johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where confirmed = 17835 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310855 | 310855 | 2022-12-13 | US | Tennessee | Loudon | 47105 | 17835 | 216 | 0 | 35.73939663 | -84.31145275 | 2022-12-14 04:21:04 | Loudon, Tennessee, US | |
3586094 | 3586094 | 2022-05-17 | US | Washington | Lewis | 53041 | 17835 | 256 | 0 | 46.57756476 | -122.3925769 | 2022-05-18 04:20:50 | Lewis, Washington, US | |
1507051 | 1507051 | 2022-05-16 | US | Washington | Lewis | 53041 | 17835 | 256 | 0 | 46.57756476 | -122.3925769 | 2022-05-17 04:20:59 | Lewis, Washington, US | |
2536693 | 2536693 | 2022-05-12 | US | Virgin Islands | 78 | 17835 | 113 | 0 | 18.3358 | -64.8963 | 2022-05-13 04:20:51 | Virgin Islands, US | ||
2446997 | 2446997 | 2022-02-22 | Russia | Magadan Oblast | 17835 | 367 | 0 | 62.48858785 | 153.9903764 | 2022-02-23 04:21:09 | Magadan Oblast, Russia | |||
554618 | 554618 | 2022-01-16 | Colombia | Choco | 17835 | 407 | 0 | 5.2528 | -76.82600000000002 | 2022-01-17 04:21:08 | Choco, Colombia | |||
407395 | 407395 | 2021-12-07 | US | Texas | Grayson | 48181 | 17835 | 515 | 0 | 33.62744998 | -96.67753461 | 2021-12-08 04:22:46 | Grayson, Texas, US | |
515287 | 515287 | 2021-08-19 | US | Wisconsin | Washington | 55131 | 17835 | 204 | 0 | 43.36863664 | -88.22974712 | 2021-08-20 04:21:33 | Washington, Wisconsin, US | |
247892 | 247892 | 2021-08-17 | US | Oregon | Lane | 41039 | 17835 | 180 | 0 | 43.93727035 | -122.847753 | 2021-08-18 04:21:35 | Lane, Oregon, US | |
333666 | 333666 | 2021-08-04 | US | Minnesota | Scott | 27139 | 17835 | 139 | 0 | 44.6490231 | -93.53340251 | 2021-08-05 04:21:51 | Scott, Minnesota, US | |
486240 | 486240 | 2021-07-19 | US | Pennsylvania | Butler | 42019 | 17835 | 423 | 0 | 40.91152759 | -79.91351055 | 2021-07-20 04:21:48 | Butler, Pennsylvania, US | |
1313542 | 1313542 | 2021-05-26 | US | Virginia | Norfolk | 51710 | 17835 | 261 | 0 | 36.89934014 | -76.26420872 | 2021-05-27 04:20:59 | Norfolk, Virginia, US | |
1872916 | 1872916 | 2021-05-15 | India | Nagaland | 17835 | 196 | 13654 | 3985 | 26.06702 | 94.470302 | 2021-05-16 04:20:49 | Nagaland, India | ||
2367719 | 2367719 | 2021-02-28 | Russia | Mordovia Republic | 17835 | 161 | 15815 | 1859 | 54.4419829 | 44.4661144 | 2021-03-01 05:23:01 | Mordovia Republic, Russia | ||
1153385 | 1153385 | 2021-02-18 | Rwanda | 17835 | 243 | 16163 | 1429 | -1.9403 | 29.8739 | 2021-02-19 05:24:16 | Rwanda | |||
2119433 | 2119433 | 2020-12-20 | Belgium | Luxembourg | 17835 | 0 | 0 | 17835 | 50.0547 | 5.4677 | 2020-12-21 05:27:58 | Luxembourg, Belgium | ||
78265 | 78265 | 2020-12-03 | US | Texas | Nueces | 48355 | 17835 | 496 | 0 | 24463 | 27.736286 | -97.5433285 | 2020-12-04 05:27:27 | Nueces, Texas, 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]);