johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 19713 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 16
- Liechtenstein 4
- Russia 1
- Sweden 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756401 | 2756401 | 2022-12-29 | US | West Virginia | Marion | 54049 | 19713 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-30 04:21:04 | Marion, West Virginia, US | |
2259812 | 2259812 | 2022-10-02 | Liechtenstein | 19713 | 86 | 0 | 47.14 | 9.55 | 2022-10-03 04:23:11 | Liechtenstein | ||||
2995338 | 2995338 | 2022-10-01 | Liechtenstein | 19713 | 86 | 0 | 47.14 | 9.55 | 2022-10-02 04:21:23 | Liechtenstein | ||||
853664 | 853664 | 2022-09-30 | Liechtenstein | 19713 | 86 | 0 | 47.14 | 9.55 | 2022-10-01 04:23:01 | Liechtenstein | ||||
2375590 | 2375590 | 2022-09-29 | Liechtenstein | 19713 | 86 | 0 | 47.14 | 9.55 | 2022-09-30 04:23:09 | Liechtenstein | ||||
3908565 | 3908565 | 2022-08-11 | US | California | Mendocino | 6045 | 19713 | 132 | 0 | 39.4381191 | -123.3911313 | 2022-08-12 04:20:54 | Mendocino, California, US | |
1770879 | 1770879 | 2022-07-03 | US | Wisconsin | Chippewa | 55017 | 19713 | 191 | 0 | 45.06939744 | -91.28068855 | 2022-07-04 04:20:54 | Chippewa, Wisconsin, US | |
3368865 | 3368865 | 2022-07-02 | US | Wisconsin | Chippewa | 55017 | 19713 | 191 | 0 | 45.06939744 | -91.28068855 | 2022-07-03 04:20:59 | Chippewa, Wisconsin, US | |
597194 | 597194 | 2022-07-01 | US | Wisconsin | Chippewa | 55017 | 19713 | 191 | 0 | 45.06939744 | -91.28068855 | 2022-07-02 04:21:16 | Chippewa, Wisconsin, US | |
3023984 | 3023984 | 2022-03-23 | US | Minnesota | Clay | 27027 | 19713 | 122 | 0 | 46.89289518 | -96.48761922 | 2022-03-24 04:20:43 | Clay, Minnesota, US | |
2449498 | 2449498 | 2022-02-22 | US | Puerto Rico | Caguas | 72025 | 19713 | 0 | 0 | 18.211615 | -66.050779 | 2022-02-23 04:21:09 | Caguas, Puerto Rico, US | |
234200 | 234200 | 2022-02-11 | US | Idaho | Twin Falls | 16083 | 19713 | 270 | 0 | 42.35440512 | -114.6685381 | 2022-02-12 04:21:06 | Twin Falls, Idaho, US | |
1701359 | 1701359 | 2022-01-03 | US | Illinois | LaSalle | 17099 | 19713 | 323 | 0 | 41.34426129999999 | -88.88633881 | 2022-01-04 04:22:17 | LaSalle, Illinois, US | |
3403036 | 3403036 | 2021-11-30 | US | Massachusetts | Barnstable | 25001 | 19713 | 436 | 0 | 41.72980578 | -70.28854339 | 2021-12-01 04:22:29 | Barnstable, Massachusetts, US | |
2985880 | 2985880 | 2021-04-10 | US | Oregon | Marion | 41047 | 19713 | 298 | 0 | 44.90287942 | -122.5815117 | 2021-04-11 04:20:56 | Marion, Oregon, US | |
241460 | 241460 | 2021-04-02 | Russia | Karachay-Cherkess Republic | 19713 | 71 | 18927 | 715 | 43.7368326 | 41.7267991 | 2021-04-03 04:20:44 | Karachay-Cherkess Republic, Russia | ||
282290 | 282290 | 2021-02-24 | US | Nebraska | Sarpy | 31153 | 19713 | 105 | 0 | 19608 | 41.11314181 | -96.11156432 | 2021-02-25 05:24:57 | Sarpy, Nebraska, US |
1588987 | 1588987 | 2021-02-05 | US | Georgia | Henry | 13151 | 19713 | 223 | 0 | 19490 | 33.4533428 | -84.14814659999998 | 2021-02-06 05:23:55 | Henry, Georgia, US |
2484957 | 2484957 | 2021-01-28 | US | Tennessee | Sumner | 47165 | 19713 | 250 | 0 | 18785 | 36.46824103 | -86.45917204 | 2021-01-29 05:22:23 | Sumner, Tennessee, US |
908879 | 908879 | 2021-01-19 | US | Florida | Lake | 12069 | 19713 | 378 | 0 | 19335 | 28.76202069 | -81.7125123 | 2021-01-20 05:21:54 | Lake, Florida, US |
206576 | 206576 | 2020-08-19 | Sweden | Vastra Gotaland | 19713 | 848 | 0 | 18865 | 58.2528 | 13.0596 | 2020-08-20 04:27:43 | Vastra Gotaland, Sweden | ||
3736554 | 3736554 | 2020-07-12 | US | Maryland | Prince George's | 24033 | 19713 | 712 | 0 | 19001 | 38.83070039 | -76.8496441 | 2020-07-13 04:43:04 | Prince George's, Maryland, 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]);