Doing Business Contributions Summary by US Government | Demographics and Population Studies

About this Dataset

Doing Business Contributions Summary

List of Contributors found in the Doing Business database.
Organization: City of New York
Last updated: 2021-08-07T16:59:00.797803
Tags: cfb, doing-business-contributions

Tables

Table 1

@usgov.city_of_new_york_doing_business_contributions_summary.table_1

524.33 KB
11145 rows
52 columns


CREATE TABLE table_1 (
  "election" VARCHAR,
  "officecd" BIGINT,
  "candid" VARCHAR,
  "canclass" VARCHAR,
  "candlast" VARCHAR,
  "candfirst" VARCHAR,
  "candmi" VARCHAR,
  "committee" VARCHAR,
  "filing" BIGINT,
  "schedule" VARCHAR,
  "refno" VARCHAR,
  "date" TIMESTAMP,
  "refunddate" TIMESTAMP,
  "name" VARCHAR,
  "c_code" VARCHAR,
  "strno" VARCHAR,
  "strname" VARCHAR,
  "apartment" VARCHAR,
  "city" VARCHAR,
  "boroughcd" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "db_entity_name" VARCHAR,
  "db_entity_start" VARCHAR,
  "occupation" VARCHAR,
  "empname" VARCHAR,
  "empstrno" VARCHAR,
  "empstrname" VARCHAR,
  "empcity" VARCHAR,
  "empstate" VARCHAR,
  "amnt" DOUBLE,
  "matchamnt" BIGINT,
  "prevamnt" DOUBLE,
  "pay_method" DOUBLE,
  "intermno" DOUBLE,
  "intermname" VARCHAR,
  "intstrno" VARCHAR,
  "intstrnm" VARCHAR,
  "intaptno" VARCHAR,
  "intcity" VARCHAR,
  "intst" VARCHAR,
  "intzip" VARCHAR,
  "intempname" VARCHAR,
  "intempstno" VARCHAR,
  "intempstnm" VARCHAR,
  "intempcity" VARCHAR,
  "intempst" VARCHAR,
  "intoccupa" VARCHAR,
  "int_c_code" VARCHAR,
  "adjtypecd" DOUBLE,
  "rr_ind" VARCHAR,
  "seg_ind" VARCHAR
);