About this Dataset

MD COVID-19 - MASTER Case Tracker

Note: Starting April 27, 2023 updates change from daily to weekly. Summary The cases, tests, positivity rates, hospitalizations, and confirmed and probable deaths for COVID-19 in Maryland. Description The MD COVID-19 - MASTER Case Tracker is a collection of Total Cases, Total Tests, Postivity Rates, Persons Tested Negative, Total Daily Hospital Beds, Total Ever Hospitalized, Total Persons Documented to Have Completed Home Isolation, Cases by County, Cases by Age Distribution, Cases by Gender Distribution, Cases by Race and Ethnicity Distribution, Confirmed Deaths Statewide, Confirmed Deaths by Date of Death, Confirmed Deaths by County, Confirmed Deaths by Age Distribution, Confirmed Deaths by Gender Distribution, Confirmed Deaths by Race And Ethnicity Distribution, Probable Deaths Statewide, Probable Deaths by Date of Death, Probable Deaths by County, Probable Deaths by Age Distribution, Probable Deaths by Gender Distribution, and Probable Deaths by Race And Ethnicity Distribution. Terms of Use The Spatial Data, and the information therein, (collectively the "Data") is provided "as is" without warranty of any kind, either expressed, implied, or statutory. The user assumes the entire risk as to quality and performance of the Data. No guarantee of accuracy is granted, nor is any responsibility for reliance thereon assumed. In no event shall the State of Maryland be liable for direct, indirect, incidental, consequential or special damages of any kind. The State of Maryland does not accept liability for any damages or misrepresentation caused by inaccuracies in the Data or as a result to changes to the Data, nor is there responsibility assumed to maintain the Data in any manner or form. The Data can be freely distributed as long as the metadata entry is not modified or deleted. Any data derived from the Data must acknowledge the State of Maryland in the metadata.
Organization: State of Maryland
Last updated: 2020-11-10T17:25:09.820313
Tags: 2019, coronavirus, covid, covid-19, data, department-of-health, disease, download, health, maryland, maryland-department-of-health, md, md-imap, mdh, open-data, outbreak, share

Tables

Table 1

@usgov.state_of_maryland_md_covid_19_master_case_tracker.table_1

779.85 kB
1,912 rows
163 columns

CREATE TABLE table_1 (
  "filter" VARCHAR,
  "reportdate" VARCHAR,
  "totalcases" BIGINT,
  "casedelta" BIGINT,
  "totaltests" DOUBLE,
  "testsdelta" DOUBLE,
  "postestpercent" DOUBLE,
  "pospercentdiff" DOUBLE,
  "negativetests" DOUBLE,
  "negdelta" BIGINT,
  "bedstotal" DOUBLE,
  "bedsacute" DOUBLE,
  "bedsicu" DOUBLE,
  "bedsdelta" DOUBLE,
  "total_hospitalized" DOUBLE,
  "hospitalizeddelta" BIGINT,
  "total_released" DOUBLE,
  "releaseddelta" BIGINT,
  "alle" BIGINT,
  "anne" BIGINT,
  "balt" BIGINT,
  "bcity" BIGINT,
  "calv" BIGINT,
  "caro" BIGINT,
  "carr" BIGINT,
  "ceci" BIGINT,
  "char" BIGINT,
  "dorc" BIGINT,
  "fred" BIGINT,
  "garr" BIGINT,
  "harf" BIGINT,
  "howa" BIGINT,
  "kent" BIGINT,
  "mont" BIGINT,
  "prin" BIGINT,
  "quee" BIGINT,
  "some" BIGINT,
  "stma" BIGINT,
  "talb" BIGINT,
  "wash" BIGINT,
  "wico" BIGINT,
  "worc" BIGINT,
  "unkn" BIGINT,
  "under18" VARCHAR,
  "n_18to64" VARCHAR  -- 18to64,
  "n_65plus" VARCHAR  -- 65plus,
  "case0to9" BIGINT,
  "case10to19" BIGINT,
  "case20to29" BIGINT,
  "case30to39" BIGINT,
  "case40to49" BIGINT,
  "case50to59" BIGINT,
  "case60to69" BIGINT,
  "case70to79" BIGINT,
  "case80plus" BIGINT,
  "caseageunknown" BIGINT,
  "genmale" BIGINT,
  "genfemale" BIGINT,
  "genunkn" BIGINT,
  "caseaframer" BIGINT,
  "casewhite" BIGINT,
  "casehispanic" BIGINT,
  "caseasian" BIGINT,
  "caseother" BIGINT,
  "casenotavail" BIGINT,
  "deaths" DOUBLE,
  "deathsdelta" DOUBLE,
  "deathdod" BIGINT,
  "deathalle" DOUBLE,
  "deathanne" DOUBLE,
  "deathbalt" DOUBLE,
  "deathbcity" DOUBLE,
  "deathcalv" DOUBLE,
  "deathcaro" DOUBLE,
  "deathcarr" DOUBLE,
  "deathceci" DOUBLE,
  "deathchar" DOUBLE,
  "deathdorc" DOUBLE,
  "deathfred" DOUBLE,
  "deathgarr" DOUBLE,
  "deathharf" DOUBLE,
  "deathhowa" DOUBLE,
  "deathkent" DOUBLE,
  "deathmont" DOUBLE,
  "deathprin" DOUBLE,
  "deathquee" DOUBLE,
  "deathsome" DOUBLE,
  "deathstma" DOUBLE,
  "deathtalb" DOUBLE,
  "deathwash" DOUBLE,
  "deathwico" DOUBLE,
  "deathworc" DOUBLE,
  "deathunkn" BIGINT,
  "death0to9" DOUBLE,
  "death10to19" DOUBLE,
  "death20to29" DOUBLE,
  "death30to39" DOUBLE,
  "death40to49" DOUBLE,
  "death50to59" DOUBLE,
  "death60to69" DOUBLE
);