lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1829750 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | CIV | H.R. 855, Voting Rights Amendment Act H.R. 2867/S. 1659, Voting Rights Advancement Act of 2015 | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829751 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | TRA | Advocacy related to performance measures Implementation of FAST Act | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829752 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | FIN | H.R. 766, the Financial Institution Customer Protection Act of 2015 H.R. 1675, the Encouraging Employee Ownership Act of 2015 S. 1841, "Taxpayer Protection and Responsible Resolution Act" Whistleblower Augmented Reward and Nonretaliation (WARN) Act of 2016 H.R. 2896, Taking Account of Institutions with Low Operation Risk Act of 2015 H.R. 3798, the Due Process Restoration Act of 2015 H.R. 4166, the Expanding Proven Financing for American Employers Act H.R. 4139, the Fostering Innovation Act H.R. 4498 , the HALOS Act H.R. 4620, the Preserving Access to CRE Capital Act H.R. 4638, the Main Street Growth Act H.R. 4096, the Investor Clarity and Bank Parity Act The Brokaw Act H.R. 4018, "Consumer Protection and Choice Act" Department of Education Complaint System Corinthian College Student Loan Relief CFTC Funding CFPB Auto Lending Reform Wage Garnishment Payday Lending Reform DoL Fiduciary Rule CFPB Oversight | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829753 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | TEC | Minority ownership Privacy and big data protections Lifeline Prison phone rates | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829754 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | POS | Nominees to U.S. Postal Service Board of Governors | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829755 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | BUD | Defense Appropriations bills Transportation, Housing, and Urban Development (THUD) Appropriations bills Commerce, Justice, and Science (CJS) Appropriations bills Labor Health Appropriations bills Financial Services Appropriations bills Earned Income Tax Credit (EITC) and Child Tax Credit (CTC) | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829756 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | GOV | Support adequate funding for the census Oppose making American Community Survey voluntary | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829757 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | IMM | Policies related to criminal prosecutions on the basis of unlawful presence/reentry Reauthorization of the EB-5 visa program H.R. 4038, relating to refugees from Iraq and Syria H.R. 158, the Visa Waiver Improvement Act | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829758 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | EDU | Elementary and Secondary Education Act Higher Education Act (gainful employment) | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829759 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | LBR | S. 1150/H.R. 2150, Raise the Wage Act H.R. 2654/ S. 1512, Pregnant Workers Fairness Act S. 2180, Protecting Older Workers Against Discrimination Act H.R.932/S.497, Healthy Families Act H.R. 1439/S.786, Family and Medical Insurance Leave Act S. 2042/H.R.3514, Workplace Action for a Growing Economy (WAGE) Act | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829760 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | LAW | H.R. 2851/S. 1038, End Racial Profiling Act S.2123 Sentencing Reform and Corrections Act H.R. 3713 Sentencing Reform Act Background Checks H.R. 540/S. 255 The FAIR Act H.R. 2875 Law Enforcement Trust & Integrity Act Judge Luis Felipe Restrepo, nominee to the U.S. Court of Appeals Third Circuit U.S. DOJ/U.S. DHS Profiling Guidance H.R. 3470/S. 2021, Fair Chance Act Second Chance Reauthorization Act S.2298 Mens Rea Reform Act of 2015 H.R. 4002 Criminal Code Improvement Act of 2015 Chief Judge Merrick Garland, nominee to the U.S. Supreme Court Rebecca Ross Haywood, nominee to the U.S. Court of Appeals Third Circuit Judge Lisabeth Tabor Hughes, nominee to the U.S. Court of Appeals Sixth Circuit Donald Karl Schott, nominee to the U.S. Court of Appeals Seventh Circuit Myra C. Selby, nominee to the U.S. Court of Appeals Seventh Circuit Jennifer Klemestrud Puhl, nominee to the U.S. Court of Appeals Eighth Circuit Judge Lucy H. Koh, nominee to the U.S. Court of Appeals Ninth Circuit Judge Abdul K. Kallon, nominee to the U.S. Court of Appeals Eleventh Circuit Judge Dax Lopez, nominee to the U.S. District Court for the Northern District of Georgia | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-04:00 | |
| 1829761 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS abcbdbc8-7bd7-4bd1-9f9f-e380d656ea88 | Q1 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 22371 | LEADERSHIP CONFERENCE ON CIVIL AND HUMAN RIGHTS | 2016 | first_quarter | HOU | Reform of housing finance system (Fannie Mae, Freddie Mac) S. 1484, Financial Regulatory Improvement Act Federal Housing Finance Agency rulemaking on "Duty to Serve" | Bureau of the Census,Consumer Financial Protection Bureau (CFPB),Education, Dept of,Executive Office of the President (EOP),Federal Communications Commission (FCC),Federal Housing Finance Agency (FHFA),Federal Trade Commission (FTC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Economic Council (NEC),Office of Management & Budget (OMB),SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 304446 | 0 | 0 | 2016-04-20T16:50:16.513000-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);