lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
11 rows where filing_uuid = "a7bef05b-3ca9-49e2-94de-bf411f5c64a6" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1573304 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | CIV | H.R. 777, ADA Notification Act of 2013, provisions relating to notification of violations. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573305 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | TAX | Tax reform proposals; S. 2260, Expiring Provisions Improvement Reform and Efficiency (EXPIRE) Act, all provisions; taxation of hotel room reservations made over the Internet; H.R.684, Marketplace Fairness Act of 2013, all provisions; S.743, Marketplace Fairness Act of 2013, all provisions; S.336, Marketplace Fairness Act of 2013, all provisions; S.2609, A bill to restore States' sovereign rights to enforce State and local sales and use tax laws, and for other purposes, all provisions; H.R.3086, Permanent Internet Tax Freedom Act, all provisions; S.1431, Internet Tax Freedom Forever Act, all provisions; H.R.434, Permanent Internet Tax Freedom Act, all provisions; S.31, Permanent Internet Tax Freedom Act of 2013, all provisions; issues related to online travel services. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573306 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | CPT | Patent reform proposals; H.R. 3309 the Innovation Act, all provisions; H.R.3540, Demand Letter Transparency Act of 2013, all provisions; S.1720, Patent Transparency and Improvements Act of 2013, all provisions; S.866, Patent Quality Improvement Act of 2013, all provisions; S.1013, Patent Abuse Reduction Act of 2013, all provisions; S.2146, Patent Fee Integrity Act, all provisions; S.2049,Transparency in Assertion of Patents Act, all provisions; S.1612, Patent Litigation Integrity Act of 2013, all provisions; H.R.2024, End Anonymous Patents Act, all provisions; HR XXXX, Targeting Rogue and Opaque Letters (TROL) Act, all provisions. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573307 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | HCR | PL III-148, Patient Protection and Affordable Healthcare Act, regulations regarding employer reporting and implementation of Act; H.R. 763, To Repeal Annual Fee on Health Insurance Providers Enacted by the Patient Protection and Affordable Care Act ("PPACA"), all provisions; H.R. 1254, Auto Enroll Repeal Act, all provisions, relating to PPACA; H.R. 2575, Save American Workers Act, all provisions, relates to PPACA; H.R. 2988, Forty Hours Is Full Time Act of 2013, all provisions; S.701, Forty Hours Is Full Time Act of 2013, all provisions; S.1188, Forty Hours Is Full Time Act of 2013, all provisions; S. 2546, Auto Enroll Repeal Act, all provisions. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573308 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | IMM | H2B Visa Rules, Wage Methodology for the Temporary Non-agricultural Employment H2B Program, Temporary Non-agricultural Employment of H-2B Aliens in the United States, Wage Methodology for the Temporary Non-Agricultural Employment H2B Program; J-1 Program: all provisions involving the J-1 cultural exchange program; Immigration reform proposals; S.744, Border Security, Economic Opportunity, and Immigration Modernization Act, all provisions; H.R.4238, To amend the Immigration and Nationality Act to provide for requirements for employers of H-2B nonimmigrants, and for other purposes, all provisions; H.R.15, Border Security, Economic Opportunity, and Immigration Modernization Act, all provisions; S.2218, Subnational Visa Waiver Program Act of 2014, all provisions; H.R.4178, American Entrepreneurship and Investment Act of 2014, all provisions; S.2048, Encouraging Trade and Investment from New Zealand Act, all provisions. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573309 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | TOU | Issues related to implementation of visa reforms; H.R. 1354, JOLT Act, all provisions, related to visa law reforms; Issues relating to Federal per diem rates; H.R. 1880, Protecting Resort Cities from Discrimination Act of 2013, all provisions, relates to agency policies on vacation destinations; H.R. 313, GSA Act of 2013, all provisions, relates to Federal agency conferences and travel; H.R. 2061, the Digital Accountability and Transparency Act (DATA Act), all provisions; S. 2218, Subnational Visa Waiver Program Act of 2014, all provisions; S.994, DATA Act, all provisions; issues related to government travel; H.R.4450,Travel Promotion, Enhancement, and Modernization Act of 2014, all provisions; S.2250, Travel Promotion, Enhancement, and Modernization Act of 2014, all provisions; H.R.4660, Commerce, Justice, Science, and Related Agencies Appropriations Act FY 2015, S.Amdt. 3291; S. XXXX, Financial services and General Govt Appropriations Bill FY 2015, all provisions; H.R.5016, Financial Services and General Government Appropriations Act FY 2015, provisions related to government travel. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573310 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | LBR | H2B Regulation, Wage Methodology for the Temporary Non-agricultural Employment H2B Program; Temporary Non-agricultural Employment of H-2B Aliens in the United States; Wage Methodology for the Temporary Non-Agricultural Employment H2B Program, Part 2; Labor Rulings and Appointments; OFCCP Section 503 Regulations, provisions related to hiring of person with disabilities; H.R. 1120, Preventing Greater Uncertainty in Labor Management Relations Act, all provisions. H.R. 4320, Workforce Democracy and Fairness Act, all provisions ; H.R. 4321, Employee Privacy Protection Act, all provisions ; S.2178, Workforce Democracy and Fairness Act, all provisions ; S.1737, Minimum Wage Fairness Act, all provisions; S.2223, Minimum Wage Fairness Act, all provisions ; H.R. 1010, Fair Minimum Wage Act of 2013, all provisions . H.R. 4660, Commerce, Justice, Science, and Related Agencies Appropriations Act FY 2015, H. Amdt. 759; H.R. 4745, Transportation, Housing and Urban Development and Related Agencies Appropriations Act, FY 2015, H.Amdt.826; H.R. 4870, Department of Defense Appropriations Act Fiscal Year 2015, H. Amdt. 926; H.R. 4923, Energy and Water Development and Related Agencies Appropriations Act FY 2015, H. Amdt. 1021; H.R.5016, Financial Services and General Government Appropriations Act FY 2015, H.Amdt. 1074 | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573311 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | INS | H.R. 508, Terrorism Risk Insurance Act of 2002 Reauthorization Act of 2013, all provisions; H.R. 2146, Terrorism Risk Insurance Program Reauthorization Act of 2013, all provisions; H.R.4871,TRIA Reform Act of 2014, all provisions; S.2244,Terrorism Risk Insurance Program Reauthorization Act of 2014, all provisions. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573312 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | TEC | Online Travel Company Taxation, taxation of hotel room reservations made over the Internet; Emergency Services Dialing procedures; S.1364, Digital Goods Act, all provisions; H.R.3724, Digital Goods and Services Tax Fairness Act of 2013, all provisions; issues related to online consumer deception; issues related to data breach; issues related to cyber security; H.R.3086, Permanent Internet Tax Freedom Act, all provisions; S.1431, Internet Tax Freedom Forever Act,all provisions; H.R.434, Permanent Internet Tax Freedom Act, all provisions; S.31, Permanent Internet Tax Freedom Act of 2013, all provisions. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573313 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | CSP | Issues relating to implementation of 15 USC 8001, Virginia Greame Pool and Spa Safety Act, all provisions, implementation compliance obligations of safety provisions for public pools and spas; H.R. 777, ADA Notification Act of 2013, provisions relating to notification of violations; issues related to online travel services. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-04:00 | |
| 1573314 | AMERICAN HOTEL & LODGING ASSOCIATION a7bef05b-3ca9-49e2-94de-bf411f5c64a6 | Q2 | AMERICAN HOTEL & LODGING ASSOCIATION | 79290 | AMERICAN HOTEL & LODGING ASSOCIATION | 2014 | second_quarter | NAT | H.R. 3286 The Protecting States Opening National Parks Act, all provisions; S.1572, Protecting States Opening National Parks Act, all provisions; H.R. 3661 The Public Access to Public Lands Guarantee Act, all provisions; S. 1750 Public Access to Public Lands Guarantee Act, all provisions; S.2104, National Park Access Act, all provisions; H.R.4353, Shutdown Windfall Reimbursement Act, all provisions. | Commerce, Dept of (DOC),Consumer Product Safety Commission (CPSC),Federal Communications Commission (FCC),Federal Trade Commission (FTC),General Services Administration (GSA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Justice, Dept of (DOJ),Labor, Dept of (DOL),Natl Labor Relations Board (NLRB),SENATE,Small Business Administration (SBA),State, Dept of (DOS),White House Office | 360000 | 0 | 0 | 2014-07-21T16:39:06.097000-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);