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

25,602 rows where deaths = 23 sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

These facets timed out: province_or_state

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2756413 2756413 2022-12-29 US West Virginia Pendleton 54071 2297 23 0   38.68314479 -79.35084086 2022-12-30 04:21:04 Pendleton, West Virginia, US
2756388 2756388 2022-12-29 US West Virginia Gilmer 54021 2521 23 0   38.9251277 -80.85952723 2022-12-30 04:21:04 Gilmer, West Virginia, US
2756324 2756324 2022-12-29 US Virginia Surry 51181 1365 23 0   37.11781893 -76.88450012 2022-12-30 04:21:04 Surry, Virginia, US
2755548 2755548 2022-12-29 US Oregon Wallowa 41063 1545 23 0   45.57894064 -117.183538 2022-12-30 04:21:04 Wallowa, Oregon, US
2755331 2755331 2022-12-29 US North Dakota Richland 38077 4687 23 0   46.26440649 -96.94852979 2022-12-30 04:21:04 Richland, North Dakota, US
2755308 2755308 2022-12-29 US North Dakota Foster 38031 1125 23 0   47.4571084 -98.88279923 2022-12-30 04:21:04 Foster, North Dakota, US
2755295 2755295 2022-12-29 US North Dakota Benson 38005 2245 23 0   48.0683985 -99.35916363 2022-12-30 04:21:04 Benson, North Dakota, US
2755109 2755109 2022-12-29 US New Mexico Los Alamos 35028 4528 23 0   35.86631386 -106.3134985 2022-12-30 04:21:04 Los Alamos, New Mexico, US
2755060 2755060 2022-12-29 US Nevada White Pine 32033 1777 23 0   39.44157041 -114.899966 2022-12-30 04:21:04 White Pine, Nevada, US
2755021 2755021 2022-12-29 US Nebraska Red Willow 31145 2566 23 0   40.1755688 -100.476998 2022-12-30 04:21:04 Red Willow, Nebraska, US
2754959 2754959 2022-12-29 US Nebraska Burt 31021 1467 23 0   41.85056773 -96.32605633 2022-12-30 04:21:04 Burt, Nebraska, US
2754292 2754292 2022-12-29 US Kentucky Carlisle 21039 1315 23 0   36.85372876 -88.9669222 2022-12-30 04:21:04 Carlisle, Kentucky, US
2754257 2754257 2022-12-29 US Kansas Sherman 20181 1779 23 0   39.35147699 -101.7197624 2022-12-30 04:21:04 Sherman, Kansas, US
2754200 2754200 2022-12-29 US Kansas Gray 20069 1384 23 0   37.73836671 -100.4369088 2022-12-30 04:21:04 Gray, Kansas, US
2754197 2754197 2022-12-29 US Kansas Gove 20063 918 23 0   38.91588178 -100.4829321 2022-12-30 04:21:04 Gove, Kansas, US
2754070 2754070 2022-12-29 US Iowa Audubon 19009 1289 23 0   41.6844628 -94.90581859 2022-12-30 04:21:04 Audubon, Iowa, US
2754054 2754054 2022-12-29 US Indiana Union 18161 2285 23 0   39.62550777 -84.92497066 2022-12-30 04:21:04 Union, Indiana, US
2753943 2753943 2022-12-29 US Illinois Piatt 17147 5434 23 0   40.01360584 -88.59319339 2022-12-30 04:21:04 Piatt, Illinois, US
2753499 2753499 2022-12-29 US California Trinity 6105 1906 23 0   40.6491767 -123.114713 2022-12-30 04:21:04 Trinity, California, US
2752697 2752697 2022-12-29 China Henan     9089 23 0   33.882 113.614 2022-12-30 04:21:04 Henan, China
1077419 1077419 2022-12-28 US West Virginia Pendleton 54071 2296 23 0   38.68314479 -79.35084086 2022-12-29 04:21:01 Pendleton, West Virginia, US
1077394 1077394 2022-12-28 US West Virginia Gilmer 54021 2520 23 0   38.9251277 -80.85952723 2022-12-29 04:21:01 Gilmer, West Virginia, US
1077330 1077330 2022-12-28 US Virginia Surry 51181 1365 23 0   37.11781893 -76.88450012 2022-12-29 04:21:01 Surry, Virginia, US
1076554 1076554 2022-12-28 US Oregon Wallowa 41063 1545 23 0   45.57894064 -117.183538 2022-12-29 04:21:01 Wallowa, Oregon, US
1076337 1076337 2022-12-28 US North Dakota Richland 38077 4687 23 0   46.26440649 -96.94852979 2022-12-29 04:21:01 Richland, North Dakota, US
1076314 1076314 2022-12-28 US North Dakota Foster 38031 1125 23 0   47.4571084 -98.88279923 2022-12-29 04:21:01 Foster, North Dakota, US
1076301 1076301 2022-12-28 US North Dakota Benson 38005 2245 23 0   48.0683985 -99.35916363 2022-12-29 04:21:01 Benson, North Dakota, US
1076115 1076115 2022-12-28 US New Mexico Los Alamos 35028 4528 23 0   35.86631386 -106.3134985 2022-12-29 04:21:01 Los Alamos, New Mexico, US
1076066 1076066 2022-12-28 US Nevada White Pine 32033 1777 23 0   39.44157041 -114.899966 2022-12-29 04:21:01 White Pine, Nevada, US
1076027 1076027 2022-12-28 US Nebraska Red Willow 31145 2566 23 0   40.1755688 -100.476998 2022-12-29 04:21:01 Red Willow, Nebraska, US
1075965 1075965 2022-12-28 US Nebraska Burt 31021 1467 23 0   41.85056773 -96.32605633 2022-12-29 04:21:01 Burt, Nebraska, US
1075298 1075298 2022-12-28 US Kentucky Carlisle 21039 1315 23 0   36.85372876 -88.9669222 2022-12-29 04:21:01 Carlisle, Kentucky, US
1075263 1075263 2022-12-28 US Kansas Sherman 20181 1779 23 0   39.35147699 -101.7197624 2022-12-29 04:21:01 Sherman, Kansas, US
1075206 1075206 2022-12-28 US Kansas Gray 20069 1384 23 0   37.73836671 -100.4369088 2022-12-29 04:21:01 Gray, Kansas, US
1075203 1075203 2022-12-28 US Kansas Gove 20063 918 23 0   38.91588178 -100.4829321 2022-12-29 04:21:01 Gove, Kansas, US
1075076 1075076 2022-12-28 US Iowa Audubon 19009 1289 23 0   41.6844628 -94.90581859 2022-12-29 04:21:01 Audubon, Iowa, US
1075060 1075060 2022-12-28 US Indiana Union 18161 2285 23 0   39.62550777 -84.92497066 2022-12-29 04:21:01 Union, Indiana, US
1074949 1074949 2022-12-28 US Illinois Piatt 17147 5424 23 0   40.01360584 -88.59319339 2022-12-29 04:21:01 Piatt, Illinois, US
1074505 1074505 2022-12-28 US California Trinity 6105 1906 23 0   40.6491767 -123.114713 2022-12-29 04:21:01 Trinity, California, US
1073703 1073703 2022-12-28 China Henan     9089 23 0   33.882 113.614 2022-12-29 04:21:01 Henan, China
331416 331416 2022-12-27 US West Virginia Pendleton 54071 2295 23 0   38.68314479 -79.35084086 2022-12-28 04:21:04 Pendleton, West Virginia, US
331391 331391 2022-12-27 US West Virginia Gilmer 54021 2519 23 0   38.9251277 -80.85952723 2022-12-28 04:21:04 Gilmer, West Virginia, US
331327 331327 2022-12-27 US Virginia Surry 51181 1362 23 0   37.11781893 -76.88450012 2022-12-28 04:21:04 Surry, Virginia, US
331164 331164 2022-12-27 US Texas Wheeler 48483 1304 23 0   35.40114335 -100.2699514 2022-12-28 04:21:04 Wheeler, Texas, US
330551 330551 2022-12-27 US Oregon Wallowa 41063 1542 23 0   45.57894064 -117.183538 2022-12-28 04:21:04 Wallowa, Oregon, US
330334 330334 2022-12-27 US North Dakota Richland 38077 4687 23 0   46.26440649 -96.94852979 2022-12-28 04:21:04 Richland, North Dakota, US
330311 330311 2022-12-27 US North Dakota Foster 38031 1125 23 0   47.4571084 -98.88279923 2022-12-28 04:21:04 Foster, North Dakota, US
330298 330298 2022-12-27 US North Dakota Benson 38005 2245 23 0   48.0683985 -99.35916363 2022-12-28 04:21:04 Benson, North Dakota, US
330112 330112 2022-12-27 US New Mexico Los Alamos 35028 4528 23 0   35.86631386 -106.3134985 2022-12-28 04:21:04 Los Alamos, New Mexico, US
330063 330063 2022-12-27 US Nevada White Pine 32033 1777 23 0   39.44157041 -114.899966 2022-12-28 04:21:04 White Pine, Nevada, US
330024 330024 2022-12-27 US Nebraska Red Willow 31145 2566 23 0   40.1755688 -100.476998 2022-12-28 04:21:04 Red Willow, Nebraska, US
329962 329962 2022-12-27 US Nebraska Burt 31021 1467 23 0   41.85056773 -96.32605633 2022-12-28 04:21:04 Burt, Nebraska, US
329295 329295 2022-12-27 US Kentucky Carlisle 21039 1315 23 0   36.85372876 -88.9669222 2022-12-28 04:21:04 Carlisle, Kentucky, US
329260 329260 2022-12-27 US Kansas Sherman 20181 1774 23 0   39.35147699 -101.7197624 2022-12-28 04:21:04 Sherman, Kansas, US
329203 329203 2022-12-27 US Kansas Gray 20069 1371 23 0   37.73836671 -100.4369088 2022-12-28 04:21:04 Gray, Kansas, US
329200 329200 2022-12-27 US Kansas Gove 20063 915 23 0   38.91588178 -100.4829321 2022-12-28 04:21:04 Gove, Kansas, US
329073 329073 2022-12-27 US Iowa Audubon 19009 1286 23 0   41.6844628 -94.90581859 2022-12-28 04:21:04 Audubon, Iowa, US
329057 329057 2022-12-27 US Indiana Union 18161 2285 23 0   39.62550777 -84.92497066 2022-12-28 04:21:04 Union, Indiana, US
328946 328946 2022-12-27 US Illinois Piatt 17147 5421 23 0   40.01360584 -88.59319339 2022-12-28 04:21:04 Piatt, Illinois, US
328502 328502 2022-12-27 US California Trinity 6105 1906 23 0   40.6491767 -123.114713 2022-12-28 04:21:04 Trinity, California, US
327700 327700 2022-12-27 China Henan     9089 23 0   33.882 113.614 2022-12-28 04:21:04 Henan, China
221489 221489 2022-12-26 US West Virginia Pendleton 54071 2293 23 0   38.68314479 -79.35084086 2022-12-27 04:21:07 Pendleton, West Virginia, US
221464 221464 2022-12-26 US West Virginia Gilmer 54021 2519 23 0   38.9251277 -80.85952723 2022-12-27 04:21:07 Gilmer, West Virginia, US
221400 221400 2022-12-26 US Virginia Surry 51181 1362 23 0   37.11781893 -76.88450012 2022-12-27 04:21:07 Surry, Virginia, US
221237 221237 2022-12-26 US Texas Wheeler 48483 1304 23 0   35.40114335 -100.2699514 2022-12-27 04:21:07 Wheeler, Texas, US
220624 220624 2022-12-26 US Oregon Wallowa 41063 1542 23 0   45.57894064 -117.183538 2022-12-27 04:21:07 Wallowa, Oregon, US
220407 220407 2022-12-26 US North Dakota Richland 38077 4687 23 0   46.26440649 -96.94852979 2022-12-27 04:21:07 Richland, North Dakota, US
220384 220384 2022-12-26 US North Dakota Foster 38031 1125 23 0   47.4571084 -98.88279923 2022-12-27 04:21:07 Foster, North Dakota, US
220371 220371 2022-12-26 US North Dakota Benson 38005 2245 23 0   48.0683985 -99.35916363 2022-12-27 04:21:07 Benson, North Dakota, US
220185 220185 2022-12-26 US New Mexico Los Alamos 35028 4528 23 0   35.86631386 -106.3134985 2022-12-27 04:21:07 Los Alamos, New Mexico, US
220136 220136 2022-12-26 US Nevada White Pine 32033 1777 23 0   39.44157041 -114.899966 2022-12-27 04:21:07 White Pine, Nevada, US
220097 220097 2022-12-26 US Nebraska Red Willow 31145 2566 23 0   40.1755688 -100.476998 2022-12-27 04:21:07 Red Willow, Nebraska, US
220035 220035 2022-12-26 US Nebraska Burt 31021 1467 23 0   41.85056773 -96.32605633 2022-12-27 04:21:07 Burt, Nebraska, US
219368 219368 2022-12-26 US Kentucky Carlisle 21039 1311 23 0   36.85372876 -88.9669222 2022-12-27 04:21:07 Carlisle, Kentucky, US
219333 219333 2022-12-26 US Kansas Sherman 20181 1774 23 0   39.35147699 -101.7197624 2022-12-27 04:21:07 Sherman, Kansas, US
219276 219276 2022-12-26 US Kansas Gray 20069 1371 23 0   37.73836671 -100.4369088 2022-12-27 04:21:07 Gray, Kansas, US
219273 219273 2022-12-26 US Kansas Gove 20063 915 23 0   38.91588178 -100.4829321 2022-12-27 04:21:07 Gove, Kansas, US
219146 219146 2022-12-26 US Iowa Audubon 19009 1286 23 0   41.6844628 -94.90581859 2022-12-27 04:21:07 Audubon, Iowa, US
219130 219130 2022-12-26 US Indiana Union 18161 2285 23 0   39.62550777 -84.92497066 2022-12-27 04:21:07 Union, Indiana, US
219019 219019 2022-12-26 US Illinois Piatt 17147 5414 23 0   40.01360584 -88.59319339 2022-12-27 04:21:07 Piatt, Illinois, US
218575 218575 2022-12-26 US California Trinity 6105 1902 23 0   40.6491767 -123.114713 2022-12-27 04:21:07 Trinity, California, US
217773 217773 2022-12-26 China Henan     9089 23 0   33.882 113.614 2022-12-27 04:21:07 Henan, China
3225946 3225946 2022-12-25 US West Virginia Pendleton 54071 2293 23 0   38.68314479 -79.35084086 2022-12-26 04:21:06 Pendleton, West Virginia, US
3225921 3225921 2022-12-25 US West Virginia Gilmer 54021 2519 23 0   38.9251277 -80.85952723 2022-12-26 04:21:06 Gilmer, West Virginia, US
3225857 3225857 2022-12-25 US Virginia Surry 51181 1357 23 0   37.11781893 -76.88450012 2022-12-26 04:21:06 Surry, Virginia, US
3225694 3225694 2022-12-25 US Texas Wheeler 48483 1304 23 0   35.40114335 -100.2699514 2022-12-26 04:21:06 Wheeler, Texas, US
3225081 3225081 2022-12-25 US Oregon Wallowa 41063 1542 23 0   45.57894064 -117.183538 2022-12-26 04:21:06 Wallowa, Oregon, US
3224864 3224864 2022-12-25 US North Dakota Richland 38077 4687 23 0   46.26440649 -96.94852979 2022-12-26 04:21:06 Richland, North Dakota, US
3224841 3224841 2022-12-25 US North Dakota Foster 38031 1125 23 0   47.4571084 -98.88279923 2022-12-26 04:21:06 Foster, North Dakota, US
3224828 3224828 2022-12-25 US North Dakota Benson 38005 2245 23 0   48.0683985 -99.35916363 2022-12-26 04:21:06 Benson, North Dakota, US
3224642 3224642 2022-12-25 US New Mexico Los Alamos 35028 4528 23 0   35.86631386 -106.3134985 2022-12-26 04:21:06 Los Alamos, New Mexico, US
3224593 3224593 2022-12-25 US Nevada White Pine 32033 1777 23 0   39.44157041 -114.899966 2022-12-26 04:21:06 White Pine, Nevada, US
3224554 3224554 2022-12-25 US Nebraska Red Willow 31145 2566 23 0   40.1755688 -100.476998 2022-12-26 04:21:06 Red Willow, Nebraska, US
3224492 3224492 2022-12-25 US Nebraska Burt 31021 1467 23 0   41.85056773 -96.32605633 2022-12-26 04:21:06 Burt, Nebraska, US
3223825 3223825 2022-12-25 US Kentucky Carlisle 21039 1311 23 0   36.85372876 -88.9669222 2022-12-26 04:21:06 Carlisle, Kentucky, US
3223790 3223790 2022-12-25 US Kansas Sherman 20181 1774 23 0   39.35147699 -101.7197624 2022-12-26 04:21:06 Sherman, Kansas, US
3223733 3223733 2022-12-25 US Kansas Gray 20069 1371 23 0   37.73836671 -100.4369088 2022-12-26 04:21:06 Gray, Kansas, US
3223730 3223730 2022-12-25 US Kansas Gove 20063 915 23 0   38.91588178 -100.4829321 2022-12-26 04:21:06 Gove, Kansas, US
3223603 3223603 2022-12-25 US Iowa Audubon 19009 1286 23 0   41.6844628 -94.90581859 2022-12-26 04:21:06 Audubon, Iowa, US
3223587 3223587 2022-12-25 US Indiana Union 18161 2285 23 0   39.62550777 -84.92497066 2022-12-26 04:21:06 Union, Indiana, US

Next page

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]);