CI_PCS20_03

Summary

This dataset is a view that combines data from the "Moving Population Aggregation" item data in the national census (2020 edition) extracted from the statistical quantity table [CI_ST] of the All Statistics Survey with the municipal statistical quantity master [CI_ST_MST], the municipal survey master [CI_TB_MST], and the municipal master table [CI_MST].

This data includes the length of time people have lived in a particular area, the population by place of permanent residence five years ago, etc.

The survey year is 2020.
The ESTATDB_RESEARCH_ID (survey ID) for the City, Town and Village Survey Master [CI_TB_MST] is 0132020.

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

Special Notes

Issue:

There are records where ESTATDB_statistics_full_name [ESTATDB_STATS_FULL_NAME] is the same, but statistics value [STATS_VALUE] 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.

※This is an example from another view, but the same issue applies to this view.

Example:

Although ESTATDB_Statistic_full_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 the age of 15, while table 4-3-1 is the total population of those aged 15 and older.

Note:

In this case, if you specify only ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME], the total of the statistics of two tables will be output.

Solution:

When specifying ESTATDB_Statistic_full_name [ESTATDB_STATS_FULL_NAME] to output statistics, please also specify ESTATDB_Statistic_code [ESTATDB_STATS_FULL_ID] or ESTATDB_Table_name [ESTATDB_TABLE_NAME].