Data Sources
Where the information on this site comes from and how often it is updated
Civic Accountability Score — Methodology
Each council member displayed on the Representatives page receives a composite score from 0–100 and an A–F letter grade. The score is built from six dimensions across voting record, campaign finance, and accountability data. Two dimensions — Ethics and Conduct — operate as penalty-only: a clean record is the expected baseline and contributes nothing to the score. Only violations subtract from it.
Grading scale
Score dimensions
Share of the full Council's stated meetings in the last 12 months the member attended. Excused absences (medical, parental, bereavement, jury duty, or another Council proceeding at the same time) are left out rather than counted for or against them.
Source: NYC Council Legistar roll calls
Share of the committee hearings in the last 12 months the member was on the roll call for and attended. Excused absences are left out, as for full Council meetings.
Source: NYC Council Legistar roll calls
Share of the bills a member primary-sponsored (introduced) that were enacted into law, measured against the 16.9% citywide historical rate. Co-sponsorships are excluded so the score reflects the member's own legislative record.
Source: NYC Legistar sponsor and matter records
Bills introduced as primary sponsor during the current term (2022–), normalized by years in role. Full credit at 3 introduced bills per year.
Source: NYC Legistar sponsor and matter records
Penalty for NYC Conflicts of Interest Board enforcement actions. A clean record contributes nothing — it is the expected baseline. Each violation deducts points based on severity: minor fines −40, mid-range fines −60, major fines −80.
Source: NYC COIB Enforcement Fines (Socrata API) + manually curated descriptions
Penalty for documented misconduct incidents including arrests, criminal charges, ethics investigations, and formal findings. A clean record contributes nothing. Any 3 incidents — regardless of outcome — floors the conduct score at 0.
Source: Wikipedia articles reviewed by Claude (Anthropic), manually curated
Penalty for documented incidents of racist, antisemitic, Islamophobic, xenophobic, homophobic, or transphobic statements, policy actions with discriminatory intent, hate group affiliations, or formal discrimination complaints. A source URL is required for every incident. A clean record contributes nothing.
Source: Wikipedia articles and press coverage reviewed by Claude (Anthropic), manually curated
Composite formula
The base score is a weighted average of the four non-penalty dimensions, normalized so a perfect record on those dimensions yields 100. Ethics and Conduct operate as penalty-only deductions applied after the base is computed:
activity = min(bills_introduced / (years_in_role × 3), 1) × 100effectiveness = min(100, (enactment_rate / 0.169) × 75)base = (participation×0.10 + effectiveness×0.10 + activity×0.05 + committee×0.10) ÷ 0.35ethics_penalty = (100 − ethics_score) × 0.20conduct_penalty = (100 − conduct_score) × 0.20hate_bias_penalty = (100 − hate_bias_score) × 0.20score = max(0, base − ethics_penalty − conduct_penalty − hate_bias_penalty)years_in_role is measured from the member's term start date. Members who joined mid-term via special election or appointment use their actual start date rather than the 2022 class baseline.
Conduct incident sourcing
Conduct incidents were seeded by fetching the Wikipedia article for each of the 51 council members via the Wikipedia REST API and passing the full article text to Claude (Anthropic) with a structured prompt. Claude was instructed to extract only incidents involving arrests, criminal charges, convictions, ethics violations, formal disciplinary action, or credible allegations of corruption — not policy disagreements, controversial votes, or pre-office activism.
All extracted incidents were manually reviewed before being committed to the codebase. Incidents that did not meet the threshold (political arrests with no charges filed, questionable votes without a formal finding) were removed. The final dataset reflects editorial judgment, not automated output.
Conduct penalty scale
Any 3 incidents, regardless of outcome, floor the conduct score at 0 (minimum penalty per incident = 34). A single conviction also floors the score at 0.
Limitations
- Voting and sponsorship data covers legislation tracked in NYC Legistar. Committee attendance, constituent services, and district engagement are not measured.
- Legislative Activity counts only bills where the member is the primary introducing sponsor. Co-sponsorships count toward Legislative Effectiveness but not Activity.
- Legislative Effectiveness reflects pass rate across all sponsored bills. New members or those who recently joined mid-term will have fewer sponsored bills and shorter track records, which may skew this score.
- Campaign finance data may not be available for all members — appointed members who have never run in a reported election cycle receive a neutral finance score (50/100).
- COIB violation descriptions are sourced from press releases and news reporting. Cases where no public description exists show the case number and fine only.
- Conduct incidents are sourced from Wikipedia, supplemented by manual research into press coverage. Members with recent incidents not yet reflected in these sources may not be captured.
- The score is a tool for civic awareness, not a comprehensive audit. It should be read alongside the underlying source data and your own judgment.
Data Sources
- Daily early morning; changed bills hourlyNYC LegistarData: City Council legislation, votes, sponsors and bill statusThe NYC Council's Legistar API is queried every morning for new legislation and votes, and bills that changed are re-checked every hour. The data is stored in our database and shown on bill pages, Track Legislation, Voting History and the council member scorecards.Legistar is the official legislative system of the NYC Council. Bill text, vote records and sponsors come directly from it.
- Daily early morningNY State Senate Open LegislationData: State legislation and votes from the NY Senate and AssemblyThe New York State Senate's public Open Legislation API is queried every morning for bills that changed, including their votes. State bills appear in Track Legislation, bill pages, and state legislators' voting records.Open Legislation is published by the New York State Senate. OpenBorough is not affiliated with it.
- Daily, after hearings are publishedNYC Council hearing videoData: Public recordings of Council hearingsRecordings published by the NYC Council are used to link a quote to the second it was said and to capture a still frame for "Said at City Hall". Quotes are matched against the official hearing transcripts.Video and captions belong to the NYC Council. Automatic captions may contain errors.
- Refreshed every hourNYC Open Data — DOB Approved PermitsData: Approved construction permits in your council districtThe Department of Buildings approved-permits dataset is queried for your council district. Work types such as New Building, Demolition, Renovation, Solar and Structural are shown on the district pages.Permit data reflects what DOB has approved and may not yet reflect work visible on the ground.
- Refreshed every hourNYC Open Data — DCWP Business LicensesData: New business licenses in your council districtThe Department of Consumer and Worker Protection licensing dataset is queried for active licenses issued in your council district in the past six months.Not every business needs a DCWP license, so not every new business appears.
- Refreshed every hourNYC Open Data — HPD Housing ViolationsData: Housing maintenance violations by district and buildingThe Department of Housing Preservation and Development violations dataset powers the Housing pages: open violations by class for each district, and an address lookup for a single building.Violations are reported by HPD. A violation may be resolved before the dataset reflects it.
- Refreshed every hourNYC Open Data — 311 Service RequestsData: 311 complaints by districtThe 311 service requests dataset is queried for your district to show the most common complaint types and recent requests on the Quality of Life pages.311 data reflects what residents report, not every problem in a neighborhood.
- Updated when the Council adopts each budgetNYC Open Data — Council Capital BudgetData: Capital funding allocated by Council members to their districtsThe NYC Council's capital budget dataset (Resolution A allocations) is queried for each district and fiscal year on the Budget pages.Dollar amounts are as published by the Council. Projects are funded over several years.
- Cached dailyNYC Campaign Finance Board (CFB)Data: Campaign contribution records for all 51 NYC Council membersThe CFB contribution dataset (Socrata API, dataset rjkp-yttg) is queried by council member name across the 2021, 2023, and 2025 election cycles. Contributions are matched by last name and first-name prefix, with diacritic normalization to handle accented characters. The share of contributions from individual donors vs. corporations and PACs is computed and used in the Campaign Finance dimension of the Civic Accountability Score.CFB data covers contributions reported to the NYC Campaign Finance Board by participating candidates. Members appointed without running in a reported cycle have no CFB data.
- Cached dailyNYC Conflicts of Interest Board (COIB)Data: Ethics enforcement fines issued to NYC Council members by the COIBThe COIB enforcement fines dataset (Socrata API, dataset p39r-nm7f) is queried for all cases where the agency is the City Council and the case name matches the council member's last name. Fines and penalties are tallied and used in the Ethics Record dimension of the Civic Accountability Score.The COIB dataset contains no description field — violation descriptions shown on the scorecard are sourced from COIB press releases and news reporting, and manually curated in the codebase.
- Checked regularly; updated after elections and appointmentsOfficial legislature websitesData: Profiles and contact details for your representativesCouncil member contact details come from council.nyc.gov, state senators from nysenate.gov, Assembly members from nyassembly.gov, and members of Congress from congress.gov. Address lookup uses the official district boundary maps.Each official site is maintained by its own legislature. OpenBorough is not affiliated with any of them.
- Refreshed every 30 minutesLocal News RSS FeedsData: NYC local news headlines, your borough firstRSS feeds from Gothamist, THE CITY, and City Limits are fetched and shown on the homepage, sorted by publication date.Articles link to their original source. OpenBorough does not produce or edit any news content.
- Reviewed as neededWikipediaData: Background on officials, and photos of citywide officialsWikipedia articles are used for background on elected officials and as a starting point for the conduct records described in the scorecard methodology above. Every conduct incident is reviewed by hand and requires a source.Wikipedia content is licensed under CC BY-SA. Photos keep their original credits.
- Daily, after legislation syncsClaude (Anthropic)Data: AI-written summaries, the daily briefing, bill stories, hearing quotes and translationsClaude writes plain-language summaries of legislation, the daily briefing, the story behind each bill from its official records, picks notable quotes from hearing transcripts, and translates content into Spanish, Haitian Creole and Bengali.AI-generated content is labeled as such. It is a convenience, not an official interpretation of any legislation.
- DailyGoogle GeminiData: Illustrations for bills and the daily briefingGemini draws an illustration for the daily briefing's headline and for every new bill, each bill in its topic's own style, showing what the bill does. Every illustration is credited as AI-generated.Illustrations are decorative. They don't depict real people or events.
- DailyOpenverseData: Backup photos for the daily briefing and social cardsWhen the daily briefing's headline can't be illustrated, its photo comes from Openverse, which indexes openly licensed images, as do the photos on our social media cards. Each photo is credited to its author and license.Bills in legislation lists show an AI illustration or their topic, never a stock photo.
- Manually updatedManually curatedData: Community resources and city services directoryThe Local Resources and City Services pages are hand-curated lists of organizations, programs and services for New Yorkers. Information comes from each organization's own website.If you notice outdated or incorrect information, please email us.
Notice incorrect or outdated information?
Email us about an issue