From a 500-row sample across 13 columns.
council_membercommunity_boardcommunity_boardcitycommunity_boardHas cd codes (`community_board`) — joinable, but needs boundary shapes to draw.
| contact_id | city | state | postal_code | council_member | community_board | case_id | case_type | case_subject | case_start_date | case_status | case_end_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 54.0 | New York | NY | 10027.0 | Mark Levine [7] | 10.0 | 3.0 | Housing | Rent Arrears | 2017-06-26T00:00:00.000 | Pending | — |
| 61.0 | New York |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
contact_id | integer | — | 0% | 102.0103.0561.0 |
city | text | — | 18% | NYNew YorkBX |
state | categorical | — | 2% | NYCTNJof 3 |
postal_code | integer | — | 19% | 10027.010025.010024.0 |
council_member | categorical | — |
GET /api/datasets/39qw-754y GET /api/datasets/39qw-754y/quality GET /api/datasets/39qw-754y/related GET /api/columns?dataset=39qw-754y
citystate| NY |
| 10031.0 |
| — |
| 9.0 |
| 4.0 |
| Housing |
| Housing Information |
| 2017-06-27T00:00:00.000 |
| Closed |
| 2017-06-27T00:00:00.000 |
| 99.0 | New York | NY | 10027.0 | Mark Levine [7] | 9.0 | 5.0 | NYCHA | Repairs | 2017-07-03T00:00:00.000 | Pending | — |
| 100.0 | New York | NY | 10023.0 | — | 7.0 | 6.0 | NYCHA | Quality of Life | 2017-07-03T00:00:00.000 | Pending | — |
| 108.0 | New York | NY | 10027.0 | — | 9.0 | 7.0 | Housing | Security Deposit | 2017-07-05T00:00:00.000 | Pending | — |
| 45.0 | — | NY | — | — | 7.0 | 9.0 | Employment | Employment | 2017-07-05T00:00:00.000 | Pending | — |
| 109.0 | New york | NY | 10027.0 | — | 9.0 | 10.0 | Employment | employment | 2017-07-05T00:00:00.000 | Pending | — |
| 110.0 | New York | NY | 10031.0 | — | 9.0 | 11.0 | Social Services | Medicare | 2017-07-06T00:00:00.000 | Closed | 2017-07-06T00:00:00.000 |
| 112.0 | New York | NY | 10025.0 | Helen Rosenthal [6] | 7.0 | 12.0 | Immigration | Immigration | 2017-07-06T00:00:00.000 | Closed | 2017-07-06T00:00:00.000 |
| 115.0 | New York | NY | 10025.0 | Helen Rosenthal [6] | 7.0 | 13.0 | NYCHA | Eviction | 2017-07-06T00:00:00.000 | Pending | — |
| 28% |
Bill Perkins [9]Mark Levine [7]Helen Rosenthal [6]of 12 |
community_board | categorical | — | 25% | 9.010.07.0of 13 |
case_id | integer | — | 0% | 568.0599.0789.0 |
case_type | text | — | 0% | HousingNYCHAOther |
sub_types | text | — | 28% | NoneRepairsEviction |
case_subject | text | — | 0% | HousingRepairsNYCHA:Repairs |
case_start_date | datetime | — | 0% | 2017-05-24T00:00:00.0002017-01-20T00:00:00.0002017-08-16T00:00:00.000 |
case_end_date | datetime | — | 68% | 2017-12-18T00:00:00.0002017-12-16T00:00:00.0002017-12-19T00:00:00.000 |
case_status | categorical | — | 6% | ClosedPendingUrgentof 3 |