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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 2017-11-20 21:14:14 | Jiffy Lube Store 1899 | 3045 Allison Bonnett Memorial Dr | Hueytown, | AL | 35023 | Auto repair 3.7 mi from Bessemer | (205) 491-8934 | 33.4504254 | -86.9813865 | This shop is not yet RepairPal Certified - | { "41": { "city_x_auto_repair_shop.id": 41, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"276": {
"auto_repair_shop_x_service.id": 276,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"279": {
"auto_repair_shop_x_service.id": 279,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"281": {
"auto_repair_shop_x_service.id": 281,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"280": {
"auto_repair_shop_x_service.id": 280,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"282": {
"auto_repair_shop_x_service.id": 282,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
},
"278": {
"auto_repair_shop_x_service.id": 278,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"277": {
"auto_repair_shop_x_service.id": 277,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"275": {
"auto_repair_shop_x_service.id": 275,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
}
} |
{ "46": { "auto_repair_shop_x_specialty.id": 46, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" }, "45": { "auto_repair_shop_x_specialty.id": 45, "specialty.id": 4, "specialty.ts": "2017-11-20 21:10:05", "specialty.value": "Oil Change & Lube" } } |
42 | 2017-11-20 21:14:16 | H & S Garage | 10101 State Highway 160 | Birmingham, | AL | 35079 | Auto repair 3.8 mi from Bessemer | 33.4506595 | -86.9258705 | This shop is not yet RepairPal Certified - | { "42": { "city_x_auto_repair_shop.id": 42, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"287": {
"auto_repair_shop_x_service.id": 287,
"service.id": 8,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Mercury"
},
"288": {
"auto_repair_shop_x_service.id": 288,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"285": {
"auto_repair_shop_x_service.id": 285,
"service.id": 28,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Lexus"
},
"290": {
"auto_repair_shop_x_service.id": 290,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"284": {
"auto_repair_shop_x_service.id": 284,
"service.id": 52,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Jaguar"
},
"283": {
"auto_repair_shop_x_service.id": 283,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"286": {
"auto_repair_shop_x_service.id": 286,
"service.id": 61,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Lincoln"
},
"289": {
"auto_repair_shop_x_service.id": 289,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
}
} |
{ "47": { "auto_repair_shop_x_specialty.id": 47, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } | |
43 | 2017-11-20 21:14:21 | Holsey Automotive | 948 Larkin St | Dolomite, | AL | 35061 | Auto repair 3.9 mi from Bessemer | (205) 744-1181 | 33.457742 | -86.9599727 | This shop is not yet RepairPal Certified - | { "43": { "city_x_auto_repair_shop.id": 43, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"294": {
"auto_repair_shop_x_service.id": 294,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"293": {
"auto_repair_shop_x_service.id": 293,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"296": {
"auto_repair_shop_x_service.id": 296,
"service.id": 8,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Mercury"
},
"297": {
"auto_repair_shop_x_service.id": 297,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"298": {
"auto_repair_shop_x_service.id": 298,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"291": {
"auto_repair_shop_x_service.id": 291,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"295": {
"auto_repair_shop_x_service.id": 295,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"292": {
"auto_repair_shop_x_service.id": 292,
"service.id": 98,
"service.ts": "2017-11-20 21:12:04",
"service.value": "Audi"
}
} |
{ "48": { "auto_repair_shop_x_specialty.id": 48, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
44 | 2017-11-20 21:14:29 | Adamson West LLC | 506 Bessemer Super Hwy | Midfield, | AL | 35233 | Auto repair 4.4 mi from Bessemer | (205) 771-4700 | 33.457226 | -86.917578 | This shop is not yet RepairPal Certified - | { "44": { "city_x_auto_repair_shop.id": 44, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"306": {
"auto_repair_shop_x_service.id": 306,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"305": {
"auto_repair_shop_x_service.id": 305,
"service.id": 14,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mitsubishi"
},
"300": {
"auto_repair_shop_x_service.id": 300,
"service.id": 23,
"service.ts": "2017-11-20 21:10:20",
"service.value": "Buick"
},
"302": {
"auto_repair_shop_x_service.id": 302,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"299": {
"auto_repair_shop_x_service.id": 299,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"301": {
"auto_repair_shop_x_service.id": 301,
"service.id": 50,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Ford"
},
"304": {
"auto_repair_shop_x_service.id": 304,
"service.id": 54,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Mini"
},
"303": {
"auto_repair_shop_x_service.id": 303,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
}
} |
{ "49": { "auto_repair_shop_x_specialty.id": 49, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
45 | 2017-11-20 21:14:37 | Charlies Transmission Service | 131 Louis Ave | Hueytown, | AL | 35023 | Auto repair 4.7 mi from Bessemer | 33.454456 | -87.005894 | This shop is not yet RepairPal Certified - | { "45": { "city_x_auto_repair_shop.id": 45, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } } | {} | {
"308": {
"auto_repair_shop_x_service.id": 308,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"311": {
"auto_repair_shop_x_service.id": 311,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"312": {
"auto_repair_shop_x_service.id": 312,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"307": {
"auto_repair_shop_x_service.id": 307,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"314": {
"auto_repair_shop_x_service.id": 314,
"service.id": 31,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Toyota"
},
"313": {
"auto_repair_shop_x_service.id": 313,
"service.id": 39,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Smart"
},
"310": {
"auto_repair_shop_x_service.id": 310,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"309": {
"auto_repair_shop_x_service.id": 309,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
}
} |
{} | |
46 | 2017-11-20 21:14:46 | Rowes Automotive Service | 4100 4th Ave S | Birmingham, | AL | 35222 | Auto repair in Birmingham | (205) 595-5414 | 33.522762 | -86.773216 | This shop is not yet RepairPal Certified - | { "46": { "city_x_auto_repair_shop.id": 46, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"315": {
"auto_repair_shop_x_service.id": 315,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"320": {
"auto_repair_shop_x_service.id": 320,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"317": {
"auto_repair_shop_x_service.id": 317,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"321": {
"auto_repair_shop_x_service.id": 321,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"322": {
"auto_repair_shop_x_service.id": 322,
"service.id": 30,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Saab"
},
"318": {
"auto_repair_shop_x_service.id": 318,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"316": {
"auto_repair_shop_x_service.id": 316,
"service.id": 50,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Ford"
},
"319": {
"auto_repair_shop_x_service.id": 319,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
}
} |
{ "50": { "auto_repair_shop_x_specialty.id": 50, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
47 | 2017-11-20 21:14:55 | Adamson Ford | 1922 2nd Ave S | Birmingham, | AL | 35233 | Auto repair in Birmingham | (205) 271-4700 | 33.510349 | -86.804388 | This shop is not yet RepairPal Certified - | { "47": { "city_x_auto_repair_shop.id": 47, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | { "323": { "auto_repair_shop_x_service.id": 323, "service.id": 50, "service.ts": "2017-11-20 21:11:24", "service.value": "Ford" } } | { "51": { "auto_repair_shop_x_specialty.id": 51, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
48 | 2017-11-20 21:15:03 | Estes Automotive Center | 2331 5th Ave S | Birmingham, | AL | 35233 | Auto repair in Birmingham | (205) 251-3300 | 33.510341 | -86.796155 | This shop is not yet RepairPal Certified - | { "48": { "city_x_auto_repair_shop.id": 48, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | { "22": { "auto_repair_shop_x_amenties.id": 22, "amenties.id": 6, "amenties.ts": "2017-11-20 21:09:51", "amenties.value": "Heated Waiting Room" }, "23": { "auto_repair_shop_x_amenties.id": 23, "amenties.id": 9, "amenties.ts": "2017-11-20 21:10:05", "amenties.value": "Parts/Accessories" } } | {
"325": {
"auto_repair_shop_x_service.id": 325,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"329": {
"auto_repair_shop_x_service.id": 329,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"330": {
"auto_repair_shop_x_service.id": 330,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"327": {
"auto_repair_shop_x_service.id": 327,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"326": {
"auto_repair_shop_x_service.id": 326,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"331": {
"auto_repair_shop_x_service.id": 331,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
},
"328": {
"auto_repair_shop_x_service.id": 328,
"service.id": 61,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Lincoln"
},
"324": {
"auto_repair_shop_x_service.id": 324,
"service.id": 98,
"service.ts": "2017-11-20 21:12:04",
"service.value": "Audi"
}
} |
{
"55": {
"auto_repair_shop_x_specialty.id": 55,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"56": {
"auto_repair_shop_x_specialty.id": 56,
"specialty.id": 14,
"specialty.ts": "2017-11-20 21:11:54",
"specialty.value": "Tire Sales/Repair"
},
"57": {
"auto_repair_shop_x_specialty.id": 57,
"specialty.id": 23,
"specialty.ts": "2017-11-20 21:12:41",
"specialty.value": "Transmission Repair"
},
"52": {
"auto_repair_shop_x_specialty.id": 52,
"specialty.id": 24,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "AC/Heating"
},
"54": {
"auto_repair_shop_x_specialty.id": 54,
"specialty.id": 26,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "Diagnosis"
},
"53": {
"auto_repair_shop_x_specialty.id": 53,
"specialty.id": 53,
"specialty.ts": "2017-11-20 21:15:03",
"specialty.value": "Alignment"
}
} |
49 | 2017-11-20 21:15:05 | Jim Burke Nissan | 1300 3rd Avenue North | Birmingham, | AL | 35203 | Auto repair in Birmingham | (866) 432-7231 | 33.512175 | -86.816293 | This shop is not yet RepairPal Certified - | { "49": { "city_x_auto_repair_shop.id": 49, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | { "332": { "auto_repair_shop_x_service.id": 332, "service.id": 9, "service.ts": "2017-11-20 21:09:58", "service.value": "Nissan" } } | { "58": { "auto_repair_shop_x_specialty.id": 58, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
50 | 2017-11-20 21:15:11 | Rexs Auto Service | 1509 3rd Ave | Birmingham, | AL | 35203 | Auto repair in Birmingham | (205) 252-7088 | 33.5130299 | -86.8137856 | This shop is not yet RepairPal Certified - | { "50": { "city_x_auto_repair_shop.id": 50, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | { "24": { "auto_repair_shop_x_amenties.id": 24, "amenties.id": 9, "amenties.ts": "2017-11-20 21:10:05", "amenties.value": "Parts/Accessories" } } | { "333": { "auto_repair_shop_x_service.id": 333, "service.id": 50, "service.ts": "2017-11-20 21:11:24", "service.value": "Ford" } } | { "59": { "auto_repair_shop_x_specialty.id": 59, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" }, "60": { "auto_repair_shop_x_specialty.id": 60, "specialty.id": 23, "specialty.ts": "2017-11-20 21:12:41", "specialty.value": "Transmission Repair" } } |
51 | 2017-11-20 21:15:16 | Lee Rodgers Tire | 401 S. 21st St | Birmingham, | AL | 35233 | Auto repair in Birmingham | (205) 986-0138 | 33.512408 | -86.802109 | This shop is not yet RepairPal Certified - | { "51": { "city_x_auto_repair_shop.id": 51, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"334": {
"auto_repair_shop_x_service.id": 334,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"338": {
"auto_repair_shop_x_service.id": 338,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"339": {
"auto_repair_shop_x_service.id": 339,
"service.id": 12,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Saturn"
},
"336": {
"auto_repair_shop_x_service.id": 336,
"service.id": 28,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Lexus"
},
"341": {
"auto_repair_shop_x_service.id": 341,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
},
"335": {
"auto_repair_shop_x_service.id": 335,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"340": {
"auto_repair_shop_x_service.id": 340,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
},
"337": {
"auto_repair_shop_x_service.id": 337,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
}
} |
{ "61": { "auto_repair_shop_x_specialty.id": 61, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" }, "62": { "auto_repair_shop_x_specialty.id": 62, "specialty.id": 14, "specialty.ts": "2017-11-20 21:11:54", "specialty.value": "Tire Sales/Repair" } } |
52 | 2017-11-20 21:15:22 | Mark's Auto Services | 2616 5th Ave | Birmingham, | AL | 35233 | Auto repair in Birmingham | (205) 328-4421 | 33.51225 | -86.792888 | This shop is not yet RepairPal Certified - | { "52": { "city_x_auto_repair_shop.id": 52, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"345": {
"auto_repair_shop_x_service.id": 345,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"346": {
"auto_repair_shop_x_service.id": 346,
"service.id": 9,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Nissan"
},
"344": {
"auto_repair_shop_x_service.id": 344,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"349": {
"auto_repair_shop_x_service.id": 349,
"service.id": 32,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Volvo"
},
"342": {
"auto_repair_shop_x_service.id": 342,
"service.id": 33,
"service.ts": "2017-11-20 21:11:13",
"service.value": "BMW"
},
"343": {
"auto_repair_shop_x_service.id": 343,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"348": {
"auto_repair_shop_x_service.id": 348,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
},
"347": {
"auto_repair_shop_x_service.id": 347,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
} |
{ "63": { "auto_repair_shop_x_specialty.id": 63, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
53 | 2017-11-20 21:15:30 | K & W Auto Service | 2410 4th Ave S | Birmingham, | AL | 35233 | Auto repair in Birmingham | (205) 251-1111 | 33.512233 | -86.796116 | This shop is not yet RepairPal Certified - | { "53": { "city_x_auto_repair_shop.id": 53, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"350": {
"auto_repair_shop_x_service.id": 350,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"351": {
"auto_repair_shop_x_service.id": 351,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"354": {
"auto_repair_shop_x_service.id": 354,
"service.id": 18,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Hummer"
},
"355": {
"auto_repair_shop_x_service.id": 355,
"service.id": 27,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Infiniti"
},
"353": {
"auto_repair_shop_x_service.id": 353,
"service.id": 42,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Honda"
},
"352": {
"auto_repair_shop_x_service.id": 352,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
},
"357": {
"auto_repair_shop_x_service.id": 357,
"service.id": 62,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Suzuki"
},
"356": {
"auto_repair_shop_x_service.id": 356,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
}
} |
{ "64": { "auto_repair_shop_x_specialty.id": 64, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
54 | 2017-11-20 21:15:36 | Mays Auto Service | 5600 1st Ave S | Birmingham, | AL | 35212 | Auto repair in Birmingham | (205) 592-6078 | 33.540626 | -86.750576 | This shop is not yet RepairPal Certified - | { "54": { "city_x_auto_repair_shop.id": 54, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"359": {
"auto_repair_shop_x_service.id": 359,
"service.id": 7,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Hyundai"
},
"363": {
"auto_repair_shop_x_service.id": 363,
"service.id": 11,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Pontiac"
},
"360": {
"auto_repair_shop_x_service.id": 360,
"service.id": 19,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Isuzu"
},
"364": {
"auto_repair_shop_x_service.id": 364,
"service.id": 22,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Porsche"
},
"362": {
"auto_repair_shop_x_service.id": 362,
"service.id": 28,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Lexus"
},
"365": {
"auto_repair_shop_x_service.id": 365,
"service.id": 40,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Volkswagen"
},
"361": {
"auto_repair_shop_x_service.id": 361,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"358": {
"auto_repair_shop_x_service.id": 358,
"service.id": 51,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Geo"
}
} |
{ "65": { "auto_repair_shop_x_specialty.id": 65, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
55 | 2017-11-20 21:15:39 | Serra Honda | 1813 Ensley Ave | Birmingham, | AL | 35218 | Auto repair in Birmingham | 33.5108483 | -86.8859151 | This shop is not yet RepairPal Certified - | { "55": { "city_x_auto_repair_shop.id": 55, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {
"28": {
"auto_repair_shop_x_amenties.id": 28,
"amenties.id": 1,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Car Wash"
},
"29": {
"auto_repair_shop_x_amenties.id": 29,
"amenties.id": 2,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Child Friendly"
},
"30": {
"auto_repair_shop_x_amenties.id": 30,
"amenties.id": 3,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Coffee"
},
"31": {
"auto_repair_shop_x_amenties.id": 31,
"amenties.id": 4,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Early Bird Dropoff"
},
"25": {
"auto_repair_shop_x_amenties.id": 25,
"amenties.id": 25,
"amenties.ts": "2017-11-20 21:15:39",
"amenties.value": "AAA Member Discount"
},
"26": {
"auto_repair_shop_x_amenties.id": 26,
"amenties.id": 26,
"amenties.ts": "2017-11-20 21:15:39",
"amenties.value": "Car Delivery"
},
"27": {
"auto_repair_shop_x_amenties.id": 27,
"amenties.id": 27,
"amenties.ts": "2017-11-20 21:15:39",
"amenties.value": "Car Pickup/Dropoff"
},
"32": {
"auto_repair_shop_x_amenties.id": 32,
"amenties.id": 32,
"amenties.ts": "2017-11-20 21:15:39",
"amenties.value": "Free Multi-Point Safety Inspection"
}
} |
{ "366": { "auto_repair_shop_x_service.id": 366, "service.id": 42, "service.ts": "2017-11-20 21:11:17", "service.value": "Honda" } } | {
"70": {
"auto_repair_shop_x_specialty.id": 70,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"66": {
"auto_repair_shop_x_specialty.id": 66,
"specialty.id": 3,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Collision Repair & Paint"
},
"68": {
"auto_repair_shop_x_specialty.id": 68,
"specialty.id": 4,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Oil Change & Lube"
},
"71": {
"auto_repair_shop_x_specialty.id": 71,
"specialty.id": 14,
"specialty.ts": "2017-11-20 21:11:54",
"specialty.value": "Tire Sales/Repair"
},
"72": {
"auto_repair_shop_x_specialty.id": 72,
"specialty.id": 23,
"specialty.ts": "2017-11-20 21:12:41",
"specialty.value": "Transmission Repair"
},
"67": {
"auto_repair_shop_x_specialty.id": 67,
"specialty.id": 67,
"specialty.ts": "2017-11-20 21:15:39",
"specialty.value": "Muffler & Exhaust"
},
"69": {
"auto_repair_shop_x_specialty.id": 69,
"specialty.id": 69,
"specialty.ts": "2017-11-20 21:15:39",
"specialty.value": "Roadside Assistance"
},
"73": {
"auto_repair_shop_x_specialty.id": 73,
"specialty.id": 73,
"specialty.ts": "2017-11-20 21:15:39",
"specialty.value": "Upholstery"
}
} |
|
56 | 2017-11-20 21:15:43 | World Class Auto Repair | 4710 5th Ave S | Birmingham, | AL | 35222 | Auto repair in Birmingham | (205) 591-7990 | 33.5276408 | -86.7611122 | This shop is not yet RepairPal Certified - | { "56": { "city_x_auto_repair_shop.id": 56, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {
"34": {
"auto_repair_shop_x_amenties.id": 34,
"amenties.id": 6,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Heated Waiting Room"
},
"35": {
"auto_repair_shop_x_amenties.id": 35,
"amenties.id": 9,
"amenties.ts": "2017-11-20 21:10:05",
"amenties.value": "Parts/Accessories"
},
"36": {
"auto_repair_shop_x_amenties.id": 36,
"amenties.id": 11,
"amenties.ts": "2017-11-20 21:11:40",
"amenties.value": "Service Guarantee"
},
"33": {
"auto_repair_shop_x_amenties.id": 33,
"amenties.id": 27,
"amenties.ts": "2017-11-20 21:15:39",
"amenties.value": "Car Pickup/Dropoff"
},
"37": {
"auto_repair_shop_x_amenties.id": 37,
"amenties.id": 37,
"amenties.ts": "2017-11-20 21:15:43",
"amenties.value": "Wireless Internet"
}
} |
{
"369": {
"auto_repair_shop_x_service.id": 369,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"371": {
"auto_repair_shop_x_service.id": 371,
"service.id": 3,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Jeep"
},
"368": {
"auto_repair_shop_x_service.id": 368,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"370": {
"auto_repair_shop_x_service.id": 370,
"service.id": 18,
"service.ts": "2017-11-20 21:10:16",
"service.value": "Hummer"
},
"367": {
"auto_repair_shop_x_service.id": 367,
"service.id": 23,
"service.ts": "2017-11-20 21:10:20",
"service.value": "Buick"
},
"372": {
"auto_repair_shop_x_service.id": 372,
"service.id": 30,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Saab"
},
"373": {
"auto_repair_shop_x_service.id": 373,
"service.id": 39,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Smart"
},
"374": {
"auto_repair_shop_x_service.id": 374,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
} |
{
"80": {
"auto_repair_shop_x_specialty.id": 80,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"78": {
"auto_repair_shop_x_specialty.id": 78,
"specialty.id": 4,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Oil Change & Lube"
},
"79": {
"auto_repair_shop_x_specialty.id": 79,
"specialty.id": 5,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Scheduled Maintenance"
},
"74": {
"auto_repair_shop_x_specialty.id": 74,
"specialty.id": 24,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "AC/Heating"
},
"75": {
"auto_repair_shop_x_specialty.id": 75,
"specialty.id": 25,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "Check Engine Light"
},
"76": {
"auto_repair_shop_x_specialty.id": 76,
"specialty.id": 26,
"specialty.ts": "2017-11-20 21:12:47",
"specialty.value": "Diagnosis"
},
"81": {
"auto_repair_shop_x_specialty.id": 81,
"specialty.id": 40,
"specialty.ts": "2017-11-20 21:13:23",
"specialty.value": "Timing Belts"
},
"77": {
"auto_repair_shop_x_specialty.id": 77,
"specialty.id": 67,
"specialty.ts": "2017-11-20 21:15:39",
"specialty.value": "Muffler & Exhaust"
}
} |
57 | 2017-11-20 21:15:44 | Drivetoday USA | 700 8th St S | Birmingham, | AL | 35233 | Auto repair in Birmingham | (205) 714-3440 | 33.4977155 | -86.8162346 | This shop is not yet RepairPal Certified - | { "57": { "city_x_auto_repair_shop.id": 57, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"381": {
"auto_repair_shop_x_service.id": 381,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"382": {
"auto_repair_shop_x_service.id": 382,
"service.id": 2,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Dodge"
},
"380": {
"auto_repair_shop_x_service.id": 380,
"service.id": 5,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Chevrolet"
},
"378": {
"auto_repair_shop_x_service.id": 378,
"service.id": 23,
"service.ts": "2017-11-20 21:10:20",
"service.value": "Buick"
},
"375": {
"auto_repair_shop_x_service.id": 375,
"service.id": 25,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Acura"
},
"377": {
"auto_repair_shop_x_service.id": 377,
"service.id": 33,
"service.ts": "2017-11-20 21:11:13",
"service.value": "BMW"
},
"379": {
"auto_repair_shop_x_service.id": 379,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"376": {
"auto_repair_shop_x_service.id": 376,
"service.id": 98,
"service.ts": "2017-11-20 21:12:04",
"service.value": "Audi"
}
} |
{ "82": { "auto_repair_shop_x_specialty.id": 82, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } |
58 | 2017-11-20 21:15:52 | Limbaugh Toyota | 2200 Avenue T | Birmingham, | AL | 35218 | Auto repair in Birmingham | (205) 780-0500 | 33.507014 | -86.881701 | This shop is not yet RepairPal Certified - | { "58": { "city_x_auto_repair_shop.id": 58, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {
"39": {
"auto_repair_shop_x_amenties.id": 39,
"amenties.id": 2,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Child Friendly"
},
"40": {
"auto_repair_shop_x_amenties.id": 40,
"amenties.id": 3,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Coffee"
},
"43": {
"auto_repair_shop_x_amenties.id": 43,
"amenties.id": 6,
"amenties.ts": "2017-11-20 21:09:51",
"amenties.value": "Heated Waiting Room"
},
"38": {
"auto_repair_shop_x_amenties.id": 38,
"amenties.id": 25,
"amenties.ts": "2017-11-20 21:15:39",
"amenties.value": "AAA Member Discount"
},
"42": {
"auto_repair_shop_x_amenties.id": 42,
"amenties.id": 32,
"amenties.ts": "2017-11-20 21:15:39",
"amenties.value": "Free Multi-Point Safety Inspection"
},
"41": {
"auto_repair_shop_x_amenties.id": 41,
"amenties.id": 41,
"amenties.ts": "2017-11-20 21:15:52",
"amenties.value": "Financing"
},
"44": {
"auto_repair_shop_x_amenties.id": 44,
"amenties.id": 44,
"amenties.ts": "2017-11-20 21:15:52",
"amenties.value": "Open Saturday"
},
"45": {
"auto_repair_shop_x_amenties.id": 45,
"amenties.id": 45,
"amenties.ts": "2017-11-20 21:15:52",
"amenties.value": "Rental Car"
}
} |
{ "383": { "auto_repair_shop_x_service.id": 383, "service.id": 31, "service.ts": "2017-11-20 21:10:26", "service.value": "Toyota" } } | {
"86": {
"auto_repair_shop_x_specialty.id": 86,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"83": {
"auto_repair_shop_x_specialty.id": 83,
"specialty.id": 3,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Collision Repair & Paint"
},
"85": {
"auto_repair_shop_x_specialty.id": 85,
"specialty.id": 4,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Oil Change & Lube"
},
"87": {
"auto_repair_shop_x_specialty.id": 87,
"specialty.id": 14,
"specialty.ts": "2017-11-20 21:11:54",
"specialty.value": "Tire Sales/Repair"
},
"88": {
"auto_repair_shop_x_specialty.id": 88,
"specialty.id": 23,
"specialty.ts": "2017-11-20 21:12:41",
"specialty.value": "Transmission Repair"
},
"84": {
"auto_repair_shop_x_specialty.id": 84,
"specialty.id": 67,
"specialty.ts": "2017-11-20 21:15:39",
"specialty.value": "Muffler & Exhaust"
},
"89": {
"auto_repair_shop_x_specialty.id": 89,
"specialty.id": 89,
"specialty.ts": "2017-11-20 21:15:52",
"specialty.value": "Windshield/Glass"
}
} |
59 | 2017-11-20 21:15:57 | Texaco Xpress Lube | 4500 Montevallo Rd | Birmingham, | AL | 35213 | Auto repair in Birmingham | (205) 956-8180 | 33.5211346 | -86.7263514 | This shop is not yet RepairPal Certified - | { "59": { "city_x_auto_repair_shop.id": 59, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"386": {
"auto_repair_shop_x_service.id": 386,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"387": {
"auto_repair_shop_x_service.id": 387,
"service.id": 24,
"service.ts": "2017-11-20 21:10:20",
"service.value": "GMC"
},
"384": {
"auto_repair_shop_x_service.id": 384,
"service.id": 33,
"service.ts": "2017-11-20 21:11:13",
"service.value": "BMW"
},
"391": {
"auto_repair_shop_x_service.id": 391,
"service.id": 39,
"service.ts": "2017-11-20 21:11:13",
"service.value": "Smart"
},
"388": {
"auto_repair_shop_x_service.id": 388,
"service.id": 45,
"service.ts": "2017-11-20 21:11:17",
"service.value": "Kia"
},
"390": {
"auto_repair_shop_x_service.id": 390,
"service.id": 56,
"service.ts": "2017-11-20 21:11:24",
"service.value": "Scion"
},
"385": {
"auto_repair_shop_x_service.id": 385,
"service.id": 57,
"service.ts": "2017-11-20 21:11:34",
"service.value": "Cadillac"
},
"389": {
"auto_repair_shop_x_service.id": 389,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
}
} |
{
"91": {
"auto_repair_shop_x_specialty.id": 91,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"90": {
"auto_repair_shop_x_specialty.id": 90,
"specialty.id": 4,
"specialty.ts": "2017-11-20 21:10:05",
"specialty.value": "Oil Change & Lube"
},
"92": {
"auto_repair_shop_x_specialty.id": 92,
"specialty.id": 14,
"specialty.ts": "2017-11-20 21:11:54",
"specialty.value": "Tire Sales/Repair"
},
"93": {
"auto_repair_shop_x_specialty.id": 93,
"specialty.id": 23,
"specialty.ts": "2017-11-20 21:12:41",
"specialty.value": "Transmission Repair"
}
} |
60 | 2017-11-20 21:16:02 | Midas Auto Service Experts | 436 Green Springs Hwy | Birmingham, | AL | 35209 | Auto repair in Birmingham | (205) 942-4489 | 33.464073 | -86.8203689 | This shop is not yet RepairPal Certified - | { "60": { "city_x_auto_repair_shop.id": 60, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } } | {} | {
"393": {
"auto_repair_shop_x_service.id": 393,
"service.id": 1,
"service.ts": "2017-11-20 21:09:51",
"service.value": "Chrysler"
},
"397": {
"auto_repair_shop_x_service.id": 397,
"service.id": 10,
"service.ts": "2017-11-20 21:09:58",
"service.value": "Plymouth"
},
"394": {
"auto_repair_shop_x_service.id": 394,
"service.id": 13,
"service.ts": "2017-11-20 21:10:05",
"service.value": "Mazda"
},
"398": {
"auto_repair_shop_x_service.id": 398,
"service.id": 30,
"service.ts": "2017-11-20 21:10:26",
"service.value": "Saab"
},
"396": {
"auto_repair_shop_x_service.id": 396,
"service.id": 88,
"service.ts": "2017-11-20 21:11:54",
"service.value": "Oldsmobile"
},
"392": {
"auto_repair_shop_x_service.id": 392,
"service.id": 98,
"service.ts": "2017-11-20 21:12:04",
"service.value": "Audi"
},
"395": {
"auto_repair_shop_x_service.id": 395,
"service.id": 118,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Mercedes-Benz"
},
"399": {
"auto_repair_shop_x_service.id": 399,
"service.id": 122,
"service.ts": "2017-11-20 21:12:14",
"service.value": "Subaru"
}
} |
{
"95": {
"auto_repair_shop_x_specialty.id": 95,
"specialty.id": 1,
"specialty.ts": "2017-11-20 21:09:51",
"specialty.value": "Service & Repair"
},
"96": {
"auto_repair_shop_x_specialty.id": 96,
"specialty.id": 14,
"specialty.ts": "2017-11-20 21:11:54",
"specialty.value": "Tire Sales/Repair"
},
"94": {
"auto_repair_shop_x_specialty.id": 94,
"specialty.id": 67,
"specialty.ts": "2017-11-20 21:15:39",
"specialty.value": "Muffler & Exhaust"
}
} |
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 |