home / lobbying / lobbying_filings_raw

lobbying_filings_raw: a6c9744a-7592-4414-b186-8ecf7764f71c

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

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
a6c9744a-7592-4414-b186-8ecf7764f71c Q1 2731 AMERICAN LAND TITLE ASSOCIATION 103590 AMERICAN LAND TITLE ASSOCIATION 2019 first_quarter 2019-04-17T15:55:17.860000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/a6c9744a-7592-4414-b186-8ecf7764f71c/", "filing_uuid": "a6c9744a-7592-4414-b186-8ecf7764f71c", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2019, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a6c9744a-7592-4414-b186-8ecf7764f71c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "130000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Justin Ailes", "dt_posted": "2019-04-17T15:55:17.860000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1800 M Street, NW Suite 300S", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 2731, "url": "https://lda.senate.gov/api/v1/registrants/2731/", "house_registrant_id": 31612, "name": "AMERICAN LAND TITLE ASSOCIATION", "description": null, "address_1": "601 Pennsylvania Ave NW", "address_2": "Suite 750, North Building", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STEVEN M GOTTHEIM", "contact_telephone": "+1 202-261-2943", "dt_updated": "2026-01-20T14:53:40.691023-05:00"}, "client": {"id": 103590, "url": "https://lda.senate.gov/api/v1/clients/103590/", "client_id": 12, "name": "AMERICAN LAND TITLE ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "General education regarding data privacy and data security in real estate transactions, no bill introduced. General education regarding the collection, use and protection of sensitive information collected by financial regulators and private companies.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47800, "prefix": null, "prefix_display": null, "first_name": "JUSTIN", "nickname": null, "middle_name": null, "last_name": "AILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67408, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67405, "prefix": null, "prefix_display": null, "first_name": "ROB", "nickname": null, "middle_name": null, "last_name": "ROBILLIARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "Draft legislation, The Strengthening the Tenth Amendment Through Entrusting States Act, to amend the Controlled Substances Act to provide for a new rule regarding the application of the Act to marihuana; no bill yet introduced.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67408, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67405, "prefix": null, "prefix_display": null, "first_name": "ROB", "nickname": null, "middle_name": null, "last_name": "ROBILLIARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "General education regarding the Treasury Departments Financial Crimes Enforcement Network (FinCEN) extending its real estate Geographic Targeting Orders (GTOs); no bill introduced. H.R. 1595, the Secure and Fair Enforcement (SAFE) Banking Act of 2019, to create protections for depository institutions that provide financial services to cannabis-related legitimate businesses and service providers for such businesses; entire bill. Draft legislation entitled the Corporate Transparency Act of 2019, to ensure that persons who form corporations or limited liability companies in the United States disclose the beneficial owners of those corporations or limited liability companies, in order to prevent wrongdoers from exploiting United States corporations and limited liability companies for criminal gain, to assist law enforcement in detecting, preventing, and punishing terrorism, money laundering, and other misconduct involving United States corporations and limited liability companies; no bill introduced.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67408, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67405, "prefix": null, "prefix_display": null, "first_name": "ROB", "nickname": null, "middle_name": null, "last_name": "ROBILLIARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 52941, "prefix": null, "prefix_display": null, "first_name": "STEVE", "nickname": null, "middle_name": null, "last_name": "GOTTHEIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "General education regarding property records in disaster planning and recovery in Puerto Rico, no bill introduced.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67405, "prefix": null, "prefix_display": null, "first_name": "ROB", "nickname": null, "middle_name": null, "last_name": "ROBILLIARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Seeking to ensure continued funding for the Federal Bureau of Investigations, IC3 program in the Fiscal Year 2020 Commerce, Justice, Science, and Related Agencies Appropriations Act; no bill yet introduced. Seeking funding for the Department of Treasury to report activities to both combat and raise awareness of wire fraud in real estate transactions in the Fiscal Year 2020 Financial Services and General Government Appropriations Act, no bill introduced. Seeking funding for the Federal Bureau of Investigations to report activities to both combat and raise awareness of wire fraud in real estate transactions in the Fiscal Year 2020 Commerce, Justice, Science, and Related Agencies Appropriations Act; no bill yet introduced. Seeking funding for the Department of Justice to report activities to both combat and raise awareness of wire fraud in real estate transactions in the Fiscal Year 2020 Commerce, Justice, Science, and Related Agencies Appropriations Act; no bill yet introduced.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67408, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67405, "prefix": null, "prefix_display": null, "first_name": "ROB", "nickname": null, "middle_name": null, "last_name": "ROBILLIARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RES", "general_issue_code_display": "Real Estate/Land Use/Conservation", "description": "General education regarding wire fraud in real estate transactions, no bill introduced. General education regarding the Real Estate Settlement Procedures Act, no bill introduced. Seeking introduction of the TRID Improvement Act of 2019, to amend the Real Estate Settlement Procedures Act of 1974 to modify requirements related to mortgage disclosures; no bill yet introduced.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67408, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "TRYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67405, "prefix": null, "prefix_display": null, "first_name": "ROB", "nickname": null, "middle_name": null, "last_name": "ROBILLIARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 47800, "prefix": null, "prefix_display": null, "first_name": "JUSTIN", "nickname": null, "middle_name": null, "last_name": "AILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31612 DC DC US US   0 0           130000.0

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.565ms · Privacy