home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9fc6f7c2-aa45-4286-94ac-de96095bd2d9

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
9fc6f7c2-aa45-4286-94ac-de96095bd2d9 Q4 400359637 RICHARD J. LEIDL, P.C. 189519 CITY OF ABILENE, TEXAS 2009 fourth_quarter 2010-01-15T15:26:40.480000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9fc6f7c2-aa45-4286-94ac-de96095bd2d9/", "filing_uuid": "9fc6f7c2-aa45-4286-94ac-de96095bd2d9", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2009, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/9fc6f7c2-aa45-4286-94ac-de96095bd2d9/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Richard J. Leidl, President", "dt_posted": "2010-01-15T15:26:40.480000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "5335 Wisconsin Avenue, NW", "registrant_address_2": "Suite 440", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20015", "registrant": {"id": 400359637, "url": "https://lda.senate.gov/api/v1/registrants/400359637/", "house_registrant_id": null, "name": "RICHARD J. LEIDL, P.C.", "description": "Law/lobbying firm", "address_1": "5335 Wisconsin Avenue, NW", "address_2": "Suite 440", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20015", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "RICHARD LEIDL", "contact_telephone": "+1 202-686-4847", "dt_updated": "2026-01-15T17:20:44.623092-05:00"}, "client": {"id": 189519, "url": "https://lda.senate.gov/api/v1/clients/189519/", "client_id": 36, "name": "CITY OF ABILENE, TEXAS", "general_description": "Municipal government", "client_government_entity": true, "client_self_select": false, "state": "TX", "state_display": "Texas", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-10-01"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Support for H.R. 1548.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Funding for projects in the FY 2010 appropriations bills and under the American Recovery and Reinvestment Act, HR 1.\nSupport for Commerce Department business incubation program funding in the FY 2010 Commerce, Justice, Science Appropriations Bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Support for R&D tax credit under H.R.422 and S. 1203.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Funding for an economic development project under the HUD Economic Development Initiative Program in the FY 2010 Transportation, HUD Appropriations Bills.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "Funding for a control tower under the Federal Aviation Administration in the FY 2010 Transportation Appropriations Bill.\nIssues concerning Aircraft Rescue and Fire Fighting standards under section 311of H.R. 915 and under S.1451.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "Funding for a NASA research program under the FY 2010 Commerce, Justice, Science Appropriations Bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Funding for water treatment facilites under an EPA program in the FY 2010 Interior Appropriations Bills.\nIssues concerning construction of a water reservoir.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "Support for a waste-to-energy facility at Dyess Air Force Base.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Support for a provision in HR 3817 concerning non-accelerated filers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Funding for bus facility projects under a Federal Transit Administration program and a pedestrian and bike trail under a Federal Highway Administration program in the FY 2010 Transportation, HUD Appropriations Bill.\nFunding for a Regional Transit Center under the Surface Transportation Authorization Act of 2009.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "Funding for a flood prevention project under an Army Corps of Engineer program in the FY 2010 Energy and Water Appropriations Bills.\nSupport for Federal Emergency Management Agency Flood Map Update Project.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46314, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "J", "last_name": "LEIDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US   TX   US US Municipal government 1 0         20000.0  

Links from other tables

  • 11 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.544ms · Privacy