johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
90 rows where deaths = 1921 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752669 | 2752669 | 2022-12-29 | Chile | Antofagasta | 178161 | 1921 | 0 | -23.6509 | -70.3975 | 2022-12-30 04:21:04 | Antofagasta, Chile | |||
2416513 | 2416513 | 2022-12-05 | US | Michigan | Genesee | 26049 | 121165 | 1921 | 0 | 43.02244215 | -83.70589709 | 2022-12-06 04:21:03 | Genesee, Michigan, US | |
720121 | 720121 | 2022-12-04 | US | Michigan | Genesee | 26049 | 121165 | 1921 | 0 | 43.02244215 | -83.70589709 | 2022-12-05 04:20:58 | Genesee, Michigan, US | |
2818410 | 2818410 | 2022-12-03 | US | Michigan | Genesee | 26049 | 121165 | 1921 | 0 | 43.02244215 | -83.70589709 | 2022-12-04 04:20:56 | Genesee, Michigan, US | |
835266 | 835266 | 2022-12-02 | US | Michigan | Genesee | 26049 | 121165 | 1921 | 0 | 43.02244215 | -83.70589709 | 2022-12-03 04:21:02 | Genesee, Michigan, US | |
2137796 | 2137796 | 2022-12-01 | US | Michigan | Genesee | 26049 | 121165 | 1921 | 0 | 43.02244215 | -83.70589709 | 2022-12-02 04:21:07 | Genesee, Michigan, US | |
1966212 | 1966212 | 2022-11-30 | US | Michigan | Genesee | 26049 | 121165 | 1921 | 0 | 43.02244215 | -83.70589709 | 2022-12-01 04:21:03 | Genesee, Michigan, US | |
2558759 | 2558759 | 2022-11-29 | US | New Jersey | Camden | 34007 | 158790 | 1921 | 0 | 39.80343818 | -74.96388753 | 2022-11-30 04:21:07 | Camden, New Jersey, US | |
2558226 | 2558226 | 2022-11-29 | US | Michigan | Genesee | 26049 | 121165 | 1921 | 0 | 43.02244215 | -83.70589709 | 2022-11-30 04:21:07 | Genesee, Michigan, US | |
2064111 | 2064111 | 2022-11-19 | Russia | Kabardino-Balkarian Republic | 73205 | 1921 | 0 | 43.4806048 | 43.5978976 | 2022-11-20 04:21:08 | Kabardino-Balkarian Republic, Russia | |||
480705 | 480705 | 2022-11-08 | US | Indiana | Lake | 18089 | 126250 | 1921 | 0 | 41.41874274 | -87.38277575 | 2022-11-09 04:21:22 | Lake, Indiana, US | |
2439855 | 2439855 | 2022-11-07 | US | Indiana | Lake | 18089 | 126250 | 1921 | 0 | 41.41874274 | -87.38277575 | 2022-11-08 04:21:21 | Lake, Indiana, US | |
1050953 | 1050953 | 2022-11-06 | US | Indiana | Lake | 18089 | 126250 | 1921 | 0 | 41.41874274 | -87.38277575 | 2022-11-07 04:21:26 | Lake, Indiana, US | |
618977 | 618977 | 2022-11-05 | US | Indiana | Lake | 18089 | 126250 | 1921 | 0 | 41.41874274 | -87.38277575 | 2022-11-06 04:21:24 | Lake, Indiana, US | |
1023481 | 1023481 | 2022-11-04 | US | Indiana | Lake | 18089 | 126250 | 1921 | 0 | 41.41874274 | -87.38277575 | 2022-11-05 04:21:52 | Lake, Indiana, US | |
432472 | 432472 | 2022-11-03 | US | Indiana | Lake | 18089 | 126250 | 1921 | 0 | 41.41874274 | -87.38277575 | 2022-11-04 04:22:11 | Lake, Indiana, US | |
850714 | 850714 | 2022-11-02 | US | Indiana | Lake | 18089 | 126250 | 1921 | 0 | 41.41874274 | -87.38277575 | 2022-11-03 04:22:05 | Lake, Indiana, US | |
849502 | 849502 | 2022-11-02 | Germany | Saarland | 460246 | 1921 | 0 | 49.3964 | 7.023 | 2022-11-03 04:22:05 | Saarland, Germany | |||
710353 | 710353 | 2022-11-01 | Germany | Saarland | 460246 | 1921 | 0 | 49.3964 | 7.023 | 2022-11-02 04:22:09 | Saarland, Germany | |||
3097687 | 3097687 | 2022-10-09 | Russia | Pskov Oblast | 124082 | 1921 | 0 | 57.5358729 | 28.8586826 | 2022-10-10 04:22:32 | Pskov Oblast, Russia | |||
4002912 | 4002912 | 2022-10-08 | Russia | Pskov Oblast | 123985 | 1921 | 0 | 57.5358729 | 28.8586826 | 2022-10-09 04:21:16 | Pskov Oblast, Russia | |||
959710 | 959710 | 2022-07-19 | US | Georgia | Gwinnett | 13135 | 225281 | 1921 | 0 | 33.96044201 | -84.02137802 | 2022-07-20 04:20:59 | Gwinnett, Georgia, US | |
3211097 | 3211097 | 2022-07-18 | US | Georgia | Gwinnett | 13135 | 225281 | 1921 | 0 | 33.96044201 | -84.02137802 | 2022-07-19 04:20:58 | Gwinnett, Georgia, US | |
3406272 | 3406272 | 2022-07-17 | US | Georgia | Gwinnett | 13135 | 225281 | 1921 | 0 | 33.96044201 | -84.02137802 | 2022-07-18 04:20:59 | Gwinnett, Georgia, US | |
2152472 | 2152472 | 2022-07-16 | US | Georgia | Gwinnett | 13135 | 225281 | 1921 | 0 | 33.96044201 | -84.02137802 | 2022-07-17 04:21:15 | Gwinnett, Georgia, US | |
2419705 | 2419705 | 2022-07-15 | US | Georgia | Gwinnett | 13135 | 225281 | 1921 | 0 | 33.96044201 | -84.02137802 | 2022-07-16 04:21:05 | Gwinnett, Georgia, US | |
3429780 | 3429780 | 2022-07-14 | US | Georgia | Gwinnett | 13135 | 225281 | 1921 | 0 | 33.96044201 | -84.02137802 | 2022-07-15 04:20:53 | Gwinnett, Georgia, US | |
3110300 | 3110300 | 2022-07-13 | US | Georgia | Gwinnett | 13135 | 225281 | 1921 | 0 | 33.96044201 | -84.02137802 | 2022-07-14 04:20:57 | Gwinnett, Georgia, US | |
3982815 | 3982815 | 2022-06-15 | Russia | Kaliningrad Oblast | 169127 | 1921 | 0 | 54.7293041 | 21.1489473 | 2022-06-16 04:20:55 | Kaliningrad Oblast, Russia | |||
947056 | 947056 | 2022-06-14 | Russia | Kaliningrad Oblast | 169119 | 1921 | 0 | 54.7293041 | 21.1489473 | 2022-06-15 04:20:54 | Kaliningrad Oblast, Russia | |||
2979464 | 2979464 | 2022-06-13 | Russia | Kaliningrad Oblast | 169100 | 1921 | 0 | 54.7293041 | 21.1489473 | 2022-06-14 04:20:52 | Kaliningrad Oblast, Russia | |||
231881 | 231881 | 2022-05-31 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-06-01 04:20:55 | Bucks, Pennsylvania, US | |
3188646 | 3188646 | 2022-05-30 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-05-31 04:20:51 | Bucks, Pennsylvania, US | |
3200795 | 3200795 | 2022-05-29 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-05-30 04:20:50 | Bucks, Pennsylvania, US | |
2727673 | 2727673 | 2022-05-28 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-05-29 04:20:53 | Bucks, Pennsylvania, US | |
2725256 | 2725256 | 2022-05-28 | Russia | Orel Oblast | 112886 | 1921 | 0 | 52.9685433 | 36.0692477 | 2022-05-29 04:20:53 | Orel Oblast, Russia | |||
1316854 | 1316854 | 2022-05-27 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-05-28 04:21:07 | Bucks, Pennsylvania, US | |
1314437 | 1314437 | 2022-05-27 | Russia | Orel Oblast | 112842 | 1921 | 0 | 52.9685433 | 36.0692477 | 2022-05-28 04:21:07 | Orel Oblast, Russia | |||
1852646 | 1852646 | 2022-05-26 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-05-27 04:20:56 | Bucks, Pennsylvania, US | |
2050522 | 2050522 | 2022-05-25 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-05-26 04:20:50 | Bucks, Pennsylvania, US | |
2047928 | 2047928 | 2022-05-25 | Malaysia | Perak | 203168 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-26 04:20:50 | Perak, Malaysia | |||
2999366 | 2999366 | 2022-05-24 | Malaysia | Perak | 203051 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-25 04:20:56 | Perak, Malaysia | |||
3593087 | 3593087 | 2022-05-23 | Malaysia | Perak | 202995 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-24 04:20:57 | Perak, Malaysia | |||
624533 | 624533 | 2022-05-22 | US | Pennsylvania | Bucks | 42017 | 129314 | 1921 | 0 | 40.33682119 | -75.10836643 | 2022-05-26 04:20:50 | Bucks, Pennsylvania, US | |
621939 | 621939 | 2022-05-22 | Malaysia | Perak | 203168 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-26 04:20:50 | Perak, Malaysia | |||
1109635 | 1109635 | 2022-05-21 | Malaysia | Perak | 202835 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-22 04:20:52 | Perak, Malaysia | |||
1169259 | 1169259 | 2022-05-20 | Malaysia | Perak | 202737 | 1921 | 0 | 4.5921 | 101.0901 | 2022-05-21 04:20:58 | Perak, Malaysia | |||
3022173 | 3022173 | 2022-03-23 | Germany | Mecklenburg-Vorpommern | 353597 | 1921 | 0 | 53.6127 | 12.4296 | 2022-03-24 04:20:43 | Mecklenburg-Vorpommern, Germany | |||
3674694 | 3674694 | 2022-02-15 | US | Texas | Cameron | 48061 | 96490 | 1921 | 0 | 26.14524221 | -97.48140372 | 2022-02-16 04:21:10 | Cameron, Texas, US | |
3809879 | 3809879 | 2022-01-28 | India | Puducherry | 158969 | 1921 | 0 | 11.882658000000001 | 78.86498 | 2022-01-29 04:21:10 | Puducherry, India | |||
3425225 | 3425225 | 2022-01-21 | Senegal | 83855 | 1921 | 0 | 14.4974 | -14.4524 | 2022-01-22 04:21:13 | Senegal | ||||
1964200 | 1964200 | 2022-01-20 | Ukraine | Sevastopol* | 54341 | 1921 | 0 | 44.6054 | 33.522 | 2022-01-21 04:21:09 | Sevastopol*, Ukraine | |||
907816 | 907816 | 2021-11-24 | Ukraine | Luhansk Oblast | 56152 | 1921 | 0 | 48.574 | 39.3078 | 2021-11-25 04:22:33 | Luhansk Oblast, Ukraine | |||
718140 | 718140 | 2021-11-12 | Yemen | 9912 | 1921 | 0 | 15.552726999999999 | 48.516388 | 2021-11-13 04:21:38 | Yemen | ||||
287937 | 287937 | 2021-10-31 | India | Manipur | 123731 | 1921 | 0 | 24.738975 | 93.882541 | 2021-11-01 04:22:01 | Manipur, India | |||
2943410 | 2943410 | 2021-10-15 | Malaysia | Kedah | 142675 | 1921 | 0 | 6.1184 | 100.3685 | 2021-10-16 04:21:15 | Kedah, Malaysia | |||
493243 | 493243 | 2021-10-14 | US | Massachusetts | Worcester | 25027 | 93095 | 1921 | 0 | 42.35026951 | -71.90493363 | 2021-10-15 04:21:26 | Worcester, Massachusetts, US | |
2959489 | 2959489 | 2021-10-08 | Mozambique | 150935 | 1921 | 0 | -18.665695 | 35.529562 | 2021-10-09 04:21:34 | Mozambique | ||||
2076204 | 2076204 | 2021-09-26 | Russia | Tyumen Oblast | 60823 | 1921 | 0 | 58.8206488 | 70.36588370000001 | 2021-09-27 04:21:16 | Tyumen Oblast, Russia | |||
1818398 | 1818398 | 2021-09-19 | Ukraine | Chernivtsi Oblast | 85279 | 1921 | 0 | 48.2917 | 25.9352 | 2021-09-20 04:21:22 | Chernivtsi Oblast, Ukraine | |||
2279727 | 2279727 | 2021-09-08 | US | California | Sacramento | 6067 | 145832 | 1921 | 0 | 38.45106826 | -121.34253740000001 | 2021-09-09 04:21:27 | Sacramento, California, US | |
3631809 | 3631809 | 2021-07-14 | Colombia | Meta | 80310 | 1921 | 76756 | 1633 | 3.272 | -73.0877 | 2021-07-15 04:21:48 | Meta, Colombia | ||
1081774 | 1081774 | 2021-05-14 | Colombia | Huila | 55463 | 1921 | 52481 | 1061 | 2.5359 | -75.5277 | 2021-05-15 04:20:58 | Huila, Colombia | ||
3704287 | 3704287 | 2021-04-27 | US | New Jersey | Union | 34039 | 69712 | 1921 | 0 | 40.65835409 | -74.30680092 | 2021-04-28 04:20:32 | Union, New Jersey, US | |
36715 | 36715 | 2021-04-12 | Spain | Asturias | 48652 | 1921 | 1063 | 45668 | 43.3614 | -5.8593 | 2021-04-13 04:20:37 | Asturias, Spain | ||
3710100 | 3710100 | 2021-04-03 | India | Odisha | 342224 | 1921 | 337635 | 2668 | 20.505428 | 84.418059 | 2021-04-04 04:20:49 | Odisha, India | ||
241216 | 241216 | 2021-04-02 | India | Odisha | 341772 | 1921 | 337430 | 2421 | 20.505428 | 84.418059 | 2021-04-03 04:20:44 | Odisha, India | ||
1302013 | 1302013 | 2021-04-01 | India | Odisha | 341311 | 1921 | 337212 | 2178 | 20.505428 | 84.418059 | 2021-04-02 04:20:36 | Odisha, India | ||
637885 | 637885 | 2021-03-31 | India | Odisha | 340917 | 1921 | 337091 | 1905 | 20.505428 | 84.418059 | 2021-04-01 04:27:05 | Odisha, India | ||
3643514 | 3643514 | 2021-03-30 | India | Odisha | 340620 | 1921 | 336930 | 1769 | 20.505428 | 84.418059 | 2021-03-31 04:26:25 | Odisha, India | ||
1293627 | 1293627 | 2021-03-29 | Ukraine | Kharkiv Oblast | 102136 | 1921 | 84163 | 16052 | 49.9935 | 36.2304 | 2021-03-30 04:26:23 | Kharkiv Oblast, Ukraine | ||
1289967 | 1289967 | 2021-03-29 | India | Odisha | 340402 | 1921 | 336809 | 1672 | 20.505428 | 84.418059 | 2021-03-30 04:26:23 | Odisha, India | ||
3369488 | 3369488 | 2021-03-21 | Peru | Huanuco | 26120 | 1921 | 0 | 24199 | -9.421676 | -76.040642 | 2021-03-22 05:25:43 | Huanuco, Peru | ||
530415 | 530415 | 2021-02-22 | Belarus | 279456 | 1921 | 269428 | 8107 | 53.7098 | 27.9534 | 2021-02-23 05:23:41 | Belarus | |||
3539629 | 3539629 | 2021-02-12 | Peru | Puno | 22259 | 1921 | 0 | 20338 | -14.995826999999998 | -69.922726 | 2021-02-13 05:22:12 | Puno, Peru | ||
2213832 | 2213832 | 2021-01-30 | US | New Jersey | Middlesex | 34023 | 63619 | 1921 | 0 | 61698 | 40.43629879 | -74.41426991 | 2021-01-31 05:22:42 | Middlesex, New Jersey, US |
3503307 | 3503307 | 2021-01-17 | India | Jammu and Kashmir | 123343 | 1921 | 120198 | 1224 | 33.75943 | 76.612638 | 2021-01-18 05:22:34 | Jammu and Kashmir, India | ||
3101390 | 3101390 | 2021-01-16 | India | Jammu and Kashmir | 123217 | 1921 | 120016 | 1280 | 33.75943 | 76.612638 | 2021-01-17 05:22:17 | Jammu and Kashmir, India | ||
2626526 | 2626526 | 2021-01-10 | US | Connecticut | Hartford | 9003 | 51890 | 1921 | 0 | 49969 | 41.80283011 | -72.73103891 | 2021-01-11 05:21:50 | Hartford, Connecticut, US |
3900614 | 3900614 | 2021-01-09 | US | Connecticut | Hartford | 9003 | 51890 | 1921 | 0 | 49969 | 41.80283011 | -72.73103891 | 2021-01-10 05:22:12 | Hartford, Connecticut, US |
154637 | 154637 | 2021-01-08 | US | Connecticut | Hartford | 9003 | 51890 | 1921 | 0 | 49969 | 41.80283011 | -72.73103891 | 2021-01-09 05:22:18 | Hartford, Connecticut, US |
1062565 | 1062565 | 2021-01-04 | US | Florida | Palm Beach | 12099 | 86275 | 1921 | 0 | 84354 | 26.64676272 | -80.46536002 | 2021-01-05 05:21:49 | Palm Beach, Florida, US |
3777759 | 3777759 | 2020-12-27 | Colombia | Norte de Santander | 38993 | 1921 | 34685 | 2387 | 7.9463 | -72.8988 | 2020-12-28 05:22:06 | Norte de Santander, Colombia | ||
205311 | 205311 | 2020-12-25 | US | Texas | Dallas | 48113 | 155481 | 1921 | 0 | 177497 | 32.76670599 | -96.7779605 | 2020-12-26 05:22:28 | Dallas, Texas, US |
1599908 | 1599908 | 2020-12-10 | Afghanistan | 48540 | 1921 | 38099 | 8520 | 33.93911 | 67.709953 | 2020-12-11 05:26:59 | Afghanistan | |||
2701494 | 2701494 | 2020-11-20 | Italy | Lazio | 97449 | 1921 | 17782 | 77746 | 41.89277044 | 12.48366722 | 2020-11-21 05:25:51 | Lazio, Italy | ||
3489869 | 3489869 | 2020-07-13 | US | Massachusetts | Middlesex | 25017 | 24536 | 1921 | 0 | 22615 | 42.48607732 | -71.39049229 | 2020-07-14 04:34:46 | Middlesex, Massachusetts, US |
3866977 | 3866977 | 2020-06-03 | Italy | Veneto | 19164 | 1921 | 15856 | 1387 | 45.43490485 | 12.33845213 | 2020-06-04 02:33:14 | Veneto, Italy | ||
2556019 | 2556019 | 2020-06-02 | Italy | Veneto | 19162 | 1921 | 15838 | 1403 | 45.43490485 | 12.33845213 | 2020-06-03 02:33:13 | Veneto, Italy | ||
1783074 | 1783074 | 2020-02-18 | Mainland China | Hubei | 61682 | 1921 | 9128 | 30.9756 | 112.2707 | 2020-02-18T23:13:11 |
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]);