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

9 rows where filing_uuid = "b74feffc-1d68-4d0d-a342-e19931f4cb9e" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 9

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
1228672 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter MMM SMART Act, H.R. 1063 and S. 1718, proposals to reform Medicare Secondary Payer (MSP) processes. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228673 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter ENG Federal legislation relating to reform, revision and/or repeal of Renewable Fuel Standard, including H.R. 3097 and H.R. 3098. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228674 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter TAX H.R. 1265 and S. 687, 15-year depreciation for restaurant construction. H.R. 2082, permanent extension of Work Opportunity Tax Credit. Potential consideration of depreciation and WOTC within legislation to extend expiring tax credits. Monitoring of congressional proposals to reform corporate tax rates. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228675 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter HCR H.R. 1744 and H.R. 2206, portions relating to repeal of employer mandate and auto-enrollment mandates in PPACA. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228676 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter LBR Monitor congressional and agency activities relating to NLRB union election provisions, procedures and regulations; S.J.Res. 36 and H.J.Res. 103; H.R. 1876 and S. 2252=provisions relating to employer mandates on paid leave, minimum wage and tip credit. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228677 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter AGR H.R. 3798, the Egg Products Inspection Act Amendments--provisions relating to regulation/use of alternative housing for hens. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228678 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter ROD Portman and LaTourette amendments to federal highway program extension legislation--provisions relating to allowing state commercialization of interstate highway rest areas. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228679 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter FOO Monitor rulemaking pursuant to Sec. 4205 of PPACA = nutritional disclosure for chain restaurants HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-04:00
1228680 CRACKER BARREL OLD COUNTRY STORE, INC. b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 CRACKER BARREL OLD COUNTRY STORE, INC. 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter FIN Federal Reserve rulemaking and potential legislation on debit card interchange fees per Sec. 1075 of PL 111-203 HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2012-04-16T17:46:51.473000-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);