ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "El Paso" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923128 | 923128 | 2021-01-12 | El Paso | Texas | 48141 | 104085 | 1860 |
919883 | 919883 | 2021-01-11 | El Paso | Texas | 48141 | 103787 | 1853 |
916638 | 916638 | 2021-01-10 | El Paso | Texas | 48141 | 103197 | 1836 |
913393 | 913393 | 2021-01-09 | El Paso | Texas | 48141 | 102889 | 1819 |
910148 | 910148 | 2021-01-08 | El Paso | Texas | 48141 | 102055 | 1778 |
906903 | 906903 | 2021-01-07 | El Paso | Texas | 48141 | 102055 | 1760 |
903657 | 903657 | 2021-01-06 | El Paso | Texas | 48141 | 100944 | 1731 |
900412 | 900412 | 2021-01-05 | El Paso | Texas | 48141 | 100421 | 1714 |
897167 | 897167 | 2021-01-04 | El Paso | Texas | 48141 | 99889 | 1708 |
893921 | 893921 | 2021-01-03 | El Paso | Texas | 48141 | 99672 | 1703 |
890675 | 890675 | 2021-01-02 | El Paso | Texas | 48141 | 99327 | 1702 |
887428 | 887428 | 2021-01-01 | El Paso | Texas | 48141 | 98906 | 1700 |
884183 | 884183 | 2020-12-31 | El Paso | Texas | 48141 | 98540 | 1666 |
880938 | 880938 | 2020-12-30 | El Paso | Texas | 48141 | 98017 | 1645 |
877693 | 877693 | 2020-12-29 | El Paso | Texas | 48141 | 97710 | 1622 |
874448 | 874448 | 2020-12-28 | El Paso | Texas | 48141 | 97409 | 1616 |
871203 | 871203 | 2020-12-27 | El Paso | Texas | 48141 | 97178 | 1611 |
867958 | 867958 | 2020-12-26 | El Paso | Texas | 48141 | 97053 | 1610 |
864713 | 864713 | 2020-12-25 | El Paso | Texas | 48141 | 96722 | 1609 |
861468 | 861468 | 2020-12-24 | El Paso | Texas | 48141 | 96428 | 1598 |
858223 | 858223 | 2020-12-23 | El Paso | Texas | 48141 | 96078 | 1567 |
854978 | 854978 | 2020-12-22 | El Paso | Texas | 48141 | 95758 | 1547 |
851733 | 851733 | 2020-12-21 | El Paso | Texas | 48141 | 95544 | 1530 |
848488 | 848488 | 2020-12-20 | El Paso | Texas | 48141 | 95177 | 1513 |
845243 | 845243 | 2020-12-19 | El Paso | Texas | 48141 | 94918 | 1498 |
841997 | 841997 | 2020-12-18 | El Paso | Texas | 48141 | 94530 | 1466 |
838752 | 838752 | 2020-12-17 | El Paso | Texas | 48141 | 94240 | 1437 |
835506 | 835506 | 2020-12-16 | El Paso | Texas | 48141 | 93859 | 1418 |
832260 | 832260 | 2020-12-15 | El Paso | Texas | 48141 | 93455 | 1394 |
829013 | 829013 | 2020-12-14 | El Paso | Texas | 48141 | 93223 | 1382 |
825767 | 825767 | 2020-12-13 | El Paso | Texas | 48141 | 92810 | 1374 |
822520 | 822520 | 2020-12-12 | El Paso | Texas | 48141 | 92584 | 1350 |
819274 | 819274 | 2020-12-11 | El Paso | Texas | 48141 | 91868 | 1317 |
816028 | 816028 | 2020-12-10 | El Paso | Texas | 48141 | 91468 | 1302 |
812782 | 812782 | 2020-12-09 | El Paso | Texas | 48141 | 91150 | 1282 |
809538 | 809538 | 2020-12-08 | El Paso | Texas | 48141 | 90748 | 1249 |
806293 | 806293 | 2020-12-07 | El Paso | Texas | 48141 | 90222 | 1241 |
803048 | 803048 | 2020-12-06 | El Paso | Texas | 48141 | 89762 | 1233 |
799803 | 799803 | 2020-12-05 | El Paso | Texas | 48141 | 89540 | 1220 |
796558 | 796558 | 2020-12-04 | El Paso | Texas | 48141 | 89100 | 1186 |
793313 | 793313 | 2020-12-03 | El Paso | Texas | 48141 | 88491 | 1142 |
790068 | 790068 | 2020-12-02 | El Paso | Texas | 48141 | 87799 | 1107 |
786823 | 786823 | 2020-12-01 | El Paso | Texas | 48141 | 86752 | 1091 |
783579 | 783579 | 2020-11-30 | El Paso | Texas | 48141 | 86172 | 1078 |
780334 | 780334 | 2020-11-29 | El Paso | Texas | 48141 | 85696 | 1074 |
777088 | 777088 | 2020-11-28 | El Paso | Texas | 48141 | 85318 | 1068 |
773843 | 773843 | 2020-11-27 | El Paso | Texas | 48141 | 84683 | 1055 |
770598 | 770598 | 2020-11-26 | El Paso | Texas | 48141 | 83993 | 1048 |
767352 | 767352 | 2020-11-25 | El Paso | Texas | 48141 | 83451 | 1013 |
764107 | 764107 | 2020-11-24 | El Paso | Texas | 48141 | 82809 | 995 |
760862 | 760862 | 2020-11-23 | El Paso | Texas | 48141 | 81511 | 980 |
757617 | 757617 | 2020-11-22 | El Paso | Texas | 48141 | 81179 | 973 |
754370 | 754370 | 2020-11-21 | El Paso | Texas | 48141 | 80291 | 949 |
751124 | 751124 | 2020-11-20 | El Paso | Texas | 48141 | 79162 | 910 |
747878 | 747878 | 2020-11-19 | El Paso | Texas | 48141 | 77977 | 876 |
744632 | 744632 | 2020-11-18 | El Paso | Texas | 48141 | 77186 | 839 |
741385 | 741385 | 2020-11-17 | El Paso | Texas | 48141 | 76075 | 818 |
738139 | 738139 | 2020-11-16 | El Paso | Texas | 48141 | 74973 | 807 |
734895 | 734895 | 2020-11-15 | El Paso | Texas | 48141 | 73340 | 803 |
731649 | 731649 | 2020-11-14 | El Paso | Texas | 48141 | 72238 | 792 |
728404 | 728404 | 2020-11-13 | El Paso | Texas | 48141 | 70575 | 778 |
725161 | 725161 | 2020-11-12 | El Paso | Texas | 48141 | 68804 | 751 |
721918 | 721918 | 2020-11-11 | El Paso | Texas | 48141 | 67484 | 729 |
718675 | 718675 | 2020-11-10 | El Paso | Texas | 48141 | 65651 | 717 |
715432 | 715432 | 2020-11-09 | El Paso | Texas | 48141 | 64158 | 708 |
712188 | 712188 | 2020-11-08 | El Paso | Texas | 48141 | 63161 | 697 |
708944 | 708944 | 2020-11-07 | El Paso | Texas | 48141 | 61104 | 691 |
705700 | 705700 | 2020-11-06 | El Paso | Texas | 48141 | 59852 | 683 |
702457 | 702457 | 2020-11-05 | El Paso | Texas | 48141 | 58429 | 676 |
699214 | 699214 | 2020-11-04 | El Paso | Texas | 48141 | 56355 | 669 |
695970 | 695970 | 2020-11-03 | El Paso | Texas | 48141 | 52817 | 649 |
692728 | 692728 | 2020-11-02 | El Paso | Texas | 48141 | 51536 | 644 |
689484 | 689484 | 2020-11-01 | El Paso | Texas | 48141 | 50114 | 642 |
686239 | 686239 | 2020-10-31 | El Paso | Texas | 48141 | 48885 | 633 |
682996 | 682996 | 2020-10-30 | El Paso | Texas | 48141 | 47052 | 623 |
679753 | 679753 | 2020-10-29 | El Paso | Texas | 48141 | 45039 | 612 |
676510 | 676510 | 2020-10-28 | El Paso | Texas | 48141 | 43425 | 601 |
673267 | 673267 | 2020-10-27 | El Paso | Texas | 48141 | 42332 | 596 |
670025 | 670025 | 2020-10-26 | El Paso | Texas | 48141 | 40887 | 595 |
666782 | 666782 | 2020-10-25 | El Paso | Texas | 48141 | 39326 | 595 |
663537 | 663537 | 2020-10-24 | El Paso | Texas | 48141 | 38554 | 593 |
660293 | 660293 | 2020-10-23 | El Paso | Texas | 48141 | 37263 | 581 |
657049 | 657049 | 2020-10-22 | El Paso | Texas | 48141 | 36025 | 579 |
653804 | 653804 | 2020-10-21 | El Paso | Texas | 48141 | 34760 | 579 |
650559 | 650559 | 2020-10-20 | El Paso | Texas | 48141 | 34035 | 576 |
647315 | 647315 | 2020-10-19 | El Paso | Texas | 48141 | 33326 | 575 |
644069 | 644069 | 2020-10-18 | El Paso | Texas | 48141 | 32758 | 575 |
640821 | 640821 | 2020-10-17 | El Paso | Texas | 48141 | 32060 | 575 |
637574 | 637574 | 2020-10-16 | El Paso | Texas | 48141 | 31478 | 571 |
634329 | 634329 | 2020-10-15 | El Paso | Texas | 48141 | 30624 | 564 |
631084 | 631084 | 2020-10-14 | El Paso | Texas | 48141 | 29887 | 560 |
627840 | 627840 | 2020-10-13 | El Paso | Texas | 48141 | 29384 | 558 |
624598 | 624598 | 2020-10-12 | El Paso | Texas | 48141 | 28934 | 556 |
621355 | 621355 | 2020-10-11 | El Paso | Texas | 48141 | 28499 | 556 |
618112 | 618112 | 2020-10-10 | El Paso | Texas | 48141 | 27953 | 555 |
614870 | 614870 | 2020-10-09 | El Paso | Texas | 48141 | 27394 | 549 |
611629 | 611629 | 2020-10-08 | El Paso | Texas | 48141 | 26969 | 546 |
608387 | 608387 | 2020-10-07 | El Paso | Texas | 48141 | 26432 | 543 |
605144 | 605144 | 2020-10-06 | El Paso | Texas | 48141 | 26030 | 538 |
601902 | 601902 | 2020-10-05 | El Paso | Texas | 48141 | 25793 | 536 |
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);