From a 500-row sample across 50 columns.
citystateHas zip codes (`zip`) — joinable, but needs boundary shapes to draw.
| election | officecd | recipid | canclass | recipname | candfirst | candmi | committee | filing | schedule | refno | date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 | 5 | 579 | P | Hughes | Michael | B | H | 10 | ABC | P0009-05 | 2001-08-08T00:00:00.000 |
| 2001 | 5 | 559 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
election | categorical | Election Cycle | 0% | 202120252013of 9 |
officecd | categorical | Office Sought. 1=Mayor; 2=Public Advocate; 3=Comptroller; 4=Borough President; 5=City Council; 6=Undeclared | 0% | 5111of 13 |
recipid | text | Candidate ID | 0% | 28991481164 |
canclass | categorical | Campaign Finance Program Classification. Participant, Non-Participant, Limited Participant, Undetermined | 0% | PNPUN |
GET /api/datasets/rjkp-yttg GET /api/datasets/rjkp-yttg/quality GET /api/datasets/rjkp-yttg/related GET /api/columns?dataset=rjkp-yttg
citynamezip| P |
| Wooten |
| Donald |
| T |
| H |
| 10 |
| D |
| P0001-01 |
| 2001-08-31T00:00:00.000 |
| 2001 | 5 | C6 | P | Fabozzi | Albert | — | H | 6 | ABC | P0003-08 | 2000-08-01T00:00:00.000 |
| 2001 | 2 | 366 | P | Colon | Willie | — | H | 9 | ABC | P0007-09 | 2001-07-05T00:00:00.000 |
| 2001 | 2 | 366 | P | Colon | Willie | — | H | 9 | ABC | P0007-10 | 2001-07-05T00:00:00.000 |
| 2001 | 2 | 366 | P | Colon | Willie | — | H | 9 | ABC | P0001-08 | 2001-03-20T00:00:00.000 |
| 2001 | 2 | 366 | P | Colon | Willie | — | H | 9 | ABC | P0001-05 | 2001-02-20T00:00:00.000 |
| 2001 | 5 | MJ | P | Martinez | Juan | D | H | 9 | ABC | P0001-10 | — |
| 2001 | 5 | 448 | P | Ciafone | John | J | H | 10 | ABC | P0003-04 | — |
| 2001 | 2 | 366 | P | Colon | Willie | — | H | 9 | ABC | P0002-06 | 2001-04-24T00:00:00.000 |
Showing 12 of 30 columns. All of them are listed below.
recipname | text | Candidate's Last name (2001-2005); Candidate's full name (from 2007) | 0% | Mamdani, Zohran KLander, Bradde Blasio, Bill |
candfirst | text | Candidate's first name (2001-2005) | 79% | FernandoAlanMark |
candmi | text | Candidate's middle initial (2001-2005) | 88% | FMA |
committee | categorical | Committee ID | 0% | HILof 15 |
filing | text | Disclosure Statement Filing Period | 0% | 867 |
schedule | categorical | Schedule. ABC=Monetary Contributions; D=In-Kind Contributions; G=Transfers In; K=Loans/Liabilities Forgiven; M=Receipt Adjustments; N=Outstanding Liabilities | 0% | ABCMDof 9 |
pageno | text | Page Number of schedule on which information was reported | 100% | — |
sequenceno | text | Sequence Number on page of schedule on which information was reported | 100% | — |
refno | text | Transaction Reference Number | 0% | R0000019R0000021R0000023 |
date | datetime | Date Received | 0% | 2021-01-11T00:00:00.0002021-03-11T00:00:00.0002025-01-11T00:00:00.000 |
refunddate | datetime | Date of Refund/Loan forgiven | 98% | 2021-01-11T00:00:00.0002021-07-09T00:00:00.0002021-10-14T00:00:00.000 |
name | text | Contributor's Name | 0% | Johnson, CHRISTOPHER LeoUnited Federation of Tea…Limuli, Laura |
c_code | categorical | Contributor Type.CAN=Candidate; CORP=Corporation; EMPO=Labor Union; FAM=Candidate's Family; IND=Individual; LLC=Limited Liability Company; OTHR=Other; PART=Partnership; PCOMC=Candidate Committee; PCOMP=Political Action Committee; PCOMZ=Party Committee; SPO=Candidate's Spouse; UNKN=Unknown | 0% | INDPCOMPOTHRof 15 |
strno | text | Contributor's Street Number | 99% | 125116 |
strname | text | Contributor's Street Name | 99% | BROADWAYBroadwayCOURT STREET |
apartment | text | Contributor's Apartment Number | 100% | 201401300 |
boroughcd | categorical | Contributor's Borough Code. K=Brooklyn; M=Manhattan; Q=Queens; S=Staten Island; X=Bronx; Z=Outside New York City | 1% | MKZof 6 |
city | text | Contributor's City, Schedule N - Vendor's City | 0% | New YorkBrooklynBronx |
state | text | Contributor's State, Schedule N - Vendor's State | 0% | NYNJCA |
zip | text | Contributor's Zip Code | 1% | 112151002511201 |
occupation | text | Contributor's Occupation | 13% | RetiredNot EmployedAttorney |
empname | text | Contributor's Employer | 23% | Not EmployedSelf-EmployedRetired |
empstrno | text | Contributor's Employer's Street Number | 37% | 1250100 |
empstrname | text | Contributor's Employer's Street Name | 36% | BroadwayPark AvenueMadison Avenue |
empcity | text | Contributor's Employer's City | 32% | New YorkBrooklynNEW YORK |
empstate | text | Contributor's Employer's State | 32% | NYNJCA |
amnt | integer | Amount | 0% | 1005025 |
matchamnt | integer | Matchable Amount of Contribution | 0% | 010050 |
prevamnt | integer | Total of Previous Contributions | 0% | 010050 |
pay_method | integer | Method of Payment. 0=Unknown; 1=Cash; 2=Check; 3=Other; 4=Credit Card; 5=Money Order | 0% | 421 |
intermno | integer | Intermediary Number | 96% | 123 |
intermname | text | Intermediary's Name (if any) | 96% | NYC DSA PACNYC - DSA PACGross, Jack |
intstrno | text | Intermediary's Street Number | 100% | 3551168-70123 |
intstrnm | text | Intermediary's Street Name | 100% | TROY-SCHENECTADY RDLexington AvenueCANTERBURY GATE |
intaptno | categorical | Intermediary's Apartment Number | 100% | 10015004FLof 11 |
intcity | text | Intermediary's City | 96% | New YorkBrooklynNEW YORK |
intst | text | Intermediary's State | 96% | NYNJDC |
intzip | text | Intermediary's Zip Code | 96% | 113851002110024 |
intempname | text | Intermediary's Employer Name | 96% | Self-EmployedSelf EmployedSelf |
intempstno | text | Intermediary's Employer Street Number | 97% | 1100233 |
intempstnm | text | Intermediary's Employer Street Name | 97% | BroadwayPark AvenueMadison Avenue |
intempcity | text | Intermediary's Employer City | 97% | New YorkNEW YORKBrooklyn |
intempst | text | Intermediary's Employer State | 97% | NYNJCA |
intoccupa | text | Intermediary's Occupation | 96% | AttorneyPRESIDENTPresident |
purposecd | text | Purpose Code. ADVAN=Advance Repayment; CMAIL=Campaign Mailings; CMISC=Campaign Miscellaneous; CNTRB=Political Contributions; COMPL=Compliance Cost; CONSL=Campaign Consultants; CONSV=Constituent Services; FUNDR=Fundraising; INTER=Interest Expenses; LITER=Campaign Literature; NQUAL=Non Qualified Expenditures; OFFCE=Office Expenses; OTHER=Other; PETIT=Petition Expenses; POLLS=Polling Costs; POSTA=Postage Expenses; PRINT=Printing Expenses; PROFL=Professional Services; RADIO=Radio Ads; RENTO=Office | 100% | FUNDROTHEROFFCE |
exemptcd | categorical | Exempt Code. C=Compliance Costs; E=Previous Election Costs; P=Petition Challenges; S=Constituent Services; U=Unknown; Blank = Not Exempt | 100% | CPALAof 7 |
adjtypecd | categorical | Schedule M/Adjustment Type Code. 0=Unknown; 1=Returned Check 2=Refund; 5=Other | 98% | 215of 4 |
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 | 96% | INDPCOMPFAMof 14 |