lobbying_filings_raw: 0dc5c9be-e9c3-4e5e-acc4-cd90aa750db0

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.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
0dc5c9be-e9c3-4e5e-acc4-cd90aa750db0 Q3 75810 MR. SEBASTIAN O'KELLY 168738 LOUISIANA OYSTER DEALERS & GROWERS ASSOCIATION 2017 third_quarter 2017-10-09T13:44:02.833000-04:00   0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0dc5c9be-e9c3-4e5e-acc4-cd90aa750db0/", "filing_uuid": "0dc5c9be-e9c3-4e5e-acc4-cd90aa750db0", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2017, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0dc5c9be-e9c3-4e5e-acc4-cd90aa750db0/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Sebastian O'Kelly", "dt_posted": "2017-10-09T13:44:02.833000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "9312 ELMHIRST DRIVE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "BETHESDA", "registrant_state": "MD", "registrant_zip": "20814", "registrant": {"id": 75810, "url": "https://lda.senate.gov/api/v1/registrants/75810/", "house_registrant_id": 36062, "name": "MR. SEBASTIAN O'KELLY", "description": "government relations", "address_1": "9312 ELMHIRST DRIVE", "address_2": null, "address_3": null, "address_4": null, "city": "BETHESDA", "state": "MD", "state_display": "Maryland", "zip": "20814", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "SEBASTIAN O'KELLY", "contact_telephone": "+1 301-529-2924", "dt_updated": "2023-07-29T19:25:16.799180-04:00"}, "client": {"id": 168738, "url": "https://lda.senate.gov/api/v1/clients/168738/", "client_id": 48, "name": "LOUISIANA OYSTER DEALERS & GROWERS ASSOCIATION", "general_description": "To promote the economic interests of the Louisiana oyster industry", "client_government_entity": false, "client_self_select": null, "state": "LA", "state_display": "Louisiana", "country": "US", "country_display": "United States of America", "ppb_state": "LA", "ppb_state_display": "Louisiana", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2016-04-04"}, "lobbying_activities": [{"general_issue_code": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "Support for inclusion in FY 2018 Energy & Water Appropriations Bills report language encouraging the Army Corps of Engineers to better assess water quality impacts on Gulf of Mexico oysters of navigation and coastal restoration projects and where feasible to mitigate any negative impacts on area oyster reefs. Monitor funding and development of Gulf coastal restoration, flood control and navigation projects. Monitor funding decisions and activities of entities (NRDA Trustee Council, RESTORE Act Council, National Fish & Wildlife Foundation) responsible for disbursement of BP Deepwater Horizon oil spill settlement funding. Support for extension of H2B guest worker visa program. Support for Federal funding for repair of Bohemia Salinity Control Structure on the lower MS River. Opposition to termination of the NOAA Sea Grant Program. Support for trade investigation into possible unfair dumping of imported oysters from Asia. Drafting and submission of comments on the Army Corps's draft scoping for its Environmental Impact Statement for construction of the Mid-Barataria Sediment Diversion in the lower MS River Delta.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143052, "prefix": "mr", "prefix_display": "MR.", "first_name": "SEBASTIAN", "nickname": null, "middle_name": "PATRICK", "last_name": "O'KELLY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 111, "name": "Natl Oceanic & Atmospheric Administration (NOAA)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables