ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Comal" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923104 | 923104 | 2021-01-12 | Comal | Texas | 48091 | 6956 | 188 |
919859 | 919859 | 2021-01-11 | Comal | Texas | 48091 | 6863 | 186 |
916614 | 916614 | 2021-01-10 | Comal | Texas | 48091 | 6863 | 186 |
913369 | 913369 | 2021-01-09 | Comal | Texas | 48091 | 6863 | 186 |
910124 | 910124 | 2021-01-08 | Comal | Texas | 48091 | 6781 | 186 |
906879 | 906879 | 2021-01-07 | Comal | Texas | 48091 | 6696 | 180 |
903633 | 903633 | 2021-01-06 | Comal | Texas | 48091 | 6623 | 178 |
900388 | 900388 | 2021-01-05 | Comal | Texas | 48091 | 6536 | 168 |
897143 | 897143 | 2021-01-04 | Comal | Texas | 48091 | 6366 | 163 |
893897 | 893897 | 2021-01-03 | Comal | Texas | 48091 | 6366 | 163 |
890651 | 890651 | 2021-01-02 | Comal | Texas | 48091 | 6366 | 163 |
887404 | 887404 | 2021-01-01 | Comal | Texas | 48091 | 6366 | 163 |
884159 | 884159 | 2020-12-31 | Comal | Texas | 48091 | 6239 | 158 |
880914 | 880914 | 2020-12-30 | Comal | Texas | 48091 | 6168 | 158 |
877669 | 877669 | 2020-12-29 | Comal | Texas | 48091 | 6113 | 157 |
874424 | 874424 | 2020-12-28 | Comal | Texas | 48091 | 6000 | 146 |
871179 | 871179 | 2020-12-27 | Comal | Texas | 48091 | 6000 | 146 |
867934 | 867934 | 2020-12-26 | Comal | Texas | 48091 | 6000 | 146 |
864689 | 864689 | 2020-12-25 | Comal | Texas | 48091 | 6000 | 146 |
861444 | 861444 | 2020-12-24 | Comal | Texas | 48091 | 6000 | 146 |
858199 | 858199 | 2020-12-23 | Comal | Texas | 48091 | 5921 | 146 |
854954 | 854954 | 2020-12-22 | Comal | Texas | 48091 | 5831 | 146 |
851709 | 851709 | 2020-12-21 | Comal | Texas | 48091 | 5751 | 141 |
848464 | 848464 | 2020-12-20 | Comal | Texas | 48091 | 5751 | 141 |
845219 | 845219 | 2020-12-19 | Comal | Texas | 48091 | 5751 | 141 |
841973 | 841973 | 2020-12-18 | Comal | Texas | 48091 | 5675 | 141 |
838728 | 838728 | 2020-12-17 | Comal | Texas | 48091 | 5571 | 141 |
835482 | 835482 | 2020-12-16 | Comal | Texas | 48091 | 5499 | 139 |
832236 | 832236 | 2020-12-15 | Comal | Texas | 48091 | 5420 | 138 |
828989 | 828989 | 2020-12-14 | Comal | Texas | 48091 | 5326 | 136 |
825743 | 825743 | 2020-12-13 | Comal | Texas | 48091 | 5326 | 136 |
822496 | 822496 | 2020-12-12 | Comal | Texas | 48091 | 5326 | 136 |
819250 | 819250 | 2020-12-11 | Comal | Texas | 48091 | 5267 | 136 |
816004 | 816004 | 2020-12-10 | Comal | Texas | 48091 | 5201 | 135 |
812758 | 812758 | 2020-12-09 | Comal | Texas | 48091 | 5130 | 133 |
809514 | 809514 | 2020-12-08 | Comal | Texas | 48091 | 5056 | 133 |
806269 | 806269 | 2020-12-07 | Comal | Texas | 48091 | 4980 | 132 |
803024 | 803024 | 2020-12-06 | Comal | Texas | 48091 | 4980 | 132 |
799779 | 799779 | 2020-12-05 | Comal | Texas | 48091 | 4980 | 132 |
796534 | 796534 | 2020-12-04 | Comal | Texas | 48091 | 4928 | 131 |
793289 | 793289 | 2020-12-03 | Comal | Texas | 48091 | 4782 | 131 |
790044 | 790044 | 2020-12-02 | Comal | Texas | 48091 | 4690 | 130 |
786799 | 786799 | 2020-12-01 | Comal | Texas | 48091 | 4592 | 130 |
783555 | 783555 | 2020-11-30 | Comal | Texas | 48091 | 4505 | 128 |
780310 | 780310 | 2020-11-29 | Comal | Texas | 48091 | 4505 | 128 |
777064 | 777064 | 2020-11-28 | Comal | Texas | 48091 | 4505 | 128 |
773819 | 773819 | 2020-11-27 | Comal | Texas | 48091 | 4505 | 128 |
770574 | 770574 | 2020-11-26 | Comal | Texas | 48091 | 4505 | 128 |
767328 | 767328 | 2020-11-25 | Comal | Texas | 48091 | 4464 | 128 |
764083 | 764083 | 2020-11-24 | Comal | Texas | 48091 | 4415 | 127 |
760838 | 760838 | 2020-11-23 | Comal | Texas | 48091 | 4355 | 125 |
757593 | 757593 | 2020-11-22 | Comal | Texas | 48091 | 4355 | 125 |
754346 | 754346 | 2020-11-21 | Comal | Texas | 48091 | 4355 | 125 |
751100 | 751100 | 2020-11-20 | Comal | Texas | 48091 | 4335 | 125 |
747854 | 747854 | 2020-11-19 | Comal | Texas | 48091 | 4285 | 125 |
744608 | 744608 | 2020-11-18 | Comal | Texas | 48091 | 4240 | 124 |
741361 | 741361 | 2020-11-17 | Comal | Texas | 48091 | 4198 | 124 |
738115 | 738115 | 2020-11-16 | Comal | Texas | 48091 | 4131 | 124 |
734871 | 734871 | 2020-11-15 | Comal | Texas | 48091 | 4131 | 124 |
731625 | 731625 | 2020-11-14 | Comal | Texas | 48091 | 4131 | 124 |
728380 | 728380 | 2020-11-13 | Comal | Texas | 48091 | 4090 | 124 |
725137 | 725137 | 2020-11-12 | Comal | Texas | 48091 | 4005 | 124 |
721894 | 721894 | 2020-11-11 | Comal | Texas | 48091 | 4005 | 124 |
718651 | 718651 | 2020-11-10 | Comal | Texas | 48091 | 3994 | 123 |
715408 | 715408 | 2020-11-09 | Comal | Texas | 48091 | 3939 | 122 |
712164 | 712164 | 2020-11-08 | Comal | Texas | 48091 | 3939 | 122 |
708920 | 708920 | 2020-11-07 | Comal | Texas | 48091 | 3939 | 122 |
705676 | 705676 | 2020-11-06 | Comal | Texas | 48091 | 3916 | 122 |
702433 | 702433 | 2020-11-05 | Comal | Texas | 48091 | 3879 | 121 |
699190 | 699190 | 2020-11-04 | Comal | Texas | 48091 | 3844 | 121 |
695946 | 695946 | 2020-11-03 | Comal | Texas | 48091 | 3825 | 120 |
692704 | 692704 | 2020-11-02 | Comal | Texas | 48091 | 3796 | 120 |
689460 | 689460 | 2020-11-01 | Comal | Texas | 48091 | 3796 | 120 |
686215 | 686215 | 2020-10-31 | Comal | Texas | 48091 | 3796 | 120 |
682972 | 682972 | 2020-10-30 | Comal | Texas | 48091 | 3776 | 120 |
679729 | 679729 | 2020-10-29 | Comal | Texas | 48091 | 3764 | 120 |
676486 | 676486 | 2020-10-28 | Comal | Texas | 48091 | 3755 | 120 |
673243 | 673243 | 2020-10-27 | Comal | Texas | 48091 | 3736 | 120 |
670001 | 670001 | 2020-10-26 | Comal | Texas | 48091 | 3709 | 120 |
666758 | 666758 | 2020-10-25 | Comal | Texas | 48091 | 3709 | 120 |
663513 | 663513 | 2020-10-24 | Comal | Texas | 48091 | 3709 | 120 |
660269 | 660269 | 2020-10-23 | Comal | Texas | 48091 | 3701 | 120 |
657025 | 657025 | 2020-10-22 | Comal | Texas | 48091 | 3693 | 120 |
653780 | 653780 | 2020-10-21 | Comal | Texas | 48091 | 3677 | 120 |
650535 | 650535 | 2020-10-20 | Comal | Texas | 48091 | 3659 | 120 |
647291 | 647291 | 2020-10-19 | Comal | Texas | 48091 | 3642 | 120 |
644045 | 644045 | 2020-10-18 | Comal | Texas | 48091 | 3642 | 120 |
640797 | 640797 | 2020-10-17 | Comal | Texas | 48091 | 3642 | 120 |
637550 | 637550 | 2020-10-16 | Comal | Texas | 48091 | 3642 | 120 |
634305 | 634305 | 2020-10-15 | Comal | Texas | 48091 | 3626 | 120 |
631060 | 631060 | 2020-10-14 | Comal | Texas | 48091 | 3607 | 120 |
627816 | 627816 | 2020-10-13 | Comal | Texas | 48091 | 3595 | 120 |
624574 | 624574 | 2020-10-12 | Comal | Texas | 48091 | 3568 | 120 |
621331 | 621331 | 2020-10-11 | Comal | Texas | 48091 | 3568 | 120 |
618088 | 618088 | 2020-10-10 | Comal | Texas | 48091 | 3568 | 120 |
614846 | 614846 | 2020-10-09 | Comal | Texas | 48091 | 3550 | 120 |
611605 | 611605 | 2020-10-08 | Comal | Texas | 48091 | 3534 | 116 |
608363 | 608363 | 2020-10-07 | Comal | Texas | 48091 | 3529 | 116 |
605120 | 605120 | 2020-10-06 | Comal | Texas | 48091 | 3520 | 116 |
601878 | 601878 | 2020-10-05 | Comal | Texas | 48091 | 3506 | 116 |
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);