Skip to content

Instantly share code, notes, and snippets.

@adamgotterer

adamgotterer/gist:6257922

Created August 17, 2013 17:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save adamgotterer/6257922 to your computer and use it in GitHub Desktop.
Save adamgotterer/6257922 to your computer and use it in GitHub Desktop.
Download ZIP
Rails ActiveRecord countries migration with name, alpha2, alpha3, latitude and longitude
Raw
gistfile1.rb
# encoding: UTF-8
class Countries < ActiveRecord::Migration
def up
create_table :countries do |t|
t.column :alpha2, :string, :size => 2
t.column :alpha3, :string, :size => 3
t.column :name, :string, :size => 80
t.column :latitude, :float
t.column :longitude, :float
end
Country.create(name: "Afghanistan", alpha2: "AF", alpha3: "AFG", latitude: 33.93911, longitude: 67.709953)
Country.create(name: "Albania", alpha2: "AL", alpha3: "ALB", latitude: 41.153332, longitude: 20.168331)
Country.create(name: "Algeria", alpha2: "DZ", alpha3: "DZA", latitude: 28.033886, longitude: 1.659626)
Country.create(name: "American Samoa", alpha2: "AS", alpha3: "ASM", latitude: -14.270972, longitude: -170.132217)
Country.create(name: "Andorra", alpha2: "AD", alpha3: "AND", latitude: 42.546245, longitude: 1.601554)
Country.create(name: "Angola", alpha2: "AO", alpha3: "AGO", latitude: -11.202692, longitude: 17.873887)
Country.create(name: "Anguilla", alpha2: "AI", alpha3: "AIA", latitude: 18.220554, longitude: -63.068615)
Country.create(name: "Antarctica", alpha2: "AQ", alpha3: "ATA", latitude: -75.250973, longitude: -0.071389)
Country.create(name: "Antigua and Barbuda", alpha2: "AG", alpha3: "ATG", latitude: 17.060816, longitude: -61.796428)
Country.create(name: "Argentina", alpha2: "AR", alpha3: "ARG", latitude: -38.416097, longitude: -63.616672)
Country.create(name: "Armenia", alpha2: "AM", alpha3: "ARM", latitude: 40.069099, longitude: 45.038189)
Country.create(name: "Aruba", alpha2: "AW", alpha3: "ABW", latitude: 12.52111, longitude: -69.968338)
Country.create(name: "Australia", alpha2: "AU", alpha3: "AUS", latitude: -25.274398, longitude: 133.775136)
Country.create(name: "Austria", alpha2: "AT", alpha3: "AUT", latitude: 47.516231, longitude: 14.550072)
Country.create(name: "Azerbaijan", alpha2: "AZ", alpha3: "AZE", latitude: 40.143105, longitude: 47.576927)
Country.create(name: "Bahamas", alpha2: "BS", alpha3: "BHS", latitude: 25.03428, longitude: -77.39628)
Country.create(name: "Bahrain", alpha2: "BH", alpha3: "BHR", latitude: 25.930414, longitude: 50.637772)
Country.create(name: "Bangladesh", alpha2: "BD", alpha3: "BGD", latitude: 23.684994, longitude: 90.356331)
Country.create(name: "Barbados", alpha2: "BB", alpha3: "BRB", latitude: 13.193887, longitude: -59.543198)
Country.create(name: "Belarus", alpha2: "BY", alpha3: "BLR", latitude: 53.709807, longitude: 27.953389)
Country.create(name: "Belgium", alpha2: "BE", alpha3: "BEL", latitude: 50.503887, longitude: 4.469936)
Country.create(name: "Belize", alpha2: "BZ", alpha3: "BLZ", latitude: 17.189877, longitude: -88.49765)
Country.create(name: "Benin", alpha2: "BJ", alpha3: "BEN", latitude: 9.30769, longitude: 2.315834)
Country.create(name: "Bermuda", alpha2: "BM", alpha3: "BMU", latitude: 32.321384, longitude: -64.75737)
Country.create(name: "Bhutan", alpha2: "BT", alpha3: "BTN", latitude: 27.514162, longitude: 90.433601)
Country.create(name: "Bolivia", alpha2: "BO", alpha3: "BOL", latitude: -16.290154, longitude: -63.588653)
Country.create(name: "Bosnia and Herzegovina", alpha2: "BA", alpha3: "BIH", latitude: 43.915886, longitude: 17.679076)
Country.create(name: "Botswana", alpha2: "BW", alpha3: "BWA", latitude: -22.328474, longitude: 24.684866)
Country.create(name: "Bouvet Island", alpha2: "BV", alpha3: "BVT", latitude: -54.423199, longitude: 3.413194)
Country.create(name: "Brazil", alpha2: "BR", alpha3: "BRA", latitude: -14.235004, longitude: -51.92528)
Country.create(name: "British Indian Ocean Territory", alpha2: "IO", alpha3: "IOT", latitude: -6.343194, longitude: 71.876519)
Country.create(name: "Brunei", alpha2: "BN", alpha3: "BRN", latitude: 4.535277, longitude: 114.727669)
Country.create(name: "Bulgaria", alpha2: "BG", alpha3: "BGR", latitude: 42.733883, longitude: 25.48583)
Country.create(name: "Burkina Faso", alpha2: "BF", alpha3: "BFA", latitude: 12.238333, longitude: -1.561593)
Country.create(name: "Burundi", alpha2: "BI", alpha3: "BDI", latitude: -3.373056, longitude: 29.918886)
Country.create(name: "Cambodia", alpha2: "KH", alpha3: "KHM", latitude: 12.565679, longitude: 104.990963)
Country.create(name: "Cameroon", alpha2: "CM", alpha3: "CMR", latitude: 7.369722, longitude: 12.354722)
Country.create(name: "Canada", alpha2: "CA", alpha3: "CAN", latitude: 56.130366, longitude: -106.346771)
Country.create(name: "Cape Verde", alpha2: "CV", alpha3: "CPV", latitude: 16.002082, longitude: -24.013197)
Country.create(name: "Cayman Islands", alpha2: "KY", alpha3: "CYM", latitude: 19.513469, longitude: -80.566956)
Country.create(name: "Central African Republic", alpha2: "CF", alpha3: "CAF", latitude: 6.611111, longitude: 20.939444)
Country.create(name: "Chad", alpha2: "TD", alpha3: "TCD", latitude: 15.454166, longitude: 18.732207)
Country.create(name: "Chile", alpha2: "CL", alpha3: "CHL", latitude: -35.675147, longitude: -71.542969)
Country.create(name: "China", alpha2: "CN", alpha3: "CHN", latitude: 35.86166, longitude: 104.195397)
Country.create(name: "Christmas Island", alpha2: "CX", alpha3: "CXR", latitude: -10.447525, longitude: 105.690449)
Country.create(name: "Cocos [Keeling] Islands", alpha2: "CC", alpha3: "CCK", latitude: -12.164165, longitude: 96.870956)
Country.create(name: "Colombia", alpha2: "CO", alpha3: "COL", latitude: 4.570868, longitude: -74.297333)
Country.create(name: "Comoros", alpha2: "KM", alpha3: "COM", latitude: -11.875001, longitude: 43.872219)
Country.create(name: "Congo [Republic]", alpha2: "CG", alpha3: "COG", latitude: -0.228021, longitude: 15.827659)
Country.create(name: "Congo [DRC]", alpha2: "CD", alpha3: "COD", latitude: -4.038333, longitude: 21.758664)
Country.create(name: "Cook Islands", alpha2: "CK", alpha3: "COK", latitude: -21.236736, longitude: -159.777671)
Country.create(name: "Costa Rica", alpha2: "CR", alpha3: "CRI", latitude: 9.748917, longitude: -83.753428)
Country.create(name: "Côte d'Ivoire", alpha2: "CI", alpha3: "CIV", latitude: 7.539989, longitude: -5.54708)
Country.create(name: "Croatia", alpha2: "HR", alpha3: "HRV", latitude: 45.1, longitude: 15.2)
Country.create(name: "Cuba", alpha2: "CU", alpha3: "CUB", latitude: 21.521757, longitude: -77.781167)
Country.create(name: "Cyprus", alpha2: "CY", alpha3: "CYP", latitude: 35.126413, longitude: 33.429859)
Country.create(name: "Czech Republic", alpha2: "CZ", alpha3: "CZE", latitude: 49.817492, longitude: 15.472962)
Country.create(name: "Denmark", alpha2: "DK", alpha3: "DNK", latitude: 56.26392, longitude: 9.501785)
Country.create(name: "Djibouti", alpha2: "DJ", alpha3: "DJI", latitude: 11.825138, longitude: 42.590275)
Country.create(name: "Dominica", alpha2: "DM", alpha3: "DMA", latitude: 15.414999, longitude: -61.370976)
Country.create(name: "Dominican Republic", alpha2: "DO", alpha3: "DOM", latitude: 18.735693, longitude: -70.162651)
Country.create(name: "Ecuador", alpha2: "EC", alpha3: "ECU", latitude: -1.831239, longitude: -78.183406)
Country.create(name: "Egypt", alpha2: "EG", alpha3: "EGY", latitude: 26.820553, longitude: 30.802498)
Country.create(name: "El Salvador", alpha2: "SV", alpha3: "SLV", latitude: 13.794185, longitude: -88.89653)
Country.create(name: "Equatorial Guinea", alpha2: "GQ", alpha3: "GNQ", latitude: 1.650801, longitude: 10.267895)
Country.create(name: "Eritrea", alpha2: "ER", alpha3: "ERI", latitude: 15.179384, longitude: 39.782334)
Country.create(name: "Estonia", alpha2: "EE", alpha3: "EST", latitude: 58.595272, longitude: 25.013607)
Country.create(name: "Ethiopia", alpha2: "ET", alpha3: "ETH", latitude: 9.145, longitude: 40.489673)
Country.create(name: "Falkland Islands [Islas Malvinas]", alpha2: "FK", alpha3: "FLK", latitude: -51.796253, longitude: -59.523613)
Country.create(name: "Faroe Islands", alpha2: "FO", alpha3: "FRO", latitude: 61.892635, longitude: -6.911806)
Country.create(name: "Fiji", alpha2: "FJ", alpha3: "FJI", latitude: -16.578193, longitude: 179.414413)
Country.create(name: "Finland", alpha2: "FI", alpha3: "FIN", latitude: 61.92411, longitude: 25.748151)
Country.create(name: "France", alpha2: "FR", alpha3: "FRA", latitude: 46.227638, longitude: 2.213749)
Country.create(name: "French Guiana", alpha2: "GF", alpha3: "GUF", latitude: 3.933889, longitude: -53.125782)
Country.create(name: "French Polynesia", alpha2: "PF", alpha3: "PYF", latitude: -17.679742, longitude: -149.406843)
Country.create(name: "French Southern Territories", alpha2: "TF", alpha3: "ATF", latitude: -49.280366, longitude: 69.348557)
Country.create(name: "Gabon", alpha2: "GA", alpha3: "GAB", latitude: -0.803689, longitude: 11.609444)
Country.create(name: "Gambia", alpha2: "GM", alpha3: "GMB", latitude: 13.443182, longitude: -15.310139)
Country.create(name: "Georgia", alpha2: "GE", alpha3: "GEO", latitude: 42.315407, longitude: 43.356892)
Country.create(name: "Germany", alpha2: "DE", alpha3: "DEU", latitude: 51.165691, longitude: 10.451526)
Country.create(name: "Ghana", alpha2: "GH", alpha3: "GHA", latitude: 7.946527, longitude: -1.023194)
Country.create(name: "Gibraltar", alpha2: "GI", alpha3: "GIB", latitude: 36.137741, longitude: -5.345374)
Country.create(name: "Greece", alpha2: "GR", alpha3: "GRC", latitude: 39.074208, longitude: 21.824312)
Country.create(name: "Greenland", alpha2: "GL", alpha3: "GRL", latitude: 71.706936, longitude: -42.604303)
Country.create(name: "Grenada", alpha2: "GD", alpha3: "GRD", latitude: 12.262776, longitude: -61.604171)
Country.create(name: "Guadeloupe", alpha2: "GP", alpha3: "GLP", latitude: 16.995971, longitude: -62.067641)
Country.create(name: "Guam", alpha2: "GU", alpha3: "GUM", latitude: 13.444304, longitude: 144.793731)
Country.create(name: "Guatemala", alpha2: "GT", alpha3: "GTM", latitude: 15.783471, longitude: -90.230759)
Country.create(name: "Guernsey", alpha2: "GG", alpha3: "GGY", latitude: 49.465691, longitude: -2.585278)
Country.create(name: "Guinea", alpha2: "GN", alpha3: "GIN", latitude: 9.945587, longitude: -9.696645)
Country.create(name: "Guinea-Bissau", alpha2: "GW", alpha3: "GNB", latitude: 11.803749, longitude: -15.180413)
Country.create(name: "Guyana", alpha2: "GY", alpha3: "GUY", latitude: 4.860416, longitude: -58.93018)
Country.create(name: "Haiti", alpha2: "HT", alpha3: "HTI", latitude: 18.971187, longitude: -72.285215)
Country.create(name: "Heard Island and McDonald Islands", alpha2: "HM", alpha3: "HMD", latitude: -53.08181, longitude: 73.504158)
Country.create(name: "Vatican City", alpha2: "VA", alpha3: "VAT", latitude: 41.902916, longitude: 12.453389)
Country.create(name: "Honduras", alpha2: "HN", alpha3: "HND", latitude: 15.199999, longitude: -86.241905)
Country.create(name: "Hong Kong", alpha2: "HK", alpha3: "HKG", latitude: 22.396428, longitude: 114.109497)
Country.create(name: "Hungary", alpha2: "HU", alpha3: "HUN", latitude: 47.162494, longitude: 19.503304)
Country.create(name: "Iceland", alpha2: "IS", alpha3: "ISL", latitude: 64.963051, longitude: -19.020835)
Country.create(name: "India", alpha2: "IN", alpha3: "IND", latitude: 20.593684, longitude: 78.96288)
Country.create(name: "Indonesia", alpha2: "ID", alpha3: "IDN", latitude: -0.789275, longitude: 113.921327)
Country.create(name: "Iran", alpha2: "IR", alpha3: "IRN", latitude: 32.427908, longitude: 53.688046)
Country.create(name: "Iraq", alpha2: "IQ", alpha3: "IRQ", latitude: 33.223191, longitude: 43.679291)
Country.create(name: "Ireland", alpha2: "IE", alpha3: "IRL", latitude: 53.41291, longitude: -8.24389)
Country.create(name: "Isle of Man", alpha2: "IM", alpha3: "IMN", latitude: 54.236107, longitude: -4.548056)
Country.create(name: "Israel", alpha2: "IL", alpha3: "ISR", latitude: 31.046051, longitude: 34.851612)
Country.create(name: "Italy", alpha2: "IT", alpha3: "ITA", latitude: 41.87194, longitude: 12.56738)
Country.create(name: "Jamaica", alpha2: "JM", alpha3: "JAM", latitude: 18.109581, longitude: -77.297508)
Country.create(name: "Japan", alpha2: "JP", alpha3: "JPN", latitude: 36.204824, longitude: 138.252924)
Country.create(name: "Jersey", alpha2: "JE", alpha3: "JEY", latitude: 49.214439, longitude: -2.13125)
Country.create(name: "Jordan", alpha2: "JO", alpha3: "JOR", latitude: 30.585164, longitude: 36.238414)
Country.create(name: "Kazakhstan", alpha2: "KZ", alpha3: "KAZ", latitude: 48.019573, longitude: 66.923684)
Country.create(name: "Kenya", alpha2: "KE", alpha3: "KEN", latitude: -0.023559, longitude: 37.906193)
Country.create(name: "Kiribati", alpha2: "KI", alpha3: "KIR", latitude: -3.370417, longitude: -168.734039)
Country.create(name: "North Korea", alpha2: "KP", alpha3: "PRK", latitude: 40.339852, longitude: 127.510093)
Country.create(name: "South Korea", alpha2: "KR", alpha3: "KOR", latitude: 35.907757, longitude: 127.766922)
Country.create(name: "Kuwait", alpha2: "KW", alpha3: "KWT", latitude: 29.31166, longitude: 47.481766)
Country.create(name: "Kyrgyzstan", alpha2: "KG", alpha3: "KGZ", latitude: 41.20438, longitude: 74.766098)
Country.create(name: "Laos", alpha2: "LA", alpha3: "LAO", latitude: 19.85627, longitude: 102.495496)
Country.create(name: "Latvia", alpha2: "LV", alpha3: "LVA", latitude: 56.879635, longitude: 24.603189)
Country.create(name: "Lebanon", alpha2: "LB", alpha3: "LBN", latitude: 33.854721, longitude: 35.862285)
Country.create(name: "Lesotho", alpha2: "LS", alpha3: "LSO", latitude: -29.609988, longitude: 28.233608)
Country.create(name: "Liberia", alpha2: "LR", alpha3: "LBR", latitude: 6.428055, longitude: -9.429499)
Country.create(name: "Libya", alpha2: "LY", alpha3: "LBY", latitude: 26.3351, longitude: 17.228331)
Country.create(name: "Liechtenstein", alpha2: "LI", alpha3: "LIE", latitude: 47.166, longitude: 9.555373)
Country.create(name: "Lithuania", alpha2: "LT", alpha3: "LTU", latitude: 55.169438, longitude: 23.881275)
Country.create(name: "Luxembourg", alpha2: "LU", alpha3: "LUX", latitude: 49.815273, longitude: 6.129583)
Country.create(name: "Macau", alpha2: "MO", alpha3: "MAC", latitude: 22.198745, longitude: 113.543873)
Country.create(name: "Macedonia [FYROM]", alpha2: "MK", alpha3: "MKD", latitude: 41.608635, longitude: 21.745275)
Country.create(name: "Madagascar", alpha2: "MG", alpha3: "MDG", latitude: -18.766947, longitude: 46.869107)
Country.create(name: "Malawi", alpha2: "MW", alpha3: "MWI", latitude: -13.254308, longitude: 34.301525)
Country.create(name: "Malaysia", alpha2: "MY", alpha3: "MYS", latitude: 4.210484, longitude: 101.975766)
Country.create(name: "Maldives", alpha2: "MV", alpha3: "MDV", latitude: 3.202778, longitude: 73.22068)
Country.create(name: "Mali", alpha2: "ML", alpha3: "MLI", latitude: 17.570692, longitude: -3.996166)
Country.create(name: "Malta", alpha2: "MT", alpha3: "MLT", latitude: 35.937496, longitude: 14.375416)
Country.create(name: "Marshall Islands", alpha2: "MH", alpha3: "MHL", latitude: 7.131474, longitude: 171.184478)
Country.create(name: "Martinique", alpha2: "MQ", alpha3: "MTQ", latitude: 14.641528, longitude: -61.024174)
Country.create(name: "Mauritania", alpha2: "MR", alpha3: "MRT", latitude: 21.00789, longitude: -10.940835)
Country.create(name: "Mauritius", alpha2: "MU", alpha3: "MUS", latitude: -20.348404, longitude: 57.552152)
Country.create(name: "Mayotte", alpha2: "YT", alpha3: "MYT", latitude: -12.8275, longitude: 45.166244)
Country.create(name: "Mexico", alpha2: "MX", alpha3: "MEX", latitude: 23.634501, longitude: -102.552784)
Country.create(name: "Micronesia", alpha2: "FM", alpha3: "FSM", latitude: 7.425554, longitude: 150.550812)
Country.create(name: "Moldova", alpha2: "MD", alpha3: "MDA", latitude: 47.411631, longitude: 28.369885)
Country.create(name: "Monaco", alpha2: "MC", alpha3: "MCO", latitude: 43.750298, longitude: 7.412841)
Country.create(name: "Mongolia", alpha2: "MN", alpha3: "MNG", latitude: 46.862496, longitude: 103.846656)
Country.create(name: "Montenegro", alpha2: "ME", alpha3: "MNE", latitude: 42.708678, longitude: 19.37439)
Country.create(name: "Montserrat", alpha2: "MS", alpha3: "MSR", latitude: 16.742498, longitude: -62.187366)
Country.create(name: "Morocco", alpha2: "MA", alpha3: "MAR", latitude: 31.791702, longitude: -7.09262)
Country.create(name: "Mozambique", alpha2: "MZ", alpha3: "MOZ", latitude: -18.665695, longitude: 35.529562)
Country.create(name: "Myanmar [Burma]", alpha2: "MM", alpha3: "MMR", latitude: 21.913965, longitude: 95.956223)
Country.create(name: "Namibia", alpha2: "NA", alpha3: "NAM", latitude: -22.95764, longitude: 18.49041)
Country.create(name: "Nauru", alpha2: "NR", alpha3: "NRU", latitude: -0.522778, longitude: 166.931503)
Country.create(name: "Nepal", alpha2: "NP", alpha3: "NPL", latitude: 28.394857, longitude: 84.124008)
Country.create(name: "Netherlands", alpha2: "NL", alpha3: "NLD", latitude: 52.132633, longitude: 5.291266)
Country.create(name: "Netherlands Antilles", alpha2: "AN", alpha3: "ANT", latitude: 12.226079, longitude: -69.060087)
Country.create(name: "New Caledonia", alpha2: "NC", alpha3: "NCL", latitude: -20.904305, longitude: 165.618042)
Country.create(name: "New Zealand", alpha2: "NZ", alpha3: "NZL", latitude: -40.900557, longitude: 174.885971)
Country.create(name: "Nicaragua", alpha2: "NI", alpha3: "NIC", latitude: 12.865416, longitude: -85.207229)
Country.create(name: "Niger", alpha2: "NE", alpha3: "NER", latitude: 17.607789, longitude: 8.081666)
Country.create(name: "Nigeria", alpha2: "NG", alpha3: "NGA", latitude: 9.081999, longitude: 8.675277)
Country.create(name: "Niue", alpha2: "NU", alpha3: "NIU", latitude: -19.054445, longitude: -169.867233)
Country.create(name: "Norfolk Island", alpha2: "NF", alpha3: "NFK", latitude: -29.040835, longitude: 167.954712)
Country.create(name: "Northern Mariana Islands", alpha2: "MP", alpha3: "MNP", latitude: 17.33083, longitude: 145.38469)
Country.create(name: "Norway", alpha2: "NO", alpha3: "NOR", latitude: 60.472024, longitude: 8.468946)
Country.create(name: "Oman", alpha2: "OM", alpha3: "OMN", latitude: 21.512583, longitude: 55.923255)
Country.create(name: "Pakistan", alpha2: "PK", alpha3: "PAK", latitude: 30.375321, longitude: 69.345116)
Country.create(name: "Palau", alpha2: "PW", alpha3: "PLW", latitude: 7.51498, longitude: 134.58252)
Country.create(name: "Palestinian Territories", alpha2: "PS", alpha3: "PSE", latitude: 31.952162, longitude: 35.233154)
Country.create(name: "Panama", alpha2: "PA", alpha3: "PAN", latitude: 8.537981, longitude: -80.782127)
Country.create(name: "Papua New Guinea", alpha2: "PG", alpha3: "PNG", latitude: -6.314993, longitude: 143.95555)
Country.create(name: "Paraguay", alpha2: "PY", alpha3: "PRY", latitude: -23.442503, longitude: -58.443832)
Country.create(name: "Peru", alpha2: "PE", alpha3: "PER", latitude: -9.189967, longitude: -75.015152)
Country.create(name: "Philippines", alpha2: "PH", alpha3: "PHL", latitude: 12.879721, longitude: 121.774017)
Country.create(name: "Pitcairn Islands", alpha2: "PN", alpha3: "PCN", latitude: -24.703615, longitude: -127.439308)
Country.create(name: "Poland", alpha2: "PL", alpha3: "POL", latitude: 51.919438, longitude: 19.145136)
Country.create(name: "Portugal", alpha2: "PT", alpha3: "PRT", latitude: 39.399872, longitude: -8.224454)
Country.create(name: "Puerto Rico", alpha2: "PR", alpha3: "PRI", latitude: 18.220833, longitude: -66.590149)
Country.create(name: "Qatar", alpha2: "QA", alpha3: "QAT", latitude: 25.354826, longitude: 51.183884)
Country.create(name: "Réunion", alpha2: "RE", alpha3: "REU", latitude: -21.115141, longitude: 55.536384)
Country.create(name: "Romania", alpha2: "RO", alpha3: "ROU", latitude: 45.943161, longitude: 24.96676)
Country.create(name: "Russia", alpha2: "RU", alpha3: "RUS", latitude: 61.52401, longitude: 105.318756)
Country.create(name: "Rwanda", alpha2: "RW", alpha3: "RWA", latitude: -1.940278, longitude: 29.873888)
Country.create(name: "Saint Helena", alpha2: "SH", alpha3: "SHN", latitude: -24.143474, longitude: -10.030696)
Country.create(name: "Saint Kitts and Nevis", alpha2: "KN", alpha3: "KNA", latitude: 17.357822, longitude: -62.782998)
Country.create(name: "Saint Lucia", alpha2: "LC", alpha3: "LCA", latitude: 13.909444, longitude: -60.978893)
Country.create(name: "Saint Pierre and Miquelon", alpha2: "PM", alpha3: "SPM", latitude: 46.941936, longitude: -56.27111)
Country.create(name: "Saint Vincent and the Grenadines", alpha2: "VC", alpha3: "VCT", latitude: 12.984305, longitude: -61.287228)
Country.create(name: "Samoa", alpha2: "WS", alpha3: "WSM", latitude: -13.759029, longitude: -172.104629)
Country.create(name: "San Marino", alpha2: "SM", alpha3: "SMR", latitude: 43.94236, longitude: 12.457777)
Country.create(name: "São Tomé and Príncipe", alpha2: "ST", alpha3: "STP", latitude: 0.18636, longitude: 6.613081)
Country.create(name: "Saudi Arabia", alpha2: "SA", alpha3: "SAU", latitude: 23.885942, longitude: 45.079162)
Country.create(name: "Senegal", alpha2: "SN", alpha3: "SEN", latitude: 14.497401, longitude: -14.452362)
Country.create(name: "Serbia", alpha2: "RS", alpha3: "SRB", latitude: 44.016521, longitude: 21.005859)
Country.create(name: "Seychelles", alpha2: "SC", alpha3: "SYC", latitude: -4.679574, longitude: 55.491977)
Country.create(name: "Sierra Leone", alpha2: "SL", alpha3: "SLE", latitude: 8.460555, longitude: -11.779889)
Country.create(name: "Singapore", alpha2: "SG", alpha3: "SGP", latitude: 1.352083, longitude: 103.819836)
Country.create(name: "Slovakia", alpha2: "SK", alpha3: "SVK", latitude: 48.669026, longitude: 19.699024)
Country.create(name: "Slovenia", alpha2: "SI", alpha3: "SVN", latitude: 46.151241, longitude: 14.995463)
Country.create(name: "Solomon Islands", alpha2: "SB", alpha3: "SLB", latitude: -9.64571, longitude: 160.156194)
Country.create(name: "Somalia", alpha2: "SO", alpha3: "SOM", latitude: 5.152149, longitude: 46.199616)
Country.create(name: "South Africa", alpha2: "ZA", alpha3: "ZAF", latitude: -30.559482, longitude: 22.937506)
Country.create(name: "South Georgia and the South Sandwich Islands", alpha2: "GS", alpha3: "SGS", latitude: -54.429579, longitude: -36.587909)
Country.create(name: "Spain", alpha2: "ES", alpha3: "ESP", latitude: 40.463667, longitude: -3.74922)
Country.create(name: "Sri Lanka", alpha2: "LK", alpha3: "LKA", latitude: 7.873054, longitude: 80.771797)
Country.create(name: "Sudan", alpha2: "SD", alpha3: "SDN", latitude: 12.862807, longitude: 30.217636)
Country.create(name: "Suriname", alpha2: "SR", alpha3: "SUR", latitude: 3.919305, longitude: -56.027783)
Country.create(name: "Svalbard and Jan Mayen", alpha2: "SJ", alpha3: "SJM", latitude: 77.553604, longitude: 23.670272)
Country.create(name: "Swaziland", alpha2: "SZ", alpha3: "SWZ", latitude: -26.522503, longitude: 31.465866)
Country.create(name: "Sweden", alpha2: "SE", alpha3: "SWE", latitude: 60.128161, longitude: 18.643501)
Country.create(name: "Switzerland", alpha2: "CH", alpha3: "CHE", latitude: 46.818188, longitude: 8.227512)
Country.create(name: "Syria", alpha2: "SY", alpha3: "SYR", latitude: 34.802075, longitude: 38.996815)
Country.create(name: "Taiwan", alpha2: "TW", alpha3: "TWN", latitude: 23.69781, longitude: 120.960515)
Country.create(name: "Tajikistan", alpha2: "TJ", alpha3: "TJK", latitude: 38.861034, longitude: 71.276093)
Country.create(name: "Tanzania", alpha2: "TZ", alpha3: "TZA", latitude: -6.369028, longitude: 34.888822)
Country.create(name: "Thailand", alpha2: "TH", alpha3: "THA", latitude: 15.870032, longitude: 100.992541)
Country.create(name: "Timor-Leste", alpha2: "TL", alpha3: "TLS", latitude: -8.874217, longitude: 125.727539)
Country.create(name: "Togo", alpha2: "TG", alpha3: "TGO", latitude: 8.619543, longitude: 0.824782)
Country.create(name: "Tokelau", alpha2: "TK", alpha3: "TKL", latitude: -8.967363, longitude: -171.855881)
Country.create(name: "Tonga", alpha2: "TO", alpha3: "TON", latitude: -21.178986, longitude: -175.198242)
Country.create(name: "Trinidad and Tobago", alpha2: "TT", alpha3: "TTO", latitude: 10.691803, longitude: -61.222503)
Country.create(name: "Tunisia", alpha2: "TN", alpha3: "TUN", latitude: 33.886917, longitude: 9.537499)
Country.create(name: "Turkey", alpha2: "TR", alpha3: "TUR", latitude: 38.963745, longitude: 35.243322)
Country.create(name: "Turkmenistan", alpha2: "TM", alpha3: "TKM", latitude: 38.969719, longitude: 59.556278)
Country.create(name: "Turks and Caicos Islands", alpha2: "TC", alpha3: "TCA", latitude: 21.694025, longitude: -71.797928)
Country.create(name: "Tuvalu", alpha2: "TV", alpha3: "TUV", latitude: -7.109535, longitude: 177.64933)
Country.create(name: "Uganda", alpha2: "UG", alpha3: "UGA", latitude: 1.373333, longitude: 32.290275)
Country.create(name: "Ukraine", alpha2: "UA", alpha3: "UKR", latitude: 48.379433, longitude: 31.16558)
Country.create(name: "United Arab Emirates", alpha2: "AE", alpha3: "ARE", latitude: 23.424076, longitude: 53.847818)
Country.create(name: "United Kingdom", alpha2: "GB", alpha3: "GBR", latitude: 55.378051, longitude: -3.435973)
Country.create(name: "United States", alpha2: "US", alpha3: "USA", latitude: 37.09024, longitude: -95.712891)
Country.create(name: "U.S. Minor Outlying Islands", alpha2: "UM", alpha3: "UMI", latitude: 0, longitude: 0)
Country.create(name: "Uruguay", alpha2: "UY", alpha3: "URY", latitude: -32.522779, longitude: -55.765835)
Country.create(name: "Uzbekistan", alpha2: "UZ", alpha3: "UZB", latitude: 41.377491, longitude: 64.585262)
Country.create(name: "Vanuatu", alpha2: "VU", alpha3: "VUT", latitude: -15.376706, longitude: 166.959158)
Country.create(name: "Venezuela", alpha2: "VE", alpha3: "VEN", latitude: 6.42375, longitude: -66.58973)
Country.create(name: "Vietnam", alpha2: "VN", alpha3: "VNM", latitude: 14.058324, longitude: 108.277199)
Country.create(name: "British Virgin Islands", alpha2: "VG", alpha3: "VGB", latitude: 18.420695, longitude: -64.639968)
Country.create(name: "U.S. Virgin Islands", alpha2: "VI", alpha3: "VIR", latitude: 18.335765, longitude: -64.896335)
Country.create(name: "Wallis and Futuna", alpha2: "WF", alpha3: "WLF", latitude: -13.768752, longitude: -177.156097)
Country.create(name: "Western Sahara", alpha2: "EH", alpha3: "ESH", latitude: 24.215527, longitude: -12.885834)
Country.create(name: "Yemen", alpha2: "YE", alpha3: "YEM", latitude: 15.552727, longitude: 48.516388)
Country.create(name: "Zambia", alpha2: "ZM", alpha3: "ZMB", latitude: -13.133897, longitude: 27.849332)
Country.create(name: "Zimbabwe", alpha2: "ZW", alpha3: "ZWE", latitude: -19.015438, longitude: 29.154857)
end
def down
drop_table :countries
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment