daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
158 rows where deaths = 1170 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 30
- US 79
- Mexico 12
- Spain 10
- Chile 7
- Russia 7
- Netherlands 6
- Italy 5
- Colombia 3
- Japan 3
- Brazil 2
- Ghana 2
- Peru 2
- Suriname 2
- Ukraine 2
- Albania 1
- Austria 1
- Canada 1
- Cuba 1
- Dominican Republic 1
- Ethiopia 1
- India 1
- Kyrgyzstan 1
- Lebanon 1
- Luxembourg 1
- Malaysia 1
- Moldova 1
- Pakistan 1
- Senegal 1
- Singapore 1
- Zambia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-13 | Luxembourg | 309253 | 1170 | 0 | 49.8153 | 6.1296 | 2022-12-14 04:21:04 | Luxembourg | ||||
2022-11-01 | US | Wisconsin | Waukesha | 55133 | 132656 | 1170 | 0 | 43.01833055 | -88.30431188 | 2022-11-02 04:22:09 | Waukesha, Wisconsin, US | |
2022-10-31 | US | Wisconsin | Waukesha | 55133 | 132586 | 1170 | 0 | 43.01833055 | -88.30431188 | 2022-11-01 04:22:36 | Waukesha, Wisconsin, US | |
2022-10-30 | US | Wisconsin | Waukesha | 55133 | 132439 | 1170 | 0 | 43.01833055 | -88.30431188 | 2022-10-31 04:21:36 | Waukesha, Wisconsin, US | |
2022-10-29 | US | Wisconsin | Waukesha | 55133 | 132439 | 1170 | 0 | 43.01833055 | -88.30431188 | 2022-10-30 04:22:14 | Waukesha, Wisconsin, US | |
2022-10-28 | US | Wisconsin | Waukesha | 55133 | 132439 | 1170 | 0 | 43.01833055 | -88.30431188 | 2022-10-29 04:21:13 | Waukesha, Wisconsin, US | |
2022-10-25 | US | Iowa | Polk | 19153 | 141532 | 1170 | 0 | 41.68679484 | -93.57767461 | 2022-10-26 04:22:19 | Polk, Iowa, US | |
2022-10-24 | US | Iowa | Polk | 19153 | 141532 | 1170 | 0 | 41.68679484 | -93.57767461 | 2022-10-25 04:21:53 | Polk, Iowa, US | |
2022-10-23 | US | Iowa | Polk | 19153 | 141532 | 1170 | 0 | 41.68679484 | -93.57767461 | 2022-10-24 04:22:29 | Polk, Iowa, US | |
2022-10-22 | US | Iowa | Polk | 19153 | 141532 | 1170 | 0 | 41.68679484 | -93.57767461 | 2022-10-23 04:22:46 | Polk, Iowa, US | |
2022-10-21 | US | Iowa | Polk | 19153 | 141532 | 1170 | 0 | 41.68679484 | -93.57767461 | 2022-10-22 04:22:53 | Polk, Iowa, US | |
2022-10-20 | US | Iowa | Polk | 19153 | 141532 | 1170 | 0 | 41.68679484 | -93.57767461 | 2022-10-21 04:22:23 | Polk, Iowa, US | |
2022-10-19 | US | Iowa | Polk | 19153 | 141532 | 1170 | 0 | 41.68679484 | -93.57767461 | 2022-10-20 04:22:59 | Polk, Iowa, US | |
2022-10-18 | US | Pennsylvania | Northampton | 42095 | 92708 | 1170 | 0 | 40.75182733 | -75.30471829 | 2022-10-19 04:22:26 | Northampton, Pennsylvania, US | |
2022-10-17 | US | Pennsylvania | Northampton | 42095 | 92708 | 1170 | 0 | 40.75182733 | -75.30471829 | 2022-10-18 04:22:42 | Northampton, Pennsylvania, US | |
2022-10-16 | US | Pennsylvania | Northampton | 42095 | 92708 | 1170 | 0 | 40.75182733 | -75.30471829 | 2022-10-17 04:20:31 | Northampton, Pennsylvania, US | |
2022-10-15 | US | Pennsylvania | Northampton | 42095 | 92708 | 1170 | 0 | 40.75182733 | -75.30471829 | 2022-10-16 04:22:39 | Northampton, Pennsylvania, US | |
2022-10-14 | US | Pennsylvania | Northampton | 42095 | 92708 | 1170 | 0 | 40.75182733 | -75.30471829 | 2022-10-15 04:22:00 | Northampton, Pennsylvania, US | |
2022-10-13 | US | Pennsylvania | Northampton | 42095 | 92708 | 1170 | 0 | 40.75182733 | -75.30471829 | 2022-10-14 04:22:28 | Northampton, Pennsylvania, US | |
2022-10-12 | US | Pennsylvania | Northampton | 42095 | 92708 | 1170 | 0 | 40.75182733 | -75.30471829 | 2022-10-13 04:22:39 | Northampton, Pennsylvania, US | |
2022-09-28 | US | Illinois | Kane | 17089 | 153699 | 1170 | 0 | 41.93842729 | -88.42861412 | 2022-09-29 04:22:34 | Kane, Illinois, US | |
2022-09-19 | US | Maryland | Anne Arundel | 24003 | 109375 | 1170 | 0 | 39.00670238 | -76.60329337 | 2022-09-20 04:22:48 | Anne Arundel, Maryland, US | |
2022-08-18 | Chile | Nuble | 124794 | 1170 | 0 | -36.7226 | -71.7622 | 2022-08-19 04:20:54 | Nuble, Chile | |||
2022-08-17 | Chile | Nuble | 124409 | 1170 | 0 | -36.7226 | -71.7622 | 2022-08-18 04:21:11 | Nuble, Chile | |||
2022-08-16 | Chile | Nuble | 124099 | 1170 | 0 | -36.7226 | -71.7622 | 2022-08-17 04:20:59 | Nuble, Chile | |||
2022-08-15 | Chile | Nuble | 123828 | 1170 | 0 | -36.7226 | -71.7622 | 2022-08-16 04:20:58 | Nuble, Chile | |||
2022-08-02 | India | Chandigarh | 96771 | 1170 | 0 | 30.733839 | 76.768278 | 2022-08-03 04:20:59 | Chandigarh, India | |||
2022-06-27 | US | South Carolina | Horry | 45051 | 101987 | 1170 | 0 | 33.9212828 | -78.99555293 | 2022-06-28 04:20:58 | Horry, South Carolina, US | |
2022-06-26 | US | Tennessee | Hamilton | 47065 | 104428 | 1170 | 0 | 35.17670231 | -85.16652245 | 2022-06-27 04:21:00 | Hamilton, Tennessee, US | |
2022-06-26 | US | South Carolina | Horry | 45051 | 101987 | 1170 | 0 | 33.9212828 | -78.99555293 | 2022-06-27 04:21:00 | Horry, South Carolina, US | |
2022-06-25 | US | South Carolina | Horry | 45051 | 101987 | 1170 | 0 | 33.9212828 | -78.99555293 | 2022-06-26 04:21:02 | Horry, South Carolina, US | |
2022-06-24 | US | South Carolina | Horry | 45051 | 101987 | 1170 | 0 | 33.9212828 | -78.99555293 | 2022-06-25 04:20:57 | Horry, South Carolina, US | |
2022-06-23 | US | South Carolina | Horry | 45051 | 101987 | 1170 | 0 | 33.9212828 | -78.99555293 | 2022-06-24 04:20:58 | Horry, South Carolina, US | |
2022-06-22 | US | South Carolina | Horry | 45051 | 101987 | 1170 | 0 | 33.9212828 | -78.99555293 | 2022-06-23 04:20:55 | Horry, South Carolina, US | |
2022-06-21 | US | South Carolina | Horry | 45051 | 101987 | 1170 | 0 | 33.9212828 | -78.99555293 | 2022-06-22 04:20:54 | Horry, South Carolina, US | |
2022-06-18 | US | Ohio | Butler | 39017 | 96599 | 1170 | 0 | 39.44012838 | -84.57388716 | 2022-06-19 04:20:51 | Butler, Ohio, US | |
2022-04-04 | US | Arkansas | Pulaski | 5119 | 102930 | 1170 | 0 | 34.77054088 | -92.31355101 | 2022-04-05 04:20:48 | Pulaski, Arkansas, US | |
2022-04-03 | US | Arkansas | Pulaski | 5119 | 102919 | 1170 | 0 | 34.77054088 | -92.31355101 | 2022-04-04 04:20:51 | Pulaski, Arkansas, US | |
2022-04-02 | US | Arkansas | Pulaski | 5119 | 102907 | 1170 | 0 | 34.77054088 | -92.31355101 | 2022-04-03 04:20:48 | Pulaski, Arkansas, US | |
2022-03-16 | Singapore | 975607 | 1170 | 0 | 1.2833 | 103.8333 | 2022-03-17 04:20:56 | Singapore | ||||
2022-02-28 | US | New Jersey | Burlington | 34005 | 100791 | 1170 | 0 | 39.87681124 | -74.66927768 | 2022-03-01 04:21:09 | Burlington, New Jersey, US | |
2022-02-17 | Japan | Chiba | 226505 | 1170 | 0 | 35.510141 | 140.198917 | 2022-02-18 04:21:04 | Chiba, Japan | |||
2022-02-07 | US | Colorado | Arapahoe | 8005 | 155784 | 1170 | 0 | 39.64977461 | -104.3353617 | 2022-02-08 04:21:15 | Arapahoe, Colorado, US | |
2022-02-06 | US | Colorado | Arapahoe | 8005 | 155590 | 1170 | 0 | 39.64977461 | -104.3353617 | 2022-02-07 04:21:05 | Arapahoe, Colorado, US | |
2022-02-02 | US | Pennsylvania | Lehigh | 42077 | 87174 | 1170 | 0 | 40.6154815 | -75.59435245 | 2022-02-03 04:21:21 | Lehigh, Pennsylvania, US | |
2022-01-28 | US | Texas | Denton | 48121 | 160096 | 1170 | 0 | 33.20521901 | -97.11691153 | 2022-01-29 04:21:10 | Denton, Texas, US | |
2022-01-27 | US | New Jersey | Mercer | 34021 | 71604 | 1170 | 0 | 40.28047017 | -74.70479631 | 2022-01-28 04:21:09 | Mercer, New Jersey, US | |
2022-01-23 | Japan | Aichi | 133490 | 1170 | 0 | 35.035551 | 137.211621 | 2022-01-24 04:21:12 | Aichi, Japan | |||
2022-01-21 | US | Texas | Montgomery | 48339 | 122130 | 1170 | 0 | 30.30079133 | -95.50572772 | 2022-01-22 04:21:13 | Montgomery, Texas, US | |
2022-01-12 | US | Pennsylvania | Westmoreland | 42129 | 65710 | 1170 | 0 | 40.31377979999999 | -79.46615476 | 2022-01-13 08:00:09 | Westmoreland, Pennsylvania, US | |
2022-01-01 | US | Colorado | Denver | 8031 | 129996 | 1170 | 0 | 39.76018276 | -104.87256950000001 | 2022-01-02 04:20:52 | Denver, Colorado, US | |
2021-12-24 | Russia | Karelia Republic | 88645 | 1170 | 0 | 62.61940309999999 | 33.4920267 | 2021-12-25 04:21:37 | Karelia Republic, Russia | |||
2021-12-04 | Suriname | 50993 | 1170 | 0 | 3.9193 | -56.0278 | 2021-12-05 04:22:25 | Suriname | ||||
2021-12-03 | Suriname | 50960 | 1170 | 0 | 3.9193 | -56.0278 | 2021-12-04 04:22:18 | Suriname | ||||
2021-12-02 | US | Texas | Collin | 48085 | 130443 | 1170 | 0 | 33.18820114 | -96.57264368 | 2021-12-03 04:23:05 | Collin, Texas, US | |
2021-11-30 | US | Michigan | Genesee | 26049 | 61265 | 1170 | 0 | 43.02244215 | -83.70589709 | 2021-12-01 04:22:29 | Genesee, Michigan, US | |
2021-11-30 | US | Louisiana | East Baton Rouge | 22033 | 64608 | 1170 | 0 | 30.53842039 | -91.09777565 | 2021-12-01 04:22:29 | East Baton Rouge, Louisiana, US | |
2021-11-29 | US | Michigan | Genesee | 26049 | 61265 | 1170 | 0 | 43.02244215 | -83.70589709 | 2021-11-30 04:22:53 | Genesee, Michigan, US | |
2021-11-29 | US | Louisiana | East Baton Rouge | 22033 | 64581 | 1170 | 0 | 30.53842039 | -91.09777565 | 2021-11-30 04:22:53 | East Baton Rouge, Louisiana, US | |
2021-11-23 | US | New Mexico | Bernalillo | 35001 | 84858 | 1170 | 0 | 35.05163625 | -106.6703554 | 2021-11-24 04:22:14 | Bernalillo, New Mexico, US | |
2021-11-12 | Russia | Orel Oblast | 57314 | 1170 | 0 | 52.96854329999999 | 36.0692477 | 2021-11-13 04:21:38 | Orel Oblast, Russia | |||
2021-11-11 | Malaysia | Perak | 118454 | 1170 | 0 | 4.5921 | 101.0901 | 2021-11-12 04:22:01 | Perak, Malaysia | |||
2021-11-06 | US | Tennessee | Davidson | 47037 | 122048 | 1170 | 0 | 36.17007426 | -86.78646056 | 2021-11-07 04:21:53 | Davidson, Tennessee, US | |
2021-11-05 | US | Tennessee | Davidson | 47037 | 121971 | 1170 | 0 | 36.17007426 | -86.78646056 | 2021-11-06 04:21:51 | Davidson, Tennessee, US | |
2021-10-27 | US | California | Ventura | 6111 | 101350 | 1170 | 0 | 34.44465746 | -119.09106129999999 | 2021-10-28 04:22:08 | Ventura, California, US | |
2021-10-26 | US | South Carolina | Spartanburg | 45083 | 61540 | 1170 | 0 | 34.92960077 | -81.99225984 | 2021-10-27 04:22:32 | Spartanburg, South Carolina, US | |
2021-10-26 | US | Indiana | Lake | 18089 | 66871 | 1170 | 0 | 41.41874274 | -87.38277575 | 2021-10-27 04:22:32 | Lake, Indiana, US | |
2021-10-25 | US | South Carolina | Spartanburg | 45083 | 61495 | 1170 | 0 | 34.92960077 | -81.99225984 | 2021-10-26 04:22:09 | Spartanburg, South Carolina, US | |
2021-10-24 | Ghana | 129805 | 1170 | 0 | 7.9465 | -1.0232 | 2021-10-25 04:22:31 | Ghana | ||||
2021-10-23 | Ghana | 129805 | 1170 | 0 | 7.9465 | -1.0232 | 2021-10-24 04:21:22 | Ghana | ||||
2021-10-18 | Netherlands | Overijssel | 133894 | 1170 | 0 | 52.444557999999994 | 6.441722 | 2021-10-19 04:20:54 | Overijssel, Netherlands | |||
2021-10-17 | US | Virginia | Fairfax | 51059 | 90382 | 1170 | 0 | 38.83677558 | -77.27565836 | 2021-10-18 04:21:10 | Fairfax, Virginia, US | |
2021-10-17 | Netherlands | Overijssel | 133599 | 1170 | 0 | 52.444557999999994 | 6.441722 | 2021-10-18 04:21:10 | Overijssel, Netherlands | |||
2021-10-16 | US | Virginia | Fairfax | 51059 | 90382 | 1170 | 0 | 38.83677558 | -77.27565836 | 2021-10-17 04:21:29 | Fairfax, Virginia, US | |
2021-10-16 | Netherlands | Overijssel | 133272 | 1170 | 0 | 52.444557999999994 | 6.441722 | 2021-10-17 04:21:29 | Overijssel, Netherlands | |||
2021-10-15 | US | Virginia | Fairfax | 51059 | 90382 | 1170 | 0 | 38.83677558 | -77.27565836 | 2021-10-16 04:21:15 | Fairfax, Virginia, US | |
2021-10-15 | Netherlands | Overijssel | 132946 | 1170 | 0 | 52.444557999999994 | 6.441722 | 2021-10-16 04:21:15 | Overijssel, Netherlands | |||
2021-10-14 | Netherlands | Overijssel | 132665 | 1170 | 0 | 52.444557999999994 | 6.441722 | 2021-10-15 04:21:26 | Overijssel, Netherlands | |||
2021-10-13 | Netherlands | Overijssel | 132387 | 1170 | 0 | 52.444557999999994 | 6.441722 | 2021-10-14 04:21:29 | Overijssel, Netherlands | |||
2021-09-26 | US | Texas | Nueces | 48355 | 53267 | 1170 | 0 | 27.736286 | -97.5433285 | 2021-09-27 04:21:16 | Nueces, Texas, US | |
2021-09-25 | US | Texas | Nueces | 48355 | 53170 | 1170 | 0 | 27.736286 | -97.5433285 | 2021-09-26 04:21:29 | Nueces, Texas, US | |
2021-09-21 | Russia | Arkhangelsk Oblast | 86973 | 1170 | 0 | 63.5589686 | 43.1221646 | 2021-09-22 04:21:45 | Arkhangelsk Oblast, Russia | |||
2021-09-20 | US | District of Columbia | District of Columbia | 11001 | 59563 | 1170 | 0 | 38.90417773 | -77.01655992 | 2021-09-21 04:21:26 | District of Columbia, District of Columbia ,US | |
2021-09-07 | US | Massachusetts | Plymouth | 25023 | 53701 | 1170 | 0 | 41.94070556 | -70.80802823 | 2021-09-08 04:21:31 | Plymouth, Massachusetts, US | |
2021-07-23 | Canada | Manitoba | 57359 | 1170 | 55652 | 537 | 53.7609 | -98.8139 | 2021-07-24 00:21:36 | Manitoba, Canada | ||
2021-07-19 | US | Pennsylvania | Lancaster | 42071 | 55893 | 1170 | 0 | 40.03904563 | -76.24770128 | 2021-07-20 04:21:48 | Lancaster, Pennsylvania, US | |
2021-07-18 | US | Pennsylvania | Lancaster | 42071 | 55881 | 1170 | 0 | 40.03904563 | -76.24770128 | 2021-07-19 04:21:24 | Lancaster, Pennsylvania, US | |
2021-07-17 | US | Pennsylvania | Lancaster | 42071 | 55865 | 1170 | 0 | 40.03904563 | -76.24770128 | 2021-07-18 04:22:07 | Lancaster, Pennsylvania, US | |
2021-07-16 | US | Pennsylvania | Lancaster | 42071 | 55841 | 1170 | 0 | 40.03904563 | -76.24770128 | 2021-07-17 04:22:22 | Lancaster, Pennsylvania, US | |
2021-07-08 | Russia | Smolensk Oblast | 36635 | 1170 | 32256 | 3209 | 55.03434960000001 | 33.0192065 | 2021-07-09 04:21:21 | Smolensk Oblast, Russia | ||
2021-07-02 | Senegal | 43427 | 1170 | 41554 | 703 | 14.4974 | -14.4524 | 2021-07-03 04:21:37 | Senegal | |||
2021-06-21 | Cuba | 169365 | 1170 | 159775 | 8420 | 21.521757 | -77.78116700000002 | 2021-06-22 04:21:34 | Cuba | |||
2021-05-26 | Spain | Navarra | 62060 | 1170 | 3905 | 56985 | 42.6954 | -1.6761 | 2021-05-27 04:20:59 | Navarra, Spain | ||
2021-05-25 | Spain | Navarra | 62007 | 1170 | 3905 | 56932 | 42.6954 | -1.6761 | 2021-05-26 04:20:35 | Navarra, Spain | ||
2021-05-24 | US | Georgia | Gwinnett | 13135 | 102257 | 1170 | 0 | 33.96044201 | -84.02137802 | 2021-05-25 04:21:08 | Gwinnett, Georgia, US | |
2021-05-24 | Spain | Navarra | 61948 | 1170 | 3905 | 56873 | 42.6954 | -1.6761 | 2021-05-25 04:21:08 | Navarra, Spain | ||
2021-05-23 | Spain | Navarra | 61811 | 1170 | 3905 | 56736 | 42.6954 | -1.6761 | 2021-05-24 04:20:53 | Navarra, Spain | ||
2021-05-22 | Spain | Navarra | 61811 | 1170 | 3905 | 56736 | 42.6954 | -1.6761 | 2021-05-23 04:20:51 | Navarra, Spain | ||
2021-05-21 | Spain | Navarra | 61811 | 1170 | 3905 | 56736 | 42.6954 | -1.6761 | 2021-05-22 04:20:45 | Navarra, Spain | ||
2021-05-20 | Spain | Navarra | 61740 | 1170 | 3905 | 56665 | 42.6954 | -1.6761 | 2021-05-21 04:20:43 | Navarra, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;