johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where confirmed = 17486 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 25
- Tajikistan 19
- Russia 3
- Colombia 1
- Oman 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1372653 | 1372653 | 2022-09-21 | US | New Hampshire | Cheshire | 33005 | 17486 | 124 | 0 | 42.92015988 | -72.25311043 | 2022-09-22 04:22:56 | Cheshire, New Hampshire, US | |
2154631 | 2154631 | 2022-07-16 | US | Tennessee | McMinn | 47107 | 17486 | 269 | 0 | 35.42812616 | -84.61520715 | 2022-07-17 04:21:15 | McMinn, Tennessee, US | |
2154609 | 2154609 | 2022-07-16 | US | Tennessee | Hawkins | 47073 | 17486 | 332 | 0 | 36.44355426 | -82.94885298 | 2022-07-17 04:21:15 | Hawkins, Tennessee, US | |
1213197 | 1213197 | 2022-07-11 | US | Michigan | Ionia | 26067 | 17486 | 181 | 0 | 42.94502238 | -85.07413319 | 2022-07-12 04:20:51 | Ionia, Michigan, US | |
2790679 | 2790679 | 2022-07-10 | US | Michigan | Ionia | 26067 | 17486 | 181 | 0 | 42.94502238 | -85.07413319 | 2022-07-11 04:20:46 | Ionia, Michigan, US | |
143632 | 143632 | 2022-07-09 | US | Michigan | Ionia | 26067 | 17486 | 181 | 0 | 42.94502238 | -85.07413319 | 2022-07-10 04:20:54 | Ionia, Michigan, US | |
1418732 | 1418732 | 2022-07-08 | US | Michigan | Ionia | 26067 | 17486 | 181 | 0 | 42.94502238 | -85.07413319 | 2022-07-09 04:20:59 | Ionia, Michigan, US | |
2742657 | 2742657 | 2022-07-07 | US | Michigan | Ionia | 26067 | 17486 | 181 | 0 | 42.94502238 | -85.07413319 | 2022-07-08 04:20:56 | Ionia, Michigan, US | |
1201452 | 1201452 | 2022-07-06 | US | Michigan | Ionia | 26067 | 17486 | 181 | 0 | 42.94502238 | -85.07413319 | 2022-07-07 04:20:55 | Ionia, Michigan, US | |
3968195 | 3968195 | 2022-07-05 | US | Michigan | Ionia | 26067 | 17486 | 181 | 0 | 42.94502238 | -85.07413319 | 2022-07-06 04:20:58 | Ionia, Michigan, US | |
1186972 | 1186972 | 2022-05-18 | US | New York | Cayuga | 36011 | 17486 | 154 | 0 | 42.91261714 | -76.55731592 | 2022-05-19 04:20:54 | Cayuga, New York, US | |
3228821 | 3228821 | 2022-01-19 | US | North Carolina | Surry | 37171 | 17486 | 268 | 0 | 36.41689489 | -80.69102283 | 2022-01-20 04:21:07 | Surry, North Carolina, US | |
1282355 | 1282355 | 2022-01-05 | US | Alabama | Cullman | 1043 | 17486 | 311 | 0 | 34.13020303 | -86.86888037 | 2022-01-06 04:22:09 | Cullman, Alabama, US | |
405403 | 405403 | 2021-12-07 | US | Indiana | LaPorte | 18091 | 17486 | 266 | 0 | 41.54366008 | -86.74072188 | 2021-12-08 04:22:46 | LaPorte, Indiana, US | |
1032870 | 1032870 | 2021-12-06 | US | Ohio | Miami | 39109 | 17486 | 358 | 0 | 40.0543329 | -84.22871271 | 2021-12-07 04:22:34 | Miami, Ohio, US | |
87460 | 87460 | 2021-11-09 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-10 04:21:38 | Tajikistan | ||||
3639888 | 3639888 | 2021-11-08 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-09 04:21:36 | Tajikistan | ||||
2000996 | 2000996 | 2021-11-07 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-08 04:21:43 | Tajikistan | ||||
495987 | 495987 | 2021-11-06 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-07 04:21:53 | Tajikistan | ||||
3121842 | 3121842 | 2021-11-05 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-06 04:21:51 | Tajikistan | ||||
698740 | 698740 | 2021-11-04 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-05 04:21:54 | Tajikistan | ||||
276518 | 276518 | 2021-11-03 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-04 04:22:20 | Tajikistan | ||||
44043 | 44043 | 2021-11-02 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-03 06:22:09 | Tajikistan | ||||
3511739 | 3511739 | 2021-11-01 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-02 04:22:03 | Tajikistan | ||||
288331 | 288331 | 2021-10-31 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-11-01 04:22:01 | Tajikistan | ||||
2721337 | 2721337 | 2021-10-30 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-31 04:22:08 | Tajikistan | ||||
567439 | 567439 | 2021-10-29 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-30 04:22:03 | Tajikistan | ||||
4681 | 4681 | 2021-10-28 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-29 04:22:03 | Tajikistan | ||||
535071 | 535071 | 2021-10-27 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-28 04:22:08 | Tajikistan | ||||
3492508 | 3492508 | 2021-10-26 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-27 04:22:32 | Tajikistan | ||||
3794230 | 3794230 | 2021-10-25 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-26 04:22:09 | Tajikistan | ||||
682676 | 682676 | 2021-10-24 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-25 04:22:31 | Tajikistan | ||||
770684 | 770684 | 2021-10-23 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-24 04:21:22 | Tajikistan | ||||
654331 | 654331 | 2021-10-22 | Tajikistan | 17486 | 125 | 0 | 38.861 | 71.2761 | 2021-10-23 04:21:32 | Tajikistan | ||||
1237159 | 1237159 | 2021-09-27 | US | Louisiana | Lafourche | 22057 | 17486 | 287 | 0 | 29.52470226 | -90.40976986 | 2021-09-28 04:21:28 | Lafourche, Louisiana, US | |
2205059 | 2205059 | 2021-08-07 | US | Kentucky | Kenton | 21117 | 17486 | 210 | 0 | 38.93950319 | -84.53241199 | 2021-08-08 04:21:33 | Kenton, Kentucky, US | |
3386939 | 3386939 | 2021-07-29 | US | Maine | Cumberland | 23005 | 17486 | 205 | 0 | 43.8370751 | -70.37226999 | 2021-07-30 04:21:34 | Cumberland, Maine, US | |
779214 | 779214 | 2021-07-08 | US | Georgia | Paulding | 13223 | 17486 | 232 | 0 | 33.91969522 | -84.86848792 | 2021-07-09 04:21:21 | Paulding, Georgia, US | |
2315853 | 2315853 | 2021-06-04 | US | California | Madera | 6039 | 17486 | 240 | 0 | 37.21513971 | -119.76655890000002 | 2021-06-05 04:23:03 | Madera, California, US | |
1415703 | 1415703 | 2021-05-24 | US | Pennsylvania | Butler | 42019 | 17486 | 414 | 0 | 40.91152759 | -79.91351055 | 2021-05-25 04:21:08 | Butler, Pennsylvania, US | |
380033 | 380033 | 2021-04-30 | Colombia | Caqueta | 17486 | 655 | 16635 | 196 | 0.8699 | -73.8419 | 2021-05-01 04:20:47 | Caqueta, Colombia | ||
471661 | 471661 | 2021-02-19 | Russia | Tatarstan Republic | 17486 | 310 | 14095 | 3081 | 55.7648572 | 52.43104273 | 2021-02-20 05:22:51 | Tatarstan Republic, Russia | ||
1673171 | 1673171 | 2021-02-07 | US | Florida | Okaloosa | 12091 | 17486 | 298 | 0 | 17188 | 30.69143028 | -86.59267105 | 2021-02-08 05:22:39 | Okaloosa, Florida, US |
1759890 | 1759890 | 2021-01-24 | US | Colorado | Boulder | 8013 | 17486 | 219 | 0 | 16537 | 40.09313619 | -105.3546767 | 2021-01-25 05:22:16 | Boulder, Colorado, US |
774970 | 774970 | 2021-01-12 | US | Colorado | Larimer | 8069 | 17486 | 191 | 0 | 16207 | 40.66671597 | -105.4625784 | 2021-01-13 05:22:15 | Larimer, Colorado, US |
1632553 | 1632553 | 2020-12-05 | Russia | Tula Oblast | 17486 | 508 | 15418 | 1560 | 53.9570701 | 37.3690909 | 2020-12-06 05:26:18 | Tula Oblast, Russia | ||
2838371 | 2838371 | 2020-09-21 | US | Maryland | Baltimore | 24005 | 17486 | 619 | 0 | 16867 | 39.45784712 | -76.62911955 | 2020-09-22 04:23:00 | Baltimore, Maryland, US |
2662011 | 2662011 | 2020-09-04 | Russia | Rostov Oblast | 17486 | 369 | 14897 | 2220 | 47.6222451 | 40.7957942 | 2020-09-05 04:28:19 | Rostov Oblast, Russia | ||
217558 | 217558 | 2020-06-08 | Oman | 17486 | 81 | 3793 | 13612 | 21.512583 | 55.92325500000001 | 2020-06-09 03:33:03 | Oman |
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]);