Queria
DatasetsShowcaseAI chatArea analysis
⌘K
All datasets内閣府
計画・通知等6
四半期別GDP速報4
  • 国内総生産(支出側)と各需要項目
  • 元のファイル
  • stg_gdp_expenditure
  • stg_sna_source_file
県民経済計算4
景気ウォッチャー調査6
About QueriaPricingGeocoderCompany ResolverTerms of ServicePrivacy PolicyCommercial TransactionsContactCommunity (Discord)

© 2026 FLOPS

cao/sna/stg_gdp_expenditure

Description

No description

Columns

No columns

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

SQL definition

SELECT "release", CAST(release_date AS "DATE") AS release_date, measure, adjustment, frequency, CAST("year" AS INTEGER) AS "year", CAST("quarter" AS INTEGER) AS "quarter", CASE  WHEN ((frequency = 'quarter')) THEN (make_date(CAST("year" AS INTEGER), ((CAST("quarter" AS INTEGER) * 3) - 2), 1)) WHEN ((frequency = 'fiscal_year')) THEN (make_date(CAST("year" AS INTEGER), 4, 1)) WHEN ((frequency = 'calendar_year')) THEN (make_date(CAST("year" AS INTEGER), 1, 1)) ELSE NULL END AS period_start, item, CAST(item_level AS INTEGER) AS item_level, CAST("value" AS "DOUBLE") AS "value", unit, source_sha256, CAST(source_row AS INTEGER) AS source_row FROM {DUCKLAKE_CATALOG}.sna.raw_gdp_expenditure
Tables20LineageHistoryIssuesChange requests
queria/cao内閣府
Star0