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 |
---|---|---|---|---|---|---|---|
1419951 | 1419951 | 2021-06-14 | Rusk | Texas | 48401 | 4059 | 108 |
1416706 | 1416706 | 2021-06-13 | Rusk | Texas | 48401 | 4055 | 108 |
1413460 | 1413460 | 2021-06-12 | Rusk | Texas | 48401 | 4055 | 108 |
1410215 | 1410215 | 2021-06-11 | Rusk | Texas | 48401 | 4050 | 108 |
1406970 | 1406970 | 2021-06-10 | Rusk | Texas | 48401 | 4050 | 108 |
1403724 | 1403724 | 2021-06-09 | Rusk | Texas | 48401 | 4047 | 108 |
1400479 | 1400479 | 2021-06-08 | Rusk | Texas | 48401 | 4044 | 108 |
1397234 | 1397234 | 2021-06-07 | Rusk | Texas | 48401 | 4038 | 108 |
1393987 | 1393987 | 2021-06-06 | Rusk | Texas | 48401 | 4036 | 108 |
1390742 | 1390742 | 2021-06-05 | Rusk | Texas | 48401 | 4037 | 108 |
1387497 | 1387497 | 2021-06-04 | Rusk | Texas | 48401 | 4035 | 108 |
1384252 | 1384252 | 2021-06-03 | Rusk | Texas | 48401 | 4034 | 108 |
1381006 | 1381006 | 2021-06-02 | Rusk | Texas | 48401 | 4033 | 108 |
1377761 | 1377761 | 2021-06-01 | Rusk | Texas | 48401 | 4029 | 108 |
1374515 | 1374515 | 2021-05-31 | Rusk | Texas | 48401 | 4028 | 108 |
1371270 | 1371270 | 2021-05-30 | Rusk | Texas | 48401 | 4028 | 108 |
1368024 | 1368024 | 2021-05-29 | Rusk | Texas | 48401 | 4028 | 108 |
1364778 | 1364778 | 2021-05-28 | Rusk | Texas | 48401 | 4021 | 108 |
1361532 | 1361532 | 2021-05-27 | Rusk | Texas | 48401 | 4015 | 108 |
1358286 | 1358286 | 2021-05-26 | Rusk | Texas | 48401 | 4011 | 108 |
1355040 | 1355040 | 2021-05-25 | Rusk | Texas | 48401 | 4008 | 108 |
1351794 | 1351794 | 2021-05-24 | Rusk | Texas | 48401 | 4002 | 108 |
1348548 | 1348548 | 2021-05-23 | Rusk | Texas | 48401 | 3998 | 108 |
1345300 | 1345300 | 2021-05-22 | Rusk | Texas | 48401 | 3996 | 108 |
1342052 | 1342052 | 2021-05-21 | Rusk | Texas | 48401 | 3992 | 108 |
1338804 | 1338804 | 2021-05-20 | Rusk | Texas | 48401 | 3992 | 108 |
1335557 | 1335557 | 2021-05-19 | Rusk | Texas | 48401 | 3987 | 108 |
1332310 | 1332310 | 2021-05-18 | Rusk | Texas | 48401 | 3984 | 107 |
1329063 | 1329063 | 2021-05-17 | Rusk | Texas | 48401 | 4117 | 107 |
1325817 | 1325817 | 2021-05-16 | Rusk | Texas | 48401 | 4115 | 107 |
1322571 | 1322571 | 2021-05-15 | Rusk | Texas | 48401 | 4115 | 107 |
1319325 | 1319325 | 2021-05-14 | Rusk | Texas | 48401 | 4110 | 107 |
1316077 | 1316077 | 2021-05-13 | Rusk | Texas | 48401 | 4108 | 107 |
1312831 | 1312831 | 2021-05-12 | Rusk | Texas | 48401 | 4109 | 107 |
1309584 | 1309584 | 2021-05-11 | Rusk | Texas | 48401 | 3968 | 107 |
1306338 | 1306338 | 2021-05-10 | Rusk | Texas | 48401 | 3959 | 107 |
1303092 | 1303092 | 2021-05-09 | Rusk | Texas | 48401 | 3957 | 107 |
1299845 | 1299845 | 2021-05-08 | Rusk | Texas | 48401 | 3957 | 107 |
1296598 | 1296598 | 2021-05-07 | Rusk | Texas | 48401 | 3955 | 107 |
1293352 | 1293352 | 2021-05-06 | Rusk | Texas | 48401 | 3951 | 107 |
1290106 | 1290106 | 2021-05-05 | Rusk | Texas | 48401 | 3946 | 107 |
1286860 | 1286860 | 2021-05-04 | Rusk | Texas | 48401 | 3946 | 107 |
1283614 | 1283614 | 2021-05-03 | Rusk | Texas | 48401 | 3947 | 107 |
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 |
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);