johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
261 rows where "last_update" is on date 2020-03-06 sorted by province_or_state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62533 | 62533 | 2020-03-07 | Denmark | 23 | 0 | 1 | 56.2639 | 9.5018 | 2020-03-06T13:03:12 | |||||
62535 | 62535 | 2020-03-07 | Lebanon | 22 | 0 | 1 | 33.8547 | 35.8623 | 2020-03-06T20:33:03 | |||||
62538 | 62538 | 2020-03-07 | Israel | 25 | 0 | 0 | 31.0 | 35.0 | 2020-03-06T20:33:03 | |||||
62542 | 62542 | 2020-03-07 | Ireland | 18 | 0 | 0 | 53.1424 | -7.6921 | 2020-03-06T20:43:03 | |||||
62545 | 62545 | 2020-03-07 | Algeria | 17 | 0 | 0 | 28.0339 | 1.6596 | 2020-03-06T01:29:39 | |||||
62547 | 62547 | 2020-03-07 | Egypt | 15 | 0 | 1 | 26.0 | 30.0 | 2020-03-06T13:03:13 | |||||
62548 | 62548 | 2020-03-07 | Finland | 28 | 1 | 1 | 64.0 | 26.0 | 2020-03-06T13:03:12 | |||||
62551 | 62551 | 2020-03-07 | Brazil | 13 | 0 | 0 | -14.235 | -51.9253 | 2020-03-06T20:33:03 | |||||
62553 | 62553 | 2020-03-07 | Russia | 13 | 0 | 2 | 60.0 | 90.0 | 2020-03-06T20:43:03 | |||||
62557 | 62557 | 2020-03-07 | Estonia | 10 | 0 | 0 | 58.5953 | 25.0136 | 2020-03-06T13:03:13 | |||||
62565 | 62565 | 2020-03-07 | Slovenia | 7 | 0 | 0 | 46.1512 | 14.9955 | 2020-03-06T15:33:03 | |||||
62567 | 62567 | 2020-03-07 | Mexico | 6 | 0 | 1 | 23.0 | -102.0 | 2020-03-06T16:43:04 | |||||
62568 | 62568 | 2020-03-07 | Pakistan | 6 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-06T13:03:12 | |||||
62573 | 62573 | 2020-03-07 | Poland | 5 | 0 | 0 | 51.9194 | 19.1451 | 2020-03-06T16:43:04 | |||||
62581 | 62581 | 2020-03-07 | Indonesia | 4 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-06T12:33:03 | |||||
62589 | 62589 | 2020-03-07 | North Macedonia | 3 | 0 | 0 | 41.6086 | 21.7453 | 2020-03-06T20:23:11 | |||||
62602 | 62602 | 2020-03-07 | Dominican Republic | 2 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-06T15:33:03 | |||||
62603 | 62603 | 2020-03-07 | Luxembourg | 2 | 0 | 0 | 49.8144 | 6.1317 | 2020-03-06T01:29:39 | |||||
62626 | 62626 | 2020-03-07 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-06T15:43:02 | |||||
62628 | 62628 | 2020-03-07 | Cameroon | 1 | 0 | 0 | 3.848 | 11.5021 | 2020-03-06T15:43:02 | |||||
62644 | 62644 | 2020-03-07 | Peru | 1 | 1 | 0 | -9.19 | -75.0152 | 2020-03-06T15:43:02 | |||||
62645 | 62645 | 2020-03-07 | Serbia | 1 | 0 | 0 | 44.0165 | 21.0059 | 2020-03-06T15:43:02 | |||||
62646 | 62646 | 2020-03-07 | Slovakia | 1 | 0 | 0 | 48.669 | 19.699 | 2020-03-06T13:03:14 | |||||
62647 | 62647 | 2020-03-07 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
62688 | 62688 | 2020-03-07 | Vatican City | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-06T15:43:02 | |||||
657780 | 657780 | 2020-03-09 | Estonia | 10 | 0 | 0 | 58.5953 | 25.0136 | 2020-03-06T13:03:13 | |||||
657825 | 657825 | 2020-03-09 | North Macedonia | 3 | 0 | 0 | 41.6086 | 21.7453 | 2020-03-06T20:23:11 | |||||
657869 | 657869 | 2020-03-09 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-06T15:43:02 | |||||
657882 | 657882 | 2020-03-09 | Serbia | 1 | 0 | 0 | 44.0165 | 21.0059 | 2020-03-06T15:43:02 | |||||
657941 | 657941 | 2020-03-09 | Vatican City | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-06T15:43:02 | |||||
1527294 | 1527294 | 2020-03-08 | Estonia | 10 | 0 | 0 | 58.5953 | 25.0136 | 2020-03-06T13:03:13 | |||||
1527337 | 1527337 | 2020-03-08 | North Macedonia | 3 | 0 | 0 | 41.6086 | 21.7453 | 2020-03-06T20:23:11 | |||||
1527375 | 1527375 | 2020-03-08 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-06T15:43:02 | |||||
1527389 | 1527389 | 2020-03-08 | Serbia | 1 | 0 | 0 | 44.0165 | 21.0059 | 2020-03-06T15:43:02 | |||||
1527446 | 1527446 | 2020-03-08 | Vatican City | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-06T15:43:02 | |||||
2127610 | 2127610 | 2020-03-11 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-06T15:43:02 | |||||
2283045 | 2283045 | 2020-03-12 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-06T15:43:02 | |||||
3177476 | 3177476 | 2020-03-06 | South Korea | 6593 | 42 | 135 | 36.0 | 128.0 | 2020-03-06T13:33:03 | |||||
3177477 | 3177477 | 2020-03-06 | Iran | 4747 | 124 | 913 | 32.0 | 53.0 | 2020-03-06T12:23:04 | |||||
3177478 | 3177478 | 2020-03-06 | Italy | 4636 | 197 | 523 | 43.0 | 12.0 | 2020-03-06T17:33:03 | |||||
3177487 | 3177487 | 2020-03-06 | Germany | 670 | 0 | 17 | 51.0 | 9.0 | 2020-03-06T17:53:03 | |||||
3177488 | 3177488 | 2020-03-06 | France | 613 | 9 | 12 | 47.0 | 2.0 | 2020-03-06T20:13:13 | |||||
3177494 | 3177494 | 2020-03-06 | Japan | 420 | 6 | 46 | 36.0 | 138.0 | 2020-03-06T20:13:13 | |||||
3177495 | 3177495 | 2020-03-06 | Spain | 400 | 5 | 2 | 40.0 | -4.0 | 2020-03-06T20:13:13 | |||||
3177501 | 3177501 | 2020-03-06 | Switzerland | 214 | 1 | 3 | 46.8182 | 8.2275 | 2020-03-06T15:23:19 | |||||
3177508 | 3177508 | 2020-03-06 | Singapore | 130 | 0 | 78 | 1.2833 | 103.8333 | 2020-03-06T13:03:12 | |||||
3177509 | 3177509 | 2020-03-06 | Netherlands | 128 | 1 | 0 | 52.1326 | 5.2913 | 2020-03-06T13:23:06 | |||||
3177512 | 3177512 | 2020-03-06 | Belgium | 109 | 0 | 1 | 50.8333 | 4.0 | 2020-03-06T12:33:03 | |||||
3177513 | 3177513 | 2020-03-06 | Norway | 108 | 0 | 0 | 60.472 | 8.4689 | 2020-03-06T16:33:04 | |||||
3177515 | 3177515 | 2020-03-06 | Sweden | 101 | 0 | 0 | 63.0 | 16.0 | 2020-03-06T13:03:12 | |||||
3177520 | 3177520 | 2020-03-06 | Bahrain | 60 | 0 | 4 | 26.0275 | 50.55 | 2020-03-06T15:33:03 | |||||
3177523 | 3177523 | 2020-03-06 | Austria | 37 | 0 | 0 | 47.5162 | 14.5501 | 2020-03-06T16:33:04 | |||||
3177524 | 3177524 | 2020-03-06 | Thailand | 48 | 1 | 31 | 15.0 | 101.0 | 2020-03-06T08:33:03 | |||||
3177525 | 3177525 | 2020-03-06 | Greece | 45 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-06T13:03:12 | |||||
3177528 | 3177528 | 2020-03-06 | Iceland | 43 | 0 | 0 | 64.9631 | -19.0208 | 2020-03-06T15:33:03 | |||||
3177529 | 3177529 | 2020-03-06 | Iraq | 40 | 3 | 0 | 33.0 | 44.0 | 2020-03-06T13:23:06 | |||||
3177530 | 3177530 | 2020-03-06 | India | 31 | 0 | 3 | 21.0 | 78.0 | 2020-03-06T13:03:12 | |||||
3177534 | 3177534 | 2020-03-06 | Denmark | 23 | 0 | 1 | 56.2639 | 9.5018 | 2020-03-06T13:03:12 | |||||
3177535 | 3177535 | 2020-03-06 | Lebanon | 22 | 0 | 1 | 33.8547 | 35.8623 | 2020-03-06T20:33:03 | |||||
3177537 | 3177537 | 2020-03-06 | Israel | 21 | 0 | 0 | 31.0 | 35.0 | 2020-03-06T20:33:03 | |||||
3177542 | 3177542 | 2020-03-06 | Czech Republic | 18 | 0 | 0 | 49.8175 | 15.473 | 2020-03-06T16:33:04 | |||||
3177543 | 3177543 | 2020-03-06 | Ireland | 18 | 0 | 0 | 53.1424 | -7.6921 | 2020-03-06T20:43:03 | |||||
3177545 | 3177545 | 2020-03-06 | Algeria | 17 | 0 | 0 | 28.0339 | 1.6596 | 2020-03-06T01:29:39 | |||||
3177547 | 3177547 | 2020-03-06 | Palestine | 16 | 0 | 0 | 31.9522 | 35.2332 | 2020-03-06T20:33:03 | |||||
3177550 | 3177550 | 2020-03-06 | Egypt | 15 | 0 | 1 | 26.0 | 30.0 | 2020-03-06T13:03:13 | |||||
3177551 | 3177551 | 2020-03-06 | Finland | 21 | 0 | 1 | 64.0 | 26.0 | 2020-03-06T13:03:12 | |||||
3177553 | 3177553 | 2020-03-06 | Brazil | 13 | 0 | 0 | -14.235 | -51.9253 | 2020-03-06T20:33:03 | |||||
3177555 | 3177555 | 2020-03-06 | Portugal | 13 | 0 | 0 | 39.3999 | -8.2245 | 2020-03-06T20:33:03 | |||||
3177556 | 3177556 | 2020-03-06 | Russia | 13 | 0 | 2 | 60.0 | 90.0 | 2020-03-06T20:43:03 | |||||
3177558 | 3177558 | 2020-03-06 | Croatia | 11 | 0 | 0 | 45.1667 | 15.5 | 2020-03-06T08:33:03 | |||||
3177560 | 3177560 | 2020-03-06 | Estonia | 10 | 0 | 0 | 58.5953 | 25.0136 | 2020-03-06T13:03:13 | |||||
3177562 | 3177562 | 2020-03-06 | Romania | 9 | 0 | 1 | 46.0 | 25.0 | 2020-03-06T16:43:04 | |||||
3177565 | 3177565 | 2020-03-06 | Slovenia | 7 | 0 | 0 | 46.1512 | 14.9955 | 2020-03-06T15:33:03 | |||||
3177568 | 3177568 | 2020-03-06 | Mexico | 6 | 0 | 1 | 23.0 | -102.0 | 2020-03-06T16:43:04 | |||||
3177569 | 3177569 | 2020-03-06 | Pakistan | 6 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-06T13:03:12 | |||||
3177570 | 3177570 | 2020-03-06 | Philippines | 5 | 1 | 1 | 13.0 | 122.0 | 2020-03-06T07:03:05 | |||||
3177571 | 3177571 | 2020-03-06 | Poland | 5 | 0 | 0 | 51.9194 | 19.1451 | 2020-03-06T16:43:04 | |||||
3177578 | 3177578 | 2020-03-06 | Indonesia | 4 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-06T12:33:03 | |||||
3177579 | 3177579 | 2020-03-06 | New Zealand | 4 | 0 | 0 | -40.9006 | 174.886 | 2020-03-06T01:29:39 | |||||
3177582 | 3177582 | 2020-03-06 | North Macedonia | 3 | 0 | 0 | 41.6086 | 21.7453 | 2020-03-06T20:23:11 | |||||
3177590 | 3177590 | 2020-03-06 | Argentina | 2 | 0 | 0 | -38.4161 | -63.6167 | 2020-03-06T01:29:39 | |||||
3177593 | 3177593 | 2020-03-06 | Dominican Republic | 2 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-06T15:33:03 | |||||
3177595 | 3177595 | 2020-03-06 | Luxembourg | 2 | 0 | 0 | 49.8144 | 6.1317 | 2020-03-06T01:29:39 | |||||
3177615 | 3177615 | 2020-03-06 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-06T15:43:02 | |||||
3177617 | 3177617 | 2020-03-06 | Cameroon | 1 | 0 | 0 | 3.848 | 11.5021 | 2020-03-06T15:43:02 | |||||
3177620 | 3177620 | 2020-03-06 | Colombia | 1 | 0 | 0 | 4.5709 | -74.2973 | 2020-03-06T20:43:03 | |||||
3177621 | 3177621 | 2020-03-06 | Costa Rica | 1 | 0 | 0 | 9.7489 | -83.7534 | 2020-03-06T01:29:39 | |||||
3177632 | 3177632 | 2020-03-06 | Peru | 1 | 1 | 0 | -9.19 | -75.0152 | 2020-03-06T15:43:02 | |||||
3177633 | 3177633 | 2020-03-06 | Serbia | 1 | 0 | 0 | 44.0165 | 21.0059 | 2020-03-06T15:43:02 | |||||
3177634 | 3177634 | 2020-03-06 | Slovakia | 1 | 0 | 0 | 48.669 | 19.699 | 2020-03-06T13:03:14 | |||||
3177635 | 3177635 | 2020-03-06 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
3177637 | 3177637 | 2020-03-06 | Togo | 1 | 0 | 0 | 8.6195 | 0.8248 | 2020-03-06T15:33:03 | |||||
3177667 | 3177667 | 2020-03-06 | Vatican City | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-06T15:43:02 | |||||
3177674 | 3177674 | 2020-03-06 | Kiribati | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-03-06T14:23:04 | |||||
3177675 | 3177675 | 2020-03-06 | Palau | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-03-06T14:23:04 | |||||
3177677 | 3177677 | 2020-03-06 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-06T14:23:04 | |||||
3177695 | 3177695 | 2020-03-06 | Tonga | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-03-06T14:23:04 | |||||
3177696 | 3177696 | 2020-03-06 | Winter Olympics 2022 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-03-06T14:23:04 | |||||
3177697 | 3177697 | 2020-03-06 | Antarctica | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-06T14:23:04 | |||||
3177700 | 3177700 | 2020-03-06 | Korea, North | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-03-06T14:23:04 |
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]);