Course resources

Data dictionaries

Column definitions for every teaching dataset. All data are fully synthetic.

Patient dimension

One row per synthetic patient.

DS1_patient_dim.csv

ColumnTypeDefinitionExample
patient_id text Unique synthetic identifier for the patient; joins to patient_id in the event tables. RBP000001
birth_date date Date of birth of the synthetic patient. 1935-07-05
sex_at_birth text Recorded sex at birth (Female or Male). Female
gender_identity_group text Grouped self-reported gender identity. Man
race_ethnicity_group text Grouped race and ethnicity category. Black non-Hispanic
preferred_language text Preferred language for care communication. Spanish
interpreter_needed_flag boolean 1 means the patient needs an interpreter. 1
zip_area_id text ZIP-area group; joins to zip_area_id in the geography dimension. ZA003
payer_primary_id text Primary payer; joins to payer_id in the payer dimension. PAY04
pcp_provider_id text Primary care provider; joins to provider_id in the provider dimension. RBPV0019
chronic_condition_count integer Number of chronic conditions on the patient record. 2
sdoh_risk_score number Composite social-determinants-of-health risk score; higher values indicate greater risk. 45.2
portal_active_flag boolean 1 means the patient has an active patient-portal account. 1
active_status text Whether the patient is currently active in the roster (Active or Inactive). Active
death_date date Date of death; blank when the patient is alive.

Provider dimension

One row per provider or clinician.

DS1_provider_dim.csv

ColumnTypeDefinitionExample
provider_id text Unique provider identifier; joins to provider_id in the event tables. RBPV0001
provider_type text Provider credential type (MD, NP, PA, and similar). NP
specialty_group text Grouped clinical specialty. Primary care
facility_id text Primary practice site; joins to facility_id in the facility dimension. PC05
years_in_practice integer Years the provider has been in practice. 16
fte_status text Employment status (Full-time, Part-time, Per diem). Per diem
panel_size number Number of patients empaneled to the provider. 1717.0
language_1 text First language spoken by the provider. English
language_2 text Second language spoken by the provider; blank when none.
active_flag boolean 1 means the provider is currently active. 1
provider_gender text Grouped provider gender. Man
provider_age_band text Age band of the provider. 55-64

Facility dimension

One row per facility or site.

DS1_facility_dim.csv

ColumnTypeDefinitionExample
facility_id text Unique facility identifier; joins to facility_id in the event tables. HOSP01
facility_name text Name of the facility. Riverbend Medical Center
facility_type text Type of site (Hospital, ED, Urgent care, clinic). Hospital
region text Operational region. Central
county_fips text 5-digit FIPS county code; joins to county_fips in geography tables. 36055
zip_area_id text ZIP-area group; joins to zip_area_id in the geography dimension. ZA010
urban_rural_group text Urbanicity grouping (Urban core, Suburban, Small town, Rural). Urban core
bed_count integer Number of staffed beds; 0 for non-inpatient sites. 320
teaching_site_flag boolean 1 means the site is a teaching site. 1
service_line_focus text Primary service line of the site. Acute care hospital
opening_year integer Year the site opened. 1998
active_flag boolean 1 means the site is currently active. 1

Payer dimension

One row per payer or plan group.

DS1_payer_dim.csv

ColumnTypeDefinitionExample
payer_id text Unique payer identifier; joins to payer_id in the event tables. PAY01
payer_group text Payer category (Commercial, Medicare, Medicaid). Commercial
plan_name text Name of the health plan. Blue Valley PPO
product_type text Plan product type (PPO, HMO, FFS). PPO
prior_auth_intensity text How aggressively the plan requires prior authorization (Low, Medium, High). Medium
avg_payment_days_band text Banded average days from claim submission to payment. 21-35 days
network_rules_group text Grouped description of the plan network rules. Standard
market_share_band text Banded market share (Low, Medium, High). High
pharmacy_benefit_flag boolean 1 means the plan includes a pharmacy benefit. 1
active_flag boolean 1 means the plan is currently active. 1

Geography dimension

One row per ZIP-area group.

DS1_geography_dim.csv

