johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
109 rows where deaths = 1854 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3714792 | 3714792 | 2022-12-06 | US | Colorado | El Paso | 8041 | 230774 | 1854 | 0 | 38.83240149 | -104.5251411 | 2022-12-07 04:20:58 | El Paso, Colorado, US | |
911980 | 911980 | 2022-10-29 | Chile | Coquimbo | 190748 | 1854 | 0 | -29.959 | -71.3389 | 2022-10-30 04:22:14 | Coquimbo, Chile | |||
1366249 | 1366249 | 2022-10-28 | Chile | Coquimbo | 190549 | 1854 | 0 | -29.959 | -71.3389 | 2022-10-29 04:21:13 | Coquimbo, Chile | |||
3250941 | 3250941 | 2022-10-11 | US | Georgia | DeKalb | 13089 | 180538 | 1854 | 0 | 33.76944049 | -84.22396017 | 2022-10-12 04:22:51 | DeKalb, Georgia, US | |
2968200 | 2968200 | 2022-10-10 | US | Georgia | DeKalb | 13089 | 180538 | 1854 | 0 | 33.76944049 | -84.22396017 | 2022-10-11 04:23:05 | DeKalb, Georgia, US | |
3098236 | 3098236 | 2022-10-09 | US | Georgia | DeKalb | 13089 | 180538 | 1854 | 0 | 33.76944049 | -84.22396017 | 2022-10-10 04:22:32 | DeKalb, Georgia, US | |
4003461 | 4003461 | 2022-10-08 | US | Georgia | DeKalb | 13089 | 180538 | 1854 | 0 | 33.76944049 | -84.22396017 | 2022-10-09 04:21:16 | DeKalb, Georgia, US | |
397058 | 397058 | 2022-10-07 | US | Georgia | DeKalb | 13089 | 180538 | 1854 | 0 | 33.76944049 | -84.22396017 | 2022-10-08 04:22:56 | DeKalb, Georgia, US | |
2530175 | 2530175 | 2022-10-06 | US | Georgia | DeKalb | 13089 | 180538 | 1854 | 0 | 33.76944049 | -84.22396017 | 2022-10-07 04:23:08 | DeKalb, Georgia, US | |
1811569 | 1811569 | 2022-10-05 | US | Georgia | DeKalb | 13089 | 180538 | 1854 | 0 | 33.76944049 | -84.22396017 | 2022-10-06 04:21:22 | DeKalb, Georgia, US | |
2770602 | 2770602 | 2022-09-26 | US | Michigan | Genesee | 26049 | 116977 | 1854 | 0 | 43.02244215 | -83.70589709 | 2022-09-27 04:23:01 | Genesee, Michigan, US | |
1978255 | 1978255 | 2022-09-25 | US | Michigan | Genesee | 26049 | 116977 | 1854 | 0 | 43.02244215 | -83.70589709 | 2022-09-26 04:20:52 | Genesee, Michigan, US | |
2651422 | 2651422 | 2022-09-24 | US | Michigan | Genesee | 26049 | 116977 | 1854 | 0 | 43.02244215 | -83.70589709 | 2022-09-25 04:23:31 | Genesee, Michigan, US | |
385862 | 385862 | 2022-09-23 | US | Michigan | Genesee | 26049 | 116977 | 1854 | 0 | 43.02244215 | -83.70589709 | 2022-09-24 04:21:40 | Genesee, Michigan, US | |
1625928 | 1625928 | 2022-09-22 | US | Michigan | Genesee | 26049 | 116977 | 1854 | 0 | 43.02244215 | -83.70589709 | 2022-09-23 04:23:13 | Genesee, Michigan, US | |
1372132 | 1372132 | 2022-09-21 | US | Michigan | Genesee | 26049 | 116977 | 1854 | 0 | 43.02244215 | -83.70589709 | 2022-09-22 04:22:56 | Genesee, Michigan, US | |
2018362 | 2018362 | 2022-09-20 | US | Michigan | Genesee | 26049 | 116977 | 1854 | 0 | 43.02244215 | -83.70589709 | 2022-09-21 04:23:22 | Genesee, Michigan, US | |
1876752 | 1876752 | 2022-08-28 | Chile | Antofagasta | 162078 | 1854 | 0 | -23.6509 | -70.3975 | 2022-08-29 04:21:06 | Antofagasta, Chile | |||
2095879 | 2095879 | 2022-08-27 | Chile | Antofagasta | 161825 | 1854 | 0 | -23.6509 | -70.3975 | 2022-08-28 04:21:02 | Antofagasta, Chile | |||
1531694 | 1531694 | 2022-08-26 | Chile | Antofagasta | 161567 | 1854 | 0 | -23.6509 | -70.3975 | 2022-08-27 04:20:57 | Antofagasta, Chile | |||
1211846 | 1211846 | 2022-07-11 | Spain | Canarias | 417940 | 1854 | 0 | 28.2916 | -16.6291 | 2022-07-12 04:20:51 | Canarias, Spain | |||
2790146 | 2790146 | 2022-07-10 | US | Indiana | Lake | 18089 | 115083 | 1854 | 0 | 41.41874274 | -87.38277575 | 2022-07-11 04:20:46 | Lake, Indiana, US | |
2789328 | 2789328 | 2022-07-10 | Spain | Canarias | 417940 | 1854 | 0 | 28.2916 | -16.6291 | 2022-07-11 04:20:46 | Canarias, Spain | |||
143099 | 143099 | 2022-07-09 | US | Indiana | Lake | 18089 | 115083 | 1854 | 0 | 41.41874274 | -87.38277575 | 2022-07-10 04:20:54 | Lake, Indiana, US | |
142281 | 142281 | 2022-07-09 | Spain | Canarias | 417940 | 1854 | 0 | 28.2916 | -16.6291 | 2022-07-10 04:20:54 | Canarias, Spain | |||
1419256 | 1419256 | 2022-07-08 | US | New Jersey | Camden | 34007 | 140612 | 1854 | 0 | 39.80343818 | -74.96388753 | 2022-07-09 04:20:59 | Camden, New Jersey, US | |
1418199 | 1418199 | 2022-07-08 | US | Indiana | Lake | 18089 | 115083 | 1854 | 0 | 41.41874274 | -87.38277575 | 2022-07-09 04:20:59 | Lake, Indiana, US | |
1417381 | 1417381 | 2022-07-08 | Spain | Canarias | 417940 | 1854 | 0 | 28.2916 | -16.6291 | 2022-07-09 04:20:59 | Canarias, Spain | |||
2311545 | 2311545 | 2022-06-17 | Russia | Pskov Oblast | 111013 | 1854 | 0 | 57.5358729 | 28.8586826 | 2022-06-18 04:21:10 | Pskov Oblast, Russia | |||
559049 | 559049 | 2022-06-16 | Russia | Pskov Oblast | 110991 | 1854 | 0 | 57.5358729 | 28.8586826 | 2022-06-17 04:20:56 | Pskov Oblast, Russia | |||
3982851 | 3982851 | 2022-06-15 | Russia | Pskov Oblast | 110967 | 1854 | 0 | 57.5358729 | 28.8586826 | 2022-06-16 04:20:55 | Pskov Oblast, Russia | |||
2086146 | 2086146 | 2022-05-15 | US | New Mexico | Bernalillo | 35001 | 149543 | 1854 | 0 | 35.05163625 | -106.6703554 | 2022-05-16 04:20:47 | Bernalillo, New Mexico, US | |
3356856 | 3356856 | 2022-05-14 | US | New Mexico | Bernalillo | 35001 | 149543 | 1854 | 0 | 35.05163625 | -106.6703554 | 2022-05-15 04:20:53 | Bernalillo, New Mexico, US | |
660501 | 660501 | 2022-05-13 | US | New Mexico | Bernalillo | 35001 | 149543 | 1854 | 0 | 35.05163625 | -106.6703554 | 2022-05-14 04:20:48 | Bernalillo, New Mexico, US | |
2307491 | 2307491 | 2022-04-20 | Russia | Kabardino-Balkarian Republic | 61351 | 1854 | 0 | 43.480604799999995 | 43.5978976 | 2022-04-21 04:20:46 | Kabardino-Balkarian Republic, Russia | |||
2115953 | 2115953 | 2022-04-08 | Russia | Orel Oblast | 109472 | 1854 | 0 | 52.96854329999999 | 36.0692477 | 2022-04-09 04:20:42 | Orel Oblast, Russia | |||
261517 | 261517 | 2022-03-15 | Japan | Aichi | 375123 | 1854 | 0 | 35.035551 | 137.211621 | 2022-03-16 04:20:50 | Aichi, Japan | |||
1868132 | 1868132 | 2022-03-10 | US | Pennsylvania | Bucks | 42017 | 122181 | 1854 | 0 | 40.33682119 | -75.10836643 | 2022-03-11 04:20:50 | Bucks, Pennsylvania, US | |
1550652 | 1550652 | 2022-03-07 | US | Pennsylvania | Lancaster | 42071 | 120295 | 1854 | 0 | 40.03904563 | -76.24770128 | 2022-03-08 04:20:54 | Lancaster, Pennsylvania, US | |
2202321 | 2202321 | 2022-03-06 | US | Pennsylvania | Lancaster | 42071 | 120277 | 1854 | 0 | 40.03904563 | -76.24770128 | 2022-03-07 04:20:47 | Lancaster, Pennsylvania, US | |
1318460 | 1318460 | 2022-01-26 | Russia | Sakha (Yakutiya) Republic | 87342 | 1854 | 0 | 66.941626 | 129.642371 | 2022-01-27 04:21:19 | Sakha (Yakutiya) Republic, Russia | |||
2054484 | 2054484 | 2022-01-25 | US | Oklahoma | Tulsa | 40143 | 137519 | 1854 | 0 | 36.11939621 | -95.94013939 | 2022-01-26 04:21:07 | Tulsa, Oklahoma, US | |
1230215 | 1230215 | 2022-01-24 | US | Oklahoma | Tulsa | 40143 | 137519 | 1854 | 0 | 36.11939621 | -95.94013939 | 2022-01-25 04:21:05 | Tulsa, Oklahoma, US | |
1143514 | 1143514 | 2022-01-23 | US | Oklahoma | Tulsa | 40143 | 137519 | 1854 | 0 | 36.11939621 | -95.94013939 | 2022-01-24 04:21:12 | Tulsa, Oklahoma, US | |
2835432 | 2835432 | 2022-01-22 | US | Oklahoma | Tulsa | 40143 | 137519 | 1854 | 0 | 36.11939621 | -95.94013939 | 2022-01-23 04:21:13 | Tulsa, Oklahoma, US | |
3427550 | 3427550 | 2022-01-21 | US | Oklahoma | Tulsa | 40143 | 137519 | 1854 | 0 | 36.11939621 | -95.94013939 | 2022-01-22 04:21:13 | Tulsa, Oklahoma, US | |
3424661 | 3424661 | 2022-01-21 | Brazil | Acre | 92004 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-22 04:21:13 | Acre, Brazil | |||
1963158 | 1963158 | 2022-01-20 | US | Oklahoma | Tulsa | 40143 | 137519 | 1854 | 0 | 36.11939621 | -95.94013939 | 2022-01-21 04:21:09 | Tulsa, Oklahoma, US | |
1960809 | 1960809 | 2022-01-20 | Russia | Tambov Oblast | 64507 | 1854 | 0 | 52.9019574 | 41.3578918 | 2022-01-21 04:21:09 | Tambov Oblast, Russia | |||
1960269 | 1960269 | 2022-01-20 | Brazil | Acre | 91781 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-21 04:21:09 | Acre, Brazil | |||
3229053 | 3229053 | 2022-01-19 | US | Oklahoma | Tulsa | 40143 | 137519 | 1854 | 0 | 36.11939621 | -95.94013939 | 2022-01-20 04:21:07 | Tulsa, Oklahoma, US | |
3226164 | 3226164 | 2022-01-19 | Brazil | Acre | 91471 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-20 04:21:07 | Acre, Brazil | |||
3463889 | 3463889 | 2022-01-18 | Brazil | Acre | 90299 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-19 04:21:23 | Acre, Brazil | |||
1471828 | 1471828 | 2022-01-17 | Brazil | Acre | 90250 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-18 04:21:04 | Acre, Brazil | |||
554502 | 554502 | 2022-01-16 | Brazil | Acre | 89801 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-17 04:21:08 | Acre, Brazil | |||
3840223 | 3840223 | 2022-01-15 | Brazil | Acre | 89635 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-16 04:21:12 | Acre, Brazil | |||
99038 | 99038 | 2022-01-14 | Brazil | Acre | 89529 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-15 04:21:07 | Acre, Brazil | |||
3687193 | 3687193 | 2022-01-13 | Brazil | Acre | 89244 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-14 04:21:54 | Acre, Brazil | |||
3612777 | 3612777 | 2022-01-12 | Brazil | Acre | 88813 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-13 08:00:09 | Acre, Brazil | |||
1113302 | 1113302 | 2022-01-11 | Brazil | Acre | 88628 | 1854 | 0 | -9.0238 | -70.812 | 2022-01-12 04:21:44 | Acre, Brazil | |||
3816197 | 3816197 | 2021-12-23 | Chile | Maule | 109376 | 1854 | 0 | -35.5183 | -71.6885 | 2021-12-24 04:21:34 | Maule, Chile | |||
447267 | 447267 | 2021-11-17 | Germany | Hamburg | 105630 | 1854 | 0 | 53.5511 | 9.9937 | 2021-11-18 04:21:33 | Hamburg, Germany | |||
718114 | 718114 | 2021-11-12 | Ukraine | Zakarpattia Oblast | 73195 | 1854 | 0 | 48.6208 | 22.2879 | 2021-11-13 04:21:38 | Zakarpattia Oblast, Ukraine | |||
46398 | 46398 | 2021-11-02 | US | Pennsylvania | Montgomery | 42091 | 86706 | 1854 | 0 | 40.21053671 | -75.36652296 | 2021-11-03 06:22:09 | Montgomery, Pennsylvania, US | |
46291 | 46291 | 2021-11-02 | US | Oklahoma | Oklahoma | 40109 | 119447 | 1854 | 0 | 35.55140095 | -97.40716948 | 2021-11-03 06:22:09 | Oklahoma, Oklahoma, US | |
3513987 | 3513987 | 2021-11-01 | US | Oklahoma | Oklahoma | 40109 | 119447 | 1854 | 0 | 35.55140095 | -97.40716948 | 2021-11-02 04:22:03 | Oklahoma, Oklahoma, US | |
290578 | 290578 | 2021-10-31 | US | Oklahoma | Oklahoma | 40109 | 119447 | 1854 | 0 | 35.55140095 | -97.40716948 | 2021-11-01 04:22:01 | Oklahoma, Oklahoma, US | |
2723584 | 2723584 | 2021-10-30 | US | Oklahoma | Oklahoma | 40109 | 119447 | 1854 | 0 | 35.55140095 | -97.40716948 | 2021-10-31 04:22:08 | Oklahoma, Oklahoma, US | |
570747 | 570747 | 2021-10-29 | Ukraine | Sumy Oblast | 104138 | 1854 | 0 | 50.9077 | 34.7981 | 2021-10-30 04:22:03 | Sumy Oblast, Ukraine | |||
569686 | 569686 | 2021-10-29 | US | Oklahoma | Oklahoma | 40109 | 119447 | 1854 | 0 | 35.55140095 | -97.40716948 | 2021-10-30 04:22:03 | Oklahoma, Oklahoma, US | |
6928 | 6928 | 2021-10-28 | US | Oklahoma | Oklahoma | 40109 | 119447 | 1854 | 0 | 35.55140095 | -97.40716948 | 2021-10-29 04:22:03 | Oklahoma, Oklahoma, US | |
537318 | 537318 | 2021-10-27 | US | Oklahoma | Oklahoma | 40109 | 119447 | 1854 | 0 | 35.55140095 | -97.40716948 | 2021-10-28 04:22:08 | Oklahoma, Oklahoma, US | |
443604 | 443604 | 2021-10-20 | Russia | Smolensk Oblast | 55780 | 1854 | 0 | 55.03434960000001 | 33.0192065 | 2021-10-21 04:21:18 | Smolensk Oblast, Russia | |||
1909435 | 1909435 | 2021-10-17 | Russia | Lipetsk Oblast | 57637 | 1854 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-10-18 04:21:10 | Lipetsk Oblast, Russia | |||
706376 | 706376 | 2021-09-29 | India | Manipur | 120426 | 1854 | 0 | 24.738975 | 93.882541 | 2021-09-30 04:21:20 | Manipur, India | |||
1334540 | 1334540 | 2021-09-28 | Russia | Vologda Oblast | 68224 | 1854 | 0 | 60.0391461 | 43.1215213 | 2021-09-29 04:21:45 | Vologda Oblast, Russia | |||
1921495 | 1921495 | 2021-09-24 | Senegal | 73719 | 1854 | 0 | 14.4974 | -14.4524 | 2021-09-25 04:21:31 | Senegal | ||||
2464396 | 2464396 | 2021-09-14 | US | Massachusetts | Worcester | 25027 | 85868 | 1854 | 0 | 42.35026951 | -71.90493363 | 2021-09-15 03:22:37 | Worcester, Massachusetts, US | |
3976794 | 3976794 | 2021-09-03 | US | New York | Erie | 36029 | 95148 | 1854 | 0 | 42.76249024 | -78.73063652 | 2021-09-04 04:21:28 | Erie, New York, US | |
2175850 | 2175850 | 2021-08-22 | Spain | Extremadura | 96614 | 1854 | 0 | 39.4937 | -6.0679 | 2021-08-23 04:21:27 | Extremadura, Spain | |||
3555946 | 3555946 | 2021-08-21 | Spain | Extremadura | 96614 | 1854 | 0 | 39.4937 | -6.0679 | 2021-08-22 04:21:29 | Extremadura, Spain | |||
1854288 | 1854288 | 2021-08-20 | Spain | Extremadura | 96614 | 1854 | 0 | 39.4937 | -6.0679 | 2021-08-21 04:21:38 | Extremadura, Spain | |||
511995 | 511995 | 2021-08-19 | Spain | Extremadura | 96115 | 1854 | 0 | 39.4937 | -6.0679 | 2021-08-20 04:21:33 | Extremadura, Spain | |||
3385139 | 3385139 | 2021-07-29 | Brazil | Roraima | 119828 | 1854 | 112425 | 5298 | -2.7376 | -62.0751 | 2021-07-30 04:21:34 | Roraima, Brazil | ||
1306404 | 1306404 | 2021-07-27 | Russia | Stavropol Krai | 63342 | 1854 | 56146 | 5342 | 44.86325770000001 | 43.4406913 | 2021-07-28 04:21:39 | Stavropol Krai, Russia | ||
829818 | 829818 | 2021-07-09 | Russia | Leningrad Oblast | 50695 | 1854 | 45479 | 3362 | 60.1853296 | 32.3925325 | 2021-07-10 04:21:25 | Leningrad Oblast, Russia | ||
1892998 | 1892998 | 2021-06-30 | Colombia | Risaralda | 75877 | 1854 | 71419 | 2604 | 5.3158 | -75.9928 | 2021-07-01 04:21:19 | Risaralda, Colombia | ||
111079 | 111079 | 2021-06-19 | Ukraine | Khmelnytskyi Oblast | 88749 | 1854 | 86053 | 842 | 49.423 | 26.9871 | 2021-06-20 04:21:48 | Khmelnytskyi Oblast, Ukraine | ||
83325 | 83325 | 2021-05-25 | Russia | Novosibirsk Oblast | 42891 | 1854 | 38866 | 2171 | 54.9720169 | 79.48139240000002 | 2021-05-26 04:20:35 | Novosibirsk Oblast, Russia | ||
3393244 | 3393244 | 2021-04-28 | Colombia | Huila | 53438 | 1854 | 50875 | 709 | 2.5359 | -75.5277 | 2021-04-29 04:20:55 | Huila, Colombia | ||
3393181 | 3393181 | 2021-04-28 | Chile | Biobio | 113921 | 1854 | 108697 | 3370 | -37.4464 | -72.1416 | 2021-04-29 04:20:55 | Biobio, Chile | ||
3705752 | 3705752 | 2021-04-27 | Ukraine | Zaporizhia Oblast | 94375 | 1854 | 75409 | 17112 | 47.8388 | 35.1396 | 2021-04-28 04:20:32 | Zaporizhia Oblast, Ukraine | ||
3701897 | 3701897 | 2021-04-27 | Chile | Biobio | 113642 | 1854 | 108091 | 3697 | -37.4464 | -72.1416 | 2021-04-28 04:20:32 | Biobio, Chile | ||
887906 | 887906 | 2021-04-26 | Chile | Biobio | 113301 | 1854 | 107493 | 3954 | -37.4464 | -72.1416 | 2021-04-27 04:20:52 | Biobio, Chile | ||
241437 | 241437 | 2021-04-02 | Russia | Altai Krai | 47330 | 1854 | 42374 | 3102 | 52.6932243 | 82.69314240000001 | 2021-04-03 04:20:44 | Altai Krai, Russia | ||
3621203 | 3621203 | 2021-03-17 | Netherlands | Gelderland | 130562 | 1854 | 0 | 128530 | 52.061738 | 5.939114 | 2021-03-18 05:26:22 | Gelderland, Netherlands | ||
1580323 | 1580323 | 2021-03-13 | Peru | San Martin | 30888 | 1854 | 0 | 29034 | -7.039531 | -76.729127 | 2021-03-14 05:25:37 | San Martin, Peru | ||
3962717 | 3962717 | 2021-03-10 | Russia | Irkutsk Oblast | 57752 | 1854 | 55362 | 536 | 56.6370122 | 104.719221 | 2021-03-11 05:25:48 | Irkutsk Oblast, Russia | ||
54964 | 54964 | 2021-03-07 | Peru | Huanuco | 25431 | 1854 | 0 | 23577 | -9.421676 | -76.040642 | 2021-03-08 05:24:48 | Huanuco, Peru | ||
2367381 | 2367381 | 2021-02-28 | El Salvador | 60181 | 1854 | 55312 | 3015 | 13.7942 | -88.8965 | 2021-03-01 05:23:01 | El Salvador |
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]);