johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
978 rows where confirmed = 205 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308549 | 308549 | 2022-12-13 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-14 04:21:04 | Unassigned, Colorado, US | |
1149610 | 1149610 | 2022-12-12 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-13 04:21:01 | Unassigned, Colorado, US | |
869464 | 869464 | 2022-12-11 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-12 04:21:01 | Unassigned, Colorado, US | |
257994 | 257994 | 2022-12-10 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-11 04:20:50 | Unassigned, Colorado, US | |
3936708 | 3936708 | 2022-12-09 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-10 04:21:02 | Unassigned, Colorado, US | |
3378040 | 3378040 | 2022-12-08 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-09 04:21:05 | Unassigned, Colorado, US | |
1985311 | 1985311 | 2022-12-07 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-08 04:21:07 | Unassigned, Colorado, US | |
3714834 | 3714834 | 2022-12-06 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-07 04:20:58 | Unassigned, Colorado, US | |
2415539 | 2415539 | 2022-12-05 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-06 04:21:03 | Unassigned, Colorado, US | |
719147 | 719147 | 2022-12-04 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-05 04:20:58 | Unassigned, Colorado, US | |
2817436 | 2817436 | 2022-12-03 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-04 04:20:56 | Unassigned, Colorado, US | |
834292 | 834292 | 2022-12-02 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-03 04:21:02 | Unassigned, Colorado, US | |
2136822 | 2136822 | 2022-12-01 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-02 04:21:07 | Unassigned, Colorado, US | |
1965238 | 1965238 | 2022-11-30 | US | Colorado | Unassigned | 90008 | 205 | 2 | 0 | 40.87595412 | 0.0 | 2022-12-01 04:21:03 | Unassigned, Colorado, US | |
2493116 | 2493116 | 2022-06-29 | US | Texas | Glasscock | 48173 | 205 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-06-30 04:21:01 | Glasscock, Texas, US | |
2489820 | 2489820 | 2022-06-29 | China | Macau | 205 | 0 | 0 | 22.1667 | 113.55 | 2022-06-30 04:21:01 | Macau, China | |||
3889660 | 3889660 | 2022-06-06 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-07 04:21:08 | Wibaux, Montana, US | |
3509429 | 3509429 | 2022-06-05 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-06 04:20:57 | Wibaux, Montana, US | |
3529506 | 3529506 | 2022-06-04 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-05 04:20:55 | Wibaux, Montana, US | |
3135592 | 3135592 | 2022-06-03 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-04 04:20:58 | Wibaux, Montana, US | |
3580667 | 3580667 | 2022-06-02 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-03 04:20:58 | Wibaux, Montana, US | |
972960 | 972960 | 2022-06-01 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-02 05:20:39 | Wibaux, Montana, US | |
231267 | 231267 | 2022-05-31 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-06-01 04:20:55 | Wibaux, Montana, US | |
3188032 | 3188032 | 2022-05-30 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-31 04:20:51 | Wibaux, Montana, US | |
3200181 | 3200181 | 2022-05-29 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-30 04:20:50 | Wibaux, Montana, US | |
2727059 | 2727059 | 2022-05-28 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-29 04:20:53 | Wibaux, Montana, US | |
1316240 | 1316240 | 2022-05-27 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-28 04:21:07 | Wibaux, Montana, US | |
1852032 | 1852032 | 2022-05-26 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-27 04:20:56 | Wibaux, Montana, US | |
2049908 | 2049908 | 2022-05-25 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-26 04:20:50 | Wibaux, Montana, US | |
3002468 | 3002468 | 2022-05-24 | US | Texas | Loving | 48301 | 205 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-25 04:20:56 | Loving, Texas, US | |
3001346 | 3001346 | 2022-05-24 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-25 04:20:56 | Wibaux, Montana, US | |
3595067 | 3595067 | 2022-05-23 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-24 04:20:57 | Wibaux, Montana, US | |
623919 | 623919 | 2022-05-22 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-26 04:20:50 | Wibaux, Montana, US | |
1111615 | 1111615 | 2022-05-21 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-22 04:20:52 | Wibaux, Montana, US | |
1171239 | 1171239 | 2022-05-20 | US | Montana | Wibaux | 30109 | 205 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-05-21 04:20:58 | Wibaux, Montana, US | |
3357407 | 3357407 | 2022-05-14 | US | Puerto Rico | Culebra | 72049 | 205 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-15 04:20:53 | Culebra, Puerto Rico, US | |
658970 | 658970 | 2022-05-13 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-14 04:20:48 | San Juan, Colorado, US | |
2534053 | 2534053 | 2022-05-12 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-13 04:20:51 | San Juan, Colorado, US | |
3445499 | 3445499 | 2022-05-11 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-12 04:20:54 | San Juan, Colorado, US | |
3536116 | 3536116 | 2022-05-10 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-11 04:20:48 | San Juan, Colorado, US | |
222651 | 222651 | 2022-05-09 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-10 04:20:50 | San Juan, Colorado, US | |
2332036 | 2332036 | 2022-05-08 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-09 04:20:54 | San Juan, Colorado, US | |
360998 | 360998 | 2022-05-07 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-08 04:20:49 | San Juan, Colorado, US | |
1398349 | 1398349 | 2022-05-06 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-07 04:21:09 | San Juan, Colorado, US | |
2598704 | 2598704 | 2022-05-05 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-06 04:21:00 | San Juan, Colorado, US | |
3266153 | 3266153 | 2022-05-04 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-05 04:20:55 | San Juan, Colorado, US | |
1572792 | 1572792 | 2022-05-03 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-04 04:20:59 | San Juan, Colorado, US | |
464052 | 464052 | 2022-05-02 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-03 04:21:00 | San Juan, Colorado, US | |
3916691 | 3916691 | 2022-05-01 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-02 04:21:10 | San Juan, Colorado, US | |
2841495 | 2841495 | 2022-04-30 | US | Colorado | San Juan | 8111 | 205 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-01 04:20:57 | San Juan, Colorado, US | |
1160241 | 1160241 | 2022-04-29 | US | Texas | Foard | 48155 | 205 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-04-30 04:21:05 | Foard, Texas, US | |
1699423 | 1699423 | 2022-04-28 | US | Texas | Foard | 48155 | 205 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-04-29 04:20:59 | Foard, Texas, US | |
3854906 | 3854906 | 2022-04-27 | US | Texas | Foard | 48155 | 205 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-04-28 04:20:47 | Foard, Texas, US | |
1329336 | 1329336 | 2022-04-26 | US | Texas | Foard | 48155 | 205 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-04-27 04:20:52 | Foard, Texas, US | |
2659797 | 2659797 | 2022-01-31 | US | Montana | Judith Basin | 30045 | 205 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-02-01 04:21:11 | Judith Basin, Montana, US | |
1694341 | 1694341 | 2022-01-10 | US | Montana | Prairie | 30079 | 205 | 3 | 0 | 46.86048047 | -105.379384 | 2022-01-11 04:22:01 | Prairie, Montana, US | |
1392793 | 1392793 | 2022-01-07 | US | Texas | Jeff Davis | 48243 | 205 | 6 | 0 | 30.71490589 | -104.1399973 | 2022-01-08 04:21:53 | Jeff Davis, Texas, US | |
1671586 | 1671586 | 2021-12-29 | US | Texas | Irion | 48235 | 205 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-30 04:21:25 | Irion, Texas, US | |
2114991 | 2114991 | 2021-12-26 | US | Vermont | Unassigned | 90050 | 205 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-27 04:21:58 | Unassigned, Vermont, US | |
3608363 | 3608363 | 2021-12-25 | US | Vermont | Unassigned | 90050 | 205 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-26 04:21:50 | Unassigned, Vermont, US | |
2966681 | 2966681 | 2021-12-24 | US | Vermont | Unassigned | 90050 | 205 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-25 04:21:37 | Unassigned, Vermont, US | |
3819713 | 3819713 | 2021-12-23 | US | Vermont | Unassigned | 90050 | 205 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-24 04:21:34 | Unassigned, Vermont, US | |
2090830 | 2090830 | 2021-12-14 | US | South Dakota | Campbell | 46021 | 205 | 5 | 0 | 45.77074915 | -100.0510181 | 2021-12-15 03:22:16 | Campbell, South Dakota, US | |
785747 | 785747 | 2021-12-13 | US | Virginia | Highland | 51091 | 205 | 4 | 0 | 38.35799465 | -79.56124594 | 2021-12-14 04:22:38 | Highland, Virginia, US | |
785247 | 785247 | 2021-12-13 | US | South Dakota | Campbell | 46021 | 205 | 5 | 0 | 45.77074915 | -100.0510181 | 2021-12-14 04:22:38 | Campbell, South Dakota, US | |
407083 | 407083 | 2021-12-07 | US | Puerto Rico | Vieques | 72147 | 205 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-08 04:22:46 | Vieques, Puerto Rico, US | |
1033165 | 1033165 | 2021-12-06 | US | Puerto Rico | Vieques | 72147 | 205 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-07 04:22:34 | Vieques, Puerto Rico, US | |
1743328 | 1743328 | 2021-12-05 | US | Puerto Rico | Vieques | 72147 | 205 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-06 04:22:34 | Vieques, Puerto Rico, US | |
140760 | 140760 | 2021-12-04 | US | Puerto Rico | Vieques | 72147 | 205 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-05 04:22:25 | Vieques, Puerto Rico, US | |
1638 | 1638 | 2021-12-02 | US | Kansas | Lane | 20101 | 205 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-03 04:23:05 | Lane, Kansas, US | |
1146237 | 1146237 | 2021-12-01 | US | Kansas | Lane | 20101 | 205 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-02 04:22:37 | Lane, Kansas, US | |
3072455 | 3072455 | 2021-11-23 | US | North Dakota | Sheridan | 38083 | 205 | 4 | 0 | 47.57700669 | -100.3426391 | 2021-11-24 04:22:14 | Sheridan, North Dakota, US | |
3751553 | 3751553 | 2021-11-22 | US | North Dakota | Sheridan | 38083 | 205 | 4 | 0 | 47.57700669 | -100.3426391 | 2021-11-23 04:22:39 | Sheridan, North Dakota, US | |
3513553 | 3513553 | 2021-11-01 | US | Nevada | Storey | 32029 | 205 | 5 | 0 | 39.44875482 | -119.5250207 | 2021-11-02 04:22:03 | Storey, Nevada, US | |
537152 | 537152 | 2021-10-27 | US | North Dakota | Oliver | 38065 | 205 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-10-28 04:22:08 | Oliver, North Dakota, US | |
3835711 | 3835711 | 2021-10-05 | US | Texas | Stonewall | 48433 | 205 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-06 04:21:33 | Stonewall, Texas, US | |
1335549 | 1335549 | 2021-09-28 | US | Kansas | Comanche | 20033 | 205 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-29 04:21:45 | Comanche, Kansas, US | |
1236918 | 1236918 | 2021-09-27 | US | Kansas | Comanche | 20033 | 205 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-28 04:21:28 | Comanche, Kansas, US | |
2077219 | 2077219 | 2021-09-26 | US | Kansas | Comanche | 20033 | 205 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-27 04:21:16 | Comanche, Kansas, US | |
1725771 | 1725771 | 2021-09-25 | US | Kansas | Comanche | 20033 | 205 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-26 04:21:29 | Comanche, Kansas, US | |
1922491 | 1922491 | 2021-09-24 | US | Kansas | Comanche | 20033 | 205 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-25 04:21:31 | Comanche, Kansas, US | |
603339 | 603339 | 2021-09-23 | US | Michigan | Keweenaw | 26083 | 205 | 4 | 0 | 47.63197653 | -88.41434263 | 2021-09-24 04:21:44 | Keweenaw, Michigan, US | |
602962 | 602962 | 2021-09-23 | US | Kansas | Comanche | 20033 | 205 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-24 04:21:44 | Comanche, Kansas, US | |
3012983 | 3012983 | 2021-09-22 | US | Michigan | Keweenaw | 26083 | 205 | 4 | 0 | 47.63197653 | -88.41434263 | 2021-09-23 04:21:43 | Keweenaw, Michigan, US | |
3012606 | 3012606 | 2021-09-22 | US | Kansas | Comanche | 20033 | 205 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-09-23 04:21:43 | Comanche, Kansas, US | |
1886707 | 1886707 | 2021-09-12 | US | Minnesota | Cook | 27031 | 205 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-13 04:21:15 | Cook, Minnesota, US | |
3807610 | 3807610 | 2021-09-11 | US | Minnesota | Cook | 27031 | 205 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-12 04:21:13 | Cook, Minnesota, US | |
3451900 | 3451900 | 2021-09-10 | US | Texas | Cottle | 48101 | 205 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-11 04:21:30 | Cottle, Texas, US | |
3450550 | 3450550 | 2021-09-10 | US | Minnesota | Cook | 27031 | 205 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-11 04:21:30 | Cook, Minnesota, US | |
2281585 | 2281585 | 2021-09-08 | US | North Dakota | Steele | 38091 | 205 | 2 | 0 | 47.45611548 | -97.72728747 | 2021-09-09 04:21:27 | Steele, North Dakota, US | |
2281148 | 2281148 | 2021-09-08 | US | Montana | Daniels | 30019 | 205 | 8 | 0 | 48.78420029 | -105.54763429999998 | 2021-09-09 04:21:27 | Daniels, Montana, US | |
2281137 | 2281137 | 2021-09-08 | US | Missouri | Worth | 29227 | 205 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-09-09 04:21:27 | Worth, Missouri, US | |
1777335 | 1777335 | 2021-08-30 | US | Missouri | Worth | 29227 | 205 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-08-31 04:21:46 | Worth, Missouri, US | |
3895539 | 3895539 | 2021-08-29 | US | Wyoming | Niobrara | 56027 | 205 | 3 | 0 | 43.05607708 | -104.47588959999999 | 2021-08-30 04:21:23 | Niobrara, Wyoming, US | |
2796642 | 2796642 | 2021-08-28 | US | Wyoming | Niobrara | 56027 | 205 | 3 | 0 | 43.05607708 | -104.47588959999999 | 2021-08-29 04:21:14 | Niobrara, Wyoming, US | |
2926801 | 2926801 | 2021-08-27 | US | Wyoming | Niobrara | 56027 | 205 | 3 | 0 | 43.05607708 | -104.47588959999999 | 2021-08-28 04:21:28 | Niobrara, Wyoming, US | |
1597068 | 1597068 | 2021-08-26 | US | Georgia | Quitman | 13239 | 205 | 3 | 0 | 31.86728114 | -85.01773177 | 2021-08-27 04:21:37 | Quitman, Georgia, US | |
34604 | 34604 | 2021-08-25 | US | New Mexico | De Baca | 35011 | 205 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-08-26 04:21:28 | De Baca, New Mexico, US | |
3105887 | 3105887 | 2021-08-24 | US | Alaska | Petersburg | 2195 | 205 | 2 | 0 | 57.13978948 | -132.9540995 | 2021-08-25 04:21:41 | Petersburg, Alaska, US | |
3167826 | 3167826 | 2021-08-23 | US | New Mexico | Mora | 35033 | 205 | 8 | 0 | 36.01095101 | -104.9497716 | 2021-08-24 04:21:19 | Mora, New Mexico, 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]);