Name: Clients Of Registered Lobbying Firms
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Clients Of Registered Lobbying Firms

Entities who wish to influence City matters often hire lobbyists to represent them. A lobbying firm must register these entities as clients.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:12.303314
Tags: disclosure, ethics, lobby, lobbying, lobbyist

Tables

Table 1

@usgov.city_of_los_angeles_clients_of_registered_lobbying_firms.table_1

542.94 kB
28,022 rows
17 columns

CREATE TABLE table_1 (
  "client_prefix" VARCHAR,
  "client_first_name" VARCHAR,
  "client_middle_name" VARCHAR,
  "client_last_name" VARCHAR,
  "client_suffix" VARCHAR,
  "lobbying_firm" VARCHAR,
  "registration_year" BIGINT,
  "date_representation_began" TIMESTAMP,
  "date_terminated" TIMESTAMP,
  "date_registered" TIMESTAMP,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" VARCHAR,
  "client_zip_4" VARCHAR,
  "client_website" VARCHAR,
  "city_agencies" VARCHAR,
  "lobbying_firm_registration_form" VARCHAR
);