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_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
2 2 08/29/2020 SD 12942     425 0 167 165 2 2 0.0 08/30/2020 02:49:52 PM N/A Agree
3 3 11/06/2020 SD 52639     1488 73 510 476 34 28 3.0 11/07/2020 02:45:17 PM N/A 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    
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
19 19 10/21/2020 SD 35044     587 22 333 320 13 3 8.0 10/22/2020 01:34:46 PM N/A Agree
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    
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
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    
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    
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
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
65 65 09/27/2020 SD 21541     408 0 218 216 2 0 0.0 09/28/2020 01:50:59 PM N/A Agree
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    
84 84 05/07/2020 AK 374     2 0 10     0 0.0 05/08/2020 09:26:08 PM N/A 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
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
97 97 06/06/2020 SD 5367     90 0 65 65 0 0 0.0 06/07/2020 02:23:35 PM N/A Agree
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
112 112 05/03/2020 SD 2631     43 2 21 21 0 0 0.0 05/04/2020 10:49:24 PM N/A 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
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
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    
136 136 08/09/2020 SD 9605     128 0 146 144 2 0 0.0 08/10/2020 02:23:35 PM N/A 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
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
158 158 12/01/2020 TX 1296972     18540 2401 21549     170 0.0 02/19/2021 01:40:11 PM Not agree Not agree
160 160 11/27/2020 SD 78280     2138 212 888 770 118 39 6.0 11/28/2020 02:46:47 PM N/A 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    
165 165 06/29/2020 AR 20257     439 0 265     1 0.0 06/30/2020 03:27:33 PM Not agree Not agree
166 166 04/02/2020 KS 552     70   13     3   04/01/2020 04:22:39 PM Agree N/A
167 167 06/26/2020 FL 120574     8850 0 3366     39 0.0 06/27/2020 05:51:58 PM Not agree Not agree
169 169 05/09/2020 AK 378     1 0 10     0 0.0 05/10/2020 09:26:08 PM N/A N/A
173 173 11/11/2020 PW 0     0 0 0     0 0.0 11/12/2020 02:55:21 PM    
174 174 08/02/2020 HI 2424     207 0 26     0 0.0 08/03/2020 10:31:01 AM Not agree Not agree
175 175 10/13/2020 SD 29339     414 -4 293 288 5 5 0.0 10/14/2020 01:28:39 PM N/A Agree
176 176 08/16/2020 TX 535042     6204 0 9983     143 0.0 08/17/2020 02:26:31 PM Not agree Not agree
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
183 183 01/18/2021 TX 2125552     11590 862 32084     46 0.0 01/19/2021 02:37:00 PM Not agree Not agree
184 184 09/17/2020 PW 0     0 0 0     0 0.0 09/18/2020 01:48:37 PM    
186 186 04/12/2020 NY 85486     3336   2443     183   04/11/2020 04:22:39 PM Not agree Not agree
188 188 05/25/2020 TX 55971     623 0 1527     8 0.0 05/26/2020 02:23:02 PM Not agree Not agree
189 189 08/26/2020 AS 0     0 0 0     0 0.0 08/27/2020 01:42:08 PM    
192 192 06/08/2020 HI 669     6 0 17     0 0.0 06/09/2020 12:49:08 PM Not agree Not agree
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    

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