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 |
---|---|---|---|---|---|---|---|
635456 | 635456 | 2020-10-16 | Clark | Idaho | 16033 | 40 | 0 |
635495 | 635495 | 2020-10-16 | Clark | Illinois | 17023 | 247 | 6 |
635596 | 635596 | 2020-10-16 | Clark | Indiana | 18019 | 2739 | 64 |
635791 | 635791 | 2020-10-16 | Clark | Kansas | 20025 | 61 | 1 |
635909 | 635909 | 2020-10-16 | Clark | Kentucky | 21049 | 429 | 10 |
636403 | 636403 | 2020-10-16 | Clark | Missouri | 29045 | 95 | 0 |
636650 | 636650 | 2020-10-16 | Clark | Nevada | 32003 | 73737 | 1468 |
636955 | 636955 | 2020-10-16 | Clark | Ohio | 39023 | 2279 | 53 |
637355 | 637355 | 2020-10-16 | Clark | South Dakota | 46025 | 65 | 0 |
637944 | 637944 | 2020-10-16 | Clark | Washington | 53011 | 4120 | 76 |
638043 | 638043 | 2020-10-16 | Clark | Wisconsin | 55019 | 676 | 11 |
631758 | 631758 | 2020-10-15 | Clark | Arkansas | 5019 | 448 | 5 |
632210 | 632210 | 2020-10-15 | Clark | Idaho | 16033 | 40 | 0 |
632249 | 632249 | 2020-10-15 | Clark | Illinois | 17023 | 241 | 6 |
632350 | 632350 | 2020-10-15 | Clark | Indiana | 18019 | 2697 | 64 |
632545 | 632545 | 2020-10-15 | Clark | Kansas | 20025 | 60 | 1 |
632663 | 632663 | 2020-10-15 | Clark | Kentucky | 21049 | 408 | 10 |
633157 | 633157 | 2020-10-15 | Clark | Missouri | 29045 | 95 | 0 |
633404 | 633404 | 2020-10-15 | Clark | Nevada | 32003 | 73154 | 1461 |
633709 | 633709 | 2020-10-15 | Clark | Ohio | 39023 | 2246 | 52 |
634109 | 634109 | 2020-10-15 | Clark | South Dakota | 46025 | 61 | 0 |
634699 | 634699 | 2020-10-15 | Clark | Washington | 53011 | 4077 | 76 |
634798 | 634798 | 2020-10-15 | Clark | Wisconsin | 55019 | 653 | 9 |
628514 | 628514 | 2020-10-14 | Clark | Arkansas | 5019 | 437 | 5 |
628966 | 628966 | 2020-10-14 | Clark | Idaho | 16033 | 40 | 0 |
629005 | 629005 | 2020-10-14 | Clark | Illinois | 17023 | 240 | 4 |
629106 | 629106 | 2020-10-14 | Clark | Indiana | 18019 | 2658 | 64 |
629301 | 629301 | 2020-10-14 | Clark | Kansas | 20025 | 60 | 1 |
629419 | 629419 | 2020-10-14 | Clark | Kentucky | 21049 | 409 | 10 |
629912 | 629912 | 2020-10-14 | Clark | Missouri | 29045 | 92 | 0 |
630159 | 630159 | 2020-10-14 | Clark | Nevada | 32003 | 72742 | 1458 |
630464 | 630464 | 2020-10-14 | Clark | Ohio | 39023 | 2197 | 52 |
630864 | 630864 | 2020-10-14 | Clark | South Dakota | 46025 | 59 | 0 |
631454 | 631454 | 2020-10-14 | Clark | Washington | 53011 | 4031 | 75 |
631553 | 631553 | 2020-10-14 | Clark | Wisconsin | 55019 | 628 | 9 |
625271 | 625271 | 2020-10-13 | Clark | Arkansas | 5019 | 429 | 5 |
625723 | 625723 | 2020-10-13 | Clark | Idaho | 16033 | 40 | 0 |
625762 | 625762 | 2020-10-13 | Clark | Illinois | 17023 | 234 | 4 |
625863 | 625863 | 2020-10-13 | Clark | Indiana | 18019 | 2636 | 64 |
626058 | 626058 | 2020-10-13 | Clark | Kansas | 20025 | 59 | 1 |
626175 | 626175 | 2020-10-13 | Clark | Kentucky | 21049 | 407 | 10 |
626668 | 626668 | 2020-10-13 | Clark | Missouri | 29045 | 85 | 0 |
626915 | 626915 | 2020-10-13 | Clark | Nevada | 32003 | 72439 | 1444 |
627220 | 627220 | 2020-10-13 | Clark | Ohio | 39023 | 2167 | 52 |
627620 | 627620 | 2020-10-13 | Clark | South Dakota | 46025 | 55 | 0 |
628210 | 628210 | 2020-10-13 | Clark | Washington | 53011 | 3981 | 73 |
628309 | 628309 | 2020-10-13 | Clark | Wisconsin | 55019 | 615 | 9 |
622028 | 622028 | 2020-10-12 | Clark | Arkansas | 5019 | 425 | 5 |
622480 | 622480 | 2020-10-12 | Clark | Idaho | 16033 | 39 | 0 |
622520 | 622520 | 2020-10-12 | Clark | Illinois | 17023 | 233 | 4 |
622621 | 622621 | 2020-10-12 | Clark | Indiana | 18019 | 2612 | 64 |
622816 | 622816 | 2020-10-12 | Clark | Kansas | 20025 | 59 | 1 |
622933 | 622933 | 2020-10-12 | Clark | Kentucky | 21049 | 400 | 10 |
623426 | 623426 | 2020-10-12 | Clark | Missouri | 29045 | 85 | 0 |
623673 | 623673 | 2020-10-12 | Clark | Nevada | 32003 | 72048 | 1440 |
623978 | 623978 | 2020-10-12 | Clark | Ohio | 39023 | 2152 | 52 |
624378 | 624378 | 2020-10-12 | Clark | South Dakota | 46025 | 55 | 0 |
624967 | 624967 | 2020-10-12 | Clark | Washington | 53011 | 3958 | 71 |
625066 | 625066 | 2020-10-12 | Clark | Wisconsin | 55019 | 603 | 9 |
618785 | 618785 | 2020-10-11 | Clark | Arkansas | 5019 | 422 | 4 |
619237 | 619237 | 2020-10-11 | Clark | Idaho | 16033 | 39 | 0 |
619276 | 619276 | 2020-10-11 | Clark | Illinois | 17023 | 229 | 4 |
619377 | 619377 | 2020-10-11 | Clark | Indiana | 18019 | 2593 | 64 |
619572 | 619572 | 2020-10-11 | Clark | Kansas | 20025 | 57 | 1 |
619689 | 619689 | 2020-10-11 | Clark | Kentucky | 21049 | 397 | 10 |
620183 | 620183 | 2020-10-11 | Clark | Missouri | 29045 | 85 | 0 |
620430 | 620430 | 2020-10-11 | Clark | Nevada | 32003 | 71633 | 1439 |
620735 | 620735 | 2020-10-11 | Clark | Ohio | 39023 | 2123 | 52 |
621135 | 621135 | 2020-10-11 | Clark | South Dakota | 46025 | 54 | 0 |
621724 | 621724 | 2020-10-11 | Clark | Washington | 53011 | 3801 | 71 |
621823 | 621823 | 2020-10-11 | Clark | Wisconsin | 55019 | 593 | 9 |
615543 | 615543 | 2020-10-10 | Clark | Arkansas | 5019 | 418 | 4 |
615995 | 615995 | 2020-10-10 | Clark | Idaho | 16033 | 38 | 0 |
616034 | 616034 | 2020-10-10 | Clark | Illinois | 17023 | 229 | 4 |
616135 | 616135 | 2020-10-10 | Clark | Indiana | 18019 | 2559 | 64 |
616330 | 616330 | 2020-10-10 | Clark | Kansas | 20025 | 57 | 1 |
616447 | 616447 | 2020-10-10 | Clark | Kentucky | 21049 | 396 | 10 |
616941 | 616941 | 2020-10-10 | Clark | Missouri | 29045 | 85 | 0 |
617188 | 617188 | 2020-10-10 | Clark | Nevada | 32003 | 71325 | 1438 |
617493 | 617493 | 2020-10-10 | Clark | Ohio | 39023 | 2100 | 52 |
617892 | 617892 | 2020-10-10 | Clark | South Dakota | 46025 | 53 | 0 |
618481 | 618481 | 2020-10-10 | Clark | Washington | 53011 | 3801 | 71 |
618580 | 618580 | 2020-10-10 | Clark | Wisconsin | 55019 | 579 | 9 |
612302 | 612302 | 2020-10-09 | Clark | Arkansas | 5019 | 412 | 4 |
612754 | 612754 | 2020-10-09 | Clark | Idaho | 16033 | 38 | 0 |
612793 | 612793 | 2020-10-09 | Clark | Illinois | 17023 | 227 | 4 |
612894 | 612894 | 2020-10-09 | Clark | Indiana | 18019 | 2514 | 64 |
613089 | 613089 | 2020-10-09 | Clark | Kansas | 20025 | 57 | 1 |
613206 | 613206 | 2020-10-09 | Clark | Kentucky | 21049 | 388 | 10 |
613700 | 613700 | 2020-10-09 | Clark | Missouri | 29045 | 82 | 0 |
613946 | 613946 | 2020-10-09 | Clark | Nevada | 32003 | 70730 | 1438 |
614251 | 614251 | 2020-10-09 | Clark | Ohio | 39023 | 2077 | 52 |
614650 | 614650 | 2020-10-09 | Clark | South Dakota | 46025 | 50 | 0 |
615239 | 615239 | 2020-10-09 | Clark | Washington | 53011 | 3801 | 71 |
615338 | 615338 | 2020-10-09 | Clark | Wisconsin | 55019 | 568 | 9 |
609060 | 609060 | 2020-10-08 | Clark | Arkansas | 5019 | 409 | 4 |
609512 | 609512 | 2020-10-08 | Clark | Idaho | 16033 | 38 | 0 |
609551 | 609551 | 2020-10-08 | Clark | Illinois | 17023 | 207 | 4 |
609652 | 609652 | 2020-10-08 | Clark | Indiana | 18019 | 2487 | 64 |
609847 | 609847 | 2020-10-08 | Clark | Kansas | 20025 | 56 | 1 |
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);