Covid County Data
Cases, deaths, testing, mobility, and NPI
@kaggle.cc7768_covid_county_data
Cases, deaths, testing, mobility, and NPI
@kaggle.cc7768_covid_county_data
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
);
CREATE TABLE mobility_dex (
"unnamed_0" BIGINT,
"dt" TIMESTAMP,
"location" BIGINT,
"dex" DOUBLE,
"dex_a" DOUBLE,
"num_devices" DOUBLE,
"num_devices_a" DOUBLE
);
CREATE TABLE npi_us (
"unnamed_0" BIGINT,
"dt" TIMESTAMP,
"location" BIGINT,
"closing_of_public_venues" BOOLEAN,
"gathering_size_100_26" BOOLEAN,
"gathering_size_10_0" BOOLEAN,
"gathering_size_25_11" BOOLEAN,
"gathering_size_500_101" BOOLEAN,
"lockdown" BOOLEAN,
"non_essential_services_closure" BOOLEAN,
"religious_gatherings_banned" BOOLEAN,
"shelter_in_place" BOOLEAN,
"social_distancing" BOOLEAN
);
Anyone who has the link will be able to view this.