Summary
This dataset is a view that combines the “Population Dynamics Statistics Confirmed Numbers” data from the “Population Dynamics Survey (2019)” with the statistical quantity table [PR_ST] of the National Statistics Survey, the prefecture statistical quantity master [PR_ST_MST], the prefectural survey master [PR_TB_MST], and the prefecture master table [PR_MST]. If the language cannot be detected, this text will be translated to English.
Sample Data
Please select the table you wish to view from the data dictionary in the snowflake marketplace.
Click here to view sample data from Japanese Prefecture Data
Data Fields
| E_NAME |
|---|
| ESTATDB_STATS_FULL_ID |
| PREF_CODE |
| STATS_YEAR |
| STATS_VALUE |
| STATS_UNIT |
| ESTATDB_STATS_FULL_NAME |
| ESTATDB_RESEARCH_TABLE_ID |
| STATS_CAT01_CODE |
| STATS_CAT01_NAME |
| ESTATDB_TABLE_NAME |
| PREF_NAME |
※【STATS_TAB01_CODE】and【STATS_TAB01_NAME】：None
Special Notes
Issue:
There are records where ESTATDB Statistics Full Name [ESTATDB_STATS_FULL_NAME] are the same, but the statistics value [STATS_VALUE] are different.
Reason for Difference:
This is due to the difference in ESTATDB table name [ESTATDB_TABLE_NAME].
Details:
- Examples are table number 3-3 and table number 4-3-1.
| ESTATDB_STATS_FULL_ID | ESTATDB_STATS_FULL_NAME | STATS_VALUE | PREF_NAME | ESTATDB_TABLE_NAME |
| 0112020009|202001|0|0|00|0 | 人口|国籍総数|総数|総数|総数 | 5,224,614 | 北海道 | 3-3男女，年齢（5歳階級），出生の月，国籍総数か日本人別人口－全国，都道府県，市区町村 |
| 0112020010|202001|0|0|0|00 | 人口|国籍総数|総数|総数|総数 | 4,609,750 | 北海道 | 4-3-1男女，年齢（5歳階級），配偶関係，国籍総数か日本人別人口（15歳以上）－全国，都道府県，市区町村 |
※This is an example from another view, but the same issue applies to this view.
Example:
Although ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME] is the same, the statistics such as STATS_VALUE are different.
The reason for the difference in statistics is that table 3-3 is the total population, including those under the age of 15, while table 4-3-1 is the total population of those aged 15 and older.
Note:
In this case, if you specify only ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME], the total of the statistics of two tables will be output.
Solution:
When specifying ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME] to output statistics, please also specify ESTATDB_Statistic_code [ESTATDB_STATS_FULL_ID] or ESTATDB_Table_name [ESTATDB_TABLE_NAME].