johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
135 rows where confirmed = 5582 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
690906 | 690906 | 2022-12-23 | US | Arkansas | Sharp | 5135 | 5582 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-12-24 04:21:02 | Sharp, Arkansas, US | |
1830959 | 1830959 | 2022-10-25 | US | Georgia | Fannin | 13111 | 5582 | 175 | 0 | 34.86430205 | -84.316964 | 2022-10-26 04:22:19 | Fannin, Georgia, US | |
795392 | 795392 | 2022-10-24 | US | Illinois | Clay | 17025 | 5582 | 73 | 0 | 38.75388572 | -88.48914513 | 2022-10-25 04:21:53 | Clay, Illinois, US | |
795220 | 795220 | 2022-10-24 | US | Georgia | Fannin | 13111 | 5582 | 175 | 0 | 34.86430205 | -84.316964 | 2022-10-25 04:21:53 | Fannin, Georgia, US | |
3278298 | 3278298 | 2022-10-23 | US | Kentucky | Knott | 21119 | 5582 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-10-24 04:22:29 | Knott, Kentucky, US | |
3277675 | 3277675 | 2022-10-23 | US | Georgia | Fannin | 13111 | 5582 | 175 | 0 | 34.86430205 | -84.316964 | 2022-10-24 04:22:29 | Fannin, Georgia, US | |
3277493 | 3277493 | 2022-10-23 | US | Colorado | Elbert | 8039 | 5582 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-24 04:22:29 | Elbert, Colorado, US | |
2269336 | 2269336 | 2022-10-22 | US | Kentucky | Knott | 21119 | 5582 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-10-23 04:22:46 | Knott, Kentucky, US | |
2268713 | 2268713 | 2022-10-22 | US | Georgia | Fannin | 13111 | 5582 | 175 | 0 | 34.86430205 | -84.316964 | 2022-10-23 04:22:46 | Fannin, Georgia, US | |
2268531 | 2268531 | 2022-10-22 | US | Colorado | Elbert | 8039 | 5582 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-23 04:22:46 | Elbert, Colorado, US | |
1593636 | 1593636 | 2022-10-21 | US | Kentucky | Knott | 21119 | 5582 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-10-22 04:22:53 | Knott, Kentucky, US | |
1593013 | 1593013 | 2022-10-21 | US | Georgia | Fannin | 13111 | 5582 | 175 | 0 | 34.86430205 | -84.316964 | 2022-10-22 04:22:53 | Fannin, Georgia, US | |
1592831 | 1592831 | 2022-10-21 | US | Colorado | Elbert | 8039 | 5582 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-22 04:22:53 | Elbert, Colorado, US | |
2273352 | 2273352 | 2022-10-20 | US | Kentucky | Knott | 21119 | 5582 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-10-21 04:22:23 | Knott, Kentucky, US | |
2272729 | 2272729 | 2022-10-20 | US | Georgia | Fannin | 13111 | 5582 | 175 | 0 | 34.86430205 | -84.316964 | 2022-10-21 04:22:23 | Fannin, Georgia, US | |
199687 | 199687 | 2022-10-19 | US | Kentucky | Knott | 21119 | 5582 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-10-20 04:22:59 | Knott, Kentucky, US | |
199064 | 199064 | 2022-10-19 | US | Georgia | Fannin | 13111 | 5582 | 175 | 0 | 34.86430205 | -84.316964 | 2022-10-20 04:22:59 | Fannin, Georgia, US | |
2758348 | 2758348 | 2022-10-18 | US | Kentucky | Knott | 21119 | 5582 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-10-19 04:22:26 | Knott, Kentucky, US | |
2026182 | 2026182 | 2022-10-17 | US | Kentucky | Knott | 21119 | 5582 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-10-18 04:22:42 | Knott, Kentucky, US | |
3756191 | 3756191 | 2022-10-13 | US | Puerto Rico | Adjuntas | 72001 | 5582 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-14 04:22:28 | Adjuntas, Puerto Rico, US | |
3215275 | 3215275 | 2022-10-12 | US | Illinois | Clark | 17023 | 5582 | 53 | 0 | 39.33425789 | -87.78705622 | 2022-10-13 04:22:39 | Clark, Illinois, US | |
1562574 | 1562574 | 2022-09-28 | US | Ohio | Holmes | 39075 | 5582 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-29 04:22:34 | Holmes, Ohio, US | |
3997117 | 3997117 | 2022-09-27 | US | Ohio | Holmes | 39075 | 5582 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-28 04:23:01 | Holmes, Ohio, US | |
2771445 | 2771445 | 2022-09-26 | US | Ohio | Holmes | 39075 | 5582 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-27 04:23:01 | Holmes, Ohio, US | |
1979098 | 1979098 | 2022-09-25 | US | Ohio | Holmes | 39075 | 5582 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-26 04:20:52 | Holmes, Ohio, US | |
2652569 | 2652569 | 2022-09-24 | US | Puerto Rico | Santa Isabel | 72133 | 5582 | 0 | 0 | 17.994525 | -66.388913 | 2022-09-25 04:23:31 | Santa Isabel, Puerto Rico, US | |
2652265 | 2652265 | 2022-09-24 | US | Ohio | Holmes | 39075 | 5582 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-25 04:23:31 | Holmes, Ohio, US | |
386705 | 386705 | 2022-09-23 | US | Ohio | Holmes | 39075 | 5582 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-24 04:21:40 | Holmes, Ohio, US | |
1626771 | 1626771 | 2022-09-22 | US | Ohio | Holmes | 39075 | 5582 | 188 | 0 | 40.56163713 | -81.92635677 | 2022-09-23 04:23:13 | Holmes, Ohio, US | |
2017851 | 2017851 | 2022-09-20 | US | Indiana | Orange | 18117 | 5582 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-09-21 04:23:22 | Orange, Indiana, US | |
3571724 | 3571724 | 2022-09-19 | US | Indiana | Orange | 18117 | 5582 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-09-20 04:22:48 | Orange, Indiana, US | |
3908468 | 3908468 | 2022-08-11 | US | Arkansas | Ashley | 5003 | 5582 | 73 | 0 | 33.19153461 | -91.7698471 | 2022-08-12 04:20:54 | Ashley, Arkansas, US | |
1088387 | 1088387 | 2022-08-09 | US | North Carolina | Currituck | 37053 | 5582 | 38 | 0 | 36.36123664 | -75.95876401 | 2022-08-10 04:20:57 | Currituck, North Carolina, US | |
3545802 | 3545802 | 2022-08-08 | US | North Carolina | Currituck | 37053 | 5582 | 38 | 0 | 36.36123664 | -75.95876401 | 2022-08-09 04:20:34 | Currituck, North Carolina, US | |
1072205 | 1072205 | 2022-08-07 | US | North Carolina | Currituck | 37053 | 5582 | 38 | 0 | 36.36123664 | -75.95876401 | 2022-08-08 04:21:08 | Currituck, North Carolina, US | |
1942793 | 1942793 | 2022-08-06 | US | North Carolina | Currituck | 37053 | 5582 | 38 | 0 | 36.36123664 | -75.95876401 | 2022-08-07 04:20:54 | Currituck, North Carolina, US | |
882592 | 882592 | 2022-08-05 | US | North Carolina | Currituck | 37053 | 5582 | 38 | 0 | 36.36123664 | -75.95876401 | 2022-08-06 04:20:56 | Currituck, North Carolina, US | |
2011003 | 2011003 | 2022-08-04 | US | North Carolina | Currituck | 37053 | 5582 | 38 | 0 | 36.36123664 | -75.95876401 | 2022-08-05 04:20:52 | Currituck, North Carolina, US | |
1100430 | 1100430 | 2022-08-03 | US | North Carolina | Currituck | 37053 | 5582 | 38 | 0 | 36.36123664 | -75.95876401 | 2022-08-04 04:20:58 | Currituck, North Carolina, US | |
3109880 | 3109880 | 2022-07-13 | US | Alabama | Monroe | 1099 | 5582 | 81 | 0 | 31.56729412 | -87.36995001 | 2022-07-14 04:20:57 | Monroe, Alabama, US | |
2490490 | 2490490 | 2022-06-29 | US | Arkansas | Clark | 5019 | 5582 | 82 | 0 | 34.04613432 | -93.17484713 | 2022-06-30 04:21:01 | Clark, Arkansas, US | |
3983621 | 3983621 | 2022-06-15 | US | Illinois | Lawrence | 17101 | 5582 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-06-16 04:20:55 | Lawrence, Illinois, US | |
1505090 | 1505090 | 2022-05-16 | US | Louisiana | Assumption | 22007 | 5582 | 70 | 0 | 29.89946234 | -91.06461642 | 2022-05-17 04:20:59 | Assumption, Louisiana, US | |
1574916 | 1574916 | 2022-05-03 | US | Puerto Rico | San Lorenzo | 72129 | 5582 | 0 | 0 | 18.147987 | -65.976392 | 2022-05-04 04:20:59 | San Lorenzo, Puerto Rico, US | |
2752275 | 2752275 | 2022-04-04 | US | Virginia | Page | 51139 | 5582 | 119 | 0 | 38.61807452 | -78.48797204 | 2022-04-05 04:20:48 | Page, Virginia, US | |
1543140 | 1543140 | 2022-03-31 | US | Texas | Moore | 48341 | 5582 | 110 | 0 | 35.83769242 | -101.8930281 | 2022-04-01 04:20:28 | Moore, Texas, US | |
3025771 | 3025771 | 2022-03-23 | US | West Virginia | McDowell | 54047 | 5582 | 67 | 0 | 37.38002939 | -81.65083669 | 2022-03-24 04:20:43 | McDowell, West Virginia, US | |
3629637 | 3629637 | 2022-03-13 | US | Michigan | Otsego | 26137 | 5582 | 96 | 0 | 45.02085831 | -84.59898295 | 2022-03-14 04:20:46 | Otsego, Michigan, US | |
3627790 | 3627790 | 2022-03-13 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-14 04:20:46 | Guaviare, Colombia | |||
952545 | 952545 | 2022-03-12 | US | Michigan | Otsego | 26137 | 5582 | 96 | 0 | 45.02085831 | -84.59898295 | 2022-03-13 04:20:49 | Otsego, Michigan, US | |
950698 | 950698 | 2022-03-12 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-13 04:20:49 | Guaviare, Colombia | |||
358006 | 358006 | 2022-03-11 | US | Michigan | Otsego | 26137 | 5582 | 96 | 0 | 45.02085831 | -84.59898295 | 2022-03-12 04:20:50 | Otsego, Michigan, US | |
356159 | 356159 | 2022-03-11 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-12 04:20:50 | Guaviare, Colombia | |||
1865311 | 1865311 | 2022-03-10 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-11 04:20:50 | Guaviare, Colombia | |||
2140006 | 2140006 | 2022-03-09 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-10 04:20:48 | Guaviare, Colombia | |||
919517 | 919517 | 2022-03-08 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-09 04:20:59 | Guaviare, Colombia | |||
1547804 | 1547804 | 2022-03-07 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-08 04:20:54 | Guaviare, Colombia | |||
2199473 | 2199473 | 2022-03-06 | Colombia | Guaviare | 5582 | 105 | 0 | 1.0654 | -73.2603 | 2022-03-07 04:20:47 | Guaviare, Colombia | |||
3811888 | 3811888 | 2022-01-28 | US | Missouri | Randolph | 29175 | 5582 | 90 | 0 | 39.44007257 | -92.49713740000001 | 2022-01-29 04:21:10 | Randolph, Missouri, US | |
1142648 | 1142648 | 2022-01-23 | US | Minnesota | Le Sueur | 27079 | 5582 | 46 | 0 | 44.37136597 | -93.72844721 | 2022-01-24 04:21:12 | Le Sueur, Minnesota, US | |
2834566 | 2834566 | 2022-01-22 | US | Minnesota | Le Sueur | 27079 | 5582 | 46 | 0 | 44.37136597 | -93.72844721 | 2022-01-23 04:21:13 | Le Sueur, Minnesota, US | |
3426684 | 3426684 | 2022-01-21 | US | Minnesota | Le Sueur | 27079 | 5582 | 46 | 0 | 44.37136597 | -93.72844721 | 2022-01-22 04:21:13 | Le Sueur, Minnesota, US | |
1962759 | 1962759 | 2022-01-20 | US | New Mexico | Luna | 35029 | 5582 | 110 | 0 | 32.18179341 | -107.75088259999998 | 2022-01-21 04:21:09 | Luna, New Mexico, US | |
1115443 | 1115443 | 2022-01-11 | US | Mississippi | Tippah | 28139 | 5582 | 88 | 0 | 34.76872156 | -88.90988194 | 2022-01-12 04:21:44 | Tippah, Mississippi, US | |
1114243 | 1114243 | 2022-01-11 | US | Colorado | Routt | 8107 | 5582 | 24 | 0 | 40.48596505 | -106.9905548 | 2022-01-12 04:21:44 | Routt, Colorado, US | |
1694184 | 1694184 | 2022-01-10 | US | Mississippi | Yazoo | 28163 | 5582 | 94 | 0 | 32.77890365 | -90.39656148 | 2022-01-11 04:22:01 | Yazoo, Mississippi, US | |
128599 | 128599 | 2022-01-09 | US | Mississippi | Yazoo | 28163 | 5582 | 94 | 0 | 32.77890365 | -90.39656148 | 2022-01-10 04:22:07 | Yazoo, Mississippi, US | |
1217434 | 1217434 | 2022-01-08 | US | Mississippi | Yazoo | 28163 | 5582 | 94 | 0 | 32.77890365 | -90.39656148 | 2022-01-09 04:21:46 | Yazoo, Mississippi, US | |
1391527 | 1391527 | 2022-01-07 | US | Mississippi | Yazoo | 28163 | 5582 | 94 | 0 | 32.77890365 | -90.39656148 | 2022-01-08 04:21:53 | Yazoo, Mississippi, US | |
1287322 | 1287322 | 2022-01-04 | US | Kansas | McPherson | 20113 | 5582 | 107 | 0 | 38.39184858 | -97.64769869 | 2022-01-05 04:21:59 | McPherson, Kansas, US | |
1701666 | 1701666 | 2022-01-03 | US | Kansas | McPherson | 20113 | 5582 | 107 | 0 | 38.39184858 | -97.64769869 | 2022-01-04 04:22:17 | McPherson, Kansas, US | |
1700103 | 1700103 | 2022-01-03 | Canada | Newfoundland and Labrador | 5582 | 20 | 0 | 53.1355 | -57.6604 | 2022-01-04 04:22:17 | Newfoundland and Labrador, Canada | |||
2966510 | 2966510 | 2021-12-24 | US | Texas | Hockley | 48219 | 5582 | 140 | 0 | 33.60771256 | -102.3431676 | 2021-12-25 04:21:37 | Hockley, Texas, US | |
3830110 | 3830110 | 2021-12-21 | US | Michigan | Houghton | 26061 | 5582 | 66 | 0 | 46.89988536 | -88.68495385 | 2021-12-22 04:21:54 | Houghton, Michigan, US | |
1256413 | 1256413 | 2021-12-20 | US | Michigan | Houghton | 26061 | 5582 | 66 | 0 | 46.89988536 | -88.68495385 | 2021-12-21 03:21:27 | Houghton, Michigan, US | |
1719206 | 1719206 | 2021-12-16 | US | South Dakota | Brookings | 46011 | 5582 | 41 | 0 | 44.36974375 | -96.79079945 | 2021-12-17 04:22:14 | Brookings, South Dakota, US | |
3499021 | 3499021 | 2021-12-15 | US | South Carolina | Marion | 45067 | 5582 | 143 | 0 | 34.07859748 | -79.36400756 | 2021-12-16 04:22:11 | Marion, South Carolina, US | |
3640412 | 3640412 | 2021-11-08 | US | Georgia | Pickens | 13227 | 5582 | 119 | 0 | 34.46589159 | -84.46406611 | 2021-11-09 04:21:36 | Pickens, Georgia, US | |
2001520 | 2001520 | 2021-11-07 | US | Georgia | Pickens | 13227 | 5582 | 119 | 0 | 34.46589159 | -84.46406611 | 2021-11-08 04:21:43 | Pickens, Georgia, US | |
496511 | 496511 | 2021-11-06 | US | Georgia | Pickens | 13227 | 5582 | 119 | 0 | 34.46589159 | -84.46406611 | 2021-11-07 04:21:53 | Pickens, Georgia, US | |
3122366 | 3122366 | 2021-11-05 | US | Georgia | Pickens | 13227 | 5582 | 119 | 0 | 34.46589159 | -84.46406611 | 2021-11-06 04:21:51 | Pickens, Georgia, US | |
698678 | 698678 | 2021-11-04 | San Marino | 5582 | 92 | 0 | 43.9424 | 12.4578 | 2021-11-05 04:21:54 | San Marino | ||||
5385 | 5385 | 2021-10-28 | US | Illinois | Randolph | 17157 | 5582 | 101 | 0 | 38.05095369 | -89.82512254 | 2021-10-29 04:22:03 | Randolph, Illinois, US | |
491388 | 491388 | 2021-10-14 | Canada | New Brunswick | 5582 | 82 | 0 | 46.5653 | -66.4619 | 2021-10-15 04:21:26 | New Brunswick, Canada | |||
636737 | 636737 | 2021-10-13 | US | South Carolina | Colleton | 45029 | 5582 | 188 | 0 | 32.87582989 | -80.67641292 | 2021-10-14 04:21:29 | Colleton, South Carolina, US | |
1335991 | 1335991 | 2021-09-28 | US | Minnesota | Douglas | 27041 | 5582 | 84 | 0 | 45.93348491 | -95.45335469 | 2021-09-29 04:21:45 | Douglas, Minnesota, US | |
1374864 | 1374864 | 2021-09-15 | US | Alabama | Franklin | 1059 | 5582 | 92 | 0 | 34.44235334 | -87.84289505 | 2021-09-16 04:22:19 | Franklin, Alabama, US | |
3452327 | 3452327 | 2021-09-10 | US | West Virginia | Jefferson | 54037 | 5582 | 65 | 0 | 39.30776166 | -77.86014147 | 2021-09-11 04:21:30 | Jefferson, West Virginia, US | |
514382 | 514382 | 2021-08-19 | US | Pennsylvania | Mifflin | 42087 | 5582 | 183 | 0 | 40.61116939 | -77.61070738 | 2021-08-20 04:21:33 | Mifflin, Pennsylvania, US | |
3479243 | 3479243 | 2021-07-22 | US | Tennessee | Dyer | 47045 | 5582 | 107 | 0 | 36.05931946 | -89.41542855 | 2021-07-23 04:21:29 | Dyer, Tennessee, US | |
2674301 | 2674301 | 2021-07-18 | US | Arkansas | Hot Spring | 5059 | 5582 | 78 | 0 | 34.31709259 | -92.95396325 | 2021-07-19 04:21:24 | Hot Spring, Arkansas, US | |
3706613 | 3706613 | 2021-07-17 | US | Arkansas | Hot Spring | 5059 | 5582 | 78 | 0 | 34.31709259 | -92.95396325 | 2021-07-18 04:22:07 | Hot Spring, Arkansas, US | |
2947844 | 2947844 | 2021-07-16 | US | Arkansas | Hot Spring | 5059 | 5582 | 78 | 0 | 34.31709259 | -92.95396325 | 2021-07-17 04:22:22 | Hot Spring, Arkansas, US | |
2318685 | 2318685 | 2021-06-04 | US | Virginia | Pittsylvania | 51143 | 5582 | 82 | 0 | 36.81980341 | -79.39731264 | 2021-06-05 04:23:03 | Pittsylvania, Virginia, US | |
2318299 | 2318299 | 2021-06-04 | US | Tennessee | Warren | 47177 | 5582 | 83 | 0 | 35.6728299 | -85.77969117 | 2021-06-05 04:23:03 | Warren, Tennessee, US | |
3114598 | 3114598 | 2021-05-06 | US | Indiana | Noble | 18113 | 5582 | 83 | 0 | 41.39672484 | -85.41966713 | 2021-05-07 04:20:40 | Noble, Indiana, US | |
2021812 | 2021812 | 2021-04-20 | US | Indiana | Henry | 18065 | 5582 | 101 | 0 | 39.93029017 | -85.39625719 | 2021-04-21 04:21:14 | Henry, Indiana, US | |
2549564 | 2549564 | 2021-04-15 | US | Florida | Gadsden | 12039 | 5582 | 92 | 0 | 30.57796289 | -84.61915825 | 2021-04-16 04:20:46 | Gadsden, Florida, US | |
1845611 | 1845611 | 2021-04-14 | Yemen | 5582 | 1083 | 2128 | 2371 | 15.552727 | 48.516388 | 2021-04-15 04:20:54 | Yemen | |||
639580 | 639580 | 2021-03-31 | US | Michigan | Midland | 26111 | 5582 | 69 | 0 | 43.64330771 | -84.38804374 | 2021-04-01 04:27:05 | Midland, Michigan, 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]);