johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where deaths = 2901 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753572 | 2753572 | 2022-12-29 | US | Connecticut | Fairfield | 9001 | 256939 | 2901 | 0 | 41.26809896 | -73.3881171 | 2022-12-30 04:21:04 | Fairfield, Connecticut, US | |
1018338 | 1018338 | 2022-12-24 | Japan | Chiba | 1238442 | 2901 | 0 | 35.510141 | 140.198917 | 2022-12-25 04:21:04 | Chiba, Japan | |||
350582 | 350582 | 2022-12-14 | US | New York | Westchester | 36119 | 321403 | 2901 | 0 | 41.16278376 | -73.75741653 | 2022-12-15 04:20:58 | Westchester, New York, US | |
2024750 | 2024750 | 2022-10-17 | Japan | Hyogo | 1025304 | 2901 | 0 | 35.039913 | 134.828057 | 2022-10-18 04:22:42 | Hyogo, Japan | |||
1561696 | 1561696 | 2022-09-28 | US | Massachusetts | Essex | 25009 | 237906 | 2901 | 0 | 42.6687626 | -70.94687179 | 2022-09-29 04:22:34 | Essex, Massachusetts, US | |
3996239 | 3996239 | 2022-09-27 | US | Massachusetts | Essex | 25009 | 237906 | 2901 | 0 | 42.6687626 | -70.94687179 | 2022-09-28 04:23:01 | Essex, Massachusetts, US | |
2770567 | 2770567 | 2022-09-26 | US | Massachusetts | Essex | 25009 | 237906 | 2901 | 0 | 42.6687626 | -70.94687179 | 2022-09-27 04:23:01 | Essex, Massachusetts, US | |
1978220 | 1978220 | 2022-09-25 | US | Massachusetts | Essex | 25009 | 237906 | 2901 | 0 | 42.6687626 | -70.94687179 | 2022-09-26 04:20:52 | Essex, Massachusetts, US | |
2651387 | 2651387 | 2022-09-24 | US | Massachusetts | Essex | 25009 | 237906 | 2901 | 0 | 42.6687626 | -70.94687179 | 2022-09-25 04:23:31 | Essex, Massachusetts, US | |
385827 | 385827 | 2022-09-23 | US | Massachusetts | Essex | 25009 | 237906 | 2901 | 0 | 42.6687626 | -70.94687179 | 2022-09-24 04:21:40 | Essex, Massachusetts, US | |
1625893 | 1625893 | 2022-09-22 | US | Massachusetts | Essex | 25009 | 237906 | 2901 | 0 | 42.6687626 | -70.94687179 | 2022-09-23 04:23:13 | Essex, Massachusetts, US | |
3950457 | 3950457 | 2022-08-17 | Italy | Calabria | 519183 | 2901 | 0 | 38.90597598 | 16.59440194 | 2022-08-18 04:21:11 | Calabria, Italy | |||
961072 | 961072 | 2022-07-19 | US | New Jersey | Middlesex | 34023 | 228726 | 2901 | 0 | 40.43629879 | -74.41426991 | 2022-07-20 04:20:59 | Middlesex, New Jersey, US | |
3212459 | 3212459 | 2022-07-18 | US | New Jersey | Middlesex | 34023 | 228315 | 2901 | 0 | 40.43629879 | -74.41426991 | 2022-07-19 04:20:58 | Middlesex, New Jersey, US | |
3407634 | 3407634 | 2022-07-17 | US | New Jersey | Middlesex | 34023 | 228147 | 2901 | 0 | 40.43629879 | -74.41426991 | 2022-07-18 04:20:59 | Middlesex, New Jersey, US | |
2153834 | 2153834 | 2022-07-16 | US | New Jersey | Middlesex | 34023 | 227842 | 2901 | 0 | 40.43629879 | -74.41426991 | 2022-07-17 04:21:15 | Middlesex, New Jersey, US | |
2421067 | 2421067 | 2022-07-15 | US | New Jersey | Middlesex | 34023 | 227513 | 2901 | 0 | 40.43629879 | -74.41426991 | 2022-07-16 04:21:05 | Middlesex, New Jersey, US | |
3431142 | 3431142 | 2022-07-14 | US | New Jersey | Middlesex | 34023 | 227127 | 2901 | 0 | 40.43629879 | -74.41426991 | 2022-07-15 04:20:53 | Middlesex, New Jersey, US | |
3320224 | 3320224 | 2022-04-07 | Jamaica | 128950 | 2901 | 0 | 18.1096 | -77.2975 | 2022-04-08 04:20:48 | Jamaica | ||||
3022524 | 3022524 | 2022-03-23 | Russia | Smolensk Oblast | 126429 | 2901 | 0 | 55.03434960000001 | 33.0192065 | 2022-03-24 04:20:43 | Smolensk Oblast, Russia | |||
2321511 | 2321511 | 2022-03-16 | US | New Jersey | Ocean | 34029 | 160597 | 2901 | 0 | 39.8895449 | -74.28089251 | 2022-03-17 04:20:56 | Ocean, New Jersey, US | |
2140368 | 2140368 | 2022-03-09 | Russia | Buryatia Republic | 129248 | 2901 | 0 | 52.718242599999996 | 109.492143 | 2022-03-10 04:20:48 | Buryatia Republic, Russia | |||
1992876 | 1992876 | 2022-03-01 | Russia | Komi Republic | 157068 | 2901 | 0 | 63.9881421 | 54.3326073 | 2022-03-02 04:21:07 | Komi Republic, Russia | |||
979614 | 979614 | 2022-02-01 | US | Connecticut | Hartford | 9003 | 169889 | 2901 | 0 | 41.80283011 | -72.73103891 | 2022-02-02 04:21:09 | Hartford, Connecticut, US | |
2835477 | 2835477 | 2022-01-22 | US | Pennsylvania | Allegheny | 42003 | 239215 | 2901 | 0 | 40.46809875 | -79.98167747 | 2022-01-23 04:21:13 | Allegheny, Pennsylvania, US | |
2167896 | 2167896 | 2022-01-01 | Syria | 50310 | 2901 | 0 | 34.802075 | 38.99681500000001 | 2022-01-02 04:20:52 | Syria | ||||
786 | 786 | 2021-12-02 | US | Arizona | Pima | 4019 | 160397 | 2901 | 0 | 32.0971334 | -111.7890033 | 2021-12-03 04:23:05 | Pima, Arizona, US | |
715518 | 715518 | 2021-11-12 | US | Illinois | Unassigned | 90017 | 92 | 2901 | 0 | 42.36542373 | 0.0 | 2021-11-13 04:21:38 | Unassigned, Illinois, US | |
29468 | 29468 | 2021-11-11 | US | Illinois | Unassigned | 90017 | 90 | 2901 | 0 | 42.36542373 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Illinois, US | |
633671 | 633671 | 2021-10-13 | Canada | Alberta | 312285 | 2901 | 0 | 53.9333 | -116.5765 | 2021-10-14 04:21:29 | Alberta, Canada | |||
2959612 | 2959612 | 2021-10-08 | Russia | Penza Oblast | 72654 | 2901 | 0 | 53.1655415 | 44.78791810000001 | 2021-10-09 04:21:34 | Penza Oblast, Russia | |||
706743 | 706743 | 2021-09-29 | Sudan | 38245 | 2901 | 0 | 12.8628 | 30.2176 | 2021-09-30 04:21:20 | Sudan | ||||
331759 | 331759 | 2021-08-04 | Colombia | Narino | 87118 | 2901 | 82210 | 2007 | 1.2892 | -77.3579 | 2021-08-05 04:21:51 | Narino, Colombia | ||
3906134 | 3906134 | 2021-07-31 | US | New Jersey | Bergen | 34003 | 106588 | 2901 | 0 | 40.96010917 | -74.07164325 | 2021-08-01 04:21:50 | Bergen, New Jersey, US | |
1952687 | 1952687 | 2021-05-21 | Peru | Ucayali | 30933 | 2901 | 0 | 28032 | -9.621718 | -73.444929 | 2021-05-22 04:20:45 | Ucayali, Peru | ||
2004515 | 2004515 | 2021-05-12 | Colombia | Norte de Santander | 56782 | 2901 | 52706 | 1175 | 7.9463 | -72.8988 | 2021-05-13 04:20:51 | Norte de Santander, Colombia | ||
3242482 | 3242482 | 2021-04-21 | Peru | Cajamarca | 47716 | 2901 | 0 | 44815 | -6.430284 | -78.74559599999998 | 2021-04-22 04:20:53 | Cajamarca, Peru | ||
2575344 | 2575344 | 2021-04-13 | West Bank and Gaza | 272767 | 2901 | 237046 | 32820 | 31.9522 | 35.2332 | 2021-04-14 04:20:41 | West Bank and Gaza | |||
3962429 | 3962429 | 2021-03-10 | Germany | Berlin | 132339 | 2901 | 125226 | 4697 | 52.52 | 13.405 | 2021-03-11 05:25:48 | Berlin, Germany | ||
1089997 | 1089997 | 2021-03-03 | Germany | Thuringen | 77110 | 2901 | 69986 | 4897 | 51.011 | 10.8453 | 2021-03-04 05:24:24 | Thuringen, Germany | ||
471165 | 471165 | 2021-02-19 | Brazil | Sergipe | 147266 | 2901 | 135858 | 8507 | -10.5741 | -37.3857 | 2021-02-20 05:22:51 | Sergipe, Brazil | ||
1530159 | 1530159 | 2021-02-09 | US | New York | Suffolk | 36103 | 150426 | 2901 | 0 | 147525 | 40.88320119 | -72.8012172 | 2021-02-10 05:22:41 | Suffolk, New York, US |
3900049 | 3900049 | 2021-01-09 | Mexico | Michoacan | 34887 | 2901 | 0 | 31986 | 19.5665 | -101.7068 | 2021-01-10 05:22:12 | Michoacan, Mexico | ||
2541102 | 2541102 | 2021-01-07 | Armenia | 161054 | 2901 | 147388 | 10765 | 40.0691 | 45.0382 | 2021-01-08 05:22:42 | Armenia |
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]);