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
1,"2018-02-22 01:34:55","Lees Roofing","Guntersville,",Guntersville,AL,35976,"(256) 960-0062","{
    ""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""
    }
}"
2,"2018-02-22 01:34:55","Blake's Roofing","Guntersville,",Guntersville,AL,35976,"(256) 202-2555","{
    ""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""
    }
}"
3,"2018-02-22 01:34:55","Lee's Roofing","Albertville,",Albertville,AL,35950,"(256) 677-4436","{
    ""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""
    }
}"
4,"2018-02-22 01:34:55","Whitmore's Roofing","630 Oakes Rd",Boaz,AL,35956,"(256) 558-2239","{
    ""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""
    }
}"
5,"2018-02-22 01:34:55","Tedder Roofing & Repairs","515 County Highway 25",Guntersville,AL,35976,"(256) 586-6378","{
    ""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""
    }
}"
6,"2018-02-22 01:34:55","Hunnie Due Roofing","Albertville,",Albertville,AL,35950,"(256) 302-3917","{
    ""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""
    }
}"
7,"2018-02-22 01:34:55","Fuller Roofing & Gutters","421 Tidwell Rd",Boaz,AL,35956,"(256) 593-6040","{
    ""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""
    }
}"
8,"2018-02-22 01:34:55","P & R Roofing","112 Sand Mountain Dr NW",Albertville,AL,35950,"(256) 582-3754","{
    ""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""
    }
}"
9,"2018-02-22 01:34:55","Town & Country Roofing","73 Frazier Rd",Albertville,AL,35950,"(256) 878-1155","{
    ""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""
    }
}"
10,"2018-02-22 01:34:55","T & T Roofing","Guntersville,",Guntersville,AL,35976,"(256) 505-9783","{
    ""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""
    }
}"
11,"2018-02-22 01:35:01","Mason Roofing","Dogwood Ave","Alexander City",AL,35010,"(256) 234-6874","{
    ""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""
    }
}"
12,"2018-02-22 01:35:01","Mason Roofing","Jacksons Gap,","Jacksons Gap",AL,36861,"(256) 749-1745","{
    ""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""
    }
}"
13,"2018-02-22 01:35:01","Mason Roofing","Alexander City,","Alexander City",AL,35010,"(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""
    }
}"
14,"2018-02-22 01:35:01","Alex City Roofing & Construction","33 Emerald Dr","Jacksons Gap",AL,36861,"(256) 825-8761","{
    ""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""
    }
}"
15,"2018-02-22 01:35:01","Old Southern Roofing Co","Dadeville,",Dadeville,AL,36853,"(256) 825-6676","{
    ""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""
    }
}"
16,"2018-02-22 01:35:01","Capitol City Roofing","Alexander City,","Alexander City",AL,35010,"(256) 234-0209","{
    ""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""
    }
}"
17,"2018-02-22 01:35:01","Old Southern Roofing Co","Alexander City,","Alexander City",AL,35010,"(256) 234-5007","{
    ""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""
    }
}"
18,"2018-02-22 01:35:01","Old Southern Roofing Co","33 Emerald Dr","Jacksons Gap",AL,36861,"(256) 825-8761","{
    ""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""
    }
}"
19,"2018-02-22 01:35:01","Alex City Metal Roofing Specialist","Alexander City,","Alexander City",AL,35010,"(256) 794-7566","{
    ""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""
    }
}"
20,"2018-02-22 01:35:01","Wheeles Seamless Gutters And Roofing","Alexander City,","Alexander City",AL,35010,"(256) 596-1821","{
    ""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""
    }
}"