daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
136 rows where confirmed = 5485 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-01 | US | Maine | Washington | 23029 | 5485 | 64 | 0 | 45.01607142 | -67.62813524 | 2022-12-02 04:21:07 | Washington, Maine, US | |
2022-11-28 | US | Tennessee | Polk | 47139 | 5485 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-29 04:21:05 | Polk, Tennessee, US | |
2022-11-22 | US | Arkansas | Sharp | 5135 | 5485 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-11-23 04:21:06 | Sharp, Arkansas, US | |
2022-11-21 | US | Arkansas | Sharp | 5135 | 5485 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-11-22 04:20:47 | Sharp, Arkansas, US | |
2022-11-01 | US | Colorado | Chaffee | 8015 | 5485 | 56 | 0 | 38.74745778 | -106.1926573 | 2022-11-02 04:22:09 | Chaffee, Colorado, US | |
2022-10-23 | US | Colorado | Alamosa | 8003 | 5485 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-24 04:22:29 | Alamosa, Colorado, US | |
2022-10-22 | US | Colorado | Alamosa | 8003 | 5485 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-23 04:22:46 | Alamosa, Colorado, US | |
2022-10-21 | US | Colorado | Alamosa | 8003 | 5485 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-22 04:22:53 | Alamosa, Colorado, US | |
2022-08-24 | US | West Virginia | Barbour | 54001 | 5485 | 76 | 0 | 39.1307219 | -80.00350858 | 2022-08-25 04:21:13 | Barbour, West Virginia, US | |
2022-08-09 | US | Oregon | Union | 41061 | 5485 | 85 | 0 | 45.30915495 | -118.0068979 | 2022-08-10 04:20:57 | Union, Oregon, US | |
2022-08-03 | US | Tennessee | Johnson | 47091 | 5485 | 98 | 0 | 36.4552395 | -81.84886538 | 2022-08-04 04:20:58 | Johnson, Tennessee, US | |
2022-07-13 | US | Alabama | Marengo | 1091 | 5485 | 108 | 0 | 32.24767634 | -87.78796182 | 2022-07-14 04:20:57 | Marengo, Alabama, US | |
2022-06-29 | US | Arkansas | Lawrence | 5075 | 5485 | 82 | 0 | 36.04188196 | -91.10867198 | 2022-06-30 04:21:01 | Lawrence, Arkansas, US | |
2022-06-20 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-21 04:20:56 | Stone, Mississippi, US | |
2022-06-19 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-20 04:21:01 | Stone, Mississippi, US | |
2022-06-18 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-19 04:20:51 | Stone, Mississippi, US | |
2022-06-17 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-18 04:21:10 | Stone, Mississippi, US | |
2022-06-16 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-17 04:20:56 | Stone, Mississippi, US | |
2022-06-15 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-16 04:20:55 | Stone, Mississippi, US | |
2022-06-14 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-15 04:20:54 | Stone, Mississippi, US | |
2022-06-13 | US | Mississippi | Stone | 28131 | 5485 | 72 | 0 | 30.79187949 | -89.11547539 | 2022-06-14 04:20:52 | Stone, Mississippi, US | |
2022-06-04 | US | Texas | Gillespie | 48171 | 5485 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-06-05 04:20:55 | Gillespie, Texas, US | |
2022-05-09 | US | Arkansas | Conway | 5029 | 5485 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-05-10 04:20:50 | Conway, Arkansas, US | |
2022-04-27 | US | Illinois | Lawrence | 17101 | 5485 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-04-28 04:20:47 | Lawrence, Illinois, US | |
2022-04-25 | US | Illinois | Lawrence | 17101 | 5485 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-04-26 04:20:51 | Lawrence, Illinois, US | |
2022-04-18 | US | Illinois | Lawrence | 17101 | 5485 | 42 | 0 | 38.71987914 | -87.72884035 | 2022-04-19 04:21:00 | Lawrence, Illinois, US | |
2022-04-17 | US | Illinois | Lawrence | 17101 | 5485 | 42 | 0 | 38.71987914 | -87.72884035 | 2022-04-18 04:21:12 | Lawrence, Illinois, US | |
2022-04-16 | US | Puerto Rico | Cayey | 72035 | 5485 | 0 | 0 | 18.102851 | -66.14914 | 2022-04-17 04:20:59 | Cayey, Puerto Rico, US | |
2022-04-16 | US | Illinois | Lawrence | 17101 | 5485 | 42 | 0 | 38.71987914 | -87.72884035 | 2022-04-17 04:20:59 | Lawrence, Illinois, US | |
2022-04-15 | US | Puerto Rico | Cayey | 72035 | 5485 | 0 | 0 | 18.102851 | -66.14914 | 2022-04-16 04:20:48 | Cayey, Puerto Rico, US | |
2022-04-15 | US | Illinois | Lawrence | 17101 | 5485 | 42 | 0 | 38.71987914 | -87.72884035 | 2022-04-16 04:20:48 | Lawrence, Illinois, US | |
2022-04-14 | US | Puerto Rico | Cayey | 72035 | 5485 | 0 | 0 | 18.102851 | -66.14914 | 2022-04-15 04:20:57 | Cayey, Puerto Rico, US | |
2022-04-14 | US | Illinois | Lawrence | 17101 | 5485 | 42 | 0 | 38.71987914 | -87.72884035 | 2022-04-15 04:20:57 | Lawrence, Illinois, US | |
2022-04-11 | US | Illinois | Lawrence | 17101 | 5485 | 42 | 0 | 38.71987914 | -87.72884035 | 2022-04-12 04:20:49 | Lawrence, Illinois, US | |
2022-04-06 | US | Puerto Rico | San Sebastian | 72131 | 5485 | 0 | 0 | 18.328646 | -66.971214 | 2022-04-07 04:20:53 | San Sebastian, Puerto Rico, US | |
2022-04-05 | US | Iowa | Bremer | 19017 | 5485 | 82 | 0 | 42.77461496 | -92.31795937 | 2022-04-06 04:20:49 | Bremer, Iowa, US | |
2022-04-04 | US | Iowa | Bremer | 19017 | 5485 | 82 | 0 | 42.77461496 | -92.31795937 | 2022-04-05 04:20:48 | Bremer, Iowa, US | |
2022-04-03 | US | Iowa | Bremer | 19017 | 5485 | 82 | 0 | 42.77461496 | -92.31795937 | 2022-04-04 04:20:51 | Bremer, Iowa, US | |
2022-04-02 | US | Iowa | Bremer | 19017 | 5485 | 82 | 0 | 42.77461496 | -92.31795937 | 2022-04-03 04:20:48 | Bremer, Iowa, US | |
2022-04-01 | US | Iowa | Bremer | 19017 | 5485 | 82 | 0 | 42.77461496 | -92.31795937 | 2022-04-02 04:20:47 | Bremer, Iowa, US | |
2022-03-31 | US | Iowa | Bremer | 19017 | 5485 | 82 | 0 | 42.77461496 | -92.31795937 | 2022-04-01 04:20:28 | Bremer, Iowa, US | |
2022-03-30 | US | Puerto Rico | Juana Diaz | 72075 | 5485 | 0 | 0 | 18.050764 | -66.49458100000001 | 2022-03-31 04:20:56 | Juana Diaz, Puerto Rico, US | |
2022-03-30 | US | Iowa | Bremer | 19017 | 5485 | 82 | 0 | 42.77461496 | -92.31795937 | 2022-03-31 04:20:56 | Bremer, Iowa, US | |
2022-03-22 | US | Missouri | Adair | 29001 | 5485 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-22 23:20:51 | Adair, Missouri, US | |
2022-03-20 | US | Missouri | Adair | 29001 | 5485 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-21 04:20:50 | Adair, Missouri, US | |
2022-03-19 | US | Missouri | Adair | 29001 | 5485 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-20 04:20:45 | Adair, Missouri, US | |
2022-03-18 | US | Missouri | Adair | 29001 | 5485 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-19 04:20:47 | Adair, Missouri, US | |
2022-03-17 | US | Missouri | Adair | 29001 | 5485 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-18 04:20:55 | Adair, Missouri, US | |
2022-03-16 | US | Missouri | Adair | 29001 | 5485 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-17 04:20:56 | Adair, Missouri, US | |
2022-03-07 | US | California | Unassigned | 90006 | 5485 | 3 | 0 | 41.74228275 | 0.0 | 2022-03-08 04:20:54 | Unassigned, California, US | |
2022-02-23 | US | Minnesota | Martin | 27091 | 5485 | 59 | 0 | 43.67429718 | -94.55099908 | 2022-02-24 04:21:14 | Martin, Minnesota, US | |
2022-02-22 | US | Iowa | Henry | 19087 | 5485 | 65 | 0 | 40.98767962 | -91.54436349 | 2022-02-23 04:21:09 | Henry, Iowa, US | |
2022-02-21 | US | Virginia | Staunton | 51790 | 5485 | 100 | 0 | 38.15965544 | -79.05979937 | 2022-02-22 04:21:01 | Staunton, Virginia, US | |
2022-02-21 | US | Iowa | Henry | 19087 | 5485 | 65 | 0 | 40.98767962 | -91.54436349 | 2022-02-22 04:21:01 | Henry, Iowa, US | |
2022-02-20 | US | Iowa | Henry | 19087 | 5485 | 65 | 0 | 40.98767962 | -91.54436349 | 2022-02-21 04:21:05 | Henry, Iowa, US | |
2022-02-19 | US | Iowa | Henry | 19087 | 5485 | 65 | 0 | 40.98767962 | -91.54436349 | 2022-02-20 04:21:00 | Henry, Iowa, US | |
2022-02-18 | US | Puerto Rico | Vega Alta | 72143 | 5485 | 0 | 0 | 18.409346 | -66.33725 | 2022-02-19 04:21:11 | Vega Alta, Puerto Rico, US | |
2022-02-18 | US | Iowa | Henry | 19087 | 5485 | 65 | 0 | 40.98767962 | -91.54436349 | 2022-02-19 04:21:11 | Henry, Iowa, US | |
2022-02-17 | US | Puerto Rico | Vega Alta | 72143 | 5485 | 0 | 0 | 18.409346 | -66.33725 | 2022-02-18 04:21:04 | Vega Alta, Puerto Rico, US | |
2022-02-17 | US | Iowa | Henry | 19087 | 5485 | 65 | 0 | 40.98767962 | -91.54436349 | 2022-02-18 04:21:04 | Henry, Iowa, US | |
2022-02-16 | US | Mississippi | Chickasaw | 28017 | 5485 | 92 | 0 | 33.91983202 | -88.9481545 | 2022-02-17 04:20:56 | Chickasaw, Mississippi, US | |
2022-02-16 | US | Iowa | Henry | 19087 | 5485 | 65 | 0 | 40.98767962 | -91.54436349 | 2022-02-17 04:20:56 | Henry, Iowa, US | |
2022-02-04 | US | Arkansas | Arkansas | 5001 | 5485 | 69 | 0 | 34.29145151 | -91.37277296 | 2022-02-05 04:21:05 | Arkansas, Arkansas, US | |
2022-01-31 | US | Wisconsin | Vernon | 55123 | 5485 | 80 | 0 | 43.59422667 | -90.8324691 | 2022-02-01 04:21:11 | Vernon, Wisconsin, US | |
2022-01-12 | US | Texas | Willacy | 48489 | 5485 | 114 | 0 | 26.47411727 | -97.61535848 | 2022-01-13 08:00:09 | Willacy, Texas, US | |
2022-01-05 | US | Pennsylvania | Elk | 42047 | 5485 | 78 | 0 | 41.42822061 | -78.64524744 | 2022-01-06 04:22:09 | Elk, Pennsylvania, US | |
2021-12-07 | US | North Carolina | Person | 37145 | 5485 | 89 | 0 | 36.38989032 | -78.97217358 | 2021-12-08 04:22:46 | Person, North Carolina, US | |
2021-12-06 | US | Illinois | Morgan | 17137 | 5485 | 103 | 0 | 39.71654544 | -90.20255104 | 2021-12-07 04:22:34 | Morgan, Illinois, US | |
2021-12-01 | US | Georgia | Toombs | 13279 | 5485 | 175 | 0 | 32.12059861 | -82.32957247 | 2021-12-02 04:22:37 | Toombs, Georgia, US | |
2021-11-18 | US | Illinois | Fulton | 17057 | 5485 | 85 | 0 | 40.47289135 | -90.20862357 | 2021-11-19 04:21:40 | Fulton, Illinois, US | |
2021-11-08 | US | Tennessee | Macon | 47111 | 5485 | 93 | 0 | 36.53157855 | -86.00778595 | 2021-11-09 04:21:36 | Macon, Tennessee, US | |
2021-11-08 | US | South Carolina | Marion | 45067 | 5485 | 140 | 0 | 34.07859748 | -79.36400756 | 2021-11-09 04:21:36 | Marion, South Carolina, US | |
2021-11-08 | US | Kentucky | Harlan | 21095 | 5485 | 131 | 0 | 36.85699301 | -83.21899516 | 2021-11-09 04:21:36 | Harlan, Kentucky, US | |
2021-11-05 | US | Tennessee | Henry | 47079 | 5485 | 86 | 0 | 36.33160906 | -88.30121797 | 2021-11-06 04:21:51 | Henry, Tennessee, US | |
2021-11-02 | US | Tennessee | Claiborne | 47025 | 5485 | 110 | 0 | 36.48319149 | -83.65947309 | 2021-11-03 06:22:09 | Claiborne, Tennessee, US | |
2021-10-31 | US | Virginia | York | 51199 | 5485 | 76 | 0 | 37.24374789 | -76.54412815 | 2021-11-01 04:22:01 | York, Virginia, US | |
2021-10-30 | US | Virginia | York | 51199 | 5485 | 76 | 0 | 37.24374789 | -76.54412815 | 2021-10-31 04:22:08 | York, Virginia, US | |
2021-10-29 | US | Virginia | York | 51199 | 5485 | 76 | 0 | 37.24374789 | -76.54412815 | 2021-10-30 04:22:03 | York, Virginia, US | |
2021-10-08 | US | Ohio | Logan | 39091 | 5485 | 97 | 0 | 40.38996525 | -83.76784341 | 2021-10-09 04:21:34 | Logan, Ohio, US | |
2021-10-07 | US | Indiana | Whitley | 18183 | 5485 | 54 | 0 | 41.13863784 | -85.50791236 | 2021-10-08 04:21:25 | Whitley, Indiana, US | |
2021-09-30 | US | South Carolina | Williamsburg | 45089 | 5485 | 118 | 0 | 33.62190129 | -79.72767442 | 2021-10-01 04:21:35 | Williamsburg, South Carolina, US | |
2021-09-30 | US | Michigan | Hillsdale | 26059 | 5485 | 109 | 0 | 41.88753639 | -84.59312019 | 2021-10-01 04:21:35 | Hillsdale, Michigan, US | |
2021-09-29 | US | Tennessee | Henderson | 47077 | 5485 | 94 | 0 | 35.65581134 | -88.38600175 | 2021-09-30 04:21:20 | Henderson, Tennessee, US | |
2021-09-29 | US | Michigan | Hillsdale | 26059 | 5485 | 109 | 0 | 41.88753639 | -84.59312019 | 2021-09-30 04:21:20 | Hillsdale, Michigan, US | |
2021-09-21 | Japan | Aomori | 5485 | 33 | 0 | 40.781541 | 140.828896 | 2021-09-22 04:21:45 | Aomori, Japan | |||
2021-09-08 | US | Puerto Rico | Guaynabo | 72061 | 5485 | 0 | 0 | 18.345114000000002 | -66.11452299999999 | 2021-09-09 04:21:27 | Guaynabo, Puerto Rico, US | |
2021-09-01 | US | Illinois | Jefferson | 17081 | 5485 | 126 | 0 | 38.29980057 | -88.9240025 | 2021-09-02 04:21:15 | Jefferson, Illinois, US | |
2021-08-30 | US | Alabama | Russell | 1113 | 5485 | 51 | 0 | 32.28725256 | -85.18415324 | 2021-08-31 04:21:46 | Russell, Alabama, US | |
2021-08-19 | US | Texas | Medina | 48325 | 5485 | 118 | 0 | 29.355730100000002 | -99.11030298 | 2021-08-20 04:21:33 | Medina, Texas, US | |
2021-08-15 | US | Ohio | Seneca | 39147 | 5485 | 135 | 0 | 41.12351311 | -83.12783209 | 2021-08-16 04:21:31 | Seneca, Ohio, US | |
2021-08-12 | US | Ohio | Washington | 39167 | 5485 | 111 | 0 | 39.45690571 | -81.49121382 | 2021-08-13 04:21:24 | Washington, Ohio, US | |
2021-08-11 | US | Nevada | Elko | 32007 | 5485 | 64 | 0 | 41.14531606 | -115.3577619 | 2021-08-12 04:21:25 | Elko, Nevada, US | |
2021-08-10 | US | New York | Genesee | 36037 | 5485 | 124 | 0 | 43.0022601 | -78.19135193 | 2021-08-11 04:21:58 | Genesee, New York, US | |
2021-08-08 | US | Alaska | Kenai Peninsula | 2122 | 5485 | 23 | 0 | 60.24429722 | -151.53888840000005 | 2021-08-09 04:21:24 | Kenai Peninsula, Alaska, US | |
2021-08-07 | US | Alaska | Kenai Peninsula | 2122 | 5485 | 23 | 0 | 60.24429722 | -151.53888840000005 | 2021-08-08 04:21:33 | Kenai Peninsula, Alaska, US | |
2021-08-06 | US | Alaska | Kenai Peninsula | 2122 | 5485 | 23 | 0 | 60.24429722 | -151.53888840000005 | 2021-08-07 04:21:30 | Kenai Peninsula, Alaska, US | |
2021-08-05 | US | North Carolina | Carteret | 37031 | 5485 | 57 | 0 | 34.8932941 | -76.54120135 | 2021-08-06 04:21:18 | Carteret, North Carolina, US | |
2021-07-01 | US | Kentucky | Scott | 21209 | 5485 | 36 | 0 | 38.29622293 | -84.5816631 | 2021-07-02 04:21:47 | Scott, Kentucky, US | |
2021-06-19 | Japan | Shiga | 5485 | 88 | 5200 | 197 | 35.21582700000001 | 136.138064 | 2021-06-20 04:21:48 | Shiga, Japan | ||
2021-05-27 | US | Iowa | Cerro Gordo | 19033 | 5485 | 89 | 0 | 43.08177563 | -93.2612239 | 2021-05-28 04:20:36 | Cerro Gordo, Iowa, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;