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 submission_date

✎ 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
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    
6620 6620 01/01/2021 SC 321357 289923 31434 5523 1026 5642     57 10.0 02/26/2021 03:36:37 PM Agree Not agree
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
17363 17363 01/01/2021 ID 141077 116717 24360 0 0 1436 1269 167 0 0.0 01/02/2021 02:50:51 PM Agree Agree
17723 17723 01/01/2021 VA 358755 299963 58792 3988 1079 5117 4509 608 36 5.0 01/02/2021 02:50:51 PM Agree Agree
18187 18187 01/01/2021 NJ 533587     5803 302 19160 17139 2021 118 0.0 02/19/2021 01:38:31 PM Not agree Agree
18559 18559 01/01/2021 VI 2036     0 0 23     0 0.0 01/02/2021 02:50:51 PM    
19192 19192 01/01/2021 FL 1300528     0 6063 21673     0 7.0 01/02/2021 02:50:51 PM Not agree Not agree
19417 19417 01/01/2021 AK 45461     0 0 205     0 0.0 01/02/2021 02:50:51 PM N/A N/A
20647 20647 01/01/2021 NY 559358     11204 0 12701     135 0.0 01/02/2021 02:50:51 PM Not agree Not agree
21037 21037 01/01/2021 WV 87820 71250 16570 2486 742 1361     23 5.0 01/02/2021 02:50:51 PM Agree Not agree
21975 21975 01/01/2021 AR 229442     4304 1519 3711     35 17.0 01/02/2021 02:50:51 PM Not agree Not agree
22054 22054 01/01/2021 HI 21258     232 0 287     1 0.0 01/02/2021 02:50:51 PM Not agree Not agree
22374 22374 01/01/2021 PA 648039 581260 66779 7714 818 16214     236 -75.0 01/02/2021 02:50:51 PM Agree Not agree
22469 22469 01/01/2021 TN 586802 514459 72343 0 0 6907 5990 917 0 0.0 01/02/2021 02:50:51 PM Agree Agree
22557 22557 01/01/2021 AS 3     0 0 0     0 0.0 01/02/2021 02:50:51 PM    
23000 23000 01/01/2021 OK 302148 243736 58412 0 0 2534 2367 167 0 0.0 01/02/2021 02:50:51 PM Agree Agree
23744 23744 01/01/2021 PR 77932 73162 4770 878 43 1526 1261 265 5 1.0 01/02/2021 02:50:51 PM Agree Agree
24050 24050 01/01/2021 GA 677589 575395 102194 11137 2418 10958 9889 1069 24 7.0 01/02/2021 02:50:51 PM Agree Agree
24066 24066 01/01/2021 MA 369341 359445 9896 0 0 12365 12157 208 0 0.0 01/02/2021 02:50:51 PM Agree Agree
43 43 01/02/2021 AR 231442     2000 403 3729     18 3.0 01/03/2021 02:53:25 PM Not agree Not agree
270 270 01/02/2021 UT 281654 281654 0 1932 0 1294 1266 28 16 2.0 01/03/2021 02:53:25 PM Agree Agree
515 515 01/02/2021 NYC 447644 394234 53410 3809 1122 25244 20432 4812 33 8.0 01/03/2021 02:53:25 PM Agree Agree
670 670 01/02/2021 OH 714673 640812 73861 14293 1817 9017 8154 863 55 13.0 01/03/2021 02:53:25 PM Agree Agree
1518 1518 01/02/2021 GA 685122 581999 103123 7533 929 10960 9891 1069 2 0.0 01/03/2021 02:53:25 PM Agree Agree
1610 1610 01/02/2021 HI 21417     159 0 287     0 0.0 01/03/2021 02:53:25 PM Not agree Not agree
3675 3675 01/02/2021 AK 46262     801 0 214     9 0.0 01/03/2021 02:53:25 PM N/A N/A
3795 3795 01/02/2021 MP 122 122 0 0 0 2 2 0 0 0.0 01/03/2021 02:53:25 PM Agree Agree
4307 4307 01/02/2021 PR 78169 73399 4770 237 0 1545 1279 266 19 1.0 01/03/2021 02:53:25 PM Agree Agree
4758 4758 01/02/2021 OK 310071 250051 60020 7923 1608 2555 2386 169 21 2.0 01/03/2021 02:53:25 PM Agree Agree
5263 5263 01/02/2021 LA 315275     0 0 7488 7115 373 0 0.0 01/03/2021 02:53:25 PM Not agree Agree
5480 5480 01/02/2021 CA 2345909     53341 0 26357     386 0.0 01/03/2021 02:53:25 PM Not agree Not agree
5749 5749 01/02/2021 NE 168262     546 0 1669     1 0.0 01/03/2021 02:53:25 PM Not agree Not agree
5949 5949 01/02/2021 MS 222061 150385 71676 1784 994 4871 3857 1014 31 14.0 01/03/2021 02:53:25 PM Agree Agree
6265 6265 01/02/2021 ND 93041 89955 3086 150 24 1310     0 0.0 01/03/2021 02:53:25 PM Agree Not agree
6683 6683 01/02/2021 AZ 539150 512047 27103 8883 634 9061 8166 895 46 8.0 01/03/2021 02:53:25 PM Agree Agree
6857 6857 01/02/2021 ME 25590 21691 3899 347 66 359 353 6 1 0.0 01/03/2021 02:53:25 PM Agree Agree
6908 6908 01/02/2021 VA 363765 303881 59884 5010 1092 5124 4516 608 7 0.0 01/03/2021 02:53:25 PM Agree Agree
7859 7859 01/02/2021 NC 558437 510515 47922 18892 2328 6892 6467 425 144 19.0 01/03/2021 02:53:25 PM Agree Agree
7989 7989 01/02/2021 IN 523090     5317 0 8410 8055 355 39 0.0 01/03/2021 02:53:25 PM Not agree Agree
8819 8819 01/02/2021 VT 7689     99 11 139     2 0.0 01/03/2021 02:53:25 PM Not agree Not agree
8911 8911 01/02/2021 NH 45184     1156 366 769     11 0.0 01/03/2021 02:53:25 PM Not agree Not agree
9000 9000 01/02/2021 GU 7308     0 0 121     0 0.0 01/03/2021 02:53:25 PM Not agree Not agree
9612 9612 01/02/2021 DC 29509     257 0 792     4 0.0 01/03/2021 02:53:25 PM    
10105 10105 01/02/2021 WI 523652 484085 39567 1129 51 5256 4870 386 2 1.0 01/03/2021 02:53:25 PM Agree Agree
10696 10696 01/02/2021 FSM 0 0 0 0 0 0 0 0 0 0.0 01/03/2021 02:53:25 PM Agree Agree
10705 10705 01/02/2021 NJ 539546     5959 448 19187 17166 2021 27 0.0 02/19/2021 01:38:31 PM Not agree Agree
10866 10866 01/02/2021 MO 399456     2157 0 5543     3 0.0 01/03/2021 02:53:25 PM Not agree Not agree
11437 11437 01/02/2021 SC 326946 294484 32462 5589 1028 5689     47 9.0 02/26/2021 03:36:37 PM Agree Not agree
11846 11846 01/02/2021 ID 142199 117636 24563 1122 203 1448 1281 167 12 0.0 01/03/2021 02:53:25 PM Agree Agree
12375 12375 01/02/2021 MD 285319     2148 0 5994 5826 168 27 0.0 01/03/2021 02:53:25 PM N/A Agree
12944 12944 01/02/2021 DE 58873 56455 2418 809 24 930 828 102 0 0.0 01/03/2021 02:53:25 PM Agree Agree
13861 13861 01/02/2021 MN 417832     2530 338 5436 5201 235 54 4.0 01/03/2021 02:53:25 PM N/A Agree
14751 14751 01/02/2021 AL 369458 297753 71705 3711 424 4872 4254 618 0 0.0 01/03/2021 02:53:25 PM Agree Agree
15739 15739 01/02/2021 CT 190120 178949 11171 4412 142 6099 4937 1162 104 21.0 01/03/2021 02:53:25 PM Agree Agree
16001 16001 01/02/2021 VI 2041     5 0 23     0 0.0 01/03/2021 02:53:25 PM    
16004 16004 01/02/2021 IL 975352 975352 0 11963 0 18217 16674 1543 44 17.0 01/03/2021 02:53:25 PM Agree Agree
16293 16293 01/02/2021 KY 273971 220231 53740 8709 1734 2698 2513 185 75 8.0 01/03/2021 02:53:25 PM Agree Agree
17226 17226 01/02/2021 OR 116348 114628 1720 2439 0 1492 1477 15 15 0.0 01/03/2021 02:53:25 PM Agree Agree
17577 17577 01/02/2021 WY 44573 38163 6410 164 11 438 438 0 0 0.0 01/03/2021 02:53:25 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
);