johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where confirmed = 9353 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3250669 | 3250669 | 2022-10-11 | US | Arkansas | Poinsett | 5111 | 9353 | 134 | 0 | 35.57433534 | -90.66268713 | 2022-10-12 04:22:51 | Poinsett, Arkansas, US | |
3995773 | 3995773 | 2022-09-27 | US | Indiana | Ripley | 18137 | 9353 | 143 | 0 | 39.10235626 | -85.26212744 | 2022-09-28 04:23:01 | Ripley, Indiana, US | |
2770101 | 2770101 | 2022-09-26 | US | Indiana | Ripley | 18137 | 9353 | 143 | 0 | 39.10235626 | -85.26212744 | 2022-09-27 04:23:01 | Ripley, Indiana, US | |
1372953 | 1372953 | 2022-09-21 | US | Ohio | Coshocton | 39031 | 9353 | 166 | 0 | 40.30096166 | -81.91729018 | 2022-09-22 04:22:56 | Coshocton, Ohio, US | |
2019183 | 2019183 | 2022-09-20 | US | Ohio | Coshocton | 39031 | 9353 | 166 | 0 | 40.30096166 | -81.91729018 | 2022-09-21 04:23:22 | Coshocton, Ohio, US | |
3573056 | 3573056 | 2022-09-19 | US | Ohio | Coshocton | 39031 | 9353 | 166 | 0 | 40.30096166 | -81.91729018 | 2022-09-20 04:22:48 | Coshocton, Ohio, US | |
421795 | 421795 | 2022-09-18 | US | Ohio | Coshocton | 39031 | 9353 | 166 | 0 | 40.30096166 | -81.91729018 | 2022-09-19 04:21:49 | Coshocton, Ohio, US | |
3375819 | 3375819 | 2022-09-17 | US | Ohio | Coshocton | 39031 | 9353 | 166 | 0 | 40.30096166 | -81.91729018 | 2022-09-18 04:22:50 | Coshocton, Ohio, US | |
2357927 | 2357927 | 2022-09-16 | US | Ohio | Coshocton | 39031 | 9353 | 166 | 0 | 40.30096166 | -81.91729018 | 2022-09-17 04:20:19 | Coshocton, Ohio, US | |
3989084 | 3989084 | 2022-09-15 | US | Ohio | Coshocton | 39031 | 9353 | 166 | 0 | 40.30096166 | -81.91729018 | 2022-09-16 04:21:19 | Coshocton, Ohio, US | |
3349591 | 3349591 | 2022-06-24 | US | Tennessee | Henderson | 47077 | 9353 | 163 | 0 | 35.65581134 | -88.38600175 | 2022-06-25 04:20:57 | Henderson, Tennessee, US | |
3270927 | 3270927 | 2022-06-19 | US | Kentucky | Harlan | 21095 | 9353 | 215 | 0 | 36.85699301 | -83.21899516 | 2022-06-20 04:21:01 | Harlan, Kentucky, US | |
3398839 | 3398839 | 2022-06-18 | US | Kentucky | Harlan | 21095 | 9353 | 215 | 0 | 36.85699301 | -83.21899516 | 2022-06-19 04:20:51 | Harlan, Kentucky, US | |
2312716 | 2312716 | 2022-06-17 | US | Kentucky | Harlan | 21095 | 9353 | 215 | 0 | 36.85699301 | -83.21899516 | 2022-06-18 04:21:10 | Harlan, Kentucky, US | |
560220 | 560220 | 2022-06-16 | US | Kentucky | Harlan | 21095 | 9353 | 215 | 0 | 36.85699301 | -83.21899516 | 2022-06-17 04:20:56 | Harlan, Kentucky, US | |
3984022 | 3984022 | 2022-06-15 | US | Kentucky | Harlan | 21095 | 9353 | 215 | 0 | 36.85699301 | -83.21899516 | 2022-06-16 04:20:55 | Harlan, Kentucky, US | |
948263 | 948263 | 2022-06-14 | US | Kentucky | Harlan | 21095 | 9353 | 215 | 0 | 36.85699301 | -83.21899516 | 2022-06-15 04:20:54 | Harlan, Kentucky, US | |
2980671 | 2980671 | 2022-06-13 | US | Kentucky | Harlan | 21095 | 9353 | 215 | 0 | 36.85699301 | -83.21899516 | 2022-06-14 04:20:52 | Harlan, Kentucky, US | |
1654623 | 1654623 | 2022-04-09 | US | New York | Chenango | 36017 | 9353 | 120 | 0 | 42.49430041 | -75.60887553 | 2022-04-10 04:20:52 | Chenango, New York, US | |
2751221 | 2751221 | 2022-04-04 | US | North Carolina | Jackson | 37099 | 9353 | 86 | 0 | 35.28814273 | -83.14093385 | 2022-04-05 04:20:48 | Jackson, North Carolina, US | |
2143466 | 2143466 | 2022-03-09 | US | Vermont | Washington | 50023 | 9353 | 46 | 0 | 44.27343241 | -72.61604978 | 2022-03-10 04:20:48 | Washington, Vermont, US | |
1551220 | 1551220 | 2022-03-07 | US | Texas | Waller | 48473 | 9353 | 101 | 0 | 30.01058447 | -95.99011759 | 2022-03-08 04:20:54 | Waller, Texas, US | |
2734054 | 2734054 | 2022-02-27 | US | Illinois | Morgan | 17137 | 9353 | 126 | 0 | 39.71654544 | -90.20255104 | 2022-02-28 04:21:05 | Morgan, Illinois, US | |
3047207 | 3047207 | 2022-02-26 | US | Illinois | Morgan | 17137 | 9353 | 126 | 0 | 39.71654544 | -90.20255104 | 2022-02-27 04:21:04 | Morgan, Illinois, US | |
575862 | 575862 | 2022-02-25 | US | Illinois | Morgan | 17137 | 9353 | 126 | 0 | 39.71654544 | -90.20255104 | 2022-02-26 04:21:12 | Morgan, Illinois, US | |
459510 | 459510 | 2022-02-02 | Netherlands | Sint Maarten | 9353 | 79 | 0 | 18.0425 | -63.0548 | 2022-02-03 04:21:21 | Sint Maarten, Netherlands | |||
1779404 | 1779404 | 2022-01-27 | Japan | Port Quarantine | 9353 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
3073557 | 3073557 | 2021-11-23 | US | Wisconsin | Barron | 55005 | 9353 | 100 | 0 | 45.42372701 | -91.84833627 | 2021-11-24 04:22:14 | Barron, Wisconsin, US | |
700051 | 700051 | 2021-11-04 | US | Michigan | Isabella | 26073 | 9353 | 130 | 0 | 43.64060976 | -84.84664923 | 2021-11-05 04:21:54 | Isabella, Michigan, US | |
277829 | 277829 | 2021-11-03 | US | Michigan | Isabella | 26073 | 9353 | 130 | 0 | 43.64060976 | -84.84664923 | 2021-11-04 04:22:20 | Isabella, Michigan, US | |
289919 | 289919 | 2021-10-31 | US | Missouri | Lincoln | 29113 | 9353 | 69 | 0 | 39.05345619 | -90.95588181 | 2021-11-01 04:22:01 | Lincoln, Missouri, US | |
2126078 | 2126078 | 2021-10-21 | US | North Carolina | Lee | 37105 | 9353 | 107 | 0 | 35.47623147 | -79.17569362 | 2021-10-22 04:21:14 | Lee, North Carolina, US | |
1337733 | 1337733 | 2021-09-28 | US | Washington | Skagit | 53057 | 9353 | 97 | 0 | 48.48171488 | -121.766131 | 2021-09-29 04:21:45 | Skagit, Washington, US | |
652416 | 652416 | 2021-08-09 | US | Ohio | Columbiana | 39029 | 9353 | 236 | 0 | 40.76932373 | -80.78094576 | 2021-08-10 04:21:27 | Columbiana, Ohio, US | |
1715763 | 1715763 | 2021-06-25 | US | Washington | Grant | 53025 | 9353 | 82 | 0 | 47.20753737 | -119.4500749 | 2021-06-26 04:21:43 | Grant, Washington, US | |
2718955 | 2718955 | 2021-06-10 | US | Montana | Cascade | 30013 | 9353 | 184 | 0 | 47.30797024 | -111.3467922 | 2021-06-11 04:23:20 | Cascade, Montana, US | |
2585816 | 2585816 | 2021-06-05 | China | Unknown | 9353 | 0 | 17 | 0 | 2021-06-06 04:24:03 | Unknown, China | ||||
1569055 | 1569055 | 2021-04-22 | US | Idaho | Twin Falls | 16083 | 9353 | 126 | 0 | 42.35440512 | -114.6685381 | 2021-04-23 04:20:52 | Twin Falls, Idaho, US | |
391052 | 391052 | 2021-04-04 | US | South Carolina | Orangeburg | 45075 | 9353 | 236 | 0 | 33.4391073 | -80.79886287 | 2021-04-05 04:20:35 | Orangeburg, South Carolina, US | |
3712968 | 3712968 | 2021-04-03 | US | South Carolina | Orangeburg | 45075 | 9353 | 236 | 0 | 33.4391073 | -80.79886287 | 2021-04-04 04:20:49 | Orangeburg, South Carolina, US | |
1291511 | 1291511 | 2021-03-29 | US | Louisiana | Lafourche | 22057 | 9353 | 200 | 0 | 29.52470226 | -90.40976986 | 2021-03-30 04:26:23 | Lafourche, Louisiana, US | |
1536287 | 1536287 | 2021-03-28 | US | Alabama | Cullman | 1043 | 9353 | 186 | 0 | 34.13020303 | -86.86888037 | 2021-03-29 04:28:35 | Cullman, Alabama, US | |
1882074 | 1882074 | 2021-03-26 | US | Indiana | Howard | 18067 | 9353 | 209 | 0 | 40.48527731 | -86.11351892 | 2021-03-27 05:25:04 | Howard, Indiana, US | |
3257306 | 3257306 | 2021-03-02 | US | Texas | Maverick | 48323 | 9353 | 308 | 0 | 9904 | 28.7429195 | -100.3157686 | 2021-03-03 05:23:28 | Maverick, Texas, US |
3066378 | 3066378 | 2021-02-27 | US | Alabama | Limestone | 1083 | 9353 | 134 | 0 | 9219 | 34.81185586 | -86.98310072 | 2021-02-28 05:22:20 | Limestone, Alabama, US |
1938269 | 1938269 | 2021-02-23 | US | Mississippi | Madison | 28089 | 9353 | 193 | 0 | 9160 | 32.63389156 | -90.03513564 | 2021-02-24 05:29:16 | Madison, Mississippi, US |
1339280 | 1339280 | 2021-02-15 | US | Illinois | Macon | 17115 | 9353 | 180 | 0 | 9173 | 39.86064913 | -88.96342505 | 2021-02-16 05:24:38 | Macon, Illinois, US |
3156104 | 3156104 | 2021-01-27 | US | Ohio | Richland | 39139 | 9353 | 189 | 0 | 9164 | 40.77180308 | -82.53799609999999 | 2021-01-28 05:22:24 | Richland, Ohio, US |
2467499 | 2467499 | 2021-01-22 | US | Florida | Hernando | 12053 | 9353 | 328 | 0 | 9025 | 28.55364461 | -82.42700204 | 2021-01-23 05:22:03 | Hernando, Florida, US |
776738 | 776738 | 2021-01-12 | US | North Dakota | Grand Forks | 38035 | 9353 | 70 | 0 | 9365 | 47.92093639 | -97.45450447 | 2021-01-13 05:22:15 | Grand Forks, North Dakota, US |
3847953 | 3847953 | 2020-12-13 | Peru | Madre de Dios | 9353 | 151 | 0 | 9202 | -11.972699 | -70.53171999999998 | 2020-12-14 05:26:27 | Madre de Dios, Peru | ||
845735 | 845735 | 2020-12-12 | Peru | Madre de Dios | 9353 | 151 | 0 | 9202 | -11.972699 | -70.53171999999998 | 2020-12-13 05:27:20 | Madre de Dios, Peru | ||
3441357 | 3441357 | 2020-11-11 | US | California | Kings | 6031 | 9353 | 85 | 0 | 9279 | 36.07409056 | -119.8159973 | 2020-11-12 05:25:55 | Kings, California, US |
3304183 | 3304183 | 2020-11-02 | Italy | P.A. Bolzano | 9353 | 319 | 2974 | 6060 | 46.49933453 | 11.35662422 | 2020-11-03 06:00:16 | P.A. Bolzano, Italy | ||
3483757 | 3483757 | 2020-10-26 | US | Washington | Spokane | 53063 | 9353 | 191 | 0 | 9162 | 47.62113146 | -117.4046494 | 2020-10-27 04:24:45 | Spokane, Washington, US |
2858796 | 2858796 | 2020-10-16 | US | Missouri | St. Charles | 29183 | 9353 | 130 | 0 | 9223 | 38.77875681 | -90.66662425 | 2020-10-17 04:24:12 | St. Charles, Missouri, US |
817964 | 817964 | 2020-10-09 | US | Alabama | Tuscaloosa | 1125 | 9353 | 126 | 0 | 9227 | 33.28726072 | -87.52556818 | 2020-10-10 04:23:57 | Tuscaloosa, Alabama, US |
665395 | 665395 | 2020-08-11 | US | Texas | El Paso | 48141 | 9353 | 307 | 0 | 16629 | 31.76980765 | -106.2363275 | 2020-08-12 04:27:29 | El Paso, Texas, US |
3061294 | 3061294 | 2020-06-13 | Brazil | Parana | 9353 | 320 | 3044 | 5877 | -25.2521 | -52.0215 | 2020-06-14 03:33:15 | Parana, Brazil |
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]);