johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where active = 9989 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296227 | 3296227 | 2021-07-30 | Jordan | 770150 | 10020 | 750141 | 9989 | 31.24 | 36.51 | 2021-07-31 04:21:35 | Jordan | |||
2586067 | 2586067 | 2021-06-05 | Mexico | Chiapas | 11636 | 1647 | 0 | 9989 | 16.7569 | -93.1292 | 2021-06-06 04:24:03 | Chiapas, Mexico | ||
380284 | 380284 | 2021-04-30 | Mexico | Nayarit | 11782 | 1793 | 0 | 9989 | 21.7514 | -104.8455 | 2021-05-01 04:20:47 | Nayarit, Mexico | ||
1841709 | 1841709 | 2021-04-14 | Canada | British Columbia | 114870 | 1521 | 103360 | 9989 | 53.7267 | -127.6476 | 2021-04-15 04:20:54 | British Columbia, Canada | ||
1301887 | 1301887 | 2021-04-01 | Colombia | Atlantico | 154196 | 4523 | 139684 | 9989 | 10.6966 | -74.8741 | 2021-04-02 04:20:36 | Atlantico, Colombia | ||
1338951 | 1338951 | 2021-02-15 | US | Florida | Charlotte | 12015 | 10322 | 333 | 0 | 9989 | 26.90131002 | -81.92949121 | 2021-02-16 05:24:38 | Charlotte, Florida, US |
791382 | 791382 | 2021-02-04 | US | Illinois | LaSalle | 17099 | 10191 | 202 | 0 | 9989 | 41.34426129999999 | -88.88633881 | 2021-02-05 05:22:38 | LaSalle, Illinois, US |
1137630 | 1137630 | 2021-01-01 | US | Georgia | Bibb | 13021 | 10250 | 261 | 0 | 9989 | 32.80904227 | -83.70489165 | 2021-01-02 05:22:33 | Bibb, Georgia, US |
3152935 | 3152935 | 2020-12-16 | US | Virginia | Henrico | 51087 | 10260 | 271 | 0 | 9989 | 37.53460572 | -77.39326555 | 2020-12-17 05:28:12 | Henrico, Virginia, US |
3861977 | 3861977 | 2020-12-04 | US | New Hampshire | Hillsborough | 33011 | 10332 | 343 | 0 | 9989 | 42.91537785 | -71.7200253 | 2020-12-05 05:27:36 | Hillsborough, New Hampshire, US |
3342230 | 3342230 | 2020-11-17 | Ukraine | Zhytomyr Oblast | 23447 | 393 | 13065 | 9989 | 50.2547 | 28.6587 | 2020-11-18 05:40:31 | Zhytomyr Oblast, Ukraine | ||
3441365 | 3441365 | 2020-11-11 | US | California | Merced | 6047 | 10145 | 157 | 0 | 9989 | 37.18922369 | -120.7209035 | 2020-11-12 05:25:55 | Merced, California, US |
2654862 | 2654862 | 2020-09-23 | US | Indiana | Lake | 18089 | 10334 | 345 | 0 | 9989 | 41.41874274 | -87.38277575 | 2020-09-24 04:23:00 | Lake, Indiana, US |
1999460 | 1999460 | 2020-08-26 | US | South Carolina | Richland | 45079 | 10179 | 190 | 0 | 9989 | 34.01791263 | -80.90267209 | 2020-08-27 04:28:15 | Richland, South Carolina, 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]);