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

26 rows where active = 6650 sorted by day descending

✎ View and edit SQL

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

These facets timed out: province_or_state

country_or_region 7

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
70737 70737 2021-09-01 Malaysia Melaka     48862 691 41521 6650 2.1896 102.2501 2021-09-02 04:21:15 Melaka, Malaysia
296063 296063 2021-07-15 Kenya       191020 3746 180624 6650 -0.0236 37.9062 2021-07-16 04:21:22 Kenya
1861336 1861336 2021-02-25 US Virginia Frederick 51069 6711 61 0 6650 39.20172582 -78.25974949 2021-02-26 05:22:40 Frederick, Virginia, US
3603854 3603854 2021-02-17 US South Carolina Greenwood 45047 6804 154 0 6650 34.15272415 -82.12715789 2021-02-18 05:22:58 Greenwood, South Carolina, US
3053535 3053535 2021-02-16 US Virginia Lynchburg 51680 6740 90 0 6650 37.40021399 -79.19888138 2021-02-17 05:23:10 Lynchburg, Virginia, US
1341634 1341634 2021-02-15 US Virginia Lynchburg 51680 6737 87 0 6650 37.40021399 -79.19888138 2021-02-16 05:24:38 Lynchburg, Virginia, US
1590246 1590246 2021-02-05 US Nebraska Hall 31079 6757 107 0 6650 40.87257079 -98.50218293 2021-02-06 05:23:55 Hall, Nebraska, US
793948 793948 2021-02-04 US Wisconsin Portage 55097 6714 64 0 6650 44.47558711 -89.50152965 2021-02-05 05:22:38 Portage, Wisconsin, US
1762229 1762229 2021-01-24 US Tennessee Greene 47059 6791 116 0 6650 36.17470125 -82.84691273 2021-01-25 05:22:16 Greene, Tennessee, US
1094165 1094165 2021-01-20 Mexico Campeche     7643 993 0 6650 19.8301 -90.5349 2021-01-21 05:22:01 Campeche, Mexico
3902245 3902245 2021-01-09 US North Carolina Caldwell 37027 6681 31 0 6650 35.95204977 -81.54799522 2021-01-10 05:22:12 Caldwell, North Carolina, US
157582 157582 2021-01-08 US Wyoming Natrona 56025 6751 101 0 6650 42.96180148 -106.797885 2021-01-09 05:22:18 Natrona, Wyoming, US
3769968 3769968 2020-12-22 Mexico Nayarit     7672 1022 0 6650 21.7514 -104.8455 2020-12-23 05:22:03 Nayarit, Mexico
1752744 1752744 2020-12-14 US Louisiana Ascension 22005 6761 111 0 6650 30.20406249 -90.91328409999998 2020-12-15 05:26:38 Ascension, Louisiana, US
3848497 3848497 2020-12-13 US Florida Martin 12085 6836 186 0 6650 27.0772071 -80.43109784 2020-12-14 05:26:27 Martin, Florida, US
863028 863028 2020-12-11 US North Carolina Rowan 37159 6798 148 0 6650 35.64003916 -80.52446628 2020-12-12 05:26:19 Rowan, North Carolina, US
2978355 2978355 2020-12-09 US Texas Kaufman 48257 6315 92 0 6650 32.599141700000004 -96.28734728 2020-12-10 05:26:19 Kaufman, Texas, US
2701724 2701724 2020-11-20 Russia Krasnoyarsk Krai     32886 903 25333 6650 63.3233807 97.0979974 2020-11-21 05:25:51 Krasnoyarsk Krai, Russia
895104 895104 2020-11-05 US Tennessee Sumner 47165 6725 120 0 6650 36.46824103 -86.45917204 2020-11-06 05:24:55 Sumner, Tennessee, US
3304436 3304436 2020-11-02 Russia Saratov Oblast     20901 158 14093 6650 51.6520555 46.86319520000001 2020-11-03 06:00:16 Saratov Oblast, Russia
213898 213898 2020-10-29 West Bank and Gaza       52571 473 45448 6650 31.9522 35.2332 2020-10-30 04:24:49 West Bank and Gaza
3786465 3786465 2020-10-11 US California Solano 6095 6701 53 0 6650 38.26827353 -121.9357113 2020-10-12 04:23:45 Solano, California, US
3120126 3120126 2020-10-06 US Pennsylvania Chester 42029 7025 375 0 6650 39.97291773 -75.74768357 2020-10-07 04:23:40 Chester, Pennsylvania, US
2816097 2816097 2020-09-25 US Virginia Loudoun 51107 6774 124 0 6650 39.08990083 -77.63481877 2020-09-26 04:23:00 Loudoun, Virginia, US
2633150 2633150 2020-06-29 India Uttar Pradesh     22828 672 15506 6650 26.925425 80.560982 2020-06-30 04:33:48 Uttar Pradesh, India
2554616 2554616 2020-06-02 US Louisiana Orleans 22071 7156 506 0 6650 30.06971951 -89.92660315 2020-06-03 02:33:13 Orleans, Louisiana, 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]);