johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
222 rows where confirmed = 3064 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 208
- Japan 3
- Kosovo 3
- China 2
- Chile 1
- Guinea-Bissau 1
- India 1
- Liechtenstein 1
- Mali 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2182549 | 2182549 | 2022-12-22 | US | Tennessee | Lake | 47095 | 3064 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-23 04:21:04 | Lake, Tennessee, US | |
1628981 | 1628981 | 2022-12-18 | US | Connecticut | Unassigned | 90009 | 3064 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-19 04:21:03 | Unassigned, Connecticut, US | |
2136632 | 2136632 | 2022-12-01 | US | Arkansas | Chicot | 5017 | 3064 | 63 | 0 | 33.26458973 | -91.29539209 | 2022-12-02 04:21:07 | Chicot, Arkansas, US | |
1965048 | 1965048 | 2022-11-30 | US | Arkansas | Chicot | 5017 | 3064 | 63 | 0 | 33.26458973 | -91.29539209 | 2022-12-01 04:21:03 | Chicot, Arkansas, US | |
711701 | 711701 | 2022-11-01 | US | Iowa | Union | 19175 | 3064 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-11-02 04:22:09 | Union, Iowa, US | |
3286150 | 3286150 | 2022-10-31 | US | Iowa | Union | 19175 | 3064 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-11-01 04:22:36 | Union, Iowa, US | |
321183 | 321183 | 2022-10-30 | US | Iowa | Union | 19175 | 3064 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-10-31 04:21:36 | Union, Iowa, US | |
913459 | 913459 | 2022-10-29 | US | Iowa | Union | 19175 | 3064 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-10-30 04:22:14 | Union, Iowa, US | |
1367728 | 1367728 | 2022-10-28 | US | Iowa | Union | 19175 | 3064 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-10-29 04:21:13 | Union, Iowa, US | |
3039583 | 3039583 | 2022-10-27 | US | Iowa | Union | 19175 | 3064 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-10-28 04:22:31 | Union, Iowa, US | |
540003 | 540003 | 2022-10-26 | US | Iowa | Union | 19175 | 3064 | 54 | 0 | 41.0277278 | -94.24234847 | 2022-10-27 04:22:01 | Union, Iowa, US | |
796047 | 796047 | 2022-10-24 | US | Michigan | Crawford | 26039 | 3064 | 36 | 0 | 44.68255561 | -84.61006219 | 2022-10-25 04:21:53 | Crawford, Michigan, US | |
3278502 | 3278502 | 2022-10-23 | US | Michigan | Crawford | 26039 | 3064 | 36 | 0 | 44.68255561 | -84.61006219 | 2022-10-24 04:22:29 | Crawford, Michigan, US | |
2269540 | 2269540 | 2022-10-22 | US | Michigan | Crawford | 26039 | 3064 | 36 | 0 | 44.68255561 | -84.61006219 | 2022-10-23 04:22:46 | Crawford, Michigan, US | |
1593840 | 1593840 | 2022-10-21 | US | Michigan | Crawford | 26039 | 3064 | 36 | 0 | 44.68255561 | -84.61006219 | 2022-10-22 04:22:53 | Crawford, Michigan, US | |
2273556 | 2273556 | 2022-10-20 | US | Michigan | Crawford | 26039 | 3064 | 36 | 0 | 44.68255561 | -84.61006219 | 2022-10-21 04:22:23 | Crawford, Michigan, US | |
199891 | 199891 | 2022-10-19 | US | Michigan | Crawford | 26039 | 3064 | 36 | 0 | 44.68255561 | -84.61006219 | 2022-10-20 04:22:59 | Crawford, Michigan, US | |
2758552 | 2758552 | 2022-10-18 | US | Michigan | Crawford | 26039 | 3064 | 36 | 0 | 44.68255561 | -84.61006219 | 2022-10-19 04:22:26 | Crawford, Michigan, US | |
856361 | 856361 | 2022-09-30 | US | Puerto Rico | Guanica | 72055 | 3064 | 0 | 0 | 17.982429 | -66.919643 | 2022-10-01 04:23:01 | Guanica, Puerto Rico, US | |
1563335 | 1563335 | 2022-09-28 | US | Texas | Trinity | 48455 | 3064 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-09-29 04:22:34 | Trinity, Texas, US | |
3997878 | 3997878 | 2022-09-27 | US | Texas | Trinity | 48455 | 3064 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-09-28 04:23:01 | Trinity, Texas, US | |
2772206 | 2772206 | 2022-09-26 | US | Texas | Trinity | 48455 | 3064 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-09-27 04:23:01 | Trinity, Texas, US | |
372003 | 372003 | 2022-09-13 | China | Shandong | 3064 | 7 | 0 | 36.3427 | 118.1498 | 2022-09-14 04:20:44 | Shandong, China | |||
2404385 | 2404385 | 2022-08-21 | US | Louisiana | West Feliciana | 22125 | 3064 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-08-22 04:20:38 | West Feliciana, Louisiana, US | |
3799463 | 3799463 | 2022-08-20 | US | Louisiana | West Feliciana | 22125 | 3064 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-08-21 04:20:44 | West Feliciana, Louisiana, US | |
2365049 | 2365049 | 2022-08-19 | US | Louisiana | West Feliciana | 22125 | 3064 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-08-20 04:21:01 | West Feliciana, Louisiana, US | |
1419272 | 1419272 | 2022-07-08 | US | New Jersey | Unassigned | 90034 | 3064 | 0 | 0 | 41.13891592 | 0.0 | 2022-07-09 04:20:59 | Unassigned, New Jersey, US | |
3347240 | 3347240 | 2022-06-24 | US | Colorado | Archuleta | 8007 | 3064 | 16 | 0 | 37.19474156 | -107.0476867 | 2022-06-25 04:20:57 | Archuleta, Colorado, US | |
3271901 | 3271901 | 2022-06-19 | US | North Dakota | Barnes | 38003 | 3064 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-06-20 04:21:01 | Barnes, North Dakota, US | |
3399813 | 3399813 | 2022-06-18 | US | North Dakota | Barnes | 38003 | 3064 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-06-19 04:20:51 | Barnes, North Dakota, US | |
2313690 | 2313690 | 2022-06-17 | US | North Dakota | Barnes | 38003 | 3064 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-06-18 04:21:10 | Barnes, North Dakota, US | |
3889613 | 3889613 | 2022-06-06 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-06-07 04:21:08 | Custer, Montana, US | |
3509382 | 3509382 | 2022-06-05 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-06-06 04:20:57 | Custer, Montana, US | |
3529459 | 3529459 | 2022-06-04 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-06-05 04:20:55 | Custer, Montana, US | |
3135545 | 3135545 | 2022-06-03 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-06-04 04:20:58 | Custer, Montana, US | |
3580620 | 3580620 | 2022-06-02 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-06-03 04:20:58 | Custer, Montana, US | |
972913 | 972913 | 2022-06-01 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-06-02 05:20:39 | Custer, Montana, US | |
231220 | 231220 | 2022-05-31 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-06-01 04:20:55 | Custer, Montana, US | |
3187985 | 3187985 | 2022-05-30 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-05-31 04:20:51 | Custer, Montana, US | |
3200134 | 3200134 | 2022-05-29 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-05-30 04:20:50 | Custer, Montana, US | |
2727012 | 2727012 | 2022-05-28 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-05-29 04:20:53 | Custer, Montana, US | |
1316193 | 1316193 | 2022-05-27 | US | Montana | Custer | 30017 | 3064 | 48 | 0 | 46.25319932 | -105.5737526 | 2022-05-28 04:21:07 | Custer, Montana, US | |
1186443 | 1186443 | 2022-05-18 | US | Minnesota | Aitkin | 27001 | 3064 | 62 | 0 | 46.60962049 | -93.4116826 | 2022-05-19 04:20:54 | Aitkin, Minnesota, US | |
3538648 | 3538648 | 2022-05-10 | US | Texas | Nolan | 48353 | 3064 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-05-11 04:20:48 | Nolan, Texas, US | |
225183 | 225183 | 2022-05-09 | US | Texas | Nolan | 48353 | 3064 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-05-10 04:20:50 | Nolan, Texas, US | |
221781 | 221781 | 2022-05-09 | China | Fujian | 3064 | 1 | 0 | 26.0789 | 117.9874 | 2022-05-10 04:20:50 | Fujian, China | |||
2334568 | 2334568 | 2022-05-08 | US | Texas | Nolan | 48353 | 3064 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-05-09 04:20:54 | Nolan, Texas, US | |
363530 | 363530 | 2022-05-07 | US | Texas | Nolan | 48353 | 3064 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-05-08 04:20:49 | Nolan, Texas, US | |
1400881 | 1400881 | 2022-05-06 | US | Texas | Nolan | 48353 | 3064 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-05-07 04:21:09 | Nolan, Texas, US | |
2601236 | 2601236 | 2022-05-05 | US | Texas | Nolan | 48353 | 3064 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-05-06 04:21:00 | Nolan, Texas, US | |
3268685 | 3268685 | 2022-05-04 | US | Texas | Nolan | 48353 | 3064 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-05-05 04:20:55 | Nolan, Texas, US | |
25531 | 25531 | 2022-03-20 | US | Indiana | Pulaski | 18131 | 3064 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-03-21 04:20:50 | Pulaski, Indiana, US | |
1657541 | 1657541 | 2022-03-19 | US | Indiana | Pulaski | 18131 | 3064 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-03-20 04:20:45 | Pulaski, Indiana, US | |
337067 | 337067 | 2022-03-18 | US | Indiana | Pulaski | 18131 | 3064 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-03-19 04:20:47 | Pulaski, Indiana, US | |
695520 | 695520 | 2022-03-17 | US | Indiana | Pulaski | 18131 | 3064 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-03-18 04:20:55 | Pulaski, Indiana, US | |
3629665 | 3629665 | 2022-03-13 | US | Minnesota | Chippewa | 27023 | 3064 | 47 | 0 | 45.02343421 | -95.56403693 | 2022-03-14 04:20:46 | Chippewa, Minnesota, US | |
952573 | 952573 | 2022-03-12 | US | Minnesota | Chippewa | 27023 | 3064 | 47 | 0 | 45.02343421 | -95.56403693 | 2022-03-13 04:20:49 | Chippewa, Minnesota, US | |
358034 | 358034 | 2022-03-11 | US | Minnesota | Chippewa | 27023 | 3064 | 47 | 0 | 45.02343421 | -95.56403693 | 2022-03-12 04:20:50 | Chippewa, Minnesota, US | |
1866118 | 1866118 | 2022-03-10 | US | Colorado | Moffat | 8081 | 3064 | 52 | 0 | 40.61810999 | -108.2070876 | 2022-03-11 04:20:50 | Moffat, Colorado, US | |
2450286 | 2450286 | 2022-02-22 | US | West Virginia | Roane | 54087 | 3064 | 35 | 0 | 38.71622686 | -81.35243568 | 2022-02-23 04:21:09 | Roane, West Virginia, US | |
1364961 | 1364961 | 2022-02-08 | US | Oregon | Baker | 41001 | 3064 | 43 | 0 | 44.70915557 | -117.6749883 | 2022-02-09 04:21:04 | Baker, Oregon, US | |
1320118 | 1320118 | 2022-01-26 | US | Missouri | Gasconade | 29073 | 3064 | 90 | 0 | 38.43947277 | -91.50847147 | 2022-01-27 04:21:19 | Gasconade, Missouri, US | |
2053062 | 2053062 | 2022-01-25 | US | Iowa | Clayton | 19043 | 3064 | 68 | 0 | 42.84443388 | -91.34133693 | 2022-01-26 04:21:07 | Clayton, Iowa, US | |
1229011 | 1229011 | 2022-01-24 | US | Kentucky | Estill | 21065 | 3064 | 39 | 0 | 37.69241417 | -83.95956369 | 2022-01-25 04:21:05 | Estill, Kentucky, US | |
1228999 | 1228999 | 2022-01-24 | US | Kentucky | Carroll | 21041 | 3064 | 38 | 0 | 38.66599534 | -85.12601074 | 2022-01-25 04:21:05 | Carroll, Kentucky, US | |
1228793 | 1228793 | 2022-01-24 | US | Iowa | Clayton | 19043 | 3064 | 68 | 0 | 42.84443388 | -91.34133693 | 2022-01-25 04:21:05 | Clayton, Iowa, US | |
1143877 | 1143877 | 2022-01-23 | US | Tennessee | Lewis | 47101 | 3064 | 49 | 0 | 35.52853208 | -87.49022694 | 2022-01-24 04:21:12 | Lewis, Tennessee, US | |
1142092 | 1142092 | 2022-01-23 | US | Iowa | Clayton | 19043 | 3064 | 68 | 0 | 42.84443388 | -91.34133693 | 2022-01-24 04:21:12 | Clayton, Iowa, US | |
2834010 | 2834010 | 2022-01-22 | US | Iowa | Clayton | 19043 | 3064 | 68 | 0 | 42.84443388 | -91.34133693 | 2022-01-23 04:21:13 | Clayton, Iowa, US | |
3426128 | 3426128 | 2022-01-21 | US | Iowa | Clayton | 19043 | 3064 | 68 | 0 | 42.84443388 | -91.34133693 | 2022-01-22 04:21:13 | Clayton, Iowa, US | |
1961736 | 1961736 | 2022-01-20 | US | Iowa | Clayton | 19043 | 3064 | 68 | 0 | 42.84443388 | -91.34133693 | 2022-01-21 04:21:09 | Clayton, Iowa, US | |
3227631 | 3227631 | 2022-01-19 | US | Iowa | Clayton | 19043 | 3064 | 68 | 0 | 42.84443388 | -91.34133693 | 2022-01-20 04:21:07 | Clayton, Iowa, US | |
1695482 | 1695482 | 2022-01-10 | US | Texas | Madison | 48313 | 3064 | 46 | 0 | 30.96694679 | -95.93003775 | 2022-01-11 04:22:01 | Madison, Texas, US | |
1694253 | 1694253 | 2022-01-10 | US | Missouri | Moniteau | 29135 | 3064 | 46 | 0 | 38.63571781 | -92.57976951 | 2022-01-11 04:22:01 | Moniteau, Missouri, US | |
1289538 | 1289538 | 2022-01-04 | US | Wisconsin | Burnett | 55013 | 3064 | 36 | 0 | 45.86303537 | -92.36711412 | 2022-01-05 04:21:59 | Burnett, Wisconsin, US | |
1288583 | 1288583 | 2022-01-04 | US | Oklahoma | McIntosh | 40091 | 3064 | 106 | 0 | 35.37235506 | -95.66599306 | 2022-01-05 04:21:59 | McIntosh, Oklahoma, US | |
1702927 | 1702927 | 2022-01-03 | US | Oklahoma | McIntosh | 40091 | 3064 | 106 | 0 | 35.37235506 | -95.66599306 | 2022-01-04 04:22:17 | McIntosh, Oklahoma, US | |
3522377 | 3522377 | 2022-01-02 | US | Tennessee | Grundy | 47061 | 3064 | 64 | 0 | 35.38433717 | -85.72142731 | 2022-01-03 02:22:25 | Grundy, Tennessee, US | |
3522010 | 3522010 | 2022-01-02 | US | Oklahoma | McIntosh | 40091 | 3064 | 106 | 0 | 35.37235506 | -95.66599306 | 2022-01-03 02:22:25 | McIntosh, Oklahoma, US | |
2170140 | 2170140 | 2022-01-01 | US | Oklahoma | McIntosh | 40091 | 3064 | 106 | 0 | 35.37235506 | -95.66599306 | 2022-01-02 04:20:52 | McIntosh, Oklahoma, US | |
2779571 | 2779571 | 2021-12-31 | US | Oklahoma | McIntosh | 40091 | 3064 | 106 | 0 | 35.37235506 | -95.66599306 | 2022-01-01 04:22:14 | McIntosh, Oklahoma, US | |
4001228 | 4001228 | 2021-12-30 | US | Oklahoma | McIntosh | 40091 | 3064 | 106 | 0 | 35.37235506 | -95.66599306 | 2021-12-31 04:21:50 | McIntosh, Oklahoma, US | |
1671035 | 1671035 | 2021-12-29 | US | Oklahoma | McIntosh | 40091 | 3064 | 106 | 0 | 35.37235506 | -95.66599306 | 2021-12-30 04:21:25 | McIntosh, Oklahoma, US | |
731960 | 731960 | 2021-12-27 | US | Kentucky | Lewis | 21135 | 3064 | 67 | 0 | 38.53184419 | -83.37735618 | 2021-12-28 04:21:47 | Lewis, Kentucky, US | |
2966135 | 2966135 | 2021-12-24 | US | Puerto Rico | Gurabo | 72063 | 3064 | 0 | 0 | 18.266461 | -65.97970500000001 | 2021-12-25 04:21:37 | Gurabo, Puerto Rico, US | |
3819167 | 3819167 | 2021-12-23 | US | Puerto Rico | Gurabo | 72063 | 3064 | 0 | 0 | 18.266461 | -65.97970500000001 | 2021-12-24 04:21:34 | Gurabo, Puerto Rico, US | |
2401733 | 2401733 | 2021-12-17 | US | Tennessee | Benton | 47005 | 3064 | 61 | 0 | 36.07110411 | -88.06849355 | 2021-12-18 02:22:20 | Benton, Tennessee, US | |
3498138 | 3498138 | 2021-12-15 | US | Missouri | Pike | 29163 | 3064 | 51 | 0 | 39.34310674 | -91.16980779 | 2021-12-16 04:22:11 | Pike, Missouri, US | |
3497315 | 3497315 | 2021-12-15 | US | Indiana | Perry | 18123 | 3064 | 54 | 0 | 38.07809328 | -86.63741946 | 2021-12-16 04:22:11 | Perry, Indiana, US | |
551757 | 551757 | 2021-12-08 | US | Illinois | Edgar | 17045 | 3064 | 50 | 0 | 39.6809186 | -87.74759563 | 2021-12-09 04:22:49 | Edgar, Illinois, US | |
2538 | 2538 | 2021-12-02 | US | New Mexico | Roosevelt | 35041 | 3064 | 71 | 0 | 34.02097406 | -103.4799493 | 2021-12-03 04:23:05 | Roosevelt, New Mexico, US | |
1324 | 1324 | 2021-12-02 | US | Illinois | Hancock | 17067 | 3064 | 35 | 0 | 40.40423981 | -91.16313899 | 2021-12-03 04:23:05 | Hancock, Illinois, US | |
163919 | 163919 | 2021-11-19 | US | Missouri | Clinton | 29049 | 3064 | 78 | 0 | 39.6013098 | -94.40465394 | 2021-11-20 04:22:17 | Clinton, Missouri, US | |
2289413 | 2289413 | 2021-11-15 | US | Missouri | Ray | 29177 | 3064 | 52 | 0 | 39.353746799999996 | -93.98905745 | 2021-11-16 04:21:10 | Ray, Missouri, US | |
717760 | 717760 | 2021-11-12 | US | Vermont | Windsor | 50027 | 3064 | 32 | 0 | 43.58010937 | -72.58595157 | 2021-11-13 04:21:38 | Windsor, Vermont, US | |
30391 | 30391 | 2021-11-11 | US | Missouri | Texas | 29215 | 3064 | 43 | 0 | 37.31728859 | -91.96564727 | 2021-11-12 04:22:01 | Texas, Missouri, US | |
2846830 | 2846830 | 2021-11-10 | US | Missouri | Texas | 29215 | 3064 | 43 | 0 | 37.31728859 | -91.96564727 | 2021-11-11 04:21:45 | Texas, Missouri, US | |
278607 | 278607 | 2021-11-03 | US | North Dakota | Rolette | 38079 | 3064 | 34 | 0 | 48.77245354 | -99.84097493 | 2021-11-04 04:22:20 | Rolette, North Dakota, US | |
44615 | 44615 | 2021-11-02 | US | Georgia | Worth | 13321 | 3064 | 91 | 0 | 31.55162306 | -83.85090513 | 2021-11-03 06:22:09 | Worth, Georgia, US | |
1912770 | 1912770 | 2021-10-17 | US | Wisconsin | Langlade | 55067 | 3064 | 54 | 0 | 45.26271619 | -89.07483625 | 2021-10-18 04:21:10 | Langlade, Wisconsin, 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]);