city_x_rite_aid_store.id,city.id,city.ts,city.title,city.state,state.id,state.ts,state.title
101,101,"2018-01-11 03:25:33","Canoga Park",California,2,"2018-01-11 03:22:57",California
102,102,"2018-01-11 03:25:33","Canyon Country",California,2,"2018-01-11 03:22:57",California,102,"2018-01-11 03:53:19","Rite Aid #05556 Canyon Country","16642 Soledad Canyon Rd","(661) 252-5388",34.426022,"Canyon Country",CA,91387,-118.426137
103,103,"2018-01-11 03:25:33",Capitola,California,2,"2018-01-11 03:22:57",California,103,"2018-01-11 03:53:22","Rite Aid #05966 Capitola","1475 41st Avenue","(831) 476-7282",36.97168717629598,Capitola,CA,95010,-121.96640610694885
104,104,"2018-01-11 03:25:33",Carlsbad,California,2,"2018-01-11 03:22:57",California
105,105,"2018-01-11 03:25:33",Carmichael,California,2,"2018-01-11 03:22:57",California,105,"2018-01-11 03:53:35","Rite Aid #06044 Carmichael","4010 Manzanita Avenue","(916) 482-4930",38.637363,Carmichael,CA,95608,-121.326212
106,106,"2018-01-11 03:25:33",Carpinteria,California,2,"2018-01-11 03:22:57",California,106,"2018-01-11 03:53:41","Rite Aid #05776 Carpinteria","801 Linden Avenue","(805) 684-4816",34.397957818750534,Carpinteria,CA,93013,-119.51999008655548
107,107,"2018-01-11 03:25:33","Castro Valley",California,2,"2018-01-11 03:22:57",California,107,"2018-01-11 03:53:47","Rite Aid #05922 Castro Valley","3848 Castro Valley Boulevard","(510) 886-3341",37.694203,"Castro Valley",CA,94546,-122.0675294
108,108,"2018-01-11 03:25:33","Cathedral City",California,2,"2018-01-11 03:22:57",California,108,"2018-01-11 03:53:50","Rite Aid #05676 Cathedral City","69155 Ramon Road","(760) 770-3097",33.813535,"Cathedral City",CA,92234,-116.456778
109,109,"2018-01-11 03:25:33",Ceres,California,2,"2018-01-11 03:22:57",California,109,"2018-01-11 03:53:55","Rite Aid #06003 Ceres","1830 Mitchell Road","(209) 538-4927",37.602734,Ceres,CA,95307,-120.938164
110,110,"2018-01-11 03:25:33",Chatsworth,California,2,"2018-01-11 03:22:57",California,110,"2018-01-11 03:54:12","Rite Aid #05545 Chatsworth","10120 Mason Avenue","(818) 349-7213",34.2545311,Chatsworth,CA,91311,-118.579281
111,111,"2018-01-11 03:25:33",Chico,California,2,"2018-01-11 03:22:57",California
112,112,"2018-01-11 03:25:33",Chino,California,2,"2018-01-11 03:22:57",California,112,"2018-01-11 03:54:28","Rite Aid #05579 Chino","12059 Central Avenue","(909) 627-4012",34.0343186,Chino,CA,91710,-117.6877535
113,113,"2018-01-11 03:25:33","Chino Hills",California,2,"2018-01-11 03:22:57",California
114,114,"2018-01-11 03:25:33",Chowchilla,California,2,"2018-01-11 03:22:57",California,114,"2018-01-11 03:54:52","Rite Aid #05848 Chowchilla","48 Robertson Blvd","(559) 665-1096",37.124115,Chowchilla,CA,93610,-120.259419
115,115,"2018-01-11 03:25:33","Chula Vista",California,2,"2018-01-11 03:22:57",California
116,116,"2018-01-11 03:25:33","Citrus Heights",California,2,"2018-01-11 03:22:57",California
117,117,"2018-01-11 03:25:33",Clearlake,California,2,"2018-01-11 03:22:57",California,117,"2018-01-11 03:55:16","Rite Aid #06026 Clearlake","15025 Olympic Drive","(707) 994-8677",38.9613846,Clearlake,CA,95422,-122.6306071
118,118,"2018-01-11 03:25:33",Coachella,California,2,"2018-01-11 03:22:57",California,118,"2018-01-11 03:55:33","Rite Aid #05678 Coachella","51101 Harrison Street","(760) 398-0833",33.677681,Coachella,CA,92236,-116.182285
119,119,"2018-01-11 03:25:33",Coalinga,California,2,"2018-01-11 03:22:57",California,119,"2018-01-11 03:55:39","Rite Aid #05793 Coalinga","159 West Polk Street","(559) 935-3597",36.135611,Coalinga,CA,93210,-120.364945
120,120,"2018-01-11 03:25:33",Colton,California,2,"2018-01-11 03:22:57",California
121,121,"2018-01-11 03:25:33",Colusa,California,2,"2018-01-11 03:22:57",California,121,"2018-01-11 03:55:49","Rite Aid #06088 Colusa","1021 Bridge Street","(530) 458-2494",39.203907,Colusa,CA,95932,-122.002743
122,122,"2018-01-11 03:25:33",Commerce,California,2,"2018-01-11 03:22:57",California,122,"2018-01-11 03:55:56","Rite Aid #05432 Commerce","5490 Whittier Boulevard","(323) 721-9718",34.01827,Commerce,CA,90022,-118.152623
123,123,"2018-01-11 03:25:33",Compton,California,2,"2018-01-11 03:22:57",California
124,124,"2018-01-11 03:25:33",Concord,California,2,"2018-01-11 03:22:57",California,124,"2018-01-11 03:56:16","Rite Aid #05913 Concord","1905 Monument Boulevard","(925) 680-2845",37.956809,Concord,CA,94520,-122.040564
125,125,"2018-01-11 03:25:33",Corcoran,California,2,"2018-01-11 03:22:57",California,125,"2018-01-11 03:56:20","Rite Aid #06395 Corcoran","1500 Whitley Avenue","(559) 992-8020",36.09855802906148,Corcoran,CA,93212,-119.56673429169314
126,126,"2018-01-11 03:25:33",Corning,California,2,"2018-01-11 03:22:57",California,126,"2018-01-11 03:56:25","Rite Aid #06188 Corning","640 Edith Avenue","(530) 824-5086",39.92957497361151,Corning,CA,96021,-122.19895362854004
127,127,"2018-01-11 03:25:33",Corona,California,2,"2018-01-11 03:22:57",California,127,"2018-01-11 03:56:32","Rite Aid #05583 Corona","910 West Ontario Avenue","(951) 735-1011",33.8575926,Corona,CA,92882,-117.5807611
128,128,"2018-01-11 03:25:33","Corona Del Mar",California,2,"2018-01-11 03:22:57",California,128,"2018-01-11 03:56:38","Rite Aid #06207 Corona Del Mar","3141 East Coast Highway","(949) 675-0414",33.5970201,"Corona Del Mar",CA,92625,-117.8717223
129,129,"2018-01-11 03:25:33",Coronado,California,2,"2018-01-11 03:22:57",California,129,"2018-01-11 03:56:41","Rite Aid #05655 Coronado","836 Orange Avenue","(619) 435-6585",32.6881509,Coronado,CA,92118,-117.1789046
130,130,"2018-01-11 03:25:33","Corte Madera",California,2,"2018-01-11 03:22:57",California,130,"2018-01-11 03:56:52","Rite Aid #05959 Corte Madera","431 Corte Madera Town Center","(415) 924-4557",37.926744,"Corte Madera",CA,94925,-122.517779
131,131,"2018-01-11 03:25:33","Costa Mesa",California,2,"2018-01-11 03:22:57",California
132,132,"2018-01-11 03:25:33",Covina,California,2,"2018-01-11 03:22:57",California,132,"2018-01-11 03:56:57","Rite Aid #05585 Covina","139 North Grand Avenue","(626) 339-8616",34.086862,Covina,CA,91724,-117.87362
133,133,"2018-01-11 03:25:33","Crescent City",California,2,"2018-01-11 03:22:57",California,133,"2018-01-11 03:57:01","Rite Aid #06040 Crescent City","575 M Street","(707) 465-3981",41.756919,"Crescent City",CA,95531,-124.193644
134,134,"2018-01-11 03:25:33","Culver City",California,2,"2018-01-11 03:22:57",California
135,135,"2018-01-11 03:25:33",Cupertino,California,2,"2018-01-11 03:22:57",California,135,"2018-01-11 03:57:24","Rite Aid #05967 Cupertino","20572 Homestead Road","(408) 253-2005",37.337057,Cupertino,CA,95014,-122.033452
136,136,"2018-01-11 03:25:33",Cypress,California,2,"2018-01-11 03:22:57",California,136,"2018-01-11 03:57:27","Rite Aid #05500 Cypress","4037 Ball Road","(714) 821-1750",33.818404,Cypress,CA,90630,-118.061443
137,137,"2018-01-11 03:25:33","Dana Point",California,2,"2018-01-11 03:22:57",California,137,"2018-01-11 03:57:48","Rite Aid #05735 Dana Point","24829 Del Prado","(949) 493-5100",33.466507,"Dana Point",CA,92629,-117.697431
138,138,"2018-01-11 03:25:33",Davis,California,2,"2018-01-11 03:22:57",California
139,139,"2018-01-11 03:25:33",Delano,California,2,"2018-01-11 03:22:57",California,139,"2018-01-11 03:57:58","Rite Aid #05794 Delano","1809 Cecil Avenue","(661) 725-1312",35.77637207135365,Delano,CA,93215,-119.23134872320588
140,140,"2018-01-11 03:25:33","Desert Hot Springs",California,2,"2018-01-11 03:22:57",California,140,"2018-01-11 03:58:08","Rite Aid #05679 Desert Hot Springs","12900 Palm Drive","(760) 251-3866",33.954664,"Desert Hot Springs",CA,92240,-116.500762
141,141,"2018-01-11 03:25:33","Diamond Bar",California,2,"2018-01-11 03:22:57",California,141,"2018-01-11 03:58:15","Rite Aid #05603 Diamond Bar","2797 South Diamond Bar Blvd","(909) 595-0912",33.975225,"Diamond Bar",CA,91765,-117.838898
142,142,"2018-01-11 03:25:33",Dinuba,California,2,"2018-01-11 03:22:57",California
143,143,"2018-01-11 03:25:33",Downey,California,2,"2018-01-11 03:22:57",California,143,"2018-01-11 03:58:29","Rite Aid #05466 Downey","7859 Firestone Boulevard","(562) 869-8890",33.94428,Downey,CA,90241,-118.140108
144,144,"2018-01-11 03:25:33",Duarte,California,2,"2018-01-11 03:22:57",California,144,"2018-01-11 03:58:34","Rite Aid #05528 Duarte","1335 East Huntington Drive","(626) 359-1316",34.140373,Duarte,CA,91010,-117.975745
145,145,"2018-01-11 03:25:33","El Cajon",California,2,"2018-01-11 03:22:57",California
146,146,"2018-01-11 03:25:33","El Centro",California,2,"2018-01-11 03:22:57",California,146,"2018-01-11 03:58:53","Rite Aid #05680 El Centro","1501 West Main Street","(760) 352-5731",32.792122,"El Centro",CA,92243,-115.570621
147,147,"2018-01-11 03:25:33","El Segundo",California,2,"2018-01-11 03:22:57",California,147,"2018-01-11 03:58:55","Rite Aid #05470 El Segundo","220 East Grand Avenue","(310) 640-2715",33.918831,"El Segundo",CA,90245,-118.41382
148,148,"2018-01-11 03:25:33","Elk Grove",California,2,"2018-01-11 03:22:57",California
149,149,"2018-01-11 03:25:33",Encinitas,California,2,"2018-01-11 03:22:57",California
150,150,"2018-01-11 03:25:33",Encino,California,2,"2018-01-11 03:22:57",California,150,"2018-01-11 03:59:21","Rite Aid - Closed #05546 Encino","17864 Ventura Boulevard","(818) 345-5474",34.162825,Encino,CA,91316,-118.522174
151,151,"2018-01-11 03:25:33",Escalon,California,2,"2018-01-11 03:22:57",California,151,"2018-01-11 03:59:27","Rite Aid #06434 Escalon","1710 California Street","(209) 838-3524",37.796987838579156,Escalon,CA,95320,-120.9919086098671
152,152,"2018-01-11 03:25:33",Escondido,California,2,"2018-01-11 03:22:57",California
153,153,"2018-01-11 03:25:33",Eureka,California,2,"2018-01-11 03:22:57",California,153,"2018-01-11 03:59:55","Rite Aid #06036 Eureka","411 Harris Street","(707) 443-8039",40.781031,Eureka,CA,95503,-124.16437
154,154,"2018-01-11 03:25:33",Exeter,California,2,"2018-01-11 03:22:57",California,154,"2018-01-11 04:00:01","Rite Aid #05795 Exeter","1051 West Visalia Road","(559) 592-4901",36.2983606993034,Exeter,CA,93221,-119.15471076965332
155,155,"2018-01-11 03:25:33",Fallbrook,California,2,"2018-01-11 03:22:57",California,155,"2018-01-11 04:00:31","Rite Aid #05631 Fallbrook","1331 South Mission Road","(760) 728-6063",33.368722,Fallbrook,CA,92028,-117.251707
156,156,"2018-01-11 03:25:33",Farmersville,California,2,"2018-01-11 03:22:57",California,156,"2018-01-11 04:00:37","Rite Aid #06764 Farmersville","1710 N Farmersville Blvd","(559) 747-3317",36.312711,Farmersville,CA,93223,-119.2063604
157,157,"2018-01-11 03:25:33",Felton,California,2,"2018-01-11 03:22:57",California,157,"2018-01-11 04:00:42","Rite Aid #05968 Felton","6123 Highway 9","(831) 335-7252",37.050067,Felton,CA,95018,-122.073765
158,158,"2018-01-11 03:25:33",Fillmore,California,2,"2018-01-11 03:22:57",California,158,"2018-01-11 04:00:48","Rite Aid #05777 Fillmore","600 West Ventura Street","(805) 524-9792",34.3952127,Fillmore,CA,93015,-118.9153014
159,159,"2018-01-11 03:25:33",Folsom,California,2,"2018-01-11 03:22:57",California,159,"2018-01-11 04:00:56","Rite Aid #06266 Folsom","526 East Bidwell Street","(916) 984-7749",38.673478,Folsom,CA,95630,-121.164013
160,160,"2018-01-11 03:25:33",Fontana,California,2,"2018-01-11 03:22:57",California
161,161,"2018-01-11 03:25:33","Fort Bragg",California,2,"2018-01-11 03:22:57",California,161,"2018-01-11 04:01:07","Rite Aid #06028 Fort Bragg","490 South Main Street","(707) 964-1848",39.436866,"Fort Bragg",CA,95437,-123.805011
162,162,"2018-01-11 03:25:33",Fortuna,California,2,"2018-01-11 03:22:57",California,162,"2018-01-11 04:01:12","Rite Aid #06041 Fortuna","725 South Fortuna Boulevard","(707) 725-9314",40.583028,Fortuna,CA,95540,-124.144853
163,163,"2018-01-11 03:25:33","Fountain Valley",California,2,"2018-01-11 03:22:57",California
164,164,"2018-01-11 03:25:33",Freedom,California,2,"2018-01-11 03:22:57",California,164,"2018-01-11 04:01:45","Rite Aid #05969 Freedom","1988 Freedom Boulevard","(831) 724-5104",36.93886901860866,Freedom,CA,95019,-121.7756956815719
165,165,"2018-01-11 03:25:33",Fremont,California,2,"2018-01-11 03:22:57",California,165,"2018-01-11 04:01:48","Rite Aid #05918 Fremont","3744 Mowry Avenue","(510) 796-2497",37.549905,Fremont,CA,94538,-121.985928
166,166,"2018-01-11 03:25:33",Fresno,California,2,"2018-01-11 03:22:57",California
167,167,"2018-01-11 03:25:33",Fullerton,California,2,"2018-01-11 03:22:57",California,167,"2018-01-11 04:01:59","Rite Aid #06472 Fullerton","1035 W Orangethorpe Avenue","(714) 773-9615",33.85974514227587,Fullerton,CA,92833,-117.94318109750748
168,168,"2018-01-11 03:25:33",Galt,California,2,"2018-01-11 03:22:57",California,168,"2018-01-11 04:02:04","Rite Aid #06547 Galt","10570 Twin Cities Road","(209) 744-1380",38.290661,Galt,CA,95632,-121.298658
169,169,"2018-01-11 03:25:33","Garden Grove",California,2,"2018-01-11 03:22:57",California
170,170,"2018-01-11 03:25:33",Gardena,California,2,"2018-01-11 03:22:57",California,170,"2018-01-11 04:02:18","Rite Aid #05471 Gardena","1208 West Redondo Beach Blvd","(310) 323-4768",33.891874,Gardena,CA,90247,-118.296349
171,171,"2018-01-11 03:25:33",Gilroy,California,2,"2018-01-11 03:22:57",California,171,"2018-01-11 04:02:23","Rite Aid #05970 Gilroy","360 East 10th Street","(408) 848-2328",37.000198,Gilroy,CA,95020,-121.56097
172,172,"2018-01-11 03:25:33",Glendale,California,2,"2018-01-11 03:22:57",California
173,173,"2018-01-11 03:25:33",Goleta,California,2,"2018-01-11 03:22:57",California,173,"2018-01-11 04:02:33","Rite Aid #05791 Goleta","199 North Fairview Avenue","(805) 964-9892",34.442989,Goleta,CA,93117,-119.831498
174,174,"2018-01-11 03:25:33","Granada Hills",California,2,"2018-01-11 03:22:57",California,174,"2018-01-11 04:02:37","Rite Aid #05553 Granada Hills","10823 Zelzah Avenue","(818) 360-8411",34.26678845700449,"Granada Hills",CA,91344,-118.52386057376862
175,175,"2018-01-11 03:25:33","Grass Valley",California,2,"2018-01-11 03:22:57",California,175,"2018-01-11 04:02:45","Rite Aid #06089 Grass Valley","720 Sutton Way","(530) 273-7399",39.234093,"Grass Valley",CA,95945,-121.035475
176,176,"2018-01-11 03:25:33",Greenfield,California,2,"2018-01-11 03:22:57",California,176,"2018-01-11 04:02:50","Rite Aid #05879 Greenfield","650 Walnut Avenue","(831) 674-5565",36.3287425,Greenfield,CA,93927,-121.2468836
177,177,"2018-01-11 03:25:33",Gridley,California,2,"2018-01-11 03:22:57",California,177,"2018-01-11 04:02:55","Rite Aid #06090 Gridley","1583 Highway 99","(530) 846-3334",39.3627738,Gridley,CA,95948,-121.6885517
178,178,"2018-01-11 03:25:33","Hacienda Heights",California,2,"2018-01-11 03:22:57",California,178,"2018-01-11 04:03:01","Rite Aid #05592 Hacienda Heights","2060 South Hacienda Boulevard","(626) 333-5642",33.99559,"Hacienda Heights",CA,91745,-117.966412
179,179,"2018-01-11 03:25:33","Half Moon Bay",California,2,"2018-01-11 03:22:57",California,179,"2018-01-11 04:03:04","Rite Aid #05885 Half Moon Bay","170 San Mateo Road","(650) 726-2511",37.46861,"Half Moon Bay",CA,94019,-122.431097
180,180,"2018-01-11 03:25:33",Hanford,California,2,"2018-01-11 03:22:57",California
181,181,"2018-01-11 03:25:33","Harbor City",California,2,"2018-01-11 03:22:57",California,181,"2018-01-11 04:03:19","Rite Aid #06413 Harbor City","1207 Pacific Coast Highway","(310) 325-4362",33.790589,"Harbor City",CA,90710,-118.298177
182,182,"2018-01-11 03:25:33",Hayward,California,2,"2018-01-11 03:22:57",California,182,"2018-01-11 04:03:31","Rite Aid #05920 Hayward","31091 Mission Boulevard","(510) 489-4581",37.618972,Hayward,CA,94544,-122.036868
183,183,"2018-01-11 03:25:33",Healdsburg,California,2,"2018-01-11 03:22:57",California,183,"2018-01-11 04:03:36","Rite Aid #06029 Healdsburg","525 Healdsburg Avenue","(707) 431-1119",38.6151036,Healdsburg,CA,95448,-122.8729349
184,184,"2018-01-11 03:25:33",Hemet,California,2,"2018-01-11 03:22:57",California
185,185,"2018-01-11 03:25:33",Hercules,California,2,"2018-01-11 03:22:57",California,185,"2018-01-11 04:03:46","Rite Aid #05923 Hercules","1560 Sycamore Avenue","(510) 799-1252",38.008991838729145,Hercules,CA,94547,-122.27223694324493
186,186,"2018-01-11 03:25:33",Hesperia,California,2,"2018-01-11 03:22:57",California
187,187,"2018-01-11 03:25:33",Hollister,California,2,"2018-01-11 03:22:57",California,187,"2018-01-11 04:04:02","Rite Aid #05971 Hollister","1701 Airline Highway","(831) 636-1692",36.838425,Hollister,CA,95023,-121.389266
188,188,"2018-01-11 03:25:33",Hollywood,California,2,"2018-01-11 03:22:57",California,188,"2018-01-11 04:04:09","Rite Aid #05438 Hollywood","6130 W Sunset Boulevard","(323) 467-4201",34.097501,Hollywood,CA,90028,-118.32343
189,189,"2018-01-11 03:25:33","Huntington Beach",California,2,"2018-01-11 03:22:57",California,189,"2018-01-11 04:04:15","Rite Aid #05745 Huntington Beach","5881 Warner Avenue","(714) 846-5291",33.715993,"Huntington Beach",CA,92649,-118.025638
190,190,"2018-01-11 03:25:33","Huntington Park",California,2,"2018-01-11 03:22:57",California,190,"2018-01-11 04:04:34","Rite Aid #05475 Huntington Park","6360 Pacific Boulevard","(323) 585-4321",33.98199,"Huntington Park",CA,90255,-118.224753
191,191,"2018-01-11 03:25:33",Indio,California,2,"2018-01-11 03:22:57",California
192,192,"2018-01-11 03:25:33",Inglewood,California,2,"2018-01-11 03:22:57",California,192,"2018-01-11 04:04:46","Rite Aid #05486 Inglewood","11340 Crenshaw Boulevard","(323) 757-2811",33.931344,Inglewood,CA,90303,-118.324674
193,193,"2018-01-11 03:25:33",Irvine,California,2,"2018-01-11 03:22:57",California
194,194,"2018-01-11 03:25:33",Kerman,California,2,"2018-01-11 03:22:57",California,194,"2018-01-11 04:04:54","Rite Aid #05853 Kerman","456 S Madera Avenue","(559) 846-7115",36.72853171609392,Kerman,CA,93630,-120.05983024835587
195,195,"2018-01-11 03:25:33","King City",California,2,"2018-01-11 03:22:57",California,195,"2018-01-11 04:04:57","Rite Aid #05880 King City","540 Canal Street","(831) 385-0886",36.20427,"King City",CA,93930,-121.131297
196,196,"2018-01-11 03:25:33","Kings Beach",California,2,"2018-01-11 03:22:57",California,196,"2018-01-11 04:05:01","Rite Aid #06106 Kings Beach","8245 North Lake Boulevard","(530) 546-2523",39.2378686,"Kings Beach",CA,96143,-120.0276982
197,197,"2018-01-11 03:25:33","La Canada Flintridge",California,2,"2018-01-11 03:22:57",California,197,"2018-01-11 04:05:03","Rite Aid #05529 La Canada Flintridge","647 Foothill Boulevard","(818) 790-5577",34.202433,"La Canada Flintridge",CA,91011,-118.192412
198,198,"2018-01-11 03:25:33","La Crescenta",California,2,"2018-01-11 03:22:57",California,198,"2018-01-11 04:05:09","Rite Aid #05538 La Crescenta","2647 West Foothill Boulevard","(818) 248-1016",34.22286,"La Crescenta",CA,91214,-118.235804
199,199,"2018-01-11 03:25:33","La Habra",California,2,"2018-01-11 03:22:57",California
200,200,"2018-01-11 03:25:33","La Mirada",California,2,"2018-01-11 03:22:57",California,200,"2018-01-11 04:05:18","Rite Aid #06333 La Mirada","15800 Imperial Highway","(562) 902-5538",33.91691,"La Mirada",CA,90638,-117.993868