home

lobbying

Correction under way: a loading error counted some lobbying filings' rows more than once, so totals and row counts here are overstated. LDA.gov's own filing pages show the correct figures. This note comes off when the fix is complete.

Lobbying registrations and reports filed under the Lobbying Disclosure Act, from LDA.gov’s API.

As LDA.gov’s terms of use require: “Senate Office of Public Records cannot vouch for the data or analyses derived from these data after the data have been retrieved from LDA.gov.”

Data license: Public Domain (U.S. Government data) · Data source: LDA.gov, the Lobbying Disclosure Act filing system (its REST API)

Custom SQL query

Queries

  • Search Lobbying Clients
  • Lobbying by Issue Area
  • Top Lobbying Clients by Spending
  • Top Lobbying Firms (Registrants)
  • Lobbying Activity for a Client
  • Lobbyists for a Client
  • Lobbying Spending Over Time
  • Search Specific Issues
  • Lobbyists who self-declared a prior government position
  • Political Contributions by Lobbyists

Tables

build_metadata

key, value

2 rows

lobbying_activities

id, filing_uuid, filing_type, registrant_name, registrant_id, client_name, filing_year, filing_period, issue_code, specific_issues, government_entities, is_no_activity, is_termination, received_date

Many rows

lobbying_affiliated_orgs

id, filing_uuid, org_name, country, country_code

29,904 rows

lobbying_client_summary

client_name, filing_count, firms_hired, issue_areas, total_reported, first_year, last_year

56,984 rows

lobbying_contributions

id, filing_uuid, lobbyist_name, contributor_name, payee_name, recipient_name, contribution_type, amount, contribution_date, filing_year, filing_period, registrant_name, received_date

Many rows

lobbying_filing_types

id, name, description

600 rows

lobbying_filings_raw

filing_uuid, filing_type, registrant_id, registrant_name, client_id, client_name, filing_year, filing_period, received_date, is_amendment, is_no_activity, is_termination, raw_json, registrant_state, registrant_country, registrant_house_id, client_state, client_ppb_state, client_country, client_ppb_country, client_general_description, client_government_entity, affiliated_org_count, client_entity_id, client_government_unit_id, client_match_method, client_match_confidence, income_amount, expense_amount

1,970,293 rows

lobbying_gov_entities

id, name

257 rows

lobbying_issue_codes

code, description

79 rows

lobbying_issue_summary

issue_code, issue_description, filing_count, unique_clients, unique_registrants, total_income

80 rows

lobbying_lobbyists

id, filing_uuid, lobbyist_name, covered_position, is_new

Many rows

lobbying_registrant_summary

registrant_name, filing_count, unique_clients, issue_areas, total_income, first_year, last_year

5,816 rows

lobbying_registrations

filing_uuid, filing_type, registrant_id, registrant_name, registrant_description, registrant_address, registrant_country, registrant_ppb_country, client_id, client_name, client_description, client_country, client_ppb_country, client_state, effective_date, received_date, general_issue_codes, is_amendment, termination_date

141,323 rows

lobbying_year_summary

filing_year, filing_count, unique_clients, unique_registrants, total_income, total_expenses

20 rows

Powered by Datasette · Queries took 49.357ms · Data license: Public Domain (U.S. Government data) · Data source: LDA.gov, the Lobbying Disclosure Act filing system (its REST API) · Privacy