johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where deaths = 2295 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2558178 | 2558178 | 2022-11-29 | US | Maryland | Prince George's | 24033 | 215228 | 2295 | 0 | 38.83070039 | -76.8496441 | 2022-11-30 04:21:07 | Prince George's, Maryland, US | |
2440921 | 2440921 | 2022-11-07 | US | New Jersey | Monmouth | 34025 | 206676 | 2295 | 0 | 40.26549699 | -74.22240686 | 2022-11-08 04:21:21 | Monmouth, New Jersey, US | |
1052019 | 1052019 | 2022-11-06 | US | New Jersey | Monmouth | 34025 | 206621 | 2295 | 0 | 40.26549699 | -74.22240686 | 2022-11-07 04:21:26 | Monmouth, New Jersey, US | |
540354 | 540354 | 2022-10-26 | US | Massachusetts | Bristol | 25005 | 172303 | 2295 | 0 | 41.79228404 | -71.10872211 | 2022-10-27 04:22:01 | Bristol, Massachusetts, US | |
1831755 | 1831755 | 2022-10-25 | US | Massachusetts | Bristol | 25005 | 172303 | 2295 | 0 | 41.79228404 | -71.10872211 | 2022-10-26 04:22:19 | Bristol, Massachusetts, US | |
796016 | 796016 | 2022-10-24 | US | Massachusetts | Bristol | 25005 | 172303 | 2295 | 0 | 41.79228404 | -71.10872211 | 2022-10-25 04:21:53 | Bristol, Massachusetts, US | |
3278471 | 3278471 | 2022-10-23 | US | Massachusetts | Bristol | 25005 | 172303 | 2295 | 0 | 41.79228404 | -71.10872211 | 2022-10-24 04:22:29 | Bristol, Massachusetts, US | |
2269509 | 2269509 | 2022-10-22 | US | Massachusetts | Bristol | 25005 | 172303 | 2295 | 0 | 41.79228404 | -71.10872211 | 2022-10-23 04:22:46 | Bristol, Massachusetts, US | |
1593809 | 1593809 | 2022-10-21 | US | Massachusetts | Bristol | 25005 | 172303 | 2295 | 0 | 41.79228404 | -71.10872211 | 2022-10-22 04:22:53 | Bristol, Massachusetts, US | |
2273525 | 2273525 | 2022-10-20 | US | Massachusetts | Bristol | 25005 | 172303 | 2295 | 0 | 41.79228404 | -71.10872211 | 2022-10-21 04:22:23 | Bristol, Massachusetts, US | |
2159727 | 2159727 | 2022-10-16 | Russia | Belgorod Oblast | 160324 | 2295 | 0 | 50.7080119 | 37.5837615 | 2022-10-17 04:20:31 | Belgorod Oblast, Russia | |||
515924 | 515924 | 2022-10-15 | Russia | Belgorod Oblast | 160152 | 2295 | 0 | 50.7080119 | 37.5837615 | 2022-10-16 04:22:39 | Belgorod Oblast, Russia | |||
3416897 | 3416897 | 2022-04-17 | Italy | Sardegna | 258049 | 2295 | 0 | 39.21531192 | 9.110616306 | 2022-04-18 04:21:12 | Sardegna, Italy | |||
1223371 | 1223371 | 2022-04-14 | Chile | Los Lagos | 193912 | 2295 | 0 | -41.9198 | -72.1416 | 2022-04-15 04:20:57 | Los Lagos, Chile | |||
1113412 | 1113412 | 2022-01-11 | Colombia | Caldas | 105752 | 2295 | 0 | 5.2983 | -75.2479 | 2022-01-12 04:21:44 | Caldas, Colombia | |||
1692140 | 1692140 | 2022-01-10 | Colombia | Caldas | 104405 | 2295 | 0 | 5.2983 | -75.2479 | 2022-01-11 04:22:01 | Caldas, Colombia | |||
128967 | 128967 | 2022-01-09 | US | New York | Erie | 36029 | 171021 | 2295 | 0 | 42.76249024 | -78.73063652 | 2022-01-10 04:22:07 | Erie, New York, US | |
126555 | 126555 | 2022-01-09 | Colombia | Caldas | 104405 | 2295 | 0 | 5.2983 | -75.2479 | 2022-01-10 04:22:07 | Caldas, Colombia | |||
1215390 | 1215390 | 2022-01-08 | Colombia | Caldas | 103885 | 2295 | 0 | 5.2983 | -75.2479 | 2022-01-09 04:21:46 | Caldas, Colombia | |||
1389483 | 1389483 | 2022-01-07 | Colombia | Caldas | 103252 | 2295 | 0 | 5.2983 | -75.2479 | 2022-01-08 04:21:53 | Caldas, Colombia | |||
2609870 | 2609870 | 2022-01-06 | Colombia | Caldas | 102827 | 2295 | 0 | 5.2983 | -75.2479 | 2022-01-07 04:22:09 | Caldas, Colombia | |||
798510 | 798510 | 2021-12-22 | Mexico | Chiapas | 23591 | 2295 | 0 | 16.7569 | -93.1292 | 2021-12-23 04:21:21 | Chiapas, Mexico | |||
2398897 | 2398897 | 2021-12-17 | Mexico | Chiapas | 23584 | 2295 | 0 | 16.7569 | -93.1292 | 2021-12-18 02:22:20 | Chiapas, Mexico | |||
1716435 | 1716435 | 2021-12-16 | Mexico | Chiapas | 23584 | 2295 | 0 | 16.7569 | -93.1292 | 2021-12-17 04:22:14 | Chiapas, Mexico | |||
3401657 | 3401657 | 2021-11-30 | Russia | Komi Republic | 89984 | 2295 | 0 | 63.9881421 | 54.3326073 | 2021-12-01 04:22:29 | Komi Republic, Russia | |||
597726 | 597726 | 2021-10-19 | Malawi | 61732 | 2295 | 0 | -13.2543 | 34.3015 | 2021-10-20 04:21:00 | Malawi | ||||
2518231 | 2518231 | 2021-08-18 | Kosovo | 120862 | 2295 | 0 | 42.602636 | 20.902977 | 2021-08-19 04:21:15 | Kosovo | ||||
1308432 | 1308432 | 2021-07-27 | US | New York | Westchester | 36119 | 130968 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-28 04:21:39 | Westchester, New York, US | |
3220575 | 3220575 | 2021-07-26 | US | New York | Westchester | 36119 | 130894 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-27 04:21:18 | Westchester, New York, US | |
1380784 | 1380784 | 2021-07-25 | US | New York | Westchester | 36119 | 130752 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-26 04:21:28 | Westchester, New York, US | |
1332524 | 1332524 | 2021-07-24 | US | New York | Westchester | 36119 | 130752 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-25 04:22:12 | Westchester, New York, US | |
3139828 | 3139828 | 2021-07-23 | US | New York | Westchester | 36119 | 130667 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-24 00:21:36 | Westchester, New York, US | |
3478588 | 3478588 | 2021-07-22 | US | New York | Westchester | 36119 | 130591 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-23 04:21:29 | Westchester, New York, US | |
3333807 | 3333807 | 2021-07-21 | US | New York | Westchester | 36119 | 130528 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-22 04:21:19 | Westchester, New York, US | |
2373788 | 2373788 | 2021-07-20 | US | New York | Westchester | 36119 | 130472 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-21 04:21:40 | Westchester, New York, US | |
485867 | 485867 | 2021-07-19 | US | New York | Westchester | 36119 | 130421 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-20 04:21:48 | Westchester, New York, US | |
2676090 | 2676090 | 2021-07-18 | US | New York | Westchester | 36119 | 130387 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-19 04:21:24 | Westchester, New York, US | |
3708402 | 3708402 | 2021-07-17 | US | New York | Westchester | 36119 | 130332 | 2295 | 0 | 41.16278376 | -73.75741653 | 2021-07-18 04:22:07 | Westchester, New York, US | |
3125270 | 3125270 | 2021-06-28 | Canada | Alberta | 231850 | 2295 | 228294 | 1261 | 53.9333 | -116.5765 | 2021-06-29 04:21:28 | Alberta, Canada | ||
2341561 | 2341561 | 2021-06-15 | US | New Jersey | Hudson | 34017 | 88230 | 2295 | 0 | 40.73766234 | -74.07515667 | 2021-06-16 04:22:32 | Hudson, New Jersey, US | |
3381259 | 3381259 | 2021-06-13 | El Salvador | 75351 | 2295 | 70150 | 2906 | 13.7942 | -88.8965 | 2021-06-14 04:22:46 | El Salvador | |||
3675978 | 3675978 | 2021-05-04 | Sweden | Vastra Gotaland | 173174 | 2295 | 0 | 170879 | 58.2528 | 13.0596 | 2021-05-05 04:20:43 | Vastra Gotaland, Sweden | ||
1568277 | 1568277 | 2021-04-22 | Peru | San Martin | 38668 | 2295 | 0 | 36373 | -7.039531 | -76.729127 | 2021-04-23 04:20:52 | San Martin, Peru | ||
2021767 | 2021767 | 2021-04-20 | US | Illinois | Unassigned | 90017 | 97 | 2295 | 0 | 42.36542373 | 0.0 | 2021-04-21 04:21:14 | Unassigned, Illinois, US | |
1842989 | 1842989 | 2021-04-14 | US | Illinois | Unassigned | 90017 | 90 | 2295 | 0 | 42.36542373 | 0.0 | 2021-04-15 04:20:54 | Unassigned, Illinois, US | |
2247478 | 2247478 | 2021-04-07 | Mexico | Durango | 32537 | 2295 | 0 | 30242 | 24.5593 | -104.6588 | 2021-04-08 04:21:13 | Durango, Mexico | ||
3663778 | 3663778 | 2021-03-09 | Peru | Puno | 24440 | 2295 | 0 | 22145 | -14.995826999999998 | -69.922726 | 2021-03-10 05:24:35 | Puno, Peru | ||
2359593 | 2359593 | 2021-03-08 | Netherlands | Noord-Holland | 194413 | 2295 | 0 | 191894 | 52.60090600000001 | 4.918688 | 2021-03-09 05:28:19 | Noord-Holland, Netherlands | ||
2207641 | 2207641 | 2021-03-04 | Italy | Marche | 70396 | 2295 | 57931 | 10170 | 43.61675973 | 13.5188753 | 2021-03-05 05:26:29 | Marche, Italy | ||
745384 | 745384 | 2021-02-20 | US | Texas | El Paso | 48141 | 100701 | 2295 | 0 | 118687 | 31.76980765 | -106.2363275 | 2021-02-21 05:24:33 | El Paso, Texas, US |
1527993 | 1527993 | 2021-02-09 | Mexico | Quintana Roo | 19332 | 2295 | 0 | 17037 | 19.1817 | -88.4791 | 2021-02-10 05:22:41 | Quintana Roo, Mexico | ||
1684410 | 1684410 | 2021-02-02 | Germany | Berlin | 120397 | 2295 | 108540 | 9882 | 52.52 | 13.405 | 2021-02-03 05:22:52 | Berlin, Germany | ||
1897369 | 1897369 | 2021-01-29 | Russia | Krasnoyarsk Krai | 55815 | 2295 | 51402 | 2118 | 63.3233807 | 97.0979974 | 2021-01-30 05:22:49 | Krasnoyarsk Krai, Russia | ||
3849946 | 3849946 | 2020-12-13 | US | New Jersey | Essex | 34013 | 44179 | 2295 | 0 | 41884 | 40.78681335 | -74.24657979 | 2020-12-14 05:26:27 | Essex, New Jersey, US |
2879937 | 2879937 | 2020-11-15 | Brazil | Alagoas | 92596 | 2295 | 89139 | 1162 | -9.5713 | -36.782 | 2020-11-16 05:25:57 | Alagoas, Brazil | ||
762062 | 762062 | 2020-10-18 | Brazil | Piaui | 106394 | 2295 | 99255 | 4305 | -7.7183 | -42.7289 | 2020-10-19 04:24:16 | Piaui, Brazil | ||
3923395 | 3923395 | 2020-08-09 | Mexico | Sonora | 19040 | 2295 | 15758 | 987 | 29.2972 | -110.3309 | 2020-08-10 04:34:55 | Sonora, Mexico | ||
61777 | 61777 | 2020-07-23 | Colombia | Atlantico | 46595 | 2295 | 28788 | 15512 | 10.6966 | -74.8741 | 2020-07-24 05:30:40 | Atlantico, Colombia |
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]);