johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
953 rows where confirmed = 221 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2019825 | 2019825 | 2022-09-20 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-21 04:23:22 | Glasscock, Texas, US | |
3573698 | 3573698 | 2022-09-19 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-20 04:22:48 | Glasscock, Texas, US | |
422437 | 422437 | 2022-09-18 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-19 04:21:49 | Glasscock, Texas, US | |
3376461 | 3376461 | 2022-09-17 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-18 04:22:50 | Glasscock, Texas, US | |
2358569 | 2358569 | 2022-09-16 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-17 04:20:19 | Glasscock, Texas, US | |
3989726 | 3989726 | 2022-09-15 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-16 04:21:19 | Glasscock, Texas, US | |
1892243 | 1892243 | 2022-09-14 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-15 04:21:02 | Glasscock, Texas, US | |
375298 | 375298 | 2022-09-13 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-14 04:20:44 | Glasscock, Texas, US | |
371986 | 371986 | 2022-09-13 | China | Guizhou | 221 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-14 04:20:44 | Guizhou, China | |||
2397900 | 2397900 | 2022-09-12 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-13 04:20:57 | Glasscock, Texas, US | |
2394591 | 2394591 | 2022-09-12 | China | Guizhou | 221 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-13 04:20:57 | Guizhou, China | |||
3768978 | 3768978 | 2022-09-11 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-12 04:20:58 | Glasscock, Texas, US | |
3765669 | 3765669 | 2022-09-11 | China | Guizhou | 221 | 2 | 0 | 26.8154 | 106.8748 | 2022-09-12 04:20:58 | Guizhou, China | |||
3827553 | 3827553 | 2022-09-10 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-11 04:20:50 | Glasscock, Texas, US | |
966010 | 966010 | 2022-09-09 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-10 04:21:10 | Glasscock, Texas, US | |
256412 | 256412 | 2022-09-08 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-09 04:21:11 | Glasscock, Texas, US | |
3748210 | 3748210 | 2022-09-07 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-08 04:21:02 | Glasscock, Texas, US | |
117850 | 117850 | 2022-09-06 | US | Texas | Glasscock | 48173 | 221 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-09-07 04:20:59 | Glasscock, Texas, US | |
3408547 | 3408547 | 2022-07-17 | US | Texas | Foard | 48155 | 221 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-18 04:20:59 | Foard, Texas, US | |
2154747 | 2154747 | 2022-07-16 | US | Texas | Foard | 48155 | 221 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-17 04:21:15 | Foard, Texas, US | |
2421980 | 2421980 | 2022-07-15 | US | Texas | Foard | 48155 | 221 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-16 04:21:05 | Foard, Texas, US | |
3432055 | 3432055 | 2022-07-14 | US | Texas | Foard | 48155 | 221 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-15 04:20:53 | Foard, Texas, US | |
3112575 | 3112575 | 2022-07-13 | US | Texas | Foard | 48155 | 221 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-14 04:20:57 | Foard, Texas, US | |
632998 | 632998 | 2022-07-12 | US | Texas | Foard | 48155 | 221 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-07-13 04:20:58 | Foard, Texas, US | |
2444763 | 2444763 | 2022-04-13 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-13 23:21:06 | Judith Basin, Montana, US | |
1950520 | 1950520 | 2022-04-12 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-13 04:21:03 | Judith Basin, Montana, US | |
3208273 | 3208273 | 2022-04-11 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-12 04:20:49 | Judith Basin, Montana, US | |
1578159 | 1578159 | 2022-04-10 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-11 04:21:02 | Judith Basin, Montana, US | |
1654401 | 1654401 | 2022-04-09 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-10 04:20:52 | Judith Basin, Montana, US | |
2117723 | 2117723 | 2022-04-08 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-09 04:20:42 | Judith Basin, Montana, US | |
3322247 | 3322247 | 2022-04-07 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-08 04:20:48 | Judith Basin, Montana, US | |
2802783 | 2802783 | 2022-04-06 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-07 04:20:53 | Judith Basin, Montana, US | |
3869552 | 3869552 | 2022-04-05 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-06 04:20:49 | Judith Basin, Montana, US | |
2750894 | 2750894 | 2022-04-04 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-05 04:20:48 | Judith Basin, Montana, US | |
3732240 | 3732240 | 2022-04-03 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-04 04:20:51 | Judith Basin, Montana, US | |
501675 | 501675 | 2022-04-02 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-03 04:20:48 | Judith Basin, Montana, US | |
3352660 | 3352660 | 2022-04-01 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-02 04:20:47 | Judith Basin, Montana, US | |
1541965 | 1541965 | 2022-03-31 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-04-01 04:20:28 | Judith Basin, Montana, US | |
2479978 | 2479978 | 2022-03-30 | US | Montana | Judith Basin | 30045 | 221 | 1 | 0 | 47.04581276 | -110.26606880000001 | 2022-03-31 04:20:56 | Judith Basin, Montana, US | |
3025407 | 3025407 | 2022-03-23 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-24 04:20:43 | Jeff Davis, Texas, US | |
1908329 | 1908329 | 2022-03-22 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-23 04:20:48 | Jeff Davis, Texas, US | |
3241460 | 3241460 | 2022-03-21 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-22 04:20:54 | Jeff Davis, Texas, US | |
27533 | 27533 | 2022-03-20 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-21 04:20:50 | Jeff Davis, Texas, US | |
1659543 | 1659543 | 2022-03-19 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-20 04:20:45 | Jeff Davis, Texas, US | |
339069 | 339069 | 2022-03-18 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-19 04:20:47 | Jeff Davis, Texas, US | |
697522 | 697522 | 2022-03-17 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-18 04:20:55 | Jeff Davis, Texas, US | |
2322465 | 2322465 | 2022-03-16 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-17 04:20:56 | Jeff Davis, Texas, US | |
264665 | 264665 | 2022-03-15 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-16 04:20:50 | Jeff Davis, Texas, US | |
2267024 | 2267024 | 2022-03-14 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-15 04:20:47 | Jeff Davis, Texas, US | |
3631090 | 3631090 | 2022-03-13 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-14 04:20:46 | Jeff Davis, Texas, US | |
953998 | 953998 | 2022-03-12 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-13 04:20:49 | Jeff Davis, Texas, US | |
359459 | 359459 | 2022-03-11 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-12 04:20:50 | Jeff Davis, Texas, US | |
1868611 | 1868611 | 2022-03-10 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-11 04:20:50 | Jeff Davis, Texas, US | |
2143306 | 2143306 | 2022-03-09 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-10 04:20:48 | Jeff Davis, Texas, US | |
922817 | 922817 | 2022-03-08 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-09 04:20:59 | Jeff Davis, Texas, US | |
1551104 | 1551104 | 2022-03-07 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-08 04:20:54 | Jeff Davis, Texas, US | |
2202773 | 2202773 | 2022-03-06 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-07 04:20:47 | Jeff Davis, Texas, US | |
2095230 | 2095230 | 2022-03-05 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-06 04:20:49 | Jeff Davis, Texas, US | |
2668930 | 2668930 | 2022-03-04 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-05 04:21:10 | Jeff Davis, Texas, US | |
1647495 | 1647495 | 2022-03-03 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-04 04:21:09 | Jeff Davis, Texas, US | |
2528498 | 2528498 | 2022-03-02 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-03 04:21:01 | Jeff Davis, Texas, US | |
1995792 | 1995792 | 2022-03-01 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-02 04:21:07 | Jeff Davis, Texas, US | |
945966 | 945966 | 2022-02-28 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-03-01 04:21:09 | Jeff Davis, Texas, US | |
2736157 | 2736157 | 2022-02-27 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-28 04:21:05 | Jeff Davis, Texas, US | |
3049310 | 3049310 | 2022-02-26 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-27 04:21:04 | Jeff Davis, Texas, US | |
577965 | 577965 | 2022-02-25 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-26 04:21:12 | Jeff Davis, Texas, US | |
1514541 | 1514541 | 2022-02-24 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-25 04:21:11 | Jeff Davis, Texas, US | |
1060982 | 1060982 | 2022-02-23 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-24 04:21:14 | Jeff Davis, Texas, US | |
2449905 | 2449905 | 2022-02-22 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-23 04:21:09 | Jeff Davis, Texas, US | |
3721318 | 3721318 | 2022-02-21 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-22 04:21:01 | Jeff Davis, Texas, US | |
3915152 | 3915152 | 2022-02-20 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-21 04:21:05 | Jeff Davis, Texas, US | |
3878710 | 3878710 | 2022-02-19 | US | Texas | Jeff Davis | 48243 | 221 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-02-20 04:21:00 | Jeff Davis, Texas, US | |
3673653 | 3673653 | 2022-02-15 | US | Montana | Garfield | 30033 | 221 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-02-16 04:21:10 | Garfield, Montana, US | |
1962368 | 1962368 | 2022-01-20 | US | Mississippi | Issaquena | 28055 | 221 | 7 | 0 | 32.72531359 | -90.97392828 | 2022-01-21 04:21:09 | Issaquena, Mississippi, US | |
3690707 | 3690707 | 2022-01-13 | US | Texas | Sterling | 48431 | 221 | 5 | 0 | 31.82781912 | -101.05007459999999 | 2022-01-14 04:21:54 | Sterling, Texas, US | |
3690386 | 3690386 | 2022-01-13 | US | South Dakota | Sully | 46119 | 221 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-14 04:21:54 | Sully, South Dakota, US | |
3690099 | 3690099 | 2022-01-13 | US | Oregon | Gilliam | 41021 | 221 | 4 | 0 | 45.37160076 | -120.20488689999999 | 2022-01-14 04:21:54 | Gilliam, Oregon, US | |
1116446 | 1116446 | 2022-01-11 | US | South Dakota | Campbell | 46021 | 221 | 6 | 0 | 45.77074915 | -100.0510181 | 2022-01-12 04:21:44 | Campbell, South Dakota, US | |
2113008 | 2113008 | 2021-12-26 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-27 04:21:58 | Lane, Kansas, US | |
3606380 | 3606380 | 2021-12-25 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-26 04:21:50 | Lane, Kansas, US | |
2964698 | 2964698 | 2021-12-24 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-25 04:21:37 | Lane, Kansas, US | |
3817730 | 3817730 | 2021-12-23 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-24 04:21:34 | Lane, Kansas, US | |
799738 | 799738 | 2021-12-22 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-23 04:21:21 | Lane, Kansas, US | |
3829778 | 3829778 | 2021-12-21 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-22 04:21:54 | Lane, Kansas, US | |
1256081 | 1256081 | 2021-12-20 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-21 03:21:27 | Lane, Kansas, US | |
2905024 | 2905024 | 2021-12-19 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-20 04:21:43 | Lane, Kansas, US | |
1262080 | 1262080 | 2021-12-18 | US | Vermont | Unassigned | 90050 | 221 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-19 04:21:11 | Unassigned, Vermont, US | |
1260097 | 1260097 | 2021-12-18 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-19 04:21:11 | Lane, Kansas, US | |
2400125 | 2400125 | 2021-12-17 | US | Kansas | Lane | 20101 | 221 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2021-12-18 02:22:20 | Lane, Kansas, US | |
1324296 | 1324296 | 2021-11-14 | US | Nebraska | Deuel | 31049 | 221 | 1 | 0 | 41.11168186 | -102.33333309999999 | 2021-11-15 04:21:36 | Deuel, Nebraska, US | |
688422 | 688422 | 2021-11-13 | US | Nebraska | Deuel | 31049 | 221 | 1 | 0 | 41.11168186 | -102.33333309999999 | 2021-11-14 04:21:31 | Deuel, Nebraska, US | |
716531 | 716531 | 2021-11-12 | US | Nebraska | Deuel | 31049 | 221 | 1 | 0 | 41.11168186 | -102.33333309999999 | 2021-11-13 04:21:38 | Deuel, Nebraska, US | |
3797121 | 3797121 | 2021-10-25 | US | Texas | Stonewall | 48433 | 221 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-26 04:22:09 | Stonewall, Texas, US | |
685567 | 685567 | 2021-10-24 | US | Texas | Stonewall | 48433 | 221 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-25 04:22:31 | Stonewall, Texas, US | |
773575 | 773575 | 2021-10-23 | US | Texas | Stonewall | 48433 | 221 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-24 04:21:22 | Stonewall, Texas, US | |
657222 | 657222 | 2021-10-22 | US | Texas | Stonewall | 48433 | 221 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-23 04:21:32 | Stonewall, Texas, US | |
2126969 | 2126969 | 2021-10-21 | US | Texas | Stonewall | 48433 | 221 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-22 04:21:14 | Stonewall, Texas, US | |
445336 | 445336 | 2021-10-20 | US | Missouri | Worth | 29227 | 221 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-10-21 04:21:18 | Worth, Missouri, US | |
1492875 | 1492875 | 2021-10-12 | US | Kansas | Comanche | 20033 | 221 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-10-13 04:20:51 | Comanche, Kansas, US | |
3008608 | 3008608 | 2021-10-11 | US | Kansas | Comanche | 20033 | 221 | 11 | 0 | 37.19114520000001 | -99.27113247 | 2021-10-12 04:21:09 | Comanche, Kansas, 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]);