ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
668 rows where fips = 30097 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418790 | 1418790 | 2021-06-14 | Sweet Grass | Montana | 30097 | 403 | 7 |
1415545 | 1415545 | 2021-06-13 | Sweet Grass | Montana | 30097 | 403 | 7 |
1412299 | 1412299 | 2021-06-12 | Sweet Grass | Montana | 30097 | 403 | 7 |
1409054 | 1409054 | 2021-06-11 | Sweet Grass | Montana | 30097 | 403 | 7 |
1405809 | 1405809 | 2021-06-10 | Sweet Grass | Montana | 30097 | 403 | 7 |
1402563 | 1402563 | 2021-06-09 | Sweet Grass | Montana | 30097 | 403 | 7 |
1399318 | 1399318 | 2021-06-08 | Sweet Grass | Montana | 30097 | 403 | 7 |
1396072 | 1396072 | 2021-06-07 | Sweet Grass | Montana | 30097 | 403 | 7 |
1392826 | 1392826 | 2021-06-06 | Sweet Grass | Montana | 30097 | 403 | 7 |
1389581 | 1389581 | 2021-06-05 | Sweet Grass | Montana | 30097 | 403 | 7 |
1386336 | 1386336 | 2021-06-04 | Sweet Grass | Montana | 30097 | 403 | 7 |
1383091 | 1383091 | 2021-06-03 | Sweet Grass | Montana | 30097 | 403 | 7 |
1379845 | 1379845 | 2021-06-02 | Sweet Grass | Montana | 30097 | 402 | 7 |
1376600 | 1376600 | 2021-06-01 | Sweet Grass | Montana | 30097 | 402 | 7 |
1373354 | 1373354 | 2021-05-31 | Sweet Grass | Montana | 30097 | 402 | 7 |
1370109 | 1370109 | 2021-05-30 | Sweet Grass | Montana | 30097 | 402 | 7 |
1366863 | 1366863 | 2021-05-29 | Sweet Grass | Montana | 30097 | 402 | 7 |
1363617 | 1363617 | 2021-05-28 | Sweet Grass | Montana | 30097 | 402 | 7 |
1360370 | 1360370 | 2021-05-27 | Sweet Grass | Montana | 30097 | 402 | 7 |
1357124 | 1357124 | 2021-05-26 | Sweet Grass | Montana | 30097 | 400 | 7 |
1353878 | 1353878 | 2021-05-25 | Sweet Grass | Montana | 30097 | 400 | 7 |
1350632 | 1350632 | 2021-05-24 | Sweet Grass | Montana | 30097 | 400 | 7 |
1347386 | 1347386 | 2021-05-23 | Sweet Grass | Montana | 30097 | 400 | 7 |
1344138 | 1344138 | 2021-05-22 | Sweet Grass | Montana | 30097 | 400 | 7 |
1340890 | 1340890 | 2021-05-21 | Sweet Grass | Montana | 30097 | 400 | 7 |
1337642 | 1337642 | 2021-05-20 | Sweet Grass | Montana | 30097 | 400 | 7 |
1334395 | 1334395 | 2021-05-19 | Sweet Grass | Montana | 30097 | 399 | 7 |
1331148 | 1331148 | 2021-05-18 | Sweet Grass | Montana | 30097 | 399 | 7 |
1327901 | 1327901 | 2021-05-17 | Sweet Grass | Montana | 30097 | 399 | 7 |
1324655 | 1324655 | 2021-05-16 | Sweet Grass | Montana | 30097 | 399 | 7 |
1321409 | 1321409 | 2021-05-15 | Sweet Grass | Montana | 30097 | 399 | 7 |
1318163 | 1318163 | 2021-05-14 | Sweet Grass | Montana | 30097 | 399 | 7 |
1314915 | 1314915 | 2021-05-13 | Sweet Grass | Montana | 30097 | 399 | 7 |
1311669 | 1311669 | 2021-05-12 | Sweet Grass | Montana | 30097 | 399 | 7 |
1308422 | 1308422 | 2021-05-11 | Sweet Grass | Montana | 30097 | 399 | 7 |
1305176 | 1305176 | 2021-05-10 | Sweet Grass | Montana | 30097 | 398 | 7 |
1301930 | 1301930 | 2021-05-09 | Sweet Grass | Montana | 30097 | 398 | 7 |
1298682 | 1298682 | 2021-05-08 | Sweet Grass | Montana | 30097 | 398 | 7 |
1295436 | 1295436 | 2021-05-07 | Sweet Grass | Montana | 30097 | 396 | 7 |
1292190 | 1292190 | 2021-05-06 | Sweet Grass | Montana | 30097 | 396 | 7 |
1288944 | 1288944 | 2021-05-05 | Sweet Grass | Montana | 30097 | 396 | 7 |
1285698 | 1285698 | 2021-05-04 | Sweet Grass | Montana | 30097 | 394 | 7 |
1282452 | 1282452 | 2021-05-03 | Sweet Grass | Montana | 30097 | 394 | 7 |
1279205 | 1279205 | 2021-05-02 | Sweet Grass | Montana | 30097 | 394 | 7 |
1275958 | 1275958 | 2021-05-01 | Sweet Grass | Montana | 30097 | 394 | 7 |
1272711 | 1272711 | 2021-04-30 | Sweet Grass | Montana | 30097 | 394 | 7 |
1269464 | 1269464 | 2021-04-29 | Sweet Grass | Montana | 30097 | 394 | 7 |
1266217 | 1266217 | 2021-04-28 | Sweet Grass | Montana | 30097 | 392 | 7 |
1262970 | 1262970 | 2021-04-27 | Sweet Grass | Montana | 30097 | 392 | 7 |
1259723 | 1259723 | 2021-04-26 | Sweet Grass | Montana | 30097 | 391 | 7 |
1256476 | 1256476 | 2021-04-25 | Sweet Grass | Montana | 30097 | 391 | 7 |
1253229 | 1253229 | 2021-04-24 | Sweet Grass | Montana | 30097 | 391 | 7 |
1249982 | 1249982 | 2021-04-23 | Sweet Grass | Montana | 30097 | 391 | 7 |
1246735 | 1246735 | 2021-04-22 | Sweet Grass | Montana | 30097 | 391 | 7 |
1243488 | 1243488 | 2021-04-21 | Sweet Grass | Montana | 30097 | 390 | 7 |
1240241 | 1240241 | 2021-04-20 | Sweet Grass | Montana | 30097 | 389 | 7 |
1236994 | 1236994 | 2021-04-19 | Sweet Grass | Montana | 30097 | 388 | 7 |
1233747 | 1233747 | 2021-04-18 | Sweet Grass | Montana | 30097 | 388 | 7 |
1230499 | 1230499 | 2021-04-17 | Sweet Grass | Montana | 30097 | 388 | 7 |
1227251 | 1227251 | 2021-04-16 | Sweet Grass | Montana | 30097 | 388 | 7 |
1224003 | 1224003 | 2021-04-15 | Sweet Grass | Montana | 30097 | 387 | 7 |
1220756 | 1220756 | 2021-04-14 | Sweet Grass | Montana | 30097 | 387 | 7 |
1217508 | 1217508 | 2021-04-13 | Sweet Grass | Montana | 30097 | 387 | 7 |
1214261 | 1214261 | 2021-04-12 | Sweet Grass | Montana | 30097 | 387 | 7 |
1211013 | 1211013 | 2021-04-11 | Sweet Grass | Montana | 30097 | 387 | 7 |
1207764 | 1207764 | 2021-04-10 | Sweet Grass | Montana | 30097 | 387 | 7 |
1204516 | 1204516 | 2021-04-09 | Sweet Grass | Montana | 30097 | 387 | 7 |
1201268 | 1201268 | 2021-04-08 | Sweet Grass | Montana | 30097 | 387 | 7 |
1198019 | 1198019 | 2021-04-07 | Sweet Grass | Montana | 30097 | 387 | 7 |
1194770 | 1194770 | 2021-04-06 | Sweet Grass | Montana | 30097 | 387 | 7 |
1191521 | 1191521 | 2021-04-05 | Sweet Grass | Montana | 30097 | 385 | 7 |
1188273 | 1188273 | 2021-04-04 | Sweet Grass | Montana | 30097 | 385 | 7 |
1185026 | 1185026 | 2021-04-03 | Sweet Grass | Montana | 30097 | 385 | 7 |
1181780 | 1181780 | 2021-04-02 | Sweet Grass | Montana | 30097 | 383 | 7 |
1178533 | 1178533 | 2021-04-01 | Sweet Grass | Montana | 30097 | 382 | 7 |
1175286 | 1175286 | 2021-03-31 | Sweet Grass | Montana | 30097 | 381 | 7 |
1172039 | 1172039 | 2021-03-30 | Sweet Grass | Montana | 30097 | 381 | 7 |
1168791 | 1168791 | 2021-03-29 | Sweet Grass | Montana | 30097 | 381 | 7 |
1165543 | 1165543 | 2021-03-28 | Sweet Grass | Montana | 30097 | 381 | 7 |
1162295 | 1162295 | 2021-03-27 | Sweet Grass | Montana | 30097 | 381 | 7 |
1159047 | 1159047 | 2021-03-26 | Sweet Grass | Montana | 30097 | 380 | 7 |
1155800 | 1155800 | 2021-03-25 | Sweet Grass | Montana | 30097 | 379 | 7 |
1152553 | 1152553 | 2021-03-24 | Sweet Grass | Montana | 30097 | 379 | 7 |
1149306 | 1149306 | 2021-03-23 | Sweet Grass | Montana | 30097 | 379 | 7 |
1146059 | 1146059 | 2021-03-22 | Sweet Grass | Montana | 30097 | 379 | 7 |
1142812 | 1142812 | 2021-03-21 | Sweet Grass | Montana | 30097 | 379 | 7 |
1139565 | 1139565 | 2021-03-20 | Sweet Grass | Montana | 30097 | 379 | 7 |
1136319 | 1136319 | 2021-03-19 | Sweet Grass | Montana | 30097 | 376 | 7 |
1133073 | 1133073 | 2021-03-18 | Sweet Grass | Montana | 30097 | 376 | 7 |
1129825 | 1129825 | 2021-03-17 | Sweet Grass | Montana | 30097 | 376 | 7 |
1126578 | 1126578 | 2021-03-16 | Sweet Grass | Montana | 30097 | 374 | 7 |
1123332 | 1123332 | 2021-03-15 | Sweet Grass | Montana | 30097 | 372 | 7 |
1120085 | 1120085 | 2021-03-14 | Sweet Grass | Montana | 30097 | 370 | 7 |
1116838 | 1116838 | 2021-03-13 | Sweet Grass | Montana | 30097 | 372 | 7 |
1113592 | 1113592 | 2021-03-12 | Sweet Grass | Montana | 30097 | 372 | 7 |
1110346 | 1110346 | 2021-03-11 | Sweet Grass | Montana | 30097 | 371 | 7 |
1107100 | 1107100 | 2021-03-10 | Sweet Grass | Montana | 30097 | 371 | 7 |
1103854 | 1103854 | 2021-03-09 | Sweet Grass | Montana | 30097 | 370 | 7 |
1100608 | 1100608 | 2021-03-08 | Sweet Grass | Montana | 30097 | 369 | 7 |
1097361 | 1097361 | 2021-03-07 | Sweet Grass | Montana | 30097 | 369 | 7 |
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);