johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 17300 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2508244 | 2508244 | 2022-11-10 | US | New Jersey | Salem | 34033 | 17300 | 258 | 0 | 39.58719656 | -75.3469663 | 2022-11-11 04:21:22 | Salem, New Jersey, US | |
850225 | 850225 | 2022-11-02 | US | Colorado | Garfield | 8045 | 17300 | 102 | 0 | 39.59921777 | -107.902708 | 2022-11-03 04:22:05 | Garfield, Colorado, US | |
1396467 | 1396467 | 2022-09-02 | US | Puerto Rico | Vega Baja | 72145 | 17300 | 0 | 0 | 18.428262 | -66.397924 | 2022-09-03 04:21:04 | Vega Baja, Puerto Rico, US | |
1949605 | 1949605 | 2022-04-12 | US | Indiana | Grant | 18053 | 17300 | 348 | 0 | 40.51587228 | -85.65468702 | 2022-04-13 04:21:03 | Grant, Indiana, US | |
3207358 | 3207358 | 2022-04-11 | US | Indiana | Grant | 18053 | 17300 | 348 | 0 | 40.51587228 | -85.65468702 | 2022-04-12 04:20:49 | Grant, Indiana, US | |
2202005 | 2202005 | 2022-03-06 | US | North Carolina | Rutherford | 37161 | 17300 | 391 | 0 | 35.40114178 | -81.92112099 | 2022-03-07 04:20:47 | Rutherford, North Carolina, US | |
2094462 | 2094462 | 2022-03-05 | US | North Carolina | Rutherford | 37161 | 17300 | 391 | 0 | 35.40114178 | -81.92112099 | 2022-03-06 04:20:49 | Rutherford, North Carolina, US | |
2668162 | 2668162 | 2022-03-04 | US | North Carolina | Rutherford | 37161 | 17300 | 391 | 0 | 35.40114178 | -81.92112099 | 2022-03-05 04:21:10 | Rutherford, North Carolina, US | |
2528306 | 2528306 | 2022-03-02 | US | Tennessee | Gibson | 47053 | 17300 | 249 | 0 | 35.99438059 | -88.93358327 | 2022-03-03 04:21:01 | Gibson, Tennessee, US | |
1235239 | 1235239 | 2021-11-28 | US | Wyoming | Laramie | 56021 | 17300 | 205 | 0 | 41.30702520000001 | -104.6887497 | 2021-11-29 04:22:30 | Laramie, Wyoming, US | |
1361946 | 1361946 | 2021-11-27 | US | Wyoming | Laramie | 56021 | 17300 | 205 | 0 | 41.30702520000001 | -104.6887497 | 2021-11-28 04:22:43 | Laramie, Wyoming, US | |
1358408 | 1358408 | 2021-11-27 | Mali | 17300 | 603 | 0 | 17.570692 | -3.996166000000001 | 2021-11-28 04:22:43 | Mali | ||||
761937 | 761937 | 2021-11-26 | US | Wyoming | Laramie | 56021 | 17300 | 205 | 0 | 41.30702520000001 | -104.6887497 | 2021-11-27 04:22:45 | Laramie, Wyoming, US | |
1806354 | 1806354 | 2021-11-25 | US | Wyoming | Laramie | 56021 | 17300 | 205 | 0 | 41.30702520000001 | -104.6887497 | 2021-11-26 04:22:33 | Laramie, Wyoming, US | |
907788 | 907788 | 2021-11-24 | US | Wyoming | Laramie | 56021 | 17300 | 205 | 0 | 41.30702520000001 | -104.6887497 | 2021-11-25 04:22:33 | Laramie, Wyoming, US | |
656271 | 656271 | 2021-10-22 | US | New York | Ulster | 36111 | 17300 | 280 | 0 | 41.89027881 | -74.26252104 | 2021-10-23 04:21:32 | Ulster, New York, US | |
3742128 | 3742128 | 2021-07-12 | US | Illinois | Tazewell | 17179 | 17300 | 307 | 0 | 40.50716185 | -89.51404662 | 2021-07-13 04:21:18 | Tazewell, Illinois, US | |
2696047 | 2696047 | 2021-07-06 | US | North Carolina | Rowan | 37159 | 17300 | 313 | 0 | 35.64003916 | -80.52446628 | 2021-07-07 04:21:20 | Rowan, North Carolina, US | |
3361660 | 3361660 | 2021-06-21 | US | Tennessee | Sullivan | 47163 | 17300 | 307 | 0 | 36.51240691 | -82.30412917 | 2021-06-22 04:21:34 | Sullivan, Tennessee, US | |
108303 | 108303 | 2021-06-19 | US | Georgia | Paulding | 13223 | 17300 | 231 | 0 | 33.91969522 | -84.86848792 | 2021-06-20 04:21:48 | Paulding, Georgia, US | |
1570777 | 1570777 | 2021-04-22 | US | Pennsylvania | Lackawanna | 42069 | 17300 | 451 | 0 | 41.43564672 | -75.60379201 | 2021-04-23 04:20:52 | Lackawanna, Pennsylvania, US | |
3886401 | 3886401 | 2021-04-11 | US | South Carolina | Florence | 45041 | 17300 | 400 | 0 | 34.02361754 | -79.70189312 | 2021-04-12 04:21:00 | Florence, South Carolina, US | |
388115 | 388115 | 2021-04-04 | France | French Guiana | 17300 | 96 | 9995 | 7209 | 4.0 | -53.0 | 2021-04-05 04:20:35 | French Guiana, France | ||
3710031 | 3710031 | 2021-04-03 | France | French Guiana | 17300 | 96 | 9995 | 7209 | 4.0 | -53.0 | 2021-04-04 04:20:49 | French Guiana, France | ||
976430 | 976430 | 2021-02-06 | US | Louisiana | Ouachita | 22073 | 17300 | 389 | 0 | 16911 | 32.47645559 | -92.15704172 | 2021-02-07 05:23:00 | Ouachita, Louisiana, US |
1589688 | 1589688 | 2021-02-05 | US | Louisiana | Ouachita | 22073 | 17300 | 389 | 0 | 16911 | 32.47645559 | -92.15704172 | 2021-02-06 05:23:55 | Ouachita, Louisiana, US |
3515602 | 3515602 | 2021-01-15 | Russia | Kabardino-Balkarian Republic | 17300 | 291 | 15822 | 1187 | 43.4806048 | 43.5978976 | 2021-01-16 05:22:40 | Kabardino-Balkarian Republic, Russia | ||
2975425 | 2975425 | 2020-12-09 | Russia | Ivanovo Oblast | 17300 | 313 | 12473 | 4514 | 56.9167446 | 41.43521370000001 | 2020-12-10 05:26:19 | Ivanovo Oblast, Russia | ||
3860081 | 3860081 | 2020-12-04 | Russia | Tula Oblast | 17300 | 502 | 15236 | 1562 | 53.9570701 | 37.3690909 | 2020-12-05 05:27:36 | Tula Oblast, Russia | ||
2498607 | 2498607 | 2020-11-03 | US | Colorado | Arapahoe | 8005 | 17300 | 428 | 0 | 14113 | 39.64977461 | -104.3353617 | 2020-11-04 05:25:09 | Arapahoe, Colorado, US |
3409827 | 3409827 | 2020-11-01 | US | Alabama | Mobile | 1097 | 17300 | 322 | 0 | 16978 | 30.78472347 | -88.20842409 | 2020-11-02 05:25:04 | Mobile, Alabama, US |
2556124 | 2556124 | 2020-06-02 | Israel | 17300 | 292 | 14821 | 2187 | 31.046051000000002 | 34.851612 | 2020-06-03 02:33:13 | Israel |
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]);