You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
auto_repair_shop.id | auto_repair_shop.ts | auto_repair_shop.title | auto_repair_shop.streetaddress | auto_repair_shop.addresslocality | auto_repair_shop.addressregion | auto_repair_shop.postalcode | auto_repair_shop.distance_directions | auto_repair_shop.phone | auto_repair_shop.latitude | auto_repair_shop.longitude | auto_repair_shop.description | auto_repair_shop.city_x_auto_repair_shop_id | auto_repair_shop.auto_repair_shop_x_amenties_id | auto_repair_shop.auto_repair_shop_x_service_id | auto_repair_shop.auto_repair_shop_x_specialty_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2017-11-20 21:09:51 | Alexander Dodge Chrysler Jeep Ram | 6764 US Hway 431 | Albertville, | AL | 35950 | Auto repair 5.3 mi from Boaz | (855) 726-1946 | 34.2729243 | -86.1985577 | This shop is not yet RepairPal Certified - | { "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" } } | {
"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"
}
} |
{
"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"
}
} |
{ "1": { "auto_repair_shop_x_specialty.id": 1, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
2 | 2017-11-20 21:09:58 | Superior Auto Care | 8842 Us Highway 431 | Albertville, | AL | 35950 | Auto repair 0.8 mi from Boaz | (256) 891-1109 | 34.206674 | -86.153788 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{ "2": { "auto_repair_shop_x_specialty.id": 2, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
3 | 2017-11-20 21:10:05 | Alexander Automotive | 7710 Highway 431 North | Albertville, | AL | 35950 | Auto repair 6.0 mi from Boaz | (800) 422-8721 | 34.2790695 | -86.2128186 | This shop is not yet RepairPal Certified - | { "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" } } | { "9": { "auto_repair_shop_x_amenties.id": 9, "amenties.id": 9, "amenties.ts": "2017-11-20 21:10:05", "amenties.value": "Parts/Accessories" } } | { "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" } } | {
"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 | 2017-11-20 21:10:16 | J & M Mechanics | 9023 Us Hwy 431 N | Albertville, | AL | 35950 | Auto repair 7.1 mi from Boaz | (256) 891-0010 | 34.2861845 | -86.2337017 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{ "7": { "auto_repair_shop_x_specialty.id": 7, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
5 | 2017-11-20 21:10:20 | Howard Bentley Buick GMC | 4321 US Highway 431 | Albertville, | AL | 35950 | Auto repair 2.9 mi from Boaz | (256) 878-1050 | 34.242371 | -86.172713 | This shop is not yet RepairPal Certified - | { "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" } } | {} | { "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" } } | { "8": { "auto_repair_shop_x_specialty.id": 8, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
6 | 2017-11-20 21:10:26 | Edico Inc | Po Box 1335 | Albertville, | AL | 35950 | Auto repair 6.4 mi from Boaz | 34.249752 | -86.261095 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{} | |
7 | 2017-11-20 21:11:13 | Economy Tire Inc | 4588 Us Highway 431 | Albertville, | AL | 35950 | Auto repair 3.3 mi from Boaz | 34.247621 | -86.175831 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{} | |
8 | 2017-11-20 21:11:17 | Holcomb Collision LLC | PO Box 2158 | Albertville, | AL | 35950 | Auto repair 5.2 mi from Boaz | (256) 878-6600 | 34.2675937 | -86.2088669 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{} |
9 | 2017-11-20 21:11:24 | Tnt Garage | 711 Darnell St | Boaz, | AL | 35957 | Auto repair in Boaz | (256) 593-2190 | 34.2069938 | -86.1626331 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{ "9": { "auto_repair_shop_x_specialty.id": 9, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
10 | 2017-11-20 21:11:34 | Sand Mountain Transmission | 1261 Wills Rd | Boaz, | AL | 35957 | Auto repair in Boaz | 34.211519 | -86.151939 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{} | |
11 | 2017-11-20 21:11:40 | Kilpatrick Chevrolet | 1134 Hwy 431 | Boaz, | AL | 35957 | Auto repair in Boaz | (256) 593-4253 | 34.2027075 | -86.151871 | This shop is not yet RepairPal Certified - | { "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" } } | { "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" } } | { "65": { "auto_repair_shop_x_service.id": 65, "service.id": 5, "service.ts": "2017-11-20 21:09:58", "service.value": "Chevrolet" } } | { "10": { "auto_repair_shop_x_specialty.id": 10, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
12 | 2017-11-20 21:11:44 | Oil Change Specialists | 10724 Al Highway 168 | Boaz, | AL | 35957 | Auto repair in Boaz | 34.236981 | -86.119188 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{} | |
13 | 2017-11-20 21:11:48 | Abbie Auto Parts Inc | 1015 Us Highway 431 | Boaz, | AL | 35957 | Auto repair in Boaz | (205) 593-8741 | 34.2010231 | -86.1514818 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{ "11": { "auto_repair_shop_x_specialty.id": 11, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
14 | 2017-11-20 21:11:54 | Williams Express Lube | 10909 AL Highway 168 | Boaz, | AL | 35957 | Auto repair in Boaz | (256) 593-1880 | 34.1989096 | -86.151776 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{
"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 | 2017-11-20 21:12:02 | Hubbard Tire Muffler & Auto | 21784 Us 431 | Guntersville, | AL | 35976 | Auto repair 12.6 mi from Boaz | (256) 582-2781 | 34.3351889 | -86.3145315 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{ "15": { "auto_repair_shop_x_specialty.id": 15, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
16 | 2017-11-20 21:12:04 | Oliver Tire | 1340 Blount Ave | Guntersville, | AL | 35976 | Auto repair 12.7 mi from Boaz | 34.346565 | -86.301574 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{} | |
17 | 2017-11-20 21:12:09 | B's Express Lube | 1716 Blount Ave | Guntersville, | AL | 35976 | Auto repair 12.6 mi from Boaz | 34.34144 | -86.30713 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{} | |
18 | 2017-11-20 21:12:11 | Bob Hembree Chevrolet | 11982 US Highway 431 | Guntersville, | AL | 35976 | Auto repair 12.6 mi from Boaz | (256) 582-5603 | 34.3360871 | -86.3142937 | This shop is not yet RepairPal Certified - | { "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" } } | {} | { "114": { "auto_repair_shop_x_service.id": 114, "service.id": 5, "service.ts": "2017-11-20 21:09:58", "service.value": "Chevrolet" } } | { "16": { "auto_repair_shop_x_specialty.id": 16, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
19 | 2017-11-20 21:12:14 | Valley Auto Electric Inc | 1904 Henry St | Guntersville, | AL | 35976 | Auto repair 13.0 mi from Boaz | (256) 582-5426 | 34.3484892 | -86.3069532 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{ "17": { "auto_repair_shop_x_specialty.id": 17, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
20 | 2017-11-20 21:12:21 | Lake City Auto Repairs Inc | 1901 Henry Street | Guntersville, | AL | 35976 | Auto repair 13.0 mi from Boaz | (256) 582-8844 | 34.348185 | -86.307269 | This shop is not yet RepairPal Certified - | { "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" } } | {} | {
"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"
}
} |
{ "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" } } |
auto_repair_shop.id | auto_repair_shop.ts | auto_repair_shop.title | auto_repair_shop.streetaddress | auto_repair_shop.addresslocality | auto_repair_shop.addressregion | auto_repair_shop.postalcode | auto_repair_shop.distance_directions | auto_repair_shop.phone | auto_repair_shop.latitude | auto_repair_shop.longitude | auto_repair_shop.description | auto_repair_shop.city_x_auto_repair_shop_id | auto_repair_shop.auto_repair_shop_x_amenties_id | auto_repair_shop.auto_repair_shop_x_service_id | auto_repair_shop.auto_repair_shop_x_specialty_id |