home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 851d9cdb-e69e-4b40-a22b-2d4fb53ac774

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
851d9cdb-e69e-4b40-a22b-2d4fb53ac774 Q1 22781 LEWIS-BURKE ASSOCIATES, LLC 129686 UNIVERSITY OF ROCHESTER 2021 first_quarter 2021-04-15T16:08:43.157000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/851d9cdb-e69e-4b40-a22b-2d4fb53ac774/", "filing_uuid": "851d9cdb-e69e-4b40-a22b-2d4fb53ac774", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2021, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/851d9cdb-e69e-4b40-a22b-2d4fb53ac774/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "R. Reed Skaggs, Chief Strategy and Business Officer", "dt_posted": "2021-04-15T16:08:43.157000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "440 1st Street, NW, Suite 700", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 22781, "url": "https://lda.senate.gov/api/v1/registrants/22781/", "house_registrant_id": 30442, "name": "LEWIS-BURKE ASSOCIATES, LLC", "description": "Lobbying and Consulting Firm", "address_1": "440 1st Street NW", "address_2": "Suite 700", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "REED SKAGGS", "contact_telephone": "+1 202-289-7475", "dt_updated": "2026-01-28T14:55:41.471573-05:00"}, "client": {"id": 129686, "url": "https://lda.senate.gov/api/v1/clients/129686/", "client_id": 1003388, "name": "UNIVERSITY OF ROCHESTER", "general_description": "Higher Education Institution", "client_government_entity": false, "client_self_select": null, "state": "NY", "state_display": "New York", "country": "US", "country_display": "United States of America", "ppb_state": "NY", "ppb_state_display": "New York", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2016-06-01"}, "lobbying_activities": [{"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "National Defense Authorization Act for Fiscal Year 2022, Issues pertaining to the National Nuclear Security Administration, the inertial confinement fusion program, and laser technologies for national security applications.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61847, "prefix": null, "prefix_display": null, "first_name": "LELAND", "nickname": null, "middle_name": null, "last_name": "COGLIANI", "suffix": null, "suffix_display": null}, "covered_position": "Professional Staff of the Senate Energy and Water Appropriations Subcommittee; Senior Analyst at the Government Accountability Office", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY 2022 Energy-Water Appropriations, Issues pertaining to research, development, testing, and evaluation at the National Nuclear Security Administration, and laser science and technology development and high energy density physics at the DOE Office of Science.\nFY 2022 Defense Appropriations, Issues related to laser technologies for defense applications.\nFY 2022 Commerce/Justice/Science Appropriations, Issues pertaining to NSF.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 17270, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LEDFORD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61847, "prefix": null, "prefix_display": null, "first_name": "LELAND", "nickname": null, "middle_name": null, "last_name": "COGLIANI", "suffix": null, "suffix_display": null}, "covered_position": "Professional Staff of the Senate Energy and Water Appropriations Subcommittee; Senior Analyst at the Government Accountability Office", "new": false}, {"lobbyist": {"id": 64181, "prefix": null, "prefix_display": null, "first_name": "BEETA", "nickname": null, "middle_name": null, "last_name": "RASOULI", "suffix": null, "suffix_display": null}, "covered_position": "Staff Assistant, Legislative Fellow, Office of Rep. Allyson Schwartz", "new": false}, {"lobbyist": {"id": 78839, "prefix": null, "prefix_display": null, "first_name": "AMBER", "nickname": null, "middle_name": "M", "last_name": "CASSADY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "DOE Office of Science Reauthorization, Issues pertaining to high energy density physics, laser technologies, and quantum science.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61847, "prefix": null, "prefix_display": null, "first_name": "LELAND", "nickname": null, "middle_name": null, "last_name": "COGLIANI", "suffix": null, "suffix_display": null}, "covered_position": "Professional Staff of the Senate Energy and Water Appropriations Subcommittee; Senior Analyst at the Government Accountability Office", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30442 NY NY US US Higher Education Institution 0 0 113097   normalized_name_state 0.9

Links from other tables

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