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 consent_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
1211 1211 10/05/2020 AS 0     0 0 0     0 0.0 10/06/2020 01:33:58 PM    
1212 1212 08/27/2020 PW 0     0 0 0     0 0.0 08/28/2020 01:43:49 PM    
1223 1223 06/30/2020 PW 0     0 0 0     0 0.0 07/01/2020 03:45:16 PM    
1255 1255 08/21/2020 PW 0     0 0 0     0 0.0 08/22/2020 02:21:09 PM    
1291 1291 09/26/2020 AS 0     0 0 0     0 0.0 09/27/2020 01:39:49 PM    
1302 1302 09/03/2020 AS 0     0 0 0     0 0.0 09/04/2020 01:36:16 PM    
1309 1309 03/15/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
1316 1316 09/01/2020 PW 0     0 0 0     0 0.0 09/02/2020 01:49:48 PM    
1319 1319 11/13/2020 AS 3     0 0 0     0 0.0 11/14/2020 02:44:40 PM    
1322 1322 05/10/2020 PW 0     0 0 0     0 0.0 05/11/2020 09:26:08 PM    
1330 1330 05/07/2020 AS 0     0 0 0     0 0.0 05/08/2020 09:26:08 PM    
1347 1347 08/27/2020 AS 0     0 0 0     0 0.0 08/28/2020 01:43:49 PM    
1364 1364 06/28/2020 PW 0     0 0 0     0 0.0 06/29/2020 02:37:31 PM    
1374 1374 08/09/2020 PW 0     0 0 0     0 0.0 08/10/2020 02:23:35 PM    
1378 1378 06/19/2020 PW 0     0 0 0     0 0.0 06/20/2020 02:15:45 PM    
1390 1390 07/21/2020 PW 0     0 0 0     0 0.0 07/22/2020 02:51:28 PM    
1394 1394 06/12/2020 AS 0     0 0 0     0 0.0 06/13/2020 05:46:26 PM    
1418 1418 11/26/2020 AS 3     0 0 0     0 0.0 11/27/2020 03:07:59 PM    
1464 1464 12/01/2020 AS 3     0 0 0     0 0.0 12/02/2020 03:48:48 PM    
1466 1466 05/18/2020 AS 0     0 0 0     0 0.0 05/19/2020 03:45:23 PM    
1495 1495 05/25/2020 PW 0     0 0 0     0 0.0 05/26/2020 02:23:02 PM    
1500 1500 12/18/2020 PW 0     0 0 0     0 0.0 12/19/2020 02:42:31 PM    
1508 1508 09/16/2020 AS 0     0 0 0     0 0.0 09/17/2020 01:45:45 PM    
1525 1525 12/22/2020 PW 0     0 0 0     0 0.0 12/23/2020 02:36:58 PM    
1528 1528 04/15/2020 PW 0     0   0     0   04/15/2020 04:22:39 PM    
1540 1540 10/21/2020 AS 0     0 0 0     0 0.0 10/22/2020 01:34:46 PM    
1548 1548 02/25/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
1574 1574 01/29/2021 AS 3     0 0 0     0 0.0 01/30/2021 02:43:11 PM    
1575 1575 02/10/2021 PW 0     0 0 0     0 0.0 02/11/2021 02:50:55 PM    
1580 1580 10/27/2020 AS 0     0 0 0     0 0.0 10/28/2020 01:52:28 PM    
1585 1585 06/29/2020 AS 0     0 0 0     0 0.0 06/30/2020 03:27:33 PM    
1596 1596 10/23/2020 PW 0     0 0 0     0 0.0 10/24/2020 01:26:44 PM    
1618 1618 03/19/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
1650 1650 10/07/2020 AS 0     0 0 0     0 0.0 10/08/2020 01:56:57 PM    
1654 1654 02/12/2021 AS 3     0 0 0     0 0.0 02/13/2021 02:50:08 PM    
1682 1682 09/14/2020 PW 0     0 0 0     0 0.0 09/15/2020 02:03:59 PM    
1683 1683 10/24/2020 PW 0     0 0 0     0 0.0 10/25/2020 01:45:35 PM    
1684 1684 12/21/2020 AS 3     0 0 0     0 0.0 12/22/2020 02:35:48 PM    
1695 1695 02/10/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
1697 1697 07/12/2020 PW 0     0 0 0     0 0.0 07/13/2020 03:19:34 PM    
1698 1698 12/20/2020 PW 0     0 0 0     0 0.0 12/21/2020 02:39:53 PM    
1709 1709 08/01/2020 PW 0     0 0 0     0 0.0 08/02/2020 02:54:37 PM    
1722 1722 02/05/2021 PW 0     0 0 0     0 0.0 02/06/2021 04:05:17 PM    
1723 1723 02/27/2021 AS 4     0 0 0     0 0.0 02/28/2021 02:48:18 PM    
1735 1735 12/08/2020 AS 3     0 0 0     0 0.0 12/09/2020 02:45:40 PM    
1746 1746 05/13/2020 PW 0     0 0 0     0 0.0 05/14/2020 05:25:44 PM    
1800 1800 01/29/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
1807 1807 02/16/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
1809 1809 01/22/2021 PW 0     0 0 0     0 0.0 01/23/2021 02:50:13 PM    
1811 1811 03/30/2020 PW 0     0   0     0   03/29/2020 04:22:39 PM    
1824 1824 07/13/2020 PW 0     0 0 0     0 0.0 07/14/2020 03:13:07 PM    
1826 1826 12/19/2020 PW 0     0 0 0     0 0.0 12/20/2020 02:32:33 PM    
1843 1843 02/21/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
1853 1853 08/19/2020 AS 0     0 0 0     0 0.0 08/20/2020 03:11:45 PM    
1868 1868 11/04/2020 PW 0     0 0 0     0 0.0 11/05/2020 02:39:23 PM    
1879 1879 09/25/2020 PW 0     0 0 0     0 0.0 09/26/2020 01:46:07 PM    
1904 1904 01/27/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
1924 1924 04/03/2020 PW 0     0   0     0   04/03/2020 04:22:39 PM    
1935 1935 03/22/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
1951 1951 11/07/2020 AS 0     0 0 0     0 0.0 11/08/2020 02:40:34 PM    
1952 1952 12/26/2020 PW 0     0 0 0     0 0.0 12/27/2020 02:44:47 PM    
1955 1955 07/13/2020 AS 0     0 0 0     0 0.0 07/14/2020 03:13:07 PM    
1957 1957 01/23/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
1958 1958 03/27/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
1989 1989 02/08/2021 AS 3     0 0 0     0 0.0 02/09/2021 03:24:29 PM    
2016 2016 10/13/2020 PW 0     0 0 0     0 0.0 10/14/2020 01:28:39 PM    
2023 2023 12/10/2020 AS 3     0 0 0     0 0.0 12/11/2020 03:06:51 PM    
2030 2030 11/17/2020 AS 3     0 0 0     0 0.0 11/18/2020 02:57:46 PM    
2032 2032 06/04/2020 PW 0     0 0 0     0 0.0 06/05/2020 03:17:07 PM    
2056 2056 10/25/2020 AS 0     0 0 0     0 0.0 10/26/2020 01:41:41 PM    
2062 2062 02/26/2021 AS 4     0 0 0     0 0.0 02/27/2021 02:51:23 PM    
2076 2076 04/17/2020 AS 0     0   0     0   04/17/2020 04:22:39 PM    
2119 2119 10/09/2020 AS 0     0 0 0     0 0.0 10/10/2020 01:30:17 PM    
2120 2120 01/27/2021 PW 0     0 0 0     0 0.0 01/28/2021 02:49:07 PM    
2121 2121 07/28/2020 PW 0     0 0 0     0 0.0 07/29/2020 02:34:46 PM    
2125 2125 02/08/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
2140 2140 12/17/2020 PW 0     0 0 0     0 0.0 12/18/2020 02:45:01 PM    
2145 2145 10/26/2020 PW 0     0 0 0     0 0.0 10/27/2020 01:47:53 PM    
2174 2174 06/29/2020 PW 0     0 0 0     0 0.0 06/30/2020 03:27:33 PM    
2182 2182 06/14/2020 AS 0     0 0 0     0 0.0 06/15/2020 02:33:03 PM    
2214 2214 09/14/2020 AS 0     0 0 0     0 0.0 09/15/2020 02:03:59 PM    
2222 2222 03/24/2020 AS 0     0   0     0   03/26/2020 04:22:39 PM    
2240 2240 11/28/2020 AS 3     0 0 0     0 0.0 11/29/2020 02:49:08 PM    
2264 2264 10/29/2020 PW 0     0 0 0     0 0.0 10/30/2020 01:37:23 PM    
2288 2288 10/30/2020 PW 0     0 0 0     0 0.0 10/31/2020 01:30:31 PM    
2329 2329 08/10/2020 AS 0     0 0 0     0 0.0 08/11/2020 02:16:27 PM    
2330 2330 01/26/2021 AS 3     0 0 0     0 0.0 01/27/2021 02:53:24 PM    
2333 2333 10/08/2020 AS 0     0 0 0     0 0.0 10/09/2020 01:43:36 PM    
2361 2361 03/22/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
2369 2369 11/16/2020 AS 3     0 0 0     0 0.0 11/17/2020 02:52:47 PM    
2377 2377 08/13/2020 AS 0     0 0 0     0 0.0 08/14/2020 02:30:03 PM    
2388 2388 12/14/2020 PW 0     0 0 0     0 0.0 12/15/2020 02:39:02 PM    
2391 2391 07/17/2020 AS 0     0 0 0     0 0.0 07/18/2020 04:14:26 PM    
2396 2396 04/15/2020 AS 0     0   0     0   04/15/2020 04:22:39 PM    
2401 2401 10/06/2020 PW 0     0 0 0     0 0.0 10/07/2020 01:45:01 PM    
2404 2404 05/21/2020 PW 0     0 0 0     0 0.0 05/22/2020 03:31:45 PM    
2418 2418 05/28/2020 PW 0     0 0 0     0 0.0 05/29/2020 02:19:55 PM    
2423 2423 08/22/2020 AS 0     0 0 0     0 0.0 08/23/2020 02:15:28 PM    
2439 2439 02/19/2020 PW 0     0   0     0   03/26/2020 04:22:39 PM    
2450 2450 01/08/2021 AS 3     0 0 0     0 0.0 01/09/2021 03:26:08 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
);