cdc_cases_deaths

Table actions
Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: big-local-datasette

24,240 rows sorted by consent_cases

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid submission_date state tot_cases conf_cases prob_cases new_case pnew_case tot_death conf_death prob_death new_death pnew_death created_at consent_cases ▼ consent_deaths
8 8 09/26/2020 PW 0     0 0 0     0 0.0 09/27/2020 01:39:49 PM    
13 13 06/07/2020 PW 0     0 0 0     0 0.0 06/08/2020 02:55:08 PM    
21 21 10/11/2020 PW 0     0 0 0     0 0.0 10/12/2020 02:07:08 PM    
25 25 01/12/2021 AS 3     0 0 0     0 0.0 01/13/2021 02:44:58 PM    
38 38 12/28/2020 AS 3     0 0 0     0 0.0 12/29/2020 02:56:32 PM    
39 39 06/23/2020 PW 0     0 0 0     0 0.0 06/24/2020 03:03:27 PM    
46 46 05/03/2020 PW 0     0 0 0     0 0.0 05/04/2020 10:49:24 PM    
61 61 11/06/2020 PW 0     0 0 0     0 0.0 11/07/2020 02:45:17 PM    
77 77 12/06/2020 AS 3     0 0 0     0 0.0 12/07/2020 02:38:33 PM    
103 103 02/18/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
126 126 03/14/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
135 135 04/08/2020 AS 0     0   0     0   04/07/2020 04:22:39 PM    
145 145 11/30/2020 AS 3     0 0 0     0 0.0 12/01/2020 03:26:07 PM    
162 162 12/11/2020 AS 3     0 0 0     0 0.0 12/12/2020 02:59:37 PM    
173 173 11/11/2020 PW 0     0 0 0     0 0.0 11/12/2020 02:55:21 PM    
177 177 03/03/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
184 184 09/17/2020 PW 0     0 0 0     0 0.0 09/18/2020 01:48:37 PM    
189 189 08/26/2020 AS 0     0 0 0     0 0.0 08/27/2020 01:42:08 PM    
195 195 03/29/2020 PW 0     0   0     0   03/28/2020 04:22:39 PM    
197 197 07/15/2020 PW 0     0 0 0     0 0.0 07/16/2020 02:22:21 PM    
200 200 02/07/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
210 210 08/25/2020 AS 0     0 0 0     0 0.0 08/26/2020 01:51:40 PM    
253 253 11/07/2020 PW 0     0 0 0     0 0.0 11/08/2020 02:40:34 PM    
254 254 02/08/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
271 271 01/09/2021 PW 0     0 0 0     0 0.0 01/10/2021 04:10:55 PM    
273 273 09/20/2020 AS 0     0 0 0     0 0.0 09/21/2020 01:47:41 PM    
274 274 09/30/2020 AS 0     0 0 0     0 0.0 10/01/2020 01:42:11 PM    
275 275 03/04/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
283 283 01/22/2021 AS 3     0 0 0     0 0.0 01/23/2021 02:50:13 PM    
285 285 07/02/2020 PW 0     0 0 0     0 0.0 07/03/2020 03:01:33 PM    
287 287 06/15/2020 PW 0     0 0 0     0 0.0 06/16/2020 02:10:11 PM    
299 299 08/24/2020 AS 0     0 0 0     0 0.0 08/25/2020 02:02:54 PM    
311 311 01/28/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
352 352 08/11/2020 AS 0     0 0 0     0 0.0 08/12/2020 01:50:14 PM    
359 359 03/27/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
375 375 10/17/2020 AS 0     0 0 0     0 0.0 10/18/2020 01:26:54 PM    
409 409 01/07/2021 AS 3     0 0 0     0 0.0 01/08/2021 03:56:01 PM    
412 412 08/05/2020 AS 0     0 0 0     0 0.0 08/06/2020 02:12:27 PM    
413 413 11/09/2020 PW 0     0 0 0     0 0.0 11/10/2020 02:45:45 PM    
418 418 02/13/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
436 436 07/07/2020 AS 0     0 0 0     0 0.0 07/08/2020 02:12:08 PM    
437 437 01/05/2021 AS 3     0 0 0     0 0.0 01/06/2021 02:58:26 PM    
451 451 12/09/2020 PW 0     0 0 0     0 0.0 12/10/2020 02:50:16 PM    
463 463 09/24/2020 PW 0     0 0 0     0 0.0 09/25/2020 01:54:10 PM    
477 477 01/31/2021 PW 0     0 0 0     0 0.0 02/01/2021 02:50:29 PM    
482 482 09/02/2020 AS 0     0 0 0     0 0.0 09/03/2020 02:18:16 PM    
493 493 12/22/2020 AS 3     0 0 0     0 0.0 12/23/2020 02:36:58 PM    
522 522 05/17/2020 PW 0     0 0 0     0 0.0 05/18/2020 04:01:54 PM    
540 540 03/11/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
546 546 05/21/2020 AS 0     0 0 0     0 0.0 05/22/2020 03:31:45 PM    
552 552 05/03/2020 AS 0     0 0 0     0 0.0 05/04/2020 10:49:24 PM    
571 571 12/13/2020 AS 3     0 0 0     0 0.0 12/14/2020 02:36:45 PM    
577 577 03/28/2020 AS 0     0   0     0   03/28/2020 04:22:39 PM    
588 588 03/02/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
603 603 09/21/2020 PW 0     0 0 0     0 0.0 09/22/2020 01:51:57 PM    
627 627 01/22/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
692 692 06/11/2020 PW 0     0 0 0     0 0.0 06/12/2020 02:17:59 PM    
703 703 07/24/2020 AS 0     0 0 0     0 0.0 07/25/2020 05:40:06 PM    
717 717 03/11/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
718 718 06/03/2020 AS 0     0 0 0     0 0.0 06/04/2020 03:03:31 PM    
726 726 01/24/2021 PW 0     0 0 0     0 0.0 01/25/2021 02:42:40 PM    
727 727 08/09/2020 AS 0     0 0 0     0 0.0 08/10/2020 02:23:35 PM    
735 735 09/25/2020 AS 0     0 0 0     0 0.0 09/26/2020 01:46:07 PM    
755 755 01/28/2021 AS 3     0 0 0     0 0.0 01/29/2021 02:42:19 PM    
785 785 12/19/2020 AS 3     0 0 0     0 0.0 12/20/2020 02:32:33 PM    
795 795 12/07/2020 PW 0     0 0 0     0 0.0 12/08/2020 02:59:49 PM    
821 821 09/04/2020 AS 0     0 0 0     0 0.0 09/05/2020 02:09:45 PM    
832 832 03/28/2020 PW 0     0   0     0   03/28/2020 04:22:39 PM    
860 860 06/06/2020 PW 0     0 0 0     0 0.0 06/07/2020 02:23:35 PM    
866 866 12/04/2020 PW 0     0 0 0     0 0.0 12/05/2020 02:29:17 PM    
879 879 01/01/2021 PW 0     0 0 0     0 0.0 01/02/2021 02:50:51 PM    
882 882 07/22/2020 AS 0     0 0 0     0 0.0 07/23/2020 02:48:19 PM    
889 889 01/23/2021 PW 0     0 0 0     0 0.0 01/24/2021 02:36:49 PM    
890 890 02/15/2021 AS 4     0 0 0     0 0.0 02/16/2021 02:53:06 PM    
894 894 02/04/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
903 903 11/01/2020 PW 0     0 0 0     0 0.0 11/02/2020 02:53:09 PM    
917 917 09/23/2020 AS 0     0 0 0     0 0.0 09/24/2020 01:54:02 PM    
921 921 12/31/2020 PW 0     0 0 0     0 0.0 01/01/2021 02:49:07 PM    
934 934 05/06/2020 PW 0     0 0 0     0 0.0 05/07/2020 10:59:02 PM    
955 955 06/02/2020 AS 0     0 0 0     0 0.0 06/03/2020 02:11:36 PM    
957 957 08/14/2020 PW 0     0 0 0     0 0.0 08/15/2020 02:02:05 PM    
964 964 12/12/2020 PW 0     0 0 0     0 0.0 12/13/2020 02:31:19 PM    
973 973 04/19/2020 PW 0     0 0 0     0 0.0 04/19/2020 04:22:39 PM    
979 979 01/17/2021 PW 0     0 0 0     0 0.0 01/18/2021 02:39:32 PM    
982 982 08/28/2020 PW 0     0 0 0     0 0.0 08/29/2020 01:42:50 PM    
992 992 07/24/2020 PW 0     0 0 0     0 0.0 07/25/2020 05:40:06 PM    
998 998 07/26/2020 AS 0     0 0 0     0 0.0 07/27/2020 02:16:42 PM    
1003 1003 05/15/2020 PW 0     0 0 0     0 0.0 05/16/2020 03:46:44 PM    
1039 1039 04/22/2020 AS 0     0 0 0     0 0.0 04/22/2020 04:22:39 PM    
1050 1050 01/30/2021 PW 0     0 0 0     0 0.0 01/31/2021 02:48:12 PM    
1060 1060 05/22/2020 PW 0     0 0 0     0 0.0 05/23/2020 05:58:16 PM    
1064 1064 01/25/2021 PW 0     0 0 0     0 0.0 01/26/2021 02:46:01 PM    
1080 1080 05/20/2020 PW 0     0 0 0     0 0.0 05/21/2020 03:41:38 PM    
1104 1104 06/24/2020 PW 0     0 0 0     0 0.0 06/25/2020 02:07:27 PM    
1132 1132 10/18/2020 AS 0     0 0 0     0 0.0 10/19/2020 02:06:44 PM    
1133 1133 01/19/2021 PW 0     0 0 0     0 0.0 01/20/2021 02:44:03 PM    
1138 1138 06/30/2020 AS 0     0 0 0     0 0.0 07/01/2020 03:45:16 PM    
1169 1169 04/25/2020 AS 0     0 0 0     0 0.0 05/25/2020 03:38:40 PM    
1197 1197 11/21/2020 PW 0     0 0 0     0 0.0 11/22/2020 03:02:23 PM    
1207 1207 02/15/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [cdc_cases_deaths] (
   [submission_date] TEXT,
   [state] TEXT,
   [tot_cases] INTEGER,
   [conf_cases] INTEGER,
   [prob_cases] INTEGER,
   [new_case] INTEGER,
   [pnew_case] INTEGER,
   [tot_death] INTEGER,
   [conf_death] INTEGER,
   [prob_death] INTEGER,
   [new_death] INTEGER,
   [pnew_death] FLOAT,
   [created_at] TEXT,
   [consent_cases] TEXT,
   [consent_deaths] TEXT
);