From a 500-row sample across 11 columns.
candidearlypayofficedist+9| election | candid | candname | officecd | officedist | canclass | primarypay | generalpay | runoffpay | totalpay |
|---|---|---|---|---|---|---|---|---|---|
| 2001 | B4 | Aboulafia, Sandy | 5 | 44 | P | 45410 | 0 | 0 | 45410 |
| 2001 | 445 | Adams, Jackie R | 5 | 7 | P | 11073 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
election | categorical | Election Cycle | 0% | 202120252001of 9 |
candid | text | Candidate ID | 0% | 399148846 |
candname | text | Candidate's Last Name, First Name, Middle Initial | 0% | Avella, TonyStringer, Scott MGennaro, James F |
officecd | categorical | Office Sought | 0% | 5554of 11 |
officeboro |
GET /api/datasets/u69g-mvrb GET /api/datasets/u69g-mvrb/quality GET /api/datasets/u69g-mvrb/related GET /api/columns?dataset=u69g-mvrb
| 0 |
| 0 |
| 11073 |
| 2001 | HF | Addabbo, Joseph P | 5 | 32 | P | 75350 | 73970 | 0 | 149320 |
| 2001 | IR | Alamo-Estrada, Agustin | 5 | 14 | P | 25000 | 2400 | 0 | 27400 |
| 2001 | BR | Allen, William A | 5 | 9 | P | 62990 | 0 | 0 | 62990 |
| 2001 | 454 | Alleyne, Alithia | 5 | 40 | P | 0 | 0 | 0 | 0 |
| 2001 | 375 | Alonso, Miguel | 5 | 37 | P | 36121 | 680 | 0 | 36801 |
| 2001 | 241 | Andrews, Jr., Anthony D | 5 | 28 | P | 68580 | 20156 | 0 | 88736 |
| 2001 | 504 | Ariola, JoAnn | 5 | 32 | P | 0 | 69816 | 0 | 69816 |
| 2001 | 51 | Avella, Tony | 5 | 19 | P | 75350 | 75170 | 0 | 150520 |
| categorical |
| Borough |
| 93% |
MKQof 5 |
officedist | integer | City Council District | 17% | 7935 |
canclass | categorical | Campaign Finance Program Classification | 0% | PNPUNof 3 |
earlypay | integer | — | 45% | 0160444174800 |
primarypay | integer | CFB Public Fund Payment for Primary | 0% | 0844475350 |
generalpay | integer | CFB Public Fund Payment for General | 0% | 08250075350 |
runoffpay | categorical | CFB Public Fund Payment for Runoff | 0% | 0574387267331of 13 |
totalpay | integer | CFB Public Fund Total Payments | 0% | 016888882500 |