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 |
---|---|---|---|---|---|---|---|
386508 | 386508 | 2020-07-31 | Clark | Idaho | 16033 | 2 | 0 |
386546 | 386546 | 2020-07-31 | Clark | Illinois | 17023 | 66 | 0 |
386647 | 386647 | 2020-07-31 | Clark | Indiana | 18019 | 1038 | 52 |
386842 | 386842 | 2020-07-31 | Clark | Kansas | 20025 | 44 | 1 |
386957 | 386957 | 2020-07-31 | Clark | Kentucky | 21049 | 148 | 7 |
387451 | 387451 | 2020-07-31 | Clark | Missouri | 29045 | 11 | 0 |
387684 | 387684 | 2020-07-31 | Clark | Nevada | 32003 | 41245 | 687 |
387988 | 387988 | 2020-07-31 | Clark | Ohio | 39023 | 1058 | 13 |
388386 | 388386 | 2020-07-31 | Clark | South Dakota | 46025 | 16 | 0 |
388971 | 388971 | 2020-07-31 | Clark | Washington | 53011 | 1780 | 42 |
389070 | 389070 | 2020-07-31 | Clark | Wisconsin | 55019 | 168 | 7 |
382840 | 382840 | 2020-07-30 | Clark | Arkansas | 5019 | 153 | 0 |
383290 | 383290 | 2020-07-30 | Clark | Idaho | 16033 | 2 | 0 |
383328 | 383328 | 2020-07-30 | Clark | Illinois | 17023 | 65 | 0 |
383429 | 383429 | 2020-07-30 | Clark | Indiana | 18019 | 1009 | 52 |
383624 | 383624 | 2020-07-30 | Clark | Kansas | 20025 | 42 | 1 |
383739 | 383739 | 2020-07-30 | Clark | Kentucky | 21049 | 143 | 7 |
384233 | 384233 | 2020-07-30 | Clark | Missouri | 29045 | 8 | 0 |
384467 | 384467 | 2020-07-30 | Clark | Nevada | 32003 | 40193 | 664 |
384771 | 384771 | 2020-07-30 | Clark | Ohio | 39023 | 1046 | 13 |
385169 | 385169 | 2020-07-30 | Clark | South Dakota | 46025 | 16 | 0 |
385754 | 385754 | 2020-07-30 | Clark | Washington | 53011 | 1758 | 41 |
385853 | 385853 | 2020-07-30 | Clark | Wisconsin | 55019 | 167 | 7 |
379623 | 379623 | 2020-07-29 | Clark | Arkansas | 5019 | 148 | 0 |
380073 | 380073 | 2020-07-29 | Clark | Idaho | 16033 | 2 | 0 |
380111 | 380111 | 2020-07-29 | Clark | Illinois | 17023 | 63 | 0 |
380212 | 380212 | 2020-07-29 | Clark | Indiana | 18019 | 982 | 52 |
380407 | 380407 | 2020-07-29 | Clark | Kansas | 20025 | 42 | 1 |
380522 | 380522 | 2020-07-29 | Clark | Kentucky | 21049 | 137 | 7 |
381017 | 381017 | 2020-07-29 | Clark | Missouri | 29045 | 3 | 0 |
381250 | 381250 | 2020-07-29 | Clark | Nevada | 32003 | 39345 | 645 |
381553 | 381553 | 2020-07-29 | Clark | Ohio | 39023 | 1031 | 13 |
381951 | 381951 | 2020-07-29 | Clark | South Dakota | 46025 | 16 | 0 |
382536 | 382536 | 2020-07-29 | Clark | Washington | 53011 | 1729 | 41 |
382635 | 382635 | 2020-07-29 | Clark | Wisconsin | 55019 | 166 | 7 |
376407 | 376407 | 2020-07-28 | Clark | Arkansas | 5019 | 145 | 0 |
376856 | 376856 | 2020-07-28 | Clark | Idaho | 16033 | 1 | 0 |
376894 | 376894 | 2020-07-28 | Clark | Illinois | 17023 | 63 | 0 |
376995 | 376995 | 2020-07-28 | Clark | Indiana | 18019 | 965 | 52 |
377190 | 377190 | 2020-07-28 | Clark | Kansas | 20025 | 41 | 1 |
377305 | 377305 | 2020-07-28 | Clark | Kentucky | 21049 | 132 | 7 |
377800 | 377800 | 2020-07-28 | Clark | Missouri | 29045 | 2 | 0 |
378032 | 378032 | 2020-07-28 | Clark | Nevada | 32003 | 38534 | 626 |
378336 | 378336 | 2020-07-28 | Clark | Ohio | 39023 | 1023 | 12 |
378734 | 378734 | 2020-07-28 | Clark | South Dakota | 46025 | 16 | 0 |
379319 | 379319 | 2020-07-28 | Clark | Washington | 53011 | 1719 | 39 |
379418 | 379418 | 2020-07-28 | Clark | Wisconsin | 55019 | 161 | 7 |
373193 | 373193 | 2020-07-27 | Clark | Arkansas | 5019 | 138 | 0 |
373679 | 373679 | 2020-07-27 | Clark | Illinois | 17023 | 59 | 0 |
373780 | 373780 | 2020-07-27 | Clark | Indiana | 18019 | 939 | 52 |
373975 | 373975 | 2020-07-27 | Clark | Kansas | 20025 | 41 | 1 |
374090 | 374090 | 2020-07-27 | Clark | Kentucky | 21049 | 132 | 7 |
374585 | 374585 | 2020-07-27 | Clark | Missouri | 29045 | 2 | 0 |
374817 | 374817 | 2020-07-27 | Clark | Nevada | 32003 | 37492 | 606 |
375119 | 375119 | 2020-07-27 | Clark | Ohio | 39023 | 1002 | 11 |
375518 | 375518 | 2020-07-27 | Clark | South Dakota | 46025 | 16 | 0 |
376103 | 376103 | 2020-07-27 | Clark | Washington | 53011 | 1682 | 39 |
376202 | 376202 | 2020-07-27 | Clark | Wisconsin | 55019 | 158 | 7 |
369981 | 369981 | 2020-07-26 | Clark | Arkansas | 5019 | 132 | 0 |
370467 | 370467 | 2020-07-26 | Clark | Illinois | 17023 | 57 | 0 |
370568 | 370568 | 2020-07-26 | Clark | Indiana | 18019 | 927 | 52 |
370763 | 370763 | 2020-07-26 | Clark | Kansas | 20025 | 40 | 1 |
370878 | 370878 | 2020-07-26 | Clark | Kentucky | 21049 | 128 | 7 |
371373 | 371373 | 2020-07-26 | Clark | Missouri | 29045 | 2 | 0 |
371605 | 371605 | 2020-07-26 | Clark | Nevada | 32003 | 36593 | 601 |
371907 | 371907 | 2020-07-26 | Clark | Ohio | 39023 | 988 | 11 |
372305 | 372305 | 2020-07-26 | Clark | South Dakota | 46025 | 16 | 0 |
372889 | 372889 | 2020-07-26 | Clark | Washington | 53011 | 1634 | 39 |
372988 | 372988 | 2020-07-26 | Clark | Wisconsin | 55019 | 157 | 7 |
366771 | 366771 | 2020-07-25 | Clark | Arkansas | 5019 | 129 | 0 |
367257 | 367257 | 2020-07-25 | Clark | Illinois | 17023 | 53 | 0 |
367358 | 367358 | 2020-07-25 | Clark | Indiana | 18019 | 912 | 52 |
367553 | 367553 | 2020-07-25 | Clark | Kansas | 20025 | 40 | 1 |
367668 | 367668 | 2020-07-25 | Clark | Kentucky | 21049 | 128 | 7 |
368162 | 368162 | 2020-07-25 | Clark | Missouri | 29045 | 2 | 0 |
368393 | 368393 | 2020-07-25 | Clark | Nevada | 32003 | 35786 | 601 |
368695 | 368695 | 2020-07-25 | Clark | Ohio | 39023 | 988 | 11 |
369093 | 369093 | 2020-07-25 | Clark | South Dakota | 46025 | 16 | 0 |
369677 | 369677 | 2020-07-25 | Clark | Washington | 53011 | 1634 | 39 |
369776 | 369776 | 2020-07-25 | Clark | Wisconsin | 55019 | 156 | 7 |
363564 | 363564 | 2020-07-24 | Clark | Arkansas | 5019 | 125 | 0 |
364050 | 364050 | 2020-07-24 | Clark | Illinois | 17023 | 52 | 0 |
364151 | 364151 | 2020-07-24 | Clark | Indiana | 18019 | 884 | 52 |
364346 | 364346 | 2020-07-24 | Clark | Kansas | 20025 | 40 | 1 |
364461 | 364461 | 2020-07-24 | Clark | Kentucky | 21049 | 126 | 7 |
364954 | 364954 | 2020-07-24 | Clark | Missouri | 29045 | 2 | 0 |
365184 | 365184 | 2020-07-24 | Clark | Nevada | 32003 | 35000 | 592 |
365486 | 365486 | 2020-07-24 | Clark | Ohio | 39023 | 976 | 11 |
365884 | 365884 | 2020-07-24 | Clark | South Dakota | 46025 | 16 | 0 |
366468 | 366468 | 2020-07-24 | Clark | Washington | 53011 | 1634 | 39 |
366566 | 366566 | 2020-07-24 | Clark | Wisconsin | 55019 | 154 | 7 |
360357 | 360357 | 2020-07-23 | Clark | Arkansas | 5019 | 120 | 0 |
360843 | 360843 | 2020-07-23 | Clark | Illinois | 17023 | 51 | 0 |
360944 | 360944 | 2020-07-23 | Clark | Indiana | 18019 | 855 | 52 |
361139 | 361139 | 2020-07-23 | Clark | Kansas | 20025 | 38 | 1 |
361254 | 361254 | 2020-07-23 | Clark | Kentucky | 21049 | 122 | 7 |
361747 | 361747 | 2020-07-23 | Clark | Missouri | 29045 | 2 | 0 |
361978 | 361978 | 2020-07-23 | Clark | Nevada | 32003 | 34209 | 580 |
362280 | 362280 | 2020-07-23 | Clark | Ohio | 39023 | 964 | 11 |
362678 | 362678 | 2020-07-23 | Clark | South Dakota | 46025 | 16 | 0 |
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);