johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
159 rows where confirmed = 4732 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 128
- France 14
- Japan 4
- Palau 4
- Russia 4
- India 1
- Netherlands 1
- Pakistan 1
- San Marino 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219849 | 219849 | 2022-12-26 | US | Mississippi | Yalobusha | 28161 | 4732 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-12-27 04:21:07 | Yalobusha, Mississippi, US | |
3224306 | 3224306 | 2022-12-25 | US | Mississippi | Yalobusha | 28161 | 4732 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-12-26 04:21:06 | Yalobusha, Mississippi, US | |
1020220 | 1020220 | 2022-12-24 | US | Mississippi | Yalobusha | 28161 | 4732 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-12-25 04:21:04 | Yalobusha, Mississippi, US | |
692243 | 692243 | 2022-12-23 | US | Mississippi | Yalobusha | 28161 | 4732 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-12-24 04:21:02 | Yalobusha, Mississippi, US | |
2181453 | 2181453 | 2022-12-22 | US | Mississippi | Yalobusha | 28161 | 4732 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-12-23 04:21:04 | Yalobusha, Mississippi, US | |
453257 | 453257 | 2022-12-21 | US | Mississippi | Yalobusha | 28161 | 4732 | 62 | 0 | 34.02824175 | -89.7076205 | 2022-12-22 04:20:56 | Yalobusha, Mississippi, US | |
1149455 | 1149455 | 2022-12-12 | US | Arkansas | Madison | 5087 | 4732 | 67 | 0 | 36.01038185 | -93.72524943 | 2022-12-13 04:21:01 | Madison, Arkansas, US | |
3717202 | 3717202 | 2022-12-06 | US | Texas | Bosque | 48035 | 4732 | 75 | 0 | 31.89978581 | -97.63613524 | 2022-12-07 04:20:58 | Bosque, Texas, US | |
2417907 | 2417907 | 2022-12-05 | US | Texas | Bosque | 48035 | 4732 | 75 | 0 | 31.89978581 | -97.63613524 | 2022-12-06 04:21:03 | Bosque, Texas, US | |
721515 | 721515 | 2022-12-04 | US | Texas | Bosque | 48035 | 4732 | 75 | 0 | 31.89978581 | -97.63613524 | 2022-12-05 04:20:58 | Bosque, Texas, US | |
2819804 | 2819804 | 2022-12-03 | US | Texas | Bosque | 48035 | 4732 | 75 | 0 | 31.89978581 | -97.63613524 | 2022-12-04 04:20:56 | Bosque, Texas, US | |
836660 | 836660 | 2022-12-02 | US | Texas | Bosque | 48035 | 4732 | 75 | 0 | 31.89978581 | -97.63613524 | 2022-12-03 04:21:02 | Bosque, Texas, US | |
2139190 | 2139190 | 2022-12-01 | US | Texas | Bosque | 48035 | 4732 | 75 | 0 | 31.89978581 | -97.63613524 | 2022-12-02 04:21:07 | Bosque, Texas, US | |
1967606 | 1967606 | 2022-11-30 | US | Texas | Bosque | 48035 | 4732 | 75 | 0 | 31.89978581 | -97.63613524 | 2022-12-01 04:21:03 | Bosque, Texas, US | |
1643663 | 1643663 | 2022-11-20 | US | Virginia | Buckingham | 51029 | 4732 | 61 | 0 | 37.57242268 | -78.52518834 | 2022-11-21 04:21:05 | Buckingham, Virginia, US | |
2067220 | 2067220 | 2022-11-19 | US | Virginia | Buckingham | 51029 | 4732 | 61 | 0 | 37.57242268 | -78.52518834 | 2022-11-20 04:21:08 | Buckingham, Virginia, US | |
1758614 | 1758614 | 2022-11-18 | US | Virginia | Buckingham | 51029 | 4732 | 61 | 0 | 37.57242268 | -78.52518834 | 2022-11-19 04:21:14 | Buckingham, Virginia, US | |
482353 | 482353 | 2022-11-08 | US | Puerto Rico | Luquillo | 72089 | 4732 | 0 | 0 | 18.342114 | -65.725097 | 2022-11-09 04:21:22 | Luquillo, Puerto Rico, US | |
3217835 | 3217835 | 2022-10-12 | US | Wisconsin | Burnett | 55013 | 4732 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-10-13 04:22:39 | Burnett, Wisconsin, US | |
3214775 | 3214775 | 2022-10-12 | US | Arkansas | Clay | 5021 | 4732 | 98 | 0 | 36.36826212 | -90.4148172 | 2022-10-13 04:22:39 | Clay, Arkansas, US | |
3250624 | 3250624 | 2022-10-11 | US | Arkansas | Clay | 5021 | 4732 | 98 | 0 | 36.36826212 | -90.4148172 | 2022-10-12 04:22:51 | Clay, Arkansas, US | |
1813320 | 1813320 | 2022-10-05 | US | Oklahoma | Choctaw | 40023 | 4732 | 67 | 0 | 34.02807439 | -95.54771129 | 2022-10-06 04:21:22 | Choctaw, Oklahoma, US | |
133294 | 133294 | 2022-10-04 | US | Oklahoma | Choctaw | 40023 | 4732 | 67 | 0 | 34.02807439 | -95.54771129 | 2022-10-05 04:23:06 | Choctaw, Oklahoma, US | |
2688241 | 2688241 | 2022-10-03 | US | Oklahoma | Choctaw | 40023 | 4732 | 67 | 0 | 34.02807439 | -95.54771129 | 2022-10-04 04:22:55 | Choctaw, Oklahoma, US | |
2262308 | 2262308 | 2022-10-02 | US | Oklahoma | Choctaw | 40023 | 4732 | 67 | 0 | 34.02807439 | -95.54771129 | 2022-10-03 04:23:11 | Choctaw, Oklahoma, US | |
2997834 | 2997834 | 2022-10-01 | US | Oklahoma | Choctaw | 40023 | 4732 | 67 | 0 | 34.02807439 | -95.54771129 | 2022-10-02 04:21:23 | Choctaw, Oklahoma, US | |
856160 | 856160 | 2022-09-30 | US | Oklahoma | Choctaw | 40023 | 4732 | 67 | 0 | 34.02807439 | -95.54771129 | 2022-10-01 04:23:01 | Choctaw, Oklahoma, US | |
2378086 | 2378086 | 2022-09-29 | US | Oklahoma | Choctaw | 40023 | 4732 | 67 | 0 | 34.02807439 | -95.54771129 | 2022-09-30 04:23:09 | Choctaw, Oklahoma, US | |
1627767 | 1627767 | 2022-09-22 | US | West Virginia | Braxton | 54007 | 4732 | 48 | 0 | 38.70036159 | -80.72011184 | 2022-09-23 04:23:13 | Braxton, West Virginia, US | |
2009752 | 2009752 | 2022-08-04 | US | Illinois | White | 17193 | 4732 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-08-05 04:20:52 | White, Illinois, US | |
1405943 | 1405943 | 2022-08-02 | US | Georgia | Washington | 13303 | 4732 | 138 | 0 | 32.96711864 | -82.79357039 | 2022-08-03 04:20:59 | Washington, Georgia, US | |
3617981 | 3617981 | 2022-08-01 | US | Georgia | Washington | 13303 | 4732 | 138 | 0 | 32.96711864 | -82.79357039 | 2022-08-02 04:20:53 | Washington, Georgia, US | |
3872461 | 3872461 | 2022-07-31 | US | Georgia | Washington | 13303 | 4732 | 138 | 0 | 32.96711864 | -82.79357039 | 2022-08-01 04:21:03 | Washington, Georgia, US | |
675215 | 675215 | 2022-07-30 | US | Georgia | Washington | 13303 | 4732 | 138 | 0 | 32.96711864 | -82.79357039 | 2022-07-31 04:21:02 | Washington, Georgia, US | |
1784414 | 1784414 | 2022-07-29 | US | Georgia | Washington | 13303 | 4732 | 138 | 0 | 32.96711864 | -82.79357039 | 2022-07-30 04:20:42 | Washington, Georgia, US | |
1066777 | 1066777 | 2022-07-28 | US | Georgia | Washington | 13303 | 4732 | 138 | 0 | 32.96711864 | -82.79357039 | 2022-07-29 04:20:45 | Washington, Georgia, US | |
2336296 | 2336296 | 2022-07-27 | US | Georgia | Washington | 13303 | 4732 | 138 | 0 | 32.96711864 | -82.79357039 | 2022-07-28 04:20:56 | Washington, Georgia, US | |
3112796 | 3112796 | 2022-07-13 | US | Virginia | Bristol | 51520 | 4732 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-07-14 04:20:57 | Bristol, Virginia, US | |
1648757 | 1648757 | 2022-06-23 | US | Alabama | Henry | 1067 | 4732 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-06-24 04:20:58 | Henry, Alabama, US | |
561725 | 561725 | 2022-06-16 | US | Tennessee | Bledsoe | 47007 | 4732 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-06-17 04:20:56 | Bledsoe, Tennessee, US | |
3985527 | 3985527 | 2022-06-15 | US | Tennessee | Bledsoe | 47007 | 4732 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-06-16 04:20:55 | Bledsoe, Tennessee, US | |
3897938 | 3897938 | 2022-05-19 | US | Missouri | Texas | 29215 | 4732 | 102 | 0 | 37.31728859 | -91.96564727 | 2022-05-20 04:20:57 | Texas, Missouri, US | |
1186722 | 1186722 | 2022-05-18 | US | Missouri | Texas | 29215 | 4732 | 102 | 0 | 37.31728859 | -91.96564727 | 2022-05-19 04:20:54 | Texas, Missouri, US | |
3584619 | 3584619 | 2022-05-17 | US | Missouri | Texas | 29215 | 4732 | 102 | 0 | 37.31728859 | -91.96564727 | 2022-05-18 04:20:50 | Texas, Missouri, US | |
1505576 | 1505576 | 2022-05-16 | US | Missouri | Texas | 29215 | 4732 | 102 | 0 | 37.31728859 | -91.96564727 | 2022-05-17 04:20:59 | Texas, Missouri, US | |
2085935 | 2085935 | 2022-05-15 | US | Missouri | Texas | 29215 | 4732 | 102 | 0 | 37.31728859 | -91.96564727 | 2022-05-16 04:20:47 | Texas, Missouri, US | |
3356645 | 3356645 | 2022-05-14 | US | Missouri | Texas | 29215 | 4732 | 102 | 0 | 37.31728859 | -91.96564727 | 2022-05-15 04:20:53 | Texas, Missouri, US | |
660290 | 660290 | 2022-05-13 | US | Missouri | Texas | 29215 | 4732 | 102 | 0 | 37.31728859 | -91.96564727 | 2022-05-14 04:20:48 | Texas, Missouri, US | |
222146 | 222146 | 2022-05-09 | Palau | 4732 | 6 | 0 | 7.515 | 134.5825 | 2022-05-10 04:20:50 | Palau | ||||
2331531 | 2331531 | 2022-05-08 | Palau | 4732 | 6 | 0 | 7.515 | 134.5825 | 2022-05-09 04:20:54 | Palau | ||||
360493 | 360493 | 2022-05-07 | Palau | 4732 | 6 | 0 | 7.515 | 134.5825 | 2022-05-08 04:20:49 | Palau | ||||
1397844 | 1397844 | 2022-05-06 | Palau | 4732 | 6 | 0 | 7.515 | 134.5825 | 2022-05-07 04:21:09 | Palau | ||||
2598425 | 2598425 | 2022-05-05 | US | Alabama | Hale | 1065 | 4732 | 106 | 0 | 32.76039258 | -87.63284988 | 2022-05-06 04:21:00 | Hale, Alabama, US | |
3265874 | 3265874 | 2022-05-04 | US | Alabama | Hale | 1065 | 4732 | 106 | 0 | 32.76039258 | -87.63284988 | 2022-05-05 04:20:55 | Hale, Alabama, US | |
1572513 | 1572513 | 2022-05-03 | US | Alabama | Hale | 1065 | 4732 | 106 | 0 | 32.76039258 | -87.63284988 | 2022-05-04 04:20:59 | Hale, Alabama, US | |
3321214 | 3321214 | 2022-04-07 | US | Illinois | Clay | 17025 | 4732 | 68 | 0 | 38.75388572 | -88.48914513 | 2022-04-08 04:20:48 | Clay, Illinois, US | |
1908181 | 1908181 | 2022-03-22 | US | Tennessee | Polk | 47139 | 4732 | 70 | 0 | 35.12245443 | -84.52075859 | 2022-03-23 04:20:48 | Polk, Tennessee, US | |
1867370 | 1867370 | 2022-03-10 | US | Missouri | Clinton | 29049 | 4732 | 115 | 0 | 39.6013098 | -94.40465394 | 2022-03-11 04:20:50 | Clinton, Missouri, US | |
2733505 | 2733505 | 2022-02-27 | US | Arkansas | Cross | 5037 | 4732 | 75 | 0 | 35.29631396 | -90.77185818 | 2022-02-28 04:21:05 | Cross, Arkansas, US | |
3048856 | 3048856 | 2022-02-26 | US | Pennsylvania | Juniata | 42067 | 4732 | 174 | 0 | 40.53358749 | -77.39975129999998 | 2022-02-27 04:21:04 | Juniata, Pennsylvania, US | |
3046658 | 3046658 | 2022-02-26 | US | Arkansas | Cross | 5037 | 4732 | 75 | 0 | 35.29631396 | -90.77185818 | 2022-02-27 04:21:04 | Cross, Arkansas, US | |
1061173 | 1061173 | 2022-02-23 | US | Virginia | Colonial Heights | 51570 | 4732 | 90 | 0 | 37.26420587 | -77.39609676 | 2022-02-24 04:21:14 | Colonial Heights, Virginia, US | |
3672625 | 3672625 | 2022-02-15 | US | Illinois | Clark | 17023 | 4732 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-16 04:21:10 | Clark, Illinois, US | |
3074865 | 3074865 | 2022-02-09 | US | Georgia | Hart | 13147 | 4732 | 82 | 0 | 34.34626973 | -82.96567682 | 2022-02-10 04:21:14 | Hart, Georgia, US | |
2658254 | 2658254 | 2022-01-31 | US | Arkansas | Ashley | 5003 | 4732 | 56 | 0 | 33.19153461 | -91.76984709999999 | 2022-02-01 04:21:11 | Ashley, Arkansas, US | |
2052674 | 2052674 | 2022-01-25 | US | Georgia | Dodge | 13091 | 4732 | 138 | 0 | 32.17265114 | -83.16948926 | 2022-01-26 04:21:07 | Dodge, Georgia, US | |
1961320 | 1961320 | 2022-01-20 | US | Georgia | Burke | 13033 | 4732 | 88 | 0 | 33.05917989 | -81.99928721 | 2022-01-21 04:21:09 | Burke, Georgia, US | |
2610048 | 2610048 | 2022-01-06 | Japan | Kagawa | 4732 | 38 | 0 | 34.217292 | 133.969047 | 2022-01-07 04:22:09 | Kagawa, Japan | |||
1283533 | 1283533 | 2022-01-05 | US | Louisiana | Union | 22111 | 4732 | 114 | 0 | 32.83121059 | -92.3749373 | 2022-01-06 04:22:09 | Union, Louisiana, US | |
3520695 | 3520695 | 2022-01-02 | US | Kansas | Barton | 20009 | 4732 | 72 | 0 | 38.47889676 | -98.75636726 | 2022-01-03 02:22:25 | Barton, Kansas, US | |
2168825 | 2168825 | 2022-01-01 | US | Kansas | Barton | 20009 | 4732 | 72 | 0 | 38.47889676 | -98.75636726 | 2022-01-02 04:20:52 | Barton, Kansas, US | |
2778256 | 2778256 | 2021-12-31 | US | Kansas | Barton | 20009 | 4732 | 72 | 0 | 38.47889676 | -98.75636726 | 2022-01-01 04:22:14 | Barton, Kansas, US | |
3999913 | 3999913 | 2021-12-30 | US | Kansas | Barton | 20009 | 4732 | 71 | 0 | 38.47889676 | -98.75636726 | 2021-12-31 04:21:50 | Barton, Kansas, US | |
1671502 | 1671502 | 2021-12-29 | US | Texas | Cass | 48067 | 4732 | 162 | 0 | 33.07499881 | -94.34646905 | 2021-12-30 04:21:25 | Cass, Texas, US | |
1669720 | 1669720 | 2021-12-29 | US | Kansas | Barton | 20009 | 4732 | 71 | 0 | 38.47889676 | -98.75636726 | 2021-12-30 04:21:25 | Barton, Kansas, US | |
1031824 | 1031824 | 2021-12-06 | US | Kentucky | Mercer | 21167 | 4732 | 87 | 0 | 37.81474237 | -84.87488475 | 2021-12-07 04:22:34 | Mercer, Kentucky, US | |
1031362 | 1031362 | 2021-12-06 | US | Illinois | Fayette | 17051 | 4732 | 71 | 0 | 39.00072038 | -89.02452658 | 2021-12-07 04:22:34 | Fayette, Illinois, US | |
1145514 | 1145514 | 2021-12-01 | US | California | Siskiyou | 6093 | 4732 | 55 | 0 | 41.59198861 | -122.54074340000001 | 2021-12-02 04:22:37 | Siskiyou, California, US | |
450931 | 450931 | 2021-11-17 | US | Wisconsin | Lincoln | 55069 | 4732 | 113 | 0 | 45.33737523 | -89.73411273 | 2021-11-18 04:21:33 | Lincoln, Wisconsin, US | |
3344127 | 3344127 | 2021-11-16 | US | Louisiana | Franklin | 22041 | 4732 | 139 | 0 | 32.13675181 | -91.67589857 | 2021-11-17 04:21:48 | Franklin, Louisiana, US | |
30652 | 30652 | 2021-11-11 | US | New York | Franklin | 36033 | 4732 | 25 | 0 | 44.59040891 | -74.29926032 | 2021-11-12 04:22:01 | Franklin, New York, US | |
3642397 | 3642397 | 2021-11-08 | US | South Carolina | Union | 45087 | 4732 | 106 | 0 | 34.68835752 | -81.61730349 | 2021-11-09 04:21:36 | Union, South Carolina, US | |
289848 | 289848 | 2021-10-31 | US | Mississippi | Tippah | 28139 | 4732 | 81 | 0 | 34.76872156 | -88.90988194 | 2021-11-01 04:22:01 | Tippah, Mississippi, US | |
2722854 | 2722854 | 2021-10-30 | US | Mississippi | Tippah | 28139 | 4732 | 81 | 0 | 34.76872156 | -88.90988194 | 2021-10-31 04:22:08 | Tippah, Mississippi, US | |
568956 | 568956 | 2021-10-29 | US | Mississippi | Tippah | 28139 | 4732 | 81 | 0 | 34.76872156 | -88.90988194 | 2021-10-30 04:22:03 | Tippah, Mississippi, US | |
3795395 | 3795395 | 2021-10-25 | US | Louisiana | De Soto | 22031 | 4732 | 108 | 0 | 32.05457447 | -93.74130302 | 2021-10-26 04:22:09 | De Soto, Louisiana, US | |
1910050 | 1910050 | 2021-10-17 | US | Georgia | Lumpkin | 13187 | 4732 | 97 | 0 | 34.57286511 | -84.00425681 | 2021-10-18 04:21:10 | Lumpkin, Georgia, US | |
935639 | 935639 | 2021-10-16 | US | Georgia | Lumpkin | 13187 | 4732 | 97 | 0 | 34.57286511 | -84.00425681 | 2021-10-17 04:21:29 | Lumpkin, Georgia, US | |
2946336 | 2946336 | 2021-10-15 | US | Tennessee | Overton | 47133 | 4732 | 79 | 0 | 36.34117832 | -85.28989535 | 2021-10-16 04:21:15 | Overton, Tennessee, US | |
2944194 | 2944194 | 2021-10-15 | US | Georgia | Lumpkin | 13187 | 4732 | 97 | 0 | 34.57286511 | -84.00425681 | 2021-10-16 04:21:15 | Lumpkin, Georgia, US | |
1492613 | 1492613 | 2021-10-12 | US | Illinois | Lee | 17103 | 4732 | 60 | 0 | 41.74583951 | -89.29977132 | 2021-10-13 04:20:51 | Lee, Illinois, US | |
987901 | 987901 | 2021-10-04 | US | Idaho | Bonner | 16017 | 4732 | 73 | 0 | 48.29996017 | -116.6017932 | 2021-10-05 04:21:27 | Bonner, Idaho, US | |
1277058 | 1277058 | 2021-10-03 | US | Puerto Rico | Ponce | 72113 | 4732 | 0 | 0 | 18.059498 | -66.613748 | 2021-10-04 04:21:31 | Ponce, Puerto Rico, US | |
2078935 | 2078935 | 2021-09-26 | US | Tennessee | Scott | 47151 | 4732 | 54 | 0 | 36.42325673 | -84.50360494 | 2021-09-27 04:21:16 | Scott, Tennessee, US | |
16398 | 16398 | 2021-09-18 | Japan | Toyama | 4732 | 48 | 0 | 36.637464 | 137.26934599999998 | 2021-09-19 04:21:34 | Toyama, Japan | |||
3196964 | 3196964 | 2021-09-06 | US | Tennessee | Macon | 47111 | 4732 | 80 | 0 | 36.53157855 | -86.00778595 | 2021-09-07 04:21:35 | Macon, Tennessee, US | |
3976134 | 3976134 | 2021-09-03 | US | Maryland | Calvert | 24009 | 4732 | 90 | 0 | 38.53961642 | -76.56820632 | 2021-09-04 04:21:28 | Calvert, Maryland, US | |
68987 | 68987 | 2021-09-01 | US | Missouri | Marion | 29127 | 4732 | 58 | 0 | 39.80601912 | -91.62203062 | 2021-09-02 04:21:15 | Marion, Missouri, US | |
2068253 | 2068253 | 2021-08-31 | US | Alabama | Chambers | 1017 | 4732 | 127 | 0 | 32.91360079 | -85.39072749 | 2021-09-01 04:21:38 | Chambers, Alabama, US | |
1778136 | 1778136 | 2021-08-30 | US | Puerto Rico | Toa Baja | 72137 | 4732 | 0 | 0 | 18.431445999999998 | -66.213553 | 2021-08-31 04:21:46 | Toa Baja, Puerto Rico, 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]);