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

793 rows where county = "Yakima" and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington · 793 ✖

fips 1

county 1

  • Yakima · 793 ✖
Link rowid date ▲ county state fips cases deaths
2502682 2502682 2022-05-13 Yakima Washington 53077 73887 790
2499424 2499424 2022-05-12 Yakima Washington 53077 73738 790
2496166 2496166 2022-05-11 Yakima Washington 53077 73738 790
2492908 2492908 2022-05-10 Yakima Washington 53077 73738 789
2489650 2489650 2022-05-09 Yakima Washington 53077 73738 789
2486393 2486393 2022-05-08 Yakima Washington 53077 73738 789
2483135 2483135 2022-05-07 Yakima Washington 53077 73738 789
2479877 2479877 2022-05-06 Yakima Washington 53077 73738 789
2476619 2476619 2022-05-05 Yakima Washington 53077 73713 789
2473361 2473361 2022-05-04 Yakima Washington 53077 73699 789
2470104 2470104 2022-05-03 Yakima Washington 53077 73660 788
2466848 2466848 2022-05-02 Yakima Washington 53077 73660 788
2463593 2463593 2022-05-01 Yakima Washington 53077 73617 788
2460337 2460337 2022-04-30 Yakima Washington 53077 73617 788
2457081 2457081 2022-04-29 Yakima Washington 53077 73617 788
2453825 2453825 2022-04-28 Yakima Washington 53077 73593 788
2450569 2450569 2022-04-27 Yakima Washington 53077 73573 788
2447313 2447313 2022-04-26 Yakima Washington 53077 73544 787
2444057 2444057 2022-04-25 Yakima Washington 53077 73544 787
2440801 2440801 2022-04-24 Yakima Washington 53077 73492 784
2437545 2437545 2022-04-23 Yakima Washington 53077 73492 784
2434289 2434289 2022-04-22 Yakima Washington 53077 73492 784
2431033 2431033 2022-04-21 Yakima Washington 53077 73492 781
2427777 2427777 2022-04-20 Yakima Washington 53077 73480 781
2424521 2424521 2022-04-19 Yakima Washington 53077 73472 780
2421265 2421265 2022-04-18 Yakima Washington 53077 73424 780
2418009 2418009 2022-04-17 Yakima Washington 53077 73402 779
2414753 2414753 2022-04-16 Yakima Washington 53077 73402 779
2411497 2411497 2022-04-15 Yakima Washington 53077 73402 779
2408241 2408241 2022-04-14 Yakima Washington 53077 73395 777
2404985 2404985 2022-04-13 Yakima Washington 53077 73382 777
2401730 2401730 2022-04-12 Yakima Washington 53077 73378 776
2398475 2398475 2022-04-11 Yakima Washington 53077 73368 776
2395220 2395220 2022-04-10 Yakima Washington 53077 73355 776
2391964 2391964 2022-04-09 Yakima Washington 53077 73355 776
2388708 2388708 2022-04-08 Yakima Washington 53077 73355 776
2385453 2385453 2022-04-07 Yakima Washington 53077 73342 774
2382198 2382198 2022-04-06 Yakima Washington 53077 73342 774
2378943 2378943 2022-04-05 Yakima Washington 53077 73335 772
2375689 2375689 2022-04-04 Yakima Washington 53077 73331 772
2372437 2372437 2022-04-03 Yakima Washington 53077 73321 772
2369184 2369184 2022-04-02 Yakima Washington 53077 73321 772
2365931 2365931 2022-04-01 Yakima Washington 53077 73321 772
2362678 2362678 2022-03-31 Yakima Washington 53077 73311 772
2359424 2359424 2022-03-30 Yakima Washington 53077 73302 772
2356170 2356170 2022-03-29 Yakima Washington 53077 73291 770
2352917 2352917 2022-03-28 Yakima Washington 53077 73280 770
2349665 2349665 2022-03-27 Yakima Washington 53077 73269 768
2346412 2346412 2022-03-26 Yakima Washington 53077 73269 768
2343159 2343159 2022-03-25 Yakima Washington 53077 73269 768
2339906 2339906 2022-03-24 Yakima Washington 53077 73227 766
2336653 2336653 2022-03-23 Yakima Washington 53077 73227 766
2333399 2333399 2022-03-22 Yakima Washington 53077 73199 766
2330145 2330145 2022-03-21 Yakima Washington 53077 73151 766
2326893 2326893 2022-03-20 Yakima Washington 53077 73051 764
2323640 2323640 2022-03-19 Yakima Washington 53077 73051 764
2320386 2320386 2022-03-18 Yakima Washington 53077 73051 764
2317132 2317132 2022-03-17 Yakima Washington 53077 73025 762
2313879 2313879 2022-03-16 Yakima Washington 53077 72992 762
2310626 2310626 2022-03-15 Yakima Washington 53077 72931 761
2307373 2307373 2022-03-14 Yakima Washington 53077 72747 761
2304122 2304122 2022-03-13 Yakima Washington 53077 72747 758
2300870 2300870 2022-03-12 Yakima Washington 53077 72747 758
2297618 2297618 2022-03-11 Yakima Washington 53077 72747 758
2294366 2294366 2022-03-10 Yakima Washington 53077 72711 754
2291114 2291114 2022-03-09 Yakima Washington 53077 72664 754
2287862 2287862 2022-03-08 Yakima Washington 53077 72607 752
2284610 2284610 2022-03-07 Yakima Washington 53077 72574 752
2281358 2281358 2022-03-06 Yakima Washington 53077 72498 752
2278105 2278105 2022-03-05 Yakima Washington 53077 72498 752
2274852 2274852 2022-03-04 Yakima Washington 53077 72498 752
2271599 2271599 2022-03-03 Yakima Washington 53077 72440 749
2268347 2268347 2022-03-02 Yakima Washington 53077 72358 749
2265094 2265094 2022-03-01 Yakima Washington 53077 72286 747
2261844 2261844 2022-02-28 Yakima Washington 53077 72215 747
2258593 2258593 2022-02-27 Yakima Washington 53077 72075 745
2255342 2255342 2022-02-26 Yakima Washington 53077 72075 745
2252091 2252091 2022-02-25 Yakima Washington 53077 72075 745
2248840 2248840 2022-02-24 Yakima Washington 53077 71991 746
2245589 2245589 2022-02-23 Yakima Washington 53077 71904 746
2242338 2242338 2022-02-22 Yakima Washington 53077 71586 737
2239087 2239087 2022-02-21 Yakima Washington 53077 71586 737
2235836 2235836 2022-02-20 Yakima Washington 53077 71586 737
2232585 2232585 2022-02-19 Yakima Washington 53077 71586 737
2229334 2229334 2022-02-18 Yakima Washington 53077 71586 737
2226083 2226083 2022-02-17 Yakima Washington 53077 71480 731
2222832 2222832 2022-02-16 Yakima Washington 53077 71336 731
2219581 2219581 2022-02-15 Yakima Washington 53077 71143 725
2216331 2216331 2022-02-14 Yakima Washington 53077 70970 725
2213080 2213080 2022-02-13 Yakima Washington 53077 70581 720
2209827 2209827 2022-02-12 Yakima Washington 53077 70581 720
2206574 2206574 2022-02-11 Yakima Washington 53077 70581 720
2203321 2203321 2022-02-10 Yakima Washington 53077 69874 713
2200067 2200067 2022-02-09 Yakima Washington 53077 69874 713
2196813 2196813 2022-02-08 Yakima Washington 53077 69874 708
2193558 2193558 2022-02-07 Yakima Washington 53077 69678 708
2190305 2190305 2022-02-06 Yakima Washington 53077 69313 700
2187052 2187052 2022-02-05 Yakima Washington 53077 69313 700
2183799 2183799 2022-02-04 Yakima Washington 53077 69313 700
2180547 2180547 2022-02-03 Yakima Washington 53077 69172 687

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