lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "d06d1c97-d9e3-4aa6-af92-a7b55152ea2a" and issue_code = "LBR" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1580262 | NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE d06d1c97-d9e3-4aa6-af92-a7b55152ea2a | 2A | NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE | 48975 | NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE | 2014 | second_quarter | LBR | Support H.R. 1010, Support S. 460. Support Tom Perez to be Secretary of Labor Oppose Scott amendment to S Con Res 8 regarding union dues. Support HR 337, Support S 84Support the Arbitration Fairness Act of 2013, H.R. 1844 / S. 878. Oppose S. 624. Oppose HR 1406. Support the Healthy Families Act, H.R. 1286 / S. 631. Support the Fair Minimum Wage Act, H.R. 1010 / S. 460. / s. 2223 Support $5 million in FY 2014 to establish a State Paid Leave Fund within the Department of Labor. Support H.R. 2654 / S 1281. Support H.R. 1755 / S. 815. Support continuation of Davis-Bacon laws; oppose King (IA) amendment to H.R. 2216 Oppose H.R. 1120. Oppose H.R. 803. Work with the Transportation Security Agency to ensure that its rules and regulations regarding criminal background checks were not shutting people put of the potential job market (with package carriers, etc.). Support issuing U Visas to Jamaican Guestworkers in Destin, FL., as they pursue complaints about conditions at Mister Clean. Support the POWER Act (Protect Our Workers from Exploitation and Retaliation) as introduced in the 112th Congres (S. 1195 / H.R. 2169) and included in S. 744 in the 113th Congress, Comprehensive Senate Immigration Reform. Support the Family and Medical Insurance Leave Act of 2013 (FAMILY Act), legislation that would create a national family and medical leave insurance program. Oppose H.R. 1493, the Sunshine for Regulatory Decrees and Settlements Act of 2013. Support increasing the minimum wage for tipped workers and tying it to inflation, as contained in H.R. 1010 / S. 460. Support youth summer programs, federal funding for appreticeships and internships, and ensuring divrsity in any such programs. Support H.R. 1340 / S. 655, the Urban Jobs Act. Support H.R. 3016 Support the Department of Labors (DOL) commitment to reviewing and revising the regulations and goals for women and minorities in apprenticeships and on federal construction projects. Support an increasee in the minimum wage, support S. 2223. Support S. 1737… | Agriculture, Dept of (USDA),Centers For Medicare and Medicaid Services (CMS),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Environmental Protection Agency (EPA),Equal Employment Opportunity Commission (EEOC),Federal Communications Commission (FCC),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Credit Union Administration (NCUA),Office of Personnel Management (OPM),Office of the Comptroller of the Currency (OCC),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Transportation Security Administration (TSA),Treasury, Dept of,U.S. Commission on Civil Rights,Veterans Affairs, Dept of (VA),White House Office | 68750 | 0 | 0 | 2014-08-15T12:47:59.567000-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);