<commit_before>+++
date = "2015-09-01T19:34:46-04:00"
title = "PRESCRIPTIONS"
linktitle = "PRESCRIPTIONS"
weight = 31
toc = "true"

[menu]
  [menu.main]
    parent = "Tables in MIMIC"

+++

# The prescriptions table

**Table source:** Hospital provider order entry database.

**Table purpose:** Contains medication related order entries, i.e. prescriptions.

**Number of rows:** 4,156,450

**Links to:**

* PATIENTS on `SUBJECT_ID`
* ADMISSIONS on `HADM_ID`
* ICUSTAYS on `ICUSTAY_ID`

# Important considerations

* The table does *not* specify if an order was later cancelled as of MIMIC-III v1.0.

# Table columns

Name | Postgres data type 
---- | ----
ROW\_ID | INT
SUBJECT\_ID | INT
HADM\_ID | INT
ICUSTAY\_ID | INT
STARTTIME | TIMESTAMP(0)
ENDTIME | TIMESTAMP(0)
DRUG\_TYPE | VARCHAR(100)
DRUG | VARCHAR(100)
DRUG\_NAME\_POE | VARCHAR(100)
DRUG\_NAME\_GENERIC | VARCHAR(100)
FORMULARY\_DRUG\_CD | VARCHAR(120)
GSN | VARCHAR(200)
NDC | VARCHAR(120)
PROD\_STRENGTH | VARCHAR(120)
DOSE\_VAL\_RX | VARCHAR(120)
DOSE\_UNIT\_RX | VARCHAR(120)
FORM\_VAL\_DISP | VARCHAR(120)
FORM\_UNIT\_DISP | VARCHAR(120)
ROUTE | VARCHAR(120)
	<commit_msg>date not time. ref #78<commit_after>+++
date = "2015-09-01T19:34:46-04:00"
title = "PRESCRIPTIONS"
linktitle = "PRESCRIPTIONS"
weight = 31
toc = "true"

[menu]
  [menu.main]
    parent = "Tables in MIMIC"

+++

# The prescriptions table

**Table source:** Hospital provider order entry database.

**Table purpose:** Contains medication related order entries, i.e. prescriptions.

**Number of rows:** 4,156,450

**Links to:**

* PATIENTS on `SUBJECT_ID`
* ADMISSIONS on `HADM_ID`
* ICUSTAYS on `ICUSTAY_ID`

# Important considerations

* The table does *not* specify if an order was later cancelled as of MIMIC-III v1.0.

# Table columns

Name | Postgres data type 
---- | ----
ROW\_ID | INT
SUBJECT\_ID | INT
HADM\_ID | INT
ICUSTAY\_ID | INT
STARTDATE | TIMESTAMP(0)
ENDDATE | TIMESTAMP(0)
DRUG\_TYPE | VARCHAR(100)
DRUG | VARCHAR(100)
DRUG\_NAME\_POE | VARCHAR(100)
DRUG\_NAME\_GENERIC | VARCHAR(100)
FORMULARY\_DRUG\_CD | VARCHAR(120)
GSN | VARCHAR(200)
NDC | VARCHAR(120)
PROD\_STRENGTH | VARCHAR(120)
DOSE\_VAL\_RX | VARCHAR(120)
DOSE\_UNIT\_RX | VARCHAR(120)
FORM\_VAL\_DISP | VARCHAR(120)
FORM\_UNIT\_DISP | VARCHAR(120)
ROUTE | VARCHAR(120)
	
{'fraction_non_alphanumeric': 0.14067278287461774, 'fraction_numerical': 0.062035823503713415, 'mean_word_length': 4.42654028436019, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4134898', 'n_tokens_mistral': 992, 'n_tokens_neox': 854, 'n_words': 228}