daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,336 rows where deaths = 34 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 >30
- US 18,465
- Japan 198
- Russia 155
- Netherlands 78
- United Kingdom 50
- Ukraine 37
- Iceland 22
- Malaysia 22
- Colombia 21
- Maldives 20
- Australia 18
- Sao Tome and Principe 16
- Chile 13
- Singapore 13
- India 12
- Peru 11
- Rwanda 11
- Sweden 11
- Guinea-Bissau 9
- France 8
- Latvia 8
- Liberia 8
- Botswana 7
- Albania 5
- Canada 5
- Guinea 5
- Uruguay 5
- Benin 4
- Dominica 4
- Ghana 4
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | West Virginia | Pocahontas | 54075 | 2509 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-30 04:21:04 | Pocahontas, West Virginia, US | |
2022-12-29 | US | Washington | Jefferson | 53031 | 4657 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-30 04:21:04 | Jefferson, Washington, US | |
2022-12-29 | US | Virginia | Lexington | 51678 | 2591 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-30 04:21:04 | Lexington, Virginia, US | |
2022-12-29 | US | Texas | Swisher | 48437 | 2602 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-30 04:21:04 | Swisher, Texas, US | |
2022-12-29 | US | Texas | Childress | 48075 | 2952 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-30 04:21:04 | Childress, Texas, US | |
2022-12-29 | US | South Dakota | Gregory | 46053 | 1201 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-30 04:21:04 | Gregory, South Dakota, US | |
2022-12-29 | US | North Dakota | Walsh | 38099 | 3980 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-30 04:21:04 | Walsh, North Dakota, US | |
2022-12-29 | US | Missouri | Harrison | 29081 | 2374 | 34 | 0 | 40.35570088 | -93.99222144 | 2022-12-30 04:21:04 | Harrison, Missouri, US | |
2022-12-29 | US | Minnesota | Swift | 27151 | 2658 | 34 | 0 | 45.2829032 | -95.68264092 | 2022-12-30 04:21:04 | Swift, Minnesota, US | |
2022-12-29 | US | Minnesota | Pipestone | 27117 | 2315 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-12-30 04:21:04 | Pipestone, Minnesota, US | |
2022-12-29 | US | Iowa | Wayne | 19185 | 1494 | 34 | 0 | 40.73969028 | -93.32752197 | 2022-12-30 04:21:04 | Wayne, Iowa, US | |
2022-12-29 | US | Idaho | Caribou | 16029 | 1658 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-30 04:21:04 | Caribou, Idaho, US | |
2022-12-29 | US | Georgia | Talbot | 13263 | 1339 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-12-30 04:21:04 | Talbot, Georgia, US | |
2022-12-29 | US | Colorado | Washington | 8121 | 1223 | 34 | 0 | 39.97015535 | -103.202587 | 2022-12-30 04:21:04 | Washington, Colorado, US | |
2022-12-29 | US | Colorado | Routt | 8107 | 7719 | 34 | 0 | 40.48596505 | -106.9905548 | 2022-12-30 04:21:04 | Routt, Colorado, US | |
2022-12-29 | US | American Samoa | 60 | 8266 | 34 | 0 | -14.271 | -170.132 | 2022-12-30 04:21:04 | American Samoa, US | ||
2022-12-28 | US | West Virginia | Pocahontas | 54075 | 2507 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-29 04:21:01 | Pocahontas, West Virginia, US | |
2022-12-28 | US | Washington | Jefferson | 53031 | 4657 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-29 04:21:01 | Jefferson, Washington, US | |
2022-12-28 | US | Virginia | Lexington | 51678 | 2591 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-29 04:21:01 | Lexington, Virginia, US | |
2022-12-28 | US | Texas | Swisher | 48437 | 2602 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-29 04:21:01 | Swisher, Texas, US | |
2022-12-28 | US | Texas | Childress | 48075 | 2952 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-29 04:21:01 | Childress, Texas, US | |
2022-12-28 | US | South Dakota | Gregory | 46053 | 1201 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-29 04:21:01 | Gregory, South Dakota, US | |
2022-12-28 | US | North Dakota | Walsh | 38099 | 3980 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-29 04:21:01 | Walsh, North Dakota, US | |
2022-12-28 | US | Missouri | Harrison | 29081 | 2374 | 34 | 0 | 40.35570088 | -93.99222144 | 2022-12-29 04:21:01 | Harrison, Missouri, US | |
2022-12-28 | US | Minnesota | Swift | 27151 | 2655 | 34 | 0 | 45.2829032 | -95.68264092 | 2022-12-29 04:21:01 | Swift, Minnesota, US | |
2022-12-28 | US | Minnesota | Pipestone | 27117 | 2308 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-12-29 04:21:01 | Pipestone, Minnesota, US | |
2022-12-28 | US | Iowa | Wayne | 19185 | 1494 | 34 | 0 | 40.73969028 | -93.32752197 | 2022-12-29 04:21:01 | Wayne, Iowa, US | |
2022-12-28 | US | Idaho | Caribou | 16029 | 1658 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-29 04:21:01 | Caribou, Idaho, US | |
2022-12-28 | US | Georgia | Talbot | 13263 | 1339 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-12-29 04:21:01 | Talbot, Georgia, US | |
2022-12-28 | US | Colorado | Washington | 8121 | 1223 | 34 | 0 | 39.97015535 | -103.202587 | 2022-12-29 04:21:01 | Washington, Colorado, US | |
2022-12-28 | US | Colorado | Routt | 8107 | 7715 | 34 | 0 | 40.48596505 | -106.9905548 | 2022-12-29 04:21:01 | Routt, Colorado, US | |
2022-12-28 | US | American Samoa | 60 | 8266 | 34 | 0 | -14.271 | -170.132 | 2022-12-29 04:21:01 | American Samoa, US | ||
2022-12-27 | US | West Virginia | Pocahontas | 54075 | 2505 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-28 04:21:04 | Pocahontas, West Virginia, US | |
2022-12-27 | US | Washington | Jefferson | 53031 | 4634 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-28 04:21:04 | Jefferson, Washington, US | |
2022-12-27 | US | Virginia | Lexington | 51678 | 2587 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-28 04:21:04 | Lexington, Virginia, US | |
2022-12-27 | US | Texas | Swisher | 48437 | 2596 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-28 04:21:04 | Swisher, Texas, US | |
2022-12-27 | US | Texas | Childress | 48075 | 2931 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-28 04:21:04 | Childress, Texas, US | |
2022-12-27 | US | South Dakota | Gregory | 46053 | 1199 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-28 04:21:04 | Gregory, South Dakota, US | |
2022-12-27 | US | North Dakota | Walsh | 38099 | 3980 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-28 04:21:04 | Walsh, North Dakota, US | |
2022-12-27 | US | Missouri | Harrison | 29081 | 2374 | 34 | 0 | 40.35570088 | -93.99222144 | 2022-12-28 04:21:04 | Harrison, Missouri, US | |
2022-12-27 | US | Minnesota | Swift | 27151 | 2655 | 34 | 0 | 45.2829032 | -95.68264092 | 2022-12-28 04:21:04 | Swift, Minnesota, US | |
2022-12-27 | US | Minnesota | Pipestone | 27117 | 2308 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-12-28 04:21:04 | Pipestone, Minnesota, US | |
2022-12-27 | US | Iowa | Wayne | 19185 | 1493 | 34 | 0 | 40.73969028 | -93.32752197 | 2022-12-28 04:21:04 | Wayne, Iowa, US | |
2022-12-27 | US | Idaho | Caribou | 16029 | 1657 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-28 04:21:04 | Caribou, Idaho, US | |
2022-12-27 | US | Georgia | Talbot | 13263 | 1336 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-12-28 04:21:04 | Talbot, Georgia, US | |
2022-12-27 | US | Colorado | Washington | 8121 | 1222 | 34 | 0 | 39.97015535 | -103.202587 | 2022-12-28 04:21:04 | Washington, Colorado, US | |
2022-12-27 | US | Colorado | Routt | 8107 | 7712 | 34 | 0 | 40.48596505 | -106.9905548 | 2022-12-28 04:21:04 | Routt, Colorado, US | |
2022-12-27 | US | American Samoa | 60 | 8266 | 34 | 0 | -14.271 | -170.132 | 2022-12-28 04:21:04 | American Samoa, US | ||
2022-12-26 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-27 04:21:07 | Pocahontas, West Virginia, US | |
2022-12-26 | US | Washington | Jefferson | 53031 | 4634 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-27 04:21:07 | Jefferson, Washington, US | |
2022-12-26 | US | Virginia | Lexington | 51678 | 2587 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-27 04:21:07 | Lexington, Virginia, US | |
2022-12-26 | US | Texas | Swisher | 48437 | 2596 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-27 04:21:07 | Swisher, Texas, US | |
2022-12-26 | US | Texas | Childress | 48075 | 2931 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-27 04:21:07 | Childress, Texas, US | |
2022-12-26 | US | South Dakota | Gregory | 46053 | 1199 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-27 04:21:07 | Gregory, South Dakota, US | |
2022-12-26 | US | North Dakota | Walsh | 38099 | 3980 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-27 04:21:07 | Walsh, North Dakota, US | |
2022-12-26 | US | Minnesota | Swift | 27151 | 2655 | 34 | 0 | 45.2829032 | -95.68264092 | 2022-12-27 04:21:07 | Swift, Minnesota, US | |
2022-12-26 | US | Minnesota | Pipestone | 27117 | 2308 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-12-27 04:21:07 | Pipestone, Minnesota, US | |
2022-12-26 | US | Iowa | Wayne | 19185 | 1493 | 34 | 0 | 40.73969028 | -93.32752197 | 2022-12-27 04:21:07 | Wayne, Iowa, US | |
2022-12-26 | US | Idaho | Caribou | 16029 | 1657 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-27 04:21:07 | Caribou, Idaho, US | |
2022-12-26 | US | Georgia | Talbot | 13263 | 1336 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-12-27 04:21:07 | Talbot, Georgia, US | |
2022-12-26 | US | Colorado | Washington | 8121 | 1222 | 34 | 0 | 39.97015535 | -103.202587 | 2022-12-27 04:21:07 | Washington, Colorado, US | |
2022-12-26 | US | Colorado | Routt | 8107 | 7708 | 34 | 0 | 40.48596505 | -106.9905548 | 2022-12-27 04:21:07 | Routt, Colorado, US | |
2022-12-26 | US | American Samoa | 60 | 8266 | 34 | 0 | -14.271 | -170.132 | 2022-12-27 04:21:07 | American Samoa, US | ||
2022-12-25 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-26 04:21:06 | Pocahontas, West Virginia, US | |
2022-12-25 | US | Washington | Jefferson | 53031 | 4634 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-26 04:21:06 | Jefferson, Washington, US | |
2022-12-25 | US | Virginia | Lexington | 51678 | 2579 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-26 04:21:06 | Lexington, Virginia, US | |
2022-12-25 | US | Texas | Swisher | 48437 | 2596 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-26 04:21:06 | Swisher, Texas, US | |
2022-12-25 | US | Texas | Childress | 48075 | 2931 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-26 04:21:06 | Childress, Texas, US | |
2022-12-25 | US | South Dakota | Gregory | 46053 | 1199 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-26 04:21:06 | Gregory, South Dakota, US | |
2022-12-25 | US | North Dakota | Walsh | 38099 | 3980 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-26 04:21:06 | Walsh, North Dakota, US | |
2022-12-25 | US | Minnesota | Swift | 27151 | 2655 | 34 | 0 | 45.2829032 | -95.68264092 | 2022-12-26 04:21:06 | Swift, Minnesota, US | |
2022-12-25 | US | Minnesota | Pipestone | 27117 | 2308 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-12-26 04:21:06 | Pipestone, Minnesota, US | |
2022-12-25 | US | Iowa | Wayne | 19185 | 1493 | 34 | 0 | 40.73969028 | -93.32752197 | 2022-12-26 04:21:06 | Wayne, Iowa, US | |
2022-12-25 | US | Idaho | Caribou | 16029 | 1657 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-26 04:21:06 | Caribou, Idaho, US | |
2022-12-25 | US | Georgia | Talbot | 13263 | 1336 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-12-26 04:21:06 | Talbot, Georgia, US | |
2022-12-25 | US | Colorado | Washington | 8121 | 1222 | 34 | 0 | 39.97015535 | -103.202587 | 2022-12-26 04:21:06 | Washington, Colorado, US | |
2022-12-25 | US | Colorado | Routt | 8107 | 7704 | 34 | 0 | 40.48596505 | -106.9905548 | 2022-12-26 04:21:06 | Routt, Colorado, US | |
2022-12-25 | US | American Samoa | 60 | 8266 | 34 | 0 | -14.271 | -170.132 | 2022-12-26 04:21:06 | American Samoa, US | ||
2022-12-24 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-25 04:21:04 | Pocahontas, West Virginia, US | |
2022-12-24 | US | Washington | Jefferson | 53031 | 4634 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-25 04:21:04 | Jefferson, Washington, US | |
2022-12-24 | US | Virginia | Lexington | 51678 | 2579 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-25 04:21:04 | Lexington, Virginia, US | |
2022-12-24 | US | Texas | Swisher | 48437 | 2596 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-25 04:21:04 | Swisher, Texas, US | |
2022-12-24 | US | Texas | Childress | 48075 | 2931 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-25 04:21:04 | Childress, Texas, US | |
2022-12-24 | US | South Dakota | Gregory | 46053 | 1199 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-25 04:21:04 | Gregory, South Dakota, US | |
2022-12-24 | US | North Dakota | Walsh | 38099 | 3980 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-25 04:21:04 | Walsh, North Dakota, US | |
2022-12-24 | US | Minnesota | Swift | 27151 | 2655 | 34 | 0 | 45.2829032 | -95.68264092 | 2022-12-25 04:21:04 | Swift, Minnesota, US | |
2022-12-24 | US | Minnesota | Pipestone | 27117 | 2308 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-12-25 04:21:04 | Pipestone, Minnesota, US | |
2022-12-24 | US | Iowa | Wayne | 19185 | 1493 | 34 | 0 | 40.73969028 | -93.32752197 | 2022-12-25 04:21:04 | Wayne, Iowa, US | |
2022-12-24 | US | Idaho | Caribou | 16029 | 1657 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-25 04:21:04 | Caribou, Idaho, US | |
2022-12-24 | US | Georgia | Talbot | 13263 | 1336 | 34 | 0 | 32.69642758 | -84.53351366 | 2022-12-25 04:21:04 | Talbot, Georgia, US | |
2022-12-24 | US | Colorado | Washington | 8121 | 1222 | 34 | 0 | 39.97015535 | -103.202587 | 2022-12-25 04:21:04 | Washington, Colorado, US | |
2022-12-24 | US | Colorado | Routt | 8107 | 7704 | 34 | 0 | 40.48596505 | -106.9905548 | 2022-12-25 04:21:04 | Routt, Colorado, US | |
2022-12-24 | US | American Samoa | 60 | 8266 | 34 | 0 | -14.271 | -170.132 | 2022-12-25 04:21:04 | American Samoa, US | ||
2022-12-23 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-24 04:21:02 | Pocahontas, West Virginia, US | |
2022-12-23 | US | Washington | Jefferson | 53031 | 4634 | 34 | 0 | 47.75003077 | -123.5609704 | 2022-12-24 04:21:02 | Jefferson, Washington, US | |
2022-12-23 | US | Virginia | Lexington | 51678 | 2579 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-12-24 04:21:02 | Lexington, Virginia, US | |
2022-12-23 | US | Texas | Swisher | 48437 | 2596 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-24 04:21:02 | Swisher, Texas, US | |
2022-12-23 | US | Texas | Childress | 48075 | 2931 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-12-24 04:21:02 | Childress, Texas, US | |
2022-12-23 | US | South Dakota | Gregory | 46053 | 1199 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-24 04:21:02 | Gregory, South Dakota, US | |
2022-12-23 | US | North Dakota | Walsh | 38099 | 3980 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-12-24 04:21:02 | Walsh, North Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;