ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
817 rows where county = "Douglas" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
935115 | 935115 | 2021-01-16 | Douglas | Nebraska | 31055 | 58043 | 561 |
931870 | 931870 | 2021-01-15 | Douglas | Nebraska | 31055 | 58043 | 561 |
928625 | 928625 | 2021-01-14 | Douglas | Nebraska | 31055 | 57813 | 554 |
925379 | 925379 | 2021-01-13 | Douglas | Nebraska | 31055 | 57546 | 548 |
922134 | 922134 | 2021-01-12 | Douglas | Nebraska | 31055 | 57113 | 544 |
918889 | 918889 | 2021-01-11 | Douglas | Nebraska | 31055 | 56784 | 544 |
915644 | 915644 | 2021-01-10 | Douglas | Nebraska | 31055 | 56528 | 541 |
912399 | 912399 | 2021-01-09 | Douglas | Nebraska | 31055 | 56390 | 541 |
909154 | 909154 | 2021-01-08 | Douglas | Nebraska | 31055 | 56038 | 541 |
905908 | 905908 | 2021-01-07 | Douglas | Nebraska | 31055 | 55682 | 617 |
902663 | 902663 | 2021-01-06 | Douglas | Nebraska | 31055 | 55327 | 525 |
899418 | 899418 | 2021-01-05 | Douglas | Nebraska | 31055 | 54849 | 525 |
896173 | 896173 | 2021-01-04 | Douglas | Nebraska | 31055 | 54328 | 519 |
892926 | 892926 | 2021-01-03 | Douglas | Nebraska | 31055 | 54097 | 515 |
889680 | 889680 | 2021-01-02 | Douglas | Nebraska | 31055 | 53815 | 515 |
886434 | 886434 | 2021-01-01 | Douglas | Nebraska | 31055 | 53595 | 515 |
883189 | 883189 | 2020-12-31 | Douglas | Nebraska | 31055 | 53284 | 515 |
879944 | 879944 | 2020-12-30 | Douglas | Nebraska | 31055 | 52700 | 501 |
876699 | 876699 | 2020-12-29 | Douglas | Nebraska | 31055 | 52205 | 493 |
873454 | 873454 | 2020-12-28 | Douglas | Nebraska | 31055 | 51960 | 489 |
870209 | 870209 | 2020-12-27 | Douglas | Nebraska | 31055 | 51605 | 480 |
866964 | 866964 | 2020-12-26 | Douglas | Nebraska | 31055 | 51356 | 480 |
863719 | 863719 | 2020-12-25 | Douglas | Nebraska | 31055 | 51295 | 480 |
860474 | 860474 | 2020-12-24 | Douglas | Nebraska | 31055 | 50976 | 485 |
857229 | 857229 | 2020-12-23 | Douglas | Nebraska | 31055 | 50740 | 484 |
853984 | 853984 | 2020-12-22 | Douglas | Nebraska | 31055 | 50355 | 475 |
850739 | 850739 | 2020-12-21 | Douglas | Nebraska | 31055 | 49960 | 475 |
847494 | 847494 | 2020-12-20 | Douglas | Nebraska | 31055 | 49690 | 466 |
844248 | 844248 | 2020-12-19 | Douglas | Nebraska | 31055 | 49285 | 466 |
841003 | 841003 | 2020-12-18 | Douglas | Nebraska | 31055 | 49059 | 466 |
837758 | 837758 | 2020-12-17 | Douglas | Nebraska | 31055 | 48633 | 454 |
834512 | 834512 | 2020-12-16 | Douglas | Nebraska | 31055 | 48126 | 454 |
831265 | 831265 | 2020-12-15 | Douglas | Nebraska | 31055 | 47775 | 454 |
828019 | 828019 | 2020-12-14 | Douglas | Nebraska | 31055 | 47256 | 450 |
824772 | 824772 | 2020-12-13 | Douglas | Nebraska | 31055 | 47126 | 417 |
821526 | 821526 | 2020-12-12 | Douglas | Nebraska | 31055 | 46648 | 417 |
818280 | 818280 | 2020-12-11 | Douglas | Nebraska | 31055 | 46384 | 416 |
815034 | 815034 | 2020-12-10 | Douglas | Nebraska | 31055 | 46026 | 412 |
811789 | 811789 | 2020-12-09 | Douglas | Nebraska | 31055 | 45492 | 407 |
808544 | 808544 | 2020-12-08 | Douglas | Nebraska | 31055 | 45068 | 400 |
805299 | 805299 | 2020-12-07 | Douglas | Nebraska | 31055 | 44605 | 389 |
802054 | 802054 | 2020-12-06 | Douglas | Nebraska | 31055 | 44236 | 384 |
798809 | 798809 | 2020-12-05 | Douglas | Nebraska | 31055 | 43793 | 384 |
795564 | 795564 | 2020-12-04 | Douglas | Nebraska | 31055 | 42910 | 384 |
792319 | 792319 | 2020-12-03 | Douglas | Nebraska | 31055 | 42462 | 370 |
789074 | 789074 | 2020-12-02 | Douglas | Nebraska | 31055 | 41869 | 358 |
785829 | 785829 | 2020-12-01 | Douglas | Nebraska | 31055 | 41227 | 348 |
782585 | 782585 | 2020-11-30 | Douglas | Nebraska | 31055 | 40636 | 329 |
779339 | 779339 | 2020-11-29 | Douglas | Nebraska | 31055 | 39976 | 323 |
776094 | 776094 | 2020-11-28 | Douglas | Nebraska | 31055 | 39569 | 320 |
772849 | 772849 | 2020-11-27 | Douglas | Nebraska | 31055 | 39147 | 318 |
769604 | 769604 | 2020-11-26 | Douglas | Nebraska | 31055 | 38845 | 314 |
766358 | 766358 | 2020-11-25 | Douglas | Nebraska | 31055 | 37684 | 314 |
763113 | 763113 | 2020-11-24 | Douglas | Nebraska | 31055 | 36939 | 310 |
759868 | 759868 | 2020-11-23 | Douglas | Nebraska | 31055 | 36398 | 302 |
756621 | 756621 | 2020-11-22 | Douglas | Nebraska | 31055 | 35868 | 298 |
753375 | 753375 | 2020-11-21 | Douglas | Nebraska | 31055 | 35675 | 298 |
750129 | 750129 | 2020-11-20 | Douglas | Nebraska | 31055 | 35272 | 295 |
746883 | 746883 | 2020-11-19 | Douglas | Nebraska | 31055 | 34694 | 281 |
743636 | 743636 | 2020-11-18 | Douglas | Nebraska | 31055 | 33903 | 280 |
740389 | 740389 | 2020-11-17 | Douglas | Nebraska | 31055 | 32983 | 275 |
737145 | 737145 | 2020-11-16 | Douglas | Nebraska | 31055 | 32206 | 271 |
733899 | 733899 | 2020-11-15 | Douglas | Nebraska | 31055 | 30829 | 267 |
730654 | 730654 | 2020-11-14 | Douglas | Nebraska | 31055 | 30552 | 267 |
727411 | 727411 | 2020-11-13 | Douglas | Nebraska | 31055 | 30098 | 267 |
724168 | 724168 | 2020-11-12 | Douglas | Nebraska | 31055 | 29411 | 260 |
720925 | 720925 | 2020-11-11 | Douglas | Nebraska | 31055 | 28617 | 255 |
717682 | 717682 | 2020-11-10 | Douglas | Nebraska | 31055 | 28084 | 255 |
714438 | 714438 | 2020-11-09 | Douglas | Nebraska | 31055 | 27398 | 246 |
711194 | 711194 | 2020-11-08 | Douglas | Nebraska | 31055 | 26839 | 246 |
707950 | 707950 | 2020-11-07 | Douglas | Nebraska | 31055 | 26436 | 246 |
704707 | 704707 | 2020-11-06 | Douglas | Nebraska | 31055 | 25931 | 242 |
701465 | 701465 | 2020-11-05 | Douglas | Nebraska | 31055 | 25342 | 242 |
698221 | 698221 | 2020-11-04 | Douglas | Nebraska | 31055 | 24759 | 239 |
694978 | 694978 | 2020-11-03 | Douglas | Nebraska | 31055 | 24274 | 236 |
691736 | 691736 | 2020-11-02 | Douglas | Nebraska | 31055 | 23908 | 235 |
688491 | 688491 | 2020-11-01 | Douglas | Nebraska | 31055 | 23619 | 235 |
685247 | 685247 | 2020-10-31 | Douglas | Nebraska | 31055 | 23390 | 235 |
682004 | 682004 | 2020-10-30 | Douglas | Nebraska | 31055 | 23126 | 232 |
678760 | 678760 | 2020-10-29 | Douglas | Nebraska | 31055 | 22820 | 231 |
675518 | 675518 | 2020-10-28 | Douglas | Nebraska | 31055 | 22395 | 223 |
672275 | 672275 | 2020-10-27 | Douglas | Nebraska | 31055 | 22095 | 223 |
669033 | 669033 | 2020-10-26 | Douglas | Nebraska | 31055 | 21830 | 221 |
665789 | 665789 | 2020-10-25 | Douglas | Nebraska | 31055 | 21620 | 221 |
662544 | 662544 | 2020-10-24 | Douglas | Nebraska | 31055 | 21453 | 221 |
659300 | 659300 | 2020-10-23 | Douglas | Nebraska | 31055 | 21302 | 219 |
656055 | 656055 | 2020-10-22 | Douglas | Nebraska | 31055 | 21006 | 218 |
652810 | 652810 | 2020-10-21 | Douglas | Nebraska | 31055 | 20704 | 216 |
649565 | 649565 | 2020-10-20 | Douglas | Nebraska | 31055 | 20469 | 215 |
646321 | 646321 | 2020-10-19 | Douglas | Nebraska | 31055 | 20328 | 215 |
643075 | 643075 | 2020-10-18 | Douglas | Nebraska | 31055 | 20039 | 214 |
639827 | 639827 | 2020-10-17 | Douglas | Nebraska | 31055 | 19813 | 214 |
636581 | 636581 | 2020-10-16 | Douglas | Nebraska | 31055 | 19588 | 214 |
633335 | 633335 | 2020-10-15 | Douglas | Nebraska | 31055 | 19204 | 211 |
630090 | 630090 | 2020-10-14 | Douglas | Nebraska | 31055 | 18892 | 209 |
626846 | 626846 | 2020-10-13 | Douglas | Nebraska | 31055 | 18664 | 207 |
623604 | 623604 | 2020-10-12 | Douglas | Nebraska | 31055 | 18459 | 203 |
620361 | 620361 | 2020-10-11 | Douglas | Nebraska | 31055 | 18328 | 203 |
617119 | 617119 | 2020-10-10 | Douglas | Nebraska | 31055 | 18204 | 203 |
613878 | 613878 | 2020-10-09 | Douglas | Nebraska | 31055 | 17841 | 202 |
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);