lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
18 rows where filing_uuid = "7fca7d2f-e8d1-4e13-a055-672ef1f88b33" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 666340 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | POS | S. 3536 International Mail Rates | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666341 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | TRU | HM-224CHM-224-EHM-206FPHMSA-2088-0075 HR 1401- Rail & Public Transportation Security Act of 2007 DHA Interim Final Rule - Chemical Facilities Highway Infrastructure Funding- NPRM (Dockets HM 224D, HM 215J, HM 232F) | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666342 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | AGR | USDA Loan Program | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666343 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | SMB | Small Business Health Plans | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666344 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | MMM | HR 6331 Durable Medical Equipment | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666345 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | AVI | -HR 2881 / S 1300 - FAA Reauthorization including aviation tax issues, labor law reform, war risk insurance and internation mail rate -HR 6984 - FAA Extension Act of 2008- Aviation Safety Issues- Proposed airlift agreement with DHL - Aviation Technology Issues-General Aviation Competition Matters-US-Brazil Negotiations - Airport issues, including congestion-US-EU Open Skies Agreement Second Stage Negotiations S 3536 International Mail Rate Issues UPS China Operations | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666346 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | FOO | FDA Inspectors at Louisville Hub | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666347 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | TOB | S.1027 Internet cigarette sales HR 4081 The PACT Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666348 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | ENG | S.2191 America's Climate Security Act of 2007 Renewable Energy and Engery Conversation Tax Act of 2008 - Fuel Cell- Alternative Fuel Vehicles- Hydraulic Hybrid- Hybrid Electric | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666349 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | BUD | Transportation, Housing and Urban Development and Related Agencies Appropriations Act 2009, including S 3261 | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666350 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | ENV | S.2191 America's Climate Security Act of 2007 | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666351 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | LBR | Railway Labor Act (FAA Reauthorization)- U.S. Labor Policy Express Carrier Provisions of Federal Labor Law- Employee Misclassification HR 3195 ADA Restoration Act HR 800 / S 1041 Employee Free Choice Act | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666352 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | PHA | HR 5839 Safeguarding America's Pharmaceuticals Act of 2008 Pedigree - pharmaceutical distribution On-line Pharmacy | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666353 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | HOM | HR 1413 and HR 5982 as relates to aviation security- TSA Final Rule Certified cargo screener program- TSA Security Programs (FACAOSSP) (IACSSP) Customs Postal Parity with Express Industry- Penalty Mitigation Responsible Supervision and Control Provisions- Brazil Express Delivery Services Modernization | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666354 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | HCR | ERISA ProtectionHealth IT E-prescribing | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666355 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | TRD | US-Korea FTA- US-Panama FTA- US-Columbia FTA | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666356 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | RRR | Government regulations on railroads | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 | |
| 666357 | UPS (UNITED PARCEL SERVICE) 7fca7d2f-e8d1-4e13-a055-672ef1f88b33 | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2008 | third_quarter | TRA | Aviation Transportation Service Agreements | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Executive Office of the President (EOP),Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),U.S. Customs & Border Protection | 1427517 | 0 | 0 | 2008-10-15T12:03:42-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
income_amount INTEGER,
expense_amount INTEGER,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);