ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,366 rows where county = "Johnson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
609880 | 609880 | 2020-10-08 | Johnson | Kansas | 20091 | 12329 | 161 |
609997 | 609997 | 2020-10-08 | Johnson | Kentucky | 21115 | 180 | 2 |
610486 | 610486 | 2020-10-08 | Johnson | Missouri | 29101 | 1044 | 5 |
610657 | 610657 | 2020-10-08 | Johnson | Nebraska | 31097 | 74 | 0 |
611509 | 611509 | 2020-10-08 | Johnson | Tennessee | 47091 | 1009 | 4 |
611685 | 611685 | 2020-10-08 | Johnson | Texas | 48251 | 3256 | 55 |
612170 | 612170 | 2020-10-08 | Johnson | Wyoming | 56019 | 46 | 1 |
605843 | 605843 | 2020-10-07 | Johnson | Arkansas | 5071 | 891 | 7 |
606170 | 606170 | 2020-10-07 | Johnson | Georgia | 13167 | 458 | 22 |
606340 | 606340 | 2020-10-07 | Johnson | Illinois | 17087 | 199 | 0 |
606440 | 606440 | 2020-10-07 | Johnson | Indiana | 18081 | 2571 | 134 |
606543 | 606543 | 2020-10-07 | Johnson | Iowa | 19103 | 5345 | 28 |
606637 | 606637 | 2020-10-07 | Johnson | Kansas | 20091 | 12329 | 160 |
606755 | 606755 | 2020-10-07 | Johnson | Kentucky | 21115 | 178 | 2 |
607244 | 607244 | 2020-10-07 | Johnson | Missouri | 29101 | 1027 | 5 |
607415 | 607415 | 2020-10-07 | Johnson | Nebraska | 31097 | 73 | 0 |
608267 | 608267 | 2020-10-07 | Johnson | Tennessee | 47091 | 1009 | 3 |
608443 | 608443 | 2020-10-07 | Johnson | Texas | 48251 | 3234 | 53 |
608928 | 608928 | 2020-10-07 | Johnson | Wyoming | 56019 | 46 | 1 |
602601 | 602601 | 2020-10-06 | Johnson | Arkansas | 5071 | 889 | 7 |
602928 | 602928 | 2020-10-06 | Johnson | Georgia | 13167 | 457 | 22 |
603098 | 603098 | 2020-10-06 | Johnson | Illinois | 17087 | 194 | 0 |
603198 | 603198 | 2020-10-06 | Johnson | Indiana | 18081 | 2555 | 134 |
603301 | 603301 | 2020-10-06 | Johnson | Iowa | 19103 | 5307 | 28 |
603395 | 603395 | 2020-10-06 | Johnson | Kansas | 20091 | 12071 | 158 |
603513 | 603513 | 2020-10-06 | Johnson | Kentucky | 21115 | 176 | 2 |
604001 | 604001 | 2020-10-06 | Johnson | Missouri | 29101 | 1018 | 5 |
604172 | 604172 | 2020-10-06 | Johnson | Nebraska | 31097 | 72 | 0 |
605024 | 605024 | 2020-10-06 | Johnson | Tennessee | 47091 | 846 | 3 |
605200 | 605200 | 2020-10-06 | Johnson | Texas | 48251 | 3196 | 53 |
605685 | 605685 | 2020-10-06 | Johnson | Wyoming | 56019 | 44 | 1 |
599358 | 599358 | 2020-10-05 | Johnson | Arkansas | 5071 | 885 | 7 |
599685 | 599685 | 2020-10-05 | Johnson | Georgia | 13167 | 457 | 22 |
599855 | 599855 | 2020-10-05 | Johnson | Illinois | 17087 | 188 | 0 |
599955 | 599955 | 2020-10-05 | Johnson | Indiana | 18081 | 2526 | 133 |
600058 | 600058 | 2020-10-05 | Johnson | Iowa | 19103 | 5286 | 28 |
600152 | 600152 | 2020-10-05 | Johnson | Kansas | 20091 | 12071 | 158 |
600270 | 600270 | 2020-10-05 | Johnson | Kentucky | 21115 | 165 | 2 |
600759 | 600759 | 2020-10-05 | Johnson | Missouri | 29101 | 1017 | 5 |
600930 | 600930 | 2020-10-05 | Johnson | Nebraska | 31097 | 72 | 0 |
601782 | 601782 | 2020-10-05 | Johnson | Tennessee | 47091 | 783 | 3 |
601958 | 601958 | 2020-10-05 | Johnson | Texas | 48251 | 3169 | 53 |
602443 | 602443 | 2020-10-05 | Johnson | Wyoming | 56019 | 44 | 1 |
596115 | 596115 | 2020-10-04 | Johnson | Arkansas | 5071 | 883 | 7 |
596442 | 596442 | 2020-10-04 | Johnson | Georgia | 13167 | 420 | 22 |
596613 | 596613 | 2020-10-04 | Johnson | Illinois | 17087 | 185 | 0 |
596713 | 596713 | 2020-10-04 | Johnson | Indiana | 18081 | 2511 | 133 |
596816 | 596816 | 2020-10-04 | Johnson | Iowa | 19103 | 5264 | 28 |
596910 | 596910 | 2020-10-04 | Johnson | Kansas | 20091 | 11800 | 158 |
597028 | 597028 | 2020-10-04 | Johnson | Kentucky | 21115 | 163 | 2 |
597516 | 597516 | 2020-10-04 | Johnson | Missouri | 29101 | 1017 | 5 |
597686 | 597686 | 2020-10-04 | Johnson | Nebraska | 31097 | 72 | 0 |
598539 | 598539 | 2020-10-04 | Johnson | Tennessee | 47091 | 771 | 3 |
598715 | 598715 | 2020-10-04 | Johnson | Texas | 48251 | 3169 | 53 |
599200 | 599200 | 2020-10-04 | Johnson | Wyoming | 56019 | 44 | 1 |
592873 | 592873 | 2020-10-03 | Johnson | Arkansas | 5071 | 876 | 7 |
593200 | 593200 | 2020-10-03 | Johnson | Georgia | 13167 | 419 | 22 |
593371 | 593371 | 2020-10-03 | Johnson | Illinois | 17087 | 181 | 0 |
593471 | 593471 | 2020-10-03 | Johnson | Indiana | 18081 | 2490 | 133 |
593574 | 593574 | 2020-10-03 | Johnson | Iowa | 19103 | 5258 | 28 |
593668 | 593668 | 2020-10-03 | Johnson | Kansas | 20091 | 11800 | 158 |
593786 | 593786 | 2020-10-03 | Johnson | Kentucky | 21115 | 163 | 2 |
594275 | 594275 | 2020-10-03 | Johnson | Missouri | 29101 | 1008 | 5 |
594444 | 594444 | 2020-10-03 | Johnson | Nebraska | 31097 | 70 | 0 |
595296 | 595296 | 2020-10-03 | Johnson | Tennessee | 47091 | 765 | 3 |
595472 | 595472 | 2020-10-03 | Johnson | Texas | 48251 | 3169 | 53 |
595957 | 595957 | 2020-10-03 | Johnson | Wyoming | 56019 | 44 | 1 |
589633 | 589633 | 2020-10-02 | Johnson | Arkansas | 5071 | 874 | 7 |
589960 | 589960 | 2020-10-02 | Johnson | Georgia | 13167 | 418 | 22 |
590130 | 590130 | 2020-10-02 | Johnson | Illinois | 17087 | 172 | 0 |
590230 | 590230 | 2020-10-02 | Johnson | Indiana | 18081 | 2480 | 133 |
590333 | 590333 | 2020-10-02 | Johnson | Iowa | 19103 | 5243 | 28 |
590427 | 590427 | 2020-10-02 | Johnson | Kansas | 20091 | 11800 | 156 |
590545 | 590545 | 2020-10-02 | Johnson | Kentucky | 21115 | 162 | 2 |
591034 | 591034 | 2020-10-02 | Johnson | Missouri | 29101 | 988 | 5 |
591203 | 591203 | 2020-10-02 | Johnson | Nebraska | 31097 | 70 | 0 |
592055 | 592055 | 2020-10-02 | Johnson | Tennessee | 47091 | 764 | 3 |
592230 | 592230 | 2020-10-02 | Johnson | Texas | 48251 | 3141 | 53 |
592715 | 592715 | 2020-10-02 | Johnson | Wyoming | 56019 | 42 | 1 |
586392 | 586392 | 2020-10-01 | Johnson | Arkansas | 5071 | 866 | 7 |
586719 | 586719 | 2020-10-01 | Johnson | Georgia | 13167 | 416 | 22 |
586889 | 586889 | 2020-10-01 | Johnson | Illinois | 17087 | 168 | 0 |
586989 | 586989 | 2020-10-01 | Johnson | Indiana | 18081 | 2448 | 135 |
587092 | 587092 | 2020-10-01 | Johnson | Iowa | 19103 | 5220 | 27 |
587186 | 587186 | 2020-10-01 | Johnson | Kansas | 20091 | 11575 | 154 |
587304 | 587304 | 2020-10-01 | Johnson | Kentucky | 21115 | 162 | 2 |
587793 | 587793 | 2020-10-01 | Johnson | Missouri | 29101 | 978 | 5 |
587962 | 587962 | 2020-10-01 | Johnson | Nebraska | 31097 | 65 | 0 |
588814 | 588814 | 2020-10-01 | Johnson | Tennessee | 47091 | 757 | 3 |
588990 | 588990 | 2020-10-01 | Johnson | Texas | 48251 | 3130 | 52 |
589475 | 589475 | 2020-10-01 | Johnson | Wyoming | 56019 | 42 | 1 |
583152 | 583152 | 2020-09-30 | Johnson | Arkansas | 5071 | 859 | 7 |
583479 | 583479 | 2020-09-30 | Johnson | Georgia | 13167 | 415 | 22 |
583649 | 583649 | 2020-09-30 | Johnson | Illinois | 17087 | 163 | 0 |
583749 | 583749 | 2020-09-30 | Johnson | Indiana | 18081 | 2422 | 135 |
583852 | 583852 | 2020-09-30 | Johnson | Iowa | 19103 | 5203 | 27 |
583946 | 583946 | 2020-09-30 | Johnson | Kansas | 20091 | 11575 | 154 |
584064 | 584064 | 2020-09-30 | Johnson | Kentucky | 21115 | 161 | 2 |
584553 | 584553 | 2020-09-30 | Johnson | Missouri | 29101 | 974 | 5 |
584722 | 584722 | 2020-09-30 | Johnson | Nebraska | 31097 | 65 | 0 |
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);