daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
518 rows where country_or_region = "US" and deaths = 486 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- North Carolina 45
- Ohio 39
- Connecticut 33
- Illinois 30
- Texas 30
- Tennessee 29
- Georgia 28
- Michigan 27
- Pennsylvania 23
- California 19
- Washington 18
- Mississippi 15
- South Carolina 15
- Florida 14
- Maryland 13
- Louisiana 12
- New York 12
- New Mexico 11
- Oregon 11
- Alabama 10
- Minnesota 10
- Kansas 9
- Idaho 7
- Utah 7
- Arizona 6
- Virginia 6
- Wisconsin 6
- Colorado 5
- Indiana 5
- New Hampshire 4
- …
country_or_region 1
- US · 518 ✖
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 | Johnston | 37101 | 71561 | 486 | 0 | 35.51745004 | -78.36622717 | 2022-11-23 04:21:06 | Johnston, North Carolina, 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-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-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-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-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-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-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-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-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-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-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-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-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-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 | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-09 04:21:22 | Carroll, Georgia, 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-07 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-08 04:21:21 | 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-06 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-07 04:21:26 | 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-05 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-06 04:21:24 | 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-04 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-05 04:21:52 | 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-03 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-04 04:22:11 | 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-02 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-03 04:22:05 | 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-10-31 | US | Connecticut | Litchfield | 9005 | 38950 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-11-01 04:22:36 | Litchfield, Connecticut, 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-30 | US | Connecticut | Litchfield | 9005 | 38945 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-31 04:21: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-29 | US | Connecticut | Litchfield | 9005 | 38928 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-30 04:22:14 | 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-28 | US | Connecticut | Litchfield | 9005 | 38895 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-29 04:21:13 | 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-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-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-08-21 | US | Illinois | Tazewell | 17179 | 41821 | 486 | 0 | 40.50716185 | -89.51404662 | 2022-08-22 04:20:38 | Tazewell, Illinois, US | |
2022-08-20 | US | Illinois | Tazewell | 17179 | 41821 | 486 | 0 | 40.50716185 | -89.51404662 | 2022-08-21 04:20:44 | Tazewell, Illinois, US | |
2022-08-19 | US | Illinois | Tazewell | 17179 | 41821 | 486 | 0 | 40.50716185 | -89.51404662 | 2022-08-20 04:21:01 | Tazewell, Illinois, US | |
2022-08-08 | US | Ohio | Licking | 39089 | 46182 | 486 | 0 | 40.09136236 | -82.48185785 | 2022-08-09 04:20:34 | Licking, Ohio, US | |
2022-08-07 | US | Ohio | Licking | 39089 | 46182 | 486 | 0 | 40.09136236 | -82.48185785 | 2022-08-08 04:21:08 | Licking, Ohio, US | |
2022-08-06 | US | Ohio | Licking | 39089 | 46182 | 486 | 0 | 40.09136236 | -82.48185785 | 2022-08-07 04:20:54 | Licking, Ohio, US | |
2022-08-05 | US | Ohio | Licking | 39089 | 46182 | 486 | 0 | 40.09136236 | -82.48185785 | 2022-08-06 04:20:56 | Licking, Ohio, US | |
2022-08-04 | US | Ohio | Licking | 39089 | 46182 | 486 | 0 | 40.09136236 | -82.48185785 | 2022-08-05 04:20:52 | Licking, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;