johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
177 rows where confirmed = 3865 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1241569 | 1241569 | 2022-11-28 | US | Missouri | Gasconade | 29073 | 3865 | 109 | 0 | 38.43947277 | -91.50847147 | 2022-11-29 04:21:05 | Gasconade, Missouri, US | |
3553557 | 3553557 | 2022-11-27 | US | Missouri | Gasconade | 29073 | 3865 | 109 | 0 | 38.43947277 | -91.50847147 | 2022-11-28 04:21:02 | Gasconade, Missouri, US | |
3552632 | 3552632 | 2022-11-27 | US | Illinois | Cumberland | 17035 | 3865 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-11-28 04:21:02 | Cumberland, Illinois, US | |
2102037 | 2102037 | 2022-11-26 | US | Missouri | Gasconade | 29073 | 3865 | 109 | 0 | 38.43947277 | -91.50847147 | 2022-11-27 04:21:05 | Gasconade, Missouri, US | |
2101112 | 2101112 | 2022-11-26 | US | Illinois | Cumberland | 17035 | 3865 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-11-27 04:21:05 | Cumberland, Illinois, US | |
489528 | 489528 | 2022-11-25 | US | Missouri | Gasconade | 29073 | 3865 | 109 | 0 | 38.43947277 | -91.50847147 | 2022-11-26 04:21:11 | Gasconade, Missouri, US | |
488603 | 488603 | 2022-11-25 | US | Illinois | Cumberland | 17035 | 3865 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-11-26 04:21:11 | Cumberland, Illinois, US | |
3525357 | 3525357 | 2022-11-24 | US | Missouri | Gasconade | 29073 | 3865 | 109 | 0 | 38.43947277 | -91.50847147 | 2022-11-25 04:21:06 | Gasconade, Missouri, US | |
3524432 | 3524432 | 2022-11-24 | US | Illinois | Cumberland | 17035 | 3865 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-11-25 04:21:06 | Cumberland, Illinois, US | |
3314140 | 3314140 | 2022-11-23 | US | Missouri | Gasconade | 29073 | 3865 | 109 | 0 | 38.43947277 | -91.50847147 | 2022-11-24 04:21:09 | Gasconade, Missouri, US | |
3313215 | 3313215 | 2022-11-23 | US | Illinois | Cumberland | 17035 | 3865 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-11-24 04:21:09 | Cumberland, Illinois, US | |
1622181 | 1622181 | 2022-11-22 | US | Missouri | Gasconade | 29073 | 3865 | 109 | 0 | 38.43947277 | -91.50847147 | 2022-11-23 04:21:06 | Gasconade, Missouri, US | |
4005107 | 4005107 | 2022-10-08 | US | North Dakota | Walsh | 38099 | 3865 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-10-09 04:21:16 | Walsh, North Dakota, US | |
398704 | 398704 | 2022-10-07 | US | North Dakota | Walsh | 38099 | 3865 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-10-08 04:22:56 | Walsh, North Dakota, US | |
2531821 | 2531821 | 2022-10-06 | US | North Dakota | Walsh | 38099 | 3865 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-10-07 04:23:08 | Walsh, North Dakota, US | |
2263421 | 2263421 | 2022-10-02 | United Kingdom | Anguilla | 3865 | 12 | 0 | 18.2206 | -63.0686 | 2022-10-03 04:23:11 | Anguilla, United Kingdom | |||
2998947 | 2998947 | 2022-10-01 | United Kingdom | Anguilla | 3865 | 12 | 0 | 18.2206 | -63.0686 | 2022-10-02 04:21:23 | Anguilla, United Kingdom | |||
857273 | 857273 | 2022-09-30 | United Kingdom | Anguilla | 3865 | 12 | 0 | 18.2206 | -63.0686 | 2022-10-01 04:23:01 | Anguilla, United Kingdom | |||
2379199 | 2379199 | 2022-09-29 | United Kingdom | Anguilla | 3865 | 12 | 0 | 18.2206 | -63.0686 | 2022-09-30 04:23:09 | Anguilla, United Kingdom | |||
1563750 | 1563750 | 2022-09-28 | United Kingdom | Anguilla | 3865 | 12 | 0 | 18.2206 | -63.0686 | 2022-09-29 04:22:34 | Anguilla, United Kingdom | |||
3998293 | 3998293 | 2022-09-27 | United Kingdom | Anguilla | 3865 | 12 | 0 | 18.2206 | -63.0686 | 2022-09-28 04:23:01 | Anguilla, United Kingdom | |||
3995263 | 3995263 | 2022-09-27 | US | Colorado | Grand | 8049 | 3865 | 29 | 0 | 40.10603347 | -106.1178042 | 2022-09-28 04:23:01 | Grand, Colorado, US | |
2326314 | 2326314 | 2022-08-24 | US | Tennessee | Lewis | 47101 | 3865 | 64 | 0 | 35.52853208 | -87.49022694 | 2022-08-25 04:21:13 | Lewis, Tennessee, US | |
2494568 | 2494568 | 2022-08-15 | US | Arkansas | Van Buren | 5141 | 3865 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-08-16 04:20:58 | Van Buren, Arkansas, US | |
1066870 | 1066870 | 2022-07-28 | US | Illinois | Greene | 17061 | 3865 | 46 | 0 | 39.35907414 | -90.388865 | 2022-07-29 04:20:45 | Greene, Illinois, US | |
2594593 | 2594593 | 2022-07-25 | US | California | Mariposa | 6043 | 3865 | 36 | 0 | 37.57978556 | -119.9073334 | 2022-07-26 04:20:58 | Mariposa, California, US | |
896708 | 896708 | 2022-07-24 | US | California | Mariposa | 6043 | 3865 | 36 | 0 | 37.57978556 | -119.9073334 | 2022-07-25 04:20:51 | Mariposa, California, US | |
91702 | 91702 | 2022-07-23 | US | California | Mariposa | 6043 | 3865 | 36 | 0 | 37.57978556 | -119.9073334 | 2022-07-24 04:20:47 | Mariposa, California, US | |
900724 | 900724 | 2022-07-22 | US | California | Mariposa | 6043 | 3865 | 36 | 0 | 37.57978556 | -119.9073334 | 2022-07-23 04:20:53 | Mariposa, California, US | |
3431725 | 3431725 | 2022-07-14 | US | Puerto Rico | Luquillo | 72089 | 3865 | 0 | 0 | 18.342114 | -65.725097 | 2022-07-15 04:20:53 | Luquillo, Puerto Rico, US | |
633149 | 633149 | 2022-07-12 | US | Texas | Tyler | 48457 | 3865 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-07-13 04:20:58 | Tyler, Texas, US | |
631115 | 631115 | 2022-07-12 | US | Iowa | Iowa | 19095 | 3865 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-07-13 04:20:58 | Iowa, Iowa, US | |
1212759 | 1212759 | 2022-07-11 | US | Iowa | Iowa | 19095 | 3865 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-07-12 04:20:51 | Iowa, Iowa, US | |
2790241 | 2790241 | 2022-07-10 | US | Iowa | Iowa | 19095 | 3865 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-07-11 04:20:46 | Iowa, Iowa, US | |
143194 | 143194 | 2022-07-09 | US | Iowa | Iowa | 19095 | 3865 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-07-10 04:20:54 | Iowa, Iowa, US | |
1418294 | 1418294 | 2022-07-08 | US | Iowa | Iowa | 19095 | 3865 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-07-09 04:20:59 | Iowa, Iowa, US | |
2742940 | 2742940 | 2022-07-07 | US | Missouri | Livingston | 29117 | 3865 | 97 | 0 | 39.78110272 | -93.54645978 | 2022-07-08 04:20:56 | Livingston, Missouri, US | |
2742219 | 2742219 | 2022-07-07 | US | Iowa | Iowa | 19095 | 3865 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-07-08 04:20:56 | Iowa, Iowa, US | |
1201735 | 1201735 | 2022-07-06 | US | Missouri | Livingston | 29117 | 3865 | 97 | 0 | 39.78110272 | -93.54645978 | 2022-07-07 04:20:55 | Livingston, Missouri, US | |
1201014 | 1201014 | 2022-07-06 | US | Iowa | Iowa | 19095 | 3865 | 50 | 0 | 41.68630265 | -92.0643373 | 2022-07-07 04:20:55 | Iowa, Iowa, US | |
3968478 | 3968478 | 2022-07-05 | US | Missouri | Livingston | 29117 | 3865 | 97 | 0 | 39.78110272 | -93.54645978 | 2022-07-06 04:20:58 | Livingston, Missouri, US | |
3079989 | 3079989 | 2022-07-04 | US | Missouri | Livingston | 29117 | 3865 | 97 | 0 | 39.78110272 | -93.54645978 | 2022-07-05 04:20:45 | Livingston, Missouri, US | |
1769271 | 1769271 | 2022-07-03 | US | Missouri | Livingston | 29117 | 3865 | 97 | 0 | 39.78110272 | -93.54645978 | 2022-07-04 04:20:54 | Livingston, Missouri, US | |
3367257 | 3367257 | 2022-07-02 | US | Missouri | Livingston | 29117 | 3865 | 97 | 0 | 39.78110272 | -93.54645978 | 2022-07-03 04:20:59 | Livingston, Missouri, US | |
595586 | 595586 | 2022-07-01 | US | Missouri | Livingston | 29117 | 3865 | 97 | 0 | 39.78110272 | -93.54645978 | 2022-07-02 04:21:16 | Livingston, Missouri, US | |
2191003 | 2191003 | 2022-06-22 | US | Virginia | Patrick | 51141 | 3865 | 97 | 0 | 36.6801638 | -80.2865648 | 2022-06-23 04:20:55 | Patrick, Virginia, US | |
168314 | 168314 | 2022-06-21 | US | New York | Schuyler | 36097 | 3865 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-06-22 04:20:54 | Schuyler, New York, US | |
561863 | 561863 | 2022-06-16 | US | Texas | Colorado | 48089 | 3865 | 66 | 0 | 29.622098 | -96.5273805 | 2022-06-17 04:20:56 | Colorado, Texas, US | |
560568 | 560568 | 2022-06-16 | US | Minnesota | Renville | 27129 | 3865 | 56 | 0 | 44.72836381 | -94.94553734 | 2022-06-17 04:20:56 | Renville, Minnesota, US | |
949586 | 949586 | 2022-06-14 | US | Puerto Rico | Comerio | 72045 | 3865 | 0 | 0 | 18.224687 | -66.221622 | 2022-06-15 04:20:54 | Comerio, Puerto Rico, US | |
2029157 | 2029157 | 2022-04-24 | US | Alabama | Macon | 1087 | 3865 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-25 04:20:56 | Macon, Alabama, US | |
746732 | 746732 | 2022-04-23 | US | Alabama | Macon | 1087 | 3865 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-24 04:20:56 | Macon, Alabama, US | |
3437217 | 3437217 | 2022-04-22 | US | Alabama | Macon | 1087 | 3865 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-23 04:20:50 | Macon, Alabama, US | |
2892802 | 2892802 | 2022-04-21 | US | Alabama | Macon | 1087 | 3865 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-22 04:20:45 | Macon, Alabama, US | |
2307674 | 2307674 | 2022-04-20 | US | Alabama | Macon | 1087 | 3865 | 84 | 0 | 32.38759944 | -85.69267724 | 2022-04-21 04:20:46 | Macon, Alabama, US | |
2255004 | 2255004 | 2022-04-19 | US | Wisconsin | Richland | 55103 | 3865 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-04-20 04:20:45 | Richland, Wisconsin, US | |
1849554 | 1849554 | 2022-04-18 | US | Wisconsin | Richland | 55103 | 3865 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-04-19 04:21:00 | Richland, Wisconsin, US | |
3732592 | 3732592 | 2022-04-03 | US | North Carolina | Polk | 37149 | 3865 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-04 04:20:51 | Polk, North Carolina, US | |
502027 | 502027 | 2022-04-02 | US | North Carolina | Polk | 37149 | 3865 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-03 04:20:48 | Polk, North Carolina, US | |
3353012 | 3353012 | 2022-04-01 | US | North Carolina | Polk | 37149 | 3865 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-04-02 04:20:47 | Polk, North Carolina, US | |
1659571 | 1659571 | 2022-03-19 | US | Texas | Llano | 48299 | 3865 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-20 04:20:45 | Llano, Texas, US | |
339097 | 339097 | 2022-03-18 | US | Texas | Llano | 48299 | 3865 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-19 04:20:47 | Llano, Texas, US | |
2264644 | 2264644 | 2022-03-14 | US | Georgia | Banks | 13011 | 3865 | 85 | 0 | 34.35607081 | -83.49644388 | 2022-03-15 04:20:47 | Banks, Georgia, US | |
3721533 | 3721533 | 2022-02-21 | US | Virginia | Grayson | 51077 | 3865 | 75 | 0 | 36.65677234 | -81.23215889 | 2022-02-22 04:21:01 | Grayson, Virginia, US | |
2330629 | 2330629 | 2022-02-04 | US | Texas | Zavala | 48507 | 3865 | 59 | 0 | 28.86617238 | -99.76050829 | 2022-02-05 04:21:05 | Zavala, Texas, US | |
979467 | 979467 | 2022-02-01 | US | Arkansas | Polk | 5113 | 3865 | 131 | 0 | 34.48254879 | -94.22728802 | 2022-02-02 04:21:09 | Polk, Arkansas, US | |
2658759 | 2658759 | 2022-01-31 | US | Illinois | Carroll | 17015 | 3865 | 44 | 0 | 42.06823429 | -89.93395545 | 2022-02-01 04:21:11 | Carroll, Illinois, US | |
1116689 | 1116689 | 2022-01-11 | US | Texas | Gonzales | 48177 | 3865 | 90 | 0 | 29.45634206 | -97.49424032 | 2022-01-12 04:21:44 | Gonzales, Texas, US | |
1115071 | 1115071 | 2022-01-11 | US | Kentucky | Wayne | 21231 | 3865 | 74 | 0 | 36.80310688 | -84.8251971 | 2022-01-12 04:21:44 | Wayne, Kentucky, US | |
1390136 | 1390136 | 2022-01-07 | US | Arkansas | Columbia | 5027 | 3865 | 77 | 0 | 33.21230701 | -93.22642793 | 2022-01-08 04:21:53 | Columbia, Arkansas, US | |
1283839 | 1283839 | 2022-01-05 | US | Mississippi | Stone | 28131 | 3865 | 67 | 0 | 30.79187949 | -89.11547539 | 2022-01-06 04:22:09 | Stone, Mississippi, US | |
3498120 | 3498120 | 2021-12-15 | US | Missouri | McDonald | 29119 | 3865 | 56 | 0 | 36.62869595 | -94.34867205 | 2021-12-16 04:22:11 | McDonald, Missouri, US | |
2088853 | 2088853 | 2021-12-14 | US | Georgia | Tattnall | 13267 | 3865 | 115 | 0 | 32.04785085 | -82.05539188 | 2021-12-15 03:22:16 | Tattnall, Georgia, US | |
783270 | 783270 | 2021-12-13 | US | Georgia | Tattnall | 13267 | 3865 | 115 | 0 | 32.04785085 | -82.05539188 | 2021-12-14 04:22:38 | Tattnall, Georgia, US | |
1661305 | 1661305 | 2021-12-12 | US | Georgia | Tattnall | 13267 | 3865 | 115 | 0 | 32.04785085 | -82.05539188 | 2021-12-13 04:22:02 | Tattnall, Georgia, US | |
1665321 | 1665321 | 2021-12-11 | US | Georgia | Tattnall | 13267 | 3865 | 115 | 0 | 32.04785085 | -82.05539188 | 2021-12-12 04:22:12 | Tattnall, Georgia, US | |
3656473 | 3656473 | 2021-12-10 | US | Georgia | Tattnall | 13267 | 3865 | 115 | 0 | 32.04785085 | -82.05539188 | 2021-12-11 04:22:45 | Tattnall, Georgia, US | |
1079560 | 1079560 | 2021-12-09 | US | Michigan | Gladwin | 26051 | 3865 | 85 | 0 | 43.98901072 | -84.38774817 | 2021-12-10 04:22:28 | Gladwin, Michigan, US | |
552409 | 552409 | 2021-12-08 | US | Michigan | Gladwin | 26051 | 3865 | 85 | 0 | 43.98901072 | -84.38774817 | 2021-12-09 04:22:49 | Gladwin, Michigan, US | |
1031194 | 1031194 | 2021-12-06 | US | Georgia | Harris | 13145 | 3865 | 95 | 0 | 32.73709786 | -84.90538572 | 2021-12-07 04:22:34 | Harris, Georgia, US | |
1146669 | 1146669 | 2021-12-01 | US | Minnesota | Martin | 27091 | 3865 | 44 | 0 | 43.67429718 | -94.55099908 | 2021-12-02 04:22:37 | Martin, Minnesota, US | |
151939 | 151939 | 2021-11-29 | US | Missouri | Randolph | 29175 | 3865 | 38 | 0 | 39.44007257 | -92.49713740000001 | 2021-11-30 04:22:53 | Randolph, Missouri, US | |
1235155 | 1235155 | 2021-11-28 | US | West Virginia | Wyoming | 54109 | 3865 | 67 | 0 | 37.612327 | -81.54511071 | 2021-11-29 04:22:30 | Wyoming, West Virginia, US | |
1361862 | 1361862 | 2021-11-27 | US | West Virginia | Wyoming | 54109 | 3865 | 67 | 0 | 37.612327 | -81.54511071 | 2021-11-28 04:22:43 | Wyoming, West Virginia, US | |
761853 | 761853 | 2021-11-26 | US | West Virginia | Wyoming | 54109 | 3865 | 67 | 0 | 37.612327 | -81.54511071 | 2021-11-27 04:22:45 | Wyoming, West Virginia, US | |
1806270 | 1806270 | 2021-11-25 | US | West Virginia | Wyoming | 54109 | 3865 | 67 | 0 | 37.612327 | -81.54511071 | 2021-11-26 04:22:33 | Wyoming, West Virginia, US | |
907704 | 907704 | 2021-11-24 | US | West Virginia | Wyoming | 54109 | 3865 | 67 | 0 | 37.612327 | -81.54511071 | 2021-11-25 04:22:33 | Wyoming, West Virginia, US | |
1016811 | 1016811 | 2021-11-21 | US | Ohio | Holmes | 39075 | 3865 | 142 | 0 | 40.56163713 | -81.92635677 | 2021-11-22 04:22:20 | Holmes, Ohio, US | |
2288823 | 2288823 | 2021-11-15 | US | Kentucky | Allen | 21003 | 3865 | 70 | 0 | 36.75197631 | -86.19457544 | 2021-11-16 04:21:10 | Allen, Kentucky, US | |
688227 | 688227 | 2021-11-13 | US | Missouri | Audrain | 29007 | 3865 | 64 | 0 | 39.215877 | -91.84242683 | 2021-11-14 04:21:31 | Audrain, Missouri, US | |
685492 | 685492 | 2021-10-24 | US | Texas | Lampasas | 48281 | 3865 | 62 | 0 | 31.19531316 | -98.24206613 | 2021-10-25 04:22:31 | Lampasas, Texas, US | |
773500 | 773500 | 2021-10-23 | US | Texas | Lampasas | 48281 | 3865 | 62 | 0 | 31.19531316 | -98.24206613 | 2021-10-24 04:21:22 | Lampasas, Texas, US | |
656779 | 656779 | 2021-10-22 | US | Puerto Rico | Trujillo Alto | 72139 | 3865 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-10-23 04:21:32 | Trujillo Alto, Puerto Rico, US | |
2126526 | 2126526 | 2021-10-21 | US | Puerto Rico | Trujillo Alto | 72139 | 3865 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-10-22 04:21:14 | Trujillo Alto, Puerto Rico, US | |
2044954 | 2044954 | 2021-10-18 | US | Indiana | Jennings | 18079 | 3865 | 60 | 0 | 38.99588883 | -85.62710784 | 2021-10-19 04:20:54 | Jennings, Indiana, US | |
2044392 | 2044392 | 2021-10-18 | US | California | Calaveras | 6009 | 3865 | 80 | 0 | 38.20537103 | -120.55291299999999 | 2021-10-19 04:20:54 | Calaveras, California, US | |
935753 | 935753 | 2021-10-16 | US | Idaho | Payette | 16075 | 3865 | 57 | 0 | 44.00545243 | -116.7647695 | 2021-10-17 04:21:29 | Payette, Idaho, US | |
935735 | 935735 | 2021-10-16 | US | Idaho | Elmore | 16039 | 3865 | 42 | 0 | 43.3507101 | -115.4701578 | 2021-10-17 04:21:29 | Elmore, Idaho, US | |
636125 | 636125 | 2021-10-13 | US | New Mexico | Luna | 35029 | 3865 | 94 | 0 | 32.18179341 | -107.75088259999998 | 2021-10-14 04:21:29 | Luna, New Mexico, US | |
707976 | 707976 | 2021-09-29 | US | Louisiana | Union | 22111 | 3865 | 99 | 0 | 32.83121059 | -92.3749373 | 2021-09-30 04:21:20 | Union, Louisiana, 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]);