daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
81 rows where deaths = 2945 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-11-02 | US | Massachusetts | Essex | 25009 | 242495 | 2945 | 0 | 42.6687626 | -70.94687179 | 2022-11-03 04:22:05 | Essex, Massachusetts, US | |
2022-11-01 | US | Massachusetts | Essex | 25009 | 242495 | 2945 | 0 | 42.6687626 | -70.94687179 | 2022-11-02 04:22:09 | Essex, Massachusetts, US | |
2022-10-31 | US | Massachusetts | Essex | 25009 | 242495 | 2945 | 0 | 42.6687626 | -70.94687179 | 2022-11-01 04:22:36 | Essex, Massachusetts, US | |
2022-10-30 | US | Massachusetts | Essex | 25009 | 242495 | 2945 | 0 | 42.6687626 | -70.94687179 | 2022-10-31 04:21:36 | Essex, Massachusetts, US | |
2022-10-29 | US | Massachusetts | Essex | 25009 | 242495 | 2945 | 0 | 42.6687626 | -70.94687179 | 2022-10-30 04:22:14 | Essex, Massachusetts, US | |
2022-10-28 | US | Massachusetts | Essex | 25009 | 242495 | 2945 | 0 | 42.6687626 | -70.94687179 | 2022-10-29 04:21:13 | Essex, Massachusetts, US | |
2022-10-27 | US | Massachusetts | Essex | 25009 | 242495 | 2945 | 0 | 42.6687626 | -70.94687179 | 2022-10-28 04:22:31 | Essex, Massachusetts, US | |
2022-10-24 | US | New Jersey | Middlesex | 34023 | 251499 | 2945 | 0 | 40.43629879 | -74.41426991 | 2022-10-25 04:21:53 | Middlesex, New Jersey, US | |
2022-10-23 | US | New Jersey | Middlesex | 34023 | 251400 | 2945 | 0 | 40.43629879 | -74.41426991 | 2022-10-24 04:22:29 | Middlesex, New Jersey, US | |
2022-10-22 | US | New Jersey | Middlesex | 34023 | 251307 | 2945 | 0 | 40.43629879 | -74.41426991 | 2022-10-23 04:22:46 | Middlesex, New Jersey, US | |
2022-10-21 | US | New Jersey | Middlesex | 34023 | 251143 | 2945 | 0 | 40.43629879 | -74.41426991 | 2022-10-22 04:22:53 | Middlesex, New Jersey, US | |
2022-09-19 | US | Connecticut | New Haven | 9009 | 234068 | 2945 | 0 | 41.4080325 | -72.93620426 | 2022-09-20 04:22:48 | New Haven, Connecticut, US | |
2022-09-18 | US | Connecticut | New Haven | 9009 | 233957 | 2945 | 0 | 41.4080325 | -72.93620426 | 2022-09-19 04:21:49 | New Haven, Connecticut, US | |
2022-09-17 | US | Connecticut | New Haven | 9009 | 233898 | 2945 | 0 | 41.4080325 | -72.93620426 | 2022-09-18 04:22:50 | New Haven, Connecticut, US | |
2022-09-16 | US | Connecticut | New Haven | 9009 | 233711 | 2945 | 0 | 41.4080325 | -72.93620426 | 2022-09-17 04:20:19 | New Haven, Connecticut, US | |
2022-09-15 | US | Connecticut | New Haven | 9009 | 233396 | 2945 | 0 | 41.4080325 | -72.93620426 | 2022-09-16 04:21:19 | New Haven, Connecticut, US | |
2022-07-17 | US | Washington | King | 53033 | 479533 | 2945 | 0 | 47.49137892 | -121.8346131 | 2022-07-18 04:20:59 | King, Washington, US | |
2022-06-15 | Chile | Maule | 253780 | 2945 | 0 | -35.5183 | -71.6885 | 2022-06-16 04:20:55 | Maule, Chile | |||
2022-06-14 | Chile | Maule | 253287 | 2945 | 0 | -35.5183 | -71.6885 | 2022-06-15 04:20:54 | Maule, Chile | |||
2022-06-13 | Chile | Maule | 253057 | 2945 | 0 | -35.5183 | -71.6885 | 2022-06-14 04:20:52 | Maule, Chile | |||
2022-06-12 | Chile | Maule | 252692 | 2945 | 0 | -35.5183 | -71.6885 | 2022-06-13 04:21:14 | Maule, Chile | |||
2022-02-25 | Malaysia | Sabah | 330771 | 2945 | 0 | 5.9788 | 116.0753 | 2022-02-26 04:21:12 | Sabah, Malaysia | |||
2022-02-24 | Italy | Abruzzo | 259705 | 2945 | 0 | 42.35122196 | 13.39843823 | 2022-02-25 04:21:11 | Abruzzo, Italy | |||
2022-01-27 | US | Missouri | St. Louis | 29189 | 207892 | 2945 | 0 | 38.63770039999999 | -90.4458375 | 2022-01-28 04:21:09 | St. Louis, Missouri, US | |
2022-01-26 | Mexico | Nayarit | 46664 | 2945 | 0 | 21.7514 | -104.8455 | 2022-01-27 04:21:19 | Nayarit, Mexico | |||
2022-01-25 | Mexico | Nayarit | 46664 | 2945 | 0 | 21.7514 | -104.8455 | 2022-01-26 04:21:07 | Nayarit, Mexico | |||
2022-01-05 | Russia | Vladimir Oblast | 82344 | 2945 | 0 | 56.0503336 | 40.656163299999996 | 2022-01-06 04:22:09 | Vladimir Oblast, Russia | |||
2021-12-17 | Ukraine | Vinnytsia Oblast | 110020 | 2945 | 0 | 49.2331 | 28.4682 | 2021-12-18 02:22:20 | Vinnytsia Oblast, Ukraine | |||
2021-12-17 | Ukraine | Chernivtsi Oblast | 117995 | 2945 | 0 | 48.2917 | 25.9352 | 2021-12-18 02:22:20 | Chernivtsi Oblast, Ukraine | |||
2021-12-10 | Russia | Omsk Oblast | 120331 | 2945 | 0 | 56.09352629999999 | 73.5099936 | 2021-12-11 04:22:45 | Omsk Oblast, Russia | |||
2021-11-29 | US | Illinois | Unassigned | 90017 | 69 | 2945 | 0 | 42.36542373 | 0.0 | 2021-11-30 04:22:53 | Unassigned, Illinois, US | |
2021-11-28 | US | Illinois | Unassigned | 90017 | 78 | 2945 | 0 | 42.36542373 | 0.0 | 2021-11-29 04:22:30 | Unassigned, Illinois, US | |
2021-11-27 | US | Illinois | Unassigned | 90017 | 78 | 2945 | 0 | 42.36542373 | 0.0 | 2021-11-28 04:22:43 | Unassigned, Illinois, US | |
2021-11-26 | Ukraine | Zhytomyr Oblast | 132217 | 2945 | 0 | 50.2547 | 28.6587 | 2021-11-27 04:22:45 | Zhytomyr Oblast, Ukraine | |||
2021-11-26 | US | Illinois | Unassigned | 90017 | 78 | 2945 | 0 | 42.36542373 | 0.0 | 2021-11-27 04:22:45 | Unassigned, Illinois, US | |
2021-11-25 | US | Illinois | Unassigned | 90017 | 78 | 2945 | 0 | 42.36542373 | 0.0 | 2021-11-26 04:22:33 | Unassigned, Illinois, US | |
2021-10-09 | Ukraine | Kiev Oblast | 137688 | 2945 | 0 | 50.053000000000004 | 30.7667 | 2021-10-10 04:21:38 | Kiev Oblast, Ukraine | |||
2021-10-07 | Russia | Volgograd Oblast | 94606 | 2945 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-08 04:21:25 | Volgograd Oblast, Russia | |||
2021-06-01 | Peru | Ucayali | 31239 | 2945 | 0 | 28294 | -9.621718 | -73.444929 | 2021-06-02 04:24:34 | Ucayali, Peru | ||
2021-05-24 | Russia | Krasnodar Krai | 47767 | 2945 | 42762 | 2060 | 45.7684014 | 39.0261044 | 2021-05-25 04:21:08 | Krasnodar Krai, Russia | ||
2021-05-03 | Italy | Marche | 98155 | 2945 | 89134 | 6076 | 43.61675973 | 13.5188753 | 2021-05-04 04:20:34 | Marche, Italy | ||
2021-04-13 | Mexico | Morelos | 31009 | 2945 | 0 | 28064 | 18.6813 | -99.1013 | 2021-04-14 04:20:41 | Morelos, Mexico | ||
2021-04-12 | Mexico | Morelos | 31009 | 2945 | 0 | 28064 | 18.6813 | -99.1013 | 2021-04-13 04:20:37 | Morelos, Mexico | ||
2021-04-11 | Russia | Nizhny Novgorod Oblast | 110264 | 2945 | 105011 | 2308 | 55.47180329999999 | 44.0911594 | 2021-04-12 04:21:00 | Nizhny Novgorod Oblast, Russia | ||
2021-04-10 | United Kingdom | Northern Ireland | 118178 | 2945 | 0 | 116050 | 54.7877 | -6.4923 | 2021-04-11 04:20:56 | Northern Ireland, United Kingdom | ||
2021-03-21 | Netherlands | Noord-Brabant | 187852 | 2945 | 0 | 186371 | 51.561174 | 5.184942 | 2021-03-22 05:25:43 | Noord-Brabant, Netherlands | ||
2021-02-18 | Germany | Rheinland-Pfalz | 98759 | 2945 | 91001 | 5256 | 50.1183 | 7.309 | 2021-02-19 05:24:16 | Rheinland-Pfalz, Germany | ||
2021-02-16 | Algeria | 111069 | 2945 | 76330 | 31794 | 28.0339 | 1.6596 | 2021-02-17 05:23:10 | Algeria | |||
2021-02-15 | US | California | San Bernardino | 6071 | 286251 | 2945 | 0 | 283801 | 34.84060306 | -116.1774685 | 2021-02-16 05:24:38 | San Bernardino, California, US |
2021-02-07 | US | Pennsylvania | Philadelphia | 42101 | 113476 | 2945 | 0 | 110531 | 40.00338507 | -75.1379271 | 2021-02-08 05:22:39 | Philadelphia, Pennsylvania, US |
2021-02-06 | US | Pennsylvania | Philadelphia | 42101 | 113195 | 2945 | 0 | 110250 | 40.00338507 | -75.1379271 | 2021-02-07 05:23:00 | Philadelphia, Pennsylvania, US |
2021-02-05 | US | Pennsylvania | Philadelphia | 42101 | 112781 | 2945 | 0 | 109836 | 40.00338507 | -75.1379271 | 2021-02-06 05:23:55 | Philadelphia, Pennsylvania, US |
2021-01-23 | Germany | Niedersachsen | 134927 | 2945 | 118425 | 13770 | 52.6367 | 9.8451 | 2021-01-24 05:22:35 | Niedersachsen, Germany | ||
2021-01-15 | Brazil | Piaui | 151046 | 2945 | 147653 | 0 | -7.7183 | -42.7289 | 2021-01-16 05:22:40 | Piaui, Brazil | ||
2020-11-26 | Pakistan | Punjab | 117160 | 2945 | 98191 | 16024 | 30.811346 | 72.13913199999998 | 2020-11-27 05:26:53 | Punjab, Pakistan | ||
2020-08-26 | India | Gujarat | 89994 | 2945 | 72282 | 14767 | 22.694884 | 71.590923 | 2020-08-27 04:28:15 | Gujarat, India | ||
2020-06-18 | Spain | Castilla - La Mancha | 17894 | 2945 | 6392 | 8557 | 39.2796 | -3.0977 | 2020-06-19 04:33:17 | Castilla - La Mancha, Spain | ||
2020-06-17 | Spain | Castilla - La Mancha | 17845 | 2945 | 6392 | 8508 | 39.2796 | -3.0977 | 2020-06-18 04:33:18 | Castilla - La Mancha, Spain | ||
2020-06-16 | Spain | Castilla - La Mancha | 17828 | 2945 | 6392 | 8491 | 39.2796 | -3.0977 | 2020-06-17 04:33:21 | Castilla - La Mancha, Spain | ||
2020-06-15 | Spain | Castilla - La Mancha | 17811 | 2945 | 6392 | 8474 | 39.2796 | -3.0977 | 2020-06-16 04:33:09 | Castilla - La Mancha, Spain | ||
2020-06-14 | Spain | Castilla - La Mancha | 17803 | 2945 | 6392 | 8466 | 39.2796 | -3.0977 | 2020-06-15 03:33:14 | Castilla - La Mancha, Spain | ||
2020-06-13 | Spain | Castilla - La Mancha | 17776 | 2945 | 6392 | 8439 | 39.2796 | -3.0977 | 2020-06-14 03:33:15 | Castilla - La Mancha, Spain | ||
2020-06-12 | Spain | Castilla - La Mancha | 17740 | 2945 | 6392 | 8403 | 39.2796 | -3.0977 | 2020-06-13 03:33:14 | Castilla - La Mancha, Spain | ||
2020-06-11 | Spain | Castilla - La Mancha | 17702 | 2945 | 6392 | 8365 | 39.2796 | -3.0977 | 2020-06-12 05:09:52 | Castilla - La Mancha, Spain | ||
2020-06-10 | Spain | Castilla - La Mancha | 17640 | 2945 | 6392 | 8303 | 39.2796 | -3.0977 | 2020-06-11 03:33:41 | Castilla - La Mancha, Spain | ||
2020-06-09 | Spain | Castilla - La Mancha | 17609 | 2945 | 6392 | 8272 | 39.2796 | -3.0977 | 2020-06-10 04:07:00 | Castilla - La Mancha, Spain | ||
2020-06-08 | Spain | Castilla - La Mancha | 17543 | 2945 | 6392 | 8206 | 39.2796 | -3.0977 | 2020-06-09 03:33:03 | Castilla - La Mancha, Spain | ||
2020-06-07 | Spain | Castilla - La Mancha | 17505 | 2945 | 6392 | 8168 | 39.2796 | -3.0977 | 2020-06-08 03:33:22 | Castilla - La Mancha, Spain | ||
2020-06-06 | Spain | Castilla - La Mancha | 17472 | 2945 | 6392 | 8135 | 39.2796 | -3.0977 | 2020-06-07 03:53:30 | Castilla - La Mancha, Spain | ||
2020-06-05 | Spain | Castilla - La Mancha | 17431 | 2945 | 6392 | 8094 | 39.2796 | -3.0977 | 2020-06-06 02:33:00 | Castilla - La Mancha, Spain | ||
2020-06-04 | Spain | Castilla - La Mancha | 17393 | 2945 | 6392 | 8056 | 39.2796 | -3.0977 | 2020-06-05 02:33:06 | Castilla - La Mancha, Spain | ||
2020-06-03 | Spain | Castilla - La Mancha | 17355 | 2945 | 6392 | 8018 | 39.2796 | -3.0977 | 2020-06-04 02:33:14 | Castilla - La Mancha, Spain | ||
2020-06-02 | Spain | Castilla - La Mancha | 17310 | 2945 | 6392 | 7973 | 39.2796 | -3.0977 | 2020-06-03 02:33:13 | Castilla - La Mancha, Spain | ||
2020-06-01 | Spain | Castilla - La Mancha | 17259 | 2945 | 6392 | 7922 | 39.2796 | -3.0977 | 2020-06-02 02:33:08 | Castilla - La Mancha, Spain | ||
2020-05-31 | Spain | Castilla - La Mancha | 17234 | 2945 | 6392 | 7897 | 39.2796 | -3.0977 | 2020-06-01 02:32:46 | Castilla - La Mancha, Spain | ||
2020-05-30 | Spain | Castilla - La Mancha | 17184 | 2945 | 6392 | 7847 | 39.2796 | -3.0977 | 2020-05-31 02:32:45 | Castilla - La Mancha, Spain | ||
2020-05-29 | Spain | Castilla - La Mancha | 17122 | 2945 | 6392 | 7785 | 39.2796 | -3.0977 | 2020-05-30 02:32:48 | Castilla - La Mancha, Spain | ||
2020-05-28 | Spain | Castilla - La Mancha | 17068 | 2945 | 6392 | 7731 | 39.2796 | -3.0977 | 2020-05-29 02:32:50 | Castilla - La Mancha, Spain | ||
2020-05-27 | Spain | Castilla - La Mancha | 16992 | 2945 | 6392 | 7655 | 39.2796 | -3.0977 | 2020-05-28 02:32:31 | Castilla - La Mancha, Spain | ||
2020-05-26 | Spain | Castilla - La Mancha | 16992 | 2945 | 6392 | 7655 | 39.2796 | -3.0977 | 2020-05-27 02:32:31 | Castilla - La Mancha, Spain | ||
2020-04-14 | Netherlands | 27419 | 2945 | 250 | 24224 | 52.1326 | 5.2913 | 2020-04-14 23:33:12 | Netherlands |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;