Queria
DatasetsShowcaseAI chatArea analysis
⌘K
All datasets産業連関表
日本の産業連関表14
  • 投入係数
  • 逆行列係数
  • 部門ごとの誘発係数
  • 部門
  • 元のファイル
  • 産業連関表の一覧
  • 取引基本表
  • stg_input_coefficients
  • stg_japan_source_file
  • stg_leontief_inverse
  • stg_sector_multipliers
  • stg_sectors
  • stg_tables
  • stg_transactions
OECD 国際産業連関表(ICIO)13
About QueriaPricingGeocoderCompany ResolverTerms of ServicePrivacy PolicyCommercial TransactionsContactCommunity (Discord)

© 2026 FLOPS

io_tables/japan/stg_tables

Description

No description

Columns

No columns

Type
View
License
  • 政府標準利用規約(第2.0版)
  • OECD Terms and Conditions(データ)
Original data
https://www.soumu.go.jp/toukei_toukatsu/data/io/index.htm

SQL definition

SELECT table_id, kind, "nullif"(series, '') AS series, CAST("year" AS INTEGER) AS "year", price, CAST("nullif"(real_base_year, '') AS INTEGER) AS real_base_year, price_basis, classification, CAST("nullif"(sector_count, '') AS INTEGER) AS sector_count, concat_ws(' ', CASE  WHEN ((kind = 'national')) THEN (("year" || '年 産業連関表')) WHEN ((kind = 'extended')) THEN (((("year" || '年 延長産業連関表(') || series) || '年基準)')) ELSE (((series || '年 接続産業連関表 ') || "year") || '年') END, CASE  WHEN ((price = 'real')) THEN ((('実質(' || real_base_year) || '年価格)')) ELSE NULL END, classification, CASE  WHEN ((price_basis = 'producer')) THEN ('生産者価格評価') ELSE '購入者価格評価' END) AS title, "nullif"(source_unit, '') AS source_unit, source_url, source_sheet, source_sha256 FROM {DUCKLAKE_CATALOG}.japan.raw_tables
Tables27LineageHistoryIssuesChange requests
queria/io_tables産業連関表
Star0