Name: Campaign Expenditures
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Campaign Expenditures

Expenditures of election campaigns.
Organization: City of New York
Last updated: 2021-08-07T17:32:53.531012
Tags: campaign-expenditure

Tables

Table 1

@usgov.city_of_new_york_2021_campaign_expenditure.table_1

12.57 MB
466,403 rows
32 columns

CREATE TABLE table_1 (
  "election" BIGINT,
  "officecd" BIGINT,
  "candid" VARCHAR,
  "canclass" VARCHAR,
  "candlast" VARCHAR,
  "candfirst" VARCHAR,
  "candmi" VARCHAR,
  "committee" VARCHAR,
  "filing" BIGINT,
  "schedule" VARCHAR,
  "pageno" VARCHAR,
  "sequenceno" VARCHAR,
  "refno" VARCHAR,
  "inv_date" TIMESTAMP,
  "date" TIMESTAMP,
  "name" VARCHAR,
  "c_code" VARCHAR,
  "org_ind" VARCHAR,
  "strno" VARCHAR,
  "strname" VARCHAR,
  "apartment" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "pay_method" VARCHAR,
  "amnt" DOUBLE,
  "purposecd" VARCHAR,
  "purpose" VARCHAR,
  "explain" VARCHAR,
  "exemptcd" VARCHAR,
  "rr_ind" VARCHAR,
  "seg_ind" VARCHAR
);