johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
62 rows where confirmed = 12563 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 57
- Russia 3
- Chile 1
- Korea, South 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3175431 | 3175431 | 2022-12-19 | US | Michigan | Gratiot | 26057 | 12563 | 205 | 0 | 43.29265605 | -84.60505416 | 2022-12-20 04:21:04 | Gratiot, Michigan, US | |
1629948 | 1629948 | 2022-12-18 | US | Michigan | Gratiot | 26057 | 12563 | 205 | 0 | 43.29265605 | -84.60505416 | 2022-12-19 04:21:03 | Gratiot, Michigan, US | |
505327 | 505327 | 2022-12-17 | US | Michigan | Gratiot | 26057 | 12563 | 205 | 0 | 43.29265605 | -84.60505416 | 2022-12-18 04:21:03 | Gratiot, Michigan, US | |
3325899 | 3325899 | 2022-12-16 | US | Michigan | Gratiot | 26057 | 12563 | 205 | 0 | 43.29265605 | -84.60505416 | 2022-12-17 04:21:04 | Gratiot, Michigan, US | |
544411 | 544411 | 2022-12-15 | US | Michigan | Gratiot | 26057 | 12563 | 205 | 0 | 43.29265605 | -84.60505416 | 2022-12-16 04:21:01 | Gratiot, Michigan, US | |
349939 | 349939 | 2022-12-14 | US | Michigan | Gratiot | 26057 | 12563 | 205 | 0 | 43.29265605 | -84.60505416 | 2022-12-15 04:20:58 | Gratiot, Michigan, US | |
309527 | 309527 | 2022-12-13 | US | Michigan | Gratiot | 26057 | 12563 | 205 | 0 | 43.29265605 | -84.60505416 | 2022-12-14 04:21:04 | Gratiot, Michigan, US | |
481217 | 481217 | 2022-11-08 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-09 04:21:22 | Cass, Michigan, US | |
2440367 | 2440367 | 2022-11-07 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-08 04:21:21 | Cass, Michigan, US | |
1051465 | 1051465 | 2022-11-06 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-07 04:21:26 | Cass, Michigan, US | |
619489 | 619489 | 2022-11-05 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-06 04:21:24 | Cass, Michigan, US | |
1023993 | 1023993 | 2022-11-04 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-05 04:21:52 | Cass, Michigan, US | |
432984 | 432984 | 2022-11-03 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-04 04:22:11 | Cass, Michigan, US | |
851226 | 851226 | 2022-11-02 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-03 04:22:05 | Cass, Michigan, US | |
712077 | 712077 | 2022-11-01 | US | Michigan | Cass | 26027 | 12563 | 157 | 0 | 41.91522292 | -85.99405727 | 2022-11-02 04:22:09 | Cass, Michigan, US | |
396760 | 396760 | 2022-10-07 | US | Arkansas | Hot Spring | 5059 | 12563 | 154 | 0 | 34.31709259 | -92.95396325 | 2022-10-08 04:22:56 | Hot Spring, Arkansas, US | |
2018867 | 2018867 | 2022-09-20 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-21 04:23:22 | Elko, Nevada, US | |
3572740 | 3572740 | 2022-09-19 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-20 04:22:48 | Elko, Nevada, US | |
421479 | 421479 | 2022-09-18 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-19 04:21:49 | Elko, Nevada, US | |
3375503 | 3375503 | 2022-09-17 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-18 04:22:50 | Elko, Nevada, US | |
2357611 | 2357611 | 2022-09-16 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-17 04:20:19 | Elko, Nevada, US | |
3988768 | 3988768 | 2022-09-15 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-16 04:21:19 | Elko, Nevada, US | |
1891285 | 1891285 | 2022-09-14 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-15 04:21:02 | Elko, Nevada, US | |
374340 | 374340 | 2022-09-13 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-14 04:20:44 | Elko, Nevada, US | |
2396942 | 2396942 | 2022-09-12 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-13 04:20:57 | Elko, Nevada, US | |
3768020 | 3768020 | 2022-09-11 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-12 04:20:58 | Elko, Nevada, US | |
3826595 | 3826595 | 2022-09-10 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-11 04:20:50 | Elko, Nevada, US | |
965052 | 965052 | 2022-09-09 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-10 04:21:10 | Elko, Nevada, US | |
255454 | 255454 | 2022-09-08 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-09 04:21:11 | Elko, Nevada, US | |
3748531 | 3748531 | 2022-09-07 | US | Virginia | Tazewell | 51185 | 12563 | 195 | 0 | 37.12191123 | -81.56685568 | 2022-09-08 04:21:02 | Tazewell, Virginia, US | |
3747252 | 3747252 | 2022-09-07 | US | Nevada | Elko | 32007 | 12563 | 142 | 0 | 41.14531606 | -115.3577619 | 2022-09-08 04:21:02 | Elko, Nevada, US | |
2011630 | 2011630 | 2022-08-04 | US | Tennessee | Fayette | 47047 | 12563 | 191 | 0 | 35.19615831 | -89.41399032 | 2022-08-05 04:20:52 | Fayette, Tennessee, US | |
2051161 | 2051161 | 2022-05-25 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-26 04:20:50 | Washington, Vermont, US | |
3002599 | 3002599 | 2022-05-24 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-25 04:20:56 | Washington, Vermont, US | |
3596320 | 3596320 | 2022-05-23 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-24 04:20:57 | Washington, Vermont, US | |
625172 | 625172 | 2022-05-22 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-26 04:20:50 | Washington, Vermont, US | |
1112868 | 1112868 | 2022-05-21 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-22 04:20:52 | Washington, Vermont, US | |
1172492 | 1172492 | 2022-05-20 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-21 04:20:58 | Washington, Vermont, US | |
3899255 | 3899255 | 2022-05-19 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-20 04:20:57 | Washington, Vermont, US | |
1188039 | 1188039 | 2022-05-18 | US | Vermont | Washington | 50023 | 12563 | 51 | 0 | 44.27343241 | -72.61604978 | 2022-05-19 04:20:54 | Washington, Vermont, US | |
2114171 | 2114171 | 2021-12-26 | US | Ohio | Hancock | 39063 | 12563 | 227 | 0 | 41.00250487 | -83.66838948 | 2021-12-27 04:21:58 | Hancock, Ohio, US | |
407828 | 407828 | 2021-12-07 | US | Wisconsin | Chippewa | 55017 | 12563 | 130 | 0 | 45.06939744 | -91.28068855 | 2021-12-08 04:22:46 | Chippewa, Wisconsin, US | |
1033910 | 1033910 | 2021-12-06 | US | Wisconsin | Chippewa | 55017 | 12563 | 130 | 0 | 45.06939744 | -91.28068855 | 2021-12-07 04:22:34 | Chippewa, Wisconsin, US | |
1744073 | 1744073 | 2021-12-05 | US | Wisconsin | Chippewa | 55017 | 12563 | 130 | 0 | 45.06939744 | -91.28068855 | 2021-12-06 04:22:34 | Chippewa, Wisconsin, US | |
141505 | 141505 | 2021-12-04 | US | Wisconsin | Chippewa | 55017 | 12563 | 130 | 0 | 45.06939744 | -91.28068855 | 2021-12-05 04:22:25 | Chippewa, Wisconsin, US | |
2199158 | 2199158 | 2021-12-03 | US | Wisconsin | Chippewa | 55017 | 12563 | 130 | 0 | 45.06939744 | -91.28068855 | 2021-12-04 04:22:18 | Chippewa, Wisconsin, US | |
723877 | 723877 | 2021-11-20 | US | Kentucky | Bullitt | 21029 | 12563 | 137 | 0 | 37.97162523 | -85.68955617 | 2021-11-21 04:22:13 | Bullitt, Kentucky, US | |
3344129 | 3344129 | 2021-11-16 | US | Louisiana | Iberia | 22045 | 12563 | 226 | 0 | 29.86803617 | -91.75871777 | 2021-11-17 04:21:48 | Iberia, Louisiana, US | |
3010490 | 3010490 | 2021-10-11 | US | Texas | Liberty | 48291 | 12563 | 324 | 0 | 30.15152688 | -94.81205615 | 2021-10-12 04:21:09 | Liberty, Texas, US | |
1896193 | 1896193 | 2021-06-30 | US | Texas | Comal | 48091 | 12563 | 305 | 0 | 29.80811278 | -98.27647225 | 2021-07-01 04:21:19 | Comal, Texas, US | |
1311649 | 1311649 | 2021-05-26 | US | Louisiana | Ascension | 22005 | 12563 | 167 | 0 | 30.20406249 | -90.91328409999998 | 2021-05-27 04:20:59 | Ascension, Louisiana, US | |
1302273 | 1302273 | 2021-04-01 | Russia | Mari El Republic | 12563 | 205 | 11694 | 664 | 56.5767504 | 47.8817512 | 2021-04-02 04:20:36 | Mari El Republic, Russia | ||
3370507 | 3370507 | 2021-03-21 | US | Iowa | Dubuque | 19061 | 12563 | 200 | 0 | 42.46815349 | -90.88181925 | 2021-03-22 05:25:43 | Dubuque, Iowa, US | |
2360382 | 2360382 | 2021-03-08 | US | Idaho | Bonneville | 16019 | 12563 | 149 | 0 | 43.38713372 | -111.6161537 | 2021-03-09 05:28:19 | Bonneville, Idaho, US | |
999983 | 999983 | 2021-03-01 | US | Maine | Cumberland | 23005 | 12563 | 179 | 0 | 12384 | 43.8370751 | -70.37226999 | 2021-03-02 05:23:30 | Cumberland, Maine, US |
2638190 | 2638190 | 2021-02-11 | US | Arkansas | Craighead | 5031 | 12563 | 174 | 0 | 12389 | 35.83018283 | -90.63235729 | 2021-02-12 05:23:29 | Craighead, Arkansas, US |
3153389 | 3153389 | 2021-01-27 | Chile | Arica y Parinacota | 12563 | 251 | 11694 | 618 | -18.594 | -69.4785 | 2021-01-28 05:22:24 | Arica y Parinacota, Chile | ||
1584357 | 1584357 | 2020-11-30 | Russia | Chuvashia Republic | 12563 | 278 | 11519 | 766 | 55.4259922 | 47.0849429 | 2020-12-01 05:26:18 | Chuvashia Republic, Russia | ||
1044061 | 1044061 | 2020-10-07 | US | New York | Orange | 36071 | 12563 | 499 | 0 | 12064 | 41.40337468 | -74.30240757 | 2020-10-08 04:23:56 | Orange, New York, US |
2729214 | 2729214 | 2020-09-15 | Russia | Krasnodar Krai | 12563 | 228 | 9952 | 2383 | 45.7684014 | 39.0261044 | 2020-09-16 04:22:53 | Krasnodar Krai, Russia | ||
2220062 | 2220062 | 2020-07-08 | US | Tennessee | Davidson | 47037 | 12563 | 132 | 0 | 12102 | 36.17007426 | -86.78646056 | 2020-07-09 04:34:23 | Davidson, Tennessee, US |
2701078 | 2701078 | 2020-06-24 | Korea, South | 12563 | 282 | 10974 | 1307 | 35.90775700000001 | 127.766922 | 2020-06-25 05:26:54 | Korea, South |
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]);