lobbying_filings_raw: ecf1699f-cac4-4313-a7ec-e7dfbec1902f

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
ecf1699f-cac4-4313-a7ec-e7dfbec1902f	Q2	401104337	SAM ACTION, INC.	201546	SAM ACTION, INC.	2022	second_quarter	2022-07-14T09:38:25-04:00	10000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/ecf1699f-cac4-4313-a7ec-e7dfbec1902f/", "filing_uuid": "ecf1699f-cac4-4313-a7ec-e7dfbec1902f", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2022, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ecf1699f-cac4-4313-a7ec-e7dfbec1902f/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Luke Niforatos", "dt_posted": "2022-07-14T09:38:25-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "107 S. West Street", "registrant_address_2": "Suite 757", "registrant_different_address": true, "registrant_city": "Alexandria", "registrant_state": "VA", "registrant_zip": "22314", "registrant": {"id": 401104337, "url": "https://lda.senate.gov/api/v1/registrants/401104337/", "house_registrant_id": null, "name": "SAM ACTION, INC.", "description": "issue advocacy", "address_1": "107 S. West Street", "address_2": "Suite 757", "address_3": null, "address_4": null, "city": "Alexandria", "state": "VA", "state_display": "Virginia", "zip": "22314", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LUKE NIFORATOS", "contact_telephone": "+1 303-335-7584", "dt_updated": "2025-07-21T09:55:18.780121-04:00"}, "client": {"id": 201546, "url": "https://lda.senate.gov/api/v1/clients/201546/", "client_id": 12, "name": "SAM ACTION, INC.", "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": "2017-01-26"}, "lobbying_activities": [{"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "H.R.2093/S. 1028, STATES Act to legalize marijuana, appropriations amendments related to marijuana legalization, criminal justice reform related to marijuana, H.R.3884, MORE Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71899, "prefix": null, "prefix_display": null, "first_name": "LUKE", "nickname": null, "middle_name": null, "last_name": "ALBEE", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Senator Leahy; Chief of Staff, Mark Warner; Staff, Governor Dukakis", "new": false}], "government_entities": [{"id": 155, "name": "Drug Enforcement Administration (DEA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 19, "name": "Office of Natl Drug Control Policy (NDCP)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "H.R. 3797, Medical Marijuana Research Act, S. 2032, Cannabidiol and Marijuana Research Expansion Act, to lower the barriers of researching marijuana.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": true}, {"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 19, "name": "Office of Natl Drug Control Policy (NDCP)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "H.R.1595/S.1200 SAFE Banking Act on marijuana banking and investment.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71899, "prefix": null, "prefix_display": null, "first_name": "LUKE", "nickname": null, "middle_name": null, "last_name": "ALBEE", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Senator Leahy; Chief of Staff, Mark Warner; Staff, Governor Dukakis", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ALC", "general_issue_code_display": "Alcohol and Drug Abuse", "description": "The effects of marijuana on children, the nexus between marijuana and psychosis.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71899, "prefix": null, "prefix_display": null, "first_name": "LUKE", "nickname": null, "middle_name": null, "last_name": "ALBEE", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Senator Leahy; Chief of Staff, Mark Warner; Staff, Governor Dukakis", "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Safety issues surrounding marijuana, marketing of high potency marijuana products to children.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71899, "prefix": null, "prefix_display": null, "first_name": "LUKE", "nickname": null, "middle_name": null, "last_name": "ALBEE", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Senator Leahy; Chief of Staff, Mark Warner; Staff, Governor Dukakis", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Federal role in marijuana laws, the legalization of marijuana, criminal justice reform.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71899, "prefix": null, "prefix_display": null, "first_name": "LUKE", "nickname": null, "middle_name": null, "last_name": "ALBEE", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Senator Leahy; Chief of Staff, Mark Warner; Staff, Governor Dukakis", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "The effects of marijuana on children, pregnant women and developing brains, the nexus between high potency marijuana and mental illness.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71899, "prefix": null, "prefix_display": null, "first_name": "LUKE", "nickname": null, "middle_name": null, "last_name": "ALBEE", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Senator Leahy; Chief of Staff, Mark Warner; Staff, Governor Dukakis", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "Preventing federally illegal enterprises from gaining a special carve out to access federally subsidized loans or grants.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71212, "prefix": null, "prefix_display": null, "first_name": "FREDERICK", "nickname": "TRIPP", "middle_name": null, "last_name": "BAIRD", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": true}, {"lobbyist": {"id": 71213, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "BAIRD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	VA	US		VA	VA	US	US		0	0	913643		normalized_name_state	0.9

Links from other tables

8 rows from filing_uuid in lobbying_activities
3 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs