johns_hopkins_csse_daily_reports
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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756115 | 2756115 | 2022-12-29 | US | Texas | Roberts | 48393 | 194 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-30 04:21:04 | Roberts, Texas, US | |
1077121 | 1077121 | 2022-12-28 | US | Texas | Roberts | 48393 | 194 | 2 | 0 | 35.83809685 | -100.813175 | 2022-12-29 04:21:01 | Roberts, Texas, US | |
1074541 | 1074541 | 2022-12-28 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-29 04:21:01 | Jackson, Colorado, US | |
328538 | 328538 | 2022-12-27 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-28 04:21:04 | Jackson, Colorado, US | |
218611 | 218611 | 2022-12-26 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-27 04:21:07 | Jackson, Colorado, US | |
3223068 | 3223068 | 2022-12-25 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-26 04:21:06 | Jackson, Colorado, US | |
1018982 | 1018982 | 2022-12-24 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-25 04:21:04 | Jackson, Colorado, US | |
691005 | 691005 | 2022-12-23 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-24 04:21:02 | Jackson, Colorado, US | |
2180215 | 2180215 | 2022-12-22 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-23 04:21:04 | Jackson, Colorado, US | |
452019 | 452019 | 2022-12-21 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-22 04:20:56 | Jackson, Colorado, US | |
2952018 | 2952018 | 2022-12-20 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-21 04:21:03 | Jackson, Colorado, US | |
3174420 | 3174420 | 2022-12-19 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-20 04:21:04 | Jackson, Colorado, US | |
1628937 | 1628937 | 2022-12-18 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-19 04:21:03 | Jackson, Colorado, US | |
504316 | 504316 | 2022-12-17 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-18 04:21:03 | Jackson, Colorado, US | |
3324888 | 3324888 | 2022-12-16 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-17 04:21:04 | Jackson, Colorado, US | |
543400 | 543400 | 2022-12-15 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-16 04:21:01 | Jackson, Colorado, US | |
348928 | 348928 | 2022-12-14 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-15 04:20:58 | Jackson, Colorado, US | |
308516 | 308516 | 2022-12-13 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-14 04:21:04 | Jackson, Colorado, US | |
3714801 | 3714801 | 2022-12-06 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-07 04:20:58 | Jackson, Colorado, US | |
2415506 | 2415506 | 2022-12-05 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-06 04:21:03 | Jackson, Colorado, US | |
719114 | 719114 | 2022-12-04 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-05 04:20:58 | Jackson, Colorado, US | |
2817403 | 2817403 | 2022-12-03 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-04 04:20:56 | Jackson, Colorado, US | |
834259 | 834259 | 2022-12-02 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-03 04:21:02 | Jackson, Colorado, US | |
2136789 | 2136789 | 2022-12-01 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-02 04:21:07 | Jackson, Colorado, US | |
1965205 | 1965205 | 2022-11-30 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-12-01 04:21:03 | Jackson, Colorado, US | |
2557219 | 2557219 | 2022-11-29 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-30 04:21:07 | Jackson, Colorado, US | |
1240293 | 1240293 | 2022-11-28 | US | Colorado | Jackson | 8057 | 194 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-29 04:21:05 | Jackson, Colorado, US | |
1620938 | 1620938 | 2022-11-22 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-23 04:21:06 | Unassigned, Colorado, US | |
3460826 | 3460826 | 2022-11-21 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-22 04:20:47 | Unassigned, Colorado, US | |
1641011 | 1641011 | 2022-11-20 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-21 04:21:05 | Unassigned, Colorado, US | |
2064568 | 2064568 | 2022-11-19 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-20 04:21:08 | Unassigned, Colorado, US | |
1755962 | 1755962 | 2022-11-18 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-19 04:21:14 | Unassigned, Colorado, US | |
3026955 | 3026955 | 2022-11-17 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-18 04:21:15 | Unassigned, Colorado, US | |
2486666 | 2486666 | 2022-11-16 | US | Colorado | Unassigned | 90008 | 194 | 2 | 0 | 40.87595412 | 0.0 | 2022-11-17 04:21:11 | Unassigned, Colorado, US | |
3547296 | 3547296 | 2022-09-01 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-02 04:21:07 | Guizhou, China | |||
2343231 | 2343231 | 2022-08-31 | China | Qinghai | 194 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-01 04:21:03 | Qinghai, China | |||
2343216 | 2343216 | 2022-08-31 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-01 04:21:03 | Guizhou, China | |||
3773696 | 3773696 | 2022-08-30 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-31 04:20:57 | Guizhou, China | |||
1680292 | 1680292 | 2022-08-29 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-30 04:21:03 | Guizhou, China | |||
1876776 | 1876776 | 2022-08-28 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-29 04:21:06 | Guizhou, China | |||
2095903 | 2095903 | 2022-08-27 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-28 04:21:02 | Guizhou, China | |||
1531718 | 1531718 | 2022-08-26 | China | Guizhou | 194 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-27 04:20:57 | Guizhou, China | |||
2334542 | 2334542 | 2022-05-08 | US | Texas | Loving | 48301 | 194 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-09 04:20:54 | Loving, Texas, US | |
157803 | 157803 | 2022-03-29 | China | Hainan | 194 | 6 | 0 | 19.1959 | 109.7453 | 2022-03-30 04:20:45 | Hainan, China | |||
236340 | 236340 | 2022-02-11 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-12 04:21:06 | Glasscock, Texas, US | |
1467182 | 1467182 | 2022-02-10 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-11 04:21:09 | Glasscock, Texas, US | |
3077143 | 3077143 | 2022-02-09 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-10 04:21:14 | Glasscock, Texas, US | |
1365450 | 1365450 | 2022-02-08 | US | Texas | Glasscock | 48173 | 194 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-09 04:21:04 | Glasscock, Texas, US | |
72143 | 72143 | 2022-02-07 | US | Illinois | Unassigned | 90017 | 194 | 3861 | 0 | 42.36542373 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Illinois, US | |
1297124 | 1297124 | 2022-02-05 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-06 04:21:00 | Foard, Texas, US | |
2330452 | 2330452 | 2022-02-04 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-05 04:21:05 | Foard, Texas, US | |
2477043 | 2477043 | 2022-02-03 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-04 04:21:10 | Foard, Texas, US | |
462522 | 462522 | 2022-02-02 | US | Texas | Kent | 48263 | 194 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-02-03 04:21:21 | Kent, Texas, US | |
462468 | 462468 | 2022-02-02 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-03 04:21:21 | Foard, Texas, US | |
982091 | 982091 | 2022-02-01 | US | Texas | Kent | 48263 | 194 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-02-02 04:21:09 | Kent, Texas, US | |
982037 | 982037 | 2022-02-01 | US | Texas | Foard | 48155 | 194 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-02-02 04:21:09 | Foard, Texas, US | |
3466177 | 3466177 | 2022-01-18 | US | Montana | Garfield | 30033 | 194 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-01-19 04:21:23 | Garfield, Montana, US | |
1435185 | 1435185 | 2021-12-28 | US | Oregon | Gilliam | 41021 | 194 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2021-12-29 03:21:43 | Gilliam, Oregon, US | |
800453 | 800453 | 2021-12-22 | US | Montana | Prairie | 30079 | 194 | 2 | 0 | 46.86048047 | -105.379384 | 2021-12-23 04:21:21 | Prairie, Montana, US | |
3831598 | 3831598 | 2021-12-21 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-22 04:21:54 | Irion, Texas, US | |
3830493 | 3830493 | 2021-12-21 | US | Montana | Prairie | 30079 | 194 | 2 | 0 | 46.86048047 | -105.379384 | 2021-12-22 04:21:54 | Prairie, Montana, US | |
1257901 | 1257901 | 2021-12-20 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-21 03:21:27 | Irion, Texas, US | |
2906844 | 2906844 | 2021-12-19 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-20 04:21:43 | Irion, Texas, US | |
1261917 | 1261917 | 2021-12-18 | US | Texas | Irion | 48235 | 194 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-19 04:21:11 | Irion, Texas, US | |
3499094 | 3499094 | 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 | |
3404797 | 3404797 | 2021-11-30 | US | Virginia | Highland | 51091 | 194 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-01 04:22:29 | Highland, Virginia, US | |
906968 | 906968 | 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 | |
3072818 | 3072818 | 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 | |
3751916 | 3751916 | 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 | |
1017123 | 1017123 | 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 | |
725287 | 725287 | 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 | |
164817 | 164817 | 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 | |
3344432 | 3344432 | 2021-11-16 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-17 04:21:48 | Issaquena, Mississippi, US | |
2289268 | 2289268 | 2021-11-15 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-16 04:21:10 | Issaquena, Mississippi, US | |
1324042 | 1324042 | 2021-11-14 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-15 04:21:36 | Issaquena, Mississippi, US | |
688168 | 688168 | 2021-11-13 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-14 04:21:31 | Issaquena, Mississippi, US | |
716277 | 716277 | 2021-11-12 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-13 04:21:38 | Issaquena, Mississippi, US | |
30227 | 30227 | 2021-11-11 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-12 04:22:01 | Issaquena, Mississippi, US | |
2846666 | 2846666 | 2021-11-10 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-11 04:21:45 | Issaquena, Mississippi, US | |
90005 | 90005 | 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 | |
88936 | 88936 | 2021-11-09 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-10 04:21:38 | Issaquena, Mississippi, US | |
3641364 | 3641364 | 2021-11-08 | US | Mississippi | Issaquena | 28055 | 194 | 7 | 0 | 32.72531359 | -90.97392828 | 2021-11-09 04:21:36 | Issaquena, Mississippi, US | |
2946487 | 2946487 | 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 | |
1492195 | 1492195 | 2021-10-12 | US | California | Unassigned | 90006 | 194 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-13 04:20:51 | Unassigned, California, US | |
2461208 | 2461208 | 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 | |
3834901 | 3834901 | 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 | |
1337502 | 1337502 | 2021-09-28 | US | Texas | Stonewall | 48433 | 194 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-09-29 04:21:45 | Stonewall, Texas, US | |
2076560 | 2076560 | 2021-09-26 | US | Colorado | Dolores | 8033 | 194 | 1 | 0 | 37.75208676 | -108.5211585 | 2021-09-27 04:21:16 | Dolores, Colorado, US | |
603701 | 603701 | 2021-09-23 | US | Montana | Meagher | 30059 | 194 | 7 | 0 | 46.59907074 | -110.8898557 | 2021-09-24 04:21:44 | Meagher, Montana, US | |
3760911 | 3760911 | 2021-09-21 | US | Washington | Garfield | 53023 | 194 | 7 | 0 | 46.43197502 | -117.54540320000001 | 2021-09-22 04:21:45 | Garfield, Washington, US | |
1885419 | 1885419 | 2021-09-12 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-13 04:21:15 | Denali, Alaska, US | |
3806322 | 3806322 | 2021-09-11 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-12 04:21:13 | Denali, Alaska, US | |
3449262 | 3449262 | 2021-09-10 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-11 04:21:30 | Denali, Alaska, US | |
1263208 | 1263208 | 2021-09-09 | US | Alaska | Denali | 2068 | 194 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-10 04:21:20 | Denali, Alaska, US | |
2069937 | 2069937 | 2021-08-31 | US | Montana | Wheatland | 30107 | 194 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-01 04:21:38 | Wheatland, Montana, US | |
1777391 | 1777391 | 2021-08-30 | US | Montana | Wheatland | 30107 | 194 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-08-31 04:21:46 | Wheatland, Montana, US | |
3893965 | 3893965 | 2021-08-29 | US | Montana | Wheatland | 30107 | 194 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-08-30 04:21:23 | Wheatland, Montana, US | |
3893638 | 3893638 | 2021-08-29 | US | Minnesota | Cook | 27031 | 194 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-08-30 04:21:23 | Cook, Minnesota, US | |
2796682 | 2796682 | 2021-08-28 | United Kingdom | Anguilla | 194 | 0 | 0 | 18.2206 | -63.0686 | 2021-08-29 04:21:14 | Anguilla, United Kingdom | |||
2795068 | 2795068 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);