johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where confirmed = 20309 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2026328 | 2026328 | 2022-10-17 | US | Maryland | Allegany | 24001 | 20309 | 378 | 0 | 39.62357628 | -78.69280486 | 2022-10-18 04:22:42 | Allegany, Maryland, US | |
1625026 | 1625026 | 2022-09-22 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-23 04:23:13 | Putnam, Florida, US | |
1371230 | 1371230 | 2022-09-21 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-22 04:22:56 | Putnam, Florida, US | |
2019726 | 2019726 | 2022-09-20 | US | Tennessee | Tipton | 47167 | 20309 | 244 | 0 | 35.501942 | -89.73694895 | 2022-09-21 04:23:22 | Tipton, Tennessee, US | |
2017460 | 2017460 | 2022-09-20 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-21 04:23:22 | Putnam, Florida, US | |
3571333 | 3571333 | 2022-09-19 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-20 04:22:48 | Putnam, Florida, US | |
420072 | 420072 | 2022-09-18 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-19 04:21:49 | Putnam, Florida, US | |
3374096 | 3374096 | 2022-09-17 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-18 04:22:50 | Putnam, Florida, US | |
2356204 | 2356204 | 2022-09-16 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-17 04:20:19 | Putnam, Florida, US | |
3987361 | 3987361 | 2022-09-15 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-16 04:21:19 | Putnam, Florida, US | |
1889878 | 1889878 | 2022-09-14 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-15 04:21:02 | Putnam, Florida, US | |
372933 | 372933 | 2022-09-13 | US | Florida | Putnam | 12107 | 20309 | 444 | 0 | 29.60779729 | -81.74230285 | 2022-09-14 04:20:44 | Putnam, Florida, US | |
2395535 | 2395535 | 2022-09-12 | US | Florida | Putnam | 12107 | 20309 | 441 | 0 | 29.60779729 | -81.74230285 | 2022-09-13 04:20:57 | Putnam, Florida, US | |
3766613 | 3766613 | 2022-09-11 | US | Florida | Putnam | 12107 | 20309 | 441 | 0 | 29.60779729 | -81.74230285 | 2022-09-12 04:20:58 | Putnam, Florida, US | |
3825188 | 3825188 | 2022-09-10 | US | Florida | Putnam | 12107 | 20309 | 441 | 0 | 29.60779729 | -81.74230285 | 2022-09-11 04:20:50 | Putnam, Florida, US | |
963645 | 963645 | 2022-09-09 | US | Florida | Putnam | 12107 | 20309 | 441 | 0 | 29.60779729 | -81.74230285 | 2022-09-10 04:21:10 | Putnam, Florida, US | |
1098529 | 1098529 | 2022-08-03 | US | Alabama | Walker | 1127 | 20309 | 453 | 0 | 33.80270512 | -87.30027177 | 2022-08-04 04:20:58 | Walker, Alabama, US | |
1405454 | 1405454 | 2022-08-02 | US | Alabama | Walker | 1127 | 20309 | 453 | 0 | 33.80270512 | -87.30027177 | 2022-08-03 04:20:59 | Walker, Alabama, US | |
3617492 | 3617492 | 2022-08-01 | US | Alabama | Walker | 1127 | 20309 | 453 | 0 | 33.80270512 | -87.30027177 | 2022-08-02 04:20:53 | Walker, Alabama, US | |
3871972 | 3871972 | 2022-07-31 | US | Alabama | Walker | 1127 | 20309 | 453 | 0 | 33.80270512 | -87.30027177 | 2022-08-01 04:21:03 | Walker, Alabama, US | |
674726 | 674726 | 2022-07-30 | US | Alabama | Walker | 1127 | 20309 | 453 | 0 | 33.80270512 | -87.30027177 | 2022-07-31 04:21:02 | Walker, Alabama, US | |
1783925 | 1783925 | 2022-07-29 | US | Alabama | Walker | 1127 | 20309 | 453 | 0 | 33.80270512 | -87.30027177 | 2022-07-30 04:20:42 | Walker, Alabama, US | |
2083983 | 2083983 | 2022-05-15 | Japan | Tokushima | 20309 | 80 | 0 | 33.919178 | 134.242091 | 2022-05-16 04:20:47 | Tokushima, Japan | |||
3719143 | 3719143 | 2022-02-21 | US | Idaho | Twin Falls | 16083 | 20309 | 278 | 0 | 42.35440512 | -114.6685381 | 2022-02-22 04:21:01 | Twin Falls, Idaho, US | |
3912977 | 3912977 | 2022-02-20 | US | Idaho | Twin Falls | 16083 | 20309 | 278 | 0 | 42.35440512 | -114.6685381 | 2022-02-21 04:21:05 | Twin Falls, Idaho, US | |
3876535 | 3876535 | 2022-02-19 | US | Idaho | Twin Falls | 16083 | 20309 | 278 | 0 | 42.35440512 | -114.6685381 | 2022-02-20 04:21:00 | Twin Falls, Idaho, US | |
462654 | 462654 | 2022-02-02 | US | Utah | Tooele | 49045 | 20309 | 88 | 0 | 40.44862644 | -113.12957150000001 | 2022-02-03 04:21:21 | Tooele, Utah, US | |
3467162 | 3467162 | 2022-01-18 | US | Tennessee | Putnam | 47141 | 20309 | 270 | 0 | 36.14005459 | -85.50646123 | 2022-01-19 04:21:23 | Putnam, Tennessee, US | |
3124708 | 3124708 | 2021-11-05 | US | Texas | Randall | 48381 | 20309 | 360 | 0 | 34.96585996 | -101.8971322 | 2021-11-06 04:21:51 | Randall, Texas, US | |
3013800 | 3013800 | 2021-09-22 | US | Ohio | Greene | 39057 | 20309 | 294 | 0 | 39.69116283 | -83.89032084 | 2021-09-23 04:21:43 | Greene, Ohio, US | |
33540 | 33540 | 2021-08-25 | US | Indiana | Porter | 18127 | 20309 | 331 | 0 | 41.45986947 | -87.06848888 | 2021-08-26 04:21:28 | Porter, Indiana, US | |
3218251 | 3218251 | 2021-07-26 | India | Ladakh | 20309 | 207 | 20032 | 70 | 34.1526 | 77.5771 | 2021-07-27 04:21:18 | Ladakh, India | ||
2207750 | 2207750 | 2021-03-04 | Mexico | Quintana Roo | 20309 | 2411 | 0 | 17898 | 19.1817 | -88.4791 | 2021-03-05 05:26:29 | Quintana Roo, Mexico | ||
3978771 | 3978771 | 2021-02-10 | Russia | Chuvashia Republic | 20309 | 935 | 18457 | 917 | 55.4259922 | 47.0849429 | 2021-02-11 05:23:55 | Chuvashia Republic, Russia | ||
1094631 | 1094631 | 2021-01-20 | US | California | Kings | 6031 | 20309 | 146 | 0 | 20244 | 36.07409056 | -119.8159973 | 2021-01-21 05:22:01 | Kings, California, US |
1094332 | 1094332 | 2021-01-20 | Russia | Smolensk Oblast | 20309 | 403 | 16484 | 3422 | 55.03434960000001 | 33.0192065 | 2021-01-21 05:22:01 | Smolensk Oblast, Russia | ||
2665203 | 2665203 | 2020-09-04 | US | Washington | King | 53033 | 20309 | 731 | 0 | 19578 | 47.49137892 | -121.8346131 | 2020-09-05 04:28:19 | King, Washington, US |
442824 | 442824 | 2020-07-26 | Austria | 20309 | 842 | 18209 | 1551 | 47.5162 | 14.5501 | 2020-07-27 04:35:02 | Austria |
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]);