ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,352 rows where county = "Douglas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199526 | 1199526 | 2021-04-07 | Douglas | Wisconsin | 55031 | 4483 | 47 |
1193371 | 1193371 | 2021-04-06 | Douglas | Colorado | 8035 | 24993 | 235 |
1193546 | 1193546 | 2021-04-06 | Douglas | Georgia | 13097 | 14427 | 206 |
1193729 | 1193729 | 2021-04-06 | Douglas | Illinois | 17041 | 2530 | 41 |
1194026 | 1194026 | 2021-04-06 | Douglas | Kansas | 20045 | 8979 | 86 |
1194455 | 1194455 | 2021-04-06 | Douglas | Minnesota | 27041 | 4249 | 70 |
1194638 | 1194638 | 2021-04-06 | Douglas | Missouri | 29067 | 900 | 27 |
1194805 | 1194805 | 2021-04-06 | Douglas | Nebraska | 31055 | 67811 | 684 |
1194875 | 1194875 | 2021-04-06 | Douglas | Nevada | 32005 | 2699 | 35 |
1195345 | 1195345 | 2021-04-06 | Douglas | Oregon | 41019 | 2944 | 64 |
1195590 | 1195590 | 2021-04-06 | Douglas | South Dakota | 46043 | 450 | 9 |
1196176 | 1196176 | 2021-04-06 | Douglas | Washington | 53017 | 3489 | 22 |
1196277 | 1196277 | 2021-04-06 | Douglas | Wisconsin | 55031 | 4462 | 47 |
1190121 | 1190121 | 2021-04-05 | Douglas | Colorado | 8035 | 24911 | 235 |
1190296 | 1190296 | 2021-04-05 | Douglas | Georgia | 13097 | 14399 | 205 |
1190479 | 1190479 | 2021-04-05 | Douglas | Illinois | 17041 | 2527 | 41 |
1190776 | 1190776 | 2021-04-05 | Douglas | Kansas | 20045 | 8971 | 86 |
1191206 | 1191206 | 2021-04-05 | Douglas | Minnesota | 27041 | 4237 | 70 |
1191389 | 1191389 | 2021-04-05 | Douglas | Missouri | 29067 | 900 | 27 |
1191556 | 1191556 | 2021-04-05 | Douglas | Nebraska | 31055 | 67664 | 683 |
1191626 | 1191626 | 2021-04-05 | Douglas | Nevada | 32005 | 2693 | 35 |
1192097 | 1192097 | 2021-04-05 | Douglas | Oregon | 41019 | 2937 | 60 |
1192342 | 1192342 | 2021-04-05 | Douglas | South Dakota | 46043 | 449 | 9 |
1192928 | 1192928 | 2021-04-05 | Douglas | Washington | 53017 | 3475 | 22 |
1193029 | 1193029 | 2021-04-05 | Douglas | Wisconsin | 55031 | 4453 | 47 |
1186874 | 1186874 | 2021-04-04 | Douglas | Colorado | 8035 | 24827 | 235 |
1187049 | 1187049 | 2021-04-04 | Douglas | Georgia | 13097 | 14387 | 205 |
1187232 | 1187232 | 2021-04-04 | Douglas | Illinois | 17041 | 2524 | 41 |
1187529 | 1187529 | 2021-04-04 | Douglas | Kansas | 20045 | 8944 | 86 |
1187958 | 1187958 | 2021-04-04 | Douglas | Minnesota | 27041 | 4220 | 70 |
1188141 | 1188141 | 2021-04-04 | Douglas | Missouri | 29067 | 900 | 27 |
1188308 | 1188308 | 2021-04-04 | Douglas | Nebraska | 31055 | 67486 | 682 |
1188378 | 1188378 | 2021-04-04 | Douglas | Nevada | 32005 | 2687 | 35 |
1188848 | 1188848 | 2021-04-04 | Douglas | Oregon | 41019 | 2926 | 60 |
1189093 | 1189093 | 2021-04-04 | Douglas | South Dakota | 46043 | 448 | 9 |
1189678 | 1189678 | 2021-04-04 | Douglas | Washington | 53017 | 3465 | 22 |
1189779 | 1189779 | 2021-04-04 | Douglas | Wisconsin | 55031 | 4443 | 47 |
1183627 | 1183627 | 2021-04-03 | Douglas | Colorado | 8035 | 24580 | 234 |
1183802 | 1183802 | 2021-04-03 | Douglas | Georgia | 13097 | 14375 | 205 |
1183985 | 1183985 | 2021-04-03 | Douglas | Illinois | 17041 | 2522 | 41 |
1184282 | 1184282 | 2021-04-03 | Douglas | Kansas | 20045 | 8944 | 86 |
1184711 | 1184711 | 2021-04-03 | Douglas | Minnesota | 27041 | 4220 | 70 |
1184894 | 1184894 | 2021-04-03 | Douglas | Missouri | 29067 | 900 | 27 |
1185061 | 1185061 | 2021-04-03 | Douglas | Nebraska | 31055 | 67377 | 682 |
1185131 | 1185131 | 2021-04-03 | Douglas | Nevada | 32005 | 2687 | 35 |
1185601 | 1185601 | 2021-04-03 | Douglas | Oregon | 41019 | 2918 | 60 |
1185846 | 1185846 | 2021-04-03 | Douglas | South Dakota | 46043 | 448 | 9 |
1186431 | 1186431 | 2021-04-03 | Douglas | Washington | 53017 | 3465 | 22 |
1186532 | 1186532 | 2021-04-03 | Douglas | Wisconsin | 55031 | 4440 | 47 |
1180380 | 1180380 | 2021-04-02 | Douglas | Colorado | 8035 | 24580 | 234 |
1180555 | 1180555 | 2021-04-02 | Douglas | Georgia | 13097 | 14348 | 205 |
1180738 | 1180738 | 2021-04-02 | Douglas | Illinois | 17041 | 2521 | 41 |
1181035 | 1181035 | 2021-04-02 | Douglas | Kansas | 20045 | 8944 | 86 |
1181465 | 1181465 | 2021-04-02 | Douglas | Minnesota | 27041 | 4198 | 70 |
1181648 | 1181648 | 2021-04-02 | Douglas | Missouri | 29067 | 900 | 27 |
1181815 | 1181815 | 2021-04-02 | Douglas | Nebraska | 31055 | 67249 | 682 |
1181884 | 1181884 | 2021-04-02 | Douglas | Nevada | 32005 | 2683 | 35 |
1182354 | 1182354 | 2021-04-02 | Douglas | Oregon | 41019 | 2915 | 60 |
1182599 | 1182599 | 2021-04-02 | Douglas | South Dakota | 46043 | 448 | 9 |
1183184 | 1183184 | 2021-04-02 | Douglas | Washington | 53017 | 3465 | 22 |
1183285 | 1183285 | 2021-04-02 | Douglas | Wisconsin | 55031 | 4429 | 47 |
1177133 | 1177133 | 2021-04-01 | Douglas | Colorado | 8035 | 24436 | 234 |
1177308 | 1177308 | 2021-04-01 | Douglas | Georgia | 13097 | 14325 | 205 |
1177491 | 1177491 | 2021-04-01 | Douglas | Illinois | 17041 | 2520 | 41 |
1177788 | 1177788 | 2021-04-01 | Douglas | Kansas | 20045 | 8944 | 86 |
1178218 | 1178218 | 2021-04-01 | Douglas | Minnesota | 27041 | 4179 | 70 |
1178401 | 1178401 | 2021-04-01 | Douglas | Missouri | 29067 | 900 | 27 |
1178568 | 1178568 | 2021-04-01 | Douglas | Nebraska | 31055 | 66951 | 682 |
1178637 | 1178637 | 2021-04-01 | Douglas | Nevada | 32005 | 2680 | 35 |
1179107 | 1179107 | 2021-04-01 | Douglas | Oregon | 41019 | 2901 | 60 |
1179352 | 1179352 | 2021-04-01 | Douglas | South Dakota | 46043 | 448 | 9 |
1179937 | 1179937 | 2021-04-01 | Douglas | Washington | 53017 | 3456 | 22 |
1180038 | 1180038 | 2021-04-01 | Douglas | Wisconsin | 55031 | 4420 | 47 |
1173886 | 1173886 | 2021-03-31 | Douglas | Colorado | 8035 | 24288 | 234 |
1174061 | 1174061 | 2021-03-31 | Douglas | Georgia | 13097 | 14304 | 202 |
1174244 | 1174244 | 2021-03-31 | Douglas | Illinois | 17041 | 2517 | 41 |
1174541 | 1174541 | 2021-03-31 | Douglas | Kansas | 20045 | 8922 | 84 |
1174971 | 1174971 | 2021-03-31 | Douglas | Minnesota | 27041 | 4157 | 70 |
1175154 | 1175154 | 2021-03-31 | Douglas | Missouri | 29067 | 900 | 27 |
1175321 | 1175321 | 2021-03-31 | Douglas | Nebraska | 31055 | 66689 | 682 |
1175390 | 1175390 | 2021-03-31 | Douglas | Nevada | 32005 | 2678 | 35 |
1175860 | 1175860 | 2021-03-31 | Douglas | Oregon | 41019 | 2884 | 60 |
1176105 | 1176105 | 2021-03-31 | Douglas | South Dakota | 46043 | 446 | 9 |
1176690 | 1176690 | 2021-03-31 | Douglas | Washington | 53017 | 3447 | 22 |
1176791 | 1176791 | 2021-03-31 | Douglas | Wisconsin | 55031 | 4398 | 47 |
1170639 | 1170639 | 2021-03-30 | Douglas | Colorado | 8035 | 24157 | 234 |
1170814 | 1170814 | 2021-03-30 | Douglas | Georgia | 13097 | 14267 | 202 |
1170997 | 1170997 | 2021-03-30 | Douglas | Illinois | 17041 | 2516 | 41 |
1171294 | 1171294 | 2021-03-30 | Douglas | Kansas | 20045 | 8922 | 84 |
1171724 | 1171724 | 2021-03-30 | Douglas | Minnesota | 27041 | 4141 | 70 |
1171907 | 1171907 | 2021-03-30 | Douglas | Missouri | 29067 | 900 | 27 |
1172074 | 1172074 | 2021-03-30 | Douglas | Nebraska | 31055 | 66518 | 682 |
1172143 | 1172143 | 2021-03-30 | Douglas | Nevada | 32005 | 2675 | 35 |
1172613 | 1172613 | 2021-03-30 | Douglas | Oregon | 41019 | 2879 | 59 |
1172858 | 1172858 | 2021-03-30 | Douglas | South Dakota | 46043 | 445 | 9 |
1173443 | 1173443 | 2021-03-30 | Douglas | Washington | 53017 | 3433 | 22 |
1173544 | 1173544 | 2021-03-30 | Douglas | Wisconsin | 55031 | 4398 | 47 |
1167391 | 1167391 | 2021-03-29 | Douglas | Colorado | 8035 | 24111 | 234 |
1167566 | 1167566 | 2021-03-29 | Douglas | Georgia | 13097 | 14245 | 202 |
1167749 | 1167749 | 2021-03-29 | Douglas | Illinois | 17041 | 2516 | 41 |
Advanced export
JSON shape: default, array, newline-delimited
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);