johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
326 rows where "last_update" is on date 2020-03-08 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
657808 | 657808 | 2020-03-09 | Afghanistan | 8 | 0 | 0 | 33.0 | 65.0 | 2020-03-08T04:53:03 | |||||
1527321 | 1527321 | 2020-03-08 | Afghanistan | 8 | 0 | 0 | 33.0 | 65.0 | 2020-03-08T04:53:03 | |||||
1527275 | 1527275 | 2020-03-08 | Algeria | 19 | 0 | 0 | 28.0339 | 1.6596 | 2020-03-08T05:23:03 | |||||
1527477 | 1527477 | 2020-03-08 | Antarctica | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-08T14:43:03 | |||||
657777 | 657777 | 2020-03-09 | Argentina | 12 | 1 | 0 | -38.4161 | -63.6167 | 2020-03-08T22:03:11 | |||||
1527287 | 1527287 | 2020-03-08 | Argentina | 12 | 1 | 0 | -38.4161 | -63.6167 | 2020-03-08T22:03:11 | |||||
657770 | 657770 | 2020-03-09 | Australia | Queensland | 15 | 0 | 8 | -28.0167 | 153.4 | 2020-03-08T05:43:04 | ||||
657838 | 657838 | 2020-03-09 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
1527259 | 1527259 | 2020-03-08 | Australia | New South Wales | 38 | 3 | 4 | -33.8688 | 151.2093 | 2020-03-08T05:13:07 | ||||
1527281 | 1527281 | 2020-03-08 | Australia | Queensland | 15 | 0 | 8 | -28.0167 | 153.4 | 2020-03-08T05:43:04 | ||||
1527347 | 1527347 | 2020-03-08 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
3752968 | 3752968 | 2020-03-10 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
1527240 | 1527240 | 2020-03-08 | Austria | 75 | 0 | 0 | 47.5162 | 14.5501 | 2020-03-08T09:13:14 | |||||
657820 | 657820 | 2020-03-09 | Bangladesh | 3 | 0 | 0 | 23.685 | 90.3563 | 2020-03-08T10:53:02 | |||||
1527332 | 1527332 | 2020-03-08 | Bangladesh | 3 | 0 | 0 | 23.685 | 90.3563 | 2020-03-08T10:53:02 | |||||
1527229 | 1527229 | 2020-03-08 | Belgium | 200 | 0 | 1 | 50.8333 | 4.0 | 2020-03-08T17:23:07 | |||||
1527274 | 1527274 | 2020-03-08 | Brazil | 20 | 0 | 0 | -14.235 | -51.9253 | 2020-03-08T17:23:07 | |||||
1527322 | 1527322 | 2020-03-08 | Bulgaria | 4 | 0 | 0 | 42.7339 | 25.4858 | 2020-03-08T11:13:17 | |||||
657839 | 657839 | 2020-03-09 | Cambodia | 2 | 0 | 1 | 11.55 | 104.9167 | 2020-03-08T04:53:03 | |||||
1527348 | 1527348 | 2020-03-08 | Cambodia | 2 | 0 | 1 | 11.55 | 104.9167 | 2020-03-08T04:53:03 | |||||
3752969 | 3752969 | 2020-03-10 | Cambodia | 2 | 0 | 1 | 11.55 | 104.9167 | 2020-03-08T04:53:03 | |||||
657840 | 657840 | 2020-03-09 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-08T05:23:03 | |||||
1527349 | 1527349 | 2020-03-08 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-08T05:23:03 | |||||
2127597 | 2127597 | 2020-03-11 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-08T05:23:03 | |||||
2283030 | 2283030 | 2020-03-12 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-08T05:23:03 | |||||
3752970 | 3752970 | 2020-03-10 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-08T05:23:03 | |||||
1527268 | 1527268 | 2020-03-08 | Canada | Toronto, ON | 28 | 0 | 3 | 43.6532 | -79.3832 | 2020-03-08T21:33:02 | ||||
1527269 | 1527269 | 2020-03-08 | Canada | British Columbia | 27 | 0 | 4 | 49.2827 | -123.1207 | 2020-03-08T05:13:07 | ||||
1527323 | 1527323 | 2020-03-08 | Canada | Montreal, QC | 14 | 0 | 0 | 45.5017 | -73.5673 | 2020-03-08T16:03:05 | ||||
1527334 | 1527334 | 2020-03-08 | Canada | Edmonton, Alberta | 3 | 0 | 0 | 53.5461 | -113.4938 | 2020-03-08T16:23:07 | ||||
657786 | 657786 | 2020-03-09 | Chile | 8 | 0 | 0 | -35.6751 | -71.543 | 2020-03-08T15:43:03 | |||||
1527299 | 1527299 | 2020-03-08 | Chile | 8 | 0 | 0 | -35.6751 | -71.543 | 2020-03-08T15:43:03 | |||||
43158 | 43158 | 2020-04-13 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
50257 | 50257 | 2020-04-17 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
418785 | 418785 | 2020-04-18 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
522323 | 522323 | 2020-04-21 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
589010 | 589010 | 2020-04-05 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
589095 | 589095 | 2020-04-05 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
808970 | 808970 | 2020-03-27 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
809050 | 809050 | 2020-03-27 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
860145 | 860145 | 2020-04-15 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
919063 | 919063 | 2020-03-26 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
919143 | 919143 | 2020-03-26 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
934251 | 934251 | 2020-04-16 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1132466 | 1132466 | 2020-03-25 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
1132545 | 1132545 | 2020-03-25 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1199257 | 1199257 | 2020-04-22 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1250206 | 1250206 | 2020-04-10 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1385097 | 1385097 | 2020-04-19 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1459218 | 1459218 | 2020-04-24 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1478974 | 1478974 | 2020-03-24 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
1479053 | 1479053 | 2020-03-24 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1527453 | 1527453 | 2020-03-08 | China | Unknown | 0 | 0 | 0 | 2020-03-08T14:43:03 | ||||||
2147032 | 2147032 | 2020-03-23 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
2147110 | 2147110 | 2020-03-23 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
2473405 | 2473405 | 2020-04-20 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
2524807 | 2524807 | 2020-04-23 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
2567021 | 2567021 | 2020-04-11 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
2578184 | 2578184 | 2020-04-12 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:00 | Xinjiang, China | ||
3021640 | 3021640 | 2020-04-07 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
3021725 | 3021725 | 2020-04-07 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3338061 | 3338061 | 2020-04-14 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3364701 | 3364701 | 2020-04-01 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
3364783 | 3364783 | 2020-04-01 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3502817 | 3502817 | 2020-04-25 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3561965 | 3561965 | 2020-04-08 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
3562050 | 3562050 | 2020-04-08 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3589290 | 3589290 | 2020-04-27 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3592468 | 3592468 | 2020-04-26 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3740466 | 3740466 | 2020-04-03 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
3740549 | 3740549 | 2020-04-03 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3815794 | 3815794 | 2020-03-31 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
3815876 | 3815876 | 2020-03-31 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3949943 | 3949943 | 2020-04-09 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
1527313 | 1527313 | 2020-03-08 | Costa Rica | 5 | 0 | 0 | 9.7489 | -83.7534 | 2020-03-08T05:13:07 | |||||
657750 | 657750 | 2020-03-09 | Czech Republic | 31 | 0 | 0 | 49.8175 | 15.473 | 2020-03-08T19:53:03 | |||||
1527264 | 1527264 | 2020-03-08 | Czech Republic | 31 | 0 | 0 | 49.8175 | 15.473 | 2020-03-08T19:53:03 | |||||
1527262 | 1527262 | 2020-03-08 | Denmark | 35 | 0 | 1 | 56.2639 | 9.5018 | 2020-03-08T14:53:11 | |||||
657802 | 657802 | 2020-03-09 | Dominican Republic | 5 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-08T17:23:08 | |||||
1527314 | 1527314 | 2020-03-08 | Dominican Republic | 5 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-08T17:23:08 | |||||
2127575 | 2127575 | 2020-03-11 | Dominican Republic | 5 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-08T17:23:08 | |||||
2283010 | 2283010 | 2020-03-12 | Dominican Republic | 5 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-08T17:23:08 | |||||
3752945 | 3752945 | 2020-03-10 | Dominican Republic | 5 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-08T17:23:08 | |||||
1527284 | 1527284 | 2020-03-08 | Ecuador | 14 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-08T05:23:03 | |||||
1527253 | 1527253 | 2020-03-08 | Egypt | 49 | 1 | 1 | 26.0 | 30.0 | 2020-03-08T19:03:11 | |||||
657842 | 657842 | 2020-03-09 | Faroe Islands | 2 | 0 | 0 | 61.8926 | -6.9118 | 2020-03-08T05:13:07 | |||||
1527350 | 1527350 | 2020-03-08 | Faroe Islands | 2 | 0 | 0 | 61.8926 | -6.9118 | 2020-03-08T05:13:07 | |||||
3752971 | 3752971 | 2020-03-10 | Faroe Islands | 2 | 0 | 0 | 61.8926 | -6.9118 | 2020-03-08T05:13:07 | |||||
1527270 | 1527270 | 2020-03-08 | Finland | 35 | 1 | 1 | 64.0 | 26.0 | 2020-03-08T10:03:13 | |||||
1527206 | 1527206 | 2020-03-08 | France | 1115 | 19 | 12 | 47.0 | 2.0 | 2020-03-08T18:03:04 | |||||
1527286 | 1527286 | 2020-03-08 | Georgia | 13 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-08T05:23:03 | |||||
1527207 | 1527207 | 2020-03-08 | Germany | 1040 | 0 | 18 | 51.0 | 9.0 | 2020-03-08T21:03:03 | |||||
657733 | 657733 | 2020-03-09 | Greece | 73 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-08T17:23:07 | |||||
1527248 | 1527248 | 2020-03-08 | Greece | 73 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-08T17:23:07 | |||||
1527239 | 1527239 | 2020-03-08 | Hong Kong | Hong Kong | 114 | 3 | 58 | 22.3 | 114.2 | 2020-03-08T14:43:03 | ||||
1527303 | 1527303 | 2020-03-08 | Hungary | 7 | 0 | 0 | 47.1625 | 19.5033 | 2020-03-08T15:03:02 | |||||
1527257 | 1527257 | 2020-03-08 | India | 39 | 0 | 3 | 21.0 | 78.0 | 2020-03-08T09:23:05 | |||||
1527308 | 1527308 | 2020-03-08 | Indonesia | 6 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-08T10:03:13 | |||||
1527202 | 1527202 | 2020-03-08 | Iran | 6566 | 194 | 2134 | 32.0 | 53.0 | 2020-03-08T11:03:30 | |||||
1527250 | 1527250 | 2020-03-08 | Iraq | 60 | 6 | 0 | 33.0 | 44.0 | 2020-03-08T21:03:03 |
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]);