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_death descending

✎ 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
1799 1799 05/14/2020 MA 82182 82182 0 1685 0 5649 167 5482 334 5482.0 05/15/2020 04:11:22 PM Agree Agree
1758 1758 04/15/2020 NYC 116073 116073 0 5982 0 11225 7166 4059 4585 4059.0 04/15/2020 04:22:39 PM Agree Agree
21066 21066 12/08/2020 IA 246811     1526 709 2919     201 2919.0 12/09/2020 02:45:40 PM Not agree Not agree
8686 8686 06/25/2020 NJ 171064     493 31 14872 13018 1854 1877 1854.0 02/19/2021 01:38:31 PM Not agree Agree
5184 5184 05/29/2020 CT 41762 39756 2006 203 2006 3868 3020 848 42 848.0 05/30/2020 03:47:59 PM Agree Agree
9358 9358 05/09/2020 CT 32984 31013 1971 573 1971 2932 2161 771 58 771.0 05/10/2020 09:26:08 PM Agree Agree
14015 14015 05/07/2020 CT 31784 29908 1876 789 1876 2797 2062 735 79 735.0 05/08/2020 09:26:08 PM Agree Agree
1260 1260 02/12/2021 OH 934742 807727 127015 3305 1549 15136 13005 2131 2559 658.0 02/13/2021 02:50:08 PM Agree Agree
15185 15185 05/03/2020 CT 29312 27552 1760 25 1760 2495 1853 642 59 642.0 05/04/2020 10:49:24 PM Agree Agree
9426 9426 04/28/2020 CT 26312 24844 1468 315 1468 2089 1566 523 77 523.0 04/29/2020 06:12:08 PM Agree Agree
14 14 11/12/2020 GA 416217 379873 36344 2802 265 8881 8403 478 548 478.0 11/13/2020 09:54:34 AM Agree Agree
13634 13634 04/26/2020 CT 25269 23853 1416 687 1416 1924 1448 476 62 476.0 05/25/2020 03:38:40 PM Agree Agree
20289 20289 11/10/2020 GA 411183 375672 35511 4279 2276 8730 8264 466 507 466.0 11/11/2020 10:15:25 AM Agree Agree
23471 23471 04/20/2020 NYC 134874 134874 0 5086 0 14427 9562 4865 1187 436.0 04/20/2020 04:22:39 PM Agree Agree
22523 22523 04/17/2020 NYC 122148 122148 0 4583 0 12199 7890 4309 722 395.0 04/17/2020 04:22:39 PM Agree Agree
20384 20384 05/22/2020 PA 66983 65209 1774 725 67 5096     678 348.0 05/23/2020 05:58:16 PM Agree Not agree
2711 2711 02/13/2021 OH 937541 809589 127952 2799 937 16340 13898 2442 1204 311.0 02/14/2021 02:51:00 PM Agree Agree
4163 4163 04/21/2020 PA 34528 33923 605 1296 315 1564     360 285.0 04/21/2020 04:22:39 PM Agree Not agree
21076 21076 01/31/2021 IA 319247     691 66 4901     250 250.0 02/01/2021 02:50:29 PM Not agree Not agree
21945 21945 05/03/2020 NYC 170534 170534 0 3651 0 18909 13536 5373 627 247.0 05/04/2020 10:49:24 PM Agree Agree
2148 2148 01/20/2021 PA 783170 689913 93257 5984 1616 19868     401 246.0 01/21/2021 02:44:32 PM Agree Not agree
3913 3913 06/23/2020 PA 83191 80810 2381 1005 54 6518     92 244.0 06/24/2020 03:03:27 PM Agree Not agree
4981 4981 01/14/2021 PA 748564 661700 86864 7175 1606 18742     313 242.0 01/15/2021 02:46:04 PM Agree Not agree
1929 1929 08/03/2020 PA 114155 110970 3185 565 11 7209     0 239.0 08/04/2020 02:09:35 PM Agree Not agree
11333 11333 06/05/2020 MI 63539 58525 5014 5298 5014 5855 5616 239 270 239.0 06/06/2020 02:31:37 PM Agree Agree
3398 3398 12/31/2020 PA 640325 574364 65961 8992 1909 15978     306 237.0 01/01/2021 02:49:07 PM Agree Not agree
7223 7223 08/06/2020 AZ 183647 182408 1239 1444 1239 4002 3786 216 70 216.0 08/07/2020 11:57:59 PM Agree Agree
1707 1707 04/25/2020 NYC 150576 150576 0 4437 0 16270 10961 5309 422 207.0 05/25/2020 03:38:40 PM Agree Agree
22418 22418 12/16/2020 PA 519369 473194 46175 10049 1989 13168     278 205.0 12/17/2020 02:33:42 PM Agree Not agree
8769 8769 04/16/2020 CT 15884 15884 0 1129 0 971 774 197 103 197.0 04/16/2020 04:22:39 PM Agree Agree
23124 23124 01/09/2021 PA 713310 632935 80375 10045 1798 17667     273 192.0 01/10/2021 04:10:55 PM Agree Not agree
4672 4672 12/23/2020 PA 581156 525803 55353 9605 1661 14442     230 190.0 12/24/2020 02:31:20 PM Agree Not agree
3717 3717 12/10/2020 PA 457289 422039 35250 11972 906 12010     248 189.0 12/11/2020 03:06:51 PM Agree Not agree
1023 1023 04/21/2020 NYC 138435 138435 0 3561 0 14996 9944 5052 569 187.0 04/21/2020 04:22:39 PM Agree Agree
794 794 01/07/2021 PA 693087 616519 76568 9698 3084 17179     265 182.0 01/08/2021 03:56:01 PM Agree Not agree
18223 18223 04/19/2020 CT 17962 17962 0 412 0 1127 946 181 41 181.0 04/19/2020 04:22:39 PM Agree Agree
18102 18102 09/29/2020 NJ 209774     568 112 16297 14326 1971 190 180.0 02/19/2021 01:38:31 PM Not agree Agree
14549 14549 06/08/2020 IL 129139 128415 724 1382 724 6102 5924 178 198 178.0 06/09/2020 04:49:08 PM Agree Agree
3856 3856 01/27/2021 PA 818369 718386 99983 5874 1731 21105     222 177.0 01/28/2021 02:49:07 PM Agree Not agree
4908 4908 01/23/2021 PA 799957 703908 96049 5785 1048 20526     205 177.0 01/24/2021 02:36:49 PM Agree Not agree
4951 4951 12/19/2020 PA 548489 498332 50157 9834 1864 13825     217 171.0 12/20/2020 02:32:33 PM Agree Not agree
20573 20573 01/21/2021 PA 788834 694492 94342 5664 1085 20128     260 170.0 01/22/2021 02:51:49 PM Agree Not agree
22338 22338 04/28/2020 NYC 157713 157713 0 1613 0 17215 11820 5395 279 167.0 04/29/2020 06:12:08 PM Agree Agree
16370 16370 04/20/2020 CT 19815 18495 1320 1853 1320 1331 984 347 204 166.0 04/20/2020 04:22:39 PM Agree Agree
3980 3980 12/15/2020 PA 509320 465134 44186 9556 2571 12890     270 165.0 12/16/2020 02:28:57 PM Agree Not agree
23916 23916 04/19/2020 NYC 129788 129788 0 1766 -1654 13240 8811 4429 528 165.0 04/19/2020 04:22:39 PM Agree Agree
93 93 01/08/2021 PA 703265 624688 78577 10178 2009 17394     215 155.0 01/09/2021 03:26:08 PM Agree Not agree
2837 2837 12/12/2020 PA 481118 440538 40580 11084 2569 12436     201 155.0 12/13/2020 02:31:19 PM Agree Not agree
595 595 01/12/2021 PA 733429 650116 83313 7275 1616 18080     227 154.0 01/13/2021 02:44:58 PM Agree Not agree
400 400 01/15/2021 PA 754611 666521 88090 6047 1226 18957     215 153.0 01/16/2021 02:46:10 PM Agree Not agree
23027 23027 09/16/2020 AR 72219     862 256 1157     154 147.0 09/17/2020 01:45:45 PM Not agree Not agree
20966 20966 12/02/2020 PA 375431 348043 27388 8291 896 10757     194 145.0 12/03/2020 03:21:08 PM Agree Not agree
22473 22473 06/01/2020 MA 100805 97291 3514 3840 3514 7035 6894 141 189 141.0 06/02/2020 02:16:17 PM Agree Agree
990 990 02/11/2021 OH 931437 805971 125466 2806 720 12577 11104 1473 721 139.0 02/12/2021 02:56:38 PM Agree Agree
3138 3138 06/04/2020 MA 102063 98376 3687 471 59 7201 7062 139 189 139.0 06/05/2020 03:17:07 PM Agree Agree
3012 3012 02/04/2021 PA 856986 744075 112911 3370 912 22101     146 129.0 02/05/2021 02:54:41 PM Agree Not agree
21682 21682 01/26/2021 PA 812495 714243 98252 4628 841 20883     219 127.0 01/27/2021 02:53:24 PM Agree Not agree
521 521 02/09/2021 PA 876913 759466 117447 4088 1147 22620     149 118.0 02/10/2021 02:52:16 PM Agree Not agree
23397 23397 12/27/2020 PA 610025 551742 58283 4884 267 15010     127 117.0 12/28/2020 02:42:49 PM Agree Not agree
22507 22507 12/01/2020 PA 367140 340648 26492 5662 936 10563     180 116.0 12/02/2020 03:48:48 PM Agree Not agree
4578 4578 01/30/2021 PA 839239 730182 109057 5191 1040 21602     140 113.0 01/31/2021 02:48:12 PM Agree Not agree
20674 20674 12/22/2020 PA 571551 517859 53692 7962 2088 14212     231 113.0 12/23/2020 02:36:58 PM Agree Not agree
23251 23251 01/17/2021 PA 767800 677774 90026 6023 688 19310     122 108.0 01/18/2021 02:39:32 PM Agree Not agree
22967 22967 10/12/2020 PA 173304 167068 6236 1088 101 8368     18 107.0 10/13/2020 01:29:38 PM Agree Not agree
1174 1174 12/09/2020 IA 249276     2465 680 3021     102 102.0 12/10/2020 02:50:16 PM Not agree Not agree
12852 12852 02/10/2021 AL 476067 373601 102466 1401 426 8888 6990 1898 309 102.0 02/11/2021 02:50:55 PM Agree Agree
24102 24102 12/13/2020 PA 491802 450377 41425 10684 845 12565     129 101.0 12/14/2020 02:36:45 PM Agree Not agree
1524 1524 12/10/2020 IA 251386     2110 404 3120     99 99.0 12/11/2020 03:06:51 PM Not agree Not agree
4493 4493 12/17/2020 IA 262558     1779 389 3451     97 97.0 12/18/2020 02:45:01 PM Not agree Not agree
12172 12172 01/27/2021 AL 449086 354967 94119 3177 1128 7172 5817 1355 276 97.0 01/28/2021 02:49:07 PM Agree Agree
22234 22234 12/05/2020 PA 411484 380193 31291 12884 2202 11262     149 97.0 12/06/2020 02:51:16 PM Agree Not agree
22450 22450 04/24/2020 CO 12184 10995 1189 1002 215 672 551 121 121 96.0 05/25/2020 03:38:40 PM Agree Agree
20809 20809 02/26/2021 PA 926336 797310 129026 3346 624 23937     69 95.0 02/27/2021 02:51:23 PM Agree Not agree
18122 18122 02/03/2021 AL 465056 365818 99238 2118 698 8203 6529 1674 309 94.0 02/04/2021 02:53:58 PM Agree Agree
22230 22230 02/11/2021 PA 884269 764748 119521 3978 935 22860     115 94.0 02/12/2021 02:56:38 PM Agree Not agree
20124 20124 02/05/2021 PA 861674 746838 114836 4688 1925 22239     138 93.0 02/06/2021 04:05:17 PM Agree Not agree
4528 4528 11/19/2020 PA 288978 270323 18655 7126 781 9581     116 91.0 11/20/2020 03:06:16 PM Agree Not agree
10467 10467 07/08/2020 NJ 175339     202 41 15423 13476 1947 142 91.0 02/19/2021 01:38:31 PM Not agree Agree
19662 19662 02/13/2021 PA 892344 771452 120892 4088 721 23072     113 91.0 02/14/2021 02:51:00 PM Agree Not agree
1974 1974 01/10/2021 PA 720816 639513 81303 7506 928 17770     103 90.0 01/11/2021 03:01:02 PM Agree Not agree
7651 7651 04/25/2020 IN 14395     715 0 872 785 87 131 87.0 05/25/2020 03:38:40 PM Not agree Agree
8640 8640 01/12/2021 AL 407848 325076 82772 3848 1817 5573 4732 841 226 87.0 01/13/2021 02:44:58 PM Agree Agree
19219 19219 01/12/2021 IA 298406     1105 460 4222     83 83.0 01/13/2021 02:44:58 PM Not agree Not agree
1784 1784 11/26/2020 PA 336254 312399 23855 8425 1087 10213     118 82.0 11/27/2020 03:07:59 PM Agree Not agree
3870 3870 12/19/2020 IA 266236     1478 324 3533     82 82.0 12/20/2020 02:32:33 PM Not agree Not agree
22145 22145 11/20/2020 PA 295786 276455 19331 6808 676 9689     108 82.0 11/21/2020 02:59:41 PM Agree Not agree
1945 1945 05/04/2020 NY 143302     1218 0 5808     157 77.0 05/05/2020 05:25:08 PM Not agree Not agree
4276 4276 12/11/2020 IA 253601     2215 679 3197     77 77.0 12/12/2020 02:59:37 PM Not agree Not agree
20878 20878 01/24/2021 PA 803933 707355 96578 3976 529 20609     83 77.0 01/25/2021 02:42:40 PM Agree Not agree
12586 12586 12/30/2020 NJ 522259     5287 645 18952 16931 2021 175 76.0 02/19/2021 01:38:31 PM Not agree Agree
21786 21786 07/05/2020 PA 90304 87705 2599 450 12 6754     5 75.0 07/06/2020 03:16:12 PM Agree Not agree
914 914 01/30/2021 IA 318556     867 214 4651     74 74.0 01/31/2021 02:48:12 PM Not agree Not agree
19385 19385 12/20/2020 PA 555844 505347 50497 7355 340 13924     99 74.0 12/21/2020 02:39:53 PM Agree Not agree
22864 22864 11/08/2020 KS 97633 87552 10081 0 857 1166     0 74.0 11/09/2020 02:38:54 PM Agree N/A
19554 19554 02/20/2021 PA 911591 786131 125460 2818 593 23570     90 72.0 02/21/2021 02:57:50 PM Agree Not agree
4476 4476 12/25/2020 PA 597560 539519 58041 7174 594 14857     139 71.0 12/26/2020 02:34:18 PM Agree Not agree
22887 22887 12/24/2020 IA 272839     1531 428 3739     71 71.0 12/25/2020 02:25:34 PM Not agree Not agree
23842 23842 05/27/2020 PA 70042 68104 1938 625 36 5373     108 71.0 05/28/2020 03:12:25 PM Agree Not agree
11417 11417 01/14/2021 AL 414583 329731 84852 3588 985 5945 4977 968 185 70.0 01/15/2021 02:46:04 PM Agree Agree
4891 4891 12/31/2020 IA 280669     1710 392 3891     69 69.0 01/01/2021 02:49:07 PM Not agree Not 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
);