home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dfdcb54f-fe89-4ad1-a87c-90b75d3df952

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
dfdcb54f-fe89-4ad1-a87c-90b75d3df952 Q1 11071 COUNCIL OF GRADUATE SCHOOLS 114923 COUNCIL OF GRADUATE SCHOOLS 2021 first_quarter 2021-04-16T10:53:40.130000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/dfdcb54f-fe89-4ad1-a87c-90b75d3df952/", "filing_uuid": "dfdcb54f-fe89-4ad1-a87c-90b75d3df952", "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/dfdcb54f-fe89-4ad1-a87c-90b75d3df952/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Matthew Smith", "dt_posted": "2021-04-16T10:53:40.130000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "ONE DUPONT CIRCLE, NW", "registrant_address_2": "Suite 230", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 11071, "url": "https://lda.senate.gov/api/v1/registrants/11071/", "house_registrant_id": 33114, "name": "COUNCIL OF GRADUATE SCHOOLS", "description": "non-profit higher education association", "address_1": "ONE DUPONT CIRCLE, NW", "address_2": "Suite 230", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20036", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "AMY SCOTT", "contact_telephone": "+1 202-461-3864", "dt_updated": "2023-06-06T16:25:13.718606-04:00"}, "client": {"id": 114923, "url": "https://lda.senate.gov/api/v1/clients/114923/", "client_id": 12, "name": "COUNCIL OF GRADUATE SCHOOLS", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2018-06-01"}, "lobbying_activities": [{"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "N/A for Q1.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69152, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "INOUYE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 72266, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 76, "name": "Natl Science Foundation (NSF)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "N/A for Q1.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69152, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "INOUYE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 72266, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 76, "name": "Natl Science Foundation (NSF)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "N/A for Q1.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69152, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "INOUYE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 72266, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 76, "name": "Natl Science Foundation (NSF)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Supported robust FY 2022 appropriations for the Department of Education and key programs, including Pell Grants, Supplemental Education Opportunity Grants, Federal Work-Study, TRIO programs, GEAR UP, LEAP Grants, foreign language programs, and the Graduate Assistance in Areas of National Need program. Also requested increased funding for research and technology areas including NSF and HRSA's Title VII and Title VIII programs. CGS also advocated for an increase in funding to the National Endowment for the Humanities.\n\nSupported the COVID-19 Reconciliation Budget package, which offered $40 billion in emergency funding for students and institutions and dedicated funding for HBCUs and other MSIs. Also supported emergency supplemental funds for the research enterprise. CGS applauded the passage of the American Rescue Plan upon passage.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69152, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "INOUYE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 72266, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 76, "name": "Natl Science Foundation (NSF)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Expressed higher education priorities to the Department of Homeland Security, including ways DHS can support international students and scholars. \n\nRequested DREAMers and international students be made eligible for emergency student funds under HEERF II.\n\nExpressed higher education priorities to the Department of State, including priorities for international students and scholars. \n\nJoined recommendations to the Departments of State and Homeland Security on how the departments can support international students' return to campuses and institutions in the fall of 2021.\n\nEndorsed the bipartisan DREAM Act (S.264).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69152, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "INOUYE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 72266, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 76, "name": "Natl Science Foundation (NSF)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Supported robust FY 2022 appropriations for the Department of Education and key programs, including Pell Grants, Supplemental Education Opportunity Grants, Federal Work-Study, TRIO programs, GEAR UP, LEAP Grants, foreign language programs, and the Graduate Assistance in Areas of National Need program.\n \nEncouraged $40 billion in COVID-19 relief for higher education institutions and students.\n\nActively lobbied for the reintroduction of the Expanding Access to Graduate Education Act in the 117th Congress. The legislation would provide graduate students who received Pell Grant support as undergraduates and who remain income-eligible to the ability to apply remaining semesters of Pell awards towards a graduate degree. \n\nExpressed higher education priorities to the Department of Homeland Security, including ways DHS can support international students and scholars. \n\nRequested DREAMers and international students are made eligible for emergency student funds under HEERF II.\n\nExpressed higher education priorities to the Department of State, including priorities for international students and scholars.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69152, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "INOUYE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 72266, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 76, "name": "Natl Science Foundation (NSF)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "Supported robust FY 2022 appropriations for science research funding.\n\nSupported emergency relief for science and research funding for the National Science Foundation in COVID-19 relief legislation. \n\nEndorsed the Research Investment to Spark the Economy Act (H.R.869/S.289), which would provide roughly $25 billion in emergency relief for the research enterprise in light of COVID-19. Also, encouraged President Biden to champion the legislation.\n\nEndorsed the Supporting Early Career Researchers Act (H.R.144), which would establish a 2-year postdoctoral fellowship program through NSF to support early-career scientists whose employment prospects may have been affected by COVID-19.\n\nJoined a letter to President Biden with priorities for the research and development enterprise.\n\nCGS encouraged increased flexibility for individuals completing the Survey of Earned Doctorate request and the Survey of Doctorate Recipients request. These flexibilities encouraged including appropriate demographic options for individuals who may identify as non-binary. These recommendations were submitted to the National Science Foundation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 69152, "prefix": null, "prefix_display": null, "first_name": "LAUREN", "nickname": null, "middle_name": null, "last_name": "INOUYE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 72266, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 76, "name": "Natl Science Foundation (NSF)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 33114 DC DC US US   0 0            

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.6ms · Privacy