home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 6f762694-d74b-4399-83e8-d938d533e208

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
6f762694-d74b-4399-83e8-d938d533e208 Q4 287771 CLARK HILL, PLC 176907 CITY OF BALTIMORE 2019 fourth_quarter 2020-01-15T13:26:27.397000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/6f762694-d74b-4399-83e8-d938d533e208/", "filing_uuid": "6f762694-d74b-4399-83e8-d938d533e208", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2019, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/6f762694-d74b-4399-83e8-d938d533e208/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Kevin F. Kelly", "dt_posted": "2020-01-15T13:26:27.397000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1001 Pennsylvania Avenue NW", "registrant_address_2": "Suite 1300 South", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 287771, "url": "https://lda.senate.gov/api/v1/registrants/287771/", "house_registrant_id": 37048, "name": "CLARK HILL, PLC", "description": "Law firm", "address_1": "1001 Pennsylvania Avenue NW", "address_2": "Suite 1300 South", "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": "ANTHONY CAMPAU", "contact_telephone": "+1 240-331-8804", "dt_updated": "2026-01-29T12:07:12.597780-05:00"}, "client": {"id": 176907, "url": "https://lda.senate.gov/api/v1/clients/176907/", "client_id": 556, "name": "CITY OF BALTIMORE", "general_description": "Municipality.", "client_government_entity": true, "client_self_select": null, "state": "MD", "state_display": "Maryland", "country": "US", "country_display": "United States of America", "ppb_state": "MD", "ppb_state_display": "Maryland", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2017-03-08"}, "lobbying_activities": [{"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Transportation, Housing & Urban Development, and Independent Agencies Appropriations Act, FY2020, transportation funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65415, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "F", "last_name": "KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65202, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "LIPIN", "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": "Department of Justice, consent decree and grant request, gun violence initiative grant request.\n\nCommerce, Justice, Science, and Related Agencies Appropriations Act, FY2020, Department of Justice funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65415, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "F", "last_name": "KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65202, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "LIPIN", "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": "ALC", "general_issue_code_display": "Alcohol and Drug Abuse", "description": "Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, FY2019 and FY2020; substance abuse funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65415, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "F", "last_name": "KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65202, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "LIPIN", "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": "HOU", "general_issue_code_display": "Housing", "description": "Transportation, Housing and Urban Development, and Independent Agencies Appropriations Act, FY2020.\n\nCity related initiatives, public housing funding, Section 8 and public funding matters, and neighborhood stabilization/demolition funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65415, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "F", "last_name": "KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65202, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "LIPIN", "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": "Transportation, Housing and Urban Development, and Independent Agencies Appropriations Act, FY2020, Housing and transportation funding; economic development funding and City related initiatives.\n\nCommerce, Justice, Science, and Related Agencies Appropriations Act, FY2020, Department of Justice funding, Census operations funding. \n\nLabor, Health and Human Services, and Education, and Related Agencies Appropriations Act, FY2020, substance abuse funding.\n\nEnergy & water appropriations FY2020; Army Corps funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65415, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "F", "last_name": "KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65202, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "LIPIN", "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 37048 MD MD US US Municipality. 1 0         10000.0  

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.521ms · Privacy