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

5 rows where filing_uuid = "8969f3ff-1bbf-4ff5-9c24-e5113aba06f5" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 5

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
1383809 AMERICAN FEDERATION OF TEACHERS 8969f3ff-1bbf-4ff5-9c24-e5113aba06f5 Q1 AMERICAN FEDERATION OF TEACHERS 2332 AMERICAN FEDERATION OF TEACHERS 2013 first_quarter CIV S. 47, the Violence Against Women Reauthorization Act (VAWA) S. 150, the Assault Weapons Ban of 2013 S. 374, Protecting Responsible Gun Sellers Act of 2013 S. 146, School Safety Enhancements Act of 2013 Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of the Vice President of the United States,SENATE,White House Office   369989 0 0 2013-04-19T15:53:27.247000-04:00
1383810 AMERICAN FEDERATION OF TEACHERS 8969f3ff-1bbf-4ff5-9c24-e5113aba06f5 Q1 AMERICAN FEDERATION OF TEACHERS 2332 AMERICAN FEDERATION OF TEACHERS 2013 first_quarter BUD H.R. 152, the Disaster Relief Appropriations Act of 2013 The Consolidated and Further Continuing Appropriations Act of 2013 H.Con.Res. 25, the fiscal year 2014 budget resolution FY 2013 Continuing ResolutionLabor, HHS, Ed Appropriations (FY 2013 & 2014) Sequestration Senate FY 2014 Budget Resolution, S.CON.RES.8 Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of the Vice President of the United States,SENATE,White House Office   369989 0 0 2013-04-19T15:53:27.247000-04:00
1383811 AMERICAN FEDERATION OF TEACHERS 8969f3ff-1bbf-4ff5-9c24-e5113aba06f5 Q1 AMERICAN FEDERATION OF TEACHERS 2332 AMERICAN FEDERATION OF TEACHERS 2013 first_quarter DOC All items pertaining to School Vouchers within DC Appropriations Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of the Vice President of the United States,SENATE,White House Office   369989 0 0 2013-04-19T15:53:27.247000-04:00
1383812 AMERICAN FEDERATION OF TEACHERS 8969f3ff-1bbf-4ff5-9c24-e5113aba06f5 Q1 AMERICAN FEDERATION OF TEACHERS 2332 AMERICAN FEDERATION OF TEACHERS 2013 first_quarter EDU All bills pertaining to NCLB All bills pertaining to ESEA All draft items regarding gun control as it directly relates to school and community safety. S. 150, the Assault Weapons Ban of 2013S. 374, Protecting Responsible Gun Sellers Act of 2013 S. 146, School Safety Enhancements Act of 2013 Raising the Bar report Educator Preparation Reform Act Child Care and Development Block Grant regulations Head Start SNAP funding S. 114, the Fairness for Struggling Students Act of 2013 H.R. 532, the Private Student Loan Bankruptcy Fairness Act of 2013 Better Counseling for Smarter Borrowing Act Proprietary Institution of Higher Education Borrower Protection Act S. 406, the Students First Act of 2013 Student Debt Childhood Obesity/Lets Move Active Schools Vouchers Presidents early ed proposal PRE-K Act Kindergarten Entry Assessment Comments State of Preschool Collection Survey 2013-15 Comments Safe Communities, Safe Schools Act of 2013, S.649 Large Capacity Ammunition Feeding Device Act, H.R. 138 Large Capacity Ammunition Feeding Device Act, S.33 Gun Show Background Check Act, S.22 Ammunition Background Check Act of 2013, S. 174 Fix Gun Checks Act of 2013, HR 137 Gun Show Loophole Closing Act, HR 141 Stop Online Ammunition Sales Act, HR 142 Stop Illegal Trafficking in Firearms Act, S 54 Child Gun Safety and Gun Access Prevention Act of 2013, HR 65 Gun Trafficking Prevention Act of 2013, S. 179 The Gun Trafficking Prevention Act, HR 452 A bill to safeguard America's schools by using community policing strategies to prevent school violence and improve student and school safety S.148 Support Assault Firearms Elimination and Reduction for our Streets Act, HR 226 School Social Workers Improving Student Success Act, HR 563 Mental Health in Schools Act, S.195 Safe Schools Improvement Act, S.403/H.R.1199 Student Support Act, HR 320 Mental Heath First Aid, HR 274 Mental Health Awareness and Improvement Act of 2013, S.689 Campus Gun Free Zone, Initial Discussions Continuum of… Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of the Vice President of the United States,SENATE,White House Office   369989 0 0 2013-04-19T15:53:27.247000-04:00
1383813 AMERICAN FEDERATION OF TEACHERS 8969f3ff-1bbf-4ff5-9c24-e5113aba06f5 Q1 AMERICAN FEDERATION OF TEACHERS 2332 AMERICAN FEDERATION OF TEACHERS 2013 first_quarter LBR H.R. 803, the Supporting Knowledge and Investing in Lifelong Skills (SKILLS) Act, as a reauthorization of the Workforce Investment Act. Defense, Dept of (DOD),Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of the Vice President of the United States,SENATE,White House Office   369989 0 0 2013-04-19T15:53:27.247000-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);