johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
68 rows where deaths = 2468 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076098 | 1076098 | 2022-12-28 | US | New Jersey | Union | 34039 | 188635 | 2468 | 0 | 40.65835409 | -74.30680092 | 2022-12-29 04:21:01 | Union, New Jersey, US | |
2063676 | 2063676 | 2022-11-19 | Chile | Los Lagos | 232031 | 2468 | 0 | -41.9198 | -72.1416 | 2022-11-20 04:21:08 | Los Lagos, Chile | |||
1755070 | 1755070 | 2022-11-18 | Chile | Los Lagos | 231851 | 2468 | 0 | -41.9198 | -72.1416 | 2022-11-19 04:21:14 | Los Lagos, Chile | |||
2275571 | 2275571 | 2022-10-20 | Ukraine | Sevastopol* | 95463 | 2468 | 0 | 44.6054 | 33.522 | 2022-10-21 04:22:23 | Sevastopol*, Ukraine | |||
1810674 | 1810674 | 2022-10-05 | Germany | Mecklenburg-Vorpommern | 612399 | 2468 | 0 | 53.6127 | 12.4296 | 2022-10-06 04:21:22 | Mecklenburg-Vorpommern, Germany | |||
3078274 | 3078274 | 2022-07-04 | Russia | Kemerovo Oblast | 166370 | 2468 | 0 | 54.5335781 | 87.342861 | 2022-07-05 04:20:45 | Kemerovo Oblast, Russia | |||
3527443 | 3527443 | 2022-06-04 | Italy | Sardegna | 315041 | 2468 | 0 | 39.21531192 | 9.110616306 | 2022-06-05 04:20:55 | Sardegna, Italy | |||
2331602 | 2331602 | 2022-05-08 | Russia | Kursk Oblast | 117490 | 2468 | 0 | 51.6568453 | 36.4852695 | 2022-05-09 04:20:54 | Kursk Oblast, Russia | |||
3917608 | 3917608 | 2022-05-01 | US | Maryland | Baltimore | 24005 | 133686 | 2468 | 0 | 39.45784712 | -76.62911955 | 2022-05-02 04:21:10 | Baltimore, Maryland, US | |
2842412 | 2842412 | 2022-04-30 | US | Maryland | Baltimore | 24005 | 133686 | 2468 | 0 | 39.45784712 | -76.62911955 | 2022-05-01 04:20:57 | Baltimore, Maryland, US | |
1158725 | 1158725 | 2022-04-29 | US | Maryland | Baltimore | 24005 | 133686 | 2468 | 0 | 39.45784712 | -76.62911955 | 2022-04-30 04:21:05 | Baltimore, Maryland, US | |
1697907 | 1697907 | 2022-04-28 | US | Maryland | Baltimore | 24005 | 133546 | 2468 | 0 | 39.45784712 | -76.62911955 | 2022-04-29 04:20:59 | Baltimore, Maryland, US | |
3730105 | 3730105 | 2022-04-03 | Estonia | 558706 | 2468 | 0 | 58.5953 | 25.0136 | 2022-04-04 04:20:51 | Estonia | ||||
3350432 | 3350432 | 2022-04-01 | Chile | OHiggins | 146722 | 2468 | 0 | -34.5755 | -71.0022 | 2022-04-02 04:20:47 | OHiggins, Chile | |||
876106 | 876106 | 2022-03-27 | Colombia | Risaralda | 106286 | 2468 | 0 | 5.3158 | -75.9928 | 2022-03-28 04:20:33 | Risaralda, Colombia | |||
1362609 | 1362609 | 2022-02-08 | Russia | Tver Oblast | 119535 | 2468 | 0 | 57.1134475 | 35.174442799999994 | 2022-02-09 04:21:04 | Tver Oblast, Russia | |||
554538 | 554538 | 2022-01-16 | Canada | British Columbia | 293521 | 2468 | 0 | 53.7267 | -127.6476 | 2022-01-17 04:21:08 | British Columbia, Canada | |||
3840259 | 3840259 | 2022-01-15 | Canada | British Columbia | 293521 | 2468 | 0 | 53.7267 | -127.6476 | 2022-01-16 04:21:12 | British Columbia, Canada | |||
99074 | 99074 | 2022-01-14 | Canada | British Columbia | 293521 | 2468 | 0 | 53.7267 | -127.6476 | 2022-01-15 04:21:07 | British Columbia, Canada | |||
1391833 | 1391833 | 2022-01-07 | US | New Jersey | Hudson | 34017 | 136423 | 2468 | 0 | 40.73766234 | -74.07515667 | 2022-01-08 04:21:53 | Hudson, New Jersey, US | |
1286045 | 1286045 | 2022-01-04 | Kuwait | 420796 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2022-01-05 04:21:59 | Kuwait | ||||
1700389 | 1700389 | 2022-01-03 | Kuwait | 419314 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2022-01-04 04:22:17 | Kuwait | ||||
3519472 | 3519472 | 2022-01-02 | Kuwait | 418332 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2022-01-03 02:22:25 | Kuwait | ||||
2167602 | 2167602 | 2022-01-01 | Kuwait | 417723 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2022-01-02 04:20:52 | Kuwait | ||||
2777033 | 2777033 | 2021-12-31 | Kuwait | 417135 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2022-01-01 04:22:14 | Kuwait | ||||
3998690 | 3998690 | 2021-12-30 | Kuwait | 416631 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2021-12-31 04:21:50 | Kuwait | ||||
1668497 | 1668497 | 2021-12-29 | Kuwait | 416077 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2021-12-30 04:21:25 | Kuwait | ||||
1432606 | 1432606 | 2021-12-28 | Kuwait | 415678 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2021-12-29 03:21:43 | Kuwait | ||||
730567 | 730567 | 2021-12-27 | Kuwait | 415349 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2021-12-28 04:21:47 | Kuwait | ||||
2111739 | 2111739 | 2021-12-26 | Kuwait | 415151 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2021-12-27 04:21:58 | Kuwait | ||||
3605111 | 3605111 | 2021-12-25 | Kuwait | 414911 | 2468 | 0 | 29.311659999999996 | 47.481766 | 2021-12-26 04:21:50 | Kuwait | ||||
907823 | 907823 | 2021-11-24 | Ukraine | Sumy Oblast | 122651 | 2468 | 0 | 50.9077 | 34.7981 | 2021-11-25 04:22:33 | Sumy Oblast, Ukraine | |||
906825 | 906825 | 2021-11-24 | US | Pennsylvania | Allegheny | 42003 | 146794 | 2468 | 0 | 40.46809875 | -79.98167747 | 2021-11-25 04:22:33 | Allegheny, Pennsylvania, US | |
3749390 | 3749390 | 2021-11-22 | Russia | Vologda Oblast | 86986 | 2468 | 0 | 60.0391461 | 43.1215213 | 2021-11-23 04:22:39 | Vologda Oblast, Russia | |||
3289144 | 3289144 | 2021-11-18 | Russia | Murmansk Oblast | 83770 | 2468 | 0 | 68.00004179999999 | 33.9999151 | 2021-11-19 04:21:40 | Murmansk Oblast, Russia | |||
569278 | 569278 | 2021-10-29 | US | New Jersey | Middlesex | 34023 | 106341 | 2468 | 0 | 40.43629879 | -74.41426991 | 2021-10-30 04:22:03 | Middlesex, New Jersey, US | |
706657 | 706657 | 2021-09-29 | Russia | Leningrad Oblast | 68941 | 2468 | 0 | 60.185329599999996 | 32.3925325 | 2021-09-30 04:21:20 | Leningrad Oblast, Russia | |||
2076146 | 2076146 | 2021-09-26 | Russia | Dagestan Republic | 51407 | 2468 | 0 | 43.05749160000001 | 47.1332224 | 2021-09-27 04:21:16 | Dagestan Republic, Russia | |||
3193844 | 3193844 | 2021-09-06 | Colombia | Cesar | 88312 | 2468 | 0 | 9.3373 | -73.6536 | 2021-09-07 04:21:35 | Cesar, Colombia | |||
511754 | 511754 | 2021-08-19 | Kyrgyzstan | 173186 | 2468 | 0 | 41.20438 | 74.766098 | 2021-08-20 04:21:33 | Kyrgyzstan | ||||
2521822 | 2521822 | 2021-08-18 | Ukraine | Zaporizhia Oblast | 106019 | 2468 | 0 | 47.8388 | 35.1396 | 2021-08-19 04:21:15 | Zaporizhia Oblast, Ukraine | |||
244957 | 244957 | 2021-08-17 | Albania | 136598 | 2468 | 0 | 41.1533 | 20.1683 | 2021-08-18 04:21:35 | Albania | ||||
1484009 | 1484009 | 2021-08-13 | US | Arizona | Pima | 4019 | 122635 | 2468 | 0 | 32.0971334 | -111.7890033 | 2021-08-14 04:21:25 | Pima, Arizona, US | |
2900139 | 2900139 | 2021-08-12 | US | Arizona | Pima | 4019 | 122363 | 2468 | 0 | 32.0971334 | -111.7890033 | 2021-08-13 04:21:24 | Pima, Arizona, US | |
1342743 | 1342743 | 2021-08-11 | US | Arizona | Pima | 4019 | 122068 | 2468 | 0 | 32.0971334 | -111.7890033 | 2021-08-12 04:21:25 | Pima, Arizona, US | |
2351890 | 2351890 | 2021-08-10 | US | Arizona | Pima | 4019 | 122012 | 2468 | 0 | 32.0971334 | -111.7890033 | 2021-08-11 04:21:58 | Pima, Arizona, US | |
1956825 | 1956825 | 2021-08-05 | Spain | Galicia | 165304 | 2468 | 0 | 42.5751 | -8.1339 | 2021-08-06 04:21:18 | Galicia, Spain | |||
2072102 | 2072102 | 2021-07-02 | Russia | Altai Krai | 54787 | 2468 | 47265 | 5054 | 52.6932243 | 82.69314240000001 | 2021-07-03 04:21:37 | Altai Krai, Russia | ||
3125582 | 3125582 | 2021-06-28 | Mexico | Aguascalientes | 26756 | 2468 | 0 | 24288 | 21.8853 | -102.2916 | 2021-06-29 04:21:28 | Aguascalientes, Mexico | ||
2590077 | 2590077 | 2021-06-27 | Mexico | Aguascalientes | 26755 | 2468 | 0 | 24287 | 21.8853 | -102.2916 | 2021-06-28 04:21:29 | Aguascalientes, Mexico | ||
3958581 | 3958581 | 2021-06-26 | Mexico | Aguascalientes | 26755 | 2468 | 0 | 24287 | 21.8853 | -102.2916 | 2021-06-27 04:21:39 | Aguascalientes, Mexico | ||
1771321 | 1771321 | 2021-05-23 | Italy | Abruzzo | 73689 | 2468 | 65254 | 5967 | 42.35122196 | 13.39843823 | 2021-05-24 04:20:53 | Abruzzo, Italy | ||
2939177 | 2939177 | 2021-05-16 | Colombia | Magdalena | 65383 | 2468 | 61100 | 1815 | 10.4113 | -74.4057 | 2021-05-17 04:20:34 | Magdalena, Colombia | ||
2571805 | 2571805 | 2021-04-13 | Netherlands | Noord-Holland | 234656 | 2468 | 0 | 231801 | 52.60090600000001 | 4.918688 | 2021-04-14 04:20:41 | Noord-Holland, Netherlands | ||
1881156 | 1881156 | 2021-03-26 | Peru | Puno | 25630 | 2468 | 0 | 23162 | -14.995826999999998 | -69.922726 | 2021-03-27 05:25:04 | Puno, Peru | ||
1735565 | 1735565 | 2021-03-14 | US | Texas | El Paso | 48141 | 106515 | 2468 | 0 | 31.76980765 | -106.2363275 | 2021-03-15 05:25:51 | El Paso, Texas, US | |
2625996 | 2625996 | 2021-01-10 | Netherlands | Noord-Brabant | 135130 | 2468 | 0 | 134060 | 51.561174 | 5.184942 | 2021-01-11 05:21:50 | Noord-Brabant, Netherlands | ||
2864575 | 2864575 | 2021-01-06 | Colombia | Santander | 69936 | 2468 | 63213 | 4255 | 6.6437 | -73.6536 | 2021-01-07 05:22:03 | Santander, Colombia | ||
2227514 | 2227514 | 2021-01-02 | Italy | Sicilia | 95500 | 2468 | 58082 | 34950 | 38.11569725 | 13.362356699999998 | 2021-01-03 05:22:52 | Sicilia, Italy | ||
766075 | 766075 | 2020-12-29 | Brazil | Sergipe | 110804 | 2468 | 97916 | 10420 | -10.5741 | -37.3857 | 2020-12-30 05:22:34 | Sergipe, Brazil | ||
3761315 | 3761315 | 2020-12-28 | Brazil | Alagoas | 103748 | 2468 | 98996 | 2284 | -9.5713 | -36.782 | 2020-12-29 05:22:37 | Alagoas, Brazil | ||
1818752 | 1818752 | 2020-12-08 | India | Rajasthan | 284116 | 2468 | 260773 | 20875 | 26.583423 | 73.847973 | 2020-12-09 05:28:01 | Rajasthan, India | ||
3441133 | 3441133 | 2020-11-11 | Sweden | Stockholm | 47685 | 2468 | 0 | 45217 | 59.6025 | 18.1384 | 2020-11-12 05:25:55 | Stockholm, Sweden | ||
2243561 | 2243561 | 2020-10-30 | Portugal | 137272 | 2468 | 77449 | 57355 | 39.3999 | -8.2245 | 2020-10-31 04:24:44 | Portugal | |||
3480288 | 3480288 | 2020-10-26 | Israel | 311187 | 2468 | 294212 | 14507 | 31.046051 | 34.851612 | 2020-10-27 04:24:45 | Israel | |||
3264690 | 3264690 | 2020-07-31 | Peru | Loreto | 11292 | 2468 | 0 | 8824 | -4.124847 | -74.424115 | 2020-08-01 04:36:27 | Loreto, Peru | ||
737547 | 737547 | 2020-06-12 | Chile | Metropolitana | 129694 | 2468 | 0 | 127226 | -33.4376 | -70.6505 | 2020-06-13 03:33:14 | Metropolitana, Chile | ||
2548273 | 2548273 | 2020-05-27 | Brazil | Pernambuco | 29919 | 2468 | 0 | 27451 | -8.8137 | -36.9541 | 2020-05-28 02:32:31 | Pernambuco, 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]);