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/hour/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_contractor/by_table/hour/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.0009899999999999999945876627549523618654347956180572509765625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 1184, "pages_total": 12 }, "struct": { "stem": { "0": "hour" }, "leaf": "hour.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "hour.id": 1, "hour.ts": "2018-01-21 20:06:40", "hour.value": "6:00 AM to 8:00 PM", "hour.key": "Monday:" }, "2": { "hour.id": 2, "hour.ts": "2018-01-21 20:06:40", "hour.value": "6:00 AM to 8:00 PM", "hour.key": "Tuesday:" }, "3": { "hour.id": 3, "hour.ts": "2018-01-21 20:06:40", "hour.value": "6:00 AM to 8:00 PM", "hour.key": "Wednesday:" }, "4": { "hour.id": 4, "hour.ts": "2018-01-21 20:06:40", "hour.value": "6:00 AM to 8:00 PM", "hour.key": "Thursday:" }, "5": { "hour.id": 5, "hour.ts": "2018-01-21 20:06:40", "hour.value": "6:00 AM to 8:00 PM", "hour.key": "Friday:" }, "6": { "hour.id": 6, "hour.ts": "2018-01-21 20:06:40", "hour.value": "8:00 AM to 3:00 PM", "hour.key": "Saturday:" }, "7": { "hour.id": 7, "hour.ts": "2018-01-21 20:06:40", "hour.value": "8:00 AM to 3:00 PM", "hour.key": "Sunday:" }, "8": { "hour.id": 8, "hour.ts": "2018-01-21 20:08:30", "hour.value": "9:00 AM to 5:00 PM", "hour.key": "Monday:" }, "9": { "hour.id": 9, "hour.ts": "2018-01-21 20:08:30", "hour.value": "9:00 AM to 5:00 PM", "hour.key": "Tuesday:" }, "10": { "hour.id": 10, "hour.ts": "2018-01-21 20:08:30", "hour.value": "9:00 AM to 5:00 PM", "hour.key": "Wednesday:" }, "11": { "hour.id": 11, "hour.ts": "2018-01-21 20:08:30", "hour.value": "9:00 AM to 5:00 PM", "hour.key": "Thursday:" }, "12": { "hour.id": 12, "hour.ts": "2018-01-21 20:08:30", "hour.value": "9:00 AM to 5:00 PM", "hour.key": "Friday:" }, "13": { "hour.id": 13, "hour.ts": "2018-01-21 20:08:30", "hour.value": "9:00 AM to 5:00 PM", "hour.key": "Saturday:" }, "14": { "hour.id": 14, "hour.ts": "2018-01-21 20:08:30", "hour.value": "9:00 AM to 12:00 PM", "hour.key": "Sunday:" }, "15": { "hour.id": 15, "hour.ts": "2018-01-21 20:08:43", "hour.value": "8:00 AM to 5:00 PM", "hour.key": "Monday:" }, "16": { "hour.id": 16, "hour.ts": "2018-01-21 20:08:43", "hour.value": "8:00 AM to 5:00 PM", "hour.key": "Tuesday:" }, "17": { "hour.id": 17, "hour.ts": "2018-01-21 20:08:43", "hour.value": "8:00 AM to 5:00 PM", "hour.key": "Wednesday:" }, "18": { "hour.id": 18, "hour.ts": "2018-01-21 20:08:43", "hour.value": "8:00 AM to 5:00 PM", "hour.key": "Thursday:" }, "19": { "hour.id": 19, "hour.ts": "2018-01-21 20:08:43", "hour.value": "8:00 AM to 5:00 PM", "hour.key": "Sunday:" }, "24": { "hour.id": 24, "hour.ts": "2018-01-21 20:09:23", "hour.value": "8:00 AM to 5:00 PM", "hour.key": "Friday:" }, "25": { "hour.id": 25, "hour.ts": "2018-01-21 20:09:23", "hour.value": "8:00 AM to 5:00 PM", "hour.key": "Saturday:" }, "27": { "hour.id": 27, "hour.ts": "2018-01-21 20:09:37", "hour.value": "10:00 AM to 10:00 PM", "hour.key": "Monday:" }, "28": { "hour.id": 28, "hour.ts": "2018-01-21 20:09:37", "hour.value": "10:00 AM to 10:00 PM", "hour.key": "Tuesday:" }, "29": { "hour.id": 29, "hour.ts": "2018-01-21 20:09:37", "hour.value": "10:00 AM to 10:00 PM", "hour.key": "Wednesday:" }, "30": { "hour.id": 30, "hour.ts": "2018-01-21 20:09:37", "hour.value": "10:00 AM to 10:00 PM", "hour.key": "Thursday:" }, "31": { "hour.id": 31, "hour.ts": "2018-01-21 20:09:37", "hour.value": "10:00 AM to 10:00 PM", "hour.key": "Friday:" }, "32": { "hour.id": 32, "hour.ts": "2018-01-21 20:09:37", "hour.value": "12:00 AM to 12:00 AM", "hour.key": "Saturday:" }, "33": { "hour.id": 33, "hour.ts": "2018-01-21 20:09:37", "hour.value": "12:00 AM to 12:00 AM", "hour.key": "Sunday:" }, "40": { "hour.id": 40, "hour.ts": "2018-01-21 20:12:54", "hour.value": "9:00 AM to 11:00 PM", "hour.key": "Monday:" }, "41": { "hour.id": 41, "hour.ts": "2018-01-21 20:12:54", "hour.value": "9:00 AM to 11:00 PM", "hour.key": "Tuesday:" }, "42": { "hour.id": 42, "hour.ts": "2018-01-21 20:12:54", "hour.value": "9:00 AM to 11:00 PM", "hour.key": "Wednesday:" }, "43": { "hour.id": 43, "hour.ts": "2018-01-21 20:12:54", "hour.value": "9:00 AM to 11:00 PM", "hour.key": "Thursday:" }, "44": { "hour.id": 44, "hour.ts": "2018-01-21 20:12:54", "hour.value": "9:00 AM to 10:00 PM", "hour.key": "Friday:" }, "45": { "hour.id": 45, "hour.ts": "2018-01-21 20:12:54", "hour.value": "9:00 AM to 9:00 PM", "hour.key": "Saturday:" }, "46": { "hour.id": 46, "hour.ts": "2018-01-21 20:12:54", "hour.value": "9:00 AM to 8:00 PM", "hour.key": "Sunday:" }, "47": { "hour.id": 47, "hour.ts": "2018-01-21 20:13:45", "hour.value": "7:00 AM to 6:00 PM", "hour.key": "Monday:" }, "48": { "hour.id": 48, "hour.ts": "2018-01-21 20:13:45", "hour.value": "7:00 AM to 6:00 PM", "hour.key": "Tuesday:" }, "49": { "hour.id": 49, "hour.ts": "2018-01-21 20:13:45", "hour.value": "7:00 AM to 6:00 PM", "hour.key": "Wednesday:" }, "50": { "hour.id": 50, "hour.ts": "2018-01-21 20:13:45", "hour.value": "7:00 AM to 6:00 PM", "hour.key": "Thursday:" }, "51": { "hour.id": 51, "hour.ts": "2018-01-21 20:13:45", "hour.value": "7:00 AM to 6:00 PM", "hour.key": "Friday:" }, "52": { "hour.id": 52, "hour.ts": "2018-01-21 20:13:45", "hour.value": "9:00 AM to 1:00 PM", "hour.key": "Saturday:" }, "53": { "hour.id": 53, "hour.ts": "2018-01-21 20:13:45", "hour.value": "9:00 AM to 1:00 PM", "hour.key": "Sunday:" }, "54": { "hour.id": 54, "hour.ts": "2018-01-21 20:13:53", "hour.value": "7:00 AM to 5:00 PM", "hour.key": "Monday:" }, "55": { "hour.id": 55, "hour.ts": "2018-01-21 20:13:53", "hour.value": "7:00 AM to 5:00 PM", "hour.key": "Tuesday:" }, "56": { "hour.id": 56, "hour.ts": "2018-01-21 20:13:53", "hour.value": "7:00 AM to 5:00 PM", "hour.key": "Wednesday:" }, "57": { "hour.id": 57, "hour.ts": "2018-01-21 20:13:53", "hour.value": "7:00 AM to 5:00 PM", "hour.key": "Thursday:" }, "58": { "hour.id": 58, "hour.ts": "2018-01-21 20:13:53", "hour.value": "7:00 AM to 5:00 PM", "hour.key": "Friday:" }, "59": { "hour.id": 59, "hour.ts": "2018-01-21 20:13:53", "hour.value": "7:00 AM to 5:00 PM", "hour.key": "Saturday:" }, "60": { "hour.id": 60, "hour.ts": "2018-01-21 20:13:53", "hour.value": "7:00 AM to 5:00 PM", "hour.key": "Sunday:" }, "68": { "hour.id": 68, "hour.ts": "2018-01-21 20:14:44", "hour.value": "12:00 AM to 7:00 AM", "hour.key": "Monday:" }, "69": { "hour.id": 69, "hour.ts": "2018-01-21 20:14:44", "hour.value": "12:00 AM to 7:00 AM", "hour.key": "Tuesday:" }, "70": { "hour.id": 70, "hour.ts": "2018-01-21 20:14:44", "hour.value": "12:00 AM to 7:00 AM", "hour.key": "Wednesday:" }, "71": { "hour.id": 71, "hour.ts": "2018-01-21 20:14:44", "hour.value": "12:00 AM to 7:00 AM", "hour.key": "Thursday:" }, "72": { "hour.id": 72, "hour.ts": "2018-01-21 20:14:44", "hour.value": "12:00 AM to 7:00 AM", "hour.key": "Friday:" }, "73": { "hour.id": 73, "hour.ts": "2018-01-21 20:14:44", "hour.value": "12:00 AM to 7:00 AM", "hour.key": "Saturday:" }, "74": { "hour.id": 74, "hour.ts": "2018-01-21 20:14:44", "hour.value": "12:00 AM to 7:00 AM", "hour.key": "Sunday:" }, "75": { "hour.id": 75, "hour.ts": "2018-01-21 20:15:53", "hour.value": "7:00 AM to 4:00 PM", "hour.key": "Monday:" }, "76": { "hour.id": 76, "hour.ts": "2018-01-21 20:15:53", "hour.value": "7:00 AM to 4:00 PM", "hour.key": "Tuesday:" }, "77": { "hour.id": 77, "hour.ts": "2018-01-21 20:15:53", "hour.value": "7:00 AM to 4:00 PM", "hour.key": "Wednesday:" }, "78": { "hour.id": 78, "hour.ts": "2018-01-21 20:15:53", "hour.value": "7:00 AM to 4:00 PM", "hour.key": "Thursday:" }, "79": { "hour.id": 79, "hour.ts": "2018-01-21 20:15:53", "hour.value": "7:00 AM to 4:00 PM", "hour.key": "Friday:" }, "80": { "hour.id": 80, "hour.ts": "2018-01-21 20:16:23", "hour.value": "8:00 AM to 6:00 PM", "hour.key": "Monday:" }, "81": { "hour.id": 81, "hour.ts": "2018-01-21 20:16:23", "hour.value": "8:00 AM to 6:00 PM", "hour.key": "Tuesday:" }, "82": { "hour.id": 82, "hour.ts": "2018-01-21 20:16:23", "hour.value": "8:00 AM to 6:00 PM", "hour.key": "Wednesday:" }, "83": { "hour.id": 83, "hour.ts": "2018-01-21 20:16:23", "hour.value": "8:00 AM to 6:00 PM", "hour.key": "Thursday:" }, "84": { "hour.id": 84, "hour.ts": "2018-01-21 20:16:23", "hour.value": "8:00 AM to 6:00 PM", "hour.key": "Friday:" }, "85": { "hour.id": 85, "hour.ts": "2018-01-21 20:16:23", "hour.value": "8:00 AM to 1:00 PM", "hour.key": "Saturday:" }, "86": { "hour.id": 86, "hour.ts": "2018-01-21 20:16:23", "hour.value": "8:00 AM to 1:00 PM", "hour.key": "Sunday:" }, "99": { "hour.id": 99, "hour.ts": "2018-01-21 20:17:05", "hour.value": "9:00 AM to 3:00 PM", "hour.key": "Saturday:" }, "100": { "hour.id": 100, "hour.ts": "2018-01-21 20:17:05", "hour.value": "9:00 AM to 3:00 PM", "hour.key": "Sunday:" }, "106": { "hour.id": 106, "hour.ts": "2018-01-21 20:17:39", "hour.value": "8:00 AM to 7:00 PM", "hour.key": "Monday:" }, "107": { "hour.id": 107, "hour.ts": "2018-01-21 20:17:39", "hour.value": "8:00 AM to 7:00 PM", "hour.key": "Tuesday:" }, "108": { "hour.id": 108, "hour.ts": "2018-01-21 20:17:39", "hour.value": "8:00 AM to 7:00 PM", "hour.key": "Wednesday:" }, "109": { "hour.id": 109, "hour.ts": "2018-01-21 20:17:39", "hour.value": "8:00 AM to 7:00 PM", "hour.key": "Thursday:" }, "110": { "hour.id": 110, "hour.ts": "2018-01-21 20:17:39", "hour.value": "8:00 AM to 7:00 PM", "hour.key": "Sunday:" }, "118": { "hour.id": 118, "hour.ts": "2018-01-21 20:18:04", "hour.value": "12:00 AM to 12:00 AM", "hour.key": "Monday:" }, "119": { "hour.id": 119, "hour.ts": "2018-01-21 20:18:04", "hour.value": "12:00 AM to 12:00 AM", "hour.key": "Tuesday:" }, "120": { "hour.id": 120, "hour.ts": "2018-01-21 20:18:04", "hour.value": "12:00 AM to 12:00 AM", "hour.key": "Wednesday:" }, "121": { "hour.id": 121, "hour.ts": "2018-01-21 20:18:04", "hour.value": "12:00 AM to 12:00 AM", "hour.key": "Thursday:" }, "122": { "hour.id": 122, "hour.ts": "2018-01-21 20:18:04", "hour.value": "12:00 AM to 12:00 AM", "hour.key": "Friday:" }, "123": { "hour.id": 123, "hour.ts": "2018-01-21 20:18:04", "hour.value": "9:00 AM to 12:00 PM", "hour.key": "Saturday:" }, "125": { "hour.id": 125, "hour.ts": "2018-01-21 20:18:13", "hour.value": "5:00 AM to 12:00 PM", "hour.key": "Monday:" }, "126": { "hour.id": 126, "hour.ts": "2018-01-21 20:18:13", "hour.value": "5:00 AM to 12:00 PM", "hour.key": "Tuesday:" }, "127": { "hour.id": 127, "hour.ts": "2018-01-21 20:18:13", "hour.value": "5:00 AM to 12:00 PM", "hour.key": "Wednesday:" }, "128": { "hour.id": 128, "hour.ts": "2018-01-21 20:18:13", "hour.value": "5:00 AM to 12:00 PM", "hour.key": "Thursday:" }, "129": { "hour.id": 129, "hour.ts": "2018-01-21 20:18:13", "hour.value": "5:00 AM to 12:00 PM", "hour.key": "Friday:" }, "130": { "hour.id": 130, "hour.ts": "2018-01-21 20:18:13", "hour.value": "5:00 AM to 12:00 PM", "hour.key": "Saturday:" }, "131": { "hour.id": 131, "hour.ts": "2018-01-21 20:18:13", "hour.value": "5:00 AM to 12:00 PM", "hour.key": "Sunday:" }, "132": { "hour.id": 132, "hour.ts": "2018-01-21 20:18:24", "hour.value": "7:00 AM to 7:00 PM", "hour.key": "Monday:" }, "133": { "hour.id": 133, "hour.ts": "2018-01-21 20:18:24", "hour.value": "7:00 AM to 7:00 PM", "hour.key": "Tuesday:" }, "134": { "hour.id": 134, "hour.ts": "2018-01-21 20:18:24", "hour.value": "7:00 AM to 7:00 PM", "hour.key": "Wednesday:" }, "135": { "hour.id": 135, "hour.ts": "2018-01-21 20:18:24", "hour.value": "7:00 AM to 7:00 PM", "hour.key": "Thursday:" }, "136": { "hour.id": 136, "hour.ts": "2018-01-21 20:18:24", "hour.value": "7:00 AM to 7:00 PM", "hour.key": "Friday:" }, "137": { "hour.id": 137, "hour.ts": "2018-01-21 20:18:24", "hour.value": "7:00 AM to 7:00 PM", "hour.key": "Saturday:" }, "138": { "hour.id": 138, "hour.ts": "2018-01-21 20:18:24", "hour.value": "7:00 AM to 7:00 PM", "hour.key": "Sunday:" }, "151": { "hour.id": 151, "hour.ts": "2018-01-21 20:19:54", "hour.value": "7:00 AM to 8:00 PM", "hour.key": "Monday:" }, "152": { "hour.id": 152, "hour.ts": "2018-01-21 20:19:54", "hour.value": "7:00 AM to 8:00 PM", "hour.key": "Tuesday:" }, "153": { "hour.id": 153, "hour.ts": "2018-01-21 20:19:54", "hour.value": "7:00 AM to 8:00 PM", "hour.key": "Wednesday:" }, "154": { "hour.id": 154, "hour.ts": "2018-01-21 20:19:54", "hour.value": "7:00 AM to 8:00 PM", "hour.key": "Thursday:" }, "155": { "hour.id": 155, "hour.ts": "2018-01-21 20:19:54", "hour.value": "--:-- to 5:00 PM", "hour.key": "Friday:" } } } }