ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,448 rows where county = "Wichita" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337802 | 2337802 | 2022-03-24 | Wichita | Kansas | 20203 | 493 | 8 |
2339675 | 2339675 | 2022-03-24 | Wichita | Texas | 48485 | 33973 | 669 |
2334548 | 2334548 | 2022-03-23 | Wichita | Kansas | 20203 | 493 | 8 |
2336421 | 2336421 | 2022-03-23 | Wichita | Texas | 48485 | 33973 | 667 |
2331294 | 2331294 | 2022-03-22 | Wichita | Kansas | 20203 | 494 | 8 |
2333167 | 2333167 | 2022-03-22 | Wichita | Texas | 48485 | 33973 | 665 |
2328042 | 2328042 | 2022-03-21 | Wichita | Kansas | 20203 | 494 | 8 |
2329914 | 2329914 | 2022-03-21 | Wichita | Texas | 48485 | 33973 | 665 |
2324789 | 2324789 | 2022-03-20 | Wichita | Kansas | 20203 | 494 | 8 |
2326662 | 2326662 | 2022-03-20 | Wichita | Texas | 48485 | 33973 | 665 |
2321535 | 2321535 | 2022-03-19 | Wichita | Kansas | 20203 | 494 | 8 |
2323409 | 2323409 | 2022-03-19 | Wichita | Texas | 48485 | 33973 | 665 |
2318281 | 2318281 | 2022-03-18 | Wichita | Kansas | 20203 | 494 | 8 |
2320155 | 2320155 | 2022-03-18 | Wichita | Texas | 48485 | 33973 | 663 |
2315028 | 2315028 | 2022-03-17 | Wichita | Kansas | 20203 | 494 | 8 |
2316901 | 2316901 | 2022-03-17 | Wichita | Texas | 48485 | 33968 | 662 |
2311775 | 2311775 | 2022-03-16 | Wichita | Kansas | 20203 | 494 | 8 |
2313648 | 2313648 | 2022-03-16 | Wichita | Texas | 48485 | 33968 | 660 |
2308522 | 2308522 | 2022-03-15 | Wichita | Kansas | 20203 | 494 | 8 |
2310395 | 2310395 | 2022-03-15 | Wichita | Texas | 48485 | 33968 | 660 |
2305271 | 2305271 | 2022-03-14 | Wichita | Kansas | 20203 | 494 | 8 |
2307142 | 2307142 | 2022-03-14 | Wichita | Texas | 48485 | 33968 | 660 |
2302019 | 2302019 | 2022-03-13 | Wichita | Kansas | 20203 | 494 | 8 |
2303891 | 2303891 | 2022-03-13 | Wichita | Texas | 48485 | 33968 | 660 |
2298767 | 2298767 | 2022-03-12 | Wichita | Kansas | 20203 | 494 | 8 |
2300639 | 2300639 | 2022-03-12 | Wichita | Texas | 48485 | 33968 | 660 |
2295515 | 2295515 | 2022-03-11 | Wichita | Kansas | 20203 | 494 | 8 |
2297387 | 2297387 | 2022-03-11 | Wichita | Texas | 48485 | 33968 | 658 |
2292263 | 2292263 | 2022-03-10 | Wichita | Kansas | 20203 | 494 | 8 |
2294135 | 2294135 | 2022-03-10 | Wichita | Texas | 48485 | 33955 | 658 |
2289011 | 2289011 | 2022-03-09 | Wichita | Kansas | 20203 | 494 | 8 |
2290883 | 2290883 | 2022-03-09 | Wichita | Texas | 48485 | 33955 | 654 |
2285760 | 2285760 | 2022-03-08 | Wichita | Kansas | 20203 | 494 | 8 |
2287631 | 2287631 | 2022-03-08 | Wichita | Texas | 48485 | 33955 | 651 |
2282508 | 2282508 | 2022-03-07 | Wichita | Kansas | 20203 | 494 | 8 |
2284379 | 2284379 | 2022-03-07 | Wichita | Texas | 48485 | 33955 | 650 |
2279255 | 2279255 | 2022-03-06 | Wichita | Kansas | 20203 | 494 | 8 |
2281127 | 2281127 | 2022-03-06 | Wichita | Texas | 48485 | 33955 | 650 |
2276002 | 2276002 | 2022-03-05 | Wichita | Kansas | 20203 | 494 | 8 |
2277874 | 2277874 | 2022-03-05 | Wichita | Texas | 48485 | 33955 | 650 |
2272749 | 2272749 | 2022-03-04 | Wichita | Kansas | 20203 | 494 | 8 |
2274621 | 2274621 | 2022-03-04 | Wichita | Texas | 48485 | 33955 | 650 |
2269497 | 2269497 | 2022-03-03 | Wichita | Kansas | 20203 | 493 | 8 |
2271368 | 2271368 | 2022-03-03 | Wichita | Texas | 48485 | 33864 | 649 |
2266244 | 2266244 | 2022-03-02 | Wichita | Kansas | 20203 | 493 | 8 |
2268116 | 2268116 | 2022-03-02 | Wichita | Texas | 48485 | 33864 | 649 |
2262993 | 2262993 | 2022-03-01 | Wichita | Kansas | 20203 | 493 | 8 |
2264863 | 2264863 | 2022-03-01 | Wichita | Texas | 48485 | 33864 | 649 |
2259742 | 2259742 | 2022-02-28 | Wichita | Kansas | 20203 | 493 | 8 |
2261613 | 2261613 | 2022-02-28 | Wichita | Texas | 48485 | 33864 | 648 |
2256491 | 2256491 | 2022-02-27 | Wichita | Kansas | 20203 | 493 | 8 |
2258362 | 2258362 | 2022-02-27 | Wichita | Texas | 48485 | 33864 | 648 |
2253240 | 2253240 | 2022-02-26 | Wichita | Kansas | 20203 | 493 | 8 |
2255111 | 2255111 | 2022-02-26 | Wichita | Texas | 48485 | 33864 | 645 |
2249989 | 2249989 | 2022-02-25 | Wichita | Kansas | 20203 | 493 | 8 |
2251860 | 2251860 | 2022-02-25 | Wichita | Texas | 48485 | 33864 | 642 |
2246738 | 2246738 | 2022-02-24 | Wichita | Kansas | 20203 | 493 | 8 |
2248609 | 2248609 | 2022-02-24 | Wichita | Texas | 48485 | 32959 | 637 |
2243487 | 2243487 | 2022-02-23 | Wichita | Kansas | 20203 | 493 | 8 |
2245358 | 2245358 | 2022-02-23 | Wichita | Texas | 48485 | 32959 | 634 |
2240236 | 2240236 | 2022-02-22 | Wichita | Kansas | 20203 | 492 | 8 |
2242107 | 2242107 | 2022-02-22 | Wichita | Texas | 48485 | 32959 | 632 |
2236985 | 2236985 | 2022-02-21 | Wichita | Kansas | 20203 | 492 | 8 |
2238856 | 2238856 | 2022-02-21 | Wichita | Texas | 48485 | 32959 | 631 |
2233734 | 2233734 | 2022-02-20 | Wichita | Kansas | 20203 | 492 | 8 |
2235605 | 2235605 | 2022-02-20 | Wichita | Texas | 48485 | 32959 | 631 |
2230483 | 2230483 | 2022-02-19 | Wichita | Kansas | 20203 | 492 | 8 |
2232354 | 2232354 | 2022-02-19 | Wichita | Texas | 48485 | 32959 | 631 |
2227232 | 2227232 | 2022-02-18 | Wichita | Kansas | 20203 | 492 | 8 |
2229103 | 2229103 | 2022-02-18 | Wichita | Texas | 48485 | 32959 | 630 |
2223981 | 2223981 | 2022-02-17 | Wichita | Kansas | 20203 | 491 | 8 |
2225852 | 2225852 | 2022-02-17 | Wichita | Texas | 48485 | 32959 | 629 |
2220730 | 2220730 | 2022-02-16 | Wichita | Kansas | 20203 | 491 | 8 |
2222601 | 2222601 | 2022-02-16 | Wichita | Texas | 48485 | 32959 | 617 |
2217479 | 2217479 | 2022-02-15 | Wichita | Kansas | 20203 | 491 | 8 |
2219350 | 2219350 | 2022-02-15 | Wichita | Texas | 48485 | 32959 | 615 |
2214228 | 2214228 | 2022-02-14 | Wichita | Kansas | 20203 | 491 | 8 |
2216099 | 2216099 | 2022-02-14 | Wichita | Texas | 48485 | 32959 | 612 |
2210976 | 2210976 | 2022-02-13 | Wichita | Kansas | 20203 | 487 | 8 |
2212848 | 2212848 | 2022-02-13 | Wichita | Texas | 48485 | 32959 | 612 |
2207723 | 2207723 | 2022-02-12 | Wichita | Kansas | 20203 | 487 | 8 |
2209595 | 2209595 | 2022-02-12 | Wichita | Texas | 48485 | 32959 | 611 |
2204470 | 2204470 | 2022-02-11 | Wichita | Kansas | 20203 | 487 | 8 |
2206342 | 2206342 | 2022-02-11 | Wichita | Texas | 48485 | 32959 | 610 |
2201217 | 2201217 | 2022-02-10 | Wichita | Kansas | 20203 | 487 | 8 |
2203089 | 2203089 | 2022-02-10 | Wichita | Texas | 48485 | 32709 | 608 |
2197963 | 2197963 | 2022-02-09 | Wichita | Kansas | 20203 | 487 | 8 |
2199835 | 2199835 | 2022-02-09 | Wichita | Texas | 48485 | 32709 | 605 |
2194709 | 2194709 | 2022-02-08 | Wichita | Kansas | 20203 | 486 | 8 |
2196581 | 2196581 | 2022-02-08 | Wichita | Texas | 48485 | 32709 | 603 |
2191455 | 2191455 | 2022-02-07 | Wichita | Kansas | 20203 | 486 | 8 |
2193327 | 2193327 | 2022-02-07 | Wichita | Texas | 48485 | 32709 | 600 |
2188202 | 2188202 | 2022-02-06 | Wichita | Kansas | 20203 | 483 | 8 |
2190074 | 2190074 | 2022-02-06 | Wichita | Texas | 48485 | 32084 | 600 |
2184949 | 2184949 | 2022-02-05 | Wichita | Kansas | 20203 | 483 | 8 |
2186821 | 2186821 | 2022-02-05 | Wichita | Texas | 48485 | 32084 | 600 |
2181697 | 2181697 | 2022-02-04 | Wichita | Kansas | 20203 | 483 | 8 |
2183568 | 2183568 | 2022-02-04 | Wichita | Texas | 48485 | 32084 | 600 |
2178446 | 2178446 | 2022-02-03 | Wichita | Kansas | 20203 | 481 | 8 |
2180316 | 2180316 | 2022-02-03 | Wichita | Texas | 48485 | 32084 | 600 |
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);