johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
97 rows where deaths = 1879 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2758497 | 2758497 | 2022-10-18 | US | Maryland | Baltimore City | 24510 | 138006 | 1879 | 0 | 39.30211911 | -76.61151012 | 2022-10-19 04:22:26 | Baltimore City, Maryland, US | |
2160277 | 2160277 | 2022-10-16 | US | Florida | Unassigned | 90012 | 3258 | 1879 | 0 | 30.86747479 | 0.0 | 2022-10-17 04:20:31 | Unassigned, Florida, US | |
516474 | 516474 | 2022-10-15 | US | Florida | Unassigned | 90012 | 3258 | 1879 | 0 | 30.86747479 | 0.0 | 2022-10-16 04:22:39 | Unassigned, Florida, US | |
2033531 | 2033531 | 2022-10-14 | US | Florida | Unassigned | 90012 | 3258 | 1879 | 0 | 30.86747479 | 0.0 | 2022-10-15 04:22:00 | Unassigned, Florida, US | |
1624055 | 1624055 | 2022-09-22 | Chile | Antofagasta | 164918 | 1879 | 0 | -23.6509 | -70.3975 | 2022-09-23 04:23:13 | Antofagasta, Chile | |||
1370259 | 1370259 | 2022-09-21 | Chile | Antofagasta | 164812 | 1879 | 0 | -23.6509 | -70.3975 | 2022-09-22 04:22:56 | Antofagasta, Chile | |||
2016489 | 2016489 | 2022-09-20 | Chile | Antofagasta | 164785 | 1879 | 0 | -23.6509 | -70.3975 | 2022-09-21 04:23:22 | Antofagasta, Chile | |||
1405031 | 1405031 | 2022-08-02 | Japan | Chiba | 636314 | 1879 | 0 | 35.510141 | 140.198917 | 2022-08-03 04:20:59 | Chiba, Japan | |||
2335639 | 2335639 | 2022-07-27 | Russia | Pskov Oblast | 111818 | 1879 | 0 | 57.5358729 | 28.8586826 | 2022-07-28 04:20:56 | Pskov Oblast, Russia | |||
1487829 | 1487829 | 2022-07-26 | Russia | Pskov Oblast | 111783 | 1879 | 0 | 57.5358729 | 28.8586826 | 2022-07-27 04:21:04 | Pskov Oblast, Russia | |||
3507594 | 3507594 | 2022-06-05 | Russia | Kabardino-Balkarian Republic | 61964 | 1879 | 0 | 43.4806048 | 43.5978976 | 2022-06-06 04:20:57 | Kabardino-Balkarian Republic, Russia | |||
3527671 | 3527671 | 2022-06-04 | Russia | Kabardino-Balkarian Republic | 61957 | 1879 | 0 | 43.4806048 | 43.5978976 | 2022-06-05 04:20:55 | Kabardino-Balkarian Republic, Russia | |||
3133757 | 3133757 | 2022-06-03 | Russia | Kabardino-Balkarian Republic | 61949 | 1879 | 0 | 43.4806048 | 43.5978976 | 2022-06-04 04:20:58 | Kabardino-Balkarian Republic, Russia | |||
2444361 | 2444361 | 2022-04-13 | US | Massachusetts | Norfolk | 25021 | 133092 | 1879 | 0 | 42.16073095 | -71.20530408 | 2022-04-13 23:21:06 | Norfolk, Massachusetts, US | |
1950118 | 1950118 | 2022-04-12 | US | Massachusetts | Norfolk | 25021 | 132859 | 1879 | 0 | 42.16073095 | -71.20530408 | 2022-04-13 04:21:03 | Norfolk, Massachusetts, US | |
3208947 | 3208947 | 2022-04-11 | US | Pennsylvania | Lancaster | 42071 | 120987 | 1879 | 0 | 40.03904563 | -76.24770128 | 2022-04-12 04:20:49 | Lancaster, Pennsylvania, US | |
1578833 | 1578833 | 2022-04-10 | US | Pennsylvania | Lancaster | 42071 | 120978 | 1879 | 0 | 40.03904563 | -76.24770128 | 2022-04-11 04:21:02 | Lancaster, Pennsylvania, US | |
1576212 | 1576212 | 2022-04-10 | Malaysia | Perak | 194926 | 1879 | 0 | 4.5921 | 101.0901 | 2022-04-11 04:21:02 | Perak, Malaysia | |||
2803430 | 2803430 | 2022-04-06 | US | Pennsylvania | Bucks | 42017 | 123129 | 1879 | 0 | 40.33682119 | -75.10836643 | 2022-04-07 04:20:53 | Bucks, Pennsylvania, US | |
3022515 | 3022515 | 2022-03-23 | Russia | Primorsky Krai | 168167 | 1879 | 0 | 45.0819456 | 134.726645 | 2022-03-24 04:20:43 | Primorsky Krai, Russia | |||
459625 | 459625 | 2022-02-02 | Russia | Sakha (Yakutiya) Republic | 106058 | 1879 | 0 | 66.941626 | 129.642371 | 2022-02-03 04:21:21 | Sakha (Yakutiya) Republic, Russia | |||
3810144 | 3810144 | 2022-01-28 | Russia | Kemerovo Oblast | 92917 | 1879 | 0 | 54.53357809999999 | 87.342861 | 2022-01-29 04:21:10 | Kemerovo Oblast, Russia | |||
1141105 | 1141105 | 2022-01-23 | Russia | Belgorod Oblast | 84706 | 1879 | 0 | 50.7080119 | 37.5837615 | 2022-01-24 04:21:12 | Belgorod Oblast, Russia | |||
3230018 | 3230018 | 2022-01-19 | US | Wisconsin | Milwaukee | 55079 | 250909 | 1879 | 0 | 43.00486062 | -87.96733172 | 2022-01-20 04:21:07 | Milwaukee, Wisconsin, US | |
3464017 | 3464017 | 2022-01-18 | Colombia | Quindio | 65710 | 1879 | 0 | 4.461 | -75.6674 | 2022-01-19 04:21:23 | Quindio, Colombia | |||
1471956 | 1471956 | 2022-01-17 | Colombia | Quindio | 65255 | 1879 | 0 | 4.461 | -75.6674 | 2022-01-18 04:21:04 | Quindio, Colombia | |||
101502 | 101502 | 2022-01-14 | US | New Jersey | Monmouth | 34025 | 147301 | 1879 | 0 | 40.26549699 | -74.22240686 | 2022-01-15 04:21:07 | Monmouth, New Jersey, US | |
1117233 | 1117233 | 2022-01-11 | Ukraine | Sevastopol* | 53366 | 1879 | 0 | 44.6054 | 33.522 | 2022-01-12 04:21:44 | Sevastopol*, Ukraine | |||
1282257 | 1282257 | 2022-01-05 | Russia | Zabaykalsky Krai | 96507 | 1879 | 0 | 52.248521000000004 | 115.956325 | 2022-01-06 04:22:09 | Zabaykalsky Krai, Russia | |||
1258735 | 1258735 | 2021-12-18 | India | Puducherry | 129292 | 1879 | 0 | 11.882658000000001 | 78.86498 | 2021-12-19 04:21:11 | Puducherry, India | |||
2399031 | 2399031 | 2021-12-17 | Russia | Khanty-Mansi Autonomous Okrug | 93317 | 1879 | 0 | 61.0259025 | 69.0982628 | 2021-12-18 02:22:20 | Khanty-Mansi Autonomous Okrug, Russia | |||
2398763 | 2398763 | 2021-12-17 | India | Puducherry | 129285 | 1879 | 0 | 11.882658000000001 | 78.86498 | 2021-12-18 02:22:20 | Puducherry, India | |||
1716301 | 1716301 | 2021-12-16 | India | Puducherry | 129285 | 1879 | 0 | 11.882658000000001 | 78.86498 | 2021-12-17 04:22:14 | Puducherry, India | |||
2088526 | 2088526 | 2021-12-14 | US | California | Kern | 6029 | 160477 | 1879 | 0 | 35.34329425 | -118.72777959999999 | 2021-12-15 03:22:16 | Kern, California, US | |
1017979 | 1017979 | 2021-11-21 | Ukraine | Ternopil Oblast | 100132 | 1879 | 0 | 49.5535 | 25.5948 | 2021-11-22 04:22:20 | Ternopil Oblast, Ukraine | |||
726135 | 726135 | 2021-11-20 | Ukraine | Luhansk Oblast | 55504 | 1879 | 0 | 48.574 | 39.3078 | 2021-11-21 04:22:13 | Luhansk Oblast, Ukraine | |||
448943 | 448943 | 2021-11-17 | US | Maryland | Baltimore | 24005 | 78579 | 1879 | 0 | 39.45784712 | -76.62911955 | 2021-11-18 04:21:33 | Baltimore, Maryland, US | |
2290147 | 2290147 | 2021-11-15 | US | Pennsylvania | Montgomery | 42091 | 89124 | 1879 | 0 | 40.21053671 | -75.36652296 | 2021-11-16 04:21:10 | Montgomery, Pennsylvania, US | |
1325879 | 1325879 | 2021-11-14 | Ukraine | Zakarpattia Oblast | 74024 | 1879 | 0 | 48.6208 | 22.2879 | 2021-11-15 04:21:36 | Zakarpattia Oblast, Ukraine | |||
3121709 | 3121709 | 2021-11-05 | Russia | Ivanovo Oblast | 56470 | 1879 | 0 | 56.9167446 | 41.43521370000001 | 2021-11-06 04:21:51 | Ivanovo Oblast, Russia | |||
698681 | 698681 | 2021-11-04 | Senegal | 73931 | 1879 | 0 | 14.4974 | -14.4524 | 2021-11-05 04:21:54 | Senegal | ||||
276459 | 276459 | 2021-11-03 | Senegal | 73926 | 1879 | 0 | 14.4974 | -14.4524 | 2021-11-04 04:22:20 | Senegal | ||||
3794144 | 3794144 | 2021-10-25 | Russia | Smolensk Oblast | 58281 | 1879 | 0 | 55.03434960000001 | 33.0192065 | 2021-10-26 04:22:09 | Smolensk Oblast, Russia | |||
654186 | 654186 | 2021-10-22 | Russia | Astrakhan Oblast | 64032 | 1879 | 0 | 47.1878186 | 47.608851 | 2021-10-23 04:21:32 | Astrakhan Oblast, Russia | |||
1491981 | 1491981 | 2021-10-12 | US | Alabama | Jefferson | 1073 | 113810 | 1879 | 0 | 33.55554728 | -86.89506300000002 | 2021-10-13 04:20:51 | Jefferson, Alabama, US | |
1276009 | 1276009 | 2021-10-03 | US | Minnesota | Hennepin | 27053 | 145233 | 1879 | 0 | 45.00761521 | -93.47694895 | 2021-10-04 04:21:31 | Hennepin, Minnesota, US | |
3929762 | 3929762 | 2021-10-02 | US | Minnesota | Hennepin | 27053 | 145233 | 1879 | 0 | 45.00761521 | -93.47694895 | 2021-10-03 04:21:24 | Hennepin, Minnesota, US | |
2133742 | 2133742 | 2021-10-01 | US | Minnesota | Hennepin | 27053 | 145233 | 1879 | 0 | 45.00761521 | -93.47694895 | 2021-10-02 04:21:25 | Hennepin, Minnesota, US | |
2773242 | 2773242 | 2021-09-30 | Russia | Vologda Oblast | 68735 | 1879 | 0 | 60.0391461 | 43.1215213 | 2021-10-01 04:21:35 | Vologda Oblast, Russia | |||
1334361 | 1334361 | 2021-09-28 | Mexico | Colima | 31510 | 1879 | 0 | 19.1223 | -104.0072 | 2021-09-29 04:21:45 | Colima, Mexico | |||
2076184 | 2076184 | 2021-09-26 | Russia | Orenburg Oblast | 75960 | 1879 | 0 | 52.02692620000001 | 54.7276647 | 2021-09-27 04:21:16 | Orenburg Oblast, Russia | |||
601803 | 601803 | 2021-09-23 | Montenegro | 128377 | 1879 | 0 | 42.708678000000006 | 19.37439 | 2021-09-24 04:21:44 | Montenegro | ||||
1817006 | 1817006 | 2021-09-19 | US | New York | Erie | 36029 | 98475 | 1879 | 0 | 42.76249024 | -78.73063652 | 2021-09-20 04:21:22 | Erie, New York, US | |
1888622 | 1888622 | 2021-09-12 | Ukraine | Chernivtsi Oblast | 83704 | 1879 | 0 | 48.2917 | 25.9352 | 2021-09-13 04:21:15 | Chernivtsi Oblast, Ukraine | |||
2070892 | 2070892 | 2021-08-31 | US | Tennessee | Shelby | 47157 | 125568 | 1879 | 0 | 35.1864775 | -89.89692423 | 2021-09-01 04:21:38 | Shelby, Tennessee, US | |
2926830 | 2926830 | 2021-08-27 | Ukraine | Poltava Oblast | 78943 | 1879 | 0 | 49.5883 | 34.5514 | 2021-08-28 04:21:28 | Poltava Oblast, Ukraine | |||
2925452 | 2925452 | 2021-08-27 | US | New York | Richmond | 36085 | 81550 | 1879 | 0 | 40.58582155 | -74.14808598 | 2021-08-28 04:21:28 | Richmond, New York, US | |
1599844 | 1599844 | 2021-08-26 | Ukraine | Poltava Oblast | 78892 | 1879 | 0 | 49.5883 | 34.5514 | 2021-08-27 04:21:37 | Poltava Oblast, Ukraine | |||
1604311 | 1604311 | 2021-08-16 | Mexico | Chiapas | 17665 | 1879 | 0 | 16.7569 | -93.1292 | 2021-08-17 04:21:49 | Chiapas, Mexico | |||
3705855 | 3705855 | 2021-07-17 | Brazil | Amapa | 119716 | 1879 | 100791 | 17046 | 0.902 | -52.003 | 2021-07-18 04:22:07 | Amapa, Brazil | ||
3659815 | 3659815 | 2021-07-11 | Russia | Leningrad Oblast | 51192 | 1879 | 45627 | 3686 | 60.1853296 | 32.3925325 | 2021-07-12 04:21:34 | Leningrad Oblast, Russia | ||
781990 | 781990 | 2021-07-08 | Ukraine | Khmelnytskyi Oblast | 88990 | 1879 | 86812 | 299 | 49.423 | 26.9871 | 2021-07-09 04:21:21 | Khmelnytskyi Oblast, Ukraine | ||
1444212 | 1444212 | 2021-07-07 | Ukraine | Khmelnytskyi Oblast | 88974 | 1879 | 86756 | 339 | 49.423 | 26.9871 | 2021-07-08 04:21:26 | Khmelnytskyi Oblast, Ukraine | ||
2697317 | 2697317 | 2021-07-06 | Ukraine | Khmelnytskyi Oblast | 88964 | 1879 | 86639 | 446 | 49.423 | 26.9871 | 2021-07-07 04:21:20 | Khmelnytskyi Oblast, Ukraine | ||
2072009 | 2072009 | 2021-07-02 | Mexico | Nayarit | 12835 | 1879 | 0 | 10956 | 21.7514 | -104.8455 | 2021-07-03 04:21:37 | Nayarit, Mexico | ||
2765265 | 2765265 | 2021-07-01 | Syria | 25551 | 1879 | 21831 | 1841 | 34.802075 | 38.99681500000001 | 2021-07-02 04:21:47 | Syria | |||
2104284 | 2104284 | 2021-06-01 | Peru | Ayacucho | 28911 | 1879 | 0 | 27032 | -14.091648 | -74.08344 | 2021-06-02 04:24:34 | Ayacucho, Peru | ||
3958113 | 3958113 | 2021-05-11 | Ukraine | Donetsk Oblast | 84103 | 1879 | 69547 | 12677 | 48.0159 | 37.8028 | 2021-05-12 04:21:29 | Donetsk Oblast, Ukraine | ||
2824392 | 2824392 | 2021-05-10 | Ukraine | Donetsk Oblast | 83778 | 1879 | 69220 | 12679 | 48.0159 | 37.8028 | 2021-05-11 04:20:41 | Donetsk Oblast, Ukraine | ||
2820823 | 2820823 | 2021-05-10 | Korea, South | 128283 | 1879 | 118717 | 7687 | 35.90775700000001 | 127.766922 | 2021-05-11 04:20:41 | Korea, South | |||
1428724 | 1428724 | 2021-05-09 | Ukraine | Donetsk Oblast | 83535 | 1879 | 68689 | 12967 | 48.0159 | 37.8028 | 2021-05-10 04:20:38 | Donetsk Oblast, Ukraine | ||
1555592 | 1555592 | 2021-05-08 | Ukraine | Donetsk Oblast | 83134 | 1879 | 68055 | 13200 | 48.0159 | 37.8028 | 2021-05-09 04:20:35 | Donetsk Oblast, Ukraine | ||
1554142 | 1554142 | 2021-05-08 | US | New Jersey | Passaic | 34031 | 72152 | 1879 | 0 | 41.03238628 | -74.29954144 | 2021-05-09 04:20:35 | Passaic, New Jersey, US | |
3702152 | 3702152 | 2021-04-27 | Japan | Tokyo | 136408 | 1879 | 127860 | 6669 | 35.711343 | 139.446921 | 2021-04-28 04:20:32 | Tokyo, Japan | ||
1570744 | 1570744 | 2021-04-22 | US | Pennsylvania | Allegheny | 42003 | 95635 | 1879 | 0 | 40.46809875 | -79.98167747 | 2021-04-23 04:20:52 | Allegheny, Pennsylvania, US | |
3244965 | 3244965 | 2021-04-21 | US | Pennsylvania | Allegheny | 42003 | 95284 | 1879 | 0 | 40.46809875 | -79.98167747 | 2021-04-22 04:20:53 | Allegheny, Pennsylvania, US | |
2985433 | 2985433 | 2021-04-10 | US | New Jersey | Union | 34039 | 66826 | 1879 | 0 | 40.65835409 | -74.30680092 | 2021-04-11 04:20:56 | Union, New Jersey, US | |
1881108 | 1881108 | 2021-03-26 | Netherlands | Gelderland | 137365 | 1879 | 0 | 135261 | 52.061738 | 5.939114 | 2021-03-27 05:25:04 | Gelderland, Netherlands | ||
1980738 | 1980738 | 2021-03-25 | Netherlands | Gelderland | 136381 | 1879 | 0 | 134304 | 52.061738 | 5.939114 | 2021-03-26 05:26:55 | Gelderland, Netherlands | ||
1800228 | 1800228 | 2021-03-23 | US | Massachusetts | Essex | 25009 | 87487 | 1879 | 0 | 42.6687626 | -70.94687179 | 2021-03-24 05:25:40 | Essex, Massachusetts, US | |
1837776 | 1837776 | 2021-03-12 | Colombia | Cordoba | 39429 | 1879 | 36382 | 1168 | 8.0493 | -75.574 | 2021-03-13 05:25:15 | Cordoba, Colombia | ||
2359518 | 2359518 | 2021-03-08 | Kenya | 109164 | 1879 | 87623 | 19662 | -0.0236 | 37.9062 | 2021-03-09 05:28:19 | Kenya | |||
2482114 | 2482114 | 2021-01-28 | Pakistan | Khyber Pakhtunkhwa | 66451 | 1879 | 61656 | 2916 | 34.485332 | 72.09169 | 2021-01-29 05:22:23 | Khyber Pakhtunkhwa, Pakistan | ||
190175 | 190175 | 2021-01-11 | Mexico | Zacatecas | 22442 | 1879 | 0 | 20563 | 22.7709 | -102.5832 | 2021-01-12 05:22:15 | Zacatecas, Mexico | ||
766269 | 766269 | 2020-12-29 | India | Jammu and Kashmir | 120527 | 1879 | 115560 | 3088 | 33.75943 | 76.612638 | 2020-12-30 05:22:34 | Jammu and Kashmir, India | ||
3761860 | 3761860 | 2020-12-28 | Slovakia | 244297 | 1879 | 120410 | 122008 | 48.669 | 19.699 | 2020-12-29 05:22:37 | Slovakia | |||
2880200 | 2880200 | 2020-11-15 | Italy | Toscana | 79403 | 1879 | 25216 | 52308 | 43.76923077 | 11.25588885 | 2020-11-16 05:25:57 | Toscana, Italy | ||
376167 | 376167 | 2020-11-06 | Italy | Liguria | 34452 | 1879 | 20881 | 11692 | 44.41149315 | 8.9326992 | 2020-11-07 05:24:52 | Liguria, Italy | ||
2500700 | 2500700 | 2020-11-03 | US | Pennsylvania | Philadelphia | 42101 | 46158 | 1879 | 0 | 44279 | 40.00338507 | -75.1379271 | 2020-11-04 05:25:09 | Philadelphia, Pennsylvania, US |
210319 | 210319 | 2020-10-29 | Mexico | Chihuahua | 17609 | 1879 | 13348 | 2382 | 28.633000000000006 | -106.0691 | 2020-10-30 04:24:49 | Chihuahua, Mexico | ||
3389305 | 3389305 | 2020-10-02 | Germany | Nordrhein-Westfalen | 71357 | 1879 | 62530 | 6947 | 51.4332 | 7.6616 | 2020-10-03 04:23:40 | Nordrhein-Westfalen, Germany | ||
3316303 | 3316303 | 2020-09-22 | Mexico | Hidalgo | 12136 | 1879 | 9674 | 583 | 20.0911 | -98.7624 | 2020-09-23 04:23:00 | Hidalgo, Mexico | ||
2958741 | 2958741 | 2020-07-29 | Mexico | Sonora | 17259 | 1879 | 14424 | 956 | 29.2972 | -110.3309 | 2020-07-30 04:35:05 | Sonora, Mexico | ||
2564150 | 2564150 | 2020-07-24 | Philippines | 76444 | 1879 | 24502 | 50063 | 12.879721 | 121.774017 | 2020-07-25 04:47:39 | Philippines | |||
413861 | 413861 | 2020-07-05 | US | Massachusetts | Middlesex | 25017 | 24153 | 1879 | 0 | 22274 | 42.48607732 | -71.39049229 | 2020-07-06 04:33:57 | Middlesex, Massachusetts, US |
303058 | 303058 | 2020-07-01 | Peru | La Libertad | 10148 | 1879 | 0 | 8269 | -7.92139 | -78.370238 | 2020-07-02 04:33:46 | La Libertad, Peru | ||
1789765 | 1789765 | 2020-05-29 | US | New York | Suffolk | 36103 | 39445 | 1879 | 0 | 37566 | 40.88320119 | -72.8012172 | 2020-05-30 02:32:48 | Suffolk, 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]);