ny_times_us_counties

Table actions
⚠️ 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

67 rows where date = "2020-06-25" and state = "Alabama" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

fips >30

state 1

  • Alabama · 67 ✖
Link rowid date ▲ county state fips cases deaths
271352 271352 2020-06-25 Autauga Alabama 1001 479 11
271353 271353 2020-06-25 Baldwin Alabama 1003 477 9
271354 271354 2020-06-25 Barbour Alabama 1005 305 1
271355 271355 2020-06-25 Bibb Alabama 1007 149 1
271356 271356 2020-06-25 Blount Alabama 1009 176 1
271357 271357 2020-06-25 Bullock Alabama 1011 351 11
271358 271358 2020-06-25 Butler Alabama 1013 588 27
271359 271359 2020-06-25 Calhoun Alabama 1015 233 5
271360 271360 2020-06-25 Chambers Alabama 1017 549 27
271361 271361 2020-06-25 Cherokee Alabama 1019 64 7
271362 271362 2020-06-25 Chilton Alabama 1021 185 3
271363 271363 2020-06-25 Choctaw Alabama 1023 188 12
271364 271364 2020-06-25 Clarke Alabama 1025 244 5
271365 271365 2020-06-25 Clay Alabama 1027 35 2
271366 271366 2020-06-25 Cleburne Alabama 1029 23 1
271367 271367 2020-06-25 Coffee Alabama 1031 330 1
271368 271368 2020-06-25 Colbert Alabama 1033 332 5
271369 271369 2020-06-25 Conecuh Alabama 1035 155 3
271370 271370 2020-06-25 Coosa Alabama 1037 54 1
271371 271371 2020-06-25 Covington Alabama 1039 276 4
271372 271372 2020-06-25 Crenshaw Alabama 1041 123 3
271373 271373 2020-06-25 Cullman Alabama 1043 356 3
271374 271374 2020-06-25 Dale Alabama 1045 219 0
271375 271375 2020-06-25 Dallas Alabama 1047 716 7
271376 271376 2020-06-25 DeKalb Alabama 1049 489 5
271377 271377 2020-06-25 Elmore Alabama 1051 744 12
271378 271378 2020-06-25 Escambia Alabama 1053 190 6
271379 271379 2020-06-25 Etowah Alabama 1055 493 13
271380 271380 2020-06-25 Fayette Alabama 1057 65 1
271381 271381 2020-06-25 Franklin Alabama 1059 816 11
271382 271382 2020-06-25 Geneva Alabama 1061 55 0
271383 271383 2020-06-25 Greene Alabama 1063 160 6
271384 271384 2020-06-25 Hale Alabama 1065 272 19
271385 271385 2020-06-25 Henry Alabama 1067 128 4
271386 271386 2020-06-25 Houston Alabama 1069 385 5
271387 271387 2020-06-25 Jackson Alabama 1071 182 3
271388 271388 2020-06-25 Jefferson Alabama 1073 3378 131
271389 271389 2020-06-25 Lamar Alabama 1075 63 0
271390 271390 2020-06-25 Lauderdale Alabama 1077 334 4
271391 271391 2020-06-25 Lawrence Alabama 1079 87 0
271392 271392 2020-06-25 Lee Alabama 1081 1020 36
271393 271393 2020-06-25 Limestone Alabama 1083 321 0
271394 271394 2020-06-25 Lowndes Alabama 1085 436 18
271395 271395 2020-06-25 Macon Alabama 1087 155 7
271396 271396 2020-06-25 Madison Alabama 1089 842 6
271397 271397 2020-06-25 Marengo Alabama 1091 256 11
271398 271398 2020-06-25 Marion Alabama 1093 188 12
271399 271399 2020-06-25 Marshall Alabama 1095 1275 9
271400 271400 2020-06-25 Mobile Alabama 1097 3241 135
271401 271401 2020-06-25 Monroe Alabama 1099 175 2
271402 271402 2020-06-25 Montgomery Alabama 1101 3514 91
271403 271403 2020-06-25 Morgan Alabama 1103 866 2
271404 271404 2020-06-25 Perry Alabama 1105 102 0
271405 271405 2020-06-25 Pickens Alabama 1107 179 6
271406 271406 2020-06-25 Pike Alabama 1109 383 4
271407 271407 2020-06-25 Randolph Alabama 1111 152 9
271408 271408 2020-06-25 Russell Alabama 1113 411 0
271409 271409 2020-06-25 Shelby Alabama 1117 897 23
271410 271410 2020-06-25 St. Clair Alabama 1115 236 2
271411 271411 2020-06-25 Sumter Alabama 1119 272 12
271412 271412 2020-06-25 Talladega Alabama 1121 207 6
271413 271413 2020-06-25 Tallapoosa Alabama 1123 541 70
271414 271414 2020-06-25 Tuscaloosa Alabama 1125 1758 37
271415 271415 2020-06-25 Walker Alabama 1127 761 12
271416 271416 2020-06-25 Washington Alabama 1129 97 6
271417 271417 2020-06-25 Wilcox Alabama 1131 263 8
271418 271418 2020-06-25 Winston Alabama 1133 210 2

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