johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
107 rows where deaths = 2059 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328724 | 328724 | 2022-12-27 | US | Georgia | Gwinnett | 13135 | 249596 | 2059 | 0 | 33.96044201 | -84.02137802 | 2022-12-28 04:21:04 | Gwinnett, Georgia, US | |
218797 | 218797 | 2022-12-26 | US | Georgia | Gwinnett | 13135 | 249596 | 2059 | 0 | 33.96044201 | -84.02137802 | 2022-12-27 04:21:07 | Gwinnett, Georgia, US | |
3223254 | 3223254 | 2022-12-25 | US | Georgia | Gwinnett | 13135 | 249596 | 2059 | 0 | 33.96044201 | -84.02137802 | 2022-12-26 04:21:06 | Gwinnett, Georgia, US | |
3222499 | 3222499 | 2022-12-25 | Malaysia | Pulau Pinang | 306672 | 2059 | 0 | 5.4141 | 100.3288 | 2022-12-26 04:21:06 | Pulau Pinang, Malaysia | |||
1019168 | 1019168 | 2022-12-24 | US | Georgia | Gwinnett | 13135 | 249596 | 2059 | 0 | 33.96044201 | -84.02137802 | 2022-12-25 04:21:04 | Gwinnett, Georgia, US | |
1018413 | 1018413 | 2022-12-24 | Malaysia | Pulau Pinang | 306616 | 2059 | 0 | 5.4141 | 100.3288 | 2022-12-25 04:21:04 | Pulau Pinang, Malaysia | |||
691191 | 691191 | 2022-12-23 | US | Georgia | Gwinnett | 13135 | 249596 | 2059 | 0 | 33.96044201 | -84.02137802 | 2022-12-24 04:21:02 | Gwinnett, Georgia, US | |
690436 | 690436 | 2022-12-23 | Malaysia | Pulau Pinang | 306575 | 2059 | 0 | 5.4141 | 100.3288 | 2022-12-24 04:21:02 | Pulau Pinang, Malaysia | |||
2180401 | 2180401 | 2022-12-22 | US | Georgia | Gwinnett | 13135 | 249596 | 2059 | 0 | 33.96044201 | -84.02137802 | 2022-12-23 04:21:04 | Gwinnett, Georgia, US | |
452205 | 452205 | 2022-12-21 | US | Georgia | Gwinnett | 13135 | 249596 | 2059 | 0 | 33.96044201 | -84.02137802 | 2022-12-22 04:20:56 | Gwinnett, Georgia, US | |
1965116 | 1965116 | 2022-11-30 | US | California | Alameda | 6001 | 378659 | 2059 | 0 | 37.64629437 | -121.8929271 | 2022-12-01 04:21:03 | Alameda, California, US | |
2557130 | 2557130 | 2022-11-29 | US | California | Alameda | 6001 | 378620 | 2059 | 0 | 37.64629437 | -121.8929271 | 2022-11-30 04:21:07 | Alameda, California, US | |
1240204 | 1240204 | 2022-11-28 | US | California | Alameda | 6001 | 377158 | 2059 | 0 | 37.64629437 | -121.8929271 | 2022-11-29 04:21:05 | Alameda, California, US | |
3552192 | 3552192 | 2022-11-27 | US | California | Alameda | 6001 | 377077 | 2059 | 0 | 37.64629437 | -121.8929271 | 2022-11-28 04:21:02 | Alameda, California, US | |
2100672 | 2100672 | 2022-11-26 | US | California | Alameda | 6001 | 377052 | 2059 | 0 | 37.64629437 | -121.8929271 | 2022-11-27 04:21:05 | Alameda, California, US | |
488163 | 488163 | 2022-11-25 | US | California | Alameda | 6001 | 377026 | 2059 | 0 | 37.64629437 | -121.8929271 | 2022-11-26 04:21:11 | Alameda, California, US | |
3523992 | 3523992 | 2022-11-24 | US | California | Alameda | 6001 | 377005 | 2059 | 0 | 37.64629437 | -121.8929271 | 2022-11-25 04:21:06 | Alameda, California, US | |
1622931 | 1622931 | 2022-11-22 | US | Pennsylvania | Bucks | 42017 | 147334 | 2059 | 0 | 40.33682119 | -75.10836643 | 2022-11-23 04:21:06 | Bucks, Pennsylvania, US | |
3462819 | 3462819 | 2022-11-21 | US | Pennsylvania | Bucks | 42017 | 147334 | 2059 | 0 | 40.33682119 | -75.10836643 | 2022-11-22 04:20:47 | Bucks, Pennsylvania, US | |
1643004 | 1643004 | 2022-11-20 | US | Pennsylvania | Bucks | 42017 | 147334 | 2059 | 0 | 40.33682119 | -75.10836643 | 2022-11-21 04:21:05 | Bucks, Pennsylvania, US | |
2066561 | 2066561 | 2022-11-19 | US | Pennsylvania | Bucks | 42017 | 147334 | 2059 | 0 | 40.33682119 | -75.10836643 | 2022-11-20 04:21:08 | Bucks, Pennsylvania, US | |
1757955 | 1757955 | 2022-11-18 | US | Pennsylvania | Bucks | 42017 | 147334 | 2059 | 0 | 40.33682119 | -75.10836643 | 2022-11-19 04:21:14 | Bucks, Pennsylvania, US | |
3028948 | 3028948 | 2022-11-17 | US | Pennsylvania | Bucks | 42017 | 147334 | 2059 | 0 | 40.33682119 | -75.10836643 | 2022-11-18 04:21:15 | Bucks, Pennsylvania, US | |
2488659 | 2488659 | 2022-11-16 | US | Pennsylvania | Bucks | 42017 | 147334 | 2059 | 0 | 40.33682119 | -75.10836643 | 2022-11-17 04:21:11 | Bucks, Pennsylvania, US | |
2506120 | 2506120 | 2022-11-10 | Malaysia | Perak | 234857 | 2059 | 0 | 4.5921 | 101.0901 | 2022-11-11 04:21:22 | Perak, Malaysia | |||
1099726 | 1099726 | 2022-08-03 | US | Massachusetts | Suffolk | 25025 | 243240 | 2059 | 0 | 42.3279514 | -71.07850442 | 2022-08-04 04:20:58 | Suffolk, Massachusetts, US | |
1406651 | 1406651 | 2022-08-02 | US | Massachusetts | Suffolk | 25025 | 243240 | 2059 | 0 | 42.3279514 | -71.07850442 | 2022-08-03 04:20:59 | Suffolk, Massachusetts, US | |
3618689 | 3618689 | 2022-08-01 | US | Massachusetts | Suffolk | 25025 | 243240 | 2059 | 0 | 42.3279514 | -71.07850442 | 2022-08-02 04:20:53 | Suffolk, Massachusetts, US | |
3873169 | 3873169 | 2022-07-31 | US | Massachusetts | Suffolk | 25025 | 243240 | 2059 | 0 | 42.3279514 | -71.07850442 | 2022-08-01 04:21:03 | Suffolk, Massachusetts, US | |
675923 | 675923 | 2022-07-30 | US | Massachusetts | Suffolk | 25025 | 243240 | 2059 | 0 | 42.3279514 | -71.07850442 | 2022-07-31 04:21:02 | Suffolk, Massachusetts, US | |
1785122 | 1785122 | 2022-07-29 | US | Massachusetts | Suffolk | 25025 | 243240 | 2059 | 0 | 42.3279514 | -71.07850442 | 2022-07-30 04:20:42 | Suffolk, Massachusetts, US | |
1067485 | 1067485 | 2022-07-28 | US | Massachusetts | Suffolk | 25025 | 243240 | 2059 | 0 | 42.3279514 | -71.07850442 | 2022-07-29 04:20:45 | Suffolk, Massachusetts, US | |
3109326 | 3109326 | 2022-07-13 | Colombia | Quindio | 71276 | 2059 | 0 | 4.461 | -75.6674 | 2022-07-14 04:20:57 | Quindio, Colombia | |||
629749 | 629749 | 2022-07-12 | Colombia | Quindio | 71276 | 2059 | 0 | 4.461 | -75.6674 | 2022-07-13 04:20:58 | Quindio, Colombia | |||
1211393 | 1211393 | 2022-07-11 | Colombia | Quindio | 71276 | 2059 | 0 | 4.461 | -75.6674 | 2022-07-12 04:20:51 | Quindio, Colombia | |||
2788875 | 2788875 | 2022-07-10 | Colombia | Quindio | 71276 | 2059 | 0 | 4.461 | -75.6674 | 2022-07-11 04:20:46 | Quindio, Colombia | |||
141828 | 141828 | 2022-07-09 | Colombia | Quindio | 71276 | 2059 | 0 | 4.461 | -75.6674 | 2022-07-10 04:20:54 | Quindio, Colombia | |||
1416928 | 1416928 | 2022-07-08 | Colombia | Quindio | 71276 | 2059 | 0 | 4.461 | -75.6674 | 2022-07-09 04:20:59 | Quindio, Colombia | |||
2740853 | 2740853 | 2022-07-07 | Colombia | Quindio | 71276 | 2059 | 0 | 4.461 | -75.6674 | 2022-07-08 04:20:56 | Quindio, Colombia | |||
3580213 | 3580213 | 2022-06-02 | US | Maryland | Montgomery | 24031 | 188985 | 2059 | 0 | 39.13676329 | -77.20358245 | 2022-06-03 04:20:58 | Montgomery, Maryland, US | |
2725014 | 2725014 | 2022-05-28 | Japan | Hokkaido | 355731 | 2059 | 0 | 43.385711 | 142.552318 | 2022-05-29 04:20:53 | Hokkaido, Japan | |||
1849976 | 1849976 | 2022-05-26 | Japan | Aichi | 535610 | 2059 | 0 | 35.035551 | 137.211621 | 2022-05-27 04:20:56 | Aichi, Japan | |||
1437303 | 1437303 | 2022-03-28 | US | Florida | Marion | 12083 | 83336 | 2059 | 0 | 29.21227113 | -82.05803627 | 2022-03-29 04:20:46 | Marion, Florida, US | |
876984 | 876984 | 2022-03-27 | US | Florida | Marion | 12083 | 83336 | 2059 | 0 | 29.21227113 | -82.05803627 | 2022-03-28 04:20:33 | Marion, Florida, US | |
2164267 | 2164267 | 2022-03-26 | US | Florida | Marion | 12083 | 83336 | 2059 | 0 | 29.21227113 | -82.05803627 | 2022-03-27 04:20:47 | Marion, Florida, US | |
1721203 | 1721203 | 2022-03-25 | US | Florida | Marion | 12083 | 83336 | 2059 | 0 | 29.21227113 | -82.05803627 | 2022-03-26 04:20:23 | Marion, Florida, US | |
1468820 | 1468820 | 2022-03-24 | US | Florida | Marion | 12083 | 83213 | 2059 | 0 | 29.21227113 | -82.05803627 | 2022-03-25 04:20:46 | Marion, Florida, US | |
3022994 | 3022994 | 2022-03-23 | US | Florida | Marion | 12083 | 83213 | 2059 | 0 | 29.21227113 | -82.05803627 | 2022-03-24 04:20:43 | Marion, Florida, US | |
1905916 | 1905916 | 2022-03-22 | US | Florida | Marion | 12083 | 83213 | 2059 | 0 | 29.21227113 | -82.05803627 | 2022-03-23 04:20:48 | Marion, Florida, US | |
338407 | 338407 | 2022-03-18 | US | Ohio | Hamilton | 39061 | 186696 | 2059 | 0 | 39.19673558 | -84.54502924 | 2022-03-19 04:20:47 | Hamilton, Ohio, US | |
3628203 | 3628203 | 2022-03-13 | Russia | Sakha (Yakutiya) Republic | 166355 | 2059 | 0 | 66.941626 | 129.642371 | 2022-03-14 04:20:46 | Sakha (Yakutiya) Republic, Russia | |||
3074158 | 3074158 | 2022-02-09 | Mongolia | 863372 | 2059 | 0 | 46.8625 | 103.8467 | 2022-02-10 04:21:14 | Mongolia | ||||
70805 | 70805 | 2022-02-07 | Brazil | Amapa | 157127 | 2059 | 0 | 0.902 | -52.003 | 2022-02-08 04:21:15 | Amapa, Brazil | |||
2012578 | 2012578 | 2022-02-06 | Estonia | 380946 | 2059 | 0 | 58.5953 | 25.0136 | 2022-02-07 04:21:05 | Estonia | ||||
1293977 | 1293977 | 2022-02-05 | India | Manipur | 134661 | 2059 | 0 | 24.738975 | 93.882541 | 2022-02-06 04:21:00 | Manipur, India | |||
1779471 | 1779471 | 2022-01-27 | Mexico | Colima | 42898 | 2059 | 0 | 19.1223 | -104.0072 | 2022-01-28 04:21:09 | Colima, Mexico | |||
2052149 | 2052149 | 2022-01-25 | Russia | Yaroslavl Oblast | 90997 | 2059 | 0 | 57.77819760000001 | 39.002109499999996 | 2022-01-26 04:21:07 | Yaroslavl Oblast, Russia | |||
1140809 | 1140809 | 2022-01-23 | Germany | Hamburg | 193422 | 2059 | 0 | 53.5511 | 9.9937 | 2022-01-24 04:21:12 | Hamburg, Germany | |||
2832727 | 2832727 | 2022-01-22 | Germany | Hamburg | 193422 | 2059 | 0 | 53.5511 | 9.9937 | 2022-01-23 04:21:13 | Hamburg, Germany | |||
3424845 | 3424845 | 2022-01-21 | Germany | Hamburg | 193422 | 2059 | 0 | 53.5511 | 9.9937 | 2022-01-22 04:21:13 | Hamburg, Germany | |||
800609 | 800609 | 2021-12-22 | US | New Jersey | Passaic | 34031 | 91000 | 2059 | 0 | 41.03238628 | -74.29954144 | 2021-12-23 04:21:21 | Passaic, New Jersey, US | |
404028 | 404028 | 2021-12-07 | Brazil | Roraima | 128696 | 2059 | 0 | -2.7376 | -62.0751 | 2021-12-08 04:22:46 | Roraima, Brazil | |||
1148577 | 1148577 | 2021-12-01 | Ukraine | Zakarpattia Oblast | 80450 | 2059 | 0 | 48.6208 | 22.2879 | 2021-12-02 04:22:37 | Zakarpattia Oblast, Ukraine | |||
698484 | 698484 | 2021-11-04 | Mexico | Campeche | 23968 | 2059 | 0 | 19.8301 | -90.5349 | 2021-11-05 04:21:54 | Campeche, Mexico | |||
770462 | 770462 | 2021-10-23 | Montenegro | 140489 | 2059 | 0 | 42.708678000000006 | 19.37439 | 2021-10-24 04:21:22 | Montenegro | ||||
1909475 | 1909475 | 2021-10-17 | Russia | Vologda Oblast | 73555 | 2059 | 0 | 60.0391461 | 43.1215213 | 2021-10-18 04:21:10 | Vologda Oblast, Russia | |||
491619 | 491619 | 2021-10-14 | Jamaica | 86722 | 2059 | 0 | 18.1096 | -77.2975 | 2021-10-15 04:21:26 | Jamaica | ||||
3836117 | 3836117 | 2021-10-05 | Ukraine | Khmelnytskyi Oblast | 97237 | 2059 | 0 | 49.423 | 26.9871 | 2021-10-06 04:21:33 | Khmelnytskyi Oblast, Ukraine | |||
3555717 | 3555717 | 2021-08-21 | Malawi | 59399 | 2059 | 0 | -13.2543 | 34.3015 | 2021-08-22 04:21:29 | Malawi | ||||
511821 | 511821 | 2021-08-19 | Netherlands | Gelderland | 211997 | 2059 | 0 | 52.061738 | 5.939114 | 2021-08-20 04:21:33 | Gelderland, Netherlands | |||
650123 | 650123 | 2021-08-09 | Peru | Ayacucho | 32072 | 2059 | 0 | -14.091648000000001 | -74.08344 | 2021-08-10 04:21:27 | Ayacucho, Peru | |||
650043 | 650043 | 2021-08-09 | Mexico | Baja California Sur | 50816 | 2059 | 0 | 26.0444 | -111.6661 | 2021-08-10 04:21:27 | Baja California Sur, Mexico | |||
589785 | 589785 | 2021-08-08 | Peru | Ayacucho | 32072 | 2059 | 0 | -14.091648 | -74.08344 | 2021-08-09 04:21:24 | Ayacucho, Peru | |||
589705 | 589705 | 2021-08-08 | Mexico | Baja California Sur | 50789 | 2059 | 0 | 26.0444 | -111.6661 | 2021-08-09 04:21:24 | Baja California Sur, Mexico | |||
2203797 | 2203797 | 2021-08-07 | Peru | Ayacucho | 32072 | 2059 | 0 | -14.091648 | -74.08344 | 2021-08-08 04:21:33 | Ayacucho, Peru | |||
2203717 | 2203717 | 2021-08-07 | Mexico | Baja California Sur | 50736 | 2059 | 0 | 26.0444 | -111.6661 | 2021-08-08 04:21:33 | Baja California Sur, Mexico | |||
1117747 | 1117747 | 2021-08-06 | Peru | Ayacucho | 32072 | 2059 | 0 | -14.091648 | -74.08344 | 2021-08-07 04:21:30 | Ayacucho, Peru | |||
1378702 | 1378702 | 2021-07-25 | Russia | Chelyabinsk Oblast | 71526 | 2059 | 64664 | 4803 | 54.4223954 | 61.1865846 | 2021-07-26 04:21:28 | Chelyabinsk Oblast, Russia | ||
483643 | 483643 | 2021-07-19 | Korea, South | 180481 | 2059 | 160347 | 18075 | 35.90775700000001 | 127.766922 | 2021-07-20 04:21:48 | Korea, South | |||
1440638 | 1440638 | 2021-07-07 | Kuwait | 369227 | 2059 | 348850 | 18318 | 29.31166 | 47.481766 | 2021-07-08 04:21:26 | Kuwait | |||
1192368 | 1192368 | 2021-05-31 | Ukraine | Ivano-Frankivsk Oblast | 86188 | 2059 | 82675 | 1454 | 48.9226 | 24.7111 | 2021-06-01 04:23:09 | Ivano-Frankivsk Oblast, Ukraine | ||
3093045 | 3093045 | 2021-05-30 | Ukraine | Ivano-Frankivsk Oblast | 86165 | 2059 | 82651 | 1455 | 48.9226 | 24.7111 | 2021-05-31 03:08:59 | Ivano-Frankivsk Oblast, Ukraine | ||
888780 | 888780 | 2021-04-26 | US | Connecticut | New Haven | 9009 | 88766 | 2059 | 0 | 41.4080325 | -72.93620426 | 2021-04-27 04:20:52 | New Haven, Connecticut, US | |
1408806 | 1408806 | 2021-04-23 | Canada | Alberta | 178777 | 2059 | 157272 | 19446 | 53.9333 | -116.5765 | 2021-04-24 04:20:38 | Alberta, Canada | ||
1841742 | 1841742 | 2021-04-14 | Chile | Valparaiso | 75752 | 2059 | 69551 | 4142 | -33.0472 | -71.6127 | 2021-04-15 04:20:54 | Valparaiso, Chile | ||
2571476 | 2571476 | 2021-04-13 | Chile | Valparaiso | 75214 | 2059 | 68924 | 4231 | -33.0472 | -71.6127 | 2021-04-14 04:20:41 | Valparaiso, Chile | ||
36227 | 36227 | 2021-04-12 | Chile | Valparaiso | 74708 | 2059 | 68130 | 4519 | -33.0472 | -71.6127 | 2021-04-13 04:20:37 | Valparaiso, Chile | ||
605825 | 605825 | 2021-04-09 | Nigeria | 163652 | 2059 | 154073 | 7520 | 9.082 | 8.6753 | 2021-04-10 04:20:59 | Nigeria | |||
3003502 | 3003502 | 2021-04-06 | Russia | Irkutsk Oblast | 62572 | 2059 | 59636 | 877 | 56.6370122 | 104.719221 | 2021-04-07 04:20:53 | Irkutsk Oblast, Russia | ||
2057841 | 2057841 | 2021-03-15 | US | Missouri | St. Louis | 29189 | 90479 | 2059 | 0 | 38.63770039999999 | -90.4458375 | 2021-03-16 05:25:13 | St. Louis, Missouri, US | |
1734453 | 1734453 | 2021-03-14 | US | Missouri | St. Louis | 29189 | 90398 | 2059 | 0 | 38.63770039999999 | -90.4458375 | 2021-03-15 05:25:51 | St. Louis, Missouri, US | |
1582110 | 1582110 | 2021-03-13 | US | Missouri | St. Louis | 29189 | 90287 | 2059 | 0 | 38.63770039999999 | -90.4458375 | 2021-03-14 05:25:37 | St. Louis, Missouri, US | |
2362242 | 2362242 | 2021-03-08 | US | Puerto Rico | Unassigned | 72999 | 2941 | 2059 | 0 | 18.459681 | -67.336525 | 2021-03-09 05:28:19 | Unassigned, Puerto Rico, US | |
57580 | 57580 | 2021-03-07 | US | Puerto Rico | Unassigned | 72999 | 2941 | 2059 | 0 | 18.459681 | -67.336525 | 2021-03-08 05:24:48 | Unassigned, Puerto Rico, US | |
3670397 | 3670397 | 2021-03-06 | US | Puerto Rico | Unassigned | 72999 | 2941 | 2059 | 0 | 882 | 18.459681 | -67.336525 | 2021-03-07 05:21:54 | Unassigned, Puerto Rico, US |
2485598 | 2485598 | 2021-01-28 | Ukraine | Lviv Oblast | 70245 | 2059 | 59448 | 8738 | 49.8397 | 24.0297 | 2021-01-29 05:22:23 | Lviv Oblast, Ukraine | ||
908895 | 908895 | 2021-01-19 | US | Florida | Palm Beach | 12099 | 98692 | 2059 | 0 | 96633 | 26.64676272 | -80.46536002 | 2021-01-20 05:21:54 | Palm Beach, Florida, US |
2864811 | 2864811 | 2021-01-06 | Mexico | Queretaro | 33920 | 2059 | 0 | 31861 | 20.5888 | -100.3899 | 2021-01-07 05:22:03 | Queretaro, Mexico | ||
3149587 | 3149587 | 2020-12-16 | Italy | Sicilia | 81256 | 2059 | 44021 | 35176 | 38.11569725 | 13.362356699999998 | 2020-12-17 05:28:12 | Sicilia, Italy | ||
1632408 | 1632408 | 2020-12-05 | Mexico | Yucatan | 24577 | 2059 | 0 | 22518 | 20.7099 | -89.0943 | 2020-12-06 05:26:18 | Yucatan, Mexico |
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]);