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

✎ 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
5 5 06/28/2020 PA 85988 83529 2459 492 13 6614     8 4.0 06/29/2020 02:37:31 PM Agree Not agree
6 6 12/02/2020 NY 346492     5775 0 10117     56 0.0 12/03/2020 03:21:08 PM Not agree Not agree
7 7 01/29/2020 MA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
8 8 09/26/2020 PW 0     0 0 0     0 0.0 09/27/2020 01:39:49 PM    
9 9 03/07/2020 GA 11 11 0 3 0 0     0   03/26/2020 12:22:39 PM Agree Agree
13 13 06/07/2020 PW 0     0 0 0     0 0.0 06/08/2020 02:55:08 PM    
15 15 10/03/2020 HI 12768     69 0 142     0 0.0 10/04/2020 09:35:23 AM Not agree Not agree
16 16 11/21/2020 IA 207675     3700 536 2160     25 0.0 11/22/2020 03:02:23 PM Not agree Not agree
18 18 02/29/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
20 20 05/26/2020 KS 9218 9218 0 0 0 188     0 0.0 05/27/2020 03:37:59 PM Agree N/A
21 21 10/11/2020 PW 0     0 0 0     0 0.0 10/12/2020 02:07:08 PM    
24 24 11/03/2020 NY 248091     1519 0 9290     8 0.0 11/04/2020 03:03:00 PM Not agree Not agree
25 25 01/12/2021 AS 3     0 0 0     0 0.0 01/13/2021 02:44:58 PM    
26 26 08/31/2020 KS 42612 41425 1187 1564 0 446     3 0.0 09/01/2020 02:09:34 PM Agree N/A
27 27 12/29/2020 TX 1715978     32552 4532 26762     241 0.0 12/30/2020 02:56:20 PM Not agree Not agree
29 29 03/09/2020 NYC 17     5   0     0   03/26/2020 04:22:39 PM Agree Agree
32 32 10/28/2020 AR 108640     961 271 1875     18 0.0 10/29/2020 02:11:33 PM Not agree Not agree
35 35 08/21/2020 KS 36856 35895 961 966 13 419     8 0.0 08/22/2020 02:21:09 PM Agree N/A
36 36 11/27/2020 KS 153021 132785 20236 5224 588 1529     26 5.0 11/28/2020 02:46:47 PM Agree N/A
37 37 01/29/2020 HI 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
38 38 12/28/2020 AS 3     0 0 0     0 0.0 12/29/2020 02:56:32 PM    
39 39 06/23/2020 PW 0     0 0 0     0 0.0 06/24/2020 03:03:27 PM    
42 42 07/16/2020 WV 4657 4535 122 100 4 99     1 0.0 07/17/2020 02:31:01 PM Agree Not agree
43 43 01/02/2021 AR 231442     2000 403 3729     18 3.0 01/03/2021 02:53:25 PM Not agree Not agree
46 46 05/03/2020 PW 0     0 0 0     0 0.0 05/04/2020 10:49:24 PM    
48 48 10/07/2020 PA 166552 160772 5780 1309 127 8272     28 -16.0 10/08/2020 01:56:57 PM Agree Not agree
49 49 06/13/2020 PA 78462 76237 2225 0 0 6211     0 0.0 06/14/2020 02:19:43 PM Agree Not agree
50 50 05/24/2020 NY 163392     732 0 7830     68 0.0 05/25/2020 02:12:49 PM Not agree Not agree
51 51 08/17/2020 AR 53077     412 0 603     4 0.0 08/18/2020 02:26:55 PM Not agree Not agree
52 52 02/14/2021 AR 313028     466 33 5265     13 2.0 02/15/2021 02:46:24 PM Not agree Not agree
53 53 01/11/2021 WV 102282 82440 19842 1070 211 1594     12 3.0 01/12/2021 02:48:35 PM Agree Not agree
55 55 02/26/2021 KS 293663 238336 55327 826 223 4735     11 1.0 02/27/2021 02:51:23 PM Agree N/A
57 57 04/04/2020 OH 3739     427   102     11   04/03/2020 04:22:39 PM Agree Agree
59 59 03/22/2020 PA 479     108   2     0   03/26/2020 04:22:39 PM Agree Not agree
61 61 11/06/2020 PW 0     0 0 0     0 0.0 11/07/2020 02:45:17 PM    
62 62 04/14/2020 AK 285     8   9     1   04/13/2020 04:22:39 PM N/A N/A
64 64 07/30/2020 KS 26870 26327 543 0 0 349     0 0.0 07/31/2020 02:35:06 PM Agree N/A
67 67 02/06/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
68 68 06/22/2020 TX 114881     3280 0 2192     10 0.0 06/23/2020 02:28:19 PM Not agree Not agree
69 69 02/11/2020 NYC 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
70 70 02/18/2020 AR 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
71 71 09/16/2020 FL 663234     2288 382 12939     152 3.0 09/17/2020 01:45:45 PM Not agree Not agree
74 74 04/06/2020 MA 13837     1337   260     29   04/05/2020 04:22:39 PM Agree Agree
76 76 12/15/2020 AK 40438     278 0 178     3 0.0 12/16/2020 02:28:57 PM N/A N/A
77 77 12/06/2020 AS 3     0 0 0     0 0.0 12/07/2020 02:38:33 PM    
78 78 11/03/2020 PA 214871 204363 10508 2875 276 8855     32 9.0 11/04/2020 03:03:00 PM Agree Not agree
83 83 07/24/2020 PA 106625 103632 2993 1054 24 7114     13 6.0 07/25/2020 05:40:06 PM Agree Not agree
84 84 05/07/2020 AK 374     2 0 10     0 0.0 05/08/2020 09:26:08 PM N/A N/A
87 87 09/21/2020 PA 150812 146281 4531 234 10 8004     48 50.0 09/22/2020 01:51:57 PM Agree Not agree
89 89 06/27/2020 KS 13538 13227 311 0 0 264     0 0.0 06/28/2020 02:59:02 PM Agree N/A
90 90 05/19/2020 AK 399     0 0 10     0 0.0 05/20/2020 03:28:26 PM N/A N/A
91 91 04/19/2020 HI 576     4 0 10     1 0.0 04/19/2020 12:22:39 PM Not agree Not agree
92 92 03/08/2020 PR 0     0   0     0   03/26/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
94 94 01/23/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
95 95 08/14/2020 AR 52392     626 0 587     5 0.0 08/15/2020 02:02:05 PM Not agree Not agree
98 98 11/29/2020 KS 153021 132785 20236 0 0 1529     0 0.0 11/30/2020 02:51:40 PM Agree N/A
100 100 09/30/2020 FL 698051     1880 264 14317     174 2.0 10/01/2020 01:42:11 PM Not agree Not agree
102 102 09/22/2020 AK 6950     44 0 45     0 0.0 09/23/2020 01:51:22 PM N/A N/A
103 103 02/18/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
105 105 04/18/2020 OK 2570     105   139     3   04/18/2020 04:22:39 PM Agree Agree
106 106 10/03/2020 FL 705938     2726 414 14628     74 2.0 10/04/2020 01:35:23 PM Not agree Not agree
108 108 12/25/2020 HI 20428     119 0 283     0 0.0 12/26/2020 02:34:18 PM Not agree Not agree
110 110 02/10/2020 MA 1     0   0     0   03/26/2020 04:22:39 PM Agree Agree
111 111 10/22/2020 NY 233558     1098 0 9177     11 0.0 10/23/2020 01:44:31 PM Not agree Not agree
113 113 01/24/2021 AK 51610     165 0 257     0 0.0 01/25/2021 02:42:40 PM N/A N/A
114 114 11/19/2020 HI 16677     100 0 222     0 0.0 11/20/2020 03:06:16 PM Not agree Not agree
116 116 05/04/2020 PA 50092 49347 745 825 30 2458     14 0.0 05/05/2020 05:25:08 PM Agree Not agree
117 117 01/31/2020 OK 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
118 118 04/06/2020 NYC 68776     3821   2738     266   04/05/2020 04:22:39 PM Agree Agree
119 119 10/26/2020 HI 14653     35 0 211     0 0.0 10/27/2020 01:47:53 PM Not agree Not agree
122 122 10/06/2020 FL 711358     2202 471 14767     55 2.0 10/07/2020 01:45:01 PM Not agree Not agree
123 123 03/16/2020 OH 50     13   0     0   03/26/2020 04:22:39 PM Agree Agree
124 124 11/06/2020 WV 27087 24672 2415 540 67 487     7 0.0 11/07/2020 02:45:17 PM Agree Not agree
125 125 10/26/2020 WV 22223 20814 1409 317 70 424     1 0.0 10/27/2020 01:47:53 PM Agree Not agree
126 126 03/14/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
127 127 11/20/2020 TX 1168925     13598 1783 20296     183 0.0 02/19/2021 01:40:11 PM Not agree Not agree
129 129 03/13/2020 PA 29     6   0     0   03/26/2020 04:22:39 PM Agree Not agree
130 130 07/02/2020 AK 1017     39 0 14     0 0.0 07/03/2020 03:01:33 PM N/A N/A
131 131 12/01/2020 FL 991910     8540 5001 18679     82 16.0 12/02/2020 03:48:48 PM Not agree Not agree
132 132 03/14/2020 PA 47     18   0     0   03/26/2020 04:22:39 PM Agree Not agree
133 133 03/23/2020 SD 28     7   1     0   03/26/2020 04:22:39 PM N/A Agree
134 134 03/31/2020 OK 565     84   23     6   03/30/2020 04:22:39 PM Agree Agree
135 135 04/08/2020 AS 0     0   0     0   04/07/2020 04:22:39 PM    
137 137 03/27/2020 GA 2367 2365 2 524 0 65     5   03/26/2020 12:22:39 PM Agree Agree
139 139 12/11/2020 NY 406146     7248 0 10669     71 0.0 12/12/2020 02:59:37 PM Not agree Not agree
141 141 01/26/2021 FL 1637296     9466 2771 25673     227 17.0 01/27/2021 02:53:24 PM Not agree Not agree
143 143 05/13/2020 AR 4236     72 0 97     2 0.0 05/14/2020 05:25:44 PM Not agree Not agree
145 145 11/30/2020 AS 3     0 0 0     0 0.0 12/01/2020 03:26:07 PM    
147 147 01/29/2020 TN 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
148 148 04/05/2020 AR 853     110   16     2   04/04/2020 04:22:39 PM Not agree Not agree
149 149 08/22/2020 KS 36856 35895 961 0 0 419     0 0.0 08/23/2020 02:15:28 PM Agree N/A
151 151 04/27/2020 NM 2823     97 0 104     5 0.0 05/25/2020 03:38:40 PM N/A Not agree
152 152 03/28/2020 KS 261     59   5     1   03/28/2020 04:22:39 PM Agree N/A
156 156 09/27/2020 KS 56592 53948 2644 0 0 632     0 0.0 09/28/2020 01:50:59 PM Agree N/A
157 157 11/22/2020 WV 40478 35292 5186 880 179 662     4 0.0 11/23/2020 03:04:35 PM Agree Not agree
158 158 12/01/2020 TX 1296972     18540 2401 21549     170 0.0 02/19/2021 01:40:11 PM Not agree Not agree
159 159 09/11/2020 PA 142885 138759 4126 1008 52 7837     17 -1.0 09/12/2020 02:12:43 PM Agree Not agree
161 161 02/25/2021 AR 318122     726 152 5397     10 1.0 02/26/2021 03:02:41 PM Not agree Not agree
162 162 12/11/2020 AS 3     0 0 0     0 0.0 12/12/2020 02:59:37 PM    

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
);