ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Van Zandt" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923292 | 923292 | 2021-01-12 | Van Zandt | Texas | 48467 | 3014 | 69 |
920047 | 920047 | 2021-01-11 | Van Zandt | Texas | 48467 | 2712 | 69 |
916802 | 916802 | 2021-01-10 | Van Zandt | Texas | 48467 | 2712 | 69 |
913557 | 913557 | 2021-01-09 | Van Zandt | Texas | 48467 | 2712 | 70 |
910312 | 910312 | 2021-01-08 | Van Zandt | Texas | 48467 | 2712 | 69 |
907067 | 907067 | 2021-01-07 | Van Zandt | Texas | 48467 | 2637 | 68 |
903821 | 903821 | 2021-01-06 | Van Zandt | Texas | 48467 | 2637 | 67 |
900576 | 900576 | 2021-01-05 | Van Zandt | Texas | 48467 | 2592 | 66 |
897331 | 897331 | 2021-01-04 | Van Zandt | Texas | 48467 | 2550 | 65 |
894085 | 894085 | 2021-01-03 | Van Zandt | Texas | 48467 | 2471 | 65 |
890839 | 890839 | 2021-01-02 | Van Zandt | Texas | 48467 | 2471 | 65 |
887592 | 887592 | 2021-01-01 | Van Zandt | Texas | 48467 | 2471 | 63 |
884347 | 884347 | 2020-12-31 | Van Zandt | Texas | 48467 | 2471 | 62 |
881102 | 881102 | 2020-12-30 | Van Zandt | Texas | 48467 | 2444 | 61 |
877857 | 877857 | 2020-12-29 | Van Zandt | Texas | 48467 | 2424 | 61 |
874612 | 874612 | 2020-12-28 | Van Zandt | Texas | 48467 | 2403 | 59 |
871367 | 871367 | 2020-12-27 | Van Zandt | Texas | 48467 | 2353 | 59 |
868122 | 868122 | 2020-12-26 | Van Zandt | Texas | 48467 | 2353 | 59 |
864877 | 864877 | 2020-12-25 | Van Zandt | Texas | 48467 | 2353 | 59 |
861632 | 861632 | 2020-12-24 | Van Zandt | Texas | 48467 | 2353 | 59 |
858387 | 858387 | 2020-12-23 | Van Zandt | Texas | 48467 | 2353 | 58 |
855142 | 855142 | 2020-12-22 | Van Zandt | Texas | 48467 | 2341 | 57 |
851897 | 851897 | 2020-12-21 | Van Zandt | Texas | 48467 | 2315 | 57 |
848652 | 848652 | 2020-12-20 | Van Zandt | Texas | 48467 | 2267 | 57 |
845407 | 845407 | 2020-12-19 | Van Zandt | Texas | 48467 | 2267 | 57 |
842161 | 842161 | 2020-12-18 | Van Zandt | Texas | 48467 | 2267 | 54 |
838916 | 838916 | 2020-12-17 | Van Zandt | Texas | 48467 | 2255 | 53 |
835670 | 835670 | 2020-12-16 | Van Zandt | Texas | 48467 | 2240 | 51 |
832424 | 832424 | 2020-12-15 | Van Zandt | Texas | 48467 | 2220 | 49 |
829177 | 829177 | 2020-12-14 | Van Zandt | Texas | 48467 | 2195 | 49 |
825931 | 825931 | 2020-12-13 | Van Zandt | Texas | 48467 | 2145 | 49 |
822684 | 822684 | 2020-12-12 | Van Zandt | Texas | 48467 | 2145 | 49 |
819438 | 819438 | 2020-12-11 | Van Zandt | Texas | 48467 | 2145 | 46 |
816192 | 816192 | 2020-12-10 | Van Zandt | Texas | 48467 | 2130 | 46 |
812946 | 812946 | 2020-12-09 | Van Zandt | Texas | 48467 | 2114 | 46 |
809702 | 809702 | 2020-12-08 | Van Zandt | Texas | 48467 | 2095 | 46 |
806457 | 806457 | 2020-12-07 | Van Zandt | Texas | 48467 | 2035 | 46 |
803212 | 803212 | 2020-12-06 | Van Zandt | Texas | 48467 | 1905 | 44 |
799967 | 799967 | 2020-12-05 | Van Zandt | Texas | 48467 | 1905 | 44 |
796722 | 796722 | 2020-12-04 | Van Zandt | Texas | 48467 | 1905 | 44 |
793477 | 793477 | 2020-12-03 | Van Zandt | Texas | 48467 | 1831 | 44 |
790232 | 790232 | 2020-12-02 | Van Zandt | Texas | 48467 | 1791 | 44 |
786987 | 786987 | 2020-12-01 | Van Zandt | Texas | 48467 | 1772 | 44 |
783743 | 783743 | 2020-11-30 | Van Zandt | Texas | 48467 | 1726 | 44 |
780498 | 780498 | 2020-11-29 | Van Zandt | Texas | 48467 | 1673 | 44 |
777252 | 777252 | 2020-11-28 | Van Zandt | Texas | 48467 | 1673 | 44 |
774007 | 774007 | 2020-11-27 | Van Zandt | Texas | 48467 | 1673 | 44 |
770762 | 770762 | 2020-11-26 | Van Zandt | Texas | 48467 | 1673 | 44 |
767516 | 767516 | 2020-11-25 | Van Zandt | Texas | 48467 | 1673 | 44 |
764271 | 764271 | 2020-11-24 | Van Zandt | Texas | 48467 | 1628 | 44 |
761026 | 761026 | 2020-11-23 | Van Zandt | Texas | 48467 | 1582 | 44 |
757781 | 757781 | 2020-11-22 | Van Zandt | Texas | 48467 | 1539 | 42 |
754534 | 754534 | 2020-11-21 | Van Zandt | Texas | 48467 | 1539 | 42 |
751288 | 751288 | 2020-11-20 | Van Zandt | Texas | 48467 | 1539 | 42 |
748042 | 748042 | 2020-11-19 | Van Zandt | Texas | 48467 | 1514 | 42 |
744796 | 744796 | 2020-11-18 | Van Zandt | Texas | 48467 | 1490 | 42 |
741549 | 741549 | 2020-11-17 | Van Zandt | Texas | 48467 | 1438 | 42 |
738302 | 738302 | 2020-11-16 | Van Zandt | Texas | 48467 | 1399 | 42 |
735058 | 735058 | 2020-11-15 | Van Zandt | Texas | 48467 | 1306 | 42 |
731812 | 731812 | 2020-11-14 | Van Zandt | Texas | 48467 | 1306 | 42 |
728567 | 728567 | 2020-11-13 | Van Zandt | Texas | 48467 | 1306 | 42 |
725324 | 725324 | 2020-11-12 | Van Zandt | Texas | 48467 | 1255 | 31 |
722081 | 722081 | 2020-11-11 | Van Zandt | Texas | 48467 | 1207 | 31 |
718838 | 718838 | 2020-11-10 | Van Zandt | Texas | 48467 | 1176 | 31 |
715595 | 715595 | 2020-11-09 | Van Zandt | Texas | 48467 | 1146 | 31 |
712351 | 712351 | 2020-11-08 | Van Zandt | Texas | 48467 | 1084 | 31 |
709107 | 709107 | 2020-11-07 | Van Zandt | Texas | 48467 | 1084 | 31 |
705863 | 705863 | 2020-11-06 | Van Zandt | Texas | 48467 | 1084 | 31 |
702620 | 702620 | 2020-11-05 | Van Zandt | Texas | 48467 | 1053 | 31 |
699377 | 699377 | 2020-11-04 | Van Zandt | Texas | 48467 | 1037 | 30 |
696133 | 696133 | 2020-11-03 | Van Zandt | Texas | 48467 | 982 | 30 |
692891 | 692891 | 2020-11-02 | Van Zandt | Texas | 48467 | 982 | 30 |
689647 | 689647 | 2020-11-01 | Van Zandt | Texas | 48467 | 966 | 30 |
686402 | 686402 | 2020-10-31 | Van Zandt | Texas | 48467 | 966 | 30 |
683159 | 683159 | 2020-10-30 | Van Zandt | Texas | 48467 | 966 | 30 |
679916 | 679916 | 2020-10-29 | Van Zandt | Texas | 48467 | 952 | 29 |
676673 | 676673 | 2020-10-28 | Van Zandt | Texas | 48467 | 944 | 29 |
673430 | 673430 | 2020-10-27 | Van Zandt | Texas | 48467 | 926 | 29 |
670188 | 670188 | 2020-10-26 | Van Zandt | Texas | 48467 | 907 | 29 |
666945 | 666945 | 2020-10-25 | Van Zandt | Texas | 48467 | 891 | 29 |
663700 | 663700 | 2020-10-24 | Van Zandt | Texas | 48467 | 891 | 29 |
660456 | 660456 | 2020-10-23 | Van Zandt | Texas | 48467 | 891 | 29 |
657212 | 657212 | 2020-10-22 | Van Zandt | Texas | 48467 | 871 | 29 |
653967 | 653967 | 2020-10-21 | Van Zandt | Texas | 48467 | 857 | 28 |
650722 | 650722 | 2020-10-20 | Van Zandt | Texas | 48467 | 850 | 28 |
647478 | 647478 | 2020-10-19 | Van Zandt | Texas | 48467 | 841 | 28 |
644232 | 644232 | 2020-10-18 | Van Zandt | Texas | 48467 | 829 | 28 |
640984 | 640984 | 2020-10-17 | Van Zandt | Texas | 48467 | 829 | 28 |
637737 | 637737 | 2020-10-16 | Van Zandt | Texas | 48467 | 829 | 28 |
634492 | 634492 | 2020-10-15 | Van Zandt | Texas | 48467 | 812 | 28 |
631247 | 631247 | 2020-10-14 | Van Zandt | Texas | 48467 | 806 | 28 |
628003 | 628003 | 2020-10-13 | Van Zandt | Texas | 48467 | 793 | 28 |
624760 | 624760 | 2020-10-12 | Van Zandt | Texas | 48467 | 781 | 28 |
621517 | 621517 | 2020-10-11 | Van Zandt | Texas | 48467 | 768 | 28 |
618274 | 618274 | 2020-10-10 | Van Zandt | Texas | 48467 | 768 | 28 |
615032 | 615032 | 2020-10-09 | Van Zandt | Texas | 48467 | 768 | 28 |
611791 | 611791 | 2020-10-08 | Van Zandt | Texas | 48467 | 756 | 28 |
608549 | 608549 | 2020-10-07 | Van Zandt | Texas | 48467 | 747 | 28 |
605306 | 605306 | 2020-10-06 | Van Zandt | Texas | 48467 | 736 | 27 |
602064 | 602064 | 2020-10-05 | Van Zandt | Texas | 48467 | 727 | 26 |
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);