daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
617 rows where confirmed = 866 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 562
- China 24
- Bhutan 8
- Australia 5
- Chad 4
- Japan 3
- Netherlands 3
- Sweden 2
- Bolivia 1
- Costa Rica 1
- India 1
- Seychelles 1
- Vietnam 1
- Zambia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-20 | US | Texas | Kimble | 48267 | 866 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-12-21 04:21:03 | Kimble, Texas, US | |
2022-12-19 | US | Texas | Kimble | 48267 | 866 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-12-20 04:21:04 | Kimble, Texas, US | |
2022-12-18 | US | Texas | Kimble | 48267 | 866 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-12-19 04:21:03 | Kimble, Texas, US | |
2022-12-17 | US | Texas | Kimble | 48267 | 866 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-12-18 04:21:03 | Kimble, Texas, US | |
2022-12-16 | US | Texas | Kimble | 48267 | 866 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-12-17 04:21:04 | Kimble, Texas, US | |
2022-12-15 | US | Texas | Kimble | 48267 | 866 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-12-16 04:21:01 | Kimble, Texas, US | |
2022-12-14 | US | Texas | Kimble | 48267 | 866 | 15 | 0 | 30.48678918 | -99.74856473 | 2022-12-15 04:20:58 | Kimble, Texas, US | |
2022-11-29 | US | Kansas | Ness | 20135 | 866 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-11-30 04:21:07 | Ness, Kansas, US | |
2022-11-28 | US | Kansas | Ness | 20135 | 866 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-11-29 04:21:05 | Ness, Kansas, US | |
2022-11-27 | US | Kansas | Ness | 20135 | 866 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-11-28 04:21:02 | Ness, Kansas, US | |
2022-11-26 | US | Kansas | Ness | 20135 | 866 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-11-27 04:21:05 | Ness, Kansas, US | |
2022-11-25 | US | Kansas | Ness | 20135 | 866 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-11-26 04:21:11 | Ness, Kansas, US | |
2022-11-24 | US | Kansas | Ness | 20135 | 866 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-11-25 04:21:06 | Ness, Kansas, US | |
2022-11-23 | US | Kansas | Ness | 20135 | 866 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-11-24 04:21:09 | Ness, Kansas, US | |
2022-11-15 | US | Kansas | Trego | 20195 | 866 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-16 04:21:09 | Trego, Kansas, US | |
2022-11-14 | US | Kansas | Trego | 20195 | 866 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-15 04:21:16 | Trego, Kansas, US | |
2022-11-13 | US | Kansas | Trego | 20195 | 866 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-14 04:21:09 | Trego, Kansas, US | |
2022-11-12 | US | Kansas | Trego | 20195 | 866 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-13 04:21:14 | Trego, Kansas, US | |
2022-11-11 | US | Kansas | Trego | 20195 | 866 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-12 04:20:41 | Trego, Kansas, US | |
2022-11-10 | US | Kansas | Trego | 20195 | 866 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-11 04:21:22 | Trego, Kansas, US | |
2022-11-09 | US | Kansas | Trego | 20195 | 866 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-10 04:21:16 | Trego, Kansas, US | |
2022-11-01 | US | Kansas | Sheridan | 20179 | 866 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-02 04:22:09 | Sheridan, Kansas, US | |
2022-10-31 | US | Kansas | Sheridan | 20179 | 866 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-01 04:22:36 | Sheridan, Kansas, US | |
2022-10-30 | US | Kansas | Sheridan | 20179 | 866 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-10-31 04:21:36 | Sheridan, Kansas, US | |
2022-10-29 | US | Kansas | Sheridan | 20179 | 866 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-10-30 04:22:14 | Sheridan, Kansas, US | |
2022-10-28 | US | Kansas | Sheridan | 20179 | 866 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-10-29 04:21:13 | Sheridan, Kansas, US | |
2022-10-27 | US | Kansas | Sheridan | 20179 | 866 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-10-28 04:22:31 | Sheridan, Kansas, US | |
2022-10-26 | US | Kansas | Sheridan | 20179 | 866 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-10-27 04:22:01 | Sheridan, Kansas, US | |
2022-10-23 | US | North Dakota | Nelson | 38063 | 866 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-10-24 04:22:29 | Nelson, North Dakota, US | |
2022-09-13 | US | South Dakota | Marshall | 46091 | 866 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-14 04:20:44 | Marshall, South Dakota, US | |
2022-09-12 | US | South Dakota | Marshall | 46091 | 866 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-13 04:20:57 | Marshall, South Dakota, US | |
2022-09-11 | US | South Dakota | Marshall | 46091 | 866 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-12 04:20:58 | Marshall, South Dakota, US | |
2022-09-10 | US | South Dakota | Marshall | 46091 | 866 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-11 04:20:50 | Marshall, South Dakota, US | |
2022-09-09 | US | South Dakota | Marshall | 46091 | 866 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-10 04:21:10 | Marshall, South Dakota, US | |
2022-09-08 | US | South Dakota | Marshall | 46091 | 866 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-09 04:21:11 | Marshall, South Dakota, US | |
2022-09-07 | US | South Dakota | Marshall | 46091 | 866 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-08 04:21:02 | Marshall, South Dakota, US | |
2022-08-16 | US | Idaho | Oneida | 16071 | 866 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-08-17 04:20:59 | Oneida, Idaho, US | |
2022-08-15 | US | Idaho | Oneida | 16071 | 866 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-08-16 04:20:58 | Oneida, Idaho, US | |
2022-08-14 | US | Idaho | Oneida | 16071 | 866 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-08-15 04:20:59 | Oneida, Idaho, US | |
2022-08-13 | US | Idaho | Oneida | 16071 | 866 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-08-14 04:20:55 | Oneida, Idaho, US | |
2022-08-12 | US | Idaho | Oneida | 16071 | 866 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-08-13 04:20:52 | Oneida, Idaho, US | |
2022-08-03 | US | Texas | Sutton | 48435 | 866 | 13 | 0 | 30.49856623 | -100.5382014 | 2022-08-04 04:20:58 | Sutton, Texas, US | |
2022-08-02 | US | Texas | Sutton | 48435 | 866 | 13 | 0 | 30.49856623 | -100.5382014 | 2022-08-03 04:20:59 | Sutton, Texas, US | |
2022-08-01 | US | Texas | Sutton | 48435 | 866 | 13 | 0 | 30.49856623 | -100.5382014 | 2022-08-02 04:20:53 | Sutton, Texas, US | |
2022-07-31 | US | Texas | Sutton | 48435 | 866 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-08-01 04:21:03 | Sutton, Texas, US | |
2022-07-30 | US | Texas | Sutton | 48435 | 866 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-07-31 04:21:02 | Sutton, Texas, US | |
2022-07-29 | US | Texas | Sutton | 48435 | 866 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-07-30 04:20:42 | Sutton, Texas, US | |
2022-07-28 | US | Texas | Sutton | 48435 | 866 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-07-29 04:20:45 | Sutton, Texas, US | |
2022-07-27 | US | Texas | Sutton | 48435 | 866 | 12 | 0 | 30.49856623 | -100.5382014 | 2022-07-28 04:20:56 | Sutton, Texas, US | |
2022-07-13 | US | North Dakota | Bowman | 38011 | 866 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-07-14 04:20:57 | Bowman, North Dakota, US | |
2022-07-10 | US | North Dakota | Cavalier | 38019 | 866 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-07-11 04:20:46 | Cavalier, North Dakota, US | |
2022-07-09 | US | North Dakota | Cavalier | 38019 | 866 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-07-10 04:20:54 | Cavalier, North Dakota, US | |
2022-07-08 | US | North Dakota | Cavalier | 38019 | 866 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-07-09 04:20:59 | Cavalier, North Dakota, US | |
2022-07-07 | US | Texas | Real | 48385 | 866 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-07-08 04:20:56 | Real, Texas, US | |
2022-07-07 | US | North Dakota | Cavalier | 38019 | 866 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-07-08 04:20:56 | Cavalier, North Dakota, US | |
2022-06-21 | US | Texas | Coke | 48081 | 866 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-06-22 04:20:54 | Coke, Texas, US | |
2022-06-20 | US | Texas | Coke | 48081 | 866 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-06-21 04:20:56 | Coke, Texas, US | |
2022-06-19 | US | Texas | Coke | 48081 | 866 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-06-20 04:21:01 | Coke, Texas, US | |
2022-06-05 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-06-06 04:20:57 | Reagan, Texas, US | |
2022-06-04 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-06-05 04:20:55 | Reagan, Texas, US | |
2022-06-03 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-06-04 04:20:58 | Reagan, Texas, US | |
2022-06-02 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-06-03 04:20:58 | Reagan, Texas, US | |
2022-06-01 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-06-02 05:20:39 | Reagan, Texas, US | |
2022-05-31 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-06-01 04:20:55 | Reagan, Texas, US | |
2022-05-30 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-31 04:20:51 | Reagan, Texas, US | |
2022-05-29 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-30 04:20:50 | Reagan, Texas, US | |
2022-05-28 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-29 04:20:53 | Reagan, Texas, US | |
2022-05-27 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-28 04:21:07 | Reagan, Texas, US | |
2022-05-26 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-27 04:20:56 | Reagan, Texas, US | |
2022-05-25 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-26 04:20:50 | Reagan, Texas, US | |
2022-05-22 | US | Texas | Reagan | 48383 | 866 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-05-26 04:20:50 | Reagan, Texas, US | |
2022-05-21 | US | Colorado | Baca | 8009 | 866 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-22 04:20:52 | Baca, Colorado, US | |
2022-05-20 | US | Colorado | Baca | 8009 | 866 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-21 04:20:58 | Baca, Colorado, US | |
2022-05-19 | US | Colorado | Baca | 8009 | 866 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-20 04:20:57 | Baca, Colorado, US | |
2022-05-18 | US | Colorado | Baca | 8009 | 866 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-19 04:20:54 | Baca, Colorado, US | |
2022-05-17 | US | Colorado | Baca | 8009 | 866 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-18 04:20:50 | Baca, Colorado, US | |
2022-05-16 | US | Colorado | Baca | 8009 | 866 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-17 04:20:59 | Baca, Colorado, US | |
2022-05-15 | US | Colorado | Baca | 8009 | 866 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-05-16 04:20:47 | Baca, Colorado, US | |
2022-04-28 | US | Delaware | Unassigned | 90010 | 866 | 0 | 0 | 39.57992638 | 0.0 | 2022-04-29 04:20:59 | Unassigned, Delaware, US | |
2022-04-10 | US | Kentucky | Hickman | 21105 | 866 | 25 | 0 | 36.67948079999999 | -88.97875928 | 2022-04-11 04:21:02 | Hickman, Kentucky, US | |
2022-04-09 | US | Kentucky | Hickman | 21105 | 866 | 25 | 0 | 36.67948079999999 | -88.97875928 | 2022-04-10 04:20:52 | Hickman, Kentucky, US | |
2022-04-08 | US | Kentucky | Hickman | 21105 | 866 | 25 | 0 | 36.67948079999999 | -88.97875928 | 2022-04-09 04:20:42 | Hickman, Kentucky, US | |
2022-04-07 | US | Kentucky | Hickman | 21105 | 866 | 25 | 0 | 36.67948079999999 | -88.97875928 | 2022-04-08 04:20:48 | Hickman, Kentucky, US | |
2022-04-06 | US | Kentucky | Hickman | 21105 | 866 | 25 | 0 | 36.67948079999999 | -88.97875928 | 2022-04-07 04:20:53 | Hickman, Kentucky, US | |
2022-04-05 | US | Kentucky | Hickman | 21105 | 866 | 25 | 0 | 36.67948079999999 | -88.97875928 | 2022-04-06 04:20:49 | Hickman, Kentucky, US | |
2022-04-04 | US | Kentucky | Hickman | 21105 | 866 | 25 | 0 | 36.67948079999999 | -88.97875928 | 2022-04-05 04:20:48 | Hickman, Kentucky, US | |
2022-03-23 | US | Oklahoma | Roger Mills | 40129 | 866 | 15 | 0 | 35.68711719 | -99.69666167 | 2022-03-24 04:20:43 | Roger Mills, Oklahoma, US | |
2022-03-22 | US | Oklahoma | Roger Mills | 40129 | 866 | 15 | 0 | 35.68711719 | -99.69666167 | 2022-03-23 04:20:48 | Roger Mills, Oklahoma, US | |
2022-03-21 | US | Oklahoma | Roger Mills | 40129 | 866 | 15 | 0 | 35.68711719 | -99.69666167 | 2022-03-22 04:20:54 | Roger Mills, Oklahoma, US | |
2022-03-20 | US | Oklahoma | Roger Mills | 40129 | 866 | 15 | 0 | 35.68711719 | -99.69666167 | 2022-03-21 04:20:50 | Roger Mills, Oklahoma, US | |
2022-03-19 | US | Oklahoma | Roger Mills | 40129 | 866 | 15 | 0 | 35.68711719 | -99.69666167 | 2022-03-20 04:20:45 | Roger Mills, Oklahoma, US | |
2022-03-18 | US | Oklahoma | Roger Mills | 40129 | 866 | 15 | 0 | 35.68711719 | -99.69666167 | 2022-03-19 04:20:47 | Roger Mills, Oklahoma, US | |
2022-03-17 | US | Oklahoma | Roger Mills | 40129 | 866 | 15 | 0 | 35.68711719 | -99.69666167 | 2022-03-18 04:20:55 | Roger Mills, Oklahoma, US | |
2022-03-03 | US | Nebraska | Johnson | 31097 | 866 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-03-04 04:21:09 | Johnson, Nebraska, US | |
2022-03-02 | US | Nebraska | Johnson | 31097 | 866 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-03-03 04:21:01 | Johnson, Nebraska, US | |
2022-02-23 | US | Vermont | Grand Isle | 50013 | 866 | 4 | 0 | 44.797582399999996 | -73.29679772 | 2022-02-24 04:21:14 | Grand Isle, Vermont, US | |
2022-02-21 | US | Virginia | Bath | 51017 | 866 | 18 | 0 | 38.05852573 | -79.73912095 | 2022-02-22 04:21:01 | Bath, Virginia, US | |
2022-02-11 | US | Colorado | Ouray | 8091 | 866 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-02-12 04:21:06 | Ouray, Colorado, US | |
2022-02-06 | US | Nebraska | Johnson | 31097 | 866 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-02-07 04:21:05 | Johnson, Nebraska, US | |
2022-02-05 | US | Nebraska | Johnson | 31097 | 866 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-02-06 04:21:00 | Johnson, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;