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 Financial Analysis

ups9-zwkmCity Government26 columns
This dataset contains a financial summary of each campaign during an off-year or special election.
View on NYC Open Data↗

Quality

C74.0 / 100

From a 411-row sample across 26 columns.

completeness97/ 25% weight
consistency62/ 20% weight
accuracy96/ 20% weight
timeliness8/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Off-Year and Special Elections Campaign Expenditure0.62
  • Off-Year and Special Elections Intermediary0.60
  • Off-Year and Special Elections Public Matching Fund Payments0.60
  • Off-Year and Special Elections Contribution0.57
  • Expense Budget0.27
  • City Council Discretionary Funding0.25
  • New York City Population by Borough, 1950 - 20400.25
  • J-51 Exemption and Abatement (Historical)

Sample rows

el_cyclefrom_stmtto_stmtofficecand_namecand_idboro_disttermndcntrs_nocntns_nonet_cntnsmatch_amt
2021C155Padilla, Jr., Jose (ID:379-NP)379(15)N0000
2021C15

Columns

26 queryable · 26 profiled

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

FieldTypeDescriptionNullValues
el_cycletextElection Cycle0%20032019A2009A
from_stmtintegerFirst Statement Number for Inclusion of Data0%1of 1
to_stmtcategoricalLast Statement Number for Inclusion of Data0%1154of 7
officecategoricalOffice Sought0%55522of 7
cand_nametext

Query this from your own app

GET /api/datasets/ups9-zwkm
GET /api/datasets/ups9-zwkm/quality
GET /api/datasets/ups9-zwkm/related
GET /api/columns?dataset=ups9-zwkm
0.24
5
Pazmino, Kevin (ID:2578-NP)
2578
(11)
N
0
0
0
0
2021C155Rivera-Diaz, Ariel (ID:2577-NP)2577(15)N0000
2021C1555Agosto, Kenny (ID:862-P)862(15)N768164204950
2021C1555Berkley, Carlton (ID:1273-P)1273(11)N157180108064276
2021C1555Blackwell, Troy (ID:2529-P) *2529(15)Y53557197.351215
2021C1555Bravo, Ischia (ID:2317-P)2317(15)N48357247876.6324107
2021C1555Crespo, Elisa (ID:2321-P)2321(15)N822102750527.4221665
2021C1555Dinowitz, Eric (ID:2192-P)2192(11)N40752281902.5734007
2021C1555Feliz, Oswald (ID:2311-P)2311(15)N32440940796.5720815

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

Candidate Name
0%
Borelli, Joseph (ID:1892…Alexis, Anthony (ID:437-…Gentile, Vincent (ID:717…
cand_idtextCandidate ID, assigned by the CFB0%416ER1086
boro_disttextContributor's Borough Code or Council District Number0%()-28-40
termndcategoricalIf the candidate terminated0%NYof 2
incumbenttextincumbent89%Iof 1
cntrs_nointegerNumber of Unique Contributors0%013
cntns_nointegerNumber of Contributions0%012
net_cntnsfloatNet Contribution Amount0%0113049760
match_amtintegerClaimed for Matching Amount0%0100400
i_nocategoricalNumber of Intermediaries0%013of 15
i_cntns_nointegerNumber of Intermediated Contributions0%0201
i_amtintegerIntermediated Contribution Amount0%0400300
sml_nointegerNumber of Unique Small Contributors (Contributed a Total of $250 or Less)0%01260
sml_amtfloatAmount Contributed by Small Contributors0%01450100
pubfnd_pmtintegerPublic Funds Payment Amount0%082500142500
net_expndfloatNet Expenditures Amount0%01074575.7199178.64
cand_class_cdcategoricalCampaign Finance Program Classification0%PNPUNof 3
max_nointegerNumber of Contributors Who Donated the Maximum Contribution Limit For the Office0%012
max_amtintegerAmount Brought in by Contributions at the Maximum Contribution Limit0%027505500
limitcategoricalMaximum Contribution Limit for the Candidate's Office0%27501375500of 12
outstanding_billsfloatOutstanding Bills Amount0%020002500
no_matchintegerNumber Match0%7777801601