home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c1eacfb1-e89b-4d3c-8295-7aaa386ef05c

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
c1eacfb1-e89b-4d3c-8295-7aaa386ef05c Q1 39837 VAN SCOYOC ASSOCIATES 148370 UNIVERSITY OF NEW HAMPSHIRE 2014 first_quarter 2014-04-17T06:58:51.037000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c1eacfb1-e89b-4d3c-8295-7aaa386ef05c/", "filing_uuid": "c1eacfb1-e89b-4d3c-8295-7aaa386ef05c", "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/c1eacfb1-e89b-4d3c-8295-7aaa386ef05c/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Thomas L. Lankford", "dt_posted": "2014-04-17T06:58:51.037000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "101 Constitution Avenue, NW", "registrant_address_2": "Suite 600 West", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "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": 148370, "url": "https://lda.senate.gov/api/v1/clients/148370/", "client_id": 1006587, "name": "UNIVERSITY OF NEW HAMPSHIRE", "general_description": "University", "client_government_entity": true, "client_self_select": false, "state": "NH", "state_display": "New Hampshire", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2010-01-01"}, "lobbying_activities": [{"general_issue_code": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "Commerce, Justice, Science, and Related Agencies Appropriations Act, FY2015, Joint hydrographic research program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29284, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "L", "last_name": "LANKFORD", "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 the following:\n\nRadiation detection technology\n\nOil spill related issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29284, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "L", "last_name": "LANKFORD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 54682, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "MATTHEW", "last_name": "BERNIER", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Water resources issues generally", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54682, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "MATTHEW", "last_name": "BERNIER", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "National Defense Authorization Act of Fiscal Year 2015, Sexual harassment, assault analysis, training support and policy issues; Turbulence research; Anti-Submarine Warfare technology research issues.\n\nMonitor radiation detection technology generally", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29284, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "L", "last_name": "LANKFORD", "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": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "H.R.3309/S.1720, Patent Transparency and Improvements Act of 2013, Intellectual Property issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29284, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "L", "last_name": "LANKFORD", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, FY2015, EPSCoR related issues.\n\nCommerce, Justice, Science, and Related Agencies Appropriations Act, FY2015, Child Victimization research and analysis NASA MMS; Helio physics program issues; and Joint hydrographic research program.\n\nDepartments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, FY2015, IDeA program issues.\n\nNational Defense Authorization Act of Fiscal Year 2015, Sexual harassment, assault analysis, training support and policy issues; Turbulence research; Anti-Submarine Warfare technology research issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29284, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "L", "last_name": "LANKFORD", "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": "MAN", "general_issue_code_display": "Manufacturing", "description": "S.1468, Revitalize American Manufacturing and Innovation Act of 2013, Advanced Manufacturing related issues and initiatives", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29284, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": "L", "last_name": "LANKFORD", "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

  • 7 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 21.338ms