言語：
英語
プロダクト種別：
データ
親プロダクト：
JAPANESE PREFECTURE DATA(日本の都道府県データ)
This dataset is a view that combines the item data of the “Medical Facility Survey” from the statistical quantity table [PR_ST] of the All-Japan Statistical Survey, with the prefecture statistical quantity master [PR_ST_MST], the prefectural survey master [PR_TB_MST], and the prefecture master table [PR_MST].
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
E_NAME | TABLE REFERENCE |
|---|---|
ESTATDB_STATS_FULL_ID | PR_ST |
PREF_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 |
ESTATDB_TABLE_NAME | PR_TB_MST |
PREF_NAME | PR_MST |
※ This field is common for 2019, 2022 and 2023 data.
The 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
Issue:
There are records where ESTATDB_statistical_name [ESTATDB_STATS_FULL_NAME] is the same but the statistics value [STATS_VALUE] is different.
Reason for difference:
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 | 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 other views, but the situation is the same in this view.
Example case:
Although ESTATDB_Statistics_Full_Name [ESTATDB_STATS_FULL_NAME] is the same, the statistics value [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 15 years old and older.
Note:
In this case, if you only specify ESTATDB_Statistics_Full_Name [ESTATDB_STATS_FULL_NAME] to output the statistics value, it will be the sum of statistics values from two tables.
Solution:
When specifying ESTATDB_Statistics_Full_Name [ESTATDB_STATS_FULL_NAME] to output the statistics value, please specify ESTATDB_Statistics_Code [ESTATDB_STATS_FULL_ID] and ESTATDB_Table_Name [ESTATDB_TABLE_NAME] together.