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 |
---|---|---|---|---|---|---|---|
934325 | 934325 | 2021-01-16 | Clark | Kansas | 20025 | 215 | 4 |
934443 | 934443 | 2021-01-16 | Clark | Kentucky | 21049 | 1923 | 16 |
934937 | 934937 | 2021-01-16 | Clark | Missouri | 29045 | 410 | 5 |
935183 | 935183 | 2021-01-16 | Clark | Nevada | 32003 | 199260 | 2852 |
935489 | 935489 | 2021-01-16 | Clark | Ohio | 39023 | 10557 | 264 |
935889 | 935889 | 2021-01-16 | Clark | South Dakota | 46025 | 324 | 4 |
936480 | 936480 | 2021-01-16 | Clark | Washington | 53011 | 15873 | 165 |
936578 | 936578 | 2021-01-16 | Clark | Wisconsin | 55019 | 3323 | 58 |
930293 | 930293 | 2021-01-15 | Clark | Arkansas | 5019 | 1628 | 30 |
930746 | 930746 | 2021-01-15 | Clark | Idaho | 16033 | 53 | 0 |
930785 | 930785 | 2021-01-15 | Clark | Illinois | 17023 | 1446 | 28 |
930885 | 930885 | 2021-01-15 | Clark | Indiana | 18019 | 10053 | 137 |
931080 | 931080 | 2021-01-15 | Clark | Kansas | 20025 | 215 | 4 |
931198 | 931198 | 2021-01-15 | Clark | Kentucky | 21049 | 1878 | 16 |
931692 | 931692 | 2021-01-15 | Clark | Missouri | 29045 | 403 | 5 |
931938 | 931938 | 2021-01-15 | Clark | Nevada | 32003 | 197652 | 2795 |
932244 | 932244 | 2021-01-15 | Clark | Ohio | 39023 | 10451 | 263 |
932644 | 932644 | 2021-01-15 | Clark | South Dakota | 46025 | 324 | 4 |
933235 | 933235 | 2021-01-15 | Clark | Washington | 53011 | 15873 | 165 |
933333 | 933333 | 2021-01-15 | Clark | Wisconsin | 55019 | 3313 | 58 |
927048 | 927048 | 2021-01-14 | Clark | Arkansas | 5019 | 1601 | 28 |
927501 | 927501 | 2021-01-14 | Clark | Idaho | 16033 | 53 | 0 |
927540 | 927540 | 2021-01-14 | Clark | Illinois | 17023 | 1434 | 26 |
927640 | 927640 | 2021-01-14 | Clark | Indiana | 18019 | 9973 | 136 |
927835 | 927835 | 2021-01-14 | Clark | Kansas | 20025 | 212 | 4 |
927953 | 927953 | 2021-01-14 | Clark | Kentucky | 21049 | 1834 | 16 |
928447 | 928447 | 2021-01-14 | Clark | Missouri | 29045 | 400 | 5 |
928693 | 928693 | 2021-01-14 | Clark | Nevada | 32003 | 196134 | 2762 |
928999 | 928999 | 2021-01-14 | Clark | Ohio | 39023 | 10334 | 261 |
929399 | 929399 | 2021-01-14 | Clark | South Dakota | 46025 | 324 | 3 |
929990 | 929990 | 2021-01-14 | Clark | Washington | 53011 | 15734 | 165 |
930088 | 930088 | 2021-01-14 | Clark | Wisconsin | 55019 | 3298 | 58 |
923802 | 923802 | 2021-01-13 | Clark | Arkansas | 5019 | 1571 | 27 |
924255 | 924255 | 2021-01-13 | Clark | Idaho | 16033 | 53 | 0 |
924294 | 924294 | 2021-01-13 | Clark | Illinois | 17023 | 1414 | 25 |
924394 | 924394 | 2021-01-13 | Clark | Indiana | 18019 | 9885 | 134 |
924589 | 924589 | 2021-01-13 | Clark | Kansas | 20025 | 212 | 4 |
924707 | 924707 | 2021-01-13 | Clark | Kentucky | 21049 | 1785 | 16 |
925201 | 925201 | 2021-01-13 | Clark | Missouri | 29045 | 391 | 5 |
925447 | 925447 | 2021-01-13 | Clark | Nevada | 32003 | 194220 | 2716 |
925754 | 925754 | 2021-01-13 | Clark | Ohio | 39023 | 10235 | 260 |
926154 | 926154 | 2021-01-13 | Clark | South Dakota | 46025 | 324 | 2 |
926745 | 926745 | 2021-01-13 | Clark | Washington | 53011 | 15617 | 164 |
926843 | 926843 | 2021-01-13 | Clark | Wisconsin | 55019 | 3285 | 58 |
920557 | 920557 | 2021-01-12 | Clark | Arkansas | 5019 | 1552 | 27 |
921010 | 921010 | 2021-01-12 | Clark | Idaho | 16033 | 53 | 0 |
921049 | 921049 | 2021-01-12 | Clark | Illinois | 17023 | 1400 | 25 |
921149 | 921149 | 2021-01-12 | Clark | Indiana | 18019 | 9778 | 133 |
921344 | 921344 | 2021-01-12 | Clark | Kansas | 20025 | 207 | 4 |
921462 | 921462 | 2021-01-12 | Clark | Kentucky | 21049 | 1723 | 16 |
921956 | 921956 | 2021-01-12 | Clark | Missouri | 29045 | 391 | 5 |
922202 | 922202 | 2021-01-12 | Clark | Nevada | 32003 | 193483 | 2674 |
922508 | 922508 | 2021-01-12 | Clark | Ohio | 39023 | 10177 | 260 |
922908 | 922908 | 2021-01-12 | Clark | South Dakota | 46025 | 323 | 2 |
923499 | 923499 | 2021-01-12 | Clark | Washington | 53011 | 15590 | 163 |
923597 | 923597 | 2021-01-12 | Clark | Wisconsin | 55019 | 3277 | 58 |
917312 | 917312 | 2021-01-11 | Clark | Arkansas | 5019 | 1531 | 26 |
917765 | 917765 | 2021-01-11 | Clark | Idaho | 16033 | 53 | 0 |
917804 | 917804 | 2021-01-11 | Clark | Illinois | 17023 | 1390 | 24 |
917904 | 917904 | 2021-01-11 | Clark | Indiana | 18019 | 9716 | 130 |
918099 | 918099 | 2021-01-11 | Clark | Kansas | 20025 | 207 | 4 |
918217 | 918217 | 2021-01-11 | Clark | Kentucky | 21049 | 1701 | 16 |
918711 | 918711 | 2021-01-11 | Clark | Missouri | 29045 | 389 | 5 |
918957 | 918957 | 2021-01-11 | Clark | Nevada | 32003 | 191163 | 2637 |
919263 | 919263 | 2021-01-11 | Clark | Ohio | 39023 | 10057 | 251 |
919663 | 919663 | 2021-01-11 | Clark | South Dakota | 46025 | 323 | 2 |
920254 | 920254 | 2021-01-11 | Clark | Washington | 53011 | 15301 | 159 |
920352 | 920352 | 2021-01-11 | Clark | Wisconsin | 55019 | 3257 | 58 |
914067 | 914067 | 2021-01-10 | Clark | Arkansas | 5019 | 1523 | 26 |
914520 | 914520 | 2021-01-10 | Clark | Idaho | 16033 | 53 | 0 |
914559 | 914559 | 2021-01-10 | Clark | Illinois | 17023 | 1378 | 24 |
914659 | 914659 | 2021-01-10 | Clark | Indiana | 18019 | 9636 | 130 |
914854 | 914854 | 2021-01-10 | Clark | Kansas | 20025 | 205 | 4 |
914972 | 914972 | 2021-01-10 | Clark | Kentucky | 21049 | 1693 | 15 |
915466 | 915466 | 2021-01-10 | Clark | Missouri | 29045 | 389 | 5 |
915712 | 915712 | 2021-01-10 | Clark | Nevada | 32003 | 189730 | 2610 |
916018 | 916018 | 2021-01-10 | Clark | Ohio | 39023 | 9945 | 248 |
916418 | 916418 | 2021-01-10 | Clark | South Dakota | 46025 | 323 | 2 |
917009 | 917009 | 2021-01-10 | Clark | Washington | 53011 | 15010 | 159 |
917107 | 917107 | 2021-01-10 | Clark | Wisconsin | 55019 | 3251 | 58 |
910822 | 910822 | 2021-01-09 | Clark | Arkansas | 5019 | 1516 | 24 |
911275 | 911275 | 2021-01-09 | Clark | Idaho | 16033 | 53 | 0 |
911314 | 911314 | 2021-01-09 | Clark | Illinois | 17023 | 1374 | 24 |
911414 | 911414 | 2021-01-09 | Clark | Indiana | 18019 | 9514 | 130 |
911609 | 911609 | 2021-01-09 | Clark | Kansas | 20025 | 205 | 4 |
911727 | 911727 | 2021-01-09 | Clark | Kentucky | 21049 | 1682 | 15 |
912221 | 912221 | 2021-01-09 | Clark | Missouri | 29045 | 386 | 5 |
912467 | 912467 | 2021-01-09 | Clark | Nevada | 32003 | 187893 | 2603 |
912773 | 912773 | 2021-01-09 | Clark | Ohio | 39023 | 9876 | 247 |
913173 | 913173 | 2021-01-09 | Clark | South Dakota | 46025 | 322 | 2 |
913764 | 913764 | 2021-01-09 | Clark | Washington | 53011 | 15010 | 159 |
913862 | 913862 | 2021-01-09 | Clark | Wisconsin | 55019 | 3244 | 58 |
907577 | 907577 | 2021-01-08 | Clark | Arkansas | 5019 | 1503 | 24 |
908030 | 908030 | 2021-01-08 | Clark | Idaho | 16033 | 53 | 0 |
908069 | 908069 | 2021-01-08 | Clark | Illinois | 17023 | 1355 | 24 |
908169 | 908169 | 2021-01-08 | Clark | Indiana | 18019 | 9357 | 130 |
908364 | 908364 | 2021-01-08 | Clark | Kansas | 20025 | 205 | 4 |
908482 | 908482 | 2021-01-08 | Clark | Kentucky | 21049 | 1632 | 15 |
908976 | 908976 | 2021-01-08 | Clark | Missouri | 29045 | 384 | 5 |
909222 | 909222 | 2021-01-08 | Clark | Nevada | 32003 | 185829 | 2566 |
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);