From a 500-row sample across 8 columns.
is_veh_stolenappl_dateeffective_date+2is_veh_stolenappl_datepermit_num+2is_veh_stolenappl_datepermit_num+5| permit_num | effective_date | expiration_date | issue_date | permit_status | is_veh_stolen | appl_date | status |
|---|---|---|---|---|---|---|---|
| 334497 | 2008-12-04T00:00:00.000 | 2011-06-30T00:00:00.000 | 2008-04-16T00:00:00.000 | Expired | NULL | 2008-11-15T00:00:00.000 | Complete |
| 608529 | 2015-01-17T00:00:00.000 | 2017-09-30T00:00:00.000 | 2014-03-04T00:00:00.000 | Expired | NULL | 2015-01-06T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permit_num | text | The unique number assigned to each permit distributed. | 0% | NYC PPPD-2025-1024677NYC PPPD-2025-1026586NYC PPPD-2025-1022815 |
effective_date | datetime | The date the permit is active. | 0% | 2024-10-21T00:00:00.0002025-04-02T00:00:00.0002025-03-14T00:00:00.000 |
expiration_date | datetime | The date the permit is inactive. | 0% | 2028-04-30T00:00:00.0002027-10-31T00:00:00.0002027-12-31T00:00:00.000 |
issue_date | datetime | The date the permit was issued. | 0% |
GET /api/datasets/gc8d-bnmn GET /api/datasets/gc8d-bnmn/quality GET /api/datasets/gc8d-bnmn/related GET /api/columns?dataset=gc8d-bnmn
expiration_date| Complete |
| 2849586 | 2009-12-21T00:00:00.000 | 2011-01-31T00:00:00.000 | 2008-08-15T00:00:00.000 | Inactive | NULL | 2009-11-23T00:00:00.000 | Complete |
| 100367 | 2002-07-03T00:00:00.000 | 2005-06-30T00:00:00.000 | 2005-02-04T00:00:00.000 | Expired | NULL | 2005-02-04T00:00:00.000 | Complete |
| 100368 | 2002-07-03T00:00:00.000 | 2005-06-30T00:00:00.000 | 2005-02-04T00:00:00.000 | Expired | NULL | 2005-02-04T00:00:00.000 | Complete |
| 966785 | 2001-09-05T00:00:00.000 | 2004-02-29T00:00:00.000 | 2005-02-04T00:00:00.000 | Expired | NULL | 2005-02-04T00:00:00.000 | Complete |
| 1568574 | 2003-12-03T00:00:00.000 | 2005-06-30T00:00:00.000 | 2005-02-04T00:00:00.000 | Expired | NULL | 2005-02-04T00:00:00.000 | Complete |
| 107144 | 2002-09-06T00:00:00.000 | 2005-08-31T00:00:00.000 | 2005-02-04T00:00:00.000 | Expired | NULL | 2005-02-04T00:00:00.000 | Complete |
| 108346 | 2002-10-09T00:00:00.000 | 2005-08-31T00:00:00.000 | 2005-02-04T00:00:00.000 | Expired | NULL | 2005-02-04T00:00:00.000 | Complete |
| 108347 | 2002-10-09T00:00:00.000 | 2005-08-31T00:00:00.000 | 2005-02-04T00:00:00.000 | Expired | NULL | 2005-02-04T00:00:00.000 | Complete |
2005-02-04T00:00:00.0002018-03-23T00:00:00.0002017-03-20T00:00:00.000 |
permit_status | categorical | The status of the permit. | 0% | ExpiredActiveRevoked NRof 9 |
is_veh_stolen | categorical | This indicates if the permit has been lost as a result of vehicle theft. | 0% | NULLLostStolenof 3 |
appl_date | datetime | The permit application submission date. | 0% | 0001-01-02T00:00:00.0002017-10-02T00:00:00.0001988-01-01T00:00:00.000 |
status | categorical | The status of the permit application submission. | 0% | CompletePrinted/CompletedDOT Final Reviewof 6 |