ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,545 rows where county = "Wabash" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337499 | 2337499 | 2022-03-24 | Wabash | Illinois | 17185 | 3715 | 30 |
2337593 | 2337593 | 2022-03-24 | Wabash | Indiana | 18169 | 8714 | 154 |
2334245 | 2334245 | 2022-03-23 | Wabash | Illinois | 17185 | 3712 | 30 |
2334339 | 2334339 | 2022-03-23 | Wabash | Indiana | 18169 | 8714 | 154 |
2330991 | 2330991 | 2022-03-22 | Wabash | Illinois | 17185 | 3711 | 30 |
2331085 | 2331085 | 2022-03-22 | Wabash | Indiana | 18169 | 8714 | 154 |
2327739 | 2327739 | 2022-03-21 | Wabash | Illinois | 17185 | 3708 | 30 |
2327833 | 2327833 | 2022-03-21 | Wabash | Indiana | 18169 | 8713 | 154 |
2324486 | 2324486 | 2022-03-20 | Wabash | Illinois | 17185 | 3705 | 30 |
2324580 | 2324580 | 2022-03-20 | Wabash | Indiana | 18169 | 8711 | 154 |
2321232 | 2321232 | 2022-03-19 | Wabash | Illinois | 17185 | 3705 | 30 |
2321326 | 2321326 | 2022-03-19 | Wabash | Indiana | 18169 | 8711 | 154 |
2317978 | 2317978 | 2022-03-18 | Wabash | Illinois | 17185 | 3705 | 30 |
2318072 | 2318072 | 2022-03-18 | Wabash | Indiana | 18169 | 8711 | 154 |
2314725 | 2314725 | 2022-03-17 | Wabash | Illinois | 17185 | 3705 | 30 |
2314819 | 2314819 | 2022-03-17 | Wabash | Indiana | 18169 | 8709 | 153 |
2311472 | 2311472 | 2022-03-16 | Wabash | Illinois | 17185 | 3705 | 30 |
2311566 | 2311566 | 2022-03-16 | Wabash | Indiana | 18169 | 8708 | 153 |
2308219 | 2308219 | 2022-03-15 | Wabash | Illinois | 17185 | 3700 | 30 |
2308313 | 2308313 | 2022-03-15 | Wabash | Indiana | 18169 | 8708 | 153 |
2304968 | 2304968 | 2022-03-14 | Wabash | Illinois | 17185 | 3699 | 30 |
2305062 | 2305062 | 2022-03-14 | Wabash | Indiana | 18169 | 8704 | 152 |
2301716 | 2301716 | 2022-03-13 | Wabash | Illinois | 17185 | 3697 | 30 |
2301810 | 2301810 | 2022-03-13 | Wabash | Indiana | 18169 | 8701 | 152 |
2298464 | 2298464 | 2022-03-12 | Wabash | Illinois | 17185 | 3697 | 30 |
2298558 | 2298558 | 2022-03-12 | Wabash | Indiana | 18169 | 8701 | 152 |
2295212 | 2295212 | 2022-03-11 | Wabash | Illinois | 17185 | 3697 | 30 |
2295306 | 2295306 | 2022-03-11 | Wabash | Indiana | 18169 | 8701 | 152 |
2291960 | 2291960 | 2022-03-10 | Wabash | Illinois | 17185 | 3697 | 30 |
2292054 | 2292054 | 2022-03-10 | Wabash | Indiana | 18169 | 8697 | 151 |
2288708 | 2288708 | 2022-03-09 | Wabash | Illinois | 17185 | 3696 | 30 |
2288802 | 2288802 | 2022-03-09 | Wabash | Indiana | 18169 | 8695 | 151 |
2285457 | 2285457 | 2022-03-08 | Wabash | Illinois | 17185 | 3696 | 30 |
2285551 | 2285551 | 2022-03-08 | Wabash | Indiana | 18169 | 8695 | 151 |
2282205 | 2282205 | 2022-03-07 | Wabash | Illinois | 17185 | 3694 | 30 |
2282299 | 2282299 | 2022-03-07 | Wabash | Indiana | 18169 | 8695 | 151 |
2278952 | 2278952 | 2022-03-06 | Wabash | Illinois | 17185 | 3690 | 30 |
2279046 | 2279046 | 2022-03-06 | Wabash | Indiana | 18169 | 8691 | 151 |
2275699 | 2275699 | 2022-03-05 | Wabash | Illinois | 17185 | 3690 | 30 |
2275793 | 2275793 | 2022-03-05 | Wabash | Indiana | 18169 | 8691 | 151 |
2272446 | 2272446 | 2022-03-04 | Wabash | Illinois | 17185 | 3690 | 30 |
2272540 | 2272540 | 2022-03-04 | Wabash | Indiana | 18169 | 8691 | 151 |
2269194 | 2269194 | 2022-03-03 | Wabash | Illinois | 17185 | 3719 | 30 |
2269288 | 2269288 | 2022-03-03 | Wabash | Indiana | 18169 | 8689 | 151 |
2265941 | 2265941 | 2022-03-02 | Wabash | Illinois | 17185 | 3730 | 30 |
2266035 | 2266035 | 2022-03-02 | Wabash | Indiana | 18169 | 8686 | 151 |
2262690 | 2262690 | 2022-03-01 | Wabash | Illinois | 17185 | 3728 | 30 |
2262784 | 2262784 | 2022-03-01 | Wabash | Indiana | 18169 | 8677 | 150 |
2259439 | 2259439 | 2022-02-28 | Wabash | Illinois | 17185 | 3723 | 30 |
2259533 | 2259533 | 2022-02-28 | Wabash | Indiana | 18169 | 8675 | 150 |
2256188 | 2256188 | 2022-02-27 | Wabash | Illinois | 17185 | 3748 | 30 |
2256282 | 2256282 | 2022-02-27 | Wabash | Indiana | 18169 | 8666 | 149 |
2252937 | 2252937 | 2022-02-26 | Wabash | Illinois | 17185 | 3748 | 30 |
2253031 | 2253031 | 2022-02-26 | Wabash | Indiana | 18169 | 8666 | 149 |
2249686 | 2249686 | 2022-02-25 | Wabash | Illinois | 17185 | 3748 | 30 |
2249780 | 2249780 | 2022-02-25 | Wabash | Indiana | 18169 | 8666 | 149 |
2246435 | 2246435 | 2022-02-24 | Wabash | Illinois | 17185 | 3756 | 30 |
2246529 | 2246529 | 2022-02-24 | Wabash | Indiana | 18169 | 8664 | 149 |
2243184 | 2243184 | 2022-02-23 | Wabash | Illinois | 17185 | 3759 | 29 |
2243278 | 2243278 | 2022-02-23 | Wabash | Indiana | 18169 | 8659 | 149 |
2239933 | 2239933 | 2022-02-22 | Wabash | Illinois | 17185 | 3747 | 28 |
2240027 | 2240027 | 2022-02-22 | Wabash | Indiana | 18169 | 8653 | 149 |
2236682 | 2236682 | 2022-02-21 | Wabash | Illinois | 17185 | 3744 | 27 |
2236776 | 2236776 | 2022-02-21 | Wabash | Indiana | 18169 | 8650 | 148 |
2233431 | 2233431 | 2022-02-20 | Wabash | Illinois | 17185 | 3744 | 27 |
2233525 | 2233525 | 2022-02-20 | Wabash | Indiana | 18169 | 8638 | 148 |
2230180 | 2230180 | 2022-02-19 | Wabash | Illinois | 17185 | 3744 | 27 |
2230274 | 2230274 | 2022-02-19 | Wabash | Indiana | 18169 | 8638 | 148 |
2226929 | 2226929 | 2022-02-18 | Wabash | Illinois | 17185 | 3744 | 27 |
2227023 | 2227023 | 2022-02-18 | Wabash | Indiana | 18169 | 8638 | 148 |
2223678 | 2223678 | 2022-02-17 | Wabash | Illinois | 17185 | 3737 | 27 |
2223772 | 2223772 | 2022-02-17 | Wabash | Indiana | 18169 | 8632 | 148 |
2220427 | 2220427 | 2022-02-16 | Wabash | Illinois | 17185 | 3732 | 27 |
2220521 | 2220521 | 2022-02-16 | Wabash | Indiana | 18169 | 8624 | 148 |
2217176 | 2217176 | 2022-02-15 | Wabash | Illinois | 17185 | 3727 | 27 |
2217270 | 2217270 | 2022-02-15 | Wabash | Indiana | 18169 | 8618 | 147 |
2213925 | 2213925 | 2022-02-14 | Wabash | Illinois | 17185 | 3716 | 26 |
2214019 | 2214019 | 2022-02-14 | Wabash | Indiana | 18169 | 8610 | 147 |
2210673 | 2210673 | 2022-02-13 | Wabash | Illinois | 17185 | 3695 | 24 |
2210767 | 2210767 | 2022-02-13 | Wabash | Indiana | 18169 | 8586 | 146 |
2207420 | 2207420 | 2022-02-12 | Wabash | Illinois | 17185 | 3695 | 24 |
2207514 | 2207514 | 2022-02-12 | Wabash | Indiana | 18169 | 8586 | 146 |
2204167 | 2204167 | 2022-02-11 | Wabash | Illinois | 17185 | 3695 | 24 |
2204261 | 2204261 | 2022-02-11 | Wabash | Indiana | 18169 | 8586 | 146 |
2200914 | 2200914 | 2022-02-10 | Wabash | Illinois | 17185 | 3695 | 24 |
2201008 | 2201008 | 2022-02-10 | Wabash | Indiana | 18169 | 8568 | 146 |
2197660 | 2197660 | 2022-02-09 | Wabash | Illinois | 17185 | 3685 | 24 |
2197754 | 2197754 | 2022-02-09 | Wabash | Indiana | 18169 | 8529 | 145 |
2194406 | 2194406 | 2022-02-08 | Wabash | Illinois | 17185 | 3665 | 24 |
2194500 | 2194500 | 2022-02-08 | Wabash | Indiana | 18169 | 8529 | 145 |
2191152 | 2191152 | 2022-02-07 | Wabash | Illinois | 17185 | 3646 | 24 |
2191246 | 2191246 | 2022-02-07 | Wabash | Indiana | 18169 | 8483 | 144 |
2187899 | 2187899 | 2022-02-06 | Wabash | Illinois | 17185 | 3624 | 24 |
2187993 | 2187993 | 2022-02-06 | Wabash | Indiana | 18169 | 8448 | 144 |
2184646 | 2184646 | 2022-02-05 | Wabash | Illinois | 17185 | 3624 | 24 |
2184740 | 2184740 | 2022-02-05 | Wabash | Indiana | 18169 | 8448 | 144 |
2181394 | 2181394 | 2022-02-04 | Wabash | Illinois | 17185 | 3624 | 24 |
2181488 | 2181488 | 2022-02-04 | Wabash | Indiana | 18169 | 8448 | 144 |
2178143 | 2178143 | 2022-02-03 | Wabash | Illinois | 17185 | 3596 | 23 |
2178237 | 2178237 | 2022-02-03 | Wabash | Indiana | 18169 | 8423 | 144 |
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);