Data dictionaries
Column definitions for every teaching dataset. All data are fully synthetic.
Patient dimension
One row per synthetic patient.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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).
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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).
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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.
| Column | Type | Definition | Example |
|---|---|---|---|
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
| Column | Type | Definition | Example |
|---|---|---|---|
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 |