lobbying_filings_raw: d6b8d5b9-9d3f-4e10-9d00-3a2d07b60e80

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.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
d6b8d5b9-9d3f-4e10-9d00-3a2d07b60e80 Q1 401103251 GOVERNMENT SOLUTIONS LLC 58328 OTSUKA AMERICA PHARMACEUTICAL, INC. 2025 first_quarter 2025-04-06T18:03:19-04:00 30000.0 0 0 0 {"url": "https://lda.gov/api/v1/filings/d6b8d5b9-9d3f-4e10-9d00-3a2d07b60e80/", "filing_uuid": "d6b8d5b9-9d3f-4e10-9d00-3a2d07b60e80", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2025, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/d6b8d5b9-9d3f-4e10-9d00-3a2d07b60e80/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Bert Steele", "dt_posted": "2025-04-06T18:03:19-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1455 PENNSYLVANIA AVE, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 401103251, "url": "https://lda.gov/api/v1/registrants/401103251/", "house_registrant_id": null, "name": "GOVERNMENT SOLUTIONS LLC", "description": "Strategic consulting and advocacy", "address_1": "1455 PENNSYLVANIA AVE, NW", "address_2": null, "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": "BERT STEELE", "contact_telephone": "+1 202-256-5505", "dt_updated": "2026-01-20T10:12:38.757396-05:00"}, "client": {"id": 58328, "url": "https://lda.gov/api/v1/clients/58328/", "client_id": 58328, "name": "OTSUKA AMERICA PHARMACEUTICAL, INC.", "general_description": "Healthcare and Pharmaceutical", "client_government_entity": null, "client_self_select": false, "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": "2023-12-20"}, "lobbying_activities": [{"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "Veterans Affairs, Mental Health, and Posttraumatic stress disorder (PTSD). Specifically, health care policies relating to mental health and PTSD. Veterans Affairs authorizations and appropriations issues related to mental health and PTSD.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60439, "prefix": null, "prefix_display": null, "first_name": "BERT", "nickname": null, "middle_name": null, "last_name": "STEELE", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "Mental Health, Brain Health, and Posttraumatic stress disorder (PTSD). Specifically, health care policies relating to mental health and PTSD. Federal authorizations and appropriations issues related to mental health and PTSD.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60439, "prefix": null, "prefix_display": null, "first_name": "BERT", "nickname": null, "middle_name": null, "last_name": "STEELE", "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": "DEF", "general_issue_code_display": "Defense", "description": "Military Health Care, Mental Health, and Posttraumatic stress disorder (PTSD). Specifically, health care policies relating to mental health and PTSD. Defense authorizations and appropriations issues related to mental health and PTSD.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60439, "prefix": null, "prefix_display": null, "first_name": "BERT", "nickname": null, "middle_name": null, "last_name": "STEELE", "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": []}

Links from other tables