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/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/main/list/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 20, "limit_total": 400, "time": 0.01434999999999999990840660046842458541505038738250732421875 }, "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": { "41": { "auto_repair_shop.id": 41, "auto_repair_shop.ts": "2017-11-20 21:14:14", "auto_repair_shop.title": "Jiffy Lube Store 1899", "auto_repair_shop.streetaddress": "3045 Allison Bonnett Memorial Dr", "auto_repair_shop.addresslocality": "Hueytown,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair 3.7 mi from Bessemer", "auto_repair_shop.phone": "(205) 491-8934", "auto_repair_shop.latitude": 33.450425400000000308864400722086429595947265625, "auto_repair_shop.longitude": -86.9813864999999992733137332834303379058837890625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "41": { "city_x_auto_repair_shop.id": 41, "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": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 42, "auto_repair_shop.ts": "2017-11-20 21:14:16", "auto_repair_shop.title": "H & S Garage", "auto_repair_shop.streetaddress": "10101 State Highway 160", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35079, "auto_repair_shop.distance_directions": "Auto repair 3.8 mi from Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.450659500000000434738467447459697723388671875, "auto_repair_shop.longitude": -86.925870500000002039087121374905109405517578125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "42": { "city_x_auto_repair_shop.id": 42, "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": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "47": { "auto_repair_shop_x_specialty.id": 47, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "43": { "auto_repair_shop.id": 43, "auto_repair_shop.ts": "2017-11-20 21:14:21", "auto_repair_shop.title": "Holsey Automotive", "auto_repair_shop.streetaddress": "948 Larkin St", "auto_repair_shop.addresslocality": "Dolomite,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35061, "auto_repair_shop.distance_directions": "Auto repair 3.9 mi from Bessemer", "auto_repair_shop.phone": "(205) 744-1181", "auto_repair_shop.latitude": 33.45774200000000320187609759159386157989501953125, "auto_repair_shop.longitude": -86.9599726999999944609953672625124454498291015625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "43": { "city_x_auto_repair_shop.id": 43, "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": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "48": { "auto_repair_shop_x_specialty.id": 48, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "44": { "auto_repair_shop.id": 44, "auto_repair_shop.ts": "2017-11-20 21:14:29", "auto_repair_shop.title": "Adamson West LLC", "auto_repair_shop.streetaddress": "506 Bessemer Super Hwy", "auto_repair_shop.addresslocality": "Midfield,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35233, "auto_repair_shop.distance_directions": "Auto repair 4.4 mi from Bessemer", "auto_repair_shop.phone": "(205) 771-4700", "auto_repair_shop.latitude": 33.45722599999999857800503377802670001983642578125, "auto_repair_shop.longitude": -86.9175780000000059999365475960075855255126953125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "44": { "city_x_auto_repair_shop.id": 44, "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": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "49": { "auto_repair_shop_x_specialty.id": 49, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "45": { "auto_repair_shop.id": 45, "auto_repair_shop.ts": "2017-11-20 21:14:37", "auto_repair_shop.title": "Charlies Transmission Service", "auto_repair_shop.streetaddress": "131 Louis Ave", "auto_repair_shop.addresslocality": "Hueytown,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35023, "auto_repair_shop.distance_directions": "Auto repair 4.7 mi from Bessemer", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.45445600000000041518433135934174060821533203125, "auto_repair_shop.longitude": -87.0058939999999978454070514999330043792724609375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "45": { "city_x_auto_repair_shop.id": 45, "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": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": {} }, "46": { "auto_repair_shop.id": 46, "auto_repair_shop.ts": "2017-11-20 21:14:46", "auto_repair_shop.title": "Rowes Automotive Service", "auto_repair_shop.streetaddress": "4100 4th Ave S", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35222, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 595-5414", "auto_repair_shop.latitude": 33.52276200000000017098500393331050872802734375, "auto_repair_shop.longitude": -86.7732160000000050104063120670616626739501953125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "46": { "city_x_auto_repair_shop.id": 46, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "50": { "auto_repair_shop_x_specialty.id": 50, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "47": { "auto_repair_shop.id": 47, "auto_repair_shop.ts": "2017-11-20 21:14:55", "auto_repair_shop.title": "Adamson Ford", "auto_repair_shop.streetaddress": "1922 2nd Ave S", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35233, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 271-4700", "auto_repair_shop.latitude": 33.51034899999999794317773194052278995513916015625, "auto_repair_shop.longitude": -86.8043880000000029895090847276151180267333984375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "47": { "city_x_auto_repair_shop.id": 47, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "323": { "auto_repair_shop_x_service.id": 323, "service.id": 50, "service.ts": "2017-11-20 21:11:24", "service.value": "Ford" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "51": { "auto_repair_shop_x_specialty.id": 51, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "48": { "auto_repair_shop.id": 48, "auto_repair_shop.ts": "2017-11-20 21:15:03", "auto_repair_shop.title": "Estes Automotive Center", "auto_repair_shop.streetaddress": "2331 5th Ave S", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35233, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 251-3300", "auto_repair_shop.latitude": 33.5103409999999968249539961107075214385986328125, "auto_repair_shop.longitude": -86.79615499999999883584678173065185546875, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "48": { "city_x_auto_repair_shop.id": 48, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 49, "auto_repair_shop.ts": "2017-11-20 21:15:05", "auto_repair_shop.title": "Jim Burke Nissan", "auto_repair_shop.streetaddress": "1300 3rd Avenue North", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35203, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(866) 432-7231", "auto_repair_shop.latitude": 33.5121749999999991587174008600413799285888671875, "auto_repair_shop.longitude": -86.816293000000001711669028736650943756103515625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "49": { "city_x_auto_repair_shop.id": 49, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "332": { "auto_repair_shop_x_service.id": 332, "service.id": 9, "service.ts": "2017-11-20 21:09:58", "service.value": "Nissan" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "58": { "auto_repair_shop_x_specialty.id": 58, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "50": { "auto_repair_shop.id": 50, "auto_repair_shop.ts": "2017-11-20 21:15:11", "auto_repair_shop.title": "Rexs Auto Service", "auto_repair_shop.streetaddress": "1509 3rd Ave", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35203, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 252-7088", "auto_repair_shop.latitude": 33.51302989999999937253960524685680866241455078125, "auto_repair_shop.longitude": -86.8137856000000027734131435863673686981201171875, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "50": { "city_x_auto_repair_shop.id": 50, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "24": { "auto_repair_shop_x_amenties.id": 24, "amenties.id": 9, "amenties.ts": "2017-11-20 21:10:05", "amenties.value": "Parts/Accessories" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "333": { "auto_repair_shop_x_service.id": 333, "service.id": 50, "service.ts": "2017-11-20 21:11:24", "service.value": "Ford" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 51, "auto_repair_shop.ts": "2017-11-20 21:15:16", "auto_repair_shop.title": "Lee Rodgers Tire", "auto_repair_shop.streetaddress": "401 S. 21st St", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35233, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 986-0138", "auto_repair_shop.latitude": 33.51240800000000064073901739902794361114501953125, "auto_repair_shop.longitude": -86.802109000000001515218173153698444366455078125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "51": { "city_x_auto_repair_shop.id": 51, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 52, "auto_repair_shop.ts": "2017-11-20 21:15:22", "auto_repair_shop.title": "Mark's Auto Services", "auto_repair_shop.streetaddress": "2616 5th Ave", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35233, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 328-4421", "auto_repair_shop.latitude": 33.51225000000000164845914696343243122100830078125, "auto_repair_shop.longitude": -86.79288800000000492218532599508762359619140625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "52": { "city_x_auto_repair_shop.id": 52, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "63": { "auto_repair_shop_x_specialty.id": 63, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "53": { "auto_repair_shop.id": 53, "auto_repair_shop.ts": "2017-11-20 21:15:30", "auto_repair_shop.title": "K & W Auto Service", "auto_repair_shop.streetaddress": "2410 4th Ave S", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35233, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 251-1111", "auto_repair_shop.latitude": 33.51223300000000193676896742545068264007568359375, "auto_repair_shop.longitude": -86.7961159999999978253981680609285831451416015625, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "53": { "city_x_auto_repair_shop.id": 53, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "64": { "auto_repair_shop_x_specialty.id": 64, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "54": { "auto_repair_shop.id": 54, "auto_repair_shop.ts": "2017-11-20 21:15:36", "auto_repair_shop.title": "Mays Auto Service", "auto_repair_shop.streetaddress": "5600 1st Ave S", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35212, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 592-6078", "auto_repair_shop.latitude": 33.540626000000003159584593959152698516845703125, "auto_repair_shop.longitude": -86.750575999999995246980688534677028656005859375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "54": { "city_x_auto_repair_shop.id": 54, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "65": { "auto_repair_shop_x_specialty.id": 65, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "55": { "auto_repair_shop.id": 55, "auto_repair_shop.ts": "2017-11-20 21:15:39", "auto_repair_shop.title": "Serra Honda", "auto_repair_shop.streetaddress": "1813 Ensley Ave", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35218, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": 33.51084829999999925576048553921282291412353515625, "auto_repair_shop.longitude": -86.885915100000005395486368797719478607177734375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "55": { "city_x_auto_repair_shop.id": 55, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "366": { "auto_repair_shop_x_service.id": 366, "service.id": 42, "service.ts": "2017-11-20 21:11:17", "service.value": "Honda" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 56, "auto_repair_shop.ts": "2017-11-20 21:15:43", "auto_repair_shop.title": "World Class Auto Repair", "auto_repair_shop.streetaddress": "4710 5th Ave S", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35222, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 591-7990", "auto_repair_shop.latitude": 33.527640800000000353975337930023670196533203125, "auto_repair_shop.longitude": -86.7611121999999994613972376100718975067138671875, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "56": { "city_x_auto_repair_shop.id": 56, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 57, "auto_repair_shop.ts": "2017-11-20 21:15:44", "auto_repair_shop.title": "Drivetoday USA", "auto_repair_shop.streetaddress": "700 8th St S", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35233, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 714-3440", "auto_repair_shop.latitude": 33.497715499999998201019479893147945404052734375, "auto_repair_shop.longitude": -86.816234600000001364605850540101528167724609375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "57": { "city_x_auto_repair_shop.id": 57, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "82": { "auto_repair_shop_x_specialty.id": 82, "specialty.id": 1, "specialty.ts": "2017-11-20 21:09:51", "specialty.value": "Service & Repair" } } }, "58": { "auto_repair_shop.id": 58, "auto_repair_shop.ts": "2017-11-20 21:15:52", "auto_repair_shop.title": "Limbaugh Toyota", "auto_repair_shop.streetaddress": "2200 Avenue T", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35218, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 780-0500", "auto_repair_shop.latitude": 33.507013999999998077328200452029705047607421875, "auto_repair_shop.longitude": -86.8817010000000067293512984178960323333740234375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "58": { "city_x_auto_repair_shop.id": 58, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_service_id": { "383": { "auto_repair_shop_x_service.id": 383, "service.id": 31, "service.ts": "2017-11-20 21:10:26", "service.value": "Toyota" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 59, "auto_repair_shop.ts": "2017-11-20 21:15:57", "auto_repair_shop.title": "Texaco Xpress Lube", "auto_repair_shop.streetaddress": "4500 Montevallo Rd", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35213, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 956-8180", "auto_repair_shop.latitude": 33.52113460000000344507498084567487239837646484375, "auto_repair_shop.longitude": -86.7263513999999986481270752847194671630859375, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "59": { "city_x_auto_repair_shop.id": 59, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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": { "auto_repair_shop.id": 60, "auto_repair_shop.ts": "2017-11-20 21:16:02", "auto_repair_shop.title": "Midas Auto Service Experts", "auto_repair_shop.streetaddress": "436 Green Springs Hwy", "auto_repair_shop.addresslocality": "Birmingham,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": 35209, "auto_repair_shop.distance_directions": "Auto repair in Birmingham", "auto_repair_shop.phone": "(205) 942-4489", "auto_repair_shop.latitude": 33.4640729999999990695869200862944126129150390625, "auto_repair_shop.longitude": -86.82036890000000539657776243984699249267578125, "auto_repair_shop.description": "This shop is not yet RepairPal Certified -", "auto_repair_shop.city_x_auto_repair_shop_id": { "60": { "city_x_auto_repair_shop.id": 60, "city.id": 3, "city.ts": "2017-11-19 21:33:21", "city.title": "Birmingham" } }, "auto_repair_shop.auto_repair_shop_x_amenties_id": {}, "auto_repair_shop.auto_repair_shop_x_service_id": { "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" } }, "auto_repair_shop.auto_repair_shop_x_specialty_id": { "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" } } } } } }