johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 4484 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130988 | 130988 | 2022-10-04 | Russia | Omsk Oblast | 226081 | 4484 | 0 | 56.0935263 | 73.5099936 | 2022-10-05 04:23:06 | Omsk Oblast, Russia | |||
2685935 | 2685935 | 2022-10-03 | Russia | Omsk Oblast | 225869 | 4484 | 0 | 56.0935263 | 73.5099936 | 2022-10-04 04:22:55 | Omsk Oblast, Russia | |||
3211336 | 3211336 | 2022-07-18 | US | Illinois | Unassigned | 90017 | 133 | 4484 | 0 | 42.36542373 | 0.0 | 2022-07-19 04:20:58 | Unassigned, Illinois, US | |
1543623 | 1543623 | 2022-03-31 | United Kingdom | Northern Ireland | 686844 | 4484 | 0 | 54.7877 | -6.4923 | 2022-04-01 04:20:28 | Northern Ireland, United Kingdom | |||
1963252 | 1963252 | 2022-01-20 | US | Pennsylvania | Philadelphia | 42101 | 286526 | 4484 | 0 | 40.00338507 | -75.1379271 | 2022-01-21 04:21:09 | Philadelphia, Pennsylvania, US | |
1077894 | 1077894 | 2021-12-09 | Italy | Liguria | 126794 | 4484 | 0 | 44.41149315 | 8.9326992 | 2021-12-10 04:22:28 | Liguria, Italy | |||
3639749 | 3639749 | 2021-11-08 | Russia | Chelyabinsk Oblast | 113419 | 4484 | 0 | 54.4223954 | 61.1865846 | 2021-11-09 04:21:36 | Chelyabinsk Oblast, Russia | |||
4252 | 4252 | 2021-10-28 | Germany | Thuringen | 149130 | 4484 | 0 | 51.011 | 10.8453 | 2021-10-29 04:22:03 | Thuringen, Germany | |||
3832750 | 3832750 | 2021-10-05 | Russia | Voronezh Oblast | 136259 | 4484 | 0 | 50.9800393 | 40.15065070000001 | 2021-10-06 04:21:33 | Voronezh Oblast, Russia | |||
2203741 | 2203741 | 2021-08-07 | Mexico | Tabasco | 91193 | 4484 | 0 | 17.8409 | -92.6189 | 2021-08-08 04:21:33 | Tabasco, Mexico | |||
626108 | 626108 | 2021-07-10 | Russia | Nizhny Novgorod Oblast | 129376 | 4484 | 118945 | 5947 | 55.47180329999999 | 44.0911594 | 2021-07-11 04:21:43 | Nizhny Novgorod Oblast, Russia | ||
3381069 | 3381069 | 2021-06-13 | Armenia | 223682 | 4484 | 215195 | 4003 | 40.0691 | 45.0382 | 2021-06-14 04:22:46 | Armenia | |||
1219514 | 1219514 | 2021-03-27 | India | Gujarat | 298596 | 4484 | 283241 | 10871 | 22.694884 | 71.590923 | 2021-03-28 05:28:10 | Gujarat, India | ||
74794 | 74794 | 2020-12-03 | Austria | 288203 | 4484 | 238127 | 51765 | 47.5162 | 14.5501 | 2020-12-04 05:27:27 | Austria | |||
272315 | 272315 | 2020-11-10 | Peru | La Libertad | 33558 | 4484 | 0 | 29074 | -7.92139 | -78.370238 | 2020-11-11 05:25:30 | La Libertad, Peru | ||
376057 | 376057 | 2020-11-06 | Czechia | 403497 | 4484 | 214882 | 184131 | 49.8175 | 15.473 | 2020-11-07 05:24:52 | Czechia | |||
3389371 | 3389371 | 2020-10-02 | Italy | Emilia-Romagna | 35577 | 4484 | 26416 | 4677 | 44.49436681 | 11.3417208 | 2020-10-03 04:23:40 | Emilia-Romagna, Italy | ||
2379612 | 2379612 | 2020-10-01 | Italy | Emilia-Romagna | 35414 | 4484 | 26276 | 4654 | 44.49436681 | 11.3417208 | 2020-10-02 04:23:51 | Emilia-Romagna, Italy | ||
1045798 | 1045798 | 2020-09-30 | Italy | Emilia-Romagna | 35311 | 4484 | 26174 | 4653 | 44.49436681 | 11.3417208 | 2020-10-01 04:23:42 | Emilia-Romagna, Italy | ||
966879 | 966879 | 2020-09-29 | Italy | Emilia-Romagna | 35210 | 4484 | 26016 | 4710 | 44.49436681 | 11.3417208 | 2020-09-30 04:23:33 | Emilia-Romagna, Italy |
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]);