home

lobbying

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov 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 with Government Positions
  • Political Contributions by Lobbyists

Tables

lobbying_activities

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

Many 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

250 rows

lobbying_filings_raw

filing_uuid, filing_type, registrant_id, registrant_name, client_id, client_name, filing_year, filing_period, received_date, amount_reported, is_amendment, is_no_activity, is_termination, raw_json

Many rows

lobbying_gov_entities

id, name

257 rows

lobbying_issue_codes

code, description

79 rows

lobbying_lobbyists

id, filing_uuid, lobbyist_name, covered_position, is_new

Many 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

137,404 rows

Powered by Datasette · Queries took 67.75ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API