johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
375 rows where confirmed = 2114 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 354
- China 4
- Canada 3
- Russia 2
- Ukraine 2
- United Kingdom 2
- Albania 1
- Germany 1
- Italy 1
- Japan 1
- Liberia 1
- Netherlands 1
- Peru 1
- Sao Tome and Principe 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1985436 | 1985436 | 2022-12-07 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-08 04:21:07 | Crawford, Georgia, US | |
3714959 | 3714959 | 2022-12-06 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-07 04:20:58 | Crawford, Georgia, US | |
2415664 | 2415664 | 2022-12-05 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-06 04:21:03 | Crawford, Georgia, US | |
719272 | 719272 | 2022-12-04 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-05 04:20:58 | Crawford, Georgia, US | |
2817561 | 2817561 | 2022-12-03 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-04 04:20:56 | Crawford, Georgia, US | |
834417 | 834417 | 2022-12-02 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-03 04:21:02 | Crawford, Georgia, US | |
2136947 | 2136947 | 2022-12-01 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-02 04:21:07 | Crawford, Georgia, US | |
1965363 | 1965363 | 2022-11-30 | US | Georgia | Crawford | 13079 | 2114 | 63 | 0 | 32.71391813 | -83.98061238 | 2022-12-01 04:21:03 | Crawford, Georgia, US | |
293242 | 293242 | 2022-11-15 | US | Iowa | Monroe | 19135 | 2114 | 52 | 0 | 41.02988815 | -92.8690667 | 2022-11-16 04:21:09 | Monroe, Iowa, US | |
3598272 | 3598272 | 2022-11-14 | US | Iowa | Monroe | 19135 | 2114 | 52 | 0 | 41.02988815 | -92.8690667 | 2022-11-15 04:21:16 | Monroe, Iowa, US | |
313130 | 313130 | 2022-11-13 | US | Iowa | Monroe | 19135 | 2114 | 52 | 0 | 41.02988815 | -92.8690667 | 2022-11-14 04:21:09 | Monroe, Iowa, US | |
64291 | 64291 | 2022-11-12 | US | Iowa | Monroe | 19135 | 2114 | 52 | 0 | 41.02988815 | -92.8690667 | 2022-11-13 04:21:14 | Monroe, Iowa, US | |
2928453 | 2928453 | 2022-11-11 | US | Iowa | Monroe | 19135 | 2114 | 52 | 0 | 41.02988815 | -92.8690667 | 2022-11-12 04:20:41 | Monroe, Iowa, US | |
2507289 | 2507289 | 2022-11-10 | US | Iowa | Monroe | 19135 | 2114 | 52 | 0 | 41.02988815 | -92.8690667 | 2022-11-11 04:21:22 | Monroe, Iowa, US | |
2432164 | 2432164 | 2022-11-09 | US | Iowa | Monroe | 19135 | 2114 | 52 | 0 | 41.02988815 | -92.8690667 | 2022-11-10 04:21:16 | Monroe, Iowa, US | |
3995272 | 3995272 | 2022-09-27 | US | Colorado | Lake | 8065 | 2114 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-09-28 04:23:01 | Lake, Colorado, US | |
253924 | 253924 | 2022-09-08 | US | Colorado | Conejos | 8021 | 2114 | 57 | 0 | 37.201606 | -106.1917488 | 2022-09-09 04:21:11 | Conejos, Colorado, US | |
1253628 | 1253628 | 2022-08-23 | US | South Dakota | Fall River | 46047 | 2114 | 40 | 0 | 43.23929297 | -103.5275691 | 2022-08-24 04:20:46 | Fall River, South Dakota, US | |
2856477 | 2856477 | 2022-08-22 | US | Wyoming | Platte | 56031 | 2114 | 42 | 0 | 42.13299116 | -104.966331 | 2022-08-23 04:20:56 | Platte, Wyoming, US | |
2855732 | 2855732 | 2022-08-22 | US | South Dakota | Fall River | 46047 | 2114 | 40 | 0 | 43.23929297 | -103.5275691 | 2022-08-23 04:20:56 | Fall River, South Dakota, US | |
2406449 | 2406449 | 2022-08-21 | US | Wyoming | Platte | 56031 | 2114 | 42 | 0 | 42.13299116 | -104.966331 | 2022-08-22 04:20:38 | Platte, Wyoming, US | |
2405704 | 2405704 | 2022-08-21 | US | South Dakota | Fall River | 46047 | 2114 | 40 | 0 | 43.23929297 | -103.5275691 | 2022-08-22 04:20:38 | Fall River, South Dakota, US | |
3801527 | 3801527 | 2022-08-20 | US | Wyoming | Platte | 56031 | 2114 | 42 | 0 | 42.13299116 | -104.966331 | 2022-08-21 04:20:44 | Platte, Wyoming, US | |
3800782 | 3800782 | 2022-08-20 | US | South Dakota | Fall River | 46047 | 2114 | 40 | 0 | 43.23929297 | -103.5275691 | 2022-08-21 04:20:44 | Fall River, South Dakota, US | |
2367113 | 2367113 | 2022-08-19 | US | Wyoming | Platte | 56031 | 2114 | 42 | 0 | 42.13299116 | -104.966331 | 2022-08-20 04:21:01 | Platte, Wyoming, US | |
2366368 | 2366368 | 2022-08-19 | US | South Dakota | Fall River | 46047 | 2114 | 40 | 0 | 43.23929297 | -103.5275691 | 2022-08-20 04:21:01 | Fall River, South Dakota, US | |
1164784 | 1164784 | 2022-08-18 | US | Wyoming | Platte | 56031 | 2114 | 42 | 0 | 42.13299116 | -104.966331 | 2022-08-19 04:20:54 | Platte, Wyoming, US | |
1164039 | 1164039 | 2022-08-18 | US | South Dakota | Fall River | 46047 | 2114 | 40 | 0 | 43.23929297 | -103.5275691 | 2022-08-19 04:20:54 | Fall River, South Dakota, US | |
3954108 | 3954108 | 2022-08-17 | US | Wyoming | Platte | 56031 | 2114 | 42 | 0 | 42.13299116 | -104.966331 | 2022-08-18 04:21:11 | Platte, Wyoming, US | |
3953363 | 3953363 | 2022-08-17 | US | South Dakota | Fall River | 46047 | 2114 | 40 | 0 | 43.23929297 | -103.5275691 | 2022-08-18 04:21:11 | Fall River, South Dakota, US | |
994610 | 994610 | 2022-08-16 | US | Wyoming | Platte | 56031 | 2114 | 42 | 0 | 42.13299116 | -104.966331 | 2022-08-17 04:20:59 | Platte, Wyoming, US | |
3544012 | 3544012 | 2022-08-08 | US | Arkansas | Prairie | 5117 | 2114 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-08-09 04:20:34 | Prairie, Arkansas, US | |
1070415 | 1070415 | 2022-08-07 | US | Arkansas | Prairie | 5117 | 2114 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-08-08 04:21:08 | Prairie, Arkansas, US | |
3872709 | 3872709 | 2022-07-31 | US | Indiana | Union | 18161 | 2114 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-08-01 04:21:03 | Union, Indiana, US | |
675463 | 675463 | 2022-07-30 | US | Indiana | Union | 18161 | 2114 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-07-31 04:21:02 | Union, Indiana, US | |
1784662 | 1784662 | 2022-07-29 | US | Indiana | Union | 18161 | 2114 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-07-30 04:20:42 | Union, Indiana, US | |
1066578 | 1066578 | 2022-07-28 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-29 04:20:45 | Glades, Florida, US | |
2336097 | 2336097 | 2022-07-27 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-28 04:20:56 | Glades, Florida, US | |
1488287 | 1488287 | 2022-07-26 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-27 04:21:04 | Glades, Florida, US | |
2594733 | 2594733 | 2022-07-25 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-26 04:20:58 | Glades, Florida, US | |
896848 | 896848 | 2022-07-24 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-25 04:20:51 | Glades, Florida, US | |
91842 | 91842 | 2022-07-23 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-24 04:20:47 | Glades, Florida, US | |
900864 | 900864 | 2022-07-22 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-23 04:20:53 | Glades, Florida, US | |
671000 | 671000 | 2022-07-21 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-22 04:21:15 | Glades, Florida, US | |
1608963 | 1608963 | 2022-07-20 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-21 04:21:10 | Glades, Florida, US | |
959596 | 959596 | 2022-07-19 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-20 04:20:59 | Glades, Florida, US | |
3213231 | 3213231 | 2022-07-18 | US | Tennessee | Hancock | 47067 | 2114 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-07-19 04:20:58 | Hancock, Tennessee, US | |
3210983 | 3210983 | 2022-07-18 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-19 04:20:58 | Glades, Florida, US | |
3408406 | 3408406 | 2022-07-17 | US | Tennessee | Hancock | 47067 | 2114 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-07-18 04:20:59 | Hancock, Tennessee, US | |
3406158 | 3406158 | 2022-07-17 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-18 04:20:59 | Glades, Florida, US | |
2152358 | 2152358 | 2022-07-16 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-17 04:21:15 | Glades, Florida, US | |
2419591 | 2419591 | 2022-07-15 | US | Florida | Glades | 12043 | 2114 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-07-16 04:21:05 | Glades, Florida, US | |
2789391 | 2789391 | 2022-07-10 | US | Alabama | Choctaw | 1023 | 2114 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-07-11 04:20:46 | Choctaw, Alabama, US | |
142344 | 142344 | 2022-07-09 | US | Alabama | Choctaw | 1023 | 2114 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-07-10 04:20:54 | Choctaw, Alabama, US | |
1417444 | 1417444 | 2022-07-08 | US | Alabama | Choctaw | 1023 | 2114 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-07-09 04:20:59 | Choctaw, Alabama, US | |
1202015 | 1202015 | 2022-07-06 | US | New Mexico | Quay | 35037 | 2114 | 58 | 0 | 35.10403332 | -103.5481727 | 2022-07-07 04:20:55 | Quay, New Mexico, US | |
2149389 | 2149389 | 2022-06-27 | US | Minnesota | Murray | 27101 | 2114 | 19 | 0 | 44.02216709 | -95.76328482 | 2022-06-28 04:20:58 | Murray, Minnesota, US | |
167257 | 167257 | 2022-06-21 | US | Iowa | Keokuk | 19107 | 2114 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-22 04:20:54 | Keokuk, Iowa, US | |
1764540 | 1764540 | 2022-06-20 | US | Iowa | Keokuk | 19107 | 2114 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-21 04:20:56 | Keokuk, Iowa, US | |
3270726 | 3270726 | 2022-06-19 | US | Iowa | Keokuk | 19107 | 2114 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-20 04:21:01 | Keokuk, Iowa, US | |
3398638 | 3398638 | 2022-06-18 | US | Iowa | Keokuk | 19107 | 2114 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-19 04:20:51 | Keokuk, Iowa, US | |
2312515 | 2312515 | 2022-06-17 | US | Iowa | Keokuk | 19107 | 2114 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-18 04:21:10 | Keokuk, Iowa, US | |
560019 | 560019 | 2022-06-16 | US | Iowa | Keokuk | 19107 | 2114 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-17 04:20:56 | Keokuk, Iowa, US | |
3983821 | 3983821 | 2022-06-15 | US | Iowa | Keokuk | 19107 | 2114 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-16 04:20:55 | Keokuk, Iowa, US | |
3727834 | 3727834 | 2022-06-07 | US | Michigan | Baraga | 26013 | 2114 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-08 04:20:55 | Baraga, Michigan, US | |
3889236 | 3889236 | 2022-06-06 | US | Michigan | Baraga | 26013 | 2114 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-07 04:21:08 | Baraga, Michigan, US | |
3509005 | 3509005 | 2022-06-05 | US | Michigan | Baraga | 26013 | 2114 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-06 04:20:57 | Baraga, Michigan, US | |
3529082 | 3529082 | 2022-06-04 | US | Michigan | Baraga | 26013 | 2114 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-05 04:20:55 | Baraga, Michigan, US | |
3135168 | 3135168 | 2022-06-03 | US | Michigan | Baraga | 26013 | 2114 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-04 04:20:58 | Baraga, Michigan, US | |
3580243 | 3580243 | 2022-06-02 | US | Michigan | Baraga | 26013 | 2114 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-03 04:20:58 | Baraga, Michigan, US | |
972536 | 972536 | 2022-06-01 | US | Michigan | Baraga | 26013 | 2114 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-02 05:20:39 | Baraga, Michigan, US | |
1110502 | 1110502 | 2022-05-21 | US | Idaho | Boundary | 16021 | 2114 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-22 04:20:52 | Boundary, Idaho, US | |
1170126 | 1170126 | 2022-05-20 | US | Idaho | Boundary | 16021 | 2114 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-21 04:20:58 | Boundary, Idaho, US | |
1186274 | 1186274 | 2022-05-18 | US | Louisiana | Red River | 22081 | 2114 | 53 | 0 | 32.09530039 | -93.34213308 | 2022-05-19 04:20:54 | Red River, Louisiana, US | |
1575360 | 1575360 | 2022-05-03 | US | Texas | Somervell | 48425 | 2114 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-04 04:20:59 | Somervell, Texas, US | |
466620 | 466620 | 2022-05-02 | US | Texas | Somervell | 48425 | 2114 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-03 04:21:00 | Somervell, Texas, US | |
3919259 | 3919259 | 2022-05-01 | US | Texas | Somervell | 48425 | 2114 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-02 04:21:10 | Somervell, Texas, US | |
2844063 | 2844063 | 2022-04-30 | US | Texas | Somervell | 48425 | 2114 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-01 04:20:57 | Somervell, Texas, US | |
746159 | 746159 | 2022-04-23 | China | Yunnan | 2114 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-24 04:20:56 | Yunnan, China | |||
2892940 | 2892940 | 2022-04-21 | US | Arkansas | Searcy | 5129 | 2114 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-04-22 04:20:45 | Searcy, Arkansas, US | |
877641 | 877641 | 2022-03-27 | US | Kentucky | Bracken | 21023 | 2114 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-28 04:20:33 | Bracken, Kentucky, US | |
2164924 | 2164924 | 2022-03-26 | US | Kentucky | Bracken | 21023 | 2114 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-27 04:20:47 | Bracken, Kentucky, US | |
1721860 | 1721860 | 2022-03-25 | US | Kentucky | Bracken | 21023 | 2114 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-26 04:20:23 | Bracken, Kentucky, US | |
1469477 | 1469477 | 2022-03-24 | US | Kentucky | Bracken | 21023 | 2114 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-25 04:20:46 | Bracken, Kentucky, US | |
3023651 | 3023651 | 2022-03-23 | US | Kentucky | Bracken | 21023 | 2114 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-24 04:20:43 | Bracken, Kentucky, US | |
1906573 | 1906573 | 2022-03-22 | US | Kentucky | Bracken | 21023 | 2114 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-23 04:20:48 | Bracken, Kentucky, US | |
3239704 | 3239704 | 2022-03-21 | US | Kentucky | Bracken | 21023 | 2114 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-22 04:20:54 | Bracken, Kentucky, US | |
27114 | 27114 | 2022-03-20 | US | Puerto Rico | Adjuntas | 72001 | 2114 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-03-21 04:20:50 | Adjuntas, Puerto Rico, US | |
1659124 | 1659124 | 2022-03-19 | US | Puerto Rico | Adjuntas | 72001 | 2114 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-03-20 04:20:45 | Adjuntas, Puerto Rico, US | |
950658 | 950658 | 2022-03-12 | China | Heilongjiang | 2114 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-03-13 04:20:49 | Heilongjiang, China | |||
2526206 | 2526206 | 2022-03-02 | US | Georgia | Macon | 13193 | 2114 | 48 | 0 | 32.35207048 | -84.04234127 | 2022-03-03 04:21:01 | Macon, Georgia, US | |
1299780 | 1299780 | 2022-02-17 | US | Minnesota | Jackson | 27063 | 2114 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-02-18 04:21:04 | Jackson, Minnesota, US | |
3674812 | 3674812 | 2022-02-15 | US | Texas | Live Oak | 48297 | 2114 | 40 | 0 | 28.35101362 | -98.1246786 | 2022-02-16 04:21:10 | Live Oak, Texas, US | |
2645136 | 2645136 | 2022-02-14 | US | Virginia | Northampton | 51131 | 2114 | 53 | 0 | 37.34062933 | -75.87751591 | 2022-02-15 04:21:09 | Northampton, Virginia, US | |
185827 | 185827 | 2022-02-13 | Canada | Nunavut | 2114 | 5 | 0 | 70.2998 | -83.1076 | 2022-02-14 04:20:51 | Nunavut, Canada | |||
315673 | 315673 | 2022-02-12 | Canada | Nunavut | 2114 | 5 | 0 | 70.2998 | -83.1076 | 2022-02-13 04:21:00 | Nunavut, Canada | |||
232999 | 232999 | 2022-02-11 | Canada | Nunavut | 2114 | 5 | 0 | 70.2998 | -83.1076 | 2022-02-12 04:21:06 | Nunavut, Canada | |||
1364434 | 1364434 | 2022-02-08 | US | Nebraska | Hamilton | 31081 | 2114 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-09 04:21:04 | Hamilton, Nebraska, US | |
1364171 | 1364171 | 2022-02-08 | US | Mississippi | Kemper | 28069 | 2114 | 45 | 0 | 32.75462946 | -88.64105766 | 2022-02-09 04:21:04 | Kemper, Mississippi, US | |
1363756 | 1363756 | 2022-02-08 | US | Kentucky | Gallatin | 21077 | 2114 | 45 | 0 | 38.75398691 | -84.8558382 | 2022-02-09 04:21:04 | Gallatin, Kentucky, 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]);