johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

15 rows where country_or_region = "US", deaths = 272 and province_or_state = "Oklahoma" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Oklahoma · 15 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
3024867 3024867 2022-03-23 US Oklahoma Pottawatomie 40125 20543 272 0   35.20614018 -96.94923008 2022-03-24 04:20:43 Pottawatomie, Oklahoma, US
1907789 1907789 2022-03-22 US Oklahoma Pottawatomie 40125 20543 272 0   35.20614018 -96.94923008 2022-03-23 04:20:48 Pottawatomie, Oklahoma, US
3240920 3240920 2022-03-21 US Oklahoma Pottawatomie 40125 20543 272 0   35.20614018 -96.94923008 2022-03-22 04:20:54 Pottawatomie, Oklahoma, US
26993 26993 2022-03-20 US Oklahoma Pottawatomie 40125 20543 272 0   35.20614018 -96.94923008 2022-03-21 04:20:50 Pottawatomie, Oklahoma, US
1659003 1659003 2022-03-19 US Oklahoma Pottawatomie 40125 20543 272 0   35.20614018 -96.94923008 2022-03-20 04:20:45 Pottawatomie, Oklahoma, US
338529 338529 2022-03-18 US Oklahoma Pottawatomie 40125 20543 272 0   35.20614018 -96.94923008 2022-03-19 04:20:47 Pottawatomie, Oklahoma, US
696982 696982 2022-03-17 US Oklahoma Pottawatomie 40125 20543 272 0   35.20614018 -96.94923008 2022-03-18 04:20:55 Pottawatomie, Oklahoma, US
2321885 2321885 2022-03-16 US Oklahoma Garfield 40047 15131 272 0   36.3791334 -97.78265517 2022-03-17 04:20:56 Garfield, Oklahoma, US
264085 264085 2022-03-15 US Oklahoma Garfield 40047 15131 272 0   36.3791334 -97.78265517 2022-03-16 04:20:50 Garfield, Oklahoma, US
2266444 2266444 2022-03-14 US Oklahoma Garfield 40047 15131 272 0   36.3791334 -97.78265517 2022-03-15 04:20:47 Garfield, Oklahoma, US
3630510 3630510 2022-03-13 US Oklahoma Garfield 40047 15131 272 0   36.3791334 -97.78265517 2022-03-14 04:20:46 Garfield, Oklahoma, US
953418 953418 2022-03-12 US Oklahoma Garfield 40047 15131 272 0   36.3791334 -97.78265517 2022-03-13 04:20:49 Garfield, Oklahoma, US
358879 358879 2022-03-11 US Oklahoma Garfield 40047 15131 272 0   36.3791334 -97.78265517 2022-03-12 04:20:50 Garfield, Oklahoma, US
1868031 1868031 2022-03-10 US Oklahoma Garfield 40047 15131 272 0   36.3791334 -97.78265517 2022-03-11 04:20:50 Garfield, Oklahoma, US
2704081 2704081 2020-11-20 US Oklahoma Oklahoma 40109 33851 272 0 33579 35.55140095 -97.40716948 2020-11-21 05:25:51 Oklahoma, Oklahoma, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);