johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
141 rows where deaths = 1562 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 43
- Peru 30
- Spain 20
- Russia 14
- Netherlands 7
- Chile 4
- Mexico 4
- Italy 3
- Oman 3
- India 2
- Ukraine 2
- Afghanistan 1
- Algeria 1
- Cambodia 1
- Canada 1
- Colombia 1
- Korea, South 1
- Malaysia 1
- Montenegro 1
- Poland 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756364 | 2756364 | 2022-12-29 | US | Washington | Pierce | 53053 | 238907 | 1562 | 0 | 47.03892768 | -122.1405958 | 2022-12-30 04:21:04 | Pierce, Washington, US | |
1077370 | 1077370 | 2022-12-28 | US | Washington | Pierce | 53053 | 238907 | 1562 | 0 | 47.03892768 | -122.1405958 | 2022-12-29 04:21:01 | Pierce, Washington, US | |
2438875 | 2438875 | 2022-11-07 | Netherlands | Utrecht | 701447 | 1562 | 0 | 52.084251 | 5.163824 | 2022-11-08 04:21:21 | Utrecht, Netherlands | |||
1049973 | 1049973 | 2022-11-06 | Netherlands | Utrecht | 701447 | 1562 | 0 | 52.084251 | 5.163824 | 2022-11-07 04:21:26 | Utrecht, Netherlands | |||
617997 | 617997 | 2022-11-05 | Netherlands | Utrecht | 701447 | 1562 | 0 | 52.084251 | 5.163824 | 2022-11-06 04:21:24 | Utrecht, Netherlands | |||
1022501 | 1022501 | 2022-11-04 | Netherlands | Utrecht | 701447 | 1562 | 0 | 52.084251 | 5.163824 | 2022-11-05 04:21:52 | Utrecht, Netherlands | |||
2272217 | 2272217 | 2022-10-20 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-21 04:22:23 | Baleares, Spain | |||
2272139 | 2272139 | 2022-10-20 | Russia | Khabarovsk Krai | 222425 | 1562 | 0 | 51.6312684 | 136.121524 | 2022-10-21 04:22:23 | Khabarovsk Krai, Russia | |||
198552 | 198552 | 2022-10-19 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-20 04:22:59 | Baleares, Spain | |||
198474 | 198474 | 2022-10-19 | Russia | Khabarovsk Krai | 222358 | 1562 | 0 | 51.6312684 | 136.121524 | 2022-10-20 04:22:59 | Khabarovsk Krai, Russia | |||
2757213 | 2757213 | 2022-10-18 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-19 04:22:26 | Baleares, Spain | |||
2757135 | 2757135 | 2022-10-18 | Russia | Khabarovsk Krai | 222289 | 1562 | 0 | 51.6312684 | 136.121524 | 2022-10-19 04:22:26 | Khabarovsk Krai, Russia | |||
2025047 | 2025047 | 2022-10-17 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-18 04:22:42 | Baleares, Spain | |||
2024969 | 2024969 | 2022-10-17 | Russia | Khabarovsk Krai | 222226 | 1562 | 0 | 51.6312684 | 136.121524 | 2022-10-18 04:22:42 | Khabarovsk Krai, Russia | |||
2159825 | 2159825 | 2022-10-16 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-17 04:20:31 | Baleares, Spain | |||
516022 | 516022 | 2022-10-15 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-16 04:22:39 | Baleares, Spain | |||
2033079 | 2033079 | 2022-10-14 | Spain | Baleares | 310086 | 1562 | 0 | 39.710358 | 2.995148 | 2022-10-15 04:22:00 | Baleares, Spain | |||
133942 | 133942 | 2022-10-04 | US | Texas | Nueces | 48355 | 115569 | 1562 | 0 | 27.736286 | -97.5433285 | 2022-10-05 04:23:06 | Nueces, Texas, US | |
2688889 | 2688889 | 2022-10-03 | US | Texas | Nueces | 48355 | 115540 | 1562 | 0 | 27.736286 | -97.5433285 | 2022-10-04 04:22:55 | Nueces, Texas, US | |
253910 | 253910 | 2022-09-08 | US | California | Ventura | 6111 | 222035 | 1562 | 0 | 34.44465746 | -119.0910613 | 2022-09-09 04:21:11 | Ventura, California, US | |
3745708 | 3745708 | 2022-09-07 | US | California | Ventura | 6111 | 221691 | 1562 | 0 | 34.44465746 | -119.0910613 | 2022-09-08 04:21:02 | Ventura, California, US | |
476505 | 476505 | 2022-06-26 | US | Illinois | Will | 17197 | 180161 | 1562 | 0 | 41.44619267 | -87.97862712 | 2022-06-27 04:21:00 | Will, Illinois, US | |
939880 | 939880 | 2022-06-25 | US | Illinois | Will | 17197 | 180161 | 1562 | 0 | 41.44619267 | -87.97862712 | 2022-06-26 04:21:02 | Will, Illinois, US | |
3347700 | 3347700 | 2022-06-24 | US | Illinois | Will | 17197 | 180161 | 1562 | 0 | 41.44619267 | -87.97862712 | 2022-06-25 04:20:57 | Will, Illinois, US | |
3509567 | 3509567 | 2022-06-05 | US | New Jersey | Morris | 34027 | 132169 | 1562 | 0 | 40.86095313 | -74.5455371 | 2022-06-06 04:20:57 | Morris, New Jersey, US | |
3529644 | 3529644 | 2022-06-04 | US | New Jersey | Morris | 34027 | 132036 | 1562 | 0 | 40.86095313 | -74.5455371 | 2022-06-05 04:20:55 | Morris, New Jersey, US | |
3135730 | 3135730 | 2022-06-03 | US | New Jersey | Morris | 34027 | 131811 | 1562 | 0 | 40.86095313 | -74.5455371 | 2022-06-04 04:20:58 | Morris, New Jersey, US | |
3580805 | 3580805 | 2022-06-02 | US | New Jersey | Morris | 34027 | 131537 | 1562 | 0 | 40.86095313 | -74.5455371 | 2022-06-03 04:20:58 | Morris, New Jersey, US | |
2048173 | 2048173 | 2022-05-25 | Spain | Navarra | 240528 | 1562 | 0 | 42.6954 | -1.6761 | 2022-05-26 04:20:50 | Navarra, Spain | |||
2999611 | 2999611 | 2022-05-24 | Spain | Navarra | 240528 | 1562 | 0 | 42.6954 | -1.6761 | 2022-05-25 04:20:56 | Navarra, Spain | |||
3593332 | 3593332 | 2022-05-23 | Spain | Navarra | 240528 | 1562 | 0 | 42.6954 | -1.6761 | 2022-05-24 04:20:57 | Navarra, Spain | |||
3593001 | 3593001 | 2022-05-23 | Italy | P.A. Trento | 166608 | 1562 | 0 | 46.06893511 | 11.12123097 | 2022-05-24 04:20:57 | P.A. Trento, Italy | |||
622184 | 622184 | 2022-05-22 | Spain | Navarra | 240528 | 1562 | 0 | 42.6954 | -1.6761 | 2022-05-26 04:20:50 | Navarra, Spain | |||
1109880 | 1109880 | 2022-05-21 | Spain | Navarra | 240528 | 1562 | 0 | 42.6954 | -1.6761 | 2022-05-22 04:20:52 | Navarra, Spain | |||
1109549 | 1109549 | 2022-05-21 | Italy | P.A. Trento | 166468 | 1562 | 0 | 46.06893511 | 11.12123097 | 2022-05-22 04:20:52 | P.A. Trento, Italy | |||
3724449 | 3724449 | 2022-04-25 | US | New York | Monroe | 36055 | 157753 | 1562 | 0 | 43.14638895 | -77.69322942 | 2022-04-26 04:20:51 | Monroe, New York, US | |
1437318 | 1437318 | 2022-03-28 | US | Florida | Sarasota | 12115 | 90629 | 1562 | 0 | 27.18546175 | -82.33174248 | 2022-03-29 04:20:46 | Sarasota, Florida, US | |
876999 | 876999 | 2022-03-27 | US | Florida | Sarasota | 12115 | 90629 | 1562 | 0 | 27.18546175 | -82.33174248 | 2022-03-28 04:20:33 | Sarasota, Florida, US | |
2164282 | 2164282 | 2022-03-26 | US | Florida | Sarasota | 12115 | 90629 | 1562 | 0 | 27.18546175 | -82.33174248 | 2022-03-27 04:20:47 | Sarasota, Florida, US | |
1721218 | 1721218 | 2022-03-25 | US | Florida | Sarasota | 12115 | 90629 | 1562 | 0 | 27.18546175 | -82.33174248 | 2022-03-26 04:20:23 | Sarasota, Florida, US | |
1468835 | 1468835 | 2022-03-24 | US | Florida | Sarasota | 12115 | 90474 | 1562 | 0 | 27.18546175 | -82.33174248 | 2022-03-25 04:20:46 | Sarasota, Florida, US | |
3023009 | 3023009 | 2022-03-23 | US | Florida | Sarasota | 12115 | 90474 | 1562 | 0 | 27.18546175 | -82.33174248 | 2022-03-24 04:20:43 | Sarasota, Florida, US | |
1905931 | 1905931 | 2022-03-22 | US | Florida | Sarasota | 12115 | 90474 | 1562 | 0 | 27.18546175 | -82.33174248 | 2022-03-23 04:20:48 | Sarasota, Florida, US | |
1548031 | 1548031 | 2022-03-07 | Malaysia | Perak | 160433 | 1562 | 0 | 4.5921 | 101.0901 | 2022-03-08 04:20:54 | Perak, Malaysia | |||
943226 | 943226 | 2022-02-28 | US | Alabama | Mobile | 1097 | 112116 | 1562 | 0 | 30.78472347 | -88.20842409 | 2022-03-01 04:21:09 | Mobile, Alabama, US | |
2733417 | 2733417 | 2022-02-27 | US | Alabama | Mobile | 1097 | 112093 | 1562 | 0 | 30.78472347 | -88.20842409 | 2022-02-28 04:21:05 | Mobile, Alabama, US | |
3046570 | 3046570 | 2022-02-26 | US | Alabama | Mobile | 1097 | 112072 | 1562 | 0 | 30.78472347 | -88.20842409 | 2022-02-27 04:21:04 | Mobile, Alabama, US | |
575225 | 575225 | 2022-02-25 | US | Alabama | Mobile | 1097 | 111886 | 1562 | 0 | 30.78472347 | -88.20842409 | 2022-02-26 04:21:12 | Mobile, Alabama, US | |
575074 | 575074 | 2022-02-25 | Russia | Pskov Oblast | 92839 | 1562 | 0 | 57.535872899999994 | 28.8586826 | 2022-02-26 04:21:12 | Pskov Oblast, Russia | |||
1058639 | 1058639 | 2022-02-23 | US | Georgia | DeKalb | 13089 | 143767 | 1562 | 0 | 33.76944049 | -84.22396017 | 2022-02-24 04:21:14 | DeKalb, Georgia, US | |
3912191 | 3912191 | 2022-02-20 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-21 04:21:05 | Moquegua, Peru | |||
3875749 | 3875749 | 2022-02-19 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-20 04:21:00 | Moquegua, Peru | |||
3856005 | 3856005 | 2022-02-18 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-19 04:21:11 | Moquegua, Peru | |||
1298224 | 1298224 | 2022-02-17 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-18 04:21:04 | Moquegua, Peru | |||
3820610 | 3820610 | 2022-02-16 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-17 04:20:56 | Moquegua, Peru | |||
3671824 | 3671824 | 2022-02-15 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-16 04:21:10 | Moquegua, Peru | |||
2641925 | 2641925 | 2022-02-14 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-15 04:21:09 | Moquegua, Peru | |||
186242 | 186242 | 2022-02-13 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-14 04:20:51 | Moquegua, Peru | |||
186013 | 186013 | 2022-02-13 | India | Meghalaya | 92991 | 1562 | 0 | 25.536934 | 91.278882 | 2022-02-14 04:20:51 | Meghalaya, India | |||
316088 | 316088 | 2022-02-12 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-13 04:21:00 | Moquegua, Peru | |||
233414 | 233414 | 2022-02-11 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-12 04:21:06 | Moquegua, Peru | |||
1464256 | 1464256 | 2022-02-10 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-11 04:21:09 | Moquegua, Peru | |||
3074217 | 3074217 | 2022-02-09 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-10 04:21:14 | Moquegua, Peru | |||
1362524 | 1362524 | 2022-02-08 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-09 04:21:04 | Moquegua, Peru | |||
71262 | 71262 | 2022-02-07 | Peru | Moquegua | 45428 | 1562 | 0 | -16.860271 | -70.839046 | 2022-02-08 04:21:15 | Moquegua, Peru | |||
459569 | 459569 | 2022-02-02 | Russia | Arkhangelsk Oblast | 144036 | 1562 | 0 | 63.5589686 | 43.1221646 | 2022-02-03 04:21:21 | Arkhangelsk Oblast, Russia | |||
2657542 | 2657542 | 2022-01-31 | Canada | Manitoba | 120644 | 1562 | 0 | 53.7609 | -98.8139 | 2022-02-01 04:21:11 | Manitoba, Canada | |||
3303445 | 3303445 | 2022-01-30 | US | Texas | Travis | 48453 | 207934 | 1562 | 0 | 30.33432034 | -97.78535620000001 | 2022-01-31 04:21:09 | Travis, Texas, US | |
2052865 | 2052865 | 2022-01-25 | US | Illinois | DuPage | 17043 | 193409 | 1562 | 0 | 41.85116968 | -88.08642662 | 2022-01-26 04:21:07 | DuPage, Illinois, US | |
1229187 | 1229187 | 2022-01-24 | US | Maryland | Baltimore City | 24510 | 106940 | 1562 | 0 | 39.30211911 | -76.61151012 | 2022-01-25 04:21:05 | Baltimore City, Maryland, US | |
1142486 | 1142486 | 2022-01-23 | US | Maryland | Baltimore City | 24510 | 106734 | 1562 | 0 | 39.30211911 | -76.61151012 | 2022-01-24 04:21:12 | Baltimore City, Maryland, US | |
1140685 | 1140685 | 2022-01-23 | Chile | Los Lagos | 103250 | 1562 | 0 | -41.9198 | -72.1416 | 2022-01-24 04:21:12 | Los Lagos, Chile | |||
2832603 | 2832603 | 2022-01-22 | Chile | Los Lagos | 102803 | 1562 | 0 | -41.9198 | -72.1416 | 2022-01-23 04:21:13 | Los Lagos, Chile | |||
1472096 | 1472096 | 2022-01-17 | Italy | Umbria | 128670 | 1562 | 0 | 43.10675841 | 12.38824698 | 2022-01-18 04:21:04 | Umbria, Italy | |||
3841129 | 3841129 | 2022-01-15 | US | Colorado | El Paso | 8041 | 166762 | 1562 | 0 | 38.83240149 | -104.5251411 | 2022-01-16 04:21:12 | El Paso, Colorado, US | |
3819089 | 3819089 | 2021-12-23 | US | Pennsylvania | Delaware | 42045 | 72308 | 1562 | 0 | 39.91680171 | -75.40243663 | 2021-12-24 04:21:34 | Delaware, Pennsylvania, US | |
682119 | 682119 | 2021-10-24 | Chile | OHiggins | 69716 | 1562 | 0 | -34.5755 | -71.0022 | 2021-10-25 04:22:31 | OHiggins, Chile | |||
770127 | 770127 | 2021-10-23 | Chile | OHiggins | 69654 | 1562 | 0 | -34.5755 | -71.0022 | 2021-10-24 04:21:22 | OHiggins, Chile | |||
654173 | 654173 | 2021-10-22 | Peru | Tumbes | 18843 | 1562 | 0 | -3.857496 | -80.54525500000003 | 2021-10-23 04:21:32 | Tumbes, Peru | |||
2125162 | 2125162 | 2021-10-21 | US | Kentucky | Jefferson | 21111 | 118682 | 1562 | 0 | 38.18664655 | -85.65931031 | 2021-10-22 04:21:14 | Jefferson, Kentucky, US | |
2123920 | 2123920 | 2021-10-21 | Peru | Tumbes | 18843 | 1562 | 0 | -3.857496 | -80.54525500000003 | 2021-10-22 04:21:14 | Tumbes, Peru | |||
443532 | 443532 | 2021-10-20 | Peru | Tumbes | 18843 | 1562 | 0 | -3.857496 | -80.54525500000003 | 2021-10-21 04:21:18 | Tumbes, Peru | |||
2946999 | 2946999 | 2021-10-15 | Ukraine | Sumy Oblast | 91455 | 1562 | 0 | 50.9077 | 34.7981 | 2021-10-16 04:21:15 | Sumy Oblast, Ukraine | |||
2876385 | 2876385 | 2021-10-09 | Peru | Tumbes | 18756 | 1562 | 0 | -3.857496 | -80.54525500000003 | 2021-10-10 04:21:38 | Tumbes, Peru | |||
2959551 | 2959551 | 2021-10-08 | Peru | Tumbes | 18756 | 1562 | 0 | -3.857496 | -80.54525500000003 | 2021-10-09 04:21:34 | Tumbes, Peru | |||
3836050 | 3836050 | 2021-10-05 | US | Wisconsin | Milwaukee | 55079 | 145197 | 1562 | 0 | 43.00486062 | -87.96733172 | 2021-10-06 04:21:33 | Milwaukee, Wisconsin, US | |
1274466 | 1274466 | 2021-10-03 | Peru | Tumbes | 18729 | 1562 | 0 | -3.857496 | -80.54525500000003 | 2021-10-04 04:21:31 | Tumbes, Peru | |||
3928219 | 3928219 | 2021-10-02 | Peru | Tumbes | 18729 | 1562 | 0 | -3.857496 | -80.54525500000003 | 2021-10-03 04:21:24 | Tumbes, Peru | |||
2774583 | 2774583 | 2021-09-30 | US | Massachusetts | Suffolk | 25025 | 104324 | 1562 | 0 | 42.327951399999996 | -71.07850442 | 2021-10-01 04:21:35 | Suffolk, Massachusetts, US | |
1814997 | 1814997 | 2021-09-19 | Russia | Lipetsk Oblast | 50639 | 1562 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-09-20 04:21:22 | Lipetsk Oblast, Russia | |||
3449058 | 3449058 | 2021-09-10 | Russia | Komi Republic | 65613 | 1562 | 0 | 63.9881421 | 54.3326073 | 2021-09-11 04:21:30 | Komi Republic, Russia | |||
3165888 | 3165888 | 2021-08-23 | Russia | Vologda Oblast | 59979 | 1562 | 0 | 60.0391461 | 43.1215213 | 2021-08-24 04:21:19 | Vologda Oblast, Russia | |||
1604310 | 1604310 | 2021-08-16 | Mexico | Campeche | 16986 | 1562 | 0 | 19.8301 | -90.5349 | 2021-08-17 04:21:49 | Campeche, Mexico | |||
589389 | 589389 | 2021-08-08 | Cambodia | 81891 | 1562 | 0 | 11.55 | 104.9167 | 2021-08-09 04:21:24 | Cambodia | ||||
3904201 | 3904201 | 2021-07-31 | Russia | Murmansk Oblast | 61881 | 1562 | 51125 | 9194 | 68.00004179999999 | 33.9999151 | 2021-08-01 04:21:50 | Murmansk Oblast, Russia | ||
1495799 | 1495799 | 2021-07-03 | Russia | Chuvashia Republic | 27475 | 1562 | 25109 | 804 | 55.4259922 | 47.0849429 | 2021-07-04 04:21:38 | Chuvashia Republic, Russia | ||
3970769 | 3970769 | 2021-06-11 | Russia | Leningrad Oblast | 46257 | 1562 | 43337 | 1358 | 60.1853296 | 32.3925325 | 2021-06-12 04:22:22 | Leningrad Oblast, Russia | ||
2717219 | 2717219 | 2021-06-10 | Russia | Stavropol Krai | 55421 | 1562 | 52599 | 1260 | 44.86325770000001 | 43.4406913 | 2021-06-11 04:23:20 | Stavropol Krai, Russia | ||
1416495 | 1416495 | 2021-05-24 | US | Washington | King | 53033 | 108508 | 1562 | 0 | 47.49137892 | -121.8346131 | 2021-05-25 04:21:08 | King, Washington, US | |
3574707 | 3574707 | 2021-05-17 | Montenegro | 98898 | 1562 | 95999 | 1337 | 42.708678000000006 | 19.37439 | 2021-05-18 04:20:33 | Montenegro |
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]);