PR_TB_MST

言語:

英語

プロダクト種別:

データ

親プロダクト:

JAPANESE PREFECTURE DATA(日本の都道府県データ)

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