daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
157 rows where confirmed = 5596 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-26 | US | Puerto Rico | Penuelas | 72111 | 5596 | 0 | 0 | 18.059645 | -66.721572 | 2022-12-27 04:21:07 | Penuelas, Puerto Rico, US | |
2022-12-25 | US | Puerto Rico | Penuelas | 72111 | 5596 | 0 | 0 | 18.059645 | -66.721572 | 2022-12-26 04:21:06 | Penuelas, Puerto Rico, US | |
2022-12-24 | US | Puerto Rico | Penuelas | 72111 | 5596 | 0 | 0 | 18.059645 | -66.721572 | 2022-12-25 04:21:04 | Penuelas, Puerto Rico, US | |
2022-12-06 | US | Iowa | Mahaska | 19123 | 5596 | 92 | 0 | 41.33521503 | -92.64083907 | 2022-12-07 04:20:58 | Mahaska, Iowa, US | |
2022-12-05 | US | Iowa | Mahaska | 19123 | 5596 | 92 | 0 | 41.33521503 | -92.64083907 | 2022-12-06 04:21:03 | Mahaska, Iowa, US | |
2022-12-04 | US | Iowa | Mahaska | 19123 | 5596 | 92 | 0 | 41.33521503 | -92.64083907 | 2022-12-05 04:20:58 | Mahaska, Iowa, US | |
2022-12-03 | US | Iowa | Mahaska | 19123 | 5596 | 92 | 0 | 41.33521503 | -92.64083907 | 2022-12-04 04:20:56 | Mahaska, Iowa, US | |
2022-12-02 | US | Iowa | Mahaska | 19123 | 5596 | 92 | 0 | 41.33521503 | -92.64083907 | 2022-12-03 04:21:02 | Mahaska, Iowa, US | |
2022-12-01 | US | Iowa | Mahaska | 19123 | 5596 | 92 | 0 | 41.33521503 | -92.64083907 | 2022-12-02 04:21:07 | Mahaska, Iowa, US | |
2022-11-30 | US | Iowa | Mahaska | 19123 | 5596 | 92 | 0 | 41.33521503 | -92.64083907 | 2022-12-01 04:21:03 | Mahaska, Iowa, US | |
2022-11-29 | US | Indiana | Jay | 18075 | 5596 | 85 | 0 | 40.43781032 | -85.00576229 | 2022-11-30 04:21:07 | Jay, Indiana, US | |
2022-11-28 | US | Indiana | Jay | 18075 | 5596 | 85 | 0 | 40.43781032 | -85.00576229 | 2022-11-29 04:21:05 | Jay, Indiana, US | |
2022-11-27 | US | Indiana | Jay | 18075 | 5596 | 85 | 0 | 40.43781032 | -85.00576229 | 2022-11-28 04:21:02 | Jay, Indiana, US | |
2022-11-26 | US | Indiana | Jay | 18075 | 5596 | 85 | 0 | 40.43781032 | -85.00576229 | 2022-11-27 04:21:05 | Jay, Indiana, US | |
2022-11-25 | US | Indiana | Jay | 18075 | 5596 | 85 | 0 | 40.43781032 | -85.00576229 | 2022-11-26 04:21:11 | Jay, Indiana, US | |
2022-11-24 | US | Indiana | Jay | 18075 | 5596 | 85 | 0 | 40.43781032 | -85.00576229 | 2022-11-25 04:21:06 | Jay, Indiana, US | |
2022-11-23 | US | Indiana | Jay | 18075 | 5596 | 85 | 0 | 40.43781032 | -85.00576229 | 2022-11-24 04:21:09 | Jay, Indiana, US | |
2022-11-02 | US | Oklahoma | Craig | 40035 | 5596 | 56 | 0 | 36.76268118 | -95.20916602 | 2022-11-03 04:22:05 | Craig, Oklahoma, US | |
2022-11-01 | US | Oklahoma | Craig | 40035 | 5596 | 56 | 0 | 36.76268118 | -95.20916602 | 2022-11-02 04:22:09 | Craig, Oklahoma, US | |
2022-11-01 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-11-02 04:22:09 | Tattnall, Georgia, US | |
2022-10-31 | US | Oklahoma | Craig | 40035 | 5596 | 56 | 0 | 36.76268118 | -95.20916602 | 2022-11-01 04:22:36 | Craig, Oklahoma, US | |
2022-10-31 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-11-01 04:22:36 | Tattnall, Georgia, US | |
2022-10-30 | US | Oklahoma | Craig | 40035 | 5596 | 56 | 0 | 36.76268118 | -95.20916602 | 2022-10-31 04:21:36 | Craig, Oklahoma, US | |
2022-10-30 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-31 04:21:36 | Tattnall, Georgia, US | |
2022-10-30 | US | Colorado | Elbert | 8039 | 5596 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-31 04:21:36 | Elbert, Colorado, US | |
2022-10-29 | US | Oklahoma | Craig | 40035 | 5596 | 56 | 0 | 36.76268118 | -95.20916602 | 2022-10-30 04:22:14 | Craig, Oklahoma, US | |
2022-10-29 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-30 04:22:14 | Tattnall, Georgia, US | |
2022-10-29 | US | Colorado | Elbert | 8039 | 5596 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-30 04:22:14 | Elbert, Colorado, US | |
2022-10-28 | US | Oklahoma | Craig | 40035 | 5596 | 56 | 0 | 36.76268118 | -95.20916602 | 2022-10-29 04:21:13 | Craig, Oklahoma, US | |
2022-10-28 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-29 04:21:13 | Tattnall, Georgia, US | |
2022-10-28 | US | Colorado | Elbert | 8039 | 5596 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-29 04:21:13 | Elbert, Colorado, US | |
2022-10-27 | US | Oklahoma | Craig | 40035 | 5596 | 56 | 0 | 36.76268118 | -95.20916602 | 2022-10-28 04:22:31 | Craig, Oklahoma, US | |
2022-10-27 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-28 04:22:31 | Tattnall, Georgia, US | |
2022-10-27 | US | Colorado | Elbert | 8039 | 5596 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-28 04:22:31 | Elbert, Colorado, US | |
2022-10-26 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-27 04:22:01 | Tattnall, Georgia, US | |
2022-10-25 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-26 04:22:19 | Tattnall, Georgia, US | |
2022-10-24 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-25 04:21:53 | Tattnall, Georgia, US | |
2022-10-23 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-24 04:22:29 | Tattnall, Georgia, US | |
2022-10-22 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-23 04:22:46 | Tattnall, Georgia, US | |
2022-10-21 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-22 04:22:53 | Tattnall, Georgia, US | |
2022-10-20 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-21 04:22:23 | Tattnall, Georgia, US | |
2022-10-19 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-20 04:22:59 | Tattnall, Georgia, US | |
2022-10-12 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-13 04:22:39 | Orange, Indiana, US | |
2022-10-11 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-12 04:22:51 | Orange, Indiana, US | |
2022-10-11 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-12 04:22:51 | Tattnall, Georgia, US | |
2022-10-10 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-11 04:23:05 | Orange, Indiana, US | |
2022-10-10 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-11 04:23:05 | Tattnall, Georgia, US | |
2022-10-09 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-10 04:22:32 | Orange, Indiana, US | |
2022-10-09 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-10 04:22:32 | Tattnall, Georgia, US | |
2022-10-08 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-09 04:21:16 | Orange, Indiana, US | |
2022-10-08 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-09 04:21:16 | Tattnall, Georgia, US | |
2022-10-07 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-08 04:22:56 | Orange, Indiana, US | |
2022-10-07 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-08 04:22:56 | Tattnall, Georgia, US | |
2022-10-06 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-07 04:23:08 | Orange, Indiana, US | |
2022-10-06 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-07 04:23:08 | Tattnall, Georgia, US | |
2022-10-05 | US | Indiana | Orange | 18117 | 5596 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-06 04:21:22 | Orange, Indiana, US | |
2022-10-05 | US | Georgia | Tattnall | 13267 | 5596 | 141 | 0 | 32.04785085 | -82.05539188 | 2022-10-06 04:21:22 | Tattnall, Georgia, US | |
2022-09-17 | US | Tennessee | Humphreys | 47085 | 5596 | 80 | 0 | 36.03958805 | -87.77992872 | 2022-09-18 04:22:50 | Humphreys, Tennessee, US | |
2022-09-16 | US | Tennessee | Humphreys | 47085 | 5596 | 80 | 0 | 36.03958805 | -87.77992872 | 2022-09-17 04:20:19 | Humphreys, Tennessee, US | |
2022-07-29 | US | Arkansas | Randolph | 5121 | 5596 | 94 | 0 | 36.3415714 | -91.02455531 | 2022-07-30 04:20:42 | Randolph, Arkansas, US | |
2022-07-12 | US | Puerto Rico | Catano | 72033 | 5596 | 0 | 0 | 18.437269 | -66.143306 | 2022-07-13 04:20:58 | Catano, Puerto Rico, US | |
2022-07-11 | US | Puerto Rico | Catano | 72033 | 5596 | 0 | 0 | 18.437269 | -66.143306 | 2022-07-12 04:20:51 | Catano, Puerto Rico, US | |
2022-07-11 | US | Illinois | Wayne | 17191 | 5596 | 84 | 0 | 38.42955355 | -88.42586459 | 2022-07-12 04:20:51 | Wayne, Illinois, US | |
2022-06-28 | US | Puerto Rico | Aibonito | 72009 | 5596 | 0 | 0 | 18.131361 | -66.264131 | 2022-06-29 04:20:59 | Aibonito, Puerto Rico, US | |
2022-06-12 | US | Mississippi | Grenada | 28043 | 5596 | 131 | 0 | 33.77036166 | -89.80245083 | 2022-06-13 04:21:14 | Grenada, Mississippi, US | |
2022-06-11 | US | Mississippi | Grenada | 28043 | 5596 | 131 | 0 | 33.77036166 | -89.80245083 | 2022-06-12 04:20:53 | Grenada, Mississippi, US | |
2022-06-10 | US | Mississippi | Grenada | 28043 | 5596 | 131 | 0 | 33.77036166 | -89.80245083 | 2022-06-11 04:21:01 | Grenada, Mississippi, US | |
2022-06-09 | US | Mississippi | Grenada | 28043 | 5596 | 131 | 0 | 33.77036166 | -89.80245083 | 2022-06-10 04:20:55 | Grenada, Mississippi, US | |
2022-06-08 | US | Mississippi | Grenada | 28043 | 5596 | 131 | 0 | 33.77036166 | -89.80245083 | 2022-06-09 04:20:54 | Grenada, Mississippi, US | |
2022-06-07 | US | Mississippi | Grenada | 28043 | 5596 | 131 | 0 | 33.77036166 | -89.80245083 | 2022-06-08 04:20:55 | Grenada, Mississippi, US | |
2022-06-06 | US | Mississippi | Grenada | 28043 | 5596 | 131 | 0 | 33.77036166 | -89.80245083 | 2022-06-07 04:21:08 | Grenada, Mississippi, US | |
2022-05-21 | US | Idaho | Payette | 16075 | 5596 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-05-22 04:20:52 | Payette, Idaho, US | |
2022-05-20 | US | Idaho | Payette | 16075 | 5596 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-05-21 04:20:58 | Payette, Idaho, US | |
2022-05-11 | Saint Kitts and Nevis | 5596 | 43 | 0 | 17.357822 | -62.782998 | 2022-05-12 04:20:54 | Saint Kitts and Nevis | ||||
2022-05-04 | US | Texas | San Jacinto | 48407 | 5596 | 101 | 0 | 30.57933681 | -95.16260304 | 2022-05-05 04:20:55 | San Jacinto, Texas, US | |
2022-04-22 | US | Texas | Moore | 48341 | 5596 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-04-23 04:20:50 | Moore, Texas, US | |
2022-04-12 | US | Michigan | Alpena | 26007 | 5596 | 136 | 0 | 45.03477666 | -83.62212411 | 2022-04-13 04:21:03 | Alpena, Michigan, US | |
2022-04-11 | US | Michigan | Alpena | 26007 | 5596 | 136 | 0 | 45.03477666 | -83.62212411 | 2022-04-12 04:20:49 | Alpena, Michigan, US | |
2022-04-10 | US | Michigan | Alpena | 26007 | 5596 | 136 | 0 | 45.03477666 | -83.62212411 | 2022-04-11 04:21:02 | Alpena, Michigan, US | |
2022-04-09 | US | Michigan | Alpena | 26007 | 5596 | 136 | 0 | 45.03477666 | -83.62212411 | 2022-04-10 04:20:52 | Alpena, Michigan, US | |
2022-04-08 | US | Michigan | Alpena | 26007 | 5596 | 136 | 0 | 45.03477666 | -83.62212411 | 2022-04-09 04:20:42 | Alpena, Michigan, US | |
2022-04-07 | US | Michigan | Alpena | 26007 | 5596 | 136 | 0 | 45.03477666 | -83.62212411 | 2022-04-08 04:20:48 | Alpena, Michigan, US | |
2022-04-06 | US | Michigan | Alpena | 26007 | 5596 | 136 | 0 | 45.03477666 | -83.62212411 | 2022-04-07 04:20:53 | Alpena, Michigan, US | |
2022-03-17 | US | Virginia | Salem | 51775 | 5596 | 95 | 0 | 37.2836193 | -80.06219455 | 2022-03-18 04:20:55 | Salem, Virginia, US | |
2022-03-09 | US | Texas | Austin | 48015 | 5596 | 71 | 0 | 29.88548725 | -96.27736949 | 2022-03-10 04:20:48 | Austin, Texas, US | |
2022-02-21 | US | Wisconsin | Jackson | 55053 | 5596 | 41 | 0 | 44.31864893 | -90.80566792 | 2022-02-22 04:21:01 | Jackson, Wisconsin, US | |
2022-02-12 | US | West Virginia | Hampshire | 54027 | 5596 | 64 | 0 | 39.32103553 | -78.60826476 | 2022-02-13 04:21:00 | Hampshire, West Virginia, US | |
2022-01-26 | US | Georgia | Harris | 13145 | 5596 | 97 | 0 | 32.73709786 | -84.90538572 | 2022-01-27 04:21:19 | Harris, Georgia, US | |
2022-01-19 | US | Georgia | Decatur | 13087 | 5596 | 112 | 0 | 30.87967778 | -84.57619536 | 2022-01-20 04:21:07 | Decatur, Georgia, US | |
2022-01-17 | US | Illinois | Perry | 17145 | 5596 | 87 | 0 | 38.08510853 | -89.36856219 | 2022-01-18 04:21:04 | Perry, Illinois, US | |
2022-01-16 | US | Texas | DeWitt | 48123 | 5596 | 86 | 0 | 29.08101855 | -97.35681170000001 | 2022-01-17 04:21:08 | DeWitt, Texas, US | |
2022-01-16 | US | Illinois | Perry | 17145 | 5596 | 87 | 0 | 38.08510853 | -89.36856219 | 2022-01-17 04:21:08 | Perry, Illinois, US | |
2022-01-15 | US | Illinois | Perry | 17145 | 5596 | 87 | 0 | 38.08510853 | -89.36856219 | 2022-01-16 04:21:12 | Perry, Illinois, US | |
2022-01-14 | US | Illinois | Perry | 17145 | 5596 | 87 | 0 | 38.08510853 | -89.36856219 | 2022-01-15 04:21:07 | Perry, Illinois, US | |
2022-01-12 | US | Kentucky | Clay | 21051 | 5596 | 69 | 0 | 37.16451126 | -83.712575 | 2022-01-13 08:00:09 | Clay, Kentucky, US | |
2021-12-03 | US | Tennessee | Henry | 47079 | 5596 | 94 | 0 | 36.33160906 | -88.30121797 | 2021-12-04 04:22:18 | Henry, Tennessee, US | |
2021-12-02 | US | Tennessee | Macon | 47111 | 5596 | 99 | 0 | 36.53157855 | -86.00778595 | 2021-12-03 04:23:05 | Macon, Tennessee, US | |
2021-11-30 | US | Minnesota | Freeborn | 27047 | 5596 | 46 | 0 | 43.67385583 | -93.34884422 | 2021-12-01 04:22:29 | Freeborn, Minnesota, US | |
2021-11-17 | US | Pennsylvania | McKean | 42083 | 5596 | 97 | 0 | 41.80938602 | -78.56478358 | 2021-11-18 04:21:33 | McKean, Pennsylvania, US | |
2021-11-07 | US | New York | Tioga | 36107 | 5596 | 73 | 0 | 42.16852837 | -76.30835812 | 2021-11-08 04:21:43 | Tioga, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;