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" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/insurance_agent_of_nationwide_1/main/list/2/?app=html-json" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 400, "time": 0.00813000000000000007382983113757290993817150592803955078125 }, "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": { "1": { "city.id": 1, "city.ts": "2017-08-15 02:34:15", "city.title": "Abbeville", "city.city_x_agent_id": { "1": { "city_x_agent.id": 1, "agent.id": 1, "agent.ts": "2017-09-06 21:20:36", "agent.title": "SOUTHERN PREMIER AGENCY LLC", "agent.pull_right": "23.24 mi", "agent.phone_number": "(334) 575-5167", "agent.street_address": "109 W WILLIAMS ST", "agent.address_locality": "Abbeville, AL 36310-2123" }, "2": { "city_x_agent.id": 2, "agent.id": 2, "agent.ts": "2017-09-06 21:20:36", "agent.title": "CLENNEY INS OF BLAKELY INC", "agent.pull_right": "22.96 mi", "agent.phone_number": "(229) 723-0880", "agent.street_address": "8 LIBERTY ST", "agent.address_locality": "Blakely, GA 39823-2258" }, "3": { "city_x_agent.id": 3, "agent.id": 3, "agent.ts": "2017-09-06 21:20:36", "agent.title": "CORNERSTONE INS GROUP INC", "agent.pull_right": "22.96 mi", "agent.phone_number": "(229) 723-6798", "agent.street_address": "120 COURT SQ", "agent.address_locality": "Blakely, GA 39823-2343" }, "4": { "city_x_agent.id": 4, "agent.id": 4, "agent.ts": "2017-09-06 21:20:36", "agent.title": "THE GLOVER AGENCY LLC", "agent.pull_right": "0.19 mi", "agent.phone_number": "(334) 687-0358", "agent.street_address": "145 E BROAD ST", "agent.address_locality": "Eufaula, AL 36027-2023" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "2": { "city.id": 2, "city.ts": "2017-09-05 22:24:19", "city.title": "Alabaster", "city.city_x_agent_id": { "5": { "city_x_agent.id": 5, "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" }, "6": { "city_x_agent.id": 6, "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" }, "7": { "city_x_agent.id": 7, "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" }, "8": { "city_x_agent.id": 8, "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" }, "9": { "city_x_agent.id": 9, "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" }, "10": { "city_x_agent.id": 10, "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" }, "11": { "city_x_agent.id": 11, "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" }, "12": { "city_x_agent.id": 12, "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" }, "13": { "city_x_agent.id": 13, "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" }, "14": { "city_x_agent.id": 14, "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" }, "27376": { "city_x_agent.id": 27376, "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" }, "27374": { "city_x_agent.id": 27374, "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" }, "27381": { "city_x_agent.id": 27381, "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" }, "27388": { "city_x_agent.id": 27388, "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" }, "27372": { "city_x_agent.id": 27372, "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" }, "27387": { "city_x_agent.id": 27387, "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" }, "27386": { "city_x_agent.id": 27386, "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" }, "27380": { "city_x_agent.id": 27380, "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" }, "27384": { "city_x_agent.id": 27384, "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" }, "27383": { "city_x_agent.id": 27383, "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" }, "27379": { "city_x_agent.id": 27379, "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" }, "27378": { "city_x_agent.id": 27378, "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" }, "27377": { "city_x_agent.id": 27377, "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" }, "27382": { "city_x_agent.id": 27382, "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" }, "27373": { "city_x_agent.id": 27373, "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" }, "27392": { "city_x_agent.id": 27392, "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" }, "27391": { "city_x_agent.id": 27391, "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" }, "27375": { "city_x_agent.id": 27375, "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" }, "27390": { "city_x_agent.id": 27390, "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" }, "27403": { "city_x_agent.id": 27403, "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" }, "27402": { "city_x_agent.id": 27402, "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" }, "27401": { "city_x_agent.id": 27401, "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" }, "27404": { "city_x_agent.id": 27404, "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" }, "27389": { "city_x_agent.id": 27389, "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" }, "27393": { "city_x_agent.id": 27393, "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" }, "27394": { "city_x_agent.id": 27394, "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" }, "27395": { "city_x_agent.id": 27395, "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" }, "27396": { "city_x_agent.id": 27396, "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" }, "27397": { "city_x_agent.id": 27397, "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" }, "27398": { "city_x_agent.id": 27398, "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" }, "27399": { "city_x_agent.id": 27399, "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" }, "27400": { "city_x_agent.id": 27400, "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" }, "3": { "city.id": 3, "city.ts": "2017-08-15 02:34:15", "city.title": "Albertville", "city.city_x_agent_id": { "15": { "city_x_agent.id": 15, "agent.id": 15, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "15.57 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US Highway 431 N", "agent.address_locality": "Albertville, AL 35950-0153" }, "16": { "city_x_agent.id": 16, "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" }, "17": { "city_x_agent.id": 17, "agent.id": 17, "agent.ts": "2017-09-05 22:10:04", "agent.title": "RANDY JONES & ASSOCIATES INC", "agent.pull_right": "15.58 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US HIGHWAY 431", "agent.address_locality": "Albertville, AL 35950-0153" }, "18": { "city_x_agent.id": 18, "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" }, "19": { "city_x_agent.id": 19, "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" }, "20": { "city_x_agent.id": 20, "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" }, "21": { "city_x_agent.id": 21, "agent.id": 21, "agent.ts": "2017-09-05 21:45:20", "agent.title": "TONYA WILLIAMS INS AGENCY INC", "agent.pull_right": "0.86 mi", "agent.phone_number": "(256) 736-2638", "agent.street_address": "1014 N BRINDLEE MOUNTAIN PKWY", "agent.address_locality": "Arab, AL 35016-1095" }, "22": { "city_x_agent.id": 22, "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" }, "23": { "city_x_agent.id": 23, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "4": { "city.id": 4, "city.ts": "2017-08-15 02:34:15", "city.title": "Alexander City", "city.city_x_agent_id": { "24": { "city_x_agent.id": 24, "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" }, "25": { "city_x_agent.id": 25, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "5": { "city.id": 5, "city.ts": "2017-08-15 02:34:15", "city.title": "Anniston", "city.city_x_agent_id": { "30": { "city_x_agent.id": 30, "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" }, "26": { "city_x_agent.id": 26, "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" }, "27": { "city_x_agent.id": 27, "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" }, "28": { "city_x_agent.id": 28, "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" }, "31": { "city_x_agent.id": 31, "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" }, "32": { "city_x_agent.id": 32, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "6": { "city.id": 6, "city.ts": "2017-09-05 22:24:32", "city.title": "Arab", "city.city_x_agent_id": { "34": { "city_x_agent.id": 34, "agent.id": 15, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "15.57 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US Highway 431 N", "agent.address_locality": "Albertville, AL 35950-0153" }, "35": { "city_x_agent.id": 35, "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" }, "27688": { "city_x_agent.id": 27688, "agent.id": 17, "agent.ts": "2017-09-05 22:10:04", "agent.title": "RANDY JONES & ASSOCIATES INC", "agent.pull_right": "15.58 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US HIGHWAY 431", "agent.address_locality": "Albertville, AL 35950-0153" }, "27690": { "city_x_agent.id": 27690, "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" }, "33": { "city_x_agent.id": 33, "agent.id": 21, "agent.ts": "2017-09-05 21:45:20", "agent.title": "TONYA WILLIAMS INS AGENCY INC", "agent.pull_right": "0.86 mi", "agent.phone_number": "(256) 736-2638", "agent.street_address": "1014 N BRINDLEE MOUNTAIN PKWY", "agent.address_locality": "Arab, AL 35016-1095" }, "36": { "city_x_agent.id": 36, "agent.id": 36, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Lee Chavez III", "agent.pull_right": "22.46 mi", "agent.phone_number": "(256) 882-9925", "agent.street_address": "1428 Weatherly Rd SE Ste 100", "agent.address_locality": "Huntsville, AL 35803-1181" }, "37": { "city_x_agent.id": 37, "agent.id": 37, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Martha Burchell", "agent.pull_right": "22.56 mi", "agent.phone_number": "(256) 737-7450", "agent.street_address": "101 Main Ave NW", "agent.address_locality": "Cullman, AL 35055-3514" }, "38": { "city_x_agent.id": 38, "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" }, "39": { "city_x_agent.id": 39, "agent.id": 39, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Tammy C Elders", "agent.pull_right": "24.92 mi", "agent.phone_number": "(256) 882-0706", "agent.street_address": "8003 Charlotte Dr", "agent.address_locality": "Huntsville, AL 35802-2254" }, "40": { "city_x_agent.id": 40, "agent.id": 40, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "23.95 mi", "agent.phone_number": "(256) 739-2520", "agent.street_address": "7434 AL Hwy 157", "agent.address_locality": "Cullman, AL 35057" }, "41": { "city_x_agent.id": 41, "agent.id": 41, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "23.98 mi", "agent.phone_number": "(256) 352-9992", "agent.street_address": "103 Commercial St SE", "agent.address_locality": "Hanceville, AL 35077" }, "42": { "city_x_agent.id": 42, "agent.id": 42, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Amber Milne", "agent.pull_right": "24.00 mi", "agent.phone_number": "(256) 352-9992", "agent.street_address": "103 Commercial St", "agent.address_locality": "Hanceville, AL 35077" }, "27689": { "city_x_agent.id": 27689, "agent.id": 140, "agent.ts": "2017-09-05 22:10:04", "agent.title": "FREEDOM INSURANCE AGENCY LLC", "agent.pull_right": "20.58 mi", "agent.phone_number": "(256) 737-0011", "agent.street_address": "168 COUNTY ROAD 1435", "agent.address_locality": "Cullman, AL 35058-5600" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "7": { "city.id": 7, "city.ts": "2017-09-05 22:24:47", "city.title": "Athens", "city.city_x_agent_id": { "27881": { "city_x_agent.id": 27881, "agent.id": 39, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Tammy C Elders", "agent.pull_right": "24.92 mi", "agent.phone_number": "(256) 882-0706", "agent.street_address": "8003 Charlotte Dr", "agent.address_locality": "Huntsville, AL 35802-2254" }, "43": { "city_x_agent.id": 43, "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" }, "44": { "city_x_agent.id": 44, "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" }, "45": { "city_x_agent.id": 45, "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" }, "46": { "city_x_agent.id": 46, "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" }, "47": { "city_x_agent.id": 47, "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" }, "49": { "city_x_agent.id": 49, "agent.id": 49, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Scott Wyatt Howell", "agent.pull_right": "12.65 mi", "agent.phone_number": "(256) 444-2041", "agent.street_address": "7561 Wall Triana Hwy Ste 3", "agent.address_locality": "Madison, AL 35757-8327" }, "50": { "city_x_agent.id": 50, "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" }, "51": { "city_x_agent.id": 51, "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" }, "52": { "city_x_agent.id": 52, "agent.id": 52, "agent.ts": "2017-09-05 22:14:00", "agent.title": "Donna B. Oglesby", "agent.pull_right": "15.04 mi", "agent.phone_number": "(256) 464-7020", "agent.street_address": "107 Arlington Dr Ste N", "agent.address_locality": "Madison, AL 35758-1735" }, "27877": { "city_x_agent.id": 27877, "agent.id": 141, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Larry Akin", "agent.pull_right": "19.87 mi", "agent.phone_number": "(256) 355-8500", "agent.street_address": "468 Highway 67 S", "agent.address_locality": "Decatur, AL 35603" }, "27873": { "city_x_agent.id": 27873, "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" }, "27874": { "city_x_agent.id": 27874, "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" }, "27875": { "city_x_agent.id": 27875, "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" }, "27882": { "city_x_agent.id": 27882, "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" }, "27883": { "city_x_agent.id": 27883, "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" }, "27885": { "city_x_agent.id": 27885, "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" }, "27886": { "city_x_agent.id": 27886, "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" }, "27876": { "city_x_agent.id": 27876, "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" }, "27887": { "city_x_agent.id": 27887, "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" }, "27879": { "city_x_agent.id": 27879, "agent.id": 255, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Jon Peters", "agent.pull_right": "22.30 mi", "agent.phone_number": "(256) 288-0230", "agent.street_address": "1017 Meridian St N", "agent.address_locality": "Huntsville, AL 35801" }, "27880": { "city_x_agent.id": 27880, "agent.id": 256, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Dusty Kilgore", "agent.pull_right": "22.70 mi", "agent.phone_number": "(256) 539-7378", "agent.street_address": "900 Bob Wallace Ave Ste 107", "agent.address_locality": "Huntsville, AL 35801-5647" }, "27878": { "city_x_agent.id": 27878, "agent.id": 257, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Aleyda Schwaiger", "agent.pull_right": "21.86 mi", "agent.phone_number": "(256) 221-5740", "agent.street_address": "4008 Triana Blvd", "agent.address_locality": "Huntsville, AL 35805-5406" }, "27872": { "city_x_agent.id": 27872, "agent.id": 260, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Dallas Davis-Graydon", "agent.pull_right": "15.08 mi", "agent.phone_number": "(256) 716-1307", "agent.street_address": "1807 Slaughter Rd Ste A", "agent.address_locality": "Madison, AL 35758-8695" }, "27889": { "city_x_agent.id": 27889, "agent.id": 262, "agent.ts": "2017-09-05 22:14:11", "agent.title": "FOUNT PARKER HARBARGER & ASSOC", "agent.pull_right": "22.40 mi", "agent.phone_number": "(256) 428-1000", "agent.street_address": "201 WASHINGTON ST NE", "agent.address_locality": "Huntsville, AL 35801-4844" }, "27888": { "city_x_agent.id": 27888, "agent.id": 263, "agent.ts": "2017-09-05 22:14:11", "agent.title": "J SMITH LANIER & CO", "agent.pull_right": "18.45 mi", "agent.phone_number": "(256) 890-9060", "agent.street_address": "206 EXCHANGE PL NW", "agent.address_locality": "Huntsville, AL 35806-2300" }, "27884": { "city_x_agent.id": 27884, "agent.id": 264, "agent.ts": "2017-09-05 22:14:11", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "16.27 mi", "agent.phone_number": "(256) 772-9704", "agent.street_address": "8121 MADISON BLVD STE 101B", "agent.address_locality": "Madison, AL 35758-2082" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "8": { "city.id": 8, "city.ts": "2017-08-15 02:34:15", "city.title": "Atmore", "city.city_x_agent_id": { "53": { "city_x_agent.id": 53, "agent.id": 53, "agent.ts": "2017-09-05 05:18:05", "agent.title": "Sandra Dockery", "agent.pull_right": "18.67 mi", "agent.phone_number": "(251) 368-7512", "agent.street_address": "1318 S Main St", "agent.address_locality": "Atmore, AL 36502" }, "54": { "city_x_agent.id": 54, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "9": { "city.id": 9, "city.ts": "2017-08-15 02:34:15", "city.title": "Auburn", "city.city_x_agent_id": { "55": { "city_x_agent.id": 55, "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" }, "56": { "city_x_agent.id": 56, "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" }, "57": { "city_x_agent.id": 57, "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" }, "58": { "city_x_agent.id": 58, "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" }, "59": { "city_x_agent.id": 59, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "10": { "city.id": 10, "city.ts": "2017-08-15 02:34:15", "city.title": "Bay Minette", "city.city_x_agent_id": { "62": { "city_x_agent.id": 62, "agent.id": 53, "agent.ts": "2017-09-05 05:18:05", "agent.title": "Sandra Dockery", "agent.pull_right": "18.67 mi", "agent.phone_number": "(251) 368-7512", "agent.street_address": "1318 S Main St", "agent.address_locality": "Atmore, AL 36502" }, "60": { "city_x_agent.id": 60, "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" }, "61": { "city_x_agent.id": 61, "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" }, "63": { "city_x_agent.id": 63, "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" }, "64": { "city_x_agent.id": 64, "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" }, "65": { "city_x_agent.id": 65, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "11": { "city.id": 11, "city.ts": "2017-09-05 22:25:19", "city.title": "Bessemer", "city.city_x_agent_id": { "28006": { "city_x_agent.id": 28006, "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" }, "27999": { "city_x_agent.id": 27999, "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" }, "27998": { "city_x_agent.id": 27998, "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" }, "67": { "city_x_agent.id": 67, "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" }, "70": { "city_x_agent.id": 70, "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" }, "28002": { "city_x_agent.id": 28002, "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" }, "28015": { "city_x_agent.id": 28015, "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" }, "28016": { "city_x_agent.id": 28016, "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" }, "28017": { "city_x_agent.id": 28017, "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" }, "72": { "city_x_agent.id": 72, "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" }, "66": { "city_x_agent.id": 66, "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" }, "68": { "city_x_agent.id": 68, "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" }, "69": { "city_x_agent.id": 69, "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" }, "71": { "city_x_agent.id": 71, "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" }, "73": { "city_x_agent.id": 73, "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" }, "74": { "city_x_agent.id": 74, "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" }, "75": { "city_x_agent.id": 75, "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" }, "27997": { "city_x_agent.id": 27997, "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" }, "28000": { "city_x_agent.id": 28000, "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" }, "28009": { "city_x_agent.id": 28009, "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" }, "28005": { "city_x_agent.id": 28005, "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" }, "28004": { "city_x_agent.id": 28004, "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" }, "28007": { "city_x_agent.id": 28007, "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" }, "28010": { "city_x_agent.id": 28010, "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" }, "28008": { "city_x_agent.id": 28008, "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" }, "28003": { "city_x_agent.id": 28003, "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" }, "28030": { "city_x_agent.id": 28030, "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" }, "28029": { "city_x_agent.id": 28029, "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" }, "28011": { "city_x_agent.id": 28011, "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" }, "28012": { "city_x_agent.id": 28012, "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" }, "28013": { "city_x_agent.id": 28013, "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" }, "28022": { "city_x_agent.id": 28022, "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" }, "28026": { "city_x_agent.id": 28026, "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" }, "28020": { "city_x_agent.id": 28020, "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" }, "28014": { "city_x_agent.id": 28014, "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" }, "28032": { "city_x_agent.id": 28032, "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" }, "28031": { "city_x_agent.id": 28031, "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" }, "27996": { "city_x_agent.id": 27996, "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" }, "28027": { "city_x_agent.id": 28027, "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" }, "28028": { "city_x_agent.id": 28028, "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" }, "28023": { "city_x_agent.id": 28023, "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" }, "28024": { "city_x_agent.id": 28024, "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" }, "28019": { "city_x_agent.id": 28019, "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" }, "28025": { "city_x_agent.id": 28025, "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" }, "28021": { "city_x_agent.id": 28021, "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" }, "28018": { "city_x_agent.id": 28018, "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" }, "12": { "city.id": 12, "city.ts": "2017-09-05 22:25:53", "city.title": "Birmingham", "city.city_x_agent_id": { "28365": { "city_x_agent.id": 28365, "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" }, "28362": { "city_x_agent.id": 28362, "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" }, "28356": { "city_x_agent.id": 28356, "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" }, "28352": { "city_x_agent.id": 28352, "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" }, "85": { "city_x_agent.id": 85, "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" }, "28354": { "city_x_agent.id": 28354, "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" }, "28371": { "city_x_agent.id": 28371, "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" }, "28370": { "city_x_agent.id": 28370, "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" }, "28369": { "city_x_agent.id": 28369, "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" }, "28367": { "city_x_agent.id": 28367, "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" }, "28357": { "city_x_agent.id": 28357, "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" }, "82": { "city_x_agent.id": 82, "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" }, "76": { "city_x_agent.id": 76, "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" }, "28348": { "city_x_agent.id": 28348, "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" }, "28368": { "city_x_agent.id": 28368, "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" }, "28347": { "city_x_agent.id": 28347, "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" }, "28349": { "city_x_agent.id": 28349, "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" }, "77": { "city_x_agent.id": 77, "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" }, "78": { "city_x_agent.id": 78, "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" }, "80": { "city_x_agent.id": 80, "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" }, "81": { "city_x_agent.id": 81, "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" }, "83": { "city_x_agent.id": 83, "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" }, "84": { "city_x_agent.id": 84, "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" }, "28364": { "city_x_agent.id": 28364, "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" }, "28353": { "city_x_agent.id": 28353, "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" }, "28351": { "city_x_agent.id": 28351, "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" }, "28366": { "city_x_agent.id": 28366, "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" }, "28350": { "city_x_agent.id": 28350, "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" }, "28361": { "city_x_agent.id": 28361, "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" }, "28332": { "city_x_agent.id": 28332, "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" }, "28333": { "city_x_agent.id": 28333, "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" }, "28355": { "city_x_agent.id": 28355, "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" }, "28359": { "city_x_agent.id": 28359, "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" }, "28334": { "city_x_agent.id": 28334, "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" }, "28337": { "city_x_agent.id": 28337, "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" }, "28335": { "city_x_agent.id": 28335, "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" }, "28363": { "city_x_agent.id": 28363, "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" }, "28358": { "city_x_agent.id": 28358, "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" }, "28360": { "city_x_agent.id": 28360, "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" }, "28344": { "city_x_agent.id": 28344, "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" }, "28343": { "city_x_agent.id": 28343, "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" }, "28345": { "city_x_agent.id": 28345, "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" }, "28346": { "city_x_agent.id": 28346, "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" }, "28341": { "city_x_agent.id": 28341, "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" }, "28342": { "city_x_agent.id": 28342, "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" }, "28339": { "city_x_agent.id": 28339, "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" }, "28340": { "city_x_agent.id": 28340, "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" }, "28338": { "city_x_agent.id": 28338, "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" }, "28336": { "city_x_agent.id": 28336, "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" }, "13": { "city.id": 13, "city.ts": "2017-08-15 02:34:15", "city.title": "Boaz", "city.city_x_agent_id": { "87": { "city_x_agent.id": 87, "agent.id": 15, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "15.57 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US Highway 431 N", "agent.address_locality": "Albertville, AL 35950-0153" }, "86": { "city_x_agent.id": 86, "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" }, "89": { "city_x_agent.id": 89, "agent.id": 17, "agent.ts": "2017-09-05 22:10:04", "agent.title": "RANDY JONES & ASSOCIATES INC", "agent.pull_right": "15.58 mi", "agent.phone_number": "(256) 878-3271", "agent.street_address": "8600 US HIGHWAY 431", "agent.address_locality": "Albertville, AL 35950-0153" }, "88": { "city_x_agent.id": 88, "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" }, "90": { "city_x_agent.id": 90, "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" }, "91": { "city_x_agent.id": 91, "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" }, "94": { "city_x_agent.id": 94, "agent.id": 21, "agent.ts": "2017-09-05 21:45:20", "agent.title": "TONYA WILLIAMS INS AGENCY INC", "agent.pull_right": "0.86 mi", "agent.phone_number": "(256) 736-2638", "agent.street_address": "1014 N BRINDLEE MOUNTAIN PKWY", "agent.address_locality": "Arab, AL 35016-1095" }, "92": { "city_x_agent.id": 92, "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" }, "93": { "city_x_agent.id": 93, "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" }, "95": { "city_x_agent.id": 95, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "14": { "city.id": 14, "city.ts": "2017-08-15 02:34:15", "city.title": "Brewton", "city.city_x_agent_id": { "96": { "city_x_agent.id": 96, "agent.id": 96, "agent.ts": "2017-09-05 05:18:28", "agent.title": "Sandra Dockery", "agent.pull_right": "0.04 mi", "agent.phone_number": "(251) 377-5857", "agent.street_address": "109 Saint Joseph Ave Ste 103", "agent.address_locality": "Brewton, AL 36426" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "15": { "city.id": 15, "city.ts": "2017-08-15 02:34:15", "city.title": "Centre", "city.city_x_agent_id": { "98": { "city_x_agent.id": 98, "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" }, "100": { "city_x_agent.id": 100, "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" }, "101": { "city_x_agent.id": 101, "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" }, "102": { "city_x_agent.id": 102, "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" }, "97": { "city_x_agent.id": 97, "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" }, "99": { "city_x_agent.id": 99, "agent.id": 99, "agent.ts": "2017-09-05 05:21:03", "agent.title": "Chris Davis", "agent.pull_right": "1.58 mi", "agent.phone_number": "(256) 845-5116", "agent.street_address": "2121 Gault Ave N", "agent.address_locality": "Fort Payne, AL 35967" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "16": { "city.id": 16, "city.ts": "2017-09-05 22:26:23", "city.title": "Chelsea", "city.city_x_agent_id": { "28396": { "city_x_agent.id": 28396, "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" }, "28391": { "city_x_agent.id": 28391, "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" }, "109": { "city_x_agent.id": 109, "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" }, "28390": { "city_x_agent.id": 28390, "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" }, "28389": { "city_x_agent.id": 28389, "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" }, "107": { "city_x_agent.id": 107, "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" }, "28386": { "city_x_agent.id": 28386, "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" }, "28385": { "city_x_agent.id": 28385, "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" }, "28382": { "city_x_agent.id": 28382, "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" }, "28417": { "city_x_agent.id": 28417, "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" }, "28401": { "city_x_agent.id": 28401, "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" }, "28392": { "city_x_agent.id": 28392, "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" }, "28395": { "city_x_agent.id": 28395, "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" }, "28420": { "city_x_agent.id": 28420, "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" }, "28418": { "city_x_agent.id": 28418, "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" }, "28414": { "city_x_agent.id": 28414, "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" }, "28411": { "city_x_agent.id": 28411, "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" }, "28394": { "city_x_agent.id": 28394, "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" }, "28405": { "city_x_agent.id": 28405, "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" }, "28403": { "city_x_agent.id": 28403, "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" }, "110": { "city_x_agent.id": 110, "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" }, "108": { "city_x_agent.id": 108, "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" }, "105": { "city_x_agent.id": 105, "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" }, "103": { "city_x_agent.id": 103, "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" }, "104": { "city_x_agent.id": 104, "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" }, "106": { "city_x_agent.id": 106, "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" }, "111": { "city_x_agent.id": 111, "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" }, "112": { "city_x_agent.id": 112, "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" }, "28398": { "city_x_agent.id": 28398, "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" }, "28393": { "city_x_agent.id": 28393, "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" }, "28397": { "city_x_agent.id": 28397, "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" }, "28413": { "city_x_agent.id": 28413, "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" }, "28409": { "city_x_agent.id": 28409, "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" }, "28400": { "city_x_agent.id": 28400, "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" }, "28404": { "city_x_agent.id": 28404, "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" }, "28407": { "city_x_agent.id": 28407, "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" }, "28421": { "city_x_agent.id": 28421, "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" }, "28408": { "city_x_agent.id": 28408, "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" }, "28399": { "city_x_agent.id": 28399, "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" }, "28402": { "city_x_agent.id": 28402, "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" }, "28415": { "city_x_agent.id": 28415, "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" }, "28412": { "city_x_agent.id": 28412, "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" }, "28383": { "city_x_agent.id": 28383, "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" }, "28384": { "city_x_agent.id": 28384, "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" }, "28387": { "city_x_agent.id": 28387, "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" }, "28388": { "city_x_agent.id": 28388, "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" }, "28416": { "city_x_agent.id": 28416, "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" }, "28410": { "city_x_agent.id": 28410, "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" }, "28419": { "city_x_agent.id": 28419, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "17": { "city.id": 17, "city.ts": "2017-09-05 22:26:48", "city.title": "Childersburg", "city.city_x_agent_id": { "28432": { "city_x_agent.id": 28432, "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" }, "28443": { "city_x_agent.id": 28443, "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" }, "28435": { "city_x_agent.id": 28435, "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" }, "28433": { "city_x_agent.id": 28433, "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" }, "122": { "city_x_agent.id": 122, "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" }, "120": { "city_x_agent.id": 120, "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" }, "116": { "city_x_agent.id": 116, "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" }, "117": { "city_x_agent.id": 117, "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" }, "121": { "city_x_agent.id": 121, "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" }, "28436": { "city_x_agent.id": 28436, "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" }, "28437": { "city_x_agent.id": 28437, "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" }, "113": { "city_x_agent.id": 113, "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" }, "114": { "city_x_agent.id": 114, "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" }, "115": { "city_x_agent.id": 115, "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" }, "118": { "city_x_agent.id": 118, "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" }, "119": { "city_x_agent.id": 119, "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" }, "28434": { "city_x_agent.id": 28434, "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" }, "28440": { "city_x_agent.id": 28440, "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" }, "28438": { "city_x_agent.id": 28438, "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" }, "28439": { "city_x_agent.id": 28439, "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" }, "28441": { "city_x_agent.id": 28441, "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" }, "28442": { "city_x_agent.id": 28442, "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" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" }, "18": { "city.id": 18, "city.ts": "2017-08-15 02:34:15", "city.title": "Clanton", "city.city_x_agent_id": { "124": { "city_x_agent.id": 124, "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" }, "123": { "city_x_agent.id": 123, "agent.id": 123, "agent.ts": "2017-09-05 05:19:04", "agent.title": "Beth Hicks", "agent.pull_right": "2.16 mi", "agent.phone_number": "(205) 755-7283", "agent.street_address": "1429 7th St S", "agent.address_locality": "Clanton, AL 35045-3746" }, "125": { "city_x_agent.id": 125, "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" }, "19": { "city.id": 19, "city.ts": "2017-09-05 22:27:07", "city.title": "Columbiana", "city.city_x_agent_id": { "129": { "city_x_agent.id": 129, "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" }, "130": { "city_x_agent.id": 130, "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" }, "131": { "city_x_agent.id": 131, "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" }, "28455": { "city_x_agent.id": 28455, "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" }, "28456": { "city_x_agent.id": 28456, "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" }, "132": { "city_x_agent.id": 132, "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" }, "28465": { "city_x_agent.id": 28465, "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" }, "28464": { "city_x_agent.id": 28464, "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" }, "28463": { "city_x_agent.id": 28463, "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" }, "28469": { "city_x_agent.id": 28469, "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" }, "28458": { "city_x_agent.id": 28458, "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" }, "28461": { "city_x_agent.id": 28461, "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" }, "28478": { "city_x_agent.id": 28478, "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" }, "28470": { "city_x_agent.id": 28470, "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" }, "28475": { "city_x_agent.id": 28475, "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" }, "28471": { "city_x_agent.id": 28471, "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" }, "28460": { "city_x_agent.id": 28460, "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" }, "28459": { "city_x_agent.id": 28459, "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" }, "28457": { "city_x_agent.id": 28457, "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" }, "28454": { "city_x_agent.id": 28454, "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" }, "128": { "city_x_agent.id": 128, "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" }, "135": { "city_x_agent.id": 135, "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" }, "133": { "city_x_agent.id": 133, "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" }, "28467": { "city_x_agent.id": 28467, "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" }, "28468": { "city_x_agent.id": 28468, "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" }, "134": { "city_x_agent.id": 134, "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" }, "28466": { "city_x_agent.id": 28466, "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" }, "126": { "city_x_agent.id": 126, "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" }, "28462": { "city_x_agent.id": 28462, "agent.id": 123, "agent.ts": "2017-09-05 05:19:04", "agent.title": "Beth Hicks", "agent.pull_right": "2.16 mi", "agent.phone_number": "(205) 755-7283", "agent.street_address": "1429 7th St S", "agent.address_locality": "Clanton, AL 35045-3746" }, "127": { "city_x_agent.id": 127, "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" }, "28484": { "city_x_agent.id": 28484, "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" }, "28485": { "city_x_agent.id": 28485, "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" }, "28482": { "city_x_agent.id": 28482, "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" }, "28474": { "city_x_agent.id": 28474, "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" }, "28472": { "city_x_agent.id": 28472, "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" }, "28473": { "city_x_agent.id": 28473, "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" }, "28476": { "city_x_agent.id": 28476, "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" }, "28477": { "city_x_agent.id": 28477, "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" }, "28480": { "city_x_agent.id": 28480, "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" }, "28479": { "city_x_agent.id": 28479, "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" }, "28481": { "city_x_agent.id": 28481, "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" }, "28483": { "city_x_agent.id": 28483, "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" }, "20": { "city.id": 20, "city.ts": "2017-08-15 02:34:15", "city.title": "Cullman", "city.city_x_agent_id": { "143": { "city_x_agent.id": 143, "agent.id": 21, "agent.ts": "2017-09-05 21:45:20", "agent.title": "TONYA WILLIAMS INS AGENCY INC", "agent.pull_right": "0.86 mi", "agent.phone_number": "(256) 736-2638", "agent.street_address": "1014 N BRINDLEE MOUNTAIN PKWY", "agent.address_locality": "Arab, AL 35016-1095" }, "136": { "city_x_agent.id": 136, "agent.id": 37, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Martha Burchell", "agent.pull_right": "22.56 mi", "agent.phone_number": "(256) 737-7450", "agent.street_address": "101 Main Ave NW", "agent.address_locality": "Cullman, AL 35055-3514" }, "137": { "city_x_agent.id": 137, "agent.id": 40, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "23.95 mi", "agent.phone_number": "(256) 739-2520", "agent.street_address": "7434 AL Hwy 157", "agent.address_locality": "Cullman, AL 35057" }, "139": { "city_x_agent.id": 139, "agent.id": 41, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Randy Jones", "agent.pull_right": "23.98 mi", "agent.phone_number": "(256) 352-9992", "agent.street_address": "103 Commercial St SE", "agent.address_locality": "Hanceville, AL 35077" }, "138": { "city_x_agent.id": 138, "agent.id": 42, "agent.ts": "2017-09-05 21:45:20", "agent.title": "Amber Milne", "agent.pull_right": "24.00 mi", "agent.phone_number": "(256) 352-9992", "agent.street_address": "103 Commercial St", "agent.address_locality": "Hanceville, AL 35077" }, "140": { "city_x_agent.id": 140, "agent.id": 140, "agent.ts": "2017-09-05 22:10:04", "agent.title": "FREEDOM INSURANCE AGENCY LLC", "agent.pull_right": "20.58 mi", "agent.phone_number": "(256) 737-0011", "agent.street_address": "168 COUNTY ROAD 1435", "agent.address_locality": "Cullman, AL 35058-5600" }, "141": { "city_x_agent.id": 141, "agent.id": 141, "agent.ts": "2017-09-05 22:14:01", "agent.title": "Larry Akin", "agent.pull_right": "19.87 mi", "agent.phone_number": "(256) 355-8500", "agent.street_address": "468 Highway 67 S", "agent.address_locality": "Decatur, AL 35603" }, "142": { "city_x_agent.id": 142, "agent.id": 142, "agent.ts": "2017-09-05 05:21:51", "agent.title": "PECK GLASGOW AGENCY INC", "agent.pull_right": "1.08 mi", "agent.phone_number": "(256) 773-2210", "agent.street_address": "1612 HIGHWAY 31 SW", "agent.address_locality": "Hartselle, AL 35640-2826" } }, "state.id": 1, "state.ts": "2017-08-01 23:07:39", "state.title": "Alabama" } } } }