johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where active = 11226 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468054 | 3468054 | 2021-08-03 | Denmark | 319295 | 2550 | 305519 | 11226 | 56.2639 | 9.5018 | 2021-08-04 04:21:25 | Denmark | |||
3705728 | 3705728 | 2021-04-27 | Ukraine | Chernihiv Oblast | 52526 | 1100 | 40200 | 11226 | 51.4982 | 31.2893 | 2021-04-28 04:20:32 | Chernihiv Oblast, Ukraine | ||
1732234 | 1732234 | 2021-03-14 | Brazil | Mato Grosso do Sul | 194882 | 3628 | 179506 | 11226 | -20.7722 | -54.7852 | 2021-03-15 05:25:51 | Mato Grosso do Sul, Brazil | ||
1675439 | 1675439 | 2021-02-07 | US | Tennessee | Sevier | 47155 | 11346 | 146 | 0 | 11226 | 35.78077323 | -83.52244332 | 2021-02-08 05:22:39 | Sevier, Tennessee, US |
1674197 | 1674197 | 2021-02-07 | US | Minnesota | Olmsted | 27109 | 11309 | 83 | 0 | 11226 | 44.00374114 | -92.40209944 | 2021-02-08 05:22:39 | Olmsted, Minnesota, US |
1684484 | 1684484 | 2021-02-02 | Italy | Friuli Venezia Giulia | 67921 | 2444 | 54251 | 11226 | 45.6494354 | 13.76813649 | 2021-02-03 05:22:52 | Friuli Venezia Giulia, Italy | ||
1897727 | 1897727 | 2021-01-29 | US | California | Shasta | 6089 | 11301 | 112 | 0 | 11226 | 40.76391419 | -122.0396884 | 2021-01-30 05:22:49 | Shasta, California, US |
910968 | 910968 | 2021-01-19 | US | South Carolina | Aiken | 45003 | 11380 | 154 | 0 | 11226 | 33.54338026 | -81.63645384 | 2021-01-20 05:21:54 | Aiken, South Carolina, US |
3233984 | 3233984 | 2021-01-03 | US | Wisconsin | Fond du Lac | 55039 | 11301 | 75 | 0 | 11226 | 43.75354908 | -88.48885325 | 2021-01-04 05:22:02 | Fond du Lac, Wisconsin, US |
2223252 | 2223252 | 2020-12-26 | Brazil | Para | 290326 | 7130 | 271445 | 11226 | -1.9981 | -54.9306 | 2020-12-27 05:22:55 | Para, Brazil | ||
2975111 | 2975111 | 2020-12-09 | Ecuador | 199228 | 13814 | 174188 | 11226 | -1.8312 | -78.1834 | 2020-12-10 05:26:19 | Ecuador | |||
1586983 | 1586983 | 2020-11-30 | US | South Carolina | Lexington | 45063 | 11454 | 228 | 0 | 11226 | 33.89665987 | -81.27146426 | 2020-12-01 05:26:18 | Lexington, South Carolina, US |
2291424 | 2291424 | 2020-10-12 | Italy | Campania | 19192 | 479 | 7487 | 11226 | 40.83956555 | 14.25084984 | 2020-10-13 04:24:02 | Campania, Italy | ||
2662453 | 2662453 | 2020-09-04 | US | Florida | Escambia | 12033 | 11418 | 192 | 0 | 11226 | 30.67652764 | -87.37284571 | 2020-09-05 04:28:19 | Escambia, Florida, US |
837346 | 837346 | 2020-08-17 | Brazil | Amapa | 39703 | 617 | 27860 | 11226 | 0.902 | -52.003 | 2020-08-18 04:27:56 | Amapa, Brazil | ||
371131 | 371131 | 2020-08-08 | US | Arizona | Yuma | 4027 | 11512 | 286 | 0 | 11226 | 32.76895712 | -113.90666740000002 | 2020-08-09 04:34:54 | Yuma, Arizona, US |
2305137 | 2305137 | 2020-06-28 | US | Connecticut | New Haven | 9009 | 12299 | 1073 | 0 | 11226 | 41.4080325 | -72.93620426 | 2020-06-29 04:33:44 | New Haven, Connecticut, 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]);