Dataset: New York City - 2013 Campaign Contributions

About this Dataset

New York City - 2013 Campaign Contributions

This dataset is now updated annually here.

Context

A record of every campaign donation made during the 2013 New York City election cycle. This dataset includes the donor, recipient, and dollar amount of contributions to campaigns both for the mayor of New York City (for the 2013-2017 term, which was won by Bill de Blasio) and for the variety of other publicly elected positions in the City of New York.

Content

This dataset includes identifying information about the name of the person and/or corporation which made the donation, the dollar amount of the donation, whether or not it was later refunded (if so, a date of refund is provided), the archetype the donation falls under, the name of the candidate being donated to, and identifying information about the donor (including self-identified work area or profession).

This dataset includes a field for campaign finance codes, read here for more information on what these are.

Acknowledgements

This data is published as-is by the City of New York.

Inspiration

What is the distribution of donations made across candidates?
What is the distribution of small-to-large donations?
Who is doing the donating? How are they spatially distributed through the city?

Tables

N 2013 Campaign Contributions

@kaggle.new_york_city_nyc_2013_campaign_contributions.n_2013_campaign_contributions

934.38 KB
17160 rows
51 columns


CREATE TABLE n_2013_campaign_contributions (
  "election" DOUBLE,
  "officecd" DOUBLE,
  "candid" VARCHAR,
  "canclass" VARCHAR,
  "candlast" VARCHAR,
  "candfirst" VARCHAR,
  "candmi" VARCHAR,
  "committee" VARCHAR,
  "filing" DOUBLE,
  "schedule" VARCHAR,
  "pageno" VARCHAR,
  "sequenceno" VARCHAR,
  "refno" VARCHAR,
  "date" VARCHAR,
  "refunddate" VARCHAR,
  "name" VARCHAR,
  "c_code" VARCHAR,
  "strno" DOUBLE,
  "strname" VARCHAR,
  "apartment" VARCHAR,
  "boroughcd" VARCHAR,
  "occupation" VARCHAR,
  "empname" VARCHAR,
  "empstrno" DOUBLE,
  "empstrname" VARCHAR,
  "amnt" DOUBLE,
  "matchamnt" DOUBLE,
  "prevamnt" DOUBLE,
  "pay_method" DOUBLE,
  "intermno" DOUBLE,
  "intermname" VARCHAR,
  "intstrno" DOUBLE,
  "intstrnm" VARCHAR,
  "intaptno" DOUBLE,
  "intst" VARCHAR,
  "intzip" DOUBLE,
  "intempname" VARCHAR,
  "intempstno" DOUBLE,
  "intempstnm" VARCHAR,
  "intempcity" VARCHAR,
  "intempst" VARCHAR,
  "intoccupa" VARCHAR,
  "purposecd" VARCHAR,
  "exemptcd" VARCHAR,
  "adjtypecd" DOUBLE,
  "rr_ind" VARCHAR,
  "seg_ind" VARCHAR,
  "int_c_code" VARCHAR,
  "location_1" VARCHAR,
  "location_2" VARCHAR,
  "location_3" VARCHAR
);