27:I[679388,["/_next/static/chunks/2g4wkl7ov9obw.js","/_next/static/chunks/30t3--dunhppr.js","/_next/static/chunks/21b79te3r-4i8.js","/_next/static/chunks/0ja18810ehkot.js","/_next/static/chunks/25rbd1ut3eby1.js","/_next/static/chunks/0tbucj9cueegr.js","/_next/static/chunks/34z0muw1j4dmi.js","/_next/static/chunks/314-2k8nno9iw.js","/_next/static/chunks/3yfebnre3d-2i.js","/_next/static/chunks/1bfd7cpb9_90u.js","/_next/static/chunks/1ygyf8ghf73g7.js","/_next/static/chunks/2tztxkdrj08mf.js","/_next/static/chunks/383p8t6j9hs4u.js","/_next/static/chunks/1sx1ky2zphjkm.js","/_next/static/chunks/2x1l07mftfd76.js","/_next/static/chunks/29uh7csbwty_7.js","/_next/static/chunks/2us_v9jepdss3.js","/_next/static/chunks/260qvhr80yvjs.js","/_next/static/chunks/0qr-8v4-7c52h.js"],"RecentViewTracker"] 29:I[574173,["/_next/static/chunks/2g4wkl7ov9obw.js","/_next/static/chunks/30t3--dunhppr.js","/_next/static/chunks/21b79te3r-4i8.js","/_next/static/chunks/0ja18810ehkot.js","/_next/static/chunks/25rbd1ut3eby1.js","/_next/static/chunks/0tbucj9cueegr.js","/_next/static/chunks/34z0muw1j4dmi.js","/_next/static/chunks/314-2k8nno9iw.js","/_next/static/chunks/3yfebnre3d-2i.js","/_next/static/chunks/1bfd7cpb9_90u.js","/_next/static/chunks/1ygyf8ghf73g7.js","/_next/static/chunks/2tztxkdrj08mf.js","/_next/static/chunks/383p8t6j9hs4u.js","/_next/static/chunks/1sx1ky2zphjkm.js","/_next/static/chunks/2x1l07mftfd76.js","/_next/static/chunks/29uh7csbwty_7.js","/_next/static/chunks/2us_v9jepdss3.js","/_next/static/chunks/260qvhr80yvjs.js","/_next/static/chunks/0qr-8v4-7c52h.js"],"DatasetTabs"] 2a:I[695887,["/_next/static/chunks/2g4wkl7ov9obw.js","/_next/static/chunks/30t3--dunhppr.js","/_next/static/chunks/21b79te3r-4i8.js","/_next/static/chunks/0ja18810ehkot.js","/_next/static/chunks/25rbd1ut3eby1.js","/_next/static/chunks/0tbucj9cueegr.js","/_next/static/chunks/34z0muw1j4dmi.js","/_next/static/chunks/314-2k8nno9iw.js","/_next/static/chunks/3yfebnre3d-2i.js","/_next/static/chunks/1bfd7cpb9_90u.js","/_next/static/chunks/1ygyf8ghf73g7.js","/_next/static/chunks/2tztxkdrj08mf.js","/_next/static/chunks/383p8t6j9hs4u.js","/_next/static/chunks/1sx1ky2zphjkm.js","/_next/static/chunks/2x1l07mftfd76.js","/_next/static/chunks/29uh7csbwty_7.js","/_next/static/chunks/2us_v9jepdss3.js","/_next/static/chunks/260qvhr80yvjs.js","/_next/static/chunks/0qr-8v4-7c52h.js"],"DatabasePageClient"] 2b:Taed,{{ config(materialized='view') }} with date_spine as ( select unnest(generate_series(DATE '1955-01-01', DATE '2027-12-31', INTERVAL 1 DAY))::DATE as date ), holidays as ( select date, holiday_name from {{ ref('raw_holidays') }} ), joined as ( select d.date, h.holiday_name as raw_holiday_name from date_spine d left join holidays h on d.date = h.date ) select date, -- 年月日 year(date)::INTEGER as year, month(date)::INTEGER as month, day(date)::INTEGER as day, -- 曜日 isodow(date)::INTEGER as weekday_code, case isodow(date)::INTEGER when 1 then '月曜日' when 2 then '火曜日' when 3 then '水曜日' when 4 then '木曜日' when 5 then '金曜日' when 6 then '土曜日' when 7 then '日曜日' end as weekday, -- 祝日・振替休日 raw_holiday_name is not null and raw_holiday_name != '休日' as is_holiday, case when raw_holiday_name is not null and raw_holiday_name != '休日' then raw_holiday_name end as holiday_name, raw_holiday_name = '休日' as is_substitute_holiday, -- 曜日フラグ isodow(date) = 6 as is_sat, isodow(date) = 7 as is_sun, isodow(date) >= 6 as is_sat_sun, isodow(date) >= 6 or raw_holiday_name is not null as is_sat_sun_holiday, isodow(date) < 6 and raw_holiday_name is null as is_weekday, -- 会計年度 (case when month(date) >= 4 then year(date) else year(date) - 1 end)::INTEGER as fiscal_year, (case when month(date) in (4, 5, 6) then 1 when month(date) in (7, 8, 9) then 2 when month(date) in (10, 11, 12) then 3 else 4 end)::INTEGER as fiscal_quarter, -- 和暦 case when date < DATE '1912-07-30' then '明治' when date < DATE '1926-12-25' then '大正' when date < DATE '1989-01-08' then '昭和' when date < DATE '2019-05-01' then '平成' else '令和' end as wareki_era, (case when date < DATE '1912-07-30' then year(date) - 1867 when date < DATE '1926-12-25' then year(date) - 1911 when date < DATE '1989-01-08' then year(date) - 1925 when date < DATE '2019-05-01' then year(date) - 1988 else year(date) - 2018 end)::INTEGER as wareki_year, case when date < DATE '1912-07-30' then '明治' || (year(date) - 1867) || '年' when date < DATE '1926-12-25' then '大正' || (year(date) - 1911) || '年' when date < DATE '1989-01-08' then '昭和' || (year(date) - 1925) || '年' when date < DATE '2019-05-01' then '平成' || (year(date) - 1988) || '年' else '令和' || (year(date) - 2018) || '年' end as wareki_label from joined26:[["$","div",null,{"className":"mx-auto flex w-full max-w-6xl flex-col gap-6 px-6 py-10","children":[["$","script",null,{"type":"application/ld+json","dangerouslySetInnerHTML":{"__html":"{\"@context\":\"https://schema.org\",\"@type\":\"DataCatalog\",\"name\":\"日本の暦データ\",\"description\":\"1955年〜2027年の日付スパインに祝日・曜日・和暦・会計年度を付与した日本の暦データ\",\"url\":\"https://queria.io/datasets/queria/calendar\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Queria\",\"url\":\"https://queria.io\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://queria.io/queria-logo-transparent.png\",\"width\":\"2048\",\"height\":\"2048\"}},\"dataset\":[{\"@type\":\"Dataset\",\"name\":\"日本の暦データ\",\"description\":\"1955年から2027年までの日本の暦を1日1行で収録したマスタ。祝日名・振替休日・曜日・平日/土日の判定に加え、会計年度・四半期、和暦（元号・和暦年）を各日付に付与する。\",\"url\":\"https://queria.io/datasets/queria/calendar/main/mart_calendar\",\"license\":\"https://www.digital.go.jp/resources/open_data/government_standard_terms_of_use_ver2.0\"}]}"}}],["$","$L27",null,{"view":{"kind":"dataset","handle":"queria","name":"calendar","title":"日本の暦データ","at":0}}],"$L28",false,false,["$","$L29",null,{"handle":"queria","database":"calendar"}],["$","div",null,{"className":"flex flex-col gap-8 lg:flex-row","children":[["$","div",null,{"className":"flex min-w-0 flex-1 flex-col gap-6","children":[["$","$L2a",null,{"database":"calendar","catalog":{"handle":"queria","name":"calendar","title":"日本の暦データ","description":"1955年〜2027年の日付スパインに祝日・曜日・和暦・会計年度を付与した日本の暦データ","cover":"📅","tags":["カレンダー","祝日","和暦","日付"],"ducklake_url":"https://data.queria.io/datasets/queria/calendar/ducklake.duckdb","repository_url":"https://github.com/queria-io/dataset-calendar","schedule":"yearly","schemas":{"main":{"title":"メイン","tables":[{"unique_id":"model.calendar.main.mart_calendar","resource_type":"model","name":"mart_calendar","schema_name":"main","title":"日本の暦データ","description":"1955年から2027年までの日本の暦を1日1行で収録したマスタ。祝日名・振替休日・曜日・平日/土日の判定に加え、会計年度・四半期、和暦（元号・和暦年）を各日付に付与する。","materialized":"view","tags":["カレンダー","祝日","和暦","日付"],"licenses":[{"title":"政府標準利用規約（第2.0版）","url":"https://www.digital.go.jp/resources/open_data/government_standard_terms_of_use_ver2.0"}],"source_url":"https://www8.cao.go.jp/chosei/shukujitsu/gaiyou.html","source_code_url":"https://github.com/queria-io/dataset-calendar/blob/main/models/main/mart/mart_calendar.sql","is_published":true,"columns":[{"name":"date","title":"日付","description":"主キー (1955-01-01〜2027-12-31)","data_type":"DATE","semantic":"$undefined"},{"name":"year","title":"年","description":"","data_type":"INTEGER","semantic":"$undefined"},{"name":"month","title":"月","description":"","data_type":"INTEGER","semantic":"$undefined"},{"name":"day","title":"日","description":"","data_type":"INTEGER","semantic":"$undefined"},{"name":"weekday_code","title":"曜日コード","description":"ISO 8601: 月曜=1〜日曜=7","data_type":"INTEGER","semantic":"$undefined"},{"name":"weekday","title":"曜日","description":"月曜日〜日曜日","data_type":"VARCHAR","semantic":"$undefined"},{"name":"is_holiday","title":"祝日フラグ","description":"国民の祝日 (振替休日を含まない)","data_type":"BOOLEAN","semantic":"$undefined"},{"name":"holiday_name","title":"祝日名","description":"祝日でない場合はNULL","data_type":"VARCHAR","semantic":"$undefined"},{"name":"is_substitute_holiday","title":"振替休日フラグ","description":"","data_type":"BOOLEAN","semantic":"$undefined"},{"name":"is_sat","title":"土曜フラグ","description":"","data_type":"BOOLEAN","semantic":"$undefined"},{"name":"is_sun","title":"日曜フラグ","description":"","data_type":"BOOLEAN","semantic":"$undefined"},{"name":"is_sat_sun","title":"土日フラグ","description":"","data_type":"BOOLEAN","semantic":"$undefined"},{"name":"is_sat_sun_holiday","title":"土日祝フラグ","description":"土曜・日曜・祝日・振替休日のいずれか","data_type":"BOOLEAN","semantic":"$undefined"},{"name":"is_weekday","title":"平日フラグ","description":"土日祝でない日","data_type":"BOOLEAN","semantic":"$undefined"},{"name":"fiscal_year","title":"会計年度","description":"4月始まり (例: 2020-03-31 → 2019)","data_type":"INTEGER","semantic":"$undefined"},{"name":"fiscal_quarter","title":"会計四半期","description":"Q1=4〜6月, Q2=7〜9月, Q3=10〜12月, Q4=1〜3月","data_type":"INTEGER","semantic":"$undefined"},{"name":"wareki_era","title":"和暦元号","description":"明治/大正/昭和/平成/令和","data_type":"VARCHAR","semantic":"$undefined"},{"name":"wareki_year","title":"和暦年","description":"元号内の年数","data_type":"INTEGER","semantic":"$undefined"},{"name":"wareki_label","title":"和暦ラベル","description":"例: 令和2年","data_type":"VARCHAR","semantic":"$undefined"}],"compiled_code":"$2b","depends_on":[]},{"unique_id":"model.calendar.main.raw_holidays","resource_type":"model","name":"raw_holidays","schema_name":"main","title":"","description":"内閣府の「国民の祝日」CSVの生データ（祝日・振替休日を含む）","materialized":"table","tags":"$undefined","licenses":[{"title":"政府標準利用規約（第2.0版）","url":"https://www.digital.go.jp/resources/open_data/government_standard_terms_of_use_ver2.0"}],"source_url":"https://www8.cao.go.jp/chosei/shukujitsu/gaiyou.html","source_code_url":"https://github.com/queria-io/dataset-calendar/blob/main/models/main/raw/raw_holidays.sql","is_published":"$undefined","columns":[{"name":"date","title":"$undefined","description":"日付","data_type":"DATE","semantic":"$undefined"},{"name":"holiday_name","title":"$undefined","description":"祝日名（振替休日は「休日」と記載）","data_type":"VARCHAR","semantic":"$undefined"}],"compiled_code":"{# 内閣府祝日CSV (UTF-8 変換済み)\n 元データ: https://www8.cao.go.jp/chosei/shukujitsu/syukujitsu.csv\n main.py が Shift_JIS → UTF-8 変換して .queria/holidays.csv に保存 #}\n\n{{\n config(\n materialized='table'\n )\n}}\n\nselect *\nfrom read_csv(\n '.queria/holidays.csv',\n header=true,\n columns={\n 'date': 'DATE',\n 'holiday_name': 'VARCHAR'\n }\n)","depends_on":[]}]}}}}],false,"$L2c"]}],"$L2d"]}]]}],"$L2e"]

License

Sources