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 created_at

✎ 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
232 232 12/31/2020 WV 85334 69506 15828 1109 -3 1338     20 4.0 01/01/2021 02:49:07 PM Agree Not agree
406 406 12/31/2020 SD 99164     444 119 1488 1204 284 24 6.0 01/01/2021 02:49:07 PM N/A Agree
455 455 12/31/2020 NM 142864     1678 0 2477     41 0.0 01/01/2021 02:49:07 PM N/A Not agree
570 570 12/31/2020 MA 369341 359445 9896 6887 0 12365 12157 208 81 0.0 01/01/2021 02:49:07 PM Agree Agree
865 865 12/31/2020 GA 666452 566676 99776 11709 3210 10934 9872 1062 88 24.0 01/01/2021 02:49:07 PM Agree Agree
921 921 12/31/2020 PW 0     0 0 0     0 0.0 01/01/2021 02:49:07 PM    
1486 1486 12/31/2020 TN 586802 514459 72343 5993 1388 6907 5990 917 97 30.0 01/01/2021 02:49:07 PM Agree Agree
2126 2126 12/31/2020 AR 225138     2708 871 3676     39 19.0 01/01/2021 02:49:07 PM Not agree Not agree
2167 2167 12/31/2020 PR 77054 72327 4727 763 86 1521 1257 264 18 4.0 01/01/2021 02:49:07 PM Agree Agree
2433 2433 12/31/2020 UT 276612 276612 0 4672 0 1269 1244 25 13 2.0 01/01/2021 02:49:07 PM Agree Agree
2533 2533 12/31/2020 MP 122 122 0 0 0 2 2 0 0 0.0 01/01/2021 02:49:07 PM Agree Agree
2644 2644 12/31/2020 NYC 438270 386824 51446 6091 1202 25187 20382 4805 43 -7.0 01/01/2021 02:49:07 PM Agree Agree
2652 2652 12/31/2020 AS 3     0 0 0     0 0.0 01/01/2021 02:49:07 PM    
3398 3398 12/31/2020 PA 640325 574364 65961 8992 1909 15978     306 237.0 01/01/2021 02:49:07 PM Agree Not agree
3523 3523 12/31/2020 AK 45461     495 0 205     3 0.0 01/01/2021 02:49:07 PM N/A N/A
3882 3882 12/31/2020 RMI 4 4 0 0 0 0 0 0 0 0.0 01/01/2021 02:49:07 PM Agree Agree
4657 4657 12/31/2020 KS 222433 186199 36234 0 0 2741     0 0.0 01/01/2021 02:49:07 PM Agree N/A
4891 4891 12/31/2020 IA 280669     1710 392 3891     69 69.0 01/01/2021 02:49:07 PM Not agree Not agree
4926 4926 12/31/2020 TX 1756172     18725 3740 27437     349 0.0 01/01/2021 02:49:07 PM Not agree Not agree
5087 5087 12/31/2020 GU 7308     0 0 121     0 0.0 01/01/2021 02:49:07 PM Not agree Not agree
5871 5871 12/31/2020 VT 7412     136 4 136     2 0.0 01/01/2021 02:49:07 PM Not agree Not agree
6679 6679 12/31/2020 IN 511485     6468 0 8263 7911 352 103 4.0 01/01/2021 02:49:07 PM Not agree Agree
7065 7065 12/31/2020 MS 218386 148911 69475 2575 1629 4816 3834 982 29 20.0 01/01/2021 02:49:07 PM Agree Agree
7365 7365 12/31/2020 NE 166798     1501 0 1651     40 0.0 01/01/2021 02:49:07 PM Not agree Not agree
7366 7366 12/31/2020 RI 87949     0 0 1777     0 0.0 01/01/2021 02:49:07 PM Not agree N/A
7696 7696 12/31/2020 IL 963389 963389 0 8009 0 17978 16490 1488 167 34.0 01/01/2021 02:49:07 PM Agree Agree
7764 7764 12/31/2020 MN 415302     2195 400 5382 5151 231 61 10.0 01/01/2021 02:49:07 PM N/A Agree
7918 7918 12/31/2020 LA 315275     4046 717 7488 7115 373 40 3.0 01/01/2021 02:49:07 PM Not agree Agree
8547 8547 12/31/2020 MD 280219     3557 0 5942 5774 168 47 0.0 01/01/2021 02:49:07 PM N/A Agree
8652 8652 12/31/2020 VI 2036     5 0 23     0 0.0 01/01/2021 02:49:07 PM    
9022 9022 12/31/2020 ID 141077 116717 24360 1213 346 1436 1269 167 33 4.0 01/01/2021 02:49:07 PM Agree Agree
9462 9462 12/31/2020 ND 92770 89730 3040 275 70 1309     17 0.0 01/01/2021 02:49:07 PM Agree Not agree
10083 10083 12/31/2020 AL 361226 290581 70645 4406 998 4827 4219 608 53 8.0 01/01/2021 02:49:07 PM Agree Agree
10165 10165 12/31/2020 ME 24201 20637 3564 13 3 347 341 6 3 1.0 01/01/2021 02:49:07 PM Agree Agree
10385 10385 12/31/2020 NC 539545 493951 45594 6715 731 6748 6342 406 19 2.0 01/01/2021 02:49:07 PM Agree Agree
12224 12224 12/31/2020 AZ 520207 495117 25090 7718 904 8864 8006 858 146 32.0 01/01/2021 02:49:07 PM Agree Agree
13685 13685 12/31/2020 DE 58064 55670 2394 1468 90 930 828 102 9 0.0 01/01/2021 02:49:07 PM Agree Agree
14075 14075 12/31/2020 OR 113909 112189 1720 1649 0 1477 1462 15 9 0.0 01/01/2021 02:49:07 PM Agree Agree
14378 14378 12/31/2020 WA 246752     4422 250 3461     41 0.0 01/01/2021 02:49:07 PM N/A N/A
15139 15139 12/31/2020 MI 528621 488144 40477 0 0 13018 12333 685 0 0.0 01/01/2021 02:49:07 PM Agree Agree
15195 15195 12/31/2020 VA 354767 297054 57713 5183 1575 5081 4478 603 49 8.0 01/01/2021 02:49:07 PM Agree Agree
15780 15780 12/31/2020 CA 2245379     27237 0 25386     428 0.0 01/01/2021 02:49:07 PM Not agree Not agree
16687 16687 12/31/2020 MT 81555 81555 0 255 0 961 961 0 11 0.0 01/01/2021 02:49:07 PM Agree Agree
17113 17113 12/31/2020 NH 44028     786 343 758     17 4.0 01/01/2021 02:49:07 PM Not agree Not agree
17128 17128 12/31/2020 WI 520438 481102 39336 4212 402 5242 4859 383 50 9.0 01/01/2021 02:49:07 PM Agree Agree
17769 17769 12/31/2020 KY 265262 213256 52006 0 0 2623 2446 177 0 0.0 01/01/2021 02:49:07 PM Agree Agree
17926 17926 12/31/2020 CT 185708 174679 11029 2045 273 5995 4854 1141 31 5.0 01/01/2021 02:49:07 PM Agree Agree
18172 18172 12/31/2020 NV 224731     2137 0 3125     59 0.0 01/01/2021 02:49:07 PM    
18326 18326 12/31/2020 DC 28983     225 0 786     6 0.0 01/01/2021 02:49:07 PM    
18717 18717 12/31/2020 FSM 0 0 0 0 0 0 0 0 0 0.0 01/01/2021 02:49:07 PM Agree Agree
18779 18779 12/31/2020 WY 44409 38010 6399 276 64 438 438 0 33 0.0 01/01/2021 02:49:07 PM Agree Agree
19009 19009 12/31/2020 MO 392570     3714 0 5519     28 0.0 01/01/2021 02:49:07 PM Not agree Not agree
19471 19471 12/31/2020 CO 334097 320021 14076 3238 249 4814 4168 646 64 7.0 01/01/2021 02:49:07 PM Agree Agree
21220 21220 12/31/2020 OH 700380 628336 72044 9632 1477 8962 8112 850 107 4.0 01/01/2021 02:49:07 PM Agree Agree
21470 21470 12/31/2020 FL 1300528     16827 0 21673     127 0.0 01/01/2021 02:49:07 PM Not agree Not agree
21546 21546 12/31/2020 OK 302148 243736 58412 4979 1010 2534 2367 167 38 3.0 01/01/2021 02:49:07 PM Agree Agree
21854 21854 12/31/2020 NY 548154     10809 0 12566     100 0.0 01/01/2021 02:49:07 PM Not agree Not agree
23810 23810 12/31/2020 HI 21026     175 0 286     3 0.0 01/01/2021 02:49:07 PM Not agree Not 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
358 358 01/01/2021 NM 144142     1278 0 2502     25 0.0 01/02/2021 02:50:51 PM N/A Not agree
434 434 01/01/2021 UT 279722 279722 0 3110 0 1278 1252 26 9 1.0 01/02/2021 02:50:51 PM Agree Agree
656 656 01/01/2021 MP 122 122 0 0 0 2 2 0 0 0.0 01/02/2021 02:50:51 PM Agree Agree
862 862 01/01/2021 SD 99164     0 0 1488 1204 284 0 0.0 01/02/2021 02:50:51 PM N/A Agree
879 879 01/01/2021 PW 0     0 0 0     0 0.0 01/02/2021 02:50:51 PM    
2058 2058 01/01/2021 TX 1772483     16311 3803 27771     334 0.0 01/02/2021 02:50:51 PM Not agree Not agree
2799 2799 01/01/2021 KS 227745 190300 37445 5312 1211 2879     138 32.0 01/02/2021 02:50:51 PM Agree N/A
3517 3517 01/01/2021 IA 282664     1995 403 3898     7 7.0 01/02/2021 02:50:51 PM Not agree Not agree
4119 4119 01/01/2021 RMI 4 4 0 0 0 0 0 0 0 0.0 01/02/2021 02:50:51 PM Agree Agree
4258 4258 01/01/2021 CO 337161 322944 14217 3064 141 4873 4221 652 59 6.0 01/02/2021 02:50:51 PM Agree Agree
4997 4997 01/01/2021 OH 700380 628336 72044 0 0 8962 8112 850 0 0.0 01/02/2021 02:50:51 PM Agree Agree
6542 6542 01/01/2021 DC 29252     269 0 788     2 0.0 01/02/2021 02:50:51 PM    
6904 6904 01/01/2021 NH 44028     0 0 758     0 0.0 01/02/2021 02:50:51 PM Not agree Not agree
7821 7821 01/01/2021 LA 315275     0 0 7488 7115 373 0 0.0 01/02/2021 02:50:51 PM Not agree Agree
8079 8079 01/01/2021 GU 7308     0 0 121     0 0.0 01/02/2021 02:50:51 PM Not agree Not agree
8415 8415 01/01/2021 MN 415302     0 0 5382 5151 231 0 0.0 01/02/2021 02:50:51 PM N/A Agree
8529 8529 01/01/2021 RI 87949     0 0 1777     0 0.0 01/02/2021 02:50:51 PM Not agree N/A
8668 8668 01/01/2021 CT 185708 174679 11029 0 0 5995 4854 1141 0 0.0 01/02/2021 02:50:51 PM Agree Agree
8890 8890 01/01/2021 IN 517773     6288 0 8371 8016 355 108 3.0 01/02/2021 02:50:51 PM Not agree Agree
8943 8943 01/01/2021 WA 246752     0 0 3461     0 0.0 01/02/2021 02:50:51 PM N/A N/A
9637 9637 01/01/2021 WI 522523 483007 39516 2085 180 5254 4869 385 12 2.0 01/02/2021 02:50:51 PM Agree Agree
9784 9784 01/01/2021 MI 528621 488144 40477 0 0 13018 12333 685 0 0.0 01/02/2021 02:50:51 PM Agree Agree
10084 10084 01/01/2021 KY 265262 213256 52006 0 0 2623 2446 177 0 0.0 01/02/2021 02:50:51 PM Agree Agree
10104 10104 01/01/2021 NC 539545 493951 45594 0 0 6748 6342 406 0 0.0 01/02/2021 02:50:51 PM Agree Agree
10128 10128 01/01/2021 ND 92891 89829 3062 121 22 1310     1 0.0 01/02/2021 02:50:51 PM Agree Not agree
10266 10266 01/01/2021 MS 220277 149595 70682 1891 1207 4840 3840 1000 24 18.0 01/02/2021 02:50:51 PM Agree Agree
10571 10571 01/01/2021 ME 25243 21410 3833 1042 269 358 352 6 11 0.0 01/02/2021 02:50:51 PM Agree Agree
10976 10976 01/01/2021 FSM 0 0 0 0 0 0 0 0 0 0.0 01/02/2021 02:50:51 PM Agree Agree
11505 11505 01/01/2021 CA 2292568     47189 0 25971     585 0.0 01/02/2021 02:50:51 PM Not agree Not agree
11720 11720 01/01/2021 AZ 530267 503798 26469 10060 1379 9015 8128 887 151 29.0 01/02/2021 02:50:51 PM Agree Agree
12039 12039 01/01/2021 NE 167716     918 0 1668     17 0.0 01/02/2021 02:50:51 PM Not agree Not agree
13017 13017 01/01/2021 DE 58064 55670 2394 0 0 930 828 102 0 0.0 01/02/2021 02:50:51 PM Agree Agree
13261 13261 01/01/2021 MT 81555 81555 0 0 0 961 961 0 0 0.0 01/02/2021 02:50:51 PM Agree Agree
13503 13503 01/01/2021 MD 283171     2952 0 5967 5799 168 25 0.0 01/02/2021 02:50:51 PM N/A Agree
14292 14292 01/01/2021 MO 397299     4729 0 5540     21 0.0 01/02/2021 02:50:51 PM Not agree Not agree
14573 14573 01/01/2021 OR 113909 112189 1720 0 0 1477 1462 15 0 0.0 01/02/2021 02:50:51 PM Agree Agree
15194 15194 01/01/2021 WY 44409 38010 6399 0 0 438 438 0 0 0.0 01/02/2021 02:50:51 PM Agree Agree
15606 15606 01/01/2021 VT 7590     178 5 137     1 0.0 01/02/2021 02:50:51 PM Not agree Not agree
15673 15673 01/01/2021 NV 227046     2315 0 3146     21 0.0 01/02/2021 02:50:51 PM    
16049 16049 01/01/2021 AL 365747 294466 71281 4521 636 4872 4254 618 45 10.0 01/02/2021 02:50:51 PM Agree Agree
17197 17197 01/01/2021 IL 963389 963389 0 0 0 18173 16647 1526 195 38.0 01/02/2021 02:50:51 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
);