Is there a difference between patients locally and on Google Cloud

[shaou77]

Prerequisites

• [ X] Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.mit.edu/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

I would like to search for patients whose first diagnosis is epilepsy. I found 1,986 patients on my own computer and only 1,238 on Google Cloud. I think it may be caused by the different number of patients. But I tried to check the number of both icustay_detail tables and it is the same. What is the problem? Thanks

Here's my query statement

SELECT DISTINCT subject_id FROM mimic_hosp.diagnoses_icd where icd_code in ('34500','34501','34510','34511','34540','34541','34550','34551','34560','34561','34570','34571','34580','34581','34590','34591','64940','64941','64942','64943','64944','78033','F445 ','G40 ','G400 ','G4000 ','G40001 ','G40009 ','G4001 ','G40011 ','G40019 ','G401 ','G4010 ','G40101 ','G40109 ','G4011 ','G40111 ','G40119 ','G402 ','G4020 ','G40201 ','G40209 ','G4021 ','G40211 ','G40219 ','G403 ','G4030 ','G40301 ','G40309 ','G4031 ','G40311 ','G40319 ','G404 ','G4040 ','G40401 ','G40409 ','G4041 ','G40411 ','G40419 ','G405 ','G4050 ','G40501 ','G40509 ','G408 ','G4080 ','G40801 ','G40802 ','G40803 ','G40804 ','G40811 ','G40812 ','G40813 ','G40814 ','G4082 ','G40821 ','G40822 ','G40823 ','G40824 ','G4089 ','G409 ','G4090 ','G40901 ','G40909 ','G4091 ','G40911 ','G40919 ','G40A ','G40A0 ','G40A01 ','G40A09 ','G40A1 ','G40A11 ','G40A19 ','G40B ','G40B0 ','G40B01 ','G40B09 ','G40B1 ','G40B11 ','G40B19 ','G8384 ','R561 ') and seq_num = 1 ORDER BY subject_id