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 prob_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
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
24095 24095 05/05/2020 NYC 171723 171723 0 1189 0 19107 13724 5383 198 10.0 05/06/2020 04:23:08 PM Agree Agree
4254 4254 05/07/2020 NYC 174709 174709 0 1421 0 19540 14162 5378 243 19.0 05/08/2020 09:26:08 PM Agree Agree
2281 2281 05/04/2020 NYC 170534 170534 0 0 0 18909 13536 5373 0 0.0 05/05/2020 05:25:08 PM Agree 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
1042 1042 05/06/2020 NYC 173288 173288 0 1565 0 19297 13938 5359 190 -24.0 05/07/2020 10:59:02 PM Agree Agree
4451 4451 05/08/2020 NYC 176086 176086 0 1377 0 19702 14389 5313 162 -65.0 05/09/2020 09:26:08 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
2579 2579 04/29/2020 NYC 159865 159865 0 2152 0 17589 12287 5302 374 -93.0 04/30/2020 04:07:01 PM Agree Agree
327 327 04/30/2020 NYC 162212 162212 0 2347 0 17866 12571 5295 277 -7.0 05/01/2020 09:00:19 PM Agree Agree
1034 1034 05/01/2020 NYC 164505 164505 0 2293 0 18231 13000 5231 365 -64.0 05/02/2020 03:47:19 PM Agree Agree
3978 3978 04/27/2020 NYC 156100 156100 0 2896 0 16936 11708 5228 263 15.0 05/25/2020 03:38:40 PM Agree Agree
22540 22540 04/26/2020 NYC 153204 153204 0 2628 0 16673 11460 5213 403 -96.0 05/25/2020 03:38:40 PM Agree Agree
20435 20435 05/09/2020 NYC 178766 178766 0 2680 0 19931 14753 5178 229 -135.0 05/10/2020 09:26:08 PM Agree Agree
21141 21141 05/12/2020 NYC 184319 184319 0 0 0 20237 15101 5136 0 0.0 05/13/2020 03:26:08 PM Agree Agree
23684 23684 05/11/2020 NYC 184319 184319 0 657 0 20237 15101 5136 181 8.0 05/12/2020 05:26:08 PM Agree Agree
3533 3533 05/10/2020 NYC 183662 183662 0 4896 0 20056 14928 5128 125 -50.0 05/11/2020 09:26:08 PM Agree Agree
1074 1074 05/02/2020 NYC 166883 166883 0 2378 0 18282 13156 5126 51 -105.0 05/03/2020 03:36:03 PM Agree Agree
829 829 04/23/2020 NYC 146139 146139 0 7704 0 15848 10746 5102 852 50.0 05/25/2020 03:38:40 PM Agree Agree
23596 23596 04/24/2020 NYC 146139 146139 0 0 0 15848 10746 5102 0 0.0 05/25/2020 03:38:40 PM Agree Agree
20118 20118 05/13/2020 NYC 185206 185206 0 887 0 20316 15233 5083 79 -53.0 05/14/2020 05:25:44 PM Agree Agree
23174 23174 02/12/2021 NYC 665581 566114 99467 4333 915 28194 23123 5071 98 60.0 02/13/2021 02:50:08 PM Agree Agree
4494 4494 02/28/2021 NYC 729947 616036 113911 3391 754 29409 24351 5058 76 14.0 03/01/2021 03:21:38 PM Agree Agree
21026 21026 05/14/2020 NYC 186293 186293 0 1087 0 20406 15349 5057 90 -26.0 05/15/2020 04:11:22 PM Agree Agree
3165 3165 02/15/2021 NYC 676695 575048 101647 3682 753 28428 23372 5056 87 20.0 02/16/2021 02:53:06 PM Agree Agree
4936 4936 05/15/2020 NYC 187848 187848 0 1555 0 20476 15422 5054 70 -3.0 05/16/2020 03:46:44 PM Agree Agree
19546 19546 02/16/2021 NYC 679835 577020 102815 3140 1168 28493 23439 5054 65 -2.0 02/17/2021 02:51:58 PM Agree 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
20615 20615 04/22/2020 NYC 138435 138435 0 0 0 14996 9944 5052 0 0.0 04/22/2020 04:22:39 PM Agree Agree
3992 3992 02/17/2021 NYC 686363 582821 103542 6528 727 28591 23547 5044 98 -10.0 02/18/2021 02:43:57 PM Agree Agree
21240 21240 02/27/2021 NYC 726556 613399 113157 4153 846 29333 24289 5044 78 15.0 02/28/2021 02:48:18 PM Agree Agree
21109 21109 02/22/2021 NYC 706083 597757 108326 3889 847 28956 23914 5042 67 2.0 02/23/2021 02:51:13 PM Agree Agree
19285 19285 02/23/2021 NYC 709551 600537 109014 3468 688 29026 23985 5041 70 -1.0 02/24/2021 02:56:12 PM Agree Agree
4712 4712 02/21/2021 NYC 702194 594715 107479 3343 981 28889 23849 5040 64 13.0 02/22/2021 02:53:38 PM Agree Agree
19308 19308 02/18/2021 NYC 691292 586674 104618 4929 1076 28688 23651 5037 97 -7.0 02/19/2021 03:33:51 PM Agree Agree
20960 20960 02/08/2021 NYC 648305 552808 95497 4415 827 27857 22820 5037 88 23.0 02/09/2021 03:24:29 PM Agree Agree
3700 3700 02/14/2021 NYC 673013 572119 100894 3707 721 28341 23305 5036 71 12.0 02/15/2021 02:46:24 PM Agree Agree
1115 1115 02/19/2021 NYC 695496 589801 105695 4204 1077 28749 23718 5031 61 -6.0 02/20/2021 02:45:37 PM Agree Agree
3697 3697 02/26/2021 NYC 722403 610092 112311 3860 1030 29255 24226 5029 80 3.0 02/27/2021 02:51:23 PM Agree Agree
533 533 02/20/2021 NYC 698851 592353 106498 3355 803 28825 23798 5027 76 -4.0 02/21/2021 02:57:50 PM Agree Agree
22110 22110 02/10/2021 NYC 656739 559220 97519 4983 1298 28022 22995 5027 73 2.0 02/11/2021 02:50:55 PM Agree Agree
23015 23015 02/25/2021 NYC 718543 607262 111281 4615 1178 29175 24149 5026 85 2.0 02/26/2021 03:02:41 PM Agree Agree
23969 23969 02/09/2021 NYC 651756 555535 96221 3451 724 27949 22924 5025 92 -12.0 02/10/2021 02:52:16 PM Agree Agree
20893 20893 02/13/2021 NYC 669306 569133 100173 3725 706 28270 23246 5024 76 -47.0 02/14/2021 02:51:00 PM Agree Agree
21589 21589 02/24/2021 NYC 713928 603825 110103 4377 1089 29090 24066 5024 64 -17.0 02/25/2021 02:54:32 PM Agree Agree
2780 2780 02/05/2021 NYC 634339 541658 92681 5447 1325 27610 22587 5023 104 9.0 02/06/2021 04:05:17 PM Agree Agree
3173 3173 02/06/2021 NYC 638804 545007 93797 4465 1116 27706 22687 5019 96 -4.0 02/07/2021 02:46:31 PM Agree Agree
20180 20180 02/04/2021 NYC 628892 537536 91356 3871 614 27506 22492 5014 77 1.0 02/05/2021 02:54:41 PM Agree Agree
21422 21422 02/07/2021 NYC 643890 549220 94670 5086 873 27769 22755 5014 63 -5.0 02/08/2021 02:53:12 PM Agree Agree
4379 4379 02/03/2021 NYC 625021 534279 90742 3331 608 27429 22416 5013 74 7.0 02/04/2021 02:53:58 PM Agree Agree
20136 20136 02/11/2021 NYC 661248 562696 98552 4509 1033 28096 23085 5011 74 -16.0 02/12/2021 02:56:38 PM Agree Agree
22978 22978 02/02/2021 NYC 621690 531556 90134 2939 989 27355 22349 5006 56 3.0 02/03/2021 02:55:58 PM Agree Agree
1640 1640 02/01/2021 NYC 618751 529606 89145 4225 902 27299 22296 5003 73 8.0 02/02/2021 02:51:51 PM Agree Agree
179 179 01/30/2021 NYC 610313 523526 86787 4836 502 27140 22143 4997 97 16.0 01/31/2021 02:48:12 PM Agree Agree
1681 1681 01/31/2021 NYC 614526 526283 88243 4213 1456 27226 22231 4995 86 -2.0 02/01/2021 09:17:04 AM Agree Agree
4682 4682 01/29/2021 NYC 605477 519192 86285 6292 1028 27043 22062 4981 90 0.0 01/30/2021 02:43:11 PM Agree Agree
21701 21701 01/28/2021 NYC 599185 513928 85257 6714 1316 26953 21972 4981 95 10.0 01/29/2021 02:42:19 PM Agree Agree
1623 1623 01/25/2021 NYC 582175 501017 81158 4587 452 26720 21746 4974 72 25.0 01/26/2021 02:46:01 PM Agree Agree
11 11 01/27/2021 NYC 592471 508530 83941 6182 1473 26858 21887 4971 93 26.0 01/28/2021 02:49:07 PM Agree Agree
3811 3811 01/24/2021 NYC 577588 496882 80706 5800 2251 26648 21699 4949 90 22.0 01/25/2021 02:42:40 PM Agree Agree
21540 21540 01/26/2021 NYC 586289 503821 82468 4114 1310 26765 21820 4945 45 -29.0 01/27/2021 02:53:24 PM Agree Agree
21963 21963 01/23/2021 NYC 571788 493333 78455 5450 154 26558 21631 4927 92 23.0 01/24/2021 02:36:49 PM Agree Agree
22547 22547 01/21/2021 NYC 560462 483060 77402 7112 1974 26398 21492 4906 64 6.0 01/22/2021 02:51:49 PM Agree Agree
23392 23392 01/22/2021 NYC 566338 488037 78301 5876 899 26466 21562 4904 68 -2.0 01/23/2021 02:50:13 PM Agree Agree
19327 19327 01/19/2021 NYC 548160 473475 74685 4701 867 26249 21346 4903 86 17.0 01/20/2021 02:44:03 PM Agree Agree
21426 21426 01/20/2021 NYC 553350 477922 75428 5190 743 26334 21434 4900 85 -3.0 01/21/2021 02:44:32 PM Agree Agree
4468 4468 01/18/2021 NYC 543459 469641 73818 5566 1252 26163 21277 4886 57 8.0 01/19/2021 02:37:00 PM Agree Agree
22038 22038 01/17/2021 NYC 537893 465327 72566 6664 1864 26106 21228 4878 67 5.0 01/18/2021 02:39:32 PM Agree Agree
20162 20162 01/16/2021 NYC 531229 460527 70702 5320 689 26039 21166 4873 68 11.0 01/17/2021 03:43:14 PM Agree Agree
22010 22010 01/14/2021 NYC 519438 450662 68776 7485 1095 25909 21038 4871 74 18.0 01/15/2021 02:46:04 PM Agree Agree
3467 3467 01/11/2021 NYC 499927 434950 64977 5643 338 25699 20834 4865 63 5.0 01/12/2021 02:48:35 PM 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
21031 21031 01/15/2021 NYC 525909 455896 70013 6471 1237 25971 21109 4862 62 -9.0 01/16/2021 02:46:10 PM Agree Agree
4461 4461 01/10/2021 NYC 494284 429645 64639 4746 781 25636 20776 4860 72 19.0 01/11/2021 03:01:02 PM Agree Agree
21882 21882 01/13/2021 NYC 511953 444272 67681 5576 1104 25835 20982 4853 93 12.0 01/14/2021 03:12:46 PM Agree Agree
22296 22296 01/08/2021 NYC 482770 420621 62149 6725 2122 25508 20661 4847 55 9.0 01/09/2021 03:26:08 PM Agree Agree
33 33 01/05/2021 NYC 462668 405805 56863 5299 1171 25363 20521 4842 54 16.0 01/06/2021 02:58:26 PM Agree Agree
23490 23490 01/06/2021 NYC 468925 410754 58171 6257 1308 25416 20574 4842 53 0.0 01/07/2021 02:56:59 PM Agree Agree
4914 4914 01/12/2021 NYC 506377 439800 66577 6450 1600 25742 20901 4841 43 -24.0 01/13/2021 02:44:58 PM Agree Agree
23799 23799 01/09/2021 NYC 489538 425680 63858 6768 1709 25564 20723 4841 56 -6.0 01/10/2021 04:10:55 PM Agree Agree
1557 1557 01/07/2021 NYC 476045 416018 60027 7120 1856 25453 20615 4838 37 -4.0 01/08/2021 03:56:01 PM Agree Agree
1180 1180 05/17/2020 NYC 190408 190408 0 -4832 -4832 20720 15888 4832 0 0.0 05/18/2020 04:01:54 PM Agree Agree
1470 1470 05/16/2020 NYC 195240 190408 4832 7392 4832 20720 15888 4832 244 -222.0 05/17/2020 03:27:46 PM Agree Agree
2833 2833 01/03/2021 NYC 452796 398432 54364 5152 954 25286 20459 4827 42 15.0 01/04/2021 02:55:45 PM Agree Agree
3045 3045 01/04/2021 NYC 457369 401677 55692 4573 1328 25309 20483 4826 23 -1.0 01/05/2021 03:00:42 PM Agree Agree
607 607 05/18/2020 NYC 191073 191073 0 665 0 20806 15983 4823 86 -9.0 05/19/2020 03:45:23 PM Agree Agree
515 515 01/02/2021 NYC 447644 394234 53410 3809 1122 25244 20432 4812 33 8.0 01/03/2021 02:53:25 PM Agree Agree
22970 22970 12/30/2020 NYC 432179 381935 50244 4174 634 25144 20332 4812 45 8.0 12/31/2020 02:55:07 PM Agree Agree
2644 2644 12/31/2020 NYC 438270 386824 51446 6091 1202 25187 20382 4805 43 -7.0 01/01/2021 02:49:07 PM Agree Agree
121 121 01/01/2021 NYC 443835 391547 52288 5565 842 25211 20407 4804 24 -1.0 01/02/2021 02:50:51 PM Agree Agree
1208 1208 12/29/2020 NYC 428005 378395 49610 4233 952 25099 20295 4804 42 4.0 12/30/2020 02:56:20 PM Agree Agree
301 301 12/28/2020 NYC 423772 375114 48658 4811 1062 25057 20257 4800 49 6.0 12/29/2020 02:56:32 PM Agree Agree
3937 3937 12/27/2020 NYC 418961 371365 47596 4562 1074 25008 20214 4794 35 2.0 12/28/2020 02:42:49 PM Agree Agree
4443 4443 12/26/2020 NYC 414399 367877 46522 3116 712 24973 20181 4792 42 12.0 12/27/2020 02:44:47 PM Agree Agree
3966 3966 05/19/2020 NYC 197155 192374 4781 6082 4781 20934 16153 4781 128 -42.0 05/20/2020 03:28:26 PM Agree Agree
22307 22307 12/25/2020 NYC 411283 365473 45810 4235 905 24931 20151 4780 42 13.0 12/26/2020 02:34:18 PM Agree Agree
4096 4096 05/21/2020 NYC 192840 192840 0 -4771 -4771 21003 16232 4771 0 0.0 05/22/2020 03:31:45 PM Agree Agree
4507 4507 05/20/2020 NYC 197611 192840 4771 456 -10 21003 16232 4771 69 -10.0 05/21/2020 03:41:38 PM Agree Agree
23735 23735 12/24/2020 NYC 407048 362143 44905 4441 1201 24889 20122 4767 46 6.0 12/25/2020 02:25:34 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
);