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 |
---|---|---|---|---|---|---|---|
920910 | 920910 | 2021-01-12 | Johnson | Georgia | 13167 | 893 | 34 |
921081 | 921081 | 2021-01-12 | Johnson | Illinois | 17087 | 1182 | 15 |
921180 | 921180 | 2021-01-12 | Johnson | Indiana | 18081 | 13969 | 285 |
921283 | 921283 | 2021-01-12 | Johnson | Iowa | 19103 | 11786 | 49 |
921377 | 921377 | 2021-01-12 | Johnson | Kansas | 20091 | 43450 | 509 |
921495 | 921495 | 2021-01-12 | Johnson | Kentucky | 21115 | 1351 | 16 |
921984 | 921984 | 2021-01-12 | Johnson | Missouri | 29101 | 3461 | 34 |
922155 | 922155 | 2021-01-12 | Johnson | Nebraska | 31097 | 583 | 6 |
923008 | 923008 | 2021-01-12 | Johnson | Tennessee | 47091 | 1928 | 30 |
923184 | 923184 | 2021-01-12 | Johnson | Texas | 48251 | 13401 | 187 |
923669 | 923669 | 2021-01-12 | Johnson | Wyoming | 56019 | 564 | 9 |
917338 | 917338 | 2021-01-11 | Johnson | Arkansas | 5071 | 2167 | 21 |
917665 | 917665 | 2021-01-11 | Johnson | Georgia | 13167 | 874 | 34 |
917836 | 917836 | 2021-01-11 | Johnson | Illinois | 17087 | 1170 | 15 |
917935 | 917935 | 2021-01-11 | Johnson | Indiana | 18081 | 13892 | 281 |
918038 | 918038 | 2021-01-11 | Johnson | Iowa | 19103 | 11743 | 49 |
918132 | 918132 | 2021-01-11 | Johnson | Kansas | 20091 | 43450 | 502 |
918250 | 918250 | 2021-01-11 | Johnson | Kentucky | 21115 | 1325 | 16 |
918739 | 918739 | 2021-01-11 | Johnson | Missouri | 29101 | 3443 | 34 |
918910 | 918910 | 2021-01-11 | Johnson | Nebraska | 31097 | 581 | 6 |
919763 | 919763 | 2021-01-11 | Johnson | Tennessee | 47091 | 1921 | 30 |
919939 | 919939 | 2021-01-11 | Johnson | Texas | 48251 | 12912 | 184 |
920424 | 920424 | 2021-01-11 | Johnson | Wyoming | 56019 | 559 | 8 |
914093 | 914093 | 2021-01-10 | Johnson | Arkansas | 5071 | 2155 | 21 |
914420 | 914420 | 2021-01-10 | Johnson | Georgia | 13167 | 869 | 34 |
914591 | 914591 | 2021-01-10 | Johnson | Illinois | 17087 | 1166 | 15 |
914690 | 914690 | 2021-01-10 | Johnson | Indiana | 18081 | 13775 | 280 |
914793 | 914793 | 2021-01-10 | Johnson | Iowa | 19103 | 11684 | 49 |
914887 | 914887 | 2021-01-10 | Johnson | Kansas | 20091 | 42456 | 501 |
915005 | 915005 | 2021-01-10 | Johnson | Kentucky | 21115 | 1317 | 16 |
915494 | 915494 | 2021-01-10 | Johnson | Missouri | 29101 | 3439 | 34 |
915665 | 915665 | 2021-01-10 | Johnson | Nebraska | 31097 | 578 | 5 |
916518 | 916518 | 2021-01-10 | Johnson | Tennessee | 47091 | 1915 | 30 |
916694 | 916694 | 2021-01-10 | Johnson | Texas | 48251 | 12912 | 184 |
917179 | 917179 | 2021-01-10 | Johnson | Wyoming | 56019 | 544 | 8 |
910848 | 910848 | 2021-01-09 | Johnson | Arkansas | 5071 | 2128 | 21 |
911175 | 911175 | 2021-01-09 | Johnson | Georgia | 13167 | 863 | 34 |
911346 | 911346 | 2021-01-09 | Johnson | Illinois | 17087 | 1154 | 15 |
911445 | 911445 | 2021-01-09 | Johnson | Indiana | 18081 | 13650 | 279 |
911548 | 911548 | 2021-01-09 | Johnson | Iowa | 19103 | 11661 | 49 |
911642 | 911642 | 2021-01-09 | Johnson | Kansas | 20091 | 42456 | 499 |
911760 | 911760 | 2021-01-09 | Johnson | Kentucky | 21115 | 1298 | 16 |
912249 | 912249 | 2021-01-09 | Johnson | Missouri | 29101 | 3405 | 34 |
912420 | 912420 | 2021-01-09 | Johnson | Nebraska | 31097 | 576 | 5 |
913273 | 913273 | 2021-01-09 | Johnson | Tennessee | 47091 | 1905 | 29 |
913449 | 913449 | 2021-01-09 | Johnson | Texas | 48251 | 12912 | 183 |
913934 | 913934 | 2021-01-09 | Johnson | Wyoming | 56019 | 541 | 8 |
907603 | 907603 | 2021-01-08 | Johnson | Arkansas | 5071 | 2079 | 21 |
907930 | 907930 | 2021-01-08 | Johnson | Georgia | 13167 | 855 | 34 |
908101 | 908101 | 2021-01-08 | Johnson | Illinois | 17087 | 1145 | 15 |
908200 | 908200 | 2021-01-08 | Johnson | Indiana | 18081 | 13422 | 272 |
908303 | 908303 | 2021-01-08 | Johnson | Iowa | 19103 | 11590 | 49 |
908397 | 908397 | 2021-01-08 | Johnson | Kansas | 20091 | 42456 | 492 |
908515 | 908515 | 2021-01-08 | Johnson | Kentucky | 21115 | 1277 | 16 |
909004 | 909004 | 2021-01-08 | Johnson | Missouri | 29101 | 3381 | 34 |
909175 | 909175 | 2021-01-08 | Johnson | Nebraska | 31097 | 565 | 5 |
910028 | 910028 | 2021-01-08 | Johnson | Tennessee | 47091 | 1899 | 29 |
910204 | 910204 | 2021-01-08 | Johnson | Texas | 48251 | 12549 | 179 |
910689 | 910689 | 2021-01-08 | Johnson | Wyoming | 56019 | 541 | 8 |
904357 | 904357 | 2021-01-07 | Johnson | Arkansas | 5071 | 2048 | 20 |
904684 | 904684 | 2021-01-07 | Johnson | Georgia | 13167 | 830 | 34 |
904855 | 904855 | 2021-01-07 | Johnson | Illinois | 17087 | 1112 | 15 |
904954 | 904954 | 2021-01-07 | Johnson | Indiana | 18081 | 13230 | 266 |
905057 | 905057 | 2021-01-07 | Johnson | Iowa | 19103 | 11531 | 47 |
905151 | 905151 | 2021-01-07 | Johnson | Kansas | 20091 | 41357 | 487 |
905269 | 905269 | 2021-01-07 | Johnson | Kentucky | 21115 | 1262 | 16 |
905758 | 905758 | 2021-01-07 | Johnson | Missouri | 29101 | 3338 | 34 |
905929 | 905929 | 2021-01-07 | Johnson | Nebraska | 31097 | 563 | 5 |
906783 | 906783 | 2021-01-07 | Johnson | Tennessee | 47091 | 1871 | 29 |
906959 | 906959 | 2021-01-07 | Johnson | Texas | 48251 | 12350 | 174 |
907444 | 907444 | 2021-01-07 | Johnson | Wyoming | 56019 | 535 | 8 |
901112 | 901112 | 2021-01-06 | Johnson | Arkansas | 5071 | 2024 | 20 |
901439 | 901439 | 2021-01-06 | Johnson | Georgia | 13167 | 807 | 34 |
901610 | 901610 | 2021-01-06 | Johnson | Illinois | 17087 | 1096 | 15 |
901709 | 901709 | 2021-01-06 | Johnson | Indiana | 18081 | 12973 | 265 |
901812 | 901812 | 2021-01-06 | Johnson | Iowa | 19103 | 11472 | 47 |
901906 | 901906 | 2021-01-06 | Johnson | Kansas | 20091 | 41357 | 478 |
902024 | 902024 | 2021-01-06 | Johnson | Kentucky | 21115 | 1224 | 16 |
902513 | 902513 | 2021-01-06 | Johnson | Missouri | 29101 | 3316 | 34 |
902684 | 902684 | 2021-01-06 | Johnson | Nebraska | 31097 | 557 | 5 |
903537 | 903537 | 2021-01-06 | Johnson | Tennessee | 47091 | 1853 | 28 |
903713 | 903713 | 2021-01-06 | Johnson | Texas | 48251 | 12165 | 170 |
904198 | 904198 | 2021-01-06 | Johnson | Wyoming | 56019 | 533 | 7 |
897867 | 897867 | 2021-01-05 | Johnson | Arkansas | 5071 | 1978 | 20 |
898194 | 898194 | 2021-01-05 | Johnson | Georgia | 13167 | 785 | 34 |
898365 | 898365 | 2021-01-05 | Johnson | Illinois | 17087 | 1079 | 15 |
898464 | 898464 | 2021-01-05 | Johnson | Indiana | 18081 | 12770 | 262 |
898567 | 898567 | 2021-01-05 | Johnson | Iowa | 19103 | 11397 | 47 |
898661 | 898661 | 2021-01-05 | Johnson | Kansas | 20091 | 40379 | 469 |
898779 | 898779 | 2021-01-05 | Johnson | Kentucky | 21115 | 1192 | 16 |
899268 | 899268 | 2021-01-05 | Johnson | Missouri | 29101 | 3297 | 34 |
899439 | 899439 | 2021-01-05 | Johnson | Nebraska | 31097 | 548 | 5 |
900292 | 900292 | 2021-01-05 | Johnson | Tennessee | 47091 | 1842 | 28 |
900468 | 900468 | 2021-01-05 | Johnson | Texas | 48251 | 11726 | 165 |
900953 | 900953 | 2021-01-05 | Johnson | Wyoming | 56019 | 530 | 7 |
894622 | 894622 | 2021-01-04 | Johnson | Arkansas | 5071 | 1938 | 20 |
894949 | 894949 | 2021-01-04 | Johnson | Georgia | 13167 | 769 | 34 |
895120 | 895120 | 2021-01-04 | Johnson | Illinois | 17087 | 1032 | 15 |
895219 | 895219 | 2021-01-04 | Johnson | Indiana | 18081 | 12730 | 257 |
895322 | 895322 | 2021-01-04 | Johnson | Iowa | 19103 | 11339 | 47 |
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);