ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 48371 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502392 | 2502392 | 2022-05-13 | Pecos | Texas | 48371 | 2749 | 71 |
2499134 | 2499134 | 2022-05-12 | Pecos | Texas | 48371 | 2749 | 71 |
2495876 | 2495876 | 2022-05-11 | Pecos | Texas | 48371 | 2748 | 71 |
2492618 | 2492618 | 2022-05-10 | Pecos | Texas | 48371 | 2748 | 71 |
2489360 | 2489360 | 2022-05-09 | Pecos | Texas | 48371 | 2746 | 71 |
2486103 | 2486103 | 2022-05-08 | Pecos | Texas | 48371 | 2746 | 71 |
2482845 | 2482845 | 2022-05-07 | Pecos | Texas | 48371 | 2746 | 71 |
2479587 | 2479587 | 2022-05-06 | Pecos | Texas | 48371 | 2745 | 71 |
2476329 | 2476329 | 2022-05-05 | Pecos | Texas | 48371 | 2744 | 71 |
2473072 | 2473072 | 2022-05-04 | Pecos | Texas | 48371 | 2744 | 71 |
2469816 | 2469816 | 2022-05-03 | Pecos | Texas | 48371 | 2744 | 71 |
2466560 | 2466560 | 2022-05-02 | Pecos | Texas | 48371 | 2744 | 71 |
2463305 | 2463305 | 2022-05-01 | Pecos | Texas | 48371 | 2744 | 71 |
2460049 | 2460049 | 2022-04-30 | Pecos | Texas | 48371 | 2744 | 71 |
2456793 | 2456793 | 2022-04-29 | Pecos | Texas | 48371 | 2744 | 71 |
2453537 | 2453537 | 2022-04-28 | Pecos | Texas | 48371 | 2744 | 71 |
2450281 | 2450281 | 2022-04-27 | Pecos | Texas | 48371 | 2744 | 71 |
2447024 | 2447024 | 2022-04-26 | Pecos | Texas | 48371 | 2744 | 71 |
2443769 | 2443769 | 2022-04-25 | Pecos | Texas | 48371 | 2742 | 71 |
2440513 | 2440513 | 2022-04-24 | Pecos | Texas | 48371 | 2742 | 71 |
2437257 | 2437257 | 2022-04-23 | Pecos | Texas | 48371 | 2742 | 71 |
2434001 | 2434001 | 2022-04-22 | Pecos | Texas | 48371 | 2742 | 71 |
2430745 | 2430745 | 2022-04-21 | Pecos | Texas | 48371 | 2741 | 71 |
2427489 | 2427489 | 2022-04-20 | Pecos | Texas | 48371 | 2740 | 71 |
2424233 | 2424233 | 2022-04-19 | Pecos | Texas | 48371 | 2740 | 71 |
2420977 | 2420977 | 2022-04-18 | Pecos | Texas | 48371 | 2739 | 71 |
2417721 | 2417721 | 2022-04-17 | Pecos | Texas | 48371 | 2738 | 71 |
2414465 | 2414465 | 2022-04-16 | Pecos | Texas | 48371 | 2738 | 71 |
2411209 | 2411209 | 2022-04-15 | Pecos | Texas | 48371 | 2738 | 71 |
2407953 | 2407953 | 2022-04-14 | Pecos | Texas | 48371 | 2738 | 71 |
2404697 | 2404697 | 2022-04-13 | Pecos | Texas | 48371 | 2738 | 71 |
2401442 | 2401442 | 2022-04-12 | Pecos | Texas | 48371 | 2738 | 71 |
2398187 | 2398187 | 2022-04-11 | Pecos | Texas | 48371 | 2738 | 71 |
2394932 | 2394932 | 2022-04-10 | Pecos | Texas | 48371 | 2738 | 71 |
2391676 | 2391676 | 2022-04-09 | Pecos | Texas | 48371 | 2738 | 71 |
2388420 | 2388420 | 2022-04-08 | Pecos | Texas | 48371 | 2737 | 71 |
2385165 | 2385165 | 2022-04-07 | Pecos | Texas | 48371 | 2735 | 71 |
2381910 | 2381910 | 2022-04-06 | Pecos | Texas | 48371 | 2735 | 71 |
2378655 | 2378655 | 2022-04-05 | Pecos | Texas | 48371 | 2735 | 71 |
2375401 | 2375401 | 2022-04-04 | Pecos | Texas | 48371 | 2735 | 71 |
2372149 | 2372149 | 2022-04-03 | Pecos | Texas | 48371 | 2735 | 71 |
2368896 | 2368896 | 2022-04-02 | Pecos | Texas | 48371 | 2735 | 71 |
2365643 | 2365643 | 2022-04-01 | Pecos | Texas | 48371 | 2735 | 71 |
2362390 | 2362390 | 2022-03-31 | Pecos | Texas | 48371 | 2735 | 71 |
2359136 | 2359136 | 2022-03-30 | Pecos | Texas | 48371 | 2734 | 71 |
2355882 | 2355882 | 2022-03-29 | Pecos | Texas | 48371 | 2734 | 71 |
2352629 | 2352629 | 2022-03-28 | Pecos | Texas | 48371 | 2728 | 71 |
2349377 | 2349377 | 2022-03-27 | Pecos | Texas | 48371 | 2728 | 71 |
2346124 | 2346124 | 2022-03-26 | Pecos | Texas | 48371 | 2728 | 71 |
2342871 | 2342871 | 2022-03-25 | Pecos | Texas | 48371 | 2721 | 71 |
2339618 | 2339618 | 2022-03-24 | Pecos | Texas | 48371 | 2720 | 71 |
2336364 | 2336364 | 2022-03-23 | Pecos | Texas | 48371 | 2720 | 71 |
2333110 | 2333110 | 2022-03-22 | Pecos | Texas | 48371 | 2720 | 71 |
2329857 | 2329857 | 2022-03-21 | Pecos | Texas | 48371 | 2719 | 71 |
2326605 | 2326605 | 2022-03-20 | Pecos | Texas | 48371 | 2719 | 71 |
2323352 | 2323352 | 2022-03-19 | Pecos | Texas | 48371 | 2718 | 71 |
2320098 | 2320098 | 2022-03-18 | Pecos | Texas | 48371 | 2718 | 71 |
2316844 | 2316844 | 2022-03-17 | Pecos | Texas | 48371 | 2716 | 71 |
2313591 | 2313591 | 2022-03-16 | Pecos | Texas | 48371 | 2651 | 71 |
2310338 | 2310338 | 2022-03-15 | Pecos | Texas | 48371 | 2651 | 70 |
2307085 | 2307085 | 2022-03-14 | Pecos | Texas | 48371 | 2651 | 70 |
2303834 | 2303834 | 2022-03-13 | Pecos | Texas | 48371 | 2649 | 70 |
2300582 | 2300582 | 2022-03-12 | Pecos | Texas | 48371 | 2649 | 70 |
2297330 | 2297330 | 2022-03-11 | Pecos | Texas | 48371 | 2649 | 70 |
2294078 | 2294078 | 2022-03-10 | Pecos | Texas | 48371 | 2648 | 69 |
2290826 | 2290826 | 2022-03-09 | Pecos | Texas | 48371 | 2648 | 69 |
2287574 | 2287574 | 2022-03-08 | Pecos | Texas | 48371 | 2648 | 69 |
2284322 | 2284322 | 2022-03-07 | Pecos | Texas | 48371 | 2647 | 69 |
2281070 | 2281070 | 2022-03-06 | Pecos | Texas | 48371 | 2647 | 69 |
2277817 | 2277817 | 2022-03-05 | Pecos | Texas | 48371 | 2647 | 69 |
2274564 | 2274564 | 2022-03-04 | Pecos | Texas | 48371 | 2647 | 69 |
2271311 | 2271311 | 2022-03-03 | Pecos | Texas | 48371 | 2646 | 69 |
2268059 | 2268059 | 2022-03-02 | Pecos | Texas | 48371 | 2646 | 69 |
2264806 | 2264806 | 2022-03-01 | Pecos | Texas | 48371 | 2645 | 69 |
2261556 | 2261556 | 2022-02-28 | Pecos | Texas | 48371 | 2644 | 69 |
2258305 | 2258305 | 2022-02-27 | Pecos | Texas | 48371 | 2644 | 69 |
2255054 | 2255054 | 2022-02-26 | Pecos | Texas | 48371 | 2644 | 69 |
2251803 | 2251803 | 2022-02-25 | Pecos | Texas | 48371 | 2643 | 69 |
2248552 | 2248552 | 2022-02-24 | Pecos | Texas | 48371 | 2640 | 69 |
2245301 | 2245301 | 2022-02-23 | Pecos | Texas | 48371 | 2639 | 69 |
2242050 | 2242050 | 2022-02-22 | Pecos | Texas | 48371 | 2637 | 68 |
2238799 | 2238799 | 2022-02-21 | Pecos | Texas | 48371 | 2632 | 68 |
2235548 | 2235548 | 2022-02-20 | Pecos | Texas | 48371 | 2631 | 68 |
2232297 | 2232297 | 2022-02-19 | Pecos | Texas | 48371 | 2631 | 68 |
2229046 | 2229046 | 2022-02-18 | Pecos | Texas | 48371 | 2626 | 67 |
2225795 | 2225795 | 2022-02-17 | Pecos | Texas | 48371 | 2624 | 66 |
2222544 | 2222544 | 2022-02-16 | Pecos | Texas | 48371 | 2618 | 66 |
2219293 | 2219293 | 2022-02-15 | Pecos | Texas | 48371 | 2609 | 66 |
2216042 | 2216042 | 2022-02-14 | Pecos | Texas | 48371 | 2606 | 66 |
2212791 | 2212791 | 2022-02-13 | Pecos | Texas | 48371 | 2605 | 66 |
2209538 | 2209538 | 2022-02-12 | Pecos | Texas | 48371 | 2605 | 65 |
2206285 | 2206285 | 2022-02-11 | Pecos | Texas | 48371 | 2605 | 65 |
2203032 | 2203032 | 2022-02-10 | Pecos | Texas | 48371 | 2603 | 65 |
2199778 | 2199778 | 2022-02-09 | Pecos | Texas | 48371 | 2600 | 65 |
2196524 | 2196524 | 2022-02-08 | Pecos | Texas | 48371 | 2596 | 65 |
2193270 | 2193270 | 2022-02-07 | Pecos | Texas | 48371 | 2594 | 65 |
2190016 | 2190016 | 2022-02-06 | Pecos | Texas | 48371 | 2593 | 65 |
2186763 | 2186763 | 2022-02-05 | Pecos | Texas | 48371 | 2588 | 65 |
2183511 | 2183511 | 2022-02-04 | Pecos | Texas | 48371 | 2579 | 65 |
2180259 | 2180259 | 2022-02-03 | Pecos | Texas | 48371 | 2573 | 64 |
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);