ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48401 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280367 | 1280367 | 2021-05-02 | Rusk | Texas | 48401 | 3946 | 107 |
1277120 | 1277120 | 2021-05-01 | Rusk | Texas | 48401 | 3946 | 107 |
1273873 | 1273873 | 2021-04-30 | Rusk | Texas | 48401 | 3937 | 107 |
1270626 | 1270626 | 2021-04-29 | Rusk | Texas | 48401 | 3930 | 107 |
1267379 | 1267379 | 2021-04-28 | Rusk | Texas | 48401 | 3927 | 107 |
1264132 | 1264132 | 2021-04-27 | Rusk | Texas | 48401 | 3923 | 107 |
1260885 | 1260885 | 2021-04-26 | Rusk | Texas | 48401 | 3920 | 107 |
1257638 | 1257638 | 2021-04-25 | Rusk | Texas | 48401 | 3917 | 107 |
1254391 | 1254391 | 2021-04-24 | Rusk | Texas | 48401 | 3917 | 106 |
1251144 | 1251144 | 2021-04-23 | Rusk | Texas | 48401 | 3915 | 106 |
1247897 | 1247897 | 2021-04-22 | Rusk | Texas | 48401 | 3914 | 106 |
1244650 | 1244650 | 2021-04-21 | Rusk | Texas | 48401 | 3910 | 106 |
1241403 | 1241403 | 2021-04-20 | Rusk | Texas | 48401 | 3905 | 106 |
1238156 | 1238156 | 2021-04-19 | Rusk | Texas | 48401 | 3898 | 106 |
1234909 | 1234909 | 2021-04-18 | Rusk | Texas | 48401 | 3898 | 106 |
1231661 | 1231661 | 2021-04-17 | Rusk | Texas | 48401 | 3897 | 106 |
1228413 | 1228413 | 2021-04-16 | Rusk | Texas | 48401 | 3894 | 105 |
1225165 | 1225165 | 2021-04-15 | Rusk | Texas | 48401 | 3894 | 105 |
1221918 | 1221918 | 2021-04-14 | Rusk | Texas | 48401 | 3892 | 105 |
1218670 | 1218670 | 2021-04-13 | Rusk | Texas | 48401 | 3892 | 105 |
1215422 | 1215422 | 2021-04-12 | Rusk | Texas | 48401 | 3891 | 105 |
1212175 | 1212175 | 2021-04-11 | Rusk | Texas | 48401 | 3891 | 105 |
1208926 | 1208926 | 2021-04-10 | Rusk | Texas | 48401 | 3888 | 105 |
1205678 | 1205678 | 2021-04-09 | Rusk | Texas | 48401 | 3885 | 105 |
1202430 | 1202430 | 2021-04-08 | Rusk | Texas | 48401 | 3879 | 105 |
1199181 | 1199181 | 2021-04-07 | Rusk | Texas | 48401 | 3880 | 105 |
1195932 | 1195932 | 2021-04-06 | Rusk | Texas | 48401 | 3877 | 105 |
1192684 | 1192684 | 2021-04-05 | Rusk | Texas | 48401 | 3875 | 105 |
1189435 | 1189435 | 2021-04-04 | Rusk | Texas | 48401 | 3878 | 105 |
1186188 | 1186188 | 2021-04-03 | Rusk | Texas | 48401 | 3874 | 105 |
1182941 | 1182941 | 2021-04-02 | Rusk | Texas | 48401 | 3874 | 105 |
1179694 | 1179694 | 2021-04-01 | Rusk | Texas | 48401 | 3868 | 105 |
1176447 | 1176447 | 2021-03-31 | Rusk | Texas | 48401 | 3859 | 105 |
1173200 | 1173200 | 2021-03-30 | Rusk | Texas | 48401 | 3857 | 105 |
1169953 | 1169953 | 2021-03-29 | Rusk | Texas | 48401 | 3849 | 105 |
1166705 | 1166705 | 2021-03-28 | Rusk | Texas | 48401 | 3848 | 104 |
1163457 | 1163457 | 2021-03-27 | Rusk | Texas | 48401 | 3848 | 104 |
1160208 | 1160208 | 2021-03-26 | Rusk | Texas | 48401 | 3842 | 104 |
1156961 | 1156961 | 2021-03-25 | Rusk | Texas | 48401 | 3843 | 104 |
1153714 | 1153714 | 2021-03-24 | Rusk | Texas | 48401 | 3842 | 104 |
1150467 | 1150467 | 2021-03-23 | Rusk | Texas | 48401 | 3845 | 104 |
1147220 | 1147220 | 2021-03-22 | Rusk | Texas | 48401 | 3835 | 104 |
1143973 | 1143973 | 2021-03-21 | Rusk | Texas | 48401 | 3834 | 104 |
1140726 | 1140726 | 2021-03-20 | Rusk | Texas | 48401 | 3834 | 103 |
1137480 | 1137480 | 2021-03-19 | Rusk | Texas | 48401 | 3831 | 102 |
1134234 | 1134234 | 2021-03-18 | Rusk | Texas | 48401 | 3828 | 102 |
1130986 | 1130986 | 2021-03-17 | Rusk | Texas | 48401 | 3826 | 101 |
1127739 | 1127739 | 2021-03-16 | Rusk | Texas | 48401 | 3824 | 101 |
1124493 | 1124493 | 2021-03-15 | Rusk | Texas | 48401 | 3815 | 101 |
1121247 | 1121247 | 2021-03-14 | Rusk | Texas | 48401 | 3812 | 101 |
1118000 | 1118000 | 2021-03-13 | Rusk | Texas | 48401 | 3807 | 101 |
1114753 | 1114753 | 2021-03-12 | Rusk | Texas | 48401 | 3799 | 100 |
1111507 | 1111507 | 2021-03-11 | Rusk | Texas | 48401 | 3793 | 100 |
1108261 | 1108261 | 2021-03-10 | Rusk | Texas | 48401 | 3787 | 100 |
1105015 | 1105015 | 2021-03-09 | Rusk | Texas | 48401 | 3785 | 100 |
1101769 | 1101769 | 2021-03-08 | Rusk | Texas | 48401 | 3782 | 100 |
1098523 | 1098523 | 2021-03-07 | Rusk | Texas | 48401 | 3778 | 100 |
1095275 | 1095275 | 2021-03-06 | Rusk | Texas | 48401 | 3778 | 99 |
1092029 | 1092029 | 2021-03-05 | Rusk | Texas | 48401 | 3771 | 99 |
1088783 | 1088783 | 2021-03-04 | Rusk | Texas | 48401 | 3760 | 97 |
1085538 | 1085538 | 2021-03-03 | Rusk | Texas | 48401 | 3762 | 96 |
1082292 | 1082292 | 2021-03-02 | Rusk | Texas | 48401 | 3750 | 95 |
1079046 | 1079046 | 2021-03-01 | Rusk | Texas | 48401 | 3741 | 95 |
1075801 | 1075801 | 2021-02-28 | Rusk | Texas | 48401 | 3741 | 95 |
1072555 | 1072555 | 2021-02-27 | Rusk | Texas | 48401 | 3728 | 94 |
1069309 | 1069309 | 2021-02-26 | Rusk | Texas | 48401 | 3725 | 94 |
1066064 | 1066064 | 2021-02-25 | Rusk | Texas | 48401 | 3710 | 91 |
1062819 | 1062819 | 2021-02-24 | Rusk | Texas | 48401 | 3700 | 91 |
1059574 | 1059574 | 2021-02-23 | Rusk | Texas | 48401 | 3687 | 90 |
1056328 | 1056328 | 2021-02-22 | Rusk | Texas | 48401 | 3681 | 90 |
1053082 | 1053082 | 2021-02-21 | Rusk | Texas | 48401 | 3677 | 90 |
1049835 | 1049835 | 2021-02-20 | Rusk | Texas | 48401 | 3672 | 90 |
1046588 | 1046588 | 2021-02-19 | Rusk | Texas | 48401 | 3658 | 89 |
1043343 | 1043343 | 2021-02-18 | Rusk | Texas | 48401 | 3642 | 89 |
1040098 | 1040098 | 2021-02-17 | Rusk | Texas | 48401 | 3636 | 89 |
1036853 | 1036853 | 2021-02-16 | Rusk | Texas | 48401 | 3632 | 89 |
1033608 | 1033608 | 2021-02-15 | Rusk | Texas | 48401 | 3628 | 89 |
1030362 | 1030362 | 2021-02-14 | Rusk | Texas | 48401 | 3612 | 89 |
1027115 | 1027115 | 2021-02-13 | Rusk | Texas | 48401 | 3598 | 88 |
1023870 | 1023870 | 2021-02-12 | Rusk | Texas | 48401 | 3583 | 87 |
1020625 | 1020625 | 2021-02-11 | Rusk | Texas | 48401 | 3578 | 86 |
1017380 | 1017380 | 2021-02-10 | Rusk | Texas | 48401 | 3565 | 82 |
1014135 | 1014135 | 2021-02-09 | Rusk | Texas | 48401 | 3536 | 82 |
1010890 | 1010890 | 2021-02-08 | Rusk | Texas | 48401 | 3519 | 82 |
1007644 | 1007644 | 2021-02-07 | Rusk | Texas | 48401 | 3512 | 82 |
1004398 | 1004398 | 2021-02-06 | Rusk | Texas | 48401 | 3512 | 82 |
1001152 | 1001152 | 2021-02-05 | Rusk | Texas | 48401 | 3477 | 81 |
997906 | 997906 | 2021-02-04 | Rusk | Texas | 48401 | 3445 | 81 |
994660 | 994660 | 2021-02-03 | Rusk | Texas | 48401 | 3431 | 80 |
991414 | 991414 | 2021-02-02 | Rusk | Texas | 48401 | 3412 | 79 |
988168 | 988168 | 2021-02-01 | Rusk | Texas | 48401 | 3396 | 79 |
984921 | 984921 | 2021-01-31 | Rusk | Texas | 48401 | 3356 | 79 |
981674 | 981674 | 2021-01-30 | Rusk | Texas | 48401 | 3356 | 77 |
978428 | 978428 | 2021-01-29 | Rusk | Texas | 48401 | 3297 | 77 |
975183 | 975183 | 2021-01-28 | Rusk | Texas | 48401 | 3260 | 77 |
971938 | 971938 | 2021-01-27 | Rusk | Texas | 48401 | 3244 | 75 |
968693 | 968693 | 2021-01-26 | Rusk | Texas | 48401 | 3220 | 73 |
965449 | 965449 | 2021-01-25 | Rusk | Texas | 48401 | 3192 | 73 |
962204 | 962204 | 2021-01-24 | Rusk | Texas | 48401 | 3192 | 73 |
958959 | 958959 | 2021-01-23 | Rusk | Texas | 48401 | 3179 | 73 |
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);