daily_reports (view)
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), last_update (date)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-30 04:21:04 | Unassigned, Ohio, US | |
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 | |
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 | |
2022-12-29 | US | Nevada | Esmeralda | 32009 | 124 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-30 04:21:04 | Esmeralda, Nevada, US | |
2022-12-29 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-30 04:21:04 | Hooker, Nebraska, US | |
2022-12-29 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-30 04:21:04 | Garden, Nebraska, US | |
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 | |
2022-12-29 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-30 04:21:04 | Carter, Montana, US | |
2022-12-29 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-30 04:21:04 | Worth, Missouri, US | |
2022-12-29 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-30 04:21:04 | Cook, Minnesota, US | |
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 | ||
2022-12-29 | US | Massachusetts | Unassigned | 90025 | 188257 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Massachusetts, US | |
2022-12-29 | US | Kansas | Hamilton | 20075 | 544 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-30 04:21:04 | Hamilton, Kansas, US | |
2022-12-29 | US | Georgia | Quitman | 13239 | 527 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-30 04:21:04 | Quitman, Georgia, US | |
2022-12-29 | US | California | Sierra | 6091 | 371 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-30 04:21:04 | Sierra, California, US | |
2022-12-29 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-30 04:21:04 | Yakutat, Alaska, US | |
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 | |
2022-12-29 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-30 04:21:04 | Sichuan, China | |||
2022-12-29 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-30 04:21:04 | Jilin, China | |||
2022-12-28 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-29 04:21:01 | Unassigned, Ohio, US | |
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 | |
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 | |
2022-12-28 | US | Nevada | Esmeralda | 32009 | 124 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-29 04:21:01 | Esmeralda, Nevada, US | |
2022-12-28 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-29 04:21:01 | Hooker, Nebraska, US | |
2022-12-28 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-29 04:21:01 | Garden, Nebraska, US | |
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 | |
2022-12-28 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-29 04:21:01 | Carter, Montana, US | |
2022-12-28 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-29 04:21:01 | Worth, Missouri, US | |
2022-12-28 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-29 04:21:01 | Cook, Minnesota, US | |
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 | ||
2022-12-28 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Massachusetts, US | |
2022-12-28 | US | Kansas | Hamilton | 20075 | 544 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-29 04:21:01 | Hamilton, Kansas, US | |
2022-12-28 | US | Georgia | Quitman | 13239 | 527 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-29 04:21:01 | Quitman, Georgia, US | |
2022-12-28 | US | California | Sierra | 6091 | 371 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-29 04:21:01 | Sierra, California, US | |
2022-12-28 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-29 04:21:01 | Yakutat, Alaska, US | |
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 | |
2022-12-28 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-29 04:21:01 | Sichuan, China | |||
2022-12-28 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-29 04:21:01 | Jilin, China | |||
2022-12-27 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-28 04:21:04 | Unassigned, Ohio, US | |
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 | |
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 | |
2022-12-27 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-28 04:21:04 | Esmeralda, Nevada, US | |
2022-12-27 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-28 04:21:04 | Hooker, Nebraska, US | |
2022-12-27 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-28 04:21:04 | Garden, Nebraska, US | |
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 | |
2022-12-27 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-28 04:21:04 | Carter, Montana, US | |
2022-12-27 | US | Missouri | Worth | 29227 | 550 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-28 04:21:04 | Worth, Missouri, US | |
2022-12-27 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-28 04:21:04 | Cook, Minnesota, US | |
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 | ||
2022-12-27 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Massachusetts, US | |
2022-12-27 | US | Kansas | Hamilton | 20075 | 543 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-28 04:21:04 | Hamilton, Kansas, US | |
2022-12-27 | US | Georgia | Quitman | 13239 | 524 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-28 04:21:04 | Quitman, Georgia, US | |
2022-12-27 | US | California | Sierra | 6091 | 371 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-28 04:21:04 | Sierra, California, US | |
2022-12-27 | US | Alaska | Yakutat | 2282 | 954 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-28 04:21:04 | Yakutat, Alaska, US | |
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 | |
2022-12-27 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-28 04:21:04 | Sichuan, China | |||
2022-12-27 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-28 04:21:04 | Jilin, China | |||
2022-12-26 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-27 04:21:07 | Unassigned, Ohio, US | |
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 | |
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 | |
2022-12-26 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-27 04:21:07 | Esmeralda, Nevada, US | |
2022-12-26 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-27 04:21:07 | Hooker, Nebraska, US | |
2022-12-26 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-27 04:21:07 | Garden, Nebraska, US | |
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 | |
2022-12-26 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-27 04:21:07 | Carter, Montana, US | |
2022-12-26 | US | Missouri | Worth | 29227 | 546 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-27 04:21:07 | Worth, Missouri, US | |
2022-12-26 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-27 04:21:07 | Cook, Minnesota, US | |
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 | ||
2022-12-26 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Massachusetts, US | |
2022-12-26 | US | Kansas | Hamilton | 20075 | 543 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-27 04:21:07 | Hamilton, Kansas, US | |
2022-12-26 | US | Georgia | Quitman | 13239 | 524 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-27 04:21:07 | Quitman, Georgia, US | |
2022-12-26 | US | California | Sierra | 6091 | 370 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-27 04:21:07 | Sierra, California, US | |
2022-12-26 | US | Alaska | Yakutat | 2282 | 952 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-27 04:21:07 | Yakutat, Alaska, US | |
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 | |
2022-12-26 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-27 04:21:07 | Sichuan, China | |||
2022-12-26 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-27 04:21:07 | Jilin, China | |||
2022-12-25 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-26 04:21:06 | Unassigned, Ohio, US | |
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 | |
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 | |
2022-12-25 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-26 04:21:06 | Esmeralda, Nevada, US | |
2022-12-25 | US | Nebraska | Hooker | 31091 | 124 | 5 | 0 | 41.91586243 | -101.1354293 | 2022-12-26 04:21:06 | Hooker, Nebraska, US | |
2022-12-25 | US | Nebraska | Garden | 31069 | 454 | 5 | 0 | 41.61703149 | -102.3313973 | 2022-12-26 04:21:06 | Garden, Nebraska, US | |
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 | |
2022-12-25 | US | Montana | Carter | 30011 | 288 | 5 | 0 | 45.5197966 | -104.5395536 | 2022-12-26 04:21:06 | Carter, Montana, US | |
2022-12-25 | US | Missouri | Worth | 29227 | 546 | 5 | 0 | 40.47945588 | -94.42328751 | 2022-12-26 04:21:06 | Worth, Missouri, US | |
2022-12-25 | US | Minnesota | Cook | 27031 | 807 | 5 | 0 | 47.90504893 | -90.52629546 | 2022-12-26 04:21:06 | Cook, Minnesota, US | |
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 | ||
2022-12-25 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Massachusetts, US | |
2022-12-25 | US | Kansas | Hamilton | 20075 | 543 | 5 | 0 | 37.99978709 | -101.7921066 | 2022-12-26 04:21:06 | Hamilton, Kansas, US | |
2022-12-25 | US | Georgia | Quitman | 13239 | 524 | 5 | 0 | 31.86728114 | -85.01773177 | 2022-12-26 04:21:06 | Quitman, Georgia, US | |
2022-12-25 | US | California | Sierra | 6091 | 370 | 5 | 0 | 39.57713498 | -120.5200701 | 2022-12-26 04:21:06 | Sierra, California, US | |
2022-12-25 | US | Alaska | Yakutat | 2282 | 952 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-12-26 04:21:06 | Yakutat, Alaska, US | |
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 | |
2022-12-25 | China | Sichuan | 12023 | 5 | 0 | 30.6171 | 102.7103 | 2022-12-26 04:21:06 | Sichuan, China | |||
2022-12-25 | China | Jilin | 40485 | 5 | 0 | 43.6661 | 126.1923 | 2022-12-26 04:21:06 | Jilin, China | |||
2022-12-24 | US | Ohio | Unassigned | 90039 | 0 | 5 | 0 | 41.70860332 | -84.64787018 | 2022-12-25 04:21:04 | Unassigned, Ohio, US | |
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 | |
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 | |
2022-12-24 | US | Nevada | Esmeralda | 32009 | 123 | 5 | 0 | 37.78436681 | -117.6319999 | 2022-12-25 04:21:04 | Esmeralda, Nevada, US | |
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;