johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where active = 6809 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218515 | 3218515 | 2021-07-26 | Russia | Krasnodar Krai | 57738 | 4048 | 46881 | 6809 | 45.7684014 | 39.0261044 | 2021-07-27 04:21:18 | Krasnodar Krai, Russia | ||
3331264 | 3331264 | 2021-07-21 | Brazil | Distrito Federal | 443280 | 9509 | 426962 | 6809 | -15.7998 | -47.8645 | 2021-07-22 04:21:19 | Distrito Federal, Brazil | ||
1579900 | 1579900 | 2021-03-13 | Brazil | Rio de Janeiro | 606452 | 34304 | 565339 | 6809 | -22.9068 | -43.1729 | 2021-03-14 05:25:37 | Rio de Janeiro, Brazil | ||
1617026 | 1617026 | 2021-03-05 | US | Georgia | Dougherty | 13095 | 7092 | 283 | 0 | 6809 | 31.53328528 | -84.21722377 | 2021-03-06 04:23:41 | Dougherty, Georgia, US |
2678064 | 2678064 | 2021-02-13 | Russia | Rostov Oblast | 68349 | 2932 | 58608 | 6809 | 47.6222451 | 40.7957942 | 2021-02-14 05:23:43 | Rostov Oblast, Russia | ||
1591804 | 1591804 | 2021-02-05 | Ukraine | Lviv Oblast | 72342 | 2122 | 63411 | 6809 | 49.8397 | 24.0297 | 2021-02-06 05:23:55 | Lviv Oblast, Ukraine | ||
1463152 | 1463152 | 2021-01-31 | US | Virginia | Roanoke City | 51770 | 6928 | 119 | 0 | 6809 | 37.27791025 | -79.96189766 | 2021-02-01 05:22:53 | Roanoke City, Virginia, US |
3157129 | 3157129 | 2021-01-27 | US | Wisconsin | Chippewa | 55017 | 6888 | 79 | 0 | 6809 | 45.06939744 | -91.28068855 | 2021-01-28 05:22:24 | Chippewa, Wisconsin, US |
3309045 | 3309045 | 2021-01-13 | US | Georgia | Newton | 13217 | 6947 | 138 | 0 | 6809 | 33.55514538 | -83.84547140000002 | 2021-01-14 05:22:32 | Newton, Georgia, US |
3903598 | 3903598 | 2021-01-09 | Ukraine | Zhytomyr Oblast | 41263 | 683 | 33771 | 6809 | 50.2547 | 28.6587 | 2021-01-10 05:22:12 | Zhytomyr Oblast, Ukraine | ||
2406524 | 2406524 | 2020-12-23 | Angola | 16931 | 393 | 9729 | 6809 | -11.2027 | 17.8739 | 2020-12-24 05:23:04 | Angola | |||
3190902 | 3190902 | 2020-11-22 | US | Idaho | Bonneville | 16019 | 6865 | 56 | 0 | 6809 | 43.38713372 | -111.6161537 | 2020-11-23 05:25:26 | Bonneville, Idaho, US |
3443055 | 3443055 | 2020-11-11 | US | New York | Onondaga | 36067 | 7021 | 212 | 0 | 6809 | 43.00491923 | -76.19971155 | 2020-11-12 05:25:55 | Onondaga, New York, US |
1731113 | 1731113 | 2020-11-08 | US | Oregon | Washington | 41067 | 6897 | 88 | 0 | 6809 | 45.55972701 | -123.0955257 | 2020-11-09 05:25:45 | Washington, Oregon, US |
376558 | 376558 | 2020-11-06 | US | Alabama | Lee | 1081 | 6874 | 65 | 0 | 6809 | 32.60154883 | -85.35132246 | 2020-11-07 05:24:52 | Lee, Alabama, US |
8487 | 8487 | 2020-10-25 | Peru | Huancavelica | 7165 | 356 | 0 | 6809 | -13.023888 | -75.00277 | 2020-10-26 04:25:02 | Huancavelica, Peru | ||
3651975 | 3651975 | 2020-10-24 | US | Alaska | Anchorage | 2020 | 6851 | 42 | 0 | 6809 | 61.14998174 | -149.14269860000005 | 2020-10-25 04:24:36 | Anchorage, Alaska, US |
2581966 | 2581966 | 2020-09-27 | Italy | Lazio | 15835 | 907 | 8119 | 6809 | 41.89277044 | 12.48366722 | 2020-09-28 04:23:00 | Lazio, Italy | ||
2665388 | 2665388 | 2020-09-04 | Ukraine | Kharkiv Oblast | 10312 | 220 | 3283 | 6809 | 49.9935 | 36.2304 | 2020-09-05 04:28:19 | Kharkiv Oblast, Ukraine |
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]);