宿泊旅行統計調査データをもとに、都道府県単位で従業者規模別・滞在目的別(観光目的50%未満/以上による区分)の延べ宿泊者数を国内外旅行者の区分で、2021~2024年の時系列に集計を行いデータ化したものです(188レコード)。
元の資料: 宿泊旅行統計調査
G空間情報センターのデータセット links_kankoutoukei_2025 の 01_syukuhakuryokoutoukeityousa.csv を、列名を小文字にして型を付けたテーブルです。列の説明は同じデータセットのデータ仕様書から付けています。
CREATE TABLE links.tourism_accommodation_guests ( prefecture_code VARCHAR, year BIGINT, total_guest_count BIGINT, stay_guest_count_tourism_over_50 BIGINT, stay_guest_count_tourism_under_50 BIGINT, stay_guest_count_employee_0_9 BIGINT, stay_guest_count_employee_0_9_tourism_over_50 BIGINT, stay_guest_count_employee_0_9_tourism_under_50 BIGINT, stay_guest_count_employee_10_29 BIGINT, stay_guest_count_employee_10_29_tourism_over_50 BIGINT, stay_guest_count_employee_10_29_tourism_under_50 BIGINT, stay_guest_count_employee_30_99 BIGINT, stay_guest_count_employee_30_99_tourism_over_50 BIGINT, stay_guest_count_employee_30_99_tourism_under_50 BIGINT, stay_guest_count_employee_over_100 BIGINT, stay_guest_count_employee_over_100_tourism_over_50 BIGINT, stay_guest_count_employee_over_100_tourism_under_50 BIGINT, stay_guest_count_foreign BIGINT, stay_guest_count_foreign_tourism_over_50 BIGINT, stay_guest_count_foreign_tourism_under_50 BIGINT, stay_guest_count_foreign_employee_0_9 BIGINT, stay_guest_count_foreign_employee_0_9_tourism_over_50 BIGINT, stay_guest_count_foreign_employee_0_9_tourism_under_50 BIGINT, stay_guest_count_foreign_employee_10_29 BIGINT, stay_guest_count_foreign_employee_10_29_tourism_over_50 BIGINT, stay_guest_count_foreign_employee_10_29_tourism_under_50 BIGINT, stay_guest_count_foreign_employee_30_99 BIGINT, stay_guest_count_foreign_employee_30_99_tourism_over_50 BIGINT, stay_guest_count_foreign_employee_30_99_tourism_under_50 BIGINT, stay_guest_count_foreign_employee_over_100 BIGINT, stay_guest_count_foreign_employee_over_100_tourism_over_50 BIGINT, stay_guest_count_foreign_employee_over_100_tourism_under_50 BIGINT, source_sha256 VARCHAR );