home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9ae6e5d1-7665-4d77-86ad-d7e281393157

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
9ae6e5d1-7665-4d77-86ad-d7e281393157 Q2 71278 LEAGUE OF CONSERVATION VOTERS 165412 LEAGUE OF CONSERVATION VOTERS 2019 second_quarter 2019-07-11T15:05:53.853000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9ae6e5d1-7665-4d77-86ad-d7e281393157/", "filing_uuid": "9ae6e5d1-7665-4d77-86ad-d7e281393157", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2019, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/9ae6e5d1-7665-4d77-86ad-d7e281393157/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "110000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Kevin O'Brien", "dt_posted": "2019-07-11T15:05:53.853000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "740 15th Street NW", "registrant_address_2": "Suite 700", "registrant_different_address": true, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 71278, "url": "https://lda.senate.gov/api/v1/registrants/71278/", "house_registrant_id": 35998, "name": "LEAGUE OF CONSERVATION VOTERS", "description": null, "address_1": "740 15th Street NW", "address_2": "Suite 700", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ASHLEY MOREHOUSE", "contact_telephone": "+1 202-785-8683", "dt_updated": "2026-01-30T13:53:08.828989-05:00"}, "client": {"id": 165412, "url": "https://lda.senate.gov/api/v1/clients/165412/", "client_id": 12, "name": "LEAGUE OF CONSERVATION VOTERS", "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": "2007-08-10"}, "lobbying_activities": [{"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Oppose EPAs roll back of the clean car standards.\n \nOppose EPAs repeal of the Clean Power Plan.\n \nComment on the implementation of the Frank Lautenberg for the 21st Century Act (EPA).\n \nOppose changes to National Oceanic and Atmospheric Administrations (NOAA) current regulatory processes.\n \nOppose CEQ rulemaking and revisions to the National Environmental Policy Act (NEPA).\n \nOppose EPA proposed rule, Strengthening Transparency in Regulatory Science.\n\nSupport H.R. 3055, the Commerce, Justice, Science, Agriculture, Rural Development, Food and Drug Administration, Interior, Environment, Military Construction, Veterans Affairs, Transportation, and Housing and Urban Development Appropriations Act, 2020, which would increase investments to fight climate change, protect communities from toxic pollution, protect our lands and waters, cut air pollution, and boost clean energy.\n\nSupport H.R. 2740, the Labor, Health and Human Services, Education, Legislative Branch, Defense, State, Foreign Operations, and Energy and Water Development Appropriations Act, 2020, which would increase investments to fight climate change and boost clean energy. \n\nUrge EPA to ban commercial use of methylene chloride-based paint strippers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24539, "prefix": null, "prefix_display": null, "first_name": "TIERNAN", "nickname": null, "middle_name": null, "last_name": "SITTENFELD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48530, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "CHIEFFO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53122, "prefix": null, "prefix_display": null, "first_name": "ALEX", "nickname": null, "middle_name": null, "last_name": "TAUREL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58386, "prefix": "ms", "prefix_display": "MS.", "first_name": "MADELEINE", "nickname": null, "middle_name": "JUSTINE", "last_name": "FOOTE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66658, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "JORDAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70951, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": "H", "last_name": "DAVIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Oppose all ideological anti-environmental policy riders and support a clean Fiscal Year 2020 appropriations package. \n \nOppose Barry Myerss nomination to be Administrator of NOAA.\n \nOppose the United States-Mexico-Canada Agreement, which does not include strong environmental and worker protections.\n \nOppose Heidi Kings nomination for Administrator of the National Highway Traffic Safety Administration.\n \nOppose Peter Wrights nomination for EPA Office of Land and Emergency Management.\n \nOppose Patrick Wyricks nomination to the US District Court for the Western District of Oklahoma.\n\nSupport H.R. 1 and S. 949, For the People Act of 2019, which would strengthen voting rights, increase transparency and fairness in our campaign finance system, and improve ethics laws. \n\nOppose Michael Truncales nomination to the US District Court for the Eastern District of Texas.\n\nOppose Kenneth Lees nomination to the US Court of Appeals for the Ninth Circuit.\n\nOppose J. Campbell Barkers nomination to the US District Court for the Eastern District of Texas.\n\nOppose Daniel Collins nomination to the US Court of Appeals for the Ninth Circuit.\n\nOppose Daniel Bress nomination to the US Court of Appeals for the Ninth Circuit.\n\nOppose David Bernhardts nomination for Interior Secretary. \n\nSupport H.R. 6, the American Dream and Promise Act of 2019, which would provide permanent protections for Dreamers, Temporary Protected Status (TPS), and Deferred Enforced Departure (DED) holders.\n\nOppose Andrew Brashers nomination to the US District Court for the Middle District of Alabama.\n\nOppose Matthew Kacsmaryks nomination to the US District Court for the Northern District of Texas.\n\nSupport H.R.51, the Washington, D.C. Admission Act, which would admit the District of Columbia as the 51st state in the Union.\n\nOppose Daniel Jorjanis nomination for Solicitor of the Department of the Interior.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24539, "prefix": null, "prefix_display": null, "first_name": "TIERNAN", "nickname": null, "middle_name": null, "last_name": "SITTENFELD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48530, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "CHIEFFO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53122, "prefix": null, "prefix_display": null, "first_name": "ALEX", "nickname": null, "middle_name": null, "last_name": "TAUREL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58386, "prefix": "ms", "prefix_display": "MS.", "first_name": "MADELEINE", "nickname": null, "middle_name": "JUSTINE", "last_name": "FOOTE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66658, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "JORDAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69960, "prefix": null, "prefix_display": null, "first_name": "BENJAMIN", "nickname": null, "middle_name": "J", "last_name": "DRISCOLL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70951, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": "H", "last_name": "DAVIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Oppose undermining ozone clean air protections (EPA).\n \nOppose the administrations Dirty Water Rule, which would gut Clean Water Act protections for streams and wetlands and jeopardize our drinking water. \n \nSupport stronger regulation of PFAS by the administration.\n\nSupport, S. 1790, the 2020 National Defense Authorization Acts provision to end the use of PFAS based foams on military installations by 2023.\n\nSupport Rep. Schrier amendment to H.R. 3055, to stop the EPA roll back of the Mercury and Air Toxics Standards (MATS).\n\nSupport request for extension of comment period for the Study of Oil and Gas Extraction Wastewater Management Under the Clean Water Act.\n\nUrge EPA to withdraw its interpretive statement exempting point source pollution discharges through groundwater to surface water from Clean Water Act (CWA) protections.\n\nUrge EPA to disclose 24 studies on Pigment Violet 29 (PV29) under the Toxic Substances Control Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24539, "prefix": null, "prefix_display": null, "first_name": "TIERNAN", "nickname": null, "middle_name": null, "last_name": "SITTENFELD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48530, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "CHIEFFO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53122, "prefix": null, "prefix_display": null, "first_name": "ALEX", "nickname": null, "middle_name": null, "last_name": "TAUREL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58386, "prefix": "ms", "prefix_display": "MS.", "first_name": "MADELEINE", "nickname": null, "middle_name": "JUSTINE", "last_name": "FOOTE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66658, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "JORDAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70951, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": "H", "last_name": "DAVIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Support the Endangered Species Act, which is facing unprecedented threats.\n \nOppose the Interior Departments recommendations regarding rescinding or shrinking national monument protections.\n \nSupport S. 367 and H.R. 1050, the ANTIQUITIES ACT, which codifies existing, presidentially-designated national monuments.\n \nSupport the Migratory Bird Treaty Act (MBTA), which encourages bird conservation.\n \nOppose attempts to exempt the Tongass National Forest in Alaska from the Roadless Area Conservation Rule.\n \nOppose mineral development authorizations in Minnesotas Superior National Forest during an ongoing study of a proposed mineral withdrawal within the Rainy River watershed.\n \nRequest extension of comment period for Endangered Species Act rules proposed by the Department of the Interior and the Department of Commerce.\n\nOppose proposed rulemaking, which would revise the National Park Services protest permitting process regarding demonstrations at the National Mall, Memorial Parks, and Presidents Park.\n\nOppose any new or amended proclamation by President Trump that weakens or removes protections of the Northeast Canyons and Seamounts Marine National Monument from extractive activities.\n\nSupport, amendment from Rep. Huffman to H.R. 2740, which would prohibit the U.S. Army Corps of Engineers from finalizing the Environmental Impact Statement (EIS) for Pebble Mine in Bristol Bay, Alaska.\nOppose, amendment from Rep. Duncan to H.R. 3055 to strike a provision that would block oil and gas lease sales in the Refuge by ensuring that the sales are compliant with the 2017 Tax Act. \n\nOppose Rep. Golden amendment to H.R. 3055 to weaken protections for critically endangered North Atlantic right whales.\n\nSupport Amendment 514 to S. 1790, the National Defense Authorization Act for FY 2020, which would prohibit the use of national defense funds for the construction of walls along the southern border.\n\nSupport H.R. 3195 and S. 1081, which provide the Land and Water Conservation Fund with full, permanent, and dedicated funding.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24539, "prefix": null, "prefix_display": null, "first_name": "TIERNAN", "nickname": null, "middle_name": null, "last_name": "SITTENFELD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48530, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "CHIEFFO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53122, "prefix": null, "prefix_display": null, "first_name": "ALEX", "nickname": null, "middle_name": null, "last_name": "TAUREL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58386, "prefix": "ms", "prefix_display": "MS.", "first_name": "MADELEINE", "nickname": null, "middle_name": "JUSTINE", "last_name": "FOOTE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66658, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "JORDAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70951, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": "H", "last_name": "DAVIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Oppose the expansion of new offshore drilling by the Department of the Interior.\n \nOppose attempts to fast-track oil and gas leasing on the Coastal Plain of the Arctic National Wildlife Refuge.\n\nSupport H.R.1146, Arctic Cultural and Coastal Plain Protection Act, which would restore protections for the coastal plain of the Arctic National Wildlife Refuge. \n\nOppose legislative efforts to include funding for restarting the licensing process for the proposed Yucca Mountain nuclear waste repository.\n \nSupport H.R. 9, the Climate Action Now Act, which would honor Americas commitments to the Paris Climate Agreement.\n\nSupport lifting the caps on discretionary spending in FY 2020 and FY2021.\n\nSupport modifying and extending tax credits for clean energy sources.\n\nSupport the Driving America Forward Act, which would expand the electric vehicle and hydrogen fuel cell tax credit.\n\nSupport the Rural Energy for America Program, which invests in renewable energy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 24539, "prefix": null, "prefix_display": null, "first_name": "TIERNAN", "nickname": null, "middle_name": null, "last_name": "SITTENFELD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48530, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "CHIEFFO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53122, "prefix": null, "prefix_display": null, "first_name": "ALEX", "nickname": null, "middle_name": null, "last_name": "TAUREL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 58386, "prefix": "ms", "prefix_display": "MS.", "first_name": "MADELEINE", "nickname": null, "middle_name": "JUSTINE", "last_name": "FOOTE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66658, "prefix": null, "prefix_display": null, "first_name": "SARA", "nickname": null, "middle_name": null, "last_name": "JORDAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70951, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": "H", "last_name": "DAVIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 35998 DC DC US US   0 0           110000.0

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 7 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.748ms · Privacy