johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
81 rows where deaths = 1644 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1240727 | 1240727 | 2022-11-28 | US | Illinois | Will | 17197 | 205428 | 1644 | 0 | 41.44619267 | -87.97862712 | 2022-11-29 04:21:05 | Will, Illinois, US | |
2159815 | 2159815 | 2022-10-16 | Singapore | 2012065 | 1644 | 0 | 1.2833 | 103.8333 | 2022-10-17 04:20:31 | Singapore | ||||
595907 | 595907 | 2022-07-01 | US | New York | Monroe | 36055 | 170229 | 1644 | 0 | 43.14638895 | -77.69322942 | 2022-07-02 04:21:16 | Monroe, New York, US | |
974190 | 974190 | 2022-06-01 | US | Utah | Salt Lake | 49035 | 351997 | 1644 | 0 | 40.66616532 | -111.9216011 | 2022-06-02 05:20:39 | Salt Lake, Utah, US | |
232497 | 232497 | 2022-05-31 | US | Utah | Salt Lake | 49035 | 351997 | 1644 | 0 | 40.66616532 | -111.9216011 | 2022-06-01 04:20:55 | Salt Lake, Utah, US | |
3189262 | 3189262 | 2022-05-30 | US | Utah | Salt Lake | 49035 | 351997 | 1644 | 0 | 40.66616532 | -111.9216011 | 2022-05-31 04:20:51 | Salt Lake, Utah, US | |
3201411 | 3201411 | 2022-05-29 | US | Utah | Salt Lake | 49035 | 351997 | 1644 | 0 | 40.66616532 | -111.9216011 | 2022-05-30 04:20:50 | Salt Lake, Utah, US | |
2728289 | 2728289 | 2022-05-28 | US | Utah | Salt Lake | 49035 | 351997 | 1644 | 0 | 40.66616532 | -111.9216011 | 2022-05-29 04:20:53 | Salt Lake, Utah, US | |
1317470 | 1317470 | 2022-05-27 | US | Utah | Salt Lake | 49035 | 351997 | 1644 | 0 | 40.66616532 | -111.9216011 | 2022-05-28 04:21:07 | Salt Lake, Utah, US | |
1853262 | 1853262 | 2022-05-26 | US | Utah | Salt Lake | 49035 | 351997 | 1644 | 0 | 40.66616532 | -111.9216011 | 2022-05-27 04:20:56 | Salt Lake, Utah, US | |
2533986 | 2533986 | 2022-05-12 | US | California | Stanislaus | 6099 | 136664 | 1644 | 0 | 37.55862499 | -120.9970722 | 2022-05-13 04:20:51 | Stanislaus, California, US | |
3445432 | 3445432 | 2022-05-11 | US | California | Stanislaus | 6099 | 136504 | 1644 | 0 | 37.55862499 | -120.9970722 | 2022-05-12 04:20:54 | Stanislaus, California, US | |
3536049 | 3536049 | 2022-05-10 | US | California | Stanislaus | 6099 | 136485 | 1644 | 0 | 37.55862499 | -120.9970722 | 2022-05-11 04:20:48 | Stanislaus, California, US | |
3417312 | 3417312 | 2022-04-17 | US | Alabama | Mobile | 1097 | 113117 | 1644 | 0 | 30.78472347 | -88.20842409 | 2022-04-18 04:21:12 | Mobile, Alabama, US | |
304261 | 304261 | 2022-04-16 | US | Alabama | Mobile | 1097 | 113117 | 1644 | 0 | 30.78472347 | -88.20842409 | 2022-04-17 04:20:59 | Mobile, Alabama, US | |
2670206 | 2670206 | 2022-04-15 | US | Alabama | Mobile | 1097 | 113117 | 1644 | 0 | 30.78472347 | -88.20842409 | 2022-04-16 04:20:48 | Mobile, Alabama, US | |
3730005 | 3730005 | 2022-04-03 | Chile | Coquimbo | 123954 | 1644 | 0 | -29.959 | -71.3389 | 2022-04-04 04:20:51 | Coquimbo, Chile | |||
499858 | 499858 | 2022-04-02 | Russia | Arkhangelsk Oblast | 225415 | 1644 | 0 | 63.5589686 | 43.1221646 | 2022-04-03 04:20:48 | Arkhangelsk Oblast, Russia | |||
2263955 | 2263955 | 2022-03-14 | Malaysia | Sarawak | 279596 | 1644 | 0 | 1.5533 | 110.3592 | 2022-03-15 04:20:47 | Sarawak, Malaysia | |||
1301290 | 1301290 | 2022-02-17 | US | Texas | Travis | 48453 | 217494 | 1644 | 0 | 30.33432034 | -97.78535620000001 | 2022-02-18 04:21:04 | Travis, Texas, US | |
2012943 | 2012943 | 2022-02-06 | Russia | Orel Oblast | 82629 | 1644 | 0 | 52.96854329999999 | 36.0692477 | 2022-02-07 04:21:05 | Orel Oblast, Russia | |||
459158 | 459158 | 2022-02-02 | Chile | OHiggins | 85941 | 1644 | 0 | -34.5755 | -71.0022 | 2022-02-03 04:21:21 | OHiggins, Chile | |||
978727 | 978727 | 2022-02-01 | Chile | OHiggins | 84624 | 1644 | 0 | -34.5755 | -71.0022 | 2022-02-02 04:21:09 | OHiggins, Chile | |||
2657569 | 2657569 | 2022-01-31 | Chile | OHiggins | 83728 | 1644 | 0 | -34.5755 | -71.0022 | 2022-02-01 04:21:11 | OHiggins, Chile | |||
3299986 | 3299986 | 2022-01-30 | Chile | OHiggins | 82710 | 1644 | 0 | -34.5755 | -71.0022 | 2022-01-31 04:21:09 | OHiggins, Chile | |||
3064514 | 3064514 | 2022-01-29 | US | Ohio | Stark | 39151 | 78031 | 1644 | 0 | 40.81482476 | -81.36437305 | 2022-01-30 04:21:26 | Stark, Ohio, US | |
3061777 | 3061777 | 2022-01-29 | Chile | OHiggins | 81636 | 1644 | 0 | -34.5755 | -71.0022 | 2022-01-30 04:21:26 | OHiggins, Chile | |||
3809711 | 3809711 | 2022-01-28 | Chile | OHiggins | 80460 | 1644 | 0 | -34.5755 | -71.0022 | 2022-01-29 04:21:10 | OHiggins, Chile | |||
1779231 | 1779231 | 2022-01-27 | Colombia | Sucre | 63727 | 1644 | 0 | 8.814 | -74.7233 | 2022-01-28 04:21:09 | Sucre, Colombia | |||
1779165 | 1779165 | 2022-01-27 | Chile | OHiggins | 79455 | 1644 | 0 | -34.5755 | -71.0022 | 2022-01-28 04:21:09 | OHiggins, Chile | |||
3816674 | 3816674 | 2021-12-23 | Russia | Tambov Oblast | 59481 | 1644 | 0 | 52.9019574 | 41.3578918 | 2021-12-24 04:21:34 | Tambov Oblast, Russia | |||
1717952 | 1717952 | 2021-12-16 | US | Massachusetts | Bristol | 25005 | 95730 | 1644 | 0 | 41.79228404 | -71.10872211 | 2021-12-17 04:22:14 | Bristol, Massachusetts, US | |
3643119 | 3643119 | 2021-11-08 | US | Wisconsin | Milwaukee | 55079 | 153494 | 1644 | 0 | 43.00486062 | -87.96733172 | 2021-11-09 04:21:36 | Milwaukee, Wisconsin, US | |
2124294 | 2124294 | 2021-10-21 | US | California | Kern | 6029 | 145962 | 1644 | 0 | 35.34329425 | -118.72777959999999 | 2021-10-22 04:21:14 | Kern, California, US | |
2462439 | 2462439 | 2021-10-06 | Ukraine | Zakarpattia Oblast | 64308 | 1644 | 0 | 48.6208 | 22.2879 | 2021-10-07 04:21:36 | Zakarpattia Oblast, Ukraine | |||
986956 | 986956 | 2021-10-04 | Italy | Sardegna | 75426 | 1644 | 0 | 39.21531192 | 9.110616306 | 2021-10-05 04:21:27 | Sardegna, Italy | |||
1274266 | 1274266 | 2021-10-03 | Italy | Sardegna | 75390 | 1644 | 0 | 39.21531192 | 9.110616306 | 2021-10-04 04:21:31 | Sardegna, Italy | |||
32337 | 32337 | 2021-08-25 | Germany | Schleswig-Holstein | 70071 | 1644 | 0 | 54.2194 | 9.6961 | 2021-08-26 04:21:28 | Schleswig-Holstein, Germany | |||
3105376 | 3105376 | 2021-08-24 | Germany | Schleswig-Holstein | 69766 | 1644 | 0 | 54.2194 | 9.6961 | 2021-08-25 04:21:41 | Schleswig-Holstein, Germany | |||
103628 | 103628 | 2021-08-15 | Spain | Murcia | 132612 | 1644 | 0 | 37.9922 | -1.1307 | 2021-08-16 04:21:31 | Murcia, Spain | |||
103438 | 103438 | 2021-08-15 | Montenegro | 106196 | 1644 | 0 | 42.708678000000006 | 19.37439 | 2021-08-16 04:21:31 | Montenegro | ||||
507986 | 507986 | 2021-08-14 | Spain | Murcia | 132612 | 1644 | 0 | 37.9922 | -1.1307 | 2021-08-15 04:21:41 | Murcia, Spain | |||
1483858 | 1483858 | 2021-08-13 | Spain | Murcia | 132612 | 1644 | 0 | 37.9922 | -1.1307 | 2021-08-14 04:21:25 | Murcia, Spain | |||
3683688 | 3683688 | 2021-08-02 | Russia | Penza Oblast | 56668 | 1644 | 46416 | 8608 | 53.1655415 | 44.78791810000001 | 2021-08-03 04:21:39 | Penza Oblast, Russia | ||
2674010 | 2674010 | 2021-07-18 | Russia | Chuvashia Republic | 28380 | 1644 | 25858 | 878 | 55.4259922 | 47.0849429 | 2021-07-19 04:21:24 | Chuvashia Republic, Russia | ||
2075601 | 2075601 | 2021-07-02 | Malaysia | Selangor | 254545 | 1644 | 226982 | 25919 | 3.0738 | 101.5183 | 2021-07-03 04:21:37 | Selangor, Malaysia | ||
2888038 | 2888038 | 2021-06-20 | Zambia | 129033 | 1644 | 108960 | 18429 | -13.133897 | 27.849332 | 2021-06-21 04:21:41 | Zambia | |||
3472259 | 3472259 | 2021-06-08 | India | Puducherry | 110106 | 1644 | 101315 | 7147 | 11.882658 | 78.86498 | 2021-06-09 04:23:31 | Puducherry, India | ||
2315427 | 2315427 | 2021-06-04 | Netherlands | Limburg | 114404 | 1644 | 0 | 112516 | 51.209227 | 5.93387 | 2021-06-05 04:23:03 | Limburg, Netherlands | ||
1448666 | 1448666 | 2021-06-03 | Mexico | Chiapas | 11582 | 1644 | 0 | 9938 | 16.7569 | -93.1292 | 2021-06-04 04:23:37 | Chiapas, Mexico | ||
2104694 | 2104694 | 2021-06-01 | US | California | Sacramento | 6067 | 108083 | 1644 | 0 | 38.45106826 | -121.3425374 | 2021-06-02 04:24:34 | Sacramento, California, US | |
1189310 | 1189310 | 2021-05-31 | US | California | Sacramento | 6067 | 108026 | 1644 | 0 | 38.45106826 | -121.3425374 | 2021-06-01 04:23:09 | Sacramento, California, US | |
3089987 | 3089987 | 2021-05-30 | US | California | Sacramento | 6067 | 107998 | 1644 | 0 | 38.45106826 | -121.3425374 | 2021-05-31 03:08:59 | Sacramento, California, US | |
730136 | 730136 | 2021-05-22 | Ukraine | Vinnytsia Oblast | 70026 | 1644 | 61427 | 6955 | 49.2331 | 28.4682 | 2021-05-23 04:20:51 | Vinnytsia Oblast, Ukraine | ||
1956156 | 1956156 | 2021-05-21 | United Arab Emirates | 552920 | 1644 | 532910 | 18366 | 23.424076 | 53.847818 | 2021-05-22 04:20:45 | United Arab Emirates | |||
2450926 | 2450926 | 2021-05-02 | Peru | Ayacucho | 26481 | 1644 | 0 | 24837 | -14.091648 | -74.08344 | 2021-05-03 04:20:39 | Ayacucho, Peru | ||
1537640 | 1537640 | 2021-03-28 | US | Minnesota | Hennepin | 27053 | 106987 | 1644 | 0 | 45.00761521 | -93.47694895 | 2021-03-29 04:28:35 | Hennepin, Minnesota, US | |
1884606 | 1884606 | 2021-03-26 | Ukraine | Ivano-Frankivsk Oblast | 77797 | 1644 | 60211 | 15942 | 48.9226 | 24.7111 | 2021-03-27 05:25:04 | Ivano-Frankivsk Oblast, Ukraine | ||
1982840 | 1982840 | 2021-03-25 | US | New York | Erie | 36029 | 71439 | 1644 | 0 | 42.76249024 | -78.73063652 | 2021-03-26 05:26:55 | Erie, New York, US | |
2781133 | 2781133 | 2021-03-24 | Oman | 153105 | 1644 | 140220 | 11241 | 21.512583 | 55.92325500000001 | 2021-03-25 05:27:00 | Oman | |||
2359434 | 2359434 | 2021-03-08 | India | Telangana | 300153 | 1644 | 296740 | 1769 | 18.1124 | 79.0193 | 2021-03-09 05:28:19 | Telangana, India | ||
2286062 | 2286062 | 2021-02-14 | US | Pennsylvania | Allegheny | 42003 | 73384 | 1644 | 0 | 71740 | 40.46809875 | -79.98167747 | 2021-02-15 05:24:49 | Allegheny, Pennsylvania, US |
3978791 | 3978791 | 2021-02-10 | Russia | Krasnodar Krai | 35497 | 1644 | 27654 | 6199 | 45.7684014 | 39.0261044 | 2021-02-11 05:23:55 | Krasnodar Krai, Russia | ||
1459730 | 1459730 | 2021-01-31 | India | Uttarakhand | 96129 | 1644 | 93310 | 1175 | 30.156447 | 79.197608 | 2021-02-01 05:22:53 | Uttarakhand, India | ||
2567838 | 2567838 | 2021-01-25 | Peru | Ucayali | 21150 | 1644 | 0 | 19506 | -9.621718 | -73.444929 | 2021-01-26 05:22:02 | Ucayali, Peru | ||
1761470 | 1761470 | 2021-01-24 | US | New Jersey | Union | 34039 | 49404 | 1644 | 0 | 47760 | 40.65835409 | -74.30680092 | 2021-01-25 05:22:16 | Union, New Jersey, US |
3308357 | 3308357 | 2021-01-13 | Peru | Cajamarca | 26107 | 1644 | 0 | 24463 | -6.430284 | -78.74559599999998 | 2021-01-14 05:22:32 | Cajamarca, Peru | ||
927744 | 927744 | 2020-12-21 | Kenya | 94614 | 1644 | 76060 | 16910 | -0.0236 | 37.9062 | 2020-12-22 05:22:33 | Kenya | |||
3189834 | 3189834 | 2020-11-22 | Colombia | Cordoba | 27895 | 1644 | 25242 | 1009 | 8.0493 | -75.574 | 2020-11-23 05:25:26 | Cordoba, Colombia | ||
3836328 | 3836328 | 2020-11-21 | Colombia | Cordoba | 27875 | 1644 | 25169 | 1062 | 8.0493 | -75.574 | 2020-11-22 05:25:45 | Cordoba, Colombia | ||
2701356 | 2701356 | 2020-11-20 | Colombia | Cordoba | 27774 | 1644 | 25128 | 1002 | 8.0493 | -75.574 | 2020-11-21 05:25:51 | Cordoba, Colombia | ||
822287 | 822287 | 2020-11-19 | US | Florida | Palm Beach | 12099 | 60219 | 1644 | 0 | 58575 | 26.64676272 | -80.46536002 | 2020-11-20 05:26:28 | Palm Beach, Florida, US |
1452447 | 1452447 | 2020-10-27 | Colombia | Santander | 40604 | 1644 | 35656 | 3304 | 6.6437 | -73.6536 | 2020-10-28 04:24:39 | Santander, Colombia | ||
3786179 | 3786179 | 2020-10-11 | Spain | C. Valenciana | 45220 | 1644 | 9970 | 33606 | 39.484 | -0.7533 | 2020-10-12 04:23:45 | C. Valenciana, Spain | ||
2602317 | 2602317 | 2020-10-10 | Spain | C. Valenciana | 45220 | 1644 | 9970 | 33606 | 39.484 | -0.7533 | 2020-10-11 04:23:46 | C. Valenciana, Spain | ||
817850 | 817850 | 2020-10-09 | Spain | C. Valenciana | 45220 | 1644 | 9970 | 33606 | 39.484 | -0.7533 | 2020-10-10 04:23:57 | C. Valenciana, Spain | ||
1041927 | 1041927 | 2020-10-07 | Mexico | Yucatan | 19170 | 1644 | 16561 | 965 | 20.7099 | -89.0943 | 2020-10-08 04:23:56 | Yucatan, Mexico | ||
1045911 | 1045911 | 2020-09-30 | Mexico | Quintana Roo | 11849 | 1644 | 9736 | 469 | 19.1817 | -88.4791 | 2020-10-01 04:23:42 | Quintana Roo, Mexico | ||
1005901 | 1005901 | 2020-07-09 | Portugal | 45277 | 1644 | 30049 | 13584 | 39.3999 | -8.2245 | 2020-07-10 04:34:24 | Portugal | |||
887608 | 887608 | 2020-07-07 | Argentina | 83426 | 1644 | 30095 | 51687 | -38.4161 | -63.6167 | 2020-07-08 05:33:48 | Argentina | |||
1829467 | 1829467 | 2020-05-16 | Germany | Baden-Wurttemberg | 33893 | 1644 | 29700 | 2563 | 48.6616 | 9.3501 | 2020-05-17 02:32:32 | Baden-Wurttemberg, Germany |
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]);