johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
895 rows where confirmed = 303 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755551 | 2755551 | 2022-12-29 | US | Oregon | Wheeler | 41069 | 303 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-30 04:21:04 | Wheeler, Oregon, US | |
1076557 | 1076557 | 2022-12-28 | US | Oregon | Wheeler | 41069 | 303 | 3 | 0 | 44.72698162 | -120.0281427 | 2022-12-29 04:21:01 | Wheeler, Oregon, US | |
2559448 | 2559448 | 2022-11-29 | US | South Dakota | Campbell | 46021 | 303 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-11-30 04:21:07 | Campbell, South Dakota, US | |
1242522 | 1242522 | 2022-11-28 | US | South Dakota | Campbell | 46021 | 303 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-11-29 04:21:05 | Campbell, South Dakota, US | |
3554510 | 3554510 | 2022-11-27 | US | South Dakota | Campbell | 46021 | 303 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-11-28 04:21:02 | Campbell, South Dakota, US | |
2102990 | 2102990 | 2022-11-26 | US | South Dakota | Campbell | 46021 | 303 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-11-27 04:21:05 | Campbell, South Dakota, US | |
490481 | 490481 | 2022-11-25 | US | South Dakota | Campbell | 46021 | 303 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-11-26 04:21:11 | Campbell, South Dakota, US | |
3526310 | 3526310 | 2022-11-24 | US | South Dakota | Campbell | 46021 | 303 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-11-25 04:21:06 | Campbell, South Dakota, US | |
3315093 | 3315093 | 2022-11-23 | US | South Dakota | Campbell | 46021 | 303 | 7 | 0 | 45.77074915 | -100.0510181 | 2022-11-24 04:21:09 | Campbell, South Dakota, US | |
2275154 | 2275154 | 2022-10-20 | US | Texas | Sterling | 48431 | 303 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-10-21 04:22:23 | Sterling, Texas, US | |
201489 | 201489 | 2022-10-19 | US | Texas | Sterling | 48431 | 303 | 9 | 0 | 31.82781912 | -101.0500746 | 2022-10-20 04:22:59 | Sterling, Texas, US | |
1811435 | 1811435 | 2022-10-05 | US | Colorado | San Juan | 8111 | 303 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-10-06 04:21:22 | San Juan, Colorado, US | |
131409 | 131409 | 2022-10-04 | US | Colorado | San Juan | 8111 | 303 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-10-05 04:23:06 | San Juan, Colorado, US | |
420585 | 420585 | 2022-09-18 | US | Iowa | Unassigned | 90019 | 303 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-19 04:21:49 | Unassigned, Iowa, US | |
3374609 | 3374609 | 2022-09-17 | US | Iowa | Unassigned | 90019 | 303 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-18 04:22:50 | Unassigned, Iowa, US | |
2356717 | 2356717 | 2022-09-16 | US | Iowa | Unassigned | 90019 | 303 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-17 04:20:19 | Unassigned, Iowa, US | |
3987874 | 3987874 | 2022-09-15 | US | Iowa | Unassigned | 90019 | 303 | 0 | 0 | 43.38107862 | 0.0 | 2022-09-16 04:21:19 | Unassigned, Iowa, US | |
3777091 | 3777091 | 2022-08-30 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-31 04:20:57 | Motley, Texas, US | |
1683687 | 1683687 | 2022-08-29 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-30 04:21:03 | Motley, Texas, US | |
1880171 | 1880171 | 2022-08-28 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-29 04:21:06 | Motley, Texas, US | |
2099298 | 2099298 | 2022-08-27 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-28 04:21:02 | Motley, Texas, US | |
1535113 | 1535113 | 2022-08-26 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-27 04:20:57 | Motley, Texas, US | |
2832000 | 2832000 | 2022-08-25 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-26 04:21:02 | Motley, Texas, US | |
2326533 | 2326533 | 2022-08-24 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-25 04:21:13 | Motley, Texas, US | |
1253942 | 1253942 | 2022-08-23 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-24 04:20:46 | Motley, Texas, US | |
2856046 | 2856046 | 2022-08-22 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-23 04:20:56 | Motley, Texas, US | |
2406018 | 2406018 | 2022-08-21 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-22 04:20:38 | Motley, Texas, US | |
3801096 | 3801096 | 2022-08-20 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-21 04:20:44 | Motley, Texas, US | |
2366682 | 2366682 | 2022-08-19 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-20 04:21:01 | Motley, Texas, US | |
1164353 | 1164353 | 2022-08-18 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-19 04:20:54 | Motley, Texas, US | |
3953677 | 3953677 | 2022-08-17 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-18 04:21:11 | Motley, Texas, US | |
994179 | 994179 | 2022-08-16 | US | Texas | Motley | 48345 | 303 | 13 | 0 | 34.07408766 | -100.779722 | 2022-08-17 04:20:59 | Motley, Texas, US | |
2496653 | 2496653 | 2022-08-15 | US | Oregon | Gilliam | 41021 | 303 | 6 | 0 | 45.37160076 | -120.2048869 | 2022-08-16 04:20:58 | Gilliam, Oregon, US | |
1211343 | 1211343 | 2022-07-11 | China | Hainan | 303 | 6 | 0 | 19.1959 | 109.7453 | 2022-07-12 04:20:51 | Hainan, China | |||
3968978 | 3968978 | 2022-07-05 | US | North Dakota | Sheridan | 38083 | 303 | 7 | 0 | 47.57700669 | -100.3426391 | 2022-07-06 04:20:58 | Sheridan, North Dakota, US | |
876073 | 876073 | 2022-03-27 | China | Shanxi | 303 | 0 | 0 | 37.5777 | 112.2922 | 2022-03-28 04:20:33 | Shanxi, China | |||
2163356 | 2163356 | 2022-03-26 | China | Shanxi | 303 | 0 | 0 | 37.5777 | 112.2922 | 2022-03-27 04:20:47 | Shanxi, China | |||
1720292 | 1720292 | 2022-03-25 | China | Shanxi | 303 | 0 | 0 | 37.5777 | 112.2922 | 2022-03-26 04:20:23 | Shanxi, China | |||
944975 | 944975 | 2022-02-28 | US | Nevada | Eureka | 32011 | 303 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2022-03-01 04:21:09 | Eureka, Nevada, US | |
3823319 | 3823319 | 2022-02-16 | US | South Dakota | Hyde | 46069 | 303 | 7 | 0 | 44.54747703 | -99.48572582 | 2022-02-17 04:20:56 | Hyde, South Dakota, US | |
2644634 | 2644634 | 2022-02-14 | US | South Dakota | Hyde | 46069 | 303 | 6 | 0 | 44.54747703 | -99.48572582 | 2022-02-15 04:21:09 | Hyde, South Dakota, US | |
2644389 | 2644389 | 2022-02-14 | US | Oregon | Sherman | 41055 | 303 | 3 | 0 | 45.41501554 | -120.6827834 | 2022-02-15 04:21:09 | Sherman, Oregon, US | |
188951 | 188951 | 2022-02-13 | US | South Dakota | Hyde | 46069 | 303 | 6 | 0 | 44.54747703 | -99.48572582 | 2022-02-14 04:20:51 | Hyde, South Dakota, US | |
318797 | 318797 | 2022-02-12 | US | South Dakota | Hyde | 46069 | 303 | 6 | 0 | 44.54747703 | -99.48572582 | 2022-02-13 04:21:00 | Hyde, South Dakota, US | |
236123 | 236123 | 2022-02-11 | US | South Dakota | Hyde | 46069 | 303 | 6 | 0 | 44.54747703 | -99.48572582 | 2022-02-12 04:21:06 | Hyde, South Dakota, US | |
73156 | 73156 | 2022-02-07 | US | Nebraska | Deuel | 31049 | 303 | 1 | 0 | 41.11168186 | -102.33333309999999 | 2022-02-08 04:21:15 | Deuel, Nebraska, US | |
3062583 | 3062583 | 2022-01-29 | US | California | Sierra | 6091 | 303 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-01-30 04:21:26 | Sierra, California, US | |
3810517 | 3810517 | 2022-01-28 | US | California | Sierra | 6091 | 303 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2022-01-29 04:21:10 | Sierra, California, US | |
1321442 | 1321442 | 2022-01-26 | US | Texas | Stonewall | 48433 | 303 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-01-27 04:21:19 | Stonewall, Texas, US | |
2055239 | 2055239 | 2022-01-25 | US | Virginia | Highland | 51091 | 303 | 5 | 0 | 38.35799465 | -79.56124594 | 2022-01-26 04:21:07 | Highland, Virginia, US | |
2055110 | 2055110 | 2022-01-25 | US | Texas | Stonewall | 48433 | 303 | 7 | 0 | 33.17906744 | -100.25384009999999 | 2022-01-26 04:21:07 | Stonewall, Texas, US | |
1230031 | 1230031 | 2022-01-24 | US | North Dakota | Oliver | 38065 | 303 | 4 | 0 | 47.11530482 | -101.3406158 | 2022-01-25 04:21:05 | Oliver, North Dakota, US | |
1142988 | 1142988 | 2022-01-23 | US | Nebraska | Garden | 31069 | 303 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-01-24 04:21:12 | Garden, Nebraska, US | |
2834906 | 2834906 | 2022-01-22 | US | Nebraska | Garden | 31069 | 303 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-01-23 04:21:13 | Garden, Nebraska, US | |
3427024 | 3427024 | 2022-01-21 | US | Nebraska | Garden | 31069 | 303 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-01-22 04:21:13 | Garden, Nebraska, US | |
1474125 | 1474125 | 2022-01-17 | US | Montana | Liberty | 30051 | 303 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-18 04:21:04 | Liberty, Montana, US | |
556799 | 556799 | 2022-01-16 | US | Montana | Liberty | 30051 | 303 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-17 04:21:08 | Liberty, Montana, US | |
3842520 | 3842520 | 2022-01-15 | US | Montana | Liberty | 30051 | 303 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-16 04:21:12 | Liberty, Montana, US | |
3841140 | 3841140 | 2022-01-15 | US | Colorado | Kiowa | 8061 | 303 | 5 | 0 | 38.43260896 | -102.7392145 | 2022-01-16 04:21:12 | Kiowa, Colorado, US | |
101335 | 101335 | 2022-01-14 | US | Montana | Liberty | 30051 | 303 | 2 | 0 | 48.56084317 | -111.02430700000001 | 2022-01-15 04:21:07 | Liberty, Montana, US | |
99955 | 99955 | 2022-01-14 | US | Colorado | Kiowa | 8061 | 303 | 5 | 0 | 38.43260896 | -102.7392145 | 2022-01-15 04:21:07 | Kiowa, Colorado, US | |
3689550 | 3689550 | 2022-01-13 | US | Nebraska | Dundy | 31057 | 303 | 4 | 0 | 40.17638677 | -101.6876522 | 2022-01-14 04:21:54 | Dundy, Nebraska, US | |
3688110 | 3688110 | 2022-01-13 | US | Colorado | Kiowa | 8061 | 303 | 5 | 0 | 38.43260896 | -102.7392145 | 2022-01-14 04:21:54 | Kiowa, Colorado, US | |
1114011 | 1114011 | 2022-01-11 | US | Alaska | Denali | 2068 | 303 | 1 | 0 | 63.67264044 | -150.0076108 | 2022-01-12 04:21:44 | Denali, Alaska, US | |
1692739 | 1692739 | 2022-01-10 | US | Alaska | Denali | 2068 | 303 | 1 | 0 | 63.67264044 | -150.0076108 | 2022-01-11 04:22:01 | Denali, Alaska, US | |
2612325 | 2612325 | 2022-01-06 | US | New York | Unassigned | 90036 | 303 | 1 | 0 | 44.74530905 | 0.0 | 2022-01-07 04:22:09 | Unassigned, New York, US | |
1282605 | 1282605 | 2022-01-05 | US | Colorado | Dolores | 8033 | 303 | 7 | 0 | 37.75208676 | -108.5211585 | 2022-01-06 04:22:09 | Dolores, Colorado, US | |
1288795 | 1288795 | 2022-01-04 | US | Puerto Rico | Vieques | 72147 | 303 | 0 | 0 | 18.123276 | -65.44097099999999 | 2022-01-05 04:21:59 | Vieques, Puerto Rico, US | |
1286448 | 1286448 | 2022-01-04 | US | Alaska | Yakutat | 2282 | 303 | 3 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-01-05 04:21:59 | Yakutat, Alaska, US | |
1703139 | 1703139 | 2022-01-03 | US | Puerto Rico | Vieques | 72147 | 303 | 0 | 0 | 18.123276 | -65.44097099999999 | 2022-01-04 04:22:17 | Vieques, Puerto Rico, US | |
1700792 | 1700792 | 2022-01-03 | US | Alaska | Yakutat | 2282 | 303 | 3 | 0 | 59.890980799999994 | -140.36014509999998 | 2022-01-04 04:22:17 | Yakutat, Alaska, US | |
3498237 | 3498237 | 2021-12-15 | US | Nebraska | Boyd | 31015 | 303 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2021-12-16 04:22:11 | Boyd, Nebraska, US | |
2090022 | 2090022 | 2021-12-14 | US | Nebraska | Boyd | 31015 | 303 | 3 | 0 | 42.899727399999996 | -98.76486568 | 2021-12-15 03:22:16 | Boyd, Nebraska, US | |
1666424 | 1666424 | 2021-12-11 | US | Missouri | Worth | 29227 | 303 | 2 | 0 | 40.47945588 | -94.42328751 | 2021-12-12 04:22:12 | Worth, Missouri, US | |
3795 | 3795 | 2021-12-02 | US | Washington | Wahkiakum | 53069 | 303 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2021-12-03 04:23:05 | Wahkiakum, Washington, US | |
1146922 | 1146922 | 2021-12-01 | US | Montana | Daniels | 30019 | 303 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2021-12-02 04:22:37 | Daniels, Montana, US | |
3403434 | 3403434 | 2021-11-30 | US | Montana | Daniels | 30019 | 303 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2021-12-01 04:22:29 | Daniels, Montana, US | |
151977 | 151977 | 2021-11-29 | US | Montana | Daniels | 30019 | 303 | 9 | 0 | 48.78420029 | -105.54763429999998 | 2021-11-30 04:22:53 | Daniels, Montana, US | |
3291797 | 3291797 | 2021-11-18 | US | South Dakota | Jerauld | 46073 | 303 | 17 | 0 | 44.06637798 | -98.62965972 | 2021-11-19 04:21:40 | Jerauld, South Dakota, US | |
450253 | 450253 | 2021-11-17 | US | South Dakota | Jerauld | 46073 | 303 | 17 | 0 | 44.06637798 | -98.62965972 | 2021-11-18 04:21:33 | Jerauld, South Dakota, US | |
3343973 | 3343973 | 2021-11-16 | US | Kansas | Stanton | 20187 | 303 | 6 | 0 | 37.56304714 | -101.78435340000001 | 2021-11-17 04:21:48 | Stanton, Kansas, US | |
2288809 | 2288809 | 2021-11-15 | US | Kansas | Stanton | 20187 | 303 | 6 | 0 | 37.56304714 | -101.78435340000001 | 2021-11-16 04:21:10 | Stanton, Kansas, US | |
2846937 | 2846937 | 2021-11-10 | US | Nebraska | Harlan | 31083 | 303 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-11 04:21:45 | Harlan, Nebraska, US | |
89207 | 89207 | 2021-11-09 | US | Nebraska | Harlan | 31083 | 303 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-10 04:21:38 | Harlan, Nebraska, US | |
88486 | 88486 | 2021-11-09 | US | Kansas | Wichita | 20203 | 303 | 6 | 0 | 38.48178252 | -101.3471509 | 2021-11-10 04:21:38 | Wichita, Kansas, US | |
3641635 | 3641635 | 2021-11-08 | US | Nebraska | Harlan | 31083 | 303 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-11-09 04:21:36 | Harlan, Nebraska, US | |
3640914 | 3640914 | 2021-11-08 | US | Kansas | Wichita | 20203 | 303 | 6 | 0 | 38.48178252 | -101.3471509 | 2021-11-09 04:21:36 | Wichita, Kansas, US | |
44990 | 44990 | 2021-11-02 | US | Kansas | Elk | 20049 | 303 | 6 | 0 | 37.45338105 | -96.24369667 | 2021-11-03 06:22:09 | Elk, Kansas, US | |
3512686 | 3512686 | 2021-11-01 | US | Kansas | Elk | 20049 | 303 | 6 | 0 | 37.45338105 | -96.24369667 | 2021-11-02 04:22:03 | Elk, Kansas, US | |
4779 | 4779 | 2021-10-28 | US | Alaska | Petersburg | 2195 | 303 | 3 | 0 | 57.13978948 | -132.9540995 | 2021-10-29 04:22:03 | Petersburg, Alaska, US | |
1495058 | 1495058 | 2021-10-12 | US | Washington | San Juan | 53055 | 303 | 0 | 0 | 48.60182783 | -122.96745 | 2021-10-13 04:20:51 | San Juan, Washington, US | |
2461684 | 2461684 | 2021-10-06 | US | South Dakota | Mellette | 46095 | 303 | 2 | 0 | 43.58078848 | -100.7563186 | 2021-10-07 04:21:36 | Mellette, South Dakota, US | |
3835377 | 3835377 | 2021-10-05 | US | South Dakota | Mellette | 46095 | 303 | 2 | 0 | 43.58078848 | -100.7563186 | 2021-10-06 04:21:33 | Mellette, South Dakota, US | |
987904 | 987904 | 2021-10-04 | US | Idaho | Butte | 16023 | 303 | 3 | 0 | 43.72592209 | -113.1735463 | 2021-10-05 04:21:27 | Butte, Idaho, US | |
1336676 | 1336676 | 2021-09-28 | US | North Dakota | Golden Valley | 38033 | 303 | 4 | 0 | 46.94022281 | -103.8465421 | 2021-09-29 04:21:45 | Golden Valley, North Dakota, US | |
1335577 | 1335577 | 2021-09-28 | US | Kansas | Jewell | 20089 | 303 | 6 | 0 | 39.78470589 | -98.21820662 | 2021-09-29 04:21:45 | Jewell, Kansas, US | |
1239080 | 1239080 | 2021-09-27 | US | Washington | Columbia | 53013 | 303 | 6 | 0 | 46.29442881 | -117.9051983 | 2021-09-28 04:21:28 | Columbia, Washington, US | |
1236946 | 1236946 | 2021-09-27 | US | Kansas | Jewell | 20089 | 303 | 6 | 0 | 39.78470589 | -98.21820662 | 2021-09-28 04:21:28 | Jewell, Kansas, US | |
2079557 | 2079557 | 2021-09-26 | US | Wyoming | Niobrara | 56027 | 303 | 4 | 0 | 43.05607708 | -104.47588959999999 | 2021-09-27 04:21:16 | Niobrara, Wyoming, US | |
2078353 | 2078353 | 2021-09-26 | US | North Dakota | Logan | 38047 | 303 | 10 | 0 | 46.45729487 | -99.47719806 | 2021-09-27 04:21:16 | Logan, 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]);