lobbying_filings_raw: 73df3bf9-be39-4f8e-a00a-09173112ebc3

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
73df3bf9-be39-4f8e-a00a-09173112ebc3	2A	32362	PUBLIC CITIZEN	140490	PUBLIC CITIZEN	2017	second_quarter	2017-07-27T14:16:14.790000-04:00	100000.0	1	0	0	{"url": "https://lda.senate.gov/api/v1/filings/73df3bf9-be39-4f8e-a00a-09173112ebc3/", "filing_uuid": "73df3bf9-be39-4f8e-a00a-09173112ebc3", "filing_type": "2A", "filing_type_display": "2nd Quarter - Amendment", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/73df3bf9-be39-4f8e-a00a-09173112ebc3/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "100000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Joseph Stoshak", "dt_posted": "2017-07-27T14:16:14.790000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1600 20TH STREET, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20009", "registrant": {"id": 32362, "url": "https://lda.senate.gov/api/v1/registrants/32362/", "house_registrant_id": 32102, "name": "PUBLIC CITIZEN", "description": null, "address_1": "1600 20TH STREET, NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20009", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "NOYAN EYIGOR", "contact_telephone": "+1 202-588-1000", "dt_updated": "2026-01-15T12:37:43.672096-05:00"}, "client": {"id": 140490, "url": "https://lda.senate.gov/api/v1/clients/140490/", "client_id": 12, "name": "PUBLIC CITIZEN", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-03"}, "lobbying_activities": [{"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Acosta, labor secretary nomination, OSHA FY18 budget, Workplace safety issues affecting small businesses, HHS appropriations, Nurse and Health care worker protection act, HR 2428/S 1122- Accurate workplace injury and illness records restoration act, OSHA's Beryllium rule-making,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 63310, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "GARDNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Reed Proposal on SEC employee advocate, Dodd-Frank general defense, S 881/HR 2585-21st Century Glass-Steagall Act of 2017, HR 10-Financial Choice Act of 2017-Oppose, HR 797-Return to Prudent Banking Act of 2017, General financial reform issues, Promote good nominees to the SEC, CFTC, and other banking agencies.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56333, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTLETT", "nickname": null, "middle_name": null, "last_name": "NAYLOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "SEC disclosure issues, Oppose the choice act, Take on Wall Street Policies (Glass-Steagall, taxing wall street trades, closing the carried interest, and performance pay loopholes).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "CON", "general_issue_code_display": "Constitution", "description": "President Emoluments lawsuit, Legislation that poses a threat to the civil justice system including HR 1215, and HR 720", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66131, "prefix": null, "prefix_display": null, "first_name": "REMINGTON", "nickname": null, "middle_name": null, "last_name": "GREGG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 143538, "prefix": "mr", "prefix_display": "MR.", "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "HOLMAN", "suffix": "phd", "suffix_display": "PHD"}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "Oppose HR 1215-Protecting Access to Care Act of 2017, Medical malpractice legislation, HR 985-Fairness in Class Action Litigation and Furthering Asbestos Claim transparency act of 2017, HR 725-Innocent Party Protection Act, HR 720-Lawsuit abuse protection act of 2017,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66131, "prefix": null, "prefix_display": null, "first_name": "REMINGTON", "nickname": null, "middle_name": null, "last_name": "GREGG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Oppose Johnson Amendment repeal, Disclosure of President Trump's tax returns, Putting main street first-Inclusive prosperity act (S 805/HR 1144), tax reform, Wall Street speculation tax/financial transaction tax, Promote Brights Lines project legislation,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66139, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "PETERSON CASSIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Protect the CMS Nursing Home Arbitration Regulation from rollback, Single-payer health care legislation, Improving Access to Affordable Prescription Drugs Act (S.771 and HR 1776), Stop Price Gouging Act (S 1369/HR 2974), FAIR Drug Pricing act (S. 1131 and HR 2439), American Health Care Act (HR 1628), CREATES Act (S 974/HR 2212), FAST Generics Act (HR 2841), FDA Reauthorization Act of 2017 (S 934, HR 2430), Preserve Access to Affordable Generics Act (S 124).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65096, "prefix": null, "prefix_display": null, "first_name": "SHANNA", "nickname": null, "middle_name": null, "last_name": "DEVINE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66133, "prefix": null, "prefix_display": null, "first_name": "EAGAN", "nickname": null, "middle_name": null, "last_name": "KEMP", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 66542, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "KNIEVEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "S 951-Oppose Regulatory Accountability Act, Regulatory reform, HR 1215, HR 985, HR 725, HR 720 (also listed in Civic issue), General meeting with CPSC commissioners, Broadband privacy protections, Anti-civil justice bills, Defend CFPB, Dodd-Frank, and other financial reforms, consumer product safety", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57280, "prefix": null, "prefix_display": null, "first_name": "AMIT", "nickname": null, "middle_name": null, "last_name": "NARANG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66131, "prefix": null, "prefix_display": null, "first_name": "REMINGTON", "nickname": null, "middle_name": null, "last_name": "GREGG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Strengthen Office of Government Ethics (OGE) Act, Official Time Reform Act (HR 1364), Reform foreign agents registration Act (FARA), Amending definition of special government employee, STOCK Act amendment HR2277/S350, Political Intelligence Transparency Act (HR 2819), White House ethics executive order 13770, ban privately sponsored travel for Congress, FBI Whistleblower Protection Enhancement Act, FY18 Federal appropriations, Conflicts of interest in the administration, Support disclosure of political spending, Getting foreign money out of our elections,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 63310, "prefix": null, "prefix_display": null, "first_name": "EMILY", "nickname": null, "middle_name": null, "last_name": "GARDNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 143538, "prefix": "mr", "prefix_display": "MR.", "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "HOLMAN", "suffix": "phd", "suffix_display": "PHD"}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "S 297-Increased competition in Pharmaceuticals Act, HR 1703-Medical Prudent Communications Act of 2017, HR 2026- Pharmaceutical Information Exchange Act, S-252-Medicare Drug Savings act of 2017, Right to try legislation, Prescription Drug Importation, and HR 1223-OPEN Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66542, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "KNIEVEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "A rider free FY17 appropriations process and appropriate funding, CPC budget, The People's budget,\nCongressional Progressive Caucus budget.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66711, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": "JEAN", "last_name": "GILBERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "Opposition to delay of RMP rules for chemical plant safety", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "Emoluments clause,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143538, "prefix": "mr", "prefix_display": "MR.", "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "HOLMAN", "suffix": "phd", "suffix_display": "PHD"}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "College for All act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Opposition to Rosen nomination to DOT", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "NAFTA renegotiation, Buy American,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45692, "prefix": null, "prefix_display": null, "first_name": "LORI", "nickname": null, "middle_name": null, "last_name": "WALLACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 46, "name": "Consumer Product Safety Commission (CPSC)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	32102	DC	DC	US	US		0	0	247598		normalized_name_state	0.9

Links from other tables

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