lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "c488ee0c-6b66-4c86-bdd6-088b74e7da83" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2268106 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | FOR | Support for Anti-Boycott, Divestment, and Sanctions Resolutions; Support for the Lautenberg Amendment | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268107 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | EDU | Never Again (Holocaust) Education Act | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268108 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | DIS | Support for the Emergency Food & Shelter Program; Support for the Federal Disaster Assistance for Non-Profits Act | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268109 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | HCR | Medicaid block grant/per capita caps; Medicaid Funding Threats/Reform; extension of Money Follows the Person Rebalancing Demonstration Project and support for the Ensuring Medicaid Provides Opportunities for Widespread Equity, Resources, and Care Act (also known as the EMPOWER Care Act, S.548/H.R. 1342); extension of spousal impoverishment in Medicaid home and community-based services protections under the Protecting Married Seniors from Impoverishment Act (H.R. 1343); Administration efforts regarding Opioid Use and implementing behavioral health information technology incentive payments; Medicaid 1115 Waiver Applications to the Department of Health & Human Services; Disability Integration Act (S. 117/H.R.555);; Independence at Home Act; . ABLE Age Adjustment Act (S. 651/H.R. 1814); | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268110 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | MMM | Medicaid Reform; Medicaid Funding Threats; and Medicare and Medicaid Innovation. | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268111 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | TAX | Charitable Tax and Donor-Advised Fund issues; Tax Cuts & Jobs Act issues impacting tax-exempt organizations including Universal Charitable Deduction and Unrelated Business Income provisions; Repeal of Johnson Amendment; IRA Charitable Rollover expansion; Pension issues including the Retirement Enhancement and Savings Act; Commodities Trading Futures Commission registration | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268112 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | BUD | Emergency Food and Shelter Program Funding (FY 2019 Appropriations); Non-profit Security Grant Program Funding (FY 2019 Appropriations); Holocaust Survivor Assistance Program (FY 2019 Appropriations); Domestic Violence Programs (FY 2019 Appropriations); Older Americans Act Nutrition Programs FY 2019 Appropriations); Senior Community Service Employment Program (FY 2019 Appropriations); Lautenberg Amendment (FY 2019 Appropriations); Census Bureau Funding (FY 2019 Commerce, Justice, and Science Appropriations bill); Labor-Health and Human Services FY 2019 Appropriations; and Transportation, Housing, Urban Development FY 2019 Appropriations. | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268113 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | HOM | Homeland Security Appropriations, Non-profit Security Grant Program, and Emergency Food and Shelter program; Antisemitism & related Homeland Security matters. Inadmissibility on Public Charge Grounds. | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268114 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | WEL | Support for Nutrition Programs; support for Supplemental Nutrition Authorization Program; Legislation promoting social service funding/programs for Holocaust survivors; Appropriations for FY 2019 - Emergency Food and Shelter Program and Older Americans Act programs; Violence Against Women Act ; Support for Holocaust Survivor Assistance Program; Support for Child Nutrition Program Reauthorization. | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-04:00 |
| 2268115 | THE JEWISH FEDERATIONS OF NORTH AMERICA c488ee0c-6b66-4c86-bdd6-088b74e7da83 | Q1 | THE JEWISH FEDERATIONS OF NORTH AMERICA | 11105 | JEWISH FEDERATIONS OF NORTH AMERICA | 2019 | first_quarter | LAW | Support for the Protecting Religiously Affiliated Institutions Act of 2019; broaden and enhance criminal penalties under Church Arson Prevention Act. | Administration for Children & Families (ACF),Administration on Aging,Education, Dept of,Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Office of Management & Budget (OMB),SENATE,State, Dept of (DOS),Treasury, Dept of,White House Office | 0 | 0 | 2019-04-16T20:55:18.377000-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,
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);