johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
662 rows where confirmed = 869 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3175725 | 3175725 | 2022-12-19 | US | Missouri | Mercer | 29129 | 869 | 15 | 0 | 40.42212303 | -93.5682959 | 2022-12-20 04:21:04 | Mercer, Missouri, US | |
1630242 | 1630242 | 2022-12-18 | US | Missouri | Mercer | 29129 | 869 | 15 | 0 | 40.42212303 | -93.5682959 | 2022-12-19 04:21:03 | Mercer, Missouri, US | |
505621 | 505621 | 2022-12-17 | US | Missouri | Mercer | 29129 | 869 | 15 | 0 | 40.42212303 | -93.5682959 | 2022-12-18 04:21:03 | Mercer, Missouri, US | |
3326193 | 3326193 | 2022-12-16 | US | Missouri | Mercer | 29129 | 869 | 15 | 0 | 40.42212303 | -93.5682959 | 2022-12-17 04:21:04 | Mercer, Missouri, US | |
544705 | 544705 | 2022-12-15 | US | Missouri | Mercer | 29129 | 869 | 15 | 0 | 40.42212303 | -93.5682959 | 2022-12-16 04:21:01 | Mercer, Missouri, US | |
350233 | 350233 | 2022-12-14 | US | Missouri | Mercer | 29129 | 869 | 15 | 0 | 40.42212303 | -93.5682959 | 2022-12-15 04:20:58 | Mercer, Missouri, US | |
309821 | 309821 | 2022-12-13 | US | Missouri | Mercer | 29129 | 869 | 15 | 0 | 40.42212303 | -93.5682959 | 2022-12-14 04:21:04 | Mercer, Missouri, US | |
2138191 | 2138191 | 2022-12-01 | US | Montana | Sheridan | 30091 | 869 | 13 | 0 | 48.72085833 | -104.503829 | 2022-12-02 04:21:07 | Sheridan, Montana, US | |
1966607 | 1966607 | 2022-11-30 | US | Montana | Sheridan | 30091 | 869 | 13 | 0 | 48.72085833 | -104.503829 | 2022-12-01 04:21:03 | Sheridan, Montana, US | |
2558621 | 2558621 | 2022-11-29 | US | Montana | Sheridan | 30091 | 869 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-30 04:21:07 | Sheridan, Montana, US | |
2557948 | 2557948 | 2022-11-29 | US | Kansas | Trego | 20195 | 869 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-30 04:21:07 | Trego, Kansas, US | |
1241695 | 1241695 | 2022-11-28 | US | Montana | Sheridan | 30091 | 869 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-29 04:21:05 | Sheridan, Montana, US | |
1241022 | 1241022 | 2022-11-28 | US | Kansas | Trego | 20195 | 869 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-29 04:21:05 | Trego, Kansas, US | |
3553683 | 3553683 | 2022-11-27 | US | Montana | Sheridan | 30091 | 869 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-28 04:21:02 | Sheridan, Montana, US | |
3553010 | 3553010 | 2022-11-27 | US | Kansas | Trego | 20195 | 869 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-28 04:21:02 | Trego, Kansas, US | |
2102163 | 2102163 | 2022-11-26 | US | Montana | Sheridan | 30091 | 869 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-27 04:21:05 | Sheridan, Montana, US | |
2101490 | 2101490 | 2022-11-26 | US | Kansas | Trego | 20195 | 869 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-27 04:21:05 | Trego, Kansas, US | |
489654 | 489654 | 2022-11-25 | US | Montana | Sheridan | 30091 | 869 | 13 | 0 | 48.72085833 | -104.503829 | 2022-11-26 04:21:11 | Sheridan, Montana, US | |
488981 | 488981 | 2022-11-25 | US | Kansas | Trego | 20195 | 869 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-26 04:21:11 | Trego, Kansas, US | |
3524810 | 3524810 | 2022-11-24 | US | Kansas | Trego | 20195 | 869 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-25 04:21:06 | Trego, Kansas, US | |
3313593 | 3313593 | 2022-11-23 | US | Kansas | Trego | 20195 | 869 | 13 | 0 | 38.91467218 | -99.87284448 | 2022-11-24 04:21:09 | Trego, Kansas, US | |
1621626 | 1621626 | 2022-11-22 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-23 04:21:06 | Sheridan, Kansas, US | |
3461514 | 3461514 | 2022-11-21 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-22 04:20:47 | Sheridan, Kansas, US | |
1641699 | 1641699 | 2022-11-20 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-21 04:21:05 | Sheridan, Kansas, US | |
2065256 | 2065256 | 2022-11-19 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-20 04:21:08 | Sheridan, Kansas, US | |
1756650 | 1756650 | 2022-11-18 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-19 04:21:14 | Sheridan, Kansas, US | |
3027643 | 3027643 | 2022-11-17 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-18 04:21:15 | Sheridan, Kansas, US | |
2487354 | 2487354 | 2022-11-16 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-17 04:21:11 | Sheridan, Kansas, US | |
293365 | 293365 | 2022-11-15 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-16 04:21:09 | Sheridan, Kansas, US | |
3598395 | 3598395 | 2022-11-14 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-15 04:21:16 | Sheridan, Kansas, US | |
313253 | 313253 | 2022-11-13 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-14 04:21:09 | Sheridan, Kansas, US | |
64414 | 64414 | 2022-11-12 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-13 04:21:14 | Sheridan, Kansas, US | |
2928576 | 2928576 | 2022-11-11 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-12 04:20:41 | Sheridan, Kansas, US | |
2507412 | 2507412 | 2022-11-10 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-11 04:21:22 | Sheridan, Kansas, US | |
2432287 | 2432287 | 2022-11-09 | US | Kansas | Sheridan | 20179 | 869 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-11-10 04:21:16 | Sheridan, Kansas, US | |
3287320 | 3287320 | 2022-10-31 | US | North Dakota | Nelson | 38063 | 869 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-11-01 04:22:36 | Nelson, North Dakota, US | |
322353 | 322353 | 2022-10-30 | US | North Dakota | Nelson | 38063 | 869 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-10-31 04:21:36 | Nelson, North Dakota, US | |
914629 | 914629 | 2022-10-29 | US | North Dakota | Nelson | 38063 | 869 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-10-30 04:22:14 | Nelson, North Dakota, US | |
1368898 | 1368898 | 2022-10-28 | US | North Dakota | Nelson | 38063 | 869 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-10-29 04:21:13 | Nelson, North Dakota, US | |
199997 | 199997 | 2022-10-19 | US | Minnesota | Lake of the Woods | 27077 | 869 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-10-20 04:22:59 | Lake of the Woods, Minnesota, US | |
2758658 | 2758658 | 2022-10-18 | US | Minnesota | Lake of the Woods | 27077 | 869 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-10-19 04:22:26 | Lake of the Woods, Minnesota, US | |
2026492 | 2026492 | 2022-10-17 | US | Minnesota | Lake of the Woods | 27077 | 869 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-10-18 04:22:42 | Lake of the Woods, Minnesota, US | |
2161270 | 2161270 | 2022-10-16 | US | Minnesota | Lake of the Woods | 27077 | 869 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-10-17 04:20:31 | Lake of the Woods, Minnesota, US | |
517467 | 517467 | 2022-10-15 | US | Minnesota | Lake of the Woods | 27077 | 869 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-10-16 04:22:39 | Lake of the Woods, Minnesota, US | |
2034524 | 2034524 | 2022-10-14 | US | Minnesota | Lake of the Woods | 27077 | 869 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-10-15 04:22:00 | Lake of the Woods, Minnesota, US | |
3755212 | 3755212 | 2022-10-13 | US | Minnesota | Lake of the Woods | 27077 | 869 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-10-14 04:22:28 | Lake of the Woods, Minnesota, US | |
3252370 | 3252370 | 2022-10-11 | US | New Mexico | Union | 35059 | 869 | 19 | 0 | 36.48126404 | -103.4709624 | 2022-10-12 04:22:51 | Union, New Mexico, US | |
133643 | 133643 | 2022-10-04 | US | South Dakota | Marshall | 46091 | 869 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-10-05 04:23:06 | Marshall, South Dakota, US | |
2688590 | 2688590 | 2022-10-03 | US | South Dakota | Marshall | 46091 | 869 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-10-04 04:22:55 | Marshall, South Dakota, US | |
2262657 | 2262657 | 2022-10-02 | US | South Dakota | Marshall | 46091 | 869 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-10-03 04:23:11 | Marshall, South Dakota, US | |
2998183 | 2998183 | 2022-10-01 | US | South Dakota | Marshall | 46091 | 869 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-10-02 04:21:23 | Marshall, South Dakota, US | |
856509 | 856509 | 2022-09-30 | US | South Dakota | Marshall | 46091 | 869 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-10-01 04:23:01 | Marshall, South Dakota, US | |
2378435 | 2378435 | 2022-09-29 | US | South Dakota | Marshall | 46091 | 869 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-30 04:23:09 | Marshall, South Dakota, US | |
1562986 | 1562986 | 2022-09-28 | US | South Dakota | Marshall | 46091 | 869 | 14 | 0 | 45.75870838 | -97.59855639 | 2022-09-29 04:22:34 | Marshall, South Dakota, US | |
116055 | 116055 | 2022-09-06 | US | Kansas | Jewell | 20089 | 869 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-07 04:20:59 | Jewell, Kansas, US | |
116042 | 116042 | 2022-09-06 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-09-07 04:20:59 | Gove, Kansas, US | |
2635027 | 2635027 | 2022-09-05 | US | Kansas | Jewell | 20089 | 869 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-06 04:21:02 | Jewell, Kansas, US | |
2635014 | 2635014 | 2022-09-05 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-09-06 04:21:02 | Gove, Kansas, US | |
2988591 | 2988591 | 2022-09-04 | US | Kansas | Jewell | 20089 | 869 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-05 04:21:01 | Jewell, Kansas, US | |
2988578 | 2988578 | 2022-09-04 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-09-05 04:21:01 | Gove, Kansas, US | |
2714276 | 2714276 | 2022-09-03 | US | Kansas | Jewell | 20089 | 869 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-04 04:21:22 | Jewell, Kansas, US | |
2714263 | 2714263 | 2022-09-03 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-09-04 04:21:22 | Gove, Kansas, US | |
1394981 | 1394981 | 2022-09-02 | US | Kansas | Jewell | 20089 | 869 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-03 04:21:04 | Jewell, Kansas, US | |
1394968 | 1394968 | 2022-09-02 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-09-03 04:21:04 | Gove, Kansas, US | |
3548810 | 3548810 | 2022-09-01 | US | Kansas | Jewell | 20089 | 869 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-02 04:21:07 | Jewell, Kansas, US | |
3548797 | 3548797 | 2022-09-01 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-09-02 04:21:07 | Gove, Kansas, US | |
2344730 | 2344730 | 2022-08-31 | US | Kansas | Jewell | 20089 | 869 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-09-01 04:21:03 | Jewell, Kansas, US | |
2344717 | 2344717 | 2022-08-31 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-09-01 04:21:03 | Gove, Kansas, US | |
3775197 | 3775197 | 2022-08-30 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-08-31 04:20:57 | Gove, Kansas, US | |
3775067 | 3775067 | 2022-08-30 | US | Iowa | Adams | 19003 | 869 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-31 04:20:57 | Adams, Iowa, US | |
3774350 | 3774350 | 2022-08-30 | US | Alaska | Yakutat | 2282 | 869 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-08-31 04:20:57 | Yakutat, Alaska, US | |
1681793 | 1681793 | 2022-08-29 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-08-30 04:21:03 | Gove, Kansas, US | |
1681663 | 1681663 | 2022-08-29 | US | Iowa | Adams | 19003 | 869 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-30 04:21:03 | Adams, Iowa, US | |
1680946 | 1680946 | 2022-08-29 | US | Alaska | Yakutat | 2282 | 869 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-08-30 04:21:03 | Yakutat, Alaska, US | |
1878277 | 1878277 | 2022-08-28 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-08-29 04:21:06 | Gove, Kansas, US | |
1878147 | 1878147 | 2022-08-28 | US | Iowa | Adams | 19003 | 869 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-29 04:21:06 | Adams, Iowa, US | |
1877430 | 1877430 | 2022-08-28 | US | Alaska | Yakutat | 2282 | 869 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-08-29 04:21:06 | Yakutat, Alaska, US | |
2097404 | 2097404 | 2022-08-27 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-08-28 04:21:02 | Gove, Kansas, US | |
2097274 | 2097274 | 2022-08-27 | US | Iowa | Adams | 19003 | 869 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-28 04:21:02 | Adams, Iowa, US | |
2096557 | 2096557 | 2022-08-27 | US | Alaska | Yakutat | 2282 | 869 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-08-28 04:21:02 | Yakutat, Alaska, US | |
1533219 | 1533219 | 2022-08-26 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-08-27 04:20:57 | Gove, Kansas, US | |
1533089 | 1533089 | 2022-08-26 | US | Iowa | Adams | 19003 | 869 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-27 04:20:57 | Adams, Iowa, US | |
1532372 | 1532372 | 2022-08-26 | US | Alaska | Yakutat | 2282 | 869 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-08-27 04:20:57 | Yakutat, Alaska, US | |
2830106 | 2830106 | 2022-08-25 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-08-26 04:21:02 | Gove, Kansas, US | |
2829976 | 2829976 | 2022-08-25 | US | Iowa | Adams | 19003 | 869 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-26 04:21:02 | Adams, Iowa, US | |
2829768 | 2829768 | 2022-08-25 | US | Idaho | Oneida | 16071 | 869 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-08-26 04:21:02 | Oneida, Idaho, US | |
2829259 | 2829259 | 2022-08-25 | US | Alaska | Yakutat | 2282 | 869 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-08-26 04:21:02 | Yakutat, Alaska, US | |
2324639 | 2324639 | 2022-08-24 | US | Kansas | Gove | 20063 | 869 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-08-25 04:21:13 | Gove, Kansas, US | |
2324509 | 2324509 | 2022-08-24 | US | Iowa | Adams | 19003 | 869 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-08-25 04:21:13 | Adams, Iowa, US | |
2324301 | 2324301 | 2022-08-24 | US | Idaho | Oneida | 16071 | 869 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-08-25 04:21:13 | Oneida, Idaho, US | |
2323792 | 2323792 | 2022-08-24 | US | Alaska | Yakutat | 2282 | 869 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-08-25 04:21:13 | Yakutat, Alaska, US | |
1073062 | 1073062 | 2022-08-07 | US | Texas | Mason | 48319 | 869 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-08-08 04:21:08 | Mason, Texas, US | |
1943650 | 1943650 | 2022-08-06 | US | Texas | Mason | 48319 | 869 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-08-07 04:20:54 | Mason, Texas, US | |
883449 | 883449 | 2022-08-05 | US | Texas | Mason | 48319 | 869 | 13 | 0 | 30.71780434 | -99.22629416 | 2022-08-06 04:20:56 | Mason, Texas, US | |
1100671 | 1100671 | 2022-08-03 | US | Oklahoma | Ellis | 40045 | 869 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-04 04:20:58 | Ellis, Oklahoma, US | |
1407596 | 1407596 | 2022-08-02 | US | Oklahoma | Ellis | 40045 | 869 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-03 04:20:59 | Ellis, Oklahoma, US | |
1405479 | 1405479 | 2022-08-02 | US | Alaska | Petersburg | 2195 | 869 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-08-03 04:20:59 | Petersburg, Alaska, US | |
3619634 | 3619634 | 2022-08-01 | US | Oklahoma | Ellis | 40045 | 869 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-02 04:20:53 | Ellis, Oklahoma, US | |
3617517 | 3617517 | 2022-08-01 | US | Alaska | Petersburg | 2195 | 869 | 6 | 0 | 57.13978948 | -132.9540995 | 2022-08-02 04:20:53 | Petersburg, Alaska, US | |
3874114 | 3874114 | 2022-07-31 | US | Oklahoma | Ellis | 40045 | 869 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-08-01 04:21:03 | Ellis, Oklahoma, 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]);