CI_PCS20_02

Summary

This dataset is a view that combines the basic employment status data from the Population Census (2020) with statistics tables from the Comprehensive Survey of Living Conditions (CI_ST), as well as the Municipality Statistics Master (CI_ST_MST), the Municipality Survey Master (CI_TB_MST), and the Municipality Master Table (CI_MST).

This data includes the population structure by industry and occupation, the population of students and preschoolers, etc.

The survey year is 2020.
The ESTATDB_RESEARCH_ID (survey ID) for the Municipalities Survey Master [CI_TB_MST] is 0122020.

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 the ESTATDB_Statistics_full_name [ESTATDB_STATS_FULL_NAME] is the same, but the statistics value [STATS_VALUE] is different.

Reason for difference:

This is because the ESTATDB_Table_name [ESTATDB_TABLE_NAME] is different.

Details:

This is the example for tables 3-3 and 4-3-1.

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

Use Case