johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
104 rows where deaths = 1852 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
538524 | 538524 | 2022-10-26 | Chile | Coquimbo | 190105 | 1852 | 0 | -29.959 | -71.3389 | 2022-10-27 04:22:01 | Coquimbo, Chile | |||
1829925 | 1829925 | 2022-10-25 | Chile | Coquimbo | 189887 | 1852 | 0 | -29.959 | -71.3389 | 2022-10-26 04:22:19 | Coquimbo, Chile | |||
2830390 | 2830390 | 2022-08-25 | US | Maryland | Baltimore City | 24510 | 133437 | 1852 | 0 | 39.30211911 | -76.61151012 | 2022-08-26 04:21:02 | Baltimore City, Maryland, US | |
2324923 | 2324923 | 2022-08-24 | US | Maryland | Baltimore City | 24510 | 133271 | 1852 | 0 | 39.30211911 | -76.61151012 | 2022-08-25 04:21:13 | Baltimore City, Maryland, US | |
3950512 | 3950512 | 2022-08-17 | Japan | Saitama | 941087 | 1852 | 0 | 35.997101 | 139.347635 | 2022-08-18 04:21:11 | Saitama, Japan | |||
2742124 | 2742124 | 2022-07-07 | US | Indiana | Lake | 18089 | 114734 | 1852 | 0 | 41.41874274 | -87.38277575 | 2022-07-08 04:20:56 | Lake, Indiana, US | |
1200919 | 1200919 | 2022-07-06 | US | Indiana | Lake | 18089 | 114734 | 1852 | 0 | 41.41874274 | -87.38277575 | 2022-07-07 04:20:55 | Lake, Indiana, US | |
3968719 | 3968719 | 2022-07-05 | US | New Jersey | Camden | 34007 | 140081 | 1852 | 0 | 39.80343818 | -74.96388753 | 2022-07-06 04:20:58 | Camden, New Jersey, US | |
3080230 | 3080230 | 2022-07-04 | US | New Jersey | Camden | 34007 | 139962 | 1852 | 0 | 39.80343818 | -74.96388753 | 2022-07-05 04:20:45 | Camden, New Jersey, US | |
1769512 | 1769512 | 2022-07-03 | US | New Jersey | Camden | 34007 | 139746 | 1852 | 0 | 39.80343818 | -74.96388753 | 2022-07-04 04:20:54 | Camden, New Jersey, US | |
3367498 | 3367498 | 2022-07-02 | US | New Jersey | Camden | 34007 | 139746 | 1852 | 0 | 39.80343818 | -74.96388753 | 2022-07-03 04:20:59 | Camden, New Jersey, US | |
595827 | 595827 | 2022-07-01 | US | New Jersey | Camden | 34007 | 139525 | 1852 | 0 | 39.80343818 | -74.96388753 | 2022-07-02 04:21:16 | Camden, New Jersey, US | |
3942228 | 3942228 | 2022-06-30 | US | New Jersey | Camden | 34007 | 139372 | 1852 | 0 | 39.80343818 | -74.96388753 | 2022-07-01 04:21:10 | Camden, New Jersey, US | |
2240180 | 2240180 | 2022-06-28 | US | Georgia | Cobb | 13067 | 185631 | 1852 | 0 | 33.94243204 | -84.5761255 | 2022-06-29 04:20:59 | Cobb, Georgia, US | |
2148422 | 2148422 | 2022-06-27 | US | Georgia | Cobb | 13067 | 185631 | 1852 | 0 | 33.94243204 | -84.5761255 | 2022-06-28 04:20:58 | Cobb, Georgia, US | |
476223 | 476223 | 2022-06-26 | US | Georgia | Cobb | 13067 | 185631 | 1852 | 0 | 33.94243204 | -84.5761255 | 2022-06-27 04:21:00 | Cobb, Georgia, US | |
939598 | 939598 | 2022-06-25 | US | Georgia | Cobb | 13067 | 185631 | 1852 | 0 | 33.94243204 | -84.5761255 | 2022-06-26 04:21:02 | Cobb, Georgia, US | |
3347418 | 3347418 | 2022-06-24 | US | Georgia | Cobb | 13067 | 185631 | 1852 | 0 | 33.94243204 | -84.5761255 | 2022-06-25 04:20:57 | Cobb, Georgia, US | |
1649159 | 1649159 | 2022-06-23 | US | Georgia | Cobb | 13067 | 185631 | 1852 | 0 | 33.94243204 | -84.5761255 | 2022-06-24 04:20:58 | Cobb, Georgia, US | |
2188394 | 2188394 | 2022-06-22 | US | Georgia | Cobb | 13067 | 185631 | 1852 | 0 | 33.94243204 | -84.5761255 | 2022-06-23 04:20:55 | Cobb, Georgia, US | |
2979500 | 2979500 | 2022-06-13 | Russia | Pskov Oblast | 110938 | 1852 | 0 | 57.5358729 | 28.8586826 | 2022-06-14 04:20:52 | Pskov Oblast, Russia | |||
3157617 | 3157617 | 2022-06-09 | Italy | Umbria | 289795 | 1852 | 0 | 43.10675841 | 12.38824698 | 2022-06-10 04:20:55 | Umbria, Italy | |||
1421084 | 1421084 | 2022-06-08 | Italy | Umbria | 289321 | 1852 | 0 | 43.10675841 | 12.38824698 | 2022-06-09 04:20:54 | Umbria, Italy | |||
3726198 | 3726198 | 2022-06-07 | Italy | Umbria | 288873 | 1852 | 0 | 43.10675841 | 12.38824698 | 2022-06-08 04:20:55 | Umbria, Italy | |||
1846181 | 1846181 | 2022-04-18 | Russia | Kaliningrad Oblast | 167316 | 1852 | 0 | 54.7293041 | 21.1489473 | 2022-04-19 04:21:00 | Kaliningrad Oblast, Russia | |||
3321054 | 3321054 | 2022-04-07 | US | Georgia | Gwinnett | 13135 | 207698 | 1852 | 0 | 33.96044201 | -84.02137802 | 2022-04-08 04:20:48 | Gwinnett, Georgia, US | |
3730293 | 3730293 | 2022-04-03 | Malaysia | Perak | 191290 | 1852 | 0 | 4.5921 | 101.0901 | 2022-04-04 04:20:51 | Perak, Malaysia | |||
1436837 | 1436837 | 2022-03-28 | Russia | Tatarstan Republic | 136428 | 1852 | 0 | 55.7648572 | 52.43104273 | 2022-03-29 04:20:46 | Tatarstan Republic, Russia | |||
1723151 | 1723151 | 2022-03-25 | US | Pennsylvania | Delaware | 42045 | 109528 | 1852 | 0 | 39.91680171 | -75.40243663 | 2022-03-26 04:20:23 | Delaware, Pennsylvania, US | |
1470768 | 1470768 | 2022-03-24 | US | Pennsylvania | Delaware | 42045 | 109494 | 1852 | 0 | 39.91680171 | -75.40243663 | 2022-03-25 04:20:46 | Delaware, Pennsylvania, US | |
3809897 | 3809897 | 2022-01-28 | Italy | Calabria | 166091 | 1852 | 0 | 38.90597598 | 16.59440194 | 2022-01-29 04:21:10 | Calabria, Italy | |||
3467218 | 3467218 | 2022-01-18 | US | Texas | Cameron | 48061 | 82951 | 1852 | 0 | 26.14524221 | -97.48140372 | 2022-01-19 04:21:23 | Cameron, Texas, US | |
99001 | 99001 | 2022-01-14 | Angola | 93302 | 1852 | 0 | -11.2027 | 17.8739 | 2022-01-15 04:21:07 | Angola | ||||
3689067 | 3689067 | 2022-01-13 | US | Maryland | Prince George's | 24033 | 155634 | 1852 | 0 | 38.83070039 | -76.8496441 | 2022-01-14 04:21:54 | Prince George's, Maryland, US | |
1115766 | 1115766 | 2022-01-11 | US | New Jersey | Monmouth | 34025 | 142867 | 1852 | 0 | 40.26549699 | -74.22240686 | 2022-01-12 04:21:44 | Monmouth, New Jersey, US | |
1695884 | 1695884 | 2022-01-10 | US | Wisconsin | Milwaukee | 55079 | 211584 | 1852 | 0 | 43.00486062 | -87.96733172 | 2022-01-11 04:22:01 | Milwaukee, Wisconsin, US | |
1692030 | 1692030 | 2022-01-10 | Brazil | Acre | 88440 | 1852 | 0 | -9.0238 | -70.812 | 2022-01-11 04:22:01 | Acre, Brazil | |||
126445 | 126445 | 2022-01-09 | Brazil | Acre | 88403 | 1852 | 0 | -9.0238 | -70.812 | 2022-01-10 04:22:07 | Acre, Brazil | |||
1215280 | 1215280 | 2022-01-08 | Brazil | Acre | 88403 | 1852 | 0 | -9.0238 | -70.812 | 2022-01-09 04:21:46 | Acre, Brazil | |||
1389373 | 1389373 | 2022-01-07 | Brazil | Acre | 88403 | 1852 | 0 | -9.0238 | -70.812 | 2022-01-08 04:21:53 | Acre, Brazil | |||
2609760 | 2609760 | 2022-01-06 | Brazil | Acre | 88403 | 1852 | 0 | -9.0238 | -70.812 | 2022-01-07 04:22:09 | Acre, Brazil | |||
1285633 | 1285633 | 2022-01-05 | Ukraine | Sevastopol* | 52977 | 1852 | 0 | 44.6054 | 33.522 | 2022-01-06 04:22:09 | Sevastopol*, Ukraine | |||
1281702 | 1281702 | 2022-01-05 | Brazil | Acre | 88395 | 1852 | 0 | -9.0238 | -70.812 | 2022-01-06 04:22:09 | Acre, Brazil | |||
1285718 | 1285718 | 2022-01-04 | Brazil | Acre | 88395 | 1852 | 0 | -9.0238 | -70.812 | 2022-01-05 04:21:59 | Acre, Brazil | |||
798205 | 798205 | 2021-12-22 | Chile | Maule | 109333 | 1852 | 0 | -35.5183 | -71.6885 | 2021-12-23 04:21:21 | Maule, Chile | |||
1661232 | 1661232 | 2021-12-12 | US | Georgia | Fulton | 13121 | 136224 | 1852 | 0 | 33.79216944 | -84.46319413 | 2021-12-13 04:22:02 | Fulton, Georgia, US | |
1660297 | 1660297 | 2021-12-12 | Estonia | 228279 | 1852 | 0 | 58.5953 | 25.0136 | 2021-12-13 04:22:02 | Estonia | ||||
1665248 | 1665248 | 2021-12-11 | US | Georgia | Fulton | 13121 | 136224 | 1852 | 0 | 33.79216944 | -84.46319413 | 2021-12-12 04:22:12 | Fulton, Georgia, US | |
3656400 | 3656400 | 2021-12-10 | US | Georgia | Fulton | 13121 | 136224 | 1852 | 0 | 33.79216944 | -84.46319413 | 2021-12-11 04:22:45 | Fulton, Georgia, US | |
904422 | 904422 | 2021-11-24 | Russia | Ryazan Oblast | 54068 | 1852 | 0 | 54.42267320000001 | 40.57052460000001 | 2021-11-25 04:22:33 | Ryazan Oblast, Russia | |||
162140 | 162140 | 2021-11-19 | Mongolia | 649731 | 1852 | 0 | 46.8625 | 103.8467 | 2021-11-20 04:22:17 | Mongolia | ||||
699977 | 699977 | 2021-11-04 | US | Maryland | Baltimore | 24005 | 77242 | 1852 | 0 | 39.45784712 | -76.62911955 | 2021-11-05 04:21:54 | Baltimore, Maryland, US | |
2123689 | 2123689 | 2021-10-21 | India | Puducherry | 127564 | 1852 | 0 | 11.882658000000001 | 78.86498 | 2021-10-22 04:21:14 | Puducherry, India | |||
443301 | 443301 | 2021-10-20 | India | Puducherry | 127521 | 1852 | 0 | 11.882658000000001 | 78.86498 | 2021-10-21 04:21:18 | Puducherry, India | |||
597620 | 597620 | 2021-10-19 | India | Puducherry | 127479 | 1852 | 0 | 11.882658000000001 | 78.86498 | 2021-10-20 04:21:00 | Puducherry, India | |||
2132076 | 2132076 | 2021-10-01 | Malaysia | Kedah | 135545 | 1852 | 0 | 6.1184 | 100.3685 | 2021-10-02 04:21:25 | Kedah, Malaysia | |||
1334218 | 1334218 | 2021-09-28 | India | Manipur | 120216 | 1852 | 0 | 24.738975 | 93.882541 | 2021-09-29 04:21:45 | Manipur, India | |||
2076526 | 2076526 | 2021-09-26 | US | California | Santa Clara | 6085 | 141770 | 1852 | 0 | 37.23104908 | -121.6970462 | 2021-09-27 04:21:16 | Santa Clara, California, US | |
2812395 | 2812395 | 2021-09-16 | Ukraine | Zhytomyr Oblast | 91339 | 1852 | 0 | 50.2547 | 28.6587 | 2021-09-17 04:21:46 | Zhytomyr Oblast, Ukraine | |||
1376211 | 1376211 | 2021-09-15 | US | Minnesota | Hennepin | 27053 | 139659 | 1852 | 0 | 45.00761521 | -93.47694895 | 2021-09-16 04:22:19 | Hennepin, Minnesota, US | |
3197623 | 3197623 | 2021-09-06 | Ukraine | Chernivtsi Oblast | 82530 | 1852 | 0 | 48.2917 | 25.9352 | 2021-09-07 04:21:35 | Chernivtsi Oblast, Ukraine | |||
180256 | 180256 | 2021-09-02 | US | New York | Erie | 36029 | 94937 | 1852 | 0 | 42.76249024 | -78.73063652 | 2021-09-03 04:21:20 | Erie, New York, US | |
2899923 | 2899923 | 2021-08-12 | Russia | Penza Oblast | 59032 | 1852 | 0 | 53.1655415 | 44.78791810000001 | 2021-08-13 04:21:24 | Penza Oblast, Russia | |||
410553 | 410553 | 2021-07-28 | US | New York | Richmond | 36085 | 76838 | 1852 | 0 | 40.58582155 | -74.14808598 | 2021-07-29 04:21:33 | Richmond, New York, US | |
3663229 | 3663229 | 2021-07-11 | Ukraine | Mykolaiv Oblast | 70096 | 1852 | 68055 | 189 | 46.975 | 31.9946 | 2021-07-12 04:21:34 | Mykolaiv Oblast, Ukraine | ||
3659446 | 3659446 | 2021-07-11 | Colombia | Meta | 78985 | 1852 | 74848 | 2285 | 3.272 | -73.0877 | 2021-07-12 04:21:34 | Meta, Colombia | ||
629513 | 629513 | 2021-07-10 | Ukraine | Mykolaiv Oblast | 70093 | 1852 | 68039 | 202 | 46.975 | 31.9946 | 2021-07-11 04:21:43 | Mykolaiv Oblast, Ukraine | ||
625730 | 625730 | 2021-07-10 | Colombia | Meta | 78771 | 1852 | 74848 | 2071 | 3.272 | -73.0877 | 2021-07-11 04:21:43 | Meta, Colombia | ||
833232 | 833232 | 2021-07-09 | Ukraine | Mykolaiv Oblast | 70080 | 1852 | 68013 | 215 | 46.975 | 31.9946 | 2021-07-10 04:21:25 | Mykolaiv Oblast, Ukraine | ||
829449 | 829449 | 2021-07-09 | Colombia | Meta | 78343 | 1852 | 73946 | 2545 | 3.272 | -73.0877 | 2021-07-10 04:21:25 | Meta, Colombia | ||
778556 | 778556 | 2021-07-08 | Russia | Chelyabinsk Oblast | 66666 | 1852 | 62135 | 2679 | 54.4223954 | 61.1865846 | 2021-07-09 04:21:21 | Chelyabinsk Oblast, Russia | ||
1932167 | 1932167 | 2021-07-05 | Brazil | Amapa | 117927 | 1852 | 97309 | 18766 | 0.902 | -52.003 | 2021-07-06 04:21:32 | Amapa, Brazil | ||
1715962 | 1715962 | 2021-06-25 | Ukraine | Poltava Oblast | 77768 | 1852 | 75582 | 334 | 49.5883 | 34.5514 | 2021-06-26 04:21:43 | Poltava Oblast, Ukraine | ||
2914800 | 2914800 | 2021-06-17 | Ukraine | Khmelnytskyi Oblast | 88682 | 1852 | 85954 | 876 | 49.423 | 26.9871 | 2021-06-18 04:22:16 | Khmelnytskyi Oblast, Ukraine | ||
3472389 | 3472389 | 2021-06-08 | Mexico | Nayarit | 12305 | 1852 | 0 | 10453 | 21.7514 | -104.8455 | 2021-06-09 04:23:31 | Nayarit, Mexico | ||
3145637 | 3145637 | 2021-06-07 | Kyrgyzstan | 107335 | 1852 | 100722 | 4761 | 41.20438 | 74.766098 | 2021-06-08 04:22:35 | Kyrgyzstan | |||
726334 | 726334 | 2021-05-22 | Colombia | Bolivar | 95943 | 1852 | 91250 | 2841 | 8.6704 | -74.03 | 2021-05-23 04:20:51 | Bolivar, Colombia | ||
887969 | 887969 | 2021-04-26 | Colombia | Huila | 53112 | 1852 | 50651 | 609 | 2.5359 | -75.5277 | 2021-04-27 04:20:52 | Huila, Colombia | ||
2020764 | 2020764 | 2021-04-20 | Japan | Tokyo | 131185 | 1852 | 123856 | 5477 | 35.711343 | 139.446921 | 2021-04-21 04:21:14 | Tokyo, Japan | ||
1290059 | 1290059 | 2021-03-29 | Kosovo | 88429 | 1852 | 73521 | 13056 | 42.602636 | 20.902977 | 2021-03-30 04:26:23 | Kosovo | |||
702527 | 702527 | 2021-03-16 | Netherlands | Gelderland | 129916 | 1852 | 0 | 127886 | 52.061738 | 5.939114 | 2021-03-17 05:25:07 | Gelderland, Netherlands | ||
1617832 | 1617832 | 2021-03-05 | US | Massachusetts | Essex | 25009 | 84395 | 1852 | 0 | 82205 | 42.6687626 | -70.94687179 | 2021-03-06 04:23:41 | Essex, Massachusetts, US |
2183757 | 2183757 | 2021-02-26 | Peru | Ucayali | 22574 | 1852 | 0 | 20722 | -9.621718 | -73.444929 | 2021-02-27 05:22:28 | Ucayali, Peru | ||
3052134 | 3052134 | 2021-02-16 | US | Missouri | St. Louis | 29189 | 86694 | 1852 | 0 | 84842 | 38.63770039999999 | -90.4458375 | 2021-02-17 05:23:10 | St. Louis, Missouri, US |
2638380 | 2638380 | 2021-02-11 | US | Connecticut | New Haven | 9009 | 67380 | 1852 | 0 | 65528 | 41.4080325 | -72.93620426 | 2021-02-12 05:23:29 | New Haven, Connecticut, US |
14787 | 14787 | 2021-01-26 | US | Ohio | Cuyahoga | 39035 | 86893 | 1852 | 0 | 85040 | 41.424119 | -81.65918339 | 2021-01-27 05:23:41 | Cuyahoga, Ohio, US |
2466792 | 2466792 | 2021-01-22 | Italy | Marche | 51981 | 1852 | 41858 | 8271 | 43.61675973 | 13.5188753 | 2021-01-23 05:22:03 | Marche, Italy | ||
3879701 | 3879701 | 2021-01-14 | Netherlands | Noord-Holland | 151602 | 1852 | 0 | 149512 | 52.60090600000001 | 4.918688 | 2021-01-15 05:22:24 | Noord-Holland, Netherlands | ||
3308429 | 3308429 | 2021-01-13 | Russia | Nizhny Novgorod Oblast | 75811 | 1852 | 68139 | 5820 | 55.47180329999999 | 44.0911594 | 2021-01-14 05:22:32 | Nizhny Novgorod Oblast, Russia | ||
3034053 | 3034053 | 2021-01-05 | Brazil | Rondonia | 97854 | 1852 | 82849 | 13153 | -11.5057 | -63.5806 | 2021-01-06 05:22:16 | Rondonia, Brazil | ||
1137538 | 1137538 | 2021-01-01 | US | Connecticut | Hartford | 9003 | 46680 | 1852 | 0 | 44828 | 41.80283011 | -72.73103891 | 2021-01-02 05:22:33 | Hartford, Connecticut, US |
3696144 | 3696144 | 2020-12-31 | US | Connecticut | Hartford | 9003 | 46680 | 1852 | 0 | 44828 | 41.80283011 | -72.73103891 | 2021-01-01 05:23:07 | Hartford, Connecticut, US |
2349549 | 2349549 | 2020-12-07 | US | Nevada | Clark | 32003 | 129427 | 1852 | 0 | 127575 | 36.21458855 | -115.0130241 | 2020-12-08 05:27:42 | Clark, Nevada, US |
2347165 | 2347165 | 2020-12-07 | Brazil | Mato Grosso do Sul | 107235 | 1852 | 91740 | 11665 | -20.7722 | -54.7852 | 2020-12-08 05:27:42 | Mato Grosso do Sul, Brazil | ||
1008419 | 1008419 | 2020-12-06 | US | Nevada | Clark | 32003 | 127819 | 1852 | 0 | 125967 | 36.21458855 | -115.0130241 | 2020-12-07 05:26:14 | Clark, Nevada, US |
1180174 | 1180174 | 2020-10-22 | US | Pennsylvania | Philadelphia | 42101 | 41610 | 1852 | 0 | 39758 | 40.00338507 | -75.1379271 | 2020-10-23 04:24:46 | Philadelphia, Pennsylvania, US |
1794718 | 1794718 | 2020-10-19 | Mexico | Michoacan | 23268 | 1852 | 20542 | 874 | 19.5665 | -101.7068 | 2020-10-20 04:24:22 | Michoacan, Mexico | ||
1794606 | 1794606 | 2020-10-19 | Ireland | 50993 | 1852 | 23364 | 25777 | 53.1424 | -7.6921 | 2020-10-20 04:24:22 | Ireland | |||
762290 | 762290 | 2020-10-18 | Ireland | 49962 | 1852 | 23364 | 24746 | 53.1424 | -7.6921 | 2020-10-19 04:24:16 | Ireland | |||
1173358 | 1173358 | 2020-09-10 | Portugal | 62126 | 1852 | 43441 | 16833 | 39.3999 | -8.2245 | 2020-09-11 04:46:23 | Portugal |
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]);