         ON (f.id = d.id)
 ;
 
+ALTER TABLE dw_morbidity_diseases
+    ADD CONSTRAINT dw_morbidity_diseases_pkey PRIMARY KEY (id);
+
 CREATE TABLE dw_contact_diseases AS
 SELECT
     d.*

WHERE
    p.type = 'Clinician'
;

CREATE TABLE dw_events_diagnostic_facilities AS
SELECT

    )
;

ALTER TABLE dw_secondary_jurisdictions
    ADD CONSTRAINT dw_secondary_jurisdictions_pkey PRIMARY KEY (id, jurisdiction_id);
CREATE INDEX dw_secondary_jurisdictions_morbidity_id_ix
    ON dw_secondary_jurisdictions (dw_morbidity_events_id);
CREATE INDEX dw_secondary_jurisdictions_contact_id_ix
    ON dw_secondary_jurisdictions (dw_contact_events_id);
CREATE INDEX dw_secondary_jurisdictions_jurisdiction_id_ix
    ON dw_secondary_jurisdictions (jurisdiction_id);

CREATE TABLE dw_events_hospitals AS
SELECT
