PrepperPrepper Open Data Bank

CI_VS

Summary

This dataset is a compiled view that extracts the “Confirmed Vital Statistics” from the National Statistical Survey’s Statistical Table [CI_ST] and links it with the Municipality Statistical Master [CI_ST_MST], the Municipality Survey Master [CI_TB_MST], and the Municipality Master Table [CI_MST].
It includes key demographic indicators 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 Municipality Survey Master [CI_TB_MST] is 0212023.

Sample Data

Please select the table you wish to view from the data dictionary in the snowflake marketplace.

Click here for sample data from Japanese City Data

Data Fields

E_NAME TABLE REFERENCE
ESTATDB_STATS_FULL_IDCI_ST
CITY_CODECI_ST
STATS_YEARCI_ST
STATS_VALUECI_ST
STATS_UNITCI_ST
ESTATDB_STATS_FULL_NAMECI_ST_MST
ESTATDB_RESEARCH_TABLE_IDCI_ST_MST
STATS_CAT01_CODECI_ST_MST
STATS_CAT01_NAMECI_ST_MST
ESTATDB_TABLE_NAMECI_TB_MST
PREF_CODECI_MST
PREF_NAMECI_MST
CITY_NAMECI_MST
※[STATS_TAB01_CODE] and [STATS_TAB01_NAME] : None

References

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

Special Notes

Issue:

There are records where ESTATDB_statistics_full_name [ESTATDB_STATS_FULL_NAME] is the same, but statistics value [STATS_VALUE], etc. 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_IDESTATDB_STATS_FULL_NAMESTATS_VALUECITY_NAMEESTATDB_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 another view, but the same issue occurs in this view.

Example:

The statistics values, such as [STATS_VALUE], are different despite the [ESTATDB_STAT_FULL_NAME] being the same.

The reason for the difference in statistics values is because Table Number 3-3 includes the total population, including those under 15 years old, while Table Number 4-3-1 includes the total population of those over 15 years old.

Note:

If only [ESTATDB_STAT_FULL_NAME] is specified to calculate the statistics value, it will result in the sum of the statistics value from two tables.

Solution:

When specifying [ESTATDB_STAT_FULL_NAME] to calculate the statistics value, please also specify [ESTATDB_STAT_FULL_ID] or [ESTATDB_TABLE_NAME].