ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where county = "Washington", deaths = 20, fips = 20201 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2354065 | 2354065 | 2022-03-29 | Washington | Kansas | 20201 | 1393 | 20 |
2350813 | 2350813 | 2022-03-28 | Washington | Kansas | 20201 | 1393 | 20 |
2347560 | 2347560 | 2022-03-27 | Washington | Kansas | 20201 | 1393 | 20 |
2344307 | 2344307 | 2022-03-26 | Washington | Kansas | 20201 | 1393 | 20 |
2341054 | 2341054 | 2022-03-25 | Washington | Kansas | 20201 | 1393 | 20 |
2337801 | 2337801 | 2022-03-24 | Washington | Kansas | 20201 | 1393 | 20 |
2334547 | 2334547 | 2022-03-23 | Washington | Kansas | 20201 | 1393 | 20 |
2331293 | 2331293 | 2022-03-22 | Washington | Kansas | 20201 | 1394 | 20 |
2328041 | 2328041 | 2022-03-21 | Washington | Kansas | 20201 | 1394 | 20 |
2324788 | 2324788 | 2022-03-20 | Washington | Kansas | 20201 | 1394 | 20 |
2321534 | 2321534 | 2022-03-19 | Washington | Kansas | 20201 | 1394 | 20 |
2318280 | 2318280 | 2022-03-18 | Washington | Kansas | 20201 | 1394 | 20 |
2315027 | 2315027 | 2022-03-17 | Washington | Kansas | 20201 | 1394 | 20 |
2311774 | 2311774 | 2022-03-16 | Washington | Kansas | 20201 | 1394 | 20 |
2308521 | 2308521 | 2022-03-15 | Washington | Kansas | 20201 | 1394 | 20 |
2305270 | 2305270 | 2022-03-14 | Washington | Kansas | 20201 | 1394 | 20 |
2302018 | 2302018 | 2022-03-13 | Washington | Kansas | 20201 | 1394 | 20 |
2298766 | 2298766 | 2022-03-12 | Washington | Kansas | 20201 | 1394 | 20 |
2295514 | 2295514 | 2022-03-11 | Washington | Kansas | 20201 | 1394 | 20 |
2292262 | 2292262 | 2022-03-10 | Washington | Kansas | 20201 | 1394 | 20 |
2289010 | 2289010 | 2022-03-09 | Washington | Kansas | 20201 | 1394 | 20 |
2285759 | 2285759 | 2022-03-08 | Washington | Kansas | 20201 | 1391 | 20 |
2282507 | 2282507 | 2022-03-07 | Washington | Kansas | 20201 | 1391 | 20 |
2279254 | 2279254 | 2022-03-06 | Washington | Kansas | 20201 | 1391 | 20 |
2276001 | 2276001 | 2022-03-05 | Washington | Kansas | 20201 | 1391 | 20 |
2272748 | 2272748 | 2022-03-04 | Washington | Kansas | 20201 | 1391 | 20 |
2269496 | 2269496 | 2022-03-03 | Washington | Kansas | 20201 | 1389 | 20 |
2266243 | 2266243 | 2022-03-02 | Washington | Kansas | 20201 | 1389 | 20 |
2262992 | 2262992 | 2022-03-01 | Washington | Kansas | 20201 | 1389 | 20 |
2259741 | 2259741 | 2022-02-28 | Washington | Kansas | 20201 | 1389 | 20 |
2256490 | 2256490 | 2022-02-27 | Washington | Kansas | 20201 | 1388 | 20 |
2253239 | 2253239 | 2022-02-26 | Washington | Kansas | 20201 | 1388 | 20 |
2249988 | 2249988 | 2022-02-25 | Washington | Kansas | 20201 | 1388 | 20 |
2246737 | 2246737 | 2022-02-24 | Washington | Kansas | 20201 | 1388 | 20 |
2243486 | 2243486 | 2022-02-23 | Washington | Kansas | 20201 | 1388 | 20 |
2240235 | 2240235 | 2022-02-22 | Washington | Kansas | 20201 | 1384 | 20 |
2236984 | 2236984 | 2022-02-21 | Washington | Kansas | 20201 | 1384 | 20 |
2233733 | 2233733 | 2022-02-20 | Washington | Kansas | 20201 | 1383 | 20 |
2230482 | 2230482 | 2022-02-19 | Washington | Kansas | 20201 | 1383 | 20 |
2227231 | 2227231 | 2022-02-18 | Washington | Kansas | 20201 | 1383 | 20 |
2223980 | 2223980 | 2022-02-17 | Washington | Kansas | 20201 | 1382 | 20 |
2220729 | 2220729 | 2022-02-16 | Washington | Kansas | 20201 | 1382 | 20 |
2217478 | 2217478 | 2022-02-15 | Washington | Kansas | 20201 | 1377 | 20 |
2214227 | 2214227 | 2022-02-14 | Washington | Kansas | 20201 | 1377 | 20 |
2210975 | 2210975 | 2022-02-13 | Washington | Kansas | 20201 | 1356 | 20 |
2207722 | 2207722 | 2022-02-12 | Washington | Kansas | 20201 | 1356 | 20 |
2204469 | 2204469 | 2022-02-11 | Washington | Kansas | 20201 | 1356 | 20 |
2201216 | 2201216 | 2022-02-10 | Washington | Kansas | 20201 | 1356 | 20 |
2197962 | 2197962 | 2022-02-09 | Washington | Kansas | 20201 | 1356 | 20 |
2194708 | 2194708 | 2022-02-08 | Washington | Kansas | 20201 | 1342 | 20 |
2191454 | 2191454 | 2022-02-07 | Washington | Kansas | 20201 | 1342 | 20 |
2188201 | 2188201 | 2022-02-06 | Washington | Kansas | 20201 | 1336 | 20 |
2184948 | 2184948 | 2022-02-05 | Washington | Kansas | 20201 | 1336 | 20 |
2181696 | 2181696 | 2022-02-04 | Washington | Kansas | 20201 | 1336 | 20 |
2178445 | 2178445 | 2022-02-03 | Washington | Kansas | 20201 | 1328 | 20 |
2175192 | 2175192 | 2022-02-02 | Washington | Kansas | 20201 | 1328 | 20 |
2171939 | 2171939 | 2022-02-01 | Washington | Kansas | 20201 | 1306 | 20 |
2168686 | 2168686 | 2022-01-31 | Washington | Kansas | 20201 | 1306 | 20 |
2165431 | 2165431 | 2022-01-30 | Washington | Kansas | 20201 | 1286 | 20 |
2162176 | 2162176 | 2022-01-29 | Washington | Kansas | 20201 | 1286 | 20 |
2158921 | 2158921 | 2022-01-28 | Washington | Kansas | 20201 | 1286 | 20 |
2155667 | 2155667 | 2022-01-27 | Washington | Kansas | 20201 | 1267 | 20 |
2152414 | 2152414 | 2022-01-26 | Washington | Kansas | 20201 | 1267 | 20 |
2149162 | 2149162 | 2022-01-25 | Washington | Kansas | 20201 | 1240 | 20 |
2145910 | 2145910 | 2022-01-24 | Washington | Kansas | 20201 | 1240 | 20 |
2142655 | 2142655 | 2022-01-23 | Washington | Kansas | 20201 | 1234 | 20 |
2139400 | 2139400 | 2022-01-22 | Washington | Kansas | 20201 | 1234 | 20 |
2136144 | 2136144 | 2022-01-21 | Washington | Kansas | 20201 | 1234 | 20 |
2132892 | 2132892 | 2022-01-20 | Washington | Kansas | 20201 | 1186 | 20 |
2129639 | 2129639 | 2022-01-19 | Washington | Kansas | 20201 | 1186 | 20 |
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);