lobbying_filings_raw: 0d06815e-264c-4d35-a30b-e5d4f4383ba2

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 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
0d06815e-264c-4d35-a30b-e5d4f4383ba2 MM 18422 HOGAN LOVELLS US LLP 124269 YM BIOSCIENCES USA INC 2007 mid_year 2007-08-08T10:45:24-04:00   0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0d06815e-264c-4d35-a30b-e5d4f4383ba2/", "filing_uuid": "0d06815e-264c-4d35-a30b-e5d4f4383ba2", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2007, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0d06815e-264c-4d35-a30b-e5d4f4383ba2/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-08-08T10:45:24-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": 18422, "url": "https://lda.senate.gov/api/v1/registrants/18422/", "house_registrant_id": 30470, "name": "HOGAN LOVELLS US LLP", "description": "Law Firm", "address_1": "COLUMBIA SQUARE", "address_2": "555 THIRTEENTH STREET NW", "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": "AARON CUTLER", "contact_telephone": "+1 202-637-5648", "dt_updated": "2026-01-21T15:33:00.526139-05:00"}, "client": {"id": 124269, "url": "https://lda.senate.gov/api/v1/clients/124269/", "client_id": 6523, "name": "YM BIOSCIENCES USA INC", "general_description": "Cancer product development company", "client_government_entity": false, "client_self_select": false, "state": null, "state_display": null, "country": "DE", "country_display": "Germany", "ppb_state": null, "ppb_state_display": null, "ppb_country": "DE", "ppb_country_display": "Germany", "effective_date": "2007-08-08"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "To assist in obtaining Hill support for a license pending before the US Treasury Department Office of Foreign Assets Control (OFAC) for client to import foreign origin vaccines and drugs to be used in clinical trials to treat solid tumor cancers", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5602, "prefix": "mr", "prefix_display": "MR.", "first_name": "HP", "nickname": null, "middle_name": null, "last_name": "GOLDFIELD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "To assist in obtaining Hill support for a license application pending before the US Treasury Department Office of Foreign Assets Control (OFAC) for client to import foreign origin vaccines and drugs to be used in clinical trials to treat solid tumor cancers", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 5602, "prefix": "mr", "prefix_display": "MR.", "first_name": "HP", "nickname": null, "middle_name": null, "last_name": "GOLDFIELD", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30470     DE DE Cancer product development company 0 0        

Links from other tables