PrepperPrepper Open Data Bank

CI_BRR

Summary

This dataset is a view that combines data from the “Basic Resident Register” item data extracted from the statistical quantity table of the National Census [CI_ST], the municipal statistics master [CI_ST_MST], the municipal survey master [CI_TB_MST], and the municipal master table [CI_MST]. 

This data includes such as the number of people moving into and out of the city from other cities, towns and villages.

The survey years are 2020 to 2024.
The ESTATDB_RESEARCH_ID (survey ID) for the City, Town and Village Survey Master [CI_TB_MST] is 0312024.

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_TAB01_CODECI_ST_MST
STATS_TAB01_NAMECI_ST_MST
STATS_CAT01_CODECI_ST_MST
STATS_CAT01_NAMECI_ST_MST
STATS_CAT02_CODECI_ST_MST
STATS_CAT02_NAMECI_ST_MST
STATS_CAT03_CODECI_ST_MST
STATS_CAT03_NAMECI_ST_MST
ESTATDB_TABLE_NAMECI_TB_MST
PREF_CODECI_MST
PREF_NAMECI_MST
CITY_NAMECI_MST

References

The data is prepared by Truestar, based on the following data.
Basic Resident Register–Based Internal Migration Report

https://www.e-stat.go.jp/stat-search/database?page=1&layout=datalist&toukei=00200523&tstat=000000070001&cycle=7&year=0&tclass1=000001219441&tclass2val=0

Special Notes

IsIssue:

There are records in which ESTATDB_statistical names [ESTATDB_STATS_FULL_NAME] are the same, but the statistics [STATS_VALUE] are different.

Reason for difference:

This is due to the difference in ESTATDB_table names [ESTATDB_TABLE_NAME].

Details:

  • This is an example of table number 3-3 and table number 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 case:

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].