johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,008 rows where confirmed = 227 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 27
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487424 | 487424 | 2022-11-25 | China | Ningxia | 227 | 0 | 0 | 37.2692 | 106.1655 | 2022-11-26 04:21:11 | Ningxia, China | |||
3523253 | 3523253 | 2022-11-24 | China | Ningxia | 227 | 0 | 0 | 37.2692 | 106.1655 | 2022-11-25 04:21:06 | Ningxia, China | |||
3312036 | 3312036 | 2022-11-23 | China | Ningxia | 227 | 0 | 0 | 37.2692 | 106.1655 | 2022-11-24 04:21:09 | Ningxia, China | |||
253118 | 253118 | 2022-09-08 | China | Qinghai | 227 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-09 04:21:11 | Qinghai, China | |||
3546580 | 3546580 | 2022-08-08 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-09 04:20:34 | Foard, Texas, US | |
1072983 | 1072983 | 2022-08-07 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-08 04:21:08 | Foard, Texas, US | |
1943571 | 1943571 | 2022-08-06 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-07 04:20:54 | Foard, Texas, US | |
883370 | 883370 | 2022-08-05 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-06 04:20:56 | Foard, Texas, US | |
2011781 | 2011781 | 2022-08-04 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-05 04:20:52 | Foard, Texas, US | |
1101208 | 1101208 | 2022-08-03 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-04 04:20:58 | Foard, Texas, US | |
1408133 | 1408133 | 2022-08-02 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-03 04:20:59 | Foard, Texas, US | |
3620171 | 3620171 | 2022-08-01 | US | Texas | Foard | 48155 | 227 | 11 | 0 | 33.97308618 | -99.7767797 | 2022-08-02 04:20:53 | Foard, Texas, US | |
2242562 | 2242562 | 2022-06-28 | US | Texas | Loving | 48301 | 227 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-29 04:20:59 | Loving, Texas, US | |
2150804 | 2150804 | 2022-06-27 | US | Texas | Loving | 48301 | 227 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-28 04:20:58 | Loving, Texas, US | |
3160770 | 3160770 | 2022-06-09 | US | Texas | Jeff Davis | 48243 | 227 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-06-10 04:20:55 | Jeff Davis, Texas, US | |
1424237 | 1424237 | 2022-06-08 | US | Texas | Jeff Davis | 48243 | 227 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-06-09 04:20:54 | Jeff Davis, Texas, US | |
3729351 | 3729351 | 2022-06-07 | US | Texas | Jeff Davis | 48243 | 227 | 9 | 0 | 30.71490589 | -104.1399973 | 2022-06-08 04:20:55 | Jeff Davis, Texas, US | |
3889621 | 3889621 | 2022-06-06 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-06-07 04:21:08 | Garfield, Montana, US | |
3509390 | 3509390 | 2022-06-05 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-06-06 04:20:57 | Garfield, Montana, US | |
3529467 | 3529467 | 2022-06-04 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-06-05 04:20:55 | Garfield, Montana, US | |
3135553 | 3135553 | 2022-06-03 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-06-04 04:20:58 | Garfield, Montana, US | |
3134208 | 3134208 | 2022-06-03 | US | Colorado | San Juan | 8111 | 227 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-06-04 04:20:58 | San Juan, Colorado, US | |
3580628 | 3580628 | 2022-06-02 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-06-03 04:20:58 | Garfield, Montana, US | |
972921 | 972921 | 2022-06-01 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-06-02 05:20:39 | Garfield, Montana, US | |
231228 | 231228 | 2022-05-31 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-06-01 04:20:55 | Garfield, Montana, US | |
3187993 | 3187993 | 2022-05-30 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-05-31 04:20:51 | Garfield, Montana, US | |
3200142 | 3200142 | 2022-05-29 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-05-30 04:20:50 | Garfield, Montana, US | |
2727020 | 2727020 | 2022-05-28 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-05-29 04:20:53 | Garfield, Montana, US | |
1316201 | 1316201 | 2022-05-27 | US | Montana | Garfield | 30033 | 227 | 3 | 0 | 47.27545948 | -107.0002351 | 2022-05-28 04:21:07 | Garfield, Montana, US | |
1285173 | 1285173 | 2022-01-05 | US | Texas | Motley | 48345 | 227 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2022-01-06 04:22:09 | Motley, Texas, US | |
1287314 | 1287314 | 2022-01-04 | US | Kansas | Lane | 20101 | 227 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2022-01-05 04:21:59 | Lane, Kansas, US | |
1701658 | 1701658 | 2022-01-03 | US | Kansas | Lane | 20101 | 227 | 8 | 0 | 38.48119447 | -100.46607540000001 | 2022-01-04 04:22:17 | Lane, Kansas, US | |
3520017 | 3520017 | 2022-01-02 | US | California | Sierra | 6091 | 227 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-01-03 02:22:25 | Sierra, California, US | |
2168147 | 2168147 | 2022-01-01 | US | California | Sierra | 6091 | 227 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-01-02 04:20:52 | Sierra, California, US | |
2777578 | 2777578 | 2021-12-31 | US | California | Sierra | 6091 | 227 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-01-01 04:22:14 | Sierra, California, US | |
3999235 | 3999235 | 2021-12-30 | US | California | Sierra | 6091 | 227 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-31 04:21:50 | Sierra, California, US | |
1669042 | 1669042 | 2021-12-29 | US | California | Sierra | 6091 | 227 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-30 04:21:25 | Sierra, California, US | |
1433151 | 1433151 | 2021-12-28 | US | California | Sierra | 6091 | 227 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-29 03:21:43 | Sierra, California, US | |
731112 | 731112 | 2021-12-27 | US | California | Sierra | 6091 | 227 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-12-28 04:21:47 | Sierra, California, US | |
2112141 | 2112141 | 2021-12-26 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-27 04:21:58 | Wrangell, Alaska, US | |
3605513 | 3605513 | 2021-12-25 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-26 04:21:50 | Wrangell, Alaska, US | |
2963831 | 2963831 | 2021-12-24 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-25 04:21:37 | Wrangell, Alaska, US | |
3816863 | 3816863 | 2021-12-23 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-24 04:21:34 | Wrangell, Alaska, US | |
798871 | 798871 | 2021-12-22 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-23 04:21:21 | Wrangell, Alaska, US | |
3828911 | 3828911 | 2021-12-21 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-22 04:21:54 | Wrangell, Alaska, US | |
1255214 | 1255214 | 2021-12-20 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-21 03:21:27 | Wrangell, Alaska, US | |
2904157 | 2904157 | 2021-12-19 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-20 04:21:43 | Wrangell, Alaska, US | |
1259230 | 1259230 | 2021-12-18 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-19 04:21:11 | Wrangell, Alaska, US | |
2399258 | 2399258 | 2021-12-17 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-18 02:22:20 | Wrangell, Alaska, US | |
1716796 | 1716796 | 2021-12-16 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-17 04:22:14 | Wrangell, Alaska, US | |
3496630 | 3496630 | 2021-12-15 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-16 04:22:11 | Wrangell, Alaska, US | |
2088415 | 2088415 | 2021-12-14 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-15 03:22:16 | Wrangell, Alaska, US | |
782832 | 782832 | 2021-12-13 | US | Alaska | Wrangell | 2275 | 227 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2021-12-14 04:22:38 | Wrangell, Alaska, US | |
1147078 | 1147078 | 2021-12-01 | US | Nevada | Storey | 32029 | 227 | 6 | 0 | 39.44875482 | -119.5250207 | 2021-12-02 04:22:37 | Storey, Nevada, US | |
3290980 | 3290980 | 2021-11-18 | US | Nebraska | Deuel | 31049 | 227 | 1 | 0 | 41.11168186 | -102.33333309999999 | 2021-11-19 04:21:40 | Deuel, Nebraska, US | |
447978 | 447978 | 2021-11-17 | US | Colorado | Cheyenne | 8017 | 227 | 8 | 0 | 38.82777431 | -102.6032558 | 2021-11-18 04:21:33 | Cheyenne, Colorado, US | |
716448 | 716448 | 2021-11-12 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-13 04:21:38 | Worth, Missouri, US | |
30398 | 30398 | 2021-11-11 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-12 04:22:01 | Worth, Missouri, US | |
2846837 | 2846837 | 2021-11-10 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-11 04:21:45 | Worth, Missouri, US | |
89107 | 89107 | 2021-11-09 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-10 04:21:38 | Worth, Missouri, US | |
3641628 | 3641628 | 2021-11-08 | US | Nebraska | Garden | 31069 | 227 | 1 | 0 | 41.61703149 | -102.3313973 | 2021-11-09 04:21:36 | Garden, Nebraska, US | |
3641535 | 3641535 | 2021-11-08 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-09 04:21:36 | Worth, Missouri, US | |
2002643 | 2002643 | 2021-11-07 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-08 04:21:43 | Worth, Missouri, US | |
497634 | 497634 | 2021-11-06 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-07 04:21:53 | Worth, Missouri, US | |
3123489 | 3123489 | 2021-11-05 | US | Missouri | Worth | 29227 | 227 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-11-06 04:21:51 | Worth, Missouri, US | |
698086 | 698086 | 2021-11-04 | Australia | Northern Territory | 227 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-05 04:21:54 | Northern Territory, Australia | |||
3514631 | 3514631 | 2021-11-01 | US | Texas | Stonewall | 48433 | 227 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-11-02 04:22:03 | Stonewall, Texas, US | |
291222 | 291222 | 2021-10-31 | US | Texas | Stonewall | 48433 | 227 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-11-01 04:22:01 | Stonewall, Texas, US | |
2724228 | 2724228 | 2021-10-30 | US | Texas | Stonewall | 48433 | 227 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-31 04:22:08 | Stonewall, Texas, US | |
570330 | 570330 | 2021-10-29 | US | Texas | Stonewall | 48433 | 227 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-30 04:22:03 | Stonewall, Texas, US | |
493827 | 493827 | 2021-10-14 | US | New Mexico | De Baca | 35011 | 227 | 3 | 0 | 34.34274529 | -104.4117842 | 2021-10-15 04:21:26 | De Baca, New Mexico, US | |
635971 | 635971 | 2021-10-13 | US | Nebraska | Boyd | 31015 | 227 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2021-10-14 04:21:29 | Boyd, Nebraska, US | |
1493649 | 1493649 | 2021-10-12 | US | Nebraska | Boyd | 31015 | 227 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2021-10-13 04:20:51 | Boyd, Nebraska, US | |
1492025 | 1492025 | 2021-10-12 | US | Alaska | Haines | 2100 | 227 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-10-13 04:20:51 | Haines, Alaska, US | |
3009411 | 3009411 | 2021-10-11 | US | Nebraska | Gosper | 31073 | 227 | 5 | 0 | 40.51481965 | -99.83020279 | 2021-10-12 04:21:09 | Gosper, Nebraska, US | |
425427 | 425427 | 2021-10-10 | US | Nebraska | Gosper | 31073 | 227 | 5 | 0 | 40.51481965 | -99.83020279 | 2021-10-11 04:21:31 | Gosper, Nebraska, US | |
425001 | 425001 | 2021-10-10 | US | Michigan | Keweenaw | 26083 | 227 | 4 | 0 | 47.63197653 | -88.41434263 | 2021-10-11 04:21:31 | Keweenaw, Michigan, US | |
2878284 | 2878284 | 2021-10-09 | US | Nebraska | Gosper | 31073 | 227 | 5 | 0 | 40.51481965 | -99.83020279 | 2021-10-10 04:21:38 | Gosper, Nebraska, US | |
2877858 | 2877858 | 2021-10-09 | US | Michigan | Keweenaw | 26083 | 227 | 4 | 0 | 47.63197653 | -88.41434263 | 2021-10-10 04:21:38 | Keweenaw, Michigan, US | |
2961450 | 2961450 | 2021-10-08 | US | Nebraska | Gosper | 31073 | 227 | 5 | 0 | 40.51481965 | -99.83020279 | 2021-10-09 04:21:34 | Gosper, Nebraska, US | |
2961024 | 2961024 | 2021-10-08 | US | Michigan | Keweenaw | 26083 | 227 | 4 | 0 | 47.63197653 | -88.41434263 | 2021-10-09 04:21:34 | Keweenaw, Michigan, US | |
1276356 | 1276356 | 2021-10-03 | US | Nebraska | Dundy | 31057 | 227 | 4 | 0 | 40.17638677 | -101.6876522 | 2021-10-04 04:21:31 | Dundy, Nebraska, US | |
3930109 | 3930109 | 2021-10-02 | US | Nebraska | Dundy | 31057 | 227 | 4 | 0 | 40.17638677 | -101.6876522 | 2021-10-03 04:21:24 | Dundy, Nebraska, US | |
2134089 | 2134089 | 2021-10-01 | US | Nebraska | Dundy | 31057 | 227 | 4 | 0 | 40.17638677 | -101.6876522 | 2021-10-02 04:21:25 | Dundy, Nebraska, US | |
2775046 | 2775046 | 2021-09-30 | US | Nebraska | Dundy | 31057 | 227 | 4 | 0 | 40.17638677 | -101.6876522 | 2021-10-01 04:21:35 | Dundy, Nebraska, US | |
708502 | 708502 | 2021-09-29 | US | Nebraska | Dundy | 31057 | 227 | 4 | 0 | 40.17638677 | -101.6876522 | 2021-09-30 04:21:20 | Dundy, Nebraska, US | |
708426 | 708426 | 2021-09-29 | US | Montana | Daniels | 30019 | 227 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2021-09-30 04:21:20 | Daniels, Montana, US | |
1336344 | 1336344 | 2021-09-28 | US | Nebraska | Dundy | 31057 | 227 | 4 | 0 | 40.17638677 | -101.6876522 | 2021-09-29 04:21:45 | Dundy, Nebraska, US | |
811611 | 811611 | 2021-09-20 | US | Montana | Wheatland | 30107 | 227 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-21 04:21:26 | Wheatland, Montana, US | |
1816810 | 1816810 | 2021-09-19 | US | Montana | Wheatland | 30107 | 227 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-20 04:21:22 | Wheatland, Montana, US | |
18390 | 18390 | 2021-09-18 | US | Montana | Wheatland | 30107 | 227 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-19 04:21:34 | Wheatland, Montana, US | |
2620075 | 2620075 | 2021-09-17 | US | Montana | Wheatland | 30107 | 227 | 9 | 0 | 46.46652491 | -109.84646359999999 | 2021-09-18 04:21:24 | Wheatland, Montana, US | |
2812210 | 2812210 | 2021-09-16 | US | Washington | Wahkiakum | 53069 | 227 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2021-09-17 04:21:46 | Wahkiakum, Washington, US | |
2465184 | 2465184 | 2021-09-14 | US | North Dakota | Divide | 38023 | 227 | 2 | 0 | 48.814938700000006 | -103.48736109999999 | 2021-09-15 03:22:37 | Divide, North Dakota, US | |
1263650 | 1263650 | 2021-09-09 | US | Georgia | Quitman | 13239 | 227 | 3 | 0 | 31.86728114 | -85.01773177 | 2021-09-10 04:21:20 | Quitman, Georgia, US | |
2280020 | 2280020 | 2021-09-08 | US | Georgia | Quitman | 13239 | 227 | 3 | 0 | 31.86728114 | -85.01773177 | 2021-09-09 04:21:27 | Quitman, Georgia, US | |
251682 | 251682 | 2021-09-04 | US | North Dakota | Grant | 38037 | 227 | 7 | 0 | 46.35821257 | -101.63900129999999 | 2021-09-05 04:21:33 | Grant, North Dakota, US | |
3976963 | 3976963 | 2021-09-03 | US | North Dakota | Grant | 38037 | 227 | 7 | 0 | 46.35821257 | -101.63900129999999 | 2021-09-04 04:21:28 | Grant, North Dakota, US | |
180425 | 180425 | 2021-09-02 | US | North Dakota | Grant | 38037 | 227 | 7 | 0 | 46.35821257 | -101.63900129999999 | 2021-09-03 04:21:20 | Grant, North Dakota, US | |
69460 | 69460 | 2021-09-01 | US | North Dakota | Grant | 38037 | 227 | 7 | 0 | 46.35821257 | -101.63900129999999 | 2021-09-02 04:21:15 | Grant, North Dakota, 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]);