lobbying_filings_raw: 908eae0e-aa41-4e8b-9acb-d555b07a0bea

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
908eae0e-aa41-4e8b-9acb-d555b07a0bea	Q2	2285	AMERICAN FARM BUREAU FED	103543	AMERICAN FARM BUREAU FED	2022	second_quarter	2022-07-19T12:16:10-04:00	680000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/908eae0e-aa41-4e8b-9acb-d555b07a0bea/", "filing_uuid": "908eae0e-aa41-4e8b-9acb-d555b07a0bea", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2022, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/908eae0e-aa41-4e8b-9acb-d555b07a0bea/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "680000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Travis Cushman", "dt_posted": "2022-07-19T12:16:10-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "600 MARYLAND AVENUE, SW", "registrant_address_2": "Ste. 1000W", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20024", "registrant": {"id": 2285, "url": "https://lda.senate.gov/api/v1/registrants/2285/", "house_registrant_id": 31020, "name": "AMERICAN FARM BUREAU FED", "description": null, "address_1": "600 Maryland Avenue SW", "address_2": "Suite 1000W", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20024", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TRAVIS CUSHMAN", "contact_telephone": "+1 202-406-3618", "dt_updated": "2026-01-29T10:57:12.273486-05:00"}, "client": {"id": 103543, "url": "https://lda.senate.gov/api/v1/clients/103543/", "client_id": 12, "name": "AMERICAN FARM BUREAU FED", "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-06"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "GIPSA-Farm Fair Practices Rule Farm Bill Protection of farmer and rancher data AMS-Mandatory Price Reporting Conservation Compliance Wetland & Highly erodible land CFTC price volatility oversight Cell-Base Protein NEPA EPA Approps CFAP CCC Conservation Program implementation Conservation Stewardship Program (CSP) Conservation Reserve Program (CRP) Growing Climate Solutions Act, S.1251, H.R. 2820 Climate Smart Agriculture Supply Chain H.R. 7606 - Lower Food & Fuels Cost Act Crop Insurance Livestock", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70419, "prefix": null, "prefix_display": null, "first_name": "TRAVIS", "nickname": null, "middle_name": null, "last_name": "CUSHMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 75358, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": null, "last_name": "MYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107001, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": "MATTHEW", "last_name": "MUNCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 119535, "prefix": null, "prefix_display": null, "first_name": "ROGER", "nickname": null, "middle_name": null, "last_name": "CRYAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 139119, "prefix": "mr", "prefix_display": "MR.", "first_name": "BERNT", "nickname": null, "middle_name": "LOUIS", "last_name": "NELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 138580, "prefix": null, "prefix_display": null, "first_name": "RUDOLPH", "nickname": null, "middle_name": "THEODORE", "last_name": "LAYHER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "Legislative Assistant, Rep. Greg Steube", "new": true}, {"lobbyist": {"id": 119541, "prefix": null, "prefix_display": null, "first_name": "COURTNEY", "nickname": null, "middle_name": null, "last_name": "BRIGGS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "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": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ANI", "general_issue_code_display": "Animals", "description": "General Concerns on Welfare of Livestock Gene editing H.R. 4140, Butcher Block Act H.R. 3766, Optimizing the Cattle Markets Act of 2021 S.3229, Cattle Price Discovery and Transparency Act S.4030 - The Cattle Price Discovery & Transparency Act S. 3870 - The Meat and Poultry Special Investigator Act S. 2732 - The John Stringer Rainey Save America's Forgotten Equines (SAFE) Act H.R. 3355 - The Save America's Forgotten Equines (SAFE) Act of 2021 S. 3678 - The Beagle Brigade Act of 2022", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 139119, "prefix": "mr", "prefix_display": "MR.", "first_name": "BERNT", "nickname": null, "middle_name": "LOUIS", "last_name": "NELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 138580, "prefix": null, "prefix_display": null, "first_name": "RUDOLPH", "nickname": null, "middle_name": "THEODORE", "last_name": "LAYHER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": "Legislative Assistant, Rep. Greg Steube", "new": true}, {"lobbyist": {"id": 107018, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": "LYNNE", "last_name": "HAGENAUER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Agriculture, Rural Development, FDA Appropriations Interior-Environment Appropriations, Waters of the US Implementation, CERCLA, NPDES Permit Terms Energy and Water Development Electronic Logging Device/Hours of Service/Transportation Housing and Urban Development Act FY 22 Budget reconciliation legislation (Build Back Better Act, H.R. 5376)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 739, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "J", "last_name": "SALMONSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70419, "prefix": null, "prefix_display": null, "first_name": "TRAVIS", "nickname": null, "middle_name": null, "last_name": "CUSHMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 106984, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BUCKMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138153, "prefix": "mr", "prefix_display": "MR.", "first_name": "DUSTIN", "nickname": null, "middle_name": null, "last_name": "SHERER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 119541, "prefix": null, "prefix_display": null, "first_name": "COURTNEY", "nickname": null, "middle_name": null, "last_name": "BRIGGS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 75358, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": null, "last_name": "MYERS", "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": "Repeal of the Navigable Waters Protection Rule Clean Water Act - Implementation of the Navigable Waters Protection Rule (NWPR) Clean Water Act - Senate and House resolutions opposing NWPR Clean Water Act- Senate and House legislation on trading and other market-based incentives WRDA Water Resources Development Act - NPDES Permit Terms Biogenic CO2", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 69848, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "RANDALL", "last_name": "DWYER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70419, "prefix": null, "prefix_display": null, "first_name": "TRAVIS", "nickname": null, "middle_name": null, "last_name": "CUSHMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 119541, "prefix": null, "prefix_display": null, "first_name": "COURTNEY", "nickname": null, "middle_name": null, "last_name": "BRIGGS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51083, "prefix": null, "prefix_display": null, "first_name": "CODY", "nickname": null, "middle_name": null, "last_name": "LYON", "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": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "Pesticide Availability Biological Evaluations FIFRA preemption", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71276, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "CRITTENDEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 119535, "prefix": null, "prefix_display": null, "first_name": "ROGER", "nickname": null, "middle_name": null, "last_name": "CRYAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107018, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": "LYNNE", "last_name": "HAGENAUER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Renewable Fuel Standard/Renewable Volume Obligation Production Tax Credits for Renewable Fuels and Renewable Energy E15 availability Encourage domestic energy production", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 75358, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": null, "last_name": "MYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "FDA enforcement of standards of identity regulations Need to Buy American (food procurement for schools and institutions) H.R. 1861,The Whole Milk for Healthy Kids Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "Biodiesel Tax Credits Renewable Fuel Standard High Octane Blends Renewable Volume Obligations E15 availability Encourage domestic energy production", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 75358, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": null, "last_name": "MYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "General Immigration Reform H-2A Legislative Reforms H.R. 1603, Farm Workforce Modernization Act H2A regulatory reforms and implementation H2B regulatory and legislative reforms Border Security", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71276, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "CRITTENDEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Promote farm safety Canadian Pacific Labor Negotiations West Coast Ports Labor Negotiations Rail Labor Negotiations", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71276, "prefix": null, "prefix_display": null, "first_name": "ALLISON", "nickname": null, "middle_name": null, "last_name": "CRITTENDEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Snake River Corps Dams America the Beautiful Initiative America Competes Act-Lacey Act provisions", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70419, "prefix": null, "prefix_display": null, "first_name": "TRAVIS", "nickname": null, "middle_name": null, "last_name": "CUSHMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107018, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": "LYNNE", "last_name": "HAGENAUER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 119541, "prefix": null, "prefix_display": null, "first_name": "COURTNEY", "nickname": null, "middle_name": null, "last_name": "BRIGGS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 142, "name": "U.S. Fish & Wildlife Service (USFWS)"}, {"id": 212, "name": "U.S. Forest Service"}]}, {"general_issue_code": "RES", "general_issue_code_display": "Real Estate/Land Use/Conservation", "description": "Western Water Infrastructure - Implementation of P.L.117-58 America the Beautiful Initiative The 1031 Like/Kind Exchange Tax Provisions H.R. 5376, The Build Back Better Act S. 173 CORE Act Wild Horse and Burro Management S. 177 - Cerro de la Olla Wilderness Establishment Act S. 455 Wild Olympics Wilderness and Wild and Scenic Rivers Act S. 1264, the RANCH Act S. 1321 Casa Grande Ruins National Monument Boundary Modification Act of 2021 S. 1538 Smith River National Recreation Area Expansion Act S. 1769 Rim of the Valley Corridor Preservation Act S. 2568/HR 4832 Open Access Evapotranspiration Data Act S. 2980, the Wildlife-Livestock Conflict Resolution Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107018, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": "LYNNE", "last_name": "HAGENAUER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138153, "prefix": "mr", "prefix_display": "MR.", "first_name": "DUSTIN", "nickname": null, "middle_name": null, "last_name": "SHERER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "Reduce Frequency of Railroad Delays STB Nominees/STB/Rail Safety", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107001, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": "MATTHEW", "last_name": "MUNCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 181, "name": "Surface Transportation Board (STB)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Renewable Energy Tax Credits - Wind, solar, Biogas Like Kind Exchange (Section 1031) Capital Gains Taxes + Stepped-up Basis Estate Tax Repeal Reform Cost Recovery and Depreciation Issues Extend Bonus Depreciation Business Income Deduction Taxation of Mutual Irrigation Companies Corporate Tax Rate For the 99.5 Percent Act, S. 994 Sensible Taxation & Equity Promotion Act FY 22 Budget Reconciliation Legislation (Build Back Better Act, H.R. 5376)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 119535, "prefix": null, "prefix_display": null, "first_name": "ROGER", "nickname": null, "middle_name": null, "last_name": "CRYAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138153, "prefix": "mr", "prefix_display": "MR.", "first_name": "DUSTIN", "nickname": null, "middle_name": null, "last_name": "SHERER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "FCC Order on Lightsquared/Ligado S.2166/H.R. 4634, the Recognizing and Ensuring Taxpayer Access to Infrastructure Necessary for GPS and Satellite Communications Act Implementation of H.R. 3684, Infrastructure Investment and Jobs Act: Broadband Provisions Right to Repair S. 3549, Agricultural Right to Repair Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 106984, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "BUCKMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 207, "name": "U.S. Copyright Office"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Implementation of Phase I of US-China Trade Agreement US trade negotiations with other nations (United Kingdom, Kenya, Japan, etc.) The Comprehensive and Progressive Agreement for Trans-Pacific Partnership (CPTPP) America COMPETES Act Indo-Pacific Strategy", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 739, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "J", "last_name": "SALMONSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 119535, "prefix": null, "prefix_display": null, "first_name": "ROGER", "nickname": null, "middle_name": null, "last_name": "CRYAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "FMCSA rule on Hours of Service (HOS)-livestock exemption Future highway and transportation funding Electronic Logging Devices Hours of Service Regulations during Coronavirus Emergency Shipping Act and shipping delays (Congress and Federal Maritime Commission) Infrastructure H.R. 3684 - The Infrastructure Investment Jobs Act implementation Supply Chain Entry-Level Driver Training Water Resources Development Act Ocean Shipping Reform Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55892, "prefix": "mr", "prefix_display": "MR.", "first_name": "DALE", "nickname": null, "middle_name": "W", "last_name": "MOORE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60307, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "RANDOLPH", "last_name": "YATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 102519, "prefix": null, "prefix_display": null, "first_name": "SAMUEL", "nickname": null, "middle_name": "A.", "last_name": "KIEFFER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107001, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": "MATTHEW", "last_name": "MUNCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67268, "prefix": null, "prefix_display": null, "first_name": "VERONICA", "nickname": null, "middle_name": "NIGH", "last_name": "SWERDLOW", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 119535, "prefix": null, "prefix_display": null, "first_name": "ROGER", "nickname": null, "middle_name": null, "last_name": "CRYAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 172, "name": "Federal Aviation Administration (FAA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 247, "name": "Pipeline & Hazardous Materials Safety Administration"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "General Concerns of Reporting Requirements on Farms and Ranches", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70419, "prefix": null, "prefix_display": null, "first_name": "TRAVIS", "nickname": null, "middle_name": null, "last_name": "CUSHMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 75358, "prefix": null, "prefix_display": null, "first_name": "SHELBY", "nickname": null, "middle_name": null, "last_name": "MYERS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 55657, "prefix": "mr", "prefix_display": "MR.", "first_name": "ANDREW", "nickname": null, "middle_name": "THOMAS", "last_name": "WALMSLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 51083, "prefix": null, "prefix_display": null, "first_name": "CODY", "nickname": null, "middle_name": null, "last_name": "LYON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	31020	DC	DC	US	US		0	0	574318		normalized_name_state	0.9

Links from other tables

18 rows from filing_uuid in lobbying_activities
19 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs