ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 36059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176071 | 2176071 | 2022-02-02 | Nassau | New York | 36059 | 392191 | 3727 |
2172818 | 2172818 | 2022-02-01 | Nassau | New York | 36059 | 391526 | 3715 |
2169565 | 2169565 | 2022-01-31 | Nassau | New York | 36059 | 391056 | 3710 |
2166310 | 2166310 | 2022-01-30 | Nassau | New York | 36059 | 390879 | 3700 |
2163055 | 2163055 | 2022-01-29 | Nassau | New York | 36059 | 390398 | 3692 |
2159800 | 2159800 | 2022-01-28 | Nassau | New York | 36059 | 389697 | 3680 |
2156545 | 2156545 | 2022-01-27 | Nassau | New York | 36059 | 388880 | 3674 |
2153292 | 2153292 | 2022-01-26 | Nassau | New York | 36059 | 387829 | 3666 |
2150040 | 2150040 | 2022-01-25 | Nassau | New York | 36059 | 386676 | 3658 |
2146788 | 2146788 | 2022-01-24 | Nassau | New York | 36059 | 386031 | 3645 |
2143534 | 2143534 | 2022-01-23 | Nassau | New York | 36059 | 385225 | 3632 |
2140279 | 2140279 | 2022-01-22 | Nassau | New York | 36059 | 384123 | 3620 |
2137023 | 2137023 | 2022-01-21 | Nassau | New York | 36059 | 382820 | 3611 |
2133770 | 2133770 | 2022-01-20 | Nassau | New York | 36059 | 380937 | 3602 |
2130518 | 2130518 | 2022-01-19 | Nassau | New York | 36059 | 379090 | 3591 |
2127264 | 2127264 | 2022-01-18 | Nassau | New York | 36059 | 377485 | 3582 |
2124012 | 2124012 | 2022-01-17 | Nassau | New York | 36059 | 376298 | 3576 |
2120760 | 2120760 | 2022-01-16 | Nassau | New York | 36059 | 374615 | 3558 |
2117508 | 2117508 | 2022-01-15 | Nassau | New York | 36059 | 371873 | 3548 |
2114257 | 2114257 | 2022-01-14 | Nassau | New York | 36059 | 368719 | 3534 |
2111005 | 2111005 | 2022-01-13 | Nassau | New York | 36059 | 365524 | 3518 |
2107753 | 2107753 | 2022-01-12 | Nassau | New York | 36059 | 361426 | 3505 |
2104502 | 2104502 | 2022-01-11 | Nassau | New York | 36059 | 357439 | 3496 |
2101251 | 2101251 | 2022-01-10 | Nassau | New York | 36059 | 354032 | 3482 |
2098000 | 2098000 | 2022-01-09 | Nassau | New York | 36059 | 350265 | 3472 |
2094748 | 2094748 | 2022-01-08 | Nassau | New York | 36059 | 343597 | 3461 |
2091496 | 2091496 | 2022-01-07 | Nassau | New York | 36059 | 336980 | 3450 |
2088245 | 2088245 | 2022-01-06 | Nassau | New York | 36059 | 330870 | 3435 |
2084993 | 2084993 | 2022-01-05 | Nassau | New York | 36059 | 323887 | 3430 |
2081741 | 2081741 | 2022-01-04 | Nassau | New York | 36059 | 317907 | 3427 |
2078489 | 2078489 | 2022-01-03 | Nassau | New York | 36059 | 313601 | 3422 |
2075238 | 2075238 | 2022-01-02 | Nassau | New York | 36059 | 308406 | 3417 |
2071987 | 2071987 | 2022-01-01 | Nassau | New York | 36059 | 302366 | 3412 |
2068736 | 2068736 | 2021-12-31 | Nassau | New York | 36059 | 294650 | 3405 |
2065485 | 2065485 | 2021-12-30 | Nassau | New York | 36059 | 287304 | 3398 |
2062235 | 2062235 | 2021-12-29 | Nassau | New York | 36059 | 280443 | 3394 |
2058986 | 2058986 | 2021-12-28 | Nassau | New York | 36059 | 274475 | 3391 |
2055737 | 2055737 | 2021-12-27 | Nassau | New York | 36059 | 270952 | 3387 |
2052487 | 2052487 | 2021-12-26 | Nassau | New York | 36059 | 268422 | 3378 |
2049237 | 2049237 | 2021-12-25 | Nassau | New York | 36059 | 260301 | 3375 |
2045987 | 2045987 | 2021-12-24 | Nassau | New York | 36059 | 260301 | 3375 |
2042737 | 2042737 | 2021-12-23 | Nassau | New York | 36059 | 255844 | 3371 |
2039488 | 2039488 | 2021-12-22 | Nassau | New York | 36059 | 252162 | 3369 |
2036238 | 2036238 | 2021-12-21 | Nassau | New York | 36059 | 249694 | 3367 |
2032988 | 2032988 | 2021-12-20 | Nassau | New York | 36059 | 247739 | 3362 |
2029738 | 2029738 | 2021-12-19 | Nassau | New York | 36059 | 245792 | 3361 |
2026487 | 2026487 | 2021-12-18 | Nassau | New York | 36059 | 243769 | 3359 |
2023236 | 2023236 | 2021-12-17 | Nassau | New York | 36059 | 242013 | 3357 |
2019985 | 2019985 | 2021-12-16 | Nassau | New York | 36059 | 240073 | 3356 |
2016734 | 2016734 | 2021-12-15 | Nassau | New York | 36059 | 238425 | 3355 |
2013484 | 2013484 | 2021-12-14 | Nassau | New York | 36059 | 237345 | 3352 |
2010233 | 2010233 | 2021-12-13 | Nassau | New York | 36059 | 236612 | 3350 |
2006982 | 2006982 | 2021-12-12 | Nassau | New York | 36059 | 235824 | 3348 |
2003731 | 2003731 | 2021-12-11 | Nassau | New York | 36059 | 234881 | 3346 |
2000480 | 2000480 | 2021-12-10 | Nassau | New York | 36059 | 233888 | 3344 |
1997230 | 1997230 | 2021-12-09 | Nassau | New York | 36059 | 232962 | 3343 |
1993979 | 1993979 | 2021-12-08 | Nassau | New York | 36059 | 232051 | 3342 |
1990728 | 1990728 | 2021-12-07 | Nassau | New York | 36059 | 231282 | 3342 |
1987477 | 1987477 | 2021-12-06 | Nassau | New York | 36059 | 230523 | 3341 |
1984227 | 1984227 | 2021-12-05 | Nassau | New York | 36059 | 230124 | 3339 |
1980977 | 1980977 | 2021-12-04 | Nassau | New York | 36059 | 229198 | 3338 |
1977727 | 1977727 | 2021-12-03 | Nassau | New York | 36059 | 228510 | 3337 |
1974477 | 1974477 | 2021-12-02 | Nassau | New York | 36059 | 227654 | 3336 |
1971228 | 1971228 | 2021-12-01 | Nassau | New York | 36059 | 226764 | 3335 |
1967978 | 1967978 | 2021-11-30 | Nassau | New York | 36059 | 226135 | 3332 |
1964727 | 1964727 | 2021-11-29 | Nassau | New York | 36059 | 225634 | 3330 |
1961475 | 1961475 | 2021-11-28 | Nassau | New York | 36059 | 225182 | 3328 |
1958224 | 1958224 | 2021-11-27 | Nassau | New York | 36059 | 224617 | 3328 |
1954973 | 1954973 | 2021-11-26 | Nassau | New York | 36059 | 224379 | 3326 |
1951722 | 1951722 | 2021-11-25 | Nassau | New York | 36059 | 223988 | 3326 |
1948471 | 1948471 | 2021-11-24 | Nassau | New York | 36059 | 223456 | 3324 |
1945220 | 1945220 | 2021-11-23 | Nassau | New York | 36059 | 222982 | 3324 |
1941969 | 1941969 | 2021-11-22 | Nassau | New York | 36059 | 222638 | 3323 |
1938719 | 1938719 | 2021-11-21 | Nassau | New York | 36059 | 222290 | 3323 |
1935469 | 1935469 | 2021-11-20 | Nassau | New York | 36059 | 221880 | 3322 |
1932219 | 1932219 | 2021-11-19 | Nassau | New York | 36059 | 221437 | 3322 |
1928968 | 1928968 | 2021-11-18 | Nassau | New York | 36059 | 221030 | 3321 |
1925718 | 1925718 | 2021-11-17 | Nassau | New York | 36059 | 220612 | 3319 |
1922469 | 1922469 | 2021-11-16 | Nassau | New York | 36059 | 220225 | 3319 |
1919219 | 1919219 | 2021-11-15 | Nassau | New York | 36059 | 219935 | 3317 |
1915969 | 1915969 | 2021-11-14 | Nassau | New York | 36059 | 219613 | 3317 |
1912719 | 1912719 | 2021-11-13 | Nassau | New York | 36059 | 219384 | 3317 |
1909469 | 1909469 | 2021-11-12 | Nassau | New York | 36059 | 219038 | 3316 |
1906220 | 1906220 | 2021-11-11 | Nassau | New York | 36059 | 218697 | 3315 |
1902971 | 1902971 | 2021-11-10 | Nassau | New York | 36059 | 218368 | 3315 |
1899721 | 1899721 | 2021-11-09 | Nassau | New York | 36059 | 218094 | 3315 |
1896471 | 1896471 | 2021-11-08 | Nassau | New York | 36059 | 217879 | 3315 |
1893221 | 1893221 | 2021-11-07 | Nassau | New York | 36059 | 217726 | 3315 |
1889971 | 1889971 | 2021-11-06 | Nassau | New York | 36059 | 217518 | 3315 |
1886721 | 1886721 | 2021-11-05 | Nassau | New York | 36059 | 217281 | 3314 |
1883472 | 1883472 | 2021-11-04 | Nassau | New York | 36059 | 217038 | 3314 |
1880223 | 1880223 | 2021-11-03 | Nassau | New York | 36059 | 216800 | 3313 |
1876974 | 1876974 | 2021-11-02 | Nassau | New York | 36059 | 216578 | 3311 |
1873725 | 1873725 | 2021-11-01 | Nassau | New York | 36059 | 216407 | 3311 |
1870476 | 1870476 | 2021-10-31 | Nassau | New York | 36059 | 216266 | 3310 |
1867227 | 1867227 | 2021-10-30 | Nassau | New York | 36059 | 216060 | 3308 |
1863978 | 1863978 | 2021-10-29 | Nassau | New York | 36059 | 215863 | 3305 |
1860729 | 1860729 | 2021-10-28 | Nassau | New York | 36059 | 215664 | 3303 |
1857480 | 1857480 | 2021-10-27 | Nassau | New York | 36059 | 215425 | 3302 |
1854231 | 1854231 | 2021-10-26 | Nassau | New York | 36059 | 215227 | 3301 |
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);