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

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
1 12/08/2020 OK 205999 171497 34502 0 0 1752 1680 72 0 0.0 12/09/2020 02:45:40 PM
2 08/29/2020 SD 12942     425 0 167 165 2 2 0.0 08/30/2020 02:49:52 PM
3 11/06/2020 SD 52639     1488 73 510 476 34 28 3.0 11/07/2020 02:45:17 PM
4 09/21/2020 MP 69 69 0 0 0 2 2 0 0 0.0 09/22/2020 01:51:57 PM
5 06/28/2020 PA 85988 83529 2459 492 13 6614     8 4.0 06/29/2020 02:37:31 PM
6 12/02/2020 NY 346492     5775 0 10117     56 0.0 12/03/2020 03:21:08 PM
7 01/29/2020 MA 0     0   0     0   03/26/2020 04:22:39 PM
8 09/26/2020 PW 0     0 0 0     0 0.0 09/27/2020 01:39:49 PM
9 03/07/2020 GA 11 11 0 3 0 0     0   03/26/2020 12:22:39 PM
10 05/26/2020 MA 93693 93693 0 422 0 6473 6473 0 57 0.0 05/27/2020 03:37:59 PM
11 01/27/2021 NYC 592471 508530 83941 6182 1473 26858 21887 4971 93 26.0 01/28/2021 02:49:07 PM
12 05/04/2020 MP 14 14 0 0 0 2 2 0 0 0.0 05/05/2020 05:25:08 PM
13 06/07/2020 PW 0     0 0 0     0 0.0 06/08/2020 02:55:08 PM
14 11/12/2020 GA 416217 379873 36344 2802 265 8881 8403 478 548 478.0 11/13/2020 09:54:34 AM
15 10/03/2020 HI 12768     69 0 142     0 0.0 10/04/2020 09:35:23 AM
16 11/21/2020 IA 207675     3700 536 2160     25 0.0 11/22/2020 03:02:23 PM
17 05/21/2020 CO 23121 20903 2218 369 61 1309 1036 273 10 0.0 05/22/2020 03:31:45 PM
18 02/29/2020 MP 0     0   0     0   03/26/2020 04:22:39 PM
19 10/21/2020 SD 35044     587 22 333 320 13 3 8.0 10/22/2020 01:34:46 PM
20 05/26/2020 KS 9218 9218 0 0 0 188     0 0.0 05/27/2020 03:37:59 PM
21 10/11/2020 PW 0     0 0 0     0 0.0 10/12/2020 02:07:08 PM
22 12/04/2020 PR 55532 53633 1899 935 86 1184 955 229 12 0.0 12/05/2020 02:29:17 PM
23 02/07/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 02/08/2021 02:53:12 PM
24 11/03/2020 NY 248091     1519 0 9290     8 0.0 11/04/2020 03:03:00 PM
25 01/12/2021 AS 3     0 0 0     0 0.0 01/13/2021 02:44:58 PM
26 08/31/2020 KS 42612 41425 1187 1564 0 446     3 0.0 09/01/2020 02:09:34 PM
27 12/29/2020 TX 1715978     32552 4532 26762     241 0.0 12/30/2020 02:56:20 PM
28 11/17/2020 OK 169762 143221 26541 7389 1406 1592 1531 61 49 6.0 11/18/2020 02:57:46 PM
29 03/09/2020 NYC 17     5   0     0   03/26/2020 04:22:39 PM
30 11/03/2020 MP 96 96 0 0 0 2 2 0 0 0.0 11/04/2020 03:03:00 PM
31 09/22/2020 UT 65044 65044 0 650 0 443 443 0 3 -1.0 09/23/2020 01:51:22 PM
32 10/28/2020 AR 108640     961 271 1875     18 0.0 10/29/2020 02:11:33 PM
33 01/05/2021 NYC 462668 405805 56863 5299 1171 25363 20521 4842 54 16.0 01/06/2021 02:58:26 PM
34 12/23/2020 OH 644822 583118 61704 7790 1474 8361 7613 748 109 26.0 12/24/2020 02:31:20 PM
35 08/21/2020 KS 36856 35895 961 966 13 419     8 0.0 08/22/2020 02:21:09 PM
36 11/27/2020 KS 153021 132785 20236 5224 588 1529     26 5.0 11/28/2020 02:46:47 PM
37 01/29/2020 HI 0     0   0     0   03/26/2020 04:22:39 PM
38 12/28/2020 AS 3     0 0 0     0 0.0 12/29/2020 02:56:32 PM
39 06/23/2020 PW 0     0 0 0     0 0.0 06/24/2020 03:03:27 PM
40 09/06/2020 UT 55347 54878 469 341 3 421 421 0 1 0.0 09/07/2020 01:37:36 PM
41 08/21/2020 NYC 232789 228144 4645 217 0 23646 19014 4632 5 -2.0 08/22/2020 02:21:09 PM
42 07/16/2020 WV 4657 4535 122 100 4 99     1 0.0 07/17/2020 02:31:01 PM
43 01/02/2021 AR 231442     2000 403 3729     18 3.0 01/03/2021 02:53:25 PM
44 06/09/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 06/10/2020 08:56:25 PM
45 01/13/2021 MP 128 128 0 0 0 2 2 0 0 0.0 01/14/2021 03:12:46 PM
46 05/03/2020 PW 0     0 0 0     0 0.0 05/04/2020 10:49:24 PM
47 08/11/2020 OH 102826 97373 5453 1095 80 3708 3435 273 35 5.0 08/12/2020 01:50:14 PM
48 10/07/2020 PA 166552 160772 5780 1309 127 8272     28 -16.0 10/08/2020 01:56:57 PM
49 06/13/2020 PA 78462 76237 2225 0 0 6211     0 0.0 06/14/2020 02:19:43 PM
50 05/24/2020 NY 163392     732 0 7830     68 0.0 05/25/2020 02:12:49 PM
51 08/17/2020 AR 53077     412 0 603     4 0.0 08/18/2020 02:26:55 PM
52 02/14/2021 AR 313028     466 33 5265     13 2.0 02/15/2021 02:46:24 PM
53 01/11/2021 WV 102282 82440 19842 1070 211 1594     12 3.0 01/12/2021 02:48:35 PM
54 06/06/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 06/07/2020 02:23:35 PM
55 02/26/2021 KS 293663 238336 55327 826 223 4735     11 1.0 02/27/2021 02:51:23 PM
56 09/08/2020 CO 59674 55642 4032 187 3 1973 1623 350 0 0.0 09/09/2020 01:47:50 PM
57 04/04/2020 OH 3739     427   102     11   04/03/2020 04:22:39 PM
58 07/20/2020 MP 38 38 0 1 0 2 2 0 0 0.0 07/21/2020 02:50:17 PM
59 03/22/2020 PA 479     108   2     0   03/26/2020 04:22:39 PM
60 01/06/2021 TN 625237 542490 82747 7588 2226 7381 6326 1055 114 29.0 01/07/2021 02:56:59 PM
61 11/06/2020 PW 0     0 0 0     0 0.0 11/07/2020 02:45:17 PM
62 04/14/2020 AK 285     8   9     1   04/13/2020 04:22:39 PM
63 10/08/2020 TN 209447 200103 9344 1992 294 2705 2591 114 63 2.0 10/09/2020 01:43:36 PM
64 07/30/2020 KS 26870 26327 543 0 0 349     0 0.0 07/31/2020 02:35:06 PM
65 09/27/2020 SD 21541     408 0 218 216 2 0 0.0 09/28/2020 01:50:59 PM
66 07/22/2020 CO 41698 38562 3136 639 24 1771 1435 336 8 3.0 07/23/2020 02:48:19 PM
67 02/06/2020 UT 0     0   0     0   03/26/2020 04:22:39 PM
68 06/22/2020 TX 114881     3280 0 2192     10 0.0 06/23/2020 02:28:19 PM
69 02/11/2020 NYC 0     0   0     0   03/26/2020 04:22:39 PM
70 02/18/2020 AR 0     0   0     0   03/26/2020 04:22:39 PM
71 09/16/2020 FL 663234     2288 382 12939     152 3.0 09/17/2020 01:45:45 PM
72 09/06/2020 OK 69738 63607 6131 444 19 853 853 0 3 0.0 09/07/2020 01:37:36 PM
73 07/28/2020 RMI 0 0 0 0 0 0 0 0 0 0.0 07/29/2020 02:34:46 PM
74 04/06/2020 MA 13837     1337   260     29   04/05/2020 04:22:39 PM
75 05/19/2020 UT 7595 7595 0 136 0 91 91 0 6 0.0 05/20/2020 03:28:26 PM
76 12/15/2020 AK 40438     278 0 178     3 0.0 12/16/2020 02:28:57 PM
77 12/06/2020 AS 3     0 0 0     0 0.0 12/07/2020 02:38:33 PM
78 11/03/2020 PA 214871 204363 10508 2875 276 8855     32 9.0 11/04/2020 03:03:00 PM
79 12/03/2020 GA 487978 433353 54625 5839 1466 9648 8879 769 81 32.0 12/04/2020 03:00:59 PM
80 11/07/2020 RMI 1 1 0 0 0 0 0 0 0 0.0 11/08/2020 02:40:34 PM
81 06/26/2020 NYC 215891 211229 4662 315 -6 22441 17779 4662 20 -6.0 06/27/2020 05:51:58 PM
82 01/25/2021 GA 870828 722062 148766 3917 387 13303 11854 1449 53 0.0 01/26/2021 02:46:01 PM
83 07/24/2020 PA 106625 103632 2993 1054 24 7114     13 6.0 07/25/2020 05:40:06 PM
84 05/07/2020 AK 374     2 0 10     0 0.0 05/08/2020 09:26:08 PM
85 12/30/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 12/31/2020 02:55:07 PM
86 11/28/2020 OH 406703 384544 22159 6895 433 6378 5963 415 32 1.0 11/29/2020 02:49:08 PM
87 09/21/2020 PA 150812 146281 4531 234 10 8004     48 50.0 09/22/2020 01:51:57 PM
88 10/07/2020 CO 74922 69748 5174 731 32 2085 1720 365 4 2.0 10/08/2020 01:56:57 PM
89 06/27/2020 KS 13538 13227 311 0 0 264     0 0.0 06/28/2020 02:59:02 PM
90 05/19/2020 AK 399     0 0 10     0 0.0 05/20/2020 03:28:26 PM
91 04/19/2020 HI 576     4 0 10     1 0.0 04/19/2020 12:22:39 PM
92 03/08/2020 PR 0     0   0     0   03/26/2020 04:22:39 PM
93 01/08/2021 PA 703265 624688 78577 10178 2009 17394     215 155.0 01/09/2021 03:26:08 PM
94 01/23/2020 GA 0     0   0     0   03/26/2020 04:22:39 PM
95 08/14/2020 AR 52392     626 0 587     5 0.0 08/15/2020 02:02:05 PM
96 09/12/2020 MA 132533 122637 9896 435 0 9195 8987 208 16 0.0 09/13/2020 04:17:15 PM
97 06/06/2020 SD 5367     90 0 65 65 0 0 0.0 06/07/2020 02:23:35 PM
98 11/29/2020 KS 153021 132785 20236 0 0 1529     0 0.0 11/30/2020 02:51:40 PM
99 04/25/2020 CO 12868 11533 1335 684 146 670 564 106 -2 -15.0 05/25/2020 03:38:40 PM
100 09/30/2020 FL 698051     1880 264 14317     174 2.0 10/01/2020 01:42:11 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
);