ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 153 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
701670 | 701670 | 2020-11-05 | Yates | New York | 36123 | 153 | 6 |
691906 | 691906 | 2020-11-02 | Lewis | New York | 36049 | 153 | 5 |
627051 | 627051 | 2020-10-13 | Wyoming | New York | 36121 | 153 | 5 |
533033 | 533033 | 2020-09-14 | Clinton | New York | 36019 | 153 | 5 |
529798 | 529798 | 2020-09-13 | Clinton | New York | 36019 | 153 | 5 |
500692 | 500692 | 2020-09-04 | Essex | New York | 36031 | 153 | 7 |
378114 | 378114 | 2020-07-28 | Cattaraugus | New York | 36009 | 153 | 5 |
374898 | 374898 | 2020-07-27 | Cattaraugus | New York | 36009 | 153 | 5 |
346045 | 346045 | 2020-07-18 | Chemung | New York | 36015 | 153 | 5 |
339665 | 339665 | 2020-07-16 | Livingston | New York | 36051 | 153 | 4 |
102688 | 102688 | 2020-04-30 | Genesee | New York | 36037 | 153 | 2 |
60745 | 60745 | 2020-04-15 | Broome | New York | 36007 | 153 | 6 |
37090 | 37090 | 2020-04-06 | Saratoga | New York | 36091 | 153 | 1 |
11744 | 11744 | 2020-03-25 | Dutchess | New York | 36027 | 153 | 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);