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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 2017-11-20 21:12:28 | Ricky Hill Transmissions | 2810 Al Highway 205 | Boaz, | AL | 35956 | Auto repair in Boaz | 34.164982 | -86.139465 | This shop is not yet RepairPal Certified - | { "21": { "city_x_auto_repair_shop.id": 21, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville" }, "122": { "city_x_auto_repair_shop.id": 122, "city.id": 4, "city.ts": "2017-11-19 21:33:21", "city.title": "Boaz" } } | {} | {
"131": {
"auto_repair_shop_x_service.id": 131,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"132": {
"auto_repair_shop_x_service.id": 132,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"136": {
"auto_repair_shop_x_service.id": 136,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"137": {
"auto_repair_shop_x_service.id": 137,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"134": {
"auto_repair_shop_x_service.id": 134,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"133": {
"auto_repair_shop_x_service.id": 133,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"138": {
"auto_repair_shop_x_service.id": 138,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
},
"135": {
"auto_repair_shop_x_service.id": 135,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
}
} |
{} | |
22 | 2017-11-20 21:12:36 | Gambles Auto Serv & Parts | 2515 Morgan Rd | Bessemer, | AL | 35022 | Auto repair in Bessemer | (205) 426-3351 | 33.3419562 | -86.9288707 | This shop is not yet RepairPal Certified - | { "22": { "city_x_auto_repair_shop.id": 22, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | { "12": { "auto_repair_shop_x_amenties.id": 12, "amenties.id": 9, "amenties.ts": "2017-11-20 21:10:05", "amenties.value": "Parts/Accessories" } } | {
"140": {
"auto_repair_shop_x_service.id": 140,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"144": {
"auto_repair_shop_x_service.id": 144,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"142": {
"auto_repair_shop_x_service.id": 142,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"141": {
"auto_repair_shop_x_service.id": 141,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"145": {
"auto_repair_shop_x_service.id": 145,
"service.id": 31,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Toyota"
},
"146": {
"auto_repair_shop_x_service.id": 146,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
},
"143": {
"auto_repair_shop_x_service.id": 143,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"139": {
"auto_repair_shop_x_service.id": 139,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
}
} |
{ "20": { "auto_repair_shop_x_specialty.id": 20, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" }, "21": { "auto_repair_shop_x_specialty.id": 21, "specialty.id": 14, "specialty.ts": "2017-11-20 21:11:54", "specialty.value": "Tire Sales/Repair" } } |
23 | 2017-11-20 21:12:41 | Williamson Foreign Car Service | 2030 19th St | Bessemer, | AL | 35020 | Auto repair in Bessemer | 33.4150886 | -86.9755444 | This shop is not yet RepairPal Certified - | { "23": { "city_x_auto_repair_shop.id": 23, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"148": {
"auto_repair_shop_x_service.id": 148,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"150": {
"auto_repair_shop_x_service.id": 150,
"service.id": 31,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Toyota"
},
"151": {
"auto_repair_shop_x_service.id": 151,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"147": {
"auto_repair_shop_x_service.id": 147,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"149": {
"auto_repair_shop_x_service.id": 149,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
}
} |
{ "22": { "auto_repair_shop_x_specialty.id": 22, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" }, "23": { "auto_repair_shop_x_specialty.id": 23, "specialty.id": 23, "specialty.ts": "2017-11-20 21:12:41", "specialty.value": "Transmission Repair" } } | |
24 | 2017-11-20 21:12:47 | 15th St Automotive | 1430 14th Ave N | Bessemer, | AL | 35020 | Auto repair in Bessemer | 33.405297 | -86.971474 | This shop is not yet RepairPal Certified - | { "24": { "city_x_auto_repair_shop.id": 24, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {
"13": {
"auto_repair_shop_x_amenties.id": 13,
"amenties.id": 3,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Coffee"
},
"15": {
"auto_repair_shop_x_amenties.id": 15,
"amenties.id": 6,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Heated Waiting Room"
},
"16": {
"auto_repair_shop_x_amenties.id": 16,
"amenties.id": 11,
"amenties.ts": "2017-11-20 21:11:40",
"amenties.value": "Service Guarantee"
},
"14": {
"auto_repair_shop_x_amenties.id": 14,
"amenties.id": 14,
"amenties.ts": "2017-11-20 21:12:47",
"amenties.value": "Gas/Diesel"
}
} |
{
"152": {
"auto_repair_shop_x_service.id": 152,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"153": {
"auto_repair_shop_x_service.id": 153,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"154": {
"auto_repair_shop_x_service.id": 154,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"157": {
"auto_repair_shop_x_service.id": 157,
"service.id": 13,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mazda"
},
"155": {
"auto_repair_shop_x_service.id": 155,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"159": {
"auto_repair_shop_x_service.id": 159,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"156": {
"auto_repair_shop_x_service.id": 156,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"158": {
"auto_repair_shop_x_service.id": 158,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
}
} |
{
"28": {
"auto_repair_shop_x_specialty.id": 28,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"27": {
"auto_repair_shop_x_specialty.id": 27,
"specialty.id": 5,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Scheduled Maintenance"
},
"24": {
"auto_repair_shop_x_specialty.id": 24,
"specialty.id": 24,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "AC/Heating"
},
"25": {
"auto_repair_shop_x_specialty.id": 25,
"specialty.id": 25,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "Check Engine Light"
},
"26": {
"auto_repair_shop_x_specialty.id": 26,
"specialty.id": 26,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "Diagnosis"
}
} |
|
25 | 2017-11-20 21:12:49 | Moore Nissan | 5487 Academy Way | Bessemer, | AL | 35022 | Auto repair in Bessemer | (205) 428-6314 | 33.363084 | -87.008807 | This shop is not yet RepairPal Certified - | { "25": { "city_x_auto_repair_shop.id": 25, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | { "160": { "auto_repair_shop_x_service.id": 160, "service.id": 9, "service.ts": "2017-11-20 21:09:58", "service.value": "Nissan" } } | { "29": { "auto_repair_shop_x_specialty.id": 29, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
26 | 2017-11-20 21:12:55 | Power Steering Associates | 1961 4th Ave. SW. | Bessemer, | AL | 35022 | Auto repair in Bessemer | (205) 426-4327 | 33.342508 | -87.001808 | This shop is not yet RepairPal Certified - | { "26": { "city_x_auto_repair_shop.id": 26, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"163": {
"auto_repair_shop_x_service.id": 163,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"164": {
"auto_repair_shop_x_service.id": 164,
"service.id": 6,
"service.ts": "2017-11-20 21:09:58",
"service.value": "FIAT"
},
"167": {
"auto_repair_shop_x_service.id": 167,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"162": {
"auto_repair_shop_x_service.id": 162,
"service.id": 23,
"service.ts": "2017-11-20 21:10:20",
"service.value": "Buick"
},
"165": {
"auto_repair_shop_x_service.id": 165,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"161": {
"auto_repair_shop_x_service.id": 161,
"service.id": 33,
"service.ts": "2017-11-20 21:11:13",
"service.value": "BMW"
},
"166": {
"auto_repair_shop_x_service.id": 166,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"168": {
"auto_repair_shop_x_service.id": 168,
"service.id": 61,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Lincoln"
}
} |
{ "30": { "auto_repair_shop_x_specialty.id": 30, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
27 | 2017-11-20 21:12:59 | General Automotive | 2433 Lottie Dr Se | Bessemer, | AL | 35022 | Auto repair in Bessemer | (205) 788-6058 | 33.346275 | -86.910129 | This shop is not yet RepairPal Certified - | { "27": { "city_x_auto_repair_shop.id": 27, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"172": {
"auto_repair_shop_x_service.id": 172,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"176": {
"auto_repair_shop_x_service.id": 176,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"175": {
"auto_repair_shop_x_service.id": 175,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"169": {
"auto_repair_shop_x_service.id": 169,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"171": {
"auto_repair_shop_x_service.id": 171,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"170": {
"auto_repair_shop_x_service.id": 170,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"173": {
"auto_repair_shop_x_service.id": 173,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"174": {
"auto_repair_shop_x_service.id": 174,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
}
} |
{ "31": { "auto_repair_shop_x_specialty.id": 31, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
28 | 2017-11-20 21:13:01 | T E Tire & Battery | 1701 North 19th St | Bessemer, | AL | 35023 | Auto repair in Bessemer | (205) 428-0111 | 33.4131969 | -86.971536 | This shop is not yet RepairPal Certified - | { "28": { "city_x_auto_repair_shop.id": 28, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"180": {
"auto_repair_shop_x_service.id": 180,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"182": {
"auto_repair_shop_x_service.id": 182,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"179": {
"auto_repair_shop_x_service.id": 179,
"service.id": 20,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Land Rover"
},
"177": {
"auto_repair_shop_x_service.id": 177,
"service.id": 23,
"service.ts": "2017-11-20 21:10:20",
"service.value": "Buick"
},
"181": {
"auto_repair_shop_x_service.id": 181,
"service.id": 30,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Saab"
},
"184": {
"auto_repair_shop_x_service.id": 184,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"178": {
"auto_repair_shop_x_service.id": 178,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"183": {
"auto_repair_shop_x_service.id": 183,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
}
} |
{ "32": { "auto_repair_shop_x_specialty.id": 32, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
29 | 2017-11-20 21:13:08 | D & D Auto Repair | 5131a Bessemer Super Hwy | Bessemer, | AL | 35020 | Auto repair in Bessemer | (205) 424-6031 | 33.4425961 | -86.9316989 | This shop is not yet RepairPal Certified - | { "29": { "city_x_auto_repair_shop.id": 29, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"186": {
"auto_repair_shop_x_service.id": 186,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"187": {
"auto_repair_shop_x_service.id": 187,
"service.id": 6,
"service.ts": "2017-11-20 21:09:58",
"service.value": "FIAT"
},
"188": {
"auto_repair_shop_x_service.id": 188,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"189": {
"auto_repair_shop_x_service.id": 189,
"service.id": 20,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Land Rover"
},
"185": {
"auto_repair_shop_x_service.id": 185,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"192": {
"auto_repair_shop_x_service.id": 192,
"service.id": 31,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Toyota"
},
"190": {
"auto_repair_shop_x_service.id": 190,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"191": {
"auto_repair_shop_x_service.id": 191,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
}
} |
{ "33": { "auto_repair_shop_x_specialty.id": 33, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
30 | 2017-11-20 21:13:15 | Ken's Tires and Wheels | 99 Florence St | Bessemer, | AL | 35023 | Auto repair in Bessemer | (205) 491-7009 | 33.453131 | -87.011 | This shop is not yet RepairPal Certified - | { "30": { "city_x_auto_repair_shop.id": 30, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"197": {
"auto_repair_shop_x_service.id": 197,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"199": {
"auto_repair_shop_x_service.id": 199,
"service.id": 4,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Ram"
},
"195": {
"auto_repair_shop_x_service.id": 195,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"196": {
"auto_repair_shop_x_service.id": 196,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"193": {
"auto_repair_shop_x_service.id": 193,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"198": {
"auto_repair_shop_x_service.id": 198,
"service.id": 28,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Lexus"
},
"200": {
"auto_repair_shop_x_service.id": 200,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"194": {
"auto_repair_shop_x_service.id": 194,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
}
} |
{ "34": { "auto_repair_shop_x_specialty.id": 34, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
31 | 2017-11-20 21:13:23 | Eastern Valley Auto Repair | 921 Eastern Valley Rd | Bessemer, | AL | 35020 | Auto repair in Bessemer | (205) 426-6356 | 33.363736 | -86.969055 | This shop is not yet RepairPal Certified - | { "31": { "city_x_auto_repair_shop.id": 31, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {
"17": {
"auto_repair_shop_x_amenties.id": 17,
"amenties.id": 3,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Coffee"
},
"18": {
"auto_repair_shop_x_amenties.id": 18,
"amenties.id": 6,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Heated Waiting Room"
},
"19": {
"auto_repair_shop_x_amenties.id": 19,
"amenties.id": 9,
"amenties.ts": "2017-11-20 21:10:05",
"amenties.value": "Parts/Accessories"
},
"20": {
"auto_repair_shop_x_amenties.id": 20,
"amenties.id": 11,
"amenties.ts": "2017-11-20 21:11:40",
"amenties.value": "Service Guarantee"
},
"21": {
"auto_repair_shop_x_amenties.id": 21,
"amenties.id": 21,
"amenties.ts": "2017-11-20 21:13:23",
"amenties.value": "Store"
}
} |
{
"203": {
"auto_repair_shop_x_service.id": 203,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"204": {
"auto_repair_shop_x_service.id": 204,
"service.id": 8,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Mercury"
},
"206": {
"auto_repair_shop_x_service.id": 206,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"205": {
"auto_repair_shop_x_service.id": 205,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"207": {
"auto_repair_shop_x_service.id": 207,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"201": {
"auto_repair_shop_x_service.id": 201,
"service.id": 23,
"service.ts": "2017-11-20 21:10:20",
"service.value": "Buick"
},
"202": {
"auto_repair_shop_x_service.id": 202,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"208": {
"auto_repair_shop_x_service.id": 208,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
}
} |
{
"39": {
"auto_repair_shop_x_specialty.id": 39,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"37": {
"auto_repair_shop_x_specialty.id": 37,
"specialty.id": 4,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Oil Change & Lube"
},
"38": {
"auto_repair_shop_x_specialty.id": 38,
"specialty.id": 5,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Scheduled Maintenance"
},
"35": {
"auto_repair_shop_x_specialty.id": 35,
"specialty.id": 25,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "Check Engine Light"
},
"36": {
"auto_repair_shop_x_specialty.id": 36,
"specialty.id": 26,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "Diagnosis"
},
"40": {
"auto_repair_shop_x_specialty.id": 40,
"specialty.id": 40,
"specialty.ts": "2017-11-20 21:13:23",
"specialty.value": "Timing Belts"
}
} |
32 | 2017-11-20 21:13:29 | Quality Auto Body | 2108 5Th Ave N | Bessemer, | AL | 35020 | Auto repair in Bessemer | 33.406139 | -86.953791 | This shop is not yet RepairPal Certified - | { "32": { "city_x_auto_repair_shop.id": 32, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"214": {
"auto_repair_shop_x_service.id": 214,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"212": {
"auto_repair_shop_x_service.id": 212,
"service.id": 20,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Land Rover"
},
"216": {
"auto_repair_shop_x_service.id": 216,
"service.id": 31,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Toyota"
},
"210": {
"auto_repair_shop_x_service.id": 210,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"211": {
"auto_repair_shop_x_service.id": 211,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"209": {
"auto_repair_shop_x_service.id": 209,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"213": {
"auto_repair_shop_x_service.id": 213,
"service.id": 61,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Lincoln"
},
"215": {
"auto_repair_shop_x_service.id": 215,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
}
} |
{} | |
33 | 2017-11-20 21:13:34 | Jims Hobby Shop Old Car | 1415 Loveless Ln | Bessemer, | AL | 35022 | Auto repair in Bessemer | 33.385605 | -86.903299 | This shop is not yet RepairPal Certified - | { "33": { "city_x_auto_repair_shop.id": 33, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"217": {
"auto_repair_shop_x_service.id": 217,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"219": {
"auto_repair_shop_x_service.id": 219,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"222": {
"auto_repair_shop_x_service.id": 222,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"221": {
"auto_repair_shop_x_service.id": 221,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"218": {
"auto_repair_shop_x_service.id": 218,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"220": {
"auto_repair_shop_x_service.id": 220,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"223": {
"auto_repair_shop_x_service.id": 223,
"service.id": 39,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Smart"
},
"224": {
"auto_repair_shop_x_service.id": 224,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
} |
{} | |
34 | 2017-11-20 21:13:39 | Jerrys Transmission Svc | 3108 Allison Bon Meml Dr | Bessemer, | AL | 35023 | Auto repair in Bessemer | 33.452042 | -86.973981 | This shop is not yet RepairPal Certified - | { "34": { "city_x_auto_repair_shop.id": 34, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"227": {
"auto_repair_shop_x_service.id": 227,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"226": {
"auto_repair_shop_x_service.id": 226,
"service.id": 18,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Hummer"
},
"225": {
"auto_repair_shop_x_service.id": 225,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"228": {
"auto_repair_shop_x_service.id": 228,
"service.id": 28,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Lexus"
},
"232": {
"auto_repair_shop_x_service.id": 232,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"230": {
"auto_repair_shop_x_service.id": 230,
"service.id": 39,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Smart"
},
"229": {
"auto_repair_shop_x_service.id": 229,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
},
"231": {
"auto_repair_shop_x_service.id": 231,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
} |
{} | |
35 | 2017-11-20 21:13:44 | Anthony Underwood Automotive | 4006 Bessemer Super Hwy | Bessemer, | AL | 35020 | Auto repair in Bessemer | 33.4293215 | -86.943574 | This shop is not yet RepairPal Certified - | { "35": { "city_x_auto_repair_shop.id": 35, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"233": {
"auto_repair_shop_x_service.id": 233,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"234": {
"auto_repair_shop_x_service.id": 234,
"service.id": 18,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Hummer"
},
"235": {
"auto_repair_shop_x_service.id": 235,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"236": {
"auto_repair_shop_x_service.id": 236,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"237": {
"auto_repair_shop_x_service.id": 237,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"238": {
"auto_repair_shop_x_service.id": 238,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
},
"240": {
"auto_repair_shop_x_service.id": 240,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
},
"239": {
"auto_repair_shop_x_service.id": 239,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
} |
{} | |
36 | 2017-11-20 21:13:50 | First Oil Change | 2530 N 19th St | Hueytown, | AL | 35023 | Auto repair 2.1 mi from Bessemer | (205) 424-1181 | 33.420097 | -86.98428 | This shop is not yet RepairPal Certified - | { "36": { "city_x_auto_repair_shop.id": 36, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"242": {
"auto_repair_shop_x_service.id": 242,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"247": {
"auto_repair_shop_x_service.id": 247,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"248": {
"auto_repair_shop_x_service.id": 248,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"246": {
"auto_repair_shop_x_service.id": 246,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"243": {
"auto_repair_shop_x_service.id": 243,
"service.id": 20,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Land Rover"
},
"244": {
"auto_repair_shop_x_service.id": 244,
"service.id": 28,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Lexus"
},
"241": {
"auto_repair_shop_x_service.id": 241,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"245": {
"auto_repair_shop_x_service.id": 245,
"service.id": 61,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Lincoln"
}
} |
{ "42": { "auto_repair_shop_x_specialty.id": 42, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" }, "41": { "auto_repair_shop_x_specialty.id": 41, "specialty.id": 4, "specialty.ts": "2017-11-20 21:10:05", "specialty.value": "Oil Change & Lube" } } |
37 | 2017-11-20 21:13:55 | Quick Oil Change | 1821 26th Ave | Hueytown, | AL | 35023 | Auto repair 2.1 mi from Bessemer | (205) 428-7755 | 33.4192835 | -86.9851809 | This shop is not yet RepairPal Certified - | { "37": { "city_x_auto_repair_shop.id": 37, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"249": {
"auto_repair_shop_x_service.id": 249,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"254": {
"auto_repair_shop_x_service.id": 254,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"253": {
"auto_repair_shop_x_service.id": 253,
"service.id": 13,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mazda"
},
"251": {
"auto_repair_shop_x_service.id": 251,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"250": {
"auto_repair_shop_x_service.id": 250,
"service.id": 50,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Ford"
},
"252": {
"auto_repair_shop_x_service.id": 252,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"256": {
"auto_repair_shop_x_service.id": 256,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
},
"255": {
"auto_repair_shop_x_service.id": 255,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
}
} |
{ "43": { "auto_repair_shop_x_specialty.id": 43, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
38 | 2017-11-20 21:14:02 | Eubanks Motors | 110 Ivy Ave | Heuytown, | AL | 35023 | Auto repair 3.1 mi from Bessemer | (205) 871-4635 | 33.441598 | -86.980044 | This shop is not yet RepairPal Certified - | { "38": { "city_x_auto_repair_shop.id": 38, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"260": {
"auto_repair_shop_x_service.id": 260,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"262": {
"auto_repair_shop_x_service.id": 262,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"263": {
"auto_repair_shop_x_service.id": 263,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"261": {
"auto_repair_shop_x_service.id": 261,
"service.id": 13,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mazda"
},
"264": {
"auto_repair_shop_x_service.id": 264,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"259": {
"auto_repair_shop_x_service.id": 259,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"257": {
"auto_repair_shop_x_service.id": 257,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"258": {
"auto_repair_shop_x_service.id": 258,
"service.id": 33,
"service.ts": "2017-11-20 21:11:13",
"service.value": "BMW"
}
} |
{ "44": { "auto_repair_shop_x_specialty.id": 44, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
39 | 2017-11-20 21:14:04 | The Mercedes Man | 116 Brooklane DR | Hueytown, | AL | 35023 | Auto repair 3.6 mi from Bessemer | (205) 914-8177 | 33.4492438 | -86.9791437 | This shop is not yet RepairPal Certified - | { "39": { "city_x_auto_repair_shop.id": 39, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | { "265": { "auto_repair_shop_x_service.id": 265, "service.id": 33, "service.ts": "2017-11-20 21:11:13", "service.value": "BMW" }, "266": { "auto_repair_shop_x_service.id": 266, "service.id": 118, "service.ts": "2017-11-20 21:12:14", "service.value": "Mercedes-Benz" } } | {} |
40 | 2017-11-20 21:14:12 | The Mercedes Man, LLC. | 116 Brooklane Drive | Hueytown, | AL | 35023 | Auto repair 3.6 mi from Bessemer | 33.449813 | -86.979114 | This shop is not yet RepairPal Certified - | { "40": { "city_x_auto_repair_shop.id": 40, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"274": {
"auto_repair_shop_x_service.id": 274,
"service.id": 4,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Ram"
},
"273": {
"auto_repair_shop_x_service.id": 273,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"272": {
"auto_repair_shop_x_service.id": 272,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"269": {
"auto_repair_shop_x_service.id": 269,
"service.id": 20,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Land Rover"
},
"268": {
"auto_repair_shop_x_service.id": 268,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"271": {
"auto_repair_shop_x_service.id": 271,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"267": {
"auto_repair_shop_x_service.id": 267,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"270": {
"auto_repair_shop_x_service.id": 270,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
}
} |
{} | |
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 |