ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 40103 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1623893 | 1623893 | 2021-08-16 | Noble | Oklahoma | 40103 | 1496 | 21 |
1620646 | 1620646 | 2021-08-15 | Noble | Oklahoma | 40103 | 1496 | 21 |
1617398 | 1617398 | 2021-08-14 | Noble | Oklahoma | 40103 | 1496 | 21 |
1614150 | 1614150 | 2021-08-13 | Noble | Oklahoma | 40103 | 1496 | 21 |
1610901 | 1610901 | 2021-08-12 | Noble | Oklahoma | 40103 | 1496 | 21 |
1607653 | 1607653 | 2021-08-11 | Noble | Oklahoma | 40103 | 1496 | 21 |
1604404 | 1604404 | 2021-08-10 | Noble | Oklahoma | 40103 | 1448 | 20 |
1601155 | 1601155 | 2021-08-09 | Noble | Oklahoma | 40103 | 1448 | 20 |
1597907 | 1597907 | 2021-08-08 | Noble | Oklahoma | 40103 | 1448 | 20 |
1594658 | 1594658 | 2021-08-07 | Noble | Oklahoma | 40103 | 1448 | 20 |
1591409 | 1591409 | 2021-08-06 | Noble | Oklahoma | 40103 | 1448 | 20 |
1588160 | 1588160 | 2021-08-05 | Noble | Oklahoma | 40103 | 1448 | 20 |
1584910 | 1584910 | 2021-08-04 | Noble | Oklahoma | 40103 | 1448 | 20 |
1581660 | 1581660 | 2021-08-03 | Noble | Oklahoma | 40103 | 1424 | 20 |
1578411 | 1578411 | 2021-08-02 | Noble | Oklahoma | 40103 | 1424 | 20 |
1575163 | 1575163 | 2021-08-01 | Noble | Oklahoma | 40103 | 1424 | 20 |
1571915 | 1571915 | 2021-07-31 | Noble | Oklahoma | 40103 | 1424 | 20 |
1568667 | 1568667 | 2021-07-30 | Noble | Oklahoma | 40103 | 1424 | 20 |
1565419 | 1565419 | 2021-07-29 | Noble | Oklahoma | 40103 | 1424 | 20 |
1562171 | 1562171 | 2021-07-28 | Noble | Oklahoma | 40103 | 1424 | 20 |
1558923 | 1558923 | 2021-07-27 | Noble | Oklahoma | 40103 | 1399 | 20 |
1555676 | 1555676 | 2021-07-26 | Noble | Oklahoma | 40103 | 1399 | 20 |
1552429 | 1552429 | 2021-07-25 | Noble | Oklahoma | 40103 | 1399 | 20 |
1549182 | 1549182 | 2021-07-24 | Noble | Oklahoma | 40103 | 1399 | 20 |
1545935 | 1545935 | 2021-07-23 | Noble | Oklahoma | 40103 | 1399 | 20 |
1542688 | 1542688 | 2021-07-22 | Noble | Oklahoma | 40103 | 1399 | 20 |
1539440 | 1539440 | 2021-07-21 | Noble | Oklahoma | 40103 | 1399 | 20 |
1536193 | 1536193 | 2021-07-20 | Noble | Oklahoma | 40103 | 1385 | 20 |
1532945 | 1532945 | 2021-07-19 | Noble | Oklahoma | 40103 | 1385 | 20 |
1529698 | 1529698 | 2021-07-18 | Noble | Oklahoma | 40103 | 1385 | 20 |
1526451 | 1526451 | 2021-07-17 | Noble | Oklahoma | 40103 | 1385 | 20 |
1523204 | 1523204 | 2021-07-16 | Noble | Oklahoma | 40103 | 1385 | 20 |
1519956 | 1519956 | 2021-07-15 | Noble | Oklahoma | 40103 | 1385 | 20 |
1516708 | 1516708 | 2021-07-14 | Noble | Oklahoma | 40103 | 1385 | 20 |
1513461 | 1513461 | 2021-07-13 | Noble | Oklahoma | 40103 | 1384 | 20 |
1510215 | 1510215 | 2021-07-12 | Noble | Oklahoma | 40103 | 1384 | 20 |
1506968 | 1506968 | 2021-07-11 | Noble | Oklahoma | 40103 | 1384 | 20 |
1503722 | 1503722 | 2021-07-10 | Noble | Oklahoma | 40103 | 1384 | 20 |
1500476 | 1500476 | 2021-07-09 | Noble | Oklahoma | 40103 | 1384 | 20 |
1497230 | 1497230 | 2021-07-08 | Noble | Oklahoma | 40103 | 1384 | 20 |
1493983 | 1493983 | 2021-07-07 | Noble | Oklahoma | 40103 | 1384 | 20 |
1490736 | 1490736 | 2021-07-06 | Noble | Oklahoma | 40103 | 1383 | 20 |
1487489 | 1487489 | 2021-07-05 | Noble | Oklahoma | 40103 | 1383 | 20 |
1484242 | 1484242 | 2021-07-04 | Noble | Oklahoma | 40103 | 1383 | 20 |
1480996 | 1480996 | 2021-07-03 | Noble | Oklahoma | 40103 | 1383 | 20 |
1477749 | 1477749 | 2021-07-02 | Noble | Oklahoma | 40103 | 1383 | 20 |
1474503 | 1474503 | 2021-07-01 | Noble | Oklahoma | 40103 | 1383 | 20 |
1471257 | 1471257 | 2021-06-30 | Noble | Oklahoma | 40103 | 1383 | 20 |
1468012 | 1468012 | 2021-06-29 | Noble | Oklahoma | 40103 | 1380 | 20 |
1464767 | 1464767 | 2021-06-28 | Noble | Oklahoma | 40103 | 1380 | 20 |
1461522 | 1461522 | 2021-06-27 | Noble | Oklahoma | 40103 | 1380 | 20 |
1458277 | 1458277 | 2021-06-26 | Noble | Oklahoma | 40103 | 1380 | 20 |
1455032 | 1455032 | 2021-06-25 | Noble | Oklahoma | 40103 | 1380 | 20 |
1451787 | 1451787 | 2021-06-24 | Noble | Oklahoma | 40103 | 1380 | 20 |
1448541 | 1448541 | 2021-06-23 | Noble | Oklahoma | 40103 | 1380 | 20 |
1445296 | 1445296 | 2021-06-22 | Noble | Oklahoma | 40103 | 1380 | 20 |
1442051 | 1442051 | 2021-06-21 | Noble | Oklahoma | 40103 | 1380 | 20 |
1438806 | 1438806 | 2021-06-20 | Noble | Oklahoma | 40103 | 1380 | 20 |
1435559 | 1435559 | 2021-06-19 | Noble | Oklahoma | 40103 | 1380 | 20 |
1432312 | 1432312 | 2021-06-18 | Noble | Oklahoma | 40103 | 1380 | 20 |
1429066 | 1429066 | 2021-06-17 | Noble | Oklahoma | 40103 | 1380 | 20 |
1425821 | 1425821 | 2021-06-16 | Noble | Oklahoma | 40103 | 1380 | 20 |
1422574 | 1422574 | 2021-06-15 | Noble | Oklahoma | 40103 | 1380 | 20 |
1419328 | 1419328 | 2021-06-14 | Noble | Oklahoma | 40103 | 1380 | 20 |
1416083 | 1416083 | 2021-06-13 | Noble | Oklahoma | 40103 | 1380 | 20 |
1412837 | 1412837 | 2021-06-12 | Noble | Oklahoma | 40103 | 1380 | 20 |
1409592 | 1409592 | 2021-06-11 | Noble | Oklahoma | 40103 | 1380 | 20 |
1406347 | 1406347 | 2021-06-10 | Noble | Oklahoma | 40103 | 1380 | 20 |
1403101 | 1403101 | 2021-06-09 | Noble | Oklahoma | 40103 | 1380 | 20 |
1399856 | 1399856 | 2021-06-08 | Noble | Oklahoma | 40103 | 1380 | 20 |
1396611 | 1396611 | 2021-06-07 | Noble | Oklahoma | 40103 | 1380 | 20 |
1393364 | 1393364 | 2021-06-06 | Noble | Oklahoma | 40103 | 1380 | 20 |
1390119 | 1390119 | 2021-06-05 | Noble | Oklahoma | 40103 | 1380 | 20 |
1386874 | 1386874 | 2021-06-04 | Noble | Oklahoma | 40103 | 1380 | 20 |
1383629 | 1383629 | 2021-06-03 | Noble | Oklahoma | 40103 | 1380 | 20 |
1380383 | 1380383 | 2021-06-02 | Noble | Oklahoma | 40103 | 1380 | 20 |
1377138 | 1377138 | 2021-06-01 | Noble | Oklahoma | 40103 | 1380 | 20 |
1373892 | 1373892 | 2021-05-31 | Noble | Oklahoma | 40103 | 1380 | 20 |
1370647 | 1370647 | 2021-05-30 | Noble | Oklahoma | 40103 | 1380 | 20 |
1367401 | 1367401 | 2021-05-29 | Noble | Oklahoma | 40103 | 1380 | 20 |
1364155 | 1364155 | 2021-05-28 | Noble | Oklahoma | 40103 | 1380 | 20 |
1360909 | 1360909 | 2021-05-27 | Noble | Oklahoma | 40103 | 1380 | 20 |
1357663 | 1357663 | 2021-05-26 | Noble | Oklahoma | 40103 | 1380 | 20 |
1354417 | 1354417 | 2021-05-25 | Noble | Oklahoma | 40103 | 1380 | 19 |
1351171 | 1351171 | 2021-05-24 | Noble | Oklahoma | 40103 | 1380 | 19 |
1347925 | 1347925 | 2021-05-23 | Noble | Oklahoma | 40103 | 1380 | 19 |
1344677 | 1344677 | 2021-05-22 | Noble | Oklahoma | 40103 | 1380 | 19 |
1341429 | 1341429 | 2021-05-21 | Noble | Oklahoma | 40103 | 1380 | 19 |
1338181 | 1338181 | 2021-05-20 | Noble | Oklahoma | 40103 | 1380 | 19 |
1334934 | 1334934 | 2021-05-19 | Noble | Oklahoma | 40103 | 1380 | 19 |
1331687 | 1331687 | 2021-05-18 | Noble | Oklahoma | 40103 | 1380 | 19 |
1328440 | 1328440 | 2021-05-17 | Noble | Oklahoma | 40103 | 1380 | 19 |
1325194 | 1325194 | 2021-05-16 | Noble | Oklahoma | 40103 | 1380 | 19 |
1321948 | 1321948 | 2021-05-15 | Noble | Oklahoma | 40103 | 1380 | 19 |
1318702 | 1318702 | 2021-05-14 | Noble | Oklahoma | 40103 | 1380 | 19 |
1315454 | 1315454 | 2021-05-13 | Noble | Oklahoma | 40103 | 1380 | 19 |
1312208 | 1312208 | 2021-05-12 | Noble | Oklahoma | 40103 | 1380 | 19 |
1308961 | 1308961 | 2021-05-11 | Noble | Oklahoma | 40103 | 1379 | 19 |
1305715 | 1305715 | 2021-05-10 | Noble | Oklahoma | 40103 | 1379 | 19 |
1302469 | 1302469 | 2021-05-09 | Noble | Oklahoma | 40103 | 1379 | 19 |
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);