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 |
---|---|---|---|---|---|---|---|
635147 | 635147 | 2020-10-16 | Douglas | Colorado | 8035 | 3335 | 63 |
635322 | 635322 | 2020-10-16 | Douglas | Georgia | 13097 | 4166 | 71 |
635504 | 635504 | 2020-10-16 | Douglas | Illinois | 17041 | 470 | 8 |
635801 | 635801 | 2020-10-16 | Douglas | Kansas | 20045 | 2689 | 15 |
636231 | 636231 | 2020-10-16 | Douglas | Minnesota | 27041 | 556 | 3 |
636414 | 636414 | 2020-10-16 | Douglas | Missouri | 29067 | 259 | 3 |
636581 | 636581 | 2020-10-16 | Douglas | Nebraska | 31055 | 19588 | 214 |
636651 | 636651 | 2020-10-16 | Douglas | Nevada | 32005 | 370 | 1 |
637119 | 637119 | 2020-10-16 | Douglas | Oregon | 41019 | 306 | 4 |
637364 | 637364 | 2020-10-16 | Douglas | South Dakota | 46043 | 145 | 3 |
637947 | 637947 | 2020-10-16 | Douglas | Washington | 53017 | 1377 | 10 |
638049 | 638049 | 2020-10-16 | Douglas | Wisconsin | 55031 | 679 | 1 |
631901 | 631901 | 2020-10-15 | Douglas | Colorado | 8035 | 3297 | 63 |
632076 | 632076 | 2020-10-15 | Douglas | Georgia | 13097 | 4151 | 71 |
632258 | 632258 | 2020-10-15 | Douglas | Illinois | 17041 | 447 | 8 |
632555 | 632555 | 2020-10-15 | Douglas | Kansas | 20045 | 2681 | 14 |
632985 | 632985 | 2020-10-15 | Douglas | Minnesota | 27041 | 532 | 3 |
633168 | 633168 | 2020-10-15 | Douglas | Missouri | 29067 | 256 | 3 |
633335 | 633335 | 2020-10-15 | Douglas | Nebraska | 31055 | 19204 | 211 |
633405 | 633405 | 2020-10-15 | Douglas | Nevada | 32005 | 368 | 1 |
633873 | 633873 | 2020-10-15 | Douglas | Oregon | 41019 | 301 | 4 |
634118 | 634118 | 2020-10-15 | Douglas | South Dakota | 46043 | 142 | 2 |
634702 | 634702 | 2020-10-15 | Douglas | Washington | 53017 | 1372 | 10 |
634804 | 634804 | 2020-10-15 | Douglas | Wisconsin | 55031 | 661 | 1 |
628657 | 628657 | 2020-10-14 | Douglas | Colorado | 8035 | 3241 | 63 |
628832 | 628832 | 2020-10-14 | Douglas | Georgia | 13097 | 4132 | 71 |
629014 | 629014 | 2020-10-14 | Douglas | Illinois | 17041 | 420 | 8 |
629311 | 629311 | 2020-10-14 | Douglas | Kansas | 20045 | 2660 | 14 |
629740 | 629740 | 2020-10-14 | Douglas | Minnesota | 27041 | 528 | 3 |
629923 | 629923 | 2020-10-14 | Douglas | Missouri | 29067 | 251 | 3 |
630090 | 630090 | 2020-10-14 | Douglas | Nebraska | 31055 | 18892 | 209 |
630160 | 630160 | 2020-10-14 | Douglas | Nevada | 32005 | 364 | 1 |
630628 | 630628 | 2020-10-14 | Douglas | Oregon | 41019 | 296 | 4 |
630873 | 630873 | 2020-10-14 | Douglas | South Dakota | 46043 | 136 | 2 |
631457 | 631457 | 2020-10-14 | Douglas | Washington | 53017 | 1369 | 10 |
631559 | 631559 | 2020-10-14 | Douglas | Wisconsin | 55031 | 654 | 1 |
625414 | 625414 | 2020-10-13 | Douglas | Colorado | 8035 | 3208 | 63 |
625589 | 625589 | 2020-10-13 | Douglas | Georgia | 13097 | 4119 | 71 |
625771 | 625771 | 2020-10-13 | Douglas | Illinois | 17041 | 398 | 8 |
626068 | 626068 | 2020-10-13 | Douglas | Kansas | 20045 | 2642 | 14 |
626496 | 626496 | 2020-10-13 | Douglas | Minnesota | 27041 | 523 | 3 |
626679 | 626679 | 2020-10-13 | Douglas | Missouri | 29067 | 248 | 3 |
626846 | 626846 | 2020-10-13 | Douglas | Nebraska | 31055 | 18664 | 207 |
626916 | 626916 | 2020-10-13 | Douglas | Nevada | 32005 | 361 | 1 |
627384 | 627384 | 2020-10-13 | Douglas | Oregon | 41019 | 288 | 4 |
627629 | 627629 | 2020-10-13 | Douglas | South Dakota | 46043 | 133 | 1 |
628213 | 628213 | 2020-10-13 | Douglas | Washington | 53017 | 1364 | 10 |
628315 | 628315 | 2020-10-13 | Douglas | Wisconsin | 55031 | 645 | 1 |
622171 | 622171 | 2020-10-12 | Douglas | Colorado | 8035 | 3178 | 63 |
622346 | 622346 | 2020-10-12 | Douglas | Georgia | 13097 | 4105 | 70 |
622529 | 622529 | 2020-10-12 | Douglas | Illinois | 17041 | 385 | 8 |
622826 | 622826 | 2020-10-12 | Douglas | Kansas | 20045 | 2625 | 14 |
623254 | 623254 | 2020-10-12 | Douglas | Minnesota | 27041 | 522 | 3 |
623437 | 623437 | 2020-10-12 | Douglas | Missouri | 29067 | 248 | 3 |
623604 | 623604 | 2020-10-12 | Douglas | Nebraska | 31055 | 18459 | 203 |
623674 | 623674 | 2020-10-12 | Douglas | Nevada | 32005 | 352 | 1 |
624142 | 624142 | 2020-10-12 | Douglas | Oregon | 41019 | 287 | 4 |
624387 | 624387 | 2020-10-12 | Douglas | South Dakota | 46043 | 133 | 1 |
624970 | 624970 | 2020-10-12 | Douglas | Washington | 53017 | 1351 | 10 |
625072 | 625072 | 2020-10-12 | Douglas | Wisconsin | 55031 | 631 | 0 |
618928 | 618928 | 2020-10-11 | Douglas | Colorado | 8035 | 3125 | 63 |
619103 | 619103 | 2020-10-11 | Douglas | Georgia | 13097 | 4072 | 70 |
619285 | 619285 | 2020-10-11 | Douglas | Illinois | 17041 | 375 | 7 |
619582 | 619582 | 2020-10-11 | Douglas | Kansas | 20045 | 2573 | 14 |
620011 | 620011 | 2020-10-11 | Douglas | Minnesota | 27041 | 515 | 3 |
620194 | 620194 | 2020-10-11 | Douglas | Missouri | 29067 | 248 | 3 |
620361 | 620361 | 2020-10-11 | Douglas | Nebraska | 31055 | 18328 | 203 |
620431 | 620431 | 2020-10-11 | Douglas | Nevada | 32005 | 348 | 1 |
620899 | 620899 | 2020-10-11 | Douglas | Oregon | 41019 | 287 | 4 |
621144 | 621144 | 2020-10-11 | Douglas | South Dakota | 46043 | 133 | 1 |
621727 | 621727 | 2020-10-11 | Douglas | Washington | 53017 | 1345 | 10 |
621829 | 621829 | 2020-10-11 | Douglas | Wisconsin | 55031 | 628 | 0 |
615686 | 615686 | 2020-10-10 | Douglas | Colorado | 8035 | 3110 | 63 |
615861 | 615861 | 2020-10-10 | Douglas | Georgia | 13097 | 4043 | 70 |
616043 | 616043 | 2020-10-10 | Douglas | Illinois | 17041 | 368 | 7 |
616340 | 616340 | 2020-10-10 | Douglas | Kansas | 20045 | 2573 | 14 |
616769 | 616769 | 2020-10-10 | Douglas | Minnesota | 27041 | 500 | 3 |
616952 | 616952 | 2020-10-10 | Douglas | Missouri | 29067 | 248 | 3 |
617119 | 617119 | 2020-10-10 | Douglas | Nebraska | 31055 | 18204 | 203 |
617189 | 617189 | 2020-10-10 | Douglas | Nevada | 32005 | 345 | 1 |
617657 | 617657 | 2020-10-10 | Douglas | Oregon | 41019 | 283 | 4 |
617901 | 617901 | 2020-10-10 | Douglas | South Dakota | 46043 | 125 | 1 |
618484 | 618484 | 2020-10-10 | Douglas | Washington | 53017 | 1345 | 10 |
618586 | 618586 | 2020-10-10 | Douglas | Wisconsin | 55031 | 622 | 0 |
612445 | 612445 | 2020-10-09 | Douglas | Colorado | 8035 | 3063 | 63 |
612620 | 612620 | 2020-10-09 | Douglas | Georgia | 13097 | 4013 | 70 |
612802 | 612802 | 2020-10-09 | Douglas | Illinois | 17041 | 364 | 7 |
613099 | 613099 | 2020-10-09 | Douglas | Kansas | 20045 | 2573 | 14 |
613528 | 613528 | 2020-10-09 | Douglas | Minnesota | 27041 | 489 | 3 |
613711 | 613711 | 2020-10-09 | Douglas | Missouri | 29067 | 236 | 3 |
613878 | 613878 | 2020-10-09 | Douglas | Nebraska | 31055 | 17841 | 202 |
613947 | 613947 | 2020-10-09 | Douglas | Nevada | 32005 | 342 | 1 |
614415 | 614415 | 2020-10-09 | Douglas | Oregon | 41019 | 281 | 4 |
614659 | 614659 | 2020-10-09 | Douglas | South Dakota | 46043 | 119 | 1 |
615242 | 615242 | 2020-10-09 | Douglas | Washington | 53017 | 1345 | 10 |
615344 | 615344 | 2020-10-09 | Douglas | Wisconsin | 55031 | 609 | 0 |
609203 | 609203 | 2020-10-08 | Douglas | Colorado | 8035 | 3028 | 63 |
609378 | 609378 | 2020-10-08 | Douglas | Georgia | 13097 | 3995 | 70 |
609560 | 609560 | 2020-10-08 | Douglas | Illinois | 17041 | 363 | 7 |
609857 | 609857 | 2020-10-08 | Douglas | Kansas | 20045 | 2524 | 14 |
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);