home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b

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
4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b Q3 51172 U.S. CHAMBER INSTITUTE FOR LEGAL REFORM 157297 U S CHAMBER INSTITUTE FOR LEGAL REFORM 2009 third_quarter 2009-10-19T09:39:30-04:00 4240000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b/", "filing_uuid": "4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2009, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/4ae8657f-5a0c-48a4-b643-e4ab3f3eeb3b/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "4240000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Steven J. Law, Chief Legal Officer & General Counsel", "dt_posted": "2009-10-19T09:39:30-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1615 H STREET, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20062", "registrant": {"id": 51172, "url": "https://lda.senate.gov/api/v1/registrants/51172/", "house_registrant_id": 34805, "name": "U.S. CHAMBER INSTITUTE FOR LEGAL REFORM", "description": null, "address_1": "1615 H STREET, NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20062", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JAY BROWN", "contact_telephone": "+1 202-659-6000", "dt_updated": "2022-04-06T16:06:44.848904-04:00"}, "client": {"id": 157297, "url": "https://lda.senate.gov/api/v1/clients/157297/", "client_id": 12, "name": "U S CHAMBER INSTITUTE FOR LEGAL REFORM", "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": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "H.R. 759, Food and Drug Administration Globalization Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "S. 540/H.R. 1346, Medical Device Safety Act of 2009\n\nGeneral background on drug and device labeling rules and the doctrine of Federal preemption (no specific legislation introduced)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "S. 588/H.R. 1485, Cruise Vessel Security and Safety Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Potential legislation dealing with the Medicare Secondary Payer provisions of the Medicare statute (not yet introduced)\n\nH.R. 3200, America's Affordable Health Choices Act, provisions on Medicare Secondary Payer", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "H.R. 2868, Chemical Facility Anti-Terrorism Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "S. 437/H.R. 2519, A bill to amend the Internal Revenue Code of 1986 to allow the deduction of attorney-advanced expenses and court costs in contingency fee cases", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 2847, FY 2010 Commerce, Justice, Science, and Related Agencies Appropriations Act, provisions on the Legal Services Corporation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "H.R. 2454, American Clean Energy and Security Act of 2009, provisions on state attorneys general and civil litigation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "General background on the issue of over-criminalization of federal law (no specific legislation introduced)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "H.R. 1105/S. 673, Omnibus Appropriations Act of 2009, provisions on state attorney general HIPPA enforcement General background on U.S. capital markets competitiveness and regulation, securities litigation and attorney pay-to-play issues in securities litigation (no specific legislation)\n\nP.L. 104-67, Private Securities Litigation Reform Act of 1995\nS. 1551, Liability for Aiding and Abetting Securities Violations Act\nH.R. 2309, Consumer Credit Protection Agency Act, provisions on state attorney general enforcement \nH.R. 3126, Consumer Financial Protection Agency Act of 2009", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AUT", "general_issue_code_display": "Automotive Industry", "description": "H.R. 609, Right to Clean Vehicles Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R.1/S. 570, American Recovery and Reinvestment Act of 2009, provisions on state attorney general enforcement", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "S. 2831 (110th Congress bill), A bill to reauthorize the Federal Trade Commission, and for other purposes\nP.L. 110-314, Consumer Product Safety Improvement Act of 2008", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "S. 386, Fraud Enforcement and Recovery Act of 2009 H.R. 1788, False Claims Act Correction Act of 2009\nS. 458, False Claims Act Clarification Act\nS. 139, Data Breach Notification Act\nS. 386, Fraud Enforcement Recovery Act, provisions on civil investigative demand \nS. 418, Secondary Metal Theft Prevention Act of 2009, provisions on state attorneys general\n\nGeneral background and information on the doctrine of Federal preemption (no specific legislation introduced)\nGeneral background on state attorneys general and their enforcement authority/activities (no specific legislation introduced)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "S. 560/H.R. 1409, Employee Free Choice Act of 2009\nS. 181/H.R. 11, Lilly Ledbetter Fair Pay Act of 2009\nThe nomination of Craig Becker to serve on the National Labor Relations Board", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TOR", "general_issue_code_display": "Torts", "description": "H.R. 1020/S. 931, Arbitration Fairness Act of 2009 H.R. 1214, Payday Loan Reform Act of 2009\nS. 537/H.R. 1508, Sunshine in Litigation Act of 2009\nS. 263, Servicemembers Access to Justice Act of 2009\nS. 512/H.R. 1237, Fairness in Nursing Home Arbitration Act \nH.R. 991, Consumer Fairness Act of 2009\nH.R. 1728, Mortgage Reform and Anti-Predatory Lending Act, arbitration provisions\nH.R. 3451, Foreclosure and Sound Mortgage Servicing Act of 2009, arbitration provisions\nH.R. 3200, Affordable Health Choices Act, provisions on medical malpractice\nS. 445, Attorney-Client Privilege Protection Act of 2009\nS. 1504, Notice Pleading Restoration Act of 2009\nS. 585, Taxpayer Abuse Prevention Act, arbitration provisions\n\nGeneral background on legal reform issues, discovery reform, medical liability reform, medical malpractice and arbitration and other alternative dispute resolution mechanisms (no specific legislation introduced)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 18122, "prefix": null, "prefix_display": null, "first_name": "LISA", "nickname": null, "middle_name": null, "last_name": "RICKARD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46149, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": null, "last_name": "WEBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48440, "prefix": "ms", "prefix_display": "MS.", "first_name": "KRISTIN", "nickname": null, "middle_name": "LEIGH", "last_name": "NELSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46146, "prefix": null, "prefix_display": null, "first_name": "HAROLD", "nickname": null, "middle_name": null, "last_name": "KIM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 16 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 48.892ms