johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
131 rows where deaths = 2158 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- Brazil 35
- Yemen 30
- US 25
- Peru 11
- Russia 5
- Italy 4
- Colombia 2
- Ireland 2
- Japan 2
- Mexico 2
- Afghanistan 1
- Canada 1
- El Salvador 1
- Estonia 1
- Ethiopia 1
- Germany 1
- Kuwait 1
- Malaysia 1
- Netherlands 1
- Syria 1
- Trinidad and Tobago 1
- Ukraine 1
- United Arab Emirates 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1630496 | 1630496 | 2022-12-18 | US | New Mexico | Bernalillo | 35001 | 192884 | 2158 | 0 | 35.05163625 | -106.6703554 | 2022-12-19 04:21:03 | Bernalillo, New Mexico, US | |
505875 | 505875 | 2022-12-17 | US | New Mexico | Bernalillo | 35001 | 192884 | 2158 | 0 | 35.05163625 | -106.6703554 | 2022-12-18 04:21:03 | Bernalillo, New Mexico, US | |
3326447 | 3326447 | 2022-12-16 | US | New Mexico | Bernalillo | 35001 | 192884 | 2158 | 0 | 35.05163625 | -106.6703554 | 2022-12-17 04:21:04 | Bernalillo, New Mexico, US | |
1987147 | 1987147 | 2022-12-07 | US | Ohio | Montgomery | 39113 | 153889 | 2158 | 0 | 39.75394919 | -84.29050975 | 2022-12-08 04:21:07 | Montgomery, Ohio, US | |
435041 | 435041 | 2022-11-03 | Yemen | 11944 | 2158 | 0 | 15.552727 | 48.516388 | 2022-11-04 04:22:11 | Yemen | ||||
853283 | 853283 | 2022-11-02 | Yemen | 11944 | 2158 | 0 | 15.552727 | 48.516388 | 2022-11-03 04:22:05 | Yemen | ||||
714134 | 714134 | 2022-11-01 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-11-02 04:22:09 | Yemen | ||||
3288583 | 3288583 | 2022-10-31 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-11-01 04:22:36 | Yemen | ||||
323616 | 323616 | 2022-10-30 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-31 04:21:36 | Yemen | ||||
915892 | 915892 | 2022-10-29 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-30 04:22:14 | Yemen | ||||
1370161 | 1370161 | 2022-10-28 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-29 04:21:13 | Yemen | ||||
3042016 | 3042016 | 2022-10-27 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-28 04:22:31 | Yemen | ||||
542436 | 542436 | 2022-10-26 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-27 04:22:01 | Yemen | ||||
1833837 | 1833837 | 2022-10-25 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-26 04:22:19 | Yemen | ||||
798098 | 798098 | 2022-10-24 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-25 04:21:53 | Yemen | ||||
3280553 | 3280553 | 2022-10-23 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-24 04:22:29 | Yemen | ||||
2271591 | 2271591 | 2022-10-22 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-23 04:22:46 | Yemen | ||||
1595891 | 1595891 | 2022-10-21 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-22 04:22:53 | Yemen | ||||
2275607 | 2275607 | 2022-10-20 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-21 04:22:23 | Yemen | ||||
201942 | 201942 | 2022-10-19 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-20 04:22:59 | Yemen | ||||
2760603 | 2760603 | 2022-10-18 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-19 04:22:26 | Yemen | ||||
2756900 | 2756900 | 2022-10-18 | Italy | Umbria | 393235 | 2158 | 0 | 43.10675841 | 12.38824698 | 2022-10-19 04:22:26 | Umbria, Italy | |||
2028437 | 2028437 | 2022-10-17 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-18 04:22:42 | Yemen | ||||
2163215 | 2163215 | 2022-10-16 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-17 04:20:31 | Yemen | ||||
519412 | 519412 | 2022-10-15 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-16 04:22:39 | Yemen | ||||
2036469 | 2036469 | 2022-10-14 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-15 04:22:00 | Yemen | ||||
3757157 | 3757157 | 2022-10-13 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-14 04:22:28 | Yemen | ||||
3217982 | 3217982 | 2022-10-12 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-13 04:22:39 | Yemen | ||||
3253831 | 3253831 | 2022-10-11 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-12 04:22:51 | Yemen | ||||
2971090 | 2971090 | 2022-10-10 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-11 04:23:05 | Yemen | ||||
3101126 | 3101126 | 2022-10-09 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-10 04:22:32 | Yemen | ||||
4006351 | 4006351 | 2022-10-08 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-09 04:21:16 | Yemen | ||||
399948 | 399948 | 2022-10-07 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-08 04:22:56 | Yemen | ||||
2533065 | 2533065 | 2022-10-06 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-07 04:23:08 | Yemen | ||||
1814459 | 1814459 | 2022-10-05 | Yemen | 11939 | 2158 | 0 | 15.552727 | 48.516388 | 2022-10-06 04:21:22 | Yemen | ||||
133224 | 133224 | 2022-10-04 | US | Ohio | Hamilton | 39061 | 220948 | 2158 | 0 | 39.19673558 | -84.54502924 | 2022-10-05 04:23:06 | Hamilton, Ohio, US | |
253028 | 253028 | 2022-09-08 | Brazil | Amapa | 178115 | 2158 | 0 | 0.902 | -52.003 | 2022-09-09 04:21:11 | Amapa, Brazil | |||
3744826 | 3744826 | 2022-09-07 | Brazil | Amapa | 178115 | 2158 | 0 | 0.902 | -52.003 | 2022-09-08 04:21:02 | Amapa, Brazil | |||
114466 | 114466 | 2022-09-06 | Brazil | Amapa | 178115 | 2158 | 0 | 0.902 | -52.003 | 2022-09-07 04:20:59 | Amapa, Brazil | |||
2633438 | 2633438 | 2022-09-05 | Brazil | Amapa | 178115 | 2158 | 0 | 0.902 | -52.003 | 2022-09-06 04:21:02 | Amapa, Brazil | |||
2987002 | 2987002 | 2022-09-04 | Brazil | Amapa | 178106 | 2158 | 0 | 0.902 | -52.003 | 2022-09-05 04:21:01 | Amapa, Brazil | |||
2712687 | 2712687 | 2022-09-03 | Brazil | Amapa | 178106 | 2158 | 0 | 0.902 | -52.003 | 2022-09-04 04:21:22 | Amapa, Brazil | |||
1393392 | 1393392 | 2022-09-02 | Brazil | Amapa | 178106 | 2158 | 0 | 0.902 | -52.003 | 2022-09-03 04:21:04 | Amapa, Brazil | |||
3547221 | 3547221 | 2022-09-01 | Brazil | Amapa | 178081 | 2158 | 0 | 0.902 | -52.003 | 2022-09-02 04:21:07 | Amapa, Brazil | |||
2343141 | 2343141 | 2022-08-31 | Brazil | Amapa | 178081 | 2158 | 0 | 0.902 | -52.003 | 2022-09-01 04:21:03 | Amapa, Brazil | |||
3773621 | 3773621 | 2022-08-30 | Brazil | Amapa | 178071 | 2158 | 0 | 0.902 | -52.003 | 2022-08-31 04:20:57 | Amapa, Brazil | |||
1680217 | 1680217 | 2022-08-29 | Brazil | Amapa | 178064 | 2158 | 0 | 0.902 | -52.003 | 2022-08-30 04:21:03 | Amapa, Brazil | |||
1876701 | 1876701 | 2022-08-28 | Brazil | Amapa | 178046 | 2158 | 0 | 0.902 | -52.003 | 2022-08-29 04:21:06 | Amapa, Brazil | |||
2095828 | 2095828 | 2022-08-27 | Brazil | Amapa | 178046 | 2158 | 0 | 0.902 | -52.003 | 2022-08-28 04:21:02 | Amapa, Brazil | |||
1531643 | 1531643 | 2022-08-26 | Brazil | Amapa | 178046 | 2158 | 0 | 0.902 | -52.003 | 2022-08-27 04:20:57 | Amapa, Brazil | |||
2828530 | 2828530 | 2022-08-25 | Brazil | Amapa | 178037 | 2158 | 0 | 0.902 | -52.003 | 2022-08-26 04:21:02 | Amapa, Brazil | |||
2323063 | 2323063 | 2022-08-24 | Brazil | Amapa | 178006 | 2158 | 0 | 0.902 | -52.003 | 2022-08-25 04:21:13 | Amapa, Brazil | |||
1069628 | 1069628 | 2022-08-07 | Brazil | Roraima | 173401 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-08 04:21:08 | Roraima, Brazil | |||
1940216 | 1940216 | 2022-08-06 | Brazil | Roraima | 173401 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-07 04:20:54 | Roraima, Brazil | |||
880015 | 880015 | 2022-08-05 | Brazil | Roraima | 173401 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-06 04:20:56 | Roraima, Brazil | |||
2008426 | 2008426 | 2022-08-04 | Brazil | Roraima | 173286 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-05 04:20:52 | Roraima, Brazil | |||
1097853 | 1097853 | 2022-08-03 | Brazil | Roraima | 173067 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-04 04:20:58 | Roraima, Brazil | |||
1404778 | 1404778 | 2022-08-02 | Brazil | Roraima | 172904 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-03 04:20:59 | Roraima, Brazil | |||
3616816 | 3616816 | 2022-08-01 | Brazil | Roraima | 172824 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-02 04:20:53 | Roraima, Brazil | |||
3871296 | 3871296 | 2022-07-31 | Brazil | Roraima | 172615 | 2158 | 0 | -2.7376 | -62.0751 | 2022-08-01 04:21:03 | Roraima, Brazil | |||
674050 | 674050 | 2022-07-30 | Brazil | Roraima | 172615 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-31 04:21:02 | Roraima, Brazil | |||
1783249 | 1783249 | 2022-07-29 | Brazil | Roraima | 172615 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-30 04:20:42 | Roraima, Brazil | |||
1065612 | 1065612 | 2022-07-28 | Brazil | Roraima | 172358 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-29 04:20:45 | Roraima, Brazil | |||
2335131 | 2335131 | 2022-07-27 | Brazil | Roraima | 172080 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-28 04:20:56 | Roraima, Brazil | |||
1487321 | 1487321 | 2022-07-26 | Brazil | Roraima | 171871 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-27 04:21:04 | Roraima, Brazil | |||
2593767 | 2593767 | 2022-07-25 | Brazil | Roraima | 171360 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-26 04:20:58 | Roraima, Brazil | |||
895882 | 895882 | 2022-07-24 | Brazil | Roraima | 171162 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-25 04:20:51 | Roraima, Brazil | |||
90876 | 90876 | 2022-07-23 | Brazil | Roraima | 171162 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-24 04:20:47 | Roraima, Brazil | |||
899898 | 899898 | 2022-07-22 | Brazil | Roraima | 171162 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-23 04:20:53 | Roraima, Brazil | |||
670034 | 670034 | 2022-07-21 | Brazil | Roraima | 170758 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-22 04:21:15 | Roraima, Brazil | |||
1607997 | 1607997 | 2022-07-20 | Brazil | Roraima | 170407 | 2158 | 0 | -2.7376 | -62.0751 | 2022-07-21 04:21:10 | Roraima, Brazil | |||
3896676 | 3896676 | 2022-05-19 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-20 04:20:57 | Lee, Florida, US | |
1185460 | 1185460 | 2022-05-18 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-19 04:20:54 | Lee, Florida, US | |
3583357 | 3583357 | 2022-05-17 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-18 04:20:50 | Lee, Florida, US | |
1504314 | 1504314 | 2022-05-16 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-17 04:20:59 | Lee, Florida, US | |
2084673 | 2084673 | 2022-05-15 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-16 04:20:47 | Lee, Florida, US | |
3355383 | 3355383 | 2022-05-14 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-15 04:20:53 | Lee, Florida, US | |
659028 | 659028 | 2022-05-13 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-14 04:20:48 | Lee, Florida, US | |
2534111 | 2534111 | 2022-05-12 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-13 04:20:51 | Lee, Florida, US | |
3445557 | 3445557 | 2022-05-11 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-12 04:20:54 | Lee, Florida, US | |
3444846 | 3444846 | 2022-05-11 | Japan | Kanagawa | 720600 | 2158 | 0 | 35.415312 | 139.338983 | 2022-05-12 04:20:54 | Kanagawa, Japan | |||
3536174 | 3536174 | 2022-05-10 | US | Florida | Lee | 12071 | 194299 | 2158 | 0 | 26.58410348 | -81.88399313 | 2022-05-11 04:20:48 | Lee, Florida, US | |
463295 | 463295 | 2022-05-02 | Germany | Mecklenburg-Vorpommern | 467650 | 2158 | 0 | 53.6127 | 12.4296 | 2022-05-03 04:21:00 | Mecklenburg-Vorpommern, Germany | |||
3436956 | 3436956 | 2022-04-22 | Netherlands | Limburg | 527069 | 2158 | 0 | 51.209227 | 5.93387 | 2022-04-23 04:20:50 | Limburg, Netherlands | |||
2669810 | 2669810 | 2022-04-15 | Japan | Hyogo | 362757 | 2158 | 0 | 35.039913 | 134.828057 | 2022-04-16 04:20:48 | Hyogo, Japan | |||
3350846 | 3350846 | 2022-04-01 | Russia | Belgorod Oblast | 126921 | 2158 | 0 | 50.7080119 | 37.5837615 | 2022-04-02 04:20:47 | Belgorod Oblast, Russia | |||
26577 | 26577 | 2022-03-20 | US | New Jersey | Monmouth | 34025 | 162547 | 2158 | 0 | 40.26549699 | -74.22240686 | 2022-03-21 04:20:50 | Monmouth, New Jersey, US | |
696566 | 696566 | 2022-03-17 | US | New Jersey | Monmouth | 34025 | 162345 | 2158 | 0 | 40.26549699 | -74.22240686 | 2022-03-18 04:20:55 | Monmouth, New Jersey, US | |
2140138 | 2140138 | 2022-03-09 | Italy | Calabria | 233237 | 2158 | 0 | 38.90597598 | 16.59440194 | 2022-03-10 04:20:48 | Calabria, Italy | |||
1548524 | 1548524 | 2022-03-07 | US | California | Kern | 6029 | 240299 | 2158 | 0 | 35.34329425 | -118.72777959999999 | 2022-03-08 04:20:54 | Kern, California, US | |
1548183 | 1548183 | 2022-03-07 | Russia | Kemerovo Oblast | 148767 | 2158 | 0 | 54.53357809999999 | 87.342861 | 2022-03-08 04:20:54 | Kemerovo Oblast, Russia | |||
2447354 | 2447354 | 2022-02-22 | US | California | Santa Clara | 6085 | 317083 | 2158 | 0 | 37.23104908 | -121.6970462 | 2022-02-23 04:21:09 | Santa Clara, California, US | |
3875449 | 3875449 | 2022-02-19 | Estonia | 455636 | 2158 | 0 | 58.5953 | 25.0136 | 2022-02-20 04:21:00 | Estonia | ||||
3820518 | 3820518 | 2022-02-16 | Mexico | Campeche | 32425 | 2158 | 0 | 19.8301 | -90.5349 | 2022-02-17 04:20:56 | Campeche, Mexico | |||
233456 | 233456 | 2022-02-11 | Russia | Khakassia Republic | 69916 | 2158 | 0 | 53.72258845 | 91.44293627 | 2022-02-12 04:21:06 | Khakassia Republic, Russia | |||
2613494 | 2613494 | 2022-01-06 | US | Washington | King | 53033 | 222392 | 2158 | 0 | 47.49137892 | -121.8346131 | 2022-01-07 04:22:09 | King, Washington, US | |
1288470 | 1288470 | 2022-01-04 | US | Ohio | Franklin | 39049 | 219288 | 2158 | 0 | 39.96995815 | -83.01115755 | 2022-01-05 04:21:59 | Franklin, Ohio, US | |
1700508 | 1700508 | 2022-01-03 | Peru | Ayacucho | 35090 | 2158 | 0 | -14.091648000000001 | -74.08344 | 2022-01-04 04:22:17 | Ayacucho, Peru | |||
3519591 | 3519591 | 2022-01-02 | Peru | Ayacucho | 35090 | 2158 | 0 | -14.091648000000001 | -74.08344 | 2022-01-03 02:22:25 | Ayacucho, Peru | |||
2167721 | 2167721 | 2022-01-01 | Peru | Ayacucho | 35090 | 2158 | 0 | -14.091648000000001 | -74.08344 | 2022-01-02 04:20:52 | Ayacucho, Peru |
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]);