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_cases

✎ 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    
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    
37 37 01/29/2020 HI 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
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
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    
117 117 01/31/2020 OK 0     0   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    
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
147 147 01/29/2020 TN 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
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    
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    
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
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
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    
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    
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    
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    
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
333 333 01/29/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree 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    
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
389 389 02/02/2020 NYC 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
403 403 02/16/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
405 405 07/12/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/13/2020 03:19:34 PM Agree Agree
407 407 03/03/2020 SD 0     0   0     0   03/26/2020 04:22:39 PM N/A Agree
412 412 08/05/2020 AS 0     0 0 0     0 0.0 08/06/2020 02:12:27 PM    
413 413 11/09/2020 PW 0     0 0 0     0 0.0 11/10/2020 02:45:45 PM    
414 414 03/26/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
418 418 02/13/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
420 420 02/17/2020 AR 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
429 429 02/23/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
430 430 04/02/2020 RMI 0     0   0     0   04/01/2020 04:22:39 PM Agree Agree
433 433 01/27/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
435 435 01/24/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
436 436 07/07/2020 AS 0     0 0 0     0 0.0 07/08/2020 02:12:08 PM    
444 444 08/26/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 08/27/2020 01:42:08 PM Agree Agree
451 451 12/09/2020 PW 0     0 0 0     0 0.0 12/10/2020 02:50:16 PM    
456 456 02/15/2020 NY 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
459 459 01/25/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
463 463 09/24/2020 PW 0     0 0 0     0 0.0 09/25/2020 01:54:10 PM    
464 464 01/25/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
470 470 03/04/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
471 471 02/21/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
477 477 01/31/2021 PW 0     0 0 0     0 0.0 02/01/2021 02:50:29 PM    
478 478 05/04/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 05/05/2020 05:25:08 PM Agree Agree
481 481 02/25/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
482 482 09/02/2020 AS 0     0 0 0     0 0.0 09/03/2020 02:18:16 PM    
492 492 03/11/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
495 495 03/01/2020 NM 0     0   0     0   03/26/2020 04:22:39 PM N/A Not agree
506 506 02/03/2020 TX 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
522 522 05/17/2020 PW 0     0 0 0     0 0.0 05/18/2020 04:01:54 PM    
525 525 02/12/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM 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
);