home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ab1c3e09-7220-4596-83db-9c59141e5d89

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
ab1c3e09-7220-4596-83db-9c59141e5d89 Q2 4540 ASSOCIATION OF COMMUNITY COLLEGE TRUSTEES 104873 ASSOCIATION OF COMMUNITY COLLEGE TRUSTEES 2022 second_quarter 2022-07-14T16:06:08-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ab1c3e09-7220-4596-83db-9c59141e5d89/", "filing_uuid": "ab1c3e09-7220-4596-83db-9c59141e5d89", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2022, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ab1c3e09-7220-4596-83db-9c59141e5d89/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Carrie Warick-Smith", "dt_posted": "2022-07-14T16:06:08-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1101 17TH STREET, NW, #300", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 4540, "url": "https://lda.senate.gov/api/v1/registrants/4540/", "house_registrant_id": 31523, "name": "ASSOCIATION OF COMMUNITY COLLEGE TRUSTEES", "description": null, "address_1": "1101 17TH STREET, NW, #300", "address_2": null, "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": "CARRIE WARICK-SMITH", "contact_telephone": "+1 202-775-6488", "dt_updated": "2026-02-10T17:42:03.965666-05:00"}, "client": {"id": 104873, "url": "https://lda.senate.gov/api/v1/clients/104873/", "client_id": 12, "name": "ASSOCIATION OF COMMUNITY COLLEGE TRUSTEES", "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": "2007-07-25"}, "lobbying_activities": [{"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "S. 864, H.R. 2037, Jumpstart Our Businesses by Supporting Students (JOBS) Act - Makes certain short-term education and training programs eligible for Pell grant. S. 839, H.R. 2030, College Transparency Act - Streamlines reporting requirements for postsecondary institutions and makes program-level data more available to students. S. 1396, H.R. 2861, Americas College Promise Act of 2021- Creates federal-state partnership that enables students to attend community college tuition-free. S. 2237 Community College Student Success Act - Seeks to improve community college graduation rates by expanding student support services. S. 200, H.R. 602, Relaunching Americas Workforce Act - Invests $15 billion in Americas workforce training infrastructure in response to the pandemic. S. 2004, H.R. 3857, Basic Assistance for Students in College (BASIC) Act - Directs grants to colleges to ensure they can provide basic needs services to students. S. 1847, ACCESS to Careers Act - Builds on the Trade Adjustment Assistance Community Colleges and Career Training (TAACCCT) grant program to increase the ability of community colleges to meet labor market demand. H.R. 447, National Apprenticeship Act of 2021- Authorizes $3.5 billion to expand registered apprenticeships across the country. Passed by the House of Representatives in February 2021. S. 1802, H.R.4411, Upskilling and Retraining Assistance Act - Increases the annual tax-free benefit from $5,250 to $12,000 for two years and expands the tools and technology that would qualify. S. 2081, H.R.3946, Pell Grant Preservation and Expansion Act - Doubles the maximum Pell Grant and further expands eligibility to help more low-income students and families afford the cost of college. S. 2054, Partnerships for Affordability and Student Success (PASS) Act - Amends the Higher Education Act to strengthen federal-state partnerships in postsecondary education. H.R. 7309 Workforce Innovation and Opportunity Act (WIOA) Reauthorization - Primary federal workforce development legislation to bring about increased coordination among labor and related programs. Due for reauthorization as of 2020. S.2800, H.R.6108 Community College to Career Fund in Higher Education Act - This bill would establish a grant program for industry partnerships with community colleges to set up and strengthen workforce programs that lead to jobs. S. 1802, the Upskilling and Retraining Assistance Act, this bill increases to $12,000 in 2021-2022, the exclusion from employee gross income, for income tax purposes, of employer-paid educational assistance programs. The bill also expands the exclusion to include amounts paid for education-related tools and technology (e.g., hand tools, computers, software, licensure fees). S.52 - Gateway to Careers Act of 2021 - This bill would provide grants to support partnerships between community or technical colleges and workforce development partners such as state workforce development boards, industry associations, and community-based organizations. S.3359 - CREATE Graduates Act, this bill would award competitive grants to states to create or support reverse transfer programs. These programs encourage educational institutions to find and award associate degrees to students who transferred from community college to four-year schools and earned enough credits for a degree, but never collected one. H.R.3684, Infrastructure Investment and Jobs Act - provide infrastructure investments across multiple sectors. H.R.5376, Build Back Better Act - Reconciliation legislation that would authorize Student Success Grant Program, provide additional community college-led workforce training, Increase the maximum award for Pell, eliminate tax liability for Pell Grants, provide additional funding for TAACCCT, and eliminate the AOTC offset from Pell grants. H.R.6376 - Student Veteran Work Study Modernization Act, this bill would allow part-time student veterans to access the VA Work Study programs. S.2625 - CCAMPIS Reauthorization Act, this bill would permanently reauthorize CCAMPIS along with increasing the funding for the program H.R. 4521 Bioeconomy Research and Development Act [America COMPETES Act] - comprehensive bill aimed at bolstering U.S. global competitiveness and strengthen domestic tech manufacturing. The bill includes several provisions including short term Pell grants, College Transparency Act, Apprenticeships reauthorization, among others. S. S.1260 - United States Innovation and Competition Act - comprehensive bill aimed at bolstering U.S. global competitiveness and strengthen domestic tech manufacturing. The bill includes workforce training provisions of importance to community colleges.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73090, "prefix": null, "prefix_display": null, "first_name": "JOSE", "nickname": null, "middle_name": null, "last_name": "MIRANDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138998, "prefix": "ms", "prefix_display": "MS.", "first_name": "ROSARIO", "nickname": null, "middle_name": "MARIA", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 138578, "prefix": "ms", "prefix_display": "MS.", "first_name": "CARRIE", "nickname": null, "middle_name": "WARICK", "last_name": "WARICK-SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R.5376, Build Back Better Act - Reconciliation legislation that would authorize Student Success Grant Program, provide additional community college-led workforce training, Increase the maximum award for Pell, eliminate tax liability for Pell Grants, provide additional funding for TAACCCT, and eliminate the AOTC offset from Pell grants. Houses FY22 Labor HHS Subcommittee funding bill - Makes appropriations for the Departments of Labor, Health and Human Services and Education. Provides about 40% in increases to the Department of Education Programs. Senates FY22 Labor HHS Subcommittee funding bill - Makes appropriations for the Departments of Labor, Health and Human Services and Education. H.R. 2471 Consolidated Appropriations Act of 2022 - This bill provides funding for all 12 appropriations divisions, including providing a Pell Grant increase and funding for community colleges via grant programs. H.R. 8295 - Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73090, "prefix": null, "prefix_display": null, "first_name": "JOSE", "nickname": null, "middle_name": null, "last_name": "MIRANDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138998, "prefix": "ms", "prefix_display": "MS.", "first_name": "ROSARIO", "nickname": null, "middle_name": "MARIA", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 138578, "prefix": "ms", "prefix_display": "MS.", "first_name": "CARRIE", "nickname": null, "middle_name": "WARICK", "last_name": "WARICK-SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "H.R.5376, Build Back Better Act - Reconciliation legislation that would authorize Student Success Grant Program, provide additional community college-led workforce training, Increase the maximum award for Pell, eliminate tax liability for Pell Grants, provide additional funding for TAACCCT, and eliminate the AOTC offset from Pell grants. H.R. 6, the American Dream and Promise Act- Gives DACA recipients and other undocumented individuals an opportunity to acquire permanent lawful status if they meet certain requirements. Passed the House of Representatives in March 2021.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73090, "prefix": null, "prefix_display": null, "first_name": "JOSE", "nickname": null, "middle_name": null, "last_name": "MIRANDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138578, "prefix": "ms", "prefix_display": "MS.", "first_name": "CARRIE", "nickname": null, "middle_name": "WARICK", "last_name": "WARICK-SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "H.R. 6, the American Dream and Promise Act- Gives DACA recipients and other undocumented individuals an opportunity to acquire permanent lawful status if they meet certain requirements. Passed the House of Representatives in March 2021. H.R.5376 Build Back Better Act - Reconciliation legislation that would authorize Americas College Promise, Student Success Grant Program, provide additional community college-led workforce training, Increase the maximum award for Pell, eliminate tax liability for Pell Grants, provide additional funding for TAACCCT, and eliminate the AOTC offset from Pell grants, and provide a pathway to citizenship for DACA recipients.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73090, "prefix": null, "prefix_display": null, "first_name": "JOSE", "nickname": null, "middle_name": null, "last_name": "MIRANDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 138578, "prefix": "ms", "prefix_display": "MS.", "first_name": "CARRIE", "nickname": null, "middle_name": "WARICK", "last_name": "WARICK-SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 138998, "prefix": "ms", "prefix_display": "MS.", "first_name": "ROSARIO", "nickname": null, "middle_name": "MARIA", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 3803, Pell Grant Flexibility Act- Amends the Internal Revenue Code to exclude from gross income any amount received as a Federal Pell Grant. H.R. 6749, American Opportunity Student Tax Relief Act- Extends and modifies the American Opportunity Tax Credit and excludes from gross income any amount received as a Federal Pell Grant. S. 847, Student Loan Tax Elimination Act - Eliminates the origination fee on federal student loans. Origination fees are the fees lenders charge for processing new loan applications. S.2455, H.R. 4173, Tax Free Pell Grant Act - Expands the usage of Pell Grants on a tax-free basis, improves coordination with the American Opportunity Tax Credit (AOTC) and ensures students do not lose out on any AOTC benefits. H.R.5376, Build Back Better Act - Reconciliation legislation that would authorize Student Success Grant Program, provide additional community college-led workforce training, Increase the maximum award for Pell, eliminate tax liability for Pell Grants, provide additional funding for TAACCCT, and eliminate the AOTC offset from Pell grants.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 73090, "prefix": null, "prefix_display": null, "first_name": "JOSE", "nickname": null, "middle_name": null, "last_name": "MIRANDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138578, "prefix": "ms", "prefix_display": "MS.", "first_name": "CARRIE", "nickname": null, "middle_name": "WARICK", "last_name": "WARICK-SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 138998, "prefix": "ms", "prefix_display": "MS.", "first_name": "ROSARIO", "nickname": null, "middle_name": "MARIA", "last_name": "DURAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31523 DC DC US US   0 0           10000.0

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.718ms · Privacy