ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Terry" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923281 | 923281 | 2021-01-12 | Terry | Texas | 48445 | 1467 | 44 |
920036 | 920036 | 2021-01-11 | Terry | Texas | 48445 | 1457 | 44 |
916791 | 916791 | 2021-01-10 | Terry | Texas | 48445 | 1457 | 44 |
913546 | 913546 | 2021-01-09 | Terry | Texas | 48445 | 1457 | 43 |
910301 | 910301 | 2021-01-08 | Terry | Texas | 48445 | 1450 | 43 |
907056 | 907056 | 2021-01-07 | Terry | Texas | 48445 | 1450 | 42 |
903810 | 903810 | 2021-01-06 | Terry | Texas | 48445 | 1351 | 40 |
900565 | 900565 | 2021-01-05 | Terry | Texas | 48445 | 1351 | 40 |
897320 | 897320 | 2021-01-04 | Terry | Texas | 48445 | 1351 | 40 |
894074 | 894074 | 2021-01-03 | Terry | Texas | 48445 | 1351 | 40 |
890828 | 890828 | 2021-01-02 | Terry | Texas | 48445 | 1351 | 40 |
887581 | 887581 | 2021-01-01 | Terry | Texas | 48445 | 1351 | 40 |
884336 | 884336 | 2020-12-31 | Terry | Texas | 48445 | 1351 | 39 |
881091 | 881091 | 2020-12-30 | Terry | Texas | 48445 | 1351 | 39 |
877846 | 877846 | 2020-12-29 | Terry | Texas | 48445 | 1311 | 39 |
874601 | 874601 | 2020-12-28 | Terry | Texas | 48445 | 1311 | 39 |
871356 | 871356 | 2020-12-27 | Terry | Texas | 48445 | 1311 | 39 |
868111 | 868111 | 2020-12-26 | Terry | Texas | 48445 | 1311 | 39 |
864866 | 864866 | 2020-12-25 | Terry | Texas | 48445 | 1311 | 39 |
861621 | 861621 | 2020-12-24 | Terry | Texas | 48445 | 1311 | 39 |
858376 | 858376 | 2020-12-23 | Terry | Texas | 48445 | 1311 | 39 |
855131 | 855131 | 2020-12-22 | Terry | Texas | 48445 | 1274 | 35 |
851886 | 851886 | 2020-12-21 | Terry | Texas | 48445 | 1270 | 35 |
848641 | 848641 | 2020-12-20 | Terry | Texas | 48445 | 1270 | 35 |
845396 | 845396 | 2020-12-19 | Terry | Texas | 48445 | 1270 | 35 |
842150 | 842150 | 2020-12-18 | Terry | Texas | 48445 | 1199 | 35 |
838905 | 838905 | 2020-12-17 | Terry | Texas | 48445 | 1199 | 35 |
835659 | 835659 | 2020-12-16 | Terry | Texas | 48445 | 1199 | 35 |
832413 | 832413 | 2020-12-15 | Terry | Texas | 48445 | 1185 | 35 |
829166 | 829166 | 2020-12-14 | Terry | Texas | 48445 | 1140 | 34 |
825920 | 825920 | 2020-12-13 | Terry | Texas | 48445 | 1140 | 34 |
822673 | 822673 | 2020-12-12 | Terry | Texas | 48445 | 1140 | 33 |
819427 | 819427 | 2020-12-11 | Terry | Texas | 48445 | 1140 | 32 |
816181 | 816181 | 2020-12-10 | Terry | Texas | 48445 | 1140 | 30 |
812935 | 812935 | 2020-12-09 | Terry | Texas | 48445 | 1094 | 30 |
809691 | 809691 | 2020-12-08 | Terry | Texas | 48445 | 1054 | 30 |
806446 | 806446 | 2020-12-07 | Terry | Texas | 48445 | 1039 | 29 |
803201 | 803201 | 2020-12-06 | Terry | Texas | 48445 | 1039 | 29 |
799956 | 799956 | 2020-12-05 | Terry | Texas | 48445 | 1039 | 29 |
796711 | 796711 | 2020-12-04 | Terry | Texas | 48445 | 992 | 28 |
793466 | 793466 | 2020-12-03 | Terry | Texas | 48445 | 970 | 27 |
790221 | 790221 | 2020-12-02 | Terry | Texas | 48445 | 970 | 27 |
786976 | 786976 | 2020-12-01 | Terry | Texas | 48445 | 956 | 27 |
783732 | 783732 | 2020-11-30 | Terry | Texas | 48445 | 910 | 25 |
780487 | 780487 | 2020-11-29 | Terry | Texas | 48445 | 910 | 25 |
777241 | 777241 | 2020-11-28 | Terry | Texas | 48445 | 910 | 25 |
773996 | 773996 | 2020-11-27 | Terry | Texas | 48445 | 910 | 24 |
770751 | 770751 | 2020-11-26 | Terry | Texas | 48445 | 910 | 24 |
767505 | 767505 | 2020-11-25 | Terry | Texas | 48445 | 910 | 24 |
764260 | 764260 | 2020-11-24 | Terry | Texas | 48445 | 895 | 23 |
761015 | 761015 | 2020-11-23 | Terry | Texas | 48445 | 890 | 20 |
757770 | 757770 | 2020-11-22 | Terry | Texas | 48445 | 890 | 20 |
754523 | 754523 | 2020-11-21 | Terry | Texas | 48445 | 890 | 19 |
751277 | 751277 | 2020-11-20 | Terry | Texas | 48445 | 882 | 18 |
748031 | 748031 | 2020-11-19 | Terry | Texas | 48445 | 851 | 18 |
744785 | 744785 | 2020-11-18 | Terry | Texas | 48445 | 838 | 15 |
741538 | 741538 | 2020-11-17 | Terry | Texas | 48445 | 811 | 12 |
738291 | 738291 | 2020-11-16 | Terry | Texas | 48445 | 784 | 12 |
735047 | 735047 | 2020-11-15 | Terry | Texas | 48445 | 784 | 12 |
731801 | 731801 | 2020-11-14 | Terry | Texas | 48445 | 752 | 12 |
728556 | 728556 | 2020-11-13 | Terry | Texas | 48445 | 752 | 12 |
725313 | 725313 | 2020-11-12 | Terry | Texas | 48445 | 743 | 12 |
722070 | 722070 | 2020-11-11 | Terry | Texas | 48445 | 738 | 11 |
718827 | 718827 | 2020-11-10 | Terry | Texas | 48445 | 706 | 11 |
715584 | 715584 | 2020-11-09 | Terry | Texas | 48445 | 698 | 11 |
712340 | 712340 | 2020-11-08 | Terry | Texas | 48445 | 698 | 11 |
709096 | 709096 | 2020-11-07 | Terry | Texas | 48445 | 698 | 11 |
705852 | 705852 | 2020-11-06 | Terry | Texas | 48445 | 693 | 11 |
702609 | 702609 | 2020-11-05 | Terry | Texas | 48445 | 674 | 10 |
699366 | 699366 | 2020-11-04 | Terry | Texas | 48445 | 652 | 10 |
696122 | 696122 | 2020-11-03 | Terry | Texas | 48445 | 641 | 10 |
692880 | 692880 | 2020-11-02 | Terry | Texas | 48445 | 626 | 10 |
689636 | 689636 | 2020-11-01 | Terry | Texas | 48445 | 626 | 10 |
686391 | 686391 | 2020-10-31 | Terry | Texas | 48445 | 626 | 10 |
683148 | 683148 | 2020-10-30 | Terry | Texas | 48445 | 589 | 10 |
679905 | 679905 | 2020-10-29 | Terry | Texas | 48445 | 573 | 9 |
676662 | 676662 | 2020-10-28 | Terry | Texas | 48445 | 535 | 9 |
673419 | 673419 | 2020-10-27 | Terry | Texas | 48445 | 505 | 8 |
670177 | 670177 | 2020-10-26 | Terry | Texas | 48445 | 505 | 8 |
666934 | 666934 | 2020-10-25 | Terry | Texas | 48445 | 505 | 8 |
663689 | 663689 | 2020-10-24 | Terry | Texas | 48445 | 493 | 8 |
660445 | 660445 | 2020-10-23 | Terry | Texas | 48445 | 493 | 7 |
657201 | 657201 | 2020-10-22 | Terry | Texas | 48445 | 487 | 7 |
653956 | 653956 | 2020-10-21 | Terry | Texas | 48445 | 487 | 7 |
650711 | 650711 | 2020-10-20 | Terry | Texas | 48445 | 458 | 6 |
647467 | 647467 | 2020-10-19 | Terry | Texas | 48445 | 440 | 6 |
644221 | 644221 | 2020-10-18 | Terry | Texas | 48445 | 440 | 6 |
640973 | 640973 | 2020-10-17 | Terry | Texas | 48445 | 430 | 6 |
637726 | 637726 | 2020-10-16 | Terry | Texas | 48445 | 398 | 6 |
634481 | 634481 | 2020-10-15 | Terry | Texas | 48445 | 398 | 6 |
631236 | 631236 | 2020-10-14 | Terry | Texas | 48445 | 384 | 6 |
627992 | 627992 | 2020-10-13 | Terry | Texas | 48445 | 361 | 6 |
624749 | 624749 | 2020-10-12 | Terry | Texas | 48445 | 347 | 6 |
621506 | 621506 | 2020-10-11 | Terry | Texas | 48445 | 347 | 6 |
618263 | 618263 | 2020-10-10 | Terry | Texas | 48445 | 347 | 6 |
615021 | 615021 | 2020-10-09 | Terry | Texas | 48445 | 337 | 6 |
611780 | 611780 | 2020-10-08 | Terry | Texas | 48445 | 323 | 4 |
608538 | 608538 | 2020-10-07 | Terry | Texas | 48445 | 320 | 4 |
605295 | 605295 | 2020-10-06 | Terry | Texas | 48445 | 298 | 4 |
602053 | 602053 | 2020-10-05 | Terry | Texas | 48445 | 286 | 4 |
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);