ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 48241 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419871 | 1419871 | 2021-06-14 | Jasper | Texas | 48241 | 2523 | 93 |
1416626 | 1416626 | 2021-06-13 | Jasper | Texas | 48241 | 2523 | 93 |
1413380 | 1413380 | 2021-06-12 | Jasper | Texas | 48241 | 2523 | 93 |
1410135 | 1410135 | 2021-06-11 | Jasper | Texas | 48241 | 2523 | 93 |
1406890 | 1406890 | 2021-06-10 | Jasper | Texas | 48241 | 2519 | 92 |
1403644 | 1403644 | 2021-06-09 | Jasper | Texas | 48241 | 2519 | 92 |
1400399 | 1400399 | 2021-06-08 | Jasper | Texas | 48241 | 2519 | 92 |
1397154 | 1397154 | 2021-06-07 | Jasper | Texas | 48241 | 2514 | 92 |
1393907 | 1393907 | 2021-06-06 | Jasper | Texas | 48241 | 2514 | 92 |
1390662 | 1390662 | 2021-06-05 | Jasper | Texas | 48241 | 2514 | 92 |
1387417 | 1387417 | 2021-06-04 | Jasper | Texas | 48241 | 2506 | 92 |
1384172 | 1384172 | 2021-06-03 | Jasper | Texas | 48241 | 2506 | 92 |
1380926 | 1380926 | 2021-06-02 | Jasper | Texas | 48241 | 2506 | 92 |
1377681 | 1377681 | 2021-06-01 | Jasper | Texas | 48241 | 2495 | 92 |
1374435 | 1374435 | 2021-05-31 | Jasper | Texas | 48241 | 2495 | 92 |
1371190 | 1371190 | 2021-05-30 | Jasper | Texas | 48241 | 2495 | 92 |
1367944 | 1367944 | 2021-05-29 | Jasper | Texas | 48241 | 2495 | 92 |
1364698 | 1364698 | 2021-05-28 | Jasper | Texas | 48241 | 2495 | 92 |
1361452 | 1361452 | 2021-05-27 | Jasper | Texas | 48241 | 2495 | 92 |
1358206 | 1358206 | 2021-05-26 | Jasper | Texas | 48241 | 2495 | 92 |
1354960 | 1354960 | 2021-05-25 | Jasper | Texas | 48241 | 2495 | 91 |
1351714 | 1351714 | 2021-05-24 | Jasper | Texas | 48241 | 2495 | 91 |
1348468 | 1348468 | 2021-05-23 | Jasper | Texas | 48241 | 2495 | 91 |
1345220 | 1345220 | 2021-05-22 | Jasper | Texas | 48241 | 2495 | 91 |
1341972 | 1341972 | 2021-05-21 | Jasper | Texas | 48241 | 2495 | 91 |
1338724 | 1338724 | 2021-05-20 | Jasper | Texas | 48241 | 2483 | 90 |
1335477 | 1335477 | 2021-05-19 | Jasper | Texas | 48241 | 2483 | 90 |
1332230 | 1332230 | 2021-05-18 | Jasper | Texas | 48241 | 2483 | 90 |
1328983 | 1328983 | 2021-05-17 | Jasper | Texas | 48241 | 2483 | 90 |
1325737 | 1325737 | 2021-05-16 | Jasper | Texas | 48241 | 2483 | 90 |
1322491 | 1322491 | 2021-05-15 | Jasper | Texas | 48241 | 2483 | 90 |
1319245 | 1319245 | 2021-05-14 | Jasper | Texas | 48241 | 2483 | 90 |
1315997 | 1315997 | 2021-05-13 | Jasper | Texas | 48241 | 2483 | 90 |
1312751 | 1312751 | 2021-05-12 | Jasper | Texas | 48241 | 2483 | 90 |
1309504 | 1309504 | 2021-05-11 | Jasper | Texas | 48241 | 2483 | 90 |
1306258 | 1306258 | 2021-05-10 | Jasper | Texas | 48241 | 2474 | 90 |
1303012 | 1303012 | 2021-05-09 | Jasper | Texas | 48241 | 2474 | 90 |
1299765 | 1299765 | 2021-05-08 | Jasper | Texas | 48241 | 2474 | 90 |
1296518 | 1296518 | 2021-05-07 | Jasper | Texas | 48241 | 2474 | 90 |
1293272 | 1293272 | 2021-05-06 | Jasper | Texas | 48241 | 2470 | 90 |
1290026 | 1290026 | 2021-05-05 | Jasper | Texas | 48241 | 2470 | 90 |
1286780 | 1286780 | 2021-05-04 | Jasper | Texas | 48241 | 2470 | 89 |
1283534 | 1283534 | 2021-05-03 | Jasper | Texas | 48241 | 2466 | 88 |
1280287 | 1280287 | 2021-05-02 | Jasper | Texas | 48241 | 2466 | 88 |
1277040 | 1277040 | 2021-05-01 | Jasper | Texas | 48241 | 2466 | 88 |
1273793 | 1273793 | 2021-04-30 | Jasper | Texas | 48241 | 2466 | 88 |
1270546 | 1270546 | 2021-04-29 | Jasper | Texas | 48241 | 2458 | 88 |
1267299 | 1267299 | 2021-04-28 | Jasper | Texas | 48241 | 2458 | 88 |
1264052 | 1264052 | 2021-04-27 | Jasper | Texas | 48241 | 2458 | 88 |
1260805 | 1260805 | 2021-04-26 | Jasper | Texas | 48241 | 2450 | 88 |
1257558 | 1257558 | 2021-04-25 | Jasper | Texas | 48241 | 2450 | 88 |
1254311 | 1254311 | 2021-04-24 | Jasper | Texas | 48241 | 2450 | 88 |
1251064 | 1251064 | 2021-04-23 | Jasper | Texas | 48241 | 2450 | 88 |
1247817 | 1247817 | 2021-04-22 | Jasper | Texas | 48241 | 2450 | 88 |
1244570 | 1244570 | 2021-04-21 | Jasper | Texas | 48241 | 2449 | 88 |
1241323 | 1241323 | 2021-04-20 | Jasper | Texas | 48241 | 2429 | 88 |
1238076 | 1238076 | 2021-04-19 | Jasper | Texas | 48241 | 2429 | 88 |
1234829 | 1234829 | 2021-04-18 | Jasper | Texas | 48241 | 2429 | 88 |
1231581 | 1231581 | 2021-04-17 | Jasper | Texas | 48241 | 2429 | 88 |
1228333 | 1228333 | 2021-04-16 | Jasper | Texas | 48241 | 2429 | 88 |
1225085 | 1225085 | 2021-04-15 | Jasper | Texas | 48241 | 2411 | 88 |
1221838 | 1221838 | 2021-04-14 | Jasper | Texas | 48241 | 2411 | 88 |
1218590 | 1218590 | 2021-04-13 | Jasper | Texas | 48241 | 2411 | 88 |
1215342 | 1215342 | 2021-04-12 | Jasper | Texas | 48241 | 2411 | 88 |
1212095 | 1212095 | 2021-04-11 | Jasper | Texas | 48241 | 2411 | 88 |
1208846 | 1208846 | 2021-04-10 | Jasper | Texas | 48241 | 2411 | 88 |
1205598 | 1205598 | 2021-04-09 | Jasper | Texas | 48241 | 2395 | 88 |
1202350 | 1202350 | 2021-04-08 | Jasper | Texas | 48241 | 2395 | 88 |
1199101 | 1199101 | 2021-04-07 | Jasper | Texas | 48241 | 2395 | 88 |
1195852 | 1195852 | 2021-04-06 | Jasper | Texas | 48241 | 2395 | 87 |
1192604 | 1192604 | 2021-04-05 | Jasper | Texas | 48241 | 2386 | 87 |
1189355 | 1189355 | 2021-04-04 | Jasper | Texas | 48241 | 2386 | 87 |
1186108 | 1186108 | 2021-04-03 | Jasper | Texas | 48241 | 2386 | 87 |
1182861 | 1182861 | 2021-04-02 | Jasper | Texas | 48241 | 2386 | 87 |
1179614 | 1179614 | 2021-04-01 | Jasper | Texas | 48241 | 2379 | 87 |
1176367 | 1176367 | 2021-03-31 | Jasper | Texas | 48241 | 2379 | 86 |
1173120 | 1173120 | 2021-03-30 | Jasper | Texas | 48241 | 2363 | 84 |
1169873 | 1169873 | 2021-03-29 | Jasper | Texas | 48241 | 2363 | 84 |
1166625 | 1166625 | 2021-03-28 | Jasper | Texas | 48241 | 2363 | 84 |
1163377 | 1163377 | 2021-03-27 | Jasper | Texas | 48241 | 2363 | 84 |
1160128 | 1160128 | 2021-03-26 | Jasper | Texas | 48241 | 2363 | 84 |
1156881 | 1156881 | 2021-03-25 | Jasper | Texas | 48241 | 2363 | 83 |
1153634 | 1153634 | 2021-03-24 | Jasper | Texas | 48241 | 2362 | 83 |
1150387 | 1150387 | 2021-03-23 | Jasper | Texas | 48241 | 2358 | 83 |
1147140 | 1147140 | 2021-03-22 | Jasper | Texas | 48241 | 2352 | 83 |
1143893 | 1143893 | 2021-03-21 | Jasper | Texas | 48241 | 2352 | 83 |
1140646 | 1140646 | 2021-03-20 | Jasper | Texas | 48241 | 2354 | 83 |
1137400 | 1137400 | 2021-03-19 | Jasper | Texas | 48241 | 2352 | 83 |
1134154 | 1134154 | 2021-03-18 | Jasper | Texas | 48241 | 2350 | 82 |
1130906 | 1130906 | 2021-03-17 | Jasper | Texas | 48241 | 2347 | 82 |
1127659 | 1127659 | 2021-03-16 | Jasper | Texas | 48241 | 2345 | 82 |
1124413 | 1124413 | 2021-03-15 | Jasper | Texas | 48241 | 2336 | 82 |
1121167 | 1121167 | 2021-03-14 | Jasper | Texas | 48241 | 2336 | 82 |
1117920 | 1117920 | 2021-03-13 | Jasper | Texas | 48241 | 2336 | 82 |
1114673 | 1114673 | 2021-03-12 | Jasper | Texas | 48241 | 2336 | 82 |
1111427 | 1111427 | 2021-03-11 | Jasper | Texas | 48241 | 2336 | 81 |
1108181 | 1108181 | 2021-03-10 | Jasper | Texas | 48241 | 2324 | 81 |
1104935 | 1104935 | 2021-03-09 | Jasper | Texas | 48241 | 2324 | 81 |
1101689 | 1101689 | 2021-03-08 | Jasper | Texas | 48241 | 2313 | 80 |
1098443 | 1098443 | 2021-03-07 | Jasper | Texas | 48241 | 2313 | 80 |
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);