lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2030900 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | TRA | - Surface transportation infrastructure funding. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030901 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | TAX | - Advocating for comprehensive tax reform. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030902 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | RET | - MEPPRA Funding - advocate for multi-employer pension reform. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030903 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | HCR | - Discussions re: Reinsurance/Market Stabilization | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030904 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | VET | - Advocate for employment of veterans. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030905 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | LBR | - Educating and commenting on the Fair Labor Standards Act as it relates to overtime reform. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030906 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | TRD | - Advocate for President's Advisory Council on Doing Business in Africa to remain intact. - HR1057/S372 To amend the Tariff Act of 1930 to ensure that merchandise arriving through the mail shall be subject to review by U.S. Customs and Border Protection and to require the provision to advance electronic information on shipments of mail to U.S. Customs and Border Protection and for other purposes. - Advocate against 30% cut to State Dept. and USAID budget. - Advocate for customs parity with global posts; reduction of burdensome new cross-border date rules; and cross-border process improvement focused on minimizing cost and processing time. - Educate USTR on priorities. - Advocate for NAFTA modernization, Trade in Services Agreement, WTO Trade facilitation implementation. general trade policy. - Strategy and messaging on international trade and investment policy submissions. - Educate on U.S. multilateral trade policy and NAFTA, Trade in Services Agreement, WTO trade facilitation implementation and general trade policy. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030907 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | AVI | - S.1405/HR2997 "FAA Reauthorization" work to achieve a multi-year bill which provides certainty and moves our aviation system towards modernization, limits unnecessary regulations, allows the system to accommodate expected growth, and improves safety and fuel efficiency. Interest relating to Air Traffic Control Funding and Federal preemption of Motor Carrier State meal/rest break laws. - Advance air cargo priorities in air traffic control reform (no weight in user fees). - Harmonizing rules for air shipment of Lithium batteries. - Advance opportunities for unmanned aerial systems. - Oppose unnecessary and harmful amendments to apply flight and duty rules to cargo pilots. - Support for U.S. Open Skies | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030908 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | HOM | - HR1057/S372 - To amend the Tariff Act of 1930 to ensure that merchandise arriving through the mail shall be subject to review by U.S. Customs and Border Protection and to require the provision of advance electronic information on shipments of mail to U.S. Customs and Border Protection and for other purposes. - Cargo security screening, including data rules and screening processes. - Work on general customs modernization/trade facilitation policy to improve current regime. Customs parity regarding foreign posts. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030909 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | POS | - HR756 "Postal Service Reform Act of 2017", educating Congress on UPS's position. - S.372/HR1057 "Synthetics Trafficking and Overdose Prevention Act" - advocate for passage of legislation to prevent shipment of synthetic drugs from foreign posts. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030910 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | TRU | - HR3388/S1885 "The AV START ACT" as it relates to including trucks in Senate autonomous vehicle legislation and regulatory framework. FY'19 THUD Appropriations relating to commercial vehicle trailer length. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-04:00 | |
| 2030911 | UPS (UNITED PARCEL SERVICE) 3cf40ebe-d94f-4e1d-bdc2-ffe1123734ee | Q3 | UPS (UNITED PARCEL SERVICE) | 39223 | UPS (UNITED PARCEL SERVICE) | 2017 | third_quarter | MMM | - HR 1122 "SPARC Act" to amend title XVIII of the Social Security Act to provide for clarification and rationalization of Medicare prescription drug plan recovery rules for certain claims relating to UPS cost reduction. | Commerce, Dept of (DOC),Defense, Dept of (DOD),Food & Drug Administration (FDA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Customs & Border Protection,U.S. Trade Representative (USTR),White House Office | 1384181 | 0 | 0 | 2017-10-18T16:22:26.480000-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);