From a 183-row sample across 12 columns.
candidelectioncanclass+1candidelectioncanclass+1totalpaycandidearlypay+9| election | candid | candname | officecd | officedist | canclass | earlypay | primarypay | generalpay | runoffpay | totalpay |
|---|---|---|---|---|---|---|---|---|---|---|
| 1999 | BW | Moskowitz, Eva S | 5 | 4 | P | 0 | 0 | 91333.00 | 0 | 91333.00 |
| 1999 | 207 | Nelson, Michael C | 5 | 48 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
election | text | Election Cycle | 0% | 2019A2009A2021C |
candid | text | Candidate ID, assigned by the CFB | 0% | 3705301068 |
candname | text | Candidate's Last Name, First Name, Middle Initial | 0% | Como, AnthonyQuinn, Christine CLouis, Farah |
officecd | categorical | Office Sought | 0% | 55522of 6 |
officeboro |
GET /api/datasets/7f4s-uwi7 GET /api/datasets/7f4s-uwi7/quality GET /api/datasets/7f4s-uwi7/related GET /api/columns?dataset=7f4s-uwi7
electioncanclassofficecdcandidelectioncanclass+1| P |
| 0 |
| 0 |
| 20244.00 |
| 0 |
| 20244.00 |
| 1999 | 214 | Oddo, James S | 5 | 50 | P | 0 | 0 | 75350.00 | 0 | 75350.00 |
| 1999 | 204 | Quinn, Christine C | 5 | 3 | P | 0 | 0 | 10684.00 | 0 | 10684.00 |
| 1999 | CM | Sollazzo, John | 5 | 50 | P | 0 | 0 | 75350.00 | 0 | 75350.00 |
| 1999A | 213 | Dweck, Joseph A | 5 | 48 | P | 0 | 0 | 21564.00 | 0 | 21564.00 |
| 1999A | 212 | Hikind, Libby N | 5 | 50 | P | 0 | 0 | 63208.00 | 0 | 63208.00 |
| 1999A | 215 | Kamaras, Philip L | 5 | 48 | P | 0 | 0 | 0 | 0 | 0 |
| 1999A | 210 | Kramer, Irma R | 5 | 48 | P | 0 | 0 | 70016.00 | 0 | 70016.00 |
| 1999A | AL | Lees, Aubrey | 5 | 3 | P | 0 | 0 | 75150.00 | 0 | 75150.00 |
| categorical |
| Borough provided for Borough President only |
| 95% |
QXof 2 |
officedist | integer | City Council District provided for City Council only | 15% | 314540 |
canclass | text | Campaign Finance Program Classification | 0% | Pof 1 |
earlypay | integer | CFB Public Fund Early Payment | 0% | 0of 1 |
primarypay | categorical | CFB Public Fund Payment for Primary | 0% | 0100100.001224411.00of 12 |
generalpay | integer | CFB Public Fund Payment for General | 0% | 0142500.0075350.00 |
runoffpay | integer | CFB Public Fund Payment for Runoff | 0% | 0of 1 |
totalpay | integer | CFB Public Fund Total Payments | 0% | 0142500.0075350.00 |