lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "86dfb39e-e01b-4ea8-9e37-61ace92ea41d" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 988731 | THOMAS WALTERS & ASSOCIATES, INC. 86dfb39e-e01b-4ea8-9e37-61ace92ea41d | Q3 | THOMAS WALTERS & ASSOCIATES, INC. | 55438 | COUNTY OF VENTURA | 2010 | third_quarter | GOV | S. 168/H.R. 1314, the SCAAP Reimbursement Protection Act - entire bill H.R. 211/S. 211 - the Calling for 2-1-1 Act - entire bill H.R. 911, Stop Child Abuse in Residential Programs for Teens Act - restrictions on County Probation departments S. 1451/H.R. 915, FAA Reauthorization - Airport Improvement Program, Contract Tower program, Firefighting regulations H.R. 2209, the Restoring the Partnership for County Health Care Costs Act entire bill S. 3635, FY 2011 Energy and Water Appropriations Funding for: Matilija Dam, Santa Clara River Watershed Protection Plan, Channel Islands Harbor H.R. 3288 - FY 2010 Transportation/HUD Appropriations - Airport Improvement Program; Contract Tower Funding Reauthorization of Child Nutrition Act obesity prevention provisions H.R. 1525, legislation to amend the National Flood Insurance Act of 1968 to require the Administrator of the Federal Emergency Management Agency to consider reconstruction and improvement of flood protection systems when establishing flood insurance rates. H.R. 3415, legislation to suspend flood insurance rate map updates in geographic areas in which certain levees are being repaired. S. 1859, the Child Support Protection Act Provisions to de-list employer provided cell phones and PDAs from listed property for IRS purposes S. 292/H.R. 275 Withholding Tax Relief Act whole bill H.R. 1639 Border Health Care Relief Act whole bill H.R. 4852, Critical Infrastructure Earthquake Preparedness Act whole bill H.R. 1906 California Ocean and Coastal Protection Act whole bill S. 422/H.R. 1032 HEART for Women Act whole bill H.R. 5850/S. 3644, the FY2011 Transportation, HUD Appropriations bill CDBG, HOME Investment Partnerships, Homeless assistance grants, HOPWA, Elderly Housing S. 3686, the FY 2011 Labor, Health and Human Services Appropriations funding for CDC State & Local Capacity, Bioterrorism Hospital Program, MMRS, MCH, ADAP, TB Control, family planning, substance abuse block grants, preventative health, safety net grants, nutrition services for older Ameri… | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) | 50000 | 0 | 0 | 2010-10-07T15:26:30.517000-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);