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"" } }",{}