ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Union" and fips = 21225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175309 | 2175309 | 2022-02-02 | Union | Kentucky | 21225 | 4008 | 52 |
2172056 | 2172056 | 2022-02-01 | Union | Kentucky | 21225 | 3979 | 52 |
2168803 | 2168803 | 2022-01-31 | Union | Kentucky | 21225 | 3951 | 52 |
2165548 | 2165548 | 2022-01-30 | Union | Kentucky | 21225 | 3891 | 52 |
2162293 | 2162293 | 2022-01-29 | Union | Kentucky | 21225 | 3891 | 52 |
2159038 | 2159038 | 2022-01-28 | Union | Kentucky | 21225 | 3891 | 52 |
2155784 | 2155784 | 2022-01-27 | Union | Kentucky | 21225 | 3827 | 52 |
2152531 | 2152531 | 2022-01-26 | Union | Kentucky | 21225 | 3798 | 51 |
2149279 | 2149279 | 2022-01-25 | Union | Kentucky | 21225 | 3742 | 51 |
2146027 | 2146027 | 2022-01-24 | Union | Kentucky | 21225 | 3700 | 51 |
2142772 | 2142772 | 2022-01-23 | Union | Kentucky | 21225 | 3611 | 51 |
2139517 | 2139517 | 2022-01-22 | Union | Kentucky | 21225 | 3611 | 51 |
2136261 | 2136261 | 2022-01-21 | Union | Kentucky | 21225 | 3611 | 51 |
2133009 | 2133009 | 2022-01-20 | Union | Kentucky | 21225 | 3575 | 51 |
2129756 | 2129756 | 2022-01-19 | Union | Kentucky | 21225 | 3510 | 51 |
2126502 | 2126502 | 2022-01-18 | Union | Kentucky | 21225 | 3468 | 51 |
2123250 | 2123250 | 2022-01-17 | Union | Kentucky | 21225 | 3328 | 48 |
2119998 | 2119998 | 2022-01-16 | Union | Kentucky | 21225 | 3328 | 48 |
2116746 | 2116746 | 2022-01-15 | Union | Kentucky | 21225 | 3328 | 48 |
2113495 | 2113495 | 2022-01-14 | Union | Kentucky | 21225 | 3328 | 48 |
2110243 | 2110243 | 2022-01-13 | Union | Kentucky | 21225 | 3239 | 48 |
2106992 | 2106992 | 2022-01-12 | Union | Kentucky | 21225 | 3206 | 48 |
2103741 | 2103741 | 2022-01-11 | Union | Kentucky | 21225 | 3153 | 48 |
2100490 | 2100490 | 2022-01-10 | Union | Kentucky | 21225 | 3131 | 48 |
2097239 | 2097239 | 2022-01-09 | Union | Kentucky | 21225 | 3108 | 47 |
2093987 | 2093987 | 2022-01-08 | Union | Kentucky | 21225 | 3108 | 47 |
2090735 | 2090735 | 2022-01-07 | Union | Kentucky | 21225 | 3108 | 47 |
2087484 | 2087484 | 2022-01-06 | Union | Kentucky | 21225 | 3074 | 47 |
2084232 | 2084232 | 2022-01-05 | Union | Kentucky | 21225 | 3049 | 46 |
2080980 | 2080980 | 2022-01-04 | Union | Kentucky | 21225 | 3027 | 46 |
2077728 | 2077728 | 2022-01-03 | Union | Kentucky | 21225 | 3007 | 46 |
2074477 | 2074477 | 2022-01-02 | Union | Kentucky | 21225 | 2944 | 46 |
2071226 | 2071226 | 2022-01-01 | Union | Kentucky | 21225 | 2944 | 46 |
2067975 | 2067975 | 2021-12-31 | Union | Kentucky | 21225 | 2944 | 46 |
2064724 | 2064724 | 2021-12-30 | Union | Kentucky | 21225 | 2944 | 46 |
2061474 | 2061474 | 2021-12-29 | Union | Kentucky | 21225 | 2944 | 46 |
2058225 | 2058225 | 2021-12-28 | Union | Kentucky | 21225 | 2928 | 46 |
2054976 | 2054976 | 2021-12-27 | Union | Kentucky | 21225 | 2914 | 46 |
2051726 | 2051726 | 2021-12-26 | Union | Kentucky | 21225 | 2868 | 44 |
2048476 | 2048476 | 2021-12-25 | Union | Kentucky | 21225 | 2868 | 44 |
2045226 | 2045226 | 2021-12-24 | Union | Kentucky | 21225 | 2868 | 44 |
2041977 | 2041977 | 2021-12-23 | Union | Kentucky | 21225 | 2868 | 44 |
2038727 | 2038727 | 2021-12-22 | Union | Kentucky | 21225 | 2868 | 44 |
2035477 | 2035477 | 2021-12-21 | Union | Kentucky | 21225 | 2861 | 44 |
2032227 | 2032227 | 2021-12-20 | Union | Kentucky | 21225 | 2851 | 44 |
2028976 | 2028976 | 2021-12-19 | Union | Kentucky | 21225 | 2805 | 44 |
2025725 | 2025725 | 2021-12-18 | Union | Kentucky | 21225 | 2805 | 44 |
2022474 | 2022474 | 2021-12-17 | Union | Kentucky | 21225 | 2805 | 44 |
2019223 | 2019223 | 2021-12-16 | Union | Kentucky | 21225 | 2789 | 44 |
2015973 | 2015973 | 2021-12-15 | Union | Kentucky | 21225 | 2772 | 44 |
2012722 | 2012722 | 2021-12-14 | Union | Kentucky | 21225 | 2755 | 43 |
2009471 | 2009471 | 2021-12-13 | Union | Kentucky | 21225 | 2739 | 43 |
2006220 | 2006220 | 2021-12-12 | Union | Kentucky | 21225 | 2722 | 43 |
2002969 | 2002969 | 2021-12-11 | Union | Kentucky | 21225 | 2722 | 43 |
1999719 | 1999719 | 2021-12-10 | Union | Kentucky | 21225 | 2722 | 43 |
1996468 | 1996468 | 2021-12-09 | Union | Kentucky | 21225 | 2690 | 43 |
1993217 | 1993217 | 2021-12-08 | Union | Kentucky | 21225 | 2684 | 43 |
1989966 | 1989966 | 2021-12-07 | Union | Kentucky | 21225 | 2663 | 42 |
1986716 | 1986716 | 2021-12-06 | Union | Kentucky | 21225 | 2638 | 42 |
1983466 | 1983466 | 2021-12-05 | Union | Kentucky | 21225 | 2613 | 41 |
1980216 | 1980216 | 2021-12-04 | Union | Kentucky | 21225 | 2613 | 41 |
1976966 | 1976966 | 2021-12-03 | Union | Kentucky | 21225 | 2613 | 41 |
1973717 | 1973717 | 2021-12-02 | Union | Kentucky | 21225 | 2598 | 40 |
1970467 | 1970467 | 2021-12-01 | Union | Kentucky | 21225 | 2579 | 40 |
1967217 | 1967217 | 2021-11-30 | Union | Kentucky | 21225 | 2569 | 39 |
1963965 | 1963965 | 2021-11-29 | Union | Kentucky | 21225 | 2553 | 39 |
1960714 | 1960714 | 2021-11-28 | Union | Kentucky | 21225 | 2550 | 39 |
1957463 | 1957463 | 2021-11-27 | Union | Kentucky | 21225 | 2550 | 39 |
1954212 | 1954212 | 2021-11-26 | Union | Kentucky | 21225 | 2550 | 39 |
1950961 | 1950961 | 2021-11-25 | Union | Kentucky | 21225 | 2550 | 39 |
1947710 | 1947710 | 2021-11-24 | Union | Kentucky | 21225 | 2550 | 39 |
1944459 | 1944459 | 2021-11-23 | Union | Kentucky | 21225 | 2537 | 39 |
1941209 | 1941209 | 2021-11-22 | Union | Kentucky | 21225 | 2531 | 39 |
1937959 | 1937959 | 2021-11-21 | Union | Kentucky | 21225 | 2526 | 38 |
1934709 | 1934709 | 2021-11-20 | Union | Kentucky | 21225 | 2526 | 38 |
1931458 | 1931458 | 2021-11-19 | Union | Kentucky | 21225 | 2526 | 38 |
1928207 | 1928207 | 2021-11-18 | Union | Kentucky | 21225 | 2526 | 36 |
1924957 | 1924957 | 2021-11-17 | Union | Kentucky | 21225 | 2523 | 36 |
1921708 | 1921708 | 2021-11-16 | Union | Kentucky | 21225 | 2523 | 36 |
1918458 | 1918458 | 2021-11-15 | Union | Kentucky | 21225 | 2519 | 36 |
1915208 | 1915208 | 2021-11-14 | Union | Kentucky | 21225 | 2516 | 36 |
1911958 | 1911958 | 2021-11-13 | Union | Kentucky | 21225 | 2516 | 36 |
1908709 | 1908709 | 2021-11-12 | Union | Kentucky | 21225 | 2516 | 36 |
1905460 | 1905460 | 2021-11-11 | Union | Kentucky | 21225 | 2512 | 36 |
1902210 | 1902210 | 2021-11-10 | Union | Kentucky | 21225 | 2512 | 36 |
1898960 | 1898960 | 2021-11-09 | Union | Kentucky | 21225 | 2510 | 36 |
1895710 | 1895710 | 2021-11-08 | Union | Kentucky | 21225 | 2507 | 35 |
1892460 | 1892460 | 2021-11-07 | Union | Kentucky | 21225 | 2503 | 34 |
1889210 | 1889210 | 2021-11-06 | Union | Kentucky | 21225 | 2503 | 34 |
1885960 | 1885960 | 2021-11-05 | Union | Kentucky | 21225 | 2503 | 34 |
1882711 | 1882711 | 2021-11-04 | Union | Kentucky | 21225 | 2502 | 33 |
1879462 | 1879462 | 2021-11-03 | Union | Kentucky | 21225 | 2499 | 33 |
1876213 | 1876213 | 2021-11-02 | Union | Kentucky | 21225 | 2498 | 32 |
1872964 | 1872964 | 2021-11-01 | Union | Kentucky | 21225 | 2496 | 32 |
1869715 | 1869715 | 2021-10-31 | Union | Kentucky | 21225 | 2494 | 32 |
1866466 | 1866466 | 2021-10-30 | Union | Kentucky | 21225 | 2494 | 32 |
1863217 | 1863217 | 2021-10-29 | Union | Kentucky | 21225 | 2494 | 32 |
1859968 | 1859968 | 2021-10-28 | Union | Kentucky | 21225 | 2492 | 32 |
1856719 | 1856719 | 2021-10-27 | Union | Kentucky | 21225 | 2492 | 32 |
1853470 | 1853470 | 2021-10-26 | Union | Kentucky | 21225 | 2491 | 32 |
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);