ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,573 rows where county = "Albany" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338654 | 2338654 | 2022-03-24 | Albany | New York | 36001 | 58593 | 507 |
2340034 | 2340034 | 2022-03-24 | Albany | Wyoming | 56001 | 9856 | 48 |
2335400 | 2335400 | 2022-03-23 | Albany | New York | 36001 | 58551 | 507 |
2336781 | 2336781 | 2022-03-23 | Albany | Wyoming | 56001 | 9856 | 48 |
2332146 | 2332146 | 2022-03-22 | Albany | New York | 36001 | 58501 | 507 |
2333527 | 2333527 | 2022-03-22 | Albany | Wyoming | 56001 | 9856 | 48 |
2328893 | 2328893 | 2022-03-21 | Albany | New York | 36001 | 58482 | 507 |
2330273 | 2330273 | 2022-03-21 | Albany | Wyoming | 56001 | 9852 | 48 |
2325641 | 2325641 | 2022-03-20 | Albany | New York | 36001 | 58466 | 507 |
2327021 | 2327021 | 2022-03-20 | Albany | Wyoming | 56001 | 9852 | 48 |
2322388 | 2322388 | 2022-03-19 | Albany | New York | 36001 | 58442 | 507 |
2323768 | 2323768 | 2022-03-19 | Albany | Wyoming | 56001 | 9852 | 48 |
2319134 | 2319134 | 2022-03-18 | Albany | New York | 36001 | 58415 | 507 |
2320514 | 2320514 | 2022-03-18 | Albany | Wyoming | 56001 | 9852 | 48 |
2315880 | 2315880 | 2022-03-17 | Albany | New York | 36001 | 58381 | 507 |
2317260 | 2317260 | 2022-03-17 | Albany | Wyoming | 56001 | 9847 | 48 |
2312627 | 2312627 | 2022-03-16 | Albany | New York | 36001 | 58357 | 507 |
2314007 | 2314007 | 2022-03-16 | Albany | Wyoming | 56001 | 9847 | 48 |
2309374 | 2309374 | 2022-03-15 | Albany | New York | 36001 | 58324 | 507 |
2310754 | 2310754 | 2022-03-15 | Albany | Wyoming | 56001 | 9847 | 48 |
2306121 | 2306121 | 2022-03-14 | Albany | New York | 36001 | 58307 | 507 |
2307501 | 2307501 | 2022-03-14 | Albany | Wyoming | 56001 | 9846 | 47 |
2302870 | 2302870 | 2022-03-13 | Albany | New York | 36001 | 58299 | 507 |
2304250 | 2304250 | 2022-03-13 | Albany | Wyoming | 56001 | 9846 | 47 |
2299618 | 2299618 | 2022-03-12 | Albany | New York | 36001 | 58269 | 504 |
2300998 | 2300998 | 2022-03-12 | Albany | Wyoming | 56001 | 9846 | 47 |
2296366 | 2296366 | 2022-03-11 | Albany | New York | 36001 | 58247 | 504 |
2297746 | 2297746 | 2022-03-11 | Albany | Wyoming | 56001 | 9846 | 47 |
2293114 | 2293114 | 2022-03-10 | Albany | New York | 36001 | 58222 | 504 |
2294494 | 2294494 | 2022-03-10 | Albany | Wyoming | 56001 | 9845 | 47 |
2289862 | 2289862 | 2022-03-09 | Albany | New York | 36001 | 58199 | 504 |
2291242 | 2291242 | 2022-03-09 | Albany | Wyoming | 56001 | 9835 | 47 |
2286610 | 2286610 | 2022-03-08 | Albany | New York | 36001 | 58162 | 503 |
2287990 | 2287990 | 2022-03-08 | Albany | Wyoming | 56001 | 9833 | 47 |
2283358 | 2283358 | 2022-03-07 | Albany | New York | 36001 | 58143 | 503 |
2284738 | 2284738 | 2022-03-07 | Albany | Wyoming | 56001 | 9831 | 47 |
2280106 | 2280106 | 2022-03-06 | Albany | New York | 36001 | 58130 | 502 |
2281486 | 2281486 | 2022-03-06 | Albany | Wyoming | 56001 | 9827 | 47 |
2276853 | 2276853 | 2022-03-05 | Albany | New York | 36001 | 58101 | 502 |
2278233 | 2278233 | 2022-03-05 | Albany | Wyoming | 56001 | 9827 | 47 |
2273600 | 2273600 | 2022-03-04 | Albany | New York | 36001 | 58018 | 502 |
2274980 | 2274980 | 2022-03-04 | Albany | Wyoming | 56001 | 9827 | 47 |
2270347 | 2270347 | 2022-03-03 | Albany | New York | 36001 | 58018 | 502 |
2271727 | 2271727 | 2022-03-03 | Albany | Wyoming | 56001 | 9825 | 47 |
2267095 | 2267095 | 2022-03-02 | Albany | New York | 36001 | 57983 | 502 |
2268475 | 2268475 | 2022-03-02 | Albany | Wyoming | 56001 | 9818 | 47 |
2263843 | 2263843 | 2022-03-01 | Albany | New York | 36001 | 57952 | 502 |
2265222 | 2265222 | 2022-03-01 | Albany | Wyoming | 56001 | 9811 | 47 |
2260592 | 2260592 | 2022-02-28 | Albany | New York | 36001 | 57922 | 502 |
2261972 | 2261972 | 2022-02-28 | Albany | Wyoming | 56001 | 9808 | 47 |
2257341 | 2257341 | 2022-02-27 | Albany | New York | 36001 | 57904 | 502 |
2258721 | 2258721 | 2022-02-27 | Albany | Wyoming | 56001 | 9797 | 47 |
2254090 | 2254090 | 2022-02-26 | Albany | New York | 36001 | 57886 | 502 |
2255470 | 2255470 | 2022-02-26 | Albany | Wyoming | 56001 | 9797 | 47 |
2250839 | 2250839 | 2022-02-25 | Albany | New York | 36001 | 57848 | 502 |
2252219 | 2252219 | 2022-02-25 | Albany | Wyoming | 56001 | 9797 | 47 |
2247588 | 2247588 | 2022-02-24 | Albany | New York | 36001 | 57817 | 501 |
2248968 | 2248968 | 2022-02-24 | Albany | Wyoming | 56001 | 9787 | 47 |
2244337 | 2244337 | 2022-02-23 | Albany | New York | 36001 | 57777 | 501 |
2245717 | 2245717 | 2022-02-23 | Albany | Wyoming | 56001 | 9782 | 47 |
2241086 | 2241086 | 2022-02-22 | Albany | New York | 36001 | 57743 | 501 |
2242466 | 2242466 | 2022-02-22 | Albany | Wyoming | 56001 | 9773 | 47 |
2237835 | 2237835 | 2022-02-21 | Albany | New York | 36001 | 57715 | 501 |
2239215 | 2239215 | 2022-02-21 | Albany | Wyoming | 56001 | 9757 | 45 |
2234584 | 2234584 | 2022-02-20 | Albany | New York | 36001 | 57686 | 500 |
2235964 | 2235964 | 2022-02-20 | Albany | Wyoming | 56001 | 9757 | 45 |
2231333 | 2231333 | 2022-02-19 | Albany | New York | 36001 | 57649 | 498 |
2232713 | 2232713 | 2022-02-19 | Albany | Wyoming | 56001 | 9757 | 45 |
2228082 | 2228082 | 2022-02-18 | Albany | New York | 36001 | 57575 | 498 |
2229462 | 2229462 | 2022-02-18 | Albany | Wyoming | 56001 | 9757 | 45 |
2224831 | 2224831 | 2022-02-17 | Albany | New York | 36001 | 57516 | 498 |
2226211 | 2226211 | 2022-02-17 | Albany | Wyoming | 56001 | 9750 | 45 |
2221580 | 2221580 | 2022-02-16 | Albany | New York | 36001 | 57454 | 498 |
2222960 | 2222960 | 2022-02-16 | Albany | Wyoming | 56001 | 9741 | 45 |
2218329 | 2218329 | 2022-02-15 | Albany | New York | 36001 | 57381 | 498 |
2219709 | 2219709 | 2022-02-15 | Albany | Wyoming | 56001 | 9720 | 45 |
2215078 | 2215078 | 2022-02-14 | Albany | New York | 36001 | 57334 | 497 |
2216459 | 2216459 | 2022-02-14 | Albany | Wyoming | 56001 | 9712 | 45 |
2211827 | 2211827 | 2022-02-13 | Albany | New York | 36001 | 57292 | 496 |
2213208 | 2213208 | 2022-02-13 | Albany | Wyoming | 56001 | 9691 | 45 |
2208574 | 2208574 | 2022-02-12 | Albany | New York | 36001 | 57236 | 493 |
2209955 | 2209955 | 2022-02-12 | Albany | Wyoming | 56001 | 9691 | 45 |
2205321 | 2205321 | 2022-02-11 | Albany | New York | 36001 | 57166 | 493 |
2206702 | 2206702 | 2022-02-11 | Albany | Wyoming | 56001 | 9691 | 45 |
2202068 | 2202068 | 2022-02-10 | Albany | New York | 36001 | 57086 | 491 |
2203449 | 2203449 | 2022-02-10 | Albany | Wyoming | 56001 | 9669 | 45 |
2198814 | 2198814 | 2022-02-09 | Albany | New York | 36001 | 56961 | 490 |
2200195 | 2200195 | 2022-02-09 | Albany | Wyoming | 56001 | 9644 | 45 |
2195560 | 2195560 | 2022-02-08 | Albany | New York | 36001 | 56818 | 490 |
2196941 | 2196941 | 2022-02-08 | Albany | Wyoming | 56001 | 9607 | 45 |
2192306 | 2192306 | 2022-02-07 | Albany | New York | 36001 | 56760 | 490 |
2193686 | 2193686 | 2022-02-07 | Albany | Wyoming | 56001 | 9595 | 45 |
2189052 | 2189052 | 2022-02-06 | Albany | New York | 36001 | 56701 | 488 |
2190433 | 2190433 | 2022-02-06 | Albany | Wyoming | 56001 | 9561 | 45 |
2185799 | 2185799 | 2022-02-05 | Albany | New York | 36001 | 56325 | 486 |
2187180 | 2187180 | 2022-02-05 | Albany | Wyoming | 56001 | 9561 | 45 |
2182547 | 2182547 | 2022-02-04 | Albany | New York | 36001 | 56197 | 485 |
2183927 | 2183927 | 2022-02-04 | Albany | Wyoming | 56001 | 9561 | 45 |
2179295 | 2179295 | 2022-02-03 | Albany | New York | 36001 | 56072 | 485 |
2180675 | 2180675 | 2022-02-03 | Albany | Wyoming | 56001 | 9499 | 45 |
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);