johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where confirmed = 11997 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754194 | 2754194 | 2022-12-29 | US | Kansas | Ford | 20057 | 11997 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-30 04:21:04 | Ford, Kansas, US | |
1075200 | 1075200 | 2022-12-28 | US | Kansas | Ford | 20057 | 11997 | 123 | 0 | 37.69200114 | -99.88825298 | 2022-12-29 04:21:01 | Ford, Kansas, US | |
221602 | 221602 | 2022-12-26 | US | Wyoming | Teton | 56039 | 11997 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-12-27 04:21:07 | Teton, Wyoming, US | |
219862 | 219862 | 2022-12-26 | US | Missouri | Butler | 29023 | 11997 | 179 | 0 | 36.71462476 | -90.40421163 | 2022-12-27 04:21:07 | Butler, Missouri, US | |
3226059 | 3226059 | 2022-12-25 | US | Wyoming | Teton | 56039 | 11997 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-12-26 04:21:06 | Teton, Wyoming, US | |
3224319 | 3224319 | 2022-12-25 | US | Missouri | Butler | 29023 | 11997 | 179 | 0 | 36.71462476 | -90.40421163 | 2022-12-26 04:21:06 | Butler, Missouri, US | |
1021973 | 1021973 | 2022-12-24 | US | Wyoming | Teton | 56039 | 11997 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-12-25 04:21:04 | Teton, Wyoming, US | |
1020233 | 1020233 | 2022-12-24 | US | Missouri | Butler | 29023 | 11997 | 179 | 0 | 36.71462476 | -90.40421163 | 2022-12-25 04:21:04 | Butler, Missouri, US | |
693996 | 693996 | 2022-12-23 | US | Wyoming | Teton | 56039 | 11997 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-12-24 04:21:02 | Teton, Wyoming, US | |
692256 | 692256 | 2022-12-23 | US | Missouri | Butler | 29023 | 11997 | 179 | 0 | 36.71462476 | -90.40421163 | 2022-12-24 04:21:02 | Butler, Missouri, US | |
2183206 | 2183206 | 2022-12-22 | US | Wyoming | Teton | 56039 | 11997 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-12-23 04:21:04 | Teton, Wyoming, US | |
2181466 | 2181466 | 2022-12-22 | US | Missouri | Butler | 29023 | 11997 | 179 | 0 | 36.71462476 | -90.40421163 | 2022-12-23 04:21:04 | Butler, Missouri, US | |
455010 | 455010 | 2022-12-21 | US | Wyoming | Teton | 56039 | 11997 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-12-22 04:20:56 | Teton, Wyoming, US | |
453270 | 453270 | 2022-12-21 | US | Missouri | Butler | 29023 | 11997 | 179 | 0 | 36.71462476 | -90.40421163 | 2022-12-22 04:20:56 | Butler, Missouri, US | |
2955009 | 2955009 | 2022-12-20 | US | Wyoming | Teton | 56039 | 11997 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-12-21 04:21:03 | Teton, Wyoming, US | |
2953269 | 2953269 | 2022-12-20 | US | Missouri | Butler | 29023 | 11997 | 179 | 0 | 36.71462476 | -90.40421163 | 2022-12-21 04:21:03 | Butler, Missouri, US | |
295336 | 295336 | 2022-11-15 | US | Virginia | Charlottesville | 51540 | 11997 | 85 | 0 | 38.03527919 | -78.48569588 | 2022-11-16 04:21:09 | Charlottesville, Virginia, US | |
312969 | 312969 | 2022-11-13 | US | Illinois | Woodford | 17203 | 11997 | 117 | 0 | 40.78579374 | -89.20973757 | 2022-11-14 04:21:09 | Woodford, Illinois, US | |
64130 | 64130 | 2022-11-12 | US | Illinois | Woodford | 17203 | 11997 | 117 | 0 | 40.78579374 | -89.20973757 | 2022-11-13 04:21:14 | Woodford, Illinois, US | |
2928292 | 2928292 | 2022-11-11 | US | Illinois | Woodford | 17203 | 11997 | 117 | 0 | 40.78579374 | -89.20973757 | 2022-11-12 04:20:41 | Woodford, Illinois, US | |
2507128 | 2507128 | 2022-11-10 | US | Illinois | Woodford | 17203 | 11997 | 117 | 0 | 40.78579374 | -89.20973757 | 2022-11-11 04:21:22 | Woodford, Illinois, US | |
2260808 | 2260808 | 2022-10-02 | US | Illinois | Randolph | 17157 | 11997 | 132 | 0 | 38.05095369 | -89.82512254 | 2022-10-03 04:23:11 | Randolph, Illinois, US | |
2996334 | 2996334 | 2022-10-01 | US | Illinois | Randolph | 17157 | 11997 | 132 | 0 | 38.05095369 | -89.82512254 | 2022-10-02 04:21:23 | Randolph, Illinois, US | |
854660 | 854660 | 2022-09-30 | US | Illinois | Randolph | 17157 | 11997 | 132 | 0 | 38.05095369 | -89.82512254 | 2022-10-01 04:23:01 | Randolph, Illinois, US | |
1627786 | 1627786 | 2022-09-22 | US | West Virginia | Logan | 54045 | 11997 | 194 | 0 | 37.8299889 | -81.93528571 | 2022-09-23 04:23:13 | Logan, West Virginia, US | |
2324363 | 2324363 | 2022-08-24 | US | Illinois | Livingston | 17105 | 11997 | 137 | 0 | 40.89188292 | -88.55784752 | 2022-08-25 04:21:13 | Livingston, Illinois, US | |
1164094 | 1164094 | 2022-08-18 | US | Tennessee | Cheatham | 47021 | 11997 | 133 | 0 | 36.26136216 | -87.08903581 | 2022-08-19 04:20:54 | Cheatham, Tennessee, US | |
899488 | 899488 | 2022-07-24 | US | Virginia | Franklin | 51067 | 11997 | 201 | 0 | 36.99536167 | -79.88023649 | 2022-07-25 04:20:51 | Franklin, Virginia, US | |
94482 | 94482 | 2022-07-23 | US | Virginia | Franklin | 51067 | 11997 | 201 | 0 | 36.99536167 | -79.88023649 | 2022-07-24 04:20:47 | Franklin, Virginia, US | |
903504 | 903504 | 2022-07-22 | US | Virginia | Franklin | 51067 | 11997 | 201 | 0 | 36.99536167 | -79.88023649 | 2022-07-23 04:20:53 | Franklin, Virginia, US | |
3538496 | 3538496 | 2022-05-10 | US | Texas | Brown | 48049 | 11997 | 229 | 0 | 31.77430356 | -98.99907113 | 2022-05-11 04:20:48 | Brown, Texas, US | |
225031 | 225031 | 2022-05-09 | US | Texas | Brown | 48049 | 11997 | 229 | 0 | 31.77430356 | -98.99907113 | 2022-05-10 04:20:50 | Brown, Texas, US | |
2334416 | 2334416 | 2022-05-08 | US | Texas | Brown | 48049 | 11997 | 229 | 0 | 31.77430356 | -98.99907113 | 2022-05-09 04:20:54 | Brown, Texas, US | |
1699690 | 1699690 | 2022-04-28 | US | Virginia | Henry | 51089 | 11997 | 263 | 0 | 36.68542395 | -79.87634026 | 2022-04-29 04:20:59 | Henry, Virginia, US | |
1470380 | 1470380 | 2022-03-24 | US | New York | Washington | 36115 | 11997 | 113 | 0 | 43.31153794 | -73.43043448 | 2022-03-25 04:20:46 | Washington, New York, US | |
1551082 | 1551082 | 2022-03-07 | US | Texas | Hardin | 48199 | 11997 | 245 | 0 | 30.33364686 | -94.38931817 | 2022-03-08 04:20:54 | Hardin, Texas, US | |
2202751 | 2202751 | 2022-03-06 | US | Texas | Hardin | 48199 | 11997 | 245 | 0 | 30.33364686 | -94.38931817 | 2022-03-07 04:20:47 | Hardin, Texas, US | |
2095208 | 2095208 | 2022-03-05 | US | Texas | Hardin | 48199 | 11997 | 245 | 0 | 30.33364686 | -94.38931817 | 2022-03-06 04:20:49 | Hardin, Texas, US | |
3821274 | 3821274 | 2022-02-16 | US | Georgia | Liberty | 13179 | 11997 | 142 | 0 | 31.82588896 | -81.49251135 | 2022-02-17 04:20:56 | Liberty, Georgia, US | |
73230 | 73230 | 2022-02-07 | US | Nevada | Elko | 32007 | 11997 | 127 | 0 | 41.14531606 | -115.3577619 | 2022-02-08 04:21:15 | Elko, Nevada, US | |
3690468 | 3690468 | 2022-01-13 | US | Tennessee | Roane | 47145 | 11997 | 187 | 0 | 35.84923189 | -84.52458689 | 2022-01-14 04:21:54 | Roane, Tennessee, US | |
1114650 | 1114650 | 2022-01-11 | US | Illinois | Whiteside | 17195 | 11997 | 200 | 0 | 41.75509713 | -89.91556058 | 2022-01-12 04:21:44 | Whiteside, Illinois, US | |
2811244 | 2811244 | 2021-09-16 | US | Ohio | Muskingum | 39119 | 11997 | 158 | 0 | 39.96575964 | -81.94363275 | 2021-09-17 04:21:46 | Muskingum, Ohio, US | |
68111 | 68111 | 2021-09-01 | US | Illinois | Vermilion | 17183 | 11997 | 164 | 0 | 40.18417171 | -87.73384359 | 2021-09-02 04:21:15 | Vermilion, Illinois, US | |
1778599 | 1778599 | 2021-08-30 | US | Texas | Victoria | 48469 | 11997 | 256 | 0 | 28.79780988 | -96.96813006 | 2021-08-31 04:21:46 | Victoria, Texas, US | |
1777241 | 1777241 | 2021-08-30 | US | Missouri | Christian | 29043 | 11997 | 139 | 0 | 36.9711783 | -93.18537118 | 2021-08-31 04:21:46 | Christian, Missouri, US | |
33221 | 33221 | 2021-08-25 | US | Georgia | Glynn | 13127 | 11997 | 216 | 0 | 31.23279254 | -81.53811412 | 2021-08-26 04:21:28 | Glynn, Georgia, US | |
32413 | 32413 | 2021-08-25 | Italy | Valle d'Aosta | 11997 | 473 | 0 | 45.73750286 | 7.320149366 | 2021-08-26 04:21:28 | Valle d'Aosta, Italy | |||
781900 | 781900 | 2021-07-08 | US | Wisconsin | Eau Claire | 55035 | 11997 | 122 | 0 | 44.726614 | -91.28609183 | 2021-07-09 04:21:21 | Eau Claire, Wisconsin, US | |
1981718 | 1981718 | 2021-03-25 | US | Indiana | Madison | 18095 | 11997 | 331 | 0 | 40.16143691 | -85.71964711 | 2021-03-26 05:26:55 | Madison, Indiana, US | |
2359688 | 2359688 | 2021-03-08 | Russia | Mari El Republic | 11997 | 180 | 10915 | 902 | 56.5767504 | 47.8817512 | 2021-03-09 05:28:19 | Mari El Republic, Russia | ||
774308 | 774308 | 2021-01-12 | India | Nagaland | 11997 | 84 | 11807 | 106 | 26.06702 | 94.470302 | 2021-01-13 05:22:15 | Nagaland, India | ||
192541 | 192541 | 2021-01-11 | US | Ohio | Licking | 39089 | 11997 | 166 | 0 | 11831 | 40.09136236 | -82.48185785 | 2021-01-12 05:22:15 | Licking, Ohio, US |
1136798 | 1136798 | 2021-01-01 | Germany | Mecklenburg-Vorpommern | 11997 | 171 | 9469 | 2723 | 53.6127 | 12.4296 | 2021-01-02 05:22:33 | Mecklenburg-Vorpommern, Germany | ||
3695404 | 3695404 | 2020-12-31 | Germany | Mecklenburg-Vorpommern | 11997 | 171 | 9130 | 2869 | 53.6127 | 12.4296 | 2021-01-01 05:23:07 | Mecklenburg-Vorpommern, Germany | ||
1453095 | 1453095 | 2020-10-27 | US | Arkansas | Pulaski | 5119 | 11997 | 209 | 0 | 11788 | 34.77054088 | -92.31355101 | 2020-10-28 04:24:39 | Pulaski, Arkansas, US |
3483285 | 3483285 | 2020-10-26 | US | Tennessee | Rutherford | 47149 | 11997 | 115 | 0 | 11902 | 35.84591405 | -86.4107263 | 2020-10-27 04:24:45 | Rutherford, Tennessee, US |
750161 | 750161 | 2020-08-01 | US | Maryland | Baltimore | 24005 | 11997 | 549 | 0 | 11448 | 39.45784712 | -76.62911955 | 2020-08-02 04:34:47 | Baltimore, Maryland, 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]);