From a 500-row sample across 43 columns.
committeezipelection+21boroughcdcommitteezip+17electionofficecdcanclassHas zip codes (`zip`) — joinable, but needs boundary shapes to draw.
| election | officecd | recipid | canclass | recipname | committee | filing | schedule | refno | date | c_code | amnt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1997A | 5 | YC | P | Perez, Federico | A | 1 | ABC | P0004-03 | 2000-01-01T00:00:00.000 | UNKN | 0 |
| 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% | 2019A2020A2009A |
officecd | categorical | Office Sought | 0% | 52255of 7 |
recipid | text | Recipient ID. assigned by the CFB | 0% | 12275302195 |
canclass | categorical | Campaign Finance Program Classification | 0% | PNPof 2 |
recipname | text |
GET /api/datasets/kgzj-pjna GET /api/datasets/kgzj-pjna/quality GET /api/datasets/kgzj-pjna/related GET /api/columns?dataset=kgzj-pjna
boroughcdcommitteezip+43boroughcdcommitteezip+49committeezipelection+21boroughcdcommitteezip+17| Perez, Federico |
| A |
| 4 |
| ABC |
| P0001-01 |
| 1997-02-11T00:00:00.000 |
| CORP |
| 100 |
| 1997A | 5 | YC | P | Perez, Federico | A | 4 | ABC | P0001-02 | 1997-02-13T00:00:00.000 | CORP | 200 |
| 2017A | 5 | 1967 | P | Holland, Marvin W | H | 1 | ABC | R0000139 | 2016-11-23T00:00:00.000 | IND | 50 |
| 2017A | 5 | 1967 | P | Holland, Marvin W | H | 1 | ABC | R0000151 | 2016-12-05T00:00:00.000 | IND | 200 |
| 2008A | 5 | 1207 | P | Ober, Charles J | I | 2 | ABC | R0000742 | 2008-05-18T00:00:00.000 | IND | 100 |
| 1994 | 5 | 64 | P | Mangano, Rosemarie A | A | 8 | ABC | P0003-01 | 1994-10-23T00:00:00.000 | IND | 100 |
| 2020A | 44 | 1190 | P | Richards, Donovan | M | 8 | ABC | R0013128 | 2020-09-24T00:00:00.000 | IND | 25 |
| 1994A | 5 | AN | P | Fossella, Vito | B | 1 | ABC | P0008-07 | 1994-03-10T00:00:00.000 | CORP | 250 |
| 1993A | 5 | SC | P | Price, Warrie L | A | 2 | ABC | P0001-07 | 1993-01-19T00:00:00.000 | CORP | 50 |
Showing 12 of 28 columns. All of them are listed below.
| Recipient's Name |
| 0% |
Williams, Jumaane DCrowley, Elizabeth SKonst, Nomiki D |
committee | categorical | Committee ID, assigned by the CFB | 0% | HILof 13 |
filing | categorical | Disclosure Statement Filing Period | 0% | 123of 17 |
schedule | categorical | Schedule | 0% | ABCMDof 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 |
date | datetime | Date Received | 0% | 2019-01-11T00:00:00.0002019-02-11T00:00:00.0002019-01-10T00:00:00.000 |
refunddate | datetime | Date of Refund/Loan forgiven | 98% | 2020-02-20T00:00:00.0002020-02-06T00:00:00.0002020-01-10T00:00:00.000 |
name | text | Contributor's Name | 0% | HART, CAROLYN RJohnson, CHRISTOPHER LeoKatz, Alan Paul |
c_code | categorical | Contributor Type | 0% | INDPCOMPFAMof 14 |
strno | text | Contributor's Street Number | 100% | — |
strname | text | Contributor's Street Name | 100% | — |
apartment | text | Contributor's Apartment Number | 100% | — |
boroughcd | categorical | Contributor's Borough Code | 1% | QKMof 8 |
city | text | Contributor's City, Schedule N - Vendor's City | 0% | BrooklynNew YorkBronx |
state | text | Contributor's State, Schedule N - Vendor's State | 1% | NYNJCA |
zip | text | Contributor's Zip Code | 1% | 100251122610021 |
occupation | text | Contributor's Occupation | 21% | RetiredNot EmployedAttorney |
empname | text | Contributor's Employer | 28% | Self-EmployedRetiredNot Employed |
empstrno | text | Contributor's Employer's Street Number | 39% | 1250100 |
empstrname | text | Contributor's Employer's Street Name | 38% | BroadwayBROADWAYPark Avenue |
empcity | text | Contributor's Employer's City | 38% | New YorkBrooklynNEW YORK |
empstate | text | Contributor's Employer's State | 38% | NYNJCA |
amnt | integer | Amount | 0% | 1005010 |
matchamnt | integer | Matchable Amount of Contribution | 0% | 01050 |
prevamnt | integer | Total of Previous Contributions | 0% | 010050 |
pay_method | integer | Method of Payment | 0% | 421 |
intermno | integer | Intermediary Number, assigned by candidate | 97% | 128 |
intermname | text | Intermediary's Name (if any) | 97% | Malave, IsmaelKim, Young HwanYao, Alan |
intstrno | text | Intermediary's Street Number, assigned by candidate | 100% | — |
intstrnm | text | Intermediary's Street Name | 100% | — |
intaptno | text | Intermediary's Apartment Number | 100% | — |
intcity | text | Intermediary's City | 97% | BronxNew YorkBrooklyn |
intst | categorical | Intermediary's State | 97% | NYNJDCof 3 |
intzip | integer | Intermediary's Zip Code | 97% | 104621047211354 |
intempname | text | Intermediary's Employer Name | 98% | City of NYselfHahm JI Bach Restaurant |
intempstno | text | Intermediary's Employer Street Number | 98% | 150040-11 |
intempstnm | text | Intermediary's Employer Street Name | 98% | Centre Street149th Place37th Ave. |
intempcity | text | Intermediary's Employer City | 98% | New YorkBronxBrooklyn |
intempst | categorical | Intermediary's Employer State | 98% | NYNJCAof 5 |
intoccupa | text | Intermediary's Occupation | 98% | comptroller's officeAttorneyOwner |
purposecd | text | Purpose Code (for Schedule D/In-Kind Contributions) | 99% | UNKNFUNDROFFCE |
exemptcd | categorical | Exempt Code | 100% | CALACANof 3 |
adjtypecd | categorical | Schedule M /Adjustment Type Code | 98% | 241of 5 |
rr_ind | categorical | Runoff/Rerun Indicator | 0% | NYof 2 |
seg_ind | categorical | Segregated Indicator | 1% | NYof 2 |
int_c_code | categorical | Intermediary's Name Code | 97% | INDOTHRFAMof 6 |