lobbying_filings_raw: 91b075d2-d59d-4f83-ab2a-9599cdebf2c8

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
91b075d2-d59d-4f83-ab2a-9599cdebf2c8 Q2 400865535 FORGE FEDERAL AFFAIRS LLC 195746 LILLY USA LLC 2017 second_quarter 2017-07-19T12:19:53.483000-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/91b075d2-d59d-4f83-ab2a-9599cdebf2c8/", "filing_uuid": "91b075d2-d59d-4f83-ab2a-9599cdebf2c8", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/91b075d2-d59d-4f83-ab2a-9599cdebf2c8/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Julian Anthony Haywood", "dt_posted": "2017-07-19T12:19:53.483000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "300 New Jersey Avenue, NW", "registrant_address_2": "Suite 900", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 400865535, "url": "https://lda.senate.gov/api/v1/registrants/400865535/", "house_registrant_id": null, "name": "FORGE FEDERAL AFFAIRS LLC", "description": "lobbying firm", "address_1": "300 New Jersey Avenue, NW", "address_2": "Suite 900", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JULIAN ANTHONY HAYWOOD", "contact_telephone": "+1 202-827-2006", "dt_updated": "2022-04-06T16:07:29.996058-04:00"}, "client": {"id": 195746, "url": "https://lda.senate.gov/api/v1/clients/195746/", "client_id": 24, "name": "LILLY USA LLC", "general_description": "develops products and devices for diabetes care", "client_government_entity": false, "client_self_select": false, "state": "IN", "state_display": "Indiana", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2012-03-06"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Issues related to Medicare Part D reform proposals in budget and health care reform proposals.\nH.R.1628, American Health Care Act of 2017/Better Care Reconciliation Act of 2017.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55941, "prefix": null, "prefix_display": null, "first_name": "JULIAN", "nickname": null, "middle_name": "A", "last_name": "HAYWOOD", "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": "PHA", "general_issue_code_display": "Pharmacy", "description": "Issues related to pricing of prescription drugs. \nOpposition to prescription drug importation. \nSupport for funding of Department of Homeland Security drug interdiction efforts. \nIssues related to reauthorization of the Prescription Drug User Fee Act. \nH.R.2430/S.934, FDA Reauthorization Act of 2017.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55941, "prefix": null, "prefix_display": null, "first_name": "JULIAN", "nickname": null, "middle_name": "A", "last_name": "HAYWOOD", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Monitored issues related to taxation of offshore revenue and corporate tax reform.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55941, "prefix": null, "prefix_display": null, "first_name": "JULIAN", "nickname": null, "middle_name": "A", "last_name": "HAYWOOD", "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   IN   US US develops products and devices for diabetes care 0 0        

Links from other tables