← All analytics projects
07
Project 07 · Public-health operations & DuckDB

Healthcare Access & Readiness

Turn official NHM quarterly MIS reports into transparent state-level access, staffing, mapping, outcome, and data-quality review signals.

HealthcareDuckDBPublic data36 states & UTs
States & UTs36
Sub-centres183,562
PHCs26,309
CHCs6,388
District hospitals784
Reported 24x723,187
National overview

Separate access signals from source limitations

Reported facility footprint

Sub-centres183,562
PHCs26,309
CHCs6,388
District hospitals784
Reported 24x7 facilities23,187

NHM focus groups

Focus groupStates/UTsPHCsMedian IMRMedian priority
High Focus - NE81,62414.041.5
High Focus - Non-NE1012,61429.061.5
Non-High Focus - Large1111,95617.055.7
Non-High Focus - Small & UT71159.031.9
Median urban mapping100.0%
Median PHC readiness42.6%
Median reported IMR14.5
Higher-priority states/UTs10
State explorer

Filter states while keeping completeness visible

Review filters

Selected states/UTs36
Selected PHCs26,309
Selected CHCs6,388
Median readiness42.6%
Median completeness93.8%

36 selected states/UTs

Current filter: 36 states/UTs
State / UTFocusPHCs24x7 / 100KPHC readinessIMRPriorityBandComplete
Uttar PradeshHigh Focus - Non-NE3,0320.865.4%37.090.0Higher review priority100%
OdishaHigh Focus - Non-NE1,2901.156.0%30.084.3Higher review priority100%
DelhiNon-High Focus - Small & UT00.00—14.081.0Higher review priority75%
JharkhandHigh Focus - Non-NE3321.260.0%29.074.3Higher review priority100%
West BengalNon-High Focus - Large9060.6625.3%17.072.8Higher review priority100%
BiharHigh Focus - Non-NE1,6901.176.2%23.070.4Higher review priority100%
GujaratNon-High Focus - Large1,5231.6710.3%20.069.9Higher review priority100%
TelanganaNon-High Focus - Large881—37.0%18.067.0Higher review priority75%
ChandigarhNon-High Focus - Small & UT50.280.0%7.062.0Higher review priority63%
UttarakhandHigh Focus - Non-NE5751.687.0%20.061.7Higher review priority100%
Madhya PradeshHigh Focus - Non-NE1,4422.3514.1%37.061.4Moderate review priority100%
KeralaNon-High Focus - Large8491.4333.3%5.059.1Moderate review priority100%
ChhattisgarhHigh Focus - Non-NE7651.9145.5%37.058.6Moderate review priority100%
AssamHigh Focus - NE9571.7142.6%32.058.0Moderate review priority100%
HaryanaNon-High Focus - Large4071.6254.5%26.056.0Moderate review priority100%
KarnatakaNon-High Focus - Large2,1602.1823.2%14.055.7Moderate review priority100%
PunjabNon-High Focus - Large4211.4749.9%17.053.0Moderate review priority100%
Himachal PradeshHigh Focus - Non-NE5811.630.0%14.052.3Moderate review priority88%
Jammu & KashmirHigh Focus - Non-NE3732.1717.7%14.048.9Moderate review priority88%
Arunachal PradeshHigh Focus - NE1438.4562.2%20.048.8Moderate review priority63%
MeghalayaHigh Focus - NE1153.1064.3%34.047.8Moderate review priority63%
MaharashtraNon-High Focus - Large2,1982.8813.6%14.047.4Moderate review priority100%
Andhra PradeshNon-High Focus - Large1,1441.63100.0%19.043.2Lower review priority100%
RajasthanHigh Focus - Non-NE2,5345.1559.3%29.042.4Lower review priority100%
GoaNon-High Focus - Large241.4454.2%6.041.9Lower review priority63%
NagalandHigh Focus - NE1314.249.2%10.041.7Lower review priority63%
Tamil NaduNon-High Focus - Large1,4433.4091.1%12.041.4Lower review priority100%
MizoramHigh Focus - NE576.4784.2%13.041.3Lower review priority63%
Andaman & Nicobar IslandsNon-High Focus - Small & UT226.8290.9%9.036.7Lower review priority63%
TripuraHigh Focus - NE1113.5484.7%15.033.0Lower review priority63%
LadakhNon-High Focus - Small & UT32—37.5%4.031.9Lower review priority38%
Dadra & Nagar Haveli and Daman & DiuNon-High Focus - Small & UT132.3984.6%9.030.5Lower review priority63%
PuducherryNon-High Focus - Small & UT392.1687.2%7.030.2Lower review priority63%
ManipurHigh Focus - NE863.1270.9%3.024.1Lower review priority63%
SikkimHigh Focus - NE244.26100.0%6.017.9Lower review priority63%
LakshadweepNon-High Focus - Small & UT415.63100.0%9.011.2Lower review priority50%
Access and outcomes

