ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 48127 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502270 | 2502270 | 2022-05-13 | Dimmit | Texas | 48127 | 5760 | 51 |
2499012 | 2499012 | 2022-05-12 | Dimmit | Texas | 48127 | 5760 | 51 |
2495754 | 2495754 | 2022-05-11 | Dimmit | Texas | 48127 | 5759 | 51 |
2492496 | 2492496 | 2022-05-10 | Dimmit | Texas | 48127 | 5759 | 51 |
2489238 | 2489238 | 2022-05-09 | Dimmit | Texas | 48127 | 5759 | 51 |
2485981 | 2485981 | 2022-05-08 | Dimmit | Texas | 48127 | 5759 | 51 |
2482723 | 2482723 | 2022-05-07 | Dimmit | Texas | 48127 | 5759 | 51 |
2479465 | 2479465 | 2022-05-06 | Dimmit | Texas | 48127 | 5757 | 51 |
2476207 | 2476207 | 2022-05-05 | Dimmit | Texas | 48127 | 5756 | 51 |
2472950 | 2472950 | 2022-05-04 | Dimmit | Texas | 48127 | 5756 | 51 |
2469694 | 2469694 | 2022-05-03 | Dimmit | Texas | 48127 | 5756 | 51 |
2466438 | 2466438 | 2022-05-02 | Dimmit | Texas | 48127 | 5756 | 51 |
2463183 | 2463183 | 2022-05-01 | Dimmit | Texas | 48127 | 5756 | 51 |
2459927 | 2459927 | 2022-04-30 | Dimmit | Texas | 48127 | 5756 | 51 |
2456671 | 2456671 | 2022-04-29 | Dimmit | Texas | 48127 | 5756 | 51 |
2453415 | 2453415 | 2022-04-28 | Dimmit | Texas | 48127 | 5755 | 51 |
2450159 | 2450159 | 2022-04-27 | Dimmit | Texas | 48127 | 5752 | 51 |
2446902 | 2446902 | 2022-04-26 | Dimmit | Texas | 48127 | 5752 | 51 |
2443647 | 2443647 | 2022-04-25 | Dimmit | Texas | 48127 | 5752 | 51 |
2440391 | 2440391 | 2022-04-24 | Dimmit | Texas | 48127 | 5752 | 51 |
2437135 | 2437135 | 2022-04-23 | Dimmit | Texas | 48127 | 5752 | 51 |
2433879 | 2433879 | 2022-04-22 | Dimmit | Texas | 48127 | 5752 | 51 |
2430623 | 2430623 | 2022-04-21 | Dimmit | Texas | 48127 | 5752 | 51 |
2427367 | 2427367 | 2022-04-20 | Dimmit | Texas | 48127 | 5750 | 51 |
2424111 | 2424111 | 2022-04-19 | Dimmit | Texas | 48127 | 5750 | 51 |
2420855 | 2420855 | 2022-04-18 | Dimmit | Texas | 48127 | 5750 | 51 |
2417599 | 2417599 | 2022-04-17 | Dimmit | Texas | 48127 | 5749 | 51 |
2414343 | 2414343 | 2022-04-16 | Dimmit | Texas | 48127 | 5749 | 51 |
2411087 | 2411087 | 2022-04-15 | Dimmit | Texas | 48127 | 5749 | 51 |
2407831 | 2407831 | 2022-04-14 | Dimmit | Texas | 48127 | 5749 | 51 |
2404575 | 2404575 | 2022-04-13 | Dimmit | Texas | 48127 | 5749 | 51 |
2401320 | 2401320 | 2022-04-12 | Dimmit | Texas | 48127 | 5749 | 51 |
2398065 | 2398065 | 2022-04-11 | Dimmit | Texas | 48127 | 5749 | 51 |
2394810 | 2394810 | 2022-04-10 | Dimmit | Texas | 48127 | 5749 | 51 |
2391554 | 2391554 | 2022-04-09 | Dimmit | Texas | 48127 | 5749 | 51 |
2388298 | 2388298 | 2022-04-08 | Dimmit | Texas | 48127 | 5749 | 51 |
2385043 | 2385043 | 2022-04-07 | Dimmit | Texas | 48127 | 5749 | 51 |
2381788 | 2381788 | 2022-04-06 | Dimmit | Texas | 48127 | 5748 | 51 |
2378533 | 2378533 | 2022-04-05 | Dimmit | Texas | 48127 | 5748 | 51 |
2375279 | 2375279 | 2022-04-04 | Dimmit | Texas | 48127 | 5748 | 51 |
2372027 | 2372027 | 2022-04-03 | Dimmit | Texas | 48127 | 5747 | 51 |
2368774 | 2368774 | 2022-04-02 | Dimmit | Texas | 48127 | 5747 | 51 |
2365521 | 2365521 | 2022-04-01 | Dimmit | Texas | 48127 | 5747 | 51 |
2362268 | 2362268 | 2022-03-31 | Dimmit | Texas | 48127 | 5745 | 51 |
2359014 | 2359014 | 2022-03-30 | Dimmit | Texas | 48127 | 5745 | 51 |
2355760 | 2355760 | 2022-03-29 | Dimmit | Texas | 48127 | 5745 | 51 |
2352507 | 2352507 | 2022-03-28 | Dimmit | Texas | 48127 | 5745 | 51 |
2349255 | 2349255 | 2022-03-27 | Dimmit | Texas | 48127 | 5745 | 51 |
2346002 | 2346002 | 2022-03-26 | Dimmit | Texas | 48127 | 5744 | 51 |
2342749 | 2342749 | 2022-03-25 | Dimmit | Texas | 48127 | 5743 | 51 |
2339496 | 2339496 | 2022-03-24 | Dimmit | Texas | 48127 | 5743 | 51 |
2336242 | 2336242 | 2022-03-23 | Dimmit | Texas | 48127 | 5742 | 51 |
2332988 | 2332988 | 2022-03-22 | Dimmit | Texas | 48127 | 5742 | 51 |
2329735 | 2329735 | 2022-03-21 | Dimmit | Texas | 48127 | 5740 | 51 |
2326483 | 2326483 | 2022-03-20 | Dimmit | Texas | 48127 | 5740 | 51 |
2323230 | 2323230 | 2022-03-19 | Dimmit | Texas | 48127 | 5740 | 51 |
2319976 | 2319976 | 2022-03-18 | Dimmit | Texas | 48127 | 5739 | 51 |
2316722 | 2316722 | 2022-03-17 | Dimmit | Texas | 48127 | 5739 | 51 |
2313469 | 2313469 | 2022-03-16 | Dimmit | Texas | 48127 | 5738 | 51 |
2310216 | 2310216 | 2022-03-15 | Dimmit | Texas | 48127 | 5738 | 51 |
2306963 | 2306963 | 2022-03-14 | Dimmit | Texas | 48127 | 5738 | 51 |
2303712 | 2303712 | 2022-03-13 | Dimmit | Texas | 48127 | 5738 | 51 |
2300460 | 2300460 | 2022-03-12 | Dimmit | Texas | 48127 | 5738 | 51 |
2297208 | 2297208 | 2022-03-11 | Dimmit | Texas | 48127 | 5737 | 51 |
2293956 | 2293956 | 2022-03-10 | Dimmit | Texas | 48127 | 5736 | 51 |
2290704 | 2290704 | 2022-03-09 | Dimmit | Texas | 48127 | 5732 | 51 |
2287452 | 2287452 | 2022-03-08 | Dimmit | Texas | 48127 | 5728 | 51 |
2284200 | 2284200 | 2022-03-07 | Dimmit | Texas | 48127 | 5724 | 51 |
2280948 | 2280948 | 2022-03-06 | Dimmit | Texas | 48127 | 5718 | 51 |
2277695 | 2277695 | 2022-03-05 | Dimmit | Texas | 48127 | 5714 | 51 |
2274442 | 2274442 | 2022-03-04 | Dimmit | Texas | 48127 | 5711 | 51 |
2271189 | 2271189 | 2022-03-03 | Dimmit | Texas | 48127 | 5708 | 51 |
2267937 | 2267937 | 2022-03-02 | Dimmit | Texas | 48127 | 5700 | 51 |
2264684 | 2264684 | 2022-03-01 | Dimmit | Texas | 48127 | 5691 | 51 |
2261434 | 2261434 | 2022-02-28 | Dimmit | Texas | 48127 | 5681 | 51 |
2258183 | 2258183 | 2022-02-27 | Dimmit | Texas | 48127 | 5679 | 51 |
2254932 | 2254932 | 2022-02-26 | Dimmit | Texas | 48127 | 5675 | 51 |
2251681 | 2251681 | 2022-02-25 | Dimmit | Texas | 48127 | 5667 | 50 |
2248430 | 2248430 | 2022-02-24 | Dimmit | Texas | 48127 | 5657 | 50 |
2245179 | 2245179 | 2022-02-23 | Dimmit | Texas | 48127 | 5636 | 50 |
2241928 | 2241928 | 2022-02-22 | Dimmit | Texas | 48127 | 5634 | 50 |
2238677 | 2238677 | 2022-02-21 | Dimmit | Texas | 48127 | 5630 | 50 |
2235426 | 2235426 | 2022-02-20 | Dimmit | Texas | 48127 | 5625 | 50 |
2232175 | 2232175 | 2022-02-19 | Dimmit | Texas | 48127 | 5617 | 50 |
2228924 | 2228924 | 2022-02-18 | Dimmit | Texas | 48127 | 5603 | 50 |
2225673 | 2225673 | 2022-02-17 | Dimmit | Texas | 48127 | 5599 | 50 |
2222422 | 2222422 | 2022-02-16 | Dimmit | Texas | 48127 | 5576 | 50 |
2219171 | 2219171 | 2022-02-15 | Dimmit | Texas | 48127 | 5557 | 50 |
2215920 | 2215920 | 2022-02-14 | Dimmit | Texas | 48127 | 5552 | 50 |
2212669 | 2212669 | 2022-02-13 | Dimmit | Texas | 48127 | 5539 | 50 |
2209416 | 2209416 | 2022-02-12 | Dimmit | Texas | 48127 | 5531 | 50 |
2206163 | 2206163 | 2022-02-11 | Dimmit | Texas | 48127 | 5525 | 50 |
2202910 | 2202910 | 2022-02-10 | Dimmit | Texas | 48127 | 5506 | 50 |
2199656 | 2199656 | 2022-02-09 | Dimmit | Texas | 48127 | 5491 | 50 |
2196402 | 2196402 | 2022-02-08 | Dimmit | Texas | 48127 | 5478 | 50 |
2193148 | 2193148 | 2022-02-07 | Dimmit | Texas | 48127 | 5474 | 50 |
2189894 | 2189894 | 2022-02-06 | Dimmit | Texas | 48127 | 5466 | 50 |
2186641 | 2186641 | 2022-02-05 | Dimmit | Texas | 48127 | 5433 | 50 |
2183389 | 2183389 | 2022-02-04 | Dimmit | Texas | 48127 | 5417 | 50 |
2180137 | 2180137 | 2022-02-03 | Dimmit | Texas | 48127 | 5391 | 49 |
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);