Spreadsheet: 679226d1590263734-extract-specific-data-from-table-to-other-based-on-id-number-test-excel-2020
Sheet: MAY 2020 (3)

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
Inv ID | Classification Group | Client Name | ID | Subject ID | Age in years | Birth date | Death date | Gender | Nationality | PHONE | Recieved Date | Region | Directorate | Originating Hospital | Current Hospital | Final Classification | Outcome | Req ID | Req seq | Req Created date | Req Recieved date | Req status | Req test status | Sending facility | Receiving Lab | Screening result | Confirmatory result | Req Result date | Req Result time | Previous Positive | Travel To Endemic Country | Travel To Endemic Country date | Contact With confirmed Cases | Contact With confirmed date | Second Case Definition | Second Case Definition date | Health Care Worker | Health Care Worker date | Fever | Fever date | Cough | Cough date | [NAME] | [NAME] date | Shortness of breath | Shortness of breath date | [NAME] | [NAME] date | [NAME] | [NAME] date | Case with contacts | case occupation | Occupation: Health Care Worker | If yes, type of HCW | case occupation details | Temperature (C) | [NAME] saturation (%) | Score of Visual Triage | [NAME] for Pneumonia | Is the Patient Symptomatic | Reason for testing: | Was patient admitted | patient hospitalized cov | initial reason for admission | date of admission | Is Patient Isolated? | Date of Isolation | healthcare facilities visit | which healthcare facility | Department | Date of visit | travel inside KSA | If yes, specify destination(s) | point of entry | Date travel to endemic | Date Departure from endemic | Contact with Sick in endemic | Date of Coming Back to Kingdom | traveled outside KSA | If yes, specify destination(s)_1 | If Other Specify | If yes, duration of stay | Fiiting with case def Epi link | Provisional source of inf |  |  |  |  | SN | Name | ID | Confirmatory result
1272606 | Case | RANI ASLAM | 55349224 | 1272224 | 7 | 2017-01-14 |  | FEMALE | KSA | NON | 2020-05-11 | JED | JED | RCYWS | RCYWS | Suspect |  | 778622 | 1 | 2020-05-11 |  | Submitted | Final | RTWS | JED |  | Rejected |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | RANI ASLAM | 55349224
1272606 | Case | KALAM OSAYER | 39585684 | 1272224 | 45 | 2017-01-14 |  | FEMALE | KSA | NON | 2020-05-11 | JED | JED | RCYWS | RCYWS | Suspect |  | 832709 | 2 | 2020-05-15 |  | Submitted | Final | RTWS | JED |  | positive |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | KALAM OSAYER | 39585684
1422205 | Case | [NAME] | 3493328 | 6281017 | 30 | 1983-01-01 |  | MALE | KSA | NON | 2020-05-19 | JED | JED | RCYWS | RCYWS | Suspect |  | 921185 | 1 | 2020-05-19 | 2020-05-21 | Complete | Final | RTWS | JED |  | Negative | 2020-05-22 | 10:20 | NO |  |  |  |  |  |  |  |  |  |  | Yes | 2020-05-13 |  |  |  |  |  |  |  |  | no | No |  |  | NONE | 38 |  | 4 |  | yes | 3 | no |  |  |  |  |  | unknown |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 3493328
1422205 | Case | SAEED MARAN | 2343289 | 6281017 | 37 | 1983-01-01 |  | MALE | KSA | NON | 2020-05-19 | JED | JED | RCYWS | RCYWS | Suspect |  | 977505 | 2 | 2020-05-22 |  | Submitted | Final | RTWS | JED |  | Negative |  |  | NO |  |  |  |  |  |  |  |  |  |  | Yes | 2020-05-13 |  |  |  |  |  |  |  |  | no | No |  |  | NONE | 38 |  | 4 |  | yes | 3 | no |  |  |  |  |  | unknown |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | SAEED MARAN | 2343289
1469250 | Contact | SALEM SAUD | 42348234 | 6317846 | 33 | 1987-01-01 |  | MALE | KSA | NON | 2020-05-21 | JED | JED | RCYWS | RCYWS | Person Under Investigation |  | 966775 | 1 | 2020-05-21 | 2020-05-22 | Accepted | Final | RTWS | JED |  | no sample |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | Yes | otherpc | pharmacy technician |  | 37 |  | 4 |  | no |  | no |  |  |  |  |  | no |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | SALEM SAUD | 42348234
1469250 | Contact | SADARA ALAM | 4842384 | 6317846 | 33 | 1987-01-01 |  | MALE | KSA | NON | 2020-05-21 | JED | JED | RCYWS | RCYWS | Person Under Investigation |  | 969976 | 2 | 2020-05-22 |  | Submitted | Final | RTWS | JED |  | positive |  |  | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes | Yes | otherpc | pharmacy technician |  | 37 |  | 4 |  | no |  | no |  |  |  |  |  | no |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | SADARA ALAM | 4842384
1370520 | Case | TAWFAQ ALI | 3487984 | 6240798 | 34 | 1986-03-11 |  | MALE | KSA | NON | 2020-05-17 | JED | JED | RCYWS | RCYWS | Suspect |  | 871943 | 1 | 2020-05-17 | 2020-05-18 | Complete | Final | RTWS | JED |  | Negative | 2020-05-18 | 14:53 | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | No |  |  | POLICE | 38.5 |  | 4 |  | yes | 3 | yes | yes | resp |  | yes |  | no |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | TAWFAQ ALI | 3487984
1370520 | Case | SALEEM SAEED | 24492 | 6240798 | 34 | 1986-03-11 |  | MALE | KSA | NON | 2020-05-17 | JED | JED | RCYWS | RCYWS | Suspect |  | 913175 | 2 | 2020-05-19 | 2020-05-19 | Complete | Final | RTWS | JED |  | Negative | 2020-05-20 | 21:04 | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | No |  |  | POLICE | 38.5 |  | 4 |  | yes | 3 | yes | yes | resp |  | yes |  | no |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | SALEEM SAEED | 24492
1247265 | Case | SADAKA ALI | 4394948 | 6144327 | 31 | 1989-02-07 |  | MALE | KSA | NON | 2020-05-10 | JED | JED | RCYWS | RCYWS | Suspect |  | 754102 | 1 | 2020-05-10 | 2020-05-11 | Complete | Final | RTWS | JED |  | Negative | 2020-05-15 | 05:18 | NO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no | No |  |  | Military | 37 |  | 4 |  | yes | 3 | no |  |  |  |  |  | unknown |  |  |  | no |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | SADAKA ALI | 4394948
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | ALI ALI AHMED | 4545545
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | BANDAR SALEM | 8474895
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | FUAD FUAD | 3487343
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | KARAM AKRAM | 398324
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | JAMIS [NAME] | 749305
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | ELAZIBITH CODU | 347820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | WESAM SAEED | 2895638
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | [NAME] | 3679473
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXTRACT INFORMATION FROM AB TO CO