ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Whitley" and fips = 18183 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 |
2334346 | 2334346 | 2022-03-23 | Whitley | Indiana | 18183 | 9646 | 83 |
2331092 | 2331092 | 2022-03-22 | Whitley | Indiana | 18183 | 9647 | 83 |
2327840 | 2327840 | 2022-03-21 | Whitley | Indiana | 18183 | 9644 | 83 |
2324587 | 2324587 | 2022-03-20 | Whitley | Indiana | 18183 | 9643 | 83 |
2321333 | 2321333 | 2022-03-19 | Whitley | Indiana | 18183 | 9643 | 83 |
2318079 | 2318079 | 2022-03-18 | Whitley | Indiana | 18183 | 9643 | 83 |
2314826 | 2314826 | 2022-03-17 | Whitley | Indiana | 18183 | 9640 | 83 |
2311573 | 2311573 | 2022-03-16 | Whitley | Indiana | 18183 | 9640 | 83 |
2308320 | 2308320 | 2022-03-15 | Whitley | Indiana | 18183 | 9638 | 83 |
2305069 | 2305069 | 2022-03-14 | Whitley | Indiana | 18183 | 9636 | 83 |
2301817 | 2301817 | 2022-03-13 | Whitley | Indiana | 18183 | 9634 | 83 |
2298565 | 2298565 | 2022-03-12 | Whitley | Indiana | 18183 | 9634 | 83 |
2295313 | 2295313 | 2022-03-11 | Whitley | Indiana | 18183 | 9634 | 83 |
2292061 | 2292061 | 2022-03-10 | Whitley | Indiana | 18183 | 9632 | 83 |
2288809 | 2288809 | 2022-03-09 | Whitley | Indiana | 18183 | 9630 | 83 |
2285558 | 2285558 | 2022-03-08 | Whitley | Indiana | 18183 | 9630 | 83 |
2282306 | 2282306 | 2022-03-07 | Whitley | Indiana | 18183 | 9630 | 83 |
2279053 | 2279053 | 2022-03-06 | Whitley | Indiana | 18183 | 9626 | 83 |
2275800 | 2275800 | 2022-03-05 | Whitley | Indiana | 18183 | 9626 | 83 |
2272547 | 2272547 | 2022-03-04 | Whitley | Indiana | 18183 | 9626 | 83 |
2269295 | 2269295 | 2022-03-03 | Whitley | Indiana | 18183 | 9625 | 82 |
2266042 | 2266042 | 2022-03-02 | Whitley | Indiana | 18183 | 9623 | 82 |
2262791 | 2262791 | 2022-03-01 | Whitley | Indiana | 18183 | 9620 | 82 |
2259540 | 2259540 | 2022-02-28 | Whitley | Indiana | 18183 | 9619 | 82 |
2256289 | 2256289 | 2022-02-27 | Whitley | Indiana | 18183 | 9614 | 82 |
2253038 | 2253038 | 2022-02-26 | Whitley | Indiana | 18183 | 9614 | 82 |
2249787 | 2249787 | 2022-02-25 | Whitley | Indiana | 18183 | 9614 | 82 |
2246536 | 2246536 | 2022-02-24 | Whitley | Indiana | 18183 | 9610 | 81 |
2243285 | 2243285 | 2022-02-23 | Whitley | Indiana | 18183 | 9603 | 81 |
2240034 | 2240034 | 2022-02-22 | Whitley | Indiana | 18183 | 9599 | 81 |
2236783 | 2236783 | 2022-02-21 | Whitley | Indiana | 18183 | 9596 | 80 |
2233532 | 2233532 | 2022-02-20 | Whitley | Indiana | 18183 | 9590 | 80 |
2230281 | 2230281 | 2022-02-19 | Whitley | Indiana | 18183 | 9590 | 80 |
2227030 | 2227030 | 2022-02-18 | Whitley | Indiana | 18183 | 9590 | 80 |
2223779 | 2223779 | 2022-02-17 | Whitley | Indiana | 18183 | 9588 | 79 |
2220528 | 2220528 | 2022-02-16 | Whitley | Indiana | 18183 | 9588 | 79 |
2217277 | 2217277 | 2022-02-15 | Whitley | Indiana | 18183 | 9583 | 79 |
2214026 | 2214026 | 2022-02-14 | Whitley | Indiana | 18183 | 9578 | 78 |
2210774 | 2210774 | 2022-02-13 | Whitley | Indiana | 18183 | 9566 | 78 |
2207521 | 2207521 | 2022-02-12 | Whitley | Indiana | 18183 | 9566 | 78 |
2204268 | 2204268 | 2022-02-11 | Whitley | Indiana | 18183 | 9566 | 78 |
2201015 | 2201015 | 2022-02-10 | Whitley | Indiana | 18183 | 9559 | 78 |
2197761 | 2197761 | 2022-02-09 | Whitley | Indiana | 18183 | 9531 | 78 |
2194507 | 2194507 | 2022-02-08 | Whitley | Indiana | 18183 | 9531 | 78 |
2191253 | 2191253 | 2022-02-07 | Whitley | Indiana | 18183 | 9522 | 77 |
2188000 | 2188000 | 2022-02-06 | Whitley | Indiana | 18183 | 9497 | 77 |
2184747 | 2184747 | 2022-02-05 | Whitley | Indiana | 18183 | 9497 | 77 |
2181495 | 2181495 | 2022-02-04 | Whitley | Indiana | 18183 | 9497 | 77 |
2178244 | 2178244 | 2022-02-03 | Whitley | Indiana | 18183 | 9486 | 77 |
2174991 | 2174991 | 2022-02-02 | Whitley | Indiana | 18183 | 9460 | 77 |
2171738 | 2171738 | 2022-02-01 | Whitley | Indiana | 18183 | 9419 | 76 |
2168485 | 2168485 | 2022-01-31 | Whitley | Indiana | 18183 | 9402 | 74 |
2165230 | 2165230 | 2022-01-30 | Whitley | Indiana | 18183 | 9312 | 74 |
2161975 | 2161975 | 2022-01-29 | Whitley | Indiana | 18183 | 9312 | 74 |
2158720 | 2158720 | 2022-01-28 | Whitley | Indiana | 18183 | 9312 | 74 |
2155466 | 2155466 | 2022-01-27 | Whitley | Indiana | 18183 | 9245 | 73 |
2152213 | 2152213 | 2022-01-26 | Whitley | Indiana | 18183 | 9126 | 73 |
2148961 | 2148961 | 2022-01-25 | Whitley | Indiana | 18183 | 9107 | 73 |
2145709 | 2145709 | 2022-01-24 | Whitley | Indiana | 18183 | 9027 | 73 |
2142454 | 2142454 | 2022-01-23 | Whitley | Indiana | 18183 | 8869 | 73 |
2139199 | 2139199 | 2022-01-22 | Whitley | Indiana | 18183 | 8869 | 73 |
2135943 | 2135943 | 2022-01-21 | Whitley | Indiana | 18183 | 8869 | 73 |
2132691 | 2132691 | 2022-01-20 | Whitley | Indiana | 18183 | 8745 | 73 |
2129438 | 2129438 | 2022-01-19 | Whitley | Indiana | 18183 | 8620 | 73 |
2126184 | 2126184 | 2022-01-18 | Whitley | Indiana | 18183 | 8506 | 73 |
2122932 | 2122932 | 2022-01-17 | Whitley | Indiana | 18183 | 8449 | 73 |
2119680 | 2119680 | 2022-01-16 | Whitley | Indiana | 18183 | 8253 | 73 |
2116428 | 2116428 | 2022-01-15 | Whitley | Indiana | 18183 | 8253 | 73 |
2113177 | 2113177 | 2022-01-14 | Whitley | Indiana | 18183 | 8253 | 73 |
2109925 | 2109925 | 2022-01-13 | Whitley | Indiana | 18183 | 8133 | 72 |
2106674 | 2106674 | 2022-01-12 | Whitley | Indiana | 18183 | 7999 | 72 |
2103423 | 2103423 | 2022-01-11 | Whitley | Indiana | 18183 | 7890 | 72 |
2100172 | 2100172 | 2022-01-10 | Whitley | Indiana | 18183 | 7840 | 72 |
2096921 | 2096921 | 2022-01-09 | Whitley | Indiana | 18183 | 7676 | 71 |
2093669 | 2093669 | 2022-01-08 | Whitley | Indiana | 18183 | 7676 | 71 |
2090417 | 2090417 | 2022-01-07 | Whitley | Indiana | 18183 | 7676 | 71 |
2087166 | 2087166 | 2022-01-06 | Whitley | Indiana | 18183 | 7607 | 71 |
2083914 | 2083914 | 2022-01-05 | Whitley | Indiana | 18183 | 7544 | 71 |
2080662 | 2080662 | 2022-01-04 | Whitley | Indiana | 18183 | 7486 | 71 |
2077410 | 2077410 | 2022-01-03 | Whitley | Indiana | 18183 | 7451 | 69 |
2074159 | 2074159 | 2022-01-02 | Whitley | Indiana | 18183 | 7343 | 68 |
2070908 | 2070908 | 2022-01-01 | Whitley | Indiana | 18183 | 7343 | 68 |
2067657 | 2067657 | 2021-12-31 | Whitley | Indiana | 18183 | 7343 | 68 |
2064406 | 2064406 | 2021-12-30 | Whitley | Indiana | 18183 | 7343 | 68 |
2061156 | 2061156 | 2021-12-29 | Whitley | Indiana | 18183 | 7311 | 68 |
2057907 | 2057907 | 2021-12-28 | Whitley | Indiana | 18183 | 7283 | 68 |
2054658 | 2054658 | 2021-12-27 | Whitley | Indiana | 18183 | 7267 | 68 |
2051408 | 2051408 | 2021-12-26 | Whitley | Indiana | 18183 | 7154 | 68 |
2048158 | 2048158 | 2021-12-25 | Whitley | Indiana | 18183 | 7154 | 68 |
2044908 | 2044908 | 2021-12-24 | Whitley | Indiana | 18183 | 7154 | 68 |
2041659 | 2041659 | 2021-12-23 | Whitley | Indiana | 18183 | 7154 | 68 |
2038409 | 2038409 | 2021-12-22 | Whitley | Indiana | 18183 | 7154 | 68 |
2035159 | 2035159 | 2021-12-21 | Whitley | Indiana | 18183 | 7121 | 67 |
2031909 | 2031909 | 2021-12-20 | Whitley | Indiana | 18183 | 7102 | 67 |
2028658 | 2028658 | 2021-12-19 | Whitley | Indiana | 18183 | 7025 | 67 |
2025407 | 2025407 | 2021-12-18 | Whitley | Indiana | 18183 | 7025 | 67 |
2022156 | 2022156 | 2021-12-17 | Whitley | Indiana | 18183 | 7025 | 67 |
2018905 | 2018905 | 2021-12-16 | Whitley | Indiana | 18183 | 6989 | 67 |
2015655 | 2015655 | 2021-12-15 | Whitley | Indiana | 18183 | 6962 | 67 |
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);