ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,455 rows where county = "Sedgwick" 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 |
---|---|---|---|---|---|---|---|
2499878 | 2499878 | 2022-05-13 | Sedgwick | Colorado | 8115 | 490 | 11 |
2500559 | 2500559 | 2022-05-13 | Sedgwick | Kansas | 20173 | 145517 | 1424 |
2496620 | 2496620 | 2022-05-12 | Sedgwick | Colorado | 8115 | 490 | 11 |
2497301 | 2497301 | 2022-05-12 | Sedgwick | Kansas | 20173 | 145185 | 1424 |
2493362 | 2493362 | 2022-05-11 | Sedgwick | Colorado | 8115 | 489 | 11 |
2494043 | 2494043 | 2022-05-11 | Sedgwick | Kansas | 20173 | 145185 | 1424 |
2490104 | 2490104 | 2022-05-10 | Sedgwick | Colorado | 8115 | 489 | 10 |
2490785 | 2490785 | 2022-05-10 | Sedgwick | Kansas | 20173 | 145185 | 1424 |
2486847 | 2486847 | 2022-05-09 | Sedgwick | Colorado | 8115 | 487 | 10 |
2487528 | 2487528 | 2022-05-09 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2483589 | 2483589 | 2022-05-08 | Sedgwick | Colorado | 8115 | 487 | 10 |
2484270 | 2484270 | 2022-05-08 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2480331 | 2480331 | 2022-05-07 | Sedgwick | Colorado | 8115 | 487 | 10 |
2481012 | 2481012 | 2022-05-07 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2477073 | 2477073 | 2022-05-06 | Sedgwick | Colorado | 8115 | 487 | 10 |
2477754 | 2477754 | 2022-05-06 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2473815 | 2473815 | 2022-05-05 | Sedgwick | Colorado | 8115 | 486 | 10 |
2474496 | 2474496 | 2022-05-05 | Sedgwick | Kansas | 20173 | 144967 | 1411 |
2470558 | 2470558 | 2022-05-04 | Sedgwick | Colorado | 8115 | 486 | 10 |
2471239 | 2471239 | 2022-05-04 | Sedgwick | Kansas | 20173 | 144967 | 1411 |
2467302 | 2467302 | 2022-05-03 | Sedgwick | Colorado | 8115 | 486 | 10 |
2467983 | 2467983 | 2022-05-03 | Sedgwick | Kansas | 20173 | 144967 | 1411 |
2464047 | 2464047 | 2022-05-02 | Sedgwick | Colorado | 8115 | 484 | 10 |
2464728 | 2464728 | 2022-05-02 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2460791 | 2460791 | 2022-05-01 | Sedgwick | Colorado | 8115 | 485 | 10 |
2461472 | 2461472 | 2022-05-01 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2457535 | 2457535 | 2022-04-30 | Sedgwick | Colorado | 8115 | 485 | 10 |
2458216 | 2458216 | 2022-04-30 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2454279 | 2454279 | 2022-04-29 | Sedgwick | Colorado | 8115 | 485 | 10 |
2454960 | 2454960 | 2022-04-29 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2451023 | 2451023 | 2022-04-28 | Sedgwick | Colorado | 8115 | 485 | 10 |
2451704 | 2451704 | 2022-04-28 | Sedgwick | Kansas | 20173 | 144742 | 1399 |
2447767 | 2447767 | 2022-04-27 | Sedgwick | Colorado | 8115 | 485 | 10 |
2448448 | 2448448 | 2022-04-27 | Sedgwick | Kansas | 20173 | 144742 | 1399 |
2444511 | 2444511 | 2022-04-26 | Sedgwick | Colorado | 8115 | 484 | 10 |
2445192 | 2445192 | 2022-04-26 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2441255 | 2441255 | 2022-04-25 | Sedgwick | Colorado | 8115 | 484 | 10 |
2441936 | 2441936 | 2022-04-25 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2437999 | 2437999 | 2022-04-24 | Sedgwick | Colorado | 8115 | 484 | 10 |
2438680 | 2438680 | 2022-04-24 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2434743 | 2434743 | 2022-04-23 | Sedgwick | Colorado | 8115 | 484 | 10 |
2435424 | 2435424 | 2022-04-23 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2431487 | 2431487 | 2022-04-22 | Sedgwick | Colorado | 8115 | 484 | 10 |
2432168 | 2432168 | 2022-04-22 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2428231 | 2428231 | 2022-04-21 | Sedgwick | Colorado | 8115 | 484 | 10 |
2428912 | 2428912 | 2022-04-21 | Sedgwick | Kansas | 20173 | 144623 | 1387 |
2424975 | 2424975 | 2022-04-20 | Sedgwick | Colorado | 8115 | 484 | 9 |
2425656 | 2425656 | 2022-04-20 | Sedgwick | Kansas | 20173 | 144623 | 1387 |
2421719 | 2421719 | 2022-04-19 | Sedgwick | Colorado | 8115 | 483 | 9 |
2422400 | 2422400 | 2022-04-19 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2418463 | 2418463 | 2022-04-18 | Sedgwick | Colorado | 8115 | 483 | 9 |
2419144 | 2419144 | 2022-04-18 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2415207 | 2415207 | 2022-04-17 | Sedgwick | Colorado | 8115 | 483 | 9 |
2415888 | 2415888 | 2022-04-17 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2411951 | 2411951 | 2022-04-16 | Sedgwick | Colorado | 8115 | 483 | 9 |
2412632 | 2412632 | 2022-04-16 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2408695 | 2408695 | 2022-04-15 | Sedgwick | Colorado | 8115 | 483 | 9 |
2409376 | 2409376 | 2022-04-15 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2405439 | 2405439 | 2022-04-14 | Sedgwick | Colorado | 8115 | 483 | 9 |
2406120 | 2406120 | 2022-04-14 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2402184 | 2402184 | 2022-04-13 | Sedgwick | Colorado | 8115 | 483 | 9 |
2402864 | 2402864 | 2022-04-13 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2398929 | 2398929 | 2022-04-12 | Sedgwick | Colorado | 8115 | 483 | 9 |
2399610 | 2399610 | 2022-04-12 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2395674 | 2395674 | 2022-04-11 | Sedgwick | Colorado | 8115 | 483 | 9 |
2396354 | 2396354 | 2022-04-11 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2392418 | 2392418 | 2022-04-10 | Sedgwick | Colorado | 8115 | 482 | 9 |
2393099 | 2393099 | 2022-04-10 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2389162 | 2389162 | 2022-04-09 | Sedgwick | Colorado | 8115 | 482 | 9 |
2389843 | 2389843 | 2022-04-09 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2385907 | 2385907 | 2022-04-08 | Sedgwick | Colorado | 8115 | 482 | 9 |
2386587 | 2386587 | 2022-04-08 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2382652 | 2382652 | 2022-04-07 | Sedgwick | Colorado | 8115 | 483 | 9 |
2383333 | 2383333 | 2022-04-07 | Sedgwick | Kansas | 20173 | 144436 | 1360 |
2379397 | 2379397 | 2022-04-06 | Sedgwick | Colorado | 8115 | 482 | 9 |
2380078 | 2380078 | 2022-04-06 | Sedgwick | Kansas | 20173 | 144436 | 1360 |
2376143 | 2376143 | 2022-04-05 | Sedgwick | Colorado | 8115 | 482 | 9 |
2376823 | 2376823 | 2022-04-05 | Sedgwick | Kansas | 20173 | 144436 | 1360 |
2372891 | 2372891 | 2022-04-04 | Sedgwick | Colorado | 8115 | 482 | 9 |
2373571 | 2373571 | 2022-04-04 | Sedgwick | Kansas | 20173 | 144436 | 1360 |
2369638 | 2369638 | 2022-04-03 | Sedgwick | Colorado | 8115 | 482 | 9 |
2370318 | 2370318 | 2022-04-03 | Sedgwick | Kansas | 20173 | 144436 | 1360 |
2366385 | 2366385 | 2022-04-02 | Sedgwick | Colorado | 8115 | 482 | 9 |
2367065 | 2367065 | 2022-04-02 | Sedgwick | Kansas | 20173 | 144436 | 1360 |
2363132 | 2363132 | 2022-04-01 | Sedgwick | Colorado | 8115 | 482 | 9 |
2363812 | 2363812 | 2022-04-01 | Sedgwick | Kansas | 20173 | 144436 | 1360 |
2359878 | 2359878 | 2022-03-31 | Sedgwick | Colorado | 8115 | 482 | 9 |
2360558 | 2360558 | 2022-03-31 | Sedgwick | Kansas | 20173 | 144418 | 1336 |
2356624 | 2356624 | 2022-03-30 | Sedgwick | Colorado | 8115 | 482 | 9 |
2357304 | 2357304 | 2022-03-30 | Sedgwick | Kansas | 20173 | 144418 | 1336 |
2353371 | 2353371 | 2022-03-29 | Sedgwick | Colorado | 8115 | 482 | 9 |
2354051 | 2354051 | 2022-03-29 | Sedgwick | Kansas | 20173 | 144388 | 1313 |
2350119 | 2350119 | 2022-03-28 | Sedgwick | Colorado | 8115 | 481 | 9 |
2350799 | 2350799 | 2022-03-28 | Sedgwick | Kansas | 20173 | 144388 | 1313 |
2346866 | 2346866 | 2022-03-27 | Sedgwick | Colorado | 8115 | 481 | 9 |
2347546 | 2347546 | 2022-03-27 | Sedgwick | Kansas | 20173 | 144384 | 1313 |
2343613 | 2343613 | 2022-03-26 | Sedgwick | Colorado | 8115 | 481 | 9 |
2344293 | 2344293 | 2022-03-26 | Sedgwick | Kansas | 20173 | 144384 | 1313 |
2340360 | 2340360 | 2022-03-25 | Sedgwick | Colorado | 8115 | 481 | 9 |
2341040 | 2341040 | 2022-03-25 | Sedgwick | Kansas | 20173 | 144384 | 1313 |
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);