johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
139 rows where recovered = 52 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
483466 | 483466 | 2021-07-19 | Denmark | Greenland | 81 | 0 | 52 | 29 | 71.7069 | -42.6043 | 2021-07-20 04:21:48 | Greenland, Denmark | ||
2673689 | 2673689 | 2021-07-18 | Denmark | Greenland | 78 | 0 | 52 | 26 | 71.7069 | -42.6043 | 2021-07-19 04:21:24 | Greenland, Denmark | ||
3706001 | 3706001 | 2021-07-17 | Denmark | Greenland | 72 | 0 | 52 | 20 | 71.7069 | -42.6043 | 2021-07-18 04:22:07 | Greenland, Denmark | ||
2693506 | 2693506 | 2021-07-06 | China | Macau | 55 | 0 | 52 | 3 | 22.1667 | 113.55 | 2021-07-07 04:21:20 | Macau, China | ||
2764729 | 2764729 | 2021-07-01 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-07-02 04:21:47 | Unknown, Chile | ||||
1892937 | 1892937 | 2021-06-30 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-07-01 04:21:19 | Unknown, Chile | ||||
400060 | 400060 | 2021-06-29 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-30 04:21:41 | Unknown, Chile | ||||
3125303 | 3125303 | 2021-06-28 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-29 04:21:28 | Unknown, Chile | ||||
2589798 | 2589798 | 2021-06-27 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-28 04:21:29 | Unknown, Chile | ||||
3958302 | 3958302 | 2021-06-26 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-27 04:21:39 | Unknown, Chile | ||||
1712121 | 1712121 | 2021-06-25 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-26 04:21:43 | Unknown, Chile | ||||
2295246 | 2295246 | 2021-06-24 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-25 04:21:33 | Unknown, Chile | ||||
2422686 | 2422686 | 2021-06-23 | Chile | Unknown | 54 | 0 | 52 | 2 | 2021-06-24 04:21:55 | Unknown, Chile | ||||
562763 | 562763 | 2021-06-22 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-23 04:21:46 | Unknown, Chile | ||||
3358465 | 3358465 | 2021-06-21 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-22 04:21:34 | Unknown, Chile | ||||
2884164 | 2884164 | 2021-06-20 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-21 04:21:41 | Unknown, Chile | ||||
107247 | 107247 | 2021-06-19 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-20 04:21:48 | Unknown, Chile | ||||
1125390 | 1125390 | 2021-06-18 | Chile | Unknown | 57 | 0 | 52 | 5 | 2021-06-19 04:22:33 | Unknown, Chile | ||||
2910968 | 2910968 | 2021-06-17 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-18 04:22:16 | Unknown, Chile | ||||
3030086 | 3030086 | 2021-06-16 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-17 04:22:36 | Unknown, Chile | ||||
2339192 | 2339192 | 2021-06-15 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-16 04:22:32 | Unknown, Chile | ||||
1563888 | 1563888 | 2021-06-14 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-15 04:22:22 | Unknown, Chile | ||||
3381171 | 3381171 | 2021-06-13 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-06-14 04:22:46 | Unknown, Chile | ||||
1567902 | 1567902 | 2021-04-22 | Chile | Unknown | 52 | 0 | 52 | 0 | 2021-04-23 04:20:52 | Unknown, Chile | ||||
2426700 | 2426700 | 2021-01-23 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-24 05:22:35 | Unknown, Chile | ||||
2466602 | 2466602 | 2021-01-22 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-23 05:22:03 | Unknown, Chile | ||||
435153 | 435153 | 2021-01-21 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-22 05:22:10 | Unknown, Chile | ||||
1093885 | 1093885 | 2021-01-20 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-21 05:22:01 | Unknown, Chile | ||||
907975 | 907975 | 2021-01-19 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-20 05:21:54 | Unknown, Chile | ||||
237038 | 237038 | 2021-01-18 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-19 05:22:15 | Unknown, Chile | ||||
3503155 | 3503155 | 2021-01-17 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-18 05:22:34 | Unknown, Chile | ||||
3101238 | 3101238 | 2021-01-16 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-17 05:22:17 | Unknown, Chile | ||||
3515200 | 3515200 | 2021-01-15 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-16 05:22:40 | Unknown, Chile | ||||
3879373 | 3879373 | 2021-01-14 | Chile | Unknown | 52 | 1 | 52 | 0 | 2021-01-15 05:22:24 | Unknown, Chile | ||||
3847487 | 3847487 | 2020-12-13 | Australia | Northern Territory | 63 | 0 | 52 | 11 | -12.4634 | 130.8456 | 2020-12-14 05:26:27 | Northern Territory, Australia | ||
845269 | 845269 | 2020-12-12 | Australia | Northern Territory | 62 | 0 | 52 | 10 | -12.4634 | 130.8456 | 2020-12-13 05:27:20 | Northern Territory, Australia | ||
860376 | 860376 | 2020-12-11 | Australia | Northern Territory | 62 | 0 | 52 | 10 | -12.4634 | 130.8456 | 2020-12-12 05:26:19 | Northern Territory, Australia | ||
1599918 | 1599918 | 2020-12-10 | Australia | Northern Territory | 62 | 0 | 52 | 10 | -12.4634 | 130.8456 | 2020-12-11 05:26:59 | Northern Territory, Australia | ||
2974927 | 2974927 | 2020-12-09 | Australia | Northern Territory | 61 | 0 | 52 | 9 | -12.4634 | 130.8456 | 2020-12-10 05:26:19 | Northern Territory, Australia | ||
1006336 | 1006336 | 2020-12-06 | Japan | Tottori | 63 | 0 | 52 | 11 | 35.359069 | 133.863619 | 2020-12-07 05:26:14 | Tottori, Japan | ||
1632345 | 1632345 | 2020-12-05 | Japan | Tottori | 63 | 0 | 52 | 11 | 35.359069 | 133.863619 | 2020-12-06 05:26:18 | Tottori, Japan | ||
3859873 | 3859873 | 2020-12-04 | Japan | Tottori | 61 | 0 | 52 | 9 | 35.359069 | 133.863619 | 2020-12-05 05:27:36 | Tottori, Japan | ||
75131 | 75131 | 2020-12-03 | Japan | Tottori | 61 | 0 | 52 | 9 | 35.359069 | 133.863619 | 2020-12-04 05:27:27 | Tottori, Japan | ||
738343 | 738343 | 2020-12-02 | Japan | Tottori | 60 | 0 | 52 | 8 | 35.359069 | 133.863619 | 2020-12-03 05:28:22 | Tottori, Japan | ||
2537437 | 2537437 | 2020-12-01 | Japan | Tottori | 59 | 0 | 52 | 7 | 35.359069 | 133.863619 | 2020-12-02 05:27:41 | Tottori, Japan | ||
3566609 | 3566609 | 2020-11-29 | Japan | Tottori | 58 | 0 | 52 | 6 | 35.359069 | 133.863619 | 2020-11-30 05:26:13 | Tottori, Japan | ||
2856645 | 2856645 | 2020-10-16 | Chile | Unknown | 52 | 1 | 52 | 0 | 2020-10-17 04:24:12 | Unknown, Chile | ||||
78886 | 78886 | 2020-10-14 | Chile | Unknown | 52 | 1 | 52 | 0 | 2020-10-15 04:24:28 | Unknown, Chile | ||||
3781701 | 3781701 | 2020-10-13 | Chile | Unknown | 52 | 1 | 52 | 0 | 2020-10-14 04:24:05 | Unknown, Chile | ||||
2291241 | 2291241 | 2020-10-12 | Chile | Unknown | 90 | 1 | 52 | 37 | 2020-10-13 04:24:02 | Unknown, Chile | ||||
3785694 | 3785694 | 2020-10-11 | Chile | Unknown | 52 | 1 | 52 | 0 | 2020-10-12 04:23:45 | Unknown, Chile | ||||
2689480 | 2689480 | 2020-10-08 | Chile | Unknown | 52 | 1 | 52 | 0 | 2020-10-09 04:23:59 | Unknown, Chile | ||||
3117283 | 3117283 | 2020-10-06 | Chile | Unknown | 52 | 1 | 52 | 0 | 2020-10-07 04:23:40 | Unknown, Chile | ||||
2510086 | 2510086 | 2020-08-27 | France | St Martin | 198 | 5 | 52 | 141 | 18.0708 | -63.0501 | 2020-08-28 04:28:11 | St Martin, France | ||
1996546 | 1996546 | 2020-08-26 | France | St Martin | 176 | 5 | 52 | 119 | 18.0708 | -63.0501 | 2020-08-27 04:28:15 | St Martin, France | ||
3562470 | 3562470 | 2020-08-25 | France | St Martin | 176 | 5 | 52 | 119 | 18.0708 | -63.0501 | 2020-08-26 04:28:11 | St Martin, France | ||
2991174 | 2991174 | 2020-08-24 | France | St Martin | 176 | 5 | 52 | 119 | 18.0708 | -63.0501 | 2020-08-25 04:28:02 | St Martin, France | ||
2215569 | 2215569 | 2020-08-23 | France | St Martin | 176 | 5 | 52 | 119 | 18.0708 | -63.0501 | 2020-08-24 04:27:56 | St Martin, France | ||
2299351 | 2299351 | 2020-08-22 | France | St Martin | 121 | 5 | 52 | 64 | 18.0708 | -63.0501 | 2020-08-23 04:27:48 | St Martin, France | ||
1479458 | 1479458 | 2020-08-21 | France | St Martin | 121 | 5 | 52 | 64 | 18.0708 | -63.0501 | 2020-08-22 04:27:49 | St Martin, France | ||
586468 | 586468 | 2020-08-13 | United Kingdom | Turks and Caicos Islands | 258 | 2 | 52 | 204 | 21.694000000000006 | -71.7979 | 2020-08-14 04:51:19 | Turks and Caicos Islands, United Kingdom | ||
3531714 | 3531714 | 2020-08-12 | Saint Vincent and the Grenadines | 57 | 0 | 52 | 5 | 12.9843 | -61.2872 | 2020-08-13 04:29:15 | Saint Vincent and the Grenadines | |||
662563 | 662563 | 2020-08-11 | Saint Vincent and the Grenadines | 57 | 0 | 52 | 5 | 12.9843 | -61.2872 | 2020-08-12 04:27:29 | Saint Vincent and the Grenadines | |||
1920810 | 1920810 | 2020-08-10 | Saint Vincent and the Grenadines | 57 | 0 | 52 | 5 | 12.9843 | -61.2872 | 2020-08-11 04:35:08 | Saint Vincent and the Grenadines | |||
1920667 | 1920667 | 2020-08-10 | Japan | Yamaguchi | 78 | 0 | 52 | 26 | 34.201190000000004 | 131.573293 | 2020-08-11 04:35:08 | Yamaguchi, Japan | ||
3923619 | 3923619 | 2020-08-09 | Saint Vincent and the Grenadines | 57 | 0 | 52 | 5 | 12.9843 | -61.2872 | 2020-08-10 04:34:55 | Saint Vincent and the Grenadines | |||
2740187 | 2740187 | 2020-08-03 | Japan | Kumamoto | 243 | 4 | 52 | 187 | 32.608154 | 130.74523100000002 | 2020-08-04 04:41:59 | Kumamoto, Japan | ||
2807939 | 2807939 | 2020-08-02 | Japan | Kumamoto | 237 | 3 | 52 | 182 | 32.608154 | 130.74523100000002 | 2020-08-03 04:34:35 | Kumamoto, Japan | ||
1928427 | 1928427 | 2020-07-30 | Japan | Mie | 91 | 1 | 52 | 38 | 34.508018 | 136.376013 | 2020-07-31 04:35:18 | Mie, Japan | ||
2958595 | 2958595 | 2020-07-29 | Japan | Mie | 90 | 1 | 52 | 37 | 34.508018 | 136.376013 | 2020-07-30 04:35:05 | Mie, Japan | ||
442837 | 442837 | 2020-07-26 | Botswana | 686 | 1 | 52 | 633 | -22.3285 | 24.6849 | 2020-07-27 04:35:02 | Botswana | |||
1503080 | 1503080 | 2020-07-25 | Botswana | 686 | 1 | 52 | 633 | -22.3285 | 24.6849 | 2020-07-26 04:35:00 | Botswana | |||
2564051 | 2564051 | 2020-07-24 | Botswana | 686 | 1 | 52 | 633 | -22.3285 | 24.6849 | 2020-07-25 04:47:39 | Botswana | |||
844606 | 844606 | 2020-07-22 | Colombia | Caqueta | 476 | 7 | 52 | 417 | 0.8699 | -73.8419 | 2020-07-23 05:15:04 | Caqueta, Colombia | ||
844569 | 844569 | 2020-07-22 | Chile | Aysen | 69 | 1 | 52 | 16 | -45.9864 | -73.7669 | 2020-07-23 05:15:04 | Aysen, Chile | ||
1707570 | 1707570 | 2020-07-21 | Russia | Nenets Autonomous Okrug | 260 | 0 | 52 | 208 | 68.27557185 | 57.1686375 | 2020-07-22 04:34:42 | Nenets Autonomous Okrug, Russia | ||
1707308 | 1707308 | 2020-07-21 | Chile | Aysen | 69 | 1 | 52 | 16 | -45.9864 | -73.7669 | 2020-07-22 04:34:42 | Aysen, Chile | ||
2974615 | 2974615 | 2020-06-30 | India | Sikkim | 89 | 0 | 52 | 37 | 27.571671000000002 | 88.472712 | 2020-07-01 04:33:52 | Sikkim, India | ||
2437929 | 2437929 | 2020-06-20 | Colombia | La Guajira | 170 | 8 | 52 | 110 | 11.3548 | -72.5205 | 2020-06-21 04:33:19 | La Guajira, Colombia | ||
1691522 | 1691522 | 2020-06-19 | Ukraine | Luhansk Oblast | 71 | 0 | 52 | 19 | 48.574 | 39.3078 | 2020-06-20 04:33:19 | Luhansk Oblast, Ukraine | ||
737670 | 737670 | 2020-06-12 | Colombia | Santander | 208 | 8 | 52 | 148 | 6.6437 | -73.6536 | 2020-06-13 03:33:14 | Santander, Colombia | ||
2864039 | 2864039 | 2020-06-10 | India | Puducherry | 127 | 0 | 52 | 75 | 11.882658 | 78.86498 | 2020-06-11 03:33:41 | Puducherry, India | ||
2863924 | 2863924 | 2020-06-10 | India | Ladakh | 108 | 1 | 52 | 55 | 34.1526 | 77.5771 | 2020-06-11 03:33:41 | Ladakh, India | ||
2800328 | 2800328 | 2020-06-07 | Libya | 256 | 5 | 52 | 199 | 26.3351 | 17.228331 | 2020-06-08 03:33:22 | Libya | |||
574384 | 574384 | 2020-06-06 | Libya | 256 | 5 | 52 | 199 | 26.3351 | 17.228331 | 2020-06-07 03:53:30 | Libya | |||
1270081 | 1270081 | 2020-06-05 | Libya | 239 | 5 | 52 | 182 | 26.3351 | 17.228331 | 2020-06-06 02:33:00 | Libya | |||
1281541 | 1281541 | 2020-06-04 | Libya | 209 | 5 | 52 | 152 | 26.3351 | 17.228331 | 2020-06-05 02:33:06 | Libya | |||
3867096 | 3867096 | 2020-06-03 | Libya | 196 | 5 | 52 | 139 | 26.3351 | 17.228331 | 2020-06-04 02:33:14 | Libya | |||
2556138 | 2556138 | 2020-06-02 | Libya | 182 | 5 | 52 | 125 | 26.3351 | 17.228331 | 2020-06-03 02:33:13 | Libya | |||
805675 | 805675 | 2020-06-01 | Libya | 168 | 5 | 52 | 111 | 26.3351 | 17.228331 | 2020-06-02 02:33:08 | Libya | |||
1794209 | 1794209 | 2020-05-31 | Libya | 156 | 5 | 52 | 99 | 26.3351 | 17.228331 | 2020-06-01 02:32:46 | Libya | |||
1104867 | 1104867 | 2020-05-25 | Mexico | Colima | 115 | 18 | 52 | 45 | 19.1223 | -104.0072 | 2020-05-26 02:32:35 | Colima, Mexico | ||
2278797 | 2278797 | 2020-05-03 | Uganda | 89 | 0 | 52 | 37 | 1.373333 | 32.290275 | 2020-05-04 02:32:28 | Uganda | |||
2278783 | 2278783 | 2020-05-03 | Sudan | 592 | 41 | 52 | 499 | 12.8628 | 30.2176 | 2020-05-04 02:32:28 | Sudan | |||
2043473 | 2043473 | 2020-05-02 | Uganda | 88 | 0 | 52 | 36 | 1.373333 | 32.290275 | 2020-05-03 02:32:28 | Uganda | |||
2043459 | 2043459 | 2020-05-02 | Sudan | 533 | 41 | 52 | 440 | 12.8628 | 30.2176 | 2020-05-03 02:32:28 | Sudan | |||
1184367 | 1184367 | 2020-05-01 | Uganda | 85 | 0 | 52 | 33 | 1.373333 | 32.290275 | 2020-05-02 02:32:27 | Uganda | |||
228848 | 228848 | 2020-04-30 | Uganda | 83 | 0 | 52 | 31 | 1.373333 | 32.290275 | 2020-05-01 02:32:28 | Uganda | |||
137593 | 137593 | 2020-04-29 | Uganda | 81 | 0 | 52 | 29 | 1.373333 | 32.290275 | 2020-04-30 02:32:27 | Uganda | |||
271807 | 271807 | 2020-04-28 | Uganda | 79 | 0 | 52 | 27 | 1.373333 | 32.290275 | 2020-04-29 02:32:29 | Uganda |
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]);