lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

10 rows where filing_uuid = "35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 10

filing_year 1

filing_period 1

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
2147405 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter CHM Toxic substances control reform, application of chemical regulations to children's and general use products, preemption, alignment of international chemical regulations Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147406 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter MAN Worker safety programs--value of those programs, ways to recognize and reward safe behaviors on the job Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147407 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter TRA Ports and customs reauthorization, CBP, trade enforcement and facilitation, port congestion, import surveillance, S. 1298 Thunes Ports Performance Bill; s. 1519 Senator Gardner's PPORTS Act; S. 1732 the Comprehensive Transportation and Consumer Protection Act of 2015. Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147408 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter TAX Independent contractors; deductibility of advertising expenses, tax relief and reform, proposed changes to estate taxes, opposition to the border adjustment tax proposal Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147409 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter SMB Independent contractors (maintain safe harbors) and use of promotional products as advertising media. Value of small businesses to the US economy. Outreach to the Senate Judiciary Committee regarding the impact of transparency related to the law enforcement act on small businesses. Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147410 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter HCR Wellness incentive programs, worker safety programs Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147411 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter CSP Consumer Product Safety Improvement Act of 2008: toys and children's product safety issues, recall elated issues, third party testing, enforcement, certification, product inspection. Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147412 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter TRD Renew and expand generalized system of preferences act; negotiations regarding new trade agreements including the TPP and T-TIP, focus on tariffs including China section 301 Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147413 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter LBR NLRB issues related to dual employer control over employees; DOL issues related to overtime rules Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00
2147414 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 35c6ec1f-e8a1-4e6c-96f4-6600ed5a34a6 Q2 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2018 second_quarter ADV Value and use of promotional products as advertising medium; tax deductions on advertising expenses Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Maritime Commission,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),U.S. Trade Representative (USTR),White House Office   95000 0 0 2018-07-17T14:02:24.667000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);