Name: City Projects And Agencies Lobbied By Registered Lobbying Firms
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

City Projects And Agencies Lobbied By Registered Lobbying Firms

City projects and agencies that were lobbied by a registered Lobbying Firm must be disclosed on a quarterly basis.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:06.406996
Tags: disclosure, ethics, lobby, lobbying, lobbyist, projects

Tables

Table 1

@usgov.city_of_los_angeles_city_projects_and_agencies_lobbied_8ca5f6a1.table_1

2.26 MB
169504 rows
14 columns


CREATE TABLE table_1 (
  "lobbying_firm" VARCHAR,
  "client_prefix" VARCHAR,
  "client_first_name" VARCHAR,
  "client_middle" VARCHAR,
  "client_last_name" VARCHAR,
  "client_suffix" VARCHAR,
  "report_quarter" BIGINT,
  "report_year" BIGINT,
  "project" VARCHAR,
  "reference_number" VARCHAR,
  "reference_number_type" VARCHAR,
  "project_location" VARCHAR,
  "city_agencies_lobbied" VARCHAR,
  "lobbying_firm_quarterly_report" VARCHAR
);