johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where confirmed = 22286 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
992589 | 992589 | 2022-08-16 | US | Maryland | Wicomico | 24045 | 22286 | 341 | 0 | 38.37301947 | -75.62705831 | 2022-08-17 04:20:59 | Wicomico, Maryland, US | |
3582031 | 3582031 | 2022-06-02 | US | Virginia | Roanoke City | 51770 | 22286 | 376 | 0 | 37.27791025 | -79.96189766 | 2022-06-03 04:20:58 | Roanoke City, Virginia, US | |
1159321 | 1159321 | 2022-04-29 | US | New Jersey | Cape May | 34009 | 22286 | 303 | 0 | 39.15008829 | -74.80170244 | 2022-04-30 04:21:05 | Cape May, New Jersey, US | |
1699249 | 1699249 | 2022-04-28 | US | Tennessee | Anderson | 47001 | 22286 | 334 | 0 | 36.12684348 | -84.19965764 | 2022-04-29 04:20:59 | Anderson, Tennessee, US | |
3730639 | 3730639 | 2022-04-03 | US | Alabama | Talladega | 1121 | 22286 | 372 | 0 | 33.37823223 | -86.16886178 | 2022-04-04 04:20:51 | Talladega, Alabama, US | |
500074 | 500074 | 2022-04-02 | US | Alabama | Talladega | 1121 | 22286 | 372 | 0 | 33.37823223 | -86.16886178 | 2022-04-03 04:20:48 | Talladega, Alabama, US | |
1468796 | 1468796 | 2022-03-24 | US | Florida | Flagler | 12035 | 22286 | 350 | 0 | 29.45933576 | -81.31508595 | 2022-03-25 04:20:46 | Flagler, Florida, US | |
3022970 | 3022970 | 2022-03-23 | US | Florida | Flagler | 12035 | 22286 | 350 | 0 | 29.45933576 | -81.31508595 | 2022-03-24 04:20:43 | Flagler, Florida, US | |
1905892 | 1905892 | 2022-03-22 | US | Florida | Flagler | 12035 | 22286 | 350 | 0 | 29.45933576 | -81.31508595 | 2022-03-23 04:20:48 | Flagler, Florida, US | |
3239023 | 3239023 | 2022-03-21 | US | Florida | Flagler | 12035 | 22286 | 341 | 0 | 29.45933576 | -81.31508595 | 2022-03-22 04:20:54 | Flagler, Florida, US | |
25096 | 25096 | 2022-03-20 | US | Florida | Flagler | 12035 | 22286 | 341 | 0 | 29.45933576 | -81.31508595 | 2022-03-21 04:20:50 | Flagler, Florida, US | |
1657106 | 1657106 | 2022-03-19 | US | Florida | Flagler | 12035 | 22286 | 341 | 0 | 29.45933576 | -81.31508595 | 2022-03-20 04:20:45 | Flagler, Florida, US | |
336632 | 336632 | 2022-03-18 | US | Florida | Flagler | 12035 | 22286 | 341 | 0 | 29.45933576 | -81.31508595 | 2022-03-19 04:20:47 | Flagler, Florida, US | |
695085 | 695085 | 2022-03-17 | US | Florida | Flagler | 12035 | 22286 | 311 | 0 | 29.45933576 | -81.31508595 | 2022-03-18 04:20:55 | Flagler, Florida, US | |
2320028 | 2320028 | 2022-03-16 | US | Florida | Flagler | 12035 | 22286 | 341 | 0 | 29.45933576 | -81.31508595 | 2022-03-17 04:20:56 | Flagler, Florida, US | |
262228 | 262228 | 2022-03-15 | US | Florida | Flagler | 12035 | 22286 | 341 | 0 | 29.45933576 | -81.31508595 | 2022-03-16 04:20:50 | Flagler, Florida, US | |
2264587 | 2264587 | 2022-03-14 | US | Florida | Flagler | 12035 | 22286 | 341 | 0 | 29.45933576 | -81.31508595 | 2022-03-15 04:20:47 | Flagler, Florida, US | |
3628653 | 3628653 | 2022-03-13 | US | Florida | Flagler | 12035 | 22286 | 311 | 0 | 29.45933576 | -81.31508595 | 2022-03-14 04:20:46 | Flagler, Florida, US | |
951561 | 951561 | 2022-03-12 | US | Florida | Flagler | 12035 | 22286 | 311 | 0 | 29.45933576 | -81.31508595 | 2022-03-13 04:20:49 | Flagler, Florida, US | |
357022 | 357022 | 2022-03-11 | US | Florida | Flagler | 12035 | 22286 | 311 | 0 | 29.45933576 | -81.31508595 | 2022-03-12 04:20:50 | Flagler, Florida, US | |
278855 | 278855 | 2021-11-03 | US | Pennsylvania | Franklin | 42055 | 22286 | 465 | 0 | 39.92956518 | -77.72157791 | 2021-11-04 04:22:20 | Franklin, Pennsylvania, US | |
3958758 | 3958758 | 2021-06-26 | Russia | Tatarstan Republic | 22286 | 534 | 20069 | 1683 | 55.7648572 | 52.43104273 | 2021-06-27 04:21:39 | Tatarstan Republic, Russia | ||
3474779 | 3474779 | 2021-06-08 | US | Ohio | Mahoning | 39099 | 22286 | 615 | 0 | 41.01631101 | -80.77287029 | 2021-06-09 04:23:31 | Mahoning, Ohio, US | |
1802199 | 1802199 | 2021-03-23 | US | Wisconsin | Outagamie | 55087 | 22286 | 212 | 0 | 44.41578887 | -88.46565023 | 2021-03-24 05:25:40 | Outagamie, Wisconsin, US | |
1207367 | 1207367 | 2021-03-22 | US | Wisconsin | Outagamie | 55087 | 22286 | 212 | 0 | 44.41578887 | -88.46565023 | 2021-03-23 05:26:18 | Outagamie, Wisconsin, US | |
2638266 | 2638266 | 2021-02-11 | US | California | Kings | 6031 | 22286 | 202 | 0 | 22183 | 36.07409056 | -119.8159973 | 2021-02-12 05:23:29 | Kings, California, US |
2427160 | 2427160 | 2021-01-23 | Russia | Vladimir Oblast | 22286 | 629 | 19577 | 2080 | 56.0503336 | 40.6561633 | 2021-01-24 05:22:35 | Vladimir Oblast, Russia | ||
3433168 | 3433168 | 2020-07-11 | US | Nevada | Clark | 32003 | 22286 | 483 | 0 | 21803 | 36.21458855 | -115.0130241 | 2020-07-12 04:34:30 | Clark, Nevada, 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]);