ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where county = "Cattaraugus", deaths = 6 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
533028 | 533028 | 2020-09-14 | Cattaraugus | New York | 36009 | 242 | 6 |
529793 | 529793 | 2020-09-13 | Cattaraugus | New York | 36009 | 241 | 6 |
526556 | 526556 | 2020-09-12 | Cattaraugus | New York | 36009 | 239 | 6 |
523320 | 523320 | 2020-09-11 | Cattaraugus | New York | 36009 | 239 | 6 |
520084 | 520084 | 2020-09-10 | Cattaraugus | New York | 36009 | 236 | 6 |
516848 | 516848 | 2020-09-09 | Cattaraugus | New York | 36009 | 234 | 6 |
513613 | 513613 | 2020-09-08 | Cattaraugus | New York | 36009 | 233 | 6 |
510380 | 510380 | 2020-09-07 | Cattaraugus | New York | 36009 | 230 | 6 |
507147 | 507147 | 2020-09-06 | Cattaraugus | New York | 36009 | 229 | 6 |
503915 | 503915 | 2020-09-05 | Cattaraugus | New York | 36009 | 227 | 6 |
500681 | 500681 | 2020-09-04 | Cattaraugus | New York | 36009 | 223 | 6 |
497447 | 497447 | 2020-09-03 | Cattaraugus | New York | 36009 | 222 | 6 |
494214 | 494214 | 2020-09-02 | Cattaraugus | New York | 36009 | 216 | 6 |
490980 | 490980 | 2020-09-01 | Cattaraugus | New York | 36009 | 206 | 6 |
487747 | 487747 | 2020-08-31 | Cattaraugus | New York | 36009 | 205 | 6 |
484514 | 484514 | 2020-08-30 | Cattaraugus | New York | 36009 | 201 | 6 |
481279 | 481279 | 2020-08-29 | Cattaraugus | New York | 36009 | 197 | 6 |
478046 | 478046 | 2020-08-28 | Cattaraugus | New York | 36009 | 197 | 6 |
474813 | 474813 | 2020-08-27 | Cattaraugus | New York | 36009 | 188 | 6 |
471579 | 471579 | 2020-08-26 | Cattaraugus | New York | 36009 | 185 | 6 |
468347 | 468347 | 2020-08-25 | Cattaraugus | New York | 36009 | 184 | 6 |
465119 | 465119 | 2020-08-24 | Cattaraugus | New York | 36009 | 182 | 6 |
461890 | 461890 | 2020-08-23 | Cattaraugus | New York | 36009 | 180 | 6 |
458662 | 458662 | 2020-08-22 | Cattaraugus | New York | 36009 | 178 | 6 |
455434 | 455434 | 2020-08-21 | Cattaraugus | New York | 36009 | 174 | 6 |
452206 | 452206 | 2020-08-20 | Cattaraugus | New York | 36009 | 174 | 6 |
448978 | 448978 | 2020-08-19 | Cattaraugus | New York | 36009 | 173 | 6 |
445750 | 445750 | 2020-08-18 | Cattaraugus | New York | 36009 | 172 | 6 |
442524 | 442524 | 2020-08-17 | Cattaraugus | New York | 36009 | 171 | 6 |
439297 | 439297 | 2020-08-16 | Cattaraugus | New York | 36009 | 171 | 6 |
436072 | 436072 | 2020-08-15 | Cattaraugus | New York | 36009 | 170 | 6 |
432846 | 432846 | 2020-08-14 | Cattaraugus | New York | 36009 | 169 | 6 |
429620 | 429620 | 2020-08-13 | Cattaraugus | New York | 36009 | 169 | 6 |
426395 | 426395 | 2020-08-12 | Cattaraugus | New York | 36009 | 168 | 6 |
423172 | 423172 | 2020-08-11 | Cattaraugus | New York | 36009 | 168 | 6 |
419949 | 419949 | 2020-08-10 | Cattaraugus | New York | 36009 | 166 | 6 |
416729 | 416729 | 2020-08-09 | Cattaraugus | New York | 36009 | 165 | 6 |
413508 | 413508 | 2020-08-08 | Cattaraugus | New York | 36009 | 165 | 6 |
410288 | 410288 | 2020-08-07 | Cattaraugus | New York | 36009 | 164 | 6 |
407068 | 407068 | 2020-08-06 | Cattaraugus | New York | 36009 | 164 | 6 |
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);