ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Yates" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501485 | 2501485 | 2022-05-13 | Yates | New York | 36123 | 3704 | 40 |
2498227 | 2498227 | 2022-05-12 | Yates | New York | 36123 | 3704 | 40 |
2494969 | 2494969 | 2022-05-11 | Yates | New York | 36123 | 3696 | 40 |
2491711 | 2491711 | 2022-05-10 | Yates | New York | 36123 | 3683 | 40 |
2488453 | 2488453 | 2022-05-09 | Yates | New York | 36123 | 3682 | 40 |
2485196 | 2485196 | 2022-05-08 | Yates | New York | 36123 | 3675 | 40 |
2481938 | 2481938 | 2022-05-07 | Yates | New York | 36123 | 3664 | 40 |
2478680 | 2478680 | 2022-05-06 | Yates | New York | 36123 | 3655 | 40 |
2475422 | 2475422 | 2022-05-05 | Yates | New York | 36123 | 3644 | 40 |
2472165 | 2472165 | 2022-05-04 | Yates | New York | 36123 | 3631 | 40 |
2468909 | 2468909 | 2022-05-03 | Yates | New York | 36123 | 3612 | 40 |
2465653 | 2465653 | 2022-05-02 | Yates | New York | 36123 | 3611 | 40 |
2462398 | 2462398 | 2022-05-01 | Yates | New York | 36123 | 3606 | 40 |
2459142 | 2459142 | 2022-04-30 | Yates | New York | 36123 | 3594 | 40 |
2455886 | 2455886 | 2022-04-29 | Yates | New York | 36123 | 3587 | 40 |
2452630 | 2452630 | 2022-04-28 | Yates | New York | 36123 | 3570 | 40 |
2449374 | 2449374 | 2022-04-27 | Yates | New York | 36123 | 3559 | 40 |
2446117 | 2446117 | 2022-04-26 | Yates | New York | 36123 | 3547 | 40 |
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 |
2208631 | 2208631 | 2022-02-12 | Yates | New York | 36123 | 3233 | 37 |
2205378 | 2205378 | 2022-02-11 | Yates | New York | 36123 | 3230 | 37 |
2202125 | 2202125 | 2022-02-10 | Yates | New York | 36123 | 3224 | 37 |
2198871 | 2198871 | 2022-02-09 | Yates | New York | 36123 | 3207 | 37 |
2195617 | 2195617 | 2022-02-08 | Yates | New York | 36123 | 3196 | 37 |
2192363 | 2192363 | 2022-02-07 | Yates | New York | 36123 | 3193 | 37 |
2189109 | 2189109 | 2022-02-06 | Yates | New York | 36123 | 3190 | 37 |
2185856 | 2185856 | 2022-02-05 | Yates | New York | 36123 | 3186 | 37 |
2182604 | 2182604 | 2022-02-04 | Yates | New York | 36123 | 3184 | 37 |
2179352 | 2179352 | 2022-02-03 | Yates | New York | 36123 | 3170 | 37 |
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);