johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where confirmed = 18868 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3377437 | 3377437 | 2022-12-08 | Malaysia | Perlis | 18868 | 194 | 0 | 6.4449 | 100.2048 | 2022-12-09 04:21:05 | Perlis, Malaysia | |||
2560128 | 2560128 | 2022-11-29 | US | Wisconsin | Columbia | 55021 | 18868 | 144 | 0 | 43.46492199 | -89.33589004 | 2022-11-30 04:21:07 | Columbia, Wisconsin, US | |
1683286 | 1683286 | 2022-08-29 | US | Puerto Rico | Toa Alta | 72135 | 18868 | 0 | 0 | 18.362406 | -66.246616 | 2022-08-30 04:21:03 | Toa Alta, Puerto Rico, US | |
1099947 | 1099947 | 2022-08-03 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-08-04 04:20:58 | Lowndes, Mississippi, US | |
1406872 | 1406872 | 2022-08-02 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-08-03 04:20:59 | Lowndes, Mississippi, US | |
3618910 | 3618910 | 2022-08-01 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-08-02 04:20:53 | Lowndes, Mississippi, US | |
3873390 | 3873390 | 2022-07-31 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-08-01 04:21:03 | Lowndes, Mississippi, US | |
676144 | 676144 | 2022-07-30 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-07-31 04:21:02 | Lowndes, Mississippi, US | |
1785343 | 1785343 | 2022-07-29 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-07-30 04:20:42 | Lowndes, Mississippi, US | |
1067706 | 1067706 | 2022-07-28 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-07-29 04:20:45 | Lowndes, Mississippi, US | |
2337225 | 2337225 | 2022-07-27 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-07-28 04:20:56 | Lowndes, Mississippi, US | |
1489415 | 1489415 | 2022-07-26 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-07-27 04:21:04 | Lowndes, Mississippi, US | |
2595861 | 2595861 | 2022-07-25 | US | Mississippi | Lowndes | 28087 | 18868 | 241 | 0 | 33.47386518 | -88.4419153 | 2022-07-26 04:20:58 | Lowndes, Mississippi, US | |
231508 | 231508 | 2022-05-31 | US | New York | Wayne | 36117 | 18868 | 179 | 0 | 43.15494365 | -77.02976528 | 2022-06-01 04:20:55 | Wayne, New York, US | |
25487 | 25487 | 2022-03-20 | US | Indiana | Floyd | 18043 | 18868 | 281 | 0 | 38.32117957 | -85.90385377 | 2022-03-21 04:20:50 | Floyd, Indiana, US | |
1657497 | 1657497 | 2022-03-19 | US | Indiana | Floyd | 18043 | 18868 | 281 | 0 | 38.32117957 | -85.90385377 | 2022-03-20 04:20:45 | Floyd, Indiana, US | |
337023 | 337023 | 2022-03-18 | US | Indiana | Floyd | 18043 | 18868 | 281 | 0 | 38.32117957 | -85.90385377 | 2022-03-19 04:20:47 | Floyd, Indiana, US | |
3520100 | 3520100 | 2022-01-02 | US | Connecticut | Middlesex | 9007 | 18868 | 414 | 0 | 41.45949668 | -72.53714864 | 2022-01-03 02:22:25 | Middlesex, Connecticut, US | |
2168230 | 2168230 | 2022-01-01 | US | Connecticut | Middlesex | 9007 | 18868 | 414 | 0 | 41.45949668 | -72.53714864 | 2022-01-02 04:20:52 | Middlesex, Connecticut, US | |
2777661 | 2777661 | 2021-12-31 | US | Connecticut | Middlesex | 9007 | 18868 | 414 | 0 | 41.45949668 | -72.53714864 | 2022-01-01 04:22:14 | Middlesex, Connecticut, US | |
3999318 | 3999318 | 2021-12-30 | US | Connecticut | Middlesex | 9007 | 18868 | 414 | 0 | 41.45949668 | -72.53714864 | 2021-12-31 04:21:50 | Middlesex, Connecticut, US | |
2000653 | 2000653 | 2021-11-07 | Japan | Gifu | 18868 | 218 | 0 | 35.778671 | 137.055925 | 2021-11-08 04:21:43 | Gifu, Japan | |||
781912 | 781912 | 2021-07-08 | US | Wisconsin | Kenosha | 55059 | 18868 | 336 | 0 | 42.57639354 | -88.04051686 | 2021-07-09 04:21:21 | Kenosha, Wisconsin, US | |
1082605 | 1082605 | 2021-05-14 | US | Florida | Clay | 12019 | 18868 | 342 | 0 | 29.98319144 | -81.85609986 | 2021-05-15 04:20:58 | Clay, Florida, US | |
1881208 | 1881208 | 2021-03-26 | Russia | Mordovia Republic | 18868 | 197 | 16858 | 1813 | 54.4419829 | 44.4661144 | 2021-03-27 05:25:04 | Mordovia Republic, Russia | ||
1838144 | 1838144 | 2021-03-12 | Russia | Kostroma Oblast | 18868 | 359 | 16157 | 2352 | 58.424756 | 44.2533273 | 2021-03-13 05:25:15 | Kostroma Oblast, Russia | ||
1673661 | 1673661 | 2021-02-07 | US | Iowa | Linn | 19113 | 18868 | 300 | 0 | 18568 | 42.07923082 | -91.59809485 | 2021-02-08 05:22:39 | Linn, Iowa, US |
793639 | 793639 | 2021-02-04 | US | Utah | Bear River | 18868 | 65 | 0 | 18803 | 41.52106798 | -113.0832816 | 2021-02-05 05:22:38 | Bear River, Utah, US | |
1134831 | 1134831 | 2020-06-26 | US | California | Orange | 6059 | 18868 | 323 | 0 | 18545 | 33.70147516 | -117.76459979999998 | 2020-06-27 04:33:35 | Orange, California, 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]);