johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where recovered = 1078 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1872975 | 1872975 | 2021-05-15 | Japan | Kochi | 1148 | 20 | 1078 | 50 | 33.422519 | 133.367307 | 2021-05-16 04:20:49 | Kochi, Japan | ||
1587945 | 1587945 | 2021-02-05 | Canada | New Brunswick | 1325 | 18 | 1078 | 229 | 46.5653 | -66.4619 | 2021-02-06 05:23:55 | New Brunswick, Canada | ||
2466914 | 2466914 | 2021-01-22 | Monaco | 1311 | 9 | 1078 | 224 | 43.7333 | 7.4167 | 2021-01-23 05:22:03 | Monaco | |||
3519078 | 3519078 | 2021-01-15 | Malaysia | Kelantan | 1728 | 9 | 1078 | 641 | 6.1254 | 102.2381 | 2021-01-16 05:22:40 | Kelantan, Malaysia | ||
2975255 | 2975255 | 2020-12-09 | Japan | Nara | 1354 | 13 | 1078 | 263 | 34.317451 | 135.871644 | 2020-12-10 05:26:19 | Nara, Japan | ||
3566340 | 3566340 | 2020-11-29 | Canada | Nova Scotia | 1290 | 65 | 1078 | 114 | 44.682 | -63.7443 | 2020-11-30 05:26:13 | Nova Scotia, Canada | ||
2935005 | 2935005 | 2020-11-28 | Canada | Nova Scotia | 1280 | 65 | 1078 | 114 | 44.682 | -63.7443 | 2020-11-29 05:25:55 | Nova Scotia, Canada | ||
392008 | 392008 | 2020-11-27 | Canada | Nova Scotia | 1266 | 65 | 1078 | 114 | 44.682 | -63.7443 | 2020-11-28 05:25:50 | Nova Scotia, Canada | ||
923799 | 923799 | 2020-11-26 | Netherlands | Curacao | 2046 | 3 | 1078 | 965 | 12.1696 | -68.99 | 2020-11-27 05:26:53 | Curacao, Netherlands | ||
923455 | 923455 | 2020-11-26 | Canada | Nova Scotia | 1257 | 65 | 1078 | 114 | 44.682 | -63.7443 | 2020-11-27 05:26:53 | Nova Scotia, Canada | ||
2729000 | 2729000 | 2020-09-15 | Italy | Valle d'Aosta | 1266 | 146 | 1078 | 42 | 45.73750286 | 7.320149366 | 2020-09-16 04:22:53 | Valle d'Aosta, Italy | ||
344272 | 344272 | 2020-09-14 | Italy | Valle d'Aosta | 1263 | 146 | 1078 | 39 | 45.73750286 | 7.320149366 | 2020-09-15 03:22:50 | Valle d'Aosta, Italy | ||
2868711 | 2868711 | 2020-09-13 | Italy | Valle d'Aosta | 1260 | 146 | 1078 | 36 | 45.73750286 | 7.320149366 | 2020-09-14 04:26:00 | Valle d'Aosta, Italy | ||
546750 | 546750 | 2020-09-12 | Italy | Valle d'Aosta | 1258 | 146 | 1078 | 34 | 45.73750286 | 7.320149366 | 2020-09-13 04:30:52 | Valle d'Aosta, Italy | ||
1444579 | 1444579 | 2020-09-11 | Italy | Valle d'Aosta | 1257 | 146 | 1078 | 33 | 45.73750286 | 7.320149366 | 2020-09-12 04:25:05 | Valle d'Aosta, Italy | ||
837744 | 837744 | 2020-08-17 | Niger | 1167 | 69 | 1078 | 20 | 17.607789 | 8.081666 | 2020-08-18 04:27:56 | Niger | |||
837669 | 837669 | 2020-08-17 | Latvia | 1323 | 32 | 1078 | 213 | 56.8796 | 24.6032 | 2020-08-18 04:27:56 | Latvia | |||
1556102 | 1556102 | 2020-08-16 | Niger | 1167 | 69 | 1078 | 20 | 17.607789 | 8.081666 | 2020-08-17 04:27:20 | Niger | |||
1556027 | 1556027 | 2020-08-16 | Latvia | 1322 | 32 | 1078 | 212 | 56.8796 | 24.6032 | 2020-08-17 04:27:20 | Latvia | |||
146029 | 146029 | 2020-08-15 | Latvia | 1315 | 32 | 1078 | 205 | 56.8796 | 24.6032 | 2020-08-16 04:27:42 | Latvia | |||
1612304 | 1612304 | 2020-08-14 | Latvia | 1308 | 32 | 1078 | 198 | 56.8796 | 24.6032 | 2020-08-15 04:27:31 | Latvia | |||
582888 | 582888 | 2020-08-13 | Latvia | 1307 | 32 | 1078 | 197 | 56.8796 | 24.6032 | 2020-08-14 04:51:19 | Latvia | |||
3531507 | 3531507 | 2020-08-12 | Latvia | 1303 | 32 | 1078 | 193 | 56.8796 | 24.6032 | 2020-08-13 04:29:15 | Latvia | |||
662356 | 662356 | 2020-08-11 | Latvia | 1293 | 32 | 1078 | 183 | 56.8796 | 24.6032 | 2020-08-12 04:27:29 | Latvia | |||
1005777 | 1005777 | 2020-07-09 | Ukraine | Zhytomyr Oblast | 1500 | 32 | 1078 | 390 | 50.2547 | 28.6587 | 2020-07-10 04:34:24 | Zhytomyr Oblast, Ukraine | ||
530284 | 530284 | 2020-07-04 | Madagascar | 2728 | 29 | 1078 | 1621 | -18.766947000000002 | 46.869107 | 2020-07-05 04:33:46 | Madagascar | |||
2700975 | 2700975 | 2020-06-24 | Russia | Vologda Oblast | 1487 | 17 | 1078 | 392 | 60.0391461 | 43.1215213 | 2020-06-25 05:26:54 | Vologda Oblast, Russia | ||
1510535 | 1510535 | 2020-06-22 | China | Hong Kong | 1161 | 5 | 1078 | 78 | 22.3 | 114.2 | 2020-06-23 04:33:22 | Hong Kong, China | ||
3249274 | 3249274 | 2020-06-21 | China | Hong Kong | 1131 | 5 | 1078 | 48 | 22.3 | 114.2 | 2020-06-22 04:33:20 | Hong Kong, China | ||
286956 | 286956 | 2020-06-15 | Mexico | Aguascalientes | 1467 | 71 | 1078 | 318 | 21.8853 | -102.2916 | 2020-06-16 04:33:09 | Aguascalientes, Mexico | ||
805445 | 805445 | 2020-06-01 | Russia | Primorsky Krai | 2049 | 19 | 1078 | 952 | 45.0819456 | 134.726645 | 2020-06-02 02:33:08 | Primorsky Krai, Russia | ||
114242 | 114242 | 2020-05-08 | Cuba | 1741 | 74 | 1078 | 589 | 21.521757 | -77.78116700000002 | 2020-05-09 02:32:35 | Cuba |
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]);