johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where deaths = 2193 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
431486 | 431486 | 2022-11-03 | Netherlands | Limburg | 559629 | 2193 | 0 | 51.209227 | 5.93387 | 2022-11-04 04:22:11 | Limburg, Netherlands | |||
849728 | 849728 | 2022-11-02 | Netherlands | Limburg | 559629 | 2193 | 0 | 51.209227 | 5.93387 | 2022-11-03 04:22:05 | Limburg, Netherlands | |||
710579 | 710579 | 2022-11-01 | Netherlands | Limburg | 559629 | 2193 | 0 | 51.209227 | 5.93387 | 2022-11-02 04:22:09 | Limburg, Netherlands | |||
320112 | 320112 | 2022-10-30 | Peru | Tacna | 60640 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-31 04:21:36 | Tacna, Peru | |||
912388 | 912388 | 2022-10-29 | Peru | Tacna | 60640 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-30 04:22:14 | Tacna, Peru | |||
1366657 | 1366657 | 2022-10-28 | Peru | Tacna | 60640 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-29 04:21:13 | Tacna, Peru | |||
3038512 | 3038512 | 2022-10-27 | Peru | Tacna | 60640 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-28 04:22:31 | Tacna, Peru | |||
538932 | 538932 | 2022-10-26 | Peru | Tacna | 60640 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-27 04:22:01 | Tacna, Peru | |||
1830333 | 1830333 | 2022-10-25 | Peru | Tacna | 60640 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-26 04:22:19 | Tacna, Peru | |||
794594 | 794594 | 2022-10-24 | Peru | Tacna | 60640 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-25 04:21:53 | Tacna, Peru | |||
3277049 | 3277049 | 2022-10-23 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-24 04:22:29 | Tacna, Peru | |||
2268087 | 2268087 | 2022-10-22 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-23 04:22:46 | Tacna, Peru | |||
1592387 | 1592387 | 2022-10-21 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-22 04:22:53 | Tacna, Peru | |||
2272103 | 2272103 | 2022-10-20 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-21 04:22:23 | Tacna, Peru | |||
198438 | 198438 | 2022-10-19 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-20 04:22:59 | Tacna, Peru | |||
2757099 | 2757099 | 2022-10-18 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-19 04:22:26 | Tacna, Peru | |||
2024933 | 2024933 | 2022-10-17 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-18 04:22:42 | Tacna, Peru | |||
2159711 | 2159711 | 2022-10-16 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-17 04:20:31 | Tacna, Peru | |||
515908 | 515908 | 2022-10-15 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-16 04:22:39 | Tacna, Peru | |||
2032965 | 2032965 | 2022-10-14 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-15 04:22:00 | Tacna, Peru | |||
3755063 | 3755063 | 2022-10-13 | US | Maryland | Montgomery | 24031 | 225025 | 2193 | 0 | 39.13676329 | -77.20358245 | 2022-10-14 04:22:28 | Montgomery, Maryland, US | |
3753653 | 3753653 | 2022-10-13 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-14 04:22:28 | Tacna, Peru | |||
3214478 | 3214478 | 2022-10-12 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-13 04:22:39 | Tacna, Peru | |||
3250327 | 3250327 | 2022-10-11 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-12 04:22:51 | Tacna, Peru | |||
2967586 | 2967586 | 2022-10-10 | Peru | Tacna | 60599 | 2193 | 0 | -17.644161 | -70.27756 | 2022-10-11 04:23:05 | Tacna, Peru | |||
231404 | 231404 | 2022-05-31 | US | New Jersey | Monmouth | 34025 | 178687 | 2193 | 0 | 40.26549699 | -74.22240686 | 2022-06-01 04:20:55 | Monmouth, New Jersey, US | |
3200318 | 3200318 | 2022-05-29 | US | New Jersey | Monmouth | 34025 | 177912 | 2193 | 0 | 40.26549699 | -74.22240686 | 2022-05-30 04:20:50 | Monmouth, New Jersey, US | |
2727196 | 2727196 | 2022-05-28 | US | New Jersey | Monmouth | 34025 | 177912 | 2193 | 0 | 40.26549699 | -74.22240686 | 2022-05-29 04:20:53 | Monmouth, New Jersey, US | |
1316377 | 1316377 | 2022-05-27 | US | New Jersey | Monmouth | 34025 | 177526 | 2193 | 0 | 40.26549699 | -74.22240686 | 2022-05-28 04:21:07 | Monmouth, New Jersey, US | |
1948706 | 1948706 | 2022-04-12 | Russia | Belgorod Oblast | 128149 | 2193 | 0 | 50.7080119 | 37.5837615 | 2022-04-13 04:21:03 | Belgorod Oblast, Russia | |||
3206351 | 3206351 | 2022-04-11 | Mexico | Colima | 54630 | 2193 | 0 | 19.1223 | -104.0072 | 2022-04-12 04:20:49 | Colima, Mexico | |||
1576237 | 1576237 | 2022-04-10 | Mexico | Colima | 54629 | 2193 | 0 | 19.1223 | -104.0072 | 2022-04-11 04:21:02 | Colima, Mexico | |||
1652479 | 1652479 | 2022-04-09 | Mexico | Colima | 54628 | 2193 | 0 | 19.1223 | -104.0072 | 2022-04-10 04:20:52 | Colima, Mexico | |||
1468404 | 1468404 | 2022-03-24 | Spain | Murcia | 386990 | 2193 | 0 | 37.9922 | -1.1307 | 2022-03-25 04:20:46 | Murcia, Spain | |||
3022578 | 3022578 | 2022-03-23 | Spain | Murcia | 386990 | 2193 | 0 | 37.9922 | -1.1307 | 2022-03-24 04:20:43 | Murcia, Spain | |||
1905500 | 1905500 | 2022-03-22 | Spain | Murcia | 386990 | 2193 | 0 | 37.9922 | -1.1307 | 2022-03-23 04:20:48 | Murcia, Spain | |||
2320139 | 2320139 | 2022-03-16 | US | Georgia | Fulton | 13121 | 213117 | 2193 | 0 | 33.79216944 | -84.46319413 | 2022-03-17 04:20:56 | Fulton, Georgia, US | |
2525481 | 2525481 | 2022-03-02 | Mozambique | 225080 | 2193 | 0 | -18.665695 | 35.529562 | 2022-03-03 04:21:01 | Mozambique | ||||
2642052 | 2642052 | 2022-02-14 | Spain | Extremadura | 227386 | 2193 | 0 | 39.4937 | -6.0679 | 2022-02-15 04:21:09 | Extremadura, Spain | |||
1464139 | 1464139 | 2022-02-10 | Malaysia | Kedah | 188039 | 2193 | 0 | 6.1184 | 100.3685 | 2022-02-11 04:21:09 | Kedah, Malaysia | |||
3655850 | 3655850 | 2021-12-10 | Russia | Tver Oblast | 92033 | 2193 | 0 | 57.1134475 | 35.174442799999994 | 2021-12-11 04:22:45 | Tver Oblast, Russia | |||
1322355 | 1322355 | 2021-11-14 | Netherlands | Gelderland | 262153 | 2193 | 0 | 52.061738 | 5.939114 | 2021-11-15 04:21:36 | Gelderland, Netherlands | |||
178263 | 178263 | 2021-09-02 | Russia | Penza Oblast | 63994 | 2193 | 0 | 53.1655415 | 44.78791810000001 | 2021-09-03 04:21:20 | Penza Oblast, Russia | |||
2947411 | 2947411 | 2021-07-16 | Kuwait | 383347 | 2193 | 363992 | 17162 | 29.31166 | 47.481766 | 2021-07-17 04:22:22 | Kuwait | |||
2071760 | 2071760 | 2021-07-02 | Colombia | Cesar | 80487 | 2193 | 76047 | 2247 | 9.3373 | -73.6536 | 2021-07-03 04:21:37 | Cesar, Colombia | ||
83751 | 83751 | 2021-05-25 | US | Connecticut | Fairfield | 9001 | 99903 | 2193 | 0 | 41.26809896 | -73.3881171 | 2021-05-26 04:20:35 | Fairfield, Connecticut, US | |
2259374 | 2259374 | 2021-05-19 | Ukraine | Zaporizhia Oblast | 100620 | 2193 | 90649 | 7778 | 47.8388 | 35.1396 | 2021-05-20 04:21:05 | Zaporizhia Oblast, Ukraine | ||
2939465 | 2939465 | 2021-05-16 | Oman | 205511 | 2193 | 190342 | 12976 | 21.512583 | 55.92325500000001 | 2021-05-17 04:20:34 | Oman | |||
2022887 | 2022887 | 2021-04-20 | US | New Jersey | Hudson | 34017 | 86072 | 2193 | 0 | 40.73766234 | -74.07515667 | 2021-04-21 04:21:14 | Hudson, New Jersey, US | |
2645827 | 2645827 | 2021-04-08 | Mexico | Aguascalientes | 25165 | 2193 | 0 | 22972 | 21.8853 | -102.2916 | 2021-04-09 04:21:13 | Aguascalientes, Mexico | ||
3643879 | 3643879 | 2021-03-30 | Sweden | Vastra Gotaland | 142501 | 2193 | 0 | 140308 | 58.2528 | 13.0596 | 2021-03-31 04:26:25 | Vastra Gotaland, Sweden | ||
1980325 | 1980325 | 2021-03-25 | Belarus | 314993 | 2193 | 305560 | 7240 | 53.7098 | 27.9534 | 2021-03-26 05:26:55 | Belarus | |||
3966183 | 3966183 | 2021-03-10 | West Bank and Gaza | 202378 | 2193 | 179810 | 20375 | 31.9522 | 35.2332 | 2021-03-11 05:25:48 | West Bank and Gaza | |||
471538 | 471538 | 2021-02-19 | Netherlands | Noord-Holland | 178163 | 2193 | 0 | 175759 | 52.60090600000001 | 4.918688 | 2021-02-20 05:22:51 | Noord-Holland, Netherlands | ||
1897064 | 1897064 | 2021-01-29 | Germany | Brandenburg | 67144 | 2193 | 54747 | 11152 | 52.4125 | 12.5316 | 2021-01-30 05:22:49 | Brandenburg, Germany | ||
862830 | 862830 | 2020-12-11 | US | New Jersey | Bergen | 34003 | 43183 | 2193 | 0 | 40990 | 40.96010917 | -74.07164325 | 2020-12-12 05:26:19 | Bergen, New Jersey, US |
3860054 | 3860054 | 2020-12-04 | Russia | Moscow Oblast | 115694 | 2193 | 82704 | 30797 | 55.50431579999999 | 38.0353929 | 2020-12-05 05:27:36 | Moscow Oblast, Russia | ||
2537091 | 2537091 | 2020-12-01 | Armenia | 135967 | 2193 | 110365 | 23409 | 40.0691 | 45.0382 | 2020-12-02 05:27:41 | Armenia | |||
678443 | 678443 | 2020-11-23 | Netherlands | Zuid-Holland | 140193 | 2193 | 0 | 137381 | 51.937835 | 4.462114 | 2020-11-24 05:27:31 | Zuid-Holland, Netherlands | ||
2498104 | 2498104 | 2020-11-03 | Mexico | Guerrero | 22319 | 2193 | 19779 | 347 | 17.4392 | -99.5451 | 2020-11-04 05:25:09 | Guerrero, Mexico | ||
2497935 | 2497935 | 2020-11-03 | Germany | Nordrhein-Westfalen | 144137 | 2193 | 92392 | 49552 | 51.4332 | 7.6616 | 2020-11-04 05:25:09 | Nordrhein-Westfalen, Germany | ||
2514169 | 2514169 | 2020-10-03 | Italy | Veneto | 28363 | 2193 | 22058 | 4112 | 45.43490485 | 12.33845213 | 2020-10-04 04:23:44 | Veneto, Italy | ||
1522938 | 1522938 | 2020-08-28 | Brazil | Santa Catarina | 141692 | 2193 | 129396 | 10103 | -27.2423 | -50.2189 | 2020-08-29 04:28:19 | Santa Catarina, Brazil | ||
2510326 | 2510326 | 2020-08-27 | Pakistan | Punjab | 96540 | 2193 | 92393 | 1954 | 30.811346 | 72.13913199999998 | 2020-08-28 04:28:11 | Punjab, Pakistan | ||
1996786 | 1996786 | 2020-08-26 | Pakistan | Punjab | 96466 | 2193 | 92301 | 1972 | 30.811346 | 72.13913199999998 | 2020-08-27 04:28:15 | Punjab, Pakistan | ||
175813 | 175813 | 2020-07-27 | US | New York | Nassau | 36059 | 43017 | 2193 | 0 | 40824 | 40.74066522 | -73.58941873 | 2020-07-28 04:58:43 | Nassau, New York, US |
441126 | 441126 | 2020-07-26 | US | New York | Nassau | 36059 | 42960 | 2193 | 0 | 40767 | 40.74066522 | -73.58941873 | 2020-07-27 04:35:02 | Nassau, New York, US |
1501370 | 1501370 | 2020-07-25 | US | New York | Nassau | 36059 | 42915 | 2193 | 0 | 40722 | 40.74066522 | -73.58941873 | 2020-07-26 04:35:00 | Nassau, New York, US |
2562340 | 2562340 | 2020-07-24 | US | New York | Nassau | 36059 | 42860 | 2193 | 0 | 40667 | 40.74066522 | -73.58941873 | 2020-07-25 04:47:39 | Nassau, New York, US |
60573 | 60573 | 2020-07-23 | US | New York | Nassau | 36059 | 42816 | 2193 | 0 | 40623 | 40.74066522 | -73.58941873 | 2020-07-24 05:30:40 | Nassau, New York, US |
843363 | 843363 | 2020-07-22 | US | New York | Nassau | 36059 | 42765 | 2193 | 0 | 40572 | 40.74066522 | -73.58941873 | 2020-07-23 05:15:04 | Nassau, New York, US |
1706102 | 1706102 | 2020-07-21 | US | New York | Nassau | 36059 | 42729 | 2193 | 0 | 40536 | 40.74066522 | -73.58941873 | 2020-07-22 04:34:42 | Nassau, New York, US |
325631 | 325631 | 2020-07-20 | US | New York | Nassau | 36059 | 42678 | 2193 | 0 | 40485 | 40.74066522 | -73.58941873 | 2020-07-21 04:38:46 | Nassau, New York, US |
120500 | 120500 | 2020-07-19 | US | New York | Nassau | 36059 | 42622 | 2193 | 0 | 40429 | 40.74066522 | -73.58941873 | 2020-07-20 05:34:40 | Nassau, New York, US |
3249662 | 3249662 | 2020-06-21 | Egypt | 55233 | 2193 | 14736 | 38304 | 26.820553000000004 | 30.802497999999996 | 2020-06-22 04:33:20 | Egypt |
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]);