johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where active = 4896 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2422888 | 2422888 | 2021-06-23 | Italy | Veneto | 425162 | 11611 | 408655 | 4896 | 45.43490485 | 12.33845213 | 2021-06-24 04:21:55 | Veneto, Italy | ||
1845629 | 1845629 | 2021-04-14 | Malaysia | Selangor | 121360 | 350 | 116114 | 4896 | 3.0738 | 101.5183 | 2021-04-15 04:20:54 | Selangor, Malaysia | ||
241548 | 241548 | 2021-04-02 | Spain | Ceuta | 5155 | 96 | 163 | 4896 | 35.8894 | -5.3213 | 2021-04-03 04:20:44 | Ceuta, Spain | ||
1302345 | 1302345 | 2021-04-01 | Spain | Ceuta | 5155 | 96 | 163 | 4896 | 35.8894 | -5.3213 | 2021-04-02 04:20:36 | Ceuta, Spain | ||
3256728 | 3256728 | 2021-03-02 | US | Oklahoma | Pontotoc | 40123 | 4944 | 48 | 0 | 4896 | 34.72959848 | -96.68337199 | 2021-03-03 05:23:28 | Pontotoc, Oklahoma, US |
1860453 | 1860453 | 2021-02-25 | US | Ohio | Darke | 39037 | 5016 | 120 | 0 | 4896 | 40.13412966 | -84.6194517 | 2021-02-26 05:22:40 | Darke, Ohio, US |
1936662 | 1936662 | 2021-02-23 | Russia | Kirov Oblast | 35857 | 289 | 30672 | 4896 | 57.9665589 | 49.4074599 | 2021-02-24 05:29:16 | Kirov Oblast, Russia | ||
745577 | 745577 | 2021-02-20 | US | Utah | Summit | 49043 | 4904 | 8 | 0 | 4896 | 40.86688146 | -110.9535882 | 2021-02-21 05:24:33 | Summit, Utah, US |
3051415 | 3051415 | 2021-02-16 | US | Iowa | Warren | 19181 | 4965 | 69 | 0 | 4896 | 41.33559454 | -93.56007641 | 2021-02-17 05:23:10 | Warren, Iowa, US |
616716 | 616716 | 2021-02-08 | US | Texas | Caldwell | 48055 | 5429 | 68 | 0 | 4896 | 29.83668859 | -97.61814775 | 2021-02-09 05:23:30 | Caldwell, Texas, US |
342601 | 342601 | 2021-02-03 | US | North Carolina | Lee | 37105 | 4954 | 58 | 0 | 4896 | 35.47623147 | -79.17569362 | 2021-02-04 05:22:26 | Lee, North Carolina, US |
2215240 | 2215240 | 2021-01-30 | US | Wisconsin | Shawano | 55115 | 4976 | 80 | 0 | 4896 | 44.78902246 | -88.76443896 | 2021-01-31 05:22:42 | Shawano, Wisconsin, US |
2567606 | 2567606 | 2021-01-25 | India | Chhattisgarh | 297108 | 3630 | 288582 | 4896 | 21.264705 | 82.035366 | 2021-01-26 05:22:02 | Chhattisgarh, India | ||
3102003 | 3102003 | 2021-01-16 | US | California | San Benito | 6069 | 4926 | 35 | 0 | 4896 | 36.60308176 | -121.069975 | 2021-01-17 05:22:17 | San Benito, California, US |
3882917 | 3882917 | 2021-01-14 | US | Virginia | Harrisonburg | 51660 | 4946 | 50 | 0 | 4896 | 38.43542574 | -78.87536254 | 2021-01-15 05:22:24 | Harrisonburg, Virginia, US |
2228232 | 2228232 | 2021-01-02 | US | Florida | Nassau | 12089 | 4962 | 66 | 0 | 4896 | 30.61037141 | -81.80297522 | 2021-01-03 05:22:52 | Nassau, Florida, US |
2347465 | 2347465 | 2020-12-07 | Japan | Tokyo | 44018 | 517 | 38605 | 4896 | 35.711343 | 139.446921 | 2020-12-08 05:27:42 | Tokyo, Japan | ||
3789511 | 3789511 | 2020-10-11 | Ukraine | Khmelnytskyi Oblast | 8792 | 162 | 3734 | 4896 | 49.423 | 26.9871 | 2020-10-12 04:23:45 | Khmelnytskyi Oblast, Ukraine | ||
2837621 | 2837621 | 2020-09-21 | US | Georgia | Henry | 13151 | 4994 | 98 | 0 | 4896 | 33.4533428 | -84.1481466 | 2020-09-22 04:23:00 | Henry, Georgia, US |
344259 | 344259 | 2020-09-14 | Italy | Lazio | 13304 | 885 | 7523 | 4896 | 41.89277044 | 12.48366722 | 2020-09-15 03:22:50 | Lazio, Italy | ||
2661721 | 2661721 | 2020-09-04 | India | Goa | 19863 | 220 | 14747 | 4896 | 15.359682 | 74.057396 | 2020-09-05 04:28:19 | Goa, India | ||
194311 | 194311 | 2020-08-31 | Russia | Sverdlovsk Oblast | 25315 | 450 | 19969 | 4896 | 58.6414755 | 61.8021546 | 2020-09-01 04:28:31 | Sverdlovsk Oblast, Russia | ||
3920294 | 3920294 | 2020-08-09 | US | Georgia | Clayton | 13063 | 5006 | 110 | 0 | 4896 | 33.54187245 | -84.35594188 | 2020-08-10 04:34:55 | Clayton, Georgia, US |
3490367 | 3490367 | 2020-07-13 | US | South Carolina | Richland | 45079 | 4995 | 99 | 0 | 4896 | 34.01791263 | -80.90267209 | 2020-07-14 04:34:46 | Richland, South Carolina, US |
2039804 | 2039804 | 2020-06-27 | Russia | Krasnoyarsk Krai | 8476 | 115 | 3465 | 4896 | 63.3233807 | 97.0979974 | 2020-06-28 04:34:04 | Krasnoyarsk Krai, Russia | ||
1040285 | 1040285 | 2020-05-26 | US | Virginia | Prince William | 51153 | 4992 | 96 | 0 | 4896 | 38.70916224 | -77.48713689 | 2020-05-27 02:32:31 | Prince William, Virginia, 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]);