ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where "date" is on date 2020-03-17 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3538 | 3538 | 2020-03-17 | Albany | New York | 36001 | 23 | 0 |
3539 | 3539 | 2020-03-17 | Allegany | New York | 36003 | 2 | 0 |
3540 | 3540 | 2020-03-17 | Broome | New York | 36007 | 1 | 0 |
3541 | 3541 | 2020-03-17 | Clinton | New York | 36019 | 1 | 0 |
3542 | 3542 | 2020-03-17 | Delaware | New York | 36025 | 1 | 0 |
3543 | 3543 | 2020-03-17 | Dutchess | New York | 36027 | 16 | 0 |
3544 | 3544 | 2020-03-17 | Erie | New York | 36029 | 7 | 0 |
3545 | 3545 | 2020-03-17 | Greene | New York | 36039 | 2 | 0 |
3546 | 3546 | 2020-03-17 | Herkimer | New York | 36043 | 1 | 0 |
3547 | 3547 | 2020-03-17 | Monroe | New York | 36055 | 11 | 0 |
3548 | 3548 | 2020-03-17 | Montgomery | New York | 36057 | 1 | 0 |
3549 | 3549 | 2020-03-17 | Nassau | New York | 36059 | 131 | 2 |
3550 | 3550 | 2020-03-17 | New York City | New York | 646 | 11 | |
3551 | 3551 | 2020-03-17 | Onondaga | New York | 36067 | 2 | 0 |
3552 | 3552 | 2020-03-17 | Ontario | New York | 36069 | 1 | 0 |
3553 | 3553 | 2020-03-17 | Orange | New York | 36071 | 15 | 0 |
3554 | 3554 | 2020-03-17 | Putnam | New York | 36079 | 2 | 0 |
3555 | 3555 | 2020-03-17 | Rensselaer | New York | 36083 | 1 | 0 |
3556 | 3556 | 2020-03-17 | Rockland | New York | 36087 | 22 | 2 |
3557 | 3557 | 2020-03-17 | Saratoga | New York | 36091 | 9 | 0 |
3558 | 3558 | 2020-03-17 | Schenectady | New York | 36093 | 5 | 0 |
3559 | 3559 | 2020-03-17 | Suffolk | New York | 36103 | 84 | 3 |
3560 | 3560 | 2020-03-17 | Sullivan | New York | 36105 | 1 | 0 |
3561 | 3561 | 2020-03-17 | Tioga | New York | 36107 | 1 | 0 |
3562 | 3562 | 2020-03-17 | Tompkins | New York | 36109 | 1 | 0 |
3563 | 3563 | 2020-03-17 | Ulster | New York | 36111 | 8 | 0 |
3564 | 3564 | 2020-03-17 | Westchester | New York | 36119 | 379 | 0 |
3565 | 3565 | 2020-03-17 | Wyoming | New York | 36121 | 1 | 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);