ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Jefferson" 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 |
---|---|---|---|---|---|---|---|
948268 | 948268 | 2021-01-20 | Jefferson | New York | 36045 | 3272 | 24 |
945021 | 945021 | 2021-01-19 | Jefferson | New York | 36045 | 3214 | 23 |
941775 | 941775 | 2021-01-18 | Jefferson | New York | 36045 | 3145 | 22 |
938530 | 938530 | 2021-01-17 | Jefferson | New York | 36045 | 3094 | 21 |
935285 | 935285 | 2021-01-16 | Jefferson | New York | 36045 | 3031 | 21 |
932040 | 932040 | 2021-01-15 | Jefferson | New York | 36045 | 2942 | 20 |
928795 | 928795 | 2021-01-14 | Jefferson | New York | 36045 | 2841 | 19 |
925550 | 925550 | 2021-01-13 | Jefferson | New York | 36045 | 2725 | 17 |
922304 | 922304 | 2021-01-12 | Jefferson | New York | 36045 | 2652 | 16 |
919059 | 919059 | 2021-01-11 | Jefferson | New York | 36045 | 2572 | 16 |
915814 | 915814 | 2021-01-10 | Jefferson | New York | 36045 | 2493 | 16 |
912569 | 912569 | 2021-01-09 | Jefferson | New York | 36045 | 2423 | 16 |
909324 | 909324 | 2021-01-08 | Jefferson | New York | 36045 | 2348 | 14 |
906079 | 906079 | 2021-01-07 | Jefferson | New York | 36045 | 2245 | 13 |
902833 | 902833 | 2021-01-06 | Jefferson | New York | 36045 | 2152 | 12 |
899588 | 899588 | 2021-01-05 | Jefferson | New York | 36045 | 2091 | 12 |
896343 | 896343 | 2021-01-04 | Jefferson | New York | 36045 | 2032 | 12 |
893097 | 893097 | 2021-01-03 | Jefferson | New York | 36045 | 1947 | 11 |
889851 | 889851 | 2021-01-02 | Jefferson | New York | 36045 | 1894 | 10 |
886604 | 886604 | 2021-01-01 | Jefferson | New York | 36045 | 1859 | 10 |
883359 | 883359 | 2020-12-31 | Jefferson | New York | 36045 | 1783 | 9 |
880114 | 880114 | 2020-12-30 | Jefferson | New York | 36045 | 1729 | 9 |
876869 | 876869 | 2020-12-29 | Jefferson | New York | 36045 | 1667 | 7 |
873624 | 873624 | 2020-12-28 | Jefferson | New York | 36045 | 1623 | 7 |
870379 | 870379 | 2020-12-27 | Jefferson | New York | 36045 | 1573 | 7 |
867134 | 867134 | 2020-12-26 | Jefferson | New York | 36045 | 1548 | 7 |
863889 | 863889 | 2020-12-25 | Jefferson | New York | 36045 | 1520 | 7 |
860644 | 860644 | 2020-12-24 | Jefferson | New York | 36045 | 1468 | 7 |
857399 | 857399 | 2020-12-23 | Jefferson | New York | 36045 | 1422 | 7 |
854154 | 854154 | 2020-12-22 | Jefferson | New York | 36045 | 1379 | 6 |
850909 | 850909 | 2020-12-21 | Jefferson | New York | 36045 | 1344 | 6 |
847664 | 847664 | 2020-12-20 | Jefferson | New York | 36045 | 1302 | 6 |
844419 | 844419 | 2020-12-19 | Jefferson | New York | 36045 | 1265 | 6 |
841173 | 841173 | 2020-12-18 | Jefferson | New York | 36045 | 1216 | 6 |
837928 | 837928 | 2020-12-17 | Jefferson | New York | 36045 | 1161 | 6 |
834682 | 834682 | 2020-12-16 | Jefferson | New York | 36045 | 1121 | 6 |
831436 | 831436 | 2020-12-15 | Jefferson | New York | 36045 | 1085 | 6 |
828189 | 828189 | 2020-12-14 | Jefferson | New York | 36045 | 1047 | 6 |
824943 | 824943 | 2020-12-13 | Jefferson | New York | 36045 | 1010 | 5 |
821696 | 821696 | 2020-12-12 | Jefferson | New York | 36045 | 962 | 5 |
818450 | 818450 | 2020-12-11 | Jefferson | New York | 36045 | 922 | 5 |
815204 | 815204 | 2020-12-10 | Jefferson | New York | 36045 | 878 | 4 |
811959 | 811959 | 2020-12-09 | Jefferson | New York | 36045 | 861 | 4 |
808714 | 808714 | 2020-12-08 | Jefferson | New York | 36045 | 828 | 4 |
805469 | 805469 | 2020-12-07 | Jefferson | New York | 36045 | 796 | 4 |
802224 | 802224 | 2020-12-06 | Jefferson | New York | 36045 | 781 | 4 |
798979 | 798979 | 2020-12-05 | Jefferson | New York | 36045 | 757 | 4 |
795734 | 795734 | 2020-12-04 | Jefferson | New York | 36045 | 694 | 4 |
792489 | 792489 | 2020-12-03 | Jefferson | New York | 36045 | 653 | 4 |
789244 | 789244 | 2020-12-02 | Jefferson | New York | 36045 | 611 | 4 |
785999 | 785999 | 2020-12-01 | Jefferson | New York | 36045 | 586 | 4 |
782755 | 782755 | 2020-11-30 | Jefferson | New York | 36045 | 566 | 3 |
779509 | 779509 | 2020-11-29 | Jefferson | New York | 36045 | 551 | 3 |
776264 | 776264 | 2020-11-28 | Jefferson | New York | 36045 | 511 | 3 |
773019 | 773019 | 2020-11-27 | Jefferson | New York | 36045 | 500 | 3 |
769774 | 769774 | 2020-11-26 | Jefferson | New York | 36045 | 487 | 3 |
766528 | 766528 | 2020-11-25 | Jefferson | New York | 36045 | 471 | 3 |
763283 | 763283 | 2020-11-24 | Jefferson | New York | 36045 | 457 | 3 |
760038 | 760038 | 2020-11-23 | Jefferson | New York | 36045 | 435 | 2 |
756792 | 756792 | 2020-11-22 | Jefferson | New York | 36045 | 418 | 2 |
753545 | 753545 | 2020-11-21 | Jefferson | New York | 36045 | 407 | 2 |
750299 | 750299 | 2020-11-20 | Jefferson | New York | 36045 | 376 | 2 |
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 |
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);