BEGIN TRANSACTION;
insert into kens ("id", "ken_kanji", "ken_kana") values ('1', '三重県', 'ﾐｴｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('2', '京都府', 'ｷｮｳﾄﾌ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('3', '佐賀県', 'ｻｶﾞｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('4', '兵庫県', 'ﾋｮｳｺﾞｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('5', '北海道', 'ﾎｯｶｲﾄﾞｳ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('6', '千葉県', 'ﾁﾊﾞｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('7', '和歌山県', 'ﾜｶﾔﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('8', '埼玉県', 'ｻｲﾀﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('9', '大分県', 'ｵｵｲﾀｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('10', '大阪府', 'ｵｵｻｶﾌ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('11', '奈良県', 'ﾅﾗｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('12', '宮城県', 'ﾐﾔｷﾞｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('13', '宮崎県', 'ﾐﾔｻﾞｷｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('14', '富山県', 'ﾄﾔﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('15', '山口県', 'ﾔﾏｸﾞﾁｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('16', '山形県', 'ﾔﾏｶﾞﾀｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('17', '山梨県', 'ﾔﾏﾅｼｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('18', '岐阜県', 'ｷﾞﾌｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('19', '岡山県', 'ｵｶﾔﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('20', '岩手県', 'ｲﾜﾃｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('21', '島根県', 'ｼﾏﾈｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('22', '広島県', 'ﾋﾛｼﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('23', '徳島県', 'ﾄｸｼﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('24', '愛媛県', 'ｴﾋﾒｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('25', '愛知県', 'ｱｲﾁｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('26', '新潟県', 'ﾆｲｶﾞﾀｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('27', '東京都', 'ﾄｳｷｮｳﾄ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('28', '栃木県', 'ﾄﾁｷﾞｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('29', '沖縄県', 'ｵｷﾅﾜｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('30', '滋賀県', 'ｼｶﾞｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('31', '熊本県', 'ｸﾏﾓﾄｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('32', '石川県', 'ｲｼｶﾜｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('33', '神奈川県', 'ｶﾅｶﾞﾜｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('34', '福井県', 'ﾌｸｲｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('35', '福岡県', 'ﾌｸｵｶｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('36', '福島県', 'ﾌｸｼﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('37', '秋田県', 'ｱｷﾀｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('38', '群馬県', 'ｸﾞﾝﾏｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('39', '茨城県', 'ｲﾊﾞﾗｷｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('40', '長崎県', 'ﾅｶﾞｻｷｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('41', '長野県', 'ﾅｶﾞﾉｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('42', '青森県', 'ｱｵﾓﾘｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('43', '静岡県', 'ｼｽﾞｵｶｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('44', '香川県', 'ｶｶﾞﾜｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('45', '高知県', 'ｺｳﾁｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('46', '鳥取県', 'ﾄｯﾄﾘｹﾝ');
insert into kens ("id", "ken_kanji", "ken_kana") values ('47', '鹿児島県', 'ｶｺﾞｼﾏｹﾝ');
COMMIT;
