johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
133 rows where confirmed = 6220 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
488101 | 488101 | 2022-11-25 | US | Arkansas | Conway | 5029 | 6220 | 74 | 0 | 35.26205537 | -92.70506566 | 2022-11-26 04:21:11 | Conway, Arkansas, US | |
1620671 | 1620671 | 2022-11-22 | US | Alabama | Monroe | 1099 | 6220 | 85 | 0 | 31.56729412 | -87.36995001 | 2022-11-23 04:21:06 | Monroe, Alabama, US | |
3460559 | 3460559 | 2022-11-21 | US | Alabama | Monroe | 1099 | 6220 | 85 | 0 | 31.56729412 | -87.36995001 | 2022-11-22 04:20:47 | Monroe, Alabama, US | |
1640744 | 1640744 | 2022-11-20 | US | Alabama | Monroe | 1099 | 6220 | 85 | 0 | 31.56729412 | -87.36995001 | 2022-11-21 04:21:05 | Monroe, Alabama, US | |
2064301 | 2064301 | 2022-11-19 | US | Alabama | Monroe | 1099 | 6220 | 85 | 0 | 31.56729412 | -87.36995001 | 2022-11-20 04:21:08 | Monroe, Alabama, US | |
1755695 | 1755695 | 2022-11-18 | US | Alabama | Monroe | 1099 | 6220 | 85 | 0 | 31.56729412 | -87.36995001 | 2022-11-19 04:21:14 | Monroe, Alabama, US | |
3026688 | 3026688 | 2022-11-17 | US | Alabama | Monroe | 1099 | 6220 | 85 | 0 | 31.56729412 | -87.36995001 | 2022-11-18 04:21:15 | Monroe, Alabama, US | |
2489400 | 2489400 | 2022-11-16 | US | Virginia | Prince Edward | 51147 | 6220 | 82 | 0 | 37.22554789 | -78.43597949 | 2022-11-17 04:21:11 | Prince Edward, Virginia, US | |
2486399 | 2486399 | 2022-11-16 | US | Alabama | Monroe | 1099 | 6220 | 85 | 0 | 31.56729412 | -87.36995001 | 2022-11-17 04:21:11 | Monroe, Alabama, US | |
2434333 | 2434333 | 2022-11-09 | US | Virginia | Prince Edward | 51147 | 6220 | 82 | 0 | 37.22554789 | -78.43597949 | 2022-11-10 04:21:16 | Prince Edward, Virginia, US | |
712655 | 712655 | 2022-11-01 | US | New Mexico | Lincoln | 35027 | 6220 | 70 | 0 | 33.74526079 | -105.4586166 | 2022-11-02 04:22:09 | Lincoln, New Mexico, US | |
3987687 | 3987687 | 2022-09-15 | US | Illinois | Wayne | 17191 | 6220 | 89 | 0 | 38.42955355 | -88.42586459 | 2022-09-16 04:21:19 | Wayne, Illinois, US | |
3549378 | 3549378 | 2022-09-01 | US | Missouri | Audrain | 29007 | 6220 | 114 | 0 | 39.215877 | -91.84242683 | 2022-09-02 04:21:07 | Audrain, Missouri, US | |
2345298 | 2345298 | 2022-08-31 | US | Missouri | Audrain | 29007 | 6220 | 114 | 0 | 39.215877 | -91.84242683 | 2022-09-01 04:21:03 | Audrain, Missouri, US | |
3775778 | 3775778 | 2022-08-30 | US | Missouri | Audrain | 29007 | 6220 | 114 | 0 | 39.215877 | -91.84242683 | 2022-08-31 04:20:57 | Audrain, Missouri, US | |
1682374 | 1682374 | 2022-08-29 | US | Missouri | Audrain | 29007 | 6220 | 114 | 0 | 39.215877 | -91.84242683 | 2022-08-30 04:21:03 | Audrain, Missouri, US | |
1878858 | 1878858 | 2022-08-28 | US | Missouri | Audrain | 29007 | 6220 | 114 | 0 | 39.215877 | -91.84242683 | 2022-08-29 04:21:06 | Audrain, Missouri, US | |
2097985 | 2097985 | 2022-08-27 | US | Missouri | Audrain | 29007 | 6220 | 114 | 0 | 39.215877 | -91.84242683 | 2022-08-28 04:21:02 | Audrain, Missouri, US | |
1533800 | 1533800 | 2022-08-26 | US | Missouri | Audrain | 29007 | 6220 | 114 | 0 | 39.215877 | -91.84242683 | 2022-08-27 04:20:57 | Audrain, Missouri, US | |
2854527 | 2854527 | 2022-08-22 | US | Michigan | Menominee | 26109 | 6220 | 74 | 0 | 45.58038692 | -87.55370409 | 2022-08-23 04:20:56 | Menominee, Michigan, US | |
2404499 | 2404499 | 2022-08-21 | US | Michigan | Menominee | 26109 | 6220 | 74 | 0 | 45.58038692 | -87.55370409 | 2022-08-22 04:20:38 | Menominee, Michigan, US | |
3799577 | 3799577 | 2022-08-20 | US | Michigan | Menominee | 26109 | 6220 | 74 | 0 | 45.58038692 | -87.55370409 | 2022-08-21 04:20:44 | Menominee, Michigan, US | |
2365163 | 2365163 | 2022-08-19 | US | Michigan | Menominee | 26109 | 6220 | 74 | 0 | 45.58038692 | -87.55370409 | 2022-08-20 04:21:01 | Menominee, Michigan, US | |
1162834 | 1162834 | 2022-08-18 | US | Michigan | Menominee | 26109 | 6220 | 74 | 0 | 45.58038692 | -87.55370409 | 2022-08-19 04:20:54 | Menominee, Michigan, US | |
3952158 | 3952158 | 2022-08-17 | US | Michigan | Menominee | 26109 | 6220 | 74 | 0 | 45.58038692 | -87.55370409 | 2022-08-18 04:21:11 | Menominee, Michigan, US | |
992660 | 992660 | 2022-08-16 | US | Michigan | Menominee | 26109 | 6220 | 74 | 0 | 45.58038692 | -87.55370409 | 2022-08-17 04:20:59 | Menominee, Michigan, US | |
1940945 | 1940945 | 2022-08-06 | US | Arkansas | Arkansas | 5001 | 6220 | 79 | 0 | 34.29145151 | -91.37277296 | 2022-08-07 04:20:54 | Arkansas, Arkansas, US | |
3212499 | 3212499 | 2022-07-18 | US | New Mexico | Taos | 35055 | 6220 | 96 | 0 | 36.58006022 | -105.6310198 | 2022-07-19 04:20:58 | Taos, New Mexico, US | |
3110014 | 3110014 | 2022-07-13 | US | Arkansas | Sevier | 5133 | 6220 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-07-14 04:20:57 | Sevier, Arkansas, US | |
1648875 | 1648875 | 2022-06-23 | US | Arkansas | Jackson | 5067 | 6220 | 64 | 0 | 35.59802983 | -91.21494602 | 2022-06-24 04:20:58 | Jackson, Arkansas, US | |
1424205 | 1424205 | 2022-06-08 | US | Texas | Gray | 48179 | 6220 | 125 | 0 | 35.40081878 | -100.8129222 | 2022-06-09 04:20:54 | Gray, Texas, US | |
1852987 | 1852987 | 2022-05-26 | US | Tennessee | Smith | 47159 | 6220 | 85 | 0 | 36.25359775 | -85.95411046 | 2022-05-27 04:20:56 | Smith, Tennessee, US | |
1112554 | 1112554 | 2022-05-21 | US | Tennessee | Morgan | 47129 | 6220 | 87 | 0 | 36.13248031 | -84.64880098 | 2022-05-22 04:20:52 | Morgan, Tennessee, US | |
1172178 | 1172178 | 2022-05-20 | US | Tennessee | Morgan | 47129 | 6220 | 87 | 0 | 36.13248031 | -84.64880098 | 2022-05-21 04:20:58 | Morgan, Tennessee, US | |
3898941 | 3898941 | 2022-05-19 | US | Tennessee | Morgan | 47129 | 6220 | 87 | 0 | 36.13248031 | -84.64880098 | 2022-05-20 04:20:57 | Morgan, Tennessee, US | |
3585400 | 3585400 | 2022-05-17 | US | Puerto Rico | Las Piedras | 72085 | 6220 | 0 | 0 | 18.187527 | -65.869468 | 2022-05-18 04:20:50 | Las Piedras, Puerto Rico, US | |
3266475 | 3266475 | 2022-05-04 | US | Illinois | Crawford | 17033 | 6220 | 45 | 0 | 39.0032229 | -87.75954624 | 2022-05-05 04:20:55 | Crawford, Illinois, US | |
3439544 | 3439544 | 2022-04-22 | US | Puerto Rico | Aguada | 72003 | 6220 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-04-23 04:20:50 | Aguada, Puerto Rico, US | |
3206907 | 3206907 | 2022-04-11 | US | Colorado | Montezuma | 8083 | 6220 | 81 | 0 | 37.33859579 | -108.59588570000001 | 2022-04-12 04:20:49 | Montezuma, Colorado, US | |
1576793 | 1576793 | 2022-04-10 | US | Colorado | Montezuma | 8083 | 6220 | 81 | 0 | 37.33859579 | -108.59588570000001 | 2022-04-11 04:21:02 | Montezuma, Colorado, US | |
1644542 | 1644542 | 2022-03-03 | Peru | Unknown | 6220 | 369 | 0 | 2022-03-04 04:21:09 | Unknown, Peru | |||||
1994434 | 1994434 | 2022-03-01 | US | Minnesota | Unassigned | 90027 | 6220 | 180 | 0 | 48.77754106 | 0.0 | 2022-03-02 04:21:07 | Unassigned, Minnesota, US | |
1994185 | 1994185 | 2022-03-01 | US | Louisiana | Pointe Coupee | 22077 | 6220 | 89 | 0 | 30.71409502 | -91.60209535 | 2022-03-02 04:21:07 | Pointe Coupee, Louisiana, US | |
944359 | 944359 | 2022-02-28 | US | Louisiana | Pointe Coupee | 22077 | 6220 | 89 | 0 | 30.71409502 | -91.60209535 | 2022-03-01 04:21:09 | Pointe Coupee, Louisiana, US | |
2734550 | 2734550 | 2022-02-27 | US | Louisiana | Pointe Coupee | 22077 | 6220 | 89 | 0 | 30.71409502 | -91.60209535 | 2022-02-28 04:21:05 | Pointe Coupee, Louisiana, US | |
3047703 | 3047703 | 2022-02-26 | US | Louisiana | Pointe Coupee | 22077 | 6220 | 89 | 0 | 30.71409502 | -91.60209535 | 2022-02-27 04:21:04 | Pointe Coupee, Louisiana, US | |
576358 | 576358 | 2022-02-25 | US | Louisiana | Pointe Coupee | 22077 | 6220 | 89 | 0 | 30.71409502 | -91.60209535 | 2022-02-26 04:21:12 | Pointe Coupee, Louisiana, US | |
1512934 | 1512934 | 2022-02-24 | US | Louisiana | Pointe Coupee | 22077 | 6220 | 89 | 0 | 30.71409502 | -91.60209535 | 2022-02-25 04:21:11 | Pointe Coupee, Louisiana, US | |
1058724 | 1058724 | 2022-02-23 | US | Georgia | Stephens | 13257 | 6220 | 137 | 0 | 34.55151201 | -83.29405315 | 2022-02-24 04:21:14 | Stephens, Georgia, US | |
2644687 | 2644687 | 2022-02-14 | US | Tennessee | DeKalb | 47041 | 6220 | 95 | 0 | 35.97616272 | -85.83689361 | 2022-02-15 04:21:09 | DeKalb, Tennessee, US | |
1364914 | 1364914 | 2022-02-08 | US | Oklahoma | Jackson | 40065 | 6220 | 92 | 0 | 34.58781741 | -99.41138784 | 2022-02-09 04:21:04 | Jackson, Oklahoma, US | |
73652 | 73652 | 2022-02-07 | US | Oklahoma | Jackson | 40065 | 6220 | 92 | 0 | 34.58781741 | -99.41138784 | 2022-02-08 04:21:15 | Jackson, Oklahoma, US | |
2015268 | 2015268 | 2022-02-06 | US | Oklahoma | Jackson | 40065 | 6220 | 92 | 0 | 34.58781741 | -99.41138784 | 2022-02-07 04:21:05 | Jackson, Oklahoma, US | |
1296597 | 1296597 | 2022-02-05 | US | Oklahoma | Jackson | 40065 | 6220 | 92 | 0 | 34.58781741 | -99.41138784 | 2022-02-06 04:21:00 | Jackson, Oklahoma, US | |
2329925 | 2329925 | 2022-02-04 | US | Oklahoma | Jackson | 40065 | 6220 | 92 | 0 | 34.58781741 | -99.41138784 | 2022-02-05 04:21:05 | Jackson, Oklahoma, US | |
2476516 | 2476516 | 2022-02-03 | US | Oklahoma | Jackson | 40065 | 6220 | 92 | 0 | 34.58781741 | -99.41138784 | 2022-02-04 04:21:10 | Jackson, Oklahoma, US | |
2475617 | 2475617 | 2022-02-03 | US | Michigan | Mason | 26105 | 6220 | 79 | 0 | 43.99509218 | -86.24988902 | 2022-02-04 04:21:10 | Mason, Michigan, US | |
461941 | 461941 | 2022-02-02 | US | Oklahoma | Jackson | 40065 | 6220 | 92 | 0 | 34.58781741 | -99.41138784 | 2022-02-03 04:21:21 | Jackson, Oklahoma, US | |
461042 | 461042 | 2022-02-02 | US | Michigan | Mason | 26105 | 6220 | 79 | 0 | 43.99509218 | -86.24988902 | 2022-02-03 04:21:21 | Mason, Michigan, US | |
981425 | 981425 | 2022-02-01 | US | Ohio | Hocking | 39073 | 6220 | 113 | 0 | 39.49537927 | -82.47991446 | 2022-02-02 04:21:09 | Hocking, Ohio, US | |
1782341 | 1782341 | 2022-01-27 | US | Tennessee | Hickman | 47081 | 6220 | 97 | 0 | 35.80609681 | -87.47643507 | 2022-01-28 04:21:09 | Hickman, Tennessee, US | |
1231227 | 1231227 | 2022-01-24 | US | Wyoming | Park | 56029 | 6220 | 123 | 0 | 44.52157546 | -109.58528249999999 | 2022-01-25 04:21:05 | Park, Wyoming, US | |
1963851 | 1963851 | 2022-01-20 | US | Vermont | Windsor | 50027 | 6220 | 47 | 0 | 43.58010937 | -72.58595157 | 2022-01-21 04:21:09 | Windsor, Vermont, US | |
3229746 | 3229746 | 2022-01-19 | US | Vermont | Windsor | 50027 | 6220 | 47 | 0 | 43.58010937 | -72.58595157 | 2022-01-20 04:21:07 | Windsor, Vermont, US | |
3690443 | 3690443 | 2022-01-13 | US | Tennessee | Lauderdale | 47097 | 6220 | 81 | 0 | 35.75893438 | -89.63015909999999 | 2022-01-14 04:21:54 | Lauderdale, Tennessee, US | |
1114810 | 1114810 | 2022-01-11 | US | Iowa | Marion | 19125 | 6220 | 106 | 0 | 41.33445101 | -93.09934783 | 2022-01-12 04:21:44 | Marion, Iowa, US | |
1693693 | 1693693 | 2022-01-10 | US | Kentucky | Boyle | 21021 | 6220 | 118 | 0 | 37.62680923 | -84.8633779 | 2022-01-11 04:22:01 | Boyle, Kentucky, US | |
1693538 | 1693538 | 2022-01-10 | US | Iowa | Marion | 19125 | 6220 | 106 | 0 | 41.33445101 | -93.09934783 | 2022-01-11 04:22:01 | Marion, Iowa, US | |
127953 | 127953 | 2022-01-09 | US | Iowa | Marion | 19125 | 6220 | 106 | 0 | 41.33445101 | -93.09934783 | 2022-01-10 04:22:07 | Marion, Iowa, US | |
1216788 | 1216788 | 2022-01-08 | US | Iowa | Marion | 19125 | 6220 | 106 | 0 | 41.33445101 | -93.09934783 | 2022-01-09 04:21:46 | Marion, Iowa, US | |
1390881 | 1390881 | 2022-01-07 | US | Iowa | Marion | 19125 | 6220 | 106 | 0 | 41.33445101 | -93.09934783 | 2022-01-08 04:21:53 | Marion, Iowa, US | |
2611268 | 2611268 | 2022-01-06 | US | Iowa | Marion | 19125 | 6220 | 106 | 0 | 41.33445101 | -93.09934783 | 2022-01-07 04:22:09 | Marion, Iowa, US | |
1283210 | 1283210 | 2022-01-05 | US | Iowa | Marion | 19125 | 6220 | 106 | 0 | 41.33445101 | -93.09934783 | 2022-01-06 04:22:09 | Marion, Iowa, US | |
3522359 | 3522359 | 2022-01-02 | US | Tennessee | Claiborne | 47025 | 6220 | 144 | 0 | 36.48319149 | -83.65947309 | 2022-01-03 02:22:25 | Claiborne, Tennessee, US | |
798962 | 798962 | 2021-12-22 | US | Arkansas | Union | 5139 | 6220 | 150 | 0 | 33.16887091 | -92.59746952 | 2021-12-23 04:21:21 | Union, Arkansas, US | |
785251 | 785251 | 2021-12-13 | US | South Dakota | Codington | 46029 | 6220 | 90 | 0 | 44.97788119 | -97.18827677 | 2021-12-14 04:22:38 | Codington, South Dakota, US | |
2838 | 2838 | 2021-12-02 | US | Ohio | Putnam | 39137 | 6220 | 129 | 0 | 41.02094889 | -84.1336111 | 2021-12-03 04:23:05 | Putnam, Ohio, US | |
794 | 794 | 2021-12-02 | US | Arkansas | Baxter | 5005 | 6220 | 188 | 0 | 36.28784385 | -92.33782872 | 2021-12-03 04:23:05 | Baxter, Arkansas, US | |
164737 | 164737 | 2021-11-19 | US | Pennsylvania | Wayne | 42127 | 6220 | 119 | 0 | 41.64938475 | -75.29956506 | 2021-11-20 04:22:17 | Wayne, Pennsylvania, US | |
2003136 | 2003136 | 2021-11-07 | US | Ohio | Highland | 39071 | 6220 | 114 | 0 | 39.1839264 | -83.60331456 | 2021-11-08 04:21:43 | Highland, Ohio, US | |
3513145 | 3513145 | 2021-11-01 | US | Minnesota | McLeod | 27085 | 6220 | 74 | 0 | 44.82367677 | -94.27287017 | 2021-11-02 04:22:03 | McLeod, Minnesota, US | |
656241 | 656241 | 2021-10-22 | US | New York | Madison | 36053 | 6220 | 102 | 0 | 42.91653905 | -75.67266639 | 2021-10-23 04:21:32 | Madison, New York, US | |
1910329 | 1910329 | 2021-10-17 | US | Indiana | Montgomery | 18107 | 6220 | 109 | 0 | 40.04034823 | -86.89335024 | 2021-10-18 04:21:10 | Montgomery, Indiana, US | |
2962621 | 2962621 | 2021-10-08 | US | Texas | Waller | 48473 | 6220 | 72 | 0 | 30.01058447 | -95.99011759 | 2021-10-09 04:21:34 | Waller, Texas, US | |
469200 | 469200 | 2021-10-07 | US | Mississippi | Bolivar | 28011 | 6220 | 145 | 0 | 33.79696941 | -90.87372121 | 2021-10-08 04:21:25 | Bolivar, Mississippi, US | |
1336654 | 1336654 | 2021-09-28 | US | North Carolina | Watauga | 37189 | 6220 | 34 | 0 | 36.23103603 | -81.70033724 | 2021-09-29 04:21:45 | Watauga, North Carolina, US | |
2620550 | 2620550 | 2021-09-17 | US | Ohio | Seneca | 39147 | 6220 | 141 | 0 | 41.12351311 | -83.12783209 | 2021-09-18 04:21:24 | Seneca, Ohio, US | |
3106737 | 3106737 | 2021-08-24 | US | Kansas | Ford | 20057 | 6220 | 84 | 0 | 37.69200114 | -99.88825298 | 2021-08-25 04:21:41 | Ford, Kansas, US | |
104206 | 104206 | 2021-08-15 | US | Georgia | Tift | 13277 | 6220 | 137 | 0 | 31.45743864 | -83.5236119 | 2021-08-16 04:21:31 | Tift, Georgia, US | |
508564 | 508564 | 2021-08-14 | US | Georgia | Tift | 13277 | 6220 | 137 | 0 | 31.45743864 | -83.5236119 | 2021-08-15 04:21:41 | Tift, Georgia, US | |
1484436 | 1484436 | 2021-08-13 | US | Georgia | Tift | 13277 | 6220 | 137 | 0 | 31.45743864 | -83.5236119 | 2021-08-14 04:21:25 | Tift, Georgia, US | |
2353987 | 2353987 | 2021-08-10 | US | Oklahoma | Grady | 40051 | 6220 | 131 | 0 | 35.0167709 | -97.88339847 | 2021-08-11 04:21:58 | Grady, Oklahoma, US | |
652516 | 652516 | 2021-08-09 | US | Oklahoma | Grady | 40051 | 6220 | 131 | 0 | 35.0167709 | -97.88339847 | 2021-08-10 04:21:27 | Grady, Oklahoma, US | |
592178 | 592178 | 2021-08-08 | US | Oklahoma | Grady | 40051 | 6220 | 131 | 0 | 35.0167709 | -97.88339847 | 2021-08-09 04:21:24 | Grady, Oklahoma, US | |
2206190 | 2206190 | 2021-08-07 | US | Oklahoma | Grady | 40051 | 6220 | 131 | 0 | 35.0167709 | -97.88339847 | 2021-08-08 04:21:33 | Grady, Oklahoma, US | |
1120140 | 1120140 | 2021-08-06 | US | Oklahoma | Grady | 40051 | 6220 | 131 | 0 | 35.0167709 | -97.88339847 | 2021-08-07 04:21:30 | Grady, Oklahoma, US | |
1959077 | 1959077 | 2021-08-05 | US | Oklahoma | Grady | 40051 | 6220 | 131 | 0 | 35.0167709 | -97.88339847 | 2021-08-06 04:21:18 | Grady, Oklahoma, US | |
334456 | 334456 | 2021-08-04 | US | Oklahoma | Grady | 40051 | 6220 | 131 | 0 | 35.0167709 | -97.88339847 | 2021-08-05 04:21:51 | Grady, Oklahoma, US | |
3018051 | 3018051 | 2021-08-01 | US | Pennsylvania | Union | 42119 | 6220 | 90 | 0 | 40.96188846 | -77.05996014 | 2021-08-02 04:21:36 | Union, Pennsylvania, US | |
3906674 | 3906674 | 2021-07-31 | US | Pennsylvania | Union | 42119 | 6220 | 89 | 0 | 40.96188846 | -77.05996014 | 2021-08-01 04:21:50 | Union, Pennsylvania, 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]);