⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

9,079 rows where county = "Unknown" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

  • - 9,079

county

  • Unknown · 9,079
Link rowid date ▲ county state fips cases deaths
1092543 2021-03-06 Unknown Alaska   257 0
1092633 2021-03-06 Unknown Arkansas   3285 0
1092768 2021-03-06 Unknown Connecticut   982 10
1092773 2021-03-06 Unknown Delaware   195 0
1092838 2021-03-06 Unknown Florida   3494 0
1092987 2021-03-06 Unknown Georgia   3515 11
1093003 2021-03-06 Unknown Guam   8718 134
1093144 2021-03-06 Unknown Illinois   0 237
1093336 2021-03-06 Unknown Iowa   8656 0
1093446 2021-03-06 Unknown Kansas   0 1022
1093630 2021-03-06 Unknown Louisiana   422 0
1093676 2021-03-06 Unknown Maryland   0 50
1093693 2021-03-06 Unknown Massachusetts   33585 9
1093774 2021-03-06 Unknown Michigan   0 12
1093857 2021-03-06 Unknown Minnesota   515 68
1094242 2021-03-06 Unknown New Hampshire   1055 5
1094263 2021-03-06 Unknown New Jersey   1219 0
1094505 2021-03-06 Unknown North Dakota   30 30
1094592 2021-03-06 Unknown Ohio   0 1
1094673 2021-03-06 Unknown Oklahoma   8 0
1094853 2021-03-06 Unknown Puerto Rico   4455 2059
1094865 2021-03-06 Unknown Rhode Island   12176 39
1095066 2021-03-06 Unknown Tennessee   8573 113
1095353 2021-03-06 Unknown Utah   1838 7
1095370 2021-03-06 Unknown Vermont   8 0
1089297 2021-03-05 Unknown Alaska   257 0
1089387 2021-03-05 Unknown Arkansas   3303 0
1089522 2021-03-05 Unknown Connecticut   982 10
1089527 2021-03-05 Unknown Delaware   195 0
1089592 2021-03-05 Unknown Florida   3491 0
1089741 2021-03-05 Unknown Georgia   3531 11
1089757 2021-03-05 Unknown Guam   8716 132
1089898 2021-03-05 Unknown Illinois   0 231
1090090 2021-03-05 Unknown Iowa   8266 0
1090200 2021-03-05 Unknown Kansas   0 1023
1090384 2021-03-05 Unknown Louisiana   422 0
1090430 2021-03-05 Unknown Maryland   0 45
1090447 2021-03-05 Unknown Massachusetts   33365 9
1090528 2021-03-05 Unknown Michigan   0 12
1090611 2021-03-05 Unknown Minnesota   515 68
1090996 2021-03-05 Unknown New Hampshire   1037 5
1091017 2021-03-05 Unknown New Jersey   1207 0
1091259 2021-03-05 Unknown North Dakota   30 30
1091346 2021-03-05 Unknown Ohio   0 1
1091427 2021-03-05 Unknown Oklahoma   4 0
1091607 2021-03-05 Unknown Puerto Rico   4443 2056
1091619 2021-03-05 Unknown Rhode Island   12176 39
1091820 2021-03-05 Unknown Tennessee   8549 113
1092107 2021-03-05 Unknown Utah   1758 7
1092124 2021-03-05 Unknown Vermont   8 0
1086052 2021-03-04 Unknown Alaska   256 0
1086142 2021-03-04 Unknown Arkansas   3300 0
1086277 2021-03-04 Unknown Connecticut   979 10
1086282 2021-03-04 Unknown Delaware   195 0
1086347 2021-03-04 Unknown Florida   3493 0
1086496 2021-03-04 Unknown Georgia   3530 11
1086512 2021-03-04 Unknown Guam   8716 132
1086653 2021-03-04 Unknown Illinois   0 218
1086845 2021-03-04 Unknown Iowa   7733 0
1086955 2021-03-04 Unknown Kansas   0 1021
1087139 2021-03-04 Unknown Louisiana   423 0
1087185 2021-03-04 Unknown Maryland   0 53
1087202 2021-03-04 Unknown Massachusetts   33137 9
1087283 2021-03-04 Unknown Michigan   0 12
1087366 2021-03-04 Unknown Minnesota   512 68
1087751 2021-03-04 Unknown New Hampshire   1037 5
1087772 2021-03-04 Unknown New Jersey   1194 0
1088014 2021-03-04 Unknown North Dakota   30 30
1088181 2021-03-04 Unknown Oklahoma   3 0
1088361 2021-03-04 Unknown Puerto Rico   4418 2053
1088373 2021-03-04 Unknown Rhode Island   11782 37
1088574 2021-03-04 Unknown Tennessee   8514 116
1088861 2021-03-04 Unknown Utah   1694 7
1088878 2021-03-04 Unknown Vermont   8 0
1082806 2021-03-03 Unknown Alaska   265 0
1082896 2021-03-03 Unknown Arkansas   3310 0
1083031 2021-03-03 Unknown Connecticut   978 10
1083036 2021-03-03 Unknown Delaware   195 0
1083101 2021-03-03 Unknown Florida   3493 0
1083250 2021-03-03 Unknown Georgia   3544 11
1083266 2021-03-03 Unknown Guam   8714 132
1083407 2021-03-03 Unknown Illinois   0 209
1083599 2021-03-03 Unknown Iowa   7154 0
1083709 2021-03-03 Unknown Kansas   0 1049
1083893 2021-03-03 Unknown Louisiana   424 0
1083915 2021-03-03 Unknown Maine   4 0
1083940 2021-03-03 Unknown Maryland   0 61
1083957 2021-03-03 Unknown Massachusetts   33007 8
1084038 2021-03-03 Unknown Michigan   0 12
1084121 2021-03-03 Unknown Minnesota   513 68
1084506 2021-03-03 Unknown New Hampshire   1041 5
1084527 2021-03-03 Unknown New Jersey   1123 0
1084769 2021-03-03 Unknown North Dakota   30 30
1084936 2021-03-03 Unknown Oklahoma   2 0
1085116 2021-03-03 Unknown Puerto Rico   4417 2048
1085128 2021-03-03 Unknown Rhode Island   11340 32
1085329 2021-03-03 Unknown Tennessee   8514 114
1085616 2021-03-03 Unknown Utah   1576 3
1085633 2021-03-03 Unknown Vermont   8 0
1079560 2021-03-02 Unknown Alaska   265 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);