lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "b7e197ae-e5eb-4828-ad8a-abebc4f4dee2" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2511999 | CALIFORNIA ASSOCIATION OF REALTORS b7e197ae-e5eb-4828-ad8a-abebc4f4dee2 | Q3 | CALIFORNIA ASSOCIATION OF REALTORS | 7691 | CALIFORNIA ASSOCIATION OF REALTORS | 2020 | third_quarter | CPI | C.A.R. spoke to Congress about Data Privacy and the impact new laws and regulations may have on small businesses. | 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 | |
| 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 | |
| 2512001 | CALIFORNIA ASSOCIATION OF REALTORS b7e197ae-e5eb-4828-ad8a-abebc4f4dee2 | Q3 | CALIFORNIA ASSOCIATION OF REALTORS | 7691 | CALIFORNIA ASSOCIATION OF REALTORS | 2020 | third_quarter | CSP | C.A.R. commented on CFPB-2019-0011 Advance Notice of Proposed Rulemaking on Property Assessed Clean Energy financing. C.A.R. commented on PACE RFI Notice No 2020-N-1 C.A.R. spoke to Congress about the impact PACE loans are having in various communities. C.A.R. spoke to the Consumer Financial Protection Bureau about property assessed clean energy loans. | 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 | |
| 2512002 | CALIFORNIA ASSOCIATION OF REALTORS b7e197ae-e5eb-4828-ad8a-abebc4f4dee2 | Q3 | CALIFORNIA ASSOCIATION OF REALTORS | 7691 | CALIFORNIA ASSOCIATION OF REALTORS | 2020 | third_quarter | CIV | H.R. 5; Equality Act; Would prohibit discrimination based on sex, sexual orientation, and gender identity in a wide variety of areas including public accommodations and facilities, education, federal funding, employment, housing, credit, and the jury system. H.R. 2402; Fair and Equal Housing Act; Would amend the Fair Housing Act (FHA) under the Civil Rights Act of 1968 to add sexual orientation and gender identity as classes protected against discrimination in the sale, rental, or financing of housing. S. 788; Equality Act; Would prohibit discrimination based on sex, sexual orientation, and gender identity in a wide variety of areas including public accommodations and facilities, education, federal funding, employment, housing, credit, and the jury system. S. 1246; Fair and Equal Housing Act; Would amend the Fair Housing Act (FHA) under the Civil Rights Act of 1968 to add sexual orientation and gender identity as classes protected against discrimination in the sale, rental, or financing of housing. C.A.R. spoke with Congress regarding landlord improvements to meet the Americans with Disabilities Act requirements. | 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 | |
| 2512003 | CALIFORNIA ASSOCIATION OF REALTORS b7e197ae-e5eb-4828-ad8a-abebc4f4dee2 | Q3 | CALIFORNIA ASSOCIATION OF REALTORS | 7691 | CALIFORNIA ASSOCIATION OF REALTORS | 2020 | third_quarter | TAX | H.R. 188; SALT Deductibility Act; would remove the cap on state and local tax deductions. H.R. 257; SALT Fairness Act of 2019; would remove the cap on state and local tax deductions. H.R. 515; State and Local Tax Deduction Fairness Act of 2019; would remove the cap on state and local tax deductions. H.R. 1142; Stop the Attack on Local Taxpayers Act of 2019; would repeal the cap on state and local tax deductions. H.R. 2624; SALT Relief and Marriage Penalty Elimination Act of 2019; would raise the cap on state and local tax deduction to the level of the standard deduction. H.R. 5377; Restoring Tax Fairness for States and Localities Act; would double the SALT cap for married couples in 2019 and eliminate the SALT cap for 2020 & 2021. S. 437; Stop the Attack on Local Taxpayers Act; would repeal the cap on state and local tax deductions. C.A.R. spoke to Congress about the need to eliminate the cap on state and local tax deductions and/or take necessary action to change the current law to mitigate its impact. C.A.R. spoke to Congress about needing a home buyer tax incentive for home buyers who do not benefit from the mortgage interest deduction. C.A.R. spoke to Congress about indexing for inflation the mortgage interest deduction. C.A.R. spoke to Congress about changes to the capital gains exclusion for primary residences to make it easier to use in high-cost areas. C.A.R. spoke to Congress about concerns regarding commercial blight in the wake of the COVID-19 crisis, and incentives to avoid this. C.A.R. contacted Treasury and the IRS regarding extending the deadlines for 1031 exchanges and quarterly estimated taxes. | 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 | |
| 2512004 | CALIFORNIA ASSOCIATION OF REALTORS b7e197ae-e5eb-4828-ad8a-abebc4f4dee2 | Q3 | CALIFORNIA ASSOCIATION OF REALTORS | 7691 | CALIFORNIA ASSOCIATION OF REALTORS | 2020 | third_quarter | INS | H.R. 2157; Additional Supplemental Appropriations for Disaster Relief Act; extends the national flood insurance program's re-authorization. H.R. 3167; National Flood Insurance Program Re-authorization Act; would reform the national flood insurance program and extend the re-authorization. C.A.R. spoke with Congress regarding proposals to reform the mortgage flood insurance program. C.A.R. spoke with Congress regarding the difficulty of procuring fire insurance in areas throughout California. | 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);