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

Campaign Intermediaries

tcwb-nry3City Government24 columns
Intermediary contributions to Election campaigns.
View on NYC Open Data↗

Quality

B84.8 / 100

From a 500-row sample across 21 columns.

completeness94/ 25% weight
consistency86/ 20% weight
accuracy76/ 20% weight
timeliness74/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Off-Year and Special Elections Intermediary0.63
    joins onoccupationstateofficecd+21
  • Campaign Contributions0.51
    joins onoccupationstateofficecd+19
  • Campaign Expenditures0.48
    joins onstateofficecdcandmi+14
  • Campaign Financial Analysis0.45

Geography

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

Sample rows

electionofficecdcandidcanclasscandlastcandfirstcandmicommitteenamec_codeboroughcdcity
202541707PGibsonVanessaLNAnzalone, Anne MarieINDQLong Island City
202512857

Columns

24 queryable · 24 profiled

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

FieldTypeDescriptionNullValues
electioncategoricalElection Cycle0%200120132025of 9
officecdcategoricalOffice Sought: [1=Mayor; 2=Public Advocate; 3=Comptroller; 4=Borough President; 5=City Council; 6=Undeclared]0%154of 12
candidtextCandidate ID, assigned by the CFB0%148A9AY
canclasscategoricalCampaign Finance Program Classification: [Participant, Non-Participant, Limited Participant, Undetermined]0%PNPUN

Query this from your own app

GET /api/datasets/tcwb-nry3
GET /api/datasets/tcwb-nry3/quality
GET /api/datasets/tcwb-nry3/related
GET /api/columns?dataset=tcwb-nry3
Doing Business Contributions Summary
0.43
joins onoccupationstateofficecd+21
  • Off-Year and Special Elections Campaign Expenditure0.39
    joins onstateofficecdcandmi+14
  • Off-Year and Special Elections Contribution0.36
    joins onoccupationstateofficecd+17
  • Off-Year and Special Elections Financial Analysis0.35
    • P
    Myrie
    Zellnor
    —
    H
    Baisden, Trevor
    IND
    M
    New York
    202512884PRamosJessica—HAlarcon, TonyINDQEast Elmhurst
    202511545PAdamsEricLNPerry, Theo HINDMNew York
    202512857PMyrieZellnor—HAnzalone, JosephINDKBrooklyn
    202512884PRamosJessica—HAttia, MohamedINDKBrooklyn
    202511545PAdamsEricLNPerry, Theo HINDMNew York
    202512899PMamdaniZohranKHAhmad, TaibaINDQWhitestone
    202512993PCuomoAndrewMHCuomo, BellaINDMNew York
    202512857PMyrieZellnor—HBarsky, NeilINDMManhattan

    Showing 12 of 21 columns. All of them are listed below.

    of 3
    candlasttextCandidate's Last Name0%StringerHevesiFerrer
    candfirsttextCandidate's First Name0%ScottAlanFernando
    candmitextCandidate's Middle Initial42%MCG
    committeecategoricalCommittee ID, assigned by the CFB0%HNJof 13
    nametextIntermediary Name0%Goldstein, ArthurConstantinople, AnthonyHalperin, Donald
    c_codecategoricalIntermediary Type0%INDPCOMPFAMof 14
    strnotextIntermediary's Street Number - If C_CODE = IND, CAN, FAM or SPO, Then field = Blank100%—
    strnametextIntermediary's Street Name - If C_CODE = IND, CAN, FAM or SPO, Then field = Blank100%—
    apartmenttextIntermediary's Apartment Number - If C_CODE = IND, CAN, FAM or SPO, Then field = Blank100%—
    boroughcdcategoricalIntermediary's Borough Code: [K=Brooklyn; M=Manhattan; Q=Queens; S=Staten Island; X=Bronx; Z=Outside New York City]2%MZKof 6
    citytextIntermediary's City, Schedule N - Vendor's City3%New YorkBrooklynNEW YORK
    statetextIntermediary's State, Schedule N - Vendor's State3%NYNJCT
    ziptextIntermediary's Zip Code3%100211002410023
    occupationtextIntermediary's Occupation9%AttorneyATTORNEYPresident
    empnametextIntermediary's Employer11%Self-EmployedSelf EmployedSelf
    empstrnotextIntermediary's Employer's Street Number22%1233200
    empstrnametextIntermediary's Employer's Street Name22%BroadwayPark AvenueMadison Avenue
    empcitytextIntermediary's Employer's City15%New YorkNEW YORKBrooklyn
    empstatetextIntermediary's Employer's State15%NYNJDC
    amntintegerTotal Amount Intermediated for Candidate and Election Cycle0%1000500100