johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
82 rows where deaths = 2478 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- US 46
- Russia 8
- Mexico 7
- Sweden 5
- Spain 4
- Albania 2
- Italy 2
- Chile 1
- Japan 1
- Kyrgyzstan 1
- Netherlands 1
- Peru 1
- Syria 1
- Ukraine 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487393 | 487393 | 2022-11-25 | Chile | Los Lagos | 233079 | 2478 | 0 | -41.9198 | -72.1416 | 2022-11-26 04:21:11 | Los Lagos, Chile | |||
621510 | 621510 | 2022-11-05 | Ukraine | Sevastopol* | 96047 | 2478 | 0 | 44.6054 | 33.522 | 2022-11-06 04:21:24 | Sevastopol*, Ukraine | |||
1562360 | 1562360 | 2022-09-28 | US | New York | Richmond | 36085 | 202188 | 2478 | 0 | 40.58582155 | -74.14808598 | 2022-09-29 04:22:34 | Richmond, New York, US | |
3996903 | 3996903 | 2022-09-27 | US | New York | Richmond | 36085 | 202056 | 2478 | 0 | 40.58582155 | -74.14808598 | 2022-09-28 04:23:01 | Richmond, New York, US | |
3987210 | 3987210 | 2022-09-15 | US | California | Santa Clara | 6085 | 447023 | 2478 | 0 | 37.23104908 | -121.6970462 | 2022-09-16 04:21:19 | Santa Clara, California, US | |
1889727 | 1889727 | 2022-09-14 | US | California | Santa Clara | 6085 | 447012 | 2478 | 0 | 37.23104908 | -121.6970462 | 2022-09-15 04:21:02 | Santa Clara, California, US | |
372782 | 372782 | 2022-09-13 | US | California | Santa Clara | 6085 | 447000 | 2478 | 0 | 37.23104908 | -121.6970462 | 2022-09-14 04:20:44 | Santa Clara, California, US | |
2395384 | 2395384 | 2022-09-12 | US | California | Santa Clara | 6085 | 445775 | 2478 | 0 | 37.23104908 | -121.6970462 | 2022-09-13 04:20:57 | Santa Clara, California, US | |
3766462 | 3766462 | 2022-09-11 | US | California | Santa Clara | 6085 | 445759 | 2478 | 0 | 37.23104908 | -121.6970462 | 2022-09-12 04:20:58 | Santa Clara, California, US | |
3825037 | 3825037 | 2022-09-10 | US | California | Santa Clara | 6085 | 445747 | 2478 | 0 | 37.23104908 | -121.6970462 | 2022-09-11 04:20:50 | Santa Clara, California, US | |
963494 | 963494 | 2022-09-09 | US | California | Santa Clara | 6085 | 445734 | 2478 | 0 | 37.23104908 | -121.6970462 | 2022-09-10 04:21:10 | Santa Clara, California, US | |
3429519 | 3429519 | 2022-07-14 | US | California | Kern | 6029 | 263145 | 2478 | 0 | 35.34329425 | -118.7277796 | 2022-07-15 04:20:53 | Kern, California, US | |
3110039 | 3110039 | 2022-07-13 | US | California | Kern | 6029 | 263145 | 2478 | 0 | 35.34329425 | -118.7277796 | 2022-07-14 04:20:57 | Kern, California, US | |
630462 | 630462 | 2022-07-12 | US | California | Kern | 6029 | 263145 | 2478 | 0 | 35.34329425 | -118.7277796 | 2022-07-13 04:20:58 | Kern, California, US | |
1212106 | 1212106 | 2022-07-11 | US | California | Kern | 6029 | 261393 | 2478 | 0 | 35.34329425 | -118.7277796 | 2022-07-12 04:20:51 | Kern, California, US | |
1211852 | 1211852 | 2022-07-11 | Spain | Extremadura | 290792 | 2478 | 0 | 39.4937 | -6.0679 | 2022-07-12 04:20:51 | Extremadura, Spain | |||
1211765 | 1211765 | 2022-07-11 | Russia | Kemerovo Oblast | 166609 | 2478 | 0 | 54.5335781 | 87.342861 | 2022-07-12 04:20:51 | Kemerovo Oblast, Russia | |||
2789588 | 2789588 | 2022-07-10 | US | California | Kern | 6029 | 261393 | 2478 | 0 | 35.34329425 | -118.7277796 | 2022-07-11 04:20:46 | Kern, California, US | |
2789334 | 2789334 | 2022-07-10 | Spain | Extremadura | 290792 | 2478 | 0 | 39.4937 | -6.0679 | 2022-07-11 04:20:46 | Extremadura, Spain | |||
142541 | 142541 | 2022-07-09 | US | California | Kern | 6029 | 261393 | 2478 | 0 | 35.34329425 | -118.7277796 | 2022-07-10 04:20:54 | Kern, California, US | |
142287 | 142287 | 2022-07-09 | Spain | Extremadura | 290792 | 2478 | 0 | 39.4937 | -6.0679 | 2022-07-10 04:20:54 | Extremadura, Spain | |||
1417641 | 1417641 | 2022-07-08 | US | California | Kern | 6029 | 261393 | 2478 | 0 | 35.34329425 | -118.7277796 | 2022-07-09 04:20:59 | Kern, California, US | |
1417387 | 1417387 | 2022-07-08 | Spain | Extremadura | 290792 | 2478 | 0 | 39.4937 | -6.0679 | 2022-07-09 04:20:59 | Extremadura, Spain | |||
973504 | 973504 | 2022-06-01 | US | Oklahoma | Oklahoma | 40109 | 201227 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-06-02 05:20:39 | Oklahoma, Oklahoma, US | |
231811 | 231811 | 2022-05-31 | US | Oklahoma | Oklahoma | 40109 | 201227 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-06-01 04:20:55 | Oklahoma, Oklahoma, US | |
3188576 | 3188576 | 2022-05-30 | US | Oklahoma | Oklahoma | 40109 | 201227 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-31 04:20:51 | Oklahoma, Oklahoma, US | |
3200725 | 3200725 | 2022-05-29 | US | Oklahoma | Oklahoma | 40109 | 201227 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-30 04:20:50 | Oklahoma, Oklahoma, US | |
2727603 | 2727603 | 2022-05-28 | US | Oklahoma | Oklahoma | 40109 | 201227 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-29 04:20:53 | Oklahoma, Oklahoma, US | |
1316784 | 1316784 | 2022-05-27 | US | Oklahoma | Oklahoma | 40109 | 201227 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-28 04:21:07 | Oklahoma, Oklahoma, US | |
1852576 | 1852576 | 2022-05-26 | US | Oklahoma | Oklahoma | 40109 | 201227 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-27 04:20:56 | Oklahoma, Oklahoma, US | |
2050452 | 2050452 | 2022-05-25 | US | Oklahoma | Oklahoma | 40109 | 200640 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-26 04:20:50 | Oklahoma, Oklahoma, US | |
3001890 | 3001890 | 2022-05-24 | US | Oklahoma | Oklahoma | 40109 | 200640 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-25 04:20:56 | Oklahoma, Oklahoma, US | |
2999528 | 2999528 | 2022-05-24 | Russia | Kursk Oblast | 118053 | 2478 | 0 | 51.6568453 | 36.4852695 | 2022-05-25 04:20:56 | Kursk Oblast, Russia | |||
3595611 | 3595611 | 2022-05-23 | US | Oklahoma | Oklahoma | 40109 | 200640 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-24 04:20:57 | Oklahoma, Oklahoma, US | |
3593249 | 3593249 | 2022-05-23 | Russia | Kursk Oblast | 118020 | 2478 | 0 | 51.6568453 | 36.4852695 | 2022-05-24 04:20:57 | Kursk Oblast, Russia | |||
624463 | 624463 | 2022-05-22 | US | Oklahoma | Oklahoma | 40109 | 200640 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-26 04:20:50 | Oklahoma, Oklahoma, US | |
1112159 | 1112159 | 2022-05-21 | US | Oklahoma | Oklahoma | 40109 | 200640 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-22 04:20:52 | Oklahoma, Oklahoma, US | |
1171783 | 1171783 | 2022-05-20 | US | Oklahoma | Oklahoma | 40109 | 200640 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-21 04:20:58 | Oklahoma, Oklahoma, US | |
3898546 | 3898546 | 2022-05-19 | US | Oklahoma | Oklahoma | 40109 | 200640 | 2478 | 0 | 35.55140095 | -97.40716948 | 2022-05-20 04:20:57 | Oklahoma, Oklahoma, US | |
223568 | 223568 | 2022-05-09 | US | Maryland | Baltimore | 24005 | 134900 | 2478 | 0 | 39.45784712 | -76.62911955 | 2022-05-10 04:20:50 | Baltimore, Maryland, US | |
2332953 | 2332953 | 2022-05-08 | US | Maryland | Baltimore | 24005 | 134682 | 2478 | 0 | 39.45784712 | -76.62911955 | 2022-05-09 04:20:54 | Baltimore, Maryland, US | |
361915 | 361915 | 2022-05-07 | US | Maryland | Baltimore | 24005 | 134682 | 2478 | 0 | 39.45784712 | -76.62911955 | 2022-05-08 04:20:49 | Baltimore, Maryland, US | |
1399266 | 1399266 | 2022-05-06 | US | Maryland | Baltimore | 24005 | 134682 | 2478 | 0 | 39.45784712 | -76.62911955 | 2022-05-07 04:21:09 | Baltimore, Maryland, US | |
694604 | 694604 | 2022-03-17 | Russia | Khanty-Mansi Autonomous Okrug | 203523 | 2478 | 0 | 61.0259025 | 69.0982628 | 2022-03-18 04:20:55 | Khanty-Mansi Autonomous Okrug, Russia | |||
3719908 | 3719908 | 2022-02-21 | US | Minnesota | Hennepin | 27053 | 291774 | 2478 | 0 | 45.00761521 | -93.47694895 | 2022-02-22 04:21:01 | Hennepin, Minnesota, US | |
3913742 | 3913742 | 2022-02-20 | US | Minnesota | Hennepin | 27053 | 291774 | 2478 | 0 | 45.00761521 | -93.47694895 | 2022-02-21 04:21:05 | Hennepin, Minnesota, US | |
3877300 | 3877300 | 2022-02-19 | US | Minnesota | Hennepin | 27053 | 291774 | 2478 | 0 | 45.00761521 | -93.47694895 | 2022-02-20 04:21:00 | Hennepin, Minnesota, US | |
3857556 | 3857556 | 2022-02-18 | US | Minnesota | Hennepin | 27053 | 291774 | 2478 | 0 | 45.00761521 | -93.47694895 | 2022-02-19 04:21:11 | Hennepin, Minnesota, US | |
186327 | 186327 | 2022-02-13 | Russia | Tver Oblast | 127406 | 2478 | 0 | 57.1134475 | 35.174442799999994 | 2022-02-14 04:20:51 | Tver Oblast, Russia | |||
2329828 | 2329828 | 2022-02-04 | US | Ohio | Franklin | 39049 | 281107 | 2478 | 0 | 39.96995815 | -83.01115755 | 2022-02-05 04:21:05 | Franklin, Ohio, US | |
1215758 | 1215758 | 2022-01-08 | Russia | Astrakhan Oblast | 82313 | 2478 | 0 | 47.1878186 | 47.608851 | 2022-01-09 04:21:46 | Astrakhan Oblast, Russia | |||
1702528 | 1702528 | 2022-01-03 | US | New Jersey | Ocean | 34029 | 124679 | 2478 | 0 | 39.8895449 | -74.28089251 | 2022-01-04 04:22:17 | Ocean, New Jersey, US | |
3521611 | 3521611 | 2022-01-02 | US | New Jersey | Ocean | 34029 | 123626 | 2478 | 0 | 39.8895449 | -74.28089251 | 2022-01-03 02:22:25 | Ocean, New Jersey, US | |
2169741 | 2169741 | 2022-01-01 | US | New Jersey | Ocean | 34029 | 122148 | 2478 | 0 | 39.8895449 | -74.28089251 | 2022-01-02 04:20:52 | Ocean, New Jersey, US | |
1432769 | 1432769 | 2021-12-28 | Russia | Ivanovo Oblast | 67500 | 2478 | 0 | 56.9167446 | 41.43521370000001 | 2021-12-29 03:21:43 | Ivanovo Oblast, Russia | |||
730859 | 730859 | 2021-12-27 | Sweden | Vastra Gotaland | 216761 | 2478 | 0 | 58.2528 | 13.0596 | 2021-12-28 04:21:47 | Vastra Gotaland, Sweden | |||
2112031 | 2112031 | 2021-12-26 | Sweden | Vastra Gotaland | 216761 | 2478 | 0 | 58.2528 | 13.0596 | 2021-12-27 04:21:58 | Vastra Gotaland, Sweden | |||
3605403 | 3605403 | 2021-12-25 | Sweden | Vastra Gotaland | 216761 | 2478 | 0 | 58.2528 | 13.0596 | 2021-12-26 04:21:50 | Vastra Gotaland, Sweden | |||
2963721 | 2963721 | 2021-12-24 | Sweden | Vastra Gotaland | 216761 | 2478 | 0 | 58.2528 | 13.0596 | 2021-12-25 04:21:37 | Vastra Gotaland, Sweden | |||
3816753 | 3816753 | 2021-12-23 | Sweden | Vastra Gotaland | 216761 | 2478 | 0 | 58.2528 | 13.0596 | 2021-12-24 04:21:34 | Vastra Gotaland, Sweden | |||
654329 | 654329 | 2021-10-22 | Syria | 40922 | 2478 | 0 | 34.802075 | 38.99681500000001 | 2021-10-23 04:21:32 | Syria | ||||
2134477 | 2134477 | 2021-10-01 | US | Ohio | Cuyahoga | 39035 | 138279 | 2478 | 0 | 41.424119 | -81.65918339 | 2021-10-02 04:21:25 | Cuyahoga, Ohio, US | |
642187 | 642187 | 2021-09-07 | Russia | Stavropol Krai | 77720 | 2478 | 0 | 44.86325770000001 | 43.4406913 | 2021-09-08 04:21:31 | Stavropol Krai, Russia | |||
1775398 | 1775398 | 2021-08-30 | Japan | Tokyo | 344624 | 2478 | 0 | 35.711343 | 139.446921 | 2021-08-31 04:21:46 | Tokyo, Japan | |||
3165314 | 3165314 | 2021-08-23 | Albania | 139721 | 2478 | 0 | 41.1533 | 20.1683 | 2021-08-24 04:21:19 | Albania | ||||
2175241 | 2175241 | 2021-08-22 | Albania | 139324 | 2478 | 0 | 41.1533 | 20.1683 | 2021-08-23 04:21:27 | Albania | ||||
3555705 | 3555705 | 2021-08-21 | Kyrgyzstan | 173676 | 2478 | 0 | 41.20438 | 74.766098 | 2021-08-22 04:21:29 | Kyrgyzstan | ||||
3469225 | 3469225 | 2021-08-03 | US | Illinois | Unassigned | 90017 | 61 | 2478 | 0 | 42.36542373 | 0.0 | 2021-08-04 04:21:25 | Unassigned, Illinois, US | |
2947431 | 2947431 | 2021-07-16 | Mexico | Aguascalientes | 27052 | 2478 | 0 | 24574 | 21.8853 | -102.2916 | 2021-07-17 04:22:22 | Aguascalientes, Mexico | ||
296087 | 296087 | 2021-07-15 | Mexico | Aguascalientes | 27011 | 2478 | 0 | 24533 | 21.8853 | -102.2916 | 2021-07-16 04:21:22 | Aguascalientes, Mexico | ||
3632032 | 3632032 | 2021-07-14 | Mexico | Aguascalientes | 26966 | 2478 | 0 | 24488 | 21.8853 | -102.2916 | 2021-07-15 04:21:48 | Aguascalientes, Mexico | ||
578907 | 578907 | 2021-07-13 | Mexico | Aguascalientes | 26937 | 2478 | 0 | 24459 | 21.8853 | -102.2916 | 2021-07-14 04:21:35 | Aguascalientes, Mexico | ||
1448671 | 1448671 | 2021-06-03 | Mexico | Durango | 34284 | 2478 | 0 | 31806 | 24.5593 | -104.6588 | 2021-06-04 04:23:37 | Durango, Mexico | ||
20348 | 20348 | 2021-05-28 | Italy | Abruzzo | 73917 | 2478 | 65935 | 5504 | 42.35122196 | 13.39843823 | 2021-05-29 04:20:41 | Abruzzo, Italy | ||
1980712 | 1980712 | 2021-03-25 | Mexico | Quintana Roo | 21051 | 2478 | 0 | 18573 | 19.1817 | -88.4791 | 2021-03-26 05:26:55 | Quintana Roo, Mexico | ||
1802302 | 1802302 | 2021-03-23 | West Bank and Gaza | 228044 | 2478 | 201675 | 23891 | 31.9522 | 35.2332 | 2021-03-24 05:25:40 | West Bank and Gaza | |||
793491 | 793491 | 2021-02-04 | US | Texas | Hidalgo | 48215 | 74521 | 2478 | 0 | 64373 | 26.39418217 | -98.18299696 | 2021-02-05 05:22:38 | Hidalgo, Texas, US |
3505517 | 3505517 | 2021-01-17 | US | New Jersey | Essex | 34013 | 59127 | 2478 | 0 | 56649 | 40.78681335 | -74.24657979 | 2021-01-18 05:22:34 | Essex, New Jersey, US |
190193 | 190193 | 2021-01-11 | Netherlands | Noord-Brabant | 135913 | 2478 | 0 | 134827 | 51.561174 | 5.184942 | 2021-01-12 05:22:15 | Noord-Brabant, Netherlands | ||
2919180 | 2919180 | 2020-11-04 | Italy | Veneto | 65531 | 2478 | 25517 | 37536 | 45.43490485 | 12.33845213 | 2020-11-05 06:05:03 | Veneto, Italy | ||
1479654 | 1479654 | 2020-08-21 | Mexico | Sonora | 20537 | 2478 | 17064 | 995 | 29.2972 | -110.3309 | 2020-08-22 04:27:49 | Sonora, Mexico | ||
2807957 | 2807957 | 2020-08-02 | Peru | Loreto | 11741 | 2478 | 0 | 9263 | -4.124847 | -74.424115 | 2020-08-03 04:34:35 | Loreto, Peru |
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]);