自治体情報 CSV インポート自治体情報 CSV インポート
CSV は更新 + 新規作成に対応（prefecture_id をキーに prefectures_info に UPSERT）します。
空欄セルは変更しない扱いです。削除は (null) を指定してください。
【採用試験倍率】年度1（y1=R8）〜年度5（y5=R4）の5年分を入力できます。
・exam_rate_year_y1〜y5: 年度（西暦、例: 2025/2024/2023/2022/2021）
・exam_rate_source_url_y1〜y5: 出典URL（文科省PDF等）
・exam_competition_rate_*_y1〜y5: 校種別倍率（小学校/中学校/高校/特別支援/養護教諭/栄養教諭/全体）
・exam_rate_merged_elem_junior_y1〜y5: 小中合算フラグ（true/false）
・exam_rate_merged_junior_high_y1〜y5: 中高合算フラグ（true/false）
・exam_rate_merged_elem_junior_high_y1〜y5: 小中高合算フラグ（true/false）
・exam_rate_merged_partner_y1〜y5: 合算相手自治体名
【教科別倍率（JSONB）】
・exam_subject_rates_junior_high_y1〜y5: 中学校の教科別倍率（JSON）
・exam_subject_rates_high_y1〜y5: 高校の教科別倍率（JSON）
・JSON形式: {"国語":3.5,"数学":2.1,"_notes":["但し書き1","但し書き2"]}
・キー=教科名、値=倍率。_notesキーに但し書き配列を格納可能
prefecture_type は「都道府県」「政令指定都市」「その他」のいずれかを指定してください。
prefecture_id,prefecture_name,prefecture_type,avg_annual_salary,initial_salary,salary_table_url,remote_area_allowance,student_loan_support,exam_info_url,exam_rate_year_y1,exam_rate_source_url_y1,exam_competition_rate_elementary_y1,exam_competition_rate_junior_high_y1,exam_competition_rate_high_y1,exam_competition_rate_special_y1,exam_competition_rate_nursing_y1,exam_competition_rate_nutrition_y1,exam_competition_rate_overall_y1,exam_rate_merged_elem_junior_y1,exam_rate_merged_junior_high_y1,exam_rate_merged_elem_junior_high_y1,exam_rate_merged_partner_y1,exam_subject_rates_junior_high_y1,exam_subject_rates_high_y1,exam_rate_year_y2,exam_rate_source_url_y2,exam_competition_rate_elementary_y2,exam_competition_rate_junior_high_y2,exam_competition_rate_high_y2,exam_competition_rate_special_y2,exam_competition_rate_nursing_y2,exam_competition_rate_nutrition_y2,exam_competition_rate_overall_y2,exam_rate_merged_elem_junior_y2,exam_rate_merged_junior_high_y2,exam_rate_merged_elem_junior_high_y2,exam_rate_merged_partner_y2,exam_subject_rates_junior_high_y2,exam_subject_rates_high_y2,exam_rate_year_y3,exam_rate_source_url_y3,exam_competition_rate_elementary_y3,exam_competition_rate_junior_high_y3,exam_competition_rate_high_y3,exam_competition_rate_special_y3,exam_competition_rate_nursing_y3,exam_competition_rate_nutrition_y3,exam_competition_rate_overall_y3,exam_rate_merged_elem_junior_y3,exam_rate_merged_junior_high_y3,exam_rate_merged_elem_junior_high_y3,exam_rate_merged_partner_y3,exam_subject_rates_junior_high_y3,exam_subject_rates_high_y3,exam_rate_year_y4,exam_rate_source_url_y4,exam_competition_rate_elementary_y4,exam_competition_rate_junior_high_y4,exam_competition_rate_high_y4,exam_competition_rate_special_y4,exam_competition_rate_nursing_y4,exam_competition_rate_nutrition_y4,exam_competition_rate_overall_y4,exam_rate_merged_elem_junior_y4,exam_rate_merged_junior_high_y4,exam_rate_merged_elem_junior_high_y4,exam_rate_merged_partner_y4,exam_subject_rates_junior_high_y4,exam_subject_rates_high_y4,exam_rate_year_y5,exam_rate_source_url_y5,exam_competition_rate_elementary_y5,exam_competition_rate_junior_high_y5,exam_competition_rate_high_y5,exam_competition_rate_special_y5,exam_competition_rate_nursing_y5,exam_competition_rate_nutrition_y5,exam_competition_rate_overall_y5,exam_rate_merged_elem_junior_y5,exam_rate_merged_junior_high_y5,exam_rate_merged_elem_junior_high_y5,exam_rate_merged_partner_y5,exam_subject_rates_junior_high_y5,exam_subject_rates_high_y5,transfer_rules,avg_age,avg_tenure,teacher_quota_elementary,teacher_quota_junior_high,teacher_quota_high,teacher_quota_special,teacher_vacancy_elementary,teacher_vacancy_junior_high,teacher_vacancy_high,teacher_vacancy_special,temp_teacher_ratio_elementary,temp_teacher_ratio_junior_high,temp_teacher_ratio_high,temp_teacher_ratio_special,homeroom_temp_ratio_elementary,homeroom_temp_ratio_elementary_special_class,homeroom_temp_ratio_junior_high,homeroom_temp_ratio_junior_high_special_class,teacher_shortage_elementary,teacher_shortage_junior_high,teacher_shortage_high,teacher_shortage_special,teacher_shortage_rate_elementary,teacher_shortage_rate_junior_high,teacher_shortage_rate_high,teacher_shortage_rate_special,school_shortage_ratio_elementary,school_shortage_ratio_junior_high,school_shortage_ratio_high,school_shortage_ratio_special,sick_leave_count,mental_illness_leave_count,disciplinary_count,work_reform_status,avg_monthly_overtime,flexible_work_system,summer_closure_days,answering_machine_rate,club_activity_guidelines_url,one_to_one_device_status,wireless_lan_rate,large_display_rate,integrated_school_admin_system_rate,ict_ability_a,ict_ability_b,ict_ability_c,ict_ability_d,school_ict_survey_url,truancy_trend,bullying_trend,japanese_support_students,harassment_consultation_url,education_board_consultation_url
131000,東京都,都道府県,6200000,300000,https://example.com/salary-table,"{""amount"":12000}",あり,https://example.com/exam-info,2025,https://www.mext.go.jp/y1.pdf,2.0,3.6,3.8,2.0,8.2,9.9,2.9,false,false,true,,"{""国語"":3.5,""数学"":2.1,""_notes"":[""R8データ""]}","{""国語"":4.0,""数学"":3.5}",2024,https://www.mext.go.jp/y2.pdf,2.2,3.8,4.0,2.1,8.5,10.1,3.1,false,false,true,,"{""国語"":3.8,""数学"":2.5}","{""国語"":4.5,""数学"":3.8}",2023,https://www.mext.go.jp/y3.pdf,2.1,3.5,3.7,1.9,8.0,9.7,2.8,false,false,true,,"{""国語"":3.6,""数学"":2.3}","{""国語"":4.2,""数学"":3.3}",2022,https://www.mext.go.jp/y4.pdf,2.0,3.3,3.5,1.8,7.8,9.5,2.6,false,false,true,,"{""国語"":3.4,""数学"":2.1}","{""国語"":4.0,""数学"":3.1}",2021,https://www.mext.go.jp/y5.pdf,1.9,3.1,3.3,1.7,7.5,9.2,2.4,false,false,true,,"{""国語"":3.2,""数学"":1.9}","{""国語"":3.8,""数学"":2.9}",転勤ルール,42.1,13.2,1000,800,600,100,30,20,15,5,12.5,11.0,9.8,8.1,7.0,6.5,6.3,5.8,100,80,70,20,2.0,1.8,1.5,1.2,3.2,2.6,2.1,1.9,120,80,3,"{""after_school"":true}",45.2,フレックス導入,5,85.5,https://example.com/club,95.0,98.0,92.5,88.3,76.2,74.1,70.0,68.5,https://example.com/ict-survey,"{""2023"":1000}","{""2023"":500}",300,https://example.com/harassment,https://example.com/board進捗: 0 / 0