daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
677 rows where deaths = 486 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 518
- Sweden 38
- Russia 30
- Netherlands 20
- Japan 11
- India 7
- Peru 6
- Chile 5
- Colombia 4
- Italy 4
- Brazil 3
- Mauritania 3
- Mexico 3
- Pakistan 3
- Ukraine 3
- Spain 2
- Bosnia and Herzegovina 1
- Canada 1
- El Salvador 1
- Estonia 1
- Germany 1
- Guyana 1
- Hungary 1
- Ireland 1
- Kuwait 1
- Latvia 1
- Madagascar 1
- Malaysia 1
- Mozambique 1
- Namibia 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-20 | US | North Carolina | Davidson | 37057 | 52982 | 486 | 0 | 35.79115496 | -80.21256572 | 2022-12-21 04:21:03 | Davidson, North Carolina, US | |
2022-12-19 | US | North Carolina | Davidson | 37057 | 52982 | 486 | 0 | 35.79115496 | -80.21256572 | 2022-12-20 04:21:04 | Davidson, North Carolina, US | |
2022-12-18 | US | North Carolina | Davidson | 37057 | 52982 | 486 | 0 | 35.79115496 | -80.21256572 | 2022-12-19 04:21:03 | Davidson, North Carolina, US | |
2022-12-17 | US | North Carolina | Davidson | 37057 | 52982 | 486 | 0 | 35.79115496 | -80.21256572 | 2022-12-18 04:21:03 | Davidson, North Carolina, US | |
2022-12-16 | US | North Carolina | Davidson | 37057 | 52982 | 486 | 0 | 35.79115496 | -80.21256572 | 2022-12-17 04:21:04 | Davidson, North Carolina, US | |
2022-12-15 | US | North Carolina | Davidson | 37057 | 52982 | 486 | 0 | 35.79115496 | -80.21256572 | 2022-12-16 04:21:01 | Davidson, North Carolina, US | |
2022-12-14 | US | North Carolina | Davidson | 37057 | 52982 | 486 | 0 | 35.79115496 | -80.21256572 | 2022-12-15 04:20:58 | Davidson, North Carolina, US | |
2022-12-13 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-14 04:21:04 | Thurston, Washington, US | |
2022-12-12 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-13 04:21:01 | Thurston, Washington, US | |
2022-12-11 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-12 04:21:01 | Thurston, Washington, US | |
2022-12-10 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-11 04:20:50 | Thurston, Washington, US | |
2022-12-09 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-10 04:21:02 | Thurston, Washington, US | |
2022-12-08 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-09 04:21:05 | Thurston, Washington, US | |
2022-12-07 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-08 04:21:07 | Thurston, Washington, US | |
2022-11-22 | US | North Carolina | Randolph | 37151 | 41756 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-23 04:21:06 | Randolph, North Carolina, US | |
2022-11-22 | US | North Carolina | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-23 04:21:06 | Johnston, North Carolina, US | |
2022-11-21 | US | North Carolina | Randolph | 37151 | 41756 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-22 04:20:47 | Randolph, North Carolina, US | |
2022-11-21 | US | North Carolina | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-22 04:20:47 | Johnston, North Carolina, US | |
2022-11-20 | US | North Carolina | Randolph | 37151 | 41756 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-21 04:21:05 | Randolph, North Carolina, US | |
2022-11-20 | US | North Carolina | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-21 04:21:05 | Johnston, North Carolina, US | |
2022-11-19 | US | North Carolina | Randolph | 37151 | 41756 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-20 04:21:08 | Randolph, North Carolina, US | |
2022-11-19 | US | North Carolina | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-20 04:21:08 | Johnston, North Carolina, US | |
2022-11-18 | US | North Carolina | Randolph | 37151 | 41756 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-19 04:21:14 | Randolph, North Carolina, US | |
2022-11-18 | US | North Carolina | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-19 04:21:14 | Johnston, North Carolina, US | |
2022-11-17 | US | North Carolina | Randolph | 37151 | 41756 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-18 04:21:15 | Randolph, North Carolina, US | |
2022-11-17 | US | North Carolina | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-18 04:21:15 | Johnston, North Carolina, US | |
2022-11-16 | US | North Carolina | Randolph | 37151 | 41756 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-17 04:21:11 | Randolph, North Carolina, US | |
2022-11-16 | US | North Carolina | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-17 04:21:11 | Johnston, North Carolina, US | |
2022-11-15 | US | North Carolina | Randolph | 37151 | 41678 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-16 04:21:09 | Randolph, North Carolina, US | |
2022-11-14 | US | North Carolina | Randolph | 37151 | 41678 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-15 04:21:16 | Randolph, North Carolina, US | |
2022-11-13 | US | North Carolina | Randolph | 37151 | 41678 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-14 04:21:09 | Randolph, North Carolina, US | |
2022-11-12 | US | North Carolina | Randolph | 37151 | 41678 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-13 04:21:14 | Randolph, North Carolina, US | |
2022-11-11 | US | North Carolina | Randolph | 37151 | 41678 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-12 04:20:41 | Randolph, North Carolina, US | |
2022-11-10 | US | North Carolina | Randolph | 37151 | 41678 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-11 04:21:22 | Randolph, North Carolina, US | |
2022-11-09 | US | North Carolina | Randolph | 37151 | 41678 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-10 04:21:16 | Randolph, North Carolina, US | |
2022-11-08 | US | North Carolina | Randolph | 37151 | 41572 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-09 04:21:22 | Randolph, North Carolina, US | |
2022-11-08 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-09 04:21:22 | Carroll, Georgia, US | |
2022-11-07 | US | North Carolina | Randolph | 37151 | 41572 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-08 04:21:21 | Randolph, North Carolina, US | |
2022-11-07 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-08 04:21:21 | Carroll, Georgia, US | |
2022-11-06 | US | North Carolina | Randolph | 37151 | 41572 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-07 04:21:26 | Randolph, North Carolina, US | |
2022-11-06 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-07 04:21:26 | Carroll, Georgia, US | |
2022-11-05 | US | North Carolina | Randolph | 37151 | 41572 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-06 04:21:24 | Randolph, North Carolina, US | |
2022-11-05 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-06 04:21:24 | Carroll, Georgia, US | |
2022-11-04 | US | North Carolina | Randolph | 37151 | 41572 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-05 04:21:52 | Randolph, North Carolina, US | |
2022-11-04 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-05 04:21:52 | Carroll, Georgia, US | |
2022-11-03 | US | North Carolina | Randolph | 37151 | 41572 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-04 04:22:11 | Randolph, North Carolina, US | |
2022-11-03 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-04 04:22:11 | Carroll, Georgia, US | |
2022-11-02 | US | North Carolina | Randolph | 37151 | 41572 | 486 | 0 | 35.71015088 | -79.80570339 | 2022-11-03 04:22:05 | Randolph, North Carolina, US | |
2022-11-02 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-03 04:22:05 | Carroll, Georgia, US | |
2022-10-31 | US | New Mexico | Sandoval | 35043 | 42086 | 486 | 0 | 35.68862401 | -106.8687803 | 2022-11-01 04:22:36 | Sandoval, New Mexico, US | |
2022-10-31 | US | Connecticut | Litchfield | 9005 | 38950 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-11-01 04:22:36 | Litchfield, Connecticut, US | |
2022-10-30 | US | New Mexico | Sandoval | 35043 | 42003 | 486 | 0 | 35.68862401 | -106.8687803 | 2022-10-31 04:21:36 | Sandoval, New Mexico, US | |
2022-10-30 | US | Connecticut | Litchfield | 9005 | 38945 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-31 04:21:36 | Litchfield, Connecticut, US | |
2022-10-29 | US | New Mexico | Sandoval | 35043 | 42003 | 486 | 0 | 35.68862401 | -106.8687803 | 2022-10-30 04:22:14 | Sandoval, New Mexico, US | |
2022-10-29 | US | Connecticut | Litchfield | 9005 | 38928 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-30 04:22:14 | Litchfield, Connecticut, US | |
2022-10-28 | US | New Mexico | Sandoval | 35043 | 42003 | 486 | 0 | 35.68862401 | -106.8687803 | 2022-10-29 04:21:13 | Sandoval, New Mexico, US | |
2022-10-28 | US | Connecticut | Litchfield | 9005 | 38895 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-29 04:21:13 | Litchfield, Connecticut, US | |
2022-10-27 | US | Connecticut | Litchfield | 9005 | 38829 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-28 04:22:31 | Litchfield, Connecticut, US | |
2022-10-25 | US | Tennessee | Blount | 47009 | 46132 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-26 04:22:19 | Blount, Tennessee, US | |
2022-10-24 | US | Tennessee | Blount | 47009 | 46101 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-25 04:21:53 | Blount, Tennessee, US | |
2022-10-23 | US | Tennessee | Blount | 47009 | 46091 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-24 04:22:29 | Blount, Tennessee, US | |
2022-10-22 | US | Tennessee | Blount | 47009 | 46085 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-23 04:22:46 | Blount, Tennessee, US | |
2022-10-21 | US | Tennessee | Blount | 47009 | 46079 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-22 04:22:53 | Blount, Tennessee, US | |
2022-10-20 | US | Tennessee | Blount | 47009 | 46060 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-21 04:22:23 | Blount, Tennessee, US | |
2022-10-19 | US | Tennessee | Blount | 47009 | 46042 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-20 04:22:59 | Blount, Tennessee, US | |
2022-10-18 | US | Tennessee | Blount | 47009 | 46027 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-19 04:22:26 | Blount, Tennessee, US | |
2022-10-17 | US | Tennessee | Blount | 47009 | 46008 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-18 04:22:42 | Blount, Tennessee, US | |
2022-10-16 | US | Tennessee | Blount | 47009 | 45994 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-17 04:20:31 | Blount, Tennessee, US | |
2022-10-15 | US | Tennessee | Blount | 47009 | 45992 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-16 04:22:39 | Blount, Tennessee, US | |
2022-10-14 | US | Tennessee | Blount | 47009 | 45982 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-15 04:22:00 | Blount, Tennessee, US | |
2022-10-13 | US | Tennessee | Blount | 47009 | 45959 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-14 04:22:28 | Blount, Tennessee, US | |
2022-10-11 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-12 04:22:51 | Jackson, Mississippi, US | |
2022-10-10 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-11 04:23:05 | Jackson, Mississippi, US | |
2022-10-09 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-10 04:22:32 | Jackson, Mississippi, US | |
2022-10-08 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-09 04:21:16 | Jackson, Mississippi, US | |
2022-10-07 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-08 04:22:56 | Jackson, Mississippi, US | |
2022-10-06 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-07 04:23:08 | Jackson, Mississippi, US | |
2022-10-05 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-06 04:21:22 | Jackson, Mississippi, US | |
2022-10-04 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-05 04:23:06 | Jackson, Mississippi, US | |
2022-10-03 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-04 04:22:55 | Jackson, Mississippi, US | |
2022-10-02 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-03 04:23:11 | Jackson, Mississippi, US | |
2022-10-01 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-02 04:21:23 | Jackson, Mississippi, US | |
2022-09-30 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-01 04:23:01 | Jackson, Mississippi, US | |
2022-09-29 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-09-30 04:23:09 | Jackson, Mississippi, US | |
2022-09-28 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-09-29 04:22:34 | Jackson, Mississippi, US | |
2022-09-23 | Japan | Tochigi | 220079 | 486 | 0 | 36.689912 | 139.819213 | 2022-09-24 04:21:40 | Tochigi, Japan | |||
2022-09-19 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-20 04:22:48 | Livingston, Michigan, US | |
2022-09-18 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-19 04:21:49 | Livingston, Michigan, US | |
2022-09-17 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-18 04:22:50 | Livingston, Michigan, US | |
2022-09-16 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-17 04:20:19 | Livingston, Michigan, US | |
2022-09-15 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-16 04:21:19 | Livingston, Michigan, US | |
2022-09-14 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-15 04:21:02 | Livingston, Michigan, US | |
2022-09-13 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-14 04:20:44 | Livingston, Michigan, US | |
2022-09-09 | Japan | Kagoshima | 278482 | 486 | 0 | 31.009484 | 130.430665 | 2022-09-10 04:21:10 | Kagoshima, Japan | |||
2022-08-30 | India | Sikkim | 43650 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-31 04:20:57 | Sikkim, India | |||
2022-08-29 | India | Sikkim | 43650 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-30 04:21:03 | Sikkim, India | |||
2022-08-28 | India | Sikkim | 43650 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-29 04:21:06 | Sikkim, India | |||
2022-08-27 | India | Sikkim | 43629 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-28 04:21:02 | Sikkim, India | |||
2022-08-22 | Japan | Kumamoto | 265539 | 486 | 0 | 32.608154 | 130.745231 | 2022-08-23 04:20:56 | Kumamoto, Japan | |||
2022-08-21 | US | Illinois | Tazewell | 17179 | 41821 | 486 | 0 | 40.50716185 | -89.51404662 | 2022-08-22 04:20:38 | Tazewell, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;