home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 7fca7d2f-e8d1-4e13-a055-672ef1f88b33

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
7fca7d2f-e8d1-4e13-a055-672ef1f88b33 Q3 39223 UPS (UNITED PARCEL SERVICE) 147131 UPS (UNITED PARCEL SERVICE) 2008 third_quarter 2008-10-15T12:03:42-04:00 1427517.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/7fca7d2f-e8d1-4e13-a055-672ef1f88b33/", "filing_uuid": "7fca7d2f-e8d1-4e13-a055-672ef1f88b33", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2008, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/7fca7d2f-e8d1-4e13-a055-672ef1f88b33/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "1427517.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Sharen A. Kinney, Public Affairs Specialist", "dt_posted": "2008-10-15T12:03:42-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "316 Pa. Ave., SE", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20003", "registrant": {"id": 39223, "url": "https://lda.senate.gov/api/v1/registrants/39223/", "house_registrant_id": 30712, "name": "UPS (UNITED PARCEL SERVICE)", "description": null, "address_1": "316 Pennslyvani Avenue SE", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20003", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LISA POST", "contact_telephone": "+1 202-655-8439", "dt_updated": "2026-01-30T14:05:09.168549-05:00"}, "client": {"id": 147131, "url": "https://lda.senate.gov/api/v1/clients/147131/", "client_id": 12, "name": "UPS (UNITED PARCEL SERVICE)", "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": "POS", "general_issue_code_display": "Postal", "description": "S. 3536 International Mail Rates", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21798, "prefix": null, "prefix_display": null, "first_name": "NICHOLAS", "nickname": null, "middle_name": null, "last_name": "LEWIS", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "TRU", "general_issue_code_display": "Trucking/Shipping", "description": "HM-224CHM-224-EHM-206FPHMSA-2088-0075\nHR 1401- Rail & Public Transportation Security Act of 2007\nDHA Interim Final Rule - Chemical Facilities\nHighway Infrastructure Funding- NPRM (Dockets HM 224D, HM 215J, HM 232F)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 32926, "prefix": null, "prefix_display": null, "first_name": "LEO", "nickname": null, "middle_name": null, "last_name": "DIAZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43168, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "W", "last_name": "MEYERS", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21914, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "F", "last_name": "JENSEN", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "USDA Loan Program", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 12921, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "KIELY", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "Small Business Health Plans", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43168, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "W", "last_name": "MEYERS", "suffix": "jr", "suffix_display": "JR"}, "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "HR 6331 Durable Medical Equipment", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 12921, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "KIELY", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "-HR 2881 / S 1300 - FAA Reauthorization including aviation tax issues, labor law reform, war risk insurance and internation mail rate\n-HR 6984 - FAA Extension Act of 2008- Aviation Safety Issues- Proposed airlift agreement with DHL\n- Aviation Technology Issues-General Aviation Competition Matters-US-Brazil Negotiations\n- Airport issues, including congestion-US-EU Open Skies Agreement Second Stage Negotiations S 3536 International Mail Rate Issues\nUPS China Operations", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 12776, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "ALAGNA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35263, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 29809, "prefix": null, "prefix_display": null, "first_name": "SHERYL", "nickname": null, "middle_name": null, "last_name": "BONILLA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12921, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "KIELY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21798, "prefix": null, "prefix_display": null, "first_name": "NICHOLAS", "nickname": null, "middle_name": null, "last_name": "LEWIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 7446, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "RICHARDSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43187, "prefix": "mr", "prefix_display": "MR.", "first_name": "DONTAI", "nickname": null, "middle_name": "L", "last_name": "SMALLS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45280, "prefix": null, "prefix_display": null, "first_name": "VICTORIA", "nickname": null, "middle_name": null, "last_name": "KING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 39897, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "GOODWIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28974, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARCEL", "nickname": null, "middle_name": "J", "last_name": "DUBOIS", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "FDA Inspectors at Louisville Hub", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29809, "prefix": null, "prefix_display": null, "first_name": "SHERYL", "nickname": null, "middle_name": null, "last_name": "BONILLA", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "TOB", "general_issue_code_display": "Tobacco", "description": "S.1027 Internet cigarette sales\nHR 4081 The PACT Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 35263, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42631, "prefix": null, "prefix_display": null, "first_name": "GREG", "nickname": null, "middle_name": null, "last_name": "MAURER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42633, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NICOLE", "nickname": null, "middle_name": "CLIFTON", "last_name": "PIERRE", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "S.2191 America's Climate Security Act of 2007\nRenewable Energy and Engery Conversation Tax Act of 2008\n- Fuel Cell- Alternative Fuel Vehicles- Hydraulic Hybrid- Hybrid Electric", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 12776, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "ALAGNA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43168, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "W", "last_name": "MEYERS", "suffix": "jr", "suffix_display": "JR"}, "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Transportation, Housing and Urban Development and Related Agencies Appropriations Act 2009, including S 3261", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 35263, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "S.2191 America's Climate Security Act of 2007", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 12776, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "ALAGNA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39897, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "GOODWIN", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Railway Labor Act (FAA Reauthorization)- U.S. Labor Policy\nExpress Carrier Provisions of Federal Labor Law- Employee Misclassification\nHR 3195 ADA Restoration Act\nHR 800 / S 1041 Employee Free Choice Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29809, "prefix": null, "prefix_display": null, "first_name": "SHERYL", "nickname": null, "middle_name": null, "last_name": "BONILLA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28974, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARCEL", "nickname": null, "middle_name": "J", "last_name": "DUBOIS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 12921, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "KIELY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42631, "prefix": null, "prefix_display": null, "first_name": "GREG", "nickname": null, "middle_name": null, "last_name": "MAURER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42633, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NICOLE", "nickname": null, "middle_name": "CLIFTON", "last_name": "PIERRE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43168, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "W", "last_name": "MEYERS", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43187, "prefix": "mr", "prefix_display": "MR.", "first_name": "DONTAI", "nickname": null, "middle_name": "L", "last_name": "SMALLS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39897, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "GOODWIN", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "HR 5839 Safeguarding America's Pharmaceuticals Act of 2008\nPedigree - pharmaceutical distribution\nOn-line Pharmacy", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43168, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "W", "last_name": "MEYERS", "suffix": "jr", "suffix_display": "JR"}, "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "HR 1413 and HR 5982 as relates to aviation security- TSA Final Rule\nCertified cargo screener program- TSA Security Programs (FACAOSSP) (IACSSP)\nCustoms Postal Parity with Express Industry- Penalty Mitigation\nResponsible Supervision and Control Provisions- Brazil Express Delivery Services Modernization", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 32926, "prefix": null, "prefix_display": null, "first_name": "LEO", "nickname": null, "middle_name": null, "last_name": "DIAZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 7446, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "RICHARDSON", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "ERISA ProtectionHealth IT\nE-prescribing", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 12921, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "KIELY", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "US-Korea FTA- US-Panama FTA- US-Columbia FTA", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 30671, "prefix": null, "prefix_display": null, "first_name": "SELINA", "nickname": null, "middle_name": null, "last_name": "JACKSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43168, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "W", "last_name": "MEYERS", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43187, "prefix": "mr", "prefix_display": "MR.", "first_name": "DONTAI", "nickname": null, "middle_name": "L", "last_name": "SMALLS", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "RRR", "general_issue_code_display": "Railroads", "description": "Government regulations on railroads", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21914, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "F", "last_name": "JENSEN", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Aviation Transportation Service Agreements", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 35263, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "BERGMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43168, "prefix": null, "prefix_display": null, "first_name": "CHARLES", "nickname": null, "middle_name": "W", "last_name": "MEYERS", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39897, "prefix": null, "prefix_display": null, "first_name": "MARK", "nickname": null, "middle_name": null, "last_name": "GOODWIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42633, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NICOLE", "nickname": null, "middle_name": "CLIFTON", "last_name": "PIERRE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 7446, "prefix": null, "prefix_display": null, "first_name": "DANA", "nickname": null, "middle_name": null, "last_name": "RICHARDSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 42631, "prefix": null, "prefix_display": null, "first_name": "GREG", "nickname": null, "middle_name": null, "last_name": "MAURER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 21798, "prefix": null, "prefix_display": null, "first_name": "NICHOLAS", "nickname": null, "middle_name": null, "last_name": "LEWIS", "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": 172, "name": "Federal Aviation Administration (FAA)"}, {"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"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 204, "name": "Transportation Security Administration (TSA)"}, {"id": 184, "name": "U.S. Customs & Border Protection"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 18 rows from filing_uuid in lobbying_activities
  • 16 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 0.955ms