ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 20055 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500500 | 2500500 | 2022-05-13 | Finney | Kansas | 20055 | 11545 | 115 |
2497242 | 2497242 | 2022-05-12 | Finney | Kansas | 20055 | 11545 | 115 |
2493984 | 2493984 | 2022-05-11 | Finney | Kansas | 20055 | 11545 | 115 |
2490726 | 2490726 | 2022-05-10 | Finney | Kansas | 20055 | 11540 | 115 |
2487469 | 2487469 | 2022-05-09 | Finney | Kansas | 20055 | 11540 | 115 |
2484211 | 2484211 | 2022-05-08 | Finney | Kansas | 20055 | 11540 | 115 |
2480953 | 2480953 | 2022-05-07 | Finney | Kansas | 20055 | 11540 | 115 |
2477695 | 2477695 | 2022-05-06 | Finney | Kansas | 20055 | 11540 | 115 |
2474437 | 2474437 | 2022-05-05 | Finney | Kansas | 20055 | 11540 | 115 |
2471180 | 2471180 | 2022-05-04 | Finney | Kansas | 20055 | 11540 | 115 |
2467924 | 2467924 | 2022-05-03 | Finney | Kansas | 20055 | 11539 | 115 |
2464669 | 2464669 | 2022-05-02 | Finney | Kansas | 20055 | 11539 | 114 |
2461413 | 2461413 | 2022-05-01 | Finney | Kansas | 20055 | 11539 | 114 |
2458157 | 2458157 | 2022-04-30 | Finney | Kansas | 20055 | 11539 | 114 |
2454901 | 2454901 | 2022-04-29 | Finney | Kansas | 20055 | 11539 | 114 |
2451645 | 2451645 | 2022-04-28 | Finney | Kansas | 20055 | 11539 | 114 |
2448389 | 2448389 | 2022-04-27 | Finney | Kansas | 20055 | 11539 | 114 |
2445133 | 2445133 | 2022-04-26 | Finney | Kansas | 20055 | 11539 | 114 |
2441877 | 2441877 | 2022-04-25 | Finney | Kansas | 20055 | 11539 | 114 |
2438621 | 2438621 | 2022-04-24 | Finney | Kansas | 20055 | 11539 | 114 |
2435365 | 2435365 | 2022-04-23 | Finney | Kansas | 20055 | 11539 | 114 |
2432109 | 2432109 | 2022-04-22 | Finney | Kansas | 20055 | 11539 | 114 |
2428853 | 2428853 | 2022-04-21 | Finney | Kansas | 20055 | 11539 | 114 |
2425597 | 2425597 | 2022-04-20 | Finney | Kansas | 20055 | 11538 | 114 |
2422341 | 2422341 | 2022-04-19 | Finney | Kansas | 20055 | 11537 | 112 |
2419085 | 2419085 | 2022-04-18 | Finney | Kansas | 20055 | 11537 | 112 |
2415829 | 2415829 | 2022-04-17 | Finney | Kansas | 20055 | 11537 | 112 |
2412573 | 2412573 | 2022-04-16 | Finney | Kansas | 20055 | 11537 | 112 |
2409317 | 2409317 | 2022-04-15 | Finney | Kansas | 20055 | 11537 | 112 |
2406061 | 2406061 | 2022-04-14 | Finney | Kansas | 20055 | 11537 | 112 |
2402805 | 2402805 | 2022-04-13 | Finney | Kansas | 20055 | 11537 | 112 |
2399551 | 2399551 | 2022-04-12 | Finney | Kansas | 20055 | 11537 | 112 |
2396295 | 2396295 | 2022-04-11 | Finney | Kansas | 20055 | 11537 | 112 |
2393040 | 2393040 | 2022-04-10 | Finney | Kansas | 20055 | 11537 | 112 |
2389784 | 2389784 | 2022-04-09 | Finney | Kansas | 20055 | 11537 | 112 |
2386528 | 2386528 | 2022-04-08 | Finney | Kansas | 20055 | 11537 | 112 |
2383274 | 2383274 | 2022-04-07 | Finney | Kansas | 20055 | 11537 | 112 |
2380019 | 2380019 | 2022-04-06 | Finney | Kansas | 20055 | 11537 | 112 |
2376764 | 2376764 | 2022-04-05 | Finney | Kansas | 20055 | 11536 | 112 |
2373512 | 2373512 | 2022-04-04 | Finney | Kansas | 20055 | 11535 | 112 |
2370259 | 2370259 | 2022-04-03 | Finney | Kansas | 20055 | 11534 | 112 |
2367006 | 2367006 | 2022-04-02 | Finney | Kansas | 20055 | 11534 | 112 |
2363753 | 2363753 | 2022-04-01 | Finney | Kansas | 20055 | 11534 | 112 |
2360499 | 2360499 | 2022-03-31 | Finney | Kansas | 20055 | 11532 | 112 |
2357245 | 2357245 | 2022-03-30 | Finney | Kansas | 20055 | 11532 | 112 |
2353992 | 2353992 | 2022-03-29 | Finney | Kansas | 20055 | 11532 | 109 |
2350740 | 2350740 | 2022-03-28 | Finney | Kansas | 20055 | 11532 | 109 |
2347487 | 2347487 | 2022-03-27 | Finney | Kansas | 20055 | 11532 | 109 |
2344234 | 2344234 | 2022-03-26 | Finney | Kansas | 20055 | 11532 | 109 |
2340981 | 2340981 | 2022-03-25 | Finney | Kansas | 20055 | 11532 | 109 |
2337728 | 2337728 | 2022-03-24 | Finney | Kansas | 20055 | 11531 | 108 |
2334474 | 2334474 | 2022-03-23 | Finney | Kansas | 20055 | 11531 | 108 |
2331220 | 2331220 | 2022-03-22 | Finney | Kansas | 20055 | 11530 | 106 |
2327968 | 2327968 | 2022-03-21 | Finney | Kansas | 20055 | 11530 | 106 |
2324715 | 2324715 | 2022-03-20 | Finney | Kansas | 20055 | 11530 | 106 |
2321461 | 2321461 | 2022-03-19 | Finney | Kansas | 20055 | 11530 | 106 |
2318207 | 2318207 | 2022-03-18 | Finney | Kansas | 20055 | 11530 | 106 |
2314954 | 2314954 | 2022-03-17 | Finney | Kansas | 20055 | 11530 | 105 |
2311701 | 2311701 | 2022-03-16 | Finney | Kansas | 20055 | 11529 | 105 |
2308448 | 2308448 | 2022-03-15 | Finney | Kansas | 20055 | 11528 | 104 |
2305197 | 2305197 | 2022-03-14 | Finney | Kansas | 20055 | 11518 | 104 |
2301945 | 2301945 | 2022-03-13 | Finney | Kansas | 20055 | 11517 | 104 |
2298693 | 2298693 | 2022-03-12 | Finney | Kansas | 20055 | 11517 | 104 |
2295441 | 2295441 | 2022-03-11 | Finney | Kansas | 20055 | 11517 | 104 |
2292189 | 2292189 | 2022-03-10 | Finney | Kansas | 20055 | 11516 | 106 |
2288937 | 2288937 | 2022-03-09 | Finney | Kansas | 20055 | 11512 | 106 |
2285686 | 2285686 | 2022-03-08 | Finney | Kansas | 20055 | 11508 | 106 |
2282434 | 2282434 | 2022-03-07 | Finney | Kansas | 20055 | 11508 | 106 |
2279181 | 2279181 | 2022-03-06 | Finney | Kansas | 20055 | 11504 | 106 |
2275928 | 2275928 | 2022-03-05 | Finney | Kansas | 20055 | 11504 | 106 |
2272675 | 2272675 | 2022-03-04 | Finney | Kansas | 20055 | 11504 | 106 |
2269423 | 2269423 | 2022-03-03 | Finney | Kansas | 20055 | 11503 | 106 |
2266170 | 2266170 | 2022-03-02 | Finney | Kansas | 20055 | 11498 | 106 |
2262919 | 2262919 | 2022-03-01 | Finney | Kansas | 20055 | 11493 | 106 |
2259668 | 2259668 | 2022-02-28 | Finney | Kansas | 20055 | 11490 | 106 |
2256417 | 2256417 | 2022-02-27 | Finney | Kansas | 20055 | 11490 | 106 |
2253166 | 2253166 | 2022-02-26 | Finney | Kansas | 20055 | 11490 | 106 |
2249915 | 2249915 | 2022-02-25 | Finney | Kansas | 20055 | 11490 | 106 |
2246664 | 2246664 | 2022-02-24 | Finney | Kansas | 20055 | 11488 | 106 |
2243413 | 2243413 | 2022-02-23 | Finney | Kansas | 20055 | 11488 | 106 |
2240162 | 2240162 | 2022-02-22 | Finney | Kansas | 20055 | 11167 | 106 |
2236911 | 2236911 | 2022-02-21 | Finney | Kansas | 20055 | 11167 | 106 |
2233660 | 2233660 | 2022-02-20 | Finney | Kansas | 20055 | 11156 | 105 |
2230409 | 2230409 | 2022-02-19 | Finney | Kansas | 20055 | 11156 | 105 |
2227158 | 2227158 | 2022-02-18 | Finney | Kansas | 20055 | 11156 | 105 |
2223907 | 2223907 | 2022-02-17 | Finney | Kansas | 20055 | 11143 | 105 |
2220656 | 2220656 | 2022-02-16 | Finney | Kansas | 20055 | 11143 | 105 |
2217405 | 2217405 | 2022-02-15 | Finney | Kansas | 20055 | 11127 | 105 |
2214154 | 2214154 | 2022-02-14 | Finney | Kansas | 20055 | 11127 | 105 |
2210902 | 2210902 | 2022-02-13 | Finney | Kansas | 20055 | 11088 | 105 |
2207649 | 2207649 | 2022-02-12 | Finney | Kansas | 20055 | 11088 | 105 |
2204396 | 2204396 | 2022-02-11 | Finney | Kansas | 20055 | 11088 | 105 |
2201143 | 2201143 | 2022-02-10 | Finney | Kansas | 20055 | 11088 | 105 |
2197889 | 2197889 | 2022-02-09 | Finney | Kansas | 20055 | 11088 | 105 |
2194635 | 2194635 | 2022-02-08 | Finney | Kansas | 20055 | 11056 | 105 |
2191381 | 2191381 | 2022-02-07 | Finney | Kansas | 20055 | 11056 | 105 |
2188128 | 2188128 | 2022-02-06 | Finney | Kansas | 20055 | 11028 | 105 |
2184875 | 2184875 | 2022-02-05 | Finney | Kansas | 20055 | 11028 | 105 |
2181623 | 2181623 | 2022-02-04 | Finney | Kansas | 20055 | 11028 | 105 |
2178372 | 2178372 | 2022-02-03 | Finney | Kansas | 20055 | 10996 | 105 |
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);