lobbying_filings_raw: 07f2ce87-33d5-4aac-ad5e-e6370f2e9379

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
07f2ce87-33d5-4aac-ad5e-e6370f2e9379 YT 8101 CAPITOL ASSOCIATES, INC. 111206 UNIV OF SAN DIEGO 2007 year_end 2007-12-13T10:46:44-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/07f2ce87-33d5-4aac-ad5e-e6370f2e9379/", "filing_uuid": "07f2ce87-33d5-4aac-ad5e-e6370f2e9379", "filing_type": "YT", "filing_type_display": "Year-End Termination", "filing_year": 2007, "filing_period": "year_end", "filing_period_display": "Year-End (July 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/07f2ce87-33d5-4aac-ad5e-e6370f2e9379/print/", "filing_document_content_type": "application/pdf", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-12-13T10:46:44-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 8101, "url": "https://lda.senate.gov/api/v1/registrants/8101/", "house_registrant_id": 30813, "name": "CAPITOL ASSOCIATES, INC.", "description": "Government Relations Health Policy Consulting Firm", "address_1": "1009 Duke Street", "address_2": null, "address_3": null, "address_4": null, "city": "Alexandria", "state": "VA", "state_display": "Virginia", "zip": "22314", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "NATHANIEL BAUGH", "contact_telephone": "+1 202-544-1880", "dt_updated": "2026-01-29T13:13:13.072592-05:00"}, "client": {"id": 111206, "url": "https://lda.senate.gov/api/v1/clients/111206/", "client_id": 1736, "name": "UNIV OF SAN DIEGO", "general_description": null, "client_government_entity": null, "client_self_select": null, "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-07"}, "lobbying_activities": [{"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "\r\nH.R. 1585/ S. 1547 National Defense Authorization Act for Fiscal Year 2008", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 22358, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "A", "last_name": "CONNOLLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29184, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "A", "last_name": "FINERFROCK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "\r\nS. 1710: Making appropriations for the Departments of Labor, Health and Human Services, and Education, and related agencies for the fiscal year ending September 30, 2008, and for other purposes\nH.R. 3043: Making appropriations for the Departments of Labor, Health and Human Services, and Education, and related agencies for the fiscal year ending September 30, 2008, and for other purposes\n\nH. R. 3222 Making appropriations for the Department of Defense for the fiscal year ending September 30, 2008, and for other purposes\n\n\r\nH.J.Res. 20: Making further continuing appropriations for the fiscal year 2007, and for other purposes\nH.J.Res. 102: Making further continuing appropriations for the fiscal year 2007, and for other purposes\n\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 22358, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "A", "last_name": "CONNOLLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29184, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "A", "last_name": "FINERFROCK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "\r\nH.R. 2204 Teacher Excellence for All Children Act of 2007\nH.R. 4137, College Opportunity and Affordability Act of 2007", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 22358, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "A", "last_name": "CONNOLLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29184, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "A", "last_name": "FINERFROCK", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 31, "name": "Navy, Dept of"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 30813 CA CA US US     0         60000.0  

Links from other tables