ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jackson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056247 | 1056247 | 2021-02-22 | Jackson | Texas | 48239 | 1572 | 28 |
1053001 | 1053001 | 2021-02-21 | Jackson | Texas | 48239 | 1572 | 28 |
1049754 | 1049754 | 2021-02-20 | Jackson | Texas | 48239 | 1572 | 28 |
1046507 | 1046507 | 2021-02-19 | Jackson | Texas | 48239 | 1572 | 28 |
1043262 | 1043262 | 2021-02-18 | Jackson | Texas | 48239 | 1571 | 28 |
1040017 | 1040017 | 2021-02-17 | Jackson | Texas | 48239 | 1571 | 28 |
1036772 | 1036772 | 2021-02-16 | Jackson | Texas | 48239 | 1571 | 28 |
1033527 | 1033527 | 2021-02-15 | Jackson | Texas | 48239 | 1571 | 28 |
1030281 | 1030281 | 2021-02-14 | Jackson | Texas | 48239 | 1571 | 28 |
1027034 | 1027034 | 2021-02-13 | Jackson | Texas | 48239 | 1571 | 28 |
1023789 | 1023789 | 2021-02-12 | Jackson | Texas | 48239 | 1568 | 28 |
1020544 | 1020544 | 2021-02-11 | Jackson | Texas | 48239 | 1569 | 28 |
1017299 | 1017299 | 2021-02-10 | Jackson | Texas | 48239 | 1564 | 27 |
1014054 | 1014054 | 2021-02-09 | Jackson | Texas | 48239 | 1555 | 26 |
1010809 | 1010809 | 2021-02-08 | Jackson | Texas | 48239 | 1551 | 26 |
1007563 | 1007563 | 2021-02-07 | Jackson | Texas | 48239 | 1551 | 26 |
1004317 | 1004317 | 2021-02-06 | Jackson | Texas | 48239 | 1551 | 26 |
1001071 | 1001071 | 2021-02-05 | Jackson | Texas | 48239 | 1542 | 26 |
997825 | 997825 | 2021-02-04 | Jackson | Texas | 48239 | 1537 | 26 |
994579 | 994579 | 2021-02-03 | Jackson | Texas | 48239 | 1530 | 26 |
991333 | 991333 | 2021-02-02 | Jackson | Texas | 48239 | 1510 | 26 |
988087 | 988087 | 2021-02-01 | Jackson | Texas | 48239 | 1505 | 25 |
984840 | 984840 | 2021-01-31 | Jackson | Texas | 48239 | 1505 | 25 |
981593 | 981593 | 2021-01-30 | Jackson | Texas | 48239 | 1505 | 24 |
978347 | 978347 | 2021-01-29 | Jackson | Texas | 48239 | 1472 | 24 |
975102 | 975102 | 2021-01-28 | Jackson | Texas | 48239 | 1445 | 23 |
971857 | 971857 | 2021-01-27 | Jackson | Texas | 48239 | 1423 | 23 |
968612 | 968612 | 2021-01-26 | Jackson | Texas | 48239 | 1395 | 23 |
965368 | 965368 | 2021-01-25 | Jackson | Texas | 48239 | 1395 | 23 |
962123 | 962123 | 2021-01-24 | Jackson | Texas | 48239 | 1395 | 23 |
958878 | 958878 | 2021-01-23 | Jackson | Texas | 48239 | 1395 | 23 |
955632 | 955632 | 2021-01-22 | Jackson | Texas | 48239 | 1380 | 23 |
952387 | 952387 | 2021-01-21 | Jackson | Texas | 48239 | 1342 | 23 |
949142 | 949142 | 2021-01-20 | Jackson | Texas | 48239 | 1297 | 23 |
945896 | 945896 | 2021-01-19 | Jackson | Texas | 48239 | 1284 | 23 |
942649 | 942649 | 2021-01-18 | Jackson | Texas | 48239 | 1284 | 23 |
939404 | 939404 | 2021-01-17 | Jackson | Texas | 48239 | 1284 | 23 |
936159 | 936159 | 2021-01-16 | Jackson | Texas | 48239 | 1284 | 23 |
932914 | 932914 | 2021-01-15 | Jackson | Texas | 48239 | 1262 | 23 |
929669 | 929669 | 2021-01-14 | Jackson | Texas | 48239 | 1252 | 23 |
926424 | 926424 | 2021-01-13 | Jackson | Texas | 48239 | 1252 | 22 |
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 |
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);