City Council Constituent Services (2015 to 2025)
The data contains issues raised by a constituent to their District office. Each case can raise multiple issues - each row represents an issue, rather than a case. ""Casework""/""case"" is a single interaction with a constituent, while an ""issue"" represents a specific concern raised by a constituent; each casework can contain multiple issues. To find who represents you and the location of your District office, the ""Who Represents Me"" Tool (https://www.mygovnyc.org/) from the CUNY Graduate Center and the League of Women Voters can provide you the City Hall office address, District office address, email address, and phone number of the representatives for any given address.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- 28 days
- Publisher last updated the data
- Oct 8, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 8, 2026, 2:07 PM
- Rows in our copy
- 341,299
- Rows at the source
- 341,299
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
1 of 11 columns carry a concept; 11 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
council_dist | Council District | The number of the Council District that received the visit, call or email. | Not bound | Text | council_dist | text | — | |
complaint_type | Complaint Type | A categorization of the complaint lodged. | Not bound | Text | complaint_type | text | — | |
descriptor | Descriptor | A more specific categorization of the complaint lodged. | Not bound | Text | descriptor | text | — | |
unique_key | Unique Key | A unique ID for the visit, call or email raising the issue. The ID is comprised of the year, district, and a sequentially generated number (by year). | Not bound | Text | unique_key | text | — | |
community_board | Community Board | The community board that the constituent lives in, inferred from the zip code the constituent reports during the visit, call or email. | Not bound | Text | community_board | text | — | |
closedate | Close Date | The date that District staff close out the casework. | Not bound | Calendar date | closedate | timestamp | — | |
zip | Zip | The zip code that the constituent reports during the visit, call or email. |
Download
This file was produced on Oct 8, 2026, 10:02 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/b9km-gdpy
- Version
- Content hash:
e6ed1e609851c6690643f0b92bc190bc9c9b4d2636a0fe730b303f565e80e49a - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 8, 2026, 2:07 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 8, 2026, 9:25 PM | full_replace | success | 341,299 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 10, 2026, 10:19 PM | full_replace | success | 341,299 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Sep 9, 2026, 9:41 PM | full_replace | success | 341,300 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 25, 2026, 1:15 PM | full_replace | success | 341,299 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.70 |