lobbying_filings_raw: c347914f-5cf0-453f-a3d6-266fe1061de0

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
c347914f-5cf0-453f-a3d6-266fe1061de0	Q1	28424	NATIONAL READY MIXED CONCRETE ASSOCIATION	134530	NATIONAL READY MIXED CONCRETE ASSOCIATION	2025	first_quarter	2025-04-17T09:21:08-04:00	0	0	0	{"url": "https://lda.gov/api/v1/filings/c347914f-5cf0-453f-a3d6-266fe1061de0/", "filing_uuid": "c347914f-5cf0-453f-a3d6-266fe1061de0", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2025, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/c347914f-5cf0-453f-a3d6-266fe1061de0/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "56280.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Andrew Tyrrell", "dt_posted": "2025-04-17T09:21:08-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "66 Canal Center Plaza", "registrant_address_2": "Suite 250", "registrant_different_address": false, "registrant_city": "Alexandria", "registrant_state": "VA", "registrant_zip": "22314", "registrant": {"id": 28424, "url": "https://lda.gov/api/v1/registrants/28424/", "house_registrant_id": 32810, "name": "NATIONAL READY MIXED CONCRETE ASSOCIATION", "description": null, "address_1": "900 SPRING STREET", "address_2": null, "address_3": null, "address_4": null, "city": "SILVER SPRING", "state": "MD", "state_display": "Maryland", "zip": "20910", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ANDREW TYRRELL", "contact_telephone": "+1 321-229-1785", "dt_updated": "2026-01-30T11:51:02.315069-05:00"}, "client": {"id": 134530, "url": "https://lda.gov/api/v1/clients/134530/", "client_id": 12, "name": "NATIONAL READY MIXED CONCRETE ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-10"}, "lobbying_activities": [{"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Workforce Democracy and Fairness Act Employee Privacy Protection Act Save Local Business Act Fair and Open Competition Act Davis-Bacon Wage Rules Independent Contractor Rules Project Labor Agreement Rules Faster Labor Contracts Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66603, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": "JOHN", "last_name": "TYRRELL", "suffix": null, "suffix_display": null}, "covered_position": "Executive Vice President of Government Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Truck Size & Weight Policies Workforce Development Infrastructure Investment and Jobs Act Buy America Domestic Procurement Policy Low Carbon Procurement Highway Reauthorization H.R. 2122 IMPACT Act 2.0 S. 1067 Concrete and Asphalt Innovation Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66603, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": "JOHN", "last_name": "TYRRELL", "suffix": null, "suffix_display": null}, "covered_position": "Executive Vice President of Government Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Disaster Savings and Resilient Construction Act Interest Expense Deduction Section 1031 Like-Kind Exchange Tax Deferral Individual Income Tax Rate Estate Tax Tax Relief for American Workers and Families Act Sec. 199A Tax Cuts and Jobs Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66603, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": "JOHN", "last_name": "TYRRELL", "suffix": null, "suffix_display": null}, "covered_position": "Executive Vice President of Government Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Inflation Reduction Act of 2022 Low Carbon Labeling EPD Assistance Program Performance Based Specifications Sustainable Building Materials Program Concrete and Asphalt Innovation Act H.R. 1534 IMPACT Act S. 1067 Concrete and Asphalt Innovation Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66603, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": "JOHN", "last_name": "TYRRELL", "suffix": null, "suffix_display": null}, "covered_position": "Executive Vice President of Government Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Building Resilient Infrastructure and Communities Program Building Code Development and Enforcement Infrastructure Investment and Jobs Act Sustainable and Resilient Construction Mass Timber Federal Buildings Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66603, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": "JOHN", "last_name": "TYRRELL", "suffix": null, "suffix_display": null}, "covered_position": "Executive Vice President of Government Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "National Flood Insurance Program (NFIP) Reauthorization", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66603, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": "JOHN", "last_name": "TYRRELL", "suffix": null, "suffix_display": null}, "covered_position": "Executive Vice President of Government Affairs", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Transportation, Housing and Urban Development, and Related Agencies Appropriations Department of the Interior, Environment, and Related Agencies Appropriations Department of Homeland Security Appropriations Energy & Water Development and Related Agencies Appropriations Department of Defense & Related Agencies Appropriations Military Construction and Veterans Affairs Appropriations National Defense Authorization Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66603, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": "JOHN", "last_name": "TYRRELL", "suffix": null, "suffix_display": null}, "covered_position": "Executive Vice President of Government Affairs", "new": false}], "government_entities": [{"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	MD	US	32810	VA	VA	US	US		0	0						56280.0

Links from other tables

21 rows from filing_uuid in lobbying_activities
3 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs