johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
545 rows where "last_update" is on date 2020-03-11 sorted by country_or_region
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, last_update
Link | rowid | day | country_or_region ▼ | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2127563 | 2127563 | 2020-03-11 | Afghanistan | 11 | 0 | 0 | 33.0 | 65.0 | 2020-03-11T10:13:12 | |||||
2283001 | 2283001 | 2020-03-12 | Afghanistan | 11 | 0 | 0 | 33.0 | 65.0 | 2020-03-11T10:13:12 | |||||
3765508 | 3765508 | 2020-03-13 | Afghanistan | 11 | 0 | 0 | 33.0 | 65.0 | 2020-03-11T20:00:00 | |||||
2127538 | 2127538 | 2020-03-11 | Albania | 12 | 1 | 0 | 41.1533 | 20.1683 | 2020-03-11T13:33:11 | |||||
3765321 | 3765321 | 2020-03-13 | Albania | 33 | 1 | 0 | 41.1533 | 20.1683 | 2020-03-11T20:00:00 | |||||
3765341 | 3765341 | 2020-03-13 | Algeria | 26 | 2 | 8 | 28.0339 | 1.6596 | 2020-03-11T20:00:00 | |||||
3765403 | 3765403 | 2020-03-13 | Andorra | 1 | 0 | 0 | 42.5063 | 1.5218 | 2020-03-11T20:00:00 | |||||
2127669 | 2127669 | 2020-03-11 | Antarctica | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-11T10:53:02 | |||||
3765405 | 3765405 | 2020-03-13 | Antigua and Barbuda | 1 | 0 | 0 | 17.0608 | -61.7964 | 2020-03-11T20:00:00 | |||||
2127524 | 2127524 | 2020-03-11 | Argentina | 19 | 1 | 0 | -38.4161 | -63.6167 | 2020-03-11T02:18:16 | |||||
2282959 | 2282959 | 2020-03-12 | Argentina | 19 | 1 | 0 | -38.4161 | -63.6167 | 2020-03-11T02:18:16 | |||||
3765412 | 3765412 | 2020-03-13 | Argentina | 31 | 2 | 0 | -38.4161 | -63.6167 | 2020-03-11T20:00:00 | |||||
3765379 | 3765379 | 2020-03-13 | Armenia | 8 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-11T20:00:00 | |||||
3765410 | 3765410 | 2020-03-13 | Aruba | 2 | 0 | 0 | 12.5211 | -69.9683 | 2020-03-11T20:00:00 | |||||
2127490 | 2127490 | 2020-03-11 | Australia | New South Wales | 65 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-11T18:52:04 | ||||
2127517 | 2127517 | 2020-03-11 | Australia | Victoria | 21 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-11T18:52:04 | ||||
2127522 | 2127522 | 2020-03-11 | Australia | Queensland | 20 | 0 | 8 | -28.0167 | 153.4 | 2020-03-11T18:52:04 | ||||
2127549 | 2127549 | 2020-03-11 | Australia | South Australia | 9 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-11T18:52:04 | ||||
2127550 | 2127550 | 2020-03-11 | Australia | Western Australia | 9 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-11T18:52:04 | ||||
2127586 | 2127586 | 2020-03-11 | Australia | Tasmania | 3 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-11T18:52:04 | ||||
2282925 | 2282925 | 2020-03-12 | Australia | New South Wales | 65 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-11T18:52:04 | ||||
2282955 | 2282955 | 2020-03-12 | Australia | Victoria | 21 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-11T18:52:04 | ||||
2282957 | 2282957 | 2020-03-12 | Australia | Queensland | 20 | 0 | 8 | -28.0167 | 153.4 | 2020-03-11T18:52:04 | ||||
2282992 | 2282992 | 2020-03-12 | Australia | South Australia | 9 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-11T18:52:04 | ||||
2282993 | 2282993 | 2020-03-12 | Australia | Western Australia | 9 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-11T18:52:04 | ||||
2283021 | 2283021 | 2020-03-12 | Australia | Tasmania | 3 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-11T18:52:04 | ||||
3765318 | 3765318 | 2020-03-13 | Australia | Tasmania | 5 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-11T20:00:00 | ||||
3765323 | 3765323 | 2020-03-13 | Australia | New South Wales | 92 | 2 | 4 | -33.8688 | 151.2093 | 2020-03-11T20:00:00 | ||||
3765324 | 3765324 | 2020-03-13 | Australia | Victoria | 36 | 0 | 8 | -37.8136 | 144.9631 | 2020-03-11T20:00:00 | ||||
3765325 | 3765325 | 2020-03-13 | Australia | Queensland | 35 | 0 | 8 | -28.0167 | 153.4 | 2020-03-11T20:00:00 | ||||
3765326 | 3765326 | 2020-03-13 | Australia | South Australia | 16 | 0 | 3 | -34.9285 | 138.6007 | 2020-03-11T20:00:00 | ||||
3765336 | 3765336 | 2020-03-13 | Australia | Australian Capital Territory | 1 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-11T20:00:00 | ||||
3765349 | 3765349 | 2020-03-13 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-11T20:00:00 | ||||
3765384 | 3765384 | 2020-03-13 | Australia | Western Australia | 14 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-11T20:00:00 | ||||
3765422 | 3765422 | 2020-03-13 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-11T20:00:00 | ||||
2127464 | 2127464 | 2020-03-11 | Austria | 148 | 0 | 4 | 47.5162 | 14.5501 | 2020-03-11T22:33:03 | |||||
3765351 | 3765351 | 2020-03-13 | Austria | 312 | 0 | 6 | 47.5162 | 14.5501 | 2020-03-11T20:00:00 | |||||
2127540 | 2127540 | 2020-03-11 | Azerbaijan | 11 | 0 | 3 | 40.1431 | 47.5769 | 2020-03-11T08:13:09 | |||||
2282983 | 2282983 | 2020-03-12 | Azerbaijan | 11 | 0 | 3 | 40.1431 | 47.5769 | 2020-03-11T08:13:09 | |||||
3765378 | 3765378 | 2020-03-13 | Azerbaijan | 15 | 1 | 3 | 40.1431 | 47.5769 | 2020-03-11T20:00:00 | |||||
2127467 | 2127467 | 2020-03-11 | Bahrain | 195 | 0 | 35 | 26.0275 | 50.55 | 2020-03-11T22:33:03 | |||||
2282898 | 2282898 | 2020-03-12 | Bahrain | 195 | 0 | 35 | 26.0275 | 50.55 | 2020-03-11T22:33:03 | |||||
3765365 | 3765365 | 2020-03-13 | Bahrain | 189 | 0 | 44 | 26.0667 | 50.5577 | 2020-03-11T20:00:00 | |||||
3765355 | 3765355 | 2020-03-13 | Bangladesh | 3 | 0 | 0 | 23.685 | 90.3563 | 2020-03-11T20:00:00 | |||||
3765377 | 3765377 | 2020-03-13 | Belarus | 27 | 0 | 3 | 53.7098 | 27.9534 | 2020-03-11T20:00:00 | |||||
2127460 | 2127460 | 2020-03-11 | Belgium | 314 | 3 | 1 | 50.8333 | 4.0 | 2020-03-11T18:52:03 | |||||
2282891 | 2282891 | 2020-03-12 | Belgium | 314 | 3 | 1 | 50.8333 | 4.0 | 2020-03-11T18:52:03 | |||||
3765406 | 3765406 | 2020-03-13 | Belgium | 559 | 3 | 1 | 50.5039 | 4.4699 | 2020-03-11T20:00:00 | |||||
3765433 | 3765433 | 2020-03-13 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-11T20:00:00 | |||||
2127595 | 2127595 | 2020-03-11 | Bolivia | 2 | 0 | 0 | -16.2902 | -63.5887 | 2020-03-11T18:52:03 | |||||
2283028 | 2283028 | 2020-03-12 | Bolivia | 2 | 0 | 0 | -16.2902 | -63.5887 | 2020-03-11T18:52:03 | |||||
3765393 | 3765393 | 2020-03-13 | Bolivia | 3 | 0 | 0 | -16.2902 | -63.5887 | 2020-03-11T20:00:00 | |||||
2127564 | 2127564 | 2020-03-11 | Bosnia and Herzegovina | 7 | 0 | 0 | 43.9159 | 17.6791 | 2020-03-11T22:13:12 | |||||
3765427 | 3765427 | 2020-03-13 | Bosnia and Herzegovina | 13 | 0 | 0 | 43.9159 | 17.6791 | 2020-03-11T20:00:00 | |||||
2127506 | 2127506 | 2020-03-11 | Brazil | 38 | 0 | 0 | -14.235 | -51.9253 | 2020-03-11T22:13:12 | |||||
3765358 | 3765358 | 2020-03-13 | Brazil | 151 | 0 | 0 | -14.235 | -51.9253 | 2020-03-11T20:00:00 | |||||
2127541 | 2127541 | 2020-03-11 | Brunei | 11 | 0 | 0 | 4.5353 | 114.7277 | 2020-03-11T22:13:12 | |||||
2282985 | 2282985 | 2020-03-12 | Brunei | 11 | 0 | 0 | 4.5353 | 114.7277 | 2020-03-11T22:13:12 | |||||
3765445 | 3765445 | 2020-03-13 | Brunei | 37 | 0 | 0 | 4.5353 | 114.7277 | 2020-03-11T20:00:00 | |||||
2127565 | 2127565 | 2020-03-11 | Bulgaria | 7 | 1 | 0 | 42.7339 | 25.4858 | 2020-03-11T22:13:12 | |||||
2283002 | 2283002 | 2020-03-12 | Bulgaria | 7 | 1 | 0 | 42.7339 | 25.4858 | 2020-03-11T22:13:12 | |||||
3765452 | 3765452 | 2020-03-13 | Bulgaria | 23 | 1 | 0 | 42.7339 | 25.4858 | 2020-03-11T20:00:00 | |||||
2127596 | 2127596 | 2020-03-11 | Burkina Faso | 2 | 0 | 0 | 12.2383 | -1.5616 | 2020-03-11T09:33:12 | |||||
2283029 | 2283029 | 2020-03-12 | Burkina Faso | 2 | 0 | 0 | 12.2383 | -1.5616 | 2020-03-11T09:33:12 | |||||
3765320 | 3765320 | 2020-03-13 | Burkina Faso | 2 | 0 | 0 | 12.2383 | -1.5616 | 2020-03-11T20:00:00 | |||||
2127588 | 2127588 | 2020-03-11 | Cambodia | 3 | 0 | 1 | 12.5657 | 104.991 | 2020-03-11T09:33:12 | |||||
2283023 | 2283023 | 2020-03-12 | Cambodia | 3 | 0 | 1 | 12.5657 | 104.991 | 2020-03-11T09:33:12 | |||||
3765333 | 3765333 | 2020-03-13 | Cambodia | 5 | 0 | 1 | 12.5657 | 104.991 | 2020-03-11T20:00:00 | |||||
3765437 | 3765437 | 2020-03-13 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-11T20:00:00 | |||||
2111302 | 2111302 | 2020-03-14 | Canada | New Brunswick | 1 | 0 | 0 | 46.5653 | -66.4619 | 2020-03-11T23:13:06 | ||||
2127504 | 2127504 | 2020-03-11 | Canada | Ontario | 142 | 1 | 4 | 51.2538 | -85.3232 | 2020-03-11T18:52:04 | ||||
2127505 | 2127505 | 2020-03-11 | Canada | British Columbia | 39 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-11T02:18:28 | ||||
2127525 | 2127525 | 2020-03-11 | Canada | Alberta | 19 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T23:13:07 | ||||
2127557 | 2127557 | 2020-03-11 | Canada | Quebec | 27 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T23:13:06 | ||||
2127611 | 2127611 | 2020-03-11 | Canada | New Brunswick | 1 | 0 | 0 | 46.5653 | -66.4619 | 2020-03-11T23:13:06 | ||||
2282960 | 2282960 | 2020-03-12 | Canada | Alberta | 19 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T23:13:07 | ||||
2283046 | 2283046 | 2020-03-12 | Canada | New Brunswick | 1 | 0 | 0 | 46.5653 | -66.4619 | 2020-03-11T23:13:06 | ||||
3765322 | 3765322 | 2020-03-13 | Canada | British Columbia | 64 | 1 | 4 | 53.7267 | -127.6476 | 2020-03-11T20:00:00 | ||||
3765335 | 3765335 | 2020-03-13 | Canada | Ontario | 247 | 4 | 4 | 51.2538 | -85.3232 | 2020-03-11T20:00:00 | ||||
3765345 | 3765345 | 2020-03-13 | Canada | New Brunswick | 1 | 0 | 0 | 46.5653 | -66.4619 | 2020-03-11T20:00:00 | ||||
3765373 | 3765373 | 2020-03-13 | Canada | Quebec | 37 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-11T20:00:00 | ||||
3765394 | 3765394 | 2020-03-13 | Canada | Manitoba | 4 | 0 | 0 | 53.7609 | -98.8139 | 2020-03-11T20:00:00 | ||||
3765395 | 3765395 | 2020-03-13 | Canada | Saskatchewan | 2 | 0 | 0 | 52.9399 | -106.4509 | 2020-03-11T20:00:00 | ||||
3765411 | 3765411 | 2020-03-13 | Canada | Grand Princess | 2 | 0 | 0 | 37.6489 | -122.6655 | 2020-03-11T20:00:00 | ||||
3765432 | 3765432 | 2020-03-13 | Canada | Alberta | 29 | 0 | 0 | 53.9333 | -116.5765 | 2020-03-11T20:00:00 | ||||
3765385 | 3765385 | 2020-03-13 | Cayman Islands | 1 | 0 | 0 | 19.3133 | -81.2546 | 2020-03-11T20:00:00 | |||||
2127514 | 2127514 | 2020-03-11 | Chile | 23 | 0 | 0 | -35.6751 | -71.543 | 2020-03-11T22:13:12 | |||||
2282952 | 2282952 | 2020-03-12 | Chile | 23 | 0 | 0 | -35.6751 | -71.543 | 2020-03-11T22:13:12 | |||||
3765413 | 3765413 | 2020-03-13 | Chile | 43 | 0 | 0 | -35.6751 | -71.543 | 2020-03-11T20:00:00 | |||||
339650 | 339650 | 2020-03-21 | China | Anhui | 990 | 6 | 984 | 31.8257 | 117.2264 | 2020-03-11T02:18:14 | ||||
339770 | 339770 | 2020-03-21 | China | Xinjiang | 76 | 3 | 73 | 41.1129 | 85.2401 | 2020-03-11T02:18:14 | ||||
339825 | 339825 | 2020-03-21 | China | Qinghai | 18 | 0 | 18 | 35.7452 | 95.9956 | 2020-03-11T02:18:14 | ||||
339895 | 339895 | 2020-03-21 | China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-03-11T02:18:14 | ||||
1176896 | 1176896 | 2020-03-18 | China | Anhui | 990 | 6 | 984 | 31.8257 | 117.2264 | 2020-03-11T02:18:14 | ||||
1176919 | 1176919 | 2020-03-18 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 | ||||
1176988 | 1176988 | 2020-03-18 | China | Xinjiang | 76 | 3 | 73 | 41.1129 | 85.2401 | 2020-03-11T02:18:14 | ||||
1177051 | 1177051 | 2020-03-18 | China | Qinghai | 18 | 0 | 18 | 35.7452 | 95.9956 | 2020-03-11T02:18:14 | ||||
1177126 | 1177126 | 2020-03-18 | China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-03-11T02:18:14 | ||||
1463477 | 1463477 | 2020-03-15 | China | Anhui | 990 | 6 | 984 | 31.8257 | 117.2264 | 2020-03-11T02:18:14 | ||||
1463496 | 1463496 | 2020-03-15 | China | Fujian | 296 | 1 | 295 | 26.0789 | 117.9874 | 2020-03-11T02:18:14 |
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]);