From a 500-row sample across 25 columns.
net_cntnsmatch_amtpubfnd_pmt+23| el_cycle | from_stmt | to_stmt | office | cand_name | cand_id | boro_dist | termnd | cntrs_no | cntns_no | net_cntns | match_amt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 | 1 | 15 | 1 | Badillo, Herman (ID:81-P) | 81 | () | N | 2035 | 2191 | 543671 | 146378 |
| 2001 | 1 | 15 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
el_cycle | categorical | Election Cycle | 0% | 202120252001of 9 |
from_stmt | integer | First Statement Number for Inclusion of Data | 0% | 1of 1 |
to_stmt | categorical | Last Statement Number for Inclusion of Data | 0% | 161520of 7 |
office | categorical | Office Sought: 1=Mayor; 2=Public Advocate; 3=Comptroller; 4=Borough President; 5=City Council; 6=Undeclared | 0% | 5551of 12 |
GET /api/datasets/m3tj-a2pb GET /api/datasets/m3tj-a2pb/quality GET /api/datasets/m3tj-a2pb/related GET /api/columns?dataset=m3tj-a2pb
cand_id| 1 |
| Cohen, Mitchel (ID:JH-P) * |
| JH |
| () |
| Y |
| 0 |
| 0 |
| 0 |
| 0 |
| 2001 | 1 | 15 | 1 | Ferrer, Fernando (ID:AY-P) | AY | () | N | 6562 | 8298 | 5415381 | 698034 |
| 2001 | 1 | 15 | 1 | Fulani, Lenora (ID:FR-P) * | FR | () | Y | 0 | 0 | 0 | 0 |
| 2001 | 1 | 15 | 1 | Golding, Kenneth (ID:562-P) | 562 | () | N | 0 | 0 | 0 | 0 |
| 2001 | 1 | 15 | 1 | Green, Mark (ID:A7-P) | A7 | () | N | 9594 | 13536 | 11232542 | 1028322 |
| 2001 | 1 | 15 | 1 | Gronowicz, Anthony (ID:581-P) * | 581 | () | Y | 0 | 0 | 0 | 0 |
| 2001 | 1 | 15 | 1 | Hevesi, Alan (ID:A9-P) | A9 | () | N | 9524 | 12725 | 7182254 | 811856 |
| 2001 | 1 | 15 | 1 | Hewes, Henry (ID:573-P) * | 573 | () | Y | 0 | 0 | 0 | 0 |
| 2001 | 1 | 15 | 1 | Iwachiw, Walter (ID:494-P) * | 494 | () | Y | 0 | 0 | 0 | 0 |
Showing 12 of 24 columns. All of them are listed below.
cand_name |
| text |
| Candidate Name |
| 0% |
Brewer, Gale (ID:399-P)Stringer, Scott (ID:148-…Gennaro, James (ID:283-P… |
cand_id | text | Candidate ID, assigned by the CFB | 0% | 399148283 |
boro_dist | text | Contributor's Borough Code: [K=Brooklyn; M=Manhattan; Q=Queens; S=Staten Island; X=Bronx; Z=Outside New York City] OR Council District Number | 0% | ()(M)(07) |
termnd | categorical | If the candidate terminated | 0% | NYof 2 |
incumbent | text | — | 99% | Iof 1 |
cntrs_no | integer | Number of Unique Contributors | 0% | 012 |
cntns_no | integer | Number of Contributions | 0% | 012 |
net_cntns | integer | Net Contribution Amount | 0% | 0100500 |
match_amt | integer | Claimed for Matching Amount | 0% | 0100175 |
i_no | integer | Number of Intermediaries | 0% | 012 |
i_cntns_no | integer | Number of Intermediated Contributions | 0% | 015 |
i_amt | integer | Intermediated Contribution Amount | 0% | 01000100 |
sml_no | integer | Number of Unique Small Contributors (Contributed a Total of $250 or Less) | 0% | 012 |
sml_amt | integer | Amount Contributed by Small Contributors | 0% | 0100175 |
pubfnd_pmt | integer | Public Funds Payment Amount | 0% | 016888882500 |
net_expnd | float | Net Expenditures Amount | 0% | 01000.45 |
cand_class_cd | categorical | Campaign Finance Program Classification | 0% | PNPUNof 3 |
max_no | integer | Number of Contributors Who Donated the Maximum Contribution Limit For the Office | 0% | 012 |
max_amt | integer | Amount Brought in by Contributions at the Maximum Contribution Limit | 0% | 027505500 |
limit | categorical | Maximum Contribution Limit for the Candidate's Office | 0% | 275010501000of 15 |
outstanding_bills | float | Outstanding Bills Amount | 0% | 050020 |
no_match | integer | — | 90% | 1of 1 |