daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
52 rows where confirmed = 12462 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-13 | US | Louisiana | Natchitoches | 22069 | 12462 | 184 | 0 | 31.72321584 | -93.09816516 | 2022-12-14 04:21:04 | Natchitoches, Louisiana, US | |
2022-12-12 | US | Louisiana | Natchitoches | 22069 | 12462 | 184 | 0 | 31.72321584 | -93.09816516 | 2022-12-13 04:21:01 | Natchitoches, Louisiana, US | |
2022-12-11 | US | Louisiana | Natchitoches | 22069 | 12462 | 184 | 0 | 31.72321584 | -93.09816516 | 2022-12-12 04:21:01 | Natchitoches, Louisiana, US | |
2022-12-10 | US | Louisiana | Natchitoches | 22069 | 12462 | 184 | 0 | 31.72321584 | -93.09816516 | 2022-12-11 04:20:50 | Natchitoches, Louisiana, US | |
2022-12-09 | US | Louisiana | Natchitoches | 22069 | 12462 | 184 | 0 | 31.72321584 | -93.09816516 | 2022-12-10 04:21:02 | Natchitoches, Louisiana, US | |
2022-12-08 | US | Louisiana | Natchitoches | 22069 | 12462 | 184 | 0 | 31.72321584 | -93.09816516 | 2022-12-09 04:21:05 | Natchitoches, Louisiana, US | |
2022-12-07 | US | Louisiana | Natchitoches | 22069 | 12462 | 184 | 0 | 31.72321584 | -93.09816516 | 2022-12-08 04:21:07 | Natchitoches, Louisiana, US | |
2022-11-13 | US | Puerto Rico | Cabo Rojo | 72023 | 12462 | 0 | 0 | 18.040993 | -67.154391 | 2022-11-14 04:21:09 | Cabo Rojo, Puerto Rico, US | |
2022-11-12 | US | Puerto Rico | Cabo Rojo | 72023 | 12462 | 0 | 0 | 18.040993 | -67.154391 | 2022-11-13 04:21:14 | Cabo Rojo, Puerto Rico, US | |
2022-11-06 | US | Tennessee | Obion | 47131 | 12462 | 207 | 0 | 36.35732446 | -89.14921589 | 2022-11-07 04:21:26 | Obion, Tennessee, US | |
2022-08-24 | US | Texas | Burnet | 48053 | 12462 | 173 | 0 | 30.78801353 | -98.181887 | 2022-08-25 04:21:13 | Burnet, Texas, US | |
2022-08-10 | US | New York | Tioga | 36107 | 12462 | 88 | 0 | 42.16852837 | -76.30835812 | 2022-08-11 04:20:49 | Tioga, New York, US | |
2022-07-23 | US | Tennessee | Fayette | 47047 | 12462 | 191 | 0 | 35.19615831 | -89.41399032 | 2022-07-24 04:20:47 | Fayette, Tennessee, US | |
2022-07-05 | US | Illinois | Stephenson | 17177 | 12462 | 167 | 0 | 42.35129217 | -89.662598 | 2022-07-06 04:20:58 | Stephenson, Illinois, US | |
2022-06-20 | US | Louisiana | Lincoln | 22061 | 12462 | 144 | 0 | 32.6003154 | -92.6659741 | 2022-06-21 04:20:56 | Lincoln, Louisiana, US | |
2022-06-02 | US | Tennessee | Campbell | 47013 | 12462 | 169 | 0 | 36.40355516 | -84.1510856 | 2022-06-03 04:20:58 | Campbell, Tennessee, US | |
2022-05-21 | US | Indiana | Marshall | 18099 | 12462 | 197 | 0 | 41.32467367 | -86.26185087 | 2022-05-22 04:20:52 | Marshall, Indiana, US | |
2022-05-20 | US | Indiana | Marshall | 18099 | 12462 | 197 | 0 | 41.32467367 | -86.26185087 | 2022-05-21 04:20:58 | Marshall, Indiana, US | |
2022-03-29 | US | Louisiana | St. Mary | 22101 | 12462 | 260 | 0 | 29.69262097 | -91.44702164 | 2022-03-30 04:20:45 | St. Mary, Louisiana, US | |
2022-02-28 | US | New Mexico | Curry | 35009 | 12462 | 175 | 0 | 34.57421077 | -103.34688759999999 | 2022-03-01 04:21:09 | Curry, New Mexico, US | |
2022-01-30 | San Marino | 12462 | 109 | 0 | 43.9424 | 12.4578 | 2022-01-31 04:21:09 | San Marino | ||||
2022-01-29 | San Marino | 12462 | 109 | 0 | 43.9424 | 12.4578 | 2022-01-30 04:21:26 | San Marino | ||||
2022-01-28 | San Marino | 12462 | 109 | 0 | 43.9424 | 12.4578 | 2022-01-29 04:21:10 | San Marino | ||||
2022-01-20 | US | Virginia | James City | 51095 | 12462 | 100 | 0 | 37.31156958 | -76.76950618 | 2022-01-21 04:21:09 | James City, Virginia, US | |
2022-01-16 | US | West Virginia | Mercer | 54055 | 12462 | 213 | 0 | 37.40481169 | -81.11023142 | 2022-01-17 04:21:08 | Mercer, West Virginia, US | |
2021-12-29 | US | Texas | Maverick | 48323 | 12462 | 415 | 0 | 28.7429195 | -100.3157686 | 2021-12-30 04:21:25 | Maverick, Texas, US | |
2021-12-21 | US | Mississippi | Lauderdale | 28075 | 12462 | 323 | 0 | 32.40419769 | -88.66229662 | 2021-12-22 04:21:54 | Lauderdale, Mississippi, US | |
2021-11-01 | US | North Carolina | Surry | 37171 | 12462 | 229 | 0 | 36.41689489 | -80.69102283 | 2021-11-02 04:22:03 | Surry, North Carolina, US | |
2021-09-27 | US | Kentucky | Laurel | 21125 | 12462 | 104 | 0 | 37.10975748 | -84.11321779 | 2021-09-28 04:21:28 | Laurel, Kentucky, US | |
2021-09-22 | US | Texas | Bowie | 48037 | 12462 | 272 | 0 | 33.44626922 | -94.41834132 | 2021-09-23 04:21:43 | Bowie, Texas, US | |
2021-09-14 | US | Michigan | Allegan | 26005 | 12462 | 169 | 0 | 42.59147037 | -85.89102866 | 2021-09-15 03:22:37 | Allegan, Michigan, US | |
2021-09-13 | US | Michigan | Allegan | 26005 | 12462 | 169 | 0 | 42.59147037 | -85.89102866 | 2021-09-14 04:21:41 | Allegan, Michigan, US | |
2021-08-08 | US | North Carolina | Cleveland | 37045 | 12462 | 231 | 0 | 35.33553364 | -81.55204486 | 2021-08-09 04:21:24 | Cleveland, North Carolina, US | |
2021-08-07 | US | North Carolina | Cleveland | 37045 | 12462 | 231 | 0 | 35.33553364 | -81.55204486 | 2021-08-08 04:21:33 | Cleveland, North Carolina, US | |
2021-08-06 | US | North Carolina | Cleveland | 37045 | 12462 | 231 | 0 | 35.33553364 | -81.55204486 | 2021-08-07 04:21:30 | Cleveland, North Carolina, US | |
2021-07-25 | US | New Mexico | Sandoval | 35043 | 12462 | 243 | 0 | 35.68862401 | -106.8687803 | 2021-07-26 04:21:28 | Sandoval, New Mexico, US | |
2021-07-24 | US | New Mexico | Sandoval | 35043 | 12462 | 243 | 0 | 35.68862401 | -106.8687803 | 2021-07-25 04:22:12 | Sandoval, New Mexico, US | |
2021-07-23 | US | New Mexico | Sandoval | 35043 | 12462 | 243 | 0 | 35.68862401 | -106.8687803 | 2021-07-24 00:21:36 | Sandoval, New Mexico, US | |
2021-05-02 | US | Oregon | Lane | 41039 | 12462 | 144 | 0 | 43.93727035 | -122.847753 | 2021-05-03 04:20:39 | Lane, Oregon, US | |
2021-04-07 | US | Wisconsin | Dodge | 55027 | 12462 | 182 | 0 | 43.41576662 | -88.70928178 | 2021-04-08 04:21:13 | Dodge, Wisconsin, US | |
2021-04-01 | US | Pennsylvania | Cambria | 42021 | 12462 | 406 | 0 | 40.49527404 | -78.71377428 | 2021-04-02 04:20:36 | Cambria, Pennsylvania, US | |
2021-01-11 | Syria | 12462 | 781 | 6098 | 5583 | 34.802075 | 38.99681500000001 | 2021-01-12 05:22:15 | Syria | |||
2020-11-23 | Russia | Karelia Republic | 12462 | 87 | 6685 | 5690 | 62.61940309999999 | 33.4920267 | 2020-11-24 05:27:31 | Karelia Republic, Russia | ||
2020-11-13 | US | Massachusetts | Hampden | 25013 | 12462 | 722 | 0 | 11617 | 42.13440424 | -72.63235561 | 2020-11-14 05:25:37 | Hampden, Massachusetts, US |
2020-11-07 | Russia | Belgorod Oblast | 12462 | 61 | 10930 | 1471 | 50.7080119 | 37.5837615 | 2020-11-08 05:24:56 | Belgorod Oblast, Russia | ||
2020-10-31 | US | Tennessee | Rutherford | 47149 | 12462 | 116 | 0 | 12412 | 35.84591405 | -86.4107263 | 2020-11-01 04:36:19 | Rutherford, Tennessee, US |
2020-10-18 | US | Pennsylvania | Delaware | 42045 | 12462 | 765 | 0 | 11697 | 39.91680171 | -75.40243663 | 2020-10-19 04:24:16 | Delaware, Pennsylvania, US |
2020-08-03 | Bosnia and Herzegovina | 12462 | 362 | 6359 | 5741 | 43.9159 | 17.6791 | 2020-08-04 04:41:59 | Bosnia and Herzegovina | |||
2020-07-06 | US | Connecticut | New Haven | 9009 | 12462 | 1078 | 0 | 11384 | 41.4080325 | -72.93620426 | 2020-07-07 04:34:00 | New Haven, Connecticut, US |
2020-05-17 | US | Massachusetts | Essex | 25009 | 12462 | 776 | 0 | 11686 | 42.6687626 | -70.94687179 | 2020-05-18 02:32:21 | Essex, Massachusetts, US |
2020-03-12 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 | |||||
2020-03-11 | Italy | 12462 | 827 | 1045 | 43.0 | 12.0 | 2020-03-11T21:33:02 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;