johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
84 rows where deaths = 2073 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 19
- US 29
- Colombia 21
- Italy 5
- Russia 5
- Netherlands 4
- Canada 2
- Japan 2
- Malaysia 2
- Mexico 2
- Spain 2
- Ukraine 2
- Brazil 1
- Germany 1
- India 1
- Korea, South 1
- Kyrgyzstan 1
- Peru 1
- Sri Lanka 1
- United Arab Emirates 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310542 | 310542 | 2022-12-13 | US | Pennsylvania | Bucks | 42017 | 149017 | 2073 | 0 | 40.33682119 | -75.10836643 | 2022-12-14 04:21:04 | Bucks, Pennsylvania, US | |
1151603 | 1151603 | 2022-12-12 | US | Pennsylvania | Bucks | 42017 | 149017 | 2073 | 0 | 40.33682119 | -75.10836643 | 2022-12-13 04:21:01 | Bucks, Pennsylvania, US | |
871457 | 871457 | 2022-12-11 | US | Pennsylvania | Bucks | 42017 | 149017 | 2073 | 0 | 40.33682119 | -75.10836643 | 2022-12-12 04:21:01 | Bucks, Pennsylvania, US | |
259987 | 259987 | 2022-12-10 | US | Pennsylvania | Bucks | 42017 | 149017 | 2073 | 0 | 40.33682119 | -75.10836643 | 2022-12-11 04:20:50 | Bucks, Pennsylvania, US | |
3938701 | 3938701 | 2022-12-09 | US | Pennsylvania | Bucks | 42017 | 149017 | 2073 | 0 | 40.33682119 | -75.10836643 | 2022-12-10 04:21:02 | Bucks, Pennsylvania, US | |
3380033 | 3380033 | 2022-12-08 | US | Pennsylvania | Bucks | 42017 | 149017 | 2073 | 0 | 40.33682119 | -75.10836643 | 2022-12-09 04:21:05 | Bucks, Pennsylvania, US | |
1987304 | 1987304 | 2022-12-07 | US | Pennsylvania | Bucks | 42017 | 149017 | 2073 | 0 | 40.33682119 | -75.10836643 | 2022-12-08 04:21:07 | Bucks, Pennsylvania, US | |
3460222 | 3460222 | 2022-11-21 | Malaysia | Perak | 235971 | 2073 | 0 | 4.5921 | 101.0901 | 2022-11-22 04:20:47 | Perak, Malaysia | |||
2395532 | 2395532 | 2022-09-12 | US | Florida | Pasco | 12101 | 149775 | 2073 | 0 | 28.30810945 | -82.40227529 | 2022-09-13 04:20:57 | Pasco, Florida, US | |
3766610 | 3766610 | 2022-09-11 | US | Florida | Pasco | 12101 | 149775 | 2073 | 0 | 28.30810945 | -82.40227529 | 2022-09-12 04:20:58 | Pasco, Florida, US | |
3825185 | 3825185 | 2022-09-10 | US | Florida | Pasco | 12101 | 149775 | 2073 | 0 | 28.30810945 | -82.40227529 | 2022-09-11 04:20:50 | Pasco, Florida, US | |
963642 | 963642 | 2022-09-09 | US | Florida | Pasco | 12101 | 149775 | 2073 | 0 | 28.30810945 | -82.40227529 | 2022-09-10 04:21:10 | Pasco, Florida, US | |
254044 | 254044 | 2022-09-08 | US | Florida | Pasco | 12101 | 148255 | 2073 | 0 | 28.30810945 | -82.40227529 | 2022-09-09 04:21:11 | Pasco, Florida, US | |
3745842 | 3745842 | 2022-09-07 | US | Florida | Pasco | 12101 | 148255 | 2073 | 0 | 28.30810945 | -82.40227529 | 2022-09-08 04:21:02 | Pasco, Florida, US | |
115482 | 115482 | 2022-09-06 | US | Florida | Pasco | 12101 | 148255 | 2073 | 0 | 28.30810945 | -82.40227529 | 2022-09-07 04:20:59 | Pasco, Florida, US | |
2712953 | 2712953 | 2022-09-03 | Italy | Umbria | 366468 | 2073 | 0 | 43.10675841 | 12.38824698 | 2022-09-04 04:21:22 | Umbria, Italy | |||
2346469 | 2346469 | 2022-08-31 | US | Texas | Cameron | 48061 | 122535 | 2073 | 0 | 26.14524221 | -97.48140372 | 2022-09-01 04:21:03 | Cameron, Texas, US | |
2343267 | 2343267 | 2022-08-31 | Colombia | Quindio | 72636 | 2073 | 0 | 4.461 | -75.6674 | 2022-09-01 04:21:03 | Quindio, Colombia | |||
3776949 | 3776949 | 2022-08-30 | US | Texas | Cameron | 48061 | 122383 | 2073 | 0 | 26.14524221 | -97.48140372 | 2022-08-31 04:20:57 | Cameron, Texas, US | |
3773747 | 3773747 | 2022-08-30 | Colombia | Quindio | 72636 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-31 04:20:57 | Quindio, Colombia | |||
1680343 | 1680343 | 2022-08-29 | Colombia | Quindio | 72636 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-30 04:21:03 | Quindio, Colombia | |||
1876827 | 1876827 | 2022-08-28 | Colombia | Quindio | 72636 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-29 04:21:06 | Quindio, Colombia | |||
2095954 | 2095954 | 2022-08-27 | Colombia | Quindio | 72636 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-28 04:21:02 | Quindio, Colombia | |||
1531769 | 1531769 | 2022-08-26 | Colombia | Quindio | 72636 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-27 04:20:57 | Quindio, Colombia | |||
2828656 | 2828656 | 2022-08-25 | Colombia | Quindio | 72636 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-26 04:21:02 | Quindio, Colombia | |||
2323189 | 2323189 | 2022-08-24 | Colombia | Quindio | 72491 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-25 04:21:13 | Quindio, Colombia | |||
1250598 | 1250598 | 2022-08-23 | Colombia | Quindio | 72491 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-24 04:20:46 | Quindio, Colombia | |||
2852702 | 2852702 | 2022-08-22 | Colombia | Quindio | 72491 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-23 04:20:56 | Quindio, Colombia | |||
2402674 | 2402674 | 2022-08-21 | Colombia | Quindio | 72491 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-22 04:20:38 | Quindio, Colombia | |||
3797752 | 3797752 | 2022-08-20 | Colombia | Quindio | 72491 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-21 04:20:44 | Quindio, Colombia | |||
2363338 | 2363338 | 2022-08-19 | Colombia | Quindio | 72491 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-20 04:21:01 | Quindio, Colombia | |||
1161009 | 1161009 | 2022-08-18 | Colombia | Quindio | 72491 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-19 04:20:54 | Quindio, Colombia | |||
3950333 | 3950333 | 2022-08-17 | Colombia | Quindio | 72409 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-18 04:21:11 | Quindio, Colombia | |||
990835 | 990835 | 2022-08-16 | Colombia | Quindio | 72409 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-17 04:20:59 | Quindio, Colombia | |||
2493874 | 2493874 | 2022-08-15 | Colombia | Quindio | 72409 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-16 04:20:58 | Quindio, Colombia | |||
3647424 | 3647424 | 2022-08-14 | Colombia | Quindio | 72409 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-15 04:20:59 | Quindio, Colombia | |||
1971087 | 1971087 | 2022-08-13 | US | Ohio | Montgomery | 39113 | 142774 | 2073 | 0 | 39.75394919 | -84.29050975 | 2022-08-14 04:20:55 | Montgomery, Ohio, US | |
1968430 | 1968430 | 2022-08-13 | Colombia | Quindio | 72409 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-14 04:20:55 | Quindio, Colombia | |||
2888239 | 2888239 | 2022-08-12 | Colombia | Quindio | 72409 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-13 04:20:52 | Quindio, Colombia | |||
3907844 | 3907844 | 2022-08-11 | Colombia | Quindio | 72409 | 2073 | 0 | 4.461 | -75.6674 | 2022-08-12 04:20:54 | Quindio, Colombia | |||
1421099 | 1421099 | 2022-06-08 | Japan | Hokkaido | 366641 | 2073 | 0 | 43.385711 | 142.552318 | 2022-06-09 04:20:54 | Hokkaido, Japan | |||
3887604 | 3887604 | 2022-06-06 | Japan | Aichi | 549018 | 2073 | 0 | 35.035551 | 137.211621 | 2022-06-07 04:21:08 | Aichi, Japan | |||
1328718 | 1328718 | 2022-04-26 | US | Ohio | Hamilton | 39061 | 188603 | 2073 | 0 | 39.19673558 | -84.54502924 | 2022-04-27 04:20:52 | Hamilton, Ohio, US | |
3724672 | 3724672 | 2022-04-25 | US | Ohio | Hamilton | 39061 | 188603 | 2073 | 0 | 39.19673558 | -84.54502924 | 2022-04-26 04:20:51 | Hamilton, Ohio, US | |
2031240 | 2031240 | 2022-04-24 | US | Ohio | Hamilton | 39061 | 188603 | 2073 | 0 | 39.19673558 | -84.54502924 | 2022-04-25 04:20:56 | Hamilton, Ohio, US | |
748815 | 748815 | 2022-04-23 | US | Ohio | Hamilton | 39061 | 188603 | 2073 | 0 | 39.19673558 | -84.54502924 | 2022-04-24 04:20:56 | Hamilton, Ohio, US | |
3439300 | 3439300 | 2022-04-22 | US | Ohio | Hamilton | 39061 | 188603 | 2073 | 0 | 39.19673558 | -84.54502924 | 2022-04-23 04:20:50 | Hamilton, Ohio, US | |
2894885 | 2894885 | 2022-04-21 | US | Ohio | Hamilton | 39061 | 188603 | 2073 | 0 | 39.19673558 | -84.54502924 | 2022-04-22 04:20:45 | Hamilton, Ohio, US | |
2309757 | 2309757 | 2022-04-20 | US | Ohio | Hamilton | 39061 | 188020 | 2073 | 0 | 39.19673558 | -84.54502924 | 2022-04-21 04:20:46 | Hamilton, Ohio, US | |
574797 | 574797 | 2022-02-25 | Italy | Calabria | 211668 | 2073 | 0 | 38.90597598 | 16.59440194 | 2022-02-26 04:21:12 | Calabria, Italy | |||
3718091 | 3718091 | 2022-02-21 | Germany | Schleswig-Holstein | 292007 | 2073 | 0 | 54.2194 | 9.6961 | 2022-02-22 04:21:01 | Schleswig-Holstein, Germany | |||
1464388 | 1464388 | 2022-02-10 | Spain | Murcia | 351816 | 2073 | 0 | 37.9922 | -1.1307 | 2022-02-11 04:21:09 | Murcia, Spain | |||
3613191 | 3613191 | 2022-01-12 | Netherlands | Limburg | 244111 | 2073 | 0 | 51.209227 | 5.93387 | 2022-01-13 08:00:09 | Limburg, Netherlands | |||
1113716 | 1113716 | 2022-01-11 | Netherlands | Limburg | 242610 | 2073 | 0 | 51.209227 | 5.93387 | 2022-01-12 04:21:44 | Limburg, Netherlands | |||
552496 | 552496 | 2021-12-08 | US | Minnesota | Hennepin | 27053 | 185057 | 2073 | 0 | 45.00761521 | -93.47694895 | 2021-12-09 04:22:49 | Hennepin, Minnesota, US | |
758584 | 758584 | 2021-11-26 | Russia | Tver Oblast | 86892 | 2073 | 0 | 57.1134475 | 35.174442799999994 | 2021-11-27 04:22:45 | Tver Oblast, Russia | |||
904381 | 904381 | 2021-11-24 | Russia | Ivanovo Oblast | 60790 | 2073 | 0 | 56.9167446 | 41.43521370000001 | 2021-11-25 04:22:33 | Ivanovo Oblast, Russia | |||
3342700 | 3342700 | 2021-11-16 | Mexico | Campeche | 24075 | 2073 | 0 | 19.8301 | -90.5349 | 2021-11-17 04:21:48 | Campeche, Mexico | |||
2287536 | 2287536 | 2021-11-15 | Mexico | Campeche | 24073 | 2073 | 0 | 19.8301 | -90.5349 | 2021-11-16 04:21:10 | Campeche, Mexico | |||
2124032 | 2124032 | 2021-10-21 | Spain | Asturias | 71165 | 2073 | 0 | 43.3614 | -5.8593 | 2021-10-22 04:21:14 | Asturias, Spain | |||
443901 | 443901 | 2021-10-20 | US | California | Fresno | 6019 | 146298 | 2073 | 0 | 36.75733899 | -119.6466953 | 2021-10-21 04:21:18 | Fresno, California, US | |
2943617 | 2943617 | 2021-10-15 | Russia | Vladimir Oblast | 57913 | 2073 | 0 | 56.0503336 | 40.656163299999996 | 2021-10-16 04:21:15 | Vladimir Oblast, Russia | |||
2459029 | 2459029 | 2021-10-06 | Russia | Orenburg Oblast | 79519 | 2073 | 0 | 52.02692620000001 | 54.7276647 | 2021-10-07 04:21:36 | Orenburg Oblast, Russia | |||
20003 | 20003 | 2021-09-18 | United Arab Emirates | 732299 | 2073 | 0 | 23.424076 | 53.847818000000004 | 2021-09-19 04:21:34 | United Arab Emirates | ||||
3974687 | 3974687 | 2021-09-03 | Netherlands | Gelderland | 215831 | 2073 | 0 | 52.061738 | 5.939114 | 2021-09-04 04:21:28 | Gelderland, Netherlands | |||
2071589 | 2071589 | 2021-08-31 | Malaysia | W.P. Kuala Lumpur | 173238 | 2073 | 156059 | 15106 | 3.139 | 101.6869 | 2021-09-01 04:21:38 | W.P. Kuala Lumpur, Malaysia | ||
1330300 | 1330300 | 2021-07-24 | Korea, South | 188848 | 2073 | 166375 | 20400 | 35.90775700000001 | 127.766922 | 2021-07-25 04:22:12 | Korea, South | |||
778417 | 778417 | 2021-07-08 | Kyrgyzstan | 135739 | 2073 | 115513 | 18153 | 41.20438 | 74.766098 | 2021-07-09 04:21:21 | Kyrgyzstan | |||
1736813 | 1736813 | 2021-06-12 | Sri Lanka | 221277 | 2073 | 186516 | 32688 | 7.873054 | 80.77179699999998 | 2021-06-13 04:22:44 | Sri Lanka | |||
526480 | 526480 | 2021-06-09 | Ukraine | Ivano-Frankivsk Oblast | 86453 | 2073 | 83029 | 1351 | 48.9226 | 24.7111 | 2021-06-10 04:23:17 | Ivano-Frankivsk Oblast, Ukraine | ||
2761579 | 2761579 | 2021-05-03 | US | Connecticut | New Haven | 9009 | 89913 | 2073 | 0 | 41.4080325 | -72.93620426 | 2021-05-04 04:20:34 | New Haven, Connecticut, US | |
2760880 | 2760880 | 2021-05-03 | India | Odisha | 471536 | 2073 | 404063 | 65400 | 20.505428 | 84.418059 | 2021-05-04 04:20:34 | Odisha, India | ||
2450954 | 2450954 | 2021-05-02 | Russia | Altai Krai | 49815 | 2073 | 44732 | 3010 | 52.6932243 | 82.69314240000001 | 2021-05-03 04:20:39 | Altai Krai, Russia | ||
3393158 | 3393158 | 2021-04-28 | Canada | Alberta | 186679 | 2073 | 163668 | 20938 | 53.9333 | -116.5765 | 2021-04-29 04:20:55 | Alberta, Canada | ||
355071 | 355071 | 2021-03-11 | US | Puerto Rico | Unassigned | 72999 | 2947 | 2073 | 0 | 18.459681 | -67.336525 | 2021-03-12 05:26:50 | Unassigned, Puerto Rico, US | |
2215295 | 2215295 | 2021-01-30 | Ukraine | Lviv Oblast | 71041 | 2073 | 60814 | 8154 | 49.8397 | 24.0297 | 2021-01-31 05:22:42 | Lviv Oblast, Ukraine | ||
821565 | 821565 | 2020-11-19 | Italy | Toscana | 88677 | 2073 | 32480 | 54124 | 43.76923077 | 11.25588885 | 2020-11-20 05:26:28 | Toscana, Italy | ||
3338723 | 3338723 | 2020-11-17 | Netherlands | Zuid-Holland | 131954 | 2073 | 0 | 129352 | 51.937835 | 4.462114 | 2020-11-18 05:40:31 | Zuid-Holland, Netherlands | ||
2653517 | 2653517 | 2020-09-23 | Brazil | Piaui | 92801 | 2073 | 89431 | 0 | -7.7183 | -42.7289 | 2020-09-24 04:23:00 | Piaui, Brazil | ||
1928636 | 1928636 | 2020-07-30 | Italy | Veneto | 20003 | 2073 | 17039 | 891 | 45.43490485 | 12.33845213 | 2020-07-31 04:35:18 | Veneto, Italy | ||
2958804 | 2958804 | 2020-07-29 | Italy | Veneto | 19891 | 2073 | 17034 | 784 | 45.43490485 | 12.33845213 | 2020-07-30 04:35:05 | Veneto, Italy | ||
3682660 | 3682660 | 2020-06-18 | Peru | Lambayeque | 11883 | 2073 | 0 | 9810 | -6.3530489999999995 | -79.824113 | 2020-06-19 04:33:17 | Lambayeque, Peru | ||
875639 | 875639 | 2020-05-24 | Canada | Ontario | 26251 | 2073 | 19477 | 5239 | 51.2538 | -85.3232 | 2020-05-25 02:32:44 | Ontario, Canada | ||
267127 | 267127 | 2020-05-21 | US | New York | Nassau | 36059 | 39487 | 2073 | 0 | 37414 | 40.74066522 | -73.58941873 | 2020-05-22 02:36:51 | Nassau, New York, US |
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]);