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 |
---|---|---|---|---|---|---|---|
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 |
909528 | 909528 | 2021-01-08 | Clark | Ohio | 39023 | 9758 | 247 |
909928 | 909928 | 2021-01-08 | Clark | South Dakota | 46025 | 320 | 2 |
910519 | 910519 | 2021-01-08 | Clark | Washington | 53011 | 14846 | 159 |
910617 | 910617 | 2021-01-08 | Clark | Wisconsin | 55019 | 3236 | 58 |
904331 | 904331 | 2021-01-07 | Clark | Arkansas | 5019 | 1483 | 24 |
904784 | 904784 | 2021-01-07 | Clark | Idaho | 16033 | 53 | 0 |
904823 | 904823 | 2021-01-07 | Clark | Illinois | 17023 | 1334 | 24 |
904923 | 904923 | 2021-01-07 | Clark | Indiana | 18019 | 9253 | 127 |
905118 | 905118 | 2021-01-07 | Clark | Kansas | 20025 | 203 | 4 |
905236 | 905236 | 2021-01-07 | Clark | Kentucky | 21049 | 1607 | 15 |
905730 | 905730 | 2021-01-07 | Clark | Missouri | 29045 | 383 | 5 |
905976 | 905976 | 2021-01-07 | Clark | Nevada | 32003 | 183447 | 2524 |
906283 | 906283 | 2021-01-07 | Clark | Ohio | 39023 | 9624 | 244 |
906683 | 906683 | 2021-01-07 | Clark | South Dakota | 46025 | 320 | 2 |
907274 | 907274 | 2021-01-07 | Clark | Washington | 53011 | 14657 | 156 |
907372 | 907372 | 2021-01-07 | Clark | Wisconsin | 55019 | 3213 | 57 |
901086 | 901086 | 2021-01-06 | Clark | Arkansas | 5019 | 1468 | 24 |
901539 | 901539 | 2021-01-06 | Clark | Idaho | 16033 | 53 | 0 |
901578 | 901578 | 2021-01-06 | Clark | Illinois | 17023 | 1318 | 24 |
901678 | 901678 | 2021-01-06 | Clark | Indiana | 18019 | 9104 | 127 |
901873 | 901873 | 2021-01-06 | Clark | Kansas | 20025 | 203 | 4 |
901991 | 901991 | 2021-01-06 | Clark | Kentucky | 21049 | 1562 | 15 |
902485 | 902485 | 2021-01-06 | Clark | Missouri | 29045 | 380 | 5 |
902731 | 902731 | 2021-01-06 | Clark | Nevada | 32003 | 180524 | 2496 |
903037 | 903037 | 2021-01-06 | Clark | Ohio | 39023 | 9494 | 240 |
903437 | 903437 | 2021-01-06 | Clark | South Dakota | 46025 | 320 | 2 |
904028 | 904028 | 2021-01-06 | Clark | Washington | 53011 | 14531 | 152 |
904126 | 904126 | 2021-01-06 | Clark | Wisconsin | 55019 | 3190 | 57 |
897841 | 897841 | 2021-01-05 | Clark | Arkansas | 5019 | 1438 | 24 |
898294 | 898294 | 2021-01-05 | Clark | Idaho | 16033 | 53 | 0 |
898333 | 898333 | 2021-01-05 | Clark | Illinois | 17023 | 1291 | 23 |
898433 | 898433 | 2021-01-05 | Clark | Indiana | 18019 | 9004 | 125 |
898628 | 898628 | 2021-01-05 | Clark | Kansas | 20025 | 198 | 4 |
898746 | 898746 | 2021-01-05 | Clark | Kentucky | 21049 | 1505 | 15 |
899240 | 899240 | 2021-01-05 | Clark | Missouri | 29045 | 378 | 5 |
899486 | 899486 | 2021-01-05 | Clark | Nevada | 32003 | 178837 | 2449 |
899792 | 899792 | 2021-01-05 | Clark | Ohio | 39023 | 9380 | 207 |
900192 | 900192 | 2021-01-05 | Clark | South Dakota | 46025 | 317 | 2 |
900783 | 900783 | 2021-01-05 | Clark | Washington | 53011 | 14431 | 149 |
900881 | 900881 | 2021-01-05 | Clark | Wisconsin | 55019 | 3181 | 55 |
894596 | 894596 | 2021-01-04 | Clark | Arkansas | 5019 | 1419 | 24 |
895049 | 895049 | 2021-01-04 | Clark | Idaho | 16033 | 53 | 0 |
895088 | 895088 | 2021-01-04 | Clark | Illinois | 17023 | 1262 | 24 |
895188 | 895188 | 2021-01-04 | Clark | Indiana | 18019 | 8894 | 121 |
895383 | 895383 | 2021-01-04 | Clark | Kansas | 20025 | 198 | 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);