From a 500-row sample across 64 columns.
permitidaxle2weightaxle2spaceaxle7weight+29permitidstate| permitid | permitapplication | fullpermitno | fullapplicationno | applicationdate | issuedate | permitfromdate | permittodate | permitservicecompany | industrytypename | year | make |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4625 | Crane | MA7R-201619-82 | Bay-20151214-1374 | 2015-12-14T10:29:17.000 | 2016-01-09T15:06:22.000 | 2016-01-09T00:00:00.000 | 2016-12-31T00:00:00.000 | Bay Crane Service Inc | Special Hauling | 2005 | TADANO |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permitid | integer | — | 0% | 474325916910 |
permitapplication | categorical | — | 0% | OverweightCraneBulk Milkof 3 |
fullpermitno | text | — | 0% | HMQ7-2014117-1146HMQ7-2014117-1147HMQ7-2014117-1145 |
fullapplicationno | text | — | 0% | Cas-2014107-1077Cas-2014107-1078Cas-2014107-1080 |
GET /api/datasets/ys48-9d3c GET /api/datasets/ys48-9d3c/quality GET /api/datasets/ys48-9d3c/related GET /api/columns?dataset=ys48-9d3c
| 5404 | Crane | BONL-2016923-725 | FEL-2016825-676 | 2016-08-25T10:46:55.000 | 2016-09-23T10:40:42.000 | 2016-09-23T00:00:00.000 | 2016-12-31T00:00:00.000 | FELDMAN LUMBER- US LBM LLC | Special Hauling | 2017 | FREIGH |
| 6330 | Overweight | K5Y6-201798-677 | The1-201782-438 | 2017-08-02T15:11:00.000 | 2017-09-08T17:51:09.000 | 2017-09-08T00:00:00.000 | 2018-08-31T00:00:00.000 | The Green-Wood Cemetery | Other | 1986 | Volvo White |
| 4279 | Bulk Milk | RLB6-2016114-119 | NYC1-20151019-1028 | 2015-10-19T15:19:53.000 | 2016-01-14T17:44:50.000 | 2015-10-17T00:00:00.000 | 2016-01-16T00:00:00.000 | NYC DOT bm | Bulk Transportation | 2013 | PETERBILT |
| 5031 | Overweight | L8F2-201669-445 | SOL-2016324-303 | 2016-03-24T11:13:16.000 | 2016-06-09T18:00:55.000 | 2016-06-09T00:00:00.000 | 2017-04-30T00:00:00.000 | SOLID WASTE SERVICES, INC. D/B/A J.P. MASCARO & SO | Waste Management | 2000 | VOLVO |
| 2977 | Crane | O94I-2015413-334 | Bay-2014122-1247 | 2014-12-02T10:35:55.000 | 2015-04-13T08:53:30.000 | 2015-04-13T00:00:00.000 | 2015-12-31T00:00:00.000 | Bay Crane Service Inc | Special Hauling | 2006 | LIEBHERR |
| 4584 | Crane | QGZG-20151211-1134 | Sup-2015125-1333 | 2015-12-05T10:59:35.000 | 2015-12-11T14:52:05.000 | 2016-01-01T00:00:00.000 | 2016-12-31T00:00:00.000 | Superior Crane Rental, Inc, | Special Hauling | 2012 | KenW / Manitex |
| 5347 | Overweight | H1OS-2016105-756 | NEW3-201684-619 | 2016-08-04T10:10:25.000 | 2016-10-05T10:01:49.000 | 2016-10-05T00:00:00.000 | 2017-07-31T00:00:00.000 | NEW YORK PAVING INC. | Construction | 1999 | MACK |
| 5775 | Crane | MZLH-2017410-385 | FEL-20161214-1047 | 2016-12-14T08:49:07.000 | 2017-04-10T11:08:31.000 | 2017-04-10T00:00:00.000 | 2017-12-31T00:00:00.000 | FELDMAN LUMBER- US LBM LLC | Special Hauling | 2012 | CORMACH |
| 2431 | Crane | KYZB-2014717-832 | TRI1-2014613-701 | 2014-06-13T13:13:00.000 | 2014-07-17T09:14:37.000 | 2014-07-17T00:00:00.000 | 2014-12-31T00:00:00.000 | TRI STATE LUMBER LTD | Special Hauling | 1996 | FORD |
Showing 12 of 57 columns. All of them are listed below.
applicationdate |
| datetime |
| — |
| 0% |
2014-10-07T08:30:11.0002014-10-07T08:05:22.0002014-10-07T09:00:21.000 |
issuedate | datetime | — | 0% | 2014-11-07T14:52:01.0002014-11-07T15:00:10.0002014-11-07T14:58:23.000 |
permitfromdate | datetime | — | 0% | 2014-11-01T00:00:00.0002017-11-01T00:00:00.0002015-03-23T00:00:00.000 |
permittodate | datetime | — | 0% | 2015-12-31T00:00:00.0002016-12-31T00:00:00.0002017-12-31T00:00:00.000 |
applicationtypename | categorical | — | 37% | RenewalOtherTransferof 5 |
applicationtypeother | text | — | 99% | New with Banked Weight C…Adding an axleRenew |
oldpermitno | text | — | 39% | AWN2-2014517-70200093044AWN2-2014517-701 |
oldexpirationdate | datetime | — | 63% | 2015-04-30T00:00:00.0002014-12-31T00:00:00.0002016-04-30T00:00:00.000 |
oldgrossvehicleweight | integer | — | 70% | 7900012000078000 |
permitservicecompany | text | — | 0% | consolidated edison co. …Bay Crane Service IncWorcester Creameries |
permitteecompany | categorical | — | 92% | Richard Obreza Trucking,…Gerster & Sons III, Inc.Greene Trucking, Inc.of 14 |
industrytypename | categorical | — | 0% | Special HaulingOtherConstructionof 6 |
industrytypeother | categorical | — | 91% | Concrete SupplyFUEL OILfuel and oil coof 15 |
leasecompanyname | categorical | — | 100% | Hudson Valley Idealease …Bedford Carp Constructio…D & D LEASING LLCof 4 |
leaseexpirationdate | coordinate | — | 100% | 20240520000000.00000000020210808000000.00000000020201231000000.000000000of 4 |
year | integer | — | 0% | 200720152005 |
make | text | — | 0% | MACKMackFREIGHTLINER |
model | text | — | 71% | TR450TR450XL-450000 WB95 |
state | categorical | — | 71% | NYNJORof 3 |
cdno | text | — | 71% | 0000N/A6 |
serialno | text | — | 71% | 000050000 WB 95056498 |
manufacturergvwr | integer | — | 8% | 790006400060600 |
registeredgvwr | integer | — | 37% | 7900064000120000 |
vehicletype | categorical | — | 37% | Other SingleDump TruckCement Truckof 5 |
vehicletypeother | text | — | 79% | UTILITYCONCRETE MIXERutility |
permittype | categorical | — | 37% | Type 2, 3 to 4 axlesType 4, 6 axlesType 1, 2 axlesof 4 |
overallwidth | float | — | 15% | 88.069.1 |
overalllength | float | — | 15% | 343541.02 |
overallheight | float | — | 15% | 1212.0312.06 |
totalnoofaxle | categorical | — | 15% | 342of 6 |
wheelbase | float | — | 15% | 17.1112.0521.03 |
loadindescription | categorical | — | 92% | Bulk Raw MilkRaw Bulk MilkBulk Raw MIlkof 4 |
loadinwidth | categorical | — | 92% | 88.06of 2 |
loadinheight | categorical | — | 92% | 11.0612.0312of 3 |
loadinlength | categorical | — | 92% | 6058.0665of 9 |
loadinweight | categorical | — | 92% | 9900098875of 2 |
loadoutdescription | text | — | 92% | Emptyof 1 |
loadoutwidth | categorical | — | 92% | 88.06of 2 |
loadoutheight | categorical | — | 92% | 11.0612.0312of 3 |
loadoutlength | categorical | — | 92% | 6058.0665of 11 |
loadoutweight | categorical | — | 92% | 320603220033380of 15 |
steeringweight | integer | — | 15% | 200001800014600 |
steeringnooftires | categorical | — | 45% | 24of 2 |
steeringloadrating | integer | — | 44% | 20000900010000 |
axle2weight | integer | — | 15% | 230002950029000 |
axle2space | float | — | 15% | 13.0312.0516.09 |
axle2nooftires | categorical | — | 44% | 428of 3 |
axle2loadrating | integer | — | 44% | 5750880010000 |
axle3weight | integer | — | 26% | 230002200029500 |
axle3space | float | — | 26% | 4.064.084.07 |
axle3nooftires | categorical | — | 45% | 423of 4 |
axle3loadrating | integer | — | 45% | 5750880024020 |
axle4weight | integer | — | 64% | 220002300020000 |
axle4space | float | — | 64% | 4.064.075.05 |
axle4nooftires | categorical | — | 78% | 42of 2 |
axle4loadrating | integer | — | 78% | 716061706610 |
axle5weight | integer | — | 98% | 214522186021300 |
axle5space | categorical | — | 98% | 5.054.065of 9 |
axle5nooftires | integer | — | 100% | 4of 1 |
axle5loadrating | integer | — | 100% | 6250of 1 |
axle6weight | categorical | — | 100% | 78001876022000of 3 |
axle6space | categorical | — | 100% | 4.0754.01of 3 |
axle6nooftires | integer | — | 100% | 4of 1 |
axle6loadrating | integer | — | 100% | 6250of 1 |
axle7weight | integer | — | 100% | 12500of 1 |
axle7space | integer | — | 100% | 5of 1 |
axle7nooftires | numeric | — | 100% | — |
axle7loadrating | numeric | — | 100% | — |
axle8weight | numeric | — | 100% | — |
axle8space | numeric | — | 100% | — |
axle8nooftires | numeric | — | 100% | — |
axle8loadrating | numeric | — | 100% | — |
axle9weight | numeric | — | 100% | — |
axle9space | numeric | — | 100% | — |
axle9nooftires | numeric | — | 100% | — |
axle9loadrating | numeric | — | 100% | — |
axle10weight | numeric | — | 100% | — |
axle10space | numeric | — | 100% | — |
axle10nooftires | numeric | — | 100% | — |
axle10loadrating | numeric | — | 100% | — |
axle11weight | numeric | — | 100% | — |
axle11space | numeric | — | 100% | — |
axle11nooftires | numeric | — | 100% | — |
axle11loadrating | numeric | — | 100% | — |