johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where active = 4450 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2939375 | 2939375 | 2021-05-16 | Jordan | 724154 | 9259 | 710445 | 4450 | 31.24 | 36.51 | 2021-05-17 04:20:34 | Jordan | |||
2454412 | 2454412 | 2021-05-02 | Ukraine | Zakarpattia Oblast | 60151 | 1527 | 54174 | 4450 | 48.6208 | 22.2879 | 2021-05-03 04:20:39 | Zakarpattia Oblast, Ukraine | ||
2369367 | 2369367 | 2021-02-28 | US | Missouri | Callaway | 29027 | 4493 | 43 | 0 | 4450 | 38.83674754 | -91.92186505 | 2021-03-01 05:23:01 | Callaway, Missouri, US |
184346 | 184346 | 2021-02-21 | US | North Carolina | Edgecombe | 37065 | 4549 | 99 | 0 | 4450 | 35.91230639 | -77.59436892 | 2021-02-22 05:24:21 | Edgecombe, North Carolina, US |
473756 | 473756 | 2021-02-19 | US | North Carolina | Pender | 37141 | 4503 | 53 | 0 | 4450 | 34.52265624 | -77.90352133 | 2021-02-20 05:22:51 | Pender, North Carolina, US |
2286926 | 2286926 | 2021-02-14 | US | West Virginia | Raleigh | 54081 | 4503 | 53 | 0 | 4450 | 37.76936795 | -81.2456041 | 2021-02-15 05:24:49 | Raleigh, West Virginia, US |
2680420 | 2680420 | 2021-02-13 | US | Oklahoma | Washington | 40147 | 4530 | 80 | 0 | 4450 | 36.71380786 | -95.90514104 | 2021-02-14 05:23:43 | Washington, Oklahoma, US |
2639308 | 2639308 | 2021-02-11 | US | Massachusetts | Berkshire | 25003 | 4689 | 221 | 0 | 4450 | 42.37428441 | -73.20524838 | 2021-02-12 05:23:29 | Berkshire, Massachusetts, US |
2481912 | 2481912 | 2021-01-28 | India | Chhattisgarh | 304319 | 3682 | 296187 | 4450 | 21.264705 | 82.035366 | 2021-01-29 05:22:23 | Chhattisgarh, India | ||
2430461 | 2430461 | 2021-01-23 | US | Wisconsin | Oconto | 55083 | 4501 | 51 | 0 | 4450 | 45.02715345 | -88.26807503 | 2021-01-24 05:22:35 | Oconto, Wisconsin, US |
193690 | 193690 | 2021-01-11 | Ukraine | Khmelnytskyi Oblast | 41275 | 706 | 36119 | 4450 | 49.423 | 26.9871 | 2021-01-12 05:22:15 | Khmelnytskyi Oblast, Ukraine | ||
1012461 | 1012461 | 2020-12-30 | US | New Jersey | Cape May | 34009 | 4584 | 134 | 0 | 4450 | 39.15008829 | -74.80170244 | 2020-12-31 05:22:49 | Cape May, New Jersey, US |
3780152 | 3780152 | 2020-12-27 | US | New York | Putnam | 36079 | 4516 | 66 | 0 | 4450 | 41.42630093 | -73.74965532 | 2020-12-28 05:22:06 | Putnam, New York, US |
3770926 | 3770926 | 2020-12-22 | US | Illinois | Whiteside | 17195 | 4569 | 119 | 0 | 4450 | 41.75509713 | -89.91556058 | 2020-12-23 05:22:03 | Whiteside, Illinois, US |
929900 | 929900 | 2020-12-21 | US | New Mexico | Valencia | 35061 | 4502 | 52 | 0 | 4450 | 34.71669834 | -106.8103733 | 2020-12-22 05:22:33 | Valencia, New Mexico, US |
2123135 | 2123135 | 2020-12-20 | US | Washington | Chelan | 53007 | 4483 | 33 | 0 | 4450 | 47.87046092 | -120.6173956 | 2020-12-21 05:27:58 | Chelan, Washington, US |
2934642 | 2934642 | 2020-12-19 | US | Washington | Chelan | 53007 | 4483 | 33 | 0 | 4450 | 47.87046092 | -120.6173956 | 2020-12-20 05:27:32 | Chelan, Washington, US |
2933708 | 2933708 | 2020-12-19 | US | Ohio | Muskingum | 39119 | 4514 | 64 | 0 | 4450 | 39.96575964 | -81.94363275 | 2020-12-20 05:27:32 | Muskingum, Ohio, US |
2935483 | 2935483 | 2020-11-28 | Russia | Tver Oblast | 14727 | 378 | 9899 | 4450 | 57.1134475 | 35.174442799999994 | 2020-11-29 05:25:55 | Tver Oblast, Russia | ||
1990788 | 1990788 | 2020-11-09 | US | New Jersey | Cumberland | 34011 | 4613 | 163 | 0 | 4450 | 39.37199394 | -75.10712559 | 2020-11-10 05:40:07 | Cumberland, New Jersey, US |
2919426 | 2919426 | 2020-11-04 | Russia | Stavropol Krai | 22079 | 442 | 17187 | 4450 | 44.86325770000001 | 43.4406913 | 2020-11-05 06:05:03 | Stavropol Krai, Russia | ||
2243748 | 2243748 | 2020-10-30 | US | Alabama | Etowah | 1055 | 4503 | 53 | 0 | 4450 | 34.04567266 | -86.04051873 | 2020-10-31 04:24:44 | Etowah, Alabama, US |
2690879 | 2690879 | 2020-10-08 | US | Iowa | Linn | 19113 | 4567 | 117 | 0 | 4450 | 42.07923082 | -91.59809485 | 2020-10-09 04:23:59 | Linn, Iowa, US |
3803418 | 3803418 | 2020-10-05 | US | Louisiana | Tangipahoa | 22105 | 4570 | 120 | 0 | 4450 | 30.62888673 | -90.40664996 | 2020-10-06 04:23:33 | Tangipahoa, Louisiana, US |
2868417 | 2868417 | 2020-09-13 | Albania | 11353 | 334 | 6569 | 4450 | 41.1533 | 20.1683 | 2020-09-14 04:26:00 | Albania | |||
547991 | 547991 | 2020-09-12 | US | Iowa | Woodbury | 19193 | 4508 | 58 | 0 | 4450 | 42.38979414 | -96.0459439 | 2020-09-13 04:30:52 | Woodbury, Iowa, US |
3181512 | 3181512 | 2020-08-18 | US | Wisconsin | Brown | 55009 | 4505 | 55 | 0 | 4450 | 44.4526553 | -88.00411844 | 2020-08-19 04:27:00 | Brown, Wisconsin, US |
841116 | 841116 | 2020-08-17 | US | Wisconsin | Brown | 55009 | 4505 | 55 | 0 | 4450 | 44.4526553 | -88.00411844 | 2020-08-18 04:27:56 | Brown, Wisconsin, US |
1559472 | 1559472 | 2020-08-16 | US | Wisconsin | Brown | 55009 | 4505 | 55 | 0 | 4450 | 44.4526553 | -88.00411844 | 2020-08-17 04:27:20 | Brown, Wisconsin, US |
2804958 | 2804958 | 2020-08-02 | US | Pennsylvania | Chester | 42029 | 4801 | 351 | 0 | 4450 | 39.97291773 | -75.74768357 | 2020-08-03 04:34:35 | Chester, Pennsylvania, US |
3182165 | 3182165 | 2020-07-28 | US | Georgia | Chatham | 13051 | 4505 | 55 | 0 | 4450 | 32.00043026 | -81.12489526 | 2020-07-29 04:35:11 | Chatham, Georgia, US |
3735801 | 3735801 | 2020-07-12 | US | Pennsylvania | Lancaster | 42071 | 4833 | 383 | 0 | 4450 | 40.03904563 | -76.24770128 | 2020-07-13 04:43:04 | Lancaster, Pennsylvania, US |
2632234 | 2632234 | 2020-06-29 | US | Delaware | Sussex | 10005 | 4637 | 187 | 0 | 4450 | 38.66143781 | -75.39031349 | 2020-06-30 04:33:48 | Sussex, Delaware, 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]);