Baselight
Sign In

USA Statewise Latest Covid-19 Data

Statewise Covid-19 data USA as on September 15, 2023

@kaggle.anandhuh_usa_statewise_latest_covid19_data

Usa Covid Data
@kaggle.anandhuh_usa_statewise_latest_covid19_data.usa_covid_data

  • 10.82 KB
  • 50 rows
  • 10 columns
usa_state

USA State

total_cases

Total Cases

total_deaths

Total Deaths

total_recovered

Total Recovered

active_cases

Active Cases

tot_cases_1m_pop

Tot Cases/ 1M Pop

deaths_1m_pop

Deaths/ 1M Pop

total_tests

Total Tests

tests_1m_pop

Tests/ 1M Pop

population

Population

Alabama1659936211381623935148633385424311933231719033174903185
Alaska30151314852989021126412159203047906406548661731545
Arizona25081683374924613331308634458946372248903530896987278717
Arkansas102997613246101277739533413004389803683126631393017804
California1239336110463412227662610653136592648202799362513257339512223
Colorado1801735153481776536985131287026652139675937155305758736
Connecticut98365212354969400189827589734651677319647045853565287
Delaware33672234633316961563345794355610260071053651973764
Florida775820790232761261255363361221420166800091311020221477737
Georgia315749143095307528339113297388405928915980272344610617423

CREATE TABLE usa_covid_data (
  "usa_state" VARCHAR,
  "total_cases" BIGINT,
  "total_deaths" BIGINT,
  "total_recovered" DOUBLE,
  "active_cases" DOUBLE,
  "tot_cases_1m_pop" BIGINT,
  "deaths_1m_pop" BIGINT,
  "total_tests" BIGINT,
  "tests_1m_pop" BIGINT,
  "population" BIGINT
);