johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
125 rows where deaths = 1602 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3280207 | 3280207 | 2022-10-23 | US | Virginia | Fairfax | 51059 | 239175 | 1602 | 0 | 38.83677558 | -77.27565836 | 2022-10-24 04:22:29 | Fairfax, Virginia, US | |
2271245 | 2271245 | 2022-10-22 | US | Virginia | Fairfax | 51059 | 239175 | 1602 | 0 | 38.83677558 | -77.27565836 | 2022-10-23 04:22:46 | Fairfax, Virginia, US | |
1595545 | 1595545 | 2022-10-21 | US | Virginia | Fairfax | 51059 | 239175 | 1602 | 0 | 38.83677558 | -77.27565836 | 2022-10-22 04:22:53 | Fairfax, Virginia, US | |
372480 | 372480 | 2022-09-13 | Singapore | 1864742 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-14 04:20:44 | Singapore | ||||
2395083 | 2395083 | 2022-09-12 | Singapore | 1861390 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-13 04:20:57 | Singapore | ||||
3766161 | 3766161 | 2022-09-11 | Singapore | 1859937 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-12 04:20:58 | Singapore | ||||
3824736 | 3824736 | 2022-09-10 | Singapore | 1858497 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-11 04:20:50 | Singapore | ||||
963193 | 963193 | 2022-09-09 | Singapore | 1856673 | 1602 | 0 | 1.2833 | 103.8333 | 2022-09-10 04:21:10 | Singapore | ||||
2855040 | 2855040 | 2022-08-22 | US | New Jersey | Morris | 34027 | 145436 | 1602 | 0 | 40.86095313 | -74.5455371 | 2022-08-23 04:20:56 | Morris, New Jersey, US | |
2405012 | 2405012 | 2022-08-21 | US | New Jersey | Morris | 34027 | 145399 | 1602 | 0 | 40.86095313 | -74.5455371 | 2022-08-22 04:20:38 | Morris, New Jersey, US | |
3800090 | 3800090 | 2022-08-20 | US | New Jersey | Morris | 34027 | 145310 | 1602 | 0 | 40.86095313 | -74.5455371 | 2022-08-21 04:20:44 | Morris, New Jersey, US | |
2365676 | 2365676 | 2022-08-19 | US | New Jersey | Morris | 34027 | 145189 | 1602 | 0 | 40.86095313 | -74.5455371 | 2022-08-20 04:21:01 | Morris, New Jersey, US | |
3545142 | 3545142 | 2022-08-08 | US | Michigan | Kent | 26081 | 183394 | 1602 | 0 | 43.03197711 | -85.54934642 | 2022-08-09 04:20:34 | Kent, Michigan, US | |
1071545 | 1071545 | 2022-08-07 | US | Michigan | Kent | 26081 | 183394 | 1602 | 0 | 43.03197711 | -85.54934642 | 2022-08-08 04:21:08 | Kent, Michigan, US | |
1942133 | 1942133 | 2022-08-06 | US | Michigan | Kent | 26081 | 183394 | 1602 | 0 | 43.03197711 | -85.54934642 | 2022-08-07 04:20:54 | Kent, Michigan, US | |
881932 | 881932 | 2022-08-05 | US | Michigan | Kent | 26081 | 183394 | 1602 | 0 | 43.03197711 | -85.54934642 | 2022-08-06 04:20:56 | Kent, Michigan, US | |
2010343 | 2010343 | 2022-08-04 | US | Michigan | Kent | 26081 | 183394 | 1602 | 0 | 43.03197711 | -85.54934642 | 2022-08-05 04:20:52 | Kent, Michigan, US | |
1099770 | 1099770 | 2022-08-03 | US | Michigan | Kent | 26081 | 183394 | 1602 | 0 | 43.03197711 | -85.54934642 | 2022-08-04 04:20:58 | Kent, Michigan, US | |
1406695 | 1406695 | 2022-08-02 | US | Michigan | Kent | 26081 | 183394 | 1602 | 0 | 43.03197711 | -85.54934642 | 2022-08-03 04:20:59 | Kent, Michigan, US | |
231475 | 231475 | 2022-05-31 | US | New York | Monroe | 36055 | 167635 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-06-01 04:20:55 | Monroe, New York, US | |
229246 | 229246 | 2022-05-31 | Japan | Saitama | 550538 | 1602 | 0 | 35.997101 | 139.347635 | 2022-06-01 04:20:55 | Saitama, Japan | |||
3188240 | 3188240 | 2022-05-30 | US | New York | Monroe | 36055 | 167182 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-31 04:20:51 | Monroe, New York, US | |
3200389 | 3200389 | 2022-05-29 | US | New York | Monroe | 36055 | 167182 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-30 04:20:50 | Monroe, New York, US | |
2727267 | 2727267 | 2022-05-28 | US | New York | Monroe | 36055 | 167182 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-29 04:20:53 | Monroe, New York, US | |
1316448 | 1316448 | 2022-05-27 | US | New York | Monroe | 36055 | 167182 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-28 04:21:07 | Monroe, New York, US | |
1852240 | 1852240 | 2022-05-26 | US | New York | Monroe | 36055 | 167014 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-27 04:20:56 | Monroe, New York, US | |
2050116 | 2050116 | 2022-05-25 | US | New York | Monroe | 36055 | 166806 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-26 04:20:50 | Monroe, New York, US | |
3001554 | 3001554 | 2022-05-24 | US | New York | Monroe | 36055 | 166582 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-25 04:20:56 | Monroe, New York, US | |
624127 | 624127 | 2022-05-22 | US | New York | Monroe | 36055 | 166806 | 1602 | 0 | 43.14638895 | -77.69322942 | 2022-05-26 04:20:50 | Monroe, New York, US | |
1908466 | 1908466 | 2022-03-22 | US | Utah | Salt Lake | 49035 | 340797 | 1602 | 0 | 40.66616532 | -111.92160109999999 | 2022-03-23 04:20:48 | Salt Lake, Utah, US | |
3628350 | 3628350 | 2022-03-13 | US | Alabama | Mobile | 1097 | 112899 | 1602 | 0 | 30.78472347 | -88.20842409 | 2022-03-14 04:20:46 | Mobile, Alabama, US | |
951258 | 951258 | 2022-03-12 | US | Alabama | Mobile | 1097 | 112899 | 1602 | 0 | 30.78472347 | -88.20842409 | 2022-03-13 04:20:49 | Mobile, Alabama, US | |
356719 | 356719 | 2022-03-11 | US | Alabama | Mobile | 1097 | 112899 | 1602 | 0 | 30.78472347 | -88.20842409 | 2022-03-12 04:20:50 | Mobile, Alabama, US | |
1865538 | 1865538 | 2022-03-10 | Malaysia | Perak | 164623 | 1602 | 0 | 4.5921 | 101.0901 | 2022-03-11 04:20:50 | Perak, Malaysia | |||
3046383 | 3046383 | 2022-02-26 | Russia | Kaliningrad Oblast | 141213 | 1602 | 0 | 54.7293041 | 21.1489473 | 2022-02-27 04:21:04 | Kaliningrad Oblast, Russia | |||
3720372 | 3720372 | 2022-02-21 | US | New Mexico | Bernalillo | 35001 | 143815 | 1602 | 0 | 35.05163625 | -106.6703554 | 2022-02-22 04:21:01 | Bernalillo, New Mexico, US | |
233009 | 233009 | 2022-02-11 | Chile | Araucania | 145086 | 1602 | 0 | -38.9489 | -72.3311 | 2022-02-12 04:21:06 | Araucania, Chile | |||
3077283 | 3077283 | 2022-02-09 | US | Texas | Travis | 48453 | 215204 | 1602 | 0 | 30.33432034 | -97.78535620000001 | 2022-02-10 04:21:14 | Travis, Texas, US | |
1362104 | 1362104 | 2022-02-08 | Canada | Manitoba | 124148 | 1602 | 0 | 53.7609 | -98.8139 | 2022-02-09 04:21:04 | Manitoba, Canada | |||
2051863 | 2051863 | 2022-01-25 | Italy | Umbria | 145098 | 1602 | 0 | 43.10675841 | 12.38824698 | 2022-01-26 04:21:07 | Umbria, Italy | |||
1227850 | 1227850 | 2022-01-24 | Russia | Orel Oblast | 74568 | 1602 | 0 | 52.96854329999999 | 36.0692477 | 2022-01-25 04:21:05 | Orel Oblast, Russia | |||
1472929 | 1472929 | 2022-01-17 | US | Georgia | Gwinnett | 13135 | 180620 | 1602 | 0 | 33.96044201 | -84.02137802 | 2022-01-18 04:21:04 | Gwinnett, Georgia, US | |
1113416 | 1113416 | 2022-01-11 | Colombia | Cauca | 60571 | 1602 | 0 | 2.705 | -76.82600000000002 | 2022-01-12 04:21:44 | Cauca, Colombia | |||
1692144 | 1692144 | 2022-01-10 | Colombia | Cauca | 59767 | 1602 | 0 | 2.705 | -76.82600000000002 | 2022-01-11 04:22:01 | Cauca, Colombia | |||
126559 | 126559 | 2022-01-09 | Colombia | Cauca | 59767 | 1602 | 0 | 2.705 | -76.82600000000002 | 2022-01-10 04:22:07 | Cauca, Colombia | |||
1077988 | 1077988 | 2021-12-09 | Malaysia | Sarawak | 251501 | 1602 | 0 | 1.5533 | 110.3592 | 2021-12-10 04:22:28 | Sarawak, Malaysia | |||
404505 | 404505 | 2021-12-07 | Russia | Kemerovo Oblast | 76600 | 1602 | 0 | 54.53357809999999 | 87.342861 | 2021-12-08 04:22:46 | Kemerovo Oblast, Russia | |||
1231408 | 1231408 | 2021-11-28 | Chile | OHiggins | 72149 | 1602 | 0 | -34.5755 | -71.0022 | 2021-11-29 04:22:30 | OHiggins, Chile | |||
1323837 | 1323837 | 2021-11-14 | US | Massachusetts | Suffolk | 25025 | 109609 | 1602 | 0 | 42.327951399999996 | -71.07850442 | 2021-11-15 04:21:36 | Suffolk, Massachusetts, US | |
687963 | 687963 | 2021-11-13 | US | Massachusetts | Suffolk | 25025 | 109609 | 1602 | 0 | 42.327951399999996 | -71.07850442 | 2021-11-14 04:21:31 | Suffolk, Massachusetts, US | |
716072 | 716072 | 2021-11-12 | US | Massachusetts | Suffolk | 25025 | 109609 | 1602 | 0 | 42.327951399999996 | -71.07850442 | 2021-11-13 04:21:38 | Suffolk, Massachusetts, US | |
30022 | 30022 | 2021-11-11 | US | Massachusetts | Suffolk | 25025 | 109231 | 1602 | 0 | 42.327951399999996 | -71.07850442 | 2021-11-12 04:22:01 | Suffolk, Massachusetts, US | |
2846461 | 2846461 | 2021-11-10 | US | Massachusetts | Suffolk | 25025 | 109231 | 1602 | 0 | 42.327951399999996 | -71.07850442 | 2021-11-11 04:21:45 | Suffolk, Massachusetts, US | |
2846275 | 2846275 | 2021-11-10 | US | Kentucky | Jefferson | 21111 | 122299 | 1602 | 0 | 38.18664655 | -85.65931031 | 2021-11-11 04:21:45 | Jefferson, Kentucky, US | |
2618295 | 2618295 | 2021-09-17 | Russia | Tver Oblast | 63939 | 1602 | 0 | 57.1134475 | 35.174442799999994 | 2021-09-18 04:21:24 | Tver Oblast, Russia | |||
2351198 | 2351198 | 2021-08-10 | Cambodia | 82898 | 1602 | 0 | 11.55 | 104.9167 | 2021-08-11 04:21:58 | Cambodia | ||||
3904210 | 3904210 | 2021-07-31 | Russia | Penza Oblast | 56206 | 1602 | 46335 | 8269 | 53.1655415 | 44.78791810000001 | 2021-08-01 04:21:50 | Penza Oblast, Russia | ||
409876 | 409876 | 2021-07-28 | US | Maryland | Prince George's | 24033 | 86487 | 1602 | 0 | 38.83070039 | -76.8496441 | 2021-07-29 04:21:33 | Prince George's, Maryland, US | |
1307737 | 1307737 | 2021-07-27 | US | Maryland | Prince George's | 24033 | 86404 | 1602 | 0 | 38.83070039 | -76.8496441 | 2021-07-28 04:21:39 | Prince George's, Maryland, US | |
3219880 | 3219880 | 2021-07-26 | US | Maryland | Prince George's | 24033 | 86343 | 1602 | 0 | 38.83070039 | -76.8496441 | 2021-07-27 04:21:18 | Prince George's, Maryland, US | |
1380089 | 1380089 | 2021-07-25 | US | Maryland | Prince George's | 24033 | 86286 | 1602 | 0 | 38.83070039 | -76.8496441 | 2021-07-26 04:21:28 | Prince George's, Maryland, US | |
1331829 | 1331829 | 2021-07-24 | US | Maryland | Prince George's | 24033 | 86236 | 1602 | 0 | 38.83070039 | -76.8496441 | 2021-07-25 04:22:12 | Prince George's, Maryland, US | |
3139133 | 3139133 | 2021-07-23 | US | Maryland | Prince George's | 24033 | 86175 | 1602 | 0 | 38.83070039 | -76.8496441 | 2021-07-24 00:21:36 | Prince George's, Maryland, US | |
3137407 | 3137407 | 2021-07-23 | Colombia | Quindio | 53323 | 1602 | 50752 | 969 | 4.461 | -75.6674 | 2021-07-24 00:21:36 | Quindio, Colombia | ||
3477893 | 3477893 | 2021-07-22 | US | Maryland | Prince George's | 24033 | 86125 | 1602 | 0 | 38.83070039 | -76.8496441 | 2021-07-23 04:21:29 | Prince George's, Maryland, US | |
3476504 | 3476504 | 2021-07-22 | Russia | Buryatia Republic | 50396 | 1602 | 45838 | 2956 | 52.7182426 | 109.492143 | 2021-07-23 04:21:29 | Buryatia Republic, Russia | ||
3476167 | 3476167 | 2021-07-22 | Colombia | Quindio | 53323 | 1602 | 50752 | 969 | 4.461 | -75.6674 | 2021-07-23 04:21:29 | Quindio, Colombia | ||
3631869 | 3631869 | 2021-07-14 | Germany | Hamburg | 77724 | 1602 | 75700 | 473 | 53.5511 | 9.9937 | 2021-07-15 04:21:48 | Hamburg, Germany | ||
578744 | 578744 | 2021-07-13 | Germany | Hamburg | 77689 | 1602 | 75600 | 525 | 53.5511 | 9.9937 | 2021-07-14 04:21:35 | Hamburg, Germany | ||
3740993 | 3740993 | 2021-07-12 | Germany | Hamburg | 77670 | 1602 | 75600 | 490 | 53.5511 | 9.9937 | 2021-07-13 04:21:18 | Hamburg, Germany | ||
2426533 | 2426533 | 2021-06-23 | Ukraine | Zakarpattia Oblast | 62055 | 1602 | 60084 | 369 | 48.6208 | 22.2879 | 2021-06-24 04:21:55 | Zakarpattia Oblast, Ukraine | ||
2339508 | 2339508 | 2021-06-15 | Montenegro | 99988 | 1602 | 97980 | 406 | 42.708678000000006 | 19.37439 | 2021-06-16 04:22:32 | Montenegro | |||
1564204 | 1564204 | 2021-06-14 | Montenegro | 99964 | 1602 | 97951 | 411 | 42.708678000000006 | 19.37439 | 2021-06-15 04:22:22 | Montenegro | |||
3145881 | 3145881 | 2021-06-07 | Spain | Murcia | 113470 | 1602 | 2180 | 109688 | 37.9922 | -1.1307 | 2021-06-08 04:22:35 | Murcia, Spain | ||
825883 | 825883 | 2021-06-06 | Spain | Murcia | 113352 | 1602 | 2180 | 109570 | 37.9922 | -1.1307 | 2021-06-07 04:22:51 | Murcia, Spain | ||
2586288 | 2586288 | 2021-06-05 | Spain | Murcia | 113352 | 1602 | 2180 | 109570 | 37.9922 | -1.1307 | 2021-06-06 04:24:03 | Murcia, Spain | ||
2315602 | 2315602 | 2021-06-04 | Spain | Murcia | 113352 | 1602 | 2180 | 109570 | 37.9922 | -1.1307 | 2021-06-05 04:23:03 | Murcia, Spain | ||
2315223 | 2315223 | 2021-06-04 | Germany | Schleswig-Holstein | 63283 | 1602 | 60800 | 921 | 54.2194 | 9.6961 | 2021-06-05 04:23:03 | Schleswig-Holstein, Germany | ||
1448887 | 1448887 | 2021-06-03 | Spain | Murcia | 113278 | 1602 | 2180 | 109496 | 37.9922 | -1.1307 | 2021-06-04 04:23:37 | Murcia, Spain | ||
1708611 | 1708611 | 2021-06-02 | Spain | Murcia | 113200 | 1602 | 2180 | 109418 | 37.9922 | -1.1307 | 2021-06-03 04:23:32 | Murcia, Spain | ||
52369 | 52369 | 2021-05-29 | US | Maryland | Montgomery | 24031 | 70806 | 1602 | 0 | 39.13676329 | -77.20358245 | 2021-05-30 04:20:55 | Montgomery, Maryland, US | |
21948 | 21948 | 2021-05-28 | US | Maryland | Montgomery | 24031 | 70789 | 1602 | 0 | 39.13676329 | -77.20358245 | 2021-05-29 04:20:41 | Montgomery, Maryland, US | |
1771093 | 1771093 | 2021-05-23 | Brazil | Roraima | 102102 | 1602 | 94757 | 5660 | -2.7376 | -62.0751 | 2021-05-24 04:20:53 | Roraima, Brazil | ||
726248 | 726248 | 2021-05-22 | Brazil | Roraima | 102019 | 1602 | 94757 | 5438 | -2.7376 | -62.0751 | 2021-05-23 04:20:51 | Roraima, Brazil | ||
1952263 | 1952263 | 2021-05-21 | Brazil | Roraima | 101797 | 1602 | 94757 | 5047 | -2.7376 | -62.0751 | 2021-05-22 04:20:45 | Roraima, Brazil | ||
1424867 | 1424867 | 2021-05-09 | Canada | British Columbia | 134341 | 1602 | 125799 | 6940 | 53.7267 | -127.6476 | 2021-05-10 04:20:38 | British Columbia, Canada | ||
1554139 | 1554139 | 2021-05-08 | US | New Jersey | Monmouth | 34025 | 74839 | 1602 | 0 | 40.26549699 | -74.22240686 | 2021-05-09 04:20:35 | Monmouth, New Jersey, US | |
1552143 | 1552143 | 2021-05-08 | Peru | Tacna | 23763 | 1602 | 0 | 22161 | -17.644160999999997 | -70.27756 | 2021-05-09 04:20:35 | Tacna, Peru | ||
1551735 | 1551735 | 2021-05-08 | Canada | British Columbia | 134341 | 1602 | 125799 | 6940 | 53.7267 | -127.6476 | 2021-05-09 04:20:35 | British Columbia, Canada | ||
2502153 | 2502153 | 2021-05-07 | Netherlands | Limburg | 105394 | 1602 | 0 | 103596 | 51.209227 | 5.93387 | 2021-05-08 04:21:04 | Limburg, Netherlands | ||
2501793 | 2501793 | 2021-05-07 | Canada | British Columbia | 134341 | 1602 | 125799 | 6940 | 53.7267 | -127.6476 | 2021-05-08 04:21:04 | British Columbia, Canada | ||
2761483 | 2761483 | 2021-05-03 | US | California | Sacramento | 6067 | 104964 | 1602 | 0 | 38.45106826 | -121.3425374 | 2021-05-04 04:20:34 | Sacramento, California, US | |
2453805 | 2453805 | 2021-05-02 | US | Texas | Cameron | 48061 | 44281 | 1602 | 0 | 26.14524221 | -97.48140372 | 2021-05-03 04:20:39 | Cameron, Texas, US | |
2451336 | 2451336 | 2021-05-02 | US | California | Sacramento | 6067 | 104806 | 1602 | 0 | 38.45106826 | -121.3425374 | 2021-05-03 04:20:39 | Sacramento, California, US | |
2827818 | 2827818 | 2021-05-01 | US | Texas | Cameron | 48061 | 44281 | 1602 | 0 | 26.14524221 | -97.48140372 | 2021-05-02 04:20:48 | Cameron, Texas, US | |
2825349 | 2825349 | 2021-05-01 | US | California | Sacramento | 6067 | 104695 | 1602 | 0 | 38.45106826 | -121.3425374 | 2021-05-02 04:20:48 | Sacramento, California, US | |
383226 | 383226 | 2021-04-30 | US | Texas | Cameron | 48061 | 44216 | 1602 | 0 | 26.14524221 | -97.48140372 | 2021-05-01 04:20:47 | Cameron, Texas, US | |
1639349 | 1639349 | 2021-04-29 | US | Texas | Cameron | 48061 | 44179 | 1602 | 0 | 26.14524221 | -97.48140372 | 2021-04-30 04:21:03 | Cameron, Texas, US | |
3396428 | 3396428 | 2021-04-28 | US | Texas | Cameron | 48061 | 44099 | 1602 | 0 | 26.14524221 | -97.48140372 | 2021-04-29 04:20:55 | Cameron, Texas, US | |
3705144 | 3705144 | 2021-04-27 | US | Texas | Cameron | 48061 | 44009 | 1602 | 0 | 26.14524221 | -97.48140372 | 2021-04-28 04:20:32 | Cameron, Texas, US |
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]);