言語：
英語
プロダクト種別：
データ
親プロダクト：
JAPANESE PREFECTURE DATA(日本の都道府県データ)
This dataset is a view created by combining the “Confirmed Vital Statistics” data from the Population Dynamics Survey with the statistical table [PR_ST] from the National Statistical Survey, along with the Prefectural Statistical Master [PR_ST_MST], the Prefectural Survey Master [PR_TB_MST], and the Prefectural Master Table [PR_MST].
It contains data such as the number of births, deaths, marriages, and divorces.
The survey years covered are 2019 to 2023.
The ESTATDB_RESEARCH_ID (Survey ID) in the Prefectural Survey Master [PR_TB_MST] is 0212023.
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_CAT01_CODE | PR_ST_MST |
STATS_CAT01_NAME | PR_ST_MST |
ESTATDB_TABLE_NAME | PR_TB_MST |
PREF_NAME | PR_MST |
※[STATS_TAB01_CODE] and [STATS_TAB01_NAME] : None
The data is prepared by Truestar, based on the following data.
Population Dynamics Survey : Confirmed Vital Statistics (Overview)
https://www.e-stat.go.jp/stat-search/database?page=1&statdisp_id=0003411564
Issue:
There are records where ESTATDB_statistics_full_name [ESTATDB_STATS_FULL_NAME] is the same, but statistics value [STATS_VALUE] are 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 | 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 same issue applies to this view.
Example:
Although ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME] is the same, the statistics such as [STATS_VALUE] are different.
The reason for the difference in statistics is that table 3-3 is the total population, including those under the age of 15, while table 4-3-1 is the total population of those aged 15 and older.
Note:
In this case, if you specify only ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME], the total of the statistics of two tables will be output.
Solution:
When specifying ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME] to output statistics, please also specify ESTATDB_Statistic_code [ESTATDB_STATS_FULL_ID] or ESTATDB_Table_name [ESTATDB_TABLE_NAME].