ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
806 rows where fips = 53033 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1520830 | 1520830 | 2021-07-15 | King | Washington | 53033 | 114099 | 1683 |
1517582 | 1517582 | 2021-07-14 | King | Washington | 53033 | 113955 | 1682 |
1514335 | 1514335 | 2021-07-13 | King | Washington | 53033 | 113784 | 1680 |
1511089 | 1511089 | 2021-07-12 | King | Washington | 53033 | 113660 | 1674 |
1507842 | 1507842 | 2021-07-11 | King | Washington | 53033 | 113296 | 1674 |
1504596 | 1504596 | 2021-07-10 | King | Washington | 53033 | 113296 | 1674 |
1501350 | 1501350 | 2021-07-09 | King | Washington | 53033 | 113296 | 1674 |
1498104 | 1498104 | 2021-07-08 | King | Washington | 53033 | 113207 | 1673 |
1494857 | 1494857 | 2021-07-07 | King | Washington | 53033 | 113092 | 1672 |
1491610 | 1491610 | 2021-07-06 | King | Washington | 53033 | 112996 | 1666 |
1488363 | 1488363 | 2021-07-05 | King | Washington | 53033 | 112751 | 1666 |
1485116 | 1485116 | 2021-07-04 | King | Washington | 53033 | 112751 | 1666 |
1481870 | 1481870 | 2021-07-03 | King | Washington | 53033 | 112751 | 1666 |
1478623 | 1478623 | 2021-07-02 | King | Washington | 53033 | 112751 | 1666 |
1475377 | 1475377 | 2021-07-01 | King | Washington | 53033 | 112672 | 1665 |
1472131 | 1472131 | 2021-06-30 | King | Washington | 53033 | 112567 | 1664 |
1468886 | 1468886 | 2021-06-29 | King | Washington | 53033 | 112516 | 1659 |
1465641 | 1465641 | 2021-06-28 | King | Washington | 53033 | 112482 | 1659 |
1462396 | 1462396 | 2021-06-27 | King | Washington | 53033 | 112443 | 1659 |
1459151 | 1459151 | 2021-06-26 | King | Washington | 53033 | 112380 | 1659 |
1455906 | 1455906 | 2021-06-25 | King | Washington | 53033 | 112293 | 1660 |
1452661 | 1452661 | 2021-06-24 | King | Washington | 53033 | 112250 | 1654 |
1449415 | 1449415 | 2021-06-23 | King | Washington | 53033 | 112166 | 1652 |
1446170 | 1446170 | 2021-06-22 | King | Washington | 53033 | 111759 | 1620 |
1442925 | 1442925 | 2021-06-21 | King | Washington | 53033 | 111708 | 1618 |
1439680 | 1439680 | 2021-06-20 | King | Washington | 53033 | 111648 | 1618 |
1436433 | 1436433 | 2021-06-19 | King | Washington | 53033 | 111586 | 1618 |
1433186 | 1433186 | 2021-06-18 | King | Washington | 53033 | 111511 | 1614 |
1429940 | 1429940 | 2021-06-17 | King | Washington | 53033 | 111427 | 1613 |
1426695 | 1426695 | 2021-06-16 | King | Washington | 53033 | 111353 | 1618 |
1423449 | 1423449 | 2021-06-15 | King | Washington | 53033 | 111242 | 1619 |
1420202 | 1420202 | 2021-06-14 | King | Washington | 53033 | 111166 | 1617 |
1416957 | 1416957 | 2021-06-13 | King | Washington | 53033 | 111108 | 1617 |
1413711 | 1413711 | 2021-06-12 | King | Washington | 53033 | 111051 | 1616 |
1410466 | 1410466 | 2021-06-11 | King | Washington | 53033 | 110939 | 1616 |
1407221 | 1407221 | 2021-06-10 | King | Washington | 53033 | 110871 | 1613 |
1403975 | 1403975 | 2021-06-09 | King | Washington | 53033 | 110719 | 1606 |
1400730 | 1400730 | 2021-06-08 | King | Washington | 53033 | 110567 | 1597 |
1397485 | 1397485 | 2021-06-07 | King | Washington | 53033 | 110419 | 1591 |
1394238 | 1394238 | 2021-06-06 | King | Washington | 53033 | 110340 | 1595 |
1390993 | 1390993 | 2021-06-05 | King | Washington | 53033 | 110260 | 1595 |
1387748 | 1387748 | 2021-06-04 | King | Washington | 53033 | 110119 | 1595 |
1384503 | 1384503 | 2021-06-03 | King | Washington | 53033 | 109997 | 1593 |
1381257 | 1381257 | 2021-06-02 | King | Washington | 53033 | 109859 | 1590 |
1378012 | 1378012 | 2021-06-01 | King | Washington | 53033 | 109759 | 1587 |
1374766 | 1374766 | 2021-05-31 | King | Washington | 53033 | 109531 | 1579 |
1371521 | 1371521 | 2021-05-30 | King | Washington | 53033 | 109531 | 1579 |
1368275 | 1368275 | 2021-05-29 | King | Washington | 53033 | 109531 | 1579 |
1365029 | 1365029 | 2021-05-28 | King | Washington | 53033 | 109360 | 1579 |
1361783 | 1361783 | 2021-05-27 | King | Washington | 53033 | 109159 | 1576 |
1358537 | 1358537 | 2021-05-26 | King | Washington | 53033 | 108916 | 1571 |
1355291 | 1355291 | 2021-05-25 | King | Washington | 53033 | 108616 | 1567 |
1352045 | 1352045 | 2021-05-24 | King | Washington | 53033 | 108510 | 1564 |
1348799 | 1348799 | 2021-05-23 | King | Washington | 53033 | 108122 | 1561 |
1345551 | 1345551 | 2021-05-22 | King | Washington | 53033 | 108122 | 1561 |
1342303 | 1342303 | 2021-05-21 | King | Washington | 53033 | 108122 | 1561 |
1339055 | 1339055 | 2021-05-20 | King | Washington | 53033 | 107847 | 1557 |
1335808 | 1335808 | 2021-05-19 | King | Washington | 53033 | 107634 | 1556 |
1332561 | 1332561 | 2021-05-18 | King | Washington | 53033 | 107464 | 1552 |
1329314 | 1329314 | 2021-05-17 | King | Washington | 53033 | 107368 | 1548 |
1326068 | 1326068 | 2021-05-16 | King | Washington | 53033 | 107149 | 1542 |
1322822 | 1322822 | 2021-05-15 | King | Washington | 53033 | 107149 | 1542 |
1319576 | 1319576 | 2021-05-14 | King | Washington | 53033 | 106942 | 1542 |
1316328 | 1316328 | 2021-05-13 | King | Washington | 53033 | 106277 | 1546 |
1313082 | 1313082 | 2021-05-12 | King | Washington | 53033 | 105969 | 1543 |
1309835 | 1309835 | 2021-05-11 | King | Washington | 53033 | 105692 | 1540 |
1306589 | 1306589 | 2021-05-10 | King | Washington | 53033 | 105425 | 1537 |
1303343 | 1303343 | 2021-05-09 | King | Washington | 53033 | 104965 | 1534 |
1300096 | 1300096 | 2021-05-08 | King | Washington | 53033 | 104965 | 1534 |
1296849 | 1296849 | 2021-05-07 | King | Washington | 53033 | 104575 | 1534 |
1293603 | 1293603 | 2021-05-06 | King | Washington | 53033 | 104211 | 1529 |
1290357 | 1290357 | 2021-05-05 | King | Washington | 53033 | 103865 | 1526 |
1287111 | 1287111 | 2021-05-04 | King | Washington | 53033 | 103353 | 1526 |
1283865 | 1283865 | 2021-05-03 | King | Washington | 53033 | 103119 | 1519 |
1280618 | 1280618 | 2021-05-02 | King | Washington | 53033 | 102351 | 1517 |
1277371 | 1277371 | 2021-05-01 | King | Washington | 53033 | 102351 | 1517 |
1274124 | 1274124 | 2021-04-30 | King | Washington | 53033 | 101885 | 1517 |
1270877 | 1270877 | 2021-04-29 | King | Washington | 53033 | 101483 | 1515 |
1267630 | 1267630 | 2021-04-28 | King | Washington | 53033 | 100955 | 1514 |
1264383 | 1264383 | 2021-04-27 | King | Washington | 53033 | 100479 | 1509 |
1261136 | 1261136 | 2021-04-26 | King | Washington | 53033 | 100278 | 1507 |
1257889 | 1257889 | 2021-04-25 | King | Washington | 53033 | 99553 | 1506 |
1254642 | 1254642 | 2021-04-24 | King | Washington | 53033 | 99553 | 1506 |
1251395 | 1251395 | 2021-04-23 | King | Washington | 53033 | 99087 | 1506 |
1248148 | 1248148 | 2021-04-22 | King | Washington | 53033 | 98629 | 1506 |
1244901 | 1244901 | 2021-04-21 | King | Washington | 53033 | 98161 | 1505 |
1241654 | 1241654 | 2021-04-20 | King | Washington | 53033 | 97714 | 1503 |
1238407 | 1238407 | 2021-04-19 | King | Washington | 53033 | 97232 | 1500 |
1235160 | 1235160 | 2021-04-18 | King | Washington | 53033 | 96810 | 1496 |
1231912 | 1231912 | 2021-04-17 | King | Washington | 53033 | 96810 | 1496 |
1228664 | 1228664 | 2021-04-16 | King | Washington | 53033 | 96337 | 1496 |
1225416 | 1225416 | 2021-04-15 | King | Washington | 53033 | 95784 | 1493 |
1222169 | 1222169 | 2021-04-14 | King | Washington | 53033 | 95349 | 1492 |
1218921 | 1218921 | 2021-04-13 | King | Washington | 53033 | 95003 | 1489 |
1215673 | 1215673 | 2021-04-12 | King | Washington | 53033 | 94777 | 1485 |
1212426 | 1212426 | 2021-04-11 | King | Washington | 53033 | 94134 | 1484 |
1209177 | 1209177 | 2021-04-10 | King | Washington | 53033 | 94134 | 1484 |
1205929 | 1205929 | 2021-04-09 | King | Washington | 53033 | 93762 | 1484 |
1202681 | 1202681 | 2021-04-08 | King | Washington | 53033 | 93326 | 1483 |
1199433 | 1199433 | 2021-04-07 | King | Washington | 53033 | 93004 | 1480 |
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);