Skip to content

Instantly share code, notes, and snippets.

@Birdasaur
Last active January 30, 2023 15:59
Show Gist options
  • Select an option

  • Save Birdasaur/648c11f91def5b6655cd06f0df898bf1 to your computer and use it in GitHub Desktop.

Select an option

Save Birdasaur/648c11f91def5b6655cd06f0df898bf1 to your computer and use it in GitHub Desktop.
id ident type name latitude_deg longitude_deg elevation_ft continent iso_country iso_region municipality scheduled_service gps_code iata_code local_code home_link wikipedia_link keywords
5531 RJAA large_airport Narita International Airport 35.764702 140.386002 141 AS JP JP-12 Narita yes RJAA NRT https://en.wikipedia.org/wiki/Narita_International_Airport TYO, Tokyo, Tokyo Narita Airport, New Tokyo International Airport
5536 RJBB large_airport Kansai International Airport 34.427299 135.244003 26 AS JP JP-27 Osaka yes RJBB KIX http://www.kansai-airport.or.jp/en/index.asp https://en.wikipedia.org/wiki/Kansai_International_Airport OSA
5576 RJGG large_airport Chubu Centrair International Airport 34.85839844 136.8049927 15 AS JP JP-23 Tokoname yes RJGG NGO https://en.wikipedia.org/wiki/Ch%C5%ABbu_Centrair_International_Airport
5598 RJOO large_airport Osaka International Airport 34.78549957 135.4380035 50 AS JP JP-27 Osaka yes RJOO ITM https://en.wikipedia.org/wiki/Osaka_International_Airport OSA, Itami
5627 RJTT large_airport Tokyo Haneda International Airport 35.552299 139.779999 35 AS JP JP-13 Tokyo yes RJTT HND http://www.haneda-airport.jp/ https://en.wikipedia.org/wiki/Tokyo_International_Airport TYO, Haneda
city lat lng country iso2 admin_name capital population population_proper
Tokyo 35.6897 139.6922 Japan JP Tokyo primary 37977000 13515271
Osaka 34.75 135.4601 Japan JP Osaka admin 14977000 2725006
Fukuoka 33.6 130.4167 Japan JP Fukuoka admin 2128000 1588924
Kyoto 35.0111 135.7669 Japan JP Kyoto admin 1805000 1459640
Saitama 35.8617 139.6453 Japan JP Saitama admin 1320571 1320571
Hiroshima 34.4 132.45 Japan JP Hiroshima admin 1306589 1306589
Chiba 35.6 140.1 Japan JP Chiba admin 981738 981738
Niigata 37.9161 139.0364 Japan JP Niigata admin 790646 790646
Kumamoto 32.8031 130.7078 Japan JP Kumamoto admin 738567 738567
Okayama 34.65 133.9167 Japan JP Okayama admin 720043 720043
Shizuoka 34.9756 138.3825 Japan JP Shizuoka admin 685589 685589
Kagoshima 31.58 130.5281 Japan JP Kagoshima admin 594258 594258
Aita 33.2333 131.6067 Japan JP Aita admin 477186 477186
Toyama 36.7 137.22 Japan JP Toyama admin 413028 413028
Nagasaki 32.7833 129.8667 Japan JP Nagasaki admin 404656 404656
Gifu 35.4167 136.7667 Japan JP Gifu admin 400118 400118
Miyazaki 31.9167 131.4167 Japan JP Miyazaki admin 397476 397476
Nagano 36.6486 138.1928 Japan JP Nagano admin 367184 367184
Wakayama 34.2333 135.1667 Japan JP Wakayama admin 353299 353299
Nara 34.6833 135.7833 Japan JP Nara admin 352377 352377
Kochi 33.5589 133.5314 Japan JP Kochi admin 325560 325560
Akita 39.7197 140.1025 Japan JP Akita admin 302984 302984
Fukushima 37.7608 140.4733 Japan JP Fukushima admin 284282 284282
Aomori 40.8222 140.7475 Japan JP Aomori admin 271962 271962
Fukui 36.0641 136.2196 Japan JP Fukui admin 260263 260263
Tokushima 34.0667 134.55 Japan JP Tokushima admin 254510 254510
Yamagata 38.25 140.3333 Japan JP Yamagata admin 247234 247234
Saga 33.2667 130.3 Japan JP Saga admin 232359 232359
Tottori 35.5011 134.235 Japan JP Tottori 187323 187323
Tochigi 36.3824 139.7341 Japan JP Tochigi 153508 153508
Yamaguchi 34.1782 131.4735 Japan JP Yamaguchi admin
Display the source blob
Display the rendered blob
Raw
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Prefecture Corruption_high_percent prefecture_ID region_ID
Hokkaido 0.127516779 392001 392001
Aomori 0.127516779 392002 392001
Iwate 0.127516779 392003 392001
Miyagi 0.127516779 392004 392001
Akita 0.127516779 392005 392001
Yamagata 0.127516779 392006 392001
Fukushima 0.127516779 392007 392001
Ibaraki 0.127516779 392008 392001
Tochigi 0.11790393 392009 392002
Gunma 0.11790393 392010 392002
Saitama 0.11790393 392011 392002
Chiba 0.11790393 392012 392002
Tokyo 0.11790393 392013 392002
Kanagawa 0.11790393 392014 392002
Niigata 0.079847909 392015 392003
Toyama 0.079847909 392016 392003
Ishikawa 0.079847909 392017 392003
Fukui 0.079847909 392018 392003
Yamanashi 0.079847909 392019 392003
Nagano 0.079847909 392020 392003
Gifu 0.079847909 392021 392003
Shizuoka 0.079847909 392022 392003
Aichi 0.079847909 392023 392003
Mie 0.079847909 392024 392003
Shiga 0.079847909 392025 392003
Kyoto 0.146443515 392026 392004
Osaka 0.146443515 392027 392004
Hyogo 0.146443515 392028 392004
Nara 0.146443515 392029 392004
Wakayama 0.146443515 392030 392004
Tottori 0.12295082 392031 392005
Shimane 0.12295082 392032 392005
Okayama 0.12295082 392033 392005
Hiroshima 0.12295082 392034 392005
Yamaguchi 0.12295082 392035 392005
Tokushima 0.12295082 392036 392005
Kagawa 0.12295082 392037 392005
Ehime 0.12295082 392038 392005
Kochi 0.12295082 392039 392005
Fukuoka 0.12295082 392040 392005
Saga 0.12295082 392041 392005
Nagasaki 0.12295082 392042 392005
Kumamoto 0.12295082 392043 392005
Miyazaki 0.12295082 392044 392005
Oita 0.12295082 392045 392005
Kagoshima 0.12295082 392046 392005
Okinawa 0.12295082 392047 392005
prefecture prefecture_ID region_ID var_high_percent
Hokkaido 392001 392001 0.11409396
Aomori 392002 392001 0.11409396
Iwate 392003 392001 0.11409396
Miyagi 392004 392001 0.11409396
Akita 392005 392001 0.11409396
Yamagata 392006 392001 0.11409396
Fukushima 392007 392001 0.11409396
Ibaraki 392008 392001 0.11409396
Tochigi 392009 392002 0.096069869
Gunma 392010 392002 0.096069869
Saitama 392011 392002 0.096069869
Chiba 392012 392002 0.096069869
Tokyo 392013 392002 0.096069869
Kanagawa 392014 392002 0.096069869
Niigata 392015 392003 0.129277567
Toyama 392016 392003 0.129277567
Ishikawa 392017 392003 0.129277567
Fukui 392018 392003 0.129277567
Yamanashi 392019 392003 0.129277567
Nagano 392020 392003 0.129277567
Gifu 392021 392003 0.129277567
Shizuoka 392022 392003 0.129277567
Aichi 392023 392003 0.129277567
Mie 392024 392003 0.129277567
Shiga 392025 392003 0.129277567
Kyoto 392026 392004 0.079497908
Osaka 392027 392004 0.079497908
Hyogo 392028 392004 0.079497908
Nara 392029 392004 0.079497908
Wakayama 392030 392004 0.079497908
Tottori 392031 392005 0.081967213
Shimane 392032 392005 0.081967213
Okayama 392033 392005 0.081967213
Hiroshima 392034 392005 0.081967213
Yamaguchi 392035 392005 0.081967213
Tokushima 392036 392005 0.081967213
Kagawa 392037 392005 0.081967213
Ehime 392038 392005 0.081967213
Kochi 392039 392005 0.081967213
Fukuoka 392040 392005 0.081967213
Saga 392041 392005 0.081967213
Nagasaki 392042 392005 0.081967213
Kumamoto 392043 392005 0.081967213
Miyazaki 392044 392005 0.081967213
Oita 392045 392005 0.081967213
Kagoshima 392046 392005 0.081967213
Okinawa 392047 392005 0.081967213
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment