lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
34 rows where filing_uuid = "549b6d3f-e908-4e08-8ade-a427de98248e" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: specific_issues, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3486207 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | AGR | Support for funding for the Rural Disaster Home Repair Program, WIC, SNAP, food assistance, Rural Partners Network, and Rural Energy for America Program in FY26 appropriations bills; oppose HR 4121 and S. 2256 due to funding cuts to the DOA and related programs. Oppose cuts, rescissions, and freezes to funding to USDA Rural Energy for America, New ERA, and PACE programs related to clean energy. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486208 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | BNK | Coal mining bankruptcies, lobbying for legislation to ensure money for reclamation after coal bankruptcies. No bill #s. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486209 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | BUD | Support for funding in appropriations bills for OSMRE, MSHA, OSHA, EDA, USDA, FEMA, USGS, AmeriCorps, CDFI, Appalachian Regional Commission, clean energy, economic development, and rural energy; oppose H.R. 4553, HR 4121, HR 3944, HR 4754, S 2431, H.R. 5304, H.R. 5342, H.R. 5166, H.R. 4249, due to related funding cuts. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486210 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | CAW | Oppose cuts to EPA and Interior funding in appropriations bills, including H.R. 4553 and H.R. 4754. Oppose S. 2750: SANDBOX Act. Support S. 2508: Gas Pipeline Leak Detection and Repair Act of 2025, to protect people from gas leaks. Oppose H.R. 4776: SPEED Act due to impacts on air and water quality. Support H.R. 4705: ACHE Act to protect communities from impacts of coal mining. Oppose H.R. 3632: Power Plant Reliability Act Oppose H.R. 3668: Improving Interagency Coordination for Pipeline Reviews Act Oppose 3898: Permit Act | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486211 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | DIS | Support S. 267, H.R. 76 to provide for reimbursement of repairs to private roads and bridges in North Carolina damaged by Tropical Storm Helene. Support funding for FEMA, Rural Disaster Home Repair Program, flood mitigation assistance, priority streamgages network, USGS funding in FY 26 appropriations, H.R. 4754, H.R. 4213 and S. 2431. Provide feedback on FEMA reform bills to members of Congress. Support H.R. 4669 to improve FEMA processes. Oppose HR 4553 due to agency and program cuts. Oppose rescission and freezing of funds for disaster relief provided through FEMA and EPA. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486212 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | ECN | Support funding in FY26 appropriations bills for economic development efforts in Appalachia, including Appalachian Regional Commission, EDA, EPA, and USDA programs, including in H.R. 4553, HR 4121, HR 3944, HR 4754, S 2431, H.R. 5304, H.R. 5342. Oppose H.R. 1 due to ending programs supporting economic development in rural and Appalachian communities. Oppose H.R. 5342 due to funding cuts to the Economic Development Administration. Support HR 5687 to ensure people are able to heat their homes. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486213 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | ENG | Support for H.R. 1373, H.R 144, and S. 1354 related to TVA transparency and salary transparency, and the TVA IRP bill (H.R. 6357) related to improving TVA's IRP process. Oppose new nominees to TVA board. Oppose bills decreasing funding for the DOE, including H.R. 4553. Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. Oppose HR 4121 due to funding cuts to the Department of Agriculture and related energy programs. Oppose H.R. 3668 Improving Interagency Coordination for Pipeline Reviews Act and H.R. 3632 Power Plant Reliability Act, due to impacts on communities dealing with harmful pollution and climate change impacts. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486214 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | FUE | Support S. 2508: Gas Pipeline Leak Detection and Repair Act of 2025, to protect people from gas leaks. Oppose H.R. 3668 Improving Interagency Coordination for Pipeline Reviews Act and H.R. 3632 Power Plant Reliability Act, due to impacts on communities dealing with harmful pollution and climate change impacts. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486215 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | HCR | Support for funding for NIOSH and coal workers programs to prevent black lung disease. Oppose H.R. 5304 due to related funding cuts. Support S. 2587 to fund health and labor programs. Support legislation to improve benefits for miners with black lung disease - S. 3491, H.R. 6756, S. 3505, H.R. 6757. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486216 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | INS | Support efforts to ensure adequate insurance levels for coal mining reclamation and black lung insurance. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486217 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | LBR | Ensure adequate benefits for miners with black lung disease. Ensure adequate funding for MSHA and DOL to protect miners' health and safety. Support funding for reentry employment opportunities, registered apprenticeships, workforce innovation and opportunity act training and employment services grants, OSHA, and NIOSH in FY 26 appropriations bills. Oppose H.R. 5304 due to funding cuts to MSHA, DOL; Support S. 2587 to fund health and labor programs. Support legislation to improve benefits for miners with black lung disease - S. 3491, H.R. 6756, S. 3505, H.R. 6757. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486218 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | MAN | No lobbying on this issue this quarter. | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | ||
| 3486219 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | NAT | Ensure reclamation of coal mines. No specific bill numbers yet. Oppose cuts to EPA and Interior programs in FY 26 appropriations, including HR 4553 and H.R. 4754. Oppose H.R. 4776: SPEED Act due to impacts on air and water quality. Support H.R. 4705: ACHE Act to protect communities from impacts of coal mining. Support H.R. 2405 White Oak Resilience Act. Oppose 3898 Permit Act. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486220 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | UTI | Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. Support for H.R. 1373, H.R 144, and S. 1354 related to TVA transparency and salary transparency, and the TVA IRP bill (H.R. 6357) related to improving TVA's IRP process. Oppose new nominees to TVA board. Oppose bills decreasing funding for the DOE, including H.R. 4553. Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. Oppose HR 4121 due to funding cuts to the Department of Agriculture and related energy programs. Oppose H.R. 3668 Improving Interagency Coordination for Pipeline Reviews Act and H.R. 3632 Power Plant Reliability Act, due to impacts on communities dealing with harmful pollution and climate change impacts. | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | ||
| 3486221 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | TAX | Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486222 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | HOU | Support funding for Department of Housing and Urban Affairs in FY 26 appropriations (H.R. 4552, S. 2465). | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3486223 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | ENV | Support funding for EPA in FY 26 appropriations bills (H.R. 4754; S. 2431). | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758274 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | AGR | Support for funding for the Rural Disaster Home Repair Program, WIC, SNAP, food assistance, Rural Partners Network, and Rural Energy for America Program in FY26 appropriations bills; oppose HR 4121 and S. 2256 due to funding cuts to the DOA and related programs. Oppose cuts, rescissions, and freezes to funding to USDA Rural Energy for America, New ERA, and PACE programs related to clean energy. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758275 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | BNK | Coal mining bankruptcies, lobbying for legislation to ensure money for reclamation after coal bankruptcies. No bill #s. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758276 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | BUD | Support for funding in appropriations bills for OSMRE, MSHA, OSHA, EDA, USDA, FEMA, USGS, AmeriCorps, CDFI, Appalachian Regional Commission, clean energy, economic development, and rural energy; oppose H.R. 4553, HR 4121, HR 3944, HR 4754, S 2431, H.R. 5304, H.R. 5342, H.R. 5166, H.R. 4249, due to related funding cuts. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758277 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | CAW | Oppose cuts to EPA and Interior funding in appropriations bills, including H.R. 4553 and H.R. 4754. Oppose S. 2750: SANDBOX Act. Support S. 2508: Gas Pipeline Leak Detection and Repair Act of 2025, to protect people from gas leaks. Oppose H.R. 4776: SPEED Act due to impacts on air and water quality. Support H.R. 4705: ACHE Act to protect communities from impacts of coal mining. Oppose H.R. 3632: Power Plant Reliability Act Oppose H.R. 3668: Improving Interagency Coordination for Pipeline Reviews Act Oppose 3898: Permit Act | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758278 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | DIS | Support S. 267, H.R. 76 to provide for reimbursement of repairs to private roads and bridges in North Carolina damaged by Tropical Storm Helene. Support funding for FEMA, Rural Disaster Home Repair Program, flood mitigation assistance, priority streamgages network, USGS funding in FY 26 appropriations, H.R. 4754, H.R. 4213 and S. 2431. Provide feedback on FEMA reform bills to members of Congress. Support H.R. 4669 to improve FEMA processes. Oppose HR 4553 due to agency and program cuts. Oppose rescission and freezing of funds for disaster relief provided through FEMA and EPA. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758279 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | ECN | Support funding in FY26 appropriations bills for economic development efforts in Appalachia, including Appalachian Regional Commission, EDA, EPA, and USDA programs, including in H.R. 4553, HR 4121, HR 3944, HR 4754, S 2431, H.R. 5304, H.R. 5342. Oppose H.R. 1 due to ending programs supporting economic development in rural and Appalachian communities. Oppose H.R. 5342 due to funding cuts to the Economic Development Administration. Support HR 5687 to ensure people are able to heat their homes. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758280 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | ENG | Support for H.R. 1373, H.R 144, and S. 1354 related to TVA transparency and salary transparency, and the TVA IRP bill (H.R. 6357) related to improving TVA's IRP process. Oppose new nominees to TVA board. Oppose bills decreasing funding for the DOE, including H.R. 4553. Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. Oppose HR 4121 due to funding cuts to the Department of Agriculture and related energy programs. Oppose H.R. 3668 Improving Interagency Coordination for Pipeline Reviews Act and H.R. 3632 Power Plant Reliability Act, due to impacts on communities dealing with harmful pollution and climate change impacts. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758281 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | FUE | Support S. 2508: Gas Pipeline Leak Detection and Repair Act of 2025, to protect people from gas leaks. Oppose H.R. 3668 Improving Interagency Coordination for Pipeline Reviews Act and H.R. 3632 Power Plant Reliability Act, due to impacts on communities dealing with harmful pollution and climate change impacts. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758282 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | HCR | Support for funding for NIOSH and coal workers programs to prevent black lung disease. Oppose H.R. 5304 due to related funding cuts. Support S. 2587 to fund health and labor programs. Support legislation to improve benefits for miners with black lung disease - S. 3491, H.R. 6756, S. 3505, H.R. 6757. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758283 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | INS | Support efforts to ensure adequate insurance levels for coal mining reclamation and black lung insurance. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758284 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | LBR | Ensure adequate benefits for miners with black lung disease. Ensure adequate funding for MSHA and DOL to protect miners' health and safety. Support funding for reentry employment opportunities, registered apprenticeships, workforce innovation and opportunity act training and employment services grants, OSHA, and NIOSH in FY 26 appropriations bills. Oppose H.R. 5304 due to funding cuts to MSHA, DOL; Support S. 2587 to fund health and labor programs. Support legislation to improve benefits for miners with black lung disease - S. 3491, H.R. 6756, S. 3505, H.R. 6757. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758285 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | MAN | No lobbying on this issue this quarter. | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | ||
| 3758286 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | NAT | Ensure reclamation of coal mines. No specific bill numbers yet. Oppose cuts to EPA and Interior programs in FY 26 appropriations, including HR 4553 and H.R. 4754. Oppose H.R. 4776: SPEED Act due to impacts on air and water quality. Support H.R. 4705: ACHE Act to protect communities from impacts of coal mining. Support H.R. 2405 White Oak Resilience Act. Oppose 3898 Permit Act. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758287 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | UTI | Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. Support for H.R. 1373, H.R 144, and S. 1354 related to TVA transparency and salary transparency, and the TVA IRP bill (H.R. 6357) related to improving TVA's IRP process. Oppose new nominees to TVA board. Oppose bills decreasing funding for the DOE, including H.R. 4553. Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. Oppose HR 4121 due to funding cuts to the Department of Agriculture and related energy programs. Oppose H.R. 3668 Improving Interagency Coordination for Pipeline Reviews Act and H.R. 3632 Power Plant Reliability Act, due to impacts on communities dealing with harmful pollution and climate change impacts. | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | ||
| 3758288 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | TAX | Support reinstating clean electric tax credits, including S. 2681: Lowering Electric Bills Act. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758289 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | HOU | Support funding for Department of Housing and Urban Affairs in FY 26 appropriations (H.R. 4552, S. 2465). | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05:00 | |
| 3758290 | APPALACHIAN VOICES 549b6d3f-e908-4e08-8ade-a427de98248e | Q4 | APPALACHIAN VOICES | 401107435 | APPALACHIAN VOICES | 2025 | fourth_quarter | ENV | Support funding for EPA in FY 26 appropriations bills (H.R. 4754; S. 2431). | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2026-01-15T13:23:54-05: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);