ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Clay" and fips = 20027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194017 | 1194017 | 2021-04-06 | Clay | Kansas | 20027 | 826 | 27 |
1190767 | 1190767 | 2021-04-05 | Clay | Kansas | 20027 | 826 | 27 |
1187520 | 1187520 | 2021-04-04 | Clay | Kansas | 20027 | 826 | 27 |
1184273 | 1184273 | 2021-04-03 | Clay | Kansas | 20027 | 826 | 27 |
1181026 | 1181026 | 2021-04-02 | Clay | Kansas | 20027 | 826 | 27 |
1177779 | 1177779 | 2021-04-01 | Clay | Kansas | 20027 | 826 | 27 |
1174532 | 1174532 | 2021-03-31 | Clay | Kansas | 20027 | 826 | 27 |
1171285 | 1171285 | 2021-03-30 | Clay | Kansas | 20027 | 826 | 27 |
1168037 | 1168037 | 2021-03-29 | Clay | Kansas | 20027 | 826 | 27 |
1164789 | 1164789 | 2021-03-28 | Clay | Kansas | 20027 | 826 | 27 |
1161541 | 1161541 | 2021-03-27 | Clay | Kansas | 20027 | 826 | 27 |
1158293 | 1158293 | 2021-03-26 | Clay | Kansas | 20027 | 826 | 27 |
1155046 | 1155046 | 2021-03-25 | Clay | Kansas | 20027 | 826 | 27 |
1151799 | 1151799 | 2021-03-24 | Clay | Kansas | 20027 | 826 | 27 |
1148552 | 1148552 | 2021-03-23 | Clay | Kansas | 20027 | 826 | 27 |
1145305 | 1145305 | 2021-03-22 | Clay | Kansas | 20027 | 826 | 27 |
1142058 | 1142058 | 2021-03-21 | Clay | Kansas | 20027 | 826 | 27 |
1138812 | 1138812 | 2021-03-20 | Clay | Kansas | 20027 | 826 | 27 |
1135566 | 1135566 | 2021-03-19 | Clay | Kansas | 20027 | 826 | 27 |
1132319 | 1132319 | 2021-03-18 | Clay | Kansas | 20027 | 826 | 27 |
1129071 | 1129071 | 2021-03-17 | Clay | Kansas | 20027 | 826 | 27 |
1125825 | 1125825 | 2021-03-16 | Clay | Kansas | 20027 | 826 | 27 |
1122579 | 1122579 | 2021-03-15 | Clay | Kansas | 20027 | 826 | 27 |
1119332 | 1119332 | 2021-03-14 | Clay | Kansas | 20027 | 826 | 27 |
1116085 | 1116085 | 2021-03-13 | Clay | Kansas | 20027 | 826 | 27 |
1112839 | 1112839 | 2021-03-12 | Clay | Kansas | 20027 | 826 | 27 |
1109593 | 1109593 | 2021-03-11 | Clay | Kansas | 20027 | 824 | 27 |
1106347 | 1106347 | 2021-03-10 | Clay | Kansas | 20027 | 824 | 27 |
1103101 | 1103101 | 2021-03-09 | Clay | Kansas | 20027 | 824 | 27 |
1099855 | 1099855 | 2021-03-08 | Clay | Kansas | 20027 | 824 | 27 |
1096607 | 1096607 | 2021-03-07 | Clay | Kansas | 20027 | 824 | 27 |
1093361 | 1093361 | 2021-03-06 | Clay | Kansas | 20027 | 824 | 27 |
1090115 | 1090115 | 2021-03-05 | Clay | Kansas | 20027 | 824 | 27 |
1086870 | 1086870 | 2021-03-04 | Clay | Kansas | 20027 | 822 | 27 |
1083624 | 1083624 | 2021-03-03 | Clay | Kansas | 20027 | 822 | 27 |
1080378 | 1080378 | 2021-03-02 | Clay | Kansas | 20027 | 818 | 27 |
1077133 | 1077133 | 2021-03-01 | Clay | Kansas | 20027 | 818 | 27 |
1073887 | 1073887 | 2021-02-28 | Clay | Kansas | 20027 | 818 | 27 |
1070641 | 1070641 | 2021-02-27 | Clay | Kansas | 20027 | 818 | 27 |
1067396 | 1067396 | 2021-02-26 | Clay | Kansas | 20027 | 818 | 27 |
1064151 | 1064151 | 2021-02-25 | Clay | Kansas | 20027 | 818 | 24 |
1060906 | 1060906 | 2021-02-24 | Clay | Kansas | 20027 | 818 | 24 |
1057660 | 1057660 | 2021-02-23 | Clay | Kansas | 20027 | 818 | 24 |
1054414 | 1054414 | 2021-02-22 | Clay | Kansas | 20027 | 818 | 24 |
1051167 | 1051167 | 2021-02-21 | Clay | Kansas | 20027 | 817 | 24 |
1047920 | 1047920 | 2021-02-20 | Clay | Kansas | 20027 | 817 | 24 |
1044675 | 1044675 | 2021-02-19 | Clay | Kansas | 20027 | 773 | 24 |
1041430 | 1041430 | 2021-02-18 | Clay | Kansas | 20027 | 816 | 24 |
1038185 | 1038185 | 2021-02-17 | Clay | Kansas | 20027 | 816 | 24 |
1034940 | 1034940 | 2021-02-16 | Clay | Kansas | 20027 | 816 | 23 |
1031694 | 1031694 | 2021-02-15 | Clay | Kansas | 20027 | 816 | 23 |
1028447 | 1028447 | 2021-02-14 | Clay | Kansas | 20027 | 816 | 23 |
1025202 | 1025202 | 2021-02-13 | Clay | Kansas | 20027 | 816 | 23 |
1021957 | 1021957 | 2021-02-12 | Clay | Kansas | 20027 | 816 | 23 |
1018712 | 1018712 | 2021-02-11 | Clay | Kansas | 20027 | 811 | 23 |
1015467 | 1015467 | 2021-02-10 | Clay | Kansas | 20027 | 811 | 23 |
1012222 | 1012222 | 2021-02-09 | Clay | Kansas | 20027 | 811 | 23 |
1008976 | 1008976 | 2021-02-08 | Clay | Kansas | 20027 | 811 | 23 |
1005730 | 1005730 | 2021-02-07 | Clay | Kansas | 20027 | 811 | 23 |
1002484 | 1002484 | 2021-02-06 | Clay | Kansas | 20027 | 811 | 23 |
999238 | 999238 | 2021-02-05 | Clay | Kansas | 20027 | 811 | 23 |
995992 | 995992 | 2021-02-04 | Clay | Kansas | 20027 | 787 | 22 |
992746 | 992746 | 2021-02-03 | Clay | Kansas | 20027 | 787 | 22 |
989500 | 989500 | 2021-02-02 | Clay | Kansas | 20027 | 787 | 22 |
986253 | 986253 | 2021-02-01 | Clay | Kansas | 20027 | 787 | 22 |
983006 | 983006 | 2021-01-31 | Clay | Kansas | 20027 | 787 | 22 |
979760 | 979760 | 2021-01-30 | Clay | Kansas | 20027 | 787 | 22 |
976514 | 976514 | 2021-01-29 | Clay | Kansas | 20027 | 787 | 22 |
973269 | 973269 | 2021-01-28 | Clay | Kansas | 20027 | 760 | 22 |
970024 | 970024 | 2021-01-27 | Clay | Kansas | 20027 | 760 | 22 |
966780 | 966780 | 2021-01-26 | Clay | Kansas | 20027 | 760 | 22 |
963535 | 963535 | 2021-01-25 | Clay | Kansas | 20027 | 760 | 22 |
960290 | 960290 | 2021-01-24 | Clay | Kansas | 20027 | 760 | 22 |
957044 | 957044 | 2021-01-23 | Clay | Kansas | 20027 | 760 | 22 |
953799 | 953799 | 2021-01-22 | Clay | Kansas | 20027 | 760 | 22 |
950554 | 950554 | 2021-01-21 | Clay | Kansas | 20027 | 746 | 21 |
947308 | 947308 | 2021-01-20 | Clay | Kansas | 20027 | 746 | 21 |
944061 | 944061 | 2021-01-19 | Clay | Kansas | 20027 | 746 | 21 |
940816 | 940816 | 2021-01-18 | Clay | Kansas | 20027 | 746 | 21 |
937571 | 937571 | 2021-01-17 | Clay | Kansas | 20027 | 746 | 21 |
934326 | 934326 | 2021-01-16 | Clay | Kansas | 20027 | 746 | 21 |
931081 | 931081 | 2021-01-15 | Clay | Kansas | 20027 | 716 | 17 |
927836 | 927836 | 2021-01-14 | Clay | Kansas | 20027 | 716 | 17 |
924590 | 924590 | 2021-01-13 | Clay | Kansas | 20027 | 716 | 17 |
921345 | 921345 | 2021-01-12 | Clay | Kansas | 20027 | 680 | 17 |
918100 | 918100 | 2021-01-11 | Clay | Kansas | 20027 | 680 | 17 |
914855 | 914855 | 2021-01-10 | Clay | Kansas | 20027 | 677 | 17 |
911610 | 911610 | 2021-01-09 | Clay | Kansas | 20027 | 677 | 17 |
908365 | 908365 | 2021-01-08 | Clay | Kansas | 20027 | 677 | 17 |
905119 | 905119 | 2021-01-07 | Clay | Kansas | 20027 | 677 | 17 |
901874 | 901874 | 2021-01-06 | Clay | Kansas | 20027 | 653 | 17 |
898629 | 898629 | 2021-01-05 | Clay | Kansas | 20027 | 629 | 17 |
895384 | 895384 | 2021-01-04 | Clay | Kansas | 20027 | 629 | 17 |
892137 | 892137 | 2021-01-03 | Clay | Kansas | 20027 | 622 | 17 |
888891 | 888891 | 2021-01-02 | Clay | Kansas | 20027 | 622 | 17 |
885645 | 885645 | 2021-01-01 | Clay | Kansas | 20027 | 622 | 17 |
882400 | 882400 | 2020-12-31 | Clay | Kansas | 20027 | 611 | 17 |
879155 | 879155 | 2020-12-30 | Clay | Kansas | 20027 | 611 | 17 |
875910 | 875910 | 2020-12-29 | Clay | Kansas | 20027 | 587 | 17 |
872665 | 872665 | 2020-12-28 | Clay | Kansas | 20027 | 587 | 17 |
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);