roofing_contractor.id,roofing_contractor.ts,roofing_contractor.title,roofing_contractor.address,roofing_contractor.city,roofing_contractor.state,roofing_contractor.zip,roofing_contractor.phone,roofing_contractor.city_x_roofing_contractor_id
21,"2018-02-22 01:35:06","Scott Cook Roofing","807 PO Box",Opp,AL,36467,"(334) 493-3926","{
    ""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""
    }
}"
22,"2018-02-22 01:35:06","Scott Cook Roofing","308 14th St",Opp,AL,36467,"(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""
    }
}"
23,"2018-02-22 01:35:06","Scott Cook Roofing","307 14th St",Opp,AL,36467,"(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""
    }
}"
24,"2018-02-22 01:35:06","Allcoast Roofing & Construction","33 Owens Rd",Brantley,AL,36009,"(334) 343-7980","{
    ""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""
    }
}"
25,"2018-02-22 01:35:06","Hollinghead Roofing Karman","157 RR 3 Box",Opp,AL,36467,"(334) 493-6449","{
    ""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""
    }
}"
26,"2018-02-22 01:35:06","Kenneth Bedsole Roofing","17172 Oak Tree Ln",Andalusia,AL,36421,"(334) 428-2227","{
    ""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""
    }
}"
27,"2018-02-22 01:35:06","Simmons Roofing Company","17470 Cane Juice Ln",Andalusia,AL,36420,"(334) 222-5379","{
    ""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""
    }
}"
28,"2018-02-22 01:35:06","Foreman Roofing & Renovation Co Inc","111 Liberty Rd",Brantley,AL,36009,"(334) 496-3948","{
    ""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""
    }
}"
29,"2018-02-22 01:35:06","C & C Vinyl And Roofing","35516 Boston Rd",Dozier,AL,36028,"(334) 496-3372","{
    ""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""
    }
}"
30,"2018-02-22 01:35:12","Andy The Roofer & Co Inc","Anniston,",Anniston,AL,36201,"(256) 835-7643","{
    ""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""
    }
}"
31,"2018-02-22 01:35:12","Andy The Roofer & Co Inc","Oxford,",Oxford,AL,36203,"(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""
    }
}"
32,"2018-02-22 01:35:12","D & G Roofing Contractors","PO Box 887",Ohatchee,AL,36271,"(256) 442-3426","{
    ""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""
    }
}"
33,"2018-02-22 01:35:12","Affordable Roof Repair & Custom Built Decks","Anniston,",Anniston,AL,36205,"(256) 405-5733","{
    ""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""
    }
}"
34,"2018-02-22 01:35:12","Post Roofing","Anniston,",Anniston,AL,36201,"(256) 689-7039","{
    ""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""
    }
}"
35,"2018-02-22 01:35:12","Reynolds Roofing","2610 County Road 67",Piedmont,AL,36272,"(256) 557-3543","{
    ""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""
    }
}"
36,"2018-02-22 01:35:12","Hollingsworth Roofing","Anniston,",Anniston,AL,36205,"(256) 689-0515","{
    ""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""
    }
}"
37,"2018-02-22 01:35:12","Reliable Roofing","Anniston,",Anniston,AL,36205,"(256) 403-0087","{
    ""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""
    }
}"
38,"2018-02-22 01:35:12","USA Roofing","502 Tillman Ave",Anniston,AL,36201,"(256) 591-2877","{
    ""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""
    }
}"
39,"2018-02-22 01:35:12","Reliable Roofing","Anniston,",Anniston,AL,36201,"(256) 403-0087","{
    ""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""
    }
}"
40,"2018-02-22 01:35:17","Roof Tech Solutions, LLC","11275 John Pugh Road",Tanner,AL,35671,"(256) 431-5002","{
    ""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""
    }
}"