ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
718 rows where fips = 48229 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923173 | 923173 | 2021-01-12 | Hudspeth | Texas | 48229 | 479 | 8 |
919928 | 919928 | 2021-01-11 | Hudspeth | Texas | 48229 | 476 | 8 |
916683 | 916683 | 2021-01-10 | Hudspeth | Texas | 48229 | 470 | 8 |
913438 | 913438 | 2021-01-09 | Hudspeth | Texas | 48229 | 468 | 8 |
910193 | 910193 | 2021-01-08 | Hudspeth | Texas | 48229 | 466 | 8 |
906948 | 906948 | 2021-01-07 | Hudspeth | Texas | 48229 | 455 | 8 |
903702 | 903702 | 2021-01-06 | Hudspeth | Texas | 48229 | 453 | 8 |
900457 | 900457 | 2021-01-05 | Hudspeth | Texas | 48229 | 453 | 8 |
897212 | 897212 | 2021-01-04 | Hudspeth | Texas | 48229 | 451 | 8 |
893966 | 893966 | 2021-01-03 | Hudspeth | Texas | 48229 | 451 | 8 |
890720 | 890720 | 2021-01-02 | Hudspeth | Texas | 48229 | 451 | 8 |
887473 | 887473 | 2021-01-01 | Hudspeth | Texas | 48229 | 448 | 8 |
884228 | 884228 | 2020-12-31 | Hudspeth | Texas | 48229 | 445 | 8 |
880983 | 880983 | 2020-12-30 | Hudspeth | Texas | 48229 | 437 | 8 |
877738 | 877738 | 2020-12-29 | Hudspeth | Texas | 48229 | 437 | 8 |
874493 | 874493 | 2020-12-28 | Hudspeth | Texas | 48229 | 435 | 8 |
871248 | 871248 | 2020-12-27 | Hudspeth | Texas | 48229 | 435 | 8 |
868003 | 868003 | 2020-12-26 | Hudspeth | Texas | 48229 | 431 | 8 |
864758 | 864758 | 2020-12-25 | Hudspeth | Texas | 48229 | 425 | 8 |
861513 | 861513 | 2020-12-24 | Hudspeth | Texas | 48229 | 410 | 8 |
858268 | 858268 | 2020-12-23 | Hudspeth | Texas | 48229 | 404 | 8 |
855023 | 855023 | 2020-12-22 | Hudspeth | Texas | 48229 | 414 | 8 |
851778 | 851778 | 2020-12-21 | Hudspeth | Texas | 48229 | 405 | 8 |
848533 | 848533 | 2020-12-20 | Hudspeth | Texas | 48229 | 388 | 7 |
845288 | 845288 | 2020-12-19 | Hudspeth | Texas | 48229 | 383 | 7 |
842042 | 842042 | 2020-12-18 | Hudspeth | Texas | 48229 | 374 | 6 |
838797 | 838797 | 2020-12-17 | Hudspeth | Texas | 48229 | 363 | 5 |
835551 | 835551 | 2020-12-16 | Hudspeth | Texas | 48229 | 351 | 5 |
832305 | 832305 | 2020-12-15 | Hudspeth | Texas | 48229 | 343 | 5 |
829058 | 829058 | 2020-12-14 | Hudspeth | Texas | 48229 | 322 | 5 |
825812 | 825812 | 2020-12-13 | Hudspeth | Texas | 48229 | 339 | 5 |
822565 | 822565 | 2020-12-12 | Hudspeth | Texas | 48229 | 313 | 5 |
819319 | 819319 | 2020-12-11 | Hudspeth | Texas | 48229 | 310 | 5 |
816073 | 816073 | 2020-12-10 | Hudspeth | Texas | 48229 | 291 | 4 |
812827 | 812827 | 2020-12-09 | Hudspeth | Texas | 48229 | 283 | 4 |
809583 | 809583 | 2020-12-08 | Hudspeth | Texas | 48229 | 281 | 4 |
806338 | 806338 | 2020-12-07 | Hudspeth | Texas | 48229 | 280 | 4 |
803093 | 803093 | 2020-12-06 | Hudspeth | Texas | 48229 | 275 | 4 |
799848 | 799848 | 2020-12-05 | Hudspeth | Texas | 48229 | 269 | 4 |
796603 | 796603 | 2020-12-04 | Hudspeth | Texas | 48229 | 267 | 4 |
793358 | 793358 | 2020-12-03 | Hudspeth | Texas | 48229 | 270 | 4 |
790113 | 790113 | 2020-12-02 | Hudspeth | Texas | 48229 | 270 | 4 |
786868 | 786868 | 2020-12-01 | Hudspeth | Texas | 48229 | 256 | 4 |
783624 | 783624 | 2020-11-30 | Hudspeth | Texas | 48229 | 256 | 4 |
780379 | 780379 | 2020-11-29 | Hudspeth | Texas | 48229 | 256 | 4 |
777133 | 777133 | 2020-11-28 | Hudspeth | Texas | 48229 | 226 | 4 |
773888 | 773888 | 2020-11-27 | Hudspeth | Texas | 48229 | 219 | 4 |
770643 | 770643 | 2020-11-26 | Hudspeth | Texas | 48229 | 179 | 4 |
767397 | 767397 | 2020-11-25 | Hudspeth | Texas | 48229 | 179 | 4 |
764152 | 764152 | 2020-11-24 | Hudspeth | Texas | 48229 | 158 | 4 |
760907 | 760907 | 2020-11-23 | Hudspeth | Texas | 48229 | 154 | 3 |
757662 | 757662 | 2020-11-22 | Hudspeth | Texas | 48229 | 142 | 3 |
754415 | 754415 | 2020-11-21 | Hudspeth | Texas | 48229 | 140 | 3 |
751169 | 751169 | 2020-11-20 | Hudspeth | Texas | 48229 | 164 | 3 |
747923 | 747923 | 2020-11-19 | Hudspeth | Texas | 48229 | 159 | 3 |
744677 | 744677 | 2020-11-18 | Hudspeth | Texas | 48229 | 155 | 3 |
741430 | 741430 | 2020-11-17 | Hudspeth | Texas | 48229 | 145 | 3 |
738184 | 738184 | 2020-11-16 | Hudspeth | Texas | 48229 | 133 | 3 |
734940 | 734940 | 2020-11-15 | Hudspeth | Texas | 48229 | 133 | 3 |
731694 | 731694 | 2020-11-14 | Hudspeth | Texas | 48229 | 133 | 3 |
728449 | 728449 | 2020-11-13 | Hudspeth | Texas | 48229 | 131 | 3 |
725206 | 725206 | 2020-11-12 | Hudspeth | Texas | 48229 | 131 | 3 |
721963 | 721963 | 2020-11-11 | Hudspeth | Texas | 48229 | 125 | 3 |
718720 | 718720 | 2020-11-10 | Hudspeth | Texas | 48229 | 122 | 3 |
715477 | 715477 | 2020-11-09 | Hudspeth | Texas | 48229 | 122 | 3 |
712233 | 712233 | 2020-11-08 | Hudspeth | Texas | 48229 | 122 | 3 |
708989 | 708989 | 2020-11-07 | Hudspeth | Texas | 48229 | 122 | 3 |
705745 | 705745 | 2020-11-06 | Hudspeth | Texas | 48229 | 120 | 3 |
702502 | 702502 | 2020-11-05 | Hudspeth | Texas | 48229 | 119 | 3 |
699259 | 699259 | 2020-11-04 | Hudspeth | Texas | 48229 | 119 | 3 |
696015 | 696015 | 2020-11-03 | Hudspeth | Texas | 48229 | 116 | 3 |
692773 | 692773 | 2020-11-02 | Hudspeth | Texas | 48229 | 114 | 3 |
689529 | 689529 | 2020-11-01 | Hudspeth | Texas | 48229 | 114 | 3 |
686284 | 686284 | 2020-10-31 | Hudspeth | Texas | 48229 | 114 | 3 |
683041 | 683041 | 2020-10-30 | Hudspeth | Texas | 48229 | 113 | 3 |
679798 | 679798 | 2020-10-29 | Hudspeth | Texas | 48229 | 106 | 3 |
676555 | 676555 | 2020-10-28 | Hudspeth | Texas | 48229 | 106 | 3 |
673312 | 673312 | 2020-10-27 | Hudspeth | Texas | 48229 | 101 | 3 |
670070 | 670070 | 2020-10-26 | Hudspeth | Texas | 48229 | 94 | 3 |
666827 | 666827 | 2020-10-25 | Hudspeth | Texas | 48229 | 94 | 3 |
663582 | 663582 | 2020-10-24 | Hudspeth | Texas | 48229 | 94 | 3 |
660338 | 660338 | 2020-10-23 | Hudspeth | Texas | 48229 | 75 | 3 |
657094 | 657094 | 2020-10-22 | Hudspeth | Texas | 48229 | 75 | 3 |
653849 | 653849 | 2020-10-21 | Hudspeth | Texas | 48229 | 75 | 3 |
650604 | 650604 | 2020-10-20 | Hudspeth | Texas | 48229 | 75 | 3 |
647360 | 647360 | 2020-10-19 | Hudspeth | Texas | 48229 | 72 | 3 |
644114 | 644114 | 2020-10-18 | Hudspeth | Texas | 48229 | 72 | 3 |
640866 | 640866 | 2020-10-17 | Hudspeth | Texas | 48229 | 72 | 3 |
637619 | 637619 | 2020-10-16 | Hudspeth | Texas | 48229 | 70 | 3 |
634374 | 634374 | 2020-10-15 | Hudspeth | Texas | 48229 | 68 | 3 |
631129 | 631129 | 2020-10-14 | Hudspeth | Texas | 48229 | 67 | 3 |
627885 | 627885 | 2020-10-13 | Hudspeth | Texas | 48229 | 67 | 3 |
624643 | 624643 | 2020-10-12 | Hudspeth | Texas | 48229 | 65 | 3 |
621400 | 621400 | 2020-10-11 | Hudspeth | Texas | 48229 | 65 | 3 |
618157 | 618157 | 2020-10-10 | Hudspeth | Texas | 48229 | 65 | 3 |
614915 | 614915 | 2020-10-09 | Hudspeth | Texas | 48229 | 65 | 3 |
611674 | 611674 | 2020-10-08 | Hudspeth | Texas | 48229 | 64 | 3 |
608432 | 608432 | 2020-10-07 | Hudspeth | Texas | 48229 | 64 | 3 |
605189 | 605189 | 2020-10-06 | Hudspeth | Texas | 48229 | 62 | 3 |
601947 | 601947 | 2020-10-05 | Hudspeth | Texas | 48229 | 62 | 3 |
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);