johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 18017 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 14
- Colombia 1
- Netherlands 1
- Russia 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2180193 | 2180193 | 2022-12-22 | US | Colorado | Broomfield | 8014 | 18017 | 128 | 0 | 39.95998787 | -105.0566324 | 2022-12-23 04:21:04 | Broomfield, Colorado, US | |
2011616 | 2011616 | 2022-08-04 | US | Tennessee | Carter | 47019 | 18017 | 344 | 0 | 36.28969086 | -82.12588974 | 2022-08-05 04:20:52 | Carter, Tennessee, US | |
1543115 | 1543115 | 2022-03-31 | US | Texas | Liberty | 48291 | 18017 | 402 | 0 | 30.15152688 | -94.81205615 | 2022-04-01 04:20:28 | Liberty, Texas, US | |
186940 | 186940 | 2022-02-13 | US | Georgia | Rockdale | 13247 | 18017 | 296 | 0 | 33.65145002 | -84.02202167 | 2022-02-14 04:20:51 | Rockdale, Georgia, US | |
316786 | 316786 | 2022-02-12 | US | Georgia | Rockdale | 13247 | 18017 | 296 | 0 | 33.65145002 | -84.02202167 | 2022-02-13 04:21:00 | Rockdale, Georgia, US | |
234112 | 234112 | 2022-02-11 | US | Georgia | Rockdale | 13247 | 18017 | 296 | 0 | 33.65145002 | -84.02202167 | 2022-02-12 04:21:06 | Rockdale, Georgia, US | |
1033174 | 1033174 | 2021-12-06 | US | Rhode Island | Unassigned | 90044 | 18017 | 34 | 0 | 41.87064746 | 0.0 | 2021-12-07 04:22:34 | Unassigned, Rhode Island, US | |
688539 | 688539 | 2021-11-13 | US | New Jersey | Sussex | 34037 | 18017 | 346 | 0 | 41.13891592 | -74.69118243 | 2021-11-14 04:21:31 | Sussex, New Jersey, US | |
2810416 | 2810416 | 2021-09-16 | US | Michigan | Muskegon | 26121 | 18017 | 384 | 0 | 43.29123859 | -86.15176712 | 2021-09-17 04:21:46 | Muskegon, Michigan, US | |
1376160 | 1376160 | 2021-09-15 | US | Michigan | Muskegon | 26121 | 18017 | 384 | 0 | 43.29123859 | -86.15176712 | 2021-09-16 04:22:19 | Muskegon, Michigan, US | |
22130 | 22130 | 2021-05-28 | US | Minnesota | St. Louis | 27137 | 18017 | 307 | 0 | 47.6048407 | -92.46879855 | 2021-05-29 04:20:41 | St. Louis, Minnesota, US | |
2257532 | 2257532 | 2021-05-19 | US | Mississippi | Harrison | 28047 | 18017 | 310 | 0 | 30.51359752 | -89.12467576 | 2021-05-20 04:21:05 | Harrison, Mississippi, US | |
1639944 | 1639944 | 2021-04-29 | Ukraine | Kirovohrad Oblast | 18017 | 645 | 10788 | 6584 | 48.5079 | 32.2623 | 2021-04-30 04:21:03 | Kirovohrad Oblast, Ukraine | ||
2573193 | 2573193 | 2021-04-13 | US | Louisiana | Ouachita | 22073 | 18017 | 442 | 0 | 32.47645559 | -92.15704172 | 2021-04-14 04:20:41 | Ouachita, Louisiana, US | |
2207876 | 2207876 | 2021-03-04 | Russia | Mordovia Republic | 18017 | 164 | 15988 | 1865 | 54.4419829 | 44.4661144 | 2021-03-05 05:26:29 | Mordovia Republic, Russia | ||
2226591 | 2226591 | 2020-12-26 | US | Texas | Galveston | 48167 | 18017 | 211 | 0 | 19595 | 29.40167322 | -94.90469073 | 2020-12-27 05:22:55 | Galveston, Texas, US |
376304 | 376304 | 2020-11-06 | Netherlands | Limburg | 18017 | 818 | 0 | 17132 | 51.209227 | 5.93387 | 2020-11-07 05:24:52 | Limburg, Netherlands | ||
3304055 | 3304055 | 2020-11-02 | Colombia | Sucre | 18017 | 616 | 14415 | 2986 | 8.814 | -74.7233 | 2020-11-03 06:00:16 | Sucre, Colombia |
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]);