From a 500-row sample across 30 columns.
strnameapartmentelection+23strnameapartmentelection+29strnameapartmentelection+14Has zip codes (`zip`) — joinable, but needs boundary shapes to draw.
| election | officecd | candid | canclass | candlast | candfirst | candmi | committee | filing | schedule | refno | date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 | 5 | 559 | P | Wooten | Donald | T | H | 10 | D | P0001-01 | 2001-08-31T00:00:00.000 |
| 2001 | 5 | CF | P |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
election | categorical | Election Cycle | 0% | 202120132001of 9 |
officecd | categorical | Office Sought: [1=Mayor; 2=Public Advocate; 3=Comptroller; 4=Borough President; 5=City Council; 6=Undeclared] | 0% | 5155of 12 |
candid | text | Candidate ID, assigned by the CFB | 0% | 605148326 |
canclass | categorical | Campaign Finance Program Classification: [Participant, Non-Participant, Limited Participant, Undetermined] | 0% | PNPUN |
GET /api/datasets/qxzj-vkn2 GET /api/datasets/qxzj-vkn2/quality GET /api/datasets/qxzj-vkn2/related GET /api/columns?dataset=qxzj-vkn2
strnameapartmentelection+21strnameapartmentelection+21strnameapartmentelection+14name| Chen |
| Ethel |
| T |
| A |
| 10 |
| F |
| P0005-08 |
| 2001-07-31T00:00:00.000 |
| 2001 | 5 | MJ | P | Martinez | Juan | D | H | 15 | F | P0001-02 | — |
| 2001 | 5 | EC | P | Brown | Everly | D | A | 14 | F | P0001-09 | — |
| 2001 | 5 | CF | P | Chen | Ethel | T | A | 9 | F | P0007-04 | — |
| 2001 | 5 | CF | P | Chen | Ethel | T | A | 10 | F | P0005-09 | 2001-08-24T00:00:00.000 |
| 2001 | 4 | ED | P | Carrion, Jr. | Adolfo | — | H | 4 | F | R0001032 | 1999-10-15T00:00:00.000 |
| 2001 | 4 | ED | P | Carrion, Jr. | Adolfo | — | H | 4 | F | R0001033 | 1999-10-18T00:00:00.000 |
| 2001 | 5 | 492 | P | Kann | Jerry | — | H | 15 | D | R0000356 | 2001-10-20T00:00:00.000 |
| 2001 | 5 | D2 | P | Perkins | Bill | — | H | 13 | F | R0002036 | 2001-10-21T00:00:00.000 |
Showing 12 of 30 columns. All of them are listed below.
candlast | text | Candidate's Last Name | 0% | BloombergStringerde Blasio |
candfirst | text | Candidate's First Name | 0% | MichaelJohnMark |
candmi | text | Candidate's Middle Initial | 47% | AMJ |
committee | categorical | Committee ID, assigned by the CFB | 0% | HIJof 15 |
filing | categorical | Disclosure Statement Filing Period | 0% | 1089of 19 |
schedule | categorical | Schedule: [ABC=Monetary Contributions; D=In-Kind Contributions; G=Transfers In; K=Loans/Liabilities Forgiven; M=Receipt Adjustments; N=Outstanding Liabilities] | 0% | FNDof 6 |
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 | 7% | 2013-09-10T00:00:00.0002021-06-22T00:00:00.0002005-09-13T00:00:00.000 |
date | datetime | Date Received | 0% | 2013-09-10T00:00:00.0002021-06-22T00:00:00.0002005-09-13T00:00:00.000 |
name | text | Payee's Name | 0% | TD BankStaplesStripe - NYC Votes Contr… |
c_code | categorical | Vendor 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% | CORPINDOTHRof 16 |
org_ind | categorical | Organization Indicator: [Y=Vendor is an organization; N=Vendor is not an organization] | 0% | YNof 2 |
strno | text | Vendor's Street Name | 67% | 2251200 |
strname | text | Vendor's Street Name | 63% | BroadwayBROADWAYMadison Avenue |
apartment | text | Vendor's Apartment Number | 91% | 231 |
city | text | Vendor's City | 9% | New YorkBrooklynBronx |
state | text | Vendor's State | 9% | NYCANJ |
zip | text | Vendor's ZIP Code | 12% | 941031120110001 |
pay_method | categorical | Advance, Final, Full, Part, Unknown | 4% | UnknownFinalFullof 5 |
amnt | integer | Amount | 0% | 10050010 |
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 | 1% | OTHERWAGESOFFCE |
purpose | text | Purpose | 1% | Other: explntionCampgn Wrkrs $$Office Expenses |
explain | text | Description of the expenditure | 2% | Advance RepaymentCanvassingStripe Fees |
exemptcd | categorical | Exempt Code: [C=Compliance Costs; E=Previous Election Costs; P=Petition Challenges; S=Constituent Services; U=Unknown; Blank = Not Exempt] | 95% | CBCFEESPof 11 |
rr_ind | categorical | Run-off/Re-run Indicator | 0% | NYof 2 |
seg_ind | categorical | Segregated Indicator | 1% | NYof 2 |