johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,011 rows where country_or_region = "US" and province_or_state = "Recovered" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Recovered · 1,011 ✖

country_or_region 1

  • US · 1,011 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2755701 2755701 2022-12-29 US Recovered     0 0 0   0.0 0.0 2022-12-30 04:21:04 Recovered, US
1076707 1076707 2022-12-28 US Recovered     0 0 0   0.0 0.0 2022-12-29 04:21:01 Recovered, US
330704 330704 2022-12-27 US Recovered     0 0 0   0.0 0.0 2022-12-28 04:21:04 Recovered, US
220777 220777 2022-12-26 US Recovered     0 0 0   0.0 0.0 2022-12-27 04:21:07 Recovered, US
3225234 3225234 2022-12-25 US Recovered     0 0 0   0.0 0.0 2022-12-26 04:21:06 Recovered, US
1021148 1021148 2022-12-24 US Recovered     0 0 0   0.0 0.0 2022-12-25 04:21:04 Recovered, US
693171 693171 2022-12-23 US Recovered     0 0 0   0.0 0.0 2022-12-24 04:21:02 Recovered, US
2182381 2182381 2022-12-22 US Recovered     0 0 0   0.0 0.0 2022-12-23 04:21:04 Recovered, US
454185 454185 2022-12-21 US Recovered     0 0 0   0.0 0.0 2022-12-22 04:20:56 Recovered, US
2954184 2954184 2022-12-20 US Recovered     0 0 0   0.0 0.0 2022-12-21 04:21:03 Recovered, US
3176586 3176586 2022-12-19 US Recovered     0 0 0   0.0 0.0 2022-12-20 04:21:04 Recovered, US
1631103 1631103 2022-12-18 US Recovered     0 0 0   0.0 0.0 2022-12-19 04:21:03 Recovered, US
506482 506482 2022-12-17 US Recovered     0 0 0   0.0 0.0 2022-12-18 04:21:03 Recovered, US
3327054 3327054 2022-12-16 US Recovered     0 0 0   0.0 0.0 2022-12-17 04:21:04 Recovered, US
545566 545566 2022-12-15 US Recovered     0 0 0   0.0 0.0 2022-12-16 04:21:01 Recovered, US
351094 351094 2022-12-14 US Recovered     0 0 0   0.0 0.0 2022-12-15 04:20:58 Recovered, US
310682 310682 2022-12-13 US Recovered     0 0 0   0.0 0.0 2022-12-14 04:21:04 Recovered, US
1151743 1151743 2022-12-12 US Recovered     0 0 0   0.0 0.0 2022-12-13 04:21:01 Recovered, US
871597 871597 2022-12-11 US Recovered     0 0 0   0.0 0.0 2022-12-12 04:21:01 Recovered, US
260127 260127 2022-12-10 US Recovered     0 0 0   0.0 0.0 2022-12-11 04:20:50 Recovered, US
3938841 3938841 2022-12-09 US Recovered     0 0 0   0.0 0.0 2022-12-10 04:21:02 Recovered, US
3380173 3380173 2022-12-08 US Recovered     0 0 0   0.0 0.0 2022-12-09 04:21:05 Recovered, US
1987444 1987444 2022-12-07 US Recovered     0 0 0   0.0 0.0 2022-12-08 04:21:07 Recovered, US
3716967 3716967 2022-12-06 US Recovered     0 0 0   0.0 0.0 2022-12-07 04:20:58 Recovered, US
2417672 2417672 2022-12-05 US Recovered     0 0 0   0.0 0.0 2022-12-06 04:21:03 Recovered, US
721280 721280 2022-12-04 US Recovered     0 0 0   0.0 0.0 2022-12-05 04:20:58 Recovered, US
2819569 2819569 2022-12-03 US Recovered     0 0 0   0.0 0.0 2022-12-04 04:20:56 Recovered, US
836425 836425 2022-12-02 US Recovered     0 0 0   0.0 0.0 2022-12-03 04:21:02 Recovered, US
2138955 2138955 2022-12-01 US Recovered     0 0 0   0.0 0.0 2022-12-02 04:21:07 Recovered, US
1967371 1967371 2022-11-30 US Recovered     0 0 0   0.0 0.0 2022-12-01 04:21:03 Recovered, US
2559385 2559385 2022-11-29 US Recovered     0 0 0   0.0 0.0 2022-11-30 04:21:07 Recovered, US
1242459 1242459 2022-11-28 US Recovered     0 0 0   0.0 0.0 2022-11-29 04:21:05 Recovered, US
3554447 3554447 2022-11-27 US Recovered     0 0 0   0.0 0.0 2022-11-28 04:21:02 Recovered, US
2102927 2102927 2022-11-26 US Recovered     0 0 0   0.0 0.0 2022-11-27 04:21:05 Recovered, US
490418 490418 2022-11-25 US Recovered     0 0 0   0.0 0.0 2022-11-26 04:21:11 Recovered, US
3526247 3526247 2022-11-24 US Recovered     0 0 0   0.0 0.0 2022-11-25 04:21:06 Recovered, US
3315030 3315030 2022-11-23 US Recovered     0 0 0   0.0 0.0 2022-11-24 04:21:09 Recovered, US
1623071 1623071 2022-11-22 US Recovered     0 0 0   0.0 0.0 2022-11-23 04:21:06 Recovered, US
3462959 3462959 2022-11-21 US Recovered     0 0 0   0.0 0.0 2022-11-22 04:20:47 Recovered, US
1643144 1643144 2022-11-20 US Recovered     0 0 0   0.0 0.0 2022-11-21 04:21:05 Recovered, US
2066701 2066701 2022-11-19 US Recovered     0 0 0   0.0 0.0 2022-11-20 04:21:08 Recovered, US
1758095 1758095 2022-11-18 US Recovered     0 0 0   0.0 0.0 2022-11-19 04:21:14 Recovered, US
3029088 3029088 2022-11-17 US Recovered     0 0 0   0.0 0.0 2022-11-18 04:21:15 Recovered, US
2488799 2488799 2022-11-16 US Recovered     0 0 0   0.0 0.0 2022-11-17 04:21:11 Recovered, US
294810 294810 2022-11-15 US Recovered     0 0 0   0.0 0.0 2022-11-16 04:21:09 Recovered, US
3599840 3599840 2022-11-14 US Recovered     0 0 0   0.0 0.0 2022-11-15 04:21:16 Recovered, US
314698 314698 2022-11-13 US Recovered     0 0 0   0.0 0.0 2022-11-14 04:21:09 Recovered, US
65859 65859 2022-11-12 US Recovered     0 0 0   0.0 0.0 2022-11-13 04:21:14 Recovered, US
2930021 2930021 2022-11-11 US Recovered     0 0 0   0.0 0.0 2022-11-12 04:20:41 Recovered, US
2508857 2508857 2022-11-10 US Recovered     0 0 0   0.0 0.0 2022-11-11 04:21:22 Recovered, US
2433732 2433732 2022-11-09 US Recovered     0 0 0   0.0 0.0 2022-11-10 04:21:16 Recovered, US
482388 482388 2022-11-08 US Recovered     0 0 0   0.0 0.0 2022-11-09 04:21:22 Recovered, US
2441538 2441538 2022-11-07 US Recovered     0 0 0   0.0 0.0 2022-11-08 04:21:21 Recovered, US
1052636 1052636 2022-11-06 US Recovered     0 0 0   0.0 0.0 2022-11-07 04:21:26 Recovered, US
620660 620660 2022-11-05 US Recovered     0 0 0   0.0 0.0 2022-11-06 04:21:24 Recovered, US
1025164 1025164 2022-11-04 US Recovered     0 0 0   0.0 0.0 2022-11-05 04:21:52 Recovered, US
434155 434155 2022-11-03 US Recovered     0 0 0   0.0 0.0 2022-11-04 04:22:11 Recovered, US
852397 852397 2022-11-02 US Recovered     0 0 0   0.0 0.0 2022-11-03 04:22:05 Recovered, US
713248 713248 2022-11-01 US Recovered     0 0 0   0.0 0.0 2022-11-02 04:22:09 Recovered, US
3287697 3287697 2022-10-31 US Recovered     0 0 0   0.0 0.0 2022-11-01 04:22:36 Recovered, US
322730 322730 2022-10-30 US Recovered     0 0 0   0.0 0.0 2022-10-31 04:21:36 Recovered, US
915006 915006 2022-10-29 US Recovered     0 0 0   0.0 0.0 2022-10-30 04:22:14 Recovered, US
1369275 1369275 2022-10-28 US Recovered     0 0 0   0.0 0.0 2022-10-29 04:21:13 Recovered, US
3041130 3041130 2022-10-27 US Recovered     0 0 0   0.0 0.0 2022-10-28 04:22:31 Recovered, US
541550 541550 2022-10-26 US Recovered     0 0 0   0.0 0.0 2022-10-27 04:22:01 Recovered, US
1832951 1832951 2022-10-25 US Recovered     0 0 0   0.0 0.0 2022-10-26 04:22:19 Recovered, US
797212 797212 2022-10-24 US Recovered     0 0 0   0.0 0.0 2022-10-25 04:21:53 Recovered, US
3279667 3279667 2022-10-23 US Recovered     0 0 0   0.0 0.0 2022-10-24 04:22:29 Recovered, US
2270705 2270705 2022-10-22 US Recovered     0 0 0   0.0 0.0 2022-10-23 04:22:46 Recovered, US
1595005 1595005 2022-10-21 US Recovered     0 0 0   0.0 0.0 2022-10-22 04:22:53 Recovered, US
2274721 2274721 2022-10-20 US Recovered     0 0 0   0.0 0.0 2022-10-21 04:22:23 Recovered, US
201056 201056 2022-10-19 US Recovered     0 0 0   0.0 0.0 2022-10-20 04:22:59 Recovered, US
2759717 2759717 2022-10-18 US Recovered     0 0 0   0.0 0.0 2022-10-19 04:22:26 Recovered, US
2027551 2027551 2022-10-17 US Recovered     0 0 0   0.0 0.0 2022-10-18 04:22:42 Recovered, US
2162329 2162329 2022-10-16 US Recovered     0 0 0   0.0 0.0 2022-10-17 04:20:31 Recovered, US
518526 518526 2022-10-15 US Recovered     0 0 0   0.0 0.0 2022-10-16 04:22:39 Recovered, US
2035583 2035583 2022-10-14 US Recovered     0 0 0   0.0 0.0 2022-10-15 04:22:00 Recovered, US
3756271 3756271 2022-10-13 US Recovered     0 0 0   0.0 0.0 2022-10-14 04:22:28 Recovered, US
3217096 3217096 2022-10-12 US Recovered     0 0 0   0.0 0.0 2022-10-13 04:22:39 Recovered, US
3252945 3252945 2022-10-11 US Recovered     0 0 0   0.0 0.0 2022-10-12 04:22:51 Recovered, US
2970204 2970204 2022-10-10 US Recovered     0 0 0   0.0 0.0 2022-10-11 04:23:05 Recovered, US
3100240 3100240 2022-10-09 US Recovered     0 0 0   0.0 0.0 2022-10-10 04:22:32 Recovered, US
4005465 4005465 2022-10-08 US Recovered     0 0 0   0.0 0.0 2022-10-09 04:21:16 Recovered, US
399062 399062 2022-10-07 US Recovered     0 0 0   0.0 0.0 2022-10-08 04:22:56 Recovered, US
2532179 2532179 2022-10-06 US Recovered     0 0 0   0.0 0.0 2022-10-07 04:23:08 Recovered, US
1813573 1813573 2022-10-05 US Recovered     0 0 0   0.0 0.0 2022-10-06 04:21:22 Recovered, US
133547 133547 2022-10-04 US Recovered     0 0 0   0.0 0.0 2022-10-05 04:23:06 Recovered, US
2688494 2688494 2022-10-03 US Recovered     0 0 0   0.0 0.0 2022-10-04 04:22:55 Recovered, US
2262561 2262561 2022-10-02 US Recovered     0 0 0   0.0 0.0 2022-10-03 04:23:11 Recovered, US
2998087 2998087 2022-10-01 US Recovered     0 0 0   0.0 0.0 2022-10-02 04:21:23 Recovered, US
856413 856413 2022-09-30 US Recovered     0 0 0   0.0 0.0 2022-10-01 04:23:01 Recovered, US
2378339 2378339 2022-09-29 US Recovered     0 0 0   0.0 0.0 2022-09-30 04:23:09 Recovered, US
1562890 1562890 2022-09-28 US Recovered     0 0 0   0.0 0.0 2022-09-29 04:22:34 Recovered, US
3997433 3997433 2022-09-27 US Recovered     0 0 0   0.0 0.0 2022-09-28 04:23:01 Recovered, US
2771761 2771761 2022-09-26 US Recovered     0 0 0   0.0 0.0 2022-09-27 04:23:01 Recovered, US
1979414 1979414 2022-09-25 US Recovered     0 0 0   0.0 0.0 2022-09-26 04:20:52 Recovered, US
2652581 2652581 2022-09-24 US Recovered     0 0 0   0.0 0.0 2022-09-25 04:23:31 Recovered, US
387021 387021 2022-09-23 US Recovered     0 0 0   0.0 0.0 2022-09-24 04:21:40 Recovered, US
1627087 1627087 2022-09-22 US Recovered     0 0 0   0.0 0.0 2022-09-23 04:23:13 Recovered, US
1373291 1373291 2022-09-21 US Recovered     0 0 0   0.0 0.0 2022-09-22 04:22:56 Recovered, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);