ColumnTypeDefinitionExample
zip_area_id text Unique ZIP-area identifier; joins to zip_area_id in patient and event tables. ZA001
zip_code_prefix text 5-digit ZIP code prefix for the area. 14601
county_fips text 5-digit FIPS county code; joins to county_fips in county tables. 36055
county_name text County name. Monroe
state_abbr text Two-letter state abbreviation. NY
region text Operational region. Central
urban_rural_group text Urbanicity grouping (Urban core, Suburban, Small town, Rural). Urban core
deprivation_quintile integer Area deprivation quintile from 1 (least deprived) to 5 (most deprived). 2
median_household_income number Median household income for the area, in US dollars. 94356
uninsured_rate_pct number Share of area residents without health insurance, as a percentage. 10.0
transit_access_group text Grouped transit access (Low, High). Low
broadband_access_pct number Share of area households with broadband access, as a percentage. 83.3

Calendar dimension

One row per calendar date.

DS1_calendar_dim.csv

ColumnTypeDefinitionExample
calendar_date date Calendar date; joins to date fields in the event tables. 2024-01-01
year integer Calendar year. 2024
quarter integer Calendar quarter (1-4). 1
month_num integer Month number (1-12). 1
month_name text Month name. January
week_of_year integer Week number within the year. 1
weekday_num integer Day-of-week number (1 = Monday through 7 = Sunday). 1
weekday_name text Day-of-week name. Monday
weekend_flag boolean 1 means the date falls on a weekend. 0
holiday_flag boolean 1 means the date is a holiday. 1
flu_season_flag boolean 1 means the date falls in flu season. 1

Appointments

One row per scheduled visit (ambulatory scheduling).

DS2_appointments_clean.csv

ColumnTypeDefinitionExample
appointment_id text Unique appointment identifier; joins to encounter_source_id in claims and source_encounter_id in surveys. APT000126
patient_id text Patient; joins to patient_id in the patient dimension. RBP011885
provider_id text Scheduled provider; joins to provider_id in the provider dimension. RBPV0067
facility_id text Scheduled site; joins to facility_id in the facility dimension. SP03
appointment_created_datetime datetime Date and time the appointment was booked (YYYY-MM-DD HH:MM). 2023-12-10 03:29
appointment_datetime datetime Scheduled date and time of the visit (YYYY-MM-DD HH:MM). 2024-01-01 08:00
appointment_date date Scheduled date of the visit. 2024-01-01
appointment_month text Year-month of the scheduled visit, for grouping (YYYY-MM). 2024-01
appointment_weekday text Day of week of the scheduled visit. Monday
appointment_hour integer Hour of the scheduled visit on a 24-hour clock. 8
lead_days integer Days between booking and the appointment (lead time). 22
visit_type text Type of visit (Acute, Behavioral Health, Urgent Care, and similar). Behavioral Health
specialty_group text Grouped specialty of the visit. Behavioral health
payer_id text Payer; joins to payer_id in the payer dimension. PAY06
reminder_channel text Channel used for the appointment reminder (Phone, SMS, and similar). Phone
reminder_sent_flag boolean 1 means a reminder was sent. 1
reminder_days_before number Days before the visit that the reminder was sent. 2.0
same_day_flag boolean 1 means the visit was booked the same day. 0
telehealth_flag boolean 1 means the visit was a telehealth visit. 0
copay_usd number Patient copay for the visit, in US dollars. 46.85
distance_to_clinic_miles number Distance from the patient to the clinic, in miles. 25.2
transportation_barrier_flag boolean 1 means a transportation barrier was recorded. 0
interpreter_needed_flag boolean 1 means an interpreter was needed. 0
weather_severity_group text Grouped weather severity on the visit day. Normal
zip_area_id text Patient ZIP-area group; joins to the geography dimension. ZA029
patient_age integer Patient age in years at the visit. 57
sdoh_risk_score number Composite social-determinants-of-health risk score; higher values indicate greater risk. 76.6
portal_active_flag boolean 1 means the patient had an active portal account. 1
deprivation_quintile integer Area deprivation quintile from 1 (least deprived) to 5 (most deprived). 4
prior_completed_visits_12m integer Completed visits in the prior 12 months. 4
prior_no_show_count_12m integer No-shows in the prior 12 months. 0
prior_cancel_count_12m integer Cancellations in the prior 12 months. 0
check_in_datetime datetime Date and time the patient checked in (YYYY-MM-DD HH:MM). 2024-01-01 07:50
seen_datetime datetime Date and time the patient was seen by the provider (YYYY-MM-DD HH:MM). 2024-01-01 08:12
cancel_datetime datetime Date and time the appointment was canceled; blank when not canceled.
attendance_outcome text Final visit outcome (Completed, No-show, Canceled, and similar). Completed
no_show_flag boolean 1 means the patient did not show for the visit. 0
arrival_late_minutes number Minutes late for the appointment; negative values mean the patient arrived early. -10.0
wait_to_room_minutes number Minutes from check-in to being roomed. 22.0
total_visit_minutes number Total visit duration in minutes. 26.0

