Lobbying Clients Disclosures: Four Biannual Period Window by US Government | Demographics and Population Studies

About this Dataset

Lobbying Clients Disclosures: Four Biannual Period Window

Data provided by Lobbying Clients in their Semi-Annual filings submitted to the NYS Joint Commission on Public Ethics
Organization: State of New York
Last updated: 2020-11-12T03:59:37.503302
Tags: disclosures, integrity, lobbying-clients

Tables

Table 1

@usgov.state_of_new_york_lobbying_clients_disclosures_four_bi_65bb305f.table_1

8.2 MB
47752 rows
26 columns


CREATE TABLE table_1 (
  "reporting_year" DOUBLE,
  "reporting_period" VARCHAR,
  "client_name" VARCHAR,
  "csr_third_party_name" VARCHAR,
  "client_address_1" VARCHAR,
  "client_address_2" VARCHAR,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" DOUBLE,
  "client_phone" VARCHAR,
  "csr_responsible_person_first_name" VARCHAR,
  "csr_responsible_person_last_name" VARCHAR,
  "total_compensation" DOUBLE,
  "total_expenses" DOUBLE,
  "bill_details_1" VARCHAR,
  "bill_details_2" VARCHAR,
  "title_details_1" VARCHAR,
  "title_details_2" VARCHAR,
  "lobbyist_subjects_1" VARCHAR,
  "lobbyist_subjects_2" VARCHAR,
  "person_1" VARCHAR,
  "person_2" VARCHAR,
  "procurement_number_1" VARCHAR,
  "procurement_number_2" VARCHAR,
  "procurement_subjects_1" VARCHAR,
  "procurement_subjects_2" VARCHAR
);