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

✎ 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
101 101 06/27/2020 PR 7189 1624 5565 123 101 153 59 94 1 0.0 06/28/2020 02:59:02 PM Agree 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    
104 104 10/10/2020 PR 53671 26776 26895 307 89 730 551 179 2 -1.0 10/11/2020 01:47:22 PM Agree Agree
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
107 107 08/28/2020 PR 32550 14986 17564 562 302 428 283 145 4 1.0 08/29/2020 01:42:50 PM Agree 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
109 109 02/23/2021 UT 367789 367789 0 716 0 1865 1808 57 12 0.0 02/24/2021 02:56:12 PM Agree 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
115 115 12/18/2020 GA 576537 500265 76272 8141 2049 10332 9396 936 38 0.0 12/19/2020 02:42:31 PM Agree 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
120 120 02/01/2021 OH 899079 783158 115921 3287 1111 11230 10000 1230 55 10.0 02/02/2021 02:51:51 PM Agree Agree
121 121 01/01/2021 NYC 443835 391547 52288 5565 842 25211 20407 4804 24 -1.0 01/02/2021 02:50:51 PM Agree 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
128 128 10/05/2020 NYC 248233 242315 5918 502 29 23866 19220 4646 5 1.0 10/06/2020 01:33:58 PM Agree 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
137 137 03/27/2020 GA 2367 2365 2 524 0 65     5   03/26/2020 12:22:39 PM Agree Agree
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
139 139 12/11/2020 NY 406146     7248 0 10669     71 0.0 12/12/2020 02:59:37 PM Not agree Not agree
140 140 11/21/2020 OK 182593 153787 28806 7088 1069 1659 1593 66 40 3.0 11/22/2020 03:02:23 PM Agree 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
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
143 143 05/13/2020 AR 4236     72 0 97     2 0.0 05/14/2020 05:25:44 PM Not agree Not agree
144 144 05/09/2020 OH 23697 22560 1137 681 90 1331 1214 117 25 -4.0 05/10/2020 09:26:08 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
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
150 150 04/28/2020 MA 58302 58302 0 1840 0 3153 3153 0 150 0.0 04/29/2020 06:12:08 PM Agree 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
153 153 04/24/2020 UT 3782 3782 0 60 0 39 39 0 1 0.0 05/25/2020 03:38:40 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
155 155 06/08/2020 MA 103626 99755 3871 190 -3 7353 7217 136 37 -1.0 06/09/2020 04:49:08 PM Agree Agree
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
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    
163 163 01/11/2021 PR 84427 78815 5612 959 71 1645 1365 280 3 0.0 01/12/2021 02:48:35 PM Agree Agree
164 164 12/11/2020 KS 185294 158086 27208 5491 964 2072     131 23.0 12/12/2020 02:59:37 PM Agree N/A
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
168 168 10/24/2020 UT 103117 103117 0 1608 0 568 563 5 1 0.0 10/25/2020 01:45:35 PM Agree 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
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
171 171 11/24/2020 UT 182121 182121 0 2701 0 808 789 19 11 1.0 11/25/2020 02:53:15 PM Agree Agree
172 172 02/23/2021 WV 130139 104084 26055 285 89 2274     11 3.0 02/24/2021 02:56:12 PM Agree Not agree
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    
178 178 12/14/2020 MA 293042 283146 9896 3572 0 11343 11135 208 37 0.0 12/15/2020 02:39:02 PM Agree Agree
179 179 01/30/2021 NYC 610313 523526 86787 4836 502 27140 22143 4997 97 16.0 01/31/2021 02:48:12 PM Agree Agree
180 180 12/18/2020 TN 503651 452581 51070 10421 1945 5960 5287 673 115 23.0 12/19/2020 02:42:31 PM Agree Agree
181 181 10/27/2020 GA 379592 352254 27338 2039 438 7844 7844 0 17 0.0 10/28/2020 09:52:28 AM Agree Agree
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    
185 185 09/03/2020 CO 58287 54367 3920 268 10 1955 1606 349 3 1.0 09/04/2020 01:36:16 PM Agree Agree
186 186 04/12/2020 NY 85486     3336   2443     183   04/11/2020 04:22:39 PM Not agree Not agree
187 187 09/04/2020 CO 58655 54709 3946 368 26 1966 1617 349 11 0.0 09/05/2020 02:09:45 PM Agree 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    
190 190 06/30/2020 OH 51789 48222 3567 743 45 2863 2615 248 45 5.0 07/01/2020 03:45:16 PM Agree Agree
191 191 12/24/2020 OK 276095 224254 51841 0 0 2291 2150 141 0 0.0 12/25/2020 02:25:34 PM Agree Agree
192 192 06/08/2020 HI 669     6 0 17     0 0.0 06/09/2020 12:49:08 PM Not agree Not agree
193 193 09/16/2020 OH 140518 133046 7472 1033 105 4555 4256 299 49 0.0 09/17/2020 01:45:45 PM Agree Agree
194 194 05/30/2020 OH 35034 32639 2395 468 31 2149 1938 211 18 1.0 05/31/2020 02:43:17 PM Agree Agree
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    
198 198 12/27/2020 PR 73658 69661 3997 431 35 1456 1205 251 11 2.0 12/28/2020 02:42:49 PM Agree Agree
199 199 10/23/2020 OH 192948 181869 11079 2518 73 5184 4874 310 23 -1.0 10/24/2020 01:26:44 PM Agree Agree
200 200 02/07/2020 PW 0     0   0     0   03/26/2020 04:22:39 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
);