johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
76 rows where deaths = 1855 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3377998 | 3377998 | 2022-12-08 | US | Colorado | El Paso | 8041 | 231207 | 1855 | 0 | 38.83240149 | -104.5251411 | 2022-12-09 04:21:05 | El Paso, Colorado, US | |
1985269 | 1985269 | 2022-12-07 | US | Colorado | El Paso | 8041 | 230963 | 1855 | 0 | 38.83240149 | -104.5251411 | 2022-12-08 04:21:07 | El Paso, Colorado, US | |
3547272 | 3547272 | 2022-09-01 | Chile | Antofagasta | 162591 | 1855 | 0 | -23.6509 | -70.3975 | 2022-09-02 04:21:07 | Antofagasta, Chile | |||
2343192 | 2343192 | 2022-08-31 | Chile | Antofagasta | 162591 | 1855 | 0 | -23.6509 | -70.3975 | 2022-09-01 04:21:03 | Antofagasta, Chile | |||
3773672 | 3773672 | 2022-08-30 | Chile | Antofagasta | 162358 | 1855 | 0 | -23.6509 | -70.3975 | 2022-08-31 04:20:57 | Antofagasta, Chile | |||
1680268 | 1680268 | 2022-08-29 | Chile | Antofagasta | 162277 | 1855 | 0 | -23.6509 | -70.3975 | 2022-08-30 04:21:03 | Antofagasta, Chile | |||
631020 | 631020 | 2022-07-12 | US | Indiana | Lake | 18089 | 115309 | 1855 | 0 | 41.41874274 | -87.38277575 | 2022-07-13 04:20:58 | Lake, Indiana, US | |
1213721 | 1213721 | 2022-07-11 | US | New Jersey | Camden | 34007 | 141051 | 1855 | 0 | 39.80343818 | -74.96388753 | 2022-07-12 04:20:51 | Camden, New Jersey, US | |
1212664 | 1212664 | 2022-07-11 | US | Indiana | Lake | 18089 | 115309 | 1855 | 0 | 41.41874274 | -87.38277575 | 2022-07-12 04:20:51 | Lake, Indiana, US | |
2791203 | 2791203 | 2022-07-10 | US | New Jersey | Camden | 34007 | 140939 | 1855 | 0 | 39.80343818 | -74.96388753 | 2022-07-11 04:20:46 | Camden, New Jersey, US | |
144156 | 144156 | 2022-07-09 | US | New Jersey | Camden | 34007 | 140764 | 1855 | 0 | 39.80343818 | -74.96388753 | 2022-07-10 04:20:54 | Camden, New Jersey, US | |
3968153 | 3968153 | 2022-07-05 | US | Massachusetts | Hampden | 25013 | 147438 | 1855 | 0 | 42.13440424 | -72.63235561 | 2022-07-06 04:20:58 | Hampden, Massachusetts, US | |
3269756 | 3269756 | 2022-06-19 | Russia | Pskov Oblast | 111049 | 1855 | 0 | 57.5358729 | 28.8586826 | 2022-06-20 04:21:01 | Pskov Oblast, Russia | |||
3397668 | 3397668 | 2022-06-18 | Russia | Pskov Oblast | 111032 | 1855 | 0 | 57.5358729 | 28.8586826 | 2022-06-19 04:20:51 | Pskov Oblast, Russia | |||
222534 | 222534 | 2022-05-09 | US | California | Alameda | 6001 | 282840 | 1855 | 0 | 37.64629437 | -121.8929271 | 2022-05-10 04:20:50 | Alameda, California, US | |
2331919 | 2331919 | 2022-05-08 | US | California | Alameda | 6001 | 279988 | 1855 | 0 | 37.64629437 | -121.8929271 | 2022-05-09 04:20:54 | Alameda, California, US | |
360881 | 360881 | 2022-05-07 | US | California | Alameda | 6001 | 279970 | 1855 | 0 | 37.64629437 | -121.8929271 | 2022-05-08 04:20:49 | Alameda, California, US | |
1398232 | 1398232 | 2022-05-06 | US | California | Alameda | 6001 | 279948 | 1855 | 0 | 37.64629437 | -121.8929271 | 2022-05-07 04:21:09 | Alameda, California, US | |
3437034 | 3437034 | 2022-04-22 | Russia | Kabardino-Balkarian Republic | 61398 | 1855 | 0 | 43.480604799999995 | 43.5978976 | 2022-04-23 04:20:50 | Kabardino-Balkarian Republic, Russia | |||
2892619 | 2892619 | 2022-04-21 | Russia | Kabardino-Balkarian Republic | 61375 | 1855 | 0 | 43.480604799999995 | 43.5978976 | 2022-04-22 04:20:45 | Kabardino-Balkarian Republic, Russia | |||
3628198 | 3628198 | 2022-03-13 | Russia | Primorsky Krai | 164356 | 1855 | 0 | 45.0819456 | 134.726645 | 2022-03-14 04:20:46 | Primorsky Krai, Russia | |||
953519 | 953519 | 2022-03-12 | US | Pennsylvania | Bucks | 42017 | 122297 | 1855 | 0 | 40.33682119 | -75.10836643 | 2022-03-13 04:20:49 | Bucks, Pennsylvania, US | |
358980 | 358980 | 2022-03-11 | US | Pennsylvania | Bucks | 42017 | 122228 | 1855 | 0 | 40.33682119 | -75.10836643 | 2022-03-12 04:20:50 | Bucks, Pennsylvania, US | |
2141778 | 2141778 | 2022-03-09 | US | Massachusetts | Norfolk | 25021 | 129303 | 1855 | 0 | 42.16073095 | -71.20530408 | 2022-03-10 04:20:48 | Norfolk, Massachusetts, US | |
2832543 | 2832543 | 2022-01-22 | Brazil | Acre | 93533 | 1855 | 0 | -9.0238 | -70.812 | 2022-01-23 04:21:13 | Acre, Brazil | |||
1963598 | 1963598 | 2022-01-20 | US | Texas | Cameron | 48061 | 84267 | 1855 | 0 | 26.14524221 | -97.48140372 | 2022-01-21 04:21:09 | Cameron, Texas, US | |
3615241 | 3615241 | 2022-01-12 | US | New Jersey | Monmouth | 34025 | 144343 | 1855 | 0 | 40.26549699 | -74.22240686 | 2022-01-13 08:00:09 | Monmouth, New Jersey, US | |
1281830 | 1281830 | 2022-01-05 | Colombia | Quindio | 59836 | 1855 | 0 | 4.461 | -75.6674 | 2022-01-06 04:22:09 | Quindio, Colombia | |||
2088780 | 2088780 | 2021-12-14 | US | Georgia | Fulton | 13121 | 136771 | 1855 | 0 | 33.79216944 | -84.46319413 | 2021-12-15 03:22:16 | Fulton, Georgia, US | |
783197 | 783197 | 2021-12-13 | US | Georgia | Fulton | 13121 | 136605 | 1855 | 0 | 33.79216944 | -84.46319413 | 2021-12-14 04:22:38 | Fulton, Georgia, US | |
551326 | 551326 | 2021-12-08 | US | California | Kern | 6029 | 159336 | 1855 | 0 | 35.34329425 | -118.72777959999999 | 2021-12-09 04:22:49 | Kern, California, US | |
43910 | 43910 | 2021-11-02 | Russia | Ivanovo Oblast | 55789 | 1855 | 0 | 56.9167446 | 41.43521370000001 | 2021-11-03 06:22:09 | Ivanovo Oblast, Russia | |||
770295 | 770295 | 2021-10-23 | India | Puducherry | 127674 | 1855 | 0 | 11.882658000000001 | 78.86498 | 2021-10-24 04:21:22 | Puducherry, India | |||
1274483 | 1274483 | 2021-10-03 | Russia | Buryatia Republic | 59162 | 1855 | 0 | 52.718242599999996 | 109.492143 | 2021-10-04 04:21:31 | Buryatia Republic, Russia | |||
2772920 | 2772920 | 2021-09-30 | India | Manipur | 120584 | 1855 | 0 | 24.738975 | 93.882541 | 2021-10-01 04:21:35 | Manipur, India | |||
1334553 | 1334553 | 2021-09-28 | Senegal | 73757 | 1855 | 0 | 14.4974 | -14.4524 | 2021-09-29 04:21:45 | Senegal | ||||
1235922 | 1235922 | 2021-09-27 | Senegal | 73747 | 1855 | 0 | 14.4974 | -14.4524 | 2021-09-28 04:21:28 | Senegal | ||||
2076223 | 2076223 | 2021-09-26 | Senegal | 73742 | 1855 | 0 | 14.4974 | -14.4524 | 2021-09-27 04:21:16 | Senegal | ||||
1724775 | 1724775 | 2021-09-25 | Senegal | 73728 | 1855 | 0 | 14.4974 | -14.4524 | 2021-09-26 04:21:29 | Senegal | ||||
3757731 | 3757731 | 2021-09-21 | Russia | Udmurt Republic | 51111 | 1855 | 0 | 57.1961165 | 52.69598320000001 | 2021-09-22 04:21:45 | Udmurt Republic, Russia | |||
809832 | 809832 | 2021-09-20 | Russia | Tyumen Oblast | 59466 | 1855 | 0 | 58.8206488 | 70.36588370000001 | 2021-09-21 04:21:26 | Tyumen Oblast, Russia | |||
1816494 | 1816494 | 2021-09-19 | US | Minnesota | Hennepin | 27053 | 140392 | 1855 | 0 | 45.00761521 | -93.47694895 | 2021-09-20 04:21:22 | Hennepin, Minnesota, US | |
18074 | 18074 | 2021-09-18 | US | Minnesota | Hennepin | 27053 | 140392 | 1855 | 0 | 45.00761521 | -93.47694895 | 2021-09-19 04:21:34 | Hennepin, Minnesota, US | |
2619759 | 2619759 | 2021-09-17 | US | Minnesota | Hennepin | 27053 | 140392 | 1855 | 0 | 45.00761521 | -93.47694895 | 2021-09-18 04:21:24 | Hennepin, Minnesota, US | |
645560 | 645560 | 2021-09-07 | Ukraine | Chernivtsi Oblast | 82649 | 1855 | 0 | 48.2917 | 25.9352 | 2021-09-08 04:21:31 | Chernivtsi Oblast, Ukraine | |||
3974792 | 3974792 | 2021-09-03 | Russia | Murmansk Oblast | 68614 | 1855 | 0 | 68.00004179999999 | 33.9999151 | 2021-09-04 04:21:28 | Murmansk Oblast, Russia | |||
2179239 | 2179239 | 2021-08-22 | Malaysia | W.P. Kuala Lumpur | 164520 | 1855 | 139309 | 23356 | 3.139 | 101.6869 | 2021-08-23 04:21:27 | W.P. Kuala Lumpur, Malaysia | ||
1483635 | 1483635 | 2021-08-13 | Mexico | Chiapas | 17225 | 1855 | 0 | 16.7569 | -93.1292 | 2021-08-14 04:21:25 | Chiapas, Mexico | |||
2207263 | 2207263 | 2021-08-07 | Ukraine | Crimea Republic* | 62454 | 1855 | 0 | 45.2835 | 34.2008 | 2021-08-08 04:21:33 | Crimea Republic*, Ukraine | |||
334165 | 334165 | 2021-08-04 | US | New York | Richmond | 36085 | 77734 | 1855 | 0 | 40.58582155 | -74.14808598 | 2021-08-05 04:21:51 | Richmond, New York, US | |
3685710 | 3685710 | 2021-08-02 | US | New York | Richmond | 36085 | 77492 | 1855 | 0 | 40.58582155 | -74.14808598 | 2021-08-03 04:21:39 | Richmond, New York, US | |
3017609 | 3017609 | 2021-08-01 | US | New York | Richmond | 36085 | 77354 | 1855 | 0 | 40.58582155 | -74.14808598 | 2021-08-02 04:21:36 | Richmond, New York, US | |
3906232 | 3906232 | 2021-07-31 | US | New York | Richmond | 36085 | 77227 | 1855 | 0 | 40.58582155 | -74.14808598 | 2021-08-01 04:21:50 | Richmond, New York, US | |
3298437 | 3298437 | 2021-07-30 | US | New York | Richmond | 36085 | 77091 | 1855 | 0 | 40.58582155 | -74.14808598 | 2021-07-31 04:21:35 | Richmond, New York, US | |
3295928 | 3295928 | 2021-07-30 | Brazil | Roraima | 120005 | 1855 | 112425 | 5549 | -2.7376 | -62.0751 | 2021-07-31 04:21:35 | Roraima, Brazil | ||
582467 | 582467 | 2021-07-13 | Ukraine | Mykolaiv Oblast | 70112 | 1855 | 68111 | 146 | 46.975 | 31.9946 | 2021-07-14 04:21:35 | Mykolaiv Oblast, Ukraine | ||
403901 | 403901 | 2021-06-29 | Ukraine | Poltava Oblast | 77817 | 1855 | 75614 | 348 | 49.5883 | 34.5514 | 2021-06-30 04:21:41 | Poltava Oblast, Ukraine | ||
3129144 | 3129144 | 2021-06-28 | Ukraine | Poltava Oblast | 77814 | 1855 | 75614 | 345 | 49.5883 | 34.5514 | 2021-06-29 04:21:28 | Poltava Oblast, Ukraine | ||
2593639 | 2593639 | 2021-06-27 | Ukraine | Poltava Oblast | 77804 | 1855 | 75614 | 335 | 49.5883 | 34.5514 | 2021-06-28 04:21:29 | Poltava Oblast, Ukraine | ||
3962143 | 3962143 | 2021-06-26 | Ukraine | Poltava Oblast | 77799 | 1855 | 75610 | 334 | 49.5883 | 34.5514 | 2021-06-27 04:21:39 | Poltava Oblast, Ukraine | ||
2299121 | 2299121 | 2021-06-24 | Zambia | 140620 | 1855 | 115898 | 22867 | -13.133897 | 27.849332 | 2021-06-25 04:21:33 | Zambia | |||
2423221 | 2423221 | 2021-06-23 | Syria | 25248 | 1855 | 21766 | 1627 | 34.802075 | 38.99681500000001 | 2021-06-24 04:21:55 | Syria | |||
3704282 | 3704282 | 2021-04-27 | US | New Jersey | Passaic | 34031 | 70940 | 1855 | 0 | 41.03238628 | -74.29954144 | 2021-04-28 04:20:32 | Passaic, New Jersey, US | |
2185751 | 2185751 | 2021-02-26 | US | New Jersey | Ocean | 34029 | 58116 | 1855 | 0 | 56261 | 39.8895449 | -74.28089251 | 2021-02-27 05:22:28 | Ocean, New Jersey, US |
790540 | 790540 | 2021-02-04 | Peru | Cusco | 29552 | 1855 | 0 | 27697 | -13.191068 | -72.153609 | 2021-02-05 05:22:38 | Cusco, Peru | ||
1676573 | 1676573 | 2021-02-01 | Mexico | Tlaxcala | 15173 | 1855 | 0 | 13318 | 19.3139 | -98.2404 | 2021-02-02 05:22:49 | Tlaxcala, Mexico | ||
2484132 | 2484132 | 2021-01-28 | US | New Jersey | Hudson | 34017 | 60138 | 1855 | 0 | 58283 | 40.73766234 | -74.07515667 | 2021-01-29 05:22:23 | Hudson, New Jersey, US |
2468970 | 2468970 | 2021-01-22 | US | New Jersey | Middlesex | 34023 | 59468 | 1855 | 0 | 57613 | 40.43629879 | -74.41426991 | 2021-01-23 05:22:03 | Middlesex, New Jersey, US |
1094334 | 1094334 | 2021-01-20 | Russia | Sverdlovsk Oblast | 66359 | 1855 | 58816 | 5688 | 58.6414755 | 61.8021546 | 2021-01-21 05:22:01 | Sverdlovsk Oblast, Russia | ||
3762144 | 3762144 | 2020-12-28 | US | California | Riverside | 6065 | 182438 | 1855 | 0 | 181035 | 33.74314981 | -115.9933578 | 2020-12-29 05:22:37 | Riverside, California, US |
3149512 | 3149512 | 2020-12-16 | Germany | Sachsen | 92409 | 1855 | 60400 | 33293 | 51.1045 | 13.2017 | 2020-12-17 05:28:12 | Sachsen, Germany | ||
3190081 | 3190081 | 2020-11-22 | Mexico | Oaxaca | 23591 | 1855 | 0 | 21736 | 17.0732 | -96.7266 | 2020-11-23 05:25:26 | Oaxaca, Mexico | ||
2836926 | 2836926 | 2020-09-21 | Morocco | 103119 | 1855 | 84158 | 17106 | 31.7917 | -7.0926 | 2020-09-22 04:23:00 | Morocco | |||
1444757 | 1444757 | 2020-09-11 | Portugal | 62813 | 1855 | 43644 | 17314 | 39.3999 | -8.2245 | 2020-09-12 04:25:05 | Portugal | |||
1105302 | 1105302 | 2020-09-02 | Brazil | Piaui | 79719 | 1855 | 76441 | 635 | -7.7183 | -42.7289 | 2020-09-03 04:28:22 | Piaui, Brazil | ||
2304996 | 2304996 | 2020-06-28 | US | Massachusetts | Middlesex | 25017 | 23915 | 1855 | 0 | 22060 | 42.48607732 | -71.39049229 | 2020-06-29 04:33:44 | Middlesex, Massachusetts, 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]);