johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
518 rows where confirmed = 874 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1630708 | 1630708 | 2022-12-18 | US | North Dakota | Eddy | 38027 | 874 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-19 04:21:03 | Eddy, North Dakota, US | |
506087 | 506087 | 2022-12-17 | US | North Dakota | Eddy | 38027 | 874 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-18 04:21:03 | Eddy, North Dakota, US | |
3326659 | 3326659 | 2022-12-16 | US | North Dakota | Eddy | 38027 | 874 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-17 04:21:04 | Eddy, North Dakota, US | |
545171 | 545171 | 2022-12-15 | US | North Dakota | Eddy | 38027 | 874 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-16 04:21:01 | Eddy, North Dakota, US | |
350699 | 350699 | 2022-12-14 | US | North Dakota | Eddy | 38027 | 874 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-12-15 04:20:58 | Eddy, North Dakota, US | |
1623125 | 1623125 | 2022-11-22 | US | South Dakota | Aurora | 46003 | 874 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-11-23 04:21:06 | Aurora, South Dakota, US | |
3463013 | 3463013 | 2022-11-21 | US | South Dakota | Aurora | 46003 | 874 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-11-22 04:20:47 | Aurora, South Dakota, US | |
1643198 | 1643198 | 2022-11-20 | US | South Dakota | Aurora | 46003 | 874 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-11-21 04:21:05 | Aurora, South Dakota, US | |
1642767 | 1642767 | 2022-11-20 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-21 04:21:05 | Nelson, North Dakota, US | |
2066755 | 2066755 | 2022-11-19 | US | South Dakota | Aurora | 46003 | 874 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-11-20 04:21:08 | Aurora, South Dakota, US | |
2066324 | 2066324 | 2022-11-19 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-20 04:21:08 | Nelson, North Dakota, US | |
1758149 | 1758149 | 2022-11-18 | US | South Dakota | Aurora | 46003 | 874 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-11-19 04:21:14 | Aurora, South Dakota, US | |
1757718 | 1757718 | 2022-11-18 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-19 04:21:14 | Nelson, North Dakota, US | |
3029142 | 3029142 | 2022-11-17 | US | South Dakota | Aurora | 46003 | 874 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-11-18 04:21:15 | Aurora, South Dakota, US | |
3028711 | 3028711 | 2022-11-17 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-18 04:21:15 | Nelson, North Dakota, US | |
2488853 | 2488853 | 2022-11-16 | US | South Dakota | Aurora | 46003 | 874 | 18 | 0 | 43.71757685 | -98.56050467 | 2022-11-17 04:21:11 | Aurora, South Dakota, US | |
2488422 | 2488422 | 2022-11-16 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-17 04:21:11 | Nelson, North Dakota, US | |
294433 | 294433 | 2022-11-15 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-16 04:21:09 | Nelson, North Dakota, US | |
3599463 | 3599463 | 2022-11-14 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-15 04:21:16 | Nelson, North Dakota, US | |
314321 | 314321 | 2022-11-13 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-14 04:21:09 | Nelson, North Dakota, US | |
65482 | 65482 | 2022-11-12 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-13 04:21:14 | Nelson, North Dakota, US | |
2929644 | 2929644 | 2022-11-11 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-12 04:20:41 | Nelson, North Dakota, US | |
2508480 | 2508480 | 2022-11-10 | US | North Dakota | Nelson | 38063 | 874 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-11 04:21:22 | Nelson, North Dakota, US | |
3755696 | 3755696 | 2022-10-13 | US | New Mexico | Union | 35059 | 874 | 19 | 0 | 36.48126404 | -103.4709624 | 2022-10-14 04:22:28 | Union, New Mexico, US | |
3995250 | 3995250 | 2022-09-27 | US | Colorado | Costilla | 8023 | 874 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-09-28 04:23:01 | Costilla, Colorado, US | |
373503 | 373503 | 2022-09-13 | US | Kansas | Jewell | 20089 | 874 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-14 04:20:44 | Jewell, Kansas, US | |
2396105 | 2396105 | 2022-09-12 | US | Kansas | Jewell | 20089 | 874 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-13 04:20:57 | Jewell, Kansas, US | |
3767183 | 3767183 | 2022-09-11 | US | Kansas | Jewell | 20089 | 874 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-12 04:20:58 | Jewell, Kansas, US | |
3825758 | 3825758 | 2022-09-10 | US | Kansas | Jewell | 20089 | 874 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-11 04:20:50 | Jewell, Kansas, US | |
964215 | 964215 | 2022-09-09 | US | Kansas | Jewell | 20089 | 874 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-10 04:21:10 | Jewell, Kansas, US | |
254617 | 254617 | 2022-09-08 | US | Kansas | Jewell | 20089 | 874 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-09 04:21:11 | Jewell, Kansas, US | |
3746415 | 3746415 | 2022-09-07 | US | Kansas | Jewell | 20089 | 874 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-08 04:21:02 | Jewell, Kansas, US | |
3546659 | 3546659 | 2022-08-08 | US | Texas | Mason | 48319 | 874 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-08-09 04:20:34 | Mason, Texas, US | |
2011935 | 2011935 | 2022-08-04 | US | Texas | Upton | 48461 | 874 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-08-05 04:20:52 | Upton, Texas, US | |
1101362 | 1101362 | 2022-08-03 | US | Texas | Upton | 48461 | 874 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-08-04 04:20:58 | Upton, Texas, US | |
1406408 | 1406408 | 2022-08-02 | US | Kansas | Woodson | 20207 | 874 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-08-03 04:20:59 | Woodson, Kansas, US | |
3619473 | 3619473 | 2022-08-01 | US | North Dakota | Bowman | 38011 | 874 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-08-02 04:20:53 | Bowman, North Dakota, US | |
3618446 | 3618446 | 2022-08-01 | US | Kansas | Woodson | 20207 | 874 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-08-02 04:20:53 | Woodson, Kansas, US | |
3872926 | 3872926 | 2022-07-31 | US | Kansas | Woodson | 20207 | 874 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-08-01 04:21:03 | Woodson, Kansas, US | |
675680 | 675680 | 2022-07-30 | US | Kansas | Woodson | 20207 | 874 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-07-31 04:21:02 | Woodson, Kansas, US | |
1784879 | 1784879 | 2022-07-29 | US | Kansas | Woodson | 20207 | 874 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-07-30 04:20:42 | Woodson, Kansas, US | |
1067242 | 1067242 | 2022-07-28 | US | Kansas | Woodson | 20207 | 874 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-07-29 04:20:45 | Woodson, Kansas, US | |
2336761 | 2336761 | 2022-07-27 | US | Kansas | Woodson | 20207 | 874 | 17 | 0 | 37.8865336 | -95.74006277 | 2022-07-28 04:20:56 | Woodson, Kansas, US | |
960164 | 960164 | 2022-07-19 | US | Kansas | Chautauqua | 20019 | 874 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-07-20 04:20:59 | Chautauqua, Kansas, US | |
3211551 | 3211551 | 2022-07-18 | US | Kansas | Chautauqua | 20019 | 874 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-07-19 04:20:58 | Chautauqua, Kansas, US | |
3406726 | 3406726 | 2022-07-17 | US | Kansas | Chautauqua | 20019 | 874 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-07-18 04:20:59 | Chautauqua, Kansas, US | |
2152926 | 2152926 | 2022-07-16 | US | Kansas | Chautauqua | 20019 | 874 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-07-17 04:21:15 | Chautauqua, Kansas, US | |
2420159 | 2420159 | 2022-07-15 | US | Kansas | Chautauqua | 20019 | 874 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-07-16 04:21:05 | Chautauqua, Kansas, US | |
3430234 | 3430234 | 2022-07-14 | US | Kansas | Chautauqua | 20019 | 874 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-07-15 04:20:53 | Chautauqua, Kansas, US | |
3110754 | 3110754 | 2022-07-13 | US | Kansas | Chautauqua | 20019 | 874 | 18 | 0 | 37.14994405 | -96.2454192 | 2022-07-14 04:20:57 | Chautauqua, Kansas, US | |
942500 | 942500 | 2022-06-25 | Nauru | 874 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2022-06-26 04:21:02 | Nauru | |||
3350320 | 3350320 | 2022-06-24 | Nauru | 874 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2022-06-25 04:20:57 | Nauru | |||
1652061 | 1652061 | 2022-06-23 | Nauru | 874 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2022-06-24 04:20:58 | Nauru | |||
2190817 | 2190817 | 2022-06-22 | US | Texas | Reagan | 48383 | 874 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-06-23 04:20:55 | Reagan, Texas, US | |
3198744 | 3198744 | 2022-05-29 | US | Colorado | Baca | 8009 | 874 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-30 04:20:50 | Baca, Colorado, US | |
2725622 | 2725622 | 2022-05-28 | US | Colorado | Baca | 8009 | 874 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-29 04:20:53 | Baca, Colorado, US | |
3266174 | 3266174 | 2022-05-04 | US | Delaware | Unassigned | 90010 | 874 | 0 | 0 | 39.57992638 | 0.0 | 2022-05-05 04:20:55 | Unassigned, Delaware, US | |
1572813 | 1572813 | 2022-05-03 | US | Delaware | Unassigned | 90010 | 874 | 0 | 0 | 39.57992638 | 0.0 | 2022-05-04 04:20:59 | Unassigned, Delaware, US | |
3208507 | 3208507 | 2022-04-11 | US | New York | Hamilton | 36041 | 874 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-04-12 04:20:49 | Hamilton, New York, US | |
1578393 | 1578393 | 2022-04-10 | US | New York | Hamilton | 36041 | 874 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-04-11 04:21:02 | Hamilton, New York, US | |
1654635 | 1654635 | 2022-04-09 | US | New York | Hamilton | 36041 | 874 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-04-10 04:20:52 | Hamilton, New York, US | |
2117957 | 2117957 | 2022-04-08 | US | New York | Hamilton | 36041 | 874 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-04-09 04:20:42 | Hamilton, New York, US | |
3322481 | 3322481 | 2022-04-07 | US | New York | Hamilton | 36041 | 874 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-04-08 04:20:48 | Hamilton, New York, US | |
2643843 | 2643843 | 2022-02-14 | US | Nebraska | Johnson | 31097 | 874 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-02-15 04:21:09 | Johnson, Nebraska, US | |
188160 | 188160 | 2022-02-13 | US | Nebraska | Johnson | 31097 | 874 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-02-14 04:20:51 | Johnson, Nebraska, US | |
318006 | 318006 | 2022-02-12 | US | Nebraska | Johnson | 31097 | 874 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-02-13 04:21:00 | Johnson, Nebraska, US | |
235332 | 235332 | 2022-02-11 | US | Nebraska | Johnson | 31097 | 874 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-02-12 04:21:06 | Johnson, Nebraska, US | |
1363000 | 1363000 | 2022-02-08 | US | Colorado | Phillips | 8095 | 874 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-02-09 04:21:04 | Phillips, Colorado, US | |
2013654 | 2013654 | 2022-02-06 | US | Idaho | Lincoln | 16063 | 874 | 14 | 0 | 43.0012336 | -114.1358773 | 2022-02-07 04:21:05 | Lincoln, Idaho, US | |
1294983 | 1294983 | 2022-02-05 | US | Idaho | Lincoln | 16063 | 874 | 14 | 0 | 43.0012336 | -114.1358773 | 2022-02-06 04:21:00 | Lincoln, Idaho, US | |
1230739 | 1230739 | 2022-01-24 | US | Texas | Hudspeth | 48229 | 874 | 16 | 0 | 31.45628381 | -105.388178 | 2022-01-25 04:21:05 | Hudspeth, Texas, US | |
1141589 | 1141589 | 2022-01-23 | US | Delaware | Unassigned | 90010 | 874 | 0 | 0 | 39.57992638 | 0.0 | 2022-01-24 04:21:12 | Unassigned, Delaware, US | |
3690346 | 3690346 | 2022-01-13 | US | South Dakota | Deuel | 46039 | 874 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-01-14 04:21:54 | Deuel, South Dakota, US | |
3688404 | 3688404 | 2022-01-13 | US | Idaho | Boise | 16015 | 874 | 11 | 0 | 43.98829931 | -115.7309284 | 2022-01-14 04:21:54 | Boise, Idaho, US | |
1115632 | 1115632 | 2022-01-11 | US | Nebraska | Antelope | 31003 | 874 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-01-12 04:21:44 | Antelope, Nebraska, US | |
128463 | 128463 | 2022-01-09 | US | Minnesota | Kittson | 27069 | 874 | 25 | 0 | 48.77754106 | -96.78317184 | 2022-01-10 04:22:07 | Kittson, Minnesota, US | |
1218005 | 1218005 | 2022-01-08 | US | North Dakota | Wells | 38103 | 874 | 11 | 0 | 47.58614526 | -99.65904998 | 2022-01-09 04:21:46 | Wells, North Dakota, US | |
1217298 | 1217298 | 2022-01-08 | US | Minnesota | Kittson | 27069 | 874 | 25 | 0 | 48.77754106 | -96.78317184 | 2022-01-09 04:21:46 | Kittson, Minnesota, US | |
1391391 | 1391391 | 2022-01-07 | US | Minnesota | Kittson | 27069 | 874 | 25 | 0 | 48.77754106 | -96.78317184 | 2022-01-08 04:21:53 | Kittson, Minnesota, US | |
2611778 | 2611778 | 2022-01-06 | US | Minnesota | Kittson | 27069 | 874 | 25 | 0 | 48.77754106 | -96.78317184 | 2022-01-07 04:22:09 | Kittson, Minnesota, US | |
1702437 | 1702437 | 2022-01-03 | US | Nebraska | Howard | 31093 | 874 | 10 | 0 | 41.2200529 | -98.5166499 | 2022-01-04 04:22:17 | Howard, Nebraska, US | |
3522717 | 3522717 | 2022-01-02 | US | Vermont | Essex | 50009 | 874 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-01-03 02:22:25 | Essex, Vermont, US | |
2170847 | 2170847 | 2022-01-01 | US | Vermont | Essex | 50009 | 874 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-01-02 04:20:52 | Essex, Vermont, US | |
2170729 | 2170729 | 2022-01-01 | US | Texas | Martin | 48317 | 874 | 24 | 0 | 32.30600051 | -101.9513518 | 2022-01-02 04:20:52 | Martin, Texas, US | |
2780278 | 2780278 | 2021-12-31 | US | Vermont | Essex | 50009 | 874 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-01-01 04:22:14 | Essex, Vermont, US | |
2780056 | 2780056 | 2021-12-31 | US | Texas | Crane | 48103 | 874 | 19 | 0 | 31.43052248 | -102.5143314 | 2022-01-01 04:22:14 | Crane, Texas, US | |
4001935 | 4001935 | 2021-12-30 | US | Vermont | Essex | 50009 | 874 | 3 | 0 | 44.72736416 | -71.73579864 | 2021-12-31 04:21:50 | Essex, Vermont, US | |
1433563 | 1433563 | 2021-12-28 | US | Illinois | Henderson | 17071 | 874 | 15 | 0 | 40.81908672 | -90.92491462 | 2021-12-29 03:21:43 | Henderson, Illinois, US | |
799927 | 799927 | 2021-12-22 | US | Louisiana | Cameron | 22023 | 874 | 8 | 0 | 29.87592238 | -93.19310676 | 2021-12-23 04:21:21 | Cameron, Louisiana, US | |
3829967 | 3829967 | 2021-12-21 | US | Louisiana | Cameron | 22023 | 874 | 8 | 0 | 29.87592238 | -93.19310676 | 2021-12-22 04:21:54 | Cameron, Louisiana, US | |
1256270 | 1256270 | 2021-12-20 | US | Louisiana | Cameron | 22023 | 874 | 8 | 0 | 29.87592238 | -93.19310676 | 2021-12-21 03:21:27 | Cameron, Louisiana, US | |
2905213 | 2905213 | 2021-12-19 | US | Louisiana | Cameron | 22023 | 874 | 8 | 0 | 29.87592238 | -93.19310676 | 2021-12-20 04:21:43 | Cameron, Louisiana, US | |
2904706 | 2904706 | 2021-12-19 | US | Illinois | Gallatin | 17059 | 874 | 10 | 0 | 37.76430935 | -88.22953869 | 2021-12-20 04:21:43 | Gallatin, Illinois, US | |
1260286 | 1260286 | 2021-12-18 | US | Louisiana | Cameron | 22023 | 874 | 8 | 0 | 29.87592238 | -93.19310676 | 2021-12-19 04:21:11 | Cameron, Louisiana, US | |
1259779 | 1259779 | 2021-12-18 | US | Illinois | Gallatin | 17059 | 874 | 10 | 0 | 37.76430935 | -88.22953869 | 2021-12-19 04:21:11 | Gallatin, Illinois, US | |
2400314 | 2400314 | 2021-12-17 | US | Louisiana | Cameron | 22023 | 874 | 8 | 0 | 29.87592238 | -93.19310676 | 2021-12-18 02:22:20 | Cameron, Louisiana, US | |
2399807 | 2399807 | 2021-12-17 | US | Illinois | Gallatin | 17059 | 874 | 10 | 0 | 37.76430935 | -88.22953869 | 2021-12-18 02:22:20 | Gallatin, Illinois, US | |
1717852 | 1717852 | 2021-12-16 | US | Louisiana | Cameron | 22023 | 874 | 8 | 0 | 29.87592238 | -93.19310676 | 2021-12-17 04:22:14 | Cameron, Louisiana, US | |
783358 | 783358 | 2021-12-13 | US | Illinois | Calhoun | 17013 | 874 | 2 | 0 | 39.16840183 | -90.66330078 | 2021-12-14 04:22:38 | Calhoun, Illinois, US | |
1661755 | 1661755 | 2021-12-12 | US | Kansas | Ottawa | 20143 | 874 | 14 | 0 | 39.13237408 | -97.65020313 | 2021-12-13 04:22:02 | Ottawa, Kansas, 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]);