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 |
---|---|---|---|---|---|---|---|
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 |
545823 | 545823 | 2020-09-18 | Douglas | Nebraska | 31055 | 15017 | 181 |
542586 | 542586 | 2020-09-17 | Douglas | Nebraska | 31055 | 14901 | 181 |
539350 | 539350 | 2020-09-16 | Douglas | Nebraska | 31055 | 14765 | 180 |
536113 | 536113 | 2020-09-15 | Douglas | Nebraska | 31055 | 14662 | 178 |
532878 | 532878 | 2020-09-14 | Douglas | Nebraska | 31055 | 14577 | 178 |
529642 | 529642 | 2020-09-13 | Douglas | Nebraska | 31055 | 14488 | 178 |
526406 | 526406 | 2020-09-12 | Douglas | Nebraska | 31055 | 14430 | 178 |
523170 | 523170 | 2020-09-11 | Douglas | Nebraska | 31055 | 14362 | 178 |
519933 | 519933 | 2020-09-10 | Douglas | Nebraska | 31055 | 14276 | 176 |
516698 | 516698 | 2020-09-09 | Douglas | Nebraska | 31055 | 14172 | 172 |
513464 | 513464 | 2020-09-08 | Douglas | Nebraska | 31055 | 14056 | 169 |
510232 | 510232 | 2020-09-07 | Douglas | Nebraska | 31055 | 13963 | 169 |
506999 | 506999 | 2020-09-06 | Douglas | Nebraska | 31055 | 13963 | 169 |
503766 | 503766 | 2020-09-05 | Douglas | Nebraska | 31055 | 13917 | 169 |
500532 | 500532 | 2020-09-04 | Douglas | Nebraska | 31055 | 13866 | 165 |
497298 | 497298 | 2020-09-03 | Douglas | Nebraska | 31055 | 13797 | 164 |
494065 | 494065 | 2020-09-02 | Douglas | Nebraska | 31055 | 13685 | 164 |
490831 | 490831 | 2020-09-01 | Douglas | Nebraska | 31055 | 13573 | 162 |
487598 | 487598 | 2020-08-31 | Douglas | Nebraska | 31055 | 13496 | 160 |
484364 | 484364 | 2020-08-30 | Douglas | Nebraska | 31055 | 13445 | 160 |
481129 | 481129 | 2020-08-29 | Douglas | Nebraska | 31055 | 13352 | 160 |
477897 | 477897 | 2020-08-28 | Douglas | Nebraska | 31055 | 13221 | 160 |
474664 | 474664 | 2020-08-27 | Douglas | Nebraska | 31055 | 13109 | 158 |
471432 | 471432 | 2020-08-26 | Douglas | Nebraska | 31055 | 12958 | 155 |
468202 | 468202 | 2020-08-25 | Douglas | Nebraska | 31055 | 12878 | 153 |
464973 | 464973 | 2020-08-24 | Douglas | Nebraska | 31055 | 12735 | 150 |
461742 | 461742 | 2020-08-23 | Douglas | Nebraska | 31055 | 12679 | 150 |
458515 | 458515 | 2020-08-22 | Douglas | Nebraska | 31055 | 12614 | 150 |
455287 | 455287 | 2020-08-21 | Douglas | Nebraska | 31055 | 12534 | 149 |
452059 | 452059 | 2020-08-20 | Douglas | Nebraska | 31055 | 12435 | 148 |
448831 | 448831 | 2020-08-19 | Douglas | Nebraska | 31055 | 12360 | 147 |
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);