johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where recovered = 1689 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331394 | 3331394 | 2021-07-21 | Colombia | Vaupes | 1713 | 17 | 1689 | 7 | 0.8554 | -70.812 | 2021-07-22 04:21:19 | Vaupes, Colombia | ||
982720 | 982720 | 2021-04-17 | Canada | Nova Scotia | 1800 | 67 | 1689 | 44 | 44.682 | -63.7443 | 2021-04-18 04:20:41 | Nova Scotia, Canada | ||
1858022 | 1858022 | 2021-02-25 | Japan | Kagoshima | 1758 | 26 | 1689 | 43 | 31.009484000000004 | 130.430665 | 2021-02-26 05:22:40 | Kagoshima, Japan | ||
742137 | 742137 | 2021-02-20 | China | Shanghai | 1781 | 7 | 1689 | 85 | 31.202 | 121.4491 | 2021-02-21 05:24:33 | Shanghai, China | ||
16024 | 16024 | 2021-01-26 | Malaysia | Sarawak | 3704 | 33 | 1689 | 1982 | 1.5533 | 110.3592 | 2021-01-27 05:23:41 | Sarawak, Malaysia | ||
3307989 | 3307989 | 2021-01-13 | Chile | Aysen | 1893 | 18 | 1689 | 186 | -45.9864 | -73.7669 | 2021-01-14 05:22:32 | Aysen, Chile | ||
3189837 | 3189837 | 2020-11-22 | Colombia | Guaviare | 1766 | 27 | 1689 | 50 | 1.0654 | -73.2603 | 2020-11-23 05:25:26 | Guaviare, Colombia | ||
970523 | 970523 | 2020-09-29 | Ukraine | Sumy Oblast | 4008 | 70 | 1689 | 2249 | 50.9077 | 34.7981 | 2020-09-30 04:23:33 | Sumy Oblast, Ukraine | ||
3093141 | 3093141 | 2020-09-20 | Bahamas | 3315 | 74 | 1689 | 1552 | 25.025885 | -78.035889 | 2020-09-21 04:23:00 | Bahamas | |||
2513801 | 2513801 | 2020-08-27 | Ukraine | Odessa Oblast | 6537 | 93 | 1689 | 4755 | 46.4846 | 30.7326 | 2020-08-28 04:28:11 | Odessa Oblast, Ukraine | ||
2000261 | 2000261 | 2020-08-26 | Ukraine | Odessa Oblast | 6352 | 90 | 1689 | 4573 | 46.4846 | 30.7326 | 2020-08-27 04:28:15 | Odessa Oblast, Ukraine | ||
3566185 | 3566185 | 2020-08-25 | Ukraine | Odessa Oblast | 6166 | 88 | 1689 | 4389 | 46.4846 | 30.7326 | 2020-08-26 04:28:11 | Odessa Oblast, Ukraine | ||
2994889 | 2994889 | 2020-08-24 | Ukraine | Odessa Oblast | 6054 | 88 | 1689 | 4277 | 46.4846 | 30.7326 | 2020-08-25 04:28:02 | Odessa Oblast, Ukraine | ||
2219284 | 2219284 | 2020-08-23 | Ukraine | Odessa Oblast | 5909 | 88 | 1689 | 4132 | 46.4846 | 30.7326 | 2020-08-24 04:27:56 | Odessa Oblast, Ukraine | ||
2303066 | 2303066 | 2020-08-22 | Ukraine | Odessa Oblast | 5788 | 86 | 1689 | 4013 | 46.4846 | 30.7326 | 2020-08-23 04:27:48 | Odessa Oblast, Ukraine | ||
3177814 | 3177814 | 2020-08-18 | China | Guangdong | 1725 | 8 | 1689 | 28 | 23.3417 | 113.4244 | 2020-08-19 04:27:00 | Guangdong, China | ||
2807940 | 2807940 | 2020-08-02 | Russia | Kurgan Oblast | 2303 | 10 | 1689 | 604 | 55.7655302 | 64.5632681 | 2020-08-03 04:34:35 | Kurgan Oblast, Russia | ||
3264703 | 3264703 | 2020-07-31 | India | Manipur | 2621 | 5 | 1689 | 927 | 24.738975 | 93.882541 | 2020-08-01 04:36:27 | Manipur, India | ||
1837233 | 1837233 | 2020-06-14 | Russia | Orel Oblast | 3559 | 35 | 1689 | 1835 | 52.96854329999999 | 36.0692477 | 2020-06-15 03:33:14 | Orel Oblast, Russia | ||
737617 | 737617 | 2020-06-12 | Russia | Perm Krai | 2506 | 38 | 1689 | 779 | 58.5951603 | 56.3159546 | 2020-06-13 03:33:14 | Perm Krai, Russia | ||
875758 | 875758 | 2020-05-24 | Cuba | 1941 | 82 | 1689 | 170 | 21.521757 | -77.78116700000002 | 2020-05-25 02:32:44 | Cuba | |||
114241 | 114241 | 2020-05-08 | Croatia | 2161 | 86 | 1689 | 386 | 45.1 | 15.2 | 2020-05-09 02:32:35 | Croatia | |||
2278759 | 2278759 | 2020-05-03 | Portugal | 25282 | 1043 | 1689 | 22550 | 39.3999 | -8.2245 | 2020-05-04 02:32:28 | Portugal | |||
1184272 | 1184272 | 2020-05-01 | Iceland | 1798 | 10 | 1689 | 99 | 64.9631 | -19.0208 | 2020-05-02 02:32:27 | Iceland | |||
50423 | 50423 | 2020-04-17 | Thailand | 2700 | 47 | 1689 | 964 | 15.870032 | 100.992541 | 2020-04-17 23:30:32 | Thailand |
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]);