Spotlight Dataset 148: HES Artificial Data
https://factsanddimensions.co.uk
Facts and Dimensions provide 1000s of tables of publicly available stats and reference data, ready to query immediately.
This video concentrates on schema: HES.Artifical_... tables
As at time of recording: 55million rows
Data back to: N/A as it is artificial data
Full detailed data over 3 tables:
HES.Artificial_Admitted_Patient_Care
HES.Artificial_AE
HES.Artificial_Outpatient
APC fields:
PARTYEAR
EPIKEY
AEKEY
PSEUDO_HESID
ADMIDATE
ADMIMETH
ADMINCAT
ADMINCATST
ADMISORC
ALCDIAG_4
ALCFRAC
AT_GP_PRACTICE
AT_RESIDENCE
AT_TREATMENT
CANNET
CANREG
CAUSE_3
CAUSE_4
COMMISSIONER_GP_PRACTICE
COMMISSIONER_RESIDENCE
COMMISSIONER_RESPONSIBILITY
COMMISSIONER_RESPONSIBILITY_ORIGIN
COMMISSIONER_TREATMENT
COMMISSIONER_TREATMENT_ORIGIN
CLASSPAT
CR_GP_PRACTICE
CR_RESIDENCE
CR_TREATMENT
DIAG_3_01 ... DIAG_3_20
DIAG_3_CONCAT
DIAG_4_01 ... DIAG_4_20
DIAG_4_CONCAT
DIAG_COUNT
DISDATE
DISDEST
DISMETH
ELECDATE
ELECDUR
ELECDUR_CALC
EPIDUR
EPIEND
EPIORDER
EPISTART
EPISTAT
EPITYPE
ETHNOS
FAE
FAE_EMERGENCY
FCE
FDE
GORTREAT
GPPRAC
MAINSPEF
MYDOB
NEODUR
OPERTN_3_01 ... OPERTN_3_24
OPERTN_3_CONCAT
OPERTN_4_01 ... OPERTN_4_24
OPERTN_4_CONCAT
OPERTN_COUNT
PCON
PCON_ONS
PCTCODE_HIS
PCTORIG_HIS
PCTTREAT
PROCODE3
PROCODE5
PROCODET
PURCODE
RANK_ORDER
RESCTY
RESCTY_ONS
RESGOR
RESGOR_ONS
RESLADST
RESLADST_ONS
RESPCT_HIS
RESSTHA_HIS
SEX
SITETRET
LSOA01
MSOA01
SPELBGIN
SPELDUR
SPELDUR_CALC
SPELEND
STARTAGE
STARTAGE_CALC
STHATRET
SUSHRG
SUSRECID
TRETSPEF
LSOA11
MSOA11
WAITLIST
ALCNRWFRAC
ALCNRWDIAG
ALCBRDFRAC
ALCBRDDIAG
SITEDIST
SITEDIST_FLAG
PROVDIST
PROVDIST_FLAG
HRG40
HRGLATE35
NER_GP_PRACTICE
NER_RESIDENCE
NER_TREATMENT
A&E fields:
PARTYEAR
PSEUDO_HESID
AEKEY
AEKEY_FLAG
AEARRIVALMODE
AEATTEND_EXC_PLANNED
AEATTENDCAT
AEATTENDDISP
AEDEPTTYPE
AEINCLOCTYPE
AEPATGROUP
AEREFSOURCE
AT_GP_PRACTICE
AT_RESIDENCE
AT_TREATMENT
ARRIVALAGE
ARRIVALAGE_CALC
ARRIVALDATE
ARRIVALTIME
CANNET
CANREG
CCG_GP_PRACTICE
CCG_RESIDENCE
CCG_RESPONSIBILITY
CCG_RESPONSIBILITY_ORIGIN
CCG_TREATMENT
CCG_TREATMENT_ORIGIN
CR_GP_PRACTICE
CR_RESIDENCE
CR_TREATMENT
CONCLDUR
CONCLTIME
DEPDUR
DEPTIME
DIAG2_01 ... DIAG2_12
DIAG3_01 ... DIAG3_12
DIAGA_01 ... DIAGA_12
DIAGS_01 ... DIAGS_12
DIAGSCHEME
ETHNOS
EPIKEY
GORTREAT
GPPRAC
INITDUR
INITTIME
INVEST2_01 ... INVEST2_12
INVESTSCHEME
PCON
PCON_ONS
PCTCODE_HIS
PCTORIG_HIS
PCTTREAT
PROCODE3
PROCODE5
PROCODET
PROCSCHEME
PURCODE
RANK_ORDER
RESCTY
RESCTY_ONS
RESGOR
RESGOR_ONS
RESLADST
RESLADST_ONS
RESPCT_HIS
RESSTHA_HIS
SEX
LSOA01
MSOA01
STHATRET
SUSHRG
SUSLDDATE_HIS
TREAT2_01 ... TREAT2_12
TREAT3_01 ... TREAT3_12
TREATSCHEME
TRETDUR
TRETTIME
LSOA11
MSOA11
PROVDIST
PROVDIST_FLAG
NER_GP_PRACTICE
NER_RESIDENCE
NER_TREATMENT
SITETRET
SITEDIST
SITEDIST_FLAG
OP fields:
PARTYEAR
PSEUDO_HESID
ATTENDKEY
ATTENDKEY_FLAG
ADMINCAT
APPTAGE
APPTAGE_CALC
APPTDATE
ATENTYPE
ATTENDANCE
ATTENDED
ATTENDID
AT_GP_PRACTICE
AT_RESIDENCE
AT_TREATMENT
CANNET
CANREG
COMMISSIONER_GP_PRACTICE
COMMISSIONER_RESIDENCE
COMMISSIONER_RESPONSIBILITY
COMMISSIONER_RESPONSIBILITY_ORIGIN
COMMISSIONER_TREATMENT
COMMISSIONER_TREATMENT_ORIGIN
CR_GP_PRACTICE
CR_RESIDENCE
CR_TREATMENT
DIAG_3_01 ... DIAG_3_12
DIAG_3_CONCAT
DIAG_4_01 ... DIAG_4_12
DIAG_4_CONCAT
DIAG_COUNT
DNADATE
ETHNOS
FIRSTATT
GORTREAT
GPPRAC
LOCCLASS
LOCTYPE
MAINSPEF
OPERTN_3_01 ... OPERTN_3_24
OPERTN_3_CONCAT
OPERTN_4_01 ... OPERTN_4_24
OPERTN_4_CONCAT
OPERTN_COUNT
OUTCOME
PCON
PCON_ONS
PCTCODE_HIS
PCTORIG_HIS
PCTTREAT
PREFERER
PRIORITY
PROCODE3
PROCODE5
PROCODET
PURCODE
REFERORG
REFSOURC
REQDATE
RESCTY
RESCTY_ONS
RESGOR
RESGOR_ONS
RESLADST
RESLADST_ONS
RESPCT_HIS
RESSTHA_HIS
SERVTYPE
SEX
SITETRET
LSOA01
MSOA01
STAFFTYP
STHATRET
SUSHRG
TRETSPEF
WAIT_IND
WAITDAYS
WAITING
LSOA11
MSOA11
SITEDIST
SITEDIST_FLAG
PROVDIST
PROVDIST_FLAG
NER_GP_PRACTICE
NER_RESIDENCE
NER_TREATMENT