daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
114 rows where deaths = 1071 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-13 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-14 04:21:04 | Martinique, France | |||
2022-12-12 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-13 04:21:01 | Martinique, France | |||
2022-12-11 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-12 04:21:01 | Martinique, France | |||
2022-12-10 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-11 04:20:50 | Martinique, France | |||
2022-12-09 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-10 04:21:02 | Martinique, France | |||
2022-12-08 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-09 04:21:05 | Martinique, France | |||
2022-12-07 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-08 04:21:07 | Martinique, France | |||
2022-12-06 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-07 04:20:58 | Martinique, France | |||
2022-12-05 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-06 04:21:03 | Martinique, France | |||
2022-12-04 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-05 04:20:58 | Martinique, France | |||
2022-12-03 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-04 04:20:56 | Martinique, France | |||
2022-12-02 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-03 04:21:02 | Martinique, France | |||
2022-12-01 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-02 04:21:07 | Martinique, France | |||
2022-11-30 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-12-01 04:21:03 | Martinique, France | |||
2022-11-29 | France | Martinique | 224468 | 1071 | 0 | 14.6415 | -61.0242 | 2022-11-30 04:21:07 | Martinique, France | |||
2022-10-08 | Russia | Kirov Oblast | 161448 | 1071 | 0 | 57.9665589 | 49.4074599 | 2022-10-09 04:21:16 | Kirov Oblast, Russia | |||
2022-10-07 | Russia | Kirov Oblast | 161273 | 1071 | 0 | 57.9665589 | 49.4074599 | 2022-10-08 04:22:56 | Kirov Oblast, Russia | |||
2022-10-04 | Japan | Kyoto | 479145 | 1071 | 0 | 35.253815 | 135.443341 | 2022-10-05 04:23:06 | Kyoto, Japan | |||
2022-05-11 | Luxembourg | 242194 | 1071 | 0 | 49.8153 | 6.1296 | 2022-05-12 04:20:54 | Luxembourg | ||||
2022-05-08 | US | New York | Onondaga | 36067 | 120905 | 1071 | 0 | 43.00491923 | -76.19971155 | 2022-05-09 04:20:54 | Onondaga, New York, US | |
2022-04-02 | Chile | Nuble | 98108 | 1071 | 0 | -36.7226 | -71.7622 | 2022-04-03 04:20:48 | Nuble, Chile | |||
2022-03-23 | Malaysia | Melaka | 113022 | 1071 | 0 | 2.1896 | 102.2501 | 2022-03-24 04:20:43 | Melaka, Malaysia | |||
2022-03-12 | Russia | Mari El Republic | 43861 | 1071 | 0 | 56.576750399999995 | 47.881751200000004 | 2022-03-13 04:20:49 | Mari El Republic, Russia | |||
2022-03-07 | US | Pennsylvania | Northampton | 42095 | 78927 | 1071 | 0 | 40.75182733 | -75.30471829 | 2022-03-08 04:20:54 | Northampton, Pennsylvania, US | |
2022-03-06 | US | Pennsylvania | Northampton | 42095 | 78918 | 1071 | 0 | 40.75182733 | -75.30471829 | 2022-03-07 04:20:47 | Northampton, Pennsylvania, US | |
2022-03-05 | Russia | Chechen Republic | 42367 | 1071 | 0 | 43.39761470000001 | 45.6985005 | 2022-03-06 04:20:49 | Chechen Republic, Russia | |||
2022-03-04 | Russia | Chechen Republic | 42330 | 1071 | 0 | 43.39761470000001 | 45.6985005 | 2022-03-05 04:21:10 | Chechen Republic, Russia | |||
2022-03-03 | Russia | Chechen Republic | 42310 | 1071 | 0 | 43.39761470000001 | 45.6985005 | 2022-03-04 04:21:09 | Chechen Republic, Russia | |||
2022-02-24 | US | Ohio | Mahoning | 39099 | 53008 | 1071 | 0 | 41.01631101 | -80.77287029 | 2022-02-25 04:21:11 | Mahoning, Ohio, US | |
2022-02-21 | US | North Carolina | Guilford | 37081 | 113421 | 1071 | 0 | 36.07959451 | -79.78824948 | 2022-02-22 04:21:01 | Guilford, North Carolina, US | |
2022-02-11 | Russia | Kurgan Oblast | 64646 | 1071 | 0 | 55.7655302 | 64.5632681 | 2022-02-12 04:21:06 | Kurgan Oblast, Russia | |||
2022-01-30 | US | Ohio | Butler | 39017 | 86580 | 1071 | 0 | 39.44012838 | -84.57388716 | 2022-01-31 04:21:09 | Butler, Ohio, US | |
2022-01-26 | Russia | North Ossetia - Alania Republic | 32912 | 1071 | 0 | 42.79336110000001 | 44.6324493 | 2022-01-27 04:21:19 | North Ossetia - Alania Republic, Russia | |||
2022-01-12 | Russia | Mordovia Republic | 41081 | 1071 | 0 | 54.4419829 | 44.466114399999995 | 2022-01-13 08:00:09 | Mordovia Republic, Russia | |||
2022-01-10 | Spain | Baleares | 156758 | 1071 | 0 | 39.710358 | 2.995148 | 2022-01-11 04:22:01 | Baleares, Spain | |||
2022-01-07 | US | Pennsylvania | Lehigh | 42077 | 70687 | 1071 | 0 | 40.6154815 | -75.59435245 | 2022-01-08 04:21:53 | Lehigh, Pennsylvania, US | |
2022-01-06 | US | California | Contra Costa | 6013 | 125225 | 1071 | 0 | 37.91923498 | -121.9289527 | 2022-01-07 04:22:09 | Contra Costa, California, US | |
2022-01-02 | US | Pennsylvania | Luzerne | 42079 | 54392 | 1071 | 0 | 41.17823008 | -75.98447579 | 2022-01-03 02:22:25 | Luzerne, Pennsylvania, US | |
2022-01-01 | US | Pennsylvania | Luzerne | 42079 | 53983 | 1071 | 0 | 41.17823008 | -75.98447579 | 2022-01-02 04:20:52 | Luzerne, Pennsylvania, US | |
2021-12-28 | US | California | Contra Costa | 6013 | 110069 | 1071 | 0 | 37.91923498 | -121.9289527 | 2021-12-29 03:21:43 | Contra Costa, California, US | |
2021-12-27 | US | California | Contra Costa | 6013 | 109518 | 1071 | 0 | 37.91923498 | -121.9289527 | 2021-12-28 04:21:47 | Contra Costa, California, US | |
2021-12-26 | US | California | Contra Costa | 6013 | 107749 | 1071 | 0 | 37.91923498 | -121.9289527 | 2021-12-27 04:21:58 | Contra Costa, California, US | |
2021-12-25 | US | California | Contra Costa | 6013 | 107695 | 1071 | 0 | 37.91923498 | -121.9289527 | 2021-12-26 04:21:50 | Contra Costa, California, US | |
2021-12-24 | US | California | Contra Costa | 6013 | 107662 | 1071 | 0 | 37.91923498 | -121.9289527 | 2021-12-25 04:21:37 | Contra Costa, California, US | |
2021-12-21 | Russia | Kostroma Oblast | 48035 | 1071 | 0 | 58.424756 | 44.253327299999995 | 2021-12-22 04:21:54 | Kostroma Oblast, Russia | |||
2021-11-11 | US | Georgia | Out of GA | 80013 | 41951 | 1071 | 0 | 34.91369188 | 0.0 | 2021-11-12 04:22:01 | Out of GA, Georgia, US | |
2021-11-10 | US | Georgia | Out of GA | 80013 | 41951 | 1071 | 0 | 34.91369188 | 0.0 | 2021-11-11 04:21:45 | Out of GA, Georgia, US | |
2021-11-03 | US | Texas | Montgomery | 48339 | 88782 | 1071 | 0 | 30.30079133 | -95.50572772 | 2021-11-04 04:22:20 | Montgomery, Texas, US | |
2021-10-24 | US | Arizona | Pinal | 4021 | 72572 | 1071 | 0 | 32.90525627 | -111.3449483 | 2021-10-25 04:22:31 | Pinal, Arizona, US | |
2021-10-23 | US | Arizona | Pinal | 4021 | 72566 | 1071 | 0 | 32.90525627 | -111.3449483 | 2021-10-24 04:21:22 | Pinal, Arizona, US | |
2021-10-06 | US | South Carolina | Spartanburg | 45083 | 59843 | 1071 | 0 | 34.92960077 | -81.99225984 | 2021-10-07 04:21:36 | Spartanburg, South Carolina, US | |
2021-10-05 | US | Illinois | Lake | 17097 | 78542 | 1071 | 0 | 42.3224907 | -88.00367925 | 2021-10-06 04:21:33 | Lake, Illinois, US | |
2021-10-04 | US | Illinois | Lake | 17097 | 78468 | 1071 | 0 | 42.3224907 | -88.00367925 | 2021-10-05 04:21:27 | Lake, Illinois, US | |
2021-10-03 | US | New Mexico | Bernalillo | 35001 | 71541 | 1071 | 0 | 35.05163625 | -106.6703554 | 2021-10-04 04:21:31 | Bernalillo, New Mexico, US | |
2021-10-02 | US | New Mexico | Bernalillo | 35001 | 71541 | 1071 | 0 | 35.05163625 | -106.6703554 | 2021-10-03 04:21:24 | Bernalillo, New Mexico, US | |
2021-10-01 | US | New Mexico | Bernalillo | 35001 | 71541 | 1071 | 0 | 35.05163625 | -106.6703554 | 2021-10-02 04:21:25 | Bernalillo, New Mexico, US | |
2021-09-30 | US | New Mexico | Bernalillo | 35001 | 71328 | 1071 | 0 | 35.05163625 | -106.6703554 | 2021-10-01 04:21:35 | Bernalillo, New Mexico, US | |
2021-09-27 | US | Colorado | El Paso | 8041 | 92532 | 1071 | 0 | 38.83240149 | -104.5251411 | 2021-09-28 04:21:28 | El Paso, Colorado, US | |
2021-09-23 | Russia | Khakassia Republic | 37970 | 1071 | 0 | 53.72258845 | 91.44293627 | 2021-09-24 04:21:44 | Khakassia Republic, Russia | |||
2021-09-14 | Ukraine | Sevastopol* | 28764 | 1071 | 0 | 44.6054 | 33.522 | 2021-09-15 03:22:37 | Sevastopol*, Ukraine | |||
2021-09-06 | US | Alabama | Mobile | 1097 | 65549 | 1071 | 0 | 30.78472347 | -88.20842409 | 2021-09-07 04:21:35 | Mobile, Alabama, US | |
2021-09-03 | Russia | Zabaykalsky Krai | 64300 | 1071 | 0 | 52.248521000000004 | 115.956325 | 2021-09-04 04:21:28 | Zabaykalsky Krai, Russia | |||
2021-07-29 | US | Ohio | Montgomery | 39113 | 53732 | 1071 | 0 | 39.75394919 | -84.29050975 | 2021-07-30 04:21:34 | Montgomery, Ohio, US | |
2021-07-28 | US | Ohio | Montgomery | 39113 | 53658 | 1071 | 0 | 39.75394919 | -84.29050975 | 2021-07-29 04:21:33 | Montgomery, Ohio, US | |
2021-07-27 | US | Ohio | Montgomery | 39113 | 53542 | 1071 | 0 | 39.75394919 | -84.29050975 | 2021-07-28 04:21:39 | Montgomery, Ohio, US | |
2021-07-26 | US | Ohio | Montgomery | 39113 | 53449 | 1071 | 0 | 39.75394919 | -84.29050975 | 2021-07-27 04:21:18 | Montgomery, Ohio, US | |
2021-06-23 | Russia | Buryatia Republic | 42177 | 1071 | 39861 | 1245 | 52.7182426 | 109.492143 | 2021-06-24 04:21:55 | Buryatia Republic, Russia | ||
2021-06-18 | US | Georgia | DeKalb | 13089 | 67071 | 1071 | 0 | 33.76944049 | -84.22396017 | 2021-06-19 04:22:33 | DeKalb, Georgia, US | |
2021-06-04 | Canada | Manitoba | 52261 | 1071 | 46999 | 4191 | 53.7609 | -98.8139 | 2021-06-05 04:23:03 | Manitoba, Canada | ||
2021-05-13 | US | Maryland | Baltimore City | 24510 | 52153 | 1071 | 0 | 39.30211911 | -76.61151012 | 2021-05-14 04:20:41 | Baltimore City, Maryland, US | |
2021-05-08 | Italy | Calabria | 62638 | 1071 | 47900 | 13667 | 38.90597598 | 16.59440194 | 2021-05-09 04:20:35 | Calabria, Italy | ||
2021-04-24 | Russia | Volgograd Oblast | 56255 | 1071 | 53816 | 1368 | 49.6048339 | 44.29035820000001 | 2021-04-25 04:20:32 | Volgograd Oblast, Russia | ||
2021-04-22 | Russia | Vladimir Oblast | 31461 | 1071 | 28853 | 1537 | 56.0503336 | 40.6561633 | 2021-04-23 04:20:52 | Vladimir Oblast, Russia | ||
2021-04-17 | Russia | Leningrad Oblast | 41449 | 1071 | 38808 | 1570 | 60.1853296 | 32.3925325 | 2021-04-18 04:20:41 | Leningrad Oblast, Russia | ||
2021-04-15 | Colombia | Caldas | 54314 | 1071 | 50769 | 2474 | 5.2983 | -75.2479 | 2021-04-16 04:20:46 | Caldas, Colombia | ||
2021-04-08 | Colombia | Quindio | 35569 | 1071 | 34043 | 455 | 4.461 | -75.6674 | 2021-04-09 04:21:13 | Quindio, Colombia | ||
2021-04-03 | Uruguay | 113904 | 1071 | 89035 | 23798 | -32.5228 | -55.7658 | 2021-04-04 04:20:49 | Uruguay | |||
2021-04-01 | US | Georgia | Gwinnett | 13135 | 96990 | 1071 | 0 | 33.96044201 | -84.02137802 | 2021-04-02 04:20:36 | Gwinnett, Georgia, US | |
2021-03-28 | Russia | Samara Oblast | 55136 | 1071 | 51869 | 2196 | 53.2128813 | 50.8914633 | 2021-03-29 04:28:35 | Samara Oblast, Russia | ||
2021-03-12 | US | Massachusetts | Plymouth | 25023 | 41492 | 1071 | 0 | 41.94070556 | -70.80802823 | 2021-03-13 05:25:15 | Plymouth, Massachusetts, US | |
2021-03-11 | Italy | P.A. Bolzano | 55915 | 1071 | 50192 | 4652 | 46.49933453 | 11.35662422 | 2021-03-12 05:26:50 | P.A. Bolzano, Italy | ||
2021-03-09 | Brazil | Acre | 60721 | 1071 | 51502 | 8148 | -9.0238 | -70.812 | 2021-03-10 05:24:35 | Acre, Brazil | ||
2021-02-25 | Mexico | Colima | 10330 | 1071 | 0 | 9259 | 19.1223 | -104.0072 | 2021-02-26 05:22:40 | Colima, Mexico | ||
2021-02-24 | Colombia | Boyaca | 45834 | 1071 | 43613 | 1150 | 5.4545 | -73.362 | 2021-02-25 05:24:57 | Boyaca, Colombia | ||
2021-02-21 | US | Florida | Orange | 12095 | 111886 | 1071 | 0 | 110815 | 28.51367621 | -81.31799498 | 2021-02-22 05:24:21 | Orange, Florida, US |
2021-02-20 | US | Florida | Orange | 12095 | 111578 | 1071 | 0 | 110507 | 28.51367621 | -81.31799498 | 2021-02-21 05:24:33 | Orange, Florida, US |
2021-02-12 | Netherlands | Utrecht | 81827 | 1071 | 0 | 80713 | 52.084251 | 5.163824 | 2021-02-13 05:22:12 | Utrecht, Netherlands | ||
2021-02-10 | US | Pennsylvania | Bucks | 42017 | 41926 | 1071 | 0 | 40855 | 40.33682119 | -75.10836643 | 2021-02-11 05:23:55 | Bucks, Pennsylvania, US |
2021-02-09 | Mexico | Baja California Sur | 24634 | 1071 | 0 | 23563 | 26.0444 | -111.6661 | 2021-02-10 05:22:41 | Baja California Sur, Mexico | ||
2021-01-31 | Germany | Hamburg | 46264 | 1071 | 39033 | 6303 | 53.5511 | 9.9937 | 2021-02-01 05:22:53 | Hamburg, Germany | ||
2021-01-30 | India | Jharkhand | 118651 | 1071 | 117004 | 576 | 23.654536 | 85.557631 | 2021-01-31 05:22:42 | Jharkhand, India | ||
2021-01-07 | Mexico | Nayarit | 8151 | 1071 | 0 | 7080 | 21.7514 | -104.8455 | 2021-01-08 05:22:42 | Nayarit, Mexico | ||
2021-01-03 | US | Ohio | Franklin | 39049 | 86446 | 1071 | 0 | 85375 | 39.96995815 | -83.01115755 | 2021-01-04 05:22:02 | Franklin, Ohio, US |
2021-01-01 | US | Florida | Hillsborough | 12057 | 77118 | 1071 | 0 | 76047 | 27.9276559 | -82.32013172 | 2021-01-02 05:22:33 | Hillsborough, Florida, US |
2020-12-31 | US | Florida | Hillsborough | 12057 | 77118 | 1071 | 0 | 76047 | 27.9276559 | -82.32013172 | 2021-01-01 05:23:07 | Hillsborough, Florida, US |
2020-12-31 | Peru | Huanuco | 20492 | 1071 | 0 | 19421 | -9.421676 | -76.040642 | 2021-01-01 05:23:07 | Huanuco, Peru | ||
2020-11-27 | US | Massachusetts | Suffolk | 25025 | 36276 | 1071 | 0 | 35042 | 42.3279514 | -71.07850442 | 2020-11-28 05:25:50 | Suffolk, Massachusetts, US |
2020-11-24 | Germany | Hessen | 77897 | 1071 | 49621 | 28528 | 50.6521 | 9.1624 | 2020-11-25 05:27:20 | Hessen, Germany | ||
2020-11-04 | North Macedonia | 35097 | 1071 | 22024 | 12002 | 41.6086 | 21.7453 | 2020-11-05 06:05:03 | North Macedonia | |||
2020-10-17 | Oman | 108296 | 1071 | 94229 | 12996 | 21.512583 | 55.92325500000001 | 2020-10-18 04:24:25 | Oman |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;