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": "US Contractors", "point": { "title": "By Table", "desc": "Each API function returns data from a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_contractor/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_contractor/by_table/category_1/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_contractor/by_table/category_1/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.0016199999999999999122923810546126333065330982208251953125 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 100727, "pages_total": 1008 }, "struct": { "stem": { "0": "category_1", "1": "city", "2": "state" }, "leaf": "category_1.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "category_1.id": 1, "category_1.ts": "2018-01-16 00:41:47", "category_1.title": "Air Conditioning (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "2": { "category_1.id": 2, "category_1.ts": "2018-01-16 00:41:50", "category_1.title": "Architects & Engineers (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "3": { "category_1.id": 3, "category_1.ts": "2018-01-16 00:41:57", "category_1.title": "Audio/Visual & Computers (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "4": { "category_1.id": 4, "category_1.ts": "2018-01-16 00:41:58", "category_1.title": "Brick & Stone (4)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "5": { "category_1.id": 5, "category_1.ts": "2018-01-16 00:42:01", "category_1.title": "Cabinets (4)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "6": { "category_1.id": 6, "category_1.ts": "2018-01-16 00:42:05", "category_1.title": "Carpenters (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "7": { "category_1.id": 7, "category_1.ts": "2018-01-16 00:42:10", "category_1.title": "Countertops (4)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "8": { "category_1.id": 8, "category_1.ts": "2018-01-16 00:42:15", "category_1.title": "Decks (5)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "9": { "category_1.id": 9, "category_1.ts": "2018-01-16 00:42:21", "category_1.title": "Disaster Recovery Services (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "10": { "category_1.id": 10, "category_1.ts": "2018-01-16 00:42:23", "category_1.title": "Doors (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "11": { "category_1.id": 11, "category_1.ts": "2018-01-16 00:42:29", "category_1.title": "Electrical (6)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "12": { "category_1.id": 12, "category_1.ts": "2018-01-16 00:42:32", "category_1.title": "Fans (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "13": { "category_1.id": 13, "category_1.ts": "2018-01-16 00:42:37", "category_1.title": "Fireplace & Wood Stoves (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "14": { "category_1.id": 14, "category_1.ts": "2018-01-16 00:42:41", "category_1.title": "Flooring & Carpet (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "15": { "category_1.id": 15, "category_1.ts": "2018-01-16 00:42:44", "category_1.title": "Glass & Mirrors (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "16": { "category_1.id": 16, "category_1.ts": "2018-01-16 00:42:49", "category_1.title": "Gutters (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "17": { "category_1.id": 17, "category_1.ts": "2018-01-16 00:42:54", "category_1.title": "Heating & Furnace Systems (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "18": { "category_1.id": 18, "category_1.ts": "2018-01-16 00:42:58", "category_1.title": "Home Security Services (7)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "19": { "category_1.id": 19, "category_1.ts": "2018-01-16 00:43:03", "category_1.title": "Insulation (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "20": { "category_1.id": 20, "category_1.ts": "2018-01-16 00:43:07", "category_1.title": "Landscaping (4)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "21": { "category_1.id": 21, "category_1.ts": "2018-01-16 00:43:13", "category_1.title": "Metal Fabrication (3)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "22": { "category_1.id": 22, "category_1.ts": "2018-01-16 00:43:18", "category_1.title": "Mold & Asbestos Services (7)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "23": { "category_1.id": 23, "category_1.ts": "2018-01-16 00:43:27", "category_1.title": "Moving (4)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "24": { "category_1.id": 24, "category_1.ts": "2018-01-16 00:43:30", "category_1.title": "Organizers (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "25": { "category_1.id": 25, "category_1.ts": "2018-01-16 00:43:35", "category_1.title": "Paving (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "26": { "category_1.id": 26, "category_1.ts": "2018-01-16 00:44:09", "category_1.title": "Pest Control (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "27": { "category_1.id": 27, "category_1.ts": "2018-01-16 00:44:12", "category_1.title": "Plumbing (5)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "28": { "category_1.id": 28, "category_1.ts": "2018-01-16 00:44:18", "category_1.title": "Powdercoating (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "29": { "category_1.id": 29, "category_1.ts": "2018-01-16 00:44:28", "category_1.title": "Roofing (5)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "30": { "category_1.id": 30, "category_1.ts": "2018-01-16 00:44:30", "category_1.title": "Septic Tanks & Wells (4)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "31": { "category_1.id": 31, "category_1.ts": "2018-01-16 00:44:34", "category_1.title": "Sheds & Enclosures (4)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "32": { "category_1.id": 32, "category_1.ts": "2018-01-16 00:44:37", "category_1.title": "Siding (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "33": { "category_1.id": 33, "category_1.ts": "2018-01-16 00:44:40", "category_1.title": "Swimming Pools (6)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "34": { "category_1.id": 34, "category_1.ts": "2018-01-16 00:44:48", "category_1.title": "Tile (6)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "35": { "category_1.id": 35, "category_1.ts": "2018-01-16 00:44:54", "category_1.title": "Tree Service (6)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "36": { "category_1.id": 36, "category_1.ts": "2018-01-16 00:45:02", "category_1.title": "Water Treatment System (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "37": { "category_1.id": 37, "category_1.ts": "2018-01-16 00:45:06", "category_1.title": "Waterproofing (7)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "38": { "category_1.id": 38, "category_1.ts": "2018-01-16 00:45:12", "category_1.title": "Windows (2)", "category_1.city": "Adamsville", "city.id": 1, "city.ts": "2018-01-15 04:58:20", "city.title": "Adamsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "39": { "category_1.id": 39, "category_1.ts": "2018-01-16 00:45:16", "category_1.title": "Additions & Remodeling (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "40": { "category_1.id": 40, "category_1.ts": "2018-01-16 00:45:21", "category_1.title": "Architects & Engineers (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "41": { "category_1.id": 41, "category_1.ts": "2018-01-16 00:45:28", "category_1.title": "Brick & Stone (5)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "42": { "category_1.id": 42, "category_1.ts": "2018-01-16 00:45:35", "category_1.title": "Cabinets (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "43": { "category_1.id": 43, "category_1.ts": "2018-01-16 00:46:15", "category_1.title": "Carpenters (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "44": { "category_1.id": 44, "category_1.ts": "2018-01-16 00:46:19", "category_1.title": "Countertops (4)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "45": { "category_1.id": 45, "category_1.ts": "2018-01-16 00:46:21", "category_1.title": "Decks (5)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "46": { "category_1.id": 46, "category_1.ts": "2018-01-16 00:46:27", "category_1.title": "Designers & Decorators (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "47": { "category_1.id": 47, "category_1.ts": "2018-01-16 00:46:31", "category_1.title": "Disaster Recovery Services (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "48": { "category_1.id": 48, "category_1.ts": "2018-01-16 00:46:37", "category_1.title": "Doors (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "49": { "category_1.id": 49, "category_1.ts": "2018-01-16 00:46:41", "category_1.title": "Electrical (6)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "50": { "category_1.id": 50, "category_1.ts": "2018-01-16 00:46:50", "category_1.title": "Excavation (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "51": { "category_1.id": 51, "category_1.ts": "2018-01-16 00:46:55", "category_1.title": "Fans (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "52": { "category_1.id": 52, "category_1.ts": "2018-01-16 00:47:02", "category_1.title": "Fences (6)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "53": { "category_1.id": 53, "category_1.ts": "2018-01-16 00:47:04", "category_1.title": "Flooring & Carpet (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "54": { "category_1.id": 54, "category_1.ts": "2018-01-16 00:47:11", "category_1.title": "Glass & Mirrors (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "55": { "category_1.id": 55, "category_1.ts": "2018-01-16 00:47:15", "category_1.title": "Gutters (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "56": { "category_1.id": 56, "category_1.ts": "2018-01-16 00:47:19", "category_1.title": "Home Security Services (6)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "57": { "category_1.id": 57, "category_1.ts": "2018-01-16 00:47:25", "category_1.title": "Insulation (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "58": { "category_1.id": 58, "category_1.ts": "2018-01-16 00:47:27", "category_1.title": "Metal Fabrication (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "59": { "category_1.id": 59, "category_1.ts": "2018-01-16 00:47:32", "category_1.title": "Moving (5)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "60": { "category_1.id": 60, "category_1.ts": "2018-01-16 00:47:36", "category_1.title": "Organizers (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "61": { "category_1.id": 61, "category_1.ts": "2018-01-16 00:47:41", "category_1.title": "Painting (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "62": { "category_1.id": 62, "category_1.ts": "2018-01-16 00:47:47", "category_1.title": "Paving (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "63": { "category_1.id": 63, "category_1.ts": "2018-01-16 00:47:51", "category_1.title": "Plumbing (6)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "64": { "category_1.id": 64, "category_1.ts": "2018-01-16 00:47:55", "category_1.title": "Powdercoating (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "65": { "category_1.id": 65, "category_1.ts": "2018-01-16 00:47:58", "category_1.title": "Power Washing (6)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "66": { "category_1.id": 66, "category_1.ts": "2018-01-16 00:48:01", "category_1.title": "Roofing (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "67": { "category_1.id": 67, "category_1.ts": "2018-01-16 00:48:02", "category_1.title": "Septic Tanks & Wells (2)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "68": { "category_1.id": 68, "category_1.ts": "2018-01-16 00:48:05", "category_1.title": "Sheds & Enclosures (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "69": { "category_1.id": 69, "category_1.ts": "2018-01-16 00:48:10", "category_1.title": "Swimming Pools (7)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "70": { "category_1.id": 70, "category_1.ts": "2018-01-16 00:48:15", "category_1.title": "Tile (4)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "71": { "category_1.id": 71, "category_1.ts": "2018-01-16 00:48:20", "category_1.title": "Tree Service (7)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "72": { "category_1.id": 72, "category_1.ts": "2018-01-16 00:48:21", "category_1.title": "Waterproofing (7)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "73": { "category_1.id": 73, "category_1.ts": "2018-01-16 00:48:27", "category_1.title": "Windows (3)", "category_1.city": "Alton", "city.id": 2, "city.ts": "2018-01-15 04:58:20", "city.title": "Alton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "74": { "category_1.id": 74, "category_1.ts": "2018-01-16 00:48:32", "category_1.title": "Additions & Remodeling (2)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "75": { "category_1.id": 75, "category_1.ts": "2018-01-16 00:48:36", "category_1.title": "Air Conditioning (3)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "76": { "category_1.id": 76, "category_1.ts": "2018-01-16 00:48:40", "category_1.title": "Appliances (2)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "77": { "category_1.id": 77, "category_1.ts": "2018-01-16 00:48:42", "category_1.title": "Audio/Visual & Computers (4)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "78": { "category_1.id": 78, "category_1.ts": "2018-01-16 00:48:43", "category_1.title": "Awnings (5)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "79": { "category_1.id": 79, "category_1.ts": "2018-01-16 00:48:45", "category_1.title": "Cabinets (8)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "80": { "category_1.id": 80, "category_1.ts": "2018-01-16 00:48:51", "category_1.title": "Carpenters (4)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "81": { "category_1.id": 81, "category_1.ts": "2018-01-16 00:48:55", "category_1.title": "Carpet & Upholstery Cleaning (2)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "82": { "category_1.id": 82, "category_1.ts": "2018-01-16 00:49:02", "category_1.title": "Ceilings (3)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "83": { "category_1.id": 83, "category_1.ts": "2018-01-16 00:49:05", "category_1.title": "Central Vacuum (2)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "84": { "category_1.id": 84, "category_1.ts": "2018-01-16 00:49:10", "category_1.title": "Concrete (5)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "85": { "category_1.id": 85, "category_1.ts": "2018-01-16 00:49:13", "category_1.title": "Countertops (4)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "86": { "category_1.id": 86, "category_1.ts": "2018-01-16 00:49:18", "category_1.title": "Decks (5)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "87": { "category_1.id": 87, "category_1.ts": "2018-01-16 00:49:24", "category_1.title": "Designers & Decorators (3)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "88": { "category_1.id": 88, "category_1.ts": "2018-01-16 00:49:31", "category_1.title": "Disability Services (3)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "89": { "category_1.id": 89, "category_1.ts": "2018-01-16 00:49:38", "category_1.title": "Docks (3)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "90": { "category_1.id": 90, "category_1.ts": "2018-01-16 00:49:45", "category_1.title": "Doors (5)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "91": { "category_1.id": 91, "category_1.ts": "2018-01-16 00:49:47", "category_1.title": "Drywall & Plaster (4)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "92": { "category_1.id": 92, "category_1.ts": "2018-01-16 00:49:49", "category_1.title": "Electrical (5)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "93": { "category_1.id": 93, "category_1.ts": "2018-01-16 00:49:52", "category_1.title": "Fences (5)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "94": { "category_1.id": 94, "category_1.ts": "2018-01-16 00:49:58", "category_1.title": "Flooring & Carpet (5)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "95": { "category_1.id": 95, "category_1.ts": "2018-01-16 00:50:05", "category_1.title": "Glass & Mirrors (3)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "96": { "category_1.id": 96, "category_1.ts": "2018-01-16 00:50:09", "category_1.title": "Gutters (4)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "97": { "category_1.id": 97, "category_1.ts": "2018-01-16 00:50:12", "category_1.title": "Handyman Services (3)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "98": { "category_1.id": 98, "category_1.ts": "2018-01-16 00:50:16", "category_1.title": "Heating & Furnace Systems (2)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "99": { "category_1.id": 99, "category_1.ts": "2018-01-16 00:50:18", "category_1.title": "Home Inspection (6)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" }, "100": { "category_1.id": 100, "category_1.ts": "2018-01-16 00:50:25", "category_1.title": "Landscaping (4)", "category_1.city": "Bon Secour", "city.id": 3, "city.ts": "2018-01-15 04:58:20", "city.title": "Bon Secour", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-01-15 04:56:56", "state.title": "Alabama" } } } }