| name | NYC Council Constituent Services |
|---|---|
| description | The dataset comes from CouncilStat, which is used by many NYC Council district offices to enter and track constituent cases that can range from issues around affordable housing, to potholes and pedestrian safety. This dataset aggregates the information that individual staff have input. However, district staffs handle a wide range of complex issues. Each offices uses the program differently, and thus records cases, differently and so comparisons between accounts may be difficult. Not all offices use the program. For more info - http://labs.council.nyc/districts/data/ |
| attribution | New York City Council (NYCC) |
| id | b9km-gdpy |
| assetType | dataset |
| category | City Government |
| createdAt | 2016-02-24 21:17:54 |
| provenance | official |
| rowsUpdatedAt | 2025-06-03 18:11:57 |
| Name | Data Type | Description | Field Name |
|---|---|---|---|
| UNIQUE_KEY | text | Unique case number of the constituent casework. | unique_key |
| ACCOUNT | text | NYC Council District that created the casework, this may or not be the district that the constituent lives in. This is generated automatically. | account |
| OPENDATE | calendar_date | Date the casework is created by staff. | opendate |
| COMPLAINT_TYPE | text | Broader category designated by staff for the constituent casework. complaint_type corresponds to NYC Council Legislative Committees. | complaint_type |
| DESCRIPTOR | text | descriptor is the more specific category designated by staff for the constituent casework. | descriptor |
| ZIP | text | Zip code of the constituent. | zip |
| BOROUGH | text | Borough of the constituent. | borough |
| CITY | text | City of the constituent. | city |
| COUNCIL_DIST | text | Council District of the constituent. | council_dist |
| COMMUNITY_BOARD | text | Community Board of the constituent. | community_board |
| CLOSEDATE | calendar_date | Close Date is the date the casework was closed. A casework could be closed because the issue is resolved or because no further action could be taken. | closedate |
| Normalized Fields | COUNCIL_DIST, COMMUNITY_BOARD |
|---|---|
| Next Update Scheduled |
| Source Data Last Updated | 2025-06-03 18:11:57 |
|---|---|
| Transformed Data Last Updated | 12/10/2025 07:26 |
| Columns Added | Calculating... |
| Added Column Names | Calculating... |
Loading data...
Loading data...