DBに市区町村データを登録するためのSQL文。

こんにちは。

ウェブサービスを作っている時、住所の登録、エリア検索といった機能で都道府県・市区町村データを使う必要がありました。

そこで、都道府県データは、他の人が用意してくれていた連想配列のデータをコピペすることができたのですが、市区町村データについては、僕が欲しいデータがありませんでした。
＊もしかしたら、あるかもしれないんですけど、CSV、jsonやらAPI？でデータを使えるかもしれないです。

なので、もう、自分で入力するしかないということで、市区町村データを入力しましたので、ここに共有します。

上のような構造のデータセットをMySQL文にしました。
＊47都道府県分を一気に流すと、量が膨大すぎて、エラーになるので地方ごとにしましょう。
＊もし、カラム名を変えたい、構造を自分用に変更する場合、コマンド+Fとかで検索して、全部置き換えとかで変えましょう。

「北海道」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '1', '札幌市中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市白石区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市豊平区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市厚別区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市手稲区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '札幌市清田区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '函館市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '小樽市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '旭川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '室蘭市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '釧路市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '帯広市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '北見市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '夕張市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '岩見沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '網走市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '留萌市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '苫小牧市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '稚内市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '美唄市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '芦別市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '江別市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '赤平市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '士別市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '名寄市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '三笠市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '根室市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '千歳市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '滝川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '砂川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '歌志内市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '深川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '富良野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '登別市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '恵庭市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '伊達市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '北広島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '石狩市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '北斗市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '石狩郡当別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '石狩郡新篠津村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '松前郡松前町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '松前郡福島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上磯郡知内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上磯郡木古内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '亀田郡七飯町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '茅部郡鹿部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '茅部郡森町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '二海郡八雲町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '山越郡長万部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '桧山郡江差町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '桧山郡上ノ国町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '桧山郡厚沢部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '爾志郡乙部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '奥尻郡奥尻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '瀬棚郡今金町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '久遠郡せたな町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '島牧郡島牧村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '寿都郡寿都町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '寿都郡黒松内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '磯谷郡蘭越町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡ニセコ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡真狩村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡留寿都村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡喜茂別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡京極町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡倶知安町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '岩内郡共和町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '岩内郡岩内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '古宇郡泊村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '古宇郡神恵内村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '積丹郡積丹町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '古平郡古平町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '余市郡仁木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '余市郡余市町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '余市郡赤井川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '空知郡南幌町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '空知郡奈井江町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '空知郡上砂川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '夕張郡由仁町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '夕張郡長沼町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '夕張郡栗山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '樺戸郡月形町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '樺戸郡浦臼町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '樺戸郡新十津川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '雨竜郡妹背牛町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '雨竜郡秩父別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '雨竜郡雨竜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '雨竜郡北竜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '雨竜郡沼田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '雨竜郡幌加内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡鷹栖町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡東神楽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡当麻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡比布町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡愛別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡上川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡東川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡美瑛町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '空知郡上富良野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '空知郡中富良野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '空知郡南富良野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '勇払郡占冠村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡和寒町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡剣淵町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡下川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '中川郡美深町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '中川郡音威子府村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '中川郡中川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '増毛郡増毛町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '留萌郡小平町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '苫前郡苫前町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '苫前郡羽幌町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '苫前郡初山別村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '天塩郡遠別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '天塩郡天塩町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '天塩郡幌延町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '宗谷郡猿払村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '枝幸郡浜頓別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '枝幸郡中頓別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '枝幸郡枝幸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '天塩郡豊富町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '礼文郡礼文町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '利尻郡利尻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '利尻郡利尻富士町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '網走郡美幌町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '網走郡津別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '斜里郡斜里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '斜里郡清里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '斜里郡小清水町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '常呂郡訓子府町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '常呂郡置戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '常呂郡佐呂間町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別郡遠軽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別郡上湧別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別郡湧別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別郡滝上町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別郡興部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別郡西興部村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '紋別郡雄武町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '網走郡大空町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡豊浦町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '有珠郡壮瞥町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '白老郡白老町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '勇払郡厚真町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '虻田郡洞爺湖町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '勇払郡安平町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '勇払郡むかわ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '沙流郡日高町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '沙流郡平取町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '新冠郡新冠町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '浦河郡浦河町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '様似郡様似町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '幌泉郡えりも町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '日高郡新ひだか町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '河東郡音更町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '河東郡士幌町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '河東郡上士幌町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '河東郡鹿追町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡新得町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '上川郡清水町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '河西郡芽室町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '河西郡中札内村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '河西郡更別村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '広尾郡大樹町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '広尾郡広尾町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '中川郡幕別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '中川郡池田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '中川郡豊頃町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '中川郡本別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '足寄郡足寄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '足寄郡陸別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '十勝郡浦幌町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '釧路郡釧路町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '厚岸郡厚岸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '厚岸郡浜中町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '川上郡標茶町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '川上郡弟子屈町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '阿寒郡鶴居村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '白糠郡白糠町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '野付郡別海町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '標津郡中標津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '標津郡標津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '1', '目梨郡羅臼町', '0', '2021-05-20', CURRENT_TIMESTAMP);

