DROP TABLE IF EXISTS CovidData_@{replace(item().HHSRegion, ' ', '_')};

CREATE TABLE CovidData_@{replace(item().HHSRegion, ' ', '_')}
(
    DataAsOf DATE,
    StartDate DATE,
    EndDate DATE,
    [Group] VARCHAR(255),
    Year VARCHAR(255),
    Month VARCHAR(255),
    MMWRWeek INT,
    WeekEndingDate DATE,
    RaceAndHispanicOriginGroup VARCHAR(255),
    AgeGroup VARCHAR(255),
    Covid19Deaths INT,
    TotalDeaths INT
);