johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where deaths = 1478 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348915 | 348915 | 2022-12-14 | US | Colorado | Denver | 8031 | 218923 | 1478 | 0 | 39.76018276 | -104.8725695 | 2022-12-15 04:20:58 | Denver, Colorado, US | |
308503 | 308503 | 2022-12-13 | US | Colorado | Denver | 8031 | 218804 | 1478 | 0 | 39.76018276 | -104.8725695 | 2022-12-14 04:21:04 | Denver, Colorado, US | |
541244 | 541244 | 2022-10-26 | US | Ohio | Lucas | 39095 | 118910 | 1478 | 0 | 41.62101218 | -83.65468618 | 2022-10-27 04:22:01 | Lucas, Ohio, US | |
1832645 | 1832645 | 2022-10-25 | US | Ohio | Lucas | 39095 | 118910 | 1478 | 0 | 41.62101218 | -83.65468618 | 2022-10-26 04:22:19 | Lucas, Ohio, US | |
796906 | 796906 | 2022-10-24 | US | Ohio | Lucas | 39095 | 118910 | 1478 | 0 | 41.62101218 | -83.65468618 | 2022-10-25 04:21:53 | Lucas, Ohio, US | |
3279361 | 3279361 | 2022-10-23 | US | Ohio | Lucas | 39095 | 118910 | 1478 | 0 | 41.62101218 | -83.65468618 | 2022-10-24 04:22:29 | Lucas, Ohio, US | |
3277884 | 3277884 | 2022-10-23 | US | Illinois | Lake | 17097 | 194280 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-24 04:22:29 | Lake, Illinois, US | |
2270399 | 2270399 | 2022-10-22 | US | Ohio | Lucas | 39095 | 118910 | 1478 | 0 | 41.62101218 | -83.65468618 | 2022-10-23 04:22:46 | Lucas, Ohio, US | |
2268922 | 2268922 | 2022-10-22 | US | Illinois | Lake | 17097 | 194280 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-23 04:22:46 | Lake, Illinois, US | |
1594699 | 1594699 | 2022-10-21 | US | Ohio | Lucas | 39095 | 118910 | 1478 | 0 | 41.62101218 | -83.65468618 | 2022-10-22 04:22:53 | Lucas, Ohio, US | |
1593222 | 1593222 | 2022-10-21 | US | Illinois | Lake | 17097 | 194280 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-22 04:22:53 | Lake, Illinois, US | |
2272938 | 2272938 | 2022-10-20 | US | Illinois | Lake | 17097 | 194557 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-21 04:22:23 | Lake, Illinois, US | |
199273 | 199273 | 2022-10-19 | US | Illinois | Lake | 17097 | 193964 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-20 04:22:59 | Lake, Illinois, US | |
2757934 | 2757934 | 2022-10-18 | US | Illinois | Lake | 17097 | 193955 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-19 04:22:26 | Lake, Illinois, US | |
2025768 | 2025768 | 2022-10-17 | US | Illinois | Lake | 17097 | 193872 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-18 04:22:42 | Lake, Illinois, US | |
2160546 | 2160546 | 2022-10-16 | US | Illinois | Lake | 17097 | 193687 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-17 04:20:31 | Lake, Illinois, US | |
516743 | 516743 | 2022-10-15 | US | Illinois | Lake | 17097 | 193687 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-16 04:22:39 | Lake, Illinois, US | |
2033800 | 2033800 | 2022-10-14 | US | Illinois | Lake | 17097 | 193687 | 1478 | 0 | 42.3224907 | -88.00367925 | 2022-10-15 04:22:00 | Lake, Illinois, US | |
3548182 | 3548182 | 2022-09-01 | US | Delaware | New Castle | 10003 | 172105 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-09-02 04:21:07 | New Castle, Delaware, US | |
2346388 | 2346388 | 2022-08-31 | US | Tennessee | Knox | 47093 | 145960 | 1478 | 0 | 35.99508821 | -83.94635435 | 2022-09-01 04:21:03 | Knox, Tennessee, US | |
2344102 | 2344102 | 2022-08-31 | US | Delaware | New Castle | 10003 | 171986 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-09-01 04:21:03 | New Castle, Delaware, US | |
3774582 | 3774582 | 2022-08-30 | US | Delaware | New Castle | 10003 | 171864 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-31 04:20:57 | New Castle, Delaware, US | |
1683464 | 1683464 | 2022-08-29 | US | Tennessee | Knox | 47093 | 145432 | 1478 | 0 | 35.99508821 | -83.94635435 | 2022-08-30 04:21:03 | Knox, Tennessee, US | |
1681178 | 1681178 | 2022-08-29 | US | Delaware | New Castle | 10003 | 171794 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-30 04:21:03 | New Castle, Delaware, US | |
1879948 | 1879948 | 2022-08-28 | US | Tennessee | Knox | 47093 | 145193 | 1478 | 0 | 35.99508821 | -83.94635435 | 2022-08-29 04:21:06 | Knox, Tennessee, US | |
1877662 | 1877662 | 2022-08-28 | US | Delaware | New Castle | 10003 | 171485 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-29 04:21:06 | New Castle, Delaware, US | |
2096789 | 2096789 | 2022-08-27 | US | Delaware | New Castle | 10003 | 171485 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-28 04:21:02 | New Castle, Delaware, US | |
1532604 | 1532604 | 2022-08-26 | US | Delaware | New Castle | 10003 | 171485 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-27 04:20:57 | New Castle, Delaware, US | |
2829491 | 2829491 | 2022-08-25 | US | Delaware | New Castle | 10003 | 171388 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-26 04:21:02 | New Castle, Delaware, US | |
2324024 | 2324024 | 2022-08-24 | US | Delaware | New Castle | 10003 | 171251 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-25 04:21:13 | New Castle, Delaware, US | |
1251433 | 1251433 | 2022-08-23 | US | Delaware | New Castle | 10003 | 171037 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-24 04:20:46 | New Castle, Delaware, US | |
2853537 | 2853537 | 2022-08-22 | US | Delaware | New Castle | 10003 | 171037 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-23 04:20:56 | New Castle, Delaware, US | |
2403509 | 2403509 | 2022-08-21 | US | Delaware | New Castle | 10003 | 170666 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-22 04:20:38 | New Castle, Delaware, US | |
3798587 | 3798587 | 2022-08-20 | US | Delaware | New Castle | 10003 | 170666 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-21 04:20:44 | New Castle, Delaware, US | |
2364173 | 2364173 | 2022-08-19 | US | Delaware | New Castle | 10003 | 170666 | 1478 | 0 | 39.57992638 | -75.64054974 | 2022-08-20 04:21:01 | New Castle, Delaware, US | |
1488933 | 1488933 | 2022-07-26 | US | Kansas | Sedgwick | 20173 | 152962 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-07-27 04:21:04 | Sedgwick, Kansas, US | |
2595379 | 2595379 | 2022-07-25 | US | Kansas | Sedgwick | 20173 | 152962 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-07-26 04:20:58 | Sedgwick, Kansas, US | |
897494 | 897494 | 2022-07-24 | US | Kansas | Sedgwick | 20173 | 152962 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-07-25 04:20:51 | Sedgwick, Kansas, US | |
92488 | 92488 | 2022-07-23 | US | Kansas | Sedgwick | 20173 | 152962 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-07-24 04:20:47 | Sedgwick, Kansas, US | |
901510 | 901510 | 2022-07-22 | US | Kansas | Sedgwick | 20173 | 152962 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-07-23 04:20:53 | Sedgwick, Kansas, US | |
671646 | 671646 | 2022-07-21 | US | Kansas | Sedgwick | 20173 | 152962 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-07-22 04:21:15 | Sedgwick, Kansas, US | |
1609609 | 1609609 | 2022-07-20 | US | Kansas | Sedgwick | 20173 | 152962 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-07-21 04:21:10 | Sedgwick, Kansas, US | |
3969885 | 3969885 | 2022-07-05 | US | Virginia | Fairfax | 51059 | 212178 | 1478 | 0 | 38.83677558 | -77.27565836 | 2022-07-06 04:20:58 | Fairfax, Virginia, US | |
167391 | 167391 | 2022-06-21 | US | Kansas | Sedgwick | 20173 | 147724 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-06-22 04:20:54 | Sedgwick, Kansas, US | |
166103 | 166103 | 2022-06-21 | Malaysia | Negeri Sembilan | 206610 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-22 04:20:54 | Negeri Sembilan, Malaysia | |||
1764674 | 1764674 | 2022-06-20 | US | Kansas | Sedgwick | 20173 | 147724 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-06-21 04:20:56 | Sedgwick, Kansas, US | |
1763386 | 1763386 | 2022-06-20 | Malaysia | Negeri Sembilan | 206541 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-21 04:20:56 | Negeri Sembilan, Malaysia | |||
3270860 | 3270860 | 2022-06-19 | US | Kansas | Sedgwick | 20173 | 147724 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-06-20 04:21:01 | Sedgwick, Kansas, US | |
3269572 | 3269572 | 2022-06-19 | Malaysia | Negeri Sembilan | 206459 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-20 04:21:01 | Negeri Sembilan, Malaysia | |||
3398772 | 3398772 | 2022-06-18 | US | Kansas | Sedgwick | 20173 | 147724 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-06-19 04:20:51 | Sedgwick, Kansas, US | |
3397484 | 3397484 | 2022-06-18 | Malaysia | Negeri Sembilan | 206375 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-19 04:20:51 | Negeri Sembilan, Malaysia | |||
2312649 | 2312649 | 2022-06-17 | US | Kansas | Sedgwick | 20173 | 147724 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-06-18 04:21:10 | Sedgwick, Kansas, US | |
2311361 | 2311361 | 2022-06-17 | Malaysia | Negeri Sembilan | 206303 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-18 04:21:10 | Negeri Sembilan, Malaysia | |||
560153 | 560153 | 2022-06-16 | US | Kansas | Sedgwick | 20173 | 147724 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-06-17 04:20:56 | Sedgwick, Kansas, US | |
558865 | 558865 | 2022-06-16 | Malaysia | Negeri Sembilan | 206221 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-17 04:20:56 | Negeri Sembilan, Malaysia | |||
3983955 | 3983955 | 2022-06-15 | US | Kansas | Sedgwick | 20173 | 147724 | 1478 | 0 | 37.6842718 | -97.4608198 | 2022-06-16 04:20:55 | Sedgwick, Kansas, US | |
3982667 | 3982667 | 2022-06-15 | Malaysia | Negeri Sembilan | 206127 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-16 04:20:55 | Negeri Sembilan, Malaysia | |||
946908 | 946908 | 2022-06-14 | Malaysia | Negeri Sembilan | 206022 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-15 04:20:54 | Negeri Sembilan, Malaysia | |||
2979316 | 2979316 | 2022-06-13 | Malaysia | Negeri Sembilan | 205917 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-14 04:20:52 | Negeri Sembilan, Malaysia | |||
2235442 | 2235442 | 2022-06-12 | Malaysia | Negeri Sembilan | 205893 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-13 04:21:14 | Negeri Sembilan, Malaysia | |||
3141640 | 3141640 | 2022-06-11 | Malaysia | Negeri Sembilan | 205809 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-12 04:20:53 | Negeri Sembilan, Malaysia | |||
1944556 | 1944556 | 2022-06-10 | Malaysia | Negeri Sembilan | 205720 | 1478 | 0 | 2.7258 | 101.9424 | 2022-06-11 04:21:01 | Negeri Sembilan, Malaysia | |||
3185965 | 3185965 | 2022-05-30 | Italy | P.A. Bolzano | 217985 | 1478 | 0 | 46.49933453 | 11.35662422 | 2022-05-31 04:20:51 | P.A. Bolzano, Italy | |||
3198114 | 3198114 | 2022-05-29 | Italy | P.A. Bolzano | 217936 | 1478 | 0 | 46.49933453 | 11.35662422 | 2022-05-30 04:20:50 | P.A. Bolzano, Italy | |||
2724992 | 2724992 | 2022-05-28 | Italy | P.A. Bolzano | 217857 | 1478 | 0 | 46.49933453 | 11.35662422 | 2022-05-29 04:20:53 | P.A. Bolzano, Italy | |||
1314173 | 1314173 | 2022-05-27 | Italy | P.A. Bolzano | 217727 | 1478 | 0 | 46.49933453 | 11.35662422 | 2022-05-28 04:21:07 | P.A. Bolzano, Italy | |||
2999641 | 2999641 | 2022-05-24 | Taiwan* | 1469019 | 1478 | 0 | 23.7 | 121.0 | 2022-05-25 04:20:56 | Taiwan* | ||||
1576363 | 1576363 | 2022-04-10 | Russia | Karelia Republic | 132297 | 1478 | 0 | 62.61940309999999 | 33.4920267 | 2022-04-11 04:21:02 | Karelia Republic, Russia | |||
338990 | 338990 | 2022-03-18 | US | Texas | Collin | 48085 | 207040 | 1478 | 0 | 33.18820114 | -96.57264368 | 2022-03-19 04:20:47 | Collin, Texas, US | |
261745 | 261745 | 2022-03-15 | Russia | Khabarovsk Krai | 190012 | 1478 | 0 | 51.6312684 | 136.121524 | 2022-03-16 04:20:50 | Khabarovsk Krai, Russia | |||
3718245 | 3718245 | 2022-02-21 | Malaysia | Perak | 141200 | 1478 | 0 | 4.5921 | 101.0901 | 2022-02-22 04:21:01 | Perak, Malaysia | |||
3912079 | 3912079 | 2022-02-20 | Malaysia | Perak | 140735 | 1478 | 0 | 4.5921 | 101.0901 | 2022-02-21 04:21:05 | Perak, Malaysia | |||
1362810 | 1362810 | 2022-02-08 | US | Arizona | Pinal | 4021 | 125376 | 1478 | 0 | 32.90525627 | -111.3449483 | 2022-02-09 04:21:04 | Pinal, Arizona, US | |
459354 | 459354 | 2022-02-02 | Italy | P.A. Trento | 125843 | 1478 | 0 | 46.06893511 | 11.12123097 | 2022-02-03 04:21:21 | P.A. Trento, Italy | |||
3303140 | 3303140 | 2022-01-30 | US | Tennessee | Davidson | 47037 | 181312 | 1478 | 0 | 36.17007426 | -86.78646056 | 2022-01-31 04:21:09 | Davidson, Tennessee, US | |
3226203 | 3226203 | 2022-01-19 | Canada | Manitoba | 112346 | 1478 | 0 | 53.7609 | -98.8139 | 2022-01-20 04:21:07 | Manitoba, Canada | |||
3464172 | 3464172 | 2022-01-18 | Japan | Hokkaido | 65970 | 1478 | 0 | 43.385711 | 142.55231799999999 | 2022-01-19 04:21:23 | Hokkaido, Japan | |||
1692450 | 1692450 | 2022-01-10 | Netherlands | Utrecht | 266865 | 1478 | 0 | 52.084251 | 5.163824 | 2022-01-11 04:22:01 | Utrecht, Netherlands | |||
126865 | 126865 | 2022-01-09 | Netherlands | Utrecht | 264571 | 1478 | 0 | 52.084251 | 5.163824 | 2022-01-10 04:22:07 | Utrecht, Netherlands | |||
1288521 | 1288521 | 2022-01-04 | US | Ohio | Stark | 39151 | 65952 | 1478 | 0 | 40.81482476 | -81.36437305 | 2022-01-05 04:21:59 | Stark, Ohio, US | |
2168181 | 2168181 | 2022-01-01 | US | Colorado | El Paso | 8041 | 133325 | 1478 | 0 | 38.83240149 | -104.5251411 | 2022-01-02 04:20:52 | El Paso, Colorado, US | |
2777612 | 2777612 | 2021-12-31 | US | Colorado | El Paso | 8041 | 132936 | 1478 | 0 | 38.83240149 | -104.5251411 | 2022-01-01 04:22:14 | El Paso, Colorado, US | |
1432803 | 1432803 | 2021-12-28 | Russia | Orel Oblast | 69941 | 1478 | 0 | 52.96854329999999 | 36.0692477 | 2021-12-29 03:21:43 | Orel Oblast, Russia | |||
2903658 | 2903658 | 2021-12-19 | India | Meghalaya | 84752 | 1478 | 0 | 25.536934 | 91.278882 | 2021-12-20 04:21:43 | Meghalaya, India | |||
1258731 | 1258731 | 2021-12-18 | India | Meghalaya | 84738 | 1478 | 0 | 25.536934 | 91.278882 | 2021-12-19 04:21:11 | Meghalaya, India | |||
2398759 | 2398759 | 2021-12-17 | India | Meghalaya | 84726 | 1478 | 0 | 25.536934 | 91.278882 | 2021-12-18 02:22:20 | Meghalaya, India | |||
1716297 | 1716297 | 2021-12-16 | India | Meghalaya | 84726 | 1478 | 0 | 25.536934 | 91.278882 | 2021-12-17 04:22:14 | Meghalaya, India | |||
3498869 | 3498869 | 2021-12-15 | US | Pennsylvania | Lancaster | 42071 | 83789 | 1478 | 0 | 40.03904563 | -76.24770128 | 2021-12-16 04:22:11 | Lancaster, Pennsylvania, US | |
3401316 | 3401316 | 2021-11-30 | Finland | 188390 | 1478 | 0 | 61.92411 | 25.748151 | 2021-12-01 04:22:29 | Finland | ||||
152637 | 152637 | 2021-11-29 | US | Pennsylvania | Bucks | 42017 | 78779 | 1478 | 0 | 40.33682119 | -75.10836643 | 2021-11-30 04:22:53 | Bucks, Pennsylvania, US | |
3749107 | 3749107 | 2021-11-22 | Italy | Umbria | 66872 | 1478 | 0 | 43.10675841 | 12.38824698 | 2021-11-23 04:22:39 | Umbria, Italy | |||
1014314 | 1014314 | 2021-11-21 | Italy | Umbria | 66866 | 1478 | 0 | 43.10675841 | 12.38824698 | 2021-11-22 04:22:20 | Umbria, Italy | |||
1494268 | 1494268 | 2021-10-12 | US | Pennsylvania | Delaware | 42045 | 60964 | 1478 | 0 | 39.91680171 | -75.40243663 | 2021-10-13 04:20:51 | Delaware, Pennsylvania, US | |
1335879 | 1335879 | 2021-09-28 | US | Massachusetts | Norfolk | 25021 | 61734 | 1478 | 0 | 42.16073095 | -71.20530408 | 2021-09-29 04:21:45 | Norfolk, Massachusetts, US | |
3974719 | 3974719 | 2021-09-03 | Peru | Apurimac | 25765 | 1478 | 0 | -14.027713 | -72.975378 | 2021-09-04 04:21:28 | Apurimac, Peru | |||
178575 | 178575 | 2021-09-02 | US | California | Kern | 6029 | 126250 | 1478 | 0 | 35.34329425 | -118.72777959999999 | 2021-09-03 04:21:20 | Kern, California, US | |
178181 | 178181 | 2021-09-02 | Peru | Apurimac | 25765 | 1478 | 0 | -14.027713 | -72.975378 | 2021-09-03 04:21:20 | Apurimac, Peru | |||
67216 | 67216 | 2021-09-01 | Peru | Apurimac | 25765 | 1478 | 0 | -14.027713 | -72.975378 | 2021-09-02 04:21:15 | Apurimac, Peru | |||
2068058 | 2068058 | 2021-08-31 | Peru | Apurimac | 25765 | 1478 | 0 | -14.027713 | -72.975378 | 2021-09-01 04:21:38 | Apurimac, Peru | |||
1775512 | 1775512 | 2021-08-30 | Peru | Apurimac | 25765 | 1478 | 0 | -14.027713 | -72.975378 | 2021-08-31 04:21:46 | Apurimac, Peru |
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]);