ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Clay" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278452 | 1278452 | 2021-05-02 | Clay | Kansas | 20027 | 826 | 29 |
1275205 | 1275205 | 2021-05-01 | Clay | Kansas | 20027 | 826 | 29 |
1271958 | 1271958 | 2021-04-30 | Clay | Kansas | 20027 | 826 | 29 |
1268711 | 1268711 | 2021-04-29 | Clay | Kansas | 20027 | 826 | 29 |
1265464 | 1265464 | 2021-04-28 | Clay | Kansas | 20027 | 826 | 29 |
1262217 | 1262217 | 2021-04-27 | Clay | Kansas | 20027 | 826 | 29 |
1258970 | 1258970 | 2021-04-26 | Clay | Kansas | 20027 | 826 | 29 |
1255723 | 1255723 | 2021-04-25 | Clay | Kansas | 20027 | 826 | 29 |
1252476 | 1252476 | 2021-04-24 | Clay | Kansas | 20027 | 826 | 29 |
1249229 | 1249229 | 2021-04-23 | Clay | Kansas | 20027 | 826 | 29 |
1245982 | 1245982 | 2021-04-22 | Clay | Kansas | 20027 | 826 | 29 |
1242735 | 1242735 | 2021-04-21 | Clay | Kansas | 20027 | 826 | 29 |
1239488 | 1239488 | 2021-04-20 | Clay | Kansas | 20027 | 826 | 29 |
1236241 | 1236241 | 2021-04-19 | Clay | Kansas | 20027 | 826 | 29 |
1232994 | 1232994 | 2021-04-18 | Clay | Kansas | 20027 | 826 | 29 |
1229745 | 1229745 | 2021-04-17 | Clay | Kansas | 20027 | 826 | 27 |
1226497 | 1226497 | 2021-04-16 | Clay | Kansas | 20027 | 826 | 27 |
1223250 | 1223250 | 2021-04-15 | Clay | Kansas | 20027 | 826 | 27 |
1220002 | 1220002 | 2021-04-14 | Clay | Kansas | 20027 | 826 | 27 |
1216754 | 1216754 | 2021-04-13 | Clay | Kansas | 20027 | 826 | 27 |
1213507 | 1213507 | 2021-04-12 | Clay | Kansas | 20027 | 826 | 27 |
1210259 | 1210259 | 2021-04-11 | Clay | Kansas | 20027 | 826 | 27 |
1207010 | 1207010 | 2021-04-10 | Clay | Kansas | 20027 | 826 | 27 |
1203762 | 1203762 | 2021-04-09 | Clay | Kansas | 20027 | 826 | 27 |
1200514 | 1200514 | 2021-04-08 | Clay | Kansas | 20027 | 826 | 27 |
1197265 | 1197265 | 2021-04-07 | Clay | Kansas | 20027 | 826 | 27 |
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 |
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);