johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 31187 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3872680 | 3872680 | 2022-07-31 | US | Indiana | Monroe | 18105 | 31187 | 287 | 0 | 39.16130004 | -86.52414358 | 2022-08-01 04:21:03 | Monroe, Indiana, US | |
675434 | 675434 | 2022-07-30 | US | Indiana | Monroe | 18105 | 31187 | 287 | 0 | 39.16130004 | -86.52414358 | 2022-07-31 04:21:02 | Monroe, Indiana, US | |
1784633 | 1784633 | 2022-07-29 | US | Indiana | Monroe | 18105 | 31187 | 287 | 0 | 39.16130004 | -86.52414358 | 2022-07-30 04:20:42 | Monroe, Indiana, US | |
2789107 | 2789107 | 2022-07-10 | Mali | 31187 | 737 | 0 | 17.570692 | -3.996166 | 2022-07-11 04:20:46 | Mali | ||||
560370 | 560370 | 2022-06-16 | US | Maine | Penobscot | 23019 | 31187 | 342 | 0 | 45.40194593 | -68.65020455 | 2022-06-17 04:20:56 | Penobscot, Maine, US | |
3440061 | 3440061 | 2022-04-22 | US | Texas | Taylor | 48441 | 31187 | 720 | 0 | 32.30163422 | -99.89007449 | 2022-04-23 04:20:50 | Taylor, Texas, US | |
1846983 | 1846983 | 2022-04-18 | US | Illinois | Kendall | 17093 | 31187 | 161 | 0 | 41.59081014 | -88.42869583 | 2022-04-19 04:21:00 | Kendall, Illinois, US | |
3048705 | 3048705 | 2022-02-26 | US | Ohio | Wood | 39173 | 31187 | 353 | 0 | 41.36224827 | -83.62285108 | 2022-02-27 04:21:04 | Wood, Ohio, US | |
1114412 | 1114412 | 2022-01-11 | US | Georgia | Houston | 13153 | 31187 | 430 | 0 | 32.45802497 | -83.66879087 | 2022-01-12 04:21:44 | Houston, Georgia, US | |
3495895 | 3495895 | 2021-12-15 | Belize | 31187 | 586 | 0 | 17.1899 | -88.4976 | 2021-12-16 04:22:11 | Belize | ||||
1664700 | 1664700 | 2021-12-11 | Russia | Tyva Republic | 31187 | 314 | 0 | 51.401714899999995 | 93.8582593 | 2021-12-12 04:22:12 | Tyva Republic, Russia | |||
2646074 | 2646074 | 2021-04-08 | Sweden | Uppsala | 31187 | 503 | 0 | 30684 | 60.0092 | 17.2715 | 2021-04-09 04:21:13 | Uppsala, Sweden | ||
2485490 | 2485490 | 2021-01-28 | US | Wisconsin | Brown | 55009 | 31187 | 212 | 0 | 30975 | 44.4526553 | -88.00411844 | 2021-01-29 05:22:23 | Brown, Wisconsin, US |
2123325 | 2123325 | 2020-12-20 | Uganda | 31187 | 231 | 10469 | 20487 | 1.373333 | 32.290275 | 2020-12-21 05:27:58 | Uganda | |||
1006149 | 1006149 | 2020-12-06 | Colombia | Norte de Santander | 31187 | 1461 | 27551 | 2175 | 7.9463 | -72.8988 | 2020-12-07 05:26:14 | Norte de Santander, Colombia | ||
1196285 | 1196285 | 2020-06-17 | Switzerland | 31187 | 1805 | 28900 | 482 | 46.8182 | 8.2275 | 2020-06-18 04:33:18 | Switzerland |
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]);