johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where active = 15288 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2548650 | 2548650 | 2021-04-15 | Canada | Quebec | 333814 | 10778 | 307748 | 15288 | 52.9399 | -73.5491 | 2021-04-16 04:20:46 | Quebec, Canada | ||
3602127 | 3602127 | 2021-02-17 | US | Indiana | Hendricks | 18063 | 15579 | 291 | 0 | 15288 | 39.76719009 | -86.51037283 | 2021-02-18 05:22:58 | Hendricks, Indiana, US |
978487 | 978487 | 2021-02-06 | US | Wisconsin | Rock | 55105 | 15449 | 161 | 0 | 15288 | 42.67151616 | -89.07147900000002 | 2021-02-07 05:23:00 | Rock, Wisconsin, US |
1678337 | 1678337 | 2021-02-01 | US | Missouri | Boone | 29019 | 15349 | 61 | 0 | 15288 | 38.99186229 | -92.30723575 | 2021-02-02 05:22:49 | Boone, Missouri, US |
2213237 | 2213237 | 2021-01-30 | US | Maryland | Frederick | 24021 | 15531 | 243 | 0 | 15288 | 39.47296601 | -77.39999394 | 2021-01-31 05:22:42 | Frederick, Maryland, US |
3101151 | 3101151 | 2021-01-16 | Belarus | 223537 | 1573 | 206676 | 15288 | 53.7098 | 27.9534 | 2021-01-17 05:22:17 | Belarus | |||
1599965 | 1599965 | 2020-12-10 | Brazil | Pernambuco | 195118 | 9229 | 170601 | 15288 | -8.8137 | -36.9541 | 2020-12-11 05:26:59 | Pernambuco, Brazil | ||
2350669 | 2350669 | 2020-12-07 | US | Texas | Williamson | 48491 | 14905 | 175 | 0 | 15288 | 30.64655664 | -97.6004854 | 2020-12-08 05:27:42 | Williamson, Texas, US |
1009539 | 1009539 | 2020-12-06 | US | Texas | Williamson | 48491 | 14562 | 175 | 0 | 15288 | 30.64655664 | -97.6004854 | 2020-12-07 05:26:14 | Williamson, Texas, US |
1635548 | 1635548 | 2020-12-05 | US | Texas | Williamson | 48491 | 14389 | 175 | 0 | 15288 | 30.64655664 | -97.6004854 | 2020-12-06 05:26:18 | Williamson, Texas, US |
680693 | 680693 | 2020-11-23 | US | North Dakota | Cass | 38017 | 15797 | 117 | 0 | 15288 | 46.93201724 | -97.2444719 | 2020-11-24 05:27:31 | Cass, North Dakota, US |
3409349 | 3409349 | 2020-11-01 | Georgia | 40727 | 335 | 25104 | 15288 | 42.3154 | 43.3569 | 2020-11-02 05:25:04 | Georgia | |||
1707382 | 1707382 | 2020-07-21 | India | Delhi | 125096 | 3690 | 106118 | 15288 | 28.646519 | 77.10898 | 2020-07-22 04:34:42 | Delhi, India | ||
2630445 | 2630445 | 2020-06-29 | US | Connecticut | Fairfield | 9001 | 16664 | 1376 | 0 | 15288 | 41.26809896 | -73.3881171 | 2020-06-30 04:33:48 | Fairfield, Connecticut, US |
1272022 | 1272022 | 2020-06-11 | US | New Jersey | Middlesex | 34023 | 16357 | 1069 | 0 | 15288 | 40.43629879 | -74.41426991 | 2020-06-12 05:09:52 | Middlesex, New Jersey, 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]);