Summary
This dataset is a view that combines data from the “Housing and Land Survey (2018 edition) Aggregated results on the structure of housing” item data extracted from the statistical table [PR_ST] of the All Statistics Survey, with the prefecture statistics master [PR_ST_MST], prefecture survey master [PR_TB_MST], and prefecture master table [PR_MST]. If the language is not clear, use 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_TAB01_CODE |
| STATS_TAB01_NAME |
| STATS_CAT01_CODE |
| STATS_CAT01_NAME |
| STATS_CAT02_CODE |
| STATS_CAT02_NAME |
| ESTATDB_TABLE_NAME |
| PREF_NAME |
Special Notes
Issue:
There are records where the ESTATDB_statistics name [ESTATDB_STATS_FULL_NAME] is the same, but the statistics 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 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.
Symptom example:
Although ESTATDB_Statistics Full Name [ESTATDB_STATS_FULL_NAME] is the same, the statistical values [STATS_VALUE] are different.
The reason for the difference in statistical values is that Table 3-3 represents the total population, including those under 15 years old, while Table 4-3-1 represents the total population of those aged 15 and above.
Note:
In this case, if you only specify ESTATDB_Statistics Full Name [ESTATDB_STATS_FULL_NAME], the resulting statistical value will be the sum of the values from two tables.
Solution:
When specifying ESTATDB_Statistics Full Name [ESTATDB_STATS_FULL_NAME] to output statistical values, please also specify ESTATDB_Statistics Code [ESTATDB_STATS_FULL_ID] and ESTATDB_Table Name [ESTATDB_TABLE_NAME].