johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 22398 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2431004 | 2431004 | 2022-11-09 | Malaysia | W.P. Labuan | 22398 | 157 | 0 | 5.2831 | 115.2308 | 2022-11-10 04:21:16 | W.P. Labuan, Malaysia | |||
1648682 | 1648682 | 2022-06-23 | Spain | Melilla | 22398 | 156 | 0 | 35.2923 | -2.9381 | 2022-06-24 04:20:58 | Melilla, Spain | |||
2187917 | 2187917 | 2022-06-22 | Spain | Melilla | 22398 | 156 | 0 | 35.2923 | -2.9381 | 2022-06-23 04:20:55 | Melilla, Spain | |||
166348 | 166348 | 2022-06-21 | Spain | Melilla | 22398 | 156 | 0 | 35.2923 | -2.9381 | 2022-06-22 04:20:54 | Melilla, Spain | |||
3852779 | 3852779 | 2022-04-27 | US | Illinois | Adams | 17001 | 22398 | 209 | 0 | 39.98815591 | -91.18786813 | 2022-04-28 04:20:47 | Adams, Illinois, US | |
2895052 | 2895052 | 2022-04-21 | US | Oregon | Umatilla | 41059 | 22398 | 219 | 0 | 45.59073056 | -118.7353826 | 2022-04-22 04:20:45 | Umatilla, Oregon, US | |
3321043 | 3321043 | 2022-04-07 | US | Georgia | Fayette | 13113 | 22398 | 314 | 0 | 33.41357794 | -84.49089434 | 2022-04-08 04:20:48 | Fayette, Georgia, US | |
2905209 | 2905209 | 2021-12-19 | US | Louisiana | Bossier | 22015 | 22398 | 411 | 0 | 32.67932307 | -93.60460152 | 2021-12-20 04:21:43 | Bossier, Louisiana, US | |
1260282 | 1260282 | 2021-12-18 | US | Louisiana | Bossier | 22015 | 22398 | 411 | 0 | 32.67932307 | -93.60460152 | 2021-12-19 04:21:11 | Bossier, Louisiana, US | |
2400310 | 2400310 | 2021-12-17 | US | Louisiana | Bossier | 22015 | 22398 | 411 | 0 | 32.67932307 | -93.60460152 | 2021-12-18 02:22:20 | Bossier, Louisiana, US | |
1360992 | 1360992 | 2021-11-27 | US | Pennsylvania | Cambria | 42021 | 22398 | 557 | 0 | 40.49527404 | -78.71377428 | 2021-11-28 04:22:43 | Cambria, Pennsylvania, US | |
937479 | 937479 | 2021-10-16 | US | Pennsylvania | Lackawanna | 42069 | 22398 | 510 | 0 | 41.43564672 | -75.60379201 | 2021-10-17 04:21:29 | Lackawanna, Pennsylvania, US | |
3168104 | 3168104 | 2021-08-23 | US | Ohio | Lake | 39085 | 22398 | 407 | 0 | 41.69710807 | -81.23676539 | 2021-08-24 04:21:19 | Lake, Ohio, US | |
778586 | 778586 | 2021-07-08 | Russia | Mordovia Republic | 22398 | 348 | 20044 | 2006 | 54.4419829 | 44.4661144 | 2021-07-09 04:21:21 | Mordovia Republic, Russia | ||
1798839 | 1798839 | 2021-03-23 | Russia | Kabardino-Balkarian Republic | 22398 | 403 | 21186 | 809 | 43.4806048 | 43.5978976 | 2021-03-24 05:25:40 | Kabardino-Balkarian Republic, Russia | ||
55616 | 55616 | 2021-03-07 | US | Georgia | Henry | 13151 | 22398 | 276 | 0 | 33.4533428 | -84.14814659999998 | 2021-03-08 05:24:48 | Henry, Georgia, US | |
1937116 | 1937116 | 2021-02-23 | US | Delaware | Sussex | 10005 | 22398 | 424 | 0 | 21974 | 38.66143781 | -75.39031349 | 2021-02-24 05:29:16 | Sussex, Delaware, US |
182898 | 182898 | 2021-02-21 | US | Georgia | Richmond | 13245 | 22398 | 412 | 0 | 21986 | 33.35777107 | -82.07026432 | 2021-02-22 05:24:21 | Richmond, Georgia, US |
2211915 | 2211915 | 2021-01-30 | Russia | Tambov Oblast | 22398 | 268 | 20745 | 1385 | 52.9019574 | 41.3578918 | 2021-01-31 05:22:42 | Tambov Oblast, Russia | ||
2543029 | 2543029 | 2021-01-07 | US | Michigan | Genesee | 26049 | 22398 | 644 | 0 | 21754 | 43.02244215 | -83.70589709 | 2021-01-08 05:22:42 | Genesee, Michigan, US |
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]);