ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Tioga" 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 |
---|---|---|---|---|---|---|---|
954786 | 954786 | 2021-01-22 | Tioga | New York | 36107 | 2294 | 54 |
951541 | 951541 | 2021-01-21 | Tioga | New York | 36107 | 2268 | 54 |
948296 | 948296 | 2021-01-20 | Tioga | New York | 36107 | 2228 | 54 |
945049 | 945049 | 2021-01-19 | Tioga | New York | 36107 | 2206 | 54 |
941803 | 941803 | 2021-01-18 | Tioga | New York | 36107 | 2191 | 54 |
938558 | 938558 | 2021-01-17 | Tioga | New York | 36107 | 2167 | 54 |
935313 | 935313 | 2021-01-16 | Tioga | New York | 36107 | 2145 | 54 |
932068 | 932068 | 2021-01-15 | Tioga | New York | 36107 | 2124 | 54 |
928823 | 928823 | 2021-01-14 | Tioga | New York | 36107 | 2102 | 54 |
925578 | 925578 | 2021-01-13 | Tioga | New York | 36107 | 2082 | 54 |
922332 | 922332 | 2021-01-12 | Tioga | New York | 36107 | 2044 | 54 |
919087 | 919087 | 2021-01-11 | Tioga | New York | 36107 | 2021 | 54 |
915842 | 915842 | 2021-01-10 | Tioga | New York | 36107 | 1999 | 54 |
912597 | 912597 | 2021-01-09 | Tioga | New York | 36107 | 1971 | 54 |
909352 | 909352 | 2021-01-08 | Tioga | New York | 36107 | 1940 | 54 |
906107 | 906107 | 2021-01-07 | Tioga | New York | 36107 | 1901 | 54 |
902861 | 902861 | 2021-01-06 | Tioga | New York | 36107 | 1856 | 54 |
899616 | 899616 | 2021-01-05 | Tioga | New York | 36107 | 1812 | 54 |
896371 | 896371 | 2021-01-04 | Tioga | New York | 36107 | 1792 | 54 |
893125 | 893125 | 2021-01-03 | Tioga | New York | 36107 | 1771 | 54 |
889879 | 889879 | 2021-01-02 | Tioga | New York | 36107 | 1740 | 54 |
886632 | 886632 | 2021-01-01 | Tioga | New York | 36107 | 1711 | 54 |
883387 | 883387 | 2020-12-31 | Tioga | New York | 36107 | 1679 | 54 |
880142 | 880142 | 2020-12-30 | Tioga | New York | 36107 | 1655 | 54 |
876897 | 876897 | 2020-12-29 | Tioga | New York | 36107 | 1630 | 54 |
873652 | 873652 | 2020-12-28 | Tioga | New York | 36107 | 1616 | 54 |
870407 | 870407 | 2020-12-27 | Tioga | New York | 36107 | 1601 | 54 |
867162 | 867162 | 2020-12-26 | Tioga | New York | 36107 | 1596 | 54 |
863917 | 863917 | 2020-12-25 | Tioga | New York | 36107 | 1575 | 54 |
860672 | 860672 | 2020-12-24 | Tioga | New York | 36107 | 1543 | 54 |
857427 | 857427 | 2020-12-23 | Tioga | New York | 36107 | 1518 | 54 |
854182 | 854182 | 2020-12-22 | Tioga | New York | 36107 | 1486 | 54 |
850937 | 850937 | 2020-12-21 | Tioga | New York | 36107 | 1480 | 54 |
847692 | 847692 | 2020-12-20 | Tioga | New York | 36107 | 1471 | 54 |
844447 | 844447 | 2020-12-19 | Tioga | New York | 36107 | 1451 | 54 |
841201 | 841201 | 2020-12-18 | Tioga | New York | 36107 | 1439 | 54 |
837956 | 837956 | 2020-12-17 | Tioga | New York | 36107 | 1421 | 54 |
834710 | 834710 | 2020-12-16 | Tioga | New York | 36107 | 1407 | 54 |
831464 | 831464 | 2020-12-15 | Tioga | New York | 36107 | 1389 | 54 |
828217 | 828217 | 2020-12-14 | Tioga | New York | 36107 | 1379 | 52 |
824971 | 824971 | 2020-12-13 | Tioga | New York | 36107 | 1367 | 52 |
821724 | 821724 | 2020-12-12 | Tioga | New York | 36107 | 1345 | 52 |
818478 | 818478 | 2020-12-11 | Tioga | New York | 36107 | 1329 | 52 |
815232 | 815232 | 2020-12-10 | Tioga | New York | 36107 | 1312 | 52 |
811987 | 811987 | 2020-12-09 | Tioga | New York | 36107 | 1295 | 52 |
808742 | 808742 | 2020-12-08 | Tioga | New York | 36107 | 1280 | 52 |
805497 | 805497 | 2020-12-07 | Tioga | New York | 36107 | 1260 | 51 |
802252 | 802252 | 2020-12-06 | Tioga | New York | 36107 | 1251 | 51 |
799007 | 799007 | 2020-12-05 | Tioga | New York | 36107 | 1228 | 51 |
795762 | 795762 | 2020-12-04 | Tioga | New York | 36107 | 1208 | 51 |
792517 | 792517 | 2020-12-03 | Tioga | New York | 36107 | 1193 | 51 |
789272 | 789272 | 2020-12-02 | Tioga | New York | 36107 | 1171 | 51 |
786027 | 786027 | 2020-12-01 | Tioga | New York | 36107 | 1153 | 51 |
782783 | 782783 | 2020-11-30 | Tioga | New York | 36107 | 1149 | 51 |
779537 | 779537 | 2020-11-29 | Tioga | New York | 36107 | 1132 | 49 |
776292 | 776292 | 2020-11-28 | Tioga | New York | 36107 | 1104 | 49 |
773047 | 773047 | 2020-11-27 | Tioga | New York | 36107 | 1095 | 49 |
769802 | 769802 | 2020-11-26 | Tioga | New York | 36107 | 1080 | 48 |
766556 | 766556 | 2020-11-25 | Tioga | New York | 36107 | 1066 | 48 |
763311 | 763311 | 2020-11-24 | Tioga | New York | 36107 | 1055 | 48 |
760066 | 760066 | 2020-11-23 | Tioga | New York | 36107 | 1043 | 48 |
756820 | 756820 | 2020-11-22 | Tioga | New York | 36107 | 1024 | 47 |
753573 | 753573 | 2020-11-21 | Tioga | New York | 36107 | 1013 | 46 |
750327 | 750327 | 2020-11-20 | Tioga | New York | 36107 | 998 | 46 |
747081 | 747081 | 2020-11-19 | Tioga | New York | 36107 | 996 | 46 |
743835 | 743835 | 2020-11-18 | Tioga | New York | 36107 | 984 | 46 |
740588 | 740588 | 2020-11-17 | Tioga | New York | 36107 | 973 | 46 |
737343 | 737343 | 2020-11-16 | Tioga | New York | 36107 | 957 | 45 |
734099 | 734099 | 2020-11-15 | Tioga | New York | 36107 | 951 | 44 |
730853 | 730853 | 2020-11-14 | Tioga | New York | 36107 | 940 | 43 |
727609 | 727609 | 2020-11-13 | Tioga | New York | 36107 | 930 | 43 |
724365 | 724365 | 2020-11-12 | Tioga | New York | 36107 | 913 | 42 |
721122 | 721122 | 2020-11-11 | Tioga | New York | 36107 | 886 | 41 |
717879 | 717879 | 2020-11-10 | Tioga | New York | 36107 | 864 | 41 |
714636 | 714636 | 2020-11-09 | Tioga | New York | 36107 | 846 | 41 |
711392 | 711392 | 2020-11-08 | Tioga | New York | 36107 | 836 | 38 |
708148 | 708148 | 2020-11-07 | Tioga | New York | 36107 | 823 | 38 |
704905 | 704905 | 2020-11-06 | Tioga | New York | 36107 | 792 | 37 |
701662 | 701662 | 2020-11-05 | Tioga | New York | 36107 | 775 | 36 |
698418 | 698418 | 2020-11-04 | Tioga | New York | 36107 | 750 | 36 |
695175 | 695175 | 2020-11-03 | Tioga | New York | 36107 | 732 | 34 |
691933 | 691933 | 2020-11-02 | Tioga | New York | 36107 | 717 | 33 |
688689 | 688689 | 2020-11-01 | Tioga | New York | 36107 | 699 | 33 |
685444 | 685444 | 2020-10-31 | Tioga | New York | 36107 | 689 | 33 |
682201 | 682201 | 2020-10-30 | Tioga | New York | 36107 | 672 | 32 |
678958 | 678958 | 2020-10-29 | Tioga | New York | 36107 | 653 | 30 |
675715 | 675715 | 2020-10-28 | Tioga | New York | 36107 | 629 | 29 |
672472 | 672472 | 2020-10-27 | Tioga | New York | 36107 | 610 | 27 |
669230 | 669230 | 2020-10-26 | Tioga | New York | 36107 | 589 | 26 |
665986 | 665986 | 2020-10-25 | Tioga | New York | 36107 | 572 | 26 |
662741 | 662741 | 2020-10-24 | Tioga | New York | 36107 | 549 | 25 |
659497 | 659497 | 2020-10-23 | Tioga | New York | 36107 | 512 | 25 |
656253 | 656253 | 2020-10-22 | Tioga | New York | 36107 | 502 | 25 |
653008 | 653008 | 2020-10-21 | Tioga | New York | 36107 | 478 | 25 |
649763 | 649763 | 2020-10-20 | Tioga | New York | 36107 | 459 | 25 |
646519 | 646519 | 2020-10-19 | Tioga | New York | 36107 | 448 | 25 |
643273 | 643273 | 2020-10-18 | Tioga | New York | 36107 | 435 | 25 |
640025 | 640025 | 2020-10-17 | Tioga | New York | 36107 | 424 | 25 |
636779 | 636779 | 2020-10-16 | Tioga | New York | 36107 | 413 | 25 |
633533 | 633533 | 2020-10-15 | Tioga | New York | 36107 | 390 | 25 |
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);