johns_hopkins_csse_daily_reports
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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953703 | 2953703 | 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 | |
3176105 | 3176105 | 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 | |
1630622 | 1630622 | 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 | |
506001 | 506001 | 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 | |
3326573 | 3326573 | 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 | |
545085 | 545085 | 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 | |
350613 | 350613 | 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 | |
311352 | 311352 | 2022-12-13 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-14 04:21:04 | Thurston, Washington, US | |
1152413 | 1152413 | 2022-12-12 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-13 04:21:01 | Thurston, Washington, US | |
872267 | 872267 | 2022-12-11 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-12 04:21:01 | Thurston, Washington, US | |
260797 | 260797 | 2022-12-10 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-11 04:20:50 | Thurston, Washington, US | |
3939511 | 3939511 | 2022-12-09 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-10 04:21:02 | Thurston, Washington, US | |
3380843 | 3380843 | 2022-12-08 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-09 04:21:05 | Thurston, Washington, US | |
1988114 | 1988114 | 2022-12-07 | US | Washington | Thurston | 53067 | 60883 | 486 | 0 | 46.9291895 | -122.8290656 | 2022-12-08 04:21:07 | Thurston, Washington, US | |
1622637 | 1622637 | 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 | |
1622612 | 1622612 | 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 | |
3462525 | 3462525 | 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 | |
3462500 | 3462500 | 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 | |
1642710 | 1642710 | 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 | |
1642685 | 1642685 | 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 | |
2066267 | 2066267 | 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 | |
2066242 | 2066242 | 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 | |
1757661 | 1757661 | 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 | |
1757636 | 1757636 | 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 | |
3028654 | 3028654 | 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 | |
3028629 | 3028629 | 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 | |
2488365 | 2488365 | 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 | |
2488340 | 2488340 | 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 | |
294376 | 294376 | 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 | |
3599406 | 3599406 | 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 | |
314264 | 314264 | 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 | |
65425 | 65425 | 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 | |
2929587 | 2929587 | 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 | |
2508423 | 2508423 | 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 | |
2433298 | 2433298 | 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 | |
481954 | 481954 | 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 | |
480363 | 480363 | 2022-11-08 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-09 04:21:22 | Carroll, Georgia, US | |
2441104 | 2441104 | 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 | |
2439513 | 2439513 | 2022-11-07 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-08 04:21:21 | Carroll, Georgia, US | |
1052202 | 1052202 | 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 | |
1050611 | 1050611 | 2022-11-06 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-07 04:21:26 | Carroll, Georgia, US | |
620226 | 620226 | 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 | |
618635 | 618635 | 2022-11-05 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-06 04:21:24 | Carroll, Georgia, US | |
1024730 | 1024730 | 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 | |
1023139 | 1023139 | 2022-11-04 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-05 04:21:52 | Carroll, Georgia, US | |
433721 | 433721 | 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 | |
432130 | 432130 | 2022-11-03 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-04 04:22:11 | Carroll, Georgia, US | |
851963 | 851963 | 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 | |
850372 | 850372 | 2022-11-02 | US | Georgia | Carroll | 13045 | 26995 | 486 | 0 | 33.58138199 | -85.07976677 | 2022-11-03 04:22:05 | Carroll, Georgia, US | |
3287115 | 3287115 | 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 | |
3285570 | 3285570 | 2022-10-31 | US | Connecticut | Litchfield | 9005 | 38950 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-11-01 04:22:36 | Litchfield, Connecticut, US | |
322148 | 322148 | 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 | |
320603 | 320603 | 2022-10-30 | US | Connecticut | Litchfield | 9005 | 38945 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-31 04:21:36 | Litchfield, Connecticut, US | |
914424 | 914424 | 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 | |
912879 | 912879 | 2022-10-29 | US | Connecticut | Litchfield | 9005 | 38928 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-30 04:22:14 | Litchfield, Connecticut, US | |
1368693 | 1368693 | 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 | |
1367148 | 1367148 | 2022-10-28 | US | Connecticut | Litchfield | 9005 | 38895 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-29 04:21:13 | Litchfield, Connecticut, US | |
3039003 | 3039003 | 2022-10-27 | US | Connecticut | Litchfield | 9005 | 38829 | 486 | 0 | 41.7937534 | -73.2451475 | 2022-10-28 04:22:31 | Litchfield, Connecticut, US | |
1833076 | 1833076 | 2022-10-25 | US | Tennessee | Blount | 47009 | 46132 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-26 04:22:19 | Blount, Tennessee, US | |
797337 | 797337 | 2022-10-24 | US | Tennessee | Blount | 47009 | 46101 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-25 04:21:53 | Blount, Tennessee, US | |
3279792 | 3279792 | 2022-10-23 | US | Tennessee | Blount | 47009 | 46091 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-24 04:22:29 | Blount, Tennessee, US | |
2270830 | 2270830 | 2022-10-22 | US | Tennessee | Blount | 47009 | 46085 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-23 04:22:46 | Blount, Tennessee, US | |
1595130 | 1595130 | 2022-10-21 | US | Tennessee | Blount | 47009 | 46079 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-22 04:22:53 | Blount, Tennessee, US | |
2274846 | 2274846 | 2022-10-20 | US | Tennessee | Blount | 47009 | 46060 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-21 04:22:23 | Blount, Tennessee, US | |
201181 | 201181 | 2022-10-19 | US | Tennessee | Blount | 47009 | 46042 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-20 04:22:59 | Blount, Tennessee, US | |
2759842 | 2759842 | 2022-10-18 | US | Tennessee | Blount | 47009 | 46027 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-19 04:22:26 | Blount, Tennessee, US | |
2027676 | 2027676 | 2022-10-17 | US | Tennessee | Blount | 47009 | 46008 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-18 04:22:42 | Blount, Tennessee, US | |
2162454 | 2162454 | 2022-10-16 | US | Tennessee | Blount | 47009 | 45994 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-17 04:20:31 | Blount, Tennessee, US | |
518651 | 518651 | 2022-10-15 | US | Tennessee | Blount | 47009 | 45992 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-16 04:22:39 | Blount, Tennessee, US | |
2035708 | 2035708 | 2022-10-14 | US | Tennessee | Blount | 47009 | 45982 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-15 04:22:00 | Blount, Tennessee, US | |
3756396 | 3756396 | 2022-10-13 | US | Tennessee | Blount | 47009 | 45959 | 486 | 0 | 35.68938198 | -83.92847788 | 2022-10-14 04:22:28 | Blount, Tennessee, US | |
3251965 | 3251965 | 2022-10-11 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-12 04:22:51 | Jackson, Mississippi, US | |
2969224 | 2969224 | 2022-10-10 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-11 04:23:05 | Jackson, Mississippi, US | |
3099260 | 3099260 | 2022-10-09 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-10 04:22:32 | Jackson, Mississippi, US | |
4004485 | 4004485 | 2022-10-08 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-09 04:21:16 | Jackson, Mississippi, US | |
398082 | 398082 | 2022-10-07 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-08 04:22:56 | Jackson, Mississippi, US | |
2531199 | 2531199 | 2022-10-06 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-07 04:23:08 | Jackson, Mississippi, US | |
1812593 | 1812593 | 2022-10-05 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-06 04:21:22 | Jackson, Mississippi, US | |
132567 | 132567 | 2022-10-04 | US | Mississippi | Jackson | 28059 | 43658 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-05 04:23:06 | Jackson, Mississippi, US | |
2687514 | 2687514 | 2022-10-03 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-04 04:22:55 | Jackson, Mississippi, US | |
2261581 | 2261581 | 2022-10-02 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-03 04:23:11 | Jackson, Mississippi, US | |
2997107 | 2997107 | 2022-10-01 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-02 04:21:23 | Jackson, Mississippi, US | |
855433 | 855433 | 2022-09-30 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-10-01 04:23:01 | Jackson, Mississippi, US | |
2377359 | 2377359 | 2022-09-29 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-09-30 04:23:09 | Jackson, Mississippi, US | |
1561910 | 1561910 | 2022-09-28 | US | Mississippi | Jackson | 28059 | 43618 | 486 | 0 | 30.54020656 | -88.64184064 | 2022-09-29 04:22:34 | Jackson, Mississippi, US | |
384247 | 384247 | 2022-09-23 | Japan | Tochigi | 220079 | 486 | 0 | 36.689912 | 139.819213 | 2022-09-24 04:21:40 | Tochigi, Japan | |||
3572257 | 3572257 | 2022-09-19 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-20 04:22:48 | Livingston, Michigan, US | |
420996 | 420996 | 2022-09-18 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-19 04:21:49 | Livingston, Michigan, US | |
3375020 | 3375020 | 2022-09-17 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-18 04:22:50 | Livingston, Michigan, US | |
2357128 | 2357128 | 2022-09-16 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-17 04:20:19 | Livingston, Michigan, US | |
3988285 | 3988285 | 2022-09-15 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-16 04:21:19 | Livingston, Michigan, US | |
1890802 | 1890802 | 2022-09-14 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-15 04:21:02 | Livingston, Michigan, US | |
373857 | 373857 | 2022-09-13 | US | Michigan | Livingston | 26093 | 53262 | 486 | 0 | 42.60302282 | -83.91297209 | 2022-09-14 04:20:44 | Livingston, Michigan, US | |
962913 | 962913 | 2022-09-09 | Japan | Kagoshima | 278482 | 486 | 0 | 31.009484 | 130.430665 | 2022-09-10 04:21:10 | Kagoshima, Japan | |||
3773856 | 3773856 | 2022-08-30 | India | Sikkim | 43650 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-31 04:20:57 | Sikkim, India | |||
1680452 | 1680452 | 2022-08-29 | India | Sikkim | 43650 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-30 04:21:03 | Sikkim, India | |||
1876936 | 1876936 | 2022-08-28 | India | Sikkim | 43650 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-29 04:21:06 | Sikkim, India | |||
2096063 | 2096063 | 2022-08-27 | India | Sikkim | 43629 | 486 | 0 | 27.571671 | 88.472712 | 2022-08-28 04:21:02 | Sikkim, India | |||
2852866 | 2852866 | 2022-08-22 | Japan | Kumamoto | 265539 | 486 | 0 | 32.608154 | 130.745231 | 2022-08-23 04:20:56 | Kumamoto, Japan | |||
2403886 | 2403886 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);