ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,259 rows where county = "Clark" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1167841 | 1167841 | 2021-03-29 | Clark | Indiana | 18019 | 12427 | 195 |
1168036 | 1168036 | 2021-03-29 | Clark | Kansas | 20025 | 247 | 4 |
1168154 | 1168154 | 2021-03-29 | Clark | Kentucky | 21049 | 2619 | 28 |
1168648 | 1168648 | 2021-03-29 | Clark | Missouri | 29045 | 673 | 7 |
1168894 | 1168894 | 2021-03-29 | Clark | Nevada | 32003 | 234131 | 4097 |
1169201 | 1169201 | 2021-03-29 | Clark | Ohio | 39023 | 13048 | 280 |
1169602 | 1169602 | 2021-03-29 | Clark | South Dakota | 46025 | 412 | 5 |
1170193 | 1170193 | 2021-03-29 | Clark | Washington | 53011 | 20105 | 246 |
1170291 | 1170291 | 2021-03-29 | Clark | Wisconsin | 55019 | 3559 | 62 |
1164000 | 1164000 | 2021-03-28 | Clark | Arkansas | 5019 | 2078 | 40 |
1164453 | 1164453 | 2021-03-28 | Clark | Idaho | 16033 | 56 | 0 |
1164492 | 1164492 | 2021-03-28 | Clark | Illinois | 17023 | 1719 | 40 |
1164593 | 1164593 | 2021-03-28 | Clark | Indiana | 18019 | 12420 | 194 |
1164788 | 1164788 | 2021-03-28 | Clark | Kansas | 20025 | 247 | 4 |
1164906 | 1164906 | 2021-03-28 | Clark | Kentucky | 21049 | 2617 | 28 |
1165400 | 1165400 | 2021-03-28 | Clark | Missouri | 29045 | 673 | 7 |
1165646 | 1165646 | 2021-03-28 | Clark | Nevada | 32003 | 234031 | 4096 |
1165953 | 1165953 | 2021-03-28 | Clark | Ohio | 39023 | 13023 | 280 |
1166354 | 1166354 | 2021-03-28 | Clark | South Dakota | 46025 | 411 | 5 |
1166945 | 1166945 | 2021-03-28 | Clark | Washington | 53011 | 20026 | 246 |
1167043 | 1167043 | 2021-03-28 | Clark | Wisconsin | 55019 | 3559 | 62 |
1160752 | 1160752 | 2021-03-27 | Clark | Arkansas | 5019 | 2078 | 40 |
1161205 | 1161205 | 2021-03-27 | Clark | Idaho | 16033 | 56 | 0 |
1161244 | 1161244 | 2021-03-27 | Clark | Illinois | 17023 | 1718 | 40 |
1161345 | 1161345 | 2021-03-27 | Clark | Indiana | 18019 | 12406 | 194 |
1161540 | 1161540 | 2021-03-27 | Clark | Kansas | 20025 | 247 | 4 |
1161658 | 1161658 | 2021-03-27 | Clark | Kentucky | 21049 | 2616 | 28 |
1162152 | 1162152 | 2021-03-27 | Clark | Missouri | 29045 | 673 | 7 |
1162398 | 1162398 | 2021-03-27 | Clark | Nevada | 32003 | 233889 | 4095 |
1162705 | 1162705 | 2021-03-27 | Clark | Ohio | 39023 | 12995 | 280 |
1163106 | 1163106 | 2021-03-27 | Clark | South Dakota | 46025 | 410 | 5 |
1163697 | 1163697 | 2021-03-27 | Clark | Washington | 53011 | 20026 | 246 |
1163795 | 1163795 | 2021-03-27 | Clark | Wisconsin | 55019 | 3558 | 62 |
1157504 | 1157504 | 2021-03-26 | Clark | Arkansas | 5019 | 2076 | 40 |
1157957 | 1157957 | 2021-03-26 | Clark | Idaho | 16033 | 56 | 0 |
1157996 | 1157996 | 2021-03-26 | Clark | Illinois | 17023 | 1718 | 40 |
1158097 | 1158097 | 2021-03-26 | Clark | Indiana | 18019 | 12389 | 194 |
1158292 | 1158292 | 2021-03-26 | Clark | Kansas | 20025 | 247 | 4 |
1158410 | 1158410 | 2021-03-26 | Clark | Kentucky | 21049 | 2614 | 28 |
1158904 | 1158904 | 2021-03-26 | Clark | Missouri | 29045 | 670 | 7 |
1159150 | 1159150 | 2021-03-26 | Clark | Nevada | 32003 | 233671 | 4088 |
1159456 | 1159456 | 2021-03-26 | Clark | Ohio | 39023 | 12961 | 280 |
1159857 | 1159857 | 2021-03-26 | Clark | South Dakota | 46025 | 406 | 5 |
1160449 | 1160449 | 2021-03-26 | Clark | Washington | 53011 | 19949 | 246 |
1160547 | 1160547 | 2021-03-26 | Clark | Wisconsin | 55019 | 3557 | 62 |
1154257 | 1154257 | 2021-03-25 | Clark | Arkansas | 5019 | 2076 | 40 |
1154710 | 1154710 | 2021-03-25 | Clark | Idaho | 16033 | 56 | 0 |
1154749 | 1154749 | 2021-03-25 | Clark | Illinois | 17023 | 1716 | 40 |
1154850 | 1154850 | 2021-03-25 | Clark | Indiana | 18019 | 12374 | 194 |
1155045 | 1155045 | 2021-03-25 | Clark | Kansas | 20025 | 247 | 4 |
1155163 | 1155163 | 2021-03-25 | Clark | Kentucky | 21049 | 2601 | 27 |
1155657 | 1155657 | 2021-03-25 | Clark | Missouri | 29045 | 663 | 7 |
1155903 | 1155903 | 2021-03-25 | Clark | Nevada | 32003 | 233305 | 4079 |
1156209 | 1156209 | 2021-03-25 | Clark | Ohio | 39023 | 12895 | 279 |
1156610 | 1156610 | 2021-03-25 | Clark | South Dakota | 46025 | 403 | 5 |
1157201 | 1157201 | 2021-03-25 | Clark | Washington | 53011 | 19903 | 245 |
1157299 | 1157299 | 2021-03-25 | Clark | Wisconsin | 55019 | 3557 | 62 |
1151010 | 1151010 | 2021-03-24 | Clark | Arkansas | 5019 | 2074 | 40 |
1151463 | 1151463 | 2021-03-24 | Clark | Idaho | 16033 | 56 | 0 |
1151502 | 1151502 | 2021-03-24 | Clark | Illinois | 17023 | 1714 | 40 |
1151603 | 1151603 | 2021-03-24 | Clark | Indiana | 18019 | 12361 | 193 |
1151798 | 1151798 | 2021-03-24 | Clark | Kansas | 20025 | 247 | 4 |
1151916 | 1151916 | 2021-03-24 | Clark | Kentucky | 21049 | 2597 | 26 |
1152410 | 1152410 | 2021-03-24 | Clark | Missouri | 29045 | 644 | 7 |
1152656 | 1152656 | 2021-03-24 | Clark | Nevada | 32003 | 233110 | 4072 |
1152962 | 1152962 | 2021-03-24 | Clark | Ohio | 39023 | 12857 | 279 |
1153363 | 1153363 | 2021-03-24 | Clark | South Dakota | 46025 | 400 | 5 |
1153954 | 1153954 | 2021-03-24 | Clark | Washington | 53011 | 19856 | 244 |
1154052 | 1154052 | 2021-03-24 | Clark | Wisconsin | 55019 | 3556 | 62 |
1147763 | 1147763 | 2021-03-23 | Clark | Arkansas | 5019 | 2071 | 40 |
1148216 | 1148216 | 2021-03-23 | Clark | Idaho | 16033 | 56 | 0 |
1148255 | 1148255 | 2021-03-23 | Clark | Illinois | 17023 | 1712 | 40 |
1148356 | 1148356 | 2021-03-23 | Clark | Indiana | 18019 | 12347 | 193 |
1148551 | 1148551 | 2021-03-23 | Clark | Kansas | 20025 | 247 | 4 |
1148669 | 1148669 | 2021-03-23 | Clark | Kentucky | 21049 | 2594 | 26 |
1149163 | 1149163 | 2021-03-23 | Clark | Missouri | 29045 | 642 | 7 |
1149409 | 1149409 | 2021-03-23 | Clark | Nevada | 32003 | 232916 | 4062 |
1149715 | 1149715 | 2021-03-23 | Clark | Ohio | 39023 | 12828 | 279 |
1150116 | 1150116 | 2021-03-23 | Clark | South Dakota | 46025 | 399 | 5 |
1150707 | 1150707 | 2021-03-23 | Clark | Washington | 53011 | 19799 | 243 |
1150805 | 1150805 | 2021-03-23 | Clark | Wisconsin | 55019 | 3554 | 62 |
1144516 | 1144516 | 2021-03-22 | Clark | Arkansas | 5019 | 2070 | 40 |
1144969 | 1144969 | 2021-03-22 | Clark | Idaho | 16033 | 56 | 0 |
1145008 | 1145008 | 2021-03-22 | Clark | Illinois | 17023 | 1710 | 40 |
1145109 | 1145109 | 2021-03-22 | Clark | Indiana | 18019 | 12336 | 192 |
1145304 | 1145304 | 2021-03-22 | Clark | Kansas | 20025 | 247 | 4 |
1145422 | 1145422 | 2021-03-22 | Clark | Kentucky | 21049 | 2582 | 26 |
1145916 | 1145916 | 2021-03-22 | Clark | Missouri | 29045 | 642 | 7 |
1146162 | 1146162 | 2021-03-22 | Clark | Nevada | 32003 | 232808 | 4049 |
1146468 | 1146468 | 2021-03-22 | Clark | Ohio | 39023 | 12788 | 279 |
1146869 | 1146869 | 2021-03-22 | Clark | South Dakota | 46025 | 395 | 5 |
1147460 | 1147460 | 2021-03-22 | Clark | Washington | 53011 | 19768 | 243 |
1147558 | 1147558 | 2021-03-22 | Clark | Wisconsin | 55019 | 3554 | 62 |
1141269 | 1141269 | 2021-03-21 | Clark | Arkansas | 5019 | 2070 | 40 |
1141722 | 1141722 | 2021-03-21 | Clark | Idaho | 16033 | 56 | 0 |
1141761 | 1141761 | 2021-03-21 | Clark | Illinois | 17023 | 1707 | 40 |
1141862 | 1141862 | 2021-03-21 | Clark | Indiana | 18019 | 12322 | 192 |
1142057 | 1142057 | 2021-03-21 | Clark | Kansas | 20025 | 247 | 4 |
1142175 | 1142175 | 2021-03-21 | Clark | Kentucky | 21049 | 2582 | 26 |
1142669 | 1142669 | 2021-03-21 | Clark | Missouri | 29045 | 642 | 7 |
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);