johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69 rows where deaths = 2401 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 21
- US 23
- Russia 13
- Mexico 6
- Chile 4
- Spain 4
- Ukraine 3
- Peru 2
- Brazil 1
- Colombia 1
- Costa Rica 1
- Dominican Republic 1
- Germany 1
- India 1
- Italy 1
- Japan 1
- Kuwait 1
- Malaysia 1
- Montenegro 1
- North Macedonia 1
- Pakistan 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295583 | 295583 | 2022-11-15 | US | Wisconsin | Milwaukee | 55079 | 323925 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-16 04:21:09 | Milwaukee, Wisconsin, US | |
3600613 | 3600613 | 2022-11-14 | US | Wisconsin | Milwaukee | 55079 | 323768 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-15 04:21:16 | Milwaukee, Wisconsin, US | |
315471 | 315471 | 2022-11-13 | US | Wisconsin | Milwaukee | 55079 | 323453 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-14 04:21:09 | Milwaukee, Wisconsin, US | |
66632 | 66632 | 2022-11-12 | US | Wisconsin | Milwaukee | 55079 | 323453 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-13 04:21:14 | Milwaukee, Wisconsin, US | |
2930794 | 2930794 | 2022-11-11 | US | Wisconsin | Milwaukee | 55079 | 323453 | 2401 | 0 | 43.00486062 | -87.96733172 | 2022-11-12 04:20:41 | Milwaukee, Wisconsin, US | |
1368661 | 1368661 | 2022-10-28 | US | New Jersey | Passaic | 34031 | 176661 | 2401 | 0 | 41.03238628 | -74.29954144 | 2022-10-29 04:21:13 | Passaic, New Jersey, US | |
3547279 | 3547279 | 2022-09-01 | Chile | Los Lagos | 221758 | 2401 | 0 | -41.9198 | -72.1416 | 2022-09-02 04:21:07 | Los Lagos, Chile | |||
2343199 | 2343199 | 2022-08-31 | Chile | Los Lagos | 221758 | 2401 | 0 | -41.9198 | -72.1416 | 2022-09-01 04:21:03 | Los Lagos, Chile | |||
3773679 | 3773679 | 2022-08-30 | Chile | Los Lagos | 221556 | 2401 | 0 | -41.9198 | -72.1416 | 2022-08-31 04:20:57 | Los Lagos, Chile | |||
1680275 | 1680275 | 2022-08-29 | Chile | Los Lagos | 221432 | 2401 | 0 | -41.9198 | -72.1416 | 2022-08-30 04:21:03 | Los Lagos, Chile | |||
1161153 | 1161153 | 2022-08-18 | Japan | Aichi | 1037904 | 2401 | 0 | 35.035551 | 137.211621 | 2022-08-19 04:20:54 | Aichi, Japan | |||
3543795 | 3543795 | 2022-08-08 | Spain | Murcia | 451067 | 2401 | 0 | 37.9922 | -1.1307 | 2022-08-09 04:20:34 | Murcia, Spain | |||
1070198 | 1070198 | 2022-08-07 | Spain | Murcia | 451067 | 2401 | 0 | 37.9922 | -1.1307 | 2022-08-08 04:21:08 | Murcia, Spain | |||
1940786 | 1940786 | 2022-08-06 | Spain | Murcia | 451067 | 2401 | 0 | 37.9922 | -1.1307 | 2022-08-07 04:20:54 | Murcia, Spain | |||
880585 | 880585 | 2022-08-05 | Spain | Murcia | 451067 | 2401 | 0 | 37.9922 | -1.1307 | 2022-08-06 04:20:56 | Murcia, Spain | |||
1407735 | 1407735 | 2022-08-02 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-08-03 04:20:59 | Montgomery, Pennsylvania, US | |
3619773 | 3619773 | 2022-08-01 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-08-02 04:20:53 | Montgomery, Pennsylvania, US | |
3874253 | 3874253 | 2022-07-31 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-08-01 04:21:03 | Montgomery, Pennsylvania, US | |
3873826 | 3873826 | 2022-07-31 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-08-01 04:21:03 | Richmond, New York, US | |
677007 | 677007 | 2022-07-30 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-31 04:21:02 | Montgomery, Pennsylvania, US | |
676580 | 676580 | 2022-07-30 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-07-31 04:21:02 | Richmond, New York, US | |
1786206 | 1786206 | 2022-07-29 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-30 04:20:42 | Montgomery, Pennsylvania, US | |
1785779 | 1785779 | 2022-07-29 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-07-30 04:20:42 | Richmond, New York, US | |
1068569 | 1068569 | 2022-07-28 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-29 04:20:45 | Montgomery, Pennsylvania, US | |
1068142 | 1068142 | 2022-07-28 | US | New York | Richmond | 36085 | 191968 | 2401 | 0 | 40.58582155 | -74.14808598 | 2022-07-29 04:20:45 | Richmond, New York, US | |
2338088 | 2338088 | 2022-07-27 | US | Pennsylvania | Montgomery | 42091 | 174986 | 2401 | 0 | 40.21053671 | -75.36652296 | 2022-07-28 04:20:56 | Montgomery, Pennsylvania, US | |
3213927 | 3213927 | 2022-07-18 | Ukraine | Sevastopol* | 85277 | 2401 | 0 | 44.6054 | 33.522 | 2022-07-19 04:20:58 | Sevastopol*, Ukraine | |||
3409102 | 3409102 | 2022-07-17 | Ukraine | Sevastopol* | 85246 | 2401 | 0 | 44.6054 | 33.522 | 2022-07-18 04:20:59 | Sevastopol*, Ukraine | |||
2421076 | 2421076 | 2022-07-15 | US | New Jersey | Union | 34039 | 164551 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-16 04:21:05 | Union, New Jersey, US | |
3431151 | 3431151 | 2022-07-14 | US | New Jersey | Union | 34039 | 164271 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-15 04:20:53 | Union, New Jersey, US | |
3111671 | 3111671 | 2022-07-13 | US | New Jersey | Union | 34039 | 163998 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-14 04:20:57 | Union, New Jersey, US | |
632094 | 632094 | 2022-07-12 | US | New Jersey | Union | 34039 | 163761 | 2401 | 0 | 40.65835409 | -74.30680092 | 2022-07-13 04:20:58 | Union, New Jersey, US | |
2533650 | 2533650 | 2022-05-12 | Russia | Tambov Oblast | 116275 | 2401 | 0 | 52.9019574 | 41.3578918 | 2022-05-13 04:20:51 | Tambov Oblast, Russia | |||
3445096 | 3445096 | 2022-05-11 | Russia | Tambov Oblast | 116228 | 2401 | 0 | 52.9019574 | 41.3578918 | 2022-05-12 04:20:54 | Tambov Oblast, Russia | |||
2892628 | 2892628 | 2022-04-21 | Russia | Khakassia Republic | 87252 | 2401 | 0 | 53.72258845 | 91.44293627 | 2022-04-22 04:20:45 | Khakassia Republic, Russia | |||
2307500 | 2307500 | 2022-04-20 | Russia | Khakassia Republic | 87236 | 2401 | 0 | 53.72258845 | 91.44293627 | 2022-04-21 04:20:46 | Khakassia Republic, Russia | |||
2251639 | 2251639 | 2022-04-19 | Russia | Khakassia Republic | 87223 | 2401 | 0 | 53.72258845 | 91.44293627 | 2022-04-20 04:20:45 | Khakassia Republic, Russia | |||
3320462 | 3320462 | 2022-04-07 | Russia | Kursk Oblast | 114665 | 2401 | 0 | 51.6568453 | 36.4852695 | 2022-04-08 04:20:48 | Kursk Oblast, Russia | |||
1059422 | 1059422 | 2022-02-23 | US | Maryland | Baltimore | 24005 | 130249 | 2401 | 0 | 39.45784712 | -76.62911955 | 2022-02-24 04:21:14 | Baltimore, Maryland, US | |
2610297 | 2610297 | 2022-01-06 | Russia | Smolensk Oblast | 85452 | 2401 | 0 | 55.03434960000001 | 33.0192065 | 2022-01-07 04:22:09 | Smolensk Oblast, Russia | |||
3998841 | 3998841 | 2021-12-30 | Russia | Astrakhan Oblast | 80953 | 2401 | 0 | 47.1878186 | 47.608851 | 2021-12-31 04:21:50 | Astrakhan Oblast, Russia | |||
1668571 | 1668571 | 2021-12-29 | Montenegro | 166581 | 2401 | 0 | 42.708678000000006 | 19.37439 | 2021-12-30 04:21:25 | Montenegro | ||||
3655672 | 3655672 | 2021-12-10 | Mexico | Baja California Sur | 57352 | 2401 | 0 | 26.0444 | -111.6661 | 2021-12-11 04:22:45 | Baja California Sur, Mexico | |||
1078003 | 1078003 | 2021-12-09 | Mexico | Baja California Sur | 57352 | 2401 | 0 | 26.0444 | -111.6661 | 2021-12-10 04:22:28 | Baja California Sur, Mexico | |||
1014595 | 1014595 | 2021-11-21 | Russia | Vladimir Oblast | 69609 | 2401 | 0 | 56.0503336 | 40.656163299999996 | 2021-11-22 04:22:20 | Vladimir Oblast, Russia | |||
279824 | 279824 | 2021-11-03 | Ukraine | Poltava Oblast | 101748 | 2401 | 0 | 49.5883 | 34.5514 | 2021-11-04 04:22:20 | Poltava Oblast, Ukraine | |||
934863 | 934863 | 2021-10-16 | Malaysia | Sabah | 209556 | 2401 | 0 | 5.9788 | 116.0753 | 2021-10-17 04:21:29 | Sabah, Malaysia | |||
2923414 | 2923414 | 2021-08-27 | Russia | Leningrad Oblast | 62281 | 2401 | 0 | 60.185329599999996 | 32.3925325 | 2021-08-28 04:21:28 | Leningrad Oblast, Russia | |||
1854046 | 1854046 | 2021-08-20 | Kuwait | 407878 | 2401 | 0 | 29.311659999999996 | 47.481766 | 2021-08-21 04:21:38 | Kuwait | ||||
507879 | 507879 | 2021-08-14 | Russia | Chelyabinsk Oblast | 78503 | 2401 | 0 | 54.4223954 | 61.1865846 | 2021-08-15 04:21:41 | Chelyabinsk Oblast, Russia | |||
3015193 | 3015193 | 2021-08-01 | Colombia | Cesar | 86578 | 2401 | 82812 | 1365 | 9.3373 | -73.6536 | 2021-08-02 04:21:36 | Cesar, Colombia | ||
3574670 | 3574670 | 2021-05-17 | Mexico | Aguascalientes | 26344 | 2401 | 0 | 23943 | 21.8853 | -102.2916 | 2021-05-18 04:20:33 | Aguascalientes, Mexico | ||
2939400 | 2939400 | 2021-05-16 | Mexico | Aguascalientes | 26338 | 2401 | 0 | 23937 | 21.8853 | -102.2916 | 2021-05-17 04:20:34 | Aguascalientes, Mexico | ||
1873030 | 1873030 | 2021-05-15 | Mexico | Aguascalientes | 26338 | 2401 | 0 | 23937 | 21.8853 | -102.2916 | 2021-05-16 04:20:49 | Aguascalientes, Mexico | ||
1081999 | 1081999 | 2021-05-14 | Mexico | Aguascalientes | 26322 | 2401 | 0 | 23921 | 21.8853 | -102.2916 | 2021-05-15 04:20:58 | Aguascalientes, Mexico | ||
638184 | 638184 | 2021-03-31 | Russia | Voronezh Oblast | 75155 | 2401 | 69769 | 2985 | 50.9800393 | 40.15065070000001 | 2021-04-01 04:27:05 | Voronezh Oblast, Russia | ||
3421089 | 3421089 | 2021-03-19 | Peru | Puno | 25149 | 2401 | 0 | 22748 | -14.995826999999998 | -69.922726 | 2021-03-20 05:25:46 | Puno, Peru | ||
3879445 | 3879445 | 2021-01-14 | Costa Rica | 183242 | 2401 | 140573 | 40268 | 9.7489 | -83.7534 | 2021-01-15 05:22:24 | Costa Rica | |||
1139121 | 1139121 | 2021-01-01 | US | New York | Nassau | 36059 | 89460 | 2401 | 0 | 87059 | 40.74066522 | -73.58941873 | 2021-01-02 05:22:33 | Nassau, New York, US |
202392 | 202392 | 2020-12-25 | North Macedonia | 80896 | 2401 | 58182 | 20313 | 41.6086 | 21.7453 | 2020-12-26 05:22:28 | North Macedonia | |||
2406713 | 2406713 | 2020-12-23 | Dominican Republic | 162496 | 2401 | 125965 | 34130 | 18.7357 | -70.1627 | 2020-12-24 05:23:04 | Dominican Republic | |||
2930976 | 2930976 | 2020-12-19 | Brazil | Sergipe | 103042 | 2401 | 89603 | 11038 | -10.5741 | -37.3857 | 2020-12-20 05:27:32 | Sergipe, Brazil | ||
3566514 | 3566514 | 2020-11-29 | India | Haryana | 232522 | 2401 | 211216 | 18905 | 29.20004 | 76.332824 | 2020-11-30 05:26:13 | Haryana, India | ||
2079930 | 2079930 | 2020-10-31 | Italy | Veneto | 56953 | 2401 | 25373 | 29179 | 45.43490485 | 12.33845213 | 2020-11-01 04:36:19 | Veneto, Italy | ||
194210 | 194210 | 2020-08-31 | Pakistan | Sindh | 129348 | 2401 | 122939 | 4008 | 26.009446 | 68.77680699999999 | 2020-09-01 04:28:31 | Sindh, Pakistan | ||
1523420 | 1523420 | 2020-08-28 | Russia | Saint Petersburg | 36104 | 2401 | 25530 | 8173 | 59.9606739 | 30.158655100000004 | 2020-08-29 04:28:19 | Saint Petersburg, Russia | ||
458502 | 458502 | 2020-08-07 | Peru | Ica | 14406 | 2401 | 0 | 12005 | -14.235097 | -75.574821 | 2020-08-08 04:34:53 | Ica, Peru | ||
737769 | 737769 | 2020-06-12 | United Kingdom | Wales | 14658 | 2401 | 0 | 13223 | 52.1307 | -3.7837 | 2020-06-13 03:33:14 | Wales, United Kingdom | ||
1041109 | 1041109 | 2020-05-26 | Germany | Bayern | 46456 | 2401 | 42100 | 2226 | 48.7904 | 11.4979 | 2020-05-27 02:32:31 | Bayern, Germany |
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]);