ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where deaths = 1 and fips = 36045 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 |
---|---|---|---|---|---|---|---|
747053 | 747053 | 2020-11-19 | Jefferson | New York | 36045 | 354 | 1 |
743807 | 743807 | 2020-11-18 | Jefferson | New York | 36045 | 345 | 1 |
740560 | 740560 | 2020-11-17 | Jefferson | New York | 36045 | 339 | 1 |
737315 | 737315 | 2020-11-16 | Jefferson | New York | 36045 | 332 | 1 |
734071 | 734071 | 2020-11-15 | Jefferson | New York | 36045 | 324 | 1 |
730825 | 730825 | 2020-11-14 | Jefferson | New York | 36045 | 316 | 1 |
727581 | 727581 | 2020-11-13 | Jefferson | New York | 36045 | 307 | 1 |
724337 | 724337 | 2020-11-12 | Jefferson | New York | 36045 | 292 | 1 |
721094 | 721094 | 2020-11-11 | Jefferson | New York | 36045 | 288 | 1 |
717851 | 717851 | 2020-11-10 | Jefferson | New York | 36045 | 282 | 1 |
714608 | 714608 | 2020-11-09 | Jefferson | New York | 36045 | 277 | 1 |
711364 | 711364 | 2020-11-08 | Jefferson | New York | 36045 | 268 | 1 |
708120 | 708120 | 2020-11-07 | Jefferson | New York | 36045 | 262 | 1 |
704877 | 704877 | 2020-11-06 | Jefferson | New York | 36045 | 260 | 1 |
701634 | 701634 | 2020-11-05 | Jefferson | New York | 36045 | 249 | 1 |
698390 | 698390 | 2020-11-04 | Jefferson | New York | 36045 | 241 | 1 |
695147 | 695147 | 2020-11-03 | Jefferson | New York | 36045 | 237 | 1 |
691905 | 691905 | 2020-11-02 | Jefferson | New York | 36045 | 231 | 1 |
688661 | 688661 | 2020-11-01 | Jefferson | New York | 36045 | 222 | 1 |
685416 | 685416 | 2020-10-31 | Jefferson | New York | 36045 | 220 | 1 |
682173 | 682173 | 2020-10-30 | Jefferson | New York | 36045 | 214 | 1 |
678930 | 678930 | 2020-10-29 | Jefferson | New York | 36045 | 211 | 1 |
675687 | 675687 | 2020-10-28 | Jefferson | New York | 36045 | 207 | 1 |
672444 | 672444 | 2020-10-27 | Jefferson | New York | 36045 | 206 | 1 |
669202 | 669202 | 2020-10-26 | Jefferson | New York | 36045 | 203 | 1 |
665958 | 665958 | 2020-10-25 | Jefferson | New York | 36045 | 202 | 1 |
662713 | 662713 | 2020-10-24 | Jefferson | New York | 36045 | 199 | 1 |
659469 | 659469 | 2020-10-23 | Jefferson | New York | 36045 | 197 | 1 |
656225 | 656225 | 2020-10-22 | Jefferson | New York | 36045 | 194 | 1 |
652980 | 652980 | 2020-10-21 | Jefferson | New York | 36045 | 193 | 1 |
649735 | 649735 | 2020-10-20 | Jefferson | New York | 36045 | 192 | 1 |
646491 | 646491 | 2020-10-19 | Jefferson | New York | 36045 | 191 | 1 |
643245 | 643245 | 2020-10-18 | Jefferson | New York | 36045 | 188 | 1 |
639997 | 639997 | 2020-10-17 | Jefferson | New York | 36045 | 186 | 1 |
636751 | 636751 | 2020-10-16 | Jefferson | New York | 36045 | 186 | 1 |
633505 | 633505 | 2020-10-15 | Jefferson | New York | 36045 | 186 | 1 |
630260 | 630260 | 2020-10-14 | Jefferson | New York | 36045 | 186 | 1 |
627016 | 627016 | 2020-10-13 | Jefferson | New York | 36045 | 186 | 1 |
623774 | 623774 | 2020-10-12 | Jefferson | New York | 36045 | 185 | 1 |
620531 | 620531 | 2020-10-11 | Jefferson | New York | 36045 | 184 | 1 |
617289 | 617289 | 2020-10-10 | Jefferson | New York | 36045 | 181 | 1 |
614047 | 614047 | 2020-10-09 | Jefferson | New York | 36045 | 180 | 1 |
610806 | 610806 | 2020-10-08 | Jefferson | New York | 36045 | 177 | 1 |
607564 | 607564 | 2020-10-07 | Jefferson | New York | 36045 | 176 | 1 |
604321 | 604321 | 2020-10-06 | Jefferson | New York | 36045 | 176 | 1 |
601079 | 601079 | 2020-10-05 | Jefferson | New York | 36045 | 176 | 1 |
597836 | 597836 | 2020-10-04 | Jefferson | New York | 36045 | 176 | 1 |
594593 | 594593 | 2020-10-03 | Jefferson | New York | 36045 | 176 | 1 |
591352 | 591352 | 2020-10-02 | Jefferson | New York | 36045 | 174 | 1 |
588111 | 588111 | 2020-10-01 | Jefferson | New York | 36045 | 172 | 1 |
584871 | 584871 | 2020-09-30 | Jefferson | New York | 36045 | 172 | 1 |
581630 | 581630 | 2020-09-29 | Jefferson | New York | 36045 | 170 | 1 |
578390 | 578390 | 2020-09-28 | Jefferson | New York | 36045 | 170 | 1 |
575149 | 575149 | 2020-09-27 | Jefferson | New York | 36045 | 170 | 1 |
571905 | 571905 | 2020-09-26 | Jefferson | New York | 36045 | 167 | 1 |
568663 | 568663 | 2020-09-25 | Jefferson | New York | 36045 | 167 | 1 |
565422 | 565422 | 2020-09-24 | Jefferson | New York | 36045 | 165 | 1 |
562181 | 562181 | 2020-09-23 | Jefferson | New York | 36045 | 164 | 1 |
558944 | 558944 | 2020-09-22 | Jefferson | New York | 36045 | 164 | 1 |
555707 | 555707 | 2020-09-21 | Jefferson | New York | 36045 | 163 | 1 |
552470 | 552470 | 2020-09-20 | Jefferson | New York | 36045 | 163 | 1 |
549231 | 549231 | 2020-09-19 | Jefferson | New York | 36045 | 161 | 1 |
545992 | 545992 | 2020-09-18 | Jefferson | New York | 36045 | 160 | 1 |
542755 | 542755 | 2020-09-17 | Jefferson | New York | 36045 | 159 | 1 |
539519 | 539519 | 2020-09-16 | Jefferson | New York | 36045 | 158 | 1 |
536282 | 536282 | 2020-09-15 | Jefferson | New York | 36045 | 158 | 1 |
533046 | 533046 | 2020-09-14 | Jefferson | New York | 36045 | 158 | 1 |
529811 | 529811 | 2020-09-13 | Jefferson | New York | 36045 | 157 | 1 |
526574 | 526574 | 2020-09-12 | Jefferson | New York | 36045 | 157 | 1 |
523338 | 523338 | 2020-09-11 | Jefferson | New York | 36045 | 157 | 1 |
520102 | 520102 | 2020-09-10 | Jefferson | New York | 36045 | 156 | 1 |
516866 | 516866 | 2020-09-09 | Jefferson | New York | 36045 | 156 | 1 |
513631 | 513631 | 2020-09-08 | Jefferson | New York | 36045 | 156 | 1 |
510398 | 510398 | 2020-09-07 | Jefferson | New York | 36045 | 156 | 1 |
507165 | 507165 | 2020-09-06 | Jefferson | New York | 36045 | 154 | 1 |
503933 | 503933 | 2020-09-05 | Jefferson | New York | 36045 | 154 | 1 |
500699 | 500699 | 2020-09-04 | Jefferson | New York | 36045 | 154 | 1 |
497465 | 497465 | 2020-09-03 | Jefferson | New York | 36045 | 154 | 1 |
494232 | 494232 | 2020-09-02 | Jefferson | New York | 36045 | 150 | 1 |
490998 | 490998 | 2020-09-01 | Jefferson | New York | 36045 | 150 | 1 |
487765 | 487765 | 2020-08-31 | Jefferson | New York | 36045 | 150 | 1 |
484532 | 484532 | 2020-08-30 | Jefferson | New York | 36045 | 150 | 1 |
481297 | 481297 | 2020-08-29 | Jefferson | New York | 36045 | 149 | 1 |
478064 | 478064 | 2020-08-28 | Jefferson | New York | 36045 | 149 | 1 |
474831 | 474831 | 2020-08-27 | Jefferson | New York | 36045 | 148 | 1 |
471597 | 471597 | 2020-08-26 | Jefferson | New York | 36045 | 146 | 1 |
468365 | 468365 | 2020-08-25 | Jefferson | New York | 36045 | 146 | 1 |
465137 | 465137 | 2020-08-24 | Jefferson | New York | 36045 | 145 | 1 |
461908 | 461908 | 2020-08-23 | Jefferson | New York | 36045 | 145 | 1 |
458680 | 458680 | 2020-08-22 | Jefferson | New York | 36045 | 144 | 1 |
455452 | 455452 | 2020-08-21 | Jefferson | New York | 36045 | 144 | 1 |
452224 | 452224 | 2020-08-20 | Jefferson | New York | 36045 | 143 | 1 |
448996 | 448996 | 2020-08-19 | Jefferson | New York | 36045 | 143 | 1 |
445768 | 445768 | 2020-08-18 | Jefferson | New York | 36045 | 143 | 1 |
442542 | 442542 | 2020-08-17 | Jefferson | New York | 36045 | 143 | 1 |
439315 | 439315 | 2020-08-16 | Jefferson | New York | 36045 | 143 | 1 |
436090 | 436090 | 2020-08-15 | Jefferson | New York | 36045 | 143 | 1 |
432864 | 432864 | 2020-08-14 | Jefferson | New York | 36045 | 143 | 1 |
429638 | 429638 | 2020-08-13 | Jefferson | New York | 36045 | 142 | 1 |
426413 | 426413 | 2020-08-12 | Jefferson | New York | 36045 | 142 | 1 |
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);