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 |
---|---|---|---|---|---|---|---|
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 |
441628 | 441628 | 2020-08-17 | Johnson | Kansas | 20091 | 6615 | 108 |
438401 | 438401 | 2020-08-16 | Johnson | Kansas | 20091 | 6430 | 108 |
435176 | 435176 | 2020-08-15 | Johnson | Kansas | 20091 | 6383 | 108 |
431951 | 431951 | 2020-08-14 | Johnson | Kansas | 20091 | 6357 | 106 |
428723 | 428723 | 2020-08-13 | Johnson | Kansas | 20091 | 6127 | 106 |
425499 | 425499 | 2020-08-12 | Johnson | Kansas | 20091 | 6120 | 106 |
422278 | 422278 | 2020-08-11 | Johnson | Kansas | 20091 | 5913 | 105 |
419055 | 419055 | 2020-08-10 | Johnson | Kansas | 20091 | 5913 | 103 |
415834 | 415834 | 2020-08-09 | Johnson | Kansas | 20091 | 5703 | 103 |
412614 | 412614 | 2020-08-08 | Johnson | Kansas | 20091 | 5643 | 103 |
409394 | 409394 | 2020-08-07 | Johnson | Kansas | 20091 | 5637 | 102 |
406175 | 406175 | 2020-08-06 | Johnson | Kansas | 20091 | 5439 | 102 |
402957 | 402957 | 2020-08-05 | Johnson | Kansas | 20091 | 5434 | 98 |
399740 | 399740 | 2020-08-04 | Johnson | Kansas | 20091 | 5252 | 98 |
396525 | 396525 | 2020-08-03 | Johnson | Kansas | 20091 | 5252 | 98 |
393309 | 393309 | 2020-08-02 | Johnson | Kansas | 20091 | 5074 | 98 |
390092 | 390092 | 2020-08-01 | Johnson | Kansas | 20091 | 5014 | 98 |
386875 | 386875 | 2020-07-31 | Johnson | Kansas | 20091 | 4995 | 98 |
383657 | 383657 | 2020-07-30 | Johnson | Kansas | 20091 | 4813 | 98 |
380440 | 380440 | 2020-07-29 | Johnson | Kansas | 20091 | 4813 | 96 |
377223 | 377223 | 2020-07-28 | Johnson | Kansas | 20091 | 4643 | 96 |
374008 | 374008 | 2020-07-27 | Johnson | Kansas | 20091 | 4643 | 94 |
370796 | 370796 | 2020-07-26 | Johnson | Kansas | 20091 | 4455 | 94 |
367586 | 367586 | 2020-07-25 | Johnson | Kansas | 20091 | 4387 | 94 |
364379 | 364379 | 2020-07-24 | Johnson | Kansas | 20091 | 4381 | 92 |
361172 | 361172 | 2020-07-23 | Johnson | Kansas | 20091 | 4161 | 96 |
357967 | 357967 | 2020-07-22 | Johnson | Kansas | 20091 | 4158 | 96 |
354765 | 354765 | 2020-07-21 | Johnson | Kansas | 20091 | 3933 | 95 |
351563 | 351563 | 2020-07-20 | Johnson | Kansas | 20091 | 3933 | 96 |
348363 | 348363 | 2020-07-19 | Johnson | Kansas | 20091 | 3744 | 96 |
345162 | 345162 | 2020-07-18 | Johnson | Kansas | 20091 | 3667 | 96 |
341962 | 341962 | 2020-07-17 | Johnson | Kansas | 20091 | 3654 | 95 |
338766 | 338766 | 2020-07-16 | Johnson | Kansas | 20091 | 3422 | 95 |
335570 | 335570 | 2020-07-15 | Johnson | Kansas | 20091 | 3370 | 94 |
332377 | 332377 | 2020-07-14 | Johnson | Kansas | 20091 | 3160 | 93 |
329190 | 329190 | 2020-07-13 | Johnson | Kansas | 20091 | 3160 | 93 |
326004 | 326004 | 2020-07-12 | Johnson | Kansas | 20091 | 2967 | 93 |
322821 | 322821 | 2020-07-11 | Johnson | Kansas | 20091 | 2857 | 92 |
319642 | 319642 | 2020-07-10 | Johnson | Kansas | 20091 | 2804 | 92 |
316469 | 316469 | 2020-07-09 | Johnson | Kansas | 20091 | 2633 | 92 |
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);