daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,133 rows where confirmed = 194 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,003
- China 47
- United Kingdom 19
- Japan 17
- Malaysia 11
- Canada 8
- Dominica 5
- Mongolia 3
- Colombia 2
- India 2
- Ukraine 2
- Armenia 1
- Bahamas 1
- Bolivia 1
- Cote d'Ivoire 1
- Ethiopia 1
- Guinea 1
- Mainland China 1
- Mexico 1
- Mozambique 1
- Peru 1
- Russia 1
- South Sudan 1
- Trinidad and Tobago 1
- West Bank and Gaza 1
| day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-12-29 | US | Texas | Roberts | 48393 | 194 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-30 04:21:04 | Roberts, Texas, US | |
| 2022-12-28 | US | Texas | Roberts | 48393 | 194 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-29 04:21:01 | Roberts, Texas, US | |
| 2022-12-28 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-29 04:21:01 | Jackson, Colorado, US | |
| 2022-12-27 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-28 04:21:04 | Jackson, Colorado, US | |
| 2022-12-26 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-27 04:21:07 | Jackson, Colorado, US | |
| 2022-12-25 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-26 04:21:06 | Jackson, Colorado, US | |
| 2022-12-24 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-25 04:21:04 | Jackson, Colorado, US | |
| 2022-12-23 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-24 04:21:02 | Jackson, Colorado, US | |
| 2022-12-22 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-23 04:21:04 | Jackson, Colorado, US | |
| 2022-12-21 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-22 04:20:56 | Jackson, Colorado, US | |
| 2022-12-20 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-21 04:21:03 | Jackson, Colorado, US | |
| 2022-12-19 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-20 04:21:04 | Jackson, Colorado, US | |
| 2022-12-18 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-19 04:21:03 | Jackson, Colorado, US | |
| 2022-12-17 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-18 04:21:03 | Jackson, Colorado, US | |
| 2022-12-16 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-17 04:21:04 | Jackson, Colorado, US | |
| 2022-12-15 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-16 04:21:01 | Jackson, Colorado, US | |
| 2022-12-14 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-15 04:20:58 | Jackson, Colorado, US | |
| 2022-12-13 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-14 04:21:04 | Jackson, Colorado, US | |
| 2022-12-06 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-07 04:20:58 | Jackson, Colorado, US | |
| 2022-12-05 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-06 04:21:03 | Jackson, Colorado, US | |
| 2022-12-04 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-05 04:20:58 | Jackson, Colorado, US | |
| 2022-12-03 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-04 04:20:56 | Jackson, Colorado, US | |
| 2022-12-02 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-03 04:21:02 | Jackson, Colorado, US | |
| 2022-12-01 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-02 04:21:07 | Jackson, Colorado, US | |
| 2022-11-30 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-01 04:21:03 | Jackson, Colorado, US | |
| 2022-11-29 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-30 04:21:07 | Jackson, Colorado, US | |
| 2022-11-28 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-29 04:21:05 | Jackson, Colorado, US | |
| 2022-11-22 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-23 04:21:06 | Unassigned, Colorado, US | |
| 2022-11-21 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-22 04:20:47 | Unassigned, Colorado, US | |
| 2022-11-20 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-21 04:21:05 | Unassigned, Colorado, US | |
| 2022-11-19 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-20 04:21:08 | Unassigned, Colorado, US | |
| 2022-11-18 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-19 04:21:14 | Unassigned, Colorado, US | |
| 2022-11-17 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-18 04:21:15 | Unassigned, Colorado, US | |
| 2022-11-16 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-17 04:21:11 | Unassigned, Colorado, US | |
| 2022-09-01 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-02 04:21:07 | Guizhou, China | |||
| 2022-08-31 | China | Qinghai | 194 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-01 04:21:03 | Qinghai, China | |||
| 2022-08-31 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-01 04:21:03 | Guizhou, China | |||
| 2022-08-30 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-31 04:20:57 | Guizhou, China | |||
| 2022-08-29 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-30 04:21:03 | Guizhou, China | |||
| 2022-08-28 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-29 04:21:06 | Guizhou, China | |||
| 2022-08-27 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-28 04:21:02 | Guizhou, China | |||
| 2022-08-26 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-27 04:20:57 | Guizhou, China | |||
| 2022-05-08 | US | Texas | Loving | 48301 | 194 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-09 04:20:54 | Loving, Texas, US | |
| 2022-03-29 | China | Hainan | 194 | 6 | 0 | 19.1959 | 109.7453 | 2022-03-30 04:20:45 | Hainan, China | |||
| 2022-02-11 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-12 04:21:06 | Glasscock, Texas, US | |
| 2022-02-10 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-11 04:21:09 | Glasscock, Texas, US | |
| 2022-02-09 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-10 04:21:14 | Glasscock, Texas, US | |
| 2022-02-08 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-09 04:21:04 | Glasscock, Texas, US | |
| 2022-02-07 | US | Illinois | Unassigned | 90017 | 194 | 3861 | 0 | 42.36542373 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Illinois, US | |
| 2022-02-05 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-06 04:21:00 | Foard, Texas, US | |
| 2022-02-04 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-05 04:21:05 | Foard, Texas, US | |
| 2022-02-03 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-04 04:21:10 | Foard, Texas, US | |
| 2022-02-02 | US | Texas | Kent | 48263 | 194 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-02-03 04:21:21 | Kent, Texas, US | |
| 2022-02-02 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-03 04:21:21 | Foard, Texas, US | |
| 2022-02-01 | US | Texas | Kent | 48263 | 194 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-02-02 04:21:09 | Kent, Texas, US | |
| 2022-02-01 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-02 04:21:09 | Foard, Texas, US | |
| 2022-01-18 | US | Montana | Garfield | 30033 | 194 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-19 04:21:23 | Garfield, Montana, US | |
| 2021-12-28 | US | Oregon | Gilliam | 41021 | 194 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2021-12-29 03:21:43 | Gilliam, Oregon, US | |
| 2021-12-22 | US | Montana | Prairie | 30079 | 194 | 2 | 0 | 46.86048047 | -105.379384 | 2021-12-23 04:21:21 | Prairie, Montana, US | |
| 2021-12-21 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-22 04:21:54 | Irion, Texas, US | |
| 2021-12-21 | US | Montana | Prairie | 30079 | 194 | 2 | 0 | 46.86048047 | -105.379384 | 2021-12-22 04:21:54 | Prairie, Montana, US | |
| 2021-12-20 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-21 03:21:27 | Irion, Texas, US | |
| 2021-12-19 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-20 04:21:43 | Irion, Texas, US | |
| 2021-12-18 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-19 04:21:11 | Irion, Texas, US | |
| 2021-12-15 | US | South Dakota | Sully | 46119 | 194 | 3 | 0 | 44.71571812 | -100.1278092 | 2021-12-16 04:22:11 | Sully, South Dakota, US | |
| 2021-11-30 | US | Virginia | Highland | 51091 | 194 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-01 04:22:29 | Highland, Virginia, US | |
| 2021-11-24 | US | Puerto Rico | Vieques | 72147 | 194 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-11-25 04:22:33 | Vieques, Puerto Rico, US | |
| 2021-11-23 | US | Puerto Rico | Vieques | 72147 | 194 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-11-24 04:22:14 | Vieques, Puerto Rico, US | |
| 2021-11-22 | US | Puerto Rico | Vieques | 72147 | 194 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-11-23 04:22:39 | Vieques, Puerto Rico, US | |
| 2021-11-21 | US | Puerto Rico | Vieques | 72147 | 194 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-11-22 04:22:20 | Vieques, Puerto Rico, US | |
| 2021-11-20 | US | Puerto Rico | Vieques | 72147 | 194 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-11-21 04:22:13 | Vieques, Puerto Rico, US | |
| 2021-11-19 | US | Puerto Rico | Vieques | 72147 | 194 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-11-20 04:22:17 | Vieques, Puerto Rico, US | |
| 2021-11-16 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-17 04:21:48 | Issaquena, Mississippi, US | |
| 2021-11-15 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-16 04:21:10 | Issaquena, Mississippi, US | |
| 2021-11-14 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-15 04:21:36 | Issaquena, Mississippi, US | |
| 2021-11-13 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-14 04:21:31 | Issaquena, Mississippi, US | |
| 2021-11-12 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-13 04:21:38 | Issaquena, Mississippi, US | |
| 2021-11-11 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-12 04:22:01 | Issaquena, Mississippi, US | |
| 2021-11-10 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-11 04:21:45 | Issaquena, Mississippi, US | |
| 2021-11-09 | US | South Dakota | Hyde | 46069 | 194 | 3 | 0 | 44.54747703 | -99.48572582 | 2021-11-10 04:21:38 | Hyde, South Dakota, US | |
| 2021-11-09 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-10 04:21:38 | Issaquena, Mississippi, US | |
| 2021-11-08 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-09 04:21:36 | Issaquena, Mississippi, US | |
| 2021-10-15 | US | Texas | Jeff Davis | 48243 | 194 | 6 | 0 | 30.71490589 | -104.1399973 | 2021-10-16 04:21:15 | Jeff Davis, Texas, US | |
| 2021-10-12 | US | California | Unassigned | 90006 | 194 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-13 04:20:51 | Unassigned, California, US | |
| 2021-10-06 | US | North Dakota | Oliver | 38065 | 194 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-10-07 04:21:36 | Oliver, North Dakota, US | |
| 2021-10-05 | US | North Dakota | Oliver | 38065 | 194 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-10-06 04:21:33 | Oliver, North Dakota, US | |
| 2021-09-28 | US | Texas | Stonewall | 48433 | 194 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-09-29 04:21:45 | Stonewall, Texas, US | |
| 2021-09-26 | US | Colorado | Dolores | 8033 | 194 | 1 | 0 | 37.75208676 | -108.5211585 | 2021-09-27 04:21:16 | Dolores, Colorado, US | |
| 2021-09-23 | US | Montana | Meagher | 30059 | 194 | 7 | 0 | 46.59907074 | -110.8898557 | 2021-09-24 04:21:44 | Meagher, Montana, US | |
| 2021-09-21 | US | Washington | Garfield | 53023 | 194 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2021-09-22 04:21:45 | Garfield, Washington, US | |
| 2021-09-12 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-13 04:21:15 | Denali, Alaska, US | |
| 2021-09-11 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-12 04:21:13 | Denali, Alaska, US | |
| 2021-09-10 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-11 04:21:30 | Denali, Alaska, US | |
| 2021-09-09 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-10 04:21:20 | Denali, Alaska, US | |
| 2021-08-31 | US | Montana | Wheatland | 30107 | 194 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-01 04:21:38 | Wheatland, Montana, US | |
| 2021-08-30 | US | Montana | Wheatland | 30107 | 194 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-08-31 04:21:46 | Wheatland, Montana, US | |
| 2021-08-29 | US | Montana | Wheatland | 30107 | 194 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-08-30 04:21:23 | Wheatland, Montana, US | |
| 2021-08-29 | US | Minnesota | Cook | 27031 | 194 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-08-30 04:21:23 | Cook, Minnesota, US | |
| 2021-08-28 | United Kingdom | Anguilla | 194 | 0 | 0 | 18.2206 | -63.0686 | 2021-08-29 04:21:14 | Anguilla, United Kingdom | |||
| 2021-08-28 | US | Montana | Wheatland | 30107 | 194 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-08-29 04:21:14 | Wheatland, Montana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;