johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
108 rows where deaths = 1706 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3714453 | 3714453 | 2022-12-06 | Singapore | 2174989 | 1706 | 0 | 1.2833 | 103.8333 | 2022-12-07 04:20:58 | Singapore | ||||
2415158 | 2415158 | 2022-12-05 | Singapore | 2173172 | 1706 | 0 | 1.2833 | 103.8333 | 2022-12-06 04:21:03 | Singapore | ||||
3461816 | 3461816 | 2022-11-21 | US | Michigan | Kent | 26081 | 194704 | 1706 | 0 | 43.03197711 | -85.54934642 | 2022-11-22 04:20:47 | Kent, Michigan, US | |
1642001 | 1642001 | 2022-11-20 | US | Michigan | Kent | 26081 | 194704 | 1706 | 0 | 43.03197711 | -85.54934642 | 2022-11-21 04:21:05 | Kent, Michigan, US | |
2065558 | 2065558 | 2022-11-19 | US | Michigan | Kent | 26081 | 194704 | 1706 | 0 | 43.03197711 | -85.54934642 | 2022-11-20 04:21:08 | Kent, Michigan, US | |
1756952 | 1756952 | 2022-11-18 | US | Michigan | Kent | 26081 | 194704 | 1706 | 0 | 43.03197711 | -85.54934642 | 2022-11-19 04:21:14 | Kent, Michigan, US | |
3027945 | 3027945 | 2022-11-17 | US | Michigan | Kent | 26081 | 194704 | 1706 | 0 | 43.03197711 | -85.54934642 | 2022-11-18 04:21:15 | Kent, Michigan, US | |
2487656 | 2487656 | 2022-11-16 | US | Michigan | Kent | 26081 | 194704 | 1706 | 0 | 43.03197711 | -85.54934642 | 2022-11-17 04:21:11 | Kent, Michigan, US | |
293667 | 293667 | 2022-11-15 | US | Michigan | Kent | 26081 | 194704 | 1706 | 0 | 43.03197711 | -85.54934642 | 2022-11-16 04:21:09 | Kent, Michigan, US | |
2375849 | 2375849 | 2022-09-29 | Spain | Navarra | 255444 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-30 04:23:09 | Navarra, Spain | |||
1560400 | 1560400 | 2022-09-28 | Spain | Navarra | 255444 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-29 04:22:34 | Navarra, Spain | |||
3994943 | 3994943 | 2022-09-27 | Spain | Navarra | 255444 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-28 04:23:01 | Navarra, Spain | |||
2771215 | 2771215 | 2022-09-26 | US | New York | Monroe | 36055 | 178544 | 1706 | 0 | 43.14638895 | -77.69322942 | 2022-09-27 04:23:01 | Monroe, New York, US | |
2769271 | 2769271 | 2022-09-26 | Spain | Navarra | 255364 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-27 04:23:01 | Navarra, Spain | |||
1978868 | 1978868 | 2022-09-25 | US | New York | Monroe | 36055 | 178544 | 1706 | 0 | 43.14638895 | -77.69322942 | 2022-09-26 04:20:52 | Monroe, New York, US | |
1976924 | 1976924 | 2022-09-25 | Spain | Navarra | 255364 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-26 04:20:52 | Navarra, Spain | |||
2652035 | 2652035 | 2022-09-24 | US | New York | Monroe | 36055 | 178421 | 1706 | 0 | 43.14638895 | -77.69322942 | 2022-09-25 04:23:31 | Monroe, New York, US | |
2650091 | 2650091 | 2022-09-24 | Spain | Navarra | 255364 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-25 04:23:31 | Navarra, Spain | |||
386475 | 386475 | 2022-09-23 | US | New York | Monroe | 36055 | 178302 | 1706 | 0 | 43.14638895 | -77.69322942 | 2022-09-24 04:21:40 | Monroe, New York, US | |
384531 | 384531 | 2022-09-23 | Spain | Navarra | 255364 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-24 04:21:40 | Navarra, Spain | |||
1626541 | 1626541 | 2022-09-22 | US | New York | Monroe | 36055 | 178157 | 1706 | 0 | 43.14638895 | -77.69322942 | 2022-09-23 04:23:13 | Monroe, New York, US | |
3776251 | 3776251 | 2022-08-30 | US | North Carolina | Mecklenburg | 37119 | 330715 | 1706 | 0 | 35.24469268 | -80.8317671 | 2022-08-31 04:20:57 | Mecklenburg, North Carolina, US | |
1682847 | 1682847 | 2022-08-29 | US | North Carolina | Mecklenburg | 37119 | 330715 | 1706 | 0 | 35.24469268 | -80.8317671 | 2022-08-30 04:21:03 | Mecklenburg, North Carolina, US | |
1879331 | 1879331 | 2022-08-28 | US | North Carolina | Mecklenburg | 37119 | 330715 | 1706 | 0 | 35.24469268 | -80.8317671 | 2022-08-29 04:21:06 | Mecklenburg, North Carolina, US | |
2098458 | 2098458 | 2022-08-27 | US | North Carolina | Mecklenburg | 37119 | 330715 | 1706 | 0 | 35.24469268 | -80.8317671 | 2022-08-28 04:21:02 | Mecklenburg, North Carolina, US | |
1534273 | 1534273 | 2022-08-26 | US | North Carolina | Mecklenburg | 37119 | 330715 | 1706 | 0 | 35.24469268 | -80.8317671 | 2022-08-27 04:20:57 | Mecklenburg, North Carolina, US | |
2831160 | 2831160 | 2022-08-25 | US | North Carolina | Mecklenburg | 37119 | 330715 | 1706 | 0 | 35.24469268 | -80.8317671 | 2022-08-26 04:21:02 | Mecklenburg, North Carolina, US | |
2325693 | 2325693 | 2022-08-24 | US | North Carolina | Mecklenburg | 37119 | 330715 | 1706 | 0 | 35.24469268 | -80.8317671 | 2022-08-25 04:21:13 | Mecklenburg, North Carolina, US | |
3580233 | 3580233 | 2022-06-02 | US | Massachusetts | Plymouth | 25023 | 123511 | 1706 | 0 | 41.94070556 | -70.80802823 | 2022-06-03 04:20:58 | Plymouth, Massachusetts, US | |
3437019 | 3437019 | 2022-04-22 | Russia | Arkhangelsk Oblast | 227749 | 1706 | 0 | 63.5589686 | 43.1221646 | 2022-04-23 04:20:50 | Arkhangelsk Oblast, Russia | |||
2893397 | 2893397 | 2022-04-21 | US | Illinois | DuPage | 17043 | 213700 | 1706 | 0 | 41.85116968 | -88.08642662 | 2022-04-22 04:20:45 | DuPage, Illinois, US | |
2308269 | 2308269 | 2022-04-20 | US | Illinois | DuPage | 17043 | 213313 | 1706 | 0 | 41.85116968 | -88.08642662 | 2022-04-21 04:20:46 | DuPage, Illinois, US | |
2445273 | 2445273 | 2022-04-13 | US | Ohio | Summit | 39153 | 112216 | 1706 | 0 | 41.12464734 | -81.53123079 | 2022-04-13 23:21:06 | Summit, Ohio, US | |
2443546 | 2443546 | 2022-04-13 | US | Georgia | DeKalb | 13089 | 149282 | 1706 | 0 | 33.76944049 | -84.22396017 | 2022-04-13 23:21:06 | DeKalb, Georgia, US | |
1951030 | 1951030 | 2022-04-12 | US | Ohio | Summit | 39153 | 112216 | 1706 | 0 | 41.12464734 | -81.53123079 | 2022-04-13 04:21:03 | Summit, Ohio, US | |
3208783 | 3208783 | 2022-04-11 | US | Ohio | Summit | 39153 | 112216 | 1706 | 0 | 41.12464734 | -81.53123079 | 2022-04-12 04:20:49 | Summit, Ohio, US | |
1578669 | 1578669 | 2022-04-10 | US | Ohio | Summit | 39153 | 112216 | 1706 | 0 | 41.12464734 | -81.53123079 | 2022-04-11 04:21:02 | Summit, Ohio, US | |
1654911 | 1654911 | 2022-04-09 | US | Ohio | Summit | 39153 | 112216 | 1706 | 0 | 41.12464734 | -81.53123079 | 2022-04-10 04:20:52 | Summit, Ohio, US | |
920795 | 920795 | 2022-03-08 | US | Indiana | Lake | 18089 | 105597 | 1706 | 0 | 41.41874274 | -87.38277575 | 2022-03-09 04:20:59 | Lake, Indiana, US | |
920464 | 920464 | 2022-03-08 | US | Georgia | Cobb | 13067 | 169642 | 1706 | 0 | 33.94243204 | -84.5761255 | 2022-03-09 04:20:59 | Cobb, Georgia, US | |
1511662 | 1511662 | 2022-02-24 | Russia | Tatarstan Republic | 106067 | 1706 | 0 | 55.7648572 | 52.43104273 | 2022-02-25 04:21:11 | Tatarstan Republic, Russia | |||
1058388 | 1058388 | 2022-02-23 | US | California | Alameda | 6001 | 261046 | 1706 | 0 | 37.64629437 | -121.8929271 | 2022-02-24 04:21:14 | Alameda, California, US | |
3875422 | 3875422 | 2022-02-19 | Colombia | Sucre | 65497 | 1706 | 0 | 8.814 | -74.7233 | 2022-02-20 04:21:00 | Sucre, Colombia | |||
1298033 | 1298033 | 2022-02-17 | Italy | Umbria | 175977 | 1706 | 0 | 43.10675841 | 12.38824698 | 2022-02-18 04:21:04 | Umbria, Italy | |||
3824075 | 3824075 | 2022-02-16 | Ukraine | Kirovohrad Oblast | 41823 | 1706 | 0 | 48.5079 | 32.2623 | 2022-02-17 04:20:56 | Kirovohrad Oblast, Ukraine | |||
1670055 | 1670055 | 2021-12-29 | US | Massachusetts | Bristol | 25005 | 103247 | 1706 | 0 | 41.79228404 | -71.10872211 | 2021-12-30 04:21:25 | Bristol, Massachusetts, US | |
3818892 | 3818892 | 2021-12-23 | US | Ohio | Hamilton | 39061 | 123377 | 1706 | 0 | 39.19673558 | -84.54502924 | 2021-12-24 04:21:34 | Hamilton, Ohio, US | |
1030621 | 1030621 | 2021-12-06 | Russia | Sakha (Yakutiya) Republic | 71986 | 1706 | 0 | 66.941626 | 129.642371 | 2021-12-07 04:22:34 | Sakha (Yakutiya) Republic, Russia | |||
87677 | 87677 | 2021-11-09 | US | California | Kern | 6029 | 152732 | 1706 | 0 | 35.34329425 | -118.72777959999999 | 2021-11-10 04:21:38 | Kern, California, US | |
3640105 | 3640105 | 2021-11-08 | US | California | Kern | 6029 | 152418 | 1706 | 0 | 35.34329425 | -118.72777959999999 | 2021-11-09 04:21:36 | Kern, California, US | |
2001213 | 2001213 | 2021-11-07 | US | California | Kern | 6029 | 151432 | 1706 | 0 | 35.34329425 | -118.72777959999999 | 2021-11-08 04:21:43 | Kern, California, US | |
496204 | 496204 | 2021-11-06 | US | California | Kern | 6029 | 151432 | 1706 | 0 | 35.34329425 | -118.72777959999999 | 2021-11-07 04:21:53 | Kern, California, US | |
3122059 | 3122059 | 2021-11-05 | US | California | Kern | 6029 | 151432 | 1706 | 0 | 35.34329425 | -118.72777959999999 | 2021-11-06 04:21:51 | Kern, California, US | |
3795479 | 3795479 | 2021-10-25 | US | Maryland | Montgomery | 24031 | 82037 | 1706 | 0 | 39.13676329 | -77.20358245 | 2021-10-26 04:22:09 | Montgomery, Maryland, US | |
773996 | 773996 | 2021-10-23 | Ukraine | Zakarpattia Oblast | 67183 | 1706 | 0 | 48.6208 | 22.2879 | 2021-10-24 04:21:22 | Zakarpattia Oblast, Ukraine | |||
423477 | 423477 | 2021-10-10 | Netherlands | Limburg | 134336 | 1706 | 0 | 51.209227 | 5.93387 | 2021-10-11 04:21:31 | Limburg, Netherlands | |||
2876334 | 2876334 | 2021-10-09 | Netherlands | Limburg | 134118 | 1706 | 0 | 51.209227 | 5.93387 | 2021-10-10 04:21:38 | Limburg, Netherlands | |||
2959500 | 2959500 | 2021-10-08 | Netherlands | Limburg | 133954 | 1706 | 0 | 51.209227 | 5.93387 | 2021-10-09 04:21:34 | Limburg, Netherlands | |||
467538 | 467538 | 2021-10-07 | Netherlands | Limburg | 133714 | 1706 | 0 | 51.209227 | 5.93387 | 2021-10-08 04:21:25 | Limburg, Netherlands | |||
2461255 | 2461255 | 2021-10-06 | US | Ohio | Franklin | 39049 | 158547 | 1706 | 0 | 39.96995815 | -83.01115755 | 2021-10-07 04:21:36 | Franklin, Ohio, US | |
3930216 | 3930216 | 2021-10-02 | US | New Jersey | Monmouth | 34025 | 89153 | 1706 | 0 | 40.26549699 | -74.22240686 | 2021-10-03 04:21:24 | Monmouth, New Jersey, US | |
1337316 | 1337316 | 2021-09-28 | US | Texas | Cameron | 48061 | 67361 | 1706 | 0 | 26.14524221 | -97.48140372 | 2021-09-29 04:21:45 | Cameron, Texas, US | |
1385887 | 1385887 | 2021-09-13 | Russia | Tyumen Oblast | 57918 | 1706 | 0 | 58.8206488 | 70.36588370000001 | 2021-09-14 04:21:41 | Tyumen Oblast, Russia | |||
3449101 | 3449101 | 2021-09-10 | Russia | Udmurt Republic | 48612 | 1706 | 0 | 57.1961165 | 52.69598320000001 | 2021-09-11 04:21:30 | Udmurt Republic, Russia | |||
177882 | 177882 | 2021-09-02 | Colombia | Quindio | 55699 | 1706 | 0 | 4.461 | -75.6674 | 2021-09-03 04:21:20 | Quindio, Colombia | |||
66917 | 66917 | 2021-09-01 | Colombia | Quindio | 55683 | 1706 | 0 | 4.461 | -75.6674 | 2021-09-02 04:21:15 | Quindio, Colombia | |||
2067759 | 2067759 | 2021-08-31 | Colombia | Quindio | 55662 | 1706 | 0 | 4.461 | -75.6674 | 2021-09-01 04:21:38 | Quindio, Colombia | |||
1775213 | 1775213 | 2021-08-30 | Colombia | Quindio | 55662 | 1706 | 0 | 4.461 | -75.6674 | 2021-08-31 04:21:46 | Quindio, Colombia | |||
3891787 | 3891787 | 2021-08-29 | Colombia | Quindio | 55628 | 1706 | 0 | 4.461 | -75.6674 | 2021-08-30 04:21:23 | Quindio, Colombia | |||
32691 | 32691 | 2021-08-25 | Senegal | 72215 | 1706 | 0 | 14.4974 | -14.4524 | 2021-08-26 04:21:28 | Senegal | ||||
2207282 | 2207282 | 2021-08-07 | Ukraine | Vinnytsia Oblast | 71720 | 1706 | 0 | 49.2331 | 28.4682 | 2021-08-08 04:21:33 | Vinnytsia Oblast, Ukraine | |||
3221921 | 3221921 | 2021-07-26 | Ukraine | Crimea Republic* | 57930 | 1706 | 48999 | 7225 | 45.2835 | 34.2008 | 2021-07-27 04:21:18 | Crimea Republic*, Ukraine | ||
2947435 | 2947435 | 2021-07-16 | Mexico | Chiapas | 12965 | 1706 | 0 | 11259 | 16.7569 | -93.1292 | 2021-07-17 04:22:22 | Chiapas, Mexico | ||
3958727 | 3958727 | 2021-06-26 | Russia | Leningrad Oblast | 48079 | 1706 | 44552 | 1821 | 60.1853296 | 32.3925325 | 2021-06-27 04:21:39 | Leningrad Oblast, Russia | ||
2104670 | 2104670 | 2021-06-01 | US | California | Fresno | 6019 | 111155 | 1706 | 0 | 36.75733899 | -119.6466953 | 2021-06-02 04:24:34 | Fresno, California, US | |
1189286 | 1189286 | 2021-05-31 | US | California | Fresno | 6019 | 111128 | 1706 | 0 | 36.75733899 | -119.6466953 | 2021-06-01 04:23:09 | Fresno, California, US | |
3089963 | 3089963 | 2021-05-30 | US | California | Fresno | 6019 | 111116 | 1706 | 0 | 36.75733899 | -119.6466953 | 2021-05-31 03:08:59 | Fresno, California, US | |
51332 | 51332 | 2021-05-29 | US | California | Fresno | 6019 | 111084 | 1706 | 0 | 36.75733899 | -119.6466953 | 2021-05-30 04:20:55 | Fresno, California, US | |
1956155 | 1956155 | 2021-05-21 | Ukraine | Zhytomyr Oblast | 86935 | 1706 | 80842 | 4387 | 50.2547 | 28.6587 | 2021-05-22 04:20:45 | Zhytomyr Oblast, Ukraine | ||
1915894 | 1915894 | 2021-05-20 | US | Pennsylvania | Montgomery | 42091 | 69745 | 1706 | 0 | 40.21053671 | -75.36652296 | 2021-05-21 04:20:43 | Montgomery, Pennsylvania, US | |
3057809 | 3057809 | 2021-05-13 | Ukraine | Chernivtsi Oblast | 78116 | 1706 | 68321 | 8089 | 48.2917 | 25.9352 | 2021-05-14 04:20:41 | Chernivtsi Oblast, Ukraine | ||
3131747 | 3131747 | 2021-04-18 | US | New York | Erie | 36029 | 82588 | 1706 | 0 | 42.76249024 | -78.73063652 | 2021-04-19 04:20:57 | Erie, New York, US | |
37535 | 37535 | 2021-04-12 | US | Indiana | Marion | 18097 | 95509 | 1706 | 0 | 39.78163624 | -86.13826325 | 2021-04-13 04:20:37 | Marion, Indiana, US | |
3884694 | 3884694 | 2021-04-11 | US | Indiana | Marion | 18097 | 95309 | 1706 | 0 | 39.78163624 | -86.13826325 | 2021-04-12 04:21:00 | Marion, Indiana, US | |
2984362 | 2984362 | 2021-04-10 | US | Indiana | Marion | 18097 | 95132 | 1706 | 0 | 39.78163624 | -86.13826325 | 2021-04-11 04:20:56 | Marion, Indiana, US | |
3004905 | 3004905 | 2021-04-06 | US | Massachusetts | Worcester | 25027 | 71462 | 1706 | 0 | 42.35026951 | -71.90493363 | 2021-04-07 04:20:53 | Worcester, Massachusetts, US | |
390478 | 390478 | 2021-04-04 | US | New York | Richmond | 36085 | 67083 | 1706 | 0 | 40.58582155 | -74.14808598 | 2021-04-05 04:20:35 | Richmond, New York, US | |
1302019 | 1302019 | 2021-04-01 | India | Telangana | 309741 | 1706 | 301876 | 6159 | 18.1124 | 79.0193 | 2021-04-02 04:20:36 | Telangana, India | ||
2780965 | 2780965 | 2021-03-24 | India | Uttarakhand | 98880 | 1706 | 96062 | 1112 | 30.156447 | 79.197608 | 2021-03-25 05:27:00 | Uttarakhand, India | ||
1798610 | 1798610 | 2021-03-23 | India | Uttarakhand | 98646 | 1706 | 96010 | 930 | 30.156447 | 79.197608 | 2021-03-24 05:25:40 | Uttarakhand, India | ||
3254718 | 3254718 | 2021-03-02 | US | California | Santa Clara | 6085 | 111411 | 1706 | 0 | 109736 | 37.23104908 | -121.6970462 | 2021-03-03 05:23:28 | Santa Clara, California, US |
2367791 | 2367791 | 2021-02-28 | Spain | Extremadura | 68952 | 1706 | 2652 | 64594 | 39.4937 | -6.0679 | 2021-03-01 05:23:01 | Extremadura, Spain | ||
3066293 | 3066293 | 2021-02-27 | Spain | Extremadura | 68952 | 1706 | 2652 | 64594 | 39.4937 | -6.0679 | 2021-02-28 05:22:20 | Extremadura, Spain | ||
2183877 | 2183877 | 2021-02-26 | Spain | Extremadura | 68952 | 1706 | 2652 | 64594 | 39.4937 | -6.0679 | 2021-02-27 05:22:28 | Extremadura, Spain | ||
530555 | 530555 | 2021-02-22 | Colombia | Huila | 49290 | 1706 | 47203 | 381 | 2.5359 | -75.5277 | 2021-02-23 05:23:41 | Huila, Colombia | ||
1153318 | 1153318 | 2021-02-18 | Russia | Irkutsk Oblast | 53267 | 1706 | 49394 | 2167 | 56.6370122 | 104.719221 | 2021-02-19 05:24:16 | Irkutsk Oblast, Russia | ||
1588350 | 1588350 | 2021-02-05 | Peru | Ucayali | 21646 | 1706 | 0 | 19940 | -9.621718 | -73.444929 | 2021-02-06 05:23:55 | Ucayali, Peru | ||
2482417 | 2482417 | 2021-01-28 | US | Arizona | Pima | 4019 | 99441 | 1706 | 0 | 97735 | 32.0971334 | -111.7890033 | 2021-01-29 05:22:23 | Pima, Arizona, US |
1759141 | 1759141 | 2021-01-24 | Colombia | Cordoba | 31633 | 1706 | 29175 | 752 | 8.0493 | -75.574 | 2021-01-25 05:22:16 | Cordoba, Colombia | ||
908835 | 908835 | 2021-01-19 | US | Connecticut | New Haven | 9009 | 58627 | 1706 | 0 | 56921 | 41.4080325 | -72.93620426 | 2021-01-20 05:21:54 | New Haven, Connecticut, 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]);