johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where recovered = 523 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3970587 | 3970587 | 2021-06-11 | Japan | Shimane | 548 | 0 | 523 | 25 | 35.07076 | 132.55406399999998 | 2021-06-12 04:22:22 | Shimane, Japan | ||
1290011 | 1290011 | 2021-03-29 | Japan | Fukui | 573 | 25 | 523 | 25 | 35.846614 | 136.22465400000002 | 2021-03-30 04:26:23 | Fukui, Japan | ||
2055929 | 2055929 | 2021-03-15 | Japan | Yamagata | 557 | 15 | 523 | 19 | 38.448396 | 140.102154 | 2021-03-16 05:25:13 | Yamagata, Japan | ||
1732541 | 1732541 | 2021-03-14 | Japan | Yamagata | 554 | 15 | 523 | 16 | 38.448396 | 140.102154 | 2021-03-15 05:25:51 | Yamagata, Japan | ||
3663623 | 3663623 | 2021-03-09 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-10 05:24:35 | Iwate, Japan | ||
2359482 | 2359482 | 2021-03-08 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-09 05:28:19 | Iwate, Japan | ||
54820 | 54820 | 2021-03-07 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-08 05:24:48 | Iwate, Japan | ||
3667637 | 3667637 | 2021-03-06 | Japan | Iwate | 555 | 30 | 523 | 2 | 39.593287 | 141.361777 | 2021-03-07 05:21:54 | Iwate, Japan | ||
1896956 | 1896956 | 2021-01-29 | China | Fujian | 539 | 1 | 523 | 15 | 26.0789 | 117.9874 | 2021-01-30 05:22:49 | Fujian, China | ||
2482236 | 2482236 | 2021-01-28 | Saint Lucia | 1029 | 13 | 523 | 493 | 13.9094 | -60.9789 | 2021-01-29 05:22:23 | Saint Lucia | |||
2481772 | 2481772 | 2021-01-28 | China | Fujian | 536 | 1 | 523 | 12 | 26.0789 | 117.9874 | 2021-01-29 05:22:23 | Fujian, China | ||
908370 | 908370 | 2021-01-19 | Russia | Chukotka Autonomous Okrug | 586 | 4 | 523 | 59 | 66.0006475 | 169.4900869 | 2021-01-20 05:21:54 | Chukotka Autonomous Okrug, Russia | ||
154031 | 154031 | 2021-01-08 | Japan | Yamanashi | 712 | 11 | 523 | 178 | 35.612364 | 138.61148899999998 | 2021-01-09 05:22:18 | Yamanashi, Japan | ||
2541455 | 2541455 | 2021-01-07 | Japan | Yamanashi | 676 | 11 | 523 | 142 | 35.612364 | 138.61148899999998 | 2021-01-08 05:22:42 | Yamanashi, Japan | ||
2119759 | 2119759 | 2020-12-20 | Japan | Wakayama | 578 | 7 | 523 | 48 | 33.911879 | 135.505446 | 2020-12-21 05:27:58 | Wakayama, Japan | ||
1350426 | 1350426 | 2020-11-24 | Monaco | 587 | 3 | 523 | 61 | 43.7333 | 7.4167 | 2020-11-25 05:27:20 | Monaco | |||
1544271 | 1544271 | 2020-11-07 | Taiwan* | 573 | 7 | 523 | 43 | 23.7 | 121.0 | 2020-11-08 05:24:56 | Taiwan* | |||
376509 | 376509 | 2020-11-06 | Taiwan* | 573 | 7 | 523 | 43 | 23.7 | 121.0 | 2020-11-07 05:24:52 | Taiwan* | |||
892447 | 892447 | 2020-11-05 | Taiwan* | 569 | 7 | 523 | 39 | 23.7 | 121.0 | 2020-11-06 05:24:55 | Taiwan* | |||
3409479 | 3409479 | 2020-11-01 | Japan | Shiga | 553 | 9 | 523 | 21 | 35.21582700000001 | 136.138064 | 2020-11-02 05:25:04 | Shiga, Japan | ||
754325 | 754325 | 2020-10-28 | Japan | Miyagi | 679 | 2 | 523 | 154 | 38.446859 | 140.927086 | 2020-10-29 04:24:49 | Miyagi, Japan | ||
12008 | 12008 | 2020-10-25 | Malaysia | Pulau Pinang | 850 | 3 | 523 | 324 | 5.4141 | 100.3288 | 2020-10-26 04:25:02 | Pulau Pinang, Malaysia | ||
2689670 | 2689670 | 2020-10-08 | Italy | Molise | 690 | 25 | 523 | 142 | 41.55774754 | 14.65916051 | 2020-10-09 04:23:59 | Molise, Italy | ||
2848867 | 2848867 | 2020-09-18 | Japan | Nara | 544 | 9 | 523 | 12 | 34.317451 | 135.871644 | 2020-09-19 04:22:00 | Nara, Japan | ||
1121609 | 1121609 | 2020-09-17 | Japan | Kumamoto | 570 | 8 | 523 | 39 | 32.608154 | 130.745231 | 2020-09-18 05:05:00 | Kumamoto, Japan | ||
666298 | 666298 | 2020-09-16 | Japan | Kumamoto | 570 | 8 | 523 | 39 | 32.608154 | 130.745231 | 2020-09-17 04:22:00 | Kumamoto, Japan | ||
1173196 | 1173196 | 2020-09-10 | Japan | Ibaraki | 593 | 14 | 523 | 56 | 36.303588 | 140.319591 | 2020-09-11 04:46:23 | Ibaraki, Japan | ||
3562498 | 3562498 | 2020-08-25 | Guyana | 1060 | 31 | 523 | 506 | 4.860416000000002 | -58.93018000000001 | 2020-08-26 04:28:11 | Guyana | |||
2958318 | 2958318 | 2020-07-29 | Japan | Aichi | 1469 | 35 | 523 | 911 | 35.035551 | 137.211621 | 2020-07-30 04:35:05 | Aichi, Japan | ||
845157 | 845157 | 2020-07-22 | Mozambique | 1557 | 11 | 523 | 1023 | -18.665695 | 35.529562 | 2020-07-23 05:15:04 | Mozambique | |||
530315 | 530315 | 2020-07-04 | Rwanda | 1092 | 3 | 523 | 566 | -1.9403 | 29.8739 | 2020-07-05 04:33:46 | Rwanda | |||
2700707 | 2700707 | 2020-06-24 | Ukraine | Kirovohrad Oblast | 634 | 31 | 523 | 80 | 48.5079 | 32.2623 | 2020-06-25 05:26:54 | Kirovohrad Oblast, Ukraine | ||
2712103 | 2712103 | 2020-05-28 | Mexico | Aguascalientes | 769 | 33 | 523 | 213 | 21.8853 | -102.2916 | 2020-05-29 02:32:50 | Aguascalientes, Mexico | ||
3331170 | 3331170 | 2020-05-11 | Uruguay | 711 | 19 | 523 | 169 | -32.5228 | -55.7658 | 2020-05-12 03:32:27 | Uruguay | |||
2278622 | 2278622 | 2020-05-03 | Australia | Western Australia | 551 | 9 | 523 | 19 | -31.9505 | 115.8605 | 2020-05-04 02:32:28 | Western Australia, Australia | ||
418796 | 418796 | 2020-04-18 | Armenia | 1248 | 20 | 523 | 705 | 40.0691 | 45.0382 | 2020-04-18 22:32:28 | Armenia | |||
3177478 | 3177478 | 2020-03-06 | Italy | 4636 | 197 | 523 | 43.0 | 12.0 | 2020-03-06T17:33:03 | |||||
3205793 | 3205793 | 2020-02-29 | Mainland China | Jiangsu | 631 | 0 | 523 | 32.9711 | 119.455 | 2020-02-29T07:23:11 |
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]);