lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
17 rows where filing_uuid = "08a098a8-e31e-4dc2-91ee-87cc25b30fe7" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 614057 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | SMB | Additional Gulf Coast Small Business Disaster Relief: S. 690 - Catastrophic Disaster Recovery Improvements Act of 2007 H.R. 1212 -Catastrophic Disaster Recovery Improvements Act of 2007 Disaster Relief for Small Business Owners: H.R. 1044 - Small Business Disaster Response & Loan Improvements Act of 2007 S. 599-Private Disaster Loans Act of 2007 H.R. 1012 - Small Business Growth Act of 2007 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614058 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | INS | Insurance Industry Competitiveness: S. 618 - Insurance Industry Competition Act of 2007 H.R 1081 - Insurance Industry Compeition Act of 2007 Insurance Regulation: H.R. 1065 - Nonadmitted & Reinsurance Reform Act of 2007 (Surplus Lines) S. 40 - National Insurance Act of 2007 (Optional Federal Charter) H.R. 3200 - National Insurance Act of 2007 (Optional Federal Charter) National Flood Insurance Program Modifications: H.R. 1682 - The Flood Insurance Reform & Modernization Act of 2007 S. 920 - Multiple Peril Insurance Act of 2007 H.R. 91 - Homeowners Protection Act of 2007 H.R. 3121 - The Flood Insurance Reform & Modernization Act of 2007 S. 2284 - The Flood Insurance Reform & Modernization Act of 2007 S. 1938 - The National Flood Mapping Act of 2007 H.R. 3959 - To amend the National Flood Insurance Act of 1968 to provide for the phase-in of actuarial rates for certain pre-FIRM properties. Homeowners' Insurance Affordability & Availability: S. 926 - Policyholder Disaster Protection Act of 2007 S. 928 - Homewoners Protection Act of 2007 H.R. 164 - Policyholder Disaster Protection Act of 2007 H.R. 330 - Homeowners Insurance Availability Act of 2007 S. 2327 - Homeowners Insurance Assistance Act of 2007 Establishment of a National Catastrophe Commission: S. 2286 - Commission on Natural Catastrophe Risk Management and Insurance Act of 2007 S. 292 - Commission on Catastrophic Disaster Risk & Insurance Act of 2007 H.R. 537 - Commission on Catastrophic Disaster Risk & Insurance Act of 2007 H.R. 3355 - Homeowners' Defense Act of 2007 S. 2310 - Homeowners' Defense Act of 2007 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614059 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | EDU | Smart Growth & School Quality: H.R. 17 - Secure Rural Schhols & Community Self-Determination Reauthorization Act of 2007 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614060 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | CAW | Wetlands Protection: H.R. 2421 - Clean Water Restoration Act of 2007 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614061 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | CPT | Patent Reform: S.1145 / H.R. 1908 - Patent Reform Act of 2007 S. 749 / H.R. 1306 - To modify the prohibition on recognition by United States courts of certain rights relating to certain marks, trade names, or commercial names. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614062 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | TEC | Network Neutrality: S. 215 - Internet Freedom Preservation Act | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614063 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | TRA | Transportation Funding & Infrastructure Improvement: S. 775 - National Infrastructure Improvement Act of 2007 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614064 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | BAN | Appraisal: H.R. 2061 - Predatory Mortgage Lending Practices Act Responsible Lending: H.R. 3915 - The Mortgage Reform and Anti-Predatory Lending Act of 2007 H.R. 3725 - The Mortgage Disclosure Simplification Act of 2007 S. 2153 - The Mortgage Disclosure Simplification Act of 2007 H.R. 3705 - Fair Disclosure for Homeowners Act of 2007 S. 2114 - American Home Ownership Preservation Act of 2007 H.R. 3705 - Fair Disclosure for Home Owners Act of 2007 H.R. 3296 - Mortgage Broker Transparency & Accountability Act of 2007 H.R. 2061 - Predatory Mortgage Lending Practices Reduction Act S. 1299 - Borrower's Protection Act of 2007 S. 2452 - Home Ownership Preservation and Protection Act of 2007 Separation of Banking & Commerce: H.R. 111 - Community Choice in Real Estate Act S. 413 - Community Choice in Real Estate Act Identity Verification: H.R. 480 - To amend the Truth in Lending Act to prohibit issuance of residential mortgages to any individual who lacks a Social Security account number. | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614065 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | FIN | FDIC ILC Moratorium: H.R. 698/S. 1356 -Industrial Bank Holding Company Act of 2007 Credit Union Reform: H.R. 1537- Credit Union Regulatory Improvements Act of 2007 GSE Reform: H.R. 1427- Federal Housing Finance Reform Act of 2007 S. 2391 - GSE Mission Improvement Act of 2007 S. 2169 - Promoting Refinancing Opportunities for Mortgages Impacted by the Subprime Emergency (PROMISE) Act of 2007 S. 2346 - Promoting Refinancing Opportunities for Mortgages Impacted by the Subprime Emergency (PROMISE) Act of 2007 S. 1100 - Federal Housing Enterprise Regulatory Reform Act of 2007 H.R. 5140 - Economic Stimulus Act of 2008 (Provisions pertaining to GSE Conforming Loan Limits) H.R. 3221 -- Foreclosure Prevention Act of 2009 (Provisions pertaining to GSE Conforming Loan Limits) | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614066 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | TAX | Catastrophe Savings Accounts: S. 927 - Catastrophe Savings Accounts Act of 2007 H.R 1787 - Catastrophe Savings Accounts Act of 2007 Health Insurance Tax Deductions for Small Businesses: H.R. 3660 - Equity for Our Nation's Self Employed Act of 2007 S. 2339 - Equity for Our Nation's Self Employed Act of 2007 H.R. 914 - Tax Equity & Affordability Act of 2007 Alternative Minimum Tax: H.R. 1366 - Individual Alternative Minimum Tax Repeal Act of 2007 S. 55 - Individual Alternative Minimum Tax Repeal Act of 2007 Small Business Tax Deductions: H.R. 976 - Small Business Tax Relief Act of 2007 Tax Treatment of Passive Income from Partnerships: H.R. 2834 - To amend the Internal Revenue Code of 1986 to treat income received by partners for performing investment management services as ordinary income received for the performance of services. S. 1624 / H.R. 2785 - To amend the Internal Revenue Code of 1986 to provide that the exception from the treatment of publicly traded partnerships as corporations for partnerships with passive-type income shall not apply to partnerships directly or indirectly deriving income from providing investment adviser and related asset management services. Tax Treatment of Environmental Remediation Costs: H.R. 1753 - To amend the Internal Revenue Code of 1986 to make the expensing of environmental remediation costs permanent law and to repeal the recapture of such expenses under section 1245 of such Code. Taxation of Property Depreciation: H.R. 2014 - Leasehold Improvement Depreciation Act of 2007 H.R. 3996 - Temporary Tax Relief Act of 2007 Extension of Low-income Tax Credits to Victims of Gulf Coast Hurricanes: H.R. 1562 - Katrina Housing Relief Act of 2007 Internet Tax Moratorium Extension: H.R. 3678 - Internet Tax Freedom Act Amendment Act of 2007 Homeownership Tax Credits: H.R.3221 - Foreclosure Prevention Act of 2008 (Sections pertaining to Homeownership Tax Credit S. 2566 - A bill to amend the Internal Revenue Code of 1986 to provide a Federal income tax credit for cer… | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614067 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | DIS | Disaster Mitigation: H.R. 913 - Hurricane & Tornado Mitigation Investment Act of 2007 S. 930 - Hurricane & Tornado Mitigation Investment Act of 2007 S. 2328 - Property Mitigation Assistance Act of 2007 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614068 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | HCR | Expansion of Small Business Health Insurance Coverage: S. 158 - Access to Affordable Health Care Act Expansion of Small Business Health Insurance Coverage (cont'd): H.R. 1200 - American Health Security Act of 2007 S. 334 - Healthy Americans Act S. 685 - Reform Health Care Now Act H.R. 853 - Wellness & Prevention Act of 2007 H.R. 676 - United States Health Insurance Act (or the Expanded & Improved Medical for All Act) H.R. 241 - Small Business Health Fairness Act of 2007 S. 733 - Promoting Health Care Purchasing Cooperatives Act S. 2795 - Small Business Health Options Program Act of 2008 S. 2818 - The Small Business Health Plans Act of 2008 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614069 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | HOU | FHA Reform: H.R. 1752 - Expanding American Homeownership Act S. 947 - 21st Centurty Housing Act FHA Reform, continued: H.R. 1852 - Expanding American Homeownership Act S. 2338 - FHA Modernization Act of 2007 H.R. 2139 - FHA Manufactured Housing Loan Modernization Act of 2007 H.R. 5140 - Economic Stimulus Act of 2008 (Provisions related to FHA Loan Limits) H.R. 3221 - A bill to provide needed housing reform and other purposes (Provisions related to FHA Loan Limits) Section 8 Housing Reform: H.R. 1851/S. 2684 - The Section 8 Voucher Reform Act of 2007 H.R. 3965 - The Mark-to-Market Extension & Enhancement Act of 2007 Development of Affordable Housing Trust Fund: H.R. 2895 -National Affordable Housing Trust Fund Act of 2007 S. 2523 - National Affordable Housing Trust Fund Act of 2007 Expanding Home Loan Opportunities for Native Americans: H.R. 3002 - Native American Economic Development and Infrastructure for Housing Act of 2007 H.R. 1676 - Native American Home Ownership Opportunity Act of 2007 Rural Housing: H.R. 1982 - The Rural Housing & Economic Development Act H.R. 3878 - The Section 515 Rural Housing Property Transfer Improvement Act of 2007 Veterans Housing: H.R. 2385 - The 21st Century GI Bill of Rights Act of 2007 S. 1409 - The 21st Century GI Bill of Rights Act of 2007 H.R. 4884 - Helping Our Veterans to Keep Their Homes Act of 2008 H.R. 4539 - Department of Veterans Affairs Loan Guaranty Cost Reduction Act of 2007 H.R. 5566/5561; S. 2768 - Veterans Mortgage Stimulus Clarification Act of 2008 (To raise VA Loan Limits) Appraisal Reform: H.R. 1723 - Fair FHA Appraisal Act S. 1222 - STOP FRAUD Act Other Issues: Farm Credit Home Loans: H.R. 2419 - Food & Energy Security Act of 2007 Elderly Housing: H.R. 2930 - The Section 202 Supportive Housing for the Elderly Act of 2007 Housing in the Gulf: H.R. 1227 - Gulf Coast Hurricane Housing Recovery Act of 2007 Monies for International Housing Efforts: H.R. 2764 - Department of State, Foreign Operations & Related Programs Appropriations Act, 2008 … | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614070 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | BNK | Bankruptcy Reform: H.R. 3609 - Emergency Home Ownership & Mortgage Equity Protection Act of 2007 S. 2136 -Helping Families Save Their Homes in Bankruptcy Act of 2007 H.R. 3778 / S. 2133 - Home Owners Mortgage & Equity Savings Act (HOMES Act) H.R. 3221 -- Foreclosure Prevention Act of 2009 (Cramdown Provisions) | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614071 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | ENV | Comprehensive National Disaster Policy: H.R. 931 - National Hurricane Research Initiative of 2007 Climate Change: S. 2191 - America's Climate Security Act of 2007 | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614072 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | CSP | Identity Theft Prevention: S. 1178 - Identity Theft Prevention Act S. 238 -Social Security Number Misuse Prevention Act Data Security: S. 495 -Personal Data Privacy & Security Act of 2007 H.R. 958 -The Data Accountability & Trust Act of 2007 H.R. 836 - Cyber Security Enhancement & Consumer Data Protection Act of 2007 Do-Not-Call Legislation: H.R. 2601 - Do-Not-Call Registry Fee Extension Act of 2007 S. 781 - Do-Not-Call Registry Fee Extension Act of 2007 FTC: DNC Education & Compliance Fees FTC: Identity Theft Education | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-04:00 | |
| 614073 | NATIONAL ASSOCIATION OF REALTORS 08a098a8-e31e-4dc2-91ee-87cc25b30fe7 | Q1 | NATIONAL ASSOCIATION OF REALTORS | 27070 | NATIONAL ASSOCIATION OF REALTORS | 2008 | first_quarter | RES | Private Property Rights: H.R. 3048 / S. 48 - Private Property Rights Protection Act of 2007 H.R. 3053 - A bill to Protect Private Property Rights Eminent Domain: H.R 926 - STOPP Act of 2007 Brownfields Cleanup: H.R. 644 - Brownfields Redevelopment Enhancement Act of 2007 RESPA Reform: H.R. 3915 - Mortgage Reform and Anti-Predatory Lending Act of 2007 (Sections Pertaining to Real Estate Settlement) Consulation with HUD Regarding GFEs and HUD-1 Standards | Agriculture, Dept of (USDA),Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Deposit Insurance Corporation (FDIC),Federal Emergency Management Agency (FEMA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,U.S. Agency for International Development (USAID),Veterans Affairs, Dept of (VA) | 3140000 | 0 | 0 | 2008-04-21T16:59:36-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);