ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Bell" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923072 | 923072 | 2021-01-12 | Bell | Texas | 48027 | 15768 | 184 |
919827 | 919827 | 2021-01-11 | Bell | Texas | 48027 | 15499 | 182 |
916582 | 916582 | 2021-01-10 | Bell | Texas | 48027 | 15111 | 182 |
913337 | 913337 | 2021-01-09 | Bell | Texas | 48027 | 15111 | 182 |
910092 | 910092 | 2021-01-08 | Bell | Texas | 48027 | 15005 | 180 |
906847 | 906847 | 2021-01-07 | Bell | Texas | 48027 | 14785 | 179 |
903601 | 903601 | 2021-01-06 | Bell | Texas | 48027 | 14455 | 177 |
900356 | 900356 | 2021-01-05 | Bell | Texas | 48027 | 14019 | 176 |
897111 | 897111 | 2021-01-04 | Bell | Texas | 48027 | 13724 | 170 |
893865 | 893865 | 2021-01-03 | Bell | Texas | 48027 | 13238 | 169 |
890619 | 890619 | 2021-01-02 | Bell | Texas | 48027 | 13238 | 169 |
887372 | 887372 | 2021-01-01 | Bell | Texas | 48027 | 13238 | 168 |
884127 | 884127 | 2020-12-31 | Bell | Texas | 48027 | 13132 | 167 |
880882 | 880882 | 2020-12-30 | Bell | Texas | 48027 | 12824 | 165 |
877637 | 877637 | 2020-12-29 | Bell | Texas | 48027 | 12515 | 164 |
874392 | 874392 | 2020-12-28 | Bell | Texas | 48027 | 12317 | 161 |
871147 | 871147 | 2020-12-27 | Bell | Texas | 48027 | 11802 | 160 |
867902 | 867902 | 2020-12-26 | Bell | Texas | 48027 | 11802 | 159 |
864657 | 864657 | 2020-12-25 | Bell | Texas | 48027 | 11802 | 157 |
861412 | 861412 | 2020-12-24 | Bell | Texas | 48027 | 11802 | 156 |
858167 | 858167 | 2020-12-23 | Bell | Texas | 48027 | 11696 | 153 |
854922 | 854922 | 2020-12-22 | Bell | Texas | 48027 | 11550 | 153 |
851677 | 851677 | 2020-12-21 | Bell | Texas | 48027 | 11409 | 149 |
848432 | 848432 | 2020-12-20 | Bell | Texas | 48027 | 11113 | 149 |
845187 | 845187 | 2020-12-19 | Bell | Texas | 48027 | 11113 | 148 |
841941 | 841941 | 2020-12-18 | Bell | Texas | 48027 | 11007 | 144 |
838696 | 838696 | 2020-12-17 | Bell | Texas | 48027 | 10770 | 144 |
835450 | 835450 | 2020-12-16 | Bell | Texas | 48027 | 10647 | 141 |
832204 | 832204 | 2020-12-15 | Bell | Texas | 48027 | 10536 | 140 |
828957 | 828957 | 2020-12-14 | Bell | Texas | 48027 | 10420 | 140 |
825711 | 825711 | 2020-12-13 | Bell | Texas | 48027 | 10211 | 140 |
822464 | 822464 | 2020-12-12 | Bell | Texas | 48027 | 10211 | 139 |
819218 | 819218 | 2020-12-11 | Bell | Texas | 48027 | 10105 | 137 |
815972 | 815972 | 2020-12-10 | Bell | Texas | 48027 | 9987 | 132 |
812726 | 812726 | 2020-12-09 | Bell | Texas | 48027 | 9793 | 131 |
809482 | 809482 | 2020-12-08 | Bell | Texas | 48027 | 9674 | 129 |
806237 | 806237 | 2020-12-07 | Bell | Texas | 48027 | 9519 | 126 |
802992 | 802992 | 2020-12-06 | Bell | Texas | 48027 | 9170 | 126 |
799747 | 799747 | 2020-12-05 | Bell | Texas | 48027 | 9170 | 125 |
796502 | 796502 | 2020-12-04 | Bell | Texas | 48027 | 9087 | 124 |
793257 | 793257 | 2020-12-03 | Bell | Texas | 48027 | 8981 | 123 |
790012 | 790012 | 2020-12-02 | Bell | Texas | 48027 | 8858 | 121 |
786767 | 786767 | 2020-12-01 | Bell | Texas | 48027 | 8752 | 119 |
783523 | 783523 | 2020-11-30 | Bell | Texas | 48027 | 8443 | 118 |
780278 | 780278 | 2020-11-29 | Bell | Texas | 48027 | 8443 | 117 |
777032 | 777032 | 2020-11-28 | Bell | Texas | 48027 | 8443 | 116 |
773787 | 773787 | 2020-11-27 | Bell | Texas | 48027 | 8443 | 115 |
770542 | 770542 | 2020-11-26 | Bell | Texas | 48027 | 8443 | 115 |
767296 | 767296 | 2020-11-25 | Bell | Texas | 48027 | 8344 | 113 |
764051 | 764051 | 2020-11-24 | Bell | Texas | 48027 | 8238 | 112 |
760806 | 760806 | 2020-11-23 | Bell | Texas | 48027 | 8112 | 112 |
757561 | 757561 | 2020-11-22 | Bell | Texas | 48027 | 8018 | 112 |
754314 | 754314 | 2020-11-21 | Bell | Texas | 48027 | 8018 | 112 |
751068 | 751068 | 2020-11-20 | Bell | Texas | 48027 | 7912 | 112 |
747822 | 747822 | 2020-11-19 | Bell | Texas | 48027 | 7820 | 112 |
744576 | 744576 | 2020-11-18 | Bell | Texas | 48027 | 7733 | 111 |
741329 | 741329 | 2020-11-17 | Bell | Texas | 48027 | 7627 | 111 |
738083 | 738083 | 2020-11-16 | Bell | Texas | 48027 | 7443 | 109 |
734839 | 734839 | 2020-11-15 | Bell | Texas | 48027 | 7352 | 109 |
731593 | 731593 | 2020-11-14 | Bell | Texas | 48027 | 7318 | 108 |
728348 | 728348 | 2020-11-13 | Bell | Texas | 48027 | 7235 | 107 |
725105 | 725105 | 2020-11-12 | Bell | Texas | 48027 | 7129 | 105 |
721862 | 721862 | 2020-11-11 | Bell | Texas | 48027 | 7088 | 104 |
718619 | 718619 | 2020-11-10 | Bell | Texas | 48027 | 7009 | 104 |
715376 | 715376 | 2020-11-09 | Bell | Texas | 48027 | 6903 | 104 |
712132 | 712132 | 2020-11-08 | Bell | Texas | 48027 | 6860 | 104 |
708888 | 708888 | 2020-11-07 | Bell | Texas | 48027 | 6866 | 104 |
705644 | 705644 | 2020-11-06 | Bell | Texas | 48027 | 6853 | 103 |
702401 | 702401 | 2020-11-05 | Bell | Texas | 48027 | 6770 | 103 |
699158 | 699158 | 2020-11-04 | Bell | Texas | 48027 | 6706 | 102 |
695914 | 695914 | 2020-11-03 | Bell | Texas | 48027 | 6647 | 101 |
692672 | 692672 | 2020-11-02 | Bell | Texas | 48027 | 6560 | 100 |
689428 | 689428 | 2020-11-01 | Bell | Texas | 48027 | 6560 | 100 |
686183 | 686183 | 2020-10-31 | Bell | Texas | 48027 | 6560 | 100 |
682940 | 682940 | 2020-10-30 | Bell | Texas | 48027 | 6534 | 100 |
679697 | 679697 | 2020-10-29 | Bell | Texas | 48027 | 6496 | 100 |
676454 | 676454 | 2020-10-28 | Bell | Texas | 48027 | 6427 | 100 |
673211 | 673211 | 2020-10-27 | Bell | Texas | 48027 | 6391 | 100 |
669969 | 669969 | 2020-10-26 | Bell | Texas | 48027 | 6327 | 100 |
666726 | 666726 | 2020-10-25 | Bell | Texas | 48027 | 6327 | 100 |
663481 | 663481 | 2020-10-24 | Bell | Texas | 48027 | 6327 | 99 |
660237 | 660237 | 2020-10-23 | Bell | Texas | 48027 | 6221 | 97 |
656993 | 656993 | 2020-10-22 | Bell | Texas | 48027 | 6169 | 96 |
653748 | 653748 | 2020-10-21 | Bell | Texas | 48027 | 6158 | 96 |
650503 | 650503 | 2020-10-20 | Bell | Texas | 48027 | 6133 | 96 |
647259 | 647259 | 2020-10-19 | Bell | Texas | 48027 | 6064 | 96 |
644013 | 644013 | 2020-10-18 | Bell | Texas | 48027 | 6064 | 96 |
640765 | 640765 | 2020-10-17 | Bell | Texas | 48027 | 6064 | 96 |
637518 | 637518 | 2020-10-16 | Bell | Texas | 48027 | 6015 | 95 |
634273 | 634273 | 2020-10-15 | Bell | Texas | 48027 | 5959 | 94 |
631028 | 631028 | 2020-10-14 | Bell | Texas | 48027 | 5931 | 94 |
627784 | 627784 | 2020-10-13 | Bell | Texas | 48027 | 5825 | 94 |
624542 | 624542 | 2020-10-12 | Bell | Texas | 48027 | 5801 | 93 |
621299 | 621299 | 2020-10-11 | Bell | Texas | 48027 | 5801 | 93 |
618056 | 618056 | 2020-10-10 | Bell | Texas | 48027 | 5801 | 92 |
614814 | 614814 | 2020-10-09 | Bell | Texas | 48027 | 5775 | 92 |
611573 | 611573 | 2020-10-08 | Bell | Texas | 48027 | 5749 | 92 |
608331 | 608331 | 2020-10-07 | Bell | Texas | 48027 | 5721 | 91 |
605088 | 605088 | 2020-10-06 | Bell | Texas | 48027 | 5690 | 90 |
601846 | 601846 | 2020-10-05 | Bell | Texas | 48027 | 5623 | 89 |
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);