# Columns: ZIP/Location,CDI,No. of responses,Hypocentral distance,Latitude,Longitude,Suspect?,Standard deviation,City,State[,cityid] "Mexicali::Baja California::Mexico",4.3,37,27,32.6500,-115.4700,0,0.144,"Mexicali","",city_2009:::84529 "Progreso::Baja California::Mexico",4.3,1,31,32.5800,-115.5800,0,0.330,"Progreso","",city_2009:::84531 "Puebla::Baja California::Mexico",3.9,9,39,32.5600,-115.3500,0,0.262,"Puebla","",city_2009:::84532 "Rosarito::Baja California::Mexico",2.0,1,147,32.3300,-117.0300,0,0.330,"Rosarito","",city_2009:::84534 "Tijuana::Baja California::Mexico",2.6,7,140,32.5300,-117.0200,0,0.277,"Tijuana","",city_2009:::84541 "San Luis Río Colorado::Sonora::Mexico",2.5,1,86,32.4600,-114.7800,0,0.330,"San Luis Río Colorado","",city_2009:::85969 "85326",2.7,1,253,33.2279,-112.9124,0,0.330,"Buckeye","AZ" "85344",2.0,3,179,33.8426,-114.1019,0,0.311,"Parker","AZ" "85350",2.7,9,89,32.5330,-114.6995,0,0.262,"Somerton","AZ" "85356",2.0,2,133,32.9007,-114.1593,0,0.320,"Wellton","AZ" "85364",3.1,59,87,32.7004,-114.6745,0,0.111,"Yuma","AZ" "85365",3.1,31,100,32.6823,-114.5342,0,0.159,"Yuma","AZ" "85367",2.2,8,114,32.6572,-114.3844,0,0.269,"Yuma","AZ" "85379",2.2,1,310,33.6028,-112.3817,0,0.330,"Surprise","AZ" "89102",2.2,1,371,36.1451,-115.1858,0,0.330,"Las Vegas","NV" "90010",1.0,1,290,34.0628,-118.3135,0,0.330,"Los Angeles","CA" "90012",2.2,1,284,34.0659,-118.2386,0,0.330,"Los Angeles","CA" "90020",1.0,1,290,34.0663,-118.3103,0,0.330,"Los Angeles","CA" "90041",1.0,1,286,34.1371,-118.2073,0,0.330,"Los Angeles","CA" "90505",1.0,1,281,33.8087,-118.3483,0,0.330,"Torrance","CA" "90620",1.0,1,254,33.8463,-118.0115,0,0.330,"Buena Park","CA" "90723",1.0,1,270,33.8976,-118.1647,0,0.330,"Paramount","CA" "90740",2.7,1,255,33.7545,-118.0713,0,0.330,"Seal Beach","CA" "90807",2.0,1,267,33.8286,-118.1782,0,0.330,"Long Beach","CA" "90815",1.0,1,261,33.7962,-118.1160,0,0.330,"Long Beach","CA" "91106",1.0,1,279,34.1390,-118.1276,0,0.330,"Pasadena","CA" "91326",1.0,1,321,34.2804,-118.5561,0,0.330,"Porter Ranch","CA" "91360",2.0,2,344,34.2140,-118.8808,0,0.320,"Thousand Oaks","CA" "91364",2.0,1,318,34.1551,-118.5954,0,0.330,"Woodland Hills","CA" "91402",2.1,1,309,34.2242,-118.4447,0,0.330,"Panorama City","CA" "91505",1.0,1,299,34.1770,-118.3479,0,0.330,"Burbank","CA" "91602",1.0,1,299,34.1507,-118.3660,0,0.330,"North Hollywood","CA" "91708",1.0,1,231,33.9536,-117.6473,0,0.330,"Chino","CA" "91761",1.0,1,232,34.0345,-117.5927,0,0.330,"Ontario","CA" "91766",2.0,1,245,34.0417,-117.7572,0,0.330,"Pomona","CA" "91784",2.2,1,244,34.1410,-117.6592,0,0.330,"Upland","CA" "91789",2.0,1,251,34.0208,-117.8541,0,0.330,"Walnut","CA" "91901",2.0,8,108,32.8065,-116.7152,0,0.269,"Alpine","CA" "91902",2.9,2,136,32.6741,-117.0048,0,0.320,"Bonita","CA" "91906",2.2,2,91,32.6963,-116.5168,0,0.320,"Campo","CA" "91910",2.5,23,141,32.6379,-117.0555,0,0.186,"Chula Vista","CA" "91911",2.2,4,141,32.6073,-117.0504,0,0.302,"Chula Vista","CA" "91913",2.0,10,135,32.6327,-116.9857,0,0.255,"Chula Vista","CA" "91914",2.3,3,132,32.6595,-116.9599,0,0.311,"Chula Vista","CA" "91915",2.5,3,133,32.6158,-116.9636,0,0.311,"Chula Vista","CA" "91916",2.0,3,101,32.9209,-116.6347,0,0.311,"Descanso","CA" "91917",2.5,1,118,32.6070,-116.7943,0,0.330,"Dulzura","CA" "91932",2.0,7,148,32.5793,-117.1176,0,0.277,"Imperial Beach","CA" "91935",2.0,3,118,32.6839,-116.8151,0,0.311,"Jamul","CA" "91941",2.9,4,135,32.7612,-117.0017,0,0.302,"La Mesa","CA" "91942",2.0,2,136,32.7833,-117.0168,0,0.320,"La Mesa","CA" "91962",2.2,2,84,32.8116,-116.4538,0,0.320,"Pine Valley","CA" "91963",2.1,1,101,32.6383,-116.6147,0,0.330,"Potrero","CA" "91977",2.0,1,134,32.7241,-116.9956,0,0.330,"Spring Valley","CA" "91978",2.0,1,129,32.7041,-116.9409,0,0.330,"Spring Valley","CA" "91980",2.1,1,106,32.5871,-116.6607,0,0.330,"Tecate","CA" "92003",1.0,1,161,33.2847,-117.2000,0,0.330,"Bonsall","CA" "92004",2.0,2,81,33.2073,-116.2825,0,0.320,"Borrego Springs","CA" "92008",2.0,1,168,33.1467,-117.3184,0,0.330,"Carlsbad","CA" "92010",2.2,1,165,33.1567,-117.2847,0,0.330,"Carlsbad","CA" "92011",2.2,1,165,33.1072,-117.2949,0,0.330,"Carlsbad","CA" "92014",2.0,3,156,32.9801,-117.2226,0,0.311,"Del Mar","CA" "92019",2.0,3,123,32.7804,-116.8798,0,0.311,"El Cajon","CA" "92020",2.4,5,132,32.7965,-116.9705,0,0.293,"El Cajon","CA" "92021",2.4,6,122,32.8392,-116.8693,0,0.285,"El Cajon","CA" "92024",2.0,3,160,33.0588,-117.2556,0,0.311,"Encinitas","CA" "92025",2.0,4,140,33.0847,-117.0258,0,0.302,"Escondido","CA" "92026",2.0,4,151,33.2143,-117.1137,0,0.302,"Escondido","CA" "92027",2.0,2,137,33.1373,-116.9847,0,0.320,"Escondido","CA" "92028",1.0,1,170,33.4049,-117.2514,0,0.330,"Fallbrook","CA" "92029",1.0,2,149,33.0815,-117.1323,0,0.320,"Escondido","CA" "92036",3.8,3,78,32.9447,-116.3789,0,0.311,"Julian","CA" "92037",3.0,17,158,32.8550,-117.2499,0,0.213,"La Jolla","CA" "92040",2.7,7,124,32.9132,-116.8824,0,0.277,"Lakeside","CA" "92056",2.0,3,166,33.2015,-117.2893,0,0.311,"Oceanside","CA" "92057",1.0,2,168,33.2522,-117.2903,0,0.320,"Oceanside","CA" "92058",3.4,1,174,33.2668,-117.3552,0,0.330,"Oceanside","CA" "92064",2.0,5,137,32.9851,-117.0207,0,0.293,"Poway","CA" "92065",2.0,7,123,33.0428,-116.8481,0,0.277,"Ramona","CA" "92069",2.9,5,154,33.1754,-117.1575,0,0.293,"San Marcos","CA" "92070",2.0,1,119,33.1881,-116.7554,0,0.330,"Santa Ysabel","CA" "92071",2.2,12,136,32.8655,-117.0144,0,0.242,"Santee","CA" "92075",3.1,1,159,32.9950,-117.2579,0,0.330,"Solana Beach","CA" "92078",2.0,5,155,33.1200,-117.1872,0,0.293,"San Marcos","CA" "92081",3.4,2,161,33.1648,-117.2409,0,0.320,"Vista","CA" "92082",2.0,4,142,33.2539,-116.9945,0,0.302,"Valley Center","CA" "92084",4.1,1,160,33.2218,-117.2050,0,0.330,"Vista","CA" "92086",1.0,1,118,33.3052,-116.6802,0,0.330,"Warner Springs","CA" "92101",2.9,29,150,32.7234,-117.1693,0,0.165,"San Diego","CA" "92103",2.5,19,150,32.7473,-117.1668,0,0.203,"San Diego","CA" "92104",2.7,4,146,32.7428,-117.1267,0,0.302,"San Diego","CA" "92105",2.0,2,143,32.7376,-117.0925,0,0.320,"San Diego","CA" "92106",3.4,1,156,32.7090,-117.2322,0,0.330,"San Diego","CA" "92108",2.4,12,148,32.7736,-117.1438,0,0.242,"San Diego","CA" "92109",2.7,7,156,32.7914,-117.2336,0,0.277,"San Diego","CA" "92110",3.1,5,153,32.7651,-117.2014,0,0.293,"San Diego","CA" "92111",2.1,4,150,32.8065,-117.1689,0,0.302,"San Diego","CA" "92115",3.0,3,141,32.7611,-117.0716,0,0.311,"San Diego","CA" "92116",2.0,6,146,32.7649,-117.1232,0,0.285,"San Diego","CA" "92117",2.7,4,153,32.8249,-117.2000,0,0.302,"San Diego","CA" "92118",2.7,7,150,32.6680,-117.1611,0,0.277,"Coronado","CA" "92119",2.0,5,137,32.8067,-117.0302,0,0.293,"San Diego","CA" "92120",2.0,1,141,32.7945,-117.0726,0,0.330,"San Diego","CA" "92121",1.0,1,153,32.8981,-117.2016,0,0.330,"San Diego","CA" "92122",2.3,21,154,32.8568,-117.2102,0,0.194,"San Diego","CA" "92123",2.0,6,147,32.8068,-117.1352,0,0.285,"San Diego","CA" "92124",2.5,5,143,32.8237,-117.0945,0,0.293,"San Diego","CA" "92126",2.0,6,148,32.9125,-117.1430,0,0.285,"San Diego","CA" "92127",2.0,2,147,33.0230,-117.1222,0,0.320,"San Diego","CA" "92128",2.0,4,142,32.9965,-117.0728,0,0.302,"San Diego","CA" "92129",2.0,9,147,32.9681,-117.1277,0,0.262,"San Diego","CA" "92130",2.0,6,154,32.9492,-117.2056,0,0.285,"San Diego","CA" "92131",2.0,4,141,32.9192,-117.0681,0,0.302,"San Diego","CA" "92139",2.4,4,140,32.6799,-117.0489,0,0.302,"San Diego","CA" "92140",3.4,1,153,32.7383,-117.2008,0,0.330,"San Diego","CA" "92154",2.2,8,137,32.5676,-117.0000,0,0.269,"San Diego","CA" "92173",3.3,2,142,32.5547,-117.0504,0,0.320,"San Ysidro","CA" "92201",2.0,9,118,33.7076,-116.2345,0,0.262,"Indio","CA" "92203",2.0,2,122,33.7518,-116.2417,0,0.320,"Indio","CA" "92210",3.1,1,123,33.7020,-116.3398,0,0.330,"Indian Wells","CA" "92211",2.0,4,128,33.7643,-116.3302,0,0.302,"Palm Desert","CA" "92223",2.0,2,181,33.9175,-116.9928,0,0.320,"Beaumont","CA" "92227",4.4,14,31,33.0077,-115.4295,0,0.230,"Brawley","CA" "92231",4.1,6,23,32.6846,-115.5469,0,0.285,"Calexico","CA" "92233",2.5,3,43,33.1705,-115.5071,0,0.311,"Calipatria","CA" "92234",2.1,4,139,33.8157,-116.4665,0,0.302,"Cathedral City","CA" "92236",2.8,5,113,33.6893,-116.1684,0,0.293,"Coachella","CA" "92239",3.1,1,110,33.7797,-115.3560,0,0.330,"Desert Center","CA" "92240",2.0,1,156,33.9626,-116.5297,0,0.330,"Desert Hot Springs","CA" "92241",1.0,1,137,33.8659,-116.3338,0,0.330,"Desert Hot Springs","CA" "92243",5.0,101,18,32.7734,-115.6010,0,0.094,"El Centro","CA" "92249",4.4,5,23,32.7188,-115.4556,0,0.293,"Heber","CA" "92250",3.4,9,27,32.7946,-115.3564,0,0.262,"Holtville","CA" "92251",5.6,56,19,32.8727,-115.6208,0,0.114,"Imperial","CA" "92253",2.0,18,115,33.6545,-116.2811,0,0.208,"La Quinta","CA" "92254",3.4,2,84,33.5044,-115.8887,0,0.320,"Mecca","CA" "92257",3.5,2,63,33.3536,-115.6763,0,0.320,"Niland","CA" "92259",3.1,1,44,32.7453,-116.0064,0,0.330,"Ocotillo","CA" "92260",2.0,9,125,33.6890,-116.3971,0,0.262,"Palm Desert","CA" "92262",2.6,15,149,33.8625,-116.5683,0,0.224,"Palm Springs","CA" "92264",2.5,12,137,33.7409,-116.5360,0,0.242,"Palm Springs","CA" "92270",2.1,7,133,33.7672,-116.4228,0,0.277,"Rancho Mirage","CA" "92274",3.8,3,50,33.0884,-115.9531,0,0.311,"Thermal","CA" "92281",3.8,1,33,33.0652,-115.6479,0,0.330,"Westmorland","CA" "92283",3.1,9,64,33.0799,-114.9865,0,0.262,"Winterhaven","CA" "92307",2.7,1,245,34.5925,-117.1313,0,0.330,"Apple Valley","CA" "92320",1.0,1,190,33.9868,-117.0491,0,0.330,"Calimesa","CA" "92336",1.0,1,229,34.1352,-117.4621,0,0.330,"Fontana","CA" "92345",2.0,2,238,34.3858,-117.3081,0,0.320,"Hesperia","CA" "92354",1.0,1,208,34.0500,-117.2514,0,0.330,"Loma Linda","CA" "92407",3.1,1,221,34.1726,-117.3086,0,0.330,"San Bernardino","CA" "92503",2.2,1,212,33.8897,-117.4468,0,0.330,"Riverside","CA" "92543",2.6,1,164,33.7023,-116.9792,0,0.330,"Hemet","CA" "92544",2.0,2,155,33.6444,-116.8984,0,0.320,"Hemet","CA" "92545",2.0,1,171,33.7327,-117.0433,0,0.330,"Hemet","CA" "92549",2.7,1,156,33.7836,-116.7772,0,0.330,"Idyllwild","CA" "92561",5.0,1,121,33.5873,-116.4804,0,0.330,"Mountain Center","CA" "92562",2.0,2,178,33.5488,-117.2676,0,0.320,"Murrieta","CA" "92563",2.0,1,170,33.5807,-117.1465,0,0.330,"Murrieta","CA" "92567",1.0,1,180,33.8103,-117.0994,0,0.330,"Nuevo","CA" "92583",2.7,2,166,33.7928,-116.9195,0,0.320,"San Jacinto","CA" "92584",2.0,3,177,33.6594,-117.1784,0,0.311,"Menifee","CA" "92585",1.0,1,181,33.7423,-117.1713,0,0.330,"Sun City","CA" "92592",1.0,2,155,33.5072,-117.0131,0,0.320,"Temecula","CA" "92596",1.0,1,167,33.6355,-117.0731,0,0.330,"Winchester","CA" "92617",1.0,1,231,33.6420,-117.8425,0,0.330,"Irvine","CA" "92646",1.0,1,243,33.6650,-117.9682,0,0.330,"Huntington Beach","CA" "92653",2.0,1,216,33.5925,-117.6990,0,0.330,"Laguna Hills","CA" "92656",2.5,2,218,33.5749,-117.7314,0,0.320,"Aliso Viejo","CA" "92663",2.0,1,237,33.6230,-117.9300,0,0.330,"Newport Beach","CA" "92677",3.4,1,214,33.5268,-117.7041,0,0.330,"Laguna Niguel","CA" "92704",1.0,1,240,33.7208,-117.9084,0,0.330,"Santa Ana","CA" "92807",2.0,1,236,33.8500,-117.7892,0,0.330,"Anaheim","CA" "92833",1.0,1,252,33.8800,-117.9611,0,0.330,"Fullerton","CA" "92840",1.0,1,245,33.7859,-117.9318,0,0.330,"Garden Grove","CA" "92882",2.7,1,221,33.8417,-117.6039,0,0.330,"Corona","CA" "93514",2.7,1,578,37.4763,-118.4007,0,0.330,"Bishop","CA" "94044",2.0,1,823,37.6045,-122.4822,0,0.330,"Pacifica","CA" "94949",2.0,1,860,38.0651,-122.5400,0,0.330,"Novato","CA" "95112",3.1,1,764,37.3449,-121.8836,0,0.330,"San Jose","CA" "95128",2.9,1,765,37.3162,-121.9365,0,0.330,"San Jose","CA" "95337",1.0,1,751,37.7409,-121.2382,0,0.330,"Manteca","CA"