Releases

A running description of all updates to the data and when those updates were made.

Upcoming releases
Pending
 * New CovidTests dataset added which provides results of all completed Covid-related tests on residents, when data are available. See wiki page on this dataset for details.
 * New StaffRoster dataset added which lists all active staff each month. See wiki page on this dataset for details.
 * Brand added to StaffCovidVaccination dataset. See wiki page for this dataset for details.
 * FloorNumber and BedLevel added to CovidTransmission dataset. See wiki page for this dataset for details.
 * Some duplicate appointments removed from Activity
 * CovidInfection.Sequence column set to NULL as it did not add any value. Joining on ResidentId + Day is sufficient.

Release 1.23
Released April 5, 2021
 * StaffCovidInfection.Gender shows NULL if not "Male" or "Female".
 * Removed records in StaffWork where there were multiple records per staff per day per shift. StaffWork now contains only one record maximum per staff per day per shift.
 * ILI removed from Comorbidity dataset as it is already included in CovidInfection dataset.
 * Removed errant semicolon from CovidInfection dataset
 * StaffWork.Institution and StaffCovidVaccination columns now show "Other" if work/vaccination location is not a prison.

Release 1.22
Released March 29, 2021
 * Starting and Ending columns in Demographics, Comorbidity, and Disability updated such that each record spans the period [Starting, Ending), with the Ending date of one record equal to the Starting date of the next for the same patient and date element.

Release 1.21
Released March 22, 2021


 * Bug fix wherein Sequence value for CovidInfection records where element="TestResultDate" was incorrect. Corrected by setting Day value of these records to equal the collection date of the test.  Value column of these records still shows the date the test result was received, which may be the same as the collection date or may be a later date.


 * Bug fix wherein demographic values were missing from the demographics dataset. Corrected by setting the minimum startdate of all demographic values to January 1, 2016.


 * Warning added to description of CovidInfection.SxOnset stating that since the Covid-19 surge starting in December, 2020, SxOnset data are not be complete.

Release 1.2
Released on March 15, 2021
 * Full and incremental files for each of the following datasets were restored to the SFTP site:
 * 1) StaffWork
 * 2) StaffCovidVaccination
 * 3) StaffCovidInfection


 * "Hospitalized" removed as a value from Comorbidity dataset as this information is already and more appropriately provided via the LocationStarus and OutToMedical columns of the CovidTransmission dataset.

Release 1.1
Released on March 1, 2021

Note: All staff datasets (StaffWork, StaffCovidInfection, StaffCovidVaccination) remain offline and will be restored in a future release once all privacy safeguards have been implemented.


 * CovidInfection dataset normalized to reduce file size. No longer one record per resident per day.  See ResidentData/CovidInfection for details.
 * Addition of Hospitalization element in CovidInfection dataset.
 * Additional values included in CovidLOC element in CovidInfection dataset.
 * Treatment dataset containing Tamiflu and Bamlanivimab data added.
 * Dates for historical comorbidities in Comorbidity dataset now start at beginning of month instead of end of month.
 * Replaced truncated ethnicity values in Demographics dataset with full values
 * Fixed bug in CovidInfection wherein Ili dates were not correct.
 * Fixed bug in Activity wherein there was a semicolon in some job descriptions

Release 1.01
Released February 17, 2021


 * Split each dataset into full and incremental files.

Release 1.0
Released on February 8, 2021

The is the initial deployment of the research datamart SFTP files

The following zipped files were deployed to the SFTP site. Each zipped file contains a semicolon separated file of relevant data from January 1, 2016 through February 8, 2021. Filenames follow the convention of foldername+"_"+MMDDYYYY. Example: "Demographics_02082021". The suffix date represents the date the data were last compiled.


 * Activity\Activity.zip
 * Comorbidity\Comorbidity.zip
 * CovidInfection\CovidInfection.zip
 * CovidTransmission\CovidTransmission.zip
 * Demographics\Demographics.zip
 * Disability\Disability.zip
 * Immunization\Immunization.zip
 * StaffCovidInfection\StaffCovidInfection.zip
 * StaffCovidVaccination\StaffCovidVaccination.zip
 * StaffWork\StaffWork.zip