lobbying_filings_raw: 0e8b2b87-c821-4416-a4ba-c681eadcfbc7

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
0e8b2b87-c821-4416-a4ba-c681eadcfbc7 MM 2398 AMFAR THE FOUNDATION FOR AIDS RESEARCH 103556 AMFAR THE FOUNDATION FOR AIDS RESEARCH 2006 mid_year 2006-07-19T00:00:00-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0e8b2b87-c821-4416-a4ba-c681eadcfbc7/", "filing_uuid": "0e8b2b87-c821-4416-a4ba-c681eadcfbc7", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2006, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0e8b2b87-c821-4416-a4ba-c681eadcfbc7/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "160000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2006-07-19T00:00:00-04: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": 2398, "url": "https://lda.senate.gov/api/v1/registrants/2398/", "house_registrant_id": 33487, "name": "AMFAR THE FOUNDATION FOR AIDS RESEARCH", "description": "Foundation for AIDS research.", "address_1": "1100 Vermont Avenue, NW", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ASAL SAYAS", "contact_telephone": "+1 202-331-8600", "dt_updated": "2026-01-26T22:10:52.083952-05:00"}, "client": {"id": 103556, "url": "https://lda.senate.gov/api/v1/clients/103556/", "client_id": 24, "name": "AMFAR THE FOUNDATION FOR AIDS RESEARCH", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "NY", "state_display": "New York", "country": "US", "country_display": "United States of America", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-24"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Global AIDS Issues - particularly the epidemic in Asia\r\n- against prostitution pledge in Global AIDS Bill\r\n- against extending needle exchange policy to multilateral organizations\r\nDomestic AIDS Issues - NIH Reauthorization: supported maintaining the authorities of the OAR and the peer review system - against support for abstinence only programs", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4507, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BYRAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 14558, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "ROBERT", "last_name": "FROST", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 21536, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 32874, "prefix": null, "prefix_display": null, "first_name": "SONIA", "nickname": null, "middle_name": null, "last_name": "KANDATHIL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 43543, "prefix": "ms", "prefix_display": "MS.", "first_name": "MONICA", "nickname": null, "middle_name": "SUSANNE", "last_name": "RUIZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}], "government_entities": [{"id": 300, "name": "UNDETERMINED"}]}, {"general_issue_code": "DOC", "general_issue_code_display": "District of Columbia", "description": "FY 2007 Appropriations:\r\n- HR 5576: General Provision regarding needle exchange", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4507, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BYRAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 14558, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "ROBERT", "last_name": "FROST", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 21536, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 32874, "prefix": null, "prefix_display": null, "first_name": "SONIA", "nickname": null, "middle_name": null, "last_name": "KANDATHIL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 43543, "prefix": "ms", "prefix_display": "MS.", "first_name": "MONICA", "nickname": null, "middle_name": "SUSANNE", "last_name": "RUIZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}], "government_entities": [{"id": 300, "name": "UNDETERMINED"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY 2007 Appropriations:HR 5647, Labor/HHS/Education Appropriations-increased funding for medical research, National Institutes of Health and other Public Health Services,against funding for abstinence only programs,supported peer review system at NIH,opposed efforts to cancel funding for specific grants\r\n-HR 5576 (District of Columbia Appropriations) General Provision regarding needle exchange\r\n-HR 5522 (Foreign Operations Appropriations) -supported language requesting support for regional initiatives such as TREAT Asia Program and General Global AIDS Funding", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4507, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BYRAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 14558, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "ROBERT", "last_name": "FROST", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 21536, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 32874, "prefix": null, "prefix_display": null, "first_name": "SONIA", "nickname": null, "middle_name": null, "last_name": "KANDATHIL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 43543, "prefix": "ms", "prefix_display": "MS.", "first_name": "MONICA", "nickname": null, "middle_name": "SUSANNE", "last_name": "RUIZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}], "government_entities": [{"id": 300, "name": "UNDETERMINED"}]}, {"general_issue_code": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "FY2007 Appropriations: HR 5647, Labor/HHS/Education Appropriations\r\n- increased funding for medical research, National Institutes of Health and other Public Health Services\r\n- against funding for abstinence only programs\r\n- supported peer review system at NIH /opposed efforts to cancel funding for specific grants\r\n- NIH Reauthorization: supported maintaining the authorities of OAR and the peer review system", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 4507, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BYRAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 14558, "prefix": null, "prefix_display": null, "first_name": "KEVIN", "nickname": null, "middle_name": "ROBERT", "last_name": "FROST", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 21536, "prefix": null, "prefix_display": null, "first_name": "JUDITH", "nickname": null, "middle_name": null, "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 32874, "prefix": null, "prefix_display": null, "first_name": "SONIA", "nickname": null, "middle_name": null, "last_name": "KANDATHIL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}, {"lobbyist": {"id": 43543, "prefix": "ms", "prefix_display": "MS.", "first_name": "MONICA", "nickname": null, "middle_name": "SUSANNE", "last_name": "RUIZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": null}], "government_entities": [{"id": 300, "name": "UNDETERMINED"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 33487 NY NY US US   0 0           160000.0

Links from other tables