johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
267 rows where confirmed = 2870 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3026898 | 3026898 | 2022-11-17 | US | Colorado | Bent | 8011 | 2870 | 49 | 0 | 37.95474293 | -103.0720195 | 2022-11-18 04:21:15 | Bent, Colorado, US | |
850118 | 850118 | 2022-11-02 | US | Arkansas | Perry | 5105 | 2870 | 41 | 0 | 34.9459153 | -92.94372564 | 2022-11-03 04:22:05 | Perry, Arkansas, US | |
320451 | 320451 | 2022-10-30 | US | Arkansas | Perry | 5105 | 2870 | 41 | 0 | 34.9459153 | -92.94372564 | 2022-10-31 04:21:36 | Perry, Arkansas, US | |
2772338 | 2772338 | 2022-09-26 | US | Virginia | Madison | 51113 | 2870 | 44 | 0 | 38.41531222 | -78.28220331 | 2022-09-27 04:23:01 | Madison, Virginia, US | |
2017799 | 2017799 | 2022-09-20 | US | Indiana | Brown | 18013 | 2870 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-21 04:23:22 | Brown, Indiana, US | |
2017399 | 2017399 | 2022-09-20 | US | Connecticut | Unassigned | 90009 | 2870 | 8 | 0 | 41.85853803 | 0.0 | 2022-09-21 04:23:22 | Unassigned, Connecticut, US | |
3571672 | 3571672 | 2022-09-19 | US | Indiana | Brown | 18013 | 2870 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-20 04:22:48 | Brown, Indiana, US | |
420411 | 420411 | 2022-09-18 | US | Indiana | Brown | 18013 | 2870 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-19 04:21:49 | Brown, Indiana, US | |
3374435 | 3374435 | 2022-09-17 | US | Indiana | Brown | 18013 | 2870 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-18 04:22:50 | Brown, Indiana, US | |
2356543 | 2356543 | 2022-09-16 | US | Indiana | Brown | 18013 | 2870 | 63 | 0 | 39.19605589 | -86.22868909 | 2022-09-17 04:20:19 | Brown, Indiana, US | |
115956 | 115956 | 2022-09-06 | US | Iowa | Humboldt | 19091 | 2870 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-09-07 04:20:59 | Humboldt, Iowa, US | |
2634928 | 2634928 | 2022-09-05 | US | Iowa | Humboldt | 19091 | 2870 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-09-06 04:21:02 | Humboldt, Iowa, US | |
2988492 | 2988492 | 2022-09-04 | US | Iowa | Humboldt | 19091 | 2870 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-09-05 04:21:01 | Humboldt, Iowa, US | |
2714177 | 2714177 | 2022-09-03 | US | Iowa | Humboldt | 19091 | 2870 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-09-04 04:21:22 | Humboldt, Iowa, US | |
1394882 | 1394882 | 2022-09-02 | US | Iowa | Humboldt | 19091 | 2870 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-09-03 04:21:04 | Humboldt, Iowa, US | |
3548711 | 3548711 | 2022-09-01 | US | Iowa | Humboldt | 19091 | 2870 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-09-02 04:21:07 | Humboldt, Iowa, US | |
2344631 | 2344631 | 2022-08-31 | US | Iowa | Humboldt | 19091 | 2870 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-09-01 04:21:03 | Humboldt, Iowa, US | |
991871 | 991871 | 2022-08-16 | US | Georgia | Stewart | 13259 | 2870 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-08-17 04:20:59 | Stewart, Georgia, US | |
2494910 | 2494910 | 2022-08-15 | US | Georgia | Stewart | 13259 | 2870 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-08-16 04:20:58 | Stewart, Georgia, US | |
3648460 | 3648460 | 2022-08-14 | US | Georgia | Stewart | 13259 | 2870 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-08-15 04:20:59 | Stewart, Georgia, US | |
1969466 | 1969466 | 2022-08-13 | US | Georgia | Stewart | 13259 | 2870 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-08-14 04:20:55 | Stewart, Georgia, US | |
1969077 | 1969077 | 2022-08-13 | US | Arkansas | Fulton | 5049 | 2870 | 95 | 0 | 36.38177105 | -91.81729127 | 2022-08-14 04:20:55 | Fulton, Arkansas, US | |
2889275 | 2889275 | 2022-08-12 | US | Georgia | Stewart | 13259 | 2870 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-08-13 04:20:52 | Stewart, Georgia, US | |
3908880 | 3908880 | 2022-08-11 | US | Georgia | Stewart | 13259 | 2870 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-08-12 04:20:54 | Stewart, Georgia, US | |
1347197 | 1347197 | 2022-08-10 | US | Georgia | Stewart | 13259 | 2870 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-08-11 04:20:49 | Stewart, Georgia, US | |
1085882 | 1085882 | 2022-08-09 | China | Shandong | 2870 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-10 04:20:57 | Shandong, China | |||
959367 | 959367 | 2022-07-19 | US | Arkansas | Chicot | 5017 | 2870 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-07-20 04:20:59 | Chicot, Arkansas, US | |
3081312 | 3081312 | 2022-07-04 | US | Texas | Ward | 48475 | 2870 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-07-05 04:20:45 | Ward, Texas, US | |
1770594 | 1770594 | 2022-07-03 | US | Texas | Ward | 48475 | 2870 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-07-04 04:20:54 | Ward, Texas, US | |
3368580 | 3368580 | 2022-07-02 | US | Texas | Ward | 48475 | 2870 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-07-03 04:20:59 | Ward, Texas, US | |
596909 | 596909 | 2022-07-01 | US | Texas | Ward | 48475 | 2870 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-07-02 04:21:16 | Ward, Texas, US | |
3580500 | 3580500 | 2022-06-02 | US | Missouri | Barton | 29011 | 2870 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-03 04:20:58 | Barton, Missouri, US | |
972793 | 972793 | 2022-06-01 | US | Missouri | Barton | 29011 | 2870 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-02 05:20:39 | Barton, Missouri, US | |
231100 | 231100 | 2022-05-31 | US | Missouri | Barton | 29011 | 2870 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-06-01 04:20:55 | Barton, Missouri, US | |
3187865 | 3187865 | 2022-05-30 | US | Missouri | Barton | 29011 | 2870 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-31 04:20:51 | Barton, Missouri, US | |
3200014 | 3200014 | 2022-05-29 | US | Missouri | Barton | 29011 | 2870 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-30 04:20:50 | Barton, Missouri, US | |
2726892 | 2726892 | 2022-05-28 | US | Missouri | Barton | 29011 | 2870 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-29 04:20:53 | Barton, Missouri, US | |
1316073 | 1316073 | 2022-05-27 | US | Missouri | Barton | 29011 | 2870 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-05-28 04:21:07 | Barton, Missouri, US | |
1185108 | 1185108 | 2022-05-18 | US | Alabama | Conecuh | 1035 | 2870 | 70 | 0 | 31.43401703 | -86.99320044 | 2022-05-19 04:20:54 | Conecuh, Alabama, US | |
3583005 | 3583005 | 2022-05-17 | US | Alabama | Conecuh | 1035 | 2870 | 70 | 0 | 31.43401703 | -86.99320044 | 2022-05-18 04:20:50 | Conecuh, Alabama, US | |
1503962 | 1503962 | 2022-05-16 | US | Alabama | Conecuh | 1035 | 2870 | 70 | 0 | 31.43401703 | -86.99320044 | 2022-05-17 04:20:59 | Conecuh, Alabama, US | |
2536130 | 2536130 | 2022-05-12 | US | Puerto Rico | Ciales | 72039 | 2870 | 0 | 0 | 18.28885 | -66.516475 | 2022-05-13 04:20:51 | Ciales, Puerto Rico, US | |
3538503 | 3538503 | 2022-05-10 | US | Texas | Camp | 48063 | 2870 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-05-11 04:20:48 | Camp, Texas, US | |
225038 | 225038 | 2022-05-09 | US | Texas | Camp | 48063 | 2870 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-05-10 04:20:50 | Camp, Texas, US | |
2334423 | 2334423 | 2022-05-08 | US | Texas | Camp | 48063 | 2870 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-05-09 04:20:54 | Camp, Texas, US | |
3722854 | 3722854 | 2022-04-25 | US | Colorado | Rio Grande | 8105 | 2870 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-04-26 04:20:51 | Rio Grande, Colorado, US | |
2203086 | 2203086 | 2022-03-06 | US | Washington | Jefferson | 53031 | 2870 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-07 04:20:47 | Jefferson, Washington, US | |
2095543 | 2095543 | 2022-03-05 | US | Washington | Jefferson | 53031 | 2870 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-06 04:20:49 | Jefferson, Washington, US | |
2669243 | 2669243 | 2022-03-04 | US | Washington | Jefferson | 53031 | 2870 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-05 04:21:10 | Jefferson, Washington, US | |
2734692 | 2734692 | 2022-02-27 | US | Michigan | Missaukee | 26113 | 2870 | 59 | 0 | 44.33772443 | -85.09256478 | 2022-02-28 04:21:05 | Missaukee, Michigan, US | |
3047845 | 3047845 | 2022-02-26 | US | Michigan | Missaukee | 26113 | 2870 | 59 | 0 | 44.33772443 | -85.09256478 | 2022-02-27 04:21:04 | Missaukee, Michigan, US | |
576500 | 576500 | 2022-02-25 | US | Michigan | Missaukee | 26113 | 2870 | 59 | 0 | 44.33772443 | -85.09256478 | 2022-02-26 04:21:12 | Missaukee, Michigan, US | |
3858356 | 3858356 | 2022-02-18 | US | Ohio | Vinton | 39163 | 2870 | 56 | 0 | 39.25208988 | -82.4831444 | 2022-02-19 04:21:11 | Vinton, Ohio, US | |
3672015 | 3672015 | 2022-02-15 | US | Alabama | Coosa | 1037 | 2870 | 53 | 0 | 32.93690146 | -86.24847739 | 2022-02-16 04:21:10 | Coosa, Alabama, US | |
3074692 | 3074692 | 2022-02-09 | US | Colorado | Park | 8093 | 2870 | 20 | 0 | 39.120926000000004 | -105.7182065 | 2022-02-10 04:21:14 | Park, Colorado, US | |
979830 | 979830 | 2022-02-01 | US | Georgia | Telfair | 13271 | 2870 | 76 | 0 | 31.92829517 | -82.93491155 | 2022-02-02 04:21:09 | Telfair, Georgia, US | |
3064956 | 3064956 | 2022-01-29 | US | Tennessee | Jackson | 47087 | 2870 | 51 | 0 | 36.36380466 | -85.67239905 | 2022-01-30 04:21:26 | Jackson, Tennessee, US | |
1780971 | 1780971 | 2022-01-27 | US | Maryland | Kent | 24029 | 2870 | 62 | 0 | 39.24976208 | -76.04741541 | 2022-01-28 04:21:09 | Kent, Maryland, US | |
3229224 | 3229224 | 2022-01-19 | US | Puerto Rico | Quebradillas | 72115 | 2870 | 0 | 0 | 18.439692 | -66.926113 | 2022-01-20 04:21:07 | Quebradillas, Puerto Rico, US | |
3690415 | 3690415 | 2022-01-13 | US | Tennessee | Decatur | 47039 | 2870 | 49 | 0 | 35.60048904 | -88.11043779 | 2022-01-14 04:21:54 | Decatur, Tennessee, US | |
3689839 | 3689839 | 2022-01-13 | US | North Carolina | Polk | 37149 | 2870 | 49 | 0 | 35.27820615 | -82.16812354 | 2022-01-14 04:21:54 | Polk, North Carolina, US | |
1436131 | 1436131 | 2021-12-28 | US | Wisconsin | Marquette | 55077 | 2870 | 38 | 0 | 43.81911946 | -89.40073763 | 2021-12-29 03:21:43 | Marquette, Wisconsin, US | |
1081447 | 1081447 | 2021-12-09 | US | West Virginia | Wetzel | 54103 | 2870 | 65 | 0 | 39.6065771 | -80.64016540000001 | 2021-12-10 04:22:28 | Wetzel, West Virginia, US | |
553857 | 553857 | 2021-12-08 | US | Texas | Falls | 48145 | 2870 | 50 | 0 | 31.25350609 | -96.93630086 | 2021-12-09 04:22:49 | Falls, Texas, US | |
407377 | 407377 | 2021-12-07 | US | Texas | Falls | 48145 | 2870 | 50 | 0 | 31.25350609 | -96.93630086 | 2021-12-08 04:22:46 | Falls, Texas, US | |
1147218 | 1147218 | 2021-12-01 | US | North Carolina | Avery | 37011 | 2870 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-02 04:22:37 | Avery, North Carolina, US | |
1147144 | 1147144 | 2021-12-01 | US | New Mexico | Taos | 35055 | 2870 | 71 | 0 | 36.58006022 | -105.63101979999999 | 2021-12-02 04:22:37 | Taos, New Mexico, US | |
1232702 | 1232702 | 2021-11-28 | US | Indiana | Carroll | 18015 | 2870 | 37 | 0 | 40.580783200000006 | -86.56198812 | 2021-11-29 04:22:30 | Carroll, Indiana, US | |
1359409 | 1359409 | 2021-11-27 | US | Indiana | Carroll | 18015 | 2870 | 37 | 0 | 40.580783200000006 | -86.56198812 | 2021-11-28 04:22:43 | Carroll, Indiana, US | |
759400 | 759400 | 2021-11-26 | US | Indiana | Carroll | 18015 | 2870 | 37 | 0 | 40.580783200000006 | -86.56198812 | 2021-11-27 04:22:45 | Carroll, Indiana, US | |
1803817 | 1803817 | 2021-11-25 | US | Indiana | Carroll | 18015 | 2870 | 37 | 0 | 40.580783200000006 | -86.56198812 | 2021-11-26 04:22:33 | Carroll, Indiana, US | |
905251 | 905251 | 2021-11-24 | US | Indiana | Carroll | 18015 | 2870 | 37 | 0 | 40.580783200000006 | -86.56198812 | 2021-11-25 04:22:33 | Carroll, Indiana, US | |
3750186 | 3750186 | 2021-11-22 | US | Illinois | White | 17193 | 2870 | 33 | 0 | 38.08706198 | -88.17657461 | 2021-11-23 04:22:39 | White, Illinois, US | |
1016569 | 1016569 | 2021-11-21 | US | New York | Essex | 36031 | 2870 | 37 | 0 | 44.11630765 | -73.77297842 | 2021-11-22 04:22:20 | Essex, New York, US | |
3343559 | 3343559 | 2021-11-16 | US | Idaho | Gem | 16045 | 2870 | 67 | 0 | 44.06482372 | -116.398376 | 2021-11-17 04:21:48 | Gem, Idaho, US | |
90208 | 90208 | 2021-11-09 | US | Texas | Falls | 48145 | 2870 | 48 | 0 | 31.25350609 | -96.93630086 | 2021-11-10 04:21:38 | Falls, Texas, US | |
3641882 | 3641882 | 2021-11-08 | US | North Carolina | Hertford | 37091 | 2870 | 72 | 0 | 36.3607755 | -76.98104134 | 2021-11-09 04:21:36 | Hertford, North Carolina, US | |
2003744 | 2003744 | 2021-11-07 | US | Texas | Falls | 48145 | 2870 | 48 | 0 | 31.25350609 | -96.93630086 | 2021-11-08 04:21:43 | Falls, Texas, US | |
498735 | 498735 | 2021-11-06 | US | Texas | Falls | 48145 | 2870 | 48 | 0 | 31.25350609 | -96.93630086 | 2021-11-07 04:21:53 | Falls, Texas, US | |
45599 | 45599 | 2021-11-02 | US | Missouri | Clinton | 29049 | 2870 | 77 | 0 | 39.6013098 | -94.40465394 | 2021-11-03 06:22:09 | Clinton, Missouri, US | |
3794382 | 3794382 | 2021-10-25 | US | Arkansas | Grant | 5053 | 2870 | 48 | 0 | 34.29017991 | -92.42320562 | 2021-10-26 04:22:09 | Grant, Arkansas, US | |
3794377 | 3794377 | 2021-10-25 | US | Arkansas | Drew | 5043 | 2870 | 54 | 0 | 33.59035001 | -91.71777921 | 2021-10-26 04:22:09 | Drew, Arkansas, US | |
684764 | 684764 | 2021-10-24 | US | North Dakota | Rolette | 38079 | 2870 | 32 | 0 | 48.77245354 | -99.84097493 | 2021-10-25 04:22:31 | Rolette, North Dakota, US | |
682828 | 682828 | 2021-10-24 | US | Arkansas | Grant | 5053 | 2870 | 48 | 0 | 34.29017991 | -92.42320562 | 2021-10-25 04:22:31 | Grant, Arkansas, US | |
682823 | 682823 | 2021-10-24 | US | Arkansas | Drew | 5043 | 2870 | 54 | 0 | 33.59035001 | -91.71777921 | 2021-10-25 04:22:31 | Drew, Arkansas, US | |
770836 | 770836 | 2021-10-23 | US | Arkansas | Grant | 5053 | 2870 | 48 | 0 | 34.29017991 | -92.42320562 | 2021-10-24 04:21:22 | Grant, Arkansas, US | |
770831 | 770831 | 2021-10-23 | US | Arkansas | Drew | 5043 | 2870 | 54 | 0 | 33.59035001 | -91.71777921 | 2021-10-24 04:21:22 | Drew, Arkansas, US | |
657491 | 657491 | 2021-10-22 | US | West Virginia | McDowell | 54047 | 2870 | 47 | 0 | 37.38002939 | -81.65083669 | 2021-10-23 04:21:32 | McDowell, West Virginia, US | |
654478 | 654478 | 2021-10-22 | US | Arkansas | Drew | 5043 | 2870 | 54 | 0 | 33.59035001 | -91.71777921 | 2021-10-23 04:21:32 | Drew, Arkansas, US | |
2944836 | 2944836 | 2021-10-15 | US | Kentucky | Wayne | 21231 | 2870 | 55 | 0 | 36.80310688 | -84.8251971 | 2021-10-16 04:21:15 | Wayne, Kentucky, US | |
637317 | 637317 | 2021-10-13 | US | Virginia | Prince Edward | 51147 | 2870 | 50 | 0 | 37.22554789 | -78.43597949 | 2021-10-14 04:21:29 | Prince Edward, Virginia, US | |
3836074 | 3836074 | 2021-10-05 | US | Wisconsin | Vilas | 55125 | 2870 | 50 | 0 | 46.05467334 | -89.51719204 | 2021-10-06 04:21:33 | Vilas, Wisconsin, US | |
2077737 | 2077737 | 2021-09-26 | US | Mississippi | Chickasaw | 28017 | 2870 | 65 | 0 | 33.91983202 | -88.9481545 | 2021-09-27 04:21:16 | Chickasaw, Mississippi, US | |
2077411 | 2077411 | 2021-09-26 | US | Kentucky | Rockcastle | 21203 | 2870 | 25 | 0 | 37.36642393 | -84.31176452 | 2021-09-27 04:21:16 | Rockcastle, Kentucky, US | |
1726289 | 1726289 | 2021-09-25 | US | Mississippi | Chickasaw | 28017 | 2870 | 65 | 0 | 33.91983202 | -88.9481545 | 2021-09-26 04:21:29 | Chickasaw, Mississippi, US | |
1923009 | 1923009 | 2021-09-24 | US | Mississippi | Chickasaw | 28017 | 2870 | 65 | 0 | 33.91983202 | -88.9481545 | 2021-09-25 04:21:31 | Chickasaw, Mississippi, US | |
1922590 | 1922590 | 2021-09-24 | US | Kentucky | Bourbon | 21017 | 2870 | 24 | 0 | 38.2054607 | -84.21827874 | 2021-09-25 04:21:31 | Bourbon, Kentucky, US | |
3013307 | 3013307 | 2021-09-22 | US | Missouri | Texas | 29215 | 2870 | 39 | 0 | 37.31728859 | -91.96564727 | 2021-09-23 04:21:43 | Texas, Missouri, US | |
2810298 | 2810298 | 2021-09-16 | US | Maine | Aroostook | 23003 | 2870 | 68 | 0 | 46.65926321 | -68.59841248 | 2021-09-17 04:21:46 | Aroostook, Maine, US | |
1887228 | 1887228 | 2021-09-12 | US | New York | Delaware | 36025 | 2870 | 40 | 0 | 42.19837623 | -74.96709306 | 2021-09-13 04:21:15 | Delaware, New York, 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]);