johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
80 rows where deaths = 1641 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2138339 | 2138339 | 2022-12-01 | US | New Jersey | Morris | 34027 | 155705 | 1641 | 0 | 40.86095313 | -74.5455371 | 2022-12-02 04:21:07 | Morris, New Jersey, US | |
1621339 | 1621339 | 2022-11-22 | US | Illinois | Will | 17197 | 204919 | 1641 | 0 | 41.44619267 | -87.97862712 | 2022-11-23 04:21:06 | Will, Illinois, US | |
3461227 | 3461227 | 2022-11-21 | US | Illinois | Will | 17197 | 204816 | 1641 | 0 | 41.44619267 | -87.97862712 | 2022-11-22 04:20:47 | Will, Illinois, US | |
1641412 | 1641412 | 2022-11-20 | US | Illinois | Will | 17197 | 204519 | 1641 | 0 | 41.44619267 | -87.97862712 | 2022-11-21 04:21:05 | Will, Illinois, US | |
2064969 | 2064969 | 2022-11-19 | US | Illinois | Will | 17197 | 204519 | 1641 | 0 | 41.44619267 | -87.97862712 | 2022-11-20 04:21:08 | Will, Illinois, US | |
1756363 | 1756363 | 2022-11-18 | US | Illinois | Will | 17197 | 204519 | 1641 | 0 | 41.44619267 | -87.97862712 | 2022-11-19 04:21:14 | Will, Illinois, US | |
3027356 | 3027356 | 2022-11-17 | US | Illinois | Will | 17197 | 204422 | 1641 | 0 | 41.44619267 | -87.97862712 | 2022-11-18 04:21:15 | Will, Illinois, US | |
2487067 | 2487067 | 2022-11-16 | US | Illinois | Will | 17197 | 204291 | 1641 | 0 | 41.44619267 | -87.97862712 | 2022-11-17 04:21:11 | Will, Illinois, US | |
516012 | 516012 | 2022-10-15 | Singapore | 2005884 | 1641 | 0 | 1.2833 | 103.8333 | 2022-10-16 04:22:39 | Singapore | ||||
2033069 | 2033069 | 2022-10-14 | Singapore | 1997847 | 1641 | 0 | 1.2833 | 103.8333 | 2022-10-15 04:22:00 | Singapore | ||||
3405615 | 3405615 | 2022-07-17 | Peru | Apurimac | 39371 | 1641 | 0 | -14.027713 | -72.975378 | 2022-07-18 04:20:59 | Apurimac, Peru | |||
2151815 | 2151815 | 2022-07-16 | Peru | Apurimac | 39371 | 1641 | 0 | -14.027713 | -72.975378 | 2022-07-17 04:21:15 | Apurimac, Peru | |||
2419048 | 2419048 | 2022-07-15 | Peru | Apurimac | 39371 | 1641 | 0 | -14.027713 | -72.975378 | 2022-07-16 04:21:05 | Apurimac, Peru | |||
3429123 | 3429123 | 2022-07-14 | Peru | Apurimac | 39371 | 1641 | 0 | -14.027713 | -72.975378 | 2022-07-15 04:20:53 | Apurimac, Peru | |||
3109643 | 3109643 | 2022-07-13 | Peru | Apurimac | 39371 | 1641 | 0 | -14.027713 | -72.975378 | 2022-07-14 04:20:57 | Apurimac, Peru | |||
630066 | 630066 | 2022-07-12 | Peru | Apurimac | 39371 | 1641 | 0 | -14.027713 | -72.975378 | 2022-07-13 04:20:58 | Apurimac, Peru | |||
1211710 | 1211710 | 2022-07-11 | Peru | Apurimac | 39371 | 1641 | 0 | -14.027713 | -72.975378 | 2022-07-12 04:20:51 | Apurimac, Peru | |||
2241648 | 2241648 | 2022-06-28 | US | New York | Monroe | 36055 | 169971 | 1641 | 0 | 43.14638895 | -77.69322942 | 2022-06-29 04:20:59 | Monroe, New York, US | |
2443149 | 2443149 | 2022-04-13 | US | Alabama | Mobile | 1097 | 113130 | 1641 | 0 | 30.78472347 | -88.20842409 | 2022-04-13 23:21:06 | Mobile, Alabama, US | |
3733166 | 3733166 | 2022-04-03 | US | Tennessee | Davidson | 47037 | 191570 | 1641 | 0 | 36.17007426 | -86.78646056 | 2022-04-04 04:20:51 | Davidson, Tennessee, US | |
3628021 | 3628021 | 2022-03-13 | Malaysia | Sarawak | 278631 | 1641 | 0 | 1.5533 | 110.3592 | 2022-03-14 04:20:46 | Sarawak, Malaysia | |||
1994846 | 1994846 | 2022-03-01 | US | New Mexico | Bernalillo | 35001 | 144904 | 1641 | 0 | 35.05163625 | -106.6703554 | 2022-03-02 04:21:07 | Bernalillo, New Mexico, US | |
1300181 | 1300181 | 2022-02-17 | US | Nebraska | Unassigned | 90031 | 3872 | 1641 | 0 | 42.8997274 | 0.0 | 2022-02-18 04:21:04 | Unassigned, Nebraska, US | |
3075156 | 3075156 | 2022-02-09 | US | Indiana | Lake | 18089 | 104498 | 1641 | 0 | 41.41874274 | -87.38277575 | 2022-02-10 04:21:14 | Lake, Indiana, US | |
1363463 | 1363463 | 2022-02-08 | US | Indiana | Lake | 18089 | 104498 | 1641 | 0 | 41.41874274 | -87.38277575 | 2022-02-09 04:21:04 | Lake, Indiana, US | |
1781902 | 1781902 | 2022-01-27 | US | Ohio | Stark | 39151 | 77732 | 1641 | 0 | 40.81482476 | -81.36437305 | 2022-01-28 04:21:09 | Stark, Ohio, US | |
1140691 | 1140691 | 2022-01-23 | Chile | OHiggins | 76727 | 1641 | 0 | -34.5755 | -71.0022 | 2022-01-24 04:21:12 | OHiggins, Chile | |||
3465781 | 3465781 | 2022-01-18 | US | Massachusetts | Norfolk | 25021 | 115128 | 1641 | 0 | 42.16073095 | -71.20530408 | 2022-01-19 04:21:23 | Norfolk, Massachusetts, US | |
1716566 | 1716566 | 2021-12-16 | Russia | Kemerovo Oblast | 79795 | 1641 | 0 | 54.53357809999999 | 87.342861 | 2021-12-17 04:22:14 | Kemerovo Oblast, Russia | |||
597 | 597 | 2021-12-02 | Russia | Zabaykalsky Krai | 88343 | 1641 | 0 | 52.248521000000004 | 115.956325 | 2021-12-03 04:23:05 | Zabaykalsky Krai, Russia | |||
686600 | 686600 | 2021-11-13 | Russia | Ryazan Oblast | 51225 | 1641 | 0 | 54.42267320000001 | 40.57052460000001 | 2021-11-14 04:21:31 | Ryazan Oblast, Russia | |||
706412 | 706412 | 2021-09-29 | Italy | Sardegna | 75205 | 1641 | 0 | 39.21531192 | 9.110616306 | 2021-09-30 04:21:20 | Sardegna, Italy | |||
3450425 | 3450425 | 2021-09-10 | US | Maryland | Prince George's | 24033 | 93513 | 1641 | 0 | 38.83070039 | -76.8496441 | 2021-09-11 04:21:30 | Prince George's, Maryland, US | |
3891843 | 3891843 | 2021-08-29 | Germany | Hamburg | 84394 | 1641 | 0 | 53.5511 | 9.9937 | 2021-08-30 04:21:23 | Hamburg, Germany | |||
2792946 | 2792946 | 2021-08-28 | Germany | Hamburg | 84394 | 1641 | 0 | 53.5511 | 9.9937 | 2021-08-29 04:21:14 | Hamburg, Germany | |||
2923105 | 2923105 | 2021-08-27 | Germany | Hamburg | 84394 | 1641 | 0 | 53.5511 | 9.9937 | 2021-08-28 04:21:28 | Hamburg, Germany | |||
2175474 | 2175474 | 2021-08-22 | Germany | Schleswig-Holstein | 69104 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-23 04:21:27 | Schleswig-Holstein, Germany | |||
3555570 | 3555570 | 2021-08-21 | Germany | Schleswig-Holstein | 69104 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-22 04:21:29 | Schleswig-Holstein, Germany | |||
1853912 | 1853912 | 2021-08-20 | Germany | Schleswig-Holstein | 69104 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-21 04:21:38 | Schleswig-Holstein, Germany | |||
511973 | 511973 | 2021-08-19 | Senegal | 71441 | 1641 | 0 | 14.4974 | -14.4524 | 2021-08-20 04:21:33 | Senegal | ||||
511619 | 511619 | 2021-08-19 | Germany | Schleswig-Holstein | 68913 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-20 04:21:33 | Schleswig-Holstein, Germany | |||
2518098 | 2518098 | 2021-08-18 | Germany | Schleswig-Holstein | 68633 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-19 04:21:15 | Schleswig-Holstein, Germany | |||
245190 | 245190 | 2021-08-17 | Germany | Schleswig-Holstein | 68345 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-18 04:21:35 | Schleswig-Holstein, Germany | |||
1604153 | 1604153 | 2021-08-16 | Germany | Schleswig-Holstein | 68152 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-17 04:21:49 | Schleswig-Holstein, Germany | |||
103247 | 103247 | 2021-08-15 | Germany | Schleswig-Holstein | 67641 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-16 04:21:31 | Schleswig-Holstein, Germany | |||
507605 | 507605 | 2021-08-14 | Germany | Schleswig-Holstein | 67641 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-15 04:21:41 | Schleswig-Holstein, Germany | |||
1483477 | 1483477 | 2021-08-13 | Germany | Schleswig-Holstein | 67641 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-14 04:21:25 | Schleswig-Holstein, Germany | |||
2899988 | 2899988 | 2021-08-12 | Spain | Murcia | 132094 | 1641 | 0 | 37.9922 | -1.1307 | 2021-08-13 04:21:24 | Murcia, Spain | |||
2899607 | 2899607 | 2021-08-12 | Germany | Schleswig-Holstein | 67424 | 1641 | 0 | 54.2194 | 9.6961 | 2021-08-13 04:21:24 | Schleswig-Holstein, Germany | |||
2351551 | 2351551 | 2021-08-10 | Mozambique | 134343 | 1641 | 0 | -18.665695 | 35.529562 | 2021-08-11 04:21:58 | Mozambique | ||||
3385245 | 3385245 | 2021-07-29 | Colombia | Quindio | 54134 | 1641 | 51801 | 692 | 4.461 | -75.6674 | 2021-07-30 04:21:34 | Quindio, Colombia | ||
3743253 | 3743253 | 2021-07-12 | US | New Jersey | Monmouth | 34025 | 76551 | 1641 | 0 | 40.26549699 | -74.22240686 | 2021-07-13 04:21:18 | Monmouth, New Jersey, US | |
3661766 | 3661766 | 2021-07-11 | US | New Jersey | Monmouth | 34025 | 76533 | 1641 | 0 | 40.26549699 | -74.22240686 | 2021-07-12 04:21:34 | Monmouth, New Jersey, US | |
1712574 | 1712574 | 2021-06-25 | Russia | Stavropol Krai | 56535 | 1641 | 53572 | 1322 | 44.86325770000001 | 43.4406913 | 2021-06-26 04:21:43 | Stavropol Krai, Russia | ||
2939498 | 2939498 | 2021-05-16 | Peru | Tacna | 24250 | 1641 | 0 | 22609 | -17.644160999999997 | -70.27756 | 2021-05-17 04:20:34 | Tacna, Peru | ||
3710369 | 3710369 | 2021-04-03 | Russia | Novosibirsk Oblast | 39013 | 1641 | 36269 | 1103 | 54.9720169 | 79.48139240000002 | 2021-04-04 04:20:49 | Novosibirsk Oblast, Russia | ||
2055736 | 2055736 | 2021-03-15 | Colombia | Narino | 49710 | 1641 | 47116 | 953 | 1.2892 | -77.3579 | 2021-03-16 05:25:13 | Narino, Colombia | ||
3667589 | 3667589 | 2021-03-06 | India | Telangana | 299900 | 1641 | 296373 | 1886 | 18.1124 | 79.0193 | 2021-03-07 05:21:54 | Telangana, India | ||
1090166 | 1090166 | 2021-03-03 | Mexico | Nayarit | 10906 | 1641 | 0 | 9265 | 21.7514 | -104.8455 | 2021-03-04 05:24:24 | Nayarit, Mexico | ||
2285595 | 2285595 | 2021-02-14 | US | New Jersey | Passaic | 34031 | 54472 | 1641 | 0 | 52831 | 41.03238628 | -74.29954144 | 2021-02-15 05:24:49 | Passaic, New Jersey, US |
2679995 | 2679995 | 2021-02-13 | US | New Jersey | Passaic | 34031 | 54286 | 1641 | 0 | 52645 | 41.03238628 | -74.29954144 | 2021-02-14 05:23:43 | Passaic, New Jersey, US |
1528094 | 1528094 | 2021-02-09 | Russia | Irkutsk Oblast | 51009 | 1641 | 46359 | 3009 | 56.6370122 | 104.719221 | 2021-02-10 05:22:41 | Irkutsk Oblast, Russia | ||
1588312 | 1588312 | 2021-02-05 | Nigeria | 137654 | 1641 | 111639 | 24374 | 9.082 | 8.6753 | 2021-02-06 05:23:55 | Nigeria | |||
2211789 | 2211789 | 2021-01-30 | Netherlands | Gelderland | 111458 | 1641 | 0 | 109671 | 52.061738 | 5.939114 | 2021-01-31 05:22:42 | Gelderland, Netherlands | ||
2468979 | 2468979 | 2021-01-22 | US | New Jersey | Union | 34039 | 48741 | 1641 | 0 | 47100 | 40.65835409 | -74.30680092 | 2021-01-23 05:22:03 | Union, New Jersey, US |
774502 | 774502 | 2021-01-12 | Peru | Cajamarca | 26078 | 1641 | 0 | 24437 | -6.430284 | -78.74559599999998 | 2021-01-13 05:22:15 | Cajamarca, Peru | ||
1751363 | 1751363 | 2020-12-14 | Mexico | Queretaro | 27036 | 1641 | 0 | 25395 | 20.5888 | -100.3899 | 2020-12-15 05:26:38 | Queretaro, Mexico | ||
678261 | 678261 | 2020-11-23 | India | Jammu and Kashmir | 106899 | 1641 | 99827 | 5431 | 33.75943 | 76.612638 | 2020-11-24 05:27:31 | Jammu and Kashmir, India | ||
678182 | 678182 | 2020-11-23 | Costa Rica | 132295 | 1641 | 81336 | 49318 | 9.7489 | -83.7534 | 2020-11-24 05:27:31 | Costa Rica | |||
124829 | 124829 | 2020-11-18 | US | Nevada | Clark | 32003 | 98930 | 1641 | 0 | 97289 | 36.21458855 | -115.0130241 | 2020-11-19 05:25:23 | Clark, Nevada, US |
123421 | 123421 | 2020-11-18 | US | Florida | Palm Beach | 12099 | 59656 | 1641 | 0 | 58015 | 26.64676272 | -80.46536002 | 2020-11-19 05:25:23 | Palm Beach, Florida, US |
3340717 | 3340717 | 2020-11-17 | US | Nevada | Clark | 32003 | 97608 | 1641 | 0 | 95967 | 36.21458855 | -115.0130241 | 2020-11-18 05:40:31 | Clark, Nevada, US |
2243478 | 2243478 | 2020-10-30 | Mexico | Oaxaca | 21191 | 1641 | 18655 | 895 | 17.0732 | -96.7266 | 2020-10-31 04:24:44 | Oaxaca, Mexico | ||
1177599 | 1177599 | 2020-10-22 | Moldova | 69568 | 1641 | 50422 | 17505 | 47.4116 | 28.3699 | 2020-10-23 04:24:46 | Moldova | |||
1794615 | 1794615 | 2020-10-19 | Italy | Liguria | 18438 | 1641 | 12886 | 3911 | 44.41149315 | 8.9326992 | 2020-10-20 04:24:22 | Liguria, Italy | ||
3117588 | 3117588 | 2020-10-06 | Mexico | Yucatan | 19085 | 1641 | 16540 | 904 | 20.7099 | -89.0943 | 2020-10-07 04:23:40 | Yucatan, Mexico | ||
344355 | 344355 | 2020-09-14 | Mexico | Coahuila | 24267 | 1641 | 21361 | 1265 | 27.0587 | -101.7068 | 2020-09-15 03:22:50 | Coahuila, Mexico | ||
1105638 | 1105638 | 2020-09-02 | Mexico | Hidalgo | 10549 | 1641 | 8138 | 770 | 20.0911 | -98.7624 | 2020-09-03 04:28:22 | Hidalgo, Mexico | ||
1273551 | 1273551 | 2020-06-11 | Germany | Nordrhein-Westfalen | 38983 | 1641 | 35737 | 1605 | 51.4332 | 7.6616 | 2020-06-12 05:09:52 | Nordrhein-Westfalen, Germany | ||
805657 | 805657 | 2020-06-01 | Indonesia | 26940 | 1641 | 7637 | 17662 | -0.7893 | 113.9213 | 2020-06-02 02:33:08 | Indonesia |
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]);