ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Otsego" and state = "New York" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
9023 | 9023 | 2020-03-23 | Otsego | New York | 36077 | 1 | 0 |
10331 | 10331 | 2020-03-24 | Otsego | New York | 36077 | 1 | 0 |
11767 | 11767 | 2020-03-25 | Otsego | New York | 36077 | 2 | 0 |
13370 | 13370 | 2020-03-26 | Otsego | New York | 36077 | 3 | 0 |
15104 | 15104 | 2020-03-27 | Otsego | New York | 36077 | 5 | 0 |
16934 | 16934 | 2020-03-28 | Otsego | New York | 36077 | 7 | 0 |
18859 | 18859 | 2020-03-29 | Otsego | New York | 36077 | 10 | 0 |
20898 | 20898 | 2020-03-30 | Otsego | New York | 36077 | 17 | 0 |
23021 | 23021 | 2020-03-31 | Otsego | New York | 36077 | 18 | 0 |
25215 | 25215 | 2020-04-01 | Otsego | New York | 36077 | 19 | 1 |
27475 | 27475 | 2020-04-02 | Otsego | New York | 36077 | 21 | 1 |
29799 | 29799 | 2020-04-03 | Otsego | New York | 36077 | 21 | 1 |
32185 | 32185 | 2020-04-04 | Otsego | New York | 36077 | 26 | 2 |
34616 | 34616 | 2020-04-05 | Otsego | New York | 36077 | 29 | 2 |
37086 | 37086 | 2020-04-06 | Otsego | New York | 36077 | 34 | 2 |
39601 | 39601 | 2020-04-07 | Otsego | New York | 36077 | 34 | 2 |
42158 | 42158 | 2020-04-08 | Otsego | New York | 36077 | 38 | 2 |
44741 | 44741 | 2020-04-09 | Otsego | New York | 36077 | 39 | 2 |
47354 | 47354 | 2020-04-10 | Otsego | New York | 36077 | 41 | 2 |
50009 | 50009 | 2020-04-11 | Otsego | New York | 36077 | 43 | 2 |
52682 | 52682 | 2020-04-12 | Otsego | New York | 36077 | 43 | 2 |
55365 | 55365 | 2020-04-13 | Otsego | New York | 36077 | 43 | 3 |
58065 | 58065 | 2020-04-14 | Otsego | New York | 36077 | 44 | 3 |
60779 | 60779 | 2020-04-15 | Otsego | New York | 36077 | 44 | 4 |
63505 | 63505 | 2020-04-16 | Otsego | New York | 36077 | 44 | 4 |
66247 | 66247 | 2020-04-17 | Otsego | New York | 36077 | 44 | 4 |
69004 | 69004 | 2020-04-18 | Otsego | New York | 36077 | 47 | 4 |
407101 | 407101 | 2020-08-06 | Otsego | New York | 36077 | 115 | 4 |
410321 | 410321 | 2020-08-07 | Otsego | New York | 36077 | 116 | 4 |
413541 | 413541 | 2020-08-08 | Otsego | New York | 36077 | 116 | 4 |
416762 | 416762 | 2020-08-09 | Otsego | New York | 36077 | 116 | 4 |
419982 | 419982 | 2020-08-10 | Otsego | New York | 36077 | 116 | 4 |
423205 | 423205 | 2020-08-11 | Otsego | New York | 36077 | 118 | 4 |
426428 | 426428 | 2020-08-12 | Otsego | New York | 36077 | 118 | 4 |
429653 | 429653 | 2020-08-13 | Otsego | New York | 36077 | 118 | 4 |
432879 | 432879 | 2020-08-14 | Otsego | New York | 36077 | 118 | 4 |
436105 | 436105 | 2020-08-15 | Otsego | New York | 36077 | 118 | 4 |
439330 | 439330 | 2020-08-16 | Otsego | New York | 36077 | 118 | 4 |
442557 | 442557 | 2020-08-17 | Otsego | New York | 36077 | 118 | 4 |
445783 | 445783 | 2020-08-18 | Otsego | New York | 36077 | 120 | 4 |
449011 | 449011 | 2020-08-19 | Otsego | New York | 36077 | 122 | 4 |
452239 | 452239 | 2020-08-20 | Otsego | New York | 36077 | 123 | 4 |
455467 | 455467 | 2020-08-21 | Otsego | New York | 36077 | 124 | 4 |
458695 | 458695 | 2020-08-22 | Otsego | New York | 36077 | 124 | 4 |
461923 | 461923 | 2020-08-23 | Otsego | New York | 36077 | 124 | 4 |
465152 | 465152 | 2020-08-24 | Otsego | New York | 36077 | 124 | 4 |
468380 | 468380 | 2020-08-25 | Otsego | New York | 36077 | 124 | 4 |
471612 | 471612 | 2020-08-26 | Otsego | New York | 36077 | 124 | 4 |
474846 | 474846 | 2020-08-27 | Otsego | New York | 36077 | 124 | 4 |
478079 | 478079 | 2020-08-28 | Otsego | New York | 36077 | 125 | 4 |
481312 | 481312 | 2020-08-29 | Otsego | New York | 36077 | 134 | 4 |
484547 | 484547 | 2020-08-30 | Otsego | New York | 36077 | 143 | 4 |
487780 | 487780 | 2020-08-31 | Otsego | New York | 36077 | 144 | 4 |
491013 | 491013 | 2020-09-01 | Otsego | New York | 36077 | 179 | 4 |
494247 | 494247 | 2020-09-02 | Otsego | New York | 36077 | 189 | 4 |
497480 | 497480 | 2020-09-03 | Otsego | New York | 36077 | 209 | 4 |
500714 | 500714 | 2020-09-04 | Otsego | New York | 36077 | 235 | 4 |
503948 | 503948 | 2020-09-05 | Otsego | New York | 36077 | 249 | 4 |
507180 | 507180 | 2020-09-06 | Otsego | New York | 36077 | 268 | 4 |
510413 | 510413 | 2020-09-07 | Otsego | New York | 36077 | 285 | 4 |
513646 | 513646 | 2020-09-08 | Otsego | New York | 36077 | 288 | 4 |
516881 | 516881 | 2020-09-09 | Otsego | New York | 36077 | 291 | 4 |
520117 | 520117 | 2020-09-10 | Otsego | New York | 36077 | 291 | 4 |
523353 | 523353 | 2020-09-11 | Otsego | New York | 36077 | 296 | 4 |
526589 | 526589 | 2020-09-12 | Otsego | New York | 36077 | 312 | 4 |
529826 | 529826 | 2020-09-13 | Otsego | New York | 36077 | 314 | 4 |
533061 | 533061 | 2020-09-14 | Otsego | New York | 36077 | 314 | 4 |
536297 | 536297 | 2020-09-15 | Otsego | New York | 36077 | 316 | 4 |
539534 | 539534 | 2020-09-16 | Otsego | New York | 36077 | 318 | 4 |
542770 | 542770 | 2020-09-17 | Otsego | New York | 36077 | 322 | 4 |
546007 | 546007 | 2020-09-18 | Otsego | New York | 36077 | 324 | 4 |
549246 | 549246 | 2020-09-19 | Otsego | New York | 36077 | 325 | 4 |
552485 | 552485 | 2020-09-20 | Otsego | New York | 36077 | 332 | 4 |
555722 | 555722 | 2020-09-21 | Otsego | New York | 36077 | 332 | 4 |
558959 | 558959 | 2020-09-22 | Otsego | New York | 36077 | 332 | 4 |
562196 | 562196 | 2020-09-23 | Otsego | New York | 36077 | 333 | 4 |
565437 | 565437 | 2020-09-24 | Otsego | New York | 36077 | 335 | 4 |
568678 | 568678 | 2020-09-25 | Otsego | New York | 36077 | 335 | 4 |
571920 | 571920 | 2020-09-26 | Otsego | New York | 36077 | 338 | 4 |
575164 | 575164 | 2020-09-27 | Otsego | New York | 36077 | 338 | 4 |
578405 | 578405 | 2020-09-28 | Otsego | New York | 36077 | 340 | 4 |
581645 | 581645 | 2020-09-29 | Otsego | New York | 36077 | 340 | 4 |
584886 | 584886 | 2020-09-30 | Otsego | New York | 36077 | 341 | 4 |
588126 | 588126 | 2020-10-01 | Otsego | New York | 36077 | 342 | 4 |
591367 | 591367 | 2020-10-02 | Otsego | New York | 36077 | 344 | 4 |
594608 | 594608 | 2020-10-03 | Otsego | New York | 36077 | 344 | 4 |
597851 | 597851 | 2020-10-04 | Otsego | New York | 36077 | 346 | 4 |
601094 | 601094 | 2020-10-05 | Otsego | New York | 36077 | 347 | 4 |
604336 | 604336 | 2020-10-06 | Otsego | New York | 36077 | 353 | 4 |
607579 | 607579 | 2020-10-07 | Otsego | New York | 36077 | 353 | 4 |
610821 | 610821 | 2020-10-08 | Otsego | New York | 36077 | 354 | 4 |
614062 | 614062 | 2020-10-09 | Otsego | New York | 36077 | 357 | 4 |
617304 | 617304 | 2020-10-10 | Otsego | New York | 36077 | 359 | 4 |
620546 | 620546 | 2020-10-11 | Otsego | New York | 36077 | 360 | 4 |
623789 | 623789 | 2020-10-12 | Otsego | New York | 36077 | 360 | 4 |
627031 | 627031 | 2020-10-13 | Otsego | New York | 36077 | 362 | 4 |
630275 | 630275 | 2020-10-14 | Otsego | New York | 36077 | 362 | 4 |
633520 | 633520 | 2020-10-15 | Otsego | New York | 36077 | 362 | 4 |
636766 | 636766 | 2020-10-16 | Otsego | New York | 36077 | 362 | 4 |
640012 | 640012 | 2020-10-17 | Otsego | New York | 36077 | 364 | 4 |
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);