lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "f8ad4cc5-2dae-42da-b620-e3c8728db40f", filing_year = 2022 and issue_code = "IMM" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2774838 | WORLDWIDE ERC f8ad4cc5-2dae-42da-b620-e3c8728db40f | Q1 | WORLDWIDE ERC | 401105673 | WORLDWIDE ERC | 2022 | first_quarter | IMM | U.S. Citizenship Act of 2021 (HR 1177) (Would make sweeping change to the United States immigration, visa, and border control system, including reversal and Congressional prohibition of many of the immigration-related executive actions of the previous administration; providing a path to legal residence for current DACA dreamers and others, essential workers in non-immigrant status, ending country-specific visa annual limits; granting immediate relative status to spouses and children of green card holders; and including other green card changes to recapture visas and exempt STEM degrees) U.S. House Committee on the Judiciary Subcommittee on Immigration and Citizenship (Modernize the Nonimmigrant and Immigrant Employment-Based System with E-Filing. As a first step to green card reform, eliminate the employment-based per country green card limits to create a first-come first-served green card system. Increase certainty and efficiency with a Trusted Employer program to pre-certify immigration-compliant employers, saving resources for top government priorities) Engaged the Senate Homeland Security and Government Affairs Committee on improvements to U.S. immigration system including E-Verify as well as processes for entry into the U.S. Modernize the nonimmigrant and immigrant employment-based system with e-filing. Increase certainty and save resources with Trusted Employer to pre-certify immigration-compliant employers, saving resources for top government priorities. Modifying then Registration Requirement for Petitioners Seeking to File Cap-Subject H-1B Petitions; Delay of Effective Date, 86 Fed. Reg. 7656 (Delay of effective date of final rule of a wage-based H-1B lottery process until December 31, 2021 proposed in the Department of Homeland Security) Strengthening Wage Protections for the Temporary and Permanent Employment of Certain Aliens in the United States: Proposed Delay of Effective Date, 86 Fed. Reg. 7656 (February 1, 2021) [DOL Docket No. ETA-2020-0006] (Delay until May 14 of effective date of final rule to… | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,White House Office | 20000 | 0 | 0 | 2022-04-15T09:27:59-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);