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 rowid
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 |
2385 | 2385 | 2020-03-15 | Clay | Florida | 12019 | 3 | 0 |
2820 | 2820 | 2020-03-16 | Clay | Florida | 12019 | 3 | 0 |
3304 | 3304 | 2020-03-17 | Clay | Florida | 12019 | 4 | 0 |
3861 | 3861 | 2020-03-18 | Clay | Florida | 12019 | 4 | 1 |
4526 | 4526 | 2020-03-19 | Clay | Florida | 12019 | 4 | 1 |
5305 | 5305 | 2020-03-20 | Clay | Florida | 12019 | 4 | 1 |
5586 | 5586 | 2020-03-20 | Clay | Minnesota | 27027 | 1 | 0 |
6233 | 6233 | 2020-03-21 | Clay | Florida | 12019 | 6 | 1 |
6554 | 6554 | 2020-03-21 | Clay | Minnesota | 27027 | 1 | 0 |
6579 | 6579 | 2020-03-21 | Clay | Mississippi | 28025 | 1 | 0 |
7270 | 7270 | 2020-03-22 | Clay | Florida | 12019 | 7 | 1 |
7635 | 7635 | 2020-03-22 | Clay | Minnesota | 27027 | 2 | 0 |
7662 | 7662 | 2020-03-22 | Clay | Mississippi | 28025 | 1 | 0 |
8416 | 8416 | 2020-03-23 | Clay | Florida | 12019 | 8 | 2 |
8813 | 8813 | 2020-03-23 | Clay | Minnesota | 27027 | 2 | 0 |
8842 | 8842 | 2020-03-23 | Clay | Mississippi | 28025 | 1 | 0 |
8900 | 8900 | 2020-03-23 | Clay | Missouri | 29047 | 3 | 0 |
9661 | 9661 | 2020-03-24 | Clay | Florida | 12019 | 10 | 2 |
10108 | 10108 | 2020-03-24 | Clay | Minnesota | 27027 | 3 | 0 |
10138 | 10138 | 2020-03-24 | Clay | Mississippi | 28025 | 1 | 0 |
10199 | 10199 | 2020-03-24 | Clay | Missouri | 29047 | 3 | 0 |
10844 | 10844 | 2020-03-25 | Clay | Alabama | 1027 | 1 | 0 |
11035 | 11035 | 2020-03-25 | Clay | Florida | 12019 | 16 | 2 |
11525 | 11525 | 2020-03-25 | Clay | Minnesota | 27027 | 3 | 0 |
11558 | 11558 | 2020-03-25 | Clay | Mississippi | 28025 | 1 | 0 |
11620 | 11620 | 2020-03-25 | Clay | Missouri | 29047 | 5 | 0 |
12378 | 12378 | 2020-03-26 | Clay | Alabama | 1027 | 1 | 0 |
12583 | 12583 | 2020-03-26 | Clay | Florida | 12019 | 20 | 4 |
13113 | 13113 | 2020-03-26 | Clay | Minnesota | 27027 | 4 | 0 |
13150 | 13150 | 2020-03-26 | Clay | Mississippi | 28025 | 1 | 0 |
13218 | 13218 | 2020-03-26 | Clay | Missouri | 29047 | 5 | 0 |
14036 | 14036 | 2020-03-27 | Clay | Alabama | 1027 | 1 | 0 |
14252 | 14252 | 2020-03-27 | Clay | Florida | 12019 | 22 | 4 |
14581 | 14581 | 2020-03-27 | Clay | Kansas | 20027 | 1 | 0 |
14826 | 14826 | 2020-03-27 | Clay | Minnesota | 27027 | 4 | 0 |
14866 | 14866 | 2020-03-27 | Clay | Mississippi | 28025 | 2 | 0 |
14943 | 14943 | 2020-03-27 | Clay | Missouri | 29047 | 9 | 0 |
15814 | 15814 | 2020-03-28 | Clay | Alabama | 1027 | 2 | 0 |
16036 | 16036 | 2020-03-28 | Clay | Florida | 12019 | 26 | 4 |
16388 | 16388 | 2020-03-28 | Clay | Kansas | 20027 | 1 | 0 |
16647 | 16647 | 2020-03-28 | Clay | Minnesota | 27027 | 4 | 0 |
16689 | 16689 | 2020-03-28 | Clay | Mississippi | 28025 | 2 | 0 |
16767 | 16767 | 2020-03-28 | Clay | Missouri | 29047 | 10 | 0 |
17697 | 17697 | 2020-03-29 | Clay | Alabama | 1027 | 2 | 0 |
17928 | 17928 | 2020-03-29 | Clay | Florida | 12019 | 35 | 4 |
18168 | 18168 | 2020-03-29 | Clay | Indiana | 18021 | 1 | 0 |
18293 | 18293 | 2020-03-29 | Clay | Kansas | 20027 | 1 | 0 |
18563 | 18563 | 2020-03-29 | Clay | Minnesota | 27027 | 4 | 0 |
18611 | 18611 | 2020-03-29 | Clay | Mississippi | 28025 | 2 | 0 |
18689 | 18689 | 2020-03-29 | Clay | Missouri | 29047 | 11 | 0 |
19215 | 19215 | 2020-03-29 | Clay | South Dakota | 46027 | 2 | 0 |
19667 | 19667 | 2020-03-30 | Clay | Alabama | 1027 | 2 | 0 |
19908 | 19908 | 2020-03-30 | Clay | Florida | 12019 | 34 | 5 |
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 |
20583 | 20583 | 2020-03-30 | Clay | Minnesota | 27027 | 4 | 0 |
20635 | 20635 | 2020-03-30 | Clay | Mississippi | 28025 | 4 | 0 |
20714 | 20714 | 2020-03-30 | Clay | Missouri | 29047 | 13 | 0 |
21267 | 21267 | 2020-03-30 | Clay | South Dakota | 46027 | 3 | 0 |
21739 | 21739 | 2020-03-31 | Clay | Alabama | 1027 | 2 | 0 |
21986 | 21986 | 2020-03-31 | Clay | Florida | 12019 | 41 | 5 |
22059 | 22059 | 2020-03-31 | Clay | Georgia | 13061 | 5 | 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 |
22697 | 22697 | 2020-03-31 | Clay | Minnesota | 27027 | 6 | 0 |
22752 | 22752 | 2020-03-31 | Clay | Mississippi | 28025 | 4 | 0 |
22832 | 22832 | 2020-03-31 | Clay | Missouri | 29047 | 16 | 0 |
23059 | 23059 | 2020-03-31 | Clay | North Carolina | 37043 | 1 | 0 |
23405 | 23405 | 2020-03-31 | Clay | South Dakota | 46027 | 3 | 0 |
23893 | 23893 | 2020-04-01 | Clay | Alabama | 1027 | 3 | 0 |
24145 | 24145 | 2020-04-01 | Clay | Florida | 12019 | 53 | 5 |
24222 | 24222 | 2020-04-01 | Clay | Georgia | 13061 | 5 | 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 |
24877 | 24877 | 2020-04-01 | Clay | Minnesota | 27027 | 7 | 0 |
24935 | 24935 | 2020-04-01 | Clay | Mississippi | 28025 | 5 | 0 |
25018 | 25018 | 2020-04-01 | Clay | Missouri | 29047 | 21 | 0 |
25253 | 25253 | 2020-04-01 | Clay | North Carolina | 37043 | 1 | 0 |
25603 | 25603 | 2020-04-01 | Clay | South Dakota | 46027 | 3 | 0 |
25638 | 25638 | 2020-04-01 | Clay | Tennessee | 47027 | 1 | 0 |
25731 | 25731 | 2020-04-01 | Clay | Texas | 48077 | 1 | 0 |
26114 | 26114 | 2020-04-02 | Clay | Alabama | 1027 | 7 | 0 |
26375 | 26375 | 2020-04-02 | Clay | Florida | 12019 | 58 | 6 |
26453 | 26453 | 2020-04-02 | Clay | Georgia | 13061 | 7 | 0 |
26677 | 26677 | 2020-04-02 | Clay | Indiana | 18021 | 1 | 0 |
26766 | 26766 | 2020-04-02 | Clay | Iowa | 19041 | 2 | 0 |
26821 | 26821 | 2020-04-02 | Clay | Kansas | 20027 | 1 | 0 |
27130 | 27130 | 2020-04-02 | Clay | Minnesota | 27027 | 8 | 0 |
27189 | 27189 | 2020-04-02 | Clay | Mississippi | 28025 | 7 | 0 |
27273 | 27273 | 2020-04-02 | Clay | Missouri | 29047 | 23 | 0 |
27514 | 27514 | 2020-04-02 | Clay | North Carolina | 37043 | 2 | 0 |
27879 | 27879 | 2020-04-02 | Clay | South Dakota | 46027 | 3 | 0 |
27916 | 27916 | 2020-04-02 | Clay | Tennessee | 47027 | 1 | 0 |
28011 | 28011 | 2020-04-02 | Clay | Texas | 48077 | 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);