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

6,835 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 · 6,835 ✖
Link rowid date ▲ county state fips cases deaths
1842727 1842727 2021-10-23 Clark Arkansas 5019 3229 55
1843181 1843181 2021-10-23 Clark Idaho 16033 78 0
1843220 1843220 2021-10-23 Clark Illinois 17023 2669 48
1843321 1843321 2021-10-23 Clark Indiana 18019 18579 262
1843516 1843516 2021-10-23 Clark Kansas 20025 321 7
1843633 1843633 2021-10-23 Clark Kentucky 21049 5166 38
1844127 1844127 2021-10-23 Clark Missouri 29045 989 12
1844374 1844374 2021-10-23 Clark Nevada 32003 336995 5900
1844680 1844680 2021-10-23 Clark Ohio 39023 19863 354
1845081 1845081 2021-10-23 Clark South Dakota 46025 509 5
1845672 1845672 2021-10-23 Clark Washington 53011 40780 479
1845770 1845770 2021-10-23 Clark Wisconsin 55019 4745 78
1839477 1839477 2021-10-22 Clark Arkansas 5019 3220 55
1839931 1839931 2021-10-22 Clark Idaho 16033 78 0
1839970 1839970 2021-10-22 Clark Illinois 17023 2669 48
1840071 1840071 2021-10-22 Clark Indiana 18019 18579 262
1840266 1840266 2021-10-22 Clark Kansas 20025 321 7
1840383 1840383 2021-10-22 Clark Kentucky 21049 5166 38
1840877 1840877 2021-10-22 Clark Missouri 29045 981 12
1841124 1841124 2021-10-22 Clark Nevada 32003 336995 5900
1841430 1841430 2021-10-22 Clark Ohio 39023 19812 354
1841831 1841831 2021-10-22 Clark South Dakota 46025 509 5
1842422 1842422 2021-10-22 Clark Washington 53011 40780 479
1842520 1842520 2021-10-22 Clark Wisconsin 55019 4745 78
1836228 1836228 2021-10-21 Clark Arkansas 5019 3212 54
1836682 1836682 2021-10-21 Clark Idaho 16033 78 0
1836721 1836721 2021-10-21 Clark Illinois 17023 2665 48
1836822 1836822 2021-10-21 Clark Indiana 18019 18562 262
1837017 1837017 2021-10-21 Clark Kansas 20025 321 7
1837134 1837134 2021-10-21 Clark Kentucky 21049 5150 38
1837628 1837628 2021-10-21 Clark Missouri 29045 981 12
1837875 1837875 2021-10-21 Clark Nevada 32003 336580 5894
1838181 1838181 2021-10-21 Clark Ohio 39023 19757 351
1838582 1838582 2021-10-21 Clark South Dakota 46025 508 5
1839173 1839173 2021-10-21 Clark Washington 53011 40651 476
1839271 1839271 2021-10-21 Clark Wisconsin 55019 4729 78
1832979 1832979 2021-10-20 Clark Arkansas 5019 3203 54
1833433 1833433 2021-10-20 Clark Idaho 16033 77 0
1833472 1833472 2021-10-20 Clark Illinois 17023 2657 48
1833573 1833573 2021-10-20 Clark Indiana 18019 18527 262
1833768 1833768 2021-10-20 Clark Kansas 20025 321 7
1833885 1833885 2021-10-20 Clark Kentucky 21049 5144 38
1834379 1834379 2021-10-20 Clark Missouri 29045 976 12
1834626 1834626 2021-10-20 Clark Nevada 32003 336148 5873
1834932 1834932 2021-10-20 Clark Ohio 39023 19728 351
1835333 1835333 2021-10-20 Clark South Dakota 46025 507 5
1835924 1835924 2021-10-20 Clark Washington 53011 40435 473
1836022 1836022 2021-10-20 Clark Wisconsin 55019 4723 76
1829730 1829730 2021-10-19 Clark Arkansas 5019 3196 54
1830184 1830184 2021-10-19 Clark Idaho 16033 77 0
1830223 1830223 2021-10-19 Clark Illinois 17023 2653 48
1830324 1830324 2021-10-19 Clark Indiana 18019 18471 262
1830519 1830519 2021-10-19 Clark Kansas 20025 318 7
1830636 1830636 2021-10-19 Clark Kentucky 21049 5133 37
1831130 1831130 2021-10-19 Clark Missouri 29045 976 12
1831377 1831377 2021-10-19 Clark Nevada 32003 335812 5862
1831683 1831683 2021-10-19 Clark Ohio 39023 19668 351
1832084 1832084 2021-10-19 Clark South Dakota 46025 505 5
1832675 1832675 2021-10-19 Clark Washington 53011 40211 468
1832773 1832773 2021-10-19 Clark Wisconsin 55019 4708 76
1826481 1826481 2021-10-18 Clark Arkansas 5019 3192 54
1826935 1826935 2021-10-18 Clark Idaho 16033 77 0
1826974 1826974 2021-10-18 Clark Illinois 17023 2652 48
1827075 1827075 2021-10-18 Clark Indiana 18019 18446 260
1827270 1827270 2021-10-18 Clark Kansas 20025 318 7
1827387 1827387 2021-10-18 Clark Kentucky 21049 5129 37
1827881 1827881 2021-10-18 Clark Missouri 29045 976 12
1828128 1828128 2021-10-18 Clark Nevada 32003 335241 5855
1828434 1828434 2021-10-18 Clark Ohio 39023 19630 349
1828835 1828835 2021-10-18 Clark South Dakota 46025 502 5
1829426 1829426 2021-10-18 Clark Washington 53011 39759 461
1829524 1829524 2021-10-18 Clark Wisconsin 55019 4703 76
1823232 1823232 2021-10-17 Clark Arkansas 5019 3191 54
1823686 1823686 2021-10-17 Clark Idaho 16033 77 0
1823725 1823725 2021-10-17 Clark Illinois 17023 2649 47
1823826 1823826 2021-10-17 Clark Indiana 18019 18405 258
1824021 1824021 2021-10-17 Clark Kansas 20025 318 7
1824138 1824138 2021-10-17 Clark Kentucky 21049 5098 36
1824632 1824632 2021-10-17 Clark Missouri 29045 976 12
1824879 1824879 2021-10-17 Clark Nevada 32003 334318 5835
1825185 1825185 2021-10-17 Clark Ohio 39023 19599 349
1825586 1825586 2021-10-17 Clark South Dakota 46025 502 5
1826177 1826177 2021-10-17 Clark Washington 53011 39759 461
1826275 1826275 2021-10-17 Clark Wisconsin 55019 4692 76
1819983 1819983 2021-10-16 Clark Arkansas 5019 3187 54
1820437 1820437 2021-10-16 Clark Idaho 16033 77 0
1820476 1820476 2021-10-16 Clark Illinois 17023 2649 47
1820577 1820577 2021-10-16 Clark Indiana 18019 18405 258
1820772 1820772 2021-10-16 Clark Kansas 20025 318 7
1820889 1820889 2021-10-16 Clark Kentucky 21049 5098 36
1821383 1821383 2021-10-16 Clark Missouri 29045 975 12
1821630 1821630 2021-10-16 Clark Nevada 32003 334318 5835
1821936 1821936 2021-10-16 Clark Ohio 39023 19567 349
1822337 1822337 2021-10-16 Clark South Dakota 46025 502 5
1822928 1822928 2021-10-16 Clark Washington 53011 39759 461
1823026 1823026 2021-10-16 Clark Wisconsin 55019 4663 76
1816734 1816734 2021-10-15 Clark Arkansas 5019 3180 54
1817188 1817188 2021-10-15 Clark Idaho 16033 77 0
1817227 1817227 2021-10-15 Clark Illinois 17023 2649 47
1817328 1817328 2021-10-15 Clark Indiana 18019 18405 258

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