johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
134 rows where confirmed = 6058 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1242379 | 1242379 | 2022-11-28 | US | Puerto Rico | Adjuntas | 72001 | 6058 | 0 | 0 | 18.180117 | -66.754367 | 2022-11-29 04:21:05 | Adjuntas, Puerto Rico, US | |
3554367 | 3554367 | 2022-11-27 | US | Puerto Rico | Adjuntas | 72001 | 6058 | 0 | 0 | 18.180117 | -66.754367 | 2022-11-28 04:21:02 | Adjuntas, Puerto Rico, US | |
1623059 | 1623059 | 2022-11-22 | US | Puerto Rico | Santa Isabel | 72133 | 6058 | 0 | 0 | 17.994525 | -66.388913 | 2022-11-23 04:21:06 | Santa Isabel, Puerto Rico, US | |
315454 | 315454 | 2022-11-13 | US | Wisconsin | Green Lake | 55047 | 6058 | 70 | 0 | 43.80025981 | -89.04679553 | 2022-11-14 04:21:09 | Green Lake, Wisconsin, US | |
66615 | 66615 | 2022-11-12 | US | Wisconsin | Green Lake | 55047 | 6058 | 70 | 0 | 43.80025981 | -89.04679553 | 2022-11-13 04:21:14 | Green Lake, Wisconsin, US | |
2930777 | 2930777 | 2022-11-11 | US | Wisconsin | Green Lake | 55047 | 6058 | 70 | 0 | 43.80025981 | -89.04679553 | 2022-11-12 04:20:41 | Green Lake, Wisconsin, US | |
3998230 | 3998230 | 2022-09-27 | US | Wisconsin | Vilas | 55125 | 6058 | 99 | 0 | 46.05467334 | -89.51719204 | 2022-09-28 04:23:01 | Vilas, Wisconsin, US | |
2772558 | 2772558 | 2022-09-26 | US | Wisconsin | Vilas | 55125 | 6058 | 99 | 0 | 46.05467334 | -89.51719204 | 2022-09-27 04:23:01 | Vilas, Wisconsin, US | |
1889622 | 1889622 | 2022-09-14 | US | Arkansas | Conway | 5029 | 6058 | 68 | 0 | 35.26205537 | -92.70506566 | 2022-09-15 04:21:02 | Conway, Arkansas, US | |
375202 | 375202 | 2022-09-13 | US | Tennessee | Unicoi | 47171 | 6058 | 99 | 0 | 36.10890856 | -82.43709629 | 2022-09-14 04:20:44 | Unicoi, Tennessee, US | |
2636799 | 2636799 | 2022-09-05 | US | Texas | Dimmit | 48127 | 6058 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-09-06 04:21:02 | Dimmit, Texas, US | |
2990363 | 2990363 | 2022-09-04 | US | Texas | Dimmit | 48127 | 6058 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-09-05 04:21:01 | Dimmit, Texas, US | |
2716048 | 2716048 | 2022-09-03 | US | Texas | Dimmit | 48127 | 6058 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-09-04 04:21:22 | Dimmit, Texas, US | |
1396753 | 1396753 | 2022-09-02 | US | Texas | Dimmit | 48127 | 6058 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-09-03 04:21:04 | Dimmit, Texas, US | |
2012243 | 2012243 | 2022-08-04 | US | Wisconsin | Iowa | 55049 | 6058 | 30 | 0 | 43.00050278 | -90.13469017 | 2022-08-05 04:20:52 | Iowa, Wisconsin, US | |
1069093 | 1069093 | 2022-07-28 | US | Texas | San Jacinto | 48407 | 6058 | 104 | 0 | 30.57933681 | -95.16260304 | 2022-07-29 04:20:45 | San Jacinto, Texas, US | |
1215050 | 1215050 | 2022-07-11 | US | West Virginia | McDowell | 54047 | 6058 | 77 | 0 | 37.38002939 | -81.65083669 | 2022-07-12 04:20:51 | McDowell, West Virginia, US | |
145028 | 145028 | 2022-07-09 | US | Texas | Calhoun | 48057 | 6058 | 51 | 0 | 28.47048236 | -96.61633945 | 2022-07-10 04:20:54 | Calhoun, Texas, US | |
3967194 | 3967194 | 2022-07-05 | US | Colorado | Morgan | 8087 | 6058 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-07-06 04:20:58 | Morgan, Colorado, US | |
3941651 | 3941651 | 2022-06-30 | US | Maryland | Talbot | 24041 | 6058 | 90 | 0 | 38.76618159 | -76.10882561 | 2022-07-01 04:21:10 | Talbot, Maryland, US | |
2492618 | 2492618 | 2022-06-29 | US | Oklahoma | Texas | 40139 | 6058 | 55 | 0 | 36.74777635 | -101.4889765 | 2022-06-30 04:21:01 | Texas, Oklahoma, US | |
2242000 | 2242000 | 2022-06-28 | US | Oklahoma | Texas | 40139 | 6058 | 55 | 0 | 36.74777635 | -101.4889765 | 2022-06-29 04:20:59 | Texas, Oklahoma, US | |
2150242 | 2150242 | 2022-06-27 | US | Oklahoma | Texas | 40139 | 6058 | 55 | 0 | 36.74777635 | -101.4889765 | 2022-06-28 04:20:58 | Texas, Oklahoma, US | |
478043 | 478043 | 2022-06-26 | US | Oklahoma | Texas | 40139 | 6058 | 55 | 0 | 36.74777635 | -101.4889765 | 2022-06-27 04:21:00 | Texas, Oklahoma, US | |
941418 | 941418 | 2022-06-25 | US | Oklahoma | Texas | 40139 | 6058 | 55 | 0 | 36.74777635 | -101.4889765 | 2022-06-26 04:21:02 | Texas, Oklahoma, US | |
3349238 | 3349238 | 2022-06-24 | US | Oklahoma | Texas | 40139 | 6058 | 55 | 0 | 36.74777635 | -101.4889765 | 2022-06-25 04:20:57 | Texas, Oklahoma, US | |
1650979 | 1650979 | 2022-06-23 | US | Oklahoma | Texas | 40139 | 6058 | 55 | 0 | 36.74777635 | -101.4889765 | 2022-06-24 04:20:58 | Texas, Oklahoma, US | |
3273071 | 3273071 | 2022-06-19 | US | Wisconsin | Kewaunee | 55061 | 6058 | 59 | 0 | 44.51727459 | -87.61468386 | 2022-06-20 04:21:01 | Kewaunee, Wisconsin, US | |
3400983 | 3400983 | 2022-06-18 | US | Wisconsin | Kewaunee | 55061 | 6058 | 59 | 0 | 44.51727459 | -87.61468386 | 2022-06-19 04:20:51 | Kewaunee, Wisconsin, US | |
2314860 | 2314860 | 2022-06-17 | US | Wisconsin | Kewaunee | 55061 | 6058 | 59 | 0 | 44.51727459 | -87.61468386 | 2022-06-18 04:21:10 | Kewaunee, Wisconsin, US | |
3579569 | 3579569 | 2022-06-02 | US | Idaho | Jefferson | 16051 | 6058 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-06-03 04:20:58 | Jefferson, Idaho, US | |
971862 | 971862 | 2022-06-01 | US | Idaho | Jefferson | 16051 | 6058 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-06-02 05:20:39 | Jefferson, Idaho, US | |
2049611 | 2049611 | 2022-05-25 | US | Minnesota | Meeker | 27093 | 6058 | 75 | 0 | 45.12328869 | -94.52839455 | 2022-05-26 04:20:50 | Meeker, Minnesota, US | |
623622 | 623622 | 2022-05-22 | US | Minnesota | Meeker | 27093 | 6058 | 75 | 0 | 45.12328869 | -94.52839455 | 2022-05-26 04:20:50 | Meeker, Minnesota, US | |
3897918 | 3897918 | 2022-05-19 | US | Missouri | Randolph | 29175 | 6058 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-20 04:20:57 | Randolph, Missouri, US | |
1186702 | 1186702 | 2022-05-18 | US | Missouri | Randolph | 29175 | 6058 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-19 04:20:54 | Randolph, Missouri, US | |
3584599 | 3584599 | 2022-05-17 | US | Missouri | Randolph | 29175 | 6058 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-18 04:20:50 | Randolph, Missouri, US | |
1505556 | 1505556 | 2022-05-16 | US | Missouri | Randolph | 29175 | 6058 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-17 04:20:59 | Randolph, Missouri, US | |
2085915 | 2085915 | 2022-05-15 | US | Missouri | Randolph | 29175 | 6058 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-16 04:20:47 | Randolph, Missouri, US | |
3356625 | 3356625 | 2022-05-14 | US | Missouri | Randolph | 29175 | 6058 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-15 04:20:53 | Randolph, Missouri, US | |
660270 | 660270 | 2022-05-13 | US | Missouri | Randolph | 29175 | 6058 | 103 | 0 | 39.44007257 | -92.4971374 | 2022-05-14 04:20:48 | Randolph, Missouri, US | |
1159206 | 1159206 | 2022-04-29 | US | Nebraska | Cass | 31025 | 6058 | 39 | 0 | 40.90899107 | -96.13971217 | 2022-04-30 04:21:05 | Cass, Nebraska, US | |
1698759 | 1698759 | 2022-04-28 | US | North Dakota | Rolette | 38079 | 6058 | 43 | 0 | 48.77245354 | -99.84097493 | 2022-04-29 04:20:59 | Rolette, North Dakota, US | |
1698388 | 1698388 | 2022-04-28 | US | Nebraska | Cass | 31025 | 6058 | 39 | 0 | 40.90899107 | -96.13971217 | 2022-04-29 04:20:59 | Cass, Nebraska, US | |
3853871 | 3853871 | 2022-04-27 | US | Nebraska | Cass | 31025 | 6058 | 39 | 0 | 40.90899107 | -96.13971217 | 2022-04-28 04:20:47 | Cass, Nebraska, US | |
1328301 | 1328301 | 2022-04-26 | US | Nebraska | Cass | 31025 | 6058 | 39 | 0 | 40.90899107 | -96.13971217 | 2022-04-27 04:20:52 | Cass, Nebraska, US | |
1950855 | 1950855 | 2022-04-12 | US | North Carolina | Martin | 37117 | 6058 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-13 04:21:03 | Martin, North Carolina, US | |
3208608 | 3208608 | 2022-04-11 | US | North Carolina | Martin | 37117 | 6058 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-12 04:20:49 | Martin, North Carolina, US | |
1578494 | 1578494 | 2022-04-10 | US | North Carolina | Martin | 37117 | 6058 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-11 04:21:02 | Martin, North Carolina, US | |
1654736 | 1654736 | 2022-04-09 | US | North Carolina | Martin | 37117 | 6058 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-10 04:20:52 | Martin, North Carolina, US | |
2118058 | 2118058 | 2022-04-08 | US | North Carolina | Martin | 37117 | 6058 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-09 04:20:42 | Martin, North Carolina, US | |
3322582 | 3322582 | 2022-04-07 | US | North Carolina | Martin | 37117 | 6058 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-08 04:20:48 | Martin, North Carolina, US | |
2803118 | 2803118 | 2022-04-06 | US | North Carolina | Martin | 37117 | 6058 | 89 | 0 | 35.84326734 | -77.10860251 | 2022-04-07 04:20:53 | Martin, North Carolina, US | |
1469043 | 1469043 | 2022-03-24 | US | Idaho | Jerome | 16053 | 6058 | 64 | 0 | 42.68891267 | -114.2655033 | 2022-03-25 04:20:46 | Jerome, Idaho, US | |
3023217 | 3023217 | 2022-03-23 | US | Idaho | Jerome | 16053 | 6058 | 64 | 0 | 42.68891267 | -114.2655033 | 2022-03-24 04:20:43 | Jerome, Idaho, US | |
3877822 | 3877822 | 2022-02-19 | US | New York | Lewis | 36049 | 6058 | 47 | 0 | 43.784415700000004 | -75.44903992 | 2022-02-20 04:21:00 | Lewis, New York, US | |
3672293 | 3672293 | 2022-02-15 | US | Colorado | Montezuma | 8083 | 6058 | 73 | 0 | 37.33859579 | -108.59588570000001 | 2022-02-16 04:21:10 | Montezuma, Colorado, US | |
3228918 | 3228918 | 2022-01-19 | US | Ohio | Gallia | 39053 | 6058 | 105 | 0 | 38.82708533 | -82.31647569 | 2022-01-20 04:21:07 | Gallia, Ohio, US | |
3688559 | 3688559 | 2022-01-13 | US | Indiana | Daviess | 18027 | 6058 | 126 | 0 | 38.70186039 | -87.07185406 | 2022-01-14 04:21:54 | Daviess, Indiana, US | |
3819851 | 3819851 | 2021-12-23 | US | Virginia | York | 51199 | 6058 | 84 | 0 | 37.24374789 | -76.54412815 | 2021-12-24 04:21:34 | York, Virginia, US | |
3819344 | 3819344 | 2021-12-23 | US | Tennessee | Carroll | 47017 | 6058 | 123 | 0 | 35.97366108 | -88.45189331 | 2021-12-24 04:21:34 | Carroll, Tennessee, US | |
1258034 | 1258034 | 2021-12-20 | US | Texas | Wood | 48499 | 6058 | 236 | 0 | 32.78722382 | -95.38236368 | 2021-12-21 03:21:27 | Wood, Texas, US | |
2907208 | 2907208 | 2021-12-19 | US | West Virginia | Logan | 54045 | 6058 | 150 | 0 | 37.8299889 | -81.93528571 | 2021-12-20 04:21:43 | Logan, West Virginia, US | |
2906913 | 2906913 | 2021-12-19 | US | Texas | Polk | 48373 | 6058 | 219 | 0 | 30.79472531 | -94.82766240000001 | 2021-12-20 04:21:43 | Polk, Texas, US | |
1717344 | 1717344 | 2021-12-16 | US | Illinois | Fulton | 17057 | 6058 | 88 | 0 | 40.47289135 | -90.20862357 | 2021-12-17 04:22:14 | Fulton, Illinois, US | |
3498802 | 3498802 | 2021-12-15 | US | Oregon | Coos | 41011 | 6058 | 114 | 0 | 43.17406868 | -124.0594514 | 2021-12-16 04:22:11 | Coos, Oregon, US | |
1743586 | 1743586 | 2021-12-05 | US | Texas | Cherokee | 48073 | 6058 | 228 | 0 | 31.837258000000002 | -95.16559897 | 2021-12-06 04:22:34 | Cherokee, Texas, US | |
141018 | 141018 | 2021-12-04 | US | Texas | Cherokee | 48073 | 6058 | 228 | 0 | 31.837258000000002 | -95.16559897 | 2021-12-05 04:22:25 | Cherokee, Texas, US | |
2198671 | 2198671 | 2021-12-03 | US | Texas | Cherokee | 48073 | 6058 | 228 | 0 | 31.837258000000002 | -95.16559897 | 2021-12-04 04:22:18 | Cherokee, Texas, US | |
2197198 | 2197198 | 2021-12-03 | US | Maryland | Calvert | 24009 | 6058 | 102 | 0 | 38.53961642 | -76.56820632 | 2021-12-04 04:22:18 | Calvert, Maryland, US | |
687497 | 687497 | 2021-11-13 | US | Indiana | Steuben | 18151 | 6058 | 81 | 0 | 41.64423868 | -85.00101094 | 2021-11-14 04:21:31 | Steuben, Indiana, US | |
3641503 | 3641503 | 2021-11-08 | US | Missouri | Platte | 29165 | 6058 | 61 | 0 | 39.38154439 | -94.77068479 | 2021-11-09 04:21:36 | Platte, Missouri, US | |
3514743 | 3514743 | 2021-11-01 | US | Virginia | Franklin | 51067 | 6058 | 106 | 0 | 36.99536167 | -79.88023649 | 2021-11-02 04:22:03 | Franklin, Virginia, US | |
600914 | 600914 | 2021-10-19 | US | Texas | Upshur | 48459 | 6058 | 136 | 0 | 32.73706798 | -94.93999853 | 2021-10-20 04:21:00 | Upshur, Texas, US | |
2461798 | 2461798 | 2021-10-06 | US | Tennessee | Weakley | 47183 | 6058 | 83 | 0 | 36.29896232 | -88.71990865 | 2021-10-07 04:21:36 | Weakley, Tennessee, US | |
3930554 | 3930554 | 2021-10-02 | US | Ohio | Shelby | 39149 | 6058 | 115 | 0 | 40.33163494 | -84.20258189 | 2021-10-03 04:21:24 | Shelby, Ohio, US | |
709244 | 709244 | 2021-09-29 | US | South Carolina | Chester | 45023 | 6058 | 100 | 0 | 34.69249168 | -81.1583216 | 2021-09-30 04:21:20 | Chester, South Carolina, US | |
1336713 | 1336713 | 2021-09-28 | US | North Dakota | Williams | 38105 | 6058 | 43 | 0 | 48.34522353 | -103.4793387 | 2021-09-29 04:21:45 | Williams, North Dakota, US | |
1814799 | 1814799 | 2021-09-19 | Japan | Miyazaki | 6058 | 39 | 0 | 32.193203999999994 | 131.299374 | 2021-09-20 04:21:22 | Miyazaki, Japan | |||
1263476 | 1263476 | 2021-09-09 | US | Florida | DeSoto | 12027 | 6058 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-09-10 04:21:20 | DeSoto, Florida, US | |
2279846 | 2279846 | 2021-09-08 | US | Florida | DeSoto | 12027 | 6058 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-09-09 04:21:27 | DeSoto, Florida, US | |
642625 | 642625 | 2021-09-07 | US | Florida | DeSoto | 12027 | 6058 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-09-08 04:21:31 | DeSoto, Florida, US | |
3194688 | 3194688 | 2021-09-06 | US | Florida | DeSoto | 12027 | 6058 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-09-07 04:21:35 | DeSoto, Florida, US | |
3281556 | 3281556 | 2021-09-05 | US | Florida | DeSoto | 12027 | 6058 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-09-06 04:21:22 | DeSoto, Florida, US | |
249970 | 249970 | 2021-09-04 | US | Florida | DeSoto | 12027 | 6058 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-09-05 04:21:33 | DeSoto, Florida, US | |
3975966 | 3975966 | 2021-09-03 | US | Kentucky | Graves | 21083 | 6058 | 108 | 0 | 36.72292505 | -88.65143315 | 2021-09-04 04:21:28 | Graves, Kentucky, US | |
3975251 | 3975251 | 2021-09-03 | US | Florida | DeSoto | 12027 | 6058 | 97 | 0 | 27.18677893 | -81.80941373 | 2021-09-04 04:21:28 | DeSoto, Florida, US | |
105073 | 105073 | 2021-08-15 | US | Minnesota | Otter Tail | 27111 | 6058 | 88 | 0 | 46.40846929 | -95.70835255 | 2021-08-16 04:21:31 | Otter Tail, Minnesota, US | |
509431 | 509431 | 2021-08-14 | US | Minnesota | Otter Tail | 27111 | 6058 | 88 | 0 | 46.40846929 | -95.70835255 | 2021-08-15 04:21:41 | Otter Tail, Minnesota, US | |
1485303 | 1485303 | 2021-08-13 | US | Minnesota | Otter Tail | 27111 | 6058 | 88 | 0 | 46.40846929 | -95.70835255 | 2021-08-14 04:21:25 | Otter Tail, Minnesota, US | |
3469253 | 3469253 | 2021-08-03 | US | Indiana | Dearborn | 18029 | 6058 | 78 | 0 | 39.14647946 | -84.97333539 | 2021-08-04 04:21:25 | Dearborn, Indiana, US | |
3684568 | 3684568 | 2021-08-02 | US | Indiana | Noble | 18113 | 6058 | 91 | 0 | 41.39672484 | -85.41966713 | 2021-08-03 04:21:39 | Noble, Indiana, US | |
409282 | 409282 | 2021-07-28 | US | Illinois | Grundy | 17063 | 6058 | 79 | 0 | 41.28569601 | -88.41905692 | 2021-07-29 04:21:33 | Grundy, Illinois, US | |
1333218 | 1333218 | 2021-07-24 | US | Tennessee | Monroe | 47123 | 6058 | 98 | 0 | 35.44550387 | -84.24902965 | 2021-07-25 04:22:12 | Monroe, Tennessee, US | |
2426413 | 2426413 | 2021-06-23 | US | Wisconsin | Barron | 55005 | 6058 | 86 | 0 | 45.42372701 | -91.84833627 | 2021-06-24 04:21:55 | Barron, Wisconsin, US | |
22605 | 22605 | 2021-05-28 | US | New York | Jefferson | 36045 | 6058 | 68 | 0 | 44.04200959 | -75.94653457 | 2021-05-29 04:20:41 | Jefferson, New York, US | |
2257433 | 2257433 | 2021-05-19 | US | Minnesota | Chisago | 27025 | 6058 | 51 | 0 | 45.5021011 | -92.90861945 | 2021-05-20 04:21:05 | Chisago, Minnesota, US | |
2005938 | 2005938 | 2021-05-12 | US | Kansas | Finney | 20055 | 6058 | 71 | 0 | 38.04340344 | -100.7381938 | 2021-05-13 04:20:51 | Finney, Kansas, US | |
3955769 | 3955769 | 2021-05-11 | US | Kansas | Finney | 20055 | 6058 | 71 | 0 | 38.04340344 | -100.7381938 | 2021-05-12 04:21:29 | Finney, Kansas, US | |
2822048 | 2822048 | 2021-05-10 | US | Kansas | Finney | 20055 | 6058 | 71 | 0 | 38.04340344 | -100.7381938 | 2021-05-11 04:20:41 | Finney, Kansas, 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]);