johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where deaths = 2469 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1595855 | 1595855 | 2022-10-21 | Ukraine | Sevastopol* | 95503 | 2469 | 0 | 44.6054 | 33.522 | 2022-10-22 04:22:53 | Sevastopol*, Ukraine | |||
372452 | 372452 | 2022-09-13 | Russia | Tambov Oblast | 126638 | 2469 | 0 | 52.9019574 | 41.3578918 | 2022-09-14 04:20:44 | Tambov Oblast, Russia | |||
990991 | 990991 | 2022-08-16 | Japan | Hyogo | 760621 | 2469 | 0 | 35.039913 | 134.828057 | 2022-08-17 04:20:59 | Hyogo, Japan | |||
2741566 | 2741566 | 2022-07-07 | US | California | Kern | 6029 | 259925 | 2469 | 0 | 35.34329425 | -118.7277796 | 2022-07-08 04:20:56 | Kern, California, US | |
1200361 | 1200361 | 2022-07-06 | US | California | Kern | 6029 | 259925 | 2469 | 0 | 35.34329425 | -118.7277796 | 2022-07-07 04:20:55 | Kern, California, US | |
1199649 | 1199649 | 2022-07-06 | Colombia | Risaralda | 106985 | 2469 | 0 | 5.3158 | -75.9928 | 2022-07-07 04:20:55 | Risaralda, Colombia | |||
3967104 | 3967104 | 2022-07-05 | US | California | Kern | 6029 | 259925 | 2469 | 0 | 35.34329425 | -118.7277796 | 2022-07-06 04:20:58 | Kern, California, US | |
3966392 | 3966392 | 2022-07-05 | Colombia | Risaralda | 106985 | 2469 | 0 | 5.3158 | -75.9928 | 2022-07-06 04:20:58 | Risaralda, Colombia | |||
3077903 | 3077903 | 2022-07-04 | Colombia | Risaralda | 106985 | 2469 | 0 | 5.3158 | -75.9928 | 2022-07-05 04:20:45 | Risaralda, Colombia | |||
1767185 | 1767185 | 2022-07-03 | Colombia | Risaralda | 106985 | 2469 | 0 | 5.3158 | -75.9928 | 2022-07-04 04:20:54 | Risaralda, Colombia | |||
3365171 | 3365171 | 2022-07-02 | Colombia | Risaralda | 106985 | 2469 | 0 | 5.3158 | -75.9928 | 2022-07-03 04:20:59 | Risaralda, Colombia | |||
593500 | 593500 | 2022-07-01 | Colombia | Risaralda | 106985 | 2469 | 0 | 5.3158 | -75.9928 | 2022-07-02 04:21:16 | Risaralda, Colombia | |||
3939901 | 3939901 | 2022-06-30 | Colombia | Risaralda | 106985 | 2469 | 0 | 5.3158 | -75.9928 | 2022-07-01 04:21:10 | Risaralda, Colombia | |||
2489859 | 2489859 | 2022-06-29 | Colombia | Risaralda | 106782 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-30 04:21:01 | Risaralda, Colombia | |||
2239241 | 2239241 | 2022-06-28 | Colombia | Risaralda | 106782 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-29 04:20:59 | Risaralda, Colombia | |||
2147483 | 2147483 | 2022-06-27 | Colombia | Risaralda | 106782 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-28 04:20:58 | Risaralda, Colombia | |||
475284 | 475284 | 2022-06-26 | Colombia | Risaralda | 106782 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-27 04:21:00 | Risaralda, Colombia | |||
938659 | 938659 | 2022-06-25 | Colombia | Risaralda | 106782 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-26 04:21:02 | Risaralda, Colombia | |||
3346479 | 3346479 | 2022-06-24 | Colombia | Risaralda | 106782 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-25 04:20:57 | Risaralda, Colombia | |||
1648220 | 1648220 | 2022-06-23 | Colombia | Risaralda | 106782 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-24 04:20:58 | Risaralda, Colombia | |||
2187455 | 2187455 | 2022-06-22 | Colombia | Risaralda | 106672 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-23 04:20:55 | Risaralda, Colombia | |||
165886 | 165886 | 2022-06-21 | Colombia | Risaralda | 106672 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-22 04:20:54 | Risaralda, Colombia | |||
1763169 | 1763169 | 2022-06-20 | Colombia | Risaralda | 106672 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-21 04:20:56 | Risaralda, Colombia | |||
3269355 | 3269355 | 2022-06-19 | Colombia | Risaralda | 106672 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-20 04:21:01 | Risaralda, Colombia | |||
3397267 | 3397267 | 2022-06-18 | Colombia | Risaralda | 106672 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-19 04:20:51 | Risaralda, Colombia | |||
2311144 | 2311144 | 2022-06-17 | Colombia | Risaralda | 106672 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-18 04:21:10 | Risaralda, Colombia | |||
558648 | 558648 | 2022-06-16 | Colombia | Risaralda | 106672 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-17 04:20:56 | Risaralda, Colombia | |||
3982450 | 3982450 | 2022-06-15 | Colombia | Risaralda | 106540 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-16 04:20:55 | Risaralda, Colombia | |||
946691 | 946691 | 2022-06-14 | Colombia | Risaralda | 106540 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-15 04:20:54 | Risaralda, Colombia | |||
2979099 | 2979099 | 2022-06-13 | Colombia | Risaralda | 106540 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-14 04:20:52 | Risaralda, Colombia | |||
2235225 | 2235225 | 2022-06-12 | Colombia | Risaralda | 106540 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-13 04:21:14 | Risaralda, Colombia | |||
3141423 | 3141423 | 2022-06-11 | Colombia | Risaralda | 106540 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-12 04:20:53 | Risaralda, Colombia | |||
1944339 | 1944339 | 2022-06-10 | Colombia | Risaralda | 106540 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-11 04:21:01 | Risaralda, Colombia | |||
3157478 | 3157478 | 2022-06-09 | Colombia | Risaralda | 106540 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-10 04:20:55 | Risaralda, Colombia | |||
1420945 | 1420945 | 2022-06-08 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-09 04:20:54 | Risaralda, Colombia | |||
3726059 | 3726059 | 2022-06-07 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-08 04:20:55 | Risaralda, Colombia | |||
3887461 | 3887461 | 2022-06-06 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-07 04:21:08 | Risaralda, Colombia | |||
3507366 | 3507366 | 2022-06-05 | Italy | Sardegna | 315493 | 2469 | 0 | 39.21531192 | 9.110616306 | 2022-06-06 04:20:57 | Sardegna, Italy | |||
3507230 | 3507230 | 2022-06-05 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-06 04:20:57 | Risaralda, Colombia | |||
3527307 | 3527307 | 2022-06-04 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-05 04:20:55 | Risaralda, Colombia | |||
3133393 | 3133393 | 2022-06-03 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-04 04:20:58 | Risaralda, Colombia | |||
3578468 | 3578468 | 2022-06-02 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-03 04:20:58 | Risaralda, Colombia | |||
970761 | 970761 | 2022-06-01 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-02 05:20:39 | Risaralda, Colombia | |||
229068 | 229068 | 2022-05-31 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-06-01 04:20:55 | Risaralda, Colombia | |||
3185833 | 3185833 | 2022-05-30 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-31 04:20:51 | Risaralda, Colombia | |||
3197982 | 3197982 | 2022-05-29 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-30 04:20:50 | Risaralda, Colombia | |||
2724860 | 2724860 | 2022-05-28 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-29 04:20:53 | Risaralda, Colombia | |||
1314041 | 1314041 | 2022-05-27 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-28 04:21:07 | Risaralda, Colombia | |||
1849833 | 1849833 | 2022-05-26 | Colombia | Risaralda | 106502 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-27 04:20:56 | Risaralda, Colombia | |||
2047709 | 2047709 | 2022-05-25 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-26 04:20:50 | Risaralda, Colombia | |||
2999147 | 2999147 | 2022-05-24 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-25 04:20:56 | Risaralda, Colombia | |||
3592868 | 3592868 | 2022-05-23 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-24 04:20:57 | Risaralda, Colombia | |||
621720 | 621720 | 2022-05-22 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-26 04:20:50 | Risaralda, Colombia | |||
1109416 | 1109416 | 2022-05-21 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-22 04:20:52 | Risaralda, Colombia | |||
1169040 | 1169040 | 2022-05-20 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-21 04:20:58 | Risaralda, Colombia | |||
3895803 | 3895803 | 2022-05-19 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-20 04:20:57 | Risaralda, Colombia | |||
1184587 | 1184587 | 2022-05-18 | Colombia | Risaralda | 106466 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-19 04:20:54 | Risaralda, Colombia | |||
3582484 | 3582484 | 2022-05-17 | Colombia | Risaralda | 106466 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-18 04:20:50 | Risaralda, Colombia | |||
1503441 | 1503441 | 2022-05-16 | Colombia | Risaralda | 106466 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-17 04:20:59 | Risaralda, Colombia | |||
2083800 | 2083800 | 2022-05-15 | Colombia | Risaralda | 106466 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-16 04:20:47 | Risaralda, Colombia | |||
3354511 | 3354511 | 2022-05-14 | Colombia | Risaralda | 106466 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-15 04:20:53 | Risaralda, Colombia | |||
658156 | 658156 | 2022-05-13 | Colombia | Risaralda | 106466 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-14 04:20:48 | Risaralda, Colombia | |||
2533239 | 2533239 | 2022-05-12 | Colombia | Risaralda | 106466 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-13 04:20:51 | Risaralda, Colombia | |||
3444685 | 3444685 | 2022-05-11 | Colombia | Risaralda | 106440 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-12 04:20:54 | Risaralda, Colombia | |||
3535302 | 3535302 | 2022-05-10 | Colombia | Risaralda | 106440 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-11 04:20:48 | Risaralda, Colombia | |||
222217 | 222217 | 2022-05-09 | Russia | Kursk Oblast | 117526 | 2469 | 0 | 51.6568453 | 36.4852695 | 2022-05-10 04:20:50 | Kursk Oblast, Russia | |||
221837 | 221837 | 2022-05-09 | Colombia | Risaralda | 106440 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-10 04:20:50 | Risaralda, Colombia | |||
2331222 | 2331222 | 2022-05-08 | Colombia | Risaralda | 106440 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-09 04:20:54 | Risaralda, Colombia | |||
360184 | 360184 | 2022-05-07 | Colombia | Risaralda | 106440 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-08 04:20:49 | Risaralda, Colombia | |||
1397535 | 1397535 | 2022-05-06 | Colombia | Risaralda | 106440 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-07 04:21:09 | Risaralda, Colombia | |||
2597890 | 2597890 | 2022-05-05 | Colombia | Risaralda | 106440 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-06 04:21:00 | Risaralda, Colombia | |||
3265339 | 3265339 | 2022-05-04 | Colombia | Risaralda | 106410 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-05 04:20:55 | Risaralda, Colombia | |||
1571978 | 1571978 | 2022-05-03 | Colombia | Risaralda | 106410 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-04 04:20:59 | Risaralda, Colombia | |||
464969 | 464969 | 2022-05-02 | US | Maryland | Baltimore | 24005 | 133826 | 2469 | 0 | 39.45784712 | -76.62911955 | 2022-05-03 04:21:00 | Baltimore, Maryland, US | |
463238 | 463238 | 2022-05-02 | Colombia | Risaralda | 106410 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-03 04:21:00 | Risaralda, Colombia | |||
3915877 | 3915877 | 2022-05-01 | Colombia | Risaralda | 106410 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-02 04:21:10 | Risaralda, Colombia | |||
2840681 | 2840681 | 2022-04-30 | Colombia | Risaralda | 106410 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-01 04:20:57 | Risaralda, Colombia | |||
1156994 | 1156994 | 2022-04-29 | Colombia | Risaralda | 106410 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-30 04:21:05 | Risaralda, Colombia | |||
1696176 | 1696176 | 2022-04-28 | Colombia | Risaralda | 106409 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-29 04:20:59 | Risaralda, Colombia | |||
3851659 | 3851659 | 2022-04-27 | Colombia | Risaralda | 106409 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-28 04:20:47 | Risaralda, Colombia | |||
1326089 | 1326089 | 2022-04-26 | Colombia | Risaralda | 106408 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-27 04:20:52 | Risaralda, Colombia | |||
3722043 | 3722043 | 2022-04-25 | Colombia | Risaralda | 106401 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-26 04:20:51 | Risaralda, Colombia | |||
2028611 | 2028611 | 2022-04-24 | Colombia | Risaralda | 106389 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-25 04:20:56 | Risaralda, Colombia | |||
746186 | 746186 | 2022-04-23 | Colombia | Risaralda | 106387 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-24 04:20:56 | Risaralda, Colombia | |||
3436671 | 3436671 | 2022-04-22 | Colombia | Risaralda | 106382 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-23 04:20:50 | Risaralda, Colombia | |||
2892256 | 2892256 | 2022-04-21 | Colombia | Risaralda | 106377 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-22 04:20:45 | Risaralda, Colombia | |||
2307128 | 2307128 | 2022-04-20 | Colombia | Risaralda | 106376 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-21 04:20:46 | Risaralda, Colombia | |||
2251267 | 2251267 | 2022-04-19 | Colombia | Risaralda | 106368 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-20 04:20:45 | Risaralda, Colombia | |||
1845872 | 1845872 | 2022-04-18 | Germany | Hamburg | 493774 | 2469 | 0 | 53.5511 | 9.9937 | 2022-04-19 04:21:00 | Hamburg, Germany | |||
1845817 | 1845817 | 2022-04-18 | Colombia | Risaralda | 106364 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-19 04:21:00 | Risaralda, Colombia | |||
3416816 | 3416816 | 2022-04-17 | Germany | Hamburg | 493774 | 2469 | 0 | 53.5511 | 9.9937 | 2022-04-18 04:21:12 | Hamburg, Germany | |||
3416761 | 3416761 | 2022-04-17 | Colombia | Risaralda | 106364 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-18 04:21:12 | Risaralda, Colombia | |||
303765 | 303765 | 2022-04-16 | Germany | Hamburg | 493774 | 2469 | 0 | 53.5511 | 9.9937 | 2022-04-17 04:20:59 | Hamburg, Germany | |||
303710 | 303710 | 2022-04-16 | Colombia | Risaralda | 106359 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-17 04:20:59 | Risaralda, Colombia | |||
2669710 | 2669710 | 2022-04-15 | Germany | Hamburg | 493774 | 2469 | 0 | 53.5511 | 9.9937 | 2022-04-16 04:20:48 | Hamburg, Germany | |||
2669655 | 2669655 | 2022-04-15 | Colombia | Risaralda | 106354 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-16 04:20:48 | Risaralda, Colombia | |||
1223495 | 1223495 | 2022-04-14 | Germany | Hamburg | 493774 | 2469 | 0 | 53.5511 | 9.9937 | 2022-04-15 04:20:57 | Hamburg, Germany | |||
1223440 | 1223440 | 2022-04-14 | Colombia | Risaralda | 106345 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-15 04:20:57 | Risaralda, Colombia | |||
2442598 | 2442598 | 2022-04-13 | Colombia | Risaralda | 106343 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-13 23:21:06 | Risaralda, Colombia | |||
1948355 | 1948355 | 2022-04-12 | Colombia | Risaralda | 106343 | 2469 | 0 | 5.3158 | -75.9928 | 2022-04-13 04:21:03 | Risaralda, Colombia |
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]);