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

13,736 rows where consent_deaths = "Agree"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: consent_cases

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
1 1 12/08/2020 OK 205999 171497 34502 0 0 1752 1680 72 0 0.0 12/09/2020 02:45:40 PM Agree Agree
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
4 4 09/21/2020 MP 69 69 0 0 0 2 2 0 0 0.0 09/22/2020 01:51:57 PM Agree Agree
7 7 01/29/2020 MA 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
9 9 03/07/2020 GA 11 11 0 3 0 0     0   03/26/2020 12:22:39 PM Agree Agree
10 10 05/26/2020 MA 93693 93693 0 422 0 6473 6473 0 57 0.0 05/27/2020 03:37:59 PM Agree Agree
11 11 01/27/2021 NYC 592471 508530 83941 6182 1473 26858 21887 4971 93 26.0 01/28/2021 02:49:07 PM Agree Agree
12 12 05/04/2020 MP 14 14 0 0 0 2 2 0 0 0.0 05/05/2020 05:25:08 PM Agree Agree
14 14 11/12/2020 GA 416217 379873 36344 2802 265 8881 8403 478 548 478.0 11/13/2020 09:54:34 AM Agree Agree
17 17 05/21/2020 CO 23121 20903 2218 369 61 1309 1036 273 10 0.0 05/22/2020 03:31:45 PM Agree 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
22 22 12/04/2020 PR 55532 53633 1899 935 86 1184 955 229 12 0.0 12/05/2020 02:29:17 PM Agree Agree
23 23 02/07/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 02/08/2021 02:53:12 PM Agree Agree
28 28 11/17/2020 OK 169762 143221 26541 7389 1406 1592 1531 61 49 6.0 11/18/2020 02:57:46 PM Agree Agree
29 29 03/09/2020 NYC 17     5   0     0   03/26/2020 04:22:39 PM Agree Agree
30 30 11/03/2020 MP 96 96 0 0 0 2 2 0 0 0.0 11/04/2020 03:03:00 PM Agree Agree
31 31 09/22/2020 UT 65044 65044 0 650 0 443 443 0 3 -1.0 09/23/2020 01:51:22 PM Agree Agree
33 33 01/05/2021 NYC 462668 405805 56863 5299 1171 25363 20521 4842 54 16.0 01/06/2021 02:58:26 PM Agree Agree
34 34 12/23/2020 OH 644822 583118 61704 7790 1474 8361 7613 748 109 26.0 12/24/2020 02:31:20 PM Agree Agree
40 40 09/06/2020 UT 55347 54878 469 341 3 421 421 0 1 0.0 09/07/2020 01:37:36 PM Agree Agree
41 41 08/21/2020 NYC 232789 228144 4645 217 0 23646 19014 4632 5 -2.0 08/22/2020 02:21:09 PM Agree Agree
44 44 06/09/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 06/10/2020 08:56:25 PM Agree Agree
45 45 01/13/2021 MP 128 128 0 0 0 2 2 0 0 0.0 01/14/2021 03:12:46 PM Agree Agree
47 47 08/11/2020 OH 102826 97373 5453 1095 80 3708 3435 273 35 5.0 08/12/2020 01:50:14 PM Agree Agree
54 54 06/06/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 06/07/2020 02:23:35 PM Agree Agree
56 56 09/08/2020 CO 59674 55642 4032 187 3 1973 1623 350 0 0.0 09/09/2020 01:47:50 PM Agree Agree
57 57 04/04/2020 OH 3739     427   102     11   04/03/2020 04:22:39 PM Agree Agree
58 58 07/20/2020 MP 38 38 0 1 0 2 2 0 0 0.0 07/21/2020 02:50:17 PM Agree Agree
60 60 01/06/2021 TN 625237 542490 82747 7588 2226 7381 6326 1055 114 29.0 01/07/2021 02:56:59 PM Agree Agree
63 63 10/08/2020 TN 209447 200103 9344 1992 294 2705 2591 114 63 2.0 10/09/2020 01:43:36 PM Agree Agree
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
66 66 07/22/2020 CO 41698 38562 3136 639 24 1771 1435 336 8 3.0 07/23/2020 02:48:19 PM Agree Agree
67 67 02/06/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
69 69 02/11/2020 NYC 0     0   0     0   03/26/2020 04:22:39 PM Agree Agree
72 72 09/06/2020 OK 69738 63607 6131 444 19 853 853 0 3 0.0 09/07/2020 01:37:36 PM Agree Agree
73 73 07/28/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/29/2020 02:34:46 PM Agree Agree
74 74 04/06/2020 MA 13837     1337   260     29   04/05/2020 04:22:39 PM Agree Agree
75 75 05/19/2020 UT 7595 7595 0 136 0 91 91 0 6 0.0 05/20/2020 03:28:26 PM Agree Agree
79 79 12/03/2020 GA 487978 433353 54625 5839 1466 9648 8879 769 81 32.0 12/04/2020 03:00:59 PM Agree Agree
80 80 11/07/2020 RMI 1 1 0 0 0 0 0 0 0 0.0 11/08/2020 02:40:34 PM Agree Agree
81 81 06/26/2020 NYC 215891 211229 4662 315 -6 22441 17779 4662 20 -6.0 06/27/2020 05:51:58 PM Agree Agree
82 82 01/25/2021 GA 870828 722062 148766 3917 387 13303 11854 1449 53 0.0 01/26/2021 02:46:01 PM Agree Agree
85 85 12/30/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 12/31/2020 02:55:07 PM Agree Agree
86 86 11/28/2020 OH 406703 384544 22159 6895 433 6378 5963 415 32 1.0 11/29/2020 02:49:08 PM Agree Agree
88 88 10/07/2020 CO 74922 69748 5174 731 32 2085 1720 365 4 2.0 10/08/2020 01:56:57 PM Agree 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
96 96 09/12/2020 MA 132533 122637 9896 435 0 9195 8987 208 16 0.0 09/13/2020 04:17:15 PM Agree 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
99 99 04/25/2020 CO 12868 11533 1335 684 146 670 564 106 -2 -15.0 05/25/2020 03:38:40 PM Agree Agree
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
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
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
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
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
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
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
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
123 123 03/16/2020 OH 50     13   0     0   03/26/2020 04:22:39 PM Agree 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
196 196 03/11/2020 GA 55 55 0 16 0 0     0   03/26/2020 12:22:39 PM Agree Agree
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
201 201 03/07/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM Agree 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
);