ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where county = "Clark", deaths = 4 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1229744 | 1229744 | 2021-04-17 | Clark | Kansas | 20025 | 248 | 4 |
1226496 | 1226496 | 2021-04-16 | Clark | Kansas | 20025 | 248 | 4 |
1223249 | 1223249 | 2021-04-15 | Clark | Kansas | 20025 | 248 | 4 |
1220001 | 1220001 | 2021-04-14 | Clark | Kansas | 20025 | 248 | 4 |
1216753 | 1216753 | 2021-04-13 | Clark | Kansas | 20025 | 248 | 4 |
1213506 | 1213506 | 2021-04-12 | Clark | Kansas | 20025 | 248 | 4 |
1210258 | 1210258 | 2021-04-11 | Clark | Kansas | 20025 | 247 | 4 |
1207009 | 1207009 | 2021-04-10 | Clark | Kansas | 20025 | 247 | 4 |
1203761 | 1203761 | 2021-04-09 | Clark | Kansas | 20025 | 247 | 4 |
1200513 | 1200513 | 2021-04-08 | Clark | Kansas | 20025 | 247 | 4 |
1197264 | 1197264 | 2021-04-07 | Clark | Kansas | 20025 | 247 | 4 |
1194016 | 1194016 | 2021-04-06 | Clark | Kansas | 20025 | 247 | 4 |
1190766 | 1190766 | 2021-04-05 | Clark | Kansas | 20025 | 247 | 4 |
1187519 | 1187519 | 2021-04-04 | Clark | Kansas | 20025 | 247 | 4 |
1184272 | 1184272 | 2021-04-03 | Clark | Kansas | 20025 | 247 | 4 |
1181025 | 1181025 | 2021-04-02 | Clark | Kansas | 20025 | 247 | 4 |
1177778 | 1177778 | 2021-04-01 | Clark | Kansas | 20025 | 247 | 4 |
1174531 | 1174531 | 2021-03-31 | Clark | Kansas | 20025 | 247 | 4 |
1171284 | 1171284 | 2021-03-30 | Clark | Kansas | 20025 | 247 | 4 |
1168036 | 1168036 | 2021-03-29 | Clark | Kansas | 20025 | 247 | 4 |
1164788 | 1164788 | 2021-03-28 | Clark | Kansas | 20025 | 247 | 4 |
1161540 | 1161540 | 2021-03-27 | Clark | Kansas | 20025 | 247 | 4 |
1158292 | 1158292 | 2021-03-26 | Clark | Kansas | 20025 | 247 | 4 |
1155045 | 1155045 | 2021-03-25 | Clark | Kansas | 20025 | 247 | 4 |
1151798 | 1151798 | 2021-03-24 | Clark | Kansas | 20025 | 247 | 4 |
1148551 | 1148551 | 2021-03-23 | Clark | Kansas | 20025 | 247 | 4 |
1145304 | 1145304 | 2021-03-22 | Clark | Kansas | 20025 | 247 | 4 |
1142057 | 1142057 | 2021-03-21 | Clark | Kansas | 20025 | 247 | 4 |
1138811 | 1138811 | 2021-03-20 | Clark | Kansas | 20025 | 247 | 4 |
1135565 | 1135565 | 2021-03-19 | Clark | Kansas | 20025 | 247 | 4 |
1132318 | 1132318 | 2021-03-18 | Clark | Kansas | 20025 | 244 | 4 |
1129070 | 1129070 | 2021-03-17 | Clark | Kansas | 20025 | 244 | 4 |
1125824 | 1125824 | 2021-03-16 | Clark | Kansas | 20025 | 245 | 4 |
1122578 | 1122578 | 2021-03-15 | Clark | Kansas | 20025 | 245 | 4 |
1119331 | 1119331 | 2021-03-14 | Clark | Kansas | 20025 | 244 | 4 |
1116084 | 1116084 | 2021-03-13 | Clark | Kansas | 20025 | 244 | 4 |
1112838 | 1112838 | 2021-03-12 | Clark | Kansas | 20025 | 244 | 4 |
1109592 | 1109592 | 2021-03-11 | Clark | Kansas | 20025 | 244 | 4 |
1106346 | 1106346 | 2021-03-10 | Clark | Kansas | 20025 | 244 | 4 |
1103100 | 1103100 | 2021-03-09 | Clark | Kansas | 20025 | 244 | 4 |
1099854 | 1099854 | 2021-03-08 | Clark | Kansas | 20025 | 244 | 4 |
1096606 | 1096606 | 2021-03-07 | Clark | Kansas | 20025 | 244 | 4 |
1093360 | 1093360 | 2021-03-06 | Clark | Kansas | 20025 | 244 | 4 |
1090114 | 1090114 | 2021-03-05 | Clark | Kansas | 20025 | 244 | 4 |
1086869 | 1086869 | 2021-03-04 | Clark | Kansas | 20025 | 244 | 4 |
1083623 | 1083623 | 2021-03-03 | Clark | Kansas | 20025 | 244 | 4 |
1080377 | 1080377 | 2021-03-02 | Clark | Kansas | 20025 | 242 | 4 |
1077132 | 1077132 | 2021-03-01 | Clark | Kansas | 20025 | 242 | 4 |
1073886 | 1073886 | 2021-02-28 | Clark | Kansas | 20025 | 238 | 4 |
1070640 | 1070640 | 2021-02-27 | Clark | Kansas | 20025 | 238 | 4 |
1067395 | 1067395 | 2021-02-26 | Clark | Kansas | 20025 | 238 | 4 |
1064150 | 1064150 | 2021-02-25 | Clark | Kansas | 20025 | 237 | 4 |
1060905 | 1060905 | 2021-02-24 | Clark | Kansas | 20025 | 237 | 4 |
1057659 | 1057659 | 2021-02-23 | Clark | Kansas | 20025 | 238 | 4 |
1054413 | 1054413 | 2021-02-22 | Clark | Kansas | 20025 | 238 | 4 |
1051166 | 1051166 | 2021-02-21 | Clark | Kansas | 20025 | 235 | 4 |
1047919 | 1047919 | 2021-02-20 | Clark | Kansas | 20025 | 235 | 4 |
1044674 | 1044674 | 2021-02-19 | Clark | Kansas | 20025 | 235 | 4 |
1041429 | 1041429 | 2021-02-18 | Clark | Kansas | 20025 | 233 | 4 |
1038184 | 1038184 | 2021-02-17 | Clark | Kansas | 20025 | 233 | 4 |
1034939 | 1034939 | 2021-02-16 | Clark | Kansas | 20025 | 233 | 4 |
1031693 | 1031693 | 2021-02-15 | Clark | Kansas | 20025 | 233 | 4 |
1028446 | 1028446 | 2021-02-14 | Clark | Kansas | 20025 | 233 | 4 |
1025201 | 1025201 | 2021-02-13 | Clark | Kansas | 20025 | 233 | 4 |
1021956 | 1021956 | 2021-02-12 | Clark | Kansas | 20025 | 233 | 4 |
1018711 | 1018711 | 2021-02-11 | Clark | Kansas | 20025 | 233 | 4 |
1015466 | 1015466 | 2021-02-10 | Clark | Kansas | 20025 | 233 | 4 |
1012221 | 1012221 | 2021-02-09 | Clark | Kansas | 20025 | 233 | 4 |
1008975 | 1008975 | 2021-02-08 | Clark | Kansas | 20025 | 233 | 4 |
1005729 | 1005729 | 2021-02-07 | Clark | Kansas | 20025 | 233 | 4 |
1002483 | 1002483 | 2021-02-06 | Clark | Kansas | 20025 | 233 | 4 |
999237 | 999237 | 2021-02-05 | Clark | Kansas | 20025 | 233 | 4 |
995991 | 995991 | 2021-02-04 | Clark | Kansas | 20025 | 231 | 4 |
992745 | 992745 | 2021-02-03 | Clark | Kansas | 20025 | 231 | 4 |
989499 | 989499 | 2021-02-02 | Clark | Kansas | 20025 | 230 | 4 |
986252 | 986252 | 2021-02-01 | Clark | Kansas | 20025 | 230 | 4 |
983005 | 983005 | 2021-01-31 | Clark | Kansas | 20025 | 230 | 4 |
979759 | 979759 | 2021-01-30 | Clark | Kansas | 20025 | 230 | 4 |
976513 | 976513 | 2021-01-29 | Clark | Kansas | 20025 | 230 | 4 |
973268 | 973268 | 2021-01-28 | Clark | Kansas | 20025 | 228 | 4 |
970023 | 970023 | 2021-01-27 | Clark | Kansas | 20025 | 228 | 4 |
966779 | 966779 | 2021-01-26 | Clark | Kansas | 20025 | 226 | 4 |
963534 | 963534 | 2021-01-25 | Clark | Kansas | 20025 | 226 | 4 |
960289 | 960289 | 2021-01-24 | Clark | Kansas | 20025 | 224 | 4 |
957043 | 957043 | 2021-01-23 | Clark | Kansas | 20025 | 224 | 4 |
953798 | 953798 | 2021-01-22 | Clark | Kansas | 20025 | 224 | 4 |
950553 | 950553 | 2021-01-21 | Clark | Kansas | 20025 | 222 | 4 |
947307 | 947307 | 2021-01-20 | Clark | Kansas | 20025 | 222 | 4 |
944060 | 944060 | 2021-01-19 | Clark | Kansas | 20025 | 220 | 4 |
940815 | 940815 | 2021-01-18 | Clark | Kansas | 20025 | 220 | 4 |
937570 | 937570 | 2021-01-17 | Clark | Kansas | 20025 | 215 | 4 |
934325 | 934325 | 2021-01-16 | Clark | Kansas | 20025 | 215 | 4 |
931080 | 931080 | 2021-01-15 | Clark | Kansas | 20025 | 215 | 4 |
927835 | 927835 | 2021-01-14 | Clark | Kansas | 20025 | 212 | 4 |
924589 | 924589 | 2021-01-13 | Clark | Kansas | 20025 | 212 | 4 |
921344 | 921344 | 2021-01-12 | Clark | Kansas | 20025 | 207 | 4 |
918099 | 918099 | 2021-01-11 | Clark | Kansas | 20025 | 207 | 4 |
914854 | 914854 | 2021-01-10 | Clark | Kansas | 20025 | 205 | 4 |
911609 | 911609 | 2021-01-09 | Clark | Kansas | 20025 | 205 | 4 |
908364 | 908364 | 2021-01-08 | Clark | Kansas | 20025 | 205 | 4 |
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);