johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where active = 5750 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385527 | 3385527 | 2021-07-29 | Nigeria | 172821 | 2141 | 164930 | 5750 | 9.082 | 8.6753 | 2021-07-30 04:21:34 | Nigeria | |||
3385347 | 3385347 | 2021-07-29 | India | Meghalaya | 63745 | 1062 | 56933 | 5750 | 25.536934 | 91.278882 | 2021-07-30 04:21:34 | Meghalaya, India | ||
829207 | 829207 | 2021-06-06 | Ukraine | Kharkiv Oblast | 147380 | 3362 | 138268 | 5750 | 49.9935 | 36.2304 | 2021-06-07 04:22:51 | Kharkiv Oblast, Ukraine | ||
1092319 | 1092319 | 2021-03-03 | US | New York | Ontario | 36069 | 5839 | 89 | 0 | 5750 | 42.85145728 | -77.30874425 | 2021-03-04 05:24:24 | Ontario, New York, US |
1860438 | 1860438 | 2021-02-25 | US | Ohio | Ashtabula | 39007 | 5907 | 157 | 0 | 5750 | 41.70860332 | -80.74830218 | 2021-02-26 05:22:40 | Ashtabula, Ohio, US |
533668 | 533668 | 2021-02-22 | US | Tennessee | McMinn | 47107 | 5849 | 89 | 0 | 5750 | 35.42812616 | -84.61520715 | 2021-02-23 05:23:41 | McMinn, Tennessee, US |
184542 | 184542 | 2021-02-21 | US | Ohio | Scioto | 39145 | 5846 | 96 | 0 | 5750 | 38.80270163 | -82.98907345 | 2021-02-22 05:24:21 | Scioto, Ohio, US |
743387 | 743387 | 2021-02-20 | US | Indiana | Dubois | 18037 | 5856 | 106 | 0 | 5750 | 38.36597551 | -86.87924170000002 | 2021-02-21 05:24:33 | Dubois, Indiana, US |
340264 | 340264 | 2021-02-03 | Italy | P.A. Bolzano | 41775 | 885 | 35140 | 5750 | 46.49933453 | 11.35662422 | 2021-02-04 05:22:26 | P.A. Bolzano, Italy | ||
1461922 | 1461922 | 2021-01-31 | US | New Jersey | Hunterdon | 34019 | 5897 | 147 | 0 | 5750 | 40.56335249 | -74.91284156 | 2021-02-01 05:22:53 | Hunterdon, New Jersey, US |
15604 | 15604 | 2021-01-26 | US | Utah | Tooele | 49045 | 5770 | 20 | 0 | 5750 | 40.44862644 | -113.1295715 | 2021-01-27 05:23:41 | Tooele, Utah, US |
238613 | 238613 | 2021-01-18 | US | Kentucky | Campbell | 21037 | 5784 | 34 | 0 | 5750 | 38.94384345 | -84.37875208 | 2021-01-19 05:22:15 | Campbell, Kentucky, US |
3102175 | 3102175 | 2021-01-16 | US | Florida | Walton | 12131 | 5809 | 59 | 0 | 5750 | 30.64204028 | -86.16935664 | 2021-01-17 05:22:17 | Walton, Florida, US |
2625904 | 2625904 | 2021-01-10 | Japan | Osaka | 34487 | 673 | 28064 | 5750 | 34.620965000000005 | 135.507481 | 2021-01-11 05:21:50 | Osaka, Japan | ||
2932308 | 2932308 | 2020-12-19 | US | Indiana | Howard | 18067 | 5863 | 113 | 0 | 5750 | 40.48527731 | -86.11351892 | 2020-12-20 05:27:32 | Howard, Indiana, US |
824998 | 824998 | 2020-11-19 | US | Washington | Franklin | 53021 | 5820 | 70 | 0 | 5750 | 46.53351425 | -118.9018212 | 2020-11-20 05:26:28 | Franklin, Washington, US |
126283 | 126283 | 2020-11-18 | US | Wisconsin | Walworth | 55127 | 5796 | 46 | 0 | 5750 | 42.66858202 | -88.54163073 | 2020-11-19 05:25:23 | Walworth, Wisconsin, US |
2881151 | 2881151 | 2020-11-15 | US | Idaho | Twin Falls | 16083 | 5817 | 67 | 0 | 5750 | 42.35440512 | -114.6685381 | 2020-11-16 05:25:57 | Twin Falls, Idaho, US |
2880282 | 2880282 | 2020-11-15 | Mexico | Campeche | 6627 | 877 | 0 | 5750 | 19.8301 | -90.5349 | 2020-11-16 05:25:57 | Campeche, Mexico | ||
2920073 | 2920073 | 2020-11-04 | US | Georgia | Whitfield | 13313 | 5814 | 64 | 0 | 5750 | 34.80987459 | -84.96093476 | 2020-11-05 06:05:03 | Whitfield, Georgia, US |
2498910 | 2498910 | 2020-11-03 | US | Georgia | Whitfield | 13313 | 5814 | 64 | 0 | 5750 | 34.80987459 | -84.96093476 | 2020-11-04 05:25:09 | Whitfield, Georgia, US |
2083497 | 2083497 | 2020-10-31 | US | Wisconsin | Rock | 55105 | 5796 | 46 | 0 | 5750 | 42.67151616 | -89.07147900000002 | 2020-11-01 04:36:19 | Rock, Wisconsin, US |
3482927 | 3482927 | 2020-10-26 | US | Oregon | Marion | 41047 | 5858 | 108 | 0 | 5750 | 44.90287942 | -122.5815117 | 2020-10-27 04:24:45 | Marion, Oregon, US |
1029964 | 1029964 | 2020-10-17 | Ukraine | Dnipropetrovsk Oblast | 10721 | 239 | 4732 | 5750 | 48.4647 | 35.0462 | 2020-10-18 04:24:25 | Dnipropetrovsk Oblast, Ukraine | ||
817296 | 817296 | 2020-10-09 | Bosnia and Herzegovina | 29917 | 926 | 23241 | 5750 | 43.9159 | 17.6791 | 2020-10-10 04:23:57 | Bosnia and Herzegovina | |||
2848581 | 2848581 | 2020-09-18 | Brazil | Maranhao | 166580 | 3632 | 157198 | 5750 | -4.9609 | -45.2744 | 2020-09-19 04:22:00 | Maranhao, Brazil | ||
2729139 | 2729139 | 2020-09-15 | Oman | 90660 | 797 | 84113 | 5750 | 21.512583 | 55.92325500000001 | 2020-09-16 04:22:53 | Oman | |||
2872156 | 2872156 | 2020-09-13 | US | Washington | Spokane | 53063 | 5891 | 141 | 0 | 5750 | 47.62113146 | -117.4046494 | 2020-09-14 04:26:00 | Spokane, Washington, US |
147759 | 147759 | 2020-08-15 | US | Mississippi | Hinds | 28049 | 5878 | 128 | 0 | 5750 | 32.2656285 | -90.44435448 | 2020-08-16 04:27:42 | Hinds, Mississippi, US |
2748211 | 2748211 | 2020-07-15 | Brazil | Rio Grande do Sul | 42239 | 1101 | 35388 | 5750 | -30.0346 | -51.2177 | 2020-07-16 04:44:59 | Rio Grande do Sul, Brazil | ||
2698351 | 2698351 | 2020-06-24 | US | Georgia | Fulton | 13121 | 6052 | 302 | 0 | 5750 | 33.79216944 | -84.46319413 | 2020-06-25 05:26:54 | Fulton, Georgia, US |
2387357 | 2387357 | 2020-05-19 | US | Massachusetts | Bristol | 25005 | 6080 | 330 | 0 | 5750 | 41.79228404 | -71.10872211 | 2020-05-20 02:32:19 | Bristol, Massachusetts, US |
1199294 | 1199294 | 2020-04-22 | Chile | 11296 | 160 | 5386 | 5750 | -35.6751 | -71.543 | 2020-04-22 23:30:32 | Chile |
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]);