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 = "ECN" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 938490 | 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 | ECN | Equal access to wealth for all Americans; fair and equal economic development for the areas and people most in need. Rebuilding of Gulf Coast after Hurricane Katrina. Support H.R. 2269, the Gulf Coast Civic Works Act. Work to ensure that funds allocated under H.R. , the American Recovery and Reinvestment Act of 2009 are evenly distributed to businesses owned by racial and ethnic minorities. Supported putting conditions on the second half of the TARP funds to ensure more foreclosure mitigation. Supported full funding for the Housing Trust Fund; supported the American Recovery and Reinvestment Act (H.R. 1). Support Tim Geithner as Secretary of the Treasury. Support reauthorization, modernization and expansion of the Community Reinvestment Act (CRA), support H.R. 1479. Support job creation programs through public works and infrastructure development. Support H.R. 2847 as it passed the House on 12/16/2009. Support for H. Res. 1024, supporting Poverty in America awareness month. | 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);