ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,448 rows where county = "Wichita" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 282 ✖
- 0 298
- 6 198
- 8 179
- 2 78
- 381 34
- 377 28
- 674 19
- 5 15
- 9 13
- 25 13
- 14 12
- 374 12
- 11 10
- 677 10
- 3 9
- 19 9
- 368 9
- 379 9
- 539 9
- 672 9
- 373 8
- 16 7
- 375 7
- 376 7
- 7 6
- 26 6
- 369 6
- 384 6
- 388 6
- 397 6
- 541 6
- 315 5
- 367 5
- 386 5
- 395 5
- 409 5
- 533 5
- 536 5
- 600 5
- 660 5
- 24 4
- 359 4
- 364 4
- 418 4
- 518 4
- 523 4
- 545 4
- 568 4
- 650 4
- 665 4
- 671 4
- 1 3
- 12 3
- 13 3
- 20 3
- 22 3
- 31 3
- 33 3
- 49 3
- 219 3
- 283 3
- 295 3
- 328 3
- 330 3
- 405 3
- 439 3
- 476 3
- 532 3
- 534 3
- 540 3
- 557 3
- 631 3
- 649 3
- 679 3
- 10 2
- 17 2
- 58 2
- 62 2
- 74 2
- 88 2
- 116 2
- 194 2
- 241 2
- 258 2
- 346 2
- 366 2
- 380 2
- 403 2
- 420 2
- 424 2
- 425 2
- 449 2
- 455 2
- 466 2
- 471 2
- 481 2
- 486 2
- 495 2
- 510 2
- 512 2
- 528 2
- 543 2
- 551 2
- 556 2
- 564 2
- 565 2
- 569 2
- 585 2
- 612 2
- 648 2
- 658 2
- 675 2
- 23 1
- 30 1
- 41 1
- 44 1
- 45 1
- 46 1
- 52 1
- 53 1
- 61 1
- 66 1
- 76 1
- 79 1
- 90 1
- 93 1
- 97 1
- 98 1
- 101 1
- 102 1
- 104 1
- 110 1
- 117 1
- 120 1
- 122 1
- 123 1
- 125 1
- 135 1
- 136 1
- 141 1
- 143 1
- 145 1
- 146 1
- 152 1
- 155 1
- 161 1
- 167 1
- 169 1
- 170 1
- 172 1
- 175 1
- 177 1
- 178 1
- 180 1
- 182 1
- 183 1
- 187 1
- 189 1
- 191 1
- 192 1
- 195 1
- 197 1
- 202 1
- 210 1
- 216 1
- 218 1
- 225 1
- 228 1
- 231 1
- 237 1
- 242 1
- 245 1
- 248 1
- 250 1
- 255 1
- 257 1
- 260 1
- 264 1
- 267 1
- 275 1
- 288 1
- 289 1
- 291 1
- 292 1
- 297 1
- 301 1
- 317 1
- 320 1
- 322 1
- 326 1
- 327 1
- 332 1
- 333 1
- 334 1
- 336 1
- 341 1
- 343 1
- 344 1
- 345 1
- 351 1
- 352 1
- 353 1
- 356 1
- 360 1
- 361 1
- 387 1
- 390 1
- 391 1
- 393 1
- 399 1
- 402 1
- 406 1
- 407 1
- 408 1
- 410 1
- 414 1
- 415 1
- 426 1
- 431 1
- 434 1
- 436 1
- 441 1
- 452 1
- 454 1
- 457 1
- 461 1
- 464 1
- 472 1
- 480 1
- 485 1
- 487 1
- 494 1
- 500 1
- 501 1
- 502 1
- 508 1
- 509 1
- 513 1
- 515 1
- 517 1
- 520 1
- 527 1
- 530 1
- 531 1
- 535 1
- 538 1
- 542 1
- 549 1
- 553 1
- 554 1
- 555 1
- 566 1
- 571 1
- 578 1
- 580 1
- 583 1
- 584 1
- 586 1
- 590 1
- 603 1
- 605 1
- 608 1
- 610 1
- 611 1
- 615 1
- 617 1
- 629 1
- 630 1
- 632 1
- 634 1
- 637 1
- 642 1
- 645 1
- 651 1
- 654 1
- 662 1
- 663 1
- 667 1
- 669 1
- 670 1
- 673 1
- 676 1
county 1
- Wichita · 1,448 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500575 | 2500575 | 2022-05-13 | Wichita | Kansas | 20203 | 493 | 8 |
2502450 | 2502450 | 2022-05-13 | Wichita | Texas | 48485 | 34143 | 679 |
2497317 | 2497317 | 2022-05-12 | Wichita | Kansas | 20203 | 493 | 8 |
2499192 | 2499192 | 2022-05-12 | Wichita | Texas | 48485 | 34088 | 679 |
2494059 | 2494059 | 2022-05-11 | Wichita | Kansas | 20203 | 493 | 8 |
2495934 | 2495934 | 2022-05-11 | Wichita | Texas | 48485 | 34088 | 679 |
2490801 | 2490801 | 2022-05-10 | Wichita | Kansas | 20203 | 493 | 8 |
2492676 | 2492676 | 2022-05-10 | Wichita | Texas | 48485 | 34088 | 677 |
2487544 | 2487544 | 2022-05-09 | Wichita | Kansas | 20203 | 493 | 8 |
2489418 | 2489418 | 2022-05-09 | Wichita | Texas | 48485 | 34048 | 677 |
2484286 | 2484286 | 2022-05-08 | Wichita | Kansas | 20203 | 493 | 8 |
2486160 | 2486160 | 2022-05-08 | Wichita | Texas | 48485 | 34048 | 677 |
2481028 | 2481028 | 2022-05-07 | Wichita | Kansas | 20203 | 493 | 8 |
2482902 | 2482902 | 2022-05-07 | Wichita | Texas | 48485 | 34048 | 677 |
2477770 | 2477770 | 2022-05-06 | Wichita | Kansas | 20203 | 493 | 8 |
2479644 | 2479644 | 2022-05-06 | Wichita | Texas | 48485 | 34048 | 677 |
2474512 | 2474512 | 2022-05-05 | Wichita | Kansas | 20203 | 493 | 8 |
2476386 | 2476386 | 2022-05-05 | Wichita | Texas | 48485 | 34048 | 676 |
2471255 | 2471255 | 2022-05-04 | Wichita | Kansas | 20203 | 493 | 8 |
2473129 | 2473129 | 2022-05-04 | Wichita | Texas | 48485 | 34048 | 677 |
2467999 | 2467999 | 2022-05-03 | Wichita | Kansas | 20203 | 493 | 8 |
2469873 | 2469873 | 2022-05-03 | Wichita | Texas | 48485 | 34048 | 677 |
2464744 | 2464744 | 2022-05-02 | Wichita | Kansas | 20203 | 493 | 8 |
2466617 | 2466617 | 2022-05-02 | Wichita | Texas | 48485 | 34048 | 677 |
2461488 | 2461488 | 2022-05-01 | Wichita | Kansas | 20203 | 493 | 8 |
2463362 | 2463362 | 2022-05-01 | Wichita | Texas | 48485 | 34048 | 677 |
2458232 | 2458232 | 2022-04-30 | Wichita | Kansas | 20203 | 493 | 8 |
2460106 | 2460106 | 2022-04-30 | Wichita | Texas | 48485 | 34048 | 677 |
2454976 | 2454976 | 2022-04-29 | Wichita | Kansas | 20203 | 493 | 8 |
2456850 | 2456850 | 2022-04-29 | Wichita | Texas | 48485 | 34048 | 675 |
2451720 | 2451720 | 2022-04-28 | Wichita | Kansas | 20203 | 493 | 8 |
2453594 | 2453594 | 2022-04-28 | Wichita | Texas | 48485 | 34026 | 675 |
2448464 | 2448464 | 2022-04-27 | Wichita | Kansas | 20203 | 493 | 8 |
2450338 | 2450338 | 2022-04-27 | Wichita | Texas | 48485 | 34026 | 674 |
2445208 | 2445208 | 2022-04-26 | Wichita | Kansas | 20203 | 493 | 8 |
2447081 | 2447081 | 2022-04-26 | Wichita | Texas | 48485 | 34026 | 674 |
2441952 | 2441952 | 2022-04-25 | Wichita | Kansas | 20203 | 493 | 8 |
2443826 | 2443826 | 2022-04-25 | Wichita | Texas | 48485 | 34026 | 674 |
2438696 | 2438696 | 2022-04-24 | Wichita | Kansas | 20203 | 493 | 8 |
2440570 | 2440570 | 2022-04-24 | Wichita | Texas | 48485 | 34026 | 674 |
2435440 | 2435440 | 2022-04-23 | Wichita | Kansas | 20203 | 493 | 8 |
2437314 | 2437314 | 2022-04-23 | Wichita | Texas | 48485 | 34026 | 674 |
2432184 | 2432184 | 2022-04-22 | Wichita | Kansas | 20203 | 493 | 8 |
2434058 | 2434058 | 2022-04-22 | Wichita | Texas | 48485 | 34026 | 674 |
2428928 | 2428928 | 2022-04-21 | Wichita | Kansas | 20203 | 493 | 8 |
2430802 | 2430802 | 2022-04-21 | Wichita | Texas | 48485 | 34011 | 674 |
2425672 | 2425672 | 2022-04-20 | Wichita | Kansas | 20203 | 493 | 8 |
2427546 | 2427546 | 2022-04-20 | Wichita | Texas | 48485 | 34011 | 674 |
2422416 | 2422416 | 2022-04-19 | Wichita | Kansas | 20203 | 493 | 8 |
2424290 | 2424290 | 2022-04-19 | Wichita | Texas | 48485 | 34011 | 674 |
2419160 | 2419160 | 2022-04-18 | Wichita | Kansas | 20203 | 493 | 8 |
2421034 | 2421034 | 2022-04-18 | Wichita | Texas | 48485 | 34011 | 674 |
2415904 | 2415904 | 2022-04-17 | Wichita | Kansas | 20203 | 493 | 8 |
2417778 | 2417778 | 2022-04-17 | Wichita | Texas | 48485 | 34011 | 674 |
2412648 | 2412648 | 2022-04-16 | Wichita | Kansas | 20203 | 493 | 8 |
2414522 | 2414522 | 2022-04-16 | Wichita | Texas | 48485 | 34011 | 674 |
2409392 | 2409392 | 2022-04-15 | Wichita | Kansas | 20203 | 493 | 8 |
2411266 | 2411266 | 2022-04-15 | Wichita | Texas | 48485 | 34011 | 674 |
2406136 | 2406136 | 2022-04-14 | Wichita | Kansas | 20203 | 493 | 8 |
2408010 | 2408010 | 2022-04-14 | Wichita | Texas | 48485 | 33997 | 674 |
2402880 | 2402880 | 2022-04-13 | Wichita | Kansas | 20203 | 493 | 8 |
2404754 | 2404754 | 2022-04-13 | Wichita | Texas | 48485 | 33997 | 674 |
2399626 | 2399626 | 2022-04-12 | Wichita | Kansas | 20203 | 493 | 8 |
2401499 | 2401499 | 2022-04-12 | Wichita | Texas | 48485 | 33997 | 674 |
2396370 | 2396370 | 2022-04-11 | Wichita | Kansas | 20203 | 493 | 8 |
2398244 | 2398244 | 2022-04-11 | Wichita | Texas | 48485 | 33997 | 674 |
2393115 | 2393115 | 2022-04-10 | Wichita | Kansas | 20203 | 493 | 8 |
2394989 | 2394989 | 2022-04-10 | Wichita | Texas | 48485 | 33997 | 674 |
2389859 | 2389859 | 2022-04-09 | Wichita | Kansas | 20203 | 493 | 8 |
2391733 | 2391733 | 2022-04-09 | Wichita | Texas | 48485 | 33997 | 674 |
2386603 | 2386603 | 2022-04-08 | Wichita | Kansas | 20203 | 493 | 8 |
2388477 | 2388477 | 2022-04-08 | Wichita | Texas | 48485 | 33997 | 672 |
2383348 | 2383348 | 2022-04-07 | Wichita | Kansas | 20203 | 493 | 8 |
2385222 | 2385222 | 2022-04-07 | Wichita | Texas | 48485 | 33990 | 672 |
2380093 | 2380093 | 2022-04-06 | Wichita | Kansas | 20203 | 493 | 8 |
2381967 | 2381967 | 2022-04-06 | Wichita | Texas | 48485 | 33990 | 672 |
2376838 | 2376838 | 2022-04-05 | Wichita | Kansas | 20203 | 493 | 8 |
2378712 | 2378712 | 2022-04-05 | Wichita | Texas | 48485 | 33990 | 672 |
2373586 | 2373586 | 2022-04-04 | Wichita | Kansas | 20203 | 493 | 8 |
2375458 | 2375458 | 2022-04-04 | Wichita | Texas | 48485 | 33990 | 672 |
2370333 | 2370333 | 2022-04-03 | Wichita | Kansas | 20203 | 493 | 8 |
2372206 | 2372206 | 2022-04-03 | Wichita | Texas | 48485 | 33982 | 672 |
2367080 | 2367080 | 2022-04-02 | Wichita | Kansas | 20203 | 493 | 8 |
2368953 | 2368953 | 2022-04-02 | Wichita | Texas | 48485 | 33982 | 673 |
2363827 | 2363827 | 2022-04-01 | Wichita | Kansas | 20203 | 493 | 8 |
2365700 | 2365700 | 2022-04-01 | Wichita | Texas | 48485 | 33982 | 672 |
2360573 | 2360573 | 2022-03-31 | Wichita | Kansas | 20203 | 493 | 8 |
2362447 | 2362447 | 2022-03-31 | Wichita | Texas | 48485 | 33982 | 672 |
2357319 | 2357319 | 2022-03-30 | Wichita | Kansas | 20203 | 493 | 8 |
2359193 | 2359193 | 2022-03-30 | Wichita | Texas | 48485 | 33982 | 672 |
2354066 | 2354066 | 2022-03-29 | Wichita | Kansas | 20203 | 493 | 8 |
2355939 | 2355939 | 2022-03-29 | Wichita | Texas | 48485 | 33982 | 671 |
2350814 | 2350814 | 2022-03-28 | Wichita | Kansas | 20203 | 493 | 8 |
2352686 | 2352686 | 2022-03-28 | Wichita | Texas | 48485 | 33982 | 671 |
2347561 | 2347561 | 2022-03-27 | Wichita | Kansas | 20203 | 493 | 8 |
2349434 | 2349434 | 2022-03-27 | Wichita | Texas | 48485 | 33982 | 671 |
2344308 | 2344308 | 2022-03-26 | Wichita | Kansas | 20203 | 493 | 8 |
2346181 | 2346181 | 2022-03-26 | Wichita | Texas | 48485 | 33982 | 671 |
2341055 | 2341055 | 2022-03-25 | Wichita | Kansas | 20203 | 493 | 8 |
2342928 | 2342928 | 2022-03-25 | Wichita | Texas | 48485 | 33982 | 670 |
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);