You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Rite Aid Stores in the United Sates", "point": { "title": "By Table", "desc": "Each API function returns data from a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/by_table/city_x_rite_aid_store/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/rite_aid_stores_in_the_united_states/by_table/city_x_rite_aid_store/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.00446000000000000042243986086987206363119184970855712890625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 2799, "pages_total": 28 }, "struct": { "stem": { "0": "city_x_rite_aid_store", "1": "city", "2": "state", "3": "rite_aid_store" }, "leaf": "city_x_rite_aid_store.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city_x_rite_aid_store.id": 1, "city.id": 1, "city.ts": "2018-01-11 03:25:14", "city.title": "Abbeville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 1, "rite_aid_store.ts": "2018-01-11 03:41:14", "rite_aid_store.title": "Rite Aid #07092 Abbeville", "rite_aid_store.address_street": "514 Kirkland Street", "rite_aid_store.telephone": "(334) 585-2282", "rite_aid_store.latitude": 31.56182700000000096451913123019039630889892578125, "rite_aid_store.address_locality": "Abbeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36310, "rite_aid_store.longitude": -85.2538909999999958699845592491328716278076171875 }, "2": { "city_x_rite_aid_store.id": 2, "city.id": 2, "city.ts": "2018-01-11 03:25:14", "city.title": "Alabaster", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 2, "rite_aid_store.ts": "2018-01-11 03:41:17", "rite_aid_store.title": "Rite Aid #07001 Alabaster", "rite_aid_store.address_street": "140 Market Center Drive", "rite_aid_store.telephone": "(205) 663-4500", "rite_aid_store.latitude": 33.23699400000000281352185993455350399017333984375, "rite_aid_store.address_locality": "Alabaster", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35007, "rite_aid_store.longitude": -86.82166399999999839565134607255458831787109375 }, "3": { "city_x_rite_aid_store.id": 3, "city.id": 3, "city.ts": "2018-01-11 03:25:14", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 3, "rite_aid_store.ts": "2018-01-11 03:41:24", "rite_aid_store.title": "Rite Aid #07002 Alexander City", "rite_aid_store.address_street": "4441 Highway 280", "rite_aid_store.telephone": "(256) 329-8433", "rite_aid_store.latitude": 32.91963299999999748024492873810231685638427734375, "rite_aid_store.address_locality": "Alexander City", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35010, "rite_aid_store.longitude": -85.955432000000001835360308177769184112548828125 }, "4": { "city_x_rite_aid_store.id": 4, "city.id": 4, "city.ts": "2018-01-11 03:25:14", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 4, "rite_aid_store.ts": "2018-01-11 03:41:29", "rite_aid_store.title": "Rite Aid #07095 Andalusia", "rite_aid_store.address_street": "1017 River Falls Street", "rite_aid_store.telephone": "(334) 222-9414", "rite_aid_store.latitude": 31.317395999999998679186319350264966487884521484375, "rite_aid_store.address_locality": "Andalusia", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36420, "rite_aid_store.longitude": -86.4983529999999944948285701684653759002685546875 }, "5": { "city_x_rite_aid_store.id": 5, "city.id": 5, "city.ts": "2018-01-11 03:25:14", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "6": { "city_x_rite_aid_store.id": 6, "city.id": 6, "city.ts": "2018-01-11 03:25:14", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 6, "rite_aid_store.ts": "2018-01-11 03:41:35", "rite_aid_store.title": "Rite Aid #07099 Atmore", "rite_aid_store.address_street": "506 East Church Street", "rite_aid_store.telephone": "(251) 368-8131", "rite_aid_store.latitude": 31.021491999999998512294041574932634830474853515625, "rite_aid_store.address_locality": "Atmore", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36502, "rite_aid_store.longitude": -87.487990999999993846358847804367542266845703125 }, "7": { "city_x_rite_aid_store.id": 7, "city.id": 7, "city.ts": "2018-01-11 03:25:14", "city.title": "Birmingham", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "8": { "city_x_rite_aid_store.id": 8, "city.id": 8, "city.ts": "2018-01-11 03:25:14", "city.title": "Chickasaw", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 8, "rite_aid_store.ts": "2018-01-11 03:41:46", "rite_aid_store.title": "Rite Aid #07125 Chickasaw", "rite_aid_store.address_street": "414 North Craft Highway", "rite_aid_store.telephone": "(251) 452-0531", "rite_aid_store.latitude": 30.770562999999999220790414256043732166290283203125, "rite_aid_store.address_locality": "Chickasaw", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36611, "rite_aid_store.longitude": -88.0741770000000059326339396648108959197998046875 }, "9": { "city_x_rite_aid_store.id": 9, "city.id": 9, "city.ts": "2018-01-11 03:25:14", "city.title": "Clanton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 9, "rite_aid_store.ts": "2018-01-11 03:41:53", "rite_aid_store.title": "Rite Aid #07004 Clanton", "rite_aid_store.address_street": "641 Ollie Avenue", "rite_aid_store.telephone": "(205) 755-5879", "rite_aid_store.latitude": 32.84920175971596023600795888341963291168212890625, "rite_aid_store.address_locality": "Clanton", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35045, "rite_aid_store.longitude": -86.632703840732574462890625 }, "10": { "city_x_rite_aid_store.id": 10, "city.id": 10, "city.ts": "2018-01-11 03:25:14", "city.title": "Cullman", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "11": { "city_x_rite_aid_store.id": 11, "city.id": 11, "city.ts": "2018-01-11 03:25:14", "city.title": "Dadeville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 11, "rite_aid_store.ts": "2018-01-11 03:42:05", "rite_aid_store.title": "Rite Aid #07136 Dadeville", "rite_aid_store.address_street": "459 North Broadnax Street", "rite_aid_store.telephone": "(256) 825-4242", "rite_aid_store.latitude": 32.83518099999999861893229535780847072601318359375, "rite_aid_store.address_locality": "Dadeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36853, "rite_aid_store.longitude": -85.7640779999999978144842316396534442901611328125 }, "12": { "city_x_rite_aid_store.id": 12, "city.id": 12, "city.ts": "2018-01-11 03:25:14", "city.title": "Decatur", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "13": { "city_x_rite_aid_store.id": 13, "city.id": 13, "city.ts": "2018-01-11 03:25:14", "city.title": "Dothan", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "14": { "city_x_rite_aid_store.id": 14, "city.id": 14, "city.ts": "2018-01-11 03:25:14", "city.title": "Enterprise", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 14, "rite_aid_store.ts": "2018-01-11 03:42:30", "rite_aid_store.title": "Rite Aid #07093 Enterprise", "rite_aid_store.address_street": "903 Rucker Boulevard", "rite_aid_store.telephone": "(334) 393-4440", "rite_aid_store.latitude": 31.32376824799622028194789891131222248077392578125, "rite_aid_store.address_locality": "Enterprise", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36330, "rite_aid_store.longitude": -85.8303987979888916015625 }, "15": { "city_x_rite_aid_store.id": 15, "city.id": 15, "city.ts": "2018-01-11 03:25:14", "city.title": "Eufaula", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 15, "rite_aid_store.ts": "2018-01-11 03:42:34", "rite_aid_store.title": "Rite Aid #04606 Eufaula", "rite_aid_store.address_street": "130 South Eufaula Avenue", "rite_aid_store.telephone": "(334) 687-7144", "rite_aid_store.latitude": 31.8918919999999985748218023218214511871337890625, "rite_aid_store.address_locality": "Eufaula", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36027, "rite_aid_store.longitude": -85.146375000000006139089236967265605926513671875 }, "16": { "city_x_rite_aid_store.id": 16, "city.id": 16, "city.ts": "2018-01-11 03:25:14", "city.title": "Fairhope", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 16, "rite_aid_store.ts": "2018-01-11 03:42:38", "rite_aid_store.title": "Rite Aid #07104 Fairhope", "rite_aid_store.address_street": "101 South Greeno Road", "rite_aid_store.telephone": "(251) 990-7172", "rite_aid_store.latitude": 30.519501999999999242163539747707545757293701171875, "rite_aid_store.address_locality": "Fairhope", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36532, "rite_aid_store.longitude": -87.8855219999999945912350085563957691192626953125 }, "17": { "city_x_rite_aid_store.id": 17, "city.id": 17, "city.ts": "2018-01-11 03:25:14", "city.title": "Florence", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "18": { "city_x_rite_aid_store.id": 18, "city.id": 18, "city.ts": "2018-01-11 03:25:14", "city.title": "Foley", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 18, "rite_aid_store.ts": "2018-01-11 03:42:49", "rite_aid_store.title": "Rite Aid #07179 Foley", "rite_aid_store.address_street": "1255 South McKenzie Street", "rite_aid_store.telephone": "(251) 971-1017", "rite_aid_store.latitude": 30.392722500000001417674866388551890850067138671875, "rite_aid_store.address_locality": "Foley", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36535, "rite_aid_store.longitude": -87.6825304999999985966496751643717288970947265625 }, "19": { "city_x_rite_aid_store.id": 19, "city.id": 19, "city.ts": "2018-01-11 03:25:14", "city.title": "Fort Payne", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 19, "rite_aid_store.ts": "2018-01-11 03:42:53", "rite_aid_store.title": "Rite Aid #07060 Fort Payne", "rite_aid_store.address_street": "1303 Gault Avenue North", "rite_aid_store.telephone": "(256) 845-6338", "rite_aid_store.latitude": 34.45294392199293298517659422941505908966064453125, "rite_aid_store.address_locality": "Fort Payne", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35967, "rite_aid_store.longitude": -85.7114803791046142578125 }, "20": { "city_x_rite_aid_store.id": 20, "city.id": 20, "city.ts": "2018-01-11 03:25:14", "city.title": "Fultondale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 20, "rite_aid_store.ts": "2018-01-11 03:43:01", "rite_aid_store.title": "Rite Aid #07014 Fultondale", "rite_aid_store.address_street": "1713 US Hwy 31 N", "rite_aid_store.telephone": "(205) 841-3815", "rite_aid_store.latitude": 33.6116260000000011132215149700641632080078125, "rite_aid_store.address_locality": "Fultondale", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35068, "rite_aid_store.longitude": -86.7962409999999948695403872989118099212646484375 }, "21": { "city_x_rite_aid_store.id": 21, "city.id": 21, "city.ts": "2018-01-11 03:25:14", "city.title": "Gardendale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 21, "rite_aid_store.ts": "2018-01-11 03:43:06", "rite_aid_store.title": "Rite Aid #07367 Gardendale", "rite_aid_store.address_street": "1018 Main St", "rite_aid_store.telephone": "(205) 631-8707", "rite_aid_store.latitude": 33.65344499999999783312887302599847316741943359375, "rite_aid_store.address_locality": "Gardendale", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35071, "rite_aid_store.longitude": -86.8126290000000011559677659533917903900146484375 }, "22": { "city_x_rite_aid_store.id": 22, "city.id": 22, "city.ts": "2018-01-11 03:25:14", "city.title": "Gulf Shores", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 22, "rite_aid_store.ts": "2018-01-11 03:44:20", "rite_aid_store.title": "Rite Aid #07180 Gulf Shores", "rite_aid_store.address_street": "1527 Highway 59 South", "rite_aid_store.telephone": "(251) 968-6119", "rite_aid_store.latitude": 30.265539000000000413592715631239116191864013671875, "rite_aid_store.address_locality": "Gulf Shores", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36542, "rite_aid_store.longitude": -87.690236999999996214683051221072673797607421875 }, "23": { "city_x_rite_aid_store.id": 23, "city.id": 23, "city.ts": "2018-01-11 03:25:14", "city.title": "Hartselle", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 23, "rite_aid_store.ts": "2018-01-11 03:44:26", "rite_aid_store.title": "Rite Aid #07049 Hartselle", "rite_aid_store.address_street": "241 Highway 31 SW", "rite_aid_store.telephone": "(256) 773-6561", "rite_aid_store.latitude": 34.44071900000000141517375595867633819580078125, "rite_aid_store.address_locality": "Hartselle", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35640, "rite_aid_store.longitude": -86.9433800000000047702997107990086078643798828125 }, "24": { "city_x_rite_aid_store.id": 24, "city.id": 24, "city.ts": "2018-01-11 03:25:14", "city.title": "Hazel Green", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 24, "rite_aid_store.ts": "2018-01-11 03:44:29", "rite_aid_store.title": "Rite Aid #01146 Hazel Green", "rite_aid_store.address_street": "14450 Highway 231/431 North", "rite_aid_store.telephone": "(256) 828-5133", "rite_aid_store.latitude": 34.9401950000000027785063139162957668304443359375, "rite_aid_store.address_locality": "Hazel Green", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35750, "rite_aid_store.longitude": -86.57071600000000444197212345898151397705078125 }, "25": { "city_x_rite_aid_store.id": 25, "city.id": 25, "city.ts": "2018-01-11 03:25:14", "city.title": "Hoover", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 25, "rite_aid_store.ts": "2018-01-11 03:44:31", "rite_aid_store.title": "Rite Aid #07370 Hoover", "rite_aid_store.address_street": "1615 Montgomery Highway", "rite_aid_store.telephone": "(205) 823-6091", "rite_aid_store.latitude": 33.3977459999999979345375322736799716949462890625, "rite_aid_store.address_locality": "Hoover", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35216, "rite_aid_store.longitude": -86.804767999999995709003997035324573516845703125 }, "26": { "city_x_rite_aid_store.id": 26, "city.id": 26, "city.ts": "2018-01-11 03:25:14", "city.title": "Hueytown", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 26, "rite_aid_store.ts": "2018-01-11 03:44:35", "rite_aid_store.title": "Rite Aid #07003 Hueytown", "rite_aid_store.address_street": "220 Forest Road", "rite_aid_store.telephone": "(205) 491-1894", "rite_aid_store.latitude": 33.450029999999998153725755400955677032470703125, "rite_aid_store.address_locality": "Hueytown", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35023, "rite_aid_store.longitude": -86.9858540000000033387550502084195613861083984375 }, "27": { "city_x_rite_aid_store.id": 27, "city.id": 27, "city.ts": "2018-01-11 03:25:14", "city.title": "Huntsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "28": { "city_x_rite_aid_store.id": 28, "city.id": 28, "city.ts": "2018-01-11 03:25:14", "city.title": "Luverne", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 28, "rite_aid_store.ts": "2018-01-11 03:44:47", "rite_aid_store.title": "Rite Aid #07066 Luverne", "rite_aid_store.address_street": "1402 South Forest Avenue", "rite_aid_store.telephone": "(334) 335-6188", "rite_aid_store.latitude": 31.696968860839195514245147933252155780792236328125, "rite_aid_store.address_locality": "Luverne", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36049, "rite_aid_store.longitude": -86.26677274703985176529386080801486968994140625 }, "29": { "city_x_rite_aid_store.id": 29, "city.id": 29, "city.ts": "2018-01-11 03:25:14", "city.title": "Madison", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "30": { "city_x_rite_aid_store.id": 30, "city.id": 30, "city.ts": "2018-01-11 03:25:14", "city.title": "Meridianville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 30, "rite_aid_store.ts": "2018-01-11 03:45:09", "rite_aid_store.title": "Rite Aid #07055 Meridianville", "rite_aid_store.address_street": "12290 Hwy 231-431 North", "rite_aid_store.telephone": "(256) 828-1000", "rite_aid_store.latitude": 34.87031300000000300087776849977672100067138671875, "rite_aid_store.address_locality": "Meridianville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35759, "rite_aid_store.longitude": -86.569424999999995407051756046712398529052734375 }, "31": { "city_x_rite_aid_store.id": 31, "city.id": 31, "city.ts": "2018-01-11 03:25:14", "city.title": "Millbrook", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 31, "rite_aid_store.ts": "2018-01-11 03:45:17", "rite_aid_store.title": "Rite Aid #07067 Millbrook", "rite_aid_store.address_street": "3741 Highway 14", "rite_aid_store.telephone": "(334) 285-6648", "rite_aid_store.latitude": 32.5179049999999989495336194522678852081298828125, "rite_aid_store.address_locality": "Millbrook", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36054, "rite_aid_store.longitude": -86.374763999999998986822902224957942962646484375 }, "32": { "city_x_rite_aid_store.id": 32, "city.id": 32, "city.ts": "2018-01-11 03:25:14", "city.title": "Mobile", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "33": { "city_x_rite_aid_store.id": 33, "city.id": 33, "city.ts": "2018-01-11 03:25:14", "city.title": "Monroeville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 33, "rite_aid_store.ts": "2018-01-11 03:45:29", "rite_aid_store.title": "Rite Aid #07097 Monroeville", "rite_aid_store.address_street": "1818 South Alabama Avenue", "rite_aid_store.telephone": "(251) 743-3253", "rite_aid_store.latitude": 31.50061075706070568003269727341830730438232421875, "rite_aid_store.address_locality": "Monroeville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36460, "rite_aid_store.longitude": -87.320426263077024486847221851348876953125 }, "34": { "city_x_rite_aid_store.id": 34, "city.id": 34, "city.ts": "2018-01-11 03:25:14", "city.title": "Montgomery", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "35": { "city_x_rite_aid_store.id": 35, "city.id": 35, "city.ts": "2018-01-11 03:25:14", "city.title": "Mountain Brook", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 35, "rite_aid_store.ts": "2018-01-11 03:45:42", "rite_aid_store.title": "Rite Aid #07021 Mountain Brook", "rite_aid_store.address_street": "2711 Culver Road", "rite_aid_store.telephone": "(205) 879-3466", "rite_aid_store.latitude": 33.48551499999999947476680972613394260406494140625, "rite_aid_store.address_locality": "Mountain Brook", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35223, "rite_aid_store.longitude": -86.7734180000000066002030507661402225494384765625 }, "36": { "city_x_rite_aid_store.id": 36, "city.id": 36, "city.ts": "2018-01-11 03:25:14", "city.title": "Northport", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 36, "rite_aid_store.ts": "2018-01-11 03:45:48", "rite_aid_store.title": "Rite Aid #07041 Northport", "rite_aid_store.address_street": "2300 McFarland Blvd", "rite_aid_store.telephone": "(205) 339-2700", "rite_aid_store.latitude": 33.24095899999999659257809980772435665130615234375, "rite_aid_store.address_locality": "Northport", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35476, "rite_aid_store.longitude": -87.5800770000000028403519536368548870086669921875 }, "37": { "city_x_rite_aid_store.id": 37, "city.id": 37, "city.ts": "2018-01-11 03:25:14", "city.title": "Opp", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 37, "rite_aid_store.ts": "2018-01-11 03:45:51", "rite_aid_store.title": "Rite Aid #07098 Opp", "rite_aid_store.address_street": "509 East Cummings Avenue", "rite_aid_store.telephone": "(334) 493-6563", "rite_aid_store.latitude": 31.279635138364227486817981116473674774169921875, "rite_aid_store.address_locality": "Opp", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36467, "rite_aid_store.longitude": -86.2486302852630615234375 }, "38": { "city_x_rite_aid_store.id": 38, "city.id": 38, "city.ts": "2018-01-11 03:25:14", "city.title": "Orange Beach", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 38, "rite_aid_store.ts": "2018-01-11 03:46:00", "rite_aid_store.title": "Rite Aid #07108 Orange Beach", "rite_aid_store.address_street": "25801 Perdido Beach Boulevard", "rite_aid_store.telephone": "(251) 981-7019", "rite_aid_store.latitude": 30.270414104278618339094464317895472049713134765625, "rite_aid_store.address_locality": "Orange Beach", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36561, "rite_aid_store.longitude": -87.5854218006134033203125 }, "39": { "city_x_rite_aid_store.id": 39, "city.id": 39, "city.ts": "2018-01-11 03:25:14", "city.title": "Owens Cross Roads", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 39, "rite_aid_store.ts": "2018-01-11 03:46:04", "rite_aid_store.title": "Rite Aid #07056 Owens Cross Roads", "rite_aid_store.address_street": "6707 US Hwy 431", "rite_aid_store.telephone": "(256) 533-5883", "rite_aid_store.latitude": 34.65955000000000296722646453417837619781494140625, "rite_aid_store.address_locality": "Owens Cross Roads", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35763, "rite_aid_store.longitude": -86.4811499999999995225152815692126750946044921875 }, "40": { "city_x_rite_aid_store.id": 40, "city.id": 40, "city.ts": "2018-01-11 03:25:14", "city.title": "Oxford", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "41": { "city_x_rite_aid_store.id": 41, "city.id": 41, "city.ts": "2018-01-11 03:25:14", "city.title": "Pelham", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 41, "rite_aid_store.ts": "2018-01-11 03:46:15", "rite_aid_store.title": "Rite Aid #07025 Pelham", "rite_aid_store.address_street": "2101 Pelham Parkway", "rite_aid_store.telephone": "(205) 985-4995", "rite_aid_store.latitude": 33.34567200000000042336978367529809474945068359375, "rite_aid_store.address_locality": "Pelham", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35124, "rite_aid_store.longitude": -86.795175999999997884515323676168918609619140625 }, "42": { "city_x_rite_aid_store.id": 42, "city.id": 42, "city.ts": "2018-01-11 03:25:14", "city.title": "Pinson", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 42, "rite_aid_store.ts": "2018-01-11 03:46:21", "rite_aid_store.title": "Rite Aid #07010 Pinson", "rite_aid_store.address_street": "4689 Pinson Blvd", "rite_aid_store.telephone": "(205) 680-2751", "rite_aid_store.latitude": 33.69481799999999793726601637899875640869140625, "rite_aid_store.address_locality": "Pinson", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35126, "rite_aid_store.longitude": -86.6810200000000037334757507778704166412353515625 }, "43": { "city_x_rite_aid_store.id": 43, "city.id": 43, "city.ts": "2018-01-11 03:25:14", "city.title": "Prattville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 43, "rite_aid_store.ts": "2018-01-11 03:46:26", "rite_aid_store.title": "Rite Aid #07172 Prattville", "rite_aid_store.address_street": "606 South Memorial Drive", "rite_aid_store.telephone": "(334) 365-1600", "rite_aid_store.latitude": 32.46121260000000319223545375280082225799560546875, "rite_aid_store.address_locality": "Prattville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36067, "rite_aid_store.longitude": -86.4515937000000036505298339761793613433837890625 }, "44": { "city_x_rite_aid_store.id": 44, "city.id": 44, "city.ts": "2018-01-11 03:25:14", "city.title": "Prichard", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 44, "rite_aid_store.ts": "2018-01-11 03:46:33", "rite_aid_store.title": "Rite Aid #07126 Prichard", "rite_aid_store.address_street": "4739 Saint Stephens Road", "rite_aid_store.telephone": "(251) 457-6666", "rite_aid_store.latitude": 30.7666329999999987876435625366866588592529296875, "rite_aid_store.address_locality": "Prichard", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36613, "rite_aid_store.longitude": -88.1318270000000012487362255342304706573486328125 }, "45": { "city_x_rite_aid_store.id": 45, "city.id": 45, "city.ts": "2018-01-11 03:25:14", "city.title": "Rainsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 45, "rite_aid_store.ts": "2018-01-11 03:46:38", "rite_aid_store.title": "Rite Aid #07062 Rainsville", "rite_aid_store.address_street": "42 McCurdy Avenue N", "rite_aid_store.telephone": "(256) 638-4414", "rite_aid_store.latitude": 34.49417100000000147019818541593849658966064453125, "rite_aid_store.address_locality": "Rainsville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35986, "rite_aid_store.longitude": -85.8465326999999973622834659181535243988037109375 }, "46": { "city_x_rite_aid_store.id": 46, "city.id": 46, "city.ts": "2018-01-11 03:25:14", "city.title": "Robertsdale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 46, "rite_aid_store.ts": "2018-01-11 03:46:43", "rite_aid_store.title": "Rite Aid #07109 Robertsdale", "rite_aid_store.address_street": "21951 State Hwy 59 S", "rite_aid_store.telephone": "(251) 947-5777", "rite_aid_store.latitude": 30.5451920000000001209627953357994556427001953125, "rite_aid_store.address_locality": "Robertsdale", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36567, "rite_aid_store.longitude": -87.709834000000000742147676646709442138671875 }, "47": { "city_x_rite_aid_store.id": 47, "city.id": 47, "city.ts": "2018-01-11 03:25:14", "city.title": "Saraland", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 47, "rite_aid_store.ts": "2018-01-11 03:46:50", "rite_aid_store.title": "Rite Aid #07181 Saraland", "rite_aid_store.address_street": "13 Shelton Beach Road", "rite_aid_store.telephone": "(251) 675-7094", "rite_aid_store.latitude": 30.823187999999998254452293622307479381561279296875, "rite_aid_store.address_locality": "Saraland", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36571, "rite_aid_store.longitude": -88.071203999999994493919075466692447662353515625 }, "48": { "city_x_rite_aid_store.id": 48, "city.id": 48, "city.ts": "2018-01-11 03:25:14", "city.title": "Semmes", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 48, "rite_aid_store.ts": "2018-01-11 03:46:52", "rite_aid_store.title": "Rite Aid #07111 Semmes", "rite_aid_store.address_street": "7880 Moffett Road", "rite_aid_store.telephone": "(251) 645-1983", "rite_aid_store.latitude": 30.76458099999999973306330502964556217193603515625, "rite_aid_store.address_locality": "Semmes", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36575, "rite_aid_store.longitude": -88.2272009999999937690517981536686420440673828125 }, "49": { "city_x_rite_aid_store.id": 49, "city.id": 49, "city.ts": "2018-01-11 03:25:14", "city.title": "Sheffield", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 49, "rite_aid_store.ts": "2018-01-11 03:46:58", "rite_aid_store.title": "Rite Aid #07051 Sheffield", "rite_aid_store.address_street": "805 South Montgomery Avenue", "rite_aid_store.telephone": "(256) 383-1970", "rite_aid_store.latitude": 34.74990389140352675667600124143064022064208984375, "rite_aid_store.address_locality": "Sheffield", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35660, "rite_aid_store.longitude": -87.6981215254272683523595333099365234375 }, "50": { "city_x_rite_aid_store.id": 50, "city.id": 50, "city.ts": "2018-01-11 03:25:14", "city.title": "Spanish Fort", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 50, "rite_aid_store.ts": "2018-01-11 03:47:01", "rite_aid_store.title": "Rite Aid #07178 Spanish Fort", "rite_aid_store.address_street": "6530 Spanish Fort Blvd", "rite_aid_store.telephone": "(251) 626-0015", "rite_aid_store.latitude": 30.667400900000000518730303156189620494842529296875, "rite_aid_store.address_locality": "Spanish Fort", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36527, "rite_aid_store.longitude": -87.910482900000005201945896260440349578857421875 }, "51": { "city_x_rite_aid_store.id": 51, "city.id": 51, "city.ts": "2018-01-11 03:25:14", "city.title": "Sylacauga", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 51, "rite_aid_store.ts": "2018-01-11 03:47:07", "rite_aid_store.title": "Rite Aid #07011 Sylacauga", "rite_aid_store.address_street": "1 North Broadway Avenue", "rite_aid_store.telephone": "(256) 245-7474", "rite_aid_store.latitude": 33.167716149919414192481781356036663055419921875, "rite_aid_store.address_locality": "Sylacauga", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35150, "rite_aid_store.longitude": -86.251457254411434405483305454254150390625 }, "52": { "city_x_rite_aid_store.id": 52, "city.id": 52, "city.ts": "2018-01-11 03:25:14", "city.title": "Talladega", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 52, "rite_aid_store.ts": "2018-01-11 03:47:10", "rite_aid_store.title": "Rite Aid #04617 Talladega", "rite_aid_store.address_street": "101 Asbury Street", "rite_aid_store.telephone": "(256) 362-9540", "rite_aid_store.latitude": 33.4367840000000029476723284460604190826416015625, "rite_aid_store.address_locality": "Talladega", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35160, "rite_aid_store.longitude": -86.09170399999999290230334736406803131103515625 }, "53": { "city_x_rite_aid_store.id": 53, "city.id": 53, "city.ts": "2018-01-11 03:25:14", "city.title": "Theodore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 53, "rite_aid_store.ts": "2018-01-11 03:47:14", "rite_aid_store.title": "Rite Aid #07182 Theodore", "rite_aid_store.address_street": "7301 Theodore-Dawes Road", "rite_aid_store.telephone": "(251) 653-9831", "rite_aid_store.latitude": 30.56229400000000140380507218651473522186279296875, "rite_aid_store.address_locality": "Theodore", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36582, "rite_aid_store.longitude": -88.2138470000000012305463314987719058990478515625 }, "54": { "city_x_rite_aid_store.id": 54, "city.id": 54, "city.ts": "2018-01-11 03:25:14", "city.title": "Thomasville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 54, "rite_aid_store.ts": "2018-01-11 03:47:17", "rite_aid_store.title": "Rite Aid #07134 Thomasville", "rite_aid_store.address_street": "33151 Highway 43", "rite_aid_store.telephone": "(334) 636-4616", "rite_aid_store.latitude": 31.923587000000001268062987946905195713043212890625, "rite_aid_store.address_locality": "Thomasville", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36784, "rite_aid_store.longitude": -87.74101799999999684587237425148487091064453125 }, "55": { "city_x_rite_aid_store.id": 55, "city.id": 55, "city.ts": "2018-01-11 03:25:14", "city.title": "Troy", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 55, "rite_aid_store.ts": "2018-01-11 03:47:20", "rite_aid_store.title": "Rite Aid #07069 Troy", "rite_aid_store.address_street": "115 Southland Village S/C", "rite_aid_store.telephone": "(334) 566-6541", "rite_aid_store.latitude": 31.784431999999998907924236846156418323516845703125, "rite_aid_store.address_locality": "Troy", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 36079, "rite_aid_store.longitude": -85.966556999999994559402693994343280792236328125 }, "56": { "city_x_rite_aid_store.id": 56, "city.id": 56, "city.ts": "2018-01-11 03:25:14", "city.title": "Tuscaloosa", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama" }, "57": { "city_x_rite_aid_store.id": 57, "city.id": 57, "city.ts": "2018-01-11 03:25:14", "city.title": "Vestavia Hills", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-11 03:22:57", "state.title": "Alabama", "rite_aid_store.id": 57, "rite_aid_store.ts": "2018-01-11 03:47:34", "rite_aid_store.title": "Rite Aid #07379 Vestavia Hills", "rite_aid_store.address_street": "708 Montgomery Highway", "rite_aid_store.telephone": "(205) 979-2180", "rite_aid_store.latitude": 33.446899000000001933585735969245433807373046875, "rite_aid_store.address_locality": "Vestavia Hills", "rite_aid_store.address_region": "AL", "rite_aid_store.postal_code": 35216, "rite_aid_store.longitude": -86.7915550000000024510882212780416011810302734375 }, "58": { "city_x_rite_aid_store.id": 58, "city.id": 58, "city.ts": "2018-01-11 03:25:33", "city.title": "Agoura Hills", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 58, "rite_aid_store.ts": "2018-01-11 03:47:41", "rite_aid_store.title": "Rite Aid #05539 Agoura Hills", "rite_aid_store.address_street": "5747 Kanan Road", "rite_aid_store.telephone": "(818) 991-5258", "rite_aid_store.latitude": 34.15592500000000342197381542064249515533447265625, "rite_aid_store.address_locality": "Agoura Hills", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91301, "rite_aid_store.longitude": -118.75792400000000270665623247623443603515625 }, "59": { "city_x_rite_aid_store.id": 59, "city.id": 59, "city.ts": "2018-01-11 03:25:33", "city.title": "Alamo", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 59, "rite_aid_store.ts": "2018-01-11 03:47:49", "rite_aid_store.title": "Rite Aid #05907 Alamo", "rite_aid_store.address_street": "130 Alamo Plaza", "rite_aid_store.telephone": "(925) 820-1233", "rite_aid_store.latitude": 37.8524124999999997953636921010911464691162109375, "rite_aid_store.address_locality": "Alamo", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 94507, "rite_aid_store.longitude": -122.0354860999999999648935045115649700164794921875 }, "60": { "city_x_rite_aid_store.id": 60, "city.id": 60, "city.ts": "2018-01-11 03:25:33", "city.title": "Alhambra", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "61": { "city_x_rite_aid_store.id": 61, "city.id": 61, "city.ts": "2018-01-11 03:25:33", "city.title": "Alpine", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 61, "rite_aid_store.ts": "2018-01-11 03:48:01", "rite_aid_store.title": "Rite Aid #06225 Alpine", "rite_aid_store.address_street": "1665 Alpine Boulevard", "rite_aid_store.telephone": "(619) 659-1085", "rite_aid_store.latitude": 32.8372359543983094454233651049435138702392578125, "rite_aid_store.address_locality": "Alpine", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91901, "rite_aid_store.longitude": -116.778985716564420727081596851348876953125 }, "62": { "city_x_rite_aid_store.id": 62, "city.id": 62, "city.ts": "2018-01-11 03:25:33", "city.title": "Altadena", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 62, "rite_aid_store.ts": "2018-01-11 03:48:07", "rite_aid_store.title": "Rite Aid #05526 Altadena", "rite_aid_store.address_street": "735 East Altadena Drive", "rite_aid_store.telephone": "(626) 791-7935", "rite_aid_store.latitude": 34.19091900000000094905772130005061626434326171875, "rite_aid_store.address_locality": "Altadena", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91001, "rite_aid_store.longitude": -118.132441999999997506165527738630771636962890625 }, "63": { "city_x_rite_aid_store.id": 63, "city.id": 63, "city.ts": "2018-01-11 03:25:33", "city.title": "Alturas", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 63, "rite_aid_store.ts": "2018-01-11 03:48:16", "rite_aid_store.title": "Rite Aid #06353 Alturas", "rite_aid_store.address_street": "432 North Main Street", "rite_aid_store.telephone": "(530) 233-3113", "rite_aid_store.latitude": 41.4880950000000012778400559909641742706298828125, "rite_aid_store.address_locality": "Alturas", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 96101, "rite_aid_store.longitude": -120.541865999999998848579707555472850799560546875 }, "64": { "city_x_rite_aid_store.id": 64, "city.id": 64, "city.ts": "2018-01-11 03:25:33", "city.title": "Anaheim", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "65": { "city_x_rite_aid_store.id": 65, "city.id": 65, "city.ts": "2018-01-11 03:25:33", "city.title": "Anderson", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 65, "rite_aid_store.ts": "2018-01-11 03:48:41", "rite_aid_store.title": "Rite Aid #06100 Anderson", "rite_aid_store.address_street": "3095 McMurray Drive", "rite_aid_store.telephone": "(530) 365-5753", "rite_aid_store.latitude": 40.456401999999997087797964923083782196044921875, "rite_aid_store.address_locality": "Anderson", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 96007, "rite_aid_store.longitude": -122.2935460000000063018887885846197605133056640625 }, "66": { "city_x_rite_aid_store.id": 66, "city.id": 66, "city.ts": "2018-01-11 03:25:33", "city.title": "Angels Camp", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 66, "rite_aid_store.ts": "2018-01-11 03:49:23", "rite_aid_store.title": "Rite Aid #05999 Angels Camp", "rite_aid_store.address_street": "230 South Main Street", "rite_aid_store.telephone": "(209) 736-4623", "rite_aid_store.latitude": 38.07927300000000059299054555594921112060546875, "rite_aid_store.address_locality": "Angels Camp", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 95222, "rite_aid_store.longitude": -120.5562680000000028712747734971344470977783203125 }, "67": { "city_x_rite_aid_store.id": 67, "city.id": 67, "city.ts": "2018-01-11 03:25:33", "city.title": "Antelope", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 67, "rite_aid_store.ts": "2018-01-11 03:49:24", "rite_aid_store.title": "Rite Aid #06086 Antelope", "rite_aid_store.address_street": "4300 Elverta Road", "rite_aid_store.telephone": "(916) 729-6763", "rite_aid_store.latitude": 38.7127789999999976089384290389716625213623046875, "rite_aid_store.address_locality": "Antelope", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 95843, "rite_aid_store.longitude": -121.3633540000000010650182957760989665985107421875 }, "68": { "city_x_rite_aid_store.id": 68, "city.id": 68, "city.ts": "2018-01-11 03:25:33", "city.title": "Antioch", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "69": { "city_x_rite_aid_store.id": 69, "city.id": 69, "city.ts": "2018-01-11 03:25:33", "city.title": "Apple Valley", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "70": { "city_x_rite_aid_store.id": 70, "city.id": 70, "city.ts": "2018-01-11 03:25:33", "city.title": "Aptos", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 70, "rite_aid_store.ts": "2018-01-11 03:49:42", "rite_aid_store.title": "Rite Aid #05965 Aptos", "rite_aid_store.address_street": "80 Rancho Del Mar", "rite_aid_store.telephone": "(831) 688-6417", "rite_aid_store.latitude": 36.9771989999999988185663823969662189483642578125, "rite_aid_store.address_locality": "Aptos", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 95003, "rite_aid_store.longitude": -121.9074659999999994397512637078762054443359375 }, "71": { "city_x_rite_aid_store.id": 71, "city.id": 71, "city.ts": "2018-01-11 03:25:33", "city.title": "Arcadia", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 71, "rite_aid_store.ts": "2018-01-11 03:49:47", "rite_aid_store.title": "Rite Aid #06300 Arcadia", "rite_aid_store.address_street": "165 E Foothill Boulevard", "rite_aid_store.telephone": "(626) 305-9112", "rite_aid_store.latitude": 34.15219830000000200698195840232074260711669921875, "rite_aid_store.address_locality": "Arcadia", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91006, "rite_aid_store.longitude": -118.02597919999999476203811354935169219970703125 }, "72": { "city_x_rite_aid_store.id": 72, "city.id": 72, "city.ts": "2018-01-11 03:25:33", "city.title": "Arroyo Grande", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "73": { "city_x_rite_aid_store.id": 73, "city.id": 73, "city.ts": "2018-01-11 03:25:33", "city.title": "Atascadero", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 73, "rite_aid_store.ts": "2018-01-11 03:50:01", "rite_aid_store.title": "Rite Aid #05827 Atascadero", "rite_aid_store.address_street": "7025 El Camino Real", "rite_aid_store.telephone": "(805) 466-8722", "rite_aid_store.latitude": 35.486390000000000100044417195022106170654296875, "rite_aid_store.address_locality": "Atascadero", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 93422, "rite_aid_store.longitude": -120.6641130000000003974491846747696399688720703125 }, "74": { "city_x_rite_aid_store.id": 74, "city.id": 74, "city.ts": "2018-01-11 03:25:33", "city.title": "Atwater", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 74, "rite_aid_store.ts": "2018-01-11 03:50:08", "rite_aid_store.title": "Rite Aid #06001 Atwater", "rite_aid_store.address_street": "571 Bellevue Road", "rite_aid_store.telephone": "(209) 358-6306", "rite_aid_store.latitude": 37.36167999999999977944753482006490230560302734375, "rite_aid_store.address_locality": "Atwater", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 95301, "rite_aid_store.longitude": -120.598645000000004756657290272414684295654296875 }, "75": { "city_x_rite_aid_store.id": 75, "city.id": 75, "city.ts": "2018-01-11 03:25:33", "city.title": "Auburn", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "76": { "city_x_rite_aid_store.id": 76, "city.id": 76, "city.ts": "2018-01-11 03:25:33", "city.title": "Azusa", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 76, "rite_aid_store.ts": "2018-01-11 03:50:26", "rite_aid_store.title": "Rite Aid #05576 Azusa", "rite_aid_store.address_street": "153 East Gladstone Street", "rite_aid_store.telephone": "(626) 334-3511", "rite_aid_store.latitude": 34.1149649999999979854692355729639530181884765625, "rite_aid_store.address_locality": "Azusa", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91702, "rite_aid_store.longitude": -117.90645499999999401552486233413219451904296875 }, "77": { "city_x_rite_aid_store.id": 77, "city.id": 77, "city.ts": "2018-01-11 03:25:33", "city.title": "Bakersfield", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "78": { "city_x_rite_aid_store.id": 78, "city.id": 78, "city.ts": "2018-01-11 03:25:33", "city.title": "Banning", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "79": { "city_x_rite_aid_store.id": 79, "city.id": 79, "city.ts": "2018-01-11 03:25:33", "city.title": "Barstow", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 79, "rite_aid_store.ts": "2018-01-11 03:50:38", "rite_aid_store.title": "Rite Aid #05690 Barstow", "rite_aid_store.address_street": "1380 Barstow Road", "rite_aid_store.telephone": "(760) 252-3502", "rite_aid_store.latitude": 34.87730499999999977944753482006490230560302734375, "rite_aid_store.address_locality": "Barstow", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92311, "rite_aid_store.longitude": -117.0235530000000068184817791916429996490478515625 }, "80": { "city_x_rite_aid_store.id": 80, "city.id": 80, "city.ts": "2018-01-11 03:25:33", "city.title": "Bay Point", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 80, "rite_aid_store.ts": "2018-01-11 03:50:49", "rite_aid_store.title": "Rite Aid #05935 Bay Point", "rite_aid_store.address_street": "580 Bailey Road", "rite_aid_store.telephone": "(925) 458-0955", "rite_aid_store.latitude": 38.01718100000000077898221206851303577423095703125, "rite_aid_store.address_locality": "Bay Point", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 94565, "rite_aid_store.longitude": -121.94366700000000491854734718799591064453125 }, "81": { "city_x_rite_aid_store.id": 81, "city.id": 81, "city.ts": "2018-01-11 03:25:33", "city.title": "Beaumont", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 81, "rite_aid_store.ts": "2018-01-11 03:50:55", "rite_aid_store.title": "Rite Aid #06529 Beaumont", "rite_aid_store.address_street": "894 Oak Valley Parkway", "rite_aid_store.telephone": "(951) 769-7370", "rite_aid_store.latitude": 33.94736999999999937926986603997647762298583984375, "rite_aid_store.address_locality": "Beaumont", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92223, "rite_aid_store.longitude": -116.9990580000000051086317398585379123687744140625 }, "82": { "city_x_rite_aid_store.id": 82, "city.id": 82, "city.ts": "2018-01-11 03:25:33", "city.title": "Bell Gardens", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 82, "rite_aid_store.ts": "2018-01-11 03:50:59", "rite_aid_store.title": "Rite Aid #05459 Bell Gardens", "rite_aid_store.address_street": "6959 Eastern Avenue", "rite_aid_store.telephone": "(323) 562-4613", "rite_aid_store.latitude": 33.9696110000000004447429091669619083404541015625, "rite_aid_store.address_locality": "Bell Gardens", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 90201, "rite_aid_store.longitude": -118.1661390000000011468728189356625080108642578125 }, "83": { "city_x_rite_aid_store.id": 83, "city.id": 83, "city.ts": "2018-01-11 03:25:33", "city.title": "Bellflower", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 83, "rite_aid_store.ts": "2018-01-11 03:51:05", "rite_aid_store.title": "Rite Aid #05508 Bellflower", "rite_aid_store.address_street": "15924 Bellflower Boulevard", "rite_aid_store.telephone": "(562) 925-5314", "rite_aid_store.latitude": 33.88871400000000022600943339057266712188720703125, "rite_aid_store.address_locality": "Bellflower", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 90706, "rite_aid_store.longitude": -118.12398899999999457577359862625598907470703125 }, "84": { "city_x_rite_aid_store.id": 84, "city.id": 84, "city.ts": "2018-01-11 03:25:33", "city.title": "Benicia", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 84, "rite_aid_store.ts": "2018-01-11 03:51:15", "rite_aid_store.title": "Rite Aid #05910 Benicia", "rite_aid_store.address_street": "60 Solano Square", "rite_aid_store.telephone": "(707) 746-0229", "rite_aid_store.latitude": 38.05461199999999877263689995743334293365478515625, "rite_aid_store.address_locality": "Benicia", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 94510, "rite_aid_store.longitude": -122.155293000000000347426976077258586883544921875 }, "85": { "city_x_rite_aid_store.id": 85, "city.id": 85, "city.ts": "2018-01-11 03:25:33", "city.title": "Bermuda Dunes", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 85, "rite_aid_store.ts": "2018-01-11 03:51:20", "rite_aid_store.title": "Rite Aid #06246 Bermuda Dunes", "rite_aid_store.address_street": "41800 Washington St", "rite_aid_store.telephone": "(760) 360-6280", "rite_aid_store.latitude": 33.7441290000000009285940905101597309112548828125, "rite_aid_store.address_locality": "Bermuda Dunes", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92203, "rite_aid_store.longitude": -116.303235999999998284692992456257343292236328125 }, "86": { "city_x_rite_aid_store.id": 86, "city.id": 86, "city.ts": "2018-01-11 03:25:33", "city.title": "Beverly Hills", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "87": { "city_x_rite_aid_store.id": 87, "city.id": 87, "city.ts": "2018-01-11 03:25:33", "city.title": "Bishop", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 87, "rite_aid_store.ts": "2018-01-11 03:51:27", "rite_aid_store.title": "Rite Aid #05839 Bishop", "rite_aid_store.address_street": "1375 Rocking W Drive", "rite_aid_store.telephone": "(760) 873-7883", "rite_aid_store.latitude": 37.37740600000000057434590416960418224334716796875, "rite_aid_store.address_locality": "Bishop", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 93514, "rite_aid_store.longitude": -118.4208459999999973888407112099230289459228515625 }, "88": { "city_x_rite_aid_store.id": 88, "city.id": 88, "city.ts": "2018-01-11 03:25:33", "city.title": "Blue Jay", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 88, "rite_aid_store.ts": "2018-01-11 03:51:33", "rite_aid_store.title": "Rite Aid #05692 Blue Jay", "rite_aid_store.address_street": "27177 Highway 189", "rite_aid_store.telephone": "(909) 336-1275", "rite_aid_store.latitude": 34.24551600000000206591721507720649242401123046875, "rite_aid_store.address_locality": "Blue Jay", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92317, "rite_aid_store.longitude": -117.2099160000000068748704507015645503997802734375 }, "89": { "city_x_rite_aid_store.id": 89, "city.id": 89, "city.ts": "2018-01-11 03:25:33", "city.title": "Blythe", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 89, "rite_aid_store.ts": "2018-01-11 03:51:36", "rite_aid_store.title": "Rite Aid #05673 Blythe", "rite_aid_store.address_street": "616 East Hobsonway", "rite_aid_store.telephone": "(760) 922-9867", "rite_aid_store.latitude": 33.6101249000000024125256459228694438934326171875, "rite_aid_store.address_locality": "Blythe", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92225, "rite_aid_store.longitude": -114.5892106000000012500095181167125701904296875 }, "90": { "city_x_rite_aid_store.id": 90, "city.id": 90, "city.ts": "2018-01-11 03:25:33", "city.title": "Bonita", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 90, "rite_aid_store.ts": "2018-01-11 03:51:40", "rite_aid_store.title": "Rite Aid #05613 Bonita", "rite_aid_store.address_street": "4348 Bonita Road", "rite_aid_store.telephone": "(619) 267-1617", "rite_aid_store.latitude": 32.6599819999999994024619809351861476898193359375, "rite_aid_store.address_locality": "Bonita", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91902, "rite_aid_store.longitude": -117.033807999999993398887454532086849212646484375 }, "91": { "city_x_rite_aid_store.id": 91, "city.id": 91, "city.ts": "2018-01-11 03:25:33", "city.title": "Brawley", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 91, "rite_aid_store.ts": "2018-01-11 03:51:46", "rite_aid_store.title": "Rite Aid #05674 Brawley", "rite_aid_store.address_street": "405 West Main Street", "rite_aid_store.telephone": "(760) 344-5732", "rite_aid_store.latitude": 32.97910900000000111731424112804234027862548828125, "rite_aid_store.address_locality": "Brawley", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92227, "rite_aid_store.longitude": -115.5485879999999951905920170247554779052734375 }, "92": { "city_x_rite_aid_store.id": 92, "city.id": 92, "city.ts": "2018-01-11 03:25:33", "city.title": "Brea", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 92, "rite_aid_store.ts": "2018-01-11 03:51:52", "rite_aid_store.title": "Rite Aid #05732 Brea", "rite_aid_store.address_street": "405 West Imperial Highway", "rite_aid_store.telephone": "(714) 529-2176", "rite_aid_store.latitude": 33.91828699999999940928319119848310947418212890625, "rite_aid_store.address_locality": "Brea", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92821, "rite_aid_store.longitude": -117.903987999999998237399267964065074920654296875 }, "93": { "city_x_rite_aid_store.id": 93, "city.id": 93, "city.ts": "2018-01-11 03:25:33", "city.title": "Buena Park", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California" }, "94": { "city_x_rite_aid_store.id": 94, "city.id": 94, "city.ts": "2018-01-11 03:25:33", "city.title": "Burbank", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 94, "rite_aid_store.ts": "2018-01-11 03:52:04", "rite_aid_store.title": "Rite Aid #05571 Burbank", "rite_aid_store.address_street": "935 North Hollywood Way", "rite_aid_store.telephone": "(818) 841-5336", "rite_aid_store.latitude": 34.16739659999999645378920831717550754547119140625, "rite_aid_store.address_locality": "Burbank", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91505, "rite_aid_store.longitude": -118.347451199999994742029230110347270965576171875 }, "95": { "city_x_rite_aid_store.id": 95, "city.id": 95, "city.ts": "2018-01-11 03:25:33", "city.title": "Burney", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 95, "rite_aid_store.ts": "2018-01-11 03:52:09", "rite_aid_store.title": "Rite Aid #06101 Burney", "rite_aid_store.address_street": "37435 Main Street", "rite_aid_store.telephone": "(530) 335-4860", "rite_aid_store.latitude": 40.88870080000000228892531595192849636077880859375, "rite_aid_store.address_locality": "Burney", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 96013, "rite_aid_store.longitude": -121.6530153000000069596353569068014621734619140625 }, "96": { "city_x_rite_aid_store.id": 96, "city.id": 96, "city.ts": "2018-01-11 03:25:33", "city.title": "Calabasas", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 96, "rite_aid_store.ts": "2018-01-11 03:52:11", "rite_aid_store.title": "Rite Aid #06327 Calabasas", "rite_aid_store.address_street": "4710 Commons Way", "rite_aid_store.telephone": "(818) 222-0549", "rite_aid_store.latitude": 34.15363070000000078607627074234187602996826171875, "rite_aid_store.address_locality": "Calabasas", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 91302, "rite_aid_store.longitude": -118.6439879999999931214915704913437366485595703125 }, "97": { "city_x_rite_aid_store.id": 97, "city.id": 97, "city.ts": "2018-01-11 03:25:33", "city.title": "Calexico", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 97, "rite_aid_store.ts": "2018-01-11 03:52:54", "rite_aid_store.title": "Rite Aid #06515 Calexico", "rite_aid_store.address_street": "211 West Birch Street", "rite_aid_store.telephone": "(760) 768-3169", "rite_aid_store.latitude": 32.6796369999999996025508153252303600311279296875, "rite_aid_store.address_locality": "Calexico", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 92231, "rite_aid_store.longitude": -115.5003860000000059926605899818241596221923828125 }, "98": { "city_x_rite_aid_store.id": 98, "city.id": 98, "city.ts": "2018-01-11 03:25:33", "city.title": "California City", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 98, "rite_aid_store.ts": "2018-01-11 03:52:56", "rite_aid_store.title": "Rite Aid #05837 California City", "rite_aid_store.address_street": "9482 California City Boulevard", "rite_aid_store.telephone": "(760) 373-5268", "rite_aid_store.latitude": 35.125395523426135468980646692216396331787109375, "rite_aid_store.address_locality": "California City", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 93505, "rite_aid_store.longitude": -117.9591979161705239675939083099365234375 }, "99": { "city_x_rite_aid_store.id": 99, "city.id": 99, "city.ts": "2018-01-11 03:25:33", "city.title": "Camarillo", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 99, "rite_aid_store.ts": "2018-01-11 03:53:01", "rite_aid_store.title": "Rite Aid #05775 Camarillo", "rite_aid_store.address_street": "2550 Las Posas Road", "rite_aid_store.telephone": "(805) 482-2135", "rite_aid_store.latitude": 34.23606399999999894134816713631153106689453125, "rite_aid_store.address_locality": "Camarillo", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 93010, "rite_aid_store.longitude": -119.035336999999998397470335476100444793701171875 }, "100": { "city_x_rite_aid_store.id": 100, "city.id": 100, "city.ts": "2018-01-11 03:25:33", "city.title": "Cameron Park", "city.state": "California", "state.id": 2, "state.ts": "2018-01-11 03:22:57", "state.title": "California", "rite_aid_store.id": 100, "rite_aid_store.ts": "2018-01-11 03:53:08", "rite_aid_store.title": "Rite Aid #06526 Cameron Park", "rite_aid_store.address_street": "3101 Green Valley Road", "rite_aid_store.telephone": "(530) 672-8908", "rite_aid_store.latitude": 38.69939600000000012869350030086934566497802734375, "rite_aid_store.address_locality": "Cameron Park", "rite_aid_store.address_region": "CA", "rite_aid_store.postal_code": 95682, "rite_aid_store.longitude": -120.9963560000000057925717555917799472808837890625 } } } }