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&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/list/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 400, "time": 0.0174200000000000014555023852835802244953811168670654296875 }, "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" } } } } } }