ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,571 rows where county = "Clark" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Clark · 3,571 ✖
Link rowid date ▲ county state fips cases deaths
959582 959582 2021-01-24 Clark Arkansas 5019 1750 32
960035 960035 2021-01-24 Clark Idaho 16033 53 0
960074 960074 2021-01-24 Clark Illinois 17023 1529 34
960174 960174 2021-01-24 Clark Indiana 18019 10752 152
960369 960369 2021-01-24 Clark Kansas 20025 224 4
960487 960487 2021-01-24 Clark Kentucky 21049 2086 16
960981 960981 2021-01-24 Clark Missouri 29045 432 5
961227 961227 2021-01-24 Clark Nevada 32003 208147 3066
961533 961533 2021-01-24 Clark Ohio 39023 10995 265
961933 961933 2021-01-24 Clark South Dakota 46025 332 4
962524 962524 2021-01-24 Clark Washington 53011 16786 177
962622 962622 2021-01-24 Clark Wisconsin 55019 3409 61
956336 956336 2021-01-23 Clark Arkansas 5019 1739 31
956789 956789 2021-01-23 Clark Idaho 16033 53 0
956828 956828 2021-01-23 Clark Illinois 17023 1527 33
956928 956928 2021-01-23 Clark Indiana 18019 10698 152
957123 957123 2021-01-23 Clark Kansas 20025 224 4
957241 957241 2021-01-23 Clark Kentucky 21049 2076 16
957735 957735 2021-01-23 Clark Missouri 29045 428 5
957981 957981 2021-01-23 Clark Nevada 32003 207240 3061
958288 958288 2021-01-23 Clark Ohio 39023 10942 265
958688 958688 2021-01-23 Clark South Dakota 46025 331 4
959279 959279 2021-01-23 Clark Washington 53011 16786 177
959377 959377 2021-01-23 Clark Wisconsin 55019 3405 61
953091 953091 2021-01-22 Clark Arkansas 5019 1725 31
953544 953544 2021-01-22 Clark Idaho 16033 53 0
953583 953583 2021-01-22 Clark Illinois 17023 1521 33
953683 953683 2021-01-22 Clark Indiana 18019 10602 147
953878 953878 2021-01-22 Clark Kansas 20025 224 4
953996 953996 2021-01-22 Clark Kentucky 21049 2041 16
954490 954490 2021-01-22 Clark Missouri 29045 426 5
954736 954736 2021-01-22 Clark Nevada 32003 205926 3017
955042 955042 2021-01-22 Clark Ohio 39023 10867 265
955442 955442 2021-01-22 Clark South Dakota 46025 329 4
956033 956033 2021-01-22 Clark Washington 53011 16639 177
956131 956131 2021-01-22 Clark Wisconsin 55019 3397 60
949846 949846 2021-01-21 Clark Arkansas 5019 1704 31
950299 950299 2021-01-21 Clark Idaho 16033 53 0
950338 950338 2021-01-21 Clark Illinois 17023 1501 33
950438 950438 2021-01-21 Clark Indiana 18019 10541 145
950633 950633 2021-01-21 Clark Kansas 20025 222 4
950751 950751 2021-01-21 Clark Kentucky 21049 1996 16
951245 951245 2021-01-21 Clark Missouri 29045 426 5
951491 951491 2021-01-21 Clark Nevada 32003 204369 2974
951797 951797 2021-01-21 Clark Ohio 39023 10802 265
952197 952197 2021-01-21 Clark South Dakota 46025 329 4
952788 952788 2021-01-21 Clark Washington 53011 16506 175
952886 952886 2021-01-21 Clark Wisconsin 55019 3385 60
946600 946600 2021-01-20 Clark Arkansas 5019 1680 31
947053 947053 2021-01-20 Clark Idaho 16033 53 0
947092 947092 2021-01-20 Clark Illinois 17023 1485 32
947192 947192 2021-01-20 Clark Indiana 18019 10449 144
947387 947387 2021-01-20 Clark Kansas 20025 222 4
947505 947505 2021-01-20 Clark Kentucky 21049 1979 16
947999 947999 2021-01-20 Clark Missouri 29045 425 5
948245 948245 2021-01-20 Clark Nevada 32003 203292 2934
948552 948552 2021-01-20 Clark Ohio 39023 10723 264
948952 948952 2021-01-20 Clark South Dakota 46025 329 4
949543 949543 2021-01-20 Clark Washington 53011 16485 166
949641 949641 2021-01-20 Clark Wisconsin 55019 3368 59
943353 943353 2021-01-19 Clark Arkansas 5019 1658 30
943806 943806 2021-01-19 Clark Idaho 16033 53 0
943845 943845 2021-01-19 Clark Illinois 17023 1477 30
943945 943945 2021-01-19 Clark Indiana 18019 10370 143
944140 944140 2021-01-19 Clark Kansas 20025 220 4
944258 944258 2021-01-19 Clark Kentucky 21049 1944 16
944752 944752 2021-01-19 Clark Missouri 29045 420 5
944998 944998 2021-01-19 Clark Nevada 32003 202471 2873
945306 945306 2021-01-19 Clark Ohio 39023 10672 264
945706 945706 2021-01-19 Clark South Dakota 46025 325 4
946297 946297 2021-01-19 Clark Washington 53011 16300 166
946395 946395 2021-01-19 Clark Wisconsin 55019 3351 58
940108 940108 2021-01-18 Clark Arkansas 5019 1655 30
940561 940561 2021-01-18 Clark Idaho 16033 53 0
940600 940600 2021-01-18 Clark Illinois 17023 1474 30
940700 940700 2021-01-18 Clark Indiana 18019 10321 140
940895 940895 2021-01-18 Clark Kansas 20025 220 4
941013 941013 2021-01-18 Clark Kentucky 21049 1937 16
941507 941507 2021-01-18 Clark Missouri 29045 418 5
941753 941753 2021-01-18 Clark Nevada 32003 201519 2866
942059 942059 2021-01-18 Clark Ohio 39023 10648 264
942459 942459 2021-01-18 Clark South Dakota 46025 325 4
943050 943050 2021-01-18 Clark Washington 53011 16125 165
943148 943148 2021-01-18 Clark Wisconsin 55019 3344 58
936863 936863 2021-01-17 Clark Arkansas 5019 1649 30
937316 937316 2021-01-17 Clark Idaho 16033 53 0
937355 937355 2021-01-17 Clark Illinois 17023 1465 29
937455 937455 2021-01-17 Clark Indiana 18019 10261 138
937650 937650 2021-01-17 Clark Kansas 20025 215 4
937768 937768 2021-01-17 Clark Kentucky 21049 1931 16
938262 938262 2021-01-17 Clark Missouri 29045 418 5
938508 938508 2021-01-17 Clark Nevada 32003 200597 2866
938814 938814 2021-01-17 Clark Ohio 39023 10608 264
939214 939214 2021-01-17 Clark South Dakota 46025 324 4
939805 939805 2021-01-17 Clark Washington 53011 16125 165
939903 939903 2021-01-17 Clark Wisconsin 55019 3331 58
933618 933618 2021-01-16 Clark Arkansas 5019 1643 30
934071 934071 2021-01-16 Clark Idaho 16033 53 0
934110 934110 2021-01-16 Clark Illinois 17023 1459 29
934210 934210 2021-01-16 Clark Indiana 18019 10172 137

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);