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 tot_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
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    
18 18 02/29/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
21 21 10/11/2020 PW 0     0 0 0     0 0.0 10/12/2020 02:07:08 PM    
23 23 02/07/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 02/08/2021 02:53:12 PM Agree Agree
25 25 01/12/2021 AS 3     0 0 0     0 0.0 01/13/2021 02:44:58 PM    
29 29 03/09/2020 NYC 17     5   0     0   03/26/2020 04:22:39 PM Agree Agree
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    
44 44 06/09/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 06/10/2020 08:56:25 PM Agree Agree
46 46 05/03/2020 PW 0     0 0 0     0 0.0 05/04/2020 10:49:24 PM    
54 54 06/06/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 06/07/2020 02:23:35 PM Agree Agree
61 61 11/06/2020 PW 0     0 0 0     0 0.0 11/07/2020 02:45:17 PM    
67 67 02/06/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree 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
73 73 07/28/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/29/2020 02:34:46 PM Agree Agree
77 77 12/06/2020 AS 3     0 0 0     0 0.0 12/07/2020 02:38:33 PM    
80 80 11/07/2020 RMI 1 1 0 0 0 0 0 0 0 0.0 11/08/2020 02:40:34 PM Agree Agree
85 85 12/30/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 12/31/2020 02:55:07 PM Agree Agree
92 92 03/08/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
94 94 01/23/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
103 103 02/18/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
110 110 02/10/2020 MA 1     0   0     0   03/26/2020 04:22:39 PM Agree Agree
117 117 01/31/2020 OK 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
123 123 03/16/2020 OH 50     13   0     0   03/26/2020 04:22:39 PM Agree Agree
126 126 03/14/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
129 129 03/13/2020 PA 29     6   0     0   03/26/2020 04:22:39 PM Agree Not agree
132 132 03/14/2020 PA 47     18   0     0   03/26/2020 04:22:39 PM Agree Not agree
135 135 04/08/2020 AS 0     0   0     0   04/07/2020 04:22:39 PM    
138 138 07/07/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/08/2020 02:12:08 PM Agree Agree
142 142 08/09/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 08/10/2020 02:23:35 PM Agree Agree
145 145 11/30/2020 AS 3     0 0 0     0 0.0 12/01/2020 03:26:07 PM    
146 146 11/19/2020 RMI 4 1 3 0 0 0 0 0 0 0.0 11/20/2020 03:06:16 PM Agree Agree
147 147 01/29/2020 TN 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
154 154 01/16/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 01/17/2021 03:43:14 PM Agree Agree
162 162 12/11/2020 AS 3     0 0 0     0 0.0 12/12/2020 02:59:37 PM    
170 170 10/08/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 10/09/2020 01:43:36 PM Agree Agree
173 173 11/11/2020 PW 0     0 0 0     0 0.0 11/12/2020 02:55:21 PM    
177 177 03/03/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
182 182 03/16/2020 PA 76     13   0     0   03/26/2020 04:22:39 PM Agree Not agree
184 184 09/17/2020 PW 0     0 0 0     0 0.0 09/18/2020 01:48:37 PM    
189 189 08/26/2020 AS 0     0 0 0     0 0.0 08/27/2020 01:42:08 PM    
195 195 03/29/2020 PW 0     0   0     0   03/28/2020 04:22:39 PM    
196 196 03/11/2020 GA 55 55 0 16 0 0     0   03/26/2020 12:22:39 PM Agree Agree
197 197 07/15/2020 PW 0     0 0 0     0 0.0 07/16/2020 02:22:21 PM    
200 200 02/07/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
201 201 03/07/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
209 209 02/05/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
210 210 08/25/2020 AS 0     0 0 0     0 0.0 08/26/2020 01:51:40 PM    
217 217 03/01/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
224 224 03/21/2020 NM 57     14   0     0   03/26/2020 04:22:39 PM N/A Not agree
227 227 02/02/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 02/03/2021 02:55:58 PM Agree Agree
230 230 02/10/2020 OH 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
235 235 03/12/2020 WV 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
244 244 02/25/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
251 251 01/29/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
252 252 03/09/2020 UT 1     0   0     0   03/26/2020 04:22:39 PM Agree Agree
253 253 11/07/2020 PW 0     0 0 0     0 0.0 11/08/2020 02:40:34 PM    
254 254 02/08/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
261 261 03/12/2020 OK 3     1   0     0   03/26/2020 04:22:39 PM Agree Agree
267 267 03/30/2020 RMI 0     0   0     0   03/29/2020 04:22:39 PM Agree Agree
271 271 01/09/2021 PW 0     0 0 0     0 0.0 01/10/2021 04:10:55 PM    
273 273 09/20/2020 AS 0     0 0 0     0 0.0 09/21/2020 01:47:41 PM    
274 274 09/30/2020 AS 0     0 0 0     0 0.0 10/01/2020 01:42:11 PM    
275 275 03/04/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
283 283 01/22/2021 AS 3     0 0 0     0 0.0 01/23/2021 02:50:13 PM    
285 285 07/02/2020 PW 0     0 0 0     0 0.0 07/03/2020 03:01:33 PM    
286 286 02/22/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
287 287 06/15/2020 PW 0     0 0 0     0 0.0 06/16/2020 02:10:11 PM    
292 292 02/18/2020 SD 0     0   0     0   03/26/2020 04:22:39 PM N/A Agree
298 298 05/16/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 05/17/2020 03:27:46 PM Agree Agree
299 299 08/24/2020 AS 0     0 0 0     0 0.0 08/25/2020 02:02:54 PM    
300 300 11/04/2020 RMI 1 1 0 0 0 0 0 0 0 0.0 11/05/2020 02:39:23 PM Agree Agree
309 309 02/11/2020 OH 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
310 310 02/14/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
311 311 01/28/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
312 312 02/26/2020 MA 1     0   0     0   03/26/2020 04:22:39 PM Agree Agree
313 313 04/13/2020 RMI 0     0   0     0   04/12/2020 04:22:39 PM Agree Agree
319 319 02/12/2020 OK 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
332 332 03/12/2020 MA 108     13   0     0   03/26/2020 04:22:39 PM Agree Agree
333 333 01/29/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
339 339 03/02/2020 GA 3 3 0 1 0 0     0   03/26/2020 12:22:39 PM Agree Agree
340 340 03/08/2020 TX 6     1   0     0   03/26/2020 04:22:39 PM Not agree Not agree
345 345 01/29/2020 AR 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
347 347 07/23/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/24/2020 02:18:40 PM Agree Agree
351 351 01/27/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
352 352 08/11/2020 AS 0     0 0 0     0 0.0 08/12/2020 01:50:14 PM    
359 359 03/27/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
362 362 03/01/2020 GA 2 2 0 0 0 0     0   03/26/2020 12:22:39 PM Agree Agree
366 366 03/26/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
375 375 10/17/2020 AS 0     0 0 0     0 0.0 10/18/2020 01:26:54 PM    
376 376 03/01/2020 AR 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
377 377 09/07/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 09/08/2020 02:47:00 PM Agree Agree
387 387 02/01/2020 HI 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
388 388 03/27/2020 HI 171     35 0 0     0   03/26/2020 12:22:39 PM Not agree Not agree
389 389 02/02/2020 NYC 0     0   0     0   03/26/2020 04:22:39 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
);