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 rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: consent_cases, consent_deaths

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
24240 24240 04/15/2020 KS 1494     17   76     5   04/15/2020 04:22:39 PM Agree N/A
24239 24239 12/05/2020 NY 368246     7532 0 10274     57 0.0 12/06/2020 02:51:16 PM Not agree Not agree
24238 24238 10/19/2020 KS 72968 67935 5033 2113 179 872     13 0.0 10/20/2020 02:59:27 PM Agree N/A
24237 24237 09/05/2020 TN 162362 158070 4292 1765 93 1862 1810 52 25 0.0 09/06/2020 02:09:04 PM Agree Agree
24236 24236 04/16/2020 UT 2760     123   22     1   04/16/2020 04:22:39 PM Agree Agree
24235 24235 11/14/2020 MA 190364 180468 9896 2841 0 10273 10065 208 27 0.0 11/15/2020 03:12:13 PM Agree Agree
24234 24234 02/23/2021 HI 26450     44 0 428     0 0.0 02/24/2021 02:56:12 PM Not agree Not agree
24233 24233 11/30/2020 FL 983370     6426 0 18597     97 0.0 12/01/2020 03:26:07 PM Not agree Not agree
24232 24232 04/09/2020 PW 0     0   0     0   04/08/2020 04:22:39 PM    
24231 24231 10/23/2020 TX 851572     6472 0 17375     89 0.0 10/24/2020 01:26:44 PM Not agree Not agree
24230 24230 03/17/2020 UT 29     0   0     0   03/26/2020 04:22:39 PM Agree Agree
24229 24229 07/26/2020 NYC 225116 220483 4633 222 5 23500 18872 4628 15 5.0 07/27/2020 02:16:42 PM Agree Agree
24228 24228 07/29/2020 OK 37060 34614 2446 2070 135 523 523 0 20 0.0 07/30/2020 02:42:43 PM Agree Agree
24227 24227 06/20/2020 FL 91670     4027 0 3144     40 0.0 06/21/2020 02:32:57 PM Not agree Not agree
24226 24226 03/31/2020 PW 0     0   0     0   03/30/2020 04:22:39 PM    
24225 24225 02/18/2020 NYC 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
24224 24224 12/10/2020 UT 225946 225946 0 3401 0 1016 998 18 21 1.0 12/11/2020 03:06:51 PM Agree Agree
24223 24223 10/15/2020 UT 90461 90461 0 1498 0 529 525 4 2 0.0 10/16/2020 01:33:55 PM Agree Agree
24222 24222 05/29/2020 SD 4866     73 0 59 59 0 5 0.0 05/30/2020 03:47:59 PM N/A Agree
24221 24221 02/06/2021 PA 865604 749985 115619 3930 783 22396     157 -70.0 02/07/2021 02:46:31 PM Agree Not agree
24220 24220 12/01/2020 IA 231439     1991 984 2431     28 0.0 12/02/2020 03:48:48 PM Not agree Not agree
24219 24219 02/24/2021 FL 1851151     6923 2605 30340     127 12.0 02/25/2021 02:54:32 PM Not agree Not agree
24218 24218 10/04/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 10/05/2020 01:49:47 PM Agree Agree
24217 24217 11/29/2020 GA 469516 420601 48915 1952 287 9442 8778 664 18 15.0 11/30/2020 02:51:40 PM Agree Agree
24216 24216 02/10/2020 IA 0     0   0     0   03/26/2020 04:22:39 PM Not agree Not agree
24215 24215 07/09/2020 OK 18036 17904 132 679 6 428 428 0 4 0.0 07/10/2020 03:35:06 PM Agree Agree
24214 24214 06/14/2020 UT 14469 14469 0 285 0 139 139 0 0 0.0 06/15/2020 02:33:03 PM Agree Agree
24213 24213 03/26/2020 SD 46     5   1     0   03/26/2020 04:22:39 PM N/A Agree
24212 24212 01/28/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
24211 24211 10/29/2020 NYC 265105 255208 9897 1311 195 23996 19340 4656 7 3.0 10/30/2020 01:37:23 PM Agree Agree
24210 24210 07/06/2020 CO 34257 31368 2889 192 -8 1691 1367 324 -10 -12.0 07/07/2020 02:58:02 PM Agree Agree
24209 24209 10/05/2020 SD 24598     180 0 248 246 2 0 0.0 10/06/2020 01:33:58 PM N/A Agree
24208 24208 12/28/2020 GA 636240 546859 89381 3941 789 10696 9719 977 7 2.0 12/29/2020 02:56:32 PM Agree Agree
24207 24207 07/05/2020 UT 25500 25276 224 498 1 185 185 0 4 0.0 07/06/2020 03:16:12 PM Agree Agree
24206 24206 04/27/2020 OK 3280 3280 0 27 0 197 197 0 2 0.0 05/25/2020 03:38:40 PM Agree Agree
24205 24205 08/04/2020 PW 0     0 0 0     0 0.0 08/05/2020 02:13:18 PM    
24204 24204 08/16/2020 UT 47248 46862 386 306 4 363 363 0 1 0.0 08/17/2020 02:26:31 PM Agree Agree
24203 24203 05/08/2020 MP 16 16 0 1 0 2 2 0 0 0.0 05/09/2020 09:26:08 PM Agree Agree
24202 24202 11/25/2020 KS 147797 128149 19648 5738 1408 1503     47 5.0 11/26/2020 02:44:21 PM Agree N/A
24201 24201 07/24/2020 NY 187258     393 0 8813     6 0.0 07/25/2020 05:40:06 PM Not agree Not agree
24200 24200 12/05/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 12/06/2020 02:51:16 PM Agree Agree
24199 24199 04/18/2020 PR 1118     50   60     2   04/18/2020 04:22:39 PM Agree Agree
24198 24198 05/20/2020 PR 2866 2866 0 61 0 125 59 66 1 2.0 05/21/2020 03:41:38 PM Agree Agree
24197 24197 02/24/2021 PR 99619 91919 7700 100 15 2016 1714 302 9 1.0 02/25/2021 02:54:32 PM Agree Agree
24196 24196 01/11/2021 GA 764499 642712 121787 7454 1115 11475 10299 1176 17 0.0 01/12/2021 02:48:35 PM Agree Agree
24195 24195 08/07/2020 AR 48039     1011 0 521     6 0.0 08/08/2020 02:58:44 PM Not agree Not agree
24194 24194 01/28/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
24193 24193 04/26/2020 UT 4214 4214 0 266 0 41 41 0 0 0.0 05/25/2020 03:38:40 PM Agree Agree
24192 24192 07/09/2020 WV 3826 3718 108 119 3 95     0 0.0 07/10/2020 03:35:06 PM Agree Not agree
24191 24191 03/11/2020 HI 2     0 0 0     0   03/11/2020 12:00:00 AM Not agree Not agree
24190 24190 01/05/2021 HI 21721     107 0 287     0 0.0 01/06/2021 02:58:26 PM Not agree Not agree
24189 24189 05/02/2020 MA 66263 66263 0 1952 0 3846 3846 0 130 0.0 05/03/2020 03:36:03 PM Agree Agree
24188 24188 10/02/2020 SD 23522     386 0 237 235 2 1 0.0 10/03/2020 01:39:53 PM N/A Agree
24187 24187 12/01/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 12/02/2020 03:48:48 PM Agree Agree
24186 24186 02/26/2020 OK 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
24185 24185 07/05/2020 OH 57151 53458 3693 968 -2 2911 2661 250 4 0.0 07/06/2020 03:16:12 PM Agree Agree
24184 24184 04/27/2020 AS 0     0 0 0     0 0.0 05/25/2020 03:38:40 PM    
24183 24183 02/26/2021 GA 1000822 814820 186002 3434 1226 17219 15007 2212 20 2.0 02/27/2021 02:51:23 PM Agree Agree
24182 24182 04/25/2020 WV 1025 1025 0 15 0 33     1 0.0 05/25/2020 03:38:40 PM Agree Not agree
24181 24181 09/29/2020 NY 214054     666 0 9036     2 0.0 09/30/2020 02:17:41 PM Not agree Not agree
24180 24180 01/30/2021 NM 173539     741 0 3265     17 0.0 01/31/2021 02:48:12 PM N/A Not agree
24179 24179 02/22/2020 NYC 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
24178 24178 06/24/2020 WV 2629 2541 88 36 0 92     0 0.0 06/25/2020 02:07:27 PM Agree Not agree
24177 24177 06/15/2020 NY 173685     239 0 8521     19 0.0 06/16/2020 02:10:11 PM Not agree Not agree
24176 24176 02/09/2021 NY 850387     3514 0 17009     84 0.0 02/10/2021 02:52:16 PM Not agree Not agree
24175 24175 07/15/2020 OK 21832 21659 173 910 6 430 430 0 6 0.0 07/16/2020 02:22:21 PM Agree Agree
24174 24174 05/10/2020 UT 6317 6317 0 83 0 67 67 0 0 0.0 05/11/2020 09:26:08 PM Agree Agree
24173 24173 12/09/2020 NYC 351412 318241 33171 3201 748 24421 19704 4717 10 0.0 12/10/2020 02:50:16 PM Agree Agree
24172 24172 04/20/2020 TN 7239 7239 0 443 0 152 152 0 5 0.0 04/20/2020 04:22:39 PM Agree Agree
24171 24171 08/07/2020 AS 0     0 0 0     0 0.0 08/08/2020 02:58:44 PM    
24170 24170 12/09/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 12/10/2020 02:50:16 PM Agree Agree
24169 24169 05/10/2020 TN 15060 14985 75 217 0 243 243 0 1 0.0 05/11/2020 09:26:08 PM Agree Agree
24168 24168 03/02/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
24167 24167 12/22/2020 AK 43001     438 0 193     10 0.0 12/23/2020 02:36:58 PM N/A N/A
24166 24166 08/20/2020 MA 124728 115310 9418 313 51 8888 8657 231 12 0.0 08/21/2020 02:27:34 PM Agree Agree
24165 24165 01/19/2021 AS 3     0 0 0     0 0.0 01/20/2021 02:44:03 PM    
24164 24164 11/06/2020 NYC 272380 261243 11137 1327 176 24060 19398 4662 6 0.0 11/07/2020 02:45:17 PM Agree Agree
24163 24163 11/22/2020 IA 210514     2839 305 2192     32 0.0 11/23/2020 03:04:35 PM Not agree Not agree
24162 24162 02/02/2021 SD 108431     116 4 1779 1430 349 1 0.0 02/03/2021 02:55:58 PM N/A Agree
24161 24161 10/29/2020 KS 82045 74710 7335 0 0 1007     0 0.0 10/30/2020 01:37:23 PM Agree N/A
24160 24160 05/17/2020 AR 4759     181 0 98     0 0.0 05/18/2020 04:01:54 PM Not agree Not agree
24159 24159 04/17/2020 CO 9047     465   391     18   04/17/2020 04:22:39 PM Agree Agree
24158 24158 04/21/2020 PW 0     0 0 0     0 0.0 04/21/2020 04:22:39 PM    
24157 24157 05/29/2020 FL 53114     1196 0 2413     49 0.0 05/30/2020 03:47:59 PM Not agree Not agree
24156 24156 06/14/2020 PW 0     0 0 0     0 0.0 06/15/2020 02:33:03 PM    
24155 24155 01/23/2021 OK 377513 297110 80403 2822 558 3289 2985 304 48 10.0 01/24/2021 02:36:49 PM Agree Agree
24154 24154 12/25/2020 MA 338203 328307 9896 0 0 11914 11706 208 0 0.0 12/26/2020 02:34:18 PM Agree Agree
24153 24153 12/05/2020 SD 85304     906 147 1091 914 177 27 6.0 12/06/2020 02:51:16 PM N/A Agree
24152 24152 06/14/2020 SD 5898     65 0 75 74 1 0 0.0 06/15/2020 02:33:03 PM N/A Agree
24151 24151 02/17/2021 GA 973247 796547 176700 3545 1347 16273 14254 2019 99 21.0 02/18/2021 02:43:57 PM Agree Agree
24150 24150 02/13/2020 RMI 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
24149 24149 06/28/2020 NM 11809     190 0 492     1 0.0 06/29/2020 02:37:31 PM N/A Not agree
24148 24148 01/02/2021 MA 377883 367987 9896 8542 0 12444 12236 208 79 0.0 01/03/2021 02:53:25 PM Agree Agree
24147 24147 02/05/2021 WV 123641 99120 24521 597 108 2100     20 6.0 02/06/2021 04:05:17 PM Agree Not agree
24146 24146 07/17/2020 NYC 222517 217895 4622 331 -2 23388 18771 4617 11 -2.0 07/18/2020 04:14:26 PM Agree Agree
24145 24145 08/12/2020 SD 9815     102 0 147 145 2 1 0.0 08/13/2020 02:12:28 PM N/A Agree
24144 24144 04/14/2020 UT 2453     61   20     2   04/13/2020 04:22:39 PM Agree Agree
24143 24143 12/11/2020 NYC 358538 324183 34355 3636 410 24467 19754 4713 17 -4.0 12/12/2020 02:59:37 PM Agree Agree
24142 24142 12/03/2020 PW 0     0 0 0     0 0.0 12/04/2020 03:00:59 PM    
24141 24141 11/09/2020 TX 1038964     4849 -1936 18769     26 0.0 02/19/2021 01:40:11 PM Not 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
);