johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 20787 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417819 | 2417819 | 2022-12-05 | US | Tennessee | Gibson | 47053 | 20787 | 287 | 0 | 35.99438059 | -88.93358327 | 2022-12-06 04:21:03 | Gibson, Tennessee, US | |
2166717 | 2166717 | 2022-03-26 | US | Texas | Maverick | 48323 | 20787 | 461 | 0 | 28.7429195 | -100.3157686 | 2022-03-27 04:20:47 | Maverick, Texas, US | |
3615238 | 3615238 | 2022-01-12 | US | New Jersey | Hunterdon | 34019 | 20787 | 214 | 0 | 40.56335249 | -74.91284156 | 2022-01-13 08:00:09 | Hunterdon, New Jersey, US | |
782875 | 782875 | 2021-12-13 | US | Arkansas | Faulkner | 5045 | 20787 | 230 | 0 | 35.14719007 | -92.33717519 | 2021-12-14 04:22:38 | Faulkner, Arkansas, US | |
1666969 | 1666969 | 2021-12-11 | US | Ohio | Wood | 39173 | 20787 | 281 | 0 | 41.36224827 | -83.62285108 | 2021-12-12 04:22:12 | Wood, Ohio, US | |
450060 | 450060 | 2021-11-17 | US | Pennsylvania | Monroe | 42089 | 20787 | 374 | 0 | 41.05934058 | -75.34031025 | 2021-11-18 04:21:33 | Monroe, Pennsylvania, US | |
3640925 | 3640925 | 2021-11-08 | US | Kentucky | Boone | 21015 | 20787 | 195 | 0 | 38.97065142 | -84.72615357 | 2021-11-09 04:21:36 | Boone, Kentucky, US | |
1275125 | 1275125 | 2021-10-03 | US | Georgia | Lowndes | 13185 | 20787 | 283 | 0 | 30.83568832 | -83.27056716 | 2021-10-04 04:21:31 | Lowndes, Georgia, US | |
3928878 | 3928878 | 2021-10-02 | US | Georgia | Lowndes | 13185 | 20787 | 283 | 0 | 30.83568832 | -83.27056716 | 2021-10-03 04:21:24 | Lowndes, Georgia, US | |
2132858 | 2132858 | 2021-10-01 | US | Georgia | Lowndes | 13185 | 20787 | 283 | 0 | 30.83568832 | -83.27056716 | 2021-10-02 04:21:25 | Lowndes, Georgia, US | |
1815355 | 1815355 | 2021-09-19 | US | California | Shasta | 6089 | 20787 | 258 | 0 | 40.76391419 | -122.0396884 | 2021-09-20 04:21:22 | Shasta, California, US | |
2355069 | 2355069 | 2021-08-10 | Ukraine | Kirovohrad Oblast | 20787 | 862 | 0 | 48.5079 | 32.2623 | 2021-08-11 04:21:58 | Kirovohrad Oblast, Ukraine | |||
3242666 | 3242666 | 2021-04-21 | US | Alabama | Baldwin | 1003 | 20787 | 302 | 0 | 30.72774991 | -87.72207058 | 2021-04-22 04:20:53 | Baldwin, Alabama, US | |
3601235 | 3601235 | 2021-02-17 | Russia | Chuvashia Republic | 20787 | 972 | 19006 | 809 | 55.4259922 | 47.0849429 | 2021-02-18 05:22:58 | Chuvashia Republic, Russia | ||
1528214 | 1528214 | 2021-02-09 | Sweden | Ostergotland | 20787 | 513 | 0 | 20274 | 58.3454 | 15.5198 | 2021-02-10 05:22:41 | Ostergotland, Sweden | ||
1632360 | 1632360 | 2020-12-05 | Latvia | 20787 | 253 | 1866 | 18668 | 56.8796 | 24.6032 | 2020-12-06 05:26:18 | Latvia | |||
3786048 | 3786048 | 2020-10-11 | Peru | Cajamarca | 20787 | 1386 | 0 | 19401 | -6.430284 | -78.74559599999998 | 2020-10-12 04:23:45 | Cajamarca, Peru |
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]);