johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where confirmed = 11869 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3716319 | 3716319 | 2022-12-06 | US | Nevada | Lyon | 32019 | 11869 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-07 04:20:58 | Lyon, Nevada, US | |
2417024 | 2417024 | 2022-12-05 | US | Nevada | Lyon | 32019 | 11869 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-06 04:21:03 | Lyon, Nevada, US | |
720632 | 720632 | 2022-12-04 | US | Nevada | Lyon | 32019 | 11869 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-05 04:20:58 | Lyon, Nevada, US | |
2818921 | 2818921 | 2022-12-03 | US | Nevada | Lyon | 32019 | 11869 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-04 04:20:56 | Lyon, Nevada, US | |
835777 | 835777 | 2022-12-02 | US | Nevada | Lyon | 32019 | 11869 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-03 04:21:02 | Lyon, Nevada, US | |
2138307 | 2138307 | 2022-12-01 | US | Nevada | Lyon | 32019 | 11869 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-02 04:21:07 | Lyon, Nevada, US | |
1966723 | 1966723 | 2022-11-30 | US | Nevada | Lyon | 32019 | 11869 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-01 04:21:03 | Lyon, Nevada, US | |
539070 | 539070 | 2022-10-26 | Sweden | Gotland | 11869 | 81 | 0 | 57.4684 | 18.4867 | 2022-10-27 04:22:01 | Gotland, Sweden | |||
1830471 | 1830471 | 2022-10-25 | Sweden | Gotland | 11869 | 81 | 0 | 57.4684 | 18.4867 | 2022-10-26 04:22:19 | Gotland, Sweden | |||
794732 | 794732 | 2022-10-24 | Sweden | Gotland | 11869 | 81 | 0 | 57.4684 | 18.4867 | 2022-10-25 04:21:53 | Gotland, Sweden | |||
3277187 | 3277187 | 2022-10-23 | Sweden | Gotland | 11869 | 81 | 0 | 57.4684 | 18.4867 | 2022-10-24 04:22:29 | Gotland, Sweden | |||
2268225 | 2268225 | 2022-10-22 | Sweden | Gotland | 11869 | 81 | 0 | 57.4684 | 18.4867 | 2022-10-23 04:22:46 | Gotland, Sweden | |||
1592525 | 1592525 | 2022-10-21 | Sweden | Gotland | 11869 | 81 | 0 | 57.4684 | 18.4867 | 2022-10-22 04:22:53 | Gotland, Sweden | |||
2272241 | 2272241 | 2022-10-20 | Sweden | Gotland | 11869 | 81 | 0 | 57.4684 | 18.4867 | 2022-10-21 04:22:23 | Gotland, Sweden | |||
2346161 | 2346161 | 2022-08-31 | US | Puerto Rico | Cidra | 72041 | 11869 | 0 | 0 | 18.173559 | -66.161179 | 2022-09-01 04:21:03 | Cidra, Puerto Rico, US | |
1348038 | 1348038 | 2022-08-10 | US | Minnesota | Douglas | 27041 | 11869 | 120 | 0 | 45.93348491 | -95.45335469 | 2022-08-11 04:20:49 | Douglas, Minnesota, US | |
1087793 | 1087793 | 2022-08-09 | US | Minnesota | Douglas | 27041 | 11869 | 120 | 0 | 45.93348491 | -95.45335469 | 2022-08-10 04:20:57 | Douglas, Minnesota, US | |
3545208 | 3545208 | 2022-08-08 | US | Minnesota | Douglas | 27041 | 11869 | 120 | 0 | 45.93348491 | -95.45335469 | 2022-08-09 04:20:34 | Douglas, Minnesota, US | |
1071611 | 1071611 | 2022-08-07 | US | Minnesota | Douglas | 27041 | 11869 | 120 | 0 | 45.93348491 | -95.45335469 | 2022-08-08 04:21:08 | Douglas, Minnesota, US | |
1942199 | 1942199 | 2022-08-06 | US | Minnesota | Douglas | 27041 | 11869 | 120 | 0 | 45.93348491 | -95.45335469 | 2022-08-07 04:20:54 | Douglas, Minnesota, US | |
881998 | 881998 | 2022-08-05 | US | Minnesota | Douglas | 27041 | 11869 | 120 | 0 | 45.93348491 | -95.45335469 | 2022-08-06 04:20:56 | Douglas, Minnesota, US | |
2010409 | 2010409 | 2022-08-04 | US | Minnesota | Douglas | 27041 | 11869 | 120 | 0 | 45.93348491 | -95.45335469 | 2022-08-05 04:20:52 | Douglas, Minnesota, US | |
3408496 | 3408496 | 2022-07-17 | US | Texas | Burnet | 48053 | 11869 | 173 | 0 | 30.78801353 | -98.181887 | 2022-07-18 04:20:59 | Burnet, Texas, US | |
949280 | 949280 | 2022-06-14 | US | North Dakota | Stark | 38089 | 11869 | 86 | 0 | 46.80851182 | -102.6576326 | 2022-06-15 04:20:54 | Stark, North Dakota, US | |
3508480 | 3508480 | 2022-06-05 | US | Indiana | Gibson | 18051 | 11869 | 144 | 0 | 38.30393723 | -87.58054938 | 2022-06-06 04:20:57 | Gibson, Indiana, US | |
3528557 | 3528557 | 2022-06-04 | US | Indiana | Gibson | 18051 | 11869 | 144 | 0 | 38.30393723 | -87.58054938 | 2022-06-05 04:20:55 | Gibson, Indiana, US | |
3134643 | 3134643 | 2022-06-03 | US | Indiana | Gibson | 18051 | 11869 | 144 | 0 | 38.30393723 | -87.58054938 | 2022-06-04 04:20:58 | Gibson, Indiana, US | |
3000357 | 3000357 | 2022-05-24 | US | Illinois | Stephenson | 17177 | 11869 | 157 | 0 | 42.35129217 | -89.662598 | 2022-05-25 04:20:56 | Stephenson, Illinois, US | |
1171474 | 1171474 | 2022-05-20 | US | New York | Tioga | 36107 | 11869 | 85 | 0 | 42.16852837 | -76.30835812 | 2022-05-21 04:20:58 | Tioga, New York, US | |
3265609 | 3265609 | 2022-05-04 | Monaco | 11869 | 57 | 0 | 43.7333 | 7.4167 | 2022-05-05 04:20:55 | Monaco | ||||
2895770 | 2895770 | 2022-04-21 | US | Virginia | Henry | 51089 | 11869 | 264 | 0 | 36.68542395 | -79.87634026 | 2022-04-22 04:20:45 | Henry, Virginia, US | |
1846994 | 1846994 | 2022-04-18 | US | Illinois | Marion | 17121 | 11869 | 210 | 0 | 38.64963204 | -88.91899208 | 2022-04-19 04:21:00 | Marion, Illinois, US | |
3868458 | 3868458 | 2022-04-05 | US | Hawaii | Kauai | 15007 | 11869 | 28 | 0 | 22.03935037 | -159.5966786 | 2022-04-06 04:20:49 | Kauai, Hawaii, US | |
2749800 | 2749800 | 2022-04-04 | US | Hawaii | Kauai | 15007 | 11869 | 28 | 0 | 22.03935037 | -159.5966786 | 2022-04-05 04:20:48 | Kauai, Hawaii, US | |
3731146 | 3731146 | 2022-04-03 | US | Hawaii | Kauai | 15007 | 11869 | 28 | 0 | 22.03935037 | -159.5966786 | 2022-04-04 04:20:51 | Kauai, Hawaii, US | |
500581 | 500581 | 2022-04-02 | US | Hawaii | Kauai | 15007 | 11869 | 28 | 0 | 22.03935037 | -159.5966786 | 2022-04-03 04:20:48 | Kauai, Hawaii, US | |
3351566 | 3351566 | 2022-04-01 | US | Hawaii | Kauai | 15007 | 11869 | 28 | 0 | 22.03935037 | -159.5966786 | 2022-04-02 04:20:47 | Kauai, Hawaii, US | |
1540871 | 1540871 | 2022-03-31 | US | Hawaii | Kauai | 15007 | 11869 | 28 | 0 | 22.03935037 | -159.5966786 | 2022-04-01 04:20:28 | Kauai, Hawaii, US | |
2478884 | 2478884 | 2022-03-30 | US | Hawaii | Kauai | 15007 | 11869 | 28 | 0 | 22.03935037 | -159.5966786 | 2022-03-31 04:20:56 | Kauai, Hawaii, US | |
3830113 | 3830113 | 2021-12-21 | US | Michigan | Ionia | 26067 | 11869 | 135 | 0 | 42.94502238 | -85.07413319 | 2021-12-22 04:21:54 | Ionia, Michigan, US | |
1256416 | 1256416 | 2021-12-20 | US | Michigan | Ionia | 26067 | 11869 | 135 | 0 | 42.94502238 | -85.07413319 | 2021-12-21 03:21:27 | Ionia, Michigan, US | |
783301 | 783301 | 2021-12-13 | US | Hawaii | Hawaii | 15001 | 11869 | 145 | 0 | 19.60121157 | -155.5210167 | 2021-12-14 04:22:38 | Hawaii, Hawaii, US | |
151070 | 151070 | 2021-11-29 | US | Indiana | Floyd | 18043 | 11869 | 225 | 0 | 38.32117957 | -85.90385377 | 2021-11-30 04:22:53 | Floyd, Indiana, US | |
7747 | 7747 | 2021-10-28 | US | Virginia | Roanoke | 51161 | 11869 | 173 | 0 | 37.26865804 | -80.06396753 | 2021-10-29 04:22:03 | Roanoke, Virginia, US | |
3759995 | 3759995 | 2021-09-21 | US | Ohio | Wayne | 39169 | 11869 | 251 | 0 | 40.82925852 | -81.88844833 | 2021-09-22 04:21:45 | Wayne, Ohio, US | |
3218308 | 3218308 | 2021-07-26 | Japan | Hiroshima | 11869 | 179 | 11461 | 229 | 34.605309000000005 | 132.788719 | 2021-07-27 04:21:18 | Hiroshima, Japan | ||
2212663 | 2212663 | 2021-01-30 | US | Illinois | Kankakee | 17091 | 11869 | 181 | 0 | 11688 | 41.13746989 | -87.86205334 | 2021-01-31 05:22:42 | Kankakee, Illinois, US |
2483742 | 2483742 | 2021-01-28 | US | Minnesota | Wright | 27171 | 11869 | 108 | 0 | 11761 | 45.17297924 | -93.96234781 | 2021-01-29 05:22:23 | Wright, Minnesota, US |
1012526 | 1012526 | 2020-12-30 | US | New York | Dutchess | 36027 | 11869 | 233 | 0 | 11636 | 41.76486060000001 | -73.74356679 | 2020-12-31 05:22:49 | Dutchess, New York, US |
3761779 | 3761779 | 2020-12-28 | Russia | Ingushetia Republic | 11869 | 135 | 9774 | 1960 | 43.11542075 | 45.01713552 | 2020-12-29 05:22:37 | Ingushetia Republic, Russia | ||
861403 | 861403 | 2020-12-11 | US | Florida | St. Lucie | 12111 | 11869 | 377 | 0 | 11492 | 27.37763908 | -80.47106649 | 2020-12-12 05:26:19 | St. Lucie, Florida, US |
2218724 | 2218724 | 2020-08-23 | US | Texas | El Paso | 48141 | 11869 | 392 | 0 | 19004 | 31.76980765 | -106.2363275 | 2020-08-24 04:27:56 | El Paso, Texas, 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]);