johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
368 rows where confirmed = 1888 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2560049 | 2560049 | 2022-11-29 | US | Washington | San Juan | 53055 | 1888 | 3 | 0 | 48.60182783 | -122.96745 | 2022-11-30 04:21:07 | San Juan, Washington, US | |
2557200 | 2557200 | 2022-11-29 | US | Colorado | Clear Creek | 8019 | 1888 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-11-30 04:21:07 | Clear Creek, Colorado, US | |
1243123 | 1243123 | 2022-11-28 | US | Washington | San Juan | 53055 | 1888 | 3 | 0 | 48.60182783 | -122.96745 | 2022-11-29 04:21:05 | San Juan, Washington, US | |
1240274 | 1240274 | 2022-11-28 | US | Colorado | Clear Creek | 8019 | 1888 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-11-29 04:21:05 | Clear Creek, Colorado, US | |
3555111 | 3555111 | 2022-11-27 | US | Washington | San Juan | 53055 | 1888 | 3 | 0 | 48.60182783 | -122.96745 | 2022-11-28 04:21:02 | San Juan, Washington, US | |
2103591 | 2103591 | 2022-11-26 | US | Washington | San Juan | 53055 | 1888 | 3 | 0 | 48.60182783 | -122.96745 | 2022-11-27 04:21:05 | San Juan, Washington, US | |
491082 | 491082 | 2022-11-25 | US | Washington | San Juan | 53055 | 1888 | 3 | 0 | 48.60182783 | -122.96745 | 2022-11-26 04:21:11 | San Juan, Washington, US | |
3526911 | 3526911 | 2022-11-24 | US | Washington | San Juan | 53055 | 1888 | 3 | 0 | 48.60182783 | -122.96745 | 2022-11-25 04:21:06 | San Juan, Washington, US | |
3315694 | 3315694 | 2022-11-23 | US | Washington | San Juan | 53055 | 1888 | 3 | 0 | 48.60182783 | -122.96745 | 2022-11-24 04:21:09 | San Juan, Washington, US | |
3250566 | 3250566 | 2022-10-11 | US | Alaska | Aleutians West | 2016 | 1888 | 3 | 0 | 52.3233 | -174.1596 | 2022-10-12 04:22:51 | Aleutians West, Alaska, US | |
2967825 | 2967825 | 2022-10-10 | US | Alaska | Aleutians West | 2016 | 1888 | 3 | 0 | 52.3233 | -174.1596 | 2022-10-11 04:23:05 | Aleutians West, Alaska, US | |
3097861 | 3097861 | 2022-10-09 | US | Alaska | Aleutians West | 2016 | 1888 | 3 | 0 | 52.3233 | -174.1596 | 2022-10-10 04:22:32 | Aleutians West, Alaska, US | |
4003086 | 4003086 | 2022-10-08 | US | Alaska | Aleutians West | 2016 | 1888 | 3 | 0 | 52.3233 | -174.1596 | 2022-10-09 04:21:16 | Aleutians West, Alaska, US | |
396683 | 396683 | 2022-10-07 | US | Alaska | Aleutians West | 2016 | 1888 | 3 | 0 | 52.3233 | -174.1596 | 2022-10-08 04:22:56 | Aleutians West, Alaska, US | |
2529800 | 2529800 | 2022-10-06 | US | Alaska | Aleutians West | 2016 | 1888 | 3 | 0 | 52.3233 | -174.1596 | 2022-10-07 04:23:08 | Aleutians West, Alaska, US | |
1811194 | 1811194 | 2022-10-05 | US | Alaska | Aleutians West | 2016 | 1888 | 3 | 0 | 52.3233 | -174.1596 | 2022-10-06 04:21:22 | Aleutians West, Alaska, US | |
1976418 | 1976418 | 2022-09-25 | China | Liaoning | 1888 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-26 04:20:52 | Liaoning, China | |||
2649585 | 2649585 | 2022-09-24 | China | Liaoning | 1888 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-25 04:23:31 | Liaoning, China | |||
384025 | 384025 | 2022-09-23 | China | Liaoning | 1888 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-24 04:21:40 | Liaoning, China | |||
256480 | 256480 | 2022-09-08 | US | Texas | Marion | 48315 | 1888 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-09-09 04:21:11 | Marion, Texas, US | |
115265 | 115265 | 2022-09-06 | US | Arkansas | Newton | 5101 | 1888 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-09-07 04:20:59 | Newton, Arkansas, US | |
2634237 | 2634237 | 2022-09-05 | US | Arkansas | Newton | 5101 | 1888 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-09-06 04:21:02 | Newton, Arkansas, US | |
2830696 | 2830696 | 2022-08-25 | US | Missouri | Caldwell | 29025 | 1888 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-26 04:21:02 | Caldwell, Missouri, US | |
2325229 | 2325229 | 2022-08-24 | US | Missouri | Caldwell | 29025 | 1888 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-25 04:21:13 | Caldwell, Missouri, US | |
1252638 | 1252638 | 2022-08-23 | US | Missouri | Caldwell | 29025 | 1888 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-24 04:20:46 | Caldwell, Missouri, US | |
2854742 | 2854742 | 2022-08-22 | US | Missouri | Caldwell | 29025 | 1888 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-23 04:20:56 | Caldwell, Missouri, US | |
2404714 | 2404714 | 2022-08-21 | US | Missouri | Caldwell | 29025 | 1888 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-22 04:20:38 | Caldwell, Missouri, US | |
3799792 | 3799792 | 2022-08-20 | US | Missouri | Caldwell | 29025 | 1888 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-21 04:20:44 | Caldwell, Missouri, US | |
2365378 | 2365378 | 2022-08-19 | US | Missouri | Caldwell | 29025 | 1888 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-20 04:21:01 | Caldwell, Missouri, US | |
2495073 | 2495073 | 2022-08-15 | US | Illinois | Pulaski | 17153 | 1888 | 22 | 0 | 37.22631423 | -89.13085001 | 2022-08-16 04:20:58 | Pulaski, Illinois, US | |
3908486 | 3908486 | 2022-08-11 | US | Arkansas | Dallas | 5039 | 1888 | 33 | 0 | 33.97042763 | -92.65167437 | 2022-08-12 04:20:54 | Dallas, Arkansas, US | |
1346803 | 1346803 | 2022-08-10 | US | Arkansas | Dallas | 5039 | 1888 | 33 | 0 | 33.97042763 | -92.65167437 | 2022-08-11 04:20:49 | Dallas, Arkansas, US | |
1071955 | 1071955 | 2022-08-07 | US | Nebraska | Cuming | 31039 | 1888 | 13 | 0 | 41.91637624 | -96.78730772 | 2022-08-08 04:21:08 | Cuming, Nebraska, US | |
1942543 | 1942543 | 2022-08-06 | US | Nebraska | Cuming | 31039 | 1888 | 13 | 0 | 41.91637624 | -96.78730772 | 2022-08-07 04:20:54 | Cuming, Nebraska, US | |
882342 | 882342 | 2022-08-05 | US | Nebraska | Cuming | 31039 | 1888 | 13 | 0 | 41.91637624 | -96.78730772 | 2022-08-06 04:20:56 | Cuming, Nebraska, US | |
2010753 | 2010753 | 2022-08-04 | US | Nebraska | Cuming | 31039 | 1888 | 13 | 0 | 41.91637624 | -96.78730772 | 2022-08-05 04:20:52 | Cuming, Nebraska, US | |
1100180 | 1100180 | 2022-08-03 | US | Nebraska | Cuming | 31039 | 1888 | 13 | 0 | 41.91637624 | -96.78730772 | 2022-08-04 04:20:58 | Cuming, Nebraska, US | |
3872547 | 3872547 | 2022-07-31 | US | Illinois | Edwards | 17047 | 1888 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-08-01 04:21:03 | Edwards, Illinois, US | |
675301 | 675301 | 2022-07-30 | US | Illinois | Edwards | 17047 | 1888 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-07-31 04:21:02 | Edwards, Illinois, US | |
1784500 | 1784500 | 2022-07-29 | US | Illinois | Edwards | 17047 | 1888 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-07-30 04:20:42 | Edwards, Illinois, US | |
2422151 | 2422151 | 2022-07-15 | US | Texas | Winkler | 48495 | 1888 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-07-16 04:21:05 | Winkler, Texas, US | |
1651383 | 1651383 | 2022-06-23 | US | Tennessee | Van Buren | 47175 | 1888 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-06-24 04:20:58 | Van Buren, Tennessee, US | |
1650391 | 1650391 | 2022-06-23 | US | Montana | Madison | 30057 | 1888 | 22 | 0 | 45.30080065 | -111.9173017 | 2022-06-24 04:20:58 | Madison, Montana, US | |
2190618 | 2190618 | 2022-06-22 | US | Tennessee | Van Buren | 47175 | 1888 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-06-23 04:20:55 | Van Buren, Tennessee, US | |
2189626 | 2189626 | 2022-06-22 | US | Montana | Madison | 30057 | 1888 | 22 | 0 | 45.30080065 | -111.9173017 | 2022-06-23 04:20:55 | Madison, Montana, US | |
168057 | 168057 | 2022-06-21 | US | Montana | Madison | 30057 | 1888 | 22 | 0 | 45.30080065 | -111.9173017 | 2022-06-22 04:20:54 | Madison, Montana, US | |
1765340 | 1765340 | 2022-06-20 | US | Montana | Madison | 30057 | 1888 | 22 | 0 | 45.30080065 | -111.9173017 | 2022-06-21 04:20:56 | Madison, Montana, US | |
3271526 | 3271526 | 2022-06-19 | US | Montana | Madison | 30057 | 1888 | 22 | 0 | 45.30080065 | -111.9173017 | 2022-06-20 04:21:01 | Madison, Montana, US | |
3399438 | 3399438 | 2022-06-18 | US | Montana | Madison | 30057 | 1888 | 22 | 0 | 45.30080065 | -111.9173017 | 2022-06-19 04:20:51 | Madison, Montana, US | |
2313315 | 2313315 | 2022-06-17 | US | Montana | Madison | 30057 | 1888 | 22 | 0 | 45.30080065 | -111.9173017 | 2022-06-18 04:21:10 | Madison, Montana, US | |
3729644 | 3729644 | 2022-06-07 | US | Virginia | Williamsburg | 51830 | 1888 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-06-08 04:20:55 | Williamsburg, Virginia, US | |
3727561 | 3727561 | 2022-06-07 | US | Kansas | Russell | 20167 | 1888 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-08 04:20:55 | Russell, Kansas, US | |
3888963 | 3888963 | 2022-06-06 | US | Kansas | Russell | 20167 | 1888 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-07 04:21:08 | Russell, Kansas, US | |
3508732 | 3508732 | 2022-06-05 | US | Kansas | Russell | 20167 | 1888 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-06 04:20:57 | Russell, Kansas, US | |
3528809 | 3528809 | 2022-06-04 | US | Kansas | Russell | 20167 | 1888 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-05 04:20:55 | Russell, Kansas, US | |
3134895 | 3134895 | 2022-06-03 | US | Kansas | Russell | 20167 | 1888 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-04 04:20:58 | Russell, Kansas, US | |
3579970 | 3579970 | 2022-06-02 | US | Kansas | Russell | 20167 | 1888 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-03 04:20:58 | Russell, Kansas, US | |
972263 | 972263 | 2022-06-01 | US | Kansas | Russell | 20167 | 1888 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-06-02 05:20:39 | Russell, Kansas, US | |
3586120 | 3586120 | 2022-05-17 | US | West Virginia | Calhoun | 54013 | 1888 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-18 04:20:50 | Calhoun, West Virginia, US | |
1507077 | 1507077 | 2022-05-16 | US | West Virginia | Calhoun | 54013 | 1888 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-05-17 04:20:59 | Calhoun, West Virginia, US | |
3266130 | 3266130 | 2022-05-04 | US | Colorado | Lake | 8065 | 1888 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-05-05 04:20:55 | Lake, Colorado, US | |
1572769 | 1572769 | 2022-05-03 | US | Colorado | Lake | 8065 | 1888 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-05-04 04:20:59 | Lake, Colorado, US | |
2895479 | 2895479 | 2022-04-21 | US | Texas | Crosby | 48107 | 1888 | 45 | 0 | 33.61431553 | -101.30003640000001 | 2022-04-22 04:20:45 | Crosby, Texas, US | |
3867394 | 3867394 | 2022-04-05 | Colombia | Vaupes | 1888 | 20 | 0 | 0.8554 | -70.812 | 2022-04-06 04:20:49 | Vaupes, Colombia | |||
2748736 | 2748736 | 2022-04-04 | Colombia | Vaupes | 1888 | 20 | 0 | 0.8554 | -70.812 | 2022-04-05 04:20:48 | Vaupes, Colombia | |||
3730082 | 3730082 | 2022-04-03 | Colombia | Vaupes | 1888 | 20 | 0 | 0.8554 | -70.812 | 2022-04-04 04:20:51 | Vaupes, Colombia | |||
499517 | 499517 | 2022-04-02 | Colombia | Vaupes | 1888 | 20 | 0 | 0.8554 | -70.812 | 2022-04-03 04:20:48 | Vaupes, Colombia | |||
3350502 | 3350502 | 2022-04-01 | Colombia | Vaupes | 1888 | 19 | 0 | 0.8554 | -70.812 | 2022-04-02 04:20:47 | Vaupes, Colombia | |||
1539807 | 1539807 | 2022-03-31 | Colombia | Vaupes | 1888 | 19 | 0 | 0.8554 | -70.812 | 2022-04-01 04:20:28 | Vaupes, Colombia | |||
2477820 | 2477820 | 2022-03-30 | Colombia | Vaupes | 1888 | 19 | 0 | 0.8554 | -70.812 | 2022-03-31 04:20:56 | Vaupes, Colombia | |||
157861 | 157861 | 2022-03-29 | Colombia | Vaupes | 1888 | 19 | 0 | 0.8554 | -70.812 | 2022-03-30 04:20:45 | Vaupes, Colombia | |||
1647928 | 1647928 | 2022-03-03 | US | Wisconsin | Menominee | 55078 | 1888 | 13 | 0 | 45.00422544 | -88.70950714 | 2022-03-04 04:21:09 | Menominee, Wisconsin, US | |
2528931 | 2528931 | 2022-03-02 | US | Wisconsin | Menominee | 55078 | 1888 | 13 | 0 | 45.00422544 | -88.70950714 | 2022-03-03 04:21:01 | Menominee, Wisconsin, US | |
2736639 | 2736639 | 2022-02-27 | US | Wyoming | Platte | 56031 | 1888 | 39 | 0 | 42.13299116 | -104.96633100000001 | 2022-02-28 04:21:05 | Platte, Wyoming, US | |
3049792 | 3049792 | 2022-02-26 | US | Wyoming | Platte | 56031 | 1888 | 39 | 0 | 42.13299116 | -104.96633100000001 | 2022-02-27 04:21:04 | Platte, Wyoming, US | |
578447 | 578447 | 2022-02-25 | US | Wyoming | Platte | 56031 | 1888 | 39 | 0 | 42.13299116 | -104.96633100000001 | 2022-02-26 04:21:12 | Platte, Wyoming, US | |
1301558 | 1301558 | 2022-02-17 | US | West Virginia | Pendleton | 54071 | 1888 | 16 | 0 | 38.68314479 | -79.35084086 | 2022-02-18 04:21:04 | Pendleton, West Virginia, US | |
2641568 | 2641568 | 2022-02-14 | China | Yunnan | 1888 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-15 04:21:09 | Yunnan, China | |||
185885 | 185885 | 2022-02-13 | China | Yunnan | 1888 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-14 04:20:51 | Yunnan, China | |||
460300 | 460300 | 2022-02-02 | US | Idaho | Benewah | 16009 | 1888 | 33 | 0 | 47.21754179 | -116.6586851 | 2022-02-03 04:21:21 | Benewah, Idaho, US | |
460260 | 460260 | 2022-02-02 | US | Georgia | Taylor | 13269 | 1888 | 48 | 0 | 32.55792548 | -84.25077141 | 2022-02-03 04:21:21 | Taylor, Georgia, US | |
3813067 | 3813067 | 2022-01-28 | US | Texas | Jim Hogg | 48247 | 1888 | 20 | 0 | 27.04453923 | -98.69681870000001 | 2022-01-29 04:21:10 | Jim Hogg, Texas, US | |
1321305 | 1321305 | 2022-01-26 | US | Texas | Franklin | 48159 | 1888 | 37 | 0 | 33.17653242 | -95.21917243 | 2022-01-27 04:21:19 | Franklin, Texas, US | |
1230680 | 1230680 | 2022-01-24 | US | Texas | Dallam | 48111 | 1888 | 33 | 0 | 36.27787176 | -102.60207249999999 | 2022-01-25 04:21:05 | Dallam, Texas, US | |
1144296 | 1144296 | 2022-01-23 | US | Virginia | Northumberland | 51133 | 1888 | 39 | 0 | 37.89202088 | -76.41949732 | 2022-01-24 04:21:12 | Northumberland, Virginia, US | |
1143979 | 1143979 | 2022-01-23 | US | Texas | Dallam | 48111 | 1888 | 33 | 0 | 36.27787176 | -102.60207249999999 | 2022-01-24 04:21:12 | Dallam, Texas, US | |
2836214 | 2836214 | 2022-01-22 | US | Virginia | Northumberland | 51133 | 1888 | 39 | 0 | 37.89202088 | -76.41949732 | 2022-01-23 04:21:13 | Northumberland, Virginia, US | |
3428332 | 3428332 | 2022-01-21 | US | Virginia | Northumberland | 51133 | 1888 | 39 | 0 | 37.89202088 | -76.41949732 | 2022-01-22 04:21:13 | Northumberland, Virginia, US | |
1963534 | 1963534 | 2022-01-20 | US | Tennessee | Moore | 47127 | 1888 | 34 | 0 | 35.27724699 | -86.36230578 | 2022-01-21 04:21:09 | Moore, Tennessee, US | |
3228388 | 3228388 | 2022-01-19 | US | Missouri | Monroe | 29137 | 1888 | 37 | 0 | 39.49593978 | -92.00043978 | 2022-01-20 04:21:07 | Monroe, Missouri, US | |
2611386 | 2611386 | 2022-01-06 | US | Kansas | Rice | 20159 | 1888 | 17 | 0 | 38.34616184 | -98.19992118 | 2022-01-07 04:22:09 | Rice, Kansas, US | |
1283328 | 1283328 | 2022-01-05 | US | Kansas | Rice | 20159 | 1888 | 17 | 0 | 38.34616184 | -98.19992118 | 2022-01-06 04:22:09 | Rice, Kansas, US | |
1287768 | 1287768 | 2022-01-04 | US | Minnesota | Rock | 27133 | 1888 | 32 | 0 | 43.67482683 | -96.25296832 | 2022-01-05 04:21:59 | Rock, Minnesota, US | |
733257 | 733257 | 2021-12-27 | US | Puerto Rico | Catano | 72033 | 1888 | 0 | 0 | 18.437269 | -66.14330600000001 | 2021-12-28 04:21:47 | Catano, Puerto Rico, US | |
3829685 | 3829685 | 2021-12-21 | US | Iowa | Louisa | 19115 | 1888 | 53 | 0 | 41.21842119 | -91.26102611 | 2021-12-22 04:21:54 | Louisa, Iowa, US | |
1256336 | 1256336 | 2021-12-20 | US | Maine | Piscataquis | 23021 | 1888 | 15 | 0 | 45.83839062 | -69.2860223 | 2021-12-21 03:21:27 | Piscataquis, Maine, US | |
1255988 | 1255988 | 2021-12-20 | US | Iowa | Louisa | 19115 | 1888 | 53 | 0 | 41.21842119 | -91.26102611 | 2021-12-21 03:21:27 | Louisa, Iowa, US | |
2905279 | 2905279 | 2021-12-19 | US | Maine | Piscataquis | 23021 | 1888 | 15 | 0 | 45.83839062 | -69.2860223 | 2021-12-20 04:21:43 | Piscataquis, Maine, US | |
2904931 | 2904931 | 2021-12-19 | US | Iowa | Louisa | 19115 | 1888 | 53 | 0 | 41.21842119 | -91.26102611 | 2021-12-20 04:21:43 | Louisa, Iowa, US | |
1260352 | 1260352 | 2021-12-18 | US | Maine | Piscataquis | 23021 | 1888 | 15 | 0 | 45.83839062 | -69.2860223 | 2021-12-19 04:21:11 | Piscataquis, Maine, 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]);