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 pnew_case

✎ 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
504 504 04/12/2020 PR 897     109   44     2   04/11/2020 04:22:39 PM Agree Agree
506 506 02/03/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
508 508 03/20/2020 NYC 5151     0   29     0   03/26/2020 04:22:39 PM Agree Agree
510 510 04/08/2020 OH 5148     366   193     26   04/07/2020 04:22:39 PM Agree Agree
514 514 03/11/2020 OH 3     0   0     0   03/26/2020 04:22:39 PM Agree Agree
518 518 04/03/2020 UT 1246     81   7     0   04/03/2020 04:22:39 PM Agree Agree
525 525 02/12/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
528 528 02/14/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
529 529 03/22/2020 NY 6123     1978   24     3   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    
551 551 04/09/2020 AR 1127     56   21     3   04/08/2020 04:22:39 PM Not agree Not 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
569 569 04/16/2020 AR 1635     52   37     4   04/16/2020 04:22:39 PM Not agree Not agree
577 577 03/28/2020 AS 0     0   0     0   03/28/2020 04:22:39 PM    
583 583 03/16/2020 NY 487     87   1     0   03/26/2020 04:22:39 PM Not agree Not agree
584 584 04/16/2020 AK 300     7   9     0   04/16/2020 04:22:39 PM N/A N/A
588 588 03/02/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
593 593 03/30/2020 PR 174     47   7     2   03/29/2020 04:22:39 PM Agree Agree
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
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
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    
633 633 03/18/2020 TX 83     19   2     1   03/26/2020 04:22:39 PM Not agree Not agree
641 641 02/05/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
644 644 04/13/2020 PA 24199     1366   524     17   04/12/2020 04:22:39 PM Agree Not agree
648 648 02/02/2020 NM 0     0   0     0   03/26/2020 04:22:39 PM N/A Not agree
649 649 04/04/2020 TX 6110     780   105     15   04/03/2020 04:22:39 PM Not agree Not agree
654 654 04/17/2020 SD 1411     100   7     0   04/17/2020 04:22:39 PM N/A 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
675 675 02/12/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree 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
693 693 04/15/2020 MP 13     0   2     0   04/15/2020 04:22:39 PM Agree Agree
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
702 702 03/02/2020 OK 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
710 710 04/20/2020 MP 14     0   0 0 0 -2 0.0 04/20/2020 04:22:39 PM Agree Agree
717 717 03/11/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
720 720 03/27/2020 CO 1734     304   31     7   03/26/2020 04:22:39 PM Agree Agree
725 725 02/10/2020 TN 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
733 733 02/19/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
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
752 752 04/11/2020 PR 788     63   42     3   04/10/2020 04:22:39 PM Agree Agree
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
769 769 02/11/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
773 773 01/26/2020 NM 0     0   0     0   03/26/2020 04:22:39 PM N/A Not agree
776 776 02/04/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
778 778 04/08/2020 SD 393     73   6     0   04/07/2020 04:22:39 PM N/A Agree
780 780 02/09/2020 MA 1     0   0     0   03/26/2020 04:22:39 PM Agree Agree
784 784 04/15/2020 RMI 0     0   0     0   04/15/2020 04:22:39 PM Agree Agree
789 789 02/10/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
792 792 03/18/2020 PA 133     37   1     1   03/26/2020 04:22:39 PM Agree Not agree
806 806 03/09/2020 TX 13     7   0     0   03/26/2020 04:22:39 PM Not agree Not agree
812 812 02/04/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
813 813 01/22/2020 MA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
819 819 02/01/2020 FL 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
828 828 02/06/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
830 830 04/16/2020 FL 22674     809   668     54   04/16/2020 04:22:39 PM Not agree Not agree
832 832 03/28/2020 PW 0     0   0     0   03/28/2020 04:22:39 PM    
839 839 04/10/2020 OH 5878     366   231     18   04/09/2020 04:22:39 PM Agree Agree
840 840 01/23/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
841 841 04/07/2020 OH 4782     332   167     25   04/07/2020 04:22:39 PM Agree Agree
842 842 02/15/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
843 843 01/25/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
847 847 04/09/2020 PR 683     63   33     9   04/08/2020 04:22:39 PM Agree Agree
851 851 04/17/2020 MP 14     1   2     0   04/17/2020 04:22:39 PM Agree Agree
863 863 03/01/2020 TN 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
864 864 03/03/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
867 867 04/01/2020 RMI 0     0   0     0   03/31/2020 04:22:39 PM Agree Agree
872 872 03/01/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
883 883 02/06/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
888 888 02/27/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
894 894 02/04/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
906 906 02/12/2020 OH 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
907 907 02/16/2020 OH 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
911 911 02/26/2020 NY 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
913 913 03/04/2020 HI 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
916 916 04/18/2020 FL 24797     731   748     22   04/18/2020 04:22:39 PM Not agree Not agree
922 922 01/24/2020 MA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
936 936 03/01/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
939 939 01/27/2020 WV 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
942 942 03/02/2020 TN 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
945 945 01/22/2020 NY 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
954 954 04/08/2020 KS 1076     176   39     12   04/07/2020 04:22:39 PM Agree N/A
956 956 03/05/2020 TN 1     1   0     0   03/26/2020 04:22:39 PM Agree Agree
963 963 04/11/2020 CO 6893     528   274     24   04/10/2020 04:22:39 PM Agree Agree
966 966 04/04/2020 MP 8     0   1     0   04/03/2020 04:22:39 PM Agree Agree
967 967 04/10/2020 CO 6365     163   250     24   04/09/2020 04:22:39 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
);