MIT-LCP/mimic-code

Update crrt-durations.sql

add some comments on start of script

remove superfluous commit message

don't drop materialized view at end of script

table -> materialized view. ref #254

table -> materialized view. ref #254

added cascade to drop view

remove commit command

remove search path setting

remove BEGIN

fix order of concepts

update readme to reflect new folders

move durations into one folder and update make-concepts to reflect

add query for CRRT durations for all pts

added icd-9 code to CCS mapping

fix row number bug

remove admit history dialysis from query

fix GU being negative, fix comment, ref #204

Correcting path for demographics queries. …

Updating make-concepts.sql to reflect that HeightWeightQuery.sql and icustay_detail.sql have been moved to demographics subfolder.

Added query folders to their path. Sorted by dependency. …

Added the query folders. 
It wasn't clear where the queries are located. Two were in the concepts folder and others were in firstday folder.
Also, another dependency was observed and added (ventilation-durations).
Sorted by folder then dependency.

refactor

removed subject_id

fix reference to comorbidity folder

remove debug filter limiting to 1 patient

fix to reflect change in ventfirstday query

remove debug icustay_id

recode logic for durations, remove GCS as it's insensitive

refactor to use with to ease reading of query

ETT is not sensitive for ventilation, refers to #156

adding precision to los_ and age variables …

Rounding admit- and dischtime to DATE and then calculating the difference is not very precise. Using EXTRACT(epoch gives actual 4 digit precision. For age the difference is probably negligible, but could be changed for completeness.

fix comments - queries do not use ventfirstday table

use vent durations for consistency

Fixed relative paths in make-severity-scores.sql

formatting, remove schema from query

move to cookbook folder