lobbying_filings_raw: a7fcca9f-3382-4188-a50c-e01c0aded08c

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
a7fcca9f-3382-4188-a50c-e01c0aded08c Q1 50375 JAY B. LEVIN, LEVIN,PAOLINO & CHRIST GOVENMENT REALTIONS CONSULTING 156831 CROSS SOUND FERRY SERVICES, INC. 2026 first_quarter 2026-04-07T12:54:44-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/a7fcca9f-3382-4188-a50c-e01c0aded08c/", "filing_uuid": "a7fcca9f-3382-4188-a50c-e01c0aded08c", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2026, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/a7fcca9f-3382-4188-a50c-e01c0aded08c/print/", "filing_document_content_type": "text/html", "income": "25000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Jay B Levin", "dt_posted": "2026-04-07T12:54:44-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "23 Worthington Road", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "New London", "registrant_state": "CT", "registrant_zip": "06320", "registrant": {"id": 50375, "url": "https://lda.gov/api/v1/registrants/50375/", "house_registrant_id": 34956, "name": "JAY B. LEVIN, LEVIN,PAOLINO & CHRIST GOVENMENT REALTIONS CONSULTING", "description": "lobbying & governmental relations firm", "address_1": "23 Worthington Road", "address_2": null, "address_3": null, "address_4": null, "city": "New London", "state": "CT", "state_display": "Connecticut", "zip": "06320", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JAY B. LEVIN", "contact_telephone": "+1 860-460-2247", "dt_updated": "2026-07-23T16:30:48.386515-04:00"}, "client": {"id": 156831, "url": "https://lda.gov/api/v1/clients/156831/", "client_id": 36, "name": "CROSS SOUND FERRY SERVICES, INC.", "general_description": "Ferry services for people, vehicles and commerce & shipyard (Thames Shipyard)", "client_government_entity": false, "client_self_select": null, "state": "CT", "state_display": "Connecticut", "country": "US", "country_display": "United States of America", "ppb_state": "CT", "ppb_state_display": "Connecticut", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2016-06-01"}, "lobbying_activities": [{"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "Exploration of working with Congress to acquire a parcel of land for expansion of client's shipyard, discussion to be held by client with the present owner of the parcel, the Superintendent of the United States Coast Guard Academy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 31124, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAY", "nickname": null, "middle_name": "B", "last_name": "LEVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Successful deployment of the latest clean engine technology in ferries", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 31124, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAY", "nickname": null, "middle_name": "B", "last_name": "LEVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 177, "name": "Maritime Administration (MARAD)"}]}, {"general_issue_code": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "Constant engagement with CT Port Authority, recreational, fishing, Coast Guard and US Navy vessels. Seeking federal funding for for profit ferry systems through an act of Congress", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 31124, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAY", "nickname": null, "middle_name": "B", "last_name": "LEVIN", "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": "RRR", "general_issue_code_display": "Railroads", "description": "Regular discussions with AMTRAK and related agencies regarding traffic access from City into client property and rights of way along property lines and in preparation for state/municipal construction of pedestrian walkway to provide safe access to ferries, trains and the future US Coast Guard Museum", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 31124, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAY", "nickname": null, "middle_name": "B", "last_name": "LEVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 75, "name": "AMTRAK - Natl Railroad Passenger Corporation"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}]}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "working in concert with the City of New London and the State of CT regarding ongoing development of Port of New London and downtown waterfront. Ongoing development of shipyard in the City of New London", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 31124, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAY", "nickname": null, "middle_name": "B", "last_name": "LEVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 75, "name": "AMTRAK - Natl Railroad Passenger Corporation"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}]}, {"general_issue_code": "MAN", "general_issue_code_display": "Manufacturing", "description": "Applying for MARAD assistance to enhance facilities at shipyard in the City of New London", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 31124, "prefix": "mr", "prefix_display": "MR.", "first_name": "JAY", "nickname": null, "middle_name": "B", "last_name": "LEVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 177, "name": "Maritime Administration (MARAD)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} CT US 34956 CT CT US US Ferry services for people, vehicles and commerce & shipyard (Thames Shipyard) 0 0         25000.0  

Links from other tables