ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 20133 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194070 | 1194070 | 2021-04-06 | Neosho | Kansas | 20133 | 1777 | 22 |
1190820 | 1190820 | 2021-04-05 | Neosho | Kansas | 20133 | 1777 | 22 |
1187573 | 1187573 | 2021-04-04 | Neosho | Kansas | 20133 | 1773 | 22 |
1184326 | 1184326 | 2021-04-03 | Neosho | Kansas | 20133 | 1773 | 22 |
1181079 | 1181079 | 2021-04-02 | Neosho | Kansas | 20133 | 1773 | 22 |
1177832 | 1177832 | 2021-04-01 | Neosho | Kansas | 20133 | 1771 | 22 |
1174585 | 1174585 | 2021-03-31 | Neosho | Kansas | 20133 | 1771 | 22 |
1171338 | 1171338 | 2021-03-30 | Neosho | Kansas | 20133 | 1771 | 22 |
1168090 | 1168090 | 2021-03-29 | Neosho | Kansas | 20133 | 1771 | 22 |
1164842 | 1164842 | 2021-03-28 | Neosho | Kansas | 20133 | 1769 | 22 |
1161594 | 1161594 | 2021-03-27 | Neosho | Kansas | 20133 | 1769 | 22 |
1158346 | 1158346 | 2021-03-26 | Neosho | Kansas | 20133 | 1769 | 22 |
1155099 | 1155099 | 2021-03-25 | Neosho | Kansas | 20133 | 1761 | 22 |
1151852 | 1151852 | 2021-03-24 | Neosho | Kansas | 20133 | 1761 | 22 |
1148605 | 1148605 | 2021-03-23 | Neosho | Kansas | 20133 | 1751 | 22 |
1145358 | 1145358 | 2021-03-22 | Neosho | Kansas | 20133 | 1751 | 22 |
1142111 | 1142111 | 2021-03-21 | Neosho | Kansas | 20133 | 1748 | 22 |
1138865 | 1138865 | 2021-03-20 | Neosho | Kansas | 20133 | 1748 | 22 |
1135619 | 1135619 | 2021-03-19 | Neosho | Kansas | 20133 | 1748 | 22 |
1132372 | 1132372 | 2021-03-18 | Neosho | Kansas | 20133 | 1743 | 22 |
1129124 | 1129124 | 2021-03-17 | Neosho | Kansas | 20133 | 1743 | 22 |
1125878 | 1125878 | 2021-03-16 | Neosho | Kansas | 20133 | 1741 | 22 |
1122632 | 1122632 | 2021-03-15 | Neosho | Kansas | 20133 | 1741 | 22 |
1119385 | 1119385 | 2021-03-14 | Neosho | Kansas | 20133 | 1743 | 22 |
1116138 | 1116138 | 2021-03-13 | Neosho | Kansas | 20133 | 1743 | 22 |
1112892 | 1112892 | 2021-03-12 | Neosho | Kansas | 20133 | 1743 | 22 |
1109646 | 1109646 | 2021-03-11 | Neosho | Kansas | 20133 | 1765 | 22 |
1106400 | 1106400 | 2021-03-10 | Neosho | Kansas | 20133 | 1765 | 22 |
1103154 | 1103154 | 2021-03-09 | Neosho | Kansas | 20133 | 1766 | 22 |
1099908 | 1099908 | 2021-03-08 | Neosho | Kansas | 20133 | 1766 | 22 |
1096660 | 1096660 | 2021-03-07 | Neosho | Kansas | 20133 | 1761 | 22 |
1093414 | 1093414 | 2021-03-06 | Neosho | Kansas | 20133 | 1761 | 22 |
1090168 | 1090168 | 2021-03-05 | Neosho | Kansas | 20133 | 1761 | 22 |
1086923 | 1086923 | 2021-03-04 | Neosho | Kansas | 20133 | 1753 | 22 |
1083677 | 1083677 | 2021-03-03 | Neosho | Kansas | 20133 | 1753 | 22 |
1080431 | 1080431 | 2021-03-02 | Neosho | Kansas | 20133 | 1739 | 18 |
1077186 | 1077186 | 2021-03-01 | Neosho | Kansas | 20133 | 1739 | 18 |
1073940 | 1073940 | 2021-02-28 | Neosho | Kansas | 20133 | 1740 | 18 |
1070694 | 1070694 | 2021-02-27 | Neosho | Kansas | 20133 | 1740 | 18 |
1067449 | 1067449 | 2021-02-26 | Neosho | Kansas | 20133 | 1740 | 18 |
1064204 | 1064204 | 2021-02-25 | Neosho | Kansas | 20133 | 1731 | 18 |
1060959 | 1060959 | 2021-02-24 | Neosho | Kansas | 20133 | 1731 | 18 |
1057713 | 1057713 | 2021-02-23 | Neosho | Kansas | 20133 | 1720 | 18 |
1054467 | 1054467 | 2021-02-22 | Neosho | Kansas | 20133 | 1720 | 18 |
1051220 | 1051220 | 2021-02-21 | Neosho | Kansas | 20133 | 1708 | 18 |
1047973 | 1047973 | 2021-02-20 | Neosho | Kansas | 20133 | 1708 | 18 |
1044728 | 1044728 | 2021-02-19 | Neosho | Kansas | 20133 | 1708 | 18 |
1041483 | 1041483 | 2021-02-18 | Neosho | Kansas | 20133 | 1696 | 18 |
1038238 | 1038238 | 2021-02-17 | Neosho | Kansas | 20133 | 1696 | 18 |
1034993 | 1034993 | 2021-02-16 | Neosho | Kansas | 20133 | 1689 | 18 |
1031747 | 1031747 | 2021-02-15 | Neosho | Kansas | 20133 | 1689 | 18 |
1028500 | 1028500 | 2021-02-14 | Neosho | Kansas | 20133 | 1682 | 18 |
1025255 | 1025255 | 2021-02-13 | Neosho | Kansas | 20133 | 1682 | 18 |
1022010 | 1022010 | 2021-02-12 | Neosho | Kansas | 20133 | 1682 | 18 |
1018765 | 1018765 | 2021-02-11 | Neosho | Kansas | 20133 | 1678 | 18 |
1015520 | 1015520 | 2021-02-10 | Neosho | Kansas | 20133 | 1678 | 18 |
1012275 | 1012275 | 2021-02-09 | Neosho | Kansas | 20133 | 1661 | 18 |
1009029 | 1009029 | 2021-02-08 | Neosho | Kansas | 20133 | 1661 | 18 |
1005783 | 1005783 | 2021-02-07 | Neosho | Kansas | 20133 | 1647 | 18 |
1002537 | 1002537 | 2021-02-06 | Neosho | Kansas | 20133 | 1647 | 18 |
999291 | 999291 | 2021-02-05 | Neosho | Kansas | 20133 | 1647 | 18 |
996045 | 996045 | 2021-02-04 | Neosho | Kansas | 20133 | 1625 | 18 |
992799 | 992799 | 2021-02-03 | Neosho | Kansas | 20133 | 1625 | 18 |
989553 | 989553 | 2021-02-02 | Neosho | Kansas | 20133 | 1604 | 18 |
986306 | 986306 | 2021-02-01 | Neosho | Kansas | 20133 | 1604 | 18 |
983059 | 983059 | 2021-01-31 | Neosho | Kansas | 20133 | 1590 | 18 |
979813 | 979813 | 2021-01-30 | Neosho | Kansas | 20133 | 1590 | 18 |
976567 | 976567 | 2021-01-29 | Neosho | Kansas | 20133 | 1590 | 18 |
973322 | 973322 | 2021-01-28 | Neosho | Kansas | 20133 | 1576 | 18 |
970077 | 970077 | 2021-01-27 | Neosho | Kansas | 20133 | 1576 | 18 |
966833 | 966833 | 2021-01-26 | Neosho | Kansas | 20133 | 1560 | 17 |
963588 | 963588 | 2021-01-25 | Neosho | Kansas | 20133 | 1560 | 17 |
960343 | 960343 | 2021-01-24 | Neosho | Kansas | 20133 | 1553 | 17 |
957097 | 957097 | 2021-01-23 | Neosho | Kansas | 20133 | 1553 | 17 |
953852 | 953852 | 2021-01-22 | Neosho | Kansas | 20133 | 1553 | 17 |
950607 | 950607 | 2021-01-21 | Neosho | Kansas | 20133 | 1536 | 17 |
947361 | 947361 | 2021-01-20 | Neosho | Kansas | 20133 | 1536 | 17 |
944114 | 944114 | 2021-01-19 | Neosho | Kansas | 20133 | 1516 | 17 |
940869 | 940869 | 2021-01-18 | Neosho | Kansas | 20133 | 1516 | 16 |
937624 | 937624 | 2021-01-17 | Neosho | Kansas | 20133 | 1497 | 16 |
934379 | 934379 | 2021-01-16 | Neosho | Kansas | 20133 | 1497 | 16 |
931134 | 931134 | 2021-01-15 | Neosho | Kansas | 20133 | 1497 | 16 |
927889 | 927889 | 2021-01-14 | Neosho | Kansas | 20133 | 1467 | 16 |
924643 | 924643 | 2021-01-13 | Neosho | Kansas | 20133 | 1467 | 16 |
921398 | 921398 | 2021-01-12 | Neosho | Kansas | 20133 | 1436 | 16 |
918153 | 918153 | 2021-01-11 | Neosho | Kansas | 20133 | 1436 | 14 |
914908 | 914908 | 2021-01-10 | Neosho | Kansas | 20133 | 1406 | 14 |
911663 | 911663 | 2021-01-09 | Neosho | Kansas | 20133 | 1406 | 14 |
908418 | 908418 | 2021-01-08 | Neosho | Kansas | 20133 | 1406 | 14 |
905172 | 905172 | 2021-01-07 | Neosho | Kansas | 20133 | 1356 | 14 |
901927 | 901927 | 2021-01-06 | Neosho | Kansas | 20133 | 1356 | 14 |
898682 | 898682 | 2021-01-05 | Neosho | Kansas | 20133 | 1288 | 14 |
895437 | 895437 | 2021-01-04 | Neosho | Kansas | 20133 | 1288 | 14 |
892190 | 892190 | 2021-01-03 | Neosho | Kansas | 20133 | 1229 | 14 |
888944 | 888944 | 2021-01-02 | Neosho | Kansas | 20133 | 1229 | 14 |
885698 | 885698 | 2021-01-01 | Neosho | Kansas | 20133 | 1229 | 14 |
882453 | 882453 | 2020-12-31 | Neosho | Kansas | 20133 | 1192 | 12 |
879208 | 879208 | 2020-12-30 | Neosho | Kansas | 20133 | 1192 | 12 |
875963 | 875963 | 2020-12-29 | Neosho | Kansas | 20133 | 1180 | 12 |
872718 | 872718 | 2020-12-28 | Neosho | Kansas | 20133 | 1131 | 11 |
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);