ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Johnson" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922155 | 922155 | 2021-01-12 | Johnson | Nebraska | 31097 | 583 | 6 |
918910 | 918910 | 2021-01-11 | Johnson | Nebraska | 31097 | 581 | 6 |
915665 | 915665 | 2021-01-10 | Johnson | Nebraska | 31097 | 578 | 5 |
912420 | 912420 | 2021-01-09 | Johnson | Nebraska | 31097 | 576 | 5 |
909175 | 909175 | 2021-01-08 | Johnson | Nebraska | 31097 | 565 | 5 |
905929 | 905929 | 2021-01-07 | Johnson | Nebraska | 31097 | 563 | 5 |
902684 | 902684 | 2021-01-06 | Johnson | Nebraska | 31097 | 557 | 5 |
899439 | 899439 | 2021-01-05 | Johnson | Nebraska | 31097 | 548 | 5 |
896194 | 896194 | 2021-01-04 | Johnson | Nebraska | 31097 | 546 | 5 |
892947 | 892947 | 2021-01-03 | Johnson | Nebraska | 31097 | 545 | 5 |
889701 | 889701 | 2021-01-02 | Johnson | Nebraska | 31097 | 545 | 5 |
886455 | 886455 | 2021-01-01 | Johnson | Nebraska | 31097 | 543 | 5 |
883210 | 883210 | 2020-12-31 | Johnson | Nebraska | 31097 | 540 | 5 |
879965 | 879965 | 2020-12-30 | Johnson | Nebraska | 31097 | 536 | 5 |
876720 | 876720 | 2020-12-29 | Johnson | Nebraska | 31097 | 536 | 5 |
873475 | 873475 | 2020-12-28 | Johnson | Nebraska | 31097 | 532 | 5 |
870230 | 870230 | 2020-12-27 | Johnson | Nebraska | 31097 | 499 | 5 |
866985 | 866985 | 2020-12-26 | Johnson | Nebraska | 31097 | 493 | 5 |
863740 | 863740 | 2020-12-25 | Johnson | Nebraska | 31097 | 493 | 5 |
860495 | 860495 | 2020-12-24 | Johnson | Nebraska | 31097 | 492 | 5 |
857250 | 857250 | 2020-12-23 | Johnson | Nebraska | 31097 | 485 | 5 |
854005 | 854005 | 2020-12-22 | Johnson | Nebraska | 31097 | 484 | 4 |
850760 | 850760 | 2020-12-21 | Johnson | Nebraska | 31097 | 477 | 4 |
847515 | 847515 | 2020-12-20 | Johnson | Nebraska | 31097 | 475 | 4 |
844269 | 844269 | 2020-12-19 | Johnson | Nebraska | 31097 | 471 | 4 |
841024 | 841024 | 2020-12-18 | Johnson | Nebraska | 31097 | 463 | 4 |
837779 | 837779 | 2020-12-17 | Johnson | Nebraska | 31097 | 458 | 4 |
834533 | 834533 | 2020-12-16 | Johnson | Nebraska | 31097 | 451 | 4 |
831286 | 831286 | 2020-12-15 | Johnson | Nebraska | 31097 | 442 | 4 |
828040 | 828040 | 2020-12-14 | Johnson | Nebraska | 31097 | 397 | 5 |
824793 | 824793 | 2020-12-13 | Johnson | Nebraska | 31097 | 397 | 5 |
821547 | 821547 | 2020-12-12 | Johnson | Nebraska | 31097 | 386 | 5 |
818301 | 818301 | 2020-12-11 | Johnson | Nebraska | 31097 | 383 | 5 |
815055 | 815055 | 2020-12-10 | Johnson | Nebraska | 31097 | 379 | 5 |
811810 | 811810 | 2020-12-09 | Johnson | Nebraska | 31097 | 351 | 5 |
808565 | 808565 | 2020-12-08 | Johnson | Nebraska | 31097 | 344 | 5 |
805320 | 805320 | 2020-12-07 | Johnson | Nebraska | 31097 | 343 | 3 |
802075 | 802075 | 2020-12-06 | Johnson | Nebraska | 31097 | 342 | 2 |
798830 | 798830 | 2020-12-05 | Johnson | Nebraska | 31097 | 341 | 2 |
795585 | 795585 | 2020-12-04 | Johnson | Nebraska | 31097 | 339 | 2 |
792340 | 792340 | 2020-12-03 | Johnson | Nebraska | 31097 | 337 | 2 |
789095 | 789095 | 2020-12-02 | Johnson | Nebraska | 31097 | 325 | 2 |
785850 | 785850 | 2020-12-01 | Johnson | Nebraska | 31097 | 321 | 2 |
782606 | 782606 | 2020-11-30 | Johnson | Nebraska | 31097 | 317 | 2 |
779360 | 779360 | 2020-11-29 | Johnson | Nebraska | 31097 | 314 | 2 |
776115 | 776115 | 2020-11-28 | Johnson | Nebraska | 31097 | 313 | 2 |
772870 | 772870 | 2020-11-27 | Johnson | Nebraska | 31097 | 306 | 2 |
769625 | 769625 | 2020-11-26 | Johnson | Nebraska | 31097 | 304 | 2 |
766379 | 766379 | 2020-11-25 | Johnson | Nebraska | 31097 | 303 | 2 |
763134 | 763134 | 2020-11-24 | Johnson | Nebraska | 31097 | 304 | 1 |
759889 | 759889 | 2020-11-23 | Johnson | Nebraska | 31097 | 304 | 1 |
756642 | 756642 | 2020-11-22 | Johnson | Nebraska | 31097 | 302 | 1 |
753396 | 753396 | 2020-11-21 | Johnson | Nebraska | 31097 | 302 | 1 |
750150 | 750150 | 2020-11-20 | Johnson | Nebraska | 31097 | 300 | 1 |
746904 | 746904 | 2020-11-19 | Johnson | Nebraska | 31097 | 295 | 1 |
743657 | 743657 | 2020-11-18 | Johnson | Nebraska | 31097 | 285 | 1 |
740410 | 740410 | 2020-11-17 | Johnson | Nebraska | 31097 | 271 | 1 |
737166 | 737166 | 2020-11-16 | Johnson | Nebraska | 31097 | 266 | 1 |
733920 | 733920 | 2020-11-15 | Johnson | Nebraska | 31097 | 266 | 1 |
730675 | 730675 | 2020-11-14 | Johnson | Nebraska | 31097 | 239 | 1 |
727432 | 727432 | 2020-11-13 | Johnson | Nebraska | 31097 | 238 | 1 |
724189 | 724189 | 2020-11-12 | Johnson | Nebraska | 31097 | 161 | 1 |
720946 | 720946 | 2020-11-11 | Johnson | Nebraska | 31097 | 156 | 0 |
717703 | 717703 | 2020-11-10 | Johnson | Nebraska | 31097 | 153 | 0 |
714459 | 714459 | 2020-11-09 | Johnson | Nebraska | 31097 | 151 | 0 |
711215 | 711215 | 2020-11-08 | Johnson | Nebraska | 31097 | 147 | 0 |
707971 | 707971 | 2020-11-07 | Johnson | Nebraska | 31097 | 145 | 0 |
704728 | 704728 | 2020-11-06 | Johnson | Nebraska | 31097 | 143 | 0 |
701486 | 701486 | 2020-11-05 | Johnson | Nebraska | 31097 | 138 | 0 |
698242 | 698242 | 2020-11-04 | Johnson | Nebraska | 31097 | 125 | 0 |
694999 | 694999 | 2020-11-03 | Johnson | Nebraska | 31097 | 121 | 0 |
691757 | 691757 | 2020-11-02 | Johnson | Nebraska | 31097 | 119 | 0 |
688512 | 688512 | 2020-11-01 | Johnson | Nebraska | 31097 | 116 | 0 |
685268 | 685268 | 2020-10-31 | Johnson | Nebraska | 31097 | 114 | 0 |
682025 | 682025 | 2020-10-30 | Johnson | Nebraska | 31097 | 113 | 0 |
678781 | 678781 | 2020-10-29 | Johnson | Nebraska | 31097 | 112 | 0 |
675539 | 675539 | 2020-10-28 | Johnson | Nebraska | 31097 | 105 | 0 |
672296 | 672296 | 2020-10-27 | Johnson | Nebraska | 31097 | 102 | 0 |
669054 | 669054 | 2020-10-26 | Johnson | Nebraska | 31097 | 101 | 0 |
665810 | 665810 | 2020-10-25 | Johnson | Nebraska | 31097 | 101 | 0 |
662565 | 662565 | 2020-10-24 | Johnson | Nebraska | 31097 | 100 | 0 |
659321 | 659321 | 2020-10-23 | Johnson | Nebraska | 31097 | 98 | 0 |
656076 | 656076 | 2020-10-22 | Johnson | Nebraska | 31097 | 97 | 0 |
652831 | 652831 | 2020-10-21 | Johnson | Nebraska | 31097 | 97 | 0 |
649586 | 649586 | 2020-10-20 | Johnson | Nebraska | 31097 | 94 | 0 |
646342 | 646342 | 2020-10-19 | Johnson | Nebraska | 31097 | 94 | 0 |
643096 | 643096 | 2020-10-18 | Johnson | Nebraska | 31097 | 93 | 0 |
639848 | 639848 | 2020-10-17 | Johnson | Nebraska | 31097 | 93 | 0 |
636602 | 636602 | 2020-10-16 | Johnson | Nebraska | 31097 | 89 | 0 |
633356 | 633356 | 2020-10-15 | Johnson | Nebraska | 31097 | 88 | 0 |
630111 | 630111 | 2020-10-14 | Johnson | Nebraska | 31097 | 85 | 0 |
626867 | 626867 | 2020-10-13 | Johnson | Nebraska | 31097 | 84 | 0 |
623625 | 623625 | 2020-10-12 | Johnson | Nebraska | 31097 | 84 | 0 |
620382 | 620382 | 2020-10-11 | Johnson | Nebraska | 31097 | 82 | 0 |
617140 | 617140 | 2020-10-10 | Johnson | Nebraska | 31097 | 81 | 0 |
613899 | 613899 | 2020-10-09 | Johnson | Nebraska | 31097 | 74 | 0 |
610657 | 610657 | 2020-10-08 | Johnson | Nebraska | 31097 | 74 | 0 |
607415 | 607415 | 2020-10-07 | Johnson | Nebraska | 31097 | 73 | 0 |
604172 | 604172 | 2020-10-06 | Johnson | Nebraska | 31097 | 72 | 0 |
600930 | 600930 | 2020-10-05 | Johnson | Nebraska | 31097 | 72 | 0 |
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);