ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Bonner" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417694 | 1417694 | 2021-06-14 | Bonner | Idaho | 16017 | 3346 | 43 |
1414448 | 1414448 | 2021-06-13 | Bonner | Idaho | 16017 | 3341 | 43 |
1411203 | 1411203 | 2021-06-12 | Bonner | Idaho | 16017 | 3341 | 43 |
1407958 | 1407958 | 2021-06-11 | Bonner | Idaho | 16017 | 3341 | 43 |
1404712 | 1404712 | 2021-06-10 | Bonner | Idaho | 16017 | 3339 | 43 |
1401467 | 1401467 | 2021-06-09 | Bonner | Idaho | 16017 | 3332 | 43 |
1398222 | 1398222 | 2021-06-08 | Bonner | Idaho | 16017 | 3328 | 43 |
1394975 | 1394975 | 2021-06-07 | Bonner | Idaho | 16017 | 3326 | 43 |
1391730 | 1391730 | 2021-06-06 | Bonner | Idaho | 16017 | 3323 | 43 |
1388485 | 1388485 | 2021-06-05 | Bonner | Idaho | 16017 | 3323 | 43 |
1385240 | 1385240 | 2021-06-04 | Bonner | Idaho | 16017 | 3323 | 43 |
1381994 | 1381994 | 2021-06-03 | Bonner | Idaho | 16017 | 3323 | 43 |
1378749 | 1378749 | 2021-06-02 | Bonner | Idaho | 16017 | 3315 | 43 |
1375503 | 1375503 | 2021-06-01 | Bonner | Idaho | 16017 | 3310 | 43 |
1372258 | 1372258 | 2021-05-31 | Bonner | Idaho | 16017 | 3306 | 43 |
1369013 | 1369013 | 2021-05-30 | Bonner | Idaho | 16017 | 3306 | 43 |
1365767 | 1365767 | 2021-05-29 | Bonner | Idaho | 16017 | 3306 | 43 |
1362521 | 1362521 | 2021-05-28 | Bonner | Idaho | 16017 | 3306 | 43 |
1359274 | 1359274 | 2021-05-27 | Bonner | Idaho | 16017 | 3304 | 43 |
1356028 | 1356028 | 2021-05-26 | Bonner | Idaho | 16017 | 3298 | 43 |
1352782 | 1352782 | 2021-05-25 | Bonner | Idaho | 16017 | 3292 | 43 |
1349536 | 1349536 | 2021-05-24 | Bonner | Idaho | 16017 | 3287 | 43 |
1346289 | 1346289 | 2021-05-23 | Bonner | Idaho | 16017 | 3281 | 43 |
1343041 | 1343041 | 2021-05-22 | Bonner | Idaho | 16017 | 3281 | 43 |
1339793 | 1339793 | 2021-05-21 | Bonner | Idaho | 16017 | 3281 | 43 |
1336546 | 1336546 | 2021-05-20 | Bonner | Idaho | 16017 | 3279 | 43 |
1333299 | 1333299 | 2021-05-19 | Bonner | Idaho | 16017 | 3266 | 43 |
1330052 | 1330052 | 2021-05-18 | Bonner | Idaho | 16017 | 3262 | 43 |
1326805 | 1326805 | 2021-05-17 | Bonner | Idaho | 16017 | 3256 | 43 |
1323559 | 1323559 | 2021-05-16 | Bonner | Idaho | 16017 | 3250 | 43 |
1320313 | 1320313 | 2021-05-15 | Bonner | Idaho | 16017 | 3250 | 43 |
1317066 | 1317066 | 2021-05-14 | Bonner | Idaho | 16017 | 3250 | 43 |
1313819 | 1313819 | 2021-05-13 | Bonner | Idaho | 16017 | 3248 | 43 |
1310572 | 1310572 | 2021-05-12 | Bonner | Idaho | 16017 | 3247 | 43 |
1307326 | 1307326 | 2021-05-11 | Bonner | Idaho | 16017 | 3242 | 43 |
1304080 | 1304080 | 2021-05-10 | Bonner | Idaho | 16017 | 3238 | 43 |
1300833 | 1300833 | 2021-05-09 | Bonner | Idaho | 16017 | 3233 | 43 |
1297586 | 1297586 | 2021-05-08 | Bonner | Idaho | 16017 | 3233 | 43 |
1294340 | 1294340 | 2021-05-07 | Bonner | Idaho | 16017 | 3233 | 43 |
1291094 | 1291094 | 2021-05-06 | Bonner | Idaho | 16017 | 3231 | 43 |
1287848 | 1287848 | 2021-05-05 | Bonner | Idaho | 16017 | 3230 | 43 |
1284602 | 1284602 | 2021-05-04 | Bonner | Idaho | 16017 | 3227 | 43 |
1281355 | 1281355 | 2021-05-03 | Bonner | Idaho | 16017 | 3224 | 43 |
1278108 | 1278108 | 2021-05-02 | Bonner | Idaho | 16017 | 3221 | 43 |
1274861 | 1274861 | 2021-05-01 | Bonner | Idaho | 16017 | 3221 | 43 |
1271614 | 1271614 | 2021-04-30 | Bonner | Idaho | 16017 | 3221 | 43 |
1268367 | 1268367 | 2021-04-29 | Bonner | Idaho | 16017 | 3218 | 43 |
1265120 | 1265120 | 2021-04-28 | Bonner | Idaho | 16017 | 3218 | 43 |
1261873 | 1261873 | 2021-04-27 | Bonner | Idaho | 16017 | 3216 | 40 |
1258626 | 1258626 | 2021-04-26 | Bonner | Idaho | 16017 | 3212 | 40 |
1255379 | 1255379 | 2021-04-25 | Bonner | Idaho | 16017 | 3205 | 40 |
1252132 | 1252132 | 2021-04-24 | Bonner | Idaho | 16017 | 3205 | 40 |
1248885 | 1248885 | 2021-04-23 | Bonner | Idaho | 16017 | 3205 | 40 |
1245638 | 1245638 | 2021-04-22 | Bonner | Idaho | 16017 | 3201 | 39 |
1242391 | 1242391 | 2021-04-21 | Bonner | Idaho | 16017 | 3195 | 39 |
1239144 | 1239144 | 2021-04-20 | Bonner | Idaho | 16017 | 3193 | 39 |
1235897 | 1235897 | 2021-04-19 | Bonner | Idaho | 16017 | 3190 | 40 |
1232650 | 1232650 | 2021-04-18 | Bonner | Idaho | 16017 | 3181 | 39 |
1229401 | 1229401 | 2021-04-17 | Bonner | Idaho | 16017 | 3181 | 39 |
1226153 | 1226153 | 2021-04-16 | Bonner | Idaho | 16017 | 3181 | 39 |
1222906 | 1222906 | 2021-04-15 | Bonner | Idaho | 16017 | 3178 | 40 |
1219658 | 1219658 | 2021-04-14 | Bonner | Idaho | 16017 | 3170 | 39 |
1216410 | 1216410 | 2021-04-13 | Bonner | Idaho | 16017 | 3155 | 39 |
1213163 | 1213163 | 2021-04-12 | Bonner | Idaho | 16017 | 3143 | 39 |
1209915 | 1209915 | 2021-04-11 | Bonner | Idaho | 16017 | 3136 | 39 |
1206666 | 1206666 | 2021-04-10 | Bonner | Idaho | 16017 | 3136 | 39 |
1203418 | 1203418 | 2021-04-09 | Bonner | Idaho | 16017 | 3136 | 39 |
1200170 | 1200170 | 2021-04-08 | Bonner | Idaho | 16017 | 3128 | 39 |
1196921 | 1196921 | 2021-04-07 | Bonner | Idaho | 16017 | 3125 | 39 |
1193673 | 1193673 | 2021-04-06 | Bonner | Idaho | 16017 | 3114 | 39 |
1190423 | 1190423 | 2021-04-05 | Bonner | Idaho | 16017 | 3111 | 39 |
1187176 | 1187176 | 2021-04-04 | Bonner | Idaho | 16017 | 3106 | 39 |
1183929 | 1183929 | 2021-04-03 | Bonner | Idaho | 16017 | 3106 | 39 |
1180682 | 1180682 | 2021-04-02 | Bonner | Idaho | 16017 | 3106 | 39 |
1177435 | 1177435 | 2021-04-01 | Bonner | Idaho | 16017 | 3104 | 39 |
1174188 | 1174188 | 2021-03-31 | Bonner | Idaho | 16017 | 3098 | 39 |
1170941 | 1170941 | 2021-03-30 | Bonner | Idaho | 16017 | 3092 | 38 |
1167693 | 1167693 | 2021-03-29 | Bonner | Idaho | 16017 | 3088 | 38 |
1164445 | 1164445 | 2021-03-28 | Bonner | Idaho | 16017 | 3084 | 38 |
1161197 | 1161197 | 2021-03-27 | Bonner | Idaho | 16017 | 3084 | 38 |
1157949 | 1157949 | 2021-03-26 | Bonner | Idaho | 16017 | 3084 | 38 |
1154702 | 1154702 | 2021-03-25 | Bonner | Idaho | 16017 | 3081 | 38 |
1151455 | 1151455 | 2021-03-24 | Bonner | Idaho | 16017 | 3080 | 38 |
1148208 | 1148208 | 2021-03-23 | Bonner | Idaho | 16017 | 3078 | 38 |
1144961 | 1144961 | 2021-03-22 | Bonner | Idaho | 16017 | 3071 | 38 |
1141714 | 1141714 | 2021-03-21 | Bonner | Idaho | 16017 | 3064 | 38 |
1138468 | 1138468 | 2021-03-20 | Bonner | Idaho | 16017 | 3064 | 38 |
1135222 | 1135222 | 2021-03-19 | Bonner | Idaho | 16017 | 3064 | 38 |
1131975 | 1131975 | 2021-03-18 | Bonner | Idaho | 16017 | 3058 | 38 |
1128727 | 1128727 | 2021-03-17 | Bonner | Idaho | 16017 | 3054 | 37 |
1125481 | 1125481 | 2021-03-16 | Bonner | Idaho | 16017 | 3050 | 37 |
1122235 | 1122235 | 2021-03-15 | Bonner | Idaho | 16017 | 3044 | 35 |
1118988 | 1118988 | 2021-03-14 | Bonner | Idaho | 16017 | 3038 | 35 |
1115741 | 1115741 | 2021-03-13 | Bonner | Idaho | 16017 | 3038 | 35 |
1112495 | 1112495 | 2021-03-12 | Bonner | Idaho | 16017 | 3037 | 35 |
1109249 | 1109249 | 2021-03-11 | Bonner | Idaho | 16017 | 3033 | 35 |
1106003 | 1106003 | 2021-03-10 | Bonner | Idaho | 16017 | 3027 | 34 |
1102757 | 1102757 | 2021-03-09 | Bonner | Idaho | 16017 | 3021 | 33 |
1099511 | 1099511 | 2021-03-08 | Bonner | Idaho | 16017 | 3013 | 33 |
1096263 | 1096263 | 2021-03-07 | Bonner | Idaho | 16017 | 3003 | 33 |
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);