johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where confirmed = 11958 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218642 | 218642 | 2022-12-26 | US | Colorado | Summit | 8117 | 11958 | 15 | 0 | 39.63803232 | -106.1150762 | 2022-12-27 04:21:07 | Summit, Colorado, US | |
1629324 | 1629324 | 2022-12-18 | US | Illinois | Logan | 17107 | 11958 | 96 | 0 | 40.12581572 | -89.36638784 | 2022-12-19 04:21:03 | Logan, Illinois, US | |
504703 | 504703 | 2022-12-17 | US | Illinois | Logan | 17107 | 11958 | 96 | 0 | 40.12581572 | -89.36638784 | 2022-12-18 04:21:03 | Logan, Illinois, US | |
3325275 | 3325275 | 2022-12-16 | US | Illinois | Logan | 17107 | 11958 | 96 | 0 | 40.12581572 | -89.36638784 | 2022-12-17 04:21:04 | Logan, Illinois, US | |
1833477 | 1833477 | 2022-10-25 | US | Virginia | Charlottesville | 51540 | 11958 | 84 | 0 | 38.03527919 | -78.48569588 | 2022-10-26 04:22:19 | Charlottesville, Virginia, US | |
131725 | 131725 | 2022-10-04 | US | Illinois | Christian | 17021 | 11958 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-10-05 04:23:06 | Christian, Illinois, US | |
115738 | 115738 | 2022-09-06 | US | Illinois | Effingham | 17049 | 11958 | 142 | 0 | 39.05935711 | -88.58969584 | 2022-09-07 04:20:59 | Effingham, Illinois, US | |
1867529 | 1867529 | 2022-03-10 | US | Nebraska | Buffalo | 31019 | 11958 | 57 | 0 | 40.85486962 | -99.07500296 | 2022-03-11 04:20:50 | Buffalo, Nebraska, US | |
3720565 | 3720565 | 2022-02-21 | US | North Carolina | Watauga | 37189 | 11958 | 53 | 0 | 36.23103603 | -81.70033724 | 2022-02-22 04:21:01 | Watauga, North Carolina, US | |
3674221 | 3674221 | 2022-02-15 | US | Oklahoma | Le Flore | 40079 | 11958 | 98 | 0 | 34.89851864 | -94.70392124 | 2022-02-16 04:21:10 | Le Flore, Oklahoma, US | |
2644322 | 2644322 | 2022-02-14 | US | Oklahoma | Le Flore | 40079 | 11958 | 98 | 0 | 34.89851864 | -94.70392124 | 2022-02-15 04:21:09 | Le Flore, Oklahoma, US | |
188639 | 188639 | 2022-02-13 | US | Oklahoma | Le Flore | 40079 | 11958 | 98 | 0 | 34.89851864 | -94.70392124 | 2022-02-14 04:20:51 | Le Flore, Oklahoma, US | |
318485 | 318485 | 2022-02-12 | US | Oklahoma | Le Flore | 40079 | 11958 | 98 | 0 | 34.89851864 | -94.70392124 | 2022-02-13 04:21:00 | Le Flore, Oklahoma, US | |
235811 | 235811 | 2022-02-11 | US | Oklahoma | Le Flore | 40079 | 11958 | 98 | 0 | 34.89851864 | -94.70392124 | 2022-02-12 04:21:06 | Le Flore, Oklahoma, US | |
1466653 | 1466653 | 2022-02-10 | US | Oklahoma | Le Flore | 40079 | 11958 | 98 | 0 | 34.89851864 | -94.70392124 | 2022-02-11 04:21:09 | Le Flore, Oklahoma, US | |
3076614 | 3076614 | 2022-02-09 | US | Oklahoma | Le Flore | 40079 | 11958 | 98 | 0 | 34.89851864 | -94.70392124 | 2022-02-10 04:21:14 | Le Flore, Oklahoma, US | |
3229427 | 3229427 | 2022-01-19 | US | Tennessee | Monroe | 47123 | 11958 | 201 | 0 | 35.44550387 | -84.24902965 | 2022-01-20 04:21:07 | Monroe, Tennessee, US | |
732893 | 732893 | 2021-12-27 | US | North Carolina | Sampson | 37163 | 11958 | 143 | 0 | 34.98820368 | -78.36914061 | 2021-12-28 04:21:47 | Sampson, North Carolina, US | |
2114065 | 2114065 | 2021-12-26 | US | North Carolina | Sampson | 37163 | 11958 | 143 | 0 | 34.98820368 | -78.36914061 | 2021-12-27 04:21:58 | Sampson, North Carolina, US | |
3607437 | 3607437 | 2021-12-25 | US | North Carolina | Sampson | 37163 | 11958 | 143 | 0 | 34.98820368 | -78.36914061 | 2021-12-26 04:21:50 | Sampson, North Carolina, US | |
2965755 | 2965755 | 2021-12-24 | US | North Carolina | Sampson | 37163 | 11958 | 143 | 0 | 34.98820368 | -78.36914061 | 2021-12-25 04:21:37 | Sampson, North Carolina, US | |
3818787 | 3818787 | 2021-12-23 | US | North Carolina | Sampson | 37163 | 11958 | 143 | 0 | 34.98820368 | -78.36914061 | 2021-12-24 04:21:34 | Sampson, North Carolina, US | |
800795 | 800795 | 2021-12-22 | US | North Carolina | Sampson | 37163 | 11958 | 143 | 0 | 34.98820368 | -78.36914061 | 2021-12-23 04:21:21 | Sampson, North Carolina, US | |
2000885 | 2000885 | 2021-11-07 | Russia | Magadan Oblast | 11958 | 288 | 0 | 62.48858785 | 153.9903764 | 2021-11-08 04:21:43 | Magadan Oblast, Russia | |||
986898 | 986898 | 2021-10-04 | Iceland | 11958 | 33 | 0 | 64.9631 | -19.0208 | 2021-10-05 04:21:27 | Iceland | ||||
1277811 | 1277811 | 2021-10-03 | US | West Virginia | Wood | 54107 | 11958 | 209 | 0 | 39.20967886 | -81.5162836 | 2021-10-04 04:21:31 | Wood, West Virginia, US | |
1958870 | 1958870 | 2021-08-05 | US | North Carolina | Nash | 37127 | 11958 | 202 | 0 | 35.96575634 | -77.98422508 | 2021-08-06 04:21:18 | Nash, North Carolina, US | |
483400 | 483400 | 2021-07-19 | China | Hong Kong | 11958 | 212 | 11686 | 60 | 22.3 | 114.2 | 2021-07-20 04:21:48 | Hong Kong, China | ||
2673623 | 2673623 | 2021-07-18 | China | Hong Kong | 11958 | 212 | 11682 | 64 | 22.3 | 114.2 | 2021-07-19 04:21:24 | Hong Kong, China | ||
2502468 | 2502468 | 2021-05-07 | US | Arizona | Cochise | 4003 | 11958 | 284 | 0 | 31.87934684 | -109.7516088 | 2021-05-08 04:21:04 | Cochise, Arizona, US | |
3423436 | 3423436 | 2021-03-19 | US | Ohio | Wood | 39173 | 11958 | 186 | 0 | 41.36224827 | -83.62285108 | 2021-03-20 05:25:46 | Wood, Ohio, US | |
976096 | 976096 | 2021-02-06 | US | Iowa | Dubuque | 19061 | 11958 | 185 | 0 | 11773 | 42.46815349 | -90.88181925 | 2021-02-07 05:23:00 | Dubuque, Iowa, US |
190048 | 190048 | 2021-01-11 | Italy | Basilicata | 11958 | 278 | 5033 | 6647 | 40.63947052 | 15.80514834 | 2021-01-12 05:22:15 | Basilicata, Italy | ||
1587424 | 1587424 | 2020-11-30 | US | Utah | Southwest Utah | 11958 | 91 | 0 | 11867 | 37.85447192 | -111.4418764 | 2020-12-01 05:26:18 | Southwest Utah, Utah, US | |
2701891 | 2701891 | 2020-11-20 | US | Alabama | Madison | 1089 | 11958 | 146 | 0 | 11812 | 34.76327133 | -86.55069633 | 2020-11-21 05:25:51 | Madison, Alabama, US |
2243830 | 2243830 | 2020-10-30 | US | Arizona | Pinal | 4021 | 11958 | 226 | 0 | 11732 | 32.90525627 | -111.3449483 | 2020-10-31 04:24:44 | Pinal, Arizona, US |
3652269 | 3652269 | 2020-10-24 | US | Florida | Leon | 12073 | 11958 | 112 | 0 | 11846 | 30.45955727 | -84.27491114 | 2020-10-25 04:24:36 | Leon, Florida, US |
2857506 | 2857506 | 2020-10-16 | US | Delaware | New Castle | 10003 | 11958 | 347 | 0 | 11611 | 39.57992638 | -75.64054974 | 2020-10-17 04:24:12 | New Castle, Delaware, US |
82540 | 82540 | 2020-10-14 | US | Washington | Yakima | 53077 | 11958 | 263 | 0 | 11695 | 46.45738486 | -120.7380126 | 2020-10-15 04:24:28 | Yakima, Washington, US |
2656441 | 2656441 | 2020-09-23 | US | Pennsylvania | Montgomery | 42091 | 11958 | 878 | 0 | 11080 | 40.21053671 | -75.36652296 | 2020-09-24 04:23:00 | Montgomery, Pennsylvania, US |
3638879 | 3638879 | 2020-05-30 | Germany | Niedersachsen | 11958 | 593 | 10600 | 762 | 52.6367 | 9.8451 | 2020-05-31 02:32:45 | Niedersachsen, Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);