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/service_area/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_contractor/by_table/service_area/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.000779999999999999985879350905548790251486934721469879150390625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 6981, "pages_total": 70 }, "struct": { "stem": { "0": "service_area" }, "leaf": "service_area.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "service_area.id": 1, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Birmingham" }, "2": { "service_area.id": 2, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Bessemer" }, "3": { "service_area.id": 3, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Alabaster" }, "4": { "service_area.id": 4, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Quinton" }, "5": { "service_area.id": 5, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Docena" }, "6": { "service_area.id": 6, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Vance" }, "7": { "service_area.id": 7, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Adamsville" }, "8": { "service_area.id": 8, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Siluria" }, "9": { "service_area.id": 9, "service_area.ts": "2018-01-21 20:06:00", "service_area.value": "Brookside" }, "10": { "service_area.id": 10, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Mobile" }, "11": { "service_area.id": 11, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Theodore" }, "12": { "service_area.id": 12, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Eight Mile" }, "13": { "service_area.id": 13, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Fairhope" }, "14": { "service_area.id": 14, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Bayou La Batre" }, "15": { "service_area.id": 15, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Point Clear" }, "16": { "service_area.id": 16, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Irvington" }, "17": { "service_area.id": 17, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Dauphin Island" }, "18": { "service_area.id": 18, "service_area.ts": "2018-01-21 20:06:18", "service_area.value": "Semmes" }, "20": { "service_area.id": 20, "service_area.ts": "2018-01-21 20:06:26", "service_area.value": "Foley" }, "22": { "service_area.id": 22, "service_area.ts": "2018-01-21 20:06:26", "service_area.value": "Saraland" }, "23": { "service_area.id": 23, "service_area.ts": "2018-01-21 20:06:26", "service_area.value": "Montrose" }, "25": { "service_area.id": 25, "service_area.ts": "2018-01-21 20:06:26", "service_area.value": "Silverhill" }, "26": { "service_area.id": 26, "service_area.ts": "2018-01-21 20:06:26", "service_area.value": "Bay Minette" }, "27": { "service_area.id": 27, "service_area.ts": "2018-01-21 20:06:26", "service_area.value": "Satsuma" }, "28": { "service_area.id": 28, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "Miami" }, "29": { "service_area.id": 29, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "Orlando" }, "30": { "service_area.id": 30, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "Tampa" }, "31": { "service_area.id": 31, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "Jacksonville" }, "32": { "service_area.id": 32, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "Fort Lauderdale" }, "34": { "service_area.id": 34, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "Saint Petersburg" }, "35": { "service_area.id": 35, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "Pensacola" }, "36": { "service_area.id": 36, "service_area.ts": "2018-01-21 20:06:40", "service_area.value": "West Palm Beach" }, "38": { "service_area.id": 38, "service_area.ts": "2018-01-21 20:06:51", "service_area.value": "Trussville" }, "39": { "service_area.id": 39, "service_area.ts": "2018-01-21 20:06:51", "service_area.value": "Leeds" }, "40": { "service_area.id": 40, "service_area.ts": "2018-01-21 20:06:51", "service_area.value": "Alton" }, "41": { "service_area.id": 41, "service_area.ts": "2018-01-21 20:06:51", "service_area.value": "Fultondale" }, "42": { "service_area.id": 42, "service_area.ts": "2018-01-21 20:06:51", "service_area.value": "New Castle" }, "43": { "service_area.id": 43, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Remlap" }, "44": { "service_area.id": 44, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Allgood" }, "45": { "service_area.id": 45, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Blountsville" }, "46": { "service_area.id": 46, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Kimberly" }, "47": { "service_area.id": 47, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Gardendale" }, "48": { "service_area.id": 48, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Empire" }, "49": { "service_area.id": 49, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Locust Fork" }, "50": { "service_area.id": 50, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Hanceville" }, "51": { "service_area.id": 51, "service_area.ts": "2018-01-21 20:06:58", "service_area.value": "Oneonta" }, "53": { "service_area.id": 53, "service_area.ts": "2018-01-21 20:07:04", "service_area.value": "Moody" }, "56": { "service_area.id": 56, "service_area.ts": "2018-01-21 20:07:04", "service_area.value": "Vandiver" }, "58": { "service_area.id": 58, "service_area.ts": "2018-01-21 20:07:04", "service_area.value": "Chelsea" }, "59": { "service_area.id": 59, "service_area.ts": "2018-01-21 20:07:04", "service_area.value": "Sterrett" }, "60": { "service_area.id": 60, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Atlanta" }, "62": { "service_area.id": 62, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Marietta" }, "63": { "service_area.id": 63, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Decatur" }, "64": { "service_area.id": 64, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Biloxi" }, "65": { "service_area.id": 65, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Norcross" }, "66": { "service_area.id": 66, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Pascagoula" }, "67": { "service_area.id": 67, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Lawrenceville" }, "68": { "service_area.id": 68, "service_area.ts": "2018-01-21 20:07:17", "service_area.value": "Kennesaw" }, "71": { "service_area.id": 71, "service_area.ts": "2018-01-21 20:07:25", "service_area.value": "Gulf Shores" }, "75": { "service_area.id": 75, "service_area.ts": "2018-01-21 20:07:25", "service_area.value": "Robertsdale" }, "76": { "service_area.id": 76, "service_area.ts": "2018-01-21 20:07:25", "service_area.value": "Orange Beach" }, "80": { "service_area.id": 80, "service_area.ts": "2018-01-21 20:07:36", "service_area.value": "Magnolia Springs" }, "82": { "service_area.id": 82, "service_area.ts": "2018-01-21 20:07:36", "service_area.value": "Perdido" }, "88": { "service_area.id": 88, "service_area.ts": "2018-01-21 20:07:40", "service_area.value": "Creola" }, "90": { "service_area.id": 90, "service_area.ts": "2018-01-21 20:07:40", "service_area.value": "Chunchula" }, "102": { "service_area.id": 102, "service_area.ts": "2018-01-21 20:07:56", "service_area.value": "Tuscaloosa" }, "103": { "service_area.id": 103, "service_area.ts": "2018-01-21 20:07:56", "service_area.value": "Cullman" }, "105": { "service_area.id": 105, "service_area.ts": "2018-01-21 20:07:56", "service_area.value": "Jasper" }, "106": { "service_area.id": 106, "service_area.ts": "2018-01-21 20:07:56", "service_area.value": "Northport" }, "107": { "service_area.id": 107, "service_area.ts": "2018-01-21 20:07:56", "service_area.value": "Pell City" }, "108": { "service_area.id": 108, "service_area.ts": "2018-01-21 20:07:56", "service_area.value": "Coaling" }, "109": { "service_area.id": 109, "service_area.ts": "2018-01-21 20:07:56", "service_area.value": "Clanton" }, "112": { "service_area.id": 112, "service_area.ts": "2018-01-21 20:08:09", "service_area.value": "Shannon" }, "118": { "service_area.id": 118, "service_area.ts": "2018-01-21 20:08:09", "service_area.value": "Dora" }, "124": { "service_area.id": 124, "service_area.ts": "2018-01-21 20:08:19", "service_area.value": "Dolomite" }, "125": { "service_area.id": 125, "service_area.ts": "2018-01-21 20:08:19", "service_area.value": "Fairfield" }, "126": { "service_area.id": 126, "service_area.ts": "2018-01-21 20:08:19", "service_area.value": "Adger" }, "127": { "service_area.id": 127, "service_area.ts": "2018-01-21 20:08:19", "service_area.value": "Mulga" }, "135": { "service_area.id": 135, "service_area.ts": "2018-01-21 20:08:20", "service_area.value": "Harpersville" }, "142": { "service_area.id": 142, "service_area.ts": "2018-01-21 20:08:27", "service_area.value": "Parrish" }, "150": { "service_area.id": 150, "service_area.ts": "2018-01-21 20:08:30", "service_area.value": "Sylacauga" }, "151": { "service_area.id": 151, "service_area.ts": "2018-01-21 20:08:30", "service_area.value": "Talladega" }, "161": { "service_area.id": 161, "service_area.ts": "2018-01-21 20:08:35", "service_area.value": "Steele" }, "162": { "service_area.id": 162, "service_area.ts": "2018-01-21 20:08:35", "service_area.value": "Odenville" }, "163": { "service_area.id": 163, "service_area.ts": "2018-01-21 20:08:35", "service_area.value": "Cropwell" }, "167": { "service_area.id": 167, "service_area.ts": "2018-01-21 20:08:43", "service_area.value": "Cordova" }, "169": { "service_area.id": 169, "service_area.ts": "2018-01-21 20:08:43", "service_area.value": "Sipsey" }, "174": { "service_area.id": 174, "service_area.ts": "2018-01-21 20:08:48", "service_area.value": "Montgomery" }, "182": { "service_area.id": 182, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "Houston" }, "183": { "service_area.id": 183, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "El Paso" }, "184": { "service_area.id": 184, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "Dallas" }, "185": { "service_area.id": 185, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "San Antonio" }, "186": { "service_area.id": 186, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "Oklahoma City" }, "187": { "service_area.id": 187, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "Austin" }, "188": { "service_area.id": 188, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "Memphis" }, "189": { "service_area.id": 189, "service_area.ts": "2018-01-21 20:08:58", "service_area.value": "New Orleans" }, "192": { "service_area.id": 192, "service_area.ts": "2018-01-21 20:09:08", "service_area.value": "Anniston" }, "193": { "service_area.id": 193, "service_area.ts": "2018-01-21 20:09:08", "service_area.value": "Gadsden" }, "194": { "service_area.id": 194, "service_area.ts": "2018-01-21 20:09:08", "service_area.value": "Rome" }, "198": { "service_area.id": 198, "service_area.ts": "2018-01-21 20:09:08", "service_area.value": "Boaz" } } } }