【MySQL】データセットのサンプル
MySQLの記事を書く際に使えそうなデータセットのメモです。
気が向き次第、追加していきます。
BigQueryなどでもそのまま使えます。
47都道府県
with
prefectures as (
select 1 as id, '北海道' as prefecture, '北海道' as area union all
select 2 as id, '青森県' as prefecture, '東北' as area union all
select 3 as id, '岩手県' as prefecture, '東北' as area union all
select 4 as id, '宮城県' as prefecture, '東北' as area union all
select 5 as id, '秋田県' as prefecture, '東北' as area union all
select 6 as id, '山形県' as prefecture, '東北' as area union all
select 7 as id, '福島県' as prefecture, '東北' as area union all
select 8 as id, '茨城県' as prefecture, '関東' as area union all
select 9 as id, '栃木県' as prefecture, '関東' as area union all
select 10 as id, '群馬県' as prefecture, '関東' as area union all
select 11 as id, '埼玉県' as prefecture, '関東' as area union all
select 12 as id, '千葉県' as prefecture, '関東' as area union all
select 13 as id, '東京都' as prefecture, '関東' as area union all
select 14 as id, '神奈川県' as prefecture, '関東' as area union all
select 15 as id, '新潟県' as prefecture, '中部' as area union all
select 16 as id, '富山県' as prefecture, '中部' as area union all
select 17 as id, '石川県' as prefecture, '中部' as area union all
select 18 as id, '福井県' as prefecture, '中部' as area union all
select 19 as id, '山梨県' as prefecture, '中部' as area union all
select 20 as id, '長野県' as prefecture, '中部' as area union all
select 21 as id, '岐阜県' as prefecture, '中部' as area union all
select 22 as id, '静岡県' as prefecture, '中部' as area union all
select 23 as id, '愛知県' as prefecture, '中部' as area union all
select 24 as id, '三重県' as prefecture, '近畿' as area union all
select 25 as id, '滋賀県' as prefecture, '近畿' as area union all
select 26 as id, '京都府' as prefecture, '近畿' as area union all
select 27 as id, '大阪府' as prefecture, '近畿' as area union all
select 28 as id, '兵庫県' as prefecture, '近畿' as area union all
select 29 as id, '奈良県' as prefecture, '近畿' as area union all
select 30 as id, '和歌山県' as prefecture, '近畿' as area union all
select 31 as id, '鳥取県' as prefecture, '中国' as area union all
select 32 as id, '島根県' as prefecture, '中国' as area union all
select 33 as id, '岡山県' as prefecture, '中国' as area union all
select 34 as id, '広島県' as prefecture, '中国' as area union all
select 35 as id, '山口県' as prefecture, '中国' as area union all
select 36 as id, '徳島県' as prefecture, '四国' as area union all
select 37 as id, '香川県' as prefecture, '四国' as area union all
select 38 as id, '愛媛県' as prefecture, '四国' as area union all
select 39 as id, '高知県' as prefecture, '四国' as area union all
select 40 as id, '福岡県' as prefecture, '九州' as area union all
select 41 as id, '佐賀県' as prefecture, '九州' as area union all
select 42 as id, '長崎県' as prefecture, '九州' as area union all
select 43 as id, '熊本県' as prefecture, '九州' as area union all
select 44 as id, '大分県' as prefecture, '九州' as area union all
select 45 as id, '宮崎県' as prefecture, '九州' as area union all
select 46 as id, '鹿児島県' as prefecture, '九州' as area union all
select 47 as id, '沖縄県' as prefecture, '九州' as area
)
select
*
from
prefectures
;以上になります。
お読み頂き、ありがとうございました。
