ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Oldham" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337898 | 2337898 | 2022-03-24 | Oldham | Kentucky | 21185 | 18198 | 133 |
2339612 | 2339612 | 2022-03-24 | Oldham | Texas | 48359 | 560 | 6 |
2334644 | 2334644 | 2022-03-23 | Oldham | Kentucky | 21185 | 18198 | 133 |
2336358 | 2336358 | 2022-03-23 | Oldham | Texas | 48359 | 560 | 6 |
2331390 | 2331390 | 2022-03-22 | Oldham | Kentucky | 21185 | 18198 | 133 |
2333104 | 2333104 | 2022-03-22 | Oldham | Texas | 48359 | 559 | 6 |
2328138 | 2328138 | 2022-03-21 | Oldham | Kentucky | 21185 | 18198 | 133 |
2329851 | 2329851 | 2022-03-21 | Oldham | Texas | 48359 | 559 | 6 |
2324885 | 2324885 | 2022-03-20 | Oldham | Kentucky | 21185 | 18137 | 129 |
2326599 | 2326599 | 2022-03-20 | Oldham | Texas | 48359 | 559 | 6 |
2321631 | 2321631 | 2022-03-19 | Oldham | Kentucky | 21185 | 18137 | 129 |
2323346 | 2323346 | 2022-03-19 | Oldham | Texas | 48359 | 558 | 6 |
2318377 | 2318377 | 2022-03-18 | Oldham | Kentucky | 21185 | 18137 | 129 |
2320092 | 2320092 | 2022-03-18 | Oldham | Texas | 48359 | 558 | 6 |
2315124 | 2315124 | 2022-03-17 | Oldham | Kentucky | 21185 | 18137 | 129 |
2316838 | 2316838 | 2022-03-17 | Oldham | Texas | 48359 | 554 | 6 |
2311871 | 2311871 | 2022-03-16 | Oldham | Kentucky | 21185 | 18137 | 129 |
2313585 | 2313585 | 2022-03-16 | Oldham | Texas | 48359 | 551 | 6 |
2308618 | 2308618 | 2022-03-15 | Oldham | Kentucky | 21185 | 18137 | 129 |
2310332 | 2310332 | 2022-03-15 | Oldham | Texas | 48359 | 550 | 6 |
2305367 | 2305367 | 2022-03-14 | Oldham | Kentucky | 21185 | 18137 | 129 |
2307079 | 2307079 | 2022-03-14 | Oldham | Texas | 48359 | 549 | 6 |
2302115 | 2302115 | 2022-03-13 | Oldham | Kentucky | 21185 | 18060 | 129 |
2303828 | 2303828 | 2022-03-13 | Oldham | Texas | 48359 | 549 | 6 |
2298863 | 2298863 | 2022-03-12 | Oldham | Kentucky | 21185 | 18060 | 129 |
2300576 | 2300576 | 2022-03-12 | Oldham | Texas | 48359 | 549 | 6 |
2295611 | 2295611 | 2022-03-11 | Oldham | Kentucky | 21185 | 18060 | 129 |
2297324 | 2297324 | 2022-03-11 | Oldham | Texas | 48359 | 548 | 6 |
2292359 | 2292359 | 2022-03-10 | Oldham | Kentucky | 21185 | 18060 | 129 |
2294072 | 2294072 | 2022-03-10 | Oldham | Texas | 48359 | 548 | 6 |
2289107 | 2289107 | 2022-03-09 | Oldham | Kentucky | 21185 | 18060 | 129 |
2290820 | 2290820 | 2022-03-09 | Oldham | Texas | 48359 | 547 | 6 |
2285856 | 2285856 | 2022-03-08 | Oldham | Kentucky | 21185 | 18060 | 129 |
2287568 | 2287568 | 2022-03-08 | Oldham | Texas | 48359 | 544 | 6 |
2282604 | 2282604 | 2022-03-07 | Oldham | Kentucky | 21185 | 18060 | 129 |
2284316 | 2284316 | 2022-03-07 | Oldham | Texas | 48359 | 544 | 6 |
2279351 | 2279351 | 2022-03-06 | Oldham | Kentucky | 21185 | 18035 | 127 |
2281064 | 2281064 | 2022-03-06 | Oldham | Texas | 48359 | 544 | 6 |
2276098 | 2276098 | 2022-03-05 | Oldham | Kentucky | 21185 | 18035 | 127 |
2277811 | 2277811 | 2022-03-05 | Oldham | Texas | 48359 | 544 | 6 |
2272845 | 2272845 | 2022-03-04 | Oldham | Kentucky | 21185 | 18035 | 127 |
2274558 | 2274558 | 2022-03-04 | Oldham | Texas | 48359 | 544 | 6 |
2269593 | 2269593 | 2022-03-03 | Oldham | Kentucky | 21185 | 18031 | 126 |
2271305 | 2271305 | 2022-03-03 | Oldham | Texas | 48359 | 543 | 6 |
2266340 | 2266340 | 2022-03-02 | Oldham | Kentucky | 21185 | 18011 | 126 |
2268053 | 2268053 | 2022-03-02 | Oldham | Texas | 48359 | 543 | 6 |
2263089 | 2263089 | 2022-03-01 | Oldham | Kentucky | 21185 | 17982 | 126 |
2264800 | 2264800 | 2022-03-01 | Oldham | Texas | 48359 | 543 | 6 |
2259838 | 2259838 | 2022-02-28 | Oldham | Kentucky | 21185 | 17952 | 126 |
2261550 | 2261550 | 2022-02-28 | Oldham | Texas | 48359 | 540 | 6 |
2256587 | 2256587 | 2022-02-27 | Oldham | Kentucky | 21185 | 17936 | 125 |
2258299 | 2258299 | 2022-02-27 | Oldham | Texas | 48359 | 540 | 6 |
2253336 | 2253336 | 2022-02-26 | Oldham | Kentucky | 21185 | 17936 | 125 |
2255048 | 2255048 | 2022-02-26 | Oldham | Texas | 48359 | 540 | 6 |
2250085 | 2250085 | 2022-02-25 | Oldham | Kentucky | 21185 | 17936 | 125 |
2251797 | 2251797 | 2022-02-25 | Oldham | Texas | 48359 | 539 | 6 |
2246834 | 2246834 | 2022-02-24 | Oldham | Kentucky | 21185 | 17874 | 125 |
2248546 | 2248546 | 2022-02-24 | Oldham | Texas | 48359 | 533 | 6 |
2243583 | 2243583 | 2022-02-23 | Oldham | Kentucky | 21185 | 17874 | 125 |
2245295 | 2245295 | 2022-02-23 | Oldham | Texas | 48359 | 532 | 6 |
2240332 | 2240332 | 2022-02-22 | Oldham | Kentucky | 21185 | 17856 | 125 |
2242044 | 2242044 | 2022-02-22 | Oldham | Texas | 48359 | 528 | 6 |
2237081 | 2237081 | 2022-02-21 | Oldham | Kentucky | 21185 | 17808 | 125 |
2238793 | 2238793 | 2022-02-21 | Oldham | Texas | 48359 | 527 | 6 |
2233830 | 2233830 | 2022-02-20 | Oldham | Kentucky | 21185 | 17743 | 124 |
2235542 | 2235542 | 2022-02-20 | Oldham | Texas | 48359 | 527 | 6 |
2230579 | 2230579 | 2022-02-19 | Oldham | Kentucky | 21185 | 17743 | 124 |
2232291 | 2232291 | 2022-02-19 | Oldham | Texas | 48359 | 527 | 6 |
2227328 | 2227328 | 2022-02-18 | Oldham | Kentucky | 21185 | 17743 | 124 |
2229040 | 2229040 | 2022-02-18 | Oldham | Texas | 48359 | 525 | 6 |
2224077 | 2224077 | 2022-02-17 | Oldham | Kentucky | 21185 | 17711 | 124 |
2225789 | 2225789 | 2022-02-17 | Oldham | Texas | 48359 | 522 | 6 |
2220826 | 2220826 | 2022-02-16 | Oldham | Kentucky | 21185 | 17684 | 124 |
2222538 | 2222538 | 2022-02-16 | Oldham | Texas | 48359 | 521 | 6 |
2217575 | 2217575 | 2022-02-15 | Oldham | Kentucky | 21185 | 17626 | 124 |
2219287 | 2219287 | 2022-02-15 | Oldham | Texas | 48359 | 521 | 6 |
2214324 | 2214324 | 2022-02-14 | Oldham | Kentucky | 21185 | 17604 | 124 |
2216036 | 2216036 | 2022-02-14 | Oldham | Texas | 48359 | 521 | 6 |
2211072 | 2211072 | 2022-02-13 | Oldham | Kentucky | 21185 | 17345 | 123 |
2212785 | 2212785 | 2022-02-13 | Oldham | Texas | 48359 | 521 | 6 |
2207819 | 2207819 | 2022-02-12 | Oldham | Kentucky | 21185 | 17345 | 123 |
2209532 | 2209532 | 2022-02-12 | Oldham | Texas | 48359 | 521 | 6 |
2204566 | 2204566 | 2022-02-11 | Oldham | Kentucky | 21185 | 17345 | 123 |
2206279 | 2206279 | 2022-02-11 | Oldham | Texas | 48359 | 520 | 6 |
2201313 | 2201313 | 2022-02-10 | Oldham | Kentucky | 21185 | 17322 | 121 |
2203026 | 2203026 | 2022-02-10 | Oldham | Texas | 48359 | 519 | 6 |
2198059 | 2198059 | 2022-02-09 | Oldham | Kentucky | 21185 | 17259 | 121 |
2199772 | 2199772 | 2022-02-09 | Oldham | Texas | 48359 | 517 | 6 |
2194805 | 2194805 | 2022-02-08 | Oldham | Kentucky | 21185 | 17138 | 121 |
2196518 | 2196518 | 2022-02-08 | Oldham | Texas | 48359 | 517 | 6 |
2191551 | 2191551 | 2022-02-07 | Oldham | Kentucky | 21185 | 17113 | 121 |
2193264 | 2193264 | 2022-02-07 | Oldham | Texas | 48359 | 516 | 6 |
2188298 | 2188298 | 2022-02-06 | Oldham | Kentucky | 21185 | 17040 | 121 |
2190010 | 2190010 | 2022-02-06 | Oldham | Texas | 48359 | 515 | 6 |
2185045 | 2185045 | 2022-02-05 | Oldham | Kentucky | 21185 | 17040 | 121 |
2186757 | 2186757 | 2022-02-05 | Oldham | Texas | 48359 | 515 | 6 |
2181793 | 2181793 | 2022-02-04 | Oldham | Kentucky | 21185 | 17040 | 121 |
2183505 | 2183505 | 2022-02-04 | Oldham | Texas | 48359 | 515 | 6 |
2178542 | 2178542 | 2022-02-03 | Oldham | Kentucky | 21185 | 16995 | 121 |
2180253 | 2180253 | 2022-02-03 | Oldham | Texas | 48359 | 514 | 6 |
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);