johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where deaths = 2699 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1620329 | 1620329 | 2022-11-22 | Malaysia | Kedah | 314704 | 2699 | 0 | 6.1184 | 100.3685 | 2022-11-23 04:21:06 | Kedah, Malaysia | |||
2159310 | 2159310 | 2022-10-16 | Chile | OHiggins | 200114 | 2699 | 0 | -34.5755 | -71.0022 | 2022-10-17 04:20:31 | OHiggins, Chile | |||
965377 | 965377 | 2022-09-09 | US | Ohio | Franklin | 39049 | 336627 | 2699 | 0 | 39.96995815 | -83.01115755 | 2022-09-10 04:21:10 | Franklin, Ohio, US | |
255779 | 255779 | 2022-09-08 | US | Ohio | Franklin | 39049 | 336627 | 2699 | 0 | 39.96995815 | -83.01115755 | 2022-09-09 04:21:11 | Franklin, Ohio, US | |
3429045 | 3429045 | 2022-07-14 | Mexico | Baja California Sur | 116020 | 2699 | 0 | 26.0444 | -111.6661 | 2022-07-15 04:20:53 | Baja California Sur, Mexico | |||
3109565 | 3109565 | 2022-07-13 | Mexico | Baja California Sur | 115614 | 2699 | 0 | 26.0444 | -111.6661 | 2022-07-14 04:20:57 | Baja California Sur, Mexico | |||
629988 | 629988 | 2022-07-12 | Mexico | Baja California Sur | 115232 | 2699 | 0 | 26.0444 | -111.6661 | 2022-07-13 04:20:58 | Baja California Sur, Mexico | |||
2791270 | 2791270 | 2022-07-10 | US | New York | Erie | 36029 | 238859 | 2699 | 0 | 42.76249024 | -78.73063652 | 2022-07-11 04:20:46 | Erie, New York, US | |
144223 | 144223 | 2022-07-09 | US | New York | Erie | 36029 | 238724 | 2699 | 0 | 42.76249024 | -78.73063652 | 2022-07-10 04:20:54 | Erie, New York, US | |
1419323 | 1419323 | 2022-07-08 | US | New York | Erie | 36029 | 238580 | 2699 | 0 | 42.76249024 | -78.73063652 | 2022-07-09 04:20:59 | Erie, New York, US | |
2743248 | 2743248 | 2022-07-07 | US | New York | Erie | 36029 | 238182 | 2699 | 0 | 42.76249024 | -78.73063652 | 2022-07-08 04:20:56 | Erie, New York, US | |
1202043 | 1202043 | 2022-07-06 | US | New York | Erie | 36029 | 238182 | 2699 | 0 | 42.76249024 | -78.73063652 | 2022-07-07 04:20:55 | Erie, New York, US | |
1227045 | 1227045 | 2022-04-14 | US | Washington | King | 53033 | 382597 | 2699 | 0 | 47.49137892 | -121.8346131 | 2022-04-15 04:20:57 | King, Washington, US | |
3320905 | 3320905 | 2022-04-07 | US | Connecticut | Fairfield | 9001 | 203279 | 2699 | 0 | 41.26809896 | -73.3881171 | 2022-04-08 04:20:48 | Fairfield, Connecticut, US | |
3320497 | 3320497 | 2022-04-07 | Russia | Tver Oblast | 158303 | 2699 | 0 | 57.1134475 | 35.174442799999994 | 2022-04-08 04:20:48 | Tver Oblast, Russia | |||
2801441 | 2801441 | 2022-04-06 | US | Connecticut | Fairfield | 9001 | 203001 | 2699 | 0 | 41.26809896 | -73.3881171 | 2022-04-07 04:20:53 | Fairfield, Connecticut, US | |
2801033 | 2801033 | 2022-04-06 | Russia | Tver Oblast | 158143 | 2699 | 0 | 57.1134475 | 35.174442799999994 | 2022-04-07 04:20:53 | Tver Oblast, Russia | |||
3868210 | 3868210 | 2022-04-05 | US | Connecticut | Fairfield | 9001 | 202854 | 2699 | 0 | 41.26809896 | -73.3881171 | 2022-04-06 04:20:49 | Fairfield, Connecticut, US | |
3867802 | 3867802 | 2022-04-05 | Russia | Tver Oblast | 157978 | 2699 | 0 | 57.1134475 | 35.174442799999994 | 2022-04-06 04:20:49 | Tver Oblast, Russia | |||
1436697 | 1436697 | 2022-03-28 | Montenegro | 232832 | 2699 | 0 | 42.708678000000006 | 19.37439 | 2022-03-29 04:20:46 | Montenegro | ||||
1722765 | 1722765 | 2022-03-25 | US | New York | Westchester | 36119 | 249290 | 2699 | 0 | 41.16278376 | -73.75741653 | 2022-03-26 04:20:23 | Westchester, New York, US | |
1470382 | 1470382 | 2022-03-24 | US | New York | Westchester | 36119 | 249121 | 2699 | 0 | 41.16278376 | -73.75741653 | 2022-03-25 04:20:46 | Westchester, New York, US | |
3024556 | 3024556 | 2022-03-23 | US | New York | Westchester | 36119 | 248832 | 2699 | 0 | 41.16278376 | -73.75741653 | 2022-03-24 04:20:43 | Westchester, New York, US | |
1865603 | 1865603 | 2022-03-10 | Netherlands | Gelderland | 833676 | 2699 | 0 | 52.061738 | 5.939114 | 2022-03-11 04:20:50 | Gelderland, Netherlands | |||
3912688 | 3912688 | 2022-02-20 | US | Connecticut | New Haven | 9009 | 189204 | 2699 | 0 | 41.408032500000004 | -72.93620426 | 2022-02-21 04:21:05 | New Haven, Connecticut, US | |
3876246 | 3876246 | 2022-02-19 | US | Connecticut | New Haven | 9009 | 189204 | 2699 | 0 | 41.408032500000004 | -72.93620426 | 2022-02-20 04:21:00 | New Haven, Connecticut, US | |
3856502 | 3856502 | 2022-02-18 | US | Connecticut | New Haven | 9009 | 189204 | 2699 | 0 | 41.408032500000004 | -72.93620426 | 2022-02-19 04:21:11 | New Haven, Connecticut, US | |
1362336 | 1362336 | 2022-02-08 | Jamaica | 126350 | 2699 | 0 | 18.1096 | -77.2975 | 2022-02-09 04:21:04 | Jamaica | ||||
554752 | 554752 | 2022-01-16 | Italy | Abruzzo | 166438 | 2699 | 0 | 42.35122196 | 13.39843823 | 2022-01-17 04:21:08 | Abruzzo, Italy | |||
722831 | 722831 | 2021-11-20 | Syria | 47091 | 2699 | 0 | 34.802075 | 38.99681500000001 | 2021-11-21 04:22:13 | Syria | ||||
714506 | 714506 | 2021-11-12 | Kyrgyzstan | 182197 | 2699 | 0 | 41.20438 | 74.766098 | 2021-11-13 04:21:38 | Kyrgyzstan | ||||
276346 | 276346 | 2021-11-03 | Peru | Huanuco | 35699 | 2699 | 0 | -9.421676 | -76.040642 | 2021-11-04 04:22:20 | Huanuco, Peru | |||
43871 | 43871 | 2021-11-02 | Peru | Huanuco | 35699 | 2699 | 0 | -9.421676 | -76.040642 | 2021-11-03 06:22:09 | Huanuco, Peru | |||
289654 | 289654 | 2021-10-31 | US | Michigan | Macomb | 26099 | 122253 | 2699 | 0 | 42.69158356 | -82.92752801 | 2021-11-01 04:22:01 | Macomb, Michigan, US | |
2722660 | 2722660 | 2021-10-30 | US | Michigan | Macomb | 26099 | 122253 | 2699 | 0 | 42.69158356 | -82.92752801 | 2021-10-31 04:22:08 | Macomb, Michigan, US | |
568762 | 568762 | 2021-10-29 | US | Michigan | Macomb | 26099 | 122253 | 2699 | 0 | 42.69158356 | -82.92752801 | 2021-10-30 04:22:03 | Macomb, Michigan, US | |
534506 | 534506 | 2021-10-27 | Chile | Biobio | 153002 | 2699 | 0 | -37.4464 | -72.1416 | 2021-10-28 04:22:08 | Biobio, Chile | |||
3491943 | 3491943 | 2021-10-26 | Chile | Biobio | 152923 | 2699 | 0 | -37.4464 | -72.1416 | 2021-10-27 04:22:32 | Biobio, Chile | |||
3793756 | 3793756 | 2021-10-25 | Denmark | 377825 | 2699 | 0 | 56.2639 | 9.5018 | 2021-10-26 04:22:09 | Denmark | ||||
3793665 | 3793665 | 2021-10-25 | Chile | Biobio | 152862 | 2699 | 0 | -37.4464 | -72.1416 | 2021-10-26 04:22:09 | Biobio, Chile | |||
682202 | 682202 | 2021-10-24 | Denmark | 376414 | 2699 | 0 | 56.2639 | 9.5018 | 2021-10-25 04:22:31 | Denmark | ||||
249516 | 249516 | 2021-09-04 | Russia | Novosibirsk Oblast | 59181 | 2699 | 0 | 54.9720169 | 79.48139240000002 | 2021-09-05 04:21:33 | Novosibirsk Oblast, Russia | |||
2068030 | 2068030 | 2021-08-31 | Netherlands | Noord-Holland | 335690 | 2699 | 0 | 52.60090600000001 | 4.9186879999999995 | 2021-09-01 04:21:38 | Noord-Holland, Netherlands | |||
1775611 | 1775611 | 2021-08-30 | Russia | Tula Oblast | 51248 | 2699 | 0 | 53.9570701 | 37.369090899999996 | 2021-08-31 04:21:46 | Tula Oblast, Russia | |||
332152 | 332152 | 2021-08-04 | Russia | Samara Oblast | 78167 | 2699 | 71661 | 3807 | 53.2128813 | 50.8914633 | 2021-08-05 04:21:51 | Samara Oblast, Russia | ||
3113745 | 3113745 | 2021-05-06 | Russia | Voronezh Oblast | 81463 | 2699 | 76858 | 1906 | 50.9800393 | 40.15065070000001 | 2021-05-07 04:20:40 | Voronezh Oblast, Russia | ||
3883695 | 3883695 | 2021-04-11 | Mexico | Zacatecas | 29300 | 2699 | 0 | 26601 | 22.7709 | -102.5832 | 2021-04-12 04:21:00 | Zacatecas, Mexico | ||
2983363 | 2983363 | 2021-04-10 | Mexico | Zacatecas | 29275 | 2699 | 0 | 26576 | 22.7709 | -102.5832 | 2021-04-11 04:20:56 | Zacatecas, Mexico | ||
3710815 | 3710815 | 2021-04-03 | US | Florida | Broward | 12011 | 217060 | 2699 | 0 | 26.15184651 | -80.48725556 | 2021-04-04 04:20:49 | Broward, Florida, US | |
1857859 | 1857859 | 2021-02-25 | Colombia | Norte de Santander | 50635 | 2699 | 47151 | 785 | 7.9463 | -72.8988 | 2021-02-26 05:22:40 | Norte de Santander, Colombia | ||
976511 | 976511 | 2021-02-06 | US | Massachusetts | Middlesex | 25017 | 104730 | 2699 | 0 | 101528 | 42.48607732 | -71.39049229 | 2021-02-07 05:23:00 | Middlesex, Massachusetts, US |
860624 | 860624 | 2020-12-11 | India | Haryana | 250394 | 2699 | 237009 | 10686 | 29.20004 | 76.332824 | 2020-12-12 05:26:19 | Haryana, India | ||
2537714 | 2537714 | 2020-12-01 | Sweden | Stockholm | 76802 | 2699 | 0 | 74103 | 59.6025 | 18.1384 | 2020-12-02 05:27:41 | Stockholm, Sweden | ||
3566315 | 3566315 | 2020-11-29 | Brazil | Rio Grande do Norte | 95556 | 2699 | 48736 | 43060 | -5.4026 | -36.9541 | 2020-11-30 05:26:13 | Rio Grande do Norte, Brazil | ||
272132 | 272132 | 2020-11-10 | Israel | 320811 | 2699 | 308145 | 9967 | 31.046051 | 34.851612 | 2020-11-11 05:25:30 | Israel | |||
344374 | 344374 | 2020-09-14 | Mexico | Tabasco | 30127 | 2699 | 26587 | 841 | 17.8409 | -92.6189 | 2020-09-15 03:22:50 | Tabasco, Mexico | ||
2868813 | 2868813 | 2020-09-13 | Mexico | Tabasco | 30045 | 2699 | 26373 | 973 | 17.8409 | -92.6189 | 2020-09-14 04:26:00 | Tabasco, Mexico | ||
427434 | 427434 | 2020-09-07 | Mexico | Sonora | 22307 | 2699 | 18878 | 730 | 29.2972 | -110.3309 | 2020-09-08 04:28:25 | Sonora, Mexico | ||
1920196 | 1920196 | 2020-08-10 | Colombia | Atlantico | 58634 | 2699 | 45918 | 10017 | 10.6966 | -74.8741 | 2020-08-11 04:35:08 | Atlantico, Colombia |
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]);