johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
60 rows where deaths = 3741 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- Colombia 18
- Italy 9
- US 9
- India 4
- Netherlands 4
- Peru 4
- Ukraine 4
- Canada 3
- Germany 2
- El Salvador 1
- Russia 1
- Trinidad and Tobago 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3523412 | 3523412 | 2022-11-24 | Italy | Abruzzo | 600580 | 3741 | 0 | 42.35122196 | 13.39843823 | 2022-11-25 04:21:06 | Abruzzo, Italy | |||
3312195 | 3312195 | 2022-11-23 | Italy | Abruzzo | 600580 | 3741 | 0 | 42.35122196 | 13.39843823 | 2022-11-24 04:21:09 | Abruzzo, Italy | |||
1620236 | 1620236 | 2022-11-22 | Italy | Abruzzo | 600580 | 3741 | 0 | 42.35122196 | 13.39843823 | 2022-11-23 04:21:06 | Abruzzo, Italy | |||
3460124 | 3460124 | 2022-11-21 | Italy | Abruzzo | 600580 | 3741 | 0 | 42.35122196 | 13.39843823 | 2022-11-22 04:20:47 | Abruzzo, Italy | |||
1640309 | 1640309 | 2022-11-20 | Italy | Abruzzo | 600580 | 3741 | 0 | 42.35122196 | 13.39843823 | 2022-11-21 04:21:05 | Abruzzo, Italy | |||
2063866 | 2063866 | 2022-11-19 | Italy | Abruzzo | 600580 | 3741 | 0 | 42.35122196 | 13.39843823 | 2022-11-20 04:21:08 | Abruzzo, Italy | |||
1755260 | 1755260 | 2022-11-18 | Italy | Abruzzo | 600580 | 3741 | 0 | 42.35122196 | 13.39843823 | 2022-11-19 04:21:14 | Abruzzo, Italy | |||
2685826 | 2685826 | 2022-10-03 | Netherlands | Noord-Brabant | 1281228 | 3741 | 0 | 51.561174 | 5.184942 | 2022-10-04 04:22:55 | Noord-Brabant, Netherlands | |||
2259893 | 2259893 | 2022-10-02 | Netherlands | Noord-Brabant | 1281228 | 3741 | 0 | 51.561174 | 5.184942 | 2022-10-03 04:23:11 | Noord-Brabant, Netherlands | |||
2995419 | 2995419 | 2022-10-01 | Netherlands | Noord-Brabant | 1281228 | 3741 | 0 | 51.561174 | 5.184942 | 2022-10-02 04:21:23 | Noord-Brabant, Netherlands | |||
853745 | 853745 | 2022-09-30 | Netherlands | Noord-Brabant | 1281228 | 3741 | 0 | 51.561174 | 5.184942 | 2022-10-01 04:23:01 | Noord-Brabant, Netherlands | |||
949931 | 949931 | 2022-06-14 | US | Texas | El Paso | 48141 | 213395 | 3741 | 0 | 31.76980765 | -106.2363275 | 2022-06-15 04:20:54 | El Paso, Texas, US | |
2982339 | 2982339 | 2022-06-13 | US | Texas | El Paso | 48141 | 213194 | 3741 | 0 | 31.76980765 | -106.2363275 | 2022-06-14 04:20:52 | El Paso, Texas, US | |
2238465 | 2238465 | 2022-06-12 | US | Texas | El Paso | 48141 | 212762 | 3741 | 0 | 31.76980765 | -106.2363275 | 2022-06-13 04:21:14 | El Paso, Texas, US | |
3144663 | 3144663 | 2022-06-11 | US | Texas | El Paso | 48141 | 212574 | 3741 | 0 | 31.76980765 | -106.2363275 | 2022-06-12 04:20:53 | El Paso, Texas, US | |
1947579 | 1947579 | 2022-06-10 | US | Texas | El Paso | 48141 | 212295 | 3741 | 0 | 31.76980765 | -106.2363275 | 2022-06-11 04:21:01 | El Paso, Texas, US | |
3160718 | 3160718 | 2022-06-09 | US | Texas | El Paso | 48141 | 212231 | 3741 | 0 | 31.76980765 | -106.2363275 | 2022-06-10 04:20:55 | El Paso, Texas, US | |
1424185 | 1424185 | 2022-06-08 | US | Texas | El Paso | 48141 | 212035 | 3741 | 0 | 31.76980765 | -106.2363275 | 2022-06-09 04:20:54 | El Paso, Texas, US | |
2251689 | 2251689 | 2022-04-19 | Russia | Vologda Oblast | 188027 | 3741 | 0 | 60.0391461 | 43.1215213 | 2022-04-20 04:20:45 | Vologda Oblast, Russia | |||
2800748 | 2800748 | 2022-04-06 | Italy | Marche | 402592 | 3741 | 0 | 43.61675973 | 13.5188753 | 2022-04-07 04:20:53 | Marche, Italy | |||
158354 | 158354 | 2022-03-29 | Trinidad and Tobago | 137496 | 3741 | 0 | 10.6918 | -61.2225 | 2022-03-30 04:20:45 | Trinidad and Tobago | ||||
1301171 | 1301171 | 2022-02-17 | US | Texas | Hidalgo | 48215 | 188507 | 3741 | 0 | 26.39418217 | -98.18299696 | 2022-02-18 04:21:04 | Hidalgo, Texas, US | |
185818 | 185818 | 2022-02-13 | Canada | Alberta | 514165 | 3741 | 0 | 53.9333 | -116.5765 | 2022-02-14 04:20:51 | Alberta, Canada | |||
315664 | 315664 | 2022-02-12 | Canada | Alberta | 514165 | 3741 | 0 | 53.9333 | -116.5765 | 2022-02-13 04:21:00 | Alberta, Canada | |||
232990 | 232990 | 2022-02-11 | Canada | Alberta | 514165 | 3741 | 0 | 53.9333 | -116.5765 | 2022-02-12 04:21:06 | Alberta, Canada | |||
2329613 | 2329613 | 2022-02-04 | US | New York | Nassau | 36059 | 393177 | 3741 | 0 | 40.74066522 | -73.58941873 | 2022-02-05 04:21:05 | Nassau, New York, US | |
3523074 | 3523074 | 2022-01-02 | Ukraine | Poltava Oblast | 140484 | 3741 | 0 | 49.5883 | 34.5514 | 2022-01-03 02:22:25 | Poltava Oblast, Ukraine | |||
1258618 | 1258618 | 2021-12-18 | Colombia | Cordoba | 104715 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-19 04:21:11 | Cordoba, Colombia | |||
2398646 | 2398646 | 2021-12-17 | Colombia | Cordoba | 104710 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-18 02:22:20 | Cordoba, Colombia | |||
1716184 | 1716184 | 2021-12-16 | Colombia | Cordoba | 104699 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-17 04:22:14 | Cordoba, Colombia | |||
3496018 | 3496018 | 2021-12-15 | Colombia | Cordoba | 104694 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-16 04:22:11 | Cordoba, Colombia | |||
2087803 | 2087803 | 2021-12-14 | Colombia | Cordoba | 104683 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-15 03:22:16 | Cordoba, Colombia | |||
782220 | 782220 | 2021-12-13 | Colombia | Cordoba | 104676 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-14 04:22:38 | Cordoba, Colombia | |||
1660255 | 1660255 | 2021-12-12 | Colombia | Cordoba | 104670 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-13 04:22:02 | Cordoba, Colombia | |||
1664271 | 1664271 | 2021-12-11 | Colombia | Cordoba | 104661 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-12 04:22:12 | Cordoba, Colombia | |||
3655423 | 3655423 | 2021-12-10 | Colombia | Cordoba | 104656 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-11 04:22:45 | Cordoba, Colombia | |||
1077754 | 1077754 | 2021-12-09 | Colombia | Cordoba | 104654 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-10 04:22:28 | Cordoba, Colombia | |||
550603 | 550603 | 2021-12-08 | Colombia | Cordoba | 104649 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-09 04:22:49 | Cordoba, Colombia | |||
404123 | 404123 | 2021-12-07 | Colombia | Cordoba | 104636 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-08 04:22:46 | Cordoba, Colombia | |||
1030205 | 1030205 | 2021-12-06 | Colombia | Cordoba | 104636 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-07 04:22:34 | Cordoba, Colombia | |||
1740368 | 1740368 | 2021-12-05 | Colombia | Cordoba | 104627 | 3741 | 0 | 8.0493 | -75.574 | 2021-12-06 04:22:34 | Cordoba, Colombia | |||
1358166 | 1358166 | 2021-11-27 | Colombia | Cordoba | 104560 | 3741 | 0 | 8.0493 | -75.574 | 2021-11-28 04:22:43 | Cordoba, Colombia | |||
758157 | 758157 | 2021-11-26 | Colombia | Cordoba | 104538 | 3741 | 0 | 8.0493 | -75.574 | 2021-11-27 04:22:45 | Cordoba, Colombia | |||
1802574 | 1802574 | 2021-11-25 | Colombia | Cordoba | 104528 | 3741 | 0 | 8.0493 | -75.574 | 2021-11-26 04:22:33 | Cordoba, Colombia | |||
904008 | 904008 | 2021-11-24 | Colombia | Cordoba | 104499 | 3741 | 0 | 8.0493 | -75.574 | 2021-11-25 04:22:33 | Cordoba, Colombia | |||
3288783 | 3288783 | 2021-11-18 | El Salvador | 118041 | 3741 | 0 | 13.7942 | -88.8965 | 2021-11-19 04:21:40 | El Salvador | ||||
2291092 | 2291092 | 2021-11-15 | Ukraine | Kiev Oblast | 162794 | 3741 | 0 | 50.053000000000004 | 30.7667 | 2021-11-16 04:21:10 | Kiev Oblast, Ukraine | |||
534668 | 534668 | 2021-10-27 | India | Himachal Pradesh | 223406 | 3741 | 0 | 31.927213000000002 | 77.233081 | 2021-10-28 04:22:08 | Himachal Pradesh, India | |||
3809530 | 3809530 | 2021-09-11 | Ukraine | Kharkiv Oblast | 154467 | 3741 | 0 | 49.9935 | 36.2304 | 2021-09-12 04:21:13 | Kharkiv Oblast, Ukraine | |||
3452477 | 3452477 | 2021-09-10 | Ukraine | Lviv Oblast | 141482 | 3741 | 0 | 49.8397 | 24.0297 | 2021-09-11 04:21:30 | Lviv Oblast, Ukraine | |||
825739 | 825739 | 2021-06-06 | Peru | Cajamarca | 58938 | 3741 | 0 | 55197 | -6.430284 | -78.74559599999998 | 2021-06-07 04:22:51 | Cajamarca, Peru | ||
2586144 | 2586144 | 2021-06-05 | Peru | Cajamarca | 58938 | 3741 | 0 | 55197 | -6.430284 | -78.74559599999998 | 2021-06-06 04:24:03 | Cajamarca, Peru | ||
2315458 | 2315458 | 2021-06-04 | Peru | Cajamarca | 58938 | 3741 | 0 | 55197 | -6.430284 | -78.74559599999998 | 2021-06-05 04:23:03 | Cajamarca, Peru | ||
1448743 | 1448743 | 2021-06-03 | Peru | Cajamarca | 58938 | 3741 | 0 | 55197 | -6.430284 | -78.74559599999998 | 2021-06-04 04:23:37 | Cajamarca, Peru | ||
1425086 | 1425086 | 2021-05-09 | Italy | Friuli Venezia Giulia | 106085 | 3741 | 95953 | 6391 | 45.6494354 | 13.76813649 | 2021-05-10 04:20:38 | Friuli Venezia Giulia, Italy | ||
888042 | 888042 | 2021-04-26 | Germany | Thuringen | 112882 | 3741 | 100300 | 9275 | 51.011 | 10.8453 | 2021-04-27 04:20:52 | Thuringen, Germany | ||
954787 | 954787 | 2021-04-25 | Germany | Thuringen | 112543 | 3741 | 99460 | 9681 | 51.011 | 10.8453 | 2021-04-26 04:21:04 | Thuringen, Germany | ||
1672399 | 1672399 | 2021-02-07 | India | Chhattisgarh | 307525 | 3741 | 299494 | 4290 | 21.264705 | 82.035366 | 2021-02-08 05:22:39 | Chhattisgarh, India | ||
2689645 | 2689645 | 2020-10-08 | India | Punjab | 121716 | 3741 | 107200 | 10775 | 30.841465000000003 | 75.40879 | 2020-10-09 04:23:59 | Punjab, India | ||
2958754 | 2958754 | 2020-07-29 | India | Tamil Nadu | 234114 | 3741 | 172883 | 57490 | 11.006091 | 78.400624 | 2020-07-30 04:35:05 | Tamil Nadu, India |
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]);