Name: Registered Lobbyist Disclosures: 7 Year Window
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Registered Lobbyist Disclosures: 7 Year Window

Data provided by Lobbyist in their Biennial Registration and Bi-monthly filings submitted to NYS Joint Commission on Public Ethics
Organization: State of New York
Last updated: 2020-11-12T03:59:52.103687
Tags: integrity, lobbyist-disclosures

Tables

Table 1

@usgov.state_of_new_york_registered_lobbyist_disclosures_7_year_window.table_1

18.84 MB
192,941 rows
39 columns

CREATE TABLE table_1 (
  "reporting_year" BIGINT,
  "reporting_period" VARCHAR,
  "lobbyist_name" VARCHAR,
  "lobbyist_address_1" VARCHAR,
  "lobbyist_address_2" VARCHAR,
  "lobbyist_city" VARCHAR,
  "lobbyist_state" VARCHAR,
  "lobbyist_zip" VARCHAR,
  "lobbyist_phone" VARCHAR,
  "lobbying_type" VARCHAR,
  "government_level" VARCHAR,
  "lobbyist_type" VARCHAR,
  "additional_lobbyists_lr" VARCHAR,
  "additional_lobbyists_lbr" VARCHAR,
  "client_name" VARCHAR,
  "client_address_1" VARCHAR,
  "client_address_2" VARCHAR,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" VARCHAR,
  "client_phone" VARCHAR,
  "client_business_nature" VARCHAR,
  "lr_responsible_party_first_name" VARCHAR,
  "lr_responsible_party_last_name" VARCHAR,
  "total_expenses" BIGINT,
  "total_compensation" BIGINT,
  "total_reimbursed" BIGINT,
  "bill_details_1" VARCHAR,
  "bill_details_2" VARCHAR,
  "procurement_details_1" VARCHAR,
  "procurement_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
);