Queria
DatasetsShowcaseAI chatArea analysis
⌘K
All datasets国立社会保障・人口問題研究所 将来推計人口
地域別将来推計人口4
  • 市区町村別 男女・5歳階級別 将来推計人口
  • 元のファイル
  • stg_population
  • stg_source_file
About QueriaPricingGeocoderCompany ResolverTerms of ServicePrivacy PolicyCommercial TransactionsContactCommunity (Discord)

© 2026 FLOPS

ipss/regional_projection/stg_population

Description

No description

Columns

No columns

Type
View
License
  • 公共データ利用規約(第1.0版)
Original data
https://www.ipss.go.jp/pp-shicyoson/j/shicyoson23/t-page.asp
Source code
models/regional_projection/stg/stg_population.sql

SQL definition

select
    lpad(trim("コード"), 5, '0') as city_code,
    case trim("市などの別")
        when 'a' then 'prefecture'
        when '0' then 'ward'
        when '1' then 'designated_city'
        when '2' then 'city'
        when '3' then 'town_village'
        when '9' then 'region'
    end as area_level,
    trim("都道府県") as prefecture,
    nullif(trim("市区町村"), '') as city_and_county,
    cast(regexp_extract(trim("年"), '^([0-9]{4})年$', 1) as integer) as year,
    cast(columns('^(総数|男|女)/') as integer),
    source_sha256,
    source_sheet,
    cast(source_row as integer) as source_row
from "ipss"."regional_projection"."raw_population"
Tables4DocumentsReports4LineageHistoryIssuesChange requests
queria/ipss国立社会保障・人口問題研究所 将来推計人口
Star1