Appointments (teaching sample)

A 12-row sample of the appointments file for the Chapter 1 and 3 Try It exercises.

DS2_appointments_sample.csv

ColumnTypeDefinitionExample
Visit ID text Appointment identifier; matches appointment_id in the full appointments file. APT000126
Clinic text Clinic/facility code of the visit. SP03
Visit type text Type of visit. Behavioral Health
Lead days integer Days between booking and the visit (lead time). 22
Reminder text Channel used for the appointment reminder. Phone
Outcome text Final visit outcome. Completed
No-show flag boolean 1 means the patient did not show for the visit. 0

ED throughput

One row per emergency department visit.

DS3_ed_throughput_clean.csv

ColumnTypeDefinitionExample
encounter_id text Unique ED encounter identifier. ED000001
patient_id text Patient; joins to patient_id in the patient dimension. RBP006296
facility_id text ED site; joins to facility_id in the facility dimension. ED01
arrival_datetime datetime Date and time of arrival (YYYY-MM-DD HH:MM:SS). 2025-07-16 10:55:00
arrival_date date Date of arrival. 2025-07-16
arrival_hour integer Hour of arrival on a 24-hour clock. 10
arrival_day_of_week text Day of week of arrival. Wednesday
arrival_mode text How the patient arrived (Walk-in, EMS, and similar). Walk-in
chief_complaint_group text Grouped chief complaint. Behavioral
triage_acuity integer Triage acuity score on a 1-5 scale, where 1 is the most urgent. 5
triage_datetime datetime Date and time triage was completed (YYYY-MM-DD HH:MM:SS). 2025-07-16 11:06:00
roomed_datetime datetime Date and time the patient was placed in a room (YYYY-MM-DD HH:MM:SS). 2025-07-16 11:38:00
provider_first_contact_datetime datetime Date and time of first provider contact (YYYY-MM-DD HH:MM:SS). 2025-07-16 11:56:00
disposition_order_datetime datetime Date and time the disposition decision was ordered (YYYY-MM-DD HH:MM:SS). 2025-07-16 13:37:00
departure_datetime datetime Date and time the patient left the ED (YYYY-MM-DD HH:MM:SS). 2025-07-16 14:08:00
lab_order_flag boolean 1 means labs were ordered. 0
lab_count integer Number of lab orders placed. 0
lab_result_datetime datetime Date and time lab results returned; blank when no labs were ordered.
imaging_flag boolean 1 means imaging was ordered. 1
imaging_modality_group text Grouped imaging modality; blank when no imaging was ordered. Ultrasound
imaging_result_datetime datetime Date and time imaging results returned; blank when no imaging was ordered. 2025-07-16 12:47:00
consult_flag boolean 1 means a specialty consult was requested. 0
boarding_flag boolean 1 means the patient boarded while waiting for an inpatient bed. 0
observation_flag boolean 1 means the patient was placed in observation status. 0
disposition text Final disposition (Home, Admit, Transfer, and similar). Home
admit_service_line text Service line for admitted patients; blank when the patient was not admitted.
pain_score_initial number Initial pain score on a 0-10 scale. 4.0
age_at_visit integer Patient age in years at the visit. 52
payer_id text Payer; joins to payer_id in the payer dimension. PAY01
language_group text Grouped preferred language; Not recorded when unknown. English
interpreter_needed_flag boolean 1 means an interpreter was needed. 0
weekend_flag boolean 1 means the visit occurred on a weekend. 0
door_to_triage_minutes number Minutes from arrival to triage. 11
triage_to_room_minutes number Minutes from triage to rooming. 32
door_to_provider_minutes number Minutes from arrival to first provider contact. 61
door_to_disposition_minutes number Minutes from arrival to the disposition decision. 162
length_of_stay_minutes number Total ED length of stay in minutes. 193
left_without_being_seen_flag boolean 1 means the patient left before being seen by a provider. 0

