daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
634 rows where deaths = 689 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 471
- Sweden 35
- Russia 25
- Chile 15
- India 10
- Japan 9
- France 8
- Ukraine 6
- Mexico 5
- Netherlands 4
- Somalia 4
- Spain 4
- Cote d'Ivoire 3
- Germany 3
- Italy 3
- Malaysia 3
- Brazil 2
- Colombia 2
- Cyprus 2
- Oman 2
- Peru 2
- Australia 1
- Indonesia 1
- Kenya 1
- Montenegro 1
- Namibia 1
- Nigeria 1
- North Macedonia 1
- Pakistan 1
- Senegal 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | Japan | Mie | 366509 | 689 | 0 | 34.508018 | 136.376013 | 2022-12-30 04:21:04 | Mie, Japan | |||
2022-12-14 | US | Arkansas | Washington | 5143 | 78619 | 689 | 0 | 35.976844 | -94.21800746 | 2022-12-15 04:20:58 | Washington, Arkansas, US | |
2022-12-11 | US | Wisconsin | Kenosha | 55059 | 54234 | 689 | 0 | 42.57639354 | -88.04051686 | 2022-12-12 04:21:01 | Kenosha, Wisconsin, US | |
2022-12-11 | US | Kentucky | Fayette | 21067 | 116863 | 689 | 0 | 38.0368225 | -84.45576892 | 2022-12-12 04:21:01 | Fayette, Kentucky, US | |
2022-12-10 | US | Wisconsin | Kenosha | 55059 | 54234 | 689 | 0 | 42.57639354 | -88.04051686 | 2022-12-11 04:20:50 | Kenosha, Wisconsin, US | |
2022-12-10 | US | Kentucky | Fayette | 21067 | 116863 | 689 | 0 | 38.0368225 | -84.45576892 | 2022-12-11 04:20:50 | Fayette, Kentucky, US | |
2022-12-09 | US | Wisconsin | Kenosha | 55059 | 54234 | 689 | 0 | 42.57639354 | -88.04051686 | 2022-12-10 04:21:02 | Kenosha, Wisconsin, US | |
2022-12-09 | US | Kentucky | Fayette | 21067 | 116863 | 689 | 0 | 38.0368225 | -84.45576892 | 2022-12-10 04:21:02 | Fayette, Kentucky, US | |
2022-12-08 | US | Wisconsin | Kenosha | 55059 | 54176 | 689 | 0 | 42.57639354 | -88.04051686 | 2022-12-09 04:21:05 | Kenosha, Wisconsin, US | |
2022-12-08 | US | Kentucky | Fayette | 21067 | 116863 | 689 | 0 | 38.0368225 | -84.45576892 | 2022-12-09 04:21:05 | Fayette, Kentucky, US | |
2022-12-07 | US | Kentucky | Fayette | 21067 | 116863 | 689 | 0 | 38.0368225 | -84.45576892 | 2022-12-08 04:21:07 | Fayette, Kentucky, US | |
2022-12-06 | US | Kentucky | Fayette | 21067 | 116863 | 689 | 0 | 38.0368225 | -84.45576892 | 2022-12-07 04:20:58 | Fayette, Kentucky, US | |
2022-12-05 | US | Kentucky | Fayette | 21067 | 116863 | 689 | 0 | 38.0368225 | -84.45576892 | 2022-12-06 04:21:03 | Fayette, Kentucky, US | |
2022-11-30 | Chile | Atacama | 107589 | 689 | 0 | -27.5661 | -70.0503 | 2022-12-01 04:21:03 | Atacama, Chile | |||
2022-11-29 | Chile | Atacama | 107410 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-30 04:21:07 | Atacama, Chile | |||
2022-11-28 | Japan | Kumamoto | 366067 | 689 | 0 | 32.608154 | 130.745231 | 2022-11-29 04:21:05 | Kumamoto, Japan | |||
2022-11-28 | Chile | Atacama | 107316 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-29 04:21:05 | Atacama, Chile | |||
2022-11-27 | Chile | Atacama | 107223 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-28 04:21:02 | Atacama, Chile | |||
2022-11-26 | Chile | Atacama | 107121 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-27 04:21:05 | Atacama, Chile | |||
2022-11-25 | Chile | Atacama | 106993 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-26 04:21:11 | Atacama, Chile | |||
2022-11-24 | Chile | Atacama | 106861 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-25 04:21:06 | Atacama, Chile | |||
2022-11-23 | Sweden | Vasternorrland | 56745 | 689 | 0 | 63.4276 | 17.7292 | 2022-11-24 04:21:09 | Vasternorrland, Sweden | |||
2022-11-23 | Chile | Atacama | 106691 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-24 04:21:09 | Atacama, Chile | |||
2022-11-22 | Sweden | Vasternorrland | 56745 | 689 | 0 | 63.4276 | 17.7292 | 2022-11-23 04:21:06 | Vasternorrland, Sweden | |||
2022-11-22 | Chile | Atacama | 106525 | 689 | 0 | -27.5661 | -70.0503 | 2022-11-23 04:21:06 | Atacama, Chile | |||
2022-11-21 | Sweden | Vasternorrland | 56745 | 689 | 0 | 63.4276 | 17.7292 | 2022-11-22 04:20:47 | Vasternorrland, Sweden | |||
2022-11-20 | Sweden | Vasternorrland | 56745 | 689 | 0 | 63.4276 | 17.7292 | 2022-11-21 04:21:05 | Vasternorrland, Sweden | |||
2022-11-19 | Sweden | Vasternorrland | 56745 | 689 | 0 | 63.4276 | 17.7292 | 2022-11-20 04:21:08 | Vasternorrland, Sweden | |||
2022-11-18 | Sweden | Vasternorrland | 56745 | 689 | 0 | 63.4276 | 17.7292 | 2022-11-19 04:21:14 | Vasternorrland, Sweden | |||
2022-11-17 | Sweden | Vasternorrland | 56745 | 689 | 0 | 63.4276 | 17.7292 | 2022-11-18 04:21:15 | Vasternorrland, Sweden | |||
2022-09-15 | US | Delaware | Kent | 10001 | 59355 | 689 | 0 | 39.08646628 | -75.56884914 | 2022-09-16 04:21:19 | Kent, Delaware, US | |
2022-09-14 | US | Delaware | Kent | 10001 | 59312 | 689 | 0 | 39.08646628 | -75.56884914 | 2022-09-15 04:21:02 | Kent, Delaware, US | |
2022-09-13 | US | Delaware | Kent | 10001 | 59271 | 689 | 0 | 39.08646628 | -75.56884914 | 2022-09-14 04:20:44 | Kent, Delaware, US | |
2022-09-12 | US | Delaware | Kent | 10001 | 59256 | 689 | 0 | 39.08646628 | -75.56884914 | 2022-09-13 04:20:57 | Kent, Delaware, US | |
2022-09-11 | US | Delaware | Kent | 10001 | 59144 | 689 | 0 | 39.08646628 | -75.56884914 | 2022-09-12 04:20:58 | Kent, Delaware, US | |
2022-09-10 | US | Delaware | Kent | 10001 | 59144 | 689 | 0 | 39.08646628 | -75.56884914 | 2022-09-11 04:20:50 | Kent, Delaware, US | |
2022-09-09 | US | Delaware | Kent | 10001 | 59144 | 689 | 0 | 39.08646628 | -75.56884914 | 2022-09-10 04:21:10 | Kent, Delaware, US | |
2022-09-07 | Japan | Hiroshima | 388158 | 689 | 0 | 34.605309 | 132.788719 | 2022-09-08 04:21:02 | Hiroshima, Japan | |||
2022-09-01 | US | Oregon | Washington | 41067 | 111543 | 689 | 0 | 45.55972701 | -123.0955257 | 2022-09-02 04:21:07 | Washington, Oregon, US | |
2022-09-01 | US | Indiana | Hamilton | 18057 | 91278 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-09-02 04:21:07 | Hamilton, Indiana, US | |
2022-08-31 | US | Oregon | Washington | 41067 | 111486 | 689 | 0 | 45.55972701 | -123.0955257 | 2022-09-01 04:21:03 | Washington, Oregon, US | |
2022-08-31 | US | Indiana | Hamilton | 18057 | 91278 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-09-01 04:21:03 | Hamilton, Indiana, US | |
2022-08-30 | US | Indiana | Hamilton | 18057 | 91173 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-08-31 04:20:57 | Hamilton, Indiana, US | |
2022-08-29 | US | Indiana | Hamilton | 18057 | 91173 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-08-30 04:21:03 | Hamilton, Indiana, US | |
2022-08-28 | US | New York | Dutchess | 36027 | 75368 | 689 | 0 | 41.7648606 | -73.74356679 | 2022-08-29 04:21:06 | Dutchess, New York, US | |
2022-08-28 | US | Indiana | Hamilton | 18057 | 91046 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-08-29 04:21:06 | Hamilton, Indiana, US | |
2022-08-27 | US | New York | Dutchess | 36027 | 75330 | 689 | 0 | 41.7648606 | -73.74356679 | 2022-08-28 04:21:02 | Dutchess, New York, US | |
2022-08-27 | US | Indiana | Hamilton | 18057 | 91046 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-08-28 04:21:02 | Hamilton, Indiana, US | |
2022-08-26 | US | New York | Dutchess | 36027 | 75271 | 689 | 0 | 41.7648606 | -73.74356679 | 2022-08-27 04:20:57 | Dutchess, New York, US | |
2022-08-26 | US | Indiana | Hamilton | 18057 | 91046 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-08-27 04:20:57 | Hamilton, Indiana, US | |
2022-08-25 | US | New York | Dutchess | 36027 | 75217 | 689 | 0 | 41.7648606 | -73.74356679 | 2022-08-26 04:21:02 | Dutchess, New York, US | |
2022-08-25 | US | Indiana | Hamilton | 18057 | 90928 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-08-26 04:21:02 | Hamilton, Indiana, US | |
2022-08-24 | US | New York | Dutchess | 36027 | 75105 | 689 | 0 | 41.7648606 | -73.74356679 | 2022-08-25 04:21:13 | Dutchess, New York, US | |
2022-08-24 | US | Indiana | Hamilton | 18057 | 90928 | 689 | 0 | 40.07306535 | -86.05244729 | 2022-08-25 04:21:13 | Hamilton, Indiana, US | |
2022-08-23 | US | New York | Dutchess | 36027 | 75043 | 689 | 0 | 41.7648606 | -73.74356679 | 2022-08-24 04:20:46 | Dutchess, New York, US | |
2022-08-18 | US | Texas | Wichita | 48485 | 35928 | 689 | 0 | 33.98842886 | -98.7041034 | 2022-08-19 04:20:54 | Wichita, Texas, US | |
2022-08-17 | US | Texas | Wichita | 48485 | 35866 | 689 | 0 | 33.98842886 | -98.7041034 | 2022-08-18 04:21:11 | Wichita, Texas, US | |
2022-08-02 | US | Pennsylvania | Fayette | 42051 | 33642 | 689 | 0 | 39.92041012 | -79.64291195 | 2022-08-03 04:20:59 | Fayette, Pennsylvania, US | |
2022-08-01 | US | Pennsylvania | Fayette | 42051 | 33642 | 689 | 0 | 39.92041012 | -79.64291195 | 2022-08-02 04:20:53 | Fayette, Pennsylvania, US | |
2022-07-31 | US | Pennsylvania | Fayette | 42051 | 33642 | 689 | 0 | 39.92041012 | -79.64291195 | 2022-08-01 04:21:03 | Fayette, Pennsylvania, US | |
2022-07-30 | US | Pennsylvania | Fayette | 42051 | 33642 | 689 | 0 | 39.92041012 | -79.64291195 | 2022-07-31 04:21:02 | Fayette, Pennsylvania, US | |
2022-07-29 | US | Pennsylvania | Fayette | 42051 | 33642 | 689 | 0 | 39.92041012 | -79.64291195 | 2022-07-30 04:20:42 | Fayette, Pennsylvania, US | |
2022-07-28 | US | Pennsylvania | Fayette | 42051 | 33642 | 689 | 0 | 39.92041012 | -79.64291195 | 2022-07-29 04:20:45 | Fayette, Pennsylvania, US | |
2022-07-27 | US | Pennsylvania | Fayette | 42051 | 33642 | 689 | 0 | 39.92041012 | -79.64291195 | 2022-07-28 04:20:56 | Fayette, Pennsylvania, US | |
2022-06-30 | US | Idaho | Canyon | 16027 | 63189 | 689 | 0 | 43.61970148 | -116.7095499 | 2022-07-01 04:21:10 | Canyon, Idaho, US | |
2022-06-29 | US | Idaho | Canyon | 16027 | 63189 | 689 | 0 | 43.61970148 | -116.7095499 | 2022-06-30 04:21:01 | Canyon, Idaho, US | |
2022-06-28 | US | Idaho | Canyon | 16027 | 63004 | 689 | 0 | 43.61970148 | -116.7095499 | 2022-06-29 04:20:59 | Canyon, Idaho, US | |
2022-06-27 | US | Idaho | Canyon | 16027 | 63004 | 689 | 0 | 43.61970148 | -116.7095499 | 2022-06-28 04:20:58 | Canyon, Idaho, US | |
2022-06-26 | US | Idaho | Canyon | 16027 | 62928 | 689 | 0 | 43.61970148 | -116.7095499 | 2022-06-27 04:21:00 | Canyon, Idaho, US | |
2022-06-25 | US | Idaho | Canyon | 16027 | 62928 | 689 | 0 | 43.61970148 | -116.7095499 | 2022-06-26 04:21:02 | Canyon, Idaho, US | |
2022-06-24 | US | Idaho | Canyon | 16027 | 62928 | 689 | 0 | 43.61970148 | -116.7095499 | 2022-06-25 04:20:57 | Canyon, Idaho, US | |
2022-06-15 | Sweden | Jonkoping | 86507 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-16 04:20:55 | Jonkoping, Sweden | |||
2022-06-14 | US | Georgia | Henry | 13151 | 59729 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-15 04:20:54 | Henry, Georgia, US | |
2022-06-14 | Sweden | Jonkoping | 86507 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-15 04:20:54 | Jonkoping, Sweden | |||
2022-06-13 | US | South Carolina | York | 45091 | 80063 | 689 | 0 | 34.97281497 | -81.18085944 | 2022-06-14 04:20:52 | York, South Carolina, US | |
2022-06-13 | US | Georgia | Henry | 13151 | 59729 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-14 04:20:52 | Henry, Georgia, US | |
2022-06-13 | Sweden | Jonkoping | 86507 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-14 04:20:52 | Jonkoping, Sweden | |||
2022-06-12 | US | South Carolina | York | 45091 | 80063 | 689 | 0 | 34.97281497 | -81.18085944 | 2022-06-13 04:21:14 | York, South Carolina, US | |
2022-06-12 | US | Georgia | Henry | 13151 | 59729 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-13 04:21:14 | Henry, Georgia, US | |
2022-06-12 | Sweden | Jonkoping | 86507 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-13 04:21:14 | Jonkoping, Sweden | |||
2022-06-11 | US | South Carolina | York | 45091 | 80063 | 689 | 0 | 34.97281497 | -81.18085944 | 2022-06-12 04:20:53 | York, South Carolina, US | |
2022-06-11 | US | Georgia | Henry | 13151 | 59729 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-12 04:20:53 | Henry, Georgia, US | |
2022-06-11 | Sweden | Jonkoping | 86507 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-12 04:20:53 | Jonkoping, Sweden | |||
2022-06-10 | US | South Carolina | York | 45091 | 80063 | 689 | 0 | 34.97281497 | -81.18085944 | 2022-06-11 04:21:01 | York, South Carolina, US | |
2022-06-10 | US | Georgia | Henry | 13151 | 59729 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-11 04:21:01 | Henry, Georgia, US | |
2022-06-10 | Sweden | Jonkoping | 86507 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-11 04:21:01 | Jonkoping, Sweden | |||
2022-06-09 | US | South Carolina | York | 45091 | 80063 | 689 | 0 | 34.97281497 | -81.18085944 | 2022-06-10 04:20:55 | York, South Carolina, US | |
2022-06-09 | US | Georgia | Henry | 13151 | 59729 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-10 04:20:55 | Henry, Georgia, US | |
2022-06-09 | Sweden | Jonkoping | 86507 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-10 04:20:55 | Jonkoping, Sweden | |||
2022-06-08 | US | South Carolina | York | 45091 | 80063 | 689 | 0 | 34.97281497 | -81.18085944 | 2022-06-09 04:20:54 | York, South Carolina, US | |
2022-06-08 | US | Georgia | Henry | 13151 | 59729 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-09 04:20:54 | Henry, Georgia, US | |
2022-06-08 | Sweden | Jonkoping | 86467 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-09 04:20:54 | Jonkoping, Sweden | |||
2022-06-07 | US | South Carolina | York | 45091 | 80063 | 689 | 0 | 34.97281497 | -81.18085944 | 2022-06-08 04:20:55 | York, South Carolina, US | |
2022-06-07 | US | Georgia | Henry | 13151 | 59267 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-08 04:20:55 | Henry, Georgia, US | |
2022-06-07 | Sweden | Jonkoping | 86467 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-08 04:20:55 | Jonkoping, Sweden | |||
2022-06-06 | US | Georgia | Henry | 13151 | 59267 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-07 04:21:08 | Henry, Georgia, US | |
2022-06-06 | Sweden | Jonkoping | 86467 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-07 04:21:08 | Jonkoping, Sweden | |||
2022-06-05 | US | Georgia | Henry | 13151 | 59267 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-06 04:20:57 | Henry, Georgia, US | |
2022-06-05 | Sweden | Jonkoping | 86467 | 689 | 0 | 57.3708 | 14.3439 | 2022-06-06 04:20:57 | Jonkoping, Sweden | |||
2022-06-04 | US | Georgia | Henry | 13151 | 59267 | 689 | 0 | 33.4533428 | -84.1481466 | 2022-06-05 04:20:55 | Henry, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;