Implausible amount of infused crystalloids

[jsassenscheidt]

Hello,

while I was working on some fluid data I found some strange outliers. I was able to narrow down the cause a bit. Running the following SQL query will return two patients with administered fluids of more than 500 liters:

SELECT admissionid, start, stop, itemid, item, dose, administered
FROM drugitems
WHERE ordercategoryid = 55
AND administered > 5000000

The item is called "X nader te bepalen" (deepl says it means "X to be specified"). I don't know if you still do some cleaning on the data, but at least I wanted to let you know.

Best wishes!

[patrickthoral]

Thanks, @jsassenscheidt. There are indeed a number of (most likely) user errors in the database, but for authenticity these have not been removed in the released dataset. We have some examples in the the bigquery tutorial showing this.