ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,569 rows where county = "Clayton" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337225 | 2337225 | 2022-03-24 | Clayton | Georgia | 13063 | 63426 | 941 |
2337622 | 2337622 | 2022-03-24 | Clayton | Iowa | 19043 | 3454 | 72 |
2333971 | 2333971 | 2022-03-23 | Clayton | Georgia | 13063 | 63417 | 940 |
2334368 | 2334368 | 2022-03-23 | Clayton | Iowa | 19043 | 3454 | 72 |
2330717 | 2330717 | 2022-03-22 | Clayton | Georgia | 13063 | 63410 | 938 |
2331114 | 2331114 | 2022-03-22 | Clayton | Iowa | 19043 | 3453 | 72 |
2327465 | 2327465 | 2022-03-21 | Clayton | Georgia | 13063 | 63395 | 935 |
2327862 | 2327862 | 2022-03-21 | Clayton | Iowa | 19043 | 3453 | 72 |
2324212 | 2324212 | 2022-03-20 | Clayton | Georgia | 13063 | 63384 | 934 |
2324609 | 2324609 | 2022-03-20 | Clayton | Iowa | 19043 | 3453 | 72 |
2320958 | 2320958 | 2022-03-19 | Clayton | Georgia | 13063 | 63384 | 934 |
2321355 | 2321355 | 2022-03-19 | Clayton | Iowa | 19043 | 3453 | 72 |
2317704 | 2317704 | 2022-03-18 | Clayton | Georgia | 13063 | 63384 | 934 |
2318101 | 2318101 | 2022-03-18 | Clayton | Iowa | 19043 | 3453 | 72 |
2314451 | 2314451 | 2022-03-17 | Clayton | Georgia | 13063 | 63364 | 931 |
2314848 | 2314848 | 2022-03-17 | Clayton | Iowa | 19043 | 3453 | 72 |
2311198 | 2311198 | 2022-03-16 | Clayton | Georgia | 13063 | 63353 | 928 |
2311595 | 2311595 | 2022-03-16 | Clayton | Iowa | 19043 | 3453 | 72 |
2307945 | 2307945 | 2022-03-15 | Clayton | Georgia | 13063 | 63339 | 926 |
2308342 | 2308342 | 2022-03-15 | Clayton | Iowa | 19043 | 3451 | 72 |
2304694 | 2304694 | 2022-03-14 | Clayton | Georgia | 13063 | 63323 | 926 |
2305091 | 2305091 | 2022-03-14 | Clayton | Iowa | 19043 | 3451 | 72 |
2301442 | 2301442 | 2022-03-13 | Clayton | Georgia | 13063 | 63300 | 925 |
2301839 | 2301839 | 2022-03-13 | Clayton | Iowa | 19043 | 3451 | 72 |
2298190 | 2298190 | 2022-03-12 | Clayton | Georgia | 13063 | 63300 | 925 |
2298587 | 2298587 | 2022-03-12 | Clayton | Iowa | 19043 | 3451 | 72 |
2294938 | 2294938 | 2022-03-11 | Clayton | Georgia | 13063 | 63300 | 925 |
2295335 | 2295335 | 2022-03-11 | Clayton | Iowa | 19043 | 3451 | 72 |
2291686 | 2291686 | 2022-03-10 | Clayton | Georgia | 13063 | 63291 | 921 |
2292083 | 2292083 | 2022-03-10 | Clayton | Iowa | 19043 | 3451 | 72 |
2288434 | 2288434 | 2022-03-09 | Clayton | Georgia | 13063 | 63279 | 919 |
2288831 | 2288831 | 2022-03-09 | Clayton | Iowa | 19043 | 3451 | 72 |
2285183 | 2285183 | 2022-03-08 | Clayton | Georgia | 13063 | 63264 | 917 |
2285580 | 2285580 | 2022-03-08 | Clayton | Iowa | 19043 | 3445 | 72 |
2281931 | 2281931 | 2022-03-07 | Clayton | Georgia | 13063 | 63248 | 911 |
2282328 | 2282328 | 2022-03-07 | Clayton | Iowa | 19043 | 3445 | 72 |
2278678 | 2278678 | 2022-03-06 | Clayton | Georgia | 13063 | 63224 | 908 |
2279075 | 2279075 | 2022-03-06 | Clayton | Iowa | 19043 | 3445 | 72 |
2275425 | 2275425 | 2022-03-05 | Clayton | Georgia | 13063 | 63224 | 908 |
2275822 | 2275822 | 2022-03-05 | Clayton | Iowa | 19043 | 3445 | 72 |
2272172 | 2272172 | 2022-03-04 | Clayton | Georgia | 13063 | 63224 | 908 |
2272569 | 2272569 | 2022-03-04 | Clayton | Iowa | 19043 | 3445 | 72 |
2268920 | 2268920 | 2022-03-03 | Clayton | Georgia | 13063 | 63210 | 902 |
2269317 | 2269317 | 2022-03-03 | Clayton | Iowa | 19043 | 3445 | 72 |
2265667 | 2265667 | 2022-03-02 | Clayton | Georgia | 13063 | 63196 | 900 |
2266064 | 2266064 | 2022-03-02 | Clayton | Iowa | 19043 | 3445 | 72 |
2262416 | 2262416 | 2022-03-01 | Clayton | Georgia | 13063 | 63161 | 899 |
2262813 | 2262813 | 2022-03-01 | Clayton | Iowa | 19043 | 3429 | 72 |
2259165 | 2259165 | 2022-02-28 | Clayton | Georgia | 13063 | 63133 | 898 |
2259562 | 2259562 | 2022-02-28 | Clayton | Iowa | 19043 | 3429 | 72 |
2255914 | 2255914 | 2022-02-27 | Clayton | Georgia | 13063 | 63084 | 896 |
2256311 | 2256311 | 2022-02-27 | Clayton | Iowa | 19043 | 3429 | 72 |
2252663 | 2252663 | 2022-02-26 | Clayton | Georgia | 13063 | 63084 | 896 |
2253060 | 2253060 | 2022-02-26 | Clayton | Iowa | 19043 | 3429 | 72 |
2249412 | 2249412 | 2022-02-25 | Clayton | Georgia | 13063 | 63084 | 896 |
2249809 | 2249809 | 2022-02-25 | Clayton | Iowa | 19043 | 3429 | 72 |
2246161 | 2246161 | 2022-02-24 | Clayton | Georgia | 13063 | 63057 | 892 |
2246558 | 2246558 | 2022-02-24 | Clayton | Iowa | 19043 | 3429 | 72 |
2242910 | 2242910 | 2022-02-23 | Clayton | Georgia | 13063 | 63021 | 888 |
2243307 | 2243307 | 2022-02-23 | Clayton | Iowa | 19043 | 3429 | 72 |
2239659 | 2239659 | 2022-02-22 | Clayton | Georgia | 13063 | 62974 | 885 |
2240056 | 2240056 | 2022-02-22 | Clayton | Iowa | 19043 | 3385 | 71 |
2236408 | 2236408 | 2022-02-21 | Clayton | Georgia | 13063 | 62949 | 882 |
2236805 | 2236805 | 2022-02-21 | Clayton | Iowa | 19043 | 3385 | 71 |
2233157 | 2233157 | 2022-02-20 | Clayton | Georgia | 13063 | 62891 | 878 |
2233554 | 2233554 | 2022-02-20 | Clayton | Iowa | 19043 | 3385 | 71 |
2229906 | 2229906 | 2022-02-19 | Clayton | Georgia | 13063 | 62891 | 878 |
2230303 | 2230303 | 2022-02-19 | Clayton | Iowa | 19043 | 3385 | 71 |
2226655 | 2226655 | 2022-02-18 | Clayton | Georgia | 13063 | 62891 | 878 |
2227052 | 2227052 | 2022-02-18 | Clayton | Iowa | 19043 | 3385 | 71 |
2223404 | 2223404 | 2022-02-17 | Clayton | Georgia | 13063 | 62809 | 873 |
2223801 | 2223801 | 2022-02-17 | Clayton | Iowa | 19043 | 3385 | 71 |
2220153 | 2220153 | 2022-02-16 | Clayton | Georgia | 13063 | 62748 | 868 |
2220550 | 2220550 | 2022-02-16 | Clayton | Iowa | 19043 | 3385 | 71 |
2216902 | 2216902 | 2022-02-15 | Clayton | Georgia | 13063 | 62684 | 865 |
2217299 | 2217299 | 2022-02-15 | Clayton | Iowa | 19043 | 3350 | 71 |
2213651 | 2213651 | 2022-02-14 | Clayton | Georgia | 13063 | 62643 | 863 |
2214048 | 2214048 | 2022-02-14 | Clayton | Iowa | 19043 | 3350 | 71 |
2210399 | 2210399 | 2022-02-13 | Clayton | Georgia | 13063 | 62557 | 862 |
2210796 | 2210796 | 2022-02-13 | Clayton | Iowa | 19043 | 3350 | 71 |
2207146 | 2207146 | 2022-02-12 | Clayton | Georgia | 13063 | 62557 | 862 |
2207543 | 2207543 | 2022-02-12 | Clayton | Iowa | 19043 | 3350 | 71 |
2203893 | 2203893 | 2022-02-11 | Clayton | Georgia | 13063 | 62557 | 862 |
2204290 | 2204290 | 2022-02-11 | Clayton | Iowa | 19043 | 3350 | 71 |
2200640 | 2200640 | 2022-02-10 | Clayton | Georgia | 13063 | 62488 | 855 |
2201037 | 2201037 | 2022-02-10 | Clayton | Iowa | 19043 | 3350 | 71 |
2197386 | 2197386 | 2022-02-09 | Clayton | Georgia | 13063 | 62404 | 854 |
2197783 | 2197783 | 2022-02-09 | Clayton | Iowa | 19043 | 3350 | 71 |
2194132 | 2194132 | 2022-02-08 | Clayton | Georgia | 13063 | 62327 | 847 |
2194529 | 2194529 | 2022-02-08 | Clayton | Iowa | 19043 | 3290 | 71 |
2190878 | 2190878 | 2022-02-07 | Clayton | Georgia | 13063 | 62238 | 844 |
2191275 | 2191275 | 2022-02-07 | Clayton | Iowa | 19043 | 3290 | 71 |
2187625 | 2187625 | 2022-02-06 | Clayton | Georgia | 13063 | 62021 | 842 |
2188022 | 2188022 | 2022-02-06 | Clayton | Iowa | 19043 | 3290 | 71 |
2184372 | 2184372 | 2022-02-05 | Clayton | Georgia | 13063 | 62021 | 842 |
2184769 | 2184769 | 2022-02-05 | Clayton | Iowa | 19043 | 3290 | 71 |
2181120 | 2181120 | 2022-02-04 | Clayton | Georgia | 13063 | 62021 | 842 |
2181517 | 2181517 | 2022-02-04 | Clayton | Iowa | 19043 | 3290 | 71 |
2177869 | 2177869 | 2022-02-03 | Clayton | Georgia | 13063 | 61913 | 841 |
2178266 | 2178266 | 2022-02-03 | Clayton | Iowa | 19043 | 3290 | 71 |
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);