ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
310 rows where deaths = 39 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2308436 | 2308436 | 2022-03-15 | Coffey | Kansas | 20031 | 2410 | 39 |
2308477 | 2308477 | 2022-03-15 | Marion | Kansas | 20115 | 3317 | 39 |
2305185 | 2305185 | 2022-03-14 | Coffey | Kansas | 20031 | 2410 | 39 |
2305226 | 2305226 | 2022-03-14 | Marion | Kansas | 20115 | 3317 | 39 |
2301933 | 2301933 | 2022-03-13 | Coffey | Kansas | 20031 | 2410 | 39 |
2301974 | 2301974 | 2022-03-13 | Marion | Kansas | 20115 | 3315 | 39 |
2298681 | 2298681 | 2022-03-12 | Coffey | Kansas | 20031 | 2410 | 39 |
2298722 | 2298722 | 2022-03-12 | Marion | Kansas | 20115 | 3315 | 39 |
2295429 | 2295429 | 2022-03-11 | Coffey | Kansas | 20031 | 2410 | 39 |
2295470 | 2295470 | 2022-03-11 | Marion | Kansas | 20115 | 3315 | 39 |
2292177 | 2292177 | 2022-03-10 | Coffey | Kansas | 20031 | 2408 | 39 |
2292218 | 2292218 | 2022-03-10 | Marion | Kansas | 20115 | 3314 | 39 |
2288925 | 2288925 | 2022-03-09 | Coffey | Kansas | 20031 | 2408 | 39 |
2288966 | 2288966 | 2022-03-09 | Marion | Kansas | 20115 | 3314 | 39 |
2285674 | 2285674 | 2022-03-08 | Coffey | Kansas | 20031 | 2405 | 39 |
2285715 | 2285715 | 2022-03-08 | Marion | Kansas | 20115 | 3313 | 39 |
2282422 | 2282422 | 2022-03-07 | Coffey | Kansas | 20031 | 2405 | 39 |
2282463 | 2282463 | 2022-03-07 | Marion | Kansas | 20115 | 3313 | 39 |
2279169 | 2279169 | 2022-03-06 | Coffey | Kansas | 20031 | 2405 | 39 |
2279210 | 2279210 | 2022-03-06 | Marion | Kansas | 20115 | 3311 | 39 |
2275916 | 2275916 | 2022-03-05 | Coffey | Kansas | 20031 | 2405 | 39 |
2275957 | 2275957 | 2022-03-05 | Marion | Kansas | 20115 | 3311 | 39 |
2272663 | 2272663 | 2022-03-04 | Coffey | Kansas | 20031 | 2405 | 39 |
2272704 | 2272704 | 2022-03-04 | Marion | Kansas | 20115 | 3311 | 39 |
2269411 | 2269411 | 2022-03-03 | Coffey | Kansas | 20031 | 2396 | 39 |
2269452 | 2269452 | 2022-03-03 | Marion | Kansas | 20115 | 3311 | 39 |
2266158 | 2266158 | 2022-03-02 | Coffey | Kansas | 20031 | 2396 | 39 |
2266199 | 2266199 | 2022-03-02 | Marion | Kansas | 20115 | 3311 | 39 |
2262907 | 2262907 | 2022-03-01 | Coffey | Kansas | 20031 | 2394 | 39 |
2262948 | 2262948 | 2022-03-01 | Marion | Kansas | 20115 | 3308 | 39 |
2262994 | 2262994 | 2022-03-01 | Wilson | Kansas | 20205 | 2791 | 39 |
2259656 | 2259656 | 2022-02-28 | Coffey | Kansas | 20031 | 2394 | 39 |
2259697 | 2259697 | 2022-02-28 | Marion | Kansas | 20115 | 3308 | 39 |
2259743 | 2259743 | 2022-02-28 | Wilson | Kansas | 20205 | 2791 | 39 |
2256405 | 2256405 | 2022-02-27 | Coffey | Kansas | 20031 | 2392 | 39 |
2256446 | 2256446 | 2022-02-27 | Marion | Kansas | 20115 | 3306 | 39 |
2256492 | 2256492 | 2022-02-27 | Wilson | Kansas | 20205 | 2789 | 39 |
2253154 | 2253154 | 2022-02-26 | Coffey | Kansas | 20031 | 2392 | 39 |
2253195 | 2253195 | 2022-02-26 | Marion | Kansas | 20115 | 3306 | 39 |
2253241 | 2253241 | 2022-02-26 | Wilson | Kansas | 20205 | 2789 | 39 |
2249903 | 2249903 | 2022-02-25 | Coffey | Kansas | 20031 | 2392 | 39 |
2249944 | 2249944 | 2022-02-25 | Marion | Kansas | 20115 | 3306 | 39 |
2249990 | 2249990 | 2022-02-25 | Wilson | Kansas | 20205 | 2789 | 39 |
2246652 | 2246652 | 2022-02-24 | Coffey | Kansas | 20031 | 2389 | 39 |
2246693 | 2246693 | 2022-02-24 | Marion | Kansas | 20115 | 3301 | 39 |
2243401 | 2243401 | 2022-02-23 | Coffey | Kansas | 20031 | 2389 | 39 |
2243442 | 2243442 | 2022-02-23 | Marion | Kansas | 20115 | 3301 | 39 |
2240150 | 2240150 | 2022-02-22 | Coffey | Kansas | 20031 | 2383 | 39 |
2240191 | 2240191 | 2022-02-22 | Marion | Kansas | 20115 | 3293 | 39 |
2236899 | 2236899 | 2022-02-21 | Coffey | Kansas | 20031 | 2383 | 39 |
2236940 | 2236940 | 2022-02-21 | Marion | Kansas | 20115 | 3293 | 39 |
2233648 | 2233648 | 2022-02-20 | Coffey | Kansas | 20031 | 2382 | 39 |
2233689 | 2233689 | 2022-02-20 | Marion | Kansas | 20115 | 3289 | 39 |
2230397 | 2230397 | 2022-02-19 | Coffey | Kansas | 20031 | 2382 | 39 |
2230438 | 2230438 | 2022-02-19 | Marion | Kansas | 20115 | 3289 | 39 |
2227146 | 2227146 | 2022-02-18 | Coffey | Kansas | 20031 | 2382 | 39 |
2227187 | 2227187 | 2022-02-18 | Marion | Kansas | 20115 | 3289 | 39 |
2223895 | 2223895 | 2022-02-17 | Coffey | Kansas | 20031 | 2377 | 39 |
2223936 | 2223936 | 2022-02-17 | Marion | Kansas | 20115 | 3282 | 39 |
2220644 | 2220644 | 2022-02-16 | Coffey | Kansas | 20031 | 2377 | 39 |
2220685 | 2220685 | 2022-02-16 | Marion | Kansas | 20115 | 3282 | 39 |
2217393 | 2217393 | 2022-02-15 | Coffey | Kansas | 20031 | 2361 | 39 |
2217434 | 2217434 | 2022-02-15 | Marion | Kansas | 20115 | 3276 | 39 |
2214142 | 2214142 | 2022-02-14 | Coffey | Kansas | 20031 | 2361 | 39 |
2214183 | 2214183 | 2022-02-14 | Marion | Kansas | 20115 | 3276 | 39 |
2210890 | 2210890 | 2022-02-13 | Coffey | Kansas | 20031 | 2334 | 39 |
2210931 | 2210931 | 2022-02-13 | Marion | Kansas | 20115 | 3251 | 39 |
2207637 | 2207637 | 2022-02-12 | Coffey | Kansas | 20031 | 2334 | 39 |
2207678 | 2207678 | 2022-02-12 | Marion | Kansas | 20115 | 3251 | 39 |
2204384 | 2204384 | 2022-02-11 | Coffey | Kansas | 20031 | 2334 | 39 |
2204425 | 2204425 | 2022-02-11 | Marion | Kansas | 20115 | 3251 | 39 |
2201131 | 2201131 | 2022-02-10 | Coffey | Kansas | 20031 | 2334 | 39 |
2201172 | 2201172 | 2022-02-10 | Marion | Kansas | 20115 | 3251 | 39 |
2197877 | 2197877 | 2022-02-09 | Coffey | Kansas | 20031 | 2334 | 39 |
2197918 | 2197918 | 2022-02-09 | Marion | Kansas | 20115 | 3251 | 39 |
2194623 | 2194623 | 2022-02-08 | Coffey | Kansas | 20031 | 2313 | 39 |
2194664 | 2194664 | 2022-02-08 | Marion | Kansas | 20115 | 3234 | 39 |
2191369 | 2191369 | 2022-02-07 | Coffey | Kansas | 20031 | 2313 | 39 |
2191410 | 2191410 | 2022-02-07 | Marion | Kansas | 20115 | 3234 | 39 |
2188116 | 2188116 | 2022-02-06 | Coffey | Kansas | 20031 | 2299 | 39 |
2188157 | 2188157 | 2022-02-06 | Marion | Kansas | 20115 | 3214 | 39 |
2184863 | 2184863 | 2022-02-05 | Coffey | Kansas | 20031 | 2299 | 39 |
2184904 | 2184904 | 2022-02-05 | Marion | Kansas | 20115 | 3214 | 39 |
2181611 | 2181611 | 2022-02-04 | Coffey | Kansas | 20031 | 2299 | 39 |
2181652 | 2181652 | 2022-02-04 | Marion | Kansas | 20115 | 3214 | 39 |
2178402 | 2178402 | 2022-02-03 | Marshall | Kansas | 20117 | 2479 | 39 |
2175149 | 2175149 | 2022-02-02 | Marshall | Kansas | 20117 | 2479 | 39 |
2171896 | 2171896 | 2022-02-01 | Marshall | Kansas | 20117 | 2448 | 39 |
2168643 | 2168643 | 2022-01-31 | Marshall | Kansas | 20117 | 2448 | 39 |
2165388 | 2165388 | 2022-01-30 | Marshall | Kansas | 20117 | 2432 | 39 |
2162133 | 2162133 | 2022-01-29 | Marshall | Kansas | 20117 | 2432 | 39 |
2158878 | 2158878 | 2022-01-28 | Marshall | Kansas | 20117 | 2432 | 39 |
2155624 | 2155624 | 2022-01-27 | Marshall | Kansas | 20117 | 2409 | 39 |
2152371 | 2152371 | 2022-01-26 | Marshall | Kansas | 20117 | 2409 | 39 |
2149119 | 2149119 | 2022-01-25 | Marshall | Kansas | 20117 | 2369 | 39 |
2145867 | 2145867 | 2022-01-24 | Marshall | Kansas | 20117 | 2369 | 39 |
2087336 | 2087336 | 2022-01-06 | Osage | Kansas | 20139 | 2819 | 39 |
2084084 | 2084084 | 2022-01-05 | Osage | Kansas | 20139 | 2819 | 39 |
2035329 | 2035329 | 2021-12-21 | Osage | Kansas | 20139 | 2472 | 39 |
2032079 | 2032079 | 2021-12-20 | Osage | Kansas | 20139 | 2472 | 39 |
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);