daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
274 rows where confirmed = 5521 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-23 | US | Tennessee | Polk | 47139 | 5521 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-12-24 04:21:02 | Polk, Tennessee, US | |
2022-11-29 | US | Texas | Deaf Smith | 48117 | 5521 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-11-30 04:21:07 | Deaf Smith, Texas, US | |
2022-11-28 | US | Texas | Deaf Smith | 48117 | 5521 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-11-29 04:21:05 | Deaf Smith, Texas, US | |
2022-10-31 | US | Arkansas | Cross | 5037 | 5521 | 98 | 0 | 35.29631396 | -90.77185818 | 2022-11-01 04:22:36 | Cross, Arkansas, US | |
2022-10-30 | US | Wisconsin | Adams | 55001 | 5521 | 66 | 0 | 43.96974651 | -89.76782777 | 2022-10-31 04:21:36 | Adams, Wisconsin, US | |
2022-10-29 | US | Wisconsin | Adams | 55001 | 5521 | 66 | 0 | 43.96974651 | -89.76782777 | 2022-10-30 04:22:14 | Adams, Wisconsin, US | |
2022-10-28 | US | Wisconsin | Adams | 55001 | 5521 | 66 | 0 | 43.96974651 | -89.76782777 | 2022-10-29 04:21:13 | Adams, Wisconsin, US | |
2022-10-09 | US | Wisconsin | Sawyer | 55113 | 5521 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-10-10 04:22:32 | Sawyer, Wisconsin, US | |
2022-10-08 | US | Wisconsin | Sawyer | 55113 | 5521 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-10-09 04:21:16 | Sawyer, Wisconsin, US | |
2022-10-07 | US | Wisconsin | Sawyer | 55113 | 5521 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-10-08 04:22:56 | Sawyer, Wisconsin, US | |
2022-10-03 | US | Puerto Rico | Adjuntas | 72001 | 5521 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-04 04:22:55 | Adjuntas, Puerto Rico, US | |
2022-09-27 | US | Georgia | Lamar | 13171 | 5521 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-09-28 04:23:01 | Lamar, Georgia, US | |
2022-09-26 | US | Georgia | Lamar | 13171 | 5521 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-09-27 04:23:01 | Lamar, Georgia, US | |
2022-09-26 | US | Colorado | Elbert | 8039 | 5521 | 44 | 0 | 39.28656773 | -104.1358721 | 2022-09-27 04:23:01 | Elbert, Colorado, US | |
2022-09-25 | US | Georgia | Lamar | 13171 | 5521 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-09-26 04:20:52 | Lamar, Georgia, US | |
2022-09-24 | US | Georgia | Lamar | 13171 | 5521 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-09-25 04:23:31 | Lamar, Georgia, US | |
2022-09-23 | US | Georgia | Lamar | 13171 | 5521 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-09-24 04:21:40 | Lamar, Georgia, US | |
2022-09-22 | US | Georgia | Lamar | 13171 | 5521 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-09-23 04:23:13 | Lamar, Georgia, US | |
2022-09-21 | US | Georgia | Lamar | 13171 | 5521 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-09-22 04:22:56 | Lamar, Georgia, US | |
2022-09-07 | US | Ohio | Meigs | 39105 | 5521 | 94 | 0 | 39.09224872 | -82.0305041 | 2022-09-08 04:21:02 | Meigs, Ohio, US | |
2022-09-06 | US | Ohio | Meigs | 39105 | 5521 | 94 | 0 | 39.09224872 | -82.0305041 | 2022-09-07 04:20:59 | Meigs, Ohio, US | |
2022-09-05 | US | Ohio | Meigs | 39105 | 5521 | 94 | 0 | 39.09224872 | -82.0305041 | 2022-09-06 04:21:02 | Meigs, Ohio, US | |
2022-09-04 | US | Ohio | Meigs | 39105 | 5521 | 94 | 0 | 39.09224872 | -82.0305041 | 2022-09-05 04:21:01 | Meigs, Ohio, US | |
2022-09-03 | US | Ohio | Meigs | 39105 | 5521 | 94 | 0 | 39.09224872 | -82.0305041 | 2022-09-04 04:21:22 | Meigs, Ohio, US | |
2022-09-02 | US | Ohio | Meigs | 39105 | 5521 | 94 | 0 | 39.09224872 | -82.0305041 | 2022-09-03 04:21:04 | Meigs, Ohio, US | |
2022-09-01 | US | Tennessee | Humphreys | 47085 | 5521 | 79 | 0 | 36.03958805 | -87.77992872 | 2022-09-02 04:21:07 | Humphreys, Tennessee, US | |
2022-09-01 | US | Ohio | Meigs | 39105 | 5521 | 94 | 0 | 39.09224872 | -82.0305041 | 2022-09-02 04:21:07 | Meigs, Ohio, US | |
2022-08-30 | US | Georgia | Tattnall | 13267 | 5521 | 136 | 0 | 32.04785085 | -82.05539188 | 2022-08-31 04:20:57 | Tattnall, Georgia, US | |
2022-08-29 | US | Georgia | Tattnall | 13267 | 5521 | 136 | 0 | 32.04785085 | -82.05539188 | 2022-08-30 04:21:03 | Tattnall, Georgia, US | |
2022-08-28 | US | Georgia | Tattnall | 13267 | 5521 | 136 | 0 | 32.04785085 | -82.05539188 | 2022-08-29 04:21:06 | Tattnall, Georgia, US | |
2022-08-27 | US | Georgia | Tattnall | 13267 | 5521 | 136 | 0 | 32.04785085 | -82.05539188 | 2022-08-28 04:21:02 | Tattnall, Georgia, US | |
2022-08-26 | US | Georgia | Tattnall | 13267 | 5521 | 136 | 0 | 32.04785085 | -82.05539188 | 2022-08-27 04:20:57 | Tattnall, Georgia, US | |
2022-08-25 | US | Georgia | Tattnall | 13267 | 5521 | 136 | 0 | 32.04785085 | -82.05539188 | 2022-08-26 04:21:02 | Tattnall, Georgia, US | |
2022-08-24 | US | Georgia | Tattnall | 13267 | 5521 | 136 | 0 | 32.04785085 | -82.05539188 | 2022-08-25 04:21:13 | Tattnall, Georgia, US | |
2022-08-22 | US | Colorado | Teller | 8119 | 5521 | 59 | 0 | 38.88133511 | -105.1614893 | 2022-08-23 04:20:56 | Teller, Colorado, US | |
2022-08-21 | US | Texas | Burleson | 48051 | 5521 | 67 | 0 | 30.49273808 | -96.62158484 | 2022-08-22 04:20:38 | Burleson, Texas, US | |
2022-08-21 | US | Colorado | Teller | 8119 | 5521 | 59 | 0 | 38.88133511 | -105.1614893 | 2022-08-22 04:20:38 | Teller, Colorado, US | |
2022-08-20 | US | Texas | Burleson | 48051 | 5521 | 67 | 0 | 30.49273808 | -96.62158484 | 2022-08-21 04:20:44 | Burleson, Texas, US | |
2022-08-19 | US | Texas | Burleson | 48051 | 5521 | 67 | 0 | 30.49273808 | -96.62158484 | 2022-08-20 04:21:01 | Burleson, Texas, US | |
2022-08-15 | US | Illinois | Pike | 17149 | 5521 | 68 | 0 | 39.62265059 | -90.8877017 | 2022-08-16 04:20:58 | Pike, Illinois, US | |
2022-08-08 | US | Virginia | Radford | 51750 | 5521 | 54 | 0 | 37.12222899 | -80.5602732 | 2022-08-09 04:20:34 | Radford, Virginia, US | |
2022-07-24 | US | Maryland | Somerset | 24039 | 5521 | 76 | 0 | 38.1163542 | -75.75118623 | 2022-07-25 04:20:51 | Somerset, Maryland, US | |
2022-07-23 | US | Maryland | Somerset | 24039 | 5521 | 76 | 0 | 38.1163542 | -75.75118623 | 2022-07-24 04:20:47 | Somerset, Maryland, US | |
2022-07-22 | US | Maryland | Somerset | 24039 | 5521 | 76 | 0 | 38.1163542 | -75.75118623 | 2022-07-23 04:20:53 | Somerset, Maryland, US | |
2022-07-21 | US | Tennessee | Unicoi | 47171 | 5521 | 97 | 0 | 36.10890856 | -82.43709629 | 2022-07-22 04:21:15 | Unicoi, Tennessee, US | |
2022-06-22 | US | Wisconsin | Vilas | 55125 | 5521 | 90 | 0 | 46.05467334 | -89.51719204 | 2022-06-23 04:20:55 | Vilas, Wisconsin, US | |
2022-04-07 | US | Texas | San Jacinto | 48407 | 5521 | 100 | 0 | 30.57933681 | -95.16260304 | 2022-04-08 04:20:48 | San Jacinto, Texas, US | |
2022-04-07 | US | Texas | Lampasas | 48281 | 5521 | 90 | 0 | 31.19531316 | -98.24206613 | 2022-04-08 04:20:48 | Lampasas, Texas, US | |
2022-04-05 | Russia | Chukotka Autonomous Okrug | 5521 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-04-06 04:20:49 | Chukotka Autonomous Okrug, Russia | |||
2022-03-13 | US | Minnesota | Wabasha | 27157 | 5521 | 16 | 0 | 44.28424356 | -92.23121312 | 2022-03-14 04:20:46 | Wabasha, Minnesota, US | |
2022-03-12 | US | Minnesota | Wabasha | 27157 | 5521 | 16 | 0 | 44.28424356 | -92.23121312 | 2022-03-13 04:20:49 | Wabasha, Minnesota, US | |
2022-03-11 | US | Minnesota | Wabasha | 27157 | 5521 | 16 | 0 | 44.28424356 | -92.23121312 | 2022-03-12 04:20:50 | Wabasha, Minnesota, US | |
2022-03-10 | US | Maryland | Talbot | 24041 | 5521 | 85 | 0 | 38.76618159 | -76.10882561 | 2022-03-11 04:20:50 | Talbot, Maryland, US | |
2022-02-27 | US | Texas | Austin | 48015 | 5521 | 71 | 0 | 29.88548725 | -96.27736949 | 2022-02-28 04:21:05 | Austin, Texas, US | |
2022-02-22 | US | Mississippi | Chickasaw | 28017 | 5521 | 92 | 0 | 33.91983202 | -88.9481545 | 2022-02-23 04:21:09 | Chickasaw, Mississippi, US | |
2022-02-21 | US | Minnesota | Dodge | 27039 | 5521 | 20 | 0 | 44.02238415 | -92.86244324 | 2022-02-22 04:21:01 | Dodge, Minnesota, US | |
2022-02-20 | US | Minnesota | Dodge | 27039 | 5521 | 20 | 0 | 44.02238415 | -92.86244324 | 2022-02-21 04:21:05 | Dodge, Minnesota, US | |
2022-02-19 | US | Minnesota | Dodge | 27039 | 5521 | 20 | 0 | 44.02238415 | -92.86244324 | 2022-02-20 04:21:00 | Dodge, Minnesota, US | |
2022-02-18 | US | Minnesota | Dodge | 27039 | 5521 | 20 | 0 | 44.02238415 | -92.86244324 | 2022-02-19 04:21:11 | Dodge, Minnesota, US | |
2022-01-17 | US | Ohio | Hocking | 39073 | 5521 | 111 | 0 | 39.49537927 | -82.47991446 | 2022-01-18 04:21:04 | Hocking, Ohio, US | |
2022-01-17 | US | New Mexico | Unassigned | 90035 | 5521 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-01-18 04:21:04 | Unassigned, New Mexico, US | |
2022-01-16 | US | New Mexico | Unassigned | 90035 | 5521 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-01-17 04:21:08 | Unassigned, New Mexico, US | |
2022-01-15 | US | New Mexico | Unassigned | 90035 | 5521 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-01-16 04:21:12 | Unassigned, New Mexico, US | |
2022-01-14 | US | New Mexico | Unassigned | 90035 | 5521 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-01-15 04:21:07 | Unassigned, New Mexico, US | |
2021-12-27 | US | Texas | Cooke | 48097 | 5521 | 107 | 0 | 33.63979567 | -97.21240912 | 2021-12-28 04:21:47 | Cooke, Texas, US | |
2021-11-28 | US | Illinois | Monroe | 17133 | 5521 | 105 | 0 | 38.27594376 | -90.17761038 | 2021-11-29 04:22:30 | Monroe, Illinois, US | |
2021-11-27 | US | Illinois | Monroe | 17133 | 5521 | 105 | 0 | 38.27594376 | -90.17761038 | 2021-11-28 04:22:43 | Monroe, Illinois, US | |
2021-11-26 | US | Illinois | Monroe | 17133 | 5521 | 105 | 0 | 38.27594376 | -90.17761038 | 2021-11-27 04:22:45 | Monroe, Illinois, US | |
2021-11-25 | US | Illinois | Monroe | 17133 | 5521 | 105 | 0 | 38.27594376 | -90.17761038 | 2021-11-26 04:22:33 | Monroe, Illinois, US | |
2021-11-24 | US | Illinois | Monroe | 17133 | 5521 | 105 | 0 | 38.27594376 | -90.17761038 | 2021-11-25 04:22:33 | Monroe, Illinois, US | |
2021-11-23 | US | South Carolina | Marion | 45067 | 5521 | 142 | 0 | 34.07859748 | -79.36400756 | 2021-11-24 04:22:14 | Marion, South Carolina, US | |
2021-11-19 | US | Missouri | Pulaski | 29169 | 5521 | 82 | 0 | 37.82462075 | -92.20783203 | 2021-11-20 04:22:17 | Pulaski, Missouri, US | |
2021-10-26 | US | California | Amador | 6005 | 5521 | 64 | 0 | 38.44583082 | -120.65696000000001 | 2021-10-27 04:22:32 | Amador, California, US | |
2021-10-26 | San Marino | 5521 | 92 | 0 | 43.9424 | 12.4578 | 2021-10-27 04:22:32 | San Marino | ||||
2021-10-23 | US | Tennessee | Hardin | 47071 | 5521 | 81 | 0 | 35.19732531 | -88.18593755 | 2021-10-24 04:21:22 | Hardin, Tennessee, US | |
2021-10-17 | US | Kansas | Cowley | 20035 | 5521 | 124 | 0 | 37.23781842 | -96.83776647 | 2021-10-18 04:21:10 | Cowley, Kansas, US | |
2021-10-16 | US | Kansas | Cowley | 20035 | 5521 | 124 | 0 | 37.23781842 | -96.83776647 | 2021-10-17 04:21:29 | Cowley, Kansas, US | |
2021-10-15 | US | Kansas | Cowley | 20035 | 5521 | 124 | 0 | 37.23781842 | -96.83776647 | 2021-10-16 04:21:15 | Cowley, Kansas, US | |
2021-10-08 | US | Colorado | La Plata | 8067 | 5521 | 54 | 0 | 37.28632032 | -107.8429014 | 2021-10-09 04:21:34 | La Plata, Colorado, US | |
2021-09-26 | US | Ohio | Madison | 39097 | 5521 | 74 | 0 | 39.89381073 | -83.40178317 | 2021-09-27 04:21:16 | Madison, Ohio, US | |
2021-09-24 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-25 04:21:31 | Buffalo, Nebraska, US | |
2021-09-23 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-24 04:21:44 | Buffalo, Nebraska, US | |
2021-09-23 | US | Michigan | Newaygo | 26123 | 5521 | 71 | 0 | 43.554373999999996 | -85.80070107 | 2021-09-24 04:21:44 | Newaygo, Michigan, US | |
2021-09-22 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-23 04:21:43 | Buffalo, Nebraska, US | |
2021-09-22 | US | Michigan | Newaygo | 26123 | 5521 | 71 | 0 | 43.554373999999996 | -85.80070107 | 2021-09-23 04:21:43 | Newaygo, Michigan, US | |
2021-09-21 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-22 04:21:45 | Buffalo, Nebraska, US | |
2021-09-20 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-21 04:21:26 | Buffalo, Nebraska, US | |
2021-09-19 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-20 04:21:22 | Buffalo, Nebraska, US | |
2021-09-18 | US | Ohio | Mercer | 39107 | 5521 | 91 | 0 | 40.54043046 | -84.62912742 | 2021-09-19 04:21:34 | Mercer, Ohio, US | |
2021-09-18 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-19 04:21:34 | Buffalo, Nebraska, US | |
2021-09-17 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-18 04:21:24 | Buffalo, Nebraska, US | |
2021-09-16 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-17 04:21:46 | Buffalo, Nebraska, US | |
2021-09-15 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-16 04:22:19 | Buffalo, Nebraska, US | |
2021-09-14 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-15 03:22:37 | Buffalo, Nebraska, US | |
2021-09-13 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-14 04:21:41 | Buffalo, Nebraska, US | |
2021-09-12 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-13 04:21:15 | Buffalo, Nebraska, US | |
2021-09-11 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-12 04:21:13 | Buffalo, Nebraska, US | |
2021-09-10 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-11 04:21:30 | Buffalo, Nebraska, US | |
2021-09-09 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-10 04:21:20 | Buffalo, Nebraska, US | |
2021-09-08 | US | Nebraska | Buffalo | 31019 | 5521 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-09-09 04:21:27 | Buffalo, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;