johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
136 rows where deaths = 2685 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752957 | 2752957 | 2022-12-29 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-30 04:21:04 | Malawi | ||||
1073963 | 1073963 | 2022-12-28 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-29 04:21:01 | Malawi | ||||
327960 | 327960 | 2022-12-27 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-28 04:21:04 | Malawi | ||||
218033 | 218033 | 2022-12-26 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-27 04:21:07 | Malawi | ||||
3222490 | 3222490 | 2022-12-25 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-26 04:21:06 | Malawi | ||||
1018404 | 1018404 | 2022-12-24 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-25 04:21:04 | Malawi | ||||
690427 | 690427 | 2022-12-23 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-24 04:21:02 | Malawi | ||||
2179637 | 2179637 | 2022-12-22 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-23 04:21:04 | Malawi | ||||
451441 | 451441 | 2022-12-21 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-22 04:20:56 | Malawi | ||||
2951440 | 2951440 | 2022-12-20 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-21 04:21:03 | Malawi | ||||
3173842 | 3173842 | 2022-12-19 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-20 04:21:04 | Malawi | ||||
1628359 | 1628359 | 2022-12-18 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-19 04:21:03 | Malawi | ||||
503738 | 503738 | 2022-12-17 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-18 04:21:03 | Malawi | ||||
3324310 | 3324310 | 2022-12-16 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-17 04:21:04 | Malawi | ||||
542822 | 542822 | 2022-12-15 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-16 04:21:01 | Malawi | ||||
348350 | 348350 | 2022-12-14 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-15 04:20:58 | Malawi | ||||
307938 | 307938 | 2022-12-13 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-14 04:21:04 | Malawi | ||||
1148999 | 1148999 | 2022-12-12 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-13 04:21:01 | Malawi | ||||
868853 | 868853 | 2022-12-11 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-12 04:21:01 | Malawi | ||||
257383 | 257383 | 2022-12-10 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-11 04:20:50 | Malawi | ||||
3936097 | 3936097 | 2022-12-09 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-10 04:21:02 | Malawi | ||||
3377429 | 3377429 | 2022-12-08 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-09 04:21:05 | Malawi | ||||
1984700 | 1984700 | 2022-12-07 | Malawi | 88220 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-08 04:21:07 | Malawi | ||||
3714223 | 3714223 | 2022-12-06 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-07 04:20:58 | Malawi | ||||
3713997 | 3713997 | 2022-12-06 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-12-07 04:20:58 | Cesar, Colombia | |||
2414928 | 2414928 | 2022-12-05 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-06 04:21:03 | Malawi | ||||
2414702 | 2414702 | 2022-12-05 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-12-06 04:21:03 | Cesar, Colombia | |||
718536 | 718536 | 2022-12-04 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-05 04:20:58 | Malawi | ||||
718310 | 718310 | 2022-12-04 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-12-05 04:20:58 | Cesar, Colombia | |||
2816825 | 2816825 | 2022-12-03 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-04 04:20:56 | Malawi | ||||
2816599 | 2816599 | 2022-12-03 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-12-04 04:20:56 | Cesar, Colombia | |||
833681 | 833681 | 2022-12-02 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-03 04:21:02 | Malawi | ||||
833455 | 833455 | 2022-12-02 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-12-03 04:21:02 | Cesar, Colombia | |||
2136211 | 2136211 | 2022-12-01 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-02 04:21:07 | Malawi | ||||
2135985 | 2135985 | 2022-12-01 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-12-02 04:21:07 | Cesar, Colombia | |||
1964627 | 1964627 | 2022-11-30 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-12-01 04:21:03 | Malawi | ||||
1964401 | 1964401 | 2022-11-30 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-12-01 04:21:03 | Cesar, Colombia | |||
2556641 | 2556641 | 2022-11-29 | Malawi | 88086 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-30 04:21:07 | Malawi | ||||
2556415 | 2556415 | 2022-11-29 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-30 04:21:07 | Cesar, Colombia | |||
1239715 | 1239715 | 2022-11-28 | Malawi | 88083 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-29 04:21:05 | Malawi | ||||
1239489 | 1239489 | 2022-11-28 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-29 04:21:05 | Cesar, Colombia | |||
3551703 | 3551703 | 2022-11-27 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-28 04:21:02 | Malawi | ||||
3551477 | 3551477 | 2022-11-27 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-28 04:21:02 | Cesar, Colombia | |||
2100183 | 2100183 | 2022-11-26 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-27 04:21:05 | Malawi | ||||
2099957 | 2099957 | 2022-11-26 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-27 04:21:05 | Cesar, Colombia | |||
487674 | 487674 | 2022-11-25 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-26 04:21:11 | Malawi | ||||
487448 | 487448 | 2022-11-25 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-26 04:21:11 | Cesar, Colombia | |||
3523503 | 3523503 | 2022-11-24 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-25 04:21:06 | Malawi | ||||
3523277 | 3523277 | 2022-11-24 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-25 04:21:06 | Cesar, Colombia | |||
3312286 | 3312286 | 2022-11-23 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-24 04:21:09 | Malawi | ||||
3312060 | 3312060 | 2022-11-23 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-24 04:21:09 | Cesar, Colombia | |||
1620327 | 1620327 | 2022-11-22 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-23 04:21:06 | Malawi | ||||
1620101 | 1620101 | 2022-11-22 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-23 04:21:06 | Cesar, Colombia | |||
3459989 | 3459989 | 2022-11-21 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-22 04:20:47 | Cesar, Colombia | |||
1640174 | 1640174 | 2022-11-20 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-21 04:21:05 | Cesar, Colombia | |||
2063731 | 2063731 | 2022-11-19 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-20 04:21:08 | Cesar, Colombia | |||
1755125 | 1755125 | 2022-11-18 | Colombia | Cesar | 108961 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-19 04:21:14 | Cesar, Colombia | |||
3026118 | 3026118 | 2022-11-17 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-18 04:21:15 | Cesar, Colombia | |||
2485829 | 2485829 | 2022-11-16 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-17 04:21:11 | Cesar, Colombia | |||
292066 | 292066 | 2022-11-15 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-16 04:21:09 | Malawi | ||||
291840 | 291840 | 2022-11-15 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-16 04:21:09 | Cesar, Colombia | |||
3597096 | 3597096 | 2022-11-14 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-15 04:21:16 | Malawi | ||||
3596870 | 3596870 | 2022-11-14 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-15 04:21:16 | Cesar, Colombia | |||
311954 | 311954 | 2022-11-13 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-14 04:21:09 | Malawi | ||||
311728 | 311728 | 2022-11-13 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-14 04:21:09 | Cesar, Colombia | |||
63115 | 63115 | 2022-11-12 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-13 04:21:14 | Malawi | ||||
62889 | 62889 | 2022-11-12 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-13 04:21:14 | Cesar, Colombia | |||
2927277 | 2927277 | 2022-11-11 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-12 04:20:41 | Malawi | ||||
2927051 | 2927051 | 2022-11-11 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-12 04:20:41 | Cesar, Colombia | |||
2506113 | 2506113 | 2022-11-10 | Malawi | 88073 | 2685 | 0 | -13.2543 | 34.3015 | 2022-11-11 04:21:22 | Malawi | ||||
2505887 | 2505887 | 2022-11-10 | Colombia | Cesar | 108940 | 2685 | 0 | 9.3373 | -73.6536 | 2022-11-11 04:21:22 | Cesar, Colombia | |||
198314 | 198314 | 2022-10-19 | Malaysia | Kedah | 310931 | 2685 | 0 | 6.1184 | 100.3685 | 2022-10-20 04:22:59 | Kedah, Malaysia | |||
2756975 | 2756975 | 2022-10-18 | Malaysia | Kedah | 310864 | 2685 | 0 | 6.1184 | 100.3685 | 2022-10-19 04:22:26 | Kedah, Malaysia | |||
2024809 | 2024809 | 2022-10-17 | Malaysia | Kedah | 310789 | 2685 | 0 | 6.1184 | 100.3685 | 2022-10-18 04:22:42 | Kedah, Malaysia | |||
2159587 | 2159587 | 2022-10-16 | Malaysia | Kedah | 310730 | 2685 | 0 | 6.1184 | 100.3685 | 2022-10-17 04:20:31 | Kedah, Malaysia | |||
2890864 | 2890864 | 2022-08-12 | US | Ohio | Franklin | 39049 | 328463 | 2685 | 0 | 39.96995815 | -83.01115755 | 2022-08-13 04:20:52 | Franklin, Ohio, US | |
1099728 | 1099728 | 2022-08-03 | US | Massachusetts | Worcester | 25027 | 215413 | 2685 | 0 | 42.35026951 | -71.90493363 | 2022-08-04 04:20:58 | Worcester, Massachusetts, US | |
1406653 | 1406653 | 2022-08-02 | US | Massachusetts | Worcester | 25027 | 215413 | 2685 | 0 | 42.35026951 | -71.90493363 | 2022-08-03 04:20:59 | Worcester, Massachusetts, US | |
3618691 | 3618691 | 2022-08-01 | US | Massachusetts | Worcester | 25027 | 215413 | 2685 | 0 | 42.35026951 | -71.90493363 | 2022-08-02 04:20:53 | Worcester, Massachusetts, US | |
3873171 | 3873171 | 2022-07-31 | US | Massachusetts | Worcester | 25027 | 215413 | 2685 | 0 | 42.35026951 | -71.90493363 | 2022-08-01 04:21:03 | Worcester, Massachusetts, US | |
675925 | 675925 | 2022-07-30 | US | Massachusetts | Worcester | 25027 | 215413 | 2685 | 0 | 42.35026951 | -71.90493363 | 2022-07-31 04:21:02 | Worcester, Massachusetts, US | |
1785124 | 1785124 | 2022-07-29 | US | Massachusetts | Worcester | 25027 | 215413 | 2685 | 0 | 42.35026951 | -71.90493363 | 2022-07-30 04:20:42 | Worcester, Massachusetts, US | |
1067487 | 1067487 | 2022-07-28 | US | Massachusetts | Worcester | 25027 | 215413 | 2685 | 0 | 42.35026951 | -71.90493363 | 2022-07-29 04:20:45 | Worcester, Massachusetts, US | |
670205 | 670205 | 2022-07-21 | Germany | Schleswig-Holstein | 914535 | 2685 | 0 | 54.2194 | 9.6961 | 2022-07-22 04:21:15 | Schleswig-Holstein, Germany | |||
3982688 | 3982688 | 2022-06-15 | Mexico | Baja California Sur | 107079 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-16 04:20:55 | Baja California Sur, Mexico | |||
946929 | 946929 | 2022-06-14 | Mexico | Baja California Sur | 106770 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-15 04:20:54 | Baja California Sur, Mexico | |||
2979337 | 2979337 | 2022-06-13 | Mexico | Baja California Sur | 106447 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-14 04:20:52 | Baja California Sur, Mexico | |||
2235463 | 2235463 | 2022-06-12 | Mexico | Baja California Sur | 106447 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-13 04:21:14 | Baja California Sur, Mexico | |||
3141661 | 3141661 | 2022-06-11 | Mexico | Baja California Sur | 106339 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-12 04:20:53 | Baja California Sur, Mexico | |||
1944577 | 1944577 | 2022-06-10 | Mexico | Baja California Sur | 106104 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-11 04:21:01 | Baja California Sur, Mexico | |||
3157716 | 3157716 | 2022-06-09 | Mexico | Baja California Sur | 105665 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-10 04:20:55 | Baja California Sur, Mexico | |||
1421183 | 1421183 | 2022-06-08 | Mexico | Baja California Sur | 105665 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-09 04:20:54 | Baja California Sur, Mexico | |||
3726297 | 3726297 | 2022-06-07 | Mexico | Baja California Sur | 105470 | 2685 | 0 | 26.0444 | -111.6661 | 2022-06-08 04:20:55 | Baja California Sur, Mexico | |||
3323687 | 3323687 | 2022-04-07 | US | Washington | King | 53033 | 378733 | 2685 | 0 | 47.49137892 | -121.8346131 | 2022-04-08 04:20:48 | King, Washington, US | |
2804223 | 2804223 | 2022-04-06 | US | Washington | King | 53033 | 378733 | 2685 | 0 | 47.49137892 | -121.8346131 | 2022-04-07 04:20:53 | King, Washington, US | |
3730500 | 3730500 | 2022-04-03 | Russia | Yaroslavl Oblast | 155244 | 2685 | 0 | 57.77819760000001 | 39.002109499999996 | 2022-04-04 04:20:51 | Yaroslavl Oblast, Russia | |||
499935 | 499935 | 2022-04-02 | Russia | Yaroslavl Oblast | 154991 | 2685 | 0 | 57.77819760000001 | 39.002109499999996 | 2022-04-03 04:20:48 | Yaroslavl Oblast, Russia | |||
3350920 | 3350920 | 2022-04-01 | Russia | Yaroslavl Oblast | 154734 | 2685 | 0 | 57.77819760000001 | 39.002109499999996 | 2022-04-02 04:20:47 | Yaroslavl Oblast, Russia | |||
2199754 | 2199754 | 2022-03-06 | Montenegro | 230958 | 2685 | 0 | 42.708678000000006 | 19.37439 | 2022-03-07 04:20:47 | Montenegro | ||||
2092211 | 2092211 | 2022-03-05 | Montenegro | 230887 | 2685 | 0 | 42.708678000000006 | 19.37439 | 2022-03-06 04:20:49 | Montenegro |
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]);