Inpatient discharges

One row per inpatient discharge.

DS4_inpatient_clean.csv

ColumnTypeDefinitionExample
discharge_id text Unique discharge identifier. IPD001565
patient_id text Patient; joins to patient_id in the patient dimension. RBP010878
facility_id text Hospital; joins to facility_id in the facility dimension. HOSP01
admission_datetime datetime Date and time of admission (YYYY-MM-DD HH:MM). 2024-01-01 00:15
discharge_datetime datetime Date and time of discharge (YYYY-MM-DD HH:MM). 2024-01-05 15:15
length_of_stay_days number Length of stay in days. 4.6
admit_source text Where the patient was admitted from (Direct, ED, Transfer). Direct
admission_type text Admission type (Elective, Urgent, Emergent). Urgent
service_line text Clinical service line of the stay. Medicine
principal_icd10cm_code text Principal ICD-10-CM diagnosis code. I11.0
principal_diagnosis_group text Grouped principal diagnosis. Heart failure
case_group text Case grouping (Medical or Surgical). Medical
comorbidity_count integer Number of comorbidities coded for the stay. 6
risk_score number Clinical risk score; higher values indicate higher risk. 46.2
ed_admit_flag boolean 1 means the patient was admitted through the emergency department. 0
surgery_flag boolean 1 means a surgical procedure was performed during the stay. 0
icu_flag boolean 1 means the patient spent time in the ICU. 0
payer_id text Payer; joins to payer_id in the payer dimension. PAY03
discharge_disposition text Where the patient went after discharge (Home, SNF, and similar). Home
followup_within_7d_flag boolean 1 means a follow-up visit occurred within 7 days of discharge. 1
home_health_ordered_flag boolean 1 means home health services were ordered at discharge. 0
snf_discharge_flag boolean 1 means the patient was discharged to a skilled nursing facility. 0
total_charges_usd number Total charges for the stay, in US dollars. 8659.58
prior_admits_12m integer Inpatient admissions in the prior 12 months. 1
prior_ed_visits_12m integer ED visits in the prior 12 months. 0
readmission_30d_flag boolean 1 means the patient was readmitted within 30 days. 0
readmission_days integer Days from discharge to readmission; blank when no readmission occurred.
mortality_flag boolean 1 means the patient died during the stay. 0
age_at_admit integer Patient age in years at admission. 71
preferred_language text Preferred language for care communication. English
zip_area_id text Patient ZIP-area group; joins to the geography dimension. ZA020
deprivation_quintile integer Area deprivation quintile from 1 (least deprived) to 5 (most deprived). 4

Claim headers

One row per submitted claim (revenue cycle).

DS5_claim_header_clean.csv

