johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
36 rows where recovered = 949 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015225 | 3015225 | 2021-08-01 | Denmark | Faroe Islands | 985 | 2 | 949 | 34 | 61.8926 | -6.9118 | 2021-08-02 04:21:36 | Faroe Islands, Denmark | ||
887945 | 887945 | 2021-04-26 | China | Sichuan | 975 | 3 | 949 | 23 | 30.6171 | 102.7103 | 2021-04-27 04:20:52 | Sichuan, China | ||
954690 | 954690 | 2021-04-25 | China | Sichuan | 970 | 3 | 949 | 18 | 30.6171 | 102.7103 | 2021-04-26 04:21:04 | Sichuan, China | ||
169736 | 169736 | 2021-04-16 | Antigua and Barbuda | 1213 | 31 | 949 | 233 | 17.0608 | -61.7964 | 2021-04-17 04:20:40 | Antigua and Barbuda | |||
36478 | 36478 | 2021-04-12 | Japan | Yamanashi | 1029 | 19 | 949 | 61 | 35.612364 | 138.61148899999998 | 2021-04-13 04:20:37 | Yamanashi, Japan | ||
3883637 | 3883637 | 2021-04-11 | Japan | Yamanashi | 1028 | 19 | 949 | 60 | 35.612364 | 138.61148899999998 | 2021-04-12 04:21:00 | Yamanashi, Japan | ||
1579921 | 1579921 | 2021-03-13 | Canada | Newfoundland and Labrador | 1012 | 6 | 949 | 57 | 53.1355 | -57.6604 | 2021-03-14 05:25:37 | Newfoundland and Labrador, Canada | ||
3667889 | 3667889 | 2021-03-06 | Saint Vincent and the Grenadines | 1645 | 8 | 949 | 688 | 12.9843 | -61.2872 | 2021-03-07 05:21:54 | Saint Vincent and the Grenadines | |||
1616510 | 1616510 | 2021-03-05 | Saint Vincent and the Grenadines | 1645 | 8 | 949 | 688 | 12.9843 | -61.2872 | 2021-03-06 04:23:41 | Saint Vincent and the Grenadines | |||
2207921 | 2207921 | 2021-03-04 | Saint Vincent and the Grenadines | 1645 | 8 | 949 | 688 | 12.9843 | -61.2872 | 2021-03-05 05:26:29 | Saint Vincent and the Grenadines | |||
1090342 | 1090342 | 2021-03-03 | Saint Vincent and the Grenadines | 1645 | 8 | 949 | 688 | 12.9843 | -61.2872 | 2021-03-04 05:24:24 | Saint Vincent and the Grenadines | |||
3539463 | 3539463 | 2021-02-12 | Japan | Ehime | 1029 | 22 | 949 | 58 | 33.624835 | 132.856842 | 2021-02-13 05:22:12 | Ehime, Japan | ||
3308069 | 3308069 | 2021-01-13 | Comoros | 1169 | 33 | 949 | 187 | -11.6455 | 43.3333 | 2021-01-14 05:22:32 | Comoros | |||
189878 | 189878 | 2021-01-11 | China | Heilongjiang | 972 | 13 | 949 | 10 | 47.862 | 127.7615 | 2021-01-12 05:22:15 | Heilongjiang, China | ||
2625681 | 2625681 | 2021-01-10 | China | Heilongjiang | 971 | 13 | 949 | 9 | 47.862 | 127.7615 | 2021-01-11 05:21:50 | Heilongjiang, China | ||
3899769 | 3899769 | 2021-01-09 | China | Heilongjiang | 971 | 13 | 949 | 9 | 47.862 | 127.7615 | 2021-01-10 05:22:12 | Heilongjiang, China | ||
153792 | 153792 | 2021-01-08 | China | Heilongjiang | 971 | 13 | 949 | 9 | 47.862 | 127.7615 | 2021-01-09 05:22:18 | Heilongjiang, China | ||
2541216 | 2541216 | 2021-01-07 | China | Heilongjiang | 971 | 13 | 949 | 9 | 47.862 | 127.7615 | 2021-01-08 05:22:42 | Heilongjiang, China | ||
2864525 | 2864525 | 2021-01-06 | China | Heilongjiang | 970 | 13 | 949 | 8 | 47.862 | 127.7615 | 2021-01-07 05:22:03 | Heilongjiang, China | ||
3034112 | 3034112 | 2021-01-05 | China | Heilongjiang | 970 | 13 | 949 | 8 | 47.862 | 127.7615 | 2021-01-06 05:22:16 | Heilongjiang, China | ||
2227556 | 2227556 | 2021-01-02 | Japan | Shiga | 1222 | 12 | 949 | 261 | 35.21582700000001 | 136.138064 | 2021-01-03 05:22:52 | Shiga, Japan | ||
1632311 | 1632311 | 2020-12-05 | Japan | Gifu | 1227 | 14 | 949 | 264 | 35.778671 | 137.055925 | 2020-12-06 05:26:18 | Gifu, Japan | ||
3169616 | 3169616 | 2020-11-16 | Italy | Basilicata | 5106 | 85 | 949 | 4072 | 40.63947052 | 15.80514834 | 2020-11-17 05:25:54 | Basilicata, Italy | ||
2860463 | 2860463 | 2020-10-16 | Ukraine | Kherson Oblast | 2264 | 43 | 949 | 1272 | 46.6354 | 32.6169 | 2020-10-17 04:24:12 | Kherson Oblast, Ukraine | ||
821185 | 821185 | 2020-10-09 | Ukraine | Kirovohrad Oblast | 1262 | 63 | 949 | 250 | 48.5079 | 32.2623 | 2020-10-10 04:23:57 | Kirovohrad Oblast, Ukraine | ||
1121548 | 1121548 | 2020-09-17 | India | Mizoram | 1534 | 0 | 949 | 585 | 23.309381 | 92.83822 | 2020-09-18 05:05:00 | Mizoram, India | ||
193981 | 193981 | 2020-08-31 | Germany | Mecklenburg-Vorpommern | 1008 | 20 | 949 | 39 | 53.6127 | 12.4296 | 2020-09-01 04:28:31 | Mecklenburg-Vorpommern, Germany | ||
3931940 | 3931940 | 2020-08-30 | Germany | Mecklenburg-Vorpommern | 1007 | 20 | 949 | 39 | 53.6127 | 12.4296 | 2020-08-31 04:28:27 | Mecklenburg-Vorpommern, Germany | ||
613289 | 613289 | 2020-08-29 | Ukraine | Cherkasy Oblast | 1482 | 38 | 949 | 495 | 49.4444 | 32.0598 | 2020-08-30 04:28:22 | Cherkasy Oblast, Ukraine | ||
586476 | 586476 | 2020-08-13 | Yemen | 1847 | 528 | 949 | 370 | 15.552727 | 48.516388 | 2020-08-14 04:51:19 | Yemen | |||
98292 | 98292 | 2020-08-04 | Ukraine | Khmelnytskyi Oblast | 1200 | 25 | 949 | 226 | 49.423 | 26.9871 | 2020-08-05 04:34:43 | Khmelnytskyi Oblast, Ukraine | ||
1136549 | 1136549 | 2020-06-26 | Malaysia | Negeri Sembilan | 1016 | 8 | 949 | 59 | 2.7258 | 101.9424 | 2020-06-27 04:33:35 | Negeri Sembilan, Malaysia | ||
2555667 | 2555667 | 2020-06-02 | Italy | Calabria | 1158 | 97 | 949 | 112 | 38.90597598 | 16.59440194 | 2020-06-03 02:33:13 | Calabria, Italy | ||
1793910 | 1793910 | 2020-05-31 | Mexico | Hidalgo | 1710 | 304 | 949 | 457 | 20.0911 | -98.7624 | 2020-06-01 02:32:46 | Hidalgo, Mexico | ||
268377 | 268377 | 2020-05-21 | Mexico | Quintana Roo | 1450 | 280 | 949 | 221 | 19.1817 | -88.4791 | 2020-05-22 02:36:51 | Quintana Roo, Mexico | ||
1829748 | 1829748 | 2020-05-16 | Senegal | 2429 | 25 | 949 | 1455 | 14.4974 | -14.4524 | 2020-05-17 02:32:32 | Senegal |
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]);