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 = "Jefferson", fips = 53031 and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Washington · 799 ✖

fips 1

  • 53031 · 799 ✖

county 1

  • Jefferson · 799 ✖
Link rowid date ▲ county state fips cases deaths
2502658 2502658 2022-05-13 Jefferson Washington 53031 3198 29
2499400 2499400 2022-05-12 Jefferson Washington 53031 3180 29
2496142 2496142 2022-05-11 Jefferson Washington 53031 3180 29
2492884 2492884 2022-05-10 Jefferson Washington 53031 3159 28
2489626 2489626 2022-05-09 Jefferson Washington 53031 3159 28
2486369 2486369 2022-05-08 Jefferson Washington 53031 3124 28
2483111 2483111 2022-05-07 Jefferson Washington 53031 3124 28
2479853 2479853 2022-05-06 Jefferson Washington 53031 3124 28
2476595 2476595 2022-05-05 Jefferson Washington 53031 3124 28
2473337 2473337 2022-05-04 Jefferson Washington 53031 3124 28
2470081 2470081 2022-05-03 Jefferson Washington 53031 3089 28
2466825 2466825 2022-05-02 Jefferson Washington 53031 3089 28
2463570 2463570 2022-05-01 Jefferson Washington 53031 3074 28
2460314 2460314 2022-04-30 Jefferson Washington 53031 3074 28
2457058 2457058 2022-04-29 Jefferson Washington 53031 3074 28
2453802 2453802 2022-04-28 Jefferson Washington 53031 3060 28
2450546 2450546 2022-04-27 Jefferson Washington 53031 3060 28
2447290 2447290 2022-04-26 Jefferson Washington 53031 3047 28
2444034 2444034 2022-04-25 Jefferson Washington 53031 3047 28
2440778 2440778 2022-04-24 Jefferson Washington 53031 3022 28
2437522 2437522 2022-04-23 Jefferson Washington 53031 3022 28
2434266 2434266 2022-04-22 Jefferson Washington 53031 3022 28
2431010 2431010 2022-04-21 Jefferson Washington 53031 3010 28
2427754 2427754 2022-04-20 Jefferson Washington 53031 3010 28
2424498 2424498 2022-04-19 Jefferson Washington 53031 3010 28
2421242 2421242 2022-04-18 Jefferson Washington 53031 3010 28
2417986 2417986 2022-04-17 Jefferson Washington 53031 2992 28
2414730 2414730 2022-04-16 Jefferson Washington 53031 2992 28
2411474 2411474 2022-04-15 Jefferson Washington 53031 2992 28
2408218 2408218 2022-04-14 Jefferson Washington 53031 2977 28
2404962 2404962 2022-04-13 Jefferson Washington 53031 2977 28
2401707 2401707 2022-04-12 Jefferson Washington 53031 2959 28
2398452 2398452 2022-04-11 Jefferson Washington 53031 2959 28
2395197 2395197 2022-04-10 Jefferson Washington 53031 2959 28
2391941 2391941 2022-04-09 Jefferson Washington 53031 2959 28
2388685 2388685 2022-04-08 Jefferson Washington 53031 2959 28
2385430 2385430 2022-04-07 Jefferson Washington 53031 2953 28
2382175 2382175 2022-04-06 Jefferson Washington 53031 2953 28
2378920 2378920 2022-04-05 Jefferson Washington 53031 2949 28
2375666 2375666 2022-04-04 Jefferson Washington 53031 2949 28
2372414 2372414 2022-04-03 Jefferson Washington 53031 2947 28
2369161 2369161 2022-04-02 Jefferson Washington 53031 2947 28
2365908 2365908 2022-04-01 Jefferson Washington 53031 2947 28
2362655 2362655 2022-03-31 Jefferson Washington 53031 2944 28
2359401 2359401 2022-03-30 Jefferson Washington 53031 2944 28
2356147 2356147 2022-03-29 Jefferson Washington 53031 2939 28
2352894 2352894 2022-03-28 Jefferson Washington 53031 2939 28
2349642 2349642 2022-03-27 Jefferson Washington 53031 2934 28
2346389 2346389 2022-03-26 Jefferson Washington 53031 2934 28
2343136 2343136 2022-03-25 Jefferson Washington 53031 2934 28
2339883 2339883 2022-03-24 Jefferson Washington 53031 2925 28
2336630 2336630 2022-03-23 Jefferson Washington 53031 2925 28
2333376 2333376 2022-03-22 Jefferson Washington 53031 2917 28
2330122 2330122 2022-03-21 Jefferson Washington 53031 2917 28
2326870 2326870 2022-03-20 Jefferson Washington 53031 2921 28
2323617 2323617 2022-03-19 Jefferson Washington 53031 2921 28
2320363 2320363 2022-03-18 Jefferson Washington 53031 2921 28
2317109 2317109 2022-03-17 Jefferson Washington 53031 2914 28
2313856 2313856 2022-03-16 Jefferson Washington 53031 2914 28
2310603 2310603 2022-03-15 Jefferson Washington 53031 2912 28
2307350 2307350 2022-03-14 Jefferson Washington 53031 2912 28
2304099 2304099 2022-03-13 Jefferson Washington 53031 2911 28
2300847 2300847 2022-03-12 Jefferson Washington 53031 2911 28
2297595 2297595 2022-03-11 Jefferson Washington 53031 2911 28
2294343 2294343 2022-03-10 Jefferson Washington 53031 2897 28
2291091 2291091 2022-03-09 Jefferson Washington 53031 2897 28
2287839 2287839 2022-03-08 Jefferson Washington 53031 2877 28
2284587 2284587 2022-03-07 Jefferson Washington 53031 2877 28
2281335 2281335 2022-03-06 Jefferson Washington 53031 2870 28
2278082 2278082 2022-03-05 Jefferson Washington 53031 2870 28
2274829 2274829 2022-03-04 Jefferson Washington 53031 2870 28
2271576 2271576 2022-03-03 Jefferson Washington 53031 2863 27
2268324 2268324 2022-03-02 Jefferson Washington 53031 2863 27
2265071 2265071 2022-03-01 Jefferson Washington 53031 2854 27
2261821 2261821 2022-02-28 Jefferson Washington 53031 2854 27
2258570 2258570 2022-02-27 Jefferson Washington 53031 2831 27
2255319 2255319 2022-02-26 Jefferson Washington 53031 2831 27
2252068 2252068 2022-02-25 Jefferson Washington 53031 2831 27
2248817 2248817 2022-02-24 Jefferson Washington 53031 2831 25
2245566 2245566 2022-02-23 Jefferson Washington 53031 2831 25
2242315 2242315 2022-02-22 Jefferson Washington 53031 2788 25
2239064 2239064 2022-02-21 Jefferson Washington 53031 2788 25
2235813 2235813 2022-02-20 Jefferson Washington 53031 2788 25
2232562 2232562 2022-02-19 Jefferson Washington 53031 2788 25
2229311 2229311 2022-02-18 Jefferson Washington 53031 2788 25
2226060 2226060 2022-02-17 Jefferson Washington 53031 2793 25
2222809 2222809 2022-02-16 Jefferson Washington 53031 2793 25
2219558 2219558 2022-02-15 Jefferson Washington 53031 2781 24
2216308 2216308 2022-02-14 Jefferson Washington 53031 2781 24
2213057 2213057 2022-02-13 Jefferson Washington 53031 2745 24
2209804 2209804 2022-02-12 Jefferson Washington 53031 2745 24
2206551 2206551 2022-02-11 Jefferson Washington 53031 2745 24
2203298 2203298 2022-02-10 Jefferson Washington 53031 2683 24
2200044 2200044 2022-02-09 Jefferson Washington 53031 2683 24
2196790 2196790 2022-02-08 Jefferson Washington 53031 2662 24
2193535 2193535 2022-02-07 Jefferson Washington 53031 2662 24
2190282 2190282 2022-02-06 Jefferson Washington 53031 2621 23
2187029 2187029 2022-02-05 Jefferson Washington 53031 2621 23
2183776 2183776 2022-02-04 Jefferson Washington 53031 2621 23
2180524 2180524 2022-02-03 Jefferson Washington 53031 2587 23

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