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" }, "prev": { "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/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.002870000000000000155153667691365626524202525615692138671875 }, "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": { "15398": { "city_x_roofing_contractor.id": 15398, "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": 15398, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Jacksonville", "roofing_contractor.address": "200 Coffee St SW", "roofing_contractor.city": "Jacksonville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36265, "roofing_contractor.phone": "(256) 435-1966" }, "15399": { "city_x_roofing_contractor.id": 15399, "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": 15399, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Prince Perfection Construction", "roofing_contractor.address": "219 Snow St", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 525-6783" }, "15400": { "city_x_roofing_contractor.id": 15400, "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": 15400, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Prince Perfection Construction", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 525-9612" }, "15401": { "city_x_roofing_contractor.id": 15401, "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": 15401, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "AAA Rooging", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36201, "roofing_contractor.phone": "(256) 403-0094" }, "15402": { "city_x_roofing_contractor.id": 15402, "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": 15402, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Construction Solutions Inc", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 283-5221" }, "15403": { "city_x_roofing_contractor.id": 15403, "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": 15403, "roofing_contractor.ts": "2018-02-22 20:12:04", "roofing_contractor.title": "Echols Metal Supply", "roofing_contractor.address": "2276 Harts Ferry Rd", "roofing_contractor.city": "Ohatchee", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36271, "roofing_contractor.phone": "(256) 892-0081" }, "15404": { "city_x_roofing_contractor.id": 15404, "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": 15404, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "B & M Metals", "roofing_contractor.address": "11665 US Highway 278 E", "roofing_contractor.city": "Piedmont", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36272, "roofing_contractor.phone": "(256) 494-3090" }, "15405": { "city_x_roofing_contractor.id": 15405, "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": 15405, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "ABC Supply Co Inc", "roofing_contractor.address": "57 Depot USA Dr", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 831-0749" }, "15406": { "city_x_roofing_contractor.id": 15406, "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": 15406, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "Remodel USA Inc", "roofing_contractor.address": "629 Keith Ave", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36207, "roofing_contractor.phone": "(256) 312-7732" }, "15407": { "city_x_roofing_contractor.id": 15407, "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": 15407, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "Heathcock Construction Custom Built Homes", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 403-5564" }, "15408": { "city_x_roofing_contractor.id": 15408, "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": 15408, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "Heathcock Construction", "roofing_contractor.address": "Oxford,", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 310-3253" }, "15409": { "city_x_roofing_contractor.id": 15409, "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": 15409, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "Haro's Remodeling", "roofing_contractor.address": "Anniston,", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36205, "roofing_contractor.phone": "(256) 365-2920" }, "15410": { "city_x_roofing_contractor.id": 15410, "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": 15410, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "Morris Building Constructors Inc", "roofing_contractor.address": "1333 Butler St", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 835-1080" }, "15411": { "city_x_roofing_contractor.id": 15411, "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": 15411, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "Heathcock Construction", "roofing_contractor.address": "42 Kelleys Lake Rd", "roofing_contractor.city": "Wellington", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36279, "roofing_contractor.phone": "(256) 892-3523" }, "15412": { "city_x_roofing_contractor.id": 15412, "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": 15412, "roofing_contractor.ts": "2018-02-22 20:12:09", "roofing_contractor.title": "Bobby Boyd Construction", "roofing_contractor.address": "755 Bernard Couch Dr", "roofing_contractor.city": "Anniston", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36207, "roofing_contractor.phone": "(256) 403-0097" }, "15413": { "city_x_roofing_contractor.id": 15413, "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": 15413, "roofing_contractor.ts": "2018-02-22 20:12:15", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "1420 Pelham Rd S", "roofing_contractor.city": "Jacksonville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36265, "roofing_contractor.phone": "(256) 435-6383" }, "15414": { "city_x_roofing_contractor.id": 15414, "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": 15414, "roofing_contractor.ts": "2018-02-22 20:12:15", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "200 Coffee St SW", "roofing_contractor.city": "Jacksonville", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36265, "roofing_contractor.phone": "(256) 435-1966" }, "15415": { "city_x_roofing_contractor.id": 15415, "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": 15415, "roofing_contractor.ts": "2018-02-22 20:12:15", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "1400 Barry St", "roofing_contractor.city": "Oxford", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36203, "roofing_contractor.phone": "(256) 831-0540" }, "40": { "city_x_roofing_contractor.id": 40, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 40, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Roof Tech Solutions, LLC", "roofing_contractor.address": "11275 John Pugh Road", "roofing_contractor.city": "Tanner", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35671, "roofing_contractor.phone": "(256) 431-5002" }, "41": { "city_x_roofing_contractor.id": 41, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 41, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Gilbert Roofing", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 444-1297" }, "42": { "city_x_roofing_contractor.id": 42, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 42, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Lewis Roofing", "roofing_contractor.address": "Elkmont,", "roofing_contractor.city": "Elkmont", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35620, "roofing_contractor.phone": "(256) 431-2202" }, "43": { "city_x_roofing_contractor.id": 43, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 43, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Advanced Roofing", "roofing_contractor.address": "22277 Howard St", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35613, "roofing_contractor.phone": "(256) 734-7050" }, "44": { "city_x_roofing_contractor.id": 44, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 44, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Yellowhammer Roofing Inc", "roofing_contractor.address": "22923 US Highway 72 Ste D", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35613, "roofing_contractor.phone": "(256) 423-7537" }, "45": { "city_x_roofing_contractor.id": 45, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 45, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Ashby Roofing Company", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 777-0731" }, "46": { "city_x_roofing_contractor.id": 46, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 46, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Yellowhammer Roofing Inc", "roofing_contractor.address": "26476 5th St", "roofing_contractor.city": "Ardmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35739, "roofing_contractor.phone": "(256) 423-8141" }, "47": { "city_x_roofing_contractor.id": 47, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 47, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "R & S Roofing", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 777-6168" }, "48": { "city_x_roofing_contractor.id": 48, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 48, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Southern Roofing & Const", "roofing_contractor.address": "20635 Colonial Dr", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35614, "roofing_contractor.phone": "(256) 232-2555" }, "49": { "city_x_roofing_contractor.id": 49, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 49, "roofing_contractor.ts": "2018-02-22 01:35:17", "roofing_contractor.title": "Valley Roofing LLC", "roofing_contractor.address": "14970 US Highway 72", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 444-4253" }, "15426": { "city_x_roofing_contractor.id": 15426, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15426, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "Yellowhammer Roofing Inc", "roofing_contractor.address": "Ardmore,", "roofing_contractor.city": "Ardmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35739, "roofing_contractor.phone": "(256) 423-8479" }, "15427": { "city_x_roofing_contractor.id": 15427, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15427, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "Pressnell Roofing Co", "roofing_contractor.address": "22150 Piney Chapel Rd", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35614, "roofing_contractor.phone": "(256) 232-8844" }, "15428": { "city_x_roofing_contractor.id": 15428, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15428, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "Glenn Hall Roofing", "roofing_contractor.address": "14951 Blackburn Rd", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 232-2506" }, "15429": { "city_x_roofing_contractor.id": 15429, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15429, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "C & L Roofing", "roofing_contractor.address": "29595 Mooresville Rd", "roofing_contractor.city": "Ardmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35739, "roofing_contractor.phone": "(256) 423-3370" }, "15430": { "city_x_roofing_contractor.id": 15430, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15430, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "Roofing Top Job", "roofing_contractor.address": "803 S Jefferson St", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 232-5559" }, "15431": { "city_x_roofing_contractor.id": 15431, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15431, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "A Plus Roofing & Repair", "roofing_contractor.address": "14256 Shaw Rd", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 431-7012" }, "15432": { "city_x_roofing_contractor.id": 15432, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15432, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "North Alabama Roofing & Restorations Inc", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 771-7333" }, "15433": { "city_x_roofing_contractor.id": 15433, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15433, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "Top Job Roofing & Construction Inc", "roofing_contractor.address": "111 Virginia Dr", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 262-4400" }, "15434": { "city_x_roofing_contractor.id": 15434, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15434, "roofing_contractor.ts": "2018-02-22 20:12:18", "roofing_contractor.title": "Elite Construction LLC", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 874-7787" }, "15435": { "city_x_roofing_contractor.id": 15435, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15435, "roofing_contractor.ts": "2018-02-22 20:12:20", "roofing_contractor.title": "Phoenix LLC", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 867-1904" }, "15436": { "city_x_roofing_contractor.id": 15436, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15436, "roofing_contractor.ts": "2018-02-22 20:12:20", "roofing_contractor.title": "Bdr Enterprises LLC", "roofing_contractor.address": "26449 Salem Minor Hill Rd", "roofing_contractor.city": "Lester", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35647, "roofing_contractor.phone": "(256) 233-6182" }, "15437": { "city_x_roofing_contractor.id": 15437, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15437, "roofing_contractor.ts": "2018-02-22 20:12:20", "roofing_contractor.title": "Interior Exterior Building Supply", "roofing_contractor.address": "13764 Mooresville Rd.", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35613, "roofing_contractor.phone": "(256) 262-6360" }, "15438": { "city_x_roofing_contractor.id": 15438, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15438, "roofing_contractor.ts": "2018-02-22 20:12:20", "roofing_contractor.title": "Dobbs Paul Construction Inc", "roofing_contractor.address": "1002 E Pryor St", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 867-1881" }, "15439": { "city_x_roofing_contractor.id": 15439, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15439, "roofing_contractor.ts": "2018-02-22 20:12:20", "roofing_contractor.title": "Economic Solutions", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 431-1342" }, "15440": { "city_x_roofing_contractor.id": 15440, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15440, "roofing_contractor.ts": "2018-02-22 20:12:20", "roofing_contractor.title": "Freeman Construction", "roofing_contractor.address": "923 N Clinton St", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 278-9584" }, "15441": { "city_x_roofing_contractor.id": 15441, "city.id": 6, "city.ts": "2018-02-22 20:12:24", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15441, "roofing_contractor.ts": "2018-02-22 20:12:20", "roofing_contractor.title": "Ryan Home & Farm Services", "roofing_contractor.address": "Athens,", "roofing_contractor.city": "Athens", "roofing_contractor.state": "AL", "roofing_contractor.zip": 35611, "roofing_contractor.phone": "(256) 431-9108" }, "50": { "city_x_roofing_contractor.id": 50, "city.id": 7, "city.ts": "2018-02-22 20:12:27", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 50, "roofing_contractor.ts": "2018-02-22 01:35:22", "roofing_contractor.title": "Amerson Roofing Inc", "roofing_contractor.address": "505 N Main St", "roofing_contractor.city": "Atmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36502, "roofing_contractor.phone": "(251) 368-5295" }, "51": { "city_x_roofing_contractor.id": 51, "city.id": 7, "city.ts": "2018-02-22 20:12:27", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 51, "roofing_contractor.ts": "2018-02-22 01:35:22", "roofing_contractor.title": "Snider's Roofing & Construction", "roofing_contractor.address": "Atmore,", "roofing_contractor.city": "Atmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36502, "roofing_contractor.phone": "(251) 253-0494" }, "52": { "city_x_roofing_contractor.id": 52, "city.id": 7, "city.ts": "2018-02-22 20:12:27", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 52, "roofing_contractor.ts": "2018-02-22 01:35:22", "roofing_contractor.title": "Amerson Roofing Inc", "roofing_contractor.address": "Atmore,", "roofing_contractor.city": "Atmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36502, "roofing_contractor.phone": "(251) 446-8363" }, "53": { "city_x_roofing_contractor.id": 53, "city.id": 7, "city.ts": "2018-02-22 20:12:27", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 53, "roofing_contractor.ts": "2018-02-22 01:35:22", "roofing_contractor.title": "Edwards A J Roofing Co Inc", "roofing_contractor.address": "1910 E Nashville Ave", "roofing_contractor.city": "Atmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36502, "roofing_contractor.phone": "(251) 368-6517" }, "54": { "city_x_roofing_contractor.id": 54, "city.id": 7, "city.ts": "2018-02-22 20:12:27", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 54, "roofing_contractor.ts": "2018-02-22 01:35:22", "roofing_contractor.title": "Snider Douglas", "roofing_contractor.address": "43 Homewood Dr", "roofing_contractor.city": "Atmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36502, "roofing_contractor.phone": "(251) 294-5486" }, "55": { "city_x_roofing_contractor.id": 55, "city.id": 7, "city.ts": "2018-02-22 20:12:27", "city.title": "Atmore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 55, "roofing_contractor.ts": "2018-02-22 01:35:22", "roofing_contractor.title": "Ace Hardware", "roofing_contractor.address": "209 W Nashville Ave", "roofing_contractor.city": "Atmore", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36502, "roofing_contractor.phone": "(251) 446-1535" }, "56": { "city_x_roofing_contractor.id": 56, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 56, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Roof Rinse & Run", "roofing_contractor.address": "1780 Hyden Park Ln", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 332-7799" }, "57": { "city_x_roofing_contractor.id": 57, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 57, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Gtr Contractors", "roofing_contractor.address": "480 N Dean Rd Ste A1", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 745-0532" }, "58": { "city_x_roofing_contractor.id": 58, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 58, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Superior Roofing", "roofing_contractor.address": "Phenix City,", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36867, "roofing_contractor.phone": "(706) 322-9032" }, "59": { "city_x_roofing_contractor.id": 59, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 59, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Monroe Roofing", "roofing_contractor.address": "2263 County Road 21", "roofing_contractor.city": "Waverly", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36879, "roofing_contractor.phone": "(334) 501-8990" }, "60": { "city_x_roofing_contractor.id": 60, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 60, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Daniel's Roofing", "roofing_contractor.address": "1 Dandelion St", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36870, "roofing_contractor.phone": "(706) 332-6034" }, "61": { "city_x_roofing_contractor.id": 61, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 61, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Mike's Roofing", "roofing_contractor.address": "1314 Lantuck Rd", "roofing_contractor.city": "Valley", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36854, "roofing_contractor.phone": "(334) 444-9103" }, "62": { "city_x_roofing_contractor.id": 62, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 62, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Ramsey Roofing", "roofing_contractor.address": "Lanett,", "roofing_contractor.city": "Lanett", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36863, "roofing_contractor.phone": "(334) 576-7537" }, "63": { "city_x_roofing_contractor.id": 63, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 63, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Greens Roofing", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36832, "roofing_contractor.phone": "(334) 319-1996" }, "64": { "city_x_roofing_contractor.id": 64, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 64, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Wayne's Roofing", "roofing_contractor.address": "Valley,", "roofing_contractor.city": "Valley", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36872, "roofing_contractor.phone": "(334) 559-5550" }, "65": { "city_x_roofing_contractor.id": 65, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 65, "roofing_contractor.ts": "2018-02-22 01:35:28", "roofing_contractor.title": "Jubilee Roofing", "roofing_contractor.address": "1550 Opelika Rd", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 821-7971" }, "15458": { "city_x_roofing_contractor.id": 15458, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15458, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Caldwell's Roofing", "roofing_contractor.address": "1780 Hyden Park Ln", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 332-7799" }, "15459": { "city_x_roofing_contractor.id": 15459, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15459, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Alex's Roofing Co", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 521-8111" }, "15460": { "city_x_roofing_contractor.id": 15460, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15460, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Atlanta Residential Roofing", "roofing_contractor.address": "101 E 19th St", "roofing_contractor.city": "Lanett", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36863, "roofing_contractor.phone": "(334) 644-7003" }, "15461": { "city_x_roofing_contractor.id": 15461, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15461, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "B & S Roofing", "roofing_contractor.address": "Opelika,", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36801, "roofing_contractor.phone": "(334) 524-5499" }, "15462": { "city_x_roofing_contractor.id": 15462, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15462, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Metal Roofing Sales & Service", "roofing_contractor.address": "1913 S Broad Ave", "roofing_contractor.city": "Lanett", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36863, "roofing_contractor.phone": "(334) 644-7663" }, "15463": { "city_x_roofing_contractor.id": 15463, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15463, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "B & S Roofing", "roofing_contractor.address": "Opelika,", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36802, "roofing_contractor.phone": "(334) 524-5499" }, "15464": { "city_x_roofing_contractor.id": 15464, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15464, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Monroe's James Roofing", "roofing_contractor.address": "3609 Saugahatchee Rd", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36801, "roofing_contractor.phone": "(334) 749-8858" }, "15465": { "city_x_roofing_contractor.id": 15465, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15465, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Yellowhammer Roofing Inc", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 501-0824" }, "15466": { "city_x_roofing_contractor.id": 15466, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15466, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Above Board Roofing", "roofing_contractor.address": "801 S Railroad Ave", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36801, "roofing_contractor.phone": "(334) 741-4253" }, "15467": { "city_x_roofing_contractor.id": 15467, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15467, "roofing_contractor.ts": "2018-02-22 20:12:31", "roofing_contractor.title": "Dixie Roofing Co", "roofing_contractor.address": "221 Lee Road 232", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36870, "roofing_contractor.phone": "(334) 297-5226" }, "15468": { "city_x_roofing_contractor.id": 15468, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15468, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Cross Country Roofing Inc", "roofing_contractor.address": "1231 Brookwood Cir", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36801, "roofing_contractor.phone": "(334) 741-7700" }, "15469": { "city_x_roofing_contractor.id": 15469, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15469, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Yellow Hammer Roofing Inc", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36832, "roofing_contractor.phone": "(334) 501-0824" }, "15470": { "city_x_roofing_contractor.id": 15470, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15470, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Boyd's Roofing LLC", "roofing_contractor.address": "Opelika,", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36802, "roofing_contractor.phone": "(334) 703-3543" }, "15471": { "city_x_roofing_contractor.id": 15471, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15471, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "A R Roofing", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36832, "roofing_contractor.phone": "(334) 521-8193" }, "15472": { "city_x_roofing_contractor.id": 15472, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15472, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Pr Roofing & Construction", "roofing_contractor.address": "21 Balsa Dr", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36869, "roofing_contractor.phone": "(706) 761-7213" }, "15473": { "city_x_roofing_contractor.id": 15473, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15473, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Cross Country Roofing Inc", "roofing_contractor.address": "Opelika,", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36802, "roofing_contractor.phone": "(334) 741-7700" }, "15474": { "city_x_roofing_contractor.id": 15474, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15474, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Roofing Professionals Inc", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36832, "roofing_contractor.phone": "(334) 364-0884" }, "15475": { "city_x_roofing_contractor.id": 15475, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15475, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Best Built Roofing", "roofing_contractor.address": "800 14th St", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36867, "roofing_contractor.phone": "(706) 682-5262" }, "15476": { "city_x_roofing_contractor.id": 15476, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15476, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "East Alabama Roofing", "roofing_contractor.address": "Opelika,", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36802, "roofing_contractor.phone": "(334) 275-1797" }, "15477": { "city_x_roofing_contractor.id": 15477, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15477, "roofing_contractor.ts": "2018-02-22 20:12:38", "roofing_contractor.title": "Roofing Professionals Inc", "roofing_contractor.address": "1014 Opelika Rd", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 466-8144" }, "15478": { "city_x_roofing_contractor.id": 15478, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15478, "roofing_contractor.ts": "2018-02-22 20:12:41", "roofing_contractor.title": "Alex City Metal Roofing Specialist", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 728-3669" }, "15479": { "city_x_roofing_contractor.id": 15479, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15479, "roofing_contractor.ts": "2018-02-22 20:12:41", "roofing_contractor.title": "Hudson Roofing And Sheet Metal", "roofing_contractor.address": "8514 Lee Road 240", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36870, "roofing_contractor.phone": "(334) 298-0152" }, "15480": { "city_x_roofing_contractor.id": 15480, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15480, "roofing_contractor.ts": "2018-02-22 20:12:41", "roofing_contractor.title": "Auburn And Opelika Roofing Co", "roofing_contractor.address": "1206 Chewacla Rd", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36804, "roofing_contractor.phone": "(334) 749-3160" }, "15481": { "city_x_roofing_contractor.id": 15481, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15481, "roofing_contractor.ts": "2018-02-22 20:12:41", "roofing_contractor.title": "A & E Metal Roofing Supply", "roofing_contractor.address": "230 Lee Road 430", "roofing_contractor.city": "Smiths Station", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36877, "roofing_contractor.phone": "(334) 664-0114" }, "15482": { "city_x_roofing_contractor.id": 15482, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15482, "roofing_contractor.ts": "2018-02-22 20:12:41", "roofing_contractor.title": "A & E Metal Roofing Supply", "roofing_contractor.address": "Phenix City,", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36867, "roofing_contractor.phone": "(334) 664-0113" }, "15483": { "city_x_roofing_contractor.id": 15483, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15483, "roofing_contractor.ts": "2018-02-22 20:12:41", "roofing_contractor.title": "Horn Doug Roofing And Contracting Co", "roofing_contractor.address": "512 N Railroad Ave", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36801, "roofing_contractor.phone": "(334) 749-1289" }, "15484": { "city_x_roofing_contractor.id": 15484, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15484, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "Htr Inc", "roofing_contractor.address": "1502 River Rd", "roofing_contractor.city": "Valley", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36854, "roofing_contractor.phone": "(334) 758-0117" }, "15485": { "city_x_roofing_contractor.id": 15485, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15485, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "Daniel's Custom Siding & Gutter", "roofing_contractor.address": "Opelika,", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36802, "roofing_contractor.phone": "(334) 319-6137" }, "15486": { "city_x_roofing_contractor.id": 15486, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15486, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "B & D Company", "roofing_contractor.address": "Phenix City,", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36867, "roofing_contractor.phone": "(706) 393-0486" }, "15487": { "city_x_roofing_contractor.id": 15487, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15487, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "Glynnis Pedigree Pups", "roofing_contractor.address": "8514 Lee Road 240", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36870, "roofing_contractor.phone": "(334) 298-0152" }, "15488": { "city_x_roofing_contractor.id": 15488, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15488, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "Dek Construction", "roofing_contractor.address": "Auburn,", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36832, "roofing_contractor.phone": "(334) 329-0800" }, "15489": { "city_x_roofing_contractor.id": 15489, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15489, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "A1 Man Services", "roofing_contractor.address": "3814 US Highway 80 W", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36870, "roofing_contractor.phone": "(706) 273-7663" }, "15490": { "city_x_roofing_contractor.id": 15490, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15490, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "Metalcrafts Incorporated", "roofing_contractor.address": "116 Bragg Ave", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36830, "roofing_contractor.phone": "(334) 821-7726" }, "15491": { "city_x_roofing_contractor.id": 15491, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15491, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "A 1 Roofmancom", "roofing_contractor.address": "3824 US Highway 80 W", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36870, "roofing_contractor.phone": "(334) 560-3202" }, "15492": { "city_x_roofing_contractor.id": 15492, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15492, "roofing_contractor.ts": "2018-02-22 20:12:43", "roofing_contractor.title": "Curb Technologies LLC", "roofing_contractor.address": "8737 Al Highway 51", "roofing_contractor.city": "Opelika", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36804, "roofing_contractor.phone": "(334) 749-6801" }, "15493": { "city_x_roofing_contractor.id": 15493, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15493, "roofing_contractor.ts": "2018-02-22 20:12:47", "roofing_contractor.title": "Southeastern Foam & Coating", "roofing_contractor.address": "8434 County Road 289", "roofing_contractor.city": "Lanett", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36863, "roofing_contractor.phone": "(334) 499-1188" }, "15494": { "city_x_roofing_contractor.id": 15494, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15494, "roofing_contractor.ts": "2018-02-22 20:12:47", "roofing_contractor.title": "Bbb Construction LLC", "roofing_contractor.address": "PO Box 3383", "roofing_contractor.city": "Auburn", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36831, "roofing_contractor.phone": "(334) 524-6319" }, "15495": { "city_x_roofing_contractor.id": 15495, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15495, "roofing_contractor.ts": "2018-02-22 20:12:47", "roofing_contractor.title": "Bartley Construction", "roofing_contractor.address": "Phenix City,", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36867, "roofing_contractor.phone": "(706) 615-0672" }, "15496": { "city_x_roofing_contractor.id": 15496, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15496, "roofing_contractor.ts": "2018-02-22 20:12:47", "roofing_contractor.title": "Local Handyman Services LLC", "roofing_contractor.address": "3227 US Highway 29", "roofing_contractor.city": "Valley", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36854, "roofing_contractor.phone": "(706) 773-7174" }, "15497": { "city_x_roofing_contractor.id": 15497, "city.id": 8, "city.ts": "2018-02-22 20:12:57", "city.title": "Auburn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-22 01:26:46", "state.title": "Alabama", "roofing_contractor.id": 15497, "roofing_contractor.ts": "2018-02-22 20:12:47", "roofing_contractor.title": "Top To Bottom Home Renovations", "roofing_contractor.address": "1704 8th Pl S", "roofing_contractor.city": "Phenix City", "roofing_contractor.state": "AL", "roofing_contractor.zip": 36869, "roofing_contractor.phone": "(706) 366-3528" } } } }