lobbying_filings_raw: a7c1aba5-c7c5-4d22-9dea-e293ff523f6f

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 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
a7c1aba5-c7c5-4d22-9dea-e293ff523f6f Q4 295691 OCEAN CHAMPIONS 179250 OCEAN CHAMPIONS 2011 fourth_quarter 2012-01-13T18:31:09-05:00 80000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/a7c1aba5-c7c5-4d22-9dea-e293ff523f6f/", "filing_uuid": "a7c1aba5-c7c5-4d22-9dea-e293ff523f6f", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2011, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/a7c1aba5-c7c5-4d22-9dea-e293ff523f6f/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "80000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "David Wilmot, President", "dt_posted": "2012-01-13T18:31:09-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "202 San Jose Avenue", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Capitola", "registrant_state": "CA", "registrant_zip": "95010", "registrant": {"id": 295691, "url": "https://lda.senate.gov/api/v1/registrants/295691/", "house_registrant_id": 37469, "name": "OCEAN CHAMPIONS", "description": "Environmental advocacy", "address_1": "202 San Jose Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Capitola", "state": "CA", "state_display": "California", "zip": "95010", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DAVID WILMOT", "contact_telephone": "", "dt_updated": "2022-04-06T16:07:45.744623-04:00"}, "client": {"id": 179250, "url": "https://lda.senate.gov/api/v1/clients/179250/", "client_id": 12, "name": "OCEAN CHAMPIONS", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2005-02-15"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Working with the House and Senate offices to secure support of and funding for ocean-related environmental projects and for the President's request for fisheries programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20936, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WILMOT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48621, "prefix": null, "prefix_display": null, "first_name": "MIKE", "nickname": null, "middle_name": null, "last_name": "DUNMYER", "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": "NAT", "general_issue_code_display": "Natural Resources", "description": "Advocacy with members of the House and Senate, and their staff members on behalf of legislation to re-introduce and pass a Harmful Algal Bloom and Hypoxia Research Amendments Act similar to the bill introduced in 2009, and full implementation of the Magnuson Stevens Act and defense against the weakening of the amendments of the Magnuson Stevens Act and for policy that supports the President's request for fisheries programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20936, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WILMOT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48621, "prefix": null, "prefix_display": null, "first_name": "MIKE", "nickname": null, "middle_name": null, "last_name": "DUNMYER", "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": "SCI", "general_issue_code_display": "Science/Technology", "description": "Advocacy with members of the House and Senate, and their staff members on behalf of legislation to re-introduce and pass a Harmful Algal Bloom and Hypoxia Research Amendments Act similar to the bill introduced in 2009.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20936, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WILMOT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48621, "prefix": null, "prefix_display": null, "first_name": "MIKE", "nickname": null, "middle_name": null, "last_name": "DUNMYER", "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": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Advocacy with members of the House and Senate, and their staff members on behalf of legislation to re-introduce and pass a Harmful Algal Bloom and Hypoxia Research Amendments Act similar to the bill introduced in 2009.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20936, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "WILMOT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48621, "prefix": null, "prefix_display": null, "first_name": "MIKE", "nickname": null, "middle_name": null, "last_name": "DUNMYER", "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": []} CA US 37469 CA CA US US   0 0 2334025   normalized_name 0.7

Links from other tables