ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where "date" is on date 2020-03-15 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 |
---|---|---|---|---|---|---|---|
2565 | 2565 | 2020-03-15 | Albany | New York | 36001 | 11 | 0 |
2566 | 2566 | 2020-03-15 | Broome | New York | 36007 | 1 | 0 |
2567 | 2567 | 2020-03-15 | Delaware | New York | 36025 | 1 | 0 |
2568 | 2568 | 2020-03-15 | Dutchess | New York | 36027 | 7 | 0 |
2569 | 2569 | 2020-03-15 | Erie | New York | 36029 | 3 | 0 |
2570 | 2570 | 2020-03-15 | Greene | New York | 36039 | 2 | 0 |
2571 | 2571 | 2020-03-15 | Herkimer | New York | 36043 | 1 | 0 |
2572 | 2572 | 2020-03-15 | Monroe | New York | 36055 | 2 | 0 |
2573 | 2573 | 2020-03-15 | Montgomery | New York | 36057 | 1 | 0 |
2574 | 2574 | 2020-03-15 | Nassau | New York | 36059 | 98 | 0 |
2575 | 2575 | 2020-03-15 | New York City | New York | 330 | 5 | |
2576 | 2576 | 2020-03-15 | Orange | New York | 36071 | 6 | 0 |
2577 | 2577 | 2020-03-15 | Putnam | New York | 36079 | 2 | 0 |
2578 | 2578 | 2020-03-15 | Rockland | New York | 36087 | 13 | 1 |
2579 | 2579 | 2020-03-15 | Saratoga | New York | 36091 | 3 | 0 |
2580 | 2580 | 2020-03-15 | Schenectady | New York | 36093 | 2 | 0 |
2581 | 2581 | 2020-03-15 | Suffolk | New York | 36103 | 47 | 0 |
2582 | 2582 | 2020-03-15 | Tioga | New York | 36107 | 1 | 0 |
2583 | 2583 | 2020-03-15 | Tompkins | New York | 36109 | 1 | 0 |
2584 | 2584 | 2020-03-15 | Ulster | New York | 36111 | 5 | 0 |
2585 | 2585 | 2020-03-15 | Westchester | New York | 36119 | 195 | 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);