johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68 rows where recovered = 251 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1736333 | 1736333 | 2021-06-12 | China | Shanxi | 253 | 0 | 251 | 2 | 37.5777 | 112.2922 | 2021-06-13 04:22:44 | Shanxi, China | ||
1588213 | 1588213 | 2021-02-05 | Japan | Shimane | 274 | 0 | 251 | 23 | 35.07076 | 132.55406399999998 | 2021-02-06 05:23:55 | Shimane, Japan | ||
790420 | 790420 | 2021-02-04 | Japan | Shimane | 273 | 0 | 251 | 22 | 35.07076 | 132.55406399999998 | 2021-02-05 05:22:38 | Shimane, Japan | ||
1676738 | 1676738 | 2021-02-01 | Saint Vincent and the Grenadines | 901 | 2 | 251 | 648 | 12.9843 | -61.2872 | 2021-02-02 05:22:49 | Saint Vincent and the Grenadines | |||
1460026 | 1460026 | 2021-01-31 | Saint Vincent and the Grenadines | 901 | 2 | 251 | 648 | 12.9843 | -61.2872 | 2021-02-01 05:22:53 | Saint Vincent and the Grenadines | |||
2938906 | 2938906 | 2020-11-28 | Malaysia | Kelantan | 353 | 3 | 251 | 99 | 6.1254 | 102.2381 | 2020-11-29 05:25:55 | Kelantan, Malaysia | ||
3304022 | 3304022 | 2020-11-02 | China | Tianjin | 273 | 3 | 251 | 19 | 39.3054 | 117.323 | 2020-11-03 06:00:16 | Tianjin, China | ||
3409271 | 3409271 | 2020-11-01 | China | Tianjin | 271 | 3 | 251 | 17 | 39.3054 | 117.323 | 2020-11-02 05:25:04 | Tianjin, China | ||
2079760 | 2079760 | 2020-10-31 | China | Tianjin | 270 | 3 | 251 | 16 | 39.3054 | 117.323 | 2020-11-01 04:36:19 | Tianjin, China | ||
2243213 | 2243213 | 2020-10-30 | China | Tianjin | 270 | 3 | 251 | 16 | 39.3054 | 117.323 | 2020-10-31 04:24:44 | Tianjin, China | ||
3651603 | 3651603 | 2020-10-24 | Japan | Saga | 254 | 0 | 251 | 3 | 33.286977 | 130.115738 | 2020-10-25 04:24:36 | Saga, Japan | ||
1053858 | 1053858 | 2020-10-23 | Japan | Saga | 253 | 0 | 251 | 2 | 33.286977 | 130.115738 | 2020-10-24 04:24:46 | Saga, Japan | ||
2175166 | 2175166 | 2020-09-09 | Ukraine | Luhansk Oblast | 480 | 4 | 251 | 225 | 48.574 | 39.3078 | 2020-09-10 04:29:01 | Luhansk Oblast, Ukraine | ||
2510208 | 2510208 | 2020-08-27 | Japan | Miyazaki | 352 | 1 | 251 | 100 | 32.193203999999994 | 131.299374 | 2020-08-28 04:28:11 | Miyazaki, Japan | ||
1996668 | 1996668 | 2020-08-26 | Japan | Miyazaki | 351 | 1 | 251 | 99 | 32.193203999999994 | 131.299374 | 2020-08-27 04:28:15 | Miyazaki, Japan | ||
1479595 | 1479595 | 2020-08-21 | Japan | Tochigi | 288 | 1 | 251 | 36 | 36.689912 | 139.819213 | 2020-08-22 04:27:49 | Tochigi, Japan | ||
3177773 | 3177773 | 2020-08-18 | Cambodia | 273 | 0 | 251 | 22 | 11.55 | 104.9167 | 2020-08-19 04:27:00 | Cambodia | |||
753981 | 753981 | 2020-08-01 | Malaysia | Perak | 263 | 6 | 251 | 6 | 4.5921 | 101.0901 | 2020-08-02 04:34:47 | Perak, Malaysia | ||
3265146 | 3265146 | 2020-07-31 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-08-01 04:36:27 | Perak, Malaysia | ||
1928855 | 1928855 | 2020-07-30 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-31 04:35:18 | Perak, Malaysia | ||
2959023 | 2959023 | 2020-07-29 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-30 04:35:05 | Perak, Malaysia | ||
3185640 | 3185640 | 2020-07-28 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-29 04:35:11 | Perak, Malaysia | ||
177691 | 177691 | 2020-07-27 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-28 04:58:43 | Perak, Malaysia | ||
443004 | 443004 | 2020-07-26 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-27 04:35:02 | Perak, Malaysia | ||
442705 | 442705 | 2020-07-26 | Ukraine | Sevastopol* | 335 | 6 | 251 | 78 | 44.6054 | 33.522 | 2020-07-27 04:35:02 | Sevastopol*, Ukraine | ||
1503248 | 1503248 | 2020-07-25 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-26 04:35:00 | Perak, Malaysia | ||
2564218 | 2564218 | 2020-07-24 | Malaysia | Perak | 261 | 6 | 251 | 4 | 4.5921 | 101.0901 | 2020-07-25 04:47:39 | Perak, Malaysia | ||
62449 | 62449 | 2020-07-23 | Malaysia | Perak | 260 | 6 | 251 | 3 | 4.5921 | 101.0901 | 2020-07-24 05:30:40 | Perak, Malaysia | ||
845237 | 845237 | 2020-07-22 | Malaysia | Perak | 260 | 6 | 251 | 3 | 4.5921 | 101.0901 | 2020-07-23 05:15:04 | Perak, Malaysia | ||
1707976 | 1707976 | 2020-07-21 | Malaysia | Perak | 259 | 6 | 251 | 2 | 4.5921 | 101.0901 | 2020-07-22 04:34:42 | Perak, Malaysia | ||
327555 | 327555 | 2020-07-20 | Malaysia | Perak | 259 | 6 | 251 | 2 | 4.5921 | 101.0901 | 2020-07-21 04:38:46 | Perak, Malaysia | ||
122372 | 122372 | 2020-07-19 | Malaysia | Perak | 259 | 6 | 251 | 2 | 4.5921 | 101.0901 | 2020-07-20 05:34:40 | Perak, Malaysia | ||
3205760 | 3205760 | 2020-07-18 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-19 04:34:58 | Perak, Malaysia | ||
2709062 | 2709062 | 2020-07-17 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-18 04:34:45 | Perak, Malaysia | ||
367868 | 367868 | 2020-07-16 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-17 04:34:50 | Perak, Malaysia | ||
2748536 | 2748536 | 2020-07-15 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-16 04:44:59 | Perak, Malaysia | ||
2159180 | 2159180 | 2020-07-14 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-15 04:34:39 | Perak, Malaysia | ||
3491822 | 3491822 | 2020-07-13 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-14 04:34:46 | Perak, Malaysia | ||
3738083 | 3738083 | 2020-07-12 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-13 04:43:04 | Perak, Malaysia | ||
3436478 | 3436478 | 2020-07-11 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-12 04:34:30 | Perak, Malaysia | ||
3237976 | 3237976 | 2020-07-10 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-11 04:34:26 | Perak, Malaysia | ||
1005961 | 1005961 | 2020-07-09 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-10 04:34:24 | Perak, Malaysia | ||
2223176 | 2223176 | 2020-07-08 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-09 04:34:23 | Perak, Malaysia | ||
887785 | 887785 | 2020-07-07 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-08 05:33:48 | Perak, Malaysia | ||
2685345 | 2685345 | 2020-07-06 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-07 04:34:00 | Perak, Malaysia | ||
415809 | 415809 | 2020-07-05 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-06 04:33:57 | Perak, Malaysia | ||
530371 | 530371 | 2020-07-04 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-05 04:33:46 | Perak, Malaysia | ||
529785 | 529785 | 2020-07-04 | Colombia | Cordoba | 915 | 70 | 251 | 594 | 8.0493 | -75.574 | 2020-07-05 04:33:46 | Cordoba, Colombia | ||
2235032 | 2235032 | 2020-07-03 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-04 04:33:51 | Perak, Malaysia | ||
3045826 | 3045826 | 2020-07-02 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-03 04:33:54 | Perak, Malaysia | ||
303517 | 303517 | 2020-07-01 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-02 04:33:46 | Perak, Malaysia | ||
2974895 | 2974895 | 2020-06-30 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-07-01 04:33:52 | Perak, Malaysia | ||
2633372 | 2633372 | 2020-06-29 | Malaysia | Perak | 257 | 6 | 251 | 0 | 4.5921 | 101.0901 | 2020-06-30 04:33:48 | Perak, Malaysia | ||
2306425 | 2306425 | 2020-06-28 | Japan | Ishikawa | 300 | 27 | 251 | 22 | 36.769464 | 136.771027 | 2020-06-29 04:33:44 | Ishikawa, Japan | ||
2039760 | 2039760 | 2020-06-27 | Japan | Ishikawa | 300 | 27 | 251 | 22 | 36.769464 | 136.771027 | 2020-06-28 04:34:04 | Ishikawa, Japan | ||
1510463 | 1510463 | 2020-06-22 | Colombia | Choco | 1010 | 32 | 251 | 727 | 5.2528 | -76.82600000000002 | 2020-06-23 04:33:22 | Choco, Colombia | ||
3249476 | 3249476 | 2020-06-21 | Colombia | Risaralda | 421 | 11 | 251 | 159 | 5.3158 | -75.9928 | 2020-06-22 04:33:20 | Risaralda, Colombia | ||
217596 | 217596 | 2020-06-08 | Togo | 497 | 13 | 251 | 233 | 8.6195 | 0.8248 | 2020-06-09 03:33:03 | Togo | |||
1432112 | 1432112 | 2020-05-20 | Lebanon | 961 | 26 | 251 | 684 | 33.8547 | 35.8623 | 2020-05-21 02:32:48 | Lebanon | |||
2390331 | 2390331 | 2020-05-19 | Lebanon | 954 | 26 | 251 | 677 | 33.8547 | 35.8623 | 2020-05-20 02:32:19 | Lebanon | |||
3261069 | 3261069 | 2020-05-18 | Lebanon | 931 | 26 | 251 | 654 | 33.8547 | 35.8623 | 2020-05-19 02:32:18 | Lebanon | |||
3331083 | 3331083 | 2020-05-11 | Kenya | 700 | 33 | 251 | 416 | -0.0236 | 37.9062 | 2020-05-12 03:32:27 | Kenya | |||
2473557 | 2473557 | 2020-04-20 | Slovakia | 1173 | 13 | 251 | 909 | 48.669 | 19.699 | 2020-04-20 23:36:27 | Slovakia | |||
934236 | 934236 | 2020-04-16 | China | Shaanxi | 256 | 3 | 251 | 2 | 35.1917 | 108.8701 | 2020-04-15 01:20:59 | Shaanxi, China | ||
860150 | 860150 | 2020-04-15 | Albania | 494 | 25 | 251 | 218 | 41.1533 | 20.1683 | 2020-04-15 22:56:32 | Albania | |||
860144 | 860144 | 2020-04-15 | Australia | Western Australia | 527 | 6 | 251 | 270 | -31.9505 | 115.8605 | 2020-04-15 23:04:26 | Western Australia, Australia | ||
860130 | 860130 | 2020-04-15 | China | Shaanxi | 256 | 3 | 251 | 2 | 35.1917 | 108.8701 | 2020-04-15 01:20:59 | Shaanxi, China | ||
3338060 | 3338060 | 2020-04-14 | Australia | Western Australia | 527 | 6 | 251 | 270 | -31.9505 | 115.8605 | 2020-04-14 23:41:11 | Western Australia, Australia |
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]);