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 |
---|---|---|---|---|---|---|---|
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 | 13131 | 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 | 13109 | 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 | 13092 | 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 | 13065 | 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 | 13036 | 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 | 13036 | 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 |
1067334 | 1067334 | 2021-02-26 | Johnson | Iowa | 19103 | 13036 | 73 |
1067428 | 1067428 | 2021-02-26 | Johnson | Kansas | 20091 | 54224 | 638 |
1067546 | 1067546 | 2021-02-26 | Johnson | Kentucky | 21115 | 1761 | 18 |
1068034 | 1068034 | 2021-02-26 | Johnson | Missouri | 29101 | 3871 | 45 |
1068205 | 1068205 | 2021-02-26 | Johnson | Nebraska | 31097 | 629 | 8 |
1069058 | 1069058 | 2021-02-26 | Johnson | Tennessee | 47091 | 2159 | 38 |
1069234 | 1069234 | 2021-02-26 | Johnson | Texas | 48251 | 18477 | 315 |
1069719 | 1069719 | 2021-02-26 | Johnson | Wyoming | 56019 | 712 | 9 |
1063388 | 1063388 | 2021-02-25 | Johnson | Arkansas | 5071 | 2724 | 31 |
1063715 | 1063715 | 2021-02-25 | Johnson | Georgia | 13167 | 1097 | 47 |
1063886 | 1063886 | 2021-02-25 | Johnson | Illinois | 17087 | 1347 | 18 |
1063986 | 1063986 | 2021-02-25 | Johnson | Indiana | 18081 | 16352 | 370 |
1064089 | 1064089 | 2021-02-25 | Johnson | Iowa | 19103 | 13013 | 73 |
1064183 | 1064183 | 2021-02-25 | Johnson | Kansas | 20091 | 54002 | 636 |
1064301 | 1064301 | 2021-02-25 | Johnson | Kentucky | 21115 | 1747 | 18 |
1064789 | 1064789 | 2021-02-25 | Johnson | Missouri | 29101 | 3861 | 45 |
1064960 | 1064960 | 2021-02-25 | Johnson | Nebraska | 31097 | 628 | 8 |
1065813 | 1065813 | 2021-02-25 | Johnson | Tennessee | 47091 | 2159 | 38 |
1065989 | 1065989 | 2021-02-25 | Johnson | Texas | 48251 | 18409 | 313 |
1066474 | 1066474 | 2021-02-25 | Johnson | Wyoming | 56019 | 705 | 9 |
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);