ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 48239 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923178 | 923178 | 2021-01-12 | Jackson | Texas | 48239 | 1220 | 22 |
919933 | 919933 | 2021-01-11 | Jackson | Texas | 48239 | 1220 | 21 |
916688 | 916688 | 2021-01-10 | Jackson | Texas | 48239 | 1220 | 21 |
913443 | 913443 | 2021-01-09 | Jackson | Texas | 48239 | 1220 | 21 |
910198 | 910198 | 2021-01-08 | Jackson | Texas | 48239 | 1198 | 20 |
906953 | 906953 | 2021-01-07 | Jackson | Texas | 48239 | 1181 | 20 |
903707 | 903707 | 2021-01-06 | Jackson | Texas | 48239 | 1148 | 20 |
900462 | 900462 | 2021-01-05 | Jackson | Texas | 48239 | 1142 | 20 |
897217 | 897217 | 2021-01-04 | Jackson | Texas | 48239 | 1106 | 20 |
893971 | 893971 | 2021-01-03 | Jackson | Texas | 48239 | 1106 | 20 |
890725 | 890725 | 2021-01-02 | Jackson | Texas | 48239 | 1106 | 20 |
887478 | 887478 | 2021-01-01 | Jackson | Texas | 48239 | 1106 | 20 |
884233 | 884233 | 2020-12-31 | Jackson | Texas | 48239 | 1085 | 20 |
880988 | 880988 | 2020-12-30 | Jackson | Texas | 48239 | 1074 | 20 |
877743 | 877743 | 2020-12-29 | Jackson | Texas | 48239 | 1057 | 19 |
874498 | 874498 | 2020-12-28 | Jackson | Texas | 48239 | 1057 | 19 |
871253 | 871253 | 2020-12-27 | Jackson | Texas | 48239 | 1057 | 19 |
868008 | 868008 | 2020-12-26 | Jackson | Texas | 48239 | 1057 | 19 |
864763 | 864763 | 2020-12-25 | Jackson | Texas | 48239 | 1057 | 19 |
861518 | 861518 | 2020-12-24 | Jackson | Texas | 48239 | 1036 | 19 |
858273 | 858273 | 2020-12-23 | Jackson | Texas | 48239 | 1036 | 19 |
855028 | 855028 | 2020-12-22 | Jackson | Texas | 48239 | 1007 | 19 |
851783 | 851783 | 2020-12-21 | Jackson | Texas | 48239 | 1007 | 19 |
848538 | 848538 | 2020-12-20 | Jackson | Texas | 48239 | 1007 | 19 |
845293 | 845293 | 2020-12-19 | Jackson | Texas | 48239 | 1007 | 19 |
842047 | 842047 | 2020-12-18 | Jackson | Texas | 48239 | 1006 | 19 |
838802 | 838802 | 2020-12-17 | Jackson | Texas | 48239 | 979 | 18 |
835556 | 835556 | 2020-12-16 | Jackson | Texas | 48239 | 973 | 18 |
832310 | 832310 | 2020-12-15 | Jackson | Texas | 48239 | 943 | 18 |
829063 | 829063 | 2020-12-14 | Jackson | Texas | 48239 | 939 | 17 |
825817 | 825817 | 2020-12-13 | Jackson | Texas | 48239 | 939 | 17 |
822570 | 822570 | 2020-12-12 | Jackson | Texas | 48239 | 939 | 17 |
819324 | 819324 | 2020-12-11 | Jackson | Texas | 48239 | 936 | 17 |
816078 | 816078 | 2020-12-10 | Jackson | Texas | 48239 | 884 | 17 |
812832 | 812832 | 2020-12-09 | Jackson | Texas | 48239 | 884 | 17 |
809588 | 809588 | 2020-12-08 | Jackson | Texas | 48239 | 868 | 17 |
806343 | 806343 | 2020-12-07 | Jackson | Texas | 48239 | 850 | 16 |
803098 | 803098 | 2020-12-06 | Jackson | Texas | 48239 | 850 | 16 |
799853 | 799853 | 2020-12-05 | Jackson | Texas | 48239 | 850 | 16 |
796608 | 796608 | 2020-12-04 | Jackson | Texas | 48239 | 848 | 16 |
793363 | 793363 | 2020-12-03 | Jackson | Texas | 48239 | 837 | 16 |
790118 | 790118 | 2020-12-02 | Jackson | Texas | 48239 | 834 | 16 |
786873 | 786873 | 2020-12-01 | Jackson | Texas | 48239 | 813 | 16 |
783629 | 783629 | 2020-11-30 | Jackson | Texas | 48239 | 811 | 16 |
780384 | 780384 | 2020-11-29 | Jackson | Texas | 48239 | 800 | 16 |
777138 | 777138 | 2020-11-28 | Jackson | Texas | 48239 | 800 | 16 |
773893 | 773893 | 2020-11-27 | Jackson | Texas | 48239 | 800 | 16 |
770648 | 770648 | 2020-11-26 | Jackson | Texas | 48239 | 800 | 16 |
767402 | 767402 | 2020-11-25 | Jackson | Texas | 48239 | 798 | 16 |
764157 | 764157 | 2020-11-24 | Jackson | Texas | 48239 | 784 | 16 |
760912 | 760912 | 2020-11-23 | Jackson | Texas | 48239 | 767 | 16 |
757667 | 757667 | 2020-11-22 | Jackson | Texas | 48239 | 767 | 16 |
754420 | 754420 | 2020-11-21 | Jackson | Texas | 48239 | 767 | 16 |
751174 | 751174 | 2020-11-20 | Jackson | Texas | 48239 | 762 | 16 |
747928 | 747928 | 2020-11-19 | Jackson | Texas | 48239 | 760 | 16 |
744682 | 744682 | 2020-11-18 | Jackson | Texas | 48239 | 757 | 16 |
741435 | 741435 | 2020-11-17 | Jackson | Texas | 48239 | 727 | 16 |
738189 | 738189 | 2020-11-16 | Jackson | Texas | 48239 | 719 | 16 |
734945 | 734945 | 2020-11-15 | Jackson | Texas | 48239 | 719 | 16 |
731699 | 731699 | 2020-11-14 | Jackson | Texas | 48239 | 719 | 16 |
728454 | 728454 | 2020-11-13 | Jackson | Texas | 48239 | 714 | 16 |
725211 | 725211 | 2020-11-12 | Jackson | Texas | 48239 | 693 | 16 |
721968 | 721968 | 2020-11-11 | Jackson | Texas | 48239 | 693 | 16 |
718725 | 718725 | 2020-11-10 | Jackson | Texas | 48239 | 692 | 16 |
715482 | 715482 | 2020-11-09 | Jackson | Texas | 48239 | 681 | 16 |
712238 | 712238 | 2020-11-08 | Jackson | Texas | 48239 | 675 | 16 |
708994 | 708994 | 2020-11-07 | Jackson | Texas | 48239 | 675 | 16 |
705750 | 705750 | 2020-11-06 | Jackson | Texas | 48239 | 676 | 16 |
702507 | 702507 | 2020-11-05 | Jackson | Texas | 48239 | 670 | 16 |
699264 | 699264 | 2020-11-04 | Jackson | Texas | 48239 | 669 | 16 |
696020 | 696020 | 2020-11-03 | Jackson | Texas | 48239 | 666 | 16 |
692778 | 692778 | 2020-11-02 | Jackson | Texas | 48239 | 663 | 16 |
689534 | 689534 | 2020-11-01 | Jackson | Texas | 48239 | 656 | 16 |
686289 | 686289 | 2020-10-31 | Jackson | Texas | 48239 | 656 | 16 |
683046 | 683046 | 2020-10-30 | Jackson | Texas | 48239 | 656 | 16 |
679803 | 679803 | 2020-10-29 | Jackson | Texas | 48239 | 654 | 16 |
676560 | 676560 | 2020-10-28 | Jackson | Texas | 48239 | 652 | 16 |
673317 | 673317 | 2020-10-27 | Jackson | Texas | 48239 | 650 | 16 |
670075 | 670075 | 2020-10-26 | Jackson | Texas | 48239 | 647 | 16 |
666832 | 666832 | 2020-10-25 | Jackson | Texas | 48239 | 646 | 16 |
663587 | 663587 | 2020-10-24 | Jackson | Texas | 48239 | 646 | 16 |
660343 | 660343 | 2020-10-23 | Jackson | Texas | 48239 | 640 | 16 |
657099 | 657099 | 2020-10-22 | Jackson | Texas | 48239 | 639 | 16 |
653854 | 653854 | 2020-10-21 | Jackson | Texas | 48239 | 639 | 16 |
650609 | 650609 | 2020-10-20 | Jackson | Texas | 48239 | 637 | 16 |
647365 | 647365 | 2020-10-19 | Jackson | Texas | 48239 | 636 | 16 |
644119 | 644119 | 2020-10-18 | Jackson | Texas | 48239 | 636 | 16 |
640871 | 640871 | 2020-10-17 | Jackson | Texas | 48239 | 636 | 16 |
637624 | 637624 | 2020-10-16 | Jackson | Texas | 48239 | 635 | 16 |
634379 | 634379 | 2020-10-15 | Jackson | Texas | 48239 | 635 | 16 |
631134 | 631134 | 2020-10-14 | Jackson | Texas | 48239 | 633 | 16 |
627890 | 627890 | 2020-10-13 | Jackson | Texas | 48239 | 633 | 16 |
624648 | 624648 | 2020-10-12 | Jackson | Texas | 48239 | 632 | 16 |
621405 | 621405 | 2020-10-11 | Jackson | Texas | 48239 | 626 | 16 |
618162 | 618162 | 2020-10-10 | Jackson | Texas | 48239 | 626 | 16 |
614920 | 614920 | 2020-10-09 | Jackson | Texas | 48239 | 627 | 16 |
611679 | 611679 | 2020-10-08 | Jackson | Texas | 48239 | 627 | 16 |
608437 | 608437 | 2020-10-07 | Jackson | Texas | 48239 | 626 | 16 |
605194 | 605194 | 2020-10-06 | Jackson | Texas | 48239 | 630 | 16 |
601952 | 601952 | 2020-10-05 | Jackson | Texas | 48239 | 633 | 16 |
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);