lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "86a49d2f-ac5a-4e6d-8aeb-c7167ffec044" and issue_code = "GOV" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 938499 | NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE 86a49d2f-ac5a-4e6d-8aeb-c7167ffec044 | Q1 | NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE | 48975 | NATIONAL ASSOCIATION FOR THE ADVANCEMENT OF COLORED PEOPLE | 2010 | first_quarter | GOV | Eliminate discrimination in the federal sector. Support public financing of House and Senate campaigns. Support S. 752 / H.R. 1526. Support full funding for the 2010 Census. Oppose efforts to omit illegal immigrants from the census count, or to ask immigration status on the 2010 Census questionnaire. Support the establishment of a US Department of Peace (support H.R. 808). Support the nomination of Robert Groves to be Director of the US Department of Commerce. Oppose any attempts to reduce federal funding as established in the House version of the Commerce-Justice- State Appropriations bill for the Census Bureau in FY 2010. Support full funding for the EEOC. Support the nomination of Jacqueline Berrien to serve as Chair of the EEOC. Oppose amendments to require a question about citizenship status on the US census form. Support H.R. 1729, allowing students to register to vote on campus. | Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Environmental Protection Agency (EPA),Equal Employment Opportunity Commission (EEOC),Federal Bureau of Investigation (FBI),Federal Communications Commission (FCC),Federal Emergency Management Agency (FEMA),Federal Reserve System,Federal Trade Commission (FTC),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Justice, Dept of (DOJ),Labor, Dept of (DOL),Office of Personnel Management (OPM),SENATE,Small Business Administration (SBA),Social Security Administration (SSA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Commission on Civil Rights,U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA),Voice of America,White House Office | 50000 | 0 | 0 | 2010-04-20T16:56:13.430000-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);