johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
109 rows where deaths = 1807 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3598029 | 3598029 | 2022-11-14 | US | Illinois | DuPage | 17043 | 272260 | 1807 | 0 | 41.85116968 | -88.08642662 | 2022-11-15 04:21:16 | DuPage, Illinois, US | |
314421 | 314421 | 2022-11-13 | US | Ohio | Summit | 39153 | 135047 | 1807 | 0 | 41.12464734 | -81.53123079 | 2022-11-14 04:21:09 | Summit, Ohio, US | |
3950630 | 3950630 | 2022-08-17 | New Zealand | 1705597 | 1807 | 0 | -40.9006 | 174.886 | 2022-08-18 04:21:11 | New Zealand | ||||
3618717 | 3618717 | 2022-08-01 | US | Michigan | Genesee | 26049 | 110852 | 1807 | 0 | 43.02244215 | -83.70589709 | 2022-08-02 04:20:53 | Genesee, Michigan, US | |
3873197 | 3873197 | 2022-07-31 | US | Michigan | Genesee | 26049 | 110852 | 1807 | 0 | 43.02244215 | -83.70589709 | 2022-08-01 04:21:03 | Genesee, Michigan, US | |
675951 | 675951 | 2022-07-30 | US | Michigan | Genesee | 26049 | 110852 | 1807 | 0 | 43.02244215 | -83.70589709 | 2022-07-31 04:21:02 | Genesee, Michigan, US | |
1785150 | 1785150 | 2022-07-29 | US | Michigan | Genesee | 26049 | 110852 | 1807 | 0 | 43.02244215 | -83.70589709 | 2022-07-30 04:20:42 | Genesee, Michigan, US | |
1067513 | 1067513 | 2022-07-28 | US | Michigan | Genesee | 26049 | 110852 | 1807 | 0 | 43.02244215 | -83.70589709 | 2022-07-29 04:20:45 | Genesee, Michigan, US | |
2337032 | 2337032 | 2022-07-27 | US | Michigan | Genesee | 26049 | 110852 | 1807 | 0 | 43.02244215 | -83.70589709 | 2022-07-28 04:20:56 | Genesee, Michigan, US | |
1489222 | 1489222 | 2022-07-26 | US | Michigan | Genesee | 26049 | 110852 | 1807 | 0 | 43.02244215 | -83.70589709 | 2022-07-27 04:21:04 | Genesee, Michigan, US | |
1648672 | 1648672 | 2022-06-23 | Spain | Canarias | 395209 | 1807 | 0 | 28.2916 | -16.6291 | 2022-06-24 04:20:58 | Canarias, Spain | |||
2187907 | 2187907 | 2022-06-22 | Spain | Canarias | 395209 | 1807 | 0 | 28.2916 | -16.6291 | 2022-06-23 04:20:55 | Canarias, Spain | |||
166338 | 166338 | 2022-06-21 | Spain | Canarias | 395209 | 1807 | 0 | 28.2916 | -16.6291 | 2022-06-22 04:20:54 | Canarias, Spain | |||
2086127 | 2086127 | 2022-05-15 | US | New Jersey | Camden | 34007 | 130717 | 1807 | 0 | 39.80343818 | -74.96388753 | 2022-05-16 04:20:47 | Camden, New Jersey, US | |
3356837 | 3356837 | 2022-05-14 | US | New Jersey | Camden | 34007 | 130534 | 1807 | 0 | 39.80343818 | -74.96388753 | 2022-05-15 04:20:53 | Camden, New Jersey, US | |
660482 | 660482 | 2022-05-13 | US | New Jersey | Camden | 34007 | 130289 | 1807 | 0 | 39.80343818 | -74.96388753 | 2022-05-14 04:20:48 | Camden, New Jersey, US | |
2535565 | 2535565 | 2022-05-12 | US | New Jersey | Camden | 34007 | 129945 | 1807 | 0 | 39.80343818 | -74.96388753 | 2022-05-13 04:20:51 | Camden, New Jersey, US | |
3447011 | 3447011 | 2022-05-11 | US | New Jersey | Camden | 34007 | 129462 | 1807 | 0 | 39.80343818 | -74.96388753 | 2022-05-12 04:20:54 | Camden, New Jersey, US | |
3536240 | 3536240 | 2022-05-10 | US | Georgia | Cobb | 13067 | 175497 | 1807 | 0 | 33.94243204 | -84.5761255 | 2022-05-11 04:20:48 | Cobb, Georgia, US | |
222775 | 222775 | 2022-05-09 | US | Georgia | Cobb | 13067 | 175497 | 1807 | 0 | 33.94243204 | -84.5761255 | 2022-05-10 04:20:50 | Cobb, Georgia, US | |
2332160 | 2332160 | 2022-05-08 | US | Georgia | Cobb | 13067 | 175497 | 1807 | 0 | 33.94243204 | -84.5761255 | 2022-05-09 04:20:54 | Cobb, Georgia, US | |
361122 | 361122 | 2022-05-07 | US | Georgia | Cobb | 13067 | 175497 | 1807 | 0 | 33.94243204 | -84.5761255 | 2022-05-08 04:20:49 | Cobb, Georgia, US | |
1398473 | 1398473 | 2022-05-06 | US | Georgia | Cobb | 13067 | 175497 | 1807 | 0 | 33.94243204 | -84.5761255 | 2022-05-07 04:21:09 | Cobb, Georgia, US | |
2598828 | 2598828 | 2022-05-05 | US | Georgia | Cobb | 13067 | 175497 | 1807 | 0 | 33.94243204 | -84.5761255 | 2022-05-06 04:21:00 | Cobb, Georgia, US | |
3266277 | 3266277 | 2022-05-04 | US | Georgia | Cobb | 13067 | 175497 | 1807 | 0 | 33.94243204 | -84.5761255 | 2022-05-05 04:20:55 | Cobb, Georgia, US | |
2251667 | 2251667 | 2022-04-19 | Russia | Pskov Oblast | 108831 | 1807 | 0 | 57.535872899999994 | 28.8586826 | 2022-04-20 04:20:45 | Pskov Oblast, Russia | |||
1225785 | 1225785 | 2022-04-14 | US | New Mexico | Bernalillo | 35001 | 147121 | 1807 | 0 | 35.05163625 | -106.6703554 | 2022-04-15 04:20:57 | Bernalillo, New Mexico, US | |
3320446 | 3320446 | 2022-04-07 | Russia | Kaliningrad Oblast | 166085 | 1807 | 0 | 54.7293041 | 21.1489473 | 2022-04-08 04:20:48 | Kaliningrad Oblast, Russia | |||
2264096 | 2264096 | 2022-03-14 | Russia | Kabardino-Balkarian Republic | 59923 | 1807 | 0 | 43.480604799999995 | 43.5978976 | 2022-03-15 04:20:47 | Kabardino-Balkarian Republic, Russia | |||
3628771 | 3628771 | 2022-03-13 | US | Georgia | Gwinnett | 13135 | 205646 | 1807 | 0 | 33.96044201 | -84.02137802 | 2022-03-14 04:20:46 | Gwinnett, Georgia, US | |
951679 | 951679 | 2022-03-12 | US | Georgia | Gwinnett | 13135 | 205646 | 1807 | 0 | 33.96044201 | -84.02137802 | 2022-03-13 04:20:49 | Gwinnett, Georgia, US | |
357140 | 357140 | 2022-03-11 | US | Georgia | Gwinnett | 13135 | 205646 | 1807 | 0 | 33.96044201 | -84.02137802 | 2022-03-12 04:20:50 | Gwinnett, Georgia, US | |
2092093 | 2092093 | 2022-03-05 | Japan | Hokkaido | 182018 | 1807 | 0 | 43.385711 | 142.55231799999999 | 2022-03-06 04:20:49 | Hokkaido, Japan | |||
942895 | 942895 | 2022-02-28 | Malaysia | Pulau Pinang | 210325 | 1807 | 0 | 5.4141 | 100.3288 | 2022-03-01 04:21:09 | Pulau Pinang, Malaysia | |||
1780993 | 1780993 | 2022-01-27 | US | Massachusetts | Suffolk | 25025 | 196144 | 1807 | 0 | 42.327951399999996 | -71.07850442 | 2022-01-28 04:21:09 | Suffolk, Massachusetts, US | |
1227591 | 1227591 | 2022-01-24 | Italy | Sardegna | 117095 | 1807 | 0 | 39.21531192 | 9.110616306 | 2022-01-25 04:21:05 | Sardegna, Italy | |||
1116060 | 1116060 | 2022-01-11 | US | Ohio | Hamilton | 39061 | 151013 | 1807 | 0 | 39.19673558 | -84.54502924 | 2022-01-12 04:21:44 | Hamilton, Ohio, US | |
1030281 | 1030281 | 2021-12-06 | Germany | Schleswig-Holstein | 100103 | 1807 | 0 | 54.2194 | 9.6961 | 2021-12-07 04:22:34 | Schleswig-Holstein, Germany | |||
3288690 | 3288690 | 2021-11-18 | Chile | Maule | 106235 | 1807 | 0 | -35.5183 | -71.6885 | 2021-11-19 04:21:40 | Maule, Chile | |||
447948 | 447948 | 2021-11-17 | US | California | San Joaquin | 6077 | 106240 | 1807 | 0 | 37.93433732 | -121.2730061 | 2021-11-18 04:21:33 | San Joaquin, California, US | |
2047524 | 2047524 | 2021-10-18 | Yemen | 9556 | 1807 | 0 | 15.552726999999999 | 48.516388 | 2021-10-19 04:20:54 | Yemen | ||||
1374686 | 1374686 | 2021-09-15 | Russia | Buryatia Republic | 57565 | 1807 | 0 | 52.718242599999996 | 109.492143 | 2021-09-16 04:22:19 | Buryatia Republic, Russia | |||
3448800 | 3448800 | 2021-09-10 | India | Manipur | 116607 | 1807 | 0 | 24.738975 | 93.882541 | 2021-09-11 04:21:30 | Manipur, India | |||
642515 | 642515 | 2021-09-07 | US | California | Santa Clara | 6085 | 137664 | 1807 | 0 | 37.23104908 | -121.6970462 | 2021-09-08 04:21:31 | Santa Clara, California, US | |
3194578 | 3194578 | 2021-09-06 | US | California | Santa Clara | 6085 | 137489 | 1807 | 0 | 37.23104908 | -121.6970462 | 2021-09-07 04:21:35 | Santa Clara, California, US | |
3281446 | 3281446 | 2021-09-05 | US | California | Santa Clara | 6085 | 137175 | 1807 | 0 | 37.23104908 | -121.6970462 | 2021-09-06 04:21:22 | Santa Clara, California, US | |
3891695 | 3891695 | 2021-08-29 | Canada | British Columbia | 163560 | 1807 | 0 | 53.7267 | -127.6476 | 2021-08-30 04:21:23 | British Columbia, Canada | |||
2792798 | 2792798 | 2021-08-28 | Canada | British Columbia | 163560 | 1807 | 0 | 53.7267 | -127.6476 | 2021-08-29 04:21:14 | British Columbia, Canada | |||
2922957 | 2922957 | 2021-08-27 | Canada | British Columbia | 163560 | 1807 | 0 | 53.7267 | -127.6476 | 2021-08-28 04:21:28 | British Columbia, Canada | |||
3166194 | 3166194 | 2021-08-23 | US | California | Sacramento | 6067 | 131758 | 1807 | 0 | 38.45106826 | -121.34253740000001 | 2021-08-24 04:21:19 | Sacramento, California, US | |
2521799 | 2521799 | 2021-08-18 | Ukraine | Chernivtsi Oblast | 80658 | 1807 | 0 | 48.2917 | 25.9352 | 2021-08-19 04:21:15 | Chernivtsi Oblast, Ukraine | |||
103054 | 103054 | 2021-08-15 | Brazil | Acre | 87489 | 1807 | 0 | -9.0238 | -70.812 | 2021-08-16 04:21:31 | Acre, Brazil | |||
507412 | 507412 | 2021-08-14 | Brazil | Acre | 87487 | 1807 | 0 | -9.0238 | -70.812 | 2021-08-15 04:21:41 | Acre, Brazil | |||
1483284 | 1483284 | 2021-08-13 | Brazil | Acre | 87485 | 1807 | 0 | -9.0238 | -70.812 | 2021-08-14 04:21:25 | Acre, Brazil | |||
2899414 | 2899414 | 2021-08-12 | Brazil | Acre | 87476 | 1807 | 0 | -9.0238 | -70.812 | 2021-08-13 04:21:24 | Acre, Brazil | |||
2351634 | 2351634 | 2021-08-10 | Russia | Chuvashia Republic | 30050 | 1807 | 0 | 55.4259922 | 47.0849429 | 2021-08-11 04:21:58 | Chuvashia Republic, Russia | |||
651570 | 651570 | 2021-08-09 | US | Massachusetts | Worcester | 25027 | 79192 | 1807 | 0 | 42.35026951 | -71.90493363 | 2021-08-10 04:21:27 | Worcester, Massachusetts, US | |
1958245 | 1958245 | 2021-08-05 | US | Minnesota | Hennepin | 27053 | 128141 | 1807 | 0 | 45.00761521 | -93.47694895 | 2021-08-06 04:21:18 | Hennepin, Minnesota, US | |
335552 | 335552 | 2021-08-04 | Ukraine | Zhytomyr Oblast | 88900 | 1807 | 86834 | 259 | 50.2547 | 28.6587 | 2021-08-05 04:21:51 | Zhytomyr Oblast, Ukraine | ||
333624 | 333624 | 2021-08-04 | US | Minnesota | Hennepin | 27053 | 127906 | 1807 | 0 | 45.00761521 | -93.47694895 | 2021-08-05 04:21:51 | Hennepin, Minnesota, US | |
332153 | 332153 | 2021-08-04 | Russia | Saratov Oblast | 74102 | 1807 | 68986 | 3309 | 51.6520555 | 46.86319520000001 | 2021-08-05 04:21:51 | Saratov Oblast, Russia | ||
3386498 | 3386498 | 2021-07-29 | US | Indiana | Marion | 18097 | 105762 | 1807 | 0 | 39.78163624 | -86.13826325 | 2021-07-30 04:21:34 | Marion, Indiana, US | |
409403 | 409403 | 2021-07-28 | US | Indiana | Marion | 18097 | 105589 | 1807 | 0 | 39.78163624 | -86.13826325 | 2021-07-29 04:21:33 | Marion, Indiana, US | |
2371760 | 2371760 | 2021-07-20 | Russia | Stavropol Krai | 61292 | 1807 | 55492 | 3993 | 44.86325770000001 | 43.4406913 | 2021-07-21 04:21:40 | Stavropol Krai, Russia | ||
579129 | 579129 | 2021-07-13 | Spain | Extremadura | 80580 | 1807 | 2652 | 76121 | 39.4937 | -6.0679 | 2021-07-14 04:21:35 | Extremadura, Spain | ||
3741378 | 3741378 | 2021-07-12 | Spain | Extremadura | 80331 | 1807 | 2652 | 75872 | 39.4937 | -6.0679 | 2021-07-13 04:21:18 | Extremadura, Spain | ||
2693985 | 2693985 | 2021-07-06 | Spain | Extremadura | 78715 | 1807 | 2652 | 74256 | 39.4937 | -6.0679 | 2021-07-07 04:21:20 | Extremadura, Spain | ||
1932734 | 1932734 | 2021-07-05 | Spain | Extremadura | 78464 | 1807 | 2652 | 74005 | 39.4937 | -6.0679 | 2021-07-06 04:21:32 | Extremadura, Spain | ||
1165465 | 1165465 | 2021-07-04 | Spain | Extremadura | 77914 | 1807 | 2652 | 73455 | 39.4937 | -6.0679 | 2021-07-05 04:21:28 | Extremadura, Spain | ||
1495899 | 1495899 | 2021-07-03 | Spain | Extremadura | 77914 | 1807 | 2652 | 73455 | 39.4937 | -6.0679 | 2021-07-04 04:21:38 | Extremadura, Spain | ||
2072214 | 2072214 | 2021-07-02 | Spain | Extremadura | 77914 | 1807 | 2652 | 73455 | 39.4937 | -6.0679 | 2021-07-03 04:21:37 | Extremadura, Spain | ||
2765230 | 2765230 | 2021-07-01 | Spain | Extremadura | 77696 | 1807 | 2652 | 73237 | 39.4937 | -6.0679 | 2021-07-02 04:21:47 | Extremadura, Spain | ||
1893438 | 1893438 | 2021-06-30 | Spain | Extremadura | 77526 | 1807 | 2652 | 73067 | 39.4937 | -6.0679 | 2021-07-01 04:21:19 | Extremadura, Spain | ||
403911 | 403911 | 2021-06-29 | United Arab Emirates | 631160 | 1807 | 609711 | 19642 | 23.424076 | 53.847818 | 2021-06-30 04:21:41 | United Arab Emirates | |||
400561 | 400561 | 2021-06-29 | Spain | Extremadura | 77397 | 1807 | 2652 | 72938 | 39.4937 | -6.0679 | 2021-06-30 04:21:41 | Extremadura, Spain | ||
3125804 | 3125804 | 2021-06-28 | Spain | Extremadura | 77280 | 1807 | 2652 | 72821 | 39.4937 | -6.0679 | 2021-06-29 04:21:28 | Extremadura, Spain | ||
2590299 | 2590299 | 2021-06-27 | Spain | Extremadura | 77087 | 1807 | 2652 | 72628 | 39.4937 | -6.0679 | 2021-06-28 04:21:29 | Extremadura, Spain | ||
3958803 | 3958803 | 2021-06-26 | Spain | Extremadura | 77087 | 1807 | 2652 | 72628 | 39.4937 | -6.0679 | 2021-06-27 04:21:39 | Extremadura, Spain | ||
1712622 | 1712622 | 2021-06-25 | Spain | Extremadura | 77087 | 1807 | 2652 | 72628 | 39.4937 | -6.0679 | 2021-06-26 04:21:43 | Extremadura, Spain | ||
2295747 | 2295747 | 2021-06-24 | Spain | Extremadura | 77018 | 1807 | 2652 | 72559 | 39.4937 | -6.0679 | 2021-06-25 04:21:33 | Extremadura, Spain | ||
2423187 | 2423187 | 2021-06-23 | Spain | Extremadura | 76966 | 1807 | 2652 | 72507 | 39.4937 | -6.0679 | 2021-06-24 04:21:55 | Extremadura, Spain | ||
563264 | 563264 | 2021-06-22 | Spain | Extremadura | 76916 | 1807 | 2652 | 72457 | 39.4937 | -6.0679 | 2021-06-23 04:21:46 | Extremadura, Spain | ||
562697 | 562697 | 2021-06-22 | Brazil | Amapa | 115976 | 1807 | 92769 | 21400 | 0.902 | -52.003 | 2021-06-23 04:21:46 | Amapa, Brazil | ||
3358966 | 3358966 | 2021-06-21 | Spain | Extremadura | 76861 | 1807 | 2652 | 72402 | 39.4937 | -6.0679 | 2021-06-22 04:21:34 | Extremadura, Spain | ||
2341623 | 2341623 | 2021-06-15 | US | New York | Erie | 36029 | 89579 | 1807 | 0 | 42.76249024 | -78.73063652 | 2021-06-16 04:22:32 | Erie, New York, US | |
2318936 | 2318936 | 2021-06-04 | Ukraine | Poltava Oblast | 77157 | 1807 | 73972 | 1378 | 49.5883 | 34.5514 | 2021-06-05 04:23:03 | Poltava Oblast, Ukraine | ||
958506 | 958506 | 2021-04-25 | Ukraine | Zaporizhia Oblast | 93688 | 1807 | 74423 | 17458 | 47.8388 | 35.1396 | 2021-04-26 04:21:04 | Zaporizhia Oblast, Ukraine | ||
3927653 | 3927653 | 2021-04-24 | Ukraine | Zaporizhia Oblast | 93436 | 1807 | 74170 | 17459 | 47.8388 | 35.1396 | 2021-04-25 04:20:32 | Zaporizhia Oblast, Ukraine | ||
1842084 | 1842084 | 2021-04-14 | Oman | 175633 | 1807 | 155645 | 18181 | 21.512583 | 55.92325500000001 | 2021-04-15 04:20:54 | Oman | |||
3646189 | 3646189 | 2021-03-30 | US | Pennsylvania | Allegheny | 42003 | 85589 | 1807 | 0 | 40.46809875 | -79.98167747 | 2021-03-31 04:26:25 | Allegheny, Pennsylvania, US | |
352581 | 352581 | 2021-03-11 | Spain | Asturias | 44862 | 1807 | 1063 | 41992 | 43.3614 | -5.8593 | 2021-03-12 05:26:50 | Asturias, Spain | ||
2367619 | 2367619 | 2021-02-28 | Netherlands | Gelderland | 122120 | 1807 | 0 | 120138 | 52.061738 | 5.939114 | 2021-03-01 05:23:01 | Gelderland, Netherlands | ||
3066121 | 3066121 | 2021-02-27 | Netherlands | Gelderland | 121725 | 1807 | 0 | 119747 | 52.061738 | 5.939114 | 2021-02-28 05:22:20 | Gelderland, Netherlands | ||
2183742 | 2183742 | 2021-02-26 | Peru | Huanuco | 25131 | 1807 | 0 | 23324 | -9.421676 | -76.040642 | 2021-02-27 05:22:28 | Huanuco, Peru | ||
2183705 | 2183705 | 2021-02-26 | Netherlands | Gelderland | 121223 | 1807 | 0 | 119243 | 52.061738 | 5.939114 | 2021-02-27 05:22:28 | Gelderland, Netherlands | ||
530590 | 530590 | 2021-02-22 | El Salvador | 59235 | 1807 | 54324 | 3104 | 13.7942 | -88.8965 | 2021-02-23 05:23:41 | El Salvador | |||
742528 | 742528 | 2021-02-20 | Russia | Krasnodar Krai | 37176 | 1807 | 30908 | 4461 | 45.7684014 | 39.0261044 | 2021-02-21 05:24:33 | Krasnodar Krai, Russia | ||
1153172 | 1153172 | 2021-02-18 | Kenya | 103615 | 1807 | 85457 | 16351 | -0.0236 | 37.9062 | 2021-02-19 05:24:16 | Kenya | |||
1460063 | 1460063 | 2021-01-31 | Sudan | 29380 | 1807 | 21410 | 6163 | 12.8628 | 30.2176 | 2021-02-01 05:22:53 | Sudan | |||
1096249 | 1096249 | 2021-01-20 | US | New Jersey | Hudson | 34017 | 56839 | 1807 | 0 | 55032 | 40.73766234 | -74.07515667 | 2021-01-21 05:22:01 | Hudson, New Jersey, US |
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]);