home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 2022bcee-efaa-4e0a-9682-b3b46212f7ea

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
2022bcee-efaa-4e0a-9682-b3b46212f7ea Q1 16987 GRIZZLE COMPANY 122643 RESCARE 2014 first_quarter 2014-04-11T11:58:58.173000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/2022bcee-efaa-4e0a-9682-b3b46212f7ea/", "filing_uuid": "2022bcee-efaa-4e0a-9682-b3b46212f7ea", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2014, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/2022bcee-efaa-4e0a-9682-b3b46212f7ea/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Richard A. Cantor, President", "dt_posted": "2014-04-11T11:58:58.173000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1701 Pennsylvania Ave NW", "registrant_address_2": "Suite 300", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 16987, "url": "https://lda.senate.gov/api/v1/registrants/16987/", "house_registrant_id": 31352, "name": "GRIZZLE COMPANY", "description": "Government affairs consulting firm.", "address_1": "1701 Pennsylvania Ave NW", "address_2": "Suite 300", "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": "RICHARD A. CANTOR", "contact_telephone": "+1 202-234-2101", "dt_updated": "2022-04-06T16:06:09.638515-04:00"}, "client": {"id": 122643, "url": "https://lda.senate.gov/api/v1/clients/122643/", "client_id": 191, "name": "RESCARE", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "KY", "state_display": "Kentucky", "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": "2007-08-07"}, "lobbying_activities": [{"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Support funding for the Workforce Investment Act (Job Corps). \nSupport for Workforce Investment Boards and 1-Stop Centers. \nSupport maintaining companionship exemption for home care services under the Fair Labor Standards Act. \nOppose Rule of Two for Job Corp procurements. Oppose DOL reduction of Job Corps training slots.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 10442, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHARLES", "nickname": null, "middle_name": "L", "last_name": "GRIZZLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 19678, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "A", "last_name": "CANTOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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