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 |
---|---|---|---|---|---|---|---|
927868 | 927868 | 2021-01-14 | Johnson | Kansas | 20091 | 44346 | 524 |
924622 | 924622 | 2021-01-13 | Johnson | Kansas | 20091 | 44346 | 519 |
921377 | 921377 | 2021-01-12 | Johnson | Kansas | 20091 | 43450 | 509 |
918132 | 918132 | 2021-01-11 | Johnson | Kansas | 20091 | 43450 | 502 |
914887 | 914887 | 2021-01-10 | Johnson | Kansas | 20091 | 42456 | 501 |
911642 | 911642 | 2021-01-09 | Johnson | Kansas | 20091 | 42456 | 499 |
908397 | 908397 | 2021-01-08 | Johnson | Kansas | 20091 | 42456 | 492 |
905151 | 905151 | 2021-01-07 | Johnson | Kansas | 20091 | 41357 | 487 |
901906 | 901906 | 2021-01-06 | Johnson | Kansas | 20091 | 41357 | 478 |
898661 | 898661 | 2021-01-05 | Johnson | Kansas | 20091 | 40379 | 469 |
895416 | 895416 | 2021-01-04 | Johnson | Kansas | 20091 | 40379 | 456 |
892169 | 892169 | 2021-01-03 | Johnson | Kansas | 20091 | 39696 | 455 |
888923 | 888923 | 2021-01-02 | Johnson | Kansas | 20091 | 39696 | 455 |
885677 | 885677 | 2021-01-01 | Johnson | Kansas | 20091 | 39696 | 454 |
882432 | 882432 | 2020-12-31 | Johnson | Kansas | 20091 | 38865 | 452 |
879187 | 879187 | 2020-12-30 | Johnson | Kansas | 20091 | 38865 | 447 |
875942 | 875942 | 2020-12-29 | Johnson | Kansas | 20091 | 37875 | 435 |
872697 | 872697 | 2020-12-28 | Johnson | Kansas | 20091 | 37875 | 418 |
869452 | 869452 | 2020-12-27 | Johnson | Kansas | 20091 | 36727 | 413 |
866207 | 866207 | 2020-12-26 | Johnson | Kansas | 20091 | 36727 | 413 |
862962 | 862962 | 2020-12-25 | Johnson | Kansas | 20091 | 36727 | 413 |
859717 | 859717 | 2020-12-24 | Johnson | Kansas | 20091 | 36727 | 413 |
856472 | 856472 | 2020-12-23 | Johnson | Kansas | 20091 | 36727 | 410 |
853227 | 853227 | 2020-12-22 | Johnson | Kansas | 20091 | 35973 | 401 |
849982 | 849982 | 2020-12-21 | Johnson | Kansas | 20091 | 35973 | 390 |
846737 | 846737 | 2020-12-20 | Johnson | Kansas | 20091 | 35086 | 385 |
843491 | 843491 | 2020-12-19 | Johnson | Kansas | 20091 | 35086 | 385 |
840246 | 840246 | 2020-12-18 | Johnson | Kansas | 20091 | 35086 | 383 |
837001 | 837001 | 2020-12-17 | Johnson | Kansas | 20091 | 33964 | 381 |
833755 | 833755 | 2020-12-16 | Johnson | Kansas | 20091 | 33964 | 371 |
830508 | 830508 | 2020-12-15 | Johnson | Kansas | 20091 | 33144 | 357 |
827262 | 827262 | 2020-12-14 | Johnson | Kansas | 20091 | 33144 | 346 |
824015 | 824015 | 2020-12-13 | Johnson | Kansas | 20091 | 32163 | 339 |
820769 | 820769 | 2020-12-12 | Johnson | Kansas | 20091 | 32163 | 339 |
817523 | 817523 | 2020-12-11 | Johnson | Kansas | 20091 | 32163 | 338 |
814277 | 814277 | 2020-12-10 | Johnson | Kansas | 20091 | 31155 | 327 |
811032 | 811032 | 2020-12-09 | Johnson | Kansas | 20091 | 31155 | 321 |
807787 | 807787 | 2020-12-08 | Johnson | Kansas | 20091 | 30199 | 312 |
804542 | 804542 | 2020-12-07 | Johnson | Kansas | 20091 | 30199 | 309 |
801297 | 801297 | 2020-12-06 | Johnson | Kansas | 20091 | 29272 | 309 |
798052 | 798052 | 2020-12-05 | Johnson | Kansas | 20091 | 29272 | 304 |
794807 | 794807 | 2020-12-04 | Johnson | Kansas | 20091 | 29272 | 299 |
791562 | 791562 | 2020-12-03 | Johnson | Kansas | 20091 | 28078 | 294 |
788317 | 788317 | 2020-12-02 | Johnson | Kansas | 20091 | 28078 | 293 |
785073 | 785073 | 2020-12-01 | Johnson | Kansas | 20091 | 27420 | 289 |
781828 | 781828 | 2020-11-30 | Johnson | Kansas | 20091 | 27420 | 285 |
778582 | 778582 | 2020-11-29 | Johnson | Kansas | 20091 | 26731 | 285 |
775337 | 775337 | 2020-11-28 | Johnson | Kansas | 20091 | 26731 | 285 |
772092 | 772092 | 2020-11-27 | Johnson | Kansas | 20091 | 26731 | 285 |
768847 | 768847 | 2020-11-26 | Johnson | Kansas | 20091 | 25931 | 285 |
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 |
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);