johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
824 rows where confirmed = 396 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 25
- US 767
- China 20
- Malaysia 6
- Canada 5
- Bhutan 2
- Comoros 2
- Japan 2
- Netherlands 2
- United Kingdom 2
- Angola 1
- Australia 1
- Colombia 1
- Costa Rica 1
- Cuba 1
- Cyprus 1
- Czechia 1
- Guyana 1
- India 1
- Jamaica 1
- Kenya 1
- Mainland China 1
- Paraguay 1
- Russia 1
- Saint Kitts and Nevis 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3214918 | 3214918 | 2022-10-12 | US | Colorado | Dolores | 8033 | 396 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-10-13 04:22:39 | Dolores, Colorado, US | |
3250767 | 3250767 | 2022-10-11 | US | Colorado | Dolores | 8033 | 396 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-10-12 04:22:51 | Dolores, Colorado, US | |
2968026 | 2968026 | 2022-10-10 | US | Colorado | Dolores | 8033 | 396 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-10-11 04:23:05 | Dolores, Colorado, US | |
2531407 | 2531407 | 2022-10-06 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-10-07 04:23:08 | Powder River, Montana, US | |
1812801 | 1812801 | 2022-10-05 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-10-06 04:21:22 | Powder River, Montana, US | |
132775 | 132775 | 2022-10-04 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-10-05 04:23:06 | Powder River, Montana, US | |
2687722 | 2687722 | 2022-10-03 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-10-04 04:22:55 | Powder River, Montana, US | |
2261789 | 2261789 | 2022-10-02 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-10-03 04:23:11 | Powder River, Montana, US | |
2997315 | 2997315 | 2022-10-01 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-10-02 04:21:23 | Powder River, Montana, US | |
855641 | 855641 | 2022-09-30 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-10-01 04:23:01 | Powder River, Montana, US | |
2377567 | 2377567 | 2022-09-29 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-30 04:23:09 | Powder River, Montana, US | |
1562118 | 1562118 | 2022-09-28 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-29 04:22:34 | Powder River, Montana, US | |
3996661 | 3996661 | 2022-09-27 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-28 04:23:01 | Powder River, Montana, US | |
2770989 | 2770989 | 2022-09-26 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-27 04:23:01 | Powder River, Montana, US | |
1978642 | 1978642 | 2022-09-25 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-26 04:20:52 | Powder River, Montana, US | |
2651809 | 2651809 | 2022-09-24 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-25 04:23:31 | Powder River, Montana, US | |
386249 | 386249 | 2022-09-23 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-24 04:21:40 | Powder River, Montana, US | |
1626315 | 1626315 | 2022-09-22 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-23 04:23:13 | Powder River, Montana, US | |
1372519 | 1372519 | 2022-09-21 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-22 04:22:56 | Powder River, Montana, US | |
2018749 | 2018749 | 2022-09-20 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-21 04:23:22 | Powder River, Montana, US | |
3572622 | 3572622 | 2022-09-19 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-20 04:22:48 | Powder River, Montana, US | |
421361 | 421361 | 2022-09-18 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-19 04:21:49 | Powder River, Montana, US | |
3375385 | 3375385 | 2022-09-17 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-18 04:22:50 | Powder River, Montana, US | |
2357493 | 2357493 | 2022-09-16 | US | Montana | Powder River | 30075 | 396 | 10 | 0 | 45.39617714 | -105.636738 | 2022-09-17 04:20:19 | Powder River, Montana, US | |
1068309 | 1068309 | 2022-07-28 | US | North Dakota | Steele | 38091 | 396 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-29 04:20:45 | Steele, North Dakota, US | |
2337828 | 2337828 | 2022-07-27 | US | North Dakota | Steele | 38091 | 396 | 2 | 0 | 47.45611548 | -97.72728747 | 2022-07-28 04:20:56 | Steele, North Dakota, US | |
3890977 | 3890977 | 2022-06-06 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-06-07 04:21:08 | Highland, Virginia, US | |
3510746 | 3510746 | 2022-06-05 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-06-06 04:20:57 | Highland, Virginia, US | |
3530823 | 3530823 | 2022-06-04 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-06-05 04:20:55 | Highland, Virginia, US | |
3136909 | 3136909 | 2022-06-03 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-06-04 04:20:58 | Highland, Virginia, US | |
3582069 | 3582069 | 2022-06-02 | US | Washington | Garfield | 53023 | 396 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-06-03 04:20:58 | Garfield, Washington, US | |
3581984 | 3581984 | 2022-06-02 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-06-03 04:20:58 | Highland, Virginia, US | |
974362 | 974362 | 2022-06-01 | US | Washington | Garfield | 53023 | 396 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-06-02 05:20:39 | Garfield, Washington, US | |
974277 | 974277 | 2022-06-01 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-06-02 05:20:39 | Highland, Virginia, US | |
232584 | 232584 | 2022-05-31 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-06-01 04:20:55 | Highland, Virginia, US | |
3189349 | 3189349 | 2022-05-30 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-31 04:20:51 | Highland, Virginia, US | |
3201498 | 3201498 | 2022-05-29 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-30 04:20:50 | Highland, Virginia, US | |
2728376 | 2728376 | 2022-05-28 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-29 04:20:53 | Highland, Virginia, US | |
1317557 | 1317557 | 2022-05-27 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-28 04:21:07 | Highland, Virginia, US | |
1853349 | 1853349 | 2022-05-26 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-27 04:20:56 | Highland, Virginia, US | |
2051225 | 2051225 | 2022-05-25 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-26 04:20:50 | Highland, Virginia, US | |
625236 | 625236 | 2022-05-22 | US | Virginia | Highland | 51091 | 396 | 7 | 0 | 38.35799465 | -79.56124594 | 2022-05-26 04:20:50 | Highland, Virginia, US | |
224072 | 224072 | 2022-05-09 | US | Nebraska | Garfield | 31071 | 396 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-05-10 04:20:50 | Garfield, Nebraska, US | |
2333457 | 2333457 | 2022-05-08 | US | Nebraska | Garfield | 31071 | 396 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-05-09 04:20:54 | Garfield, Nebraska, US | |
362419 | 362419 | 2022-05-07 | US | Nebraska | Garfield | 31071 | 396 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-05-08 04:20:49 | Garfield, Nebraska, US | |
1399770 | 1399770 | 2022-05-06 | US | Nebraska | Garfield | 31071 | 396 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-05-07 04:21:09 | Garfield, Nebraska, US | |
2600125 | 2600125 | 2022-05-05 | US | Nebraska | Garfield | 31071 | 396 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-05-06 04:21:00 | Garfield, Nebraska, US | |
3267574 | 3267574 | 2022-05-04 | US | Nebraska | Garfield | 31071 | 396 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-05-05 04:20:55 | Garfield, Nebraska, US | |
1574213 | 1574213 | 2022-05-03 | US | Nebraska | Garfield | 31071 | 396 | 2 | 0 | 41.91428955 | -98.99111827 | 2022-05-04 04:20:59 | Garfield, Nebraska, US | |
160022 | 160022 | 2022-03-29 | US | Montana | Liberty | 30051 | 396 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-30 04:20:45 | Liberty, Montana, US | |
1438593 | 1438593 | 2022-03-28 | US | Montana | Liberty | 30051 | 396 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-29 04:20:46 | Liberty, Montana, US | |
878274 | 878274 | 2022-03-27 | US | Montana | Liberty | 30051 | 396 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-28 04:20:33 | Liberty, Montana, US | |
2165557 | 2165557 | 2022-03-26 | US | Montana | Liberty | 30051 | 396 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-27 04:20:47 | Liberty, Montana, US | |
1722493 | 1722493 | 2022-03-25 | US | Montana | Liberty | 30051 | 396 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-26 04:20:23 | Liberty, Montana, US | |
1470110 | 1470110 | 2022-03-24 | US | Montana | Liberty | 30051 | 396 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-25 04:20:46 | Liberty, Montana, US | |
3024284 | 3024284 | 2022-03-23 | US | Montana | Liberty | 30051 | 396 | 4 | 0 | 48.56084317 | -111.02430700000001 | 2022-03-24 04:20:43 | Liberty, Montana, US | |
1513516 | 1513516 | 2022-02-24 | US | Nebraska | Pawnee | 31133 | 396 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-25 04:21:11 | Pawnee, Nebraska, US | |
1513391 | 1513391 | 2022-02-24 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-25 04:21:11 | Worth, Missouri, US | |
1059957 | 1059957 | 2022-02-23 | US | Nebraska | Pawnee | 31133 | 396 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-24 04:21:14 | Pawnee, Nebraska, US | |
1059832 | 1059832 | 2022-02-23 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-24 04:21:14 | Worth, Missouri, US | |
2448880 | 2448880 | 2022-02-22 | US | Nebraska | Pawnee | 31133 | 396 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-23 04:21:09 | Pawnee, Nebraska, US | |
2448755 | 2448755 | 2022-02-22 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-23 04:21:09 | Worth, Missouri, US | |
3720293 | 3720293 | 2022-02-21 | US | Nebraska | Pawnee | 31133 | 396 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-22 04:21:01 | Pawnee, Nebraska, US | |
3720257 | 3720257 | 2022-02-21 | US | Nebraska | Franklin | 31061 | 396 | 4 | 0 | 40.17636348 | -98.95299073 | 2022-02-22 04:21:01 | Franklin, Nebraska, US | |
3720168 | 3720168 | 2022-02-21 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-22 04:21:01 | Worth, Missouri, US | |
3914127 | 3914127 | 2022-02-20 | US | Nebraska | Pawnee | 31133 | 396 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-21 04:21:05 | Pawnee, Nebraska, US | |
3914002 | 3914002 | 2022-02-20 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-21 04:21:05 | Worth, Missouri, US | |
3877685 | 3877685 | 2022-02-19 | US | Nebraska | Pawnee | 31133 | 396 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-20 04:21:00 | Pawnee, Nebraska, US | |
3877560 | 3877560 | 2022-02-19 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-20 04:21:00 | Worth, Missouri, US | |
3857941 | 3857941 | 2022-02-18 | US | Nebraska | Pawnee | 31133 | 396 | 1 | 0 | 40.13141096 | -96.23705437 | 2022-02-19 04:21:11 | Pawnee, Nebraska, US | |
3857816 | 3857816 | 2022-02-18 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-19 04:21:11 | Worth, Missouri, US | |
1300035 | 1300035 | 2022-02-17 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-18 04:21:04 | Worth, Missouri, US | |
3822421 | 3822421 | 2022-02-16 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-17 04:20:56 | Worth, Missouri, US | |
3673635 | 3673635 | 2022-02-15 | US | Missouri | Worth | 29227 | 396 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-02-16 04:21:10 | Worth, Missouri, US | |
2015589 | 2015589 | 2022-02-06 | US | South Dakota | Jerauld | 46073 | 396 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-02-07 04:21:05 | Jerauld, South Dakota, US | |
1296918 | 1296918 | 2022-02-05 | US | South Dakota | Jerauld | 46073 | 396 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-02-06 04:21:00 | Jerauld, South Dakota, US | |
2330246 | 2330246 | 2022-02-04 | US | South Dakota | Jerauld | 46073 | 396 | 19 | 0 | 44.06637798 | -98.62965972 | 2022-02-05 04:21:05 | Jerauld, South Dakota, US | |
979814 | 979814 | 2022-02-01 | US | Georgia | Quitman | 13239 | 396 | 4 | 0 | 31.86728114 | -85.01773177 | 2022-02-02 04:21:09 | Quitman, Georgia, US | |
1218716 | 1218716 | 2022-01-08 | US | Texas | Knox | 48275 | 396 | 22 | 0 | 33.60519951 | -99.74229059999999 | 2022-01-09 04:21:46 | Knox, Texas, US | |
2612942 | 2612942 | 2022-01-06 | US | South Dakota | Miner | 46097 | 396 | 12 | 0 | 44.02197882 | -97.60992207 | 2022-01-07 04:22:09 | Miner, South Dakota, US | |
1257179 | 1257179 | 2021-12-20 | US | North Dakota | Kidder | 38043 | 396 | 13 | 0 | 46.97830064 | -99.77507857 | 2021-12-21 03:21:27 | Kidder, North Dakota, US | |
1719371 | 1719371 | 2021-12-16 | US | Texas | Armstrong | 48011 | 396 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2021-12-17 04:22:14 | Armstrong, Texas, US | |
407730 | 407730 | 2021-12-07 | US | Washington | Columbia | 53013 | 396 | 9 | 0 | 46.29442881 | -117.9051983 | 2021-12-08 04:22:46 | Columbia, Washington, US | |
3766 | 3766 | 2021-12-02 | US | Washington | Columbia | 53013 | 396 | 9 | 0 | 46.29442881 | -117.9051983 | 2021-12-03 04:23:05 | Columbia, Washington, US | |
2379 | 2379 | 2021-12-02 | US | Nebraska | Brown | 31017 | 396 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-12-03 04:23:05 | Brown, Nebraska, US | |
1232940 | 1232940 | 2021-11-28 | US | Kansas | Lincoln | 20105 | 396 | 6 | 0 | 39.04549684 | -98.20756994 | 2021-11-29 04:22:30 | Lincoln, Kansas, US | |
1231418 | 1231418 | 2021-11-28 | China | Guangxi | 396 | 2 | 0 | 23.8298 | 108.7881 | 2021-11-29 04:22:30 | Guangxi, China | |||
1359647 | 1359647 | 2021-11-27 | US | Kansas | Lincoln | 20105 | 396 | 6 | 0 | 39.04549684 | -98.20756994 | 2021-11-28 04:22:43 | Lincoln, Kansas, US | |
759638 | 759638 | 2021-11-26 | US | Kansas | Lincoln | 20105 | 396 | 6 | 0 | 39.04549684 | -98.20756994 | 2021-11-27 04:22:45 | Lincoln, Kansas, US | |
1804055 | 1804055 | 2021-11-25 | US | Kansas | Lincoln | 20105 | 396 | 6 | 0 | 39.04549684 | -98.20756994 | 2021-11-26 04:22:33 | Lincoln, Kansas, US | |
905489 | 905489 | 2021-11-24 | US | Kansas | Lincoln | 20105 | 396 | 6 | 0 | 39.04549684 | -98.20756994 | 2021-11-25 04:22:33 | Lincoln, Kansas, US | |
3072113 | 3072113 | 2021-11-23 | US | Nebraska | Hitchcock | 31087 | 396 | 5 | 0 | 40.17609175 | -101.04164770000001 | 2021-11-24 04:22:14 | Hitchcock, Nebraska, US | |
164748 | 164748 | 2021-11-19 | US | Puerto Rico | Arroyo | 72015 | 396 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-20 04:22:17 | Arroyo, Puerto Rico, US | |
3291635 | 3291635 | 2021-11-18 | US | Puerto Rico | Arroyo | 72015 | 396 | 0 | 0 | 17.998457000000005 | -66.056546 | 2021-11-19 04:21:40 | Arroyo, Puerto Rico, US | |
449493 | 449493 | 2021-11-17 | US | Nebraska | Sherman | 31163 | 396 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-11-18 04:21:33 | Sherman, Nebraska, US | |
2289861 | 2289861 | 2021-11-15 | US | North Dakota | Griggs | 38039 | 396 | 2 | 0 | 47.45785838 | -98.23850925 | 2021-11-16 04:21:10 | Griggs, North Dakota, US | |
1324303 | 1324303 | 2021-11-14 | US | Nebraska | Frontier | 31063 | 396 | 1 | 0 | 40.52993007 | -100.3924658 | 2021-11-15 04:21:36 | Frontier, Nebraska, US | |
688429 | 688429 | 2021-11-13 | US | Nebraska | Frontier | 31063 | 396 | 1 | 0 | 40.52993007 | -100.3924658 | 2021-11-14 04:21:31 | Frontier, Nebraska, US | |
716538 | 716538 | 2021-11-12 | US | Nebraska | Frontier | 31063 | 396 | 1 | 0 | 40.52993007 | -100.3924658 | 2021-11-13 04:21:38 | Frontier, Nebraska, US | |
90027 | 90027 | 2021-11-09 | US | South Dakota | Sanborn | 46111 | 396 | 3 | 0 | 44.02351092 | -98.09098159999999 | 2021-11-10 04:21:38 | Sanborn, South Dakota, 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]);