home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e7d63d86-ee61-4dc3-a3aa-e29f4d3dfc86

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
e7d63d86-ee61-4dc3-a3aa-e29f4d3dfc86 Q1 310973 APOTEX CORP. 183737 APOTEX CORP. 2010 first_quarter 2010-04-19T14:40:28.737000-04:00 130000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e7d63d86-ee61-4dc3-a3aa-e29f4d3dfc86/", "filing_uuid": "e7d63d86-ee61-4dc3-a3aa-e29f4d3dfc86", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2010, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e7d63d86-ee61-4dc3-a3aa-e29f4d3dfc86/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "130000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Steve Giuli, Director of Government Affairs & Industry Relations", "dt_posted": "2010-04-19T14:40:28.737000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2400 N. COMMERCE PARKWAY", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WESTON", "registrant_state": "FL", "registrant_zip": "33326", "registrant": {"id": 310973, "url": "https://lda.senate.gov/api/v1/registrants/310973/", "house_registrant_id": 38623, "name": "APOTEX CORP.", "description": "Generic pharmaceutical manufacturer", "address_1": "2400 N. COMMERCE PARKWAY", "address_2": null, "address_3": null, "address_4": null, "city": "WESTON", "state": "FL", "state_display": "Florida", "zip": "33326", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STEVE GIULI", "contact_telephone": "+1 954-384-8007", "dt_updated": "2026-01-30T15:29:14.471073-05:00"}, "client": {"id": 183737, "url": "https://lda.senate.gov/api/v1/clients/183737/", "client_id": 12, "name": "APOTEX CORP.", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "FL", "state_display": "Florida", "country": "US", "country_display": "United States of America", "ppb_state": "FL", "ppb_state_display": "Florida", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2006-07-20"}, "lobbying_activities": [{"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "S. 369, the Preserve Access to Affordable Pharmaceuticals Act\nS. 1315, the Drug Price Competition Act of 2009\nH.R. 3777, the Drug Price Competition Act of 2009\nH.R. 3962, Affordable Health Care for America Act, Section 2573, Protecting Consumer Access to Generic Drugs Act H.R. 3962, Affordable Heatlh Care for America Act, Section 2375, Licensure Pathway for Biosimilar Products\nH.R. 3590, the Patient Protection and Affordable Care Act, Title VII, Subtitle A, Biologics Price Competition and Innovation\nH.R. 4872, the Health Care and Education Reconciliation Act of 2010 pertaining to patent settlements between brand and generic pharmaceutical manufacturers", "foreign_entity_issues": "ApoSherm Inc., the parent company of Apotex Corp., has direct or indirect ownership interests in companies that develop, manufacture, and/or sell generic drugs, and therefore has an interest in the issues identified in this report", "lobbyists": [{"lobbyist": {"id": 41476, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "GIULI", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 1 row from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 15.07ms