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 |
---|---|---|---|---|---|---|---|
534685 | 534685 | 2020-09-15 | Douglas | Colorado | 8035 | 2350 | 60 |
534859 | 534859 | 2020-09-15 | Douglas | Georgia | 13097 | 3373 | 69 |
535041 | 535041 | 2020-09-15 | Douglas | Illinois | 17041 | 267 | 5 |
535338 | 535338 | 2020-09-15 | Douglas | Kansas | 20045 | 1935 | 10 |
535766 | 535766 | 2020-09-15 | Douglas | Minnesota | 27041 | 210 | 1 |
535949 | 535949 | 2020-09-15 | Douglas | Missouri | 29067 | 139 | 3 |
536113 | 536113 | 2020-09-15 | Douglas | Nebraska | 31055 | 14662 | 178 |
536181 | 536181 | 2020-09-15 | Douglas | Nevada | 32005 | 275 | 1 |
536651 | 536651 | 2020-09-15 | Douglas | Oregon | 41019 | 192 | 3 |
536895 | 536895 | 2020-09-15 | Douglas | South Dakota | 46043 | 44 | 0 |
537477 | 537477 | 2020-09-15 | Douglas | Washington | 53017 | 1252 | 10 |
537579 | 537579 | 2020-09-15 | Douglas | Wisconsin | 55031 | 343 | 0 |
531450 | 531450 | 2020-09-14 | Douglas | Colorado | 8035 | 2326 | 60 |
531624 | 531624 | 2020-09-14 | Douglas | Georgia | 13097 | 3358 | 69 |
531806 | 531806 | 2020-09-14 | Douglas | Illinois | 17041 | 262 | 5 |
532103 | 532103 | 2020-09-14 | Douglas | Kansas | 20045 | 1895 | 10 |
532531 | 532531 | 2020-09-14 | Douglas | Minnesota | 27041 | 206 | 1 |
532714 | 532714 | 2020-09-14 | Douglas | Missouri | 29067 | 137 | 3 |
532878 | 532878 | 2020-09-14 | Douglas | Nebraska | 31055 | 14577 | 178 |
532946 | 532946 | 2020-09-14 | Douglas | Nevada | 32005 | 272 | 1 |
533415 | 533415 | 2020-09-14 | Douglas | Oregon | 41019 | 191 | 3 |
533659 | 533659 | 2020-09-14 | Douglas | South Dakota | 46043 | 43 | 0 |
534241 | 534241 | 2020-09-14 | Douglas | Washington | 53017 | 1244 | 10 |
534343 | 534343 | 2020-09-14 | Douglas | Wisconsin | 55031 | 343 | 0 |
528213 | 528213 | 2020-09-13 | Douglas | Colorado | 8035 | 2312 | 60 |
528387 | 528387 | 2020-09-13 | Douglas | Georgia | 13097 | 3350 | 68 |
528569 | 528569 | 2020-09-13 | Douglas | Illinois | 17041 | 260 | 5 |
528866 | 528866 | 2020-09-13 | Douglas | Kansas | 20045 | 1823 | 10 |
529295 | 529295 | 2020-09-13 | Douglas | Minnesota | 27041 | 200 | 1 |
529478 | 529478 | 2020-09-13 | Douglas | Missouri | 29067 | 137 | 3 |
529642 | 529642 | 2020-09-13 | Douglas | Nebraska | 31055 | 14488 | 178 |
529710 | 529710 | 2020-09-13 | Douglas | Nevada | 32005 | 272 | 1 |
530180 | 530180 | 2020-09-13 | Douglas | Oregon | 41019 | 188 | 3 |
530424 | 530424 | 2020-09-13 | Douglas | South Dakota | 46043 | 43 | 0 |
531006 | 531006 | 2020-09-13 | Douglas | Washington | 53017 | 1235 | 10 |
531108 | 531108 | 2020-09-13 | Douglas | Wisconsin | 55031 | 336 | 0 |
524977 | 524977 | 2020-09-12 | Douglas | Colorado | 8035 | 2299 | 60 |
525151 | 525151 | 2020-09-12 | Douglas | Georgia | 13097 | 3343 | 68 |
525333 | 525333 | 2020-09-12 | Douglas | Illinois | 17041 | 254 | 5 |
525630 | 525630 | 2020-09-12 | Douglas | Kansas | 20045 | 1823 | 10 |
526059 | 526059 | 2020-09-12 | Douglas | Minnesota | 27041 | 197 | 1 |
526242 | 526242 | 2020-09-12 | Douglas | Missouri | 29067 | 134 | 3 |
526406 | 526406 | 2020-09-12 | Douglas | Nebraska | 31055 | 14430 | 178 |
526474 | 526474 | 2020-09-12 | Douglas | Nevada | 32005 | 270 | 1 |
526943 | 526943 | 2020-09-12 | Douglas | Oregon | 41019 | 187 | 3 |
527187 | 527187 | 2020-09-12 | Douglas | South Dakota | 46043 | 42 | 0 |
527769 | 527769 | 2020-09-12 | Douglas | Washington | 53017 | 1235 | 10 |
527871 | 527871 | 2020-09-12 | Douglas | Wisconsin | 55031 | 327 | 0 |
521741 | 521741 | 2020-09-11 | Douglas | Colorado | 8035 | 2287 | 60 |
521915 | 521915 | 2020-09-11 | Douglas | Georgia | 13097 | 3319 | 68 |
522097 | 522097 | 2020-09-11 | Douglas | Illinois | 17041 | 249 | 5 |
522394 | 522394 | 2020-09-11 | Douglas | Kansas | 20045 | 1823 | 10 |
522823 | 522823 | 2020-09-11 | Douglas | Minnesota | 27041 | 194 | 1 |
523006 | 523006 | 2020-09-11 | Douglas | Missouri | 29067 | 132 | 3 |
523170 | 523170 | 2020-09-11 | Douglas | Nebraska | 31055 | 14362 | 178 |
523238 | 523238 | 2020-09-11 | Douglas | Nevada | 32005 | 268 | 1 |
523707 | 523707 | 2020-09-11 | Douglas | Oregon | 41019 | 183 | 3 |
523951 | 523951 | 2020-09-11 | Douglas | South Dakota | 46043 | 40 | 0 |
524533 | 524533 | 2020-09-11 | Douglas | Washington | 53017 | 1235 | 10 |
524635 | 524635 | 2020-09-11 | Douglas | Wisconsin | 55031 | 309 | 0 |
518504 | 518504 | 2020-09-10 | Douglas | Colorado | 8035 | 2277 | 60 |
518678 | 518678 | 2020-09-10 | Douglas | Georgia | 13097 | 3308 | 68 |
518860 | 518860 | 2020-09-10 | Douglas | Illinois | 17041 | 247 | 5 |
519157 | 519157 | 2020-09-10 | Douglas | Kansas | 20045 | 1792 | 9 |
519586 | 519586 | 2020-09-10 | Douglas | Minnesota | 27041 | 193 | 1 |
519769 | 519769 | 2020-09-10 | Douglas | Missouri | 29067 | 128 | 3 |
519933 | 519933 | 2020-09-10 | Douglas | Nebraska | 31055 | 14276 | 176 |
520001 | 520001 | 2020-09-10 | Douglas | Nevada | 32005 | 265 | 1 |
520471 | 520471 | 2020-09-10 | Douglas | Oregon | 41019 | 182 | 3 |
520715 | 520715 | 2020-09-10 | Douglas | South Dakota | 46043 | 37 | 0 |
521297 | 521297 | 2020-09-10 | Douglas | Washington | 53017 | 1233 | 9 |
521399 | 521399 | 2020-09-10 | Douglas | Wisconsin | 55031 | 301 | 0 |
515269 | 515269 | 2020-09-09 | Douglas | Colorado | 8035 | 2255 | 60 |
515443 | 515443 | 2020-09-09 | Douglas | Georgia | 13097 | 3293 | 68 |
515625 | 515625 | 2020-09-09 | Douglas | Illinois | 17041 | 242 | 5 |
515922 | 515922 | 2020-09-09 | Douglas | Kansas | 20045 | 1772 | 9 |
516351 | 516351 | 2020-09-09 | Douglas | Minnesota | 27041 | 191 | 1 |
516534 | 516534 | 2020-09-09 | Douglas | Missouri | 29067 | 124 | 3 |
516698 | 516698 | 2020-09-09 | Douglas | Nebraska | 31055 | 14172 | 172 |
516766 | 516766 | 2020-09-09 | Douglas | Nevada | 32005 | 264 | 1 |
517235 | 517235 | 2020-09-09 | Douglas | Oregon | 41019 | 182 | 3 |
517479 | 517479 | 2020-09-09 | Douglas | South Dakota | 46043 | 34 | 0 |
518060 | 518060 | 2020-09-09 | Douglas | Washington | 53017 | 1228 | 9 |
518162 | 518162 | 2020-09-09 | Douglas | Wisconsin | 55031 | 300 | 0 |
512036 | 512036 | 2020-09-08 | Douglas | Colorado | 8035 | 2243 | 60 |
512210 | 512210 | 2020-09-08 | Douglas | Georgia | 13097 | 3269 | 67 |
512392 | 512392 | 2020-09-08 | Douglas | Illinois | 17041 | 240 | 5 |
512689 | 512689 | 2020-09-08 | Douglas | Kansas | 20045 | 1739 | 9 |
513117 | 513117 | 2020-09-08 | Douglas | Minnesota | 27041 | 189 | 1 |
513300 | 513300 | 2020-09-08 | Douglas | Missouri | 29067 | 120 | 3 |
513464 | 513464 | 2020-09-08 | Douglas | Nebraska | 31055 | 14056 | 169 |
513532 | 513532 | 2020-09-08 | Douglas | Nevada | 32005 | 261 | 1 |
514000 | 514000 | 2020-09-08 | Douglas | Oregon | 41019 | 182 | 3 |
514244 | 514244 | 2020-09-08 | Douglas | South Dakota | 46043 | 32 | 0 |
514825 | 514825 | 2020-09-08 | Douglas | Washington | 53017 | 1216 | 9 |
514927 | 514927 | 2020-09-08 | Douglas | Wisconsin | 55031 | 296 | 0 |
508803 | 508803 | 2020-09-07 | Douglas | Colorado | 8035 | 2223 | 60 |
508977 | 508977 | 2020-09-07 | Douglas | Georgia | 13097 | 3260 | 67 |
509159 | 509159 | 2020-09-07 | Douglas | Illinois | 17041 | 241 | 5 |
509456 | 509456 | 2020-09-07 | Douglas | Kansas | 20045 | 1600 | 9 |
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);