johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
152 rows where deaths = 1254 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330857 | 330857 | 2022-12-27 | US | Tennessee | Hamilton | 47065 | 118399 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-28 04:21:04 | Hamilton, Tennessee, US | |
220930 | 220930 | 2022-12-26 | US | Tennessee | Hamilton | 47065 | 118399 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-27 04:21:07 | Hamilton, Tennessee, US | |
3225387 | 3225387 | 2022-12-25 | US | Tennessee | Hamilton | 47065 | 118399 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-26 04:21:06 | Hamilton, Tennessee, US | |
1021301 | 1021301 | 2022-12-24 | US | Tennessee | Hamilton | 47065 | 118399 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-25 04:21:04 | Hamilton, Tennessee, US | |
693324 | 693324 | 2022-12-23 | US | Tennessee | Hamilton | 47065 | 118372 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-24 04:21:02 | Hamilton, Tennessee, US | |
2182534 | 2182534 | 2022-12-22 | US | Tennessee | Hamilton | 47065 | 118288 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-23 04:21:04 | Hamilton, Tennessee, US | |
454338 | 454338 | 2022-12-21 | US | Tennessee | Hamilton | 47065 | 118232 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-22 04:20:56 | Hamilton, Tennessee, US | |
2954337 | 2954337 | 2022-12-20 | US | Tennessee | Hamilton | 47065 | 118146 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-21 04:21:03 | Hamilton, Tennessee, US | |
3176739 | 3176739 | 2022-12-19 | US | Tennessee | Hamilton | 47065 | 118070 | 1254 | 0 | 35.17670231 | -85.16652245 | 2022-12-20 04:21:04 | Hamilton, Tennessee, US | |
1964351 | 1964351 | 2022-11-30 | Chile | Nuble | 148688 | 1254 | 0 | -36.7226 | -71.7622 | 2022-12-01 04:21:03 | Nuble, Chile | |||
2556365 | 2556365 | 2022-11-29 | Chile | Nuble | 148476 | 1254 | 0 | -36.7226 | -71.7622 | 2022-11-30 04:21:07 | Nuble, Chile | |||
1239439 | 1239439 | 2022-11-28 | Chile | Nuble | 148337 | 1254 | 0 | -36.7226 | -71.7622 | 2022-11-29 04:21:05 | Nuble, Chile | |||
1348236 | 1348236 | 2022-08-10 | US | Missouri | Jackson | 29095 | 108174 | 1254 | 0 | 39.01002188 | -94.34724536 | 2022-08-11 04:20:49 | Jackson, Missouri, US | |
1087991 | 1087991 | 2022-08-09 | US | Missouri | Jackson | 29095 | 108096 | 1254 | 0 | 39.01002188 | -94.34724536 | 2022-08-10 04:20:57 | Jackson, Missouri, US | |
3545406 | 3545406 | 2022-08-08 | US | Missouri | Jackson | 29095 | 108002 | 1254 | 0 | 39.01002188 | -94.34724536 | 2022-08-09 04:20:34 | Jackson, Missouri, US | |
1071809 | 1071809 | 2022-08-07 | US | Missouri | Jackson | 29095 | 107838 | 1254 | 0 | 39.01002188 | -94.34724536 | 2022-08-08 04:21:08 | Jackson, Missouri, US | |
1942397 | 1942397 | 2022-08-06 | US | Missouri | Jackson | 29095 | 107838 | 1254 | 0 | 39.01002188 | -94.34724536 | 2022-08-07 04:20:54 | Jackson, Missouri, US | |
882196 | 882196 | 2022-08-05 | US | Missouri | Jackson | 29095 | 107838 | 1254 | 0 | 39.01002188 | -94.34724536 | 2022-08-06 04:20:56 | Jackson, Missouri, US | |
670901 | 670901 | 2022-07-21 | US | Colorado | Arapahoe | 8005 | 178682 | 1254 | 0 | 39.64977461 | -104.3353617 | 2022-07-22 04:21:15 | Arapahoe, Colorado, US | |
1608864 | 1608864 | 2022-07-20 | US | Colorado | Arapahoe | 8005 | 178505 | 1254 | 0 | 39.64977461 | -104.3353617 | 2022-07-21 04:21:10 | Arapahoe, Colorado, US | |
961221 | 961221 | 2022-07-19 | US | North Carolina | Guilford | 37081 | 132608 | 1254 | 0 | 36.07959451 | -79.78824948 | 2022-07-20 04:20:59 | Guilford, North Carolina, US | |
959129 | 959129 | 2022-07-19 | Russia | North Ossetia - Alania Republic | 41067 | 1254 | 0 | 42.7933611 | 44.6324493 | 2022-07-20 04:20:59 | North Ossetia - Alania Republic, Russia | |||
3212608 | 3212608 | 2022-07-18 | US | North Carolina | Guilford | 37081 | 132608 | 1254 | 0 | 36.07959451 | -79.78824948 | 2022-07-19 04:20:58 | Guilford, North Carolina, US | |
3210516 | 3210516 | 2022-07-18 | Russia | North Ossetia - Alania Republic | 41064 | 1254 | 0 | 42.7933611 | 44.6324493 | 2022-07-19 04:20:58 | North Ossetia - Alania Republic, Russia | |||
3407783 | 3407783 | 2022-07-17 | US | North Carolina | Guilford | 37081 | 132608 | 1254 | 0 | 36.07959451 | -79.78824948 | 2022-07-18 04:20:59 | Guilford, North Carolina, US | |
2153983 | 2153983 | 2022-07-16 | US | North Carolina | Guilford | 37081 | 132608 | 1254 | 0 | 36.07959451 | -79.78824948 | 2022-07-17 04:21:15 | Guilford, North Carolina, US | |
2421216 | 2421216 | 2022-07-15 | US | North Carolina | Guilford | 37081 | 132608 | 1254 | 0 | 36.07959451 | -79.78824948 | 2022-07-16 04:21:05 | Guilford, North Carolina, US | |
3431291 | 3431291 | 2022-07-14 | US | North Carolina | Guilford | 37081 | 132608 | 1254 | 0 | 36.07959451 | -79.78824948 | 2022-07-15 04:20:53 | Guilford, North Carolina, US | |
3111811 | 3111811 | 2022-07-13 | US | North Carolina | Guilford | 37081 | 132608 | 1254 | 0 | 36.07959451 | -79.78824948 | 2022-07-14 04:20:57 | Guilford, North Carolina, US | |
3939974 | 3939974 | 2022-06-30 | Guyana | 67395 | 1254 | 0 | 4.860416 | -58.93018 | 2022-07-01 04:21:10 | Guyana | ||||
3939742 | 3939742 | 2022-06-30 | Australia | Queensland | 1298031 | 1254 | 0 | -27.4698 | 153.0251 | 2022-07-01 04:21:10 | Queensland, Australia | |||
1848150 | 1848150 | 2022-04-18 | US | New Jersey | Mercer | 34021 | 77159 | 1254 | 0 | 40.28047017 | -74.70479631 | 2022-04-19 04:21:00 | Mercer, New Jersey, US | |
3419094 | 3419094 | 2022-04-17 | US | New Jersey | Mercer | 34021 | 77159 | 1254 | 0 | 40.28047017 | -74.70479631 | 2022-04-18 04:21:12 | Mercer, New Jersey, US | |
3732408 | 3732408 | 2022-04-03 | US | New Jersey | Mercer | 34021 | 75975 | 1254 | 0 | 40.28047017 | -74.70479631 | 2022-04-04 04:20:51 | Mercer, New Jersey, US | |
501843 | 501843 | 2022-04-02 | US | New Jersey | Mercer | 34021 | 75975 | 1254 | 0 | 40.28047017 | -74.70479631 | 2022-04-03 04:20:48 | Mercer, New Jersey, US | |
1438758 | 1438758 | 2022-03-28 | US | New Jersey | Mercer | 34021 | 75704 | 1254 | 0 | 40.28047017 | -74.70479631 | 2022-03-29 04:20:46 | Mercer, New Jersey, US | |
1436864 | 1436864 | 2022-03-28 | Singapore | 1072005 | 1254 | 0 | 1.2833 | 103.8333 | 2022-03-29 04:20:46 | Singapore | ||||
878439 | 878439 | 2022-03-27 | US | New Jersey | Mercer | 34021 | 75681 | 1254 | 0 | 40.28047017 | -74.70479631 | 2022-03-28 04:20:33 | Mercer, New Jersey, US | |
2165722 | 2165722 | 2022-03-26 | US | New Jersey | Mercer | 34021 | 75620 | 1254 | 0 | 40.28047017 | -74.70479631 | 2022-03-27 04:20:47 | Mercer, New Jersey, US | |
1723672 | 1723672 | 2022-03-25 | US | Texas | Nueces | 48355 | 99248 | 1254 | 0 | 27.736286 | -97.5433285 | 2022-03-26 04:20:23 | Nueces, Texas, US | |
2449953 | 2449953 | 2022-02-22 | US | Texas | Montgomery | 48339 | 134837 | 1254 | 0 | 30.30079133 | -95.50572772 | 2022-02-23 04:21:09 | Montgomery, Texas, US | |
3674815 | 3674815 | 2022-02-15 | US | Texas | Lubbock | 48303 | 92600 | 1254 | 0 | 33.61008596 | -101.82047890000001 | 2022-02-16 04:21:10 | Lubbock, Texas, US | |
72593 | 72593 | 2022-02-07 | US | Louisiana | East Baton Rouge | 22033 | 108053 | 1254 | 0 | 30.53842039 | -91.09777565 | 2022-02-08 04:21:15 | East Baton Rouge, Louisiana, US | |
2014209 | 2014209 | 2022-02-06 | US | Louisiana | East Baton Rouge | 22033 | 107417 | 1254 | 0 | 30.53842039 | -91.09777565 | 2022-02-07 04:21:05 | East Baton Rouge, Louisiana, US | |
2013299 | 2013299 | 2022-02-06 | US | California | Tulare | 6107 | 124233 | 1254 | 0 | 36.22026558 | -118.8020203 | 2022-02-07 04:21:05 | Tulare, California, US | |
1295538 | 1295538 | 2022-02-05 | US | Louisiana | East Baton Rouge | 22033 | 107417 | 1254 | 0 | 30.53842039 | -91.09777565 | 2022-02-06 04:21:00 | East Baton Rouge, Louisiana, US | |
1294628 | 1294628 | 2022-02-05 | US | California | Tulare | 6107 | 123306 | 1254 | 0 | 36.22026558 | -118.8020203 | 2022-02-06 04:21:00 | Tulare, California, US | |
2328866 | 2328866 | 2022-02-04 | US | Louisiana | East Baton Rouge | 22033 | 107417 | 1254 | 0 | 30.53842039 | -91.09777565 | 2022-02-05 04:21:05 | East Baton Rouge, Louisiana, US | |
2327956 | 2327956 | 2022-02-04 | US | California | Tulare | 6107 | 123226 | 1254 | 0 | 36.22026558 | -118.8020203 | 2022-02-05 04:21:05 | Tulare, California, US | |
555082 | 555082 | 2022-01-16 | Spain | Canarias | 213089 | 1254 | 0 | 28.2916 | -16.6291 | 2022-01-17 04:21:08 | Canarias, Spain | |||
3840803 | 3840803 | 2022-01-15 | Spain | Canarias | 213089 | 1254 | 0 | 28.2916 | -16.6291 | 2022-01-16 04:21:12 | Canarias, Spain | |||
99618 | 99618 | 2022-01-14 | Spain | Canarias | 213089 | 1254 | 0 | 28.2916 | -16.6291 | 2022-01-15 04:21:07 | Canarias, Spain | |||
1282045 | 1282045 | 2022-01-05 | Malaysia | Kelantan | 170664 | 1254 | 0 | 6.1254 | 102.2381 | 2022-01-06 04:22:09 | Kelantan, Malaysia | |||
1285908 | 1285908 | 2022-01-04 | Germany | Saarland | 75028 | 1254 | 0 | 49.3964 | 7.023 | 2022-01-05 04:21:59 | Saarland, Germany | |||
3496061 | 3496061 | 2021-12-15 | Eswatini | 56200 | 1254 | 0 | -26.5225 | 31.4659 | 2021-12-16 04:22:11 | Eswatini | ||||
2087846 | 2087846 | 2021-12-14 | Eswatini | 54731 | 1254 | 0 | -26.5225 | 31.4659 | 2021-12-15 03:22:16 | Eswatini | ||||
1663267 | 1663267 | 2021-12-12 | US | South Carolina | Spartanburg | 45083 | 63807 | 1254 | 0 | 34.92960077 | -81.99225984 | 2021-12-13 04:22:02 | Spartanburg, South Carolina, US | |
1667283 | 1667283 | 2021-12-11 | US | South Carolina | Spartanburg | 45083 | 63807 | 1254 | 0 | 34.92960077 | -81.99225984 | 2021-12-12 04:22:12 | Spartanburg, South Carolina, US | |
3658435 | 3658435 | 2021-12-10 | US | South Carolina | Spartanburg | 45083 | 63807 | 1254 | 0 | 34.92960077 | -81.99225984 | 2021-12-11 04:22:45 | Spartanburg, South Carolina, US | |
1741649 | 1741649 | 2021-12-05 | US | Indiana | Lake | 18089 | 72483 | 1254 | 0 | 41.41874274 | -87.38277575 | 2021-12-06 04:22:34 | Lake, Indiana, US | |
139081 | 139081 | 2021-12-04 | US | Indiana | Lake | 18089 | 72483 | 1254 | 0 | 41.41874274 | -87.38277575 | 2021-12-05 04:22:25 | Lake, Indiana, US | |
2196734 | 2196734 | 2021-12-03 | US | Indiana | Lake | 18089 | 72483 | 1254 | 0 | 41.41874274 | -87.38277575 | 2021-12-04 04:22:18 | Lake, Indiana, US | |
3401570 | 3401570 | 2021-11-30 | Netherlands | Overijssel | 173664 | 1254 | 0 | 52.444557999999994 | 6.441722 | 2021-12-01 04:22:29 | Overijssel, Netherlands | |||
150043 | 150043 | 2021-11-29 | Malaysia | Perak | 122790 | 1254 | 0 | 4.5921 | 101.0901 | 2021-11-30 04:22:53 | Perak, Malaysia | |||
1805261 | 1805261 | 2021-11-25 | US | Ohio | Summit | 39153 | 68882 | 1254 | 0 | 41.12464734 | -81.53123079 | 2021-11-26 04:22:33 | Summit, Ohio, US | |
904415 | 904415 | 2021-11-24 | Russia | Orel Oblast | 61425 | 1254 | 0 | 52.96854329999999 | 36.0692477 | 2021-11-25 04:22:33 | Orel Oblast, Russia | |||
2845159 | 2845159 | 2021-11-10 | Spain | Navarra | 84149 | 1254 | 0 | 42.6954 | -1.6761 | 2021-11-11 04:21:45 | Navarra, Spain | |||
87429 | 87429 | 2021-11-09 | Spain | Navarra | 83931 | 1254 | 0 | 42.6954 | -1.6761 | 2021-11-10 04:21:38 | Navarra, Spain | |||
3639857 | 3639857 | 2021-11-08 | Spain | Navarra | 83931 | 1254 | 0 | 42.6954 | -1.6761 | 2021-11-09 04:21:36 | Navarra, Spain | |||
567344 | 567344 | 2021-10-29 | Russia | Primorsky Krai | 75677 | 1254 | 0 | 45.0819456 | 134.726645 | 2021-10-30 04:22:03 | Primorsky Krai, Russia | |||
4111 | 4111 | 2021-10-28 | Chile | Antofagasta | 62806 | 1254 | 0 | -23.6509 | -70.3975 | 2021-10-29 04:22:03 | Antofagasta, Chile | |||
534501 | 534501 | 2021-10-27 | Chile | Antofagasta | 62712 | 1254 | 0 | -23.6509 | -70.3975 | 2021-10-28 04:22:08 | Antofagasta, Chile | |||
3491938 | 3491938 | 2021-10-26 | Chile | Antofagasta | 62654 | 1254 | 0 | -23.6509 | -70.3975 | 2021-10-27 04:22:32 | Antofagasta, Chile | |||
3793660 | 3793660 | 2021-10-25 | Chile | Antofagasta | 62611 | 1254 | 0 | -23.6509 | -70.3975 | 2021-10-26 04:22:09 | Antofagasta, Chile | |||
685983 | 685983 | 2021-10-24 | Ukraine | Sevastopol* | 36647 | 1254 | 0 | 44.6054 | 33.522 | 2021-10-25 04:22:31 | Sevastopol*, Ukraine | |||
654150 | 654150 | 2021-10-22 | Peru | Amazonas | 31726 | 1254 | 0 | -5.077253 | -78.050172 | 2021-10-23 04:21:32 | Amazonas, Peru | |||
2123897 | 2123897 | 2021-10-21 | Peru | Amazonas | 31726 | 1254 | 0 | -5.077253 | -78.050172 | 2021-10-22 04:21:14 | Amazonas, Peru | |||
443509 | 443509 | 2021-10-20 | Peru | Amazonas | 31726 | 1254 | 0 | -5.077253 | -78.050172 | 2021-10-21 04:21:18 | Amazonas, Peru | |||
492424 | 492424 | 2021-10-14 | US | Georgia | DeKalb | 13089 | 90214 | 1254 | 0 | 33.76944049 | -84.22396017 | 2021-10-15 04:21:26 | DeKalb, Georgia, US | |
1492189 | 1492189 | 2021-10-12 | US | California | Stanislaus | 6099 | 84156 | 1254 | 0 | 37.55862499 | -120.9970722 | 2021-10-13 04:20:51 | Stanislaus, California, US | |
3007489 | 3007489 | 2021-10-11 | Peru | Amazonas | 31619 | 1254 | 0 | -5.077253 | -78.050172 | 2021-10-12 04:21:09 | Amazonas, Peru | |||
423505 | 423505 | 2021-10-10 | Peru | Amazonas | 31619 | 1254 | 0 | -5.077253 | -78.050172 | 2021-10-11 04:21:31 | Amazonas, Peru | |||
2459037 | 2459037 | 2021-10-06 | Russia | Sakha (Yakutiya) Republic | 55449 | 1254 | 0 | 66.941626 | 129.642371 | 2021-10-07 04:21:36 | Sakha (Yakutiya) Republic, Russia | |||
1337097 | 1337097 | 2021-09-28 | US | South Carolina | Greenville | 45045 | 99565 | 1254 | 0 | 34.89502264 | -82.37295012 | 2021-09-29 04:21:45 | Greenville, South Carolina, US | |
1334279 | 1334279 | 2021-09-28 | Japan | Kanagawa | 167330 | 1254 | 0 | 35.415312 | 139.338983 | 2021-09-29 04:21:45 | Kanagawa, Japan | |||
2076724 | 2076724 | 2021-09-26 | US | Georgia | Cobb | 13067 | 104252 | 1254 | 0 | 33.94243204 | -84.5761255 | 2021-09-27 04:21:16 | Cobb, Georgia, US | |
1725276 | 1725276 | 2021-09-25 | US | Georgia | Cobb | 13067 | 104252 | 1254 | 0 | 33.94243204 | -84.5761255 | 2021-09-26 04:21:29 | Cobb, Georgia, US | |
1921996 | 1921996 | 2021-09-24 | US | Georgia | Cobb | 13067 | 104252 | 1254 | 0 | 33.94243204 | -84.5761255 | 2021-09-25 04:21:31 | Cobb, Georgia, US | |
2621682 | 2621682 | 2021-09-17 | Ukraine | Ternopil Oblast | 73502 | 1254 | 0 | 49.5535 | 25.5948 | 2021-09-18 04:21:24 | Ternopil Oblast, Ukraine | |||
180199 | 180199 | 2021-09-02 | US | New Jersey | Morris | 34027 | 53623 | 1254 | 0 | 40.86095313 | -74.54553709999998 | 2021-09-03 04:21:20 | Morris, New Jersey, US | |
2068712 | 2068712 | 2021-08-31 | US | Georgia | Gwinnett | 13135 | 115780 | 1254 | 0 | 33.96044201 | -84.02137802 | 2021-09-01 04:21:38 | Gwinnett, Georgia, US | |
1483778 | 1483778 | 2021-08-13 | Russia | Lipetsk Oblast | 42844 | 1254 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-08-14 04:21:25 | Lipetsk Oblast, Russia | |||
1342289 | 1342289 | 2021-08-11 | Jamaica | 55790 | 1254 | 0 | 18.1096 | -77.2975 | 2021-08-12 04:21:25 | Jamaica | ||||
408377 | 408377 | 2021-07-28 | Mexico | Colima | 15014 | 1254 | 0 | 13760 | 19.1223 | -104.0072 | 2021-07-29 04:21:33 | Colima, Mexico | ||
408274 | 408274 | 2021-07-28 | Italy | Calabria | 70542 | 1254 | 66797 | 2491 | 38.90597598 | 16.59440194 | 2021-07-29 04:21:33 | Calabria, Italy | ||
1306135 | 1306135 | 2021-07-27 | Italy | Calabria | 70397 | 1254 | 66719 | 2424 | 38.90597598 | 16.59440194 | 2021-07-28 04:21:39 | Calabria, Italy | ||
1330008 | 1330008 | 2021-07-24 | Cambodia | 72104 | 1254 | 64548 | 6302 | 11.55 | 104.9167 | 2021-07-25 04:22:12 | Cambodia | |||
579087 | 579087 | 2021-07-13 | Russia | Tver Oblast | 48905 | 1254 | 42561 | 5090 | 57.1134475 | 35.174442799999994 | 2021-07-14 04:21:35 | Tver Oblast, Russia | ||
3741616 | 3741616 | 2021-07-12 | US | California | Alameda | 6001 | 92739 | 1254 | 0 | 37.64629437 | -121.8929271 | 2021-07-13 04:21:18 | Alameda, California, US | |
3741318 | 3741318 | 2021-07-12 | Russia | Penza Oblast | 51825 | 1254 | 45746 | 4825 | 53.1655415 | 44.78791810000001 | 2021-07-13 04:21:18 | Penza Oblast, Russia |
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]);