ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Albany" and fips = 56001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
2177424 | 2177424 | 2022-02-02 | Albany | Wyoming | 56001 | 9467 | 45 |
2174171 | 2174171 | 2022-02-01 | Albany | Wyoming | 56001 | 9427 | 45 |
2170919 | 2170919 | 2022-01-31 | Albany | Wyoming | 56001 | 9397 | 45 |
2167666 | 2167666 | 2022-01-30 | Albany | Wyoming | 56001 | 9262 | 45 |
2164411 | 2164411 | 2022-01-29 | Albany | Wyoming | 56001 | 9262 | 45 |
2161156 | 2161156 | 2022-01-28 | Albany | Wyoming | 56001 | 9262 | 45 |
2157900 | 2157900 | 2022-01-27 | Albany | Wyoming | 56001 | 9226 | 45 |
2154647 | 2154647 | 2022-01-26 | Albany | Wyoming | 56001 | 9126 | 45 |
2151394 | 2151394 | 2022-01-25 | Albany | Wyoming | 56001 | 9005 | 45 |
2148142 | 2148142 | 2022-01-24 | Albany | Wyoming | 56001 | 8897 | 44 |
2144890 | 2144890 | 2022-01-23 | Albany | Wyoming | 56001 | 8775 | 44 |
2141635 | 2141635 | 2022-01-22 | Albany | Wyoming | 56001 | 8775 | 44 |
2138379 | 2138379 | 2022-01-21 | Albany | Wyoming | 56001 | 8775 | 44 |
2135124 | 2135124 | 2022-01-20 | Albany | Wyoming | 56001 | 8655 | 44 |
2131872 | 2131872 | 2022-01-19 | Albany | Wyoming | 56001 | 8544 | 44 |
2128618 | 2128618 | 2022-01-18 | Albany | Wyoming | 56001 | 8415 | 44 |
2125365 | 2125365 | 2022-01-17 | Albany | Wyoming | 56001 | 8171 | 44 |
2122113 | 2122113 | 2022-01-16 | Albany | Wyoming | 56001 | 8171 | 44 |
2118861 | 2118861 | 2022-01-15 | Albany | Wyoming | 56001 | 8171 | 44 |
2115609 | 2115609 | 2022-01-14 | Albany | Wyoming | 56001 | 8171 | 44 |
2112357 | 2112357 | 2022-01-13 | Albany | Wyoming | 56001 | 8091 | 44 |
2109105 | 2109105 | 2022-01-12 | Albany | Wyoming | 56001 | 7940 | 44 |
2105854 | 2105854 | 2022-01-11 | Albany | Wyoming | 56001 | 7838 | 44 |
2102603 | 2102603 | 2022-01-10 | Albany | Wyoming | 56001 | 7759 | 44 |
2099352 | 2099352 | 2022-01-09 | Albany | Wyoming | 56001 | 7535 | 44 |
2096101 | 2096101 | 2022-01-08 | Albany | Wyoming | 56001 | 7535 | 44 |
2092849 | 2092849 | 2022-01-07 | Albany | Wyoming | 56001 | 7535 | 44 |
2089597 | 2089597 | 2022-01-06 | Albany | Wyoming | 56001 | 7463 | 44 |
2086346 | 2086346 | 2022-01-05 | Albany | Wyoming | 56001 | 7358 | 44 |
2083094 | 2083094 | 2022-01-04 | Albany | Wyoming | 56001 | 7249 | 44 |
2079842 | 2079842 | 2022-01-03 | Albany | Wyoming | 56001 | 7150 | 43 |
2076590 | 2076590 | 2022-01-02 | Albany | Wyoming | 56001 | 7048 | 43 |
2073339 | 2073339 | 2022-01-01 | Albany | Wyoming | 56001 | 7048 | 43 |
2070088 | 2070088 | 2021-12-31 | Albany | Wyoming | 56001 | 7048 | 43 |
2066837 | 2066837 | 2021-12-30 | Albany | Wyoming | 56001 | 7048 | 43 |
2063587 | 2063587 | 2021-12-29 | Albany | Wyoming | 56001 | 7018 | 43 |
2060337 | 2060337 | 2021-12-28 | Albany | Wyoming | 56001 | 6985 | 43 |
2057088 | 2057088 | 2021-12-27 | Albany | Wyoming | 56001 | 6958 | 43 |
2053839 | 2053839 | 2021-12-26 | Albany | Wyoming | 56001 | 6934 | 43 |
2050589 | 2050589 | 2021-12-25 | Albany | Wyoming | 56001 | 6934 | 43 |
2047339 | 2047339 | 2021-12-24 | Albany | Wyoming | 56001 | 6934 | 43 |
2044089 | 2044089 | 2021-12-23 | Albany | Wyoming | 56001 | 6934 | 43 |
2040840 | 2040840 | 2021-12-22 | Albany | Wyoming | 56001 | 6924 | 43 |
2037590 | 2037590 | 2021-12-21 | Albany | Wyoming | 56001 | 6920 | 43 |
2034340 | 2034340 | 2021-12-20 | Albany | Wyoming | 56001 | 6915 | 41 |
2031090 | 2031090 | 2021-12-19 | Albany | Wyoming | 56001 | 6909 | 41 |
2027839 | 2027839 | 2021-12-18 | Albany | Wyoming | 56001 | 6909 | 41 |
2024588 | 2024588 | 2021-12-17 | Albany | Wyoming | 56001 | 6909 | 41 |
2021337 | 2021337 | 2021-12-16 | Albany | Wyoming | 56001 | 6908 | 41 |
2018086 | 2018086 | 2021-12-15 | Albany | Wyoming | 56001 | 6905 | 41 |
Advanced export
JSON shape: default, array, newline-delimited
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);