johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
134 rows where confirmed = 5588 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218512 | 218512 | 2022-12-26 | US | Arkansas | Sharp | 5135 | 5588 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-12-27 04:21:07 | Sharp, Arkansas, US | |
1985131 | 1985131 | 2022-12-07 | US | Arkansas | Cross | 5037 | 5588 | 100 | 0 | 35.29631396 | -90.77185818 | 2022-12-08 04:21:07 | Cross, Arkansas, US | |
2559971 | 2559971 | 2022-11-29 | US | Virginia | New Kent | 51127 | 5588 | 42 | 0 | 37.50694406 | -76.99828634 | 2022-11-30 04:21:07 | New Kent, Virginia, US | |
711211 | 711211 | 2022-11-01 | US | Georgia | Berrien | 13019 | 5588 | 92 | 0 | 31.27590016 | -83.2252992 | 2022-11-02 04:22:09 | Berrien, Georgia, US | |
3285660 | 3285660 | 2022-10-31 | US | Georgia | Berrien | 13019 | 5588 | 92 | 0 | 31.27590016 | -83.2252992 | 2022-11-01 04:22:36 | Berrien, Georgia, US | |
320693 | 320693 | 2022-10-30 | US | Georgia | Berrien | 13019 | 5588 | 92 | 0 | 31.27590016 | -83.2252992 | 2022-10-31 04:21:36 | Berrien, Georgia, US | |
912969 | 912969 | 2022-10-29 | US | Georgia | Berrien | 13019 | 5588 | 92 | 0 | 31.27590016 | -83.2252992 | 2022-10-30 04:22:14 | Berrien, Georgia, US | |
1367238 | 1367238 | 2022-10-28 | US | Georgia | Berrien | 13019 | 5588 | 92 | 0 | 31.27590016 | -83.2252992 | 2022-10-29 04:21:13 | Berrien, Georgia, US | |
3039093 | 3039093 | 2022-10-27 | US | Georgia | Berrien | 13019 | 5588 | 92 | 0 | 31.27590016 | -83.2252992 | 2022-10-28 04:22:31 | Berrien, Georgia, US | |
539513 | 539513 | 2022-10-26 | US | Georgia | Berrien | 13019 | 5588 | 92 | 0 | 31.27590016 | -83.2252992 | 2022-10-27 04:22:01 | Berrien, Georgia, US | |
1979402 | 1979402 | 2022-09-25 | US | Puerto Rico | Santa Isabel | 72133 | 5588 | 0 | 0 | 17.994525 | -66.388913 | 2022-09-26 04:20:52 | Santa Isabel, Puerto Rico, US | |
1625417 | 1625417 | 2022-09-22 | US | Indiana | Orange | 18117 | 5588 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-09-23 04:23:13 | Orange, Indiana, US | |
1371621 | 1371621 | 2022-09-21 | US | Indiana | Orange | 18117 | 5588 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-09-22 04:22:56 | Orange, Indiana, US | |
3909961 | 3909961 | 2022-08-11 | US | Missouri | Ray | 29177 | 5588 | 96 | 0 | 39.3537468 | -93.98905745 | 2022-08-12 04:20:54 | Ray, Missouri, US | |
1348278 | 1348278 | 2022-08-10 | US | Missouri | Ray | 29177 | 5588 | 96 | 0 | 39.3537468 | -93.98905745 | 2022-08-11 04:20:49 | Ray, Missouri, US | |
1088033 | 1088033 | 2022-08-09 | US | Missouri | Ray | 29177 | 5588 | 96 | 0 | 39.3537468 | -93.98905745 | 2022-08-10 04:20:57 | Ray, Missouri, US | |
3545448 | 3545448 | 2022-08-08 | US | Missouri | Ray | 29177 | 5588 | 96 | 0 | 39.3537468 | -93.98905745 | 2022-08-09 04:20:34 | Ray, Missouri, US | |
1071851 | 1071851 | 2022-08-07 | US | Missouri | Ray | 29177 | 5588 | 96 | 0 | 39.3537468 | -93.98905745 | 2022-08-08 04:21:08 | Ray, Missouri, US | |
1942439 | 1942439 | 2022-08-06 | US | Missouri | Ray | 29177 | 5588 | 96 | 0 | 39.3537468 | -93.98905745 | 2022-08-07 04:20:54 | Ray, Missouri, US | |
882238 | 882238 | 2022-08-05 | US | Missouri | Ray | 29177 | 5588 | 96 | 0 | 39.3537468 | -93.98905745 | 2022-08-06 04:20:56 | Ray, Missouri, US | |
3874957 | 3874957 | 2022-07-31 | US | Virginia | Prince Edward | 51147 | 5588 | 77 | 0 | 37.22554789 | -78.43597949 | 2022-08-01 04:21:03 | Prince Edward, Virginia, US | |
677711 | 677711 | 2022-07-30 | US | Virginia | Prince Edward | 51147 | 5588 | 77 | 0 | 37.22554789 | -78.43597949 | 2022-07-31 04:21:02 | Prince Edward, Virginia, US | |
1786910 | 1786910 | 2022-07-29 | US | Virginia | Prince Edward | 51147 | 5588 | 77 | 0 | 37.22554789 | -78.43597949 | 2022-07-30 04:20:42 | Prince Edward, Virginia, US | |
3112880 | 3112880 | 2022-07-13 | US | Virginia | Powhatan | 51145 | 5588 | 62 | 0 | 37.55016038 | -77.91267882 | 2022-07-14 04:20:57 | Powhatan, Virginia, US | |
1770935 | 1770935 | 2022-07-03 | US | Wisconsin | Vilas | 55125 | 5588 | 91 | 0 | 46.05467334 | -89.51719204 | 2022-07-04 04:20:54 | Vilas, Wisconsin, US | |
3368921 | 3368921 | 2022-07-02 | US | Wisconsin | Vilas | 55125 | 5588 | 91 | 0 | 46.05467334 | -89.51719204 | 2022-07-03 04:20:59 | Vilas, Wisconsin, US | |
597250 | 597250 | 2022-07-01 | US | Wisconsin | Vilas | 55125 | 5588 | 91 | 0 | 46.05467334 | -89.51719204 | 2022-07-02 04:21:16 | Vilas, Wisconsin, US | |
2492286 | 2492286 | 2022-06-29 | US | New York | Schoharie | 36095 | 5588 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-06-30 04:21:01 | Schoharie, New York, US | |
947938 | 947938 | 2022-06-14 | US | Indiana | Fountain | 18045 | 5588 | 105 | 0 | 40.12361933 | -87.24217689 | 2022-06-15 04:20:54 | Fountain, Indiana, US | |
2980346 | 2980346 | 2022-06-13 | US | Indiana | Fountain | 18045 | 5588 | 105 | 0 | 40.12361933 | -87.24217689 | 2022-06-14 04:20:52 | Fountain, Indiana, US | |
3583597 | 3583597 | 2022-05-17 | US | Idaho | Payette | 16075 | 5588 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-05-18 04:20:50 | Payette, Idaho, US | |
1504554 | 1504554 | 2022-05-16 | US | Idaho | Payette | 16075 | 5588 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-05-17 04:20:59 | Payette, Idaho, US | |
3538952 | 3538952 | 2022-05-10 | US | West Virginia | Lincoln | 54043 | 5588 | 82 | 0 | 38.172154 | -82.07017953 | 2022-05-11 04:20:48 | Lincoln, West Virginia, US | |
225487 | 225487 | 2022-05-09 | US | West Virginia | Lincoln | 54043 | 5588 | 82 | 0 | 38.172154 | -82.07017953 | 2022-05-10 04:20:50 | Lincoln, West Virginia, US | |
3855032 | 3855032 | 2022-04-27 | US | Texas | San Jacinto | 48407 | 5588 | 101 | 0 | 30.57933681 | -95.16260304 | 2022-04-28 04:20:47 | San Jacinto, Texas, US | |
2251258 | 2251258 | 2022-04-19 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-20 04:20:45 | Guaviare, Colombia | |||
1845808 | 1845808 | 2022-04-18 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-19 04:21:00 | Guaviare, Colombia | |||
3416752 | 3416752 | 2022-04-17 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-18 04:21:12 | Guaviare, Colombia | |||
303701 | 303701 | 2022-04-16 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-17 04:20:59 | Guaviare, Colombia | |||
2669646 | 2669646 | 2022-04-15 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-16 04:20:48 | Guaviare, Colombia | |||
1223431 | 1223431 | 2022-04-14 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-15 04:20:57 | Guaviare, Colombia | |||
2445938 | 2445938 | 2022-04-13 | US | Texas | Moore | 48341 | 5588 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-04-13 23:21:06 | Moore, Texas, US | |
2444497 | 2444497 | 2022-04-13 | US | Minnesota | Martin | 27091 | 5588 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-04-13 23:21:06 | Martin, Minnesota, US | |
2442589 | 2442589 | 2022-04-13 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-13 23:21:06 | Guaviare, Colombia | |||
1948346 | 1948346 | 2022-04-12 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-13 04:21:03 | Guaviare, Colombia | |||
3208007 | 3208007 | 2022-04-11 | US | Minnesota | Martin | 27091 | 5588 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-04-12 04:20:49 | Martin, Minnesota, US | |
3206099 | 3206099 | 2022-04-11 | Colombia | Guaviare | 5588 | 105 | 0 | 1.0654 | -73.2603 | 2022-04-12 04:20:49 | Guaviare, Colombia | |||
1577893 | 1577893 | 2022-04-10 | US | Minnesota | Martin | 27091 | 5588 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-04-11 04:21:02 | Martin, Minnesota, US | |
1654135 | 1654135 | 2022-04-09 | US | Minnesota | Martin | 27091 | 5588 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-04-10 04:20:52 | Martin, Minnesota, US | |
2117457 | 2117457 | 2022-04-08 | US | Minnesota | Martin | 27091 | 5588 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-04-09 04:20:42 | Martin, Minnesota, US | |
3321981 | 3321981 | 2022-04-07 | US | Minnesota | Martin | 27091 | 5588 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-04-08 04:20:48 | Martin, Minnesota, US | |
3915572 | 3915572 | 2022-02-20 | US | Wisconsin | Jackson | 55053 | 5588 | 41 | 0 | 44.31864893 | -90.80566792 | 2022-02-21 04:21:05 | Jackson, Wisconsin, US | |
3879130 | 3879130 | 2022-02-19 | US | Wisconsin | Jackson | 55053 | 5588 | 41 | 0 | 44.31864893 | -90.80566792 | 2022-02-20 04:21:00 | Jackson, Wisconsin, US | |
3878617 | 3878617 | 2022-02-19 | US | Texas | Calhoun | 48057 | 5588 | 46 | 0 | 28.47048236 | -96.61633945 | 2022-02-20 04:21:00 | Calhoun, Texas, US | |
3859386 | 3859386 | 2022-02-18 | US | Wisconsin | Jackson | 55053 | 5588 | 41 | 0 | 44.31864893 | -90.80566792 | 2022-02-19 04:21:11 | Jackson, Wisconsin, US | |
2642299 | 2642299 | 2022-02-14 | US | California | Del Norte | 6015 | 5588 | 45 | 0 | 41.74228275 | -123.89740630000001 | 2022-02-15 04:21:09 | Del Norte, California, US | |
189009 | 189009 | 2022-02-13 | US | Tennessee | Fentress | 47049 | 5588 | 110 | 0 | 36.38128818 | -84.92870012 | 2022-02-14 04:20:51 | Fentress, Tennessee, US | |
2476707 | 2476707 | 2022-02-03 | US | Puerto Rico | Juncos | 72077 | 5588 | 0 | 0 | 18.223793 | -65.909109 | 2022-02-04 04:21:10 | Juncos, Puerto Rico, US | |
980382 | 980382 | 2022-02-01 | US | Kentucky | Lincoln | 21137 | 5588 | 113 | 0 | 37.45475628 | -84.6565327 | 2022-02-02 04:21:09 | Lincoln, Kentucky, US | |
557221 | 557221 | 2022-01-16 | US | North Dakota | Stutsman | 38093 | 5588 | 92 | 0 | 46.97962541 | -98.95637318 | 2022-01-17 04:21:08 | Stutsman, North Dakota, US | |
555894 | 555894 | 2022-01-16 | US | Indiana | Jennings | 18079 | 5588 | 76 | 0 | 38.99588883 | -85.62710784 | 2022-01-17 04:21:08 | Jennings, Indiana, US | |
3841615 | 3841615 | 2022-01-15 | US | Indiana | Jennings | 18079 | 5588 | 76 | 0 | 38.99588883 | -85.62710784 | 2022-01-16 04:21:12 | Jennings, Indiana, US | |
100430 | 100430 | 2022-01-14 | US | Indiana | Jennings | 18079 | 5588 | 76 | 0 | 38.99588883 | -85.62710784 | 2022-01-15 04:21:07 | Jennings, Indiana, US | |
1117074 | 1117074 | 2022-01-11 | US | West Virginia | Hancock | 54029 | 5588 | 126 | 0 | 40.51943859 | -80.57461608 | 2022-01-12 04:21:44 | Hancock, West Virginia, US | |
1114576 | 1114576 | 2022-01-11 | US | Illinois | Fayette | 17051 | 5588 | 77 | 0 | 39.00072038 | -89.02452658 | 2022-01-12 04:21:44 | Fayette, Illinois, US | |
1695817 | 1695817 | 2022-01-10 | US | West Virginia | Mingo | 54059 | 5588 | 101 | 0 | 37.73048351 | -82.13338365 | 2022-01-11 04:22:01 | Mingo, West Virginia, US | |
2612881 | 2612881 | 2022-01-06 | US | South Carolina | Marlboro | 45069 | 5588 | 86 | 0 | 34.59905577 | -79.67561152 | 2022-01-07 04:22:09 | Marlboro, South Carolina, US | |
1719187 | 1719187 | 2021-12-16 | US | South Carolina | Marion | 45067 | 5588 | 143 | 0 | 34.07859748 | -79.36400756 | 2021-12-17 04:22:14 | Marion, South Carolina, US | |
2089800 | 2089800 | 2021-12-14 | US | Mississippi | Lincoln | 28085 | 5588 | 136 | 0 | 31.53288662 | -90.45391915 | 2021-12-15 03:22:16 | Lincoln, Mississippi, US | |
152487 | 152487 | 2021-11-29 | US | Ohio | Perry | 39127 | 5588 | 85 | 0 | 39.73508655 | -82.23804971 | 2021-11-30 04:22:53 | Perry, Ohio, US | |
3071404 | 3071404 | 2021-11-23 | US | Kentucky | Boyle | 21021 | 5588 | 93 | 0 | 37.62680923 | -84.8633779 | 2021-11-24 04:22:14 | Boyle, Kentucky, US | |
689051 | 689051 | 2021-11-13 | US | Pennsylvania | Perry | 42099 | 5588 | 130 | 0 | 40.40206612 | -77.26297447 | 2021-11-14 04:21:31 | Perry, Pennsylvania, US | |
2000934 | 2000934 | 2021-11-07 | San Marino | 5588 | 92 | 0 | 43.9424 | 12.4578 | 2021-11-08 04:21:43 | San Marino | ||||
495925 | 495925 | 2021-11-06 | San Marino | 5588 | 92 | 0 | 43.9424 | 12.4578 | 2021-11-07 04:21:53 | San Marino | ||||
3121780 | 3121780 | 2021-11-05 | San Marino | 5588 | 92 | 0 | 43.9424 | 12.4578 | 2021-11-06 04:21:51 | San Marino | ||||
446063 | 446063 | 2021-10-20 | US | Pennsylvania | Wayne | 42127 | 5588 | 104 | 0 | 41.64938475 | -75.29956506 | 2021-10-21 04:21:18 | Wayne, Pennsylvania, US | |
3008106 | 3008106 | 2021-10-11 | US | Georgia | Chattahoochee | 13053 | 5588 | 17 | 0 | 32.34341231 | -84.78809239 | 2021-10-12 04:21:09 | Chattahoochee, Georgia, US | |
424122 | 424122 | 2021-10-10 | US | Georgia | Chattahoochee | 13053 | 5588 | 17 | 0 | 32.34341231 | -84.78809239 | 2021-10-11 04:21:31 | Chattahoochee, Georgia, US | |
2876979 | 2876979 | 2021-10-09 | US | Georgia | Chattahoochee | 13053 | 5588 | 17 | 0 | 32.34341231 | -84.78809239 | 2021-10-10 04:21:38 | Chattahoochee, Georgia, US | |
2960145 | 2960145 | 2021-10-08 | US | Georgia | Chattahoochee | 13053 | 5588 | 17 | 0 | 32.34341231 | -84.78809239 | 2021-10-09 04:21:34 | Chattahoochee, Georgia, US | |
1818100 | 1818100 | 2021-09-19 | US | Virginia | Danville | 51590 | 5588 | 163 | 0 | 36.58022376 | -79.40395668 | 2021-09-20 04:21:22 | Danville, Virginia, US | |
1815671 | 1815671 | 2021-09-19 | US | Georgia | Wayne | 13305 | 5588 | 130 | 0 | 31.5521809 | -81.91894878 | 2021-09-20 04:21:22 | Wayne, Georgia, US | |
19680 | 19680 | 2021-09-18 | US | Virginia | Danville | 51590 | 5588 | 163 | 0 | 36.58022376 | -79.40395668 | 2021-09-19 04:21:34 | Danville, Virginia, US | |
17251 | 17251 | 2021-09-18 | US | Georgia | Wayne | 13305 | 5588 | 130 | 0 | 31.5521809 | -81.91894878 | 2021-09-19 04:21:34 | Wayne, Georgia, US | |
2621365 | 2621365 | 2021-09-17 | US | Virginia | Danville | 51590 | 5588 | 163 | 0 | 36.58022376 | -79.40395668 | 2021-09-18 04:21:24 | Danville, Virginia, US | |
2618936 | 2618936 | 2021-09-17 | US | Georgia | Wayne | 13305 | 5588 | 130 | 0 | 31.5521809 | -81.91894878 | 2021-09-18 04:21:24 | Wayne, Georgia, US | |
1376346 | 1376346 | 2021-09-15 | US | Mississippi | Union | 28145 | 5588 | 85 | 0 | 34.49162015 | -89.00776006 | 2021-09-16 04:22:19 | Union, Mississippi, US | |
2463282 | 2463282 | 2021-09-14 | US | Arkansas | Independence | 5063 | 5588 | 151 | 0 | 35.74242707 | -91.57001641 | 2021-09-15 03:22:37 | Independence, Arkansas, US | |
2925070 | 2925070 | 2021-08-27 | US | Missouri | Camden | 29029 | 5588 | 111 | 0 | 38.02199522 | -92.76083747 | 2021-08-28 04:21:28 | Camden, Missouri, US | |
35834 | 35834 | 2021-08-25 | US | Virginia | Washington | 51191 | 5588 | 115 | 0 | 36.72341572 | -81.95666289 | 2021-08-26 04:21:28 | Washington, Virginia, US | |
3470748 | 3470748 | 2021-08-03 | US | Oklahoma | McClain | 40087 | 5588 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-08-04 04:21:25 | McClain, Oklahoma, US | |
3686022 | 3686022 | 2021-08-02 | US | Oklahoma | McClain | 40087 | 5588 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-08-03 04:21:39 | McClain, Oklahoma, US | |
3017921 | 3017921 | 2021-08-01 | US | Oklahoma | McClain | 40087 | 5588 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-08-02 04:21:36 | McClain, Oklahoma, US | |
3906544 | 3906544 | 2021-07-31 | US | Oklahoma | McClain | 40087 | 5588 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-08-01 04:21:50 | McClain, Oklahoma, US | |
3298749 | 3298749 | 2021-07-30 | US | Oklahoma | McClain | 40087 | 5588 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-07-31 04:21:35 | McClain, Oklahoma, US | |
3387960 | 3387960 | 2021-07-29 | US | Oklahoma | McClain | 40087 | 5588 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-07-30 04:21:34 | McClain, Oklahoma, US | |
410865 | 410865 | 2021-07-28 | US | Oklahoma | McClain | 40087 | 5588 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-07-29 04:21:33 | McClain, Oklahoma, US | |
3140584 | 3140584 | 2021-07-23 | US | Texas | Burnet | 48053 | 5588 | 70 | 0 | 30.78801353 | -98.181887 | 2021-07-24 00:21:36 | Burnet, Texas, US | |
1440619 | 1440619 | 2021-07-07 | Japan | Shiga | 5588 | 90 | 5432 | 66 | 35.21582700000001 | 136.138064 | 2021-07-08 04:21:26 | Shiga, Japan | ||
2720355 | 2720355 | 2021-06-10 | US | Virginia | Pittsylvania | 51143 | 5588 | 82 | 0 | 36.81980341 | -79.39731264 | 2021-06-11 04:23:20 | Pittsylvania, Virginia, 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]);