johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
90 rows where deaths = 2117 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3040523 | 3040523 | 2022-10-27 | US | New Mexico | Bernalillo | 35001 | 183162 | 2117 | 0 | 35.05163625 | -106.6703554 | 2022-10-28 04:22:31 | Bernalillo, New Mexico, US | |
540943 | 540943 | 2022-10-26 | US | New Mexico | Bernalillo | 35001 | 182952 | 2117 | 0 | 35.05163625 | -106.6703554 | 2022-10-27 04:22:01 | Bernalillo, New Mexico, US | |
3099943 | 3099943 | 2022-10-09 | US | Ohio | Montgomery | 39113 | 149379 | 2117 | 0 | 39.75394919 | -84.29050975 | 2022-10-10 04:22:32 | Montgomery, Ohio, US | |
3910475 | 3910475 | 2022-08-11 | US | Ohio | Hamilton | 39061 | 212359 | 2117 | 0 | 39.19673558 | -84.54502924 | 2022-08-12 04:20:54 | Hamilton, Ohio, US | |
1348792 | 1348792 | 2022-08-10 | US | Ohio | Hamilton | 39061 | 210594 | 2117 | 0 | 39.19673558 | -84.54502924 | 2022-08-11 04:20:49 | Hamilton, Ohio, US | |
2010278 | 2010278 | 2022-08-04 | US | Maryland | Montgomery | 24031 | 211569 | 2117 | 0 | 39.13676329 | -77.20358245 | 2022-08-05 04:20:52 | Montgomery, Maryland, US | |
1099705 | 1099705 | 2022-08-03 | US | Maryland | Montgomery | 24031 | 211140 | 2117 | 0 | 39.13676329 | -77.20358245 | 2022-08-04 04:20:58 | Montgomery, Maryland, US | |
91126 | 91126 | 2022-07-23 | Japan | Aichi | 692653 | 2117 | 0 | 35.035551 | 137.211621 | 2022-07-24 04:20:47 | Aichi, Japan | |||
2311549 | 2311549 | 2022-06-17 | Russia | Sakha (Yakutiya) Republic | 180924 | 2117 | 0 | 66.941626 | 129.642371 | 2022-06-18 04:21:10 | Sakha (Yakutiya) Republic, Russia | |||
559053 | 559053 | 2022-06-16 | Russia | Sakha (Yakutiya) Republic | 180885 | 2117 | 0 | 66.941626 | 129.642371 | 2022-06-17 04:20:56 | Sakha (Yakutiya) Republic, Russia | |||
3982855 | 3982855 | 2022-06-15 | Russia | Sakha (Yakutiya) Republic | 180847 | 2117 | 0 | 66.941626 | 129.642371 | 2022-06-16 04:20:55 | Sakha (Yakutiya) Republic, Russia | |||
947096 | 947096 | 2022-06-14 | Russia | Sakha (Yakutiya) Republic | 180810 | 2117 | 0 | 66.941626 | 129.642371 | 2022-06-15 04:20:54 | Sakha (Yakutiya) Republic, Russia | |||
2979504 | 2979504 | 2022-06-13 | Russia | Sakha (Yakutiya) Republic | 180775 | 2117 | 0 | 66.941626 | 129.642371 | 2022-06-14 04:20:52 | Sakha (Yakutiya) Republic, Russia | |||
3730230 | 3730230 | 2022-04-03 | Japan | Hyogo | 339516 | 2117 | 0 | 35.039913 | 134.828057 | 2022-04-04 04:20:51 | Hyogo, Japan | |||
3628535 | 3628535 | 2022-03-13 | US | California | San Joaquin | 6077 | 175484 | 2117 | 0 | 37.93433732 | -121.2730061 | 2022-03-14 04:20:46 | San Joaquin, California, US | |
3627935 | 3627935 | 2022-03-13 | Italy | Sardegna | 194075 | 2117 | 0 | 39.21531192 | 9.110616306 | 2022-03-14 04:20:46 | Sardegna, Italy | |||
951443 | 951443 | 2022-03-12 | US | California | San Joaquin | 6077 | 175356 | 2117 | 0 | 37.93433732 | -121.2730061 | 2022-03-13 04:20:49 | San Joaquin, California, US | |
356904 | 356904 | 2022-03-11 | US | California | San Joaquin | 6077 | 175353 | 2117 | 0 | 37.93433732 | -121.2730061 | 2022-03-12 04:20:50 | San Joaquin, California, US | |
921271 | 921271 | 2022-03-08 | US | Maryland | Prince George's | 24033 | 169163 | 2117 | 0 | 38.83070039 | -76.8496441 | 2022-03-09 04:20:59 | Prince George's, Maryland, US | |
2665762 | 2665762 | 2022-03-04 | Italy | Calabria | 222996 | 2117 | 0 | 38.90597598 | 16.59440194 | 2022-03-05 04:21:10 | Calabria, Italy | |||
943386 | 943386 | 2022-02-28 | US | California | Kern | 6029 | 236843 | 2117 | 0 | 35.34329425 | -118.72777959999999 | 2022-03-01 04:21:09 | Kern, California, US | |
943045 | 943045 | 2022-02-28 | Russia | Kemerovo Oblast | 143678 | 2117 | 0 | 54.53357809999999 | 87.342861 | 2022-03-01 04:21:09 | Kemerovo Oblast, Russia | |||
3674236 | 3674236 | 2022-02-15 | US | Oklahoma | Oklahoma | 40109 | 188647 | 2117 | 0 | 35.55140095 | -97.40716948 | 2022-02-16 04:21:10 | Oklahoma, Oklahoma, US | |
2644337 | 2644337 | 2022-02-14 | US | Oklahoma | Oklahoma | 40109 | 188647 | 2117 | 0 | 35.55140095 | -97.40716948 | 2022-02-15 04:21:09 | Oklahoma, Oklahoma, US | |
188654 | 188654 | 2022-02-13 | US | Oklahoma | Oklahoma | 40109 | 188647 | 2117 | 0 | 35.55140095 | -97.40716948 | 2022-02-14 04:20:51 | Oklahoma, Oklahoma, US | |
318500 | 318500 | 2022-02-12 | US | Oklahoma | Oklahoma | 40109 | 188647 | 2117 | 0 | 35.55140095 | -97.40716948 | 2022-02-13 04:21:00 | Oklahoma, Oklahoma, US | |
235826 | 235826 | 2022-02-11 | US | Oklahoma | Oklahoma | 40109 | 188647 | 2117 | 0 | 35.55140095 | -97.40716948 | 2022-02-12 04:21:06 | Oklahoma, Oklahoma, US | |
1466668 | 1466668 | 2022-02-10 | US | Oklahoma | Oklahoma | 40109 | 188647 | 2117 | 0 | 35.55140095 | -97.40716948 | 2022-02-11 04:21:09 | Oklahoma, Oklahoma, US | |
3076629 | 3076629 | 2022-02-09 | US | Oklahoma | Oklahoma | 40109 | 188647 | 2117 | 0 | 35.55140095 | -97.40716948 | 2022-02-10 04:21:14 | Oklahoma, Oklahoma, US | |
1362733 | 1362733 | 2022-02-08 | US | Alabama | Jefferson | 1073 | 178979 | 2117 | 0 | 33.55554728 | -86.89506300000002 | 2022-02-09 04:21:04 | Jefferson, Alabama, US | |
3810012 | 3810012 | 2022-01-28 | Mexico | Campeche | 29259 | 2117 | 0 | 19.8301 | -90.5349 | 2022-01-29 04:21:10 | Campeche, Mexico | |||
555011 | 555011 | 2022-01-16 | Russia | Kursk Oblast | 83225 | 2117 | 0 | 51.6568453 | 36.4852695 | 2022-01-17 04:21:08 | Kursk Oblast, Russia | |||
99441 | 99441 | 2022-01-14 | Mozambique | 217821 | 2117 | 0 | -18.665695 | 35.529562 | 2022-01-15 04:21:07 | Mozambique | ||||
2905438 | 2905438 | 2021-12-19 | US | Minnesota | Hennepin | 27053 | 191052 | 2117 | 0 | 45.00761521 | -93.47694895 | 2021-12-20 04:21:43 | Hennepin, Minnesota, US | |
1260511 | 1260511 | 2021-12-18 | US | Minnesota | Hennepin | 27053 | 191052 | 2117 | 0 | 45.00761521 | -93.47694895 | 2021-12-19 04:21:11 | Hennepin, Minnesota, US | |
2400539 | 2400539 | 2021-12-17 | US | Minnesota | Hennepin | 27053 | 191052 | 2117 | 0 | 45.00761521 | -93.47694895 | 2021-12-18 02:22:20 | Hennepin, Minnesota, US | |
3499635 | 3499635 | 2021-12-15 | US | Washington | King | 53033 | 177812 | 2117 | 0 | 47.49137892 | -121.8346131 | 2021-12-16 04:22:11 | King, Washington, US | |
3496478 | 3496478 | 2021-12-15 | Spain | Asturias | 80180 | 2117 | 0 | 43.3614 | -5.8593 | 2021-12-16 04:22:11 | Asturias, Spain | |||
1664496 | 1664496 | 2021-12-11 | Malaysia | Kedah | 163686 | 2117 | 0 | 6.1184 | 100.3685 | 2021-12-12 04:22:12 | Kedah, Malaysia | |||
447561 | 447561 | 2021-11-17 | Russia | Astrakhan Oblast | 70653 | 2117 | 0 | 47.1878186 | 47.608851 | 2021-11-18 04:21:33 | Astrakhan Oblast, Russia | |||
657636 | 657636 | 2021-10-22 | Ukraine | Poltava Oblast | 91836 | 2117 | 0 | 49.5883 | 34.5514 | 2021-10-23 04:21:32 | Poltava Oblast, Ukraine | |||
2043834 | 2043834 | 2021-10-18 | Jamaica | 87586 | 2117 | 0 | 18.1096 | -77.2975 | 2021-10-19 04:20:54 | Jamaica | ||||
495286 | 495286 | 2021-10-14 | United Arab Emirates | 738268 | 2117 | 0 | 23.424076 | 53.847818000000004 | 2021-10-15 04:21:26 | United Arab Emirates | ||||
809810 | 809810 | 2021-09-20 | Russia | Omsk Oblast | 80790 | 2117 | 0 | 56.09352629999999 | 73.5099936 | 2021-09-21 04:21:26 | Omsk Oblast, Russia | |||
582516 | 582516 | 2021-07-13 | Malaysia | Selangor | 295925 | 2117 | 247950 | 45858 | 3.0738 | 101.5183 | 2021-07-14 04:21:35 | Selangor, Malaysia | ||
3659649 | 3659649 | 2021-07-11 | Kuwait | 375594 | 2117 | 355562 | 17915 | 29.31166 | 47.481766 | 2021-07-12 04:21:34 | Kuwait | |||
2884506 | 2884506 | 2021-06-20 | Nigeria | 167206 | 2117 | 163557 | 1532 | 9.082 | 8.6753 | 2021-06-21 04:21:41 | Nigeria | |||
107589 | 107589 | 2021-06-19 | Nigeria | 167206 | 2117 | 163550 | 1539 | 9.082 | 8.6753 | 2021-06-20 04:21:48 | Nigeria | |||
1125732 | 1125732 | 2021-06-18 | Nigeria | 167155 | 2117 | 163540 | 1498 | 9.082 | 8.6753 | 2021-06-19 04:22:33 | Nigeria | |||
2911310 | 2911310 | 2021-06-17 | Nigeria | 167142 | 2117 | 163535 | 1490 | 9.082 | 8.6753 | 2021-06-18 04:22:16 | Nigeria | |||
3030427 | 3030427 | 2021-06-16 | Nigeria | 167103 | 2117 | 163528 | 1458 | 9.082 | 8.6753 | 2021-06-17 04:22:36 | Nigeria | |||
2339533 | 2339533 | 2021-06-15 | Nigeria | 167095 | 2117 | 163483 | 1495 | 9.082 | 8.6753 | 2021-06-16 04:22:32 | Nigeria | |||
1564229 | 1564229 | 2021-06-14 | Nigeria | 167078 | 2117 | 163469 | 1492 | 9.082 | 8.6753 | 2021-06-15 04:22:22 | Nigeria | |||
3381512 | 3381512 | 2021-06-13 | Nigeria | 167066 | 2117 | 163463 | 1486 | 9.082 | 8.6753 | 2021-06-14 04:22:46 | Nigeria | |||
1736646 | 1736646 | 2021-06-12 | Nigeria | 167059 | 2117 | 163436 | 1506 | 9.082 | 8.6753 | 2021-06-13 04:22:44 | Nigeria | |||
3970687 | 3970687 | 2021-06-11 | Nigeria | 167051 | 2117 | 163430 | 1504 | 9.082 | 8.6753 | 2021-06-12 04:22:22 | Nigeria | |||
2717109 | 2717109 | 2021-06-10 | Nigeria | 166982 | 2117 | 163331 | 1534 | 9.082 | 8.6753 | 2021-06-11 04:23:20 | Nigeria | |||
522994 | 522994 | 2021-06-09 | Nigeria | 166982 | 2117 | 163331 | 1534 | 9.082 | 8.6753 | 2021-06-10 04:23:17 | Nigeria | |||
3472434 | 3472434 | 2021-06-08 | Nigeria | 166918 | 2117 | 163259 | 1542 | 9.082 | 8.6753 | 2021-06-09 04:23:31 | Nigeria | |||
3145718 | 3145718 | 2021-06-07 | Nigeria | 166816 | 2117 | 163190 | 1509 | 9.082 | 8.6753 | 2021-06-08 04:22:35 | Nigeria | |||
825720 | 825720 | 2021-06-06 | Nigeria | 166767 | 2117 | 163096 | 1554 | 9.082 | 8.6753 | 2021-06-07 04:22:51 | Nigeria | |||
2586125 | 2586125 | 2021-06-05 | Nigeria | 166756 | 2117 | 162994 | 1645 | 9.082 | 8.6753 | 2021-06-06 04:24:03 | Nigeria | |||
2315439 | 2315439 | 2021-06-04 | Nigeria | 166730 | 2117 | 162584 | 2029 | 9.082 | 8.6753 | 2021-06-05 04:23:03 | Nigeria | |||
1448724 | 1448724 | 2021-06-03 | Nigeria | 166682 | 2117 | 162521 | 2044 | 9.082 | 8.6753 | 2021-06-04 04:23:37 | Nigeria | |||
1807406 | 1807406 | 2021-05-27 | US | Connecticut | New Haven | 9009 | 91795 | 2117 | 0 | 41.4080325 | -72.93620426 | 2021-05-28 04:20:36 | New Haven, Connecticut, US | |
2820534 | 2820534 | 2021-05-10 | Canada | Alberta | 210387 | 2117 | 182832 | 25438 | 53.9333 | -116.5765 | 2021-05-11 04:20:41 | Alberta, Canada | ||
3677822 | 3677822 | 2021-05-04 | US | New Jersey | Ocean | 34029 | 74859 | 2117 | 0 | 39.8895449 | -74.28089251 | 2021-05-05 04:20:43 | Ocean, New Jersey, US | |
1639979 | 1639979 | 2021-04-29 | Venezuela | 196386 | 2117 | 178072 | 16197 | 6.4238 | -66.5897 | 2021-04-30 04:21:03 | Venezuela | |||
3393279 | 3393279 | 2021-04-28 | El Salvador | 68922 | 2117 | 64667 | 2138 | 13.7942 | -88.8965 | 2021-04-29 04:20:55 | El Salvador | |||
2573639 | 2573639 | 2021-04-13 | US | Missouri | St. Louis | 29189 | 94780 | 2117 | 0 | 38.63770039999999 | -90.4458375 | 2021-04-14 04:20:41 | St. Louis, Missouri, US | |
388879 | 388879 | 2021-04-04 | US | Connecticut | Fairfield | 9001 | 90537 | 2117 | 0 | 41.26809896 | -73.3881171 | 2021-04-05 04:20:35 | Fairfield, Connecticut, US | |
3710795 | 3710795 | 2021-04-03 | US | Connecticut | Fairfield | 9001 | 90537 | 2117 | 0 | 41.26809896 | -73.3881171 | 2021-04-04 04:20:49 | Fairfield, Connecticut, US | |
241911 | 241911 | 2021-04-02 | US | Connecticut | Fairfield | 9001 | 90537 | 2117 | 0 | 41.26809896 | -73.3881171 | 2021-04-03 04:20:44 | Fairfield, Connecticut, US | |
640371 | 640371 | 2021-03-31 | US | Ohio | Cuyahoga | 39035 | 101978 | 2117 | 0 | 41.424119 | -81.65918339 | 2021-04-01 04:27:05 | Cuyahoga, Ohio, US | |
3646000 | 3646000 | 2021-03-30 | US | Ohio | Cuyahoga | 39035 | 101722 | 2117 | 0 | 41.424119 | -81.65918339 | 2021-03-31 04:26:25 | Cuyahoga, Ohio, US | |
1535979 | 1535979 | 2021-03-28 | Kenya | 130214 | 2117 | 91754 | 36343 | -0.0236 | 37.9062 | 2021-03-29 04:28:35 | Kenya | |||
182197 | 182197 | 2021-02-21 | Peru | Cusco | 33380 | 2117 | 0 | 31263 | -13.191068 | -72.153609 | 2021-02-22 05:24:21 | Cusco, Peru | ||
1679541 | 1679541 | 2021-02-01 | US | Texas | El Paso | 48141 | 93356 | 2117 | 0 | 111941 | 31.76980765 | -106.2363275 | 2021-02-02 05:22:49 | El Paso, Texas, US |
2867771 | 2867771 | 2021-01-06 | US | Texas | Dallas | 48113 | 180703 | 2117 | 0 | 204685 | 32.76670599 | -96.7779605 | 2021-01-07 05:22:03 | Dallas, Texas, US |
1602902 | 1602902 | 2020-12-10 | US | Pennsylvania | Philadelphia | 42101 | 78972 | 2117 | 0 | 76855 | 40.00338507 | -75.1379271 | 2020-12-11 05:26:59 | Philadelphia, Pennsylvania, US |
1600195 | 1600195 | 2020-12-10 | Ireland | 75203 | 2117 | 23364 | 49722 | 53.1424 | -7.6921 | 2020-12-11 05:26:59 | Ireland | |||
821701 | 821701 | 2020-11-19 | Netherlands | Zuid-Holland | 134599 | 2117 | 0 | 131897 | 51.937835 | 4.462114 | 2020-11-20 05:26:28 | Zuid-Holland, Netherlands | ||
1988721 | 1988721 | 2020-11-09 | Mexico | Michoacan | 26165 | 2117 | 23178 | 870 | 19.5665 | -101.7068 | 2020-11-10 05:40:07 | Michoacan, Mexico | ||
79263 | 79263 | 2020-10-14 | Portugal | 91193 | 2117 | 54493 | 34583 | 39.3999 | -8.2245 | 2020-10-15 04:24:28 | Portugal | |||
79065 | 79065 | 2020-10-14 | Israel | 299242 | 2117 | 259060 | 38065 | 31.046051 | 34.851612 | 2020-10-15 04:24:28 | Israel | |||
3389271 | 3389271 | 2020-10-02 | Dominican Republic | 113350 | 2117 | 88840 | 22393 | 18.7357 | -70.1627 | 2020-10-03 04:23:40 | Dominican Republic | |||
3316082 | 3316082 | 2020-09-22 | Colombia | Valle del Cauca | 58048 | 2117 | 47901 | 8030 | 3.8009 | -76.6413 | 2020-09-23 04:23:00 | Valle del Cauca, Colombia | ||
2836681 | 2836681 | 2020-09-21 | Colombia | Valle del Cauca | 57483 | 2117 | 47901 | 7465 | 3.8009 | -76.6413 | 2020-09-22 04:23:00 | Valle del Cauca, Colombia | ||
1107705 | 1107705 | 2020-09-02 | US | New Jersey | Essex | 34013 | 20637 | 2117 | 0 | 18520 | 40.78681335 | -74.24657979 | 2020-09-03 04:28:22 | Essex, New Jersey, US |
2510182 | 2510182 | 2020-08-27 | Italy | Veneto | 22469 | 2117 | 18131 | 2221 | 45.43490485 | 12.33845213 | 2020-08-28 04:28:11 | Veneto, Italy |
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]);