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": "Plumbers in US", "point": { "title": "By Table", "desc": "Each API function returns data from a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/plumbers_in_us/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/plumbers_in_us/by_table/city_x_plumber/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/plumbers_in_us/by_table/city_x_plumber/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.002150000000000000001387778780781445675529539585113525390625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 104839, "pages_total": 1049 }, "struct": { "stem": { "0": "city_x_plumber", "1": "city", "2": "state", "3": "plumber" }, "leaf": "city_x_plumber.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city_x_plumber.id": 1, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 1, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Dependable Plumbing", "plumber.phone": "(256) 505-0447", "plumber.address": "Guntersville,", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "2": { "city_x_plumber.id": 2, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 2, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "McCann Plumbing", "plumber.phone": "(256) 572-8193", "plumber.address": "Guntersville,", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "3": { "city_x_plumber.id": 3, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 3, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "McCann Plumbing", "plumber.phone": "(256) 891-8933", "plumber.address": "505 Deidra St", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "4": { "city_x_plumber.id": 4, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 4, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Dependable Plumbing", "plumber.phone": "(256) 505-0447", "plumber.address": "5501 Cedar Mill Dr", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "5": { "city_x_plumber.id": 5, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 5, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Sand Mountain Plumbing", "plumber.phone": "(256) 878-4355", "plumber.address": "Albertville,", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "6": { "city_x_plumber.id": 6, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 6, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Baker Plumbing & Gas", "plumber.phone": "(256) 302-3737", "plumber.address": "Guntersville,", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "7": { "city_x_plumber.id": 7, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 7, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Nailor Plumbing & Gas", "plumber.phone": "(256) 677-2457", "plumber.address": "Albertville,", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "8": { "city_x_plumber.id": 8, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 8, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Chris Yaughn Plumbing", "plumber.phone": "(334) 608-9407", "plumber.address": "Douglas,", "plumber.city": "Douglas", "plumber.state": "AL", "plumber.zip": 35964 }, "9": { "city_x_plumber.id": 9, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 9, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Nailor Plumbing & Gas", "plumber.phone": "(256) 677-2457", "plumber.address": "Guntersville,", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "10": { "city_x_plumber.id": 10, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 10, "plumber.ts": "2018-02-08 21:45:36", "plumber.title": "Afford US Plumbing", "plumber.phone": "(256) 477-3330", "plumber.address": "Albertville,", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17905": { "city_x_plumber.id": 17905, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17905, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Russell Rahn Plumbing", "plumber.phone": "(256) 515-1125", "plumber.address": "1440 Ervin Patterson Rd", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35951 }, "17906": { "city_x_plumber.id": 17906, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17906, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Clements & Son Plumbing", "plumber.phone": "(256) 891-0319", "plumber.address": "195 Beck Rd", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17907": { "city_x_plumber.id": 17907, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17907, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Sanders Plumbing & Gas", "plumber.phone": "(256) 506-2976", "plumber.address": "Guntersville,", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "17908": { "city_x_plumber.id": 17908, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17908, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Jason Pounds Electrical Plumbing & Trenching", "plumber.phone": "(256) 302-2537", "plumber.address": "Albertville,", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17909": { "city_x_plumber.id": 17909, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17909, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Roto Rooter Plumbing & Drain Services", "plumber.phone": "(256) 582-8284", "plumber.address": "1215 Blount Ave", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "17910": { "city_x_plumber.id": 17910, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17910, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Webb Plumbing & Septic Tank Service", "plumber.phone": "(256) 878-6989", "plumber.address": "1556 Brashers Chapel Rd", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35951 }, "17911": { "city_x_plumber.id": 17911, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17911, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Bodine R C Plumbing & Contracting Inc", "plumber.phone": "(256) 891-1745", "plumber.address": "211 Drive In Rd", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "17912": { "city_x_plumber.id": 17912, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17912, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Roto Rooter", "plumber.phone": "(256) 878-3122", "plumber.address": "800 Section Line Rd", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17913": { "city_x_plumber.id": 17913, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17913, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Roto Rooter", "plumber.phone": "(256) 437-2622", "plumber.address": "Guntersville,", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "17914": { "city_x_plumber.id": 17914, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17914, "plumber.ts": "2018-02-10 20:20:30", "plumber.title": "Roto Rooter", "plumber.phone": "(256) 582-8284", "plumber.address": "1215 Blount Ave", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "17915": { "city_x_plumber.id": 17915, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17915, "plumber.ts": "2018-02-10 20:20:35", "plumber.title": "Power Rooter", "plumber.phone": "(256) 506-7090", "plumber.address": "Albertville,", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17916": { "city_x_plumber.id": 17916, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17916, "plumber.ts": "2018-02-10 20:20:35", "plumber.title": "Wittichen Supply Company", "plumber.phone": "(256) 878-0381", "plumber.address": "501 Railroad Ave", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17917": { "city_x_plumber.id": 17917, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17917, "plumber.ts": "2018-02-10 20:20:35", "plumber.title": "Hometown Painting & Remodeling", "plumber.phone": "(256) 293-8142", "plumber.address": "Albertville,", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17918": { "city_x_plumber.id": 17918, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17918, "plumber.ts": "2018-02-10 20:20:35", "plumber.title": "Ross Graden Lumber Company", "plumber.phone": "(256) 582-3125", "plumber.address": "933 Blount Ave", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "17919": { "city_x_plumber.id": 17919, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17919, "plumber.ts": "2018-02-10 20:20:35", "plumber.title": "Ace Hardware", "plumber.phone": "(256) 878-2241", "plumber.address": "7008 US Highway 431", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17920": { "city_x_plumber.id": 17920, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17920, "plumber.ts": "2018-02-10 20:20:35", "plumber.title": "Ace Hardware", "plumber.phone": "(256) 878-2241", "plumber.address": "7345 US Highway 431", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17921": { "city_x_plumber.id": 17921, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17921, "plumber.ts": "2018-02-10 20:22:24", "plumber.title": "Ace Hardware", "plumber.phone": "(256) 582-3353", "plumber.address": "1536 Blount Ave", "plumber.city": "Guntersville", "plumber.state": "AL", "plumber.zip": 35976 }, "17922": { "city_x_plumber.id": 17922, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17922, "plumber.ts": "2018-02-10 20:22:24", "plumber.title": "Ace Hardware", "plumber.phone": "(256) 878-2241", "plumber.address": "7004 US Highway 431", "plumber.city": "Albertville", "plumber.state": "AL", "plumber.zip": 35950 }, "17923": { "city_x_plumber.id": 17923, "city.id": 1, "city.ts": "2018-02-10 20:22:32", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17923, "plumber.ts": "2018-02-10 20:22:24", "plumber.title": "Ace Hardware", "plumber.phone": "(256) 593-4218", "plumber.address": "10055 Al Highway 168", "plumber.city": "Boaz", "plumber.state": "AL", "plumber.zip": 35957 }, "11": { "city_x_plumber.id": 11, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 11, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Neighbors Plumbing", "plumber.phone": "(256) 329-0234", "plumber.address": "Kellyton,", "plumber.city": "Kellyton", "plumber.state": "AL", "plumber.zip": 35089 }, "12": { "city_x_plumber.id": 12, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 12, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Pipemasters Plumbing", "plumber.phone": "(256) 750-1918", "plumber.address": "Alexander City,", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "13": { "city_x_plumber.id": 13, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 13, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Williams Plumbing Heating & Air", "plumber.phone": "(256) 329-8488", "plumber.address": "PO Box 103", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35011 }, "14": { "city_x_plumber.id": 14, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 14, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Plumbing By Ryan", "plumber.phone": "(256) 794-2227", "plumber.address": "Alexander City,", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "15": { "city_x_plumber.id": 15, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 15, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Regal Plumbing LLC", "plumber.phone": "(256) 825-2139", "plumber.address": "160 Warrior Ln", "plumber.city": "Dadeville", "plumber.state": "AL", "plumber.zip": 36853 }, "16": { "city_x_plumber.id": 16, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 16, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Williams Plumbing Heating And AC", "plumber.phone": "(256) 329-8488", "plumber.address": "103 PO Box", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35011 }, "17": { "city_x_plumber.id": 17, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Roto Rooter Plumbing & Drain Services", "plumber.phone": "(256) 234-7711", "plumber.address": "Alexander City,", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "18": { "city_x_plumber.id": 18, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 18, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "R & R Plumbing Services LLC", "plumber.phone": "(256) 794-7467", "plumber.address": "Alexander City,", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "19": { "city_x_plumber.id": 19, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 19, "plumber.ts": "2018-02-08 21:45:40", "plumber.title": "Arctic Air And Heat", "plumber.phone": "(256) 794-4341", "plumber.address": "87 Milam Rd", "plumber.city": "Jacksons Gap", "plumber.state": "AL", "plumber.zip": 36861 }, "17933": { "city_x_plumber.id": 17933, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17933, "plumber.ts": "2018-02-10 20:22:36", "plumber.title": "Roto Rooter", "plumber.phone": "(256) 234-7711", "plumber.address": "Alexander City,", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "17934": { "city_x_plumber.id": 17934, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17934, "plumber.ts": "2018-02-10 20:22:36", "plumber.title": "Bb&T", "plumber.phone": "(256) 215-5379", "plumber.address": "2055 Cherokee Rd", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "17935": { "city_x_plumber.id": 17935, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17935, "plumber.ts": "2018-02-10 20:22:36", "plumber.title": "Harold Dean's Appliance & Repair", "plumber.phone": "(256) 596-0381", "plumber.address": "Alexander City,", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "17936": { "city_x_plumber.id": 17936, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17936, "plumber.ts": "2018-02-10 20:22:36", "plumber.title": "Southern Pipe & Supply Co", "plumber.phone": "(256) 234-4236", "plumber.address": "2590 Dadeville Rd", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "17937": { "city_x_plumber.id": 17937, "city.id": 2, "city.ts": "2018-02-10 20:22:37", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17937, "plumber.ts": "2018-02-10 20:22:36", "plumber.title": "Lake Martin Building Supply", "plumber.phone": "(256) 234-5500", "plumber.address": "2695 Dadeville Rd", "plumber.city": "Alexander City", "plumber.state": "AL", "plumber.zip": 35010 }, "20": { "city_x_plumber.id": 20, "city.id": 3, "city.ts": "2018-02-10 20:22:39", "city.title": "Aliceville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 20, "plumber.ts": "2018-02-08 21:45:41", "plumber.title": "J & R Service Co", "plumber.phone": "(205) 375-2672", "plumber.address": "266 Shady Grove Rd", "plumber.city": "Reform", "plumber.state": "AL", "plumber.zip": 35481 }, "21": { "city_x_plumber.id": 21, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 21, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Affordable Plumbing", "plumber.phone": "(334) 222-9731", "plumber.address": "1012 Stanley Ave", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420 }, "22": { "city_x_plumber.id": 22, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 22, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Holcomb Plumbing & Electric", "plumber.phone": "(334) 222-4020", "plumber.address": "21187 Rosin Ridge Rd", "plumber.city": "Red Level", "plumber.state": "AL", "plumber.zip": 36474 }, "23": { "city_x_plumber.id": 23, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 23, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Bailey Plumbing And Electric", "plumber.phone": "(334) 493-4323", "plumber.address": "30248 Cool Springs Rd", "plumber.city": "Opp", "plumber.state": "AL", "plumber.zip": 36467 }, "24": { "city_x_plumber.id": 24, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 24, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Mullen Larry Plumbing Service", "plumber.phone": "(334) 222-1993", "plumber.address": "18360 Solmar Loop", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420 }, "25": { "city_x_plumber.id": 25, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 25, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "C & I Plumbing & Electrical Co", "plumber.phone": "(334) 222-6331", "plumber.address": "102 Forest Ave", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420 }, "26": { "city_x_plumber.id": 26, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 26, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Wilson Johnny Plumbing & Electric Contractor", "plumber.phone": "(334) 493-6020", "plumber.address": "127 W Covington Ave", "plumber.city": "Opp", "plumber.state": "AL", "plumber.zip": 36467 }, "27": { "city_x_plumber.id": 27, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 27, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "C & I Plumbing & Electrical Co", "plumber.phone": "(334) 222-6331", "plumber.address": "Andalusia,", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420 }, "28": { "city_x_plumber.id": 28, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 28, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "B & P Photography", "plumber.phone": "(334) 222-9731", "plumber.address": "1012 Stanley Ave", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420 }, "29": { "city_x_plumber.id": 29, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 29, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "24 7 Plumber Wellington's Best", "plumber.phone": "(256) 978-4328", "plumber.address": "Wellington,", "plumber.city": "Wellington", "plumber.state": "AL", "plumber.zip": 36279 }, "30": { "city_x_plumber.id": 30, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 30, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Howell Plumbing", "plumber.phone": "(256) 831-2345", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "31": { "city_x_plumber.id": 31, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 31, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Preston's Plumbing", "plumber.phone": "(256) 454-5962", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201 }, "32": { "city_x_plumber.id": 32, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 32, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Burks Plumbing", "plumber.phone": "(256) 499-0276", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36205 }, "33": { "city_x_plumber.id": 33, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 33, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Ted's Plumbing", "plumber.phone": "(256) 236-6737", "plumber.address": "500 Noble St", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201 }, "34": { "city_x_plumber.id": 34, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 34, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Jeff's Plumbing", "plumber.phone": "(256) 310-2005", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "35": { "city_x_plumber.id": 35, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 35, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "American Plumbing", "plumber.phone": "(256) 831-4122", "plumber.address": "401 Hamric Dr W", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "36": { "city_x_plumber.id": 36, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 36, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Ward Plumbing", "plumber.phone": "(256) 237-0946", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201 }, "37": { "city_x_plumber.id": 37, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 37, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Ward Plumbing", "plumber.phone": "(256) 237-0946", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36205 }, "38": { "city_x_plumber.id": 38, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 38, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Preferred Plumbing", "plumber.phone": "(256) 343-4643", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36205 }, "17957": { "city_x_plumber.id": 17957, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17957, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Reliable Plumbing", "plumber.phone": "(256) 447-7949", "plumber.address": "206 Memorial Dr", "plumber.city": "Piedmont", "plumber.state": "AL", "plumber.zip": 36272 }, "17958": { "city_x_plumber.id": 17958, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17958, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Wilson Plumbing", "plumber.phone": "(256) 820-4750", "plumber.address": "520 W 52nd St", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36206 }, "17959": { "city_x_plumber.id": 17959, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17959, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "AAA Plumbing", "plumber.phone": "(256) 236-0066", "plumber.address": "4519 Oakwood Dr", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36206 }, "17960": { "city_x_plumber.id": 17960, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17960, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Barrett Plumbing", "plumber.phone": "(256) 238-1941", "plumber.address": "4619 Sprague Ave", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36206 }, "17961": { "city_x_plumber.id": 17961, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17961, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Crim's Plumbing", "plumber.phone": "(256) 832-5125", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17962": { "city_x_plumber.id": 17962, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17962, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Jason's Plumbing", "plumber.phone": "(256) 591-8508", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36205 }, "17963": { "city_x_plumber.id": 17963, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17963, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Anthony Dulaney Plumbing LLC", "plumber.phone": "(256) 835-7191", "plumber.address": "600 Mudd St", "plumber.city": "Eastaboga", "plumber.state": "AL", "plumber.zip": 36260 }, "17964": { "city_x_plumber.id": 17964, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17964, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "C Mac Plumbing", "plumber.phone": "(256) 236-9371", "plumber.address": "4518 Charles Ave", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36206 }, "17965": { "city_x_plumber.id": 17965, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17965, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Anthony Dulaney Plumbing", "plumber.phone": "(256) 835-7191", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201 }, "17966": { "city_x_plumber.id": 17966, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17966, "plumber.ts": "2018-02-10 20:24:26", "plumber.title": "Welch Plumbing Inc", "plumber.phone": "(256) 310-4834", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17967": { "city_x_plumber.id": 17967, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17967, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Pointer Plumbing Co", "plumber.phone": "(256) 831-9233", "plumber.address": "15 Kue Pass", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17968": { "city_x_plumber.id": 17968, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17968, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Alabama Plumbing And Drain", "plumber.phone": "(256) 236-4455", "plumber.address": "154 Deer Ridge Rd", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36207 }, "17969": { "city_x_plumber.id": 17969, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17969, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "John Hearn Plumbing", "plumber.phone": "(256) 239-2733", "plumber.address": "4692 US Highway 78 E", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36207 }, "17970": { "city_x_plumber.id": 17970, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17970, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Raughton's Septic & Plumbing", "plumber.phone": "(256) 831-0102", "plumber.address": "5958 US Highway 78 W", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17971": { "city_x_plumber.id": 17971, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17971, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Raughton's Septic & Plumbing", "plumber.phone": "(256) 310-0935", "plumber.address": "1077 Iron City Rd", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36207 }, "17972": { "city_x_plumber.id": 17972, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17972, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Pioneer Plumbing Co", "plumber.phone": "(256) 237-5870", "plumber.address": "1006 Crestview Dr", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36206 }, "17973": { "city_x_plumber.id": 17973, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17973, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Ralph Raughton's Septic & Plumbing", "plumber.phone": "(256) 310-0935", "plumber.address": "1077 Iron City Rd", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36207 }, "17974": { "city_x_plumber.id": 17974, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17974, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Model City Plumbing & Mechanical", "plumber.phone": "(256) 236-2972", "plumber.address": "3017 Alexandria Rd", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201 }, "17975": { "city_x_plumber.id": 17975, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17975, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "American Plumbing & Septic Service", "plumber.phone": "(256) 447-4847", "plumber.address": "Piedmont,", "plumber.city": "Piedmont", "plumber.state": "AL", "plumber.zip": 36272 }, "17976": { "city_x_plumber.id": 17976, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17976, "plumber.ts": "2018-02-10 20:25:42", "plumber.title": "Jeff's Plumbing Service", "plumber.phone": "(256) 435-4178", "plumber.address": "615 Mark Green Rd", "plumber.city": "Jacksonville", "plumber.state": "AL", "plumber.zip": 36265 }, "17977": { "city_x_plumber.id": 17977, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17977, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "A American Plumbing & Septic", "plumber.phone": "(256) 238-8800", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201 }, "17978": { "city_x_plumber.id": 17978, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17978, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Dewberry Plumbing Inc", "plumber.phone": "(256) 831-3207", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17979": { "city_x_plumber.id": 17979, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17979, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Raughton's Septic & Plumbing", "plumber.phone": "(256) 831-0102", "plumber.address": "5997 US Highway 78 W", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17980": { "city_x_plumber.id": 17980, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17980, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Dulaney Anthony Plumbing", "plumber.phone": "(256) 835-7191", "plumber.address": "PO Box 468", "plumber.city": "Eastaboga", "plumber.state": "AL", "plumber.zip": 36260 }, "17981": { "city_x_plumber.id": 17981, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17981, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Raughton's Septic & Plumbing", "plumber.phone": "(256) 310-0935", "plumber.address": "5858 US Highway 78 W", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17982": { "city_x_plumber.id": 17982, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17982, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Perez Plumbing & Gas", "plumber.phone": "(256) 835-0404", "plumber.address": "331 Noah Ln", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17983": { "city_x_plumber.id": 17983, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17983, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Larry Turner Plumbing", "plumber.phone": "(256) 310-5729", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17984": { "city_x_plumber.id": 17984, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17984, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Smith Plumbing & Storage", "plumber.phone": "(256) 447-9200", "plumber.address": "22766 Al Highway 9 N", "plumber.city": "Piedmont", "plumber.state": "AL", "plumber.zip": 36272 }, "17985": { "city_x_plumber.id": 17985, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17985, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Mr Dan's Plumbing", "plumber.phone": "(256) 435-1515", "plumber.address": "Jacksonville,", "plumber.city": "Jacksonville", "plumber.state": "AL", "plumber.zip": 36265 }, "17986": { "city_x_plumber.id": 17986, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17986, "plumber.ts": "2018-02-10 20:25:43", "plumber.title": "Pointer Plumbing Co", "plumber.phone": "(256) 831-9233", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17987": { "city_x_plumber.id": 17987, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17987, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "American Plumbing & Septic Service", "plumber.phone": "(256) 835-1810", "plumber.address": "401 Hamric Dr W", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17988": { "city_x_plumber.id": 17988, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17988, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "Roto Rooter Plumbing & Drain Services", "plumber.phone": "(256) 283-1722", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17989": { "city_x_plumber.id": 17989, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17989, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "Roger's Plumbing Electrical & Gas Service", "plumber.phone": "(256) 435-7753", "plumber.address": "Jacksonville,", "plumber.city": "Jacksonville", "plumber.state": "AL", "plumber.zip": 36265 }, "17990": { "city_x_plumber.id": 17990, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17990, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "Roto Rooter Plumbing & Drain Services", "plumber.phone": "(256) 831-7220", "plumber.address": "52872 US Highway 78", "plumber.city": "Eastaboga", "plumber.state": "AL", "plumber.zip": 36260 }, "17991": { "city_x_plumber.id": 17991, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17991, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "A American Drain Cleaning & Plumbing Services", "plumber.phone": "(256) 835-1810", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201 }, "17992": { "city_x_plumber.id": 17992, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17992, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "Preston's Plumbing And Drain Cleaning Service", "plumber.phone": "(256) 419-5500", "plumber.address": "10474 Choccolocco Rd", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36207 }, "17993": { "city_x_plumber.id": 17993, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17993, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "A American Drain Cleaning & Plumbing Services", "plumber.phone": "(256) 238-8800", "plumber.address": "401 Hamric Dr W", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 }, "17994": { "city_x_plumber.id": 17994, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama", "plumber.id": 17994, "plumber.ts": "2018-02-10 20:25:46", "plumber.title": "Onsite Solutions LLC", "plumber.phone": "(256) 310-2801", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203 } } } }