ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
844 rows where fips = 53061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1494871 | 1494871 | 2021-07-07 | Snohomish | Washington | 53061 | 40493 | 610 |
1491624 | 1491624 | 2021-07-06 | Snohomish | Washington | 53061 | 40437 | 608 |
1488377 | 1488377 | 2021-07-05 | Snohomish | Washington | 53061 | 40330 | 605 |
1485130 | 1485130 | 2021-07-04 | Snohomish | Washington | 53061 | 40330 | 605 |
1481884 | 1481884 | 2021-07-03 | Snohomish | Washington | 53061 | 40330 | 605 |
1478637 | 1478637 | 2021-07-02 | Snohomish | Washington | 53061 | 40330 | 605 |
1475391 | 1475391 | 2021-07-01 | Snohomish | Washington | 53061 | 40284 | 605 |
1472145 | 1472145 | 2021-06-30 | Snohomish | Washington | 53061 | 40231 | 604 |
1468900 | 1468900 | 2021-06-29 | Snohomish | Washington | 53061 | 40178 | 601 |
1465655 | 1465655 | 2021-06-28 | Snohomish | Washington | 53061 | 40136 | 600 |
1462410 | 1462410 | 2021-06-27 | Snohomish | Washington | 53061 | 40069 | 600 |
1459165 | 1459165 | 2021-06-26 | Snohomish | Washington | 53061 | 40069 | 600 |
1455920 | 1455920 | 2021-06-25 | Snohomish | Washington | 53061 | 40026 | 600 |
1452675 | 1452675 | 2021-06-24 | Snohomish | Washington | 53061 | 39984 | 599 |
1449429 | 1449429 | 2021-06-23 | Snohomish | Washington | 53061 | 39933 | 596 |
1446184 | 1446184 | 2021-06-22 | Snohomish | Washington | 53061 | 39897 | 596 |
1442939 | 1442939 | 2021-06-21 | Snohomish | Washington | 53061 | 39844 | 596 |
1439694 | 1439694 | 2021-06-20 | Snohomish | Washington | 53061 | 39805 | 595 |
1436447 | 1436447 | 2021-06-19 | Snohomish | Washington | 53061 | 39805 | 595 |
1433200 | 1433200 | 2021-06-18 | Snohomish | Washington | 53061 | 39756 | 595 |
1429954 | 1429954 | 2021-06-17 | Snohomish | Washington | 53061 | 39709 | 593 |
1426709 | 1426709 | 2021-06-16 | Snohomish | Washington | 53061 | 39661 | 591 |
1423463 | 1423463 | 2021-06-15 | Snohomish | Washington | 53061 | 39616 | 588 |
1420216 | 1420216 | 2021-06-14 | Snohomish | Washington | 53061 | 39584 | 586 |
1416971 | 1416971 | 2021-06-13 | Snohomish | Washington | 53061 | 39544 | 586 |
1413725 | 1413725 | 2021-06-12 | Snohomish | Washington | 53061 | 39544 | 586 |
1410480 | 1410480 | 2021-06-11 | Snohomish | Washington | 53061 | 39458 | 586 |
1407235 | 1407235 | 2021-06-10 | Snohomish | Washington | 53061 | 39425 | 586 |
1403989 | 1403989 | 2021-06-09 | Snohomish | Washington | 53061 | 39382 | 583 |
1400744 | 1400744 | 2021-06-08 | Snohomish | Washington | 53061 | 39340 | 583 |
1397499 | 1397499 | 2021-06-07 | Snohomish | Washington | 53061 | 39281 | 589 |
1394252 | 1394252 | 2021-06-06 | Snohomish | Washington | 53061 | 39222 | 585 |
1391007 | 1391007 | 2021-06-05 | Snohomish | Washington | 53061 | 39222 | 585 |
1387762 | 1387762 | 2021-06-04 | Snohomish | Washington | 53061 | 39150 | 585 |
1384517 | 1384517 | 2021-06-03 | Snohomish | Washington | 53061 | 39096 | 585 |
1381271 | 1381271 | 2021-06-02 | Snohomish | Washington | 53061 | 39008 | 585 |
1378026 | 1378026 | 2021-06-01 | Snohomish | Washington | 53061 | 38954 | 585 |
1374780 | 1374780 | 2021-05-31 | Snohomish | Washington | 53061 | 38872 | 585 |
1371535 | 1371535 | 2021-05-30 | Snohomish | Washington | 53061 | 38872 | 585 |
1368289 | 1368289 | 2021-05-29 | Snohomish | Washington | 53061 | 38872 | 585 |
1365043 | 1365043 | 2021-05-28 | Snohomish | Washington | 53061 | 38817 | 585 |
1361797 | 1361797 | 2021-05-27 | Snohomish | Washington | 53061 | 38740 | 585 |
1358551 | 1358551 | 2021-05-26 | Snohomish | Washington | 53061 | 38639 | 582 |
1355305 | 1355305 | 2021-05-25 | Snohomish | Washington | 53061 | 38488 | 582 |
1352059 | 1352059 | 2021-05-24 | Snohomish | Washington | 53061 | 38418 | 582 |
1348813 | 1348813 | 2021-05-23 | Snohomish | Washington | 53061 | 38260 | 582 |
1345565 | 1345565 | 2021-05-22 | Snohomish | Washington | 53061 | 38260 | 582 |
1342317 | 1342317 | 2021-05-21 | Snohomish | Washington | 53061 | 38260 | 582 |
1339069 | 1339069 | 2021-05-20 | Snohomish | Washington | 53061 | 38096 | 580 |
1335822 | 1335822 | 2021-05-19 | Snohomish | Washington | 53061 | 38012 | 580 |
1332575 | 1332575 | 2021-05-18 | Snohomish | Washington | 53061 | 37931 | 579 |
1329328 | 1329328 | 2021-05-17 | Snohomish | Washington | 53061 | 37860 | 577 |
1326082 | 1326082 | 2021-05-16 | Snohomish | Washington | 53061 | 37807 | 574 |
1322836 | 1322836 | 2021-05-15 | Snohomish | Washington | 53061 | 37807 | 574 |
1319590 | 1319590 | 2021-05-14 | Snohomish | Washington | 53061 | 37721 | 574 |
1316342 | 1316342 | 2021-05-13 | Snohomish | Washington | 53061 | 37477 | 574 |
1313096 | 1313096 | 2021-05-12 | Snohomish | Washington | 53061 | 37373 | 573 |
1309849 | 1309849 | 2021-05-11 | Snohomish | Washington | 53061 | 37276 | 573 |
1306603 | 1306603 | 2021-05-10 | Snohomish | Washington | 53061 | 37163 | 573 |
1303357 | 1303357 | 2021-05-09 | Snohomish | Washington | 53061 | 37023 | 571 |
1300110 | 1300110 | 2021-05-08 | Snohomish | Washington | 53061 | 37023 | 571 |
1296863 | 1296863 | 2021-05-07 | Snohomish | Washington | 53061 | 36843 | 571 |
1293617 | 1293617 | 2021-05-06 | Snohomish | Washington | 53061 | 36719 | 570 |
1290371 | 1290371 | 2021-05-05 | Snohomish | Washington | 53061 | 36622 | 569 |
1287125 | 1287125 | 2021-05-04 | Snohomish | Washington | 53061 | 36446 | 569 |
1283879 | 1283879 | 2021-05-03 | Snohomish | Washington | 53061 | 36303 | 568 |
1280632 | 1280632 | 2021-05-02 | Snohomish | Washington | 53061 | 36093 | 566 |
1277385 | 1277385 | 2021-05-01 | Snohomish | Washington | 53061 | 36093 | 566 |
1274138 | 1274138 | 2021-04-30 | Snohomish | Washington | 53061 | 35942 | 566 |
1270891 | 1270891 | 2021-04-29 | Snohomish | Washington | 53061 | 35792 | 567 |
1267644 | 1267644 | 2021-04-28 | Snohomish | Washington | 53061 | 35643 | 565 |
1264397 | 1264397 | 2021-04-27 | Snohomish | Washington | 53061 | 35482 | 564 |
1261150 | 1261150 | 2021-04-26 | Snohomish | Washington | 53061 | 35313 | 564 |
1257903 | 1257903 | 2021-04-25 | Snohomish | Washington | 53061 | 35132 | 563 |
1254656 | 1254656 | 2021-04-24 | Snohomish | Washington | 53061 | 35132 | 563 |
1251409 | 1251409 | 2021-04-23 | Snohomish | Washington | 53061 | 35019 | 563 |
1248162 | 1248162 | 2021-04-22 | Snohomish | Washington | 53061 | 34859 | 563 |
1244915 | 1244915 | 2021-04-21 | Snohomish | Washington | 53061 | 34718 | 563 |
1241668 | 1241668 | 2021-04-20 | Snohomish | Washington | 53061 | 34523 | 563 |
1238421 | 1238421 | 2021-04-19 | Snohomish | Washington | 53061 | 34336 | 563 |
1235174 | 1235174 | 2021-04-18 | Snohomish | Washington | 53061 | 34236 | 564 |
1231926 | 1231926 | 2021-04-17 | Snohomish | Washington | 53061 | 34236 | 564 |
1228678 | 1228678 | 2021-04-16 | Snohomish | Washington | 53061 | 34114 | 564 |
1225430 | 1225430 | 2021-04-15 | Snohomish | Washington | 53061 | 34114 | 564 |
1222183 | 1222183 | 2021-04-14 | Snohomish | Washington | 53061 | 34114 | 564 |
1218935 | 1218935 | 2021-04-13 | Snohomish | Washington | 53061 | 34114 | 564 |
1215687 | 1215687 | 2021-04-12 | Snohomish | Washington | 53061 | 34114 | 564 |
1212440 | 1212440 | 2021-04-11 | Snohomish | Washington | 53061 | 33277 | 563 |
1209191 | 1209191 | 2021-04-10 | Snohomish | Washington | 53061 | 33277 | 563 |
1205943 | 1205943 | 2021-04-09 | Snohomish | Washington | 53061 | 33271 | 563 |
1202695 | 1202695 | 2021-04-08 | Snohomish | Washington | 53061 | 33271 | 563 |
1199447 | 1199447 | 2021-04-07 | Snohomish | Washington | 53061 | 33271 | 563 |
1196198 | 1196198 | 2021-04-06 | Snohomish | Washington | 53061 | 33271 | 563 |
1192950 | 1192950 | 2021-04-05 | Snohomish | Washington | 53061 | 33271 | 563 |
1189700 | 1189700 | 2021-04-04 | Snohomish | Washington | 53061 | 32600 | 558 |
1186453 | 1186453 | 2021-04-03 | Snohomish | Washington | 53061 | 32600 | 558 |
1183206 | 1183206 | 2021-04-02 | Snohomish | Washington | 53061 | 32600 | 558 |
1179959 | 1179959 | 2021-04-01 | Snohomish | Washington | 53061 | 32600 | 558 |
1176712 | 1176712 | 2021-03-31 | Snohomish | Washington | 53061 | 32600 | 558 |
1173465 | 1173465 | 2021-03-30 | Snohomish | Washington | 53061 | 32600 | 558 |
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);