「東北」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '2', '青森市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '弘前市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '八戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '黒石市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '五所川原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '十和田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '三沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', 'むつ市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', 'つがる市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '平川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '東津軽郡平内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '東津軽郡今別町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '東津軽郡蓬田村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '西津軽郡鯵ヶ沢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '西津軽郡深浦町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '中津軽郡西目屋村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '南津軽郡藤崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '南津軽郡大鰐町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '南津軽郡田舎館村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '北津軽郡板柳町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '北津軽郡鶴田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '北津軽郡中泊町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '上北郡野辺地町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '上北郡七戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '上北郡六戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '上北郡横浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '上北郡東北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '上北郡六ヶ所村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '上北郡おいらせ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '下北郡大間町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '下北郡東通村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '下北郡風間浦村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '下北郡佐井村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '三戸郡三戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '三戸郡五戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '三戸郡田子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '三戸郡南部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '三戸郡階上町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '2', '三戸郡新郷村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '盛岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '宮古市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '大船渡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '花巻市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '北上市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '久慈市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '遠野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '一関市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '陸前高田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '釜石市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '二戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '八幡平市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '奥州市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '岩手郡雫石町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '岩手郡葛巻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '岩手郡岩手町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '岩手郡滝沢村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '紫波郡紫波町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '紫波郡矢巾町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '和賀郡西和賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '胆沢郡金ケ崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '西磐井郡平泉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '東磐井郡藤沢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '気仙郡住田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '上閉伊郡大槌町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '下閉伊郡山田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '下閉伊郡岩泉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '下閉伊郡田野畑村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '下閉伊郡普代村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '下閉伊郡川井村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '九戸郡軽米町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '九戸郡野田村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '九戸郡九戸村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '九戸郡洋野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '3', '二戸郡一戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '仙台市青葉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '仙台市宮城野区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '仙台市若林区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '仙台市太白区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '仙台市泉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '石巻市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '塩竃市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '気仙沼市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '白石市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '名取市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '角田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '多賀城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '岩沼市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '登米市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '栗原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '東松島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '大崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '刈田郡蔵王町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '刈田郡七ヶ宿町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '柴田郡大河原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '柴田郡村田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '柴田郡柴田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '柴田郡川崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '伊具郡丸森町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '亘理郡亘理町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '亘理郡山元町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '宮城郡松島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '宮城郡七ヶ浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '宮城郡利府町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '黒川郡大和町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '黒川郡大郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '黒川郡富谷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '黒川郡大衡村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '加美郡色麻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '加美郡加美町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '遠田郡涌谷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '遠田郡美里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '牡鹿郡女川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '本吉郡本吉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '4', '本吉郡南三陸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '秋田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '能代市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '横手市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '大館市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '男鹿市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '湯沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '鹿角市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '由利本荘市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '潟上市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '大仙市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '北秋田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', 'にかほ市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '仙北市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '鹿角郡小坂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '北秋田郡上小阿仁村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '山本郡藤里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '山本郡三種町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '山本郡八峰町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '南秋田郡五城目町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '南秋田郡八郎潟町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '南秋田郡井川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '仙北郡美郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '雄勝郡羽後町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '5', '雄勝郡東成瀬村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '山形市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '米沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '鶴岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '酒田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '新庄市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '寒河江市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '上山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '村山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '長井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '天童市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '東根市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '尾花沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '南陽市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '東村山郡山辺町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '東村山郡中山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '西村山郡河北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '西村山郡西川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '西村山郡朝日町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '西村山郡大江町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '北村山郡大石田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '最上郡金山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '最上郡最上町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '最上郡舟形町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '最上郡真室川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '最上郡大蔵村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '最上郡鮭川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '最上郡戸沢村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '東置賜郡高畠町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '東置賜郡川西町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '西置賜郡小国町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '西置賜郡白鷹町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '西置賜郡飯豊町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '東田川郡三川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '東田川郡庄内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '6', '飽海郡遊佐町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '福島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '会津若松市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '郡山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', 'いわき市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '白河市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '須賀川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '喜多方市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '相馬市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '二本松市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '田村市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '南相馬市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '伊達市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '本宮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '伊達郡桑折町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '伊達郡国見町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '伊達郡川俣町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '伊達郡飯野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '安達郡大玉村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '岩瀬郡鏡石町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '岩瀬郡天栄村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '南会津郡下郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '南会津郡桧枝岐村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '南会津郡只見町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '南会津郡南会津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '耶麻郡北塩原村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '耶麻郡西会津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '耶麻郡磐梯町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '耶麻郡猪苗代町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '河沼郡会津坂下町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '河沼郡湯川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '河沼郡柳津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '大沼郡三島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '大沼郡金山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '大沼郡昭和村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '大沼郡会津美里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '西白河郡西郷村町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '西白河郡泉崎村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '西白河郡中島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '西白河郡矢吹町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '東白川郡棚倉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '東白川郡矢祭町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '東白川郡塙町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '東白川郡鮫川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '石川郡石川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '石川郡玉川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '石川郡平田村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '石川郡浅川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '石川郡古殿町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '田村郡三春町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '田村郡小野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡広野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡楢葉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡富岡町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡川内村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡大熊町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡双葉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡浪江町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '双葉郡葛尾村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '相馬郡新地町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '7', '相馬郡飯舘村', '0', '2021-05-20', CURRENT_TIMESTAMP);

