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 new_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
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
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
2615 2615 04/06/2020 NY 72324     17844   3202     2185   04/05/2020 04:22:39 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
19076 19076 02/04/2021 IN 633690     2359 0 11637 11231 406 1546 28.0 02/05/2021 02:54:41 PM Not agree Agree
23099 23099 04/07/2020 NYC 76876     8100   4111     1373   04/07/2020 04:22:39 PM Agree 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
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
18764 18764 02/25/2021 CA 3460326     4965 0 50991     1114 0.0 02/26/2021 03:02:41 PM Not agree Not agree
23115 23115 04/09/2020 NYC 84163     2360   5664     969   04/08/2020 04:22:39 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
11587 11587 01/22/2021 CA 3062068     23024 0 35768     764 0.0 01/23/2021 02:50:13 PM Not agree Not agree
17814 17814 01/28/2021 CA 3186610     16696 0 38961     737 0.0 01/29/2021 02:42:19 PM Not agree Not 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
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
16291 16291 01/27/2021 CA 3169914     16728 0 38224     697 0.0 01/28/2021 02:49:07 PM Not agree Not agree
8635 8635 01/09/2021 CA 2621277     52636 0 29233     695 0.0 01/10/2021 04:10:55 PM Not agree Not agree
18269 18269 01/20/2021 CA 3019371     22403 0 34433     694 0.0 01/21/2021 02:44:32 PM Not agree Not 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
22888 22888 07/27/2020 TX 385923     4267 0 5713     675 0.0 07/28/2020 02:21:07 PM Not agree Not agree
14782 14782 01/16/2021 CA 2900246     40622 0 32960     669 0.0 01/17/2021 03:43:14 PM Not agree Not agree
8618 8618 02/04/2021 CA 3294447     13176 0 42466     655 0.0 02/05/2021 02:54:41 PM Not agree Not agree
18900 18900 01/30/2021 CA 3224374     18427 0 40216     638 0.0 01/31/2021 02:48:12 PM Not agree Not agree
11634 11634 01/15/2021 CA 2859624     42655 0 32291     637 0.0 01/16/2021 02:46:10 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
11727 11727 02/06/2021 CA 3320862     12394 0 43647     623 0.0 02/07/2021 02:46:31 PM Not agree Not agree
13673 13673 01/29/2021 CA 3205947     19337 0 39578     617 0.0 01/30/2021 02:43:11 PM Not agree Not agree
1992 1992 06/28/2020 NYC 216461 211861 4600 222 -70 23077 18477 4600 607 -70.0 06/29/2020 02:37:31 PM Agree Agree
20540 20540 11/14/2020 TX 1138536     49458 2224 19926     606 0.0 02/19/2021 01:40:11 PM Not agree Not agree
6698 6698 01/23/2021 CA 3085040     22972 0 36361     593 0.0 01/24/2021 02:36:49 PM Not agree Not agree
12986 12986 01/13/2021 CA 2781039     33751 0 31102     589 0.0 01/14/2021 03:12:46 PM Not agree Not agree
11505 11505 01/01/2021 CA 2292568     47189 0 25971     585 0.0 01/02/2021 02:50:51 PM Not agree Not agree
4545 4545 04/08/2020 NYC 81803     4927   4695     584   04/07/2020 04:22:39 PM Agree Agree
13347 13347 01/07/2021 CA 2518611     36385 0 28045     583 0.0 01/08/2021 03:56:01 PM Not agree Not agree
1591 1591 05/06/2020 NY 145627     1309 0 6482     575 -77.0 05/07/2020 10:59:02 PM Not agree Not agree
12955 12955 01/21/2021 CA 3039044     19673 0 35004     571 0.0 01/22/2021 02:51:49 PM Not 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
12902 12902 02/05/2021 CA 3308468     14021 0 43024     558 0.0 02/06/2021 04:05:17 PM Not agree Not agree
20161 20161 05/05/2020 PA 50957 50171 786 865 41 3012     554 1.0 05/06/2020 04:23:08 PM Agree Not agree
15838 15838 01/14/2021 CA 2816969     35930 0 31654     552 0.0 01/15/2021 02:46:04 PM Not agree Not 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
5334 5334 01/12/2021 CA 2747288     36487 0 30513     548 0.0 01/13/2021 02:44:58 PM Not agree Not agree
21468 21468 04/11/2020 NYC 98308     5552   6367     547   04/10/2020 04:22:39 PM Agree Agree
5782 5782 02/12/2021 CA 3381615     10059 0 46002     546 0.0 02/13/2021 02:50:08 PM Not 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
15656 15656 02/10/2021 CA 3362981     8390 0 44995     518 0.0 02/11/2021 02:50:55 PM Not agree Not agree
19551 19551 04/18/2020 NYC 128022 126368 1654 5874 1654 12712 8448 4264 513 -45.0 04/18/2020 04:22:39 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
6514 6514 01/08/2021 CA 2568641     50030 0 28538     493 0.0 01/09/2021 03:26:08 PM Not agree Not agree
5812 5812 02/20/2021 CA 3435186     6668 0 48825     481 0.0 02/21/2021 02:57:50 PM Not agree Not agree
15871 15871 01/31/2021 CA 3243348     18974 0 40697     481 0.0 02/01/2021 02:50:29 PM Not agree Not agree
19190 19190 02/03/2021 CA 3281271     10501 0 41811     481 0.0 02/04/2021 02:53:58 PM Not agree Not agree
4650 4650 04/29/2020 PA 44366 43802 564 1102 34 2195     479 2.0 04/30/2020 04:07:01 PM Agree Not agree
22034 22034 01/28/2021 TX 2310952     18220 3228 35639     471 0.0 01/29/2021 02:42:19 PM Not agree Not agree
9803 9803 01/10/2021 CA 2670962     49685 0 29701     468 0.0 01/11/2021 03:01:02 PM Not agree Not agree
2429 2429 01/27/2021 TX 2292732     19613 4541 35168     467 0.0 01/28/2021 02:49:07 PM Not agree Not agree
9579 9579 02/11/2021 CA 3371556     8575 0 45456     461 0.0 02/12/2021 02:56:38 PM Not agree Not agree
9485 9485 01/06/2021 CA 2482226     29892 0 27462     459 0.0 01/07/2021 02:56:59 PM Not agree Not agree
2754 2754 04/14/2020 NYC 110091     3278   6640     458   04/13/2020 04:22:39 PM Agree Agree
8813 8813 04/30/2020 NJ 118653     2388 0 7228 7228 0 458 0.0 02/19/2021 01:38:31 PM Not agree Agree
22664 22664 04/05/2020 NY 54480     4082   1017     451   04/04/2020 04:22:39 PM Not agree Not agree
1213 1213 01/20/2021 TX 2166283     31255 5320 32844     450 0.0 01/21/2021 02:44:32 PM Not agree Not agree
4574 4574 01/21/2021 TX 2188643     22360 3396 33285     441 0.0 01/22/2021 02:51:49 PM Not agree Not agree
3162 3162 02/04/2021 TX 2448393     15283 2987 37727     439 0.0 02/05/2021 02:54:41 PM Not agree Not agree
6763 6763 02/27/2021 CA 3470877     5151 0 51821     439 0.0 02/28/2021 02:48:18 PM Not agree Not agree
13646 13646 02/13/2021 CA 3391036     9421 0 46435     433 0.0 02/14/2021 02:51:00 PM Not agree Not agree
6601 6601 01/17/2021 CA 2942475     42229 0 33392     432 0.0 01/18/2021 02:39:32 PM Not agree Not agree
10397 10397 12/30/2020 CA 2218142     30921 0 24958     432 0.0 12/31/2020 02:55:07 PM Not agree Not agree
7405 7405 01/24/2021 CA 3109151     24111 0 36790     429 0.0 01/25/2021 02:42:40 PM Not agree Not agree
15780 15780 12/31/2020 CA 2245379     27237 0 25386     428 0.0 01/01/2021 02:49:07 PM Not agree Not agree
2614 2614 01/14/2021 TX 2045699     23064 4138 31050     426 0.0 01/15/2021 02:46:04 PM Not agree Not 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
6102 6102 02/02/2021 CA 3270770     12064 0 41330     422 0.0 02/03/2021 02:55:58 PM Not agree Not agree
23300 23300 01/22/2021 TX 2211289     22646 4412 33707     422 0.0 01/23/2021 02:50:13 PM Not agree Not agree
19103 19103 02/19/2021 CA 3428518     6798 0 48344     420 0.0 02/20/2021 02:45:37 PM Not agree Not agree
1796 1796 02/03/2021 TX 2433110     17620 4050 37288     418 0.0 02/04/2021 02:53:58 PM Not agree Not agree
16667 16667 02/18/2021 CA 3421720     5573 0 47924     417 0.0 02/19/2021 03:33:51 PM Not agree Not agree
14327 14327 01/26/2021 CA 3153186     17028 0 37527     409 0.0 01/27/2021 02:53:24 PM Not agree Not agree
13431 13431 02/14/2021 CA 3399878     8842 0 46843     408 0.0 02/15/2021 02:46:24 PM Not agree Not agree
24014 24014 01/23/2021 TX 2228961     17672 3534 34114     407 0.0 01/24/2021 02:36:49 PM Not agree Not agree
19321 19321 01/13/2021 TX 2022635     27343 4783 30624     405 0.0 01/14/2021 03:12:46 PM Not agree Not 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
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
23798 23798 02/05/2021 TX 2462886     14493 3735 38128     401 0.0 02/06/2021 04:05:17 PM Not agree Not agree
6479 6479 02/17/2021 CA 3416147     4090 0 47507     400 0.0 02/18/2021 02:43:57 PM Not agree Not agree
22831 22831 01/15/2021 TX 2072903     27204 5214 31450     400 0.0 01/16/2021 02:46:10 PM Not agree Not agree
11978 11978 04/28/2020 NJ 113857     2669 1 6442 6442 0 398 0.0 02/19/2021 01:38:31 PM Not agree Agree
3490 3490 01/07/2021 TX 1891741     24578 4473 28938     393 0.0 01/08/2021 03:56:01 PM Not agree Not agree
10164 10164 02/26/2021 CA 3465726     5400 0 51382     391 0.0 02/27/2021 02:51:23 PM Not agree Not agree
23383 23383 04/04/2020 NYC 60850     4561   2254     387   04/03/2020 04:22:39 PM Agree Agree
5480 5480 01/02/2021 CA 2345909     53341 0 26357     386 0.0 01/03/2021 02:53:25 PM Not agree Not agree
21926 21926 02/11/2021 TX 2529343     11890 2858 39771     385 0.0 02/12/2021 02:56:38 PM Not agree Not agree
22757 22757 02/10/2021 TX 2517453     12897 2619 39386     385 0.0 02/11/2021 02:50:55 PM Not agree Not agree
18279 18279 05/21/2020 IL 102686 102686 0 2268 0 4607 4607 0 382 0.0 05/22/2020 03:31:45 PM Agree Agree
3935 3935 01/16/2021 TX 2097560     24657 3640 31831     381 0.0 01/17/2021 03:43:14 PM Not agree Not agree
20693 20693 01/09/2021 TX 1938551     23290 3927 29691     381 0.0 01/10/2021 04:10:55 PM Not agree Not agree
15819 15819 12/17/2020 CA 1723362     52281 0 21860     379 0.0 12/18/2020 02:45:01 PM Not agree Not agree
18926 18926 04/21/2020 NJ 92387 92387 0 3581 0 4753 4753 0 376 0.0 04/21/2020 04:22:39 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
2157 2157 01/08/2021 TX 1915261     23520 5736 29310     372 0.0 01/09/2021 03:26:08 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
);