lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where filing_uuid = "5c19010e-8a7f-48bf-8a4d-f2e79b21876f" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1085742 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | HCR | H.R. 2, Repealing the Job-Killing Health Care Law Act; H. Res. 9, Instructing certain committees to report legislation replacing the job-killing health care law; Patient Protection and Affordable Health Care Act (P.L. 111-148); S. 20, American Job Protection Act; Medical Malpractice Reform; Small Business Health Plans; Health Savings Accounts; Portability of Health Care Benefits; S. 720, Repeal the CLASS Entitlement Act; Repeal the Patient Protection and Affordable Health Care Act (P.L. 111-148) | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-04:00 | |
| 1085743 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | ENV | EPA: Greenhouse Gas Regulations; EPA: Lead, Renovation, Repair, and Painting Program for Public and Commercial Buildings; S.Amdt.183 to S.493, the SBIR/STTR Reauthorization Act of 2011 | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-04:00 | |
| 1085744 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | FIN | Access to Capital; Small Business Lending/Community Banks | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-04:00 | |
| 1085745 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | TAX | 3 Percent Withholding; Form 1099 Reporting Requirements included in the Patient Protection and Affordable Care Act (P.L. 111-148); S. Amdt. 9 to S. 223, FAA Air Transportation Modernization and Safety Improvement Act; H.R. 4, Small Business Paperwork Mandate Elimination Act; American Job Builders Tax Reform Act; Completed Contract Method; Medicare Hospital Insurance Tax on investment income ; 1986 Tax Reform; S.Amdt.161 to S.493, the SBIR/STTR Reauthorization Act of 2011; Taxation of business income in partnerships and S-corps | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-04:00 | |
| 1085746 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | GOV | H.R. 10/S.299, the Regulations from the Executive in Need of Scrutiny Act; H. Res. 72, directing certain standing committees to inventory and review, existing, pending and proposed regulations and orders from agencies of the federal government | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-04:00 | |
| 1085747 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | ENG | Associated Builders & Contractors Job Creation Proposal (issues related to a comprehensive energy policy) | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-04:00 | |
| 1085748 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | IMM | H-2B Visa Program; E-Verify Program; Form 1-9; DOL- Wage Methodology for the Temporary Non-Agricultural Employment H-2B Program | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-04:00 | |
| 1085749 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. 5c19010e-8a7f-48bf-8a4d-f2e79b21876f | Q1 | ASSOCIATED BUILDERS AND CONTRACTORS, INC. | 4766 | ASSOCIATED BUILDERS AND CONTRACTORS INC | 2011 | first_quarter | LBR | H.R. 735/S. 119, Government Neutrality in Contracting Act; Government Mandated Project Labor Agreements; Injury Illness Prevention Program; Davis-Bacon Prevailing Wage; DOL-Wage Methodology for Temporary Non-Agricultural Employment H-2B Program; S. Amdt 19 to S. 223, FAA Air Transportation Modernization and Safety Improvement Act; H.R. 746 Davis-Bacon Repeal Act; H.R. 745 Davis-Bacon Repeal Act; Amdt 166/ Amdt 273 to H.R. 1, the Full-Year Continuing Appropriations Act for Fiscal Year 2011; S. 217/H.R. 972, Secret Ballot Protection Act ; High Road Government Contracting Policy; DOL/WHD: Right To Know Under the Fair Labor Standards Act; DOL/OLMS: Persuader Agreements: Employer and Labor Relations Consultant Reporting Under the LMRDA; DOL/OLMS: Persuader Agreements: Consultant Form LM-21 Receipts and Disbursements Report ; DOL/OLMS: Labor Organization Annual Financial Report (Form LM-2); DOL/OLMS: Trust Annual Report (Form T-1); NLRB: Proposed Rules Governing Notification of Employee Rights Under the National Labor Relations Act; NLRB: Effective Remedies in Organizing Campaigns; DOL/OSHA: Occupational Injury and Illness Recording and Reporting Requirements--Musculoskeletal Disorders (MSD) Column; DOL/OSHA: Interpretation of OSHAs Provisions for Feasible Administrative or Engineering Controls of Occupational Noise; DOL/OSHA: Injury and Illness Prevention Program; DOL/OSHA: Voluntary Protection Program; Secret-ballot elections ; Secondary Employer Bannering; Amdt. 3 and 41 to H.R. 658, the FAA Reauthorization and Reform Act; Section 903 of H.R. 658, FAA Air Transportation Modernization and Safety Improvement Act; Bargaining units; Job-site access; Voluntary recognition | Environmental Protection Agency (EPA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE | 730000 | 0 | 0 | 2011-04-19T13:39:12.993000-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);