City Clerk ELobbyist Data by US Government | Demographics and Population Studies

About this Dataset

City Clerk ELobbyist Data

Data set includes the filings for Client Registrations and Periodic Reports filed by Lobbyist.
Organization: City of New York
Last updated: 2020-11-10T17:02:55.571624
Tags: elobbyist, lobbying, lobbyists

Tables

Table 1

@usgov.city_of_new_york_city_clerk_elobbyist_data.table_1

13.18 MB
76107 rows
28 columns


CREATE TABLE table_1 (
  "client_id" BIGINT,
  "lobbyist_id" BIGINT,
  "lobbyist_name" VARCHAR,
  "lobbyist_po" VARCHAR,
  "report_year" BIGINT,
  "client_name" VARCHAR,
  "client_po" VARCHAR,
  "lobbyist_employees" VARCHAR,
  "lobbyist_activities" VARCHAR,
  "lobbyist_targets" VARCHAR,
  "lobbyist_is_colobbyist" BIGINT,
  "client_industry" VARCHAR,
  "lobbyist_has_finacial_interest" BIGINT,
  "num_periods" BIGINT,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "periodic_id" DOUBLE,
  "registration_id" DOUBLE,
  "period" DOUBLE,
  "periodic_year" DOUBLE,
  "compensation_total" DOUBLE,
  "lobbying_expenses_total" DOUBLE,
  "small_expense_total" DOUBLE,
  "itemized_expense_total" DOUBLE,
  "salary_expense_total" DOUBLE,
  "reimbursed_expenses_total" DOUBLE,
  "periodic_activities" VARCHAR,
  "periodic_targets" VARCHAR
);