johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where recovered = 604 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 17
- Japan 6
- China 5
- Australia 3
- Malaysia 2
- Andorra 1
- Burkina Faso 1
- Colombia 1
- Kazakhstan 1
- Libya 1
- Mainland China 1
- Mali 1
- Mexico 1
- Paraguay 1
- Sao Tome and Principe 1
- Sri Lanka 1
- Ukraine 1
- Zimbabwe 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3141231 | 3141231 | 2021-07-23 | Malaysia | Perlis | 641 | 8 | 604 | 29 | 6.4449 | 100.2048 | 2021-07-24 00:21:36 | Perlis, Malaysia | ||
2884189 | 2884189 | 2021-06-20 | China | Shaanxi | 624 | 3 | 604 | 17 | 35.1917 | 108.8701 | 2021-06-21 04:21:41 | Shaanxi, China | ||
107272 | 107272 | 2021-06-19 | China | Shaanxi | 624 | 3 | 604 | 17 | 35.1917 | 108.8701 | 2021-06-20 04:21:48 | Shaanxi, China | ||
1125415 | 1125415 | 2021-06-18 | China | Shaanxi | 624 | 3 | 604 | 17 | 35.1917 | 108.8701 | 2021-06-19 04:22:33 | Shaanxi, China | ||
2910993 | 2910993 | 2021-06-17 | China | Shaanxi | 622 | 3 | 604 | 15 | 35.1917 | 108.8701 | 2021-06-18 04:22:16 | Shaanxi, China | ||
530405 | 530405 | 2021-02-22 | Australia | South Australia | 612 | 4 | 604 | 4 | -34.9285 | 138.6007 | 2021-02-23 05:23:41 | South Australia, Australia | ||
2864745 | 2864745 | 2021-01-06 | Japan | Oita | 772 | 6 | 604 | 162 | 33.200697 | 131.43323999999998 | 2021-01-07 05:22:03 | Oita, Japan | ||
2864735 | 2864735 | 2021-01-06 | Japan | Kochi | 700 | 10 | 604 | 86 | 33.422519 | 133.367307 | 2021-01-07 05:22:03 | Kochi, Japan | ||
392257 | 392257 | 2020-11-27 | Japan | Mie | 797 | 7 | 604 | 186 | 34.508018 | 136.376013 | 2020-11-28 05:25:50 | Mie, Japan | ||
210267 | 210267 | 2020-10-29 | Japan | Nara | 627 | 9 | 604 | 14 | 34.317451 | 135.871644 | 2020-10-30 04:24:49 | Nara, Japan | ||
2689690 | 2689690 | 2020-10-08 | Japan | Gifu | 631 | 10 | 604 | 17 | 35.778671 | 137.055925 | 2020-10-09 04:23:59 | Gifu, Japan | ||
1041832 | 1041832 | 2020-10-07 | Japan | Gifu | 631 | 10 | 604 | 17 | 35.778671 | 137.055925 | 2020-10-08 04:23:56 | Gifu, Japan | ||
3531307 | 3531307 | 2020-08-12 | Colombia | Putumayo | 1638 | 75 | 604 | 959 | 0.436 | -75.5277 | 2020-08-13 04:29:15 | Putumayo, Colombia | ||
98783 | 98783 | 2020-08-04 | Malaysia | Sarawak | 678 | 19 | 604 | 55 | 1.5533 | 110.3592 | 2020-08-05 04:34:43 | Sarawak, Malaysia | ||
1928758 | 1928758 | 2020-07-30 | Libya | 3438 | 73 | 604 | 2761 | 26.3351 | 17.228331 | 2020-07-31 04:35:18 | Libya | |||
3185619 | 3185619 | 2020-07-28 | Zimbabwe | 2817 | 40 | 604 | 2173 | -19.015438 | 29.154857 | 2020-07-29 04:35:11 | Zimbabwe | |||
62361 | 62361 | 2020-07-23 | Sao Tome and Principe | 749 | 14 | 604 | 131 | 0.18636 | 6.613081 | 2020-07-24 05:30:40 | Sao Tome and Principe | |||
3436279 | 3436279 | 2020-07-11 | Australia | Western Australia | 635 | 9 | 604 | 22 | -31.9505 | 115.8605 | 2020-07-12 04:34:30 | Western Australia, Australia | ||
3237777 | 3237777 | 2020-07-10 | Australia | Western Australia | 634 | 9 | 604 | 21 | -31.9505 | 115.8605 | 2020-07-11 04:34:26 | Western Australia, Australia | ||
3061204 | 3061204 | 2020-06-13 | Ukraine | Lviv Oblast | 2658 | 92 | 604 | 1962 | 49.8397 | 24.0297 | 2020-06-14 03:33:15 | Lviv Oblast, Ukraine | ||
1211135 | 1211135 | 2020-06-09 | Paraguay | 1187 | 11 | 604 | 572 | -23.4425 | -58.4438 | 2020-06-10 04:07:00 | Paraguay | |||
2799814 | 2799814 | 2020-06-07 | Mexico | Baja California Sur | 765 | 43 | 604 | 118 | 26.0444 | -111.6661 | 2020-06-08 03:33:22 | Baja California Sur, Mexico | ||
1105140 | 1105140 | 2020-05-25 | Mali | 1059 | 67 | 604 | 388 | 17.570692 | -3.996166000000001 | 2020-05-26 02:32:35 | Mali | |||
268589 | 268589 | 2020-05-21 | Sri Lanka | 1055 | 9 | 604 | 442 | 7.873054 | 80.77179699999998 | 2020-05-22 02:36:51 | Sri Lanka | |||
1829630 | 1829630 | 2020-05-16 | Burkina Faso | 782 | 51 | 604 | 127 | 12.2383 | -1.5616 | 2020-05-17 02:32:32 | Burkina Faso | |||
3276324 | 3276324 | 2020-05-15 | Andorra | 761 | 49 | 604 | 108 | 42.5063 | 1.5218 | 2020-05-16 02:32:19 | Andorra | |||
2043245 | 2043245 | 2020-05-02 | China | Heilongjiang | 944 | 13 | 604 | 327 | 47.861999999999995 | 127.7615 | 2020-05-03 02:32:28 | Heilongjiang, China | ||
1459307 | 1459307 | 2020-04-24 | Kazakhstan | 2482 | 25 | 604 | 1853 | 48.0196 | 66.9237 | 2020-04-25 06:30:33 | Kazakhstan | |||
1720045 | 1720045 | 2020-02-19 | Mainland China | Zhejiang | 1174 | 0 | 604 | 29.1832 | 120.0934 | 2020-02-19T11:33:02 |
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]);