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/city/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_contractor/by_table/city/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_contractor/by_table/city/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 100, "limit_total": 400, "time": 0.00136999999999999990708821062668221202329732477664947509765625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 2478, "pages_total": 25 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "201": { "city.id": 201, "city.ts": "2018-01-15 04:58:34", "city.title": "Brea", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "202": { "city.id": 202, "city.ts": "2018-01-15 04:58:34", "city.title": "Buena Park", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "203": { "city.id": 203, "city.ts": "2018-01-15 04:58:34", "city.title": "Burbank", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "204": { "city.id": 204, "city.ts": "2018-01-15 04:58:34", "city.title": "Calabasas", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "205": { "city.id": 205, "city.ts": "2018-01-15 04:58:34", "city.title": "Canoga Park", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "206": { "city.id": 206, "city.ts": "2018-01-15 04:58:34", "city.title": "Chatsworth", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "207": { "city.id": 207, "city.ts": "2018-01-15 04:58:34", "city.title": "Costa Mesa", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "208": { "city.id": 208, "city.ts": "2018-01-15 04:58:34", "city.title": "Culver City", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "209": { "city.id": 209, "city.ts": "2018-01-15 04:58:34", "city.title": "Cypress", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "210": { "city.id": 210, "city.ts": "2018-01-15 04:58:34", "city.title": "Encino", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "211": { "city.id": 211, "city.ts": "2018-01-15 04:58:34", "city.title": "Fountain Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "212": { "city.id": 212, "city.ts": "2018-01-15 04:58:34", "city.title": "Fullerton", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "213": { "city.id": 213, "city.ts": "2018-01-15 04:58:34", "city.title": "Garden Grove", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "214": { "city.id": 214, "city.ts": "2018-01-15 04:58:34", "city.title": "Glendale", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "215": { "city.id": 215, "city.ts": "2018-01-15 04:58:34", "city.title": "Granada Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "216": { "city.id": 216, "city.ts": "2018-01-15 04:58:34", "city.title": "Huntington Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "217": { "city.id": 217, "city.ts": "2018-01-15 04:58:34", "city.title": "Irvine", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "218": { "city.id": 218, "city.ts": "2018-01-15 04:58:34", "city.title": "La Habra", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "219": { "city.id": 219, "city.ts": "2018-01-15 04:58:34", "city.title": "La Palma", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "220": { "city.id": 220, "city.ts": "2018-01-15 04:58:34", "city.title": "Laguna Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "221": { "city.id": 221, "city.ts": "2018-01-15 04:58:34", "city.title": "Lake Forest", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "222": { "city.id": 222, "city.ts": "2018-01-15 04:58:34", "city.title": "Lakewood", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "223": { "city.id": 223, "city.ts": "2018-01-15 04:58:34", "city.title": "Long Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "224": { "city.id": 224, "city.ts": "2018-01-15 04:58:34", "city.title": "Los Alamitos", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "225": { "city.id": 225, "city.ts": "2018-01-15 04:58:34", "city.title": "Mission Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "226": { "city.id": 226, "city.ts": "2018-01-15 04:58:34", "city.title": "Mission Viejo", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "227": { "city.id": 227, "city.ts": "2018-01-15 04:58:34", "city.title": "Newport Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "228": { "city.id": 228, "city.ts": "2018-01-15 04:58:34", "city.title": "North Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "229": { "city.id": 229, "city.ts": "2018-01-15 04:58:34", "city.title": "Northridge", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "230": { "city.id": 230, "city.ts": "2018-01-15 04:58:34", "city.title": "Orange", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "231": { "city.id": 231, "city.ts": "2018-01-15 04:58:34", "city.title": "Pasadena", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "232": { "city.id": 232, "city.ts": "2018-01-15 04:58:34", "city.title": "Placentia", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "233": { "city.id": 233, "city.ts": "2018-01-15 04:58:34", "city.title": "Porter Ranch", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "234": { "city.id": 234, "city.ts": "2018-01-15 04:58:34", "city.title": "Reseda", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "235": { "city.id": 235, "city.ts": "2018-01-15 04:58:34", "city.title": "San Diego", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "236": { "city.id": 236, "city.ts": "2018-01-15 04:58:34", "city.title": "Santa Ana", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "237": { "city.id": 237, "city.ts": "2018-01-15 04:58:34", "city.title": "Santa Clarita", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "238": { "city.id": 238, "city.ts": "2018-01-15 04:58:34", "city.title": "Santa Monica", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "239": { "city.id": 239, "city.ts": "2018-01-15 04:58:34", "city.title": "Seal Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "240": { "city.id": 240, "city.ts": "2018-01-15 04:58:34", "city.title": "Tarzana", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "241": { "city.id": 241, "city.ts": "2018-01-15 04:58:34", "city.title": "Tustin", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "242": { "city.id": 242, "city.ts": "2018-01-15 04:58:34", "city.title": "Universal City", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "243": { "city.id": 243, "city.ts": "2018-01-15 04:58:34", "city.title": "Valencia", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "244": { "city.id": 244, "city.ts": "2018-01-15 04:58:34", "city.title": "Valley Village", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "245": { "city.id": 245, "city.ts": "2018-01-15 04:58:34", "city.title": "Villa Park", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "246": { "city.id": 246, "city.ts": "2018-01-15 04:58:34", "city.title": "West Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "247": { "city.id": 247, "city.ts": "2018-01-15 04:58:34", "city.title": "West Hollywood", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "248": { "city.id": 248, "city.ts": "2018-01-15 04:58:34", "city.title": "Westminster", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "249": { "city.id": 249, "city.ts": "2018-01-15 04:58:34", "city.title": "Yorba Linda", "city.state": "California", "state.id": 5, "state.ts": "2018-01-15 04:56:56", "state.title": "California" }, "250": { "city.id": 250, "city.ts": "2018-01-15 04:58:36", "city.title": "Berthoud", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "251": { "city.id": 251, "city.ts": "2018-01-15 04:58:36", "city.title": "Boulder", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "252": { "city.id": 252, "city.ts": "2018-01-15 04:58:36", "city.title": "Brighton", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "253": { "city.id": 253, "city.ts": "2018-01-15 04:58:36", "city.title": "Buffalo Creek", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "254": { "city.id": 254, "city.ts": "2018-01-15 04:58:36", "city.title": "Cascade", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "255": { "city.id": 255, "city.ts": "2018-01-15 04:58:36", "city.title": "Castle Rock", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "256": { "city.id": 256, "city.ts": "2018-01-15 04:58:36", "city.title": "Colorado Springs", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "257": { "city.id": 257, "city.ts": "2018-01-15 04:58:36", "city.title": "Commerce City", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "258": { "city.id": 258, "city.ts": "2018-01-15 04:58:36", "city.title": "Conifer", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "259": { "city.id": 259, "city.ts": "2018-01-15 04:58:36", "city.title": "Dacono", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "260": { "city.id": 260, "city.ts": "2018-01-15 04:58:36", "city.title": "Dupont", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "261": { "city.id": 261, "city.ts": "2018-01-15 04:58:36", "city.title": "Eldorado Springs", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "262": { "city.id": 262, "city.ts": "2018-01-15 04:58:36", "city.title": "Erie", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "263": { "city.id": 263, "city.ts": "2018-01-15 04:58:36", "city.title": "Evergreen", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "264": { "city.id": 264, "city.ts": "2018-01-15 04:58:36", "city.title": "Firestone", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "265": { "city.id": 265, "city.ts": "2018-01-15 04:58:36", "city.title": "Fort Collins", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "266": { "city.id": 266, "city.ts": "2018-01-15 04:58:36", "city.title": "Fort Lupton", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "267": { "city.id": 267, "city.ts": "2018-01-15 04:58:36", "city.title": "Fountain", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "268": { "city.id": 268, "city.ts": "2018-01-15 04:58:36", "city.title": "Franktown", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "269": { "city.id": 269, "city.ts": "2018-01-15 04:58:36", "city.title": "Frederick", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "270": { "city.id": 270, "city.ts": "2018-01-15 04:58:36", "city.title": "Golden", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "271": { "city.id": 271, "city.ts": "2018-01-15 04:58:36", "city.title": "Greeley", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "272": { "city.id": 272, "city.ts": "2018-01-15 04:58:36", "city.title": "Green Mountain Falls", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "273": { "city.id": 273, "city.ts": "2018-01-15 04:58:36", "city.title": "Henderson", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "274": { "city.id": 274, "city.ts": "2018-01-15 04:58:36", "city.title": "Hygiene", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "275": { "city.id": 275, "city.ts": "2018-01-15 04:58:36", "city.title": "Idledale", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "276": { "city.id": 276, "city.ts": "2018-01-15 04:58:36", "city.title": "Indian Hills", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "277": { "city.id": 277, "city.ts": "2018-01-15 04:58:36", "city.title": "Johnstown", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "278": { "city.id": 278, "city.ts": "2018-01-15 04:58:36", "city.title": "Kittredge", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "279": { "city.id": 279, "city.ts": "2018-01-15 04:58:36", "city.title": "Lafayette", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "280": { "city.id": 280, "city.ts": "2018-01-15 04:58:36", "city.title": "Larkspur", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "281": { "city.id": 281, "city.ts": "2018-01-15 04:58:36", "city.title": "Longmont", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "282": { "city.id": 282, "city.ts": "2018-01-15 04:58:36", "city.title": "Louisville", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "283": { "city.id": 283, "city.ts": "2018-01-15 04:58:36", "city.title": "Louviers", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "284": { "city.id": 284, "city.ts": "2018-01-15 04:58:36", "city.title": "Loveland", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "285": { "city.id": 285, "city.ts": "2018-01-15 04:58:36", "city.title": "Manitou Springs", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "286": { "city.id": 286, "city.ts": "2018-01-15 04:58:36", "city.title": "Mead", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "287": { "city.id": 287, "city.ts": "2018-01-15 04:58:36", "city.title": "Milliken", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "288": { "city.id": 288, "city.ts": "2018-01-15 04:58:36", "city.title": "Monument", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "289": { "city.id": 289, "city.ts": "2018-01-15 04:58:36", "city.title": "Morrison", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "290": { "city.id": 290, "city.ts": "2018-01-15 04:58:36", "city.title": "Niwot", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "291": { "city.id": 291, "city.ts": "2018-01-15 04:58:36", "city.title": "Palmer Lake", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "292": { "city.id": 292, "city.ts": "2018-01-15 04:58:36", "city.title": "Parker", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "293": { "city.id": 293, "city.ts": "2018-01-15 04:58:36", "city.title": "Pine", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "294": { "city.id": 294, "city.ts": "2018-01-15 04:58:36", "city.title": "Sedalia", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "295": { "city.id": 295, "city.ts": "2018-01-15 04:58:36", "city.title": "Thornton", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "296": { "city.id": 296, "city.ts": "2018-01-15 04:58:36", "city.title": "Timnath", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "297": { "city.id": 297, "city.ts": "2018-01-15 04:58:36", "city.title": "USAF Academy", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "298": { "city.id": 298, "city.ts": "2018-01-15 04:58:36", "city.title": "Watkins", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "299": { "city.id": 299, "city.ts": "2018-01-15 04:58:36", "city.title": "Windsor", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-01-15 04:56:56", "state.title": "Colorado" }, "300": { "city.id": 300, "city.ts": "2018-01-15 04:58:39", "city.title": "Ansonia", "city.state": "Connecticut", "state.id": 7, "state.ts": "2018-01-15 04:56:56", "state.title": "Connecticut" } } } }