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

799 rows where county = "Clark" and fips = 53011 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 53011 · 799 ✖

county 1

  • Clark · 799 ✖
Link rowid date ▲ county state fips cases deaths
2502648 2502648 2022-05-13 Clark Washington 53011 91435 804
2499390 2499390 2022-05-12 Clark Washington 53011 91106 801
2496132 2496132 2022-05-11 Clark Washington 53011 91106 801
2492874 2492874 2022-05-10 Clark Washington 53011 90793 800
2489616 2489616 2022-05-09 Clark Washington 53011 90793 800
2486359 2486359 2022-05-08 Clark Washington 53011 90331 799
2483101 2483101 2022-05-07 Clark Washington 53011 90331 799
2479843 2479843 2022-05-06 Clark Washington 53011 90331 799
2476585 2476585 2022-05-05 Clark Washington 53011 90331 799
2473327 2473327 2022-05-04 Clark Washington 53011 90331 799
2470071 2470071 2022-05-03 Clark Washington 53011 90239 797
2466815 2466815 2022-05-02 Clark Washington 53011 90239 797
2463560 2463560 2022-05-01 Clark Washington 53011 89789 797
2460304 2460304 2022-04-30 Clark Washington 53011 89789 797
2457048 2457048 2022-04-29 Clark Washington 53011 89789 797
2453792 2453792 2022-04-28 Clark Washington 53011 89553 796
2450536 2450536 2022-04-27 Clark Washington 53011 89553 796
2447280 2447280 2022-04-26 Clark Washington 53011 89279 796
2444024 2444024 2022-04-25 Clark Washington 53011 89279 796
2440768 2440768 2022-04-24 Clark Washington 53011 89106 795
2437512 2437512 2022-04-23 Clark Washington 53011 89106 795
2434256 2434256 2022-04-22 Clark Washington 53011 89106 795
2431000 2431000 2022-04-21 Clark Washington 53011 88947 795
2427744 2427744 2022-04-20 Clark Washington 53011 88947 795
2424488 2424488 2022-04-19 Clark Washington 53011 88802 794
2421232 2421232 2022-04-18 Clark Washington 53011 88802 794
2417976 2417976 2022-04-17 Clark Washington 53011 88711 794
2414720 2414720 2022-04-16 Clark Washington 53011 88711 794
2411464 2411464 2022-04-15 Clark Washington 53011 88711 794
2408208 2408208 2022-04-14 Clark Washington 53011 88620 795
2404952 2404952 2022-04-13 Clark Washington 53011 88620 795
2401697 2401697 2022-04-12 Clark Washington 53011 88485 794
2398442 2398442 2022-04-11 Clark Washington 53011 88485 794
2395187 2395187 2022-04-10 Clark Washington 53011 88485 794
2391931 2391931 2022-04-09 Clark Washington 53011 88485 794
2388675 2388675 2022-04-08 Clark Washington 53011 88485 794
2385420 2385420 2022-04-07 Clark Washington 53011 88415 794
2382165 2382165 2022-04-06 Clark Washington 53011 88415 794
2378910 2378910 2022-04-05 Clark Washington 53011 88099 791
2375656 2375656 2022-04-04 Clark Washington 53011 88099 791
2372404 2372404 2022-04-03 Clark Washington 53011 88066 791
2369151 2369151 2022-04-02 Clark Washington 53011 88066 791
2365898 2365898 2022-04-01 Clark Washington 53011 88066 791
2362645 2362645 2022-03-31 Clark Washington 53011 88033 789
2359391 2359391 2022-03-30 Clark Washington 53011 88033 789
2356137 2356137 2022-03-29 Clark Washington 53011 87955 787
2352884 2352884 2022-03-28 Clark Washington 53011 87955 787
2349632 2349632 2022-03-27 Clark Washington 53011 87913 785
2346379 2346379 2022-03-26 Clark Washington 53011 87913 785
2343126 2343126 2022-03-25 Clark Washington 53011 87913 785
2339873 2339873 2022-03-24 Clark Washington 53011 87608 782
2336620 2336620 2022-03-23 Clark Washington 53011 87608 782
2333366 2333366 2022-03-22 Clark Washington 53011 87198 782
2330112 2330112 2022-03-21 Clark Washington 53011 87198 782
2326860 2326860 2022-03-20 Clark Washington 53011 87115 781
2323607 2323607 2022-03-19 Clark Washington 53011 87115 781
2320353 2320353 2022-03-18 Clark Washington 53011 87115 781
2317099 2317099 2022-03-17 Clark Washington 53011 86869 778
2313846 2313846 2022-03-16 Clark Washington 53011 86869 778
2310593 2310593 2022-03-15 Clark Washington 53011 86514 774
2307340 2307340 2022-03-14 Clark Washington 53011 86514 774
2304089 2304089 2022-03-13 Clark Washington 53011 86324 771
2300837 2300837 2022-03-12 Clark Washington 53011 86324 771
2297585 2297585 2022-03-11 Clark Washington 53011 86324 771
2294333 2294333 2022-03-10 Clark Washington 53011 85592 768
2291081 2291081 2022-03-09 Clark Washington 53011 85592 768
2287829 2287829 2022-03-08 Clark Washington 53011 85083 765
2284577 2284577 2022-03-07 Clark Washington 53011 85083 765
2281325 2281325 2022-03-06 Clark Washington 53011 84903 759
2278072 2278072 2022-03-05 Clark Washington 53011 84903 759
2274819 2274819 2022-03-04 Clark Washington 53011 84903 759
2271566 2271566 2022-03-03 Clark Washington 53011 84402 754
2268314 2268314 2022-03-02 Clark Washington 53011 84402 754
2265061 2265061 2022-03-01 Clark Washington 53011 83863 744
2261811 2261811 2022-02-28 Clark Washington 53011 83863 744
2258560 2258560 2022-02-27 Clark Washington 53011 83776 743
2255309 2255309 2022-02-26 Clark Washington 53011 83776 743
2252058 2252058 2022-02-25 Clark Washington 53011 83776 743
2248807 2248807 2022-02-24 Clark Washington 53011 83578 740
2245556 2245556 2022-02-23 Clark Washington 53011 83578 740
2242305 2242305 2022-02-22 Clark Washington 53011 83235 734
2239054 2239054 2022-02-21 Clark Washington 53011 83235 734
2235803 2235803 2022-02-20 Clark Washington 53011 83235 734
2232552 2232552 2022-02-19 Clark Washington 53011 83235 734
2229301 2229301 2022-02-18 Clark Washington 53011 83235 734
2226050 2226050 2022-02-17 Clark Washington 53011 82885 730
2222799 2222799 2022-02-16 Clark Washington 53011 82885 730
2219548 2219548 2022-02-15 Clark Washington 53011 82426 718
2216298 2216298 2022-02-14 Clark Washington 53011 82426 718
2213047 2213047 2022-02-13 Clark Washington 53011 81937 718
2209794 2209794 2022-02-12 Clark Washington 53011 81937 718
2206541 2206541 2022-02-11 Clark Washington 53011 81937 718
2203288 2203288 2022-02-10 Clark Washington 53011 80586 712
2200034 2200034 2022-02-09 Clark Washington 53011 80586 712
2196780 2196780 2022-02-08 Clark Washington 53011 79607 708
2193525 2193525 2022-02-07 Clark Washington 53011 79607 708
2190272 2190272 2022-02-06 Clark Washington 53011 78248 701
2187019 2187019 2022-02-05 Clark Washington 53011 78248 701
2183766 2183766 2022-02-04 Clark Washington 53011 78248 701
2180514 2180514 2022-02-03 Clark Washington 53011 77195 692

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