「関東」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '8', '水戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '日立市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '土浦市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '古河市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '石岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '結城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '龍ケ崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '下妻市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '常総市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '常陸太田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '高萩市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '北茨城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '笠間市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '取手市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '牛久市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', 'つくば市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', 'ひたちなか市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '鹿嶋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '潮来市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '守谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '常陸大宮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '那珂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '筑西市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '坂東市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '稲敷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', 'かすみがうら市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '桜川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '神栖市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '行方市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '鉾田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', 'つくばみらい市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '小美玉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '東茨城郡茨城町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '東茨城郡大洗町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '東茨城郡城里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '那珂郡東海村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '久慈郡大子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '稲敷郡美浦村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '稲敷郡阿見町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '稲敷郡河内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '結城郡八千代町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '猿島郡五霞町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '猿島郡境町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '8', '北相馬郡利根町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '宇都宮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '足利市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '栃木市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '佐野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '鹿沼市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '日光市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '小山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '真岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '大田原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '矢板市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '那須塩原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', 'さくら市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '那須烏山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '下野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '河内郡上三川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '上都賀郡西方町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '芳賀郡二宮町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '芳賀郡益子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '芳賀郡茂木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '芳賀郡市貝町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '芳賀郡芳賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '下都賀郡壬生町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '下都賀郡野木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '下都賀郡大平町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '下都賀郡藤岡町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '下都賀郡岩舟町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '下都賀郡都賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '塩谷郡塩谷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '塩谷郡高根沢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '那須郡那須町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '9', '那須郡那珂川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '前橋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '高崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '桐生市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '伊勢崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '太田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '沼田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '館林市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '渋川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '藤岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '富岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '安中市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', 'みどり市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '勢多郡富士見村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '北群馬郡榛東村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '北群馬郡吉岡町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '多野郡吉井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '多野郡上野村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '多野郡神流町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '甘楽郡下仁田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '甘楽郡南牧村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '甘楽郡甘楽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '吾妻郡中之条町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '吾妻郡長野原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '吾妻郡嬬恋村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '吾妻郡草津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '吾妻郡六合村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '吾妻郡高山村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '吾妻郡東吾妻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '利根郡片品村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '利根郡川場村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '利根郡昭和村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '利根郡みなかみ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '佐波郡玉村町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '邑楽郡板倉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '邑楽郡明和町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '邑楽郡千代田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '邑楽郡大泉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '10', '邑楽郡邑楽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市大宮区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市見沼区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市桜区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市浦和区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市緑区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'さいたま市岩槻区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '川越市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '熊谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '川口市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '行田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '秩父市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '所沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '飯能市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '加須市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '本庄市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '東松山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '春日部市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '狭山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '羽生市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '鴻巣市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '深谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '上尾市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '草加市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '越谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '蕨市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '戸田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '入間市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '鳩ケ谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '朝霞市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '志木市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '和光市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '新座市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '桶川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '久喜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北本市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '八潮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '富士見市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '三郷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '蓮田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '坂戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '幸手市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '鶴ヶ島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '日高市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '吉川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', 'ふじみ野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北足立郡伊奈町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '入間郡三芳町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '入間郡毛呂山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '入間郡越生町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '比企郡嵐山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '比企郡小川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '比企郡川島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '比企郡吉見町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '比企郡鳩山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '比企郡ときがわ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '秩父郡横瀬町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '秩父郡皆野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '秩父郡長瀞町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '秩父郡小鹿野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '秩父郡東秩父村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '児玉郡美里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '児玉郡神川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '児玉郡上里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '大里郡寄居町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北埼玉郡騎西町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北埼玉郡北川辺町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北埼玉郡大利根町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '南埼玉郡宮代町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '南埼玉郡白岡町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '南埼玉郡菖蒲町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北葛飾郡栗橋町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北葛飾郡鷲宮町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北葛飾郡杉戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '11', '北葛飾郡松伏町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '千葉市中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '千葉市花見川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '千葉市稲毛区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '千葉市若葉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '千葉市緑区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '千葉市美浜区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '銚子市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '市川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '船橋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '館山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '木更津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '松戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '野田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '茂原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '成田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '佐倉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '東金市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '旭市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '習志野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '柏市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '勝浦市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '市原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '流山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '八千代市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '我孫子市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '鴨川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '鎌ケ谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '君津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '富津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '浦安市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '四街道市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '袖ケ浦市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '八街市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '印西市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '白井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '富里市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '南房総市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '匝瑳市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '香取市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '山武市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', 'いすみ市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '印旛郡酒々井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '印旛郡印旛村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '印旛郡本埜村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '印旛郡栄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '香取郡神崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '香取郡多古町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '香取郡東庄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '山武郡大網白里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '山武郡九十九里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '山武郡芝山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '山武郡横芝光町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '長生郡一宮町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '長生郡睦沢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '長生郡長生村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '長生郡白子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '長生郡長柄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '長生郡長南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '夷隅郡大多喜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '夷隅郡御宿町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '12', '安房郡鋸南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '千代田区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '港区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '新宿区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '文京区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '台東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '墨田区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '江東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '品川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '目黒区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '大田区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '世田谷区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '渋谷区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '中野区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '杉並区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '豊島区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '荒川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '板橋区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '練馬区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '足立区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '葛飾区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '江戸川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '八王子市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '立川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '武蔵野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '三鷹市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '青梅市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '府中市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '昭島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '調布市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '町田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '小金井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '小平市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '日野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '東村山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '国分寺市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '国立市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '福生市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '狛江市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '東大和市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '清瀬市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '東久留米市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '武蔵村山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '多摩市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '稲城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '羽村市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', 'あきる野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '西東京市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '西多摩郡瑞穂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '西多摩郡日の出町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '西多摩郡檜原村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '西多摩郡奥多摩町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '大島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '利島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '新島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '神津島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '三宅村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '御蔵島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '八丈町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '青ケ島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '13', '小笠原村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市鶴見区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市神奈川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市中区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市保土ケ谷区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市磯子区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市金沢区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市港北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市戸塚区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市港南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市旭区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市緑区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市瀬谷区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市栄区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市泉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市青葉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横浜市都筑区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市川崎区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市幸区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市中原区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市高津区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市多摩区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市宮前区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '川崎市麻生区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '横須賀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '平塚市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '鎌倉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '藤沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '小田原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '茅ヶ崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '逗子市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '相模原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '三浦市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '秦野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '厚木市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '大和市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '伊勢原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '海老名市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '座間市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '南足柄市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '綾瀬市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '三浦郡葉山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '高座郡寒川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '中郡大磯町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '中郡二宮町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄上郡中井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄上郡大井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄上郡松田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄上郡山北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄上郡開成町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄下郡箱根町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄下郡真鶴町	', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '足柄下郡湯河原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '愛甲郡愛川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '14', '愛甲郡清川村', '0', '2021-05-20', CURRENT_TIMESTAMP);

