ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

778 rows where county = "Young" and state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Texas · 778 ✖

fips 1

county 1

  • Young · 778 ✖
Link rowid date ▲ county state fips cases deaths
2502459 2502459 2022-05-13 Young Texas 48503 4002 94
2499201 2499201 2022-05-12 Young Texas 48503 4000 94
2495943 2495943 2022-05-11 Young Texas 48503 3974 94
2492685 2492685 2022-05-10 Young Texas 48503 3966 94
2489427 2489427 2022-05-09 Young Texas 48503 3962 94
2486169 2486169 2022-05-08 Young Texas 48503 3962 94
2482911 2482911 2022-05-07 Young Texas 48503 3962 94
2479653 2479653 2022-05-06 Young Texas 48503 3959 94
2476395 2476395 2022-05-05 Young Texas 48503 3957 94
2473138 2473138 2022-05-04 Young Texas 48503 3955 94
2469882 2469882 2022-05-03 Young Texas 48503 3953 94
2466626 2466626 2022-05-02 Young Texas 48503 3953 94
2463371 2463371 2022-05-01 Young Texas 48503 3953 94
2460115 2460115 2022-04-30 Young Texas 48503 3953 94
2456859 2456859 2022-04-29 Young Texas 48503 3950 94
2453603 2453603 2022-04-28 Young Texas 48503 3939 94
2450347 2450347 2022-04-27 Young Texas 48503 3931 93
2447090 2447090 2022-04-26 Young Texas 48503 3930 93
2443835 2443835 2022-04-25 Young Texas 48503 3929 93
2440579 2440579 2022-04-24 Young Texas 48503 3929 93
2437323 2437323 2022-04-23 Young Texas 48503 3929 93
2434067 2434067 2022-04-22 Young Texas 48503 3924 93
2430811 2430811 2022-04-21 Young Texas 48503 3922 93
2427555 2427555 2022-04-20 Young Texas 48503 3919 93
2424299 2424299 2022-04-19 Young Texas 48503 3918 93
2421043 2421043 2022-04-18 Young Texas 48503 3917 93
2417787 2417787 2022-04-17 Young Texas 48503 3914 93
2414531 2414531 2022-04-16 Young Texas 48503 3914 93
2411275 2411275 2022-04-15 Young Texas 48503 3914 93
2408019 2408019 2022-04-14 Young Texas 48503 3914 93
2404763 2404763 2022-04-13 Young Texas 48503 3913 93
2401508 2401508 2022-04-12 Young Texas 48503 3913 93
2398253 2398253 2022-04-11 Young Texas 48503 3913 93
2394998 2394998 2022-04-10 Young Texas 48503 3913 93
2391742 2391742 2022-04-09 Young Texas 48503 3913 93
2388486 2388486 2022-04-08 Young Texas 48503 3912 92
2385231 2385231 2022-04-07 Young Texas 48503 3909 92
2381976 2381976 2022-04-06 Young Texas 48503 3907 90
2378721 2378721 2022-04-05 Young Texas 48503 3907 90
2375467 2375467 2022-04-04 Young Texas 48503 3907 90
2372215 2372215 2022-04-03 Young Texas 48503 3907 90
2368962 2368962 2022-04-02 Young Texas 48503 3907 90
2365709 2365709 2022-04-01 Young Texas 48503 3905 90
2362456 2362456 2022-03-31 Young Texas 48503 3903 90
2359202 2359202 2022-03-30 Young Texas 48503 3902 90
2355948 2355948 2022-03-29 Young Texas 48503 3900 90
2352695 2352695 2022-03-28 Young Texas 48503 3900 90
2349443 2349443 2022-03-27 Young Texas 48503 3900 90
2346190 2346190 2022-03-26 Young Texas 48503 3900 90
2342937 2342937 2022-03-25 Young Texas 48503 3899 90
2339684 2339684 2022-03-24 Young Texas 48503 3898 90
2336430 2336430 2022-03-23 Young Texas 48503 3898 90
2333176 2333176 2022-03-22 Young Texas 48503 3893 90
2329923 2329923 2022-03-21 Young Texas 48503 3891 89
2326671 2326671 2022-03-20 Young Texas 48503 3891 89
2323418 2323418 2022-03-19 Young Texas 48503 3890 89
2320164 2320164 2022-03-18 Young Texas 48503 3890 89
2316910 2316910 2022-03-17 Young Texas 48503 3890 89
2313657 2313657 2022-03-16 Young Texas 48503 3890 89
2310404 2310404 2022-03-15 Young Texas 48503 3890 89
2307151 2307151 2022-03-14 Young Texas 48503 3889 89
2303900 2303900 2022-03-13 Young Texas 48503 3889 89
2300648 2300648 2022-03-12 Young Texas 48503 3889 89
2297396 2297396 2022-03-11 Young Texas 48503 3889 89
2294144 2294144 2022-03-10 Young Texas 48503 3887 89
2290892 2290892 2022-03-09 Young Texas 48503 3887 89
2287640 2287640 2022-03-08 Young Texas 48503 3886 89
2284388 2284388 2022-03-07 Young Texas 48503 3885 89
2281136 2281136 2022-03-06 Young Texas 48503 3885 89
2277883 2277883 2022-03-05 Young Texas 48503 3885 89
2274630 2274630 2022-03-04 Young Texas 48503 3881 89
2271377 2271377 2022-03-03 Young Texas 48503 3879 88
2268125 2268125 2022-03-02 Young Texas 48503 3870 87
2264872 2264872 2022-03-01 Young Texas 48503 3866 87
2261622 2261622 2022-02-28 Young Texas 48503 3859 87
2258371 2258371 2022-02-27 Young Texas 48503 3859 87
2255120 2255120 2022-02-26 Young Texas 48503 3859 87
2251869 2251869 2022-02-25 Young Texas 48503 3857 87
2248618 2248618 2022-02-24 Young Texas 48503 3852 87
2245367 2245367 2022-02-23 Young Texas 48503 3849 86
2242116 2242116 2022-02-22 Young Texas 48503 3847 83
2238865 2238865 2022-02-21 Young Texas 48503 3847 83
2235614 2235614 2022-02-20 Young Texas 48503 3847 83
2232363 2232363 2022-02-19 Young Texas 48503 3847 83
2229112 2229112 2022-02-18 Young Texas 48503 3844 82
2225861 2225861 2022-02-17 Young Texas 48503 3832 82
2222610 2222610 2022-02-16 Young Texas 48503 3817 82
2219359 2219359 2022-02-15 Young Texas 48503 3807 82
2216108 2216108 2022-02-14 Young Texas 48503 3796 82
2212857 2212857 2022-02-13 Young Texas 48503 3795 82
2209604 2209604 2022-02-12 Young Texas 48503 3792 82
2206351 2206351 2022-02-11 Young Texas 48503 3782 82
2203098 2203098 2022-02-10 Young Texas 48503 3767 82
2199844 2199844 2022-02-09 Young Texas 48503 3746 82
2196590 2196590 2022-02-08 Young Texas 48503 3736 82
2193336 2193336 2022-02-07 Young Texas 48503 3726 82
2190083 2190083 2022-02-06 Young Texas 48503 3726 82
2186830 2186830 2022-02-05 Young Texas 48503 3725 82
2183577 2183577 2022-02-04 Young Texas 48503 3723 82
2180325 2180325 2022-02-03 Young Texas 48503 3713 82

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);