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 cases 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
1076927 1076927 6037 Los Angeles County CA 6 12/24/20 677299 9153
1083317 1083317 6037 Los Angeles County CA 6 12/26/20 665600 9299
1080122 1080122 6037 Los Angeles County CA 6 12/25/20 664840 9299
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
1067342 1067342 6037 Los Angeles County CA 6 12/21/20 634849 8875
1064147 1064147 6037 Los Angeles County CA 6 12/20/20 623670 8875
1060952 1060952 6037 Los Angeles County CA 6 12/19/20 610372 8817
1057757 1057757 6037 Los Angeles County CA 6 12/18/20 596721 8757
1054562 1054562 6037 Los Angeles County CA 6 12/17/20 580325 8664
1051367 1051367 6037 Los Angeles County CA 6 12/16/20 566005 8568
1048172 1048172 6037 Los Angeles County CA 6 12/15/20 543769 8431
1044977 1044977 6037 Los Angeles County CA 6 12/14/20 532730 8345
1041782 1041782 6037 Los Angeles County CA 6 12/13/20 525486 8298
1038587 1038587 6037 Los Angeles County CA 6 12/12/20 512872 8269
1035392 1035392 6037 Los Angeles County CA 6 12/11/20 501635 8199
1032197 1032197 6037 Los Angeles County CA 6 12/10/20 487917 8149
1029002 1029002 6037 Los Angeles County CA 6 12/9/20 475271 8075
1025807 1025807 6037 Los Angeles County CA 6 12/8/20 466321 8000
1188648 1188648 4013 Maricopa County AZ 4 1/28/21 462580 7271
1185453 1185453 4013 Maricopa County AZ 4 1/27/21 459501 7174
1022612 1022612 6037 Los Angeles County CA 6 12/7/20 457880 7936
1182258 1182258 4013 Maricopa County AZ 4 1/26/21 455830 7053
1179063 1179063 4013 Maricopa County AZ 4 1/25/21 452925 6951
1189166 1189166 17031 Cook County IL 17 1/28/21 450116 8803
1019417 1019417 6037 Los Angeles County CA 6 12/6/20 449851 7909
1175868 1175868 4013 Maricopa County AZ 4 1/24/21 449162 6950
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
1172673 1172673 4013 Maricopa County AZ 4 1/23/21 444431 6891
1173191 1173191 17031 Cook County IL 17 1/23/21 443600 8686
1169996 1169996 17031 Cook County IL 17 1/22/21 441657 8659
1169478 1169478 4013 Maricopa County AZ 4 1/22/21 439743 6806
1016222 1016222 6037 Los Angeles County CA 6 12/5/20 439408 7886
1166801 1166801 17031 Cook County IL 17 1/21/21 439118 8615
1163606 1163606 17031 Cook County IL 17 1/20/21 437465 8570
1160411 1160411 17031 Cook County IL 17 1/19/21 435888 8544
1157216 1157216 17031 Cook County IL 17 1/18/21 434341 8525
1166283 1166283 4013 Maricopa County AZ 4 1/21/21 434337 6683
1154021 1154021 17031 Cook County IL 17 1/17/21 433089 8495
1150826 1150826 17031 Cook County IL 17 1/16/21 431385 8471
1013027 1013027 6037 Los Angeles County CA 6 12/4/20 430583 7842
1147631 1147631 17031 Cook County IL 17 1/15/21 429270 8427
1163088 1163088 4013 Maricopa County AZ 4 1/20/21 428624 6548
1144436 1144436 17031 Cook County IL 17 1/14/21 426658 8383
1159893 1159893 4013 Maricopa County AZ 4 1/19/21 425844 6443
1141241 1141241 17031 Cook County IL 17 1/13/21 424217 8369
1138046 1138046 17031 Cook County IL 17 1/12/21 422159 8342
1009832 1009832 6037 Los Angeles County CA 6 12/3/20 421881 7782
1156698 1156698 4013 Maricopa County AZ 4 1/18/21 421551 6443
1134851 1134851 17031 Cook County IL 17 1/11/21 419471 8321
1153503 1153503 4013 Maricopa County AZ 4 1/17/21 417839 6443
1131656 1131656 17031 Cook County IL 17 1/10/21 417790 8278
1128461 1128461 17031 Cook County IL 17 1/9/21 415991 8219
1006637 1006637 6037 Los Angeles County CA 6 12/2/20 414185 7740
1125266 1125266 17031 Cook County IL 17 1/8/21 413504 8196
1150308 1150308 4013 Maricopa County AZ 4 1/16/21 413282 6437
1122071 1122071 17031 Cook County IL 17 1/7/21 410005 8152
1003442 1003442 6037 Los Angeles County CA 6 12/1/20 408396 7700
1147113 1147113 4013 Maricopa County AZ 4 1/15/21 407631 6320
1118876 1118876 17031 Cook County IL 17 1/6/21 406674 8101
1115681 1115681 17031 Cook County IL 17 1/5/21 403987 8059
1143918 1143918 4013 Maricopa County AZ 4 1/14/21 401855 6212
1112486 1112486 17031 Cook County IL 17 1/4/21 401457 8025
1000247 1000247 6037 Los Angeles County CA 6 11/30/20 400919 7655

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
);