ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where county = "Lewis", deaths = 39 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 |
---|---|---|---|---|---|---|---|
1954968 | 1954968 | 2021-11-26 | Lewis | New York | 36049 | 4145 | 39 |
1951717 | 1951717 | 2021-11-25 | Lewis | New York | 36049 | 4125 | 39 |
1948466 | 1948466 | 2021-11-24 | Lewis | New York | 36049 | 4101 | 39 |
1945215 | 1945215 | 2021-11-23 | Lewis | New York | 36049 | 4066 | 39 |
1941964 | 1941964 | 2021-11-22 | Lewis | New York | 36049 | 4045 | 39 |
1938714 | 1938714 | 2021-11-21 | Lewis | New York | 36049 | 4039 | 39 |
1935464 | 1935464 | 2021-11-20 | Lewis | New York | 36049 | 4028 | 39 |
1932214 | 1932214 | 2021-11-19 | Lewis | New York | 36049 | 4015 | 39 |
1928963 | 1928963 | 2021-11-18 | Lewis | New York | 36049 | 3990 | 39 |
1925713 | 1925713 | 2021-11-17 | Lewis | New York | 36049 | 3966 | 39 |
1922464 | 1922464 | 2021-11-16 | Lewis | New York | 36049 | 3941 | 39 |
1919214 | 1919214 | 2021-11-15 | Lewis | New York | 36049 | 3914 | 39 |
1915964 | 1915964 | 2021-11-14 | Lewis | New York | 36049 | 3904 | 39 |
1912714 | 1912714 | 2021-11-13 | Lewis | New York | 36049 | 3896 | 39 |
1909464 | 1909464 | 2021-11-12 | Lewis | New York | 36049 | 3876 | 39 |
1906215 | 1906215 | 2021-11-11 | Lewis | New York | 36049 | 3861 | 39 |
1902966 | 1902966 | 2021-11-10 | Lewis | New York | 36049 | 3847 | 39 |
1899716 | 1899716 | 2021-11-09 | Lewis | New York | 36049 | 3837 | 39 |
1896466 | 1896466 | 2021-11-08 | Lewis | New York | 36049 | 3813 | 39 |
1893216 | 1893216 | 2021-11-07 | Lewis | New York | 36049 | 3810 | 39 |
1889966 | 1889966 | 2021-11-06 | Lewis | New York | 36049 | 3804 | 39 |
1886716 | 1886716 | 2021-11-05 | Lewis | New York | 36049 | 3785 | 39 |
1883467 | 1883467 | 2021-11-04 | Lewis | New York | 36049 | 3769 | 39 |
1880218 | 1880218 | 2021-11-03 | Lewis | New York | 36049 | 3756 | 39 |
1876969 | 1876969 | 2021-11-02 | Lewis | New York | 36049 | 3739 | 39 |
1873720 | 1873720 | 2021-11-01 | Lewis | New York | 36049 | 3732 | 39 |
1870471 | 1870471 | 2021-10-31 | Lewis | New York | 36049 | 3726 | 39 |
1867222 | 1867222 | 2021-10-30 | Lewis | New York | 36049 | 3717 | 39 |
1863973 | 1863973 | 2021-10-29 | Lewis | New York | 36049 | 3704 | 39 |
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);