johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46,127 rows where deaths = 5 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755427 | 2755427 | 2022-12-29 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-30 04:21:04 | Unassigned, Ohio, US | |
2755325 | 2755325 | 2022-12-29 | US | North Dakota | Oliver | 38065 | 371 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-30 04:21:04 | Oliver, North Dakota, US | |
2755148 | 2755148 | 2022-12-29 | US | New York | Hamilton | 36041 | 1073 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-12-30 04:21:04 | Hamilton, New York, US | |
2755048 | 2755048 | 2022-12-29 | US | Nevada | Esmeralda | 32009 | 124 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-30 04:21:04 | Esmeralda, Nevada, US | |
2754994 | 2754994 | 2022-12-29 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-30 04:21:04 | Hooker, Nebraska, US | |
2754983 | 2754983 | 2022-12-29 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-30 04:21:04 | Garden, Nebraska, US | |
2754910 | 2754910 | 2022-12-29 | US | Montana | Golden Valley | 30037 | 168 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-12-30 04:21:04 | Golden Valley, Montana, US | |
2754897 | 2754897 | 2022-12-29 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-30 04:21:04 | Carter, Montana, US | |
2754890 | 2754890 | 2022-12-29 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-30 04:21:04 | Worth, Missouri, US | |
2754619 | 2754619 | 2022-12-29 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-30 04:21:04 | Cook, Minnesota, US | |
2754541 | 2754541 | 2022-12-29 | US | Michigan | Federal Correctional Institution (FCI) | 329 | 5 | 0 | 47.63197653 | 0.0 | 2022-12-30 04:21:04 | Federal Correctional Institution (FCI), Michigan, US | ||
2754515 | 2754515 | 2022-12-29 | US | Massachusetts | Unassigned | 90025 | 188257 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Massachusetts, US | |
2754203 | 2754203 | 2022-12-29 | US | Kansas | Hamilton | 20075 | 544 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-30 04:21:04 | Hamilton, Kansas, US | |
2753773 | 2753773 | 2022-12-29 | US | Georgia | Quitman | 13239 | 527 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-30 04:21:04 | Quitman, Georgia, US | |
2753492 | 2753492 | 2022-12-29 | US | California | Sierra | 6091 | 371 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-30 04:21:04 | Sierra, California, US | |
2753350 | 2753350 | 2022-12-29 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-30 04:21:04 | Yakutat, Alaska, US | |
2753321 | 2753321 | 2022-12-29 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-30 04:21:04 | Aleutians East, Alaska, US | |
2752713 | 2752713 | 2022-12-29 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-30 04:21:04 | Sichuan, China | |||
2752704 | 2752704 | 2022-12-29 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-30 04:21:04 | Jilin, China | |||
1076433 | 1076433 | 2022-12-28 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-29 04:21:01 | Unassigned, Ohio, US | |
1076331 | 1076331 | 2022-12-28 | US | North Dakota | Oliver | 38065 | 371 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-29 04:21:01 | Oliver, North Dakota, US | |
1076154 | 1076154 | 2022-12-28 | US | New York | Hamilton | 36041 | 1068 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-12-29 04:21:01 | Hamilton, New York, US | |
1076054 | 1076054 | 2022-12-28 | US | Nevada | Esmeralda | 32009 | 124 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-29 04:21:01 | Esmeralda, Nevada, US | |
1076000 | 1076000 | 2022-12-28 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-29 04:21:01 | Hooker, Nebraska, US | |
1075989 | 1075989 | 2022-12-28 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-29 04:21:01 | Garden, Nebraska, US | |
1075916 | 1075916 | 2022-12-28 | US | Montana | Golden Valley | 30037 | 168 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-12-29 04:21:01 | Golden Valley, Montana, US | |
1075903 | 1075903 | 2022-12-28 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-29 04:21:01 | Carter, Montana, US | |
1075896 | 1075896 | 2022-12-28 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-29 04:21:01 | Worth, Missouri, US | |
1075625 | 1075625 | 2022-12-28 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-29 04:21:01 | Cook, Minnesota, US | |
1075547 | 1075547 | 2022-12-28 | US | Michigan | Federal Correctional Institution (FCI) | 329 | 5 | 0 | 47.63197653 | 0.0 | 2022-12-29 04:21:01 | Federal Correctional Institution (FCI), Michigan, US | ||
1075521 | 1075521 | 2022-12-28 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Massachusetts, US | |
1075209 | 1075209 | 2022-12-28 | US | Kansas | Hamilton | 20075 | 544 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-29 04:21:01 | Hamilton, Kansas, US | |
1074779 | 1074779 | 2022-12-28 | US | Georgia | Quitman | 13239 | 527 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-29 04:21:01 | Quitman, Georgia, US | |
1074498 | 1074498 | 2022-12-28 | US | California | Sierra | 6091 | 371 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-29 04:21:01 | Sierra, California, US | |
1074356 | 1074356 | 2022-12-28 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-29 04:21:01 | Yakutat, Alaska, US | |
1074327 | 1074327 | 2022-12-28 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-29 04:21:01 | Aleutians East, Alaska, US | |
1073719 | 1073719 | 2022-12-28 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-29 04:21:01 | Sichuan, China | |||
1073710 | 1073710 | 2022-12-28 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-29 04:21:01 | Jilin, China | |||
330430 | 330430 | 2022-12-27 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-28 04:21:04 | Unassigned, Ohio, US | |
330328 | 330328 | 2022-12-27 | US | North Dakota | Oliver | 38065 | 371 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-28 04:21:04 | Oliver, North Dakota, US | |
330151 | 330151 | 2022-12-27 | US | New York | Hamilton | 36041 | 1068 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-12-28 04:21:04 | Hamilton, New York, US | |
330051 | 330051 | 2022-12-27 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-28 04:21:04 | Esmeralda, Nevada, US | |
329997 | 329997 | 2022-12-27 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-28 04:21:04 | Hooker, Nebraska, US | |
329986 | 329986 | 2022-12-27 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-28 04:21:04 | Garden, Nebraska, US | |
329913 | 329913 | 2022-12-27 | US | Montana | Golden Valley | 30037 | 168 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-12-28 04:21:04 | Golden Valley, Montana, US | |
329900 | 329900 | 2022-12-27 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-28 04:21:04 | Carter, Montana, US | |
329893 | 329893 | 2022-12-27 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-28 04:21:04 | Worth, Missouri, US | |
329622 | 329622 | 2022-12-27 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-28 04:21:04 | Cook, Minnesota, US | |
329544 | 329544 | 2022-12-27 | US | Michigan | Federal Correctional Institution (FCI) | 329 | 5 | 0 | 47.63197653 | 0.0 | 2022-12-28 04:21:04 | Federal Correctional Institution (FCI), Michigan, US | ||
329518 | 329518 | 2022-12-27 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Massachusetts, US | |
329206 | 329206 | 2022-12-27 | US | Kansas | Hamilton | 20075 | 543 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-28 04:21:04 | Hamilton, Kansas, US | |
328776 | 328776 | 2022-12-27 | US | Georgia | Quitman | 13239 | 524 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-28 04:21:04 | Quitman, Georgia, US | |
328495 | 328495 | 2022-12-27 | US | California | Sierra | 6091 | 371 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-28 04:21:04 | Sierra, California, US | |
328353 | 328353 | 2022-12-27 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-28 04:21:04 | Yakutat, Alaska, US | |
328324 | 328324 | 2022-12-27 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-28 04:21:04 | Aleutians East, Alaska, US | |
327716 | 327716 | 2022-12-27 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-28 04:21:04 | Sichuan, China | |||
327707 | 327707 | 2022-12-27 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-28 04:21:04 | Jilin, China | |||
220503 | 220503 | 2022-12-26 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-27 04:21:07 | Unassigned, Ohio, US | |
220401 | 220401 | 2022-12-26 | US | North Dakota | Oliver | 38065 | 371 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-27 04:21:07 | Oliver, North Dakota, US | |
220224 | 220224 | 2022-12-26 | US | New York | Hamilton | 36041 | 1068 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-12-27 04:21:07 | Hamilton, New York, US | |
220124 | 220124 | 2022-12-26 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-27 04:21:07 | Esmeralda, Nevada, US | |
220070 | 220070 | 2022-12-26 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-27 04:21:07 | Hooker, Nebraska, US | |
220059 | 220059 | 2022-12-26 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-27 04:21:07 | Garden, Nebraska, US | |
219986 | 219986 | 2022-12-26 | US | Montana | Golden Valley | 30037 | 168 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-12-27 04:21:07 | Golden Valley, Montana, US | |
219973 | 219973 | 2022-12-26 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-27 04:21:07 | Carter, Montana, US | |
219966 | 219966 | 2022-12-26 | US | Missouri | Worth | 29227 | 546 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-27 04:21:07 | Worth, Missouri, US | |
219695 | 219695 | 2022-12-26 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-27 04:21:07 | Cook, Minnesota, US | |
219617 | 219617 | 2022-12-26 | US | Michigan | Federal Correctional Institution (FCI) | 329 | 5 | 0 | 47.63197653 | 0.0 | 2022-12-27 04:21:07 | Federal Correctional Institution (FCI), Michigan, US | ||
219591 | 219591 | 2022-12-26 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Massachusetts, US | |
219279 | 219279 | 2022-12-26 | US | Kansas | Hamilton | 20075 | 543 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-27 04:21:07 | Hamilton, Kansas, US | |
218849 | 218849 | 2022-12-26 | US | Georgia | Quitman | 13239 | 524 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-27 04:21:07 | Quitman, Georgia, US | |
218568 | 218568 | 2022-12-26 | US | California | Sierra | 6091 | 370 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-27 04:21:07 | Sierra, California, US | |
218426 | 218426 | 2022-12-26 | US | Alaska | Yakutat | 2282 | 952 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-27 04:21:07 | Yakutat, Alaska, US | |
218397 | 218397 | 2022-12-26 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-27 04:21:07 | Aleutians East, Alaska, US | |
217789 | 217789 | 2022-12-26 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-27 04:21:07 | Sichuan, China | |||
217780 | 217780 | 2022-12-26 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-27 04:21:07 | Jilin, China | |||
3224960 | 3224960 | 2022-12-25 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-26 04:21:06 | Unassigned, Ohio, US | |
3224858 | 3224858 | 2022-12-25 | US | North Dakota | Oliver | 38065 | 371 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-26 04:21:06 | Oliver, North Dakota, US | |
3224681 | 3224681 | 2022-12-25 | US | New York | Hamilton | 36041 | 1068 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-12-26 04:21:06 | Hamilton, New York, US | |
3224581 | 3224581 | 2022-12-25 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-26 04:21:06 | Esmeralda, Nevada, US | |
3224527 | 3224527 | 2022-12-25 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-26 04:21:06 | Hooker, Nebraska, US | |
3224516 | 3224516 | 2022-12-25 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-26 04:21:06 | Garden, Nebraska, US | |
3224443 | 3224443 | 2022-12-25 | US | Montana | Golden Valley | 30037 | 168 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-12-26 04:21:06 | Golden Valley, Montana, US | |
3224430 | 3224430 | 2022-12-25 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-26 04:21:06 | Carter, Montana, US | |
3224423 | 3224423 | 2022-12-25 | US | Missouri | Worth | 29227 | 546 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-26 04:21:06 | Worth, Missouri, US | |
3224152 | 3224152 | 2022-12-25 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-26 04:21:06 | Cook, Minnesota, US | |
3224074 | 3224074 | 2022-12-25 | US | Michigan | Federal Correctional Institution (FCI) | 329 | 5 | 0 | 47.63197653 | 0.0 | 2022-12-26 04:21:06 | Federal Correctional Institution (FCI), Michigan, US | ||
3224048 | 3224048 | 2022-12-25 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Massachusetts, US | |
3223736 | 3223736 | 2022-12-25 | US | Kansas | Hamilton | 20075 | 543 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-26 04:21:06 | Hamilton, Kansas, US | |
3223306 | 3223306 | 2022-12-25 | US | Georgia | Quitman | 13239 | 524 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-26 04:21:06 | Quitman, Georgia, US | |
3223025 | 3223025 | 2022-12-25 | US | California | Sierra | 6091 | 370 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-26 04:21:06 | Sierra, California, US | |
3222883 | 3222883 | 2022-12-25 | US | Alaska | Yakutat | 2282 | 952 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-26 04:21:06 | Yakutat, Alaska, US | |
3222854 | 3222854 | 2022-12-25 | US | Alaska | Aleutians East | 2013 | 1321 | 5 | 0 | 55.32222414 | -161.9722021 | 2022-12-26 04:21:06 | Aleutians East, Alaska, US | |
3222246 | 3222246 | 2022-12-25 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-26 04:21:06 | Sichuan, China | |||
3222237 | 3222237 | 2022-12-25 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-26 04:21:06 | Jilin, China | |||
1020874 | 1020874 | 2022-12-24 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-25 04:21:04 | Unassigned, Ohio, US | |
1020772 | 1020772 | 2022-12-24 | US | North Dakota | Oliver | 38065 | 371 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-25 04:21:04 | Oliver, North Dakota, US | |
1020595 | 1020595 | 2022-12-24 | US | New York | Hamilton | 36041 | 1068 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-12-25 04:21:04 | Hamilton, New York, US | |
1020495 | 1020495 | 2022-12-24 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-25 04:21:04 | Esmeralda, Nevada, US | |
1020441 | 1020441 | 2022-12-24 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-25 04:21:04 | Hooker, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
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]);