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

721 rows where county = "Ward" 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 · 721 ✖

fips 1

county 1

  • Ward · 721 ✖
Link rowid date ▲ county state fips cases deaths
2502445 2502445 2022-05-13 Ward Texas 48475 2830 44
2499187 2499187 2022-05-12 Ward Texas 48475 2830 44
2495929 2495929 2022-05-11 Ward Texas 48475 2829 44
2492671 2492671 2022-05-10 Ward Texas 48475 2829 44
2489413 2489413 2022-05-09 Ward Texas 48475 2829 43
2486155 2486155 2022-05-08 Ward Texas 48475 2829 43
2482897 2482897 2022-05-07 Ward Texas 48475 2829 43
2479639 2479639 2022-05-06 Ward Texas 48475 2829 43
2476381 2476381 2022-05-05 Ward Texas 48475 2829 43
2473124 2473124 2022-05-04 Ward Texas 48475 2829 43
2469868 2469868 2022-05-03 Ward Texas 48475 2829 43
2466612 2466612 2022-05-02 Ward Texas 48475 2829 43
2463357 2463357 2022-05-01 Ward Texas 48475 2829 43
2460101 2460101 2022-04-30 Ward Texas 48475 2829 43
2456845 2456845 2022-04-29 Ward Texas 48475 2829 43
2453589 2453589 2022-04-28 Ward Texas 48475 2829 43
2450333 2450333 2022-04-27 Ward Texas 48475 2828 43
2447076 2447076 2022-04-26 Ward Texas 48475 2828 43
2443821 2443821 2022-04-25 Ward Texas 48475 2828 43
2440565 2440565 2022-04-24 Ward Texas 48475 2828 43
2437309 2437309 2022-04-23 Ward Texas 48475 2828 43
2434053 2434053 2022-04-22 Ward Texas 48475 2828 43
2430797 2430797 2022-04-21 Ward Texas 48475 2828 43
2427541 2427541 2022-04-20 Ward Texas 48475 2827 43
2424285 2424285 2022-04-19 Ward Texas 48475 2827 43
2421029 2421029 2022-04-18 Ward Texas 48475 2827 43
2417773 2417773 2022-04-17 Ward Texas 48475 2822 43
2414517 2414517 2022-04-16 Ward Texas 48475 2822 43
2411261 2411261 2022-04-15 Ward Texas 48475 2822 43
2408005 2408005 2022-04-14 Ward Texas 48475 2822 43
2404749 2404749 2022-04-13 Ward Texas 48475 2822 43
2401494 2401494 2022-04-12 Ward Texas 48475 2822 43
2398239 2398239 2022-04-11 Ward Texas 48475 2821 43
2394984 2394984 2022-04-10 Ward Texas 48475 2821 43
2391728 2391728 2022-04-09 Ward Texas 48475 2820 43
2388472 2388472 2022-04-08 Ward Texas 48475 2820 43
2385217 2385217 2022-04-07 Ward Texas 48475 2819 43
2381962 2381962 2022-04-06 Ward Texas 48475 2818 43
2378707 2378707 2022-04-05 Ward Texas 48475 2818 43
2375453 2375453 2022-04-04 Ward Texas 48475 2818 43
2372201 2372201 2022-04-03 Ward Texas 48475 2818 43
2368948 2368948 2022-04-02 Ward Texas 48475 2818 43
2365695 2365695 2022-04-01 Ward Texas 48475 2818 43
2362442 2362442 2022-03-31 Ward Texas 48475 2818 43
2359188 2359188 2022-03-30 Ward Texas 48475 2818 43
2355934 2355934 2022-03-29 Ward Texas 48475 2818 43
2352681 2352681 2022-03-28 Ward Texas 48475 2818 43
2349429 2349429 2022-03-27 Ward Texas 48475 2817 43
2346176 2346176 2022-03-26 Ward Texas 48475 2817 43
2342923 2342923 2022-03-25 Ward Texas 48475 2815 43
2339670 2339670 2022-03-24 Ward Texas 48475 2810 43
2336416 2336416 2022-03-23 Ward Texas 48475 2810 43
2333162 2333162 2022-03-22 Ward Texas 48475 2810 43
2329909 2329909 2022-03-21 Ward Texas 48475 2810 43
2326657 2326657 2022-03-20 Ward Texas 48475 2810 43
2323404 2323404 2022-03-19 Ward Texas 48475 2810 43
2320150 2320150 2022-03-18 Ward Texas 48475 2809 43
2316896 2316896 2022-03-17 Ward Texas 48475 2805 43
2313643 2313643 2022-03-16 Ward Texas 48475 2804 43
2310390 2310390 2022-03-15 Ward Texas 48475 2804 43
2307137 2307137 2022-03-14 Ward Texas 48475 2804 43
2303886 2303886 2022-03-13 Ward Texas 48475 2804 43
2300634 2300634 2022-03-12 Ward Texas 48475 2804 43
2297382 2297382 2022-03-11 Ward Texas 48475 2804 43
2294130 2294130 2022-03-10 Ward Texas 48475 2804 43
2290878 2290878 2022-03-09 Ward Texas 48475 2804 43
2287626 2287626 2022-03-08 Ward Texas 48475 2804 43
2284374 2284374 2022-03-07 Ward Texas 48475 2804 43
2281122 2281122 2022-03-06 Ward Texas 48475 2803 43
2277869 2277869 2022-03-05 Ward Texas 48475 2803 43
2274616 2274616 2022-03-04 Ward Texas 48475 2801 43
2271363 2271363 2022-03-03 Ward Texas 48475 2801 43
2268111 2268111 2022-03-02 Ward Texas 48475 2800 43
2264858 2264858 2022-03-01 Ward Texas 48475 2800 43
2261608 2261608 2022-02-28 Ward Texas 48475 2799 43
2258357 2258357 2022-02-27 Ward Texas 48475 2799 43
2255106 2255106 2022-02-26 Ward Texas 48475 2799 43
2251855 2251855 2022-02-25 Ward Texas 48475 2798 43
2248604 2248604 2022-02-24 Ward Texas 48475 2796 43
2245353 2245353 2022-02-23 Ward Texas 48475 2791 43
2242102 2242102 2022-02-22 Ward Texas 48475 2787 42
2238851 2238851 2022-02-21 Ward Texas 48475 2782 42
2235600 2235600 2022-02-20 Ward Texas 48475 2780 42
2232349 2232349 2022-02-19 Ward Texas 48475 2780 42
2229098 2229098 2022-02-18 Ward Texas 48475 2769 42
2225847 2225847 2022-02-17 Ward Texas 48475 2765 42
2222596 2222596 2022-02-16 Ward Texas 48475 2756 42
2219345 2219345 2022-02-15 Ward Texas 48475 2743 42
2216094 2216094 2022-02-14 Ward Texas 48475 2737 42
2212843 2212843 2022-02-13 Ward Texas 48475 2737 42
2209590 2209590 2022-02-12 Ward Texas 48475 2735 42
2206337 2206337 2022-02-11 Ward Texas 48475 2726 42
2203084 2203084 2022-02-10 Ward Texas 48475 2717 42
2199830 2199830 2022-02-09 Ward Texas 48475 2711 42
2196576 2196576 2022-02-08 Ward Texas 48475 2703 42
2193322 2193322 2022-02-07 Ward Texas 48475 2695 41
2190069 2190069 2022-02-06 Ward Texas 48475 2693 41
2186816 2186816 2022-02-05 Ward Texas 48475 2693 41
2183563 2183563 2022-02-04 Ward Texas 48475 2682 39
2180311 2180311 2022-02-03 Ward Texas 48475 2662 39

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