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 |
---|---|---|---|---|---|---|---|
1053768 | 1053768 | 2021-02-22 | Douglas | Colorado | 8035 | 21347 | 230 |
1053943 | 1053943 | 2021-02-22 | Douglas | Georgia | 13097 | 13174 | 175 |
1054126 | 1054126 | 2021-02-22 | Douglas | Illinois | 17041 | 2402 | 38 |
1054423 | 1054423 | 2021-02-22 | Douglas | Kansas | 20045 | 8570 | 76 |
1054853 | 1054853 | 2021-02-22 | Douglas | Minnesota | 27041 | 3897 | 68 |
1055036 | 1055036 | 2021-02-22 | Douglas | Missouri | 29067 | 765 | 23 |
1055203 | 1055203 | 2021-02-22 | Douglas | Nebraska | 31055 | 63437 | 652 |
1055272 | 1055272 | 2021-02-22 | Douglas | Nevada | 32005 | 2486 | 33 |
1055741 | 1055741 | 2021-02-22 | Douglas | Oregon | 41019 | 2346 | 51 |
1055986 | 1055986 | 2021-02-22 | Douglas | South Dakota | 46043 | 424 | 9 |
1056571 | 1056571 | 2021-02-22 | Douglas | Washington | 53017 | 3208 | 22 |
1056672 | 1056672 | 2021-02-22 | Douglas | Wisconsin | 55031 | 4204 | 38 |
1050521 | 1050521 | 2021-02-21 | Douglas | Colorado | 8035 | 21290 | 230 |
1050696 | 1050696 | 2021-02-21 | Douglas | Georgia | 13097 | 13138 | 175 |
1050879 | 1050879 | 2021-02-21 | Douglas | Illinois | 17041 | 2393 | 38 |
1051176 | 1051176 | 2021-02-21 | Douglas | Kansas | 20045 | 8548 | 71 |
1051606 | 1051606 | 2021-02-21 | Douglas | Minnesota | 27041 | 3895 | 68 |
1051789 | 1051789 | 2021-02-21 | Douglas | Missouri | 29067 | 765 | 23 |
1051956 | 1051956 | 2021-02-21 | Douglas | Nebraska | 31055 | 63326 | 650 |
1052025 | 1052025 | 2021-02-21 | Douglas | Nevada | 32005 | 2481 | 33 |
1052495 | 1052495 | 2021-02-21 | Douglas | Oregon | 41019 | 2333 | 51 |
1052740 | 1052740 | 2021-02-21 | Douglas | South Dakota | 46043 | 424 | 9 |
1053325 | 1053325 | 2021-02-21 | Douglas | Washington | 53017 | 3207 | 22 |
1053426 | 1053426 | 2021-02-21 | Douglas | Wisconsin | 55031 | 4199 | 38 |
1047274 | 1047274 | 2021-02-20 | Douglas | Colorado | 8035 | 21225 | 230 |
1047449 | 1047449 | 2021-02-20 | Douglas | Georgia | 13097 | 13109 | 175 |
1047632 | 1047632 | 2021-02-20 | Douglas | Illinois | 17041 | 2383 | 37 |
1047929 | 1047929 | 2021-02-20 | Douglas | Kansas | 20045 | 8548 | 71 |
1048359 | 1048359 | 2021-02-20 | Douglas | Minnesota | 27041 | 3888 | 68 |
1048542 | 1048542 | 2021-02-20 | Douglas | Missouri | 29067 | 765 | 23 |
1048709 | 1048709 | 2021-02-20 | Douglas | Nebraska | 31055 | 63254 | 650 |
1048778 | 1048778 | 2021-02-20 | Douglas | Nevada | 32005 | 2475 | 33 |
1049248 | 1049248 | 2021-02-20 | Douglas | Oregon | 41019 | 2312 | 51 |
1049493 | 1049493 | 2021-02-20 | Douglas | South Dakota | 46043 | 422 | 9 |
1050078 | 1050078 | 2021-02-20 | Douglas | Washington | 53017 | 3207 | 22 |
1050179 | 1050179 | 2021-02-20 | Douglas | Wisconsin | 55031 | 4198 | 38 |
1044029 | 1044029 | 2021-02-19 | Douglas | Colorado | 8035 | 21144 | 230 |
1044204 | 1044204 | 2021-02-19 | Douglas | Georgia | 13097 | 13052 | 175 |
1044387 | 1044387 | 2021-02-19 | Douglas | Illinois | 17041 | 2362 | 37 |
1044684 | 1044684 | 2021-02-19 | Douglas | Kansas | 20045 | 8548 | 71 |
1045113 | 1045113 | 2021-02-19 | Douglas | Minnesota | 27041 | 3882 | 68 |
1045296 | 1045296 | 2021-02-19 | Douglas | Missouri | 29067 | 765 | 23 |
1045463 | 1045463 | 2021-02-19 | Douglas | Nebraska | 31055 | 63238 | 650 |
1045532 | 1045532 | 2021-02-19 | Douglas | Nevada | 32005 | 2475 | 33 |
1046001 | 1046001 | 2021-02-19 | Douglas | Oregon | 41019 | 2292 | 51 |
1046246 | 1046246 | 2021-02-19 | Douglas | South Dakota | 46043 | 422 | 9 |
1046831 | 1046831 | 2021-02-19 | Douglas | Washington | 53017 | 3207 | 22 |
1046932 | 1046932 | 2021-02-19 | Douglas | Wisconsin | 55031 | 4193 | 38 |
1040784 | 1040784 | 2021-02-18 | Douglas | Colorado | 8035 | 21061 | 230 |
1040959 | 1040959 | 2021-02-18 | Douglas | Georgia | 13097 | 12998 | 175 |
1041142 | 1041142 | 2021-02-18 | Douglas | Illinois | 17041 | 2327 | 36 |
1041439 | 1041439 | 2021-02-18 | Douglas | Kansas | 20045 | 8533 | 71 |
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 |
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);