ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Butte" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417319 | 1417319 | 2021-06-14 | Butte | California | 6007 | 12586 | 194 |
1414073 | 1414073 | 2021-06-13 | Butte | California | 6007 | 12576 | 194 |
1410828 | 1410828 | 2021-06-12 | Butte | California | 6007 | 12576 | 194 |
1407583 | 1407583 | 2021-06-11 | Butte | California | 6007 | 12565 | 194 |
1404337 | 1404337 | 2021-06-10 | Butte | California | 6007 | 12555 | 194 |
1401092 | 1401092 | 2021-06-09 | Butte | California | 6007 | 12540 | 194 |
1397847 | 1397847 | 2021-06-08 | Butte | California | 6007 | 12533 | 194 |
1394600 | 1394600 | 2021-06-07 | Butte | California | 6007 | 12527 | 194 |
1391355 | 1391355 | 2021-06-06 | Butte | California | 6007 | 12514 | 194 |
1388110 | 1388110 | 2021-06-05 | Butte | California | 6007 | 12494 | 193 |
1384865 | 1384865 | 2021-06-04 | Butte | California | 6007 | 12478 | 193 |
1381619 | 1381619 | 2021-06-03 | Butte | California | 6007 | 12432 | 193 |
1378374 | 1378374 | 2021-06-02 | Butte | California | 6007 | 12427 | 193 |
1375128 | 1375128 | 2021-06-01 | Butte | California | 6007 | 12429 | 193 |
1371883 | 1371883 | 2021-05-31 | Butte | California | 6007 | 12427 | 190 |
1368638 | 1368638 | 2021-05-30 | Butte | California | 6007 | 12425 | 190 |
1365392 | 1365392 | 2021-05-29 | Butte | California | 6007 | 12407 | 190 |
1362146 | 1362146 | 2021-05-28 | Butte | California | 6007 | 12401 | 190 |
1358899 | 1358899 | 2021-05-27 | Butte | California | 6007 | 12332 | 190 |
1355653 | 1355653 | 2021-05-26 | Butte | California | 6007 | 12295 | 189 |
1352407 | 1352407 | 2021-05-25 | Butte | California | 6007 | 12279 | 189 |
1349161 | 1349161 | 2021-05-24 | Butte | California | 6007 | 12271 | 189 |
1345914 | 1345914 | 2021-05-23 | Butte | California | 6007 | 12265 | 189 |
1342666 | 1342666 | 2021-05-22 | Butte | California | 6007 | 12236 | 188 |
1339418 | 1339418 | 2021-05-21 | Butte | California | 6007 | 12220 | 188 |
1336171 | 1336171 | 2021-05-20 | Butte | California | 6007 | 12198 | 188 |
1332924 | 1332924 | 2021-05-19 | Butte | California | 6007 | 12164 | 191 |
1329677 | 1329677 | 2021-05-18 | Butte | California | 6007 | 12144 | 192 |
1326430 | 1326430 | 2021-05-17 | Butte | California | 6007 | 12140 | 192 |
1323184 | 1323184 | 2021-05-16 | Butte | California | 6007 | 12095 | 192 |
1319938 | 1319938 | 2021-05-15 | Butte | California | 6007 | 12076 | 192 |
1316691 | 1316691 | 2021-05-14 | Butte | California | 6007 | 12051 | 196 |
1313444 | 1313444 | 2021-05-13 | Butte | California | 6007 | 12026 | 199 |
1310197 | 1310197 | 2021-05-12 | Butte | California | 6007 | 12008 | 199 |
1306951 | 1306951 | 2021-05-11 | Butte | California | 6007 | 11993 | 199 |
1303705 | 1303705 | 2021-05-10 | Butte | California | 6007 | 11985 | 199 |
1300458 | 1300458 | 2021-05-09 | Butte | California | 6007 | 11962 | 199 |
1297211 | 1297211 | 2021-05-08 | Butte | California | 6007 | 11943 | 199 |
1293965 | 1293965 | 2021-05-07 | Butte | California | 6007 | 11929 | 198 |
1290719 | 1290719 | 2021-05-06 | Butte | California | 6007 | 11907 | 198 |
1287473 | 1287473 | 2021-05-05 | Butte | California | 6007 | 11883 | 198 |
1284227 | 1284227 | 2021-05-04 | Butte | California | 6007 | 11864 | 198 |
1280980 | 1280980 | 2021-05-03 | Butte | California | 6007 | 11859 | 198 |
1277733 | 1277733 | 2021-05-02 | Butte | California | 6007 | 11845 | 198 |
1274486 | 1274486 | 2021-05-01 | Butte | California | 6007 | 11812 | 197 |
1271239 | 1271239 | 2021-04-30 | Butte | California | 6007 | 11787 | 196 |
1267992 | 1267992 | 2021-04-29 | Butte | California | 6007 | 11762 | 196 |
1264745 | 1264745 | 2021-04-28 | Butte | California | 6007 | 11738 | 196 |
1261498 | 1261498 | 2021-04-27 | Butte | California | 6007 | 11720 | 196 |
1258251 | 1258251 | 2021-04-26 | Butte | California | 6007 | 11709 | 196 |
1255004 | 1255004 | 2021-04-25 | Butte | California | 6007 | 11678 | 196 |
1251757 | 1251757 | 2021-04-24 | Butte | California | 6007 | 11672 | 196 |
1248510 | 1248510 | 2021-04-23 | Butte | California | 6007 | 11656 | 196 |
1245263 | 1245263 | 2021-04-22 | Butte | California | 6007 | 11643 | 196 |
1242016 | 1242016 | 2021-04-21 | Butte | California | 6007 | 11619 | 196 |
1238769 | 1238769 | 2021-04-20 | Butte | California | 6007 | 11601 | 196 |
1235522 | 1235522 | 2021-04-19 | Butte | California | 6007 | 11591 | 196 |
1232275 | 1232275 | 2021-04-18 | Butte | California | 6007 | 11573 | 196 |
1229026 | 1229026 | 2021-04-17 | Butte | California | 6007 | 11549 | 196 |
1225778 | 1225778 | 2021-04-16 | Butte | California | 6007 | 11529 | 196 |
1222531 | 1222531 | 2021-04-15 | Butte | California | 6007 | 11513 | 196 |
1219283 | 1219283 | 2021-04-14 | Butte | California | 6007 | 11497 | 196 |
1216035 | 1216035 | 2021-04-13 | Butte | California | 6007 | 11488 | 193 |
1212788 | 1212788 | 2021-04-12 | Butte | California | 6007 | 11487 | 193 |
1209540 | 1209540 | 2021-04-11 | Butte | California | 6007 | 11482 | 193 |
1206291 | 1206291 | 2021-04-10 | Butte | California | 6007 | 11454 | 193 |
1203043 | 1203043 | 2021-04-09 | Butte | California | 6007 | 11414 | 193 |
1199795 | 1199795 | 2021-04-08 | Butte | California | 6007 | 11405 | 193 |
1196546 | 1196546 | 2021-04-07 | Butte | California | 6007 | 11396 | 193 |
1193298 | 1193298 | 2021-04-06 | Butte | California | 6007 | 11384 | 193 |
1190048 | 1190048 | 2021-04-05 | Butte | California | 6007 | 11375 | 193 |
1186801 | 1186801 | 2021-04-04 | Butte | California | 6007 | 11359 | 193 |
1183554 | 1183554 | 2021-04-03 | Butte | California | 6007 | 11350 | 193 |
1180307 | 1180307 | 2021-04-02 | Butte | California | 6007 | 11328 | 193 |
1177060 | 1177060 | 2021-04-01 | Butte | California | 6007 | 11321 | 193 |
1173813 | 1173813 | 2021-03-31 | Butte | California | 6007 | 11296 | 193 |
1170566 | 1170566 | 2021-03-30 | Butte | California | 6007 | 11291 | 191 |
1167318 | 1167318 | 2021-03-29 | Butte | California | 6007 | 11285 | 191 |
1164070 | 1164070 | 2021-03-28 | Butte | California | 6007 | 11278 | 191 |
1160822 | 1160822 | 2021-03-27 | Butte | California | 6007 | 11278 | 191 |
1157574 | 1157574 | 2021-03-26 | Butte | California | 6007 | 11270 | 188 |
1154327 | 1154327 | 2021-03-25 | Butte | California | 6007 | 11252 | 187 |
1151080 | 1151080 | 2021-03-24 | Butte | California | 6007 | 11227 | 187 |
1147833 | 1147833 | 2021-03-23 | Butte | California | 6007 | 11211 | 185 |
1144586 | 1144586 | 2021-03-22 | Butte | California | 6007 | 11208 | 185 |
1141339 | 1141339 | 2021-03-21 | Butte | California | 6007 | 11199 | 185 |
1138093 | 1138093 | 2021-03-20 | Butte | California | 6007 | 11191 | 185 |
1134847 | 1134847 | 2021-03-19 | Butte | California | 6007 | 11179 | 185 |
1131600 | 1131600 | 2021-03-18 | Butte | California | 6007 | 11170 | 185 |
1128352 | 1128352 | 2021-03-17 | Butte | California | 6007 | 11154 | 184 |
1125106 | 1125106 | 2021-03-16 | Butte | California | 6007 | 11141 | 185 |
1121860 | 1121860 | 2021-03-15 | Butte | California | 6007 | 11140 | 185 |
1118613 | 1118613 | 2021-03-14 | Butte | California | 6007 | 11131 | 185 |
1115366 | 1115366 | 2021-03-13 | Butte | California | 6007 | 11126 | 184 |
1112120 | 1112120 | 2021-03-12 | Butte | California | 6007 | 11110 | 170 |
1108874 | 1108874 | 2021-03-11 | Butte | California | 6007 | 11096 | 170 |
1105628 | 1105628 | 2021-03-10 | Butte | California | 6007 | 11092 | 170 |
1102382 | 1102382 | 2021-03-09 | Butte | California | 6007 | 11082 | 169 |
1099136 | 1099136 | 2021-03-08 | Butte | California | 6007 | 11075 | 169 |
1095888 | 1095888 | 2021-03-07 | Butte | California | 6007 | 11065 | 169 |
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);