ColumnTypeDefinitionExample
claim_id text Unique claim identifier; joins to claim_id on the claim lines. CLM001052
encounter_source_id text Source visit identifier linking the claim to the appointment. APT028457
patient_id text Patient; joins to patient_id in the patient dimension. RBP002479
facility_id text Rendering site; joins to facility_id in the facility dimension. PC01
provider_id text Rendering provider; joins to provider_id in the provider dimension. RBPV0003
service_date date Date the service was rendered. 2024-01-01
claim_submit_date date Date the claim was submitted to the payer. 2024-01-07
payer_id text Payer; joins to payer_id in the payer dimension. PAY01
service_category text Category of service (Office visit, Urgent care, and similar). Office visit
site_of_service text Site where the service was rendered. Office
claim_type text Claim type (Professional or Institutional). Professional
diagnosis_chapter text ICD chapter grouping of the diagnosis. Factors influencing health status
billed_charge_usd number Amount billed, in US dollars. 176.69
allowed_amount_usd number Payer-allowed amount, in US dollars. 102.48
paid_amount_usd number Amount paid by the payer, in US dollars. 92.49
patient_responsibility_usd number Amount owed by the patient, in US dollars. 9.99
contractual_adjustment_usd number Contractual write-off, in US dollars. 74.21
denial_flag boolean 1 means the claim was denied. 0
denial_reason_group text Grouped denial reason; blank when the claim was not denied.
clean_claim_flag boolean 1 means the claim was submitted without errors (a clean claim). 1
prior_auth_required_flag boolean 1 means prior authorization was required. 0
prior_auth_obtained_flag boolean 1 means prior authorization was obtained; blank when it was not required.
network_status text Network status of the claim (In-network or Out-of-network). In-network
appeal_flag boolean 1 means the claim was appealed. 0
appeal_outcome text Outcome of the appeal; blank when no appeal was filed.
final_status text Final claim status (Paid, Denied, Pending). Paid
days_to_first_submission integer Days from the service date to first submission. 6
days_to_final_payment integer Days from submission to final payment. 26
claim_line_count integer Number of lines on the claim. 1
high_cost_flag boolean 1 means the claim was flagged as high-cost. 0
month_key text Year-month key for grouping (YYYY-MM). 2024-01

Claim lines (optional)

One row per claim line; optional supplement.

DS5_claim_line_optional.csv

ColumnTypeDefinitionExample
claim_line_id text Unique claim line identifier. CLM000001-L1
claim_id text Claim header; joins to claim_id in the claim headers. CLM000001
encounter_source_id text Source visit identifier linking the line to the appointment. APT007988
patient_id text Patient; joins to patient_id in the patient dimension. RBP010825
facility_id text Rendering site; joins to facility_id in the facility dimension. UC02
provider_id text Rendering provider; joins to provider_id in the provider dimension. RBPV0104
service_date date Date the service was rendered. 2024-04-03
payer_id text Payer; joins to payer_id in the payer dimension. PAY03
service_category text Category of service. Urgent care
site_of_service text Site where the service was rendered. Urgent care
claim_type text Claim type (Professional or Institutional). Professional
revenue_or_service_group_code text Grouped revenue or service code for the line. RV020
service_group_description text Description of the service group. Urgent evaluation
units integer Number of service units on the line. 1
line_charge_usd number Billed charge for the line, in US dollars. 9.69
line_allowed_usd number Allowed amount for the line, in US dollars. 4.86
line_paid_usd number Paid amount for the line, in US dollars. 4.18
month_key text Year-month key for grouping (YYYY-MM). 2024-04

Survey responses

One row per patient-experience survey response.

DS6_survey_responses_clean.csv

ColumnTypeDefinitionExample
survey_response_id text Unique survey response identifier. SRV00001
sample_id text Sampling frame identifier for the survey wave. SMP00001
source_encounter_id text Visit identifier linking the survey to the appointment. APT032641
patient_id text Patient; joins to patient_id in the patient dimension. RBP000851
facility_id text Site of the visit; joins to facility_id in the facility dimension. SP06
provider_id text Provider of the visit; joins to provider_id in the provider dimension. RBPV0095
survey_mode_offered text Mode in which the survey was offered (Paper, SMS, Portal). Paper
survey_mode_completed text Mode in which the survey was completed. Paper
survey_language text Language of the completed survey. English
days_after_visit integer Days between the visit and the survey response. 8
timely_appointment_score_1_4 integer Score for getting a timely appointment, on a 1-4 scale. 4
staff_courtesy_score_1_4 integer Score for staff courtesy, on a 1-4 scale. 3
provider_listened_score_1_4 integer Score for the provider listening carefully, on a 1-4 scale. 4
provider_explained_score_1_4 integer Score for the provider explaining things clearly, on a 1-4 scale. 4
care_coordination_score_1_4 number Score for care coordination, on a 1-4 scale. 3.0
office_staff_helpful_score_1_4 integer Score for office staff helpfulness, on a 1-4 scale. 3
wait_time_perception_score_1_4 number Score for perceived wait time, on a 1-4 scale. 4.0
overall_provider_rating_0_10 number Overall provider rating on a 0-10 scale. 10.0
recommend_practice_rating_0_10 number Likelihood to recommend the practice, on a 0-10 scale; blank when not answered. 10.0
portal_results_helpful_score_1_4 number Score for portal results being helpful, on a 1-4 scale. 3.0
confidence_in_care_plan_score_1_4 integer Score for confidence in the care plan, on a 1-4 scale. 3
comment_theme_primary text Primary theme of the free-text comment; blank when no comment was given. Communication
completion_flag boolean 1 means the survey was completed. 1
source_setting text Care setting of the source visit (Ambulatory, and similar). Ambulatory
overall_top_box_flag boolean 1 means the overall provider rating was top-box (9 or 10). 1
recommend_top_box_flag boolean 1 means the recommend rating was top-box (9 or 10). 1
communication_composite_score number Composite of the communication items, on a 1-4 scale. 3.67
access_composite_score number Composite of the access items, on a 1-4 scale. 3.67

