johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where confirmed = 11733 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1832921 | 1832921 | 2022-10-25 | US | Puerto Rico | Moca | 72099 | 11733 | 0 | 0 | 18.377805 | -67.080952 | 2022-10-26 04:22:19 | Moca, Puerto Rico, US | |
2971029 | 2971029 | 2022-10-10 | US | Wyoming | Teton | 56039 | 11733 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-10-11 04:23:05 | Teton, Wyoming, US | |
3101065 | 3101065 | 2022-10-09 | US | Wyoming | Teton | 56039 | 11733 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-10-10 04:22:32 | Teton, Wyoming, US | |
4006290 | 4006290 | 2022-10-08 | US | Wyoming | Teton | 56039 | 11733 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-10-09 04:21:16 | Teton, Wyoming, US | |
399887 | 399887 | 2022-10-07 | US | Wyoming | Teton | 56039 | 11733 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-10-08 04:22:56 | Teton, Wyoming, US | |
2533004 | 2533004 | 2022-10-06 | US | Wyoming | Teton | 56039 | 11733 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-10-07 04:23:08 | Teton, Wyoming, US | |
1814398 | 1814398 | 2022-10-05 | US | Wyoming | Teton | 56039 | 11733 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-10-06 04:21:22 | Teton, Wyoming, US | |
134372 | 134372 | 2022-10-04 | US | Wyoming | Teton | 56039 | 11733 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-10-05 04:23:06 | Teton, Wyoming, US | |
254379 | 254379 | 2022-09-08 | US | Illinois | Woodford | 17203 | 11733 | 114 | 0 | 40.78579374 | -89.20973757 | 2022-09-09 04:21:11 | Woodford, Illinois, US | |
1786440 | 1786440 | 2022-07-29 | US | Tennessee | Cheatham | 47021 | 11733 | 129 | 0 | 36.26136216 | -87.08903581 | 2022-07-30 04:20:42 | Cheatham, Tennessee, US | |
478882 | 478882 | 2022-06-26 | US | Washington | Douglas | 53017 | 11733 | 71 | 0 | 47.7361335 | -119.692937 | 2022-06-27 04:21:00 | Douglas, Washington, US | |
942257 | 942257 | 2022-06-25 | US | Washington | Douglas | 53017 | 11733 | 71 | 0 | 47.7361335 | -119.692937 | 2022-06-26 04:21:02 | Douglas, Washington, US | |
3350077 | 3350077 | 2022-06-24 | US | Washington | Douglas | 53017 | 11733 | 71 | 0 | 47.7361335 | -119.692937 | 2022-06-25 04:20:57 | Douglas, Washington, US | |
1851567 | 1851567 | 2022-05-26 | US | Maryland | Calvert | 24009 | 11733 | 147 | 0 | 38.53961642 | -76.56820632 | 2022-05-27 04:20:56 | Calvert, Maryland, US | |
1218540 | 1218540 | 2022-01-08 | US | Tennessee | McMinn | 47107 | 11733 | 197 | 0 | 35.42812616 | -84.61520715 | 2022-01-09 04:21:46 | McMinn, Tennessee, US | |
4001308 | 4001308 | 2021-12-30 | US | Pennsylvania | Carbon | 42025 | 11733 | 231 | 0 | 40.91545395 | -75.7068525 | 2021-12-31 04:21:50 | Carbon, Pennsylvania, US | |
716927 | 716927 | 2021-11-12 | US | Ohio | Erie | 39043 | 11733 | 199 | 0 | 41.36796058 | -82.62904521 | 2021-11-13 04:21:38 | Erie, Ohio, US | |
637326 | 637326 | 2021-10-13 | US | Virginia | Roanoke City | 51770 | 11733 | 229 | 0 | 37.27791025 | -79.96189766 | 2021-10-14 04:21:29 | Roanoke City, Virginia, US | |
1238868 | 1238868 | 2021-09-27 | US | Texas | Starr | 48427 | 11733 | 327 | 0 | 26.56150059 | -98.73892358 | 2021-09-28 04:21:28 | Starr, Texas, US | |
2079169 | 2079169 | 2021-09-26 | US | Texas | Starr | 48427 | 11733 | 327 | 0 | 26.56150059 | -98.73892358 | 2021-09-27 04:21:16 | Starr, Texas, US | |
2282402 | 2282402 | 2021-09-08 | US | Texas | Walker | 48471 | 11733 | 150 | 0 | 30.73872995 | -95.57440968 | 2021-09-09 04:21:27 | Walker, Texas, US | |
1855872 | 1855872 | 2021-08-20 | US | Missouri | Cass | 29037 | 11733 | 128 | 0 | 38.64789422 | -94.353399 | 2021-08-21 04:21:38 | Cass, Missouri, US | |
1807170 | 1807170 | 2021-05-27 | US | Alaska | Matanuska-Susitna | 2170 | 11733 | 57 | 0 | 62.31305045 | -149.5741743 | 2021-05-28 04:20:36 | Matanuska-Susitna, Alaska, US | |
2007338 | 2007338 | 2021-05-12 | US | Pennsylvania | Lycoming | 42081 | 11733 | 278 | 0 | 41.34310539 | -77.06629984 | 2021-05-13 04:20:51 | Lycoming, Pennsylvania, US | |
2414379 | 2414379 | 2021-04-19 | US | Wisconsin | Eau Claire | 55035 | 11733 | 118 | 0 | 44.726614 | -91.28609183 | 2021-04-20 04:20:41 | Eau Claire, Wisconsin, US | |
3133056 | 3133056 | 2021-04-18 | US | Wisconsin | Eau Claire | 55035 | 11733 | 118 | 0 | 44.726614 | -91.28609183 | 2021-04-19 04:20:57 | Eau Claire, Wisconsin, US | |
2568660 | 2568660 | 2021-01-25 | US | Illinois | Kankakee | 17091 | 11733 | 179 | 0 | 11554 | 41.13746989 | -87.86205334 | 2021-01-26 05:22:02 | Kankakee, Illinois, US |
774864 | 774864 | 2021-01-12 | US | Arkansas | Sebastian | 5131 | 11733 | 169 | 0 | 11564 | 35.19605503 | -94.27162713 | 2021-01-13 05:22:15 | Sebastian, Arkansas, US |
2703745 | 2703745 | 2020-11-20 | US | New York | Monroe | 36055 | 11733 | 309 | 0 | 11424 | 43.14638895 | -77.69322942 | 2020-11-21 05:25:51 | Monroe, New York, US |
755892 | 755892 | 2020-10-28 | US | Massachusetts | Norfolk | 25021 | 11733 | 964 | 0 | 10625 | 42.16073095 | -71.20530408 | 2020-10-29 04:24:49 | Norfolk, Massachusetts, US |
3119224 | 3119224 | 2020-10-06 | US | Minnesota | Ramsey | 27123 | 11733 | 328 | 0 | 11405 | 45.01625271 | -93.09872295 | 2020-10-07 04:23:40 | Ramsey, Minnesota, US |
1121884 | 1121884 | 2020-09-17 | Spain | Murcia | 11733 | 178 | 2180 | 9375 | 37.9922 | -1.1307 | 2020-09-18 05:05:00 | Murcia, Spain | ||
666573 | 666573 | 2020-09-16 | Spain | Murcia | 11733 | 178 | 2180 | 9375 | 37.9922 | -1.1307 | 2020-09-17 04:22:00 | Murcia, Spain | ||
2729298 | 2729298 | 2020-09-15 | Spain | Murcia | 11733 | 178 | 2180 | 9375 | 37.9922 | -1.1307 | 2020-09-16 04:22:53 | Murcia, Spain | ||
2510781 | 2510781 | 2020-08-27 | US | Colorado | Denver | 8031 | 11733 | 414 | 0 | 10652 | 39.76018276 | -104.8725695 | 2020-08-28 04:28:11 | Denver, Colorado, US |
3435842 | 3435842 | 2020-07-11 | Colombia | Bolivar | 11733 | 456 | 6358 | 4919 | 8.6704 | -74.03 | 2020-07-12 04:34:30 | Bolivar, Colombia |
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]);