johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 7897 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3256336 | 3256336 | 2021-03-02 | US | New Mexico | Lea | 35025 | 8045 | 148 | 0 | 7897 | 32.79215361 | -103.4123733 | 2021-03-03 05:23:28 | Lea, New Mexico, US |
3255098 | 3255098 | 2021-03-02 | US | Illinois | Adams | 17001 | 8011 | 114 | 0 | 7897 | 39.98815591 | -91.18786813 | 2021-03-03 05:23:28 | Adams, Illinois, US |
3603653 | 3603653 | 2021-02-17 | US | Oregon | Jackson | 41029 | 8004 | 107 | 0 | 7897 | 42.43201126 | -122.7289309 | 2021-02-18 05:22:58 | Jackson, Oregon, US |
1340280 | 1340280 | 2021-02-15 | US | Montana | Missoula | 30063 | 7980 | 83 | 0 | 7897 | 47.03728583 | -113.92135079999998 | 2021-02-16 05:24:38 | Missoula, Montana, US |
2215266 | 2215266 | 2021-01-30 | US | Wyoming | Laramie | 56021 | 7984 | 87 | 0 | 7897 | 41.30702520000001 | -104.6887497 | 2021-01-31 05:22:42 | Laramie, Wyoming, US |
1900753 | 1900753 | 2021-01-29 | US | Wyoming | Laramie | 56021 | 7984 | 87 | 0 | 7897 | 41.30702520000001 | -104.6887497 | 2021-01-30 05:22:49 | Laramie, Wyoming, US |
3230925 | 3230925 | 2021-01-03 | US | Arkansas | Faulkner | 5045 | 7991 | 94 | 0 | 7897 | 35.14719007 | -92.33717519 | 2021-01-04 05:22:02 | Faulkner, Arkansas, US |
3848152 | 3848152 | 2020-12-13 | US | Alabama | Etowah | 1055 | 7977 | 80 | 0 | 7897 | 34.04567266 | -86.04051873 | 2020-12-14 05:26:27 | Etowah, Alabama, US |
3442919 | 3442919 | 2020-11-11 | US | Nebraska | Sarpy | 31153 | 7941 | 44 | 0 | 7897 | 41.11314181 | -96.11156432 | 2020-11-12 05:25:55 | Sarpy, Nebraska, US |
2243325 | 2243325 | 2020-10-30 | India | Bihar | 215327 | 1084 | 206346 | 7897 | 25.679658 | 85.60484 | 2020-10-31 04:24:44 | Bihar, India | ||
3788709 | 3788709 | 2020-10-11 | US | South Carolina | Lexington | 45063 | 8078 | 181 | 0 | 7897 | 33.89665987 | -81.27146426 | 2020-10-12 04:23:45 | Lexington, South Carolina, US |
2514891 | 2514891 | 2020-10-03 | US | Florida | St. Lucie | 12111 | 8189 | 292 | 0 | 7897 | 27.37763908 | -80.47106649 | 2020-10-04 04:23:44 | St. Lucie, Florida, US |
2974221 | 2974221 | 2020-06-30 | India | Andhra Pradesh | 14595 | 187 | 6511 | 7897 | 15.9129 | 79.74 | 2020-07-01 04:33:52 | Andhra Pradesh, India | ||
1793848 | 1793848 | 2020-05-31 | Spain | Castilla - La Mancha | 17234 | 2945 | 6392 | 7897 | 39.2796 | -3.0977 | 2020-06-01 02:32:46 | Castilla - La Mancha, Spain | ||
2581585 | 2581585 | 2020-05-12 | Norway | 8157 | 228 | 32 | 7897 | 60.472 | 8.4689 | 2020-05-13 03:32:26 | Norway |
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]);