Guidance
GUMCAD: sample data extract
Updated 12 November 2021
Download CSV 2.08 KB
| ClinicID | Clinic_Type | PatientID | Patient_Type | Gender_Identity | Gender_Birth | Age | Sex_Ori | Ethnicity | Country_Birth | LA | LSOA | Consultation_Referral | Consultation_Date | Consultation_Medium | Consultation_Type | Consultation_Speciality | Consultation_PN | Consultation_Symptomatic | Episode_Activity | Diagnosis_Confirmed | Diagnosis_Site | Diagnosis_Treated | OSP | OSP_New | OSP_CL | MSM | MSM_HIV_Pos | MSM_CL | MSM_CL_Rec | WSW | WSW_New | PN_Date | PN_Partners | PN_Contacts | PN_Contacts_Att_Rep | PN_Contacts_Att_Ver | PrEP_Eligibility | PrEP_Uptake | PrEP_Regimen | PrEP_Prescription | PrEP_Stop_Reason | Alcohol_1 | Alcohol_2 | Drugs_Used | Drugs_1 | Drugs_2 | Drugs_3 | Drugs_4 | Drugs_5 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| R1234 | 1 | M1900001 | 2 | 1 | Y | 32 | 2 | A | GBR | E09000008 | E01001106 | 1082321000000109 | 2019-01-01 | 1 | 1 | 2 | NA | Y | 240589008 | 1 | 2 | 1 | NA | NA | NA | 4 | U | N | NA | NA | NA | 2019-01-01 | 6 | 6 | 4 | 4 | 1 | 1 | 1 | 3 | NA | Y | N | Y | NA | NA | Y | NA | NA |
| R1234 | 1 | M1900001 | 2 | 1 | Y | 32 | 2 | A | GBR | E09000008 | E01001106 | 1082321000000109 | 2019-01-01 | 1 | 1 | 2 | NA | Y | 442487003 | NA | NA | NA | NA | NA | NA | 4 | U | N | NA | NA | NA | Not set | NA | NA | NA | NA | 1 | 1 | 1 | 3 | NA | Y | N | Y | NA | NA | Y | NA | NA |
| R1234 | 1 | F1900001 | NA | 2 | Y | 20 | 1 | M | JAM | E09000011 | E01001571 | 1086261000000106 | 2019-02-01 | 1 | 1 | 1 | NA | N | 240589008 | 2 | 1 | 1 | 2 | Y | Y | NA | NA | NA | NA | NA | NA | 2019-02-01 | 1 | 1 | 1 | 1 | NA | NA | NA | NA | NA | Y | N | N | NA | NA | NA | NA | NA |
| R1234 | 1 | F1900001 | NA | 2 | Y | 20 | 1 | M | JAM | E09000011 | E01001571 | 1086261000000106 | 2019-02-01 | 1 | 1 | 1 | NA | N | 442487003 | NA | NA | NA | 2 | Y | Y | NA | NA | NA | NA | NA | NA | Not set | NA | NA | NA | NA | NA | NA | NA | NA | NA | Y | N | N | NA | NA | NA | NA | NA |
| R1234 | 1 | F1900001 | NA | 2 | Y | 20 | 1 | M | JAM | E09000011 | E01001571 | 1086261000000106 | 2019-02-01 | 1 | 1 | 1 | NA | N | 171149006 | NA | NA | NA | 2 | Y | Y | NA | NA | NA | NA | NA | NA | Not set | NA | NA | NA | NA | NA | NA | NA | NA | NA | Y | N | N | NA | NA | NA | NA | NA |
| R1234 | 1 | W1900001 | NA | 2 | N | 45 | 1 | C | ITA | E09000020 | E01002812 | 1086261000000109 | 2019-03-01 | 7 | 1 | 2 | NA | NA | 442487003 | NA | NA | NA | 2 | Y | Y | NA | NA | NA | NA | NA | NA | Not set | NA | NA | NA | NA | NA | NA | NA | NA | NA | Y | N | N | NA | NA | NA | NA | NA |