Skip to content

Open Data: Nursing Homes, Nurse Licensing, and CNA Programs

The datasets behind Medical Career Center are free to download as CSV files. Each file is generated from the same tables the site's pages use, so a download always matches what the site shows. Reuse is free under CC BY 4.0 with credit to Medical Career Center.

Datasets

Nursing home staffing, turnover, and penalties

14,690 rows · 30 columns

Every Medicare- or Medicaid-certified US nursing home with reported staffing hours per resident per day (nurse aide, LPN, RN, total, weekend), nursing staff and RN turnover, administrators who left, CMS star ratings, health deficiencies, fines, and payment denials.

Source: CMS Care Compare Provider Information (public data), current monthly release. License: CMS figures are public data. The compilation is released under CC BY 4.0: free to use, share, and adapt with credit to Medical Career Center (medicalcareercenter.org).

Columns

ccn, name, city, state, zip, ownership, chain, certified_beds, avg_residents, aide_hprd, lpn_hprd, rn_hprd, total_nurse_hprd, weekend_total_hprd, total_turnover_pct, rn_turnover_pct, admins_left, staffing_footnote, overall_stars, health_stars, staffing_stars, qm_stars, health_deficiencies, fines_3yr, fine_amount_3yr, payment_denials_3yr, abuse_icon, special_focus, cms_release, mcc_url

Nursing home staffing by state

53 rows · 6 columns

The state table from the Nursing Home Staffing Report: homes analyzed, median aide hours and turnover, and the share of homes at or above the thresholds of the repealed 2024 federal minimum staffing rule.

Source: Computed by Medical Career Center from CMS Care Compare Provider Information. License: CC BY 4.0: free to use, share, and adapt with credit to Medical Career Center (medicalcareercenter.org).

Columns

state, homes_analyzed, median_aide_hprd, median_turnover_pct, meet_2_45_aide_hprd, meet_all_three_2024_thresholds

RN license rules by state

51 rows · 13 columns

For all 51 boards of nursing: official license lookup, Nurse Licensure Compact status and implementation date, renewal cycle, continuing education hours, license and renewal fees, temporary permit, and board phone.

Source: Each state board of nursing; compact dates from the Nurse Licensure Compact. License: CC BY 4.0: free to use, share, and adapt with credit to Medical Career Center (medicalcareercenter.org).

Columns

state, board, board_url, license_lookup_url, compact_member, compact_implemented, renewal_cycle_years, ce_hours, initial_fee, renewal_fee, temporary_permit, phone, mcc_url

LPN license rules by state

51 rows · 13 columns

The same fields for practical and vocational nurse licensing in all 51 jurisdictions.

Source: Each state board of nursing; compact dates from the Nurse Licensure Compact. License: CC BY 4.0: free to use, share, and adapt with credit to Medical Career Center (medicalcareercenter.org).

Columns

state, board, board_url, license_lookup_url, compact_member, compact_implemented, renewal_cycle_years, ce_hours, initial_fee, renewal_fee, temporary_permit, phone, mcc_url

CNA training hours and nurse aide registries by state

51 rows · 7 columns

Required nurse aide training hours and clinical hours in each state, with the registry operator, official lookup, and phone.

Source: State nurse aide training rules and registry sites. License: CC BY 4.0: free to use, share, and adapt with credit to Medical Career Center (medicalcareercenter.org).

Columns

state, training_hours, clinical_hours, registry_operator, registry_lookup_url, registry_phone, mcc_url

State-approved CNA training programs

6,858 rows · 12 columns

Programs on the official approved nurse aide training lists of the states that publish one: name, address, city, ZIP, county, phone, type, and hours as each state lists them.

Source: State approved nurse aide training program lists. License: CC BY 4.0: free to use, share, and adapt with credit to Medical Career Center (medicalcareercenter.org).

Columns

state, program, address, city, zip, county, phone, type, hours, status, state_list_url, listed

Using the data

Credit the data as “Medical Career Center (medicalcareercenter.org)” with a link to the page or file you used. Nursing home figures are CMS public data and update with each monthly CMS release; license rules and program lists are compiled from state boards and state program lists and carry the dates shown on each state's page.

Hours are per resident per day. Turnover and fines are CMS measures (turnover over a year, fines over three years). A blank cell means the source publishes no figure. Individual license and certification records are not offered in bulk; look them up one at a time through the nurse aide registry lookup or the nursing license lookup.

The Nursing Home Staffing Report is built from the first two datasets. Questions or corrections: contact Team MCC.