johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
157 rows where confirmed = 4679 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754334 | 2754334 | 2022-12-29 | US | Kentucky | Larue | 21123 | 4679 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-30 04:21:04 | Larue, Kentucky, US | |
1075340 | 1075340 | 2022-12-28 | US | Kentucky | Larue | 21123 | 4679 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-29 04:21:01 | Larue, Kentucky, US | |
329337 | 329337 | 2022-12-27 | US | Kentucky | Larue | 21123 | 4679 | 78 | 0 | 37.54567114 | -85.70138352 | 2022-12-28 04:21:04 | Larue, Kentucky, US | |
3523959 | 3523959 | 2022-11-24 | US | Arkansas | Madison | 5087 | 4679 | 66 | 0 | 36.01038185 | -93.72524943 | 2022-11-25 04:21:06 | Madison, Arkansas, US | |
713909 | 713909 | 2022-11-01 | US | Washington | Pacific | 53049 | 4679 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-02 04:22:09 | Pacific, Washington, US | |
3288358 | 3288358 | 2022-10-31 | US | Washington | Pacific | 53049 | 4679 | 72 | 0 | 46.55418369 | -123.7285716 | 2022-11-01 04:22:36 | Pacific, Washington, US | |
1832916 | 1832916 | 2022-10-25 | US | Puerto Rico | Luquillo | 72089 | 4679 | 0 | 0 | 18.342114 | -65.725097 | 2022-10-26 04:22:19 | Luquillo, Puerto Rico, US | |
797177 | 797177 | 2022-10-24 | US | Puerto Rico | Luquillo | 72089 | 4679 | 0 | 0 | 18.342114 | -65.725097 | 2022-10-25 04:21:53 | Luquillo, Puerto Rico, US | |
2275081 | 2275081 | 2022-10-20 | US | Texas | Lavaca | 48285 | 4679 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-10-21 04:22:23 | Lavaca, Texas, US | |
201416 | 201416 | 2022-10-19 | US | Texas | Lavaca | 48285 | 4679 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-10-20 04:22:59 | Lavaca, Texas, US | |
2759656 | 2759656 | 2022-10-18 | US | Puerto Rico | Ciales | 72039 | 4679 | 0 | 0 | 18.28885 | -66.516475 | 2022-10-19 04:22:26 | Ciales, Puerto Rico, US | |
2027490 | 2027490 | 2022-10-17 | US | Puerto Rico | Ciales | 72039 | 4679 | 0 | 0 | 18.28885 | -66.516475 | 2022-10-18 04:22:42 | Ciales, Puerto Rico, US | |
131826 | 131826 | 2022-10-04 | US | Indiana | Carroll | 18015 | 4679 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-10-05 04:23:06 | Carroll, Indiana, US | |
2688451 | 2688451 | 2022-10-03 | US | Puerto Rico | Jayuya | 72073 | 4679 | 0 | 0 | 18.211446 | -66.58878 | 2022-10-04 04:22:55 | Jayuya, Puerto Rico, US | |
2686773 | 2686773 | 2022-10-03 | US | Indiana | Carroll | 18015 | 4679 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-10-04 04:22:55 | Carroll, Indiana, US | |
2260840 | 2260840 | 2022-10-02 | US | Indiana | Carroll | 18015 | 4679 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-10-03 04:23:11 | Carroll, Indiana, US | |
2996366 | 2996366 | 2022-10-01 | US | Indiana | Carroll | 18015 | 4679 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-10-02 04:21:23 | Carroll, Indiana, US | |
854692 | 854692 | 2022-09-30 | US | Indiana | Carroll | 18015 | 4679 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-10-01 04:23:01 | Carroll, Indiana, US | |
2376618 | 2376618 | 2022-09-29 | US | Indiana | Carroll | 18015 | 4679 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-09-30 04:23:09 | Carroll, Indiana, US | |
1563336 | 1563336 | 2022-09-28 | US | Texas | Tyler | 48457 | 4679 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-09-29 04:22:34 | Tyler, Texas, US | |
1563109 | 1563109 | 2022-09-28 | US | Texas | Andrews | 48003 | 4679 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-29 04:22:34 | Andrews, Texas, US | |
1561169 | 1561169 | 2022-09-28 | US | Indiana | Carroll | 18015 | 4679 | 72 | 0 | 40.5807832 | -86.56198812 | 2022-09-29 04:22:34 | Carroll, Indiana, US | |
3997879 | 3997879 | 2022-09-27 | US | Texas | Tyler | 48457 | 4679 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-09-28 04:23:01 | Tyler, Texas, US | |
3997652 | 3997652 | 2022-09-27 | US | Texas | Andrews | 48003 | 4679 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-28 04:23:01 | Andrews, Texas, US | |
2772207 | 2772207 | 2022-09-26 | US | Texas | Tyler | 48457 | 4679 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-09-27 04:23:01 | Tyler, Texas, US | |
2771980 | 2771980 | 2022-09-26 | US | Texas | Andrews | 48003 | 4679 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-27 04:23:01 | Andrews, Texas, US | |
1978002 | 1978002 | 2022-09-25 | US | Kentucky | Caldwell | 21033 | 4679 | 64 | 0 | 37.14749129 | -87.86948214 | 2022-09-26 04:20:52 | Caldwell, Kentucky, US | |
2651169 | 2651169 | 2022-09-24 | US | Kentucky | Caldwell | 21033 | 4679 | 64 | 0 | 37.14749129 | -87.86948214 | 2022-09-25 04:23:31 | Caldwell, Kentucky, US | |
385609 | 385609 | 2022-09-23 | US | Kentucky | Caldwell | 21033 | 4679 | 64 | 0 | 37.14749129 | -87.86948214 | 2022-09-24 04:21:40 | Caldwell, Kentucky, US | |
1625675 | 1625675 | 2022-09-22 | US | Kentucky | Caldwell | 21033 | 4679 | 64 | 0 | 37.14749129 | -87.86948214 | 2022-09-23 04:23:13 | Caldwell, Kentucky, US | |
1371879 | 1371879 | 2022-09-21 | US | Kentucky | Caldwell | 21033 | 4679 | 64 | 0 | 37.14749129 | -87.86948214 | 2022-09-22 04:22:56 | Caldwell, Kentucky, US | |
2018109 | 2018109 | 2022-09-20 | US | Kentucky | Caldwell | 21033 | 4679 | 64 | 0 | 37.14749129 | -87.86948214 | 2022-09-21 04:23:22 | Caldwell, Kentucky, US | |
3571982 | 3571982 | 2022-09-19 | US | Kentucky | Caldwell | 21033 | 4679 | 64 | 0 | 37.14749129 | -87.86948214 | 2022-09-20 04:22:48 | Caldwell, Kentucky, US | |
375549 | 375549 | 2022-09-13 | US | Virginia | Greene | 51079 | 4679 | 63 | 0 | 38.29545894 | -78.46525378 | 2022-09-14 04:20:44 | Greene, Virginia, US | |
1099883 | 1099883 | 2022-08-03 | US | Minnesota | Roseau | 27135 | 4679 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-08-04 04:20:58 | Roseau, Minnesota, US | |
1406808 | 1406808 | 2022-08-02 | US | Minnesota | Roseau | 27135 | 4679 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-08-03 04:20:59 | Roseau, Minnesota, US | |
3618846 | 3618846 | 2022-08-01 | US | Minnesota | Roseau | 27135 | 4679 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-08-02 04:20:53 | Roseau, Minnesota, US | |
3873326 | 3873326 | 2022-07-31 | US | Minnesota | Roseau | 27135 | 4679 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-08-01 04:21:03 | Roseau, Minnesota, US | |
676080 | 676080 | 2022-07-30 | US | Minnesota | Roseau | 27135 | 4679 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-07-31 04:21:02 | Roseau, Minnesota, US | |
1785279 | 1785279 | 2022-07-29 | US | Minnesota | Roseau | 27135 | 4679 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-07-30 04:20:42 | Roseau, Minnesota, US | |
1067642 | 1067642 | 2022-07-28 | US | Minnesota | Roseau | 27135 | 4679 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-07-29 04:20:45 | Roseau, Minnesota, US | |
2336457 | 2336457 | 2022-07-27 | US | Illinois | White | 17193 | 4679 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-28 04:20:56 | White, Illinois, US | |
94363 | 94363 | 2022-07-23 | US | Texas | Shelby | 48419 | 4679 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-07-24 04:20:47 | Shelby, Texas, US | |
3348769 | 3348769 | 2022-06-24 | US | Nebraska | Washington | 31177 | 4679 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-06-25 04:20:57 | Washington, Nebraska, US | |
1650510 | 1650510 | 2022-06-23 | US | Nebraska | Washington | 31177 | 4679 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-06-24 04:20:58 | Washington, Nebraska, US | |
2189745 | 2189745 | 2022-06-22 | US | Nebraska | Washington | 31177 | 4679 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-06-23 04:20:55 | Washington, Nebraska, US | |
168176 | 168176 | 2022-06-21 | US | Nebraska | Washington | 31177 | 4679 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-06-22 04:20:54 | Washington, Nebraska, US | |
1766522 | 1766522 | 2022-06-20 | US | Texas | Panola | 48365 | 4679 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-06-21 04:20:56 | Panola, Texas, US | |
1765459 | 1765459 | 2022-06-20 | US | Nebraska | Washington | 31177 | 4679 | 45 | 0 | 41.52815707 | -96.22019892 | 2022-06-21 04:20:56 | Washington, Nebraska, US | |
947228 | 947228 | 2022-06-14 | US | Alabama | Henry | 1067 | 4679 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-06-15 04:20:54 | Henry, Alabama, US | |
3579663 | 3579663 | 2022-06-02 | US | Illinois | Piatt | 17147 | 4679 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-06-03 04:20:58 | Piatt, Illinois, US | |
3189508 | 3189508 | 2022-05-30 | US | West Virginia | Taylor | 54091 | 4679 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-05-31 04:20:51 | Taylor, West Virginia, US | |
3201657 | 3201657 | 2022-05-29 | US | West Virginia | Taylor | 54091 | 4679 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-05-30 04:20:50 | Taylor, West Virginia, US | |
2728535 | 2728535 | 2022-05-28 | US | West Virginia | Taylor | 54091 | 4679 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-05-29 04:20:53 | Taylor, West Virginia, US | |
1317716 | 1317716 | 2022-05-27 | US | West Virginia | Taylor | 54091 | 4679 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-05-28 04:21:07 | Taylor, West Virginia, US | |
1699514 | 1699514 | 2022-04-28 | US | Texas | Montague | 48337 | 4679 | 128 | 0 | 33.67521893 | -97.72500958 | 2022-04-29 04:20:59 | Montague, Texas, US | |
1848893 | 1848893 | 2022-04-18 | US | Tennessee | Bledsoe | 47007 | 4679 | 57 | 0 | 35.59942968 | -85.20611967 | 2022-04-19 04:21:00 | Bledsoe, Tennessee, US | |
3730717 | 3730717 | 2022-04-03 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-04-04 04:20:51 | Drew, Arkansas, US | |
500152 | 500152 | 2022-04-02 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-04-03 04:20:48 | Drew, Arkansas, US | |
3351137 | 3351137 | 2022-04-01 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-04-02 04:20:47 | Drew, Arkansas, US | |
1540442 | 1540442 | 2022-03-31 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-04-01 04:20:28 | Drew, Arkansas, US | |
2478455 | 2478455 | 2022-03-30 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-03-31 04:20:56 | Drew, Arkansas, US | |
158496 | 158496 | 2022-03-29 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-03-30 04:20:45 | Drew, Arkansas, US | |
1437067 | 1437067 | 2022-03-28 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-03-29 04:20:46 | Drew, Arkansas, US | |
876748 | 876748 | 2022-03-27 | US | Arkansas | Drew | 5043 | 4679 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-03-28 04:20:33 | Drew, Arkansas, US | |
1551071 | 1551071 | 2022-03-07 | US | Texas | Gonzales | 48177 | 4679 | 95 | 0 | 29.45634206 | -97.49424032 | 2022-03-08 04:20:54 | Gonzales, Texas, US | |
2736009 | 2736009 | 2022-02-27 | US | Tennessee | Polk | 47139 | 4679 | 65 | 0 | 35.12245443 | -84.52075859 | 2022-02-28 04:21:05 | Polk, Tennessee, US | |
3049162 | 3049162 | 2022-02-26 | US | Tennessee | Polk | 47139 | 4679 | 65 | 0 | 35.12245443 | -84.52075859 | 2022-02-27 04:21:04 | Polk, Tennessee, US | |
1299026 | 1299026 | 2022-02-17 | US | Illinois | Clay | 17025 | 4679 | 63 | 0 | 38.75388572 | -88.48914513 | 2022-02-18 04:21:04 | Clay, Illinois, US | |
3822823 | 3822823 | 2022-02-16 | US | North Carolina | Yancey | 37199 | 4679 | 50 | 0 | 35.90079156 | -82.31237181 | 2022-02-17 04:20:56 | Yancey, North Carolina, US | |
3074938 | 3074938 | 2022-02-09 | US | Georgia | Union | 13291 | 4679 | 140 | 0 | 34.82995757 | -83.98967069 | 2022-02-10 04:21:14 | Union, Georgia, US | |
2476956 | 2476956 | 2022-02-03 | US | Tennessee | Unicoi | 47171 | 4679 | 86 | 0 | 36.10890856 | -82.43709629 | 2022-02-04 04:21:10 | Unicoi, Tennessee, US | |
982535 | 982535 | 2022-02-01 | US | Wisconsin | Taylor | 55119 | 4679 | 65 | 0 | 45.21179252 | -90.5004405 | 2022-02-02 04:21:09 | Taylor, Wisconsin, US | |
2660967 | 2660967 | 2022-01-31 | US | Texas | Milam | 48331 | 4679 | 93 | 0 | 30.78581830000001 | -96.97718698 | 2022-02-01 04:21:11 | Milam, Texas, US | |
3300964 | 3300964 | 2022-01-30 | US | Georgia | Berrien | 13019 | 4679 | 72 | 0 | 31.27590016 | -83.22529920000002 | 2022-01-31 04:21:09 | Berrien, Georgia, US | |
3062755 | 3062755 | 2022-01-29 | US | Georgia | Berrien | 13019 | 4679 | 72 | 0 | 31.27590016 | -83.22529920000002 | 2022-01-30 04:21:26 | Berrien, Georgia, US | |
3810689 | 3810689 | 2022-01-28 | US | Georgia | Berrien | 13019 | 4679 | 72 | 0 | 31.27590016 | -83.22529920000002 | 2022-01-29 04:21:10 | Berrien, Georgia, US | |
3229544 | 3229544 | 2022-01-19 | US | Texas | Frio | 48163 | 4679 | 80 | 0 | 28.86751206 | -99.10804207 | 2022-01-20 04:21:07 | Frio, Texas, US | |
1255268 | 1255268 | 2021-12-20 | US | Arkansas | Jackson | 5067 | 4679 | 47 | 0 | 35.59802983 | -91.21494602 | 2021-12-21 03:21:27 | Jackson, Arkansas, US | |
3403786 | 3403786 | 2021-11-30 | US | North Carolina | Montgomery | 37123 | 4679 | 110 | 0 | 35.33155144 | -79.90416657 | 2021-12-01 04:22:29 | Montgomery, North Carolina, US | |
904493 | 904493 | 2021-11-24 | Sweden | Gotland | 4679 | 54 | 0 | 57.4684 | 18.4867 | 2021-11-25 04:22:33 | Gotland, Sweden | |||
3290050 | 3290050 | 2021-11-18 | US | Indiana | Scott | 18143 | 4679 | 78 | 0 | 38.68672078 | -85.74627859 | 2021-11-19 04:21:40 | Scott, Indiana, US | |
1323984 | 1323984 | 2021-11-14 | US | Minnesota | Pine | 27115 | 4679 | 39 | 0 | 46.12105238 | -92.74070188 | 2021-11-15 04:21:36 | Pine, Minnesota, US | |
688110 | 688110 | 2021-11-13 | US | Minnesota | Pine | 27115 | 4679 | 39 | 0 | 46.12105238 | -92.74070188 | 2021-11-14 04:21:31 | Pine, Minnesota, US | |
716219 | 716219 | 2021-11-12 | US | Minnesota | Pine | 27115 | 4679 | 39 | 0 | 46.12105238 | -92.74070188 | 2021-11-13 04:21:38 | Pine, Minnesota, US | |
699751 | 699751 | 2021-11-04 | US | Kansas | Seward | 20175 | 4679 | 49 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-05 04:21:54 | Seward, Kansas, US | |
277529 | 277529 | 2021-11-03 | US | Kansas | Seward | 20175 | 4679 | 49 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-04 04:22:20 | Seward, Kansas, US | |
276947 | 276947 | 2021-11-03 | US | Georgia | Butts | 13035 | 4679 | 117 | 0 | 33.283094500000004 | -83.95435040000002 | 2021-11-04 04:22:20 | Butts, Georgia, US | |
45520 | 45520 | 2021-11-02 | US | Mississippi | Itawamba | 28057 | 4679 | 105 | 0 | 34.27993475 | -88.3606733 | 2021-11-03 06:22:09 | Itawamba, Mississippi, US | |
2721413 | 2721413 | 2021-10-30 | US | Alabama | Winston | 1133 | 4679 | 103 | 0 | 34.15030532 | -87.37325922 | 2021-10-31 04:22:08 | Winston, Alabama, US | |
492509 | 492509 | 2021-10-14 | US | Georgia | Stephens | 13257 | 4679 | 102 | 0 | 34.55151201 | -83.29405315 | 2021-10-15 04:21:26 | Stephens, Georgia, US | |
2879188 | 2879188 | 2021-10-09 | US | Tennessee | Overton | 47133 | 4679 | 78 | 0 | 36.34117832 | -85.28989535 | 2021-10-10 04:21:38 | Overton, Tennessee, US | |
2459630 | 2459630 | 2021-10-06 | US | Georgia | Lumpkin | 13187 | 4679 | 92 | 0 | 34.57286511 | -84.00425681 | 2021-10-07 04:21:36 | Lumpkin, Georgia, US | |
2772979 | 2772979 | 2021-09-30 | Japan | Kagawa | 4679 | 36 | 0 | 34.217292 | 133.969047 | 2021-10-01 04:21:35 | Kagawa, Japan | |||
706435 | 706435 | 2021-09-29 | Japan | Kagawa | 4679 | 36 | 0 | 34.217292 | 133.969047 | 2021-09-30 04:21:20 | Kagawa, Japan | |||
2076836 | 2076836 | 2021-09-26 | US | Georgia | Unassigned | 90013 | 4679 | 7 | 0 | 34.91369188 | 0.0 | 2021-09-27 04:21:16 | Unassigned, Georgia, US | |
1725388 | 1725388 | 2021-09-25 | US | Georgia | Unassigned | 90013 | 4679 | 7 | 0 | 34.91369188 | 0.0 | 2021-09-26 04:21:29 | Unassigned, Georgia, US | |
1922108 | 1922108 | 2021-09-24 | US | Georgia | Unassigned | 90013 | 4679 | 7 | 0 | 34.91369188 | 0.0 | 2021-09-25 04:21:31 | Unassigned, Georgia, US | |
602529 | 602529 | 2021-09-23 | US | Georgia | Madison | 13195 | 4679 | 65 | 0 | 34.12920917 | -83.21218732 | 2021-09-24 04:21:44 | Madison, Georgia, US | |
2466406 | 2466406 | 2021-09-14 | US | Wyoming | Teton | 56039 | 4679 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-09-15 03:22:37 | Teton, Wyoming, 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]);