言語：
英語
プロダクト種別：
データ
親プロダクト：
JAPANESE PREFECTURE DATA(日本の都道府県データ)
This dataset is a view that combines data from the “Population Movement Aggregation” item of the national census (2020 edition) extracted from the statistical quantity table [PR_ST] of the National Statistics Survey, with the prefecture statistics master [PR_ST_MST], prefectural survey master [PR_TB_MST], and prefecture master table [PR_MST].
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
E_NAME |
|---|
ESTATDB_STATS_FULL_ID |
PREF_CODE |
STATS_YEAR |
STATS_VALUE |
STATS_UNIT |
ESTATDB_STATS_FULL_NAME |
ESTATDB_RESEARCH_TABLE_ID |
STATS_TAB01_CODE |
STATS_TAB01_NAME |
STATS_CAT01_CODE |
STATS_CAT01_NAME |
STATS_CAT02_CODE |
STATS_CAT02_NAME |
STATS_CAT03_CODE |
STATS_CAT03_NAME |
STATS_CAT04_CODE |
STATS_CAT04_NAME |
ESTATDB_TABLE_NAME |
PREF_NAME |
Issue:
There are records where ESTATDB_statistical_name [ESTATDB_STATS_FULL_NAME] is the same, but the statistical values [STATS_VALUE] are different.
Reason for Difference:
This is because the ESTATDB table names [ESTATDB_TABLE_NAME] are different.
Details:
Examples are from table numbers 3-3 and 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 situation applies to this view.
Example:
Although ESTATDB_Statistic_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 Number 3-3 includes the total population, including those under 15 years old, while Table Number 4-3-1 includes the total population of those 15 years old and above.
Note:
In this case, if you specify only ESTATDB_Statistic_Name [ESTATDB_STATS_FULL_NAME] to obtain statistical values, it will result in the sum of statistics from two tables.
Solution:
When specifying ESTATDB_Statistic_Name [ESTATDB_STATS_FULL_NAME] to obtain statistical values, please also specify ESTATDB_Statistic_Code [ESTATDB_STATS_FULL_ID] or ESTATDB_Table_Name [ESTATDB_TABLE_NAME].