ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where deaths = 13, fips = 8121 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1677215 | 1677215 | 2021-09-02 | Washington | Colorado | 8121 | 487 | 13 |
1673968 | 1673968 | 2021-09-01 | Washington | Colorado | 8121 | 487 | 13 |
1670720 | 1670720 | 2021-08-31 | Washington | Colorado | 8121 | 487 | 13 |
1667473 | 1667473 | 2021-08-30 | Washington | Colorado | 8121 | 485 | 13 |
1664226 | 1664226 | 2021-08-29 | Washington | Colorado | 8121 | 485 | 13 |
1660978 | 1660978 | 2021-08-28 | Washington | Colorado | 8121 | 485 | 13 |
1657730 | 1657730 | 2021-08-27 | Washington | Colorado | 8121 | 485 | 13 |
1654482 | 1654482 | 2021-08-26 | Washington | Colorado | 8121 | 484 | 13 |
1651235 | 1651235 | 2021-08-25 | Washington | Colorado | 8121 | 483 | 13 |
1647986 | 1647986 | 2021-08-24 | Washington | Colorado | 8121 | 483 | 13 |
1644738 | 1644738 | 2021-08-23 | Washington | Colorado | 8121 | 483 | 13 |
1641488 | 1641488 | 2021-08-22 | Washington | Colorado | 8121 | 482 | 13 |
1638238 | 1638238 | 2021-08-21 | Washington | Colorado | 8121 | 482 | 13 |
1634988 | 1634988 | 2021-08-20 | Washington | Colorado | 8121 | 482 | 13 |
1631739 | 1631739 | 2021-08-19 | Washington | Colorado | 8121 | 481 | 13 |
1628492 | 1628492 | 2021-08-18 | Washington | Colorado | 8121 | 481 | 13 |
1625245 | 1625245 | 2021-08-17 | Washington | Colorado | 8121 | 481 | 13 |
1621998 | 1621998 | 2021-08-16 | Washington | Colorado | 8121 | 481 | 13 |
1618751 | 1618751 | 2021-08-15 | Washington | Colorado | 8121 | 480 | 13 |
1615503 | 1615503 | 2021-08-14 | Washington | Colorado | 8121 | 480 | 13 |
1612254 | 1612254 | 2021-08-13 | Washington | Colorado | 8121 | 480 | 13 |
1609006 | 1609006 | 2021-08-12 | Washington | Colorado | 8121 | 479 | 13 |
1605757 | 1605757 | 2021-08-11 | Washington | Colorado | 8121 | 479 | 13 |
1602508 | 1602508 | 2021-08-10 | Washington | Colorado | 8121 | 479 | 13 |
1599259 | 1599259 | 2021-08-09 | Washington | Colorado | 8121 | 479 | 13 |
1596010 | 1596010 | 2021-08-08 | Washington | Colorado | 8121 | 478 | 13 |
1592761 | 1592761 | 2021-08-07 | Washington | Colorado | 8121 | 478 | 13 |
1589512 | 1589512 | 2021-08-06 | Washington | Colorado | 8121 | 478 | 13 |
1586263 | 1586263 | 2021-08-05 | Washington | Colorado | 8121 | 478 | 13 |
1583013 | 1583013 | 2021-08-04 | Washington | Colorado | 8121 | 477 | 13 |
1579763 | 1579763 | 2021-08-03 | Washington | Colorado | 8121 | 477 | 13 |
1576515 | 1576515 | 2021-08-02 | Washington | Colorado | 8121 | 477 | 13 |
1573267 | 1573267 | 2021-08-01 | Washington | Colorado | 8121 | 477 | 13 |
1570019 | 1570019 | 2021-07-31 | Washington | Colorado | 8121 | 477 | 13 |
1566771 | 1566771 | 2021-07-30 | Washington | Colorado | 8121 | 477 | 13 |
1563523 | 1563523 | 2021-07-29 | Washington | Colorado | 8121 | 477 | 13 |
1560275 | 1560275 | 2021-07-28 | Washington | Colorado | 8121 | 477 | 13 |
1557028 | 1557028 | 2021-07-27 | Washington | Colorado | 8121 | 477 | 13 |
1553781 | 1553781 | 2021-07-26 | Washington | Colorado | 8121 | 477 | 13 |
1550534 | 1550534 | 2021-07-25 | Washington | Colorado | 8121 | 477 | 13 |
1547287 | 1547287 | 2021-07-24 | Washington | Colorado | 8121 | 477 | 13 |
1544040 | 1544040 | 2021-07-23 | Washington | Colorado | 8121 | 477 | 13 |
1540792 | 1540792 | 2021-07-22 | Washington | Colorado | 8121 | 477 | 13 |
1537545 | 1537545 | 2021-07-21 | Washington | Colorado | 8121 | 476 | 13 |
1534297 | 1534297 | 2021-07-20 | Washington | Colorado | 8121 | 475 | 13 |
1531050 | 1531050 | 2021-07-19 | Washington | Colorado | 8121 | 475 | 13 |
1527803 | 1527803 | 2021-07-18 | Washington | Colorado | 8121 | 474 | 13 |
1524556 | 1524556 | 2021-07-17 | Washington | Colorado | 8121 | 474 | 13 |
1521308 | 1521308 | 2021-07-16 | Washington | Colorado | 8121 | 474 | 13 |
1518060 | 1518060 | 2021-07-15 | Washington | Colorado | 8121 | 474 | 13 |
1514813 | 1514813 | 2021-07-14 | Washington | Colorado | 8121 | 474 | 13 |
1511567 | 1511567 | 2021-07-13 | Washington | Colorado | 8121 | 474 | 13 |
1508320 | 1508320 | 2021-07-12 | Washington | Colorado | 8121 | 474 | 13 |
1505074 | 1505074 | 2021-07-11 | Washington | Colorado | 8121 | 474 | 13 |
1501828 | 1501828 | 2021-07-10 | Washington | Colorado | 8121 | 474 | 13 |
1498582 | 1498582 | 2021-07-09 | Washington | Colorado | 8121 | 474 | 13 |
1495335 | 1495335 | 2021-07-08 | Washington | Colorado | 8121 | 474 | 13 |
1492089 | 1492089 | 2021-07-07 | Washington | Colorado | 8121 | 474 | 13 |
1488842 | 1488842 | 2021-07-06 | Washington | Colorado | 8121 | 474 | 13 |
1485595 | 1485595 | 2021-07-05 | Washington | Colorado | 8121 | 474 | 13 |
1482349 | 1482349 | 2021-07-04 | Washington | Colorado | 8121 | 474 | 13 |
1479102 | 1479102 | 2021-07-03 | Washington | Colorado | 8121 | 474 | 13 |
1475856 | 1475856 | 2021-07-02 | Washington | Colorado | 8121 | 474 | 13 |
1472610 | 1472610 | 2021-07-01 | Washington | Colorado | 8121 | 473 | 13 |
1469364 | 1469364 | 2021-06-30 | Washington | Colorado | 8121 | 473 | 13 |
1466119 | 1466119 | 2021-06-29 | Washington | Colorado | 8121 | 473 | 13 |
1462874 | 1462874 | 2021-06-28 | Washington | Colorado | 8121 | 474 | 13 |
1459629 | 1459629 | 2021-06-27 | Washington | Colorado | 8121 | 473 | 13 |
1456384 | 1456384 | 2021-06-26 | Washington | Colorado | 8121 | 473 | 13 |
1453139 | 1453139 | 2021-06-25 | Washington | Colorado | 8121 | 474 | 13 |
1449893 | 1449893 | 2021-06-24 | Washington | Colorado | 8121 | 474 | 13 |
1446648 | 1446648 | 2021-06-23 | Washington | Colorado | 8121 | 474 | 13 |
1443403 | 1443403 | 2021-06-22 | Washington | Colorado | 8121 | 474 | 13 |
1440158 | 1440158 | 2021-06-21 | Washington | Colorado | 8121 | 473 | 13 |
1436911 | 1436911 | 2021-06-20 | Washington | Colorado | 8121 | 473 | 13 |
1433664 | 1433664 | 2021-06-19 | Washington | Colorado | 8121 | 473 | 13 |
1430418 | 1430418 | 2021-06-18 | Washington | Colorado | 8121 | 473 | 13 |
1427173 | 1427173 | 2021-06-17 | Washington | Colorado | 8121 | 472 | 13 |
1423928 | 1423928 | 2021-06-16 | Washington | Colorado | 8121 | 472 | 13 |
1420680 | 1420680 | 2021-06-15 | Washington | Colorado | 8121 | 472 | 13 |
1417435 | 1417435 | 2021-06-14 | Washington | Colorado | 8121 | 471 | 13 |
1414189 | 1414189 | 2021-06-13 | Washington | Colorado | 8121 | 471 | 13 |
1410944 | 1410944 | 2021-06-12 | Washington | Colorado | 8121 | 471 | 13 |
1407699 | 1407699 | 2021-06-11 | Washington | Colorado | 8121 | 471 | 13 |
1404453 | 1404453 | 2021-06-10 | Washington | Colorado | 8121 | 470 | 13 |
1401208 | 1401208 | 2021-06-09 | Washington | Colorado | 8121 | 469 | 13 |
1397963 | 1397963 | 2021-06-08 | Washington | Colorado | 8121 | 469 | 13 |
1394716 | 1394716 | 2021-06-07 | Washington | Colorado | 8121 | 468 | 13 |
1391471 | 1391471 | 2021-06-06 | Washington | Colorado | 8121 | 468 | 13 |
1388226 | 1388226 | 2021-06-05 | Washington | Colorado | 8121 | 468 | 13 |
1384981 | 1384981 | 2021-06-04 | Washington | Colorado | 8121 | 468 | 13 |
1381735 | 1381735 | 2021-06-03 | Washington | Colorado | 8121 | 467 | 13 |
1378490 | 1378490 | 2021-06-02 | Washington | Colorado | 8121 | 466 | 13 |
1375244 | 1375244 | 2021-06-01 | Washington | Colorado | 8121 | 463 | 13 |
1371999 | 1371999 | 2021-05-31 | Washington | Colorado | 8121 | 463 | 13 |
1368754 | 1368754 | 2021-05-30 | Washington | Colorado | 8121 | 463 | 13 |
1365508 | 1365508 | 2021-05-29 | Washington | Colorado | 8121 | 463 | 13 |
1362262 | 1362262 | 2021-05-28 | Washington | Colorado | 8121 | 463 | 13 |
1359015 | 1359015 | 2021-05-27 | Washington | Colorado | 8121 | 463 | 13 |
1355769 | 1355769 | 2021-05-26 | Washington | Colorado | 8121 | 463 | 13 |
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);