lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "2a4dad4b-fbce-4065-9a95-e495ae9fc6de", filing_year = 2014 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1535247 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES 2a4dad4b-fbce-4065-9a95-e495ae9fc6de | Q1 | THE AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2046 | AMERICAN COUNCIL OF ENGINEERING COMPANIES | 2014 | first_quarter | GOV | Issues related to the audit on engineering firm overhead performed by the Office of the Inspector General at USDOT; issues related to oversight of engineering services and contracting in the federal highway program, including FHWA rulemaking on consultant services and FHWA "safe harbor" pilot program for indirect cost rate; federal procurement issues, including definitions of inherently governmental and critical functions; Defense Authorization Act, contracting changes; small business set asides/contracting;HR 746, small business compliance issues; small business size standards related to engineering services; issues related to agency performance of infrastructure work without engineering oversight/involvement; limiting "in-sourcing" by federal agencies and competition for third party work; FY'14 Defense Authorization (HR 1960/S 1197), issues related to small business programs, A-76 process and employee compensation; HR 2232, provisions related to small business subcontracting; HR 1942, procurement reforms; HR 436/S 109, related to removing prject labor agreements from federal projects; S 1192/HR 2444, provisions related to compensation limits; S 6, requirements on veterans workforce within contracting firms; S 196, provisions related to small firm contracting; HR 2232/HR 2441/S 1190, provisions related to small firm contracting; HR 2751, provisions related to reverse auctions and other procurement actions; HR 1622, related to the qualifications for publicly traded small firms in government contracting; HR 505, related to compensation caps; HR 1109, related to selection factors for government contracting; HR 2750, design-build reforms; HR 3370, related to flood insurance changes; HR 4228, related to changes in DHS acquisition procedures. | AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Defense, Dept of (DOD),Education, Dept of,Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),Federal Aviation Administration (FAA),Federal Emergency Management Agency (FEMA),Federal Highway Administration (FHA),Federal Transit Administration (FTA),General Services Administration (GSA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Office of Management & Budget (OMB),Overseas Private Investment Corp (OPIC),Securities & Exchange Commission (SEC),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),Treasury, Dept of,U.S. Agency for International Development (USAID),U.S. Trade Representative (USTR),Veterans Affairs, Dept of (VA) | 765169 | 0 | 0 | 2014-04-21T14:29:24.597000-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);