lobbying_filings_raw: c2747d48-9254-44f2-8f87-d13d127f5b01

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
c2747d48-9254-44f2-8f87-d13d127f5b01 Q3 401104543 THE PRENDA GROUP LLC 207184 CROWLEY MARITIME CORPORATION 2022 third_quarter 2022-10-13T12:16:40-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c2747d48-9254-44f2-8f87-d13d127f5b01/", "filing_uuid": "c2747d48-9254-44f2-8f87-d13d127f5b01", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2022, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/c2747d48-9254-44f2-8f87-d13d127f5b01/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Brian Prenda", "dt_posted": "2022-10-13T12:16:40-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "416 South Capitol Street SE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 401104543, "url": "https://lda.senate.gov/api/v1/registrants/401104543/", "house_registrant_id": null, "name": "THE PRENDA GROUP LLC", "description": "Marine Based Aggregate Materials Project. State of Washington US", "address_1": "95205 Captains Way", "address_2": null, "address_3": null, "address_4": null, "city": "Fernandina Beach", "state": "FL", "state_display": "Florida", "zip": "32034", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "BRIAN JOSEPH PRENDA", "contact_telephone": "+1 202-258-3113", "dt_updated": "2026-01-13T15:20:19.498461-05:00"}, "client": {"id": 207184, "url": "https://lda.senate.gov/api/v1/clients/207184/", "client_id": 152, "name": "CROWLEY MARITIME CORPORATION", "general_description": "Shipping and Logistics / Liquified Natural Gas", "client_government_entity": false, "client_self_select": null, "state": "FL", "state_display": "Florida", "country": "US", "country_display": "United States of America", "ppb_state": "FL", "ppb_state_display": "Florida", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2020-09-17"}, "lobbying_activities": [{"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "The Development, Upgrade and modernization of energy infrastructure in Puerto Rico, the Caribbean, the U.S. Territories. Monitoring all proposed Infrastructure Legislation concerning Microgrids/ Ports / Liquified Natural Gas / Renewable Energy and Microgrids / in Puerto Rico, the Caribbean, the U.S. Territories. FY 2023 Appropriations.HR 8255 Department of Interior Maritime aspects of offshore wind development.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138295, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "PRENDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68950, "prefix": null, "prefix_display": null, "first_name": "BRADFORD", "nickname": null, "middle_name": null, "last_name": "PRICE", "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": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "The Development, Upgrade and modernization of energy infrastructure in Puerto Rico, the Caribbean, the U.S. Territories. Monitoring Congressional action on energy infrastructure, Microgrids at U.S. port facilities, Smart Ports, Liquified Natural Gas Transportation, Renewable Energy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138295, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "PRENDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68950, "prefix": null, "prefix_display": null, "first_name": "BRADFORD", "nickname": null, "middle_name": null, "last_name": "PRICE", "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": "TRA", "general_issue_code_display": "Transportation", "description": "Monitoring Congressional action on energy infrastructure at U.S. port facilities, smart ports. Monitoring Congressional action on energy infrastructure, Microgrids at U.S. port facilities, Liquified Natural Gas Transportation, Renewable Energy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138295, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "PRENDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68950, "prefix": null, "prefix_display": null, "first_name": "BRADFORD", "nickname": null, "middle_name": null, "last_name": "PRICE", "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": "Monitoring appropriations which affect the Development, Upgrade and modernization of energy infrastructure. Renewable Energy. Offshore wind. Infrastructure / Energy and water Appropriations FY 2023 HR 8255", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138295, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "PRENDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68950, "prefix": null, "prefix_display": null, "first_name": "BRADFORD", "nickname": null, "middle_name": null, "last_name": "PRICE", "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": "HOM", "general_issue_code_display": "Homeland Security", "description": "Monitoring FEMA response to Severe weather and Electric Grid in the United States.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138295, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": null, "last_name": "PRENDA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68950, "prefix": null, "prefix_display": null, "first_name": "BRADFORD", "nickname": null, "middle_name": null, "last_name": "PRICE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} FL US   FL FL US US Shipping and Logistics / Liquified Natural Gas 0 0         50000.0  

Links from other tables