ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
680 rows where fips = 16079 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417725 | 1417725 | 2021-06-14 | Shoshone | Idaho | 16079 | 1177 | 34 |
1414479 | 1414479 | 2021-06-13 | Shoshone | Idaho | 16079 | 1173 | 34 |
1411234 | 1411234 | 2021-06-12 | Shoshone | Idaho | 16079 | 1173 | 34 |
1407989 | 1407989 | 2021-06-11 | Shoshone | Idaho | 16079 | 1173 | 34 |
1404743 | 1404743 | 2021-06-10 | Shoshone | Idaho | 16079 | 1169 | 34 |
1401498 | 1401498 | 2021-06-09 | Shoshone | Idaho | 16079 | 1166 | 34 |
1398253 | 1398253 | 2021-06-08 | Shoshone | Idaho | 16079 | 1164 | 34 |
1395006 | 1395006 | 2021-06-07 | Shoshone | Idaho | 16079 | 1163 | 34 |
1391761 | 1391761 | 2021-06-06 | Shoshone | Idaho | 16079 | 1162 | 34 |
1388516 | 1388516 | 2021-06-05 | Shoshone | Idaho | 16079 | 1162 | 34 |
1385271 | 1385271 | 2021-06-04 | Shoshone | Idaho | 16079 | 1162 | 34 |
1382025 | 1382025 | 2021-06-03 | Shoshone | Idaho | 16079 | 1161 | 34 |
1378780 | 1378780 | 2021-06-02 | Shoshone | Idaho | 16079 | 1158 | 34 |
1375534 | 1375534 | 2021-06-01 | Shoshone | Idaho | 16079 | 1156 | 34 |
1372289 | 1372289 | 2021-05-31 | Shoshone | Idaho | 16079 | 1146 | 34 |
1369044 | 1369044 | 2021-05-30 | Shoshone | Idaho | 16079 | 1146 | 34 |
1365798 | 1365798 | 2021-05-29 | Shoshone | Idaho | 16079 | 1146 | 34 |
1362552 | 1362552 | 2021-05-28 | Shoshone | Idaho | 16079 | 1146 | 34 |
1359305 | 1359305 | 2021-05-27 | Shoshone | Idaho | 16079 | 1144 | 34 |
1356059 | 1356059 | 2021-05-26 | Shoshone | Idaho | 16079 | 1139 | 34 |
1352813 | 1352813 | 2021-05-25 | Shoshone | Idaho | 16079 | 1135 | 34 |
1349567 | 1349567 | 2021-05-24 | Shoshone | Idaho | 16079 | 1135 | 34 |
1346320 | 1346320 | 2021-05-23 | Shoshone | Idaho | 16079 | 1132 | 34 |
1343072 | 1343072 | 2021-05-22 | Shoshone | Idaho | 16079 | 1132 | 34 |
1339824 | 1339824 | 2021-05-21 | Shoshone | Idaho | 16079 | 1132 | 34 |
1336577 | 1336577 | 2021-05-20 | Shoshone | Idaho | 16079 | 1129 | 34 |
1333330 | 1333330 | 2021-05-19 | Shoshone | Idaho | 16079 | 1127 | 34 |
1330083 | 1330083 | 2021-05-18 | Shoshone | Idaho | 16079 | 1124 | 34 |
1326836 | 1326836 | 2021-05-17 | Shoshone | Idaho | 16079 | 1124 | 34 |
1323590 | 1323590 | 2021-05-16 | Shoshone | Idaho | 16079 | 1120 | 34 |
1320344 | 1320344 | 2021-05-15 | Shoshone | Idaho | 16079 | 1120 | 34 |
1317097 | 1317097 | 2021-05-14 | Shoshone | Idaho | 16079 | 1120 | 34 |
1313850 | 1313850 | 2021-05-13 | Shoshone | Idaho | 16079 | 1117 | 34 |
1310603 | 1310603 | 2021-05-12 | Shoshone | Idaho | 16079 | 1117 | 34 |
1307357 | 1307357 | 2021-05-11 | Shoshone | Idaho | 16079 | 1113 | 34 |
1304111 | 1304111 | 2021-05-10 | Shoshone | Idaho | 16079 | 1112 | 34 |
1300864 | 1300864 | 2021-05-09 | Shoshone | Idaho | 16079 | 1108 | 34 |
1297617 | 1297617 | 2021-05-08 | Shoshone | Idaho | 16079 | 1108 | 34 |
1294371 | 1294371 | 2021-05-07 | Shoshone | Idaho | 16079 | 1108 | 34 |
1291125 | 1291125 | 2021-05-06 | Shoshone | Idaho | 16079 | 1105 | 34 |
1287879 | 1287879 | 2021-05-05 | Shoshone | Idaho | 16079 | 1103 | 34 |
1284633 | 1284633 | 2021-05-04 | Shoshone | Idaho | 16079 | 1098 | 34 |
1281386 | 1281386 | 2021-05-03 | Shoshone | Idaho | 16079 | 1095 | 34 |
1278139 | 1278139 | 2021-05-02 | Shoshone | Idaho | 16079 | 1091 | 34 |
1274892 | 1274892 | 2021-05-01 | Shoshone | Idaho | 16079 | 1091 | 34 |
1271645 | 1271645 | 2021-04-30 | Shoshone | Idaho | 16079 | 1091 | 34 |
1268398 | 1268398 | 2021-04-29 | Shoshone | Idaho | 16079 | 1089 | 34 |
1265151 | 1265151 | 2021-04-28 | Shoshone | Idaho | 16079 | 1084 | 34 |
1261904 | 1261904 | 2021-04-27 | Shoshone | Idaho | 16079 | 1082 | 34 |
1258657 | 1258657 | 2021-04-26 | Shoshone | Idaho | 16079 | 1082 | 34 |
1255410 | 1255410 | 2021-04-25 | Shoshone | Idaho | 16079 | 1079 | 34 |
1252163 | 1252163 | 2021-04-24 | Shoshone | Idaho | 16079 | 1079 | 34 |
1248916 | 1248916 | 2021-04-23 | Shoshone | Idaho | 16079 | 1079 | 34 |
1245669 | 1245669 | 2021-04-22 | Shoshone | Idaho | 16079 | 1076 | 34 |
1242422 | 1242422 | 2021-04-21 | Shoshone | Idaho | 16079 | 1074 | 34 |
1239175 | 1239175 | 2021-04-20 | Shoshone | Idaho | 16079 | 1073 | 34 |
1235928 | 1235928 | 2021-04-19 | Shoshone | Idaho | 16079 | 1073 | 34 |
1232681 | 1232681 | 2021-04-18 | Shoshone | Idaho | 16079 | 1062 | 34 |
1229432 | 1229432 | 2021-04-17 | Shoshone | Idaho | 16079 | 1062 | 34 |
1226184 | 1226184 | 2021-04-16 | Shoshone | Idaho | 16079 | 1062 | 34 |
1222937 | 1222937 | 2021-04-15 | Shoshone | Idaho | 16079 | 1062 | 34 |
1219689 | 1219689 | 2021-04-14 | Shoshone | Idaho | 16079 | 1059 | 34 |
1216441 | 1216441 | 2021-04-13 | Shoshone | Idaho | 16079 | 1058 | 34 |
1213194 | 1213194 | 2021-04-12 | Shoshone | Idaho | 16079 | 1058 | 34 |
1209946 | 1209946 | 2021-04-11 | Shoshone | Idaho | 16079 | 1055 | 34 |
1206697 | 1206697 | 2021-04-10 | Shoshone | Idaho | 16079 | 1055 | 34 |
1203449 | 1203449 | 2021-04-09 | Shoshone | Idaho | 16079 | 1055 | 34 |
1200201 | 1200201 | 2021-04-08 | Shoshone | Idaho | 16079 | 1054 | 34 |
1196952 | 1196952 | 2021-04-07 | Shoshone | Idaho | 16079 | 1053 | 34 |
1193704 | 1193704 | 2021-04-06 | Shoshone | Idaho | 16079 | 1051 | 34 |
1190454 | 1190454 | 2021-04-05 | Shoshone | Idaho | 16079 | 1051 | 34 |
1187207 | 1187207 | 2021-04-04 | Shoshone | Idaho | 16079 | 1050 | 34 |
1183960 | 1183960 | 2021-04-03 | Shoshone | Idaho | 16079 | 1050 | 34 |
1180713 | 1180713 | 2021-04-02 | Shoshone | Idaho | 16079 | 1050 | 34 |
1177466 | 1177466 | 2021-04-01 | Shoshone | Idaho | 16079 | 1050 | 34 |
1174219 | 1174219 | 2021-03-31 | Shoshone | Idaho | 16079 | 1047 | 34 |
1170972 | 1170972 | 2021-03-30 | Shoshone | Idaho | 16079 | 1046 | 34 |
1167724 | 1167724 | 2021-03-29 | Shoshone | Idaho | 16079 | 1046 | 34 |
1164476 | 1164476 | 2021-03-28 | Shoshone | Idaho | 16079 | 1044 | 33 |
1161228 | 1161228 | 2021-03-27 | Shoshone | Idaho | 16079 | 1044 | 33 |
1157980 | 1157980 | 2021-03-26 | Shoshone | Idaho | 16079 | 1044 | 33 |
1154733 | 1154733 | 2021-03-25 | Shoshone | Idaho | 16079 | 1043 | 33 |
1151486 | 1151486 | 2021-03-24 | Shoshone | Idaho | 16079 | 1043 | 33 |
1148239 | 1148239 | 2021-03-23 | Shoshone | Idaho | 16079 | 1040 | 33 |
1144992 | 1144992 | 2021-03-22 | Shoshone | Idaho | 16079 | 1038 | 33 |
1141745 | 1141745 | 2021-03-21 | Shoshone | Idaho | 16079 | 1033 | 33 |
1138499 | 1138499 | 2021-03-20 | Shoshone | Idaho | 16079 | 1033 | 33 |
1135253 | 1135253 | 2021-03-19 | Shoshone | Idaho | 16079 | 1033 | 33 |
1132006 | 1132006 | 2021-03-18 | Shoshone | Idaho | 16079 | 1031 | 33 |
1128758 | 1128758 | 2021-03-17 | Shoshone | Idaho | 16079 | 1029 | 33 |
1125512 | 1125512 | 2021-03-16 | Shoshone | Idaho | 16079 | 1027 | 33 |
1122266 | 1122266 | 2021-03-15 | Shoshone | Idaho | 16079 | 1024 | 32 |
1119019 | 1119019 | 2021-03-14 | Shoshone | Idaho | 16079 | 1020 | 32 |
1115772 | 1115772 | 2021-03-13 | Shoshone | Idaho | 16079 | 1020 | 32 |
1112526 | 1112526 | 2021-03-12 | Shoshone | Idaho | 16079 | 1019 | 32 |
1109280 | 1109280 | 2021-03-11 | Shoshone | Idaho | 16079 | 1018 | 32 |
1106034 | 1106034 | 2021-03-10 | Shoshone | Idaho | 16079 | 1016 | 32 |
1102788 | 1102788 | 2021-03-09 | Shoshone | Idaho | 16079 | 1016 | 32 |
1099542 | 1099542 | 2021-03-08 | Shoshone | Idaho | 16079 | 1015 | 32 |
1096294 | 1096294 | 2021-03-07 | Shoshone | Idaho | 16079 | 1012 | 32 |
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);