johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56 rows where deaths = 2323 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2179779 | 2179779 | 2022-12-22 | Russia | Belgorod Oblast | 164443 | 2323 | 0 | 50.7080119 | 37.5837615 | 2022-12-23 04:21:04 | Belgorod Oblast, Russia | |||
451583 | 451583 | 2022-12-21 | Russia | Belgorod Oblast | 164417 | 2323 | 0 | 50.7080119 | 37.5837615 | 2022-12-22 04:20:56 | Belgorod Oblast, Russia | |||
2951582 | 2951582 | 2022-12-20 | Russia | Belgorod Oblast | 164394 | 2323 | 0 | 50.7080119 | 37.5837615 | 2022-12-21 04:21:03 | Belgorod Oblast, Russia | |||
3173984 | 3173984 | 2022-12-19 | Russia | Belgorod Oblast | 164370 | 2323 | 0 | 50.7080119 | 37.5837615 | 2022-12-20 04:21:04 | Belgorod Oblast, Russia | |||
145640 | 145640 | 2022-07-09 | United Arab Emirates | 961345 | 2323 | 0 | 23.424076 | 53.847818 | 2022-07-10 04:20:54 | United Arab Emirates | ||||
2242967 | 2242967 | 2022-06-28 | US | Wisconsin | Milwaukee | 55079 | 292254 | 2323 | 0 | 43.00486062 | -87.96733172 | 2022-06-29 04:20:59 | Milwaukee, Wisconsin, US | |
2151209 | 2151209 | 2022-06-27 | US | Wisconsin | Milwaukee | 55079 | 292048 | 2323 | 0 | 43.00486062 | -87.96733172 | 2022-06-28 04:20:58 | Milwaukee, Wisconsin, US | |
559389 | 559389 | 2022-06-16 | US | California | Santa Clara | 6085 | 381542 | 2323 | 0 | 37.23104908 | -121.6970462 | 2022-06-17 04:20:56 | Santa Clara, California, US | |
3983191 | 3983191 | 2022-06-15 | US | California | Santa Clara | 6085 | 379882 | 2323 | 0 | 37.23104908 | -121.6970462 | 2022-06-16 04:20:55 | Santa Clara, California, US | |
947432 | 947432 | 2022-06-14 | US | California | Santa Clara | 6085 | 379838 | 2323 | 0 | 37.23104908 | -121.6970462 | 2022-06-15 04:20:54 | Santa Clara, California, US | |
2598260 | 2598260 | 2022-05-05 | Russia | Kemerovo Oblast | 162097 | 2323 | 0 | 54.5335781 | 87.342861 | 2022-05-06 04:21:00 | Kemerovo Oblast, Russia | |||
1698598 | 1698598 | 2022-04-28 | US | New York | Richmond | 36085 | 169107 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-29 04:20:59 | Richmond, New York, US | |
3854081 | 3854081 | 2022-04-27 | US | New York | Richmond | 36085 | 168888 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-28 04:20:47 | Richmond, New York, US | |
1328511 | 1328511 | 2022-04-26 | US | New York | Richmond | 36085 | 168734 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-27 04:20:52 | Richmond, New York, US | |
3724465 | 3724465 | 2022-04-25 | US | New York | Richmond | 36085 | 168630 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-26 04:20:51 | Richmond, New York, US | |
2031033 | 2031033 | 2022-04-24 | US | New York | Richmond | 36085 | 168166 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-25 04:20:56 | Richmond, New York, US | |
748608 | 748608 | 2022-04-23 | US | New York | Richmond | 36085 | 168166 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-24 04:20:56 | Richmond, New York, US | |
3439093 | 3439093 | 2022-04-22 | US | New York | Richmond | 36085 | 168166 | 2323 | 0 | 40.58582155 | -74.14808598 | 2022-04-23 04:20:50 | Richmond, New York, US | |
1224151 | 1224151 | 2022-04-14 | US | California | Kern | 6029 | 242803 | 2323 | 0 | 35.34329425 | -118.72777959999999 | 2022-04-15 04:20:57 | Kern, California, US | |
2443309 | 2443309 | 2022-04-13 | US | California | Kern | 6029 | 242803 | 2323 | 0 | 35.34329425 | -118.72777959999999 | 2022-04-13 23:21:06 | Kern, California, US | |
2443024 | 2443024 | 2022-04-13 | Russia | Zabaykalsky Krai | 167162 | 2323 | 0 | 52.248521000000004 | 115.956325 | 2022-04-13 23:21:06 | Zabaykalsky Krai, Russia | |||
1949066 | 1949066 | 2022-04-12 | US | California | Kern | 6029 | 242803 | 2323 | 0 | 35.34329425 | -118.72777959999999 | 2022-04-13 04:21:03 | Kern, California, US | |
2800682 | 2800682 | 2022-04-06 | Germany | Schleswig-Holstein | 537098 | 2323 | 0 | 54.2194 | 9.6961 | 2022-04-07 04:20:53 | Schleswig-Holstein, Germany | |||
356548 | 356548 | 2022-03-11 | Russia | Kursk Oblast | 109896 | 2323 | 0 | 51.6568453 | 36.4852695 | 2022-03-12 04:20:50 | Kursk Oblast, Russia | |||
319562 | 319562 | 2022-02-12 | Ukraine | Ternopil Oblast | 140651 | 2323 | 0 | 49.5535 | 25.5948 | 2022-02-13 04:21:00 | Ternopil Oblast, Ukraine | |||
72663 | 72663 | 2022-02-07 | US | Maryland | Baltimore | 24005 | 128996 | 2323 | 0 | 39.45784712 | -76.62911955 | 2022-02-08 04:21:15 | Baltimore, Maryland, US | |
2014279 | 2014279 | 2022-02-06 | US | Maryland | Baltimore | 24005 | 128905 | 2323 | 0 | 39.45784712 | -76.62911955 | 2022-02-07 04:21:05 | Baltimore, Maryland, US | |
2327543 | 2327543 | 2022-02-04 | Peru | Unknown | 499638 | 2323 | 0 | 2022-02-05 04:21:05 | Unknown, Peru | |||||
150108 | 150108 | 2021-11-29 | Netherlands | Gelderland | 301803 | 2323 | 0 | 52.061738 | 5.939114 | 2021-11-30 04:22:53 | Gelderland, Netherlands | |||
451015 | 451015 | 2021-11-17 | Ukraine | Sumy Oblast | 119744 | 2323 | 0 | 50.9077 | 34.7981 | 2021-11-18 04:21:33 | Sumy Oblast, Ukraine | |||
535307 | 535307 | 2021-10-27 | US | California | Sacramento | 6067 | 161319 | 2323 | 0 | 38.45106826 | -121.34253740000001 | 2021-10-28 04:22:08 | Sacramento, California, US | |
685966 | 685966 | 2021-10-24 | Ukraine | Chernivtsi Oblast | 102128 | 2323 | 0 | 48.2917 | 25.9352 | 2021-10-25 04:22:31 | Chernivtsi Oblast, Ukraine | |||
936978 | 936978 | 2021-10-16 | US | New Jersey | Ocean | 34029 | 93253 | 2323 | 0 | 39.8895449 | -74.28089251 | 2021-10-17 04:21:29 | Ocean, New Jersey, US | |
178287 | 178287 | 2021-09-02 | Russia | Volgograd Oblast | 82417 | 2323 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-03 04:21:20 | Volgograd Oblast, Russia | |||
2068150 | 2068150 | 2021-08-31 | Russia | Saratov Oblast | 80831 | 2323 | 0 | 51.652055499999996 | 46.86319520000001 | 2021-09-01 04:21:38 | Saratov Oblast, Russia | |||
1344458 | 1344458 | 2021-08-11 | US | New Jersey | Hudson | 34017 | 90479 | 2323 | 0 | 40.73766234 | -74.07515667 | 2021-08-12 04:21:25 | Hudson, New Jersey, US | |
1958491 | 1958491 | 2021-08-05 | US | Missouri | St. Louis | 29189 | 109887 | 2323 | 0 | 38.63770039999999 | -90.4458375 | 2021-08-06 04:21:18 | St. Louis, Missouri, US | |
24012 | 24012 | 2021-05-28 | Ukraine | Zaporizhia Oblast | 102471 | 2323 | 94730 | 5418 | 47.8388 | 35.1396 | 2021-05-29 04:20:41 | Zaporizhia Oblast, Ukraine | ||
726555 | 726555 | 2021-05-22 | Latvia | 130712 | 2323 | 121123 | 7266 | 56.8796 | 24.6032 | 2021-05-23 04:20:51 | Latvia | |||
2939485 | 2939485 | 2021-05-16 | Peru | Huanuco | 31026 | 2323 | 0 | 28703 | -9.421676 | -76.040642 | 2021-05-17 04:20:34 | Huanuco, Peru | ||
2763696 | 2763696 | 2021-05-03 | US | Puerto Rico | Unassigned | 72999 | 3900 | 2323 | 0 | 18.459681 | -67.336525 | 2021-05-04 04:20:34 | Unassigned, Puerto Rico, US | |
3643848 | 3643848 | 2021-03-30 | Spain | Galicia | 116361 | 2323 | 9204 | 104834 | 42.5751 | -8.1339 | 2021-03-31 04:26:25 | Galicia, Spain | ||
1980771 | 1980771 | 2021-03-25 | Peru | Cajamarca | 38801 | 2323 | 0 | 36478 | -6.430284 | -78.74559599999998 | 2021-03-26 05:26:55 | Cajamarca, Peru | ||
1588098 | 1588098 | 2021-02-05 | Germany | Thuringen | 67743 | 2323 | 59101 | 6774 | 51.011 | 10.8453 | 2021-02-06 05:23:55 | Thuringen, Germany | ||
1097195 | 1097195 | 2021-01-20 | US | Texas | Hidalgo | 48215 | 66320 | 2323 | 0 | 56431 | 26.39418217 | -98.18299696 | 2021-01-21 05:22:01 | Hidalgo, Texas, US |
3101678 | 3101678 | 2021-01-16 | Russia | Rostov Oblast | 57921 | 2323 | 47918 | 7680 | 47.6222451 | 40.7957942 | 2021-01-17 05:22:17 | Rostov Oblast, Russia | ||
3515498 | 3515498 | 2021-01-15 | Mexico | Queretaro | 37319 | 2323 | 0 | 34996 | 20.5888 | -100.3899 | 2021-01-16 05:22:40 | Queretaro, Mexico | ||
1136989 | 1136989 | 2021-01-01 | Mexico | Yucatan | 26748 | 2323 | 0 | 24425 | 20.7099 | -89.0943 | 2021-01-02 05:22:33 | Yucatan, Mexico | ||
2537502 | 2537502 | 2020-12-01 | Moldova | 108863 | 2323 | 95918 | 10622 | 47.4116 | 28.3699 | 2020-12-02 05:27:41 | Moldova | |||
1544023 | 1544023 | 2020-11-07 | Mexico | Chihuahua | 20884 | 2323 | 16748 | 1813 | 28.633000000000006 | -106.0691 | 2020-11-08 05:24:56 | Chihuahua, Mexico | ||
2191741 | 2191741 | 2020-10-21 | Pakistan | Punjab | 102107 | 2323 | 97289 | 2495 | 30.811346 | 72.13913199999998 | 2020-10-22 04:24:27 | Punjab, Pakistan | ||
2191576 | 2191576 | 2020-10-21 | Israel | 307569 | 2323 | 283147 | 22099 | 31.046051 | 34.851612 | 2020-10-22 04:24:27 | Israel | |||
966830 | 966830 | 2020-09-29 | Honduras | 76098 | 2323 | 27383 | 46392 | 15.2 | -86.2419 | 2020-09-30 04:23:33 | Honduras | |||
2614178 | 2614178 | 2020-09-26 | Panama | 110108 | 2323 | 86796 | 20989 | 8.538 | -80.7821 | 2020-09-27 04:23:00 | Panama | |||
546503 | 546503 | 2020-09-12 | Brazil | Rio Grande do Norte | 65521 | 2323 | 39207 | 23525 | -5.4026 | -36.9541 | 2020-09-13 04:30:52 | Rio Grande do Norte, Brazil | ||
1864569 | 1864569 | 2020-05-22 | US | Michigan | Wayne | 26163 | 19602 | 2323 | 0 | 17279 | 42.28098405 | -83.281255 | 2020-05-23 02:32:42 | Wayne, Michigan, 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]);