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": "Nationwide Insurance Agents 1", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 20, "limit_total": 400, "time": 0.0036099999999999999276967255212866803049109876155853271484375 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 3249, "pages_total": 163 }, "struct": { "stem": { "0": "state", "1": "city" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "21": { "city.id": 21, "city.ts": "2017-09-05 22:27:33", "city.title": "Decatur", "city.city_x_agent_id": { "28506": { "city_x_agent.id": 28506, "agent.id": 39, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Tammy C Elders", "agent.pull_right": "24.92 mi", "agent.phone_number": "(256) 882-0706", "agent.street_address": "8003 Charlotte Dr", "agent.address_locality": "Huntsville, AL 35802-2254" }, "28499": { "city_x_agent.id": 28499, "agent.id": 43, "agent.ts": "2017-09-05 22:14:00", "agent.title": "John J Kilgro Jr", "agent.pull_right": "1.06 mi", "agent.phone_number": "(256) 232-5241", "agent.street_address": "800 US Highway 72 W STE G", "agent.address_locality": "Athens, AL 35611-4227" }, "28498": { "city_x_agent.id": 28498, "agent.id": 44, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Thomas E McAlister", "agent.pull_right": "1.73 mi", "agent.phone_number": "(256) 232-7200", "agent.street_address": "1111 U S Hwy 72 East", "agent.address_locality": "Athens, AL 35611" }, "28497": { "city_x_agent.id": 28497, "agent.id": 45, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Scott Wyatt Howell", "agent.pull_right": "1.91 mi", "agent.phone_number": "(256) 444-2041", "agent.street_address": "1114 Hwy 31 S STE E", "agent.address_locality": "Athens, AL 35611-4471" }, "28509": { "city_x_agent.id": 28509, "agent.id": 46, "agent.ts": "2017-09-05 05:17:39", "agent.title": "PEPPER JOHNSTONE & COMPANY INC", "agent.pull_right": "0.10 mi", "agent.phone_number": "(256) 232-7818", "agent.street_address": "122 W MARKET ST", "agent.address_locality": "Athens, AL 35611-2656" }, "28510": { "city_x_agent.id": 28510, "agent.id": 47, "agent.ts": "2017-09-05 05:17:39", "agent.title": "MARTIN & HUBBS INC", "agent.pull_right": "0.11 mi", "agent.phone_number": "(256) 232-0505", "agent.street_address": "102 W MARKET ST", "agent.address_locality": "Athens, AL 35611-2656" }, "28502": { "city_x_agent.id": 28502, "agent.id": 49, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Scott Wyatt Howell", "agent.pull_right": "12.65 mi", "agent.phone_number": "(256) 444-2041", "agent.street_address": "7561 Wall Triana Hwy Ste 3", "agent.address_locality": "Madison, AL 35757-8327" }, "144": { "city_x_agent.id": 144, "agent.id": 50, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Mickey H Brewington", "agent.pull_right": "13.60 mi", "agent.phone_number": "(256) 353-1115", "agent.street_address": "303 Cain St NE Ste B", "agent.address_locality": "Decatur, AL 35601-1983" }, "145": { "city_x_agent.id": 145, "agent.id": 51, "agent.ts": "2017-09-05 22:14:00", "agent.title": "John J Kilgro Jr", "agent.pull_right": "13.97 mi", "agent.phone_number": "(256) 350-8241", "agent.street_address": "439 Johnston St SE", "agent.address_locality": "Decatur, AL 35601" }, "28500": { "city_x_agent.id": 28500, "agent.id": 52, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Donna B. Oglesby", "agent.pull_right": "15.04 mi", "agent.phone_number": "(256) 464-7020", "agent.street_address": "107 Arlington Dr Ste N", "agent.address_locality": "Madison, AL 35758-1735" }, "149": { "city_x_agent.id": 149, "agent.id": 141, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Larry Akin", "agent.pull_right": "19.87 mi", "agent.phone_number": "(256) 355-8500", "agent.street_address": "468 Highway 67 S", "agent.address_locality": "Decatur, AL 35603" }, "28508": { "city_x_agent.id": 28508, "agent.id": 142, "agent.ts": "2017-09-05 05:21:51", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "1.08 mi", "agent.phone_number": "(256) 773-2210", "agent.street_address": "1612 HIGHWAY 31 SW", "agent.address_locality": "Hartselle, AL 35640-2826" }, "146": { "city_x_agent.id": 146, "agent.id": 146, "agent.ts": "2017-09-05 22:14:01", "agent.title": "John J Kilgro Jr", "agent.pull_right": "15.65 mi", "agent.phone_number": "(256) 350-9434", "agent.street_address": "520 14th Ave SE", "agent.address_locality": "Decatur, AL 35601" }, "147": { "city_x_agent.id": 147, "agent.id": 147, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Larry Akin", "agent.pull_right": "16.19 mi", "agent.phone_number": "(256) 260-2278", "agent.street_address": "820 Bradley St SW", "agent.address_locality": "Decatur, AL 35601" }, "148": { "city_x_agent.id": 148, "agent.id": 148, "agent.ts": "2017-09-05 22:14:01", "agent.title": "David Hayes", "agent.pull_right": "16.85 mi", "agent.phone_number": "(256) 350-6315", "agent.street_address": "1000 Beltline Rd SW Ste A", "agent.address_locality": "Decatur, AL 35601" }, "150": { "city_x_agent.id": 150, "agent.id": 150, "agent.ts": "2017-09-05 22:14:11", "agent.title": "SS NESBITT & CO INC", "agent.pull_right": "15.22 mi", "agent.phone_number": "(205) 262-2700", "agent.street_address": "1425 6TH AVE SE", "agent.address_locality": "Decatur, AL 35601-4211" }, "151": { "city_x_agent.id": 151, "agent.id": 151, "agent.ts": "2017-09-05 22:14:11", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "15.59 mi", "agent.phone_number": "(256) 350-7296", "agent.street_address": "2708 6TH AVE SE STE A", "agent.address_locality": "Decatur, AL 35603-1508" }, "152": { "city_x_agent.id": 152, "agent.id": 152, "agent.ts": "2017-09-05 22:14:11", "agent.title": "KING WYNN & ASSOCIATES LLC", "agent.pull_right": "16.71 mi", "agent.phone_number": "(256) 686-3383", "agent.street_address": "2021 DANVILLE PARK DR SW STE 8", "agent.address_locality": "Decatur, AL 35603-1806" }, "153": { "city_x_agent.id": 153, "agent.id": 153, "agent.ts": "2017-09-05 22:14:11", "agent.title": "STOVALL MARKS INSURANCE INC", "agent.pull_right": "16.95 mi", "agent.phone_number": "(256) 355-7951", "agent.street_address": "2601 DANVILLE RD SW", "agent.address_locality": "Decatur, AL 35603-4216" }, "28504": { "city_x_agent.id": 28504, "agent.id": 179, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Michael Noe", "agent.pull_right": "18.15 mi", "agent.phone_number": "(256) 247-3530", "agent.street_address": "16428 Highway 72", "agent.address_locality": "Rogersville, AL 35652" }, "28496": { "city_x_agent.id": 28496, "agent.id": 241, "agent.ts": "2017-09-05 22:14:11", "agent.title": "STOVALL MARKS INSURANCE, INC", "agent.pull_right": "16.95 mi", "agent.phone_number": "(256) 355-7951", "agent.street_address": "2601 DANVILLE RD SW", "agent.address_locality": "Decatur, AL 35603-4216" }, "28507": { "city_x_agent.id": 28507, "agent.id": 255, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Jon Peters", "agent.pull_right": "22.30 mi", "agent.phone_number": "(256) 288-0230", "agent.street_address": "1017 Meridian St N", "agent.address_locality": "Huntsville, AL 35801" }, "28505": { "city_x_agent.id": 28505, "agent.id": 256, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Dusty Kilgore", "agent.pull_right": "22.70 mi", "agent.phone_number": "(256) 539-7378", "agent.street_address": "900 Bob Wallace Ave Ste 107", "agent.address_locality": "Huntsville, AL 35801-5647" }, "28503": { "city_x_agent.id": 28503, "agent.id": 257, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Aleyda Schwaiger", "agent.pull_right": "21.86 mi", "agent.phone_number": "(256) 221-5740", "agent.street_address": "4008 Triana Blvd", "agent.address_locality": "Huntsville, AL 35805-5406" }, "28501": { "city_x_agent.id": 28501, "agent.id": 260, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Dallas Davis-Graydon", "agent.pull_right": "15.08 mi", "agent.phone_number": "(256) 716-1307", "agent.street_address": "1807 Slaughter Rd Ste A", "agent.address_locality": "Madison, AL 35758-8695" }, "28515": { "city_x_agent.id": 28515, "agent.id": 262, "agent.ts": "2017-09-05 22:14:11", "agent.title": "FOUNT PARKER HARBARGER & ASSOC", "agent.pull_right": "22.40 mi", "agent.phone_number": "(256) 428-1000", "agent.street_address": "201 WASHINGTON ST NE", "agent.address_locality": "Huntsville, AL 35801-4844" }, "28514": { "city_x_agent.id": 28514, "agent.id": 263, "agent.ts": "2017-09-05 22:14:11", "agent.title": "J SMITH LANIER & CO", "agent.pull_right": "18.45 mi", "agent.phone_number": "(256) 890-9060", "agent.street_address": "206 EXCHANGE PL NW", "agent.address_locality": "Huntsville, AL 35806-2300" }, "28512": { "city_x_agent.id": 28512, "agent.id": 264, "agent.ts": "2017-09-05 22:14:11", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "16.27 mi", "agent.phone_number": "(256) 772-9704", "agent.street_address": "8121 MADISON BLVD STE 101B", "agent.address_locality": "Madison, AL 35758-2082" }, "28513": { "city_x_agent.id": 28513, "agent.id": 344, "agent.ts": "2017-09-05 05:23:31", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "1.22 mi", "agent.phone_number": "(256) 974-4000", "agent.street_address": "11210 AL HIGHWAY 157", "agent.address_locality": "Moulton, AL 35650-1906" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "22": { "city.id": 22, "city.ts": "2017-08-15 02:34:15", "city.title": "Demopolis", "city.city_x_agent_id": { "154": { "city_x_agent.id": 154, "agent.id": 154, "agent.ts": "2017-09-05 05:23:02", "agent.title": "MARENGO INSURANCE AGENCY INC", "agent.pull_right": "20.85 mi", "agent.phone_number": "(334) 289-0828", "agent.street_address": "107 W WASHINGTON ST", "agent.address_locality": "Demopolis, AL 36732-2043" }, "155": { "city_x_agent.id": 155, "agent.id": 155, "agent.ts": "2017-09-05 05:23:02", "agent.title": "MARENGO INSURANCE AGENCY INC", "agent.pull_right": "0.09 mi", "agent.phone_number": "(205) 652-9591", "agent.street_address": "222 S WASHINGTON ST", "agent.address_locality": "Livingston, AL 35470" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "23": { "city.id": 23, "city.ts": "2017-08-15 02:34:15", "city.title": "Dothan", "city.city_x_agent_id": { "156": { "city_x_agent.id": 156, "agent.id": 156, "agent.ts": "2017-09-05 05:19:56", "agent.title": "David R. Cornelius", "agent.pull_right": "0.75 mi", "agent.phone_number": "(334) 677-6238", "agent.street_address": "1050 W Main St", "agent.address_locality": "Dothan, AL 36301" }, "157": { "city_x_agent.id": 157, "agent.id": 157, "agent.ts": "2017-09-05 05:19:56", "agent.title": "SLINGLUFF INSURANCE AGENCY INC", "agent.pull_right": "0.42 mi", "agent.phone_number": "(334) 792-5101", "agent.street_address": "568 S OATES ST", "agent.address_locality": "Dothan, AL 36301-2554" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "24": { "city.id": 24, "city.ts": "2017-09-05 22:27:43", "city.title": "Eclectic", "city.city_x_agent_id": { "160": { "city_x_agent.id": 160, "agent.id": 24, "agent.ts": "2017-09-05 05:25:39", "agent.title": "Mark Daughtry", "agent.pull_right": "22.95 mi", "agent.phone_number": "(256) 234-7781", "agent.street_address": "746 Commerce Dr", "agent.address_locality": "Alexander City, AL 35010-3919" }, "158": { "city_x_agent.id": 158, "agent.id": 25, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Brenda Shepherd", "agent.pull_right": "12.10 mi", "agent.phone_number": "(334) 541-2400", "agent.street_address": "25 Central Ave-Kowaliga Rd", "agent.address_locality": "Eclectic, AL 36024" }, "159": { "city_x_agent.id": 159, "agent.id": 159, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Gary W Davenport", "agent.pull_right": "9.94 mi", "agent.phone_number": "(334) 271-1610", "agent.street_address": "441 N Eastern Blvd", "agent.address_locality": "Montgomery, AL 36117-2211" }, "161": { "city_x_agent.id": 161, "agent.id": 161, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Sandra Dockery", "agent.pull_right": "13.27 mi", "agent.phone_number": "(334) 277-6991", "agent.street_address": "6781 Taylor Cir", "agent.address_locality": "Montgomery, AL 36117" }, "162": { "city_x_agent.id": 162, "agent.id": 162, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Jon Peters", "agent.pull_right": "12.46 mi", "agent.phone_number": "(334) 396-3141", "agent.street_address": "4157 Carmichael Rd", "agent.address_locality": "Montgomery, AL 36106-2888" }, "163": { "city_x_agent.id": 163, "agent.id": 163, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Randy Jones", "agent.pull_right": "12.75 mi", "agent.phone_number": "(334) 272-7288", "agent.street_address": "2800 Zelda Rd Ste 200-2", "agent.address_locality": "Montgomery, AL 36106" }, "164": { "city_x_agent.id": 164, "agent.id": 164, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Randy Jones", "agent.pull_right": "12.75 mi", "agent.phone_number": "(334) 272-7288", "agent.street_address": "2800 Zelda Rd Ste 200-2", "agent.address_locality": "Montgomery, AL 36106" }, "165": { "city_x_agent.id": 165, "agent.id": 165, "agent.ts": "2017-09-05 05:26:49", "agent.title": "COUSINS INSURANCE AGENCY INC", "agent.pull_right": "0.06 mi", "agent.phone_number": "(334) 567-8493", "agent.street_address": "234 HILL ST", "agent.address_locality": "Wetumpka, AL 36092-2721" }, "166": { "city_x_agent.id": 166, "agent.id": 166, "agent.ts": "2017-09-05 05:26:49", "agent.title": "RISK MANAGEMENT ASSOCIATES LLC", "agent.pull_right": "5.56 mi", "agent.phone_number": "(334) 652-4461", "agent.street_address": "38 SETH JOHNSON DR", "agent.address_locality": "Wetumpka, AL 36093-2108" }, "167": { "city_x_agent.id": 167, "agent.id": 167, "agent.ts": "2017-09-05 05:20:01", "agent.title": "HARMON DENNIS BRADSHAW INC", "agent.pull_right": "20.06 mi", "agent.phone_number": "(334) 273-7277", "agent.street_address": "7115 HALCYON SUMMIT DR", "agent.address_locality": "Montgomery, AL 36117-6971" }, "28532": { "city_x_agent.id": 28532, "agent.id": 341, "agent.ts": "2017-09-05 05:24:59", "agent.title": "STARKE AGENCY INC", "agent.pull_right": "9.85 mi", "agent.phone_number": "(334) 263-5535", "agent.street_address": "210 COMMERCE ST", "agent.address_locality": "Montgomery, AL 36104-2587" }, "28528": { "city_x_agent.id": 28528, "agent.id": 343, "agent.ts": "2017-09-05 05:24:59", "agent.title": "STARR INSURANCE GROUP", "agent.pull_right": "11.75 mi", "agent.phone_number": "(334) 356-2500", "agent.street_address": "1736 W 2ND ST", "agent.address_locality": "Montgomery, AL 36106-1502" }, "28526": { "city_x_agent.id": 28526, "agent.id": 28536, "agent.ts": "2017-09-05 22:27:35", "agent.title": "HARMON DENNIS BRADSHAW INC.", "agent.pull_right": "20.06 mi", "agent.phone_number": "(334) 273-7277", "agent.street_address": "7115 HALCYON SUMMIT DR", "agent.address_locality": "Montgomery, AL 36117-6971" }, "28527": { "city_x_agent.id": 28527, "agent.id": 28537, "agent.ts": "2017-09-05 22:27:35", "agent.title": "THOMPSON INSURANCE INC", "agent.pull_right": "23.16 mi", "agent.phone_number": "(334) 277-8970", "agent.street_address": "3300 GATSBY LN", "agent.address_locality": "Montgomery, AL 36106-2696" }, "28529": { "city_x_agent.id": 28529, "agent.id": 28539, "agent.ts": "2017-09-05 22:27:35", "agent.title": "ALABAMA INSURANCE ALLIANCE INC", "agent.pull_right": "23.86 mi", "agent.phone_number": "(334) 277-1000", "agent.street_address": "3500 EASTERN BLVD", "agent.address_locality": "Montgomery, AL 36116-1781" }, "28530": { "city_x_agent.id": 28530, "agent.id": 28540, "agent.ts": "2017-09-05 22:27:35", "agent.title": "ALABAMA INSURANCE ALLIANCE, INC", "agent.pull_right": "23.86 mi", "agent.phone_number": "(334) 277-1000", "agent.street_address": "3500 EASTERN BLVD", "agent.address_locality": "Montgomery, AL 36116-1781" }, "28531": { "city_x_agent.id": 28531, "agent.id": 28541, "agent.ts": "2017-09-05 22:27:35", "agent.title": "ARONOV INSURANCE INC", "agent.pull_right": "23.86 mi", "agent.phone_number": "(334) 277-1000", "agent.street_address": "3500 EASTERN BLVD", "agent.address_locality": "Montgomery, AL 36116-1781" }, "28534": { "city_x_agent.id": 28534, "agent.id": 28544, "agent.ts": "2017-09-05 22:27:35", "agent.title": "ASSURED NEACE LUKENS INS AGY", "agent.pull_right": "24.08 mi", "agent.phone_number": "(334) 270-6824", "agent.street_address": "5251 HAMPSTEAD HIGH ST", "agent.address_locality": "Montgomery, AL 36116-6744" }, "28535": { "city_x_agent.id": 28535, "agent.id": 28545, "agent.ts": "2017-09-05 22:27:35", "agent.title": "ASSURED NL INSURANCE AGENCY INC", "agent.pull_right": "24.08 mi", "agent.phone_number": "(615) 301-2500", "agent.street_address": "5251 HAMPSTEAD HIGH ST STE 200", "agent.address_locality": "Montgomery, AL 36116-6755" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "25": { "city.id": 25, "city.ts": "2017-08-15 02:34:15", "city.title": "Eufaula", "city.city_x_agent_id": { "169": { "city_x_agent.id": 169, "agent.id": 1, "agent.ts": "2017-09-06 21:20:36", "agent.title": "SOUTHERN PREMIER AGENCY LLC", "agent.pull_right": "23.24 mi", "agent.phone_number": "(334) 575-5167", "agent.street_address": "109 W WILLIAMS ST", "agent.address_locality": "Abbeville, AL 36310-2123" }, "168": { "city_x_agent.id": 168, "agent.id": 4, "agent.ts": "2017-09-06 21:20:36", "agent.title": "THE GLOVER AGENCY LLC", "agent.pull_right": "0.19 mi", "agent.phone_number": "(334) 687-0358", "agent.street_address": "145 E BROAD ST", "agent.address_locality": "Eufaula, AL 36027-2023" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "26": { "city.id": 26, "city.ts": "2017-08-15 02:34:15", "city.title": "Fayette", "city.city_x_agent_id": { "170": { "city_x_agent.id": 170, "agent.id": 170, "agent.ts": "2017-09-05 05:26:56", "agent.title": "THE TURNER AGENCY INC", "agent.pull_right": "16.78 mi", "agent.phone_number": "(205) 932-5223", "agent.street_address": "202 TEMPLE AVE N", "agent.address_locality": "Fayette, AL 35555-2307" }, "171": { "city_x_agent.id": 171, "agent.id": 171, "agent.ts": "2017-09-05 05:26:56", "agent.title": "James Odum Jr", "agent.pull_right": "0.23 mi", "agent.phone_number": "(205) 487-4545", "agent.street_address": "754 US Highway 43", "agent.address_locality": "Winfield, AL 35594" }, "172": { "city_x_agent.id": 172, "agent.id": 172, "agent.ts": "2017-09-05 05:26:56", "agent.title": "THE TURNER AGENCY INC", "agent.pull_right": "21.07 mi", "agent.phone_number": "(205) 695-9116", "agent.street_address": "121 2ND AVE NE", "agent.address_locality": "Vernon, AL 35592" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "27": { "city.id": 27, "city.ts": "2017-08-15 02:34:15", "city.title": "Florence", "city.city_x_agent_id": { "173": { "city_x_agent.id": 173, "agent.id": 173, "agent.ts": "2017-09-05 05:26:14", "agent.title": "Bill Cochran", "agent.pull_right": "5.06 mi", "agent.phone_number": "(256) 767-4237", "agent.street_address": "115 E Mobile St", "agent.address_locality": "Florence, AL 35630-4760" }, "174": { "city_x_agent.id": 174, "agent.id": 174, "agent.ts": "2017-09-05 05:26:14", "agent.title": "Scott Wyatt Howell", "agent.pull_right": "7.75 mi", "agent.phone_number": "(256) 275-7585", "agent.street_address": "1609 Mockingbird Ct Ste A", "agent.address_locality": "Florence, AL 35630" }, "175": { "city_x_agent.id": 175, "agent.id": 175, "agent.ts": "2017-09-05 05:26:14", "agent.title": "David Hall", "agent.pull_right": "2.38 mi", "agent.phone_number": "(256) 381-8775", "agent.street_address": "709 Avalon Ave", "agent.address_locality": "Muscle Shoals, AL 35661" }, "176": { "city_x_agent.id": 176, "agent.id": 176, "agent.ts": "2017-09-05 05:26:14", "agent.title": "Laura Butler", "agent.pull_right": "2.01 mi", "agent.phone_number": "(256) 314-1280", "agent.street_address": "3203 Woodward Ave", "agent.address_locality": "Muscle Shoals, AL 35661" }, "177": { "city_x_agent.id": 177, "agent.id": 177, "agent.ts": "2017-09-05 05:26:14", "agent.title": "WILLIAM M OWENS HOLDINGS LLC", "agent.pull_right": "0.10 mi", "agent.phone_number": "(256) 383-5451", "agent.street_address": "106 N MAIN ST", "agent.address_locality": "Tuscumbia, AL 35674-2041" }, "178": { "city_x_agent.id": 178, "agent.id": 178, "agent.ts": "2017-09-05 05:26:14", "agent.title": "HENNINGER JOHNSON & LAYTON INS", "agent.pull_right": "0.06 mi", "agent.phone_number": "(256) 383-3400", "agent.street_address": "120 E 5TH ST", "agent.address_locality": "Tuscumbia, AL 35674-2443" }, "179": { "city_x_agent.id": 179, "agent.id": 179, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Michael Noe", "agent.pull_right": "18.15 mi", "agent.phone_number": "(256) 247-3530", "agent.street_address": "16428 Highway 72", "agent.address_locality": "Rogersville, AL 35652" }, "180": { "city_x_agent.id": 180, "agent.id": 180, "agent.ts": "2017-09-05 13:56:34", "agent.title": "SAM NEWTON INS AGENCY INC", "agent.pull_right": "24.62 mi", "agent.phone_number": "(256) 229-6239", "agent.street_address": "11342 HIGHWAY 101", "agent.address_locality": "Lexington, AL 35648-3201" }, "181": { "city_x_agent.id": 181, "agent.id": 181, "agent.ts": "2017-09-05 13:56:34", "agent.title": "SMALL & RURAL SERVICES INC", "agent.pull_right": "24.62 mi", "agent.phone_number": "(256) 229-6239", "agent.street_address": "11342 HIGHWAY 101", "agent.address_locality": "Lexington, AL 35648-3201" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "28": { "city.id": 28, "city.ts": "2017-08-15 02:34:15", "city.title": "Foley", "city.city_x_agent_id": { "182": { "city_x_agent.id": 182, "agent.id": 182, "agent.ts": "2017-09-05 05:20:53", "agent.title": "Ben Castleberry", "agent.pull_right": "1.02 mi", "agent.phone_number": "(251) 943-5216", "agent.street_address": "1402 S McKenzie St", "agent.address_locality": "Foley, AL 36535" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "29": { "city.id": 29, "city.ts": "2017-08-15 02:34:15", "city.title": "Fort Payne", "city.city_x_agent_id": { "184": { "city_x_agent.id": 184, "agent.id": 97, "agent.ts": "2017-09-05 05:25:04", "agent.title": "Cathy Reko", "agent.pull_right": "24.01 mi", "agent.phone_number": "(256) 927-5155", "agent.street_address": "1520 Chesnut Bypass", "agent.address_locality": "Centre, AL 35960-2816" }, "183": { "city_x_agent.id": 183, "agent.id": 99, "agent.ts": "2017-09-05 05:21:03", "agent.title": "Chris Davis", "agent.pull_right": "1.58 mi", "agent.phone_number": "(256) 845-5116", "agent.street_address": "2121 Gault Ave N", "agent.address_locality": "Fort Payne, AL 35967" }, "185": { "city_x_agent.id": 185, "agent.id": 185, "agent.ts": "2017-09-05 05:25:29", "agent.title": "Randy Jones", "agent.pull_right": "3.78 mi", "agent.phone_number": "(256) 259-2545", "agent.street_address": "419 E Laurel St", "agent.address_locality": "Scottsboro, AL 35768-1959" }, "186": { "city_x_agent.id": 186, "agent.id": 186, "agent.ts": "2017-09-05 05:25:29", "agent.title": "GOGGANS FORT PAYNE INC", "agent.pull_right": "5.39 mi", "agent.phone_number": "(256) 574-3440", "agent.street_address": "1905 VETERANS DR", "agent.address_locality": "Scottsboro, AL 35769-3756" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "30": { "city.id": 30, "city.ts": "2017-09-05 22:28:17", "city.title": "Fultondale", "city.city_x_agent_id": { "28568": { "city_x_agent.id": 28568, "agent.id": 6, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Tyler F Watts", "agent.pull_right": "3.11 mi", "agent.phone_number": "(205) 690-5033", "agent.street_address": "160 Yeager Pkwy STE 107", "agent.address_locality": "Pelham, AL 35124" }, "28565": { "city_x_agent.id": 28565, "agent.id": 7, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Scott Richards", "agent.pull_right": "7.39 mi", "agent.phone_number": "(205) 988-4346", "agent.street_address": "2070 Valleydale Rd Ste 4", "agent.address_locality": "Birmingham, AL 35244-2035" }, "28564": { "city_x_agent.id": 28564, "agent.id": 8, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Kenneth R Caldwell", "agent.pull_right": "8.62 mi", "agent.phone_number": "(205) 733-0444", "agent.street_address": "3926 Lorna Rd", "agent.address_locality": "Birmingham, AL 35244-1004" }, "28561": { "city_x_agent.id": 28561, "agent.id": 9, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Roger L Watts", "agent.pull_right": "9.05 mi", "agent.phone_number": "(205) 988-8899", "agent.street_address": "3659 Lorna Rd Ste 109", "agent.address_locality": "Hoover, AL 35216-5958" }, "28563": { "city_x_agent.id": 28563, "agent.id": 10, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Wade K. Kaiser", "agent.pull_right": "9.55 mi", "agent.phone_number": "(205) 291-4100", "agent.street_address": "2473 Valleydale Rd Ste A", "agent.address_locality": "Birmingham, AL 35244" }, "28585": { "city_x_agent.id": 28585, "agent.id": 12, "agent.ts": "2017-09-05 21:43:23", "agent.title": "COMPLETE INSURANCE COVERAGE", "agent.pull_right": "7.28 mi", "agent.phone_number": "(205) 774-1754", "agent.street_address": "137 BUSINESS CENTER DR", "agent.address_locality": "Birmingham, AL 35244-2022" }, "28582": { "city_x_agent.id": 28582, "agent.id": 13, "agent.ts": "2017-09-05 21:43:23", "agent.title": "TRAMMEL-HARPER & WILLIAMS INC", "agent.pull_right": "7.55 mi", "agent.phone_number": "(205) 988-3444", "agent.street_address": "2073 VALLEYDALE RD", "agent.address_locality": "Hoover, AL 35244-2007" }, "28583": { "city_x_agent.id": 28583, "agent.id": 14, "agent.ts": "2017-09-05 22:14:16", "agent.title": "MIKOS KAMPAKIS INS SRVCS INC", "agent.pull_right": "7.25 mi", "agent.phone_number": "(205) 822-7413", "agent.street_address": "421 EMERY DR STE 100", "agent.address_locality": "Hoover, AL 35244-4567" }, "28566": { "city_x_agent.id": 28566, "agent.id": 66, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Calvin E Lewter", "agent.pull_right": "1.23 mi", "agent.phone_number": "(205) 426-4441", "agent.street_address": "417 4th Ave N", "agent.address_locality": "Bessemer, AL 35020-6230" }, "28557": { "city_x_agent.id": 28557, "agent.id": 68, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Ashley Bruette", "agent.pull_right": "8.66 mi", "agent.phone_number": "(205) 979-4331", "agent.street_address": "3021 Lorna Rd Ste 111", "agent.address_locality": "Birmingham, AL 35216" }, "28551": { "city_x_agent.id": 28551, "agent.id": 69, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Patricia H Donalson", "agent.pull_right": "9.02 mi", "agent.phone_number": "(205) 942-7543", "agent.street_address": "1729 S Lakeshore Dr", "agent.address_locality": "Birmingham, AL 35216-1621" }, "28578": { "city_x_agent.id": 28578, "agent.id": 71, "agent.ts": "2017-09-05 22:14:16", "agent.title": "ELIM INSURANCE AGENCY, LLC", "agent.pull_right": "6.49 mi", "agent.phone_number": "(205) 979-9994", "agent.street_address": "2170 CLEARBROOK RD STE 105", "agent.address_locality": "Hoover, AL 35226-1573" }, "28584": { "city_x_agent.id": 28584, "agent.id": 73, "agent.ts": "2017-09-05 22:14:16", "agent.title": "MIKOS KAMPAKIS INSURANCE", "agent.pull_right": "7.25 mi", "agent.phone_number": "(205) 822-7413", "agent.street_address": "421 EMERY DR STE 100", "agent.address_locality": "Hoover, AL 35244-4567" }, "28577": { "city_x_agent.id": 28577, "agent.id": 74, "agent.ts": "2017-09-05 22:14:16", "agent.title": "KAMPAKIS INSURANCE SERVICES INC", "agent.pull_right": "8.38 mi", "agent.phone_number": "(205) 847-5355", "agent.street_address": "100 CENTURY PARK S STE 200", "agent.address_locality": "Birmingham, AL 35226-3922" }, "28580": { "city_x_agent.id": 28580, "agent.id": 75, "agent.ts": "2017-09-05 22:14:16", "agent.title": "NSUREHUB LLC", "agent.pull_right": "8.65 mi", "agent.phone_number": "(205) 377-7977", "agent.street_address": "3021 LORNA RD STE 301", "agent.address_locality": "Hoover, AL 35216-4500" }, "28552": { "city_x_agent.id": 28552, "agent.id": 77, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Tyler F Watts", "agent.pull_right": "14.04 mi", "agent.phone_number": "(205) 822-5477", "agent.street_address": "2015 Kentucky Ave", "agent.address_locality": "Birmingham, AL 35216" }, "189": { "city_x_agent.id": 189, "agent.id": 78, "agent.ts": "2017-09-05 21:44:56", "agent.title": "David Hayes", "agent.pull_right": "22.15 mi", "agent.phone_number": "(205) 798-4238", "agent.street_address": "221 Lapala Dr", "agent.address_locality": "Birmingham, AL 35214-3839" }, "187": { "city_x_agent.id": 187, "agent.id": 80, "agent.ts": "2017-09-05 05:24:52", "agent.title": "David Hayes", "agent.pull_right": "8.80 mi", "agent.phone_number": "(205) 386-4455", "agent.street_address": "1351 Decatur Hwy Ste 119", "agent.address_locality": "Fultondale, AL 35068" }, "28553": { "city_x_agent.id": 28553, "agent.id": 81, "agent.ts": "2017-09-05 21:44:56", "agent.title": "Brian Lambert", "agent.pull_right": "15.30 mi", "agent.phone_number": "(205) 871-9101", "agent.street_address": "3232 Cahaba Heights Rd", "agent.address_locality": "Birmingham, AL 35243-1614" }, "28556": { "city_x_agent.id": 28556, "agent.id": 83, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Russ Richardson", "agent.pull_right": "13.59 mi", "agent.phone_number": "(205) 991-7802", "agent.street_address": "4908 Cahaba River Rd Ste 108", "agent.address_locality": "Birmingham, AL 35243" }, "28558": { "city_x_agent.id": 28558, "agent.id": 84, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Max P Blalock Jr", "agent.pull_right": "13.54 mi", "agent.phone_number": "(205) 981-2424", "agent.street_address": "244 Inverness Center Dr Unit 102", "agent.address_locality": "Birmingham, AL 35242" }, "28567": { "city_x_agent.id": 28567, "agent.id": 103, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Rod Burchell", "agent.pull_right": "13.37 mi", "agent.phone_number": "(205) 678-0800", "agent.street_address": "16233 Highway 280 Ste E", "agent.address_locality": "Chelsea, AL 35043" }, "28559": { "city_x_agent.id": 28559, "agent.id": 104, "agent.ts": "2017-09-05 21:44:56", "agent.title": "Roger L Watts", "agent.pull_right": "14.25 mi", "agent.phone_number": "(205) 991-2636", "agent.street_address": "4000 Meadow Lake Dr Ste 119", "agent.address_locality": "Birmingham, AL 35242-5427" }, "28562": { "city_x_agent.id": 28562, "agent.id": 106, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Robert Langston", "agent.pull_right": "10.69 mi", "agent.phone_number": "(205) 991-2484", "agent.street_address": "4525 Valleydale Rd", "agent.address_locality": "Birmingham, AL 35242-4605" }, "28581": { "city_x_agent.id": 28581, "agent.id": 111, "agent.ts": "2017-09-05 21:44:58", "agent.title": "COLLECTIVE UNDERWRITERS INC", "agent.pull_right": "13.98 mi", "agent.phone_number": "(205) 776-1680", "agent.street_address": "800 CORPORATE PKWY STE 108", "agent.address_locality": "Birmingham, AL 35242-5470" }, "28579": { "city_x_agent.id": 28579, "agent.id": 112, "agent.ts": "2017-09-05 21:44:57", "agent.title": "J SMITH LANIER & COMPANY", "agent.pull_right": "13.89 mi", "agent.phone_number": "(770) 683-1000", "agent.street_address": "10 INVERNESS CENTER PKWY STE 400", "agent.address_locality": "Birmingham, AL 35242-4818" }, "28560": { "city_x_agent.id": 28560, "agent.id": 118, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Brian Lambert", "agent.pull_right": "6.29 mi", "agent.phone_number": "(205) 699-6554", "agent.street_address": "8349 1st Ave Ste 110", "agent.address_locality": "Leeds, AL 35094" }, "188": { "city_x_agent.id": 188, "agent.id": 188, "agent.ts": "2017-09-05 05:24:52", "agent.title": "Jonathan Nix", "agent.pull_right": "7.78 mi", "agent.phone_number": "(205) 631-4700", "agent.street_address": "1603 Decatur Hwy", "agent.address_locality": "Gardendale, AL 35071" }, "191": { "city_x_agent.id": 191, "agent.id": 191, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Sidney K Brooks", "agent.pull_right": "4.70 mi", "agent.phone_number": "(205) 856-3563", "agent.street_address": "1275 Center Point Pkwy Ste 200", "agent.address_locality": "Birmingham, AL 35215-6339" }, "192": { "city_x_agent.id": 192, "agent.id": 192, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Leo Blankenship", "agent.pull_right": "4.79 mi", "agent.phone_number": "(205) 854-1606", "agent.street_address": "2025 Center Point Pkwy", "agent.address_locality": "Birmingham, AL 35215-4619" }, "193": { "city_x_agent.id": 193, "agent.id": 193, "agent.ts": "2017-09-05 05:26:03", "agent.title": "David Hayes", "agent.pull_right": "3.43 mi", "agent.phone_number": "(205) 874-6546", "agent.street_address": "5290 Old Springville Rd Ste B", "agent.address_locality": "Pinson, AL 35126" }, "194": { "city_x_agent.id": 194, "agent.id": 194, "agent.ts": "2017-09-05 21:45:10", "agent.title": "WILLIS OF ALABAMA INC", "agent.pull_right": "18.99 mi", "agent.phone_number": "(205) 871-3871", "agent.street_address": "2101 6TH AVE N STE 1200", "agent.address_locality": "Birmingham, AL 35203-2775" }, "195": { "city_x_agent.id": 195, "agent.id": 195, "agent.ts": "2017-09-05 21:45:10", "agent.title": "POINT CLEAR INSURANCE PARTNERS LLC", "agent.pull_right": "18.40 mi", "agent.phone_number": "(205) 871-3894", "agent.street_address": "3918 MONTCLAIR RD STE 208", "agent.address_locality": "Mountain Brk, AL 35213-2418" }, "196": { "city_x_agent.id": 196, "agent.id": 196, "agent.ts": "2017-09-05 21:44:58", "agent.title": "J R PREWITT & ASSOCIATES INC", "agent.pull_right": "17.69 mi", "agent.phone_number": "(205) 397-5118", "agent.street_address": "2146 HIGHLAND AVE S", "agent.address_locality": "Birmingham, AL 35205-4002" }, "28554": { "city_x_agent.id": 28554, "agent.id": 214, "agent.ts": "2017-09-05 05:26:03", "agent.title": "David J. Rosetta", "agent.pull_right": "4.79 mi", "agent.phone_number": "(205) 680-4349", "agent.street_address": "6401 Old Springville Rd Ste 117", "agent.address_locality": "Pinson, AL 35126" }, "28550": { "city_x_agent.id": 28550, "agent.id": 215, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Stanley Q Wormely", "agent.pull_right": "0.49 mi", "agent.phone_number": "(205) 836-4466", "agent.street_address": "235 Main St Ste 103", "agent.address_locality": "Trussville, AL 35173" }, "28555": { "city_x_agent.id": 28555, "agent.id": 281, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Jay R Grogan", "agent.pull_right": "1.37 mi", "agent.phone_number": "(205) 661-9393", "agent.street_address": "7018 Gadsden Hwy Ste 120", "agent.address_locality": "Trussville, AL 35173-2670" }, "28571": { "city_x_agent.id": 28571, "agent.id": 284, "agent.ts": "2017-09-05 05:26:03", "agent.title": "BEST INSURANCE AGENCY LLC", "agent.pull_right": "0.39 mi", "agent.phone_number": "(205) 655-2128", "agent.street_address": "122 N CHALKVILLE RD", "agent.address_locality": "Trussville, AL 35173-1381" }, "28569": { "city_x_agent.id": 28569, "agent.id": 285, "agent.ts": "2017-09-05 05:26:03", "agent.title": "GURLEY COOKE AGENCY INC", "agent.pull_right": "1.25 mi", "agent.phone_number": "(205) 841-4444", "agent.street_address": "285 CALUMET PARKWAY STE B", "agent.address_locality": "Trussville, AL 35173" }, "28548": { "city_x_agent.id": 28548, "agent.id": 286, "agent.ts": "2017-09-05 21:45:10", "agent.title": "PETRA R M S LLC", "agent.pull_right": "19.18 mi", "agent.phone_number": "(205) 354-2700", "agent.street_address": "4855 OVERTON RD", "agent.address_locality": "Birmingham, AL 35210-3806" }, "28576": { "city_x_agent.id": 28576, "agent.id": 27399, "agent.ts": "2017-09-05 21:44:56", "agent.title": "JUDY CARTER AND ASSOCIATES", "agent.pull_right": "12.15 mi", "agent.phone_number": "(888) 795-1221", "agent.street_address": "300 VESTAVIA PKWY STE 3450", "agent.address_locality": "Vestavia, AL 35216-3776" }, "28574": { "city_x_agent.id": 28574, "agent.id": 27403, "agent.ts": "2017-09-05 21:44:58", "agent.title": "S S NESBITT & CO INC", "agent.pull_right": "14.81 mi", "agent.phone_number": "(205) 262-2625", "agent.street_address": "3500 BLUE LAKE DR STE 120", "agent.address_locality": "Vestavia, AL 35243-1909" }, "28575": { "city_x_agent.id": 28575, "agent.id": 27404, "agent.ts": "2017-09-05 21:44:58", "agent.title": "SS NESBITT & CO INC", "agent.pull_right": "14.81 mi", "agent.phone_number": "(205) 262-2700", "agent.street_address": "3500 BLUE LAKE DR STE 120", "agent.address_locality": "Vestavia, AL 35243-1909" }, "28572": { "city_x_agent.id": 28572, "agent.id": 27405, "agent.ts": "2017-09-05 21:44:58", "agent.title": "GREENHALGH INS AGENCY INC", "agent.pull_right": "15.25 mi", "agent.phone_number": "(205) 967-8800", "agent.street_address": "3144 CAHABA HEIGHTS RD", "agent.address_locality": "Vestavia, AL 35243-5243" }, "28573": { "city_x_agent.id": 28573, "agent.id": 27406, "agent.ts": "2017-09-05 21:44:58", "agent.title": "GREENHALGH INSURANCE AGENCY INC", "agent.pull_right": "15.25 mi", "agent.phone_number": "(205) 967-8800", "agent.street_address": "3144 CAHABA HEIGHTS RD", "agent.address_locality": "Vestavia, AL 35243-5243" }, "28549": { "city_x_agent.id": 28549, "agent.id": 27407, "agent.ts": "2017-09-05 21:44:58", "agent.title": "CRC INSURANCE SERVICES INC", "agent.pull_right": "15.55 mi", "agent.phone_number": "(312) 899-1480", "agent.street_address": "1 METROPLEX DR STE 400", "agent.address_locality": "Birmingham, AL 35209-6895" }, "28570": { "city_x_agent.id": 28570, "agent.id": 27408, "agent.ts": "2017-09-05 21:44:58", "agent.title": "DBAPETRA RMS WRIGHT SPRAYBERRY CLAY", "agent.pull_right": "16.04 mi", "agent.phone_number": "", "agent.street_address": "3794 VILLAGE LN", "agent.address_locality": "Mountain Brk, AL 35223-2700" }, "28547": { "city_x_agent.id": 28547, "agent.id": 27409, "agent.ts": "2017-09-05 21:44:58", "agent.title": "COBBS ALLEN & HALL INC", "agent.pull_right": "16.28 mi", "agent.phone_number": "(205) 414-8100", "agent.street_address": "115 OFFICE PARK DR", "agent.address_locality": "Mountain Brk, AL 35223-2421" }, "28546": { "city_x_agent.id": 28546, "agent.id": 27410, "agent.ts": "2017-09-05 21:44:58", "agent.title": "ARTHUR J GALLAGHER RISK MGMT", "agent.pull_right": "17.05 mi", "agent.phone_number": "(205) 414-7049", "agent.street_address": "2200 WOODCREST PL STE 250", "agent.address_locality": "Birmingham, AL 35209-1396" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "31": { "city.id": 31, "city.ts": "2017-08-15 02:34:15", "city.title": "Gadsden", "city.city_x_agent_id": { "203": { "city_x_agent.id": 203, "agent.id": 15, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "15.57 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US Highway 431 N", "agent.address_locality": "Albertville, AL 35950-0153" }, "201": { "city_x_agent.id": 201, "agent.id": 16, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Tony G King", "agent.pull_right": "20.62 mi", "agent.phone_number": "(256) 593-0221", "agent.street_address": "10000 Al Highway 168", "agent.address_locality": "Boaz, AL 35957-1886" }, "205": { "city_x_agent.id": 205, "agent.id": 17, "agent.ts": "2017-09-05 22:10:04", "agent.title": "RANDY JONES & ASSOCIATES INC", "agent.pull_right": "15.58 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US HIGHWAY 431", "agent.address_locality": "Albertville, AL 35950-0153" }, "204": { "city_x_agent.id": 204, "agent.id": 18, "agent.ts": "2017-09-05 22:10:04", "agent.title": "FIRST CAPITAL INS AGENCY INC", "agent.pull_right": "21.94 mi", "agent.phone_number": "(256) 593-4251", "agent.street_address": "167 US HIGHWAY 431", "agent.address_locality": "Boaz, AL 35957-6644" }, "197": { "city_x_agent.id": 197, "agent.id": 19, "agent.ts": "2017-09-05 05:25:04", "agent.title": "Randy Jones", "agent.pull_right": "4.39 mi", "agent.phone_number": "(256) 543-9594", "agent.street_address": "301 South Fifth Street", "agent.address_locality": "Gadsden, AL 35901-4223" }, "198": { "city_x_agent.id": 198, "agent.id": 20, "agent.ts": "2017-09-05 05:25:03", "agent.title": "Frank Amos", "agent.pull_right": "0.12 mi", "agent.phone_number": "(256) 442-4754", "agent.street_address": "118 Church St Ste 4", "agent.address_locality": "Rainbow City, AL 35906-6265" }, "199": { "city_x_agent.id": 199, "agent.id": 22, "agent.ts": "2017-09-05 05:25:04", "agent.title": "SHANNON BANKS & SMITH INC", "agent.pull_right": "4.50 mi", "agent.phone_number": "(256) 543-1424", "agent.street_address": "200 CHESTNUT ST STE B", "agent.address_locality": "Gadsden, AL 35901-4235" }, "200": { "city_x_agent.id": 200, "agent.id": 23, "agent.ts": "2017-09-05 05:25:04", "agent.title": "SHANNON, BANKS & SMITH INC", "agent.pull_right": "4.50 mi", "agent.phone_number": "(256) 543-1424", "agent.street_address": "200 CHESTNUT ST STE B", "agent.address_locality": "Gadsden, AL 35901-4235" }, "202": { "city_x_agent.id": 202, "agent.id": 97, "agent.ts": "2017-09-05 05:25:04", "agent.title": "Cathy Reko", "agent.pull_right": "24.01 mi", "agent.phone_number": "(256) 927-5155", "agent.street_address": "1520 Chesnut Bypass", "agent.address_locality": "Centre, AL 35960-2816" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "32": { "city.id": 32, "city.ts": "2017-09-05 22:28:47", "city.title": "Gardendale", "city.city_x_agent_id": { "28612": { "city_x_agent.id": 28612, "agent.id": 6, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Tyler F Watts", "agent.pull_right": "3.11 mi", "agent.phone_number": "(205) 690-5033", "agent.street_address": "160 Yeager Pkwy STE 107", "agent.address_locality": "Pelham, AL 35124" }, "28610": { "city_x_agent.id": 28610, "agent.id": 7, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Scott Richards", "agent.pull_right": "7.39 mi", "agent.phone_number": "(205) 988-4346", "agent.street_address": "2070 Valleydale Rd Ste 4", "agent.address_locality": "Birmingham, AL 35244-2035" }, "28608": { "city_x_agent.id": 28608, "agent.id": 8, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Kenneth R Caldwell", "agent.pull_right": "8.62 mi", "agent.phone_number": "(205) 733-0444", "agent.street_address": "3926 Lorna Rd", "agent.address_locality": "Birmingham, AL 35244-1004" }, "28605": { "city_x_agent.id": 28605, "agent.id": 9, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Roger L Watts", "agent.pull_right": "9.05 mi", "agent.phone_number": "(205) 988-8899", "agent.street_address": "3659 Lorna Rd Ste 109", "agent.address_locality": "Hoover, AL 35216-5958" }, "28607": { "city_x_agent.id": 28607, "agent.id": 10, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Wade K. Kaiser", "agent.pull_right": "9.55 mi", "agent.phone_number": "(205) 291-4100", "agent.street_address": "2473 Valleydale Rd Ste A", "agent.address_locality": "Birmingham, AL 35244" }, "28635": { "city_x_agent.id": 28635, "agent.id": 12, "agent.ts": "2017-09-05 21:43:23", "agent.title": "COMPLETE INSURANCE COVERAGE", "agent.pull_right": "7.28 mi", "agent.phone_number": "(205) 774-1754", "agent.street_address": "137 BUSINESS CENTER DR", "agent.address_locality": "Birmingham, AL 35244-2022" }, "28634": { "city_x_agent.id": 28634, "agent.id": 13, "agent.ts": "2017-09-05 21:43:23", "agent.title": "TRAMMEL-HARPER & WILLIAMS INC", "agent.pull_right": "7.55 mi", "agent.phone_number": "(205) 988-3444", "agent.street_address": "2073 VALLEYDALE RD", "agent.address_locality": "Hoover, AL 35244-2007" }, "28632": { "city_x_agent.id": 28632, "agent.id": 14, "agent.ts": "2017-09-05 22:14:16", "agent.title": "MIKOS KAMPAKIS INS SRVCS INC", "agent.pull_right": "7.25 mi", "agent.phone_number": "(205) 822-7413", "agent.street_address": "421 EMERY DR STE 100", "agent.address_locality": "Hoover, AL 35244-4567" }, "28609": { "city_x_agent.id": 28609, "agent.id": 66, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Calvin E Lewter", "agent.pull_right": "1.23 mi", "agent.phone_number": "(205) 426-4441", "agent.street_address": "417 4th Ave N", "agent.address_locality": "Bessemer, AL 35020-6230" }, "28601": { "city_x_agent.id": 28601, "agent.id": 68, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Ashley Bruette", "agent.pull_right": "8.66 mi", "agent.phone_number": "(205) 979-4331", "agent.street_address": "3021 Lorna Rd Ste 111", "agent.address_locality": "Birmingham, AL 35216" }, "28597": { "city_x_agent.id": 28597, "agent.id": 69, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Patricia H Donalson", "agent.pull_right": "9.02 mi", "agent.phone_number": "(205) 942-7543", "agent.street_address": "1729 S Lakeshore Dr", "agent.address_locality": "Birmingham, AL 35216-1621" }, "28628": { "city_x_agent.id": 28628, "agent.id": 71, "agent.ts": "2017-09-05 22:14:16", "agent.title": "ELIM INSURANCE AGENCY, LLC", "agent.pull_right": "6.49 mi", "agent.phone_number": "(205) 979-9994", "agent.street_address": "2170 CLEARBROOK RD STE 105", "agent.address_locality": "Hoover, AL 35226-1573" }, "28633": { "city_x_agent.id": 28633, "agent.id": 73, "agent.ts": "2017-09-05 22:14:16", "agent.title": "MIKOS KAMPAKIS INSURANCE", "agent.pull_right": "7.25 mi", "agent.phone_number": "(205) 822-7413", "agent.street_address": "421 EMERY DR STE 100", "agent.address_locality": "Hoover, AL 35244-4567" }, "28627": { "city_x_agent.id": 28627, "agent.id": 74, "agent.ts": "2017-09-05 22:14:16", "agent.title": "KAMPAKIS INSURANCE SERVICES INC", "agent.pull_right": "8.38 mi", "agent.phone_number": "(205) 847-5355", "agent.street_address": "100 CENTURY PARK S STE 200", "agent.address_locality": "Birmingham, AL 35226-3922" }, "28630": { "city_x_agent.id": 28630, "agent.id": 75, "agent.ts": "2017-09-05 22:14:16", "agent.title": "NSUREHUB LLC", "agent.pull_right": "8.65 mi", "agent.phone_number": "(205) 377-7977", "agent.street_address": "3021 LORNA RD STE 301", "agent.address_locality": "Hoover, AL 35216-4500" }, "28598": { "city_x_agent.id": 28598, "agent.id": 77, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Tyler F Watts", "agent.pull_right": "14.04 mi", "agent.phone_number": "(205) 822-5477", "agent.street_address": "2015 Kentucky Ave", "agent.address_locality": "Birmingham, AL 35216" }, "210": { "city_x_agent.id": 210, "agent.id": 78, "agent.ts": "2017-09-05 21:44:56", "agent.title": "David Hayes", "agent.pull_right": "22.15 mi", "agent.phone_number": "(205) 798-4238", "agent.street_address": "221 Lapala Dr", "agent.address_locality": "Birmingham, AL 35214-3839" }, "207": { "city_x_agent.id": 207, "agent.id": 80, "agent.ts": "2017-09-05 05:24:52", "agent.title": "David Hayes", "agent.pull_right": "8.80 mi", "agent.phone_number": "(205) 386-4455", "agent.street_address": "1351 Decatur Hwy Ste 119", "agent.address_locality": "Fultondale, AL 35068" }, "28599": { "city_x_agent.id": 28599, "agent.id": 81, "agent.ts": "2017-09-05 21:44:56", "agent.title": "Brian Lambert", "agent.pull_right": "15.30 mi", "agent.phone_number": "(205) 871-9101", "agent.street_address": "3232 Cahaba Heights Rd", "agent.address_locality": "Birmingham, AL 35243-1614" }, "28600": { "city_x_agent.id": 28600, "agent.id": 83, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Russ Richardson", "agent.pull_right": "13.59 mi", "agent.phone_number": "(205) 991-7802", "agent.street_address": "4908 Cahaba River Rd Ste 108", "agent.address_locality": "Birmingham, AL 35243" }, "28603": { "city_x_agent.id": 28603, "agent.id": 84, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Max P Blalock Jr", "agent.pull_right": "13.54 mi", "agent.phone_number": "(205) 981-2424", "agent.street_address": "244 Inverness Center Dr Unit 102", "agent.address_locality": "Birmingham, AL 35242" }, "28611": { "city_x_agent.id": 28611, "agent.id": 103, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Rod Burchell", "agent.pull_right": "13.37 mi", "agent.phone_number": "(205) 678-0800", "agent.street_address": "16233 Highway 280 Ste E", "agent.address_locality": "Chelsea, AL 35043" }, "28604": { "city_x_agent.id": 28604, "agent.id": 104, "agent.ts": "2017-09-05 21:44:56", "agent.title": "Roger L Watts", "agent.pull_right": "14.25 mi", "agent.phone_number": "(205) 991-2636", "agent.street_address": "4000 Meadow Lake Dr Ste 119", "agent.address_locality": "Birmingham, AL 35242-5427" }, "28606": { "city_x_agent.id": 28606, "agent.id": 106, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Robert Langston", "agent.pull_right": "10.69 mi", "agent.phone_number": "(205) 991-2484", "agent.street_address": "4525 Valleydale Rd", "agent.address_locality": "Birmingham, AL 35242-4605" }, "28631": { "city_x_agent.id": 28631, "agent.id": 111, "agent.ts": "2017-09-05 21:44:58", "agent.title": "COLLECTIVE UNDERWRITERS INC", "agent.pull_right": "13.98 mi", "agent.phone_number": "(205) 776-1680", "agent.street_address": "800 CORPORATE PKWY STE 108", "agent.address_locality": "Birmingham, AL 35242-5470" }, "28629": { "city_x_agent.id": 28629, "agent.id": 112, "agent.ts": "2017-09-05 21:44:57", "agent.title": "J SMITH LANIER & COMPANY", "agent.pull_right": "13.89 mi", "agent.phone_number": "(770) 683-1000", "agent.street_address": "10 INVERNESS CENTER PKWY STE 400", "agent.address_locality": "Birmingham, AL 35242-4818" }, "28602": { "city_x_agent.id": 28602, "agent.id": 118, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Brian Lambert", "agent.pull_right": "6.29 mi", "agent.phone_number": "(205) 699-6554", "agent.street_address": "8349 1st Ave Ste 110", "agent.address_locality": "Leeds, AL 35094" }, "206": { "city_x_agent.id": 206, "agent.id": 188, "agent.ts": "2017-09-05 05:24:52", "agent.title": "Jonathan Nix", "agent.pull_right": "7.78 mi", "agent.phone_number": "(205) 631-4700", "agent.street_address": "1603 Decatur Hwy", "agent.address_locality": "Gardendale, AL 35071" }, "209": { "city_x_agent.id": 209, "agent.id": 191, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Sidney K Brooks", "agent.pull_right": "4.70 mi", "agent.phone_number": "(205) 856-3563", "agent.street_address": "1275 Center Point Pkwy Ste 200", "agent.address_locality": "Birmingham, AL 35215-6339" }, "208": { "city_x_agent.id": 208, "agent.id": 192, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Leo Blankenship", "agent.pull_right": "4.79 mi", "agent.phone_number": "(205) 854-1606", "agent.street_address": "2025 Center Point Pkwy", "agent.address_locality": "Birmingham, AL 35215-4619" }, "212": { "city_x_agent.id": 212, "agent.id": 193, "agent.ts": "2017-09-05 05:26:03", "agent.title": "David Hayes", "agent.pull_right": "3.43 mi", "agent.phone_number": "(205) 874-6546", "agent.street_address": "5290 Old Springville Rd Ste B", "agent.address_locality": "Pinson, AL 35126" }, "213": { "city_x_agent.id": 213, "agent.id": 194, "agent.ts": "2017-09-05 21:45:10", "agent.title": "WILLIS OF ALABAMA INC", "agent.pull_right": "18.99 mi", "agent.phone_number": "(205) 871-3871", "agent.street_address": "2101 6TH AVE N STE 1200", "agent.address_locality": "Birmingham, AL 35203-2775" }, "28613": { "city_x_agent.id": 28613, "agent.id": 195, "agent.ts": "2017-09-05 21:45:10", "agent.title": "POINT CLEAR INSURANCE PARTNERS LLC", "agent.pull_right": "18.40 mi", "agent.phone_number": "(205) 871-3894", "agent.street_address": "3918 MONTCLAIR RD STE 208", "agent.address_locality": "Mountain Brk, AL 35213-2418" }, "28614": { "city_x_agent.id": 28614, "agent.id": 196, "agent.ts": "2017-09-05 21:44:58", "agent.title": "J R PREWITT & ASSOCIATES INC", "agent.pull_right": "17.69 mi", "agent.phone_number": "(205) 397-5118", "agent.street_address": "2146 HIGHLAND AVE S", "agent.address_locality": "Birmingham, AL 35205-4002" }, "214": { "city_x_agent.id": 214, "agent.id": 214, "agent.ts": "2017-09-05 05:26:03", "agent.title": "David J. Rosetta", "agent.pull_right": "4.79 mi", "agent.phone_number": "(205) 680-4349", "agent.street_address": "6401 Old Springville Rd Ste 117", "agent.address_locality": "Pinson, AL 35126" }, "215": { "city_x_agent.id": 215, "agent.id": 215, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Stanley Q Wormely", "agent.pull_right": "0.49 mi", "agent.phone_number": "(205) 836-4466", "agent.street_address": "235 Main St Ste 103", "agent.address_locality": "Trussville, AL 35173" }, "28596": { "city_x_agent.id": 28596, "agent.id": 281, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Jay R Grogan", "agent.pull_right": "1.37 mi", "agent.phone_number": "(205) 661-9393", "agent.street_address": "7018 Gadsden Hwy Ste 120", "agent.address_locality": "Trussville, AL 35173-2670" }, "28617": { "city_x_agent.id": 28617, "agent.id": 284, "agent.ts": "2017-09-05 05:26:03", "agent.title": "BEST INSURANCE AGENCY LLC", "agent.pull_right": "0.39 mi", "agent.phone_number": "(205) 655-2128", "agent.street_address": "122 N CHALKVILLE RD", "agent.address_locality": "Trussville, AL 35173-1381" }, "28615": { "city_x_agent.id": 28615, "agent.id": 285, "agent.ts": "2017-09-05 05:26:03", "agent.title": "GURLEY COOKE AGENCY INC", "agent.pull_right": "1.25 mi", "agent.phone_number": "(205) 841-4444", "agent.street_address": "285 CALUMET PARKWAY STE B", "agent.address_locality": "Trussville, AL 35173" }, "28619": { "city_x_agent.id": 28619, "agent.id": 286, "agent.ts": "2017-09-05 21:45:10", "agent.title": "PETRA R M S LLC", "agent.pull_right": "19.18 mi", "agent.phone_number": "(205) 354-2700", "agent.street_address": "4855 OVERTON RD", "agent.address_locality": "Birmingham, AL 35210-3806" }, "28626": { "city_x_agent.id": 28626, "agent.id": 27399, "agent.ts": "2017-09-05 21:44:56", "agent.title": "JUDY CARTER AND ASSOCIATES", "agent.pull_right": "12.15 mi", "agent.phone_number": "(888) 795-1221", "agent.street_address": "300 VESTAVIA PKWY STE 3450", "agent.address_locality": "Vestavia, AL 35216-3776" }, "28624": { "city_x_agent.id": 28624, "agent.id": 27403, "agent.ts": "2017-09-05 21:44:58", "agent.title": "S S NESBITT & CO INC", "agent.pull_right": "14.81 mi", "agent.phone_number": "(205) 262-2625", "agent.street_address": "3500 BLUE LAKE DR STE 120", "agent.address_locality": "Vestavia, AL 35243-1909" }, "28625": { "city_x_agent.id": 28625, "agent.id": 27404, "agent.ts": "2017-09-05 21:44:58", "agent.title": "SS NESBITT & CO INC", "agent.pull_right": "14.81 mi", "agent.phone_number": "(205) 262-2700", "agent.street_address": "3500 BLUE LAKE DR STE 120", "agent.address_locality": "Vestavia, AL 35243-1909" }, "28622": { "city_x_agent.id": 28622, "agent.id": 27405, "agent.ts": "2017-09-05 21:44:58", "agent.title": "GREENHALGH INS AGENCY INC", "agent.pull_right": "15.25 mi", "agent.phone_number": "(205) 967-8800", "agent.street_address": "3144 CAHABA HEIGHTS RD", "agent.address_locality": "Vestavia, AL 35243-5243" }, "28623": { "city_x_agent.id": 28623, "agent.id": 27406, "agent.ts": "2017-09-05 21:44:58", "agent.title": "GREENHALGH INSURANCE AGENCY INC", "agent.pull_right": "15.25 mi", "agent.phone_number": "(205) 967-8800", "agent.street_address": "3144 CAHABA HEIGHTS RD", "agent.address_locality": "Vestavia, AL 35243-5243" }, "28620": { "city_x_agent.id": 28620, "agent.id": 27407, "agent.ts": "2017-09-05 21:44:58", "agent.title": "CRC INSURANCE SERVICES INC", "agent.pull_right": "15.55 mi", "agent.phone_number": "(312) 899-1480", "agent.street_address": "1 METROPLEX DR STE 400", "agent.address_locality": "Birmingham, AL 35209-6895" }, "28621": { "city_x_agent.id": 28621, "agent.id": 27408, "agent.ts": "2017-09-05 21:44:58", "agent.title": "DBAPETRA RMS WRIGHT SPRAYBERRY CLAY", "agent.pull_right": "16.04 mi", "agent.phone_number": "", "agent.street_address": "3794 VILLAGE LN", "agent.address_locality": "Mountain Brk, AL 35223-2700" }, "28618": { "city_x_agent.id": 28618, "agent.id": 27409, "agent.ts": "2017-09-05 21:44:58", "agent.title": "COBBS ALLEN & HALL INC", "agent.pull_right": "16.28 mi", "agent.phone_number": "(205) 414-8100", "agent.street_address": "115 OFFICE PARK DR", "agent.address_locality": "Mountain Brk, AL 35223-2421" }, "28616": { "city_x_agent.id": 28616, "agent.id": 27410, "agent.ts": "2017-09-05 21:44:58", "agent.title": "ARTHUR J GALLAGHER RISK MGMT", "agent.pull_right": "17.05 mi", "agent.phone_number": "(205) 414-7049", "agent.street_address": "2200 WOODCREST PL STE 250", "agent.address_locality": "Birmingham, AL 35209-1396" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "33": { "city.id": 33, "city.ts": "2017-08-15 02:34:15", "city.title": "Greenville", "city.city_x_agent_id": { "216": { "city_x_agent.id": 216, "agent.id": 216, "agent.ts": "2017-09-05 05:23:06", "agent.title": "Sandra Dockery", "agent.pull_right": "22.32 mi", "agent.phone_number": "(334) 382-3700", "agent.street_address": "509 E Commerce St Ste 2", "agent.address_locality": "Greenville, AL 36037" }, "217": { "city_x_agent.id": 217, "agent.id": 217, "agent.ts": "2017-09-05 05:23:06", "agent.title": "Randy Jones", "agent.pull_right": "23.69 mi", "agent.phone_number": "(800) 648-6584", "agent.street_address": "180 Greenville By Pass", "agent.address_locality": "Greenville, AL 36037-3723" }, "218": { "city_x_agent.id": 218, "agent.id": 218, "agent.ts": "2017-09-05 05:23:06", "agent.title": "NORMAN EDWARDS & WILKES LLC", "agent.pull_right": "22.36 mi", "agent.phone_number": "(334) 382-0880", "agent.street_address": "415 E COMMERCE ST", "agent.address_locality": "Greenville, AL 36037-2328" }, "219": { "city_x_agent.id": 219, "agent.id": 219, "agent.ts": "2017-09-05 05:25:57", "agent.title": "John J Kilgro Jr", "agent.pull_right": "18.36 mi", "agent.phone_number": "(334) 335-2277", "agent.street_address": "110 S Forest Ave", "agent.address_locality": "Luverne, AL 36049" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "34": { "city.id": 34, "city.ts": "2017-08-15 02:34:15", "city.title": "Haleyville", "city.city_x_agent_id": { "222": { "city_x_agent.id": 222, "agent.id": 171, "agent.ts": "2017-09-05 05:26:56", "agent.title": "James Odum Jr", "agent.pull_right": "0.23 mi", "agent.phone_number": "(205) 487-4545", "agent.street_address": "754 US Highway 43", "agent.address_locality": "Winfield, AL 35594" }, "220": { "city_x_agent.id": 220, "agent.id": 220, "agent.ts": "2017-09-05 05:26:56", "agent.title": "YOUR INSURANCE CENTERS INC", "agent.pull_right": "23.41 mi", "agent.phone_number": "(205) 486-7575", "agent.street_address": "2012 9TH AVE", "agent.address_locality": "Haleyville, AL 35565-1423" }, "221": { "city_x_agent.id": 221, "agent.id": 221, "agent.ts": "2017-09-05 05:26:56", "agent.title": "David Hall", "agent.pull_right": "17.81 mi", "agent.phone_number": "(205) 921-9215", "agent.street_address": "138 1st St NW", "agent.address_locality": "Hamilton, AL 35570-0939" }, "223": { "city_x_agent.id": 223, "agent.id": 223, "agent.ts": "2017-09-05 05:26:56", "agent.title": "YOUR INSURANCE CENTERS INC", "agent.pull_right": "18.00 mi", "agent.phone_number": "(205) 921-2141", "agent.street_address": "400 BEXAR AVE W", "agent.address_locality": "Hamilton, AL 35570-5522" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "35": { "city.id": 35, "city.ts": "2017-08-15 02:34:15", "city.title": "Hamilton", "city.city_x_agent_id": { "226": { "city_x_agent.id": 226, "agent.id": 171, "agent.ts": "2017-09-05 05:26:56", "agent.title": "James Odum Jr", "agent.pull_right": "0.23 mi", "agent.phone_number": "(205) 487-4545", "agent.street_address": "754 US Highway 43", "agent.address_locality": "Winfield, AL 35594" }, "227": { "city_x_agent.id": 227, "agent.id": 220, "agent.ts": "2017-09-05 05:26:56", "agent.title": "YOUR INSURANCE CENTERS INC", "agent.pull_right": "23.41 mi", "agent.phone_number": "(205) 486-7575", "agent.street_address": "2012 9TH AVE", "agent.address_locality": "Haleyville, AL 35565-1423" }, "224": { "city_x_agent.id": 224, "agent.id": 221, "agent.ts": "2017-09-05 05:26:56", "agent.title": "David Hall", "agent.pull_right": "17.81 mi", "agent.phone_number": "(205) 921-9215", "agent.street_address": "138 1st St NW", "agent.address_locality": "Hamilton, AL 35570-0939" }, "225": { "city_x_agent.id": 225, "agent.id": 223, "agent.ts": "2017-09-05 05:26:56", "agent.title": "YOUR INSURANCE CENTERS INC", "agent.pull_right": "18.00 mi", "agent.phone_number": "(205) 921-2141", "agent.street_address": "400 BEXAR AVE W", "agent.address_locality": "Hamilton, AL 35570-5522" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "36": { "city.id": 36, "city.ts": "2017-08-15 02:34:15", "city.title": "Hanceville", "city.city_x_agent_id": { "234": { "city_x_agent.id": 234, "agent.id": 21, "agent.ts": "2017-09-05 21:45:20", "agent.title": "TONYA WILLIAMS INS AGENCY INC", "agent.pull_right": "0.86 mi", "agent.phone_number": "(256) 736-2638", "agent.street_address": "1014 N BRINDLEE MOUNTAIN PKWY", "agent.address_locality": "Arab, AL 35016-1095" }, "230": { "city_x_agent.id": 230, "agent.id": 37, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Martha Burchell", "agent.pull_right": "22.56 mi", "agent.phone_number": "(256) 737-7450", "agent.street_address": "101 Main Ave NW", "agent.address_locality": "Cullman, AL 35055-3514" }, "231": { "city_x_agent.id": 231, "agent.id": 40, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "23.95 mi", "agent.phone_number": "(256) 739-2520", "agent.street_address": "7434 AL Hwy 157", "agent.address_locality": "Cullman, AL 35057" }, "229": { "city_x_agent.id": 229, "agent.id": 41, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "23.98 mi", "agent.phone_number": "(256) 352-9992", "agent.street_address": "103 Commercial St SE", "agent.address_locality": "Hanceville, AL 35077" }, "228": { "city_x_agent.id": 228, "agent.id": 42, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Amber Milne", "agent.pull_right": "24.00 mi", "agent.phone_number": "(256) 352-9992", "agent.street_address": "103 Commercial St", "agent.address_locality": "Hanceville, AL 35077" }, "233": { "city_x_agent.id": 233, "agent.id": 95, "agent.ts": "2017-09-05 05:23:56", "agent.title": "JIM MURPHREE INSURANCE AGY INC", "agent.pull_right": "0.07 mi", "agent.phone_number": "(205) 274-2378", "agent.street_address": "407 2ND AVE E", "agent.address_locality": "Oneonta, AL 35121-1411" }, "232": { "city_x_agent.id": 232, "agent.id": 140, "agent.ts": "2017-09-05 22:10:04", "agent.title": "FREEDOM INSURANCE AGENCY LLC", "agent.pull_right": "20.58 mi", "agent.phone_number": "(256) 737-0011", "agent.street_address": "168 COUNTY ROAD 1435", "agent.address_locality": "Cullman, AL 35058-5600" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "37": { "city.id": 37, "city.ts": "2017-09-05 22:29:02", "city.title": "Hartselle", "city.city_x_agent_id": { "28650": { "city_x_agent.id": 28650, "agent.id": 37, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Martha Burchell", "agent.pull_right": "22.56 mi", "agent.phone_number": "(256) 737-7450", "agent.street_address": "101 Main Ave NW", "agent.address_locality": "Cullman, AL 35055-3514" }, "28648": { "city_x_agent.id": 28648, "agent.id": 40, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "23.95 mi", "agent.phone_number": "(256) 739-2520", "agent.street_address": "7434 AL Hwy 157", "agent.address_locality": "Cullman, AL 35057" }, "28653": { "city_x_agent.id": 28653, "agent.id": 43, "agent.ts": "2017-09-05 22:14:00", "agent.title": "John J Kilgro Jr", "agent.pull_right": "1.06 mi", "agent.phone_number": "(256) 232-5241", "agent.street_address": "800 US Highway 72 W STE G", "agent.address_locality": "Athens, AL 35611-4227" }, "28652": { "city_x_agent.id": 28652, "agent.id": 44, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Thomas E McAlister", "agent.pull_right": "1.73 mi", "agent.phone_number": "(256) 232-7200", "agent.street_address": "1111 U S Hwy 72 East", "agent.address_locality": "Athens, AL 35611" }, "28651": { "city_x_agent.id": 28651, "agent.id": 45, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Scott Wyatt Howell", "agent.pull_right": "1.91 mi", "agent.phone_number": "(256) 444-2041", "agent.street_address": "1114 Hwy 31 S STE E", "agent.address_locality": "Athens, AL 35611-4471" }, "28661": { "city_x_agent.id": 28661, "agent.id": 46, "agent.ts": "2017-09-05 05:17:39", "agent.title": "PEPPER JOHNSTONE & COMPANY INC", "agent.pull_right": "0.10 mi", "agent.phone_number": "(256) 232-7818", "agent.street_address": "122 W MARKET ST", "agent.address_locality": "Athens, AL 35611-2656" }, "28659": { "city_x_agent.id": 28659, "agent.id": 47, "agent.ts": "2017-09-05 05:17:39", "agent.title": "MARTIN & HUBBS INC", "agent.pull_right": "0.11 mi", "agent.phone_number": "(256) 232-0505", "agent.street_address": "102 W MARKET ST", "agent.address_locality": "Athens, AL 35611-2656" }, "28647": { "city_x_agent.id": 28647, "agent.id": 50, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Mickey H Brewington", "agent.pull_right": "13.60 mi", "agent.phone_number": "(256) 353-1115", "agent.street_address": "303 Cain St NE Ste B", "agent.address_locality": "Decatur, AL 35601-1983" }, "28646": { "city_x_agent.id": 28646, "agent.id": 51, "agent.ts": "2017-09-05 22:14:00", "agent.title": "John J Kilgro Jr", "agent.pull_right": "13.97 mi", "agent.phone_number": "(256) 350-8241", "agent.street_address": "439 Johnston St SE", "agent.address_locality": "Decatur, AL 35601" }, "28649": { "city_x_agent.id": 28649, "agent.id": 52, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Donna B. Oglesby", "agent.pull_right": "15.04 mi", "agent.phone_number": "(256) 464-7020", "agent.street_address": "107 Arlington Dr Ste N", "agent.address_locality": "Madison, AL 35758-1735" }, "28655": { "city_x_agent.id": 28655, "agent.id": 140, "agent.ts": "2017-09-05 22:10:04", "agent.title": "FREEDOM INSURANCE AGENCY LLC", "agent.pull_right": "20.58 mi", "agent.phone_number": "(256) 737-0011", "agent.street_address": "168 COUNTY ROAD 1435", "agent.address_locality": "Cullman, AL 35058-5600" }, "235": { "city_x_agent.id": 235, "agent.id": 141, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Larry Akin", "agent.pull_right": "19.87 mi", "agent.phone_number": "(256) 355-8500", "agent.street_address": "468 Highway 67 S", "agent.address_locality": "Decatur, AL 35603" }, "239": { "city_x_agent.id": 239, "agent.id": 142, "agent.ts": "2017-09-05 05:21:51", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "1.08 mi", "agent.phone_number": "(256) 773-2210", "agent.street_address": "1612 HIGHWAY 31 SW", "agent.address_locality": "Hartselle, AL 35640-2826" }, "238": { "city_x_agent.id": 238, "agent.id": 146, "agent.ts": "2017-09-05 22:14:01", "agent.title": "John J Kilgro Jr", "agent.pull_right": "15.65 mi", "agent.phone_number": "(256) 350-9434", "agent.street_address": "520 14th Ave SE", "agent.address_locality": "Decatur, AL 35601" }, "237": { "city_x_agent.id": 237, "agent.id": 147, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Larry Akin", "agent.pull_right": "16.19 mi", "agent.phone_number": "(256) 260-2278", "agent.street_address": "820 Bradley St SW", "agent.address_locality": "Decatur, AL 35601" }, "236": { "city_x_agent.id": 236, "agent.id": 148, "agent.ts": "2017-09-05 22:14:01", "agent.title": "David Hayes", "agent.pull_right": "16.85 mi", "agent.phone_number": "(256) 350-6315", "agent.street_address": "1000 Beltline Rd SW Ste A", "agent.address_locality": "Decatur, AL 35601" }, "244": { "city_x_agent.id": 244, "agent.id": 150, "agent.ts": "2017-09-05 22:14:11", "agent.title": "SS NESBITT & CO INC", "agent.pull_right": "15.22 mi", "agent.phone_number": "(205) 262-2700", "agent.street_address": "1425 6TH AVE SE", "agent.address_locality": "Decatur, AL 35601-4211" }, "242": { "city_x_agent.id": 242, "agent.id": 151, "agent.ts": "2017-09-05 22:14:11", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "15.59 mi", "agent.phone_number": "(256) 350-7296", "agent.street_address": "2708 6TH AVE SE STE A", "agent.address_locality": "Decatur, AL 35603-1508" }, "243": { "city_x_agent.id": 243, "agent.id": 152, "agent.ts": "2017-09-05 22:14:11", "agent.title": "KING WYNN & ASSOCIATES LLC", "agent.pull_right": "16.71 mi", "agent.phone_number": "(256) 686-3383", "agent.street_address": "2021 DANVILLE PARK DR SW STE 8", "agent.address_locality": "Decatur, AL 35603-1806" }, "240": { "city_x_agent.id": 240, "agent.id": 153, "agent.ts": "2017-09-05 22:14:11", "agent.title": "STOVALL MARKS INSURANCE INC", "agent.pull_right": "16.95 mi", "agent.phone_number": "(256) 355-7951", "agent.street_address": "2601 DANVILLE RD SW", "agent.address_locality": "Decatur, AL 35603-4216" }, "241": { "city_x_agent.id": 241, "agent.id": 241, "agent.ts": "2017-09-05 22:14:11", "agent.title": "STOVALL MARKS INSURANCE, INC", "agent.pull_right": "16.95 mi", "agent.phone_number": "(256) 355-7951", "agent.street_address": "2601 DANVILLE RD SW", "agent.address_locality": "Decatur, AL 35603-4216" }, "28654": { "city_x_agent.id": 28654, "agent.id": 260, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Dallas Davis-Graydon", "agent.pull_right": "15.08 mi", "agent.phone_number": "(256) 716-1307", "agent.street_address": "1807 Slaughter Rd Ste A", "agent.address_locality": "Madison, AL 35758-8695" }, "28658": { "city_x_agent.id": 28658, "agent.id": 263, "agent.ts": "2017-09-05 22:14:11", "agent.title": "J SMITH LANIER & CO", "agent.pull_right": "18.45 mi", "agent.phone_number": "(256) 890-9060", "agent.street_address": "206 EXCHANGE PL NW", "agent.address_locality": "Huntsville, AL 35806-2300" }, "28657": { "city_x_agent.id": 28657, "agent.id": 264, "agent.ts": "2017-09-05 22:14:11", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "16.27 mi", "agent.phone_number": "(256) 772-9704", "agent.street_address": "8121 MADISON BLVD STE 101B", "agent.address_locality": "Madison, AL 35758-2082" }, "28656": { "city_x_agent.id": 28656, "agent.id": 344, "agent.ts": "2017-09-05 05:23:31", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "1.22 mi", "agent.phone_number": "(256) 974-4000", "agent.street_address": "11210 AL HIGHWAY 157", "agent.address_locality": "Moulton, AL 35650-1906" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "38": { "city.id": 38, "city.ts": "2017-09-05 22:29:22", "city.title": "Hoover", "city.city_x_agent_id": { "28699": { "city_x_agent.id": 28699, "agent.id": 5, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Jeff Bentley", "agent.pull_right": "1.30 mi", "agent.phone_number": "(205) 663-6223", "agent.street_address": "580 14th Ave SW", "agent.address_locality": "Alabaster, AL 35007-5328" }, "28673": { "city_x_agent.id": 28673, "agent.id": 6, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Tyler F Watts", "agent.pull_right": "3.11 mi", "agent.phone_number": "(205) 690-5033", "agent.street_address": "160 Yeager Pkwy STE 107", "agent.address_locality": "Pelham, AL 35124" }, "248": { "city_x_agent.id": 248, "agent.id": 7, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Scott Richards", "agent.pull_right": "7.39 mi", "agent.phone_number": "(205) 988-4346", "agent.street_address": "2070 Valleydale Rd Ste 4", "agent.address_locality": "Birmingham, AL 35244-2035" }, "246": { "city_x_agent.id": 246, "agent.id": 8, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Kenneth R Caldwell", "agent.pull_right": "8.62 mi", "agent.phone_number": "(205) 733-0444", "agent.street_address": "3926 Lorna Rd", "agent.address_locality": "Birmingham, AL 35244-1004" }, "245": { "city_x_agent.id": 245, "agent.id": 9, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Roger L Watts", "agent.pull_right": "9.05 mi", "agent.phone_number": "(205) 988-8899", "agent.street_address": "3659 Lorna Rd Ste 109", "agent.address_locality": "Hoover, AL 35216-5958" }, "249": { "city_x_agent.id": 249, "agent.id": 10, "agent.ts": "2017-09-05 21:43:23", "agent.title": "Wade K. Kaiser", "agent.pull_right": "9.55 mi", "agent.phone_number": "(205) 291-4100", "agent.street_address": "2473 Valleydale Rd Ste A", "agent.address_locality": "Birmingham, AL 35244" }, "28682": { "city_x_agent.id": 28682, "agent.id": 11, "agent.ts": "2017-09-05 21:43:23", "agent.title": "ALABAMA INSURANCE EXCHANGE INC", "agent.pull_right": "7.25 mi", "agent.phone_number": "(205) 988-0800", "agent.street_address": "2032 VALLEYDALE RD", "agent.address_locality": "Hoover, AL 35244-2095" }, "28681": { "city_x_agent.id": 28681, "agent.id": 12, "agent.ts": "2017-09-05 21:43:23", "agent.title": "COMPLETE INSURANCE COVERAGE", "agent.pull_right": "7.28 mi", "agent.phone_number": "(205) 774-1754", "agent.street_address": "137 BUSINESS CENTER DR", "agent.address_locality": "Birmingham, AL 35244-2022" }, "28679": { "city_x_agent.id": 28679, "agent.id": 13, "agent.ts": "2017-09-05 21:43:23", "agent.title": "TRAMMEL-HARPER & WILLIAMS INC", "agent.pull_right": "7.55 mi", "agent.phone_number": "(205) 988-3444", "agent.street_address": "2073 VALLEYDALE RD", "agent.address_locality": "Hoover, AL 35244-2007" }, "28683": { "city_x_agent.id": 28683, "agent.id": 14, "agent.ts": "2017-09-05 22:14:16", "agent.title": "MIKOS KAMPAKIS INS SRVCS INC", "agent.pull_right": "7.25 mi", "agent.phone_number": "(205) 822-7413", "agent.street_address": "421 EMERY DR STE 100", "agent.address_locality": "Hoover, AL 35244-4567" }, "28675": { "city_x_agent.id": 28675, "agent.id": 66, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Calvin E Lewter", "agent.pull_right": "1.23 mi", "agent.phone_number": "(205) 426-4441", "agent.street_address": "417 4th Ave N", "agent.address_locality": "Bessemer, AL 35020-6230" }, "247": { "city_x_agent.id": 247, "agent.id": 68, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Ashley Bruette", "agent.pull_right": "8.66 mi", "agent.phone_number": "(205) 979-4331", "agent.street_address": "3021 Lorna Rd Ste 111", "agent.address_locality": "Birmingham, AL 35216" }, "252": { "city_x_agent.id": 252, "agent.id": 69, "agent.ts": "2017-09-05 22:14:16", "agent.title": "Patricia H Donalson", "agent.pull_right": "9.02 mi", "agent.phone_number": "(205) 942-7543", "agent.street_address": "1729 S Lakeshore Dr", "agent.address_locality": "Birmingham, AL 35216-1621" }, "28680": { "city_x_agent.id": 28680, "agent.id": 71, "agent.ts": "2017-09-05 22:14:16", "agent.title": "ELIM INSURANCE AGENCY, LLC", "agent.pull_right": "6.49 mi", "agent.phone_number": "(205) 979-9994", "agent.street_address": "2170 CLEARBROOK RD STE 105", "agent.address_locality": "Hoover, AL 35226-1573" }, "28684": { "city_x_agent.id": 28684, "agent.id": 73, "agent.ts": "2017-09-05 22:14:16", "agent.title": "MIKOS KAMPAKIS INSURANCE", "agent.pull_right": "7.25 mi", "agent.phone_number": "(205) 822-7413", "agent.street_address": "421 EMERY DR STE 100", "agent.address_locality": "Hoover, AL 35244-4567" }, "28677": { "city_x_agent.id": 28677, "agent.id": 74, "agent.ts": "2017-09-05 22:14:16", "agent.title": "KAMPAKIS INSURANCE SERVICES INC", "agent.pull_right": "8.38 mi", "agent.phone_number": "(205) 847-5355", "agent.street_address": "100 CENTURY PARK S STE 200", "agent.address_locality": "Birmingham, AL 35226-3922" }, "28676": { "city_x_agent.id": 28676, "agent.id": 75, "agent.ts": "2017-09-05 22:14:16", "agent.title": "NSUREHUB LLC", "agent.pull_right": "8.65 mi", "agent.phone_number": "(205) 377-7977", "agent.street_address": "3021 LORNA RD STE 301", "agent.address_locality": "Hoover, AL 35216-4500" }, "251": { "city_x_agent.id": 251, "agent.id": 77, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Tyler F Watts", "agent.pull_right": "14.04 mi", "agent.phone_number": "(205) 822-5477", "agent.street_address": "2015 Kentucky Ave", "agent.address_locality": "Birmingham, AL 35216" }, "28700": { "city_x_agent.id": 28700, "agent.id": 78, "agent.ts": "2017-09-05 21:44:56", "agent.title": "David Hayes", "agent.pull_right": "22.15 mi", "agent.phone_number": "(205) 798-4238", "agent.street_address": "221 Lapala Dr", "agent.address_locality": "Birmingham, AL 35214-3839" }, "28702": { "city_x_agent.id": 28702, "agent.id": 80, "agent.ts": "2017-09-05 05:24:52", "agent.title": "David Hayes", "agent.pull_right": "8.80 mi", "agent.phone_number": "(205) 386-4455", "agent.street_address": "1351 Decatur Hwy Ste 119", "agent.address_locality": "Fultondale, AL 35068" }, "28672": { "city_x_agent.id": 28672, "agent.id": 81, "agent.ts": "2017-09-05 21:44:56", "agent.title": "Brian Lambert", "agent.pull_right": "15.30 mi", "agent.phone_number": "(205) 871-9101", "agent.street_address": "3232 Cahaba Heights Rd", "agent.address_locality": "Birmingham, AL 35243-1614" }, "253": { "city_x_agent.id": 253, "agent.id": 83, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Russ Richardson", "agent.pull_right": "13.59 mi", "agent.phone_number": "(205) 991-7802", "agent.street_address": "4908 Cahaba River Rd Ste 108", "agent.address_locality": "Birmingham, AL 35243" }, "254": { "city_x_agent.id": 254, "agent.id": 84, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Max P Blalock Jr", "agent.pull_right": "13.54 mi", "agent.phone_number": "(205) 981-2424", "agent.street_address": "244 Inverness Center Dr Unit 102", "agent.address_locality": "Birmingham, AL 35242" }, "28698": { "city_x_agent.id": 28698, "agent.id": 103, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Rod Burchell", "agent.pull_right": "13.37 mi", "agent.phone_number": "(205) 678-0800", "agent.street_address": "16233 Highway 280 Ste E", "agent.address_locality": "Chelsea, AL 35043" }, "28674": { "city_x_agent.id": 28674, "agent.id": 104, "agent.ts": "2017-09-05 21:44:56", "agent.title": "Roger L Watts", "agent.pull_right": "14.25 mi", "agent.phone_number": "(205) 991-2636", "agent.street_address": "4000 Meadow Lake Dr Ste 119", "agent.address_locality": "Birmingham, AL 35242-5427" }, "250": { "city_x_agent.id": 250, "agent.id": 106, "agent.ts": "2017-09-05 21:44:54", "agent.title": "Robert Langston", "agent.pull_right": "10.69 mi", "agent.phone_number": "(205) 991-2484", "agent.street_address": "4525 Valleydale Rd", "agent.address_locality": "Birmingham, AL 35242-4605" }, "28694": { "city_x_agent.id": 28694, "agent.id": 111, "agent.ts": "2017-09-05 21:44:58", "agent.title": "COLLECTIVE UNDERWRITERS INC", "agent.pull_right": "13.98 mi", "agent.phone_number": "(205) 776-1680", "agent.street_address": "800 CORPORATE PKWY STE 108", "agent.address_locality": "Birmingham, AL 35242-5470" }, "28690": { "city_x_agent.id": 28690, "agent.id": 112, "agent.ts": "2017-09-05 21:44:57", "agent.title": "J SMITH LANIER & COMPANY", "agent.pull_right": "13.89 mi", "agent.phone_number": "(770) 683-1000", "agent.street_address": "10 INVERNESS CENTER PKWY STE 400", "agent.address_locality": "Birmingham, AL 35242-4818" }, "28705": { "city_x_agent.id": 28705, "agent.id": 115, "agent.ts": "2017-09-05 21:44:54", "agent.title": "John Allan Lowe", "agent.pull_right": "13.00 mi", "agent.phone_number": "(205) 669-7333", "agent.street_address": "101 Mildred St", "agent.address_locality": "Columbiana, AL 35051-9331" }, "28704": { "city_x_agent.id": 28704, "agent.id": 118, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Brian Lambert", "agent.pull_right": "6.29 mi", "agent.phone_number": "(205) 699-6554", "agent.street_address": "8349 1st Ave Ste 110", "agent.address_locality": "Leeds, AL 35094" }, "28707": { "city_x_agent.id": 28707, "agent.id": 188, "agent.ts": "2017-09-05 05:24:52", "agent.title": "Jonathan Nix", "agent.pull_right": "7.78 mi", "agent.phone_number": "(205) 631-4700", "agent.street_address": "1603 Decatur Hwy", "agent.address_locality": "Gardendale, AL 35071" }, "28703": { "city_x_agent.id": 28703, "agent.id": 191, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Sidney K Brooks", "agent.pull_right": "4.70 mi", "agent.phone_number": "(205) 856-3563", "agent.street_address": "1275 Center Point Pkwy Ste 200", "agent.address_locality": "Birmingham, AL 35215-6339" }, "28706": { "city_x_agent.id": 28706, "agent.id": 192, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Leo Blankenship", "agent.pull_right": "4.79 mi", "agent.phone_number": "(205) 854-1606", "agent.street_address": "2025 Center Point Pkwy", "agent.address_locality": "Birmingham, AL 35215-4619" }, "28709": { "city_x_agent.id": 28709, "agent.id": 193, "agent.ts": "2017-09-05 05:26:03", "agent.title": "David Hayes", "agent.pull_right": "3.43 mi", "agent.phone_number": "(205) 874-6546", "agent.street_address": "5290 Old Springville Rd Ste B", "agent.address_locality": "Pinson, AL 35126" }, "28697": { "city_x_agent.id": 28697, "agent.id": 194, "agent.ts": "2017-09-05 21:45:10", "agent.title": "WILLIS OF ALABAMA INC", "agent.pull_right": "18.99 mi", "agent.phone_number": "(205) 871-3871", "agent.street_address": "2101 6TH AVE N STE 1200", "agent.address_locality": "Birmingham, AL 35203-2775" }, "28696": { "city_x_agent.id": 28696, "agent.id": 195, "agent.ts": "2017-09-05 21:45:10", "agent.title": "POINT CLEAR INSURANCE PARTNERS LLC", "agent.pull_right": "18.40 mi", "agent.phone_number": "(205) 871-3894", "agent.street_address": "3918 MONTCLAIR RD STE 208", "agent.address_locality": "Mountain Brk, AL 35213-2418" }, "28695": { "city_x_agent.id": 28695, "agent.id": 196, "agent.ts": "2017-09-05 21:44:58", "agent.title": "J R PREWITT & ASSOCIATES INC", "agent.pull_right": "17.69 mi", "agent.phone_number": "(205) 397-5118", "agent.street_address": "2146 HIGHLAND AVE S", "agent.address_locality": "Birmingham, AL 35205-4002" }, "28711": { "city_x_agent.id": 28711, "agent.id": 214, "agent.ts": "2017-09-05 05:26:03", "agent.title": "David J. Rosetta", "agent.pull_right": "4.79 mi", "agent.phone_number": "(205) 680-4349", "agent.street_address": "6401 Old Springville Rd Ste 117", "agent.address_locality": "Pinson, AL 35126" }, "28708": { "city_x_agent.id": 28708, "agent.id": 215, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Stanley Q Wormely", "agent.pull_right": "0.49 mi", "agent.phone_number": "(205) 836-4466", "agent.street_address": "235 Main St Ste 103", "agent.address_locality": "Trussville, AL 35173" }, "28710": { "city_x_agent.id": 28710, "agent.id": 281, "agent.ts": "2017-09-05 05:26:03", "agent.title": "Jay R Grogan", "agent.pull_right": "1.37 mi", "agent.phone_number": "(205) 661-9393", "agent.street_address": "7018 Gadsden Hwy Ste 120", "agent.address_locality": "Trussville, AL 35173-2670" }, "28678": { "city_x_agent.id": 28678, "agent.id": 27399, "agent.ts": "2017-09-05 21:44:56", "agent.title": "JUDY CARTER AND ASSOCIATES", "agent.pull_right": "12.15 mi", "agent.phone_number": "(888) 795-1221", "agent.street_address": "300 VESTAVIA PKWY STE 3450", "agent.address_locality": "Vestavia, AL 35216-3776" }, "28686": { "city_x_agent.id": 28686, "agent.id": 27403, "agent.ts": "2017-09-05 21:44:58", "agent.title": "S S NESBITT & CO INC", "agent.pull_right": "14.81 mi", "agent.phone_number": "(205) 262-2625", "agent.street_address": "3500 BLUE LAKE DR STE 120", "agent.address_locality": "Vestavia, AL 35243-1909" }, "28687": { "city_x_agent.id": 28687, "agent.id": 27404, "agent.ts": "2017-09-05 21:44:58", "agent.title": "SS NESBITT & CO INC", "agent.pull_right": "14.81 mi", "agent.phone_number": "(205) 262-2700", "agent.street_address": "3500 BLUE LAKE DR STE 120", "agent.address_locality": "Vestavia, AL 35243-1909" }, "28688": { "city_x_agent.id": 28688, "agent.id": 27405, "agent.ts": "2017-09-05 21:44:58", "agent.title": "GREENHALGH INS AGENCY INC", "agent.pull_right": "15.25 mi", "agent.phone_number": "(205) 967-8800", "agent.street_address": "3144 CAHABA HEIGHTS RD", "agent.address_locality": "Vestavia, AL 35243-5243" }, "28689": { "city_x_agent.id": 28689, "agent.id": 27406, "agent.ts": "2017-09-05 21:44:58", "agent.title": "GREENHALGH INSURANCE AGENCY INC", "agent.pull_right": "15.25 mi", "agent.phone_number": "(205) 967-8800", "agent.street_address": "3144 CAHABA HEIGHTS RD", "agent.address_locality": "Vestavia, AL 35243-5243" }, "28685": { "city_x_agent.id": 28685, "agent.id": 27407, "agent.ts": "2017-09-05 21:44:58", "agent.title": "CRC INSURANCE SERVICES INC", "agent.pull_right": "15.55 mi", "agent.phone_number": "(312) 899-1480", "agent.street_address": "1 METROPLEX DR STE 400", "agent.address_locality": "Birmingham, AL 35209-6895" }, "28692": { "city_x_agent.id": 28692, "agent.id": 27408, "agent.ts": "2017-09-05 21:44:58", "agent.title": "DBAPETRA RMS WRIGHT SPRAYBERRY CLAY", "agent.pull_right": "16.04 mi", "agent.phone_number": "", "agent.street_address": "3794 VILLAGE LN", "agent.address_locality": "Mountain Brk, AL 35223-2700" }, "28691": { "city_x_agent.id": 28691, "agent.id": 27409, "agent.ts": "2017-09-05 21:44:58", "agent.title": "COBBS ALLEN & HALL INC", "agent.pull_right": "16.28 mi", "agent.phone_number": "(205) 414-8100", "agent.street_address": "115 OFFICE PARK DR", "agent.address_locality": "Mountain Brk, AL 35223-2421" }, "28693": { "city_x_agent.id": 28693, "agent.id": 27410, "agent.ts": "2017-09-05 21:44:58", "agent.title": "ARTHUR J GALLAGHER RISK MGMT", "agent.pull_right": "17.05 mi", "agent.phone_number": "(205) 414-7049", "agent.street_address": "2200 WOODCREST PL STE 250", "agent.address_locality": "Birmingham, AL 35209-1396" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "39": { "city.id": 39, "city.ts": "2017-09-05 22:29:40", "city.title": "Huntsville", "city.city_x_agent_id": { "259": { "city_x_agent.id": 259, "agent.id": 36, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Lee Chavez III", "agent.pull_right": "22.46 mi", "agent.phone_number": "(256) 882-9925", "agent.street_address": "1428 Weatherly Rd SE Ste 100", "agent.address_locality": "Huntsville, AL 35803-1181" }, "261": { "city_x_agent.id": 261, "agent.id": 38, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Lee Chavez III", "agent.pull_right": "23.20 mi", "agent.phone_number": "(256) 536-3227", "agent.street_address": "6674 HWY 431 Ste 4", "agent.address_locality": "Owens Cross Roads, AL 35763" }, "258": { "city_x_agent.id": 258, "agent.id": 39, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Tammy C Elders", "agent.pull_right": "24.92 mi", "agent.phone_number": "(256) 882-0706", "agent.street_address": "8003 Charlotte Dr", "agent.address_locality": "Huntsville, AL 35802-2254" }, "28727": { "city_x_agent.id": 28727, "agent.id": 43, "agent.ts": "2017-09-05 22:14:00", "agent.title": "John J Kilgro Jr", "agent.pull_right": "1.06 mi", "agent.phone_number": "(256) 232-5241", "agent.street_address": "800 US Highway 72 W STE G", "agent.address_locality": "Athens, AL 35611-4227" }, "28724": { "city_x_agent.id": 28724, "agent.id": 44, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Thomas E McAlister", "agent.pull_right": "1.73 mi", "agent.phone_number": "(256) 232-7200", "agent.street_address": "1111 U S Hwy 72 East", "agent.address_locality": "Athens, AL 35611" }, "28725": { "city_x_agent.id": 28725, "agent.id": 45, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Scott Wyatt Howell", "agent.pull_right": "1.91 mi", "agent.phone_number": "(256) 444-2041", "agent.street_address": "1114 Hwy 31 S STE E", "agent.address_locality": "Athens, AL 35611-4471" }, "28733": { "city_x_agent.id": 28733, "agent.id": 46, "agent.ts": "2017-09-05 05:17:39", "agent.title": "PEPPER JOHNSTONE & COMPANY INC", "agent.pull_right": "0.10 mi", "agent.phone_number": "(256) 232-7818", "agent.street_address": "122 W MARKET ST", "agent.address_locality": "Athens, AL 35611-2656" }, "28731": { "city_x_agent.id": 28731, "agent.id": 47, "agent.ts": "2017-09-05 05:17:39", "agent.title": "MARTIN & HUBBS INC", "agent.pull_right": "0.11 mi", "agent.phone_number": "(256) 232-0505", "agent.street_address": "102 W MARKET ST", "agent.address_locality": "Athens, AL 35611-2656" }, "28723": { "city_x_agent.id": 28723, "agent.id": 49, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Scott Wyatt Howell", "agent.pull_right": "12.65 mi", "agent.phone_number": "(256) 444-2041", "agent.street_address": "7561 Wall Triana Hwy Ste 3", "agent.address_locality": "Madison, AL 35757-8327" }, "28729": { "city_x_agent.id": 28729, "agent.id": 50, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Mickey H Brewington", "agent.pull_right": "13.60 mi", "agent.phone_number": "(256) 353-1115", "agent.street_address": "303 Cain St NE Ste B", "agent.address_locality": "Decatur, AL 35601-1983" }, "28728": { "city_x_agent.id": 28728, "agent.id": 51, "agent.ts": "2017-09-05 22:14:00", "agent.title": "John J Kilgro Jr", "agent.pull_right": "13.97 mi", "agent.phone_number": "(256) 350-8241", "agent.street_address": "439 Johnston St SE", "agent.address_locality": "Decatur, AL 35601" }, "28722": { "city_x_agent.id": 28722, "agent.id": 52, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Donna B. Oglesby", "agent.pull_right": "15.04 mi", "agent.phone_number": "(256) 464-7020", "agent.street_address": "107 Arlington Dr Ste N", "agent.address_locality": "Madison, AL 35758-1735" }, "28726": { "city_x_agent.id": 28726, "agent.id": 141, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Larry Akin", "agent.pull_right": "19.87 mi", "agent.phone_number": "(256) 355-8500", "agent.street_address": "468 Highway 67 S", "agent.address_locality": "Decatur, AL 35603" }, "28730": { "city_x_agent.id": 28730, "agent.id": 146, "agent.ts": "2017-09-05 22:14:01", "agent.title": "John J Kilgro Jr", "agent.pull_right": "15.65 mi", "agent.phone_number": "(256) 350-9434", "agent.street_address": "520 14th Ave SE", "agent.address_locality": "Decatur, AL 35601" }, "28735": { "city_x_agent.id": 28735, "agent.id": 150, "agent.ts": "2017-09-05 22:14:11", "agent.title": "SS NESBITT & CO INC", "agent.pull_right": "15.22 mi", "agent.phone_number": "(205) 262-2700", "agent.street_address": "1425 6TH AVE SE", "agent.address_locality": "Decatur, AL 35601-4211" }, "28734": { "city_x_agent.id": 28734, "agent.id": 151, "agent.ts": "2017-09-05 22:14:11", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "15.59 mi", "agent.phone_number": "(256) 350-7296", "agent.street_address": "2708 6TH AVE SE STE A", "agent.address_locality": "Decatur, AL 35603-1508" }, "255": { "city_x_agent.id": 255, "agent.id": 255, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Jon Peters", "agent.pull_right": "22.30 mi", "agent.phone_number": "(256) 288-0230", "agent.street_address": "1017 Meridian St N", "agent.address_locality": "Huntsville, AL 35801" }, "256": { "city_x_agent.id": 256, "agent.id": 256, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Dusty Kilgore", "agent.pull_right": "22.70 mi", "agent.phone_number": "(256) 539-7378", "agent.street_address": "900 Bob Wallace Ave Ste 107", "agent.address_locality": "Huntsville, AL 35801-5647" }, "257": { "city_x_agent.id": 257, "agent.id": 257, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Aleyda Schwaiger", "agent.pull_right": "21.86 mi", "agent.phone_number": "(256) 221-5740", "agent.street_address": "4008 Triana Blvd", "agent.address_locality": "Huntsville, AL 35805-5406" }, "260": { "city_x_agent.id": 260, "agent.id": 260, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Dallas Davis-Graydon", "agent.pull_right": "15.08 mi", "agent.phone_number": "(256) 716-1307", "agent.street_address": "1807 Slaughter Rd Ste A", "agent.address_locality": "Madison, AL 35758-8695" }, "262": { "city_x_agent.id": 262, "agent.id": 262, "agent.ts": "2017-09-05 22:14:11", "agent.title": "FOUNT PARKER HARBARGER & ASSOC", "agent.pull_right": "22.40 mi", "agent.phone_number": "(256) 428-1000", "agent.street_address": "201 WASHINGTON ST NE", "agent.address_locality": "Huntsville, AL 35801-4844" }, "263": { "city_x_agent.id": 263, "agent.id": 263, "agent.ts": "2017-09-05 22:14:11", "agent.title": "J SMITH LANIER & CO", "agent.pull_right": "18.45 mi", "agent.phone_number": "(256) 890-9060", "agent.street_address": "206 EXCHANGE PL NW", "agent.address_locality": "Huntsville, AL 35806-2300" }, "264": { "city_x_agent.id": 264, "agent.id": 264, "agent.ts": "2017-09-05 22:14:11", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "16.27 mi", "agent.phone_number": "(256) 772-9704", "agent.street_address": "8121 MADISON BLVD STE 101B", "agent.address_locality": "Madison, AL 35758-2082" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "40": { "city.id": 40, "city.ts": "2017-08-15 02:34:15", "city.title": "Jackson", "city.city_x_agent_id": { "265": { "city_x_agent.id": 265, "agent.id": 265, "agent.ts": "2017-09-05 05:22:16", "agent.title": "SKIPPER INSURANCE AGENCIES INC", "agent.pull_right": "1.29 mi", "agent.phone_number": "(251) 246-2487", "agent.street_address": "1534 COLLEGE AVE", "agent.address_locality": "Jackson, AL 36545-2419" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" } } } }