daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,483 rows where confirmed = 55 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
- US 2,346
- Chile 27
- China 18
- Fiji 18
- France 14
- Canada 7
- Netherlands 7
- Uganda 5
- Colombia 4
- Japan 4
- Malaysia 4
- United Kingdom 4
- Mainland China 3
- Saint Vincent and the Grenadines 3
- Bahamas 2
- Denmark 2
- Gambia 2
- Guyana 2
- Albania 1
- Australia 1
- Bahrain 1
- Egypt 1
- Ethiopia 1
- Monaco 1
- Namibia 1
- New Zealand 1
- Oman 1
- Panama 1
- Serbia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-08-03 | New Zealand | Niue | 55 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-08-04 04:20:58 | Niue, New Zealand | ||
2022-05-18 | US | Maine | Unassigned | 90023 | 55 | 0 | 0 | 46.65926321 | 0.0 | 2022-05-19 04:20:54 | Unassigned, Maine, US | |
2022-04-25 | Netherlands | Unknown | 55 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
2022-04-24 | Netherlands | Unknown | 55 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
2022-04-23 | Netherlands | Unknown | 55 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
2022-04-22 | Netherlands | Unknown | 55 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
2022-01-09 | US | Nebraska | Blaine | 31009 | 55 | 0 | 0 | 41.91311716 | -99.97677845 | 2022-01-10 04:22:07 | Blaine, Nebraska, US | |
2022-01-08 | US | Nebraska | Blaine | 31009 | 55 | 0 | 0 | 41.91311716 | -99.97677845 | 2022-01-09 04:21:46 | Blaine, Nebraska, US | |
2022-01-07 | US | Nebraska | Blaine | 31009 | 55 | 0 | 0 | 41.91311716 | -99.97677845 | 2022-01-08 04:21:53 | Blaine, Nebraska, US | |
2022-01-06 | US | Nebraska | Blaine | 31009 | 55 | 0 | 0 | 41.91311716 | -99.97677845 | 2022-01-07 04:22:09 | Blaine, Nebraska, US | |
2021-12-27 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-28 04:21:47 | Slope, North Dakota, US | |
2021-12-26 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-27 04:21:58 | Slope, North Dakota, US | |
2021-12-25 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-26 04:21:50 | Slope, North Dakota, US | |
2021-12-24 | US | Puerto Rico | Culebra | 72049 | 55 | 0 | 0 | 18.31586 | -65.28813000000001 | 2021-12-25 04:21:37 | Culebra, Puerto Rico, US | |
2021-12-24 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-25 04:21:37 | Slope, North Dakota, US | |
2021-12-23 | US | Puerto Rico | Culebra | 72049 | 55 | 0 | 0 | 18.31586 | -65.28813000000001 | 2021-12-24 04:21:34 | Culebra, Puerto Rico, US | |
2021-12-23 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-24 04:21:34 | Slope, North Dakota, US | |
2021-12-22 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-23 04:21:21 | Slope, North Dakota, US | |
2021-12-22 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-23 04:21:21 | Harding, New Mexico, US | |
2021-12-21 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-22 04:21:54 | Slope, North Dakota, US | |
2021-12-21 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-22 04:21:54 | Harding, New Mexico, US | |
2021-12-20 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-21 03:21:27 | Slope, North Dakota, US | |
2021-12-20 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-21 03:21:27 | Harding, New Mexico, US | |
2021-12-19 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-20 04:21:43 | Slope, North Dakota, US | |
2021-12-19 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-20 04:21:43 | Harding, New Mexico, US | |
2021-12-18 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-19 04:21:11 | Slope, North Dakota, US | |
2021-12-18 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-19 04:21:11 | Harding, New Mexico, US | |
2021-12-17 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-18 02:22:20 | Slope, North Dakota, US | |
2021-12-17 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-18 02:22:20 | Harding, New Mexico, US | |
2021-12-16 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-17 04:22:14 | Slope, North Dakota, US | |
2021-12-16 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-17 04:22:14 | Harding, New Mexico, US | |
2021-12-15 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-16 04:22:11 | Slope, North Dakota, US | |
2021-12-15 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-16 04:22:11 | Harding, New Mexico, US | |
2021-12-14 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-15 03:22:16 | Slope, North Dakota, US | |
2021-12-14 | US | New Mexico | Harding | 35021 | 55 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2021-12-15 03:22:16 | Harding, New Mexico, US | |
2021-12-13 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-14 04:22:38 | Slope, North Dakota, US | |
2021-12-12 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-13 04:22:02 | Slope, North Dakota, US | |
2021-12-11 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-12 04:22:12 | Slope, North Dakota, US | |
2021-12-10 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-11 04:22:45 | Slope, North Dakota, US | |
2021-12-09 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-10 04:22:28 | Slope, North Dakota, US | |
2021-12-08 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-09 04:22:49 | Slope, North Dakota, US | |
2021-12-07 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-08 04:22:46 | Slope, North Dakota, US | |
2021-12-06 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-07 04:22:34 | Slope, North Dakota, US | |
2021-12-05 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-06 04:22:34 | Slope, North Dakota, US | |
2021-12-04 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-05 04:22:25 | Slope, North Dakota, US | |
2021-12-03 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-04 04:22:18 | Slope, North Dakota, US | |
2021-12-02 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-03 04:23:05 | Slope, North Dakota, US | |
2021-12-01 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-02 04:22:37 | Slope, North Dakota, US | |
2021-11-30 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-12-01 04:22:29 | Slope, North Dakota, US | |
2021-11-29 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-30 04:22:53 | Slope, North Dakota, US | |
2021-11-28 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-29 04:22:30 | Slope, North Dakota, US | |
2021-11-27 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-28 04:22:43 | Slope, North Dakota, US | |
2021-11-26 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-27 04:22:45 | Slope, North Dakota, US | |
2021-11-25 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-26 04:22:33 | Slope, North Dakota, US | |
2021-11-24 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-25 04:22:33 | Slope, North Dakota, US | |
2021-11-23 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-24 04:22:14 | Slope, North Dakota, US | |
2021-11-22 | US | North Dakota | Slope | 38087 | 55 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-11-23 04:22:39 | Slope, North Dakota, US | |
2021-11-02 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-11-03 06:22:09 | Sioux, Nebraska, US | |
2021-11-01 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-11-02 04:22:03 | Sioux, Nebraska, US | |
2021-10-31 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-11-01 04:22:01 | Sioux, Nebraska, US | |
2021-10-30 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-31 04:22:08 | Sioux, Nebraska, US | |
2021-10-29 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-30 04:22:03 | Sioux, Nebraska, US | |
2021-10-28 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-29 04:22:03 | Sioux, Nebraska, US | |
2021-10-27 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-28 04:22:08 | Sioux, Nebraska, US | |
2021-10-26 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-27 04:22:32 | Sioux, Nebraska, US | |
2021-10-25 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-26 04:22:09 | Sioux, Nebraska, US | |
2021-10-24 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-25 04:22:31 | Sioux, Nebraska, US | |
2021-10-23 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-24 04:21:22 | Sioux, Nebraska, US | |
2021-10-22 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-23 04:21:32 | Sioux, Nebraska, US | |
2021-10-21 | US | Nebraska | Sioux | 31165 | 55 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-10-22 04:21:14 | Sioux, Nebraska, US | |
2021-10-13 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-14 04:21:29 | Hinsdale, Colorado, US | |
2021-10-12 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-13 04:20:51 | Hinsdale, Colorado, US | |
2021-10-11 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-12 04:21:09 | Hinsdale, Colorado, US | |
2021-10-10 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-11 04:21:31 | Hinsdale, Colorado, US | |
2021-10-09 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-10 04:21:38 | Hinsdale, Colorado, US | |
2021-10-08 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-09 04:21:34 | Hinsdale, Colorado, US | |
2021-10-07 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-08 04:21:25 | Hinsdale, Colorado, US | |
2021-10-06 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-07 04:21:36 | Hinsdale, Colorado, US | |
2021-10-05 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-06 04:21:33 | Hinsdale, Colorado, US | |
2021-10-04 | US | Colorado | Hinsdale | 8053 | 55 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-10-05 04:21:27 | Hinsdale, Colorado, US | |
2021-09-28 | US | Nebraska | Grant | 31075 | 55 | 4 | 0 | 41.91528587 | -101.740701 | 2021-09-29 04:21:45 | Grant, Nebraska, US | |
2021-09-26 | US | North Carolina | Unassigned | 90037 | 55 | 0 | 0 | 36.49360862 | 0.0 | 2021-09-27 04:21:16 | Unassigned, North Carolina, US | |
2021-09-26 | US | Nebraska | Wheeler | 31183 | 55 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-09-27 04:21:16 | Wheeler, Nebraska, US | |
2021-09-25 | US | North Carolina | Unassigned | 90037 | 55 | 0 | 0 | 36.49360862 | 0.0 | 2021-09-26 04:21:29 | Unassigned, North Carolina, US | |
2021-09-25 | US | Nebraska | Wheeler | 31183 | 55 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-09-26 04:21:29 | Wheeler, Nebraska, US | |
2021-09-24 | US | North Carolina | Unassigned | 90037 | 55 | 0 | 0 | 36.49360862 | 0.0 | 2021-09-25 04:21:31 | Unassigned, North Carolina, US | |
2021-09-02 | US | Texas | Kenedy | 48261 | 55 | 2 | 0 | 26.92601662 | -97.66413984 | 2021-09-03 04:21:20 | Kenedy, Texas, US | |
2021-09-01 | US | Texas | Kenedy | 48261 | 55 | 2 | 0 | 26.92601662 | -97.66413984 | 2021-09-02 04:21:15 | Kenedy, Texas, US | |
2021-08-11 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.26665159999999 | 2021-08-12 04:21:25 | Treasure, Montana, US | |
2021-08-10 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.26665159999999 | 2021-08-11 04:21:58 | Treasure, Montana, US | |
2021-08-09 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.26665159999999 | 2021-08-10 04:21:27 | Treasure, Montana, US | |
2021-08-08 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.2666516 | 2021-08-09 04:21:24 | Treasure, Montana, US | |
2021-08-07 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.2666516 | 2021-08-08 04:21:33 | Treasure, Montana, US | |
2021-08-06 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.2666516 | 2021-08-07 04:21:30 | Treasure, Montana, US | |
2021-08-05 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.2666516 | 2021-08-06 04:21:18 | Treasure, Montana, US | |
2021-08-04 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.2666516 | 2021-08-05 04:21:51 | Treasure, Montana, US | |
2021-08-03 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.2666516 | 2021-08-04 04:21:25 | Treasure, Montana, US | |
2021-08-03 | US | Colorado | San Juan | 8111 | 55 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-08-04 04:21:25 | San Juan, Colorado, US | |
2021-08-02 | US | Montana | Treasure | 30103 | 55 | 1 | 0 | 46.20973220000001 | -107.2666516 | 2021-08-03 04:21:39 | Treasure, Montana, US | |
2021-08-02 | US | Illinois | Unassigned | 90017 | 55 | 2475 | 0 | 42.36542373 | 0.0 | 2021-08-03 04:21:39 | Unassigned, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;