johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where deaths = 3192 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2100193 | 2100193 | 2022-11-26 | Malaysia | Sabah | 404306 | 3192 | 0 | 5.9788 | 116.0753 | 2022-11-27 04:21:05 | Sabah, Malaysia | |||
311797 | 311797 | 2022-11-13 | Germany | Hamburg | 766737 | 3192 | 0 | 53.5511 | 9.9937 | 2022-11-14 04:21:09 | Hamburg, Germany | |||
62958 | 62958 | 2022-11-12 | Germany | Hamburg | 766737 | 3192 | 0 | 53.5511 | 9.9937 | 2022-11-13 04:21:14 | Hamburg, Germany | |||
2927120 | 2927120 | 2022-11-11 | Germany | Hamburg | 766737 | 3192 | 0 | 53.5511 | 9.9937 | 2022-11-12 04:20:41 | Hamburg, Germany | |||
2506265 | 2506265 | 2022-11-10 | Russia | Ivanovo Oblast | 130095 | 3192 | 0 | 56.9167446 | 41.4352137 | 2022-11-11 04:21:22 | Ivanovo Oblast, Russia | |||
2096153 | 2096153 | 2022-08-27 | Kosovo | 271063 | 3192 | 0 | 42.602636 | 20.902977 | 2022-08-28 04:21:02 | Kosovo | ||||
1212219 | 1212219 | 2022-07-11 | US | Connecticut | Hartford | 9003 | 202165 | 3192 | 0 | 41.80283011 | -72.73103891 | 2022-07-12 04:20:51 | Hartford, Connecticut, US | |
2789701 | 2789701 | 2022-07-10 | US | Connecticut | Hartford | 9003 | 202075 | 3192 | 0 | 41.80283011 | -72.73103891 | 2022-07-11 04:20:46 | Hartford, Connecticut, US | |
142654 | 142654 | 2022-07-09 | US | Connecticut | Hartford | 9003 | 201969 | 3192 | 0 | 41.80283011 | -72.73103891 | 2022-07-10 04:20:54 | Hartford, Connecticut, US | |
1417754 | 1417754 | 2022-07-08 | US | Connecticut | Hartford | 9003 | 201772 | 3192 | 0 | 41.80283011 | -72.73103891 | 2022-07-09 04:20:59 | Hartford, Connecticut, US | |
2741679 | 2741679 | 2022-07-07 | US | Connecticut | Hartford | 9003 | 201520 | 3192 | 0 | 41.80283011 | -72.73103891 | 2022-07-08 04:20:56 | Hartford, Connecticut, US | |
947067 | 947067 | 2022-06-14 | Russia | Komi Republic | 172363 | 3192 | 0 | 63.9881421 | 54.3326073 | 2022-06-15 04:20:54 | Komi Republic, Russia | |||
2979475 | 2979475 | 2022-06-13 | Russia | Komi Republic | 172342 | 3192 | 0 | 63.9881421 | 54.3326073 | 2022-06-14 04:20:52 | Komi Republic, Russia | |||
2235601 | 2235601 | 2022-06-12 | Russia | Komi Republic | 172320 | 3192 | 0 | 63.9881421 | 54.3326073 | 2022-06-13 04:21:14 | Komi Republic, Russia | |||
3141799 | 3141799 | 2022-06-11 | Russia | Komi Republic | 172294 | 3192 | 0 | 63.9881421 | 54.3326073 | 2022-06-12 04:20:53 | Komi Republic, Russia | |||
1540258 | 1540258 | 2022-03-31 | Spain | Galicia | 580041 | 3192 | 0 | 42.5751 | -8.1339 | 2022-04-01 04:20:28 | Galicia, Spain | |||
2478271 | 2478271 | 2022-03-30 | Spain | Galicia | 580041 | 3192 | 0 | 42.5751 | -8.1339 | 2022-03-31 04:20:56 | Galicia, Spain | |||
158312 | 158312 | 2022-03-29 | Spain | Galicia | 580041 | 3192 | 0 | 42.5751 | -8.1339 | 2022-03-30 04:20:45 | Galicia, Spain | |||
2143167 | 2143167 | 2022-03-09 | US | Tennessee | Shelby | 47157 | 234641 | 3192 | 0 | 35.1864775 | -89.89692423 | 2022-03-10 04:20:48 | Shelby, Tennessee, US | |
71219 | 71219 | 2022-02-07 | Netherlands | Noord-Holland | 872343 | 3192 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-08 04:21:15 | Noord-Holland, Netherlands | |||
3998850 | 3998850 | 2021-12-30 | Russia | Dagestan Republic | 65791 | 3192 | 0 | 43.05749160000001 | 47.1332224 | 2021-12-31 04:21:50 | Dagestan Republic, Russia | |||
730361 | 730361 | 2021-12-27 | Colombia | Huila | 89717 | 3192 | 0 | 2.5359 | -75.5277 | 2021-12-28 04:21:47 | Huila, Colombia | |||
2111533 | 2111533 | 2021-12-26 | Colombia | Huila | 89668 | 3192 | 0 | 2.5359 | -75.5277 | 2021-12-27 04:21:58 | Huila, Colombia | |||
3832120 | 3832120 | 2021-12-21 | Ukraine | Zhytomyr Oblast | 139123 | 3192 | 0 | 50.2547 | 28.6587 | 2021-12-22 04:21:54 | Zhytomyr Oblast, Ukraine | |||
3828729 | 3828729 | 2021-12-21 | Russia | Udmurt Republic | 78291 | 3192 | 0 | 57.1961165 | 52.69598320000001 | 2021-12-22 04:21:54 | Udmurt Republic, Russia | |||
2903687 | 2903687 | 2021-12-19 | Italy | Marche | 133383 | 3192 | 0 | 43.61675973 | 13.5188753 | 2021-12-20 04:21:43 | Marche, Italy | |||
2400987 | 2400987 | 2021-12-17 | US | New Jersey | Essex | 34013 | 115900 | 3192 | 0 | 40.78681335 | -74.24657979 | 2021-12-18 02:22:20 | Essex, New Jersey, US | |
2127365 | 2127365 | 2021-10-21 | Uganda | 125426 | 3192 | 0 | 1.373333 | 32.290275 | 2021-10-22 04:21:14 | Uganda | ||||
3010119 | 3010119 | 2021-10-11 | US | Puerto Rico | Unassigned | 72999 | 4129 | 3192 | 0 | 18.459681 | -67.336525 | 2021-10-12 04:21:09 | Unassigned, Puerto Rico, US | |
1344535 | 1344535 | 2021-08-11 | US | New York | Nassau | 36059 | 190674 | 3192 | 0 | 40.74066522 | -73.58941873 | 2021-08-12 04:21:25 | Nassau, New York, US | |
3015201 | 3015201 | 2021-08-01 | Colombia | Magdalena | 88659 | 3192 | 84395 | 1072 | 10.4113 | -74.4057 | 2021-08-02 04:21:36 | Magdalena, Colombia | ||
2589756 | 2589756 | 2021-06-27 | Brazil | Tocantins | 196708 | 3192 | 175769 | 17561 | -10.1753 | -48.2982 | 2021-06-28 04:21:29 | Tocantins, Brazil | ||
2825012 | 2825012 | 2021-05-01 | Russia | Nizhny Novgorod Oblast | 114133 | 3192 | 109463 | 1478 | 55.47180329999999 | 44.0911594 | 2021-05-02 04:20:48 | Nizhny Novgorod Oblast, Russia | ||
3702020 | 3702020 | 2021-04-27 | Germany | Berlin | 165095 | 3192 | 153000 | 9858 | 52.52 | 13.405 | 2021-04-28 04:20:32 | Berlin, Germany | ||
3423934 | 3423934 | 2021-03-19 | US | Texas | Bexar | 48029 | 205852 | 3192 | 0 | 29.44928723 | -98.52019748 | 2021-03-20 05:25:46 | Bexar, Texas, US | |
2367191 | 2367191 | 2021-02-28 | Armenia | 172058 | 3192 | 163394 | 5472 | 40.0691 | 45.0382 | 2021-03-01 05:23:01 | Armenia | |||
3600800 | 3600800 | 2021-02-17 | Burma | 141690 | 3192 | 130944 | 7554 | 21.9162 | 95.956 | 2021-02-18 05:22:58 | Burma | |||
3049935 | 3049935 | 2021-02-16 | Burma | 141659 | 3192 | 130859 | 7608 | 21.9162 | 95.956 | 2021-02-17 05:23:10 | Burma | |||
1459751 | 1459751 | 2021-01-31 | Italy | Puglia | 122907 | 3192 | 66971 | 52744 | 41.12559576 | 16.86736689 | 2021-02-01 05:22:53 | Puglia, Italy | ||
2864649 | 2864649 | 2021-01-06 | Honduras | 124899 | 3192 | 57348 | 64359 | 15.2 | -86.2419 | 2021-01-07 05:22:03 | Honduras | |||
2406932 | 2406932 | 2020-12-23 | Mexico | Tamaulipas | 38435 | 3192 | 0 | 35243 | 24.2669 | -98.8363 | 2020-12-24 05:23:04 | Tamaulipas, Mexico | ||
10567 | 10567 | 2020-10-25 | US | New York | New York | 36061 | 34691 | 3192 | 0 | 31499 | 40.76727260000001 | -73.97152637 | 2020-10-26 04:25:02 | New York, New York, US |
3653804 | 3653804 | 2020-10-24 | US | New York | New York | 36061 | 34526 | 3192 | 0 | 31334 | 40.76727260000001 | -73.97152637 | 2020-10-25 04:24:36 | New York, New York, US |
1056059 | 1056059 | 2020-10-23 | US | New York | New York | 36061 | 34381 | 3192 | 0 | 31189 | 40.76727260000001 | -73.97152637 | 2020-10-24 04:24:46 | New York, New York, US |
2193834 | 2193834 | 2020-10-21 | US | New York | New York | 36061 | 34121 | 3192 | 0 | 30929 | 40.76727260000001 | -73.97152637 | 2020-10-22 04:24:27 | New York, New York, US |
3992845 | 3992845 | 2020-10-20 | US | New York | New York | 36061 | 34063 | 3192 | 0 | 30871 | 40.76727260000001 | -73.97152637 | 2020-10-21 04:24:14 | New York, New York, US |
1796865 | 1796865 | 2020-10-19 | US | New York | New York | 36061 | 33994 | 3192 | 0 | 30802 | 40.76727260000001 | -73.97152637 | 2020-10-20 04:24:22 | New York, New York, 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]);