From a 500-row sample across 6 columns.
fdny_violationsdob_violationshpd_violations| report_date | building_id | dob_violations | hpd_violations | fdny_violations | total_open_violations |
|---|---|---|---|---|---|
| 2018-12-31T00:00:00.000 | TQ01 | 0 | 2 | 3 | 5 |
| 2018-12-31T00:00:00.000 | TQ02 | 4 | 2 | 0 | 6 |
| 2018-12-31T00:00:00.000 | TQ03 | 1 | 2 | 1 | 4 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
report_date | datetime | Date on which the reporting period ended. Each report covers a calendar year quarter. | 0% | 2018-09-30T00:00:00.0002018-06-30T00:00:00.0002018-12-31T00:00:00.000of 8 |
building_id | text | Unique ID assigned to each building to de-identify addresses for the purposes of this report. | 0% | TQ21TQ93TQ31 |
dob_violations | integer | Open violations at the close of the reporting period issued by the Department of Buildings. Such violations are notice that the property is not in compliance with a provision of the applicable law and includes an order from the Commissioner to correct the violating condition. | 0% | 032 |
hpd_violations | integer | Open violations at the close of the reporting period issued by the Department of Housing Preservation and Development. |
GET /api/datasets/96te-xmyw GET /api/datasets/96te-xmyw/quality GET /api/datasets/96te-xmyw/related GET /api/columns?dataset=96te-xmyw
| 2018-12-31T00:00:00.000 | TQ04 | 0 | 3 | 4 | 7 |
| 2018-12-31T00:00:00.000 | TQ05 | 13 | 46 | 5 | 64 |
| 2018-12-31T00:00:00.000 | TQ06 | 0 | 0 | 6 | 6 |
| 2018-12-31T00:00:00.000 | TQ07 | 0 | 1 | 6 | 7 |
| 2018-12-31T00:00:00.000 | TQ08 | 34 | 0 | 6 | 40 |
| 2018-12-31T00:00:00.000 | TQ09 | 7 | 3 | 0 | 10 |
| 2018-12-31T00:00:00.000 | TQ10 | 8 | 14 | 2 | 24 |
| 0% |
023 |
fdny_violations | categorical | Open violations at the close of the reporting period issued by the Fire Department. Such violations give notification of a violating condition and a direct to correct the condition. | 0% | 012of 11 |
total_open_violations | integer | Total open violations at the close of the reporting period. | 0% | 1003 |