johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
61 rows where deaths = 2216 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
481180 | 481180 | 2022-11-08 | US | Maryland | Montgomery | 24031 | 227972 | 2216 | 0 | 39.13676329 | -77.20358245 | 2022-11-09 04:21:22 | Montgomery, Maryland, US | |
2440330 | 2440330 | 2022-11-07 | US | Maryland | Montgomery | 24031 | 227972 | 2216 | 0 | 39.13676329 | -77.20358245 | 2022-11-08 04:21:21 | Montgomery, Maryland, US | |
253333 | 253333 | 2022-09-08 | Japan | Saitama | 1109861 | 2216 | 0 | 35.997101 | 139.347635 | 2022-09-09 04:21:11 | Saitama, Japan | |||
3745131 | 3745131 | 2022-09-07 | Japan | Saitama | 1103912 | 2216 | 0 | 35.997101 | 139.347635 | 2022-09-08 04:21:02 | Saitama, Japan | |||
1346437 | 1346437 | 2022-08-10 | Mozambique | 229777 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-11 04:20:49 | Mozambique | ||||
1086192 | 1086192 | 2022-08-09 | Mozambique | 229777 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-10 04:20:57 | Mozambique | ||||
3543607 | 3543607 | 2022-08-08 | Mozambique | 229759 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-09 04:20:34 | Mozambique | ||||
1070010 | 1070010 | 2022-08-07 | Mozambique | 229755 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-08 04:21:08 | Mozambique | ||||
1940598 | 1940598 | 2022-08-06 | Mozambique | 229739 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-07 04:20:54 | Mozambique | ||||
880397 | 880397 | 2022-08-05 | Mozambique | 229696 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-06 04:20:56 | Mozambique | ||||
2008808 | 2008808 | 2022-08-04 | Mozambique | 229674 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-05 04:20:52 | Mozambique | ||||
1098235 | 1098235 | 2022-08-03 | Mozambique | 229645 | 2216 | 0 | -18.665695 | 35.529562 | 2022-08-04 04:20:58 | Mozambique | ||||
670385 | 670385 | 2022-07-21 | Mexico | Colima | 63703 | 2216 | 0 | 19.1223 | -104.0072 | 2022-07-22 04:21:15 | Colima, Mexico | |||
1608348 | 1608348 | 2022-07-20 | Mexico | Colima | 63417 | 2216 | 0 | 19.1223 | -104.0072 | 2022-07-21 04:21:10 | Colima, Mexico | |||
746537 | 746537 | 2022-04-23 | Russia | Belgorod Oblast | 129257 | 2216 | 0 | 50.7080119 | 37.5837615 | 2022-04-24 04:20:56 | Belgorod Oblast, Russia | |||
335901 | 335901 | 2022-03-18 | Italy | Calabria | 259086 | 2216 | 0 | 38.90597598 | 16.59440194 | 2022-03-19 04:20:47 | Calabria, Italy | |||
942913 | 942913 | 2022-02-28 | Mexico | Campeche | 33228 | 2216 | 0 | 19.8301 | -90.5349 | 2022-03-01 04:21:09 | Campeche, Mexico | |||
2733104 | 2733104 | 2022-02-27 | Mexico | Campeche | 33225 | 2216 | 0 | 19.8301 | -90.5349 | 2022-02-28 04:21:05 | Campeche, Mexico | |||
1364616 | 1364616 | 2022-02-08 | US | New York | Richmond | 36085 | 162626 | 2216 | 0 | 40.58582155 | -74.14808598 | 2022-02-09 04:21:04 | Richmond, New York, US | |
3302392 | 3302392 | 2022-01-30 | US | New Jersey | Union | 34039 | 137232 | 2216 | 0 | 40.65835409 | -74.30680092 | 2022-01-31 04:21:09 | Union, New Jersey, US | |
3844158 | 3844158 | 2022-01-15 | Ukraine | Volyn Oblast | 104816 | 2216 | 0 | 50.7472 | 25.3254 | 2022-01-16 04:21:12 | Volyn Oblast, Ukraine | |||
3832112 | 3832112 | 2021-12-21 | Ukraine | Rivne Oblast | 126125 | 2216 | 0 | 50.6199 | 26.2516 | 2021-12-22 04:21:54 | Rivne Oblast, Ukraine | |||
3655843 | 3655843 | 2021-12-10 | Russia | Smolensk Oblast | 80543 | 2216 | 0 | 55.03434960000001 | 33.0192065 | 2021-12-11 04:22:45 | Smolensk Oblast, Russia | |||
2287570 | 2287570 | 2021-11-15 | Montenegro | 152411 | 2216 | 0 | 42.708678000000006 | 19.37439 | 2021-11-16 04:21:10 | Montenegro | ||||
600666 | 600666 | 2021-10-19 | US | Tennessee | Shelby | 47157 | 143459 | 2216 | 0 | 35.1864775 | -89.89692423 | 2021-10-20 04:21:00 | Shelby, Tennessee, US | |
1374350 | 1374350 | 2021-09-15 | Colombia | Risaralda | 87392 | 2216 | 0 | 5.3158 | -75.9928 | 2021-09-16 04:22:19 | Risaralda, Colombia | |||
2295491 | 2295491 | 2021-06-24 | Japan | Tokyo | 170918 | 2216 | 164572 | 4130 | 35.711343 | 139.446921 | 2021-06-25 04:21:33 | Tokyo, Japan | ||
1771227 | 1771227 | 2021-05-23 | El Salvador | 72220 | 2216 | 67510 | 2494 | 13.7942 | -88.8965 | 2021-05-24 04:20:53 | El Salvador | |||
3395559 | 3395559 | 2021-04-28 | US | New Jersey | Hudson | 34017 | 86360 | 2216 | 0 | 40.73766234 | -74.07515667 | 2021-04-29 04:20:55 | Hudson, New Jersey, US | |
3005472 | 3005472 | 2021-04-06 | US | New Jersey | Middlesex | 34023 | 85647 | 2216 | 0 | 40.43629879 | -74.41426991 | 2021-04-07 04:20:53 | Middlesex, New Jersey, US | |
1289694 | 1289694 | 2021-03-29 | Albania | 124419 | 2216 | 90024 | 32179 | 41.1533 | 20.1683 | 2021-03-30 04:26:23 | Albania | |||
1207425 | 1207425 | 2021-03-22 | Ukraine | Dnipropetrovsk Oblast | 83909 | 2216 | 72363 | 9330 | 48.4647 | 35.0462 | 2021-03-23 05:26:18 | Dnipropetrovsk Oblast, Ukraine | ||
3453117 | 3453117 | 2021-03-18 | Russia | Voronezh Oblast | 72459 | 2216 | 66850 | 3393 | 50.9800393 | 40.15065070000001 | 2021-03-19 05:26:09 | Voronezh Oblast, Russia | ||
3962622 | 3962622 | 2021-03-10 | Mexico | Tlaxcala | 17621 | 2216 | 0 | 15405 | 19.3139 | -98.2404 | 2021-03-11 05:25:48 | Tlaxcala, Mexico | ||
3254208 | 3254208 | 2021-03-02 | Libya | 134967 | 2216 | 122079 | 10672 | 26.3351 | 17.228331 | 2021-03-03 05:23:28 | Libya | |||
998886 | 998886 | 2021-03-01 | US | Arizona | Pima | 4019 | 109601 | 2216 | 0 | 107385 | 32.0971334 | -111.7890033 | 2021-03-02 05:23:30 | Pima, Arizona, US |
2367944 | 2367944 | 2021-02-28 | US | Arizona | Pima | 4019 | 109488 | 2216 | 0 | 107272 | 32.0971334 | -111.7890033 | 2021-03-01 05:23:01 | Pima, Arizona, US |
3067041 | 3067041 | 2021-02-27 | US | Illinois | Unassigned | 90017 | 80 | 2216 | 0 | 0 | 42.36542373 | 0.0 | 2021-02-28 05:22:20 | Unassigned, Illinois, US |
3066446 | 3066446 | 2021-02-27 | US | Arizona | Pima | 4019 | 109320 | 2216 | 0 | 107104 | 32.0971334 | -111.7890033 | 2021-02-28 05:22:20 | Pima, Arizona, US |
613565 | 613565 | 2021-02-08 | Denmark | 202051 | 2216 | 193202 | 6633 | 56.2639 | 9.5018 | 2021-02-09 05:23:30 | Denmark | |||
1672334 | 1672334 | 2021-02-07 | Denmark | 201621 | 2216 | 192695 | 6710 | 56.2639 | 9.5018 | 2021-02-08 05:22:39 | Denmark | |||
1896904 | 1896904 | 2021-01-29 | Brazil | Rondonia | 123200 | 2216 | 97983 | 23001 | -11.5057 | -63.5806 | 2021-01-30 05:22:49 | Rondonia, Brazil | ||
3156620 | 3156620 | 2021-01-27 | US | Texas | Bexar | 48029 | 167508 | 2216 | 0 | 162054 | 29.44928723 | -98.52019748 | 2021-01-28 05:22:24 | Bexar, Texas, US |
12555 | 12555 | 2021-01-26 | Russia | Krasnoyarsk Krai | 54863 | 2216 | 50505 | 2142 | 63.3233807 | 97.0979974 | 2021-01-27 05:23:41 | Krasnoyarsk Krai, Russia | ||
2466722 | 2466722 | 2021-01-22 | Germany | Rheinland-Pfalz | 87855 | 2216 | 72260 | 14089 | 50.1183 | 7.309 | 2021-01-23 05:22:03 | Rheinland-Pfalz, Germany | ||
190306 | 190306 | 2021-01-11 | Russia | Rostov Oblast | 55955 | 2216 | 45993 | 7746 | 47.6222451 | 40.7957942 | 2021-01-12 05:22:15 | Rostov Oblast, Russia | ||
2626432 | 2626432 | 2021-01-10 | US | California | Riverside | 6065 | 230419 | 2216 | 0 | 228879 | 33.74314981 | -115.9933578 | 2021-01-11 05:21:50 | Riverside, California, US |
3771468 | 3771468 | 2020-12-22 | US | Massachusetts | Middlesex | 25017 | 67233 | 2216 | 0 | 64622 | 42.48607732 | -71.39049229 | 2020-12-23 05:22:03 | Middlesex, Massachusetts, US |
2119633 | 2119633 | 2020-12-20 | Germany | Sachsen | 104744 | 2216 | 65100 | 39662 | 51.1045 | 13.2017 | 2020-12-21 05:27:58 | Sachsen, Germany | ||
678259 | 678259 | 2020-11-23 | India | Haryana | 219963 | 2216 | 197335 | 20412 | 29.20004 | 76.332824 | 2020-11-24 05:27:31 | Haryana, India | ||
3189983 | 3189983 | 2020-11-22 | Italy | Toscana | 94705 | 2216 | 39765 | 52724 | 43.76923077 | 11.25588885 | 2020-11-23 05:25:26 | Toscana, Italy | ||
3440912 | 3440912 | 2020-11-11 | Mexico | San Luis Potosi | 30869 | 2216 | 27062 | 1591 | 22.1565 | -100.9855 | 2020-11-12 05:25:55 | San Luis Potosi, Mexico | ||
2500255 | 2500255 | 2020-11-03 | US | New York | Nassau | 36059 | 50602 | 2216 | 0 | 48386 | 40.74066522 | -73.58941873 | 2020-11-04 05:25:09 | Nassau, New York, US |
3306429 | 3306429 | 2020-11-02 | US | New York | Nassau | 36059 | 50407 | 2216 | 0 | 48191 | 40.74066522 | -73.58941873 | 2020-11-03 06:00:16 | Nassau, New York, US |
3411678 | 3411678 | 2020-11-01 | US | New York | Nassau | 36059 | 50294 | 2216 | 0 | 48078 | 40.74066522 | -73.58941873 | 2020-11-02 05:25:04 | Nassau, New York, US |
2245620 | 2245620 | 2020-10-30 | US | New York | Nassau | 36059 | 50007 | 2216 | 0 | 47791 | 40.74066522 | -73.58941873 | 2020-10-31 04:24:44 | Nassau, New York, US |
3480043 | 3480043 | 2020-10-26 | Brazil | Alagoas | 90254 | 2216 | 85557 | 2481 | -9.5713 | -36.782 | 2020-10-27 04:24:45 | Alagoas, Brazil | ||
8417 | 8417 | 2020-10-25 | Mexico | Hidalgo | 15184 | 2216 | 12166 | 802 | 20.0911 | -98.7624 | 2020-10-26 04:25:02 | Hidalgo, Mexico | ||
2602032 | 2602032 | 2020-10-10 | Italy | Veneto | 31065 | 2216 | 23017 | 5832 | 45.43490485 | 12.33845213 | 2020-10-11 04:23:46 | Veneto, Italy | ||
1515494 | 1515494 | 2020-09-28 | Mexico | Tamaulipas | 28713 | 2216 | 25633 | 864 | 24.2669 | -98.8363 | 2020-09-29 04:23:42 | Tamaulipas, Mexico | ||
887135 | 887135 | 2020-07-07 | Brazil | Bahia | 91954 | 2216 | 63207 | 26531 | -12.5797 | -41.7007 | 2020-07-08 05:33:48 | Bahia, Brazil |
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]);