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/3/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/5/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 4, "limit": 20, "limit_total": 400, "time": 0.003930000000000000333344463143703251262195408344268798828125 }, "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": { "61": { "city.id": 61, "city.ts": "2017-09-05 22:33:57", "city.title": "Pinson", "city.city_x_agent_id": { "29028": { "city_x_agent.id": 29028, "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" }, "29025": { "city_x_agent.id": 29025, "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" }, "29024": { "city_x_agent.id": 29024, "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" }, "29023": { "city_x_agent.id": 29023, "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" }, "29050": { "city_x_agent.id": 29050, "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" }, "29049": { "city_x_agent.id": 29049, "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" }, "29048": { "city_x_agent.id": 29048, "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" }, "29021": { "city_x_agent.id": 29021, "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" }, "29017": { "city_x_agent.id": 29017, "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" }, "29046": { "city_x_agent.id": 29046, "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" }, "29044": { "city_x_agent.id": 29044, "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" }, "29045": { "city_x_agent.id": 29045, "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" }, "29016": { "city_x_agent.id": 29016, "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" }, "29013": { "city_x_agent.id": 29013, "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" }, "443": { "city_x_agent.id": 443, "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" }, "29015": { "city_x_agent.id": 29015, "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" }, "29018": { "city_x_agent.id": 29018, "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" }, "29020": { "city_x_agent.id": 29020, "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" }, "29047": { "city_x_agent.id": 29047, "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" }, "29026": { "city_x_agent.id": 29026, "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" }, "29019": { "city_x_agent.id": 29019, "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" }, "29022": { "city_x_agent.id": 29022, "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" }, "29042": { "city_x_agent.id": 29042, "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" }, "29041": { "city_x_agent.id": 29041, "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" }, "29012": { "city_x_agent.id": 29012, "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" }, "29027": { "city_x_agent.id": 29027, "agent.id": 119, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Luther Craig Tumlin", "agent.pull_right": "14.87 mi", "agent.phone_number": "(205) 884-2475", "agent.street_address": "1914 Cogswell Ave", "agent.address_locality": "Pell City, AL 35125-1651" }, "442": { "city_x_agent.id": 442, "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" }, "439": { "city_x_agent.id": 439, "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" }, "438": { "city_x_agent.id": 438, "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" }, "436": { "city_x_agent.id": 436, "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" }, "29031": { "city_x_agent.id": 29031, "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" }, "29030": { "city_x_agent.id": 29030, "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" }, "29032": { "city_x_agent.id": 29032, "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" }, "437": { "city_x_agent.id": 437, "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" }, "440": { "city_x_agent.id": 440, "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" }, "441": { "city_x_agent.id": 441, "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" }, "445": { "city_x_agent.id": 445, "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" }, "444": { "city_x_agent.id": 444, "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" }, "29029": { "city_x_agent.id": 29029, "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" }, "29043": { "city_x_agent.id": 29043, "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" }, "29039": { "city_x_agent.id": 29039, "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" }, "29040": { "city_x_agent.id": 29040, "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" }, "29037": { "city_x_agent.id": 29037, "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" }, "29038": { "city_x_agent.id": 29038, "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" }, "29036": { "city_x_agent.id": 29036, "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" }, "29035": { "city_x_agent.id": 29035, "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" }, "29034": { "city_x_agent.id": 29034, "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" }, "29033": { "city_x_agent.id": 29033, "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" }, "62": { "city.id": 62, "city.ts": "2017-09-05 22:34:10", "city.title": "Prattville", "city.city_x_agent_id": { "453": { "city_x_agent.id": 453, "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" }, "454": { "city_x_agent.id": 454, "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" }, "452": { "city_x_agent.id": 452, "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" }, "451": { "city_x_agent.id": 451, "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" }, "450": { "city_x_agent.id": 450, "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" }, "29062": { "city_x_agent.id": 29062, "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" }, "29066": { "city_x_agent.id": 29066, "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" }, "29067": { "city_x_agent.id": 29067, "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" }, "447": { "city_x_agent.id": 447, "agent.id": 339, "agent.ts": "2017-09-05 05:26:49", "agent.title": "David G Dockery", "agent.pull_right": "13.62 mi", "agent.phone_number": "(334) 358-1891", "agent.street_address": "694 Commerce Ct Ste D", "agent.address_locality": "Prattville, AL 36066" }, "446": { "city_x_agent.id": 446, "agent.id": 340, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Virginia Wallis", "agent.pull_right": "14.06 mi", "agent.phone_number": "(334) 358-1344", "agent.street_address": "696 N Silver Hills Dr Ste 116", "agent.address_locality": "Prattville, AL 36066" }, "448": { "city_x_agent.id": 448, "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" }, "455": { "city_x_agent.id": 455, "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" }, "29068": { "city_x_agent.id": 29068, "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" }, "29061": { "city_x_agent.id": 29061, "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" }, "29063": { "city_x_agent.id": 29063, "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" }, "29064": { "city_x_agent.id": 29064, "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" }, "29065": { "city_x_agent.id": 29065, "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" }, "29069": { "city_x_agent.id": 29069, "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" }, "29070": { "city_x_agent.id": 29070, "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" }, "63": { "city.id": 63, "city.ts": "2017-09-05 22:34:23", "city.title": "Rainbow City", "city.city_x_agent_id": { "460": { "city_x_agent.id": 460, "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" }, "463": { "city_x_agent.id": 463, "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" }, "457": { "city_x_agent.id": 457, "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" }, "456": { "city_x_agent.id": 456, "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" }, "458": { "city_x_agent.id": 458, "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" }, "459": { "city_x_agent.id": 459, "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" }, "462": { "city_x_agent.id": 462, "agent.id": 26, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Randy Jones", "agent.pull_right": "21.80 mi", "agent.phone_number": "(256) 237-7508", "agent.street_address": "413 Quintard Ave", "agent.address_locality": "Anniston, AL 36201-5751" }, "464": { "city_x_agent.id": 464, "agent.id": 28, "agent.ts": "2017-09-05 05:25:45", "agent.title": "CUNNINGHAM INSURANCE INC", "agent.pull_right": "22.12 mi", "agent.phone_number": "(256) 236-0301", "agent.street_address": "1112 WILMER AVE", "agent.address_locality": "Anniston, AL 36201-4648" }, "29081": { "city_x_agent.id": 29081, "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" }, "461": { "city_x_agent.id": 461, "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" }, "64": { "city.id": 64, "city.ts": "2017-08-15 02:34:15", "city.title": "Roanoke", "city.city_x_agent_id": { "472": { "city_x_agent.id": 472, "agent.id": 32, "agent.ts": "2017-09-05 05:27:08", "agent.title": "FIRST CAPITAL INS AGENCY INC", "agent.pull_right": "20.52 mi", "agent.phone_number": "(256) 396-2131", "agent.street_address": "575 E COLLEGE ST", "agent.address_locality": "Lineville, AL 36266-4521" }, "467": { "city_x_agent.id": 467, "agent.id": 269, "agent.ts": "2017-09-05 06:45:08", "agent.title": "Russ Richardson", "agent.pull_right": "15.82 mi", "agent.phone_number": "(205) 757-7137", "agent.street_address": "1350 County Road 114", "agent.address_locality": "Lafayette, AL 36862" }, "470": { "city_x_agent.id": 470, "agent.id": 271, "agent.ts": "2017-09-05 06:45:08", "agent.title": "J SMITH LANIER & CO", "agent.pull_right": "0.52 mi", "agent.phone_number": "(706) 645-8291", "agent.street_address": "300 W 10TH ST", "agent.address_locality": "West Point, GA 31833-1212" }, "471": { "city_x_agent.id": 471, "agent.id": 272, "agent.ts": "2017-09-05 06:45:08", "agent.title": "J SMITH LANIER & COMPANY", "agent.pull_right": "0.52 mi", "agent.phone_number": "(770) 683-1000", "agent.street_address": "300 W 10TH ST", "agent.address_locality": "West Point, GA 31833-1212" }, "466": { "city_x_agent.id": 466, "agent.id": 276, "agent.ts": "2017-09-05 05:27:08", "agent.title": "TRI COUNTY INSURANCE", "agent.pull_right": "15.61 mi", "agent.phone_number": "(334) 863-2206", "agent.street_address": "3164 HIGHWAY 431 STE 5", "agent.address_locality": "Roanoke, AL 36274-1702" }, "469": { "city_x_agent.id": 469, "agent.id": 278, "agent.ts": "2017-09-05 06:45:08", "agent.title": "MALLORY AGENCY", "agent.pull_right": "13.98 mi", "agent.phone_number": "(706) 884-3339", "agent.street_address": "207 N LEWIS ST", "agent.address_locality": "Lagrange, GA 30240-2737" }, "468": { "city_x_agent.id": 468, "agent.id": 300, "agent.ts": "2017-09-05 05:27:08", "agent.title": "Pamela Skidmore", "agent.pull_right": "0.79 mi", "agent.phone_number": "(256) 449-2671", "agent.street_address": "23431 Highway 48", "agent.address_locality": "Woodland, AL 36280-7719" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "65": { "city.id": 65, "city.ts": "2017-09-05 22:34:44", "city.title": "Rogersville", "city.city_x_agent_id": { "474": { "city_x_agent.id": 474, "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" }, "476": { "city_x_agent.id": 476, "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" }, "475": { "city_x_agent.id": 475, "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" }, "29097": { "city_x_agent.id": 29097, "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" }, "29098": { "city_x_agent.id": 29098, "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" }, "481": { "city_x_agent.id": 481, "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" }, "482": { "city_x_agent.id": 482, "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" }, "29094": { "city_x_agent.id": 29094, "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" }, "29092": { "city_x_agent.id": 29092, "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" }, "29093": { "city_x_agent.id": 29093, "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" }, "29106": { "city_x_agent.id": 29106, "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" }, "29107": { "city_x_agent.id": 29107, "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" }, "29100": { "city_x_agent.id": 29100, "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" }, "29102": { "city_x_agent.id": 29102, "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" }, "479": { "city_x_agent.id": 479, "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" }, "477": { "city_x_agent.id": 477, "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" }, "478": { "city_x_agent.id": 478, "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" }, "480": { "city_x_agent.id": 480, "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" }, "29105": { "city_x_agent.id": 29105, "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" }, "29104": { "city_x_agent.id": 29104, "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" }, "473": { "city_x_agent.id": 473, "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" }, "29095": { "city_x_agent.id": 29095, "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" }, "29096": { "city_x_agent.id": 29096, "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" }, "29103": { "city_x_agent.id": 29103, "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" }, "29101": { "city_x_agent.id": 29101, "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" }, "66": { "city.id": 66, "city.ts": "2017-09-05 22:34:53", "city.title": "Saraland", "city.city_x_agent_id": { "29121": { "city_x_agent.id": 29121, "agent.id": 54, "agent.ts": "2017-09-05 05:18:05", "agent.title": "Deborah Adams", "agent.pull_right": "0.06 mi", "agent.phone_number": "(251) 937-7513", "agent.street_address": "108 N Hoyle Ave", "agent.address_locality": "Bay Minette, AL 36507" }, "483": { "city_x_agent.id": 483, "agent.id": 61, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Shanda Dearing", "agent.pull_right": "11.25 mi", "agent.phone_number": "(251) 679-0801", "agent.street_address": "202 A Norton Ave", "agent.address_locality": "Saraland, AL 36571" }, "485": { "city_x_agent.id": 485, "agent.id": 63, "agent.ts": "2017-09-05 05:25:18", "agent.title": "WILLIS OF ALABAMA INC", "agent.pull_right": "8.08 mi", "agent.phone_number": "(251) 433-0441", "agent.street_address": "11 N WATER ST STE 19290", "agent.address_locality": "Mobile, AL 36602-3809" }, "486": { "city_x_agent.id": 486, "agent.id": 64, "agent.ts": "2017-09-05 05:25:18", "agent.title": "LYON FRY CADDEN INS AGENCY INC", "agent.pull_right": "8.80 mi", "agent.phone_number": "(251) 473-4600", "agent.street_address": "3212 MIDTOWN PARK S", "agent.address_locality": "Mobile, AL 36606-4128" }, "487": { "city_x_agent.id": 487, "agent.id": 65, "agent.ts": "2017-09-05 05:25:18", "agent.title": "LYON FRY CADDEN INSAGY INC", "agent.pull_right": "8.80 mi", "agent.phone_number": "(251) 473-4600", "agent.street_address": "3212 MIDTOWN PARK S", "agent.address_locality": "Mobile, AL 36606-4128" }, "489": { "city_x_agent.id": 489, "agent.id": 324, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Sandra Dockery", "agent.pull_right": "11.23 mi", "agent.phone_number": "(251) 476-0624", "agent.street_address": "1340 Sledge Dr Ste A", "agent.address_locality": "Mobile, AL 36606" }, "488": { "city_x_agent.id": 488, "agent.id": 325, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Franklin W Grimes Jr", "agent.pull_right": "11.00 mi", "agent.phone_number": "(251) 476-0614", "agent.street_address": "1111 E I65 Service Rd S Ste 105", "agent.address_locality": "Mobile, AL 36606" }, "490": { "city_x_agent.id": 490, "agent.id": 326, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Ford L Chambliss Jr", "agent.pull_right": "11.03 mi", "agent.phone_number": "(251) 461-0685", "agent.street_address": "1208 W I65 Service Rd S", "agent.address_locality": "Mobile, AL 36609-5514" }, "491": { "city_x_agent.id": 491, "agent.id": 327, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Judy C Bailey", "agent.pull_right": "11.84 mi", "agent.phone_number": "(251) 660-7878", "agent.street_address": "3700 K Government Blvd", "agent.address_locality": "Mobile, AL 36693" }, "29118": { "city_x_agent.id": 29118, "agent.id": 328, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Randy Jones", "agent.pull_right": "8.68 mi", "agent.phone_number": "(251) 345-6680", "agent.street_address": "1050 Hillcrest Road Ste C", "agent.address_locality": "Mobile, AL 36695" }, "29119": { "city_x_agent.id": 29119, "agent.id": 329, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Meredith C Smith", "agent.pull_right": "8.68 mi", "agent.phone_number": "(251) 634-1503", "agent.street_address": "1050 Hillcrest Rd Ste C", "agent.address_locality": "Mobile, AL 36695-3917" }, "492": { "city_x_agent.id": 492, "agent.id": 330, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Adrienne L Tucker", "agent.pull_right": "7.57 mi", "agent.phone_number": "(251) 342-4450", "agent.street_address": "6750 Airport Blvd STE D", "agent.address_locality": "Mobile, AL 36695" }, "29120": { "city_x_agent.id": 29120, "agent.id": 332, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Randy Jones", "agent.pull_right": "14.30 mi", "agent.phone_number": "(251) 666-5343", "agent.street_address": "5441 Highway 90 W Ste 24", "agent.address_locality": "Mobile, AL 36619" }, "484": { "city_x_agent.id": 484, "agent.id": 484, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Adrienne L Tucker", "agent.pull_right": "2.12 mi", "agent.phone_number": "(251) 645-0599", "agent.street_address": "7875 Moffett Rd Ste D", "agent.address_locality": "Semmes, AL 36575" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "67": { "city.id": 67, "city.ts": "2017-08-15 02:34:15", "city.title": "Scottsboro", "city.city_x_agent_id": { "495": { "city_x_agent.id": 495, "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" }, "493": { "city_x_agent.id": 493, "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" }, "494": { "city_x_agent.id": 494, "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" }, "68": { "city.id": 68, "city.ts": "2017-08-15 02:34:15", "city.title": "Selma", "city.city_x_agent_id": { "496": { "city_x_agent.id": 496, "agent.id": 496, "agent.ts": "2017-09-05 05:25:33", "agent.title": "PEAK INSURANCE INC", "agent.pull_right": "0.26 mi", "agent.phone_number": "(334) 872-2303", "agent.street_address": "1003 BROAD ST", "agent.address_locality": "Selma, AL 36701-4509" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "69": { "city.id": 69, "city.ts": "2017-09-05 22:35:06", "city.title": "Semmes", "city.city_x_agent_id": { "504": { "city_x_agent.id": 504, "agent.id": 61, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Shanda Dearing", "agent.pull_right": "11.25 mi", "agent.phone_number": "(251) 679-0801", "agent.street_address": "202 A Norton Ave", "agent.address_locality": "Saraland, AL 36571" }, "29135": { "city_x_agent.id": 29135, "agent.id": 63, "agent.ts": "2017-09-05 05:25:18", "agent.title": "WILLIS OF ALABAMA INC", "agent.pull_right": "8.08 mi", "agent.phone_number": "(251) 433-0441", "agent.street_address": "11 N WATER ST STE 19290", "agent.address_locality": "Mobile, AL 36602-3809" }, "29133": { "city_x_agent.id": 29133, "agent.id": 64, "agent.ts": "2017-09-05 05:25:18", "agent.title": "LYON FRY CADDEN INS AGENCY INC", "agent.pull_right": "8.80 mi", "agent.phone_number": "(251) 473-4600", "agent.street_address": "3212 MIDTOWN PARK S", "agent.address_locality": "Mobile, AL 36606-4128" }, "29134": { "city_x_agent.id": 29134, "agent.id": 65, "agent.ts": "2017-09-05 05:25:18", "agent.title": "LYON FRY CADDEN INSAGY INC", "agent.pull_right": "8.80 mi", "agent.phone_number": "(251) 473-4600", "agent.street_address": "3212 MIDTOWN PARK S", "agent.address_locality": "Mobile, AL 36606-4128" }, "503": { "city_x_agent.id": 503, "agent.id": 324, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Sandra Dockery", "agent.pull_right": "11.23 mi", "agent.phone_number": "(251) 476-0624", "agent.street_address": "1340 Sledge Dr Ste A", "agent.address_locality": "Mobile, AL 36606" }, "501": { "city_x_agent.id": 501, "agent.id": 325, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Franklin W Grimes Jr", "agent.pull_right": "11.00 mi", "agent.phone_number": "(251) 476-0614", "agent.street_address": "1111 E I65 Service Rd S Ste 105", "agent.address_locality": "Mobile, AL 36606" }, "502": { "city_x_agent.id": 502, "agent.id": 326, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Ford L Chambliss Jr", "agent.pull_right": "11.03 mi", "agent.phone_number": "(251) 461-0685", "agent.street_address": "1208 W I65 Service Rd S", "agent.address_locality": "Mobile, AL 36609-5514" }, "505": { "city_x_agent.id": 505, "agent.id": 327, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Judy C Bailey", "agent.pull_right": "11.84 mi", "agent.phone_number": "(251) 660-7878", "agent.street_address": "3700 K Government Blvd", "agent.address_locality": "Mobile, AL 36693" }, "499": { "city_x_agent.id": 499, "agent.id": 328, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Randy Jones", "agent.pull_right": "8.68 mi", "agent.phone_number": "(251) 345-6680", "agent.street_address": "1050 Hillcrest Road Ste C", "agent.address_locality": "Mobile, AL 36695" }, "500": { "city_x_agent.id": 500, "agent.id": 329, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Meredith C Smith", "agent.pull_right": "8.68 mi", "agent.phone_number": "(251) 634-1503", "agent.street_address": "1050 Hillcrest Rd Ste C", "agent.address_locality": "Mobile, AL 36695-3917" }, "498": { "city_x_agent.id": 498, "agent.id": 330, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Adrienne L Tucker", "agent.pull_right": "7.57 mi", "agent.phone_number": "(251) 342-4450", "agent.street_address": "6750 Airport Blvd STE D", "agent.address_locality": "Mobile, AL 36695" }, "506": { "city_x_agent.id": 506, "agent.id": 332, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Randy Jones", "agent.pull_right": "14.30 mi", "agent.phone_number": "(251) 666-5343", "agent.street_address": "5441 Highway 90 W Ste 24", "agent.address_locality": "Mobile, AL 36619" }, "497": { "city_x_agent.id": 497, "agent.id": 484, "agent.ts": "2017-09-05 05:25:35", "agent.title": "Adrienne L Tucker", "agent.pull_right": "2.12 mi", "agent.phone_number": "(251) 645-0599", "agent.street_address": "7875 Moffett Rd Ste D", "agent.address_locality": "Semmes, AL 36575" }, "29132": { "city_x_agent.id": 29132, "agent.id": 12900, "agent.ts": "2017-09-05 08:32:57", "agent.title": "Matthew L Bradshaw", "agent.pull_right": "1.78 mi", "agent.phone_number": "(601) 947-8770", "agent.street_address": "197 Scott Rd", "agent.address_locality": "Lucedale, MS 39452" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "70": { "city.id": 70, "city.ts": "2017-08-15 02:34:15", "city.title": "Sylacauga", "city.city_x_agent_id": { "510": { "city_x_agent.id": 510, "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" }, "512": { "city_x_agent.id": 512, "agent.id": 31, "agent.ts": "2017-09-05 05:25:45", "agent.title": "TALLADEGA INSURANCE AGENCY", "agent.pull_right": "0.17 mi", "agent.phone_number": "(256) 362-4153", "agent.street_address": "109 SPRING ST N", "agent.address_locality": "Talladega, AL 35160-2028" }, "511": { "city_x_agent.id": 511, "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" }, "507": { "city_x_agent.id": 507, "agent.id": 113, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Mark Daughtry", "agent.pull_right": "18.74 mi", "agent.phone_number": "(256) 378-0062", "agent.street_address": "34898 US Highway 280", "agent.address_locality": "Sylacauga, AL 35150" }, "508": { "city_x_agent.id": 508, "agent.id": 114, "agent.ts": "2017-09-05 05:25:45", "agent.title": "BIRMINGHAM INS BROKERS LLC", "agent.pull_right": "18.09 mi", "agent.phone_number": "(256) 346-3550", "agent.street_address": "123 6TH AVE SW # SV", "agent.address_locality": "Childersburg, AL 35044-1645" }, "509": { "city_x_agent.id": 509, "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" }, "513": { "city_x_agent.id": 513, "agent.id": 125, "agent.ts": "2017-09-05 21:44:57", "agent.title": "RUX CARTER INS AGY INC", "agent.pull_right": "12.93 mi", "agent.phone_number": "(205) 669-3158", "agent.street_address": "107 N MAIN ST", "agent.address_locality": "Columbiana, AL 35051-5359" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "71": { "city.id": 71, "city.ts": "2017-08-15 02:34:15", "city.title": "Talladega", "city.city_x_agent_id": { "518": { "city_x_agent.id": 518, "agent.id": 26, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Randy Jones", "agent.pull_right": "21.80 mi", "agent.phone_number": "(256) 237-7508", "agent.street_address": "413 Quintard Ave", "agent.address_locality": "Anniston, AL 36201-5751" }, "517": { "city_x_agent.id": 517, "agent.id": 27, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Mark Lee", "agent.pull_right": "20.00 mi", "agent.phone_number": "(256) 831-8691", "agent.street_address": "320 Snow St Ste A", "agent.address_locality": "Oxford, AL 36203" }, "520": { "city_x_agent.id": 520, "agent.id": 28, "agent.ts": "2017-09-05 05:25:45", "agent.title": "CUNNINGHAM INSURANCE INC", "agent.pull_right": "22.12 mi", "agent.phone_number": "(256) 236-0301", "agent.street_address": "1112 WILMER AVE", "agent.address_locality": "Anniston, AL 36201-4648" }, "514": { "city_x_agent.id": 514, "agent.id": 31, "agent.ts": "2017-09-05 05:25:45", "agent.title": "TALLADEGA INSURANCE AGENCY", "agent.pull_right": "0.17 mi", "agent.phone_number": "(256) 362-4153", "agent.street_address": "109 SPRING ST N", "agent.address_locality": "Talladega, AL 35160-2028" }, "522": { "city_x_agent.id": 522, "agent.id": 32, "agent.ts": "2017-09-05 05:27:08", "agent.title": "FIRST CAPITAL INS AGENCY INC", "agent.pull_right": "20.52 mi", "agent.phone_number": "(256) 396-2131", "agent.street_address": "575 E COLLEGE ST", "agent.address_locality": "Lineville, AL 36266-4521" }, "516": { "city_x_agent.id": 516, "agent.id": 113, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Mark Daughtry", "agent.pull_right": "18.74 mi", "agent.phone_number": "(256) 378-0062", "agent.street_address": "34898 US Highway 280", "agent.address_locality": "Sylacauga, AL 35150" }, "519": { "city_x_agent.id": 519, "agent.id": 114, "agent.ts": "2017-09-05 05:25:45", "agent.title": "BIRMINGHAM INS BROKERS LLC", "agent.pull_right": "18.09 mi", "agent.phone_number": "(256) 346-3550", "agent.street_address": "123 6TH AVE SW # SV", "agent.address_locality": "Childersburg, AL 35044-1645" }, "515": { "city_x_agent.id": 515, "agent.id": 119, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Luther Craig Tumlin", "agent.pull_right": "14.87 mi", "agent.phone_number": "(205) 884-2475", "agent.street_address": "1914 Cogswell Ave", "agent.address_locality": "Pell City, AL 35125-1651" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "72": { "city.id": 72, "city.ts": "2017-08-15 02:34:15", "city.title": "Troy", "city.city_x_agent_id": { "525": { "city_x_agent.id": 525, "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" }, "523": { "city_x_agent.id": 523, "agent.id": 311, "agent.ts": "2017-09-05 05:25:57", "agent.title": "SANBUCK INC", "agent.pull_right": "0.18 mi", "agent.phone_number": "(334) 566-2644", "agent.street_address": "101 S 3 NOTCH ST", "agent.address_locality": "Troy, AL 36081-1905" }, "524": { "city_x_agent.id": 524, "agent.id": 312, "agent.ts": "2017-09-05 05:25:57", "agent.title": "WILKES INSURANCE GROUP LLC", "agent.pull_right": "1.52 mi", "agent.phone_number": "(334) 566-2484", "agent.street_address": "1332 S BRUNDIDGE ST", "agent.address_locality": "Troy, AL 36081-3127" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "73": { "city.id": 73, "city.ts": "2017-09-05 22:35:51", "city.title": "Trussville", "city.city_x_agent_id": { "29163": { "city_x_agent.id": 29163, "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" }, "29162": { "city_x_agent.id": 29162, "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" }, "29161": { "city_x_agent.id": 29161, "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" }, "29160": { "city_x_agent.id": 29160, "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" }, "29183": { "city_x_agent.id": 29183, "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" }, "29182": { "city_x_agent.id": 29182, "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" }, "29181": { "city_x_agent.id": 29181, "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" }, "29184": { "city_x_agent.id": 29184, "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" }, "29159": { "city_x_agent.id": 29159, "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" }, "29153": { "city_x_agent.id": 29153, "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" }, "29180": { "city_x_agent.id": 29180, "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" }, "29185": { "city_x_agent.id": 29185, "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" }, "29178": { "city_x_agent.id": 29178, "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" }, "29179": { "city_x_agent.id": 29179, "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" }, "29152": { "city_x_agent.id": 29152, "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" }, "29154": { "city_x_agent.id": 29154, "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" }, "29146": { "city_x_agent.id": 29146, "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" }, "29148": { "city_x_agent.id": 29148, "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" }, "29150": { "city_x_agent.id": 29150, "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" }, "29151": { "city_x_agent.id": 29151, "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" }, "29158": { "city_x_agent.id": 29158, "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" }, "29149": { "city_x_agent.id": 29149, "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" }, "29156": { "city_x_agent.id": 29156, "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" }, "29176": { "city_x_agent.id": 29176, "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" }, "29175": { "city_x_agent.id": 29175, "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" }, "532": { "city_x_agent.id": 532, "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" }, "29157": { "city_x_agent.id": 29157, "agent.id": 119, "agent.ts": "2017-09-05 05:25:45", "agent.title": "Luther Craig Tumlin", "agent.pull_right": "14.87 mi", "agent.phone_number": "(205) 884-2475", "agent.street_address": "1914 Cogswell Ave", "agent.address_locality": "Pell City, AL 35125-1651" }, "29147": { "city_x_agent.id": 29147, "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" }, "529": { "city_x_agent.id": 529, "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" }, "531": { "city_x_agent.id": 531, "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" }, "528": { "city_x_agent.id": 528, "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" }, "29166": { "city_x_agent.id": 29166, "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" }, "29164": { "city_x_agent.id": 29164, "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" }, "29167": { "city_x_agent.id": 29167, "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" }, "530": { "city_x_agent.id": 530, "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" }, "526": { "city_x_agent.id": 526, "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" }, "527": { "city_x_agent.id": 527, "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" }, "533": { "city_x_agent.id": 533, "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" }, "534": { "city_x_agent.id": 534, "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" }, "535": { "city_x_agent.id": 535, "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" }, "29177": { "city_x_agent.id": 29177, "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" }, "29172": { "city_x_agent.id": 29172, "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" }, "29173": { "city_x_agent.id": 29173, "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" }, "29168": { "city_x_agent.id": 29168, "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" }, "29169": { "city_x_agent.id": 29169, "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" }, "29174": { "city_x_agent.id": 29174, "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" }, "29165": { "city_x_agent.id": 29165, "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" }, "29171": { "city_x_agent.id": 29171, "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" }, "29170": { "city_x_agent.id": 29170, "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" }, "74": { "city.id": 74, "city.ts": "2017-08-15 02:34:15", "city.title": "Tuscaloosa", "city.city_x_agent_id": { "538": { "city_x_agent.id": 538, "agent.id": 373, "agent.ts": "2017-09-05 05:26:05", "agent.title": "Michael Noe", "agent.pull_right": "2.66 mi", "agent.phone_number": "(205) 333-7133", "agent.street_address": "3920 McFarland Blvd", "agent.address_locality": "Northport, AL 35476" }, "537": { "city_x_agent.id": 537, "agent.id": 374, "agent.ts": "2017-09-05 05:26:05", "agent.title": "Jack Moorehead", "agent.pull_right": "1.94 mi", "agent.phone_number": "(205) 758-6700", "agent.street_address": "46 McFarland Blvd Ste 2", "agent.address_locality": "Northport, AL 35476" }, "536": { "city_x_agent.id": 536, "agent.id": 375, "agent.ts": "2017-09-05 05:26:05", "agent.title": "Stephen Baldo-Downs", "agent.pull_right": "1.69 mi", "agent.phone_number": "(205) 345-5958", "agent.street_address": "408 15th St", "agent.address_locality": "Tuscaloosa, AL 35401-3525" }, "539": { "city_x_agent.id": 539, "agent.id": 376, "agent.ts": "2017-09-05 05:26:05", "agent.title": "Dennis P Crocker", "agent.pull_right": "3.44 mi", "agent.phone_number": "(205) 553-4300", "agent.street_address": "3709 McFarland Blvd E", "agent.address_locality": "Tuscaloosa, AL 35405-2401" }, "543": { "city_x_agent.id": 543, "agent.id": 377, "agent.ts": "2017-09-05 05:26:05", "agent.title": "ZEALCO INSURANCE", "agent.pull_right": "1.54 mi", "agent.phone_number": "(205) 722-2777", "agent.street_address": "2114 LURLEEN B WALLACE BLVD", "agent.address_locality": "Northport, AL 35476-3948" }, "540": { "city_x_agent.id": 540, "agent.id": 378, "agent.ts": "2017-09-05 05:26:05", "agent.title": "THE INSURANCE CENTER OF TUSCALOOSA", "agent.pull_right": "0.18 mi", "agent.phone_number": "(205) 752-0486", "agent.street_address": "2105 JACK WARNER PKWY", "agent.address_locality": "Tuscaloosa, AL 35401-1029" }, "541": { "city_x_agent.id": 541, "agent.id": 379, "agent.ts": "2017-09-05 05:26:05", "agent.title": "FITTS AGENCY INC", "agent.pull_right": "0.29 mi", "agent.phone_number": "(205) 342-3500", "agent.street_address": "1806 6TH ST", "agent.address_locality": "Tuscaloosa, AL 35401-1721" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "75": { "city.id": 75, "city.ts": "2017-08-15 02:34:15", "city.title": "Tuscumbia", "city.city_x_agent_id": { "546": { "city_x_agent.id": 546, "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" }, "547": { "city_x_agent.id": 547, "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" }, "545": { "city_x_agent.id": 545, "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" }, "544": { "city_x_agent.id": 544, "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" }, "549": { "city_x_agent.id": 549, "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" }, "548": { "city_x_agent.id": 548, "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" }, "550": { "city_x_agent.id": 550, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "76": { "city.id": 76, "city.ts": "2017-08-15 02:34:15", "city.title": "Union Springs", "city.city_x_agent_id": { "551": { "city_x_agent.id": 551, "agent.id": 551, "agent.ts": "2017-09-05 05:26:17", "agent.title": "Roger L Watts", "agent.pull_right": "0.19 mi", "agent.phone_number": "(205) 991-6543", "agent.street_address": "214 N Prairie St Ste 1", "agent.address_locality": "Union Springs, AL 36089-1651" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "77": { "city.id": 77, "city.ts": "2017-09-05 22:36:10", "city.title": "Valley", "city.city_x_agent_id": { "556": { "city_x_agent.id": 556, "agent.id": 55, "agent.ts": "2017-09-05 06:45:08", "agent.title": "Mark Daughtry", "agent.pull_right": "19.97 mi", "agent.phone_number": "(334) 741-9979", "agent.street_address": "105 N 10th St STE A", "agent.address_locality": "Opelika, AL 36801-4300" }, "560": { "city_x_agent.id": 560, "agent.id": 56, "agent.ts": "2017-09-05 05:26:23", "agent.title": "TRI COUNTY INSURANCE", "agent.pull_right": "21.94 mi", "agent.phone_number": "(334) 887-2905", "agent.street_address": "1434 OPELIKA RD STE C", "agent.address_locality": "Auburn, AL 36830-7674" }, "559": { "city_x_agent.id": 559, "agent.id": 57, "agent.ts": "2017-09-05 06:45:08", "agent.title": "J SMITH LANIER & COMPANY", "agent.pull_right": "19.79 mi", "agent.phone_number": "(770) 683-1000", "agent.street_address": "707 AVENUE A", "agent.address_locality": "Opelika, AL 36801-4927" }, "558": { "city_x_agent.id": 558, "agent.id": 58, "agent.ts": "2017-09-05 05:26:23", "agent.title": "ELLIOTT & ASSOCIATES INC", "agent.pull_right": "17.29 mi", "agent.phone_number": "(334) 745-0888", "agent.street_address": "211 2ND AVE", "agent.address_locality": "Opelika, AL 36801-3607" }, "552": { "city_x_agent.id": 552, "agent.id": 59, "agent.ts": "2017-09-05 05:26:23", "agent.title": "TRI COUNTY INSURANCE", "agent.pull_right": "1.99 mi", "agent.phone_number": "(334) 756-3600", "agent.street_address": "360 FOB JAMES DR", "agent.address_locality": "Valley, AL 36854-5080" }, "555": { "city_x_agent.id": 555, "agent.id": 269, "agent.ts": "2017-09-05 06:45:08", "agent.title": "Russ Richardson", "agent.pull_right": "15.82 mi", "agent.phone_number": "(205) 757-7137", "agent.street_address": "1350 County Road 114", "agent.address_locality": "Lafayette, AL 36862" }, "553": { "city_x_agent.id": 553, "agent.id": 271, "agent.ts": "2017-09-05 06:45:08", "agent.title": "J SMITH LANIER & CO", "agent.pull_right": "0.52 mi", "agent.phone_number": "(706) 645-8291", "agent.street_address": "300 W 10TH ST", "agent.address_locality": "West Point, GA 31833-1212" }, "554": { "city_x_agent.id": 554, "agent.id": 272, "agent.ts": "2017-09-05 06:45:08", "agent.title": "J SMITH LANIER & COMPANY", "agent.pull_right": "0.52 mi", "agent.phone_number": "(770) 683-1000", "agent.street_address": "300 W 10TH ST", "agent.address_locality": "West Point, GA 31833-1212" }, "561": { "city_x_agent.id": 561, "agent.id": 276, "agent.ts": "2017-09-05 05:27:08", "agent.title": "TRI COUNTY INSURANCE", "agent.pull_right": "15.61 mi", "agent.phone_number": "(334) 863-2206", "agent.street_address": "3164 HIGHWAY 431 STE 5", "agent.address_locality": "Roanoke, AL 36274-1702" }, "557": { "city_x_agent.id": 557, "agent.id": 278, "agent.ts": "2017-09-05 06:45:08", "agent.title": "MALLORY AGENCY", "agent.pull_right": "13.98 mi", "agent.phone_number": "(706) 884-3339", "agent.street_address": "207 N LEWIS ST", "agent.address_locality": "Lagrange, GA 30240-2737" }, "29196": { "city_x_agent.id": 29196, "agent.id": 399, "agent.ts": "2017-09-05 05:24:03", "agent.title": "J SMITH LANIER & CO", "agent.pull_right": "24.74 mi", "agent.phone_number": "(229) 431-0023", "agent.street_address": "200 BROOKSTONE CENTRE PKWY", "agent.address_locality": "Columbus, GA 31904-4559" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "78": { "city.id": 78, "city.ts": "2017-08-15 02:34:15", "city.title": "Vernon", "city.city_x_agent_id": { "565": { "city_x_agent.id": 565, "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" }, "563": { "city_x_agent.id": 563, "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" }, "562": { "city_x_agent.id": 562, "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" }, "564": { "city_x_agent.id": 564, "agent.id": 564, "agent.ts": "2017-09-05 08:37:35", "agent.title": "John Smith", "agent.pull_right": "22.06 mi", "agent.phone_number": "(662) 327-0203", "agent.street_address": "431 Wilkins Wise Rd", "agent.address_locality": "Columbus, MS 39705" }, "566": { "city_x_agent.id": 566, "agent.id": 566, "agent.ts": "2017-09-05 08:37:35", "agent.title": "GALLOWAY CHANDLER MCKINNEY INS", "agent.pull_right": "23.68 mi", "agent.phone_number": "(662) 328-0492", "agent.street_address": "2320 COMMERCE ST", "agent.address_locality": "Columbus, MS 39705" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "79": { "city.id": 79, "city.ts": "2017-09-05 22:36:46", "city.title": "Vestavia", "city.city_x_agent_id": { "29243": { "city_x_agent.id": 29243, "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" }, "29235": { "city_x_agent.id": 29235, "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" }, "29208": { "city_x_agent.id": 29208, "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" }, "576": { "city_x_agent.id": 576, "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" }, "572": { "city_x_agent.id": 572, "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" }, "575": { "city_x_agent.id": 575, "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" }, "29231": { "city_x_agent.id": 29231, "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" }, "29230": { "city_x_agent.id": 29230, "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" }, "29229": { "city_x_agent.id": 29229, "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" }, "29232": { "city_x_agent.id": 29232, "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" }, "29236": { "city_x_agent.id": 29236, "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" }, "569": { "city_x_agent.id": 569, "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" }, "568": { "city_x_agent.id": 568, "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" }, "29223": { "city_x_agent.id": 29223, "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" }, "29233": { "city_x_agent.id": 29233, "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" }, "29215": { "city_x_agent.id": 29215, "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" }, "29219": { "city_x_agent.id": 29219, "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" }, "567": { "city_x_agent.id": 567, "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" }, "29209": { "city_x_agent.id": 29209, "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" }, "29234": { "city_x_agent.id": 29234, "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" }, "570": { "city_x_agent.id": 570, "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" }, "571": { "city_x_agent.id": 571, "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" }, "573": { "city_x_agent.id": 573, "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" }, "29237": { "city_x_agent.id": 29237, "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" }, "29207": { "city_x_agent.id": 29207, "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" }, "574": { "city_x_agent.id": 574, "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" }, "29227": { "city_x_agent.id": 29227, "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" }, "29226": { "city_x_agent.id": 29226, "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" }, "29241": { "city_x_agent.id": 29241, "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" }, "29240": { "city_x_agent.id": 29240, "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" }, "29238": { "city_x_agent.id": 29238, "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" }, "29239": { "city_x_agent.id": 29239, "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" }, "29244": { "city_x_agent.id": 29244, "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" }, "29225": { "city_x_agent.id": 29225, "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" }, "29224": { "city_x_agent.id": 29224, "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" }, "29220": { "city_x_agent.id": 29220, "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" }, "29246": { "city_x_agent.id": 29246, "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" }, "29242": { "city_x_agent.id": 29242, "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" }, "29245": { "city_x_agent.id": 29245, "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" }, "29228": { "city_x_agent.id": 29228, "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" }, "29213": { "city_x_agent.id": 29213, "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" }, "29221": { "city_x_agent.id": 29221, "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" }, "29222": { "city_x_agent.id": 29222, "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" }, "29216": { "city_x_agent.id": 29216, "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" }, "29217": { "city_x_agent.id": 29217, "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" }, "29211": { "city_x_agent.id": 29211, "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" }, "29218": { "city_x_agent.id": 29218, "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" }, "29212": { "city_x_agent.id": 29212, "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" }, "29214": { "city_x_agent.id": 29214, "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" }, "80": { "city.id": 80, "city.ts": "2017-09-05 22:37:03", "city.title": "Wetumpka", "city.city_x_agent_id": { "580": { "city_x_agent.id": 580, "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" }, "577": { "city_x_agent.id": 577, "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" }, "584": { "city_x_agent.id": 584, "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" }, "581": { "city_x_agent.id": 581, "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" }, "582": { "city_x_agent.id": 582, "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" }, "583": { "city_x_agent.id": 583, "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" }, "578": { "city_x_agent.id": 578, "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" }, "579": { "city_x_agent.id": 579, "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" }, "29257": { "city_x_agent.id": 29257, "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" }, "585": { "city_x_agent.id": 585, "agent.id": 339, "agent.ts": "2017-09-05 05:26:49", "agent.title": "David G Dockery", "agent.pull_right": "13.62 mi", "agent.phone_number": "(334) 358-1891", "agent.street_address": "694 Commerce Ct Ste D", "agent.address_locality": "Prattville, AL 36066" }, "586": { "city_x_agent.id": 586, "agent.id": 340, "agent.ts": "2017-09-05 05:26:49", "agent.title": "Virginia Wallis", "agent.pull_right": "14.06 mi", "agent.phone_number": "(334) 358-1344", "agent.street_address": "696 N Silver Hills Dr Ste 116", "agent.address_locality": "Prattville, AL 36066" }, "29259": { "city_x_agent.id": 29259, "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" }, "29262": { "city_x_agent.id": 29262, "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" }, "29258": { "city_x_agent.id": 29258, "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" }, "29261": { "city_x_agent.id": 29261, "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" }, "29263": { "city_x_agent.id": 29263, "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" }, "29264": { "city_x_agent.id": 29264, "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" }, "29265": { "city_x_agent.id": 29265, "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" }, "29266": { "city_x_agent.id": 29266, "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" }, "29267": { "city_x_agent.id": 29267, "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" } } } }