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 tot_death

✎ 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
403 403 02/16/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
405 405 07/12/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/13/2020 03:19:34 PM Agree Agree
407 407 03/03/2020 SD 0     0   0     0   03/26/2020 04:22:39 PM N/A Agree
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    
414 414 03/26/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
418 418 02/13/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
420 420 02/17/2020 AR 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
429 429 02/23/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
430 430 04/02/2020 RMI 0     0   0     0   04/01/2020 04:22:39 PM Agree Agree
433 433 01/27/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
435 435 01/24/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
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    
444 444 08/26/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 08/27/2020 01:42:08 PM Agree Agree
447 447 03/23/2020 IA 105     15   0     0   03/26/2020 04:22:39 PM Not agree Not agree
451 451 12/09/2020 PW 0     0 0 0     0 0.0 12/10/2020 02:50:16 PM    
456 456 02/15/2020 NY 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
459 459 01/25/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
463 463 09/24/2020 PW 0     0 0 0     0 0.0 09/25/2020 01:54:10 PM    
464 464 01/25/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
470 470 03/04/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
471 471 02/21/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
474 474 03/08/2020 IA 3     3   0     0   03/26/2020 04:22:39 PM Not agree Not agree
477 477 01/31/2021 PW 0     0 0 0     0 0.0 02/01/2021 02:50:29 PM    
478 478 05/04/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 05/05/2020 05:25:08 PM Agree Agree
481 481 02/25/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
482 482 09/02/2020 AS 0     0 0 0     0 0.0 09/03/2020 02:18:16 PM    
492 492 03/11/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
493 493 12/22/2020 AS 3     0 0 0     0 0.0 12/23/2020 02:36:58 PM    
495 495 03/01/2020 NM 0     0   0     0   03/26/2020 04:22:39 PM N/A Not agree
499 499 11/21/2020 RMI 4 1 3 0 0 0 0 0 0 0.0 11/22/2020 03:02:23 PM Agree Agree
506 506 02/03/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
514 514 03/11/2020 OH 3     0   0     0   03/26/2020 04:22:39 PM Agree Agree
522 522 05/17/2020 PW 0     0 0 0     0 0.0 05/18/2020 04:01:54 PM    
525 525 02/12/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
527 527 07/22/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/23/2020 02:48:19 PM Agree Agree
528 528 02/14/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
534 534 03/18/2020 MA 256     38   0     0   03/26/2020 04:22:39 PM Agree Agree
539 539 02/24/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
540 540 03/11/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
543 543 06/23/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 06/24/2020 03:03:27 PM Agree Agree
546 546 05/21/2020 AS 0     0 0 0     0 0.0 05/22/2020 03:31:45 PM    
549 549 08/06/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 08/07/2020 11:57:59 PM Agree Agree
552 552 05/03/2020 AS 0     0 0 0     0 0.0 05/04/2020 10:49:24 PM    
557 557 05/05/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 05/06/2020 04:23:08 PM Agree Agree
558 558 03/02/2020 NYC 1     1   0     0   03/26/2020 04:22:39 PM Agree Agree
565 565 01/28/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
567 567 02/15/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
571 571 12/13/2020 AS 3     0 0 0     0 0.0 12/14/2020 02:36:45 PM    
574 574 11/27/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 11/28/2020 02:46:47 PM Agree Agree
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    
594 594 04/10/2020 RMI 0     0   0     0   04/09/2020 04:22:39 PM Agree Agree
601 601 03/12/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
603 603 09/21/2020 PW 0     0 0 0     0 0.0 09/22/2020 01:51:57 PM    
605 605 05/07/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 05/08/2020 09:26:08 PM Agree Agree
613 613 02/25/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
615 615 03/11/2020 TX 23     8   0     0   03/26/2020 04:22:39 PM Not agree Not agree
616 616 03/30/2020 HI 252     22 0 0     0   03/29/2020 12:22:39 PM Not agree Not agree
617 617 03/31/2020 RMI 0     0   0     0   03/30/2020 04:22:39 PM Agree Agree
624 624 02/01/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
627 627 01/22/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
641 641 02/05/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
648 648 02/02/2020 NM 0     0   0     0   03/26/2020 04:22:39 PM N/A Not agree
657 657 01/31/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 02/01/2021 02:50:29 PM Agree Agree
660 660 03/16/2020 PR 2     0   0     0   03/26/2020 04:22:39 PM Agree Agree
668 668 02/08/2020 OH 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
672 672 08/24/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 08/25/2020 02:02:54 PM Agree Agree
675 675 02/12/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
678 678 03/08/2020 HI 2     1 0 0     0   03/26/2020 12:22:39 PM Not agree Not agree
681 681 04/06/2020 RMI 0     0   0     0   04/05/2020 04:22:39 PM Agree Agree
684 684 02/03/2020 OH 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
692 692 06/11/2020 PW 0     0 0 0     0 0.0 06/12/2020 02:17:59 PM    
697 697 02/28/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
698 698 03/01/2020 KS 0     0   0     0   03/26/2020 04:22:39 PM Agree N/A
700 700 03/16/2020 HI 11     1 0 0     0   03/26/2020 12:22:39 PM Not agree Not agree
702 702 03/02/2020 OK 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
703 703 07/24/2020 AS 0     0 0 0     0 0.0 07/25/2020 05:40:06 PM    
710 710 04/20/2020 MP 14     0   0 0 0 -2 0.0 04/20/2020 04:22:39 PM Agree Agree
713 713 10/05/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 10/06/2020 01:33:58 PM Agree Agree
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    
721 721 05/23/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 05/24/2020 02:15:55 PM Agree Agree
725 725 02/10/2020 TN 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
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    
731 731 09/09/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 09/10/2020 02:02:53 PM Agree Agree
733 733 02/19/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
735 735 09/25/2020 AS 0     0 0 0     0 0.0 09/26/2020 01:46:07 PM    
738 738 03/06/2020 MA 7     5   0     0   03/26/2020 04:22:39 PM Agree Agree
739 739 03/04/2020 FL 2     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
742 742 02/07/2020 FL 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
745 745 09/12/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 09/13/2020 04:17:15 PM Agree Agree
755 755 01/28/2021 AS 3     0 0 0     0 0.0 01/29/2021 02:42:19 PM    
761 761 04/05/2020 RMI 0     0   0     0   04/04/2020 04:22:39 PM Agree Agree
765 765 01/26/2020 OK 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
766 766 03/17/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
768 768 01/20/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 01/21/2021 02:44:32 PM Agree Agree

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