johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
641 rows where confirmed = 772 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329188 | 329188 | 2022-12-27 | US | Kansas | Decatur | 20039 | 772 | 21 | 0 | 39.78468441 | -100.4594081 | 2022-12-28 04:21:04 | Decatur, Kansas, US | |
219261 | 219261 | 2022-12-26 | US | Kansas | Decatur | 20039 | 772 | 21 | 0 | 39.78468441 | -100.4594081 | 2022-12-27 04:21:07 | Decatur, Kansas, US | |
3223718 | 3223718 | 2022-12-25 | US | Kansas | Decatur | 20039 | 772 | 21 | 0 | 39.78468441 | -100.4594081 | 2022-12-26 04:21:06 | Decatur, Kansas, US | |
1019632 | 1019632 | 2022-12-24 | US | Kansas | Decatur | 20039 | 772 | 21 | 0 | 39.78468441 | -100.4594081 | 2022-12-25 04:21:04 | Decatur, Kansas, US | |
691655 | 691655 | 2022-12-23 | US | Kansas | Decatur | 20039 | 772 | 21 | 0 | 39.78468441 | -100.4594081 | 2022-12-24 04:21:02 | Decatur, Kansas, US | |
2180865 | 2180865 | 2022-12-22 | US | Kansas | Decatur | 20039 | 772 | 21 | 0 | 39.78468441 | -100.4594081 | 2022-12-23 04:21:04 | Decatur, Kansas, US | |
452669 | 452669 | 2022-12-21 | US | Kansas | Decatur | 20039 | 772 | 21 | 0 | 39.78468441 | -100.4594081 | 2022-12-22 04:20:56 | Decatur, Kansas, US | |
3717074 | 3717074 | 2022-12-06 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-07 04:20:58 | Potter, South Dakota, US | |
2417779 | 2417779 | 2022-12-05 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-06 04:21:03 | Potter, South Dakota, US | |
721387 | 721387 | 2022-12-04 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-05 04:20:58 | Potter, South Dakota, US | |
2819676 | 2819676 | 2022-12-03 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-04 04:20:56 | Potter, South Dakota, US | |
836532 | 836532 | 2022-12-02 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-03 04:21:02 | Potter, South Dakota, US | |
2139062 | 2139062 | 2022-12-01 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-02 04:21:07 | Potter, South Dakota, US | |
1967478 | 1967478 | 2022-11-30 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-12-01 04:21:03 | Potter, South Dakota, US | |
2559492 | 2559492 | 2022-11-29 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-11-30 04:21:07 | Potter, South Dakota, US | |
1242566 | 1242566 | 2022-11-28 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-11-29 04:21:05 | Potter, South Dakota, US | |
3554554 | 3554554 | 2022-11-27 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-11-28 04:21:02 | Potter, South Dakota, US | |
2103034 | 2103034 | 2022-11-26 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-11-27 04:21:05 | Potter, South Dakota, US | |
490525 | 490525 | 2022-11-25 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-11-26 04:21:11 | Potter, South Dakota, US | |
3526354 | 3526354 | 2022-11-24 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-11-25 04:21:06 | Potter, South Dakota, US | |
3315137 | 3315137 | 2022-11-23 | US | South Dakota | Potter | 46107 | 772 | 9 | 0 | 45.06583079 | -99.95498503 | 2022-11-24 04:21:09 | Potter, South Dakota, US | |
2688111 | 2688111 | 2022-10-03 | US | North Dakota | McIntosh | 38051 | 772 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-10-04 04:22:55 | McIntosh, North Dakota, US | |
1977233 | 1977233 | 2022-09-25 | US | Colorado | Custer | 8027 | 772 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-26 04:20:52 | Custer, Colorado, US | |
2650400 | 2650400 | 2022-09-24 | US | Colorado | Custer | 8027 | 772 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-25 04:23:31 | Custer, Colorado, US | |
384840 | 384840 | 2022-09-23 | US | Colorado | Custer | 8027 | 772 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-24 04:21:40 | Custer, Colorado, US | |
1624906 | 1624906 | 2022-09-22 | US | Colorado | Custer | 8027 | 772 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-23 04:23:13 | Custer, Colorado, US | |
1371110 | 1371110 | 2022-09-21 | US | Colorado | Custer | 8027 | 772 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-22 04:22:56 | Custer, Colorado, US | |
2017340 | 2017340 | 2022-09-20 | US | Colorado | Custer | 8027 | 772 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-09-21 04:23:22 | Custer, Colorado, US | |
2098514 | 2098514 | 2022-08-27 | US | North Dakota | Emmons | 38029 | 772 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-08-28 04:21:02 | Emmons, North Dakota, US | |
1534329 | 1534329 | 2022-08-26 | US | North Dakota | Emmons | 38029 | 772 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-08-27 04:20:57 | Emmons, North Dakota, US | |
1067908 | 1067908 | 2022-07-28 | US | Montana | Sheridan | 30091 | 772 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-29 04:20:45 | Sheridan, Montana, US | |
2337427 | 2337427 | 2022-07-27 | US | Montana | Sheridan | 30091 | 772 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-28 04:20:56 | Sheridan, Montana, US | |
1489617 | 1489617 | 2022-07-26 | US | Montana | Sheridan | 30091 | 772 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-27 04:21:04 | Sheridan, Montana, US | |
2596063 | 2596063 | 2022-07-25 | US | Montana | Sheridan | 30091 | 772 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-26 04:20:58 | Sheridan, Montana, US | |
898178 | 898178 | 2022-07-24 | US | Montana | Sheridan | 30091 | 772 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-25 04:20:51 | Sheridan, Montana, US | |
93172 | 93172 | 2022-07-23 | US | Montana | Sheridan | 30091 | 772 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-24 04:20:47 | Sheridan, Montana, US | |
902194 | 902194 | 2022-07-22 | US | Montana | Sheridan | 30091 | 772 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-23 04:20:53 | Sheridan, Montana, US | |
1608065 | 1608065 | 2022-07-20 | China | Macau | 772 | 5 | 0 | 22.1667 | 113.55 | 2022-07-21 04:21:10 | Macau, China | |||
2241799 | 2241799 | 2022-06-28 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-29 04:20:59 | Eddy, North Dakota, US | |
2150041 | 2150041 | 2022-06-27 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-28 04:20:58 | Eddy, North Dakota, US | |
477842 | 477842 | 2022-06-26 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-27 04:21:00 | Eddy, North Dakota, US | |
941217 | 941217 | 2022-06-25 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-26 04:21:02 | Eddy, North Dakota, US | |
3349037 | 3349037 | 2022-06-24 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-25 04:20:57 | Eddy, North Dakota, US | |
1650778 | 1650778 | 2022-06-23 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-24 04:20:58 | Eddy, North Dakota, US | |
2190013 | 2190013 | 2022-06-22 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-23 04:20:55 | Eddy, North Dakota, US | |
168444 | 168444 | 2022-06-21 | US | North Dakota | Eddy | 38027 | 772 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-06-22 04:20:54 | Eddy, North Dakota, US | |
2086164 | 2086164 | 2022-05-15 | US | New Mexico | Mora | 35033 | 772 | 18 | 0 | 36.01095101 | -104.9497716 | 2022-05-16 04:20:47 | Mora, New Mexico, US | |
3356874 | 3356874 | 2022-05-14 | US | New Mexico | Mora | 35033 | 772 | 18 | 0 | 36.01095101 | -104.9497716 | 2022-05-15 04:20:53 | Mora, New Mexico, US | |
660519 | 660519 | 2022-05-13 | US | New Mexico | Mora | 35033 | 772 | 18 | 0 | 36.01095101 | -104.9497716 | 2022-05-14 04:20:48 | Mora, New Mexico, US | |
2535602 | 2535602 | 2022-05-12 | US | New Mexico | Mora | 35033 | 772 | 18 | 0 | 36.01095101 | -104.9497716 | 2022-05-13 04:20:51 | Mora, New Mexico, US | |
3447395 | 3447395 | 2022-05-11 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-12 04:20:54 | Ellis, Oklahoma, US | |
3447048 | 3447048 | 2022-05-11 | US | New Mexico | Mora | 35033 | 772 | 18 | 0 | 36.01095101 | -104.9497716 | 2022-05-12 04:20:54 | Mora, New Mexico, US | |
3538012 | 3538012 | 2022-05-10 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-11 04:20:48 | Ellis, Oklahoma, US | |
224547 | 224547 | 2022-05-09 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-10 04:20:50 | Ellis, Oklahoma, US | |
2333932 | 2333932 | 2022-05-08 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-09 04:20:54 | Ellis, Oklahoma, US | |
362894 | 362894 | 2022-05-07 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-08 04:20:49 | Ellis, Oklahoma, US | |
1400245 | 1400245 | 2022-05-06 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-07 04:21:09 | Ellis, Oklahoma, US | |
2600600 | 2600600 | 2022-05-05 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.2180194 | -99.75324573 | 2022-05-06 04:21:00 | Ellis, Oklahoma, US | |
2445308 | 2445308 | 2022-04-13 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-13 23:21:06 | Ellis, Oklahoma, US | |
1951065 | 1951065 | 2022-04-12 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-13 04:21:03 | Ellis, Oklahoma, US | |
3208818 | 3208818 | 2022-04-11 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-12 04:20:49 | Ellis, Oklahoma, US | |
1578704 | 1578704 | 2022-04-10 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-11 04:21:02 | Ellis, Oklahoma, US | |
1654946 | 1654946 | 2022-04-09 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-10 04:20:52 | Ellis, Oklahoma, US | |
2118268 | 2118268 | 2022-04-08 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-09 04:20:42 | Ellis, Oklahoma, US | |
3322792 | 3322792 | 2022-04-07 | US | Oklahoma | Ellis | 40045 | 772 | 8 | 0 | 36.218019399999996 | -99.75324573 | 2022-04-08 04:20:48 | Ellis, Oklahoma, US | |
1061017 | 1061017 | 2022-02-23 | US | Texas | Mason | 48319 | 772 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-02-24 04:21:14 | Mason, Texas, US | |
2449940 | 2449940 | 2022-02-22 | US | Texas | Mason | 48319 | 772 | 11 | 0 | 30.71780434 | -99.22629416 | 2022-02-23 04:21:09 | Mason, Texas, US | |
2449622 | 2449622 | 2022-02-22 | US | South Dakota | Bennett | 46007 | 772 | 13 | 0 | 43.19486375 | -101.6665572 | 2022-02-23 04:21:09 | Bennett, South Dakota, US | |
3721075 | 3721075 | 2022-02-21 | US | South Dakota | Marshall | 46091 | 772 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-02-22 04:21:01 | Marshall, South Dakota, US | |
3721035 | 3721035 | 2022-02-21 | US | South Dakota | Bennett | 46007 | 772 | 12 | 0 | 43.19486375 | -101.6665572 | 2022-02-22 04:21:01 | Bennett, South Dakota, US | |
3914909 | 3914909 | 2022-02-20 | US | South Dakota | Marshall | 46091 | 772 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-02-21 04:21:05 | Marshall, South Dakota, US | |
3914869 | 3914869 | 2022-02-20 | US | South Dakota | Bennett | 46007 | 772 | 12 | 0 | 43.19486375 | -101.6665572 | 2022-02-21 04:21:05 | Bennett, South Dakota, US | |
3878467 | 3878467 | 2022-02-19 | US | South Dakota | Marshall | 46091 | 772 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-02-20 04:21:00 | Marshall, South Dakota, US | |
3878427 | 3878427 | 2022-02-19 | US | South Dakota | Bennett | 46007 | 772 | 12 | 0 | 43.19486375 | -101.6665572 | 2022-02-20 04:21:00 | Bennett, South Dakota, US | |
3858723 | 3858723 | 2022-02-18 | US | South Dakota | Marshall | 46091 | 772 | 13 | 0 | 45.75870838 | -97.59855639 | 2022-02-19 04:21:11 | Marshall, South Dakota, US | |
3858683 | 3858683 | 2022-02-18 | US | South Dakota | Bennett | 46007 | 772 | 12 | 0 | 43.19486375 | -101.6665572 | 2022-02-19 04:21:11 | Bennett, South Dakota, US | |
2644612 | 2644612 | 2022-02-14 | US | South Dakota | Clark | 46025 | 772 | 8 | 0 | 44.85834507 | -97.72925109 | 2022-02-15 04:21:09 | Clark, South Dakota, US | |
2643102 | 2643102 | 2022-02-14 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-15 04:21:09 | Sheridan, Kansas, US | |
2643043 | 2643043 | 2022-02-14 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-15 04:21:09 | Gove, Kansas, US | |
187419 | 187419 | 2022-02-13 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-14 04:20:51 | Sheridan, Kansas, US | |
187360 | 187360 | 2022-02-13 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-14 04:20:51 | Gove, Kansas, US | |
317265 | 317265 | 2022-02-12 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-13 04:21:00 | Sheridan, Kansas, US | |
317206 | 317206 | 2022-02-12 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-13 04:21:00 | Gove, Kansas, US | |
234591 | 234591 | 2022-02-11 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-12 04:21:06 | Sheridan, Kansas, US | |
234532 | 234532 | 2022-02-11 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-12 04:21:06 | Gove, Kansas, US | |
1465433 | 1465433 | 2022-02-10 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-11 04:21:09 | Sheridan, Kansas, US | |
1465374 | 1465374 | 2022-02-10 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-11 04:21:09 | Gove, Kansas, US | |
3075394 | 3075394 | 2022-02-09 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-10 04:21:14 | Sheridan, Kansas, US | |
3075335 | 3075335 | 2022-02-09 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-10 04:21:14 | Gove, Kansas, US | |
3074997 | 3074997 | 2022-02-09 | US | Idaho | Oneida | 16071 | 772 | 10 | 0 | 42.19494279999999 | -112.5407838 | 2022-02-10 04:21:14 | Oneida, Idaho, US | |
1363701 | 1363701 | 2022-02-08 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-09 04:21:04 | Sheridan, Kansas, US | |
1363642 | 1363642 | 2022-02-08 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-09 04:21:04 | Gove, Kansas, US | |
72439 | 72439 | 2022-02-07 | US | Kansas | Sheridan | 20179 | 772 | 18 | 0 | 39.35018161 | -100.44182590000001 | 2022-02-08 04:21:15 | Sheridan, Kansas, US | |
72380 | 72380 | 2022-02-07 | US | Kansas | Gove | 20063 | 772 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-02-08 04:21:15 | Gove, Kansas, US | |
1782692 | 1782692 | 2022-01-27 | US | Virginia | Bath | 51017 | 772 | 15 | 0 | 38.05852573 | -79.73912095 | 2022-01-28 04:21:09 | Bath, Virginia, US | |
3425417 | 3425417 | 2022-01-21 | US | Arkansas | Calhoun | 5013 | 772 | 9 | 0 | 33.55598792 | -92.49974403 | 2022-01-22 04:21:13 | Calhoun, Arkansas, US | |
1960977 | 1960977 | 2022-01-20 | US | Alaska | Copper River | 2066 | 772 | 6 | 0 | 60.3886 | -162.8905196 | 2022-01-21 04:21:09 | Copper River, Alaska, US | |
3226872 | 3226872 | 2022-01-19 | US | Alaska | Copper River | 2066 | 772 | 6 | 0 | 60.3886 | -162.8905196 | 2022-01-20 04:21:07 | Copper River, Alaska, US | |
3467045 | 3467045 | 2022-01-18 | US | South Dakota | Edmunds | 46045 | 772 | 14 | 0 | 45.41846445 | -99.21545423 | 2022-01-19 04:21:23 | Edmunds, South Dakota, US | |
1474984 | 1474984 | 2022-01-17 | US | South Dakota | Edmunds | 46045 | 772 | 14 | 0 | 45.41846445 | -99.21545423 | 2022-01-18 04:21:04 | Edmunds, South 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]);