Name: Los Angeles Clients Of Registered Lobbying Firms
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Los Angeles Clients Of Registered Lobbying Firms

Content

Entities who wish to influence City matters often hire lobbyists to represent them. A lobbying firm must register these entities as clients.

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 Jorge Alcala on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Tables

Clients Of Registered Lobbying Firms

@kaggle.cityofla_los_angeles_clients_of_registered_lobbying_firms.clients_of_registered_lobbying_firms

459.91 kB
11,593 rows
28 columns

CREATE TABLE clients_of_registered_lobbying_firms (
  "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_street_address" VARCHAR,
  "client_street_address_2" VARCHAR,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" VARCHAR,
  "client_zip_4" VARCHAR,
  "client_area_code" VARCHAR,
  "client_telephone" VARCHAR,
  "client_telephone_ext" VARCHAR,
  "client_email" VARCHAR,
  "client_alt_area_code" DOUBLE,
  "client_alt_telephone" VARCHAR,
  "client_alt_telephone_ext" DOUBLE,
  "client_fax_area_code" DOUBLE,
  "client_fax_number" VARCHAR,
  "client_website" VARCHAR,
  "city_agencies" VARCHAR,
  "lobbying_firm_registration_form" VARCHAR
);