From a 500-row sample across 7 columns.
community_districtzipcity+5zipcitycouncil_district+2zipcitycouncil_district+3industryHas borough codes (`borough_name`) — joinable, but needs boundary shapes to draw.
| intake_date | source | language | outcome | industry | request_type | topic |
|---|---|---|---|---|---|---|
| 2022-07-11T00:00:00.000 | Referral | English | Assigned for Review | — | — | — |
| 2014-12-16T00:00:00.000 | Call from 311 | Spanish | Assigned for Review | Home Health Care Services | — | — |
| 2021-03-16T00:00:00.000 | Call from Hotline | English |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
intake_date | datetime | Date inquiry was entered into the system | 0% | 2014-10-07T00:00:00.0002014-10-06T00:00:00.0002020-07-09T00:00:00.000 |
source | categorical | Identifies how inquiry was received | 1% | EmailCall from 311Direct Callof 14 |
language | categorical | Preferred language of the customer | 0% | EnglishSpanishMandarinof 19 |
request_type | categorical | Type of the inquiry received | 30% |
GET /api/datasets/2z24-2htf GET /api/datasets/2z24-2htf/quality GET /api/datasets/2z24-2htf/related GET /api/columns?dataset=2z24-2htf
citycouncil_districtstatelanguagezipcitystatecouncil_district| Information Provided |
| — |
| Information Request |
| Paid Safe and Sick Leave |
| 2020-07-07T00:00:00.000 | Call from Hotline | English | Information Provided | — | Information Request | Wage & Hour |
| 2016-12-09T00:00:00.000 | Call from 311 | English | Information Provided | — | Information Request | Paid Safe and Sick Leave |
| 2022-07-28T00:00:00.000 | English | Information Provided | — | Information Request | Discrimination/Harassment |
| 2022-03-30T00:00:00.000 | English | Information Provided | — | Information Request | Paid Safe and Sick Leave |
| 2017-06-02T00:00:00.000 | Spanish | Information Provided | — | Information Request | Paid Safe and Sick Leave |
| 2024-02-19T00:00:00.000 | Website | English | Information Provided | — | — | — |
| 2017-04-07T00:00:00.000 | Call from 311 | Spanish | Information Provided | — | Information Request | Paid Safe and Sick Leave |
Information RequestOutreach RequestMultiple Request Types (…topic | text | Law or rule that is the subject of the inquiry. | 30% | Paid Safe and Sick LeaveOtherFreelance Isn't Free |
outcome | categorical | Result of the inquiry | 0% | Information ProvidedAssigned for ReviewMultiple Outcomes (2)of 7 |
industry | text | Where available, the general industry name of the workplace that is the subject of inquiry. | 83% | Limited-Service Restaura…Couriers and Express Del…Retail Trade |
city | text | Where available, the city where the workplace that is subject to inquiry was based. | 100% | — |
state | text | Where available, the state where the workplace that is subject to inquiry was based. | 100% | — |
zip | text | Where available, the ZIP Code where the workplace that is subject to inquiry was based. | 100% | — |
borough_name | text | Where available, the Borough where the workplace that is subject to inquiry was based. | 100% | — |
community_district | numeric | Where available, the two-digit Community District where the workplace that is subject to inquiry was based. | 100% | — |
council_district | numeric | Where available, the City Council district where the workplace that is subject to inquiry was based. | 100% | — |