lobbying_filings_raw: 3233f3d6-c93e-4ac1-bec3-e7de5b02f8f7

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
3233f3d6-c93e-4ac1-bec3-e7de5b02f8f7	Q4	400887598	SANKOFA CONSULTING STRATEGIES	196003	U.S. TRAVEL ASSOCIATION	2014	fourth_quarter	2015-01-09T12:30:56.437000-05:00	45000.0	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/3233f3d6-c93e-4ac1-bec3-e7de5b02f8f7/", "filing_uuid": "3233f3d6-c93e-4ac1-bec3-e7de5b02f8f7", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2014, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3233f3d6-c93e-4ac1-bec3-e7de5b02f8f7/print/", "filing_document_content_type": "text/html", "income": "45000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Steven Schwadron", "dt_posted": "2015-01-09T12:30:56.437000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1720 Eye Street, NW", "registrant_address_2": "4th Floor", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 400887598, "url": "https://lda.senate.gov/api/v1/registrants/400887598/", "house_registrant_id": null, "name": "SANKOFA CONSULTING STRATEGIES", "description": "Lobbying and communications firm", "address_1": "1720 Eye Street, NW", "address_2": "4th Floor", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STEVEN SCHWADRON", "contact_telephone": "+1 202-306-0808", "dt_updated": "2022-04-06T16:06:43.380474-04:00"}, "client": {"id": 196003, "url": "https://lda.senate.gov/api/v1/clients/196003/", "client_id": 24, "name": "U.S. TRAVEL ASSOCIATION", "general_description": "To promote travel to and within the United States", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2012-02-08"}, "lobbying_activities": [{"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Advocate for safe and efficient travel to and within the United States, with focus on visa processing, Visa Waiver Program, homeland security, travel documentation, federal employee travel, infrastructure modernization and implementation of National Tourism Strategy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56511, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "C", "last_name": "SCHWADRON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, former Rep.Bill Delahunt", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Advocate for safe and efficient travel to and within the United States, with focus on visa processing, Visa Waiver Program, homeland security, travel documentation, federal employee travel, infrastructure modernization and implementation of National Tourism Strategy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56511, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "C", "last_name": "SCHWADRON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, former Rep. Bill Delahunt", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Advocate for safe and efficient travel to and within the United States, with focus on visa processing, Visa Waiver Program, homeland security, travel documentation, federal employee travel, infrastructure modernization and implementation of National Tourism Strategy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56511, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "C", "last_name": "SCHWADRON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, former Rep. Bill Delahunt", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "Advocate for safe and efficient travel to and within the United States, with focus on visa processing, Visa Waiver Program, homeland security, travel documentation, federal employee travel, infrastructure modernization and implementation of National Tourism Strategy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56511, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "C", "last_name": "SCHWADRON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, former Rep. Bill Delahunt", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Advocate for safe and efficient travel to and within the United States, with focus on visa processing, Visa Waiver Program, homeland security, travel documentation, federal employee travel, infrastructure modernization and implementation of National Tourism Strategy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56511, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "C", "last_name": "SCHWADRON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, former Rep. Bill Delahunt", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "TOU", "general_issue_code_display": "Travel/Tourism", "description": "Advocate for safe and efficient travel to and within the United States, with focus on visa processing, Visa Waiver Program, homeland security, travel documentation, federal employee travel, infrastructure modernization and implementation of National Tourism Strategy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56511, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "C", "last_name": "SCHWADRON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, former Rep. Bill Delahunt", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Advocate for safe and efficient travel to and within the United States, with focus on visa processing, Visa Waiver Program, homeland security, travel documentation, federal employee travel, infrastructure modernization and implementation of National Tourism Strategy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56511, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "C", "last_name": "SCHWADRON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, former Rep. Bill Delahunt", "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US		DC		US	US	To promote travel to and within the United States	0	0	993148		normalized_name_state	0.9

Links from other tables

7 rows from filing_uuid in lobbying_activities
1 row from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs