ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,544 rows where county = "Whitley" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337600 | 2337600 | 2022-03-24 | Whitley | Indiana | 18183 | 9647 | 83 |
2337923 | 2337923 | 2022-03-24 | Whitley | Kentucky | 21235 | 14198 | 175 |
2334346 | 2334346 | 2022-03-23 | Whitley | Indiana | 18183 | 9646 | 83 |
2334669 | 2334669 | 2022-03-23 | Whitley | Kentucky | 21235 | 14198 | 175 |
2331092 | 2331092 | 2022-03-22 | Whitley | Indiana | 18183 | 9647 | 83 |
2331415 | 2331415 | 2022-03-22 | Whitley | Kentucky | 21235 | 14198 | 175 |
2327840 | 2327840 | 2022-03-21 | Whitley | Indiana | 18183 | 9644 | 83 |
2328163 | 2328163 | 2022-03-21 | Whitley | Kentucky | 21235 | 14198 | 175 |
2324587 | 2324587 | 2022-03-20 | Whitley | Indiana | 18183 | 9643 | 83 |
2324910 | 2324910 | 2022-03-20 | Whitley | Kentucky | 21235 | 14079 | 172 |
2321333 | 2321333 | 2022-03-19 | Whitley | Indiana | 18183 | 9643 | 83 |
2321656 | 2321656 | 2022-03-19 | Whitley | Kentucky | 21235 | 14079 | 172 |
2318079 | 2318079 | 2022-03-18 | Whitley | Indiana | 18183 | 9643 | 83 |
2318402 | 2318402 | 2022-03-18 | Whitley | Kentucky | 21235 | 14079 | 172 |
2314826 | 2314826 | 2022-03-17 | Whitley | Indiana | 18183 | 9640 | 83 |
2315149 | 2315149 | 2022-03-17 | Whitley | Kentucky | 21235 | 14079 | 172 |
2311573 | 2311573 | 2022-03-16 | Whitley | Indiana | 18183 | 9640 | 83 |
2311896 | 2311896 | 2022-03-16 | Whitley | Kentucky | 21235 | 14079 | 172 |
2308320 | 2308320 | 2022-03-15 | Whitley | Indiana | 18183 | 9638 | 83 |
2308643 | 2308643 | 2022-03-15 | Whitley | Kentucky | 21235 | 14079 | 172 |
2305069 | 2305069 | 2022-03-14 | Whitley | Indiana | 18183 | 9636 | 83 |
2305392 | 2305392 | 2022-03-14 | Whitley | Kentucky | 21235 | 14079 | 172 |
2301817 | 2301817 | 2022-03-13 | Whitley | Indiana | 18183 | 9634 | 83 |
2302140 | 2302140 | 2022-03-13 | Whitley | Kentucky | 21235 | 13960 | 168 |
2298565 | 2298565 | 2022-03-12 | Whitley | Indiana | 18183 | 9634 | 83 |
2298888 | 2298888 | 2022-03-12 | Whitley | Kentucky | 21235 | 13960 | 168 |
2295313 | 2295313 | 2022-03-11 | Whitley | Indiana | 18183 | 9634 | 83 |
2295636 | 2295636 | 2022-03-11 | Whitley | Kentucky | 21235 | 13960 | 168 |
2292061 | 2292061 | 2022-03-10 | Whitley | Indiana | 18183 | 9632 | 83 |
2292384 | 2292384 | 2022-03-10 | Whitley | Kentucky | 21235 | 13960 | 168 |
2288809 | 2288809 | 2022-03-09 | Whitley | Indiana | 18183 | 9630 | 83 |
2289132 | 2289132 | 2022-03-09 | Whitley | Kentucky | 21235 | 13960 | 168 |
2285558 | 2285558 | 2022-03-08 | Whitley | Indiana | 18183 | 9630 | 83 |
2285881 | 2285881 | 2022-03-08 | Whitley | Kentucky | 21235 | 13960 | 168 |
2282306 | 2282306 | 2022-03-07 | Whitley | Indiana | 18183 | 9630 | 83 |
2282629 | 2282629 | 2022-03-07 | Whitley | Kentucky | 21235 | 13960 | 168 |
2279053 | 2279053 | 2022-03-06 | Whitley | Indiana | 18183 | 9626 | 83 |
2279376 | 2279376 | 2022-03-06 | Whitley | Kentucky | 21235 | 13908 | 168 |
2275800 | 2275800 | 2022-03-05 | Whitley | Indiana | 18183 | 9626 | 83 |
2276123 | 2276123 | 2022-03-05 | Whitley | Kentucky | 21235 | 13908 | 168 |
2272547 | 2272547 | 2022-03-04 | Whitley | Indiana | 18183 | 9626 | 83 |
2272870 | 2272870 | 2022-03-04 | Whitley | Kentucky | 21235 | 13908 | 168 |
2269295 | 2269295 | 2022-03-03 | Whitley | Indiana | 18183 | 9625 | 82 |
2269618 | 2269618 | 2022-03-03 | Whitley | Kentucky | 21235 | 13868 | 167 |
2266042 | 2266042 | 2022-03-02 | Whitley | Indiana | 18183 | 9623 | 82 |
2266365 | 2266365 | 2022-03-02 | Whitley | Kentucky | 21235 | 13838 | 161 |
2262791 | 2262791 | 2022-03-01 | Whitley | Indiana | 18183 | 9620 | 82 |
2263114 | 2263114 | 2022-03-01 | Whitley | Kentucky | 21235 | 13819 | 161 |
2259540 | 2259540 | 2022-02-28 | Whitley | Indiana | 18183 | 9619 | 82 |
2259863 | 2259863 | 2022-02-28 | Whitley | Kentucky | 21235 | 13751 | 160 |
2256289 | 2256289 | 2022-02-27 | Whitley | Indiana | 18183 | 9614 | 82 |
2256612 | 2256612 | 2022-02-27 | Whitley | Kentucky | 21235 | 13713 | 160 |
2253038 | 2253038 | 2022-02-26 | Whitley | Indiana | 18183 | 9614 | 82 |
2253361 | 2253361 | 2022-02-26 | Whitley | Kentucky | 21235 | 13713 | 160 |
2249787 | 2249787 | 2022-02-25 | Whitley | Indiana | 18183 | 9614 | 82 |
2250110 | 2250110 | 2022-02-25 | Whitley | Kentucky | 21235 | 13713 | 160 |
2246536 | 2246536 | 2022-02-24 | Whitley | Indiana | 18183 | 9610 | 81 |
2246859 | 2246859 | 2022-02-24 | Whitley | Kentucky | 21235 | 13663 | 158 |
2243285 | 2243285 | 2022-02-23 | Whitley | Indiana | 18183 | 9603 | 81 |
2243608 | 2243608 | 2022-02-23 | Whitley | Kentucky | 21235 | 13663 | 158 |
2240034 | 2240034 | 2022-02-22 | Whitley | Indiana | 18183 | 9599 | 81 |
2240357 | 2240357 | 2022-02-22 | Whitley | Kentucky | 21235 | 13629 | 158 |
2236783 | 2236783 | 2022-02-21 | Whitley | Indiana | 18183 | 9596 | 80 |
2237106 | 2237106 | 2022-02-21 | Whitley | Kentucky | 21235 | 13598 | 156 |
2233532 | 2233532 | 2022-02-20 | Whitley | Indiana | 18183 | 9590 | 80 |
2233855 | 2233855 | 2022-02-20 | Whitley | Kentucky | 21235 | 13500 | 156 |
2230281 | 2230281 | 2022-02-19 | Whitley | Indiana | 18183 | 9590 | 80 |
2230604 | 2230604 | 2022-02-19 | Whitley | Kentucky | 21235 | 13500 | 156 |
2227030 | 2227030 | 2022-02-18 | Whitley | Indiana | 18183 | 9590 | 80 |
2227353 | 2227353 | 2022-02-18 | Whitley | Kentucky | 21235 | 13500 | 156 |
2223779 | 2223779 | 2022-02-17 | Whitley | Indiana | 18183 | 9588 | 79 |
2224102 | 2224102 | 2022-02-17 | Whitley | Kentucky | 21235 | 13443 | 155 |
2220528 | 2220528 | 2022-02-16 | Whitley | Indiana | 18183 | 9588 | 79 |
2220851 | 2220851 | 2022-02-16 | Whitley | Kentucky | 21235 | 13381 | 150 |
2217277 | 2217277 | 2022-02-15 | Whitley | Indiana | 18183 | 9583 | 79 |
2217600 | 2217600 | 2022-02-15 | Whitley | Kentucky | 21235 | 13315 | 150 |
2214026 | 2214026 | 2022-02-14 | Whitley | Indiana | 18183 | 9578 | 78 |
2214349 | 2214349 | 2022-02-14 | Whitley | Kentucky | 21235 | 13256 | 149 |
2210774 | 2210774 | 2022-02-13 | Whitley | Indiana | 18183 | 9566 | 78 |
2211097 | 2211097 | 2022-02-13 | Whitley | Kentucky | 21235 | 13002 | 148 |
2207521 | 2207521 | 2022-02-12 | Whitley | Indiana | 18183 | 9566 | 78 |
2207844 | 2207844 | 2022-02-12 | Whitley | Kentucky | 21235 | 13002 | 148 |
2204268 | 2204268 | 2022-02-11 | Whitley | Indiana | 18183 | 9566 | 78 |
2204591 | 2204591 | 2022-02-11 | Whitley | Kentucky | 21235 | 13002 | 148 |
2201015 | 2201015 | 2022-02-10 | Whitley | Indiana | 18183 | 9559 | 78 |
2201338 | 2201338 | 2022-02-10 | Whitley | Kentucky | 21235 | 12950 | 147 |
2197761 | 2197761 | 2022-02-09 | Whitley | Indiana | 18183 | 9531 | 78 |
2198084 | 2198084 | 2022-02-09 | Whitley | Kentucky | 21235 | 12908 | 147 |
2194507 | 2194507 | 2022-02-08 | Whitley | Indiana | 18183 | 9531 | 78 |
2194830 | 2194830 | 2022-02-08 | Whitley | Kentucky | 21235 | 12865 | 147 |
2191253 | 2191253 | 2022-02-07 | Whitley | Indiana | 18183 | 9522 | 77 |
2191576 | 2191576 | 2022-02-07 | Whitley | Kentucky | 21235 | 12759 | 147 |
2188000 | 2188000 | 2022-02-06 | Whitley | Indiana | 18183 | 9497 | 77 |
2188323 | 2188323 | 2022-02-06 | Whitley | Kentucky | 21235 | 12644 | 147 |
2184747 | 2184747 | 2022-02-05 | Whitley | Indiana | 18183 | 9497 | 77 |
2185070 | 2185070 | 2022-02-05 | Whitley | Kentucky | 21235 | 12644 | 147 |
2181495 | 2181495 | 2022-02-04 | Whitley | Indiana | 18183 | 9497 | 77 |
2181818 | 2181818 | 2022-02-04 | Whitley | Kentucky | 21235 | 12644 | 147 |
2178244 | 2178244 | 2022-02-03 | Whitley | Indiana | 18183 | 9486 | 77 |
2178567 | 2178567 | 2022-02-03 | Whitley | Kentucky | 21235 | 12581 | 147 |
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);