ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where fips = 48075 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419788 | 1419788 | 2021-06-14 | Childress | Texas | 48075 | 1382 | 17 |
1416543 | 1416543 | 2021-06-13 | Childress | Texas | 48075 | 1382 | 17 |
1413297 | 1413297 | 2021-06-12 | Childress | Texas | 48075 | 1382 | 17 |
1410052 | 1410052 | 2021-06-11 | Childress | Texas | 48075 | 1380 | 17 |
1406807 | 1406807 | 2021-06-10 | Childress | Texas | 48075 | 1378 | 17 |
1403561 | 1403561 | 2021-06-09 | Childress | Texas | 48075 | 1377 | 17 |
1400316 | 1400316 | 2021-06-08 | Childress | Texas | 48075 | 1377 | 17 |
1397071 | 1397071 | 2021-06-07 | Childress | Texas | 48075 | 1377 | 17 |
1393824 | 1393824 | 2021-06-06 | Childress | Texas | 48075 | 1377 | 17 |
1390579 | 1390579 | 2021-06-05 | Childress | Texas | 48075 | 1377 | 17 |
1387334 | 1387334 | 2021-06-04 | Childress | Texas | 48075 | 1377 | 17 |
1384089 | 1384089 | 2021-06-03 | Childress | Texas | 48075 | 1376 | 17 |
1380843 | 1380843 | 2021-06-02 | Childress | Texas | 48075 | 1374 | 17 |
1377598 | 1377598 | 2021-06-01 | Childress | Texas | 48075 | 1375 | 17 |
1374352 | 1374352 | 2021-05-31 | Childress | Texas | 48075 | 1378 | 17 |
1371107 | 1371107 | 2021-05-30 | Childress | Texas | 48075 | 1378 | 17 |
1367861 | 1367861 | 2021-05-29 | Childress | Texas | 48075 | 1378 | 17 |
1364615 | 1364615 | 2021-05-28 | Childress | Texas | 48075 | 1375 | 17 |
1361369 | 1361369 | 2021-05-27 | Childress | Texas | 48075 | 1378 | 17 |
1358123 | 1358123 | 2021-05-26 | Childress | Texas | 48075 | 1378 | 17 |
1354877 | 1354877 | 2021-05-25 | Childress | Texas | 48075 | 1378 | 17 |
1351631 | 1351631 | 2021-05-24 | Childress | Texas | 48075 | 1379 | 17 |
1348385 | 1348385 | 2021-05-23 | Childress | Texas | 48075 | 1379 | 17 |
1345137 | 1345137 | 2021-05-22 | Childress | Texas | 48075 | 1379 | 17 |
1341889 | 1341889 | 2021-05-21 | Childress | Texas | 48075 | 1370 | 17 |
1338641 | 1338641 | 2021-05-20 | Childress | Texas | 48075 | 1376 | 17 |
1335394 | 1335394 | 2021-05-19 | Childress | Texas | 48075 | 1376 | 17 |
1332147 | 1332147 | 2021-05-18 | Childress | Texas | 48075 | 1382 | 17 |
1328900 | 1328900 | 2021-05-17 | Childress | Texas | 48075 | 1379 | 17 |
1325654 | 1325654 | 2021-05-16 | Childress | Texas | 48075 | 1379 | 17 |
1322408 | 1322408 | 2021-05-15 | Childress | Texas | 48075 | 1379 | 17 |
1319162 | 1319162 | 2021-05-14 | Childress | Texas | 48075 | 1378 | 17 |
1315914 | 1315914 | 2021-05-13 | Childress | Texas | 48075 | 1380 | 17 |
1312668 | 1312668 | 2021-05-12 | Childress | Texas | 48075 | 1379 | 17 |
1309421 | 1309421 | 2021-05-11 | Childress | Texas | 48075 | 1380 | 17 |
1306175 | 1306175 | 2021-05-10 | Childress | Texas | 48075 | 1382 | 17 |
1302929 | 1302929 | 2021-05-09 | Childress | Texas | 48075 | 1382 | 17 |
1299682 | 1299682 | 2021-05-08 | Childress | Texas | 48075 | 1382 | 17 |
1296435 | 1296435 | 2021-05-07 | Childress | Texas | 48075 | 1381 | 17 |
1293189 | 1293189 | 2021-05-06 | Childress | Texas | 48075 | 1382 | 17 |
1289943 | 1289943 | 2021-05-05 | Childress | Texas | 48075 | 1386 | 17 |
1286697 | 1286697 | 2021-05-04 | Childress | Texas | 48075 | 1385 | 17 |
1283451 | 1283451 | 2021-05-03 | Childress | Texas | 48075 | 1384 | 17 |
1280204 | 1280204 | 2021-05-02 | Childress | Texas | 48075 | 1384 | 17 |
1276957 | 1276957 | 2021-05-01 | Childress | Texas | 48075 | 1384 | 17 |
1273710 | 1273710 | 2021-04-30 | Childress | Texas | 48075 | 1384 | 17 |
1270463 | 1270463 | 2021-04-29 | Childress | Texas | 48075 | 1384 | 17 |
1267216 | 1267216 | 2021-04-28 | Childress | Texas | 48075 | 1385 | 17 |
1263969 | 1263969 | 2021-04-27 | Childress | Texas | 48075 | 1387 | 17 |
1260722 | 1260722 | 2021-04-26 | Childress | Texas | 48075 | 1389 | 17 |
1257475 | 1257475 | 2021-04-25 | Childress | Texas | 48075 | 1389 | 17 |
1254228 | 1254228 | 2021-04-24 | Childress | Texas | 48075 | 1389 | 17 |
1250981 | 1250981 | 2021-04-23 | Childress | Texas | 48075 | 1387 | 17 |
1247734 | 1247734 | 2021-04-22 | Childress | Texas | 48075 | 1388 | 17 |
1244487 | 1244487 | 2021-04-21 | Childress | Texas | 48075 | 1384 | 17 |
1241240 | 1241240 | 2021-04-20 | Childress | Texas | 48075 | 1384 | 17 |
1237993 | 1237993 | 2021-04-19 | Childress | Texas | 48075 | 1387 | 17 |
1234746 | 1234746 | 2021-04-18 | Childress | Texas | 48075 | 1387 | 17 |
1231498 | 1231498 | 2021-04-17 | Childress | Texas | 48075 | 1387 | 17 |
1228250 | 1228250 | 2021-04-16 | Childress | Texas | 48075 | 1389 | 17 |
1225002 | 1225002 | 2021-04-15 | Childress | Texas | 48075 | 1390 | 17 |
1221755 | 1221755 | 2021-04-14 | Childress | Texas | 48075 | 1392 | 17 |
1218507 | 1218507 | 2021-04-13 | Childress | Texas | 48075 | 1397 | 17 |
1215259 | 1215259 | 2021-04-12 | Childress | Texas | 48075 | 1380 | 17 |
1212012 | 1212012 | 2021-04-11 | Childress | Texas | 48075 | 1380 | 17 |
1208763 | 1208763 | 2021-04-10 | Childress | Texas | 48075 | 1380 | 17 |
1205515 | 1205515 | 2021-04-09 | Childress | Texas | 48075 | 1352 | 17 |
1202267 | 1202267 | 2021-04-08 | Childress | Texas | 48075 | 1351 | 17 |
1199018 | 1199018 | 2021-04-07 | Childress | Texas | 48075 | 1326 | 17 |
1195769 | 1195769 | 2021-04-06 | Childress | Texas | 48075 | 1324 | 17 |
1192521 | 1192521 | 2021-04-05 | Childress | Texas | 48075 | 1336 | 17 |
1189272 | 1189272 | 2021-04-04 | Childress | Texas | 48075 | 1336 | 17 |
1186025 | 1186025 | 2021-04-03 | Childress | Texas | 48075 | 1336 | 17 |
1182778 | 1182778 | 2021-04-02 | Childress | Texas | 48075 | 1336 | 17 |
1179531 | 1179531 | 2021-04-01 | Childress | Texas | 48075 | 1336 | 17 |
1176284 | 1176284 | 2021-03-31 | Childress | Texas | 48075 | 1336 | 17 |
1173037 | 1173037 | 2021-03-30 | Childress | Texas | 48075 | 1335 | 17 |
1169790 | 1169790 | 2021-03-29 | Childress | Texas | 48075 | 1344 | 17 |
1166542 | 1166542 | 2021-03-28 | Childress | Texas | 48075 | 1344 | 17 |
1163294 | 1163294 | 2021-03-27 | Childress | Texas | 48075 | 1344 | 17 |
1160045 | 1160045 | 2021-03-26 | Childress | Texas | 48075 | 1345 | 17 |
1156798 | 1156798 | 2021-03-25 | Childress | Texas | 48075 | 1343 | 17 |
1153551 | 1153551 | 2021-03-24 | Childress | Texas | 48075 | 1344 | 17 |
1150304 | 1150304 | 2021-03-23 | Childress | Texas | 48075 | 1342 | 17 |
1147057 | 1147057 | 2021-03-22 | Childress | Texas | 48075 | 1338 | 17 |
1143810 | 1143810 | 2021-03-21 | Childress | Texas | 48075 | 1338 | 17 |
1140563 | 1140563 | 2021-03-20 | Childress | Texas | 48075 | 1338 | 17 |
1137317 | 1137317 | 2021-03-19 | Childress | Texas | 48075 | 1335 | 17 |
1134071 | 1134071 | 2021-03-18 | Childress | Texas | 48075 | 1337 | 17 |
1130823 | 1130823 | 2021-03-17 | Childress | Texas | 48075 | 1335 | 17 |
1127576 | 1127576 | 2021-03-16 | Childress | Texas | 48075 | 1335 | 17 |
1124330 | 1124330 | 2021-03-15 | Childress | Texas | 48075 | 1342 | 17 |
1121084 | 1121084 | 2021-03-14 | Childress | Texas | 48075 | 1342 | 17 |
1117837 | 1117837 | 2021-03-13 | Childress | Texas | 48075 | 1342 | 17 |
1114590 | 1114590 | 2021-03-12 | Childress | Texas | 48075 | 1337 | 17 |
1111344 | 1111344 | 2021-03-11 | Childress | Texas | 48075 | 1336 | 17 |
1108098 | 1108098 | 2021-03-10 | Childress | Texas | 48075 | 1337 | 17 |
1104852 | 1104852 | 2021-03-09 | Childress | Texas | 48075 | 1336 | 17 |
1101606 | 1101606 | 2021-03-08 | Childress | Texas | 48075 | 1335 | 17 |
1098360 | 1098360 | 2021-03-07 | Childress | Texas | 48075 | 1335 | 17 |
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);