OpenSAFELY-TPP database schema
- Description
- This report displays the schema of the OpenSAFELY-TPP database.
- Contact
- Get in touch and tell us how you use this report or new features you'd like to see: team@opensafely.org
- First published
- 06 Jan 2021
- Last released
- 17 May 2023
- Links
OpenSAFELY-TPP Database Schema¶
This report displays the schema of the OpenSAFELY-TPP database. It is part of the OpenSAFELY platform's technical documentation and is published at https://reports.opensafely.org/.
The schema is read from the OpenSAFELYSchemaInformation
table,
which is refreshed at the same time as the core SystmOne primary care datasets.
There are some non-automated steps required to update the schema information when a new table is added to the database —
if you can't see a table that you are expecting to see, then please speak to TPP.
If you would like to use the OpenSAFELY platform, then you should read our documentation, our principles, and our process for onboarding new users. If you would like to see the code we used to create this report, then you can view it on GitHub.
Data Sources¶
The core SystmOne primary care datasets are stored in the S1
tables in the database.
The table below lists other, externally-linked datasets:
Dataset | Source | Tables |
---|---|---|
All positive or negative SARS-CoV2 tests | SGSS | SGSS_AllTests_Positive , SGSS_AllTests_Negative |
First-ever positive or negative SARS-CoV2 test | SGSS | SGSS_Positive , SGSS_Negative |
A&E attendances | SUS Emergency Care | EC |
In-patient hospital admissions | SUS Admitted Patient Care Spells | APCS |
Out-patient hospital appointments | SUS | OPA |
Covid-related ICU admissions | ICNARC | ICNARC |
Covid-related in-hospital deaths | CPNS | CPNS |
COVID-19 Infection Survey | ONS | ONS_CIS |
All-cause registered deaths | ONS | ONS_Deaths |
High cost drugs | HighCostDrugs |
|
Unique Property Reference Number1 | UPRN |
|
Master Patient Index | MPI |
|
Health and Social Care Worker identification2 | HealthCareWorker |
1Used for deriving household variables
2Collected at the point of vaccination
Some of these tables are accompanied by additional tables.
For example, the OPA
table contains the core out-patient appointment event data, and is accompanied by the OPA_Cost
, OPA_Diag
, and OPA_Proc
tables.
Report Run Date¶
This report was run on 2023-05-16. It reflects the state of the database on this date.
Table Names by Data Source¶
DataSource | TableName |
---|---|
Airmid | OpenPROMPT |
ICNARC | ICNARC |
ISARIC | ISARIC_New |
NHSD_HIGH_COST_DRUGS | HighCostDrugs |
NHSE_APCS | APCS |
NHSE_APCS | APCS_Cost |
NHSE_APCS | APCS_Der |
NHSE_CPNS | CPNS |
NHSE_EC | EC |
NHSE_EC | EC_AlcoholDrugInvolvement |
NHSE_EC | EC_Comorbidities |
NHSE_EC | EC_Cost |
NHSE_EC | EC_Diagnosis |
NHSE_EC | EC_Investigation |
NHSE_EC | EC_PatientMentalHealth |
NHSE_EC | EC_Treatment |
NHSE_ECDS | ECDS |
NHSE_ECDS | ECDS_EC_Diagnoses |
NHSE_HEALTH_CARE_WORKER | HealthCareWorker |
NHSE_MPI | MPI |
NHSE_MPI | UPRN |
NHSE_OPA | OPA |
NHSE_OPA | OPA_Cost |
NHSE_OPA | OPA_Diag |
NHSE_OPA | OPA_Proc |
NHSE_SGSS | SGSS_AllTests_Negative |
NHSE_SGSS | SGSS_AllTests_Positive |
NHSE_SGSS | SGSS_Negative |
NHSE_SGSS | SGSS_Positive |
NHSE_Therapeutics | Therapeutics |
NHSE_WL | WL_ClockStops |
NHSE_WL | WL_Diagnostics |
NHSE_WL | WL_OpenPathways |
ONS_CIS | ONS_CIS |
ONS_CIS | ONS_CIS_New |
ONS_CIS | ONS_CIS_New_Swab_Clearance |
ONS_CIS | ONS_CIS_New_Swab_Clearance_Pos_All |
ONS_CIS | ONS_CIS_New_Swab_Clearance_Pos_TnT |
ONS_DEATHS | ONS_Deaths |
OS_BUILD | BuildInfo |
OS_BUILD | CodeCountIndicator |
OS_BUILD | LatestBuildTime |
OS_BUILD | OpenSAFELYSchemaInformation |
OS_DERIVED | Household |
OS_DERIVED | HouseholdMember |
OS_DERIVED | MSOA_PopulationEstimates_2019 |
OS_DERIVED | PotentialCareHomeAddress |
S1 | Appointment |
S1 | CodedEvent |
S1 | CodedEventRange |
S1 | Consultation |
S1 | CTV3Dictionary |
S1 | CTV3Hierarchy |
S1 | DataDictionary |
S1 | ICD10Dictionary |
S1 | MedicationDictionary |
S1 | MedicationIssue |
S1 | MedicationRepeat |
S1 | MedicationSensitivity |
S1 | Organisation |
S1 | Patient |
S1 | PatientAddress |
S1 | QOFClusterReference |
S1 | RegistrationHistory |
S1 | UnitDictionary |
S1 | Vaccination |
S1 | VaccinationReference |
S1 | YCodeToSnomedMapping |
UK_Renal_Register | UKRR |
Table Schemas¶
The table schemas contain the following information:
ColumnName
, the column nameColumnType
, the column type, such as integer, numeric, or date. For more information, see SQL Server's data types documentationPrecision
,Scale
andMaxLength
. For more information, see SQL Server's precision, scale, and length documentationIsNullable
, whetherNULL
values are accepted
Use the links in the list below to jump to a table schema.
- Airmid
- ICNARC
- ISARIC
- NHSD_HIGH_COST_DRUGS
- NHSE_APCS
- NHSE_CPNS
- NHSE_EC
- NHSE_ECDS
- NHSE_HEALTH_CARE_WORKER
- NHSE_MPI
- NHSE_OPA
- NHSE_SGSS
- NHSE_Therapeutics
- NHSE_WL
- ONS_CIS
- ONS_DEATHS
- OS_BUILD
- OS_DERIVED
- S1
- Appointment
- CTV3Dictionary
- CTV3Hierarchy
- CodedEvent
- CodedEventRange
- Consultation
- DataDictionary
- ICD10Dictionary
- MedicationDictionary
- MedicationIssue
- MedicationRepeat
- MedicationSensitivity
- Organisation
- Patient
- PatientAddress
- QOFClusterReference
- RegistrationHistory
- UnitDictionary
- Vaccination
- VaccinationReference
- YCodeToSnomedMapping
- UK_Renal_Register
Airmid¶
OpenPROMPT¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CodedEvent_ID | varchar | 0 | 0 | 50 | False |
CodeSystemId | int | 10 | 0 | 4 | False |
ConceptId | varchar | 0 | 0 | 50 | True |
Consultation_ID | bigint | 19 | 0 | 8 | False |
ConsultationDate | datetime | 23 | 3 | 8 | False |
NumericValue | real | 24 | 0 | 4 | False |
Patient_ID | int | 10 | 0 | 4 | False |
ICNARC¶
ICNARC¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
AdvancedDays_CardiovascularSupport | int | 10 | 0 | 4 | True |
AdvancedDays_RespiratorySupport | int | 10 | 0 | 4 | True |
ahsurv | int | 10 | 0 | 4 | True |
AP2score | int | 10 | 0 | 4 | True |
ausurv | int | 10 | 0 | 4 | True |
BasicDays_CardiovascularSupport | int | 10 | 0 | 4 | True |
BasicDays_RespiratorySupport | int | 10 | 0 | 4 | True |
CalculatedAge | int | 10 | 0 | 4 | True |
DateOfDeath | datetime | 23 | 3 | 8 | True |
EstimatedAge | int | 10 | 0 | 4 | True |
HighestLevelFirst24Hours | int | 10 | 0 | 4 | True |
HospitalAdmissionDate | datetime | 23 | 3 | 8 | True |
HospitalDischargeDate | datetime | 23 | 3 | 8 | True |
HRG | varchar | 0 | 0 | 50 | True |
ICNARC_ID | bigint | 19 | 0 | 8 | True |
IcuAdmissionDateTime | datetime | 23 | 3 | 8 | True |
IcuDischargeDateTime | datetime | 23 | 3 | 8 | True |
IMscore | int | 10 | 0 | 4 | True |
Level0days | int | 10 | 0 | 4 | True |
Level1days | int | 10 | 0 | 4 | True |
Level2days | int | 10 | 0 | 4 | True |
Level3days | int | 10 | 0 | 4 | True |
OriginalHospitalAdmissionDate | datetime | 23 | 3 | 8 | True |
OriginalIcuAdmissionDate | datetime | 23 | 3 | 8 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
pfratio | real | 24 | 0 | 4 | True |
Sex | varchar | 0 | 0 | 10 | True |
SupportDays_Dermatological | int | 10 | 0 | 4 | True |
SupportDays_Gastrointestinal | int | 10 | 0 | 4 | True |
SupportDays_Liver | int | 10 | 0 | 4 | True |
SupportDays_Neurological | int | 10 | 0 | 4 | True |
SupportDays_Renal | int | 10 | 0 | 4 | True |
TransferredIn | varchar | 0 | 0 | 10 | True |
TransferredOut | varchar | 0 | 0 | 10 | True |
UltimateHospitalDischargeDate | datetime | 23 | 3 | 8 | True |
UltimateIcuDischargeDate | datetime | 23 | 3 | 8 | True |
Ventilator | int | 10 | 0 | 4 | True |
yhsurv | int | 10 | 0 | 4 | True |
yusurv | int | 10 | 0 | 4 | True |
ISARIC¶
ISARIC_New¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
abdopain_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
abdopain_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
adeno_mbcat | varchar | 0 | 0 | 1000 | True |
adeno_mbcat_v2 | varchar | 0 | 0 | 1000 | True |
adm_no_symp | varchar | 0 | 0 | 1000 | True |
admission_diabp_vsorres | varchar | 0 | 0 | 1000 | True |
admission_signs_and_symptoms_complete | varchar | 0 | 0 | 1000 | True |
age | varchar | 0 | 0 | 1000 | True |
age.factor | varchar | 0 | 0 | 1000 | True |
age_estimateyears | varchar | 0 | 0 | 1000 | True |
age_estimateyearsu | varchar | 0 | 0 | 1000 | True |
agedatyn | varchar | 0 | 0 | 1000 | True |
ageusia_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
ageusia_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
aidshiv_mhyn | varchar | 0 | 0 | 1000 | True |
aneamia_ceterm | varchar | 0 | 0 | 1000 | True |
animal_erdat | varchar | 0 | 0 | 1000 | True |
animal_erdat_2 | varchar | 0 | 0 | 1000 | True |
animal_erterm | varchar | 0 | 0 | 1000 | True |
animal_erterm_2 | varchar | 0 | 0 | 1000 | True |
animal_eryn | varchar | 0 | 0 | 1000 | True |
animal_eryn_2 | varchar | 0 | 0 | 1000 | True |
anosmia_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
anosmia_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
antibiotic_cmtrt | varchar | 0 | 0 | 1000 | True |
antibiotic_cmyn | varchar | 0 | 0 | 1000 | True |
antibiotic2_cmtrt | varchar | 0 | 0 | 1000 | True |
antibiotic2_cmyn | varchar | 0 | 0 | 1000 | True |
antibiotic3_cmtrt | varchar | 0 | 0 | 1000 | True |
antibiotic3_cmyn | varchar | 0 | 0 | 1000 | True |
antibiotic4_cmtrt | varchar | 0 | 0 | 1000 | True |
antibiotic4_cmyn | varchar | 0 | 0 | 1000 | True |
antibiotic5_cmtrt | varchar | 0 | 0 | 1000 | True |
antibiotic5_cmyn | varchar | 0 | 0 | 1000 | True |
antibiotic6_cmtrt | varchar | 0 | 0 | 1000 | True |
antibiotic6_cmyn | varchar | 0 | 0 | 1000 | True |
antibiotic7_cmtrt | varchar | 0 | 0 | 1000 | True |
antibiotic7_cmyn | varchar | 0 | 0 | 1000 | True |
antifung_cmyn | varchar | 0 | 0 | 1000 | True |
antifungal_cmtrt | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___1 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___10 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___11 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___12 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___2 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___3 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___4 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___5 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___6 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___7 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___8 | varchar | 0 | 0 | 1000 | True |
antiviral_cmtrt___9 | varchar | 0 | 0 | 1000 | True |
antiviral_cmyn | varchar | 0 | 0 | 1000 | True |
any_daily_fio2_21 | varchar | 0 | 0 | 1000 | True |
any_daily_fio2_28 | varchar | 0 | 0 | 1000 | True |
any_daily_hoterm | varchar | 0 | 0 | 1000 | True |
any_daily_invasive_prtrt | varchar | 0 | 0 | 1000 | True |
any_daily_nasaloxy_cmtrt | varchar | 0 | 0 | 1000 | True |
any_daily_noninvasive_prtrt | varchar | 0 | 0 | 1000 | True |
any_icu | varchar | 0 | 0 | 1000 | True |
any_icu_hoterm | varchar | 0 | 0 | 1000 | True |
any_invasive | varchar | 0 | 0 | 1000 | True |
any_invasive_proccur | varchar | 0 | 0 | 1000 | True |
any_noninvasive | varchar | 0 | 0 | 1000 | True |
any_noninvasive_proccur | varchar | 0 | 0 | 1000 | True |
any_oxygen | varchar | 0 | 0 | 1000 | True |
any_oxygen_cmoccur | varchar | 0 | 0 | 1000 | True |
any_oxygenhf_cmoccur | varchar | 0 | 0 | 1000 | True |
any_trach | varchar | 0 | 0 | 1000 | True |
anydat.day1 | varchar | 0 | 0 | 1000 | True |
anydat.disch | varchar | 0 | 0 | 1000 | True |
apdm_age | varchar | 0 | 0 | 1000 | True |
aplb_lbmethod | varchar | 0 | 0 | 1000 | True |
aplb_lbmethodoth | varchar | 0 | 0 | 1000 | True |
aplb_lborres | varchar | 0 | 0 | 1000 | True |
aplb_lborres_out | varchar | 0 | 0 | 1000 | True |
aplb_lbperf | varchar | 0 | 0 | 1000 | True |
aplb_lbperf_out | varchar | 0 | 0 | 1000 | True |
apsc_brdisdat | varchar | 0 | 0 | 1000 | True |
apsc_brfedind | varchar | 0 | 0 | 1000 | True |
apsc_brfedindy | varchar | 0 | 0 | 1000 | True |
apsc_dvageind | varchar | 0 | 0 | 1000 | True |
apsc_gestout | varchar | 0 | 0 | 1000 | True |
apsc_vcageind | varchar | 0 | 0 | 1000 | True |
apvs_weight | varchar | 0 | 0 | 1000 | True |
apvs_weightnk | varchar | 0 | 0 | 1000 | True |
apvs_weightu | varchar | 0 | 0 | 1000 | True |
ards_ceoccur | varchar | 0 | 0 | 1000 | True |
ari | varchar | 0 | 0 | 1000 | True |
arm | varchar | 0 | 0 | 1000 | True |
arm_n | varchar | 0 | 0 | 1000 | True |
arm_participant | varchar | 0 | 0 | 1000 | True |
arrhythmia_ceterm | varchar | 0 | 0 | 1000 | True |
asthma_mhyn | varchar | 0 | 0 | 1000 | True |
asymptomatic | varchar | 0 | 0 | 1000 | True |
avpu_vsorres.day1 | varchar | 0 | 0 | 1000 | True |
avpu_vsorres.disch | varchar | 0 | 0 | 1000 | True |
bact_mborres | varchar | 0 | 0 | 1000 | True |
bacteraemia_ceterm | varchar | 0 | 0 | 1000 | True |
bacteria_mborres | varchar | 0 | 0 | 1000 | True |
bactpneu_ceoccur | varchar | 0 | 0 | 1000 | True |
bleed_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
bleed_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
bleed_ceterm_v2 | varchar | 0 | 0 | 1000 | True |
bleed_cetermy_v2 | varchar | 0 | 0 | 1000 | True |
bleed_cetermy_v3 | varchar | 0 | 0 | 1000 | True |
bloodgroup | varchar | 0 | 0 | 1000 | True |
bronchio_ceterm | varchar | 0 | 0 | 1000 | True |
calc_age | varchar | 0 | 0 | 1000 | True |
cardiacarrest_ceterm | varchar | 0 | 0 | 1000 | True |
cardiomyopathy_ceterm | varchar | 0 | 0 | 1000 | True |
casiriv_cmtrt_first | varchar | 0 | 0 | 1000 | True |
ccg | varchar | 0 | 0 | 1000 | True |
cestdat | varchar | 0 | 0 | 1000 | True |
chestpain_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
chestpain_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
chrincard | varchar | 0 | 0 | 1000 | True |
chronic_ace_cmoccur | varchar | 0 | 0 | 1000 | True |
chronic_arb_cmoccur | varchar | 0 | 0 | 1000 | True |
chronic_nsaid_cmoccur | varchar | 0 | 0 | 1000 | True |
chronichaemo_mhyn | varchar | 0 | 0 | 1000 | True |
chronicneu_mhyn | varchar | 0 | 0 | 1000 | True |
chronicpul_mhyn | varchar | 0 | 0 | 1000 | True |
clinical_frailty | varchar | 0 | 0 | 1000 | True |
clinicalpneu_mborres | varchar | 0 | 0 | 1000 | True |
coagulo_ceterm | varchar | 0 | 0 | 1000 | True |
comorb_none | varchar | 0 | 0 | 1000 | True |
comorbidities_complete | varchar | 0 | 0 | 1000 | True |
complications_complete | varchar | 0 | 0 | 1000 | True |
complications_none | varchar | 0 | 0 | 1000 | True |
confirmed_negative_pcr | varchar | 0 | 0 | 1000 | True |
confirmed_negative_pcr_complete | varchar | 0 | 0 | 1000 | True |
confusion_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
confusion_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
conjunct_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
conjunct_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
consent_ctu_dms_complete | varchar | 0 | 0 | 1000 | True |
consent_daterec | varchar | 0 | 0 | 1000 | True |
consent_given | varchar | 0 | 0 | 1000 | True |
consent_mode___1 | varchar | 0 | 0 | 1000 | True |
consent_mode___10 | varchar | 0 | 0 | 1000 | True |
consent_mode___11 | varchar | 0 | 0 | 1000 | True |
consent_mode___2 | varchar | 0 | 0 | 1000 | True |
consent_mode___3 | varchar | 0 | 0 | 1000 | True |
consent_mode___4 | varchar | 0 | 0 | 1000 | True |
consent_mode___5 | varchar | 0 | 0 | 1000 | True |
consent_mode___6 | varchar | 0 | 0 | 1000 | True |
consent_mode___7 | varchar | 0 | 0 | 1000 | True |
consent_mode___8 | varchar | 0 | 0 | 1000 | True |
consent_mode___9 | varchar | 0 | 0 | 1000 | True |
consent_optcondit___1 | varchar | 0 | 0 | 1000 | True |
consent_optcondit___2 | varchar | 0 | 0 | 1000 | True |
consent_optcondit___3 | varchar | 0 | 0 | 1000 | True |
consent_optcondit___4 | varchar | 0 | 0 | 1000 | True |
consent_phone | varchar | 0 | 0 | 1000 | True |
conv_plasma_cmyn | varchar | 0 | 0 | 1000 | True |
core_additional_information_complete | varchar | 0 | 0 | 4000 | True |
coriona_ieorres2 | varchar | 0 | 0 | 1000 | True |
coriona_ieorres3 | varchar | 0 | 0 | 1000 | True |
corna_mbcat | varchar | 0 | 0 | 1000 | True |
corna_mbcaty | varchar | 0 | 0 | 1000 | True |
corona_ieorres | varchar | 0 | 0 | 1000 | True |
coronaother_mborres | varchar | 0 | 0 | 1000 | True |
corticost_cmdose | varchar | 0 | 0 | 1000 | True |
corticost_cmroute | varchar | 0 | 0 | 1000 | True |
corticost_cmtrt | varchar | 0 | 0 | 1000 | True |
corticost_cmtrt_type | varchar | 0 | 0 | 1000 | True |
corticost_cmyn | varchar | 0 | 0 | 1000 | True |
corticost2_cmdose | varchar | 0 | 0 | 1000 | True |
corticost2_cmroute | varchar | 0 | 0 | 1000 | True |
corticost2_cmtrt | varchar | 0 | 0 | 1000 | True |
corticost2_cmtrt_type | varchar | 0 | 0 | 1000 | True |
corticost2_cmyn | varchar | 0 | 0 | 1000 | True |
corticost3_cmdose | varchar | 0 | 0 | 1000 | True |
corticost3_cmroute | varchar | 0 | 0 | 1000 | True |
corticost3_cmtrt | varchar | 0 | 0 | 1000 | True |
corticost3_cmtrt_type | varchar | 0 | 0 | 1000 | True |
corticost3_cmyn | varchar | 0 | 0 | 1000 | True |
corticost4_cmdose | varchar | 0 | 0 | 1000 | True |
corticost4_cmroute | varchar | 0 | 0 | 1000 | True |
corticost4_cmtrt | varchar | 0 | 0 | 1000 | True |
corticost4_cmtrt_type | varchar | 0 | 0 | 1000 | True |
corticost4_cmyn | varchar | 0 | 0 | 1000 | True |
corticost5_cmdose | varchar | 0 | 0 | 1000 | True |
corticost5_cmroute | varchar | 0 | 0 | 1000 | True |
corticost5_cmtrt | varchar | 0 | 0 | 1000 | True |
corticost5_cmtrt_type | varchar | 0 | 0 | 1000 | True |
corticost5_cmyn | varchar | 0 | 0 | 1000 | True |
cough | varchar | 0 | 0 | 1000 | True |
cough_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
cough_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
coughhb_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
coughhb_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
coughsput_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
coughsput_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
country | varchar | 0 | 0 | 1000 | True |
country_pcds.day1 | varchar | 0 | 0 | 1000 | True |
country_pcds.disch | varchar | 0 | 0 | 1000 | True |
cov19sars_mbyn_v2 | varchar | 0 | 0 | 1000 | True |
covid19_new | varchar | 0 | 0 | 1000 | True |
covid19_vaccine | varchar | 0 | 0 | 1000 | True |
covid19_vaccine_other_type | varchar | 0 | 0 | 1000 | True |
covid19_vaccine_type | varchar | 0 | 0 | 1000 | True |
covid19_vaccine2d | varchar | 0 | 0 | 1000 | True |
covid19_vaccine2d_nk | varchar | 0 | 0 | 1000 | True |
covid19_vaccined | varchar | 0 | 0 | 1000 | True |
covid19_vaccined_nk | varchar | 0 | 0 | 1000 | True |
cryptogenic_ceterm | varchar | 0 | 0 | 1000 | True |
daily_alt_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_alt_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_alt_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_alt_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_altop_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_altop_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_aptt_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_aptt_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_aptt_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_aptt_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_apttop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_apttop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_ast_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_ast_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_ast_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_ast_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_astop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_astop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_baseex_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_baseex_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_baseex_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_baseex_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_bil_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_bil_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_bil_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_bil_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_bil_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_bil_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_bilop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_bilop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_bun_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_bun_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_bun_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_bun_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_bun_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_bun_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_bunop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_bunop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_cpk_lby.day1 | varchar | 0 | 0 | 1000 | True |
daily_cpk_lby.disch | varchar | 0 | 0 | 1000 | True |
daily_cpk_lbyn_2.day1 | varchar | 0 | 0 | 1000 | True |
daily_cpk_lbyn_2.disch | varchar | 0 | 0 | 1000 | True |
daily_cpkop_lbyn_2.day1 | varchar | 0 | 0 | 1000 | True |
daily_cpkop_lbyn_2.disch | varchar | 0 | 0 | 1000 | True |
daily_creat_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_creat_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_creat_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_creat_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_creat_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_creat_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_creatop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_creatop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_crp_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_crp_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_crp_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_crp_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_crp_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_crp_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_crpop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_crpop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_dop5to15_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_dop5to15_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_dopgr15_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_dopgr15_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_dopless5_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_dopless5_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_dsstdat.day1 | varchar | 0 | 0 | 1000 | True |
daily_dsstdat.disch | varchar | 0 | 0 | 1000 | True |
daily_ecmo_prtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_ecmo_prtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___1.day1 | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___1.disch | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___2.day1 | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___2.disch | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___3.day1 | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___3.disch | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___4.day1 | varchar | 0 | 0 | 1000 | True |
daily_egfr_equation___4.disch | varchar | 0 | 0 | 1000 | True |
daily_egfr_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_egfr_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_egfr_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_egfr_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_egfrop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_egfrop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_esr_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_esr_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_esr_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_esr_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_esrop_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_esrop_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_ferr_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_ferr_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_ferr_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_ferr_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_ferr_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_ferr_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_ferrop_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_ferrop_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_fi02_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_fi02_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_fio2_combined.day1 | varchar | 0 | 0 | 1000 | True |
daily_fio2_combined.disch | varchar | 0 | 0 | 1000 | True |
daily_fio2_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_fio2_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_fio2b_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_fio2b_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_fio2c_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_fio2c_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_fio2c_lborres_converted.day1 | varchar | 0 | 0 | 1000 | True |
daily_fio2c_lborres_converted.disch | varchar | 0 | 0 | 4000 | True |
daily_form_complete.day1 | varchar | 0 | 0 | 1000 | True |
daily_form_complete.disch | varchar | 0 | 0 | 1000 | True |
daily_gcs_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_gcs_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_gcs_vsorres.day1 | varchar | 0 | 0 | 1000 | True |
daily_gcs_vsorres.disch | varchar | 0 | 0 | 1000 | True |
daily_glucose_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_glucose_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_glucose_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_glucose_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_glucose_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_glucose_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_glucoseop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_glucoseop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_haematocrit_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_haematocrit_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_haematocrit_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_haematocrit_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_haematocrit_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_haematocrit_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_hb_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_hb_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_hb_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_hb_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_hb_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_hb_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborresd.day1 | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborresd.disch | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborresnk.day1 | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborresnk.disch | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_hba1c_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_hba1cop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_hba1cop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_hbop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_hbop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_hco3_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_hco3_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_hco3_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_hco3_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_hco3_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_hco3_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_hoterm.day1 | varchar | 0 | 0 | 1000 | True |
daily_hoterm.disch | varchar | 0 | 0 | 1000 | True |
daily_inotrope_cmyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_inotrope_cmyn.disch | varchar | 0 | 0 | 1000 | True |
daily_inr_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_inr_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_inrop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_inrop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_invasive_prtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_invasive_prtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_lactate_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_lactate_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_lactate_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_lactate_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_lactate_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_lactate_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_lactateop_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_lactateop_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_lbdat.day1 | varchar | 0 | 0 | 1000 | True |
daily_lbdat.disch | varchar | 0 | 0 | 1000 | True |
daily_lbperf.day1 | varchar | 0 | 0 | 1000 | True |
daily_lbperf.disch | varchar | 0 | 0 | 1000 | True |
daily_ldh_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_ldh_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_ldh_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_ldh_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_ldhop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_ldhop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_lymp_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_lymp_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_lymp_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_lymp_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_lymp_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_lymp_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_lympop_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_lympop_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_meanart_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_meanart_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_meanart_vsorres.day1 | varchar | 0 | 0 | 1000 | True |
daily_meanart_vsorres.disch | varchar | 0 | 0 | 1000 | True |
daily_nasaloxy_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_nasaloxy_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_neuro_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_neuro_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_neutro_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_neutro_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_neutro_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_neutro_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_neutro_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_neutro_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_neutroop_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_neutroop_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_nitritc_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_nitritc_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_noninvasive_prtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_noninvasive_prtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_other_prtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_other_prtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_pao2_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_pao2_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_pao2_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_pao2_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_pao2_lbspec.day1 | varchar | 0 | 0 | 1000 | True |
daily_pao2_lbspec.disch | varchar | 0 | 0 | 1000 | True |
daily_pao2_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_pao2_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_pco2_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_pco2_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_pco2_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_pco2_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_pco2_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_pco2_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_ph_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_ph_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_ph_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_ph_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_plt_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_plt_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_plt_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_plt_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_plt_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_plt_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_pltop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_pltop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_potassium_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_potassium_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_potassium_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_potassium_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_potassium_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_potassium_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_potassiumop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_potassiumop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_procal_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_procal_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_procal_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_procal_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_procalop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_procalop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_prone_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_prone_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_prperf.day1 | varchar | 0 | 0 | 1000 | True |
daily_prperf.disch | varchar | 0 | 0 | 1000 | True |
daily_pt_inr_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_pt_inr_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_pt_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_pt_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_pt_lborres_add_inr.day1 | varchar | 0 | 0 | 1000 | True |
daily_pt_lborres_add_inr.disch | varchar | 0 | 0 | 1000 | True |
daily_ptop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_ptop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_rr.day1 | varchar | 0 | 0 | 1000 | True |
daily_rr.disch | varchar | 0 | 0 | 1000 | True |
daily_rr_nk.day1 | varchar | 0 | 0 | 1000 | True |
daily_rr_nk.disch | varchar | 0 | 0 | 1000 | True |
daily_rrt_cmtrt.day1 | varchar | 0 | 0 | 1000 | True |
daily_rrt_cmtrt.disch | varchar | 0 | 0 | 1000 | True |
daily_sa02_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_sa02_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_samples.day1 | varchar | 0 | 0 | 1000 | True |
daily_samples.disch | varchar | 0 | 0 | 1000 | True |
daily_samples_kitno.day1 | varchar | 0 | 0 | 1000 | True |
daily_samples_kitno.disch | varchar | 0 | 0 | 1000 | True |
daily_sao2_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_sao2_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_sodium_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_sodium_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_sodium_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_sodium_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_sodium_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_sodium_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_sodiumop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_sodiumop_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_temp_vsorres.day1 | varchar | 0 | 0 | 1000 | True |
daily_temp_vsorres.disch | varchar | 0 | 0 | 1000 | True |
daily_temp_vsorresnk.day1 | varchar | 0 | 0 | 1000 | True |
daily_temp_vsorresnk.disch | varchar | 0 | 0 | 1000 | True |
daily_temp_vsorresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_temp_vsorresu.disch | varchar | 0 | 0 | 1000 | True |
daily_trach_prperf.day1 | varchar | 0 | 0 | 1000 | True |
daily_trach_prperf.disch | varchar | 0 | 0 | 1000 | True |
daily_urine_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_urine_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_urine_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_urine_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_wbc_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_wbc_lborres.disch | varchar | 0 | 0 | 1000 | True |
daily_wbc_lborresu.day1 | varchar | 0 | 0 | 1000 | True |
daily_wbc_lborresu.disch | varchar | 0 | 0 | 1000 | True |
daily_wbc_lbyn.day1 | varchar | 0 | 0 | 1000 | True |
daily_wbc_lbyn.disch | varchar | 0 | 0 | 1000 | True |
daily_wbcop_lborres.day1 | varchar | 0 | 0 | 1000 | True |
daily_wbcop_lborres.disch | varchar | 0 | 0 | 1000 | True |
dehydration_vsorres | varchar | 0 | 0 | 1000 | True |
dementia_mhyn | varchar | 0 | 0 | 1000 | True |
demographics_complete | varchar | 0 | 0 | 1000 | True |
dexamethasone | varchar | 0 | 0 | 1000 | True |
dexamethasone_days | varchar | 0 | 0 | 1000 | True |
dexamethasone_dose | varchar | 0 | 0 | 1000 | True |
dexamethasone_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone_other_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone_route | varchar | 0 | 0 | 1000 | True |
dexamethasone2 | varchar | 0 | 0 | 1000 | True |
dexamethasone2_days | varchar | 0 | 0 | 1000 | True |
dexamethasone2_dose | varchar | 0 | 0 | 1000 | True |
dexamethasone2_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone2_other_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone2_route | varchar | 0 | 0 | 1000 | True |
dexamethasone3 | varchar | 0 | 0 | 1000 | True |
dexamethasone3_days | varchar | 0 | 0 | 1000 | True |
dexamethasone3_dose | varchar | 0 | 0 | 1000 | True |
dexamethasone3_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone3_other_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone3_route | varchar | 0 | 0 | 1000 | True |
dexamethasone4 | varchar | 0 | 0 | 1000 | True |
dexamethasone4_days | varchar | 0 | 0 | 1000 | True |
dexamethasone4_dose | varchar | 0 | 0 | 1000 | True |
dexamethasone4_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone4_other_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone4_route | varchar | 0 | 0 | 1000 | True |
dexamethasone5 | varchar | 0 | 0 | 1000 | True |
dexamethasone5_days | varchar | 0 | 0 | 1000 | True |
dexamethasone5_dose | varchar | 0 | 0 | 1000 | True |
dexamethasone5_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone5_other_freq | varchar | 0 | 0 | 1000 | True |
dexamethasone5_route | varchar | 0 | 0 | 1000 | True |
diabetes_mhyn | varchar | 0 | 0 | 1000 | True |
diabetes_type_mhyn | varchar | 0 | 0 | 1000 | True |
diabetescom_mhyn | varchar | 0 | 0 | 1000 | True |
diabp_vsyn | varchar | 0 | 0 | 1000 | True |
diarrhoea_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
diarrhoea_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
diastolic_vsorres.day1 | varchar | 0 | 0 | 1000 | True |
diastolic_vsorres.disch | varchar | 0 | 0 | 1000 | True |
diastolic_vsyn.day1 | varchar | 0 | 0 | 1000 | True |
diastolic_vsyn.disch | varchar | 0 | 0 | 1000 | True |
dlvrdtc_rptestcd | varchar | 0 | 0 | 1000 | True |
dlvrdtc_rptestcd_out | varchar | 0 | 0 | 1000 | True |
dshosp | varchar | 0 | 0 | 1000 | True |
dsstdat | varchar | 0 | 0 | 1000 | True |
dsstdtc | varchar | 0 | 0 | 1000 | True |
dsstdtc_v2 | varchar | 0 | 0 | 1000 | True |
dsstdtc_v2_nk | varchar | 0 | 0 | 1000 | True |
dsstdtcyn | varchar | 0 | 0 | 1000 | True |
dsterm | varchar | 0 | 0 | 1000 | True |
dsterm_v2 | varchar | 0 | 0 | 1000 | True |
dvt_ceterm | varchar | 0 | 0 | 1000 | True |
dyspnoe | varchar | 0 | 0 | 1000 | True |
earpain_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
earpain_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
egestage_rptestcd | varchar | 0 | 0 | 1000 | True |
endocarditis_aeterm | varchar | 0 | 0 | 1000 | True |
erendat | varchar | 0 | 0 | 1000 | True |
erendat_2 | varchar | 0 | 0 | 1000 | True |
estgest | varchar | 0 | 0 | 1000 | True |
ethnic___1 | varchar | 0 | 0 | 1000 | True |
ethnic___10 | varchar | 0 | 0 | 1000 | True |
ethnic___2 | varchar | 0 | 0 | 1000 | True |
ethnic___3 | varchar | 0 | 0 | 1000 | True |
ethnic___4 | varchar | 0 | 0 | 1000 | True |
ethnic___5 | varchar | 0 | 0 | 1000 | True |
ethnic___6 | varchar | 0 | 0 | 1000 | True |
ethnic___7 | varchar | 0 | 0 | 1000 | True |
ethnic___8 | varchar | 0 | 0 | 1000 | True |
ethnic___9 | varchar | 0 | 0 | 1000 | True |
ethnicity | varchar | 0 | 0 | 1000 | True |
excorp_prdur | varchar | 0 | 0 | 1000 | True |
excorp_still_on | varchar | 0 | 0 | 1000 | True |
extracorp_prtrt | varchar | 0 | 0 | 1000 | True |
fatigue_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
fatigue_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
fever | varchar | 0 | 0 | 1000 | True |
fever_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
fever_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
final_outcome_complete | varchar | 0 | 0 | 1000 | True |
flw_any.day1 | varchar | 0 | 0 | 1000 | True |
flw_any.disch | varchar | 0 | 0 | 1000 | True |
gastro_ceterm | varchar | 0 | 0 | 1000 | True |
headache_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
headache_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
healthwork_erterm | varchar | 0 | 0 | 1000 | True |
heartfailure_ceterm | varchar | 0 | 0 | 1000 | True |
hodur | varchar | 0 | 0 | 1000 | True |
hooccur | varchar | 0 | 0 | 1000 | True |
hostdat | varchar | 0 | 0 | 1000 | True |
hostdat_transfer | varchar | 0 | 0 | 1000 | True |
hostdat_transfernk | varchar | 0 | 0 | 1000 | True |
hosttim | varchar | 0 | 0 | 1000 | True |
hr_vsorres | varchar | 0 | 0 | 1000 | True |
hr_vsyn | varchar | 0 | 0 | 1000 | True |
hyperglycemia_aeterm | varchar | 0 | 0 | 1000 | True |
hypertension_mhyn | varchar | 0 | 0 | 1000 | True |
hypoglycemia_ceterm | varchar | 0 | 0 | 1000 | True |
icu_hoendat | varchar | 0 | 0 | 1000 | True |
icu_hoendat2 | varchar | 0 | 0 | 1000 | True |
icu_hoendat2_nk | varchar | 0 | 0 | 1000 | True |
icu_hoendat3 | varchar | 0 | 0 | 1000 | True |
icu_hoendat3_nk | varchar | 0 | 0 | 1000 | True |
icu_hoendatnk | varchar | 0 | 0 | 1000 | True |
icu_hostdat | varchar | 0 | 0 | 1000 | True |
icu_hostdat2 | varchar | 0 | 0 | 1000 | True |
icu_hostdat2_nk | varchar | 0 | 0 | 1000 | True |
icu_hostdat3 | varchar | 0 | 0 | 1000 | True |
icu_hostdat3_nk | varchar | 0 | 0 | 1000 | True |
icu_hostdatnk | varchar | 0 | 0 | 1000 | True |
icu_hostillin | varchar | 0 | 0 | 1000 | True |
icu_hoterm | varchar | 0 | 0 | 1000 | True |
icu_no | varchar | 0 | 0 | 1000 | True |
il6_cmtrt | varchar | 0 | 0 | 1000 | True |
il6_cmtrt_first | varchar | 0 | 0 | 1000 | True |
il6_cmtrt_last | varchar | 0 | 0 | 1000 | True |
il6_cmtrt_other | varchar | 0 | 0 | 1000 | True |
imd_quintile | varchar | 0 | 0 | 1000 | True |
immno_cmtrt | varchar | 0 | 0 | 1000 | True |
inclusion_criteria_complete | varchar | 0 | 0 | 1000 | True |
infect | varchar | 0 | 0 | 1000 | True |
infect_cmtrt | varchar | 0 | 0 | 1000 | True |
infectious_respiratory_disease_pathogen_diagnosis_complete | varchar | 0 | 0 | 1000 | True |
infectuk_mborres | varchar | 0 | 0 | 1000 | True |
infiltrates_faorres.day1 | varchar | 0 | 0 | 1000 | True |
infiltrates_faorres.disch | varchar | 0 | 0 | 1000 | True |
inflammatory_mss | varchar | 0 | 0 | 1000 | True |
influ_mbcat | varchar | 0 | 0 | 1000 | True |
influ_mbyn | varchar | 0 | 0 | 1000 | True |
influ_mbyn_v2 | varchar | 0 | 0 | 1000 | True |
influenza_2021_vaccine | varchar | 0 | 0 | 1000 | True |
influenza_2021_vaccined | varchar | 0 | 0 | 1000 | True |
influenza_2021_vaccined_nk | varchar | 0 | 0 | 1000 | True |
influother_mborres | varchar | 0 | 0 | 1000 | True |
influothera_mborres | varchar | 0 | 0 | 1000 | True |
inhalednit_cmtrt | varchar | 0 | 0 | 1000 | True |
inotrop_cmtrt | varchar | 0 | 0 | 1000 | True |
inotrope_cmdur | varchar | 0 | 0 | 1000 | True |
inotrope_still_on | varchar | 0 | 0 | 1000 | True |
interleukin_cmtrt | varchar | 0 | 0 | 1000 | True |
interleukin_cmyn | varchar | 0 | 0 | 1000 | True |
invasive_prdur | varchar | 0 | 0 | 1000 | True |
invasive_proccur | varchar | 0 | 0 | 1000 | True |
invasive_still_on | varchar | 0 | 0 | 1000 | True |
ischaemia_ceterm | varchar | 0 | 0 | 1000 | True |
jointpain_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
jointpain_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
labwork_erterm | varchar | 0 | 0 | 1000 | True |
liverdysfunction_ceterm | varchar | 0 | 0 | 1000 | True |
lowerchest_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
lowerchest_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
lymp_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
lymp_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
malignantneo_mhyn | varchar | 0 | 0 | 1000 | True |
malnutrition_mhyn | varchar | 0 | 0 | 1000 | True |
mbperf | varchar | 0 | 0 | 1000 | True |
meningitis_ceterm | varchar | 0 | 0 | 1000 | True |
mildliver | varchar | 0 | 0 | 1000 | True |
modliv | varchar | 0 | 0 | 1000 | True |
myalgia_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
myalgia_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
myocarditis_ceterm | varchar | 0 | 0 | 1000 | True |
neuro_cmtrt | varchar | 0 | 0 | 1000 | True |
neuro_comp | varchar | 0 | 0 | 1000 | True |
nhs_region | varchar | 0 | 0 | 1000 | True |
ni_site | varchar | 0 | 0 | 1000 | True |
no_symptoms | varchar | 0 | 0 | 1000 | True |
no_symptoms_v3 | varchar | 0 | 0 | 1000 | True |
noncorona_expphi | varchar | 0 | 0 | 1000 | True |
noninvasive_proccur | varchar | 0 | 0 | 1000 | True |
obesity_mhyn | varchar | 0 | 0 | 1000 | True |
offlabel_cmtrt | varchar | 0 | 0 | 1000 | True |
offlabel_cmyn | varchar | 0 | 0 | 1000 | True |
onset_and_admission_complete | varchar | 0 | 0 | 1000 | True |
onset2admission | varchar | 0 | 0 | 1000 | True |
othantiviral_cmtrt | varchar | 0 | 0 | 1000 | True |
othantiviral2_cmyn | varchar | 0 | 0 | 1000 | True |
othantiviral3_cmtrt | varchar | 0 | 0 | 1000 | True |
othantiviral3_cmyn | varchar | 0 | 0 | 1000 | True |
othantiviral4_cmtrt | varchar | 0 | 0 | 1000 | True |
othantiviral4_cmyn | varchar | 0 | 0 | 1000 | True |
othantiviral5_cmtrt | varchar | 0 | 0 | 1000 | True |
othantiviral5_cmyn | varchar | 0 | 0 | 1000 | True |
other_ceoccur | varchar | 0 | 0 | 1000 | True |
other_ceterm | varchar | 0 | 0 | 4000 | True |
other_cm | varchar | 0 | 0 | 1000 | True |
other_cmoccur | varchar | 0 | 0 | 1000 | True |
other_cmtrt | varchar | 0 | 0 | 1000 | True |
other_cmyn | varchar | 0 | 0 | 1000 | True |
other_ethnic | varchar | 0 | 0 | 1000 | True |
other_mborres | varchar | 0 | 0 | 1000 | True |
other_mbyn | varchar | 0 | 0 | 1000 | True |
other_mhyn | varchar | 0 | 0 | 1000 | True |
othhantiviral2_cmtrt | varchar | 0 | 0 | 1000 | True |
outcome_complete | varchar | 0 | 0 | 1000 | True |
oxy_vsorres | varchar | 0 | 0 | 1000 | True |
oxy_vsorresu | varchar | 0 | 0 | 1000 | True |
oxy_vsyn | varchar | 0 | 0 | 1000 | True |
oxygen_cmoccur | varchar | 0 | 0 | 1000 | True |
oxygen_proccur | varchar | 0 | 0 | 1000 | True |
oxygen_proccur_v2 | varchar | 0 | 0 | 1000 | True |
oxygenhf_cmoccur | varchar | 0 | 0 | 1000 | True |
pancreat_ceterm | varchar | 0 | 0 | 1000 | True |
participant_identification_number_pin_complete | varchar | 0 | 0 | 1000 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
pcr_path_diag___0 | varchar | 0 | 0 | 1000 | True |
pcr_path_diag___1 | varchar | 0 | 0 | 1000 | True |
pcr_path_diag___10 | varchar | 0 | 0 | 1000 | True |
pcr_path_diag___2 | varchar | 0 | 0 | 1000 | True |
pcr_path_diag___3 | varchar | 0 | 0 | 1000 | True |
pcr_path_diag___4 | varchar | 0 | 0 | 1000 | True |
pcr_path_diag___5 | varchar | 0 | 0 | 1000 | True |
pcr_path_diag___6 | varchar | 0 | 0 | 1000 | True |
pcr_path_diago | varchar | 0 | 0 | 1000 | True |
pleuraleff_ceterm | varchar | 0 | 0 | 1000 | True |
pneumothorax_ceterm | varchar | 0 | 0 | 1000 | True |
postpart_rptestcd | varchar | 0 | 0 | 1000 | True |
postpart_rptestcd_out | varchar | 0 | 0 | 1000 | True |
preadmission_treatment_complete | varchar | 0 | 0 | 1000 | True |
pregout_rptestcd | varchar | 0 | 0 | 1000 | True |
pregout_rptestcd_out | varchar | 0 | 0 | 1000 | True |
pregyn_rptestcd | varchar | 0 | 0 | 1000 | True |
prev_subjid | varchar | 0 | 0 | 1000 | True |
prev_subjid_nk | varchar | 0 | 0 | 1000 | True |
pronevent_prtrt | varchar | 0 | 0 | 1000 | True |
pulmthromb_ceterm | varchar | 0 | 0 | 1000 | True |
rash_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
rash_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
readm_cov19 | varchar | 0 | 0 | 1000 | True |
readminreas | varchar | 0 | 0 | 1000 | True |
readminreasnk | varchar | 0 | 0 | 1000 | True |
reason_for_withdrawal | varchar | 0 | 0 | 1000 | True |
recruitment | varchar | 0 | 0 | 1000 | True |
reinf_antigen | varchar | 0 | 0 | 1000 | True |
reinf_antigend | varchar | 0 | 0 | 1000 | True |
reinf_asymptomatic | varchar | 0 | 0 | 1000 | True |
reinf_cestdat | varchar | 0 | 0 | 1000 | True |
reinf_pcr | varchar | 0 | 0 | 1000 | True |
reinf_pcrd | varchar | 0 | 0 | 1000 | True |
reinf_pre_adm_hosp | varchar | 0 | 0 | 1000 | True |
reinf_pre_casiriv | varchar | 0 | 0 | 1000 | True |
reinf_pre_chloro_hchlo | varchar | 0 | 0 | 1000 | True |
reinf_pre_conv_plasma | varchar | 0 | 0 | 1000 | True |
reinf_pre_dexameth | varchar | 0 | 0 | 1000 | True |
reinf_pre_ecmo | varchar | 0 | 0 | 1000 | True |
reinf_pre_hdu_icu | varchar | 0 | 0 | 1000 | True |
reinf_pre_interferon | varchar | 0 | 0 | 1000 | True |
reinf_pre_inv_vent | varchar | 0 | 0 | 1000 | True |
reinf_pre_lopin_riton | varchar | 0 | 0 | 1000 | True |
reinf_pre_oxygen | varchar | 0 | 0 | 1000 | True |
reinf_pre_remdesivir | varchar | 0 | 0 | 1000 | True |
reinf_pre_steroid | varchar | 0 | 0 | 1000 | True |
reinf_pre_tociliz | varchar | 0 | 0 | 1000 | True |
reinf_prev_enrol | varchar | 0 | 0 | 1000 | True |
reinf_serology | varchar | 0 | 0 | 1000 | True |
reinf_serologyd | varchar | 0 | 0 | 1000 | True |
reinf_treat_none | varchar | 0 | 0 | 1000 | True |
reinfection_form_complete | varchar | 0 | 0 | 1000 | True |
remdes_cmtrt_first | varchar | 0 | 0 | 1000 | True |
remdes_cmtrt_last | varchar | 0 | 0 | 1000 | True |
remdesivir.day1 | varchar | 0 | 0 | 1000 | True |
remdesivir.disch | varchar | 0 | 0 | 1000 | True |
remdesivir_day.day1 | varchar | 0 | 0 | 1000 | True |
remdesivir_day.disch | varchar | 0 | 0 | 1000 | True |
remdesivir_last_dose.day1 | varchar | 0 | 0 | 1000 | True |
remdesivir_last_dose.disch | varchar | 0 | 0 | 1000 | True |
renal_mhyn | varchar | 0 | 0 | 1000 | True |
renal_proccur | varchar | 0 | 0 | 1000 | True |
renalinjury_ceterm | varchar | 0 | 0 | 1000 | True |
research_samples_complete | varchar | 0 | 0 | 1000 | True |
rhabdomyolsis_ceterm | varchar | 0 | 0 | 1000 | True |
rheumatologic_mhyn | varchar | 0 | 0 | 1000 | True |
rr_vsorres | varchar | 0 | 0 | 1000 | True |
rr_vsyn | varchar | 0 | 0 | 1000 | True |
rrt_prtrt | varchar | 0 | 0 | 1000 | True |
rrt_still_on | varchar | 0 | 0 | 1000 | True |
rrt_totdur | varchar | 0 | 0 | 1000 | True |
rsv_mbcat | varchar | 0 | 0 | 1000 | True |
rsv_mbcat_v2 | varchar | 0 | 0 | 1000 | True |
runnynose_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
runnynose_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
sample_date | varchar | 0 | 0 | 1000 | True |
sample_kit | varchar | 0 | 0 | 1000 | True |
sample_obtained | varchar | 0 | 0 | 1000 | True |
seizure_ceterm | varchar | 0 | 0 | 1000 | True |
seizures_cecoccur_v2 | varchar | 0 | 0 | 1000 | True |
seizures_cecoccur_v3 | varchar | 0 | 0 | 1000 | True |
sex | varchar | 0 | 0 | 1000 | True |
shortbreath_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
shortbreath_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
site_type | varchar | 0 | 0 | 1000 | True |
siteid | varchar | 0 | 0 | 1000 | True |
siteid_transfernk | varchar | 0 | 0 | 1000 | True |
siteid_v2 | varchar | 0 | 0 | 1000 | True |
siteid_v2_nk | varchar | 0 | 0 | 1000 | True |
siteidnk | varchar | 0 | 0 | 1000 | True |
siteyn | varchar | 0 | 0 | 1000 | True |
siteyn_v2 | varchar | 0 | 0 | 1000 | True |
siteyn_v3 | varchar | 0 | 0 | 1000 | True |
skinulcers_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
skinulcers_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
smoking_mhyn | varchar | 0 | 0 | 1000 | True |
smoking_mhyn_2levels | varchar | 0 | 0 | 1000 | True |
sorethroat_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
sorethroat_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
status | varchar | 0 | 0 | 1000 | True |
stercap_vsorres | varchar | 0 | 0 | 1000 | True |
stercap_vsyn | varchar | 0 | 0 | 1000 | True |
stroke_ceterm | varchar | 0 | 0 | 1000 | True |
study_1_id | varchar | 0 | 0 | 1000 | True |
study_1_name | varchar | 0 | 0 | 1000 | True |
study_2 | varchar | 0 | 0 | 1000 | True |
study_2_id | varchar | 0 | 0 | 1000 | True |
study_2_name | varchar | 0 | 0 | 1000 | True |
study_3 | varchar | 0 | 0 | 1000 | True |
study_3_id | varchar | 0 | 0 | 1000 | True |
study_3_name | varchar | 0 | 0 | 1000 | True |
study_participation_complete | varchar | 0 | 0 | 1000 | True |
subjid_transfer | varchar | 0 | 0 | 1000 | True |
subjidcat | varchar | 0 | 0 | 1000 | True |
subjidcat_transfer | varchar | 0 | 0 | 1000 | True |
subjidcat_v2 | varchar | 0 | 0 | 1000 | True |
suppds_qval | varchar | 0 | 0 | 1000 | True |
suppds_qval_v2 | varchar | 0 | 0 | 1000 | True |
supper_trcity | varchar | 0 | 0 | 1000 | True |
supper_trcity_2 | varchar | 0 | 0 | 1000 | True |
supper_trcntry | varchar | 0 | 0 | 1000 | True |
supper_trcntry_2 | varchar | 0 | 0 | 1000 | True |
surgefacil | varchar | 0 | 0 | 1000 | True |
susp_reinf | varchar | 0 | 0 | 1000 | True |
symptoms_epi_animal | varchar | 0 | 0 | 1000 | True |
symptoms_epi_healthfac | varchar | 0 | 0 | 1000 | True |
symptoms_epi_lab | varchar | 0 | 0 | 1000 | True |
symptoms_epi_pathogen | varchar | 0 | 0 | 1000 | True |
symptoms_epi_physical | varchar | 0 | 0 | 1000 | True |
symptoms_epi_travel | varchar | 0 | 0 | 1000 | True |
sysbp_vsorres | varchar | 0 | 0 | 1000 | True |
sysbp_vsyn | varchar | 0 | 0 | 1000 | True |
systolic_vsorres.day1 | varchar | 0 | 0 | 1000 | True |
systolic_vsorres.disch | varchar | 0 | 0 | 1000 | True |
systolic_vsyn.day1 | varchar | 0 | 0 | 1000 | True |
systolic_vsyn.disch | varchar | 0 | 0 | 1000 | True |
temp_vsorres | varchar | 0 | 0 | 1000 | True |
temp_vsorresu | varchar | 0 | 0 | 1000 | True |
temp_vsyn | varchar | 0 | 0 | 1000 | True |
tiers_consent_complete | varchar | 0 | 0 | 1000 | True |
tiers_faorres___1 | varchar | 0 | 0 | 1000 | True |
tiers_faorres___2 | varchar | 0 | 0 | 1000 | True |
tiers_faorres___3 | varchar | 0 | 0 | 1000 | True |
tracheo_prtrt | varchar | 0 | 0 | 1000 | True |
transfer_subjid | varchar | 0 | 0 | 1000 | True |
travel_erterm | varchar | 0 | 0 | 1000 | True |
travel_erterm_2 | varchar | 0 | 0 | 1000 | True |
treatment_complete | varchar | 0 | 0 | 1000 | True |
vaccine_covid_trial | varchar | 0 | 0 | 1000 | True |
vaccine_covid_triald | varchar | 0 | 0 | 1000 | True |
version_9_7 | varchar | 0 | 0 | 1000 | True |
vomit_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
vomit_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
vrialpneu_ceoccur | varchar | 0 | 0 | 1000 | True |
vulnerable_cancers | varchar | 0 | 0 | 1000 | True |
vulnerable_copd | varchar | 0 | 0 | 1000 | True |
vulnerable_immuno | varchar | 0 | 0 | 1000 | True |
vulnerable_no_nk | varchar | 0 | 0 | 1000 | True |
vulnerable_preg | varchar | 0 | 0 | 1000 | True |
vulnerable_scid | varchar | 0 | 0 | 1000 | True |
vulnerable_transplant | varchar | 0 | 0 | 1000 | True |
wheeze_ceoccur_v2 | varchar | 0 | 0 | 1000 | True |
wheeze_ceoccur_v3 | varchar | 0 | 0 | 1000 | True |
withddat | varchar | 0 | 0 | 1000 | True |
withdrawal_form_complete | varchar | 0 | 0 | 1000 | True |
withdreas | varchar | 0 | 0 | 1000 | True |
withdtype | varchar | 0 | 0 | 1000 | True |
xray_prperf.day1 | varchar | 0 | 0 | 1000 | True |
xray_prperf.disch | varchar | 0 | 0 | 1000 | True |
NHSD_HIGH_COST_DRUGS¶
HighCostDrugs¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
ActivityTreatmentFunctionCode | varchar | 0 | 0 | 100 | True |
DerivedSNOMEDFromName | varchar | 0 | 0 | 1000 | True |
DerivedVTM | varchar | 0 | 0 | 1000 | True |
DerivedVTMName | varchar | 0 | 0 | 1000 | True |
DispensingRoute | varchar | 0 | 0 | 100 | True |
DrugName | varchar | 0 | 0 | 1000 | True |
DrugPackSize | varchar | 0 | 0 | 1000 | True |
DrugQuanitityOrWeightProportion | varchar | 0 | 0 | 1000 | True |
DrugStrength | varchar | 0 | 0 | 1000 | True |
DrugVolume | varchar | 0 | 0 | 1000 | True |
FinancialMonth | varchar | 0 | 0 | 2 | True |
FinancialYear | varchar | 0 | 0 | 6 | True |
HighCostTariffExcludedDrugCode | varchar | 0 | 0 | 100 | True |
HomeDeliveryCharge | varchar | 0 | 0 | 100 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
PersonAge | int | 10 | 0 | 4 | True |
PersonGender | int | 10 | 0 | 4 | True |
RouteOfAdministration | varchar | 0 | 0 | 100 | True |
TherapeuticIndicationCode | varchar | 0 | 0 | 1000 | True |
TotalCost | varchar | 0 | 0 | 100 | True |
UnitOfMeasurement | varchar | 0 | 0 | 100 | True |
NHSE_APCS¶
APCS¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Administrative_Category | varchar | 0 | 0 | 2 | True |
Admission_Date | date | 10 | 0 | 3 | True |
Admission_Method | varchar | 0 | 0 | 2 | True |
APCS_Ident | bigint | 19 | 0 | 8 | False |
Carer_Support_Indicator | varchar | 0 | 0 | 1000 | True |
Der_Activity_Month | varchar | 0 | 0 | 6 | True |
Der_Admit_Treatment_Function_Code | varchar | 0 | 0 | 3 | True |
Der_Diagnosis_All | varchar | 0 | 0 | 4000 | True |
Der_Diagnosis_Count | int | 10 | 0 | 4 | True |
Der_Dischg_Treatment_Function_Code | varchar | 0 | 0 | 3 | True |
Der_Financial_Year | varchar | 0 | 0 | 7 | True |
Der_Procedure_All | varchar | 0 | 0 | 4000 | True |
Der_Procedure_Count | int | 10 | 0 | 4 | True |
Der_Pseudo_Patient_Pathway_ID | bigint | 19 | 0 | 8 | True |
Der_Spell_LoS | int | 10 | 0 | 4 | True |
Discharge_Date | date | 10 | 0 | 3 | True |
Discharge_Destination | varchar | 0 | 0 | 2 | True |
Discharge_Method | varchar | 0 | 0 | 2 | True |
Duration_of_Elective_Wait | int | 10 | 0 | 4 | True |
Ethnic_Group | varchar | 0 | 0 | 2 | True |
Hospital_Spell_Duration | int | 10 | 0 | 4 | True |
Patient_Classification | varchar | 0 | 0 | 2 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Provider_Org_Code_Type | varchar | 0 | 0 | 5 | True |
Source_of_Admission | varchar | 0 | 0 | 2 | True |
Spell_Core_HRG_SUS | varchar | 0 | 0 | 10 | True |
Spell_HRG_Version_No_SUS | varchar | 0 | 0 | 20 | True |
APCS_Cost¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
APCS_Ident | bigint | 19 | 0 | 8 | False |
Grand_Total_Payment_MFF | real | 24 | 0 | 4 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Tariff_Initial_Amount | real | 24 | 0 | 4 | True |
Tariff_Total_Payment | real | 24 | 0 | 4 | True |
APCS_Der¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
APCS_Ident | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Spell_Dominant_Procedure | varchar | 0 | 0 | 100 | True |
Spell_LoS | varchar | 0 | 0 | 5 | True |
Spell_Main_Specialty_Code | varchar | 0 | 0 | 3 | True |
Spell_PbR_CC_Day | varchar | 0 | 0 | 4 | True |
Spell_PbR_Rehab_Days | varchar | 0 | 0 | 4 | True |
Spell_Primary_Diagnosis | varchar | 0 | 0 | 5 | True |
Spell_RE30_Admit_Type | varchar | 0 | 0 | 1 | True |
Spell_RE30_Indicator | varchar | 0 | 0 | 1 | True |
Spell_Secondary_Diagnosis | varchar | 0 | 0 | 5 | True |
Spell_Treatment_Function_Code | varchar | 0 | 0 | 3 | True |
NHSE_CPNS¶
CPNS¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Age | int | 10 | 0 | 4 | True |
CovidTestResult | varchar | 0 | 0 | 100 | True |
DateOfAdmission | date | 10 | 0 | 3 | True |
DateOfDeath | date | 10 | 0 | 3 | True |
DateOfResult | date | 10 | 0 | 3 | True |
DateOfSwabbed | date | 10 | 0 | 3 | True |
Der_Ethnic_Category_Description | varchar | 0 | 0 | 100 | True |
Der_Latest_SUS_Attendance_Date_For_Ethnicity | varchar | 0 | 0 | 100 | True |
Der_Source_Dataset_For_Ethnicty | varchar | 0 | 0 | 100 | True |
DetainedUnderMHAct | bit | 1 | 0 | 1 | True |
HadLearningDisability | varchar | 0 | 0 | 10 | True |
Id | bigint | 19 | 0 | 8 | False |
LearningDisabilityType | varchar | 0 | 0 | 100 | True |
LocationOfDeath | varchar | 0 | 0 | 1000 | True |
NationalApproved | varchar | 0 | 0 | 10 | True |
NationalApprovedDate | date | 10 | 0 | 3 | True |
NHSworker | bit | 1 | 0 | 1 | True |
OnDeathCertificateNotice | bit | 1 | 0 | 1 | True |
OrganisationTypeLot | varchar | 0 | 0 | 100 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
PreExistingCondition | varchar | 0 | 0 | 10 | True |
PreExistingConditionList | varchar | 0 | 0 | 4000 | True |
ReceivedTreatmentForMentalHealth | varchar | 0 | 0 | 100 | True |
RegionalApprovedDate | date | 10 | 0 | 3 | True |
RegionApproved | varchar | 0 | 0 | 10 | True |
RegionCode | varchar | 0 | 0 | 10 | True |
RegionName | varchar | 0 | 0 | 100 | True |
RelativesAware | varchar | 0 | 0 | 100 | True |
Sex | varchar | 0 | 0 | 5 | True |
snapDate | date | 10 | 0 | 3 | True |
TransferredFromAMentalHealthSetting | bit | 1 | 0 | 1 | True |
TransferredFromLearningDisabilityAutismSetting | bit | 1 | 0 | 1 | True |
TravelHistory | varchar | 0 | 0 | 10 | True |
NHSE_EC¶
EC¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Arrival_Date | date | 10 | 0 | 3 | True |
Arrival_Time | time | 16 | 7 | 5 | True |
Decision_To_Admit_Treatment_Function_Code | varchar | 0 | 0 | 3 | True |
Der_Activity_Month | varchar | 0 | 0 | 6 | True |
Der_EC_Diagnosis_All | varchar | 0 | 0 | 4000 | True |
Der_EC_Investigation_All | varchar | 0 | 0 | 4000 | True |
Der_EC_Treatment_All | varchar | 0 | 0 | 4000 | True |
Der_Financial_Year | varchar | 0 | 0 | 7 | True |
Discharge_Destination_SNOMED_CT | varchar | 0 | 0 | 20 | True |
DQ_Chief_Complaint_Completed | varchar | 0 | 0 | 5 | True |
DQ_Chief_Complaint_Expected | varchar | 0 | 0 | 5 | True |
DQ_Chief_Complaint_Valid | varchar | 0 | 0 | 5 | True |
DQ_Primary_Diagnosis_Completed | varchar | 0 | 0 | 5 | True |
DQ_Primary_Diagnosis_Expected | varchar | 0 | 0 | 5 | True |
DQ_Primary_Diagnosis_Valid | varchar | 0 | 0 | 5 | True |
EC_Arrival_Mode_SNOMED_CT | varchar | 0 | 0 | 20 | True |
EC_Attendance_Source_SNOMED_CT | varchar | 0 | 0 | 20 | True |
EC_AttendanceCategory | varchar | 0 | 0 | 1 | True |
EC_Chief_Complaint_SNOMED_CT | varchar | 0 | 0 | 20 | True |
EC_Decision_To_Admit_Date | date | 10 | 0 | 3 | True |
EC_Department_Type | varchar | 0 | 0 | 2 | True |
EC_Ident | bigint | 19 | 0 | 8 | False |
EC_Injury_Date | date | 10 | 0 | 3 | True |
Ethnic_Category | varchar | 0 | 0 | 1 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
SUS_Final_Price | varchar | 0 | 0 | 5 | True |
SUS_HRG_Code | varchar | 0 | 0 | 5 | True |
SUS_Tariff | varchar | 0 | 0 | 5 | True |
EC_AlcoholDrugInvolvement¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
EC_Alcohol_Drug_Involvement_01 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_02 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_03 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_04 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_05 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_06 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_07 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_08 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_09 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_10 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_11 | varchar | 0 | 0 | 20 | True |
EC_Alcohol_Drug_Involvement_12 | varchar | 0 | 0 | 20 | True |
EC_Ident | bigint | 19 | 0 | 8 | False |
Is_Code_Approved_01 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_02 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_03 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_04 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_05 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_06 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_07 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_08 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_09 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_10 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_11 | varchar | 0 | 0 | 5 | True |
Is_Code_Approved_12 | varchar | 0 | 0 | 5 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
EC_Comorbidities¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Comorbidity_01 | varchar | 0 | 0 | 20 | True |
Comorbidity_02 | varchar | 0 | 0 | 20 | True |
Comorbidity_03 | varchar | 0 | 0 | 20 | True |
Comorbidity_04 | varchar | 0 | 0 | 20 | True |
Comorbidity_05 | varchar | 0 | 0 | 20 | True |
Comorbidity_06 | varchar | 0 | 0 | 20 | True |
Comorbidity_07 | varchar | 0 | 0 | 20 | True |
Comorbidity_08 | varchar | 0 | 0 | 20 | True |
Comorbidity_09 | varchar | 0 | 0 | 20 | True |
Comorbidity_10 | varchar | 0 | 0 | 20 | True |
Comorbidity_11 | varchar | 0 | 0 | 20 | True |
Comorbidity_12 | varchar | 0 | 0 | 20 | True |
Comorbidity_13 | varchar | 0 | 0 | 20 | True |
Comorbidity_14 | varchar | 0 | 0 | 20 | True |
Comorbidity_15 | varchar | 0 | 0 | 20 | True |
Comorbidity_16 | varchar | 0 | 0 | 20 | True |
Comorbidity_17 | varchar | 0 | 0 | 20 | True |
Comorbidity_18 | varchar | 0 | 0 | 20 | True |
Comorbidity_19 | varchar | 0 | 0 | 20 | True |
Comorbidity_20 | varchar | 0 | 0 | 20 | True |
Comorbidity_21 | varchar | 0 | 0 | 20 | True |
Comorbidity_22 | varchar | 0 | 0 | 20 | True |
Comorbidity_23 | varchar | 0 | 0 | 20 | True |
Comorbidity_24 | varchar | 0 | 0 | 20 | True |
EC_Ident | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
EC_Cost¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
EC_Ident | bigint | 19 | 0 | 8 | False |
Grand_Total_Payment_MFF | real | 24 | 0 | 4 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Tariff_Total_Payment | real | 24 | 0 | 4 | True |
EC_Diagnosis¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
AEA_Diagnosis_01 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_02 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_03 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_04 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_05 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_06 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_07 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_08 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_09 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_10 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_11 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_12 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_13 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_14 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_15 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_16 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_17 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_18 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_19 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_20 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_21 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_22 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_23 | varchar | 0 | 0 | 100 | True |
AEA_Diagnosis_24 | varchar | 0 | 0 | 100 | True |
EC_Chief_Complaint_SNOMED_CT | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_01 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_02 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_03 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_04 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_05 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_06 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_07 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_08 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_09 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_10 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_11 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_12 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_13 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_14 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_15 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_16 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_17 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_18 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_19 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_20 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_21 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_22 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_23 | varchar | 0 | 0 | 20 | True |
EC_Diagnosis_24 | varchar | 0 | 0 | 20 | True |
EC_Ident | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
EC_Investigation¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
AEA_Investigation_01 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_02 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_03 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_04 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_05 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_06 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_07 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_08 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_09 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_10 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_11 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_12 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_13 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_14 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_15 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_16 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_17 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_18 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_19 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_20 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_21 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_22 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_23 | varchar | 0 | 0 | 20 | True |
AEA_Investigation_24 | varchar | 0 | 0 | 20 | True |
EC_Ident | bigint | 19 | 0 | 8 | False |
EC_Investigation_01 | varchar | 0 | 0 | 20 | True |
EC_Investigation_02 | varchar | 0 | 0 | 20 | True |
EC_Investigation_03 | varchar | 0 | 0 | 20 | True |
EC_Investigation_04 | varchar | 0 | 0 | 20 | True |
EC_Investigation_05 | varchar | 0 | 0 | 20 | True |
EC_Investigation_06 | varchar | 0 | 0 | 20 | True |
EC_Investigation_07 | varchar | 0 | 0 | 20 | True |
EC_Investigation_08 | varchar | 0 | 0 | 20 | True |
EC_Investigation_09 | varchar | 0 | 0 | 20 | True |
EC_Investigation_10 | varchar | 0 | 0 | 20 | True |
EC_Investigation_11 | varchar | 0 | 0 | 20 | True |
EC_Investigation_12 | varchar | 0 | 0 | 20 | True |
EC_Investigation_13 | varchar | 0 | 0 | 20 | True |
EC_Investigation_14 | varchar | 0 | 0 | 20 | True |
EC_Investigation_15 | varchar | 0 | 0 | 20 | True |
EC_Investigation_16 | varchar | 0 | 0 | 20 | True |
EC_Investigation_17 | varchar | 0 | 0 | 20 | True |
EC_Investigation_18 | varchar | 0 | 0 | 20 | True |
EC_Investigation_19 | varchar | 0 | 0 | 20 | True |
EC_Investigation_20 | varchar | 0 | 0 | 20 | True |
EC_Investigation_21 | varchar | 0 | 0 | 20 | True |
EC_Investigation_22 | varchar | 0 | 0 | 20 | True |
EC_Investigation_23 | varchar | 0 | 0 | 20 | True |
EC_Investigation_24 | varchar | 0 | 0 | 20 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
EC_PatientMentalHealth¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
EC_Ident | bigint | 19 | 0 | 8 | False |
MH_Classification_01 | varchar | 0 | 0 | 20 | True |
MH_Classification_010 | varchar | 0 | 0 | 20 | True |
MH_Classification_011 | varchar | 0 | 0 | 20 | True |
MH_Classification_012 | varchar | 0 | 0 | 20 | True |
MH_Classification_013 | varchar | 0 | 0 | 20 | True |
MH_Classification_014 | varchar | 0 | 0 | 20 | True |
MH_Classification_015 | varchar | 0 | 0 | 20 | True |
MH_Classification_016 | varchar | 0 | 0 | 20 | True |
MH_Classification_017 | varchar | 0 | 0 | 20 | True |
MH_Classification_018 | varchar | 0 | 0 | 20 | True |
MH_Classification_019 | varchar | 0 | 0 | 20 | True |
MH_Classification_02 | varchar | 0 | 0 | 20 | True |
MH_Classification_03 | varchar | 0 | 0 | 20 | True |
MH_Classification_04 | varchar | 0 | 0 | 20 | True |
MH_Classification_05 | varchar | 0 | 0 | 20 | True |
MH_Classification_06 | varchar | 0 | 0 | 20 | True |
MH_Classification_07 | varchar | 0 | 0 | 20 | True |
MH_Classification_08 | varchar | 0 | 0 | 20 | True |
MH_Classification_09 | varchar | 0 | 0 | 20 | True |
MH_Classification_20 | varchar | 0 | 0 | 20 | True |
MH_Classification_21 | varchar | 0 | 0 | 20 | True |
MH_Classification_22 | varchar | 0 | 0 | 20 | True |
MH_Classification_23 | varchar | 0 | 0 | 20 | True |
MH_Classification_24 | varchar | 0 | 0 | 20 | True |
MH_Expiry_Date_01 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_010 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_011 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_012 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_013 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_014 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_015 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_016 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_017 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_018 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_019 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_02 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_03 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_04 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_05 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_06 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_07 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_08 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_09 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_20 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_21 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_22 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_23 | date | 10 | 0 | 3 | True |
MH_Expiry_Date_24 | date | 10 | 0 | 3 | True |
MH_Start_Date_01 | date | 10 | 0 | 3 | True |
MH_Start_Date_010 | date | 10 | 0 | 3 | True |
MH_Start_Date_011 | date | 10 | 0 | 3 | True |
MH_Start_Date_012 | date | 10 | 0 | 3 | True |
MH_Start_Date_013 | date | 10 | 0 | 3 | True |
MH_Start_Date_014 | date | 10 | 0 | 3 | True |
MH_Start_Date_015 | date | 10 | 0 | 3 | True |
MH_Start_Date_016 | date | 10 | 0 | 3 | True |
MH_Start_Date_017 | date | 10 | 0 | 3 | True |
MH_Start_Date_018 | date | 10 | 0 | 3 | True |
MH_Start_Date_019 | date | 10 | 0 | 3 | True |
MH_Start_Date_02 | date | 10 | 0 | 3 | True |
MH_Start_Date_03 | date | 10 | 0 | 3 | True |
MH_Start_Date_04 | date | 10 | 0 | 3 | True |
MH_Start_Date_05 | date | 10 | 0 | 3 | True |
MH_Start_Date_06 | date | 10 | 0 | 3 | True |
MH_Start_Date_07 | date | 10 | 0 | 3 | True |
MH_Start_Date_08 | date | 10 | 0 | 3 | True |
MH_Start_Date_09 | date | 10 | 0 | 3 | True |
MH_Start_Date_20 | date | 10 | 0 | 3 | True |
MH_Start_Date_21 | date | 10 | 0 | 3 | True |
MH_Start_Date_22 | date | 10 | 0 | 3 | True |
MH_Start_Date_23 | date | 10 | 0 | 3 | True |
MH_Start_Date_24 | date | 10 | 0 | 3 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
EC_Treatment¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
AEA_Treatment_01 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_02 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_03 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_04 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_05 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_06 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_07 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_08 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_09 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_10 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_11 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_12 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_13 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_14 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_15 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_16 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_17 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_18 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_19 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_20 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_21 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_22 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_23 | varchar | 0 | 0 | 20 | True |
AEA_Treatment_24 | varchar | 0 | 0 | 20 | True |
EC_Ident | bigint | 19 | 0 | 8 | False |
EC_Treatment_01 | varchar | 0 | 0 | 20 | True |
EC_Treatment_02 | varchar | 0 | 0 | 20 | True |
EC_Treatment_03 | varchar | 0 | 0 | 20 | True |
EC_Treatment_04 | varchar | 0 | 0 | 20 | True |
EC_Treatment_05 | varchar | 0 | 0 | 20 | True |
EC_Treatment_06 | varchar | 0 | 0 | 20 | True |
EC_Treatment_07 | varchar | 0 | 0 | 20 | True |
EC_Treatment_08 | varchar | 0 | 0 | 20 | True |
EC_Treatment_09 | varchar | 0 | 0 | 20 | True |
EC_Treatment_10 | varchar | 0 | 0 | 20 | True |
EC_Treatment_11 | varchar | 0 | 0 | 20 | True |
EC_Treatment_12 | varchar | 0 | 0 | 20 | True |
EC_Treatment_13 | varchar | 0 | 0 | 20 | True |
EC_Treatment_14 | varchar | 0 | 0 | 20 | True |
EC_Treatment_15 | varchar | 0 | 0 | 20 | True |
EC_Treatment_16 | varchar | 0 | 0 | 20 | True |
EC_Treatment_17 | varchar | 0 | 0 | 20 | True |
EC_Treatment_18 | varchar | 0 | 0 | 20 | True |
EC_Treatment_19 | varchar | 0 | 0 | 20 | True |
EC_Treatment_20 | varchar | 0 | 0 | 20 | True |
EC_Treatment_21 | varchar | 0 | 0 | 20 | True |
EC_Treatment_22 | varchar | 0 | 0 | 20 | True |
EC_Treatment_23 | varchar | 0 | 0 | 20 | True |
EC_Treatment_24 | varchar | 0 | 0 | 20 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
NHSE_ECDS¶
ECDS¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Accessible_Information_Professional_Required_Code_Approved | varchar | 0 | 0 | 5 | True |
Accessible_Information_Professional_Required_SNOMED_CT | varchar | 0 | 0 | 18 | True |
Accommodation_Status_Code_Approved | varchar | 0 | 0 | 5 | True |
Accommodation_Status_SNOMED_CT | varchar | 0 | 0 | 18 | True |
Age_At_Arrival | bigint | 19 | 0 | 8 | True |
Age_at_CDS_Activity_Date | bigint | 19 | 0 | 8 | True |
Age_Range | varchar | 0 | 0 | 5 | True |
Arrival_Date | datetime | 23 | 3 | 8 | True |
Arrival_Mode_Approved | varchar | 0 | 0 | 5 | True |
Arrival_Month | bigint | 19 | 0 | 8 | True |
Arrival_Planned | varchar | 0 | 0 | 5 | True |
Arrival_Time | varchar | 0 | 0 | 8 | True |
Attendance_Source_Organisation | varchar | 0 | 0 | 9 | True |
Cancer_Registry | varchar | 0 | 0 | 5 | True |
CDS_Activity_Date | date | 10 | 0 | 3 | True |
CDS_Group_Indicator | bigint | 19 | 0 | 8 | True |
CDS_Interchange_Sender_Identity | varchar | 0 | 0 | 12 | True |
CDS_Prime_Recipient_Identity | varchar | 0 | 0 | 12 | True |
CDS_Type | varchar | 0 | 0 | 3 | True |
Clinical_Acuity_Code_Approved | varchar | 0 | 0 | 5 | True |
Clinical_Chief_Complaint_Code_Approved | varchar | 0 | 0 | 5 | True |
Clinical_Chief_Complaint_Extended_Code | varchar | 0 | 0 | 18 | True |
Clinical_Chief_Complaint_Injury_Related | varchar | 0 | 0 | 5 | True |
Clinical_Disease_Notification | varchar | 0 | 0 | 50 | True |
Clinical_Injury_Activity_Status_Code_Approved | varchar | 0 | 0 | 5 | True |
Clinical_Injury_Activity_Type_Code_Approved | varchar | 0 | 0 | 5 | True |
Clinical_Injury_Intent_Code_Approved | varchar | 0 | 0 | 5 | True |
Clinical_Injury_Place_Type_Approved | varchar | 0 | 0 | 5 | True |
Clinical_Trial_Code | varchar | 0 | 0 | 50 | True |
Commissioner_Code | varchar | 0 | 0 | 12 | True |
Decision_To_Admit_Receiving_Site | varchar | 0 | 0 | 9 | True |
Decision_To_Admit_Treatment_Function_Code | varchar | 0 | 0 | 8 | True |
Der_Activity_Month | varchar | 0 | 0 | 6 | True |
Der_AEA_Diagnosis_All | varchar | 0 | 0 | 200 | True |
Der_AEA_Investigation_All | varchar | 0 | 0 | 200 | True |
Der_AEA_Patient_Group | varchar | 0 | 0 | 2 | True |
Der_AEA_Treatment_All | varchar | 0 | 0 | 200 | True |
Der_Age_At_CDS_Activity_Date | int | 10 | 0 | 4 | True |
Der_Commissioner_Code | varchar | 0 | 0 | 5 | True |
Der_Dupe_Flag | int | 10 | 0 | 4 | True |
Der_EC_Arrival_Date_Time | datetime | 23 | 3 | 8 | True |
Der_EC_Departure_Date_Time | datetime | 23 | 3 | 8 | True |
Der_EC_Diagnosis_All | varchar | 0 | 0 | 500 | True |
Der_EC_Duration | int | 10 | 0 | 4 | True |
Der_EC_Investigation_All | varchar | 0 | 0 | 500 | True |
Der_EC_Treatment_All | varchar | 0 | 0 | 500 | True |
Der_Financial_Year | varchar | 0 | 0 | 7 | False |
Der_Number_AEA_Diagnosis | int | 10 | 0 | 4 | True |
Der_Number_AEA_Investigation | int | 10 | 0 | 4 | True |
Der_Number_AEA_Treatment | int | 10 | 0 | 4 | True |
Der_Number_EC_Diagnosis | int | 10 | 0 | 4 | True |
Der_Number_EC_Investigation | int | 10 | 0 | 4 | True |
Der_Number_EC_Treatment | int | 10 | 0 | 4 | True |
Der_Provider_Code | varchar | 0 | 0 | 5 | True |
Der_Provider_Site_Code | varchar | 0 | 0 | 5 | True |
Der_Record_Type | varchar | 0 | 0 | 4 | True |
Discharge_Destination_SNOMED_CT | varchar | 0 | 0 | 18 | True |
Discharge_Follow_Up_Approved | varchar | 0 | 0 | 5 | True |
Discharge_Follow_Up_SNOMED_CT | varchar | 0 | 0 | 18 | True |
Discharge_Information_Given_Approved | varchar | 0 | 0 | 5 | True |
Discharge_Information_Given_SNOMED_CT | varchar | 0 | 0 | 18 | True |
DischargeDestinationApproved | varchar | 0 | 0 | 5 | True |
DQ_Chief_Complaint_Completed | varchar | 0 | 0 | 5 | True |
DQ_Chief_Complaint_Expected | varchar | 0 | 0 | 5 | True |
DQ_Chief_Complaint_Valid | varchar | 0 | 0 | 5 | True |
DQ_Primary_Diagnosis_Completed | varchar | 0 | 0 | 5 | True |
DQ_Primary_Diagnosis_Expected | varchar | 0 | 0 | 5 | True |
DQ_Primary_Diagnosis_Valid | varchar | 0 | 0 | 5 | True |
EC_Acuity_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Arrival_Mode_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Attendance_Source_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_AttendanceCategory | varchar | 0 | 0 | 1 | True |
EC_Chief_Complaint_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Conclusion_Date | date | 10 | 0 | 3 | True |
EC_Conclusion_Time | varchar | 0 | 0 | 8 | True |
EC_Conclusion_Time_Since_Arrival | bigint | 19 | 0 | 8 | True |
EC_Decision_To_Admit_Date | date | 10 | 0 | 3 | True |
EC_Decision_To_Admit_Time | varchar | 0 | 0 | 8 | True |
EC_Decision_To_Admit_Time_Since_Arrival | bigint | 19 | 0 | 8 | True |
EC_Department_Type | varchar | 0 | 0 | 2 | True |
EC_Departure_Date | date | 10 | 0 | 3 | True |
EC_Departure_Time | varchar | 0 | 0 | 8 | True |
EC_Departure_Time_Since_Arrival | bigint | 19 | 0 | 8 | True |
EC_Discharge_Status_Approved | varchar | 0 | 0 | 5 | True |
EC_Discharge_Status_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Ident | bigint | 19 | 0 | 8 | True |
EC_Initial_Assessment_Date | date | 10 | 0 | 3 | True |
EC_Initial_Assessment_Time | varchar | 0 | 0 | 8 | True |
EC_Initial_Assessment_Time_Since_Arrival | bigint | 19 | 0 | 8 | True |
EC_Injury_Activity_Status_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Injury_Activity_Type_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Injury_Date | date | 10 | 0 | 3 | True |
EC_Injury_Intent_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Injury_Mechanism_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Injury_Time | varchar | 0 | 0 | 8 | True |
EC_PCD_Indicator | int | 10 | 0 | 4 | True |
EC_Place_Of_Injury_Latitude | varchar | 0 | 0 | 10 | True |
EC_Place_Of_Injury_Longitude | varchar | 0 | 0 | 10 | True |
EC_Place_Of_Injury_SNOMED_CT | varchar | 0 | 0 | 18 | True |
EC_Seen_For_Treatment_Date | date | 10 | 0 | 3 | True |
EC_Seen_For_Treatment_Time | varchar | 0 | 0 | 8 | True |
EC_Seen_For_Treatment_Time_Since_Arrival | bigint | 19 | 0 | 8 | True |
Ethnic_Category | varchar | 0 | 0 | 1 | True |
Exclusions | varchar | 0 | 0 | 100 | True |
Finished_Indicator | bigint | 19 | 0 | 8 | True |
Fractional_Age_At_Arrival | float | 53 | 0 | 8 | True |
HES_Age_At_Arrival | bigint | 19 | 0 | 8 | True |
HES_Age_At_Departure | bigint | 19 | 0 | 8 | True |
Index_Of_Multiple_Deprivation_Decile | varchar | 0 | 0 | 50 | True |
Index_Of_Multiple_Deprivation_Decile_Description | varchar | 0 | 0 | 50 | True |
Interpreter_Language_Code_Approved | varchar | 0 | 0 | 5 | True |
Interpreter_Language_SNOMED_CT | varchar | 0 | 0 | 18 | True |
Month_of_Birth | varchar | 0 | 0 | 2 | True |
NHS_Number_Is_Valid | varchar | 0 | 0 | 5 | True |
NHS_Number_Status_Indicator_Code | varchar | 0 | 0 | 2 | True |
Overseas_Visitor_Charging_Category | varchar | 0 | 0 | 1 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Patient_Type | varchar | 0 | 0 | 4 | True |
Preferred_Spoken_Language_Code_Approved | varchar | 0 | 0 | 5 | True |
Preferred_Spoken_Language_SNOMED_CT | varchar | 0 | 0 | 18 | True |
Provider_Code | varchar | 0 | 0 | 12 | True |
Reason_For_Access | varchar | 0 | 0 | 100 | True |
RTT_Period_End_Date | date | 10 | 0 | 3 | True |
RTT_Period_Length | bigint | 19 | 0 | 8 | True |
RTT_Period_Start_Date | date | 10 | 0 | 3 | True |
RTT_Period_Status | varchar | 0 | 0 | 2 | True |
Rural_Urban_Indicator | varchar | 0 | 0 | 1 | True |
Sex | varchar | 0 | 0 | 5 | True |
Site_Code_of_Treatment | varchar | 0 | 0 | 5 | True |
SNOMED_Version | varchar | 0 | 0 | 6 | True |
SUS_Code_Cleaning_Applied | varchar | 0 | 0 | 5 | True |
SUS_Costing_Period | varchar | 0 | 0 | 20 | True |
SUS_Excluded | varchar | 0 | 0 | 5 | True |
SUS_Final_Price | numeric | 38 | 38 | 9 | True |
SUS_Grouper_Version | varchar | 0 | 0 | 8 | True |
SUS_HRG_Code | varchar | 0 | 0 | 5 | True |
SUS_MFAdjustment | numeric | 38 | 38 | 9 | True |
SUS_MFF | varchar | 0 | 0 | 10 | True |
SUS_Tariff | numeric | 38 | 38 | 9 | True |
SUS_Tariff_Description | varchar | 0 | 0 | 10 | True |
Wait_Time_Measurement_Type | varchar | 0 | 0 | 2 | True |
Withheld_Identity_Reason | varchar | 0 | 0 | 2 | True |
Year_of_Birth | varchar | 0 | 0 | 4 | True |
ECDS_EC_Diagnoses¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
DiagnosisCode | varchar | 0 | 0 | 50 | True |
EC_Ident | bigint | 19 | 0 | 8 | True |
Ordinal | int | 10 | 0 | 4 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
NHSE_HEALTH_CARE_WORKER¶
HealthCareWorker¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
HealthCareWorker | varchar | 0 | 0 | 10 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
NHSE_MPI¶
MPI¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Birth_Month | varchar | 0 | 0 | 10 | True |
Care_Home_Flag | varchar | 0 | 0 | 10 | True |
Data_Source | varchar | 0 | 0 | 100 | True |
Date_Added | date | 10 | 0 | 3 | True |
DateFrom | date | 10 | 0 | 3 | True |
DateTo | date | 10 | 0 | 3 | True |
Death_Month | varchar | 0 | 0 | 10 | True |
Gender | varchar | 0 | 0 | 1 | True |
Latest_Flag | varchar | 0 | 0 | 10 | True |
Living_Alone_Flag | varchar | 0 | 0 | 100 | True |
Living_with_elderly_Flag | varchar | 0 | 0 | 100 | True |
Living_with_young_Flag | varchar | 0 | 0 | 100 | True |
Original_Posting_Date | date | 10 | 0 | 3 | True |
OS_Property_Classification | varchar | 0 | 0 | 100 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
private_outdoor_space | varchar | 0 | 0 | 100 | True |
private_outdoor_space_area | varchar | 0 | 0 | 100 | True |
property_type | varchar | 0 | 0 | 100 | True |
Pseudo_parent_uprn | varchar | 0 | 0 | 200 | True |
Pseudo_uprn | varchar | 0 | 0 | 200 | True |
RP_of_Death | varchar | 0 | 0 | 10 | True |
Rural_Urban_Classification | varchar | 0 | 0 | 100 | True |
ServiceType | varchar | 0 | 0 | 100 | True |
UPRN¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
_0to4 | int | 10 | 0 | 4 | True |
_10to14 | int | 10 | 0 | 4 | True |
_15to19 | int | 10 | 0 | 4 | True |
_20to24 | int | 10 | 0 | 4 | True |
_25to29 | int | 10 | 0 | 4 | True |
_30to34 | int | 10 | 0 | 4 | True |
_40to44 | int | 10 | 0 | 4 | True |
_45to49 | int | 10 | 0 | 4 | True |
_50to54 | int | 10 | 0 | 4 | True |
_55to59 | int | 10 | 0 | 4 | True |
_5to9 | int | 10 | 0 | 4 | True |
_60to64 | int | 10 | 0 | 4 | True |
_65to69 | int | 10 | 0 | 4 | True |
_70to74 | int | 10 | 0 | 4 | True |
_75to79 | int | 10 | 0 | 4 | True |
_80to84 | int | 10 | 0 | 4 | True |
_85Plus | int | 10 | 0 | 4 | True |
Care_Home_Flag | varchar | 0 | 0 | 100 | True |
class | varchar | 0 | 0 | 100 | True |
private_outdoor_space | varchar | 0 | 0 | 100 | True |
private_outdoor_space_area | varchar | 0 | 0 | 100 | True |
property_type | varchar | 0 | 0 | 100 | True |
Pseudo_parent_uprn | varchar | 0 | 0 | 200 | True |
Pseudo_uprn | varchar | 0 | 0 | 200 | True |
Rural_Urban_Classification | varchar | 0 | 0 | 100 | True |
ServiceType | varchar | 0 | 0 | 100 | True |
Total_Pop | int | 10 | 0 | 4 | True |
NHSE_OPA¶
OPA¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Activity_Location_Type_Code | varchar | 0 | 0 | 5 | True |
Administrative_Category | varchar | 0 | 0 | 2 | True |
Appointment_Date | date | 10 | 0 | 3 | True |
Attendance_Status | varchar | 0 | 0 | 2 | True |
Clinic_Code | varchar | 0 | 0 | 100 | True |
Consultation_Medium_Used | varchar | 0 | 0 | 2 | True |
Der_Activity_Month | varchar | 0 | 0 | 100 | True |
Der_Financial_Year | varchar | 0 | 0 | 100 | True |
Ethnic_Category | varchar | 0 | 0 | 2 | True |
First_Attendance | varchar | 0 | 0 | 2 | True |
HRG_Code | varchar | 0 | 0 | 10 | True |
HRG_Version_No | varchar | 0 | 0 | 10 | True |
Main_Specialty_Code | varchar | 0 | 0 | 3 | True |
Medical_Staff_Type_Seeing_Patient | varchar | 0 | 0 | 2 | True |
MultiProf_Ind_Code | varchar | 0 | 0 | 2 | True |
OPA_Ident | bigint | 19 | 0 | 8 | False |
OPA_Referral_Source | varchar | 0 | 0 | 2 | True |
Operation_Status | varchar | 0 | 0 | 2 | True |
Outcome_of_Attendance | varchar | 0 | 0 | 2 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Priority_Type | varchar | 0 | 0 | 2 | True |
Provider_Code | varchar | 0 | 0 | 100 | True |
Provider_Code_Type | varchar | 0 | 0 | 100 | True |
Referral_Request_Received_Date | date | 10 | 0 | 3 | True |
Treatment_Function_Code | varchar | 0 | 0 | 3 | True |
OPA_Cost¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Grand_Total_Payment_MFF | real | 24 | 0 | 4 | True |
OPA_Ident | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Tariff_OPP | real | 24 | 0 | 4 | True |
Tariff_Total_Payment | real | 24 | 0 | 4 | True |
OPA_Diag¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
OPA_Ident | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Primary_Diagnosis_Code | varchar | 0 | 0 | 100 | True |
Primary_Diagnosis_Code_Read | varchar | 0 | 0 | 5 | True |
Secondary_Diagnosis_Code_1 | varchar | 0 | 0 | 100 | True |
Secondary_Diagnosis_Code_1_Read | varchar | 0 | 0 | 5 | True |
OPA_Proc¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
OPA_Ident | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Primary_Procedure_Code | varchar | 0 | 0 | 100 | True |
Primary_Procedure_Code_Read | varchar | 0 | 0 | 5 | True |
Procedure_Code_2 | varchar | 0 | 0 | 100 | True |
Procedure_Code_2_Read | varchar | 0 | 0 | 5 | True |
NHSE_SGSS¶
SGSS_AllTests_Negative¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Age_In_Years | int | 10 | 0 | 4 | True |
County_Description | varchar | 0 | 0 | 50 | True |
Ethnic_Category_Desc | varchar | 0 | 0 | 255 | True |
Lab_Report_Date | date | 10 | 0 | 3 | True |
LFT_Flag | varchar | 0 | 0 | 255 | True |
Organism_Species_Name | varchar | 0 | 0 | 200 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Patient_Sex | varchar | 0 | 0 | 50 | True |
Pillar | varchar | 0 | 0 | 255 | True |
PostCode_Source | varchar | 0 | 0 | 50 | True |
Specimen_Date | date | 10 | 0 | 3 | True |
Symptomatic | varchar | 0 | 0 | 50 | True |
SGSS_AllTests_Positive¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Age_In_Years | int | 10 | 0 | 4 | True |
County_Description | varchar | 0 | 0 | 50 | True |
Ethnic_Category_Desc | varchar | 0 | 0 | 255 | True |
Lab_Report_Date | date | 10 | 0 | 3 | True |
LFT_Flag | varchar | 0 | 0 | 255 | True |
Organism_Species_Name | varchar | 0 | 0 | 200 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Patient_Sex | varchar | 0 | 0 | 50 | True |
Pillar | varchar | 0 | 0 | 255 | True |
PostCode_Source | varchar | 0 | 0 | 50 | True |
SGTF | varchar | 0 | 0 | 255 | True |
Specimen_Date | date | 10 | 0 | 3 | True |
Symptomatic | varchar | 0 | 0 | 50 | True |
Variant | varchar | 0 | 0 | 255 | True |
VariantDetectionMethod | varchar | 0 | 0 | 255 | True |
SGSS_Negative¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Age_In_Years | int | 10 | 0 | 4 | True |
County_Description | varchar | 0 | 0 | 50 | True |
Earliest_Specimen_Date | date | 10 | 0 | 3 | True |
Lab_Report_Date | date | 10 | 0 | 3 | True |
Organism_Species_Name | varchar | 0 | 0 | 200 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Patient_Sex | varchar | 0 | 0 | 50 | True |
PostCode_Source | varchar | 0 | 0 | 50 | True |
SGSS_Positive¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Age_In_Years | int | 10 | 0 | 4 | True |
CaseCategory | varchar | 0 | 0 | 50 | False |
County_Description | varchar | 0 | 0 | 50 | True |
Earliest_Specimen_Date | date | 10 | 0 | 3 | True |
Lab_Report_Date | date | 10 | 0 | 3 | True |
Organism_Species_Name | varchar | 0 | 0 | 200 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Patient_Sex | varchar | 0 | 0 | 50 | True |
PostCode_Source | varchar | 0 | 0 | 50 | True |
SGTF | varchar | 0 | 0 | 10 | False |
NHSE_Therapeutics¶
Therapeutics¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
AgeAtReceivedDate | int | 10 | 0 | 4 | True |
CASIM05_date_of_symptom_onset | varchar | 0 | 0 | 1000 | True |
CASIM05_risk_cohort | varchar | 0 | 0 | 1000 | True |
Count | int | 10 | 0 | 4 | True |
COVID_indication | varchar | 0 | 0 | 1000 | True |
CurrentStatus | varchar | 0 | 0 | 1000 | True |
Der_LoadDate | varchar | 0 | 0 | 1000 | True |
Diagnosis | varchar | 0 | 0 | 1000 | True |
FormName | varchar | 0 | 0 | 1000 | True |
Intervention | varchar | 0 | 0 | 1000 | True |
MOL1_high_risk_cohort | varchar | 0 | 0 | 1000 | True |
MOL1_onset_of_symptoms | varchar | 0 | 0 | 1000 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Received | datetime | 23 | 3 | 8 | True |
Region | varchar | 0 | 0 | 1000 | True |
SOT02_onset_of_symptoms | varchar | 0 | 0 | 1000 | True |
SOT02_risk_cohorts | varchar | 0 | 0 | 1000 | True |
TreatmentStartDate | datetime | 23 | 3 | 8 | True |
NHSE_WL¶
WL_ClockStops¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
ACTIVITY_TREATMENT_FUNCTION_CODE | varchar | 0 | 0 | 1000 | True |
ADMISSION_METHOD_CODE_HOSPITAL_PROVIDER_SPELL | varchar | 0 | 0 | 1000 | True |
Cancellation_Date | varchar | 0 | 0 | 1000 | True |
Completed_Type | varchar | 0 | 0 | 1000 | True |
Date_Last_Attended | varchar | 0 | 0 | 1000 | True |
Date_Of_Last_Priority_Review | varchar | 0 | 0 | 1000 | True |
DECISION_TO_ADMIT_DATE | varchar | 0 | 0 | 1000 | True |
Diagnostic_Priority_Code | varchar | 0 | 0 | 1000 | True |
Due_Date | varchar | 0 | 0 | 1000 | True |
Inclusion_On_Cancer_Ptl | varchar | 0 | 0 | 1000 | True |
Last_Dna_Date | varchar | 0 | 0 | 1000 | True |
Local_Outcome_Of_Attendance | varchar | 0 | 0 | 1000 | True |
Local_Rtt_Status_Code | varchar | 0 | 0 | 1000 | True |
MAIN_SPECIALTY_CODE | varchar | 0 | 0 | 1000 | True |
OPCS_Code | varchar | 0 | 0 | 1000 | True |
OUTCOME_OF_ATTENDANCE_CODE | varchar | 0 | 0 | 1000 | True |
Outpatient_Appointment_Date | varchar | 0 | 0 | 1000 | True |
Outpatient_Future_Appointment_Date | varchar | 0 | 0 | 1000 | True |
Outpatient_Priority_Code | varchar | 0 | 0 | 1000 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
PRIORITY_TYPE_CODE | varchar | 0 | 0 | 1000 | True |
Procedure_Priority_Code | varchar | 0 | 0 | 1000 | True |
PSEUDO_ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER_ISSUER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_COMMISSIONER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_PROVIDER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_SITE_IDENTIFIER_OF_TREATMENT | varbinary | 0 | 0 | 8000 | True |
PSEUDO_PATIENT_PATHWAY_IDENTIFIER | varbinary | 0 | 0 | 8000 | True |
Pseudo_Referral_Identifier | varbinary | 0 | 0 | 8000 | True |
Referral_Request_Received_Date | varchar | 0 | 0 | 1000 | True |
REFERRAL_TO_TREATMENT_PERIOD_END_DATE | varchar | 0 | 0 | 1000 | True |
REFERRAL_TO_TREATMENT_PERIOD_START_DATE | varchar | 0 | 0 | 1000 | True |
REFERRAL_TO_TREATMENT_PERIOD_STATUS | varchar | 0 | 0 | 1000 | True |
SOURCE_OF_REFERRAL_FOR_OUTPATIENTS | varchar | 0 | 0 | 1000 | True |
Tci_Date | varchar | 0 | 0 | 1000 | True |
Waiting_List_Type | varchar | 0 | 0 | 1000 | True |
Week_Ending_Date | varchar | 0 | 0 | 1000 | True |
WL_Diagnostics¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Diagnostic_Clock_Start_Date | varchar | 0 | 0 | 1000 | True |
Diagnostic_Modality | varchar | 0 | 0 | 1000 | True |
Diagnostic_Priority_Code | varchar | 0 | 0 | 1000 | True |
Inclusion_On_Cancer_Ptl | varchar | 0 | 0 | 1000 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Planned_Diagnostic_Due_Date | varchar | 0 | 0 | 1000 | True |
PRIORITY_TYPE_CODE | varchar | 0 | 0 | 1000 | True |
Proposed_Procedure_Opcs_Code | varchar | 0 | 0 | 1000 | True |
PSEUDO_ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER_ISSUER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_COMMISSIONER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_PROVIDER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_SITE_IDENTIFIER_OF_TREATMENT | varbinary | 0 | 0 | 8000 | True |
PSEUDO_PATIENT_PATHWAY_IDENTIFIER | varbinary | 0 | 0 | 8000 | True |
Pseudo_Referral_Identifier | varbinary | 0 | 0 | 8000 | True |
REFERRAL_TO_TREATMENT_PERIOD_END_DATE | varchar | 0 | 0 | 1000 | True |
REFERRAL_TO_TREATMENT_PERIOD_START_DATE | varchar | 0 | 0 | 1000 | True |
Waiting_List_Type | varchar | 0 | 0 | 1000 | True |
Week_Ending_Date | varchar | 0 | 0 | 1000 | True |
WL_OpenPathways¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
ACTIVITY_TREATMENT_FUNCTION_CODE | varchar | 0 | 0 | 1000 | True |
ADMISSION_METHOD_CODE_HOSPITAL_PROVIDER_SPELL | varchar | 0 | 0 | 1000 | True |
Cancellation_Date | varchar | 0 | 0 | 1000 | True |
Current_Pathway_Period_Start_Date | varchar | 0 | 0 | 1000 | True |
Date_Last_Attended | varchar | 0 | 0 | 1000 | True |
Date_Of_Last_Priority_Review | varchar | 0 | 0 | 1000 | True |
DECISION_TO_ADMIT_DATE | varchar | 0 | 0 | 1000 | True |
Diagnostic_Priority_Code | varchar | 0 | 0 | 1000 | True |
Due_Date | varchar | 0 | 0 | 1000 | True |
Inclusion_On_Cancer_Ptl | varchar | 0 | 0 | 1000 | True |
Last_Dna_Date | varchar | 0 | 0 | 1000 | True |
Local_Outcome_Of_Attendance | varchar | 0 | 0 | 1000 | True |
Local_Rtt_Status_Code | varchar | 0 | 0 | 1000 | True |
MAIN_SPECIALTY_CODE | varchar | 0 | 0 | 1000 | True |
OUTCOME_OF_ATTENDANCE_CODE | varchar | 0 | 0 | 1000 | True |
Outpatient_Appointment_Date | varchar | 0 | 0 | 1000 | True |
Outpatient_Future_Appointment_Date | varchar | 0 | 0 | 1000 | True |
Outpatient_Priority_Code | varchar | 0 | 0 | 1000 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
PRIORITY_TYPE_CODE | varchar | 0 | 0 | 1000 | True |
Procedure_Priority_Code | varchar | 0 | 0 | 1000 | True |
Proposed_Procedure_Opcs_Code | varchar | 0 | 0 | 1000 | True |
PSEUDO_ORGANISATION_CODE_PATIENT_PATHWAY_IDENTIFIER_ISSUER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_COMMISSIONER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_IDENTIFIER_CODE_OF_PROVIDER | varbinary | 0 | 0 | 8000 | True |
PSEUDO_ORGANISATION_SITE_IDENTIFIER_OF_TREATMENT | varbinary | 0 | 0 | 8000 | True |
PSEUDO_PATIENT_PATHWAY_IDENTIFIER | varbinary | 0 | 0 | 8000 | True |
Pseudo_Referral_Identifier | varbinary | 0 | 0 | 8000 | True |
REFERRAL_REQUEST_RECEIVED_DATE | varchar | 0 | 0 | 1000 | True |
REFERRAL_TO_TREATMENT_PERIOD_END_DATE | varchar | 0 | 0 | 1000 | True |
REFERRAL_TO_TREATMENT_PERIOD_START_DATE | varchar | 0 | 0 | 1000 | True |
REFERRAL_TO_TREATMENT_PERIOD_STATUS | varchar | 0 | 0 | 1000 | True |
SOURCE_OF_REFERRAL | varchar | 0 | 0 | 1000 | True |
Tci_Date | varchar | 0 | 0 | 1000 | True |
Waiting_List_Type | varchar | 0 | 0 | 1000 | True |
Week_Ending_Date | varchar | 0 | 0 | 1000 | True |
ONS_CIS¶
ONS_CIS¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
age_at_visit | int | 10 | 0 | 4 | True |
contact_any_covid | bit | 1 | 0 | 1 | True |
contact_any_covid_dayssinceg | real | 24 | 0 | 4 | True |
contact_face_covering | int | 10 | 0 | 4 | True |
country | int | 10 | 0 | 4 | True |
covid_admitted | bit | 1 | 0 | 1 | True |
covid_date | date | 10 | 0 | 3 | True |
covid_nhs_contact | bit | 1 | 0 | 1 | True |
covid_test_blood | bit | 1 | 0 | 1 | True |
covid_test_blood_neg_last_date | date | 10 | 0 | 3 | True |
covid_test_blood_pos_first_date | date | 10 | 0 | 3 | True |
covid_test_blood_result | int | 10 | 0 | 4 | True |
covid_test_swab | bit | 1 | 0 | 1 | True |
covid_test_swab_neg_last_date | date | 10 | 0 | 3 | True |
covid_test_swab_pos_first_date | date | 10 | 0 | 3 | True |
covid_test_swab_result | int | 10 | 0 | 4 | True |
covid_think_havehad | bit | 1 | 0 | 1 | True |
ct_mean | varchar | 0 | 0 | 100 | True |
dataset | int | 10 | 0 | 4 | True |
dvhsize | int | 10 | 0 | 4 | True |
ethnicity | int | 10 | 0 | 4 | True |
geography_code | varchar | 0 | 0 | 100 | True |
geography_name | varchar | 0 | 0 | 100 | True |
gor9d | varchar | 0 | 0 | 100 | True |
gor9d_surge | varchar | 0 | 0 | 100 | True |
health_care_clean | bit | 1 | 0 | 1 | True |
health_conditions | bit | 1 | 0 | 1 | True |
health_conditions_impact | int | 10 | 0 | 4 | True |
hhsize | int | 10 | 0 | 4 | True |
imp_age | int | 10 | 0 | 4 | True |
imp_sex | varchar | 0 | 0 | 10 | True |
n_participants | int | 10 | 0 | 4 | True |
patient_facing_clean | int | 10 | 0 | 4 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
received_ox_date | date | 10 | 0 | 3 | True |
result_combined | varchar | 0 | 0 | 100 | True |
result_mk | varchar | 0 | 0 | 100 | True |
result_mk_date | date | 10 | 0 | 3 | True |
result_tdi | varchar | 0 | 0 | 100 | True |
samples_taken_date | date | 10 | 0 | 3 | True |
school_year | varchar | 0 | 0 | 100 | True |
self_isolating | bit | 1 | 0 | 1 | True |
self_isolating_v1 | int | 10 | 0 | 4 | True |
sex | varchar | 0 | 0 | 10 | True |
smoke_ever_regularly | bit | 1 | 0 | 1 | True |
smoke_now_cigar | bit | 1 | 0 | 1 | True |
smoke_now_cigarettes | bit | 1 | 0 | 1 | True |
smoke_now_pipe | bit | 1 | 0 | 1 | True |
smoke_now_vape | bit | 1 | 0 | 1 | True |
SOC_occupation | varchar | 0 | 0 | 100 | True |
surge_flag | bit | 1 | 0 | 1 | True |
sympt_covid_abdominal_pain | bit | 1 | 0 | 1 | True |
sympt_covid_any | bit | 1 | 0 | 1 | True |
sympt_covid_cough | bit | 1 | 0 | 1 | True |
sympt_covid_diarrhoea | bit | 1 | 0 | 1 | True |
sympt_covid_fatigue_weakness | bit | 1 | 0 | 1 | True |
sympt_covid_fever | bit | 1 | 0 | 1 | True |
sympt_covid_headache | bit | 1 | 0 | 1 | True |
sympt_covid_loss_of_smell | bit | 1 | 0 | 1 | True |
sympt_covid_loss_of_taste | bit | 1 | 0 | 1 | True |
sympt_covid_muscle_ache_myalgia | bit | 1 | 0 | 1 | True |
sympt_covid_nausea_vomiting | bit | 1 | 0 | 1 | True |
sympt_covid_shortness_of_breath | bit | 1 | 0 | 1 | True |
sympt_covid_sore_throat | bit | 1 | 0 | 1 | True |
sympt_now_abdominal_pain | bit | 1 | 0 | 1 | True |
sympt_now_any | bit | 1 | 0 | 1 | True |
sympt_now_cough | bit | 1 | 0 | 1 | True |
sympt_now_date | date | 10 | 0 | 3 | True |
sympt_now_diarrhoea | bit | 1 | 0 | 1 | True |
sympt_now_fatigue_weakness | bit | 1 | 0 | 1 | True |
sympt_now_fever | bit | 1 | 0 | 1 | True |
sympt_now_headache | bit | 1 | 0 | 1 | True |
sympt_now_loss_of_smell | bit | 1 | 0 | 1 | True |
sympt_now_loss_of_taste | bit | 1 | 0 | 1 | True |
sympt_now_muscle_ache_myalgia | bit | 1 | 0 | 1 | True |
sympt_now_nausea_vomiting | bit | 1 | 0 | 1 | True |
sympt_now_shortness_of_breath | bit | 1 | 0 | 1 | True |
sympt_now_sore_throat | bit | 1 | 0 | 1 | True |
tenure_group | int | 10 | 0 | 4 | True |
think_have_covid_sympt_now | bit | 1 | 0 | 1 | True |
travel_abroad | bit | 1 | 0 | 1 | True |
travel_abroad_date | date | 10 | 0 | 3 | True |
visit_date | date | 10 | 0 | 3 | True |
visit_id | varchar | 0 | 0 | 100 | True |
work_direct_contact_patients_etc | bit | 1 | 0 | 1 | True |
work_location | int | 10 | 0 | 4 | True |
work_outside_home_days | real | 24 | 0 | 4 | True |
work_sector | int | 10 | 0 | 4 | True |
work_social_distancing | int | 10 | 0 | 4 | True |
work_status | int | 10 | 0 | 4 | True |
work_status_clean | int | 10 | 0 | 4 | True |
work_status_v1 | int | 10 | 0 | 4 | True |
work_travel | int | 10 | 0 | 4 | True |
ONS_CIS_New¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
age_at_visit | int | 10 | 0 | 4 | True |
ageg | int | 10 | 0 | 4 | True |
ageg_7 | int | 10 | 0 | 4 | True |
ageg_small | int | 10 | 0 | 4 | True |
ageg_small2 | int | 10 | 0 | 4 | True |
ageg_sy | int | 10 | 0 | 4 | True |
any_evidence_sympt_around | int | 10 | 0 | 4 | True |
any_evidence_sympt_now | int | 10 | 0 | 4 | True |
assay_mabs | real | 24 | 0 | 4 | True |
assay_mabs_n | real | 24 | 0 | 4 | True |
contact_any_covid | int | 10 | 0 | 4 | True |
contact_any_covid_date | date | 10 | 0 | 3 | True |
contact_any_covid_dayssinceg | int | 10 | 0 | 4 | True |
contact_any_covid_type | int | 10 | 0 | 4 | True |
contact_carehome | int | 10 | 0 | 4 | True |
contact_face_covering | int | 10 | 0 | 4 | True |
contact_face_covering_other | int | 10 | 0 | 4 | True |
contact_face_covering_workschool | int | 10 | 0 | 4 | True |
contact_hospital | int | 10 | 0 | 4 | True |
contact_known_covid | int | 10 | 0 | 4 | True |
contact_known_covid_date | date | 10 | 0 | 3 | True |
contact_known_covid_type | int | 10 | 0 | 4 | True |
contact_other_in_hh_carehome | int | 10 | 0 | 4 | True |
contact_other_in_hh_hospital | int | 10 | 0 | 4 | True |
contact_participant_carehome | int | 10 | 0 | 4 | True |
contact_participant_hospital | int | 10 | 0 | 4 | True |
contact_physical_18_69y | int | 10 | 0 | 4 | True |
contact_physical_18y | int | 10 | 0 | 4 | True |
contact_physical_70y | int | 10 | 0 | 4 | True |
contact_social_dist_18_to_69 | int | 10 | 0 | 4 | True |
contact_social_dist_18y | int | 10 | 0 | 4 | True |
contact_social_dist_70y | int | 10 | 0 | 4 | True |
contact_suspect_covid | int | 10 | 0 | 4 | True |
contact_suspect_covid_date | date | 10 | 0 | 3 | True |
contact_suspect_covid_type | int | 10 | 0 | 4 | True |
country | int | 10 | 0 | 4 | True |
covid_admitted | int | 10 | 0 | 4 | True |
covid_date | date | 10 | 0 | 3 | True |
covid_nhs_contact | int | 10 | 0 | 4 | True |
covid_test_blood | int | 10 | 0 | 4 | True |
covid_test_blood_neg_last_date | date | 10 | 0 | 3 | True |
covid_test_blood_pos_first_date | date | 10 | 0 | 3 | True |
covid_test_blood_result | int | 10 | 0 | 4 | True |
covid_test_swab | int | 10 | 0 | 4 | True |
covid_test_swab_neg_last_date | date | 10 | 0 | 3 | True |
covid_test_swab_pos_first_date | date | 10 | 0 | 3 | True |
covid_test_swab_result | int | 10 | 0 | 4 | True |
covid_think_havehad | int | 10 | 0 | 4 | True |
ct_mean | real | 24 | 0 | 4 | True |
ctMS2 | real | 24 | 0 | 4 | True |
ctMS2_result | int | 10 | 0 | 4 | True |
ctNgene | real | 24 | 0 | 4 | True |
ctNgene_result | int | 10 | 0 | 4 | True |
ctORF1ab | real | 24 | 0 | 4 | True |
ctORF1ab_result | int | 10 | 0 | 4 | True |
ctpattern | int | 10 | 0 | 4 | True |
ctSgene | real | 24 | 0 | 4 | True |
ctSgene_result | int | 10 | 0 | 4 | True |
dataset | int | 10 | 0 | 4 | True |
dob_is_imputed | int | 10 | 0 | 4 | True |
ethnicity | int | 10 | 0 | 4 | True |
ethnicityg | int | 10 | 0 | 4 | True |
geography_code | varchar | 0 | 0 | 100 | True |
geography_name | varchar | 0 | 0 | 100 | True |
gor_name | int | 10 | 0 | 4 | True |
gor9d | int | 10 | 0 | 4 | True |
health_care_clean | int | 10 | 0 | 4 | True |
health_conditions | int | 10 | 0 | 4 | True |
health_conditions_impact | int | 10 | 0 | 4 | True |
hh_id_fake | int | 10 | 0 | 4 | True |
hhsize | int | 10 | 0 | 4 | True |
imd_decile_E | int | 10 | 0 | 4 | True |
imd_decile_NI | int | 10 | 0 | 4 | True |
imd_decile_S | int | 10 | 0 | 4 | True |
imd_decile_W | int | 10 | 0 | 4 | True |
imd_quartile_E | int | 10 | 0 | 4 | True |
imd_quartile_NI | int | 10 | 0 | 4 | True |
imd_quartile_S | int | 10 | 0 | 4 | True |
imd_quartile_W | int | 10 | 0 | 4 | True |
last_linkage_dt | date | 10 | 0 | 3 | True |
long_covid_abdominal_pain | int | 10 | 0 | 4 | True |
long_covid_chest_pain | int | 10 | 0 | 4 | True |
long_covid_cough | int | 10 | 0 | 4 | True |
long_covid_diarrhoea | int | 10 | 0 | 4 | True |
long_covid_difficult_concentrate | int | 10 | 0 | 4 | True |
long_covid_fever | int | 10 | 0 | 4 | True |
long_covid_have_symptoms | int | 10 | 0 | 4 | True |
long_covid_headache | int | 10 | 0 | 4 | True |
long_covid_loss_of_appetite | int | 10 | 0 | 4 | True |
long_covid_loss_of_smell | int | 10 | 0 | 4 | True |
long_covid_loss_of_taste | int | 10 | 0 | 4 | True |
long_covid_low_mood_not_enjoying | int | 10 | 0 | 4 | True |
long_covid_memory_loss_confusion | int | 10 | 0 | 4 | True |
long_covid_muscle_ache | int | 10 | 0 | 4 | True |
long_covid_nausea_vomiting | int | 10 | 0 | 4 | True |
long_covid_palpitations | int | 10 | 0 | 4 | True |
long_covid_shortness_of_breath | int | 10 | 0 | 4 | True |
long_covid_sore_throat | int | 10 | 0 | 4 | True |
long_covid_trouble_sleeping | int | 10 | 0 | 4 | True |
long_covid_vertigo_dizziness | int | 10 | 0 | 4 | True |
long_covid_weakness_tiredness | int | 10 | 0 | 4 | True |
long_covid_worry_anxiety | int | 10 | 0 | 4 | True |
main_job_changed | int | 10 | 0 | 4 | True |
n_participants_corrected | int | 10 | 0 | 4 | True |
nhs_data_share | int | 10 | 0 | 4 | True |
opt_out_date | date | 10 | 0 | 3 | True |
others_home_hours | int | 10 | 0 | 4 | True |
others_own_home_hours | int | 10 | 0 | 4 | True |
outside_shopping_only_times | int | 10 | 0 | 4 | True |
outside_shopping_social_times | int | 10 | 0 | 4 | True |
outside_socialising_only_times | int | 10 | 0 | 4 | True |
patient_facing_clean | int | 10 | 0 | 4 | True |
patient_facing_clean_ever | int | 10 | 0 | 4 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
pseudo_visit_id | varbinary | 0 | 0 | 8000 | True |
reason_for_withdrawal | int | 10 | 0 | 4 | True |
received_ox_date | date | 10 | 0 | 3 | True |
reduce_activities_long_covid | int | 10 | 0 | 4 | True |
result_combined | int | 10 | 0 | 4 | True |
result_mk | int | 10 | 0 | 4 | True |
result_mk_date | date | 10 | 0 | 3 | True |
result_tdi | int | 10 | 0 | 4 | True |
result_tdi_date | date | 10 | 0 | 3 | True |
result_tdi_date_n | date | 10 | 0 | 3 | True |
result_tdi_n | int | 10 | 0 | 4 | True |
rural_urban | int | 10 | 0 | 4 | True |
samples_taken_date | date | 10 | 0 | 3 | True |
school_year | int | 10 | 0 | 4 | True |
self_isolating | int | 10 | 0 | 4 | True |
self_isolating_v1 | int | 10 | 0 | 4 | True |
sex | int | 10 | 0 | 4 | True |
sex_is_imputed | int | 10 | 0 | 4 | True |
smoke_ever_regularly | int | 10 | 0 | 4 | True |
smoke_now_cigar | int | 10 | 0 | 4 | True |
smoke_now_cigarettes | int | 10 | 0 | 4 | True |
smoke_now_hookah_shisha | int | 10 | 0 | 4 | True |
smoke_now_nothing | int | 10 | 0 | 4 | True |
smoke_now_pipe | int | 10 | 0 | 4 | True |
smoke_now_vape | int | 10 | 0 | 4 | True |
SOC_occupation | varchar | 0 | 0 | 100 | True |
sympt_covid_abdominal_pain | int | 10 | 0 | 4 | True |
sympt_covid_any | int | 10 | 0 | 4 | True |
sympt_covid_cough | int | 10 | 0 | 4 | True |
sympt_covid_diarrhoea | int | 10 | 0 | 4 | True |
sympt_covid_fatigue_weakness | int | 10 | 0 | 4 | True |
sympt_covid_fever | int | 10 | 0 | 4 | True |
sympt_covid_headache | int | 10 | 0 | 4 | True |
sympt_covid_loss_of_smell | int | 10 | 0 | 4 | True |
sympt_covid_loss_of_taste | int | 10 | 0 | 4 | True |
sympt_covid_muscle_ache_myalgia | int | 10 | 0 | 4 | True |
sympt_covid_nausea_vomiting | int | 10 | 0 | 4 | True |
sympt_covid_shortness_of_breath | int | 10 | 0 | 4 | True |
sympt_covid_sore_throat | int | 10 | 0 | 4 | True |
sympt_now_abdominal_pain | int | 10 | 0 | 4 | True |
sympt_now_any | int | 10 | 0 | 4 | True |
sympt_now_any_orig | int | 10 | 0 | 4 | True |
sympt_now_cough | int | 10 | 0 | 4 | True |
sympt_now_count12 | int | 10 | 0 | 4 | True |
sympt_now_date | date | 10 | 0 | 3 | True |
sympt_now_diarrhoea | int | 10 | 0 | 4 | True |
sympt_now_fatigue_weakness | int | 10 | 0 | 4 | True |
sympt_now_fever | int | 10 | 0 | 4 | True |
sympt_now_headache | int | 10 | 0 | 4 | True |
sympt_now_loss_of_smell | int | 10 | 0 | 4 | True |
sympt_now_loss_of_taste | int | 10 | 0 | 4 | True |
sympt_now_muscle_ache_myalgia | int | 10 | 0 | 4 | True |
sympt_now_nausea_vomiting | int | 10 | 0 | 4 | True |
sympt_now_shortness_of_breath | int | 10 | 0 | 4 | True |
sympt_now_sore_throat | int | 10 | 0 | 4 | True |
tenure_group | int | 10 | 0 | 4 | True |
think_have_covid_sympt_now | int | 10 | 0 | 4 | True |
travel_abroad | int | 10 | 0 | 4 | True |
travel_abroad_date | date | 10 | 0 | 3 | True |
visit_date | date | 10 | 0 | 3 | True |
visit_num | int | 10 | 0 | 4 | True |
visit_status | int | 10 | 0 | 4 | True |
visit_type | int | 10 | 0 | 4 | True |
withdrawn_participant | int | 10 | 0 | 4 | True |
work_direct_contact_patients_etc | int | 10 | 0 | 4 | True |
work_location | int | 10 | 0 | 4 | True |
work_outside_home_days | real | 24 | 0 | 4 | True |
work_sector | int | 10 | 0 | 4 | True |
work_social_distancing | int | 10 | 0 | 4 | True |
work_status | int | 10 | 0 | 4 | True |
work_status_clean | int | 10 | 0 | 4 | True |
work_status_v1 | int | 10 | 0 | 4 | True |
work_status_v2 | int | 10 | 0 | 4 | True |
work_travel | int | 10 | 0 | 4 | True |
ONS_CIS_New_Swab_Clearance¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
age_at_visit | int | 10 | 0 | 4 | True |
ageg_small | int | 10 | 0 | 4 | True |
ageg_sy | int | 10 | 0 | 4 | True |
any_evidence_sympt_ARO | int | 10 | 0 | 4 | True |
any_lfdpos | int | 10 | 0 | 4 | True |
atrisk_date | date | 10 | 0 | 3 | True |
check | int | 10 | 0 | 4 | True |
cis20_name | int | 10 | 0 | 4 | True |
cis20_samp | int | 10 | 0 | 4 | True |
clear_pattern | int | 10 | 0 | 4 | True |
count_pos_in_epi_updt | int | 10 | 0 | 4 | True |
country | int | 10 | 0 | 4 | True |
ct_mean_max | real | 24 | 0 | 4 | True |
ct_mean_min | real | 24 | 0 | 4 | True |
ctpattern_max | int | 10 | 0 | 4 | True |
ctpattern_min | int | 10 | 0 | 4 | True |
duration_intermittent | int | 10 | 0 | 4 | True |
epi_inf_type | int | 10 | 0 | 4 | True |
episode_updt | int | 10 | 0 | 4 | True |
ethnicity_wo | int | 10 | 0 | 4 | True |
ethnicityg | int | 10 | 0 | 4 | True |
ever_care_home_worker | int | 10 | 0 | 4 | True |
ever_lthc | int | 10 | 0 | 4 | True |
ever_lthc_disabled | int | 10 | 0 | 4 | True |
ever_personfacing_socialcare | int | 10 | 0 | 4 | True |
first_neg_date | date | 10 | 0 | 3 | True |
first_pos_date | date | 10 | 0 | 3 | True |
firstpos_test_no | int | 10 | 0 | 4 | True |
gor9d | int | 10 | 0 | 4 | True |
hh_enrol_date | date | 10 | 0 | 3 | True |
hh_id_fake | int | 10 | 0 | 4 | True |
hhsize | int | 10 | 0 | 4 | True |
index_date_updt | date | 10 | 0 | 3 | True |
intermittent | int | 10 | 0 | 4 | True |
last_pos_date | date | 10 | 0 | 3 | True |
laua_name | int | 10 | 0 | 4 | True |
laua_samp | int | 10 | 0 | 4 | True |
lineage | varchar | 0 | 0 | 1000 | True |
n_participants_corrected | int | 10 | 0 | 4 | True |
n_tests_in_epi | int | 10 | 0 | 4 | True |
next_lab_id | int | 10 | 0 | 4 | True |
other_in_hh | int | 10 | 0 | 4 | True |
pangolin | varchar | 0 | 0 | 1000 | True |
patient_facing_clean_ever | int | 10 | 0 | 4 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
plot | real | 24 | 0 | 4 | True |
pospattern | varchar | 0 | 0 | 1000 | True |
prev_neg_date | date | 10 | 0 | 3 | True |
PREVNEG | int | 10 | 0 | 4 | True |
rgn_samp | int | 10 | 0 | 4 | True |
second_neg_date | date | 10 | 0 | 3 | True |
sex | int | 10 | 0 | 4 | True |
smoke | int | 10 | 0 | 4 | True |
sympt_ARO_amn_source | int | 10 | 0 | 4 | True |
sympt_ARO_split | int | 10 | 0 | 4 | True |
testkit | varchar | 0 | 0 | 1000 | True |
wofy53 | int | 10 | 0 | 4 | True |
WOFY57 | int | 10 | 0 | 4 | True |
ONS_CIS_New_Swab_Clearance_Pos_All¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
age_at_visit | int | 10 | 0 | 4 | True |
ageg_small | int | 10 | 0 | 4 | True |
ageg_sy | int | 10 | 0 | 4 | True |
any_evidence_sympt_ARO | int | 10 | 0 | 4 | True |
any_lfdpos | int | 10 | 0 | 4 | True |
atrisk_date | date | 10 | 0 | 3 | True |
check | int | 10 | 0 | 4 | True |
cis20_name | int | 10 | 0 | 4 | True |
cis20_samp | int | 10 | 0 | 4 | True |
clear_pattern | int | 10 | 0 | 4 | True |
count_pos_in_epi_updt | int | 10 | 0 | 4 | True |
country | int | 10 | 0 | 4 | True |
covid_test_swab_result | int | 10 | 0 | 4 | True |
ct_mean_max | real | 24 | 0 | 4 | True |
ct_mean_max_exc_tnt | real | 24 | 0 | 4 | True |
ct_mean_min | real | 24 | 0 | 4 | True |
ct_mean_min_exc_tnt | real | 24 | 0 | 4 | True |
ctpattern_max | int | 10 | 0 | 4 | True |
ctpattern_max_exc_tnt | int | 10 | 0 | 4 | True |
ctpattern_min | int | 10 | 0 | 4 | True |
ctpattern_min_exc_tnt | int | 10 | 0 | 4 | True |
duration_intermittent | int | 10 | 0 | 4 | True |
epi_inf_type | int | 10 | 0 | 4 | True |
episode_updt | int | 10 | 0 | 4 | True |
ethnicity_wo | int | 10 | 0 | 4 | True |
ethnicityg | int | 10 | 0 | 4 | True |
ever_care_home_worker | int | 10 | 0 | 4 | True |
ever_lthc | int | 10 | 0 | 4 | True |
ever_lthc_disabled | int | 10 | 0 | 4 | True |
ever_personfacing_socialcare | int | 10 | 0 | 4 | True |
first_neg_date | date | 10 | 0 | 3 | True |
first_pos_date | date | 10 | 0 | 3 | True |
first_pos_date_cis | date | 10 | 0 | 3 | True |
firstpos_test_no | int | 10 | 0 | 4 | True |
gor9d | int | 10 | 0 | 4 | True |
hh_enrol_date | date | 10 | 0 | 3 | True |
hh_id_fake | int | 10 | 0 | 4 | True |
hhsize | int | 10 | 0 | 4 | True |
index_date_updt | date | 10 | 0 | 3 | True |
intermittent | int | 10 | 0 | 4 | True |
last_pos_date | date | 10 | 0 | 3 | True |
laua_name | int | 10 | 0 | 4 | True |
laua_samp | int | 10 | 0 | 4 | True |
lineage | varchar | 0 | 0 | 1000 | True |
n | int | 10 | 0 | 4 | True |
n_participants_corrected | int | 10 | 0 | 4 | True |
n_tests_in_epi | int | 10 | 0 | 4 | True |
next_lab_id | int | 10 | 0 | 4 | True |
other_in_hh | int | 10 | 0 | 4 | True |
pangolin | varchar | 0 | 0 | 1000 | True |
patient_facing_clean_ever | int | 10 | 0 | 4 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
plot | real | 24 | 0 | 4 | True |
pospattern | varchar | 0 | 0 | 1000 | True |
prev_neg_date | date | 10 | 0 | 3 | True |
PREVNEG | int | 10 | 0 | 4 | True |
rgn_samp | int | 10 | 0 | 4 | True |
second_neg_date | date | 10 | 0 | 3 | True |
sex | int | 10 | 0 | 4 | True |
smoke | int | 10 | 0 | 4 | True |
sympt_ARO_amn_source | int | 10 | 0 | 4 | True |
sympt_ARO_split | int | 10 | 0 | 4 | True |
testedfor | varchar | 0 | 0 | 1000 | True |
testkit | varchar | 0 | 0 | 1000 | True |
type_updt | int | 10 | 0 | 4 | True |
type_updt_tnt_minus_cis_days | int | 10 | 0 | 4 | True |
wofy60 | int | 10 | 0 | 4 | True |
WOFY68 | int | 10 | 0 | 4 | True |
ONS_CIS_New_Swab_Clearance_Pos_TnT¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
age_at_visit | int | 10 | 0 | 4 | True |
ageg_small | int | 10 | 0 | 4 | True |
ageg_sy | int | 10 | 0 | 4 | True |
any_evidence_sympt_ARO | int | 10 | 0 | 4 | True |
any_lfdpos | int | 10 | 0 | 4 | True |
atrisk_date | date | 10 | 0 | 3 | True |
check | int | 10 | 0 | 4 | True |
cis20_name | int | 10 | 0 | 4 | True |
cis20_samp | int | 10 | 0 | 4 | True |
clear_pattern | int | 10 | 0 | 4 | True |
count_pos_in_epi_updt | int | 10 | 0 | 4 | True |
country | int | 10 | 0 | 4 | True |
ct_mean_max | real | 24 | 0 | 4 | True |
ct_mean_max_exc_tnt | real | 24 | 0 | 4 | True |
ct_mean_min | real | 24 | 0 | 4 | True |
ct_mean_min_exc_tnt | real | 24 | 0 | 4 | True |
ctpattern_max | int | 10 | 0 | 4 | True |
ctpattern_max_exc_tnt | int | 10 | 0 | 4 | True |
ctpattern_min | int | 10 | 0 | 4 | True |
ctpattern_min_exc_tnt | int | 10 | 0 | 4 | True |
duration_intermittent | int | 10 | 0 | 4 | True |
epi_inf_type | int | 10 | 0 | 4 | True |
episode_updt | int | 10 | 0 | 4 | True |
ethnicity_wo | int | 10 | 0 | 4 | True |
ethnicityg | int | 10 | 0 | 4 | True |
ever_care_home_worker | int | 10 | 0 | 4 | True |
ever_lthc | int | 10 | 0 | 4 | True |
ever_lthc_disabled | int | 10 | 0 | 4 | True |
ever_personfacing_socialcare | int | 10 | 0 | 4 | True |
first_neg_date | date | 10 | 0 | 3 | True |
first_pos_date | date | 10 | 0 | 3 | True |
first_pos_date_cis | date | 10 | 0 | 3 | True |
firstpos_test_no | int | 10 | 0 | 4 | True |
gor9d | int | 10 | 0 | 4 | True |
hh_enrol_date | date | 10 | 0 | 3 | True |
hh_id_fake | int | 10 | 0 | 4 | True |
hhsize | int | 10 | 0 | 4 | True |
index_date_updt | date | 10 | 0 | 3 | True |
intermittent | int | 10 | 0 | 4 | True |
last_pos_date | date | 10 | 0 | 3 | True |
laua_name | int | 10 | 0 | 4 | True |
laua_samp | int | 10 | 0 | 4 | True |
lineage | varchar | 0 | 0 | 1000 | True |
n | int | 10 | 0 | 4 | True |
n_participants_corrected | int | 10 | 0 | 4 | True |
n_tests_in_epi | int | 10 | 0 | 4 | True |
next_lab_id | int | 10 | 0 | 4 | True |
other_in_hh | int | 10 | 0 | 4 | True |
pangolin | varchar | 0 | 0 | 1000 | True |
patient_facing_clean_ever | int | 10 | 0 | 4 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
plot | real | 24 | 0 | 4 | True |
pospattern | varchar | 0 | 0 | 1000 | True |
prev_neg_date | date | 10 | 0 | 3 | True |
PREVNEG | int | 10 | 0 | 4 | True |
rgn_samp | int | 10 | 0 | 4 | True |
second_neg_date | date | 10 | 0 | 3 | True |
sex | int | 10 | 0 | 4 | True |
smoke | int | 10 | 0 | 4 | True |
sympt_ARO_amn_source | int | 10 | 0 | 4 | True |
sympt_ARO_split | int | 10 | 0 | 4 | True |
testedfor | varchar | 0 | 0 | 1000 | True |
testkit | varchar | 0 | 0 | 1000 | True |
type_updt | int | 10 | 0 | 4 | True |
type_updt_tnt_minus_cis_days | int | 10 | 0 | 4 | True |
wofy60 | int | 10 | 0 | 4 | True |
WOFY68 | int | 10 | 0 | 4 | True |
ONS_DEATHS¶
ONS_Deaths¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
ageinyrs | int | 10 | 0 | 4 | True |
dod | date | 10 | 0 | 3 | True |
FIC10MEN1 | varchar | 0 | 0 | 100 | True |
FIC10MEN10 | varchar | 0 | 0 | 100 | True |
FIC10MEN11 | varchar | 0 | 0 | 100 | True |
FIC10MEN12 | varchar | 0 | 0 | 100 | True |
FIC10MEN13 | varchar | 0 | 0 | 100 | True |
FIC10MEN14 | varchar | 0 | 0 | 100 | True |
FIC10MEN15 | varchar | 0 | 0 | 100 | True |
FIC10MEN2 | varchar | 0 | 0 | 100 | True |
FIC10MEN3 | varchar | 0 | 0 | 100 | True |
FIC10MEN4 | varchar | 0 | 0 | 100 | True |
FIC10MEN5 | varchar | 0 | 0 | 100 | True |
FIC10MEN6 | varchar | 0 | 0 | 100 | True |
FIC10MEN7 | varchar | 0 | 0 | 100 | True |
FIC10MEN8 | varchar | 0 | 0 | 100 | True |
FIC10MEN9 | varchar | 0 | 0 | 100 | True |
FIC10UND | varchar | 0 | 0 | 100 | True |
ICD10001 | varchar | 0 | 0 | 100 | True |
ICD10002 | varchar | 0 | 0 | 100 | True |
ICD10003 | varchar | 0 | 0 | 100 | True |
ICD10004 | varchar | 0 | 0 | 100 | True |
ICD10005 | varchar | 0 | 0 | 100 | True |
ICD10006 | varchar | 0 | 0 | 100 | True |
ICD10007 | varchar | 0 | 0 | 100 | True |
ICD10008 | varchar | 0 | 0 | 100 | True |
ICD10009 | varchar | 0 | 0 | 100 | True |
ICD10010 | varchar | 0 | 0 | 100 | True |
ICD10011 | varchar | 0 | 0 | 100 | True |
ICD10012 | varchar | 0 | 0 | 100 | True |
ICD10013 | varchar | 0 | 0 | 100 | True |
ICD10014 | varchar | 0 | 0 | 100 | True |
ICD10015 | varchar | 0 | 0 | 100 | True |
icd10u | varchar | 0 | 0 | 100 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Place_of_occurrence | varchar | 0 | 0 | 1000 | True |
sex | varchar | 0 | 0 | 10 | True |
OS_BUILD¶
BuildInfo¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
BuildDate | datetime | 23 | 3 | 8 | False |
BuildDesc | varchar | 0 | 0 | 100 | False |
BuildNumber | int | 10 | 0 | 4 | False |
CodeCountIndicator¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CodeCountIndicator | float | 53 | 0 | 8 | True |
CTV3Code | varchar | 0 | 0 | 50 | False |
LatestBuildTime¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
DtLatestBuild | datetime | 23 | 3 | 8 | False |
OpenSAFELYSchemaInformation¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CollationName | nvarchar | 0 | 0 | 256 | True |
CollationName | sysname | 0 | 0 | 256 | True |
ColumnId | int | 10 | 0 | 4 | False |
ColumnName | nvarchar | 0 | 0 | 256 | True |
ColumnName | sysname | 0 | 0 | 256 | True |
ColumnType | nvarchar | 0 | 0 | 256 | False |
ColumnType | sysname | 0 | 0 | 256 | False |
DataSource | varchar | 0 | 0 | 1000 | True |
IsNullable | bit | 1 | 0 | 1 | True |
MaxLength | smallint | 5 | 0 | 2 | False |
Precision | tinyint | 3 | 0 | 1 | False |
Scale | tinyint | 3 | 0 | 1 | False |
TableName | nvarchar | 0 | 0 | 256 | False |
TableName | sysname | 0 | 0 | 256 | False |
OS_DERIVED¶
Household¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CareHome | bit | 1 | 0 | 1 | True |
Household_ID | bigint | 19 | 0 | 8 | True |
HouseholdSize | int | 10 | 0 | 4 | True |
MatchesUprnCount | bit | 1 | 0 | 1 | True |
MixedSoftwareHousehold | bit | 1 | 0 | 1 | True |
MSOA | varchar | 0 | 0 | 50 | True |
NFA_Unknown | bit | 1 | 0 | 1 | True |
Prison | bit | 1 | 0 | 1 | True |
TppPercentage | int | 10 | 0 | 4 | True |
HouseholdMember¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Household_ID | bigint | 19 | 0 | 8 | False |
HouseholdMember_ID | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
MSOA_PopulationEstimates_2019¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Age_0 | int | 10 | 0 | 4 | False |
Age_1 | int | 10 | 0 | 4 | False |
Age_10 | int | 10 | 0 | 4 | False |
Age_11 | int | 10 | 0 | 4 | False |
Age_12 | int | 10 | 0 | 4 | False |
Age_13 | int | 10 | 0 | 4 | False |
Age_14 | int | 10 | 0 | 4 | False |
Age_15 | int | 10 | 0 | 4 | False |
Age_16 | int | 10 | 0 | 4 | False |
Age_17 | int | 10 | 0 | 4 | False |
Age_18 | int | 10 | 0 | 4 | False |
Age_19 | int | 10 | 0 | 4 | False |
Age_2 | int | 10 | 0 | 4 | False |
Age_20 | int | 10 | 0 | 4 | False |
Age_21 | int | 10 | 0 | 4 | False |
Age_22 | int | 10 | 0 | 4 | False |
Age_23 | int | 10 | 0 | 4 | False |
Age_24 | int | 10 | 0 | 4 | False |
Age_25 | int | 10 | 0 | 4 | False |
Age_26 | int | 10 | 0 | 4 | False |
Age_27 | int | 10 | 0 | 4 | False |
Age_28 | int | 10 | 0 | 4 | False |
Age_29 | int | 10 | 0 | 4 | False |
Age_3 | int | 10 | 0 | 4 | False |
Age_30 | int | 10 | 0 | 4 | False |
Age_31 | int | 10 | 0 | 4 | False |
Age_32 | int | 10 | 0 | 4 | False |
Age_33 | int | 10 | 0 | 4 | False |
Age_34 | int | 10 | 0 | 4 | False |
Age_35 | int | 10 | 0 | 4 | False |
Age_36 | int | 10 | 0 | 4 | False |
Age_37 | int | 10 | 0 | 4 | False |
Age_38 | int | 10 | 0 | 4 | False |
Age_39 | int | 10 | 0 | 4 | False |
Age_4 | int | 10 | 0 | 4 | False |
Age_40 | int | 10 | 0 | 4 | False |
Age_41 | int | 10 | 0 | 4 | False |
Age_42 | int | 10 | 0 | 4 | False |
Age_43 | int | 10 | 0 | 4 | False |
Age_44 | int | 10 | 0 | 4 | False |
Age_45 | int | 10 | 0 | 4 | False |
Age_46 | int | 10 | 0 | 4 | False |
Age_47 | int | 10 | 0 | 4 | False |
Age_48 | int | 10 | 0 | 4 | False |
Age_49 | int | 10 | 0 | 4 | False |
Age_5 | int | 10 | 0 | 4 | False |
Age_50 | int | 10 | 0 | 4 | False |
Age_51 | int | 10 | 0 | 4 | False |
Age_52 | int | 10 | 0 | 4 | False |
Age_53 | int | 10 | 0 | 4 | False |
Age_54 | int | 10 | 0 | 4 | False |
Age_55 | int | 10 | 0 | 4 | False |
Age_56 | int | 10 | 0 | 4 | False |
Age_57 | int | 10 | 0 | 4 | False |
Age_58 | int | 10 | 0 | 4 | False |
Age_59 | int | 10 | 0 | 4 | False |
Age_6 | int | 10 | 0 | 4 | False |
Age_60 | int | 10 | 0 | 4 | False |
Age_61 | int | 10 | 0 | 4 | False |
Age_62 | int | 10 | 0 | 4 | False |
Age_63 | int | 10 | 0 | 4 | False |
Age_64 | int | 10 | 0 | 4 | False |
Age_65 | int | 10 | 0 | 4 | False |
Age_66 | int | 10 | 0 | 4 | False |
Age_67 | int | 10 | 0 | 4 | False |
Age_68 | int | 10 | 0 | 4 | False |
Age_69 | int | 10 | 0 | 4 | False |
Age_7 | int | 10 | 0 | 4 | False |
Age_70 | int | 10 | 0 | 4 | False |
Age_71 | int | 10 | 0 | 4 | False |
Age_72 | int | 10 | 0 | 4 | False |
Age_73 | int | 10 | 0 | 4 | False |
Age_74 | int | 10 | 0 | 4 | False |
Age_75 | int | 10 | 0 | 4 | False |
Age_76 | int | 10 | 0 | 4 | False |
Age_77 | int | 10 | 0 | 4 | False |
Age_78 | int | 10 | 0 | 4 | False |
Age_79 | int | 10 | 0 | 4 | False |
Age_8 | int | 10 | 0 | 4 | False |
Age_80 | int | 10 | 0 | 4 | False |
Age_81 | int | 10 | 0 | 4 | False |
Age_82 | int | 10 | 0 | 4 | False |
Age_83 | int | 10 | 0 | 4 | False |
Age_84 | int | 10 | 0 | 4 | False |
Age_85 | int | 10 | 0 | 4 | False |
Age_86 | int | 10 | 0 | 4 | False |
Age_87 | int | 10 | 0 | 4 | False |
Age_88 | int | 10 | 0 | 4 | False |
Age_89 | int | 10 | 0 | 4 | False |
Age_9 | int | 10 | 0 | 4 | False |
Age_90_Plus | int | 10 | 0 | 4 | False |
Age_All | int | 10 | 0 | 4 | False |
LA_Code_2019 | varchar | 0 | 0 | 50 | False |
LA_Code_2020 | varchar | 0 | 0 | 50 | False |
MSOA_Code | varchar | 0 | 0 | 50 | False |
PotentialCareHomeAddress¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
LocationDoesNotRequireNursing | varchar | 0 | 0 | 5 | False |
LocationRequiresNursing | varchar | 0 | 0 | 5 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
PatientAddress_ID | bigint | 19 | 0 | 8 | False |
S1¶
Appointment¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Appointment_ID | bigint | 19 | 0 | 8 | False |
ArrivedDate | datetime | 23 | 3 | 8 | False |
BookedDate | datetime | 23 | 3 | 8 | False |
EndDate | datetime | 23 | 3 | 8 | False |
FinishedDate | datetime | 23 | 3 | 8 | False |
Organisation_ID | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
SeenDate | datetime | 23 | 3 | 8 | False |
StartDate | datetime | 23 | 3 | 8 | False |
Status | int | 10 | 0 | 4 | False |
CTV3Dictionary¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CTV3Code | varchar | 0 | 0 | 50 | False |
Description | varchar | 0 | 0 | 255 | False |
CTV3Hierarchy¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
ChildCTV3Code | varchar | 0 | 0 | 50 | False |
ChildCTV3Description | varchar | 0 | 0 | 255 | False |
ChildToParentDistance | int | 10 | 0 | 4 | False |
ParentCTV3Code | varchar | 0 | 0 | 50 | False |
ParentCTV3Description | varchar | 0 | 0 | 255 | False |
CodedEvent¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CodedEvent_ID | bigint | 19 | 0 | 8 | False |
Consultation_ID | bigint | 19 | 0 | 8 | False |
ConsultationDate | datetime | 23 | 3 | 8 | False |
CTV3Code | varchar | 0 | 0 | 50 | False |
NumericValue | real | 24 | 0 | 4 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
CodedEventRange¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CodedEvent_ID | bigint | 19 | 0 | 8 | False |
CodedEventRange_ID | bigint | 19 | 0 | 8 | False |
Comparator | tinyint | 3 | 0 | 1 | False |
Consultation_ID | bigint | 19 | 0 | 8 | False |
LowerBound | real | 24 | 0 | 4 | False |
Patient_ID | int | 10 | 0 | 4 | False |
UpperBound | real | 24 | 0 | 4 | False |
Consultation¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Consultation_ID | bigint | 19 | 0 | 8 | False |
ConsultationDate | datetime | 23 | 3 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Registration_ID | bigint | 19 | 0 | 8 | False |
DataDictionary¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Code | varchar | 0 | 0 | 255 | True |
Description | varchar | 0 | 0 | 1000 | True |
Table | varchar | 0 | 0 | 1000 | True |
Type | varchar | 0 | 0 | 255 | True |
ICD10Dictionary¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Code | varchar | 0 | 0 | 4 | False |
CodeDescription | varchar | 0 | 0 | 500 | False |
ParentCode | char | 0 | 0 | 3 | False |
ParentCodeDescription | varchar | 0 | 0 | 500 | False |
MedicationDictionary¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CompanyName | varchar | 0 | 0 | 200 | True |
DMD_ID | varchar | 0 | 0 | 50 | True |
Form | varchar | 0 | 0 | 50 | True |
FullName | varchar | 0 | 0 | 1000 | True |
MultilexDrug_ID | varchar | 0 | 0 | 767 | True |
PackDescription | varchar | 0 | 0 | 50 | True |
ProductId | bigint | 19 | 0 | 8 | False |
RootName | varchar | 0 | 0 | 100 | True |
Strength | varchar | 0 | 0 | 500 | True |
MedicationIssue¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Consultation_ID | bigint | 19 | 0 | 8 | False |
ConsultationDate | datetime | 23 | 3 | 8 | False |
Dose | varchar | 0 | 0 | 255 | False |
EndDate | datetime | 23 | 3 | 8 | False |
MedicationIssue_ID | bigint | 19 | 0 | 8 | False |
MedicationStatus | int | 10 | 0 | 4 | False |
MultilexDrug_ID | varchar | 0 | 0 | 255 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Quantity | varchar | 0 | 0 | 255 | False |
RepeatMedication_ID | bigint | 19 | 0 | 8 | False |
StartDate | datetime | 23 | 3 | 8 | False |
MedicationRepeat¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Consultation_ID | bigint | 19 | 0 | 8 | False |
ConsultationDate | datetime | 23 | 3 | 8 | False |
Dose | varchar | 0 | 0 | 255 | False |
EndDate | datetime | 23 | 3 | 8 | False |
MedicationRepeat_ID | bigint | 19 | 0 | 8 | False |
MedicationStatus | int | 10 | 0 | 4 | False |
MultilexDrug_ID | varchar | 0 | 0 | 255 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Quantity | varchar | 0 | 0 | 255 | False |
StartDate | datetime | 23 | 3 | 8 | False |
MedicationSensitivity¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Consultation_ID | bigint | 19 | 0 | 8 | False |
ConsultationDate | datetime | 23 | 3 | 8 | False |
Ended | bit | 1 | 0 | 1 | True |
FormulationSpecific | bit | 1 | 0 | 1 | False |
MedicationSensitivity_ID | int | 10 | 0 | 4 | False |
MultilexDrug_ID | varchar | 0 | 0 | 100 | False |
Patient_ID | int | 10 | 0 | 4 | False |
StartDate | datetime | 23 | 3 | 8 | False |
Organisation¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
GoLiveDate | datetime | 23 | 3 | 8 | False |
MSOACode | varchar | 0 | 0 | 150 | False |
Organisation_ID | bigint | 19 | 0 | 8 | False |
Region | varchar | 0 | 0 | 255 | False |
STPCode | varchar | 0 | 0 | 50 | False |
Patient¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
DateOfBirth | date | 10 | 0 | 3 | True |
DateOfDeath | date | 10 | 0 | 3 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
Sex | char | 0 | 0 | 1 | False |
PatientAddress¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
AddressType | int | 10 | 0 | 4 | False |
EndDate | datetime | 23 | 3 | 8 | False |
ImdRankRounded | int | 10 | 0 | 4 | False |
MSOACode | varchar | 0 | 0 | 150 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
PatientAddress_ID | bigint | 19 | 0 | 8 | False |
RuralUrbanClassificationCode | int | 10 | 0 | 4 | False |
StartDate | datetime | 23 | 3 | 8 | False |
QOFClusterReference¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
ClusterName | varchar | 0 | 0 | 100 | False |
ClusterType | varchar | 0 | 0 | 50 | False |
CTV3Code | varchar | 0 | 0 | 50 | False |
Description | varchar | 0 | 0 | 255 | False |
RegistrationHistory¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
EndDate | datetime | 23 | 3 | 8 | False |
Organisation_ID | bigint | 19 | 0 | 8 | False |
Patient_ID | bigint | 19 | 0 | 8 | False |
Registration_ID | bigint | 19 | 0 | 8 | False |
StartDate | datetime | 23 | 3 | 8 | False |
UnitDictionary¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
CTV3Code | varchar | 0 | 0 | 50 | False |
DecimalPlaces | int | 10 | 0 | 4 | False |
LowerNormalBound | real | 24 | 0 | 4 | False |
Maximum | real | 24 | 0 | 4 | False |
Minimum | real | 24 | 0 | 4 | False |
UnitDictionary_ID | int | 10 | 0 | 4 | False |
Units | varchar | 0 | 0 | 50 | False |
UpperNormalBound | real | 24 | 0 | 4 | False |
Vaccination¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
Patient_ID | bigint | 19 | 0 | 8 | False |
Vaccination_ID | bigint | 19 | 0 | 8 | False |
VaccinationDate | datetime | 23 | 3 | 8 | False |
VaccinationName | varchar | 0 | 0 | 100 | False |
VaccinationName_ID | bigint | 19 | 0 | 8 | False |
VaccinationSchedulePart | int | 10 | 0 | 4 | False |
VaccinationReference¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
VaccinationContent | varchar | 0 | 0 | 50 | False |
VaccinationName | varchar | 0 | 0 | 100 | False |
VaccinationName_ID | int | 10 | 0 | 4 | False |
YCodeToSnomedMapping¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
SctConceptId | bigint | 19 | 0 | 8 | True |
YCode | varchar | 0 | 0 | 5 | False |
UK_Renal_Register¶
UKRR¶
ColumnName | ColumnType | Precision | Scale | MaxLength | IsNullable |
---|---|---|---|---|---|
creat | real | 24 | 0 | 4 | True |
dataset | varchar | 0 | 0 | 1000 | True |
eGFR_ckdepi | real | 24 | 0 | 4 | True |
mod_prev | varchar | 0 | 0 | 1000 | True |
mod_start | varchar | 0 | 0 | 1000 | True |
Patient_ID | bigint | 19 | 0 | 8 | False |
renal_centre | varchar | 0 | 0 | 1000 | True |
rrt_start | date | 10 | 0 | 3 | True |