home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f26c97c9-e1e6-4126-b4ff-0e1df0a165e6

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

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
f26c97c9-e1e6-4126-b4ff-0e1df0a165e6 Q1 12868 DUTKO WORLDWIDE, LLC 118115 CALIFORNIA HEALTHCARE INSTITUTE 2009 first_quarter 2009-04-08T13:46:04-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f26c97c9-e1e6-4126-b4ff-0e1df0a165e6/", "filing_uuid": "f26c97c9-e1e6-4126-b4ff-0e1df0a165e6", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2009, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f26c97c9-e1e6-4126-b4ff-0e1df0a165e6/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Mark Irion, Chief Executive Officer", "dt_posted": "2009-04-08T13:46:04-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "412 FIRST STREET SE", "registrant_address_2": "SUITE 100", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 12868, "url": "https://lda.senate.gov/api/v1/registrants/12868/", "house_registrant_id": 32229, "name": "DUTKO WORLDWIDE, LLC", "description": "Government relations firm", "address_1": "80 M STREET SE", "address_2": "SUITE 130", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRIS ANDRESEN", "contact_telephone": "+1 202-851-3618", "dt_updated": "2026-01-26T17:43:32.412214-05:00"}, "client": {"id": 118115, "url": "https://lda.senate.gov/api/v1/clients/118115/", "client_id": 5052, "name": "CALIFORNIA HEALTHCARE INSTITUTE", "general_description": null, "client_government_entity": false, "client_self_select": false, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-03"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Promote the life sciences community and communicate the economic and health benefits of this industry and advise client on health care legislation. Monitor legislation related to Pathway for Biosimilars Act (HR 1548).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4072, "prefix": null, "prefix_display": null, "first_name": "DARREN", "nickname": null, "middle_name": null, "last_name": "WILLCOX", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39784, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "LEMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45762, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45621, "prefix": null, "prefix_display": null, "first_name": "KAREN", "nickname": null, "middle_name": null, "last_name": "TRAMONTANO", "suffix": null, "suffix_display": null}, "covered_position": "the White House Chief of Staff.", "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Monitor federal legislation related to Patent Reform Act of 2007 (HR1260/S515/S610) and advise client as it affects them.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39784, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "LEMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4072, "prefix": null, "prefix_display": null, "first_name": "DARREN", "nickname": null, "middle_name": null, "last_name": "WILLCOX", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45762, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "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": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Promoted the life sciences community and communicated the economic and health benefits of this industry; advised client on health care legislation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39784, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "LEMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4072, "prefix": null, "prefix_display": null, "first_name": "DARREN", "nickname": null, "middle_name": null, "last_name": "WILLCOX", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45762, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "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": "EDU", "general_issue_code_display": "Education", "description": "No Child Left Behind Reauthorization, Higher Education Act Reauthorization, NSF and Department of Education STEM education and professional development programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 4072, "prefix": null, "prefix_display": null, "first_name": "DARREN", "nickname": null, "middle_name": null, "last_name": "WILLCOX", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39784, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "LEMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45762, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "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": "TOR", "general_issue_code_display": "Torts", "description": "Advise client on legislation being developed to address federal preemption for medical device and pharmaceutical manufacturers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39784, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "LEMONS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4072, "prefix": null, "prefix_display": null, "first_name": "DARREN", "nickname": null, "middle_name": null, "last_name": "WILLCOX", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45762, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "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 32229 CA CA US US   0 0         30000.0  

Links from other tables

  • 5 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.285ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy