Covid County Data

Cases, deaths, testing, mobility, and NPI

@kaggle.cc7768_covid_county_data

Table List

3 tables(17.9 MB)

Covid County Data

Mobility Dex

Npi Us

Covid County Data

@kaggle.cc7768_covid_county_data.covid_county_data

7.29 MB
742606 rows
33 columns

unnamed_0 Unnamed: 0	dt Dt	location Location	fips Fips	negative_tests_total Negative Tests Total	positive_tests_total Positive Tests Total	tests_total Tests Total
1	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18	18		1	1
2	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	29	29	7		7
3	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18001	18001
4	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18003	18003
5	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18005	18005		1	1
6	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18007	18007
7	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18009	18009
8	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18011	18011
9	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18013	18013
10	Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18015	18015


CREATE TABLE covid_county_data (
  "unnamed_0" BIGINT,
  "dt" TIMESTAMP,
  "location" BIGINT,
  "fips" BIGINT,
  "active_total" DOUBLE,
  "cases_confirmed" DOUBLE,
  "cases_suspected" DOUBLE,
  "cases_total" DOUBLE,
  "deaths_confirmed" DOUBLE,
  "deaths_suspected" DOUBLE,
  "deaths_total" DOUBLE,
  "hospital_beds_capacity_count" DOUBLE,
  "hospital_beds_in_use_any" DOUBLE,
  "hospital_beds_in_use_covid_confirmed" DOUBLE,
  "hospital_beds_in_use_covid_new" DOUBLE,
  "hospital_beds_in_use_covid_suspected" DOUBLE,
  "hospital_beds_in_use_covid_total" DOUBLE,
  "icu_beds_capacity_count" DOUBLE,
  "icu_beds_in_use_any" DOUBLE,
  "icu_beds_in_use_covid_confirmed" DOUBLE,
  "icu_beds_in_use_covid_suspected" DOUBLE,
  "icu_beds_in_use_covid_total" DOUBLE,
  "negative_tests_total" DOUBLE,
  "num_hospitals_reporting" DOUBLE,
  "num_of_hospitals" DOUBLE,
  "positive_tests_total" DOUBLE,
  "recovered_total" DOUBLE,
  "tests_total" DOUBLE,
  "ventilators_capacity_count" DOUBLE,
  "ventilators_in_use_any" DOUBLE,
  "ventilators_in_use_covid_confirmed" DOUBLE,
  "ventilators_in_use_covid_suspected" DOUBLE,
  "ventilators_in_use_covid_total" DOUBLE
);