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_affiliated_orgs

id, filing_uuid, org_name, country, country_code

29,447 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

300 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, 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

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

138,328 rows

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