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 state 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
5061 5061 01/23/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
5069 5069 12/10/2020 WY 38223 33203 5020 338 24 299 299 0 0 0.0 12/11/2020 03:06:51 PM Agree Agree
5230 5230 09/13/2020 WY 4346 3679 667 49 5 42 42 0 0 0.0 09/14/2020 02:01:21 PM Agree Agree
5237 5237 10/22/2020 WY 10119 8537 1582 271 39 68 68 0 7 0.0 10/23/2020 01:44:31 PM Agree Agree
5302 5302 11/01/2020 WY 13723 11638 2085 425 63 87 87 0 0 0.0 11/02/2020 02:53:09 PM Agree Agree
5310 5310 10/08/2020 WY 7092 6031 1061 193 28 54 54 0 1 0.0 10/09/2020 01:43:36 PM Agree Agree
5323 5323 02/15/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
5352 5352 02/08/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
5362 5362 12/28/2020 WY 43704 37623 6081 504 48 405 405 0 32 0.0 12/29/2020 02:56:32 PM Agree Agree
5383 5383 05/16/2020 WY 741 559 182 25 7 7 7 0 0 0.0 05/17/2020 03:27:46 PM Agree Agree
5419 5419 04/16/2020 WY 401 296 105 8 0 2 2 0 0 0.0 04/16/2020 04:22:39 PM Agree Agree
5434 5434 02/13/2021 WY 53086 45211 7875 0 0 647 647 0 0 0.0 02/14/2021 02:51:00 PM Agree Agree
5445 5445 01/15/2021 WY 48909 41773 7136 208 63 522 522 0 0 0.0 01/16/2021 02:46:10 PM Agree Agree
5466 5466 11/26/2020 WY 30761 26677 4084 0 0 215 215 0 0 0.0 11/27/2020 03:07:59 PM Agree Agree
5489 5489 03/19/2020 WY 18     2   0     0   03/26/2020 04:22:39 PM Agree Agree
5594 5594 05/18/2020 WY 766 577 189 12 1 10 8 2 2 2.0 05/19/2020 03:45:23 PM Agree Agree
5625 5625 12/26/2020 WY 43146 37129 6017 482 53 373 373 0 0 0.0 12/27/2020 02:44:47 PM Agree Agree
5661 5661 08/23/2020 WY 3579 3046 533 36 -1 37 37 0 0 0.0 08/24/2020 01:54:34 PM Agree Agree
5692 5692 08/28/2020 WY 3763 3196 567 41 11 37 37 0 0 0.0 08/29/2020 01:42:50 PM Agree Agree
5704 5704 05/06/2020 WY 631 479 152 27 0 7 7 0 0 0.0 05/07/2020 10:59:02 PM Agree Agree
5747 5747 01/30/2021 WY 51704 44122 7582 14 8 596 596 0 0 0.0 01/31/2021 02:48:12 PM Agree Agree
5791 5791 01/29/2021 WY 51690 44116 7574 260 28 596 596 0 0 0.0 01/30/2021 02:43:11 PM Agree Agree
5828 5828 07/25/2020 WY 2446 2008 438 41 5 25 25 0 0 0.0 07/26/2020 03:17:16 PM Agree Agree
5857 5857 08/12/2020 WY 3086 2600 486 13 -3 29 29 0 0 0.0 08/13/2020 02:12:28 PM Agree Agree
5906 5906 03/29/2020 WY 87     3   0     0   03/28/2020 04:22:39 PM Agree Agree
5978 5978 03/06/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
6000 6000 07/11/2020 WY 1839 1488 351 49 6 21 21 0 0 0.0 07/12/2020 03:13:57 PM Agree Agree
6018 6018 08/29/2020 WY 3784 3210 574 21 7 37 37 0 0 0.0 08/30/2020 02:49:52 PM Agree Agree
6137 6137 03/24/2020 WY 30     4   0     0   03/26/2020 04:22:39 PM Agree Agree
6167 6167 01/10/2021 WY 46832 40013 6819 113 25 489 489 0 0 0.0 01/11/2021 03:01:02 PM Agree Agree
6185 6185 04/15/2020 WY 393 288 105 -101 4 2 2 0 1 0.0 04/15/2020 04:22:39 PM Agree Agree
6189 6189 08/09/2020 WY 3050 2533 517 37 2 28 28 0 0 0.0 08/10/2020 02:23:35 PM Agree Agree
6302 6302 07/12/2020 WY 1862 1506 356 23 5 21 21 0 0 0.0 07/13/2020 03:19:34 PM Agree Agree
6307 6307 10/01/2020 WY 6083 5170 913 135 11 53 53 0 3 0.0 10/02/2020 01:40:08 PM Agree Agree
6350 6350 01/14/2021 WY 48701 41628 7073 412 67 522 522 0 0 0.0 01/15/2021 02:46:04 PM Agree Agree
6393 6393 07/13/2020 WY 1903 1545 358 41 2 21 21 0 0 0.0 07/14/2020 03:13:07 PM Agree Agree
6431 6431 04/26/2020 WY 502 370 132 11 3 7 7 0 0 0.0 05/25/2020 03:38:40 PM Agree Agree
6488 6488 08/31/2020 WY 3842 3264 578 22 3 37 37 0 0 0.0 09/01/2020 02:09:34 PM Agree Agree
6599 6599 03/11/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
6628 6628 04/03/2020 WY 166     16   0     0   04/03/2020 04:22:39 PM Agree Agree
6685 6685 12/20/2020 WY 41662 35982 5680 174 10 351 351 0 0 0.0 12/21/2020 02:39:53 PM Agree Agree
6734 6734 03/13/2020 WY 1     0   0     0   03/26/2020 04:22:39 PM Agree Agree
6757 6757 06/20/2020 WY 1179 930 249 6 3 20 20 0 0 0.0 06/21/2020 02:32:57 PM Agree Agree
6867 6867 08/22/2020 WY 3543 3009 534 19 4 37 37 0 0 0.0 08/23/2020 02:15:28 PM Agree Agree
7050 7050 09/14/2020 WY 4392 3723 669 46 2 46 46 0 4 0.0 09/15/2020 02:03:59 PM Agree Agree
7090 7090 11/09/2020 WY 18010 15311 2699 700 80 114 114 0 0 0.0 11/10/2020 02:45:45 PM Agree Agree
7130 7130 02/03/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
7152 7152 01/12/2021 WY 48072 41116 6956 677 115 522 522 0 33 0.0 01/13/2021 02:44:58 PM Agree Agree
7196 7196 07/05/2020 WY 1634 1312 322 28 5 20 20 0 0 0.0 07/06/2020 03:16:12 PM Agree Agree
7207 7207 07/06/2020 WY 1675 1349 326 41 4 20 20 0 0 0.0 07/07/2020 02:58:02 PM Agree Agree
7224 7224 11/25/2020 WY 30761 26677 4084 802 100 215 215 0 13 0.0 11/26/2020 02:44:21 PM Agree Agree
7271 7271 08/24/2020 WY 3603 3068 535 24 2 37 37 0 0 0.0 08/25/2020 02:02:54 PM Agree Agree
7308 7308 01/30/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
7328 7328 06/12/2020 WY 1027 811 216 18 0 18 18 0 0 0.0 06/13/2020 05:46:26 PM Agree Agree
7376 7376 04/01/2020 WY 137     17   0     0   03/31/2020 04:22:39 PM Agree Agree
7377 7377 02/17/2021 WY 53450 45438 8012 99 48 662 662 0 0 0.0 02/18/2021 02:43:57 PM Agree Agree
7430 7430 01/03/2021 WY 44875 38440 6435 302 25 438 438 0 0 0.0 01/04/2021 02:55:45 PM Agree Agree
7436 7436 04/22/2020 WY 447 326 121 6 2 6 6 0 0 0.0 04/22/2020 04:22:39 PM Agree Agree
7442 7442 08/02/2020 WY 2808 2333 475 39 3 26 26 0 0 0.0 08/03/2020 02:31:01 PM Agree Agree
7505 7505 04/20/2020 WY 428 317 111 2 -2 2 2 0 0 0.0 04/20/2020 04:22:39 PM Agree Agree
7549 7549 06/05/2020 WY 933 721 212 12 0 17 17 0 0 0.0 06/06/2020 02:31:37 PM Agree Agree
7607 7607 04/04/2020 WY 187     21   0     0   04/03/2020 04:22:39 PM Agree Agree
7670 7670 06/06/2020 WY 939 726 213 6 1 17 17 0 0 0.0 06/07/2020 02:23:35 PM Agree Agree
7706 7706 06/15/2020 WY 1079 856 223 19 4 18 18 0 0 0.0 06/16/2020 02:10:11 PM Agree Agree
7785 7785 12/06/2020 WY 36317 31561 4756 376 65 257 257 0 0 0.0 12/07/2020 02:38:33 PM Agree Agree
7786 7786 01/16/2021 WY 49068 41917 7151 159 15 522 522 0 0 0.0 01/17/2021 03:43:14 PM Agree Agree
7834 7834 10/21/2020 WY 9848 8305 1543 322 87 61 61 0 0 0.0 10/22/2020 01:34:46 PM Agree Agree
7860 7860 05/25/2020 WY 843 644 199 5 -1 12 12 0 0 0.0 05/26/2020 02:23:02 PM Agree Agree
7889 7889 10/25/2020 WY 11041 9396 1645 236 17 68 68 0 0 0.0 10/26/2020 01:41:41 PM Agree Agree
7957 7957 02/01/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
8043 8043 07/23/2020 WY 2347 1923 424 59 0 25 25 0 0 0.0 07/24/2020 02:18:40 PM Agree Agree
8173 8173 02/28/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
8257 8257 08/15/2020 WY 3227 2730 497 44 8 30 30 0 0 0.0 08/16/2020 02:57:14 PM Agree Agree
8305 8305 10/24/2020 WY 10805 9177 1628 260 1 68 68 0 0 0.0 10/25/2020 01:45:35 PM Agree Agree
8329 8329 10/11/2020 WY 7611 6476 1135 156 18 54 54 0 0 0.0 10/12/2020 02:07:08 PM Agree Agree
8358 8358 11/19/2020 WY 26169 22489 3680 894 155 176 176 0 21 0.0 11/20/2020 03:06:16 PM Agree Agree
8369 8369 08/16/2020 WY 3286 2789 497 59 0 30 30 0 0 0.0 08/17/2020 02:26:31 PM Agree Agree
8405 8405 10/30/2020 WY 13028 11020 2008 521 90 87 87 0 0 0.0 10/31/2020 01:30:31 PM Agree Agree
8434 8434 03/16/2020 WY 3     0   0     0   03/26/2020 04:22:39 PM Agree Agree
8460 8460 09/17/2020 WY 4652 3936 716 86 16 49 49 0 3 0.0 09/18/2020 01:48:37 PM Agree Agree
8502 8502 07/08/2020 WY 1740 1404 336 29 3 21 21 0 1 0.0 07/09/2020 03:14:15 PM Agree Agree
8536 8536 12/16/2020 WY 40310 34883 5427 246 75 328 328 0 0 0.0 12/17/2020 02:33:42 PM Agree Agree
8558 8558 05/27/2020 WY 860 653 207 10 5 14 14 0 1 0.0 05/28/2020 03:12:25 PM Agree Agree
8616 8616 07/30/2020 WY 2686 2217 469 58 13 26 26 0 0 0.0 07/31/2020 02:35:06 PM Agree Agree
8628 8628 02/02/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
8681 8681 02/27/2021 WY 54350 46044 8306 0 0 671 671 0 0 0.0 02/28/2021 02:48:18 PM Agree Agree
8682 8682 12/18/2020 WY 41359 35760 5599 766 119 351 351 0 0 0.0 12/19/2020 02:42:31 PM Agree Agree
8697 8697 12/01/2020 WY 33805 29389 4416 500 164 230 230 0 15 0.0 12/02/2020 03:48:48 PM Agree Agree
8716 8716 04/27/2020 WY 520 389 131 18 -1 7 7 0 0 0.0 05/25/2020 03:38:40 PM Agree Agree
8739 8739 05/07/2020 WY 635 483 152 4 0 7 7 0 0 0.0 05/08/2020 09:26:08 PM Agree Agree
8757 8757 06/03/2020 WY 915 703 212 3 1 17 17 0 0 0.0 06/04/2020 03:03:31 PM Agree Agree
8864 8864 10/15/2020 WY 8375 7089 1286 198 23 57 57 0 0 0.0 10/16/2020 01:33:55 PM Agree Agree
8874 8874 06/30/2020 WY 1487 1184 303 37 4 20 20 0 0 0.0 07/01/2020 03:45:16 PM Agree Agree
8908 8908 10/29/2020 WY 12507 10589 1918 361 60 87 87 0 10 0.0 10/30/2020 01:37:23 PM Agree Agree
8939 8939 12/17/2020 WY 40593 35113 5480 283 53 351 351 0 23 0.0 12/18/2020 02:45:01 PM Agree Agree
8947 8947 02/22/2020 WY 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
8978 8978 03/21/2020 WY 24     2   0     0   03/26/2020 04:22:39 PM Agree Agree
8992 8992 11/14/2020 WY 21881 18726 3155 540 57 144 144 0 17 0.0 11/15/2020 03:12:13 PM Agree Agree
9032 9032 10/31/2020 WY 13298 11276 2022 270 14 87 87 0 0 0.0 11/01/2020 03:03:08 PM Agree Agree
9062 9062 07/15/2020 WY 1985 1605 380 34 10 22 22 0 0 0.0 07/16/2020 02:22:21 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
);