lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023844 | NATIONAL TRUST FOR HISTORIC PRESERVATION c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9 | Q3 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 28721 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 2017 | third_quarter | CIV | Lobbying for African-American Civil Rights Network Act of 2017(HR 1927/S. 857); A bill to reauthorize the Historically Black Colleges and Universities (HBCUs) Historic Preservation program (H.R. 1135). | Advisory Council on Historic Preservation (ACHP),Army, Dept of (Corps of Engineers),Bureau of Land Management (BLM),Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office | 42376 | 0 | 0 | 2017-10-13T16:01:04.603000-04:00 | |
| 2023845 | NATIONAL TRUST FOR HISTORIC PRESERVATION c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9 | Q3 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 28721 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 2017 | third_quarter | TRA | Implementation of streamlining provisions for highway projects and new streamling provisions proposed in White House and congressional infrastructure packages. | Advisory Council on Historic Preservation (ACHP),Army, Dept of (Corps of Engineers),Bureau of Land Management (BLM),Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office | 42376 | 0 | 0 | 2017-10-13T16:01:04.603000-04:00 | |
| 2023846 | NATIONAL TRUST FOR HISTORIC PRESERVATION c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9 | Q3 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 28721 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 2017 | third_quarter | MAR | S. 89/H.R. 619, a bill exempting the Delta Queen from the provisions of the Safety of Law of the Sea (SOLAS) | Advisory Council on Historic Preservation (ACHP),Army, Dept of (Corps of Engineers),Bureau of Land Management (BLM),Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office | 42376 | 0 | 0 | 2017-10-13T16:01:04.603000-04:00 | |
| 2023847 | NATIONAL TRUST FOR HISTORIC PRESERVATION c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9 | Q3 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 28721 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 2017 | third_quarter | GOV | Advisory Council on Historic Preservation (ACHP) - review of permit application for the James River Transmission line;correspondence related to the disposal of the Richmond, CA post office; the VAs proposed building disposal plan. Army Corps of Engineers (ACOE) - Review of the permit application for the James River transmission line. Department of Defense (DOD) - working with DODs Federal Preservation Officer regarding the Military LAND Act; Department of the Interior (DOI-BLM) -- permit application for the James River transmission line; historic leasing and deferred maintenance in the national parks; correspondence with Bureau of Land Management staff about oil and gas lease sales in SE Utah, Wyoming, and northern New Mexico. National Park Service (NPS) - historic leasing, deferred maintenance, HOPE Crews; the unintentional demolition of a historic bungalow on Ford Island in Hawaii. Department of Veterans Affairs - VAs realignment study for historic properties, proposed building disposal plan, historic leasing. | Advisory Council on Historic Preservation (ACHP),Army, Dept of (Corps of Engineers),Bureau of Land Management (BLM),Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office | 42376 | 0 | 0 | 2017-10-13T16:01:04.603000-04:00 | |
| 2023848 | NATIONAL TRUST FOR HISTORIC PRESERVATION c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9 | Q3 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 28721 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 2017 | third_quarter | POS | H.R. 756, Postal Service Reform Act of 2017 | Advisory Council on Historic Preservation (ACHP),Army, Dept of (Corps of Engineers),Bureau of Land Management (BLM),Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office | 42376 | 0 | 0 | 2017-10-13T16:01:04.603000-04:00 | |
| 2023849 | NATIONAL TRUST FOR HISTORIC PRESERVATION c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9 | Q3 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 28721 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 2017 | third_quarter | BUD | BUD: HR 1158/S. 425, the Historic Tax Credit Improvement Act of 2017 (BUD); African-American Civil Rights Network Act of 2017(HR 1927/S. 857); Resilient Federal Forests Act (HR 2936); A bill to reauthorize the Historically Black Colleges and Universities (HBCUs) Historic Preservation program (H.R. 1135). HR 601 - Continuing Appropriations Act, 2018 and Supplemental Appropriations for Disaster Relief Requirements Act, 2017 Public Law No: 115-56. [disaster relief for affected historic and cultural properties from Hurricanes Harvey and Irma]; FY18 Omnibus Appropriations -HR 3354 (2017-2018) - Interior and Environment, Agriculture and Rural Development, Commerce, Justice, Science, Financial Services and General Government, Homeland Security, Labor, Health and Human Services, Education, State and Foreign Operations, Transportation, Housing and Urban Development, Defense, Military Construction and Veterans Affairs, Legislative Branch, and Energy and Water Development Appropriations Act, (en bloc amendments to increase funding for Historically-Black Colleges and Universities (HBCUs) and the Historic Preservation Fund (HPF). | Advisory Council on Historic Preservation (ACHP),Army, Dept of (Corps of Engineers),Bureau of Land Management (BLM),Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office | 42376 | 0 | 0 | 2017-10-13T16:01:04.603000-04:00 | |
| 2023850 | NATIONAL TRUST FOR HISTORIC PRESERVATION c8ce0d2e-ebe6-438a-90bf-5507e4f97cf9 | Q3 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 28721 | NATIONAL TRUST FOR HISTORIC PRESERVATION | 2017 | third_quarter | NAT | National Park Service Legacy Act (S. 751/H.R. 2584); H.J. Res. 44/S.J. Res 15 - revocation of BLM Planning 2.0 rule; H.R. 538- Ocmulgee Boundary Revision Act; H.R.; National Defense Authorization Act of 2018 - (H.R. 473, the Military LAND Act provision- to provide that if the head of the agency managing Federal property objects to the inclusion of certain property on the National Register or its designation as a National Historic Landmark for reasons of national security). | Advisory Council on Historic Preservation (ACHP),Army, Dept of (Corps of Engineers),Bureau of Land Management (BLM),Defense, Dept of (DOD),Federal Highway Administration (FHA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Park Service (NPS),SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),Veterans Affairs, Dept of (VA),White House Office | 42376 | 0 | 0 | 2017-10-13T16:01:04.603000-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);