lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_period = "first_quarter", filing_uuid = "86a49d2f-ac5a-4e6d-8aeb-c7167ffec044" and issue_code = "COM" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 938508 | 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 | COM | Ensuring equal access for minority-owned television and radio stations. Oppose "A La Carte" pricing. Spread the word about the Digital TV transition. Ensure that the Arbitron rating system is not harmful to radio stations owned by racial and ethnic minorities (oppose Arbitron's PPM system). Support for racial- and ethnic-owned media outlets. Support H.R. 848, support for minority-owned media. Support a delay of the Digital TV transition (S. 352). Support for the Impact Study on the impact of broadband deployment on all American communities. Support ensuring full and comprehensive deployment of broadband technology to all American communities that is affordable, accessible, attainable and sustainable. Support broadband deployment and accessibility throughout the United States, and especially in racial and ethnic minority communities and traditionally underserved communities. | 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);