ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Coffey" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418040 | 1418040 | 2021-06-14 | Coffey | Kansas | 20031 | 750 | 23 |
1414794 | 1414794 | 2021-06-13 | Coffey | Kansas | 20031 | 750 | 23 |
1411549 | 1411549 | 2021-06-12 | Coffey | Kansas | 20031 | 750 | 23 |
1408304 | 1408304 | 2021-06-11 | Coffey | Kansas | 20031 | 750 | 23 |
1405058 | 1405058 | 2021-06-10 | Coffey | Kansas | 20031 | 748 | 23 |
1401813 | 1401813 | 2021-06-09 | Coffey | Kansas | 20031 | 748 | 23 |
1398568 | 1398568 | 2021-06-08 | Coffey | Kansas | 20031 | 745 | 23 |
1395321 | 1395321 | 2021-06-07 | Coffey | Kansas | 20031 | 745 | 23 |
1392076 | 1392076 | 2021-06-06 | Coffey | Kansas | 20031 | 744 | 23 |
1388831 | 1388831 | 2021-06-05 | Coffey | Kansas | 20031 | 744 | 23 |
1385586 | 1385586 | 2021-06-04 | Coffey | Kansas | 20031 | 744 | 23 |
1382340 | 1382340 | 2021-06-03 | Coffey | Kansas | 20031 | 742 | 23 |
1379095 | 1379095 | 2021-06-02 | Coffey | Kansas | 20031 | 742 | 23 |
1375849 | 1375849 | 2021-06-01 | Coffey | Kansas | 20031 | 741 | 23 |
1372604 | 1372604 | 2021-05-31 | Coffey | Kansas | 20031 | 741 | 23 |
1369359 | 1369359 | 2021-05-30 | Coffey | Kansas | 20031 | 741 | 23 |
1366113 | 1366113 | 2021-05-29 | Coffey | Kansas | 20031 | 741 | 23 |
1362867 | 1362867 | 2021-05-28 | Coffey | Kansas | 20031 | 741 | 23 |
1359620 | 1359620 | 2021-05-27 | Coffey | Kansas | 20031 | 740 | 23 |
1356374 | 1356374 | 2021-05-26 | Coffey | Kansas | 20031 | 740 | 23 |
1353128 | 1353128 | 2021-05-25 | Coffey | Kansas | 20031 | 739 | 23 |
1349882 | 1349882 | 2021-05-24 | Coffey | Kansas | 20031 | 739 | 23 |
1346635 | 1346635 | 2021-05-23 | Coffey | Kansas | 20031 | 739 | 23 |
1343387 | 1343387 | 2021-05-22 | Coffey | Kansas | 20031 | 739 | 23 |
1340139 | 1340139 | 2021-05-21 | Coffey | Kansas | 20031 | 739 | 23 |
1336892 | 1336892 | 2021-05-20 | Coffey | Kansas | 20031 | 737 | 23 |
1333645 | 1333645 | 2021-05-19 | Coffey | Kansas | 20031 | 737 | 23 |
1330398 | 1330398 | 2021-05-18 | Coffey | Kansas | 20031 | 736 | 23 |
1327151 | 1327151 | 2021-05-17 | Coffey | Kansas | 20031 | 736 | 23 |
1323905 | 1323905 | 2021-05-16 | Coffey | Kansas | 20031 | 736 | 23 |
1320659 | 1320659 | 2021-05-15 | Coffey | Kansas | 20031 | 736 | 23 |
1317412 | 1317412 | 2021-05-14 | Coffey | Kansas | 20031 | 736 | 23 |
1314165 | 1314165 | 2021-05-13 | Coffey | Kansas | 20031 | 735 | 23 |
1310918 | 1310918 | 2021-05-12 | Coffey | Kansas | 20031 | 735 | 23 |
1307672 | 1307672 | 2021-05-11 | Coffey | Kansas | 20031 | 733 | 23 |
1304426 | 1304426 | 2021-05-10 | Coffey | Kansas | 20031 | 733 | 23 |
1301179 | 1301179 | 2021-05-09 | Coffey | Kansas | 20031 | 730 | 23 |
1297932 | 1297932 | 2021-05-08 | Coffey | Kansas | 20031 | 730 | 23 |
1294686 | 1294686 | 2021-05-07 | Coffey | Kansas | 20031 | 730 | 23 |
1291440 | 1291440 | 2021-05-06 | Coffey | Kansas | 20031 | 729 | 23 |
1288194 | 1288194 | 2021-05-05 | Coffey | Kansas | 20031 | 729 | 23 |
1284948 | 1284948 | 2021-05-04 | Coffey | Kansas | 20031 | 728 | 23 |
1281701 | 1281701 | 2021-05-03 | Coffey | Kansas | 20031 | 728 | 23 |
1278454 | 1278454 | 2021-05-02 | Coffey | Kansas | 20031 | 726 | 23 |
1275207 | 1275207 | 2021-05-01 | Coffey | Kansas | 20031 | 726 | 23 |
1271960 | 1271960 | 2021-04-30 | Coffey | Kansas | 20031 | 726 | 23 |
1268713 | 1268713 | 2021-04-29 | Coffey | Kansas | 20031 | 724 | 23 |
1265466 | 1265466 | 2021-04-28 | Coffey | Kansas | 20031 | 724 | 23 |
1262219 | 1262219 | 2021-04-27 | Coffey | Kansas | 20031 | 723 | 23 |
1258972 | 1258972 | 2021-04-26 | Coffey | Kansas | 20031 | 723 | 23 |
1255725 | 1255725 | 2021-04-25 | Coffey | Kansas | 20031 | 722 | 23 |
1252478 | 1252478 | 2021-04-24 | Coffey | Kansas | 20031 | 722 | 23 |
1249231 | 1249231 | 2021-04-23 | Coffey | Kansas | 20031 | 722 | 23 |
1245984 | 1245984 | 2021-04-22 | Coffey | Kansas | 20031 | 722 | 23 |
1242737 | 1242737 | 2021-04-21 | Coffey | Kansas | 20031 | 722 | 23 |
1239490 | 1239490 | 2021-04-20 | Coffey | Kansas | 20031 | 722 | 23 |
1236243 | 1236243 | 2021-04-19 | Coffey | Kansas | 20031 | 722 | 23 |
1232996 | 1232996 | 2021-04-18 | Coffey | Kansas | 20031 | 723 | 23 |
1229747 | 1229747 | 2021-04-17 | Coffey | Kansas | 20031 | 723 | 14 |
1226499 | 1226499 | 2021-04-16 | Coffey | Kansas | 20031 | 723 | 14 |
1223252 | 1223252 | 2021-04-15 | Coffey | Kansas | 20031 | 723 | 14 |
1220004 | 1220004 | 2021-04-14 | Coffey | Kansas | 20031 | 723 | 14 |
1216756 | 1216756 | 2021-04-13 | Coffey | Kansas | 20031 | 724 | 14 |
1213509 | 1213509 | 2021-04-12 | Coffey | Kansas | 20031 | 724 | 14 |
1210261 | 1210261 | 2021-04-11 | Coffey | Kansas | 20031 | 723 | 14 |
1207012 | 1207012 | 2021-04-10 | Coffey | Kansas | 20031 | 723 | 14 |
1203764 | 1203764 | 2021-04-09 | Coffey | Kansas | 20031 | 723 | 14 |
1200516 | 1200516 | 2021-04-08 | Coffey | Kansas | 20031 | 723 | 14 |
1197267 | 1197267 | 2021-04-07 | Coffey | Kansas | 20031 | 723 | 14 |
1194019 | 1194019 | 2021-04-06 | Coffey | Kansas | 20031 | 723 | 14 |
1190769 | 1190769 | 2021-04-05 | Coffey | Kansas | 20031 | 723 | 14 |
1187522 | 1187522 | 2021-04-04 | Coffey | Kansas | 20031 | 723 | 14 |
1184275 | 1184275 | 2021-04-03 | Coffey | Kansas | 20031 | 723 | 14 |
1181028 | 1181028 | 2021-04-02 | Coffey | Kansas | 20031 | 723 | 14 |
1177781 | 1177781 | 2021-04-01 | Coffey | Kansas | 20031 | 723 | 14 |
1174534 | 1174534 | 2021-03-31 | Coffey | Kansas | 20031 | 723 | 14 |
1171287 | 1171287 | 2021-03-30 | Coffey | Kansas | 20031 | 722 | 14 |
1168039 | 1168039 | 2021-03-29 | Coffey | Kansas | 20031 | 722 | 14 |
1164791 | 1164791 | 2021-03-28 | Coffey | Kansas | 20031 | 721 | 14 |
1161543 | 1161543 | 2021-03-27 | Coffey | Kansas | 20031 | 721 | 14 |
1158295 | 1158295 | 2021-03-26 | Coffey | Kansas | 20031 | 721 | 14 |
1155048 | 1155048 | 2021-03-25 | Coffey | Kansas | 20031 | 721 | 14 |
1151801 | 1151801 | 2021-03-24 | Coffey | Kansas | 20031 | 721 | 14 |
1148554 | 1148554 | 2021-03-23 | Coffey | Kansas | 20031 | 721 | 14 |
1145307 | 1145307 | 2021-03-22 | Coffey | Kansas | 20031 | 721 | 14 |
1142060 | 1142060 | 2021-03-21 | Coffey | Kansas | 20031 | 721 | 14 |
1138814 | 1138814 | 2021-03-20 | Coffey | Kansas | 20031 | 721 | 14 |
1135568 | 1135568 | 2021-03-19 | Coffey | Kansas | 20031 | 721 | 14 |
1132321 | 1132321 | 2021-03-18 | Coffey | Kansas | 20031 | 722 | 14 |
1129073 | 1129073 | 2021-03-17 | Coffey | Kansas | 20031 | 722 | 14 |
1125827 | 1125827 | 2021-03-16 | Coffey | Kansas | 20031 | 717 | 14 |
1122581 | 1122581 | 2021-03-15 | Coffey | Kansas | 20031 | 717 | 14 |
1119334 | 1119334 | 2021-03-14 | Coffey | Kansas | 20031 | 715 | 14 |
1116087 | 1116087 | 2021-03-13 | Coffey | Kansas | 20031 | 715 | 14 |
1112841 | 1112841 | 2021-03-12 | Coffey | Kansas | 20031 | 715 | 14 |
1109595 | 1109595 | 2021-03-11 | Coffey | Kansas | 20031 | 714 | 14 |
1106349 | 1106349 | 2021-03-10 | Coffey | Kansas | 20031 | 714 | 14 |
1103103 | 1103103 | 2021-03-09 | Coffey | Kansas | 20031 | 712 | 14 |
1099857 | 1099857 | 2021-03-08 | Coffey | Kansas | 20031 | 712 | 14 |
1096609 | 1096609 | 2021-03-07 | Coffey | Kansas | 20031 | 712 | 14 |
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);