johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
81 rows where deaths = 2578 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
545036 | 545036 | 2022-12-15 | US | New York | Richmond | 36085 | 215010 | 2578 | 0 | 40.58582155 | -74.14808598 | 2022-12-16 04:21:01 | Richmond, New York, US | |
1985457 | 1985457 | 2022-12-07 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-08 04:21:07 | Fulton, Georgia, US | |
3714980 | 3714980 | 2022-12-06 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-07 04:20:58 | Fulton, Georgia, US | |
2415685 | 2415685 | 2022-12-05 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-06 04:21:03 | Fulton, Georgia, US | |
719293 | 719293 | 2022-12-04 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-05 04:20:58 | Fulton, Georgia, US | |
2817582 | 2817582 | 2022-12-03 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-04 04:20:56 | Fulton, Georgia, US | |
834438 | 834438 | 2022-12-02 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-03 04:21:02 | Fulton, Georgia, US | |
2136968 | 2136968 | 2022-12-01 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-02 04:21:07 | Fulton, Georgia, US | |
1965384 | 1965384 | 2022-11-30 | US | Georgia | Fulton | 13121 | 264704 | 2578 | 0 | 33.79216944 | -84.46319413 | 2022-12-01 04:21:03 | Fulton, Georgia, US | |
852187 | 852187 | 2022-11-02 | US | Oklahoma | Oklahoma | 40109 | 231915 | 2578 | 0 | 35.55140095 | -97.40716948 | 2022-11-03 04:22:05 | Oklahoma, Oklahoma, US | |
713038 | 713038 | 2022-11-01 | US | Oklahoma | Oklahoma | 40109 | 231915 | 2578 | 0 | 35.55140095 | -97.40716948 | 2022-11-02 04:22:09 | Oklahoma, Oklahoma, US | |
3287487 | 3287487 | 2022-10-31 | US | Oklahoma | Oklahoma | 40109 | 231915 | 2578 | 0 | 35.55140095 | -97.40716948 | 2022-11-01 04:22:36 | Oklahoma, Oklahoma, US | |
322520 | 322520 | 2022-10-30 | US | Oklahoma | Oklahoma | 40109 | 231915 | 2578 | 0 | 35.55140095 | -97.40716948 | 2022-10-31 04:21:36 | Oklahoma, Oklahoma, US | |
914796 | 914796 | 2022-10-29 | US | Oklahoma | Oklahoma | 40109 | 231915 | 2578 | 0 | 35.55140095 | -97.40716948 | 2022-10-30 04:22:14 | Oklahoma, Oklahoma, US | |
1369065 | 1369065 | 2022-10-28 | US | Oklahoma | Oklahoma | 40109 | 231915 | 2578 | 0 | 35.55140095 | -97.40716948 | 2022-10-29 04:21:13 | Oklahoma, Oklahoma, US | |
3040920 | 3040920 | 2022-10-27 | US | Oklahoma | Oklahoma | 40109 | 231915 | 2578 | 0 | 35.55140095 | -97.40716948 | 2022-10-28 04:22:31 | Oklahoma, Oklahoma, US | |
198585 | 198585 | 2022-10-19 | Sweden | Skane | 346063 | 2578 | 0 | 55.9903 | 13.5958 | 2022-10-20 04:22:59 | Skane, Sweden | |||
2757246 | 2757246 | 2022-10-18 | Sweden | Skane | 346063 | 2578 | 0 | 55.9903 | 13.5958 | 2022-10-19 04:22:26 | Skane, Sweden | |||
2025080 | 2025080 | 2022-10-17 | Sweden | Skane | 346063 | 2578 | 0 | 55.9903 | 13.5958 | 2022-10-18 04:22:42 | Skane, Sweden | |||
2159858 | 2159858 | 2022-10-16 | Sweden | Skane | 346063 | 2578 | 0 | 55.9903 | 13.5958 | 2022-10-17 04:20:31 | Skane, Sweden | |||
516055 | 516055 | 2022-10-15 | Sweden | Skane | 346063 | 2578 | 0 | 55.9903 | 13.5958 | 2022-10-16 04:22:39 | Skane, Sweden | |||
2033112 | 2033112 | 2022-10-14 | Sweden | Skane | 346063 | 2578 | 0 | 55.9903 | 13.5958 | 2022-10-15 04:22:00 | Skane, Sweden | |||
3753800 | 3753800 | 2022-10-13 | Sweden | Skane | 346063 | 2578 | 0 | 55.9903 | 13.5958 | 2022-10-14 04:22:28 | Skane, Sweden | |||
1810993 | 1810993 | 2022-10-05 | Russia | Khanty-Mansi Autonomous Okrug | 244459 | 2578 | 0 | 61.0259025 | 69.0982628 | 2022-10-06 04:21:22 | Khanty-Mansi Autonomous Okrug, Russia | |||
2343639 | 2343639 | 2022-08-31 | Russia | Kemerovo Oblast | 180647 | 2578 | 0 | 54.5335781 | 87.342861 | 2022-09-01 04:21:03 | Kemerovo Oblast, Russia | |||
3909577 | 3909577 | 2022-08-11 | US | Maryland | Baltimore | 24005 | 152493 | 2578 | 0 | 39.45784712 | -76.62911955 | 2022-08-12 04:20:54 | Baltimore, Maryland, US | |
3908303 | 3908303 | 2022-08-11 | Spain | Extremadura | 299248 | 2578 | 0 | 39.4937 | -6.0679 | 2022-08-12 04:20:54 | Extremadura, Spain | |||
1346620 | 1346620 | 2022-08-10 | Spain | Extremadura | 299248 | 2578 | 0 | 39.4937 | -6.0679 | 2022-08-11 04:20:49 | Extremadura, Spain | |||
1086375 | 1086375 | 2022-08-09 | Spain | Extremadura | 299248 | 2578 | 0 | 39.4937 | -6.0679 | 2022-08-10 04:20:57 | Extremadura, Spain | |||
2788813 | 2788813 | 2022-07-10 | Chile | OHiggins | 173074 | 2578 | 0 | -34.5755 | -71.0022 | 2022-07-11 04:20:46 | OHiggins, Chile | |||
141766 | 141766 | 2022-07-09 | Chile | OHiggins | 172638 | 2578 | 0 | -34.5755 | -71.0022 | 2022-07-10 04:20:54 | OHiggins, Chile | |||
1109341 | 1109341 | 2022-05-21 | Chile | Araucania | 218244 | 2578 | 0 | -38.9489 | -72.3311 | 2022-05-22 04:20:52 | Araucania, Chile | |||
2309009 | 2309009 | 2022-04-20 | US | Minnesota | Hennepin | 27053 | 301310 | 2578 | 0 | 45.00761521 | -93.47694895 | 2022-04-21 04:20:46 | Hennepin, Minnesota, US | |
3730288 | 3730288 | 2022-04-03 | Malaysia | Kedah | 293237 | 2578 | 0 | 6.1184 | 100.3685 | 2022-04-04 04:20:51 | Kedah, Malaysia | |||
1468390 | 1468390 | 2022-03-24 | Spain | Asturias | 201625 | 2578 | 0 | 43.3614 | -5.8593 | 2022-03-25 04:20:46 | Asturias, Spain | |||
3022564 | 3022564 | 2022-03-23 | Spain | Asturias | 201625 | 2578 | 0 | 43.3614 | -5.8593 | 2022-03-24 04:20:43 | Asturias, Spain | |||
1905486 | 1905486 | 2022-03-22 | Spain | Asturias | 201625 | 2578 | 0 | 43.3614 | -5.8593 | 2022-03-23 04:20:48 | Asturias, Spain | |||
919479 | 919479 | 2022-03-08 | China | Hong Kong | 739946 | 2578 | 0 | 22.3 | 114.2 | 2022-03-09 04:20:59 | Hong Kong, China | |||
2527830 | 2527830 | 2022-03-02 | US | Ohio | Franklin | 39049 | 286424 | 2578 | 0 | 39.96995815 | -83.01115755 | 2022-03-03 04:21:01 | Franklin, Ohio, US | |
1513643 | 1513643 | 2022-02-24 | US | New York | Erie | 36029 | 205386 | 2578 | 0 | 42.76249024 | -78.73063652 | 2022-02-25 04:21:11 | Erie, New York, US | |
1960747 | 1960747 | 2022-01-20 | Russia | Astrakhan Oblast | 84158 | 2578 | 0 | 47.1878186 | 47.608851 | 2022-01-21 04:21:09 | Astrakhan Oblast, Russia | |||
3519557 | 3519557 | 2022-01-02 | Netherlands | Gelderland | 361769 | 2578 | 0 | 52.061738 | 5.939114 | 2022-01-03 02:22:25 | Gelderland, Netherlands | |||
2167687 | 2167687 | 2022-01-01 | Netherlands | Gelderland | 360003 | 2578 | 0 | 52.061738 | 5.939114 | 2022-01-02 04:20:52 | Gelderland, Netherlands | |||
798251 | 798251 | 2021-12-22 | Colombia | Boyaca | 106749 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-23 04:21:21 | Boyaca, Colombia | |||
3828291 | 3828291 | 2021-12-21 | Colombia | Boyaca | 106744 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-22 04:21:54 | Boyaca, Colombia | |||
1254594 | 1254594 | 2021-12-20 | Colombia | Boyaca | 106729 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-21 03:21:27 | Boyaca, Colombia | |||
2903537 | 2903537 | 2021-12-19 | Colombia | Boyaca | 106707 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-20 04:21:43 | Boyaca, Colombia | |||
1258610 | 1258610 | 2021-12-18 | Colombia | Boyaca | 106694 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-19 04:21:11 | Boyaca, Colombia | |||
2398638 | 2398638 | 2021-12-17 | Colombia | Boyaca | 106682 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-18 02:22:20 | Boyaca, Colombia | |||
1716176 | 1716176 | 2021-12-16 | Colombia | Boyaca | 106668 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-17 04:22:14 | Boyaca, Colombia | |||
3496010 | 3496010 | 2021-12-15 | Colombia | Boyaca | 106657 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-16 04:22:11 | Boyaca, Colombia | |||
2087795 | 2087795 | 2021-12-14 | Colombia | Boyaca | 106632 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-15 03:22:16 | Boyaca, Colombia | |||
782212 | 782212 | 2021-12-13 | Colombia | Boyaca | 106612 | 2578 | 0 | 5.4545 | -73.362 | 2021-12-14 04:22:38 | Boyaca, Colombia | |||
1148573 | 1148573 | 2021-12-01 | Ukraine | Sumy Oblast | 125273 | 2578 | 0 | 50.9077 | 34.7981 | 2021-12-02 04:22:37 | Sumy Oblast, Ukraine | |||
3749089 | 3749089 | 2021-11-22 | Italy | Abruzzo | 86166 | 2578 | 0 | 42.35122196 | 13.39843823 | 2021-11-23 04:22:39 | Abruzzo, Italy | |||
1014296 | 1014296 | 2021-11-21 | Italy | Abruzzo | 86124 | 2578 | 0 | 42.35122196 | 13.39843823 | 2021-11-22 04:22:20 | Abruzzo, Italy | |||
686424 | 686424 | 2021-11-13 | Malaysia | W.P. Kuala Lumpur | 197389 | 2578 | 0 | 3.139 | 101.6869 | 2021-11-14 04:21:31 | W.P. Kuala Lumpur, Malaysia | |||
3794559 | 3794559 | 2021-10-25 | US | Connecticut | Hartford | 9003 | 98308 | 2578 | 0 | 41.80283011 | -72.73103891 | 2021-10-26 04:22:09 | Hartford, Connecticut, US | |
683005 | 683005 | 2021-10-24 | US | Connecticut | Hartford | 9003 | 98052 | 2578 | 0 | 41.80283011 | -72.73103891 | 2021-10-25 04:22:31 | Hartford, Connecticut, US | |
771013 | 771013 | 2021-10-23 | US | Connecticut | Hartford | 9003 | 98052 | 2578 | 0 | 41.80283011 | -72.73103891 | 2021-10-24 04:21:22 | Hartford, Connecticut, US | |
654660 | 654660 | 2021-10-22 | US | Connecticut | Hartford | 9003 | 98052 | 2578 | 0 | 41.80283011 | -72.73103891 | 2021-10-23 04:21:32 | Hartford, Connecticut, US | |
706695 | 706695 | 2021-09-29 | Russia | Ulyanovsk Oblast | 82738 | 2578 | 0 | 54.146317700000004 | 47.2324921 | 2021-09-30 04:21:20 | Ulyanovsk Oblast, Russia | |||
1335948 | 1335948 | 2021-09-28 | US | Michigan | Oakland | 26125 | 134611 | 2578 | 0 | 42.66090111 | -83.38595416 | 2021-09-29 04:21:45 | Oakland, Michigan, US | |
1237317 | 1237317 | 2021-09-27 | US | Michigan | Oakland | 26125 | 134611 | 2578 | 0 | 42.66090111 | -83.38595416 | 2021-09-28 04:21:28 | Oakland, Michigan, US | |
1374549 | 1374549 | 2021-09-15 | Kyrgyzstan | 177389 | 2578 | 0 | 41.20438 | 74.766098 | 2021-09-16 04:22:19 | Kyrgyzstan | ||||
1385878 | 1385878 | 2021-09-13 | Russia | Saratov Oblast | 83969 | 2578 | 0 | 51.652055499999996 | 46.86319520000001 | 2021-09-14 04:21:41 | Saratov Oblast, Russia | |||
2279297 | 2279297 | 2021-09-08 | Nigeria | 197046 | 2578 | 0 | 9.082 | 8.6753 | 2021-09-09 04:21:27 | Nigeria | ||||
2067961 | 2067961 | 2021-08-31 | Latvia | 142637 | 2578 | 0 | 56.8796 | 24.6032 | 2021-09-01 04:21:38 | Latvia | ||||
3298959 | 3298959 | 2021-07-30 | US | Puerto Rico | Unassigned | 72999 | 4134 | 2578 | 0 | 18.459681 | -67.336525 | 2021-07-31 04:21:35 | Unassigned, Puerto Rico, US | |
3388170 | 3388170 | 2021-07-29 | US | Puerto Rico | Unassigned | 72999 | 4133 | 2578 | 0 | 18.459681 | -67.336525 | 2021-07-30 04:21:34 | Unassigned, Puerto Rico, US | |
1125794 | 1125794 | 2021-06-18 | Russia | Irkutsk Oblast | 71923 | 2578 | 68573 | 772 | 56.6370122 | 104.719221 | 2021-06-19 04:22:33 | Irkutsk Oblast, Russia | ||
1568320 | 1568320 | 2021-04-22 | Russia | Krasnodar Krai | 44673 | 2578 | 39298 | 2797 | 45.7684014 | 39.0261044 | 2021-04-23 04:20:52 | Krasnodar Krai, Russia | ||
3149557 | 3149557 | 2020-12-16 | India | Rajasthan | 294831 | 2578 | 277743 | 14510 | 26.583423 | 73.847973 | 2020-12-17 05:28:12 | Rajasthan, India | ||
1751554 | 1751554 | 2020-12-14 | Spain | C. Valenciana | 117532 | 2578 | 9970 | 104984 | 39.484 | -0.7533 | 2020-12-15 05:26:38 | C. Valenciana, Spain | ||
3338298 | 3338298 | 2020-11-17 | Austria | 209072 | 2578 | 136487 | 76165 | 47.5162 | 14.5501 | 2020-11-18 05:40:31 | Austria | |||
2880147 | 2880147 | 2020-11-15 | India | Chhattisgarh | 210534 | 2578 | 188869 | 19087 | 21.264705 | 82.035366 | 2020-11-16 05:25:57 | Chhattisgarh, India | ||
1452336 | 1452336 | 2020-10-27 | Brazil | Rio Grande do Norte | 81014 | 2578 | 43148 | 34355 | -5.4026 | -36.9541 | 2020-10-28 04:24:39 | Rio Grande do Norte, Brazil | ||
2171294 | 2171294 | 2020-09-09 | Brazil | Paraiba | 110727 | 2578 | 81122 | 27027 | -7.24 | -36.782 | 2020-09-10 04:29:01 | Paraiba, Brazil | ||
586470 | 586470 | 2020-08-13 | United Kingdom | Wales | 17484 | 2578 | 0 | 15898 | 52.1307 | -3.7837 | 2020-08-14 04:51:19 | Wales, United Kingdom | ||
2807831 | 2807831 | 2020-08-02 | Brazil | Espirito Santo | 84255 | 2578 | 68515 | 13145 | -19.1834 | -40.3089 | 2020-08-03 04:34:35 | Espirito Santo, Brazil | ||
2700536 | 2700536 | 2020-06-24 | Germany | Bayern | 47995 | 2578 | 44900 | 517 | 48.7904 | 11.4979 | 2020-06-25 05:26:54 | Bayern, Germany |
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]);