covid_casesdeaths_reshaped_bln

Table actions
Data provided via a collaboration between USAFacts and Big Local News. This is an ongoing effort to collect and distribute county-level data on confirmed coronavirus cases and deaths. Please cite USAFacts as the data provider. The three CSV files are the current version and will be updated daily around 8 a.m. The zipped archives are prior versions with a date stamp of when they were uploaded by Big Local News. See README for additional details

Data source: Big Local News · About: big-local-datasette

1,191,735 rows sorted by deaths descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid countyFIPS County Name State stateFIPS date cases deaths ▲
1188752 1188752 6037 Los Angeles County CA 6 1/28/21 1066569 15897
1185557 1185557 6037 Los Angeles County CA 6 1/27/21 1060492 15592
1182362 1182362 6037 Los Angeles County CA 6 1/26/21 1055181 15303
1179167 1179167 6037 Los Angeles County CA 6 1/25/21 1048757 15260
1175972 1175972 6037 Los Angeles County CA 6 1/24/21 1040961 15162
1172777 1172777 6037 Los Angeles County CA 6 1/23/21 1031177 14894
1169582 1169582 6037 Los Angeles County CA 6 1/22/21 1023055 14641
1166387 1166387 6037 Los Angeles County CA 6 1/21/21 1015608 14384
1163192 1163192 6037 Los Angeles County CA 6 1/20/21 1010375 14122
1159997 1159997 6037 Los Angeles County CA 6 1/19/21 1002614 13936
1156802 1156802 6037 Los Angeles County CA 6 1/18/21 993028 13848
1153607 1153607 6037 Los Angeles County CA 6 1/17/21 982684 13741
1150412 1150412 6037 Los Angeles County CA 6 1/16/21 968979 13489
1147217 1147217 6037 Los Angeles County CA 6 1/15/21 954652 13234
1144022 1144022 6037 Los Angeles County CA 6 1/14/21 937985 12955
1140827 1140827 6037 Los Angeles County CA 6 1/13/21 926295 12674
1137632 1137632 6037 Los Angeles County CA 6 1/12/21 914434 12387
1134437 1134437 6037 Los Angeles County CA 6 1/11/21 901783 12250
1131242 1131242 6037 Los Angeles County CA 6 1/10/21 887949 12084
1128047 1128047 6037 Los Angeles County CA 6 1/9/21 871188 11863
1124852 1124852 6037 Los Angeles County CA 6 1/8/21 853187 11545
1121657 1121657 6037 Los Angeles County CA 6 1/7/21 835052 11328
1118462 1118462 6037 Los Angeles County CA 6 1/6/21 823783 11071
1115267 1115267 6037 Los Angeles County CA 6 1/5/21 813022 10850
1112072 1112072 6037 Los Angeles County CA 6 1/4/21 803532 10773
1108877 1108877 6037 Los Angeles County CA 6 1/3/21 791892 10682
1105682 1105682 6037 Los Angeles County CA 6 1/2/21 775578 10552
1102487 1102487 6037 Los Angeles County CA 6 1/1/21 755844 10345
1099292 1099292 6037 Los Angeles County CA 6 12/31/20 741627 10056
1096097 1096097 6037 Los Angeles County CA 6 12/30/20 731907 9782
1092902 1092902 6037 Los Angeles County CA 6 12/29/20 720699 9555
1089707 1089707 6037 Los Angeles County CA 6 12/28/20 707260 9482
1086512 1086512 6037 Los Angeles County CA 6 12/27/20 694149 9438
1080122 1080122 6037 Los Angeles County CA 6 12/25/20 664840 9299
1083317 1083317 6037 Los Angeles County CA 6 12/26/20 665600 9299
1076927 1076927 6037 Los Angeles County CA 6 12/24/20 677299 9153
1073732 1073732 6037 Los Angeles County CA 6 12/23/20 663954 9016
1070537 1070537 6037 Los Angeles County CA 6 12/22/20 647542 8931
1064147 1064147 6037 Los Angeles County CA 6 12/20/20 623670 8875
1067342 1067342 6037 Los Angeles County CA 6 12/21/20 634849 8875
1060952 1060952 6037 Los Angeles County CA 6 12/19/20 610372 8817
1189166 1189166 17031 Cook County IL 17 1/28/21 450116 8803
1057757 1057757 6037 Los Angeles County CA 6 12/18/20 596721 8757
1185971 1185971 17031 Cook County IL 17 1/27/21 448546 8756
1182776 1182776 17031 Cook County IL 17 1/26/21 447295 8734
1179581 1179581 17031 Cook County IL 17 1/25/21 446035 8724
1176386 1176386 17031 Cook County IL 17 1/24/21 444927 8706
1173191 1173191 17031 Cook County IL 17 1/23/21 443600 8686
1054562 1054562 6037 Los Angeles County CA 6 12/17/20 580325 8664
1169996 1169996 17031 Cook County IL 17 1/22/21 441657 8659
1166801 1166801 17031 Cook County IL 17 1/21/21 439118 8615
1163606 1163606 17031 Cook County IL 17 1/20/21 437465 8570
1051367 1051367 6037 Los Angeles County CA 6 12/16/20 566005 8568
1160411 1160411 17031 Cook County IL 17 1/19/21 435888 8544
1157216 1157216 17031 Cook County IL 17 1/18/21 434341 8525
1154021 1154021 17031 Cook County IL 17 1/17/21 433089 8495
1150826 1150826 17031 Cook County IL 17 1/16/21 431385 8471
1048172 1048172 6037 Los Angeles County CA 6 12/15/20 543769 8431
1147631 1147631 17031 Cook County IL 17 1/15/21 429270 8427
1144436 1144436 17031 Cook County IL 17 1/14/21 426658 8383
1141241 1141241 17031 Cook County IL 17 1/13/21 424217 8369
1044977 1044977 6037 Los Angeles County CA 6 12/14/20 532730 8345
1138046 1138046 17031 Cook County IL 17 1/12/21 422159 8342
1134851 1134851 17031 Cook County IL 17 1/11/21 419471 8321
1190427 1190427 36047 Kings County NY 36 1/28/21 166767 8299
1041782 1041782 6037 Los Angeles County CA 6 12/13/20 525486 8298
1131656 1131656 17031 Cook County IL 17 1/10/21 417790 8278
1187232 1187232 36047 Kings County NY 36 1/27/21 164936 8278
1038587 1038587 6037 Los Angeles County CA 6 12/12/20 512872 8269
1184037 1184037 36047 Kings County NY 36 1/26/21 163336 8246
1180842 1180842 36047 Kings County NY 36 1/25/21 161964 8230
1128461 1128461 17031 Cook County IL 17 1/9/21 415991 8219
1177647 1177647 36047 Kings County NY 36 1/24/21 160369 8205
1035392 1035392 6037 Los Angeles County CA 6 12/11/20 501635 8199
1125266 1125266 17031 Cook County IL 17 1/8/21 413504 8196
1174452 1174452 36047 Kings County NY 36 1/23/21 158856 8176
1122071 1122071 17031 Cook County IL 17 1/7/21 410005 8152
1032197 1032197 6037 Los Angeles County CA 6 12/10/20 487917 8149
1171257 1171257 36047 Kings County NY 36 1/22/21 157260 8149
1168062 1168062 36047 Kings County NY 36 1/21/21 155424 8120
1118876 1118876 17031 Cook County IL 17 1/6/21 406674 8101
1164867 1164867 36047 Kings County NY 36 1/20/21 153843 8092
1029002 1029002 6037 Los Angeles County CA 6 12/9/20 475271 8075
1161672 1161672 36047 Kings County NY 36 1/19/21 151973 8073
1115681 1115681 17031 Cook County IL 17 1/5/21 403987 8059
1190444 1190444 36081 Queens County NY 36 1/28/21 170554 8058
1158477 1158477 36047 Kings County NY 36 1/18/21 150463 8057
1155282 1155282 36047 Kings County NY 36 1/17/21 148920 8037
1187249 1187249 36081 Queens County NY 36 1/27/21 168784 8033
1112486 1112486 17031 Cook County IL 17 1/4/21 401457 8025
1152087 1152087 36047 Kings County NY 36 1/16/21 147252 8020
1184054 1184054 36081 Queens County NY 36 1/26/21 167342 8013
1025807 1025807 6037 Los Angeles County CA 6 12/8/20 466321 8000
1180859 1180859 36081 Queens County NY 36 1/25/21 165810 7996
1148892 1148892 36047 Kings County NY 36 1/15/21 145424 7994
1109291 1109291 17031 Cook County IL 17 1/3/21 399609 7985
1177664 1177664 36081 Queens County NY 36 1/24/21 164219 7979
1145697 1145697 36047 Kings County NY 36 1/14/21 143078 7970
1174469 1174469 36081 Queens County NY 36 1/23/21 162455 7958
1171274 1171274 36081 Queens County NY 36 1/22/21 160663 7942

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [covid_casesdeaths_reshaped_bln] (
   [countyFIPS] INTEGER,
   [County Name] TEXT,
   [State] TEXT,
   [stateFIPS] INTEGER,
   [date] TEXT,
   [cases] INTEGER,
   [deaths] INTEGER
);