ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Brazoria" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923078 | 923078 | 2021-01-12 | Brazoria | Texas | 48039 | 24330 | 257 |
919833 | 919833 | 2021-01-11 | Brazoria | Texas | 48039 | 23990 | 255 |
916588 | 916588 | 2021-01-10 | Brazoria | Texas | 48039 | 23746 | 255 |
913343 | 913343 | 2021-01-09 | Brazoria | Texas | 48039 | 23499 | 254 |
910098 | 910098 | 2021-01-08 | Brazoria | Texas | 48039 | 23228 | 250 |
906853 | 906853 | 2021-01-07 | Brazoria | Texas | 48039 | 22947 | 250 |
903607 | 903607 | 2021-01-06 | Brazoria | Texas | 48039 | 22651 | 246 |
900362 | 900362 | 2021-01-05 | Brazoria | Texas | 48039 | 22411 | 245 |
897117 | 897117 | 2021-01-04 | Brazoria | Texas | 48039 | 21785 | 243 |
893871 | 893871 | 2021-01-03 | Brazoria | Texas | 48039 | 21785 | 243 |
890625 | 890625 | 2021-01-02 | Brazoria | Texas | 48039 | 21553 | 243 |
887378 | 887378 | 2021-01-01 | Brazoria | Texas | 48039 | 21553 | 242 |
884133 | 884133 | 2020-12-31 | Brazoria | Texas | 48039 | 21271 | 238 |
880888 | 880888 | 2020-12-30 | Brazoria | Texas | 48039 | 20918 | 234 |
877643 | 877643 | 2020-12-29 | Brazoria | Texas | 48039 | 20688 | 232 |
874398 | 874398 | 2020-12-28 | Brazoria | Texas | 48039 | 20664 | 230 |
871153 | 871153 | 2020-12-27 | Brazoria | Texas | 48039 | 20223 | 229 |
867908 | 867908 | 2020-12-26 | Brazoria | Texas | 48039 | 19992 | 229 |
864663 | 864663 | 2020-12-25 | Brazoria | Texas | 48039 | 19992 | 229 |
861418 | 861418 | 2020-12-24 | Brazoria | Texas | 48039 | 19789 | 228 |
858173 | 858173 | 2020-12-23 | Brazoria | Texas | 48039 | 19516 | 226 |
854928 | 854928 | 2020-12-22 | Brazoria | Texas | 48039 | 19154 | 224 |
851683 | 851683 | 2020-12-21 | Brazoria | Texas | 48039 | 18851 | 224 |
848438 | 848438 | 2020-12-20 | Brazoria | Texas | 48039 | 18851 | 224 |
845193 | 845193 | 2020-12-19 | Brazoria | Texas | 48039 | 18551 | 224 |
841947 | 841947 | 2020-12-18 | Brazoria | Texas | 48039 | 18350 | 222 |
838702 | 838702 | 2020-12-17 | Brazoria | Texas | 48039 | 18016 | 218 |
835456 | 835456 | 2020-12-16 | Brazoria | Texas | 48039 | 17683 | 214 |
832210 | 832210 | 2020-12-15 | Brazoria | Texas | 48039 | 17511 | 212 |
828963 | 828963 | 2020-12-14 | Brazoria | Texas | 48039 | 17386 | 210 |
825717 | 825717 | 2020-12-13 | Brazoria | Texas | 48039 | 17185 | 210 |
822470 | 822470 | 2020-12-12 | Brazoria | Texas | 48039 | 16936 | 210 |
819224 | 819224 | 2020-12-11 | Brazoria | Texas | 48039 | 16823 | 210 |
815978 | 815978 | 2020-12-10 | Brazoria | Texas | 48039 | 15695 | 209 |
812732 | 812732 | 2020-12-09 | Brazoria | Texas | 48039 | 15586 | 209 |
809488 | 809488 | 2020-12-08 | Brazoria | Texas | 48039 | 15513 | 208 |
806243 | 806243 | 2020-12-07 | Brazoria | Texas | 48039 | 15419 | 208 |
802998 | 802998 | 2020-12-06 | Brazoria | Texas | 48039 | 15213 | 207 |
799753 | 799753 | 2020-12-05 | Brazoria | Texas | 48039 | 15088 | 207 |
796508 | 796508 | 2020-12-04 | Brazoria | Texas | 48039 | 14895 | 206 |
793263 | 793263 | 2020-12-03 | Brazoria | Texas | 48039 | 14726 | 206 |
790018 | 790018 | 2020-12-02 | Brazoria | Texas | 48039 | 14645 | 204 |
786773 | 786773 | 2020-12-01 | Brazoria | Texas | 48039 | 14574 | 202 |
783529 | 783529 | 2020-11-30 | Brazoria | Texas | 48039 | 14511 | 200 |
780284 | 780284 | 2020-11-29 | Brazoria | Texas | 48039 | 14389 | 200 |
777038 | 777038 | 2020-11-28 | Brazoria | Texas | 48039 | 14154 | 200 |
773793 | 773793 | 2020-11-27 | Brazoria | Texas | 48039 | 14154 | 200 |
770548 | 770548 | 2020-11-26 | Brazoria | Texas | 48039 | 14154 | 200 |
767302 | 767302 | 2020-11-25 | Brazoria | Texas | 48039 | 14050 | 200 |
764057 | 764057 | 2020-11-24 | Brazoria | Texas | 48039 | 13924 | 199 |
760812 | 760812 | 2020-11-23 | Brazoria | Texas | 48039 | 13857 | 196 |
757567 | 757567 | 2020-11-22 | Brazoria | Texas | 48039 | 13824 | 195 |
754320 | 754320 | 2020-11-21 | Brazoria | Texas | 48039 | 13722 | 194 |
751074 | 751074 | 2020-11-20 | Brazoria | Texas | 48039 | 13626 | 194 |
747828 | 747828 | 2020-11-19 | Brazoria | Texas | 48039 | 13516 | 193 |
744582 | 744582 | 2020-11-18 | Brazoria | Texas | 48039 | 13455 | 192 |
741335 | 741335 | 2020-11-17 | Brazoria | Texas | 48039 | 13364 | 192 |
738089 | 738089 | 2020-11-16 | Brazoria | Texas | 48039 | 13308 | 190 |
734845 | 734845 | 2020-11-15 | Brazoria | Texas | 48039 | 13308 | 190 |
731599 | 731599 | 2020-11-14 | Brazoria | Texas | 48039 | 13243 | 190 |
728354 | 728354 | 2020-11-13 | Brazoria | Texas | 48039 | 13185 | 190 |
725111 | 725111 | 2020-11-12 | Brazoria | Texas | 48039 | 13098 | 190 |
721868 | 721868 | 2020-11-11 | Brazoria | Texas | 48039 | 13059 | 189 |
718625 | 718625 | 2020-11-10 | Brazoria | Texas | 48039 | 13247 | 189 |
715382 | 715382 | 2020-11-09 | Brazoria | Texas | 48039 | 12950 | 189 |
712138 | 712138 | 2020-11-08 | Brazoria | Texas | 48039 | 12904 | 188 |
708894 | 708894 | 2020-11-07 | Brazoria | Texas | 48039 | 12850 | 188 |
705650 | 705650 | 2020-11-06 | Brazoria | Texas | 48039 | 12806 | 188 |
702407 | 702407 | 2020-11-05 | Brazoria | Texas | 48039 | 12731 | 187 |
699164 | 699164 | 2020-11-04 | Brazoria | Texas | 48039 | 12718 | 187 |
695920 | 695920 | 2020-11-03 | Brazoria | Texas | 48039 | 12687 | 186 |
692678 | 692678 | 2020-11-02 | Brazoria | Texas | 48039 | 12687 | 185 |
689434 | 689434 | 2020-11-01 | Brazoria | Texas | 48039 | 12501 | 185 |
686189 | 686189 | 2020-10-31 | Brazoria | Texas | 48039 | 12501 | 185 |
682946 | 682946 | 2020-10-30 | Brazoria | Texas | 48039 | 12436 | 185 |
679703 | 679703 | 2020-10-29 | Brazoria | Texas | 48039 | 12387 | 184 |
676460 | 676460 | 2020-10-28 | Brazoria | Texas | 48039 | 12333 | 184 |
673217 | 673217 | 2020-10-27 | Brazoria | Texas | 48039 | 12295 | 183 |
669975 | 669975 | 2020-10-26 | Brazoria | Texas | 48039 | 12271 | 182 |
666732 | 666732 | 2020-10-25 | Brazoria | Texas | 48039 | 12243 | 182 |
663487 | 663487 | 2020-10-24 | Brazoria | Texas | 48039 | 12191 | 182 |
660243 | 660243 | 2020-10-23 | Brazoria | Texas | 48039 | 12105 | 181 |
656999 | 656999 | 2020-10-22 | Brazoria | Texas | 48039 | 12060 | 179 |
653754 | 653754 | 2020-10-21 | Brazoria | Texas | 48039 | 12060 | 179 |
650509 | 650509 | 2020-10-20 | Brazoria | Texas | 48039 | 12027 | 179 |
647265 | 647265 | 2020-10-19 | Brazoria | Texas | 48039 | 12008 | 179 |
644019 | 644019 | 2020-10-18 | Brazoria | Texas | 48039 | 11954 | 179 |
640771 | 640771 | 2020-10-17 | Brazoria | Texas | 48039 | 11954 | 179 |
637524 | 637524 | 2020-10-16 | Brazoria | Texas | 48039 | 11917 | 179 |
634279 | 634279 | 2020-10-15 | Brazoria | Texas | 48039 | 11895 | 177 |
631034 | 631034 | 2020-10-14 | Brazoria | Texas | 48039 | 11847 | 175 |
627790 | 627790 | 2020-10-13 | Brazoria | Texas | 48039 | 11801 | 173 |
624548 | 624548 | 2020-10-12 | Brazoria | Texas | 48039 | 11791 | 173 |
621305 | 621305 | 2020-10-11 | Brazoria | Texas | 48039 | 11762 | 173 |
618062 | 618062 | 2020-10-10 | Brazoria | Texas | 48039 | 11736 | 173 |
614820 | 614820 | 2020-10-09 | Brazoria | Texas | 48039 | 11703 | 173 |
611579 | 611579 | 2020-10-08 | Brazoria | Texas | 48039 | 11691 | 173 |
608337 | 608337 | 2020-10-07 | Brazoria | Texas | 48039 | 11658 | 173 |
605094 | 605094 | 2020-10-06 | Brazoria | Texas | 48039 | 11603 | 172 |
601852 | 601852 | 2020-10-05 | Brazoria | Texas | 48039 | 11575 | 171 |
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);