ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,908 rows where county = "Clay" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 18
- Florida 793
- Minnesota 785
- Mississippi 784
- Missouri 782
- Alabama 780
- Kansas 778
- Indiana 776
- South Dakota 776
- Georgia 775
- Iowa 774
- North Carolina 774
- Tennessee 773
- Texas 773
- Arkansas 768
- Nebraska 764
- Illinois 760
- Kentucky 755
- West Virginia 738
fips 18
county 1
- Clay · 13,908 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1413 | 1413 | 2020-03-12 | Clay | Florida | 12019 | 1 | 0 |
1679 | 1679 | 2020-03-13 | Clay | Florida | 12019 | 1 | 0 |
2001 | 2001 | 2020-03-14 | Clay | Florida | 12019 | 1 | 0 |
5586 | 5586 | 2020-03-20 | Clay | Minnesota | 27027 | 1 | 0 |
6554 | 6554 | 2020-03-21 | Clay | Minnesota | 27027 | 1 | 0 |
6579 | 6579 | 2020-03-21 | Clay | Mississippi | 28025 | 1 | 0 |
7662 | 7662 | 2020-03-22 | Clay | Mississippi | 28025 | 1 | 0 |
8842 | 8842 | 2020-03-23 | Clay | Mississippi | 28025 | 1 | 0 |
10138 | 10138 | 2020-03-24 | Clay | Mississippi | 28025 | 1 | 0 |
10844 | 10844 | 2020-03-25 | Clay | Alabama | 1027 | 1 | 0 |
11558 | 11558 | 2020-03-25 | Clay | Mississippi | 28025 | 1 | 0 |
12378 | 12378 | 2020-03-26 | Clay | Alabama | 1027 | 1 | 0 |
13150 | 13150 | 2020-03-26 | Clay | Mississippi | 28025 | 1 | 0 |
14036 | 14036 | 2020-03-27 | Clay | Alabama | 1027 | 1 | 0 |
14581 | 14581 | 2020-03-27 | Clay | Kansas | 20027 | 1 | 0 |
16388 | 16388 | 2020-03-28 | Clay | Kansas | 20027 | 1 | 0 |
18168 | 18168 | 2020-03-29 | Clay | Indiana | 18021 | 1 | 0 |
18293 | 18293 | 2020-03-29 | Clay | Kansas | 20027 | 1 | 0 |
19980 | 19980 | 2020-03-30 | Clay | Georgia | 13061 | 1 | 0 |
20174 | 20174 | 2020-03-30 | Clay | Indiana | 18021 | 1 | 0 |
20306 | 20306 | 2020-03-30 | Clay | Kansas | 20027 | 1 | 0 |
22268 | 22268 | 2020-03-31 | Clay | Indiana | 18021 | 1 | 0 |
22353 | 22353 | 2020-03-31 | Clay | Iowa | 19041 | 1 | 0 |
22404 | 22404 | 2020-03-31 | Clay | Kansas | 20027 | 1 | 0 |
23059 | 23059 | 2020-03-31 | Clay | North Carolina | 37043 | 1 | 0 |
24438 | 24438 | 2020-04-01 | Clay | Indiana | 18021 | 1 | 0 |
24525 | 24525 | 2020-04-01 | Clay | Iowa | 19041 | 1 | 0 |
24579 | 24579 | 2020-04-01 | Clay | Kansas | 20027 | 1 | 0 |
25253 | 25253 | 2020-04-01 | Clay | North Carolina | 37043 | 1 | 0 |
25638 | 25638 | 2020-04-01 | Clay | Tennessee | 47027 | 1 | 0 |
25731 | 25731 | 2020-04-01 | Clay | Texas | 48077 | 1 | 0 |
26677 | 26677 | 2020-04-02 | Clay | Indiana | 18021 | 1 | 0 |
26821 | 26821 | 2020-04-02 | Clay | Kansas | 20027 | 1 | 0 |
27916 | 27916 | 2020-04-02 | Clay | Tennessee | 47027 | 1 | 0 |
28011 | 28011 | 2020-04-02 | Clay | Texas | 48077 | 1 | 0 |
29135 | 29135 | 2020-04-03 | Clay | Kansas | 20027 | 1 | 0 |
30251 | 30251 | 2020-04-03 | Clay | Tennessee | 47027 | 1 | 0 |
30346 | 30346 | 2020-04-03 | Clay | Texas | 48077 | 1 | 0 |
31507 | 31507 | 2020-04-04 | Clay | Kansas | 20027 | 1 | 0 |
32642 | 32642 | 2020-04-04 | Clay | Tennessee | 47027 | 1 | 0 |
32739 | 32739 | 2020-04-04 | Clay | Texas | 48077 | 1 | 0 |
33920 | 33920 | 2020-04-05 | Clay | Kansas | 20027 | 1 | 0 |
35078 | 35078 | 2020-04-05 | Clay | Tennessee | 47027 | 1 | 0 |
35696 | 35696 | 2020-04-06 | Clay | Arkansas | 5021 | 1 | 0 |
36377 | 36377 | 2020-04-06 | Clay | Kansas | 20027 | 1 | 0 |
37554 | 37554 | 2020-04-06 | Clay | Tennessee | 47027 | 1 | 0 |
38185 | 38185 | 2020-04-07 | Clay | Arkansas | 5021 | 1 | 0 |
38879 | 38879 | 2020-04-07 | Clay | Kansas | 20027 | 1 | 0 |
40077 | 40077 | 2020-04-07 | Clay | Tennessee | 47027 | 1 | 0 |
40728 | 40728 | 2020-04-08 | Clay | Arkansas | 5021 | 1 | 0 |
41426 | 41426 | 2020-04-08 | Clay | Kansas | 20027 | 1 | 0 |
43300 | 43300 | 2020-04-09 | Clay | Arkansas | 5021 | 1 | 0 |
44002 | 44002 | 2020-04-09 | Clay | Kansas | 20027 | 1 | 0 |
45899 | 45899 | 2020-04-10 | Clay | Arkansas | 5021 | 1 | 0 |
46609 | 46609 | 2020-04-10 | Clay | Kansas | 20027 | 1 | 0 |
47219 | 47219 | 2020-04-10 | Clay | Nebraska | 31035 | 1 | 0 |
48529 | 48529 | 2020-04-11 | Clay | Arkansas | 5021 | 1 | 0 |
49243 | 49243 | 2020-04-11 | Clay | Kansas | 20027 | 1 | 0 |
51191 | 51191 | 2020-04-12 | Clay | Arkansas | 5021 | 1 | 0 |
51907 | 51907 | 2020-04-12 | Clay | Kansas | 20027 | 1 | 0 |
53869 | 53869 | 2020-04-13 | Clay | Arkansas | 5021 | 1 | 0 |
54589 | 54589 | 2020-04-13 | Clay | Kansas | 20027 | 1 | 0 |
56561 | 56561 | 2020-04-14 | Clay | Arkansas | 5021 | 1 | 0 |
57021 | 57021 | 2020-04-14 | Clay | Illinois | 17025 | 1 | 0 |
57282 | 57282 | 2020-04-14 | Clay | Kansas | 20027 | 1 | 0 |
59269 | 59269 | 2020-04-15 | Clay | Arkansas | 5021 | 1 | 0 |
59728 | 59728 | 2020-04-15 | Clay | Illinois | 17025 | 1 | 0 |
59990 | 59990 | 2020-04-15 | Clay | Kansas | 20027 | 1 | 0 |
61988 | 61988 | 2020-04-16 | Clay | Arkansas | 5021 | 1 | 0 |
62449 | 62449 | 2020-04-16 | Clay | Illinois | 17025 | 1 | 0 |
62711 | 62711 | 2020-04-16 | Clay | Kansas | 20027 | 1 | 0 |
64721 | 64721 | 2020-04-17 | Clay | Arkansas | 5021 | 1 | 0 |
65181 | 65181 | 2020-04-17 | Clay | Illinois | 17025 | 1 | 0 |
67469 | 67469 | 2020-04-18 | Clay | Arkansas | 5021 | 1 | 0 |
67929 | 67929 | 2020-04-18 | Clay | Illinois | 17025 | 1 | 0 |
70231 | 70231 | 2020-04-19 | Clay | Arkansas | 5021 | 1 | 0 |
70691 | 70691 | 2020-04-19 | Clay | Illinois | 17025 | 1 | 0 |
71040 | 71040 | 2020-04-19 | Clay | Kentucky | 21051 | 1 | 0 |
73000 | 73000 | 2020-04-20 | Clay | Arkansas | 5021 | 1 | 0 |
73461 | 73461 | 2020-04-20 | Clay | Illinois | 17025 | 1 | 0 |
73812 | 73812 | 2020-04-20 | Clay | Kentucky | 21051 | 1 | 0 |
75776 | 75776 | 2020-04-21 | Clay | Arkansas | 5021 | 1 | 0 |
76237 | 76237 | 2020-04-21 | Clay | Illinois | 17025 | 1 | 0 |
76592 | 76592 | 2020-04-21 | Clay | Kentucky | 21051 | 1 | 0 |
78560 | 78560 | 2020-04-22 | Clay | Arkansas | 5021 | 1 | 0 |
79377 | 79377 | 2020-04-22 | Clay | Kentucky | 21051 | 1 | 0 |
81353 | 81353 | 2020-04-23 | Clay | Arkansas | 5021 | 1 | 0 |
82174 | 82174 | 2020-04-23 | Clay | Kentucky | 21051 | 1 | 0 |
84153 | 84153 | 2020-04-24 | Clay | Arkansas | 5021 | 1 | 0 |
84977 | 84977 | 2020-04-24 | Clay | Kentucky | 21051 | 1 | 0 |
87786 | 87786 | 2020-04-25 | Clay | Kentucky | 21051 | 1 | 0 |
90602 | 90602 | 2020-04-26 | Clay | Kentucky | 21051 | 1 | 0 |
93423 | 93423 | 2020-04-27 | Clay | Kentucky | 21051 | 1 | 0 |
96256 | 96256 | 2020-04-28 | Clay | Kentucky | 21051 | 1 | 0 |
99102 | 99102 | 2020-04-29 | Clay | Kentucky | 21051 | 1 | 0 |
101954 | 101954 | 2020-04-30 | Clay | Kentucky | 21051 | 1 | 0 |
104815 | 104815 | 2020-05-01 | Clay | Kentucky | 21051 | 1 | 0 |
107680 | 107680 | 2020-05-02 | Clay | Kentucky | 21051 | 1 | 0 |
110551 | 110551 | 2020-05-03 | Clay | Kentucky | 21051 | 1 | 0 |
113428 | 113428 | 2020-05-04 | Clay | Kentucky | 21051 | 1 | 0 |
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);