Queria
DatasetsShowcaseAI chatArea analysis
⌘K
All datasetsアドレス・ベース・レジストリ
  • 市区町村マスタ
  • 地番マスタ
  • 都道府県マスタ
  • 住居表示 街区マスタ
  • 住居表示 住居マスタ
  • 町字マスタ
  • raw_mt_city
  • raw_mt_city_pos
  • raw_mt_pref
  • raw_mt_pref_pos
  • raw_mt_rsdtdsp_blk
  • raw_mt_rsdtdsp_blk_pos
  • raw_mt_rsdtdsp_rsdt
  • raw_mt_rsdtdsp_rsdt_pos
  • raw_mt_town
  • raw_mt_town_fullset
  • raw_mt_town_pos
  • stg_city_pos
  • stg_pref_pos
  • stg_city
  • stg_pref
  • stg_rsdtdsp_blk
  • stg_rsdtdsp_blk_pos
  • stg_rsdtdsp_rsdt
  • stg_rsdtdsp_rsdt_pos
  • stg_town
  • stg_town_fullset
  • stg_town_pos
About QueriaPricingGeocoderCompany ResolverTerms of ServicePrivacy PolicyCommercial TransactionsContactCommunity (Discord)

© 2026 FLOPS

address_br/main/stg_city

Description

No description

Columns

No columns

Type
View
License
  • アドレス・ベース・レジストリ利用規約(デジタル庁)
Original data
https://dataset.address-br.digital.go.jp/

SQL definition

SELECT lg_code, "left"(lg_code, 5) AS lg_code_5, "left"(lg_code, 2) AS pref_code, pref AS pref_name, pref_kana AS pref_name_kana, county AS county_name, city AS city_name, city_kana AS city_name_kana, ward AS ward_name, ward_kana AS ward_name_kana, (ward IS NOT NULL) AS is_designated_city_ward, efct_date FROM {DUCKLAKE_CATALOG}.main.raw_mt_city WHERE (lg_code IS NOT NULL)
Tables28Reports1LineageHistoryIssuesChange requests
queria/address_brアドレス・ベース・レジストリ
Star0