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": "Auto Repair Shop 1",
"point": {
"title": "Main",
"desc": "Main access point of this API. "
}
},
"input": {},
"links": {
"up": {
"href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/"
},
"home": {
"href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/list/?app=html-json"
},
"next": {
"href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/list/2/?app=html-json"
}
},
"meta": {
"query": {
"page": 1,
"limit": 20,
"limit_total": 400,
"time": 0.0048599999999999997368771431638378999195992946624755859375
},
"stats": {
"raw_rows": 20,
"rows": 20,
"rows_total": 56323,
"pages_total": 2817
},
"struct": {
"stem": {
"0": "auto_repair_shop"
},
"leaf": "auto_repair_shop.id",
"leaf_stem": {},
"leaf_stem_leaf": null
}
},
"output": {
"rows": {
"1": {
"auto_repair_shop.id": 1,
"auto_repair_shop.ts": "2017-11-20 21:09:51",
"auto_repair_shop.title": "Alexander Dodge Chrysler Jeep Ram",
"auto_repair_shop.streetaddress": "6764 US Hway 431",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 5.3 mi from Boaz",
"auto_repair_shop.phone": "(855) 726-1946",
"auto_repair_shop.latitude": 34.2729242999999996754922904074192047119140625,
"auto_repair_shop.longitude": -86.1985576999999949521225062198936939239501953125,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"1": {
"city_x_auto_repair_shop.id": 1,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"129": {
"city_x_auto_repair_shop.id": 129,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {
"1": {
"auto_repair_shop_x_amenties.id": 1,
"amenties.id": 1,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Car Wash"
},
"2": {
"auto_repair_shop_x_amenties.id": 2,
"amenties.id": 2,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Child Friendly"
},
"3": {
"auto_repair_shop_x_amenties.id": 3,
"amenties.id": 3,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Coffee"
},
"4": {
"auto_repair_shop_x_amenties.id": 4,
"amenties.id": 4,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Early Bird Dropoff"
},
"5": {
"auto_repair_shop_x_amenties.id": 5,
"amenties.id": 5,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Extended/Evening Hours"
},
"6": {
"auto_repair_shop_x_amenties.id": 6,
"amenties.id": 6,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Heated Waiting Room"
},
"7": {
"auto_repair_shop_x_amenties.id": 7,
"amenties.id": 7,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Military Discount"
},
"8": {
"auto_repair_shop_x_amenties.id": 8,
"amenties.id": 8,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Senior Discount"
}
},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"1": {
"auto_repair_shop_x_service.id": 1,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"2": {
"auto_repair_shop_x_service.id": 2,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"3": {
"auto_repair_shop_x_service.id": 3,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"4": {
"auto_repair_shop_x_service.id": 4,
"service.id": 4,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Ram"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"1": {
"auto_repair_shop_x_specialty.id": 1,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"2": {
"auto_repair_shop.id": 2,
"auto_repair_shop.ts": "2017-11-20 21:09:58",
"auto_repair_shop.title": "Superior Auto Care",
"auto_repair_shop.streetaddress": "8842 Us Highway 431",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 0.8 mi from Boaz",
"auto_repair_shop.phone": "(256) 891-1109",
"auto_repair_shop.latitude": 34.20667399999999958026819513179361820220947265625,
"auto_repair_shop.longitude": -86.1537880000000058089426602236926555633544921875,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"2": {
"city_x_auto_repair_shop.id": 2,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"125": {
"city_x_auto_repair_shop.id": 125,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"5": {
"auto_repair_shop_x_service.id": 5,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"6": {
"auto_repair_shop_x_service.id": 6,
"service.id": 6,
"service.ts": "2017-11-20 21:09:58",
"service.value": "FIAT"
},
"7": {
"auto_repair_shop_x_service.id": 7,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"8": {
"auto_repair_shop_x_service.id": 8,
"service.id": 8,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Mercury"
},
"9": {
"auto_repair_shop_x_service.id": 9,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"10": {
"auto_repair_shop_x_service.id": 10,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"11": {
"auto_repair_shop_x_service.id": 11,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"12": {
"auto_repair_shop_x_service.id": 12,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"2": {
"auto_repair_shop_x_specialty.id": 2,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"3": {
"auto_repair_shop.id": 3,
"auto_repair_shop.ts": "2017-11-20 21:10:05",
"auto_repair_shop.title": "Alexander Automotive",
"auto_repair_shop.streetaddress": "7710 Highway 431 North",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 6.0 mi from Boaz",
"auto_repair_shop.phone": "(800) 422-8721",
"auto_repair_shop.latitude": 34.27906949999999852707333047874271869659423828125,
"auto_repair_shop.longitude": -86.2128186000000056310454965569078922271728515625,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"3": {
"city_x_auto_repair_shop.id": 3,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"130": {
"city_x_auto_repair_shop.id": 130,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {
"9": {
"auto_repair_shop_x_amenties.id": 9,
"amenties.id": 9,
"amenties.ts": "2017-11-20 21:10:05",
"amenties.value": "Parts/Accessories"
}
},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"13": {
"auto_repair_shop_x_service.id": 13,
"service.id": 13,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mazda"
},
"14": {
"auto_repair_shop_x_service.id": 14,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"6": {
"auto_repair_shop_x_specialty.id": 6,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"3": {
"auto_repair_shop_x_specialty.id": 3,
"specialty.id": 3,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Collision Repair & Paint"
},
"4": {
"auto_repair_shop_x_specialty.id": 4,
"specialty.id": 4,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Oil Change & Lube"
},
"5": {
"auto_repair_shop_x_specialty.id": 5,
"specialty.id": 5,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Scheduled Maintenance"
}
}
},
"4": {
"auto_repair_shop.id": 4,
"auto_repair_shop.ts": "2017-11-20 21:10:16",
"auto_repair_shop.title": "J & M Mechanics",
"auto_repair_shop.streetaddress": "9023 Us Hwy 431 N",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 7.1 mi from Boaz",
"auto_repair_shop.phone": "(256) 891-0010",
"auto_repair_shop.latitude": 34.28618449999999739929990028031170368194580078125,
"auto_repair_shop.longitude": -86.2337016999999974586899043060839176177978515625,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"4": {
"city_x_auto_repair_shop.id": 4,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"132": {
"city_x_auto_repair_shop.id": 132,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"16": {
"auto_repair_shop_x_service.id": 16,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"17": {
"auto_repair_shop_x_service.id": 17,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"15": {
"auto_repair_shop_x_service.id": 15,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"21": {
"auto_repair_shop_x_service.id": 21,
"service.id": 8,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Mercury"
},
"18": {
"auto_repair_shop_x_service.id": 18,
"service.id": 18,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Hummer"
},
"19": {
"auto_repair_shop_x_service.id": 19,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"20": {
"auto_repair_shop_x_service.id": 20,
"service.id": 20,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Land Rover"
},
"22": {
"auto_repair_shop_x_service.id": 22,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"7": {
"auto_repair_shop_x_specialty.id": 7,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"5": {
"auto_repair_shop.id": 5,
"auto_repair_shop.ts": "2017-11-20 21:10:20",
"auto_repair_shop.title": "Howard Bentley Buick GMC",
"auto_repair_shop.streetaddress": "4321 US Highway 431",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 2.9 mi from Boaz",
"auto_repair_shop.phone": "(256) 878-1050",
"auto_repair_shop.latitude": 34.24237099999999855981513974256813526153564453125,
"auto_repair_shop.longitude": -86.1727130000000016707417671568691730499267578125,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"5": {
"city_x_auto_repair_shop.id": 5,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"126": {
"city_x_auto_repair_shop.id": 126,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"23": {
"auto_repair_shop_x_service.id": 23,
"service.id": 23,
"service.ts": "2017-11-20 21:10:20",
"service.value": "Buick"
},
"24": {
"auto_repair_shop_x_service.id": 24,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"8": {
"auto_repair_shop_x_specialty.id": 8,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"6": {
"auto_repair_shop.id": 6,
"auto_repair_shop.ts": "2017-11-20 21:10:26",
"auto_repair_shop.title": "Edico Inc",
"auto_repair_shop.streetaddress": "Po Box 1335",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 6.4 mi from Boaz",
"auto_repair_shop.phone": "",
"auto_repair_shop.latitude": 34.24975200000000086220097728073596954345703125,
"auto_repair_shop.longitude": -86.2610949999999974124875734560191631317138671875,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"6": {
"city_x_auto_repair_shop.id": 6,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"131": {
"city_x_auto_repair_shop.id": 131,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"26": {
"auto_repair_shop_x_service.id": 26,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"29": {
"auto_repair_shop_x_service.id": 29,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"25": {
"auto_repair_shop_x_service.id": 25,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"27": {
"auto_repair_shop_x_service.id": 27,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"28": {
"auto_repair_shop_x_service.id": 28,
"service.id": 28,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Lexus"
},
"30": {
"auto_repair_shop_x_service.id": 30,
"service.id": 30,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Saab"
},
"31": {
"auto_repair_shop_x_service.id": 31,
"service.id": 31,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Toyota"
},
"32": {
"auto_repair_shop_x_service.id": 32,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {}
},
"7": {
"auto_repair_shop.id": 7,
"auto_repair_shop.ts": "2017-11-20 21:11:13",
"auto_repair_shop.title": "Economy Tire Inc",
"auto_repair_shop.streetaddress": "4588 Us Highway 431",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 3.3 mi from Boaz",
"auto_repair_shop.phone": "",
"auto_repair_shop.latitude": 34.24762100000000231148078455589711666107177734375,
"auto_repair_shop.longitude": -86.1758310000000022910171537660062313079833984375,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"7": {
"city_x_auto_repair_shop.id": 7,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"127": {
"city_x_auto_repair_shop.id": 127,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"34": {
"auto_repair_shop_x_service.id": 34,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"36": {
"auto_repair_shop_x_service.id": 36,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"38": {
"auto_repair_shop_x_service.id": 38,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"35": {
"auto_repair_shop_x_service.id": 35,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"37": {
"auto_repair_shop_x_service.id": 37,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"33": {
"auto_repair_shop_x_service.id": 33,
"service.id": 33,
"service.ts": "2017-11-20 21:11:13",
"service.value": "BMW"
},
"39": {
"auto_repair_shop_x_service.id": 39,
"service.id": 39,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Smart"
},
"40": {
"auto_repair_shop_x_service.id": 40,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {}
},
"8": {
"auto_repair_shop.id": 8,
"auto_repair_shop.ts": "2017-11-20 21:11:17",
"auto_repair_shop.title": "Holcomb Collision LLC",
"auto_repair_shop.streetaddress": "PO Box 2158",
"auto_repair_shop.addresslocality": "Albertville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35950,
"auto_repair_shop.distance_directions": "Auto repair 5.2 mi from Boaz",
"auto_repair_shop.phone": "(256) 878-6600",
"auto_repair_shop.latitude": 34.26759369999999904621290625073015689849853515625,
"auto_repair_shop.longitude": -86.208866900000003852255758829414844512939453125,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"8": {
"city_x_auto_repair_shop.id": 8,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"128": {
"city_x_auto_repair_shop.id": 128,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"44": {
"auto_repair_shop_x_service.id": 44,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"46": {
"auto_repair_shop_x_service.id": 46,
"service.id": 8,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Mercury"
},
"47": {
"auto_repair_shop_x_service.id": 47,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"43": {
"auto_repair_shop_x_service.id": 43,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"48": {
"auto_repair_shop_x_service.id": 48,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"41": {
"auto_repair_shop_x_service.id": 41,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"42": {
"auto_repair_shop_x_service.id": 42,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"45": {
"auto_repair_shop_x_service.id": 45,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {}
},
"9": {
"auto_repair_shop.id": 9,
"auto_repair_shop.ts": "2017-11-20 21:11:24",
"auto_repair_shop.title": "Tnt Garage",
"auto_repair_shop.streetaddress": "711 Darnell St",
"auto_repair_shop.addresslocality": "Boaz,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35957,
"auto_repair_shop.distance_directions": "Auto repair in Boaz",
"auto_repair_shop.phone": "(256) 593-2190",
"auto_repair_shop.latitude": 34.20699379999999933943399810232222080230712890625,
"auto_repair_shop.longitude": -86.162633099999993646633811295032501220703125,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"9": {
"city_x_auto_repair_shop.id": 9,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"119": {
"city_x_auto_repair_shop.id": 119,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"53": {
"auto_repair_shop_x_service.id": 53,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"55": {
"auto_repair_shop_x_service.id": 55,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"49": {
"auto_repair_shop_x_service.id": 49,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"50": {
"auto_repair_shop_x_service.id": 50,
"service.id": 50,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Ford"
},
"51": {
"auto_repair_shop_x_service.id": 51,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"52": {
"auto_repair_shop_x_service.id": 52,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"54": {
"auto_repair_shop_x_service.id": 54,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"56": {
"auto_repair_shop_x_service.id": 56,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"9": {
"auto_repair_shop_x_specialty.id": 9,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"10": {
"auto_repair_shop.id": 10,
"auto_repair_shop.ts": "2017-11-20 21:11:34",
"auto_repair_shop.title": "Sand Mountain Transmission",
"auto_repair_shop.streetaddress": "1261 Wills Rd",
"auto_repair_shop.addresslocality": "Boaz,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35957,
"auto_repair_shop.distance_directions": "Auto repair in Boaz",
"auto_repair_shop.phone": "",
"auto_repair_shop.latitude": 34.21151900000000267709765466861426830291748046875,
"auto_repair_shop.longitude": -86.151938999999998713974491693079471588134765625,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"10": {
"city_x_auto_repair_shop.id": 10,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"123": {
"city_x_auto_repair_shop.id": 123,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"60": {
"auto_repair_shop_x_service.id": 60,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"58": {
"auto_repair_shop_x_service.id": 58,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"63": {
"auto_repair_shop_x_service.id": 63,
"service.id": 31,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Toyota"
},
"64": {
"auto_repair_shop_x_service.id": 64,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"59": {
"auto_repair_shop_x_service.id": 59,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"57": {
"auto_repair_shop_x_service.id": 57,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"61": {
"auto_repair_shop_x_service.id": 61,
"service.id": 61,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Lincoln"
},
"62": {
"auto_repair_shop_x_service.id": 62,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {}
},
"11": {
"auto_repair_shop.id": 11,
"auto_repair_shop.ts": "2017-11-20 21:11:40",
"auto_repair_shop.title": "Kilpatrick Chevrolet",
"auto_repair_shop.streetaddress": "1134 Hwy 431",
"auto_repair_shop.addresslocality": "Boaz,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35957,
"auto_repair_shop.distance_directions": "Auto repair in Boaz",
"auto_repair_shop.phone": "(256) 593-4253",
"auto_repair_shop.latitude": 34.202707500000002482920535840094089508056640625,
"auto_repair_shop.longitude": -86.151870999999999867213773541152477264404296875,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"11": {
"city_x_auto_repair_shop.id": 11,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"118": {
"city_x_auto_repair_shop.id": 118,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {
"10": {
"auto_repair_shop_x_amenties.id": 10,
"amenties.id": 9,
"amenties.ts": "2017-11-20 21:10:05",
"amenties.value": "Parts/Accessories"
},
"11": {
"auto_repair_shop_x_amenties.id": 11,
"amenties.id": 11,
"amenties.ts": "2017-11-20 21:11:40",
"amenties.value": "Service Guarantee"
}
},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"65": {
"auto_repair_shop_x_service.id": 65,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"10": {
"auto_repair_shop_x_specialty.id": 10,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"12": {
"auto_repair_shop.id": 12,
"auto_repair_shop.ts": "2017-11-20 21:11:44",
"auto_repair_shop.title": "Oil Change Specialists",
"auto_repair_shop.streetaddress": "10724 Al Highway 168",
"auto_repair_shop.addresslocality": "Boaz,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35957,
"auto_repair_shop.distance_directions": "Auto repair in Boaz",
"auto_repair_shop.phone": "",
"auto_repair_shop.latitude": 34.2369810000000001082298695109784603118896484375,
"auto_repair_shop.longitude": -86.1191879999999940764610073529183864593505859375,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"12": {
"city_x_auto_repair_shop.id": 12,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"124": {
"city_x_auto_repair_shop.id": 124,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"70": {
"auto_repair_shop_x_service.id": 70,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"72": {
"auto_repair_shop_x_service.id": 72,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"67": {
"auto_repair_shop_x_service.id": 67,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"68": {
"auto_repair_shop_x_service.id": 68,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"71": {
"auto_repair_shop_x_service.id": 71,
"service.id": 30,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Saab"
},
"66": {
"auto_repair_shop_x_service.id": 66,
"service.id": 50,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Ford"
},
"69": {
"auto_repair_shop_x_service.id": 69,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"73": {
"auto_repair_shop_x_service.id": 73,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {}
},
"13": {
"auto_repair_shop.id": 13,
"auto_repair_shop.ts": "2017-11-20 21:11:48",
"auto_repair_shop.title": "Abbie Auto Parts Inc",
"auto_repair_shop.streetaddress": "1015 Us Highway 431",
"auto_repair_shop.addresslocality": "Boaz,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35957,
"auto_repair_shop.distance_directions": "Auto repair in Boaz",
"auto_repair_shop.phone": "(205) 593-8741",
"auto_repair_shop.latitude": 34.2010231000000004542016540654003620147705078125,
"auto_repair_shop.longitude": -86.15148179999999911160557530820369720458984375,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"13": {
"city_x_auto_repair_shop.id": 13,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"121": {
"city_x_auto_repair_shop.id": 121,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"78": {
"auto_repair_shop_x_service.id": 78,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"74": {
"auto_repair_shop_x_service.id": 74,
"service.id": 6,
"service.ts": "2017-11-20 21:09:58",
"service.value": "FIAT"
},
"79": {
"auto_repair_shop_x_service.id": 79,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"75": {
"auto_repair_shop_x_service.id": 75,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"80": {
"auto_repair_shop_x_service.id": 80,
"service.id": 30,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Saab"
},
"81": {
"auto_repair_shop_x_service.id": 81,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
},
"76": {
"auto_repair_shop_x_service.id": 76,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"77": {
"auto_repair_shop_x_service.id": 77,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"11": {
"auto_repair_shop_x_specialty.id": 11,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"14": {
"auto_repair_shop.id": 14,
"auto_repair_shop.ts": "2017-11-20 21:11:54",
"auto_repair_shop.title": "Williams Express Lube",
"auto_repair_shop.streetaddress": "10909 AL Highway 168",
"auto_repair_shop.addresslocality": "Boaz,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35957,
"auto_repair_shop.distance_directions": "Auto repair in Boaz",
"auto_repair_shop.phone": "(256) 593-1880",
"auto_repair_shop.latitude": 34.19890960000000035279299481771886348724365234375,
"auto_repair_shop.longitude": -86.1517759999999981346263666637241840362548828125,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"14": {
"city_x_auto_repair_shop.id": 14,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"120": {
"city_x_auto_repair_shop.id": 120,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"85": {
"auto_repair_shop_x_service.id": 85,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"83": {
"auto_repair_shop_x_service.id": 83,
"service.id": 6,
"service.ts": "2017-11-20 21:09:58",
"service.value": "FIAT"
},
"89": {
"auto_repair_shop_x_service.id": 89,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"82": {
"auto_repair_shop_x_service.id": 82,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"86": {
"auto_repair_shop_x_service.id": 86,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"84": {
"auto_repair_shop_x_service.id": 84,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"87": {
"auto_repair_shop_x_service.id": 87,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"88": {
"auto_repair_shop_x_service.id": 88,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"13": {
"auto_repair_shop_x_specialty.id": 13,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"12": {
"auto_repair_shop_x_specialty.id": 12,
"specialty.id": 4,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Oil Change & Lube"
},
"14": {
"auto_repair_shop_x_specialty.id": 14,
"specialty.id": 14,
"specialty.ts": "2017-11-20 21:11:54",
"specialty.value": "Tire Sales/Repair"
}
}
},
"15": {
"auto_repair_shop.id": 15,
"auto_repair_shop.ts": "2017-11-20 21:12:02",
"auto_repair_shop.title": "Hubbard Tire Muffler & Auto",
"auto_repair_shop.streetaddress": "21784 Us 431",
"auto_repair_shop.addresslocality": "Guntersville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35976,
"auto_repair_shop.distance_directions": "Auto repair 12.6 mi from Boaz",
"auto_repair_shop.phone": "(256) 582-2781",
"auto_repair_shop.latitude": 34.33518889999999856854628887958824634552001953125,
"auto_repair_shop.longitude": -86.3145315000000010741132427938282489776611328125,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"15": {
"city_x_auto_repair_shop.id": 15,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"138": {
"city_x_auto_repair_shop.id": 138,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"91": {
"auto_repair_shop_x_service.id": 91,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"96": {
"auto_repair_shop_x_service.id": 96,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"95": {
"auto_repair_shop_x_service.id": 95,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"92": {
"auto_repair_shop_x_service.id": 92,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"94": {
"auto_repair_shop_x_service.id": 94,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"97": {
"auto_repair_shop_x_service.id": 97,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
},
"93": {
"auto_repair_shop_x_service.id": 93,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"90": {
"auto_repair_shop_x_service.id": 90,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"15": {
"auto_repair_shop_x_specialty.id": 15,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"16": {
"auto_repair_shop.id": 16,
"auto_repair_shop.ts": "2017-11-20 21:12:04",
"auto_repair_shop.title": "Oliver Tire",
"auto_repair_shop.streetaddress": "1340 Blount Ave",
"auto_repair_shop.addresslocality": "Guntersville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35976,
"auto_repair_shop.distance_directions": "Auto repair 12.7 mi from Boaz",
"auto_repair_shop.phone": "",
"auto_repair_shop.latitude": 34.34656499999999823558027856051921844482421875,
"auto_repair_shop.longitude": -86.3015740000000022291715140454471111297607421875,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"16": {
"city_x_auto_repair_shop.id": 16,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"140": {
"city_x_auto_repair_shop.id": 140,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"99": {
"auto_repair_shop_x_service.id": 99,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"100": {
"auto_repair_shop_x_service.id": 100,
"service.id": 6,
"service.ts": "2017-11-20 21:09:58",
"service.value": "FIAT"
},
"104": {
"auto_repair_shop_x_service.id": 104,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"102": {
"auto_repair_shop_x_service.id": 102,
"service.id": 13,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mazda"
},
"101": {
"auto_repair_shop_x_service.id": 101,
"service.id": 18,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Hummer"
},
"105": {
"auto_repair_shop_x_service.id": 105,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
},
"103": {
"auto_repair_shop_x_service.id": 103,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
},
"98": {
"auto_repair_shop_x_service.id": 98,
"service.id": 98,
"service.ts": "2017-11-20 21:12:04",
"service.value": "Audi"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {}
},
"17": {
"auto_repair_shop.id": 17,
"auto_repair_shop.ts": "2017-11-20 21:12:09",
"auto_repair_shop.title": "B's Express Lube",
"auto_repair_shop.streetaddress": "1716 Blount Ave",
"auto_repair_shop.addresslocality": "Guntersville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35976,
"auto_repair_shop.distance_directions": "Auto repair 12.6 mi from Boaz",
"auto_repair_shop.phone": "",
"auto_repair_shop.latitude": 34.34143999999999863348421058617532253265380859375,
"auto_repair_shop.longitude": -86.307130000000000791260390542447566986083984375,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"17": {
"city_x_auto_repair_shop.id": 17,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"139": {
"city_x_auto_repair_shop.id": 139,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"106": {
"auto_repair_shop_x_service.id": 106,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"107": {
"auto_repair_shop_x_service.id": 107,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"111": {
"auto_repair_shop_x_service.id": 111,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"112": {
"auto_repair_shop_x_service.id": 112,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"109": {
"auto_repair_shop_x_service.id": 109,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"108": {
"auto_repair_shop_x_service.id": 108,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"113": {
"auto_repair_shop_x_service.id": 113,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
},
"110": {
"auto_repair_shop_x_service.id": 110,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {}
},
"18": {
"auto_repair_shop.id": 18,
"auto_repair_shop.ts": "2017-11-20 21:12:11",
"auto_repair_shop.title": "Bob Hembree Chevrolet",
"auto_repair_shop.streetaddress": "11982 US Highway 431",
"auto_repair_shop.addresslocality": "Guntersville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35976,
"auto_repair_shop.distance_directions": "Auto repair 12.6 mi from Boaz",
"auto_repair_shop.phone": "(256) 582-5603",
"auto_repair_shop.latitude": 34.3360871000000003050445229746401309967041015625,
"auto_repair_shop.longitude": -86.3142936999999932368154986761510372161865234375,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"18": {
"city_x_auto_repair_shop.id": 18,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"137": {
"city_x_auto_repair_shop.id": 137,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"114": {
"auto_repair_shop_x_service.id": 114,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"16": {
"auto_repair_shop_x_specialty.id": 16,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"19": {
"auto_repair_shop.id": 19,
"auto_repair_shop.ts": "2017-11-20 21:12:14",
"auto_repair_shop.title": "Valley Auto Electric Inc",
"auto_repair_shop.streetaddress": "1904 Henry St",
"auto_repair_shop.addresslocality": "Guntersville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35976,
"auto_repair_shop.distance_directions": "Auto repair 13.0 mi from Boaz",
"auto_repair_shop.phone": "(256) 582-5426",
"auto_repair_shop.latitude": 34.3484892000000030520823202095925807952880859375,
"auto_repair_shop.longitude": -86.3069531999999952631696942262351512908935546875,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"19": {
"city_x_auto_repair_shop.id": 19,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"141": {
"city_x_auto_repair_shop.id": 141,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"119": {
"auto_repair_shop_x_service.id": 119,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"116": {
"auto_repair_shop_x_service.id": 116,
"service.id": 18,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Hummer"
},
"115": {
"auto_repair_shop_x_service.id": 115,
"service.id": 33,
"service.ts": "2017-11-20 21:11:13",
"service.value": "BMW"
},
"121": {
"auto_repair_shop_x_service.id": 121,
"service.id": 39,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Smart"
},
"117": {
"auto_repair_shop_x_service.id": 117,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"120": {
"auto_repair_shop_x_service.id": 120,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
},
"118": {
"auto_repair_shop_x_service.id": 118,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
},
"122": {
"auto_repair_shop_x_service.id": 122,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"17": {
"auto_repair_shop_x_specialty.id": 17,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
}
}
},
"20": {
"auto_repair_shop.id": 20,
"auto_repair_shop.ts": "2017-11-20 21:12:21",
"auto_repair_shop.title": "Lake City Auto Repairs Inc",
"auto_repair_shop.streetaddress": "1901 Henry Street",
"auto_repair_shop.addresslocality": "Guntersville,",
"auto_repair_shop.addressregion": "AL",
"auto_repair_shop.postalcode": 35976,
"auto_repair_shop.distance_directions": "Auto repair 13.0 mi from Boaz",
"auto_repair_shop.phone": "(256) 582-8844",
"auto_repair_shop.latitude": 34.34818500000000085492501966655254364013671875,
"auto_repair_shop.longitude": -86.3072690000000051213646656833589076995849609375,
"auto_repair_shop.description": "This shop is not yet RepairPal Certified -",
"auto_repair_shop.city_x_auto_repair_shop_id": {
"20": {
"city_x_auto_repair_shop.id": 20,
"city.id": 1,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Albertville"
},
"142": {
"city_x_auto_repair_shop.id": 142,
"city.id": 4,
"city.ts": "2017-11-19 21:33:21",
"city.title": "Boaz"
}
},
"auto_repair_shop.auto_repair_shop_x_amenties_id": {},
"auto_repair_shop.auto_repair_shop_x_service_id": {
"130": {
"auto_repair_shop_x_service.id": 130,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"125": {
"auto_repair_shop_x_service.id": 125,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"123": {
"auto_repair_shop_x_service.id": 123,
"service.id": 50,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Ford"
},
"124": {
"auto_repair_shop_x_service.id": 124,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"127": {
"auto_repair_shop_x_service.id": 127,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
},
"129": {
"auto_repair_shop_x_service.id": 129,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
},
"126": {
"auto_repair_shop_x_service.id": 126,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
},
"128": {
"auto_repair_shop_x_service.id": 128,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
},
"auto_repair_shop.auto_repair_shop_x_specialty_id": {
"18": {
"auto_repair_shop_x_specialty.id": 18,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"19": {
"auto_repair_shop_x_specialty.id": 19,
"specialty.id": 14,
"specialty.ts": "2017-11-20 21:11:54",
"specialty.value": "Tire Sales/Repair"
}
}
}
}
}
}