Summary
This dataset is a view that combines data from the “Housing and Land Survey (2018 / 2023 edition) Additional Aggregation” item data extracted from the statistical quantity table [PR_ST] of the All Statistics Survey, the prefectural statistics master [PR_ST_MST], the prefectural survey master [PR_TB_MST], and the prefectural master table [PR_MST].
- 2023
- 2018
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 | REFERENCE TABLE |
|---|---|
| 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 |
| ESTATDB_TABLE_NAME | PR_TB_MST |
| PREF_NAME | PR_MST |
Special Notes
Issue:
There are records where the ESTATDB statistic full name [ESTATDB_STATS_FULL_NAME] is the same, but the statistic value [STATS_VALUE] is different.
Reason for difference:
This is because the ESTATDB table name [ESTATDB_TABLE_NAME] is different.
Details:
- This is an example for tables 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 phenomenon is the same in this view.
Example:
Although the ESTATDB_Statistical_Name [ESTATDB_STATS_FULL_NAME] is the same, the statistical values such as [STATS_VALUE] are different.
The reason for the difference in statistical values is because table 3-3 includes the total population, including those under 15 years old, while table 4-3-1 includes the total population of those 15 years old and over.
Note:
In this case, if you only specify ESTATDB_Statistical_Name [ESTATDB_STATS_FULL_NAME], the result will be the sum of the statistics from two tables.
Solution:
When specifying ESTATDB_Statistical_Name [ESTATDB_STATS_FULL_NAME] to output the statistical value, please also specify ESTATDB_Statistical_Code [ESTATDB_STATS_FULL_ID] and ESTATDB_Table_Name [ESTATDB_TABLE_NAME] together.