johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where recovered = 2482 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- France 6
- United Kingdom 5
- Japan 3
- Russia 3
- Colombia 2
- Malaysia 2
- Guinea-Bissau 1
- Hungary 1
- Mali 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2375160 | 2375160 | 2021-07-20 | United Kingdom | Bermuda | 2530 | 33 | 2482 | 15 | 32.3078 | -64.7505 | 2021-07-21 04:21:40 | Bermuda, United Kingdom | ||
487239 | 487239 | 2021-07-19 | United Kingdom | Bermuda | 2530 | 33 | 2482 | 15 | 32.3078 | -64.7505 | 2021-07-20 04:21:48 | Bermuda, United Kingdom | ||
2677462 | 2677462 | 2021-07-18 | United Kingdom | Bermuda | 2530 | 33 | 2482 | 15 | 32.3078 | -64.7505 | 2021-07-19 04:21:24 | Bermuda, United Kingdom | ||
3709774 | 3709774 | 2021-07-17 | United Kingdom | Bermuda | 2530 | 33 | 2482 | 15 | 32.3078 | -64.7505 | 2021-07-18 04:22:07 | Bermuda, United Kingdom | ||
2951005 | 2951005 | 2021-07-16 | United Kingdom | Bermuda | 2530 | 33 | 2482 | 15 | 32.3078 | -64.7505 | 2021-07-17 04:22:22 | Bermuda, United Kingdom | ||
2717006 | 2717006 | 2021-06-10 | Japan | Saga | 2535 | 23 | 2482 | 30 | 33.286977 | 130.115738 | 2021-06-11 04:23:20 | Saga, Japan | ||
2586033 | 2586033 | 2021-06-05 | Japan | Wakayama | 2635 | 45 | 2482 | 108 | 33.911879 | 135.505446 | 2021-06-06 04:24:03 | Wakayama, Japan | ||
1916899 | 1916899 | 2021-05-20 | Malaysia | W.P. Labuan | 2553 | 13 | 2482 | 58 | 5.2831 | 115.2308 | 2021-05-21 04:20:43 | W.P. Labuan, Malaysia | ||
3420955 | 3420955 | 2021-03-19 | Japan | Shiga | 2681 | 51 | 2482 | 148 | 35.21582700000001 | 136.138064 | 2021-03-20 05:25:46 | Shiga, Japan | ||
3600970 | 3600970 | 2021-02-17 | Guinea-Bissau | 2999 | 46 | 2482 | 471 | 11.8037 | -15.1804 | 2021-02-18 05:22:58 | Guinea-Bissau | |||
765992 | 765992 | 2020-10-18 | Malaysia | Selangor | 3251 | 25 | 2482 | 744 | 3.0738 | 101.5183 | 2020-10-19 04:24:16 | Selangor, Malaysia | ||
3801966 | 3801966 | 2020-10-05 | Mali | 3189 | 131 | 2482 | 576 | 17.570692 | -3.996166000000001 | 2020-10-06 04:23:33 | Mali | |||
2605925 | 2605925 | 2020-09-24 | France | Reunion | 3501 | 11 | 2482 | 1008 | -21.1151 | 55.5364 | 2020-09-25 04:23:00 | Reunion, France | ||
2653668 | 2653668 | 2020-09-23 | France | Reunion | 3501 | 15 | 2482 | 1004 | -21.1151 | 55.5364 | 2020-09-24 04:23:00 | Reunion, France | ||
3316117 | 3316117 | 2020-09-22 | France | Reunion | 3415 | 15 | 2482 | 918 | -21.1151 | 55.5364 | 2020-09-23 04:23:00 | Reunion, France | ||
2836716 | 2836716 | 2020-09-21 | France | Reunion | 3415 | 15 | 2482 | 918 | -21.1151 | 55.5364 | 2020-09-22 04:23:00 | Reunion, France | ||
3093320 | 3093320 | 2020-09-20 | France | Reunion | 3194 | 15 | 2482 | 697 | -21.1151 | 55.5364 | 2020-09-21 04:23:00 | Reunion, France | ||
2454670 | 2454670 | 2020-09-19 | France | Reunion | 3194 | 15 | 2482 | 697 | -21.1151 | 55.5364 | 2020-09-20 04:22:00 | Reunion, France | ||
427193 | 427193 | 2020-09-07 | Colombia | Putumayo | 3213 | 142 | 2482 | 589 | 0.436 | -75.5277 | 2020-09-08 04:28:25 | Putumayo, Colombia | ||
3161478 | 3161478 | 2020-09-06 | Colombia | Putumayo | 3213 | 142 | 2482 | 589 | 0.436 | -75.5277 | 2020-09-07 04:28:30 | Putumayo, Colombia | ||
3932236 | 3932236 | 2020-08-30 | Russia | Kostroma Oblast | 3510 | 40 | 2482 | 988 | 58.424756 | 44.2533273 | 2020-08-31 04:28:27 | Kostroma Oblast, Russia | ||
1928470 | 1928470 | 2020-07-30 | Russia | Novgorod Oblast | 3729 | 71 | 2482 | 1176 | 58.2843833 | 32.516975699999996 | 2020-07-31 04:35:18 | Novgorod Oblast, Russia | ||
1522219 | 1522219 | 2020-06-23 | Russia | Bashkortostan Republic | 5011 | 18 | 2482 | 2511 | 54.8573563 | 57.1439682 | 2020-06-24 04:33:28 | Bashkortostan Republic, Russia | ||
1837485 | 1837485 | 2020-06-14 | Hungary | 4069 | 562 | 2482 | 1025 | 47.1625 | 19.5033 | 2020-06-15 03:33:14 | Hungary | |||
1404385 | 1404385 | 2020-05-14 | Spain | Extremadura | 2923 | 492 | 2482 | 0 | 39.4937 | -6.0679 | 2020-05-15 02:33:02 | Extremadura, Spain |
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]);