home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f0c970ea-c93a-4f80-800c-1b3fd2cae1fa

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
f0c970ea-c93a-4f80-800c-1b3fd2cae1fa Q1 29037 NESTLE USA 134649 NESTLE USA 2026 first_quarter 2026-04-14T12:03:16-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/f0c970ea-c93a-4f80-800c-1b3fd2cae1fa/", "filing_uuid": "f0c970ea-c93a-4f80-800c-1b3fd2cae1fa", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2026, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/f0c970ea-c93a-4f80-800c-1b3fd2cae1fa/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "470325.40", "expenses_method": "C", "expenses_method_display": "C", "posted_by_name": "Kaitlyn Brown", "dt_posted": "2026-04-14T12:03:16-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1812 N. Moore Street", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Arlington", "registrant_state": "VA", "registrant_zip": "22204", "registrant": {"id": 29037, "url": "https://lda.gov/api/v1/registrants/29037/", "house_registrant_id": 31429, "name": "NESTLE USA", "description": null, "address_1": "505 9TH STREET NW, SUITE 600", "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": "HANNA ABOU-EL-SEOUD", "contact_telephone": "+1 202-294-2319", "dt_updated": "2026-07-22T07:42:29.081097-04:00"}, "client": {"id": 134649, "url": "https://lda.gov/api/v1/clients/134649/", "client_id": 12, "name": "NESTLE USA", "general_description": "food and beverage manufacturing", "client_government_entity": false, "client_self_select": true, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-06"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Inform Congress and Administration on impact of tariff and trade policy to food and beverage industry from tariffs on Canada, Mexico and other countries.", "foreign_entity_issues": "To the degree that public policies benefit Nestle USA, so too will its parent company, Nestle S.A., benefit.", "lobbyists": [{"lobbyist": {"id": 86804, "prefix": null, "prefix_display": null, "first_name": "HANNA", "nickname": null, "middle_name": null, "last_name": "ABOU-EL-SEOUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 140309, "prefix": null, "prefix_display": null, "first_name": "KAITLYN", "nickname": null, "middle_name": null, "last_name": "BROWN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "Informed Congress and Administration on ingredients and additives ban, proposals to label food, beverage and medical foods. Discussed importance of maintaining feeding programs within the Farm Bill including SNAP. Support for the Dietary Supplements Act. Support for the Pet Food Uniform Regulatory Reform Act (PURR Act)", "foreign_entity_issues": "To the degree that public policies benefit Nestle, so too will its parent company, Nestle SA, benefit.", "lobbyists": [{"lobbyist": {"id": 143061, "prefix": "ms", "prefix_display": "MS.", "first_name": "EMMA", "nickname": null, "middle_name": "LEE", "last_name": "BRYAN", "suffix": null, "suffix_display": null}, "covered_position": "Senator Joe Manchin legislative assistance Nov 2017-Jan 2023", "new": true}, {"lobbyist": {"id": 100616, "prefix": null, "prefix_display": null, "first_name": "MEGAN", "nickname": null, "middle_name": null, "last_name": "VILLARREAL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 147536, "prefix": null, "prefix_display": null, "first_name": "MORGAN", "nickname": null, "middle_name": null, "last_name": "BEACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 153342, "prefix": null, "prefix_display": null, "first_name": "JACOB", "nickname": null, "middle_name": null, "last_name": "OPPLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Supported conservation and wetlands restoration advocacy specifically targeted to the Farm Bill. Nestle advocates for continued federal investment in climate activities.Inform nationwide EPR framework discussion, recycling infrastructure investment, and general federal action to reduce patchwork of state regulatory oversight", "foreign_entity_issues": "To the degree that public policies benefit Nestle, so too will its parent company, Nestle SA, benefit.", "lobbyists": [{"lobbyist": {"id": 100616, "prefix": null, "prefix_display": null, "first_name": "MEGAN", "nickname": null, "middle_name": null, "last_name": "VILLARREAL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 144929, "prefix": null, "prefix_display": null, "first_name": "COLBY", "nickname": null, "middle_name": null, "last_name": "SHOLLER", "suffix": null, "suffix_display": null}, "covered_position": "Office of Sen. Scott Brown (R-MA) - September 2011 - March 2012 Senate Homeland Security and Governmental Affairs Committee - March 2012 - March 2013 U.S. Agency for International Development: March 2013 - May 2017", "new": true}, {"lobbyist": {"id": 153342, "prefix": null, "prefix_display": null, "first_name": "JACOB", "nickname": null, "middle_name": null, "last_name": "OPPLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "Support full enactment of the Paws Assisting Veterans (PAWS Act).", "foreign_entity_issues": "To the degree that public policies benefit Nestle USA, so too will its parent company, Nestle S.A., benefit.", "lobbyists": [{"lobbyist": {"id": 100616, "prefix": null, "prefix_display": null, "first_name": "MEGAN", "nickname": null, "middle_name": null, "last_name": "VILLARREAL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 147536, "prefix": null, "prefix_display": null, "first_name": "MORGAN", "nickname": null, "middle_name": null, "last_name": "BEACH", "suffix": null, "suffix_display": null}, "covered_position": "U.S. House of Representatives Congressman David Valadao Legislative Research Assistance Aug. 2016-Dec. 2016", "new": true}, {"lobbyist": {"id": 140309, "prefix": null, "prefix_display": null, "first_name": "KAITLYN", "nickname": null, "middle_name": null, "last_name": "BROWN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Monitor Congressional and Administrative action impacting labor and workforce.", "foreign_entity_issues": "To the degree that public policies benefit Nestle USA, so too will its parent company, Nestle S.A., benefit.", "lobbyists": [{"lobbyist": {"id": 140309, "prefix": null, "prefix_display": null, "first_name": "KAITLYN", "nickname": null, "middle_name": null, "last_name": "BROWN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 86804, "prefix": null, "prefix_display": null, "first_name": "HANNA", "nickname": null, "middle_name": null, "last_name": "ABOU-EL-SEOUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 38, "name": "Labor, Dept of (DOL)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Support extension of various TCJA provisions. Inform Congress and Administration on impacts of OECD Pillar 2.", "foreign_entity_issues": "To the degree that public policies benefit Nestle USA, so too will its parent company, Nestle S.A., benefit.", "lobbyists": [{"lobbyist": {"id": 86804, "prefix": null, "prefix_display": null, "first_name": "HANNA", "nickname": null, "middle_name": null, "last_name": "ABOU-EL-SEOUD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 144929, "prefix": null, "prefix_display": null, "first_name": "COLBY", "nickname": null, "middle_name": null, "last_name": "SHOLLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31429 VA VA US US food and beverage manufacturing 0 0           470325.4

Links from other tables

  • 36 rows from filing_uuid in lobbying_activities
  • 42 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.37ms · Privacy