johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
596 rows where confirmed = 831 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3462565 | 3462565 | 2022-11-21 | US | North Dakota | Emmons | 38029 | 831 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-11-22 04:20:47 | Emmons, North Dakota, US | |
295071 | 295071 | 2022-11-15 | US | Texas | Collingsworth | 48087 | 831 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-11-16 04:21:09 | Collingsworth, Texas, US | |
3600101 | 3600101 | 2022-11-14 | US | Texas | Collingsworth | 48087 | 831 | 16 | 0 | 34.96489496 | -100.2700111 | 2022-11-15 04:21:16 | Collingsworth, Texas, US | |
3251477 | 3251477 | 2022-10-11 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-12 04:22:51 | Ness, Kansas, US | |
2968736 | 2968736 | 2022-10-10 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-11 04:23:05 | Ness, Kansas, US | |
3098772 | 3098772 | 2022-10-09 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-10 04:22:32 | Ness, Kansas, US | |
4003997 | 4003997 | 2022-10-08 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-09 04:21:16 | Ness, Kansas, US | |
397594 | 397594 | 2022-10-07 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-08 04:22:56 | Ness, Kansas, US | |
2530711 | 2530711 | 2022-10-06 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-07 04:23:08 | Ness, Kansas, US | |
1812105 | 1812105 | 2022-10-05 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-06 04:21:22 | Ness, Kansas, US | |
132079 | 132079 | 2022-10-04 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-05 04:23:06 | Ness, Kansas, US | |
2687026 | 2687026 | 2022-10-03 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-04 04:22:55 | Ness, Kansas, US | |
2261093 | 2261093 | 2022-10-02 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-03 04:23:11 | Ness, Kansas, US | |
2996619 | 2996619 | 2022-10-01 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-02 04:21:23 | Ness, Kansas, US | |
854945 | 854945 | 2022-09-30 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-10-01 04:23:01 | Ness, Kansas, US | |
2377506 | 2377506 | 2022-09-29 | US | Missouri | Schuyler | 29197 | 831 | 27 | 0 | 40.46921489 | -92.52311943 | 2022-09-30 04:23:09 | Schuyler, Missouri, US | |
2376871 | 2376871 | 2022-09-29 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-09-30 04:23:09 | Ness, Kansas, US | |
1562057 | 1562057 | 2022-09-28 | US | Missouri | Schuyler | 29197 | 831 | 27 | 0 | 40.46921489 | -92.52311943 | 2022-09-29 04:22:34 | Schuyler, Missouri, US | |
1561422 | 1561422 | 2022-09-28 | US | Kansas | Ness | 20135 | 831 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-09-29 04:22:34 | Ness, Kansas, US | |
3996600 | 3996600 | 2022-09-27 | US | Missouri | Schuyler | 29197 | 831 | 27 | 0 | 40.46921489 | -92.52311943 | 2022-09-28 04:23:01 | Schuyler, Missouri, US | |
2770928 | 2770928 | 2022-09-26 | US | Missouri | Schuyler | 29197 | 831 | 27 | 0 | 40.46921489 | -92.52311943 | 2022-09-27 04:23:01 | Schuyler, Missouri, US | |
1978581 | 1978581 | 2022-09-25 | US | Missouri | Schuyler | 29197 | 831 | 27 | 0 | 40.46921489 | -92.52311943 | 2022-09-26 04:20:52 | Schuyler, Missouri, US | |
2651748 | 2651748 | 2022-09-24 | US | Missouri | Schuyler | 29197 | 831 | 27 | 0 | 40.46921489 | -92.52311943 | 2022-09-25 04:23:31 | Schuyler, Missouri, US | |
386188 | 386188 | 2022-09-23 | US | Missouri | Schuyler | 29197 | 831 | 27 | 0 | 40.46921489 | -92.52311943 | 2022-09-24 04:21:40 | Schuyler, Missouri, US | |
2496451 | 2496451 | 2022-08-15 | US | North Dakota | Nelson | 38063 | 831 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-08-16 04:20:58 | Nelson, North Dakota, US | |
1490435 | 1490435 | 2022-07-26 | US | South Dakota | Aurora | 46003 | 831 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-27 04:21:04 | Aurora, South Dakota, US | |
1488929 | 1488929 | 2022-07-26 | US | Kansas | Rush | 20165 | 831 | 19 | 0 | 38.52275276 | -99.30863983 | 2022-07-27 04:21:04 | Rush, Kansas, US | |
1488877 | 1488877 | 2022-07-26 | US | Kansas | Gove | 20063 | 831 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-07-27 04:21:04 | Gove, Kansas, US | |
2596881 | 2596881 | 2022-07-25 | US | South Dakota | Aurora | 46003 | 831 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-26 04:20:58 | Aurora, South Dakota, US | |
2595375 | 2595375 | 2022-07-25 | US | Kansas | Rush | 20165 | 831 | 19 | 0 | 38.52275276 | -99.30863983 | 2022-07-26 04:20:58 | Rush, Kansas, US | |
2595323 | 2595323 | 2022-07-25 | US | Kansas | Gove | 20063 | 831 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-07-26 04:20:58 | Gove, Kansas, US | |
898996 | 898996 | 2022-07-24 | US | South Dakota | Aurora | 46003 | 831 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-25 04:20:51 | Aurora, South Dakota, US | |
897490 | 897490 | 2022-07-24 | US | Kansas | Rush | 20165 | 831 | 19 | 0 | 38.52275276 | -99.30863983 | 2022-07-25 04:20:51 | Rush, Kansas, US | |
897438 | 897438 | 2022-07-24 | US | Kansas | Gove | 20063 | 831 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-07-25 04:20:51 | Gove, Kansas, US | |
93990 | 93990 | 2022-07-23 | US | South Dakota | Aurora | 46003 | 831 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-24 04:20:47 | Aurora, South Dakota, US | |
92484 | 92484 | 2022-07-23 | US | Kansas | Rush | 20165 | 831 | 19 | 0 | 38.52275276 | -99.30863983 | 2022-07-24 04:20:47 | Rush, Kansas, US | |
92432 | 92432 | 2022-07-23 | US | Kansas | Gove | 20063 | 831 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-07-24 04:20:47 | Gove, Kansas, US | |
91753 | 91753 | 2022-07-23 | US | Colorado | Costilla | 8023 | 831 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-07-24 04:20:47 | Costilla, Colorado, US | |
903012 | 903012 | 2022-07-22 | US | South Dakota | Aurora | 46003 | 831 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-23 04:20:53 | Aurora, South Dakota, US | |
901506 | 901506 | 2022-07-22 | US | Kansas | Rush | 20165 | 831 | 19 | 0 | 38.52275276 | -99.30863983 | 2022-07-23 04:20:53 | Rush, Kansas, US | |
901454 | 901454 | 2022-07-22 | US | Kansas | Gove | 20063 | 831 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-07-23 04:20:53 | Gove, Kansas, US | |
900775 | 900775 | 2022-07-22 | US | Colorado | Costilla | 8023 | 831 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-07-23 04:20:53 | Costilla, Colorado, US | |
673148 | 673148 | 2022-07-21 | US | South Dakota | Aurora | 46003 | 831 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-22 04:21:15 | Aurora, South Dakota, US | |
671642 | 671642 | 2022-07-21 | US | Kansas | Rush | 20165 | 831 | 19 | 0 | 38.52275276 | -99.30863983 | 2022-07-22 04:21:15 | Rush, Kansas, US | |
671590 | 671590 | 2022-07-21 | US | Kansas | Gove | 20063 | 831 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-07-22 04:21:15 | Gove, Kansas, US | |
1611111 | 1611111 | 2022-07-20 | US | South Dakota | Aurora | 46003 | 831 | 17 | 0 | 43.71757685 | -98.56050467 | 2022-07-21 04:21:10 | Aurora, South Dakota, US | |
1609605 | 1609605 | 2022-07-20 | US | Kansas | Rush | 20165 | 831 | 19 | 0 | 38.52275276 | -99.30863983 | 2022-07-21 04:21:10 | Rush, Kansas, US | |
1609553 | 1609553 | 2022-07-20 | US | Kansas | Gove | 20063 | 831 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-07-21 04:21:10 | Gove, Kansas, US | |
961115 | 961115 | 2022-07-19 | US | New Mexico | Union | 35059 | 831 | 17 | 0 | 36.48126404 | -103.4709624 | 2022-07-20 04:20:59 | Union, New Mexico, US | |
145011 | 145011 | 2022-07-09 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-10 04:20:54 | Baylor, Texas, US | |
1420111 | 1420111 | 2022-07-08 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-09 04:20:59 | Baylor, Texas, US | |
2744036 | 2744036 | 2022-07-07 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-08 04:20:56 | Baylor, Texas, US | |
1202831 | 1202831 | 2022-07-06 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-07 04:20:55 | Baylor, Texas, US | |
1202086 | 1202086 | 2022-07-06 | US | New York | Unassigned | 90036 | 831 | 2 | 0 | 44.74530905 | 0.0 | 2022-07-07 04:20:55 | Unassigned, New York, US | |
3969574 | 3969574 | 2022-07-05 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-06 04:20:58 | Baylor, Texas, US | |
3968829 | 3968829 | 2022-07-05 | US | New York | Unassigned | 90036 | 831 | 2 | 0 | 44.74530905 | 0.0 | 2022-07-06 04:20:58 | Unassigned, New York, US | |
3081085 | 3081085 | 2022-07-04 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-05 04:20:45 | Baylor, Texas, US | |
1770367 | 1770367 | 2022-07-03 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-04 04:20:54 | Baylor, Texas, US | |
3368353 | 3368353 | 2022-07-02 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-03 04:20:59 | Baylor, Texas, US | |
596682 | 596682 | 2022-07-01 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-02 04:21:16 | Baylor, Texas, US | |
3943083 | 3943083 | 2022-06-30 | US | Texas | Baylor | 48023 | 831 | 32 | 0 | 33.61640794 | -99.21352901 | 2022-07-01 04:21:10 | Baylor, Texas, US | |
2150048 | 2150048 | 2022-06-27 | US | North Dakota | Hettinger | 38041 | 831 | 8 | 0 | 46.43375068 | -102.4632417 | 2022-06-28 04:20:58 | Hettinger, North Dakota, US | |
1650584 | 1650584 | 2022-06-23 | US | New Mexico | Mora | 35033 | 831 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-06-24 04:20:58 | Mora, New Mexico, US | |
561202 | 561202 | 2022-06-16 | US | North Dakota | Cavalier | 38019 | 831 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-06-17 04:20:56 | Cavalier, North Dakota, US | |
2727780 | 2727780 | 2022-05-28 | US | Puerto Rico | Maricao | 72093 | 831 | 0 | 0 | 18.171795 | -66.942126 | 2022-05-29 04:20:53 | Maricao, Puerto Rico, US | |
1849218 | 1849218 | 2022-04-18 | US | Texas | Upton | 48461 | 831 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-04-19 04:21:00 | Upton, Texas, US | |
3420162 | 3420162 | 2022-04-17 | US | Texas | Upton | 48461 | 831 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-04-18 04:21:12 | Upton, Texas, US | |
307111 | 307111 | 2022-04-16 | US | Texas | Upton | 48461 | 831 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-04-17 04:20:59 | Upton, Texas, US | |
2673056 | 2673056 | 2022-04-15 | US | Texas | Upton | 48461 | 831 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-04-16 04:20:48 | Upton, Texas, US | |
1226841 | 1226841 | 2022-04-14 | US | Texas | Upton | 48461 | 831 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-04-15 04:20:57 | Upton, Texas, US | |
158431 | 158431 | 2022-03-29 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 831 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-03-30 04:20:45 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1437002 | 1437002 | 2022-03-28 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 831 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-03-29 04:20:46 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1867252 | 1867252 | 2022-03-10 | US | Minnesota | Traverse | 27155 | 831 | 10 | 0 | 45.77298854 | -96.47062949 | 2022-03-11 04:20:50 | Traverse, Minnesota, US | |
1318862 | 1318862 | 2022-01-26 | US | Colorado | Phillips | 8095 | 831 | 17 | 0 | 40.59414277 | -102.3577703 | 2022-01-27 04:21:19 | Phillips, Colorado, US | |
1228258 | 1228258 | 2022-01-24 | US | Colorado | Ouray | 8091 | 831 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-01-25 04:21:05 | Ouray, Colorado, US | |
3229851 | 3229851 | 2022-01-19 | US | Virginia | Rappahannock | 51157 | 831 | 7 | 0 | 38.68295619 | -78.15826963 | 2022-01-20 04:21:07 | Rappahannock, Virginia, US | |
3228596 | 3228596 | 2022-01-19 | US | Nevada | Lincoln | 32017 | 831 | 5 | 0 | 37.64268459 | -114.8790388 | 2022-01-20 04:21:07 | Lincoln, Nevada, US | |
3616190 | 3616190 | 2022-01-12 | US | Texas | Hudspeth | 48229 | 831 | 14 | 0 | 31.45628381 | -105.388178 | 2022-01-13 08:00:09 | Hudspeth, Texas, US | |
1116915 | 1116915 | 2022-01-11 | US | Virginia | Craig | 51045 | 831 | 11 | 0 | 37.48133648 | -80.21072274 | 2022-01-12 04:21:44 | Craig, Virginia, US | |
1703425 | 1703425 | 2022-01-03 | US | Texas | Donley | 48129 | 831 | 18 | 0 | 34.96517499 | -100.8140093 | 2022-01-04 04:22:17 | Donley, Texas, US | |
1701227 | 1701227 | 2022-01-03 | US | Georgia | Talbot | 13263 | 831 | 30 | 0 | 32.69642758 | -84.53351366 | 2022-01-04 04:22:17 | Talbot, Georgia, US | |
3520310 | 3520310 | 2022-01-02 | US | Georgia | Talbot | 13263 | 831 | 30 | 0 | 32.69642758 | -84.53351366 | 2022-01-03 02:22:25 | Talbot, Georgia, US | |
2168440 | 2168440 | 2022-01-01 | US | Georgia | Talbot | 13263 | 831 | 30 | 0 | 32.69642758 | -84.53351366 | 2022-01-02 04:20:52 | Talbot, Georgia, US | |
2777871 | 2777871 | 2021-12-31 | US | Georgia | Talbot | 13263 | 831 | 30 | 0 | 32.69642758 | -84.53351366 | 2022-01-01 04:22:14 | Talbot, Georgia, US | |
732570 | 732570 | 2021-12-27 | US | Nebraska | Antelope | 31003 | 831 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2021-12-28 04:21:47 | Antelope, Nebraska, US | |
2113742 | 2113742 | 2021-12-26 | US | Nebraska | Antelope | 31003 | 831 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2021-12-27 04:21:58 | Antelope, Nebraska, US | |
3607114 | 3607114 | 2021-12-25 | US | Nebraska | Antelope | 31003 | 831 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2021-12-26 04:21:50 | Antelope, Nebraska, US | |
2965432 | 2965432 | 2021-12-24 | US | Nebraska | Antelope | 31003 | 831 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2021-12-25 04:21:37 | Antelope, Nebraska, US | |
3818464 | 3818464 | 2021-12-23 | US | Nebraska | Antelope | 31003 | 831 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2021-12-24 04:21:34 | Antelope, Nebraska, US | |
1717401 | 1717401 | 2021-12-16 | US | Illinois | Scott | 17171 | 831 | 7 | 0 | 39.642916899999996 | -90.47814431 | 2021-12-17 04:22:14 | Scott, Illinois, US | |
3498235 | 3498235 | 2021-12-15 | US | Nebraska | Boone | 31011 | 831 | 4 | 0 | 41.70759415 | -98.06737183 | 2021-12-16 04:22:11 | Boone, Nebraska, US | |
3497919 | 3497919 | 2021-12-15 | US | Minnesota | Kittson | 27069 | 831 | 23 | 0 | 48.77754106 | -96.78317184 | 2021-12-16 04:22:11 | Kittson, Minnesota, US | |
3497112 | 3497112 | 2021-12-15 | US | Idaho | Boise | 16015 | 831 | 11 | 0 | 43.98829931 | -115.7309284 | 2021-12-16 04:22:11 | Boise, Idaho, US | |
407410 | 407410 | 2021-12-07 | US | Texas | Hemphill | 48211 | 831 | 3 | 0 | 35.83764858 | -100.2703577 | 2021-12-08 04:22:46 | Hemphill, Texas, US | |
1033492 | 1033492 | 2021-12-06 | US | Texas | Hemphill | 48211 | 831 | 3 | 0 | 35.83764858 | -100.2703577 | 2021-12-07 04:22:34 | Hemphill, Texas, US | |
1031366 | 1031366 | 2021-12-06 | US | Illinois | Gallatin | 17059 | 831 | 10 | 0 | 37.76430935 | -88.22953869 | 2021-12-07 04:22:34 | Gallatin, Illinois, US | |
3402387 | 3402387 | 2021-11-30 | US | Idaho | Lewis | 16061 | 831 | 23 | 0 | 46.23315327 | -116.434146 | 2021-12-01 04:22:29 | Lewis, Idaho, US | |
3071686 | 3071686 | 2021-11-23 | US | Michigan | Luce | 26095 | 831 | 5 | 0 | 46.47227431 | -85.54471223 | 2021-11-24 04:22:14 | Luce, Michigan, US | |
3750784 | 3750784 | 2021-11-22 | US | Michigan | Luce | 26095 | 831 | 5 | 0 | 46.47227431 | -85.54471223 | 2021-11-23 04:22:39 | Luce, Michigan, US | |
29760 | 29760 | 2021-11-11 | US | Kansas | Scott | 20171 | 831 | 29 | 0 | 38.48222076 | -100.90665390000001 | 2021-11-12 04:22:01 | Scott, 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]);