ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 48017 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498957 | 2498957 | 2022-05-12 | Bailey | Texas | 48017 | 1511 | 39 |
2495699 | 2495699 | 2022-05-11 | Bailey | Texas | 48017 | 1511 | 39 |
2492441 | 2492441 | 2022-05-10 | Bailey | Texas | 48017 | 1511 | 39 |
2489183 | 2489183 | 2022-05-09 | Bailey | Texas | 48017 | 1511 | 39 |
2485926 | 2485926 | 2022-05-08 | Bailey | Texas | 48017 | 1511 | 39 |
2482668 | 2482668 | 2022-05-07 | Bailey | Texas | 48017 | 1511 | 39 |
2479410 | 2479410 | 2022-05-06 | Bailey | Texas | 48017 | 1511 | 39 |
2476152 | 2476152 | 2022-05-05 | Bailey | Texas | 48017 | 1511 | 39 |
2472895 | 2472895 | 2022-05-04 | Bailey | Texas | 48017 | 1476 | 39 |
2469639 | 2469639 | 2022-05-03 | Bailey | Texas | 48017 | 1475 | 39 |
2466383 | 2466383 | 2022-05-02 | Bailey | Texas | 48017 | 1475 | 39 |
2463128 | 2463128 | 2022-05-01 | Bailey | Texas | 48017 | 1475 | 39 |
2459872 | 2459872 | 2022-04-30 | Bailey | Texas | 48017 | 1475 | 39 |
2456616 | 2456616 | 2022-04-29 | Bailey | Texas | 48017 | 1475 | 39 |
2453360 | 2453360 | 2022-04-28 | Bailey | Texas | 48017 | 1475 | 39 |
2450104 | 2450104 | 2022-04-27 | Bailey | Texas | 48017 | 1475 | 39 |
2446847 | 2446847 | 2022-04-26 | Bailey | Texas | 48017 | 1475 | 39 |
2443592 | 2443592 | 2022-04-25 | Bailey | Texas | 48017 | 1475 | 39 |
2440336 | 2440336 | 2022-04-24 | Bailey | Texas | 48017 | 1475 | 39 |
2437080 | 2437080 | 2022-04-23 | Bailey | Texas | 48017 | 1475 | 39 |
2433824 | 2433824 | 2022-04-22 | Bailey | Texas | 48017 | 1475 | 39 |
2430568 | 2430568 | 2022-04-21 | Bailey | Texas | 48017 | 1475 | 39 |
2427312 | 2427312 | 2022-04-20 | Bailey | Texas | 48017 | 1475 | 39 |
2424056 | 2424056 | 2022-04-19 | Bailey | Texas | 48017 | 1475 | 39 |
2420800 | 2420800 | 2022-04-18 | Bailey | Texas | 48017 | 1475 | 39 |
2417544 | 2417544 | 2022-04-17 | Bailey | Texas | 48017 | 1475 | 39 |
2414288 | 2414288 | 2022-04-16 | Bailey | Texas | 48017 | 1475 | 39 |
2411032 | 2411032 | 2022-04-15 | Bailey | Texas | 48017 | 1475 | 39 |
2407776 | 2407776 | 2022-04-14 | Bailey | Texas | 48017 | 1475 | 39 |
2404520 | 2404520 | 2022-04-13 | Bailey | Texas | 48017 | 1475 | 39 |
2401265 | 2401265 | 2022-04-12 | Bailey | Texas | 48017 | 1475 | 39 |
2398010 | 2398010 | 2022-04-11 | Bailey | Texas | 48017 | 1475 | 39 |
2394755 | 2394755 | 2022-04-10 | Bailey | Texas | 48017 | 1475 | 39 |
2391499 | 2391499 | 2022-04-09 | Bailey | Texas | 48017 | 1475 | 39 |
2388243 | 2388243 | 2022-04-08 | Bailey | Texas | 48017 | 1463 | 39 |
2384988 | 2384988 | 2022-04-07 | Bailey | Texas | 48017 | 1463 | 39 |
2381733 | 2381733 | 2022-04-06 | Bailey | Texas | 48017 | 1463 | 39 |
2378478 | 2378478 | 2022-04-05 | Bailey | Texas | 48017 | 1463 | 39 |
2375224 | 2375224 | 2022-04-04 | Bailey | Texas | 48017 | 1463 | 39 |
2371972 | 2371972 | 2022-04-03 | Bailey | Texas | 48017 | 1463 | 39 |
2368719 | 2368719 | 2022-04-02 | Bailey | Texas | 48017 | 1463 | 39 |
2365466 | 2365466 | 2022-04-01 | Bailey | Texas | 48017 | 1462 | 39 |
2362213 | 2362213 | 2022-03-31 | Bailey | Texas | 48017 | 1462 | 39 |
2358959 | 2358959 | 2022-03-30 | Bailey | Texas | 48017 | 1462 | 39 |
2355705 | 2355705 | 2022-03-29 | Bailey | Texas | 48017 | 1461 | 39 |
2352452 | 2352452 | 2022-03-28 | Bailey | Texas | 48017 | 1451 | 39 |
2349200 | 2349200 | 2022-03-27 | Bailey | Texas | 48017 | 1451 | 39 |
2345947 | 2345947 | 2022-03-26 | Bailey | Texas | 48017 | 1451 | 39 |
2342694 | 2342694 | 2022-03-25 | Bailey | Texas | 48017 | 1451 | 39 |
2339441 | 2339441 | 2022-03-24 | Bailey | Texas | 48017 | 1444 | 39 |
2336187 | 2336187 | 2022-03-23 | Bailey | Texas | 48017 | 1442 | 39 |
2332933 | 2332933 | 2022-03-22 | Bailey | Texas | 48017 | 1425 | 39 |
2329680 | 2329680 | 2022-03-21 | Bailey | Texas | 48017 | 1425 | 39 |
2326428 | 2326428 | 2022-03-20 | Bailey | Texas | 48017 | 1425 | 39 |
2323175 | 2323175 | 2022-03-19 | Bailey | Texas | 48017 | 1425 | 39 |
2319921 | 2319921 | 2022-03-18 | Bailey | Texas | 48017 | 1424 | 39 |
2316667 | 2316667 | 2022-03-17 | Bailey | Texas | 48017 | 1406 | 39 |
2313414 | 2313414 | 2022-03-16 | Bailey | Texas | 48017 | 1404 | 39 |
2310161 | 2310161 | 2022-03-15 | Bailey | Texas | 48017 | 1403 | 38 |
2306908 | 2306908 | 2022-03-14 | Bailey | Texas | 48017 | 1400 | 38 |
2303657 | 2303657 | 2022-03-13 | Bailey | Texas | 48017 | 1400 | 38 |
2300405 | 2300405 | 2022-03-12 | Bailey | Texas | 48017 | 1400 | 38 |
2297153 | 2297153 | 2022-03-11 | Bailey | Texas | 48017 | 1399 | 38 |
2293901 | 2293901 | 2022-03-10 | Bailey | Texas | 48017 | 1395 | 38 |
2290649 | 2290649 | 2022-03-09 | Bailey | Texas | 48017 | 1385 | 38 |
2287397 | 2287397 | 2022-03-08 | Bailey | Texas | 48017 | 1382 | 38 |
2284145 | 2284145 | 2022-03-07 | Bailey | Texas | 48017 | 1381 | 38 |
2280893 | 2280893 | 2022-03-06 | Bailey | Texas | 48017 | 1381 | 38 |
2277640 | 2277640 | 2022-03-05 | Bailey | Texas | 48017 | 1381 | 38 |
2274387 | 2274387 | 2022-03-04 | Bailey | Texas | 48017 | 1380 | 38 |
2271134 | 2271134 | 2022-03-03 | Bailey | Texas | 48017 | 1380 | 38 |
2267882 | 2267882 | 2022-03-02 | Bailey | Texas | 48017 | 1380 | 38 |
2264629 | 2264629 | 2022-03-01 | Bailey | Texas | 48017 | 1377 | 38 |
2261379 | 2261379 | 2022-02-28 | Bailey | Texas | 48017 | 1370 | 38 |
2258128 | 2258128 | 2022-02-27 | Bailey | Texas | 48017 | 1370 | 38 |
2254877 | 2254877 | 2022-02-26 | Bailey | Texas | 48017 | 1370 | 38 |
2251626 | 2251626 | 2022-02-25 | Bailey | Texas | 48017 | 1370 | 38 |
2248375 | 2248375 | 2022-02-24 | Bailey | Texas | 48017 | 1370 | 38 |
2245124 | 2245124 | 2022-02-23 | Bailey | Texas | 48017 | 1370 | 37 |
2241873 | 2241873 | 2022-02-22 | Bailey | Texas | 48017 | 1370 | 37 |
2238622 | 2238622 | 2022-02-21 | Bailey | Texas | 48017 | 1369 | 37 |
2235371 | 2235371 | 2022-02-20 | Bailey | Texas | 48017 | 1369 | 37 |
2232120 | 2232120 | 2022-02-19 | Bailey | Texas | 48017 | 1368 | 37 |
2228869 | 2228869 | 2022-02-18 | Bailey | Texas | 48017 | 1368 | 37 |
2225618 | 2225618 | 2022-02-17 | Bailey | Texas | 48017 | 1367 | 37 |
2222367 | 2222367 | 2022-02-16 | Bailey | Texas | 48017 | 1363 | 37 |
2219116 | 2219116 | 2022-02-15 | Bailey | Texas | 48017 | 1357 | 37 |
2215865 | 2215865 | 2022-02-14 | Bailey | Texas | 48017 | 1356 | 37 |
2212614 | 2212614 | 2022-02-13 | Bailey | Texas | 48017 | 1356 | 37 |
2209361 | 2209361 | 2022-02-12 | Bailey | Texas | 48017 | 1352 | 34 |
2206108 | 2206108 | 2022-02-11 | Bailey | Texas | 48017 | 1351 | 34 |
2202855 | 2202855 | 2022-02-10 | Bailey | Texas | 48017 | 1350 | 34 |
2199601 | 2199601 | 2022-02-09 | Bailey | Texas | 48017 | 1350 | 34 |
2196347 | 2196347 | 2022-02-08 | Bailey | Texas | 48017 | 1349 | 33 |
2193093 | 2193093 | 2022-02-07 | Bailey | Texas | 48017 | 1348 | 33 |
2189839 | 2189839 | 2022-02-06 | Bailey | Texas | 48017 | 1348 | 33 |
2186586 | 2186586 | 2022-02-05 | Bailey | Texas | 48017 | 1347 | 33 |
2183334 | 2183334 | 2022-02-04 | Bailey | Texas | 48017 | 1344 | 33 |
2180082 | 2180082 | 2022-02-03 | Bailey | Texas | 48017 | 1344 | 33 |
2176831 | 2176831 | 2022-02-02 | Bailey | Texas | 48017 | 1342 | 31 |
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);