From a 500-row sample across 6 columns.
| ec | candidate | board_meeting_date | determination | current_determination_name | final_board_determination |
|---|---|---|---|---|---|
| 2007A | Ignizio, Vincent | 2007-09-06T00:00:00.000 | Accepting a $4,125 over-the-limit contribution | Accepting over-the-limit contributions | 250 |
| 2005 | Clarke, Yvette | 2007-09-06T00:00:00.000 | Corporate contributions | Accepting contributions from corporations, limited liability companies, or partnerships | 250 |
| 2005 | Lester, Jack |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
ec | text | Election year | 0% | 201320092017 |
candidate | text | Candidate name | 0% | de Blasio, BillEugene, MathieuWilliams, Jumaane |
board_meeting_date | datetime | Date of board meeting | 0% | 2016-12-15T00:00:00.0002016-04-14T00:00:00.0002012-10-18T00:00:00.000 |
determination | text | Description of the Board’s determination, as shown on the Final Board Determination or Final Audit Report | 0% | Failing to demonstrate t… |
GET /api/datasets/xrxs-qn95 GET /api/datasets/xrxs-qn95/quality GET /api/datasets/xrxs-qn95/related GET /api/columns?dataset=xrxs-qn95
| 2007-09-06T00:00:00.000 |
| $100 corporate contribution |
| Accepting contributions from corporations, limited liability companies, or partnerships |
| 100 |
| 2005 | Lester, Jack | 2007-09-06T00:00:00.000 | $200 corporate contribution | Accepting contributions from corporations, limited liability companies, or partnerships | 125 |
| 2005 | Vazquez-Hernandez, Viviana | 2007-09-06T00:00:00.000 | Corporate in-kind contribution | Accepting contributions from corporations, limited liability companies, or partnerships | 340 |
| 2005 | Weprin, David | 2007-09-06T00:00:00.000 | $500 corporate contribution | Accepting contributions from corporations, limited liability companies, or partnerships | 125 |
| 2005 | Weprin, David | 2007-09-06T00:00:00.000 | $1,000 corporate contribution | Accepting contributions from corporations, limited liability companies, or partnerships | 125 |
| 2005 | Weprin, David | 2007-09-06T00:00:00.000 | $2,000 corporate contribution | Accepting contributions from corporations, limited liability companies, or partnerships | 125 |
| 2005 | Weprin, David | 2007-09-06T00:00:00.000 | Failing to attribute three partnership/limited liability company contributions in excess of $2,500 | Accepting contributions from corporations, limited liability companies, or partnerships | 300 |
| 2005 | Lester, Jack | 2007-09-06T00:00:00.000 | $8,760 over-the-limit contribution | Accepting over-the-limit contributions | 5380 |
Making impermissible pos…Accepting over-the-limit…current_determination_name | text | Category of the Board's determination | 0% | Accepting contributions …Accepting over-the-limit…Failure to report transa… |
final_board_determination | text | The penalty or public funds repayment obligation assessed in the Final Board Determination | 0% | 250Violation; No Penalty100 |