home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cbb7bb2a-e797-45bb-93f4-25caa728848f

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
cbb7bb2a-e797-45bb-93f4-25caa728848f Q2 46723 NORTH CAROLINA BAPTIST HOSPITAL 154301 NORTH CAROLINA BAPTIST HOSPITAL 2011 second_quarter 2011-07-08T14:52:15.917000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cbb7bb2a-e797-45bb-93f4-25caa728848f/", "filing_uuid": "cbb7bb2a-e797-45bb-93f4-25caa728848f", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2011, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cbb7bb2a-e797-45bb-93f4-25caa728848f/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "40000.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Greg Bray--Controller", "dt_posted": "2011-07-08T14:52:15.917000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "MEDICAL CENTER BOULEVARD", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WINSTON-SALEM", "registrant_state": "NC", "registrant_zip": "27157", "registrant": {"id": 46723, "url": "https://lda.senate.gov/api/v1/registrants/46723/", "house_registrant_id": 34385, "name": "NORTH CAROLINA BAPTIST HOSPITAL", "description": null, "address_1": "MEDICAL CENTER BOULEVARD", "address_2": null, "address_3": null, "address_4": null, "city": "WINSTON-SALEM", "state": "NC", "state_display": "North Carolina", "zip": "27157", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JOANNE C. RUHLAND", "contact_telephone": "", "dt_updated": "2022-05-31T15:11:18.905777-04:00"}, "client": {"id": 154301, "url": "https://lda.senate.gov/api/v1/clients/154301/", "client_id": 12, "name": "NORTH CAROLINA BAPTIST HOSPITAL", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "NC", "state_display": "North Carolina", "country": "US", "country_display": "United States of America", "ppb_state": "NC", "ppb_state_display": "North Carolina", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-24"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "IRS Notice re: Tax exempt provisions in PPACA\n1099 Requirements", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21644, "prefix": null, "prefix_display": null, "first_name": "JOANNE", "nickname": null, "middle_name": "C", "last_name": "RUHLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Labor-HHS-FY2012", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21644, "prefix": null, "prefix_display": null, "first_name": "JOANNE", "nickname": null, "middle_name": "C", "last_name": "RUHLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "National Trauma Center Stabalization Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21644, "prefix": null, "prefix_display": null, "first_name": "JOANNE", "nickname": null, "middle_name": "C", "last_name": "RUHLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "FAA Authorization bill amedments", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21644, "prefix": null, "prefix_display": null, "first_name": "JOANNE", "nickname": null, "middle_name": "C", "last_name": "RUHLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Budget Negotiations FY2012\nGraduate Medical Education \nDebt Ceiling/Deficit Reduction Talks-GME and Medicaid provider tax program Medicaid 340(b) Program\nMedicaid Graduate Medical Education (GME) funding\nMedicare Recovery Audit Committee\nPatient Protection and Affordable Care Act\nHealth Care and Education Reconciliation Act of 2010 (H.R.4872)\n(Accountable Care Organizations)\n(Transitions in Care Funding)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 21644, "prefix": null, "prefix_display": null, "first_name": "JOANNE", "nickname": null, "middle_name": "C", "last_name": "RUHLAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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