ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 205 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
730848 | 730848 | 2020-11-14 | Seneca | New York | 36099 | 205 | 2 |
698380 | 698380 | 2020-11-04 | Delaware | New York | 36025 | 205 | 6 |
691940 | 691940 | 2020-11-02 | Wyoming | New York | 36121 | 205 | 5 |
672437 | 672437 | 2020-10-27 | Essex | New York | 36031 | 205 | 14 |
669195 | 669195 | 2020-10-26 | Essex | New York | 36031 | 205 | 14 |
665951 | 665951 | 2020-10-25 | Essex | New York | 36031 | 205 | 14 |
643225 | 643225 | 2020-10-18 | Allegany | New York | 36003 | 205 | 6 |
594582 | 594582 | 2020-10-03 | Cortland | New York | 36023 | 205 | 1 |
565405 | 565405 | 2020-09-24 | Cayuga | New York | 36011 | 205 | 2 |
565424 | 565424 | 2020-09-24 | Livingston | New York | 36051 | 205 | 6 |
497450 | 497450 | 2020-09-03 | Chemung | New York | 36015 | 205 | 2 |
494217 | 494217 | 2020-09-02 | Chemung | New York | 36015 | 205 | 2 |
490983 | 490983 | 2020-09-01 | Chemung | New York | 36015 | 205 | 2 |
487747 | 487747 | 2020-08-31 | Cattaraugus | New York | 36009 | 205 | 6 |
381335 | 381335 | 2020-07-29 | Chenango | New York | 36017 | 205 | 3 |
326929 | 326929 | 2020-07-12 | Wayne | New York | 36117 | 205 | 1 |
210918 | 210918 | 2020-06-05 | Genesee | New York | 36037 | 205 | 6 |
207836 | 207836 | 2020-06-04 | Genesee | New York | 36037 | 205 | 6 |
201706 | 201706 | 2020-06-02 | St. Lawrence | New York | 36089 | 205 | 2 |
198632 | 198632 | 2020-06-01 | St. Lawrence | New York | 36089 | 205 | 2 |
189412 | 189412 | 2020-05-29 | Ontario | New York | 36069 | 205 | 17 |
177206 | 177206 | 2020-05-25 | Orleans | New York | 36073 | 205 | 23 |
108409 | 108409 | 2020-05-02 | Columbia | New York | 36021 | 205 | 16 |
77293 | 77293 | 2020-04-21 | Broome | New York | 36007 | 205 | 7 |
18823 | 18823 | 2020-03-29 | Albany | New York | 36001 | 205 | 1 |
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);