ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
736 rows where fips = 48267 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419884 | 1419884 | 2021-06-14 | Kimble | Texas | 48267 | 292 | 6 |
1416639 | 1416639 | 2021-06-13 | Kimble | Texas | 48267 | 292 | 6 |
1413393 | 1413393 | 2021-06-12 | Kimble | Texas | 48267 | 292 | 6 |
1410148 | 1410148 | 2021-06-11 | Kimble | Texas | 48267 | 292 | 6 |
1406903 | 1406903 | 2021-06-10 | Kimble | Texas | 48267 | 291 | 6 |
1403657 | 1403657 | 2021-06-09 | Kimble | Texas | 48267 | 286 | 6 |
1400412 | 1400412 | 2021-06-08 | Kimble | Texas | 48267 | 286 | 6 |
1397167 | 1397167 | 2021-06-07 | Kimble | Texas | 48267 | 286 | 6 |
1393920 | 1393920 | 2021-06-06 | Kimble | Texas | 48267 | 286 | 6 |
1390675 | 1390675 | 2021-06-05 | Kimble | Texas | 48267 | 286 | 6 |
1387430 | 1387430 | 2021-06-04 | Kimble | Texas | 48267 | 285 | 6 |
1384185 | 1384185 | 2021-06-03 | Kimble | Texas | 48267 | 285 | 6 |
1380939 | 1380939 | 2021-06-02 | Kimble | Texas | 48267 | 285 | 6 |
1377694 | 1377694 | 2021-06-01 | Kimble | Texas | 48267 | 285 | 6 |
1374448 | 1374448 | 2021-05-31 | Kimble | Texas | 48267 | 282 | 6 |
1371203 | 1371203 | 2021-05-30 | Kimble | Texas | 48267 | 282 | 6 |
1367957 | 1367957 | 2021-05-29 | Kimble | Texas | 48267 | 282 | 6 |
1364711 | 1364711 | 2021-05-28 | Kimble | Texas | 48267 | 282 | 6 |
1361465 | 1361465 | 2021-05-27 | Kimble | Texas | 48267 | 282 | 6 |
1358219 | 1358219 | 2021-05-26 | Kimble | Texas | 48267 | 282 | 6 |
1354973 | 1354973 | 2021-05-25 | Kimble | Texas | 48267 | 282 | 6 |
1351727 | 1351727 | 2021-05-24 | Kimble | Texas | 48267 | 278 | 6 |
1348481 | 1348481 | 2021-05-23 | Kimble | Texas | 48267 | 277 | 6 |
1345233 | 1345233 | 2021-05-22 | Kimble | Texas | 48267 | 268 | 6 |
1341985 | 1341985 | 2021-05-21 | Kimble | Texas | 48267 | 268 | 6 |
1338737 | 1338737 | 2021-05-20 | Kimble | Texas | 48267 | 268 | 6 |
1335490 | 1335490 | 2021-05-19 | Kimble | Texas | 48267 | 268 | 6 |
1332243 | 1332243 | 2021-05-18 | Kimble | Texas | 48267 | 268 | 6 |
1328996 | 1328996 | 2021-05-17 | Kimble | Texas | 48267 | 268 | 6 |
1325750 | 1325750 | 2021-05-16 | Kimble | Texas | 48267 | 267 | 6 |
1322504 | 1322504 | 2021-05-15 | Kimble | Texas | 48267 | 266 | 6 |
1319258 | 1319258 | 2021-05-14 | Kimble | Texas | 48267 | 266 | 6 |
1316010 | 1316010 | 2021-05-13 | Kimble | Texas | 48267 | 266 | 6 |
1312764 | 1312764 | 2021-05-12 | Kimble | Texas | 48267 | 265 | 6 |
1309517 | 1309517 | 2021-05-11 | Kimble | Texas | 48267 | 265 | 6 |
1306271 | 1306271 | 2021-05-10 | Kimble | Texas | 48267 | 265 | 6 |
1303025 | 1303025 | 2021-05-09 | Kimble | Texas | 48267 | 265 | 6 |
1299778 | 1299778 | 2021-05-08 | Kimble | Texas | 48267 | 265 | 6 |
1296531 | 1296531 | 2021-05-07 | Kimble | Texas | 48267 | 265 | 6 |
1293285 | 1293285 | 2021-05-06 | Kimble | Texas | 48267 | 265 | 6 |
1290039 | 1290039 | 2021-05-05 | Kimble | Texas | 48267 | 266 | 6 |
1286793 | 1286793 | 2021-05-04 | Kimble | Texas | 48267 | 268 | 6 |
1283547 | 1283547 | 2021-05-03 | Kimble | Texas | 48267 | 268 | 6 |
1280300 | 1280300 | 2021-05-02 | Kimble | Texas | 48267 | 267 | 6 |
1277053 | 1277053 | 2021-05-01 | Kimble | Texas | 48267 | 267 | 6 |
1273806 | 1273806 | 2021-04-30 | Kimble | Texas | 48267 | 266 | 6 |
1270559 | 1270559 | 2021-04-29 | Kimble | Texas | 48267 | 265 | 6 |
1267312 | 1267312 | 2021-04-28 | Kimble | Texas | 48267 | 263 | 6 |
1264065 | 1264065 | 2021-04-27 | Kimble | Texas | 48267 | 263 | 6 |
1260818 | 1260818 | 2021-04-26 | Kimble | Texas | 48267 | 263 | 6 |
1257571 | 1257571 | 2021-04-25 | Kimble | Texas | 48267 | 262 | 6 |
1254324 | 1254324 | 2021-04-24 | Kimble | Texas | 48267 | 262 | 6 |
1251077 | 1251077 | 2021-04-23 | Kimble | Texas | 48267 | 262 | 6 |
1247830 | 1247830 | 2021-04-22 | Kimble | Texas | 48267 | 262 | 6 |
1244583 | 1244583 | 2021-04-21 | Kimble | Texas | 48267 | 260 | 6 |
1241336 | 1241336 | 2021-04-20 | Kimble | Texas | 48267 | 260 | 6 |
1238089 | 1238089 | 2021-04-19 | Kimble | Texas | 48267 | 260 | 6 |
1234842 | 1234842 | 2021-04-18 | Kimble | Texas | 48267 | 260 | 6 |
1231594 | 1231594 | 2021-04-17 | Kimble | Texas | 48267 | 260 | 6 |
1228346 | 1228346 | 2021-04-16 | Kimble | Texas | 48267 | 260 | 6 |
1225098 | 1225098 | 2021-04-15 | Kimble | Texas | 48267 | 262 | 6 |
1221851 | 1221851 | 2021-04-14 | Kimble | Texas | 48267 | 262 | 6 |
1218603 | 1218603 | 2021-04-13 | Kimble | Texas | 48267 | 262 | 6 |
1215355 | 1215355 | 2021-04-12 | Kimble | Texas | 48267 | 260 | 6 |
1212108 | 1212108 | 2021-04-11 | Kimble | Texas | 48267 | 260 | 6 |
1208859 | 1208859 | 2021-04-10 | Kimble | Texas | 48267 | 260 | 6 |
1205611 | 1205611 | 2021-04-09 | Kimble | Texas | 48267 | 260 | 6 |
1202363 | 1202363 | 2021-04-08 | Kimble | Texas | 48267 | 261 | 6 |
1199114 | 1199114 | 2021-04-07 | Kimble | Texas | 48267 | 261 | 6 |
1195865 | 1195865 | 2021-04-06 | Kimble | Texas | 48267 | 261 | 6 |
1192617 | 1192617 | 2021-04-05 | Kimble | Texas | 48267 | 261 | 6 |
1189368 | 1189368 | 2021-04-04 | Kimble | Texas | 48267 | 261 | 6 |
1186121 | 1186121 | 2021-04-03 | Kimble | Texas | 48267 | 261 | 6 |
1182874 | 1182874 | 2021-04-02 | Kimble | Texas | 48267 | 261 | 6 |
1179627 | 1179627 | 2021-04-01 | Kimble | Texas | 48267 | 261 | 6 |
1176380 | 1176380 | 2021-03-31 | Kimble | Texas | 48267 | 261 | 6 |
1173133 | 1173133 | 2021-03-30 | Kimble | Texas | 48267 | 261 | 6 |
1169886 | 1169886 | 2021-03-29 | Kimble | Texas | 48267 | 261 | 6 |
1166638 | 1166638 | 2021-03-28 | Kimble | Texas | 48267 | 261 | 6 |
1163390 | 1163390 | 2021-03-27 | Kimble | Texas | 48267 | 260 | 6 |
1160141 | 1160141 | 2021-03-26 | Kimble | Texas | 48267 | 260 | 6 |
1156894 | 1156894 | 2021-03-25 | Kimble | Texas | 48267 | 260 | 6 |
1153647 | 1153647 | 2021-03-24 | Kimble | Texas | 48267 | 260 | 6 |
1150400 | 1150400 | 2021-03-23 | Kimble | Texas | 48267 | 260 | 6 |
1147153 | 1147153 | 2021-03-22 | Kimble | Texas | 48267 | 260 | 6 |
1143906 | 1143906 | 2021-03-21 | Kimble | Texas | 48267 | 259 | 6 |
1140659 | 1140659 | 2021-03-20 | Kimble | Texas | 48267 | 259 | 6 |
1137413 | 1137413 | 2021-03-19 | Kimble | Texas | 48267 | 259 | 6 |
1134167 | 1134167 | 2021-03-18 | Kimble | Texas | 48267 | 259 | 6 |
1130919 | 1130919 | 2021-03-17 | Kimble | Texas | 48267 | 259 | 6 |
1127672 | 1127672 | 2021-03-16 | Kimble | Texas | 48267 | 259 | 6 |
1124426 | 1124426 | 2021-03-15 | Kimble | Texas | 48267 | 259 | 6 |
1121180 | 1121180 | 2021-03-14 | Kimble | Texas | 48267 | 259 | 6 |
1117933 | 1117933 | 2021-03-13 | Kimble | Texas | 48267 | 259 | 6 |
1114686 | 1114686 | 2021-03-12 | Kimble | Texas | 48267 | 259 | 6 |
1111440 | 1111440 | 2021-03-11 | Kimble | Texas | 48267 | 259 | 6 |
1108194 | 1108194 | 2021-03-10 | Kimble | Texas | 48267 | 260 | 6 |
1104948 | 1104948 | 2021-03-09 | Kimble | Texas | 48267 | 259 | 6 |
1101702 | 1101702 | 2021-03-08 | Kimble | Texas | 48267 | 259 | 6 |
1098456 | 1098456 | 2021-03-07 | Kimble | Texas | 48267 | 259 | 6 |
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);