johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where deaths = 3025 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3250112 | 3250112 | 2022-10-11 | Italy | Calabria | 567289 | 3025 | 0 | 38.90597598 | 16.59440194 | 2022-10-12 04:22:51 | Calabria, Italy | |||
1783706 | 1783706 | 2022-07-29 | Russia | Astrakhan Oblast | 119695 | 3025 | 0 | 47.1878186 | 47.608851 | 2022-07-30 04:20:42 | Astrakhan Oblast, Russia | |||
1066069 | 1066069 | 2022-07-28 | Russia | Astrakhan Oblast | 119579 | 3025 | 0 | 47.1878186 | 47.608851 | 2022-07-29 04:20:45 | Astrakhan Oblast, Russia | |||
960010 | 960010 | 2022-07-19 | US | Indiana | Marion | 18097 | 239944 | 3025 | 0 | 39.78163624 | -86.13826325 | 2022-07-20 04:20:59 | Marion, Indiana, US | |
3211397 | 3211397 | 2022-07-18 | US | Indiana | Marion | 18097 | 239485 | 3025 | 0 | 39.78163624 | -86.13826325 | 2022-07-19 04:20:58 | Marion, Indiana, US | |
3406572 | 3406572 | 2022-07-17 | US | Indiana | Marion | 18097 | 238857 | 3025 | 0 | 39.78163624 | -86.13826325 | 2022-07-18 04:20:59 | Marion, Indiana, US | |
2152772 | 2152772 | 2022-07-16 | US | Indiana | Marion | 18097 | 238857 | 3025 | 0 | 39.78163624 | -86.13826325 | 2022-07-17 04:21:15 | Marion, Indiana, US | |
2420005 | 2420005 | 2022-07-15 | US | Indiana | Marion | 18097 | 238857 | 3025 | 0 | 39.78163624 | -86.13826325 | 2022-07-16 04:21:05 | Marion, Indiana, US | |
168224 | 168224 | 2022-06-21 | US | New Jersey | Ocean | 34029 | 177190 | 3025 | 0 | 39.8895449 | -74.28089251 | 2022-06-22 04:20:54 | Ocean, New Jersey, US | |
1765507 | 1765507 | 2022-06-20 | US | New Jersey | Ocean | 34029 | 177013 | 3025 | 0 | 39.8895449 | -74.28089251 | 2022-06-21 04:20:56 | Ocean, New Jersey, US | |
2048063 | 2048063 | 2022-05-25 | Russia | Buryatia Republic | 136543 | 3025 | 0 | 52.7182426 | 109.492143 | 2022-05-26 04:20:50 | Buryatia Republic, Russia | |||
622074 | 622074 | 2022-05-22 | Russia | Buryatia Republic | 136543 | 3025 | 0 | 52.7182426 | 109.492143 | 2022-05-26 04:20:50 | Buryatia Republic, Russia | |||
499871 | 499871 | 2022-04-02 | Russia | Ivanovo Oblast | 107736 | 3025 | 0 | 56.9167446 | 41.43521370000001 | 2022-04-03 04:20:48 | Ivanovo Oblast, Russia | |||
3226713 | 3226713 | 2022-01-19 | Russia | Vladimir Oblast | 84785 | 3025 | 0 | 56.0503336 | 40.656163299999996 | 2022-01-20 04:21:07 | Vladimir Oblast, Russia | |||
1113783 | 1113783 | 2022-01-11 | Russia | Bryansk Oblast | 98348 | 3025 | 0 | 52.887331499999995 | 33.41585300000001 | 2022-01-12 04:21:44 | Bryansk Oblast, Russia | |||
2613674 | 2613674 | 2022-01-06 | Ukraine | Chernivtsi Oblast | 119894 | 3025 | 0 | 48.2917 | 25.9352 | 2022-01-07 04:22:09 | Chernivtsi Oblast, Ukraine | |||
800887 | 800887 | 2021-12-22 | US | Ohio | Cuyahoga | 39035 | 201896 | 3025 | 0 | 41.424119 | -81.65918339 | 2021-12-23 04:21:21 | Cuyahoga, Ohio, US | |
1078182 | 1078182 | 2021-12-09 | Russia | Tyumen Oblast | 83656 | 3025 | 0 | 58.8206488 | 70.36588370000001 | 2021-12-10 04:22:28 | Tyumen Oblast, Russia | |||
1742704 | 1742704 | 2021-12-05 | US | New Jersey | Bergen | 34003 | 125880 | 3025 | 0 | 40.96010917 | -74.07164325 | 2021-12-06 04:22:34 | Bergen, New Jersey, US | |
3401261 | 3401261 | 2021-11-30 | Colombia | Bolivar | 160512 | 3025 | 0 | 8.6704 | -74.03 | 2021-12-01 04:22:29 | Bolivar, Colombia | |||
4431 | 4431 | 2021-10-28 | Mexico | Durango | 48590 | 3025 | 0 | 24.5593 | -104.6588 | 2021-10-29 04:22:03 | Durango, Mexico | |||
443192 | 443192 | 2021-10-20 | Colombia | Narino | 89741 | 3025 | 0 | 1.2892 | -77.3579 | 2021-10-21 04:21:18 | Narino, Colombia | |||
597511 | 597511 | 2021-10-19 | Colombia | Narino | 89733 | 3025 | 0 | 1.2892 | -77.3579 | 2021-10-20 04:21:00 | Narino, Colombia | |||
2043688 | 2043688 | 2021-10-18 | Colombia | Narino | 89731 | 3025 | 0 | 1.2892 | -77.3579 | 2021-10-19 04:20:54 | Narino, Colombia | |||
780527 | 780527 | 2021-07-08 | US | New Jersey | Essex | 34013 | 94568 | 3025 | 0 | 40.78681335 | -74.24657979 | 2021-07-09 04:21:21 | Essex, New Jersey, US | |
1442749 | 1442749 | 2021-07-07 | US | New Jersey | Essex | 34013 | 94532 | 3025 | 0 | 40.78681335 | -74.24657979 | 2021-07-08 04:21:26 | Essex, New Jersey, US | |
1125303 | 1125303 | 2021-06-18 | Belarus | 409385 | 3025 | 402202 | 4158 | 53.7098 | 27.9534 | 2021-06-19 04:22:33 | Belarus | |||
1564079 | 1564079 | 2021-06-14 | Italy | Marche | 103414 | 3025 | 97685 | 2704 | 43.61675973 | 13.5188753 | 2021-06-15 04:22:22 | Marche, Italy | ||
3381362 | 3381362 | 2021-06-13 | Italy | Marche | 103411 | 3025 | 97587 | 2799 | 43.61675973 | 13.5188753 | 2021-06-14 04:22:46 | Marche, Italy | ||
1736496 | 1736496 | 2021-06-12 | Italy | Marche | 103378 | 3025 | 97483 | 2870 | 43.61675973 | 13.5188753 | 2021-06-13 04:22:44 | Marche, Italy | ||
3970537 | 3970537 | 2021-06-11 | Italy | Marche | 103344 | 3025 | 97346 | 2973 | 43.61675973 | 13.5188753 | 2021-06-12 04:22:22 | Marche, Italy | ||
2718568 | 2718568 | 2021-06-10 | US | Massachusetts | Middlesex | 25017 | 135136 | 3025 | 0 | 42.48607732 | -71.39049229 | 2021-06-11 04:23:20 | Middlesex, Massachusetts, US | |
1568196 | 1568196 | 2021-04-22 | Mexico | Morelos | 31678 | 3025 | 0 | 28653 | 18.6813 | -99.1013 | 2021-04-23 04:20:52 | Morelos, Mexico | ||
3129748 | 3129748 | 2021-04-18 | Russia | Nizhny Novgorod Oblast | 111748 | 3025 | 106811 | 1912 | 55.47180329999999 | 44.0911594 | 2021-04-19 04:20:57 | Nizhny Novgorod Oblast, Russia | ||
3003194 | 3003194 | 2021-04-06 | Ethiopia | 219381 | 3025 | 163956 | 52400 | 9.145 | 40.4897 | 2021-04-07 04:20:53 | Ethiopia | |||
1880895 | 1880895 | 2021-03-26 | Germany | Berlin | 142003 | 3025 | 131782 | 8175 | 52.52 | 13.405 | 2021-03-27 05:25:04 | Berlin, Germany | ||
3253876 | 3253876 | 2021-03-02 | Brazil | Alagoas | 132704 | 3025 | 126108 | 3571 | -9.5713 | -36.782 | 2021-03-03 05:23:28 | Alagoas, Brazil | ||
3101591 | 3101591 | 2021-01-16 | Peru | Ancash | 33478 | 3025 | 0 | 30453 | -9.407125 | -77.67179499999997 | 2021-01-17 05:22:17 | Ancash, Peru | ||
3230198 | 3230198 | 2021-01-03 | Brazil | Rio Grande do Norte | 119835 | 3025 | 68394 | 47685 | -5.4026 | -36.9541 | 2021-01-04 05:22:02 | Rio Grande do Norte, Brazil | ||
3149679 | 3149679 | 2020-12-16 | Mexico | Hidalgo | 21797 | 3025 | 0 | 18772 | 20.0911 | -98.7624 | 2020-12-17 05:28:12 | Hidalgo, Mexico | ||
1818730 | 1818730 | 2020-12-08 | India | Chhattisgarh | 249699 | 3025 | 227158 | 19516 | 21.264705 | 82.035366 | 2020-12-09 05:28:01 | Chhattisgarh, India | ||
3992289 | 3992289 | 2020-10-20 | US | Michigan | Wayne | 26163 | 38664 | 3025 | 0 | 35639 | 42.28098405 | -83.281255 | 2020-10-21 04:24:14 | Wayne, Michigan, US |
1796309 | 1796309 | 2020-10-19 | US | Michigan | Wayne | 26163 | 38435 | 3025 | 0 | 35410 | 42.28098405 | -83.281255 | 2020-10-20 04:24:22 | Wayne, Michigan, US |
3178158 | 3178158 | 2020-08-18 | Peru | Arequipa | 24096 | 3025 | 0 | 21071 | -15.843524 | -72.475539 | 2020-08-19 04:27:00 | Arequipa, Peru | ||
2632759 | 2632759 | 2020-06-29 | Spain | Castilla - La Mancha | 18120 | 3025 | 6392 | 8703 | 39.2796 | -3.0977 | 2020-06-30 04:33:48 | Castilla - La Mancha, Spain | ||
3416446 | 3416446 | 2020-05-17 | India | 95698 | 3025 | 36795 | 55878 | 20.593684 | 78.96288 | 2020-05-18 02:32:21 | India |
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]);