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": 200 }, "api": { "title": "Plumbers in US", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/plumbers_in_us/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/plumbers_in_us/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/plumbers_in_us/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/plumbers_in_us/main/list/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 20, "limit_total": 200, "time": 0.0014599999999999999263089467405052346293814480304718017578125 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 104839, "pages_total": 5242 }, "struct": { "stem": { "0": "plumber" }, "leaf": "plumber.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "21": { "plumber.id": 21, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Affordable Plumbing", "plumber.phone": "(334) 222-9731", "plumber.address": "1012 Stanley Ave", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420, "plumber.city_x_plumber_id": { "21": { "city_x_plumber.id": 21, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "22": { "plumber.id": 22, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Holcomb Plumbing & Electric", "plumber.phone": "(334) 222-4020", "plumber.address": "21187 Rosin Ridge Rd", "plumber.city": "Red Level", "plumber.state": "AL", "plumber.zip": 36474, "plumber.city_x_plumber_id": { "22": { "city_x_plumber.id": 22, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "23": { "plumber.id": 23, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Bailey Plumbing And Electric", "plumber.phone": "(334) 493-4323", "plumber.address": "30248 Cool Springs Rd", "plumber.city": "Opp", "plumber.state": "AL", "plumber.zip": 36467, "plumber.city_x_plumber_id": { "23": { "city_x_plumber.id": 23, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "24": { "plumber.id": 24, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Mullen Larry Plumbing Service", "plumber.phone": "(334) 222-1993", "plumber.address": "18360 Solmar Loop", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420, "plumber.city_x_plumber_id": { "24": { "city_x_plumber.id": 24, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "25": { "plumber.id": 25, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "C & I Plumbing & Electrical Co", "plumber.phone": "(334) 222-6331", "plumber.address": "102 Forest Ave", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420, "plumber.city_x_plumber_id": { "25": { "city_x_plumber.id": 25, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "26": { "plumber.id": 26, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "Wilson Johnny Plumbing & Electric Contractor", "plumber.phone": "(334) 493-6020", "plumber.address": "127 W Covington Ave", "plumber.city": "Opp", "plumber.state": "AL", "plumber.zip": 36467, "plumber.city_x_plumber_id": { "26": { "city_x_plumber.id": 26, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "27": { "plumber.id": 27, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "C & I Plumbing & Electrical Co", "plumber.phone": "(334) 222-6331", "plumber.address": "Andalusia,", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420, "plumber.city_x_plumber_id": { "27": { "city_x_plumber.id": 27, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "28": { "plumber.id": 28, "plumber.ts": "2018-02-08 21:45:44", "plumber.title": "B & P Photography", "plumber.phone": "(334) 222-9731", "plumber.address": "1012 Stanley Ave", "plumber.city": "Andalusia", "plumber.state": "AL", "plumber.zip": 36420, "plumber.city_x_plumber_id": { "28": { "city_x_plumber.id": 28, "city.id": 4, "city.ts": "2018-02-10 20:23:48", "city.title": "Andalusia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "29": { "plumber.id": 29, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "24 7 Plumber Wellington's Best", "plumber.phone": "(256) 978-4328", "plumber.address": "Wellington,", "plumber.city": "Wellington", "plumber.state": "AL", "plumber.zip": 36279, "plumber.city_x_plumber_id": { "29": { "city_x_plumber.id": 29, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "30": { "plumber.id": 30, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Howell Plumbing", "plumber.phone": "(256) 831-2345", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203, "plumber.city_x_plumber_id": { "30": { "city_x_plumber.id": 30, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "31": { "plumber.id": 31, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Preston's Plumbing", "plumber.phone": "(256) 454-5962", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201, "plumber.city_x_plumber_id": { "31": { "city_x_plumber.id": 31, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "32": { "plumber.id": 32, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Burks Plumbing", "plumber.phone": "(256) 499-0276", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36205, "plumber.city_x_plumber_id": { "32": { "city_x_plumber.id": 32, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "33": { "plumber.id": 33, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Ted's Plumbing", "plumber.phone": "(256) 236-6737", "plumber.address": "500 Noble St", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201, "plumber.city_x_plumber_id": { "33": { "city_x_plumber.id": 33, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "34": { "plumber.id": 34, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Jeff's Plumbing", "plumber.phone": "(256) 310-2005", "plumber.address": "Oxford,", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203, "plumber.city_x_plumber_id": { "34": { "city_x_plumber.id": 34, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "35": { "plumber.id": 35, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "American Plumbing", "plumber.phone": "(256) 831-4122", "plumber.address": "401 Hamric Dr W", "plumber.city": "Oxford", "plumber.state": "AL", "plumber.zip": 36203, "plumber.city_x_plumber_id": { "35": { "city_x_plumber.id": 35, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "36": { "plumber.id": 36, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Ward Plumbing", "plumber.phone": "(256) 237-0946", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36201, "plumber.city_x_plumber_id": { "36": { "city_x_plumber.id": 36, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "37": { "plumber.id": 37, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Ward Plumbing", "plumber.phone": "(256) 237-0946", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36205, "plumber.city_x_plumber_id": { "37": { "city_x_plumber.id": 37, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "38": { "plumber.id": 38, "plumber.ts": "2018-02-08 21:45:45", "plumber.title": "Preferred Plumbing", "plumber.phone": "(256) 343-4643", "plumber.address": "Anniston,", "plumber.city": "Anniston", "plumber.state": "AL", "plumber.zip": 36205, "plumber.city_x_plumber_id": { "38": { "city_x_plumber.id": 38, "city.id": 5, "city.ts": "2018-02-10 20:25:58", "city.title": "Anniston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "39": { "plumber.id": 39, "plumber.ts": "2018-02-08 21:45:50", "plumber.title": "Ben Franklin The Punctual Plumber", "plumber.phone": "(256) 232-9858", "plumber.address": "Athens,", "plumber.city": "Athens", "plumber.state": "AL", "plumber.zip": 35611, "plumber.city_x_plumber_id": { "39": { "city_x_plumber.id": 39, "city.id": 6, "city.ts": "2018-02-10 20:26:15", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } }, "40": { "plumber.id": 40, "plumber.ts": "2018-02-08 21:45:50", "plumber.title": "Take 5 Plumbing & Electrical", "plumber.phone": "(256) 216-6086", "plumber.address": "26295 US Highway 72", "plumber.city": "Athens", "plumber.state": "AL", "plumber.zip": 35613, "plumber.city_x_plumber_id": { "40": { "city_x_plumber.id": 40, "city.id": 6, "city.ts": "2018-02-10 20:26:15", "city.title": "Athens", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-02-08 21:40:27", "state.title": "Alabama" } } } } } }