johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where active = 3791 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1310089 | 1310089 | 2021-05-26 | Germany | Sachsen-Anhalt | 97834 | 3294 | 90900 | 3791 | 51.9503 | 11.6923 | 2021-05-27 04:20:59 | Sachsen-Anhalt, Germany | ||
3578230 | 3578230 | 2021-05-17 | Ukraine | Rivne Oblast | 75714 | 1135 | 70788 | 3791 | 50.6199 | 26.2516 | 2021-05-18 04:20:33 | Rivne Oblast, Ukraine | ||
2209971 | 2209971 | 2021-03-04 | US | North Carolina | Haywood | 37087 | 3877 | 86 | 0 | 3791 | 35.55269063 | -82.98196486 | 2021-03-05 05:26:29 | Haywood, North Carolina, US |
1090423 | 1090423 | 2021-03-03 | US | Alabama | Chilton | 1021 | 3891 | 100 | 0 | 3791 | 32.85044126 | -86.7173256 | 2021-03-04 05:24:24 | Chilton, Alabama, US |
3255344 | 3255344 | 2021-03-02 | US | Iowa | Jasper | 19099 | 3857 | 66 | 0 | 3791 | 41.68576082 | -93.05567785 | 2021-03-03 05:23:28 | Jasper, Iowa, US |
282390 | 282390 | 2021-02-24 | US | New Mexico | Unassigned | 90035 | 3791 | 0 | 0 | 3791 | 36.60569702 | -108.7151824 | 2021-02-25 05:24:57 | Unassigned, New Mexico, US |
184954 | 184954 | 2021-02-21 | US | Tennessee | Cheatham | 47021 | 3867 | 43 | 0 | 3791 | 36.26136216 | -87.08903581 | 2021-02-22 05:24:21 | Cheatham, Tennessee, US |
183577 | 183577 | 2021-02-21 | US | Louisiana | Webster | 22119 | 3883 | 92 | 0 | 3791 | 32.70847669 | -93.33121835 | 2021-02-22 05:24:21 | Webster, Louisiana, US |
183278 | 183278 | 2021-02-21 | US | Iowa | Wapello | 19179 | 3896 | 105 | 0 | 3791 | 41.03064984 | -92.40954728 | 2021-02-22 05:24:21 | Wapello, Iowa, US |
744415 | 744415 | 2021-02-20 | US | Nebraska | Platte | 31141 | 3838 | 47 | 0 | 3791 | 41.57246836 | -97.52144359 | 2021-02-21 05:24:33 | Platte, Nebraska, US |
473150 | 473150 | 2021-02-19 | US | Minnesota | Nobles | 27105 | 3838 | 47 | 0 | 3791 | 43.67434621 | -95.75329576 | 2021-02-20 05:22:51 | Nobles, Minnesota, US |
2286990 | 2286990 | 2021-02-14 | US | Wisconsin | Polk | 55095 | 3834 | 43 | 0 | 3791 | 45.46130348 | -92.44182875 | 2021-02-15 05:24:49 | Polk, Wisconsin, US |
2286344 | 2286344 | 2021-02-14 | US | Tennessee | Cocke | 47029 | 3880 | 90 | 0 | 3791 | 35.9278914 | -83.11828725 | 2021-02-15 05:24:49 | Cocke, Tennessee, US |
2681130 | 2681130 | 2021-02-13 | US | Virginia | Campbell | 51031 | 3824 | 33 | 0 | 3791 | 37.20553386 | -79.09678609 | 2021-02-14 05:23:43 | Campbell, Virginia, US |
3980189 | 3980189 | 2021-02-10 | US | Michigan | Cass | 26027 | 3849 | 58 | 0 | 3791 | 41.91522292 | -85.99405727 | 2021-02-11 05:23:55 | Cass, Michigan, US |
1590468 | 1590468 | 2021-02-05 | US | North Carolina | Chatham | 37037 | 3861 | 70 | 0 | 3791 | 35.70394416 | -79.25541492 | 2021-02-06 05:23:55 | Chatham, North Carolina, US |
1462424 | 1462424 | 2021-01-31 | US | Pennsylvania | Huntingdon | 42061 | 3906 | 115 | 0 | 3791 | 40.42162652 | -77.97673273 | 2021-02-01 05:22:53 | Huntingdon, Pennsylvania, US |
2483801 | 2483801 | 2021-01-28 | US | Mississippi | Pontotoc | 28115 | 3853 | 62 | 0 | 3791 | 34.226046000000004 | -89.03636807 | 2021-01-29 05:22:23 | Pontotoc, Mississippi, US |
1760947 | 1760947 | 2021-01-24 | US | Michigan | Marquette | 26103 | 3845 | 54 | 0 | 3791 | 46.4338914 | -87.64043701 | 2021-01-25 05:22:16 | Marquette, Michigan, US |
2428554 | 2428554 | 2021-01-23 | US | Michigan | Marquette | 26103 | 3845 | 54 | 0 | 3791 | 46.4338914 | -87.64043701 | 2021-01-24 05:22:35 | Marquette, Michigan, US |
1097535 | 1097535 | 2021-01-20 | US | Washington | Skagit | 53057 | 3837 | 46 | 0 | 3791 | 48.48171488 | -121.766131 | 2021-01-21 05:22:01 | Skagit, Washington, US |
1097063 | 1097063 | 2021-01-20 | US | Tennessee | Rhea | 47143 | 3742 | 56 | 0 | 3791 | 35.60536161 | -84.93076643 | 2021-01-21 05:22:01 | Rhea, Tennessee, US |
3880583 | 3880583 | 2021-01-14 | US | Illinois | Marion | 17121 | 3896 | 105 | 0 | 3791 | 38.64963204 | -88.91899208 | 2021-01-15 05:22:24 | Marion, Illinois, US |
3879993 | 3879993 | 2021-01-14 | US | Alaska | Kenai Peninsula | 2122 | 3810 | 19 | 0 | 3791 | 60.24429722 | -151.53888840000005 | 2021-01-15 05:22:24 | Kenai Peninsula, Alaska, US |
1065472 | 1065472 | 2021-01-04 | Ukraine | Kirovohrad Oblast | 8573 | 260 | 4522 | 3791 | 48.5079 | 32.2623 | 2021-01-05 05:21:49 | Kirovohrad Oblast, Ukraine | ||
1062937 | 1062937 | 2021-01-04 | US | Indiana | Jackson | 18071 | 3845 | 54 | 0 | 3791 | 38.90915820000001 | -86.03851889 | 2021-01-05 05:21:49 | Jackson, Indiana, US |
768843 | 768843 | 2020-12-29 | US | Oklahoma | Bryan | 40013 | 3823 | 32 | 0 | 3791 | 33.96472458 | -96.25903472 | 2020-12-30 05:22:34 | Bryan, Oklahoma, US |
766352 | 766352 | 2020-12-29 | Japan | Osaka | 29415 | 562 | 25062 | 3791 | 34.620965000000005 | 135.507481 | 2020-12-30 05:22:34 | Osaka, Japan | ||
2224506 | 2224506 | 2020-12-26 | US | Illinois | Knox | 17095 | 3884 | 93 | 0 | 3791 | 40.93148779 | -90.21330340000002 | 2020-12-27 05:22:55 | Knox, Illinois, US |
1752851 | 1752851 | 2020-12-14 | US | Massachusetts | Barnstable | 25001 | 3998 | 181 | 0 | 3791 | 41.72980578 | -70.28854339 | 2020-12-15 05:26:38 | Barnstable, Massachusetts, US |
861640 | 861640 | 2020-12-11 | US | Illinois | Clinton | 17027 | 3854 | 63 | 0 | 3791 | 38.60704876 | -89.42385254 | 2020-12-12 05:26:19 | Clinton, Illinois, US |
1634588 | 1634588 | 2020-12-05 | US | North Carolina | Caldwell | 37027 | 3816 | 25 | 0 | 3791 | 35.95204977 | -81.54799522 | 2020-12-06 05:26:18 | Caldwell, North Carolina, US |
393112 | 393112 | 2020-11-27 | US | Georgia | Troup | 13285 | 3911 | 120 | 0 | 3791 | 33.03349196 | -85.02812115 | 2020-11-28 05:25:50 | Troup, Georgia, US |
1975952 | 1975952 | 2020-11-25 | US | Virginia | Montgomery | 51121 | 3806 | 15 | 0 | 3791 | 37.17746986 | -80.37868691 | 2020-11-26 05:27:44 | Montgomery, Virginia, US |
824102 | 824102 | 2020-11-19 | US | Oklahoma | Comanche | 40031 | 3819 | 28 | 0 | 3791 | 34.65973764 | -98.47195055 | 2020-11-20 05:26:28 | Comanche, Oklahoma, US |
3171334 | 3171334 | 2020-11-16 | US | Minnesota | Clay | 27027 | 3841 | 50 | 0 | 3791 | 46.89289518 | -96.48761922 | 2020-11-17 05:25:54 | Clay, Minnesota, US |
377275 | 377275 | 2020-11-06 | US | Indiana | Johnson | 18081 | 3957 | 166 | 0 | 3791 | 39.48994426 | -86.10149107 | 2020-11-07 05:24:52 | Johnson, Indiana, US |
893689 | 893689 | 2020-11-05 | US | Maryland | Harford | 24025 | 3873 | 82 | 0 | 3791 | 39.55010644 | -76.30775940000002 | 2020-11-06 05:24:55 | Harford, Maryland, US |
3409693 | 3409693 | 2020-11-01 | Russia | Tver Oblast | 9731 | 326 | 5614 | 3791 | 57.1134475 | 35.174442799999994 | 2020-11-02 05:25:04 | Tver Oblast, Russia | ||
1026070 | 1026070 | 2020-10-17 | Azerbaijan | 44317 | 623 | 39903 | 3791 | 40.1431 | 47.5769 | 2020-10-18 04:24:25 | Azerbaijan | |||
1823552 | 1823552 | 2020-10-04 | US | Georgia | Columbia | 13073 | 3853 | 62 | 0 | 3791 | 33.54534185 | -82.263524 | 2020-10-05 04:23:33 | Columbia, Georgia, US |
2813570 | 2813570 | 2020-09-25 | US | Georgia | Lowndes | 13185 | 3872 | 81 | 0 | 3791 | 30.83568832 | -83.27056716 | 2020-09-26 04:23:00 | Lowndes, Georgia, US |
1446198 | 1446198 | 2020-09-11 | US | Michigan | Genesee | 26049 | 4096 | 305 | 0 | 3791 | 43.02244215 | -83.70589709 | 2020-09-12 04:25:05 | Genesee, Michigan, US |
1174136 | 1174136 | 2020-09-10 | US | Illinois | Champaign | 17019 | 3811 | 20 | 0 | 3791 | 40.13919438 | -88.20046615 | 2020-09-11 04:46:23 | Champaign, Illinois, US |
1108176 | 1108176 | 2020-09-02 | US | Oregon | Washington | 41067 | 3838 | 47 | 0 | 3791 | 45.55972701 | -123.0955257 | 2020-09-03 04:28:22 | Washington, Oregon, US |
3934695 | 3934695 | 2020-08-30 | US | Pennsylvania | Northampton | 42095 | 4091 | 300 | 0 | 3791 | 40.75182733 | -75.30471829 | 2020-08-31 04:28:27 | Northampton, Pennsylvania, US |
1705498 | 1705498 | 2020-07-21 | US | Kansas | Johnson | 20091 | 3886 | 95 | 0 | 3791 | 38.88548175 | -94.82250877 | 2020-07-22 04:34:42 | Johnson, Kansas, US |
3329719 | 3329719 | 2020-05-11 | US | Wisconsin | Milwaukee | 55079 | 4022 | 231 | 0 | 3791 | 43.00486062 | -87.96733172 | 2020-05-12 03:32:27 | Milwaukee, Wisconsin, 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]);