町丁目ごとのよく使う指標を 1 行に並べた表です。1 行が国勢調査の小地域(町丁目)1 つです。
CREATE TABLE profile.small_area ( key_code VARCHAR, prefecture_code VARCHAR, city_code VARCHAR, city_name VARCHAR, area_name VARCHAR, area_km2 DOUBLE, population INTEGER, households INTEGER, population_density BIGINT, population_under_15 BIGINT, population_15_64 BIGINT, population_65_over BIGINT, population_75_over BIGINT, aged_65_over_rate DOUBLE, facility_count BIGINT, food_count BIGINT, grocery_count BIGINT, shopping_count BIGINT, medical_count BIGINT, education_count BIGINT, nearest_station_name VARCHAR, nearest_station_distance_m INTEGER, nearest_station_passenger_count HUGEINT, station_passenger_year INTEGER, residential_price_year BIGINT, residential_price_median BIGINT, commercial_price_year BIGINT, commercial_price_median BIGINT );