lobbying_filings_raw: bddabd0b-50e1-4d2f-bcb9-97ff4af55c33

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
bddabd0b-50e1-4d2f-bcb9-97ff4af55c33	Q3	25842	MORGAN STANLEY & CO. LLC	133644	MORGAN STANLEY & CO LLC	2009	third_quarter	2009-10-20T10:47:10-04:00	720000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/bddabd0b-50e1-4d2f-bcb9-97ff4af55c33/", "filing_uuid": "bddabd0b-50e1-4d2f-bcb9-97ff4af55c33", "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/bddabd0b-50e1-4d2f-bcb9-97ff4af55c33/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "720000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Michael J. Stein", "dt_posted": "2009-10-20T10:47:10-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "401 9TH STREET, NW, #650", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 25842, "url": "https://lda.senate.gov/api/v1/registrants/25842/", "house_registrant_id": 31813, "name": "MORGAN STANLEY & CO. LLC", "description": null, "address_1": "401 9TH STREET, NW, #650", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JOSH WILSUSEN", "contact_telephone": "+1 202-654-2003", "dt_updated": "2026-01-22T15:54:26.131438-05:00"}, "client": {"id": 133644, "url": "https://lda.senate.gov/api/v1/clients/133644/", "client_id": 12, "name": "MORGAN STANLEY & CO LLC", "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-01"}, "lobbying_activities": [{"general_issue_code": "BNK", "general_issue_code_display": "Bankruptcy", "description": "Amendments to Bankruptcy Laws", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39218, "prefix": null, "prefix_display": null, "first_name": "JOSHUA", "nickname": null, "middle_name": null, "last_name": "WILSUSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41072, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "STEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "China Market Access\nEU Clearing and Settlement\nEU-US Accounting Convergence\nUS-China Relationship", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 2783, "prefix": null, "prefix_display": null, "first_name": "KRISTIN", "nickname": null, "middle_name": null, "last_name": "ROESSER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41072, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "STEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Issues Related to Financial Regulatory Restructuring\nIssues Related to Mortgage Industry Reforms\nIssues Related to Federal Government's Financial Market Assistance", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39218, "prefix": null, "prefix_display": null, "first_name": "JOSHUA", "nickname": null, "middle_name": null, "last_name": "WILSUSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41072, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "STEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 33213, "prefix": null, "prefix_display": null, "first_name": "WESTON", "nickname": null, "middle_name": null, "last_name": "COULAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Issues Related to Broker Dealers\nEnergy Legislation\nIssues Related to Derivatives \nIssues Related to Financial Market Systemic Risk Issues Related to Commodity Markets\nIssues Related to Futures Markets\nIssues Related to Hedge Funds\nIssues Related to Investment Advisers\nIssues Related to Financial Regulatory Restructuring\nIssues Related to Pension Reform\nCommodity Exchange Act Reform\nCommercial Arbitration Reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39218, "prefix": null, "prefix_display": null, "first_name": "JOSHUA", "nickname": null, "middle_name": null, "last_name": "WILSUSEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41072, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "STEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 33213, "prefix": null, "prefix_display": null, "first_name": "WESTON", "nickname": null, "middle_name": null, "last_name": "COULAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Taxation of Financial Products\nActive Financing Legislation \nBusiness Activity Tax \nEnergy Tax Legislation Technical Corrections to Pension Protection Act\nTax Information Reporting \nPrivate Equity Taxation\nIssues Related to Tax-Exempt Bonds\nIssues Related to Pensions & Deferred Compensation\nIssues Related to Net Operating Losses\nIssues Related to International Tax Rules\nIssues Related to Federal Government's Financial Market Assistance\nIssues Related to Housing Legislation\nIssues Related to Taxation of Employee Benefits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33213, "prefix": null, "prefix_display": null, "first_name": "WESTON", "nickname": null, "middle_name": null, "last_name": "COULAM", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41072, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "STEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 54, "name": "Federal Deposit Insurance Corporation (FDIC)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US	31813	DC	DC	US	US		0	0	1301		normalized_name_dc_fallback	0.8

Links from other tables

5 rows from filing_uuid in lobbying_activities
4 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs