johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94 rows where confirmed = 8148 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331016 | 331016 | 2022-12-27 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-28 04:21:04 | Hale, Texas, US | |
221089 | 221089 | 2022-12-26 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-27 04:21:07 | Hale, Texas, US | |
3225546 | 3225546 | 2022-12-25 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-26 04:21:06 | Hale, Texas, US | |
1021460 | 1021460 | 2022-12-24 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-25 04:21:04 | Hale, Texas, US | |
693483 | 693483 | 2022-12-23 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-24 04:21:02 | Hale, Texas, US | |
2182693 | 2182693 | 2022-12-22 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-23 04:21:04 | Hale, Texas, US | |
454497 | 454497 | 2022-12-21 | US | Texas | Hale | 48189 | 8148 | 249 | 0 | 34.07044901 | -101.8268114 | 2022-12-22 04:20:56 | Hale, Texas, US | |
311373 | 311373 | 2022-12-13 | US | West Virginia | Hancock | 54029 | 8148 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-12-14 04:21:04 | Hancock, West Virginia, US | |
2968930 | 2968930 | 2022-10-10 | US | Louisiana | Morehouse | 22067 | 8148 | 142 | 0 | 32.81686191 | -91.80421614 | 2022-10-11 04:23:05 | Morehouse, Louisiana, US | |
1814252 | 1814252 | 2022-10-05 | US | West Virginia | Boone | 54005 | 8148 | 93 | 0 | 38.01974191 | -81.69888019 | 2022-10-06 04:21:22 | Boone, West Virginia, US | |
134226 | 134226 | 2022-10-04 | US | West Virginia | Boone | 54005 | 8148 | 93 | 0 | 38.01974191 | -81.69888019 | 2022-10-05 04:23:06 | Boone, West Virginia, US | |
2771732 | 2771732 | 2022-09-26 | US | Puerto Rico | Morovis | 72101 | 8148 | 0 | 0 | 18.316963 | -66.420383 | 2022-09-27 04:23:01 | Morovis, Puerto Rico, US | |
256810 | 256810 | 2022-09-08 | US | West Virginia | Mason | 54053 | 8148 | 101 | 0 | 38.77071799 | -82.02524219 | 2022-09-09 04:21:11 | Mason, West Virginia, US | |
2346744 | 2346744 | 2022-08-31 | US | Virginia | Carroll | 51035 | 8148 | 153 | 0 | 36.73066666 | -80.73455942 | 2022-09-01 04:21:03 | Carroll, Virginia, US | |
1254074 | 1254074 | 2022-08-23 | US | Virginia | Caroline | 51033 | 8148 | 89 | 0 | 38.02679129 | -77.34901405 | 2022-08-24 04:20:46 | Caroline, Virginia, US | |
3953248 | 3953248 | 2022-08-17 | US | Puerto Rico | Lares | 72081 | 8148 | 0 | 0 | 18.269035 | -66.867236 | 2022-08-18 04:21:11 | Lares, Puerto Rico, US | |
1490708 | 1490708 | 2022-07-26 | US | Texas | Hockley | 48219 | 8148 | 164 | 0 | 33.60771256 | -102.3431676 | 2022-07-27 04:21:04 | Hockley, Texas, US | |
3941196 | 3941196 | 2022-06-30 | US | Indiana | Scott | 18143 | 8148 | 108 | 0 | 38.68672078 | -85.74627859 | 2022-07-01 04:21:10 | Scott, Indiana, US | |
2491154 | 2491154 | 2022-06-29 | US | Indiana | Scott | 18143 | 8148 | 108 | 0 | 38.68672078 | -85.74627859 | 2022-06-30 04:21:01 | Scott, Indiana, US | |
560387 | 560387 | 2022-06-16 | US | Maryland | Dorchester | 24019 | 8148 | 109 | 0 | 38.45413522 | -76.02752426 | 2022-06-17 04:20:56 | Dorchester, Maryland, US | |
3985334 | 3985334 | 2022-06-15 | US | Puerto Rico | Cabo Rojo | 72023 | 8148 | 0 | 0 | 18.040993 | -67.154391 | 2022-06-16 04:20:55 | Cabo Rojo, Puerto Rico, US | |
950350 | 950350 | 2022-06-14 | US | West Virginia | Mingo | 54059 | 8148 | 124 | 0 | 37.73048351 | -82.13338365 | 2022-06-15 04:20:54 | Mingo, West Virginia, US | |
948979 | 948979 | 2022-06-14 | US | Nebraska | Unassigned | 90031 | 8148 | 860 | 0 | 42.8997274 | 0.0 | 2022-06-15 04:20:54 | Unassigned, Nebraska, US | |
1421622 | 1421622 | 2022-06-08 | US | Arkansas | Poinsett | 5111 | 8148 | 127 | 0 | 35.57433534 | -90.66268713 | 2022-06-09 04:20:54 | Poinsett, Arkansas, US | |
3727859 | 3727859 | 2022-06-07 | US | Michigan | Houghton | 26061 | 8148 | 95 | 0 | 46.89988536 | -88.68495385 | 2022-06-08 04:20:55 | Houghton, Michigan, US | |
3889261 | 3889261 | 2022-06-06 | US | Michigan | Houghton | 26061 | 8148 | 95 | 0 | 46.89988536 | -88.68495385 | 2022-06-07 04:21:08 | Houghton, Michigan, US | |
3509030 | 3509030 | 2022-06-05 | US | Michigan | Houghton | 26061 | 8148 | 95 | 0 | 46.89988536 | -88.68495385 | 2022-06-06 04:20:57 | Houghton, Michigan, US | |
3529107 | 3529107 | 2022-06-04 | US | Michigan | Houghton | 26061 | 8148 | 95 | 0 | 46.89988536 | -88.68495385 | 2022-06-05 04:20:55 | Houghton, Michigan, US | |
3135193 | 3135193 | 2022-06-03 | US | Michigan | Houghton | 26061 | 8148 | 95 | 0 | 46.89988536 | -88.68495385 | 2022-06-04 04:20:58 | Houghton, Michigan, US | |
3580268 | 3580268 | 2022-06-02 | US | Michigan | Houghton | 26061 | 8148 | 95 | 0 | 46.89988536 | -88.68495385 | 2022-06-03 04:20:58 | Houghton, Michigan, US | |
972561 | 972561 | 2022-06-01 | US | Michigan | Houghton | 26061 | 8148 | 95 | 0 | 46.89988536 | -88.68495385 | 2022-06-02 05:20:39 | Houghton, Michigan, US | |
3002805 | 3002805 | 2022-05-24 | US | West Virginia | Mineral | 54057 | 8148 | 157 | 0 | 39.41561583 | -78.94104895 | 2022-05-25 04:20:56 | Mineral, West Virginia, US | |
1907883 | 1907883 | 2022-03-22 | US | Pennsylvania | McKean | 42083 | 8148 | 138 | 0 | 41.80938602 | -78.56478358 | 2022-03-23 04:20:48 | McKean, Pennsylvania, US | |
2528389 | 2528389 | 2022-03-02 | US | Texas | Bee | 48025 | 8148 | 149 | 0 | 28.41761668 | -97.74215593 | 2022-03-03 04:21:01 | Bee, Texas, US | |
1514039 | 1514039 | 2022-02-24 | US | Oregon | Malheur | 41045 | 8148 | 101 | 0 | 43.1937027 | -117.62273950000001 | 2022-02-25 04:21:11 | Malheur, Oregon, US | |
1513912 | 1513912 | 2022-02-24 | US | Ohio | Perry | 39127 | 8148 | 124 | 0 | 39.73508655 | -82.23804971 | 2022-02-25 04:21:11 | Perry, Ohio, US | |
3912879 | 3912879 | 2022-02-20 | US | Georgia | Pickens | 13227 | 8148 | 154 | 0 | 34.46589159 | -84.46406611 | 2022-02-21 04:21:05 | Pickens, Georgia, US | |
3876437 | 3876437 | 2022-02-19 | US | Georgia | Pickens | 13227 | 8148 | 154 | 0 | 34.46589159 | -84.46406611 | 2022-02-20 04:21:00 | Pickens, Georgia, US | |
3856693 | 3856693 | 2022-02-18 | US | Georgia | Pickens | 13227 | 8148 | 154 | 0 | 34.46589159 | -84.46406611 | 2022-02-19 04:21:11 | Pickens, Georgia, US | |
318591 | 318591 | 2022-02-12 | US | Pennsylvania | Greene | 42059 | 8148 | 96 | 0 | 39.85746531 | -80.22357106 | 2022-02-13 04:21:00 | Greene, Pennsylvania, US | |
3076157 | 3076157 | 2022-02-09 | US | Nebraska | Platte | 31141 | 8148 | 50 | 0 | 41.57246836 | -97.52144359 | 2022-02-10 04:21:14 | Platte, Nebraska, US | |
3614924 | 3614924 | 2022-01-12 | US | Mississippi | Warren | 28149 | 8148 | 181 | 0 | 32.35810271 | -90.83352619 | 2022-01-13 08:00:09 | Warren, Mississippi, US | |
1435081 | 1435081 | 2021-12-28 | US | Ohio | Shelby | 39149 | 8148 | 157 | 0 | 40.33163494 | -84.20258189 | 2021-12-29 03:21:43 | Shelby, Ohio, US | |
1255539 | 1255539 | 2021-12-20 | US | Georgia | Camden | 13039 | 8148 | 97 | 0 | 30.92951916 | -81.66601818 | 2021-12-21 03:21:27 | Camden, Georgia, US | |
152300 | 152300 | 2021-11-29 | US | North Carolina | Edgecombe | 37065 | 8148 | 127 | 0 | 35.91230639 | -77.59436892 | 2021-11-30 04:22:53 | Edgecombe, North Carolina, US | |
1016656 | 1016656 | 2021-11-21 | US | North Carolina | Granville | 37077 | 8148 | 104 | 0 | 36.30337451 | -78.65184241 | 2021-11-22 04:22:20 | Granville, North Carolina, US | |
724820 | 724820 | 2021-11-20 | US | North Carolina | Granville | 37077 | 8148 | 104 | 0 | 36.30337451 | -78.65184241 | 2021-11-21 04:22:13 | Granville, North Carolina, US | |
164350 | 164350 | 2021-11-19 | US | North Carolina | Granville | 37077 | 8148 | 104 | 0 | 36.30337451 | -78.65184241 | 2021-11-20 04:22:17 | Granville, North Carolina, US | |
498081 | 498081 | 2021-11-06 | US | North Dakota | Stark | 38089 | 8148 | 70 | 0 | 46.80851182 | -102.65763259999999 | 2021-11-07 04:21:53 | Stark, North Dakota, US | |
277604 | 277604 | 2021-11-03 | US | Kentucky | Jessamine | 21113 | 8148 | 95 | 0 | 37.87119786 | -84.58252003 | 2021-11-04 04:22:20 | Jessamine, Kentucky, US | |
469653 | 469653 | 2021-10-07 | US | New York | Jefferson | 36045 | 8148 | 72 | 0 | 44.04200959 | -75.94653457 | 2021-10-08 04:21:25 | Jefferson, New York, US | |
3012868 | 3012868 | 2021-09-22 | US | Louisiana | St. Martin | 22099 | 8148 | 157 | 0 | 30.13112107 | -91.61403569 | 2021-09-23 04:21:43 | St. Martin, Louisiana, US | |
3759937 | 3759937 | 2021-09-21 | US | Ohio | Geauga | 39055 | 8148 | 157 | 0 | 41.49952319 | -81.17935342 | 2021-09-22 04:21:45 | Geauga, Ohio, US | |
1387551 | 1387551 | 2021-09-13 | US | Missouri | Lincoln | 29113 | 8148 | 56 | 0 | 39.05345619 | -90.95588181 | 2021-09-14 04:21:41 | Lincoln, Missouri, US | |
252237 | 252237 | 2021-09-04 | US | Tennessee | Jefferson | 47089 | 8148 | 132 | 0 | 36.04818632 | -83.45148924 | 2021-09-05 04:21:33 | Jefferson, Tennessee, US | |
69878 | 69878 | 2021-09-01 | US | South Carolina | Georgetown | 45043 | 8148 | 153 | 0 | 33.43443342 | -79.33202141 | 2021-09-02 04:21:15 | Georgetown, South Carolina, US | |
2178480 | 2178480 | 2021-08-22 | US | Tennessee | Cumberland | 47035 | 8148 | 151 | 0 | 35.95271721 | -84.99840585 | 2021-08-23 04:21:27 | Cumberland, Tennessee, US | |
105686 | 105686 | 2021-08-15 | US | North Carolina | Rutherford | 37161 | 8148 | 224 | 0 | 35.40114178 | -81.92112099 | 2021-08-16 04:21:31 | Rutherford, North Carolina, US | |
510044 | 510044 | 2021-08-14 | US | North Carolina | Rutherford | 37161 | 8148 | 224 | 0 | 35.40114178 | -81.92112099 | 2021-08-15 04:21:41 | Rutherford, North Carolina, US | |
1485916 | 1485916 | 2021-08-13 | US | North Carolina | Rutherford | 37161 | 8148 | 224 | 0 | 35.40114178 | -81.92112099 | 2021-08-14 04:21:25 | Rutherford, North Carolina, US | |
593148 | 593148 | 2021-08-08 | US | West Virginia | Wood | 54107 | 8148 | 177 | 0 | 39.20967886 | -81.5162836 | 2021-08-09 04:21:24 | Wood, West Virginia, US | |
2207160 | 2207160 | 2021-08-07 | US | West Virginia | Wood | 54107 | 8148 | 177 | 0 | 39.20967886 | -81.5162836 | 2021-08-08 04:21:33 | Wood, West Virginia, US | |
1121110 | 1121110 | 2021-08-06 | US | West Virginia | Wood | 54107 | 8148 | 177 | 0 | 39.20967886 | -81.5162836 | 2021-08-07 04:21:30 | Wood, West Virginia, US | |
3476732 | 3476732 | 2021-07-22 | US | Alaska | Fairbanks North Star | 2090 | 8148 | 44 | 0 | 64.80726247 | -146.5692662 | 2021-07-23 04:21:29 | Fairbanks North Star, Alaska, US | |
3331951 | 3331951 | 2021-07-21 | US | Alaska | Fairbanks North Star | 2090 | 8148 | 44 | 0 | 64.80726247 | -146.5692662 | 2021-07-22 04:21:19 | Fairbanks North Star, Alaska, US | |
2674268 | 2674268 | 2021-07-18 | US | Arizona | Santa Cruz | 4023 | 8148 | 181 | 0 | 31.52508998 | -110.8479088 | 2021-07-19 04:21:24 | Santa Cruz, Arizona, US | |
628574 | 628574 | 2021-07-10 | US | Pennsylvania | Somerset | 42111 | 8148 | 218 | 0 | 39.97172723 | -79.02699593 | 2021-07-11 04:21:43 | Somerset, Pennsylvania, US | |
2590518 | 2590518 | 2021-06-27 | US | Arkansas | Pope | 5115 | 8148 | 110 | 0 | 35.44871474 | -93.03212219 | 2021-06-28 04:21:29 | Pope, Arkansas, US | |
3959022 | 3959022 | 2021-06-26 | US | Arkansas | Pope | 5115 | 8148 | 110 | 0 | 35.44871474 | -93.03212219 | 2021-06-27 04:21:39 | Pope, Arkansas, US | |
1712841 | 1712841 | 2021-06-25 | US | Arkansas | Pope | 5115 | 8148 | 110 | 0 | 35.44871474 | -93.03212219 | 2021-06-26 04:21:43 | Pope, Arkansas, US | |
3475901 | 3475901 | 2021-06-08 | US | Wyoming | Natrona | 56025 | 8148 | 138 | 0 | 42.96180148 | -106.797885 | 2021-06-09 04:23:31 | Natrona, Wyoming, US | |
3473357 | 3473357 | 2021-06-08 | US | Indiana | Bartholomew | 18005 | 8148 | 156 | 0 | 39.20744865 | -85.89558181 | 2021-06-09 04:23:31 | Bartholomew, Indiana, US | |
2005463 | 2005463 | 2021-05-12 | US | Georgia | Gordon | 13129 | 8148 | 116 | 0 | 34.50487351 | -84.87296253 | 2021-05-13 04:20:51 | Gordon, Georgia, US | |
3957307 | 3957307 | 2021-05-11 | US | South Carolina | Greenwood | 45047 | 8148 | 173 | 0 | 34.15272415 | -82.12715789 | 2021-05-12 04:21:29 | Greenwood, South Carolina, US | |
2411559 | 2411559 | 2021-04-19 | US | Florida | Nassau | 12089 | 8148 | 124 | 0 | 30.61037141 | -81.80297522 | 2021-04-20 04:20:41 | Nassau, Florida, US | |
3004928 | 3004928 | 2021-04-06 | US | Michigan | Eaton | 26045 | 8148 | 163 | 0 | 42.59599185 | -84.83740035 | 2021-04-07 04:20:53 | Eaton, Michigan, US | |
1538091 | 1538091 | 2021-03-28 | US | New Jersey | Hunterdon | 34019 | 8148 | 169 | 0 | 40.56335249 | -74.91284156 | 2021-03-29 04:28:35 | Hunterdon, New Jersey, US | |
2485531 | 2485531 | 2021-01-28 | US | Wisconsin | Ozaukee | 55089 | 8148 | 78 | 0 | 8070 | 43.38352225 | -87.94625009 | 2021-01-29 05:22:23 | Ozaukee, Wisconsin, US |
911638 | 911638 | 2021-01-19 | US | West Virginia | Berkeley | 54003 | 8148 | 72 | 0 | 8076 | 39.46704621 | -78.02414609 | 2021-01-20 05:21:54 | Berkeley, West Virginia, US |
776716 | 776716 | 2021-01-12 | US | North Carolina | Wayne | 37191 | 8148 | 156 | 0 | 7992 | 35.36438125 | -78.00027268 | 2021-01-13 05:22:15 | Wayne, North Carolina, US |
156480 | 156480 | 2021-01-08 | US | Ohio | Richland | 39139 | 8148 | 158 | 0 | 7990 | 40.77180308 | -82.53799609999999 | 2021-01-09 05:22:18 | Richland, Ohio, US |
2865152 | 2865152 | 2021-01-06 | US | Arizona | Cochise | 4003 | 8148 | 144 | 0 | 8004 | 31.87934684 | -109.7516088 | 2021-01-07 05:22:03 | Cochise, Arizona, US |
768956 | 768956 | 2020-12-29 | US | Pennsylvania | Beaver | 42007 | 8148 | 242 | 0 | 7906 | 40.6825484 | -80.34921611 | 2020-12-30 05:22:34 | Beaver, Pennsylvania, US |
203252 | 203252 | 2020-12-25 | US | Illinois | Kendall | 17093 | 8148 | 68 | 0 | 8080 | 41.59081014 | -88.42869583 | 2020-12-26 05:22:28 | Kendall, Illinois, US |
202395 | 202395 | 2020-12-25 | Pakistan | Azad Jammu and Kashmir | 8148 | 214 | 7325 | 609 | 34.027401 | 73.947253 | 2020-12-26 05:22:28 | Azad Jammu and Kashmir, Pakistan | ||
3566353 | 3566353 | 2020-11-29 | Chile | Atacama | 8148 | 105 | 7954 | 89 | -27.5661 | -70.0503 | 2020-11-30 05:26:13 | Atacama, Chile | ||
1729058 | 1729058 | 2020-11-08 | US | California | Solano | 6095 | 8148 | 85 | 0 | 8065 | 38.26827353 | -121.9357113 | 2020-11-09 05:25:45 | Solano, California, US |
2657386 | 2657386 | 2020-09-23 | Ukraine | Kiev Oblast | 8148 | 165 | 5053 | 2930 | 50.053 | 30.7667 | 2020-09-24 04:23:00 | Kiev Oblast, Ukraine | ||
2217163 | 2217163 | 2020-08-23 | US | Louisiana | Lafayette | 22055 | 8148 | 106 | 0 | 8042 | 30.2049055 | -92.06959876 | 2020-08-24 04:27:56 | Lafayette, Louisiana, US |
837529 | 837529 | 2020-08-17 | Germany | Rheinland-Pfalz | 8148 | 242 | 7324 | 609 | 50.1183 | 7.309 | 2020-08-18 04:27:56 | Rheinland-Pfalz, Germany | ||
3531535 | 3531535 | 2020-08-12 | Mexico | Hidalgo | 8148 | 1258 | 5936 | 954 | 20.0911 | -98.7624 | 2020-08-13 04:29:15 | Hidalgo, Mexico | ||
176896 | 176896 | 2020-07-27 | US | Illinois | Will | 17197 | 8148 | 338 | 0 | 7810 | 41.44619267 | -87.97862712 | 2020-07-28 04:58:43 | Will, Illinois, US |
3681755 | 3681755 | 2020-06-18 | US | California | San Bernardino | 6071 | 8148 | 226 | 0 | 7921 | 34.84060306 | -116.1774685 | 2020-06-19 04:33:17 | San Bernardino, California, US |
2555905 | 2555905 | 2020-06-02 | Peru | Piura | 8148 | 2313 | 0 | 5835 | -5.133361 | -80.335861 | 2020-06-03 02:33:13 | Piura, Peru |
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]);