johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where deaths = 3422 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1393922 | 1393922 | 2022-09-02 | Russia | Ryazan Oblast | 132941 | 3422 | 0 | 54.4226732 | 40.5705246 | 2022-09-03 04:21:04 | Ryazan Oblast, Russia | |||
3543620 | 3543620 | 2022-08-08 | Netherlands | Noord-Holland | 1375432 | 3422 | 0 | 52.600906 | 4.918688 | 2022-08-09 04:20:34 | Noord-Holland, Netherlands | |||
1490581 | 1490581 | 2022-07-26 | US | Tennessee | Shelby | 47157 | 261517 | 3422 | 0 | 35.1864775 | -89.89692423 | 2022-07-27 04:21:04 | Shelby, Tennessee, US | |
1608225 | 1608225 | 2022-07-20 | Italy | Abruzzo | 483504 | 3422 | 0 | 42.35122196 | 13.39843823 | 2022-07-21 04:21:10 | Abruzzo, Italy | |||
1169499 | 1169499 | 2022-05-20 | Spain | Galicia | 644998 | 3422 | 0 | 42.5751 | -8.1339 | 2022-05-21 04:20:58 | Galicia, Spain | |||
3896262 | 3896262 | 2022-05-19 | Spain | Galicia | 644998 | 3422 | 0 | 42.5751 | -8.1339 | 2022-05-20 04:20:57 | Galicia, Spain | |||
1185046 | 1185046 | 2022-05-18 | Spain | Galicia | 644998 | 3422 | 0 | 42.5751 | -8.1339 | 2022-05-19 04:20:54 | Galicia, Spain | |||
3582943 | 3582943 | 2022-05-17 | Spain | Galicia | 644998 | 3422 | 0 | 42.5751 | -8.1339 | 2022-05-18 04:20:50 | Galicia, Spain | |||
2307548 | 2307548 | 2022-04-20 | Russia | Vladimir Oblast | 149984 | 3422 | 0 | 56.0503336 | 40.656163299999996 | 2022-04-21 04:20:46 | Vladimir Oblast, Russia | |||
3352819 | 3352819 | 2022-04-01 | US | New Jersey | Bergen | 34003 | 223164 | 3422 | 0 | 40.96010917 | -74.07164325 | 2022-04-02 04:20:47 | Bergen, New Jersey, US | |
1905419 | 1905419 | 2022-03-22 | Russia | Leningrad Oblast | 179707 | 3422 | 0 | 60.185329599999996 | 32.3925325 | 2022-03-23 04:20:48 | Leningrad Oblast, Russia | |||
3300516 | 3300516 | 2022-01-30 | Sudan | 57106 | 3422 | 0 | 12.8628 | 30.2176 | 2022-01-31 04:21:09 | Sudan | ||||
3062307 | 3062307 | 2022-01-29 | Sudan | 57106 | 3422 | 0 | 12.8628 | 30.2176 | 2022-01-30 04:21:26 | Sudan | ||||
3810241 | 3810241 | 2022-01-28 | Sudan | 57106 | 3422 | 0 | 12.8628 | 30.2176 | 2022-01-29 04:21:10 | Sudan | ||||
1779695 | 1779695 | 2022-01-27 | Sudan | 57106 | 3422 | 0 | 12.8628 | 30.2176 | 2022-01-28 04:21:09 | Sudan | ||||
1702599 | 1702599 | 2022-01-03 | US | New York | Nassau | 36059 | 313601 | 3422 | 0 | 40.74066522 | -73.58941873 | 2022-01-04 04:22:17 | Nassau, New York, US | |
2088082 | 2088082 | 2021-12-14 | Mexico | Zacatecas | 42345 | 3422 | 0 | 22.7709 | -102.5832 | 2021-12-15 03:22:16 | Zacatecas, Mexico | |||
782499 | 782499 | 2021-12-13 | Mexico | Zacatecas | 42338 | 3422 | 0 | 22.7709 | -102.5832 | 2021-12-14 04:22:38 | Zacatecas, Mexico | |||
1660534 | 1660534 | 2021-12-12 | Mexico | Zacatecas | 42332 | 3422 | 0 | 22.7709 | -102.5832 | 2021-12-13 04:22:02 | Zacatecas, Mexico | |||
3069864 | 3069864 | 2021-11-23 | Colombia | Magdalena | 99250 | 3422 | 0 | 10.4113 | -74.4057 | 2021-11-24 04:22:14 | Magdalena, Colombia | |||
567359 | 567359 | 2021-10-29 | Russia | Tula Oblast | 59600 | 3422 | 0 | 53.9570701 | 37.369090899999996 | 2021-10-30 04:22:03 | Tula Oblast, Russia | |||
1818434 | 1818434 | 2021-09-19 | United Kingdom | Northern Ireland | 226276 | 3422 | 0 | 54.7877 | -6.4923 | 2021-09-20 04:21:22 | Northern Ireland, United Kingdom | |||
1262904 | 1262904 | 2021-09-09 | Namibia | 125966 | 3422 | 0 | -22.9576 | 18.4904 | 2021-09-10 04:21:20 | Namibia | ||||
3471848 | 3471848 | 2021-08-03 | Zambia | 197123 | 3422 | 189341 | 4360 | -13.133897 | 27.849332 | 2021-08-04 04:21:25 | Zambia | |||
1306217 | 1306217 | 2021-07-27 | Libya | 240309 | 3422 | 187960 | 48927 | 26.3351 | 17.228331 | 2021-07-28 04:21:39 | Libya | |||
2371774 | 2371774 | 2021-07-20 | Russia | Voronezh Oblast | 98795 | 3422 | 92740 | 2633 | 50.9800393 | 40.15065070000001 | 2021-07-21 04:21:40 | Voronezh Oblast, Russia | ||
483926 | 483926 | 2021-07-19 | Thailand | 415170 | 3422 | 26873 | 384875 | 15.870032 | 100.992541 | 2021-07-20 04:21:48 | Thailand | |||
1952422 | 1952422 | 2021-05-21 | Germany | Berlin | 176753 | 3422 | 169100 | 4504 | 52.52 | 13.405 | 2021-05-22 04:20:45 | Berlin, Germany | ||
1913161 | 1913161 | 2021-05-20 | India | Jammu and Kashmir | 260057 | 3422 | 206081 | 50554 | 33.75943 | 76.612638 | 2021-05-21 04:20:43 | Jammu and Kashmir, India | ||
3574823 | 3574823 | 2021-05-17 | Russia | Nizhny Novgorod Oblast | 116113 | 3422 | 111382 | 1309 | 55.47180329999999 | 44.0911594 | 2021-05-18 04:20:33 | Nizhny Novgorod Oblast, Russia | ||
1570793 | 1570793 | 2021-04-22 | US | Pennsylvania | Philadelphia | 42101 | 144901 | 3422 | 0 | 40.00338507 | -75.1379271 | 2021-04-23 04:20:52 | Philadelphia, Pennsylvania, US | |
2413861 | 2413861 | 2021-04-19 | US | Texas | Bexar | 48029 | 216001 | 3422 | 0 | 29.44928723 | -98.52019748 | 2021-04-20 04:20:41 | Bexar, Texas, US | |
2410725 | 2410725 | 2021-04-19 | Dominican Republic | 261531 | 3422 | 218988 | 39121 | 18.7357 | -70.1627 | 2021-04-20 04:20:41 | Dominican Republic | |||
3132538 | 3132538 | 2021-04-18 | US | Texas | Bexar | 48029 | 216001 | 3422 | 0 | 29.44928723 | -98.52019748 | 2021-04-19 04:20:57 | Bexar, Texas, US | |
985966 | 985966 | 2021-04-17 | US | Texas | Bexar | 48029 | 216001 | 3422 | 0 | 29.44928723 | -98.52019748 | 2021-04-18 04:20:41 | Bexar, Texas, US | |
2548792 | 2548792 | 2021-04-15 | Germany | Rheinland-Pfalz | 126606 | 3422 | 112700 | 11569 | 50.1183 | 7.309 | 2021-04-16 04:20:46 | Rheinland-Pfalz, Germany | ||
1838496 | 1838496 | 2021-03-12 | US | California | San Diego | 6073 | 278070 | 3422 | 0 | 33.03484597 | -116.7365326 | 2021-03-13 05:25:15 | San Diego, California, US | |
352861 | 352861 | 2021-03-11 | US | California | San Diego | 6073 | 277692 | 3422 | 0 | 33.03484597 | -116.7365326 | 2021-03-12 05:26:50 | San Diego, California, US | |
613680 | 613680 | 2021-02-08 | Italy | Puglia | 129467 | 3422 | 75760 | 50285 | 41.12559576 | 16.86736689 | 2021-02-09 05:23:30 | Puglia, Italy | ||
435289 | 435289 | 2021-01-21 | Honduras | 138044 | 3422 | 60392 | 74230 | 15.2 | -86.2419 | 2021-01-22 05:22:10 | Honduras | |||
1751412 | 1751412 | 2020-12-14 | Pakistan | Punjab | 128138 | 3422 | 115298 | 9418 | 30.811346 | 72.13913199999998 | 2020-12-15 05:26:38 | Punjab, Pakistan | ||
1794867 | 1794867 | 2020-10-19 | Russia | Saint Petersburg | 52592 | 3422 | 33857 | 15313 | 59.9606739 | 30.158655100000004 | 2020-10-20 04:24:22 | Saint Petersburg, Russia | ||
762551 | 762551 | 2020-10-18 | Russia | Saint Petersburg | 51906 | 3422 | 33517 | 14967 | 59.9606739 | 30.158655100000004 | 2020-10-19 04:24:16 | Saint Petersburg, Russia | ||
3093160 | 3093160 | 2020-09-20 | Brazil | Espirito Santo | 124291 | 3422 | 113819 | 7050 | -19.1834 | -40.3089 | 2020-09-21 04:23:00 | Espirito Santo, Brazil | ||
2685209 | 2685209 | 2020-07-06 | Egypt | 76222 | 3422 | 21238 | 51562 | 26.820553000000004 | 30.802497999999996 | 2020-07-07 04:34:00 | Egypt |
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]);