johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where deaths = 3489 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- Russia 13
- US 7
- Colombia 4
- Netherlands 4
- Albania 3
- Chile 3
- Mexico 3
- Brazil 1
- Egypt 1
- Germany 1
- Italy 1
- United Kingdom 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753150 | 2753150 | 2022-12-29 | Russia | Ryazan Oblast | 149457 | 3489 | 0 | 54.4226732 | 40.5705246 | 2022-12-30 04:21:04 | Ryazan Oblast, Russia | |||
3460292 | 3460292 | 2022-11-21 | Netherlands | Noord-Holland | 1403377 | 3489 | 0 | 52.600906 | 4.918688 | 2022-11-22 04:20:47 | Noord-Holland, Netherlands | |||
1640477 | 1640477 | 2022-11-20 | Netherlands | Noord-Holland | 1403377 | 3489 | 0 | 52.600906 | 4.918688 | 2022-11-21 04:21:05 | Noord-Holland, Netherlands | |||
2064034 | 2064034 | 2022-11-19 | Netherlands | Noord-Holland | 1403377 | 3489 | 0 | 52.600906 | 4.918688 | 2022-11-20 04:21:08 | Noord-Holland, Netherlands | |||
1755428 | 1755428 | 2022-11-18 | Netherlands | Noord-Holland | 1403377 | 3489 | 0 | 52.600906 | 4.918688 | 2022-11-19 04:21:14 | Noord-Holland, Netherlands | |||
1627287 | 1627287 | 2022-09-22 | US | Tennessee | Shelby | 47157 | 273283 | 3489 | 0 | 35.1864775 | -89.89692423 | 2022-09-23 04:23:13 | Shelby, Tennessee, US | |
1373491 | 1373491 | 2022-09-21 | US | Tennessee | Shelby | 47157 | 273158 | 3489 | 0 | 35.1864775 | -89.89692423 | 2022-09-22 04:22:56 | Shelby, Tennessee, US | |
1417350 | 1417350 | 2022-07-08 | Russia | Vladimir Oblast | 152352 | 3489 | 0 | 56.0503336 | 40.6561633 | 2022-07-09 04:20:59 | Vladimir Oblast, Russia | |||
3269737 | 3269737 | 2022-06-19 | Russia | Leningrad Oblast | 188453 | 3489 | 0 | 60.1853296 | 32.3925325 | 2022-06-20 04:21:01 | Leningrad Oblast, Russia | |||
3397649 | 3397649 | 2022-06-18 | Russia | Leningrad Oblast | 188424 | 3489 | 0 | 60.1853296 | 32.3925325 | 2022-06-19 04:20:51 | Leningrad Oblast, Russia | |||
2311526 | 2311526 | 2022-06-17 | Russia | Leningrad Oblast | 188401 | 3489 | 0 | 60.1853296 | 32.3925325 | 2022-06-18 04:21:10 | Leningrad Oblast, Russia | |||
559030 | 559030 | 2022-06-16 | Russia | Leningrad Oblast | 188375 | 3489 | 0 | 60.1853296 | 32.3925325 | 2022-06-17 04:20:56 | Leningrad Oblast, Russia | |||
3982832 | 3982832 | 2022-06-15 | Russia | Leningrad Oblast | 188353 | 3489 | 0 | 60.1853296 | 32.3925325 | 2022-06-16 04:20:55 | Leningrad Oblast, Russia | |||
947073 | 947073 | 2022-06-14 | Russia | Leningrad Oblast | 188321 | 3489 | 0 | 60.1853296 | 32.3925325 | 2022-06-15 04:20:54 | Leningrad Oblast, Russia | |||
2979481 | 2979481 | 2022-06-13 | Russia | Leningrad Oblast | 188285 | 3489 | 0 | 60.1853296 | 32.3925325 | 2022-06-14 04:20:52 | Leningrad Oblast, Russia | |||
1540035 | 1540035 | 2022-03-31 | Mexico | Aguascalientes | 64003 | 3489 | 0 | 21.8853 | -102.2916 | 2022-04-01 04:20:28 | Aguascalientes, Mexico | |||
1467772 | 1467772 | 2022-03-24 | Albania | 273257 | 3489 | 0 | 41.1533 | 20.1683 | 2022-03-25 04:20:46 | Albania | ||||
3021946 | 3021946 | 2022-03-23 | Albania | 273164 | 3489 | 0 | 41.1533 | 20.1683 | 2022-03-24 04:20:43 | Albania | ||||
1904868 | 1904868 | 2022-03-22 | Albania | 273146 | 3489 | 0 | 41.1533 | 20.1683 | 2022-03-23 04:20:48 | Albania | ||||
2610285 | 2610285 | 2022-01-06 | Russia | Orenburg Oblast | 108638 | 3489 | 0 | 52.02692620000001 | 54.7276647 | 2022-01-07 04:22:09 | Orenburg Oblast, Russia | |||
3519268 | 3519268 | 2022-01-02 | Colombia | Magdalena | 101695 | 3489 | 0 | 10.4113 | -74.4057 | 2022-01-03 02:22:25 | Magdalena, Colombia | |||
2167398 | 2167398 | 2022-01-01 | Colombia | Magdalena | 101572 | 3489 | 0 | 10.4113 | -74.4057 | 2022-01-02 04:20:52 | Magdalena, Colombia | |||
2776829 | 2776829 | 2021-12-31 | Colombia | Magdalena | 101467 | 3489 | 0 | 10.4113 | -74.4057 | 2022-01-01 04:22:14 | Magdalena, Colombia | |||
1017452 | 1017452 | 2021-11-21 | US | Texas | Hidalgo | 48215 | 125078 | 3489 | 0 | 26.39418217 | -98.18299696 | 2021-11-22 04:22:20 | Hidalgo, Texas, US | |
725616 | 725616 | 2021-11-20 | US | Texas | Hidalgo | 48215 | 125078 | 3489 | 0 | 26.39418217 | -98.18299696 | 2021-11-21 04:22:13 | Hidalgo, Texas, US | |
165146 | 165146 | 2021-11-19 | US | Texas | Hidalgo | 48215 | 125037 | 3489 | 0 | 26.39418217 | -98.18299696 | 2021-11-20 04:22:17 | Hidalgo, Texas, US | |
2721240 | 2721240 | 2021-10-30 | Russia | Penza Oblast | 79817 | 3489 | 0 | 53.1655415 | 44.78791810000001 | 2021-10-31 04:22:08 | Penza Oblast, Russia | |||
2720783 | 2720783 | 2021-10-30 | Chile | Valparaiso | 126501 | 3489 | 0 | -33.0472 | -71.6127 | 2021-10-31 04:22:08 | Valparaiso, Chile | |||
566885 | 566885 | 2021-10-29 | Chile | Valparaiso | 126318 | 3489 | 0 | -33.0472 | -71.6127 | 2021-10-30 04:22:03 | Valparaiso, Chile | |||
4127 | 4127 | 2021-10-28 | Chile | Valparaiso | 126129 | 3489 | 0 | -33.0472 | -71.6127 | 2021-10-29 04:22:03 | Valparaiso, Chile | |||
2776639 | 2776639 | 2021-09-30 | United Kingdom | Northern Ireland | 238300 | 3489 | 0 | 54.7877 | -6.4923 | 2021-10-01 04:21:35 | Northern Ireland, United Kingdom | |||
650204 | 650204 | 2021-08-09 | Russia | Perm Krai | 77310 | 3489 | 0 | 58.5951603 | 56.3159546 | 2021-08-10 04:21:27 | Perm Krai, Russia | |||
522948 | 522948 | 2021-06-09 | Mexico | Morelos | 33993 | 3489 | 0 | 30504 | 18.6813 | -99.1013 | 2021-06-10 04:23:17 | Morelos, Mexico | ||
2586236 | 2586236 | 2021-06-05 | Russia | Sverdlovsk Oblast | 89780 | 3489 | 83686 | 2605 | 58.6414755 | 61.8021546 | 2021-06-06 04:24:03 | Sverdlovsk Oblast, Russia | ||
24036 | 24036 | 2021-05-28 | West Bank and Gaza | 307569 | 3489 | 300125 | 3955 | 31.9522 | 35.2332 | 2021-05-29 04:20:41 | West Bank and Gaza | |||
3678669 | 3678669 | 2021-05-04 | US | Texas | Bexar | 48029 | 223126 | 3489 | 0 | 29.44928723 | -98.52019748 | 2021-05-05 04:20:43 | Bexar, Texas, US | |
2450865 | 2450865 | 2021-05-02 | Mexico | Oaxaca | 46010 | 3489 | 0 | 42521 | 17.0732 | -96.7266 | 2021-05-03 04:20:39 | Oaxaca, Mexico | ||
1568023 | 1568023 | 2021-04-22 | Germany | Rheinland-Pfalz | 132799 | 3489 | 116700 | 13748 | 50.1183 | 7.309 | 2021-04-23 04:20:52 | Rheinland-Pfalz, Germany | ||
1535657 | 1535657 | 2021-03-28 | Brazil | Alagoas | 151824 | 3489 | 143777 | 4558 | -9.5713 | -36.782 | 2021-03-29 04:28:35 | Alagoas, Brazil | ||
2864551 | 2864551 | 2021-01-06 | Colombia | Atlantico | 96957 | 3489 | 90101 | 3367 | 10.6966 | -74.8741 | 2021-01-07 05:22:03 | Atlantico, Colombia | ||
202240 | 202240 | 2020-12-25 | Italy | Lazio | 155667 | 3489 | 76104 | 76074 | 41.89277044 | 12.48366722 | 2020-12-26 05:22:28 | Lazio, Italy | ||
786815 | 786815 | 2020-10-15 | US | Arizona | Maricopa | 4013 | 148152 | 3489 | 0 | 144663 | 33.34835867 | -112.4918154 | 2020-10-16 04:24:01 | Maricopa, Arizona, US |
887649 | 887649 | 2020-07-07 | Egypt | 77279 | 3489 | 21718 | 52072 | 26.820553000000004 | 30.802497999999996 | 2020-07-08 05:33:48 | 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]);