「北陸」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '15', '新潟市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新潟市東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新潟市中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新潟市江南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新潟市秋葉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新潟市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新潟市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新潟市西蒲区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '長岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '三条市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '柏崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '新発田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '小千谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '加茂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '十日町市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '見附市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '村上市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '燕市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '糸魚川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '妙高市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '五泉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '上越市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '阿賀野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '佐渡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '魚沼市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '南魚沼市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '胎内市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '北蒲原郡聖篭町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '西蒲原郡弥彦村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '南蒲原郡田上町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '東蒲原郡阿賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '三島郡出雲崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '北魚沼郡川口町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '南魚沼郡湯沢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '中魚沼郡津南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '刈羽郡刈羽村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '岩船郡関川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '岩船郡荒川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '岩船郡神林村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '岩船郡朝日村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '岩船郡山北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '15', '岩船郡粟島浦村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '富山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '高岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '魚津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '氷見市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '滑川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '黒部市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '礪波市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '小矢部市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '南礪市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '射水市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '中新川郡', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '中新川郡舟橋村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '中新川郡上市町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '中新川郡立山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '下新川郡', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '下新川郡入善町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '16', '下新川郡朝日町	', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '金沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '七尾市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '小松市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '輪島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '珠洲市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '加賀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '羽咋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', 'かほく市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '白山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '能美市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '能美郡川北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '石川郡野々市町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '河北郡津幡町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '河北郡内灘町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '羽咋郡志賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '羽咋郡宝達志水町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '鹿島郡中能登町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '鳳珠郡穴水町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '17', '鳳珠郡能登町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '福井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '敦賀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '小浜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '大野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '勝山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '鯖江市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', 'あわら市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '越前市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '坂井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '吉田郡永平寺町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '今立郡池田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '南条郡南越前町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '丹生郡越前町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '三方郡美浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '大飯郡高浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '大飯郡おおい町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '18', '三方上中郡若狭町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '甲府市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '富士吉田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '都留市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '山梨市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '大月市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '韮崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南アルプス市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '北杜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '甲斐市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '笛吹市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '上野原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '甲州市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '中央市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '西八代郡市川三郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南巨摩郡増穂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南巨摩郡鰍沢町	', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南巨摩郡早川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南巨摩郡身延町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南巨摩郡南部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '中巨摩郡昭和町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南都留郡道志村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南都留郡西桂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南都留郡忍野村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南都留郡山中湖村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南都留郡鳴沢村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '南都留郡富士河口湖町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '北都留郡小菅村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '19', '北都留郡丹波山村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '長野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '松本市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '岡谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '飯田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '諏訪市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '須坂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '小諸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '伊那市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '駒ヶ根市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '中野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '大町市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '飯山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '茅野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '塩尻市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '佐久市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '千曲市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '東御市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '安曇野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '南佐久郡小海町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '南佐久郡川上村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '南佐久郡南牧村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '南佐久郡南相木村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '南佐久郡北相木村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '南佐久郡佐久穂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '北佐久郡軽井沢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '北佐久郡御代田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '北佐久郡立科町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '小県郡青木村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '小県郡長和町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '諏訪郡下諏訪町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '諏訪郡富士見町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '諏訪郡原村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上伊那郡辰野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上伊那郡箕輪町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上伊那郡飯島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上伊那郡南箕輪村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上伊那郡中川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上伊那郡宮田村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡松川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡高森町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡阿南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡清内路村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡阿智村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡平谷村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡根羽村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡下條村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡売木村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡天龍村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡泰阜村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡喬木村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡豊丘村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下伊那郡大鹿村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '木曽郡上松町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '木曽郡南木曽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '木曽郡木祖村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '木曽郡王滝村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '木曽郡大桑村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '木曽郡木曽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '東筑摩郡麻績村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '東筑摩郡生坂村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '東筑摩郡波田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '東筑摩郡山形村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '東筑摩郡朝日村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '東筑摩郡筑北村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '北安曇郡池田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '北安曇郡松川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '北安曇郡白馬村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '北安曇郡小谷村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '埴科郡坂城町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上高井郡小布施町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上高井郡高山村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下高井郡山ノ内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下高井郡木島平村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下高井郡野沢温泉村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上水内郡信州新町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上水内郡信濃町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上水内郡小川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上水内郡中条村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '上水内郡飯綱町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '20', '下水内郡栄村', '0', '2021-05-20', CURRENT_TIMESTAMP);

