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 new_death

View and edit SQL

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
4673 04/07/2020 NY 61897     -10427   1378     -1824   04/07/2020 04:22:39 PM
20787 04/13/2020 NYC 106813     3605   6182     -537   04/12/2020 04:22:39 PM
21106 11/11/2020 GA 413415 377336 36079 2232 568 8333 8333 0 -397 -466.0 11/12/2020 09:55:21 AM
21493 11/15/2020 TX 1108402     -30134 1362 19559     -367 0.0 02/19/2021 01:40:11 PM
4194 05/21/2020 PA 66258 64551 1707 1846 1707 4418     -349 60.0 05/22/2020 03:31:45 PM
21302 04/23/2020 PA 37053 36665 388 1369 -251 1421     -201 -270.0 05/25/2020 03:38:40 PM
11500 09/30/2020 NJ 210588     814 102 16122 14335 1787 -175 -184.0 02/19/2021 01:38:31 PM
23575 02/28/2021 AR 322415     3220 1216 5243     -174 -68.0 03/01/2021 03:21:38 PM
8886 12/10/2020 WA 192413     2550 0 2850     -166 0.0 12/11/2020 03:06:51 PM
8081 05/20/2020 IL 100418 100418 0 2388 0 4225 4225 0 -154 0.0 05/21/2020 03:41:38 PM
20852 09/14/2020 GA 309018 293632 15386 1384 351 6353 6353 0 -91 0.0 09/15/2020 10:03:59 AM
17417 01/08/2021 NE 174614     1023 0 1733     -78 0.0 01/09/2021 03:26:08 PM
4860 06/03/2020 MA 101592 97964 3628 429 4 7012 7012 0 -73 -141.0 06/04/2020 03:03:31 PM
4223 05/15/2020 MA 83421 83421 0 1239 0 5592 5592 0 -57 -5482.0 05/16/2020 03:46:44 PM
18972 10/21/2020 NV 92064     472 -93 1732     -42 -47.0 10/22/2020 01:34:46 PM
2299 06/30/2020 MA 108882 103701 5181 114 41 8054 7874 180 -41 -20.0 07/01/2020 03:45:16 PM
5285 07/13/2020 WA 41757     1101 0 1399     -39 0.0 07/14/2020 03:13:07 PM
7581 08/26/2020 NJ 193632     337 52 15914 14134 1780 -39 -49.0 02/19/2021 01:38:31 PM
12189 04/29/2020 AZ 7202 7202 0 254 0 254 254 0 -39 0.0 04/30/2020 04:07:01 PM
11907 07/22/2020 NJ 179574     445 56 15707 13787 1920 -30 -54.0 02/19/2021 01:38:31 PM
5622 10/15/2020 MN 117106     1163 61 2199 2192 7 -28 -46.0 10/16/2020 01:33:55 PM
14585 07/29/2020 NJ 182977     506 35 15798 13923 1875 -27 -45.0 02/19/2021 01:38:31 PM
15226 05/06/2020 LA 30399     330 -73 2094 2021 73 -21 0.0 05/07/2020 10:59:02 PM
12040 05/02/2020 LA 29140     429 0 1950 1907 43 -20 0.0 05/03/2020 03:36:03 PM
13386 07/04/2020 ID 7370 6779 591 376 -2 93 73 20 -20 0.0 07/05/2020 03:00:14 PM
747 09/07/2020 MA 130942 121046 9896 319 97 9133 8925 208 -19 -27.0 09/08/2020 02:47:00 PM
14870 04/20/2020 AL 5424 5191 233 478 233 147 146 1 -18 1.0 04/20/2020 04:22:39 PM
1786 07/13/2020 OK 20401 20245 156 467 11 424 424 0 -17 0.0 07/14/2020 03:13:07 PM
5078 06/09/2020 NV 10030     225 -19 444     -17 -19.0 06/10/2020 08:56:25 PM
14716 06/01/2020 NV 8688     78 -17 421     -17 -17.0 06/02/2020 02:16:17 PM
18975 06/14/2020 NV 11173     209 -18 464     -17 -18.0 06/15/2020 02:33:03 PM
14738 06/16/2020 NV 11658     361 -18 467     -16 -18.0 06/17/2020 03:06:04 PM
15970 06/04/2020 NV 9090     139 -16 429     -16 -16.0 06/05/2020 03:17:07 PM
17509 05/26/2020 NV 7998     110 -16 396     -16 -16.0 05/27/2020 03:37:59 PM
13979 03/28/2020 NV 738     117   14     -15   03/28/2020 04:22:39 PM
15660 08/05/2020 NJ 185824     403 46 15842 13989 1853 -15 -22.0 02/19/2021 01:38:31 PM
16043 06/06/2020 NV 9460     175 -19 437     -15 -19.0 06/07/2020 02:23:35 PM
9960 06/12/2020 NV 10678     261 -18 462     -14 -18.0 06/13/2020 05:46:26 PM
21687 06/06/2020 GA 50126 50094 32 583 0 2160 2160 0 -14 0.0 06/07/2020 10:23:35 AM
18392 12/18/2020 WA 220268     3063 124 3104     -13 50.0 12/19/2020 02:42:31 PM
12499 07/18/2020 NJ 178551     287 24 15672 13725 1947 -12 -27.0 02/19/2021 01:38:31 PM
16970 05/29/2020 NV 8350     125 -17 415     -12 -17.0 05/30/2020 03:47:59 PM
6962 12/25/2020 NE 161162     805 0 1558     -10 0.0 12/26/2020 02:34:18 PM
16895 05/22/2020 NV 7401     130 -16 387     -10 -16.0 05/23/2020 05:58:16 PM
19428 09/05/2020 MA 130253 120454 9799 438 22 9116 8907 209 -10 -25.0 09/06/2020 02:09:04 PM
23020 06/14/2020 OK 8231 8231 0 591 -11 359 359 0 -10 0.0 06/15/2020 02:33:03 PM
24210 07/06/2020 CO 34257 31368 2889 192 -8 1691 1367 324 -10 -12.0 07/07/2020 02:58:02 PM
2008 12/22/2020 CO 313552 300691 12861 2516 242 4369 3747 622 -9 13.0 12/23/2020 02:36:58 PM
5797 09/19/2020 ID 37247 34149 3098 288 40 441 403 38 -9 0.0 09/20/2020 01:53:10 PM
7954 06/27/2020 ND 3458 3458 0 37 0 78     -9 -9.0 06/28/2020 02:59:02 PM
10040 07/04/2020 ND 3779 3779 0 57 0 80     -9 -9.0 07/05/2020 03:00:14 PM
12327 09/07/2020 AL 133604 121879 11725 1290 226 2267 2153 114 -9 -10.0 09/08/2020 02:47:00 PM
19454 07/04/2020 OK 15645 15645 0 1428 -96 398 398 0 -9 0.0 07/05/2020 03:00:14 PM
639 11/22/2020 OK 186136 156527 29609 3543 803 1651 1590 61 -8 -5.0 11/23/2020 03:04:35 PM
5586 09/24/2020 AL 148206 133433 14773 1053 72 2480 2349 131 -8 -22.0 09/25/2020 01:54:10 PM
5803 07/12/2020 WI 39877 36448 3429 797 28 820 820 0 -8 -7.0 07/13/2020 03:19:34 PM
6952 05/13/2020 MN 12917     0 0 638 638 0 -8 -8.0 05/14/2020 05:25:44 PM
9903 06/30/2020 NV 18684     553 -9 529     -7 0.0 07/01/2020 03:45:16 PM
15095 01/31/2021 NJ 696829 623541 73288 4286 477 21484 19355 2129 -7 0.0 02/01/2021 02:50:29 PM
15760 09/19/2020 NV 75607     323 0 1558     -7 -6.0 09/20/2020 01:53:10 PM
21892 06/25/2020 OK 11948 11948 0 1189 -19 375 375 0 -7 0.0 06/26/2020 07:18:27 PM
6094 05/19/2020 NV 7046     125 -15 373     -6 -15.0 05/20/2020 03:28:26 PM
6574 11/05/2020 VA 188771 173646 15125 1568 341 3682 3432 250 -6 -12.0 11/06/2020 03:33:41 PM
23770 07/03/2020 PA 89375 86813 2562 634 26 6740     -6 -80.0 07/04/2020 03:30:31 PM
1267 12/08/2020 NYC 348211 315788 32423 4567 1671 24411 19694 4717 -5 -8.0 12/09/2020 02:45:40 PM
2117 05/16/2020 OK 4861 4854 7 -110 0 283 283 0 -5 0.0 05/17/2020 03:27:46 PM
10009 05/16/2020 NV 6662     33 -15 349     -5 -15.0 05/17/2020 03:27:46 PM
16852 06/17/2020 WA 26784     253 0 1226     -5 0.0 06/18/2020 05:16:14 PM
17262 08/12/2020 NJ 188697     518 55 15885 14046 1839 -5 -14.0 02/19/2021 01:38:31 PM
5918 07/09/2020 ND 4070 4070 0 99 0 85     -4 -4.0 07/10/2020 03:35:06 PM
11848 07/12/2020 NV 27894     1032 187 617     -4 -5.0 07/13/2020 03:19:34 PM
12389 08/08/2020 MI 96191 86889 9302 721 23 6520 6250 270 -4 -7.0 08/09/2020 02:03:10 PM
19448 08/19/2020 NYC 232371 227724 4647 303 -2 23639 19003 4636 -4 -2.0 08/20/2020 03:11:45 PM
21694 09/18/2020 NYC 240822 235461 5361 635 1 23771 19146 4625 -4 -3.0 09/19/2020 02:00:26 PM
6244 06/16/2020 ND 3124 3124 0 23 0 74     -3 -3.0 06/17/2020 03:06:04 PM
6992 02/22/2021 AZ 809474 755051 54423 1507 36 15502 13692 1810 -3 -1.0 02/23/2021 02:51:13 PM
16494 05/14/2020 NV 6499     94 -11 339     -3 -11.0 05/15/2020 04:11:22 PM
18830 07/21/2020 NE 23190     343 0 310     -3 0.0 07/22/2020 02:51:28 PM
20153 05/11/2020 OK 4439 4432 7 -150 7 269 269 0 -3 0.0 05/12/2020 05:26:08 PM
20860 09/08/2020 NYC 237070 232232 4838 202 6 23741 19098 4643 -3 -3.0 09/09/2020 01:47:50 PM
99 04/25/2020 CO 12868 11533 1335 684 146 670 564 106 -2 -15.0 05/25/2020 03:38:40 PM
710 04/20/2020 MP 14     0   0 0 0 -2 0.0 04/20/2020 04:22:39 PM
891 05/29/2020 GA 44145 44116 29 626 5 1971 1971 0 -2 0.0 05/30/2020 11:47:59 AM
1377 06/28/2020 UT 21450 21450 0 464 0 168 168 0 -2 0.0 06/29/2020 02:37:31 PM
5342 07/14/2020 NE 21717     318 0 286     -2 0.0 07/15/2020 03:05:12 PM
5916 10/14/2020 MO 148679     4449 0 2420     -2 0.0 10/15/2020 01:30:46 PM
9943 10/05/2020 NV 82529     325 -12 1663     -2 -2.0 10/06/2020 01:33:58 PM
11042 01/03/2021 WA 255396     8644 428 3459     -2 0.0 01/04/2021 02:55:45 PM
14960 01/20/2021 ID 157588 128633 28955 810 244 1635 1436 199 -2 0.0 01/21/2021 02:44:32 PM
16388 02/02/2021 WA 314692     1357 437 4316     -2 0.0 02/03/2021 02:55:58 PM
18591 09/07/2020 AZ 205964 204157 1807 198 10 5219 4945 274 -2 0.0 09/08/2020 02:47:00 PM
20011 09/21/2020 NYC 241631 236253 5378 294 10 23780 19153 4627 -2 -3.0 09/22/2020 01:51:57 PM
20768 10/02/2020 NYC 246739 240873 5866 670 61 23844 19207 4637 -2 -3.0 10/03/2020 01:39:53 PM
20914 05/07/2020 TN 14166 14096 70 228 70 237 237 0 -2 0.0 05/08/2020 09:26:08 PM
21047 04/25/2020 GA 22223 22212 11 686 0 897 897 0 -2 0.0 05/25/2020 11:38:40 AM
22472 09/10/2020 NYC 237752 232926 4826 201 -15 23739 19116 4623 -2 -19.0 09/11/2020 01:51:03 PM
23676 04/24/2020 TN 8742 8742 0 461 -15 168 168 0 -2 0.0 05/25/2020 03:38:40 PM
869 09/12/2020 UT 58203 57719 484 692 7 432 432 0 -1 0.0 09/13/2020 04:17:15 PM
2471 06/02/2020 UT 10353 10353 0 252 0 113 113 0 -1 0.0 06/03/2020 02:11:36 PM
2490 07/25/2020 UT 38064 37770 294 383 1 273 273 0 -1 0.0 07/26/2020 03:17:16 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
);