Care registry

One row per active registry patient.

DS7_registry_clean.csv

ColumnTypeDefinitionExample
patient_id text Unique synthetic identifier for the patient; joins to patient_id in the event tables. RBP000001
registry_date date Date of the registry snapshot. 2025-12-31
pcp_provider_id text Primary care provider; joins to provider_id in the provider dimension. RBPV0019
facility_id text Primary site; joins to facility_id in the facility dimension. PC05
payer_id text Payer; joins to payer_id in the payer dimension. PAY04
zip_area_id text ZIP-area group; joins to zip_area_id in the geography dimension. ZA003
age integer Age in years at the snapshot date. 90
sex_at_birth text Recorded sex at birth (Female or Male). Female
race_ethnicity_group text Grouped race and ethnicity category. Black non-Hispanic
preferred_language text Preferred language for care communication. Spanish
interpreter_needed_flag boolean 1 means the patient needs an interpreter. 1
deprivation_quintile integer Area deprivation quintile from 1 (least deprived) to 5 (most deprived). 3
food_insecurity_flag boolean 1 means food insecurity was screened positive. 0
transportation_barrier_flag boolean 1 means a transportation barrier was screened positive. 0
housing_instability_flag boolean 1 means housing instability was screened positive. 0
diabetes_flag boolean 1 means diabetes is on the registry record. 1
hypertension_flag boolean 1 means hypertension is on the registry record. 0
copd_flag boolean 1 means COPD is on the registry record. 0
depression_flag boolean 1 means depression is on the registry record. 0
a1c_value number Most recent hemoglobin A1c, as a percentage. 8.1
a1c_test_date date Date of the most recent A1c test. 2025-01-12
bp_systolic_last integer Most recent systolic blood pressure, in mmHg. 125
bp_diastolic_last integer Most recent diastolic blood pressure, in mmHg. 77
bmi number Body mass index. 32.5
smoker_flag boolean 1 means the patient currently smokes. 0
flu_vaccine_current_flag boolean 1 means flu vaccination is current. 0
colorectal_screening_up_to_date_flag boolean 1 means colorectal cancer screening is up to date. 1
mammogram_up_to_date_flag boolean 1 means mammogram screening is up to date; blank when the patient is not in the screening population.
eye_exam_up_to_date_flag boolean 1 means the diabetic eye exam is up to date. 0
medication_adherence_flag boolean 1 means the patient is adherent to prescribed medications. 1
er_visits_12m integer ED visits in the prior 12 months. 2
inpatient_admits_12m integer Inpatient admissions in the prior 12 months. 0
care_gap_count integer Number of open care gaps. 2
risk_tier text Risk tier (Low, Medium, High). Medium
care_manager_assigned_flag boolean 1 means a care manager is assigned. 0

Wellness screening

One row per adult at an annual wellness screening; a small file built for practicing correlation and regression.

DS9_wellness_screening.csv

