ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where county = "Clay" and deaths = 32 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
county 1
- Clay · 121 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329710 | 2329710 | 2022-03-21 | Clay | Texas | 48077 | 2052 | 32 |
2326458 | 2326458 | 2022-03-20 | Clay | Texas | 48077 | 2052 | 32 |
2323205 | 2323205 | 2022-03-19 | Clay | Texas | 48077 | 2052 | 32 |
2319951 | 2319951 | 2022-03-18 | Clay | Texas | 48077 | 2052 | 32 |
2316697 | 2316697 | 2022-03-17 | Clay | Texas | 48077 | 2052 | 32 |
2300435 | 2300435 | 2022-03-12 | Clay | Texas | 48077 | 2049 | 32 |
2297183 | 2297183 | 2022-03-11 | Clay | Texas | 48077 | 2049 | 32 |
2293931 | 2293931 | 2022-03-10 | Clay | Texas | 48077 | 2047 | 32 |
2290679 | 2290679 | 2022-03-09 | Clay | Texas | 48077 | 2047 | 32 |
2287427 | 2287427 | 2022-03-08 | Clay | Texas | 48077 | 2044 | 32 |
2284175 | 2284175 | 2022-03-07 | Clay | Texas | 48077 | 2041 | 32 |
2280923 | 2280923 | 2022-03-06 | Clay | Texas | 48077 | 2041 | 32 |
2277670 | 2277670 | 2022-03-05 | Clay | Texas | 48077 | 2041 | 32 |
2274417 | 2274417 | 2022-03-04 | Clay | Texas | 48077 | 2040 | 32 |
2271164 | 2271164 | 2022-03-03 | Clay | Texas | 48077 | 2040 | 32 |
2267912 | 2267912 | 2022-03-02 | Clay | Texas | 48077 | 2040 | 32 |
2217391 | 2217391 | 2022-02-15 | Clay | Kansas | 20027 | 1945 | 32 |
2214140 | 2214140 | 2022-02-14 | Clay | Kansas | 20027 | 1945 | 32 |
2216339 | 2216339 | 2022-02-14 | Clay | West Virginia | 54015 | 2245 | 32 |
2210888 | 2210888 | 2022-02-13 | Clay | Kansas | 20027 | 1937 | 32 |
2213088 | 2213088 | 2022-02-13 | Clay | West Virginia | 54015 | 2240 | 32 |
2207635 | 2207635 | 2022-02-12 | Clay | Kansas | 20027 | 1937 | 32 |
2209835 | 2209835 | 2022-02-12 | Clay | West Virginia | 54015 | 2234 | 32 |
2204382 | 2204382 | 2022-02-11 | Clay | Kansas | 20027 | 1937 | 32 |
2206582 | 2206582 | 2022-02-11 | Clay | West Virginia | 54015 | 2230 | 32 |
2201129 | 2201129 | 2022-02-10 | Clay | Kansas | 20027 | 1937 | 32 |
2203329 | 2203329 | 2022-02-10 | Clay | West Virginia | 54015 | 2212 | 32 |
2197875 | 2197875 | 2022-02-09 | Clay | Kansas | 20027 | 1937 | 32 |
2200075 | 2200075 | 2022-02-09 | Clay | West Virginia | 54015 | 2196 | 32 |
2194621 | 2194621 | 2022-02-08 | Clay | Kansas | 20027 | 1919 | 32 |
2196821 | 2196821 | 2022-02-08 | Clay | West Virginia | 54015 | 2194 | 32 |
2191367 | 2191367 | 2022-02-07 | Clay | Kansas | 20027 | 1919 | 32 |
2188114 | 2188114 | 2022-02-06 | Clay | Kansas | 20027 | 1911 | 32 |
2184861 | 2184861 | 2022-02-05 | Clay | Kansas | 20027 | 1911 | 32 |
2181609 | 2181609 | 2022-02-04 | Clay | Kansas | 20027 | 1911 | 32 |
2178358 | 2178358 | 2022-02-03 | Clay | Kansas | 20027 | 1897 | 32 |
2175105 | 2175105 | 2022-02-02 | Clay | Kansas | 20027 | 1897 | 32 |
2171852 | 2171852 | 2022-02-01 | Clay | Kansas | 20027 | 1869 | 32 |
2168599 | 2168599 | 2022-01-31 | Clay | Kansas | 20027 | 1869 | 32 |
2165344 | 2165344 | 2022-01-30 | Clay | Kansas | 20027 | 1856 | 32 |
2162089 | 2162089 | 2022-01-29 | Clay | Kansas | 20027 | 1856 | 32 |
2158834 | 2158834 | 2022-01-28 | Clay | Kansas | 20027 | 1856 | 32 |
2155580 | 2155580 | 2022-01-27 | Clay | Kansas | 20027 | 1833 | 32 |
2152327 | 2152327 | 2022-01-26 | Clay | Kansas | 20027 | 1833 | 32 |
2149075 | 2149075 | 2022-01-25 | Clay | Kansas | 20027 | 1790 | 32 |
2145823 | 2145823 | 2022-01-24 | Clay | Kansas | 20027 | 1790 | 32 |
2142568 | 2142568 | 2022-01-23 | Clay | Kansas | 20027 | 1754 | 32 |
2139313 | 2139313 | 2022-01-22 | Clay | Kansas | 20027 | 1754 | 32 |
2136057 | 2136057 | 2022-01-21 | Clay | Kansas | 20027 | 1754 | 32 |
2132805 | 2132805 | 2022-01-20 | Clay | Kansas | 20027 | 1709 | 32 |
2129552 | 2129552 | 2022-01-19 | Clay | Kansas | 20027 | 1709 | 32 |
2126298 | 2126298 | 2022-01-18 | Clay | Kansas | 20027 | 1620 | 32 |
2123046 | 2123046 | 2022-01-17 | Clay | Kansas | 20027 | 1620 | 32 |
2119794 | 2119794 | 2022-01-16 | Clay | Kansas | 20027 | 1620 | 32 |
2116542 | 2116542 | 2022-01-15 | Clay | Kansas | 20027 | 1620 | 32 |
2113291 | 2113291 | 2022-01-14 | Clay | Kansas | 20027 | 1620 | 32 |
1715186 | 1715186 | 2021-09-13 | Clay | Tennessee | 47027 | 1317 | 32 |
1711940 | 1711940 | 2021-09-12 | Clay | Tennessee | 47027 | 1290 | 32 |
1708693 | 1708693 | 2021-09-11 | Clay | Tennessee | 47027 | 1290 | 32 |
1705446 | 1705446 | 2021-09-10 | Clay | Tennessee | 47027 | 1290 | 32 |
1702196 | 1702196 | 2021-09-09 | Clay | Tennessee | 47027 | 1281 | 32 |
1698947 | 1698947 | 2021-09-08 | Clay | Tennessee | 47027 | 1275 | 32 |
1132437 | 1132437 | 2021-03-18 | Clay | Kentucky | 21051 | 2537 | 32 |
992551 | 992551 | 2021-02-03 | Clay | Indiana | 18021 | 2307 | 32 |
989305 | 989305 | 2021-02-02 | Clay | Indiana | 18021 | 2301 | 32 |
986058 | 986058 | 2021-02-01 | Clay | Indiana | 18021 | 2293 | 32 |
982811 | 982811 | 2021-01-31 | Clay | Indiana | 18021 | 2285 | 32 |
979565 | 979565 | 2021-01-30 | Clay | Indiana | 18021 | 2280 | 32 |
976319 | 976319 | 2021-01-29 | Clay | Indiana | 18021 | 2275 | 32 |
973074 | 973074 | 2021-01-28 | Clay | Indiana | 18021 | 2269 | 32 |
969829 | 969829 | 2021-01-27 | Clay | Indiana | 18021 | 2257 | 32 |
966585 | 966585 | 2021-01-26 | Clay | Indiana | 18021 | 2250 | 32 |
963340 | 963340 | 2021-01-25 | Clay | Indiana | 18021 | 2243 | 32 |
960095 | 960095 | 2021-01-24 | Clay | Indiana | 18021 | 2235 | 32 |
956849 | 956849 | 2021-01-23 | Clay | Indiana | 18021 | 2225 | 32 |
953604 | 953604 | 2021-01-22 | Clay | Indiana | 18021 | 2218 | 32 |
950359 | 950359 | 2021-01-21 | Clay | Indiana | 18021 | 2209 | 32 |
947113 | 947113 | 2021-01-20 | Clay | Indiana | 18021 | 2199 | 32 |
943866 | 943866 | 2021-01-19 | Clay | Indiana | 18021 | 2190 | 32 |
940621 | 940621 | 2021-01-18 | Clay | Indiana | 18021 | 2187 | 32 |
937376 | 937376 | 2021-01-17 | Clay | Indiana | 18021 | 2179 | 32 |
934131 | 934131 | 2021-01-16 | Clay | Indiana | 18021 | 2164 | 32 |
930886 | 930886 | 2021-01-15 | Clay | Indiana | 18021 | 2147 | 32 |
931600 | 931600 | 2021-01-15 | Clay | Mississippi | 28025 | 1567 | 32 |
927641 | 927641 | 2021-01-14 | Clay | Indiana | 18021 | 2124 | 32 |
928355 | 928355 | 2021-01-14 | Clay | Mississippi | 28025 | 1556 | 32 |
924395 | 924395 | 2021-01-13 | Clay | Indiana | 18021 | 2105 | 32 |
925109 | 925109 | 2021-01-13 | Clay | Mississippi | 28025 | 1538 | 32 |
921150 | 921150 | 2021-01-12 | Clay | Indiana | 18021 | 2090 | 32 |
917905 | 917905 | 2021-01-11 | Clay | Indiana | 18021 | 2084 | 32 |
914660 | 914660 | 2021-01-10 | Clay | Indiana | 18021 | 2067 | 32 |
911415 | 911415 | 2021-01-09 | Clay | Indiana | 18021 | 2044 | 32 |
908170 | 908170 | 2021-01-08 | Clay | Indiana | 18021 | 2014 | 32 |
904924 | 904924 | 2021-01-07 | Clay | Indiana | 18021 | 1996 | 32 |
901679 | 901679 | 2021-01-06 | Clay | Indiana | 18021 | 1961 | 32 |
897842 | 897842 | 2021-01-05 | Clay | Arkansas | 5021 | 1369 | 32 |
894597 | 894597 | 2021-01-04 | Clay | Arkansas | 5021 | 1350 | 32 |
852301 | 852301 | 2020-12-22 | Clay | Alabama | 1027 | 1077 | 32 |
438978 | 438978 | 2020-08-16 | Clay | Missouri | 29047 | 1143 | 32 |
435753 | 435753 | 2020-08-15 | Clay | Missouri | 29047 | 1133 | 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);