Finding Pregnant Women in the dataset

[isaacopix]

Hello,

How can I find pregnant women in the dataset? Which table and variable can I use to get this group?

[jraffa]

I don't think there is a specific table or variable. Context will be important, as there are like post-labour patients in here that you may or may not want.

I found some in the diagnosis table:

select diagnosisstring, count(diagnosisstring) as count  from diagnosis where diagnosisstring ilike '%preg%' group by diagnosisstring ORDER by c DESC;

diagnosisstring	count
surgery|obstetrics|pregnancy	243
surgery|obstetrics|pre-eclampsia/ eclampsia|pregnancy induced hypertension	42
surgery|obstetrics|vaginal hemorrhage|not pregnancy related	32
surgery|obstetrics|ectopic pregnancy|with rupture	24
gastrointestinal|hepatic disease|hepatic dysfunction|pregnancy related	17
cardiovascular|ventricular disorders|cardiomyopathy|peri-partum|during pregnancy	14
hematology|bleeding and red blood cell disorders|anemia|relative anemia, including anemia of pregnancy	10

....and more

I would also look in the pasthistory table.

[isaacopix]

Thanks this might work!

Initially, I was thinking of using the icd9code in the diagnosis table to identify pregnant women but could not get the pregnancy codes associated with pregnancy such as Z33, O009-09A in the demo database.