「東海」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '21', '岐阜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '大垣市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '高山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '多治見市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '関市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '中津川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '美濃市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '瑞浪市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '羽島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '恵那市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '美濃加茂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '土岐市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '各務原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '可児市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '山県市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '瑞穂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '飛騨市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '本巣市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '郡上市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '下呂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '海津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '羽島郡岐南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '羽島郡笠松町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '養老郡養老町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '不破郡垂井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '不破郡関ケ原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '安八郡神戸町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '安八郡輪之内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '安八郡安八町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '揖斐郡揖斐川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '揖斐郡大野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '揖斐郡池田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '本巣郡北方町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '加茂郡坂祝町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '加茂郡富加町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '加茂郡川辺町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '加茂郡七宗町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '加茂郡八百津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '加茂郡白川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '加茂郡東白川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '可児郡御嵩町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '21', '大野郡白川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '静岡市葵区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '静岡市駿河区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '静岡市清水区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜松市中区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜松市東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜松市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜松市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜松市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜松市浜北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜松市天竜区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '沼津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '熱海市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '三島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '富士宮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '伊東市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '島田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '富士市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '磐田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '焼津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '掛川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '藤枝市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '御殿場市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '袋井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '下田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '裾野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '湖西市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '伊豆市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '御前崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '菊川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '伊豆の国市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '牧之原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '賀茂郡東伊豆町	', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '賀茂郡河津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '賀茂郡南伊豆町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '賀茂郡松崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '賀茂郡西伊豆町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '田方郡函南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '駿東郡清水町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '駿東郡長泉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '駿東郡小山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '富士郡芝川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '庵原郡富士川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '庵原郡由比町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '志太郡岡部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '志太郡大井川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '榛原郡吉田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '榛原郡川根町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '榛原郡川根本町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '周智郡森町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '22', '浜名郡新居町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市千種区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市中村区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市中区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市昭和区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市瑞穂区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市熱田区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市中川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市港区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市守山区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市緑区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市名東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '名古屋市天白区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '豊橋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '岡崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '一宮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '瀬戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '半田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '春日井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '豊川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '津島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '碧南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '刈谷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '豊田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '安城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '西尾市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '蒲郡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '犬山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '常滑市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '江南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '小牧市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '稲沢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '新城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '東海市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '大府市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '知多市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '知立市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '尾張旭市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '高浜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '岩倉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '豊明市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '日進市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '田原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '愛西市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '清須市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '北名古屋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '弥富市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '愛知郡東郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '愛知郡長久手町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '西春日井郡豊山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '西春日井郡春日町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '丹羽郡大口町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '丹羽郡扶桑町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '海部郡七宝町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '海部郡美和町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '海部郡甚目寺町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '海部郡大治町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '海部郡蟹江町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '海部郡飛島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '知多郡阿久比町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '知多郡東浦町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '知多郡南知多町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '知多郡美浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '知多郡武豊町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '幡豆郡一色町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '幡豆郡吉良町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '幡豆郡幡豆町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '額田郡幸田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '西加茂郡三好町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '北設楽郡設楽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '北設楽郡東栄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '北設楽郡豊根村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '宝飯郡音羽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '宝飯郡小坂井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '23', '宝飯郡御津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '四日市市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '伊勢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '松阪市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '桑名市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '鈴鹿市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '名張市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '尾鷲市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '亀山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '鳥羽市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '熊野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', 'いなべ市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '志摩市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '伊賀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '桑名郡木曽岬町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '員弁郡東員町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '三重郡菰野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '三重郡朝日町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '三重郡川越町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '多気郡多気町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '多気郡明和町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '多気郡大台町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '度会郡玉城町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '度会郡度会町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '度会郡大紀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '度会郡南伊勢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '北牟婁郡紀北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '南牟婁郡御浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '24', '南牟婁郡紀宝町', '0', '2021-05-20', CURRENT_TIMESTAMP);

