johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where deaths = 3166 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2817024 | 2817024 | 2022-12-03 | Russia | Smolensk Oblast | 145839 | 3166 | 0 | 55.0343496 | 33.0192065 | 2022-12-04 04:20:56 | Smolensk Oblast, Russia | |||
833880 | 833880 | 2022-12-02 | Russia | Smolensk Oblast | 145823 | 3166 | 0 | 55.0343496 | 33.0192065 | 2022-12-03 04:21:02 | Smolensk Oblast, Russia | |||
2438637 | 2438637 | 2022-11-07 | Germany | Hamburg | 763387 | 3166 | 0 | 53.5511 | 9.9937 | 2022-11-08 04:21:21 | Hamburg, Germany | |||
849375 | 849375 | 2022-11-02 | Chile | Maule | 320768 | 3166 | 0 | -35.5183 | -71.6885 | 2022-11-03 04:22:05 | Maule, Chile | |||
710226 | 710226 | 2022-11-01 | Chile | Maule | 320630 | 3166 | 0 | -35.5183 | -71.6885 | 2022-11-02 04:22:09 | Maule, Chile | |||
3284675 | 3284675 | 2022-10-31 | Chile | Maule | 320500 | 3166 | 0 | -35.5183 | -71.6885 | 2022-11-01 04:22:36 | Maule, Chile | |||
319708 | 319708 | 2022-10-30 | Chile | Maule | 320182 | 3166 | 0 | -35.5183 | -71.6885 | 2022-10-31 04:21:36 | Maule, Chile | |||
2756983 | 2756983 | 2022-10-18 | Malaysia | Sabah | 397126 | 3166 | 0 | 5.9788 | 116.0753 | 2022-10-19 04:22:26 | Sabah, Malaysia | |||
1560298 | 1560298 | 2022-09-28 | Russia | Ivanovo Oblast | 123855 | 3166 | 0 | 56.9167446 | 41.4352137 | 2022-09-29 04:22:34 | Ivanovo Oblast, Russia | |||
1098451 | 1098451 | 2022-08-03 | Sweden | Vastra Gotaland | 437957 | 3166 | 0 | 58.2528 | 13.0596 | 2022-08-04 04:20:58 | Vastra Gotaland, Sweden | |||
1405376 | 1405376 | 2022-08-02 | Sweden | Vastra Gotaland | 437957 | 3166 | 0 | 58.2528 | 13.0596 | 2022-08-03 04:20:59 | Vastra Gotaland, Sweden | |||
3617414 | 3617414 | 2022-08-01 | Sweden | Vastra Gotaland | 437957 | 3166 | 0 | 58.2528 | 13.0596 | 2022-08-02 04:20:53 | Vastra Gotaland, Sweden | |||
3871894 | 3871894 | 2022-07-31 | Sweden | Vastra Gotaland | 437957 | 3166 | 0 | 58.2528 | 13.0596 | 2022-08-01 04:21:03 | Vastra Gotaland, Sweden | |||
674648 | 674648 | 2022-07-30 | Sweden | Vastra Gotaland | 437957 | 3166 | 0 | 58.2528 | 13.0596 | 2022-07-31 04:21:02 | Vastra Gotaland, Sweden | |||
1783847 | 1783847 | 2022-07-29 | Sweden | Vastra Gotaland | 437957 | 3166 | 0 | 58.2528 | 13.0596 | 2022-07-30 04:20:42 | Vastra Gotaland, Sweden | |||
1066210 | 1066210 | 2022-07-28 | Sweden | Vastra Gotaland | 437957 | 3166 | 0 | 58.2528 | 13.0596 | 2022-07-29 04:20:45 | Vastra Gotaland, Sweden | |||
2418874 | 2418874 | 2022-07-15 | Jamaica | 144489 | 3166 | 0 | 18.1096 | -77.2975 | 2022-07-16 04:21:05 | Jamaica | ||||
3432613 | 3432613 | 2022-07-14 | Ukraine | Unknown | 209501 | 3166 | 0 | 2022-07-15 04:20:53 | Unknown, Ukraine | |||||
3113133 | 3113133 | 2022-07-13 | Ukraine | Unknown | 209501 | 3166 | 0 | 2022-07-14 04:20:57 | Unknown, Ukraine | |||||
633556 | 633556 | 2022-07-12 | Ukraine | Unknown | 209501 | 3166 | 0 | 2022-07-13 04:20:58 | Unknown, Ukraine | |||||
1215234 | 1215234 | 2022-07-11 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-12 04:20:51 | Unknown, Ukraine | ||||
2792716 | 2792716 | 2022-07-10 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-11 04:20:46 | Unknown, Ukraine | ||||
145669 | 145669 | 2022-07-09 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-10 04:20:54 | Unknown, Ukraine | ||||
1420769 | 1420769 | 2022-07-08 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-09 04:20:59 | Unknown, Ukraine | ||||
2744694 | 2744694 | 2022-07-07 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-08 04:20:56 | Unknown, Ukraine | ||||
1203489 | 1203489 | 2022-07-06 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-07 04:20:55 | Unknown, Ukraine | ||||
3970232 | 3970232 | 2022-07-05 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-06 04:20:58 | Unknown, Ukraine | ||||
3081743 | 3081743 | 2022-07-04 | Ukraine | Unknown | 209501 | 3166 | 0 | 0 | 2022-07-05 04:20:45 | Unknown, Ukraine | ||||
2999879 | 2999879 | 2022-05-24 | US | California | Sacramento | 6067 | 320593 | 3166 | 0 | 38.45106826 | -121.3425374 | 2022-05-25 04:20:56 | Sacramento, California, US | |
3593600 | 3593600 | 2022-05-23 | US | California | Sacramento | 6067 | 320469 | 3166 | 0 | 38.45106826 | -121.3425374 | 2022-05-24 04:20:57 | Sacramento, California, US | |
1110148 | 1110148 | 2022-05-21 | US | California | Sacramento | 6067 | 318040 | 3166 | 0 | 38.45106826 | -121.3425374 | 2022-05-22 04:20:52 | Sacramento, California, US | |
1169772 | 1169772 | 2022-05-20 | US | California | Sacramento | 6067 | 318017 | 3166 | 0 | 38.45106826 | -121.3425374 | 2022-05-21 04:20:58 | Sacramento, California, US | |
3896535 | 3896535 | 2022-05-19 | US | California | Sacramento | 6067 | 317934 | 3166 | 0 | 38.45106826 | -121.3425374 | 2022-05-20 04:20:57 | Sacramento, California, US | |
1185319 | 1185319 | 2022-05-18 | US | California | Sacramento | 6067 | 316213 | 3166 | 0 | 38.45106826 | -121.3425374 | 2022-05-19 04:20:54 | Sacramento, California, US | |
1845938 | 1845938 | 2022-04-18 | Italy | Abruzzo | 348167 | 3166 | 0 | 42.35122196 | 13.39843823 | 2022-04-19 04:21:00 | Abruzzo, Italy | |||
1468400 | 1468400 | 2022-03-24 | Spain | Galicia | 565481 | 3166 | 0 | 42.5751 | -8.1339 | 2022-03-25 04:20:46 | Galicia, Spain | |||
1468194 | 1468194 | 2022-03-24 | Mexico | Nayarit | 57909 | 3166 | 0 | 21.7514 | -104.8455 | 2022-03-25 04:20:46 | Nayarit, Mexico | |||
3022574 | 3022574 | 2022-03-23 | Spain | Galicia | 565481 | 3166 | 0 | 42.5751 | -8.1339 | 2022-03-24 04:20:43 | Galicia, Spain | |||
1905496 | 1905496 | 2022-03-22 | Spain | Galicia | 565481 | 3166 | 0 | 42.5751 | -8.1339 | 2022-03-23 04:20:48 | Galicia, Spain | |||
951095 | 951095 | 2022-03-12 | Russia | Murmansk Oblast | 130662 | 3166 | 0 | 68.00004179999999 | 33.9999151 | 2022-03-13 04:20:49 | Murmansk Oblast, Russia | |||
3671876 | 3671876 | 2022-02-15 | Russia | Lipetsk Oblast | 113130 | 3166 | 0 | 52.693517799999995 | 39.112266399999996 | 2022-02-16 04:21:10 | Lipetsk Oblast, Russia | |||
2642015 | 2642015 | 2022-02-14 | Russia | Vladimir Oblast | 112529 | 3166 | 0 | 56.0503336 | 40.656163299999996 | 2022-02-15 04:21:09 | Vladimir Oblast, Russia | |||
101491 | 101491 | 2022-01-14 | US | New Jersey | Bergen | 34003 | 197809 | 3166 | 0 | 40.96010917 | -74.07164325 | 2022-01-15 04:21:07 | Bergen, New Jersey, US | |
2111899 | 2111899 | 2021-12-26 | Russia | Dagestan Republic | 65305 | 3166 | 0 | 43.05749160000001 | 47.1332224 | 2021-12-27 04:21:58 | Dagestan Republic, Russia | |||
2903388 | 2903388 | 2021-12-19 | Albania | 205777 | 3166 | 0 | 41.1533 | 20.1683 | 2021-12-20 04:21:43 | Albania | ||||
3496446 | 3496446 | 2021-12-15 | Russia | Tyumen Oblast | 85475 | 3166 | 0 | 58.8206488 | 70.36588370000001 | 2021-12-16 04:22:11 | Tyumen Oblast, Russia | |||
3401466 | 3401466 | 2021-11-30 | Japan | Tokyo | 382175 | 3166 | 0 | 35.711343 | 139.446921 | 2021-12-01 04:22:29 | Tokyo, Japan | |||
714726 | 714726 | 2021-11-12 | Russia | Ulyanovsk Oblast | 102331 | 3166 | 0 | 54.146317700000004 | 47.2324921 | 2021-11-13 04:21:38 | Ulyanovsk Oblast, Russia | |||
89295 | 89295 | 2021-11-09 | US | New Jersey | Essex | 34013 | 107054 | 3166 | 0 | 40.78681335 | -74.24657979 | 2021-11-10 04:21:38 | Essex, New Jersey, US | |
2899631 | 2899631 | 2021-08-12 | India | Goa | 172276 | 3166 | 0 | 15.359682000000001 | 74.057396 | 2021-08-13 04:21:24 | Goa, India | |||
408145 | 408145 | 2021-07-28 | Colombia | Magdalena | 88039 | 3166 | 83663 | 1210 | 10.4113 | -74.4057 | 2021-07-29 04:21:33 | Magdalena, Colombia | ||
1712079 | 1712079 | 2021-06-25 | Brazil | Tocantins | 196274 | 3166 | 175769 | 16751 | -10.1753 | -48.2982 | 2021-06-26 04:21:43 | Tocantins, Brazil | ||
3030352 | 3030352 | 2021-06-16 | Libya | 189888 | 3166 | 175471 | 11251 | 26.3351 | 17.228331 | 2021-06-17 04:22:36 | Libya | |||
2339458 | 2339458 | 2021-06-15 | Libya | 189555 | 3166 | 175226 | 11163 | 26.3351 | 17.228331 | 2021-06-16 04:22:32 | Libya | |||
1915453 | 1915453 | 2021-05-20 | US | New York | Nassau | 36059 | 182656 | 3166 | 0 | 40.74066522 | -73.58941873 | 2021-05-21 04:20:43 | Nassau, New York, US | |
380348 | 380348 | 2021-04-30 | Peru | Cajamarca | 51581 | 3166 | 0 | 48415 | -6.430284 | -78.74559599999998 | 2021-05-01 04:20:47 | Cajamarca, Peru | ||
1798622 | 1798622 | 2021-03-23 | Italy | Friuli Venezia Giulia | 92608 | 3166 | 73162 | 16280 | 45.6494354 | 13.76813649 | 2021-03-24 05:25:40 | Friuli Venezia Giulia, Italy | ||
2359572 | 2359572 | 2021-03-08 | Mexico | Yucatan | 33368 | 3166 | 0 | 30202 | 20.7099 | -89.0943 | 2021-03-09 05:28:19 | Yucatan, Mexico | ||
3049916 | 3049916 | 2021-02-16 | Brazil | Mato Grosso do Sul | 172402 | 3166 | 160856 | 7812 | -20.7722 | -54.7852 | 2021-02-17 05:23:10 | Mato Grosso do Sul, Brazil | ||
2637468 | 2637468 | 2021-02-11 | Brazil | Piaui | 164858 | 3166 | 161177 | 0 | -7.7183 | -42.7289 | 2021-02-12 05:23:29 | Piaui, Brazil | ||
3879323 | 3879323 | 2021-01-14 | Brazil | Rio Grande do Norte | 128601 | 3166 | 91645 | 32107 | -5.4026 | -36.9541 | 2021-01-15 05:22:24 | Rio Grande do Norte, Brazil | ||
2119815 | 2119815 | 2020-12-20 | Mexico | Tamaulipas | 37979 | 3166 | 0 | 34813 | 24.2669 | -98.8363 | 2020-12-21 05:27:58 | Tamaulipas, Mexico | ||
3338428 | 3338428 | 2020-11-17 | Colombia | Atlantico | 74975 | 3166 | 70813 | 996 | 10.6966 | -74.8741 | 2020-11-18 05:40:31 | Atlantico, Colombia | ||
271900 | 271900 | 2020-11-10 | Brazil | Paraiba | 136029 | 3166 | 110951 | 21912 | -7.24 | -36.782 | 2020-11-11 05:25:30 | Paraiba, Brazil | ||
2497795 | 2497795 | 2020-11-03 | Canada | Ontario | 81167 | 3166 | 70345 | 8121 | 51.2538 | -85.3232 | 2020-11-04 05:25:09 | Ontario, Canada |
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]);