ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
422 rows where county = "Clay" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- Georgia 159
- Iowa 72
- West Virginia 67
- Nebraska 28
- Arkansas 26
- Kentucky 19
- Indiana 17
- Mississippi 13
- South Dakota 6
- Florida 4
- Tennessee 4
- Alabama 3
- Minnesota 2
- Missouri 2
fips 14
county 1
- Clay · 422 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2246160 | 2246160 | 2022-02-24 | Clay | Georgia | 13061 | 516 | 4 |
2242909 | 2242909 | 2022-02-23 | Clay | Georgia | 13061 | 516 | 4 |
2239658 | 2239658 | 2022-02-22 | Clay | Georgia | 13061 | 516 | 4 |
2236407 | 2236407 | 2022-02-21 | Clay | Georgia | 13061 | 516 | 4 |
2233156 | 2233156 | 2022-02-20 | Clay | Georgia | 13061 | 516 | 4 |
2229905 | 2229905 | 2022-02-19 | Clay | Georgia | 13061 | 516 | 4 |
2226654 | 2226654 | 2022-02-18 | Clay | Georgia | 13061 | 516 | 4 |
2223403 | 2223403 | 2022-02-17 | Clay | Georgia | 13061 | 516 | 4 |
2220152 | 2220152 | 2022-02-16 | Clay | Georgia | 13061 | 516 | 4 |
2216901 | 2216901 | 2022-02-15 | Clay | Georgia | 13061 | 516 | 4 |
2213650 | 2213650 | 2022-02-14 | Clay | Georgia | 13061 | 516 | 4 |
2210398 | 2210398 | 2022-02-13 | Clay | Georgia | 13061 | 513 | 4 |
2207145 | 2207145 | 2022-02-12 | Clay | Georgia | 13061 | 513 | 4 |
2203892 | 2203892 | 2022-02-11 | Clay | Georgia | 13061 | 513 | 4 |
2200639 | 2200639 | 2022-02-10 | Clay | Georgia | 13061 | 513 | 4 |
2197385 | 2197385 | 2022-02-09 | Clay | Georgia | 13061 | 511 | 4 |
2194131 | 2194131 | 2022-02-08 | Clay | Georgia | 13061 | 510 | 4 |
2190877 | 2190877 | 2022-02-07 | Clay | Georgia | 13061 | 510 | 4 |
2187624 | 2187624 | 2022-02-06 | Clay | Georgia | 13061 | 506 | 4 |
2184371 | 2184371 | 2022-02-05 | Clay | Georgia | 13061 | 506 | 4 |
2181119 | 2181119 | 2022-02-04 | Clay | Georgia | 13061 | 506 | 4 |
2177868 | 2177868 | 2022-02-03 | Clay | Georgia | 13061 | 505 | 4 |
2174615 | 2174615 | 2022-02-02 | Clay | Georgia | 13061 | 505 | 4 |
2171362 | 2171362 | 2022-02-01 | Clay | Georgia | 13061 | 505 | 4 |
2168109 | 2168109 | 2022-01-31 | Clay | Georgia | 13061 | 504 | 4 |
2164854 | 2164854 | 2022-01-30 | Clay | Georgia | 13061 | 497 | 4 |
2161599 | 2161599 | 2022-01-29 | Clay | Georgia | 13061 | 497 | 4 |
2158343 | 2158343 | 2022-01-28 | Clay | Georgia | 13061 | 497 | 4 |
2155090 | 2155090 | 2022-01-27 | Clay | Georgia | 13061 | 493 | 4 |
2151837 | 2151837 | 2022-01-26 | Clay | Georgia | 13061 | 490 | 4 |
2148585 | 2148585 | 2022-01-25 | Clay | Georgia | 13061 | 487 | 4 |
2145333 | 2145333 | 2022-01-24 | Clay | Georgia | 13061 | 480 | 4 |
2142078 | 2142078 | 2022-01-23 | Clay | Georgia | 13061 | 470 | 4 |
2138823 | 2138823 | 2022-01-22 | Clay | Georgia | 13061 | 470 | 4 |
2135567 | 2135567 | 2022-01-21 | Clay | Georgia | 13061 | 470 | 4 |
2132315 | 2132315 | 2022-01-20 | Clay | Georgia | 13061 | 462 | 4 |
2129062 | 2129062 | 2022-01-19 | Clay | Georgia | 13061 | 455 | 4 |
2125808 | 2125808 | 2022-01-18 | Clay | Georgia | 13061 | 448 | 4 |
2122556 | 2122556 | 2022-01-17 | Clay | Georgia | 13061 | 446 | 4 |
2119304 | 2119304 | 2022-01-16 | Clay | Georgia | 13061 | 436 | 4 |
2116052 | 2116052 | 2022-01-15 | Clay | Georgia | 13061 | 436 | 4 |
2112801 | 2112801 | 2022-01-14 | Clay | Georgia | 13061 | 436 | 4 |
2109549 | 2109549 | 2022-01-13 | Clay | Georgia | 13061 | 428 | 4 |
2106298 | 2106298 | 2022-01-12 | Clay | Georgia | 13061 | 417 | 4 |
2103047 | 2103047 | 2022-01-11 | Clay | Georgia | 13061 | 405 | 4 |
2099796 | 2099796 | 2022-01-10 | Clay | Georgia | 13061 | 393 | 4 |
2096545 | 2096545 | 2022-01-09 | Clay | Georgia | 13061 | 368 | 4 |
2093293 | 2093293 | 2022-01-08 | Clay | Georgia | 13061 | 368 | 4 |
2090041 | 2090041 | 2022-01-07 | Clay | Georgia | 13061 | 368 | 4 |
2086790 | 2086790 | 2022-01-06 | Clay | Georgia | 13061 | 368 | 4 |
2083538 | 2083538 | 2022-01-05 | Clay | Georgia | 13061 | 368 | 4 |
2080286 | 2080286 | 2022-01-04 | Clay | Georgia | 13061 | 348 | 4 |
2077034 | 2077034 | 2022-01-03 | Clay | Georgia | 13061 | 325 | 4 |
2073783 | 2073783 | 2022-01-02 | Clay | Georgia | 13061 | 325 | 4 |
2070532 | 2070532 | 2022-01-01 | Clay | Georgia | 13061 | 325 | 4 |
2067281 | 2067281 | 2021-12-31 | Clay | Georgia | 13061 | 325 | 4 |
2064030 | 2064030 | 2021-12-30 | Clay | Georgia | 13061 | 322 | 4 |
2060780 | 2060780 | 2021-12-29 | Clay | Georgia | 13061 | 322 | 4 |
2057531 | 2057531 | 2021-12-28 | Clay | Georgia | 13061 | 321 | 4 |
2054282 | 2054282 | 2021-12-27 | Clay | Georgia | 13061 | 319 | 4 |
2051032 | 2051032 | 2021-12-26 | Clay | Georgia | 13061 | 318 | 4 |
2047782 | 2047782 | 2021-12-25 | Clay | Georgia | 13061 | 318 | 4 |
2044532 | 2044532 | 2021-12-24 | Clay | Georgia | 13061 | 318 | 4 |
2041283 | 2041283 | 2021-12-23 | Clay | Georgia | 13061 | 318 | 4 |
2038033 | 2038033 | 2021-12-22 | Clay | Georgia | 13061 | 318 | 4 |
2034783 | 2034783 | 2021-12-21 | Clay | Georgia | 13061 | 318 | 4 |
2031533 | 2031533 | 2021-12-20 | Clay | Georgia | 13061 | 318 | 4 |
2028282 | 2028282 | 2021-12-19 | Clay | Georgia | 13061 | 318 | 4 |
2025031 | 2025031 | 2021-12-18 | Clay | Georgia | 13061 | 318 | 4 |
2021780 | 2021780 | 2021-12-17 | Clay | Georgia | 13061 | 318 | 4 |
2018529 | 2018529 | 2021-12-16 | Clay | Georgia | 13061 | 317 | 4 |
2015279 | 2015279 | 2021-12-15 | Clay | Georgia | 13061 | 317 | 4 |
2012028 | 2012028 | 2021-12-14 | Clay | Georgia | 13061 | 317 | 4 |
2008777 | 2008777 | 2021-12-13 | Clay | Georgia | 13061 | 317 | 4 |
2005526 | 2005526 | 2021-12-12 | Clay | Georgia | 13061 | 317 | 4 |
2002275 | 2002275 | 2021-12-11 | Clay | Georgia | 13061 | 317 | 4 |
1999025 | 1999025 | 2021-12-10 | Clay | Georgia | 13061 | 317 | 4 |
1995774 | 1995774 | 2021-12-09 | Clay | Georgia | 13061 | 317 | 4 |
1992523 | 1992523 | 2021-12-08 | Clay | Georgia | 13061 | 317 | 4 |
1989272 | 1989272 | 2021-12-07 | Clay | Georgia | 13061 | 316 | 4 |
1986022 | 1986022 | 2021-12-06 | Clay | Georgia | 13061 | 316 | 4 |
1982772 | 1982772 | 2021-12-05 | Clay | Georgia | 13061 | 316 | 4 |
1979522 | 1979522 | 2021-12-04 | Clay | Georgia | 13061 | 316 | 4 |
1976272 | 1976272 | 2021-12-03 | Clay | Georgia | 13061 | 316 | 4 |
1973023 | 1973023 | 2021-12-02 | Clay | Georgia | 13061 | 316 | 4 |
1969773 | 1969773 | 2021-12-01 | Clay | Georgia | 13061 | 316 | 4 |
1966523 | 1966523 | 2021-11-30 | Clay | Georgia | 13061 | 315 | 4 |
1963271 | 1963271 | 2021-11-29 | Clay | Georgia | 13061 | 315 | 4 |
1960020 | 1960020 | 2021-11-28 | Clay | Georgia | 13061 | 315 | 4 |
1956769 | 1956769 | 2021-11-27 | Clay | Georgia | 13061 | 315 | 4 |
1953518 | 1953518 | 2021-11-26 | Clay | Georgia | 13061 | 315 | 4 |
1950267 | 1950267 | 2021-11-25 | Clay | Georgia | 13061 | 315 | 4 |
1947016 | 1947016 | 2021-11-24 | Clay | Georgia | 13061 | 315 | 4 |
1943765 | 1943765 | 2021-11-23 | Clay | Georgia | 13061 | 315 | 4 |
1940515 | 1940515 | 2021-11-22 | Clay | Georgia | 13061 | 315 | 4 |
1937265 | 1937265 | 2021-11-21 | Clay | Georgia | 13061 | 314 | 4 |
1934015 | 1934015 | 2021-11-20 | Clay | Georgia | 13061 | 314 | 4 |
1930763 | 1930763 | 2021-11-19 | Clay | Georgia | 13061 | 314 | 4 |
1927513 | 1927513 | 2021-11-18 | Clay | Georgia | 13061 | 314 | 4 |
1924263 | 1924263 | 2021-11-17 | Clay | Georgia | 13061 | 314 | 4 |
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);