daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
43 rows where confirmed = 12539 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-21 | US | Oklahoma | Sequoyah | 40135 | 12539 | 114 | 0 | 35.49447108 | -94.75463785 | 2022-12-22 04:20:56 | Sequoyah, Oklahoma, US | |
2022-12-20 | US | Oklahoma | Sequoyah | 40135 | 12539 | 114 | 0 | 35.49447108 | -94.75463785 | 2022-12-21 04:21:03 | Sequoyah, Oklahoma, US | |
2022-12-19 | US | Oklahoma | Sequoyah | 40135 | 12539 | 114 | 0 | 35.49447108 | -94.75463785 | 2022-12-20 04:21:04 | Sequoyah, Oklahoma, US | |
2022-12-18 | US | Oklahoma | Sequoyah | 40135 | 12539 | 114 | 0 | 35.49447108 | -94.75463785 | 2022-12-19 04:21:03 | Sequoyah, Oklahoma, US | |
2022-12-17 | US | Oklahoma | Sequoyah | 40135 | 12539 | 114 | 0 | 35.49447108 | -94.75463785 | 2022-12-18 04:21:03 | Sequoyah, Oklahoma, US | |
2022-12-16 | US | Oklahoma | Sequoyah | 40135 | 12539 | 114 | 0 | 35.49447108 | -94.75463785 | 2022-12-17 04:21:04 | Sequoyah, Oklahoma, US | |
2022-12-15 | US | Oklahoma | Sequoyah | 40135 | 12539 | 114 | 0 | 35.49447108 | -94.75463785 | 2022-12-16 04:21:01 | Sequoyah, Oklahoma, US | |
2022-08-30 | US | Puerto Rico | Gurabo | 72063 | 12539 | 0 | 0 | 18.266461 | -65.979705 | 2022-08-31 04:20:57 | Gurabo, Puerto Rico, US | |
2022-08-04 | US | Virginia | Danville | 51590 | 12539 | 285 | 0 | 36.58022376 | -79.40395668 | 2022-08-05 04:20:52 | Danville, Virginia, US | |
2022-08-02 | US | Virginia | Culpeper | 51047 | 12539 | 156 | 0 | 38.48199985 | -77.9563087 | 2022-08-03 04:20:59 | Culpeper, Virginia, US | |
2022-08-01 | US | Tennessee | Fayette | 47047 | 12539 | 191 | 0 | 35.19615831 | -89.41399032 | 2022-08-02 04:20:53 | Fayette, Tennessee, US | |
2022-07-28 | Tonga | 12539 | 12 | 0 | -21.179 | -175.1982 | 2022-07-29 04:20:45 | Tonga | ||||
2022-07-27 | Tonga | 12539 | 12 | 0 | -21.179 | -175.1982 | 2022-07-28 04:20:56 | Tonga | ||||
2022-07-26 | Tonga | 12539 | 12 | 0 | -21.179 | -175.1982 | 2022-07-27 04:21:04 | Tonga | ||||
2022-07-16 | US | Texas | Brown | 48049 | 12539 | 229 | 0 | 31.77430356 | -98.99907113 | 2022-07-17 04:21:15 | Brown, Texas, US | |
2022-07-07 | US | Maine | Oxford | 23017 | 12539 | 153 | 0 | 44.49952995 | -70.75682123 | 2022-07-08 04:20:56 | Oxford, Maine, US | |
2022-01-25 | US | Texas | Caldwell | 48055 | 12539 | 164 | 0 | 29.83668859 | -97.61814775 | 2022-01-26 04:21:07 | Caldwell, Texas, US | |
2022-01-02 | US | Minnesota | Rice | 27131 | 12539 | 148 | 0 | 44.3543376 | -93.29658715 | 2022-01-03 02:22:25 | Rice, Minnesota, US | |
2022-01-01 | US | Minnesota | Rice | 27131 | 12539 | 148 | 0 | 44.3543376 | -93.29658715 | 2022-01-02 04:20:52 | Rice, Minnesota, US | |
2021-12-31 | US | Minnesota | Rice | 27131 | 12539 | 148 | 0 | 44.3543376 | -93.29658715 | 2022-01-01 04:22:14 | Rice, Minnesota, US | |
2021-12-30 | US | Minnesota | Rice | 27131 | 12539 | 148 | 0 | 44.3543376 | -93.29658715 | 2021-12-31 04:21:50 | Rice, Minnesota, US | |
2021-12-26 | US | Texas | Coryell | 48099 | 12539 | 169 | 0 | 31.39078397 | -97.79936155 | 2021-12-27 04:21:58 | Coryell, Texas, US | |
2021-12-15 | China | Unknown | 12539 | 0 | 0 | 2021-12-16 04:22:11 | Unknown, China | |||||
2021-11-23 | US | Oklahoma | Pottawatomie | 40125 | 12539 | 195 | 0 | 35.20614018 | -96.94923008 | 2021-11-24 04:22:14 | Pottawatomie, Oklahoma, US | |
2021-11-22 | US | Oklahoma | Pottawatomie | 40125 | 12539 | 195 | 0 | 35.20614018 | -96.94923008 | 2021-11-23 04:22:39 | Pottawatomie, Oklahoma, US | |
2021-11-21 | US | Oklahoma | Pottawatomie | 40125 | 12539 | 195 | 0 | 35.20614018 | -96.94923008 | 2021-11-22 04:22:20 | Pottawatomie, Oklahoma, US | |
2021-11-20 | US | Oklahoma | Pottawatomie | 40125 | 12539 | 195 | 0 | 35.20614018 | -96.94923008 | 2021-11-21 04:22:13 | Pottawatomie, Oklahoma, US | |
2021-11-19 | US | Oklahoma | Pottawatomie | 40125 | 12539 | 195 | 0 | 35.20614018 | -96.94923008 | 2021-11-20 04:22:17 | Pottawatomie, Oklahoma, US | |
2021-11-18 | US | Oklahoma | Pottawatomie | 40125 | 12539 | 195 | 0 | 35.20614018 | -96.94923008 | 2021-11-19 04:21:40 | Pottawatomie, Oklahoma, US | |
2021-11-17 | US | Oklahoma | Pottawatomie | 40125 | 12539 | 195 | 0 | 35.20614018 | -96.94923008 | 2021-11-18 04:21:33 | Pottawatomie, Oklahoma, US | |
2021-06-02 | Malaysia | Melaka | 12539 | 78 | 9141 | 3320 | 2.1896 | 102.2501 | 2021-06-03 04:23:32 | Melaka, Malaysia | ||
2021-06-02 | US | Texas | Grayson | 48181 | 12539 | 342 | 0 | 33.62744998 | -96.67753461 | 2021-06-03 04:23:32 | Grayson, Texas, US | |
2021-04-05 | US | Massachusetts | Barnstable | 25001 | 12539 | 357 | 0 | 41.72980578 | -70.28854339 | 2021-04-06 04:20:32 | Barnstable, Massachusetts, US | |
2021-03-09 | Colombia | Casanare | 12539 | 281 | 11950 | 308 | 5.7589 | -71.5724 | 2021-03-10 05:24:35 | Casanare, Colombia | ||
2021-03-08 | Chile | Atacama | 12539 | 156 | 11884 | 499 | -27.5661 | -70.0503 | 2021-03-09 05:28:19 | Atacama, Chile | ||
2021-02-11 | US | Alabama | Calhoun | 1015 | 12539 | 257 | 0 | 12282 | 33.77483727 | -85.82630386 | 2021-02-12 05:23:29 | Calhoun, Alabama, US |
2021-02-02 | US | Iowa | Johnson | 19103 | 12539 | 62 | 0 | 12477 | 41.67169354 | -91.58754744 | 2021-02-03 05:22:52 | Johnson, Iowa, US |
2021-01-07 | US | Indiana | Hendricks | 18063 | 12539 | 240 | 0 | 12299 | 39.76719009 | -86.51037283 | 2021-01-08 05:22:42 | Hendricks, Indiana, US |
2021-01-03 | US | Indiana | Johnson | 18081 | 12539 | 267 | 0 | 12272 | 39.48994426 | -86.10149107 | 2021-01-04 05:22:02 | Johnson, Indiana, US |
2020-10-30 | Mexico | Baja California Sur | 12539 | 605 | 11094 | 840 | 26.0444 | -111.6661 | 2020-10-31 04:24:44 | Baja California Sur, Mexico | ||
2020-09-27 | Russia | Orenburg Oblast | 12539 | 85 | 11303 | 1151 | 52.0269262 | 54.7276647 | 2020-09-28 04:23:00 | Orenburg Oblast, Russia | ||
2020-07-07 | US | Wisconsin | Milwaukee | 55079 | 12539 | 398 | 0 | 12141 | 43.00486062 | -87.96733172 | 2020-07-08 05:33:48 | Milwaukee, Wisconsin, US |
2020-04-29 | US | Massachusetts | Suffolk | 25025 | 12539 | 504 | 0 | 12035 | 42.327951399999996 | -71.07850442 | 2020-04-30 02:32:27 | Suffolk, Massachusetts, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;