johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where active = 6731 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2585932 | 2585932 | 2021-06-05 | India | Delhi | 1428863 | 24557 | 1397575 | 6731 | 28.646519 | 77.10898 | 2021-06-06 04:24:03 | Delhi, India | ||
1341789 | 1341789 | 2021-02-15 | US | West Virginia | Wood | 54107 | 6856 | 125 | 0 | 6731 | 39.20967886 | -81.5162836 | 2021-02-16 05:24:38 | Wood, West Virginia, US |
1760903 | 1760903 | 2021-01-24 | US | Michigan | Bay | 26017 | 6984 | 253 | 0 | 6731 | 43.70639106 | -83.98731479 | 2021-01-25 05:22:16 | Bay, Michigan, US |
2428510 | 2428510 | 2021-01-23 | US | Michigan | Bay | 26017 | 6984 | 253 | 0 | 6731 | 43.70639106 | -83.98731479 | 2021-01-24 05:22:35 | Bay, Michigan, US |
860755 | 860755 | 2020-12-11 | Mexico | Chiapas | 7908 | 1177 | 0 | 6731 | 16.7569 | -93.1292 | 2020-12-12 05:26:19 | Chiapas, Mexico | ||
3836692 | 3836692 | 2020-11-21 | Russia | Kirov Oblast | 15942 | 188 | 9023 | 6731 | 57.9665589 | 49.4074599 | 2020-11-22 05:25:45 | Kirov Oblast, Russia | ||
125026 | 125026 | 2020-11-18 | US | North Carolina | Johnston | 37101 | 6801 | 70 | 0 | 6731 | 35.51745004 | -78.36622717 | 2020-11-19 05:25:23 | Johnston, North Carolina, US |
272368 | 272368 | 2020-11-10 | Russia | Krasnoyarsk Krai | 29584 | 752 | 22101 | 6731 | 63.3233807 | 97.0979974 | 2020-11-11 05:25:30 | Krasnoyarsk Krai, Russia | ||
1990790 | 1990790 | 2020-11-09 | US | New Jersey | Gloucester | 34015 | 6982 | 251 | 0 | 6731 | 39.71581067 | -75.13995546 | 2020-11-10 05:40:07 | Gloucester, New Jersey, US |
2919927 | 2919927 | 2020-11-04 | US | Georgia | Bibb | 13021 | 6944 | 213 | 0 | 6731 | 32.80904227 | -83.70489165 | 2020-11-05 06:05:03 | Bibb, Georgia, US |
3097032 | 3097032 | 2020-09-20 | Ukraine | Ivano-Frankivsk Oblast | 12382 | 277 | 5374 | 6731 | 48.9226 | 24.7111 | 2020-09-21 04:23:00 | Ivano-Frankivsk Oblast, Ukraine | ||
2868444 | 2868444 | 2020-09-13 | Bosnia and Herzegovina | 23465 | 696 | 16038 | 6731 | 43.9159 | 17.6791 | 2020-09-14 04:26:00 | Bosnia and Herzegovina | |||
2234335 | 2234335 | 2020-07-03 | US | Arizona | Yuma | 4027 | 6838 | 107 | 0 | 6731 | 32.76895712 | -113.90666740000002 | 2020-07-04 04:33:51 | Yuma, Arizona, US |
2623819 | 2623819 | 2020-06-25 | US | Florida | Orange | 12095 | 6786 | 55 | 0 | 6731 | 28.51367621 | -81.31799498 | 2020-06-26 04:33:43 | Orange, Florida, 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]);