From a 500-row sample across 6 columns.
effective_dateexpiration_dateis_veh_stolen+2effective_datestatus_1expiration_date+2effective_dateexpiration_dateis_veh_stolen+2| permit_tag | effective_date | expiration_date | status | appl_date | status_1 |
|---|---|---|---|---|---|
| 1612595 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-09-08T00:00:00.000 | Complete |
| 1612596 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-16T00:00:00.000 | Complete |
| 1612597 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-09-29T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permit_tag | integer | The unique number assigned to the state permit tag. | 0% | 617195451897326171951 |
effective_date | datetime | The date the permit is active. | 0% | 2016-04-27T00:00:00.0002007-08-20T00:00:00.0002017-02-15T00:00:00.000 |
expiration_date | datetime | The date the permit is inactive. | 0% | 2023-11-30T00:00:00.0002023-10-31T00:00:00.0002023-12-31T00:00:00.000 |
status | categorical | The status of the permit. | 0% |
GET /api/datasets/gms8-qcv5 GET /api/datasets/gms8-qcv5/quality GET /api/datasets/gms8-qcv5/related GET /api/columns?dataset=gms8-qcv5
expiration_dateexpiration_date| Complete |
| 1612598 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-02T00:00:00.000 | Complete |
| 1612600 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-19T00:00:00.000 | Complete |
| 1612601 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-16T00:00:00.000 | Complete |
| 1612602 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-10T00:00:00.000 | Complete |
| 1612603 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-20T00:00:00.000 | Complete |
| 1612604 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-19T00:00:00.000 | Complete |
| 1612605 | 2023-12-05T00:00:00.000 | 2024-06-30T00:00:00.000 | Active | 2023-10-23T00:00:00.000 | Complete |
ExpiredActiveAis_veh_stolen | text | This indicates if the permit has been lost as a result of vehicle theft. | 94% | NULLof 1 |
appl_date | datetime | The permit application submission date. | 0% | 0001-01-02T00:00:00.0002017-10-02T00:00:00.0002018-11-17T00:00:00.000 |
status_1 | categorical | The status of the permit application submission. | 0% | CompleteCof 2 |