ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
817 rows where fips = 31055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
610636 | 610636 | 2020-10-08 | Douglas | Nebraska | 31055 | 17750 | 198 |
607394 | 607394 | 2020-10-07 | Douglas | Nebraska | 31055 | 17547 | 198 |
604151 | 604151 | 2020-10-06 | Douglas | Nebraska | 31055 | 17366 | 197 |
600909 | 600909 | 2020-10-05 | Douglas | Nebraska | 31055 | 17188 | 196 |
597665 | 597665 | 2020-10-04 | Douglas | Nebraska | 31055 | 17089 | 196 |
594424 | 594424 | 2020-10-03 | Douglas | Nebraska | 31055 | 16938 | 196 |
591183 | 591183 | 2020-10-02 | Douglas | Nebraska | 31055 | 16831 | 196 |
587942 | 587942 | 2020-10-01 | Douglas | Nebraska | 31055 | 16614 | 195 |
584702 | 584702 | 2020-09-30 | Douglas | Nebraska | 31055 | 16438 | 194 |
581461 | 581461 | 2020-09-29 | Douglas | Nebraska | 31055 | 16297 | 194 |
578220 | 578220 | 2020-09-28 | Douglas | Nebraska | 31055 | 16164 | 193 |
574979 | 574979 | 2020-09-27 | Douglas | Nebraska | 31055 | 16027 | 193 |
571736 | 571736 | 2020-09-26 | Douglas | Nebraska | 31055 | 15864 | 193 |
568494 | 568494 | 2020-09-25 | Douglas | Nebraska | 31055 | 15702 | 193 |
565253 | 565253 | 2020-09-24 | Douglas | Nebraska | 31055 | 15629 | 191 |
562012 | 562012 | 2020-09-23 | Douglas | Nebraska | 31055 | 15509 | 191 |
558775 | 558775 | 2020-09-22 | Douglas | Nebraska | 31055 | 15363 | 190 |
555538 | 555538 | 2020-09-21 | Douglas | Nebraska | 31055 | 15264 | 182 |
552300 | 552300 | 2020-09-20 | Douglas | Nebraska | 31055 | 15198 | 181 |
549061 | 549061 | 2020-09-19 | Douglas | Nebraska | 31055 | 15121 | 181 |
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);