lobbying_filings_raw: 62f3c515-ebe1-4d5a-aebd-1329ce6ff5ef

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid	filing_type	registrant_id	registrant_name	client_id	client_name	filing_year	filing_period	received_date	amount_reported	is_amendment	is_no_activity	is_termination	raw_json	registrant_state	registrant_country	registrant_house_id	client_state	client_ppb_state	client_country	client_ppb_country	client_general_description	client_government_entity	affiliated_org_count	client_entity_id	client_government_unit_id	client_match_method	client_match_confidence
62f3c515-ebe1-4d5a-aebd-1329ce6ff5ef	Q1	4790	ASSOCIATED GENERAL CONTRACTORS OF AMERICA	104900	ASSOCIATED GENERAL CONTRACTORS OF AMERICA	2016	first_quarter	2016-04-20T12:04:37.583000-04:00	80000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/62f3c515-ebe1-4d5a-aebd-1329ce6ff5ef/", "filing_uuid": "62f3c515-ebe1-4d5a-aebd-1329ce6ff5ef", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2016, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/62f3c515-ebe1-4d5a-aebd-1329ce6ff5ef/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "80000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Jeffrey D. Shoaf", "dt_posted": "2016-04-20T12:04:37.583000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2300 WILSON BOULEVARD", "registrant_address_2": "SUITE #300", "registrant_different_address": false, "registrant_city": "ARLINGTON", "registrant_state": "VA", "registrant_zip": "22201", "registrant": {"id": 4790, "url": "https://lda.senate.gov/api/v1/registrants/4790/", "house_registrant_id": 31244, "name": "ASSOCIATED GENERAL CONTRACTORS OF AMERICA", "description": null, "address_1": "2300 WILSON BOULEVARD", "address_2": "SUITE #300", "address_3": null, "address_4": null, "city": "ARLINGTON", "state": "VA", "state_display": "Virginia", "zip": "22201", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DAVID ASHINOFF", "contact_telephone": "+1 202-547-5013", "dt_updated": "2026-01-30T10:02:56.110920-05:00"}, "client": {"id": 104900, "url": "https://lda.senate.gov/api/v1/clients/104900/", "client_id": 12, "name": "ASSOCIATED GENERAL CONTRACTORS OF AMERICA", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "VA", "state_display": "Virginia", "country": "US", "country_display": "United States of America", "ppb_state": "VA", "ppb_state_display": "Virginia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-02"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Highway Trust Fund Solvency; S.2606 exempting water and sewer construction from Private Activity Bond volume cap; Individual and corporate tax reform; Financial Accounting Standards Board issues; HR 1105, Permanent reduction or elimination of the estate and gift taxes; Repeal of health insurance tax; Implementation of the Water Resources Reform and Development Act; Like-kind Exchanges (Sec. 1031); Creation of a category for Public Buildings for Private Activity Bond eligibility and exemption of that category from volume cap; HR 636 America's Small Business Tax Relief (Section 179/Expensing); HR 880 Permanent R&D tax credit; HR 629 Built-in Gains Recognition; HR 765 (15-Year Depreciation); HR 2510 (Bonus Depreciation); HR 4468 Water Infrastructure Trust Fund Act; Section 199 NPRM; Energy Efficiency Tax Incentives Act(179D)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53189, "prefix": "mr", "prefix_display": "MR.", "first_name": "SCOTT", "nickname": null, "middle_name": "M", "last_name": "BERRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59161, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": "JOHN", "last_name": "LENIHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43667, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEPHEN", "nickname": null, "middle_name": "E", "last_name": "SANDHERR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ROD", "general_issue_code_display": "Roads/Highway", "description": "Monitor implementation of Map-21 and Fixing America's Surface Transportation (FAST) Act; Highway Trust Fund solvency;Surface Transportation funding; Legislative proposals to provide additional funding for federal highway & transit programs; FY 2017 THUD Appropriations", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59161, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": "JOHN", "last_name": "LENIHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Monitor implementation of MAP-21 and the FAST Act; Highway Trust Fund solvency; Surface Transportation funding; FY 2017 Department of Transportation Appropriations; Monitor Implementation of HR 3080, the Water Resources Reform & Development Act; Water Resources Development Act for 2016; Disadvantaged Business Enterprise Program; Harbor Maintenance Trust Fund; Inland Waterways Trust Fund; FAA Reauthorization; Water Infrastructure Funding in WRRDA", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59161, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": "JOHN", "last_name": "LENIHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43667, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEPHEN", "nickname": null, "middle_name": "E", "last_name": "SANDHERR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53189, "prefix": "mr", "prefix_display": "MR.", "first_name": "SCOTT", "nickname": null, "middle_name": "M", "last_name": "BERRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY 2017 appropriations for federal construction programs to provide for economic activity for Army Corps of Engineers - Civil Works; DOD Military Construction/VA; Labor Appropriations - Agency Budget Requests; GSA Federal Building Fund (FBF) FY 2017; FY 2017 Energy & Water Appropriations, Waters of the U.S. Regulation and Increasing Harbor Maintenance Trust Fund Revenue Outlays; Transportation & HUD Appropriations; FY 2017 Interior and Environment Appropriations - SRF Funding, American Iron and Steel Provisions, and EPA regulations on waters of the U.S., DERA Funding; FY 2017 Labor, Health and Human Services", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53189, "prefix": "mr", "prefix_display": "MR.", "first_name": "SCOTT", "nickname": null, "middle_name": "M", "last_name": "BERRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59161, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": "JOHN", "last_name": "LENIHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "HR 1671/S 71 - Government Neutrality in Contracting Act; OSHA Crystalline Silica Rulemaking; OSHA-proposed rule to improve tracking of workplace injuries/illnesses; Fair Pay and Safe Workplaces Executive Order #13673;", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "TRAC Act; Bid Shopping; Bid Listing; Buy American Reform;Protecting the attendance of federal employees at non-federal conferences; HR 1666 - The Design-Build Efficiency & Jobs Act of 2015; HR 1444 - Commonsense Contracting Act of 2015 (Reverse Auctions); HR 1671/S 71 - Government Neutrality in Contracting Act; Plans for mandating verification systems/policies for employers; S 1526, Construction Consensus Procurement Improvement Act of 2015; Construction Reform Act of 2015 H.R. 3106", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53189, "prefix": "mr", "prefix_display": "MR.", "first_name": "SCOTT", "nickname": null, "middle_name": "M", "last_name": "BERRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Immigration issues - comprehensive immigration reform, H2B visa reform efforts; Employment verification legislation; HR 1147, Legal Workforce Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "HR 1671 & S 71 - Government Neutrality in Contracting Act; Efforts to mandate employment verification system for employers; Definition of independent contractor; Multi-employer Pension Reform; Working Families Flexibility Act; HR 465/S 233; H J Res 29/S J Res 8 - A joint resolution providing for congressional disapproval under Chapter 8 of Title 5, United States Codes of the rule submitted by the National Labor Relations Board relating to representation case procedures; Implementation of workforce Innovation and Opportunity Act; Elementary and Secondary Education Act; Perkins Re-authorization; HR 548, Certainty in Enforcement Act; HR 549, Litigation Oversight Act; HR 550, EEOC Transparency and Accountability Act; HR 1187, Preserving Employee Wellness Programs Act; HR 4320, Workforce Democracy and Fairness Act; HR 4321, Employees Privacy Protection Act; Opposition to the \"Fair Pay and Safe Workplaces\" Executive Order; S 2015/HR 3549 Protecting Local Business Opportunity Act; Promoting Apprenticeships for Credentials and Employment Act; Pension Accountability Act H.R. 4029/S. 2147; S.2707/H.R. 4773 Protecting Workplace Advancement and Opportunity Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59161, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": "JOHN", "last_name": "LENIHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Employer Mandate Repeal; Auto Enroll Repeal Act; HR 928, to repeal the annual fee on health insurance providers enacted by the Patient Protection and Affordable Care Act; Save American Workers Act; HR 30/S 183; HR 2712/S. 1996: Commonsense Reporting and Verification Act; HR 2050, Middle Class Health Benefits Tax Repeal Act; HR 879, Ax the Tax on Middle Class Americans' Health Plans Act; HR 863/S. 1809, STARS Act; HR 3112 Be Open Act(Auto Enrollment); S 1415 Small Stability Act; HR 248/S305 American Job Protection Act; HR 2911/S1697 Small Business Healthcare Relief Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59161, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": "JOHN", "last_name": "LENIHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Overseas Buildings Operations; Embassy construction", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "Small Business Authorization; 8(a) program; National Defense Authorization Act of 2017; Reverse Auctions; Bid Listing; Bid Shopping; HR 1444 - The Commonsense Construction Contracting Act of 2015; Design-Build Construction; HR 1666, The Design-Build Efficiency & Jobs Act of 2015; HR 1481 Small Contractors Improve Competition Act of 2015; S 1526 Construction Consensus Improvement Act of 2015", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Clean Water and Drinking Water Revolving Loan Fund Program reauthorization; Water Infrastructure funding: grants and loans; Anaerobic Digester Grants; HR 499, S.2606 Sustainable Water Infrastructure Investment Act,removing cap on private activity bond for water and sewage facilities; HR 4468 Water Infrastructure Trust Fund Act; Provisions relating to transportation planning and environmental review; Rule relating to federal jurisdiction over \"Waters of the United States\" for the purpose of Clean Water Act permits; Monitor implementation of the Water Resources Development and Reform Act; Diesel Emission Reduction Act (DERA) funding and reauthorization; Reform of Prior Authorization for PAC Solicitation; Western Drought legislation and Rapid Act; Consolidated Appropriations Act - Waters of the US rider", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53189, "prefix": "mr", "prefix_display": "MR.", "first_name": "SCOTT", "nickname": null, "middle_name": "M", "last_name": "BERRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 55551, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "CHRISTIANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59161, "prefix": "mr", "prefix_display": "MR.", "first_name": "BRIAN", "nickname": null, "middle_name": "JOHN", "last_name": "LENIHAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 49781, "prefix": null, "prefix_display": null, "first_name": "SEAN", "nickname": null, "middle_name": null, "last_name": "O'NEILL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43654, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "D", "last_name": "SHOAF", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34649, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 32, "name": "Education, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 173, "name": "Federal Highway Administration (FHA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 167, "name": "Occupational Safety & Health Administration (OSHA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	VA	US	31244	VA	VA	US	US		0	0	992607		normalized_name_state	0.9

Links from other tables

12 rows from filing_uuid in lobbying_activities
7 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs