Table names and paths
Please note: all table paths start with ‘dars_nic_391419_j3w9t_collab.’ (eg. dars_nic_391419_j3w9t_collab.gdppr_dars_nic_391419_j3w9t_archive)
| Dataset | Table Name | Table Path |
|---|---|---|
| GDPPR | gdppr | gdppr_dars_nic_391419_j3w9t_archive |
| HES APC | hes_apc | hes_apc_all_years_archive |
| HES APC OTR | hes_apc_otr | hes_apc_otr_all_years_archive |
| HES APC ACP | hes_apc_acp | hes_apc_acp_all_years_archive |
| HES APC MAT | hes_apc_mat | hes_apc_mat_all_years_archive |
| HES AE | hes_ae | hes_ae_all_years_archive |
| HES AE OTR | hes_ae_otr | hes_ae_all_years_otr_archive |
| HES CC | hes_cc | hes_cc_all_years_archive |
| HES CC OTR | hes_cc_otr | hes_cc_otr_all_years_archive |
| HES OP | hes_op | hes_op_all_years_archive |
| HES OP OTR | hes_op_otr | hes_op_otr_all_years_archive |
| SUS | sus | sus_dars_nic_391419_j3w9t_archive |
| Uncurated Low Latency - APC | lowlat_apc | lowlat_apc_all_years_archive |
| Uncurated Low Latency - CC | lowlat_cc | lowlat_cc_all_years_archive |
| Uncurated Low Latency - OP | lowlat_op | lowlat_op_all_years_archive |
| ECDS | lowlat_ecds | lowlat_ecds_all_years_archive |
| SGSS | sgss | sgss_dars_nic_391419_j3w9t_archive |
| Pillar 2 Antigen | covid_antibody_testing_pillar3 | covid_antibody_testing_pillar3_dars_nic_391419_j3w9t_archive |
| Pillar 3 Antibody | covid_antibody_testing_pillar2 | covid_antibody_testing_pillar3_dars_nic_391419_j3w9t_archive |
| COVID-19 vaccination status | vaccine_status | vaccine_status_dars_nic_391419_j3w9t_archive |
| COVID-19 vaccination adverse reactions | vaccine_adverse_reactions | vaccine_adverse_reactions_dars_nic_391419_j3w9t_archive |
| Civil Registry Deaths | deaths | deaths_dars_nic_391419_j3w9t_archive |
| ICNARC COVID | icnarc | icnarc_dars_nic_391419_j3w9t_archive |
| COVID-19 SARI-Watch (formerly CHESS) | chess | chess_dars_nic_391419_j3w9t_archive |
| NHS BSA Dispensed Medicines | primary_care_meds | primary_care_meds_dars_nic_391419_j3w9t_archive |
| EPMA - Administration | epma_administration | epma_administration_dars_nic_391419_j3w9t_archive |
| EPMA - Administration DMD | epma_administration_dmd | epma_administration_dmd_dars_nic_391419_j3w9t_archive |
| EPMA - Administration Dosage | epma_administration_dosage | epma_administration_dosage_dars_nic_391419_j3w9t_archive |
| EPMA - Prescription | epma_prescription | epma_prescription_dars_nic_391419_j3w9t_archive |
| EPMA - Prescription DMD | epma_prescription_dmd | epma_prescription_dmd_dars_nic_391419_j3w9t_archive |
| EPMA - Prescription Dosage | epma_prescription_dosage | epma_prescription_dosage_dars_nic_391419_j3w9t_archive |
| EPMA - Prescription Chemical | epma_prescription_chemical | epma_prescription_chemical_dars_nic_391419_j3w9t_archive |
| NICOR - MINAP | nicor_minap | nicor_minap_dars_nic_391419_j3w9t_archive |
| NICOR - NACRM | nicor_crm_eps | nicor_crm_eps_dars_nic_391419_j3w9t_archive |
| NICOR - NACRM | nicor_crm_pmicd | nicor_crm_pmicd_dars_nic_391419_j3w9t_archive |
| NICOR - NACSA | nicor_acs_combined | nicor_acs_combined_dars_nic_391419_j3w9t_archive |
| NICOR - NCHDA | nicor_congenital | nicor_congenital_dars_nic_391419_j3w9t_archive |
| NICOR - NHFA | nicor_hf | nicor_hf_dars_nic_391419_j3w9t_archive |
| NICOR - NHFA v5 | nicor_hf_v5 | nicor_hf_v5_dars_nic_391419_j3w9t_archive |
| NICOR - PCI | nicor_pci | nicor_pci_dars_nic_391419_j3w9t_archive |
| NICOR - TAVI | nicor_tavi | nicor_tavi_dars_nic_391419_j3w9t_archive |
| SSNAP | ssnap | ssnap_dars_nic_391419_j3w9t_archive |
| IAPT - Care Activities | iapt_v2_1_care_activities | iapt_v2_1_care_activities_all_years_archive |
| IAPT - Care Cluster | iapt_v2_1_care_cluster | iapt_v2_1_care_cluster_all_years_archive |
| IAPT - Coded Scored Assessments | iapt_v2_1_coded_scored_assessments | iapt_v2_1_coded_scored_assessments_all_years_archive |
| IAPT - Demographics and Referral | iapt_v2_1_demographics_and_referral | iapt_v2_1_demographics_and_referral_all_years_archive |
| IAPT - Employment Status | iapt_v2_1_employment_status | iapt_v2_1_employment_status_all_years_archive |
| IAPT - Internet Enabled Therapies | iapt_v2_1_internet_enabled_therapies | iapt_v2_1_internet_enabled_therapies_all_years_archive |
| IAPT - Mental and Physical Health Conditions | iapt_v2_1_mental_and_physical_health_conditions | iapt_v2_1_mental_and_physical_health_conditions_all_years_archive |
| IAPT - Onward Referrals | iapt_v2_1_onward_referrals | iapt_v2_1_onward_referrals_all_years_archive |
| IAPT - Waiting Time Pauses | iapt_v2_1_waiting_time_pauses | iapt_v2_1_waiting_time_pauses_all_years_archive |
| MSDS - Baby Activities | msds_v2_baby_activities | msds_v2_baby_activities_all_years_archive |
| MSDS - Baby Demographics | msds_v2_baby_demographics | msds_v2_baby_demographics_all_years_archive |
| MSDS - Baby Diagnoses | msds_v2_baby_diagnoses | msds_v2_baby_diagnoses_all_years_archive |
| MSDS - Care Activities | msds_v2_care_activities | msds_v2_care_activities_all_years_archive |
| MSDS - Coded Scored Assessments | msds_v2_coded_scored_assessments | msds_v2_coded_scored_assessments_all_years_archive |
| MSDS - Demographics Bookings and Pregnancy | msds_v2_demographics_booking_and_pregnancy | msds_v2_demographics_booking_and_pregnancy_all_years_archive |
| MSDS - Diagnoses and History | msds_v2_diagnoses_and_history | msds_v2_diagnoses_and_history_all_years_archive |
| MSDS - Findings and Observations | msds_v2_findings_and_observations | msds_v2_findings_and_observations_all_years_archive |
| MSDS - Hospital Provider Spell | msds_v2_hospital_provider_spell | msds_v2_hospital_provider_spell_all_years_archive |
| MSDS - Labour Activities | msds_v2_labour_activities | msds_v2_labour_activities_all_years_archive |
| MSDS - Maternity Care Plan | msds_v2_maternity_care_plan | msds_v2_maternity_care_plan_all_years_archive |
| MHSDS | mhs{table_name} | mhs{table_name}_dars_nic_391419_j3w9t_archive |