lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "1f7c411f-7edf-4af8-ad27-e716c19da585" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: government_entities, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3197324 | MISSY EDWARDS STRATEGIES, LLC 1f7c411f-7edf-4af8-ad27-e716c19da585 | Q2 | MISSY EDWARDS STRATEGIES, LLC | 400547641 | REAL ESTATE ROUNDTABLE | 2024 | second_quarter | ENG | Energy Efficiency Incentives, Energy Star, Tax Incentives, Tenant Star, Energy Consumption Data, Building Rating Issues | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2024-07-17T20:48:12-04:00 | |
| 3197325 | MISSY EDWARDS STRATEGIES, LLC 1f7c411f-7edf-4af8-ad27-e716c19da585 | Q2 | MISSY EDWARDS STRATEGIES, LLC | 400547641 | REAL ESTATE ROUNDTABLE | 2024 | second_quarter | FIN | Credit Risk Retention OTC Derivatives Basel III, Liquidity Coverage Ration, HVCRE Rule, FRTB, Basel III Endgame Floor Insurance; Terrorism Risk Insurance CFIUS Reform (FIRRMA) Beneficial Ownership, Corporate Transparency Act, ENABLERS Act Cyber Security (H.R. 3776, H.R. 3359); Cyber Insurance Current Expected Credit Losses (CECL) LIBOR Reform Forbearance Issues Emergency Rental Assistance for Residential Business Tenants (e.g., H.R. 7301) Restart Act (S. 3814) Corporate Governance Through Diversity Act (H.R. 1018, S. 360) Pandemic Risk Insurance Troubled Deb Restructuring (TDR) CECL Reg S-K Reform SEC Proposed Rule on Financial Climate Risk Reporting SEC Proposed Rules on: Amendments to Form PF, Private Fund Advisers, Cybersecurity Risk Management SEC Custody Rule | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2024-07-17T20:48:12-04:00 | |
| 3197326 | MISSY EDWARDS STRATEGIES, LLC 1f7c411f-7edf-4af8-ad27-e716c19da585 | Q2 | MISSY EDWARDS STRATEGIES, LLC | 400547641 | REAL ESTATE ROUNDTABLE | 2024 | second_quarter | HOM | Model Standard for Private Sector Emergency Preparedness Information Sharing and Resilience Cyber Terrorism CISPA Cyber Intelligence Sharing and Protection Act Cybersecurity (H.R. 3359, H.R. 3776) Beneficial Ownership Ban Secrecy Act (BSA) Geographic Tracking Orders (GTO) CFIUS Reform Pandemic Risk | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2024-07-17T20:48:12-04:00 | |
| 3197327 | MISSY EDWARDS STRATEGIES, LLC 1f7c411f-7edf-4af8-ad27-e716c19da585 | Q2 | MISSY EDWARDS STRATEGIES, LLC | 400547641 | REAL ESTATE ROUNDTABLE | 2024 | second_quarter | TAX | "Carried Interest Fairness Act" and carried interest reform, including changes in holding period Energy efficiency and clean energy tax incentives, including the E-QUIP Act and Inflation Reduction Act, and regulatory implementation Like-Kind Exchanges (Sec. 1031) Completed contract method of accounting and condominium construction (Section 460(e) Fair Accounting for Condominium Construction Act (HR 4280) FIRPTA reform and Parity for Non-Traded REITS Act Net investment income tax and SECA liability Cost recovery, residential rental property and nonresidential property Low-income housing tax credit and the Affordable Housing Credit Improvement Act (S 1557 and HR 3238) Proposed and final tax regulations under section 897 and 892 REIT rules, including investments in related parties Retail Revitalization Act of 2023 (HR 3749) Cancellation of Indebtedness income (section 108) (HR 5580, Saving Our Mainstreet American Locations for Leisure and Shopping Act) Capital gains tax rate State and local tax deduction 20% deduction for pass-through business income (section 199A) and tax rules on pass-through income, including Senator Wyden pass-through reform discussion draft Taxing appreciated capital gains at death Opportunity Zone reform, reporting, and deadline extensions (HR 5761, Opportunity Zones Transparency, Extension and Improvement Act) Estate tax valuation discounts and rules for grantor trusts Revitalizing Downtowns Act and tax incentives for property conversions Passive Foreign Investment Company proposed tax regulations (REG-118250-20) Taxing unrealized gains annually - Administration's minimum tax proposal and Chairman Wyden proposal TCJA Permanency Act Business interest deductibility and section 163(j) Active loss limitation and section 461(l) S. 2518, Ending Tax Breaks for Massive Sovereign Wealth Funds Act S. 2224, Stop Predatory Investing Act Tax Relief for American Families and Workers Act (H.R. 7024) | Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 30000 | 0 | 0 | 2024-07-17T20:48:12-04:00 | |
| 3197328 | MISSY EDWARDS STRATEGIES, LLC 1f7c411f-7edf-4af8-ad27-e716c19da585 | Q2 | MISSY EDWARDS STRATEGIES, LLC | 400547641 | REAL ESTATE ROUNDTABLE | 2024 | second_quarter | BAN | 16. Specific lobbying issues GSE Reform Housing Bills Dodd Frank - Wall Street Reform and Consumer Protection Act Dodd Frank Regulations (Volker Rule, Credit Risk Retention, OTC Derivatives) H.R. 4620, S. 2155 Basel III, Liquidity Coverage Ration, HVCRE Rule, S. 2155 Terrorism Risk Insurance Flood Insurance (NFIP Reauthorization) CFIUS Reform (FIRRMA) Beneficial Ownership, Bank Secrecy Act (BSA) Cyber Security (H.R. 3776, H.R. 3359) Current Expected Credit Losses (CECL) Cannabis Issues, Safe Banking Act (H.R. 1595) LIBOR Reform Pandemic Risk Insurance Act Workplace Recovery Act Mark to Market Accounting Federal Reserve Credit Facilities Forbearance Issues TALF Main Street Lending Program CARES Act Stimulus Legislation Liability Reform Troubled Debt Restructuring (TDR) Improving Corporate Governance Through Diversity Act (H.R. 1277, S.374) | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2024-07-17T20:48:12-04:00 | |
| 3197329 | MISSY EDWARDS STRATEGIES, LLC 1f7c411f-7edf-4af8-ad27-e716c19da585 | Q2 | MISSY EDWARDS STRATEGIES, LLC | 400547641 | REAL ESTATE ROUNDTABLE | 2024 | second_quarter | TRA | Infrastructure finance issues (e.g., repatriation, Highway Trust Fund) Public-Private Partnerships, TIFIA modernization Permitting requirements (e.g., NEPA) Transportation matters in the Bipartisan Infrastructure Law | HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),Treasury, Dept of | 30000 | 0 | 0 | 2024-07-17T20:48:12-04:00 | |
| 3197330 | MISSY EDWARDS STRATEGIES, LLC 1f7c411f-7edf-4af8-ad27-e716c19da585 | Q2 | MISSY EDWARDS STRATEGIES, LLC | 400547641 | REAL ESTATE ROUNDTABLE | 2024 | second_quarter | INS | Terrorism Risk Insurance National Catastrophic Risk Insurance Flood Insurance (NFIP Reauthorization) LIBOR Reform Beneficial Ownership CFIUS Reform Cyber Terrorism Pandemic Risk Insurance Act Workplace Recovery Act Economic Recovery Liability Reform Troubled Debt Restructuring (TDR) CECL | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2024-07-17T20:48:12-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);