From a 500-row sample across 51 columns.
permitidpermitservicecompanyaxle9spaceaxle2space+29permitid| permitid | fullpermitno | fullapplicationno | applicationdate | issuedate | permitdate | permitdateto | permitallowedfrom | permitallowedto | permitservicecompany | permitteecompany | truckyear |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 529867 | OOWO-2021721-19065 | Ans-2021720-20437 | 2021-07-20T11:18:28.000Z | 2021-07-21T09:55:58.000Z | 2021-07-22T00:00:00.000Z | 2021-07-23T00:00:00.000Z | 2021-07-21T02:00:00.000Z | 2021-07-21T01:59:00.000Z | Anslem King 817 DD | UPTOWN LOCALS, INC. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permitid | integer | — | 0% | 616133415390461061 |
fullpermitno | text | — | 0% | IH2L-2024910-27181JY5Q-2024124-34690FRKC-202496-26904 |
fullapplicationno | text | — | 0% | 144-2024126-3701144-2024221-6977144-202425-4784 |
applicationdate | datetime | — | 0% | 2018-07-26T15:05:22.000Z2024-04-04T12:22:50.000Z2019-07-26T12:17:54.000Z |
GET /api/datasets/as69-ew8f GET /api/datasets/as69-ew8f/quality GET /api/datasets/as69-ew8f/related GET /api/columns?dataset=as69-ew8f
| 2005 |
| 579379 | BSMJ-202282-28106 | App-202282-29824 | 2022-08-02T09:55:30.000Z | 2022-08-02T15:09:02.000Z | 2022-08-03T00:00:00.000Z | 2022-08-04T00:00:00.000Z | 2022-08-02T04:00:00.000Z | 2022-08-02T03:59:00.000Z | Joseph Gonzalez 817 | Apple Inc. Ever's Blueberry S1 | 2013 |
| 567002 | BQF9-202259-16486 | HAR-202256-17447 | 2022-05-06T14:24:13.000Z | 2022-05-09T10:41:52.000Z | 2022-05-10T00:00:00.000Z | 2022-05-11T00:00:00.000Z | 2022-05-09T22:00:00.000Z | 2022-05-09T05:30:00.000Z | HARRIS CAMDEN TERMINAL EQUIPMENT CO | Harris Camden Terminal Equipment Co | 1997 |
| 580628 | YCXM-2022812-29563 | HAR-2022811-31073 | 2022-08-11T08:12:40.000Z | 2022-08-12T13:43:55.000Z | 2022-08-15T00:00:00.000Z | 2022-08-16T00:00:00.000Z | 2022-08-12T22:00:00.000Z | 2022-08-12T05:30:00.000Z | HARRIS CAMDEN TERMINAL EQUIPMENT CO | Harris Camden Terminal Equipment Co | 1992 |
| 552717 | HVOB-202221-3034 | Cit2-2022129-3162 | 2022-01-29T07:51:57.000Z | 2022-02-01T11:55:47.000Z | 2022-02-02T00:00:00.000Z | 2022-02-03T00:00:00.000Z | 2022-02-01T22:00:00.000Z | 2022-02-01T05:30:00.000Z | City Permits, Inc | We Transport LLC | 2017 |
| 571458 | CBVZ-202269-20707 | Hig-202268-21903 | 2022-06-08T14:04:57.000Z | 2022-06-09T09:51:50.000Z | 2022-06-13T00:00:00.000Z | 2022-06-13T00:00:00.000Z | 2022-06-09T00:01:00.000Z | 2022-06-09T05:30:00.000Z | High Wide & Heavy Oversize Escorts LLC | GARYS GARAGE | 1992 |
| 530210 | SH4W-2021726-19675 | Les-2021722-20780 | 2021-07-22T11:05:15.000Z | 2021-07-26T15:43:47.000Z | 2021-07-28T00:00:00.000Z | 2021-07-29T00:00:00.000Z | 2021-07-26T22:00:00.000Z | 2021-07-26T05:30:00.000Z | Lester R. Summers, Inc. | Lester R. Summers, Inc. | 2017 |
| 555234 | P4F4-2022225-6041 | Eli-2022217-5679 | 2022-02-17T10:28:01.000Z | 2022-02-25T09:25:49.000Z | 2022-02-28T00:00:00.000Z | 2022-03-01T00:00:00.000Z | 2022-02-25T22:00:00.000Z | 2022-02-25T05:30:00.000Z | Elite Motor Carrier Escort, LLC. | Dagen Trucking, Co | 2015 |
| 578242 | TKEI-2022726-27052 | New-2022725-28687 | 2022-07-25T14:40:53.000Z | 2022-07-26T09:58:01.000Z | 2022-07-27T00:00:00.000Z | 2022-07-28T00:00:00.000Z | 2022-07-26T22:00:00.000Z | 2022-07-26T05:30:00.000Z | New York Truck Escorts & Permits, Inc. | HIGH TRANSIT LLC | 2018 |
| 633764 | AENH-2023106-31271 | NJ-2023105-33178 | 2023-10-05T23:17:30.000Z | 2023-10-06T09:31:35.000Z | 2023-10-10T00:00:00.000Z | 2023-10-11T00:00:00.000Z | 2023-10-06T22:00:00.000Z | 2023-10-06T05:30:00.000Z | NJ Routing and Logistics | KINDAN LAAL TRANSPORTATIONS | 2016 |
Showing 12 of 56 columns. All of them are listed below.
issuedate | datetime | — | 0% | 2016-06-27T13:42:32.000Z2016-08-18T16:47:39.000Z2016-05-25T14:20:29.000Z |
permitdate | datetime | — | 0% | 2022-12-05T00:00:00.000Z2017-07-27T00:00:00.000Z2023-02-06T00:00:00.000Z |
permitdateto | datetime | — | 0% | 2017-07-28T00:00:00.000Z2017-06-29T00:00:00.000Z2022-12-06T00:00:00.000Z |
permitallowedfrom | datetime | — | 0% | 2017-06-06T22:00:00.000Z2017-10-16T22:00:00.000Z2017-05-16T22:00:00.000Z |
permitallowedto | datetime | — | 0% | 2017-06-06T05:30:00.000Z2017-04-28T05:30:00.000Z2022-02-17T05:30:00.000Z |
permitservicecompany | text | — | 0% | HARRIS CAMDEN TERMINAL …New York Truck Escorts &…High Wide & Heavy Oversi… |
permitteecompany | text | — | 0% | Harris Camden Terminal E…BAY CRANE SERVICE INC.Blue Bloods |
truckyear | text | — | 0% | 201620072015 |
truckmake | text | — | 0% | FREIGHTLINERKENWORTHPETERBILT |
truckstate | text | — | 0% | PANYNJ |
trailerlicno | text | — | 100% | — |
traileryear | text | — | 5% | 201720152007 |
trailermake | text | — | 5% | FONTAINEGREAT DANEMANAC |
trailerstate | text | — | 5% | PANJME |
overallwidth | float | — | 0% | 8.06811.11 |
overalllength | float | — | 0% | 757978 |
overallheight | float | — | 0% | 13.0612.0612 |
trailerlength | float | — | 5% | 534850 |
totalgrossweight | integer | — | 0% | 790005000040000 |
descriptionofload | text | — | 0% | EMPTY TRAILEREMPTYSTEEL FRAME |
loadheight | float | — | 0% | 13.0623 |
loadwidth | float | — | 0% | 8.06811.11 |
loadlength | integer | — | 0% | 534840 |
loadweight | integer | — | 0% | 200003000040000 |
startstreetaddress | text | — | 38% | 47TH ST & MADISON AVE15 Washington Ave364 Maspeth Ave |
startcity | text | — | 38% | BrooklynBROOKLYNMANHATTAN |
startstate | categorical | — | 0% | NYNew Yorkof 2 |
startzipcode | text | — | 0% | 111111122211205 |
startcountyline | text | — | 62% | NJ @ GWBGEORGE WASHINGTON BRIDGENYC/NASSAU LINE @ I-495 |
endstreetaddress | text | — | 35% | 47TH ST & MADISON AVEWEST 33RD ST AND 10TH AV…JFK AIRPORT |
endcity | text | — | 36% | MANHATTANBrooklynQUEENS |
endstate | categorical | — | 0% | NYNew Yorkof 2 |
endzipcode | text | — | 0% | 222221111110017 |
endcountyline | text | — | 64% | GEORGE WASHINGTON BRIDGE…NJ @ GWBNYC/NASSAU LINE @ I-495 |
totalnumberofaxle | integer | — | 0% | 564 |
steeringweight | integer | — | 0% | 120001000014000 |
axle2weight | integer | — | 0% | 100001500012000 |
axle2space | float | — | 0% | 17.061517 |
axle3weight | integer | — | 1% | 10000150007000 |
axle3space | float | — | 1% | 4.064.044 |
axle4weight | integer | — | 2% | 10000150006000 |
axle4space | float | — | 2% | 4.06337 |
axle5weight | integer | — | 14% | 1000060005000 |
axle5space | float | — | 14% | 4.0645 |
axle6weight | integer | — | 70% | 7200600019500 |
axle6space | float | — | 70% | 4.0655.05 |
axle7weight | integer | — | 86% | 60001950014850 |
axle7space | float | — | 86% | 4.0654.02 |
axle8weight | integer | — | 92% | 19500600014850 |
axle8space | float | — | 92% | 4.0655.05 |
axle9weight | integer | — | 97% | 13800600019500 |
axle9space | float | — | 97% | 54.064.04 |
axle10weight | integer | — | 99% | 170001650020000 |
axle10space | float | — | 99% | 54.064.04 |
axle11weight | integer | — | 100% | 20000521012200 |
axle11space | float | — | 100% | 54.114.06 |
wheelbase | float | — | 0% | 6863.0665 |