Dataset: LA City Projects & Agencies By Lobbying Firms

About this Dataset

LA City Projects & Agencies By Lobbying Firms

Content

City projects and agencies that were lobbied by a registered Lobbying Firm must be disclosed on a quarterly basis.

Context

This is a dataset hosted by the city of Los Angeles. The organization has an open data platform found here and they update their information according the amount of data that is brought in. Explore Los Angeles's Data using Kaggle and all of the data sources available through the city of Los Angeles organization page!

Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Mike Wilson on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Tables

City Projects And Agencies Lobbied By Registered Lobby 34660ac4

@kaggle.cityofla_la_city_projects_agencies_by_lobbying_firms.city_projects_and_agencies_lobbied_by_registered_lobby_34660ac4

514.82 KB
34592 rows
14 columns


CREATE TABLE city_projects_and_agencies_lobbied_by_registered_lobby_34660ac4 (
  "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
);