Is there a difference between patients locally and on Google Cloud

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

Start by running the supplied SQL against the local and Google Cloud mimic_hosp.diagnoses_icd tables, then compare the matching rows and the icustay_detail population. Done means identifying and documenting why the query returns 1,986 versus 1,238 patients.