ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where county = "Clay" and "date" is on date 2020-04-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
92504 | 92504 | 2020-04-27 | Clay | Alabama | 1027 | 19 | 1 |
92596 | 92596 | 2020-04-27 | Clay | Arkansas | 5021 | 2 | 0 |
92793 | 92793 | 2020-04-27 | Clay | Florida | 12019 | 271 | 14 |
92881 | 92881 | 2020-04-27 | Clay | Georgia | 13061 | 20 | 2 |
93059 | 93059 | 2020-04-27 | Clay | Illinois | 17025 | 2 | 0 |
93155 | 93155 | 2020-04-27 | Clay | Indiana | 18021 | 19 | 1 |
93255 | 93255 | 2020-04-27 | Clay | Iowa | 19041 | 3 | 0 |
93332 | 93332 | 2020-04-27 | Clay | Kansas | 20027 | 4 | 1 |
93423 | 93423 | 2020-04-27 | Clay | Kentucky | 21051 | 1 | 0 |
93725 | 93725 | 2020-04-27 | Clay | Minnesota | 27027 | 131 | 9 |
93803 | 93803 | 2020-04-27 | Clay | Mississippi | 28025 | 31 | 2 |
93894 | 93894 | 2020-04-27 | Clay | Missouri | 29047 | 68 | 1 |
94010 | 94010 | 2020-04-27 | Clay | Nebraska | 31035 | 5 | 0 |
94213 | 94213 | 2020-04-27 | Clay | North Carolina | 37043 | 5 | 0 |
94639 | 94639 | 2020-04-27 | Clay | South Dakota | 46027 | 5 | 0 |
94689 | 94689 | 2020-04-27 | Clay | Tennessee | 47027 | 5 | 0 |
94801 | 94801 | 2020-04-27 | Clay | Texas | 48077 | 3 | 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);