johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 18613 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 9
- Angola 1
- Denmark 1
- Japan 1
- Mauritania 1
- Nepal 1
- Netherlands 1
- Peru 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2377740 | 2377740 | 2022-09-29 | US | New Mexico | Eddy | 35015 | 18613 | 313 | 0 | 32.47167456 | -104.3053527 | 2022-09-30 04:23:09 | Eddy, New Mexico, US | |
3355166 | 3355166 | 2022-05-14 | US | Arkansas | Jefferson | 5069 | 18613 | 277 | 0 | 34.26767081 | -91.92619839 | 2022-05-15 04:20:53 | Jefferson, Arkansas, US | |
3323618 | 3323618 | 2022-04-07 | US | Virginia | Montgomery | 51121 | 18613 | 149 | 0 | 37.17746986 | -80.37868691 | 2022-04-08 04:20:48 | Montgomery, Virginia, US | |
187780 | 187780 | 2022-02-13 | US | Minnesota | Clay | 27027 | 18613 | 117 | 0 | 46.89289518 | -96.48761922 | 2022-02-14 04:20:51 | Clay, Minnesota, US | |
317626 | 317626 | 2022-02-12 | US | Minnesota | Clay | 27027 | 18613 | 117 | 0 | 46.89289518 | -96.48761922 | 2022-02-13 04:21:00 | Clay, Minnesota, US | |
234952 | 234952 | 2022-02-11 | US | Minnesota | Clay | 27027 | 18613 | 117 | 0 | 46.89289518 | -96.48761922 | 2022-02-12 04:21:06 | Clay, Minnesota, US | |
3061858 | 3061858 | 2022-01-29 | Denmark | Faroe Islands | 18613 | 18 | 0 | 61.8926 | -6.9118 | 2022-01-30 04:21:26 | Faroe Islands, Denmark | |||
2051890 | 2051890 | 2022-01-25 | Japan | Miyagi | 18613 | 118 | 0 | 38.446859 | 140.927086 | 2022-01-26 04:21:07 | Miyagi, Japan | |||
731582 | 731582 | 2021-12-27 | US | Illinois | Vermilion | 17183 | 18613 | 237 | 0 | 40.18417171 | -87.73384359 | 2021-12-28 04:21:47 | Vermilion, Illinois, US | |
1815256 | 1815256 | 2021-09-19 | US | Arkansas | Faulkner | 5045 | 18613 | 202 | 0 | 35.14719007 | -92.33717519 | 2021-09-20 04:21:22 | Faulkner, Arkansas, US | |
2176076 | 2176076 | 2021-08-22 | US | Arkansas | Sebastian | 5131 | 18613 | 303 | 0 | 35.19605503 | -94.27162713 | 2021-08-23 04:21:27 | Sebastian, Arkansas, US | |
2502101 | 2502101 | 2021-05-07 | Mauritania | 18613 | 456 | 17847 | 310 | 21.0079 | -10.9408 | 2021-05-08 04:21:04 | Mauritania | |||
1676590 | 1676590 | 2021-02-01 | Netherlands | Drenthe | 18613 | 243 | 0 | 18347 | 52.862485 | 6.618435000000002 | 2021-02-02 05:22:49 | Drenthe, Netherlands | ||
3879268 | 3879268 | 2021-01-14 | Angola | 18613 | 425 | 16008 | 2180 | -11.2027 | 17.8739 | 2021-01-15 05:22:24 | Angola | |||
1632472 | 1632472 | 2020-12-05 | Peru | Puno | 18613 | 1466 | 0 | 17147 | -14.995826999999998 | -69.922726 | 2020-12-06 05:26:18 | Puno, Peru | ||
1057454 | 1057454 | 2020-10-23 | Ukraine | Ternopil Oblast | 18613 | 237 | 13574 | 4802 | 49.5535 | 25.5948 | 2020-10-24 04:24:46 | Ternopil Oblast, Ukraine | ||
442925 | 442925 | 2020-07-26 | Nepal | 18613 | 45 | 13128 | 5440 | 28.1667 | 84.25 | 2020-07-27 04:35:02 | Nepal |
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]);