home / lobbying / lobbying_filings_raw

lobbying_filings_raw: d8b628fe-31b2-4b6f-adb7-e60b2f87c853

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
d8b628fe-31b2-4b6f-adb7-e60b2f87c853 Q2 12711 DUCKS UNLIMITED, INC 117781 DUCKS UNLIMITED, INC 2009 second_quarter 2009-07-13T15:03:42-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/d8b628fe-31b2-4b6f-adb7-e60b2f87c853/", "filing_uuid": "d8b628fe-31b2-4b6f-adb7-e60b2f87c853", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2009, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/d8b628fe-31b2-4b6f-adb7-e60b2f87c853/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "50000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Scott Sutherland, Director fo the Governmental Affairs Office", "dt_posted": "2009-07-13T15:03:42-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1301 PENNSYLVANIA AVENUE, NW, #402", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 12711, "url": "https://lda.senate.gov/api/v1/registrants/12711/", "house_registrant_id": 31845, "name": "DUCKS UNLIMITED, INC", "description": "Wetlands Conservation Organization", "address_1": "444 North Capitol Street, NW", "address_2": "Suite 745", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ZACH HARTMAN", "contact_telephone": "+1 202-347-1530", "dt_updated": "2025-03-17T12:29:52.815358-04:00"}, "client": {"id": 117781, "url": "https://lda.senate.gov/api/v1/clients/117781/", "client_id": 12, "name": "DUCKS UNLIMITED, INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2009-10-15"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Working to increase funding for migratory bird habitat conservation programs within Interior appropriations legislation, Agriculture appropriations legislation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10861, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SUTHERLAND", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 10689, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTON", "nickname": null, "middle_name": "CHARLES", "last_name": "JAMES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 50309, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "WRINN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Working to overcome challenges to the Clean Water Act that would jeopardize waters important to waterfowl, S 787.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10861, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SUTHERLAND", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 50309, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "WRINN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 10689, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTON", "nickname": null, "middle_name": "CHARLES", "last_name": "JAMES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Working to build support for conservation in the implementation of the 2008 Farm Bill, HR 2419.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10861, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SUTHERLAND", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 10689, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTON", "nickname": null, "middle_name": "CHARLES", "last_name": "JAMES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 50309, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "WRINN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Working to ensure inclusion of and favorable treatment for conservation easements and improved incentives for charitable contributions in pending tax legislation, HR 1831 and S 812. IRA Rollover. Payment of excise taxes that help fund North American Wetlands Conservation Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10861, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SUTHERLAND", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 10689, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTON", "nickname": null, "middle_name": "CHARLES", "last_name": "JAMES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 50309, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "WRINN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Working to ensure wildlife needs are considered in climate change legislation, HR 2454.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10861, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SUTHERLAND", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 10689, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTON", "nickname": null, "middle_name": "CHARLES", "last_name": "JAMES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 50309, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "WRINN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 59138, "prefix": null, "prefix_display": null, "first_name": "CAROLINE", "nickname": null, "middle_name": null, "last_name": "BROUWER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 45313, "prefix": null, "prefix_display": null, "first_name": "ACCORD", "nickname": null, "middle_name": null, "last_name": "GROUP", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Working to increase authorized funding for migratory bird habitat conservation programs, including wetland, coastal and associated upland restoration and conservation programs. Working to build support for wildlife habitat conservation within proposed Great Lakes Restoration legislation. Working to offset effects of waterfowl habitat due to alternative energy development. Wetlands Loan Act and Duck Stamp legislation, HR 1916. Hunting access issues: the Hunting Heritage Protection Act, S1348 and HR3046.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10861, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "SUTHERLAND", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 10689, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTON", "nickname": null, "middle_name": "CHARLES", "last_name": "JAMES", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}, {"lobbyist": {"id": 50309, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "WRINN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 5 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 27.116ms