Viewing a saved revision (read-only)
tMKhb5RoNTMJ7BhmAP7vq
Created from react-d3-starter template
Hospital General Information — Dataset Documentation
Dataset Overview
- File:
data/Hospital_General_Information.csv - Size: 1,450,767 bytes
- Rows: 1,000
- Columns: 38
- Subject matter (tentative): This appears to be a general-information extract about U.S. hospitals (likely derived from the CMS "Hospital General Information" dataset). Each row represents one hospital facility. It includes identity and location fields (name, address, city, state, ZIP, county, telephone), facility attributes (type, ownership, emergency services, birthing-friendly designation), an overall star rating, and per-measure-group counts for Mortality (MORT), Safety, Readmission (READM), Patient Experience (Pt Exp), and Timely & Effective Care (TE).
The CSV header is the first record and spans multiple physical lines (cells are quoted and contain embedded newlines/annotations). A real CSV parser must be used; there is no preamble before the header.
Column Descriptions
Data types use Tamara Munzner's classification (Nominal / Ordinal / Quantitative / Temporal / Geographic coordinates / Geographic identifiers). All interpretations are tentative unless noted; missing counts come from the computed dataset profile.
| Column | Apparent meaning (tentative) | Munzner type | Missing / notes |
|---|---|---|---|
| Facility ID | Unique numeric facility identifier (e.g., CMS provider number) | Geographic identifier / Quantitative ID | 0 missing; cardinality 1,000 (unique) |
| Facility Name | Hospital name | Nominal | 0 missing; 995 unique (a few duplicate names) |
| Address | Street address | Geographic identifier | 0 missing |
| City/Town | City or town | Geographic identifier | 0 missing; 643 unique |
| State | Two-letter state abbreviation | Geographic identifier / Nominal | 0 missing; 10 unique in this subset |
| ZIP Code | 5-digit postal code | Geographic identifier | 0 missing |
| County/Parish | County or parish name | Geographic identifier | 0 missing; 274 unique |
| Telephone Number | Contact phone number | Nominal | 0 missing; formatted like "(334) 793-8701" |
| Hospital Type | Facility category, e.g. "Acute Care Hospitals" | Nominal | 0 missing; 7 categories |
| Hospital Ownership | Ownership class, e.g. "Government – Hospital District or Authority", "Proprietary", "Voluntary non-profit – Private" | Nominal | 0 missing; 12 categories |
| Emergency Services | Whether emergency services are offered ("Yes"/"No") | Nominal (binary) | 0 missing |
| Meets criteria for birthing friendly designation | Birthing-friendly designation flag ("Y" / blank) | Nominal | 528 missing; only one observed value ("Y") in the profile |
| Hospital overall rating | Overall star rating, 1–5 | Ordinal | 0 missing in profile; values include "Not Available" (parsed as missing); cardinality 6 (1–5 plus a non-numeric marker); mean ≈ 3.09 |
| Hospital overall rating footnote | Footnote code explaining a missing/unavailable rating (e.g., 5, 29) | Nominal (code) | 666 missing; cardinality 8 |
| MORT Group Measure Count | Number of measures in the Mortality group (8) | Quantitative | 0 missing |
| Count of Facility MORT Measures | Measures actually reported for this facility (1–8) | Quantitative | 0 missing |
| Count of MORT Measures Better | Facilities' measures performing better than national rate | Quantitative | 0 missing; 0–7 |
| Count of MORT Measures No Different | Measures not different from national rate | Quantitative | 0 missing; 1–8 |
| Count of MORT Measures Worse | Measures performing worse than national rate | Quantitative | 0 missing; 0–4 |
| MORT Group Footnote | Footnote code for the Mortality group | Nominal (code) | 783 missing |
| Safety Group Measure Count | Number of measures in the Safety group (8) | Quantitative | 0 missing |
| Count of Facility Safety Measures | Safety measures reported (1–8) | Quantitative (stored as string) | 0 missing; may contain "Not Available" |
| Count of Safety Measures Better | Safety measures better than national rate | Quantitative (string) | 0 missing; 0–5 |
| Count of Safety Measures No Different | Safety measures no different | Quantitative (string) | 0 missing; 0–8 |
| Count of Safety Measures Worse | Safety measures worse | Quantitative (string) | 0 missing; 0–2 |
| Safety Group Footnote | Footnote code for Safety group | Nominal (code) | 696 missing |
| READM Group Measure Count | Number of measures in the Readmission group (11) | Quantitative | 0 missing |
| Count of Facility READM Measures | Readmission measures reported (1–11) | Quantitative | 0 missing |
| Count of READM Measures Better | Readmission measures better | Quantitative | 0 missing; 0–5 |
| Count of READM Measures No Different | Readmission measures no different | Quantitative | 0 missing; 0–11 |
| Count of READM Measures Worse | Readmission measures worse | Quantitative (string) | 0 missing; 0–7; may contain "Not Available" |
| READM Group Footnote | Footnote code for Readmission group | Nominal (code) | 801 missing |
| Pt Exp Group Measure Count | Number of measures in the Patient Experience group (15) | Quantitative | 0 missing |
| Count of Facility Pt Exp Measures | Patient-experience measures reported (5–15) | Quantitative | 0 missing |
| Pt Exp Group Footnote | Footnote code for Patient Experience group | Nominal (code) | 711 missing |
| TE Group Measure Count | Number of measures in the Timely & Effective Care group (10) | Quantitative | 0 missing |
| Count of Facility TE Measures | TE measures reported (1–10) | Quantitative | 0 missing |
| TE Group Footnote | Footnote code for TE group | Nominal (code) | 829 missing |
Parsing assumptions:
- Numeric columns may contain the literal string
Not Availableor blank cells; these are treated as missing, not zero. - Several count columns are typed as strings in the parsed profile
(e.g.,
Count of Facility Safety Measures) because of such markers; they are converted with+valueand validated before use. Hospital overall ratingvalues outside 1–5 (e.g.,Not Available) are treated as missing.- No temporal or latitude/longitude columns are present.
Visualization
Type: Horizontal-grouped stacked bar chart (one bar per state, stacked by overall star rating 1–5).
Why this design:
Hospital overall ratingis the dataset's headline ordinal field; a stacked bar shows both each state's total hospital count and its rating mix in one view.Statehas low cardinality (10) in this dataset, making a per-state bar layout readable without scrolling.- The red→green (1-star→5-star) color ramp matches the ordinal, evaluative nature of star ratings.
Encodings:
- x:
State(nominal, band scale) - y: count of hospitals (linear scale)
- color:
Hospital overall rating1–5 (ordinal scale,schemeRdYlGn) - Facet rows of each stack segment: one
<g>per rating
Interactions:
- Native tooltips (
<title>) on each stacked segment: state, rating, and count. - Fully responsive: chart re-renders on container resize via
ResizeObserver.
Not-shown fields (ownership, measure counts, etc.) are intentionally omitted to keep this starter minimal; they remain available for subsequent prototypes.
Files
index.html— page shell and import map (React + D3 via CDN)index.jsx— mounts<App />App.jsx— loads/data/Hospital_General_Information.csv, parses ratings, tracks container sizeviz.js— aggregation, scales, axes, legend, titlerenderChart.js— draws the stacked bars with tooltipsuseContainerDimensions.js— container-size hookstyles.css— page stylesREADME.md— this documentation