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 |
---|---|---|---|---|---|---|---|
1041868 | 1041868 | 2021-02-18 | Douglas | Minnesota | 27041 | 3877 | 68 |
1042051 | 1042051 | 2021-02-18 | Douglas | Missouri | 29067 | 765 | 23 |
1042218 | 1042218 | 2021-02-18 | Douglas | Nebraska | 31055 | 63048 | 649 |
1042287 | 1042287 | 2021-02-18 | Douglas | Nevada | 32005 | 2471 | 33 |
1042756 | 1042756 | 2021-02-18 | Douglas | Oregon | 41019 | 2272 | 51 |
1043001 | 1043001 | 2021-02-18 | Douglas | South Dakota | 46043 | 422 | 9 |
1043586 | 1043586 | 2021-02-18 | Douglas | Washington | 53017 | 3204 | 22 |
1043687 | 1043687 | 2021-02-18 | Douglas | Wisconsin | 55031 | 4191 | 38 |
1037539 | 1037539 | 2021-02-17 | Douglas | Colorado | 8035 | 20958 | 230 |
1037714 | 1037714 | 2021-02-17 | Douglas | Georgia | 13097 | 12939 | 174 |
1037897 | 1037897 | 2021-02-17 | Douglas | Illinois | 17041 | 2304 | 36 |
1038194 | 1038194 | 2021-02-17 | Douglas | Kansas | 20045 | 8505 | 71 |
1038623 | 1038623 | 2021-02-17 | Douglas | Minnesota | 27041 | 3875 | 68 |
1038806 | 1038806 | 2021-02-17 | Douglas | Missouri | 29067 | 764 | 23 |
1038973 | 1038973 | 2021-02-17 | Douglas | Nebraska | 31055 | 63026 | 645 |
1039042 | 1039042 | 2021-02-17 | Douglas | Nevada | 32005 | 2469 | 33 |
1039511 | 1039511 | 2021-02-17 | Douglas | Oregon | 41019 | 2247 | 51 |
1039756 | 1039756 | 2021-02-17 | Douglas | South Dakota | 46043 | 420 | 9 |
1040341 | 1040341 | 2021-02-17 | Douglas | Washington | 53017 | 3200 | 22 |
1040442 | 1040442 | 2021-02-17 | Douglas | Wisconsin | 55031 | 4184 | 37 |
1034294 | 1034294 | 2021-02-16 | Douglas | Colorado | 8035 | 20879 | 230 |
1034469 | 1034469 | 2021-02-16 | Douglas | Georgia | 13097 | 12897 | 174 |
1034652 | 1034652 | 2021-02-16 | Douglas | Illinois | 17041 | 2296 | 36 |
1034949 | 1034949 | 2021-02-16 | Douglas | Kansas | 20045 | 8505 | 71 |
1035378 | 1035378 | 2021-02-16 | Douglas | Minnesota | 27041 | 3871 | 68 |
1035561 | 1035561 | 2021-02-16 | Douglas | Missouri | 29067 | 764 | 23 |
1035728 | 1035728 | 2021-02-16 | Douglas | Nebraska | 31055 | 62896 | 639 |
1035797 | 1035797 | 2021-02-16 | Douglas | Nevada | 32005 | 2465 | 32 |
1036266 | 1036266 | 2021-02-16 | Douglas | Oregon | 41019 | 2207 | 51 |
1036511 | 1036511 | 2021-02-16 | Douglas | South Dakota | 46043 | 420 | 9 |
1037096 | 1037096 | 2021-02-16 | Douglas | Washington | 53017 | 3176 | 20 |
1037197 | 1037197 | 2021-02-16 | Douglas | Wisconsin | 55031 | 4183 | 37 |
1031048 | 1031048 | 2021-02-15 | Douglas | Colorado | 8035 | 20806 | 230 |
1031223 | 1031223 | 2021-02-15 | Douglas | Georgia | 13097 | 12856 | 169 |
1031406 | 1031406 | 2021-02-15 | Douglas | Illinois | 17041 | 2284 | 36 |
1031703 | 1031703 | 2021-02-15 | Douglas | Kansas | 20045 | 8490 | 71 |
1032133 | 1032133 | 2021-02-15 | Douglas | Minnesota | 27041 | 3867 | 68 |
1032316 | 1032316 | 2021-02-15 | Douglas | Missouri | 29067 | 764 | 23 |
1032483 | 1032483 | 2021-02-15 | Douglas | Nebraska | 31055 | 62861 | 636 |
1032552 | 1032552 | 2021-02-15 | Douglas | Nevada | 32005 | 2459 | 32 |
1033021 | 1033021 | 2021-02-15 | Douglas | Oregon | 41019 | 2170 | 51 |
1033266 | 1033266 | 2021-02-15 | Douglas | South Dakota | 46043 | 419 | 9 |
1033851 | 1033851 | 2021-02-15 | Douglas | Washington | 53017 | 3174 | 20 |
1033952 | 1033952 | 2021-02-15 | Douglas | Wisconsin | 55031 | 4180 | 37 |
1027801 | 1027801 | 2021-02-14 | Douglas | Colorado | 8035 | 20613 | 230 |
1027976 | 1027976 | 2021-02-14 | Douglas | Georgia | 13097 | 12818 | 167 |
1028159 | 1028159 | 2021-02-14 | Douglas | Illinois | 17041 | 2265 | 35 |
1028456 | 1028456 | 2021-02-14 | Douglas | Kansas | 20045 | 8424 | 71 |
1028886 | 1028886 | 2021-02-14 | Douglas | Minnesota | 27041 | 3864 | 68 |
1029069 | 1029069 | 2021-02-14 | Douglas | Missouri | 29067 | 764 | 23 |
1029236 | 1029236 | 2021-02-14 | Douglas | Nebraska | 31055 | 62832 | 636 |
1029305 | 1029305 | 2021-02-14 | Douglas | Nevada | 32005 | 2459 | 32 |
1029775 | 1029775 | 2021-02-14 | Douglas | Oregon | 41019 | 2157 | 51 |
1030020 | 1030020 | 2021-02-14 | Douglas | South Dakota | 46043 | 419 | 9 |
1030605 | 1030605 | 2021-02-14 | Douglas | Washington | 53017 | 3174 | 20 |
1030706 | 1030706 | 2021-02-14 | Douglas | Wisconsin | 55031 | 4180 | 37 |
1024556 | 1024556 | 2021-02-13 | Douglas | Colorado | 8035 | 20613 | 230 |
1024731 | 1024731 | 2021-02-13 | Douglas | Georgia | 13097 | 12769 | 166 |
1024914 | 1024914 | 2021-02-13 | Douglas | Illinois | 17041 | 2265 | 35 |
1025211 | 1025211 | 2021-02-13 | Douglas | Kansas | 20045 | 8424 | 71 |
1025640 | 1025640 | 2021-02-13 | Douglas | Minnesota | 27041 | 3864 | 68 |
1025823 | 1025823 | 2021-02-13 | Douglas | Missouri | 29067 | 763 | 23 |
1025990 | 1025990 | 2021-02-13 | Douglas | Nebraska | 31055 | 62761 | 636 |
1026059 | 1026059 | 2021-02-13 | Douglas | Nevada | 32005 | 2449 | 32 |
1026528 | 1026528 | 2021-02-13 | Douglas | Oregon | 41019 | 2140 | 51 |
1026773 | 1026773 | 2021-02-13 | Douglas | South Dakota | 46043 | 418 | 9 |
1027358 | 1027358 | 2021-02-13 | Douglas | Washington | 53017 | 3174 | 20 |
1027459 | 1027459 | 2021-02-13 | Douglas | Wisconsin | 55031 | 4175 | 37 |
1021311 | 1021311 | 2021-02-12 | Douglas | Colorado | 8035 | 20560 | 230 |
1021486 | 1021486 | 2021-02-12 | Douglas | Georgia | 13097 | 12699 | 165 |
1021669 | 1021669 | 2021-02-12 | Douglas | Illinois | 17041 | 2252 | 35 |
1021966 | 1021966 | 2021-02-12 | Douglas | Kansas | 20045 | 8424 | 71 |
1022395 | 1022395 | 2021-02-12 | Douglas | Minnesota | 27041 | 3861 | 68 |
1022578 | 1022578 | 2021-02-12 | Douglas | Missouri | 29067 | 761 | 23 |
1022745 | 1022745 | 2021-02-12 | Douglas | Nebraska | 31055 | 62581 | 636 |
1022814 | 1022814 | 2021-02-12 | Douglas | Nevada | 32005 | 2449 | 32 |
1023283 | 1023283 | 2021-02-12 | Douglas | Oregon | 41019 | 2116 | 51 |
1023528 | 1023528 | 2021-02-12 | Douglas | South Dakota | 46043 | 418 | 9 |
1024113 | 1024113 | 2021-02-12 | Douglas | Washington | 53017 | 3174 | 20 |
1024214 | 1024214 | 2021-02-12 | Douglas | Wisconsin | 55031 | 4172 | 37 |
1018066 | 1018066 | 2021-02-11 | Douglas | Colorado | 8035 | 20343 | 230 |
1018241 | 1018241 | 2021-02-11 | Douglas | Georgia | 13097 | 12616 | 162 |
1018424 | 1018424 | 2021-02-11 | Douglas | Illinois | 17041 | 2229 | 35 |
1018721 | 1018721 | 2021-02-11 | Douglas | Kansas | 20045 | 8409 | 76 |
1019150 | 1019150 | 2021-02-11 | Douglas | Minnesota | 27041 | 3854 | 68 |
1019333 | 1019333 | 2021-02-11 | Douglas | Missouri | 29067 | 760 | 23 |
1019500 | 1019500 | 2021-02-11 | Douglas | Nebraska | 31055 | 62434 | 634 |
1019569 | 1019569 | 2021-02-11 | Douglas | Nevada | 32005 | 2447 | 29 |
1020038 | 1020038 | 2021-02-11 | Douglas | Oregon | 41019 | 2100 | 51 |
1020283 | 1020283 | 2021-02-11 | Douglas | South Dakota | 46043 | 417 | 9 |
1020868 | 1020868 | 2021-02-11 | Douglas | Washington | 53017 | 3168 | 20 |
1020969 | 1020969 | 2021-02-11 | Douglas | Wisconsin | 55031 | 4171 | 37 |
1014821 | 1014821 | 2021-02-10 | Douglas | Colorado | 8035 | 20336 | 230 |
1014996 | 1014996 | 2021-02-10 | Douglas | Georgia | 13097 | 12533 | 160 |
1015179 | 1015179 | 2021-02-10 | Douglas | Illinois | 17041 | 2204 | 35 |
1015476 | 1015476 | 2021-02-10 | Douglas | Kansas | 20045 | 8346 | 70 |
1015905 | 1015905 | 2021-02-10 | Douglas | Minnesota | 27041 | 3850 | 68 |
1016088 | 1016088 | 2021-02-10 | Douglas | Missouri | 29067 | 759 | 23 |
1016255 | 1016255 | 2021-02-10 | Douglas | Nebraska | 31055 | 62305 | 628 |
1016324 | 1016324 | 2021-02-10 | Douglas | Nevada | 32005 | 2442 | 29 |
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);