johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where deaths = 3554 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- US 13
- Spain 7
- Russia 3
- Germany 2
- Namibia 2
- Ukraine 2
- Albania 1
- Brazil 1
- Canada 1
- Dominican Republic 1
- El Salvador 1
- Italy 1
- Paraguay 1
- Peru 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
849864 | 849864 | 2022-11-02 | Russia | Vladimir Oblast | 176845 | 3554 | 0 | 56.0503336 | 40.6561633 | 2022-11-03 04:22:05 | Vladimir Oblast, Russia | |||
2008363 | 2008363 | 2022-08-04 | Albania | 315337 | 3554 | 0 | 41.1533 | 20.1683 | 2022-08-05 04:20:52 | Albania | ||||
2147942 | 2147942 | 2022-06-27 | Spain | Galicia | 681624 | 3554 | 0 | 42.5751 | -8.1339 | 2022-06-28 04:20:58 | Galicia, Spain | |||
475743 | 475743 | 2022-06-26 | Spain | Galicia | 681624 | 3554 | 0 | 42.5751 | -8.1339 | 2022-06-27 04:21:00 | Galicia, Spain | |||
939118 | 939118 | 2022-06-25 | Spain | Galicia | 681624 | 3554 | 0 | 42.5751 | -8.1339 | 2022-06-26 04:21:02 | Galicia, Spain | |||
3346938 | 3346938 | 2022-06-24 | Spain | Galicia | 681624 | 3554 | 0 | 42.5751 | -8.1339 | 2022-06-25 04:20:57 | Galicia, Spain | |||
2140373 | 2140373 | 2022-03-09 | Russia | Dagestan Republic | 90593 | 3554 | 0 | 43.05749160000001 | 47.1332224 | 2022-03-10 04:20:48 | Dagestan Republic, Russia | |||
1301133 | 1301133 | 2022-02-17 | US | Texas | El Paso | 48141 | 202024 | 3554 | 0 | 31.76980765 | -106.23632749999999 | 2022-02-18 04:21:04 | El Paso, Texas, US | |
3820895 | 3820895 | 2022-02-16 | US | Arizona | Pima | 4019 | 246502 | 3554 | 0 | 32.0971334 | -111.7890033 | 2022-02-17 04:20:56 | Pima, Arizona, US | |
3672109 | 3672109 | 2022-02-15 | US | Arizona | Pima | 4019 | 245956 | 3554 | 0 | 32.0971334 | -111.7890033 | 2022-02-16 04:21:10 | Pima, Arizona, US | |
2642210 | 2642210 | 2022-02-14 | US | Arizona | Pima | 4019 | 245956 | 3554 | 0 | 32.0971334 | -111.7890033 | 2022-02-15 04:21:09 | Pima, Arizona, US | |
186527 | 186527 | 2022-02-13 | US | Arizona | Pima | 4019 | 245532 | 3554 | 0 | 32.0971334 | -111.7890033 | 2022-02-14 04:20:51 | Pima, Arizona, US | |
1142516 | 1142516 | 2022-01-23 | US | Massachusetts | Middlesex | 25017 | 291711 | 3554 | 0 | 42.48607732 | -71.39049229 | 2022-01-24 04:21:12 | Middlesex, Massachusetts, US | |
2834434 | 2834434 | 2022-01-22 | US | Massachusetts | Middlesex | 25017 | 291711 | 3554 | 0 | 42.48607732 | -71.39049229 | 2022-01-23 04:21:13 | Middlesex, Massachusetts, US | |
3426552 | 3426552 | 2022-01-21 | US | Massachusetts | Middlesex | 25017 | 291711 | 3554 | 0 | 42.48607732 | -71.39049229 | 2022-01-22 04:21:13 | Middlesex, Massachusetts, US | |
3467295 | 3467295 | 2022-01-18 | US | Texas | Hidalgo | 48215 | 153461 | 3554 | 0 | 26.39418217 | -98.18299696 | 2022-01-19 04:21:23 | Hidalgo, Texas, US | |
3511520 | 3511520 | 2021-11-01 | Namibia | 128938 | 3554 | 0 | -22.9576 | 18.4904 | 2021-11-02 04:22:03 | Namibia | ||||
288112 | 288112 | 2021-10-31 | Namibia | 128927 | 3554 | 0 | -22.9576 | 18.4904 | 2021-11-01 04:22:01 | Namibia | ||||
770217 | 770217 | 2021-10-23 | El Salvador | 112290 | 3554 | 0 | 13.7942 | -88.8965 | 2021-10-24 04:21:22 | El Salvador | ||||
633828 | 633828 | 2021-10-13 | Germany | Sachsen-Anhalt | 106011 | 3554 | 0 | 51.9503 | 11.6923 | 2021-10-14 04:21:29 | Sachsen-Anhalt, Germany | |||
3659881 | 3659881 | 2021-07-11 | Spain | Aragon | 130503 | 3554 | 3772 | 123177 | 41.5976 | -0.9057 | 2021-07-12 04:21:34 | Aragon, Spain | ||
626165 | 626165 | 2021-07-10 | Spain | Aragon | 130503 | 3554 | 3772 | 123177 | 41.5976 | -0.9057 | 2021-07-11 04:21:43 | Aragon, Spain | ||
833224 | 833224 | 2021-07-09 | Ukraine | Kharkiv Oblast | 148737 | 3554 | 144498 | 685 | 49.9935 | 36.2304 | 2021-07-10 04:21:25 | Kharkiv Oblast, Ukraine | ||
829884 | 829884 | 2021-07-09 | Spain | Aragon | 130503 | 3554 | 3772 | 123177 | 41.5976 | -0.9057 | 2021-07-10 04:21:25 | Aragon, Spain | ||
3362337 | 3362337 | 2021-06-21 | West Bank and Gaza | 312811 | 3554 | 306312 | 2945 | 31.9522 | 35.2332 | 2021-06-22 04:21:34 | West Bank and Gaza | |||
2887593 | 2887593 | 2021-06-20 | US | Texas | Tarrant | 48439 | 269490 | 3554 | 0 | 32.77143818 | -97.29101614 | 2021-06-21 04:21:41 | Tarrant, Texas, US | |
110676 | 110676 | 2021-06-19 | US | Texas | Tarrant | 48439 | 269361 | 3554 | 0 | 32.77143818 | -97.29101614 | 2021-06-20 04:21:48 | Tarrant, Texas, US | |
1128819 | 1128819 | 2021-06-18 | US | Texas | Tarrant | 48439 | 269280 | 3554 | 0 | 32.77143818 | -97.29101614 | 2021-06-19 04:22:33 | Tarrant, Texas, US | |
54422 | 54422 | 2021-05-29 | Ukraine | Lviv Oblast | 135811 | 3554 | 129045 | 3212 | 49.8397 | 24.0297 | 2021-05-30 04:20:55 | Lviv Oblast, Ukraine | ||
1310396 | 1310396 | 2021-05-26 | Russia | Nizhny Novgorod Oblast | 117386 | 3554 | 112215 | 1617 | 55.47180329999999 | 44.0911594 | 2021-05-27 04:20:59 | Nizhny Novgorod Oblast, Russia | ||
729515 | 729515 | 2021-05-22 | US | Texas | Bexar | 48029 | 226243 | 3554 | 0 | 29.44928723 | -98.52019748 | 2021-05-23 04:20:51 | Bexar, Texas, US | |
2390926 | 2390926 | 2021-05-18 | Peru | Cajamarca | 55835 | 3554 | 0 | 52281 | -6.430284 | -78.74559599999998 | 2021-05-19 04:20:42 | Cajamarca, Peru | ||
2004542 | 2004542 | 2021-05-12 | Dominican Republic | 273497 | 3554 | 232381 | 37562 | 18.7357 | -70.1627 | 2021-05-13 04:20:51 | Dominican Republic | |||
1841867 | 1841867 | 2021-04-14 | Germany | Thuringen | 103971 | 3554 | 91840 | 9738 | 51.011 | 10.8453 | 2021-04-15 04:20:54 | Thuringen, Germany | ||
637653 | 637653 | 2021-03-31 | Brazil | Alagoas | 153490 | 3554 | 144928 | 5008 | -9.5713 | -36.782 | 2021-04-01 04:27:05 | Alagoas, Brazil | ||
702554 | 702554 | 2021-03-16 | Paraguay | 183348 | 3554 | 152280 | 27514 | -23.4425 | -58.4438 | 2021-03-17 05:25:07 | Paraguay | |||
3539451 | 3539451 | 2021-02-12 | Italy | Puglia | 133479 | 3554 | 88325 | 41600 | 41.12559576 | 16.86736689 | 2021-02-13 05:22:12 | Puglia, Italy | ||
1972362 | 1972362 | 2020-11-25 | Canada | Ontario | 112026 | 3554 | 96188 | 11612 | 51.2538 | -85.3232 | 2020-11-26 05:27:44 | Ontario, Canada |
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]);