ColumnTypeDefinitionExample
patient_id text Unique screening participant identifier, assigned in random order. WS001
age number Age in years at the screening (22 to 79). 53
birth_month number Month of birth, 1 (January) to 12 (December). 2
bmi number Body mass index, weight in kilograms divided by height in meters squared. 25.1
waist_cm number Waist circumference in centimeters. 91
steps_per_day number Average daily step count from the participant's activity tracker. 6940
sedentary_hours number Average hours per day spent sitting or lying while awake. 8.9
exercise_hours_week number Self-reported hours of planned exercise per week. 7.2
resting_heart_rate number Resting heart rate in beats per minute. 64
systolic_bp number Systolic blood pressure in millimeters of mercury (mmHg). 119
stress_index number Self-rated stress over the past month, 0 (none) to 10 (extreme). 3.9
fasting_glucose number Fasting blood glucose in milligrams per deciliter (mg/dL). 107
sleep_hours number Average hours of sleep per night. 7.9
fatigue_score number Self-rated daytime fatigue, 0 (none) to 10 (severe). 4.1
height_cm number Height in centimeters. 173
weight_kg number Body weight in kilograms. 75.1
grip_strength_kg number Maximum hand-grip strength in kilograms, measured with a hand dynamometer. 45.0
hdl_cholesterol number High-density lipoprotein (HDL) cholesterol in milligrams per deciliter (mg/dL). 73
screen_time_hours number Average recreational screen time in hours per day. 9.4
vitamin_d number Serum 25-hydroxyvitamin D in nanograms per milliliter (ng/mL). 36

Sampling scenarios

Sampling and study-design vignettes.

DS8_sampling_scenarios.csv

ColumnTypeDefinitionExample
scenario_id text Unique scenario identifier. SCN001
target_population text The population the scenario asks about. Adults with at least one primary care visit in the last year
sampling_frame text The list actually sampled from. EHR registry roster
sampling_method text Sampling method used (Simple random, Stratified, Cluster). Simple random
weighting_needed_flag boolean 1 means survey weights are needed for valid population estimates. 0
bias_risk text The main bias risk in the scenario. Nonresponse bias
recommended_summary text Suggested student task for summarizing the scenario. Describe the likely target population and who may be missing.
study_type_hint text Hint about the study type. observational
best_chart text Recommended chart for the scenario. stacked bar chart
likely_unit_of_analysis text The likely unit of analysis (patient, household, encounter). household
key_missing_information text Key information missing from the scenario. measurement timing
teaching_focus text The teaching point of the vignette. unit of analysis
difficulty_level text Difficulty level of the vignette. introductory

Studies master

Study summaries for evidence literacy.

DS8_studies_master.csv

ColumnTypeDefinitionExample
study_id text Unique study identifier. ST001
topic text Topic of the study. Primary care no-shows
study_design text Study design (cohort, trial, QI, and similar). cohort
population text Study population. Ambulatory adults with primary care appointments
setting text Setting where the study was conducted. multiclinic health system
data_source_type text Type of data source (EHR, experiment, survey). EHR
sample_n integer Sample size (number of participants or records). 1600
exposure_or_intervention text Exposure or intervention studied. SMS reminder program
comparator text Comparison group. No reminder
outcome text Primary outcome measured. No-show rate
effect_measure text Effect measure reported (RR for risk ratio, difference, and similar). RR
main_result text Main result as reported. 0.82 (95% CI 0.76-0.89)
ci_or_p_value text Confidence interval or p-value; Not reported when absent. Not reported
key_limitation text Key limitation of the study. Residual confounding due to clinic workflow differences
evidence_strength_tier text Tiered evidence strength (Low, Moderate, High). Moderate
source_type text Publication source type (Journal, Report). Journal

PLACES county (wide)

CDC PLACES-style county estimates, wide form.

PH1_places_county_wide.csv

ColumnTypeDefinitionExample
county_fips text 5-digit FIPS county code; joins to county tables. 01029
county_name text County name. Cleburne
state_abbr text Two-letter state abbreviation. AL
region text Census-style region. South
urban_rural_group text Urbanicity grouping (Urban core, Suburban, Small town, Rural). Urban core
adult_population_band text Banded adult population size of the county. 250k+
obesity_pct number Modeled share of adults with obesity, as a percentage. 33.6
diagnosed_diabetes_pct number Modeled share of adults with diagnosed diabetes, as a percentage. 17.2
high_blood_pressure_pct number Modeled share of adults with high blood pressure, as a percentage. 36.5
current_smoking_pct number Modeled share of adults who currently smoke, as a percentage. 16.6
binge_drinking_pct number Modeled share of adults reporting binge drinking, as a percentage. 15.6
physical_inactivity_pct number Modeled share of adults reporting no physical activity, as a percentage. 26.8
routine_checkup_pct number Modeled share of adults with a routine checkup in the past year, as a percentage. 72.6
mammography_pct number Modeled share of eligible women with a recent mammogram, as a percentage. 68.2
colorectal_screening_pct number Modeled share of eligible adults up to date on colorectal screening, as a percentage. 69.5
uninsured_pct number Modeled share of adults without health insurance, as a percentage. 14.3
poor_mental_health_pct number Modeled share of adults reporting poor mental health, as a percentage. 19.0
poor_physical_health_pct number Modeled share of adults reporting poor physical health, as a percentage. 17.4
release_year integer PLACES release year for the estimates. 2025

