johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where active = 5289 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3907638 | 3907638 | 2021-07-31 | Uzbekistan | 129327 | 874 | 123164 | 5289 | 41.377491 | 64.585262 | 2021-08-01 04:21:50 | Uzbekistan | |||
1440333 | 1440333 | 2021-07-07 | Brazil | Roraima | 114483 | 1770 | 107046 | 5289 | -2.7376 | -62.0751 | 2021-07-08 04:21:26 | Roraima, Brazil | ||
562717 | 562717 | 2021-06-22 | Brazil | Roraima | 109781 | 1716 | 102722 | 5289 | -2.7376 | -62.0751 | 2021-06-23 04:21:46 | Roraima, Brazil | ||
1085553 | 1085553 | 2021-05-14 | Ukraine | Kirovohrad Oblast | 19546 | 732 | 13525 | 5289 | 48.5079 | 32.2623 | 2021-05-15 04:20:58 | Kirovohrad Oblast, Ukraine | ||
1082163 | 1082163 | 2021-05-14 | Russia | Rostov Oblast | 90925 | 4198 | 81438 | 5289 | 47.6222451 | 40.7957942 | 2021-05-15 04:20:58 | Rostov Oblast, Russia | ||
3452607 | 3452607 | 2021-03-18 | Brazil | Roraima | 87032 | 1274 | 80125 | 5289 | -2.7376 | -62.0751 | 2021-03-19 05:26:09 | Roraima, Brazil | ||
1937314 | 1937314 | 2021-02-23 | US | Georgia | Spalding | 13255 | 5443 | 154 | 0 | 5289 | 33.26310031 | -84.28013991 | 2021-02-24 05:29:16 | Spalding, Georgia, US |
184301 | 184301 | 2021-02-21 | US | New York | Steuben | 36101 | 5426 | 137 | 0 | 5289 | 42.2689144 | -77.3829924 | 2021-02-22 05:24:21 | Steuben, New York, US |
743401 | 743401 | 2021-02-20 | US | Indiana | Henry | 18065 | 5379 | 90 | 0 | 5289 | 39.93029017 | -85.39625719 | 2021-02-21 05:24:33 | Henry, Indiana, US |
1156647 | 1156647 | 2021-02-18 | US | Wisconsin | Columbia | 55021 | 5347 | 58 | 0 | 5289 | 43.46492199 | -89.33589004 | 2021-02-19 05:24:16 | Columbia, Wisconsin, US |
1341415 | 1341415 | 2021-02-15 | US | Texas | Lamar | 48277 | 3306 | 139 | 0 | 5289 | 33.66981763 | -95.57404777 | 2021-02-16 05:24:38 | Lamar, Texas, US |
1672446 | 1672446 | 2021-02-07 | Italy | P.A. Bolzano | 44481 | 902 | 38290 | 5289 | 46.49933453 | 11.35662422 | 2021-02-08 05:22:39 | P.A. Bolzano, Italy | ||
2213476 | 2213476 | 2021-01-30 | US | Mississippi | Lafayette | 28071 | 5392 | 103 | 0 | 5289 | 34.35687874 | -89.48490961 | 2021-01-31 05:22:42 | Lafayette, Mississippi, US |
909994 | 909994 | 2021-01-19 | US | Mississippi | Lowndes | 28087 | 5405 | 116 | 0 | 5289 | 33.47386518 | -88.44191529999998 | 2021-01-20 05:21:54 | Lowndes, Mississippi, US |
239701 | 239701 | 2021-01-18 | US | Ohio | Hancock | 39063 | 5404 | 115 | 0 | 5289 | 41.00250487 | -83.66838948 | 2021-01-19 05:22:15 | Hancock, Ohio, US |
3902676 | 3902676 | 2021-01-09 | US | Puerto Rico | Carolina | 72031 | 5289 | 0 | 0 | 5289 | 18.374986 | -65.95683100000001 | 2021-01-10 05:22:12 | Carolina, Puerto Rico, US |
2865859 | 2865859 | 2021-01-06 | US | Indiana | Wayne | 18177 | 5443 | 154 | 0 | 5289 | 39.8633444 | -85.01044989 | 2021-01-07 05:22:03 | Wayne, Indiana, US |
1061962 | 1061962 | 2021-01-04 | Nepal | 262262 | 1885 | 255088 | 5289 | 28.1667 | 84.25 | 2021-01-05 05:21:49 | Nepal | |||
3778381 | 3778381 | 2020-12-27 | US | Arkansas | Garland | 5051 | 5430 | 141 | 0 | 5289 | 34.57692074 | -93.14921604 | 2020-12-28 05:22:06 | Garland, Arkansas, US |
738189 | 738189 | 2020-12-02 | Estonia | 13019 | 122 | 7608 | 5289 | 58.5953 | 25.0136 | 2020-12-03 05:28:22 | Estonia | |||
1587450 | 1587450 | 2020-11-30 | US | Virginia | Alexandria | 51510 | 5366 | 77 | 0 | 5289 | 38.814003 | -77.08183073 | 2020-12-01 05:26:18 | Alexandria, Virginia, US |
3412121 | 3412121 | 2020-11-01 | US | Pennsylvania | Northampton | 42095 | 5604 | 315 | 0 | 5289 | 40.75182733 | -75.30471829 | 2020-11-02 05:25:04 | Northampton, Pennsylvania, US |
2292151 | 2292151 | 2020-10-12 | US | Florida | Okaloosa | 12091 | 5411 | 122 | 0 | 5289 | 30.69143028 | -86.59267105 | 2020-10-13 04:24:02 | Okaloosa, Florida, US |
1518059 | 1518059 | 2020-09-28 | US | Pennsylvania | Lehigh | 42077 | 5642 | 353 | 0 | 5289 | 40.6154815 | -75.59435245 | 2020-09-29 04:23:42 | Lehigh, Pennsylvania, US |
610523 | 610523 | 2020-08-29 | US | Georgia | Muscogee | 13215 | 5422 | 133 | 0 | 5289 | 32.50931999 | -84.87142262 | 2020-08-30 04:28:22 | Muscogee, Georgia, US |
3866856 | 3866856 | 2020-06-03 | Brazil | Parana | 5567 | 210 | 0 | 5289 | -25.2521 | -52.0215 | 2020-06-04 02:33:14 | Parana, Brazil | ||
3274955 | 3274955 | 2020-05-15 | US | New Jersey | Mercer | 34021 | 5675 | 386 | 0 | 5289 | 40.28047017 | -74.70479631 | 2020-05-16 02:32:19 | Mercer, New Jersey, 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]);