ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clarke" and fips = 13059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2434859 | 2434859 | 2022-04-23 | Clarke | Georgia | 13059 | 29700 | 230 |
2431603 | 2431603 | 2022-04-22 | Clarke | Georgia | 13059 | 29700 | 230 |
2428347 | 2428347 | 2022-04-21 | Clarke | Georgia | 13059 | 29700 | 230 |
2425091 | 2425091 | 2022-04-20 | Clarke | Georgia | 13059 | 29700 | 230 |
2421835 | 2421835 | 2022-04-19 | Clarke | Georgia | 13059 | 29688 | 228 |
2418579 | 2418579 | 2022-04-18 | Clarke | Georgia | 13059 | 29688 | 228 |
2415323 | 2415323 | 2022-04-17 | Clarke | Georgia | 13059 | 29687 | 228 |
2412067 | 2412067 | 2022-04-16 | Clarke | Georgia | 13059 | 29687 | 228 |
2408811 | 2408811 | 2022-04-15 | Clarke | Georgia | 13059 | 29687 | 228 |
2405555 | 2405555 | 2022-04-14 | Clarke | Georgia | 13059 | 29675 | 227 |
2402300 | 2402300 | 2022-04-13 | Clarke | Georgia | 13059 | 29671 | 226 |
2399045 | 2399045 | 2022-04-12 | Clarke | Georgia | 13059 | 29666 | 226 |
2395790 | 2395790 | 2022-04-11 | Clarke | Georgia | 13059 | 29662 | 226 |
2392534 | 2392534 | 2022-04-10 | Clarke | Georgia | 13059 | 29651 | 226 |
2389278 | 2389278 | 2022-04-09 | Clarke | Georgia | 13059 | 29651 | 226 |
2386023 | 2386023 | 2022-04-08 | Clarke | Georgia | 13059 | 29651 | 226 |
2382768 | 2382768 | 2022-04-07 | Clarke | Georgia | 13059 | 29651 | 226 |
2379513 | 2379513 | 2022-04-06 | Clarke | Georgia | 13059 | 29647 | 226 |
2376259 | 2376259 | 2022-04-05 | Clarke | Georgia | 13059 | 29642 | 224 |
2373007 | 2373007 | 2022-04-04 | Clarke | Georgia | 13059 | 29637 | 225 |
2369754 | 2369754 | 2022-04-03 | Clarke | Georgia | 13059 | 29629 | 225 |
2366501 | 2366501 | 2022-04-02 | Clarke | Georgia | 13059 | 29629 | 225 |
2363248 | 2363248 | 2022-04-01 | Clarke | Georgia | 13059 | 29629 | 225 |
2359994 | 2359994 | 2022-03-31 | Clarke | Georgia | 13059 | 29621 | 225 |
2356740 | 2356740 | 2022-03-30 | Clarke | Georgia | 13059 | 29613 | 224 |
2353487 | 2353487 | 2022-03-29 | Clarke | Georgia | 13059 | 29589 | 223 |
2350235 | 2350235 | 2022-03-28 | Clarke | Georgia | 13059 | 29578 | 223 |
2346982 | 2346982 | 2022-03-27 | Clarke | Georgia | 13059 | 29572 | 223 |
2343729 | 2343729 | 2022-03-26 | Clarke | Georgia | 13059 | 29572 | 223 |
2340476 | 2340476 | 2022-03-25 | Clarke | Georgia | 13059 | 29572 | 223 |
2337223 | 2337223 | 2022-03-24 | Clarke | Georgia | 13059 | 29564 | 223 |
2333969 | 2333969 | 2022-03-23 | Clarke | Georgia | 13059 | 29562 | 222 |
2330715 | 2330715 | 2022-03-22 | Clarke | Georgia | 13059 | 29563 | 222 |
2327463 | 2327463 | 2022-03-21 | Clarke | Georgia | 13059 | 29561 | 222 |
2324210 | 2324210 | 2022-03-20 | Clarke | Georgia | 13059 | 29561 | 222 |
2320956 | 2320956 | 2022-03-19 | Clarke | Georgia | 13059 | 29561 | 222 |
2317702 | 2317702 | 2022-03-18 | Clarke | Georgia | 13059 | 29561 | 222 |
2314449 | 2314449 | 2022-03-17 | Clarke | Georgia | 13059 | 29559 | 221 |
2311196 | 2311196 | 2022-03-16 | Clarke | Georgia | 13059 | 29548 | 221 |
2307943 | 2307943 | 2022-03-15 | Clarke | Georgia | 13059 | 29543 | 220 |
2304692 | 2304692 | 2022-03-14 | Clarke | Georgia | 13059 | 29540 | 219 |
2301440 | 2301440 | 2022-03-13 | Clarke | Georgia | 13059 | 29538 | 218 |
2298188 | 2298188 | 2022-03-12 | Clarke | Georgia | 13059 | 29538 | 218 |
2294936 | 2294936 | 2022-03-11 | Clarke | Georgia | 13059 | 29538 | 218 |
2291684 | 2291684 | 2022-03-10 | Clarke | Georgia | 13059 | 29530 | 217 |
2288432 | 2288432 | 2022-03-09 | Clarke | Georgia | 13059 | 29527 | 217 |
2285181 | 2285181 | 2022-03-08 | Clarke | Georgia | 13059 | 29521 | 216 |
2281929 | 2281929 | 2022-03-07 | Clarke | Georgia | 13059 | 29505 | 216 |
2278676 | 2278676 | 2022-03-06 | Clarke | Georgia | 13059 | 29495 | 216 |
2275423 | 2275423 | 2022-03-05 | Clarke | Georgia | 13059 | 29495 | 216 |
2272170 | 2272170 | 2022-03-04 | Clarke | Georgia | 13059 | 29495 | 216 |
2268918 | 2268918 | 2022-03-03 | Clarke | Georgia | 13059 | 29493 | 215 |
2265665 | 2265665 | 2022-03-02 | Clarke | Georgia | 13059 | 29487 | 215 |
2262414 | 2262414 | 2022-03-01 | Clarke | Georgia | 13059 | 29485 | 215 |
2259163 | 2259163 | 2022-02-28 | Clarke | Georgia | 13059 | 29476 | 213 |
2255912 | 2255912 | 2022-02-27 | Clarke | Georgia | 13059 | 29463 | 212 |
2252661 | 2252661 | 2022-02-26 | Clarke | Georgia | 13059 | 29463 | 212 |
2249410 | 2249410 | 2022-02-25 | Clarke | Georgia | 13059 | 29463 | 212 |
2246159 | 2246159 | 2022-02-24 | Clarke | Georgia | 13059 | 29454 | 212 |
2242908 | 2242908 | 2022-02-23 | Clarke | Georgia | 13059 | 29446 | 211 |
2239657 | 2239657 | 2022-02-22 | Clarke | Georgia | 13059 | 29433 | 209 |
2236406 | 2236406 | 2022-02-21 | Clarke | Georgia | 13059 | 29427 | 209 |
2233155 | 2233155 | 2022-02-20 | Clarke | Georgia | 13059 | 29392 | 208 |
2229904 | 2229904 | 2022-02-19 | Clarke | Georgia | 13059 | 29392 | 208 |
2226653 | 2226653 | 2022-02-18 | Clarke | Georgia | 13059 | 29392 | 208 |
2223402 | 2223402 | 2022-02-17 | Clarke | Georgia | 13059 | 29374 | 208 |
2220151 | 2220151 | 2022-02-16 | Clarke | Georgia | 13059 | 29353 | 205 |
2216900 | 2216900 | 2022-02-15 | Clarke | Georgia | 13059 | 29327 | 204 |
2213649 | 2213649 | 2022-02-14 | Clarke | Georgia | 13059 | 29303 | 202 |
2210397 | 2210397 | 2022-02-13 | Clarke | Georgia | 13059 | 29255 | 201 |
2207144 | 2207144 | 2022-02-12 | Clarke | Georgia | 13059 | 29255 | 201 |
2203891 | 2203891 | 2022-02-11 | Clarke | Georgia | 13059 | 29255 | 201 |
2200638 | 2200638 | 2022-02-10 | Clarke | Georgia | 13059 | 29228 | 201 |
2197384 | 2197384 | 2022-02-09 | Clarke | Georgia | 13059 | 29193 | 201 |
2194130 | 2194130 | 2022-02-08 | Clarke | Georgia | 13059 | 29138 | 200 |
2190876 | 2190876 | 2022-02-07 | Clarke | Georgia | 13059 | 29107 | 200 |
2187623 | 2187623 | 2022-02-06 | Clarke | Georgia | 13059 | 29011 | 200 |
2184370 | 2184370 | 2022-02-05 | Clarke | Georgia | 13059 | 29011 | 200 |
2181118 | 2181118 | 2022-02-04 | Clarke | Georgia | 13059 | 29011 | 200 |
2177867 | 2177867 | 2022-02-03 | Clarke | Georgia | 13059 | 28941 | 200 |
2174614 | 2174614 | 2022-02-02 | Clarke | Georgia | 13059 | 28873 | 199 |
2171361 | 2171361 | 2022-02-01 | Clarke | Georgia | 13059 | 28777 | 199 |
2168108 | 2168108 | 2022-01-31 | Clarke | Georgia | 13059 | 28722 | 199 |
2164853 | 2164853 | 2022-01-30 | Clarke | Georgia | 13059 | 28468 | 197 |
2161598 | 2161598 | 2022-01-29 | Clarke | Georgia | 13059 | 28468 | 197 |
2158342 | 2158342 | 2022-01-28 | Clarke | Georgia | 13059 | 28468 | 197 |
2155089 | 2155089 | 2022-01-27 | Clarke | Georgia | 13059 | 28318 | 196 |
2151836 | 2151836 | 2022-01-26 | Clarke | Georgia | 13059 | 27947 | 196 |
2148584 | 2148584 | 2022-01-25 | Clarke | Georgia | 13059 | 27765 | 195 |
2145332 | 2145332 | 2022-01-24 | Clarke | Georgia | 13059 | 27651 | 194 |
2142077 | 2142077 | 2022-01-23 | Clarke | Georgia | 13059 | 27272 | 194 |
2138822 | 2138822 | 2022-01-22 | Clarke | Georgia | 13059 | 27272 | 194 |
2135566 | 2135566 | 2022-01-21 | Clarke | Georgia | 13059 | 27272 | 194 |
2132314 | 2132314 | 2022-01-20 | Clarke | Georgia | 13059 | 27038 | 192 |
2129061 | 2129061 | 2022-01-19 | Clarke | Georgia | 13059 | 26589 | 192 |
2125807 | 2125807 | 2022-01-18 | Clarke | Georgia | 13059 | 26261 | 192 |
2122555 | 2122555 | 2022-01-17 | Clarke | Georgia | 13059 | 26174 | 192 |
2119303 | 2119303 | 2022-01-16 | Clarke | Georgia | 13059 | 25612 | 191 |
2116051 | 2116051 | 2022-01-15 | Clarke | Georgia | 13059 | 25612 | 191 |
2112800 | 2112800 | 2022-01-14 | Clarke | Georgia | 13059 | 25612 | 191 |
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);