From a 500-row sample across 15 columns.
namecand_idname| name | cand_id | election_cycle | candidate_program | amount_contributions | amount_expenditures | amount_public_funds_received | penalties | public_funds_repayment | penalty_or_public_funds_still | date_dar_sent_to_campaign | date_far_sent_to_campaign |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Gwen Goodwin | 1009 | 2021 | P | 190 | 31.35 | 0 | 0 | 0 | N | — | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
name | text | Candidate Name | 0% | Danniel MaioGale BrewerWalter Iwachiw |
cand_id | text | Unique candidate identifier (across elections) | 0% | 416494399 |
election_cycle | text | Election year/cycle | 0% | 202120012009 |
candidate_program | categorical | Status of the candidate | 4% | PNPUNof 3 |
amount_contributions |
GET /api/datasets/x4w5-m7uh GET /api/datasets/x4w5-m7uh/quality GET /api/datasets/x4w5-m7uh/related GET /api/columns?dataset=x4w5-m7uh
| Beverly Kolber |
| 1060 |
| 2021 |
| NP |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| N |
| — |
| — |
| Alfonso Quiroz | 1092 | 2021 | P | 44774 | 185769.97 | 167768 | 0 | 0 | N | 2023-06-29T00:00:00.000 | 2025-04-28T00:00:00.000 |
| Mercedes Narcisse | 1159 | 2021 | P | 130222.53 | 381636.5 | 286160 | 0 | 0 | N | 2023-03-17T00:00:00.000 | — |
| Mercedes Narcisse | 1159 | 2023 | P | 89313 | 139148.67 | 46000 | 0 | 0 | N | 2024-05-27T00:00:00.000 | 2025-06-14T00:00:00.000 |
| Mercedes Narcisse | 1159 | 2025 | P | 151604.68 | 377008.34 | 305736 | 0 | 0 | N | — | — |
| Ruben Diaz Jr. | 1160 | 2021 | P | 854343.57 | 457222.83 | 0 | 0 | 0 | N | — | — |
| Brad Lander | 1164 | 2021 | P | 1079366.7 | 5510676.67 | 4368230 | 0 | 0 | N | 2024-02-06T00:00:00.000 | — |
| Brad Lander | 1164 | 2025 | P | 1823525.66 | 7901860.21 | 6417738 | 0 | 0 | N | — | — |
| Paul Vallone | 1176 | 2021 | P | 80011.12 | 45097.93 | 0 | 0 | 0 | N | — | — |
Showing 12 of 13 columns. All of them are listed below.
| integer |
| Total amount of candidate contributions |
| 0% |
0100500 |
amount_expenditures | float | Total amount of candidate expenditures | 0% | 010015 |
amount_public_funds_received | integer | Total amount of candidate public funds received | 0% | 016888882500 |
date_dar_sent_to_campaign | datetime | Date draft audit report sent | 51% | 2018-04-09T00:00:00.0002018-04-16T00:00:00.0002014-07-07T00:00:00.000 |
date_far_sent_to_campaign | datetime | Date final audit report sent | 69% | 2022-12-09T00:00:00.0002014-02-21T00:00:00.0002025-08-13T00:00:00.000 |
audit_complete_date | datetime | Date final audit completed | 82% | 2006-07-24T00:00:00.0002006-07-21T00:00:00.0002002-10-07T00:00:00.000 |
date_fbd_sent_to_campaign | datetime | Date final board determination sent | 85% | 2001-11-30T00:00:00.0002001-12-06T00:00:00.0002002-07-30T00:00:00.000 |
penalties | integer | Total amount of penalties | 0% | 0100500 |
public_funds_repayment | integer | Total amount of public funds repayments owed | 0% | 074862000 |
penalties_still_outstanding | integer | Amount of outstanding penalties | 96% | 5501800400 |
public_funds_repayments_still | integer | Amount of outstanding repayments of public funds | 98% | 160241253 |
penalty_or_public_funds_still | categorical | Whether penalty/repayment of public funds still outstanding as of date of fulfillment of this FOIL request | 0% | NYof 2 |