ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Sedgwick" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1622674 | 1622674 | 2021-08-16 | Sedgwick | Kansas | 20173 | 62988 | 825 |
1619427 | 1619427 | 2021-08-15 | Sedgwick | Kansas | 20173 | 62589 | 825 |
1616179 | 1616179 | 2021-08-14 | Sedgwick | Kansas | 20173 | 62589 | 825 |
1612930 | 1612930 | 2021-08-13 | Sedgwick | Kansas | 20173 | 62589 | 825 |
1609682 | 1609682 | 2021-08-12 | Sedgwick | Kansas | 20173 | 62046 | 821 |
1606433 | 1606433 | 2021-08-11 | Sedgwick | Kansas | 20173 | 62046 | 821 |
1603184 | 1603184 | 2021-08-10 | Sedgwick | Kansas | 20173 | 61624 | 818 |
1599935 | 1599935 | 2021-08-09 | Sedgwick | Kansas | 20173 | 61624 | 818 |
1596687 | 1596687 | 2021-08-08 | Sedgwick | Kansas | 20173 | 60963 | 813 |
1593438 | 1593438 | 2021-08-07 | Sedgwick | Kansas | 20173 | 60963 | 813 |
1590189 | 1590189 | 2021-08-06 | Sedgwick | Kansas | 20173 | 60963 | 813 |
1586940 | 1586940 | 2021-08-05 | Sedgwick | Kansas | 20173 | 60608 | 811 |
1583690 | 1583690 | 2021-08-04 | Sedgwick | Kansas | 20173 | 60608 | 811 |
1580440 | 1580440 | 2021-08-03 | Sedgwick | Kansas | 20173 | 60200 | 811 |
1577191 | 1577191 | 2021-08-02 | Sedgwick | Kansas | 20173 | 60200 | 811 |
1573943 | 1573943 | 2021-08-01 | Sedgwick | Kansas | 20173 | 59910 | 810 |
1570695 | 1570695 | 2021-07-31 | Sedgwick | Kansas | 20173 | 59910 | 810 |
1567447 | 1567447 | 2021-07-30 | Sedgwick | Kansas | 20173 | 59910 | 810 |
1564199 | 1564199 | 2021-07-29 | Sedgwick | Kansas | 20173 | 59650 | 810 |
1560951 | 1560951 | 2021-07-28 | Sedgwick | Kansas | 20173 | 59650 | 810 |
1557704 | 1557704 | 2021-07-27 | Sedgwick | Kansas | 20173 | 59410 | 810 |
1554457 | 1554457 | 2021-07-26 | Sedgwick | Kansas | 20173 | 59410 | 810 |
1551210 | 1551210 | 2021-07-25 | Sedgwick | Kansas | 20173 | 59200 | 810 |
1547963 | 1547963 | 2021-07-24 | Sedgwick | Kansas | 20173 | 59200 | 810 |
1544716 | 1544716 | 2021-07-23 | Sedgwick | Kansas | 20173 | 59200 | 810 |
1541468 | 1541468 | 2021-07-22 | Sedgwick | Kansas | 20173 | 58979 | 801 |
1538221 | 1538221 | 2021-07-21 | Sedgwick | Kansas | 20173 | 58979 | 801 |
1534973 | 1534973 | 2021-07-20 | Sedgwick | Kansas | 20173 | 58778 | 801 |
1531726 | 1531726 | 2021-07-19 | Sedgwick | Kansas | 20173 | 58778 | 801 |
1528479 | 1528479 | 2021-07-18 | Sedgwick | Kansas | 20173 | 58654 | 801 |
1525232 | 1525232 | 2021-07-17 | Sedgwick | Kansas | 20173 | 58654 | 801 |
1521984 | 1521984 | 2021-07-16 | Sedgwick | Kansas | 20173 | 58654 | 801 |
1518736 | 1518736 | 2021-07-15 | Sedgwick | Kansas | 20173 | 58381 | 800 |
1515489 | 1515489 | 2021-07-14 | Sedgwick | Kansas | 20173 | 58381 | 800 |
1512243 | 1512243 | 2021-07-13 | Sedgwick | Kansas | 20173 | 58381 | 800 |
1508996 | 1508996 | 2021-07-12 | Sedgwick | Kansas | 20173 | 58381 | 800 |
1505750 | 1505750 | 2021-07-11 | Sedgwick | Kansas | 20173 | 58294 | 794 |
1502504 | 1502504 | 2021-07-10 | Sedgwick | Kansas | 20173 | 58294 | 794 |
1499258 | 1499258 | 2021-07-09 | Sedgwick | Kansas | 20173 | 58294 | 794 |
1496011 | 1496011 | 2021-07-08 | Sedgwick | Kansas | 20173 | 58195 | 793 |
1492765 | 1492765 | 2021-07-07 | Sedgwick | Kansas | 20173 | 58195 | 793 |
1489518 | 1489518 | 2021-07-06 | Sedgwick | Kansas | 20173 | 58092 | 792 |
1486271 | 1486271 | 2021-07-05 | Sedgwick | Kansas | 20173 | 58092 | 792 |
1483025 | 1483025 | 2021-07-04 | Sedgwick | Kansas | 20173 | 58092 | 792 |
1479778 | 1479778 | 2021-07-03 | Sedgwick | Kansas | 20173 | 58092 | 792 |
1476532 | 1476532 | 2021-07-02 | Sedgwick | Kansas | 20173 | 58092 | 792 |
1473286 | 1473286 | 2021-07-01 | Sedgwick | Kansas | 20173 | 58027 | 791 |
1470040 | 1470040 | 2021-06-30 | Sedgwick | Kansas | 20173 | 58027 | 791 |
1466795 | 1466795 | 2021-06-29 | Sedgwick | Kansas | 20173 | 57953 | 788 |
1463550 | 1463550 | 2021-06-28 | Sedgwick | Kansas | 20173 | 57953 | 788 |
1460305 | 1460305 | 2021-06-27 | Sedgwick | Kansas | 20173 | 57902 | 788 |
1457060 | 1457060 | 2021-06-26 | Sedgwick | Kansas | 20173 | 57902 | 788 |
1453815 | 1453815 | 2021-06-25 | Sedgwick | Kansas | 20173 | 57902 | 788 |
1450569 | 1450569 | 2021-06-24 | Sedgwick | Kansas | 20173 | 57856 | 786 |
1447324 | 1447324 | 2021-06-23 | Sedgwick | Kansas | 20173 | 57856 | 786 |
1444079 | 1444079 | 2021-06-22 | Sedgwick | Kansas | 20173 | 57780 | 783 |
1440834 | 1440834 | 2021-06-21 | Sedgwick | Kansas | 20173 | 57780 | 783 |
1437587 | 1437587 | 2021-06-20 | Sedgwick | Kansas | 20173 | 57732 | 783 |
1434340 | 1434340 | 2021-06-19 | Sedgwick | Kansas | 20173 | 57732 | 783 |
1431094 | 1431094 | 2021-06-18 | Sedgwick | Kansas | 20173 | 57732 | 783 |
1427849 | 1427849 | 2021-06-17 | Sedgwick | Kansas | 20173 | 57688 | 783 |
1424604 | 1424604 | 2021-06-16 | Sedgwick | Kansas | 20173 | 57688 | 783 |
1421356 | 1421356 | 2021-06-15 | Sedgwick | Kansas | 20173 | 57633 | 783 |
1418111 | 1418111 | 2021-06-14 | Sedgwick | Kansas | 20173 | 57633 | 783 |
1414865 | 1414865 | 2021-06-13 | Sedgwick | Kansas | 20173 | 57550 | 775 |
1411620 | 1411620 | 2021-06-12 | Sedgwick | Kansas | 20173 | 57550 | 775 |
1408375 | 1408375 | 2021-06-11 | Sedgwick | Kansas | 20173 | 57550 | 775 |
1405129 | 1405129 | 2021-06-10 | Sedgwick | Kansas | 20173 | 57512 | 775 |
1401884 | 1401884 | 2021-06-09 | Sedgwick | Kansas | 20173 | 57512 | 775 |
1398639 | 1398639 | 2021-06-08 | Sedgwick | Kansas | 20173 | 57457 | 775 |
1395392 | 1395392 | 2021-06-07 | Sedgwick | Kansas | 20173 | 57457 | 775 |
1392147 | 1392147 | 2021-06-06 | Sedgwick | Kansas | 20173 | 57417 | 768 |
1388902 | 1388902 | 2021-06-05 | Sedgwick | Kansas | 20173 | 57417 | 768 |
1385657 | 1385657 | 2021-06-04 | Sedgwick | Kansas | 20173 | 57417 | 768 |
1382411 | 1382411 | 2021-06-03 | Sedgwick | Kansas | 20173 | 57376 | 767 |
1379166 | 1379166 | 2021-06-02 | Sedgwick | Kansas | 20173 | 57376 | 767 |
1375920 | 1375920 | 2021-06-01 | Sedgwick | Kansas | 20173 | 57272 | 767 |
1372675 | 1372675 | 2021-05-31 | Sedgwick | Kansas | 20173 | 57272 | 767 |
1369430 | 1369430 | 2021-05-30 | Sedgwick | Kansas | 20173 | 57272 | 767 |
1366184 | 1366184 | 2021-05-29 | Sedgwick | Kansas | 20173 | 57272 | 767 |
1362938 | 1362938 | 2021-05-28 | Sedgwick | Kansas | 20173 | 57272 | 767 |
1359691 | 1359691 | 2021-05-27 | Sedgwick | Kansas | 20173 | 57226 | 761 |
1356445 | 1356445 | 2021-05-26 | Sedgwick | Kansas | 20173 | 57226 | 761 |
1353199 | 1353199 | 2021-05-25 | Sedgwick | Kansas | 20173 | 57127 | 759 |
1349953 | 1349953 | 2021-05-24 | Sedgwick | Kansas | 20173 | 57127 | 759 |
1346706 | 1346706 | 2021-05-23 | Sedgwick | Kansas | 20173 | 57079 | 759 |
1343458 | 1343458 | 2021-05-22 | Sedgwick | Kansas | 20173 | 57079 | 759 |
1340210 | 1340210 | 2021-05-21 | Sedgwick | Kansas | 20173 | 57079 | 759 |
1336963 | 1336963 | 2021-05-20 | Sedgwick | Kansas | 20173 | 56960 | 759 |
1333716 | 1333716 | 2021-05-19 | Sedgwick | Kansas | 20173 | 56960 | 759 |
1330469 | 1330469 | 2021-05-18 | Sedgwick | Kansas | 20173 | 56838 | 756 |
1327222 | 1327222 | 2021-05-17 | Sedgwick | Kansas | 20173 | 56838 | 756 |
1323976 | 1323976 | 2021-05-16 | Sedgwick | Kansas | 20173 | 56770 | 756 |
1320730 | 1320730 | 2021-05-15 | Sedgwick | Kansas | 20173 | 56770 | 756 |
1317483 | 1317483 | 2021-05-14 | Sedgwick | Kansas | 20173 | 56770 | 756 |
1314236 | 1314236 | 2021-05-13 | Sedgwick | Kansas | 20173 | 56676 | 753 |
1310989 | 1310989 | 2021-05-12 | Sedgwick | Kansas | 20173 | 56676 | 753 |
1307743 | 1307743 | 2021-05-11 | Sedgwick | Kansas | 20173 | 56588 | 753 |
1304497 | 1304497 | 2021-05-10 | Sedgwick | Kansas | 20173 | 56588 | 753 |
1301250 | 1301250 | 2021-05-09 | Sedgwick | Kansas | 20173 | 56475 | 753 |
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);