daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
332 rows where deaths = 809 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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-13 | Malta | 116000 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-14 04:21:04 | Malta | ||||
2022-12-12 | Malta | 115981 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-13 04:21:01 | Malta | ||||
2022-12-11 | Malta | 115973 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-12 04:21:01 | Malta | ||||
2022-12-10 | Malta | 115960 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-11 04:20:50 | Malta | ||||
2022-12-09 | Malta | 115941 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-10 04:21:02 | Malta | ||||
2022-12-08 | Malta | 115933 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-09 04:21:05 | Malta | ||||
2022-12-07 | Malta | 115918 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-08 04:21:07 | Malta | ||||
2022-12-06 | Malta | 115907 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-07 04:20:58 | Malta | ||||
2022-12-05 | Malta | 115891 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-06 04:21:03 | Malta | ||||
2022-12-04 | Malta | 115870 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-05 04:20:58 | Malta | ||||
2022-12-03 | Malta | 115857 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-04 04:20:56 | Malta | ||||
2022-12-02 | Malta | 115851 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-03 04:21:02 | Malta | ||||
2022-12-01 | Malta | 115839 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-02 04:21:07 | Malta | ||||
2022-11-30 | Malta | 115818 | 809 | 0 | 35.9375 | 14.3754 | 2022-12-01 04:21:03 | Malta | ||||
2022-11-29 | Malta | 115790 | 809 | 0 | 35.9375 | 14.3754 | 2022-11-30 04:21:07 | Malta | ||||
2022-11-28 | Malta | 115775 | 809 | 0 | 35.9375 | 14.3754 | 2022-11-29 04:21:05 | Malta | ||||
2022-11-27 | Malta | 115769 | 809 | 0 | 35.9375 | 14.3754 | 2022-11-28 04:21:02 | Malta | ||||
2022-11-26 | Malta | 115765 | 809 | 0 | 35.9375 | 14.3754 | 2022-11-27 04:21:05 | Malta | ||||
2022-11-25 | Malta | 115754 | 809 | 0 | 35.9375 | 14.3754 | 2022-11-26 04:21:11 | Malta | ||||
2022-11-24 | Malta | 115750 | 809 | 0 | 35.9375 | 14.3754 | 2022-11-25 04:21:06 | Malta | ||||
2022-11-23 | Malta | 115734 | 809 | 0 | 35.9375 | 14.3754 | 2022-11-24 04:21:09 | Malta | ||||
2022-10-24 | US | West Virginia | Kanawha | 54039 | 56311 | 809 | 0 | 38.33860077 | -81.52857054 | 2022-10-25 04:21:53 | Kanawha, West Virginia, US | |
2022-10-23 | US | West Virginia | Kanawha | 54039 | 56263 | 809 | 0 | 38.33860077 | -81.52857054 | 2022-10-24 04:22:29 | Kanawha, West Virginia, US | |
2022-10-22 | US | West Virginia | Kanawha | 54039 | 56263 | 809 | 0 | 38.33860077 | -81.52857054 | 2022-10-23 04:22:46 | Kanawha, West Virginia, US | |
2022-10-21 | US | West Virginia | Kanawha | 54039 | 56263 | 809 | 0 | 38.33860077 | -81.52857054 | 2022-10-22 04:22:53 | Kanawha, West Virginia, US | |
2022-10-20 | US | West Virginia | Kanawha | 54039 | 56229 | 809 | 0 | 38.33860077 | -81.52857054 | 2022-10-21 04:22:23 | Kanawha, West Virginia, US | |
2022-10-04 | US | Georgia | Bibb | 13021 | 43137 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-10-05 04:23:06 | Bibb, Georgia, US | |
2022-10-03 | US | Georgia | Bibb | 13021 | 43137 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-10-04 04:22:55 | Bibb, Georgia, US | |
2022-10-02 | US | Georgia | Bibb | 13021 | 43137 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-10-03 04:23:11 | Bibb, Georgia, US | |
2022-10-01 | US | Georgia | Bibb | 13021 | 43137 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-10-02 04:21:23 | Bibb, Georgia, US | |
2022-09-30 | US | Georgia | Bibb | 13021 | 43137 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-10-01 04:23:01 | Bibb, Georgia, US | |
2022-09-29 | US | Georgia | Bibb | 13021 | 43137 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-09-30 04:23:09 | Bibb, Georgia, US | |
2022-09-28 | US | Georgia | Bibb | 13021 | 43137 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-09-29 04:22:34 | Bibb, Georgia, US | |
2022-09-14 | US | Virginia | Chesterfield | 51041 | 90226 | 809 | 0 | 37.37373208 | -77.5868014 | 2022-09-15 04:21:02 | Chesterfield, Virginia, US | |
2022-09-14 | US | Alabama | Tuscaloosa | 1125 | 65131 | 809 | 0 | 33.28726072 | -87.52556818 | 2022-09-15 04:21:02 | Tuscaloosa, Alabama, US | |
2022-09-13 | US | Virginia | Chesterfield | 51041 | 90148 | 809 | 0 | 37.37373208 | -77.5868014 | 2022-09-14 04:20:44 | Chesterfield, Virginia, US | |
2022-09-13 | US | Alabama | Tuscaloosa | 1125 | 65131 | 809 | 0 | 33.28726072 | -87.52556818 | 2022-09-14 04:20:44 | Tuscaloosa, Alabama, US | |
2022-09-12 | US | Alabama | Tuscaloosa | 1125 | 65131 | 809 | 0 | 33.28726072 | -87.52556818 | 2022-09-13 04:20:57 | Tuscaloosa, Alabama, US | |
2022-09-11 | US | Alabama | Tuscaloosa | 1125 | 65131 | 809 | 0 | 33.28726072 | -87.52556818 | 2022-09-12 04:20:58 | Tuscaloosa, Alabama, US | |
2022-09-10 | US | Alabama | Tuscaloosa | 1125 | 65131 | 809 | 0 | 33.28726072 | -87.52556818 | 2022-09-11 04:20:50 | Tuscaloosa, Alabama, US | |
2022-09-09 | US | Alabama | Tuscaloosa | 1125 | 65131 | 809 | 0 | 33.28726072 | -87.52556818 | 2022-09-10 04:21:10 | Tuscaloosa, Alabama, US | |
2022-09-08 | US | Alabama | Tuscaloosa | 1125 | 65131 | 809 | 0 | 33.28726072 | -87.52556818 | 2022-09-09 04:21:11 | Tuscaloosa, Alabama, US | |
2022-09-01 | US | Missouri | St. Louis City | 29510 | 68609 | 809 | 0 | 38.63555736 | -90.24349225 | 2022-09-02 04:21:07 | St. Louis City, Missouri, US | |
2022-08-31 | US | Missouri | St. Louis City | 29510 | 68609 | 809 | 0 | 38.63555736 | -90.24349225 | 2022-09-01 04:21:03 | St. Louis City, Missouri, US | |
2022-08-30 | US | Missouri | St. Louis City | 29510 | 68609 | 809 | 0 | 38.63555736 | -90.24349225 | 2022-08-31 04:20:57 | St. Louis City, Missouri, US | |
2022-08-30 | US | Georgia | Bibb | 13021 | 42404 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-08-31 04:20:57 | Bibb, Georgia, US | |
2022-08-29 | US | Missouri | St. Louis City | 29510 | 68609 | 809 | 0 | 38.63555736 | -90.24349225 | 2022-08-30 04:21:03 | St. Louis City, Missouri, US | |
2022-08-29 | US | Georgia | Bibb | 13021 | 42404 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-08-30 04:21:03 | Bibb, Georgia, US | |
2022-08-28 | US | Missouri | St. Louis City | 29510 | 68609 | 809 | 0 | 38.63555736 | -90.24349225 | 2022-08-29 04:21:06 | St. Louis City, Missouri, US | |
2022-08-28 | US | Georgia | Bibb | 13021 | 42404 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-08-29 04:21:06 | Bibb, Georgia, US | |
2022-08-27 | US | Missouri | St. Louis City | 29510 | 68609 | 809 | 0 | 38.63555736 | -90.24349225 | 2022-08-28 04:21:02 | St. Louis City, Missouri, US | |
2022-08-27 | US | Georgia | Bibb | 13021 | 42404 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-08-28 04:21:02 | Bibb, Georgia, US | |
2022-08-26 | US | Missouri | St. Louis City | 29510 | 68609 | 809 | 0 | 38.63555736 | -90.24349225 | 2022-08-27 04:20:57 | St. Louis City, Missouri, US | |
2022-08-26 | US | Georgia | Bibb | 13021 | 42404 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-08-27 04:20:57 | Bibb, Georgia, US | |
2022-08-25 | US | Georgia | Bibb | 13021 | 42404 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-08-26 04:21:02 | Bibb, Georgia, US | |
2022-08-24 | US | Georgia | Bibb | 13021 | 42404 | 809 | 0 | 32.80904227 | -83.70489165 | 2022-08-25 04:21:13 | Bibb, Georgia, US | |
2022-08-11 | US | Illinois | Madison | 17119 | 79495 | 809 | 0 | 38.83042506 | -89.90422563 | 2022-08-12 04:20:54 | Madison, Illinois, US | |
2022-08-10 | US | Illinois | Madison | 17119 | 79393 | 809 | 0 | 38.83042506 | -89.90422563 | 2022-08-11 04:20:49 | Madison, Illinois, US | |
2022-08-09 | US | Illinois | Madison | 17119 | 79334 | 809 | 0 | 38.83042506 | -89.90422563 | 2022-08-10 04:20:57 | Madison, Illinois, US | |
2022-07-27 | Germany | Bremen | 237644 | 809 | 0 | 53.0793 | 8.8017 | 2022-07-28 04:20:56 | Bremen, Germany | |||
2022-07-26 | US | New Mexico | San Juan | 35045 | 45281 | 809 | 0 | 36.50838318 | -108.320437 | 2022-07-27 04:21:04 | San Juan, New Mexico, US | |
2022-07-23 | Cote d'Ivoire | 84950 | 809 | 0 | 7.54 | -5.5471 | 2022-07-24 04:20:47 | Cote d'Ivoire | ||||
2022-07-22 | Cote d'Ivoire | 84889 | 809 | 0 | 7.54 | -5.5471 | 2022-07-23 04:20:53 | Cote d'Ivoire | ||||
2022-07-13 | US | Minnesota | Anoka | 27003 | 105598 | 809 | 0 | 45.27476015 | -93.24604565 | 2022-07-14 04:20:57 | Anoka, Minnesota, US | |
2022-07-12 | US | Minnesota | Anoka | 27003 | 105598 | 809 | 0 | 45.27476015 | -93.24604565 | 2022-07-13 04:20:58 | Anoka, Minnesota, US | |
2022-07-11 | US | Minnesota | Anoka | 27003 | 105598 | 809 | 0 | 45.27476015 | -93.24604565 | 2022-07-12 04:20:51 | Anoka, Minnesota, US | |
2022-07-10 | US | Minnesota | Anoka | 27003 | 105598 | 809 | 0 | 45.27476015 | -93.24604565 | 2022-07-11 04:20:46 | Anoka, Minnesota, US | |
2022-07-09 | US | Minnesota | Anoka | 27003 | 105598 | 809 | 0 | 45.27476015 | -93.24604565 | 2022-07-10 04:20:54 | Anoka, Minnesota, US | |
2022-07-08 | US | Minnesota | Anoka | 27003 | 105598 | 809 | 0 | 45.27476015 | -93.24604565 | 2022-07-09 04:20:59 | Anoka, Minnesota, US | |
2022-07-07 | US | Minnesota | Anoka | 27003 | 105598 | 809 | 0 | 45.27476015 | -93.24604565 | 2022-07-08 04:20:56 | Anoka, Minnesota, US | |
2022-05-21 | US | Washington | Clark | 53011 | 92553 | 809 | 0 | 45.77568046 | -122.4829204 | 2022-05-22 04:20:52 | Clark, Washington, US | |
2022-05-21 | US | New York | Oneida | 36065 | 59140 | 809 | 0 | 43.24375382 | -75.43710392 | 2022-05-22 04:20:52 | Oneida, New York, US | |
2022-05-20 | US | Washington | Clark | 53011 | 92553 | 809 | 0 | 45.77568046 | -122.4829204 | 2022-05-21 04:20:58 | Clark, Washington, US | |
2022-05-20 | US | New York | Oneida | 36065 | 59065 | 809 | 0 | 43.24375382 | -75.43710392 | 2022-05-21 04:20:58 | Oneida, New York, US | |
2022-05-04 | US | Oklahoma | Cleveland | 40027 | 79329 | 809 | 0 | 35.20413532 | -97.32519562 | 2022-05-05 04:20:55 | Cleveland, Oklahoma, US | |
2022-05-03 | US | Oklahoma | Cleveland | 40027 | 79329 | 809 | 0 | 35.20413532 | -97.32519562 | 2022-05-04 04:20:59 | Cleveland, Oklahoma, US | |
2022-05-02 | US | Oklahoma | Cleveland | 40027 | 79329 | 809 | 0 | 35.20413532 | -97.32519562 | 2022-05-03 04:21:00 | Cleveland, Oklahoma, US | |
2022-05-02 | Spain | Cantabria | 135700 | 809 | 0 | 43.1828 | -3.9878 | 2022-05-03 04:21:00 | Cantabria, Spain | |||
2022-05-01 | US | Oklahoma | Cleveland | 40027 | 79329 | 809 | 0 | 35.20413532 | -97.32519562 | 2022-05-02 04:21:10 | Cleveland, Oklahoma, US | |
2022-05-01 | Spain | Cantabria | 135700 | 809 | 0 | 43.1828 | -3.9878 | 2022-05-02 04:21:10 | Cantabria, Spain | |||
2022-04-30 | US | Oklahoma | Cleveland | 40027 | 79329 | 809 | 0 | 35.20413532 | -97.32519562 | 2022-05-01 04:20:57 | Cleveland, Oklahoma, US | |
2022-04-30 | Spain | Cantabria | 135700 | 809 | 0 | 43.1828 | -3.9878 | 2022-05-01 04:20:57 | Cantabria, Spain | |||
2022-04-30 | Chile | Arica y Parinacota | 55439 | 809 | 0 | -18.594 | -69.4785 | 2022-05-01 04:20:57 | Arica y Parinacota, Chile | |||
2022-04-29 | US | Oklahoma | Cleveland | 40027 | 79329 | 809 | 0 | 35.20413532 | -97.32519562 | 2022-04-30 04:21:05 | Cleveland, Oklahoma, US | |
2022-04-29 | Spain | Cantabria | 135700 | 809 | 0 | 43.1828 | -3.9878 | 2022-04-30 04:21:05 | Cantabria, Spain | |||
2022-04-29 | Chile | Arica y Parinacota | 55409 | 809 | 0 | -18.594 | -69.4785 | 2022-04-30 04:21:05 | Arica y Parinacota, Chile | |||
2022-04-28 | US | Oklahoma | Cleveland | 40027 | 79329 | 809 | 0 | 35.20413532 | -97.32519562 | 2022-04-29 04:20:59 | Cleveland, Oklahoma, US | |
2022-04-28 | Chile | Arica y Parinacota | 55400 | 809 | 0 | -18.594 | -69.4785 | 2022-04-29 04:20:59 | Arica y Parinacota, Chile | |||
2022-04-27 | Chile | Arica y Parinacota | 55376 | 809 | 0 | -18.594 | -69.4785 | 2022-04-28 04:20:47 | Arica y Parinacota, Chile | |||
2022-04-26 | Chile | Arica y Parinacota | 55361 | 809 | 0 | -18.594 | -69.4785 | 2022-04-27 04:20:52 | Arica y Parinacota, Chile | |||
2022-04-25 | Chile | Arica y Parinacota | 55353 | 809 | 0 | -18.594 | -69.4785 | 2022-04-26 04:20:51 | Arica y Parinacota, Chile | |||
2022-04-24 | Chile | Arica y Parinacota | 55342 | 809 | 0 | -18.594 | -69.4785 | 2022-04-25 04:20:56 | Arica y Parinacota, Chile | |||
2022-04-23 | Chile | Arica y Parinacota | 55332 | 809 | 0 | -18.594 | -69.4785 | 2022-04-24 04:20:56 | Arica y Parinacota, Chile | |||
2022-04-22 | Chile | Arica y Parinacota | 55320 | 809 | 0 | -18.594 | -69.4785 | 2022-04-23 04:20:50 | Arica y Parinacota, Chile | |||
2022-04-07 | US | Virginia | Virginia Beach | 51810 | 89360 | 809 | 0 | 36.73285734 | -76.04566934 | 2022-04-08 04:20:48 | Virginia Beach, Virginia, US | |
2022-03-20 | US | Illinois | Winnebago | 17201 | 76121 | 809 | 0 | 42.33641854 | -89.16085327 | 2022-03-21 04:20:50 | Winnebago, Illinois, US | |
2022-03-20 | Italy | Basilicata | 96397 | 809 | 0 | 40.63947052 | 15.80514834 | 2022-03-21 04:20:50 | Basilicata, Italy | |||
2022-03-19 | US | Illinois | Winnebago | 17201 | 76121 | 809 | 0 | 42.33641854 | -89.16085327 | 2022-03-20 04:20:45 | Winnebago, Illinois, US | |
2022-03-18 | US | Illinois | Winnebago | 17201 | 76121 | 809 | 0 | 42.33641854 | -89.16085327 | 2022-03-19 04:20:47 | Winnebago, Illinois, US | |
2022-03-04 | US | Texas | Jefferson | 48245 | 44388 | 809 | 0 | 29.8832777 | -94.16434171 | 2022-03-05 04:21:10 | Jefferson, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;