home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 19f18b81-ce4d-4718-9f55-7bc890bcccc7

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
19f18b81-ce4d-4718-9f55-7bc890bcccc7 1T 40026226 CUBIST PHARMACEUTICALS, INC. 188177 CUBIST PHARMACEUTICALS 2015 first_quarter 2015-02-02T17:43:37.717000-05:00   0 0 1 {"url": "https://lda.senate.gov/api/v1/filings/19f18b81-ce4d-4718-9f55-7bc890bcccc7/", "filing_uuid": "19f18b81-ce4d-4718-9f55-7bc890bcccc7", "filing_type": "1T", "filing_type_display": "1st Quarter - Termination", "filing_year": 2015, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/19f18b81-ce4d-4718-9f55-7bc890bcccc7/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Mary Hogan", "dt_posted": "2015-02-02T17:43:37.717000-05:00", "termination_date": "2015-01-22", "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "65 Hayden Avenue", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Lexington", "registrant_state": "MA", "registrant_zip": "02421", "registrant": {"id": 40026226, "url": "https://lda.senate.gov/api/v1/registrants/40026226/", "house_registrant_id": 39875, "name": "CUBIST PHARMACEUTICALS, INC.", "description": "pharmaceutical company", "address_1": "65 Hayden Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Lexington", "state": "MA", "state_display": "Massachusetts", "zip": "02421", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MARK BATTAGLINI", "contact_telephone": "+1 781-860-8660", "dt_updated": "2022-04-06T16:06:43.954054-04:00"}, "client": {"id": 188177, "url": "https://lda.senate.gov/api/v1/clients/188177/", "client_id": 75, "name": "CUBIST PHARMACEUTICALS", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "MA", "state_display": "Massachusetts", "country": "US", "country_display": "United States of America", "ppb_state": "MA", "ppb_state_display": "Massachusetts", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-02-18"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Developing an Innovative Strategy for Antimicrobial Resistant Microorganisms (DISARM)Act; Ongoing discussions surrounding next steps for protecting and promoting incentives for the development of resistant pathogens including breakpoints, andtibiotic resistance, reimbursement issues for antibiotics, President's Council of Advisors on Science and Technology (PCSAT)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44486, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARK", "nickname": null, "middle_name": "THOMAS", "last_name": "BATTAGLINI", "suffix": "esq", "suffix_display": "ESQ"}, "covered_position": null, "new": false}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}]}], "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 12.246ms