home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 671bfc05-f4ce-48dc-9b3c-12aceb2624d2

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
671bfc05-f4ce-48dc-9b3c-12aceb2624d2 Q1 307273 SISTERS OF CHARITY OF ST. AUGUSTINE HEALTH SYSTEM 182448 SISTERS OF CHARITY OF ST AUGUSTINE HEALTH SYSTEM 2014 first_quarter 2014-04-17T10:22:17.720000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/671bfc05-f4ce-48dc-9b3c-12aceb2624d2/", "filing_uuid": "671bfc05-f4ce-48dc-9b3c-12aceb2624d2", "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/671bfc05-f4ce-48dc-9b3c-12aceb2624d2/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "12625.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Kyle Miller, Manager, Government Affairs and Public Policy", "dt_posted": "2014-04-17T10:22:17.720000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2475 East 22nd Street", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Cleveland", "registrant_state": "OH", "registrant_zip": "44115", "registrant": {"id": 307273, "url": "https://lda.senate.gov/api/v1/registrants/307273/", "house_registrant_id": 38359, "name": "SISTERS OF CHARITY OF ST. AUGUSTINE HEALTH SYSTEM", "description": null, "address_1": "2475 EAST 22ND STREET", "address_2": null, "address_3": null, "address_4": null, "city": "CLEVELAND", "state": "OH", "state_display": "Ohio", "zip": "44115", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "THOMAS F. TURNER", "contact_telephone": "+1 330-489-1421", "dt_updated": "2022-04-06T16:07:11.587421-04:00"}, "client": {"id": 182448, "url": "https://lda.senate.gov/api/v1/clients/182448/", "client_id": 12, "name": "SISTERS OF CHARITY OF ST AUGUSTINE HEALTH SYSTEM", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "OH", "state_display": "Ohio", "country": "US", "country_display": "United States of America", "ppb_state": "OH", "ppb_state_display": "Ohio", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2006-04-15"}, "lobbying_activities": [{"general_issue_code": "HOU", "general_issue_code_display": "Housing", "description": "Advocated for programs that will lessen youth homelessness. Supported Housing First model.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57647, "prefix": "mr", "prefix_display": "MR.", "first_name": "KYLE", "nickname": null, "middle_name": "D.", "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": "Manager, Government Affairs and Public Policy", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Advocated for thoughtful deficit reduction policy grounded in broad, shared responsibility.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57647, "prefix": "mr", "prefix_display": "MR.", "first_name": "KYLE", "nickname": null, "middle_name": "D.", "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": "Manager, Government Affairs and Public Policy", "new": false}, {"lobbyist": {"id": 38397, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "FORBES", "last_name": "TURNER", "suffix": null, "suffix_display": null}, "covered_position": "VP, Mercy Medical Center", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Advocated for good implementation of the Affordable Care Act, including increasing coverage and access for many while protecting the dignity of life. Urged lawmakers to work with the hospital and provider communities to ensure strong reimbursement for providers and sound health care delivery system changes. Educated about community benefit of nonprofit hospitals.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57647, "prefix": "mr", "prefix_display": "MR.", "first_name": "KYLE", "nickname": null, "middle_name": "D.", "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": "Manager, Government Affairs and Public Policy", "new": false}, {"lobbyist": {"id": 38397, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "FORBES", "last_name": "TURNER", "suffix": null, "suffix_display": null}, "covered_position": "VP, Mercy Medical Center", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Advocated for sound infrastructure funding and provided updates on the E. 22nd Street project in Cleveland.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57647, "prefix": "mr", "prefix_display": "MR.", "first_name": "KYLE", "nickname": null, "middle_name": "D.", "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": "Manager, Government Affairs and Public Policy", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Advocated for better provider reimbursements for Medicare and Medicaid. Educated about the negative impacts (to providers and beneficiaries) of cuts to Medicare and Medicaid. Stressed the importance of Graduate Medical Education. Educated about the importance of Disproportionate Share Hospital (DSH) funding for hospitals serving those in need and advocated for a delay of Disproportionate Share Hospital funding cuts.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57647, "prefix": "mr", "prefix_display": "MR.", "first_name": "KYLE", "nickname": null, "middle_name": "D.", "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": "Manager, Government Affairs and Public Policy", "new": false}, {"lobbyist": {"id": 38397, "prefix": "mr", "prefix_display": "MR.", "first_name": "THOMAS", "nickname": null, "middle_name": "FORBES", "last_name": "TURNER", "suffix": null, "suffix_display": null}, "covered_position": "VP, Mercy Medical Center", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "REL", "general_issue_code_display": "Religion", "description": "Discussed the importance of faith-based nonprofits to the common good. Educated about the work of grantmaking foundations and the philanthropic sector, including efforts to ameliorate poverty through health and human services, housing and education programs. Advocated for responsible fatherhood.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57647, "prefix": "mr", "prefix_display": "MR.", "first_name": "KYLE", "nickname": null, "middle_name": "D.", "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": "Manager, Government Affairs and Public Policy", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Advocated for funding for the Cleveland Central Promise Neighborhood Initiative.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57647, "prefix": "mr", "prefix_display": "MR.", "first_name": "KYLE", "nickname": null, "middle_name": "D.", "last_name": "MILLER", "suffix": null, "suffix_display": null}, "covered_position": "Manager, Government Affairs and Public Policy", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} OH US 38359 OH OH US US   0 0           12625.0

Links from other tables

  • 7 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.327ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API