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 Committee Membership (1999 to 2025)

aabe-yfm9City Government11 columns
This dataset contains information on the appointments of New York City Council Members from 1999 through 2025. Information before 1999 is not contained in Legistar, the Council's tracking system. More information on Committees can be found at: https://council.nyc.gov/committees/ To access the Legislative API, you can request a key here: https://council.nyc.gov/legislation/api/
View on NYC Open Data↗

Quality

B88.3 / 100

From a 500-row sample across 11 columns.

completeness100/ 25% weight
consistency73/ 20% weight
accuracy93/ 20% weight
timeliness75/ 15% weight
usability95/ 20% weight

Related datasets

  • City Council Meetings (1999 to 2024)0.45
    joins oncommitteemodified_date
  • City Council Legislation: Bills and Local Laws0.32
    joins oncommitteemodified_date
  • Campaign Expenditures0.29
    joins oncommittee
  • Campaign Contributions0.28
    joins oncommittee
  • Minority and Women-Owned Business Enterprise Statistics0.28
  • Doing Business Contributions Summary

Sample rows

member_idfirst_namelast_namefull_namecommitteeappointment_typestart_dateend_datemodified_datecommittee_idid
7739AdrienneAdamsAdrienne E. AdamsCity CouncilPRIMARY SPEAKER2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:15:12.00015210
7742Diana I.Ayala

Columns

11 queryable · 11 profiled

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

FieldTypeDescriptionNullValues
member_idtextUnique ID for the Council Member0%52595273386
first_nametextCouncil Member first name.0%Gale A.JamesBill
last_nametextCouncil Member last name.0%RiveraWilliamsBrewer
full_nametextCouncil Member full name.0%Gale A. BrewerJames F. GennaroKaren Koslowitz
committee

Query this from your own app

GET /api/datasets/aabe-yfm9
GET /api/datasets/aabe-yfm9/quality
GET /api/datasets/aabe-yfm9/related
GET /api/columns?dataset=aabe-yfm9
0.28
joins oncommittee
  • NYC Historical Vital Records: Index to Digitized Death Certificates0.28
    joins onfirst_namelast_name
  • Tax Lien Sale Lists0.27
  • Diana I. Ayala
    City Council
    PRIMARY COUNCIL MEMBERS
    2024-01-01T00:00:00.000
    2025-12-31T00:00:00.000
    2023-11-08T18:16:44.000
    1
    5211
    7804ShaunAbreuShaun AbreuCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:21:26.00015212
    7825AlexaAvilésAlexa AvilésCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:23:06.00015214
    7864ChrisBanksChris BanksCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:23:38.00015215
    7802Erik D.BottcherErik D. BottcherCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:25:36.00015217
    7748Justin L.BrannanJustin L. BrannanCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:26:05.00015218
    5259Gale A.BrewerGale A. BrewerCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:26:30.00015219
    7796Selvena N.Brooks-PowersSelvena N. Brooks-PowersCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:27:09.00015220
    7813Tiffany L.CabánTiffany L. CabánCity CouncilPRIMARY COUNCIL MEMBERS2024-01-01T00:00:00.0002025-12-31T00:00:00.0002023-11-08T18:27:53.00015221
    text
    Name of City Council Committee.
    0%
    City CouncilCommittee on Land UseCommittee on Finance
    appointment_typecategoricalCommittee Role.0%PRIMARY COUNCIL MEMBERSCHAIRPRIMARY SPEAKERof 8
    start_datedatetimeDate the Council Member started membership on the Committee.0%2018-01-11T00:00:00.0001990-01-01T00:00:00.0002022-01-20T00:00:00.000
    end_datedatetimeDate the Council Member ended or is projected to end membership on Committee.0%2023-12-31T00:00:00.0002025-12-31T00:00:00.0002021-12-31T00:00:00.000
    modified_datedatetimeDate and time record was last updated.0%2015-08-25T15:56:55.0002022-01-20T18:47:20.0002022-04-05T16:37:45.000
    committee_idtextUnique ID for the Committee.0%11711
    idtextUnique ID for the Committee appointment.0%24735422585