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 |
---|---|---|---|---|---|---|---|
1817523 | 1817523 | 2021-10-15 | Clark | Kansas | 20025 | 318 | 7 |
1817640 | 1817640 | 2021-10-15 | Clark | Kentucky | 21049 | 5098 | 36 |
1818134 | 1818134 | 2021-10-15 | Clark | Missouri | 29045 | 972 | 12 |
1818381 | 1818381 | 2021-10-15 | Clark | Nevada | 32003 | 334318 | 5835 |
1818687 | 1818687 | 2021-10-15 | Clark | Ohio | 39023 | 19513 | 349 |
1819088 | 1819088 | 2021-10-15 | Clark | South Dakota | 46025 | 502 | 5 |
1819679 | 1819679 | 2021-10-15 | Clark | Washington | 53011 | 39759 | 461 |
1819777 | 1819777 | 2021-10-15 | Clark | Wisconsin | 55019 | 4663 | 76 |
1813486 | 1813486 | 2021-10-14 | Clark | Arkansas | 5019 | 3174 | 54 |
1813940 | 1813940 | 2021-10-14 | Clark | Idaho | 16033 | 77 | 0 |
1813979 | 1813979 | 2021-10-14 | Clark | Illinois | 17023 | 2640 | 47 |
1814080 | 1814080 | 2021-10-14 | Clark | Indiana | 18019 | 18358 | 258 |
1814275 | 1814275 | 2021-10-14 | Clark | Kansas | 20025 | 318 | 7 |
1814392 | 1814392 | 2021-10-14 | Clark | Kentucky | 21049 | 5079 | 36 |
1814885 | 1814885 | 2021-10-14 | Clark | Missouri | 29045 | 972 | 12 |
1815132 | 1815132 | 2021-10-14 | Clark | Nevada | 32003 | 334036 | 5830 |
1815438 | 1815438 | 2021-10-14 | Clark | Ohio | 39023 | 19446 | 346 |
1815839 | 1815839 | 2021-10-14 | Clark | South Dakota | 46025 | 501 | 5 |
1816430 | 1816430 | 2021-10-14 | Clark | Washington | 53011 | 39591 | 457 |
1816528 | 1816528 | 2021-10-14 | Clark | Wisconsin | 55019 | 4663 | 76 |
1810237 | 1810237 | 2021-10-13 | Clark | Arkansas | 5019 | 3169 | 54 |
1810691 | 1810691 | 2021-10-13 | Clark | Idaho | 16033 | 77 | 0 |
1810730 | 1810730 | 2021-10-13 | Clark | Illinois | 17023 | 2638 | 47 |
1810831 | 1810831 | 2021-10-13 | Clark | Indiana | 18019 | 18315 | 256 |
1811026 | 1811026 | 2021-10-13 | Clark | Kansas | 20025 | 318 | 7 |
1811143 | 1811143 | 2021-10-13 | Clark | Kentucky | 21049 | 5065 | 36 |
1811637 | 1811637 | 2021-10-13 | Clark | Missouri | 29045 | 972 | 12 |
1811884 | 1811884 | 2021-10-13 | Clark | Nevada | 32003 | 333608 | 5801 |
1812190 | 1812190 | 2021-10-13 | Clark | Ohio | 39023 | 19372 | 346 |
1812591 | 1812591 | 2021-10-13 | Clark | South Dakota | 46025 | 500 | 5 |
1813182 | 1813182 | 2021-10-13 | Clark | Washington | 53011 | 39431 | 455 |
1813280 | 1813280 | 2021-10-13 | Clark | Wisconsin | 55019 | 4651 | 76 |
1806988 | 1806988 | 2021-10-12 | Clark | Arkansas | 5019 | 3167 | 54 |
1807442 | 1807442 | 2021-10-12 | Clark | Idaho | 16033 | 77 | 0 |
1807481 | 1807481 | 2021-10-12 | Clark | Illinois | 17023 | 2635 | 47 |
1807582 | 1807582 | 2021-10-12 | Clark | Indiana | 18019 | 18279 | 256 |
1807777 | 1807777 | 2021-10-12 | Clark | Kansas | 20025 | 318 | 7 |
1807894 | 1807894 | 2021-10-12 | Clark | Kentucky | 21049 | 5046 | 36 |
1808388 | 1808388 | 2021-10-12 | Clark | Missouri | 29045 | 971 | 12 |
1808635 | 1808635 | 2021-10-12 | Clark | Nevada | 32003 | 333186 | 5781 |
1808941 | 1808941 | 2021-10-12 | Clark | Ohio | 39023 | 19308 | 346 |
1809342 | 1809342 | 2021-10-12 | Clark | South Dakota | 46025 | 498 | 5 |
1809933 | 1809933 | 2021-10-12 | Clark | Washington | 53011 | 39242 | 448 |
1810031 | 1810031 | 2021-10-12 | Clark | Wisconsin | 55019 | 4636 | 76 |
1803737 | 1803737 | 2021-10-11 | Clark | Arkansas | 5019 | 3159 | 54 |
1804191 | 1804191 | 2021-10-11 | Clark | Idaho | 16033 | 77 | 0 |
1804230 | 1804230 | 2021-10-11 | Clark | Illinois | 17023 | 2626 | 47 |
1804331 | 1804331 | 2021-10-11 | Clark | Indiana | 18019 | 18267 | 254 |
1804526 | 1804526 | 2021-10-11 | Clark | Kansas | 20025 | 318 | 7 |
1804643 | 1804643 | 2021-10-11 | Clark | Kentucky | 21049 | 5034 | 36 |
1805137 | 1805137 | 2021-10-11 | Clark | Missouri | 29045 | 970 | 12 |
1805384 | 1805384 | 2021-10-11 | Clark | Nevada | 32003 | 332667 | 5765 |
1805691 | 1805691 | 2021-10-11 | Clark | Ohio | 39023 | 19260 | 341 |
1806092 | 1806092 | 2021-10-11 | Clark | South Dakota | 46025 | 496 | 5 |
1806684 | 1806684 | 2021-10-11 | Clark | Washington | 53011 | 39091 | 448 |
1806782 | 1806782 | 2021-10-11 | Clark | Wisconsin | 55019 | 4627 | 75 |
1800488 | 1800488 | 2021-10-10 | Clark | Arkansas | 5019 | 3157 | 54 |
1800942 | 1800942 | 2021-10-10 | Clark | Idaho | 16033 | 77 | 0 |
1800981 | 1800981 | 2021-10-10 | Clark | Illinois | 17023 | 2626 | 47 |
1801082 | 1801082 | 2021-10-10 | Clark | Indiana | 18019 | 18169 | 254 |
1801277 | 1801277 | 2021-10-10 | Clark | Kansas | 20025 | 318 | 7 |
1801394 | 1801394 | 2021-10-10 | Clark | Kentucky | 21049 | 4975 | 34 |
1801888 | 1801888 | 2021-10-10 | Clark | Missouri | 29045 | 970 | 12 |
1802135 | 1802135 | 2021-10-10 | Clark | Nevada | 32003 | 331430 | 5743 |
1802441 | 1802441 | 2021-10-10 | Clark | Ohio | 39023 | 19241 | 341 |
1802842 | 1802842 | 2021-10-10 | Clark | South Dakota | 46025 | 496 | 5 |
1803433 | 1803433 | 2021-10-10 | Clark | Washington | 53011 | 38703 | 444 |
1803531 | 1803531 | 2021-10-10 | Clark | Wisconsin | 55019 | 4592 | 73 |
1797239 | 1797239 | 2021-10-09 | Clark | Arkansas | 5019 | 3155 | 52 |
1797693 | 1797693 | 2021-10-09 | Clark | Idaho | 16033 | 77 | 0 |
1797732 | 1797732 | 2021-10-09 | Clark | Illinois | 17023 | 2626 | 47 |
1797833 | 1797833 | 2021-10-09 | Clark | Indiana | 18019 | 18169 | 254 |
1798028 | 1798028 | 2021-10-09 | Clark | Kansas | 20025 | 318 | 7 |
1798145 | 1798145 | 2021-10-09 | Clark | Kentucky | 21049 | 4975 | 34 |
1798639 | 1798639 | 2021-10-09 | Clark | Missouri | 29045 | 970 | 12 |
1798886 | 1798886 | 2021-10-09 | Clark | Nevada | 32003 | 331430 | 5743 |
1799192 | 1799192 | 2021-10-09 | Clark | Ohio | 39023 | 19182 | 341 |
1799593 | 1799593 | 2021-10-09 | Clark | South Dakota | 46025 | 496 | 5 |
1800184 | 1800184 | 2021-10-09 | Clark | Washington | 53011 | 38703 | 444 |
1800282 | 1800282 | 2021-10-09 | Clark | Wisconsin | 55019 | 4592 | 73 |
1793990 | 1793990 | 2021-10-08 | Clark | Arkansas | 5019 | 3152 | 52 |
1794444 | 1794444 | 2021-10-08 | Clark | Idaho | 16033 | 77 | 0 |
1794483 | 1794483 | 2021-10-08 | Clark | Illinois | 17023 | 2626 | 47 |
1794584 | 1794584 | 2021-10-08 | Clark | Indiana | 18019 | 18169 | 254 |
1794779 | 1794779 | 2021-10-08 | Clark | Kansas | 20025 | 318 | 7 |
1794896 | 1794896 | 2021-10-08 | Clark | Kentucky | 21049 | 4975 | 34 |
1795390 | 1795390 | 2021-10-08 | Clark | Missouri | 29045 | 970 | 12 |
1795637 | 1795637 | 2021-10-08 | Clark | Nevada | 32003 | 331430 | 5743 |
1795943 | 1795943 | 2021-10-08 | Clark | Ohio | 39023 | 19138 | 341 |
1796344 | 1796344 | 2021-10-08 | Clark | South Dakota | 46025 | 496 | 5 |
1796935 | 1796935 | 2021-10-08 | Clark | Washington | 53011 | 38703 | 444 |
1797033 | 1797033 | 2021-10-08 | Clark | Wisconsin | 55019 | 4592 | 73 |
1790742 | 1790742 | 2021-10-07 | Clark | Arkansas | 5019 | 3149 | 52 |
1791196 | 1791196 | 2021-10-07 | Clark | Idaho | 16033 | 76 | 0 |
1791235 | 1791235 | 2021-10-07 | Clark | Illinois | 17023 | 2610 | 47 |
1791336 | 1791336 | 2021-10-07 | Clark | Indiana | 18019 | 18098 | 251 |
1791531 | 1791531 | 2021-10-07 | Clark | Kansas | 20025 | 318 | 7 |
1791648 | 1791648 | 2021-10-07 | Clark | Kentucky | 21049 | 4952 | 32 |
1792141 | 1792141 | 2021-10-07 | Clark | Missouri | 29045 | 970 | 12 |
1792388 | 1792388 | 2021-10-07 | Clark | Nevada | 32003 | 330961 | 5739 |
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);