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

794 rows where county = "Island" 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

county 1

  • Island · 794 ✖
Link rowid date ▲ county state fips cases deaths
2502657 2502657 2022-05-13 Island Washington 53029 10635 76
2499399 2499399 2022-05-12 Island Washington 53029 10569 76
2496141 2496141 2022-05-11 Island Washington 53029 10569 76
2492883 2492883 2022-05-10 Island Washington 53029 10525 76
2489625 2489625 2022-05-09 Island Washington 53029 10525 76
2486368 2486368 2022-05-08 Island Washington 53029 10457 76
2483110 2483110 2022-05-07 Island Washington 53029 10457 76
2479852 2479852 2022-05-06 Island Washington 53029 10457 76
2476594 2476594 2022-05-05 Island Washington 53029 10457 76
2473336 2473336 2022-05-04 Island Washington 53029 10457 76
2470080 2470080 2022-05-03 Island Washington 53029 10389 76
2466824 2466824 2022-05-02 Island Washington 53029 10389 76
2463569 2463569 2022-05-01 Island Washington 53029 10358 76
2460313 2460313 2022-04-30 Island Washington 53029 10358 76
2457057 2457057 2022-04-29 Island Washington 53029 10358 76
2453801 2453801 2022-04-28 Island Washington 53029 10308 76
2450545 2450545 2022-04-27 Island Washington 53029 10308 76
2447289 2447289 2022-04-26 Island Washington 53029 10258 76
2444033 2444033 2022-04-25 Island Washington 53029 10258 76
2440777 2440777 2022-04-24 Island Washington 53029 10206 76
2437521 2437521 2022-04-23 Island Washington 53029 10206 76
2434265 2434265 2022-04-22 Island Washington 53029 10206 76
2431009 2431009 2022-04-21 Island Washington 53029 10175 76
2427753 2427753 2022-04-20 Island Washington 53029 10175 76
2424497 2424497 2022-04-19 Island Washington 53029 10145 75
2421241 2421241 2022-04-18 Island Washington 53029 10145 75
2417985 2417985 2022-04-17 Island Washington 53029 10090 75
2414729 2414729 2022-04-16 Island Washington 53029 10090 75
2411473 2411473 2022-04-15 Island Washington 53029 10090 75
2408217 2408217 2022-04-14 Island Washington 53029 10068 75
2404961 2404961 2022-04-13 Island Washington 53029 10068 75
2401706 2401706 2022-04-12 Island Washington 53029 10021 75
2398451 2398451 2022-04-11 Island Washington 53029 10021 75
2395196 2395196 2022-04-10 Island Washington 53029 10021 75
2391940 2391940 2022-04-09 Island Washington 53029 10021 75
2388684 2388684 2022-04-08 Island Washington 53029 10021 75
2385429 2385429 2022-04-07 Island Washington 53029 10008 75
2382174 2382174 2022-04-06 Island Washington 53029 10008 75
2378919 2378919 2022-04-05 Island Washington 53029 9990 75
2375665 2375665 2022-04-04 Island Washington 53029 9990 75
2372413 2372413 2022-04-03 Island Washington 53029 9976 75
2369160 2369160 2022-04-02 Island Washington 53029 9976 75
2365907 2365907 2022-04-01 Island Washington 53029 9976 75
2362654 2362654 2022-03-31 Island Washington 53029 9974 74
2359400 2359400 2022-03-30 Island Washington 53029 9974 74
2356146 2356146 2022-03-29 Island Washington 53029 9970 74
2352893 2352893 2022-03-28 Island Washington 53029 9970 74
2349641 2349641 2022-03-27 Island Washington 53029 9963 74
2346388 2346388 2022-03-26 Island Washington 53029 9963 74
2343135 2343135 2022-03-25 Island Washington 53029 9963 74
2339882 2339882 2022-03-24 Island Washington 53029 9950 73
2336629 2336629 2022-03-23 Island Washington 53029 9950 73
2333375 2333375 2022-03-22 Island Washington 53029 9938 73
2330121 2330121 2022-03-21 Island Washington 53029 9938 73
2326869 2326869 2022-03-20 Island Washington 53029 9927 73
2323616 2323616 2022-03-19 Island Washington 53029 9927 73
2320362 2320362 2022-03-18 Island Washington 53029 9927 73
2317108 2317108 2022-03-17 Island Washington 53029 9896 72
2313855 2313855 2022-03-16 Island Washington 53029 9896 72
2310602 2310602 2022-03-15 Island Washington 53029 9872 71
2307349 2307349 2022-03-14 Island Washington 53029 9872 71
2304098 2304098 2022-03-13 Island Washington 53029 9843 71
2300846 2300846 2022-03-12 Island Washington 53029 9843 71
2297594 2297594 2022-03-11 Island Washington 53029 9843 71
2294342 2294342 2022-03-10 Island Washington 53029 9824 71
2291090 2291090 2022-03-09 Island Washington 53029 9824 71
2287838 2287838 2022-03-08 Island Washington 53029 9817 70
2284586 2284586 2022-03-07 Island Washington 53029 9817 70
2281334 2281334 2022-03-06 Island Washington 53029 9795 70
2278081 2278081 2022-03-05 Island Washington 53029 9795 70
2274828 2274828 2022-03-04 Island Washington 53029 9795 70
2271575 2271575 2022-03-03 Island Washington 53029 9787 68
2268323 2268323 2022-03-02 Island Washington 53029 9787 68
2265070 2265070 2022-03-01 Island Washington 53029 9762 68
2261820 2261820 2022-02-28 Island Washington 53029 9762 68
2258569 2258569 2022-02-27 Island Washington 53029 9741 68
2255318 2255318 2022-02-26 Island Washington 53029 9741 68
2252067 2252067 2022-02-25 Island Washington 53029 9741 68
2248816 2248816 2022-02-24 Island Washington 53029 9741 66
2245565 2245565 2022-02-23 Island Washington 53029 9741 66
2242314 2242314 2022-02-22 Island Washington 53029 9649 66
2239063 2239063 2022-02-21 Island Washington 53029 9649 66
2235812 2235812 2022-02-20 Island Washington 53029 9649 66
2232561 2232561 2022-02-19 Island Washington 53029 9649 66
2229310 2229310 2022-02-18 Island Washington 53029 9649 66
2226059 2226059 2022-02-17 Island Washington 53029 9656 65
2222808 2222808 2022-02-16 Island Washington 53029 9656 65
2219557 2219557 2022-02-15 Island Washington 53029 9648 65
2216307 2216307 2022-02-14 Island Washington 53029 9648 65
2213056 2213056 2022-02-13 Island Washington 53029 9601 64
2209803 2209803 2022-02-12 Island Washington 53029 9601 64
2206550 2206550 2022-02-11 Island Washington 53029 9601 64
2203297 2203297 2022-02-10 Island Washington 53029 9440 63
2200043 2200043 2022-02-09 Island Washington 53029 9440 63
2196789 2196789 2022-02-08 Island Washington 53029 9352 61
2193534 2193534 2022-02-07 Island Washington 53029 9352 61
2190281 2190281 2022-02-06 Island Washington 53029 9226 60
2187028 2187028 2022-02-05 Island Washington 53029 9226 60
2183775 2183775 2022-02-04 Island Washington 53029 9226 60
2180523 2180523 2022-02-03 Island Washington 53029 9126 60

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