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 state

✎ 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
62 62 04/14/2020 AK 285     8   9     1   04/13/2020 04:22:39 PM N/A N/A
76 76 12/15/2020 AK 40438     278 0 178     3 0.0 12/16/2020 02:28:57 PM N/A N/A
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
102 102 09/22/2020 AK 6950     44 0 45     0 0.0 09/23/2020 01:51:22 PM N/A N/A
113 113 01/24/2021 AK 51610     165 0 257     0 0.0 01/25/2021 02:42:40 PM N/A N/A
130 130 07/02/2020 AK 1017     39 0 14     0 0.0 07/03/2020 03:01:33 PM N/A N/A
169 169 05/09/2020 AK 378     1 0 10     0 0.0 05/10/2020 09:26:08 PM N/A N/A
207 207 05/11/2020 AK 381     2 0 10     0 0.0 05/12/2020 05:26:08 PM N/A N/A
243 243 05/27/2020 AK 412     1 0 10     0 0.0 05/28/2020 03:12:25 PM N/A N/A
263 263 07/10/2020 AK 1323     51 0 17     0 0.0 07/11/2020 06:25:05 PM N/A N/A
293 293 05/13/2020 AK 383     0 0 10     0 0.0 05/14/2020 05:25:44 PM N/A N/A
346 346 09/29/2020 AK 7721     124 0 56     0 0.0 09/30/2020 02:17:41 PM N/A N/A
351 351 01/27/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
374 374 12/27/2020 AK 44280     290 0 199     0 0.0 12/28/2020 02:42:49 PM N/A N/A
402 402 02/10/2021 AK 53991     182 0 278     0 0.0 02/11/2021 02:50:55 PM N/A N/A
488 488 05/14/2020 AK 387     4 0 10     0 0.0 05/15/2020 04:11:22 PM N/A N/A
532 532 01/08/2021 AK 48063     403 0 222     0 0.0 01/09/2021 03:26:08 PM N/A N/A
535 535 04/28/2020 AK 351     6 0 9     0 0.0 04/29/2020 06:12:08 PM N/A N/A
561 561 11/15/2020 AK 22662     648 0 98     0 0.0 11/16/2020 06:40:02 PM N/A N/A
584 584 04/16/2020 AK 300     7   9     0   04/16/2020 04:22:39 PM N/A N/A
597 597 01/17/2021 AK 50296     279 0 228     0 0.0 01/18/2021 02:39:32 PM N/A N/A
723 723 10/17/2020 AK 10760     211 0 67     1 0.0 10/18/2020 01:26:54 PM N/A N/A
736 736 12/04/2020 AK 34041     750 0 141     12 0.0 12/05/2020 02:29:17 PM N/A N/A
770 770 09/11/2020 AK 6113     93 0 43     1 0.0 09/12/2020 02:12:43 PM N/A N/A
798 798 05/06/2020 AK 372     1 0 10     1 0.0 05/07/2020 10:59:02 PM N/A N/A
810 810 05/28/2020 AK 425     13 0 10     0 0.0 05/29/2020 02:19:55 PM N/A N/A
812 812 02/04/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
837 837 06/25/2020 AK 816     24 0 12     0 0.0 06/26/2020 07:18:27 PM N/A N/A
874 874 11/03/2020 AK 16360     388 0 84     0 0.0 11/04/2020 03:03:00 PM N/A N/A
900 900 09/10/2020 AK 6020     124 0 42     0 0.0 09/11/2020 01:51:03 PM N/A N/A
936 936 03/01/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
940 940 10/11/2020 AK 9686     255 0 60     0 0.0 10/12/2020 02:07:08 PM N/A N/A
1016 1016 06/03/2020 AK 505     18 0 10     0 0.0 06/04/2020 03:03:31 PM N/A N/A
1027 1027 07/01/2020 AK 978     38 0 14     0 0.0 07/02/2020 03:10:03 PM N/A N/A
1033 1033 10/28/2020 AK 14097     355 0 71     1 0.0 10/29/2020 02:11:33 PM N/A N/A
1087 1087 03/07/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
1093 1093 03/18/2020 AK 6     3   0     0   03/26/2020 04:22:39 PM N/A N/A
1108 1108 03/05/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
1123 1123 12/14/2020 AK 40160     422 0 175     0 0.0 12/15/2020 02:39:02 PM N/A N/A
1176 1176 08/19/2020 AK 4438     67 0 29     0 0.0 08/20/2020 03:11:45 PM N/A N/A
1201 1201 06/08/2020 AK 563     19 0 10     0 0.0 06/09/2020 04:49:08 PM N/A N/A
1203 1203 10/07/2020 AK 8878     126 0 59     1 0.0 10/08/2020 01:56:57 PM N/A N/A
1210 1210 01/19/2021 AK 50572     125 0 229     1 0.0 01/20/2021 02:44:03 PM N/A N/A
1218 1218 08/21/2020 AK 4588     68 0 30     1 0.0 08/22/2020 02:21:09 PM N/A N/A
1240 1240 02/26/2021 AK 55989     103 0 287     0 0.0 02/27/2021 02:51:23 PM N/A N/A
1281 1281 07/29/2020 AK 2797     68 0 22     0 0.0 07/30/2020 02:42:43 PM N/A N/A
1301 1301 04/05/2020 AK 185     14   6     1   04/04/2020 04:22:39 PM N/A N/A
1303 1303 06/11/2020 AK 610     17 0 11     0 0.0 06/12/2020 02:17:59 PM N/A N/A
1328 1328 10/31/2020 AK 15274     437 0 82     1 0.0 11/01/2020 03:03:08 PM N/A N/A
1329 1329 12/05/2020 AK 34963     922 0 142     1 0.0 12/06/2020 02:51:16 PM N/A N/A
1335 1335 11/16/2020 AK 23240     578 0 98     0 0.0 11/17/2020 02:52:47 PM N/A N/A
1359 1359 03/27/2020 AK 85     16   2     1   03/26/2020 04:22:39 PM N/A N/A
1384 1384 05/02/2020 AK 365     1 0 9     0 0.0 05/03/2020 03:36:03 PM N/A N/A
1419 1419 07/08/2020 AK 1226     42 0 17     0 0.0 07/09/2020 03:14:15 PM N/A N/A
1427 1427 01/05/2021 AK 47006     194 0 217     0 0.0 01/06/2021 02:58:26 PM N/A N/A
1454 1454 11/20/2020 AK 25369     460 0 100     0 0.0 11/21/2020 02:59:41 PM N/A N/A
1462 1462 06/02/2020 AK 487     20 0 10     0 0.0 06/03/2020 02:11:36 PM N/A N/A
1498 1498 04/22/2020 AK 335     6 0 9     0 0.0 04/22/2020 04:22:39 PM N/A N/A
1541 1541 02/11/2021 AK 54134     143 0 278     0 0.0 02/12/2021 02:56:38 PM N/A N/A
1542 1542 02/04/2021 AK 53114     158 0 277     0 0.0 02/05/2021 02:54:41 PM N/A N/A
1559 1559 03/29/2020 AK 114     12   3     1   03/28/2020 04:22:39 PM N/A N/A
1571 1571 11/17/2020 AK 23874     634 0 99     1 0.0 11/18/2020 02:57:46 PM N/A N/A
1594 1594 09/12/2020 AK 6216     103 0 44     1 0.0 09/13/2020 04:17:15 PM N/A N/A
1625 1625 07/04/2020 AK 1111     48 0 16     1 0.0 07/05/2020 03:00:14 PM N/A N/A
1639 1639 12/11/2020 AK 38584     622 0 157     3 0.0 12/12/2020 02:59:37 PM N/A N/A
1694 1694 03/25/2020 AK 59     17   1     0   03/26/2020 04:22:39 PM N/A N/A
1820 1820 01/30/2021 AK 52470     135 0 260     0 0.0 01/31/2021 02:48:12 PM N/A N/A
1828 1828 12/20/2020 AK 42413     178 0 183     0 0.0 12/21/2020 02:39:53 PM N/A N/A
1829 1829 04/26/2020 AK 341     2 0 9     0 0.0 05/25/2020 03:38:40 PM N/A N/A
1842 1842 04/04/2020 AK 171     14   5     2   04/03/2020 04:22:39 PM N/A N/A
1900 1900 09/21/2020 AK 6906     70 0 45     0 0.0 09/22/2020 01:51:57 PM N/A N/A
1967 1967 02/18/2021 AK 55009     210 0 286     0 0.0 02/19/2021 03:33:51 PM N/A N/A
1972 1972 02/21/2021 AK 55198     0 0 286     0 0.0 02/22/2021 02:53:38 PM N/A N/A
1987 1987 02/29/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
2014 2014 05/05/2020 AK 371     1 0 9     0 0.0 05/06/2020 04:23:08 PM N/A N/A
2039 2039 06/29/2020 AK 904     21 0 14     0 0.0 06/30/2020 03:27:33 PM N/A N/A
2040 2040 03/13/2020 AK 1     1   0     0   03/26/2020 04:22:39 PM N/A N/A
2052 2052 07/14/2020 AK 1579     40 0 17     0 0.0 07/15/2020 03:05:12 PM N/A N/A
2075 2075 08/28/2020 AK 5092     117 0 37     0 0.0 08/29/2020 01:42:50 PM N/A N/A
2106 2106 05/10/2020 AK 379     1 0 10     0 0.0 05/11/2020 09:26:08 PM N/A N/A
2107 2107 12/18/2020 AK 41905     487 0 182     0 0.0 12/19/2020 02:42:31 PM N/A N/A
2134 2134 03/26/2020 AK 69     10   1     0   03/26/2020 04:22:39 PM N/A N/A
2170 2170 12/02/2020 AK 32531     697 0 121     0 0.0 12/03/2020 03:21:08 PM N/A N/A
2179 2179 08/07/2020 AK 3536     52 0 25     0 0.0 08/08/2020 02:58:44 PM N/A N/A
2188 2188 05/29/2020 AK 430     5 0 10     0 0.0 05/30/2020 03:47:59 PM N/A N/A
2198 2198 07/11/2020 AK 1385     62 0 17     0 0.0 07/12/2020 03:13:57 PM N/A N/A
2199 2199 04/09/2020 AK 235     9   7     0   04/08/2020 04:22:39 PM N/A N/A
2202 2202 04/30/2020 AK 355     0 0 9     0 0.0 05/01/2020 09:00:19 PM N/A N/A
2207 2207 12/24/2020 AK 43629     268 0 198     2 0.0 12/25/2020 02:25:34 PM N/A N/A
2212 2212 01/25/2021 AK 51693     83 0 257     0 0.0 01/26/2021 02:46:01 PM N/A N/A
2215 2215 01/22/2020 AK 0     0   0     0   03/26/2020 04:22:39 PM N/A N/A
2233 2233 02/02/2021 AK 52775     107 0 277     17 0.0 02/03/2021 02:55:58 PM N/A N/A
2235 2235 10/22/2020 AK 11837     232 0 68     0 0.0 10/23/2020 01:44:31 PM N/A N/A
2251 2251 06/16/2020 AK 676     12 0 12     0 0.0 06/17/2020 03:06:04 PM N/A N/A
2253 2253 07/30/2020 AK 2878     81 0 23     1 0.0 07/31/2020 02:35:06 PM N/A N/A
2323 2323 08/05/2020 AK 3449     55 0 25     0 0.0 08/06/2020 02:12:27 PM N/A N/A
2347 2347 06/15/2020 AK 664     3 0 12     0 0.0 06/16/2020 02:10:11 PM N/A N/A
2363 2363 04/15/2020 AK 293     8   9     0   04/15/2020 04:22:39 PM N/A N/A
2366 2366 07/19/2020 AK 1874     79 0 18     0 0.0 07/20/2020 02:35:44 PM N/A N/A

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