About this Dataset

Political Consultant Filings: Beginning 2016

This dataset contains Political Consultant Disclosure Statements and Correction Filings, as well as an agency-generated final records for each political consultant. Each line contains the Political Consultant’s name, business address and telephone as well as the public official/candidate and client names, business address, telephone number, the office held or sought by each public official/candidate where applicable and a brief description of the services provided to each.
Organization: State of New York
Last updated: 2020-11-12T04:00:27.266481
Tags: candidate-for-public-office, political-consultant, political-consultant-client, political-consulting, political-consulting-services, public-official

Tables

Table 1

@usgov.state_of_new_york_political_consultant_filings_beginning_2016.table_1

296.13 KB
16880 rows
28 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "reporting_period" VARCHAR,
  "filing_date" TIMESTAMP,
  "filing_record_identifier" VARCHAR,
  "filing_type" VARCHAR,
  "correction_type" VARCHAR,
  "political_consultant_pc_name" VARCHAR,
  "pc_business_name" VARCHAR,
  "pc_business_address_1" VARCHAR,
  "pc_business_city" VARCHAR,
  "pc_business_state" VARCHAR,
  "pc_business_zip_code" VARCHAR,
  "pc_business_county" VARCHAR,
  "pc_business_country" VARCHAR,
  "pc_business_telephone_number" VARCHAR,
  "client_type" VARCHAR,
  "client_name" VARCHAR,
  "office_held_sought" VARCHAR,
  "client_business_address_1" VARCHAR,
  "client_business_city" VARCHAR,
  "client_business_state" VARCHAR,
  "client_business_zip_code" VARCHAR,
  "client_business_country" VARCHAR,
  "client_business_telephone_number" VARCHAR,
  "name_of_person_with_controlling_interest_in_business" VARCHAR,
  "description_of_services_provided" VARCHAR,
  "registration_id" VARCHAR,
  "reporting_period_id" BIGINT
);