home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ff2d70ff-9d4c-4d75-9d0e-27edaf2f8909

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
ff2d70ff-9d4c-4d75-9d0e-27edaf2f8909 3A 299992 NORTHWESTERN UNIV 180256 NORTHWESTERN UNIV 2016 third_quarter 2016-10-18T11:10:32.017000-04:00 177513.0 1 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ff2d70ff-9d4c-4d75-9d0e-27edaf2f8909/", "filing_uuid": "ff2d70ff-9d4c-4d75-9d0e-27edaf2f8909", "filing_type": "3A", "filing_type_display": "3rd Quarter - Amendment", "filing_year": 2016, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ff2d70ff-9d4c-4d75-9d0e-27edaf2f8909/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "177513.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Jennifer Kunde", "dt_posted": "2016-10-18T11:10:32.017000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "633 CLARK ST.", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "EVANSTON", "registrant_state": "IL", "registrant_zip": "60208", "registrant": {"id": 299992, "url": "https://lda.senate.gov/api/v1/registrants/299992/", "house_registrant_id": 37678, "name": "NORTHWESTERN UNIV", "description": null, "address_1": "633 CLARK ST.", "address_2": null, "address_3": null, "address_4": null, "city": "EVANSTON", "state": "IL", "state_display": "Illinois", "zip": "60208", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JOSEPH FITZGIBBON", "contact_telephone": "+1 847-491-7490", "dt_updated": "2026-01-20T09:42:38.251096-05:00"}, "client": {"id": 180256, "url": "https://lda.senate.gov/api/v1/clients/180256/", "client_id": 12, "name": "NORTHWESTERN UNIV", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "IL", "state_display": "Illinois", "country": "US", "country_display": "United States of America", "ppb_state": "IL", "ppb_state_display": "Illinois", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-13"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 644, America Gives More Act of 2015, Section 3.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65248, "prefix": null, "prefix_display": null, "first_name": "CAITLIN", "nickname": null, "middle_name": "M.", "last_name": "LEACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "S. 289/H.R. 2104 American Cures Act, entire bill.\n\nS. 318/H.R. 531 Accelerating Biomedical Research Act, entire bill.\n\nH.R. 6, 21st Century Cures Act, Title I and II.\n\nH.R. 2124/S. 1148, Resident Physician Shortage Reduction Act, entire bill.\n\nS. 2713, Advancing Precision Medicine Act of 2016, entire bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65248, "prefix": null, "prefix_display": null, "first_name": "CAITLIN", "nickname": null, "middle_name": "M.", "last_name": "LEACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "H.R. 9, Innovation Act, entire bill. \n\nS. 632, Strong Patent Act of 2015, entire bill.\n\nS. 1137, Protecting American Talent and Entrepreneurship Act of 2015, Section 7.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65248, "prefix": null, "prefix_display": null, "first_name": "CAITLIN", "nickname": null, "middle_name": "M.", "last_name": "LEACH", "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": "H. Con. Res. 125, Establishing the congressional budget for the United States Government for fiscal year 2017 and setting forth the appropriate budgetary levels for fiscal years 2018 through 2026, Title I\n\nH.R. 5393, FY 2017 Commerce, Justice and Science Appropriations Bill, Title III, Office of Science and Technology, National Science Foundation.\n\nS. 2837, FY 2017 Commerce, Justice and Science Appropriations Bill, Title III, Science, Office of Science and Technology, National Science Foundation.\n\nH.R. 5293, FY 2017 Department of Defense Appropriations, Title IV, RDTE, Title VI, Defense Health Programs.\n\nS. 3000, FY 2017, Department of Defense Appropriations, Title IV, RDTE, Title VI, Defense Health Program.\n\nH.R. 5055, FY 2017, Department of Energy and Water Development Appropriations, Title III, Department of Energy, Energy Efficiency and Renewable Energy. \n\nS. 2804, FY 2017, Department of Energy and Water Development Appropriations, Title III, Department of Energy, Energy Efficiency and Renewable Energy, Science Advanced Research Projects Agency-Energy.\n\nS. 3040, FY 2017, Departments of Labor, Health and Human Services and Education, and related agencies appropriations bill, Title II, Department of Health and Human Services, HRSA, CDC, NIH, AHRQ, Title III, Department of Education.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65248, "prefix": null, "prefix_display": null, "first_name": "CAITLIN", "nickname": null, "middle_name": "M.", "last_name": "LEACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "S. 153, I-Squared Act of 2015, entire bill.\n\nH.R. 962/S. 181, The Startup Act, entire bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65248, "prefix": null, "prefix_display": null, "first_name": "CAITLIN", "nickname": null, "middle_name": "M.", "last_name": "LEACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "S. 108, Financial Aid Simplification and Transparency Act of 2015, entire bill.\n\nS. 559/H.R. 970, Supporting Academic Freedom Through Regulatory Relief Act, entire bill.\n\nH.R. 1310/S. 590, Campus Safety and Accountability Act, entire bill.\n\nH. Res. 294, Expressing support for the continuation of the Perkins Loan Program, entire bill.\n\nS. 1060/H.R. 1956, Pell Grant Protection Act, entire bill.\n\nH.R. 2604/S. 1482, Need-Based Educational Aid Act, entire bill.\n\nS. 729, Fairness for Struggling Students Act, entire bill.\n\nH.R. 5528, The Simplifying the Application for Student Aid Act, entire bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65248, "prefix": null, "prefix_display": null, "first_name": "CAITLIN", "nickname": null, "middle_name": "M.", "last_name": "LEACH", "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": "SCI", "general_issue_code_display": "Science/Technology", "description": "S. 747/H.R. 1398, American Innovation Act, entire bill. \n\nH.R. 1119, Research and Development Efficiency Act, entire bill. \n\nH.R. 1158, Department of Energy Laboratory Modernization and Technology Transfer Act, entire bill. \n\nH.R. 1806, America COMPETES Reauthorization Act of 2015, entire bill. \n\nS. 1398, Energy Title of the America COMPETES Reauthorization Act of 2015, entire bill.\n\nH.R. 5638, The Solar Fuels Innovation Act, entire bill. \n\nH.R. 5640, The Electricity Storage innovation Act, entire bill.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65248, "prefix": null, "prefix_display": null, "first_name": "CAITLIN", "nickname": null, "middle_name": "M.", "last_name": "LEACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} IL US 37678 IL IL US US   0 0        

Links from other tables

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