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,967 rows where county = "Clark" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Clark · 3,967 ✖
Link rowid date ▲ county state fips cases deaths
1066607 1066607 2021-02-26 Clark Arkansas 5019 2029 37
1067060 1067060 2021-02-26 Clark Idaho 16033 53 0
1067099 1067099 2021-02-26 Clark Illinois 17023 1681 37
1067200 1067200 2021-02-26 Clark Indiana 18019 11934 188
1067395 1067395 2021-02-26 Clark Kansas 20025 238 4
1067513 1067513 2021-02-26 Clark Kentucky 21049 2409 20
1068006 1068006 2021-02-26 Clark Missouri 29045 472 6
1068252 1068252 2021-02-26 Clark Nevada 32003 226120 3847
1068558 1068558 2021-02-26 Clark Ohio 39023 12194 335
1068958 1068958 2021-02-26 Clark South Dakota 46025 370 5
1069549 1069549 2021-02-26 Clark Washington 53011 18859 228
1069647 1069647 2021-02-26 Clark Wisconsin 55019 3542 61
1063362 1063362 2021-02-25 Clark Arkansas 5019 2021 37
1063815 1063815 2021-02-25 Clark Idaho 16033 53 0
1063854 1063854 2021-02-25 Clark Illinois 17023 1680 37
1063955 1063955 2021-02-25 Clark Indiana 18019 11906 187
1064150 1064150 2021-02-25 Clark Kansas 20025 237 4
1064268 1064268 2021-02-25 Clark Kentucky 21049 2407 18
1064761 1064761 2021-02-25 Clark Missouri 29045 472 6
1065007 1065007 2021-02-25 Clark Nevada 32003 225820 3839
1065313 1065313 2021-02-25 Clark Ohio 39023 12162 335
1065713 1065713 2021-02-25 Clark South Dakota 46025 368 5
1066304 1066304 2021-02-25 Clark Washington 53011 18804 228
1066402 1066402 2021-02-25 Clark Wisconsin 55019 3542 61
1060117 1060117 2021-02-24 Clark Arkansas 5019 2014 37
1060570 1060570 2021-02-24 Clark Idaho 16033 53 0
1060609 1060609 2021-02-24 Clark Illinois 17023 1675 37
1060710 1060710 2021-02-24 Clark Indiana 18019 11881 187
1060905 1060905 2021-02-24 Clark Kansas 20025 237 4
1061023 1061023 2021-02-24 Clark Kentucky 21049 2394 18
1061517 1061517 2021-02-24 Clark Missouri 29045 472 6
1061763 1061763 2021-02-24 Clark Nevada 32003 225301 3827
1062069 1062069 2021-02-24 Clark Ohio 39023 12139 333
1062468 1062468 2021-02-24 Clark South Dakota 46025 366 5
1063059 1063059 2021-02-24 Clark Washington 53011 18754 227
1063157 1063157 2021-02-24 Clark Wisconsin 55019 3541 61
1056871 1056871 2021-02-23 Clark Arkansas 5019 2002 37
1057324 1057324 2021-02-23 Clark Idaho 16033 53 0
1057363 1057363 2021-02-23 Clark Illinois 17023 1673 37
1057464 1057464 2021-02-23 Clark Indiana 18019 11864 187
1057659 1057659 2021-02-23 Clark Kansas 20025 238 4
1057777 1057777 2021-02-23 Clark Kentucky 21049 2384 18
1058271 1058271 2021-02-23 Clark Missouri 29045 471 6
1058517 1058517 2021-02-23 Clark Nevada 32003 224944 3810
1058823 1058823 2021-02-23 Clark Ohio 39023 12121 332
1059223 1059223 2021-02-23 Clark South Dakota 46025 365 5
1059814 1059814 2021-02-23 Clark Washington 53011 18706 228
1059912 1059912 2021-02-23 Clark Wisconsin 55019 3539 61
1053625 1053625 2021-02-22 Clark Arkansas 5019 1993 37
1054078 1054078 2021-02-22 Clark Idaho 16033 53 0
1054117 1054117 2021-02-22 Clark Illinois 17023 1667 37
1054218 1054218 2021-02-22 Clark Indiana 18019 11847 187
1054413 1054413 2021-02-22 Clark Kansas 20025 238 4
1054531 1054531 2021-02-22 Clark Kentucky 21049 2372 18
1055025 1055025 2021-02-22 Clark Missouri 29045 470 6
1055271 1055271 2021-02-22 Clark Nevada 32003 224597 3789
1055577 1055577 2021-02-22 Clark Ohio 39023 12101 331
1055977 1055977 2021-02-22 Clark South Dakota 46025 362 5
1056568 1056568 2021-02-22 Clark Washington 53011 18674 225
1056666 1056666 2021-02-22 Clark Wisconsin 55019 3533 61
1050378 1050378 2021-02-21 Clark Arkansas 5019 1992 36
1050831 1050831 2021-02-21 Clark Idaho 16033 53 0
1050870 1050870 2021-02-21 Clark Illinois 17023 1667 37
1050971 1050971 2021-02-21 Clark Indiana 18019 11827 187
1051166 1051166 2021-02-21 Clark Kansas 20025 235 4
1051284 1051284 2021-02-21 Clark Kentucky 21049 2371 18
1051778 1051778 2021-02-21 Clark Missouri 29045 470 6
1052024 1052024 2021-02-21 Clark Nevada 32003 224469 3780
1052331 1052331 2021-02-21 Clark Ohio 39023 12082 330
1052731 1052731 2021-02-21 Clark South Dakota 46025 362 5
1053322 1053322 2021-02-21 Clark Washington 53011 18612 224
1053420 1053420 2021-02-21 Clark Wisconsin 55019 3533 61
1047131 1047131 2021-02-20 Clark Arkansas 5019 1990 36
1047584 1047584 2021-02-20 Clark Idaho 16033 53 0
1047623 1047623 2021-02-20 Clark Illinois 17023 1665 37
1047724 1047724 2021-02-20 Clark Indiana 18019 11811 187
1047919 1047919 2021-02-20 Clark Kansas 20025 235 4
1048037 1048037 2021-02-20 Clark Kentucky 21049 2370 18
1048531 1048531 2021-02-20 Clark Missouri 29045 469 6
1048777 1048777 2021-02-20 Clark Nevada 32003 224227 3778
1049084 1049084 2021-02-20 Clark Ohio 39023 12064 329
1049484 1049484 2021-02-20 Clark South Dakota 46025 362 5
1050075 1050075 2021-02-20 Clark Washington 53011 18612 224
1050173 1050173 2021-02-20 Clark Wisconsin 55019 3533 61
1043886 1043886 2021-02-19 Clark Arkansas 5019 1986 36
1044339 1044339 2021-02-19 Clark Idaho 16033 53 0
1044378 1044378 2021-02-19 Clark Illinois 17023 1663 37
1044479 1044479 2021-02-19 Clark Indiana 18019 11783 187
1044674 1044674 2021-02-19 Clark Kansas 20025 235 4
1044792 1044792 2021-02-19 Clark Kentucky 21049 2369 18
1045285 1045285 2021-02-19 Clark Missouri 29045 469 6
1045531 1045531 2021-02-19 Clark Nevada 32003 223960 3749
1045837 1045837 2021-02-19 Clark Ohio 39023 12046 328
1046237 1046237 2021-02-19 Clark South Dakota 46025 363 5
1046828 1046828 2021-02-19 Clark Washington 53011 18551 224
1046926 1046926 2021-02-19 Clark Wisconsin 55019 3533 61
1040641 1040641 2021-02-18 Clark Arkansas 5019 1983 36
1041094 1041094 2021-02-18 Clark Idaho 16033 53 0
1041133 1041133 2021-02-18 Clark Illinois 17023 1657 37
1041234 1041234 2021-02-18 Clark Indiana 18019 11761 187

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);