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
41,"2018-02-22 01:35:17","Gilbert Roofing","Athens,",Athens,AL,35611,"(256) 444-1297","{
    ""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""
    }
}"
42,"2018-02-22 01:35:17","Lewis Roofing","Elkmont,",Elkmont,AL,35620,"(256) 431-2202","{
    ""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""
    }
}"
43,"2018-02-22 01:35:17","Advanced Roofing","22277 Howard St",Athens,AL,35613,"(256) 734-7050","{
    ""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""
    }
}"
44,"2018-02-22 01:35:17","Yellowhammer Roofing Inc","22923 US Highway 72 Ste D",Athens,AL,35613,"(256) 423-7537","{
    ""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""
    }
}"
45,"2018-02-22 01:35:17","Ashby Roofing Company","Athens,",Athens,AL,35611,"(256) 777-0731","{
    ""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""
    }
}"
46,"2018-02-22 01:35:17","Yellowhammer Roofing Inc","26476 5th St",Ardmore,AL,35739,"(256) 423-8141","{
    ""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""
    }
}"
47,"2018-02-22 01:35:17","R & S Roofing","Athens,",Athens,AL,35611,"(256) 777-6168","{
    ""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""
    }
}"
48,"2018-02-22 01:35:17","Southern Roofing & Const","20635 Colonial Dr",Athens,AL,35614,"(256) 232-2555","{
    ""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""
    }
}"
49,"2018-02-22 01:35:17","Valley Roofing LLC","14970 US Highway 72",Athens,AL,35611,"(256) 444-4253","{
    ""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""
    }
}"
50,"2018-02-22 01:35:22","Amerson Roofing Inc","505 N Main St",Atmore,AL,36502,"(251) 368-5295","{
    ""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""
    }
}"
51,"2018-02-22 01:35:22","Snider's Roofing & Construction","Atmore,",Atmore,AL,36502,"(251) 253-0494","{
    ""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""
    }
}"
52,"2018-02-22 01:35:22","Amerson Roofing Inc","Atmore,",Atmore,AL,36502,"(251) 446-8363","{
    ""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""
    }
}"
53,"2018-02-22 01:35:22","Edwards A J Roofing Co Inc","1910 E Nashville Ave",Atmore,AL,36502,"(251) 368-6517","{
    ""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""
    }
}"
54,"2018-02-22 01:35:22","Snider Douglas","43 Homewood Dr",Atmore,AL,36502,"(251) 294-5486","{
    ""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""
    }
}"
55,"2018-02-22 01:35:22","Ace Hardware","209 W Nashville Ave",Atmore,AL,36502,"(251) 446-1535","{
    ""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""
    }
}"
56,"2018-02-22 01:35:28","Roof Rinse & Run","1780 Hyden Park Ln",Auburn,AL,36830,"(334) 332-7799","{
    ""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""
    }
}"
57,"2018-02-22 01:35:28","Gtr Contractors","480 N Dean Rd Ste A1",Auburn,AL,36830,"(334) 745-0532","{
    ""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""
    }
}"
58,"2018-02-22 01:35:28","Superior Roofing","Phenix City,","Phenix City",AL,36867,"(706) 322-9032","{
    ""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""
    }
}"
59,"2018-02-22 01:35:28","Monroe Roofing","2263 County Road 21",Waverly,AL,36879,"(334) 501-8990","{
    ""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""
    }
}"
60,"2018-02-22 01:35:28","Daniel's Roofing","1 Dandelion St","Phenix City",AL,36870,"(706) 332-6034","{
    ""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""
    }
}"