johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where deaths = 2954 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753070 | 2753070 | 2022-12-29 | Peru | Huanuco | 60396 | 2954 | 0 | -9.421676 | -76.040642 | 2022-12-30 04:21:04 | Huanuco, Peru | |||
1074076 | 1074076 | 2022-12-28 | Peru | Huanuco | 60396 | 2954 | 0 | -9.421676 | -76.040642 | 2022-12-29 04:21:01 | Huanuco, Peru | |||
328073 | 328073 | 2022-12-27 | Peru | Huanuco | 60396 | 2954 | 0 | -9.421676 | -76.040642 | 2022-12-28 04:21:04 | Huanuco, Peru | |||
218146 | 218146 | 2022-12-26 | Peru | Huanuco | 60396 | 2954 | 0 | -9.421676 | -76.040642 | 2022-12-27 04:21:07 | Huanuco, Peru | |||
1976783 | 1976783 | 2022-09-25 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-26 04:20:52 | Huanuco, Peru | |||
2649950 | 2649950 | 2022-09-24 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-25 04:23:31 | Huanuco, Peru | |||
384390 | 384390 | 2022-09-23 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-24 04:21:40 | Huanuco, Peru | |||
1624456 | 1624456 | 2022-09-22 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-23 04:23:13 | Huanuco, Peru | |||
1370660 | 1370660 | 2022-09-21 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-22 04:22:56 | Huanuco, Peru | |||
2016890 | 2016890 | 2022-09-20 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-21 04:23:22 | Huanuco, Peru | |||
3570763 | 3570763 | 2022-09-19 | Peru | Huanuco | 58024 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-20 04:22:48 | Huanuco, Peru | |||
419502 | 419502 | 2022-09-18 | Peru | Huanuco | 57978 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-19 04:21:49 | Huanuco, Peru | |||
3373526 | 3373526 | 2022-09-17 | Peru | Huanuco | 57978 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-18 04:22:50 | Huanuco, Peru | |||
2355634 | 2355634 | 2022-09-16 | Peru | Huanuco | 57978 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-17 04:20:19 | Huanuco, Peru | |||
3986791 | 3986791 | 2022-09-15 | Peru | Huanuco | 57978 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-16 04:21:19 | Huanuco, Peru | |||
1889308 | 1889308 | 2022-09-14 | Peru | Huanuco | 57978 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-15 04:21:02 | Huanuco, Peru | |||
372363 | 372363 | 2022-09-13 | Peru | Huanuco | 57978 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-14 04:20:44 | Huanuco, Peru | |||
2394966 | 2394966 | 2022-09-12 | Peru | Huanuco | 57978 | 2954 | 0 | -9.421676 | -76.040642 | 2022-09-13 04:20:57 | Huanuco, Peru | |||
2187389 | 2187389 | 2022-06-22 | Chile | Maule | 257272 | 2954 | 0 | -35.5183 | -71.6885 | 2022-06-23 04:20:55 | Maule, Chile | |||
165820 | 165820 | 2022-06-21 | Chile | Maule | 256821 | 2954 | 0 | -35.5183 | -71.6885 | 2022-06-22 04:20:54 | Maule, Chile | |||
1763103 | 1763103 | 2022-06-20 | Chile | Maule | 256577 | 2954 | 0 | -35.5183 | -71.6885 | 2022-06-21 04:20:56 | Maule, Chile | |||
3851801 | 3851801 | 2022-04-27 | Jamaica | 129747 | 2954 | 0 | 18.1096 | -77.2975 | 2022-04-28 04:20:47 | Jamaica | ||||
2478162 | 2478162 | 2022-03-30 | Russia | Astrakhan Oblast | 114587 | 2954 | 0 | 47.1878186 | 47.608851 | 2022-03-31 04:20:56 | Astrakhan Oblast, Russia | |||
2732987 | 2732987 | 2022-02-27 | Italy | Abruzzo | 262894 | 2954 | 0 | 42.35122196 | 13.39843823 | 2022-02-28 04:21:05 | Abruzzo, Italy | |||
3046240 | 3046240 | 2022-02-26 | Malaysia | Sabah | 334506 | 2954 | 0 | 5.9788 | 116.0753 | 2022-02-27 04:21:04 | Sabah, Malaysia | |||
3046218 | 3046218 | 2022-02-26 | Kyrgyzstan | 200458 | 2954 | 0 | 41.20438 | 74.766098 | 2022-02-27 04:21:04 | Kyrgyzstan | ||||
3671896 | 3671896 | 2022-02-15 | Russia | Ryazan Oblast | 86630 | 2954 | 0 | 54.42267320000001 | 40.57052460000001 | 2022-02-16 04:21:10 | Ryazan Oblast, Russia | |||
3073816 | 3073816 | 2022-02-09 | Chile | Biobio | 213374 | 2954 | 0 | -37.4464 | -72.1416 | 2022-02-10 04:21:14 | Biobio, Chile | |||
1362123 | 1362123 | 2022-02-08 | Chile | Biobio | 210086 | 2954 | 0 | -37.4464 | -72.1416 | 2022-02-09 04:21:04 | Biobio, Chile | |||
70861 | 70861 | 2022-02-07 | Chile | Biobio | 207240 | 2954 | 0 | -37.4464 | -72.1416 | 2022-02-08 04:21:15 | Biobio, Chile | |||
1782033 | 1782033 | 2022-01-27 | US | Pennsylvania | Allegheny | 42003 | 245213 | 2954 | 0 | 40.46809875 | -79.98167747 | 2022-01-28 04:21:09 | Allegheny, Pennsylvania, US | |
1254995 | 1254995 | 2021-12-20 | Russia | Leningrad Oblast | 97798 | 2954 | 0 | 60.185329599999996 | 32.3925325 | 2021-12-21 03:21:27 | Leningrad Oblast, Russia | |||
1148009 | 1148009 | 2021-12-01 | US | Texas | El Paso | 48141 | 140287 | 2954 | 0 | 31.76980765 | -106.23632749999999 | 2021-12-02 04:22:37 | El Paso, Texas, US | |
3289152 | 3289152 | 2021-11-18 | Russia | Orenburg Oblast | 96610 | 2954 | 0 | 52.02692620000001 | 54.7276647 | 2021-11-19 04:21:40 | Orenburg Oblast, Russia | |||
28614 | 28614 | 2021-11-11 | Russia | Chuvashia Republic | 39785 | 2954 | 0 | 55.4259922 | 47.0849429 | 2021-11-12 04:22:01 | Chuvashia Republic, Russia | |||
423589 | 423589 | 2021-10-10 | Russia | Penza Oblast | 73214 | 2954 | 0 | 53.1655415 | 44.78791810000001 | 2021-10-11 04:21:31 | Penza Oblast, Russia | |||
1274314 | 1274314 | 2021-10-03 | Japan | Tokyo | 380038 | 2954 | 0 | 35.711343 | 139.446921 | 2021-10-04 04:21:31 | Tokyo, Japan | |||
650073 | 650073 | 2021-08-09 | Mexico | Zacatecas | 34525 | 2954 | 0 | 22.7709 | -102.5832 | 2021-08-10 04:21:27 | Zacatecas, Mexico | |||
589735 | 589735 | 2021-08-08 | Mexico | Zacatecas | 34494 | 2954 | 0 | 22.7709 | -102.5832 | 2021-08-09 04:21:24 | Zacatecas, Mexico | |||
2203747 | 2203747 | 2021-08-07 | Mexico | Zacatecas | 34394 | 2954 | 0 | 22.7709 | -102.5832 | 2021-08-08 04:21:33 | Zacatecas, Mexico | |||
2008284 | 2008284 | 2021-05-12 | Ukraine | Kharkiv Oblast | 141115 | 2954 | 117538 | 20623 | 49.9935 | 36.2304 | 2021-05-13 04:20:51 | Kharkiv Oblast, Ukraine | ||
173698 | 173698 | 2021-04-16 | United Kingdom | Northern Ireland | 118851 | 2954 | 0 | 116718 | 54.7877 | -6.4923 | 2021-04-17 04:20:40 | Northern Ireland, United Kingdom | ||
471101 | 471101 | 2021-02-19 | Algeria | 111600 | 2954 | 76797 | 31849 | 28.0339 | 1.6596 | 2021-02-20 05:22:51 | Algeria | |||
3050414 | 3050414 | 2021-02-16 | Russia | Rostov Oblast | 69357 | 2954 | 59506 | 6897 | 47.6222451 | 40.7957942 | 2021-02-17 05:23:10 | Rostov Oblast, Russia | ||
2426988 | 2426988 | 2021-01-23 | Mexico | Guerrero | 29656 | 2954 | 0 | 26702 | 17.4392 | -99.5451 | 2021-01-24 05:22:35 | Guerrero, Mexico | ||
3101435 | 3101435 | 2021-01-16 | Italy | Sicilia | 119290 | 2954 | 70884 | 45452 | 38.11569725 | 13.362356699999998 | 2021-01-17 05:22:17 | Sicilia, Italy | ||
2704609 | 2704609 | 2020-11-20 | US | Texas | Harris | 48201 | 226482 | 2954 | 0 | 176957 | 29.85864939 | -95.39339521 | 2020-11-21 05:25:51 | Harris, Texas, US |
1243594 | 1243594 | 2020-09-08 | Colombia | Atlantico | 65111 | 2954 | 60064 | 2093 | 10.6966 | -74.8741 | 2020-09-09 04:28:48 | Atlantico, Colombia | ||
146149 | 146149 | 2020-08-15 | Romania | 69374 | 2954 | 32334 | 34086 | 45.9432 | 24.9668 | 2020-08-16 04:27:42 | Romania |
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]);