ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,654 rows where county = "Johnson" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953117 | 953117 | 2021-01-22 | Johnson | Arkansas | 5071 | 2363 | 26 |
953444 | 953444 | 2021-01-22 | Johnson | Georgia | 13167 | 962 | 35 |
953615 | 953615 | 2021-01-22 | Johnson | Illinois | 17087 | 1242 | 15 |
953714 | 953714 | 2021-01-22 | Johnson | Indiana | 18081 | 15030 | 304 |
953817 | 953817 | 2021-01-22 | Johnson | Iowa | 19103 | 12246 | 52 |
953911 | 953911 | 2021-01-22 | Johnson | Kansas | 20091 | 47897 | 543 |
954029 | 954029 | 2021-01-22 | Johnson | Kentucky | 21115 | 1461 | 16 |
954518 | 954518 | 2021-01-22 | Johnson | Missouri | 29101 | 3589 | 34 |
954689 | 954689 | 2021-01-22 | Johnson | Nebraska | 31097 | 607 | 7 |
955542 | 955542 | 2021-01-22 | Johnson | Tennessee | 47091 | 2046 | 34 |
955718 | 955718 | 2021-01-22 | Johnson | Texas | 48251 | 15446 | 224 |
956203 | 956203 | 2021-01-22 | Johnson | Wyoming | 56019 | 609 | 9 |
949872 | 949872 | 2021-01-21 | Johnson | Arkansas | 5071 | 2327 | 26 |
950199 | 950199 | 2021-01-21 | Johnson | Georgia | 13167 | 954 | 34 |
950370 | 950370 | 2021-01-21 | Johnson | Illinois | 17087 | 1224 | 15 |
950469 | 950469 | 2021-01-21 | Johnson | Indiana | 18081 | 14928 | 303 |
950572 | 950572 | 2021-01-21 | Johnson | Iowa | 19103 | 12200 | 51 |
950666 | 950666 | 2021-01-21 | Johnson | Kansas | 20091 | 47051 | 542 |
950784 | 950784 | 2021-01-21 | Johnson | Kentucky | 21115 | 1454 | 16 |
951273 | 951273 | 2021-01-21 | Johnson | Missouri | 29101 | 3578 | 34 |
951444 | 951444 | 2021-01-21 | Johnson | Nebraska | 31097 | 606 | 7 |
952297 | 952297 | 2021-01-21 | Johnson | Tennessee | 47091 | 2035 | 33 |
952473 | 952473 | 2021-01-21 | Johnson | Texas | 48251 | 15235 | 220 |
952958 | 952958 | 2021-01-21 | Johnson | Wyoming | 56019 | 608 | 9 |
946626 | 946626 | 2021-01-20 | Johnson | Arkansas | 5071 | 2305 | 26 |
946953 | 946953 | 2021-01-20 | Johnson | Georgia | 13167 | 948 | 34 |
947124 | 947124 | 2021-01-20 | Johnson | Illinois | 17087 | 1217 | 15 |
947223 | 947223 | 2021-01-20 | Johnson | Indiana | 18081 | 14805 | 300 |
947326 | 947326 | 2021-01-20 | Johnson | Iowa | 19103 | 12160 | 51 |
947420 | 947420 | 2021-01-20 | Johnson | Kansas | 20091 | 47051 | 540 |
947538 | 947538 | 2021-01-20 | Johnson | Kentucky | 21115 | 1446 | 16 |
948027 | 948027 | 2021-01-20 | Johnson | Missouri | 29101 | 3559 | 34 |
948198 | 948198 | 2021-01-20 | Johnson | Nebraska | 31097 | 603 | 7 |
949052 | 949052 | 2021-01-20 | Johnson | Tennessee | 47091 | 2030 | 33 |
949228 | 949228 | 2021-01-20 | Johnson | Texas | 48251 | 15098 | 215 |
949713 | 949713 | 2021-01-20 | Johnson | Wyoming | 56019 | 604 | 9 |
943379 | 943379 | 2021-01-19 | Johnson | Arkansas | 5071 | 2297 | 26 |
943706 | 943706 | 2021-01-19 | Johnson | Georgia | 13167 | 946 | 34 |
943877 | 943877 | 2021-01-19 | Johnson | Illinois | 17087 | 1211 | 15 |
943976 | 943976 | 2021-01-19 | Johnson | Indiana | 18081 | 14744 | 300 |
944079 | 944079 | 2021-01-19 | Johnson | Iowa | 19103 | 12118 | 49 |
944173 | 944173 | 2021-01-19 | Johnson | Kansas | 20091 | 46009 | 532 |
944291 | 944291 | 2021-01-19 | Johnson | Kentucky | 21115 | 1437 | 16 |
944780 | 944780 | 2021-01-19 | Johnson | Missouri | 29101 | 3552 | 34 |
944951 | 944951 | 2021-01-19 | Johnson | Nebraska | 31097 | 593 | 7 |
945806 | 945806 | 2021-01-19 | Johnson | Tennessee | 47091 | 2022 | 32 |
945982 | 945982 | 2021-01-19 | Johnson | Texas | 48251 | 14435 | 213 |
946467 | 946467 | 2021-01-19 | Johnson | Wyoming | 56019 | 600 | 9 |
940134 | 940134 | 2021-01-18 | Johnson | Arkansas | 5071 | 2294 | 26 |
940461 | 940461 | 2021-01-18 | Johnson | Georgia | 13167 | 942 | 34 |
940632 | 940632 | 2021-01-18 | Johnson | Illinois | 17087 | 1210 | 15 |
940731 | 940731 | 2021-01-18 | Johnson | Indiana | 18081 | 14640 | 296 |
940834 | 940834 | 2021-01-18 | Johnson | Iowa | 19103 | 12076 | 49 |
940928 | 940928 | 2021-01-18 | Johnson | Kansas | 20091 | 46009 | 533 |
941046 | 941046 | 2021-01-18 | Johnson | Kentucky | 21115 | 1423 | 16 |
941535 | 941535 | 2021-01-18 | Johnson | Missouri | 29101 | 3530 | 34 |
941706 | 941706 | 2021-01-18 | Johnson | Nebraska | 31097 | 593 | 7 |
942559 | 942559 | 2021-01-18 | Johnson | Tennessee | 47091 | 2018 | 32 |
942735 | 942735 | 2021-01-18 | Johnson | Texas | 48251 | 14435 | 210 |
943220 | 943220 | 2021-01-18 | Johnson | Wyoming | 56019 | 593 | 9 |
936889 | 936889 | 2021-01-17 | Johnson | Arkansas | 5071 | 2287 | 26 |
937216 | 937216 | 2021-01-17 | Johnson | Georgia | 13167 | 942 | 34 |
937387 | 937387 | 2021-01-17 | Johnson | Illinois | 17087 | 1211 | 15 |
937486 | 937486 | 2021-01-17 | Johnson | Indiana | 18081 | 14553 | 295 |
937589 | 937589 | 2021-01-17 | Johnson | Iowa | 19103 | 12047 | 49 |
937683 | 937683 | 2021-01-17 | Johnson | Kansas | 20091 | 44973 | 533 |
937801 | 937801 | 2021-01-17 | Johnson | Kentucky | 21115 | 1420 | 16 |
938290 | 938290 | 2021-01-17 | Johnson | Missouri | 29101 | 3527 | 34 |
938461 | 938461 | 2021-01-17 | Johnson | Nebraska | 31097 | 595 | 7 |
939314 | 939314 | 2021-01-17 | Johnson | Tennessee | 47091 | 2015 | 32 |
939490 | 939490 | 2021-01-17 | Johnson | Texas | 48251 | 14435 | 207 |
939975 | 939975 | 2021-01-17 | Johnson | Wyoming | 56019 | 587 | 9 |
933644 | 933644 | 2021-01-16 | Johnson | Arkansas | 5071 | 2282 | 26 |
933971 | 933971 | 2021-01-16 | Johnson | Georgia | 13167 | 941 | 34 |
934142 | 934142 | 2021-01-16 | Johnson | Illinois | 17087 | 1210 | 15 |
934241 | 934241 | 2021-01-16 | Johnson | Indiana | 18081 | 14455 | 295 |
934344 | 934344 | 2021-01-16 | Johnson | Iowa | 19103 | 12022 | 49 |
934438 | 934438 | 2021-01-16 | Johnson | Kansas | 20091 | 44973 | 533 |
934556 | 934556 | 2021-01-16 | Johnson | Kentucky | 21115 | 1407 | 16 |
935045 | 935045 | 2021-01-16 | Johnson | Missouri | 29101 | 3515 | 34 |
935216 | 935216 | 2021-01-16 | Johnson | Nebraska | 31097 | 594 | 7 |
936069 | 936069 | 2021-01-16 | Johnson | Tennessee | 47091 | 2012 | 32 |
936245 | 936245 | 2021-01-16 | Johnson | Texas | 48251 | 14435 | 205 |
936730 | 936730 | 2021-01-16 | Johnson | Wyoming | 56019 | 582 | 9 |
930399 | 930399 | 2021-01-15 | Johnson | Arkansas | 5071 | 2258 | 26 |
930726 | 930726 | 2021-01-15 | Johnson | Georgia | 13167 | 937 | 34 |
930897 | 930897 | 2021-01-15 | Johnson | Illinois | 17087 | 1208 | 15 |
930996 | 930996 | 2021-01-15 | Johnson | Indiana | 18081 | 14330 | 291 |
931099 | 931099 | 2021-01-15 | Johnson | Iowa | 19103 | 11987 | 49 |
931193 | 931193 | 2021-01-15 | Johnson | Kansas | 20091 | 44973 | 530 |
931311 | 931311 | 2021-01-15 | Johnson | Kentucky | 21115 | 1396 | 16 |
931800 | 931800 | 2021-01-15 | Johnson | Missouri | 29101 | 3509 | 34 |
931971 | 931971 | 2021-01-15 | Johnson | Nebraska | 31097 | 594 | 7 |
932824 | 932824 | 2021-01-15 | Johnson | Tennessee | 47091 | 2005 | 31 |
933000 | 933000 | 2021-01-15 | Johnson | Texas | 48251 | 14259 | 203 |
933485 | 933485 | 2021-01-15 | Johnson | Wyoming | 56019 | 580 | 9 |
927154 | 927154 | 2021-01-14 | Johnson | Arkansas | 5071 | 2237 | 26 |
927481 | 927481 | 2021-01-14 | Johnson | Georgia | 13167 | 908 | 34 |
927652 | 927652 | 2021-01-14 | Johnson | Illinois | 17087 | 1200 | 15 |
927751 | 927751 | 2021-01-14 | Johnson | Indiana | 18081 | 14177 | 288 |
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]);