Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

City Council Constituent Services (2015 to 2025)

b9km-gdpyCity Government11 columns
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.
View on NYC Open Data↗

Quality

A94.8 / 100

From a 500-row sample across 11 columns.

completeness91/ 25% weight
consistency86/ 20% weight
accuracy100/ 20% weight
timeliness98/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Mayor’s Office of Operations: Demographic Survey0.33
  • DSNY Monthly Tonnage Data0.31
    joins onborough
  • Civil Service List (Terminated)0.31
  • Medicaid Offices0.31
    joins oncitycommunity_board
  • NYC Permitted Event Information0.30
    joins oncommunity_board
  • 2020 Neighborhood Tabulation Areas (NTAs)0.30

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

unique_keyaccountopendatecomplaint_typedescriptorzipboroughcitycouncil_distcommunity_boardclosedate
NYCC34519748NYCC342025-01-09T00:00:00.000Governmental OperationsVoting Information11385BrooklynRidgewoodNYCC3405 Brooklyn—
NYCC34519746NYCC342025-01-09T00:00:00.000

Columns

11 queryable · 11 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
unique_keytextA 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).0%NYCC04504298NYCC26536444NYCC22504630
accounttextThe number of the Council District that received the visit, call or email.0%NYCC50NYCC48NYCC06
opendatedatetimeThe date that District staff started work on the casework.0%2019-12-23T00:00:00.0002016-12-29T00:00:00.0002015-12-30T00:00:00.000
complaint_typetextA categorization of the complaint lodged.2%

Query this from your own app

GET /api/datasets/b9km-gdpy
GET /api/datasets/b9km-gdpy/quality
GET /api/datasets/b9km-gdpy/related
GET /api/columns?dataset=b9km-gdpy
Evictions
0.30
joins oncommunity_boardborough
  • Self Hauler Registrants0.29
    joins oncitycommunity_board
    • Utilities
    Con Edison
    11237
    Brooklyn
    Brooklyn
    NYCC34
    04 Brooklyn
    2025-01-09T00:00:00.000
    NYCC34519742NYCC342025-01-08T00:00:00.000Housing and BuildingsHeat/Hot Water11249BrooklynBrooklynNYCC3301 Brooklyn2025-01-08T00:00:00.000
    NYCC34519741NYCC342025-01-06T00:00:00.000Housing and BuildingsHeat/Hot Water11211BrooklynBrooklynNYCC3401 Brooklyn2025-01-08T00:00:00.000
    NYCC34519743NYCC342024-12-23T00:00:00.000Housing and BuildingsMaintenance11211BrooklynBrooklynNYCC3401 Brooklyn2025-01-09T00:00:00.000
    NYCC34519744NYCC342024-12-11T00:00:00.000General WelfareSSI and Social Security11211BrooklynBrooklynNYCC3401 Brooklyn2025-01-09T00:00:00.000
    NYCC34519745NYCC342024-09-05T00:00:00.000FinanceTax Preparation Assi11385BrooklynRidgewoodNYCC3405 Brooklyn2025-01-09T00:00:00.000
    NYCC31505454NYCC312024-06-04T00:00:00.000SanitationOVERGROWN GRASS——Rockaway———
    NYCC31505451NYCC312024-05-30T00:00:00.000——11413QueensLaureltonNYCC3113 Queens—
    NYCC31505452NYCC312024-05-30T00:00:00.000——11413QueensLaureltonNYCC3113 Queens—
    Housing and BuildingsTransportationFinance
    descriptortextA more specific categorization of the complaint lodged.6%Seeking an affordable ho…Tax Preparation AssiU.S. Citizenship
    ziptextThe zip code that the constituent reports during the visit, call or email.15%100241031410306
    boroughcategoricalThe borough that the constituent reports during the visit, call or email.18%BrooklynManhattanQueensof 5
    citytextThe city that the constituent reports during the visit, call or email.10%BrooklynNew YorkStaten Island
    council_disttextThe number of the Council District that received the visit, call or email.18%NYCC50NYCC06NYCC48
    community_boardtextThe community board that the constituent lives in, inferred from the zip code the constituent reports during the visit, call or email.21%07 Manhattan02 Staten Island15 Brooklyn
    closedatedatetimeThe date that District staff close out the casework.4%2019-07-16T00:00:00.0002022-05-05T00:00:00.0002022-06-16T00:00:00.000