home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 0db3aa8b-84ed-4091-bc92-71b8ccf5f814

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
0db3aa8b-84ed-4091-bc92-71b8ccf5f814 Q4 27913 THE NATIONAL GRANGE OF THE ORDER OF PATRONS OF HUSBANDRY 134471 NATIONAL GRANGE OF THE ORDER OF PATRONS OF HUSBANDRY 2009 fourth_quarter 2010-01-13T15:30:01.893000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0db3aa8b-84ed-4091-bc92-71b8ccf5f814/", "filing_uuid": "0db3aa8b-84ed-4091-bc92-71b8ccf5f814", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2009, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0db3aa8b-84ed-4091-bc92-71b8ccf5f814/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Ed Luttrell - Master (President)", "dt_posted": "2010-01-13T15:30:01.893000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1616 H Street, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 27913, "url": "https://lda.senate.gov/api/v1/registrants/27913/", "house_registrant_id": 32114, "name": "THE NATIONAL GRANGE OF THE ORDER OF PATRONS OF HUSBANDRY", "description": null, "address_1": "1616 H STREET, NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRISTINE E. HAMP", "contact_telephone": "+1 202-628-3507", "dt_updated": "2026-02-04T09:32:02.855302-05:00"}, "client": {"id": 134471, "url": "https://lda.senate.gov/api/v1/clients/134471/", "client_id": 12, "name": "NATIONAL GRANGE OF THE ORDER OF PATRONS OF HUSBANDRY", "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-07-27"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Federal Agriculture Improvement Reform Act\nRisk Management\nCountry of Origin Labeling\nAnimal Identification Agribusiness Mergers\nAnimal Health\nCommodity Futures Act Reauthorization\nMarket Access Program\nFarmers Market Promotion Program\nMilk Income Loss Contract Program\n2008 Farm Bill\nInterstate Sales of State Inspected Meat and Poultry", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Intermodal Surface Transportation Legislation (SAFETEA-LU)\nRailroad Mergers\nPorts and Rivers Commercial Transportation\nEssential Air Services (EAS) Federal Aviation Administration Reauthorization", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "American Reinvestment and Recovery Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Endangered Species Act\nFarmland Preservation\nNational Parks and Forests", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "Rural Public Safety\nControlling Methamphetamine\nCrime Victims Fund\nPlumb Island Animal Disease Center", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "Media Consolidation/Concentration\nUniversal Service Fund\nRural Telephone Service\nDigital TV Transition Video Franchise", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Social Security Reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "Telemedicine\nRural Broadband Deployment\nNetwork Neutrality", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Rural Health\nReimportation of Pharmaceuticals\nNational Health Care Reform\nAssociation Health Plans", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Reform of Medicare/Medicaid System\nMedicare Part D", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Motor Vehicle Owners Right to Repair Legislation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "World Trade Organization Negotiations\nUS-Columbia Trade Agreement\nUS-South Korea Trade Agreement\nArgentine Sovereign Debt Repudation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "Flag Protection\nOfficial Language - English", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Estate Tax\nFarm Property Sales Tax\nTax Credits for Farm Preservation\nCapital Gains Tax Earned Income Tax Credits\nBeginning Farmer Tax Incentives\nRenewable Energy and Conservation Tax Credits\nEndangered Species Tax Credits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Alternative/Renewable Fuels\nGreenhouse Gases Emission/Climate Change\n25 x 25' Resolution\nCorporate Average Fuel Economy Standards", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Immigration Reform\nLegal Farm Workers\nH2A Reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "Truth in Advertising/Food Safety", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Equity for Rural Schools\nSecure Rural Schools and Communitites Act\nNo Child Left Behind Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Clean Air Act\nClean Water Act\nSafe Drinking Water Act\nSpill Prevention Control and Countermeasures Program", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26662, "prefix": null, "prefix_display": null, "first_name": "LEROY", "nickname": null, "middle_name": null, "last_name": "WATSON", "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": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 64, "name": "Federal Trade Commission (FTC)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 112, "name": "Natl Telecommunications & Information Administration (NTIA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 32114 DC DC US US   0 0           10000.0

Links from other tables

  • 19 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.356ms · Privacy