johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where deaths = 3131 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
710347 | 710347 | 2022-11-01 | Germany | Hamburg | 756924 | 3131 | 0 | 53.5511 | 9.9937 | 2022-11-02 04:22:09 | Hamburg, Germany | |||
3284796 | 3284796 | 2022-10-31 | Germany | Hamburg | 756924 | 3131 | 0 | 53.5511 | 9.9937 | 2022-11-01 04:22:36 | Hamburg, Germany | |||
912461 | 912461 | 2022-10-29 | Russia | Smolensk Oblast | 145358 | 3131 | 0 | 55.0343496 | 33.0192065 | 2022-10-30 04:22:14 | Smolensk Oblast, Russia | |||
1366730 | 1366730 | 2022-10-28 | Russia | Smolensk Oblast | 145326 | 3131 | 0 | 55.0343496 | 33.0192065 | 2022-10-29 04:21:13 | Smolensk Oblast, Russia | |||
3038585 | 3038585 | 2022-10-27 | Russia | Smolensk Oblast | 145284 | 3131 | 0 | 55.0343496 | 33.0192065 | 2022-10-28 04:22:31 | Smolensk Oblast, Russia | |||
539005 | 539005 | 2022-10-26 | Russia | Smolensk Oblast | 145265 | 3131 | 0 | 55.0343496 | 33.0192065 | 2022-10-27 04:22:01 | Smolensk Oblast, Russia | |||
670363 | 670363 | 2022-07-21 | Malaysia | Sabah | 379141 | 3131 | 0 | 5.9788 | 116.0753 | 2022-07-22 04:21:15 | Sabah, Malaysia | |||
1608326 | 1608326 | 2022-07-20 | Malaysia | Sabah | 378874 | 3131 | 0 | 5.9788 | 116.0753 | 2022-07-21 04:21:10 | Sabah, Malaysia | |||
958959 | 958959 | 2022-07-19 | Malaysia | Sabah | 378595 | 3131 | 0 | 5.9788 | 116.0753 | 2022-07-20 04:20:59 | Sabah, Malaysia | |||
3210346 | 3210346 | 2022-07-18 | Malaysia | Sabah | 378361 | 3131 | 0 | 5.9788 | 116.0753 | 2022-07-19 04:20:58 | Sabah, Malaysia | |||
3405521 | 3405521 | 2022-07-17 | Malaysia | Sabah | 378137 | 3131 | 0 | 5.9788 | 116.0753 | 2022-07-18 04:20:59 | Sabah, Malaysia | |||
2151721 | 2151721 | 2022-07-16 | Malaysia | Sabah | 377906 | 3131 | 0 | 5.9788 | 116.0753 | 2022-07-17 04:21:15 | Sabah, Malaysia | |||
2418954 | 2418954 | 2022-07-15 | Malaysia | Sabah | 377632 | 3131 | 0 | 5.9788 | 116.0753 | 2022-07-16 04:21:05 | Sabah, Malaysia | |||
1763531 | 1763531 | 2022-06-20 | Russia | Ivanovo Oblast | 112209 | 3131 | 0 | 56.9167446 | 41.4352137 | 2022-06-21 04:20:56 | Ivanovo Oblast, Russia | |||
3269717 | 3269717 | 2022-06-19 | Russia | Ivanovo Oblast | 112179 | 3131 | 0 | 56.9167446 | 41.4352137 | 2022-06-20 04:21:01 | Ivanovo Oblast, Russia | |||
3397629 | 3397629 | 2022-06-18 | Russia | Ivanovo Oblast | 112147 | 3131 | 0 | 56.9167446 | 41.4352137 | 2022-06-19 04:20:51 | Ivanovo Oblast, Russia | |||
1697000 | 1697000 | 2022-04-28 | US | Connecticut | Hartford | 9003 | 181457 | 3131 | 0 | 41.80283011 | -72.73103891 | 2022-04-29 04:20:59 | Hartford, Connecticut, US | |
3852034 | 3852034 | 2022-04-27 | Russia | Komi Republic | 170632 | 3131 | 0 | 63.9881421 | 54.3326073 | 2022-04-28 04:20:47 | Komi Republic, Russia | |||
3722867 | 3722867 | 2022-04-25 | US | Connecticut | Hartford | 9003 | 180627 | 3131 | 0 | 41.80283011 | -72.73103891 | 2022-04-26 04:20:51 | Hartford, Connecticut, US | |
2029435 | 2029435 | 2022-04-24 | US | Connecticut | Hartford | 9003 | 180164 | 3131 | 0 | 41.80283011 | -72.73103891 | 2022-04-25 04:20:56 | Hartford, Connecticut, US | |
747010 | 747010 | 2022-04-23 | US | Connecticut | Hartford | 9003 | 180164 | 3131 | 0 | 41.80283011 | -72.73103891 | 2022-04-24 04:20:56 | Hartford, Connecticut, US | |
3437495 | 3437495 | 2022-04-22 | US | Connecticut | Hartford | 9003 | 180164 | 3131 | 0 | 41.80283011 | -72.73103891 | 2022-04-23 04:20:50 | Hartford, Connecticut, US | |
2163881 | 2163881 | 2022-03-26 | Syria | 55634 | 3131 | 0 | 34.802075 | 38.99681500000001 | 2022-03-27 04:20:47 | Syria | ||||
1117220 | 1117220 | 2022-01-11 | Ukraine | Ivano-Frankivsk Oblast | 129357 | 3131 | 0 | 48.9226 | 24.7111 | 2022-01-12 04:21:44 | Ivano-Frankivsk Oblast, Ukraine | |||
2610176 | 2610176 | 2022-01-06 | Netherlands | Noord-Holland | 544003 | 3131 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-01-07 04:22:09 | Noord-Holland, Netherlands | |||
731580 | 731580 | 2021-12-27 | US | Illinois | Unassigned | 90017 | 187 | 3131 | 0 | 42.36542373 | 0.0 | 2021-12-28 04:21:47 | Unassigned, Illinois, US | |
2112752 | 2112752 | 2021-12-26 | US | Illinois | Unassigned | 90017 | 143 | 3131 | 0 | 42.36542373 | 0.0 | 2021-12-27 04:21:58 | Unassigned, Illinois, US | |
3606124 | 3606124 | 2021-12-25 | US | Illinois | Unassigned | 90017 | 143 | 3131 | 0 | 42.36542373 | 0.0 | 2021-12-26 04:21:50 | Unassigned, Illinois, US | |
2964442 | 2964442 | 2021-12-24 | US | Illinois | Unassigned | 90017 | 143 | 3131 | 0 | 42.36542373 | 0.0 | 2021-12-25 04:21:37 | Unassigned, Illinois, US | |
722469 | 722469 | 2021-11-20 | Italy | Marche | 120303 | 3131 | 0 | 43.61675973 | 13.5188753 | 2021-11-21 04:22:13 | Marche, Italy | |||
685975 | 685975 | 2021-10-24 | Ukraine | Kiev Oblast | 145572 | 3131 | 0 | 50.053000000000004 | 30.7667 | 2021-10-25 04:22:31 | Kiev Oblast, Ukraine | |||
3834654 | 3834654 | 2021-10-05 | US | New Jersey | Essex | 34013 | 104687 | 3131 | 0 | 40.78681335 | -74.24657979 | 2021-10-06 04:21:33 | Essex, New Jersey, US | |
3834087 | 3834087 | 2021-10-05 | US | Massachusetts | Middlesex | 25017 | 153695 | 3131 | 0 | 42.48607732 | -71.39049229 | 2021-10-06 04:21:33 | Middlesex, Massachusetts, US | |
1374342 | 1374342 | 2021-09-15 | Colombia | Huila | 88024 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-16 04:22:19 | Huila, Colombia | |||
2462641 | 2462641 | 2021-09-14 | Colombia | Huila | 88024 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-15 03:22:37 | Huila, Colombia | |||
1385480 | 1385480 | 2021-09-13 | Colombia | Huila | 88012 | 3131 | 0 | 2.5359 | -75.5277 | 2021-09-14 04:21:41 | Huila, Colombia | |||
3974690 | 3974690 | 2021-09-03 | Netherlands | Noord-Brabant | 306613 | 3131 | 0 | 51.561174 | 5.1849419999999995 | 2021-09-04 04:21:28 | Noord-Brabant, Netherlands | |||
178152 | 178152 | 2021-09-02 | Netherlands | Noord-Brabant | 306363 | 3131 | 0 | 51.561174 | 5.1849419999999995 | 2021-09-03 04:21:20 | Noord-Brabant, Netherlands | |||
1708373 | 1708373 | 2021-06-02 | Libya | 186323 | 3131 | 172420 | 10772 | 26.3351 | 17.228331 | 2021-06-03 04:23:32 | Libya | |||
2450862 | 2450862 | 2021-05-02 | Mexico | Morelos | 32317 | 3131 | 0 | 29186 | 18.6813 | -99.1013 | 2021-05-03 04:20:39 | Morelos, Mexico | ||
1536143 | 1536143 | 2021-03-28 | Russia | Krasnoyarsk Krai | 66414 | 3131 | 61469 | 1814 | 63.3233807 | 97.0979974 | 2021-03-29 04:28:35 | Krasnoyarsk Krai, Russia | ||
2058898 | 2058898 | 2021-03-15 | US | Texas | Bexar | 48029 | 205243 | 3131 | 0 | 29.44928723 | -98.52019748 | 2021-03-16 05:25:13 | Bexar, Texas, US | |
3539554 | 3539554 | 2021-02-12 | Mexico | Queretaro | 52326 | 3131 | 0 | 49195 | 20.5888 | -100.3899 | 2021-02-13 05:22:12 | Queretaro, Mexico | ||
1672203 | 1672203 | 2021-02-07 | Brazil | Piaui | 162637 | 3131 | 158549 | 729 | -7.7183 | -42.7289 | 2021-02-08 05:22:39 | Piaui, Brazil | ||
1459518 | 1459518 | 2021-01-31 | Burma | 140145 | 3131 | 125072 | 11942 | 21.9162 | 95.956 | 2021-02-01 05:22:53 | Burma | |||
2931321 | 2931321 | 2020-12-19 | Mexico | Tabasco | 41489 | 3131 | 0 | 38358 | 17.8409 | -92.6189 | 2020-12-20 05:27:32 | Tabasco, Mexico | ||
2079768 | 2079768 | 2020-10-31 | Colombia | Atlantico | 71870 | 3131 | 67249 | 1490 | 10.6966 | -74.8741 | 2020-11-01 04:36:19 | Atlantico, Colombia | ||
2379721 | 2379721 | 2020-10-01 | Mexico | Nuevo Leon | 40495 | 3131 | 33482 | 3882 | 25.5922 | -99.9962 | 2020-10-02 04:23:51 | Nuevo Leon, Mexico | ||
3315955 | 3315955 | 2020-09-22 | Brazil | Distrito Federal | 185349 | 3131 | 172996 | 9222 | -15.7998 | -47.8645 | 2020-09-23 04:23:00 | Distrito Federal, Brazil |
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]);