MIMIC III 数据库中表格信息

    技术2022-07-13  82

    文章目录

    数据库中表的基本信息表格中的列关系图其他(chartevents)

    来源

    数据库中表的基本信息

    TableChildrenParentsColumnsRowsCommentsadmissions1811958,976Hospital admissions associated with an ICU stay.callout22434,499Record of when patients were ready for discharge (called out), and the actual time of their discharge (or more generally, their outcome).caregivers747,567List of caregivers associated with an ICU stay.chartevents515330,712,483Events occuring on a patient chart.chartevents_11538,033,561Partition of chartevents. Should not be directly queried.chartevents_10159,584,888Partition of chartevents. Should not be directly queried.chartevents_1115470,141Partition of chartevents. Should not be directly queried.chartevents_1215265,413Partition of chartevents. Should not be directly queried.chartevents_131539,066,570Partition of chartevents. Should not be directly queried.chartevents_1415100,075,138Partition of chartevents. Should not be directly queried.chartevents_21513,116,197Partition of chartevents. Should not be directly queried.chartevents_31538,657,533Partition of chartevents. Should not be directly queried.chartevents_4159,374,587Partition of chartevents. Should not be directly queried.chartevents_51518,201,026Partition of chartevents. Should not be directly queried.chartevents_61528,014,688Partition of chartevents. Should not be directly queried.chartevents_715255,967Partition of chartevents. Should not be directly queried.chartevents_81534,322,082Partition of chartevents. Should not be directly queried.chartevents_9151,274,692Partition of chartevents. Should not be directly queried.cptevents212573,146Events recorded in Current Procedural Terminology.d_cpt9134High-level dictionary of the Current Procedural Terminology.d_icd_diagnoses1414,710Dictionary of the International Classification of Diseases, 9th Revision (Diagnoses).d_icd_procedures143,898Dictionary of the International Classification of Diseases, 9th Revision (Procedures).d_items81012,487Dictionary of non-laboratory-related charted items.d_labitems16753Dictionary of laboratory-related items.datetimeevents5144,485,937Events relating to a datetime.diagnoses_icd35651,047Diagnoses relating to a hospital admission coded using the ICD9 system.drgcodes28125,557Hospital stays classified using the Diagnosis-Related Group system.icustays821261,532List of ICU admissions.inputevents_cv42217,527,935Events relating to fluid input for patients whose data was originally stored in the CareVue database.inputevents_mv5313,618,991Events relating to fluid input for patients whose data was originally stored in the MetaVision database.labevents3927,854,055Events relating to laboratory tests.microbiologyevents516631,726Events relating to microbiology tests.noteevents3112,083,180Notes associated with hospital stays.outputevents5134,349,218Outputs recorded during the ICU stay.patients19846,520prescriptions3194,156,450Medicines prescribed.procedureevents_mv525258,066Procedure start and stop times recorded for MetaVision patients.procedures_icd35240,095Procedures relating to a hospital admission coded using the ICD9 system.services2673,343Hospital services that patients were under during their hospital stay.transfers313261,897Location of patients during their hospital stay.40 Tables534728,556,685

    表格中的列

    关系图

    其他(chartevents)

    Processed: 0.017, SQL: 9