You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Auto Repair Shop 1", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/list/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 20, "limit_total": 400, "time": 0.0221699999999999987354559749519467004574835300445556640625 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 56323, "pages_total": 2817 }, "struct": { "stem": { "0": "auto_repair_shop" }, "leaf": "auto_repair_shop.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "21": { "auto_repair_shop.id": 21, "auto_repair_shop.ts": "2017-11-20 21:12:28", "auto_repair_shop.title": "Ricky Hill Transmissions", "auto_repair_shop.streetaddress": "2810 Al Highway 205", "auto_repair_shop.addresslocality": "Boaz,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35956, "auto_repair_shop.distance_directions": "Auto repair in Boaz", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 34.16498200000000196041582967154681682586669921875, "auto_repair_shop.longitude": -86.139465000000001282387529499828815460205078125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": {} }, "22": { "auto_repair_shop.id": 22, "auto_repair_shop.ts": "2017-11-20 21:12:36", "auto_repair_shop.title": "Gambles Auto Serv & Parts", "auto_repair_shop.streetaddress": "2515 Morgan Rd", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35022, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 426-3351", "auto_repair_shop.latitude": 33.341956199999998489147401414811611175537109375, "auto_repair_shop.longitude": -86.92887070000000448999344371259212493896484375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "22": { "city_x_auto_repair_shop.id": 22, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "12": { "auto_repair_shop_x_amenties.id": 12, "amenties.id": 9, "amenties.ts": "2017-11-20 21:10:05", "amenties.value": "Parts/Accessories" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 23, "auto_repair_shop.ts": "2017-11-20 21:12:41", "auto_repair_shop.title": "Williamson Foreign Car Service", "auto_repair_shop.streetaddress": "2030 19th St", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35020, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.41508859999999714318619226105511188507080078125, "auto_repair_shop.longitude": -86.9755444000000039750375435687601566314697265625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "23": { "city_x_auto_repair_shop.id": 23, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 24, "auto_repair_shop.ts": "2017-11-20 21:12:47", "auto_repair_shop.title": "15th St Automotive", "auto_repair_shop.streetaddress": "1430 14th Ave N", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35020, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.40529699999999735382516519166529178619384765625, "auto_repair_shop.longitude": -86.97147400000000061481841839849948883056640625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "24": { "city_x_auto_repair_shop.id": 24, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 25, "auto_repair_shop.ts": "2017-11-20 21:12:49", "auto_repair_shop.title": "Moore Nissan", "auto_repair_shop.streetaddress": "5487 Academy Way", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35022, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 428-6314", "auto_repair_shop.latitude": 33.3630840000000006284608389250934123992919921875, "auto_repair_shop.longitude": -87.0088070000000044501575757749378681182861328125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "25": { "city_x_auto_repair_shop.id": 25, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "160": { "auto_repair_shop_x_service.id": 160, "service.id": 9, "service.ts": "2017-11-20 21:09:58", "service.value": "Nissan" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "29": { "auto_repair_shop_x_specialty.id": 29, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "26": { "auto_repair_shop.id": 26, "auto_repair_shop.ts": "2017-11-20 21:12:55", "auto_repair_shop.title": "Power Steering Associates", "auto_repair_shop.streetaddress": "1961 4th Ave. SW.", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35022, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 426-4327", "auto_repair_shop.latitude": 33.34250800000000225509211304597556591033935546875, "auto_repair_shop.longitude": -87.0018079999999969231794239021837711334228515625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "26": { "city_x_auto_repair_shop.id": 26, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "30": { "auto_repair_shop_x_specialty.id": 30, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "27": { "auto_repair_shop.id": 27, "auto_repair_shop.ts": "2017-11-20 21:12:59", "auto_repair_shop.title": "General Automotive", "auto_repair_shop.streetaddress": "2433 Lottie Dr Se", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35022, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 788-6058", "auto_repair_shop.latitude": 33.34627499999999855617716093547642230987548828125, "auto_repair_shop.longitude": -86.9101289999999977453626343049108982086181640625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "27": { "city_x_auto_repair_shop.id": 27, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "31": { "auto_repair_shop_x_specialty.id": 31, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "28": { "auto_repair_shop.id": 28, "auto_repair_shop.ts": "2017-11-20 21:13:01", "auto_repair_shop.title": "T E Tire & Battery", "auto_repair_shop.streetaddress": "1701 North 19th St", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 428-0111", "auto_repair_shop.latitude": 33.4131969000000026426278054714202880859375, "auto_repair_shop.longitude": -86.9715360000000003992681740783154964447021484375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "28": { "city_x_auto_repair_shop.id": 28, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "32": { "auto_repair_shop_x_specialty.id": 32, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "29": { "auto_repair_shop.id": 29, "auto_repair_shop.ts": "2017-11-20 21:13:08", "auto_repair_shop.title": "D & D Auto Repair", "auto_repair_shop.streetaddress": "5131a Bessemer Super Hwy", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35020, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 424-6031", "auto_repair_shop.latitude": 33.44259610000000293439370580017566680908203125, "auto_repair_shop.longitude": -86.9316989000000006626578397117555141448974609375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "29": { "city_x_auto_repair_shop.id": 29, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "33": { "auto_repair_shop_x_specialty.id": 33, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "30": { "auto_repair_shop.id": 30, "auto_repair_shop.ts": "2017-11-20 21:13:15", "auto_repair_shop.title": "Ken's Tires and Wheels", "auto_repair_shop.streetaddress": "99 Florence St", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 491-7009", "auto_repair_shop.latitude": 33.4531309999999990623109624721109867095947265625, "auto_repair_shop.longitude": -87.010999999999995679900166578590869903564453125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "30": { "city_x_auto_repair_shop.id": 30, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "34": { "auto_repair_shop_x_specialty.id": 34, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "31": { "auto_repair_shop.id": 31, "auto_repair_shop.ts": "2017-11-20 21:13:23", "auto_repair_shop.title": "Eastern Valley Auto Repair", "auto_repair_shop.streetaddress": "921 Eastern Valley Rd", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35020, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "(205) 426-6356", "auto_repair_shop.latitude": 33.3637360000000029458533390425145626068115234375, "auto_repair_shop.longitude": -86.969054999999997335180523805320262908935546875, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "31": { "city_x_auto_repair_shop.id": 31, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 32, "auto_repair_shop.ts": "2017-11-20 21:13:29", "auto_repair_shop.title": "Quality Auto Body", "auto_repair_shop.streetaddress": "2108 5Th Ave N", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35020, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.40613900000000313639247906394302845001220703125, "auto_repair_shop.longitude": -86.953790999999995392499840818345546722412109375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "32": { "city_x_auto_repair_shop.id": 32, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": {} }, "33": { "auto_repair_shop.id": 33, "auto_repair_shop.ts": "2017-11-20 21:13:34", "auto_repair_shop.title": "Jims Hobby Shop Old Car", "auto_repair_shop.streetaddress": "1415 Loveless Ln", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35022, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.38560499999999819920049048960208892822265625, "auto_repair_shop.longitude": -86.90329900000000407089828513562679290771484375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "33": { "city_x_auto_repair_shop.id": 33, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": {} }, "34": { "auto_repair_shop.id": 34, "auto_repair_shop.ts": "2017-11-20 21:13:39", "auto_repair_shop.title": "Jerrys Transmission Svc", "auto_repair_shop.streetaddress": "3108 Allison Bon Meml Dr", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.45204199999999872261469135992228984832763671875, "auto_repair_shop.longitude": -86.9739809999999948786353343166410923004150390625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "34": { "city_x_auto_repair_shop.id": 34, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": {} }, "35": { "auto_repair_shop.id": 35, "auto_repair_shop.ts": "2017-11-20 21:13:44", "auto_repair_shop.title": "Anthony Underwood Automotive", "auto_repair_shop.streetaddress": "4006 Bessemer Super Hwy", "auto_repair_shop.addresslocality": "Bessemer,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35020, "auto_repair_shop.distance_directions": "Auto repair in Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.4293215000000003556124283932149410247802734375, "auto_repair_shop.longitude": -86.9435739999999981364453560672700405120849609375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "35": { "city_x_auto_repair_shop.id": 35, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": {} }, "36": { "auto_repair_shop.id": 36, "auto_repair_shop.ts": "2017-11-20 21:13:50", "auto_repair_shop.title": "First Oil Change", "auto_repair_shop.streetaddress": "2530 N 19th St", "auto_repair_shop.addresslocality": "Hueytown,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair 2.1 mi from Bessemer", "auto_repair_shop.phone": "(205) 424-1181", "auto_repair_shop.latitude": 33.42009699999999838837538845837116241455078125, "auto_repair_shop.longitude": -86.9842799999999982674125931225717067718505859375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "36": { "city_x_auto_repair_shop.id": 36, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 37, "auto_repair_shop.ts": "2017-11-20 21:13:55", "auto_repair_shop.title": "Quick Oil Change", "auto_repair_shop.streetaddress": "1821 26th Ave", "auto_repair_shop.addresslocality": "Hueytown,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair 2.1 mi from Bessemer", "auto_repair_shop.phone": "(205) 428-7755", "auto_repair_shop.latitude": 33.41928349999999880992618273012340068817138671875, "auto_repair_shop.longitude": -86.9851809000000031346644391305744647979736328125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "37": { "city_x_auto_repair_shop.id": 37, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "43": { "auto_repair_shop_x_specialty.id": 43, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "38": { "auto_repair_shop.id": 38, "auto_repair_shop.ts": "2017-11-20 21:14:02", "auto_repair_shop.title": "Eubanks Motors", "auto_repair_shop.streetaddress": "110 Ivy Ave", "auto_repair_shop.addresslocality": "Heuytown,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair 3.1 mi from Bessemer", "auto_repair_shop.phone": "(205) 871-4635", "auto_repair_shop.latitude": 33.4415979999999990468495525419712066650390625, "auto_repair_shop.longitude": -86.9800440000000065765561885200440883636474609375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "38": { "city_x_auto_repair_shop.id": 38, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "44": { "auto_repair_shop_x_specialty.id": 44, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "39": { "auto_repair_shop.id": 39, "auto_repair_shop.ts": "2017-11-20 21:14:04", "auto_repair_shop.title": "The Mercedes Man", "auto_repair_shop.streetaddress": "116 Brooklane DR", "auto_repair_shop.addresslocality": "Hueytown,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair 3.6 mi from Bessemer", "auto_repair_shop.phone": "(205) 914-8177", "auto_repair_shop.latitude": 33.44924379999999786150510772131383419036865234375, "auto_repair_shop.longitude": -86.9791436999999945101080811582505702972412109375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "39": { "city_x_auto_repair_shop.id": 39, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": {} }, "40": { "auto_repair_shop.id": 40, "auto_repair_shop.ts": "2017-11-20 21:14:12", "auto_repair_shop.title": "The Mercedes Man, LLC.", "auto_repair_shop.streetaddress": "116 Brooklane Drive", "auto_repair_shop.addresslocality": "Hueytown,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair 3.6 mi from Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.44981299999999890815161052159965038299560546875, "auto_repair_shop.longitude": -86.9791139999999955989551381208002567291259765625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "40": { "city_x_auto_repair_shop.id": 40, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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.auto_repair_shop_x_specialty_id": {} } } } }