johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 20154 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2771908 | 2771908 | 2022-09-26 | US | Tennessee | Gibson | 47053 | 20154 | 273 | 0 | 35.99438059 | -88.93358327 | 2022-09-27 04:23:01 | Gibson, Tennessee, US | |
1058152 | 1058152 | 2022-02-23 | Spain | Melilla | 20154 | 147 | 0 | 35.2923 | -2.9381 | 2022-02-24 04:21:14 | Melilla, Spain | |||
1298051 | 1298051 | 2022-02-17 | Japan | Ishikawa | 20154 | 155 | 0 | 36.769464 | 136.771027 | 2022-02-18 04:21:04 | Ishikawa, Japan | |||
3229894 | 3229894 | 2022-01-19 | US | Washington | Grant | 53025 | 20154 | 187 | 0 | 47.20753737 | -119.4500749 | 2022-01-20 04:21:07 | Grant, Washington, US | |
1218022 | 1218022 | 2022-01-08 | US | Ohio | Columbiana | 39029 | 20154 | 428 | 0 | 40.76932373 | -80.78094576 | 2022-01-09 04:21:46 | Columbiana, Ohio, US | |
3514396 | 3514396 | 2021-11-01 | US | Tennessee | Sevier | 47155 | 20154 | 270 | 0 | 35.78077323 | -83.52244332 | 2021-11-02 04:22:03 | Sevier, Tennessee, US | |
1957466 | 1957466 | 2021-08-05 | US | Idaho | Kootenai | 16055 | 20154 | 225 | 0 | 47.67282258 | -116.7020872 | 2021-08-06 04:21:18 | Kootenai, Idaho, US | |
3478558 | 3478558 | 2021-07-22 | US | New York | Niagara | 36063 | 20154 | 374 | 0 | 43.19898042 | -78.74777412 | 2021-07-23 04:21:29 | Niagara, New York, US | |
353090 | 353090 | 2021-03-11 | US | Georgia | Forsyth | 13117 | 20154 | 162 | 0 | 34.22604035 | -84.12315129999998 | 2021-03-12 05:26:50 | Forsyth, Georgia, US | |
3254873 | 3254873 | 2021-03-02 | US | Florida | St. Johns | 12109 | 20154 | 198 | 0 | 19956 | 29.90096506 | -81.43589967 | 2021-03-03 05:23:28 | St. Johns, Florida, US |
613882 | 613882 | 2021-02-08 | Russia | Chuvashia Republic | 20154 | 926 | 18251 | 977 | 55.4259922 | 47.0849429 | 2021-02-09 05:23:30 | Chuvashia Republic, Russia | ||
3154211 | 3154211 | 2021-01-27 | US | Colorado | Douglas | 8035 | 20154 | 217 | 0 | 18385 | 39.33133796 | -104.930001 | 2021-01-28 05:22:24 | Douglas, Colorado, US |
2430525 | 2430525 | 2021-01-23 | Ukraine | Kherson Oblast | 20154 | 549 | 15697 | 3908 | 46.6354 | 32.6169 | 2021-01-24 05:22:35 | Kherson Oblast, Ukraine | ||
927683 | 927683 | 2020-12-21 | Italy | P.A. Trento | 20154 | 855 | 17227 | 2072 | 46.06893511 | 11.12123097 | 2020-12-22 05:22:33 | P.A. Trento, Italy | ||
3785767 | 3785767 | 2020-10-11 | Cote d'Ivoire | 20154 | 120 | 19798 | 236 | 7.54 | -5.5471 | 2020-10-12 04:23:45 | Cote d'Ivoire | |||
967457 | 967457 | 2020-09-29 | US | California | San Joaquin | 6077 | 20154 | 454 | 0 | 19700 | 37.93433732 | -121.2730061 | 2020-09-30 04:23:33 | San Joaquin, California, US |
2222858 | 2222858 | 2020-07-08 | Brazil | Roraima | 20154 | 393 | 4495 | 14403 | -2.7376 | -62.0751 | 2020-07-09 04:34:23 | Roraima, Brazil |
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]);