From a 500-row sample across 5 columns.
createdonpermitnumbermodifiedoncreatedonpermitnumbermodifiedoncreatedonpermitnumbercreatedonpermitnumber| permitnumber | feetype | permitfeeamountcharged | createdon | modifiedon |
|---|---|---|---|---|
| B012017065C17 | ADMINISTRATION FEE | 135 | 2017-03-06T15:52:47.000 | 2021-08-01T00:05:27.000 |
| B012021323B37 | ADMINISTRATION FEE | 135 | 2021-11-19T12:09:49.000 | 2024-12-19T00:05:37.000 |
| B012018352A33 | INSPECTION FEE | 245 | 2018-12-18T09:35:24.000 | 2022-01-16T00:05:35.000 |
| S012018239A27 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permitnumber | text | — | 0% | Q011998183075Q011998244039Q012001081104 |
feetype | text | — | 0% | ADMINISTRATION FEEINSPECTION FEEEMERGENCY FEE |
permitfeeamountcharged | integer | — | 0% | 1355030 |
createdon | datetime | — | 0% | 2013-12-14T21:03:08.0002014-01-02T15:44:43.0002013-12-17T12:02:46.000 |
GET /api/datasets/9fnm-j6if GET /api/datasets/9fnm-j6if/quality GET /api/datasets/9fnm-j6if/related GET /api/columns?dataset=9fnm-j6if
createdonpermitnumbermodifiedoncreatedonpermitnumbermodifiedoncreatedonmodifiedon| ADMINISTRATION FEE |
| 135 |
| 2018-08-27T07:45:26.000 |
| 2021-10-03T00:05:17.000 |
| M012021132B37 | ADMINISTRATION FEE | 135 | 2021-05-12T15:28:21.000 | 2021-06-02T07:42:18.000 |
| M012018138B30 | ADMINISTRATION FEE | 135 | 2018-05-18T12:39:53.000 | 2021-06-09T00:05:14.000 |
| B022021351B18 | ADMINISTRATION FEE | 100 | 2021-12-17T14:51:09.000 | 2022-01-16T00:05:10.000 |
| M012017223C54 | ADMINISTRATION FEE | 135 | 2017-08-11T15:12:31.000 | 2021-10-03T00:05:17.000 |
| Q022022266A37 | ADMINISTRATION FEE | 50 | 2022-09-23T10:33:07.000 | 2022-12-28T00:05:08.000 |
| B012017342B48 | ADMINISTRATION FEE | 135 | 2017-12-08T19:57:14.000 | 2018-01-12T00:07:19.000 |
modifiedon |
| datetime |
| — |
| 0% |
2013-12-14T21:03:08.0002018-06-22T20:16:47.0002018-05-20T00:05:42.000 |