ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Rooks" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500554 | 2500554 | 2022-05-13 | Rooks | Kansas | 20163 | 1377 | 20 |
2497296 | 2497296 | 2022-05-12 | Rooks | Kansas | 20163 | 1373 | 20 |
2494038 | 2494038 | 2022-05-11 | Rooks | Kansas | 20163 | 1373 | 20 |
2490780 | 2490780 | 2022-05-10 | Rooks | Kansas | 20163 | 1373 | 20 |
2487523 | 2487523 | 2022-05-09 | Rooks | Kansas | 20163 | 1373 | 20 |
2484265 | 2484265 | 2022-05-08 | Rooks | Kansas | 20163 | 1373 | 20 |
2481007 | 2481007 | 2022-05-07 | Rooks | Kansas | 20163 | 1373 | 20 |
2477749 | 2477749 | 2022-05-06 | Rooks | Kansas | 20163 | 1373 | 20 |
2474491 | 2474491 | 2022-05-05 | Rooks | Kansas | 20163 | 1371 | 20 |
2471234 | 2471234 | 2022-05-04 | Rooks | Kansas | 20163 | 1371 | 20 |
2467978 | 2467978 | 2022-05-03 | Rooks | Kansas | 20163 | 1371 | 20 |
2464723 | 2464723 | 2022-05-02 | Rooks | Kansas | 20163 | 1371 | 20 |
2461467 | 2461467 | 2022-05-01 | Rooks | Kansas | 20163 | 1371 | 20 |
2458211 | 2458211 | 2022-04-30 | Rooks | Kansas | 20163 | 1371 | 20 |
2454955 | 2454955 | 2022-04-29 | Rooks | Kansas | 20163 | 1371 | 20 |
2451699 | 2451699 | 2022-04-28 | Rooks | Kansas | 20163 | 1371 | 20 |
2448443 | 2448443 | 2022-04-27 | Rooks | Kansas | 20163 | 1371 | 20 |
2445187 | 2445187 | 2022-04-26 | Rooks | Kansas | 20163 | 1371 | 20 |
2441931 | 2441931 | 2022-04-25 | Rooks | Kansas | 20163 | 1371 | 20 |
2438675 | 2438675 | 2022-04-24 | Rooks | Kansas | 20163 | 1371 | 20 |
2435419 | 2435419 | 2022-04-23 | Rooks | Kansas | 20163 | 1371 | 20 |
2432163 | 2432163 | 2022-04-22 | Rooks | Kansas | 20163 | 1371 | 20 |
2428907 | 2428907 | 2022-04-21 | Rooks | Kansas | 20163 | 1370 | 20 |
2425651 | 2425651 | 2022-04-20 | Rooks | Kansas | 20163 | 1370 | 20 |
2422395 | 2422395 | 2022-04-19 | Rooks | Kansas | 20163 | 1370 | 20 |
2419139 | 2419139 | 2022-04-18 | Rooks | Kansas | 20163 | 1370 | 20 |
2415883 | 2415883 | 2022-04-17 | Rooks | Kansas | 20163 | 1370 | 20 |
2412627 | 2412627 | 2022-04-16 | Rooks | Kansas | 20163 | 1370 | 20 |
2409371 | 2409371 | 2022-04-15 | Rooks | Kansas | 20163 | 1370 | 20 |
2406115 | 2406115 | 2022-04-14 | Rooks | Kansas | 20163 | 1368 | 20 |
2402859 | 2402859 | 2022-04-13 | Rooks | Kansas | 20163 | 1368 | 20 |
2399605 | 2399605 | 2022-04-12 | Rooks | Kansas | 20163 | 1368 | 20 |
2396349 | 2396349 | 2022-04-11 | Rooks | Kansas | 20163 | 1368 | 20 |
2393094 | 2393094 | 2022-04-10 | Rooks | Kansas | 20163 | 1368 | 20 |
2389838 | 2389838 | 2022-04-09 | Rooks | Kansas | 20163 | 1368 | 20 |
2386582 | 2386582 | 2022-04-08 | Rooks | Kansas | 20163 | 1368 | 20 |
2383328 | 2383328 | 2022-04-07 | Rooks | Kansas | 20163 | 1366 | 20 |
2380073 | 2380073 | 2022-04-06 | Rooks | Kansas | 20163 | 1366 | 20 |
2376818 | 2376818 | 2022-04-05 | Rooks | Kansas | 20163 | 1366 | 20 |
2373566 | 2373566 | 2022-04-04 | Rooks | Kansas | 20163 | 1366 | 20 |
2370313 | 2370313 | 2022-04-03 | Rooks | Kansas | 20163 | 1366 | 20 |
2367060 | 2367060 | 2022-04-02 | Rooks | Kansas | 20163 | 1366 | 20 |
2363807 | 2363807 | 2022-04-01 | Rooks | Kansas | 20163 | 1366 | 20 |
2360553 | 2360553 | 2022-03-31 | Rooks | Kansas | 20163 | 1367 | 20 |
2357299 | 2357299 | 2022-03-30 | Rooks | Kansas | 20163 | 1367 | 20 |
2354046 | 2354046 | 2022-03-29 | Rooks | Kansas | 20163 | 1368 | 20 |
2350794 | 2350794 | 2022-03-28 | Rooks | Kansas | 20163 | 1368 | 20 |
2347541 | 2347541 | 2022-03-27 | Rooks | Kansas | 20163 | 1367 | 20 |
2344288 | 2344288 | 2022-03-26 | Rooks | Kansas | 20163 | 1367 | 20 |
2341035 | 2341035 | 2022-03-25 | Rooks | Kansas | 20163 | 1367 | 20 |
2337782 | 2337782 | 2022-03-24 | Rooks | Kansas | 20163 | 1367 | 20 |
2334528 | 2334528 | 2022-03-23 | Rooks | Kansas | 20163 | 1367 | 20 |
2331274 | 2331274 | 2022-03-22 | Rooks | Kansas | 20163 | 1367 | 20 |
2328022 | 2328022 | 2022-03-21 | Rooks | Kansas | 20163 | 1367 | 20 |
2324769 | 2324769 | 2022-03-20 | Rooks | Kansas | 20163 | 1367 | 20 |
2321515 | 2321515 | 2022-03-19 | Rooks | Kansas | 20163 | 1367 | 20 |
2318261 | 2318261 | 2022-03-18 | Rooks | Kansas | 20163 | 1367 | 20 |
2315008 | 2315008 | 2022-03-17 | Rooks | Kansas | 20163 | 1367 | 20 |
2311755 | 2311755 | 2022-03-16 | Rooks | Kansas | 20163 | 1367 | 20 |
2308502 | 2308502 | 2022-03-15 | Rooks | Kansas | 20163 | 1367 | 20 |
2305251 | 2305251 | 2022-03-14 | Rooks | Kansas | 20163 | 1367 | 20 |
2301999 | 2301999 | 2022-03-13 | Rooks | Kansas | 20163 | 1367 | 20 |
2298747 | 2298747 | 2022-03-12 | Rooks | Kansas | 20163 | 1367 | 20 |
2295495 | 2295495 | 2022-03-11 | Rooks | Kansas | 20163 | 1367 | 20 |
2292243 | 2292243 | 2022-03-10 | Rooks | Kansas | 20163 | 1364 | 20 |
2288991 | 2288991 | 2022-03-09 | Rooks | Kansas | 20163 | 1364 | 20 |
2285740 | 2285740 | 2022-03-08 | Rooks | Kansas | 20163 | 1364 | 20 |
2282488 | 2282488 | 2022-03-07 | Rooks | Kansas | 20163 | 1364 | 20 |
2279235 | 2279235 | 2022-03-06 | Rooks | Kansas | 20163 | 1363 | 20 |
2275982 | 2275982 | 2022-03-05 | Rooks | Kansas | 20163 | 1363 | 20 |
2272729 | 2272729 | 2022-03-04 | Rooks | Kansas | 20163 | 1363 | 20 |
2269477 | 2269477 | 2022-03-03 | Rooks | Kansas | 20163 | 1361 | 20 |
2266224 | 2266224 | 2022-03-02 | Rooks | Kansas | 20163 | 1361 | 20 |
2262973 | 2262973 | 2022-03-01 | Rooks | Kansas | 20163 | 1349 | 20 |
2259722 | 2259722 | 2022-02-28 | Rooks | Kansas | 20163 | 1349 | 20 |
2256471 | 2256471 | 2022-02-27 | Rooks | Kansas | 20163 | 1349 | 20 |
2253220 | 2253220 | 2022-02-26 | Rooks | Kansas | 20163 | 1349 | 20 |
2249969 | 2249969 | 2022-02-25 | Rooks | Kansas | 20163 | 1349 | 20 |
2246718 | 2246718 | 2022-02-24 | Rooks | Kansas | 20163 | 1345 | 20 |
2243467 | 2243467 | 2022-02-23 | Rooks | Kansas | 20163 | 1345 | 20 |
2240216 | 2240216 | 2022-02-22 | Rooks | Kansas | 20163 | 1341 | 20 |
2236965 | 2236965 | 2022-02-21 | Rooks | Kansas | 20163 | 1341 | 20 |
2233714 | 2233714 | 2022-02-20 | Rooks | Kansas | 20163 | 1339 | 20 |
2230463 | 2230463 | 2022-02-19 | Rooks | Kansas | 20163 | 1339 | 20 |
2227212 | 2227212 | 2022-02-18 | Rooks | Kansas | 20163 | 1339 | 20 |
2223961 | 2223961 | 2022-02-17 | Rooks | Kansas | 20163 | 1335 | 20 |
2220710 | 2220710 | 2022-02-16 | Rooks | Kansas | 20163 | 1335 | 20 |
2217459 | 2217459 | 2022-02-15 | Rooks | Kansas | 20163 | 1328 | 20 |
2214208 | 2214208 | 2022-02-14 | Rooks | Kansas | 20163 | 1328 | 20 |
2210956 | 2210956 | 2022-02-13 | Rooks | Kansas | 20163 | 1318 | 20 |
2207703 | 2207703 | 2022-02-12 | Rooks | Kansas | 20163 | 1318 | 20 |
2204450 | 2204450 | 2022-02-11 | Rooks | Kansas | 20163 | 1318 | 20 |
2201197 | 2201197 | 2022-02-10 | Rooks | Kansas | 20163 | 1318 | 20 |
2197943 | 2197943 | 2022-02-09 | Rooks | Kansas | 20163 | 1318 | 20 |
2194689 | 2194689 | 2022-02-08 | Rooks | Kansas | 20163 | 1308 | 20 |
2191435 | 2191435 | 2022-02-07 | Rooks | Kansas | 20163 | 1308 | 20 |
2188182 | 2188182 | 2022-02-06 | Rooks | Kansas | 20163 | 1298 | 20 |
2184929 | 2184929 | 2022-02-05 | Rooks | Kansas | 20163 | 1298 | 20 |
2181677 | 2181677 | 2022-02-04 | Rooks | Kansas | 20163 | 1298 | 20 |
2178426 | 2178426 | 2022-02-03 | Rooks | Kansas | 20163 | 1289 | 18 |
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);