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

Off-Year and Special Elections Intermediary

yqhh-93zqCity Government24 columns
This dataset contains each intermediaries contribution to a campaign during an off-year or special election.
View on NYC Open Data↗

Quality

C78.9 / 100

From a 286-row sample across 21 columns.

completeness90/ 25% weight
consistency90/ 20% weight
accuracy95/ 20% weight
timeliness8/ 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 Contribution0.68
    joins onstrnoempstateempname+17
  • Off-Year and Special Elections Campaign Expenditure0.68
    joins onstrnoapartmentcandlast+14
  • Campaign Intermediaries0.63
    joins onstrnoempstateempname+21
  • Off-Year and Special Elections Financial Analysis0.60

Geography

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

Sample rows

electionofficecdcandidcanclasscandlastcandfirstcandmicommitteenamec_codeboroughcdcity
2016A51674PMolinaMarlonMHAbreu, CandyINDXBronx
2009B41160P

Columns

24 queryable · 24 profiled

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

FieldTypeDescriptionNullValues
electiontextElection Cycle0%2003A2019A2009B
officecdcategoricalOffice Sought0%5224of 6
candidtextCandidate ID, assigned by the CFB0%WC1160BW
canclasscategoricalCampaign Finance Program Classification0%PNPof 2
candlasttextCandidate's Last Name

Query this from your own app

GET /api/datasets/yqhh-93zq
GET /api/datasets/yqhh-93zq/quality
GET /api/datasets/yqhh-93zq/related
GET /api/columns?dataset=yqhh-93zq
Off-Year and Special Elections Public Matching Fund Payments0.53
joins onelectionofficecdcandid+1
  • Campaign Financial Analysis0.38
  • Campaign Expenditures0.38
    joins onstrnoapartmentcandlast+14
  • Doing Business Contributions Summary0.36
    joins onstrnoempstateempname+21
    • Diaz Jr.
    Ruben
    —
    H
    Acosta, Adriano
    IND
    X
    Bronx
    2013A51615PAdam-OvideMarieMHAdam, Martin WFAMQRosedale
    2013A51615PAdam-OvideMarieMHAdam, Mikely PFAMKBrooklyn
    2019A222196PSmallsDawnLHAime, Alex-HandrahINDKBrooklyn
    2020B552313PAbdinMisba—HAlam, Mohammed ZINDQJackson Heights
    2016A51920PRussellJ. Loren—HAlston, GloriaINDXBronx
    2020B551331PDiazDarmaVIAlvarado, AlexandraINDKBrooklyn
    2009B41160PDiaz Jr.Ruben—HAlvarez, AndreitaINDXBronx
    1993A5SCPPriceWarrieLAANGELL , JEANINDMNEW YORK

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

    0%
    Espada, Jr.Diaz Jr.Moskowitz
    candfirsttextCandidate's First Name0%PedroRubenEva
    candmicategoricalCandidate's Middle Initial57%SDLof 15
    committeecategoricalCommittee ID, assigned by the CFB0%HALof 11
    nametextIntermediary Name0%GOLDSTEIN, ARTHURRicci, FrankKelly, Kevin
    c_codecategoricalContributor Type0%INDFAMEMPOof 6
    strnotextIntermediary's Street Number100%—
    strnametextIntermediary's Street Name100%—
    apartmenttextIntermediary's Apartment Number100%—
    boroughcdcategoricalIntermediary's Borough Code2%MKXof 6
    citytextIntermediary's City, Schedule N - Vendor's City2%New YorkBrooklynBronx
    statecategoricalIntermediary's State, Schedule N - Vendor's State2%NYNJDCof 3
    ziptextIntermediary's Zip Code4%112151047210036
    occupationtextIntermediary's Occupation16%AttorneyRetiredPhysician
    empnametextIntermediary's Employer20%Self-EmployedRetiredAll Stars Project, Inc.
    empstrnotextIntermediary's Employer's Street Number28%500140
    empstrnametextIntermediary's Employer's Street Name26%BroadwayGreenwich St.Third Avenue
    empcitytextIntermediary's Employer's City26%New YorkBronxBrooklyn
    empstatecategoricalIntermediary's Employer's State26%NYNJDCof 5
    amntintegerTotal Amount Intermediated for Candidate and Election Cycle0%3020100