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": "Roofing Contractors 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/roofing_contractors_in_us/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city_x_roofing_contractor/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city_x_roofing_contractor/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.0035799999999999998490096686509787105023860931396484375 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 69406, "pages_total": 695 }, "struct": { "stem": { "0": "city_x_roofing_contractor", "1": "city", "2": "state", "3": "roofing_contractor" }, "leaf": "city_x_roofing_contractor.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city_x_roofing_contractor.id": 1, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 1, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Lees Roofing", "roofing_contractor.address": "Guntersville,", "roofing_contractor.city": "Guntersville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35976, "roofing_contractor.phone": "(256) 960-0062" }, "2": { "city_x_roofing_contractor.id": 2, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 2, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Blake's Roofing", "roofing_contractor.address": "Guntersville,", "roofing_contractor.city": "Guntersville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35976, "roofing_contractor.phone": "(256) 202-2555" }, "3": { "city_x_roofing_contractor.id": 3, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 3, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Lee's Roofing", "roofing_contractor.address": "Albertville,", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 677-4436" }, "4": { "city_x_roofing_contractor.id": 4, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 4, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Whitmore's Roofing", "roofing_contractor.address": "630 Oakes Rd", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35956, "roofing_contractor.phone": "(256) 558-2239" }, "5": { "city_x_roofing_contractor.id": 5, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 5, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Tedder Roofing & Repairs", "roofing_contractor.address": "515 County Highway 25", "roofing_contractor.city": "Guntersville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35976, "roofing_contractor.phone": "(256) 586-6378" }, "6": { "city_x_roofing_contractor.id": 6, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 6, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Hunnie Due Roofing", "roofing_contractor.address": "Albertville,", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 302-3917" }, "7": { "city_x_roofing_contractor.id": 7, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 7, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Fuller Roofing & Gutters", "roofing_contractor.address": "421 Tidwell Rd", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35956, "roofing_contractor.phone": "(256) 593-6040" }, "8": { "city_x_roofing_contractor.id": 8, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 8, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "P & R Roofing", "roofing_contractor.address": "112 Sand Mountain Dr NW", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 582-3754" }, "9": { "city_x_roofing_contractor.id": 9, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 9, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "Town & Country Roofing", "roofing_contractor.address": "73 Frazier Rd", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 878-1155" }, "10": { "city_x_roofing_contractor.id": 10, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 10, "roofing_contractor.ts": "2018-02-22 01:34:55", "roofing_contractor.title": "T & T Roofing", "roofing_contractor.address": "Guntersville,", "roofing_contractor.city": "Guntersville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35976, "roofing_contractor.phone": "(256) 505-9783" }, "15308": { "city_x_roofing_contractor.id": 15308, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15308, "roofing_contractor.ts": "2018-02-22 20:11:10", "roofing_contractor.title": "Jc Metal Roofing", "roofing_contractor.address": "Boaz,", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35957, "roofing_contractor.phone": "(256) 251-5497" }, "15309": { "city_x_roofing_contractor.id": 15309, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15309, "roofing_contractor.ts": "2018-02-22 20:11:10", "roofing_contractor.title": "Fuller Roofing LLC", "roofing_contractor.address": "421 Tidwell Rd", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35956, "roofing_contractor.phone": "(256) 593-6040" }, "15310": { "city_x_roofing_contractor.id": 15310, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15310, "roofing_contractor.ts": "2018-02-22 20:11:10", "roofing_contractor.title": "Kb Metal Roofing & Remodeling", "roofing_contractor.address": "Albertville,", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 744-4095" }, "15311": { "city_x_roofing_contractor.id": 15311, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15311, "roofing_contractor.ts": "2018-02-22 20:11:10", "roofing_contractor.title": "C R Roofing", "roofing_contractor.address": "921 Dooley Ave", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35951, "roofing_contractor.phone": "(256) 878-5101" }, "15312": { "city_x_roofing_contractor.id": 15312, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15312, "roofing_contractor.ts": "2018-02-22 20:11:10", "roofing_contractor.title": "Elite Roofing & Repair", "roofing_contractor.address": "Albertville,", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 558-5067" }, "15313": { "city_x_roofing_contractor.id": 15313, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15313, "roofing_contractor.ts": "2018-02-22 20:11:10", "roofing_contractor.title": "Echols Metal Roofing", "roofing_contractor.address": "65 Paragon St", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 840-0080" }, "15314": { "city_x_roofing_contractor.id": 15314, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15314, "roofing_contractor.ts": "2018-02-22 20:11:10", "roofing_contractor.title": "McCoy Construction", "roofing_contractor.address": "Guntersville,", "roofing_contractor.city": "Guntersville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35976, "roofing_contractor.phone": "(256) 486-8058" }, "15315": { "city_x_roofing_contractor.id": 15315, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15315, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Chamble Construction LLC", "roofing_contractor.address": "Boaz,", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35957, "roofing_contractor.phone": "(256) 302-1582" }, "15316": { "city_x_roofing_contractor.id": 15316, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15316, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Fine Tune Your Home", "roofing_contractor.address": "Albertville,", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 572-4518" }, "15317": { "city_x_roofing_contractor.id": 15317, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15317, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Tony Griffin Construction Inc", "roofing_contractor.address": "Boaz,", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35957, "roofing_contractor.phone": "(256) 251-5474" }, "15318": { "city_x_roofing_contractor.id": 15318, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15318, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "A Jennings Co", "roofing_contractor.address": "2485 County Highway 21", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35957, "roofing_contractor.phone": "(256) 505-1276" }, "15319": { "city_x_roofing_contractor.id": 15319, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15319, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Johnson Builders", "roofing_contractor.address": "5 Thrasher Dr", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35956, "roofing_contractor.phone": "(256) 593-9345" }, "15320": { "city_x_roofing_contractor.id": 15320, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15320, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "K & G Metals", "roofing_contractor.address": "8894 US Highway 431", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 878-7227" }, "15321": { "city_x_roofing_contractor.id": 15321, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15321, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Asap Fence", "roofing_contractor.address": "397 Robin Rd", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 302-0099" }, "15322": { "city_x_roofing_contractor.id": 15322, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15322, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Southland Home Builders", "roofing_contractor.address": "Guntersville,", "roofing_contractor.city": "Guntersville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35976, "roofing_contractor.phone": "(256) 486-4236" }, "15323": { "city_x_roofing_contractor.id": 15323, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15323, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Homepro Construction LLC", "roofing_contractor.address": "Albertville,", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 279-5923" }, "15324": { "city_x_roofing_contractor.id": 15324, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15324, "roofing_contractor.ts": "2018-02-22 20:11:13", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "7008 US Highway 431", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 878-2241" }, "15325": { "city_x_roofing_contractor.id": 15325, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15325, "roofing_contractor.ts": "2018-02-22 20:11:18", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "7345 US Highway 431", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 878-2241" }, "15326": { "city_x_roofing_contractor.id": 15326, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15326, "roofing_contractor.ts": "2018-02-22 20:11:18", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "1536 Blount Ave", "roofing_contractor.city": "Guntersville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35976, "roofing_contractor.phone": "(256) 582-3353" }, "15327": { "city_x_roofing_contractor.id": 15327, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15327, "roofing_contractor.ts": "2018-02-22 20:11:18", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "7004 US Highway 431", "roofing_contractor.city": "Albertville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35950, "roofing_contractor.phone": "(256) 878-2241" }, "15328": { "city_x_roofing_contractor.id": 15328, "city.id": 1, "city.ts": "2018-02-22 20:11:23", "city.title": "Albertville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15328, "roofing_contractor.ts": "2018-02-22 20:11:18", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "10055 Al Highway 168", "roofing_contractor.city": "Boaz", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35957, "roofing_contractor.phone": "(256) 593-4218" }, "11": { "city_x_roofing_contractor.id": 11, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 11, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Mason Roofing", "roofing_contractor.address": "Dogwood Ave", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 234-6874" }, "12": { "city_x_roofing_contractor.id": 12, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 12, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Mason Roofing", "roofing_contractor.address": "Jacksons Gap,", "roofing_contractor.city": "Jacksons Gap", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36861, "roofing_contractor.phone": "(256) 749-1745" }, "13": { "city_x_roofing_contractor.id": 13, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 13, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Mason Roofing", "roofing_contractor.address": "Alexander City,", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 749-1745" }, "14": { "city_x_roofing_contractor.id": 14, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 14, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Alex City Roofing & Construction", "roofing_contractor.address": "33 Emerald Dr", "roofing_contractor.city": "Jacksons Gap", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36861, "roofing_contractor.phone": "(256) 825-8761" }, "15": { "city_x_roofing_contractor.id": 15, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Old Southern Roofing Co", "roofing_contractor.address": "Dadeville,", "roofing_contractor.city": "Dadeville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36853, "roofing_contractor.phone": "(256) 825-6676" }, "16": { "city_x_roofing_contractor.id": 16, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 16, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Capitol City Roofing", "roofing_contractor.address": "Alexander City,", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 234-0209" }, "17": { "city_x_roofing_contractor.id": 17, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 17, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Old Southern Roofing Co", "roofing_contractor.address": "Alexander City,", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 234-5007" }, "18": { "city_x_roofing_contractor.id": 18, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 18, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Old Southern Roofing Co", "roofing_contractor.address": "33 Emerald Dr", "roofing_contractor.city": "Jacksons Gap", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36861, "roofing_contractor.phone": "(256) 825-8761" }, "19": { "city_x_roofing_contractor.id": 19, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 19, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Alex City Metal Roofing Specialist", "roofing_contractor.address": "Alexander City,", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 794-7566" }, "20": { "city_x_roofing_contractor.id": 20, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 20, "roofing_contractor.ts": "2018-02-22 01:35:01", "roofing_contractor.title": "Wheeles Seamless Gutters And Roofing", "roofing_contractor.address": "Alexander City,", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 596-1821" }, "15339": { "city_x_roofing_contractor.id": 15339, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15339, "roofing_contractor.ts": "2018-02-22 20:11:27", "roofing_contractor.title": "Heart Of Dixie Roofing Co", "roofing_contractor.address": "Alexander City,", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 496-5216" }, "15340": { "city_x_roofing_contractor.id": 15340, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15340, "roofing_contractor.ts": "2018-02-22 20:11:27", "roofing_contractor.title": "A & E Metal Roofing Supply LLC", "roofing_contractor.address": "239 McClellan Industrial Dr", "roofing_contractor.city": "Kellyton", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35089, "roofing_contractor.phone": "(256) 329-0034" }, "15341": { "city_x_roofing_contractor.id": 15341, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15341, "roofing_contractor.ts": "2018-02-22 20:11:27", "roofing_contractor.title": "D & G Construction Co", "roofing_contractor.address": "52 Locklear Dr", "roofing_contractor.city": "Jacksons Gap", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36861, "roofing_contractor.phone": "(256) 749-7483" }, "15342": { "city_x_roofing_contractor.id": 15342, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15342, "roofing_contractor.ts": "2018-02-22 20:11:27", "roofing_contractor.title": "Ideal Exteriors Inc", "roofing_contractor.address": "5610 Highway 49 S", "roofing_contractor.city": "Dadeville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36853, "roofing_contractor.phone": "(256) 307-1169" }, "15343": { "city_x_roofing_contractor.id": 15343, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15343, "roofing_contractor.ts": "2018-02-22 20:11:27", "roofing_contractor.title": "Dean Construction", "roofing_contractor.address": "47 Linda Place Ext", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 234-4614" }, "15344": { "city_x_roofing_contractor.id": 15344, "city.id": 2, "city.ts": "2018-02-22 20:11:32", "city.title": "Alexander City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15344, "roofing_contractor.ts": "2018-02-22 20:11:27", "roofing_contractor.title": "Goodson Construction", "roofing_contractor.address": "Alexander City,", "roofing_contractor.city": "Alexander City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35010, "roofing_contractor.phone": "(256) 825-7467" }, "21": { "city_x_roofing_contractor.id": 21, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 21, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Scott Cook Roofing", "roofing_contractor.address": "807 PO Box", "roofing_contractor.city": "Opp", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36467, "roofing_contractor.phone": "(334) 493-3926" }, "22": { "city_x_roofing_contractor.id": 22, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 22, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Scott Cook Roofing", "roofing_contractor.address": "308 14th St", "roofing_contractor.city": "Opp", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36467, "roofing_contractor.phone": "(334) 493-3926" }, "23": { "city_x_roofing_contractor.id": 23, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 23, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Scott Cook Roofing", "roofing_contractor.address": "307 14th St", "roofing_contractor.city": "Opp", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36467, "roofing_contractor.phone": "(334) 493-3926" }, "24": { "city_x_roofing_contractor.id": 24, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 24, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Allcoast Roofing & Construction", "roofing_contractor.address": "33 Owens Rd", "roofing_contractor.city": "Brantley", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36009, "roofing_contractor.phone": "(334) 343-7980" }, "25": { "city_x_roofing_contractor.id": 25, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 25, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Hollinghead Roofing Karman", "roofing_contractor.address": "157 RR 3 Box", "roofing_contractor.city": "Opp", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36467, "roofing_contractor.phone": "(334) 493-6449" }, "26": { "city_x_roofing_contractor.id": 26, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 26, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Kenneth Bedsole Roofing", "roofing_contractor.address": "17172 Oak Tree Ln", "roofing_contractor.city": "Andalusia", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36421, "roofing_contractor.phone": "(334) 428-2227" }, "27": { "city_x_roofing_contractor.id": 27, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 27, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Simmons Roofing Company", "roofing_contractor.address": "17470 Cane Juice Ln", "roofing_contractor.city": "Andalusia", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36420, "roofing_contractor.phone": "(334) 222-5379" }, "28": { "city_x_roofing_contractor.id": 28, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 28, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "Foreman Roofing & Renovation Co Inc", "roofing_contractor.address": "111 Liberty Rd", "roofing_contractor.city": "Brantley", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36009, "roofing_contractor.phone": "(334) 496-3948" }, "29": { "city_x_roofing_contractor.id": 29, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 29, "roofing_contractor.ts": "2018-02-22 01:35:06", "roofing_contractor.title": "C & C Vinyl And Roofing", "roofing_contractor.address": "35516 Boston Rd", "roofing_contractor.city": "Dozier", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36028, "roofing_contractor.phone": "(334) 496-3372" }, "15354": { "city_x_roofing_contractor.id": 15354, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15354, "roofing_contractor.ts": "2018-02-22 20:11:42", "roofing_contractor.title": "Kirklands All Out Construction", "roofing_contractor.address": "310 Andalusia Estate Dr", "roofing_contractor.city": "Andalusia", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36420, "roofing_contractor.phone": "(334) 892-6262" }, "15355": { "city_x_roofing_contractor.id": 15355, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15355, "roofing_contractor.ts": "2018-02-22 20:11:42", "roofing_contractor.title": "Jones Construction", "roofing_contractor.address": "102 David St", "roofing_contractor.city": "Andalusia", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36421, "roofing_contractor.phone": "(334) 764-3794" }, "15356": { "city_x_roofing_contractor.id": 15356, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15356, "roofing_contractor.ts": "2018-02-22 20:11:42", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "704 Old Perry Store Rd", "roofing_contractor.city": "Opp", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36467, "roofing_contractor.phone": "(334) 493-3514" }, "15357": { "city_x_roofing_contractor.id": 15357, "city.id": 4, "city.ts": "2018-02-22 20:11:46", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15357, "roofing_contractor.ts": "2018-02-22 20:11:42", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "541 W Bypass", "roofing_contractor.city": "Andalusia", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36420, "roofing_contractor.phone": "(334) 222-1106" }, "30": { "city_x_roofing_contractor.id": 30, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 30, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Andy The Roofer & Co Inc", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 835-7643" }, "31": { "city_x_roofing_contractor.id": 31, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 31, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Andy The Roofer & Co Inc", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 835-7643" }, "32": { "city_x_roofing_contractor.id": 32, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 32, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "D & G Roofing Contractors", "roofing_contractor.address": "PO Box 887", "roofing_contractor.city": "Ohatchee", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36271, "roofing_contractor.phone": "(256) 442-3426" }, "33": { "city_x_roofing_contractor.id": 33, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 33, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Affordable Roof Repair & Custom Built Decks", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 405-5733" }, "34": { "city_x_roofing_contractor.id": 34, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 34, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Post Roofing", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 689-7039" }, "35": { "city_x_roofing_contractor.id": 35, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 35, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Reynolds Roofing", "roofing_contractor.address": "2610 County Road 67", "roofing_contractor.city": "Piedmont", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36272, "roofing_contractor.phone": "(256) 557-3543" }, "36": { "city_x_roofing_contractor.id": 36, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 36, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Hollingsworth Roofing", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 689-0515" }, "37": { "city_x_roofing_contractor.id": 37, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 37, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Reliable Roofing", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 403-0087" }, "38": { "city_x_roofing_contractor.id": 38, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 38, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "USA Roofing", "roofing_contractor.address": "502 Tillman Ave", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 591-2877" }, "39": { "city_x_roofing_contractor.id": 39, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 39, "roofing_contractor.ts": "2018-02-22 01:35:12", "roofing_contractor.title": "Reliable Roofing", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 403-0087" }, "15368": { "city_x_roofing_contractor.id": 15368, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15368, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "Post Roofing", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 238-8638" }, "15369": { "city_x_roofing_contractor.id": 15369, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15369, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "USA Roofing", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 591-2877" }, "15370": { "city_x_roofing_contractor.id": 15370, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15370, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "Barnettes Affordable Roofing", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 831-0300" }, "15371": { "city_x_roofing_contractor.id": 15371, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15371, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "Southern Roofing And Siding", "roofing_contractor.address": "1325 Noble St", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 237-7663" }, "15372": { "city_x_roofing_contractor.id": 15372, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15372, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "Southern Roofing And Siding", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 237-7663" }, "15373": { "city_x_roofing_contractor.id": 15373, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15373, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "Curvin's Roofing & Siding", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 820-2797" }, "15374": { "city_x_roofing_contractor.id": 15374, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15374, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "Curvin's Roofing & Siding", "roofing_contractor.address": "461 School Cutoff", "roofing_contractor.city": "Jacksonville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36265, "roofing_contractor.phone": "(256) 435-2233" }, "15375": { "city_x_roofing_contractor.id": 15375, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15375, "roofing_contractor.ts": "2018-02-22 20:11:50", "roofing_contractor.title": "M & E Metal Roofing", "roofing_contractor.address": "4556 Hollingsworth Rd", "roofing_contractor.city": "Jacksonville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36265, "roofing_contractor.phone": "(256) 447-6441" }, "15376": { "city_x_roofing_contractor.id": 15376, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15376, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Clark Custom Roofing", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 310-0908" }, "15377": { "city_x_roofing_contractor.id": 15377, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15377, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Oxford Quality Roofing", "roofing_contractor.address": "903 Caffey Dr", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 835-7152" }, "15378": { "city_x_roofing_contractor.id": 15378, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15378, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Turner Roofing Co", "roofing_contractor.address": "3130 Alexandria Rd", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 237-6137" }, "15379": { "city_x_roofing_contractor.id": 15379, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15379, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Kyner Roofing Company", "roofing_contractor.address": "425 Blue Bird Dr", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36206, "roofing_contractor.phone": "(256) 435-2579" }, "15380": { "city_x_roofing_contractor.id": 15380, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15380, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Continental Roofing Company LLC", "roofing_contractor.address": "309 Quintard Ave Ste E", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 238-8102" }, "15381": { "city_x_roofing_contractor.id": 15381, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15381, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Mack Metal Roofing", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 310-7325" }, "15382": { "city_x_roofing_contractor.id": 15382, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15382, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Brown Roofing Company Inc", "roofing_contractor.address": "20 W 6th St", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 238-8859" }, "15383": { "city_x_roofing_contractor.id": 15383, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15383, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Advanced Roofing Solutions", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 403-1428" }, "15384": { "city_x_roofing_contractor.id": 15384, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15384, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Quality Roofing & Construction", "roofing_contractor.address": "212 Mountain Ave", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 375-8200" }, "15385": { "city_x_roofing_contractor.id": 15385, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15385, "roofing_contractor.ts": "2018-02-22 20:11:57", "roofing_contractor.title": "Reece Roofing Company", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 453-2057" }, "15386": { "city_x_roofing_contractor.id": 15386, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15386, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "Bar-B Roofing", "roofing_contractor.address": "508 Chestnut Ave", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 591-7777" }, "15387": { "city_x_roofing_contractor.id": 15387, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15387, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "Alabama Roofing & Sheet Metal Co", "roofing_contractor.address": "1700 Hillyer Robinson Industrial Pkwy", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36207, "roofing_contractor.phone": "(256) 831-9000" }, "15388": { "city_x_roofing_contractor.id": 15388, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15388, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "M & E Metal Roofing Specialist", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 835-1201" }, "15389": { "city_x_roofing_contractor.id": 15389, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15389, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "M & E Metal Roofing Specialist", "roofing_contractor.address": "639 Old Choccolocco Rd", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36207, "roofing_contractor.phone": "(256) 235-9417" }, "15390": { "city_x_roofing_contractor.id": 15390, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15390, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "M & E Metal Roofing Specialist", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 453-6064" }, "15391": { "city_x_roofing_contractor.id": 15391, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15391, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "M & E Metal Roofing Specialist", "roofing_contractor.address": "4556 Hollingsworth Rd", "roofing_contractor.city": "Jacksonville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36265, "roofing_contractor.phone": "(256) 591-0092" }, "15392": { "city_x_roofing_contractor.id": 15392, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15392, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "Better boys roofing and construction", "roofing_contractor.address": "708 Timber Way", "roofing_contractor.city": "Weaver", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36277, "roofing_contractor.phone": "(256) 452-2532" }, "15393": { "city_x_roofing_contractor.id": 15393, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15393, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "Bobby Boyd Construction", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 499-5715" }, "15394": { "city_x_roofing_contractor.id": 15394, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15394, "roofing_contractor.ts": "2018-02-22 20:12:02", "roofing_contractor.title": "Accurate Reliable Construction", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 310-0325" }, "15395": { "city_x_roofing_contractor.id": 15395, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15395, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Be Right There Repairs", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 225-3395" }, "15396": { "city_x_roofing_contractor.id": 15396, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15396, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Tim Brown", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 835-8984" }, "15397": { "city_x_roofing_contractor.id": 15397, "city.id": 5, "city.ts": "2018-02-22 20:12:16", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15397, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Lee's", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 294-0746" } } } }