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

780 rows where fips = 56001 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

  • 56001 · 780 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502810 2502810 2022-05-13 Albany Wyoming 56001 9934 49
2499552 2499552 2022-05-12 Albany Wyoming 56001 9934 49
2496294 2496294 2022-05-11 Albany Wyoming 56001 9934 49
2493036 2493036 2022-05-10 Albany Wyoming 56001 9934 49
2489778 2489778 2022-05-09 Albany Wyoming 56001 9914 49
2486521 2486521 2022-05-08 Albany Wyoming 56001 9914 49
2483263 2483263 2022-05-07 Albany Wyoming 56001 9914 49
2480005 2480005 2022-05-06 Albany Wyoming 56001 9914 49
2476747 2476747 2022-05-05 Albany Wyoming 56001 9914 49
2473489 2473489 2022-05-04 Albany Wyoming 56001 9914 49
2470232 2470232 2022-05-03 Albany Wyoming 56001 9914 49
2466976 2466976 2022-05-02 Albany Wyoming 56001 9905 48
2463721 2463721 2022-05-01 Albany Wyoming 56001 9905 48
2460465 2460465 2022-04-30 Albany Wyoming 56001 9905 48
2457209 2457209 2022-04-29 Albany Wyoming 56001 9905 48
2453953 2453953 2022-04-28 Albany Wyoming 56001 9905 48
2450697 2450697 2022-04-27 Albany Wyoming 56001 9905 48
2447441 2447441 2022-04-26 Albany Wyoming 56001 9905 48
2444185 2444185 2022-04-25 Albany Wyoming 56001 9894 48
2440929 2440929 2022-04-24 Albany Wyoming 56001 9894 48
2437673 2437673 2022-04-23 Albany Wyoming 56001 9894 48
2434417 2434417 2022-04-22 Albany Wyoming 56001 9894 48
2431161 2431161 2022-04-21 Albany Wyoming 56001 9894 48
2427905 2427905 2022-04-20 Albany Wyoming 56001 9894 48
2424649 2424649 2022-04-19 Albany Wyoming 56001 9894 48
2421393 2421393 2022-04-18 Albany Wyoming 56001 9880 48
2418137 2418137 2022-04-17 Albany Wyoming 56001 9880 48
2414881 2414881 2022-04-16 Albany Wyoming 56001 9880 48
2411625 2411625 2022-04-15 Albany Wyoming 56001 9880 48
2408369 2408369 2022-04-14 Albany Wyoming 56001 9880 48
2405113 2405113 2022-04-13 Albany Wyoming 56001 9880 48
2401858 2401858 2022-04-12 Albany Wyoming 56001 9880 48
2398603 2398603 2022-04-11 Albany Wyoming 56001 9885 48
2395348 2395348 2022-04-10 Albany Wyoming 56001 9885 48
2392092 2392092 2022-04-09 Albany Wyoming 56001 9885 48
2388836 2388836 2022-04-08 Albany Wyoming 56001 9885 48
2385581 2385581 2022-04-07 Albany Wyoming 56001 9883 48
2382326 2382326 2022-04-06 Albany Wyoming 56001 9883 48
2379071 2379071 2022-04-05 Albany Wyoming 56001 9883 48
2375817 2375817 2022-04-04 Albany Wyoming 56001 9878 48
2372565 2372565 2022-04-03 Albany Wyoming 56001 9878 48
2369312 2369312 2022-04-02 Albany Wyoming 56001 9878 48
2366059 2366059 2022-04-01 Albany Wyoming 56001 9878 48
2362806 2362806 2022-03-31 Albany Wyoming 56001 9873 48
2359552 2359552 2022-03-30 Albany Wyoming 56001 9873 48
2356298 2356298 2022-03-29 Albany Wyoming 56001 9873 48
2353045 2353045 2022-03-28 Albany Wyoming 56001 9869 48
2349793 2349793 2022-03-27 Albany Wyoming 56001 9869 48
2346540 2346540 2022-03-26 Albany Wyoming 56001 9869 48
2343287 2343287 2022-03-25 Albany Wyoming 56001 9869 48
2340034 2340034 2022-03-24 Albany Wyoming 56001 9856 48
2336781 2336781 2022-03-23 Albany Wyoming 56001 9856 48
2333527 2333527 2022-03-22 Albany Wyoming 56001 9856 48
2330273 2330273 2022-03-21 Albany Wyoming 56001 9852 48
2327021 2327021 2022-03-20 Albany Wyoming 56001 9852 48
2323768 2323768 2022-03-19 Albany Wyoming 56001 9852 48
2320514 2320514 2022-03-18 Albany Wyoming 56001 9852 48
2317260 2317260 2022-03-17 Albany Wyoming 56001 9847 48
2314007 2314007 2022-03-16 Albany Wyoming 56001 9847 48
2310754 2310754 2022-03-15 Albany Wyoming 56001 9847 48
2307501 2307501 2022-03-14 Albany Wyoming 56001 9846 47
2304250 2304250 2022-03-13 Albany Wyoming 56001 9846 47
2300998 2300998 2022-03-12 Albany Wyoming 56001 9846 47
2297746 2297746 2022-03-11 Albany Wyoming 56001 9846 47
2294494 2294494 2022-03-10 Albany Wyoming 56001 9845 47
2291242 2291242 2022-03-09 Albany Wyoming 56001 9835 47
2287990 2287990 2022-03-08 Albany Wyoming 56001 9833 47
2284738 2284738 2022-03-07 Albany Wyoming 56001 9831 47
2281486 2281486 2022-03-06 Albany Wyoming 56001 9827 47
2278233 2278233 2022-03-05 Albany Wyoming 56001 9827 47
2274980 2274980 2022-03-04 Albany Wyoming 56001 9827 47
2271727 2271727 2022-03-03 Albany Wyoming 56001 9825 47
2268475 2268475 2022-03-02 Albany Wyoming 56001 9818 47
2265222 2265222 2022-03-01 Albany Wyoming 56001 9811 47
2261972 2261972 2022-02-28 Albany Wyoming 56001 9808 47
2258721 2258721 2022-02-27 Albany Wyoming 56001 9797 47
2255470 2255470 2022-02-26 Albany Wyoming 56001 9797 47
2252219 2252219 2022-02-25 Albany Wyoming 56001 9797 47
2248968 2248968 2022-02-24 Albany Wyoming 56001 9787 47
2245717 2245717 2022-02-23 Albany Wyoming 56001 9782 47
2242466 2242466 2022-02-22 Albany Wyoming 56001 9773 47
2239215 2239215 2022-02-21 Albany Wyoming 56001 9757 45
2235964 2235964 2022-02-20 Albany Wyoming 56001 9757 45
2232713 2232713 2022-02-19 Albany Wyoming 56001 9757 45
2229462 2229462 2022-02-18 Albany Wyoming 56001 9757 45
2226211 2226211 2022-02-17 Albany Wyoming 56001 9750 45
2222960 2222960 2022-02-16 Albany Wyoming 56001 9741 45
2219709 2219709 2022-02-15 Albany Wyoming 56001 9720 45
2216459 2216459 2022-02-14 Albany Wyoming 56001 9712 45
2213208 2213208 2022-02-13 Albany Wyoming 56001 9691 45
2209955 2209955 2022-02-12 Albany Wyoming 56001 9691 45
2206702 2206702 2022-02-11 Albany Wyoming 56001 9691 45
2203449 2203449 2022-02-10 Albany Wyoming 56001 9669 45
2200195 2200195 2022-02-09 Albany Wyoming 56001 9644 45
2196941 2196941 2022-02-08 Albany Wyoming 56001 9607 45
2193686 2193686 2022-02-07 Albany Wyoming 56001 9595 45
2190433 2190433 2022-02-06 Albany Wyoming 56001 9561 45
2187180 2187180 2022-02-05 Albany Wyoming 56001 9561 45
2183927 2183927 2022-02-04 Albany Wyoming 56001 9561 45
2180675 2180675 2022-02-03 Albany Wyoming 56001 9499 45

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