CI_SES23　CI_SES22　CI_SES19

Summary

This dataset is a view that combines the item data from the "Medical Facility Survey" extracted from the statistics table of the All Statistics Survey [CI_ST], with the municipal statistics master [CI_ST_MST], the municipal survey master [CI_TB_MST], and the municipal master table [CI_MST].

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

※This field is common for 2019, 2022 and 2023 data.

References

This data is prepared by Truestar, based on the following data.
Medical Facility Survey
https://www.e-stat.go.jp/stat-search/database?tclass=000001222742&cycle=7&year=20230

Aggregated Land Data
https://www.e-stat.go.jp/stat-search/database?tclass=000001207741&cycle=0

Special Notes

Issue:

There are records where the ESTATDB statistic full name [ESTATDB_STATS_FULL_NAME] is the same, but the statistic value [STATS_VALUE] is 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 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].