Dataset: Impact Of COVID On Black Communities

About this Dataset

Impact Of COVID On Black Communities

Context

In this critical moment, COVID-19 data is being collected, released, analyzed, interpreted, and used to inform recovery and response efforts. D4BL has worked to consolidate state level data to explore the disproportionate impact of COVID-19 on Black people in the US. The D4BL COVID-19 Dataset captures state-level COVID-19 cases and deaths for Black people in the United States. D4BL established a team of volunteer data scientists to develop a codebase for automating the data extraction from state websites and storing it into this dataset

Content

Impact of COVID 19 on Black Communities in USA.

Acknowledgements

https://d4bl.org/

Inspiration

Impact (social / financial & other) on certain communities in USA.

Tables

Latest Combined Output

@kaggle.kkhandekar_impact_of_covid_on_black_communities.latest_combined_output

227.71 KB
6554 rows
23 columns


CREATE TABLE latest_combined_output (
  "date_combined" TIMESTAMP,
  "date_time_combined" VARCHAR,
  "unnamed_0" BIGINT,
  "unnamed_0_1" VARCHAR,
  "location" VARCHAR,
  "date_published" VARCHAR,
  "total_cases" DOUBLE,
  "total_deaths" DOUBLE,
  "pct_cases_black_aa" DOUBLE,
  "pct_deaths_black_aa" DOUBLE,
  "date_run" TIMESTAMP,
  "status_code" VARCHAR,
  "count_cases_black_aa" DOUBLE,
  "count_deaths_black_aa" VARCHAR,
  "pct_includes_unknown_race" VARCHAR,
  "pct_includes_hispanic_black" VARCHAR,
  "count_cases_known_race" DOUBLE,
  "count_deaths_known_race" DOUBLE,
  "black_aa_population" DOUBLE,
  "pct_black_aa_population" DOUBLE,
  "date_time_run" VARCHAR,
  "date_run_1" TIMESTAMP,
  "date_time_run_1" VARCHAR
);