From a 500-row sample across 27 columns.
pagenocanclassapartment+21canclassapartmentstrname+14pagenocanclassapartment+29Has zip codes (`zip`) — joinable, but needs boundary shapes to draw.
| election | officecd | candid | canclass | candlast | candfirst | committee | filing | schedule | refno | date | c_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1997A | 5 | YC | P | Perez | Federico | A | 2 | F | P0003-07 | 1997-01-27T00:00:00.000 | IND |
| 1997A | 5 | YC | P |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
election | text | Election Cycle | 0% | 2019A2020A2021C |
officecd | categorical | Office Sought | 0% | 55522of 6 |
candid | text | Candidate ID, assigned by the CFB | 0% | 35322761190 |
canclass | categorical | Campaign Finance Program Classification | 0% | PNPof 2 |
candlast | text | Candidate's Last Name |
GET /api/datasets/cgcg-w2ys GET /api/datasets/cgcg-w2ys/quality GET /api/datasets/cgcg-w2ys/related GET /api/columns?dataset=cgcg-w2ys
canclasselectioncandid+1pagenocanclassapartment+23name| Perez |
| Federico |
| A |
| 2 |
| F |
| P0005-02 |
| 1997-01-30T00:00:00.000 |
| IND |
| 1997A | 5 | YC | P | Perez | Federico | A | 2 | F | P0006-05 | — | IND |
| 1991A | 5 | 53 | P | Battaglia | Angela | A | 4 | F | P0002-03 | — | IND |
| 1993A | 5 | 78 | P | Polise | Jo Ann | A | 5 | F | P0001-02 | — | IND |
| 1993A | 5 | 8 | P | Nadelson | Eileen | A | 1 | F | P0001-06 | — | IND |
| 1993A | 5 | SC | P | Price | Warrie | A | 1 | F | P0009-02 | — | IND |
| 1994 | 5 | 64 | P | Mangano | Rosemarie | A | 8 | F | P0001-02 | — | IND |
| 1999A | 5 | 214 | P | Oddo | James | H | 4 | X | P0001-02 | 1999-03-11T00:00:00.000 | IND |
| 2013A | 5 | 1246 | P | Leandre | Jacques | I | 2 | F | R0001511 | 2013-02-04T00:00:00.000 | OTHR |
Showing 12 of 26 columns. All of them are listed below.
| 0% |
RodriguezYinRichards |
candfirst | text | Candidate's First Name | 0% | YdanisAnthonyDao |
candmi | text | Candidate's Middle Initial | 48% | ASD |
committee | categorical | Committee ID, assigned by the CFB | 0% | HIAof 13 |
filing | categorical | Disclosure Statement Filing Period | 0% | 431of 16 |
schedule | categorical | Schedule | 0% | FNDof 7 |
pageno | text | Page Number of schedule on which information was reported (paper filings only) | 100% | — |
sequenceno | text | Sequence Number on page of schedule on which information was reported (paper filings only) | 100% | — |
refno | text | Transaction Reference Number | 0% | P0001-01P0001-02P0001-03 |
inv_date | datetime | Date Invoiced | 9% | 2019-02-26T00:00:00.0002019-02-25T00:00:00.0002007-02-20T00:00:00.000 |
date | datetime | Date Received | 1% | 2019-02-26T00:00:00.0002019-02-25T00:00:00.0002007-02-20T00:00:00.000 |
name | text | Payee's Name | 0% | StaplesTD BankAmalgamated Bank |
c_code | categorical | Contributor Type | 0% | INDCORPOTHRof 16 |
org_ind | categorical | Organization Indicator | 0% | YNof 2 |
strno | text | Vendor's Street Number | 100% | — |
strname | text | Vendor's Street Name | 100% | — |
apartment | text | Vendor's Apartment Number | 100% | — |
city | text | Vendor's City | 10% | BrooklynNew YorkBronx |
state | text | Vendor's State | 9% | NYCAMA |
zip | text | Vendor's ZIP Code | 12% | 941031000111201 |
pay_method | categorical | Method of Payment | 7% | UnknownFullFinalof 5 |
amnt | integer | Amount | 0% | 1005001000 |
purposecd | text | Purpose Code | 1% | OTHERWAGESOFFCE |
purpose | text | Purpose | 1% | Other: explntionCampgn Wrkrs $$Office Expenses |
explain | text | Description of the expenditure | 10% | CanvassingAdvance Repaymentsalary |
exemptcd | categorical | Exempt Code | 98% | CPCANof 8 |
rr_ind | categorical | Run-off/Re-run Indicator | 0% | NYof 2 |
seg_ind | categorical | Segregated Indicator | 2% | NYof 2 |