言語：
英語
プロダクト種別：
データ
親プロダクト：
JAPANESE PREFECTURE DATA(日本の都道府県データ)
This dataset is a view that combines data from the “Basic Resident Register” item data extracted from the statistical quantity table of the National Census [PR_ST], the municipal statistics master [PR_ST_MST], the municipal survey master [PR_TB_MST], and the municipal master table [PR_MST].
This data includes such as the number of people moving into and out of the city from other cities, towns and villages.
The survey years are 2020 to 2024.
The ESTATDB_RESEARCH_ID (survey ID) for the City, Town and Village Survey Master [PR_TB_MST] is 0312024.
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 | TABLE REFERENCE |
|---|---|
ESTATDB_STATS_FULL_ID | PR_ST |
CITY_CODE | PR_ST |
STATS_YEAR | PR_ST |
STATS_VALUE | PR_ST |
STATS_UNIT | PR_ST |
ESTATDB_STATS_FULL_NAME | PR_ST_MST |
ESTATDB_RESEARCH_TABLE_ID | PR_ST_MST |
STATS_TAB01_CODE | PR_ST_MST |
STATS_TAB01_NAME | PR_ST_MST |
STATS_CAT01_CODE | PR_ST_MST |
STATS_CAT01_NAME | PR_ST_MST |
STATS_CAT02_CODE | PR_ST_MST |
STATS_CAT02_NAME | PR_ST_MST |
STATS_CAT03_CODE | PR_ST_MST |
STATS_CAT03_NAME | PR_ST_MST |
ESTATDB_TABLE_NAME | PR_TB_MST |
PREF_NAME | PR_MST |
The data is prepared by Truestar, based on the following data.
Basic Resident Register–Based Internal Migration Report
Issue:
There are records in which ESTATDB_statistical names [ESTATDB_STATS_FULL_NAME] are the same, but the statistics [STATS_VALUE] are different.
Reason for difference:
This is due to the difference in ESTATDB_table names [ESTATDB_TABLE_NAME].
Details:
This is an example of 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 issue is the same in this view.
Example case:
Although the statistical name [ESTATDB_Stats_Full_Name] is the same, the statistics value [STATS_VALUE] is different.
The reason for the difference in statistics values 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_Stats_Full_Name] to output the statistics value, it will be the sum of the statistics values of two tables.
Solution:
When specifying [ESTATDB_Stats_Full_Name] to output the statistics value, please also specify [ESTATDB_Stats_Full_Id] and [ESTATDB_Table_Name].