daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,491 rows where deaths = 154 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 4,005
- Spain 79
- Colombia 61
- Japan 51
- Russia 40
- Andorra 35
- Djibouti 20
- Germany 19
- France 15
- Malaysia 11
- Canada 8
- Peru 8
- Guinea-Bissau 7
- Nicaragua 7
- Seychelles 7
- Burkina Faso 6
- Chile 6
- Guyana 6
- Sweden 6
- Benin 5
- Gabon 5
- Netherlands 5
- Pakistan 5
- Ukraine 5
- Equatorial Guinea 4
- Mexico 4
- Papua New Guinea 4
- Suriname 4
- Australia 3
- Bahamas 3
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Texas | Washington | 48477 | 10726 | 154 | 0 | 30.21498498 | -96.40946246 | 2022-12-30 04:21:04 | Washington, Texas, US | |
2022-12-29 | US | Oklahoma | Garvin | 40049 | 8284 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-30 04:21:04 | Garvin, Oklahoma, US | |
2022-12-29 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-30 04:21:04 | Carteret, North Carolina, US | |
2022-12-29 | US | Michigan | Alpena | 26007 | 6388 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-30 04:21:04 | Alpena, Michigan, US | |
2022-12-29 | US | Arizona | La Paz | 4012 | 5896 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-30 04:21:04 | La Paz, Arizona, US | |
2022-12-28 | US | Texas | Washington | 48477 | 10726 | 154 | 0 | 30.21498498 | -96.40946246 | 2022-12-29 04:21:01 | Washington, Texas, US | |
2022-12-28 | US | Oklahoma | Garvin | 40049 | 8252 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-29 04:21:01 | Garvin, Oklahoma, US | |
2022-12-28 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-29 04:21:01 | Carteret, North Carolina, US | |
2022-12-28 | US | Michigan | Alpena | 26007 | 6388 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-29 04:21:01 | Alpena, Michigan, US | |
2022-12-28 | US | Arizona | La Paz | 4012 | 5896 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-29 04:21:01 | La Paz, Arizona, US | |
2022-12-27 | US | Oklahoma | Garvin | 40049 | 8252 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-28 04:21:04 | Garvin, Oklahoma, US | |
2022-12-27 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-28 04:21:04 | Carteret, North Carolina, US | |
2022-12-27 | US | Michigan | Alpena | 26007 | 6388 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-28 04:21:04 | Alpena, Michigan, US | |
2022-12-27 | US | Iowa | Dallas | 19049 | 26432 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-28 04:21:04 | Dallas, Iowa, US | |
2022-12-27 | US | Arizona | La Paz | 4012 | 5879 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-28 04:21:04 | La Paz, Arizona, US | |
2022-12-26 | US | Oklahoma | Garvin | 40049 | 8252 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-27 04:21:07 | Garvin, Oklahoma, US | |
2022-12-26 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-27 04:21:07 | Carteret, North Carolina, US | |
2022-12-26 | US | Michigan | Alpena | 26007 | 6375 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-27 04:21:07 | Alpena, Michigan, US | |
2022-12-26 | US | Iowa | Dallas | 19049 | 26432 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-27 04:21:07 | Dallas, Iowa, US | |
2022-12-26 | US | Arizona | La Paz | 4012 | 5879 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-27 04:21:07 | La Paz, Arizona, US | |
2022-12-25 | US | Oklahoma | Garvin | 40049 | 8252 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-26 04:21:06 | Garvin, Oklahoma, US | |
2022-12-25 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-26 04:21:06 | Carteret, North Carolina, US | |
2022-12-25 | US | Michigan | Alpena | 26007 | 6375 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-26 04:21:06 | Alpena, Michigan, US | |
2022-12-25 | US | Iowa | Dallas | 19049 | 26432 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-26 04:21:06 | Dallas, Iowa, US | |
2022-12-25 | US | Arizona | La Paz | 4012 | 5879 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-26 04:21:06 | La Paz, Arizona, US | |
2022-12-24 | US | Oklahoma | Garvin | 40049 | 8252 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-25 04:21:04 | Garvin, Oklahoma, US | |
2022-12-24 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-25 04:21:04 | Carteret, North Carolina, US | |
2022-12-24 | US | Michigan | Alpena | 26007 | 6375 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-25 04:21:04 | Alpena, Michigan, US | |
2022-12-24 | US | Iowa | Dallas | 19049 | 26432 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-25 04:21:04 | Dallas, Iowa, US | |
2022-12-24 | US | Arizona | La Paz | 4012 | 5879 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-25 04:21:04 | La Paz, Arizona, US | |
2022-12-23 | US | Oklahoma | Garvin | 40049 | 8252 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-24 04:21:02 | Garvin, Oklahoma, US | |
2022-12-23 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-24 04:21:02 | Carteret, North Carolina, US | |
2022-12-23 | US | Michigan | Alpena | 26007 | 6375 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-24 04:21:02 | Alpena, Michigan, US | |
2022-12-23 | US | Iowa | Dallas | 19049 | 26432 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-24 04:21:02 | Dallas, Iowa, US | |
2022-12-23 | US | Arizona | La Paz | 4012 | 5879 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-24 04:21:02 | La Paz, Arizona, US | |
2022-12-22 | US | Oklahoma | Garvin | 40049 | 8252 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-23 04:21:04 | Garvin, Oklahoma, US | |
2022-12-22 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-23 04:21:04 | Carteret, North Carolina, US | |
2022-12-22 | US | Michigan | Alpena | 26007 | 6375 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-23 04:21:04 | Alpena, Michigan, US | |
2022-12-22 | US | Iowa | Dallas | 19049 | 26432 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-23 04:21:04 | Dallas, Iowa, US | |
2022-12-22 | US | Arizona | La Paz | 4012 | 5879 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-23 04:21:04 | La Paz, Arizona, US | |
2022-12-21 | US | Oklahoma | Garvin | 40049 | 8180 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-22 04:20:56 | Garvin, Oklahoma, US | |
2022-12-21 | US | North Carolina | Carteret | 37031 | 17751 | 154 | 0 | 34.8932941 | -76.54120135 | 2022-12-22 04:20:56 | Carteret, North Carolina, US | |
2022-12-21 | US | Michigan | Alpena | 26007 | 6375 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-22 04:20:56 | Alpena, Michigan, US | |
2022-12-21 | US | Iowa | Dallas | 19049 | 26432 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-22 04:20:56 | Dallas, Iowa, US | |
2022-12-21 | US | Arizona | La Paz | 4012 | 5879 | 154 | 0 | 33.72854224 | -113.9810029 | 2022-12-22 04:20:56 | La Paz, Arizona, US | |
2022-12-20 | US | Oklahoma | Garvin | 40049 | 8180 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-21 04:21:03 | Garvin, Oklahoma, US | |
2022-12-20 | US | Michigan | Alpena | 26007 | 6375 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-21 04:21:03 | Alpena, Michigan, US | |
2022-12-20 | US | Iowa | Dallas | 19049 | 26347 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-21 04:21:03 | Dallas, Iowa, US | |
2022-12-20 | Japan | Shimane | 123789 | 154 | 0 | 35.07076 | 132.554064 | 2022-12-21 04:21:03 | Shimane, Japan | |||
2022-12-19 | US | Oklahoma | Garvin | 40049 | 8180 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-20 04:21:04 | Garvin, Oklahoma, US | |
2022-12-19 | US | Michigan | Alpena | 26007 | 6357 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-20 04:21:04 | Alpena, Michigan, US | |
2022-12-19 | US | Iowa | Dallas | 19049 | 26347 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-20 04:21:04 | Dallas, Iowa, US | |
2022-12-18 | US | Oklahoma | Garvin | 40049 | 8180 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-19 04:21:03 | Garvin, Oklahoma, US | |
2022-12-18 | US | Michigan | Alpena | 26007 | 6357 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-19 04:21:03 | Alpena, Michigan, US | |
2022-12-18 | US | Iowa | Dallas | 19049 | 26347 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-19 04:21:03 | Dallas, Iowa, US | |
2022-12-17 | US | Oklahoma | Garvin | 40049 | 8180 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-18 04:21:03 | Garvin, Oklahoma, US | |
2022-12-17 | US | Michigan | Alpena | 26007 | 6357 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-18 04:21:03 | Alpena, Michigan, US | |
2022-12-17 | US | Iowa | Dallas | 19049 | 26347 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-18 04:21:03 | Dallas, Iowa, US | |
2022-12-16 | US | Oklahoma | Garvin | 40049 | 8180 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-17 04:21:04 | Garvin, Oklahoma, US | |
2022-12-16 | US | Michigan | Alpena | 26007 | 6357 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-17 04:21:04 | Alpena, Michigan, US | |
2022-12-16 | US | Iowa | Dallas | 19049 | 26347 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-17 04:21:04 | Dallas, Iowa, US | |
2022-12-15 | US | Oklahoma | Garvin | 40049 | 8180 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-16 04:21:01 | Garvin, Oklahoma, US | |
2022-12-15 | US | Michigan | Alpena | 26007 | 6357 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-16 04:21:01 | Alpena, Michigan, US | |
2022-12-15 | US | Iowa | Dallas | 19049 | 26347 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-16 04:21:01 | Dallas, Iowa, US | |
2022-12-14 | US | Oklahoma | Garvin | 40049 | 8131 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-15 04:20:58 | Garvin, Oklahoma, US | |
2022-12-14 | US | Michigan | Alpena | 26007 | 6357 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-15 04:20:58 | Alpena, Michigan, US | |
2022-12-14 | US | Iowa | Dallas | 19049 | 26347 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-15 04:20:58 | Dallas, Iowa, US | |
2022-12-13 | US | Oklahoma | Garvin | 40049 | 8131 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-14 04:21:04 | Garvin, Oklahoma, US | |
2022-12-13 | US | North Carolina | Alexander | 37003 | 12254 | 154 | 0 | 35.9223796 | -81.17751948 | 2022-12-14 04:21:04 | Alexander, North Carolina, US | |
2022-12-13 | US | Michigan | Alpena | 26007 | 6357 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-14 04:21:04 | Alpena, Michigan, US | |
2022-12-13 | US | Iowa | Dallas | 19049 | 26261 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-14 04:21:04 | Dallas, Iowa, US | |
2022-12-13 | US | Indiana | Harrison | 18061 | 12835 | 154 | 0 | 38.19467379 | -86.10948271 | 2022-12-14 04:21:04 | Harrison, Indiana, US | |
2022-12-12 | US | Oklahoma | Garvin | 40049 | 8131 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-13 04:21:01 | Garvin, Oklahoma, US | |
2022-12-12 | US | North Carolina | Alexander | 37003 | 12254 | 154 | 0 | 35.9223796 | -81.17751948 | 2022-12-13 04:21:01 | Alexander, North Carolina, US | |
2022-12-12 | US | Mississippi | Pontotoc | 28115 | 12196 | 154 | 0 | 34.226046 | -89.03636807 | 2022-12-13 04:21:01 | Pontotoc, Mississippi, US | |
2022-12-12 | US | Michigan | Alpena | 26007 | 6325 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-13 04:21:01 | Alpena, Michigan, US | |
2022-12-12 | US | Iowa | Dallas | 19049 | 26261 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-13 04:21:01 | Dallas, Iowa, US | |
2022-12-12 | US | Indiana | Harrison | 18061 | 12835 | 154 | 0 | 38.19467379 | -86.10948271 | 2022-12-13 04:21:01 | Harrison, Indiana, US | |
2022-12-11 | US | Oklahoma | Garvin | 40049 | 8131 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-12 04:21:01 | Garvin, Oklahoma, US | |
2022-12-11 | US | North Carolina | Alexander | 37003 | 12254 | 154 | 0 | 35.9223796 | -81.17751948 | 2022-12-12 04:21:01 | Alexander, North Carolina, US | |
2022-12-11 | US | Mississippi | Pontotoc | 28115 | 12196 | 154 | 0 | 34.226046 | -89.03636807 | 2022-12-12 04:21:01 | Pontotoc, Mississippi, US | |
2022-12-11 | US | Michigan | Alpena | 26007 | 6325 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-12 04:21:01 | Alpena, Michigan, US | |
2022-12-11 | US | Iowa | Dallas | 19049 | 26261 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-12 04:21:01 | Dallas, Iowa, US | |
2022-12-11 | US | Indiana | Harrison | 18061 | 12835 | 154 | 0 | 38.19467379 | -86.10948271 | 2022-12-12 04:21:01 | Harrison, Indiana, US | |
2022-12-10 | US | Oklahoma | Garvin | 40049 | 8131 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-11 04:20:50 | Garvin, Oklahoma, US | |
2022-12-10 | US | North Carolina | Alexander | 37003 | 12254 | 154 | 0 | 35.9223796 | -81.17751948 | 2022-12-11 04:20:50 | Alexander, North Carolina, US | |
2022-12-10 | US | Mississippi | Pontotoc | 28115 | 12196 | 154 | 0 | 34.226046 | -89.03636807 | 2022-12-11 04:20:50 | Pontotoc, Mississippi, US | |
2022-12-10 | US | Michigan | Alpena | 26007 | 6325 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-11 04:20:50 | Alpena, Michigan, US | |
2022-12-10 | US | Iowa | Dallas | 19049 | 26261 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-11 04:20:50 | Dallas, Iowa, US | |
2022-12-10 | US | Indiana | Harrison | 18061 | 12835 | 154 | 0 | 38.19467379 | -86.10948271 | 2022-12-11 04:20:50 | Harrison, Indiana, US | |
2022-12-09 | US | Oklahoma | Garvin | 40049 | 8131 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-10 04:21:02 | Garvin, Oklahoma, US | |
2022-12-09 | US | North Carolina | Alexander | 37003 | 12254 | 154 | 0 | 35.9223796 | -81.17751948 | 2022-12-10 04:21:02 | Alexander, North Carolina, US | |
2022-12-09 | US | Mississippi | Pontotoc | 28115 | 12196 | 154 | 0 | 34.226046 | -89.03636807 | 2022-12-10 04:21:02 | Pontotoc, Mississippi, US | |
2022-12-09 | US | Michigan | Alpena | 26007 | 6325 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-10 04:21:02 | Alpena, Michigan, US | |
2022-12-09 | US | Iowa | Dallas | 19049 | 26261 | 154 | 0 | 41.68560356 | -94.04127625 | 2022-12-10 04:21:02 | Dallas, Iowa, US | |
2022-12-09 | US | Indiana | Harrison | 18061 | 12835 | 154 | 0 | 38.19467379 | -86.10948271 | 2022-12-10 04:21:02 | Harrison, Indiana, US | |
2022-12-08 | US | Oklahoma | Garvin | 40049 | 8131 | 154 | 0 | 34.70418038 | -97.30811132 | 2022-12-09 04:21:05 | Garvin, Oklahoma, US | |
2022-12-08 | US | North Carolina | Alexander | 37003 | 12254 | 154 | 0 | 35.9223796 | -81.17751948 | 2022-12-09 04:21:05 | Alexander, North Carolina, US | |
2022-12-08 | US | Mississippi | Pontotoc | 28115 | 12196 | 154 | 0 | 34.226046 | -89.03636807 | 2022-12-09 04:21:05 | Pontotoc, Mississippi, US | |
2022-12-08 | US | Michigan | Alpena | 26007 | 6325 | 154 | 0 | 45.03477666 | -83.62212411 | 2022-12-09 04:21:05 | Alpena, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;