daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
154 rows where confirmed = 5895 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Arkansas | Logan | 5083 | 5895 | 86 | 0 | 35.21413234 | -93.71951016 | 2022-12-30 04:21:04 | Logan, Arkansas, US | |
2022-12-29 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-30 04:21:04 | Marengo, Alabama, US | |
2022-12-28 | US | Arkansas | Logan | 5083 | 5895 | 86 | 0 | 35.21413234 | -93.71951016 | 2022-12-29 04:21:01 | Logan, Arkansas, US | |
2022-12-28 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-29 04:21:01 | Marengo, Alabama, US | |
2022-12-27 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-28 04:21:04 | Marengo, Alabama, US | |
2022-12-26 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-27 04:21:07 | Marengo, Alabama, US | |
2022-12-25 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-26 04:21:06 | Marengo, Alabama, US | |
2022-12-24 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-25 04:21:04 | Marengo, Alabama, US | |
2022-12-23 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-24 04:21:02 | Marengo, Alabama, US | |
2022-12-22 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-23 04:21:04 | Marengo, Alabama, US | |
2022-12-21 | US | Alabama | Marengo | 1091 | 5895 | 115 | 0 | 32.24767634 | -87.78796182 | 2022-12-22 04:20:56 | Marengo, Alabama, US | |
2022-12-11 | US | Tennessee | Johnson | 47091 | 5895 | 107 | 0 | 36.4552395 | -81.84886538 | 2022-12-12 04:21:01 | Johnson, Tennessee, US | |
2022-12-10 | US | Tennessee | Johnson | 47091 | 5895 | 107 | 0 | 36.4552395 | -81.84886538 | 2022-12-11 04:20:50 | Johnson, Tennessee, US | |
2022-11-27 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-28 04:21:02 | Roosevelt, New Mexico, US | |
2022-11-26 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-27 04:21:05 | Roosevelt, New Mexico, US | |
2022-11-25 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-26 04:21:11 | Roosevelt, New Mexico, US | |
2022-11-24 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-25 04:21:06 | Roosevelt, New Mexico, US | |
2022-11-23 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-24 04:21:09 | Roosevelt, New Mexico, US | |
2022-11-22 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-23 04:21:06 | Roosevelt, New Mexico, US | |
2022-11-21 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-22 04:20:47 | Roosevelt, New Mexico, US | |
2022-11-20 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-21 04:21:05 | Roosevelt, New Mexico, US | |
2022-11-19 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-20 04:21:08 | Roosevelt, New Mexico, US | |
2022-11-18 | US | New Mexico | Roosevelt | 35041 | 5895 | 109 | 0 | 34.02097406 | -103.4799493 | 2022-11-19 04:21:14 | Roosevelt, New Mexico, US | |
2022-10-31 | US | Maryland | Somerset | 24039 | 5895 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-11-01 04:22:36 | Somerset, Maryland, US | |
2022-10-30 | US | Maryland | Somerset | 24039 | 5895 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-10-31 04:21:36 | Somerset, Maryland, US | |
2022-10-29 | US | Maryland | Somerset | 24039 | 5895 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-10-30 04:22:14 | Somerset, Maryland, US | |
2022-10-28 | US | Maryland | Somerset | 24039 | 5895 | 77 | 0 | 38.1163542 | -75.75118623 | 2022-10-29 04:21:13 | Somerset, Maryland, US | |
2022-10-06 | US | West Virginia | Brooke | 54009 | 5895 | 106 | 0 | 40.27367263 | -80.57915332 | 2022-10-07 04:23:08 | Brooke, West Virginia, US | |
2022-09-14 | US | Louisiana | Concordia | 22029 | 5895 | 91 | 0 | 31.44817835 | -91.63814433 | 2022-09-15 04:21:02 | Concordia, Louisiana, US | |
2022-09-14 | US | Alabama | Pickens | 1107 | 5895 | 111 | 0 | 33.28094866 | -88.08818103 | 2022-09-15 04:21:02 | Pickens, Alabama, US | |
2022-09-13 | US | Alabama | Pickens | 1107 | 5895 | 111 | 0 | 33.28094866 | -88.08818103 | 2022-09-14 04:20:44 | Pickens, Alabama, US | |
2022-09-12 | US | Alabama | Pickens | 1107 | 5895 | 111 | 0 | 33.28094866 | -88.08818103 | 2022-09-13 04:20:57 | Pickens, Alabama, US | |
2022-09-11 | US | Alabama | Pickens | 1107 | 5895 | 111 | 0 | 33.28094866 | -88.08818103 | 2022-09-12 04:20:58 | Pickens, Alabama, US | |
2022-09-10 | US | Alabama | Pickens | 1107 | 5895 | 111 | 0 | 33.28094866 | -88.08818103 | 2022-09-11 04:20:50 | Pickens, Alabama, US | |
2022-09-09 | US | Alabama | Pickens | 1107 | 5895 | 111 | 0 | 33.28094866 | -88.08818103 | 2022-09-10 04:21:10 | Pickens, Alabama, US | |
2022-09-08 | US | Alabama | Pickens | 1107 | 5895 | 111 | 0 | 33.28094866 | -88.08818103 | 2022-09-09 04:21:11 | Pickens, Alabama, US | |
2022-09-05 | US | Virginia | Powhatan | 51145 | 5895 | 66 | 0 | 37.55016038 | -77.91267882 | 2022-09-06 04:21:02 | Powhatan, Virginia, US | |
2022-08-28 | US | Illinois | Edgar | 17045 | 5895 | 60 | 0 | 39.6809186 | -87.74759563 | 2022-08-29 04:21:06 | Edgar, Illinois, US | |
2022-08-27 | US | Illinois | Edgar | 17045 | 5895 | 60 | 0 | 39.6809186 | -87.74759563 | 2022-08-28 04:21:02 | Edgar, Illinois, US | |
2022-08-26 | US | Illinois | Edgar | 17045 | 5895 | 60 | 0 | 39.6809186 | -87.74759563 | 2022-08-27 04:20:57 | Edgar, Illinois, US | |
2022-08-23 | US | North Carolina | Yancey | 37199 | 5895 | 60 | 0 | 35.90079156 | -82.31237181 | 2022-08-24 04:20:46 | Yancey, North Carolina, US | |
2022-08-22 | US | North Carolina | Yancey | 37199 | 5895 | 60 | 0 | 35.90079156 | -82.31237181 | 2022-08-23 04:20:56 | Yancey, North Carolina, US | |
2022-08-21 | US | North Carolina | Yancey | 37199 | 5895 | 60 | 0 | 35.90079156 | -82.31237181 | 2022-08-22 04:20:38 | Yancey, North Carolina, US | |
2022-08-20 | US | North Carolina | Yancey | 37199 | 5895 | 60 | 0 | 35.90079156 | -82.31237181 | 2022-08-21 04:20:44 | Yancey, North Carolina, US | |
2022-08-19 | US | North Carolina | Yancey | 37199 | 5895 | 60 | 0 | 35.90079156 | -82.31237181 | 2022-08-20 04:21:01 | Yancey, North Carolina, US | |
2022-08-18 | US | North Carolina | Yancey | 37199 | 5895 | 60 | 0 | 35.90079156 | -82.31237181 | 2022-08-19 04:20:54 | Yancey, North Carolina, US | |
2022-08-17 | US | North Carolina | Yancey | 37199 | 5895 | 60 | 0 | 35.90079156 | -82.31237181 | 2022-08-18 04:21:11 | Yancey, North Carolina, US | |
2022-08-13 | Russia | Chukotka Autonomous Okrug | 5895 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-08-14 04:20:55 | Chukotka Autonomous Okrug, Russia | |||
2022-08-12 | US | Arkansas | Clark | 5019 | 5895 | 86 | 0 | 34.04613432 | -93.17484713 | 2022-08-13 04:20:52 | Clark, Arkansas, US | |
2022-08-04 | US | Virginia | King George | 51099 | 5895 | 45 | 0 | 38.26818502 | -77.15852768 | 2022-08-05 04:20:52 | King George, Virginia, US | |
2022-06-12 | US | Indiana | LaGrange | 18087 | 5895 | 103 | 0 | 41.64232188 | -85.42674232 | 2022-06-13 04:21:14 | LaGrange, Indiana, US | |
2022-06-11 | US | Indiana | LaGrange | 18087 | 5895 | 103 | 0 | 41.64232188 | -85.42674232 | 2022-06-12 04:20:53 | LaGrange, Indiana, US | |
2022-06-10 | US | Indiana | LaGrange | 18087 | 5895 | 103 | 0 | 41.64232188 | -85.42674232 | 2022-06-11 04:21:01 | LaGrange, Indiana, US | |
2022-05-25 | US | Tennessee | Chester | 47023 | 5895 | 99 | 0 | 35.42527478 | -88.6095842 | 2022-05-26 04:20:50 | Chester, Tennessee, US | |
2022-05-16 | US | Minnesota | Dodge | 27039 | 5895 | 21 | 0 | 44.02238415 | -92.86244324 | 2022-05-17 04:20:59 | Dodge, Minnesota, US | |
2022-05-03 | US | Texas | Frio | 48163 | 5895 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-05-04 04:20:59 | Frio, Texas, US | |
2022-05-02 | US | Texas | Frio | 48163 | 5895 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-05-03 04:21:00 | Frio, Texas, US | |
2022-05-01 | US | Texas | Frio | 48163 | 5895 | 93 | 0 | 28.86751206 | -99.10804207 | 2022-05-02 04:21:10 | Frio, Texas, US | |
2022-04-17 | US | Indiana | Randolph | 18135 | 5895 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-04-18 04:21:12 | Randolph, Indiana, US | |
2022-04-16 | US | Indiana | Randolph | 18135 | 5895 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-04-17 04:20:59 | Randolph, Indiana, US | |
2022-04-15 | US | Indiana | Randolph | 18135 | 5895 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-04-16 04:20:48 | Randolph, Indiana, US | |
2022-04-14 | US | Indiana | Randolph | 18135 | 5895 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-04-15 04:20:57 | Randolph, Indiana, US | |
2022-04-13 | US | Indiana | Randolph | 18135 | 5895 | 148 | 0 | 40.15734772 | -85.01139319 | 2022-04-13 23:21:06 | Randolph, Indiana, US | |
2022-04-05 | US | Indiana | Randolph | 18135 | 5895 | 147 | 0 | 40.15734772 | -85.01139319 | 2022-04-06 04:20:49 | Randolph, Indiana, US | |
2022-04-04 | US | Indiana | Randolph | 18135 | 5895 | 147 | 0 | 40.15734772 | -85.01139319 | 2022-04-05 04:20:48 | Randolph, Indiana, US | |
2022-03-06 | US | Puerto Rico | Dorado | 72051 | 5895 | 0 | 0 | 18.436115 | -66.278669 | 2022-03-07 04:20:47 | Dorado, Puerto Rico, US | |
2022-03-02 | US | Kentucky | Johnson | 21115 | 5895 | 96 | 0 | 37.85106355 | -82.8264322 | 2022-03-03 04:21:01 | Johnson, Kentucky, US | |
2022-02-17 | US | Mississippi | Wayne | 28153 | 5895 | 84 | 0 | 31.64135687 | -88.69573913 | 2022-02-18 04:21:04 | Wayne, Mississippi, US | |
2022-02-16 | US | Mississippi | Wayne | 28153 | 5895 | 84 | 0 | 31.64135687 | -88.69573913 | 2022-02-17 04:20:56 | Wayne, Mississippi, US | |
2022-02-06 | Japan | Tokushima | 5895 | 68 | 0 | 33.919178 | 134.242091 | 2022-02-07 04:21:05 | Tokushima, Japan | |||
2022-01-23 | US | West Virginia | Nicholas | 54067 | 5895 | 78 | 0 | 38.29617706 | -80.79759588 | 2022-01-24 04:21:12 | Nicholas, West Virginia, US | |
2021-12-21 | US | Missouri | Laclede | 29105 | 5895 | 152 | 0 | 37.65896829 | -92.5888493 | 2021-12-22 04:21:54 | Laclede, Missouri, US | |
2021-12-18 | US | California | Amador | 6005 | 5895 | 69 | 0 | 38.44583082 | -120.65696000000001 | 2021-12-19 04:21:11 | Amador, California, US | |
2021-12-17 | US | California | Amador | 6005 | 5895 | 69 | 0 | 38.44583082 | -120.65696000000001 | 2021-12-18 02:22:20 | Amador, California, US | |
2021-12-16 | US | Maine | Somerset | 23025 | 5895 | 68 | 0 | 45.51229767 | -69.95995554 | 2021-12-17 04:22:14 | Somerset, Maine, US | |
2021-12-16 | US | California | Amador | 6005 | 5895 | 69 | 0 | 38.44583082 | -120.65696000000001 | 2021-12-17 04:22:14 | Amador, California, US | |
2021-12-14 | US | Oklahoma | McCurtain | 40089 | 5895 | 129 | 0 | 34.11664328 | -94.77222373 | 2021-12-15 03:22:16 | McCurtain, Oklahoma, US | |
2021-12-13 | US | Oklahoma | McCurtain | 40089 | 5895 | 129 | 0 | 34.11664328 | -94.77222373 | 2021-12-14 04:22:38 | McCurtain, Oklahoma, US | |
2021-12-12 | US | Oklahoma | McCurtain | 40089 | 5895 | 129 | 0 | 34.11664328 | -94.77222373 | 2021-12-13 04:22:02 | McCurtain, Oklahoma, US | |
2021-12-11 | US | Oklahoma | McCurtain | 40089 | 5895 | 129 | 0 | 34.11664328 | -94.77222373 | 2021-12-12 04:22:12 | McCurtain, Oklahoma, US | |
2021-12-10 | US | Oklahoma | McCurtain | 40089 | 5895 | 129 | 0 | 34.11664328 | -94.77222373 | 2021-12-11 04:22:45 | McCurtain, Oklahoma, US | |
2021-12-09 | US | Oklahoma | McCurtain | 40089 | 5895 | 129 | 0 | 34.11664328 | -94.77222373 | 2021-12-10 04:22:28 | McCurtain, Oklahoma, US | |
2021-12-08 | US | Wyoming | Sheridan | 56033 | 5895 | 59 | 0 | 44.79048913 | -106.8862389 | 2021-12-09 04:22:49 | Sheridan, Wyoming, US | |
2021-12-08 | US | Oklahoma | McCurtain | 40089 | 5895 | 129 | 0 | 34.11664328 | -94.77222373 | 2021-12-09 04:22:49 | McCurtain, Oklahoma, US | |
2021-12-01 | US | Tennessee | Marion | 47115 | 5895 | 66 | 0 | 35.12997174 | -85.62265895 | 2021-12-02 04:22:37 | Marion, Tennessee, US | |
2021-11-30 | US | Tennessee | Carroll | 47017 | 5895 | 109 | 0 | 35.97366108 | -88.45189331 | 2021-12-01 04:22:29 | Carroll, Tennessee, US | |
2021-11-29 | US | North Carolina | Jackson | 37099 | 5895 | 72 | 0 | 35.28814273 | -83.14093385 | 2021-11-30 04:22:53 | Jackson, North Carolina, US | |
2021-11-22 | US | Texas | Wood | 48499 | 5895 | 230 | 0 | 32.78722382 | -95.38236368 | 2021-11-23 04:22:39 | Wood, Texas, US | |
2021-11-21 | US | Texas | Wood | 48499 | 5895 | 230 | 0 | 32.78722382 | -95.38236368 | 2021-11-22 04:22:20 | Wood, Texas, US | |
2021-11-20 | US | Texas | Wood | 48499 | 5895 | 230 | 0 | 32.78722382 | -95.38236368 | 2021-11-21 04:22:13 | Wood, Texas, US | |
2021-11-18 | US | Texas | Grimes | 48185 | 5895 | 108 | 0 | 30.54579585 | -95.98902499 | 2021-11-19 04:21:40 | Grimes, Texas, US | |
2021-11-09 | US | Mississippi | Pike | 28113 | 5895 | 155 | 0 | 31.17507789 | -90.40392572 | 2021-11-10 04:21:38 | Pike, Mississippi, US | |
2021-11-08 | Japan | Aomori | 5895 | 38 | 0 | 40.781541 | 140.828896 | 2021-11-09 04:21:36 | Aomori, Japan | |||
2021-11-07 | Japan | Aomori | 5895 | 38 | 0 | 40.781541 | 140.828896 | 2021-11-08 04:21:43 | Aomori, Japan | |||
2021-11-06 | Japan | Aomori | 5895 | 38 | 0 | 40.781541 | 140.828896 | 2021-11-07 04:21:53 | Aomori, Japan | |||
2021-11-05 | Japan | Aomori | 5895 | 38 | 0 | 40.781541 | 140.828896 | 2021-11-06 04:21:51 | Aomori, Japan | |||
2021-11-04 | Japan | Aomori | 5895 | 38 | 0 | 40.781541 | 140.828896 | 2021-11-05 04:21:54 | Aomori, Japan | |||
2021-11-03 | Japan | Aomori | 5895 | 38 | 0 | 40.781541 | 140.828896 | 2021-11-04 04:22:20 | Aomori, Japan | |||
2021-11-02 | Japan | Aomori | 5895 | 38 | 0 | 40.781541 | 140.828896 | 2021-11-03 06:22:09 | Aomori, Japan | |||
2021-09-30 | US | Texas | Bee | 48025 | 5895 | 113 | 0 | 28.41761668 | -97.74215593 | 2021-10-01 04:21:35 | Bee, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;