johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
60 rows where deaths = 3024 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
849505 | 849505 | 2022-11-02 | Germany | Schleswig-Holstein | 1088194 | 3024 | 0 | 54.2194 | 9.6961 | 2022-11-03 04:22:05 | Schleswig-Holstein, Germany | |||
2967371 | 2967371 | 2022-10-10 | Italy | Calabria | 565905 | 3024 | 0 | 38.90597598 | 16.59440194 | 2022-10-11 04:23:05 | Calabria, Italy | |||
3097407 | 3097407 | 2022-10-09 | Italy | Calabria | 565475 | 3024 | 0 | 38.90597598 | 16.59440194 | 2022-10-10 04:22:32 | Calabria, Italy | |||
4002632 | 4002632 | 2022-10-08 | Italy | Calabria | 564738 | 3024 | 0 | 38.90597598 | 16.59440194 | 2022-10-09 04:21:16 | Calabria, Italy | |||
2008467 | 2008467 | 2022-08-04 | Chile | Maule | 277775 | 3024 | 0 | -35.5183 | -71.6885 | 2022-08-05 04:20:52 | Maule, Chile | |||
2335588 | 2335588 | 2022-07-27 | Russia | Astrakhan Oblast | 119452 | 3024 | 0 | 47.1878186 | 47.608851 | 2022-07-28 04:20:56 | Astrakhan Oblast, Russia | |||
1487778 | 1487778 | 2022-07-26 | Russia | Astrakhan Oblast | 119345 | 3024 | 0 | 47.1878186 | 47.608851 | 2022-07-27 04:21:04 | Astrakhan Oblast, Russia | |||
2148374 | 2148374 | 2022-06-27 | US | Florida | Polk | 12105 | 214932 | 3024 | 0 | 27.95027105 | -81.69732947 | 2022-06-28 04:20:58 | Polk, Florida, US | |
476175 | 476175 | 2022-06-26 | US | Florida | Polk | 12105 | 214932 | 3024 | 0 | 27.95027105 | -81.69732947 | 2022-06-27 04:21:00 | Polk, Florida, US | |
939550 | 939550 | 2022-06-25 | US | Florida | Polk | 12105 | 214932 | 3024 | 0 | 27.95027105 | -81.69732947 | 2022-06-26 04:21:02 | Polk, Florida, US | |
3271693 | 3271693 | 2022-06-19 | US | New Jersey | Ocean | 34029 | 176921 | 3024 | 0 | 39.8895449 | -74.28089251 | 2022-06-20 04:21:01 | Ocean, New Jersey, US | |
3399605 | 3399605 | 2022-06-18 | US | New Jersey | Ocean | 34029 | 176786 | 3024 | 0 | 39.8895449 | -74.28089251 | 2022-06-19 04:20:51 | Ocean, New Jersey, US | |
2313482 | 2313482 | 2022-06-17 | US | New Jersey | Ocean | 34029 | 176661 | 3024 | 0 | 39.8895449 | -74.28089251 | 2022-06-18 04:21:10 | Ocean, New Jersey, US | |
2999501 | 2999501 | 2022-05-24 | Russia | Buryatia Republic | 136524 | 3024 | 0 | 52.7182426 | 109.492143 | 2022-05-25 04:20:56 | Buryatia Republic, Russia | |||
3722451 | 3722451 | 2022-04-25 | Russia | Smolensk Oblast | 129712 | 3024 | 0 | 55.03434960000001 | 33.0192065 | 2022-04-26 04:20:51 | Smolensk Oblast, Russia | |||
2029019 | 2029019 | 2022-04-24 | Russia | Smolensk Oblast | 129655 | 3024 | 0 | 55.03434960000001 | 33.0192065 | 2022-04-25 04:20:56 | Smolensk Oblast, Russia | |||
2443088 | 2443088 | 2022-04-13 | Sweden | Vastra Gotaland | 432659 | 3024 | 0 | 58.2528 | 13.0596 | 2022-04-13 23:21:06 | Vastra Gotaland, Sweden | |||
1948845 | 1948845 | 2022-04-12 | Sweden | Vastra Gotaland | 432659 | 3024 | 0 | 58.2528 | 13.0596 | 2022-04-13 04:21:03 | Vastra Gotaland, Sweden | |||
3206598 | 3206598 | 2022-04-11 | Sweden | Vastra Gotaland | 432659 | 3024 | 0 | 58.2528 | 13.0596 | 2022-04-12 04:20:49 | Vastra Gotaland, Sweden | |||
1576484 | 1576484 | 2022-04-10 | Sweden | Vastra Gotaland | 432659 | 3024 | 0 | 58.2528 | 13.0596 | 2022-04-11 04:21:02 | Vastra Gotaland, Sweden | |||
1652726 | 1652726 | 2022-04-09 | Sweden | Vastra Gotaland | 432659 | 3024 | 0 | 58.2528 | 13.0596 | 2022-04-10 04:20:52 | Vastra Gotaland, Sweden | |||
2116048 | 2116048 | 2022-04-08 | Sweden | Vastra Gotaland | 432659 | 3024 | 0 | 58.2528 | 13.0596 | 2022-04-09 04:20:42 | Vastra Gotaland, Sweden | |||
3320572 | 3320572 | 2022-04-07 | Sweden | Vastra Gotaland | 432659 | 3024 | 0 | 58.2528 | 13.0596 | 2022-04-08 04:20:48 | Vastra Gotaland, Sweden | |||
3238544 | 3238544 | 2022-03-21 | Russia | Komi Republic | 166814 | 3024 | 0 | 63.9881421 | 54.3326073 | 2022-03-22 04:20:54 | Komi Republic, Russia | |||
24617 | 24617 | 2022-03-20 | Russia | Komi Republic | 166626 | 3024 | 0 | 63.9881421 | 54.3326073 | 2022-03-21 04:20:50 | Komi Republic, Russia | |||
2641858 | 2641858 | 2022-02-14 | Mexico | Tlaxcala | 40563 | 3024 | 0 | 19.3139 | -98.2404 | 2022-02-15 04:21:09 | Tlaxcala, Mexico | |||
3300431 | 3300431 | 2022-01-30 | Russia | Lipetsk Oblast | 91589 | 3024 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-01-31 04:21:09 | Lipetsk Oblast, Russia | |||
730667 | 730667 | 2021-12-27 | Nigeria | 238420 | 3024 | 0 | 9.082 | 8.6753 | 2021-12-28 04:21:47 | Nigeria | ||||
140136 | 140136 | 2021-12-04 | US | New Jersey | Bergen | 34003 | 125650 | 3024 | 0 | 40.96010917 | -74.07164325 | 2021-12-05 04:22:25 | Bergen, New Jersey, US | |
758587 | 758587 | 2021-11-26 | Russia | Udmurt Republic | 73632 | 3024 | 0 | 57.1961165 | 52.69598320000001 | 2021-11-27 04:22:45 | Udmurt Republic, Russia | |||
773997 | 773997 | 2021-10-23 | Ukraine | Zaporizhia Oblast | 132726 | 3024 | 0 | 47.8388 | 35.1396 | 2021-10-24 04:21:22 | Zaporizhia Oblast, Ukraine | |||
1909049 | 1909049 | 2021-10-17 | Colombia | Narino | 89721 | 3024 | 0 | 1.2892 | -77.3579 | 2021-10-18 04:21:10 | Narino, Colombia | |||
934638 | 934638 | 2021-10-16 | Colombia | Narino | 89701 | 3024 | 0 | 1.2892 | -77.3579 | 2021-10-17 04:21:29 | Narino, Colombia | |||
2943193 | 2943193 | 2021-10-15 | Colombia | Narino | 89691 | 3024 | 0 | 1.2892 | -77.3579 | 2021-10-16 04:21:15 | Narino, Colombia | |||
491473 | 491473 | 2021-10-14 | Colombia | Narino | 89680 | 3024 | 0 | 1.2892 | -77.3579 | 2021-10-15 04:21:26 | Narino, Colombia | |||
2175799 | 2175799 | 2021-08-22 | Russia | Samara Oblast | 86285 | 3024 | 0 | 53.2128813 | 50.8914633 | 2021-08-23 04:21:27 | Samara Oblast, Russia | |||
2695854 | 2695854 | 2021-07-06 | US | New Jersey | Essex | 34013 | 94521 | 3024 | 0 | 40.78681335 | -74.24657979 | 2021-07-07 04:21:20 | Essex, New Jersey, US | |
1934603 | 1934603 | 2021-07-05 | US | New Jersey | Essex | 34013 | 94514 | 3024 | 0 | 40.78681335 | -74.24657979 | 2021-07-06 04:21:32 | Essex, New Jersey, US | |
1167334 | 1167334 | 2021-07-04 | US | New Jersey | Essex | 34013 | 94513 | 3024 | 0 | 40.78681335 | -74.24657979 | 2021-07-05 04:21:28 | Essex, New Jersey, US | |
1895307 | 1895307 | 2021-06-30 | US | New Jersey | Essex | 34013 | 94502 | 3024 | 0 | 40.78681335 | -74.24657979 | 2021-07-01 04:21:19 | Essex, New Jersey, US | |
2716959 | 2716959 | 2021-06-10 | Italy | Marche | 103301 | 3024 | 97288 | 2989 | 43.61675973 | 13.5188753 | 2021-06-11 04:23:20 | Marche, Italy | ||
524453 | 524453 | 2021-06-09 | US | Massachusetts | Middlesex | 25017 | 135121 | 3024 | 0 | 42.48607732 | -71.39049229 | 2021-06-10 04:23:17 | Middlesex, Massachusetts, US | |
522844 | 522844 | 2021-06-09 | Italy | Marche | 103255 | 3024 | 97106 | 3125 | 43.61675973 | 13.5188753 | 2021-06-10 04:23:17 | Marche, Italy | ||
3473893 | 3473893 | 2021-06-08 | US | Massachusetts | Middlesex | 25017 | 135107 | 3024 | 0 | 42.48607732 | -71.39049229 | 2021-06-09 04:23:31 | Middlesex, Massachusetts, US | |
3472284 | 3472284 | 2021-06-08 | Italy | Marche | 103173 | 3024 | 96905 | 3244 | 43.61675973 | 13.5188753 | 2021-06-09 04:23:31 | Marche, Italy | ||
3924259 | 3924259 | 2021-04-24 | Russia | Sverdlovsk Oblast | 85500 | 3024 | 79121 | 3355 | 58.6414755 | 61.8021546 | 2021-04-25 04:20:32 | Sverdlovsk Oblast, Russia | ||
3133151 | 3133151 | 2021-04-18 | Ukraine | Lviv Oblast | 122907 | 3024 | 89278 | 30605 | 49.8397 | 24.0297 | 2021-04-19 04:20:57 | Lviv Oblast, Ukraine | ||
1881101 | 1881101 | 2021-03-26 | Nepal | 276665 | 3024 | 272342 | 1299 | 28.1667 | 84.25 | 2021-03-27 05:25:04 | Nepal | |||
3254057 | 3254057 | 2021-03-02 | Germany | Brandenburg | 76721 | 3024 | 70291 | 3682 | 52.4125 | 12.5316 | 2021-03-03 05:23:28 | Brandenburg, Germany | ||
471293 | 471293 | 2021-02-19 | Dominican Republic | 233598 | 3024 | 182603 | 47971 | 18.7357 | -70.1627 | 2021-02-20 05:22:51 | Dominican Republic | |||
613783 | 613783 | 2021-02-08 | Mexico | Queretaro | 50493 | 3024 | 0 | 47469 | 20.5888 | -100.3899 | 2021-02-09 05:23:30 | Queretaro, Mexico | ||
1672197 | 1672197 | 2021-02-07 | Brazil | Mato Grosso do Sul | 165903 | 3024 | 155196 | 7345 | -20.7722 | -54.7852 | 2021-02-08 05:22:39 | Mato Grosso do Sul, Brazil | ||
340222 | 340222 | 2021-02-03 | India | Haryana | 268136 | 3024 | 264093 | 1019 | 29.20004 | 76.332824 | 2021-02-04 05:22:26 | Haryana, India | ||
1632404 | 1632404 | 2020-12-05 | Mexico | Tamaulipas | 36377 | 3024 | 0 | 33353 | 24.2669 | -98.8363 | 2020-12-06 05:26:18 | Tamaulipas, Mexico | ||
3440679 | 3440679 | 2020-11-11 | Colombia | Valle del Cauca | 92323 | 3024 | 82857 | 6442 | 3.8009 | -76.6413 | 2020-11-12 05:25:55 | Valle del Cauca, Colombia | ||
3651323 | 3651323 | 2020-10-24 | Brazil | Santa Catarina | 244978 | 3024 | 213495 | 28459 | -27.2423 | -50.2189 | 2020-10-25 04:24:36 | Santa Catarina, Brazil | ||
2306322 | 2306322 | 2020-06-28 | Spain | Castilla - La Mancha | 18094 | 3024 | 6392 | 8678 | 39.2796 | -3.0977 | 2020-06-29 04:33:44 | Castilla - La Mancha, Spain | ||
2039657 | 2039657 | 2020-06-27 | Spain | Castilla - La Mancha | 18076 | 3024 | 6392 | 8660 | 39.2796 | -3.0977 | 2020-06-28 04:34:04 | Castilla - La Mancha, Spain | ||
1135938 | 1135938 | 2020-06-26 | Spain | Castilla - La Mancha | 18024 | 3024 | 6392 | 8608 | 39.2796 | -3.0977 | 2020-06-27 04:33:35 | Castilla - La Mancha, Spain | ||
3752814 | 3752814 | 2020-03-10 | Mainland China | Hubei | 67760 | 3024 | 47743 | 30.9756 | 112.2707 | 2020-03-10T15:13:05 |
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]);