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": "Electrician Information Of USA 2", "desc": "Electrician Information Of USA Data Set ", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/electrician_information_of_USA_2/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/electrician_information_of_USA_2/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/electrician_information_of_USA_2/main/list/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/electrician_information_of_USA_2/main/list/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 3, "limit_total": 400, "time": 0.06479000000000000036859404417555197142064571380615234375 }, "stats": { "raw_rows": 3, "rows": 3, "rows_total": 5094, "pages_total": 1698 }, "struct": { "stem": { "0": "electrician" }, "leaf": "electrician.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "8": { "electrician.id": 8, "electrician.ts": "2018-10-13 00:04:58", "electrician.title": "Burnett Electric", "electrician.telephone": "(205) 826-3643", "electrician.address": "15953 Annie Bell Drive", "electrician.zip_code": 35446, "electrician.score": 100, "electrician.votes": "", "electrician.description": "With over 33 over of experience serving Tuscaloosa County and the surrounding area, Shad Burnett is the solution for all your electrical needs. We take great pride in our extreme professionalism, timeliness and superior customer service on every job. We make sure to develop a lasting relationship so that the next time service is needed, there will be no question on who to call. Satisfaction guaranteed!", "electrician.locality": "Buhl", "electrician.business_overview": "", "electrician.website": "", "electrician.since": 1985, "electrician.city_x_electrician_id": { "8": { "city_x_electrician.id": 8, "city.id": 2, "city.ts": "2018-11-08 04:12:50", "city.city": "Abernant", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "115": { "city_x_electrician.id": 115, "city.id": 12, "city.ts": "2018-11-08 04:12:50", "city.city": "Aliceville", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "507": { "city_x_electrician.id": 507, "city.id": 54, "city.ts": "2018-11-08 04:12:50", "city.city": "Boligee", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "631": { "city_x_electrician.id": 631, "city.id": 68, "city.ts": "2018-11-08 04:12:50", "city.city": "Brookwood", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "680": { "city_x_electrician.id": 680, "city.id": 73, "city.ts": "2018-11-08 04:12:50", "city.city": "Buhl", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "761": { "city_x_electrician.id": 761, "city.id": 83, "city.ts": "2018-11-08 04:12:50", "city.city": "Carrollton", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "963": { "city_x_electrician.id": 963, "city.id": 107, "city.ts": "2018-11-08 04:12:50", "city.city": "Coaling", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "997": { "city_x_electrician.id": 997, "city.id": 111, "city.ts": "2018-11-08 04:12:50", "city.city": "Coker", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1062": { "city_x_electrician.id": 1062, "city.id": 117, "city.ts": "2018-11-08 04:12:50", "city.city": "Cottondale", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1363": { "city_x_electrician.id": 1363, "city.id": 152, "city.ts": "2018-11-08 04:12:50", "city.city": "Duncanville", "state_x_letter.id": 4, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 4, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "D" }, "1392": { "city_x_electrician.id": 1392, "city.id": 155, "city.ts": "2018-11-08 04:12:50", "city.city": "Echola", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1481": { "city_x_electrician.id": 1481, "city.id": 164, "city.ts": "2018-11-08 04:12:50", "city.city": "Elrod", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1535": { "city_x_electrician.id": 1535, "city.id": 171, "city.ts": "2018-11-08 04:12:50", "city.city": "Ethelsville", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1547": { "city_x_electrician.id": 1547, "city.id": 173, "city.ts": "2018-11-08 04:12:50", "city.city": "Eutaw", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1719": { "city_x_electrician.id": 1719, "city.id": 194, "city.ts": "2018-11-08 04:12:50", "city.city": "Fosters", "state_x_letter.id": 6, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 6, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "F" }, "1918": { "city_x_electrician.id": 1918, "city.id": 218, "city.ts": "2018-11-08 04:12:50", "city.city": "Gordo", "state_x_letter.id": 7, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 7, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "G" }, "2343": { "city_x_electrician.id": 2343, "city.id": 267, "city.ts": "2018-11-08 04:12:50", "city.city": "Jasper", "state_x_letter.id": 10, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 10, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "J" }, "2387": { "city_x_electrician.id": 2387, "city.id": 273, "city.ts": "2018-11-08 04:12:50", "city.city": "Kellerman", "state_x_letter.id": 11, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 11, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "K" }, "2457": { "city_x_electrician.id": 2457, "city.id": 280, "city.ts": "2018-11-08 04:12:50", "city.city": "Knoxville", "state_x_letter.id": 11, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 11, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "K" }, "2997": { "city_x_electrician.id": 2997, "city.id": 342, "city.ts": "2018-11-08 04:12:50", "city.city": "Moundville", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "3202": { "city_x_electrician.id": 3202, "city.id": 364, "city.ts": "2018-11-08 04:12:50", "city.city": "Northport", "state_x_letter.id": 14, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 14, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "N" }, "3459": { "city_x_electrician.id": 3459, "city.id": 390, "city.ts": "2018-11-08 04:12:50", "city.city": "Peterson", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3683": { "city_x_electrician.id": 3683, "city.id": 416, "city.ts": "2018-11-08 04:12:50", "city.city": "Reform", "state_x_letter.id": 18, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 18, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "R" }, "3833": { "city_x_electrician.id": 3833, "city.id": 433, "city.ts": "2018-11-08 04:12:50", "city.city": "Samantha", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4401": { "city_x_electrician.id": 4401, "city.id": 492, "city.ts": "2018-11-08 04:12:50", "city.city": "Tuscaloosa", "state_x_letter.id": 20, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 20, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "T" }, "4488": { "city_x_electrician.id": 4488, "city.id": 503, "city.ts": "2018-11-08 04:12:50", "city.city": "Vance", "state_x_letter.id": 22, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 22, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "V" } }, "electrician.electrician_x_achievement_id": {}, "electrician.electrician_x_service_area_id": { "802": { "electrician_x_service_area.id": 802, "service_area.id": 39, "service_area.ts": "2018-04-11 05:44:26", "service_area.area": "Tuscaloosa" }, "803": { "electrician_x_service_area.id": 803, "service_area.id": 214, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Jasper" }, "804": { "electrician_x_service_area.id": 804, "service_area.id": 222, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Northport" }, "805": { "electrician_x_service_area.id": 805, "service_area.id": 234, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Coaling" }, "826": { "electrician_x_service_area.id": 826, "service_area.id": 259, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Peterson" }, "827": { "electrician_x_service_area.id": 827, "service_area.id": 270, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Fosters" }, "811": { "electrician_x_service_area.id": 811, "service_area.id": 581, "service_area.ts": "2018-10-13 00:03:22", "service_area.area": "Knoxville" }, "819": { "electrician_x_service_area.id": 819, "service_area.id": 619, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Brookwood" }, "821": { "electrician_x_service_area.id": 821, "service_area.id": 623, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Abernant" }, "824": { "electrician_x_service_area.id": 824, "service_area.id": 648, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Duncanville" }, "823": { "electrician_x_service_area.id": 823, "service_area.id": 655, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Boligee" }, "806": { "electrician_x_service_area.id": 806, "service_area.id": 657, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Elrod" }, "807": { "electrician_x_service_area.id": 807, "service_area.id": 658, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Gordo" }, "808": { "electrician_x_service_area.id": 808, "service_area.id": 659, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Vance" }, "809": { "electrician_x_service_area.id": 809, "service_area.id": 660, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Samantha" }, "810": { "electrician_x_service_area.id": 810, "service_area.id": 670, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Aliceville" }, "812": { "electrician_x_service_area.id": 812, "service_area.id": 671, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Coker" }, "813": { "electrician_x_service_area.id": 813, "service_area.id": 672, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Echola" }, "814": { "electrician_x_service_area.id": 814, "service_area.id": 674, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Carrollton" }, "815": { "electrician_x_service_area.id": 815, "service_area.id": 681, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Eutaw" }, "816": { "electrician_x_service_area.id": 816, "service_area.id": 683, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Cottondale" }, "817": { "electrician_x_service_area.id": 817, "service_area.id": 684, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Buhl" }, "818": { "electrician_x_service_area.id": 818, "service_area.id": 685, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Ethelsville" }, "820": { "electrician_x_service_area.id": 820, "service_area.id": 691, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Kellerman" }, "822": { "electrician_x_service_area.id": 822, "service_area.id": 698, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Moundville" }, "825": { "electrician_x_service_area.id": 825, "service_area.id": 700, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Reform" } }, "electrician.service_category_id": { "20": { "service_category.id": 20, "service_category.ts": "2018-10-13 00:04:58", "service_category.title": "Electrical", "service_category.service_id": { "69": { "service.id": 69, "service.ts": "2018-10-13 00:04:58", "service.service": "Home Addition or Remodel Electrical Installation" }, "70": { "service.id": 70, "service.ts": "2018-10-13 00:04:58", "service.service": "Electric Wiring Upgrade" }, "71": { "service.id": 71, "service.ts": "2018-10-13 00:04:58", "service.service": "Electric Outlets & Fixtures Install" } } } }, "electrician.electrician_x_expertise_id": { "23": { "electrician_x_expertise.id": 23, "expertise.id": 23, "expertise.ts": "2018-10-13 00:04:58", "expertise.expertise": "Electrical Switches, Outlets & Fixtures - Install or Repair" } }, "electrician.business_hour_id": {}, "electrician.quick_fact_id": { "17": { "quick_fact.id": 17, "quick_fact.ts": "2018-10-13 00:04:58", "quick_fact.title": "Free Estimates" }, "18": { "quick_fact.id": 18, "quick_fact.ts": "2018-10-13 00:04:58", "quick_fact.title": "Credit Cards Accepted" } }, "electrician.license_id": {}, "electrician.image_slug_id": {} }, "9": { "electrician.id": 9, "electrician.ts": "2018-10-13 00:05:02", "electrician.title": "Rushing Electric, Inc.", "electrician.telephone": "(205) 331-7904", "electrician.address": "1104 26th Avenue", "electrician.zip_code": 35476, "electrician.score": 98, "electrician.votes": 15, "electrician.description": "We are a locally owned and operated company that values honesty and integrity and treats your home as if it were our own. We have many years of experience to give you confidence that we are your number one choice for your next home project. You will find us to be competitively priced with close attention to the details. We look forward to building a lasting relationship and guarantee your satisfaction!", "electrician.locality": "North Port", "electrician.business_overview": "We started in this industry in 1986. We describe our business as Up and coming", "electrician.website": "", "electrician.since": 2009, "electrician.city_x_electrician_id": { "9": { "city_x_electrician.id": 9, "city.id": 2, "city.ts": "2018-11-08 04:12:50", "city.city": "Abernant", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "61": { "city_x_electrician.id": 61, "city.id": 6, "city.ts": "2018-11-08 04:12:50", "city.city": "Akron", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "116": { "city_x_electrician.id": 116, "city.id": 12, "city.ts": "2018-11-08 04:12:50", "city.city": "Aliceville", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "345": { "city_x_electrician.id": 345, "city.id": 37, "city.ts": "2018-11-08 04:12:50", "city.city": "Bankston", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "391": { "city_x_electrician.id": 391, "city.id": 43, "city.ts": "2018-11-08 04:12:50", "city.city": "Belk", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "419": { "city_x_electrician.id": 419, "city.id": 47, "city.ts": "2018-11-08 04:12:50", "city.city": "Berry", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "508": { "city_x_electrician.id": 508, "city.id": 54, "city.ts": "2018-11-08 04:12:50", "city.city": "Boligee", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "566": { "city_x_electrician.id": 566, "city.id": 61, "city.ts": "2018-11-08 04:12:50", "city.city": "Brent", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "587": { "city_x_electrician.id": 587, "city.id": 64, "city.ts": "2018-11-08 04:12:50", "city.city": "Brierfield", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "632": { "city_x_electrician.id": 632, "city.id": 68, "city.ts": "2018-11-08 04:12:50", "city.city": "Brookwood", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "683": { "city_x_electrician.id": 683, "city.id": 73, "city.ts": "2018-11-08 04:12:50", "city.city": "Buhl", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "762": { "city_x_electrician.id": 762, "city.id": 83, "city.ts": "2018-11-08 04:12:50", "city.city": "Carrollton", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "802": { "city_x_electrician.id": 802, "city.id": 89, "city.ts": "2018-11-08 04:12:50", "city.city": "Centreville", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "938": { "city_x_electrician.id": 938, "city.id": 103, "city.ts": "2018-11-08 04:12:50", "city.city": "Clinton", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "964": { "city_x_electrician.id": 964, "city.id": 107, "city.ts": "2018-11-08 04:12:50", "city.city": "Coaling", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "998": { "city_x_electrician.id": 998, "city.id": 111, "city.ts": "2018-11-08 04:12:50", "city.city": "Coker", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1063": { "city_x_electrician.id": 1063, "city.id": 117, "city.ts": "2018-11-08 04:12:50", "city.city": "Cottondale", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1364": { "city_x_electrician.id": 1364, "city.id": 152, "city.ts": "2018-11-08 04:12:50", "city.city": "Duncanville", "state_x_letter.id": 4, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 4, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "D" }, "1393": { "city_x_electrician.id": 1393, "city.id": 155, "city.ts": "2018-11-08 04:12:50", "city.city": "Echola", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1482": { "city_x_electrician.id": 1482, "city.id": 164, "city.ts": "2018-11-08 04:12:50", "city.city": "Elrod", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1536": { "city_x_electrician.id": 1536, "city.id": 171, "city.ts": "2018-11-08 04:12:50", "city.city": "Ethelsville", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1548": { "city_x_electrician.id": 1548, "city.id": 173, "city.ts": "2018-11-08 04:12:50", "city.city": "Eutaw", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1720": { "city_x_electrician.id": 1720, "city.id": 194, "city.ts": "2018-11-08 04:12:50", "city.city": "Fosters", "state_x_letter.id": 6, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 6, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "F" }, "1919": { "city_x_electrician.id": 1919, "city.id": 218, "city.ts": "2018-11-08 04:12:50", "city.city": "Gordo", "state_x_letter.id": 7, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 7, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "G" }, "1994": { "city_x_electrician.id": 1994, "city.id": 226, "city.ts": "2018-11-08 04:12:50", "city.city": "Green Pond", "state_x_letter.id": 7, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 7, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "G" }, "2388": { "city_x_electrician.id": 2388, "city.id": 273, "city.ts": "2018-11-08 04:12:50", "city.city": "Kellerman", "state_x_letter.id": 11, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 11, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "K" }, "2404": { "city_x_electrician.id": 2404, "city.id": 275, "city.ts": "2018-11-08 04:12:50", "city.city": "Kennedy", "state_x_letter.id": 11, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 11, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "K" }, "2458": { "city_x_electrician.id": 2458, "city.id": 280, "city.ts": "2018-11-08 04:12:50", "city.city": "Knoxville", "state_x_letter.id": 11, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 11, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "K" }, "2786": { "city_x_electrician.id": 2786, "city.id": 319, "city.ts": "2018-11-08 04:12:50", "city.city": "Marion", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "2998": { "city_x_electrician.id": 2998, "city.id": 342, "city.ts": "2018-11-08 04:12:50", "city.city": "Moundville", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "3204": { "city_x_electrician.id": 3204, "city.id": 364, "city.ts": "2018-11-08 04:12:50", "city.city": "Northport", "state_x_letter.id": 14, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 14, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "N" }, "3225": { "city_x_electrician.id": 3225, "city.id": 367, "city.ts": "2018-11-08 04:12:50", "city.city": "Oakman", "state_x_letter.id": 15, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 15, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "O" }, "3460": { "city_x_electrician.id": 3460, "city.id": 390, "city.ts": "2018-11-08 04:12:50", "city.city": "Peterson", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3684": { "city_x_electrician.id": 3684, "city.id": 416, "city.ts": "2018-11-08 04:12:50", "city.city": "Reform", "state_x_letter.id": 18, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 18, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "R" }, "3834": { "city_x_electrician.id": 3834, "city.id": 433, "city.ts": "2018-11-08 04:12:50", "city.city": "Samantha", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "3876": { "city_x_electrician.id": 3876, "city.id": 438, "city.ts": "2018-11-08 04:12:50", "city.city": "Sawyerville", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4403": { "city_x_electrician.id": 4403, "city.id": 492, "city.ts": "2018-11-08 04:12:50", "city.city": "Tuscaloosa", "state_x_letter.id": 20, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 20, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "T" }, "4489": { "city_x_electrician.id": 4489, "city.id": 503, "city.ts": "2018-11-08 04:12:50", "city.city": "Vance", "state_x_letter.id": 22, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 22, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "V" }, "4689": { "city_x_electrician.id": 4689, "city.id": 525, "city.ts": "2018-11-08 04:12:50", "city.city": "West Blocton", "state_x_letter.id": 23, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 23, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "W" }, "4768": { "city_x_electrician.id": 4768, "city.id": 534, "city.ts": "2018-11-08 04:12:50", "city.city": "Woodstock", "state_x_letter.id": 23, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 23, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "W" } }, "electrician.electrician_x_achievement_id": { "40": { "electrician_x_achievement.id": 40, "achievement.id": 1, "achievement.ts": "2018-04-11 05:44:26", "achievement.achievement": "Top Rated Professional", "achievement.description": "Homeowners have given this pro an overall top rating and would highly recommend them to others." }, "41": { "electrician_x_achievement.id": 41, "achievement.id": 2, "achievement.ts": "2018-04-11 05:44:26", "achievement.achievement": "Elite Service Professional", "achievement.description": "Homeowners have rated this pro highly for superior customer service." }, "42": { "electrician_x_achievement.id": 42, "achievement.id": 3, "achievement.ts": "2018-04-11 05:44:26", "achievement.achievement": "Seal of Approval", "achievement.description": "This pro has passed the HomeAdvisor screening process." }, "44": { "electrician_x_achievement.id": 44, "achievement.id": 5, "achievement.ts": "2018-04-11 05:44:26", "achievement.achievement": "Best of HomeAdvisor", "achievement.description": "This pro was rated as the best of the best by HomeAdvisor." }, "43": { "electrician_x_achievement.id": 43, "achievement.id": 29, "achievement.ts": "2018-10-13 00:03:31", "achievement.achievement": "One Year With HomeAdvisor", "achievement.description": "This pro has been an active member of the HomeAdvisor network for 1 Year." } }, "electrician.electrician_x_service_area_id": { "828": { "electrician_x_service_area.id": 828, "service_area.id": 39, "service_area.ts": "2018-04-11 05:44:26", "service_area.area": "Tuscaloosa" }, "829": { "electrician_x_service_area.id": 829, "service_area.id": 222, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Northport" }, "830": { "electrician_x_service_area.id": 830, "service_area.id": 234, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Coaling" }, "867": { "electrician_x_service_area.id": 867, "service_area.id": 259, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Peterson" }, "868": { "electrician_x_service_area.id": 868, "service_area.id": 270, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Fosters" }, "865": { "electrician_x_service_area.id": 865, "service_area.id": 278, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Woodstock" }, "831": { "electrician_x_service_area.id": 831, "service_area.id": 279, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Berry" }, "832": { "electrician_x_service_area.id": 832, "service_area.id": 285, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Kennedy" }, "847": { "electrician_x_service_area.id": 847, "service_area.id": 581, "service_area.ts": "2018-10-13 00:03:22", "service_area.area": "Knoxville" }, "844": { "electrician_x_service_area.id": 844, "service_area.id": 589, "service_area.ts": "2018-10-13 00:03:22", "service_area.area": "Akron" }, "860": { "electrician_x_service_area.id": 860, "service_area.id": 619, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Brookwood" }, "862": { "electrician_x_service_area.id": 862, "service_area.id": 623, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Abernant" }, "833": { "electrician_x_service_area.id": 833, "service_area.id": 647, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Sawyerville" }, "834": { "electrician_x_service_area.id": 834, "service_area.id": 648, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Duncanville" }, "835": { "electrician_x_service_area.id": 835, "service_area.id": 650, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Belk" }, "836": { "electrician_x_service_area.id": 836, "service_area.id": 652, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Centreville" }, "837": { "electrician_x_service_area.id": 837, "service_area.id": 655, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Boligee" }, "838": { "electrician_x_service_area.id": 838, "service_area.id": 656, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "West Blocton" }, "839": { "electrician_x_service_area.id": 839, "service_area.id": 657, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Elrod" }, "840": { "electrician_x_service_area.id": 840, "service_area.id": 658, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Gordo" }, "841": { "electrician_x_service_area.id": 841, "service_area.id": 659, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Vance" }, "842": { "electrician_x_service_area.id": 842, "service_area.id": 660, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Samantha" }, "843": { "electrician_x_service_area.id": 843, "service_area.id": 663, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Clinton" }, "845": { "electrician_x_service_area.id": 845, "service_area.id": 666, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "West Greene" }, "846": { "electrician_x_service_area.id": 846, "service_area.id": 670, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Aliceville" }, "848": { "electrician_x_service_area.id": 848, "service_area.id": 671, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Coker" }, "849": { "electrician_x_service_area.id": 849, "service_area.id": 672, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Echola" }, "850": { "electrician_x_service_area.id": 850, "service_area.id": 673, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Brent" }, "851": { "electrician_x_service_area.id": 851, "service_area.id": 674, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Carrollton" }, "852": { "electrician_x_service_area.id": 852, "service_area.id": 679, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Bankston" }, "853": { "electrician_x_service_area.id": 853, "service_area.id": 681, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Eutaw" }, "854": { "electrician_x_service_area.id": 854, "service_area.id": 683, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Cottondale" }, "855": { "electrician_x_service_area.id": 855, "service_area.id": 684, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Buhl" }, "856": { "electrician_x_service_area.id": 856, "service_area.id": 685, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Ethelsville" }, "857": { "electrician_x_service_area.id": 857, "service_area.id": 687, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Marion" }, "858": { "electrician_x_service_area.id": 858, "service_area.id": 688, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Brierfield" }, "859": { "electrician_x_service_area.id": 859, "service_area.id": 689, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Oakman" }, "861": { "electrician_x_service_area.id": 861, "service_area.id": 691, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Kellerman" }, "863": { "electrician_x_service_area.id": 863, "service_area.id": 695, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Green Pond" }, "864": { "electrician_x_service_area.id": 864, "service_area.id": 698, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Moundville" }, "866": { "electrician_x_service_area.id": 866, "service_area.id": 700, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Reform" } }, "electrician.service_category_id": {}, "electrician.electrician_x_expertise_id": { "24": { "electrician_x_expertise.id": 24, "expertise.id": 24, "expertise.ts": "2018-10-13 00:05:03", "expertise.expertise": "Audio/Visual" }, "25": { "electrician_x_expertise.id": 25, "expertise.id": 25, "expertise.ts": "2018-10-13 00:05:03", "expertise.expertise": "Home Theater Accessory - Install" }, "26": { "electrician_x_expertise.id": 26, "expertise.id": 26, "expertise.ts": "2018-10-13 00:05:03", "expertise.expertise": "Surround Sound System - Install" } }, "electrician.business_hour_id": {}, "electrician.quick_fact_id": { "19": { "quick_fact.id": 19, "quick_fact.ts": "2018-10-13 00:05:03", "quick_fact.title": "Free Estimates" }, "20": { "quick_fact.id": 20, "quick_fact.ts": "2018-10-13 00:05:03", "quick_fact.title": "Credit Cards Accepted" } }, "electrician.license_id": { "6": { "license.id": 6, "license.ts": "2018-10-13 00:05:03", "license.trade": "Electrical Contractor", "license.license": "03401", "license.expiration": "06-30-2019" } }, "electrician.image_slug_id": {} }, "10": { "electrician.id": 10, "electrician.ts": "2018-10-13 00:05:16", "electrician.title": "Advanced Cabling Engineers", "electrician.telephone": "(205) 383-5916", "electrician.address": "4971 Caldwell Mill Lane", "electrician.zip_code": 35242, "electrician.score": 100, "electrician.votes": "", "electrician.description": "We pride our company on reliability, great communication, integrity, and quality work. We are experts in our trade and will do our best to keep you as educated as we can on your particular task or project. We look forward to earning your business! We specialize in the following: Wired and wireless device installation Router setup / troubleshooting Computer setup / repair Home theater installation / repair Commercial cabling Commercial workstation configuration", "electrician.locality": "Birmingham", "electrician.business_overview": "I chose to work in this industry because We have always had a passion for networking. Whether it be fixing a network or setting it up, it always brings us great joy to see a job all the way through. . We started in this industry in 2003. We describe our business as Up and coming Can you guys install network cables in my house and possibly my business? We would need to perform an estimate at your house, but most commercial networking is on the table.", "electrician.website": "", "electrician.since": 2008, "electrician.city_x_electrician_id": { "10": { "city_x_electrician.id": 10, "city.id": 2, "city.ts": "2018-11-08 04:12:50", "city.city": "Abernant", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "24": { "city_x_electrician.id": 24, "city.id": 3, "city.ts": "2018-11-08 04:12:50", "city.city": "Adamsville", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "49": { "city_x_electrician.id": 49, "city.id": 5, "city.ts": "2018-11-08 04:12:50", "city.city": "Adger", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "71": { "city_x_electrician.id": 71, "city.id": 7, "city.ts": "2018-11-08 04:12:50", "city.city": "Alabaster", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "124": { "city_x_electrician.id": 124, "city.id": 13, "city.ts": "2018-11-08 04:12:50", "city.city": "Allgood", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "134": { "city_x_electrician.id": 134, "city.id": 14, "city.ts": "2018-11-08 04:12:50", "city.city": "Alpine", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "150": { "city_x_electrician.id": 150, "city.id": 15, "city.ts": "2018-11-08 04:12:50", "city.city": "Alton", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "252": { "city_x_electrician.id": 252, "city.id": 27, "city.ts": "2018-11-08 04:12:50", "city.city": "Ashville", "state_x_letter.id": 1, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 1, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "A" }, "458": { "city_x_electrician.id": 458, "city.id": 50, "city.ts": "2018-11-08 04:12:50", "city.city": "Birmingham", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "513": { "city_x_electrician.id": 513, "city.id": 55, "city.ts": "2018-11-08 04:12:50", "city.city": "Bon Air", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "556": { "city_x_electrician.id": 556, "city.id": 60, "city.ts": "2018-11-08 04:12:50", "city.city": "Bremen", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "612": { "city_x_electrician.id": 612, "city.id": 67, "city.ts": "2018-11-08 04:12:50", "city.city": "Brookside", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "633": { "city_x_electrician.id": 633, "city.id": 68, "city.ts": "2018-11-08 04:12:50", "city.city": "Brookwood", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "692": { "city_x_electrician.id": 692, "city.id": 74, "city.ts": "2018-11-08 04:12:50", "city.city": "Burnwell", "state_x_letter.id": 2, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 2, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "B" }, "722": { "city_x_electrician.id": 722, "city.id": 77, "city.ts": "2018-11-08 04:12:50", "city.city": "Calera", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "831": { "city_x_electrician.id": 831, "city.id": 93, "city.ts": "2018-11-08 04:12:50", "city.city": "Chelsea", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "850": { "city_x_electrician.id": 850, "city.id": 95, "city.ts": "2018-11-08 04:12:50", "city.city": "Childersburg", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "904": { "city_x_electrician.id": 904, "city.id": 100, "city.ts": "2018-11-08 04:12:50", "city.city": "Clay", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "928": { "city_x_electrician.id": 928, "city.id": 102, "city.ts": "2018-11-08 04:12:50", "city.city": "Cleveland", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "965": { "city_x_electrician.id": 965, "city.id": 107, "city.ts": "2018-11-08 04:12:50", "city.city": "Coaling", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1013": { "city_x_electrician.id": 1013, "city.id": 113, "city.ts": "2018-11-08 04:12:50", "city.city": "Columbiana", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1025": { "city_x_electrician.id": 1025, "city.id": 114, "city.ts": "2018-11-08 04:12:50", "city.city": "Cook Springs", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1049": { "city_x_electrician.id": 1049, "city.id": 116, "city.ts": "2018-11-08 04:12:50", "city.city": "Cordova", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1064": { "city_x_electrician.id": 1064, "city.id": 117, "city.ts": "2018-11-08 04:12:50", "city.city": "Cottondale", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1127": { "city_x_electrician.id": 1127, "city.id": 126, "city.ts": "2018-11-08 04:12:50", "city.city": "Cropwell", "state_x_letter.id": 3, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 3, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "C" }, "1284": { "city_x_electrician.id": 1284, "city.id": 145, "city.ts": "2018-11-08 04:12:50", "city.city": "Docena", "state_x_letter.id": 4, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 4, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "D" }, "1304": { "city_x_electrician.id": 1304, "city.id": 146, "city.ts": "2018-11-08 04:12:50", "city.city": "Dolomite", "state_x_letter.id": 4, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 4, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "D" }, "1320": { "city_x_electrician.id": 1320, "city.id": 147, "city.ts": "2018-11-08 04:12:50", "city.city": "Dora", "state_x_letter.id": 4, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 4, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "D" }, "1365": { "city_x_electrician.id": 1365, "city.id": 152, "city.ts": "2018-11-08 04:12:50", "city.city": "Duncanville", "state_x_letter.id": 4, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 4, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "D" }, "1495": { "city_x_electrician.id": 1495, "city.id": 166, "city.ts": "2018-11-08 04:12:50", "city.city": "Empire", "state_x_letter.id": 5, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 5, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "E" }, "1775": { "city_x_electrician.id": 1775, "city.id": 201, "city.ts": "2018-11-08 04:12:50", "city.city": "Fultondale", "state_x_letter.id": 6, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 6, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "F" }, "1835": { "city_x_electrician.id": 1835, "city.id": 208, "city.ts": "2018-11-08 04:12:50", "city.city": "Garden City", "state_x_letter.id": 7, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 7, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "G" }, "1849": { "city_x_electrician.id": 1849, "city.id": 209, "city.ts": "2018-11-08 04:12:50", "city.city": "Gardendale", "state_x_letter.id": 7, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 7, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "G" }, "1903": { "city_x_electrician.id": 1903, "city.id": 216, "city.ts": "2018-11-08 04:12:50", "city.city": "Goodsprings", "state_x_letter.id": 7, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 7, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "G" }, "1977": { "city_x_electrician.id": 1977, "city.id": 225, "city.ts": "2018-11-08 04:12:50", "city.city": "Graysville", "state_x_letter.id": 7, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 7, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "G" }, "2082": { "city_x_electrician.id": 2082, "city.id": 237, "city.ts": "2018-11-08 04:12:50", "city.city": "Hanceville", "state_x_letter.id": 8, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 8, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "H" }, "2101": { "city_x_electrician.id": 2101, "city.id": 239, "city.ts": "2018-11-08 04:12:50", "city.city": "Harpersville", "state_x_letter.id": 8, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 8, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "H" }, "2150": { "city_x_electrician.id": 2150, "city.id": 244, "city.ts": "2018-11-08 04:12:50", "city.city": "Hayden", "state_x_letter.id": 8, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 8, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "H" }, "2213": { "city_x_electrician.id": 2213, "city.id": 252, "city.ts": "2018-11-08 04:12:50", "city.city": "Hollins", "state_x_letter.id": 8, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 8, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "H" }, "2344": { "city_x_electrician.id": 2344, "city.id": 267, "city.ts": "2018-11-08 04:12:50", "city.city": "Jasper", "state_x_letter.id": 10, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 10, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "J" }, "2389": { "city_x_electrician.id": 2389, "city.id": 273, "city.ts": "2018-11-08 04:12:50", "city.city": "Kellerman", "state_x_letter.id": 11, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 11, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "K" }, "2433": { "city_x_electrician.id": 2433, "city.id": 278, "city.ts": "2018-11-08 04:12:50", "city.city": "Kimberly", "state_x_letter.id": 11, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 11, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "K" }, "2515": { "city_x_electrician.id": 2515, "city.id": 287, "city.ts": "2018-11-08 04:12:50", "city.city": "Leeds", "state_x_letter.id": 12, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 12, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "L" }, "2591": { "city_x_electrician.id": 2591, "city.id": 296, "city.ts": "2018-11-08 04:12:50", "city.city": "Lincoln", "state_x_letter.id": 12, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 12, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "L" }, "2644": { "city_x_electrician.id": 2644, "city.id": 303, "city.ts": "2018-11-08 04:12:50", "city.city": "Locust Fork", "state_x_letter.id": 12, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 12, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "L" }, "2774": { "city_x_electrician.id": 2774, "city.id": 318, "city.ts": "2018-11-08 04:12:50", "city.city": "Margaret", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "2858": { "city_x_electrician.id": 2858, "city.id": 329, "city.ts": "2018-11-08 04:12:50", "city.city": "Millerville", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "2905": { "city_x_electrician.id": 2905, "city.id": 335, "city.ts": "2018-11-08 04:12:50", "city.city": "Montevallo", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "2941": { "city_x_electrician.id": 2941, "city.id": 338, "city.ts": "2018-11-08 04:12:50", "city.city": "Moody", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "2971": { "city_x_electrician.id": 2971, "city.id": 340, "city.ts": "2018-11-08 04:12:50", "city.city": "Morris", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "3025": { "city_x_electrician.id": 3025, "city.id": 345, "city.ts": "2018-11-08 04:12:50", "city.city": "Mount Olive", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "3054": { "city_x_electrician.id": 3054, "city.id": 347, "city.ts": "2018-11-08 04:12:50", "city.city": "Mulga", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "3066": { "city_x_electrician.id": 3066, "city.id": 348, "city.ts": "2018-11-08 04:12:50", "city.city": "Munford", "state_x_letter.id": 13, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 13, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "M" }, "3130": { "city_x_electrician.id": 3130, "city.id": 357, "city.ts": "2018-11-08 04:12:50", "city.city": "New Castle", "state_x_letter.id": 14, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 14, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "N" }, "3226": { "city_x_electrician.id": 3226, "city.id": 367, "city.ts": "2018-11-08 04:12:50", "city.city": "Oakman", "state_x_letter.id": 15, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 15, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "O" }, "3260": { "city_x_electrician.id": 3260, "city.id": 370, "city.ts": "2018-11-08 04:12:50", "city.city": "Oneonta", "state_x_letter.id": 15, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 15, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "O" }, "3352": { "city_x_electrician.id": 3352, "city.id": 379, "city.ts": "2018-11-08 04:12:50", "city.city": "Palmerdale", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3380": { "city_x_electrician.id": 3380, "city.id": 382, "city.ts": "2018-11-08 04:12:50", "city.city": "Parrish", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3397": { "city_x_electrician.id": 3397, "city.id": 383, "city.ts": "2018-11-08 04:12:50", "city.city": "Pelham", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3411": { "city_x_electrician.id": 3411, "city.id": 384, "city.ts": "2018-11-08 04:12:50", "city.city": "Pell City", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3461": { "city_x_electrician.id": 3461, "city.id": 390, "city.ts": "2018-11-08 04:12:50", "city.city": "Peterson", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3534": { "city_x_electrician.id": 3534, "city.id": 400, "city.ts": "2018-11-08 04:12:50", "city.city": "Pinson", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3572": { "city_x_electrician.id": 3572, "city.id": 404, "city.ts": "2018-11-08 04:12:50", "city.city": "Pleasant Grove", "state_x_letter.id": 16, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 16, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "P" }, "3619": { "city_x_electrician.id": 3619, "city.id": 408, "city.ts": "2018-11-08 04:12:50", "city.city": "Quinton", "state_x_letter.id": 17, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 17, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "Q" }, "3692": { "city_x_electrician.id": 3692, "city.id": 417, "city.ts": "2018-11-08 04:12:50", "city.city": "Remlap", "state_x_letter.id": 18, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 18, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "R" }, "3719": { "city_x_electrician.id": 3719, "city.id": 420, "city.ts": "2018-11-08 04:12:50", "city.city": "Riverside", "state_x_letter.id": 18, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 18, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "R" }, "3796": { "city_x_electrician.id": 3796, "city.id": 429, "city.ts": "2018-11-08 04:12:50", "city.city": "Saginaw", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "3946": { "city_x_electrician.id": 3946, "city.id": 445, "city.ts": "2018-11-08 04:12:50", "city.city": "Shannon", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "3970": { "city_x_electrician.id": 3970, "city.id": 447, "city.ts": "2018-11-08 04:12:50", "city.city": "Shelby", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "3999": { "city_x_electrician.id": 3999, "city.id": 451, "city.ts": "2018-11-08 04:12:50", "city.city": "Siluria", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4024": { "city_x_electrician.id": 4024, "city.id": 453, "city.ts": "2018-11-08 04:12:50", "city.city": "Sipsey", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4090": { "city_x_electrician.id": 4090, "city.id": 460, "city.ts": "2018-11-08 04:12:50", "city.city": "Springville", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4125": { "city_x_electrician.id": 4125, "city.id": 464, "city.ts": "2018-11-08 04:12:50", "city.city": "Steele", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4137": { "city_x_electrician.id": 4137, "city.id": 465, "city.ts": "2018-11-08 04:12:50", "city.city": "Sterrett", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4175": { "city_x_electrician.id": 4175, "city.id": 469, "city.ts": "2018-11-08 04:12:50", "city.city": "Sumiton", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4212": { "city_x_electrician.id": 4212, "city.id": 473, "city.ts": "2018-11-08 04:12:50", "city.city": "Sycamore", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4219": { "city_x_electrician.id": 4219, "city.id": 474, "city.ts": "2018-11-08 04:12:50", "city.city": "Sylacauga", "state_x_letter.id": 19, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 19, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "S" }, "4333": { "city_x_electrician.id": 4333, "city.id": 487, "city.ts": "2018-11-08 04:12:50", "city.city": "Trafford", "state_x_letter.id": 20, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 20, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "T" }, "4383": { "city_x_electrician.id": 4383, "city.id": 491, "city.ts": "2018-11-08 04:12:50", "city.city": "Trussville", "state_x_letter.id": 20, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 20, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "T" }, "4406": { "city_x_electrician.id": 4406, "city.id": 492, "city.ts": "2018-11-08 04:12:50", "city.city": "Tuscaloosa", "state_x_letter.id": 20, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 20, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "T" }, "4490": { "city_x_electrician.id": 4490, "city.id": 503, "city.ts": "2018-11-08 04:12:50", "city.city": "Vance", "state_x_letter.id": 22, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 22, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "V" }, "4501": { "city_x_electrician.id": 4501, "city.id": 504, "city.ts": "2018-11-08 04:12:50", "city.city": "Vandiver", "state_x_letter.id": 22, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 22, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "V" }, "4533": { "city_x_electrician.id": 4533, "city.id": 508, "city.ts": "2018-11-08 04:12:50", "city.city": "Vincent", "state_x_letter.id": 22, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 22, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "V" }, "4627": { "city_x_electrician.id": 4627, "city.id": 518, "city.ts": "2018-11-08 04:12:50", "city.city": "Watson", "state_x_letter.id": 23, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 23, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "W" }, "4728": { "city_x_electrician.id": 4728, "city.id": 529, "city.ts": "2018-11-08 04:12:50", "city.city": "Wilsonville", "state_x_letter.id": 23, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 23, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "W" }, "4740": { "city_x_electrician.id": 4740, "city.id": 530, "city.ts": "2018-11-08 04:12:50", "city.city": "Wilton", "state_x_letter.id": 23, "state.id": 1, "state.ts": "2018-04-10 05:11:19", "state.state": "Alabama", "letter.id": 23, "letter.ts": "2018-04-10 05:59:39", "letter.letter": "W" } }, "electrician.electrician_x_achievement_id": {}, "electrician.electrician_x_service_area_id": { "869": { "electrician_x_service_area.id": 869, "service_area.id": 8, "service_area.ts": "2018-04-11 05:44:26", "service_area.area": "Birmingham" }, "870": { "electrician_x_service_area.id": 870, "service_area.id": 39, "service_area.ts": "2018-04-11 05:44:26", "service_area.area": "Tuscaloosa" }, "871": { "electrician_x_service_area.id": 871, "service_area.id": 214, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Jasper" }, "878": { "electrician_x_service_area.id": 878, "service_area.id": 220, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Sylacauga" }, "872": { "electrician_x_service_area.id": 872, "service_area.id": 230, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Pell City" }, "873": { "electrician_x_service_area.id": 873, "service_area.id": 234, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Coaling" }, "874": { "electrician_x_service_area.id": 874, "service_area.id": 237, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Alabaster" }, "875": { "electrician_x_service_area.id": 875, "service_area.id": 253, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Remlap" }, "876": { "electrician_x_service_area.id": 876, "service_area.id": 254, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Watson" }, "877": { "electrician_x_service_area.id": 877, "service_area.id": 259, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Peterson" }, "879": { "electrician_x_service_area.id": 879, "service_area.id": 267, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Margaret" }, "880": { "electrician_x_service_area.id": 880, "service_area.id": 277, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Wilton" }, "881": { "electrician_x_service_area.id": 881, "service_area.id": 280, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Parrish" }, "882": { "electrician_x_service_area.id": 882, "service_area.id": 297, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Childersburg" }, "883": { "electrician_x_service_area.id": 883, "service_area.id": 298, "service_area.ts": "2018-04-11 06:14:49", "service_area.area": "Kimberly" }, "939": { "electrician_x_service_area.id": 939, "service_area.id": 536, "service_area.ts": "2018-10-13 00:03:22", "service_area.area": "Cleveland" }, "905": { "electrician_x_service_area.id": 905, "service_area.id": 587, "service_area.ts": "2018-10-13 00:03:22", "service_area.area": "Lincoln" }, "899": { "electrician_x_service_area.id": 899, "service_area.id": 606, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Harpersville" }, "900": { "electrician_x_service_area.id": 900, "service_area.id": 607, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Adamsville" }, "901": { "electrician_x_service_area.id": 901, "service_area.id": 608, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Shelby" }, "902": { "electrician_x_service_area.id": 902, "service_area.id": 609, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Siluria" }, "903": { "electrician_x_service_area.id": 903, "service_area.id": 610, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Vincent" }, "910": { "electrician_x_service_area.id": 910, "service_area.id": 611, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Fultondale" }, "913": { "electrician_x_service_area.id": 913, "service_area.id": 612, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Calera" }, "922": { "electrician_x_service_area.id": 922, "service_area.id": 614, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Sterrett" }, "925": { "electrician_x_service_area.id": 925, "service_area.id": 615, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Saginaw" }, "929": { "electrician_x_service_area.id": 929, "service_area.id": 616, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Adger" }, "930": { "electrician_x_service_area.id": 930, "service_area.id": 617, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Columbiana" }, "931": { "electrician_x_service_area.id": 931, "service_area.id": 618, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Leeds" }, "934": { "electrician_x_service_area.id": 934, "service_area.id": 619, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Brookwood" }, "936": { "electrician_x_service_area.id": 936, "service_area.id": 620, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Pinson" }, "941": { "electrician_x_service_area.id": 941, "service_area.id": 621, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Vandiver" }, "944": { "electrician_x_service_area.id": 944, "service_area.id": 622, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Mulga" }, "945": { "electrician_x_service_area.id": 945, "service_area.id": 623, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Abernant" }, "949": { "electrician_x_service_area.id": 949, "service_area.id": 624, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Graysville" }, "950": { "electrician_x_service_area.id": 950, "service_area.id": 625, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Montevallo" }, "951": { "electrician_x_service_area.id": 951, "service_area.id": 626, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Trussville" }, "955": { "electrician_x_service_area.id": 955, "service_area.id": 627, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Pelham" }, "898": { "electrician_x_service_area.id": 898, "service_area.id": 628, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Moody" }, "896": { "electrician_x_service_area.id": 896, "service_area.id": 629, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Chelsea" }, "889": { "electrician_x_service_area.id": 889, "service_area.id": 630, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Docena" }, "956": { "electrician_x_service_area.id": 956, "service_area.id": 631, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Wilsonville" }, "887": { "electrician_x_service_area.id": 887, "service_area.id": 633, "service_area.ts": "2018-10-13 00:03:31", "service_area.area": "Gardendale" }, "885": { "electrician_x_service_area.id": 885, "service_area.id": 648, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Duncanville" }, "884": { "electrician_x_service_area.id": 884, "service_area.id": 649, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Shannon" }, "886": { "electrician_x_service_area.id": 886, "service_area.id": 651, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Quinton" }, "890": { "electrician_x_service_area.id": 890, "service_area.id": 659, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Vance" }, "919": { "electrician_x_service_area.id": 919, "service_area.id": 676, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Dolomite" }, "928": { "electrician_x_service_area.id": 928, "service_area.id": 683, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Cottondale" }, "933": { "electrician_x_service_area.id": 933, "service_area.id": 689, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Oakman" }, "935": { "electrician_x_service_area.id": 935, "service_area.id": 691, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Kellerman" }, "952": { "electrician_x_service_area.id": 952, "service_area.id": 697, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Goodsprings" }, "953": { "electrician_x_service_area.id": 953, "service_area.id": 699, "service_area.ts": "2018-10-13 00:04:39", "service_area.area": "Pleasant Grove" }, "888": { "electrician_x_service_area.id": 888, "service_area.id": 888, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Empire" }, "891": { "electrician_x_service_area.id": 891, "service_area.id": 891, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Steele" }, "892": { "electrician_x_service_area.id": 892, "service_area.id": 892, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Cropwell" }, "893": { "electrician_x_service_area.id": 893, "service_area.id": 893, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Hollins" }, "894": { "electrician_x_service_area.id": 894, "service_area.id": 894, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Cordova" }, "895": { "electrician_x_service_area.id": 895, "service_area.id": 895, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Locust Fork" }, "897": { "electrician_x_service_area.id": 897, "service_area.id": 897, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Hanceville" }, "904": { "electrician_x_service_area.id": 904, "service_area.id": 904, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Oneonta" }, "906": { "electrician_x_service_area.id": 906, "service_area.id": 906, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Sipsey" }, "907": { "electrician_x_service_area.id": 907, "service_area.id": 907, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Dora" }, "908": { "electrician_x_service_area.id": 908, "service_area.id": 908, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Bremen" }, "909": { "electrician_x_service_area.id": 909, "service_area.id": 909, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Brookside" }, "911": { "electrician_x_service_area.id": 911, "service_area.id": 911, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Palmerdale" }, "912": { "electrician_x_service_area.id": 912, "service_area.id": 912, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Ashville" }, "914": { "electrician_x_service_area.id": 914, "service_area.id": 914, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Hayden" }, "915": { "electrician_x_service_area.id": 915, "service_area.id": 915, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Sayre" }, "916": { "electrician_x_service_area.id": 916, "service_area.id": 916, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Sumiton" }, "917": { "electrician_x_service_area.id": 917, "service_area.id": 917, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Cook Springs" }, "918": { "electrician_x_service_area.id": 918, "service_area.id": 918, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Riverside" }, "920": { "electrician_x_service_area.id": 920, "service_area.id": 920, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Millerville" }, "921": { "electrician_x_service_area.id": 921, "service_area.id": 921, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Garden City" }, "923": { "electrician_x_service_area.id": 923, "service_area.id": 923, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Trafford" }, "924": { "electrician_x_service_area.id": 924, "service_area.id": 924, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "New Castle" }, "926": { "electrician_x_service_area.id": 926, "service_area.id": 926, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Burnwell" }, "927": { "electrician_x_service_area.id": 927, "service_area.id": 927, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Wattsville" }, "932": { "electrician_x_service_area.id": 932, "service_area.id": 932, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Springville" }, "937": { "electrician_x_service_area.id": 937, "service_area.id": 937, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Bon Air" }, "938": { "electrician_x_service_area.id": 938, "service_area.id": 938, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Clay" }, "940": { "electrician_x_service_area.id": 940, "service_area.id": 940, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Mount Olive" }, "942": { "electrician_x_service_area.id": 942, "service_area.id": 942, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Munford" }, "943": { "electrician_x_service_area.id": 943, "service_area.id": 943, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Morris" }, "946": { "electrician_x_service_area.id": 946, "service_area.id": 946, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Allgood" }, "947": { "electrician_x_service_area.id": 947, "service_area.id": 947, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Alpine" }, "948": { "electrician_x_service_area.id": 948, "service_area.id": 948, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Alton" }, "954": { "electrician_x_service_area.id": 954, "service_area.id": 954, "service_area.ts": "2018-10-13 00:05:16", "service_area.area": "Sycamore" } }, "electrician.service_category_id": { "21": { "service_category.id": 21, "service_category.ts": "2018-10-13 00:05:16", "service_category.title": "Audio/Visual & Computers", "service_category.service_id": { "72": { "service.id": 72, "service.ts": "2018-10-13 00:05:16", "service.service": "Computer Repair/Upgrade" } } }, "22": { "service_category.id": 22, "service_category.ts": "2018-10-13 00:05:16", "service_category.title": "Electrical", "service_category.service_id": { "73": { "service.id": 73, "service.ts": "2018-10-13 00:05:16", "service.service": "Telephone System Install - For Business" }, "74": { "service.id": 74, "service.ts": "2018-10-13 00:05:16", "service.service": "Telephone System Repair - For Business" }, "75": { "service.id": 75, "service.ts": "2018-10-13 00:05:16", "service.service": "Telephone Jack & Wiring Install - For Business" } } }, "23": { "service_category.id": 23, "service_category.ts": "2018-10-13 00:05:16", "service_category.title": "Home Security Services", "service_category.service_id": { "76": { "service.id": 76, "service.ts": "2018-10-13 00:05:16", "service.service": "Building Automation System Install - For Business" } } } }, "electrician.electrician_x_expertise_id": { "27": { "electrician_x_expertise.id": 27, "expertise.id": 27, "expertise.ts": "2018-10-13 00:05:16", "expertise.expertise": "Personal Computers" }, "28": { "electrician_x_expertise.id": 28, "expertise.id": 28, "expertise.ts": "2018-10-13 00:05:16", "expertise.expertise": "Internet and cabling" }, "29": { "electrician_x_expertise.id": 29, "expertise.id": 29, "expertise.ts": "2018-10-13 00:05:16", "expertise.expertise": "Router Installation/repair" }, "30": { "electrician_x_expertise.id": 30, "expertise.id": 30, "expertise.ts": "2018-10-13 00:05:16", "expertise.expertise": "Electronic Installation(Alexa Devices, Google Home, NEST, etc)" }, "31": { "electrician_x_expertise.id": 31, "expertise.id": 31, "expertise.ts": "2018-10-13 00:05:16", "expertise.expertise": "Electronics repair" } }, "electrician.business_hour_id": { "15": { "business_hour.id": 15, "business_hour.ts": "2018-10-13 00:05:16", "business_hour.title": "Monday:", "business_hour.value": "5:00 PM to 9:00 PM" }, "16": { "business_hour.id": 16, "business_hour.ts": "2018-10-13 00:05:16", "business_hour.title": "Tuesday:", "business_hour.value": "5:00 PM to 9:00 PM" }, "17": { "business_hour.id": 17, "business_hour.ts": "2018-10-13 00:05:16", "business_hour.title": "Wednesday:", "business_hour.value": "5:00 PM to 9:00 PM" }, "18": { "business_hour.id": 18, "business_hour.ts": "2018-10-13 00:05:16", "business_hour.title": "Thursday:", "business_hour.value": "5:00 PM to 9:00 PM" }, "19": { "business_hour.id": 19, "business_hour.ts": "2018-10-13 00:05:16", "business_hour.title": "Friday:", "business_hour.value": "5:00 PM to 9:00 PM" }, "20": { "business_hour.id": 20, "business_hour.ts": "2018-10-13 00:05:16", "business_hour.title": "Saturday:", "business_hour.value": "9:00 AM to 9:00 PM" }, "21": { "business_hour.id": 21, "business_hour.ts": "2018-10-13 00:05:16", "business_hour.title": "Sunday:", "business_hour.value": "9:00 AM to 9:00 PM" } }, "electrician.quick_fact_id": { "21": { "quick_fact.id": 21, "quick_fact.ts": "2018-10-13 00:05:16", "quick_fact.title": "Free Estimates" }, "22": { "quick_fact.id": 22, "quick_fact.ts": "2018-10-13 00:05:16", "quick_fact.title": "Credit Cards Accepted" } }, "electrician.license_id": {}, "electrician.image_slug_id": { "8": { "image_slug.id": 8, "image_slug.ts": "2018-10-16 05:11:30", "image_slug.work_image_id": { "5": { "work_image.id": 5, "work_image.path": "/c2/4f/74/9d/c24f749d26b746efe8c30a42e6b5581649e54730.jpg", "work_image.work_image":} } } } } } } }