ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Franklin" and state = "Vermont" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923348 | 923348 | 2021-01-12 | Franklin | Vermont | 50011 | 640 | 32 |
920103 | 920103 | 2021-01-11 | Franklin | Vermont | 50011 | 633 | 32 |
916858 | 916858 | 2021-01-10 | Franklin | Vermont | 50011 | 631 | 32 |
913613 | 913613 | 2021-01-09 | Franklin | Vermont | 50011 | 625 | 32 |
910368 | 910368 | 2021-01-08 | Franklin | Vermont | 50011 | 619 | 32 |
907123 | 907123 | 2021-01-07 | Franklin | Vermont | 50011 | 601 | 31 |
903877 | 903877 | 2021-01-06 | Franklin | Vermont | 50011 | 593 | 31 |
900632 | 900632 | 2021-01-05 | Franklin | Vermont | 50011 | 584 | 30 |
897387 | 897387 | 2021-01-04 | Franklin | Vermont | 50011 | 570 | 28 |
894141 | 894141 | 2021-01-03 | Franklin | Vermont | 50011 | 569 | 26 |
890895 | 890895 | 2021-01-02 | Franklin | Vermont | 50011 | 564 | 26 |
887648 | 887648 | 2021-01-01 | Franklin | Vermont | 50011 | 542 | 25 |
884403 | 884403 | 2020-12-31 | Franklin | Vermont | 50011 | 542 | 25 |
881158 | 881158 | 2020-12-30 | Franklin | Vermont | 50011 | 536 | 25 |
877913 | 877913 | 2020-12-29 | Franklin | Vermont | 50011 | 525 | 25 |
874668 | 874668 | 2020-12-28 | Franklin | Vermont | 50011 | 522 | 25 |
871423 | 871423 | 2020-12-27 | Franklin | Vermont | 50011 | 520 | 25 |
868178 | 868178 | 2020-12-26 | Franklin | Vermont | 50011 | 513 | 23 |
864933 | 864933 | 2020-12-25 | Franklin | Vermont | 50011 | 487 | 23 |
861688 | 861688 | 2020-12-24 | Franklin | Vermont | 50011 | 487 | 23 |
858443 | 858443 | 2020-12-23 | Franklin | Vermont | 50011 | 479 | 21 |
855198 | 855198 | 2020-12-22 | Franklin | Vermont | 50011 | 470 | 19 |
851953 | 851953 | 2020-12-21 | Franklin | Vermont | 50011 | 463 | 19 |
848708 | 848708 | 2020-12-20 | Franklin | Vermont | 50011 | 454 | 19 |
845463 | 845463 | 2020-12-19 | Franklin | Vermont | 50011 | 441 | 18 |
842217 | 842217 | 2020-12-18 | Franklin | Vermont | 50011 | 437 | 18 |
838972 | 838972 | 2020-12-17 | Franklin | Vermont | 50011 | 424 | 18 |
835726 | 835726 | 2020-12-16 | Franklin | Vermont | 50011 | 417 | 18 |
832480 | 832480 | 2020-12-15 | Franklin | Vermont | 50011 | 411 | 15 |
829233 | 829233 | 2020-12-14 | Franklin | Vermont | 50011 | 405 | 14 |
825987 | 825987 | 2020-12-13 | Franklin | Vermont | 50011 | 396 | 14 |
822740 | 822740 | 2020-12-12 | Franklin | Vermont | 50011 | 375 | 14 |
819494 | 819494 | 2020-12-11 | Franklin | Vermont | 50011 | 365 | 13 |
816248 | 816248 | 2020-12-10 | Franklin | Vermont | 50011 | 349 | 13 |
813002 | 813002 | 2020-12-09 | Franklin | Vermont | 50011 | 344 | 13 |
809758 | 809758 | 2020-12-08 | Franklin | Vermont | 50011 | 325 | 13 |
806513 | 806513 | 2020-12-07 | Franklin | Vermont | 50011 | 321 | 12 |
803268 | 803268 | 2020-12-06 | Franklin | Vermont | 50011 | 317 | 12 |
800023 | 800023 | 2020-12-05 | Franklin | Vermont | 50011 | 304 | 12 |
796778 | 796778 | 2020-12-04 | Franklin | Vermont | 50011 | 296 | 11 |
793533 | 793533 | 2020-12-03 | Franklin | Vermont | 50011 | 288 | 11 |
790288 | 790288 | 2020-12-02 | Franklin | Vermont | 50011 | 275 | 11 |
787043 | 787043 | 2020-12-01 | Franklin | Vermont | 50011 | 260 | 10 |
783799 | 783799 | 2020-11-30 | Franklin | Vermont | 50011 | 245 | 8 |
780554 | 780554 | 2020-11-29 | Franklin | Vermont | 50011 | 233 | 7 |
777308 | 777308 | 2020-11-28 | Franklin | Vermont | 50011 | 218 | 7 |
774063 | 774063 | 2020-11-27 | Franklin | Vermont | 50011 | 212 | 7 |
770818 | 770818 | 2020-11-26 | Franklin | Vermont | 50011 | 200 | 7 |
767572 | 767572 | 2020-11-25 | Franklin | Vermont | 50011 | 200 | 7 |
764327 | 764327 | 2020-11-24 | Franklin | Vermont | 50011 | 194 | 7 |
761082 | 761082 | 2020-11-23 | Franklin | Vermont | 50011 | 193 | 7 |
757837 | 757837 | 2020-11-22 | Franklin | Vermont | 50011 | 192 | 7 |
754590 | 754590 | 2020-11-21 | Franklin | Vermont | 50011 | 191 | 7 |
751344 | 751344 | 2020-11-20 | Franklin | Vermont | 50011 | 187 | 7 |
748098 | 748098 | 2020-11-19 | Franklin | Vermont | 50011 | 183 | 7 |
744852 | 744852 | 2020-11-18 | Franklin | Vermont | 50011 | 173 | 7 |
741605 | 741605 | 2020-11-17 | Franklin | Vermont | 50011 | 171 | 7 |
738358 | 738358 | 2020-11-16 | Franklin | Vermont | 50011 | 169 | 7 |
735114 | 735114 | 2020-11-15 | Franklin | Vermont | 50011 | 163 | 7 |
731868 | 731868 | 2020-11-14 | Franklin | Vermont | 50011 | 161 | 7 |
728623 | 728623 | 2020-11-13 | Franklin | Vermont | 50011 | 159 | 7 |
725380 | 725380 | 2020-11-12 | Franklin | Vermont | 50011 | 156 | 7 |
722137 | 722137 | 2020-11-11 | Franklin | Vermont | 50011 | 152 | 7 |
718894 | 718894 | 2020-11-10 | Franklin | Vermont | 50011 | 148 | 7 |
715651 | 715651 | 2020-11-09 | Franklin | Vermont | 50011 | 148 | 7 |
712407 | 712407 | 2020-11-08 | Franklin | Vermont | 50011 | 146 | 7 |
709163 | 709163 | 2020-11-07 | Franklin | Vermont | 50011 | 144 | 7 |
705919 | 705919 | 2020-11-06 | Franklin | Vermont | 50011 | 144 | 7 |
702676 | 702676 | 2020-11-05 | Franklin | Vermont | 50011 | 144 | 7 |
699433 | 699433 | 2020-11-04 | Franklin | Vermont | 50011 | 143 | 7 |
696189 | 696189 | 2020-11-03 | Franklin | Vermont | 50011 | 143 | 7 |
692947 | 692947 | 2020-11-02 | Franklin | Vermont | 50011 | 143 | 7 |
689703 | 689703 | 2020-11-01 | Franklin | Vermont | 50011 | 143 | 7 |
686458 | 686458 | 2020-10-31 | Franklin | Vermont | 50011 | 143 | 7 |
683215 | 683215 | 2020-10-30 | Franklin | Vermont | 50011 | 142 | 7 |
679972 | 679972 | 2020-10-29 | Franklin | Vermont | 50011 | 142 | 7 |
676729 | 676729 | 2020-10-28 | Franklin | Vermont | 50011 | 142 | 7 |
673486 | 673486 | 2020-10-27 | Franklin | Vermont | 50011 | 142 | 7 |
670244 | 670244 | 2020-10-26 | Franklin | Vermont | 50011 | 135 | 7 |
667001 | 667001 | 2020-10-25 | Franklin | Vermont | 50011 | 135 | 7 |
663756 | 663756 | 2020-10-24 | Franklin | Vermont | 50011 | 134 | 7 |
660512 | 660512 | 2020-10-23 | Franklin | Vermont | 50011 | 133 | 7 |
657268 | 657268 | 2020-10-22 | Franklin | Vermont | 50011 | 133 | 7 |
654023 | 654023 | 2020-10-21 | Franklin | Vermont | 50011 | 132 | 7 |
650778 | 650778 | 2020-10-20 | Franklin | Vermont | 50011 | 132 | 7 |
647534 | 647534 | 2020-10-19 | Franklin | Vermont | 50011 | 132 | 7 |
644288 | 644288 | 2020-10-18 | Franklin | Vermont | 50011 | 132 | 7 |
641040 | 641040 | 2020-10-17 | Franklin | Vermont | 50011 | 131 | 7 |
637793 | 637793 | 2020-10-16 | Franklin | Vermont | 50011 | 131 | 7 |
634548 | 634548 | 2020-10-15 | Franklin | Vermont | 50011 | 131 | 7 |
631303 | 631303 | 2020-10-14 | Franklin | Vermont | 50011 | 131 | 7 |
628059 | 628059 | 2020-10-13 | Franklin | Vermont | 50011 | 131 | 7 |
624816 | 624816 | 2020-10-12 | Franklin | Vermont | 50011 | 131 | 7 |
621573 | 621573 | 2020-10-11 | Franklin | Vermont | 50011 | 131 | 7 |
618330 | 618330 | 2020-10-10 | Franklin | Vermont | 50011 | 131 | 7 |
615088 | 615088 | 2020-10-09 | Franklin | Vermont | 50011 | 131 | 7 |
611847 | 611847 | 2020-10-08 | Franklin | Vermont | 50011 | 131 | 7 |
608605 | 608605 | 2020-10-07 | Franklin | Vermont | 50011 | 130 | 7 |
605362 | 605362 | 2020-10-06 | Franklin | Vermont | 50011 | 130 | 7 |
602120 | 602120 | 2020-10-05 | Franklin | Vermont | 50011 | 130 | 7 |
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);