home / lobbying / lobbying_filings_raw

lobbying_filings_raw: b74feffc-1d68-4d0d-a342-e19931f4cb9e

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
b74feffc-1d68-4d0d-a342-e19931f4cb9e Q1 400721169 CRACKER BARREL OLD COUNTRY STORE, INC. 194734 CRACKER BARREL OLD COUNTRY STORE, INC. 2012 first_quarter 2012-04-16T17:46:51.473000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/b74feffc-1d68-4d0d-a342-e19931f4cb9e/", "filing_uuid": "b74feffc-1d68-4d0d-a342-e19931f4cb9e", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/b74feffc-1d68-4d0d-a342-e19931f4cb9e/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "40000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Michael Zylstra, VP GC & Corp Sec", "dt_posted": "2012-04-16T17:46:51.473000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "305 Hartmann Drive", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Lebanon", "registrant_state": "TN", "registrant_zip": "37087", "registrant": {"id": 400721169, "url": "https://lda.senate.gov/api/v1/registrants/400721169/", "house_registrant_id": null, "name": "CRACKER BARREL OLD COUNTRY STORE, INC.", "description": "Restaurant and retail operations", "address_1": "305 Hartmann Drive", "address_2": null, "address_3": null, "address_4": null, "city": "Lebanon", "state": "TN", "state_display": "Tennessee", "zip": "37087", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MICHAEL ZYLSTRA", "contact_telephone": "+1 615-235-4006", "dt_updated": "2022-04-06T16:07:49.423279-04:00"}, "client": {"id": 194734, "url": "https://lda.senate.gov/api/v1/clients/194734/", "client_id": 12, "name": "CRACKER BARREL OLD COUNTRY STORE, INC.", "general_description": "Restaurant and retail sales", "client_government_entity": false, "client_self_select": true, "state": "TN", "state_display": "Tennessee", "country": "US", "country_display": "United States of America", "ppb_state": "TN", "ppb_state_display": "Tennessee", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-03-09"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "SMART Act, H.R. 1063 and S. 1718, proposals to reform Medicare Secondary Payer (MSP) processes.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Federal legislation relating to reform, revision and/or repeal of Renewable Fuel Standard, including H.R. 3097 and H.R. 3098.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 1265 and S. 687, 15-year depreciation for restaurant construction. H.R. 2082, permanent extension of Work Opportunity Tax Credit. Potential consideration of depreciation and WOTC within legislation to extend expiring tax credits. Monitoring of congressional proposals to reform corporate tax rates.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "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": "H.R. 1744 and H.R. 2206, portions relating to repeal of employer mandate and auto-enrollment mandates in PPACA.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Monitor congressional and agency activities relating to NLRB union election provisions, procedures and regulations; S.J.Res. 36 and H.J.Res. 103; H.R. 1876 and S. 2252=provisions relating to employer mandates on paid leave, minimum wage and tip credit.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "H.R. 3798, the Egg Products Inspection Act Amendments--provisions relating to regulation/use of alternative housing for hens.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ROD", "general_issue_code_display": "Roads/Highway", "description": "Portman and LaTourette amendments to federal highway program extension legislation--provisions relating to allowing state commercialization of interstate highway rest areas.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "Monitor rulemaking pursuant to Sec. 4205 of PPACA = nutritional disclosure for chain restaurants", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Federal Reserve rulemaking and potential legislation on debit card interchange fees per Sec. 1075 of PL 111-203", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53491, "prefix": null, "prefix_display": null, "first_name": "PATRICK", "nickname": null, "middle_name": null, "last_name": "SHEEHY", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Rep. Tom Petri", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 9 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 3.196ms