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 tot_cases descending

✎ 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
7520 7520 02/28/2021 CA 3475562     4685 0 51979     158 0.0 03/01/2021 03:21:38 PM Not agree Not agree
6763 6763 02/27/2021 CA 3470877     5151 0 51821     439 0.0 02/28/2021 02:48:18 PM Not agree Not agree
10164 10164 02/26/2021 CA 3465726     5400 0 51382     391 0.0 02/27/2021 02:51:23 PM Not agree Not agree
18764 18764 02/25/2021 CA 3460326     4965 0 50991     1114 0.0 02/26/2021 03:02:41 PM Not agree Not agree
18344 18344 02/24/2021 CA 3455361     5303 0 49877     314 0.0 02/25/2021 02:54:32 PM Not agree Not agree
15868 15868 02/23/2021 CA 3450058     3447 0 49563     225 0.0 02/24/2021 02:56:12 PM Not agree Not agree
16039 16039 02/22/2021 CA 3446611     4665 0 49338     233 0.0 02/23/2021 02:51:13 PM Not agree Not agree
18072 18072 02/21/2021 CA 3441946     6760 0 49105     280 0.0 02/22/2021 02:53:38 PM Not agree Not agree
5812 5812 02/20/2021 CA 3435186     6668 0 48825     481 0.0 02/21/2021 02:57:50 PM Not agree Not agree
19103 19103 02/19/2021 CA 3428518     6798 0 48344     420 0.0 02/20/2021 02:45:37 PM Not agree Not agree
16667 16667 02/18/2021 CA 3421720     5573 0 47924     417 0.0 02/19/2021 03:33:51 PM Not agree Not agree
6479 6479 02/17/2021 CA 3416147     4090 0 47507     400 0.0 02/18/2021 02:43:57 PM Not agree Not agree
7693 7693 02/16/2021 CA 3412057     5692 0 47107     64 0.0 02/17/2021 02:51:58 PM Not agree Not agree
7883 7883 02/15/2021 CA 3406365     6487 0 47043     200 0.0 02/16/2021 02:53:06 PM Not agree Not agree
13431 13431 02/14/2021 CA 3399878     8842 0 46843     408 0.0 02/15/2021 02:46:24 PM Not agree Not agree
13646 13646 02/13/2021 CA 3391036     9421 0 46435     433 0.0 02/14/2021 02:51:00 PM Not agree Not agree
5782 5782 02/12/2021 CA 3381615     10059 0 46002     546 0.0 02/13/2021 02:50:08 PM Not agree Not agree
9579 9579 02/11/2021 CA 3371556     8575 0 45456     461 0.0 02/12/2021 02:56:38 PM Not agree Not agree
15656 15656 02/10/2021 CA 3362981     8390 0 44995     518 0.0 02/11/2021 02:50:55 PM Not agree Not agree
7757 7757 02/09/2021 CA 3354591     8251 0 44477     327 0.0 02/10/2021 02:52:16 PM Not agree Not agree
18185 18185 02/08/2021 CA 3346340     10414 0 44150     208 0.0 02/09/2021 03:24:29 PM Not agree Not agree
12094 12094 02/07/2021 CA 3335926     15064 0 43942     295 0.0 02/08/2021 02:53:12 PM Not agree Not agree
11727 11727 02/06/2021 CA 3320862     12394 0 43647     623 0.0 02/07/2021 02:46:31 PM Not agree Not agree
12902 12902 02/05/2021 CA 3308468     14021 0 43024     558 0.0 02/06/2021 04:05:17 PM Not agree Not agree
8618 8618 02/04/2021 CA 3294447     13176 0 42466     655 0.0 02/05/2021 02:54:41 PM Not agree Not agree
19190 19190 02/03/2021 CA 3281271     10501 0 41811     481 0.0 02/04/2021 02:53:58 PM Not agree Not agree
6102 6102 02/02/2021 CA 3270770     12064 0 41330     422 0.0 02/03/2021 02:55:58 PM Not agree Not agree
6081 6081 02/01/2021 CA 3258706     15358 0 40908     211 0.0 02/02/2021 02:51:51 PM Not agree Not agree
15871 15871 01/31/2021 CA 3243348     18974 0 40697     481 0.0 02/01/2021 02:50:29 PM Not agree Not agree
18900 18900 01/30/2021 CA 3224374     18427 0 40216     638 0.0 01/31/2021 02:48:12 PM Not agree Not agree
13673 13673 01/29/2021 CA 3205947     19337 0 39578     617 0.0 01/30/2021 02:43:11 PM Not agree Not agree
17814 17814 01/28/2021 CA 3186610     16696 0 38961     737 0.0 01/29/2021 02:42:19 PM Not agree Not agree
16291 16291 01/27/2021 CA 3169914     16728 0 38224     697 0.0 01/28/2021 02:49:07 PM Not agree Not agree
14327 14327 01/26/2021 CA 3153186     17028 0 37527     409 0.0 01/27/2021 02:53:24 PM Not agree Not agree
14857 14857 01/25/2021 CA 3136158     27007 0 37118     328 0.0 01/26/2021 02:46:01 PM Not agree Not agree
7405 7405 01/24/2021 CA 3109151     24111 0 36790     429 0.0 01/25/2021 02:42:40 PM Not agree Not agree
6698 6698 01/23/2021 CA 3085040     22972 0 36361     593 0.0 01/24/2021 02:36:49 PM Not agree Not agree
11587 11587 01/22/2021 CA 3062068     23024 0 35768     764 0.0 01/23/2021 02:50:13 PM Not agree Not agree
12955 12955 01/21/2021 CA 3039044     19673 0 35004     571 0.0 01/22/2021 02:51:49 PM Not agree Not agree
18269 18269 01/20/2021 CA 3019371     22403 0 34433     694 0.0 01/21/2021 02:44:32 PM Not agree Not agree
7137 7137 01/19/2021 CA 2996968     23794 0 33739     146 0.0 01/20/2021 02:44:03 PM Not agree Not agree
6380 6380 01/18/2021 CA 2973174     30699 0 33593     201 0.0 01/19/2021 02:37:00 PM Not agree Not agree
6601 6601 01/17/2021 CA 2942475     42229 0 33392     432 0.0 01/18/2021 02:39:32 PM Not agree Not agree
14782 14782 01/16/2021 CA 2900246     40622 0 32960     669 0.0 01/17/2021 03:43:14 PM Not agree Not agree
11634 11634 01/15/2021 CA 2859624     42655 0 32291     637 0.0 01/16/2021 02:46:10 PM Not agree Not agree
15838 15838 01/14/2021 CA 2816969     35930 0 31654     552 0.0 01/15/2021 02:46:04 PM Not agree Not agree
12986 12986 01/13/2021 CA 2781039     33751 0 31102     589 0.0 01/14/2021 03:12:46 PM Not agree Not agree
5334 5334 01/12/2021 CA 2747288     36487 0 30513     548 0.0 01/13/2021 02:44:58 PM Not agree Not agree
18285 18285 01/11/2021 CA 2710801     39839 0 29965     264 0.0 01/12/2021 02:48:35 PM Not agree Not agree
9803 9803 01/10/2021 CA 2670962     49685 0 29701     468 0.0 01/11/2021 03:01:02 PM Not agree Not agree
2620 2620 02/28/2021 TX 2644024     3815 739 42936     197 0.0 03/01/2021 03:21:38 PM Not agree Not agree
22508 22508 02/27/2021 TX 2640209     11073 2520 42739     164 0.0 02/28/2021 02:48:18 PM Not agree Not agree
612 612 02/26/2021 TX 2629136     7955 2320 42575     290 0.0 02/27/2021 02:51:23 PM Not agree Not agree
8635 8635 01/09/2021 CA 2621277     52636 0 29233     695 0.0 01/10/2021 04:10:55 PM Not agree Not agree
1812 1812 02/25/2021 TX 2621181     7389 2281 42285     305 0.0 02/26/2021 03:02:41 PM Not agree Not agree
1535 1535 02/24/2021 TX 2613792     7517 2161 41980     339 0.0 02/25/2021 02:54:32 PM Not agree Not agree
3652 3652 02/23/2021 TX 2606275     11809 3790 41641     234 0.0 02/24/2021 02:56:12 PM Not agree Not agree
4885 4885 02/22/2021 TX 2594466     6365 611 41407     64 0.0 02/23/2021 02:51:13 PM Not agree Not agree
705 705 02/21/2021 TX 2588101     4484 658 41343     130 0.0 02/22/2021 02:53:38 PM Not agree Not agree
21536 21536 02/20/2021 TX 2583617     6486 1454 41213     227 0.0 02/21/2021 02:57:50 PM Not agree Not agree
24032 24032 02/19/2021 TX 2577131     2937 667 40986     172 0.0 02/20/2021 02:45:37 PM Not agree Not agree
2995 2995 02/18/2021 TX 2574194     3131 342 40814     97 0.0 02/19/2021 03:33:51 PM Not agree Not agree
20954 20954 02/17/2021 TX 2571063     3766 1057 40717     72 0.0 02/18/2021 02:43:57 PM Not agree Not agree
6514 6514 01/08/2021 CA 2568641     50030 0 28538     493 0.0 01/09/2021 03:26:08 PM Not agree Not agree
1760 1760 02/16/2021 TX 2567297     3348 -261 40645     52 0.0 02/17/2021 02:51:58 PM Not agree Not agree
23459 23459 02/15/2021 TX 2563949     3889 445 40593     66 0.0 02/16/2021 02:53:06 PM Not agree Not agree
1940 1940 02/14/2021 TX 2560060     6933 863 40527     149 0.0 02/15/2021 02:46:24 PM Not agree Not agree
4024 4024 02/13/2021 TX 2553127     11282 2379 40378     283 0.0 02/14/2021 02:51:00 PM Not agree Not agree
2283 2283 02/12/2021 TX 2541845     12502 2402 40095     324 0.0 02/13/2021 02:50:08 PM Not agree Not agree
21926 21926 02/11/2021 TX 2529343     11890 2858 39771     385 0.0 02/12/2021 02:56:38 PM Not agree Not agree
13347 13347 01/07/2021 CA 2518611     36385 0 28045     583 0.0 01/08/2021 03:56:01 PM Not agree Not agree
22757 22757 02/10/2021 TX 2517453     12897 2619 39386     385 0.0 02/11/2021 02:50:55 PM Not agree Not agree
19671 19671 02/09/2021 TX 2504556     13329 2676 39001     301 0.0 02/10/2021 02:52:16 PM Not agree Not agree
23416 23416 02/08/2021 TX 2491227     7485 664 38700     57 0.0 02/09/2021 03:24:29 PM Not agree Not agree
2238 2238 02/07/2021 TX 2483742     6959 1539 38643     167 0.0 02/08/2021 02:53:12 PM Not agree Not agree
9485 9485 01/06/2021 CA 2482226     29892 0 27462     459 0.0 01/07/2021 02:56:59 PM Not agree Not agree
19256 19256 02/06/2021 TX 2476783     13897 2572 38476     348 0.0 02/07/2021 02:46:31 PM Not agree Not agree
23798 23798 02/05/2021 TX 2462886     14493 3735 38128     401 0.0 02/06/2021 04:05:17 PM Not agree Not agree
16729 16729 01/05/2021 CA 2452334     31440 0 27003     368 0.0 01/06/2021 02:58:26 PM Not agree Not agree
3162 3162 02/04/2021 TX 2448393     15283 2987 37727     439 0.0 02/05/2021 02:54:41 PM Not agree Not agree
1796 1796 02/03/2021 TX 2433110     17620 4050 37288     418 0.0 02/04/2021 02:53:58 PM Not agree Not agree
10184 10184 01/04/2021 CA 2420894     29633 0 26635     97 0.0 01/05/2021 03:00:42 PM Not agree Not agree
22161 22161 02/02/2021 TX 2415490     23047 3488 36870     331 0.0 02/03/2021 02:55:58 PM Not agree Not agree
19349 19349 02/01/2021 TX 2392443     31811 3784 36539     48 0.0 02/02/2021 02:51:51 PM Not agree Not agree
11844 11844 01/03/2021 CA 2391261     45352 0 26538     181 0.0 01/04/2021 02:55:45 PM Not agree Not agree
20723 20723 01/31/2021 TX 2360632     11370 1282 36491     171 0.0 02/01/2021 02:50:29 PM Not agree Not agree
23859 23859 01/30/2021 TX 2349262     19234 3532 36320     332 0.0 01/31/2021 02:48:12 PM Not agree Not 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
1098 1098 01/29/2021 TX 2330028     19076 3850 35988     349 0.0 01/30/2021 02:43:11 PM Not agree Not agree
22034 22034 01/28/2021 TX 2310952     18220 3228 35639     471 0.0 01/29/2021 02:42:19 PM Not agree Not agree
2429 2429 01/27/2021 TX 2292732     19613 4541 35168     467 0.0 01/28/2021 02:49:07 PM Not agree Not 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
22606 22606 01/26/2021 TX 2273119     26274 3796 34701     307 0.0 01/27/2021 02:53:24 PM Not agree Not agree
1633 1633 01/25/2021 TX 2246845     6319 795 34394     72 0.0 01/26/2021 02:46:01 PM Not agree Not 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
23564 23564 01/24/2021 TX 2240526     11565 1389 34322     208 0.0 01/25/2021 02:42:40 PM Not agree Not agree
24014 24014 01/23/2021 TX 2228961     17672 3534 34114     407 0.0 01/24/2021 02:36:49 PM Not agree Not agree
10397 10397 12/30/2020 CA 2218142     30921 0 24958     432 0.0 12/31/2020 02:55:07 PM Not agree Not agree
23300 23300 01/22/2021 TX 2211289     22646 4412 33707     422 0.0 01/23/2021 02:50:13 PM Not agree Not agree
4574 4574 01/21/2021 TX 2188643     22360 3396 33285     441 0.0 01/22/2021 02:51:49 PM Not agree Not 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
);