home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cd18eea3-2d5d-4cbf-a705-2d9af507bbc6

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
cd18eea3-2d5d-4cbf-a705-2d9af507bbc6 Q2 10503 SANOFI PASTEUR, INC. (FORMERLY AVENTIS PASTEUR) 114351 SANOFI PASTEUR INC (FORMERLY AVENTIS PASTEUR) 2010 second_quarter 2010-07-16T11:55:14.497000-04:00 630000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cd18eea3-2d5d-4cbf-a705-2d9af507bbc6/", "filing_uuid": "cd18eea3-2d5d-4cbf-a705-2d9af507bbc6", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2010, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cd18eea3-2d5d-4cbf-a705-2d9af507bbc6/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "630000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Ronald M. Jacobs, Counsel", "dt_posted": "2010-07-16T11:55:14.497000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "801 PENNSYLVANIA AVE NW #730", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 10503, "url": "https://lda.senate.gov/api/v1/registrants/10503/", "house_registrant_id": 30841, "name": "SANOFI PASTEUR, INC. (FORMERLY AVENTIS PASTEUR)", "description": null, "address_1": "801 PENNSYLVANIA AVE NW #725", "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": "SEAN CALLINICOS", "contact_telephone": "", "dt_updated": "2022-04-06T16:04:36.358024-04:00"}, "client": {"id": 114351, "url": "https://lda.senate.gov/api/v1/clients/114351/", "client_id": 12, "name": "SANOFI PASTEUR INC (FORMERLY AVENTIS PASTEUR)", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Patent reform issues Sean Callinicos: Staff Director and Chief Counsel, Senate Environment and Public Works Committee, Subcommittee on Clean Air and Nuclear Safety; General Counsel, Senator Lauch Faircloth.", "foreign_entity_issues": "Sanofi-Aventis Group has an interest in this legislation due to the potential impact on their U.S. business.", "lobbyists": [{"lobbyist": {"id": 15354, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "CALLINICOS", "suffix": null, "suffix_display": null}, "covered_position": "See Addendum", "new": false}, {"lobbyist": {"id": 40095, "prefix": null, "prefix_display": null, "first_name": "AMY", "nickname": null, "middle_name": "L", "last_name": "REDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44809, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "MARYANNE", "nickname": null, "middle_name": "DOLBEARE", "last_name": "DUNLAP", "suffix": null, "suffix_display": null}, "covered_position": "Staff Senate Env. & Pub. Works Committee", "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Vaccine-related legislation, advance market commitments, and other issues Sean Callinicos: Staff Director and Chief Counsel, Senate Environment and Public Works Committee, Subcommittee on Clean Air and Nuclear Safety; General Counsel, Senator Lauch Faircloth.", "foreign_entity_issues": "Sanofi-Aventis Group has an interest in this legislation due to the potential impact on their U.S. business.", "lobbyists": [{"lobbyist": {"id": 15354, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "CALLINICOS", "suffix": null, "suffix_display": null}, "covered_position": "See Addendum", "new": false}, {"lobbyist": {"id": 40095, "prefix": null, "prefix_display": null, "first_name": "AMY", "nickname": null, "middle_name": "L", "last_name": "REDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44809, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "MARYANNE", "nickname": null, "middle_name": "DOLBEARE", "last_name": "DUNLAP", "suffix": null, "suffix_display": null}, "covered_position": "Staff Senate Env. & Pub. Works Committee", "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Legislation and other issues involving vaccine taxes and children's health, vaccine-related issues with respect to Medicaid and Medicare, and vaccine-related general tax issues. Sean Callinicos: Staff Director and Chief Counsel, Senate Environment and Public Works Committee, Subcommittee on Clean Air and Nuclear Safety; General Counsel, Senator Lauch Faircloth.", "foreign_entity_issues": "Sanofi-Aventis Group has an interest in this legislation due to the potential impact on their U.S. business.", "lobbyists": [{"lobbyist": {"id": 15354, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "CALLINICOS", "suffix": null, "suffix_display": null}, "covered_position": "See Addendum", "new": false}, {"lobbyist": {"id": 40095, "prefix": null, "prefix_display": null, "first_name": "AMY", "nickname": null, "middle_name": "L", "last_name": "REDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44809, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "MARYANNE", "nickname": null, "middle_name": "DOLBEARE", "last_name": "DUNLAP", "suffix": null, "suffix_display": null}, "covered_position": "Staff Senate Env. & Pub. Works Committee", "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Vaccine and generic biological issues and related appropriation issues, including vaccines for children, pandemic concerns, influenza vaccine issues, stockpile, bioterrorism, bioterrorism countermeasures, vaccine injury compensation programs, vaccine safety, and FDA and CDC funding; health care reform legislation as it pertains to vaccines, including America's Affordable Health Choices Act (HR 3200), the Affordable Health Choices Act (S 1679), and the America's Healthy Future Act (Sen Finance). Sean Callinicos: Staff Director and Chief Counsel, Senate Environment and Public Works Committee, Subcommittee on Clean Air and Nuclear Safety; General Counsel, Senator Lauch Faircloth.", "foreign_entity_issues": "Sanofi-Aventis Group has an interest in this legislation due to the potential impact on their U.S. business.", "lobbyists": [{"lobbyist": {"id": 15354, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "CALLINICOS", "suffix": null, "suffix_display": null}, "covered_position": "See Addendum", "new": false}, {"lobbyist": {"id": 40095, "prefix": null, "prefix_display": null, "first_name": "AMY", "nickname": null, "middle_name": "L", "last_name": "REDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44809, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "MARYANNE", "nickname": null, "middle_name": "DOLBEARE", "last_name": "DUNLAP", "suffix": null, "suffix_display": null}, "covered_position": "Staff Senate Env. & Pub. Works Committee", "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Vaccine related Medicare and Medicaid issues, including those arising from health care reform legislation. Sean Callinicos: Staff Director and Chief Counsel, Senate Environment and Public Works Committee, Subcommittee on Clean Air and Nuclear Safety; General Counsel, Senator Lauch Faircloth.", "foreign_entity_issues": "Sanofi-Aventis Group has an interest in this legislation due to the potential impact on their U.S. business.", "lobbyists": [{"lobbyist": {"id": 15354, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "CALLINICOS", "suffix": null, "suffix_display": null}, "covered_position": "See Addendum", "new": false}, {"lobbyist": {"id": 40095, "prefix": null, "prefix_display": null, "first_name": "AMY", "nickname": null, "middle_name": "L", "last_name": "REDL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44809, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "MARYANNE", "nickname": null, "middle_name": "DOLBEARE", "last_name": "DUNLAP", "suffix": null, "suffix_display": null}, "covered_position": "Staff Senate Env. & Pub. Works Committee", "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30841 DC DC US US   0 0 2071448   normalized_name_dc_fallback 0.8

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 1.066ms