johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where active = 3748 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3958474 | 3958474 | 2021-06-26 | India | Tripura | 64644 | 668 | 60228 | 3748 | 23.746783 | 91.743565 | 2021-06-27 04:21:39 | Tripura, India | ||
3030331 | 3030331 | 2021-06-16 | Japan | Tokyo | 167388 | 2183 | 161457 | 3748 | 35.711343 | 139.446921 | 2021-06-17 04:22:36 | Tokyo, Japan | ||
1416681 | 1416681 | 2021-05-24 | Ukraine | Kherson Oblast | 34218 | 1015 | 29455 | 3748 | 46.6354 | 32.6169 | 2021-05-25 04:21:08 | Kherson Oblast, Ukraine | ||
169773 | 169773 | 2021-04-16 | Brazil | Alagoas | 164404 | 3921 | 156735 | 3748 | -9.5713 | -36.782 | 2021-04-17 04:20:40 | Alagoas, Brazil | ||
2208990 | 2208990 | 2021-03-04 | US | Kansas | Seward | 20175 | 3782 | 34 | 0 | 3748 | 37.19324632 | -100.8507201 | 2021-03-05 05:26:29 | Seward, Kansas, US |
1091411 | 1091411 | 2021-03-03 | US | Kansas | Seward | 20175 | 3782 | 34 | 0 | 3748 | 37.19324632 | -100.8507201 | 2021-03-04 05:24:24 | Seward, Kansas, US |
3254828 | 3254828 | 2021-03-02 | US | Florida | DeSoto | 12027 | 3823 | 75 | 0 | 3748 | 27.18677893 | -81.80941373 | 2021-03-03 05:23:28 | DeSoto, Florida, US |
2370023 | 2370023 | 2021-02-28 | US | Oklahoma | Caddo | 40015 | 3804 | 56 | 0 | 3748 | 35.17364557 | -98.37534464 | 2021-03-01 05:23:01 | Caddo, Oklahoma, US |
3068525 | 3068525 | 2021-02-27 | US | Oklahoma | Caddo | 40015 | 3804 | 56 | 0 | 3748 | 35.17364557 | -98.37534464 | 2021-02-28 05:22:20 | Caddo, Oklahoma, US |
3068235 | 3068235 | 2021-02-27 | US | New York | Madison | 36053 | 3833 | 85 | 0 | 3748 | 42.91653905 | -75.67266639 | 2021-02-28 05:22:20 | Madison, New York, US |
1859485 | 1859485 | 2021-02-25 | US | Louisiana | Avoyelles | 22009 | 3865 | 117 | 0 | 3748 | 31.07796211 | -92.00079449 | 2021-02-26 05:22:40 | Avoyelles, Louisiana, US |
1939576 | 1939576 | 2021-02-23 | US | Texas | Jim Wells | 48249 | 4214 | 81 | 0 | 3748 | 27.73103938 | -98.0904705 | 2021-02-24 05:29:16 | Jim Wells, Texas, US |
1155396 | 1155396 | 2021-02-18 | US | North Carolina | Alexander | 37003 | 3820 | 72 | 0 | 3748 | 35.922379600000006 | -81.17751948 | 2021-02-19 05:24:16 | Alexander, North Carolina, US |
1898220 | 1898220 | 2021-01-29 | US | Indiana | Clinton | 18023 | 3796 | 48 | 0 | 3748 | 40.30319754 | -86.47277257 | 2021-01-30 05:22:49 | Clinton, Indiana, US |
3153972 | 3153972 | 2021-01-27 | US | Alabama | Franklin | 1059 | 3801 | 53 | 0 | 3748 | 34.44235334 | -87.84289505 | 2021-01-28 05:22:24 | Franklin, Alabama, US |
2570306 | 2570306 | 2021-01-25 | US | Pennsylvania | Bradford | 42015 | 3813 | 65 | 0 | 3748 | 41.78869215 | -76.51570822 | 2021-01-26 05:22:02 | Bradford, Pennsylvania, US |
908385 | 908385 | 2021-01-19 | Russia | Khabarovsk Krai | 40990 | 225 | 37017 | 3748 | 51.6312684 | 136.121524 | 2021-01-20 05:21:54 | Khabarovsk Krai, Russia | ||
3307981 | 3307981 | 2021-01-13 | Canada | Saskatchewan | 19021 | 206 | 15063 | 3748 | 52.9399 | -106.4509 | 2021-01-14 05:22:32 | Saskatchewan, Canada | ||
2628585 | 2628585 | 2021-01-10 | US | Puerto Rico | Caguas | 72025 | 3748 | 0 | 0 | 3748 | 18.211615 | -66.050779 | 2021-01-11 05:21:50 | Caguas, Puerto Rico, US |
3762305 | 3762305 | 2020-12-28 | US | Florida | Putnam | 12107 | 3819 | 71 | 0 | 3748 | 29.60779729 | -81.74230285 | 2020-12-29 05:22:37 | Putnam, Florida, US |
1603670 | 1603670 | 2020-12-10 | US | Washington | Thurston | 53067 | 3794 | 46 | 0 | 3748 | 46.9291895 | -122.8290656 | 2020-12-11 05:26:59 | Thurston, Washington, US |
924380 | 924380 | 2020-11-26 | US | Florida | Jackson | 12063 | 3837 | 89 | 0 | 3748 | 30.7954597 | -85.21500423 | 2020-11-27 05:26:53 | Jackson, Florida, US |
1973285 | 1973285 | 2020-11-25 | US | Florida | Jackson | 12063 | 3837 | 89 | 0 | 3748 | 30.7954597 | -85.21500423 | 2020-11-26 05:27:44 | Jackson, Florida, US |
1350973 | 1350973 | 2020-11-24 | US | Connecticut | Litchfield | 9005 | 3908 | 160 | 0 | 3748 | 41.7937534 | -73.2451475 | 2020-11-25 05:27:20 | Litchfield, Connecticut, US |
2191715 | 2191715 | 2020-10-21 | Netherlands | Drenthe | 3827 | 69 | 0 | 3748 | 52.862485 | 6.618435000000002 | 2020-10-22 04:24:27 | Drenthe, Netherlands | ||
1794587 | 1794587 | 2020-10-19 | India | Manipur | 15778 | 117 | 11913 | 3748 | 24.738975 | 93.882541 | 2020-10-20 04:24:22 | Manipur, India | ||
1526561 | 1526561 | 2020-08-28 | US | Virginia | Richmond City | 51760 | 3795 | 47 | 0 | 3748 | 37.53255773 | -77.47966921 | 2020-08-29 04:28:19 | Richmond City, Virginia, US |
1999313 | 1999313 | 2020-08-26 | US | Pennsylvania | Northampton | 42095 | 4046 | 298 | 0 | 3748 | 40.75182733 | -75.30471829 | 2020-08-27 04:28:15 | Northampton, Pennsylvania, US |
3486797 | 3486797 | 2020-08-20 | US | Ohio | Summit | 39153 | 3937 | 189 | 0 | 3748 | 41.12464734 | -81.53123079 | 2020-08-21 04:27:41 | Summit, Ohio, US |
3610159 | 3610159 | 2020-08-06 | US | Missouri | Jackson | 29095 | 3810 | 62 | 0 | 3748 | 39.01002188 | -94.34724536 | 2020-08-07 04:35:11 | Jackson, Missouri, US |
1500034 | 1500034 | 2020-07-25 | US | Wisconsin | Dane | 55025 | 3781 | 33 | 0 | 3748 | 43.06601594 | -89.41733797 | 2020-07-26 04:35:00 | Dane, Wisconsin, US |
2560845 | 2560845 | 2020-07-24 | US | Georgia | Clayton | 13063 | 3838 | 90 | 0 | 3748 | 33.54187245 | -84.35594188 | 2020-07-25 04:47:39 | Clayton, Georgia, US |
60704 | 60704 | 2020-07-23 | US | Louisiana | Ouachita | 22073 | 3845 | 97 | 0 | 3748 | 32.47645559 | -92.15704172 | 2020-07-24 05:30:40 | Ouachita, Louisiana, US |
1787983 | 1787983 | 2020-05-29 | US | New York | Dutchess | 36027 | 3887 | 139 | 0 | 3748 | 41.76486060000001 | -73.74356679 | 2020-05-30 02:32:48 | Dutchess, New York, US |
2899158 | 2899158 | 2020-05-09 | Argentina | 5776 | 300 | 1728 | 3748 | -38.4161 | -63.6167 | 2020-05-10 02:32:30 | Argentina | |||
42002 | 42002 | 2020-04-13 | US | New Jersey | Monmouth | 34025 | 3875 | 127 | 0 | 3748 | 40.26549699 | -74.22240686 | 2020-04-13 23:07:54 | Monmouth, New Jersey, 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]);