ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Comanche" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718058 | 1718058 | 2021-09-14 | Comanche | Oklahoma | 40031 | 18301 | 222 |
1714810 | 1714810 | 2021-09-13 | Comanche | Oklahoma | 40031 | 18301 | 222 |
1711564 | 1711564 | 2021-09-12 | Comanche | Oklahoma | 40031 | 18301 | 222 |
1708317 | 1708317 | 2021-09-11 | Comanche | Oklahoma | 40031 | 18301 | 222 |
1705070 | 1705070 | 2021-09-10 | Comanche | Oklahoma | 40031 | 18301 | 222 |
1701820 | 1701820 | 2021-09-09 | Comanche | Oklahoma | 40031 | 18301 | 222 |
1698571 | 1698571 | 2021-09-08 | Comanche | Oklahoma | 40031 | 18301 | 222 |
1695323 | 1695323 | 2021-09-07 | Comanche | Oklahoma | 40031 | 17645 | 213 |
1692075 | 1692075 | 2021-09-06 | Comanche | Oklahoma | 40031 | 17645 | 213 |
1688826 | 1688826 | 2021-09-05 | Comanche | Oklahoma | 40031 | 17645 | 213 |
1685576 | 1685576 | 2021-09-04 | Comanche | Oklahoma | 40031 | 17645 | 213 |
1682325 | 1682325 | 2021-09-03 | Comanche | Oklahoma | 40031 | 17645 | 213 |
1679075 | 1679075 | 2021-09-02 | Comanche | Oklahoma | 40031 | 17645 | 213 |
1675827 | 1675827 | 2021-09-01 | Comanche | Oklahoma | 40031 | 17645 | 213 |
1672580 | 1672580 | 2021-08-31 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1669332 | 1669332 | 2021-08-30 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1666085 | 1666085 | 2021-08-29 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1662837 | 1662837 | 2021-08-28 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1659589 | 1659589 | 2021-08-27 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1656340 | 1656340 | 2021-08-26 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1653093 | 1653093 | 2021-08-25 | Comanche | Oklahoma | 40031 | 17023 | 209 |
1649846 | 1649846 | 2021-08-24 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1646597 | 1646597 | 2021-08-23 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1643348 | 1643348 | 2021-08-22 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1640098 | 1640098 | 2021-08-21 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1636848 | 1636848 | 2021-08-20 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1633598 | 1633598 | 2021-08-19 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1630351 | 1630351 | 2021-08-18 | Comanche | Oklahoma | 40031 | 16580 | 206 |
1627104 | 1627104 | 2021-08-17 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1623857 | 1623857 | 2021-08-16 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1620610 | 1620610 | 2021-08-15 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1617362 | 1617362 | 2021-08-14 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1614114 | 1614114 | 2021-08-13 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1610865 | 1610865 | 2021-08-12 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1607617 | 1607617 | 2021-08-11 | Comanche | Oklahoma | 40031 | 16041 | 203 |
1604368 | 1604368 | 2021-08-10 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1601119 | 1601119 | 2021-08-09 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1597871 | 1597871 | 2021-08-08 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1594622 | 1594622 | 2021-08-07 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1591373 | 1591373 | 2021-08-06 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1588124 | 1588124 | 2021-08-05 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1584874 | 1584874 | 2021-08-04 | Comanche | Oklahoma | 40031 | 15563 | 203 |
1581624 | 1581624 | 2021-08-03 | Comanche | Oklahoma | 40031 | 15129 | 201 |
1578375 | 1578375 | 2021-08-02 | Comanche | Oklahoma | 40031 | 15129 | 201 |
1575127 | 1575127 | 2021-08-01 | Comanche | Oklahoma | 40031 | 15129 | 201 |
1571879 | 1571879 | 2021-07-31 | Comanche | Oklahoma | 40031 | 15129 | 201 |
1568631 | 1568631 | 2021-07-30 | Comanche | Oklahoma | 40031 | 15129 | 201 |
1565383 | 1565383 | 2021-07-29 | Comanche | Oklahoma | 40031 | 15129 | 201 |
1562135 | 1562135 | 2021-07-28 | Comanche | Oklahoma | 40031 | 15129 | 201 |
1558887 | 1558887 | 2021-07-27 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1555640 | 1555640 | 2021-07-26 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1552393 | 1552393 | 2021-07-25 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1549146 | 1549146 | 2021-07-24 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1545899 | 1545899 | 2021-07-23 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1542652 | 1542652 | 2021-07-22 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1539404 | 1539404 | 2021-07-21 | Comanche | Oklahoma | 40031 | 14832 | 201 |
1536157 | 1536157 | 2021-07-20 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1532909 | 1532909 | 2021-07-19 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1529662 | 1529662 | 2021-07-18 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1526415 | 1526415 | 2021-07-17 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1523168 | 1523168 | 2021-07-16 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1519920 | 1519920 | 2021-07-15 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1516672 | 1516672 | 2021-07-14 | Comanche | Oklahoma | 40031 | 14656 | 201 |
1513425 | 1513425 | 2021-07-13 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1510179 | 1510179 | 2021-07-12 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1506932 | 1506932 | 2021-07-11 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1503686 | 1503686 | 2021-07-10 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1500440 | 1500440 | 2021-07-09 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1497194 | 1497194 | 2021-07-08 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1493947 | 1493947 | 2021-07-07 | Comanche | Oklahoma | 40031 | 14548 | 201 |
1490700 | 1490700 | 2021-07-06 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1487453 | 1487453 | 2021-07-05 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1484206 | 1484206 | 2021-07-04 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1480960 | 1480960 | 2021-07-03 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1477713 | 1477713 | 2021-07-02 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1474467 | 1474467 | 2021-07-01 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1471221 | 1471221 | 2021-06-30 | Comanche | Oklahoma | 40031 | 14407 | 200 |
1467976 | 1467976 | 2021-06-29 | Comanche | Oklahoma | 40031 | 14260 | 200 |
1464731 | 1464731 | 2021-06-28 | Comanche | Oklahoma | 40031 | 14260 | 200 |
1461486 | 1461486 | 2021-06-27 | Comanche | Oklahoma | 40031 | 14260 | 200 |
1458241 | 1458241 | 2021-06-26 | Comanche | Oklahoma | 40031 | 14260 | 200 |
1454996 | 1454996 | 2021-06-25 | Comanche | Oklahoma | 40031 | 14260 | 200 |
1451751 | 1451751 | 2021-06-24 | Comanche | Oklahoma | 40031 | 14260 | 200 |
1448505 | 1448505 | 2021-06-23 | Comanche | Oklahoma | 40031 | 14260 | 200 |
1445260 | 1445260 | 2021-06-22 | Comanche | Oklahoma | 40031 | 14103 | 198 |
1442015 | 1442015 | 2021-06-21 | Comanche | Oklahoma | 40031 | 14103 | 198 |
1438770 | 1438770 | 2021-06-20 | Comanche | Oklahoma | 40031 | 14103 | 198 |
1435523 | 1435523 | 2021-06-19 | Comanche | Oklahoma | 40031 | 14103 | 198 |
1432276 | 1432276 | 2021-06-18 | Comanche | Oklahoma | 40031 | 14103 | 198 |
1429030 | 1429030 | 2021-06-17 | Comanche | Oklahoma | 40031 | 14103 | 198 |
1425785 | 1425785 | 2021-06-16 | Comanche | Oklahoma | 40031 | 14103 | 198 |
1422538 | 1422538 | 2021-06-15 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1419292 | 1419292 | 2021-06-14 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1416047 | 1416047 | 2021-06-13 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1412801 | 1412801 | 2021-06-12 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1409556 | 1409556 | 2021-06-11 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1406311 | 1406311 | 2021-06-10 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1403065 | 1403065 | 2021-06-09 | Comanche | Oklahoma | 40031 | 14017 | 195 |
1399820 | 1399820 | 2021-06-08 | Comanche | Oklahoma | 40031 | 13963 | 195 |
1396575 | 1396575 | 2021-06-07 | Comanche | Oklahoma | 40031 | 13963 | 195 |
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);