johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
93 rows where deaths = 1719 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1813027 | 1813027 | 2022-10-05 | US | New York | Monroe | 36055 | 179664 | 1719 | 0 | 43.14638895 | -77.69322942 | 2022-10-06 04:21:22 | Monroe, New York, US | |
3773897 | 3773897 | 2022-08-30 | Japan | Fukuoka | 977370 | 1719 | 0 | 33.526032 | 130.666949 | 2022-08-31 04:20:57 | Fukuoka, Japan | |||
2853451 | 2853451 | 2022-08-22 | US | California | Stanislaus | 6099 | 154601 | 1719 | 0 | 37.55862499 | -120.9970722 | 2022-08-23 04:20:56 | Stanislaus, California, US | |
2403423 | 2403423 | 2022-08-21 | US | California | Stanislaus | 6099 | 154601 | 1719 | 0 | 37.55862499 | -120.9970722 | 2022-08-22 04:20:38 | Stanislaus, California, US | |
3798501 | 3798501 | 2022-08-20 | US | California | Stanislaus | 6099 | 154601 | 1719 | 0 | 37.55862499 | -120.9970722 | 2022-08-21 04:20:44 | Stanislaus, California, US | |
2364087 | 2364087 | 2022-08-19 | US | California | Stanislaus | 6099 | 154601 | 1719 | 0 | 37.55862499 | -120.9970722 | 2022-08-20 04:21:01 | Stanislaus, California, US | |
632842 | 632842 | 2022-07-12 | US | Tennessee | Davidson | 47037 | 208937 | 1719 | 0 | 36.17007426 | -86.78646056 | 2022-07-13 04:20:58 | Davidson, Tennessee, US | |
1416859 | 1416859 | 2022-07-08 | Chile | Coquimbo | 152933 | 1719 | 0 | -29.959 | -71.3389 | 2022-07-09 04:20:59 | Coquimbo, Chile | |||
3939962 | 3939962 | 2022-06-30 | Germany | Saarland | 340396 | 1719 | 0 | 49.3964 | 7.023 | 2022-07-01 04:21:10 | Saarland, Germany | |||
2489920 | 2489920 | 2022-06-29 | Germany | Saarland | 338543 | 1719 | 0 | 49.3964 | 7.023 | 2022-06-30 04:21:01 | Saarland, Germany | |||
1764934 | 1764934 | 2022-06-20 | US | Massachusetts | Plymouth | 25023 | 125054 | 1719 | 0 | 41.94070556 | -70.80802823 | 2022-06-21 04:20:56 | Plymouth, Massachusetts, US | |
3271120 | 3271120 | 2022-06-19 | US | Massachusetts | Plymouth | 25023 | 125054 | 1719 | 0 | 41.94070556 | -70.80802823 | 2022-06-20 04:21:01 | Plymouth, Massachusetts, US | |
3399032 | 3399032 | 2022-06-18 | US | Massachusetts | Plymouth | 25023 | 125054 | 1719 | 0 | 41.94070556 | -70.80802823 | 2022-06-19 04:20:51 | Plymouth, Massachusetts, US | |
2312909 | 2312909 | 2022-06-17 | US | Massachusetts | Plymouth | 25023 | 125054 | 1719 | 0 | 41.94070556 | -70.80802823 | 2022-06-18 04:21:10 | Plymouth, Massachusetts, US | |
1169818 | 1169818 | 2022-05-20 | US | Colorado | El Paso | 8041 | 197372 | 1719 | 0 | 38.83240149 | -104.5251411 | 2022-05-21 04:20:58 | El Paso, Colorado, US | |
3896581 | 3896581 | 2022-05-19 | US | Colorado | El Paso | 8041 | 197180 | 1719 | 0 | 38.83240149 | -104.5251411 | 2022-05-20 04:20:57 | El Paso, Colorado, US | |
3536443 | 3536443 | 2022-05-10 | US | Illinois | DuPage | 17043 | 222726 | 1719 | 0 | 41.85116968 | -88.08642662 | 2022-05-11 04:20:48 | DuPage, Illinois, US | |
748860 | 748860 | 2022-04-23 | US | Ohio | Stark | 39151 | 79949 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-24 04:20:56 | Stark, Ohio, US | |
3439345 | 3439345 | 2022-04-22 | US | Ohio | Stark | 39151 | 79949 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-23 04:20:50 | Stark, Ohio, US | |
2894930 | 2894930 | 2022-04-21 | US | Ohio | Stark | 39151 | 79949 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-22 04:20:45 | Stark, Ohio, US | |
2309802 | 2309802 | 2022-04-20 | US | Ohio | Stark | 39151 | 79833 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-21 04:20:46 | Stark, Ohio, US | |
2253941 | 2253941 | 2022-04-19 | US | Ohio | Stark | 39151 | 79833 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-20 04:20:45 | Stark, Ohio, US | |
1848491 | 1848491 | 2022-04-18 | US | Ohio | Stark | 39151 | 79833 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-19 04:21:00 | Stark, Ohio, US | |
3419435 | 3419435 | 2022-04-17 | US | Ohio | Stark | 39151 | 79833 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-18 04:21:12 | Stark, Ohio, US | |
306384 | 306384 | 2022-04-16 | US | Ohio | Stark | 39151 | 79833 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-17 04:20:59 | Stark, Ohio, US | |
2672329 | 2672329 | 2022-04-15 | US | Ohio | Stark | 39151 | 79833 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-16 04:20:48 | Stark, Ohio, US | |
1226114 | 1226114 | 2022-04-14 | US | Ohio | Stark | 39151 | 79833 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-15 04:20:57 | Stark, Ohio, US | |
2445272 | 2445272 | 2022-04-13 | US | Ohio | Stark | 39151 | 79756 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-13 23:21:06 | Stark, Ohio, US | |
1951029 | 1951029 | 2022-04-12 | US | Ohio | Stark | 39151 | 79756 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-13 04:21:03 | Stark, Ohio, US | |
3208782 | 3208782 | 2022-04-11 | US | Ohio | Stark | 39151 | 79756 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-12 04:20:49 | Stark, Ohio, US | |
1578668 | 1578668 | 2022-04-10 | US | Ohio | Stark | 39151 | 79756 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-11 04:21:02 | Stark, Ohio, US | |
1654910 | 1654910 | 2022-04-09 | US | Ohio | Stark | 39151 | 79756 | 1719 | 0 | 40.81482476 | -81.36437305 | 2022-04-10 04:20:52 | Stark, Ohio, US | |
26587 | 26587 | 2022-03-20 | US | New Mexico | Bernalillo | 35001 | 146040 | 1719 | 0 | 35.05163625 | -106.6703554 | 2022-03-21 04:20:50 | Bernalillo, New Mexico, US | |
1658597 | 1658597 | 2022-03-19 | US | New Mexico | Bernalillo | 35001 | 146040 | 1719 | 0 | 35.05163625 | -106.6703554 | 2022-03-20 04:20:45 | Bernalillo, New Mexico, US | |
3629068 | 3629068 | 2022-03-13 | US | Indiana | Lake | 18089 | 105659 | 1719 | 0 | 41.41874274 | -87.38277575 | 2022-03-14 04:20:46 | Lake, Indiana, US | |
951976 | 951976 | 2022-03-12 | US | Indiana | Lake | 18089 | 105659 | 1719 | 0 | 41.41874274 | -87.38277575 | 2022-03-13 04:20:49 | Lake, Indiana, US | |
357437 | 357437 | 2022-03-11 | US | Indiana | Lake | 18089 | 105659 | 1719 | 0 | 41.41874274 | -87.38277575 | 2022-03-12 04:20:50 | Lake, Indiana, US | |
1992662 | 1992662 | 2022-03-01 | Japan | Kanagawa | 457648 | 1719 | 0 | 35.415312 | 139.338983 | 2022-03-02 04:21:07 | Kanagawa, Japan | |||
730720 | 730720 | 2021-12-27 | Russia | Belgorod Oblast | 80779 | 1719 | 0 | 50.7080119 | 37.5837615 | 2021-12-28 04:21:47 | Belgorod Oblast, Russia | |||
3605049 | 3605049 | 2021-12-25 | Italy | Sardegna | 84354 | 1719 | 0 | 39.21531192 | 9.110616306 | 2021-12-26 04:21:50 | Sardegna, Italy | |||
2963367 | 2963367 | 2021-12-24 | Italy | Sardegna | 83886 | 1719 | 0 | 39.21531192 | 9.110616306 | 2021-12-25 04:21:37 | Sardegna, Italy | |||
141614 | 141614 | 2021-12-04 | Ukraine | Sevastopol* | 49567 | 1719 | 0 | 44.6054 | 33.522 | 2021-12-05 04:22:25 | Sevastopol*, Ukraine | |||
162249 | 162249 | 2021-11-19 | Russia | Kursk Oblast | 72866 | 1719 | 0 | 51.6568453 | 36.4852695 | 2021-11-20 04:22:17 | Kursk Oblast, Russia | |||
495327 | 495327 | 2021-11-06 | Angola | 64654 | 1719 | 0 | -11.2027 | 17.8739 | 2021-11-07 04:21:53 | Angola | ||||
3121182 | 3121182 | 2021-11-05 | Angola | 64612 | 1719 | 0 | -11.2027 | 17.8739 | 2021-11-06 04:21:51 | Angola | ||||
4251 | 4251 | 2021-10-28 | Germany | Schleswig-Holstein | 81007 | 1719 | 0 | 54.2194 | 9.6961 | 2021-10-29 04:22:03 | Schleswig-Holstein, Germany | |||
536321 | 536321 | 2021-10-27 | US | Maryland | Prince George's | 24033 | 99501 | 1719 | 0 | 38.83070039 | -76.8496441 | 2021-10-28 04:22:08 | Prince George's, Maryland, US | |
1815077 | 1815077 | 2021-09-19 | Spain | Murcia | 139703 | 1719 | 0 | 37.9922 | -1.1307 | 2021-09-20 04:21:22 | Murcia, Spain | |||
16657 | 16657 | 2021-09-18 | Spain | Murcia | 139703 | 1719 | 0 | 37.9922 | -1.1307 | 2021-09-19 04:21:34 | Murcia, Spain | |||
2618342 | 2618342 | 2021-09-17 | Spain | Murcia | 139703 | 1719 | 0 | 37.9922 | -1.1307 | 2021-09-18 04:21:24 | Murcia, Spain | |||
3974642 | 3974642 | 2021-09-03 | Mexico | Campeche | 20393 | 1719 | 0 | 19.8301 | -90.5349 | 2021-09-04 04:21:28 | Campeche, Mexico | |||
36058 | 36058 | 2021-08-25 | Ukraine | Vinnytsia Oblast | 72242 | 1719 | 0 | 49.2331 | 28.4682 | 2021-08-26 04:21:28 | Vinnytsia Oblast, Ukraine | |||
3108897 | 3108897 | 2021-08-24 | US | Washington | King | 53033 | 131281 | 1719 | 0 | 47.49137892 | -121.8346131 | 2021-08-25 04:21:41 | King, Washington, US | |
3476390 | 3476390 | 2021-07-22 | Mexico | Chiapas | 13352 | 1719 | 0 | 11633 | 16.7569 | -93.1292 | 2021-07-23 04:21:29 | Chiapas, Mexico | ||
1440832 | 1440832 | 2021-07-07 | Russia | Stavropol Krai | 58332 | 1719 | 54359 | 2254 | 44.86325770000001 | 43.4406913 | 2021-07-08 04:21:26 | Stavropol Krai, Russia | ||
1168852 | 1168852 | 2021-07-04 | Malaysia | Selangor | 259854 | 1719 | 230839 | 27296 | 3.0738 | 101.5183 | 2021-07-05 04:21:28 | Selangor, Malaysia | ||
3358507 | 3358507 | 2021-06-21 | Colombia | Caldas | 83827 | 1719 | 79028 | 3080 | 5.2983 | -75.2479 | 2021-06-22 04:21:34 | Caldas, Colombia | ||
1564633 | 1564633 | 2021-06-14 | US | California | Fresno | 6019 | 111464 | 1719 | 0 | 36.75733899 | -119.6466953 | 2021-06-15 04:22:22 | Fresno, California, US | |
1563820 | 1563820 | 2021-06-14 | Brazil | Acre | 84337 | 1719 | 78886 | 3732 | -9.0238 | -70.812 | 2021-06-15 04:22:22 | Acre, Brazil | ||
3381916 | 3381916 | 2021-06-13 | US | California | Fresno | 6019 | 111442 | 1719 | 0 | 36.75733899 | -119.6466953 | 2021-06-14 04:22:46 | Fresno, California, US | |
2716809 | 2716809 | 2021-06-10 | Colombia | Boyaca | 73800 | 1719 | 69012 | 3069 | 5.4545 | -73.362 | 2021-06-11 04:23:20 | Boyaca, Colombia | ||
825313 | 825313 | 2021-06-06 | Brazil | Amapa | 112999 | 1719 | 89266 | 22014 | 0.902 | -52.003 | 2021-06-07 04:22:51 | Amapa, Brazil | ||
1710994 | 1710994 | 2021-06-02 | US | Pennsylvania | Montgomery | 42091 | 70273 | 1719 | 0 | 40.21053671 | -75.36652296 | 2021-06-03 04:23:32 | Montgomery, Pennsylvania, US | |
1952567 | 1952567 | 2021-05-21 | Kuwait | 297206 | 1719 | 282913 | 12574 | 29.31166 | 47.481766 | 2021-05-22 04:20:45 | Kuwait | |||
2942944 | 2942944 | 2021-05-16 | Ukraine | Chernivtsi Oblast | 78373 | 1719 | 70270 | 6384 | 48.2917 | 25.9352 | 2021-05-17 04:20:34 | Chernivtsi Oblast, Ukraine | ||
3242557 | 3242557 | 2021-04-21 | Russia | Novosibirsk Oblast | 40416 | 1719 | 37460 | 1237 | 54.9720169 | 79.48139240000002 | 2021-04-22 04:20:53 | Novosibirsk Oblast, Russia | ||
3131121 | 3131121 | 2021-04-18 | US | Massachusetts | Worcester | 25027 | 73744 | 1719 | 0 | 42.35026951 | -71.90493363 | 2021-04-19 04:20:57 | Worcester, Massachusetts, US | |
983200 | 983200 | 2021-04-17 | Russia | Tula Oblast | 37704 | 1719 | 35340 | 645 | 53.9570701 | 37.3690909 | 2021-04-18 04:20:41 | Tula Oblast, Russia | ||
1841731 | 1841731 | 2021-04-14 | Chile | Biobio | 105700 | 1719 | 99602 | 4379 | -37.4464 | -72.1416 | 2021-04-15 04:20:54 | Biobio, Chile | ||
2571465 | 2571465 | 2021-04-13 | Chile | Biobio | 105184 | 1719 | 98931 | 4534 | -37.4464 | -72.1416 | 2021-04-14 04:20:41 | Biobio, Chile | ||
36216 | 36216 | 2021-04-12 | Chile | Biobio | 104655 | 1719 | 98154 | 4782 | -37.4464 | -72.1416 | 2021-04-13 04:20:37 | Biobio, Chile | ||
2648008 | 2648008 | 2021-04-08 | US | New York | Richmond | 36085 | 68283 | 1719 | 0 | 40.58582155 | -74.14808598 | 2021-04-09 04:21:13 | Richmond, New York, US | |
1302023 | 1302023 | 2021-04-01 | India | Uttarakhand | 100911 | 1719 | 96956 | 2236 | 30.156447 | 79.197608 | 2021-04-02 04:20:36 | Uttarakhand, India | ||
2677997 | 2677997 | 2021-02-13 | Peru | San Martin | 28526 | 1719 | 0 | 26807 | -7.039531 | -76.729127 | 2021-02-14 05:23:43 | San Martin, Peru | ||
2637982 | 2637982 | 2021-02-11 | Russia | Voronezh Oblast | 62272 | 1719 | 56028 | 4525 | 50.9800393 | 40.15065070000001 | 2021-02-12 05:23:29 | Voronezh Oblast, Russia | ||
2637606 | 2637606 | 2021-02-11 | El Salvador | 57229 | 1719 | 50999 | 4511 | 13.7942 | -88.8965 | 2021-02-12 05:23:29 | El Salvador | |||
615856 | 615856 | 2021-02-08 | US | New Jersey | Ocean | 34029 | 52781 | 1719 | 0 | 51062 | 39.8895449 | -74.28089251 | 2021-02-09 05:23:30 | Ocean, New Jersey, US |
2626913 | 2626913 | 2021-01-10 | US | Illinois | Unassigned | 90017 | 96 | 1719 | 0 | 0 | 42.36542373 | 0.0 | 2021-01-11 05:21:50 | Unassigned, Illinois, US |
3761690 | 3761690 | 2020-12-28 | Mexico | Zacatecas | 20707 | 1719 | 0 | 18988 | 22.7709 | -102.5832 | 2020-12-29 05:22:37 | Zacatecas, Mexico | ||
3860548 | 3860548 | 2020-12-04 | US | Florida | Palm Beach | 12099 | 67736 | 1719 | 0 | 66017 | 26.64676272 | -80.46536002 | 2020-12-05 05:27:36 | Palm Beach, Florida, US |
1974712 | 1974712 | 2020-11-25 | US | Nevada | Clark | 32003 | 109827 | 1719 | 0 | 108108 | 36.21458855 | -115.0130241 | 2020-11-26 05:27:44 | Clark, Nevada, US |
375899 | 375899 | 2020-11-06 | Austria | 135116 | 1719 | 83707 | 53932 | 47.5162 | 14.5501 | 2020-11-07 05:24:52 | Austria | |||
8616 | 8616 | 2020-10-25 | Spain | C. Valenciana | 53831 | 1719 | 9970 | 42142 | 39.484 | -0.7533 | 2020-10-26 04:25:02 | C. Valenciana, Spain | ||
3651853 | 3651853 | 2020-10-24 | Spain | C. Valenciana | 53831 | 1719 | 9970 | 42142 | 39.484 | -0.7533 | 2020-10-25 04:24:36 | C. Valenciana, Spain | ||
1054108 | 1054108 | 2020-10-23 | Spain | C. Valenciana | 53831 | 1719 | 9970 | 42142 | 39.484 | -0.7533 | 2020-10-24 04:24:46 | C. Valenciana, Spain | ||
3801992 | 3801992 | 2020-10-05 | Mexico | Quintana Roo | 12409 | 1719 | 10202 | 488 | 19.1817 | -88.4791 | 2020-10-06 04:23:33 | Quintana Roo, Mexico | ||
2514267 | 2514267 | 2020-10-03 | Mexico | San Luis Potosi | 23515 | 1719 | 20947 | 849 | 22.1565 | -100.9855 | 2020-10-04 04:23:44 | San Luis Potosi, Mexico | ||
1515097 | 1515097 | 2020-09-28 | Algeria | 51213 | 1719 | 35962 | 13532 | 28.0339 | 1.6596 | 2020-09-29 04:23:42 | Algeria | |||
1243842 | 1243842 | 2020-09-08 | Mexico | Hidalgo | 11042 | 1719 | 8688 | 635 | 20.0911 | -98.7624 | 2020-09-09 04:28:48 | Hidalgo, Mexico | ||
177625 | 177625 | 2020-07-27 | Portugal | 50299 | 1719 | 35375 | 13205 | 39.3999 | -8.2245 | 2020-07-28 04:58:43 | Portugal | |||
1005304 | 1005304 | 2020-07-09 | Colombia | Atlantico | 29572 | 1719 | 11080 | 16773 | 10.6966 | -74.8741 | 2020-07-10 04:34:24 | Atlantico, Colombia | ||
530160 | 530160 | 2020-07-04 | Mexico | Veracruz | 11477 | 1719 | 8530 | 1228 | 19.1738 | -96.1342 | 2020-07-05 04:33:46 | Veracruz, Mexico | ||
2111024 | 2111024 | 2020-05-06 | Switzerland | 30060 | 1719 | 25700 | 2641 | 46.8182 | 8.2275 | 2020-05-07 02:32:28 | Switzerland |
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]);