ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Johnson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
765601 | 765601 | 2020-11-25 | Johnson | Kansas | 20091 | 25931 | 284 |
762356 | 762356 | 2020-11-24 | Johnson | Kansas | 20091 | 25025 | 283 |
759111 | 759111 | 2020-11-23 | Johnson | Kansas | 20091 | 25025 | 274 |
755864 | 755864 | 2020-11-22 | Johnson | Kansas | 20091 | 23891 | 271 |
752618 | 752618 | 2020-11-21 | Johnson | Kansas | 20091 | 23891 | 271 |
749372 | 749372 | 2020-11-20 | Johnson | Kansas | 20091 | 23891 | 266 |
746126 | 746126 | 2020-11-19 | Johnson | Kansas | 20091 | 22826 | 260 |
742879 | 742879 | 2020-11-18 | Johnson | Kansas | 20091 | 22826 | 252 |
739632 | 739632 | 2020-11-17 | Johnson | Kansas | 20091 | 21981 | 253 |
736388 | 736388 | 2020-11-16 | Johnson | Kansas | 20091 | 21981 | 248 |
733142 | 733142 | 2020-11-15 | Johnson | Kansas | 20091 | 20946 | 244 |
729897 | 729897 | 2020-11-14 | Johnson | Kansas | 20091 | 20946 | 244 |
726654 | 726654 | 2020-11-13 | Johnson | Kansas | 20091 | 20946 | 243 |
723411 | 723411 | 2020-11-12 | Johnson | Kansas | 20091 | 19808 | 239 |
720168 | 720168 | 2020-11-11 | Johnson | Kansas | 20091 | 19808 | 238 |
716925 | 716925 | 2020-11-10 | Johnson | Kansas | 20091 | 18783 | 236 |
713681 | 713681 | 2020-11-09 | Johnson | Kansas | 20091 | 18783 | 235 |
710437 | 710437 | 2020-11-08 | Johnson | Kansas | 20091 | 17858 | 233 |
707193 | 707193 | 2020-11-07 | Johnson | Kansas | 20091 | 17858 | 233 |
703950 | 703950 | 2020-11-06 | Johnson | Kansas | 20091 | 17858 | 229 |
700708 | 700708 | 2020-11-05 | Johnson | Kansas | 20091 | 17039 | 226 |
697464 | 697464 | 2020-11-04 | Johnson | Kansas | 20091 | 17039 | 222 |
694222 | 694222 | 2020-11-03 | Johnson | Kansas | 20091 | 16522 | 219 |
690979 | 690979 | 2020-11-02 | Johnson | Kansas | 20091 | 16522 | 213 |
687734 | 687734 | 2020-11-01 | Johnson | Kansas | 20091 | 15817 | 205 |
684490 | 684490 | 2020-10-31 | Johnson | Kansas | 20091 | 15817 | 205 |
681247 | 681247 | 2020-10-30 | Johnson | Kansas | 20091 | 15817 | 203 |
678004 | 678004 | 2020-10-29 | Johnson | Kansas | 20091 | 15320 | 201 |
674761 | 674761 | 2020-10-28 | Johnson | Kansas | 20091 | 15320 | 199 |
671519 | 671519 | 2020-10-27 | Johnson | Kansas | 20091 | 14581 | 196 |
668276 | 668276 | 2020-10-26 | Johnson | Kansas | 20091 | 14581 | 192 |
665032 | 665032 | 2020-10-25 | Johnson | Kansas | 20091 | 14148 | 192 |
661787 | 661787 | 2020-10-24 | Johnson | Kansas | 20091 | 14148 | 192 |
658543 | 658543 | 2020-10-23 | Johnson | Kansas | 20091 | 14148 | 190 |
655298 | 655298 | 2020-10-22 | Johnson | Kansas | 20091 | 13906 | 185 |
652053 | 652053 | 2020-10-21 | Johnson | Kansas | 20091 | 13906 | 183 |
648809 | 648809 | 2020-10-20 | Johnson | Kansas | 20091 | 13702 | 178 |
645564 | 645564 | 2020-10-19 | Johnson | Kansas | 20091 | 13702 | 173 |
642317 | 642317 | 2020-10-18 | Johnson | Kansas | 20091 | 13410 | 173 |
639070 | 639070 | 2020-10-17 | Johnson | Kansas | 20091 | 13410 | 173 |
635824 | 635824 | 2020-10-16 | Johnson | Kansas | 20091 | 13410 | 173 |
632578 | 632578 | 2020-10-15 | Johnson | Kansas | 20091 | 13167 | 171 |
629334 | 629334 | 2020-10-14 | Johnson | Kansas | 20091 | 13167 | 171 |
626091 | 626091 | 2020-10-13 | Johnson | Kansas | 20091 | 12932 | 168 |
622849 | 622849 | 2020-10-12 | Johnson | Kansas | 20091 | 12932 | 163 |
619605 | 619605 | 2020-10-11 | Johnson | Kansas | 20091 | 12620 | 163 |
616363 | 616363 | 2020-10-10 | Johnson | Kansas | 20091 | 12620 | 163 |
613122 | 613122 | 2020-10-09 | Johnson | Kansas | 20091 | 12620 | 163 |
609880 | 609880 | 2020-10-08 | Johnson | Kansas | 20091 | 12329 | 161 |
606637 | 606637 | 2020-10-07 | Johnson | Kansas | 20091 | 12329 | 160 |
603395 | 603395 | 2020-10-06 | Johnson | Kansas | 20091 | 12071 | 158 |
600152 | 600152 | 2020-10-05 | Johnson | Kansas | 20091 | 12071 | 158 |
596910 | 596910 | 2020-10-04 | Johnson | Kansas | 20091 | 11800 | 158 |
593668 | 593668 | 2020-10-03 | Johnson | Kansas | 20091 | 11800 | 158 |
590427 | 590427 | 2020-10-02 | Johnson | Kansas | 20091 | 11800 | 156 |
587186 | 587186 | 2020-10-01 | Johnson | Kansas | 20091 | 11575 | 154 |
583946 | 583946 | 2020-09-30 | Johnson | Kansas | 20091 | 11575 | 154 |
580707 | 580707 | 2020-09-29 | Johnson | Kansas | 20091 | 11348 | 153 |
577466 | 577466 | 2020-09-28 | Johnson | Kansas | 20091 | 11348 | 146 |
574224 | 574224 | 2020-09-27 | Johnson | Kansas | 20091 | 10997 | 146 |
570981 | 570981 | 2020-09-26 | Johnson | Kansas | 20091 | 10997 | 146 |
567739 | 567739 | 2020-09-25 | Johnson | Kansas | 20091 | 10997 | 146 |
564499 | 564499 | 2020-09-24 | Johnson | Kansas | 20091 | 10697 | 146 |
561259 | 561259 | 2020-09-23 | Johnson | Kansas | 20091 | 10697 | 145 |
558023 | 558023 | 2020-09-22 | Johnson | Kansas | 20091 | 10462 | 143 |
554786 | 554786 | 2020-09-21 | Johnson | Kansas | 20091 | 10462 | 141 |
551547 | 551547 | 2020-09-20 | Johnson | Kansas | 20091 | 10178 | 141 |
548308 | 548308 | 2020-09-19 | Johnson | Kansas | 20091 | 10178 | 141 |
545070 | 545070 | 2020-09-18 | Johnson | Kansas | 20091 | 10178 | 141 |
541834 | 541834 | 2020-09-17 | Johnson | Kansas | 20091 | 9917 | 140 |
538597 | 538597 | 2020-09-16 | Johnson | Kansas | 20091 | 9917 | 138 |
535361 | 535361 | 2020-09-15 | Johnson | Kansas | 20091 | 9687 | 138 |
532126 | 532126 | 2020-09-14 | Johnson | Kansas | 20091 | 9687 | 134 |
528889 | 528889 | 2020-09-13 | Johnson | Kansas | 20091 | 9354 | 134 |
525653 | 525653 | 2020-09-12 | Johnson | Kansas | 20091 | 9350 | 134 |
522417 | 522417 | 2020-09-11 | Johnson | Kansas | 20091 | 9350 | 128 |
519180 | 519180 | 2020-09-10 | Johnson | Kansas | 20091 | 9147 | 128 |
515945 | 515945 | 2020-09-09 | Johnson | Kansas | 20091 | 9147 | 126 |
512712 | 512712 | 2020-09-08 | Johnson | Kansas | 20091 | 9047 | 121 |
509479 | 509479 | 2020-09-07 | Johnson | Kansas | 20091 | 9047 | 121 |
506247 | 506247 | 2020-09-06 | Johnson | Kansas | 20091 | 8776 | 121 |
503013 | 503013 | 2020-09-05 | Johnson | Kansas | 20091 | 8695 | 121 |
499779 | 499779 | 2020-09-04 | Johnson | Kansas | 20091 | 8695 | 120 |
496546 | 496546 | 2020-09-03 | Johnson | Kansas | 20091 | 8495 | 118 |
493312 | 493312 | 2020-09-02 | Johnson | Kansas | 20091 | 8495 | 118 |
490079 | 490079 | 2020-09-01 | Johnson | Kansas | 20091 | 8240 | 117 |
486846 | 486846 | 2020-08-31 | Johnson | Kansas | 20091 | 8240 | 116 |
483611 | 483611 | 2020-08-30 | Johnson | Kansas | 20091 | 8050 | 116 |
480377 | 480377 | 2020-08-29 | Johnson | Kansas | 20091 | 7974 | 116 |
477144 | 477144 | 2020-08-28 | Johnson | Kansas | 20091 | 7920 | 116 |
473911 | 473911 | 2020-08-27 | Johnson | Kansas | 20091 | 7682 | 116 |
470679 | 470679 | 2020-08-26 | Johnson | Kansas | 20091 | 7682 | 116 |
467450 | 467450 | 2020-08-25 | Johnson | Kansas | 20091 | 7418 | 112 |
464221 | 464221 | 2020-08-24 | Johnson | Kansas | 20091 | 7418 | 111 |
460992 | 460992 | 2020-08-23 | Johnson | Kansas | 20091 | 7236 | 110 |
457765 | 457765 | 2020-08-22 | Johnson | Kansas | 20091 | 7167 | 110 |
454537 | 454537 | 2020-08-21 | Johnson | Kansas | 20091 | 7058 | 110 |
451309 | 451309 | 2020-08-20 | Johnson | Kansas | 20091 | 6788 | 110 |
448081 | 448081 | 2020-08-19 | Johnson | Kansas | 20091 | 6788 | 108 |
444854 | 444854 | 2020-08-18 | Johnson | Kansas | 20091 | 6615 | 108 |
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);