Queria
DatasetsShowcaseAI chatArea analysis
⌘K
All datasets内閣府
計画・通知等6
四半期別GDP速報4
県民経済計算4
  • 県民経済計算
  • 元のファイル
  • stg_observations
  • stg_pref_accounts_source_file
景気ウォッチャー調査6
About QueriaPricingGeocoderCompany ResolverTerms of ServicePrivacy PolicyCommercial TransactionsContactCommunity (Discord)

© 2026 FLOPS

cao/pref_accounts/stg_observations

Description

No description

Columns

No columns

Type
View
License
  • 公共データ利用規約(第1.0版)
Original data
https://rssystem.go.jp

SQL definition

SELECT "release", table_kind, CAST(table_number AS INTEGER) AS table_number, table_title, "nullif"(item, '') AS item, CAST(item_level AS INTEGER) AS item_level, area_type, area_name, "nullif"(prefecture_code, '') AS prefecture_code, "nullif"(city_code, '') AS city_code, CAST(fiscal_year AS INTEGER) AS fiscal_year, CAST("value" AS "DOUBLE") AS "value", "nullif"(unit, '') AS unit, source_sha256, source_sheet, CAST(source_row AS INTEGER) AS source_row FROM {DUCKLAKE_CATALOG}.pref_accounts.raw_observations
Tables20LineageHistoryIssuesChange requests
queria/cao内閣府
Star0