ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
305 rows where 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 |
---|---|---|---|---|---|---|---|
2442862 | 2442862 | 2022-04-25 | Yates | New York | 36123 | 3541 | 39 |
2439606 | 2439606 | 2022-04-24 | Yates | New York | 36123 | 3535 | 39 |
2436350 | 2436350 | 2022-04-23 | Yates | New York | 36123 | 3521 | 39 |
2433094 | 2433094 | 2022-04-22 | Yates | New York | 36123 | 3512 | 39 |
2429838 | 2429838 | 2022-04-21 | Yates | New York | 36123 | 3499 | 39 |
2426582 | 2426582 | 2022-04-20 | Yates | New York | 36123 | 3487 | 39 |
2423326 | 2423326 | 2022-04-19 | Yates | New York | 36123 | 3479 | 39 |
2420069 | 2420069 | 2022-04-18 | Yates | New York | 36123 | 3470 | 39 |
2416814 | 2416814 | 2022-04-17 | Yates | New York | 36123 | 3465 | 39 |
2413558 | 2413558 | 2022-04-16 | Yates | New York | 36123 | 3454 | 39 |
2410302 | 2410302 | 2022-04-15 | Yates | New York | 36123 | 3448 | 39 |
2407046 | 2407046 | 2022-04-14 | Yates | New York | 36123 | 3436 | 39 |
2403790 | 2403790 | 2022-04-13 | Yates | New York | 36123 | 3424 | 39 |
2400535 | 2400535 | 2022-04-12 | Yates | New York | 36123 | 3417 | 39 |
2397280 | 2397280 | 2022-04-11 | Yates | New York | 36123 | 3413 | 39 |
2394025 | 2394025 | 2022-04-10 | Yates | New York | 36123 | 3409 | 39 |
2390769 | 2390769 | 2022-04-09 | Yates | New York | 36123 | 3404 | 39 |
2387513 | 2387513 | 2022-04-08 | Yates | New York | 36123 | 3398 | 39 |
2384258 | 2384258 | 2022-04-07 | Yates | New York | 36123 | 3393 | 39 |
2381003 | 2381003 | 2022-04-06 | Yates | New York | 36123 | 3389 | 39 |
2377748 | 2377748 | 2022-04-05 | Yates | New York | 36123 | 3387 | 39 |
2374495 | 2374495 | 2022-04-04 | Yates | New York | 36123 | 3383 | 39 |
2371243 | 2371243 | 2022-04-03 | Yates | New York | 36123 | 3381 | 39 |
2367990 | 2367990 | 2022-04-02 | Yates | New York | 36123 | 3378 | 39 |
2364737 | 2364737 | 2022-04-01 | Yates | New York | 36123 | 3372 | 39 |
2361483 | 2361483 | 2022-03-31 | Yates | New York | 36123 | 3369 | 39 |
2358229 | 2358229 | 2022-03-30 | Yates | New York | 36123 | 3364 | 39 |
2354975 | 2354975 | 2022-03-29 | Yates | New York | 36123 | 3362 | 39 |
2351722 | 2351722 | 2022-03-28 | Yates | New York | 36123 | 3361 | 39 |
2348470 | 2348470 | 2022-03-27 | Yates | New York | 36123 | 3360 | 39 |
2345217 | 2345217 | 2022-03-26 | Yates | New York | 36123 | 3358 | 39 |
2341964 | 2341964 | 2022-03-25 | Yates | New York | 36123 | 3353 | 39 |
2338711 | 2338711 | 2022-03-24 | Yates | New York | 36123 | 3349 | 39 |
2335457 | 2335457 | 2022-03-23 | Yates | New York | 36123 | 3342 | 39 |
2332203 | 2332203 | 2022-03-22 | Yates | New York | 36123 | 3336 | 39 |
2328950 | 2328950 | 2022-03-21 | Yates | New York | 36123 | 3336 | 39 |
2325698 | 2325698 | 2022-03-20 | Yates | New York | 36123 | 3336 | 39 |
2322445 | 2322445 | 2022-03-19 | Yates | New York | 36123 | 3336 | 39 |
2319191 | 2319191 | 2022-03-18 | Yates | New York | 36123 | 3336 | 39 |
2315937 | 2315937 | 2022-03-17 | Yates | New York | 36123 | 3336 | 39 |
2312684 | 2312684 | 2022-03-16 | Yates | New York | 36123 | 3333 | 39 |
2309431 | 2309431 | 2022-03-15 | Yates | New York | 36123 | 3332 | 39 |
2306178 | 2306178 | 2022-03-14 | Yates | New York | 36123 | 3332 | 39 |
2302927 | 2302927 | 2022-03-13 | Yates | New York | 36123 | 3332 | 39 |
2299675 | 2299675 | 2022-03-12 | Yates | New York | 36123 | 3329 | 39 |
2296423 | 2296423 | 2022-03-11 | Yates | New York | 36123 | 3329 | 39 |
2293171 | 2293171 | 2022-03-10 | Yates | New York | 36123 | 3325 | 39 |
2289919 | 2289919 | 2022-03-09 | Yates | New York | 36123 | 3322 | 39 |
2286667 | 2286667 | 2022-03-08 | Yates | New York | 36123 | 3319 | 39 |
2283415 | 2283415 | 2022-03-07 | Yates | New York | 36123 | 3317 | 39 |
2280163 | 2280163 | 2022-03-06 | Yates | New York | 36123 | 3314 | 39 |
2276910 | 2276910 | 2022-03-05 | Yates | New York | 36123 | 3312 | 39 |
2273657 | 2273657 | 2022-03-04 | Yates | New York | 36123 | 3305 | 39 |
2270404 | 2270404 | 2022-03-03 | Yates | New York | 36123 | 3305 | 39 |
2267152 | 2267152 | 2022-03-02 | Yates | New York | 36123 | 3303 | 39 |
2263900 | 2263900 | 2022-03-01 | Yates | New York | 36123 | 3296 | 39 |
2260649 | 2260649 | 2022-02-28 | Yates | New York | 36123 | 3291 | 39 |
2257398 | 2257398 | 2022-02-27 | Yates | New York | 36123 | 3289 | 39 |
2254147 | 2254147 | 2022-02-26 | Yates | New York | 36123 | 3287 | 39 |
2250896 | 2250896 | 2022-02-25 | Yates | New York | 36123 | 3286 | 39 |
2247645 | 2247645 | 2022-02-24 | Yates | New York | 36123 | 3285 | 39 |
2244394 | 2244394 | 2022-02-23 | Yates | New York | 36123 | 3283 | 39 |
2241143 | 2241143 | 2022-02-22 | Yates | New York | 36123 | 3276 | 39 |
2237892 | 2237892 | 2022-02-21 | Yates | New York | 36123 | 3275 | 39 |
2234641 | 2234641 | 2022-02-20 | Yates | New York | 36123 | 3273 | 39 |
2231390 | 2231390 | 2022-02-19 | Yates | New York | 36123 | 3269 | 39 |
2228139 | 2228139 | 2022-02-18 | Yates | New York | 36123 | 3262 | 39 |
2224888 | 2224888 | 2022-02-17 | Yates | New York | 36123 | 3256 | 39 |
2221637 | 2221637 | 2022-02-16 | Yates | New York | 36123 | 3249 | 39 |
2218386 | 2218386 | 2022-02-15 | Yates | New York | 36123 | 3244 | 39 |
2215135 | 2215135 | 2022-02-14 | Yates | New York | 36123 | 3240 | 39 |
2211884 | 2211884 | 2022-02-13 | Yates | New York | 36123 | 3237 | 39 |
2169553 | 2169553 | 2022-01-31 | Franklin | New York | 36033 | 8405 | 39 |
2166298 | 2166298 | 2022-01-30 | Franklin | New York | 36033 | 8361 | 39 |
2163043 | 2163043 | 2022-01-29 | Franklin | New York | 36033 | 8326 | 39 |
2159788 | 2159788 | 2022-01-28 | Franklin | New York | 36033 | 8283 | 39 |
2156533 | 2156533 | 2022-01-27 | Franklin | New York | 36033 | 8231 | 39 |
2153280 | 2153280 | 2022-01-26 | Franklin | New York | 36033 | 8181 | 39 |
2150028 | 2150028 | 2022-01-25 | Franklin | New York | 36033 | 8146 | 39 |
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 |
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);