johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
160 rows where confirmed = 5990 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2182899 | 2182899 | 2022-12-22 | US | Virginia | Buchanan | 51027 | 5990 | 136 | 0 | 37.26818323 | -82.03749726 | 2022-12-23 04:21:04 | Buchanan, Virginia, US | |
454703 | 454703 | 2022-12-21 | US | Virginia | Buchanan | 51027 | 5990 | 135 | 0 | 37.26818323 | -82.03749726 | 2022-12-22 04:20:56 | Buchanan, Virginia, US | |
871579 | 871579 | 2022-12-11 | US | Puerto Rico | Sabana Grande | 72121 | 5990 | 0 | 0 | 18.08282 | -66.943758 | 2022-12-12 04:21:01 | Sabana Grande, Puerto Rico, US | |
1832498 | 1832498 | 2022-10-25 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-26 04:22:19 | Madison, North Carolina, US | |
796759 | 796759 | 2022-10-24 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-25 04:21:53 | Madison, North Carolina, US | |
3279214 | 3279214 | 2022-10-23 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-24 04:22:29 | Madison, North Carolina, US | |
2270252 | 2270252 | 2022-10-22 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-23 04:22:46 | Madison, North Carolina, US | |
1594552 | 1594552 | 2022-10-21 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-22 04:22:53 | Madison, North Carolina, US | |
2275402 | 2275402 | 2022-10-20 | US | West Virginia | Brooke | 54009 | 5990 | 107 | 0 | 40.27367263 | -80.57915332 | 2022-10-21 04:22:23 | Brooke, West Virginia, US | |
2274268 | 2274268 | 2022-10-20 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-21 04:22:23 | Madison, North Carolina, US | |
200712 | 200712 | 2022-10-19 | US | Ohio | Carroll | 39019 | 5990 | 131 | 0 | 40.5789686 | -81.09178213 | 2022-10-20 04:22:59 | Carroll, Ohio, US | |
200603 | 200603 | 2022-10-19 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-20 04:22:59 | Madison, North Carolina, US | |
198661 | 198661 | 2022-10-19 | US | Alabama | Pickens | 1107 | 5990 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-10-20 04:22:59 | Pickens, Alabama, US | |
2759373 | 2759373 | 2022-10-18 | US | Ohio | Carroll | 39019 | 5990 | 131 | 0 | 40.5789686 | -81.09178213 | 2022-10-19 04:22:26 | Carroll, Ohio, US | |
2759264 | 2759264 | 2022-10-18 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-19 04:22:26 | Madison, North Carolina, US | |
2757322 | 2757322 | 2022-10-18 | US | Alabama | Pickens | 1107 | 5990 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-10-19 04:22:26 | Pickens, Alabama, US | |
2027207 | 2027207 | 2022-10-17 | US | Ohio | Carroll | 39019 | 5990 | 131 | 0 | 40.5789686 | -81.09178213 | 2022-10-18 04:22:42 | Carroll, Ohio, US | |
2027098 | 2027098 | 2022-10-17 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-18 04:22:42 | Madison, North Carolina, US | |
2025156 | 2025156 | 2022-10-17 | US | Alabama | Pickens | 1107 | 5990 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-10-18 04:22:42 | Pickens, Alabama, US | |
2161985 | 2161985 | 2022-10-16 | US | Ohio | Carroll | 39019 | 5990 | 131 | 0 | 40.5789686 | -81.09178213 | 2022-10-17 04:20:31 | Carroll, Ohio, US | |
2161876 | 2161876 | 2022-10-16 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-17 04:20:31 | Madison, North Carolina, US | |
2159934 | 2159934 | 2022-10-16 | US | Alabama | Pickens | 1107 | 5990 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-10-17 04:20:31 | Pickens, Alabama, US | |
518182 | 518182 | 2022-10-15 | US | Ohio | Carroll | 39019 | 5990 | 131 | 0 | 40.5789686 | -81.09178213 | 2022-10-16 04:22:39 | Carroll, Ohio, US | |
518073 | 518073 | 2022-10-15 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-16 04:22:39 | Madison, North Carolina, US | |
516131 | 516131 | 2022-10-15 | US | Alabama | Pickens | 1107 | 5990 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-10-16 04:22:39 | Pickens, Alabama, US | |
2035239 | 2035239 | 2022-10-14 | US | Ohio | Carroll | 39019 | 5990 | 131 | 0 | 40.5789686 | -81.09178213 | 2022-10-15 04:22:00 | Carroll, Ohio, US | |
2035130 | 2035130 | 2022-10-14 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-15 04:22:00 | Madison, North Carolina, US | |
2033188 | 2033188 | 2022-10-14 | US | Alabama | Pickens | 1107 | 5990 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-10-15 04:22:00 | Pickens, Alabama, US | |
3755927 | 3755927 | 2022-10-13 | US | Ohio | Carroll | 39019 | 5990 | 131 | 0 | 40.5789686 | -81.09178213 | 2022-10-14 04:22:28 | Carroll, Ohio, US | |
3755818 | 3755818 | 2022-10-13 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-14 04:22:28 | Madison, North Carolina, US | |
3753876 | 3753876 | 2022-10-13 | US | Alabama | Pickens | 1107 | 5990 | 112 | 0 | 33.28094866 | -88.08818103 | 2022-10-14 04:22:28 | Pickens, Alabama, US | |
3216643 | 3216643 | 2022-10-12 | US | North Carolina | Madison | 37115 | 5990 | 84 | 0 | 35.85402722 | -82.71346418 | 2022-10-13 04:22:39 | Madison, North Carolina, US | |
1680980 | 1680980 | 2022-08-29 | US | Arkansas | Conway | 5029 | 5990 | 68 | 0 | 35.26205537 | -92.70506566 | 2022-08-30 04:21:03 | Conway, Arkansas, US | |
3872516 | 3872516 | 2022-07-31 | US | Idaho | Payette | 16075 | 5990 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-08-01 04:21:03 | Payette, Idaho, US | |
675270 | 675270 | 2022-07-30 | US | Idaho | Payette | 16075 | 5990 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-07-31 04:21:02 | Payette, Idaho, US | |
1784469 | 1784469 | 2022-07-29 | US | Idaho | Payette | 16075 | 5990 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-07-30 04:20:42 | Payette, Idaho, US | |
3408397 | 3408397 | 2022-07-17 | US | Tennessee | Fentress | 47049 | 5990 | 130 | 0 | 36.38128818 | -84.92870012 | 2022-07-18 04:20:59 | Fentress, Tennessee, US | |
2154597 | 2154597 | 2022-07-16 | US | Tennessee | Fentress | 47049 | 5990 | 130 | 0 | 36.38128818 | -84.92870012 | 2022-07-17 04:21:15 | Fentress, Tennessee, US | |
2491600 | 2491600 | 2022-06-29 | US | Maryland | Garrett | 24023 | 5990 | 115 | 0 | 39.52786077 | -79.27355126 | 2022-06-30 04:21:01 | Garrett, Maryland, US | |
476890 | 476890 | 2022-06-26 | US | Kentucky | Meade | 21163 | 5990 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-27 04:21:00 | Meade, Kentucky, US | |
940265 | 940265 | 2022-06-25 | US | Kentucky | Meade | 21163 | 5990 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-26 04:21:02 | Meade, Kentucky, US | |
3348085 | 3348085 | 2022-06-24 | US | Kentucky | Meade | 21163 | 5990 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-25 04:20:57 | Meade, Kentucky, US | |
1649826 | 1649826 | 2022-06-23 | US | Kentucky | Meade | 21163 | 5990 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-24 04:20:58 | Meade, Kentucky, US | |
2189061 | 2189061 | 2022-06-22 | US | Kentucky | Meade | 21163 | 5990 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-23 04:20:55 | Meade, Kentucky, US | |
167492 | 167492 | 2022-06-21 | US | Kentucky | Meade | 21163 | 5990 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-22 04:20:54 | Meade, Kentucky, US | |
1764775 | 1764775 | 2022-06-20 | US | Kentucky | Meade | 21163 | 5990 | 66 | 0 | 37.96163597 | -86.21028219 | 2022-06-21 04:20:56 | Meade, Kentucky, US | |
2236892 | 2236892 | 2022-06-12 | US | Louisiana | Grant | 22043 | 5990 | 95 | 0 | 31.59882456 | -92.56124347 | 2022-06-13 04:21:14 | Grant, Louisiana, US | |
3143090 | 3143090 | 2022-06-11 | US | Louisiana | Grant | 22043 | 5990 | 95 | 0 | 31.59882456 | -92.56124347 | 2022-06-12 04:20:53 | Grant, Louisiana, US | |
1946006 | 1946006 | 2022-06-10 | US | Louisiana | Grant | 22043 | 5990 | 95 | 0 | 31.59882456 | -92.56124347 | 2022-06-11 04:21:01 | Grant, Louisiana, US | |
3890447 | 3890447 | 2022-06-06 | US | South Carolina | Jasper | 45053 | 5990 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-06-07 04:21:08 | Jasper, South Carolina, US | |
3510216 | 3510216 | 2022-06-05 | US | South Carolina | Jasper | 45053 | 5990 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-06-06 04:20:57 | Jasper, South Carolina, US | |
3530293 | 3530293 | 2022-06-04 | US | South Carolina | Jasper | 45053 | 5990 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-06-05 04:20:55 | Jasper, South Carolina, US | |
3527994 | 3527994 | 2022-06-04 | US | Arkansas | Sevier | 5133 | 5990 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-06-05 04:20:55 | Sevier, Arkansas, US | |
3136379 | 3136379 | 2022-06-03 | US | South Carolina | Jasper | 45053 | 5990 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-06-04 04:20:58 | Jasper, South Carolina, US | |
3581454 | 3581454 | 2022-06-02 | US | South Carolina | Jasper | 45053 | 5990 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-06-03 04:20:58 | Jasper, South Carolina, US | |
973747 | 973747 | 2022-06-01 | US | South Carolina | Jasper | 45053 | 5990 | 93 | 0 | 32.43171982 | -81.02487495 | 2022-06-02 05:20:39 | Jasper, South Carolina, US | |
232711 | 232711 | 2022-05-31 | US | West Virginia | Hampshire | 54027 | 5990 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-06-01 04:20:55 | Hampshire, West Virginia, US | |
1575560 | 1575560 | 2022-05-03 | US | Virginia | Waynesboro | 51820 | 5990 | 69 | 0 | 38.06451466 | -78.90293905 | 2022-05-04 04:20:59 | Waynesboro, Virginia, US | |
2031506 | 2031506 | 2022-04-24 | US | Puerto Rico | Corozal | 72047 | 5990 | 0 | 0 | 18.304264 | -66.327738 | 2022-04-25 04:20:56 | Corozal, Puerto Rico, US | |
2445356 | 2445356 | 2022-04-13 | US | Oklahoma | Texas | 40139 | 5990 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-13 23:21:06 | Texas, Oklahoma, US | |
1951113 | 1951113 | 2022-04-12 | US | Oklahoma | Texas | 40139 | 5990 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-13 04:21:03 | Texas, Oklahoma, US | |
3208866 | 3208866 | 2022-04-11 | US | Oklahoma | Texas | 40139 | 5990 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-12 04:20:49 | Texas, Oklahoma, US | |
1578867 | 1578867 | 2022-04-10 | US | Puerto Rico | Aguada | 72003 | 5990 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-04-11 04:21:02 | Aguada, Puerto Rico, US | |
1578752 | 1578752 | 2022-04-10 | US | Oklahoma | Texas | 40139 | 5990 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-11 04:21:02 | Texas, Oklahoma, US | |
1654994 | 1654994 | 2022-04-09 | US | Oklahoma | Texas | 40139 | 5990 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-10 04:20:52 | Texas, Oklahoma, US | |
2118316 | 2118316 | 2022-04-08 | US | Oklahoma | Texas | 40139 | 5990 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-09 04:20:42 | Texas, Oklahoma, US | |
3322840 | 3322840 | 2022-04-07 | US | Oklahoma | Texas | 40139 | 5990 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-08 04:20:48 | Texas, Oklahoma, US | |
264908 | 264908 | 2022-03-15 | US | Virginia | Mecklenburg | 51117 | 5990 | 110 | 0 | 36.67882005 | -78.36131056 | 2022-03-16 04:20:50 | Mecklenburg, Virginia, US | |
1867434 | 1867434 | 2022-03-10 | US | Missouri | Randolph | 29175 | 5990 | 101 | 0 | 39.44007257 | -92.49713740000001 | 2022-03-11 04:20:50 | Randolph, Missouri, US | |
2142129 | 2142129 | 2022-03-09 | US | Missouri | Randolph | 29175 | 5990 | 100 | 0 | 39.44007257 | -92.49713740000001 | 2022-03-10 04:20:48 | Randolph, Missouri, US | |
921640 | 921640 | 2022-03-08 | US | Missouri | Randolph | 29175 | 5990 | 100 | 0 | 39.44007257 | -92.49713740000001 | 2022-03-09 04:20:59 | Randolph, Missouri, US | |
1060191 | 1060191 | 2022-02-23 | US | North Carolina | Martin | 37117 | 5990 | 85 | 0 | 35.84326734 | -77.10860251 | 2022-02-24 04:21:14 | Martin, North Carolina, US | |
3673086 | 3673086 | 2022-02-15 | US | Kentucky | Lincoln | 21137 | 5990 | 118 | 0 | 37.45475628 | -84.6565327 | 2022-02-16 04:21:10 | Lincoln, Kentucky, US | |
74042 | 74042 | 2022-02-07 | US | Tennessee | Haywood | 47075 | 5990 | 88 | 0 | 35.58332824 | -89.28536625 | 2022-02-08 04:21:15 | Haywood, Tennessee, US | |
460254 | 460254 | 2022-02-02 | US | Georgia | Stephens | 13257 | 5990 | 132 | 0 | 34.55151201 | -83.29405315 | 2022-02-03 04:21:21 | Stephens, Georgia, US | |
459369 | 459369 | 2022-02-02 | Japan | Fukui | 5990 | 38 | 0 | 35.846614 | 136.22465400000002 | 2022-02-03 04:21:21 | Fukui, Japan | |||
3810481 | 3810481 | 2022-01-28 | US | California | Glenn | 6021 | 5990 | 39 | 0 | 39.59875897 | -122.3938452 | 2022-01-29 04:21:10 | Glenn, California, US | |
1141789 | 1141789 | 2022-01-23 | US | Georgia | Sumter | 13261 | 5990 | 145 | 0 | 32.03650571 | -84.19821492 | 2022-01-24 04:21:12 | Sumter, Georgia, US | |
2833707 | 2833707 | 2022-01-22 | US | Georgia | Sumter | 13261 | 5990 | 145 | 0 | 32.03650571 | -84.19821492 | 2022-01-23 04:21:13 | Sumter, Georgia, US | |
3425825 | 3425825 | 2022-01-21 | US | Georgia | Sumter | 13261 | 5990 | 145 | 0 | 32.03650571 | -84.19821492 | 2022-01-22 04:21:13 | Sumter, Georgia, US | |
1961321 | 1961321 | 2022-01-20 | US | Georgia | Butts | 13035 | 5990 | 127 | 0 | 33.283094500000004 | -83.95435040000002 | 2022-01-21 04:21:09 | Butts, Georgia, US | |
1475412 | 1475412 | 2022-01-17 | US | Virginia | Accomack | 51001 | 5990 | 85 | 0 | 37.76707161 | -75.63234615 | 2022-01-18 04:21:04 | Accomack, Virginia, US | |
1473853 | 1473853 | 2022-01-17 | US | Minnesota | Lyon | 27083 | 5990 | 68 | 0 | 44.41327865 | -95.83806103 | 2022-01-18 04:21:04 | Lyon, Minnesota, US | |
556527 | 556527 | 2022-01-16 | US | Minnesota | Lyon | 27083 | 5990 | 68 | 0 | 44.41327865 | -95.83806103 | 2022-01-17 04:21:08 | Lyon, Minnesota, US | |
3842248 | 3842248 | 2022-01-15 | US | Minnesota | Lyon | 27083 | 5990 | 68 | 0 | 44.41327865 | -95.83806103 | 2022-01-16 04:21:12 | Lyon, Minnesota, US | |
101063 | 101063 | 2022-01-14 | US | Minnesota | Lyon | 27083 | 5990 | 68 | 0 | 44.41327865 | -95.83806103 | 2022-01-15 04:21:07 | Lyon, Minnesota, US | |
1435886 | 1435886 | 2021-12-28 | US | Virginia | Charlottesville | 51540 | 5990 | 63 | 0 | 38.03527919 | -78.48569588 | 2021-12-29 03:21:43 | Charlottesville, Virginia, US | |
784110 | 784110 | 2021-12-13 | US | Minnesota | Freeborn | 27047 | 5990 | 50 | 0 | 43.67385583 | -93.34884422 | 2021-12-14 04:22:38 | Freeborn, Minnesota, US | |
405706 | 405706 | 2021-12-07 | US | Kentucky | Harlan | 21095 | 5990 | 145 | 0 | 36.85699301 | -83.21899516 | 2021-12-08 04:22:46 | Harlan, Kentucky, US | |
3291524 | 3291524 | 2021-11-18 | US | Oregon | Benton | 41003 | 5990 | 37 | 0 | 44.49167306 | -123.4316987 | 2021-11-19 04:21:40 | Benton, Oregon, US | |
449069 | 449069 | 2021-11-17 | US | Minnesota | Becker | 27005 | 5990 | 70 | 0 | 46.93479392 | -95.67158144 | 2021-11-18 04:21:33 | Becker, Minnesota, US | |
3345128 | 3345128 | 2021-11-16 | US | Ohio | Preble | 39135 | 5990 | 142 | 0 | 39.7420247 | -84.64787018 | 2021-11-17 04:21:48 | Preble, Ohio, US | |
2290654 | 2290654 | 2021-11-15 | US | Texas | Polk | 48373 | 5990 | 210 | 0 | 30.79472531 | -94.82766240000001 | 2021-11-16 04:21:10 | Polk, Texas, US | |
1325428 | 1325428 | 2021-11-14 | US | Texas | Polk | 48373 | 5990 | 210 | 0 | 30.79472531 | -94.82766240000001 | 2021-11-15 04:21:36 | Polk, Texas, US | |
689554 | 689554 | 2021-11-13 | US | Texas | Polk | 48373 | 5990 | 210 | 0 | 30.79472531 | -94.82766240000001 | 2021-11-14 04:21:31 | Polk, Texas, US | |
717663 | 717663 | 2021-11-12 | US | Texas | Polk | 48373 | 5990 | 210 | 0 | 30.79472531 | -94.82766240000001 | 2021-11-13 04:21:38 | Polk, Texas, US | |
714930 | 714930 | 2021-11-12 | US | Arkansas | Baxter | 5005 | 5990 | 185 | 0 | 36.28784385 | -92.33782872 | 2021-11-13 04:21:38 | Baxter, Arkansas, US | |
3122638 | 3122638 | 2021-11-05 | US | Indiana | Putnam | 18133 | 5990 | 81 | 0 | 39.66437981 | -86.84517605 | 2021-11-06 04:21:51 | Putnam, Indiana, US | |
279230 | 279230 | 2021-11-03 | US | Texas | Cherokee | 48073 | 5990 | 222 | 0 | 31.837258000000002 | -95.16559897 | 2021-11-04 04:22:20 | Cherokee, Texas, US | |
46755 | 46755 | 2021-11-02 | US | Texas | Cherokee | 48073 | 5990 | 221 | 0 | 31.837258000000002 | -95.16559897 | 2021-11-03 06:22:09 | Cherokee, Texas, 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]);