ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Shawnee" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635867 | 635867 | 2020-10-16 | Shawnee | Kansas | 20177 | 3235 | 69 |
632621 | 632621 | 2020-10-15 | Shawnee | Kansas | 20177 | 3185 | 65 |
629377 | 629377 | 2020-10-14 | Shawnee | Kansas | 20177 | 3180 | 65 |
626134 | 626134 | 2020-10-13 | Shawnee | Kansas | 20177 | 3116 | 62 |
622892 | 622892 | 2020-10-12 | Shawnee | Kansas | 20177 | 3116 | 62 |
619648 | 619648 | 2020-10-11 | Shawnee | Kansas | 20177 | 3020 | 62 |
616406 | 616406 | 2020-10-10 | Shawnee | Kansas | 20177 | 3020 | 62 |
613165 | 613165 | 2020-10-09 | Shawnee | Kansas | 20177 | 3020 | 62 |
609923 | 609923 | 2020-10-08 | Shawnee | Kansas | 20177 | 2975 | 60 |
606680 | 606680 | 2020-10-07 | Shawnee | Kansas | 20177 | 2975 | 34 |
603438 | 603438 | 2020-10-06 | Shawnee | Kansas | 20177 | 2925 | 34 |
600195 | 600195 | 2020-10-05 | Shawnee | Kansas | 20177 | 2925 | 34 |
596953 | 596953 | 2020-10-04 | Shawnee | Kansas | 20177 | 2864 | 34 |
593711 | 593711 | 2020-10-03 | Shawnee | Kansas | 20177 | 2864 | 34 |
590470 | 590470 | 2020-10-02 | Shawnee | Kansas | 20177 | 2864 | 34 |
587229 | 587229 | 2020-10-01 | Shawnee | Kansas | 20177 | 2804 | 32 |
583989 | 583989 | 2020-09-30 | Shawnee | Kansas | 20177 | 2804 | 32 |
580750 | 580750 | 2020-09-29 | Shawnee | Kansas | 20177 | 2765 | 32 |
577509 | 577509 | 2020-09-28 | Shawnee | Kansas | 20177 | 2765 | 32 |
574267 | 574267 | 2020-09-27 | Shawnee | Kansas | 20177 | 2710 | 32 |
571024 | 571024 | 2020-09-26 | Shawnee | Kansas | 20177 | 2710 | 32 |
567782 | 567782 | 2020-09-25 | Shawnee | Kansas | 20177 | 2710 | 32 |
564542 | 564542 | 2020-09-24 | Shawnee | Kansas | 20177 | 2671 | 32 |
561302 | 561302 | 2020-09-23 | Shawnee | Kansas | 20177 | 2671 | 30 |
558066 | 558066 | 2020-09-22 | Shawnee | Kansas | 20177 | 2608 | 30 |
554829 | 554829 | 2020-09-21 | Shawnee | Kansas | 20177 | 2602 | 30 |
551590 | 551590 | 2020-09-20 | Shawnee | Kansas | 20177 | 2563 | 28 |
548351 | 548351 | 2020-09-19 | Shawnee | Kansas | 20177 | 2563 | 28 |
545113 | 545113 | 2020-09-18 | Shawnee | Kansas | 20177 | 2563 | 28 |
541877 | 541877 | 2020-09-17 | Shawnee | Kansas | 20177 | 2523 | 28 |
538640 | 538640 | 2020-09-16 | Shawnee | Kansas | 20177 | 2523 | 28 |
535404 | 535404 | 2020-09-15 | Shawnee | Kansas | 20177 | 2496 | 27 |
532169 | 532169 | 2020-09-14 | Shawnee | Kansas | 20177 | 2496 | 27 |
528932 | 528932 | 2020-09-13 | Shawnee | Kansas | 20177 | 2448 | 27 |
525696 | 525696 | 2020-09-12 | Shawnee | Kansas | 20177 | 2448 | 27 |
522460 | 522460 | 2020-09-11 | Shawnee | Kansas | 20177 | 2448 | 27 |
519223 | 519223 | 2020-09-10 | Shawnee | Kansas | 20177 | 2420 | 27 |
515988 | 515988 | 2020-09-09 | Shawnee | Kansas | 20177 | 2420 | 27 |
512755 | 512755 | 2020-09-08 | Shawnee | Kansas | 20177 | 2387 | 23 |
509522 | 509522 | 2020-09-07 | Shawnee | Kansas | 20177 | 2387 | 23 |
506290 | 506290 | 2020-09-06 | Shawnee | Kansas | 20177 | 2305 | 23 |
503056 | 503056 | 2020-09-05 | Shawnee | Kansas | 20177 | 2305 | 23 |
499822 | 499822 | 2020-09-04 | Shawnee | Kansas | 20177 | 2305 | 23 |
496589 | 496589 | 2020-09-03 | Shawnee | Kansas | 20177 | 2259 | 22 |
493355 | 493355 | 2020-09-02 | Shawnee | Kansas | 20177 | 2251 | 22 |
490122 | 490122 | 2020-09-01 | Shawnee | Kansas | 20177 | 2199 | 22 |
486889 | 486889 | 2020-08-31 | Shawnee | Kansas | 20177 | 2186 | 22 |
483654 | 483654 | 2020-08-30 | Shawnee | Kansas | 20177 | 2125 | 22 |
480420 | 480420 | 2020-08-29 | Shawnee | Kansas | 20177 | 2125 | 22 |
477187 | 477187 | 2020-08-28 | Shawnee | Kansas | 20177 | 2125 | 22 |
473954 | 473954 | 2020-08-27 | Shawnee | Kansas | 20177 | 2094 | 22 |
470722 | 470722 | 2020-08-26 | Shawnee | Kansas | 20177 | 2058 | 21 |
467493 | 467493 | 2020-08-25 | Shawnee | Kansas | 20177 | 2010 | 21 |
464264 | 464264 | 2020-08-24 | Shawnee | Kansas | 20177 | 1994 | 21 |
461034 | 461034 | 2020-08-23 | Shawnee | Kansas | 20177 | 1971 | 21 |
457807 | 457807 | 2020-08-22 | Shawnee | Kansas | 20177 | 1942 | 21 |
454579 | 454579 | 2020-08-21 | Shawnee | Kansas | 20177 | 1942 | 21 |
451351 | 451351 | 2020-08-20 | Shawnee | Kansas | 20177 | 1910 | 21 |
448123 | 448123 | 2020-08-19 | Shawnee | Kansas | 20177 | 1868 | 21 |
444896 | 444896 | 2020-08-18 | Shawnee | Kansas | 20177 | 1810 | 21 |
441670 | 441670 | 2020-08-17 | Shawnee | Kansas | 20177 | 1787 | 19 |
438443 | 438443 | 2020-08-16 | Shawnee | Kansas | 20177 | 1755 | 19 |
435218 | 435218 | 2020-08-15 | Shawnee | Kansas | 20177 | 1720 | 19 |
431993 | 431993 | 2020-08-14 | Shawnee | Kansas | 20177 | 1720 | 19 |
428765 | 428765 | 2020-08-13 | Shawnee | Kansas | 20177 | 1682 | 19 |
425541 | 425541 | 2020-08-12 | Shawnee | Kansas | 20177 | 1653 | 19 |
422320 | 422320 | 2020-08-11 | Shawnee | Kansas | 20177 | 1611 | 19 |
419097 | 419097 | 2020-08-10 | Shawnee | Kansas | 20177 | 1588 | 19 |
415876 | 415876 | 2020-08-09 | Shawnee | Kansas | 20177 | 1550 | 19 |
412656 | 412656 | 2020-08-08 | Shawnee | Kansas | 20177 | 1522 | 19 |
409436 | 409436 | 2020-08-07 | Shawnee | Kansas | 20177 | 1522 | 19 |
406217 | 406217 | 2020-08-06 | Shawnee | Kansas | 20177 | 1494 | 19 |
402999 | 402999 | 2020-08-05 | Shawnee | Kansas | 20177 | 1476 | 19 |
399782 | 399782 | 2020-08-04 | Shawnee | Kansas | 20177 | 1443 | 19 |
396567 | 396567 | 2020-08-03 | Shawnee | Kansas | 20177 | 1443 | 19 |
393351 | 393351 | 2020-08-02 | Shawnee | Kansas | 20177 | 1420 | 19 |
390134 | 390134 | 2020-08-01 | Shawnee | Kansas | 20177 | 1398 | 19 |
386917 | 386917 | 2020-07-31 | Shawnee | Kansas | 20177 | 1398 | 19 |
383699 | 383699 | 2020-07-30 | Shawnee | Kansas | 20177 | 1379 | 19 |
380482 | 380482 | 2020-07-29 | Shawnee | Kansas | 20177 | 1374 | 19 |
377265 | 377265 | 2020-07-28 | Shawnee | Kansas | 20177 | 1328 | 19 |
374050 | 374050 | 2020-07-27 | Shawnee | Kansas | 20177 | 1324 | 19 |
370838 | 370838 | 2020-07-26 | Shawnee | Kansas | 20177 | 1295 | 19 |
367628 | 367628 | 2020-07-25 | Shawnee | Kansas | 20177 | 1268 | 17 |
364421 | 364421 | 2020-07-24 | Shawnee | Kansas | 20177 | 1268 | 17 |
361214 | 361214 | 2020-07-23 | Shawnee | Kansas | 20177 | 1241 | 15 |
358009 | 358009 | 2020-07-22 | Shawnee | Kansas | 20177 | 1237 | 14 |
354807 | 354807 | 2020-07-21 | Shawnee | Kansas | 20177 | 1205 | 14 |
351605 | 351605 | 2020-07-20 | Shawnee | Kansas | 20177 | 1205 | 14 |
348405 | 348405 | 2020-07-19 | Shawnee | Kansas | 20177 | 1159 | 13 |
345204 | 345204 | 2020-07-18 | Shawnee | Kansas | 20177 | 1159 | 13 |
342004 | 342004 | 2020-07-17 | Shawnee | Kansas | 20177 | 1146 | 13 |
338808 | 338808 | 2020-07-16 | Shawnee | Kansas | 20177 | 1109 | 13 |
335612 | 335612 | 2020-07-15 | Shawnee | Kansas | 20177 | 1092 | 13 |
332419 | 332419 | 2020-07-14 | Shawnee | Kansas | 20177 | 1066 | 13 |
329232 | 329232 | 2020-07-13 | Shawnee | Kansas | 20177 | 1048 | 13 |
326046 | 326046 | 2020-07-12 | Shawnee | Kansas | 20177 | 990 | 13 |
322863 | 322863 | 2020-07-11 | Shawnee | Kansas | 20177 | 990 | 13 |
319684 | 319684 | 2020-07-10 | Shawnee | Kansas | 20177 | 964 | 13 |
316509 | 316509 | 2020-07-09 | Shawnee | Kansas | 20177 | 918 | 13 |
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);