johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
366 rows where confirmed = 1624 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1831477 | 1831477 | 2022-10-25 | US | Kansas | Mitchell | 20123 | 1624 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-26 04:22:19 | Mitchell, Kansas, US | |
795738 | 795738 | 2022-10-24 | US | Kansas | Mitchell | 20123 | 1624 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-25 04:21:53 | Mitchell, Kansas, US | |
3278193 | 3278193 | 2022-10-23 | US | Kansas | Mitchell | 20123 | 1624 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-24 04:22:29 | Mitchell, Kansas, US | |
2269231 | 2269231 | 2022-10-22 | US | Kansas | Mitchell | 20123 | 1624 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-23 04:22:46 | Mitchell, Kansas, US | |
1593531 | 1593531 | 2022-10-21 | US | Kansas | Mitchell | 20123 | 1624 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-22 04:22:53 | Mitchell, Kansas, US | |
2273247 | 2273247 | 2022-10-20 | US | Kansas | Mitchell | 20123 | 1624 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-21 04:22:23 | Mitchell, Kansas, US | |
199582 | 199582 | 2022-10-19 | US | Kansas | Mitchell | 20123 | 1624 | 25 | 0 | 39.39331582 | -98.20906732 | 2022-10-20 04:22:59 | Mitchell, Kansas, US | |
2377415 | 2377415 | 2022-09-29 | US | Missouri | Atchison | 29005 | 1624 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-30 04:23:09 | Atchison, Missouri, US | |
1561966 | 1561966 | 2022-09-28 | US | Missouri | Atchison | 29005 | 1624 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-29 04:22:34 | Atchison, Missouri, US | |
3997536 | 3997536 | 2022-09-27 | US | South Dakota | Moody | 46101 | 1624 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-28 04:23:01 | Moody, South Dakota, US | |
3996509 | 3996509 | 2022-09-27 | US | Missouri | Atchison | 29005 | 1624 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-28 04:23:01 | Atchison, Missouri, US | |
2771864 | 2771864 | 2022-09-26 | US | South Dakota | Moody | 46101 | 1624 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-27 04:23:01 | Moody, South Dakota, US | |
2770837 | 2770837 | 2022-09-26 | US | Missouri | Atchison | 29005 | 1624 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-27 04:23:01 | Atchison, Missouri, US | |
1979517 | 1979517 | 2022-09-25 | US | South Dakota | Moody | 46101 | 1624 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-26 04:20:52 | Moody, South Dakota, US | |
1978490 | 1978490 | 2022-09-25 | US | Missouri | Atchison | 29005 | 1624 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-26 04:20:52 | Atchison, Missouri, US | |
2652684 | 2652684 | 2022-09-24 | US | South Dakota | Moody | 46101 | 1624 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-25 04:23:31 | Moody, South Dakota, US | |
2651657 | 2651657 | 2022-09-24 | US | Missouri | Atchison | 29005 | 1624 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-25 04:23:31 | Atchison, Missouri, US | |
387124 | 387124 | 2022-09-23 | US | South Dakota | Moody | 46101 | 1624 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-24 04:21:40 | Moody, South Dakota, US | |
386097 | 386097 | 2022-09-23 | US | Missouri | Atchison | 29005 | 1624 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-09-24 04:21:40 | Atchison, Missouri, US | |
1627678 | 1627678 | 2022-09-22 | US | Virginia | Norton | 51720 | 1624 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-09-23 04:23:13 | Norton, Virginia, US | |
1627423 | 1627423 | 2022-09-22 | US | Texas | Jack | 48237 | 1624 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-09-23 04:23:13 | Jack, Texas, US | |
1627190 | 1627190 | 2022-09-22 | US | South Dakota | Moody | 46101 | 1624 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-23 04:23:13 | Moody, South Dakota, US | |
1373627 | 1373627 | 2022-09-21 | US | Texas | Jack | 48237 | 1624 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-09-22 04:22:56 | Jack, Texas, US | |
1373394 | 1373394 | 2022-09-21 | US | South Dakota | Moody | 46101 | 1624 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-09-22 04:22:56 | Moody, South Dakota, US | |
2019990 | 2019990 | 2022-09-20 | US | Texas | Yoakum | 48501 | 1624 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-09-21 04:23:22 | Yoakum, Texas, US | |
2017673 | 2017673 | 2022-09-20 | US | Idaho | Lemhi | 16059 | 1624 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-09-21 04:23:22 | Lemhi, Idaho, US | |
3573863 | 3573863 | 2022-09-19 | US | Texas | Yoakum | 48501 | 1624 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-09-20 04:22:48 | Yoakum, Texas, US | |
3571546 | 3571546 | 2022-09-19 | US | Idaho | Lemhi | 16059 | 1624 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-09-20 04:22:48 | Lemhi, Idaho, US | |
3777071 | 3777071 | 2022-08-30 | US | Texas | Lynn | 48305 | 1624 | 39 | 0 | 33.17657705 | -101.8162849 | 2022-08-31 04:20:57 | Lynn, Texas, US | |
1683667 | 1683667 | 2022-08-29 | US | Texas | Lynn | 48305 | 1624 | 39 | 0 | 33.17657705 | -101.8162849 | 2022-08-30 04:21:03 | Lynn, Texas, US | |
2832368 | 2832368 | 2022-08-25 | US | Wisconsin | Iron | 55051 | 1624 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-08-26 04:21:02 | Iron, Wisconsin, US | |
2832340 | 2832340 | 2022-08-25 | US | West Virginia | Wirt | 54105 | 1624 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-08-26 04:21:02 | Wirt, West Virginia, US | |
2832141 | 2832141 | 2022-08-25 | US | Virginia | Covington | 51580 | 1624 | 29 | 0 | 37.7824656 | -79.98631446 | 2022-08-26 04:21:02 | Covington, Virginia, US | |
2326674 | 2326674 | 2022-08-24 | US | Virginia | Covington | 51580 | 1624 | 29 | 0 | 37.7824656 | -79.98631446 | 2022-08-25 04:21:13 | Covington, Virginia, US | |
1254198 | 1254198 | 2022-08-23 | US | Washington | Ferry | 53019 | 1624 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-08-24 04:20:46 | Ferry, Washington, US | |
2856302 | 2856302 | 2022-08-22 | US | Washington | Ferry | 53019 | 1624 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-08-23 04:20:56 | Ferry, Washington, US | |
2406274 | 2406274 | 2022-08-21 | US | Washington | Ferry | 53019 | 1624 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-08-22 04:20:38 | Ferry, Washington, US | |
3801352 | 3801352 | 2022-08-20 | US | Washington | Ferry | 53019 | 1624 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-08-21 04:20:44 | Ferry, Washington, US | |
2366938 | 2366938 | 2022-08-19 | US | Washington | Ferry | 53019 | 1624 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-08-20 04:21:01 | Ferry, Washington, US | |
1407466 | 1407466 | 2022-08-02 | US | North Dakota | Ransom | 38073 | 1624 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-08-03 04:20:59 | Ransom, North Dakota, US | |
3969926 | 3969926 | 2022-07-05 | US | Virginia | Mathews | 51115 | 1624 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-07-06 04:20:58 | Mathews, Virginia, US | |
2803829 | 2803829 | 2022-04-06 | US | Texas | Coleman | 48083 | 1624 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-04-07 04:20:53 | Coleman, Texas, US | |
3870598 | 3870598 | 2022-04-05 | US | Texas | Coleman | 48083 | 1624 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-04-06 04:20:49 | Coleman, Texas, US | |
3868154 | 3868154 | 2022-04-05 | US | Colorado | Clear Creek | 8019 | 1624 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-04-06 04:20:49 | Clear Creek, Colorado, US | |
2751940 | 2751940 | 2022-04-04 | US | Texas | Coleman | 48083 | 1624 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-04-05 04:20:48 | Coleman, Texas, US | |
3733286 | 3733286 | 2022-04-03 | US | Texas | Coleman | 48083 | 1624 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-04-04 04:20:51 | Coleman, Texas, US | |
502721 | 502721 | 2022-04-02 | US | Texas | Coleman | 48083 | 1624 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-04-03 04:20:48 | Coleman, Texas, US | |
3353706 | 3353706 | 2022-04-01 | US | Texas | Coleman | 48083 | 1624 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-04-02 04:20:47 | Coleman, Texas, US | |
1543011 | 1543011 | 2022-03-31 | US | Texas | Coleman | 48083 | 1624 | 71 | 0 | 31.76736834 | -99.45240766 | 2022-04-01 04:20:28 | Coleman, Texas, US | |
2481024 | 2481024 | 2022-03-30 | US | Texas | Coleman | 48083 | 1624 | 70 | 0 | 31.76736834 | -99.45240766 | 2022-03-31 04:20:56 | Coleman, Texas, US | |
161065 | 161065 | 2022-03-29 | US | Texas | Coleman | 48083 | 1624 | 69 | 0 | 31.76736834 | -99.45240766 | 2022-03-30 04:20:45 | Coleman, Texas, US | |
1467910 | 1467910 | 2022-03-24 | China | Sichuan | 1624 | 3 | 0 | 30.6171 | 102.7103 | 2022-03-25 04:20:46 | Sichuan, China | |||
3023162 | 3023162 | 2022-03-23 | US | Georgia | Treutlen | 13283 | 1624 | 60 | 0 | 32.40422134 | -82.56904553 | 2022-03-24 04:20:43 | Treutlen, Georgia, US | |
1906084 | 1906084 | 2022-03-22 | US | Georgia | Treutlen | 13283 | 1624 | 60 | 0 | 32.40422134 | -82.56904553 | 2022-03-23 04:20:48 | Treutlen, Georgia, US | |
3239215 | 3239215 | 2022-03-21 | US | Georgia | Treutlen | 13283 | 1624 | 60 | 0 | 32.40422134 | -82.56904553 | 2022-03-22 04:20:54 | Treutlen, Georgia, US | |
25288 | 25288 | 2022-03-20 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-21 04:20:50 | Treutlen, Georgia, US | |
1657298 | 1657298 | 2022-03-19 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-20 04:20:45 | Treutlen, Georgia, US | |
336824 | 336824 | 2022-03-18 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-19 04:20:47 | Treutlen, Georgia, US | |
695277 | 695277 | 2022-03-17 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-18 04:20:55 | Treutlen, Georgia, US | |
2320220 | 2320220 | 2022-03-16 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-17 04:20:56 | Treutlen, Georgia, US | |
262420 | 262420 | 2022-03-15 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-16 04:20:50 | Treutlen, Georgia, US | |
2264779 | 2264779 | 2022-03-14 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-15 04:20:47 | Treutlen, Georgia, US | |
3628845 | 3628845 | 2022-03-13 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-14 04:20:46 | Treutlen, Georgia, US | |
951753 | 951753 | 2022-03-12 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-13 04:20:49 | Treutlen, Georgia, US | |
357214 | 357214 | 2022-03-11 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-12 04:20:50 | Treutlen, Georgia, US | |
1866366 | 1866366 | 2022-03-10 | US | Georgia | Treutlen | 13283 | 1624 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-03-11 04:20:50 | Treutlen, Georgia, US | |
921465 | 921465 | 2022-03-08 | US | Minnesota | Wilkin | 27167 | 1624 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-03-09 04:20:59 | Wilkin, Minnesota, US | |
1549752 | 1549752 | 2022-03-07 | US | Minnesota | Wilkin | 27167 | 1624 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-03-08 04:20:54 | Wilkin, Minnesota, US | |
1059944 | 1059944 | 2022-02-23 | US | Nebraska | Knox | 31107 | 1624 | 12 | 0 | 42.63758421 | -97.89178836 | 2022-02-24 04:21:14 | Knox, Nebraska, US | |
1464715 | 1464715 | 2022-02-10 | US | Colorado | Kit Carson | 8063 | 1624 | 32 | 0 | 39.30497777 | -102.60221990000001 | 2022-02-11 04:21:09 | Kit Carson, Colorado, US | |
2475687 | 2475687 | 2022-02-03 | US | Minnesota | Lac qui Parle | 27073 | 1624 | 28 | 0 | 44.9973857 | -96.17488219 | 2022-02-04 04:21:10 | Lac qui Parle, Minnesota, US | |
3300689 | 3300689 | 2022-01-30 | US | Arkansas | Dallas | 5039 | 1624 | 22 | 0 | 33.97042763 | -92.65167437 | 2022-01-31 04:21:09 | Dallas, Arkansas, US | |
3062480 | 3062480 | 2022-01-29 | US | Arkansas | Dallas | 5039 | 1624 | 22 | 0 | 33.97042763 | -92.65167437 | 2022-01-30 04:21:26 | Dallas, Arkansas, US | |
3810414 | 3810414 | 2022-01-28 | US | Arkansas | Dallas | 5039 | 1624 | 22 | 0 | 33.97042763 | -92.65167437 | 2022-01-29 04:21:10 | Dallas, Arkansas, US | |
1781685 | 1781685 | 2022-01-27 | US | North Carolina | Camden | 37029 | 1624 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-01-28 04:21:09 | Camden, North Carolina, US | |
1779899 | 1779899 | 2022-01-27 | US | Arkansas | Newton | 5101 | 1624 | 45 | 0 | 35.91947491 | -93.21612969 | 2022-01-28 04:21:09 | Newton, Arkansas, US | |
1320346 | 1320346 | 2022-01-26 | US | Nebraska | Wayne | 31179 | 1624 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-01-27 04:21:19 | Wayne, Nebraska, US | |
3427718 | 3427718 | 2022-01-21 | US | Puerto Rico | Patillas | 72109 | 1624 | 0 | 0 | 18.03174 | -66.012242 | 2022-01-22 04:21:13 | Patillas, Puerto Rico, US | |
1474329 | 1474329 | 2022-01-17 | US | New Mexico | Sierra | 35051 | 1624 | 65 | 0 | 33.13028233 | -107.1925893 | 2022-01-18 04:21:04 | Sierra, New Mexico, US | |
557003 | 557003 | 2022-01-16 | US | New Mexico | Sierra | 35051 | 1624 | 65 | 0 | 33.13028233 | -107.1925893 | 2022-01-17 04:21:08 | Sierra, New Mexico, US | |
555299 | 555299 | 2022-01-16 | US | Arkansas | Monroe | 5095 | 1624 | 28 | 0 | 34.6815935 | -91.20540287 | 2022-01-17 04:21:08 | Monroe, Arkansas, US | |
3842724 | 3842724 | 2022-01-15 | US | New Mexico | Sierra | 35051 | 1624 | 65 | 0 | 33.13028233 | -107.1925893 | 2022-01-16 04:21:12 | Sierra, New Mexico, US | |
101539 | 101539 | 2022-01-14 | US | New Mexico | Sierra | 35051 | 1624 | 65 | 0 | 33.13028233 | -107.1925893 | 2022-01-15 04:21:07 | Sierra, New Mexico, US | |
1114983 | 1114983 | 2022-01-11 | US | Kentucky | Cumberland | 21057 | 1624 | 21 | 0 | 36.78926125 | -85.39050034 | 2022-01-12 04:21:44 | Cumberland, Kentucky, US | |
1288087 | 1288087 | 2022-01-04 | US | Nebraska | Hamilton | 31081 | 1624 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-01-05 04:21:59 | Hamilton, Nebraska, US | |
1287994 | 1287994 | 2022-01-04 | US | Montana | Carbon | 30009 | 1624 | 23 | 0 | 45.22850116 | -109.0274047 | 2022-01-05 04:21:59 | Carbon, Montana, US | |
1287990 | 1287990 | 2022-01-04 | US | Montana | Beaverhead | 30001 | 1624 | 23 | 0 | 45.13434354 | -112.89846940000001 | 2022-01-05 04:21:59 | Beaverhead, Montana, US | |
1670371 | 1670371 | 2021-12-29 | US | Missouri | Iron | 29093 | 1624 | 29 | 0 | 37.55487945 | -90.7735296 | 2021-12-30 04:21:25 | Iron, Missouri, US | |
1433472 | 1433472 | 2021-12-28 | US | Georgia | Wilkes | 13317 | 1624 | 39 | 0 | 33.78290391 | -82.74286107 | 2021-12-29 03:21:43 | Wilkes, Georgia, US | |
730326 | 730326 | 2021-12-27 | China | Jiangsu | 1624 | 0 | 0 | 32.9711 | 119.455 | 2021-12-28 04:21:47 | Jiangsu, China | |||
2114849 | 2114849 | 2021-12-26 | US | Texas | La Salle | 48283 | 1624 | 40 | 0 | 28.34453111 | -99.09908775 | 2021-12-27 04:21:58 | La Salle, Texas, US | |
2112659 | 2112659 | 2021-12-26 | US | Idaho | Valley | 16085 | 1624 | 13 | 0 | 44.76728382 | -115.5676773 | 2021-12-27 04:21:58 | Valley, Idaho, US | |
2111498 | 2111498 | 2021-12-26 | China | Jiangsu | 1624 | 0 | 0 | 32.9711 | 119.455 | 2021-12-27 04:21:58 | Jiangsu, China | |||
3606031 | 3606031 | 2021-12-25 | US | Idaho | Valley | 16085 | 1624 | 13 | 0 | 44.76728382 | -115.5676773 | 2021-12-26 04:21:50 | Valley, Idaho, US | |
3604870 | 3604870 | 2021-12-25 | China | Jiangsu | 1624 | 0 | 0 | 32.9711 | 119.455 | 2021-12-26 04:21:50 | Jiangsu, China | |||
2964349 | 2964349 | 2021-12-24 | US | Idaho | Valley | 16085 | 1624 | 13 | 0 | 44.76728382 | -115.5676773 | 2021-12-25 04:21:37 | Valley, Idaho, US | |
2963188 | 2963188 | 2021-12-24 | China | Jiangsu | 1624 | 0 | 0 | 32.9711 | 119.455 | 2021-12-25 04:21:37 | Jiangsu, China | |||
3817381 | 3817381 | 2021-12-23 | US | Idaho | Valley | 16085 | 1624 | 13 | 0 | 44.76728382 | -115.5676773 | 2021-12-24 04:21:34 | Valley, Idaho, US | |
3816220 | 3816220 | 2021-12-23 | China | Jiangsu | 1624 | 0 | 0 | 32.9711 | 119.455 | 2021-12-24 04:21:34 | Jiangsu, China | |||
798228 | 798228 | 2021-12-22 | China | Jiangsu | 1624 | 0 | 0 | 32.9711 | 119.455 | 2021-12-23 04:21:21 | Jiangsu, China |
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]);