daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
415 rows where deaths = 826 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 194
- Russia 87
- Spain 29
- Cote d'Ivoire 16
- Sweden 14
- Japan 11
- Chile 10
- India 9
- Mozambique 6
- Fiji 4
- Brazil 3
- Colombia 3
- El Salvador 3
- Peru 3
- Ukraine 3
- Australia 2
- Italy 2
- Netherlands 2
- Austria 1
- Cuba 1
- France 1
- Kuwait 1
- Malaysia 1
- Mexico 1
- Montenegro 1
- Norway 1
- Serbia 1
- Singapore 1
- Taiwan* 1
- United Arab Emirates 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-16 | Japan | Okinawa | 529654 | 826 | 0 | 25.768923 | 126.668016 | 2022-12-17 04:21:04 | Okinawa, Japan | |||
2022-12-15 | Japan | Okinawa | 528964 | 826 | 0 | 25.768923 | 126.668016 | 2022-12-16 04:21:01 | Okinawa, Japan | |||
2022-12-14 | Japan | Okinawa | 528175 | 826 | 0 | 25.768923 | 126.668016 | 2022-12-15 04:20:58 | Okinawa, Japan | |||
2022-12-06 | Japan | Shizuoka | 589986 | 826 | 0 | 34.916975 | 138.407784 | 2022-12-07 04:20:58 | Shizuoka, Japan | |||
2022-11-17 | US | West Virginia | Kanawha | 54039 | 56776 | 826 | 0 | 38.33860077 | -81.52857054 | 2022-11-18 04:21:15 | Kanawha, West Virginia, US | |
2022-11-09 | US | Illinois | Madison | 17119 | 83312 | 826 | 0 | 38.83042506 | -89.90422563 | 2022-11-10 04:21:16 | Madison, Illinois, US | |
2022-11-07 | US | Missouri | St. Louis City | 29510 | 71546 | 826 | 0 | 38.63555736 | -90.24349225 | 2022-11-08 04:21:21 | St. Louis City, Missouri, US | |
2022-11-06 | US | Missouri | St. Louis City | 29510 | 71546 | 826 | 0 | 38.63555736 | -90.24349225 | 2022-11-07 04:21:26 | St. Louis City, Missouri, US | |
2022-11-05 | US | Missouri | St. Louis City | 29510 | 71546 | 826 | 0 | 38.63555736 | -90.24349225 | 2022-11-06 04:21:24 | St. Louis City, Missouri, US | |
2022-11-04 | US | Missouri | St. Louis City | 29510 | 71546 | 826 | 0 | 38.63555736 | -90.24349225 | 2022-11-05 04:21:52 | St. Louis City, Missouri, US | |
2022-11-03 | US | Missouri | St. Louis City | 29510 | 71546 | 826 | 0 | 38.63555736 | -90.24349225 | 2022-11-04 04:22:11 | St. Louis City, Missouri, US | |
2022-11-02 | US | Missouri | St. Louis City | 29510 | 71546 | 826 | 0 | 38.63555736 | -90.24349225 | 2022-11-03 04:22:05 | St. Louis City, Missouri, US | |
2022-11-01 | US | Missouri | St. Louis City | 29510 | 71546 | 826 | 0 | 38.63555736 | -90.24349225 | 2022-11-02 04:22:09 | St. Louis City, Missouri, US | |
2022-10-19 | US | Alabama | Tuscaloosa | 1125 | 66022 | 826 | 0 | 33.28726072 | -87.52556818 | 2022-10-20 04:22:59 | Tuscaloosa, Alabama, US | |
2022-10-18 | US | Alabama | Tuscaloosa | 1125 | 66022 | 826 | 0 | 33.28726072 | -87.52556818 | 2022-10-19 04:22:26 | Tuscaloosa, Alabama, US | |
2022-10-17 | US | Alabama | Tuscaloosa | 1125 | 66022 | 826 | 0 | 33.28726072 | -87.52556818 | 2022-10-18 04:22:42 | Tuscaloosa, Alabama, US | |
2022-10-16 | US | Alabama | Tuscaloosa | 1125 | 66022 | 826 | 0 | 33.28726072 | -87.52556818 | 2022-10-17 04:20:31 | Tuscaloosa, Alabama, US | |
2022-10-15 | US | Alabama | Tuscaloosa | 1125 | 66022 | 826 | 0 | 33.28726072 | -87.52556818 | 2022-10-16 04:22:39 | Tuscaloosa, Alabama, US | |
2022-10-14 | US | Alabama | Tuscaloosa | 1125 | 66022 | 826 | 0 | 33.28726072 | -87.52556818 | 2022-10-15 04:22:00 | Tuscaloosa, Alabama, US | |
2022-10-14 | Cote d'Ivoire | 87509 | 826 | 0 | 7.54 | -5.5471 | 2022-10-15 04:22:00 | Cote d'Ivoire | ||||
2022-10-13 | US | Alabama | Tuscaloosa | 1125 | 66022 | 826 | 0 | 33.28726072 | -87.52556818 | 2022-10-14 04:22:28 | Tuscaloosa, Alabama, US | |
2022-10-13 | Cote d'Ivoire | 87509 | 826 | 0 | 7.54 | -5.5471 | 2022-10-14 04:22:28 | Cote d'Ivoire | ||||
2022-10-12 | US | Minnesota | Dakota | 27037 | 129015 | 826 | 0 | 44.67172617 | -93.06299363 | 2022-10-13 04:22:39 | Dakota, Minnesota, US | |
2022-10-12 | Cote d'Ivoire | 87490 | 826 | 0 | 7.54 | -5.5471 | 2022-10-13 04:22:39 | Cote d'Ivoire | ||||
2022-10-11 | US | Minnesota | Dakota | 27037 | 129015 | 826 | 0 | 44.67172617 | -93.06299363 | 2022-10-12 04:22:51 | Dakota, Minnesota, US | |
2022-10-11 | Cote d'Ivoire | 87455 | 826 | 0 | 7.54 | -5.5471 | 2022-10-12 04:22:51 | Cote d'Ivoire | ||||
2022-10-10 | US | Minnesota | Dakota | 27037 | 129015 | 826 | 0 | 44.67172617 | -93.06299363 | 2022-10-11 04:23:05 | Dakota, Minnesota, US | |
2022-10-10 | Cote d'Ivoire | 87438 | 826 | 0 | 7.54 | -5.5471 | 2022-10-11 04:23:05 | Cote d'Ivoire | ||||
2022-10-09 | US | Minnesota | Dakota | 27037 | 129015 | 826 | 0 | 44.67172617 | -93.06299363 | 2022-10-10 04:22:32 | Dakota, Minnesota, US | |
2022-10-09 | Cote d'Ivoire | 87428 | 826 | 0 | 7.54 | -5.5471 | 2022-10-10 04:22:32 | Cote d'Ivoire | ||||
2022-10-08 | US | Minnesota | Dakota | 27037 | 129015 | 826 | 0 | 44.67172617 | -93.06299363 | 2022-10-09 04:21:16 | Dakota, Minnesota, US | |
2022-10-08 | Cote d'Ivoire | 87422 | 826 | 0 | 7.54 | -5.5471 | 2022-10-09 04:21:16 | Cote d'Ivoire | ||||
2022-10-07 | US | Minnesota | Dakota | 27037 | 129015 | 826 | 0 | 44.67172617 | -93.06299363 | 2022-10-08 04:22:56 | Dakota, Minnesota, US | |
2022-10-07 | Cote d'Ivoire | 87388 | 826 | 0 | 7.54 | -5.5471 | 2022-10-08 04:22:56 | Cote d'Ivoire | ||||
2022-10-06 | US | Minnesota | Dakota | 27037 | 129015 | 826 | 0 | 44.67172617 | -93.06299363 | 2022-10-07 04:23:08 | Dakota, Minnesota, US | |
2022-10-06 | Cote d'Ivoire | 87374 | 826 | 0 | 7.54 | -5.5471 | 2022-10-07 04:23:08 | Cote d'Ivoire | ||||
2022-10-05 | Cote d'Ivoire | 87316 | 826 | 0 | 7.54 | -5.5471 | 2022-10-06 04:21:22 | Cote d'Ivoire | ||||
2022-10-04 | Cote d'Ivoire | 87316 | 826 | 0 | 7.54 | -5.5471 | 2022-10-05 04:23:06 | Cote d'Ivoire | ||||
2022-10-03 | Cote d'Ivoire | 87293 | 826 | 0 | 7.54 | -5.5471 | 2022-10-04 04:22:55 | Cote d'Ivoire | ||||
2022-10-02 | Cote d'Ivoire | 87282 | 826 | 0 | 7.54 | -5.5471 | 2022-10-03 04:23:11 | Cote d'Ivoire | ||||
2022-10-01 | Cote d'Ivoire | 87258 | 826 | 0 | 7.54 | -5.5471 | 2022-10-02 04:21:23 | Cote d'Ivoire | ||||
2022-09-30 | Cote d'Ivoire | 87208 | 826 | 0 | 7.54 | -5.5471 | 2022-10-01 04:23:01 | Cote d'Ivoire | ||||
2022-09-29 | Cote d'Ivoire | 87208 | 826 | 0 | 7.54 | -5.5471 | 2022-09-30 04:23:09 | Cote d'Ivoire | ||||
2022-09-15 | US | California | San Mateo | 6081 | 177167 | 826 | 0 | 37.4228808 | -122.3275546 | 2022-09-16 04:21:19 | San Mateo, California, US | |
2022-09-14 | US | California | San Mateo | 6081 | 177162 | 826 | 0 | 37.4228808 | -122.3275546 | 2022-09-15 04:21:02 | San Mateo, California, US | |
2022-09-13 | US | California | San Mateo | 6081 | 177158 | 826 | 0 | 37.4228808 | -122.3275546 | 2022-09-14 04:20:44 | San Mateo, California, US | |
2022-09-12 | US | California | San Mateo | 6081 | 176740 | 826 | 0 | 37.4228808 | -122.3275546 | 2022-09-13 04:20:57 | San Mateo, California, US | |
2022-09-11 | US | California | San Mateo | 6081 | 176735 | 826 | 0 | 37.4228808 | -122.3275546 | 2022-09-12 04:20:58 | San Mateo, California, US | |
2022-09-10 | US | California | San Mateo | 6081 | 176726 | 826 | 0 | 37.4228808 | -122.3275546 | 2022-09-11 04:20:50 | San Mateo, California, US | |
2022-09-09 | US | California | San Mateo | 6081 | 176724 | 826 | 0 | 37.4228808 | -122.3275546 | 2022-09-10 04:21:10 | San Mateo, California, US | |
2022-08-31 | US | New York | Oneida | 36065 | 62722 | 826 | 0 | 43.24375382 | -75.43710392 | 2022-09-01 04:21:03 | Oneida, New York, US | |
2022-08-30 | US | Washington | Yakima | 53077 | 79575 | 826 | 0 | 46.45738486 | -120.7380126 | 2022-08-31 04:20:57 | Yakima, Washington, US | |
2022-08-30 | US | New York | Oneida | 36065 | 62665 | 826 | 0 | 43.24375382 | -75.43710392 | 2022-08-31 04:20:57 | Oneida, New York, US | |
2022-08-29 | US | Washington | Yakima | 53077 | 79575 | 826 | 0 | 46.45738486 | -120.7380126 | 2022-08-30 04:21:03 | Yakima, Washington, US | |
2022-08-29 | US | New York | Oneida | 36065 | 62635 | 826 | 0 | 43.24375382 | -75.43710392 | 2022-08-30 04:21:03 | Oneida, New York, US | |
2022-08-28 | US | Washington | Yakima | 53077 | 79398 | 826 | 0 | 46.45738486 | -120.7380126 | 2022-08-29 04:21:06 | Yakima, Washington, US | |
2022-08-27 | US | Washington | Yakima | 53077 | 79398 | 826 | 0 | 46.45738486 | -120.7380126 | 2022-08-28 04:21:02 | Yakima, Washington, US | |
2022-08-26 | US | Washington | Yakima | 53077 | 79398 | 826 | 0 | 46.45738486 | -120.7380126 | 2022-08-27 04:20:57 | Yakima, Washington, US | |
2022-08-25 | US | Washington | Yakima | 53077 | 79319 | 826 | 0 | 46.45738486 | -120.7380126 | 2022-08-26 04:21:02 | Yakima, Washington, US | |
2022-08-24 | US | Washington | Yakima | 53077 | 79319 | 826 | 0 | 46.45738486 | -120.7380126 | 2022-08-25 04:21:13 | Yakima, Washington, US | |
2022-08-03 | Chile | Arica y Parinacota | 66177 | 826 | 0 | -18.594 | -69.4785 | 2022-08-04 04:20:58 | Arica y Parinacota, Chile | |||
2022-08-02 | Chile | Arica y Parinacota | 65871 | 826 | 0 | -18.594 | -69.4785 | 2022-08-03 04:20:59 | Arica y Parinacota, Chile | |||
2022-08-01 | Chile | Arica y Parinacota | 65718 | 826 | 0 | -18.594 | -69.4785 | 2022-08-02 04:20:53 | Arica y Parinacota, Chile | |||
2022-07-31 | Chile | Arica y Parinacota | 65568 | 826 | 0 | -18.594 | -69.4785 | 2022-08-01 04:21:03 | Arica y Parinacota, Chile | |||
2022-07-17 | US | Colorado | Pueblo | 8101 | 53336 | 826 | 0 | 38.17359144 | -104.5127437 | 2022-07-18 04:20:59 | Pueblo, Colorado, US | |
2022-07-16 | US | Colorado | Pueblo | 8101 | 53297 | 826 | 0 | 38.17359144 | -104.5127437 | 2022-07-17 04:21:15 | Pueblo, Colorado, US | |
2022-07-13 | US | Oklahoma | Cleveland | 40027 | 83356 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-14 04:20:57 | Cleveland, Oklahoma, US | |
2022-07-13 | Sweden | Ostergotland | 95566 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-14 04:20:57 | Ostergotland, Sweden | |||
2022-07-12 | US | Oklahoma | Cleveland | 40027 | 83356 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-13 04:20:58 | Cleveland, Oklahoma, US | |
2022-07-12 | Sweden | Ostergotland | 95566 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-13 04:20:58 | Ostergotland, Sweden | |||
2022-07-11 | US | Oklahoma | Cleveland | 40027 | 83356 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-12 04:20:51 | Cleveland, Oklahoma, US | |
2022-07-11 | Sweden | Ostergotland | 95566 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-12 04:20:51 | Ostergotland, Sweden | |||
2022-07-10 | US | Oklahoma | Cleveland | 40027 | 83356 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-11 04:20:46 | Cleveland, Oklahoma, US | |
2022-07-10 | Sweden | Ostergotland | 95566 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-11 04:20:46 | Ostergotland, Sweden | |||
2022-07-09 | US | Oklahoma | Cleveland | 40027 | 83356 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-10 04:20:54 | Cleveland, Oklahoma, US | |
2022-07-09 | Sweden | Ostergotland | 95566 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-10 04:20:54 | Ostergotland, Sweden | |||
2022-07-08 | US | Oklahoma | Cleveland | 40027 | 83356 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-09 04:20:59 | Cleveland, Oklahoma, US | |
2022-07-08 | Sweden | Ostergotland | 95566 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-09 04:20:59 | Ostergotland, Sweden | |||
2022-07-07 | US | Oklahoma | Cleveland | 40027 | 83356 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-08 04:20:56 | Cleveland, Oklahoma, US | |
2022-07-07 | Sweden | Ostergotland | 95566 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-08 04:20:56 | Ostergotland, Sweden | |||
2022-07-06 | US | Oklahoma | Cleveland | 40027 | 82663 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-07 04:20:55 | Cleveland, Oklahoma, US | |
2022-07-06 | Sweden | Ostergotland | 95451 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-07 04:20:55 | Ostergotland, Sweden | |||
2022-07-05 | US | Oklahoma | Cleveland | 40027 | 82663 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-06 04:20:58 | Cleveland, Oklahoma, US | |
2022-07-05 | Sweden | Ostergotland | 95451 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-06 04:20:58 | Ostergotland, Sweden | |||
2022-07-04 | US | Oklahoma | Cleveland | 40027 | 82663 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-05 04:20:45 | Cleveland, Oklahoma, US | |
2022-07-04 | Sweden | Ostergotland | 95451 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-05 04:20:45 | Ostergotland, Sweden | |||
2022-07-03 | US | Oklahoma | Cleveland | 40027 | 82663 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-04 04:20:54 | Cleveland, Oklahoma, US | |
2022-07-03 | Sweden | Ostergotland | 95451 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-04 04:20:54 | Ostergotland, Sweden | |||
2022-07-02 | US | Oklahoma | Cleveland | 40027 | 82663 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-03 04:20:59 | Cleveland, Oklahoma, US | |
2022-07-02 | Sweden | Ostergotland | 95451 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-03 04:20:59 | Ostergotland, Sweden | |||
2022-07-01 | US | Oklahoma | Cleveland | 40027 | 82663 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-02 04:21:16 | Cleveland, Oklahoma, US | |
2022-07-01 | Sweden | Ostergotland | 95451 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-02 04:21:16 | Ostergotland, Sweden | |||
2022-06-30 | US | Oklahoma | Cleveland | 40027 | 82663 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-07-01 04:21:10 | Cleveland, Oklahoma, US | |
2022-06-30 | Sweden | Ostergotland | 95451 | 826 | 0 | 58.3454 | 15.5198 | 2022-07-01 04:21:10 | Ostergotland, Sweden | |||
2022-06-29 | US | Oklahoma | Cleveland | 40027 | 81975 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-06-30 04:21:01 | Cleveland, Oklahoma, US | |
2022-06-28 | US | Oklahoma | Cleveland | 40027 | 81975 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-06-29 04:20:59 | Cleveland, Oklahoma, US | |
2022-06-27 | US | Oklahoma | Cleveland | 40027 | 81975 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-06-28 04:20:58 | Cleveland, Oklahoma, US | |
2022-06-26 | US | Oklahoma | Cleveland | 40027 | 81975 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-06-27 04:21:00 | Cleveland, Oklahoma, US | |
2022-06-25 | US | Oklahoma | Cleveland | 40027 | 81975 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-06-26 04:21:02 | Cleveland, Oklahoma, US | |
2022-06-24 | US | Oklahoma | Cleveland | 40027 | 81975 | 826 | 0 | 35.20413532 | -97.32519562 | 2022-06-25 04:20:57 | Cleveland, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;