johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,054 rows where confirmed = 192 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3552281 | 3552281 | 2022-11-27 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-28 04:21:02 | Jackson, Colorado, US | |
2100761 | 2100761 | 2022-11-26 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-27 04:21:05 | Jackson, Colorado, US | |
488252 | 488252 | 2022-11-25 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-26 04:21:11 | Jackson, Colorado, US | |
3524081 | 3524081 | 2022-11-24 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-25 04:21:06 | Jackson, Colorado, US | |
3312864 | 3312864 | 2022-11-23 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-24 04:21:09 | Jackson, Colorado, US | |
1620905 | 1620905 | 2022-11-22 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-23 04:21:06 | Jackson, Colorado, US | |
3460793 | 3460793 | 2022-11-21 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-22 04:20:47 | Jackson, Colorado, US | |
1640978 | 1640978 | 2022-11-20 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-21 04:21:05 | Jackson, Colorado, US | |
2064535 | 2064535 | 2022-11-19 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-20 04:21:08 | Jackson, Colorado, US | |
1755929 | 1755929 | 2022-11-18 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-19 04:21:14 | Jackson, Colorado, US | |
3026922 | 3026922 | 2022-11-17 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-18 04:21:15 | Jackson, Colorado, US | |
2486633 | 2486633 | 2022-11-16 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-17 04:21:11 | Jackson, Colorado, US | |
292644 | 292644 | 2022-11-15 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-16 04:21:09 | Jackson, Colorado, US | |
3597674 | 3597674 | 2022-11-14 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-15 04:21:16 | Jackson, Colorado, US | |
312532 | 312532 | 2022-11-13 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-14 04:21:09 | Jackson, Colorado, US | |
63693 | 63693 | 2022-11-12 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-13 04:21:14 | Jackson, Colorado, US | |
2927855 | 2927855 | 2022-11-11 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-12 04:20:41 | Jackson, Colorado, US | |
2506691 | 2506691 | 2022-11-10 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-11 04:21:22 | Jackson, Colorado, US | |
2431566 | 2431566 | 2022-11-09 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-10 04:21:16 | Jackson, Colorado, US | |
480222 | 480222 | 2022-11-08 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-09 04:21:22 | Jackson, Colorado, US | |
2439372 | 2439372 | 2022-11-07 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-08 04:21:21 | Jackson, Colorado, US | |
1050470 | 1050470 | 2022-11-06 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-07 04:21:26 | Jackson, Colorado, US | |
618494 | 618494 | 2022-11-05 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-06 04:21:24 | Jackson, Colorado, US | |
1022998 | 1022998 | 2022-11-04 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-05 04:21:52 | Jackson, Colorado, US | |
431989 | 431989 | 2022-11-03 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-04 04:22:11 | Jackson, Colorado, US | |
850231 | 850231 | 2022-11-02 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-03 04:22:05 | Jackson, Colorado, US | |
711082 | 711082 | 2022-11-01 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-02 04:22:09 | Jackson, Colorado, US | |
3285531 | 3285531 | 2022-10-31 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-11-01 04:22:36 | Jackson, Colorado, US | |
320564 | 320564 | 2022-10-30 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-31 04:21:36 | Jackson, Colorado, US | |
912840 | 912840 | 2022-10-29 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-30 04:22:14 | Jackson, Colorado, US | |
1367109 | 1367109 | 2022-10-28 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-29 04:21:13 | Jackson, Colorado, US | |
3038964 | 3038964 | 2022-10-27 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-28 04:22:31 | Jackson, Colorado, US | |
539384 | 539384 | 2022-10-26 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-27 04:22:01 | Jackson, Colorado, US | |
1830785 | 1830785 | 2022-10-25 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-26 04:22:19 | Jackson, Colorado, US | |
795046 | 795046 | 2022-10-24 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-25 04:21:53 | Jackson, Colorado, US | |
3277501 | 3277501 | 2022-10-23 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-24 04:22:29 | Jackson, Colorado, US | |
2268539 | 2268539 | 2022-10-22 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-23 04:22:46 | Jackson, Colorado, US | |
1592839 | 1592839 | 2022-10-21 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-22 04:22:53 | Jackson, Colorado, US | |
2272555 | 2272555 | 2022-10-20 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-21 04:22:23 | Jackson, Colorado, US | |
198890 | 198890 | 2022-10-19 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-20 04:22:59 | Jackson, Colorado, US | |
2757551 | 2757551 | 2022-10-18 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-19 04:22:26 | Jackson, Colorado, US | |
2025385 | 2025385 | 2022-10-17 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-18 04:22:42 | Jackson, Colorado, US | |
2160163 | 2160163 | 2022-10-16 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-17 04:20:31 | Jackson, Colorado, US | |
516360 | 516360 | 2022-10-15 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-16 04:22:39 | Jackson, Colorado, US | |
2033417 | 2033417 | 2022-10-14 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-15 04:22:00 | Jackson, Colorado, US | |
3754105 | 3754105 | 2022-10-13 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-14 04:22:28 | Jackson, Colorado, US | |
3214930 | 3214930 | 2022-10-12 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-13 04:22:39 | Jackson, Colorado, US | |
3250779 | 3250779 | 2022-10-11 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-10-12 04:22:51 | Jackson, Colorado, US | |
1877615 | 1877615 | 2022-08-28 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-29 04:21:06 | Jackson, Colorado, US | |
2096742 | 2096742 | 2022-08-27 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-28 04:21:02 | Jackson, Colorado, US | |
1532557 | 1532557 | 2022-08-26 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-27 04:20:57 | Jackson, Colorado, US | |
2829444 | 2829444 | 2022-08-25 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-26 04:21:02 | Jackson, Colorado, US | |
2323977 | 2323977 | 2022-08-24 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-25 04:21:13 | Jackson, Colorado, US | |
1251386 | 1251386 | 2022-08-23 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-24 04:20:46 | Jackson, Colorado, US | |
3798540 | 3798540 | 2022-08-20 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-21 04:20:44 | Jackson, Colorado, US | |
3797701 | 3797701 | 2022-08-20 | China | Guizhou | 192 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-21 04:20:44 | Guizhou, China | |||
2364126 | 2364126 | 2022-08-19 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-20 04:21:01 | Jackson, Colorado, US | |
2363287 | 2363287 | 2022-08-19 | China | Guizhou | 192 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-20 04:21:01 | Guizhou, China | |||
1161797 | 1161797 | 2022-08-18 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-19 04:20:54 | Jackson, Colorado, US | |
1160958 | 1160958 | 2022-08-18 | China | Guizhou | 192 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-19 04:20:54 | Guizhou, China | |||
3951121 | 3951121 | 2022-08-17 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-18 04:21:11 | Jackson, Colorado, US | |
991623 | 991623 | 2022-08-16 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-17 04:20:59 | Jackson, Colorado, US | |
2494662 | 2494662 | 2022-08-15 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-16 04:20:58 | Jackson, Colorado, US | |
3648212 | 3648212 | 2022-08-14 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-15 04:20:59 | Jackson, Colorado, US | |
1969218 | 1969218 | 2022-08-13 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-14 04:20:55 | Jackson, Colorado, US | |
2889027 | 2889027 | 2022-08-12 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-13 04:20:52 | Jackson, Colorado, US | |
3908632 | 3908632 | 2022-08-11 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-12 04:20:54 | Jackson, Colorado, US | |
1346949 | 1346949 | 2022-08-10 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-11 04:20:49 | Jackson, Colorado, US | |
1086704 | 1086704 | 2022-08-09 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-10 04:20:57 | Jackson, Colorado, US | |
3544119 | 3544119 | 2022-08-08 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-09 04:20:34 | Jackson, Colorado, US | |
1070522 | 1070522 | 2022-08-07 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-08 04:21:08 | Jackson, Colorado, US | |
1941110 | 1941110 | 2022-08-06 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-07 04:20:54 | Jackson, Colorado, US | |
880909 | 880909 | 2022-08-05 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-06 04:20:56 | Jackson, Colorado, US | |
2009320 | 2009320 | 2022-08-04 | US | Colorado | Jackson | 8057 | 192 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-08-05 04:20:52 | Jackson, Colorado, US | |
363504 | 363504 | 2022-05-07 | US | Texas | Loving | 48301 | 192 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-08 04:20:49 | Loving, Texas, US | |
1400431 | 1400431 | 2022-05-06 | US | Puerto Rico | Culebra | 72049 | 192 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-07 04:21:09 | Culebra, Puerto Rico, US | |
2015804 | 2015804 | 2022-02-06 | US | Texas | Glasscock | 48173 | 192 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-07 04:21:05 | Glasscock, Texas, US | |
1297133 | 1297133 | 2022-02-05 | US | Texas | Glasscock | 48173 | 192 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-02-06 04:21:00 | Glasscock, Texas, US | |
3813075 | 3813075 | 2022-01-28 | US | Texas | Kent | 48263 | 192 | 3 | 0 | 33.18104136 | -100.7780939 | 2022-01-29 04:21:10 | Kent, Texas, US | |
1320254 | 1320254 | 2022-01-26 | US | Montana | Wibaux | 30109 | 192 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-01-27 04:21:19 | Wibaux, Montana, US | |
2054760 | 2054760 | 2022-01-25 | US | South Dakota | Harding | 46063 | 192 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-01-26 04:21:07 | Harding, South Dakota, US | |
2053922 | 2053922 | 2022-01-25 | US | Montana | Wibaux | 30109 | 192 | 8 | 0 | 46.95925154 | -104.2510927 | 2022-01-26 04:21:07 | Wibaux, Montana, US | |
1230491 | 1230491 | 2022-01-24 | US | South Dakota | Harding | 46063 | 192 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-01-25 04:21:05 | Harding, South Dakota, US | |
1143790 | 1143790 | 2022-01-23 | US | South Dakota | Harding | 46063 | 192 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-01-24 04:21:12 | Harding, South Dakota, US | |
2835708 | 2835708 | 2022-01-22 | US | South Dakota | Harding | 46063 | 192 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-01-23 04:21:13 | Harding, South Dakota, US | |
3427826 | 3427826 | 2022-01-21 | US | South Dakota | Harding | 46063 | 192 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-01-22 04:21:13 | Harding, South Dakota, US | |
1115731 | 1115731 | 2022-01-11 | US | Nevada | Eureka | 32011 | 192 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2022-01-12 04:21:44 | Eureka, Nevada, US | |
1694459 | 1694459 | 2022-01-10 | US | Nevada | Eureka | 32011 | 192 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2022-01-11 04:22:01 | Eureka, Nevada, US | |
2613274 | 2613274 | 2022-01-06 | US | Texas | Sterling | 48431 | 192 | 5 | 0 | 31.82781912 | -101.05007459999999 | 2022-01-07 04:22:09 | Sterling, Texas, US | |
801048 | 801048 | 2021-12-22 | US | Oregon | Gilliam | 41021 | 192 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2021-12-23 04:21:21 | Gilliam, Oregon, US | |
3831088 | 3831088 | 2021-12-21 | US | Oregon | Gilliam | 41021 | 192 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2021-12-22 04:21:54 | Gilliam, Oregon, US | |
1256796 | 1256796 | 2021-12-20 | US | Montana | Prairie | 30079 | 192 | 2 | 0 | 46.86048047 | -105.379384 | 2021-12-21 03:21:27 | Prairie, Montana, US | |
2401945 | 2401945 | 2021-12-17 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-18 02:22:20 | Irion, Texas, US | |
1719483 | 1719483 | 2021-12-16 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-17 04:22:14 | Irion, Texas, US | |
3499317 | 3499317 | 2021-12-15 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-16 04:22:11 | Irion, Texas, US | |
2091102 | 2091102 | 2021-12-14 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-15 03:22:16 | Irion, Texas, US | |
785519 | 785519 | 2021-12-13 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-14 04:22:38 | Irion, Texas, US | |
1663554 | 1663554 | 2021-12-12 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-13 04:22:02 | Irion, Texas, US | |
1667570 | 1667570 | 2021-12-11 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-12 04:22:12 | Irion, Texas, US | |
3658722 | 3658722 | 2021-12-10 | US | Texas | Irion | 48235 | 192 | 2 | 0 | 31.30375559 | -100.982439 | 2021-12-11 04:22:45 | Irion, Texas, 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]);