johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where confirmed = 11285 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3177341 | 3177341 | 2022-12-19 | US | Wisconsin | Green | 55045 | 11285 | 60 | 0 | 42.6794956 | -89.60243287 | 2022-12-20 04:21:04 | Green, Wisconsin, US | |
1621575 | 1621575 | 2022-11-22 | US | Kansas | Harvey | 20079 | 11285 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-23 04:21:06 | Harvey, Kansas, US | |
3461463 | 3461463 | 2022-11-21 | US | Kansas | Harvey | 20079 | 11285 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-22 04:20:47 | Harvey, Kansas, US | |
1641648 | 1641648 | 2022-11-20 | US | Kansas | Harvey | 20079 | 11285 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-21 04:21:05 | Harvey, Kansas, US | |
2065205 | 2065205 | 2022-11-19 | US | Kansas | Harvey | 20079 | 11285 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-20 04:21:08 | Harvey, Kansas, US | |
1756599 | 1756599 | 2022-11-18 | US | Kansas | Harvey | 20079 | 11285 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-19 04:21:14 | Harvey, Kansas, US | |
3027592 | 3027592 | 2022-11-17 | US | Kansas | Harvey | 20079 | 11285 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-18 04:21:15 | Harvey, Kansas, US | |
2487303 | 2487303 | 2022-11-16 | US | Kansas | Harvey | 20079 | 11285 | 133 | 0 | 38.04293782 | -97.42747573 | 2022-11-17 04:21:11 | Harvey, Kansas, US | |
1024599 | 1024599 | 2022-11-04 | US | New York | Chenango | 36017 | 11285 | 130 | 0 | 42.49430041 | -75.60887553 | 2022-11-05 04:21:52 | Chenango, New York, US | |
3041857 | 3041857 | 2022-10-27 | US | West Virginia | Wayne | 54099 | 11285 | 140 | 0 | 38.14901357 | -82.42287994 | 2022-10-28 04:22:31 | Wayne, West Virginia, US | |
3546737 | 3546737 | 2022-08-08 | US | Texas | Van Zandt | 48467 | 11285 | 285 | 0 | 32.56483801 | -95.83766469 | 2022-08-09 04:20:34 | Van Zandt, Texas, US | |
2336056 | 2336056 | 2022-07-27 | US | Colorado | Summit | 8117 | 11285 | 14 | 0 | 39.63803232 | -106.1150762 | 2022-07-28 04:20:56 | Summit, Colorado, US | |
3211348 | 3211348 | 2022-07-18 | US | Illinois | Woodford | 17203 | 11285 | 113 | 0 | 40.78579374 | -89.20973757 | 2022-07-19 04:20:58 | Woodford, Illinois, US | |
1648734 | 1648734 | 2022-06-23 | US | Alabama | Chilton | 1021 | 11285 | 208 | 0 | 32.85044126 | -86.7173256 | 2022-06-24 04:20:58 | Chilton, Alabama, US | |
2190164 | 2190164 | 2022-06-22 | US | Oklahoma | Delaware | 40041 | 11285 | 204 | 0 | 36.40823634 | -94.80325046 | 2022-06-23 04:20:55 | Delaware, Oklahoma, US | |
168595 | 168595 | 2022-06-21 | US | Oklahoma | Delaware | 40041 | 11285 | 204 | 0 | 36.40823634 | -94.80325046 | 2022-06-22 04:20:54 | Delaware, Oklahoma, US | |
1765878 | 1765878 | 2022-06-20 | US | Oklahoma | Delaware | 40041 | 11285 | 204 | 0 | 36.40823634 | -94.80325046 | 2022-06-21 04:20:56 | Delaware, Oklahoma, US | |
3272064 | 3272064 | 2022-06-19 | US | Oklahoma | Delaware | 40041 | 11285 | 204 | 0 | 36.40823634 | -94.80325046 | 2022-06-20 04:21:01 | Delaware, Oklahoma, US | |
3399976 | 3399976 | 2022-06-18 | US | Oklahoma | Delaware | 40041 | 11285 | 204 | 0 | 36.40823634 | -94.80325046 | 2022-06-19 04:20:51 | Delaware, Oklahoma, US | |
2313853 | 2313853 | 2022-06-17 | US | Oklahoma | Delaware | 40041 | 11285 | 204 | 0 | 36.40823634 | -94.80325046 | 2022-06-18 04:21:10 | Delaware, Oklahoma, US | |
561357 | 561357 | 2022-06-16 | US | Oklahoma | Delaware | 40041 | 11285 | 204 | 0 | 36.40823634 | -94.80325046 | 2022-06-17 04:20:56 | Delaware, Oklahoma, US | |
947864 | 947864 | 2022-06-14 | US | Illinois | Livingston | 17105 | 11285 | 136 | 0 | 40.89188292 | -88.55784752 | 2022-06-15 04:20:54 | Livingston, Illinois, US | |
2982296 | 2982296 | 2022-06-13 | US | Texas | Burnet | 48053 | 11285 | 172 | 0 | 30.78801353 | -98.181887 | 2022-06-14 04:20:52 | Burnet, Texas, US | |
3527958 | 3527958 | 2022-06-04 | US | Arkansas | Hot Spring | 5059 | 11285 | 134 | 0 | 34.31709259 | -92.95396325 | 2022-06-05 04:20:55 | Hot Spring, Arkansas, US | |
3854524 | 3854524 | 2022-04-27 | US | Pennsylvania | Venango | 42121 | 11285 | 238 | 0 | 41.40323442 | -79.75845449 | 2022-04-28 04:20:47 | Venango, Pennsylvania, US | |
1299103 | 1299103 | 2022-02-17 | US | Illinois | Stephenson | 17177 | 11285 | 152 | 0 | 42.35129217 | -89.662598 | 2022-02-18 04:21:04 | Stephenson, Illinois, US | |
1298198 | 1298198 | 2022-02-17 | Pakistan | Gilgit-Baltistan | 11285 | 189 | 0 | 35.792146 | 74.982138 | 2022-02-18 04:21:04 | Gilgit-Baltistan, Pakistan | |||
71975 | 71975 | 2022-02-07 | US | Georgia | Tift | 13277 | 11285 | 202 | 0 | 31.45743864 | -83.5236119 | 2022-02-08 04:21:15 | Tift, Georgia, US | |
1296755 | 1296755 | 2022-02-05 | US | Puerto Rico | Arecibo | 72013 | 11285 | 0 | 0 | 18.406631 | -66.675077 | 2022-02-06 04:21:00 | Arecibo, Puerto Rico, US | |
405890 | 405890 | 2021-12-07 | US | Massachusetts | Berkshire | 25003 | 11285 | 291 | 0 | 42.37428441 | -73.20524838 | 2021-12-08 04:22:46 | Berkshire, Massachusetts, US | |
3401743 | 3401743 | 2021-11-30 | Spain | Melilla | 11285 | 113 | 0 | 35.2923 | -2.9381 | 2021-12-01 04:22:29 | Melilla, Spain | |||
498333 | 498333 | 2021-11-06 | US | Pennsylvania | Lawrence | 42073 | 11285 | 271 | 0 | 40.99206278 | -80.33393706 | 2021-11-07 04:21:53 | Lawrence, Pennsylvania, US | |
1912552 | 1912552 | 2021-10-17 | US | Virginia | Frederick | 51069 | 11285 | 138 | 0 | 39.20172582 | -78.25974949 | 2021-10-18 04:21:10 | Frederick, Virginia, US | |
938141 | 938141 | 2021-10-16 | US | Virginia | Frederick | 51069 | 11285 | 138 | 0 | 39.20172582 | -78.25974949 | 2021-10-17 04:21:29 | Frederick, Virginia, US | |
2946696 | 2946696 | 2021-10-15 | US | Virginia | Frederick | 51069 | 11285 | 138 | 0 | 39.20172582 | -78.25974949 | 2021-10-16 04:21:15 | Frederick, Virginia, US | |
17459 | 17459 | 2021-09-18 | US | Indiana | Kosciusko | 18085 | 11285 | 134 | 0 | 41.24521668 | -85.86312322 | 2021-09-19 04:21:34 | Kosciusko, Indiana, US | |
3470050 | 3470050 | 2021-08-03 | US | Missouri | Buchanan | 29021 | 11285 | 157 | 0 | 39.65816401 | -94.80138942 | 2021-08-04 04:21:25 | Buchanan, Missouri, US | |
3018174 | 3018174 | 2021-08-01 | US | South Carolina | Lancaster | 45057 | 11285 | 175 | 0 | 34.68270843 | -80.70513032 | 2021-08-02 04:21:36 | Lancaster, South Carolina, US | |
3906797 | 3906797 | 2021-07-31 | US | South Carolina | Lancaster | 45057 | 11285 | 175 | 0 | 34.68270843 | -80.70513032 | 2021-08-01 04:21:50 | Lancaster, South Carolina, US | |
3299002 | 3299002 | 2021-07-30 | US | South Carolina | Lancaster | 45057 | 11285 | 175 | 0 | 34.68270843 | -80.70513032 | 2021-07-31 04:21:35 | Lancaster, South Carolina, US | |
1565267 | 1565267 | 2021-06-14 | US | Iowa | Dallas | 19049 | 11285 | 99 | 0 | 41.68560356 | -94.04127625 | 2021-06-15 04:22:22 | Dallas, Iowa, US | |
2826542 | 2826542 | 2021-05-01 | US | Minnesota | Sherburne | 27141 | 11285 | 82 | 0 | 45.44447208 | -93.77617511 | 2021-05-02 04:20:48 | Sherburne, Minnesota, US | |
2825545 | 2825545 | 2021-05-01 | US | Georgia | Carroll | 13045 | 11285 | 238 | 0 | 33.58138199 | -85.07976677 | 2021-05-02 04:20:48 | Carroll, Georgia, US | |
1672215 | 1672215 | 2021-02-07 | Burkina Faso | 11285 | 134 | 10129 | 1022 | 12.2383 | -1.5616 | 2021-02-08 05:22:39 | Burkina Faso | |||
1591158 | 1591158 | 2021-02-05 | US | Tennessee | Sevier | 47155 | 11285 | 144 | 0 | 11141 | 35.78077323 | -83.52244332 | 2021-02-06 05:23:55 | Sevier, Tennessee, US |
1901202 | 1901202 | 2020-12-18 | Japan | Saitama | 11285 | 177 | 9008 | 2100 | 35.997101 | 139.347635 | 2020-12-19 05:27:52 | Saitama, Japan | ||
1006515 | 1006515 | 2020-12-06 | Russia | Mordovia Republic | 11285 | 67 | 9160 | 2058 | 54.4419829 | 44.4661144 | 2020-12-07 05:26:14 | Mordovia Republic, Russia | ||
2662354 | 2662354 | 2020-09-04 | US | California | Ventura | 6111 | 11285 | 114 | 0 | 11164 | 34.44465746 | -119.0910613 | 2020-09-05 04:28:19 | Ventura, California, US |
2062333 | 2062333 | 2020-09-01 | US | Ohio | Hamilton | 39061 | 11285 | 263 | 0 | 11022 | 39.19673558 | -84.54502924 | 2020-09-02 04:28:25 | Hamilton, Ohio, US |
2060870 | 2060870 | 2020-09-01 | US | Illinois | Kane | 17089 | 11285 | 313 | 0 | 10972 | 41.93842729 | -88.42861412 | 2020-09-02 04:28:25 | Kane, Illinois, US |
3566219 | 3566219 | 2020-08-25 | Zambia | 11285 | 282 | 10400 | 603 | -13.133897 | 27.849332 | 2020-08-26 04:28:11 | Zambia | |||
574186 | 574186 | 2020-06-06 | Brazil | Santa Catarina | 11285 | 166 | 0 | 11119 | -27.2423 | -50.2189 | 2020-06-07 03:53:30 | Santa Catarina, Brazil | ||
1269587 | 1269587 | 2020-06-05 | Spain | C. Valenciana | 11285 | 1332 | 9970 | 0 | 39.484 | -0.7533 | 2020-06-06 02:33:00 | C. Valenciana, Spain |
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]);