Skip to content

A data repo containing a dataset compiled and cleaned by CalMatters for our Disaster Days project.

Notifications You must be signed in to change notification settings

CalMatters/data-disaster-days

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

Disaster Days Dataset

In 2019, CalMatters published an investigative series called "Disaster Days", where we explored records of school closures between 2002 and 2019 to determine what reasons bubbled up most prominently. What we found was how the crises of the 21st century were impacting students across the state who lost instructional days that in many cases were never made up. The series, reported by former CalMatters K-12 reporter Ricardo Cano, found that "every fifth student in California sent home (in 2018) at least once for a natural disaster day, a maintenance crisis day, a threatened school shooting day or some other emergency."

To compile this dataset, CalMatters requested emergency school closure incidents reported by local school districts to the state's Department of Education from the 2002-03 school year (the farthest back records of this nature went) to the 2018-19 school year. We then built a database from those forms establishing a standardized cause for closures based on what details forms provided (spoiler: some forms were more detailed than others).

Installation and Use

The dataset is provided as a csv file and can be imported into many tools, like Excel and Google Spreadsheets.

Data Dictionary

Note: We omitted reports where we couldn't completely verify the reason or number of days for the closure. This encompasses 82 out of 15,159 reports.

Field Description
school

name of the school

district

school district where school is organized under

school_year

school year of report

enrollment

enrollment for the school year

category

category for closure report, created by CalMatters

reason

reason for closure report, created by CalMatters

description

description of closure provided in report

date_description

dates in which the closure occured

year

calendar year

days

closure days from incident

cds_code

County-District-School (CDS) code for the school

county

county where school is located

Examples of Use

Data Use

If you use this dataset, please mention it was collected, combined and cleaned by CalMatters. We would love to know how you used it, so feel free to send us a message if you do. If you have any questions about this dataset, feel free to contact us as well.

CalMatters is a nonpartisan, nonprofit journalism venture committed to explaining how California’s state Capitol works and why it matters.

About

A data repo containing a dataset compiled and cleaned by CalMatters for our Disaster Days project.

Topics

Resources

Stars

Watchers

Forks