「関西」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '25', '大津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '彦根市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '長浜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '近江八幡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '草津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '守山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '栗東市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '甲賀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '野洲市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '湖南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '高島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '東近江市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '米原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '蒲生郡安土町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '蒲生郡日野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '蒲生郡竜王町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '愛知郡愛荘町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '犬上郡豊郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '犬上郡甲良町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '犬上郡多賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '東浅井郡虎姫町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '東浅井郡湖北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '伊香郡高月町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '伊香郡木之本町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '伊香郡余呉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '25', '伊香郡西浅井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市上京区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市左京区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市中京区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市東山区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市下京区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市右京区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市伏見区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市山科区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京都市西京区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '福知山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '舞鶴市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '綾部市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '宇治市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '宮津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '亀岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '城陽市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '向日市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '長岡京市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '八幡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京田辺市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '京丹後市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '南丹市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '木津川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '乙訓郡大山崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '久世郡久御山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '綴喜郡井手町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '綴喜郡宇治田原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '相楽郡山城町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '相楽郡木津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '相楽郡加茂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '相楽郡笠置町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '相楽郡和束町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '相楽郡精華町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '相楽郡南山城村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '船井郡京丹波町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '与謝郡伊根町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '26', '与謝郡与謝野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市都島区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市福島区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市此花区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市港区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市大正区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市天王寺区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市浪速区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市西淀川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市東淀川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市東成区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市生野区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市旭区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市城東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市阿倍野区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市住吉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市東住吉区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市西成区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市淀川区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市鶴見区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市住之江区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市平野区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪市中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '堺市堺区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '堺市中区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '堺市東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '堺市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '堺市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '堺市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '堺市美原区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '岸和田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '豊中市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '池田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '吹田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '泉大津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '高槻市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '貝塚市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '守口市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '枚方市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '茨木市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '八尾市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '泉佐野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '富田林市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '寝屋川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '河内長野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '松原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大東市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '和泉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '箕面市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '柏原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '羽曳野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '門真市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '摂津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '高石市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '藤井寺市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '東大阪市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '泉南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '四條畷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '交野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '大阪狭山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '阪南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '三島郡島本町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '豊能郡豊能町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '豊能郡能勢町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '泉北郡忠岡町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '泉南郡熊取町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '泉南郡田尻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '泉南郡岬町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '南河内郡太子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '南河内郡河南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '27', '南河内郡千早赤阪村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市東灘区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市灘区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市兵庫区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市長田区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市須磨区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市垂水区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神戸市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '姫路市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '尼崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '明石市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '西宮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '洲本市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '芦屋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '伊丹市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '相生市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '豊岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '加古川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '赤穂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '西脇市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '宝塚市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '三木市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '高砂市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '川西市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '小野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '三田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '加西市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '篠山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '養父市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '丹波市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '南あわじ市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '朝来市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '淡路市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '宍粟市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '加東市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', 'たつの市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '川辺郡猪名川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '多可郡多可町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '加古郡稲美町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '加古郡播磨町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神崎郡市川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神崎郡福崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '神崎郡神河町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '揖保郡太子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '赤穂郡上郡町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '佐用郡佐用町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '美方郡香美町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '28', '美方郡新温泉町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '奈良市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '大和高田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '大和郡山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '天理市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '橿原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '桜井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '五條市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '御所市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '生駒市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '香芝市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '葛城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '宇陀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '山辺郡山添村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '生駒郡平群町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '生駒郡三郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '生駒郡斑鳩町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '生駒郡安堵町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '磯城郡川西町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '磯城郡三宅町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '磯城郡田原本町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '宇陀郡曽爾村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '宇陀郡御杖村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '高市郡高取町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '高市郡明日香村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '北葛城郡上牧町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '北葛城郡王寺町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '北葛城郡広陵町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '北葛城郡河合町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡吉野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡大淀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡下市町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡黒滝村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡天川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡野迫川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡十津川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡下北山村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡上北山村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡川上村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '29', '吉野郡東吉野村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '和歌山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '海南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '橋本市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '有田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '御坊市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '田辺市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '新宮市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '紀の川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '岩出市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '海草郡紀美野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '伊都郡かつらぎ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '伊都郡九度山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '伊都郡高野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '有田郡湯浅町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '有田郡広川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '有田郡有田川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '日高郡美浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '日高郡日高町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '日高郡由良町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '日高郡印南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '日高郡みなべ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '日高郡日高川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '西牟婁郡白浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '西牟婁郡上富田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '西牟婁郡すさみ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '東牟婁郡那智勝浦町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '東牟婁郡太地町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '東牟婁郡古座川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '東牟婁郡北山村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '30', '東牟婁郡串本町', '0', '2021-05-20', CURRENT_TIMESTAMP);

