{ "sample": { "is_sample": "TRUE", "limit_total": 200 }, "api": { "title": "Auto Repair Shop 1", "point": { "title": "By Table", "desc": "Each API function returns data by a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/by_table/city_x_auto_repair_shop/?app=json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shop_1/by_table/city_x_auto_repair_shop/2/?app=json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 30, "limit_total": 200, "time": "0.1524" }, "stats": { "raw_rows": 30, "rows": 30, "rows_total": 89690, "pages_total": 2990 }, "struct": { "stem": [ "city_x_auto_repair_shop", "city", "auto_repair_shop" ], "leaf": "city_x_auto_repair_shop.id", "leaf_stem": [], "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city_x_auto_repair_shop.id": 1, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 1, "auto_repair_shop.ts": "2017-11-20 21:09:51", "auto_repair_shop.title": "Alexander Dodge Chrysler Jeep Ram", "auto_repair_shop.streetaddress": "6764 US Hway 431", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 5.3 mi from Boaz", "auto_repair_shop.phone": "(855) 726-1946", "auto_repair_shop.latitude": "34.2729243", "auto_repair_shop.longitude": "-86.1985577", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "2": { "city_x_auto_repair_shop.id": 2, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 2, "auto_repair_shop.ts": "2017-11-20 21:09:58", "auto_repair_shop.title": "Superior Auto Care", "auto_repair_shop.streetaddress": "8842 Us Highway 431", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 0.8 mi from Boaz", "auto_repair_shop.phone": "(256) 891-1109", "auto_repair_shop.latitude": "34.206674", "auto_repair_shop.longitude": "-86.153788", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "3": { "city_x_auto_repair_shop.id": 3, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 3, "auto_repair_shop.ts": "2017-11-20 21:10:05", "auto_repair_shop.title": "Alexander Automotive", "auto_repair_shop.streetaddress": "7710 Highway 431 North", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 6.0 mi from Boaz", "auto_repair_shop.phone": "(800) 422-8721", "auto_repair_shop.latitude": "34.2790695", "auto_repair_shop.longitude": "-86.2128186", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "4": { "city_x_auto_repair_shop.id": 4, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 4, "auto_repair_shop.ts": "2017-11-20 21:10:16", "auto_repair_shop.title": "J & M Mechanics", "auto_repair_shop.streetaddress": "9023 Us Hwy 431 N", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 7.1 mi from Boaz", "auto_repair_shop.phone": "(256) 891-0010", "auto_repair_shop.latitude": "34.2861845", "auto_repair_shop.longitude": "-86.2337017", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "5": { "city_x_auto_repair_shop.id": 5, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 5, "auto_repair_shop.ts": "2017-11-20 21:10:20", "auto_repair_shop.title": "Howard Bentley Buick GMC", "auto_repair_shop.streetaddress": "4321 US Highway 431", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 2.9 mi from Boaz", "auto_repair_shop.phone": "(256) 878-1050", "auto_repair_shop.latitude": "34.242371", "auto_repair_shop.longitude": "-86.172713", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "6": { "city_x_auto_repair_shop.id": 6, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 6, "auto_repair_shop.ts": "2017-11-20 21:10:26", "auto_repair_shop.title": "Edico Inc", "auto_repair_shop.streetaddress": "Po Box 1335", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 6.4 mi from Boaz", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": "34.249752", "auto_repair_shop.longitude": "-86.261095", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "7": { "city_x_auto_repair_shop.id": 7, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 7, "auto_repair_shop.ts": "2017-11-20 21:11:13", "auto_repair_shop.title": "Economy Tire Inc", "auto_repair_shop.streetaddress": "4588 Us Highway 431", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 3.3 mi from Boaz", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": "34.247621", "auto_repair_shop.longitude": "-86.175831", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "8": { "city_x_auto_repair_shop.id": 8, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 8, "auto_repair_shop.ts": "2017-11-20 21:11:17", "auto_repair_shop.title": "Holcomb Collision LLC", "auto_repair_shop.streetaddress": "PO Box 2158", "auto_repair_shop.addresslocality": "Albertville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35950", "auto_repair_shop.distance_directions": "Auto repair 5.2 mi from Boaz", "auto_repair_shop.phone": "(256) 878-6600", "auto_repair_shop.latitude": "34.2675937", "auto_repair_shop.longitude": "-86.2088669", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "9": { "city_x_auto_repair_shop.id": 9, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 9, "auto_repair_shop.ts": "2017-11-20 21:11:24", "auto_repair_shop.title": "Tnt Garage", "auto_repair_shop.streetaddress": "711 Darnell St", "auto_repair_shop.addresslocality": "Boaz,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35957", "auto_repair_shop.distance_directions": "Auto repair in Boaz", "auto_repair_shop.phone": "(256) 593-2190", "auto_repair_shop.latitude": "34.2069938", "auto_repair_shop.longitude": "-86.1626331", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "10": { "city_x_auto_repair_shop.id": 10, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 10, "auto_repair_shop.ts": "2017-11-20 21:11:34", "auto_repair_shop.title": "Sand Mountain Transmission", "auto_repair_shop.streetaddress": "1261 Wills Rd", "auto_repair_shop.addresslocality": "Boaz,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35957", "auto_repair_shop.distance_directions": "Auto repair in Boaz", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": "34.211519", "auto_repair_shop.longitude": "-86.151939", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "11": { "city_x_auto_repair_shop.id": 11, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 11, "auto_repair_shop.ts": "2017-11-20 21:11:40", "auto_repair_shop.title": "Kilpatrick Chevrolet", "auto_repair_shop.streetaddress": "1134 Hwy 431", "auto_repair_shop.addresslocality": "Boaz,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35957", "auto_repair_shop.distance_directions": "Auto repair in Boaz", "auto_repair_shop.phone": "(256) 593-4253", "auto_repair_shop.latitude": "34.2027075", "auto_repair_shop.longitude": "-86.151871", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "12": { "city_x_auto_repair_shop.id": 12, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 12, "auto_repair_shop.ts": "2017-11-20 21:11:44", "auto_repair_shop.title": "Oil Change Specialists", "auto_repair_shop.streetaddress": "10724 Al Highway 168", "auto_repair_shop.addresslocality": "Boaz,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35957", "auto_repair_shop.distance_directions": "Auto repair in Boaz", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": "34.236981", "auto_repair_shop.longitude": "-86.119188", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "13": { "city_x_auto_repair_shop.id": 13, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 13, "auto_repair_shop.ts": "2017-11-20 21:11:48", "auto_repair_shop.title": "Abbie Auto Parts Inc", "auto_repair_shop.streetaddress": "1015 Us Highway 431", "auto_repair_shop.addresslocality": "Boaz,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35957", "auto_repair_shop.distance_directions": "Auto repair in Boaz", "auto_repair_shop.phone": "(205) 593-8741", "auto_repair_shop.latitude": "34.2010231", "auto_repair_shop.longitude": "-86.1514818", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "14": { "city_x_auto_repair_shop.id": 14, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 14, "auto_repair_shop.ts": "2017-11-20 21:11:54", "auto_repair_shop.title": "Williams Express Lube", "auto_repair_shop.streetaddress": "10909 AL Highway 168", "auto_repair_shop.addresslocality": "Boaz,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35957", "auto_repair_shop.distance_directions": "Auto repair in Boaz", "auto_repair_shop.phone": "(256) 593-1880", "auto_repair_shop.latitude": "34.1989096", "auto_repair_shop.longitude": "-86.151776", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "15": { "city_x_auto_repair_shop.id": 15, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 15, "auto_repair_shop.ts": "2017-11-20 21:12:02", "auto_repair_shop.title": "Hubbard Tire Muffler & Auto", "auto_repair_shop.streetaddress": "21784 Us 431", "auto_repair_shop.addresslocality": "Guntersville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35976", "auto_repair_shop.distance_directions": "Auto repair 12.6 mi from Boaz", "auto_repair_shop.phone": "(256) 582-2781", "auto_repair_shop.latitude": "34.3351889", "auto_repair_shop.longitude": "-86.3145315", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "16": { "city_x_auto_repair_shop.id": 16, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 16, "auto_repair_shop.ts": "2017-11-20 21:12:04", "auto_repair_shop.title": "Oliver Tire", "auto_repair_shop.streetaddress": "1340 Blount Ave", "auto_repair_shop.addresslocality": "Guntersville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35976", "auto_repair_shop.distance_directions": "Auto repair 12.7 mi from Boaz", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": "34.346565", "auto_repair_shop.longitude": "-86.301574", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "17": { "city_x_auto_repair_shop.id": 17, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 17, "auto_repair_shop.ts": "2017-11-20 21:12:09", "auto_repair_shop.title": "B's Express Lube", "auto_repair_shop.streetaddress": "1716 Blount Ave", "auto_repair_shop.addresslocality": "Guntersville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35976", "auto_repair_shop.distance_directions": "Auto repair 12.6 mi from Boaz", "auto_repair_shop.phone": "", "auto_repair_shop.latitude": "34.34144", "auto_repair_shop.longitude": "-86.30713", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "18": { "city_x_auto_repair_shop.id": 18, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 18, "auto_repair_shop.ts": "2017-11-20 21:12:11", "auto_repair_shop.title": "Bob Hembree Chevrolet", "auto_repair_shop.streetaddress": "11982 US Highway 431", "auto_repair_shop.addresslocality": "Guntersville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35976", "auto_repair_shop.distance_directions": "Auto repair 12.6 mi from Boaz", "auto_repair_shop.phone": "(256) 582-5603", "auto_repair_shop.latitude": "34.3360871", "auto_repair_shop.longitude": "-86.3142937", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "19": { "city_x_auto_repair_shop.id": 19, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 19, "auto_repair_shop.ts": "2017-11-20 21:12:14", "auto_repair_shop.title": "Valley Auto Electric Inc", "auto_repair_shop.streetaddress": "1904 Henry St", "auto_repair_shop.addresslocality": "Guntersville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35976", "auto_repair_shop.distance_directions": "Auto repair 13.0 mi from Boaz", "auto_repair_shop.phone": "(256) 582-5426", "auto_repair_shop.latitude": "34.3484892", "auto_repair_shop.longitude": "-86.3069532", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "20": { "city_x_auto_repair_shop.id": 20, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "auto_repair_shop.id": 20, "auto_repair_shop.ts": "2017-11-20 21:12:21", "auto_repair_shop.title": "Lake City Auto Repairs Inc", "auto_repair_shop.streetaddress": "1901 Henry Street", "auto_repair_shop.addresslocality": "Guntersville,", "auto_repair_shop.addressregion": "AL", "auto_repair_shop.postalcode": "35976", "auto_repair_shop.distance_directions": "Auto repair 13.0 mi from Boaz", "auto_repair_shop.phone": "(256) 582-8844", "auto_repair_shop.latitude": "34.348185", "auto_repair_shop.longitude": "-86.307269", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "21": { "city_x_auto_repair_shop.id": 21, "city.id": 1, "city.ts": "2017-11-19 21:33:21", "city.title": "Albertville", "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.164982", "auto_repair_shop.longitude": "-86.139465", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "22": { "city_x_auto_repair_shop.id": 22, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.3419562", "auto_repair_shop.longitude": "-86.9288707", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "23": { "city_x_auto_repair_shop.id": 23, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.4150886", "auto_repair_shop.longitude": "-86.9755444", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "24": { "city_x_auto_repair_shop.id": 24, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.405297", "auto_repair_shop.longitude": "-86.971474", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "25": { "city_x_auto_repair_shop.id": 25, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.363084", "auto_repair_shop.longitude": "-87.008807", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "26": { "city_x_auto_repair_shop.id": 26, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.342508", "auto_repair_shop.longitude": "-87.001808", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "27": { "city_x_auto_repair_shop.id": 27, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.346275", "auto_repair_shop.longitude": "-86.910129", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "28": { "city_x_auto_repair_shop.id": 28, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.4131969", "auto_repair_shop.longitude": "-86.971536", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "29": { "city_x_auto_repair_shop.id": 29, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.4425961", "auto_repair_shop.longitude": "-86.9316989", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" }, "30": { "city_x_auto_repair_shop.id": 30, "city.id": 2, "city.ts": "2017-11-19 21:33:21", "city.title": "Bessemer", "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.453131", "auto_repair_shop.longitude": "-87.011", "auto_repair_shop.description": "This shop is not yet RepairPal Certified -" } } } }