ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 48291 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419896 | 1419896 | 2021-06-14 | Liberty | Texas | 48291 | 8052 | 190 |
1416651 | 1416651 | 2021-06-13 | Liberty | Texas | 48291 | 8048 | 190 |
1413405 | 1413405 | 2021-06-12 | Liberty | Texas | 48291 | 8043 | 190 |
1410160 | 1410160 | 2021-06-11 | Liberty | Texas | 48291 | 8046 | 190 |
1406915 | 1406915 | 2021-06-10 | Liberty | Texas | 48291 | 8037 | 190 |
1403669 | 1403669 | 2021-06-09 | Liberty | Texas | 48291 | 8030 | 190 |
1400424 | 1400424 | 2021-06-08 | Liberty | Texas | 48291 | 8029 | 189 |
1397179 | 1397179 | 2021-06-07 | Liberty | Texas | 48291 | 8026 | 189 |
1393932 | 1393932 | 2021-06-06 | Liberty | Texas | 48291 | 8016 | 189 |
1390687 | 1390687 | 2021-06-05 | Liberty | Texas | 48291 | 8012 | 189 |
1387442 | 1387442 | 2021-06-04 | Liberty | Texas | 48291 | 8012 | 189 |
1384197 | 1384197 | 2021-06-03 | Liberty | Texas | 48291 | 7998 | 189 |
1380951 | 1380951 | 2021-06-02 | Liberty | Texas | 48291 | 7994 | 188 |
1377706 | 1377706 | 2021-06-01 | Liberty | Texas | 48291 | 8030 | 188 |
1374460 | 1374460 | 2021-05-31 | Liberty | Texas | 48291 | 8030 | 187 |
1371215 | 1371215 | 2021-05-30 | Liberty | Texas | 48291 | 8030 | 187 |
1367969 | 1367969 | 2021-05-29 | Liberty | Texas | 48291 | 8030 | 187 |
1364723 | 1364723 | 2021-05-28 | Liberty | Texas | 48291 | 8038 | 187 |
1361477 | 1361477 | 2021-05-27 | Liberty | Texas | 48291 | 8016 | 187 |
1358231 | 1358231 | 2021-05-26 | Liberty | Texas | 48291 | 8008 | 187 |
1354985 | 1354985 | 2021-05-25 | Liberty | Texas | 48291 | 7993 | 187 |
1351739 | 1351739 | 2021-05-24 | Liberty | Texas | 48291 | 7988 | 187 |
1348493 | 1348493 | 2021-05-23 | Liberty | Texas | 48291 | 7973 | 187 |
1345245 | 1345245 | 2021-05-22 | Liberty | Texas | 48291 | 7970 | 187 |
1341997 | 1341997 | 2021-05-21 | Liberty | Texas | 48291 | 7972 | 187 |
1338749 | 1338749 | 2021-05-20 | Liberty | Texas | 48291 | 7965 | 186 |
1335502 | 1335502 | 2021-05-19 | Liberty | Texas | 48291 | 7964 | 186 |
1332255 | 1332255 | 2021-05-18 | Liberty | Texas | 48291 | 7953 | 185 |
1329008 | 1329008 | 2021-05-17 | Liberty | Texas | 48291 | 7941 | 185 |
1325762 | 1325762 | 2021-05-16 | Liberty | Texas | 48291 | 7933 | 185 |
1322516 | 1322516 | 2021-05-15 | Liberty | Texas | 48291 | 7925 | 185 |
1319270 | 1319270 | 2021-05-14 | Liberty | Texas | 48291 | 7905 | 185 |
1316022 | 1316022 | 2021-05-13 | Liberty | Texas | 48291 | 7876 | 185 |
1312776 | 1312776 | 2021-05-12 | Liberty | Texas | 48291 | 7862 | 184 |
1309529 | 1309529 | 2021-05-11 | Liberty | Texas | 48291 | 7861 | 184 |
1306283 | 1306283 | 2021-05-10 | Liberty | Texas | 48291 | 7871 | 183 |
1303037 | 1303037 | 2021-05-09 | Liberty | Texas | 48291 | 7865 | 183 |
1299790 | 1299790 | 2021-05-08 | Liberty | Texas | 48291 | 7853 | 183 |
1296543 | 1296543 | 2021-05-07 | Liberty | Texas | 48291 | 7846 | 183 |
1293297 | 1293297 | 2021-05-06 | Liberty | Texas | 48291 | 7826 | 183 |
1290051 | 1290051 | 2021-05-05 | Liberty | Texas | 48291 | 7821 | 183 |
1286805 | 1286805 | 2021-05-04 | Liberty | Texas | 48291 | 7816 | 183 |
1283559 | 1283559 | 2021-05-03 | Liberty | Texas | 48291 | 7779 | 182 |
1280312 | 1280312 | 2021-05-02 | Liberty | Texas | 48291 | 7762 | 182 |
1277065 | 1277065 | 2021-05-01 | Liberty | Texas | 48291 | 7762 | 181 |
1273818 | 1273818 | 2021-04-30 | Liberty | Texas | 48291 | 7750 | 180 |
1270571 | 1270571 | 2021-04-29 | Liberty | Texas | 48291 | 7711 | 180 |
1267324 | 1267324 | 2021-04-28 | Liberty | Texas | 48291 | 7694 | 180 |
1264077 | 1264077 | 2021-04-27 | Liberty | Texas | 48291 | 7685 | 179 |
1260830 | 1260830 | 2021-04-26 | Liberty | Texas | 48291 | 7680 | 179 |
1257583 | 1257583 | 2021-04-25 | Liberty | Texas | 48291 | 7662 | 179 |
1254336 | 1254336 | 2021-04-24 | Liberty | Texas | 48291 | 7630 | 179 |
1251089 | 1251089 | 2021-04-23 | Liberty | Texas | 48291 | 7636 | 178 |
1247842 | 1247842 | 2021-04-22 | Liberty | Texas | 48291 | 7628 | 178 |
1244595 | 1244595 | 2021-04-21 | Liberty | Texas | 48291 | 7600 | 178 |
1241348 | 1241348 | 2021-04-20 | Liberty | Texas | 48291 | 7577 | 178 |
1238101 | 1238101 | 2021-04-19 | Liberty | Texas | 48291 | 7591 | 178 |
1234854 | 1234854 | 2021-04-18 | Liberty | Texas | 48291 | 7579 | 178 |
1231606 | 1231606 | 2021-04-17 | Liberty | Texas | 48291 | 7558 | 178 |
1228358 | 1228358 | 2021-04-16 | Liberty | Texas | 48291 | 7555 | 178 |
1225110 | 1225110 | 2021-04-15 | Liberty | Texas | 48291 | 7552 | 177 |
1221863 | 1221863 | 2021-04-14 | Liberty | Texas | 48291 | 7532 | 175 |
1218615 | 1218615 | 2021-04-13 | Liberty | Texas | 48291 | 7520 | 174 |
1215367 | 1215367 | 2021-04-12 | Liberty | Texas | 48291 | 7508 | 173 |
1212120 | 1212120 | 2021-04-11 | Liberty | Texas | 48291 | 7494 | 173 |
1208871 | 1208871 | 2021-04-10 | Liberty | Texas | 48291 | 7486 | 173 |
1205623 | 1205623 | 2021-04-09 | Liberty | Texas | 48291 | 7483 | 173 |
1202375 | 1202375 | 2021-04-08 | Liberty | Texas | 48291 | 7468 | 172 |
1199126 | 1199126 | 2021-04-07 | Liberty | Texas | 48291 | 7455 | 172 |
1195877 | 1195877 | 2021-04-06 | Liberty | Texas | 48291 | 7443 | 172 |
1192629 | 1192629 | 2021-04-05 | Liberty | Texas | 48291 | 7444 | 172 |
1189380 | 1189380 | 2021-04-04 | Liberty | Texas | 48291 | 7436 | 171 |
1186133 | 1186133 | 2021-04-03 | Liberty | Texas | 48291 | 7430 | 171 |
1182886 | 1182886 | 2021-04-02 | Liberty | Texas | 48291 | 7412 | 171 |
1179639 | 1179639 | 2021-04-01 | Liberty | Texas | 48291 | 7412 | 171 |
1176392 | 1176392 | 2021-03-31 | Liberty | Texas | 48291 | 7412 | 171 |
1173145 | 1173145 | 2021-03-30 | Liberty | Texas | 48291 | 7408 | 170 |
1169898 | 1169898 | 2021-03-29 | Liberty | Texas | 48291 | 7394 | 170 |
1166650 | 1166650 | 2021-03-28 | Liberty | Texas | 48291 | 7385 | 170 |
1163402 | 1163402 | 2021-03-27 | Liberty | Texas | 48291 | 7374 | 170 |
1160153 | 1160153 | 2021-03-26 | Liberty | Texas | 48291 | 7369 | 170 |
1156906 | 1156906 | 2021-03-25 | Liberty | Texas | 48291 | 7350 | 169 |
1153659 | 1153659 | 2021-03-24 | Liberty | Texas | 48291 | 7342 | 169 |
1150412 | 1150412 | 2021-03-23 | Liberty | Texas | 48291 | 7326 | 169 |
1147165 | 1147165 | 2021-03-22 | Liberty | Texas | 48291 | 7323 | 169 |
1143918 | 1143918 | 2021-03-21 | Liberty | Texas | 48291 | 7312 | 169 |
1140671 | 1140671 | 2021-03-20 | Liberty | Texas | 48291 | 7288 | 169 |
1137425 | 1137425 | 2021-03-19 | Liberty | Texas | 48291 | 7283 | 169 |
1134179 | 1134179 | 2021-03-18 | Liberty | Texas | 48291 | 7258 | 169 |
1130931 | 1130931 | 2021-03-17 | Liberty | Texas | 48291 | 7257 | 169 |
1127684 | 1127684 | 2021-03-16 | Liberty | Texas | 48291 | 7241 | 168 |
1124438 | 1124438 | 2021-03-15 | Liberty | Texas | 48291 | 7246 | 166 |
1121192 | 1121192 | 2021-03-14 | Liberty | Texas | 48291 | 7234 | 166 |
1117945 | 1117945 | 2021-03-13 | Liberty | Texas | 48291 | 7226 | 166 |
1114698 | 1114698 | 2021-03-12 | Liberty | Texas | 48291 | 7204 | 165 |
1111452 | 1111452 | 2021-03-11 | Liberty | Texas | 48291 | 7177 | 165 |
1108206 | 1108206 | 2021-03-10 | Liberty | Texas | 48291 | 7170 | 165 |
1104960 | 1104960 | 2021-03-09 | Liberty | Texas | 48291 | 7136 | 165 |
1101714 | 1101714 | 2021-03-08 | Liberty | Texas | 48291 | 7116 | 164 |
1098468 | 1098468 | 2021-03-07 | Liberty | Texas | 48291 | 7114 | 164 |
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);