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 pnew_case

✎ 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
18 18 02/29/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
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
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
62 62 04/14/2020 AK 285     8   9     1   04/13/2020 04:22:39 PM N/A N/A
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
74 74 04/06/2020 MA 13837     1337   260     29   04/05/2020 04:22:39 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    
105 105 04/18/2020 OK 2570     105   139     3   04/18/2020 04:22:39 PM Agree Agree
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
118 118 04/06/2020 NYC 68776     3821   2738     266   04/05/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
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    
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
152 152 03/28/2020 KS 261     59   5     1   03/28/2020 04:22:39 PM Agree N/A
166 166 04/02/2020 KS 552     70   13     3   04/01/2020 04:22:39 PM Agree N/A
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
186 186 04/12/2020 NY 85486     3336   2443     183   04/11/2020 04:22:39 PM Not agree Not agree
195 195 03/29/2020 PW 0     0   0     0   03/28/2020 04:22:39 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
217 217 03/01/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
219 219 03/29/2020 TN 1537     164   7     1   03/28/2020 04:22:39 PM Agree Agree
221 221 03/31/2020 CO 2966     339   69     18   03/30/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
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
242 242 04/14/2020 AR 1498     88   32     2   04/13/2020 04:22:39 PM Not 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
254 254 02/08/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
257 257 03/13/2020 FL 31     0   2     0   03/26/2020 04:22:39 PM Not agree Not agree
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
275 275 03/04/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
286 286 02/22/2020 PA 0     0   0     0   03/26/2020 04:22:39 PM Agree Not agree
292 292 02/18/2020 SD 0     0   0     0   03/26/2020 04:22:39 PM N/A 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
321 321 04/11/2020 PA 21656     1676   494     78   04/10/2020 04:22:39 PM Agree Not agree
322 322 03/24/2020 OH 564     122   8     2   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
335 335 04/18/2020 CO 9433     386   411     20   04/18/2020 04: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
341 341 03/17/2020 FL 195     53   7     2   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
350 350 03/23/2020 PR 31     8   2     1   03/26/2020 04:22:39 PM Agree Agree
351 351 01/27/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
354 354 03/29/2020 PA 3394     642   38     4   03/28/2020 04:22:39 PM Agree Not agree
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
376 376 03/01/2020 AR 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
385 385 03/23/2020 TX 507     0   8     3   03/26/2020 04:22:39 PM Not agree Not 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
407 407 03/03/2020 SD 0     0   0     0   03/26/2020 04:22:39 PM N/A Agree
414 414 03/26/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
415 415 03/18/2020 CO 216     33   2     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    
419 419 03/18/2020 KS 21     5   1     0   03/26/2020 04:22:39 PM Agree N/A
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
447 447 03/23/2020 IA 105     15   0     0   03/26/2020 04:22:39 PM Not agree Not agree
450 450 04/09/2020 NY 72910     5397   1787     242   04/08/2020 04:22:39 PM Not agree Not agree
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
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
474 474 03/08/2020 IA 3     3   0     0   03/26/2020 04:22:39 PM Not agree Not agree
481 481 02/25/2020 CO 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
485 485 04/15/2020 UT 2637     184   21     1   04/15/2020 04:22:39 PM Agree Agree
487 487 03/24/2020 PA 851     207   7     5   03/26/2020 04:22:39 PM Agree Not agree
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

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