Describe the relationship without claiming causation

24x7 access density and infant mortality

00208411724x7 facilities per 100K Census-2011 populationUttar Pradesh: 0.86 facilities per 100K; IMR 37.0Odisha: 1.15 facilities per 100K; IMR 30.0Delhi: 0.00 facilities per 100K; IMR 14.0Jharkhand: 1.26 facilities per 100K; IMR 29.0West Bengal: 0.66 facilities per 100K; IMR 17.0Bihar: 1.17 facilities per 100K; IMR 23.0Gujarat: 1.67 facilities per 100K; IMR 20.0Chandigarh: 0.28 facilities per 100K; IMR 7.0Uttarakhand: 1.68 facilities per 100K; IMR 20.0Madhya Pradesh: 2.35 facilities per 100K; IMR 37.0Kerala: 1.43 facilities per 100K; IMR 5.0Chhattisgarh: 1.91 facilities per 100K; IMR 37.0Assam: 1.71 facilities per 100K; IMR 32.0Haryana: 1.62 facilities per 100K; IMR 26.0Karnataka: 2.18 facilities per 100K; IMR 14.0Punjab: 1.47 facilities per 100K; IMR 17.0Himachal Pradesh: 1.63 facilities per 100K; IMR 14.0Jammu & Kashmir: 2.17 facilities per 100K; IMR 14.0Arunachal Pradesh: 8.45 facilities per 100K; IMR 20.0Meghalaya: 3.10 facilities per 100K; IMR 34.0Maharashtra: 2.88 facilities per 100K; IMR 14.0Andhra Pradesh: 1.63 facilities per 100K; IMR 19.0Rajasthan: 5.15 facilities per 100K; IMR 29.0Goa: 1.44 facilities per 100K; IMR 6.0Nagaland: 4.24 facilities per 100K; IMR 10.0Tamil Nadu: 3.40 facilities per 100K; IMR 12.0Mizoram: 6.47 facilities per 100K; IMR 13.0Andaman & Nicobar Islands: 6.82 facilities per 100K; IMR 9.0Tripura: 3.54 facilities per 100K; IMR 15.0Dadra & Nagar Haveli and Daman & Diu: 2.39 facilities per 100K; IMR 9.0Puducherry: 2.16 facilities per 100K; IMR 7.0Manipur: 3.12 facilities per 100K; IMR 3.0Sikkim: 4.26 facilities per 100K; IMR 6.0Lakshadweep: 15.63 facilities per 100K; IMR 9.0
Circle size represents reported population · hover for state values
States in scatter34
Correlation-0.21
Rate exclusions2
Review planner

Composite, completeness-aware priority screen

Top 20 review-priority scores

Arunachal Pradesh48.8
Moderate review priority · 63% complete
Jammu & Kashmir48.9
Moderate review priority · 88% complete
Himachal Pradesh52.3
Moderate review priority · 88% complete
Punjab53.0
Moderate review priority · 100% complete
Karnataka55.7
Moderate review priority · 100% complete
Haryana56.0
Moderate review priority · 100% complete
Assam58.0
Moderate review priority · 100% complete
Chhattisgarh58.6
Moderate review priority · 100% complete
Kerala59.1
Moderate review priority · 100% complete
Madhya Pradesh61.4
Moderate review priority · 100% complete
Uttarakhand61.7
Higher review priority · 100% complete
Chandigarh62.0
Higher review priority · 63% complete
Telangana67.0
Higher review priority · 75% complete
Gujarat69.9
Higher review priority · 100% complete
Bihar70.4
Higher review priority · 100% complete
West Bengal72.8
Higher review priority · 100% complete
Jharkhand74.3
Higher review priority · 100% complete
Delhi81.0
Higher review priority · 75% complete
Odisha84.3
Higher review priority · 100% complete
Uttar Pradesh90.0
Higher review priority · 100% complete
Methods and Power BI

Quality checks, metric definitions, and companion files

Data quality

CheckIssuesStatus
parsed_state_ut_rows36PASS
duplicate_state_rows0PASS
missing_or_zero_population_rows2REVIEW
missing_imr_rows0PASS
missing_mmr_rows17REVIEW
urban_mapping_above_100_pct_rows1REVIEW
phc_staffing_above_100_pct_rows0PASS
insufficient_priority_component_rows0PASS
negative_facility_count_cells0PASS

Metric dictionary

MetricUnitBoundary
urban_facility_mapping_pct%Higher is better; values over 100 are retained source inconsistencies
phc_three_nurse_readiness_pct%Staffing readiness proxy, not full workforce adequacy
facilities_24x7_per_100krateUses dated population and does not measure beds, staffing quality, or travel time
district_hospitals_per_millionrateFacility count does not measure beds, quality, or travel time
imrper 1,000 live birthsMissing for some states/UTs
review_priority_score0-100Screening index only; requires at least three components
Healthcare access Power BI companion layout target
Power BI companion layout target; not a hosted report.