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 conf_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
7244 7244 02/28/2021 IL 1186696 1186696 0 1249 0 22735 20516 2219 25 3.0 03/01/2021 03:21:38 PM Agree Agree
17676 17676 02/27/2021 IL 1185447 1185447 0 1780 0 22710 20494 2216 35 1.0 02/28/2021 02:48:18 PM Agree Agree
14383 14383 02/26/2021 IL 1183667 1183667 0 2441 0 22675 20460 2215 68 14.0 02/27/2021 02:51:23 PM Agree Agree
13083 13083 02/25/2021 IL 1181226 1181226 0 1884 0 22607 20406 2201 32 0.0 02/26/2021 03:02:41 PM Agree Agree
18555 18555 02/24/2021 IL 1179342 1179342 0 2022 0 22575 20374 2201 47 3.0 02/25/2021 02:54:32 PM Agree Agree
13914 13914 02/23/2021 IL 1177320 1177320 0 1665 0 22528 20330 2198 22 -5.0 02/24/2021 02:56:12 PM Agree Agree
5829 5829 02/22/2021 IL 1175655 1175655 0 1246 0 22506 20303 2203 40 6.0 02/23/2021 02:51:13 PM Agree Agree
17140 17140 02/21/2021 IL 1174409 1174409 0 1585 0 22466 20269 2197 40 5.0 02/22/2021 02:53:38 PM Agree Agree
11338 11338 02/20/2021 IL 1172824 1172824 0 1922 0 22426 20234 2192 58 16.0 02/21/2021 02:57:50 PM Agree Agree
13441 13441 02/19/2021 IL 1170902 1170902 0 2219 0 22368 20192 2176 71 8.0 02/20/2021 02:45:37 PM Agree Agree
18973 18973 02/18/2021 IL 1168683 1168683 0 1966 0 22297 20129 2168 73 1.0 02/19/2021 03:33:51 PM Agree Agree
7998 7998 02/17/2021 IL 1166717 1166717 0 1795 0 22224 20057 2167 25 2.0 02/18/2021 02:43:57 PM Agree Agree
11131 11131 02/16/2021 IL 1164922 1164922 0 1348 0 22199 20034 2165 33 1.0 02/17/2021 02:51:58 PM Agree Agree
16904 16904 02/15/2021 IL 1163574 1163574 0 1420 0 22166 20002 2164 45 4.0 02/16/2021 02:53:06 PM Agree Agree
7408 7408 02/14/2021 IL 1162154 1162154 0 1631 0 22121 19961 2160 34 -1.0 02/15/2021 02:46:24 PM Agree Agree
9229 9229 02/13/2021 IL 1160523 1160523 0 2092 0 22087 19926 2161 60 7.0 02/14/2021 02:51:00 PM Agree Agree
9397 9397 02/12/2021 IL 1158431 1158431 0 2598 0 22027 19873 2154 42 10.0 02/13/2021 02:50:08 PM Agree Agree
12227 12227 02/11/2021 IL 1155833 1155833 0 2838 0 21985 19841 2144 116 14.0 02/12/2021 02:56:38 PM Agree Agree
13370 13370 02/10/2021 IL 1152995 1152995 0 2825 0 21869 19739 2130 67 14.0 02/11/2021 02:50:55 PM Agree Agree
18376 18376 02/09/2021 IL 1150170 1150170 0 2082 0 21802 19686 2116 23 5.0 02/10/2021 02:52:16 PM Agree Agree
15488 15488 02/08/2021 IL 1148088 1148088 0 1747 0 21779 19668 2111 41 6.0 02/09/2021 03:24:29 PM Agree Agree
8562 8562 02/07/2021 IL 1146341 1146341 0 2060 0 21738 19633 2105 62 14.0 02/08/2021 02:53:12 PM Agree Agree
10598 10598 02/06/2021 IL 1144281 1144281 0 3062 0 21676 19585 2091 73 14.0 02/07/2021 02:46:31 PM Agree Agree
13209 13209 02/05/2021 IL 1141219 1141219 0 3660 0 21603 19526 2077 106 24.0 02/06/2021 04:05:17 PM Agree Agree
18146 18146 02/04/2021 IL 1137559 1137559 0 3328 0 21497 19444 2053 77 8.0 02/05/2021 02:54:41 PM Agree Agree
17953 17953 02/03/2021 IL 1134231 1134231 0 3314 0 21420 19375 2045 84 15.0 02/04/2021 02:53:58 PM Agree Agree
6983 6983 02/02/2021 IL 1130917 1130917 0 2304 0 21336 19306 2030 63 16.0 02/03/2021 02:55:58 PM Agree Agree
15709 15709 02/01/2021 IL 1128613 1128613 0 2312 0 21273 19259 2014 20 4.0 02/02/2021 02:51:51 PM Agree Agree
12505 12505 01/31/2021 IL 1126301 1126301 0 2428 0 21253 19243 2010 40 0.0 02/01/2021 02:50:29 PM Agree Agree
7692 7692 01/30/2021 IL 1123873 1123873 0 3345 0 21213 19203 2010 67 2.0 01/31/2021 02:48:12 PM Agree Agree
14199 14199 01/29/2021 IL 1120528 1120528 0 4156 0 21146 19138 2008 72 1.0 01/30/2021 02:43:11 PM Agree Agree
18891 18891 01/28/2021 IL 1116372 1116372 0 4191 0 21074 19067 2007 125 22.0 01/29/2021 02:42:19 PM Agree Agree
11383 11383 01/27/2021 IL 1112181 1112181 0 3751 0 20949 18964 1985 96 15.0 01/28/2021 02:49:07 PM Agree Agree
14028 14028 01/26/2021 IL 1108430 1108430 0 3667 0 20853 18883 1970 109 24.0 01/27/2021 02:53:24 PM Agree Agree
10735 10735 01/25/2021 IL 1104763 1104763 0 2944 0 20744 18798 1946 64 16.0 01/26/2021 02:46:01 PM Agree Agree
11310 11310 01/24/2021 IL 1101819 1101819 0 3292 0 20680 18750 1930 35 -4.0 01/25/2021 02:42:40 PM Agree Agree
12993 12993 01/23/2021 IL 1098527 1098527 0 5152 0 20645 18711 1934 111 15.0 01/24/2021 02:36:49 PM Agree Agree
5961 5961 01/22/2021 IL 1093375 1093375 0 7042 0 20534 18615 1919 111 16.0 01/23/2021 02:50:13 PM Agree Agree
10268 10268 01/21/2021 IL 1086333 1086333 0 4979 0 20423 18520 1903 138 16.0 01/22/2021 02:51:49 PM Agree Agree
11610 11610 01/20/2021 IL 1081354 1081354 0 4822 0 20285 18398 1887 132 25.0 01/21/2021 02:44:32 PM Agree Agree
10731 10731 01/19/2021 IL 1076532 1076532 0 4318 0 20153 18291 1862 35 2.0 01/20/2021 02:44:03 PM Agree Agree
5071 5071 01/18/2021 IL 1072214 1072214 0 3385 0 20118 18258 1860 68 18.0 01/19/2021 02:37:00 PM Agree Agree
18897 18897 01/17/2021 IL 1068829 1068829 0 4162 0 20050 18208 1842 30 1.0 01/18/2021 02:39:32 PM Agree Agree
9681 9681 01/16/2021 IL 1064667 1064667 0 5343 0 20020 18179 1841 147 17.0 01/17/2021 03:43:14 PM Agree Agree
11411 11411 01/15/2021 IL 1059324 1059324 0 6642 0 19873 18049 1824 149 28.0 01/16/2021 02:46:10 PM Agree Agree
17059 17059 01/14/2021 IL 1052682 1052682 0 6652 0 19724 17928 1796 107 19.0 01/15/2021 02:46:04 PM Agree Agree
5291 5291 01/13/2021 IL 1046030 1046030 0 5862 0 19617 17840 1777 120 23.0 01/14/2021 03:12:46 PM Agree Agree
18055 18055 01/12/2021 IL 1040168 1040168 0 6642 0 19497 17743 1754 134 18.0 01/13/2021 02:44:58 PM Agree Agree
16174 16174 01/11/2021 IL 1033526 1033526 0 4776 0 19363 17627 1736 70 17.0 01/12/2021 02:48:35 PM Agree Agree
12814 12814 01/10/2021 IL 1028750 1028750 0 4711 0 19293 17574 1719 83 3.0 01/11/2021 03:01:02 PM Agree Agree
7794 7794 01/09/2021 IL 1024039 1024039 0 6717 0 19210 17494 1716 102 3.0 01/10/2021 04:10:55 PM Agree Agree
6322 6322 01/08/2021 IL 1017322 1017322 0 9277 0 19108 17395 1713 167 44.0 01/09/2021 03:26:08 PM Agree Agree
18430 18430 01/07/2021 IL 1008045 1008045 0 8757 0 18941 17272 1669 206 30.0 01/08/2021 03:56:01 PM Agree Agree
9388 9388 01/06/2021 IL 999288 999288 0 7569 0 18735 17096 1639 173 36.0 01/07/2021 02:56:59 PM Agree Agree
18298 18298 01/05/2021 IL 991719 991719 0 6839 0 18562 16959 1603 150 25.0 01/06/2021 02:58:26 PM Agree Agree
8378 8378 01/04/2021 IL 984880 984880 0 5059 0 18412 16834 1578 90 11.0 01/05/2021 03:00:42 PM Agree Agree
17430 17430 01/03/2021 IL 979821 979821 0 4469 0 18322 16755 1567 105 24.0 01/04/2021 02:55:45 PM Agree Agree
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
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
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
7566 7566 12/30/2020 IL 955380 955380 0 7374 0 17811 16357 1454 215 37.0 12/31/2020 02:55:07 PM Agree Agree
13722 13722 12/29/2020 IL 948006 948006 0 5644 0 17596 16179 1417 126 21.0 12/30/2020 02:56:20 PM Agree Agree
19115 19115 12/28/2020 IL 942362 942362 0 4453 0 17470 16074 1396 134 29.0 12/29/2020 02:56:32 PM Agree Agree
10231 10231 12/27/2020 IL 937909 937909 0 3767 0 17336 15969 1367 112 8.0 12/28/2020 02:42:49 PM Agree Agree
13717 13717 12/26/2020 IL 934142 934142 0 3293 0 17224 15865 1359 70 4.0 12/27/2020 02:44:47 PM Agree Agree
14336 14336 12/25/2020 IL 930849 930849 0 5742 0 17154 15799 1355 194 38.0 12/26/2020 02:34:18 PM Agree Agree
12464 12464 12/24/2020 IL 925107 925107 0 7037 0 16960 15643 1317 118 22.0 12/25/2020 02:25:34 PM Agree Agree
17672 17672 12/23/2020 IL 918070 918070 0 6762 0 16842 15547 1295 171 38.0 12/24/2020 02:31:20 PM Agree Agree
16594 16594 12/22/2020 IL 911308 911308 0 6239 0 16671 15414 1257 144 29.0 12/23/2020 02:36:58 PM Agree Agree
14566 14566 12/21/2020 IL 905069 905069 0 4699 0 16527 15299 1228 120 23.0 12/22/2020 02:35:48 PM Agree Agree
6361 6361 12/20/2020 IL 900370 900370 0 6003 0 16407 15202 1205 81 2.0 12/21/2020 02:39:53 PM Agree Agree
17348 17348 12/19/2020 IL 894367 894367 0 7562 0 16326 15123 1203 120 12.0 12/20/2020 02:32:33 PM Agree Agree
16813 16813 12/18/2020 IL 886805 886805 0 7377 0 16206 15015 1191 221 41.0 12/19/2020 02:42:31 PM Agree Agree
17212 17212 12/17/2020 IL 879428 879428 0 8828 0 15985 14835 1150 208 28.0 12/18/2020 02:45:01 PM Agree Agree
14705 14705 12/16/2020 IL 870600 870600 0 7123 0 15777 14655 1122 190 44.0 12/17/2020 02:33:42 PM Agree Agree
12313 12313 12/15/2020 IL 863477 863477 0 7359 0 15587 14509 1078 132 17.0 12/16/2020 02:28:57 PM Agree Agree
15329 15329 12/14/2020 IL 856118 856118 0 7214 0 15455 14394 1061 116 13.0 12/15/2020 02:39:02 PM Agree Agree
12201 12201 12/13/2020 IL 848904 848904 0 7216 0 15339 14291 1048 107 -8.0 12/14/2020 02:36:45 PM Agree Agree
9075 9075 12/12/2020 IL 841688 841688 0 8737 0 15232 14176 1056 165 39.0 12/13/2020 02:31:19 PM Agree Agree
13050 13050 12/11/2020 IL 832951 832951 0 9420 0 15067 14050 1017 222 33.0 12/12/2020 02:59:37 PM Agree Agree
788 788 02/28/2021 OH 967422 829430 137992 1268 308 17297 14709 2588 60 11.0 03/01/2021 03:21:38 PM Agree Agree
22985 22985 02/27/2021 OH 966154 828470 137684 1774 777 17237 14660 2577 54 15.0 02/28/2021 02:48:18 PM Agree Agree
21877 21877 02/26/2021 OH 964380 827473 136907 1976 652 17183 14621 2562 58 10.0 02/27/2021 02:51:23 PM Agree Agree
3847 3847 02/25/2021 OH 962404 826149 136255 2409 661 17125 14573 2552 80 7.0 02/26/2021 03:02:41 PM Agree Agree
3612 3612 02/24/2021 OH 959995 824401 135594 1842 532 17045 14500 2545 77 7.0 02/25/2021 02:54:32 PM Agree Agree
7149 7149 12/10/2020 IL 823531 823531 0 11101 0 14845 13861 984 232 37.0 12/11/2020 03:06:51 PM Agree Agree
23072 23072 02/23/2021 OH 958153 823091 135062 2775 700 16968 14430 2538 94 15.0 02/24/2021 02:56:12 PM Agree Agree
880 880 02/22/2021 OH 955378 821016 134362 1611 634 16874 14351 2523 58 8.0 02/23/2021 02:51:13 PM Agree Agree
22156 22156 02/21/2021 OH 953767 820039 133728 1461 416 16816 14301 2515 67 14.0 02/22/2021 02:53:38 PM Agree Agree
21280 21280 02/20/2021 OH 952306 818994 133312 2611 1110 16749 14248 2501 56 12.0 02/21/2021 02:57:50 PM Agree Agree
20863 20863 02/28/2021 GA 1006521 818516 188005 2334 791 17295 15068 2227 1 0.0 03/01/2021 03:21:38 PM Agree Agree
20918 20918 02/19/2021 OH 949695 817493 132202 2306 870 16693 14204 2489 82 10.0 02/20/2021 02:45:37 PM Agree Agree
23742 23742 02/27/2021 GA 1004187 816973 187214 3365 1212 17294 15067 2227 75 15.0 02/28/2021 02:48:18 PM Agree Agree
23130 23130 02/18/2021 OH 947389 816057 131332 2282 757 16611 14132 2479 98 12.0 02/19/2021 03:33:51 PM Agree Agree
24183 24183 02/26/2021 GA 1000822 814820 186002 3434 1226 17219 15007 2212 20 2.0 02/27/2021 02:51:23 PM Agree Agree
2765 2765 02/17/2021 OH 945107 814532 130575 1816 749 16513 14046 2467 60 14.0 02/18/2021 02:43:57 PM Agree Agree
20163 20163 02/16/2021 OH 943291 813465 129826 2026 861 16453 14000 2453 59 4.0 02/17/2021 02:51:58 PM Agree Agree
19438 19438 02/25/2021 GA 997388 812612 184776 3327 1188 17199 14989 2210 135 28.0 02/26/2021 03:02:41 PM Agree Agree
12174 12174 12/09/2020 IL 812430 812430 0 8256 0 14613 13666 947 229 50.0 12/10/2020 02:50:16 PM Agree Agree
19506 19506 02/15/2021 OH 941265 812300 128965 1915 537 16394 13945 2449 48 7.0 02/16/2021 02:53:06 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
);