Summary
This dataset is a view created by extracting the item data for “Housing and Land Survey (2023 / 2018): Tabulation on Housing Structure and Related Characteristics” from the National Statistics Survey Data Table (PR_ST), and combining it with the Prefecture Statistics Master (PR_ST_MST), the Prefecture Survey Master (PR_TB_MST), and the Prefecture Master Table (PR_MST).
- 2023
- 2018
The survey year is 2023.
In the Prefecture Survey Master (PR_TB_MST), the ESTATDB_RESEARCH_ID (Survey ID) is 0622023.
The survey year is 2018.
In the Prefecture Survey Master (PR_TB_MST), the ESTATDB_RESEARCH_ID (Survey ID) is 0622018.
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 | J_NAME | テーブル参照先 |
|---|---|---|
| ESTATDB_STATS_FULL_ID | ESTATDB_統計量コード | PR_ST |
| PREF_CODE | 都道府県コード | PR_ST |
| STATS_YEAR | 調査年度 | PR_ST |
| STATS_VALUE | 統計値 | PR_ST |
| STATS_UNIT | 統計単位 | PR_ST |
| ESTATDB_STATS_FULL_NAME | ESTATDB_統計量名 | PR_ST_MST |
| ESTATDB_RESEARCH_TABLE_ID | ESTATDB_調査テーブルID | PR_ST_MST |
| STATS_TAB01_CODE | 統計量_属性_表01コード | PR_ST_MST |
| STATS_TAB01_NAME | 統計量_属性_表01名 | PR_ST_MST |
| STATS_CAT01_CODE | 統計量_属性_カテゴリ01コード | PR_ST_MST |
| STATS_CAT01_NAME | 統計量_属性_カテゴリ01名 | PR_ST_MST |
| STATS_CAT02_CODE | 統計量_属性_カテゴリ02コード | PR_ST_MST |
| STATS_CAT02_NAME | 統計量_属性_カテゴリ02名 | PR_ST_MST |
| STATS_CAT03_CODE | 統計量_属性_カテゴリ03コード | PR_ST_MST |
| STATS_CAT03_NAME | 統計量_属性_カテゴリ03名 | PR_ST_MST |
| STATS_CAT04_CODE | 統計量_属性_カテゴリ04コード | PR_ST_MST |
| STATS_CAT04_NAME | 統計量_属性_カテゴリ04名 | PR_ST_MST |
| ESTATDB_TABLE_NAME | ESTATDB_テーブル名 | PR_TB_MST |
| PREF_NAME | 都道府県名 | PR_MST |
Special Notes
Issue:
There are records where ESTATDB_statistical_names [ESTATDB_STATS_FULL_NAME] are the same but the statistics [STATS_VALUE] are different.
Reason:
This is because 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 of another view, but the same issue occurs in this view.
Example:
Although ESTATDB_Statistic Name [ESTATDB_STATS_FULL_NAME] is the same, the statistics [STATS_VALUE] are different.
The reason for the difference in statistics is that Table 3-3 includes the total population, including those under 15 years old, while Table 4-3-1 includes the total population of those aged 15 and over.
Note:
In this case, if you specify only ESTATDB_Statistic Name [ESTATDB_STATS_FULL_NAME] to output the statistics value, the sum of statistics values of two tables will be output.
Solution:
When specifying ESTATDB_Statistic Name [ESTATDB_STATS_FULL_NAME] to output the statistics value, please also specify ESTATDB_Statistic Code [ESTATDB_STATS_FULL_ID] and ESTATDB_Table Name [ESTATDB_TABLE_NAME] together.