ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where county = "Clay", deaths = 3 and fips = 21051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
316549 | 316549 | 2020-07-09 | Clay | Kentucky | 21051 | 80 | 3 |
313375 | 313375 | 2020-07-08 | Clay | Kentucky | 21051 | 79 | 3 |
310205 | 310205 | 2020-07-07 | Clay | Kentucky | 21051 | 76 | 3 |
307037 | 307037 | 2020-07-06 | Clay | Kentucky | 21051 | 72 | 3 |
303870 | 303870 | 2020-07-05 | Clay | Kentucky | 21051 | 68 | 3 |
300706 | 300706 | 2020-07-04 | Clay | Kentucky | 21051 | 68 | 3 |
297544 | 297544 | 2020-07-03 | Clay | Kentucky | 21051 | 68 | 3 |
294386 | 294386 | 2020-07-02 | Clay | Kentucky | 21051 | 64 | 3 |
291232 | 291232 | 2020-07-01 | Clay | Kentucky | 21051 | 62 | 3 |
288082 | 288082 | 2020-06-30 | Clay | Kentucky | 21051 | 59 | 3 |
284933 | 284933 | 2020-06-29 | Clay | Kentucky | 21051 | 53 | 3 |
281787 | 281787 | 2020-06-28 | Clay | Kentucky | 21051 | 53 | 3 |
278639 | 278639 | 2020-06-27 | Clay | Kentucky | 21051 | 53 | 3 |
275491 | 275491 | 2020-06-26 | Clay | Kentucky | 21051 | 46 | 3 |
272348 | 272348 | 2020-06-25 | Clay | Kentucky | 21051 | 44 | 3 |
269212 | 269212 | 2020-06-24 | Clay | Kentucky | 21051 | 39 | 3 |
266079 | 266079 | 2020-06-23 | Clay | Kentucky | 21051 | 37 | 3 |
262952 | 262952 | 2020-06-22 | Clay | Kentucky | 21051 | 32 | 3 |
259823 | 259823 | 2020-06-21 | Clay | Kentucky | 21051 | 32 | 3 |
256697 | 256697 | 2020-06-20 | Clay | Kentucky | 21051 | 31 | 3 |
253577 | 253577 | 2020-06-19 | Clay | Kentucky | 21051 | 30 | 3 |
250462 | 250462 | 2020-06-18 | Clay | Kentucky | 21051 | 27 | 3 |
247350 | 247350 | 2020-06-17 | Clay | Kentucky | 21051 | 23 | 3 |
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);