ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where county = "Chenango", deaths = 6 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 |
---|---|---|---|---|---|---|---|
672430 | 672430 | 2020-10-27 | Chenango | New York | 36017 | 388 | 6 |
669188 | 669188 | 2020-10-26 | Chenango | New York | 36017 | 386 | 6 |
665944 | 665944 | 2020-10-25 | Chenango | New York | 36017 | 381 | 6 |
662699 | 662699 | 2020-10-24 | Chenango | New York | 36017 | 365 | 6 |
659455 | 659455 | 2020-10-23 | Chenango | New York | 36017 | 358 | 6 |
656211 | 656211 | 2020-10-22 | Chenango | New York | 36017 | 347 | 6 |
652966 | 652966 | 2020-10-21 | Chenango | New York | 36017 | 337 | 6 |
649721 | 649721 | 2020-10-20 | Chenango | New York | 36017 | 331 | 6 |
646477 | 646477 | 2020-10-19 | Chenango | New York | 36017 | 330 | 6 |
643231 | 643231 | 2020-10-18 | Chenango | New York | 36017 | 313 | 6 |
639983 | 639983 | 2020-10-17 | Chenango | New York | 36017 | 304 | 6 |
636737 | 636737 | 2020-10-16 | Chenango | New York | 36017 | 294 | 6 |
633491 | 633491 | 2020-10-15 | Chenango | New York | 36017 | 291 | 6 |
630246 | 630246 | 2020-10-14 | Chenango | New York | 36017 | 290 | 6 |
627002 | 627002 | 2020-10-13 | Chenango | New York | 36017 | 280 | 6 |
623760 | 623760 | 2020-10-12 | Chenango | New York | 36017 | 277 | 6 |
620517 | 620517 | 2020-10-11 | Chenango | New York | 36017 | 275 | 6 |
617275 | 617275 | 2020-10-10 | Chenango | New York | 36017 | 271 | 6 |
614033 | 614033 | 2020-10-09 | Chenango | New York | 36017 | 268 | 6 |
610792 | 610792 | 2020-10-08 | Chenango | New York | 36017 | 267 | 6 |
607550 | 607550 | 2020-10-07 | Chenango | New York | 36017 | 265 | 6 |
604307 | 604307 | 2020-10-06 | Chenango | New York | 36017 | 263 | 6 |
601065 | 601065 | 2020-10-05 | Chenango | New York | 36017 | 262 | 6 |
597822 | 597822 | 2020-10-04 | Chenango | New York | 36017 | 261 | 6 |
594579 | 594579 | 2020-10-03 | Chenango | New York | 36017 | 259 | 6 |
591338 | 591338 | 2020-10-02 | Chenango | New York | 36017 | 257 | 6 |
588097 | 588097 | 2020-10-01 | Chenango | New York | 36017 | 253 | 6 |
584857 | 584857 | 2020-09-30 | Chenango | New York | 36017 | 253 | 6 |
581616 | 581616 | 2020-09-29 | Chenango | New York | 36017 | 251 | 6 |
578376 | 578376 | 2020-09-28 | Chenango | New York | 36017 | 251 | 6 |
575135 | 575135 | 2020-09-27 | Chenango | New York | 36017 | 249 | 6 |
571891 | 571891 | 2020-09-26 | Chenango | New York | 36017 | 249 | 6 |
568649 | 568649 | 2020-09-25 | Chenango | New York | 36017 | 248 | 6 |
565408 | 565408 | 2020-09-24 | Chenango | New York | 36017 | 248 | 6 |
562167 | 562167 | 2020-09-23 | Chenango | New York | 36017 | 248 | 6 |
558930 | 558930 | 2020-09-22 | Chenango | New York | 36017 | 248 | 6 |
555693 | 555693 | 2020-09-21 | Chenango | New York | 36017 | 248 | 6 |
552456 | 552456 | 2020-09-20 | Chenango | New York | 36017 | 248 | 6 |
549217 | 549217 | 2020-09-19 | Chenango | New York | 36017 | 248 | 6 |
545978 | 545978 | 2020-09-18 | Chenango | New York | 36017 | 248 | 6 |
542741 | 542741 | 2020-09-17 | Chenango | New York | 36017 | 245 | 6 |
539505 | 539505 | 2020-09-16 | Chenango | New York | 36017 | 245 | 6 |
536268 | 536268 | 2020-09-15 | Chenango | New York | 36017 | 245 | 6 |
533032 | 533032 | 2020-09-14 | Chenango | New York | 36017 | 245 | 6 |
529797 | 529797 | 2020-09-13 | Chenango | New York | 36017 | 245 | 6 |
526560 | 526560 | 2020-09-12 | Chenango | New York | 36017 | 245 | 6 |
523324 | 523324 | 2020-09-11 | Chenango | New York | 36017 | 244 | 6 |
520088 | 520088 | 2020-09-10 | Chenango | New York | 36017 | 242 | 6 |
516852 | 516852 | 2020-09-09 | Chenango | New York | 36017 | 240 | 6 |
513617 | 513617 | 2020-09-08 | Chenango | New York | 36017 | 239 | 6 |
510384 | 510384 | 2020-09-07 | Chenango | New York | 36017 | 235 | 6 |
507151 | 507151 | 2020-09-06 | Chenango | New York | 36017 | 235 | 6 |
503919 | 503919 | 2020-09-05 | Chenango | New York | 36017 | 233 | 6 |
500685 | 500685 | 2020-09-04 | Chenango | New York | 36017 | 231 | 6 |
497451 | 497451 | 2020-09-03 | Chenango | New York | 36017 | 230 | 6 |
494218 | 494218 | 2020-09-02 | Chenango | New York | 36017 | 229 | 6 |
490984 | 490984 | 2020-09-01 | Chenango | New York | 36017 | 229 | 6 |
487751 | 487751 | 2020-08-31 | Chenango | New York | 36017 | 228 | 6 |
484518 | 484518 | 2020-08-30 | Chenango | New York | 36017 | 227 | 6 |
481283 | 481283 | 2020-08-29 | Chenango | New York | 36017 | 225 | 6 |
478050 | 478050 | 2020-08-28 | Chenango | New York | 36017 | 224 | 6 |
474817 | 474817 | 2020-08-27 | Chenango | New York | 36017 | 224 | 6 |
471583 | 471583 | 2020-08-26 | Chenango | New York | 36017 | 223 | 6 |
468351 | 468351 | 2020-08-25 | Chenango | New York | 36017 | 223 | 6 |
465123 | 465123 | 2020-08-24 | Chenango | New York | 36017 | 223 | 6 |
461894 | 461894 | 2020-08-23 | Chenango | New York | 36017 | 223 | 6 |
458666 | 458666 | 2020-08-22 | Chenango | New York | 36017 | 223 | 6 |
455438 | 455438 | 2020-08-21 | Chenango | New York | 36017 | 222 | 6 |
452210 | 452210 | 2020-08-20 | Chenango | New York | 36017 | 219 | 6 |
448982 | 448982 | 2020-08-19 | Chenango | New York | 36017 | 218 | 6 |
445754 | 445754 | 2020-08-18 | Chenango | New York | 36017 | 218 | 6 |
442528 | 442528 | 2020-08-17 | Chenango | New York | 36017 | 218 | 6 |
439301 | 439301 | 2020-08-16 | Chenango | New York | 36017 | 218 | 6 |
436076 | 436076 | 2020-08-15 | Chenango | New York | 36017 | 218 | 6 |
432850 | 432850 | 2020-08-14 | Chenango | New York | 36017 | 218 | 6 |
429624 | 429624 | 2020-08-13 | Chenango | New York | 36017 | 218 | 6 |
426399 | 426399 | 2020-08-12 | Chenango | New York | 36017 | 218 | 6 |
423176 | 423176 | 2020-08-11 | Chenango | New York | 36017 | 218 | 6 |
419953 | 419953 | 2020-08-10 | Chenango | New York | 36017 | 216 | 6 |
416733 | 416733 | 2020-08-09 | Chenango | New York | 36017 | 216 | 6 |
413512 | 413512 | 2020-08-08 | Chenango | New York | 36017 | 215 | 6 |
410292 | 410292 | 2020-08-07 | Chenango | New York | 36017 | 215 | 6 |
407072 | 407072 | 2020-08-06 | Chenango | New York | 36017 | 212 | 6 |
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);