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

4,170 rows where county = "Johnson" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Johnson · 4,170 ✖
Link rowid date ▲ county state fips cases deaths
1092598 1092598 2021-03-06 Johnson Arkansas 5071 2798 31
1092925 1092925 2021-03-06 Johnson Georgia 13167 1088 47
1093096 1093096 2021-03-06 Johnson Illinois 17087 1353 18
1093196 1093196 2021-03-06 Johnson Indiana 18081 16528 379
1093299 1093299 2021-03-06 Johnson Iowa 19103 12906 75
1093393 1093393 2021-03-06 Johnson Kansas 20091 54730 640
1093511 1093511 2021-03-06 Johnson Kentucky 21115 1823 18
1093999 1093999 2021-03-06 Johnson Missouri 29101 3885 45
1094170 1094170 2021-03-06 Johnson Nebraska 31097 629 8
1095024 1095024 2021-03-06 Johnson Tennessee 47091 2175 38
1095200 1095200 2021-03-06 Johnson Texas 48251 18775 333
1095685 1095685 2021-03-06 Johnson Wyoming 56019 712 9
1089352 1089352 2021-03-05 Johnson Arkansas 5071 2794 30
1089679 1089679 2021-03-05 Johnson Georgia 13167 1093 47
1089850 1089850 2021-03-05 Johnson Illinois 17087 1353 18
1089950 1089950 2021-03-05 Johnson Indiana 18081 16487 377
1090053 1090053 2021-03-05 Johnson Iowa 19103 12906 75
1090147 1090147 2021-03-05 Johnson Kansas 20091 54730 640
1090265 1090265 2021-03-05 Johnson Kentucky 21115 1821 18
1090753 1090753 2021-03-05 Johnson Missouri 29101 3881 45
1090924 1090924 2021-03-05 Johnson Nebraska 31097 628 8
1091778 1091778 2021-03-05 Johnson Tennessee 47091 2173 38
1091954 1091954 2021-03-05 Johnson Texas 48251 18748 332
1092439 1092439 2021-03-05 Johnson Wyoming 56019 712 9
1086107 1086107 2021-03-04 Johnson Arkansas 5071 2781 30
1086434 1086434 2021-03-04 Johnson Georgia 13167 1095 47
1086605 1086605 2021-03-04 Johnson Illinois 17087 1353 18
1086705 1086705 2021-03-04 Johnson Indiana 18081 16469 376
1086808 1086808 2021-03-04 Johnson Iowa 19103 12906 75
1086902 1086902 2021-03-04 Johnson Kansas 20091 54533 646
1087020 1087020 2021-03-04 Johnson Kentucky 21115 1815 18
1087508 1087508 2021-03-04 Johnson Missouri 29101 3874 45
1087679 1087679 2021-03-04 Johnson Nebraska 31097 628 8
1088532 1088532 2021-03-04 Johnson Tennessee 47091 2171 38
1088708 1088708 2021-03-04 Johnson Texas 48251 18715 330
1089193 1089193 2021-03-04 Johnson Wyoming 56019 712 9
1082861 1082861 2021-03-03 Johnson Arkansas 5071 2772 30
1083188 1083188 2021-03-03 Johnson Georgia 13167 1095 47
1083359 1083359 2021-03-03 Johnson Illinois 17087 1351 18
1083459 1083459 2021-03-03 Johnson Indiana 18081 16442 375
1083562 1083562 2021-03-03 Johnson Iowa 19103 12906 74
1083656 1083656 2021-03-03 Johnson Kansas 20091 54533 644
1083774 1083774 2021-03-03 Johnson Kentucky 21115 1808 18
1084263 1084263 2021-03-03 Johnson Missouri 29101 3871 45
1084434 1084434 2021-03-03 Johnson Nebraska 31097 629 8
1085287 1085287 2021-03-03 Johnson Tennessee 47091 2166 38
1085463 1085463 2021-03-03 Johnson Texas 48251 18655 323
1085948 1085948 2021-03-03 Johnson Wyoming 56019 712 9
1079615 1079615 2021-03-02 Johnson Arkansas 5071 2767 30
1079942 1079942 2021-03-02 Johnson Georgia 13167 1094 47
1080113 1080113 2021-03-02 Johnson Illinois 17087 1347 18
1080213 1080213 2021-03-02 Johnson Indiana 18081 16424 375
1080316 1080316 2021-03-02 Johnson Iowa 19103 12906 74
1080410 1080410 2021-03-02 Johnson Kansas 20091 54370 644
1080528 1080528 2021-03-02 Johnson Kentucky 21115 1802 18
1081017 1081017 2021-03-02 Johnson Missouri 29101 3865 45
1081188 1081188 2021-03-02 Johnson Nebraska 31097 628 8
1082041 1082041 2021-03-02 Johnson Tennessee 47091 2163 38
1082217 1082217 2021-03-02 Johnson Texas 48251 18608 321
1082702 1082702 2021-03-02 Johnson Wyoming 56019 712 9
1076370 1076370 2021-03-01 Johnson Arkansas 5071 2758 30
1076697 1076697 2021-03-01 Johnson Georgia 13167 1092 47
1076868 1076868 2021-03-01 Johnson Illinois 17087 1347 18
1076968 1076968 2021-03-01 Johnson Indiana 18081 16411 375
1077071 1077071 2021-03-01 Johnson Iowa 19103 12906 73
1077165 1077165 2021-03-01 Johnson Kansas 20091 54370 639
1077283 1077283 2021-03-01 Johnson Kentucky 21115 1780 18
1077771 1077771 2021-03-01 Johnson Missouri 29101 3865 45
1077942 1077942 2021-03-01 Johnson Nebraska 31097 628 8
1078795 1078795 2021-03-01 Johnson Tennessee 47091 2162 38
1078971 1078971 2021-03-01 Johnson Texas 48251 18518 318
1079456 1079456 2021-03-01 Johnson Wyoming 56019 712 9
1073124 1073124 2021-02-28 Johnson Arkansas 5071 2755 30
1073451 1073451 2021-02-28 Johnson Georgia 13167 1093 47
1073622 1073622 2021-02-28 Johnson Illinois 17087 1347 18
1073722 1073722 2021-02-28 Johnson Indiana 18081 16398 374
1073825 1073825 2021-02-28 Johnson Iowa 19103 12906 73
1073919 1073919 2021-02-28 Johnson Kansas 20091 54224 638
1074037 1074037 2021-02-28 Johnson Kentucky 21115 1774 18
1074525 1074525 2021-02-28 Johnson Missouri 29101 3876 45
1074696 1074696 2021-02-28 Johnson Nebraska 31097 628 8
1075550 1075550 2021-02-28 Johnson Tennessee 47091 2163 38
1075726 1075726 2021-02-28 Johnson Texas 48251 18518 318
1076211 1076211 2021-02-28 Johnson Wyoming 56019 712 9
1069878 1069878 2021-02-27 Johnson Arkansas 5071 2741 31
1070205 1070205 2021-02-27 Johnson Georgia 13167 1094 47
1070376 1070376 2021-02-27 Johnson Illinois 17087 1347 18
1070476 1070476 2021-02-27 Johnson Indiana 18081 16381 371
1070579 1070579 2021-02-27 Johnson Iowa 19103 12906 73
1070673 1070673 2021-02-27 Johnson Kansas 20091 54224 638
1070791 1070791 2021-02-27 Johnson Kentucky 21115 1771 18
1071279 1071279 2021-02-27 Johnson Missouri 29101 3876 45
1071450 1071450 2021-02-27 Johnson Nebraska 31097 628 8
1072304 1072304 2021-02-27 Johnson Tennessee 47091 2163 38
1072480 1072480 2021-02-27 Johnson Texas 48251 18518 318
1072965 1072965 2021-02-27 Johnson Wyoming 56019 712 9
1066633 1066633 2021-02-26 Johnson Arkansas 5071 2734 31
1066960 1066960 2021-02-26 Johnson Georgia 13167 1094 47
1067131 1067131 2021-02-26 Johnson Illinois 17087 1347 18
1067231 1067231 2021-02-26 Johnson Indiana 18081 16374 371

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);