Summary
This dataset is a view that combines the item data from the “Medical Facility Survey” extracted from the statistics table of the All Statistics Survey [CI_ST], with the municipal statistics master [CI_ST_MST], the municipal survey master [CI_TB_MST], and the municipal master table [CI_MST].
- 2023
- 2022
- 2019
The survey year is 2023.
The ESTATDB_RESEARCH_ID (Survey ID) for the Municipality Survey Master [CI_TB_MST] is 0512023.
The survey year is 2022.
The ESTATDB_RESEARCH_ID (survey ID) for the Municipalities Survey Master [CI_TB_MST] is 0512022.
The survey year is 2019.
The ESTATDB_RESEARCH_ID (survey ID) for the Municipalities Survey Master [CI_TB_MST] is 0512019.
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 | TABLE REFERENCE |
|---|---|
| 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 |
| ESTATDB_TABLE_NAME | CI_TB_MST |
| PREF_CODE | CI_MST |
| PREF_NAME | CI_MST |
| CITY_NAME | CI_MST |
References
This data is prepared by Truestar, based on the following data.
Medical Facility Survey
https://www.e-stat.go.jp/stat-search/database?tclass=000001222742&cycle=7&year=20230
Aggregated Land Data
https://www.e-stat.go.jp/stat-search/database?tclass=000001207741&cycle=0
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 | 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].