「中国・四国」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '31', '鳥取市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '米子市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '倉吉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '境港市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '岩美郡岩美町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '八頭郡若桜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '八頭郡智頭町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '八頭郡八頭町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '東伯郡三朝町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '東伯郡湯梨浜町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '東伯郡琴浦町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '東伯郡北栄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '西伯郡日吉津村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '西伯郡大山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '西伯郡南部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '西伯郡伯耆町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '日野郡日南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '日野郡日野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '31', '日野郡江府町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '松江市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '浜田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '出雲市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '益田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '大田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '安来市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '江津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '雲南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '八束郡東出雲町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '仁多郡奥出雲町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '飯石郡飯南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '簸川郡斐川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '邑智郡川本町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '邑智郡美郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '邑智郡邑南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '鹿足郡津和野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '鹿足郡吉賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '隠岐郡海士町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '隠岐郡西ノ島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '隠岐郡知夫村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '32', '隠岐郡隠岐の島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '岡山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '倉敷市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '津山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '玉野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '笠岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '井原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '総社市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '高梁市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '新見市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '備前市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '瀬戸内市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '赤磐市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '真庭市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '美作市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '浅口市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '和気郡和気町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '都窪郡早島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '浅口郡里庄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '小田郡矢掛町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '真庭郡新庄村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '苫田郡鏡野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '勝田郡勝央町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '勝田郡奈義町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '英田郡西粟倉村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '久米郡久米南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '久米郡美咲町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '33', '加賀郡吉備中央町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市中区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市安佐南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市安佐北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市安芸区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '広島市佐伯区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '呉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '竹原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '三原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '尾道市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '福山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '府中市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '三次市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '庄原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '大竹市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '東広島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '廿日市市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '安芸高田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '江田島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '安芸郡府中町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '安芸郡海田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '安芸郡熊野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '安芸郡坂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '山県郡安芸太田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '山県郡北広島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '豊田郡大崎上島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '世羅郡世羅町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '34', '神石郡神石高原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '下関市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '宇部市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '山口市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '萩市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '防府市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '下松市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '岩国市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '光市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '長門市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '柳井市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '美祢市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '周南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '山陽小野田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '大島郡周防大島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '玖珂郡和木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '熊毛郡上関町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '熊毛郡田布施町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '熊毛郡平生町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '美祢郡美東町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '美祢郡秋芳町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '阿武郡阿武町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '35', '阿武郡阿東町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '徳島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '鳴門市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '小松島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '阿南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '吉野川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '阿波市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '美馬市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '三好市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '勝浦郡勝浦町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '勝浦郡上勝町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '名東郡佐那河内村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '名西郡石井町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '名西郡神山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '那賀郡那賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '海部郡牟岐町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '海部郡美波町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '海部郡海陽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '板野郡松茂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '板野郡北島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '板野郡藍住町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '板野郡板野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '板野郡上板町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '美馬郡つるぎ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '36', '三好郡東みよし町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '高松市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '丸亀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '坂出市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '善通寺市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '観音寺市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', 'さぬき市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '東かがわ市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '三豊市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '小豆郡土庄町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '小豆郡小豆島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '木田郡三木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '香川郡直島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '綾歌郡宇多津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '綾歌郡綾川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '仲多度郡琴平町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '仲多度郡多度津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '37', '仲多度郡まんのう町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '松山市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '今治市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '宇和島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '八幡浜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '新居浜市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '西条市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '大洲市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '伊予市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '四国中央市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '西予市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '東温市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '越智郡上島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '上浮穴郡久万高原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '伊予郡松前町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '伊予郡砥部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '喜多郡内子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '西宇和郡伊方町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '北宇和郡松野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '北宇和郡鬼北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '38', '南宇和郡愛南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高知市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '室戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '南国市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '土佐市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '須崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '宿毛市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '土佐清水市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '四万十市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '香南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '香美市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸郡東洋町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸郡奈半利町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸郡田野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸郡安田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸郡北川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸郡馬路村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '安芸郡芸西村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '長岡郡本山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '長岡郡大豊町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '土佐郡土佐町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '土佐郡大川村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '吾川郡春野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '吾川郡いの町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '吾川郡仁淀川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高岡郡中土佐町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高岡郡佐川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高岡郡越知町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高岡郡梼原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高岡郡日高村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高岡郡津野町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '高岡郡四万十町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '幡多郡大月町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '幡多郡三原村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '39', '幡多郡黒潮町', '0', '2021-05-20', CURRENT_TIMESTAMP);

「九州」

