Summary
This dataset is a view that combines item data from the “Industrial Statistics Survey (2020 Final Report)” extracted from the statistics table “PR_ST” of the National Statistical Survey, with the prefectural statistics master table “PR_ST_MST”, the prefectural survey master table “PR_TB_MST”, and the prefectural master table “PR_MST”.
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 |
|---|
| ESTATDB_STATS_FULL_ID |
| PREF_CODE |
| STATS_YEAR |
| STATS_VALUE |
| STATS_UNIT |
| ESTATDB_STATS_FULL_NAME |
| ESTATDB_RESEARCH_TABLE_ID |
| STATS_CAT01_CODE |
| STATS_CAT01_NAME |
| STATS_CAT02_CODE |
| STATS_CAT02_NAME |
| ESTATDB_TABLE_NAME |
| PREF_NAME |
※【STATS_TAB01_CODE】and【STATS_TAB01_NAME】：None
Special Notes
Issue:
There are records with the same ESTATDB statistical name (ESTATDB_STATS_FULL_NAME), but different statistics (STATS_VALUE).
Reason for Difference:
The ESTATDB table name (ESTATDB_TABLE_NAME) is different.
Details:
This is an example of 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 situation is the same in this view.
Example:
Although ESTATDB_Statistical_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 15 years old, while Table 4-3-1 is the total population of those 15 years old and over.
Note:
In this case, if you specify only ESTATDB_Statistical_Name [ESTATDB_STATS_FULL_NAME], the sum of statistics for two tables will be output.
Solution:
When specifying ESTATDB_Statistical_Name [ESTATDB_STATS_FULL_NAME] to output statistics, please also specify ESTATDB_Statistical_Code [ESTATDB_STATS_FULL_ID] and ESTATDB_Table_Name [ESTATDB_TABLE_NAME].