Summary
This dataset contains attribute information of the Prefecture Statistical Master Table processed by Truestar, based on the statistical data for Japan’s prefectures published on the Government Statistical e-Stat website.
Features/Usages
This dataset provides attribute information for the Prefecture Statistical Master Table. By using the ESTATDB_RESEARCH_TABLE_ID (ESTATDB_Survey Table ID) assigned by Truestar, you can easily obtain attribute information for each survey by joining it with the Prefecture Statistical Master 【PR_ST_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 |
|---|
| STATDB_RESEARCH_TABLE_ID |
| ESTATDB_RESEARCH_ID |
| ESTATDB_RESEARCH_NAME |
| ESTATDB_TABLE_ID |
| ESTATDB_TABLE_NAME |
| ESTATDB_ESTAT_URL |
| GOV_STATS_NAME |
| GOV_STATS_CODE |
| RESEARCH_OUTLINE1 |
| RESEARCH_OUTLINE2 |
| RESEARCH_NAME |
| RESEARCH_CATEGORY1 |
| RESEARCH_CATEGORY2 |
| RESEARCH_CATEGORY3 |
| RESEARCH_CATEGORY4 |
| RAW_TABLE_ID |
| RAW_TABLE_CATEGORY |
| RAW_TABLE_TITLE |
| RAW_TABLE_NAME |
| STATS_CATEGORY |
| STATS_SUBCATEGORY |
| MINISTRY_IN_CHARGE |
| SECTION_IN_CHARGE |
| GOV_STATS_URL |
| GOV_STATS_CATEGORY |
| RESEARCH_DATE |
| PUBLISH_DATETIME |
| STATS_DISPLAY_ID |
| PROVISION_CYCLE |
| AGGREGATE_AREA1 |
| AGGREGATE_AREA2 |
| AGGREGATE_AREA3 |
| TOTAL_NUMBER_OF_CELLS |
| STATS_DETAIL |
| STATS_CAT01_COLUMN_NAME |
| STATS_CAT02_COLUMN_NAME |
| STATS_CAT03_COLUMN_NAME |
| STATS_CAT04_COLUMN_NAME |
| STATS_CAT05_COLUMN_NAME |
| STATS_AREA_DETAIL |
| STATS_TIME_DETAIL |
Exploratory Visualisation
To make it easier to find the necessary items from a large number of survey datasets, we have prepared an Exploratory Visualisation. By specifying the survey name or searching with a free keyword (e.g., “population”), you can retrieve the corresponding Survey Table ID 【ESTATDB_RESEARCH_TABLE_ID】. Clicking on the URL for each table number will take you to the overview page on e-Stat.
*Click on the image above to go to the Viz.
References
2020 Census of Japan
https://www.e-stat.go.jp/stat-search/database?page=1&toukei=00200521&tstat=000001136464
Medical Facility Survey
https://www.e-stat.go.jp/stat-search/files?tclass=000001133147&cycle=7
Resident Basic Register Population Movement Report
https://www.e-stat.go.jp/stat-search/database?page=1&toukei=00200523&tstat=000000070001
2020 Industrial Statistics Survey Final Report
https://www.e-stat.go.jp/stat-search/database?tclass=000001145041&cycle=7
Vital Statistics Survey
https://www.e-stat.go.jp/stat-search/files?page=1&toukei=00450011&tstat=
000001028897&tclass1=000001053058&tclass2=000001053061
2021 and 2016 Economic Census – Activity Survey
https://www.e-stat.go.jp/stat-search/database?page=1&toukei=00200553&tstat=000001095895
Housing and Land Statistics Survey 2023/2018 Edition
https://www.e-stat.go.jp/stat-search/database?tclass=000001117398