Summary
This dataset is a view created by extracting the “Housing and Land Survey – Tabulation on Housing Structure and Related Items” from the statistical table CI_ST of the National Statistical Survey, and combining it with the Municipality Statistical Master (CI_ST_MST), the Municipality Survey Master (CI_TB_MST), and the Municipality Master Table (CI_MST).
It contains data on building characteristics such as structure, construction method, and construction period.
- 2023
- 2018
The survey year is 2023.
In the Municipality Survey Master (CI_TB_MST), the ESTATDB_RESEARCH_ID (Survey ID) is 0622023.
The survey year is 2018.
In the Municipality Survey Master (CI_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 for sample data from Japanese City Data
Data Fields
| E_NAME | REFERENCE TABLE |
|---|---|
| ESTATDB_STATS_FULL_ID | CI_ST |
| CITY_CODE | CI_ST |
| STATS_YEAR | CI_ST |
| STATS_VALUE | CI_ST |
| STATS_UNIT | CI_ST |
| ESTATDB_STATS_FULL_NAME | CI_ST_MST |
| ESTATDB_RESEARCH_TABLE_ID | CI_ST_MST |
| STATS_TAB01_CODE | CI_ST_MST |
| STATS_TAB01_NAME | CI_ST_MST |
| STATS_CAT01_CODE | CI_ST_MST |
| STATS_CAT01_NAME | CI_ST_MST |
| STATS_CAT02_CODE | CI_ST_MST |
| STATS_CAT02_NAME | CI_ST_MST |
| STATS_CAT03_CODE | CI_ST_MST |
| STATS_CAT03_NAME | CI_ST_MST |
| STATS_CAT04_CODE | CI_ST_MST |
| STATS_CAT04_NAME | CI_ST_MST |
| STATS_CAT05_CODE | CI_ST_MST |
| STATS_CAT05_NAME | CI_ST_MST |
| ESTATDB_TABLE_NAME | CI_TB_MST |
| PREF_CODE | CI_MST |
| PREF_NAME | CI_MST |
| CITY_NAME | CI_MST |
Special Notes
Issue:
There are records where ESTATDB_statistic 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 for tables 3-3 and 4-3-1.
| ESTATDB_STATS_FULL_ID | ESTATDB_STATS_FULL_NAME | STATS_VALUE | CITY_NAME | ESTATDB_TABLE_NAME |
| 0112020009|202001|0|0|00|0 | 人口|国籍総数|総数|総数|総数 | 1,973,395 | 札幌市 | 3-3男女，年齢（5歳階級），出生の月，国籍総数か日本人別人口－全国，都道府県，市区町村 |
| 0112020010|202001|0|0|0|00 | 人口|国籍総数|総数|総数|総数 | 1,726,966 | 札幌市 | 4-3-1男女，年齢（5歳階級），配偶関係，国籍総数か日本人別人口（15歳以上）－全国，都道府県，市区町村 |
※This is an example from another view, but the same issue occurs in this view.
Example case:
The statistics values, such as STATS_VALUE, are different despite the ESTATDB_STAT_FULL_NAME being the same.
The reason for the difference in statistics values is because 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 over 15 years old.
Note:
If only ESTATDB_STAT_FULL_NAME is specified to calculate the statistics value, it will result in the sum of the statistics value from two tables.
Solution:
When specifying ESTATDB_STAT_FULL_NAME to calculate the statistics value, please also specify ESTATDB_STAT_FULL_ID or ESTATDB_TABLE_NAME.