daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,461 rows where confirmed = 171 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 25
- US 1,067
- China 318
- Malaysia 13
- France 9
- Japan 9
- Australia 5
- Cambodia 5
- Russia 5
- Colombia 4
- Spain 3
- United Kingdom 3
- Guyana 2
- Mainland China 2
- Mali 2
- Saudi Arabia 2
- Ukraine 2
- Venezuela 2
- Estonia 1
- Iceland 1
- Mauritius 1
- Monaco 1
- Netherlands 1
- Peru 1
- Saint Lucia 1
- Serbia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-01 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-11-02 04:22:09 | Camas, Idaho, US | |
2022-10-31 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-11-01 04:22:36 | Camas, Idaho, US | |
2022-10-30 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-31 04:21:36 | Camas, Idaho, US | |
2022-10-29 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-30 04:22:14 | Camas, Idaho, US | |
2022-10-28 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-29 04:21:13 | Camas, Idaho, US | |
2022-10-27 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-28 04:22:31 | Camas, Idaho, US | |
2022-10-26 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-27 04:22:01 | Camas, Idaho, US | |
2022-10-25 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-26 04:22:19 | Camas, Idaho, US | |
2022-10-24 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-25 04:21:53 | Camas, Idaho, US | |
2022-10-23 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-24 04:22:29 | Camas, Idaho, US | |
2022-10-22 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-23 04:22:46 | Camas, Idaho, US | |
2022-10-21 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-22 04:22:53 | Camas, Idaho, US | |
2022-10-20 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-21 04:22:23 | Camas, Idaho, US | |
2022-10-19 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-20 04:22:59 | Camas, Idaho, US | |
2022-10-18 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-19 04:22:26 | Camas, Idaho, US | |
2022-10-17 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-18 04:22:42 | Camas, Idaho, US | |
2022-10-16 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-17 04:20:31 | Camas, Idaho, US | |
2022-10-15 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-16 04:22:39 | Camas, Idaho, US | |
2022-10-14 | US | Idaho | Camas | 16025 | 171 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-10-15 04:22:00 | Camas, Idaho, US | |
2022-09-26 | US | Colorado | Unassigned | 90008 | 171 | 2 | 0 | 40.87595412 | 0.0 | 2022-09-27 04:23:01 | Unassigned, Colorado, US | |
2022-09-25 | US | Colorado | Unassigned | 90008 | 171 | 2 | 0 | 40.87595412 | 0.0 | 2022-09-26 04:20:52 | Unassigned, Colorado, US | |
2022-09-24 | US | Colorado | Unassigned | 90008 | 171 | 2 | 0 | 40.87595412 | 0.0 | 2022-09-25 04:23:31 | Unassigned, Colorado, US | |
2022-09-23 | US | Colorado | Unassigned | 90008 | 171 | 2 | 0 | 40.87595412 | 0.0 | 2022-09-24 04:21:40 | Unassigned, Colorado, US | |
2022-09-22 | US | Colorado | Unassigned | 90008 | 171 | 2 | 0 | 40.87595412 | 0.0 | 2022-09-23 04:23:13 | Unassigned, Colorado, US | |
2022-09-20 | US | Colorado | Unassigned | 90008 | 171 | 2 | 0 | 40.87595412 | 0.0 | 2022-09-21 04:23:22 | Unassigned, Colorado, US | |
2022-08-23 | China | Qinghai | 171 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-24 04:20:46 | Qinghai, China | |||
2022-07-06 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-07 04:20:55 | McMullen, Texas, US | |
2022-07-05 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-06 04:20:58 | McMullen, Texas, US | |
2022-07-04 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-05 04:20:45 | McMullen, Texas, US | |
2022-07-03 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-04 04:20:54 | McMullen, Texas, US | |
2022-07-02 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-03 04:20:59 | McMullen, Texas, US | |
2022-07-01 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-02 04:21:16 | McMullen, Texas, US | |
2022-06-30 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-07-01 04:21:10 | McMullen, Texas, US | |
2022-06-29 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-06-30 04:21:01 | McMullen, Texas, US | |
2022-06-28 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-06-29 04:20:59 | McMullen, Texas, US | |
2022-06-27 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-06-28 04:20:58 | McMullen, Texas, US | |
2022-06-26 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-06-27 04:21:00 | McMullen, Texas, US | |
2022-06-25 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-06-26 04:21:02 | McMullen, Texas, US | |
2022-06-24 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-06-25 04:20:57 | McMullen, Texas, US | |
2022-06-23 | US | Texas | McMullen | 48311 | 171 | 9 | 0 | 28.35251708 | -98.56769164 | 2022-06-24 04:20:58 | McMullen, Texas, US | |
2022-05-30 | US | Colorado | Jackson | 8057 | 171 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-05-31 04:20:51 | Jackson, Colorado, US | |
2022-05-29 | US | Colorado | Jackson | 8057 | 171 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-05-30 04:20:50 | Jackson, Colorado, US | |
2022-05-28 | US | Colorado | Jackson | 8057 | 171 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-05-29 04:20:53 | Jackson, Colorado, US | |
2022-04-20 | US | Puerto Rico | Culebra | 72049 | 171 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-21 04:20:46 | Culebra, Puerto Rico, US | |
2022-04-03 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-04 04:20:51 | Loving, Texas, US | |
2022-04-02 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-03 04:20:48 | Loving, Texas, US | |
2022-04-01 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-02 04:20:47 | Loving, Texas, US | |
2022-03-31 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-01 04:20:28 | Loving, Texas, US | |
2022-03-30 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-03-31 04:20:56 | Loving, Texas, US | |
2022-03-29 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-03-30 04:20:45 | Loving, Texas, US | |
2022-03-28 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-03-29 04:20:46 | Loving, Texas, US | |
2022-03-27 | US | Texas | Loving | 48301 | 171 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-03-28 04:20:33 | Loving, Texas, US | |
2022-03-23 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-24 04:20:43 | Guizhou, China | |||
2022-03-22 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-23 04:20:48 | Guizhou, China | |||
2022-03-21 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-22 04:20:54 | Guizhou, China | |||
2022-03-20 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-21 04:20:50 | Guizhou, China | |||
2022-03-19 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-20 04:20:45 | Guizhou, China | |||
2022-03-18 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-19 04:20:47 | Guizhou, China | |||
2022-03-16 | United Kingdom | Montserrat | 171 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-03-17 04:20:56 | Montserrat, United Kingdom | |||
2022-03-15 | United Kingdom | Montserrat | 171 | 2 | 0 | 16.742498 | -62.187366000000004 | 2022-03-16 04:20:50 | Montserrat, United Kingdom | |||
2022-03-10 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-11 04:20:50 | Roberts, Texas, US | |
2022-03-09 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-10 04:20:48 | Roberts, Texas, US | |
2022-03-08 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-09 04:20:59 | Roberts, Texas, US | |
2022-03-07 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-08 04:20:54 | Roberts, Texas, US | |
2022-03-07 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-08 04:20:54 | Rock, Nebraska, US | |
2022-03-06 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-07 04:20:47 | Roberts, Texas, US | |
2022-03-06 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-07 04:20:47 | Rock, Nebraska, US | |
2022-03-05 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-06 04:20:49 | Roberts, Texas, US | |
2022-03-05 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-06 04:20:49 | Rock, Nebraska, US | |
2022-03-04 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-05 04:21:10 | Roberts, Texas, US | |
2022-03-04 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-05 04:21:10 | Rock, Nebraska, US | |
2022-03-03 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-04 04:21:09 | Roberts, Texas, US | |
2022-03-03 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-04 04:21:09 | Rock, Nebraska, US | |
2022-03-02 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-03 04:21:01 | Roberts, Texas, US | |
2022-03-02 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-03 04:21:01 | Rock, Nebraska, US | |
2022-03-01 | US | Texas | Roberts | 48393 | 171 | 2 | 0 | 35.83809685 | -100.813175 | 2022-03-02 04:21:07 | Roberts, Texas, US | |
2022-03-01 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-02 04:21:07 | Rock, Nebraska, US | |
2022-02-28 | US | Nebraska | Rock | 31149 | 171 | 2 | 0 | 42.42252217 | -99.44832069 | 2022-03-01 04:21:09 | Rock, Nebraska, US | |
2022-02-02 | US | South Dakota | Jones | 46075 | 171 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-02-03 04:21:21 | Jones, South Dakota, US | |
2022-02-01 | US | South Dakota | Jones | 46075 | 171 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-02-02 04:21:09 | Jones, South Dakota, US | |
2022-01-31 | US | South Dakota | Jones | 46075 | 171 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-02-01 04:21:11 | Jones, South Dakota, US | |
2022-01-16 | US | Texas | Kent | 48263 | 171 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-01-17 04:21:08 | Kent, Texas, US | |
2022-01-13 | US | Texas | Glasscock | 48173 | 171 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-01-14 04:21:54 | Glasscock, Texas, US | |
2022-01-12 | US | Texas | Throckmorton | 48447 | 171 | 7 | 0 | 33.17751417 | -99.21226795 | 2022-01-13 08:00:09 | Throckmorton, Texas, US | |
2022-01-12 | US | Colorado | San Juan | 8111 | 171 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-01-13 08:00:09 | San Juan, Colorado, US | |
2022-01-10 | US | South Dakota | Harding | 46063 | 171 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-01-11 04:22:01 | Harding, South Dakota, US | |
2022-01-03 | US | Montana | Garfield | 30033 | 171 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-04 04:22:17 | Garfield, Montana, US | |
2021-12-30 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-31 04:21:50 | Taliaferro, Georgia, US | |
2021-12-29 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-30 04:21:25 | Taliaferro, Georgia, US | |
2021-12-28 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-29 03:21:43 | Taliaferro, Georgia, US | |
2021-12-27 | US | South Dakota | Harding | 46063 | 171 | 3 | 0 | 45.58015551 | -103.4958629 | 2021-12-28 04:21:47 | Harding, South Dakota, US | |
2021-12-27 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-28 04:21:47 | Taliaferro, Georgia, US | |
2021-12-26 | US | South Dakota | Harding | 46063 | 171 | 3 | 0 | 45.58015551 | -103.4958629 | 2021-12-27 04:21:58 | Harding, South Dakota, US | |
2021-12-26 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-27 04:21:58 | Taliaferro, Georgia, US | |
2021-12-25 | US | South Dakota | Harding | 46063 | 171 | 3 | 0 | 45.58015551 | -103.4958629 | 2021-12-26 04:21:50 | Harding, South Dakota, US | |
2021-12-25 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-26 04:21:50 | Taliaferro, Georgia, US | |
2021-12-24 | US | South Dakota | Harding | 46063 | 171 | 3 | 0 | 45.58015551 | -103.4958629 | 2021-12-25 04:21:37 | Harding, South Dakota, US | |
2021-12-24 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-25 04:21:37 | Taliaferro, Georgia, US | |
2021-12-23 | US | South Dakota | Harding | 46063 | 171 | 3 | 0 | 45.58015551 | -103.4958629 | 2021-12-24 04:21:34 | Harding, South Dakota, US | |
2021-12-23 | US | Georgia | Taliaferro | 13265 | 171 | 3 | 0 | 33.56543317 | -82.88136816 | 2021-12-24 04:21:34 | Taliaferro, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;