home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e3f7bada-41a4-467e-b559-e1d8feecf822

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
e3f7bada-41a4-467e-b559-e1d8feecf822 Q2 323876 BLUE CROSS AND BLUE SHIELD OF KANSAS, INC. 187394 BLUE CROSS AND BLUE SHIELD OF KANSAS INC 2008 second_quarter 2008-07-16T17:26:42-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e3f7bada-41a4-467e-b559-e1d8feecf822/", "filing_uuid": "e3f7bada-41a4-467e-b559-e1d8feecf822", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2008, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e3f7bada-41a4-467e-b559-e1d8feecf822/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Sunee N. Mickle, Director, Government Relations", "dt_posted": "2008-07-16T17:26:42-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1133 S.W. TOPEKA BLVD", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "TOPEKA", "registrant_state": "KS", "registrant_zip": "66629", "registrant": {"id": 323876, "url": "https://lda.senate.gov/api/v1/registrants/323876/", "house_registrant_id": 39735, "name": "BLUE CROSS AND BLUE SHIELD OF KANSAS, INC.", "description": null, "address_1": "1133 S.W. TOPEKA BLVD", "address_2": null, "address_3": null, "address_4": null, "city": "TOPEKA", "state": "KS", "state_display": "Kansas", "zip": "66629", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "SUNEE N. MICKLE", "contact_telephone": "+1 785-291-7194", "dt_updated": "2026-01-22T16:55:26.214176-05:00"}, "client": {"id": 187394, "url": "https://lda.senate.gov/api/v1/clients/187394/", "client_id": 12, "name": "BLUE CROSS AND BLUE SHIELD OF KANSAS INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "KS", "state_display": "Kansas", "country": "US", "country_display": "United States of America", "ppb_state": "KS", "ppb_state_display": "Kansas", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "1899-12-30"}, "lobbying_activities": [{"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "E-prescribing; Comparative Effectiveness Research: HR3162 \"Children's Health and Medicare Protection Act of 2007\" Section 904 only; HR2184 \"Enhanced Health Care Value for All Act\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45016, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUNEE", "nickname": null, "middle_name": "N", "last_name": "MICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Medicare Advantage Funding: HR 6331 \"Medicare Improvements for Patients and Providers Act of 2008\"; S3101 \"Medicare Improvements for Patients and Providers Act of 2008\"; S3118 \"Preserving Access to Medicare Act of 2008\"; and Comparative Effectiveness Funding: HR3162 \"Children's Health and Medicare Protection Act of 2007\" Section 904 only; HR2184 \"Enhanced Health Care Value for All Act\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45016, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUNEE", "nickname": null, "middle_name": "N", "last_name": "MICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "HR3920 \"Trade and Globalization Act of 2007\" and S1848 \"TAA Health Coverage Improvement Act of 2007\" - parts pertaining to the Health Coverage Tax Credit", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45016, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUNEE", "nickname": null, "middle_name": "N", "last_name": "MICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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": "See attached addendum for General Lobbying Issue Area: HCR - Healthcare Antitrust and Health Insurance Reform: HR971 and S2161 \"Community Pharmacy Fairness Act of 2007\", S618 \"Insurance Industry Competition Act of 2007\"\n\nHealth Information Technology Standards; Electronic Health Records; ICD10 Implementation: HR1368 \"Personalized Health Information Act of 2007\"; S1783 and S1693 \"Wired for Health Care Quality Act\"; HR3800 \"Promoting Health Information Technology Act\"; HR2406 \"Healthcare Information Technology Enterprise Integration Act\", HR6357 \"Pro(Tech)t Act of 2008\"\n\nHealthcare Reform; Insurance Market Reform; Employer Based Healthcare System; Small Group Market/Small Business Healthcare; Uninsured: S1019 \"Health Care Choice Act of 2007\"; S334 and HR3163 \"Healthy Americans Act\"; S2795 \"Small Business Health Options Program Act of 2008\"\n\nGenetic Non-discrimination: HR493 and S358 \"Genetic Information Nondiscrimination Act of 2007\n\nMental Health Parity: HR1424 \"Paul Wellstone Mental Health and Addiction Equity Act of 2007\" and S558 \"Mental Health Parity Act of 2007\"\n\nTAA; HR3801 and S1848 \"TAA Health Coverage Improvement Act of 2007\"\n\nComparative Effectiveness Research: HR3162 \"Children's Health and Medicare Protection Act of 2007\" Section 904 only; HR2184 \"Enhanced Health Care Value for All Act\"\n\nHealth Savings Accounts/Medical Savings Accounts; SCHIP\n\nS2041 \"False Claim Act Correction of 2007\" as it pertains to the payment of healthcare claims", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45016, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUNEE", "nickname": null, "middle_name": "N", "last_name": "MICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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": "Medicare; Medicare Part D; Comparative Effectiveness Research: HR3162 \"Children's Health and Medicare Protection Act of 2007\" Section 904 only; HR2184 \"Enhanced Health Care Value for All Act\"; Medicare Electronic Health Records; Pay for Performance; Medicare Advantage: HR 6331 \"Medicare Improvements for Patients and Providers Act of 2008\"; S3101 \"Medicare Improvements for Patients and Providers Act of 2008\"; S3118 \"Preserving Access to Medicare Act of 2008\"", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 45016, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUNEE", "nickname": null, "middle_name": "N", "last_name": "MICKLE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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 10.566ms