INSERT INTO `cities` (`id`, `prefecture_id`, `city_name`, `delete_flg`, `create_date`, `update_date`) VALUES 
(NULL, '40', '北九州市門司区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '北九州市若松区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '北九州市戸畑区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '北九州市小倉北区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '北九州市小倉南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '北九州市八幡東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '北九州市八幡西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市東区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市博多区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市中央区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市西区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市城南区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福岡市早良区', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '大牟田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '久留米市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '直方市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '飯塚市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '柳川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '八女市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '筑後市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '大川市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '行橋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '豊前市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '中間市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '小郡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '筑紫野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '春日市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '大野城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '宗像市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '太宰府市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '前原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '古賀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '福津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', 'うきは市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '宮若市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '嘉麻市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '朝倉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', 'みやま市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '筑紫郡那珂川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糟屋郡宇美町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糟屋郡篠栗町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糟屋郡志免町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糟屋郡須惠町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糟屋郡新宮町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糟屋郡久山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糟屋郡粕屋町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '遠賀郡芦屋町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '遠賀郡水巻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '遠賀郡岡垣町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '遠賀郡遠賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '鞍手郡小竹町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '鞍手郡鞍手町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '嘉穂郡桂川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '朝倉郡筑前町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '朝倉郡東峰村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糸島郡二丈町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '糸島郡志摩町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '三井郡大刀洗町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '三潴郡大木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '八女郡黒木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '八女郡立花町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '八女郡広川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '八女郡矢部村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '八女郡星野村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川郡香春町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川郡添田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川郡糸田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川郡川崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川郡大任町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川郡赤村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '田川郡福智町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '京都郡苅田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '京都郡みやこ町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '築上郡吉富町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '築上郡上毛町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '40', '築上郡築上町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '佐賀市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '唐津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '鳥栖市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '多久市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '伊万里市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '武雄市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '鹿島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '小城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '嬉野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '神埼市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '佐賀郡川副町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '佐賀郡東与賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '佐賀郡久保田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '神埼郡吉野ヶ里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '三養基郡基山町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '三養基郡上峰町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '三養基郡みやき町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '東松浦郡玄海町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '西松浦郡有田町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '杵島郡大町町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '杵島郡江北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '杵島郡白石町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '41', '藤津郡太良町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '長崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '佐世保市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '島原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '諌早市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '大村市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '平戸市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '松浦市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '対馬市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '壱岐市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '五島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '西海市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '雲仙市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '南島原市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '西彼杵郡長与町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '西彼杵郡時津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '東彼杵郡東彼杵町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '東彼杵郡川棚町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '東彼杵郡波佐見町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '北松浦郡小値賀町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '北松浦郡江迎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '北松浦郡鹿町町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '北松浦郡佐々町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '42', '南松浦郡新上五島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '熊本市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '八代市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '人吉市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '荒尾市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '水俣市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '玉名市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '山鹿市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '菊池市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '宇土市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '上天草市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '宇城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '阿蘇市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '天草市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '合志市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '下益城郡城南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '下益城郡富合町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '下益城郡美里町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '玉名郡玉東町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '玉名郡南関町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '玉名郡長洲町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '玉名郡和水町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '鹿本郡植木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '菊池郡大津町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '菊池郡菊陽町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '阿蘇郡南小国町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '阿蘇郡小国町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '阿蘇郡産山村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '阿蘇郡高森町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '阿蘇郡西原村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '阿蘇郡南阿蘇村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '上益城郡御船町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '上益城郡嘉島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '上益城郡益城町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '上益城郡甲佐町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '上益城郡山都町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '八代郡氷川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '葦北郡芦北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '葦北郡津奈木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡錦町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡多良木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡湯前町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡水上村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡相良村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡五木村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡山江村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡球磨村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '球磨郡あさぎり町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '43', '天草郡苓北町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '大分市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '別府市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '中津市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '日田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '佐伯市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '臼杵市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '津久見市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '竹田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '豊後高田市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '杵築市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '宇佐市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '豊後大野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '由布市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '国東市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '東国東郡姫島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '速見郡日出町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '玖珠郡九重町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '44', '玖珠郡玖珠町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '宮崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '都城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '延岡市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '日南市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '小林市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '日向市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '串間市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '西都市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', 'えびの市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '宮崎郡清武町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '南那珂郡北郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '南那珂郡南郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '北諸県郡三股町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '西諸県郡高原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '西諸県郡野尻町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '東諸県郡国富町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '東諸県郡綾町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '児湯郡高鍋町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '児湯郡新富町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '児湯郡西米良村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '児湯郡木城町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '児湯郡川南町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '児湯郡都農町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '東臼杵郡門川町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '東臼杵郡諸塚村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '東臼杵郡椎葉村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '東臼杵郡美郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '西臼杵郡高千穂町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '西臼杵郡日之影町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '45', '西臼杵郡五ヶ瀬町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '鹿児島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '鹿屋市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '枕崎市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '阿久根市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '出水市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大口市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '指宿市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '西之表市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '垂水市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '薩摩川内市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '日置市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '曽於市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '霧島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', 'いちき串木野市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '南さつま市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '志布志市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '奄美市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '鹿児島郡三島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '鹿児島郡十島村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '揖宿郡頴娃町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '川辺郡知覧町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '川辺郡川辺町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '薩摩郡さつま町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '出水郡長島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '伊佐郡菱刈町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '姶良郡加治木町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '姶良郡姶良町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '姶良郡蒲生町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '姶良郡湧水町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '曽於郡大崎町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '肝属郡東串良町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '肝属郡錦江町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '肝属郡南大隅町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '肝属郡肝付町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '熊毛郡中種子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '熊毛郡南種子町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '熊毛郡上屋久町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '熊毛郡屋久町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡大和村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡宇検村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡瀬戸内町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡龍郷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡喜界町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡徳之島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡天城町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡伊仙町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡和泊町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡知名町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '46', '大島郡与論町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '那覇市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '宜野湾市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '石垣市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '浦添市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '名護市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '糸満市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '沖縄市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '豊見城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', 'うるま市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '宮古島市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '南城市', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡国頭村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡大宜味村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡東村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡今帰仁村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡本部町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡恩納村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡宜野座村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡金武町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '国頭郡伊江村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '中頭郡読谷村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '中頭郡嘉手納町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '中頭郡北谷町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '中頭郡北中城村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '中頭郡中城村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '中頭郡西原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡与那原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡南風原町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡渡嘉敷村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡座間味村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡粟国村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡渡名喜村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡南大東村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡北大東村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡伊平屋村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡伊是名村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡久米島町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '島尻郡八重瀬町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '宮古郡多良間村', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '八重山郡竹富町', '0', '2021-05-20', CURRENT_TIMESTAMP),
(NULL, '47', '八重山郡与那国町', '0', '2021-05-20', CURRENT_TIMESTAMP);