johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
78 rows where deaths = 1712 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1085758 | 1085758 | 2022-08-09 | Australia | Queensland | 1562443 | 1712 | 0 | -27.4698 | 153.0251 | 2022-08-10 04:20:57 | Queensland, Australia | |||
1767115 | 1767115 | 2022-07-03 | Chile | Coquimbo | 149615 | 1712 | 0 | -29.959 | -71.3389 | 2022-07-04 04:20:54 | Coquimbo, Chile | |||
3365101 | 3365101 | 2022-07-02 | Chile | Coquimbo | 148879 | 1712 | 0 | -29.959 | -71.3389 | 2022-07-03 04:20:59 | Coquimbo, Chile | |||
2187516 | 2187516 | 2022-06-22 | Germany | Saarland | 330412 | 1712 | 0 | 49.3964 | 7.023 | 2022-06-23 04:20:55 | Saarland, Germany | |||
3918552 | 3918552 | 2022-05-01 | US | Ohio | Summit | 39153 | 113311 | 1712 | 0 | 41.12464734 | -81.53123079 | 2022-05-02 04:21:10 | Summit, Ohio, US | |
2843356 | 2843356 | 2022-04-30 | US | Ohio | Summit | 39153 | 113311 | 1712 | 0 | 41.12464734 | -81.53123079 | 2022-05-01 04:20:57 | Summit, Ohio, US | |
1159669 | 1159669 | 2022-04-29 | US | Ohio | Summit | 39153 | 113311 | 1712 | 0 | 41.12464734 | -81.53123079 | 2022-04-30 04:21:05 | Summit, Ohio, US | |
1698851 | 1698851 | 2022-04-28 | US | Ohio | Summit | 39153 | 113311 | 1712 | 0 | 41.12464734 | -81.53123079 | 2022-04-29 04:20:59 | Summit, Ohio, US | |
1907712 | 1907712 | 2022-03-22 | US | Ohio | Stark | 39151 | 79566 | 1712 | 0 | 40.81482476 | -81.36437305 | 2022-03-23 04:20:48 | Stark, Ohio, US | |
3240843 | 3240843 | 2022-03-21 | US | Ohio | Stark | 39151 | 79566 | 1712 | 0 | 40.81482476 | -81.36437305 | 2022-03-22 04:20:54 | Stark, Ohio, US | |
26916 | 26916 | 2022-03-20 | US | Ohio | Stark | 39151 | 79566 | 1712 | 0 | 40.81482476 | -81.36437305 | 2022-03-21 04:20:50 | Stark, Ohio, US | |
1658926 | 1658926 | 2022-03-19 | US | Ohio | Stark | 39151 | 79566 | 1712 | 0 | 40.81482476 | -81.36437305 | 2022-03-20 04:20:45 | Stark, Ohio, US | |
919529 | 919529 | 2022-03-08 | Colombia | Sucre | 65602 | 1712 | 0 | 8.814 | -74.7233 | 2022-03-09 04:20:59 | Sucre, Colombia | |||
1547816 | 1547816 | 2022-03-07 | Colombia | Sucre | 65599 | 1712 | 0 | 8.814 | -74.7233 | 2022-03-08 04:20:54 | Sucre, Colombia | |||
3857407 | 3857407 | 2022-02-18 | US | Maryland | Baltimore City | 24510 | 109568 | 1712 | 0 | 39.30211911 | -76.61151012 | 2022-02-19 04:21:11 | Baltimore City, Maryland, US | |
1297951 | 1297951 | 2022-02-17 | Germany | Mecklenburg-Vorpommern | 201359 | 1712 | 0 | 53.6127 | 12.4296 | 2022-02-18 04:21:04 | Mecklenburg-Vorpommern, Germany | |||
2015529 | 2015529 | 2022-02-06 | US | South Carolina | Greenville | 45045 | 167177 | 1712 | 0 | 34.89502264 | -82.37295012 | 2022-02-07 04:21:05 | Greenville, South Carolina, US | |
1296858 | 1296858 | 2022-02-05 | US | South Carolina | Greenville | 45045 | 167177 | 1712 | 0 | 34.89502264 | -82.37295012 | 2022-02-06 04:21:00 | Greenville, South Carolina, US | |
2330186 | 2330186 | 2022-02-04 | US | South Carolina | Greenville | 45045 | 167177 | 1712 | 0 | 34.89502264 | -82.37295012 | 2022-02-05 04:21:05 | Greenville, South Carolina, US | |
4000248 | 4000248 | 2021-12-30 | US | Massachusetts | Bristol | 25005 | 105028 | 1712 | 0 | 41.79228404 | -71.10872211 | 2021-12-31 04:21:50 | Bristol, Massachusetts, US | |
1258766 | 1258766 | 2021-12-18 | Italy | Sardegna | 82101 | 1712 | 0 | 39.21531192 | 9.110616306 | 2021-12-19 04:21:11 | Sardegna, Italy | |||
2398794 | 2398794 | 2021-12-17 | Italy | Sardegna | 81919 | 1712 | 0 | 39.21531192 | 9.110616306 | 2021-12-18 02:22:20 | Sardegna, Italy | |||
2088241 | 2088241 | 2021-12-14 | Russia | Zabaykalsky Krai | 92078 | 1712 | 0 | 52.248521000000004 | 115.956325 | 2021-12-15 03:22:16 | Zabaykalsky Krai, Russia | |||
554340 | 554340 | 2021-12-08 | US | Wisconsin | Milwaukee | 55079 | 165151 | 1712 | 0 | 43.00486062 | -87.96733172 | 2021-12-09 04:22:49 | Milwaukee, Wisconsin, US | |
3289136 | 3289136 | 2021-11-18 | Russia | Kursk Oblast | 72520 | 1712 | 0 | 51.6568453 | 36.4852695 | 2021-11-19 04:21:40 | Kursk Oblast, Russia | |||
2722586 | 2722586 | 2021-10-30 | US | Maryland | Montgomery | 24031 | 82473 | 1712 | 0 | 39.13676329 | -77.20358245 | 2021-10-31 04:22:08 | Montgomery, Maryland, US | |
3793800 | 3793800 | 2021-10-25 | Germany | Schleswig-Holstein | 79941 | 1712 | 0 | 54.2194 | 9.6961 | 2021-10-26 04:22:09 | Schleswig-Holstein, Germany | |||
444940 | 444940 | 2021-10-20 | US | Maryland | Prince George's | 24033 | 98991 | 1712 | 0 | 38.83070039 | -76.8496441 | 2021-10-21 04:21:18 | Prince George's, Maryland, US | |
597800 | 597800 | 2021-10-19 | Netherlands | Limburg | 137185 | 1712 | 0 | 51.209227 | 5.93387 | 2021-10-20 04:21:00 | Limburg, Netherlands | |||
2878383 | 2878383 | 2021-10-09 | US | New Jersey | Monmouth | 34025 | 90100 | 1712 | 0 | 40.26549699 | -74.22240686 | 2021-10-10 04:21:38 | Monmouth, New Jersey, US | |
3832709 | 3832709 | 2021-10-05 | Russia | Lipetsk Oblast | 54232 | 1712 | 0 | 52.693517799999995 | 39.112266399999996 | 2021-10-06 04:21:33 | Lipetsk Oblast, Russia | |||
2809126 | 2809126 | 2021-09-16 | US | Alabama | Jefferson | 1073 | 108713 | 1712 | 0 | 33.55554728 | -86.89506300000002 | 2021-09-17 04:21:46 | Jefferson, Alabama, US | |
1374871 | 1374871 | 2021-09-15 | US | Alabama | Jefferson | 1073 | 108230 | 1712 | 0 | 33.55554728 | -86.89506300000002 | 2021-09-16 04:22:19 | Jefferson, Alabama, US | |
1385933 | 1385933 | 2021-09-13 | Spain | Murcia | 139172 | 1712 | 0 | 37.9922 | -1.1307 | 2021-09-14 04:21:41 | Murcia, Spain | |||
1385867 | 1385867 | 2021-09-13 | Russia | Orenburg Oblast | 71544 | 1712 | 0 | 52.02692620000001 | 54.7276647 | 2021-09-14 04:21:41 | Orenburg Oblast, Russia | |||
2279461 | 2279461 | 2021-09-08 | Spain | Murcia | 138791 | 1712 | 0 | 37.9922 | -1.1307 | 2021-09-09 04:21:27 | Murcia, Spain | |||
2279015 | 2279015 | 2021-09-08 | Colombia | Quindio | 55810 | 1712 | 0 | 4.461 | -75.6674 | 2021-09-09 04:21:27 | Quindio, Colombia | |||
641794 | 641794 | 2021-09-07 | Colombia | Quindio | 55786 | 1712 | 0 | 4.461 | -75.6674 | 2021-09-08 04:21:31 | Quindio, Colombia | |||
3193857 | 3193857 | 2021-09-06 | Colombia | Quindio | 55770 | 1712 | 0 | 4.461 | -75.6674 | 2021-09-07 04:21:35 | Quindio, Colombia | |||
3280725 | 3280725 | 2021-09-05 | Colombia | Quindio | 55761 | 1712 | 0 | 4.461 | -75.6674 | 2021-09-06 04:21:22 | Quindio, Colombia | |||
67321 | 67321 | 2021-09-01 | Russia | Vladimir Oblast | 49395 | 1712 | 0 | 56.0503336 | 40.656163299999996 | 2021-09-02 04:21:15 | Vladimir Oblast, Russia | |||
2793146 | 2793146 | 2021-08-28 | Montenegro | 113808 | 1712 | 0 | 42.708678000000006 | 19.37439 | 2021-08-29 04:21:14 | Montenegro | ||||
248911 | 248911 | 2021-08-17 | Ukraine | Vinnytsia Oblast | 71980 | 1712 | 0 | 49.2331 | 28.4682 | 2021-08-18 04:21:35 | Vinnytsia Oblast, Ukraine | |||
1607874 | 1607874 | 2021-08-16 | Ukraine | Vinnytsia Oblast | 71973 | 1712 | 0 | 49.2331 | 28.4682 | 2021-08-17 04:21:49 | Vinnytsia Oblast, Ukraine | |||
3471214 | 3471214 | 2021-08-03 | US | Texas | Cameron | 48061 | 48737 | 1712 | 0 | 26.14524221 | -97.48140372 | 2021-08-04 04:21:25 | Cameron, Texas, US | |
3468370 | 3468370 | 2021-08-03 | Russia | Buryatia Republic | 52937 | 1712 | 47390 | 3835 | 52.7182426 | 109.492143 | 2021-08-04 04:21:25 | Buryatia Republic, Russia | ||
483669 | 483669 | 2021-07-19 | Mexico | Chiapas | 13141 | 1712 | 0 | 11429 | 16.7569 | -93.1292 | 2021-07-20 04:21:48 | Chiapas, Mexico | ||
2693937 | 2693937 | 2021-07-06 | Russia | Stavropol Krai | 58163 | 1712 | 54287 | 2164 | 44.86325770000001 | 43.4406913 | 2021-07-07 04:21:20 | Stavropol Krai, Russia | ||
3381103 | 3381103 | 2021-06-13 | Brazil | Acre | 84174 | 1712 | 78886 | 3576 | -9.0238 | -70.812 | 2021-06-14 04:22:46 | Acre, Brazil | ||
1736702 | 1736702 | 2021-06-12 | Russia | Chelyabinsk Oblast | 62857 | 1712 | 58886 | 2259 | 54.4223954 | 61.1865846 | 2021-06-13 04:22:44 | Chelyabinsk Oblast, Russia | ||
2315843 | 2315843 | 2021-06-04 | US | California | Fresno | 6019 | 111228 | 1712 | 0 | 36.75733899 | -119.6466953 | 2021-06-05 04:23:03 | Fresno, California, US | |
1448317 | 1448317 | 2021-06-03 | Brazil | Amapa | 112654 | 1712 | 88251 | 22691 | 0.902 | -52.003 | 2021-06-04 04:23:37 | Amapa, Brazil | ||
1188918 | 1188918 | 2021-05-31 | Peru | Tacna | 25336 | 1712 | 0 | 23624 | -17.644160999999997 | -70.27756 | 2021-06-01 04:23:09 | Tacna, Peru | ||
2259366 | 2259366 | 2021-05-19 | Ukraine | Poltava Oblast | 75855 | 1712 | 70208 | 3935 | 49.5883 | 34.5514 | 2021-05-20 04:21:05 | Poltava Oblast, Ukraine | ||
2008286 | 2008286 | 2021-05-12 | Ukraine | Khmelnytskyi Oblast | 85691 | 1712 | 75635 | 8344 | 49.423 | 26.9871 | 2021-05-13 04:20:51 | Khmelnytskyi Oblast, Ukraine | ||
2022949 | 2022949 | 2021-04-20 | US | New York | Erie | 36029 | 83198 | 1712 | 0 | 42.76249024 | -78.73063652 | 2021-04-21 04:21:14 | Erie, New York, US | |
2571532 | 2571532 | 2021-04-13 | Colombia | Narino | 51103 | 1712 | 48339 | 1052 | 1.2892 | -77.3579 | 2021-04-14 04:20:41 | Narino, Colombia | ||
36283 | 36283 | 2021-04-12 | Colombia | Narino | 51103 | 1712 | 48339 | 1052 | 1.2892 | -77.3579 | 2021-04-13 04:20:37 | Narino, Colombia | ||
3885189 | 3885189 | 2021-04-11 | US | Massachusetts | Worcester | 25027 | 72520 | 1712 | 0 | 42.35026951 | -71.90493363 | 2021-04-12 04:21:00 | Worcester, Massachusetts, US | |
3883442 | 3883442 | 2021-04-11 | Colombia | Narino | 51014 | 1712 | 48290 | 1012 | 1.2892 | -77.3579 | 2021-04-12 04:21:00 | Narino, Colombia | ||
2249650 | 2249650 | 2021-04-07 | US | New York | Richmond | 36085 | 67861 | 1712 | 0 | 40.58582155 | -74.14808598 | 2021-04-08 04:21:13 | Richmond, New York, US | |
241222 | 241222 | 2021-04-02 | India | Telangana | 310819 | 1712 | 302207 | 6900 | 18.1124 | 79.0193 | 2021-04-03 04:20:44 | Telangana, India | ||
2639896 | 2639896 | 2021-02-11 | US | New Jersey | Union | 34039 | 53421 | 1712 | 0 | 51709 | 40.65835409 | -74.30680092 | 2021-02-12 05:23:29 | Union, New Jersey, US |
975092 | 975092 | 2021-02-06 | Peru | Ucayali | 21756 | 1712 | 0 | 20044 | -9.621718 | -73.444929 | 2021-02-07 05:23:00 | Ucayali, Peru | ||
1676391 | 1676391 | 2021-02-01 | Germany | Sachsen-Anhalt | 51620 | 1712 | 43588 | 7199 | 51.9503 | 11.6923 | 2021-02-02 05:22:49 | Sachsen-Anhalt, Germany | ||
1459679 | 1459679 | 2021-01-31 | Germany | Sachsen-Anhalt | 51620 | 1712 | 42971 | 7663 | 51.9503 | 11.6923 | 2021-02-01 05:22:53 | Sachsen-Anhalt, Germany | ||
1897324 | 1897324 | 2021-01-29 | Peru | Puno | 20462 | 1712 | 0 | 18750 | -14.995826999999998 | -69.922726 | 2021-01-30 05:22:49 | Puno, Peru | ||
3695337 | 3695337 | 2020-12-31 | Colombia | Cundinamarca | 67160 | 1712 | 61645 | 3803 | 5.026 | -74.03 | 2021-01-01 05:23:07 | Cundinamarca, Colombia | ||
1006286 | 1006286 | 2020-12-06 | Italy | Puglia | 64341 | 1712 | 16795 | 45834 | 41.12559576 | 16.86736689 | 2020-12-07 05:26:14 | Puglia, Italy | ||
3566439 | 3566439 | 2020-11-29 | Croatia | 126612 | 1712 | 101838 | 23062 | 45.1 | 15.2 | 2020-11-30 05:26:13 | Croatia | |||
1972276 | 1972276 | 2020-11-25 | Afghanistan | 45278 | 1712 | 36145 | 7421 | 33.93911 | 67.709953 | 2020-11-26 05:27:44 | Afghanistan | |||
762417 | 762417 | 2020-10-18 | Mexico | Yucatan | 20318 | 1712 | 17527 | 1079 | 20.7099 | -89.0943 | 2020-10-19 04:24:16 | Yucatan, Mexico | ||
2514148 | 2514148 | 2020-10-03 | Israel | 264793 | 1712 | 192966 | 70115 | 31.046051 | 34.851612 | 2020-10-04 04:23:44 | Israel | |||
3389485 | 3389485 | 2020-10-02 | Mexico | San Luis Potosi | 23373 | 1712 | 20821 | 840 | 22.1565 | -100.9855 | 2020-10-03 04:23:40 | San Luis Potosi, Mexico | ||
371253 | 371253 | 2020-08-08 | Brazil | Distrito Federal | 121824 | 1712 | 103859 | 16253 | -15.7998 | -47.8645 | 2020-08-09 04:34:54 | Distrito Federal, Brazil | ||
2564152 | 2564152 | 2020-07-24 | Portugal | 49692 | 1712 | 34687 | 13293 | 39.3999 | -8.2245 | 2020-07-25 04:47:39 | Portugal | |||
121977 | 121977 | 2020-07-19 | Germany | Nordrhein-Westfalen | 46024 | 1712 | 42300 | 2012 | 51.4332 | 7.6616 | 2020-07-20 05:34:40 | Nordrhein-Westfalen, Germany | ||
3205366 | 3205366 | 2020-07-18 | Germany | Nordrhein-Westfalen | 45910 | 1712 | 41904 | 2294 | 51.4332 | 7.6616 | 2020-07-19 04:34:58 | Nordrhein-Westfalen, Germany |
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]);