johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where confirmed = 46578 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1964772 | 1964772 | 2022-11-30 | Russia | Chechen Republic | 46578 | 1076 | 0 | 43.3976147 | 45.6985005 | 2022-12-01 04:21:03 | Chechen Republic, Russia | |||
3776271 | 3776271 | 2022-08-30 | US | North Carolina | Rowan | 37159 | 46578 | 607 | 0 | 35.64003916 | -80.52446628 | 2022-08-31 04:20:57 | Rowan, North Carolina, US | |
1682867 | 1682867 | 2022-08-29 | US | North Carolina | Rowan | 37159 | 46578 | 607 | 0 | 35.64003916 | -80.52446628 | 2022-08-30 04:21:03 | Rowan, North Carolina, US | |
1879351 | 1879351 | 2022-08-28 | US | North Carolina | Rowan | 37159 | 46578 | 607 | 0 | 35.64003916 | -80.52446628 | 2022-08-29 04:21:06 | Rowan, North Carolina, US | |
2098478 | 2098478 | 2022-08-27 | US | North Carolina | Rowan | 37159 | 46578 | 607 | 0 | 35.64003916 | -80.52446628 | 2022-08-28 04:21:02 | Rowan, North Carolina, US | |
1534293 | 1534293 | 2022-08-26 | US | North Carolina | Rowan | 37159 | 46578 | 607 | 0 | 35.64003916 | -80.52446628 | 2022-08-27 04:20:57 | Rowan, North Carolina, US | |
2831180 | 2831180 | 2022-08-25 | US | North Carolina | Rowan | 37159 | 46578 | 607 | 0 | 35.64003916 | -80.52446628 | 2022-08-26 04:21:02 | Rowan, North Carolina, US | |
2325713 | 2325713 | 2022-08-24 | US | North Carolina | Rowan | 37159 | 46578 | 607 | 0 | 35.64003916 | -80.52446628 | 2022-08-25 04:21:13 | Rowan, North Carolina, US | |
2012933 | 2012933 | 2022-02-06 | Russia | Mordovia Republic | 46578 | 1176 | 0 | 54.4419829 | 44.466114399999995 | 2022-02-07 04:21:05 | Mordovia Republic, Russia | |||
1227690 | 1227690 | 2022-01-24 | Mexico | Aguascalientes | 46578 | 3140 | 0 | 21.8853 | -102.2916 | 2022-01-25 04:21:05 | Aguascalientes, Mexico | |||
447446 | 447446 | 2021-11-17 | Mauritius | 46578 | 304 | 0 | -20.348404000000002 | 57.552152 | 2021-11-18 04:21:33 | Mauritius | ||||
2044144 | 2044144 | 2021-10-18 | Spain | Cantabria | 46578 | 609 | 0 | 43.1828 | -3.9878 | 2021-10-19 04:20:54 | Cantabria, Spain | |||
590203 | 590203 | 2021-08-08 | US | California | San Mateo | 6081 | 46578 | 548 | 0 | 37.4228808 | -122.32755459999998 | 2021-08-09 04:21:24 | San Mateo, California, US | |
2004754 | 2004754 | 2021-05-12 | Mexico | Oaxaca | 46578 | 3636 | 0 | 42942 | 17.0732 | -96.7266 | 2021-05-13 04:20:51 | Oaxaca, Mexico |
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]);