lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "b7e197ae-e5eb-4828-ad8a-abebc4f4dee2" and issue_code = "HOU" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2512000 | CALIFORNIA ASSOCIATION OF REALTORS b7e197ae-e5eb-4828-ad8a-abebc4f4dee2 | Q3 | CALIFORNIA ASSOCIATION OF REALTORS | 7691 | CALIFORNIA ASSOCIATION OF REALTORS | 2020 | third_quarter | HOU | H.R. 299; Blue Water Navy Vietnam Veterans Act of 2019; Would remove the loan limit on V.A. home loans and increase the fee on the loans. H.R. 748; Coronavirus Aid, Relief, and Economic Security Act or the CARES Act; Creates forgivable loans for small businesses and independent Contractors. Would also provide Pandemic Unemployment Assistance for people who do not historically qualify for unemployment insurance. H.R. 6364, S 3533; Securing and Enabling Commerce Using Remote and Electronic Notarization Act, would allow for remote online notarization. H.R. 2162; Housing Financial Literacy Act of 2019; Would reduce the FHA single-family mortgage insurance premium for first-time homebuyers who completed a housing counseling course. H.R. 3141; FHA Loan Affordability Act of 2019; Would eliminate the FHA mortgage insurance premium once the LTV has reached 78 percent. H.R 3504; Ryan Kules Specially Adaptive Housing Improvement Act of 2019; would extend increases in the VA home loan guarantee program. H.R. 6800; Health and Economic Recovery Omnibus Emergency Solutions Act or the HEROES Act; would provide tenant and landlord assistance, expand the Paycheck Protection Program, extend foreclosure and eviction moratoriums, and other actions. H.R. 6886; Paycheck Protection Program Flexibility Act of 2020; The bill would make changes to the Paycheck Protection Program. C.A.R. spoke with the National Economic Council about mortgage finance reform, conforming loan limits, FHA home loan premiums, and California's housing supply. C.A.R. spoke to Congress about the need for the Federal government to look for ways to stimulate the housing supply in California. C.A.R. spoke to Congress about the risk HECM loans pose to the safety and soundness of the Mutual Mortgage Insurance Fund and the cost to home owners. C.A.R. spoke to Congress about the need to support affordable housing for home ownership. C.A.R. spoke to Congress about mortgage finance Reform proposals. This includes the government guarantee, conforming… | Consumer Financial Protection Bureau (CFPB),Federal Housing Finance Agency (FHFA),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Internal Revenue Service (IRS),Natl Economic Council (NEC),SENATE,Treasury, Dept of | 44092 | 0 | 0 | 2020-10-16T16:43:30.777000-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);