mit-lcp / mimic-website Goto Github PK
View Code? Open in Web Editor NEWWebsite for the MIMIC Critical Care Database (currently version MIMIC-III)
Home Page: https://mimic.mit.edu
License: MIT License
Website for the MIMIC Critical Care Database (currently version MIMIC-III)
Home Page: https://mimic.mit.edu
License: MIT License
At the moment the top left of the website reads "MIMIC-III v1.0". I think a useful improvement would be to replace this text with "The latest version of MIMIC-III is v1.1", and increment it with each version. This would make it easier for those who visit the site to notice that their version is out of date.
https://mimic.physionet.org/mimictables/noteevents/
Under "Links to:" I dont think there should be:
D_ITEMS on ITEMID
Since there is no column with such name.
@alistairewj the website is ready for us to start adding content. Hugo was a great choice...it's really nice to work with.
Adding content is straightforward. Now the framework is there, it pretty much just involves creating new files in the content directory: https://github.com/MIT-LCP/mimic-website/tree/master/content
In case you'd like to make a start on the table descriptions, I've added a set of template files at:
https://github.com/MIT-LCP/mimic-website/tree/master/content/datatables
As we'll be providing import scripts, I'm not sure whether we need to draw out each table in the documentation? I'm undecided about whether this would be useful or not...
The front page of the website needs a logo if possible.
Is there a logo for MIMIC? If not, could we create one?
Add a citation for MIMIC-III to acknowledgements.md. I believe the current in-press citation is:
Johnson A, Pollard T, Shen L, Lehman L, Feng M, Ghassemi M, Moody B, Szolovits P, Celi LA, Mark R. Medical Information Mart for Intensive Care (MIMIC-III): the public access critical care database. Scientific Data 2016 (In press).
Bug reported by @kpierceHST:
it turns out that my script for approving mimic users no longer works, because it pointed to a location on the old site. ditto for the display of grantees.
The "Data" button on the front page of the website (http://mimic.physionet.org/) should link to a very clear explanation of how to get hold of the MIMIC data. At the moment, it doesn't.
The following components were present in the old website, but are not currently listed anywhere on the new website:
Set up the repository on Travis CI:
https://travis-ci.org
After installing MIMIC-III in a local Postgres database, create a test to compare dimensions of local database with online database.
Should the website display a list of MIMIC-related articles? For example, see:
https://mimic.physionet.org/about/publications.html
If so, how should the list of articles be generated?
I've been trying to follow the method presented here. https://mimic.physionet.org/tutorials/install-mimic-locally-windows/. When I try to create tables with the command \i postgres_create_tables.sql, it gives me a syntax error. Screenshot attached. Please guide regarding the same. Thanks!
When rebuilding the website, old pages don't seem to be deleted. For example, IOEVENTS has been removed and replaced with a few tables, e.g. INPUTEVENTS_CV:
http://mimic.physionet.org/mimictables/inputevents_cv/
And on the left, it's clear that IOEVENTS is no longer listed:
But, you can still type in the URL for the old table: http://mimic.physionet.org/mimictables/ioevents/
Which brings you to an obsolete page describing IOEVENTS:
@kepaik suggests that instead of listing a single page for each data table as shown in the image below, we should display the details in a single longer page (with a menu to find items within the page). I agree this would work better, so will update the template.
Hi,
I am getting ready to build a data dictionnary for mimic descibing things like https://mimic.physionet.org/mimictables/callout/ . This data dictionnary will be machine exploitable. For my use case, it will be a basis to align my database on mimic and document it. But it could be usefull too for you:
I uselly use an excel spreadsheet, robust & multiplateform. Do you have any thing to start with other than the website flat documentation ?
Thanks,
We need to create a system for making announcements on the front page of the website. Ideally it should be:
I noticed that there is a tutorial for installing MIMIC-III on Windows here on GitHub, but it hasn't yet been added to the mimic website.
It is a fairly similar install but a few of the commands differ. As a beginner I got a little bit lost trying to translate the Ubuntu instructions to work on Windows until luckily, I stumbled across the Windows readme here on GitHub (thanks for posting @alistairewj !)
https://github.com/MIT-LCP/mimic-code/blob/master/buildmimic/postgres/README-windows.md
Hello, after reading what follows, I didn't really get how can I obtain the RASS of a certain group of patients.
#185 - Three text concepts (GCS, code status, RASS) had a null linksto field in d_items, even though the data existed in chartevents. This has been corrected. Note these were the only three text concepts available for Metavision patients in MIMIC-III v1.3 (see #88).
Is it available then?
I could just find this element on d_items:
228302 CAM-ICU RASS LOC
It has yes/no values on chart events, so I guess I should look somewhere else.
PD: I don't know if this is the right place for posting this kind of questions.
@kepaik suggests using a layout similar to bootstrap:
http://getbootstrap.com/
we should create a new theme on a branch then merge when ready!
In the Querying MIMIC-III tutorial, 4. Mortality and admissions section, the query uses hospital_expiry_flag field instead of expiry_flag as defined in mimic-code repo, buildmimic/postgres/postgres_create_tables.sql
Before we begin building the MIMIC website, we need to have:
As noted in the following thread, some of the row counts in the documentation need to be updated:
MIT-LCP/mimic-code#31
Hi,
I tried mapping ITEMID in CHARTEVENT table using
https://physionet.org/mimic2/UserGuide/UserGuide.pdf
Appendix 6.2,
But there are so many ITEMIDs that are not there in Appendix 6.2.
Is there a way that I can map every ITEMID to figure out what vital signs or lab events it shows?
I also tried matching the ITEMIDs with the Lab Event's ITEMIDs using:
Buttons on the front page of the site have a transparent background when someone:
There are several questions that are repeatedly sent to the mimic-support email address or to individual staff in the lab. Replying uses up lab resources, so we should explore what we can do to reduce the frequency of them (e.g. providing clearer information on the website, improving documentation, etc.). Repeated questions can be logged in this thread.
Aaron pointed out that these instructions
"...You can avoid browser warnings by installing
our certificate authority file which can be obtained from: http://mimic.physionet.org/certs/lcpca.crt"
failed because of a broken link. I copied the certs directory from old site to new and asked him to try again.
The description in Step 1 refers to the icustayevents table instead of icustays.
We would like to share a series of tutorials on the MIMIC website. The first one will be "An introduction to MIMIC-III": http://mimic.physionet.org/tutorials/intro_to_mimic-iii/
The new tutorial could be based on the MIMIC-II version at: http://mimic.physionet.org/archive/introduction-mimic-ii.pdf
As discussed with @kepaik this might be a good task for a student, because it will be a nice introduction to MIMIC. Perhaps something for @erinhong if she is interested?
We should set up web analytics for mimic.physionet.org so that we can get an idea of things like:
We should add the DOI to the website somewhere. Options include the top left so that it is carried to every page (which currently lists the version number), or we could just have it on one of the data pages.
The DOI is doi:10.13026/C2XW26
.
I'm currently running MIMIC-III on PostgreSQL through pgAdmin III on a windows installation, and I just tried going through the last part of the 'Patient age and mortality' tutorial. I noticed a couple of things that didn't work on my installation of MIMIC.
The main thing was the 'months_between' function, supposedly it doesn't exist on PostgreSQL. I think the query on the website could be for an Oracle installation.
Here is the full query I ran that resulted in what I was looking for (changed lines marked with %):
WITH first_admission_time AS (
SELECT
p.subject_id, p.dob, p.gender,
MIN (a.admittime) AS first_admittime
%FROM mimiciii.patients p
%INNER JOIN mimiciii.admissions a
ON p.subject_id = a.subject_id
%GROUP BY p.subject_id, p.dob, p.gender, a.hadm_id
ORDER BY a.hadm_id, p.subject_id
),
age AS (
SELECT
subject_id, dob, gender, first_admittime,
% age(first_admittime, dob)
AS first_admit_age,
CASE
% WHEN age(first_admittime, dob) > '89 years'
% THEN '>89'
% WHEN age(first_admittime, dob) >= '15 years'
THEN 'adult'
% WHEN age(first_admittime, dob) <= '1 year'
THEN 'neonate'
ELSE 'middle'
END AS age_group
FROM first_admission_time
ORDER BY subject_id
)
SELECT *
FROM age;
This query gives the age in years, months, days, and hours so there could be a more relevant function depending on what you need age for. The reasons behind these changes are outlined below:
Since the tutorial page says that the tutorial should be run on a PostgreSQL installation I'm concerned that maybe my set-up or query is incorrect. I also have limited programming/sql knowledge so something else may have gone wrong along the way.
Another interesting note is that there were no patients in the database with an age between 5 months and 14 years. Is this because there is no data from the paediatric ICU?
Thanks
Hi,
I tried mapping ITEMID in CHARTEVENT table using
https://physionet.org/mimic2/UserGuide/UserGuide.pdf
Appendix 6.2,
But there are so many ITEMIDs that are not there in Appendix 6.2.
Is there a way that I can map every ITEMID to figure out what vital signs or lab events it shows?
I also tried matching the ITEMIDs with the Lab Event's ITEMIDs using:
https://github.com/MIT-LCP/mimic-code/blob/master/migrating/labid.csv
But no success!
Rather than rebuilding the public content manually each time updates are made, it would be good to set up automatic deployment. See: http://gohugo.io/tutorials/automated-deployments/ for a suggested method.
When a new (minor) version of MIMIC is released, we need to make a number of manual updates across several webpages. To simplify updates, the version number should be updated in a single place and the change should be reflected across the website.
Create tutorial on how to build MIMIC locally from CSV:
The NIH require researchers of studies using MIMIC-III to include the following acknowledgment in their publications:
Research reported in this publication was supported by the National Institute of Biomedical Imaging and Bioengineering of the National Institutes of Health under Award Number R01EB017205. The content is solely the responsibility of the authors and does not necessarily represent the official views of the National Institutes of Health.
There is a large community familiar with the old website and who may be looking for information such as:
This information has been archived at: http://mimic.physionet.org/archive/mimic-ii/ but it is not immediately obvious that this is where to look.
@kpierceHST pointed out that the font isn't particularly easy to read. Change color of text and/or background and review the font.
Hello! So the NOTEEVENTS table obviously has a large amount of text spanning several pages sometimes. Is there an easy way to read it? On the website it states "TEXT is often large and contains many newline characters: it may be easier to read if viewed in a distinct program rather than the one performing the queries" - how exactly can I accomplish that? I mean is there a way to export the text (or query result in general) to a windows document reader? Thanks!
No response after clicking on Submit Information.
Once (/if) the website is finalized and approved by the group, what is the process for redirecting the MIMIC URL (https://mimic.physionet.org) to the new content?
A PDF of the documentation should be automatically generated from the web content. One option is to use Pandoc, as we did previously.
https://mimic.physionet.org/mimictables/noteevents/
Here, there is no explanation of what this column means. :)
We would like to provide a forum for the MIMIC community to discuss research questions, data extraction issues, etc. The aims of doing this include:
It would be beneficial to have a definition table for care units and services.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.