PLACES county (long)

CDC PLACES-style county estimates, long form.

PH1_places_county_long.csv

ColumnTypeDefinitionExample
county_fips text 5-digit FIPS county code; joins to county tables. 01029
county_name text County name. Cleburne
state_abbr text Two-letter state abbreviation. AL
region text Census-style region. South
urban_rural_group text Urbanicity grouping (Urban core, Suburban, Small town, Rural). Urban core
measure_id text Measure identifier; joins to measure_id in the measure lookup. obesity_pct
measure_label text Human-readable measure label. Obesity among adults
estimate_pct number Modeled estimate for the measure, as a percentage. 33.6
low_ci number Lower bound of the confidence interval, as a percentage. 32.7
high_ci number Upper bound of the confidence interval, as a percentage. 34.5
release_year integer PLACES release year for the estimates. 2025

PLACES measure lookup

Measure lookup for the PLACES companion.

PH1_places_measure_lookup.csv

ColumnTypeDefinitionExample
measure_id text Unique measure identifier; joins to measure_id in the long-form county file. obesity_pct
measure_label text Human-readable measure label. Obesity among adults
unit text Unit of the measure. Percent
polarity text Whether higher or lower values are desirable. Lower is better
suggested_chart text Suggested chart type for the measure. Choropleth or bar
numerator_concept text What the numerator counts. Adults meeting the measure definition
denominator_concept text What the denominator counts. Eligible adult population
teaching_note text Teaching suggestion for using the measure. Use for chronic disease burden comparison

BRFSS teaching extract

BRFSS-style weighted adult survey sample.

PH2_brfss2022_teaching_extract.csv

ColumnTypeDefinitionExample
respondent_id text Unique respondent identifier. BRF22000001
state_fips text 2-digit state FIPS code. 53
state_abbr text Two-letter state abbreviation. WA
interview_month integer Month of the interview (1-12). 9
sex text Respondent sex. Male
age_group text Age group band. 18-24
race_ethnicity_group text Grouped race and ethnicity category. White non-Hispanic
education_group text Grouped educational attainment. Some college
income_group text Grouped household income band. 25k-49k
general_health text Self-rated general health. Very good
bmi_category text BMI category (Underweight, Normal, Overweight, Obesity). Normal
current_smoker_flag boolean 1 means the respondent currently smokes. 0
physical_activity_flag boolean 1 means the respondent reported any physical activity. 1
diabetes_flag boolean 1 means the respondent reported diabetes. 0
high_bp_flag boolean 1 means the respondent reported high blood pressure. 1
insured_flag boolean 1 means the respondent has health insurance. 1
usual_source_of_care_flag boolean 1 means the respondent has a usual source of care. 1
poor_mental_health_days integer Days of poor mental health in the past 30 days. 8
poor_physical_health_days integer Days of poor physical health in the past 30 days. 0
flu_vaccine_flag boolean 1 means the respondent received a flu vaccine. 0
final_weight number Final survey weight for population estimates. 1792.95
stratum integer Sampling stratum identifier. 5320
psu integer Primary sampling unit identifier. 53403
source_variable_map text Pipe-delimited map from teaching columns to source BRFSS variable names. _STATE|SEXVAR|X_AGE_G|X_RACE_G|EDUCA|INCOME3|GENHLTH|BMI5CAT|SMOKE100|EXERANY2|DIABETE4|BPHIGH6|HLTHPLN1|PERSDOC3|MENTHLTH|PHYSHLTH|FLUSHOT7|_LLCPWT|_STSTR|_PSU