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": "Roofing Contractors in US", "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/roofing_contractors_in_us/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.0017799999999999998982758153687200319836847484111785888671875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 2259, "pages_total": 23 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "101": { "city.id": 101, "city.ts": "2018-02-22 20:31:15", "city.title": "Batesville", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "102": { "city.id": 102, "city.ts": "2018-02-22 20:31:27", "city.title": "Benton", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "103": { "city.id": 103, "city.ts": "2018-02-22 20:31:32", "city.title": "Blytheville", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "104": { "city.id": 104, "city.ts": "2018-02-22 20:31:38", "city.title": "Cherokee Village", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "105": { "city.id": 105, "city.ts": "2018-02-22 20:31:42", "city.title": "Clinton", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "106": { "city.id": 106, "city.ts": "2018-02-22 20:32:03", "city.title": "Conway", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "107": { "city.id": 107, "city.ts": "2018-02-22 20:32:09", "city.title": "Crossett", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "108": { "city.id": 108, "city.ts": "2018-02-22 20:32:14", "city.title": "Dardanelle", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "109": { "city.id": 109, "city.ts": "2018-02-22 01:28:33", "city.title": "Dumas", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "110": { "city.id": 110, "city.ts": "2018-02-22 20:32:22", "city.title": "El Dorado", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "111": { "city.id": 111, "city.ts": "2018-02-22 01:28:33", "city.title": "Elaine", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "112": { "city.id": 112, "city.ts": "2018-02-22 20:32:59", "city.title": "Fort Smith", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "113": { "city.id": 113, "city.ts": "2018-02-22 20:33:02", "city.title": "Greenbrier", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "114": { "city.id": 114, "city.ts": "2018-02-22 20:33:07", "city.title": "Hamburg", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "115": { "city.id": 115, "city.ts": "2018-02-22 20:33:13", "city.title": "Hampton", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "116": { "city.id": 116, "city.ts": "2018-02-22 20:33:19", "city.title": "Heber Springs", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "117": { "city.id": 117, "city.ts": "2018-02-22 20:33:34", "city.title": "Hope", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "118": { "city.id": 118, "city.ts": "2018-02-22 20:33:56", "city.title": "Hot Springs", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "119": { "city.id": 119, "city.ts": "2018-02-22 20:34:01", "city.title": "Huntsville", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "120": { "city.id": 120, "city.ts": "2018-02-22 20:34:15", "city.title": "Jacksonville", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "121": { "city.id": 121, "city.ts": "2018-02-22 20:34:45", "city.title": "Jonesboro", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "122": { "city.id": 122, "city.ts": "2018-02-22 20:34:53", "city.title": "Lake Village", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "123": { "city.id": 123, "city.ts": "2018-02-22 20:36:05", "city.title": "Little Rock", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "124": { "city.id": 124, "city.ts": "2018-02-22 01:28:33", "city.title": "McCrory", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "125": { "city.id": 125, "city.ts": "2018-02-22 20:36:14", "city.title": "Mena", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "126": { "city.id": 126, "city.ts": "2018-02-22 20:36:21", "city.title": "Monticello", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "127": { "city.id": 127, "city.ts": "2018-02-22 20:36:52", "city.title": "Mountain Home", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "128": { "city.id": 128, "city.ts": "2018-02-22 20:36:55", "city.title": "Mountain View", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "129": { "city.id": 129, "city.ts": "2018-02-22 20:37:00", "city.title": "Newport", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "130": { "city.id": 130, "city.ts": "2018-02-22 20:37:05", "city.title": "Osceola", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "131": { "city.id": 131, "city.ts": "2018-02-22 20:37:22", "city.title": "Pine Bluff", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "132": { "city.id": 132, "city.ts": "2018-02-22 20:37:28", "city.title": "Pocahontas", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "133": { "city.id": 133, "city.ts": "2018-02-22 20:37:34", "city.title": "Prairie Grove", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "134": { "city.id": 134, "city.ts": "2018-02-22 20:37:37", "city.title": "Prescott", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "135": { "city.id": 135, "city.ts": "2018-02-22 20:37:40", "city.title": "Redfield", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "136": { "city.id": 136, "city.ts": "2018-02-22 20:37:43", "city.title": "Rison", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "137": { "city.id": 137, "city.ts": "2018-02-22 20:38:31", "city.title": "Rogers", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "138": { "city.id": 138, "city.ts": "2018-02-22 20:38:45", "city.title": "Russellville", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "139": { "city.id": 139, "city.ts": "2018-02-22 20:38:50", "city.title": "Sheridan", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "140": { "city.id": 140, "city.ts": "2018-02-22 20:38:58", "city.title": "Stuttgart", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "141": { "city.id": 141, "city.ts": "2018-02-22 20:39:01", "city.title": "Trumann", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "142": { "city.id": 142, "city.ts": "2018-02-22 01:28:33", "city.title": "Tuckerman", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "143": { "city.id": 143, "city.ts": "2018-02-22 20:39:09", "city.title": "Waldron", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "144": { "city.id": 144, "city.ts": "2018-02-22 20:39:13", "city.title": "Weiner", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "145": { "city.id": 145, "city.ts": "2018-02-22 20:39:18", "city.title": "West Fork", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "146": { "city.id": 146, "city.ts": "2018-02-22 20:39:22", "city.title": "West Helena", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "147": { "city.id": 147, "city.ts": "2018-02-22 20:39:28", "city.title": "West Memphis", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "148": { "city.id": 148, "city.ts": "2018-02-22 20:39:31", "city.title": "Wheatley", "city.state": "Arkansas", "state.id": 4, "state.ts": "2018-02-22 01:26:46", "state.title": "Arkansas" }, "149": { "city.id": 149, "city.ts": "2018-02-22 20:39:54", "city.title": "Alhambra", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "150": { "city.id": 150, "city.ts": "2018-02-22 20:39:56", "city.title": "Alturas", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "151": { "city.id": 151, "city.ts": "2018-02-22 20:41:02", "city.title": "Auburn", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "152": { "city.id": 152, "city.ts": "2018-02-22 01:28:43", "city.title": "Baker", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "153": { "city.id": 153, "city.ts": "2018-02-22 20:41:42", "city.title": "Bakersfield", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "154": { "city.id": 154, "city.ts": "2018-02-22 20:41:47", "city.title": "Banning", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "155": { "city.id": 155, "city.ts": "2018-02-22 20:41:53", "city.title": "Barstow", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "156": { "city.id": 156, "city.ts": "2018-02-22 20:41:59", "city.title": "Big Bear Lake", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "157": { "city.id": 157, "city.ts": "2018-02-22 20:42:03", "city.title": "Blythe", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "158": { "city.id": 158, "city.ts": "2018-02-22 20:42:11", "city.title": "Buellton", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "159": { "city.id": 159, "city.ts": "2018-02-22 20:42:14", "city.title": "Burney", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "160": { "city.id": 160, "city.ts": "2018-02-22 20:42:19", "city.title": "Carpinteria", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "161": { "city.id": 161, "city.ts": "2018-02-22 20:42:48", "city.title": "Chico", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "162": { "city.id": 162, "city.ts": "2018-02-22 20:43:01", "city.title": "Chula Vista", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "163": { "city.id": 163, "city.ts": "2018-02-22 20:43:03", "city.title": "Colfax", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "164": { "city.id": 164, "city.ts": "2018-02-22 20:43:05", "city.title": "Colusa", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "165": { "city.id": 165, "city.ts": "2018-02-22 20:43:10", "city.title": "Compton", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "166": { "city.id": 166, "city.ts": "2018-02-22 20:43:16", "city.title": "Corcoran", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "167": { "city.id": 167, "city.ts": "2018-02-22 20:43:36", "city.title": "Corona", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "168": { "city.id": 168, "city.ts": "2018-02-22 20:43:52", "city.title": "Crescent City", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "169": { "city.id": 169, "city.ts": "2018-02-22 20:43:56", "city.title": "Dorris", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "170": { "city.id": 170, "city.ts": "2018-02-22 20:44:02", "city.title": "Dos Palos", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "171": { "city.id": 171, "city.ts": "2018-02-22 20:44:18", "city.title": "Downey", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "172": { "city.id": 172, "city.ts": "2018-02-22 20:44:59", "city.title": "El Cajon", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "173": { "city.id": 173, "city.ts": "2018-02-22 20:45:12", "city.title": "El Centro", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "174": { "city.id": 174, "city.ts": "2018-02-22 20:45:36", "city.title": "Elk Grove", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "175": { "city.id": 175, "city.ts": "2018-02-22 20:46:11", "city.title": "Encinitas", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "176": { "city.id": 176, "city.ts": "2018-02-22 20:46:27", "city.title": "Eureka", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "177": { "city.id": 177, "city.ts": "2018-02-22 20:46:32", "city.title": "Exeter", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "178": { "city.id": 178, "city.ts": "2018-02-22 20:47:08", "city.title": "Fairfield", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "179": { "city.id": 179, "city.ts": "2018-02-22 20:48:07", "city.title": "Fremont", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "180": { "city.id": 180, "city.ts": "2018-02-22 20:49:12", "city.title": "Fresno", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "181": { "city.id": 181, "city.ts": "2018-02-22 20:49:14", "city.title": "Friant", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "182": { "city.id": 182, "city.ts": "2018-02-22 20:50:28", "city.title": "Fullerton", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "183": { "city.id": 183, "city.ts": "2018-02-22 20:50:31", "city.title": "Garberville", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "184": { "city.id": 184, "city.ts": "2018-02-22 20:51:01", "city.title": "Glendale", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "185": { "city.id": 185, "city.ts": "2018-02-22 20:52:02", "city.title": "Glendora", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "186": { "city.id": 186, "city.ts": "2018-02-22 20:52:17", "city.title": "Grass Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "187": { "city.id": 187, "city.ts": "2018-02-22 20:52:33", "city.title": "Hawthorne", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "188": { "city.id": 188, "city.ts": "2018-02-22 20:52:44", "city.title": "Hemet", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "189": { "city.id": 189, "city.ts": "2018-02-22 20:53:51", "city.title": "Huntington Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "190": { "city.id": 190, "city.ts": "2018-02-22 20:54:10", "city.title": "Irvine", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "191": { "city.id": 191, "city.ts": "2018-02-22 01:28:43", "city.title": "Kerman", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "192": { "city.id": 192, "city.ts": "2018-02-22 20:54:15", "city.title": "Knights Landing", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "193": { "city.id": 193, "city.ts": "2018-02-22 20:54:17", "city.title": "Laguna Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "194": { "city.id": 194, "city.ts": "2018-02-22 20:54:49", "city.title": "Lakeport", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "195": { "city.id": 195, "city.ts": "2018-02-22 20:55:10", "city.title": "Lancaster", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "196": { "city.id": 196, "city.ts": "2018-02-22 20:55:14", "city.title": "Linden", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "197": { "city.id": 197, "city.ts": "2018-02-22 20:55:20", "city.title": "Lindsay", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "198": { "city.id": 198, "city.ts": "2018-02-22 20:55:24", "city.title": "Livingston", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "199": { "city.id": 199, "city.ts": "2018-02-22 20:55:42", "city.title": "Lodi", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "200": { "city.id": 200, "city.ts": "2018-02-22 20:55:45", "city.title": "Lompoc", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" } } } }