home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 89fcf09b-e82f-499e-a6a4-8fc3f4fb6d1b

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
89fcf09b-e82f-499e-a6a4-8fc3f4fb6d1b Q2 30906 SQUIRE PATTON BOGGS 137758 NATIONAL CANNABIS ROUNDTABLE 2020 second_quarter 2020-07-10T09:47:56.033000-04:00 80000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/89fcf09b-e82f-499e-a6a4-8fc3f4fb6d1b/", "filing_uuid": "89fcf09b-e82f-499e-a6a4-8fc3f4fb6d1b", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2020, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/89fcf09b-e82f-499e-a6a4-8fc3f4fb6d1b/print/", "filing_document_content_type": "text/html", "income": "80000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Glenn Willard, Of Counsel", "dt_posted": "2020-07-10T09:47:56.033000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2550 M STREET, NW", "registrant_address_2": null, "registrant_different_address": null, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20037", "registrant": {"id": 30906, "url": "https://lda.senate.gov/api/v1/registrants/30906/", "house_registrant_id": 31917, "name": "SQUIRE PATTON BOGGS", "description": "Law Firm", "address_1": "2550 M STREET, NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20037", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "GLENN WILLARD", "contact_telephone": "+1 202-457-6000", "dt_updated": "2026-01-05T11:28:49.243604-05:00"}, "client": {"id": 137758, "url": "https://lda.senate.gov/api/v1/clients/137758/", "client_id": 1010317, "name": "NATIONAL CANNABIS ROUNDTABLE", "general_description": "Trade Association", "client_government_entity": false, "client_self_select": null, "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": "2019-03-06"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Correcting flaws in the US tax codethat serve as barriers to legal commerce in the cannabis industry.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67278, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CRISCUOLO", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66011, "prefix": null, "prefix_display": null, "first_name": "AUSTIN", "nickname": null, "middle_name": null, "last_name": "HARRISON", "suffix": null, "suffix_display": null}, "covered_position": "March 2009: Intern for Cong. Gregg Harper; May-Aug. 2013: Intern for Sen. Thad Cochran; January-May 2015: June-August 2015: U.S. Department of State, intern, U.S. Embassy, Zagreb, Croatia.", "new": false}, {"lobbyist": {"id": 43512, "prefix": "mr", "prefix_display": "MR.", "first_name": "W", "nickname": null, "middle_name": "CAFFEY", "last_name": "NORMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61872, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SCHNITTGER", "suffix": null, "suffix_display": null}, "covered_position": "Dep. Chief of Staff, Speaker Boehner, 2006-2015; Press Secr., Rep. John Boehner 1994-2001; Communications Director, House Committee on Education and the Workforce 2001-2005", "new": false}, {"lobbyist": {"id": 35859, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "L", "last_name": "TURNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "Reforming federal law and policy governing medical research, financial transactions, and tax deductions applicable to cannabis and allowing states and territories to set and enforce their own laws governing cannabis use, including H.R. 1595 and S. 1200, the Secure and Fair Enforcement (SAFE) Banking Act of 2019.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67278, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CRISCUOLO", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66011, "prefix": null, "prefix_display": null, "first_name": "AUSTIN", "nickname": null, "middle_name": null, "last_name": "HARRISON", "suffix": null, "suffix_display": null}, "covered_position": "March 2009: Intern for Cong. Gregg Harper; May-Aug. 2013: Intern for Sen. Thad Cochran; January-May 2015: June-August 2015: U.S. Department of State, intern, U.S. Embassy, Zagreb, Croatia.", "new": false}, {"lobbyist": {"id": 43512, "prefix": "mr", "prefix_display": "MR.", "first_name": "W", "nickname": null, "middle_name": "CAFFEY", "last_name": "NORMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61872, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SCHNITTGER", "suffix": null, "suffix_display": null}, "covered_position": "Dep. Chief of Staff, Speaker Boehner, 2006-2015; Press Secr., Rep. John Boehner 1994-2001; Communications Director, House Committee on Education and the Workforce 2001-2005", "new": false}, {"lobbyist": {"id": 35859, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "L", "last_name": "TURNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "Reforming federal law and policy governing medical research, financial transactions, and tax deductions applicable to cannabis and allowing states and territories to set and enforce their own laws governing cannabis use, including H.R. 2093 and S. 1028, the Strengthening the Tenth Amendment Through Entrusting States (STATES) Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67278, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CRISCUOLO", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66011, "prefix": null, "prefix_display": null, "first_name": "AUSTIN", "nickname": null, "middle_name": null, "last_name": "HARRISON", "suffix": null, "suffix_display": null}, "covered_position": "March 2009: Intern for Cong. Gregg Harper; May-Aug. 2013: Intern for Sen. Thad Cochran; January-May 2015: June-August 2015: U.S. Department of State, intern, U.S. Embassy, Zagreb, Croatia.", "new": false}, {"lobbyist": {"id": 43512, "prefix": "mr", "prefix_display": "MR.", "first_name": "W", "nickname": null, "middle_name": "CAFFEY", "last_name": "NORMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61872, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SCHNITTGER", "suffix": null, "suffix_display": null}, "covered_position": "Dep. Chief of Staff, Speaker Boehner, 2006-2015; Press Secr., Rep. John Boehner 1994-2001; Communications Director, House Committee on Education and the Workforce 2001-2005", "new": false}, {"lobbyist": {"id": 35859, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "L", "last_name": "TURNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "Reforming federal law and policy governing medical research, financial transactions, and tax deductions applicable to cannabis and allowing states and territories to set and enforce their own laws governing cannabis use.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67278, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CRISCUOLO", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66011, "prefix": null, "prefix_display": null, "first_name": "AUSTIN", "nickname": null, "middle_name": null, "last_name": "HARRISON", "suffix": null, "suffix_display": null}, "covered_position": "March 2009: Intern for Cong. Gregg Harper; May-Aug. 2013: Intern for Sen. Thad Cochran; January-May 2015: June-August 2015: U.S. Department of State, intern, U.S. Embassy, Zagreb, Croatia.", "new": false}, {"lobbyist": {"id": 43512, "prefix": "mr", "prefix_display": "MR.", "first_name": "W", "nickname": null, "middle_name": "CAFFEY", "last_name": "NORMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61872, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "SCHNITTGER", "suffix": null, "suffix_display": null}, "covered_position": "Dep. Chief of Staff, Speaker Boehner, 2006-2015; Press Secr., Rep. John Boehner 1994-2001; Communications Director, House Committee on Education and the Workforce 2001-2005", "new": false}, {"lobbyist": {"id": 35859, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "L", "last_name": "TURNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 198, "name": "Natl Economic Council (NEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 5 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 17.457ms