ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,654 rows where county = "Johnson" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Johnson · 3,654 ✖
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);