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": "US Auto Parts Store Information 1", "desc": "US Auto Parts Store Information Data Set", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/us_auto_parts_store_information_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/us_auto_parts_store_information_1/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/us_auto_parts_store_information_1/main/list/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 400, "time": 0.011509999999999999398259120653165155090391635894775390625 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 4404, "pages_total": 221 }, "struct": { "stem": { "0": "location_shop" }, "leaf": "location_shop.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "location_shop.id": 1, "location_shop.ts": "2018-05-27 23:23:55", "location_shop.shop_idt": 6026, "location_shop.title": "Alabaster", "location_shop.telephone": "(205) 620-5219", "location_shop.address": "693 1st Street SW", "location_shop.location": "Alabaster", "location_shop.region": "AL", "location_shop.post_code": 35007, "location_shop.latitude": 33.236697622802495288851787336170673370361328125, "location_shop.longitude": -86.819439232349395751953125, "location_shop.region_x_location_shop_id": { "1": { "region_x_location_shop.id": 1, "region.id": 1, "region.ts": "2018-05-27 23:13:13", "region.region": "Alabaster", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "1": { "time.id": 1, "time.ts": "2018-05-27 23:23:55", "time.monday_end": 2100, "time.monday_start": 730, "time.tuesday_end": 2100, "time.tuesday_start": 730, "time.wednesday_end": 2100, "time.wednesday_start": 730, "time.thursday_end": 2100, "time.thursday_start": 730, "time.friday_end": 2100, "time.friday_start": 730, "time.saturday_end": 2100, "time.saturday_start": 730, "time.sunday_end": 1900, "time.sunday_start": 900 } } }, "2": { "location_shop.id": 2, "location_shop.ts": "2018-05-27 23:24:39", "location_shop.shop_idt": 9230, "location_shop.title": "Albertville", "location_shop.telephone": "(256) 891-4710", "location_shop.address": "6855 US Highway 431", "location_shop.location": "Albertville", "location_shop.region": "AL", "location_shop.post_code": 35950, "location_shop.latitude": 34.27298578508476367687762831337749958038330078125, "location_shop.longitude": -86.20019361376756705794832669198513031005859375, "location_shop.region_x_location_shop_id": { "2": { "region_x_location_shop.id": 2, "region.id": 2, "region.ts": "2018-05-27 23:13:13", "region.region": "Albertville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "2": { "time.id": 2, "time.ts": "2018-05-27 23:24:39", "time.monday_end": 2000, "time.monday_start": 730, "time.tuesday_end": 2000, "time.tuesday_start": 730, "time.wednesday_end": 2000, "time.wednesday_start": 730, "time.thursday_end": 2000, "time.thursday_start": 730, "time.friday_end": 2000, "time.friday_start": 730, "time.saturday_end": 2000, "time.saturday_start": 730, "time.sunday_end": 1900, "time.sunday_start": 800 } } }, "3": { "location_shop.id": 3, "location_shop.ts": "2018-05-27 23:24:51", "location_shop.shop_idt": 9080, "location_shop.title": "Alexander City", "location_shop.telephone": "(256) 234-2267", "location_shop.address": "4350 Highway 280 West", "location_shop.location": "Alexander City", "location_shop.region": "AL", "location_shop.post_code": 35010, "location_shop.latitude": 32.9198989575435376764289685525000095367431640625, "location_shop.longitude": -85.9581353813399573482456617057323455810546875, "location_shop.region_x_location_shop_id": { "3": { "region_x_location_shop.id": 3, "region.id": 3, "region.ts": "2018-05-27 23:13:13", "region.region": "Alexander City", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "3": { "time.id": 3, "time.ts": "2018-05-27 23:24:51", "time.monday_end": 2000, "time.monday_start": 730, "time.tuesday_end": 2000, "time.tuesday_start": 730, "time.wednesday_end": 2000, "time.wednesday_start": 730, "time.thursday_end": 2000, "time.thursday_start": 730, "time.friday_end": 2000, "time.friday_start": 730, "time.saturday_end": 2000, "time.saturday_start": 730, "time.sunday_end": 1800, "time.sunday_start": 900 } } }, "4": { "location_shop.id": 4, "location_shop.ts": "2018-05-27 23:25:14", "location_shop.shop_idt": 9101, "location_shop.title": "Andalusia", "location_shop.telephone": "(334) 427-1530", "location_shop.address": "1104 Martin Luther King J Ex", "location_shop.location": "Andalusia", "location_shop.region": "AL", "location_shop.post_code": 36420, "location_shop.latitude": 31.318160453902084583432952058501541614532470703125, "location_shop.longitude": -86.46418373286616088080336339771747589111328125, "location_shop.region_x_location_shop_id": { "4": { "region_x_location_shop.id": 4, "region.id": 4, "region.ts": "2018-05-27 23:13:13", "region.region": "Andalusia", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "4": { "time.id": 4, "time.ts": "2018-05-27 23:25:14", "time.monday_end": 2000, "time.monday_start": 730, "time.tuesday_end": 2000, "time.tuesday_start": 730, "time.wednesday_end": 2000, "time.wednesday_start": 730, "time.thursday_end": 2000, "time.thursday_start": 730, "time.friday_end": 2000, "time.friday_start": 730, "time.saturday_end": 1900, "time.saturday_start": 730, "time.sunday_end": 1800, "time.sunday_start": 900 } } }, "5": { "location_shop.id": 5, "location_shop.ts": "2018-05-27 23:25:44", "location_shop.shop_idt": 9030, "location_shop.title": "Arab", "location_shop.telephone": "(256) 586-7070", "location_shop.address": "737 North Brindlee Mountain Parkway", "location_shop.location": "Arab", "location_shop.region": "AL", "location_shop.post_code": 35016, "location_shop.latitude": 34.32727131520767471783983637578785419464111328125, "location_shop.longitude": -86.5037664324034949459019117057323455810546875, "location_shop.region_x_location_shop_id": { "5": { "region_x_location_shop.id": 5, "region.id": 6, "region.ts": "2018-05-27 23:13:13", "region.region": "Arab", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "5": { "time.id": 5, "time.ts": "2018-05-27 23:25:44", "time.monday_end": 1900, "time.monday_start": 730, "time.tuesday_end": 1900, "time.tuesday_start": 730, "time.wednesday_end": 1900, "time.wednesday_start": 730, "time.thursday_end": 1900, "time.thursday_start": 730, "time.friday_end": 1900, "time.friday_start": 730, "time.saturday_end": 1900, "time.saturday_start": 730, "time.sunday_end": 1900, "time.sunday_start": 800 } } }, "6": { "location_shop.id": 6, "location_shop.ts": "2018-05-27 23:27:08", "location_shop.shop_idt": 5917, "location_shop.title": "Atmore", "location_shop.telephone": "(251) 368-9172", "location_shop.address": "1603 South Main Street", "location_shop.location": "Atmore", "location_shop.region": "AL", "location_shop.post_code": 36502, "location_shop.latitude": 31.003777724656156777882642927579581737518310546875, "location_shop.longitude": -87.49220162630075492415926419198513031005859375, "location_shop.region_x_location_shop_id": { "6": { "region_x_location_shop.id": 6, "region.id": 8, "region.ts": "2018-05-27 23:13:13", "region.region": "Atmore", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "6": { "time.id": 6, "time.ts": "2018-05-27 23:27:08", "time.monday_end": 1900, "time.monday_start": 800, "time.tuesday_end": 1900, "time.tuesday_start": 800, "time.wednesday_end": 1900, "time.wednesday_start": 800, "time.thursday_end": 1900, "time.thursday_start": 800, "time.friday_end": 1900, "time.friday_start": 800, "time.saturday_end": 1900, "time.saturday_start": 800, "time.sunday_end": 1700, "time.sunday_start": 900 } } }, "7": { "location_shop.id": 7, "location_shop.ts": "2018-05-27 23:27:51", "location_shop.shop_idt": 9103, "location_shop.title": "Bay Minette", "location_shop.telephone": "(251) 580-3030", "location_shop.address": "101 McMeans Avenue", "location_shop.location": "Bay Minette", "location_shop.region": "AL", "location_shop.post_code": 36507, "location_shop.latitude": 30.878473799999998306020643212832510471343994140625, "location_shop.longitude": -87.7843004000000064479536376893520355224609375, "location_shop.region_x_location_shop_id": { "7": { "region_x_location_shop.id": 7, "region.id": 10, "region.ts": "2018-05-27 23:13:13", "region.region": "Bay Minette", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "7": { "time.id": 7, "time.ts": "2018-05-27 23:27:51", "time.monday_end": 1900, "time.monday_start": 800, "time.tuesday_end": 1900, "time.tuesday_start": 800, "time.wednesday_end": 1900, "time.wednesday_start": 800, "time.thursday_end": 1900, "time.thursday_start": 800, "time.friday_end": 1900, "time.friday_start": 800, "time.saturday_end": 1900, "time.saturday_start": 800, "time.sunday_end": 1800, "time.sunday_start": 900 } } }, "8": { "location_shop.id": 8, "location_shop.ts": "2018-05-27 23:28:41", "location_shop.shop_idt": 9010, "location_shop.title": "Boaz", "location_shop.telephone": "(256) 840-9279", "location_shop.address": "1389 US Highway 431 North", "location_shop.location": "Boaz", "location_shop.region": "AL", "location_shop.post_code": 35957, "location_shop.latitude": 34.2063631118805204778254847042262554168701171875, "location_shop.longitude": -86.1527158227045219973661005496978759765625, "location_shop.region_x_location_shop_id": { "8": { "region_x_location_shop.id": 8, "region.id": 13, "region.ts": "2018-05-27 23:13:13", "region.region": "Boaz", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "8": { "time.id": 8, "time.ts": "2018-05-27 23:28:41", "time.monday_end": 2000, "time.monday_start": 730, "time.tuesday_end": 2000, "time.tuesday_start": 730, "time.wednesday_end": 2000, "time.wednesday_start": 730, "time.thursday_end": 2000, "time.thursday_start": 730, "time.friday_end": 2000, "time.friday_start": 730, "time.saturday_end": 2000, "time.saturday_start": 730, "time.sunday_end": 1900, "time.sunday_start": 900 } } }, "9": { "location_shop.id": 9, "location_shop.ts": "2018-05-27 23:29:06", "location_shop.shop_idt": 5939, "location_shop.title": "Brent", "location_shop.telephone": "(205) 926-7912", "location_shop.address": "2974 Main Street", "location_shop.location": "Brent", "location_shop.region": "AL", "location_shop.post_code": 35034, "location_shop.latitude": 32.944056491245873985462822020053863525390625, "location_shop.longitude": -87.15548439882701359238126315176486968994140625, "location_shop.region_x_location_shop_id": { "9": { "region_x_location_shop.id": 9, "region.id": 14, "region.ts": "2018-05-27 23:13:13", "region.region": "Brent", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "9": { "time.id": 9, "time.ts": "2018-05-27 23:29:06", "time.monday_end": 1900, "time.monday_start": 730, "time.tuesday_end": 1900, "time.tuesday_start": 730, "time.wednesday_end": 1900, "time.wednesday_start": 730, "time.thursday_end": 1900, "time.thursday_start": 730, "time.friday_end": 1900, "time.friday_start": 730, "time.saturday_end": 1900, "time.saturday_start": 730, "time.sunday_end": 1700, "time.sunday_start": 900 } } }, "10": { "location_shop.id": 10, "location_shop.ts": "2018-05-27 23:29:31", "location_shop.shop_idt": 5914, "location_shop.title": "Brewton", "location_shop.telephone": "(251) 867-3646", "location_shop.address": "1029 Douglas Avenue", "location_shop.location": "Brewton", "location_shop.region": "AL", "location_shop.post_code": 36426, "location_shop.latitude": 31.122623999999998289922586991451680660247802734375, "location_shop.longitude": -87.0687530000000009522409527562558650970458984375, "location_shop.region_x_location_shop_id": { "10": { "region_x_location_shop.id": 10, "region.id": 15, "region.ts": "2018-05-27 23:13:13", "region.region": "Brewton", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "10": { "time.id": 10, "time.ts": "2018-05-27 23:29:31", "time.monday_end": 1900, "time.monday_start": 800, "time.tuesday_end": 1900, "time.tuesday_start": 800, "time.wednesday_end": 1900, "time.wednesday_start": 800, "time.thursday_end": 1900, "time.thursday_start": 800, "time.friday_end": 1900, "time.friday_start": 800, "time.saturday_end": 1900, "time.saturday_start": 800, "time.sunday_end": 1700, "time.sunday_start": 900 } } }, "11": { "location_shop.id": 11, "location_shop.ts": "2018-05-27 23:29:50", "location_shop.shop_idt": 5938, "location_shop.title": "Butler", "location_shop.telephone": "(205) 459-5990", "location_shop.address": "227 West Pushmataha Street", "location_shop.location": "Butler", "location_shop.region": "AL", "location_shop.post_code": 36904, "location_shop.latitude": 32.09022378218961790707908221520483493804931640625, "location_shop.longitude": -88.22310358285898246322176419198513031005859375, "location_shop.region_x_location_shop_id": { "11": { "region_x_location_shop.id": 11, "region.id": 16, "region.ts": "2018-05-27 23:13:13", "region.region": "Butler", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "11": { "time.id": 11, "time.ts": "2018-05-27 23:29:50", "time.monday_end": 1900, "time.monday_start": 800, "time.tuesday_end": 1900, "time.tuesday_start": 800, "time.wednesday_end": 1900, "time.wednesday_start": 800, "time.thursday_end": 1900, "time.thursday_start": 800, "time.friday_end": 1900, "time.friday_start": 800, "time.saturday_end": 1900, "time.saturday_start": 800, "time.sunday_end": 1700, "time.sunday_start": 900 } } }, "12": { "location_shop.id": 12, "location_shop.ts": "2018-05-27 23:31:10", "location_shop.shop_idt": 8424, "location_shop.title": "Calera", "location_shop.telephone": "(205) 668-1548", "location_shop.address": "7951 Hwy 31", "location_shop.location": "Calera", "location_shop.region": "AL", "location_shop.post_code": 35040, "location_shop.latitude": 33.10731289999393567313745734281837940216064453125, "location_shop.longitude": -86.75200045108800850357511080801486968994140625, "location_shop.region_x_location_shop_id": { "12": { "region_x_location_shop.id": 12, "region.id": 17, "region.ts": "2018-05-27 23:13:13", "region.region": "Calera", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "12": { "time.id": 12, "time.ts": "2018-05-27 23:31:10", "time.monday_end": 2000, "time.monday_start": 700, "time.tuesday_end": 2000, "time.tuesday_start": 700, "time.wednesday_end": 2000, "time.wednesday_start": 700, "time.thursday_end": 2000, "time.thursday_start": 700, "time.friday_end": 2000, "time.friday_start": 700, "time.saturday_end": 2000, "time.saturday_start": 700, "time.sunday_end": 1800, "time.sunday_start": 900 } } }, "13": { "location_shop.id": 13, "location_shop.ts": "2018-05-27 23:32:30", "location_shop.shop_idt": 9400, "location_shop.title": "Center Point", "location_shop.telephone": "(205) 856-4644", "location_shop.address": "2007 Center Point Pkwy", "location_shop.location": "Center Point", "location_shop.region": "AL", "location_shop.post_code": 35215, "location_shop.latitude": 33.63907495087590149296374875120818614959716796875, "location_shop.longitude": -86.6831901222457190669956617057323455810546875, "location_shop.region_x_location_shop_id": { "13": { "region_x_location_shop.id": 13, "region.id": 18, "region.ts": "2018-05-27 23:13:13", "region.region": "Center Point", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "13": { "time.id": 13, "time.ts": "2018-05-27 23:32:30", "time.monday_end": 2100, "time.monday_start": 730, "time.tuesday_end": 2100, "time.tuesday_start": 730, "time.wednesday_end": 2100, "time.wednesday_start": 730, "time.thursday_end": 2100, "time.thursday_start": 730, "time.friday_end": 2100, "time.friday_start": 730, "time.saturday_end": 2100, "time.saturday_start": 730, "time.sunday_end": 1800, "time.sunday_start": 900 } } }, "14": { "location_shop.id": 14, "location_shop.ts": "2018-05-27 23:32:54", "location_shop.shop_idt": 9500, "location_shop.title": "Centre", "location_shop.telephone": "(256) 927-6960", "location_shop.address": "1700 West Main Street", "location_shop.location": "Centre", "location_shop.region": "AL", "location_shop.post_code": 35960, "location_shop.latitude": 34.16036554674875702630743035115301609039306640625, "location_shop.longitude": -85.70984423160552978515625, "location_shop.region_x_location_shop_id": { "14": { "region_x_location_shop.id": 14, "region.id": 19, "region.ts": "2018-05-27 23:13:13", "region.region": "Centre", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "14": { "time.id": 14, "time.ts": "2018-05-27 23:32:54", "time.monday_end": 2000, "time.monday_start": 700, "time.tuesday_end": 2000, "time.tuesday_start": 700, "time.wednesday_end": 2000, "time.wednesday_start": 700, "time.thursday_end": 2000, "time.thursday_start": 700, "time.friday_end": 2000, "time.friday_start": 700, "time.saturday_end": 2000, "time.saturday_start": 700, "time.sunday_end": 1800, "time.sunday_start": 800 } } }, "15": { "location_shop.id": 15, "location_shop.ts": "2018-05-27 23:33:14", "location_shop.shop_idt": 6293, "location_shop.title": "Chelsea", "location_shop.telephone": "(205) 678-9713", "location_shop.address": "16462 Highway 280", "location_shop.location": "Chelsea", "location_shop.region": "AL", "location_shop.post_code": 35043, "location_shop.latitude": 33.3496981090711557271788478828966617584228515625, "location_shop.longitude": -86.62704437971109427962801419198513031005859375, "location_shop.region_x_location_shop_id": { "15": { "region_x_location_shop.id": 15, "region.id": 20, "region.ts": "2018-05-27 23:13:13", "region.region": "Chelsea", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "15": { "time.id": 15, "time.ts": "2018-05-27 23:33:14", "time.monday_end": 2100, "time.monday_start": 730, "time.tuesday_end": 2100, "time.tuesday_start": 730, "time.wednesday_end": 2100, "time.wednesday_start": 730, "time.thursday_end": 2100, "time.thursday_start": 730, "time.friday_end": 2100, "time.friday_start": 730, "time.saturday_end": 2100, "time.saturday_start": 730, "time.sunday_end": 1900, "time.sunday_start": 900 } } }, "16": { "location_shop.id": 16, "location_shop.ts": "2018-05-27 23:33:36", "location_shop.shop_idt": 5962, "location_shop.title": "Clanton", "location_shop.telephone": "(205) 755-0851", "location_shop.address": "101 Seventh Street South", "location_shop.location": "Clanton", "location_shop.region": "AL", "location_shop.post_code": 35045, "location_shop.latitude": 32.83754904202499602661191602237522602081298828125, "location_shop.longitude": -86.63074314594268798828125, "location_shop.region_x_location_shop_id": { "16": { "region_x_location_shop.id": 16, "region.id": 21, "region.ts": "2018-05-27 23:13:13", "region.region": "Clanton", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "16": { "time.id": 16, "time.ts": "2018-05-27 23:33:36", "time.monday_end": 2000, "time.monday_start": 700, "time.tuesday_end": 2000, "time.tuesday_start": 700, "time.wednesday_end": 2000, "time.wednesday_start": 700, "time.thursday_end": 2000, "time.thursday_start": 700, "time.friday_end": 2000, "time.friday_start": 700, "time.saturday_end": 2000, "time.saturday_start": 700, "time.sunday_end": 1800, "time.sunday_start": 900 } } }, "17": { "location_shop.id": 17, "location_shop.ts": "2018-05-27 23:34:01", "location_shop.shop_idt": 9350, "location_shop.title": "Cullman", "location_shop.telephone": "(256) 737-5449", "location_shop.address": "1642 Second Ave. SW", "location_shop.location": "Cullman", "location_shop.region": "AL", "location_shop.post_code": 35055, "location_shop.latitude": 34.16028675640228584597934968769550323486328125, "location_shop.longitude": -86.83431208133697509765625, "location_shop.region_x_location_shop_id": { "17": { "region_x_location_shop.id": 17, "region.id": 22, "region.ts": "2018-05-27 23:13:13", "region.region": "Cullman", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "17": { "time.id": 17, "time.ts": "2018-05-27 23:34:01", "time.monday_end": 2000, "time.monday_start": 700, "time.tuesday_end": 2000, "time.tuesday_start": 700, "time.wednesday_end": 2000, "time.wednesday_start": 700, "time.thursday_end": 2000, "time.thursday_start": 700, "time.friday_end": 2000, "time.friday_start": 700, "time.saturday_end": 2000, "time.saturday_start": 700, "time.sunday_end": 1900, "time.sunday_start": 800 } } }, "18": { "location_shop.id": 18, "location_shop.ts": "2018-05-27 23:34:22", "location_shop.shop_idt": 9104, "location_shop.title": "Daleville", "location_shop.telephone": "(334) 598-4117", "location_shop.address": "969 N Daleville Avenue", "location_shop.location": "Daleville", "location_shop.region": "AL", "location_shop.post_code": 36322, "location_shop.latitude": 31.320643953260258740556309930980205535888671875, "location_shop.longitude": -85.7108567562181633547879755496978759765625, "location_shop.region_x_location_shop_id": { "18": { "region_x_location_shop.id": 18, "region.id": 23, "region.ts": "2018-05-27 23:13:13", "region.region": "Daleville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "18": { "time.id": 18, "time.ts": "2018-05-27 23:34:22", "time.monday_end": 2000, "time.monday_start": 730, "time.tuesday_end": 2000, "time.tuesday_start": 730, "time.wednesday_end": 2000, "time.wednesday_start": 730, "time.thursday_end": 2000, "time.thursday_start": 730, "time.friday_end": 2000, "time.friday_start": 730, "time.saturday_end": 1900, "time.saturday_start": 730, "time.sunday_end": 1800, "time.sunday_start": 900 } } }, "19": { "location_shop.id": 19, "location_shop.ts": "2018-05-27 23:35:09", "location_shop.shop_idt": 5941, "location_shop.title": "Demopolis", "location_shop.telephone": "(334) 289-1213", "location_shop.address": "315 Highway 80 East", "location_shop.location": "Demopolis", "location_shop.region": "AL", "location_shop.post_code": 36732, "location_shop.latitude": 32.50416334286108366313783335499465465545654296875, "location_shop.longitude": -87.8343522548675537109375, "location_shop.region_x_location_shop_id": { "19": { "region_x_location_shop.id": 19, "region.id": 26, "region.ts": "2018-05-27 23:13:13", "region.region": "Demopolis", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "19": { "time.id": 19, "time.ts": "2018-05-27 23:35:09", "time.monday_end": 2000, "time.monday_start": 700, "time.tuesday_end": 2000, "time.tuesday_start": 700, "time.wednesday_end": 2000, "time.wednesday_start": 700, "time.thursday_end": 2000, "time.thursday_start": 700, "time.friday_end": 2000, "time.friday_start": 700, "time.saturday_end": 2000, "time.saturday_start": 700, "time.sunday_end": 1900, "time.sunday_start": 800 } } }, "20": { "location_shop.id": 20, "location_shop.ts": "2018-05-27 23:36:18", "location_shop.shop_idt": 9270, "location_shop.title": "Enterprise", "location_shop.telephone": "(334) 308-2868", "location_shop.address": "908 Rucker Blvd.", "location_shop.location": "Enterprise", "location_shop.region": "AL", "location_shop.post_code": 36330, "location_shop.latitude": 31.3231025235711939558314043097198009490966796875, "location_shop.longitude": -85.828808089818267035298049449920654296875, "location_shop.region_x_location_shop_id": { "20": { "region_x_location_shop.id": 20, "region.id": 28, "region.ts": "2018-05-27 23:13:13", "region.region": "Enterprise", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" } }, "location_shop.time_id": { "20": { "time.id": 20, "time.ts": "2018-05-27 23:36:18", "time.monday_end": 2000, "time.monday_start": 730, "time.tuesday_end": 2000, "time.tuesday_start": 730, "time.wednesday_end": 2000, "time.wednesday_start": 730, "time.thursday_end": 2000, "time.thursday_start": 730, "time.friday_end": 2000, "time.friday_start": 730, "time.saturday_end": 1900, "time.saturday_start": 730, "time.sunday_end": 1800, "time.sunday_start": 900 } } } } } }