1Strategy reports & analyses
The written deliverables. Markdown (.md) files open as text in the browser or in any editor.
| File | What it is |
|---|---|
| Strategic_Analysis_Consulting_Report.md | The full ~20,000-word strategic engagement: PESTEL, Five Forces, leakage, value chain & financials, payer/covered-lives, resident-vs-commuter read, regulatory navigation, SWOT/TOWS, growth horizons, the service-line roadmap, recommendations, and the adversarial partner-review appendix. |
| service_line_market_entry.md | Acute service-line market-entry analysis & phased reclaim-and-grow roadmap (23 lines scored, H1/H2/H3, do-not-build list). |
| service_line_scorecard.csv | The 23 candidate service lines × 8 weighted criteria + weighted score + tier + priority. |
| rch_market_leakage_analysis.md | HCAI patient-origin / market-share & leakage analysis (methodology, core vs. broad market, ED vs. inpatient). |
| commuter_resident_analysis.md | Resident-vs-commuter market read (LEHD LODES + ACS): who works vs. lives in the service area, and the residence haircut for the covered-lives model. |
| independent_provider_analysis.md | Independent provider network & manageable-lives analysis (CIN aggregation targets, SB→Banning corridor). |
| california_regulatory_requirements.md | California regulatory brief: CPOM, 1206(l) foundation, Knox-Keene ladder, OHCA/AB1415, SB351, network adequacy. |
2Market, leakage & demographics data
| File | What it is |
|---|---|
| rch_market_share_leakage.csv | 17 service-area ZIPs × RCH share + leakage + 9 competitors, inpatient and ED (HCAI CY2024). |
| rch_patient_origin.csv | RCH's draw by origin ZIP (585 ZIPs): inpatient, ED, ambulatory-surgery volume + % of RCH. |
| hcai_utilization_comparison.csv | RCH vs. 9 competitors: beds, discharges, ALOS, occupancy, ED visits, surgeries, births, trauma designation. |
| service_area_demographics.csv · .geojson | ZIP-level population, age, income, insurance, race/ethnicity + CDC PLACES disease burden (the map overlays). |
| commute_flows_by_city.csv | 11-city commute/jobs-housing table (LEHD LODES8 2022 + ACS 2024). |
3Competitors & provider network
| File | What it is |
|---|---|
| competitors.csv · .json · .md | Every hospital, ASC, urgent care, clinic, imaging & physician group in the service area (geocoded) — the competitor map's source data. |
| independent_groups.csv · .json | Independent provider groups (CIN aggregation candidates), with specialties, provider counts, and panel-life estimates. |
4RCH facility, quality & financials
| File | What it is |
|---|---|
| rch_hospital_data.md | Full RCH fact brief: facility, quality (CMS/HCAHPS/mortality/infections), financials (Form 990 FY2011–2024), utilization, with sources. |
| rch_quality_scores.csv | RCH quality metrics (CMS Care Compare) in tabular form. |
| rch_financials_utilization.csv | 14-year financial trajectory + HCAI utilization series. |
| redlands_community_hospital_benefits.md | RCH community-benefit summary. |
5Employers, health plans & source documents
| File | What it is |
|---|---|
| redlands_top_employers.md | City of Redlands top employers (ACFR FY2025). |
| redlands_business_licenses.csv | All 7,264 active Redlands business licenses, with employee counts + Form 5500 health-plan match columns (≈1 MB). |
| health_plan_carriers_by_employer.csv · roster_health_plan_matches.csv · redlands_5500_health_plans.csv | DOL Form 5500 / Schedule A health-plan filings cross-matched to local employers (carriers, participants). |
| health_plans_form5500.md | Notes on the Form 5500 health-plan methodology. |
| redlands_acfr_2024-25.pdf | City of Redlands Annual Comprehensive Financial Report FY2024-25 (public source document, ≈3.7 MB). |
About these files. This is a personal strategy side-project built entirely from public/official data; modeled figures (covered lives, take-up, residence haircuts, recapture sizing) are labeled planning estimates throughout — not actuarial, legal, clinical, or investment advice. Markdown and CSV files open as plain text in the browser; the PDF opens inline. Every figure traces to its cited public source within the report files.