johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
113 rows where deaths = 1899 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2179355 | 2179355 | 2022-12-22 | Chile | Coquimbo | 201676 | 1899 | 0 | -29.959 | -71.3389 | 2022-12-23 04:21:04 | Coquimbo, Chile | |||
1986224 | 1986224 | 2022-12-07 | US | Maryland | Baltimore City | 24510 | 141969 | 1899 | 0 | 39.30211911 | -76.61151012 | 2022-12-08 04:21:07 | Baltimore City, Maryland, US | |
3715747 | 3715747 | 2022-12-06 | US | Maryland | Baltimore City | 24510 | 141844 | 1899 | 0 | 39.30211911 | -76.61151012 | 2022-12-07 04:20:58 | Baltimore City, Maryland, US | |
540924 | 540924 | 2022-10-26 | US | New Jersey | Camden | 34007 | 155815 | 1899 | 0 | 39.80343818 | -74.96388753 | 2022-10-27 04:22:01 | Camden, New Jersey, US | |
1832325 | 1832325 | 2022-10-25 | US | New Jersey | Camden | 34007 | 155719 | 1899 | 0 | 39.80343818 | -74.96388753 | 2022-10-26 04:22:19 | Camden, New Jersey, US | |
796586 | 796586 | 2022-10-24 | US | New Jersey | Camden | 34007 | 155618 | 1899 | 0 | 39.80343818 | -74.96388753 | 2022-10-25 04:21:53 | Camden, New Jersey, US | |
3279041 | 3279041 | 2022-10-23 | US | New Jersey | Camden | 34007 | 155553 | 1899 | 0 | 39.80343818 | -74.96388753 | 2022-10-24 04:22:29 | Camden, New Jersey, US | |
2270079 | 2270079 | 2022-10-22 | US | New Jersey | Camden | 34007 | 155493 | 1899 | 0 | 39.80343818 | -74.96388753 | 2022-10-23 04:22:46 | Camden, New Jersey, US | |
1594379 | 1594379 | 2022-10-21 | US | New Jersey | Camden | 34007 | 155427 | 1899 | 0 | 39.80343818 | -74.96388753 | 2022-10-22 04:22:53 | Camden, New Jersey, US | |
2274095 | 2274095 | 2022-10-20 | US | New Jersey | Camden | 34007 | 155323 | 1899 | 0 | 39.80343818 | -74.96388753 | 2022-10-21 04:22:23 | Camden, New Jersey, US | |
3215413 | 3215413 | 2022-10-12 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-13 04:22:39 | Lake, Indiana, US | |
3251262 | 3251262 | 2022-10-11 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-12 04:22:51 | Lake, Indiana, US | |
2968521 | 2968521 | 2022-10-10 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-11 04:23:05 | Lake, Indiana, US | |
3098557 | 3098557 | 2022-10-09 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-10 04:22:32 | Lake, Indiana, US | |
4003782 | 4003782 | 2022-10-08 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-09 04:21:16 | Lake, Indiana, US | |
397379 | 397379 | 2022-10-07 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-08 04:22:56 | Lake, Indiana, US | |
2530496 | 2530496 | 2022-10-06 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-07 04:23:08 | Lake, Indiana, US | |
1811890 | 1811890 | 2022-10-05 | US | Indiana | Lake | 18089 | 124916 | 1899 | 0 | 41.41874274 | -87.38277575 | 2022-10-06 04:21:22 | Lake, Indiana, US | |
2016931 | 2016931 | 2022-09-20 | Russia | Kabardino-Balkarian Republic | 70535 | 1899 | 0 | 43.4806048 | 43.5978976 | 2022-09-21 04:23:22 | Kabardino-Balkarian Republic, Russia | |||
3766122 | 3766122 | 2022-09-11 | Russia | Pskov Oblast | 118128 | 1899 | 0 | 57.5358729 | 28.8586826 | 2022-09-12 04:20:58 | Pskov Oblast, Russia | |||
3824697 | 3824697 | 2022-09-10 | Russia | Pskov Oblast | 117894 | 1899 | 0 | 57.5358729 | 28.8586826 | 2022-09-11 04:20:50 | Pskov Oblast, Russia | |||
1405824 | 1405824 | 2022-08-02 | US | Georgia | Cobb | 13067 | 194768 | 1899 | 0 | 33.94243204 | -84.5761255 | 2022-08-03 04:20:59 | Cobb, Georgia, US | |
3617862 | 3617862 | 2022-08-01 | US | Georgia | Cobb | 13067 | 194768 | 1899 | 0 | 33.94243204 | -84.5761255 | 2022-08-02 04:20:53 | Cobb, Georgia, US | |
3872342 | 3872342 | 2022-07-31 | US | Georgia | Cobb | 13067 | 194768 | 1899 | 0 | 33.94243204 | -84.5761255 | 2022-08-01 04:21:03 | Cobb, Georgia, US | |
675096 | 675096 | 2022-07-30 | US | Georgia | Cobb | 13067 | 194768 | 1899 | 0 | 33.94243204 | -84.5761255 | 2022-07-31 04:21:02 | Cobb, Georgia, US | |
1784295 | 1784295 | 2022-07-29 | US | Georgia | Cobb | 13067 | 194768 | 1899 | 0 | 33.94243204 | -84.5761255 | 2022-07-30 04:20:42 | Cobb, Georgia, US | |
1066658 | 1066658 | 2022-07-28 | US | Georgia | Cobb | 13067 | 194768 | 1899 | 0 | 33.94243204 | -84.5761255 | 2022-07-29 04:20:45 | Cobb, Georgia, US | |
2336177 | 2336177 | 2022-07-27 | US | Georgia | Cobb | 13067 | 194768 | 1899 | 0 | 33.94243204 | -84.5761255 | 2022-07-28 04:20:56 | Cobb, Georgia, US | |
2741552 | 2741552 | 2022-07-07 | US | California | Alameda | 6001 | 330321 | 1899 | 0 | 37.64629437 | -121.8929271 | 2022-07-08 04:20:56 | Alameda, California, US | |
1200347 | 1200347 | 2022-07-06 | US | California | Alameda | 6001 | 328177 | 1899 | 0 | 37.64629437 | -121.8929271 | 2022-07-07 04:20:55 | Alameda, California, US | |
3967090 | 3967090 | 2022-07-05 | US | California | Alameda | 6001 | 328121 | 1899 | 0 | 37.64629437 | -121.8929271 | 2022-07-06 04:20:58 | Alameda, California, US | |
3265703 | 3265703 | 2022-05-04 | Russia | Kaliningrad Oblast | 168119 | 1899 | 0 | 54.7293041 | 21.1489473 | 2022-05-05 04:20:55 | Kaliningrad Oblast, Russia | |||
3350894 | 3350894 | 2022-04-01 | Russia | Primorsky Krai | 170380 | 1899 | 0 | 45.0819456 | 134.726645 | 2022-04-02 04:20:47 | Primorsky Krai, Russia | |||
1547968 | 1547968 | 2022-03-07 | Japan | Hyogo | 282960 | 1899 | 0 | 35.039913 | 134.828057 | 2022-03-08 04:20:54 | Hyogo, Japan | |||
2732699 | 2732699 | 2022-02-27 | Angola | 98701 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-28 04:21:05 | Angola | ||||
3045852 | 3045852 | 2022-02-26 | Angola | 98701 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-27 04:21:04 | Angola | ||||
574507 | 574507 | 2022-02-25 | Angola | 98701 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-26 04:21:12 | Angola | ||||
1511083 | 1511083 | 2022-02-24 | Angola | 98701 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-25 04:21:11 | Angola | ||||
1057524 | 1057524 | 2022-02-23 | Angola | 98698 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-24 04:21:14 | Angola | ||||
2446447 | 2446447 | 2022-02-22 | Angola | 98671 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-23 04:21:09 | Angola | ||||
3717860 | 3717860 | 2022-02-21 | Angola | 98658 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-22 04:21:01 | Angola | ||||
3911694 | 3911694 | 2022-02-20 | Angola | 98638 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-21 04:21:05 | Angola | ||||
3875252 | 3875252 | 2022-02-19 | Angola | 98617 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-20 04:21:00 | Angola | ||||
3855508 | 3855508 | 2022-02-18 | Angola | 98605 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-19 04:21:11 | Angola | ||||
1297727 | 1297727 | 2022-02-17 | Angola | 98585 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-18 04:21:04 | Angola | ||||
3820113 | 3820113 | 2022-02-16 | Angola | 98568 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-17 04:20:56 | Angola | ||||
3671327 | 3671327 | 2022-02-15 | Angola | 98555 | 1899 | 0 | -11.2027 | 17.8739 | 2022-02-16 04:21:10 | Angola | ||||
1364954 | 1364954 | 2022-02-08 | US | Oklahoma | Tulsa | 40143 | 161879 | 1899 | 0 | 36.11939621 | -95.94013939 | 2022-02-09 04:21:04 | Tulsa, Oklahoma, US | |
73692 | 73692 | 2022-02-07 | US | Oklahoma | Tulsa | 40143 | 161879 | 1899 | 0 | 36.11939621 | -95.94013939 | 2022-02-08 04:21:15 | Tulsa, Oklahoma, US | |
70803 | 70803 | 2022-02-07 | Brazil | Acre | 105979 | 1899 | 0 | -9.0238 | -70.812 | 2022-02-08 04:21:15 | Acre, Brazil | |||
2015308 | 2015308 | 2022-02-06 | US | Oklahoma | Tulsa | 40143 | 161879 | 1899 | 0 | 36.11939621 | -95.94013939 | 2022-02-07 04:21:05 | Tulsa, Oklahoma, US | |
2015203 | 2015203 | 2022-02-06 | US | Ohio | Montgomery | 39113 | 123872 | 1899 | 0 | 39.75394919 | -84.29050975 | 2022-02-07 04:21:05 | Montgomery, Ohio, US | |
1296637 | 1296637 | 2022-02-05 | US | Oklahoma | Tulsa | 40143 | 161879 | 1899 | 0 | 36.11939621 | -95.94013939 | 2022-02-06 04:21:00 | Tulsa, Oklahoma, US | |
2329965 | 2329965 | 2022-02-04 | US | Oklahoma | Tulsa | 40143 | 161879 | 1899 | 0 | 36.11939621 | -95.94013939 | 2022-02-05 04:21:05 | Tulsa, Oklahoma, US | |
2476556 | 2476556 | 2022-02-03 | US | Oklahoma | Tulsa | 40143 | 161879 | 1899 | 0 | 36.11939621 | -95.94013939 | 2022-02-04 04:21:10 | Tulsa, Oklahoma, US | |
461981 | 461981 | 2022-02-02 | US | Oklahoma | Tulsa | 40143 | 161879 | 1899 | 0 | 36.11939621 | -95.94013939 | 2022-02-03 04:21:21 | Tulsa, Oklahoma, US | |
1779710 | 1779710 | 2022-01-27 | Sweden | Skane | 278446 | 1899 | 0 | 55.9903 | 13.5958 | 2022-01-28 04:21:09 | Skane, Sweden | |||
1318538 | 1318538 | 2022-01-26 | Sweden | Skane | 272100 | 1899 | 0 | 55.9903 | 13.5958 | 2022-01-27 04:21:19 | Skane, Sweden | |||
2052206 | 2052206 | 2022-01-25 | Sweden | Skane | 268083 | 1899 | 0 | 55.9903 | 13.5958 | 2022-01-26 04:21:07 | Skane, Sweden | |||
1962143 | 1962143 | 2022-01-20 | US | Maryland | Prince George's | 24033 | 162671 | 1899 | 0 | 38.83070039 | -76.8496441 | 2022-01-21 04:21:09 | Prince George's, Maryland, US | |
1693124 | 1693124 | 2022-01-10 | US | Georgia | Fulton | 13121 | 180426 | 1899 | 0 | 33.79216944 | -84.46319413 | 2022-01-11 04:22:01 | Fulton, Georgia, US | |
1692594 | 1692594 | 2022-01-10 | Senegal | 79766 | 1899 | 0 | 14.4974 | -14.4524 | 2022-01-11 04:22:01 | Senegal | ||||
3816293 | 3816293 | 2021-12-23 | Estonia | 234958 | 1899 | 0 | 58.5953 | 25.0136 | 2021-12-24 04:21:34 | Estonia | ||||
3403013 | 3403013 | 2021-11-30 | US | Maryland | Baltimore | 24005 | 80262 | 1899 | 0 | 39.45784712 | -76.62911955 | 2021-12-01 04:22:29 | Baltimore, Maryland, US | |
87706 | 87706 | 2021-11-09 | US | California | Santa Clara | 6085 | 148655 | 1899 | 0 | 37.23104908 | -121.6970462 | 2021-11-10 04:21:38 | Santa Clara, California, US | |
2773063 | 2773063 | 2021-09-30 | Mexico | Colima | 31739 | 1899 | 0 | 19.1223 | -104.0072 | 2021-10-01 04:21:35 | Colima, Mexico | |||
708667 | 708667 | 2021-09-29 | US | New York | Erie | 36029 | 100804 | 1899 | 0 | 42.76249024 | -78.73063652 | 2021-09-30 04:21:20 | Erie, New York, US | |
809836 | 809836 | 2021-09-20 | Russia | Vladimir Oblast | 52454 | 1899 | 0 | 56.0503336 | 40.656163299999996 | 2021-09-21 04:21:26 | Vladimir Oblast, Russia | |||
809340 | 809340 | 2021-09-20 | Canada | British Columbia | 179653 | 1899 | 0 | 53.7267 | -127.6476 | 2021-09-21 04:21:26 | British Columbia, Canada | |||
2811008 | 2811008 | 2021-09-16 | US | New York | Richmond | 36085 | 84765 | 1899 | 0 | 40.58582155 | -74.14808598 | 2021-09-17 04:21:46 | Richmond, New York, US | |
1487185 | 1487185 | 2021-08-13 | Ukraine | Khmelnytskyi Oblast | 89625 | 1899 | 0 | 49.423 | 26.9871 | 2021-08-14 04:21:25 | Khmelnytskyi Oblast, Ukraine | |||
2903315 | 2903315 | 2021-08-12 | Ukraine | Khmelnytskyi Oblast | 89586 | 1899 | 0 | 49.423 | 26.9871 | 2021-08-13 04:21:24 | Khmelnytskyi Oblast, Ukraine | |||
296187 | 296187 | 2021-07-15 | Peru | Tacna | 28454 | 1899 | 0 | 26555 | -17.644160999999997 | -70.27756 | 2021-07-16 04:21:22 | Tacna, Peru | ||
3632132 | 3632132 | 2021-07-14 | Peru | Tacna | 28454 | 1899 | 0 | 26555 | -17.644160999999997 | -70.27756 | 2021-07-15 04:21:48 | Tacna, Peru | ||
3741413 | 3741413 | 2021-07-12 | Syria | 25795 | 1899 | 21889 | 2007 | 34.802075 | 38.99681500000001 | 2021-07-13 04:21:18 | Syria | |||
3741276 | 3741276 | 2021-07-12 | Russia | Chelyabinsk Oblast | 67699 | 1899 | 62568 | 3232 | 54.4223954 | 61.1865846 | 2021-07-13 04:21:18 | Chelyabinsk Oblast, Russia | ||
1932275 | 1932275 | 2021-07-05 | Colombia | Caldas | 91513 | 1899 | 86570 | 3044 | 5.2983 | -75.2479 | 2021-07-06 04:21:32 | Caldas, Colombia | ||
1564148 | 1564148 | 2021-06-14 | Kyrgyzstan | 110829 | 1899 | 102890 | 6040 | 41.20438 | 74.766098 | 2021-06-15 04:22:22 | Kyrgyzstan | |||
2315533 | 2315533 | 2021-06-04 | Russia | Novosibirsk Oblast | 43656 | 1899 | 39565 | 2192 | 54.9720169 | 79.48139240000002 | 2021-06-05 04:23:03 | Novosibirsk Oblast, Russia | ||
645993 | 645993 | 2021-05-05 | Japan | Tokyo | 142921 | 1899 | 133488 | 7534 | 35.711343 | 139.446921 | 2021-05-06 04:20:38 | Tokyo, Japan | ||
645738 | 645738 | 2021-05-05 | Chile | Biobio | 117336 | 1899 | 112499 | 2938 | -37.4464 | -72.1416 | 2021-05-06 04:20:38 | Biobio, Chile | ||
3675693 | 3675693 | 2021-05-04 | Japan | Tokyo | 142303 | 1899 | 132792 | 7612 | 35.711343 | 139.446921 | 2021-05-05 04:20:43 | Tokyo, Japan | ||
3675438 | 3675438 | 2021-05-04 | Chile | Biobio | 116887 | 1899 | 111928 | 3060 | -37.4464 | -72.1416 | 2021-05-05 04:20:43 | Biobio, Chile | ||
2760705 | 2760705 | 2021-05-03 | Chile | Biobio | 116636 | 1899 | 111467 | 3270 | -37.4464 | -72.1416 | 2021-05-04 04:20:34 | Biobio, Chile | ||
2827423 | 2827423 | 2021-05-01 | US | Pennsylvania | Allegheny | 42003 | 98020 | 1899 | 0 | 40.46809875 | -79.98167747 | 2021-05-02 04:20:48 | Allegheny, Pennsylvania, US | |
383834 | 383834 | 2021-04-30 | Ukraine | Zaporizhia Oblast | 96026 | 1899 | 77926 | 16201 | 47.8388 | 35.1396 | 2021-05-01 04:20:47 | Zaporizhia Oblast, Ukraine | ||
1639957 | 1639957 | 2021-04-29 | Ukraine | Zaporizhia Oblast | 95406 | 1899 | 77184 | 16323 | 47.8388 | 35.1396 | 2021-04-30 04:21:03 | Zaporizhia Oblast, Ukraine | ||
3242294 | 3242294 | 2021-04-21 | India | Telangana | 373468 | 1899 | 321788 | 49781 | 18.1124 | 79.0193 | 2021-04-22 04:20:53 | Telangana, India | ||
637981 | 637981 | 2021-03-31 | Latvia | 102363 | 1899 | 93631 | 6833 | 56.8796 | 24.6032 | 2021-04-01 04:27:05 | Latvia | |||
702602 | 702602 | 2021-03-16 | Russia | Irkutsk Oblast | 58923 | 1899 | 56426 | 598 | 56.6370122 | 104.719221 | 2021-03-17 05:25:07 | Irkutsk Oblast, Russia | ||
352347 | 352347 | 2021-03-11 | Kenya | 111185 | 1899 | 87994 | 21292 | -0.0236 | 37.9062 | 2021-03-12 05:26:50 | Kenya | |||
1672752 | 1672752 | 2021-02-07 | Spain | Galicia | 101860 | 1899 | 9204 | 90757 | 42.5751 | -8.1339 | 2021-02-08 05:22:39 | Galicia, Spain | ||
975213 | 975213 | 2021-02-06 | Spain | Galicia | 101860 | 1899 | 9204 | 90757 | 42.5751 | -8.1339 | 2021-02-07 05:23:00 | Galicia, Spain | ||
1588623 | 1588623 | 2021-02-05 | US | Arizona | Pima | 4019 | 103932 | 1899 | 0 | 102033 | 32.0971334 | -111.7890033 | 2021-02-06 05:23:55 | Pima, Arizona, US |
1588471 | 1588471 | 2021-02-05 | Spain | Galicia | 101860 | 1899 | 9204 | 90757 | 42.5751 | -8.1339 | 2021-02-06 05:23:55 | Galicia, Spain | ||
1678918 | 1678918 | 2021-02-01 | US | Ohio | Cuyahoga | 39035 | 89371 | 1899 | 0 | 87471 | 41.424119 | -81.65918339 | 2021-02-02 05:22:49 | Cuyahoga, Ohio, US |
2484135 | 2484135 | 2021-01-28 | US | New Jersey | Middlesex | 34023 | 62445 | 1899 | 0 | 60546 | 40.43629879 | -74.41426991 | 2021-01-29 05:22:23 | Middlesex, New Jersey, US |
2568318 | 2568318 | 2021-01-25 | US | Connecticut | Fairfield | 9001 | 70347 | 1899 | 0 | 68448 | 41.26809896 | -73.3881171 | 2021-01-26 05:22:02 | Fairfield, Connecticut, US |
3101402 | 3101402 | 2021-01-16 | India | Odisha | 333127 | 1899 | 329318 | 1910 | 20.505428 | 84.418059 | 2021-01-17 05:22:17 | Odisha, India | ||
3308309 | 3308309 | 2021-01-13 | Mexico | Zacatecas | 22686 | 1899 | 0 | 20787 | 22.7709 | -102.5832 | 2021-01-14 05:22:32 | Zacatecas, 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]);