daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
936 rows where deaths = 406 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-29 | US | Pennsylvania | Adams | 42001 | 30515 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-30 04:21:04 | Adams, Pennsylvania, US | |
2022-12-29 | US | Missouri | Franklin | 29071 | 30652 | 406 | 0 | 38.41127108 | -91.07522826 | 2022-12-30 04:21:04 | Franklin, Missouri, US | |
2022-12-29 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-30 04:21:04 | Marshall, Alabama, US | |
2022-12-28 | US | Pennsylvania | Adams | 42001 | 30515 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-29 04:21:01 | Adams, Pennsylvania, US | |
2022-12-28 | US | Missouri | Franklin | 29071 | 30652 | 406 | 0 | 38.41127108 | -91.07522826 | 2022-12-29 04:21:01 | Franklin, Missouri, US | |
2022-12-28 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-29 04:21:01 | Marshall, Alabama, US | |
2022-12-27 | US | Pennsylvania | Adams | 42001 | 30366 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-28 04:21:04 | Adams, Pennsylvania, US | |
2022-12-27 | US | Missouri | Franklin | 29071 | 30651 | 406 | 0 | 38.41127108 | -91.07522826 | 2022-12-28 04:21:04 | Franklin, Missouri, US | |
2022-12-27 | US | Arizona | Gila | 4007 | 20978 | 406 | 0 | 33.80190085 | -110.8132779 | 2022-12-28 04:21:04 | Gila, Arizona, US | |
2022-12-27 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-28 04:21:04 | Marshall, Alabama, US | |
2022-12-26 | US | Pennsylvania | Adams | 42001 | 30366 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-27 04:21:07 | Adams, Pennsylvania, US | |
2022-12-26 | US | Arizona | Gila | 4007 | 20978 | 406 | 0 | 33.80190085 | -110.8132779 | 2022-12-27 04:21:07 | Gila, Arizona, US | |
2022-12-26 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-27 04:21:07 | Marshall, Alabama, US | |
2022-12-25 | US | Pennsylvania | Adams | 42001 | 30366 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-26 04:21:06 | Adams, Pennsylvania, US | |
2022-12-25 | US | Arizona | Gila | 4007 | 20978 | 406 | 0 | 33.80190085 | -110.8132779 | 2022-12-26 04:21:06 | Gila, Arizona, US | |
2022-12-25 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-26 04:21:06 | Marshall, Alabama, US | |
2022-12-24 | US | Pennsylvania | Adams | 42001 | 30366 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-25 04:21:04 | Adams, Pennsylvania, US | |
2022-12-24 | US | Arizona | Gila | 4007 | 20978 | 406 | 0 | 33.80190085 | -110.8132779 | 2022-12-25 04:21:04 | Gila, Arizona, US | |
2022-12-24 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-25 04:21:04 | Marshall, Alabama, US | |
2022-12-23 | US | Pennsylvania | Adams | 42001 | 30366 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-24 04:21:02 | Adams, Pennsylvania, US | |
2022-12-23 | US | Arizona | Gila | 4007 | 20978 | 406 | 0 | 33.80190085 | -110.8132779 | 2022-12-24 04:21:02 | Gila, Arizona, US | |
2022-12-23 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-24 04:21:02 | Marshall, Alabama, US | |
2022-12-22 | US | Pennsylvania | Adams | 42001 | 30366 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-23 04:21:04 | Adams, Pennsylvania, US | |
2022-12-22 | US | Arizona | Gila | 4007 | 20978 | 406 | 0 | 33.80190085 | -110.8132779 | 2022-12-23 04:21:04 | Gila, Arizona, US | |
2022-12-22 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-23 04:21:04 | Marshall, Alabama, US | |
2022-12-21 | US | Pennsylvania | Adams | 42001 | 30366 | 406 | 0 | 39.87140411 | -77.21610347 | 2022-12-22 04:20:56 | Adams, Pennsylvania, US | |
2022-12-21 | US | Oklahoma | Rogers | 40131 | 30336 | 406 | 0 | 36.37004357 | -95.60406759 | 2022-12-22 04:20:56 | Rogers, Oklahoma, US | |
2022-12-21 | US | Arizona | Gila | 4007 | 20978 | 406 | 0 | 33.80190085 | -110.8132779 | 2022-12-22 04:20:56 | Gila, Arizona, US | |
2022-12-21 | US | Alabama | Marshall | 1095 | 31626 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-22 04:20:56 | Marshall, Alabama, US | |
2022-12-20 | US | Oklahoma | Rogers | 40131 | 30336 | 406 | 0 | 36.37004357 | -95.60406759 | 2022-12-21 04:21:03 | Rogers, Oklahoma, US | |
2022-12-20 | US | Alabama | Marshall | 1095 | 31501 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-21 04:21:03 | Marshall, Alabama, US | |
2022-12-20 | Japan | Fukushima | 317664 | 406 | 0 | 37.378867 | 140.223295 | 2022-12-21 04:21:03 | Fukushima, Japan | |||
2022-12-19 | US | Oklahoma | Rogers | 40131 | 30336 | 406 | 0 | 36.37004357 | -95.60406759 | 2022-12-20 04:21:04 | Rogers, Oklahoma, US | |
2022-12-19 | US | New Mexico | Lea | 35025 | 22269 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-20 04:21:04 | Lea, New Mexico, US | |
2022-12-19 | US | Alabama | Marshall | 1095 | 31501 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-20 04:21:04 | Marshall, Alabama, US | |
2022-12-18 | US | Oklahoma | Rogers | 40131 | 30336 | 406 | 0 | 36.37004357 | -95.60406759 | 2022-12-19 04:21:03 | Rogers, Oklahoma, US | |
2022-12-18 | US | New Mexico | Lea | 35025 | 22239 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-19 04:21:03 | Lea, New Mexico, US | |
2022-12-18 | US | Alabama | Marshall | 1095 | 31501 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-19 04:21:03 | Marshall, Alabama, US | |
2022-12-17 | US | Oklahoma | Rogers | 40131 | 30336 | 406 | 0 | 36.37004357 | -95.60406759 | 2022-12-18 04:21:03 | Rogers, Oklahoma, US | |
2022-12-17 | US | New Mexico | Lea | 35025 | 22239 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-18 04:21:03 | Lea, New Mexico, US | |
2022-12-17 | US | Alabama | Marshall | 1095 | 31501 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-18 04:21:03 | Marshall, Alabama, US | |
2022-12-16 | US | Oklahoma | Rogers | 40131 | 30336 | 406 | 0 | 36.37004357 | -95.60406759 | 2022-12-17 04:21:04 | Rogers, Oklahoma, US | |
2022-12-16 | US | New Mexico | Lea | 35025 | 22239 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-17 04:21:04 | Lea, New Mexico, US | |
2022-12-16 | US | Alabama | Marshall | 1095 | 31501 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-17 04:21:04 | Marshall, Alabama, US | |
2022-12-15 | US | Tennessee | Greene | 47059 | 26554 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-16 04:21:01 | Greene, Tennessee, US | |
2022-12-15 | US | Oklahoma | Rogers | 40131 | 30336 | 406 | 0 | 36.37004357 | -95.60406759 | 2022-12-16 04:21:01 | Rogers, Oklahoma, US | |
2022-12-15 | US | New Mexico | Lea | 35025 | 22222 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-16 04:21:01 | Lea, New Mexico, US | |
2022-12-15 | US | Alabama | Marshall | 1095 | 31501 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-16 04:21:01 | Marshall, Alabama, US | |
2022-12-14 | US | Tennessee | Greene | 47059 | 26543 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-15 04:20:58 | Greene, Tennessee, US | |
2022-12-14 | US | New Mexico | Lea | 35025 | 22191 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-15 04:20:58 | Lea, New Mexico, US | |
2022-12-14 | US | Alabama | Marshall | 1095 | 31501 | 406 | 0 | 34.36975964 | -86.30486727 | 2022-12-15 04:20:58 | Marshall, Alabama, US | |
2022-12-13 | US | Tennessee | Greene | 47059 | 26525 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-14 04:21:04 | Greene, Tennessee, US | |
2022-12-13 | US | New Mexico | Lea | 35025 | 22182 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-14 04:21:04 | Lea, New Mexico, US | |
2022-12-12 | US | Tennessee | Greene | 47059 | 26510 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-13 04:21:01 | Greene, Tennessee, US | |
2022-12-12 | US | New Mexico | Lea | 35025 | 22162 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-13 04:21:01 | Lea, New Mexico, US | |
2022-12-11 | US | Tennessee | Greene | 47059 | 26486 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-12 04:21:01 | Greene, Tennessee, US | |
2022-12-11 | US | New Mexico | Lea | 35025 | 22116 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-12 04:21:01 | Lea, New Mexico, US | |
2022-12-10 | US | Tennessee | Greene | 47059 | 26480 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-11 04:20:50 | Greene, Tennessee, US | |
2022-12-10 | US | New Mexico | Lea | 35025 | 22116 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-11 04:20:50 | Lea, New Mexico, US | |
2022-12-09 | US | Tennessee | Greene | 47059 | 26472 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-10 04:21:02 | Greene, Tennessee, US | |
2022-12-09 | US | New Mexico | Lea | 35025 | 22116 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-10 04:21:02 | Lea, New Mexico, US | |
2022-12-08 | US | Tennessee | Greene | 47059 | 26459 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-09 04:21:05 | Greene, Tennessee, US | |
2022-12-08 | US | New Mexico | Lea | 35025 | 22081 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-09 04:21:05 | Lea, New Mexico, US | |
2022-12-07 | US | Tennessee | Greene | 47059 | 26444 | 406 | 0 | 36.17470125 | -82.84691273 | 2022-12-08 04:21:07 | Greene, Tennessee, US | |
2022-12-07 | US | New Mexico | Lea | 35025 | 22019 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-08 04:21:07 | Lea, New Mexico, US | |
2022-12-06 | US | New Mexico | Lea | 35025 | 21983 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-07 04:20:58 | Lea, New Mexico, US | |
2022-12-06 | Japan | Shiga | 279208 | 406 | 0 | 35.215827 | 136.138064 | 2022-12-07 04:20:58 | Shiga, Japan | |||
2022-12-05 | US | New Mexico | Lea | 35025 | 21950 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-06 04:21:03 | Lea, New Mexico, US | |
2022-12-04 | US | New Mexico | Lea | 35025 | 21903 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-05 04:20:58 | Lea, New Mexico, US | |
2022-12-03 | US | New Mexico | Lea | 35025 | 21903 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-04 04:20:56 | Lea, New Mexico, US | |
2022-12-03 | Japan | Miyazaki | 217624 | 406 | 0 | 32.193204 | 131.299374 | 2022-12-04 04:20:56 | Miyazaki, Japan | |||
2022-12-02 | US | New Mexico | Lea | 35025 | 21903 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-03 04:21:02 | Lea, New Mexico, US | |
2022-12-01 | US | New Mexico | Lea | 35025 | 21890 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-02 04:21:07 | Lea, New Mexico, US | |
2022-12-01 | Japan | Oita | 201269 | 406 | 0 | 33.200697 | 131.43324 | 2022-12-02 04:21:07 | Oita, Japan | |||
2022-11-30 | US | Oklahoma | Canadian | 40017 | 46209 | 406 | 0 | 35.5426055 | -97.98465569 | 2022-12-01 04:21:03 | Canadian, Oklahoma, US | |
2022-11-30 | US | New Mexico | Lea | 35025 | 21869 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-01 04:21:03 | Lea, New Mexico, US | |
2022-11-30 | US | Minnesota | Stearns | 27145 | 59224 | 406 | 0 | 45.55192576 | -94.61078221 | 2022-12-01 04:21:03 | Stearns, Minnesota, US | |
2022-11-29 | US | Oklahoma | Canadian | 40017 | 46209 | 406 | 0 | 35.5426055 | -97.98465569 | 2022-11-30 04:21:07 | Canadian, Oklahoma, US | |
2022-11-29 | US | New Mexico | Lea | 35025 | 21847 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-11-30 04:21:07 | Lea, New Mexico, US | |
2022-11-29 | US | Minnesota | Stearns | 27145 | 59224 | 406 | 0 | 45.55192576 | -94.61078221 | 2022-11-30 04:21:07 | Stearns, Minnesota, US | |
2022-11-29 | US | Illinois | LaSalle | 17099 | 35370 | 406 | 0 | 41.3442613 | -88.88633881 | 2022-11-30 04:21:07 | LaSalle, Illinois, US | |
2022-11-28 | US | Oklahoma | Canadian | 40017 | 46209 | 406 | 0 | 35.5426055 | -97.98465569 | 2022-11-29 04:21:05 | Canadian, Oklahoma, US | |
2022-11-28 | US | New Mexico | Lea | 35025 | 21824 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-11-29 04:21:05 | Lea, New Mexico, US | |
2022-11-28 | US | Minnesota | Stearns | 27145 | 59224 | 406 | 0 | 45.55192576 | -94.61078221 | 2022-11-29 04:21:05 | Stearns, Minnesota, US | |
2022-11-28 | US | Illinois | LaSalle | 17099 | 35335 | 406 | 0 | 41.3442613 | -88.88633881 | 2022-11-29 04:21:05 | LaSalle, Illinois, US | |
2022-11-27 | US | Oklahoma | Canadian | 40017 | 46209 | 406 | 0 | 35.5426055 | -97.98465569 | 2022-11-28 04:21:02 | Canadian, Oklahoma, US | |
2022-11-27 | US | New Mexico | Lea | 35025 | 21795 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-11-28 04:21:02 | Lea, New Mexico, US | |
2022-11-27 | US | Minnesota | Stearns | 27145 | 59224 | 406 | 0 | 45.55192576 | -94.61078221 | 2022-11-28 04:21:02 | Stearns, Minnesota, US | |
2022-11-27 | US | Illinois | LaSalle | 17099 | 35247 | 406 | 0 | 41.3442613 | -88.88633881 | 2022-11-28 04:21:02 | LaSalle, Illinois, US | |
2022-11-26 | US | Oklahoma | Canadian | 40017 | 46209 | 406 | 0 | 35.5426055 | -97.98465569 | 2022-11-27 04:21:05 | Canadian, Oklahoma, US | |
2022-11-26 | US | New Mexico | Lea | 35025 | 21795 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-11-27 04:21:05 | Lea, New Mexico, US | |
2022-11-26 | US | Minnesota | Stearns | 27145 | 59224 | 406 | 0 | 45.55192576 | -94.61078221 | 2022-11-27 04:21:05 | Stearns, Minnesota, US | |
2022-11-26 | US | Illinois | LaSalle | 17099 | 35247 | 406 | 0 | 41.3442613 | -88.88633881 | 2022-11-27 04:21:05 | LaSalle, Illinois, US | |
2022-11-25 | US | Oklahoma | Canadian | 40017 | 46209 | 406 | 0 | 35.5426055 | -97.98465569 | 2022-11-26 04:21:11 | Canadian, Oklahoma, US | |
2022-11-25 | US | New Mexico | Lea | 35025 | 21795 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-11-26 04:21:11 | Lea, New Mexico, US | |
2022-11-25 | US | Minnesota | Stearns | 27145 | 59224 | 406 | 0 | 45.55192576 | -94.61078221 | 2022-11-26 04:21:11 | Stearns, Minnesota, US | |
2022-11-25 | US | Illinois | LaSalle | 17099 | 35247 | 406 | 0 | 41.3442613 | -88.88633881 | 2022-11-26 04:21:11 | LaSalle, Illinois, US | |
2022-11-24 | US | Oklahoma | Canadian | 40017 | 46209 | 406 | 0 | 35.5426055 | -97.98465569 | 2022-11-25 04:21:06 | Canadian, Oklahoma, US | |
2022-11-24 | US | New Mexico | Lea | 35025 | 21795 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-11-25 04:21:06 | Lea, New Mexico, US | |
2022-11-24 | US | Minnesota | Stearns | 27145 | 59224 | 406 | 0 | 45.55192576 | -94.61078221 | 2022-11-25 04:21:06 | Stearns, Minnesota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;