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

12 rows where filing_uuid = "1067f651-e76f-4c72-ae4e-0b0089d5678e" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 12

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
924754 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter CON H.R. 1020/S. 931, the Arbitration Fairness Act Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924755 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter FOO H.R. 1398 & S. 558, Labeling Education and Nutrition Act H.R. 2426, Menu Education and Labeling Act Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924756 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter FIN Increase transparency and improve conditions for small business merchants dealing with credit card agencies S. 414, the Credit CARD Act; H.R. 627 & S. 235, Credit Cardholders' Bill of Rights Act; H.R. 3126, Consumer Financial Protection Agency Act; S. 1212 & H.R. 2695, Credit Card Fair Fee Act; H.R. 2382, Credit Card Interchange Fees Act. Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924757 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter TAX Estate tax repeal; H.R. 1083, the Business Activity Tax Simplification Act (BATSA); H.R. 2672, the Help Veterans Own Franchises Act; H.R. 273, 15-year depreciation schedule for restaurants; Extend expiring small business tax credits; H.R. 4154, Permanent Estate Tax Relief for Families, Farmers, and Small Businesses Act; H.R. 3905, the Estate Tax Relief Act; H.R. 4306, permanently extend 15 year depreciation for restaurants/retail Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924758 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter HCR Legislative initiatives to make access and affordability easier for small businesses such as Small Business Health Plans, expansion of Health Savings Accounts and Health IT. H.R. 3200/S. 1679, Affordable Health Choices Act; America's Healthy Future Act; H.R. 3590, the Patient Protection and Affordable Care Act; H.R. 4872, the Health Care and Education Reconciliation Act Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924759 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter POS Prevent enactment of legislation restricting use of direct mail advertising (Do Not Mail legislation) Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924760 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter VET H.R. 942, the Veteran's Self-Employment Act H.R. 2672, the Help Veterans Own Franchises Act Efforts to encourage veteran's ownership of franchised businesses Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924761 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter SMB Extension of expiring SBA provisions in H.R. 1, American Recovery & Reinvestment Act; H.R. 2352, Job Creation Through Entrepreneurship Act; Expand capital access programs; S. 2869/H.R. 4302, the Small Business Job Creation and Access to Capital Act. Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924762 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter ENG H.R. 2454, the American Clean Energy and Security Act of 2009 Clean Energy Jobs and American Power Act Cap and trade issues Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924763 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter IMM H.R. 1934, American Job and Seasonal Business Preservation Act; H.R. 1136, Save our Small & Seasonal Businesses Act; S. 388, Save our Small & Seasonal Businesses Act; DHS E-Verify "no-match" regulations; Comprehensive Immigration Reform; Promote foreign franchisees ability to obtain "business tourist" visas for U.S. training. Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924764 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter TOU S. 1023/H.R. 2935, the Travel Promotion Act; Efforts to promote and encourage travel & tourism industry; Western Hemisphere Travel Initiative; H.R. 2410, Foreign Relations Authorization Act Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-04:00
924765 INTERNATIONAL FRANCHISE ASSOCIATION 1067f651-e76f-4c72-ae4e-0b0089d5678e Q1 INTERNATIONAL FRANCHISE ASSOCIATION 47872 INTERNATIONAL FRANCHISE ASSOCIATION 2010 first_quarter LBR H.R. 1409/S. 560, the Employee Free Choice Act; H.R. 12, the Paycheck Fairness Act; H.R. 2460/S. 1152, the Healthy Families Act; H.R. 635, National Commission on State Workers Comp Laws Act; RESPECT Act; H.R. 3548, Unemployment Compensation Extension Act; Nomination of Mr. Craig Becker to NLRB; NPRM Docket No. OSHA20090044 (RIN 1218-AC45) OSHA Recordkeeping Rulemaking; H.R. 3408/S. 2882, Taxpayer Responsibility, Accountability, and Consistency Act Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),Occupational Safety & Health Administration (OSHA),SENATE,Small Business Administration (SBA),Treasury, Dept of,Veterans Affairs, Dept of (VA),White House Office   150000 0 0 2010-04-19T17:15:41.460000-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);