home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4e9d875c-19b0-41fc-93fc-5a2e2fa348c0

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
4e9d875c-19b0-41fc-93fc-5a2e2fa348c0 Q1 12208 DICKSTEIN SHAPIRO LLP 117024 BAYER CORPORATION 2014 first_quarter 2014-04-21T22:13:30.297000-04:00 90000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4e9d875c-19b0-41fc-93fc-5a2e2fa348c0/", "filing_uuid": "4e9d875c-19b0-41fc-93fc-5a2e2fa348c0", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2014, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4e9d875c-19b0-41fc-93fc-5a2e2fa348c0/print/", "filing_document_content_type": "text/html", "income": "90000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "L. Andrew Zausner, partner", "dt_posted": "2014-04-21T22:13:30.297000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1825 Eye St., NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 12208, "url": "https://lda.senate.gov/api/v1/registrants/12208/", "house_registrant_id": 31737, "name": "DICKSTEIN SHAPIRO LLP", "description": "Law firm", "address_1": "1825 Eye Street NW", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "SCOTT THOMAS", "contact_telephone": "+1 202-420-2200", "dt_updated": "2022-04-06T16:07:57.938885-04:00"}, "client": {"id": 117024, "url": "https://lda.senate.gov/api/v1/clients/117024/", "client_id": 1005154, "name": "BAYER CORPORATION", "general_description": "Health care, crop science and high performance materials, products, and services.", "client_government_entity": false, "client_self_select": null, "state": "PA", "state_display": "Pennsylvania", "country": "US", "country_display": "United States of America", "ppb_state": "PA", "ppb_state_display": "Pennsylvania", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2014-02-01"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Monitor legislative and administrative action related to trade promotion authority negotiations.\nMonitor legislative and administrative action related to Trans-Pacific Partnerships.\nMonitor legislative and administrative action related to Transatlantic Trade and Investment Partnership.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10806, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "MANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2581, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "SHULMAN SCHWARTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60377, "prefix": null, "prefix_display": null, "first_name": "MONICA", "nickname": null, "middle_name": null, "last_name": "SCHUTLEIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41002, "prefix": null, "prefix_display": null, "first_name": "K", "nickname": null, "middle_name": "LAURIE", "last_name": "MCKAY", "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": "AGR", "general_issue_code_display": "Agriculture", "description": "Monitor implementation of the Agricultural Act of 2014 (P.L. 113-79). \nMonitor passage of FY 2014 omnibus appropriations bill (P.L. 113-76).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10806, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "MANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2581, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "SHULMAN SCHWARTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60377, "prefix": null, "prefix_display": null, "first_name": "MONICA", "nickname": null, "middle_name": null, "last_name": "SCHUTLEIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41002, "prefix": null, "prefix_display": null, "first_name": "K", "nickname": null, "middle_name": "LAURIE", "last_name": "MCKAY", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "Monitor legislative and administrative action related to health care policy.\nMonitor legislative and administrative action related to drug user fees.\nMonitor legislative and administrative action related to sustainable growth rate and SGR repeal. \nMonitor the implementation of the Patient Protection and Affordable Care Act, P.L. 111-148.Monitor passage of FY 2014 omnibus appropriations bill (P.L. 113-76).\nH.R. 2810, Medicare Patient Access and Quality Improvement Act of 2013. \nH.R. 4302, Protecting Access to Medicare Act. \nS. 1871, SGR Repeal and Medicare Beneficiary Access Act of 2013.\nDraft, House Departments of Labor, Health and Human Services and Related Agencies Appropriations Act, 2015.\nDraft, Senate Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2015.\nDraft, House tax extender legislation.\nDraft, Senate tax extender legislation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10806, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "MANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2581, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "SHULMAN SCHWARTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60377, "prefix": null, "prefix_display": null, "first_name": "MONICA", "nickname": null, "middle_name": null, "last_name": "SCHUTLEIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41002, "prefix": null, "prefix_display": null, "first_name": "K", "nickname": null, "middle_name": "LAURIE", "last_name": "MCKAY", "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": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Monitor federal issues and legislation associated with chemical facilities regulation.\nMonitor passage and implementation of FY 2014 omnibus appropriations bill (P.L. 113-76).\nMonitor legislative action related to the Toxic Substances Control Act.H.R. 3080, Water Resources Reform and Development Act of 2013.\nS. 601, Water Resources Development Act of 2013.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41002, "prefix": null, "prefix_display": null, "first_name": "K", "nickname": null, "middle_name": "LAURIE", "last_name": "MCKAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10806, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "MANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2581, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "SHULMAN SCHWARTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60377, "prefix": null, "prefix_display": null, "first_name": "MONICA", "nickname": null, "middle_name": null, "last_name": "SCHUTLEIS", "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": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "Monitor federal issues and legislation associated with chemical facilities regulation.\nMonitor passage of FY 2014 omnibus appropriations bill (P.L. 113-76).\nMonitor legislative action related to the Toxic Substances Control Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10806, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "MANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2581, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "SHULMAN SCHWARTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60377, "prefix": null, "prefix_display": null, "first_name": "MONICA", "nickname": null, "middle_name": null, "last_name": "SCHUTLEIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41002, "prefix": null, "prefix_display": null, "first_name": "K", "nickname": null, "middle_name": "LAURIE", "last_name": "MCKAY", "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": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Monitor legislative and administrative action related to energy efficiency and energy technology.\nS. 761, Energy Savings and Industrial Competitiveness Act of 2013.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10806, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "MANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2581, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "SHULMAN SCHWARTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60377, "prefix": null, "prefix_display": null, "first_name": "MONICA", "nickname": null, "middle_name": null, "last_name": "SCHUTLEIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41002, "prefix": null, "prefix_display": null, "first_name": "K", "nickname": null, "middle_name": "LAURIE", "last_name": "MCKAY", "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": "TAR", "general_issue_code_display": "Tariff (miscellaneous tariff bills)", "description": "Monitor legislative and administrative action related to miscellaneous tariff legislation.\nH.R. 2708, To amend the Harmonized Tariff Schedule of the United States to modify temporarily certain rates of duty, and for other purposes.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 9662, "prefix": null, "prefix_display": null, "first_name": "TIM", "nickname": null, "middle_name": null, "last_name": "HUTCHINSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 10806, "prefix": "mr", "prefix_display": "MR.", "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "MANGAS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48153, "prefix": null, "prefix_display": null, "first_name": "ALBERT", "nickname": null, "middle_name": null, "last_name": "WYNN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 4531, "prefix": null, "prefix_display": null, "first_name": "GRAHAM", "nickname": null, "middle_name": null, "last_name": "MATHEWS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2581, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "SHULMAN SCHWARTZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60377, "prefix": null, "prefix_display": null, "first_name": "MONICA", "nickname": null, "middle_name": null, "last_name": "SCHUTLEIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41002, "prefix": null, "prefix_display": null, "first_name": "K", "nickname": null, "middle_name": "LAURIE", "last_name": "MCKAY", "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 31737 PA PA US US Health care, crop science and high performance materials, products, and services. 0 0 2088445   normalized_name 0.7

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 7 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 1.166ms