johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
22 rows where confirmed = 22384 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2346373 | 2346373 | 2022-08-31 | US | Tennessee | Hamblen | 47063 | 22384 | 376 | 0 | 36.21990035 | -83.26586179 | 2022-09-01 04:21:03 | Hamblen, Tennessee, US | |
961085 | 961085 | 2022-07-19 | US | New Mexico | Chaves | 35005 | 22384 | 346 | 0 | 33.36406072 | -104.4665365 | 2022-07-20 04:20:59 | Chaves, New Mexico, US | |
2242793 | 2242793 | 2022-06-28 | US | Virginia | Portsmouth | 51740 | 22384 | 338 | 0 | 36.85914825 | -76.35971629 | 2022-06-29 04:20:59 | Portsmouth, Virginia, US | |
3888156 | 3888156 | 2022-06-06 | US | Arkansas | White | 5145 | 22384 | 297 | 0 | 35.25688493 | -91.74908296 | 2022-06-07 04:21:08 | White, Arkansas, US | |
1574862 | 1574862 | 2022-05-03 | US | Puerto Rico | Caguas | 72025 | 22384 | 0 | 0 | 18.211615 | -66.050779 | 2022-05-04 04:20:59 | Caguas, Puerto Rico, US | |
2141557 | 2141557 | 2022-03-09 | US | Kentucky | Campbell | 21037 | 22384 | 153 | 0 | 38.94384345 | -84.37875208 | 2022-03-10 04:20:48 | Campbell, Kentucky, US | |
921068 | 921068 | 2022-03-08 | US | Kentucky | Campbell | 21037 | 22384 | 153 | 0 | 38.94384345 | -84.37875208 | 2022-03-09 04:20:59 | Campbell, Kentucky, US | |
1549355 | 1549355 | 2022-03-07 | US | Kentucky | Campbell | 21037 | 22384 | 153 | 0 | 38.94384345 | -84.37875208 | 2022-03-08 04:20:54 | Campbell, Kentucky, US | |
2201024 | 2201024 | 2022-03-06 | US | Kentucky | Campbell | 21037 | 22384 | 153 | 0 | 38.94384345 | -84.37875208 | 2022-03-07 04:20:47 | Campbell, Kentucky, US | |
2093481 | 2093481 | 2022-03-05 | US | Kentucky | Campbell | 21037 | 22384 | 153 | 0 | 38.94384345 | -84.37875208 | 2022-03-06 04:20:49 | Campbell, Kentucky, US | |
2667181 | 2667181 | 2022-03-04 | US | Kentucky | Campbell | 21037 | 22384 | 153 | 0 | 38.94384345 | -84.37875208 | 2022-03-05 04:21:10 | Campbell, Kentucky, US | |
2833209 | 2833209 | 2022-01-22 | US | Alabama | Houston | 1069 | 22384 | 444 | 0 | 31.15197924 | -85.29939599 | 2022-01-23 04:21:13 | Houston, Alabama, US | |
689276 | 689276 | 2021-11-13 | US | Tennessee | Bradley | 47011 | 22384 | 202 | 0 | 35.15739424 | -84.857186 | 2021-11-14 04:21:31 | Bradley, Tennessee, US | |
1777229 | 1777229 | 2021-08-30 | US | Missouri | Boone | 29019 | 22384 | 114 | 0 | 38.99186229 | -92.30723575 | 2021-08-31 04:21:46 | Boone, Missouri, US | |
2352403 | 2352403 | 2021-08-10 | US | Illinois | Champaign | 17019 | 22384 | 161 | 0 | 40.13919438 | -88.20046615 | 2021-08-11 04:21:58 | Champaign, Illinois, US | |
653282 | 653282 | 2021-08-09 | US | Virginia | Chesapeake | 51550 | 22384 | 311 | 0 | 36.67670048 | -76.30545744 | 2021-08-10 04:21:27 | Chesapeake, Virginia, US | |
649806 | 649806 | 2021-08-09 | Colombia | Caqueta | 22384 | 893 | 0 | 0.8699 | -73.8419 | 2021-08-10 04:21:27 | Caqueta, Colombia | |||
1415301 | 1415301 | 2021-05-24 | US | New York | Oneida | 36065 | 22384 | 509 | 0 | 43.24375382 | -75.43710392 | 2021-05-25 04:21:08 | Oneida, New York, US | |
1204001 | 1204001 | 2021-03-22 | Russia | Chuvashia Republic | 22384 | 1160 | 20441 | 783 | 55.4259922 | 47.0849429 | 2021-03-23 05:26:18 | Chuvashia Republic, Russia | ||
3848239 | 3848239 | 2020-12-13 | US | Arizona | Yuma | 4027 | 22384 | 423 | 0 | 21961 | 32.76895712 | -113.90666740000002 | 2020-12-14 05:26:27 | Yuma, Arizona, US |
2347207 | 2347207 | 2020-12-07 | Chile | Antofagasta | 22384 | 567 | 21633 | 184 | -23.6509 | -70.3975 | 2020-12-08 05:27:42 | Antofagasta, Chile | ||
678204 | 678204 | 2020-11-23 | Finland | 22384 | 408 | 15300 | 6252 | 61.92411 | 25.748151 | 2020-11-24 05:27:31 | Finland |
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]);