home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 5900ddeb-1fdb-42d2-b397-42ce46bb024e

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
5900ddeb-1fdb-42d2-b397-42ce46bb024e Q1 39837 VAN SCOYOC ASSOCIATES 148615 UPFIELD US INC. 2020 first_quarter 2020-04-17T05:23:37.227000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/5900ddeb-1fdb-42d2-b397-42ce46bb024e/", "filing_uuid": "5900ddeb-1fdb-42d2-b397-42ce46bb024e", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2020, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/5900ddeb-1fdb-42d2-b397-42ce46bb024e/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Shannon Campagna, Vice President", "dt_posted": "2020-04-17T05:23:37.227000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "800 Maine Avenue, SW", "registrant_address_2": "Suite 800", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20024", "registrant": {"id": 39837, "url": "https://lda.senate.gov/api/v1/registrants/39837/", "house_registrant_id": 32802, "name": "VAN SCOYOC ASSOCIATES", "description": "Government Relations Consultant", "address_1": "800 Maine Avenue, SW", "address_2": "Suite 800", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20024", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "H. STEWART VAN SCOYOC", "contact_telephone": "+1 202-638-1950", "dt_updated": "2026-01-30T16:27:15.999039-05:00"}, "client": {"id": 148615, "url": "https://lda.senate.gov/api/v1/clients/148615/", "client_id": 1009001, "name": "UPFIELD US INC.", "general_description": "Manufacturer of Plant-Based Foods", "client_government_entity": false, "client_self_select": null, "state": "NJ", "state_display": "New Jersey", "country": "US", "country_display": "United States of America", "ppb_state": "NJ", "ppb_state_display": "New Jersey", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2019-02-04"}, "lobbying_activities": [{"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Monitor Economic development opportunities, generally", "foreign_entity_issues": "The foreign entities, Upfield Group B.V., Sigma Holdco B.V., Sigma Investco B.V., Sigma Interco B.V., Sigma Topco B.V., Sigma Luxco S. a.r.l., have the same interest in the outcome of item #16 as client Upfield US Inc.", "lobbyists": [{"lobbyist": {"id": 70060, "prefix": null, "prefix_display": null, "first_name": "SHANNON", "nickname": null, "middle_name": null, "last_name": "CAMPAGNA", "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": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "U.S. Food and Drug Administration, Food labeling related matters\n\nH.R.1769/S.792, Defending Against Imitations and Replacements of Yogurt, Milk, and Cheese To Promote Regular Intake of Dairy Everyday (DAIRY PRIDE) Act, generally\n\nH.R.4881/S.3016, Real Marketing Edible Artificials Truthfully Act of 2019, generally\n\nCOVID-19 Employee Health and Safety related issues", "foreign_entity_issues": "The foreign entities, Upfield Group B.V., Sigma Holdco B.V., Sigma Investco B.V., Sigma Interco B.V., Sigma Topco B.V., Sigma Luxco S. a.r.l., have the same interest in the outcome of item #16 as client Upfield US Inc.", "lobbyists": [{"lobbyist": {"id": 70060, "prefix": null, "prefix_display": null, "first_name": "SHANNON", "nickname": null, "middle_name": null, "last_name": "CAMPAGNA", "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": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 1.461ms