ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 48249 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923183 | 923183 | 2021-01-12 | Jim Wells | Texas | 48249 | 3204 | 68 |
919938 | 919938 | 2021-01-11 | Jim Wells | Texas | 48249 | 3157 | 66 |
916693 | 916693 | 2021-01-10 | Jim Wells | Texas | 48249 | 3157 | 66 |
913448 | 913448 | 2021-01-09 | Jim Wells | Texas | 48249 | 3132 | 66 |
910203 | 910203 | 2021-01-08 | Jim Wells | Texas | 48249 | 3076 | 66 |
906958 | 906958 | 2021-01-07 | Jim Wells | Texas | 48249 | 3036 | 66 |
903712 | 903712 | 2021-01-06 | Jim Wells | Texas | 48249 | 3012 | 66 |
900467 | 900467 | 2021-01-05 | Jim Wells | Texas | 48249 | 2974 | 65 |
897222 | 897222 | 2021-01-04 | Jim Wells | Texas | 48249 | 2891 | 65 |
893976 | 893976 | 2021-01-03 | Jim Wells | Texas | 48249 | 2891 | 65 |
890730 | 890730 | 2021-01-02 | Jim Wells | Texas | 48249 | 2850 | 65 |
887483 | 887483 | 2021-01-01 | Jim Wells | Texas | 48249 | 2850 | 65 |
884238 | 884238 | 2020-12-31 | Jim Wells | Texas | 48249 | 2770 | 65 |
880993 | 880993 | 2020-12-30 | Jim Wells | Texas | 48249 | 2751 | 63 |
877748 | 877748 | 2020-12-29 | Jim Wells | Texas | 48249 | 2692 | 63 |
874503 | 874503 | 2020-12-28 | Jim Wells | Texas | 48249 | 2650 | 63 |
871258 | 871258 | 2020-12-27 | Jim Wells | Texas | 48249 | 2650 | 63 |
868013 | 868013 | 2020-12-26 | Jim Wells | Texas | 48249 | 2609 | 63 |
864768 | 864768 | 2020-12-25 | Jim Wells | Texas | 48249 | 2609 | 63 |
861523 | 861523 | 2020-12-24 | Jim Wells | Texas | 48249 | 2590 | 63 |
858278 | 858278 | 2020-12-23 | Jim Wells | Texas | 48249 | 2554 | 63 |
855033 | 855033 | 2020-12-22 | Jim Wells | Texas | 48249 | 2526 | 62 |
851788 | 851788 | 2020-12-21 | Jim Wells | Texas | 48249 | 2490 | 61 |
848543 | 848543 | 2020-12-20 | Jim Wells | Texas | 48249 | 2490 | 61 |
845298 | 845298 | 2020-12-19 | Jim Wells | Texas | 48249 | 2466 | 61 |
842052 | 842052 | 2020-12-18 | Jim Wells | Texas | 48249 | 2449 | 61 |
838807 | 838807 | 2020-12-17 | Jim Wells | Texas | 48249 | 2431 | 60 |
835561 | 835561 | 2020-12-16 | Jim Wells | Texas | 48249 | 2417 | 60 |
832315 | 832315 | 2020-12-15 | Jim Wells | Texas | 48249 | 2382 | 60 |
829068 | 829068 | 2020-12-14 | Jim Wells | Texas | 48249 | 2358 | 58 |
825822 | 825822 | 2020-12-13 | Jim Wells | Texas | 48249 | 2358 | 58 |
822575 | 822575 | 2020-12-12 | Jim Wells | Texas | 48249 | 2341 | 58 |
819329 | 819329 | 2020-12-11 | Jim Wells | Texas | 48249 | 2319 | 58 |
816083 | 816083 | 2020-12-10 | Jim Wells | Texas | 48249 | 2180 | 58 |
812837 | 812837 | 2020-12-09 | Jim Wells | Texas | 48249 | 2165 | 58 |
809593 | 809593 | 2020-12-08 | Jim Wells | Texas | 48249 | 2155 | 57 |
806348 | 806348 | 2020-12-07 | Jim Wells | Texas | 48249 | 2140 | 57 |
803103 | 803103 | 2020-12-06 | Jim Wells | Texas | 48249 | 2140 | 56 |
799858 | 799858 | 2020-12-05 | Jim Wells | Texas | 48249 | 2136 | 56 |
796613 | 796613 | 2020-12-04 | Jim Wells | Texas | 48249 | 2118 | 56 |
793368 | 793368 | 2020-12-03 | Jim Wells | Texas | 48249 | 2113 | 56 |
790123 | 790123 | 2020-12-02 | Jim Wells | Texas | 48249 | 2092 | 56 |
786878 | 786878 | 2020-12-01 | Jim Wells | Texas | 48249 | 2077 | 56 |
783634 | 783634 | 2020-11-30 | Jim Wells | Texas | 48249 | 2045 | 56 |
780389 | 780389 | 2020-11-29 | Jim Wells | Texas | 48249 | 2045 | 56 |
777143 | 777143 | 2020-11-28 | Jim Wells | Texas | 48249 | 2013 | 56 |
773898 | 773898 | 2020-11-27 | Jim Wells | Texas | 48249 | 2009 | 56 |
770653 | 770653 | 2020-11-26 | Jim Wells | Texas | 48249 | 2009 | 56 |
767407 | 767407 | 2020-11-25 | Jim Wells | Texas | 48249 | 1994 | 56 |
764162 | 764162 | 2020-11-24 | Jim Wells | Texas | 48249 | 1944 | 56 |
760917 | 760917 | 2020-11-23 | Jim Wells | Texas | 48249 | 1944 | 56 |
757672 | 757672 | 2020-11-22 | Jim Wells | Texas | 48249 | 1944 | 56 |
754425 | 754425 | 2020-11-21 | Jim Wells | Texas | 48249 | 1910 | 56 |
751179 | 751179 | 2020-11-20 | Jim Wells | Texas | 48249 | 1894 | 55 |
747933 | 747933 | 2020-11-19 | Jim Wells | Texas | 48249 | 1878 | 54 |
744687 | 744687 | 2020-11-18 | Jim Wells | Texas | 48249 | 1869 | 53 |
741440 | 741440 | 2020-11-17 | Jim Wells | Texas | 48249 | 1863 | 53 |
738194 | 738194 | 2020-11-16 | Jim Wells | Texas | 48249 | 1858 | 53 |
734950 | 734950 | 2020-11-15 | Jim Wells | Texas | 48249 | 1858 | 53 |
731704 | 731704 | 2020-11-14 | Jim Wells | Texas | 48249 | 1843 | 53 |
728459 | 728459 | 2020-11-13 | Jim Wells | Texas | 48249 | 1834 | 53 |
725216 | 725216 | 2020-11-12 | Jim Wells | Texas | 48249 | 1832 | 53 |
721973 | 721973 | 2020-11-11 | Jim Wells | Texas | 48249 | 1820 | 53 |
718730 | 718730 | 2020-11-10 | Jim Wells | Texas | 48249 | 1806 | 53 |
715487 | 715487 | 2020-11-09 | Jim Wells | Texas | 48249 | 1792 | 53 |
712243 | 712243 | 2020-11-08 | Jim Wells | Texas | 48249 | 1792 | 53 |
708999 | 708999 | 2020-11-07 | Jim Wells | Texas | 48249 | 1787 | 53 |
705755 | 705755 | 2020-11-06 | Jim Wells | Texas | 48249 | 1782 | 53 |
702512 | 702512 | 2020-11-05 | Jim Wells | Texas | 48249 | 1777 | 52 |
699269 | 699269 | 2020-11-04 | Jim Wells | Texas | 48249 | 1757 | 52 |
696025 | 696025 | 2020-11-03 | Jim Wells | Texas | 48249 | 1748 | 52 |
692783 | 692783 | 2020-11-02 | Jim Wells | Texas | 48249 | 1726 | 52 |
689539 | 689539 | 2020-11-01 | Jim Wells | Texas | 48249 | 1726 | 52 |
686294 | 686294 | 2020-10-31 | Jim Wells | Texas | 48249 | 1709 | 52 |
683051 | 683051 | 2020-10-30 | Jim Wells | Texas | 48249 | 1679 | 52 |
679808 | 679808 | 2020-10-29 | Jim Wells | Texas | 48249 | 1637 | 52 |
676565 | 676565 | 2020-10-28 | Jim Wells | Texas | 48249 | 1620 | 52 |
673322 | 673322 | 2020-10-27 | Jim Wells | Texas | 48249 | 1600 | 52 |
670080 | 670080 | 2020-10-26 | Jim Wells | Texas | 48249 | 1590 | 52 |
666837 | 666837 | 2020-10-25 | Jim Wells | Texas | 48249 | 1590 | 52 |
663592 | 663592 | 2020-10-24 | Jim Wells | Texas | 48249 | 1566 | 52 |
660348 | 660348 | 2020-10-23 | Jim Wells | Texas | 48249 | 1534 | 52 |
657104 | 657104 | 2020-10-22 | Jim Wells | Texas | 48249 | 1533 | 51 |
653859 | 653859 | 2020-10-21 | Jim Wells | Texas | 48249 | 1533 | 51 |
650614 | 650614 | 2020-10-20 | Jim Wells | Texas | 48249 | 1533 | 47 |
647370 | 647370 | 2020-10-19 | Jim Wells | Texas | 48249 | 1525 | 46 |
644124 | 644124 | 2020-10-18 | Jim Wells | Texas | 48249 | 1525 | 46 |
640876 | 640876 | 2020-10-17 | Jim Wells | Texas | 48249 | 1524 | 46 |
637629 | 637629 | 2020-10-16 | Jim Wells | Texas | 48249 | 1563 | 46 |
634384 | 634384 | 2020-10-15 | Jim Wells | Texas | 48249 | 1563 | 43 |
631139 | 631139 | 2020-10-14 | Jim Wells | Texas | 48249 | 1560 | 41 |
627895 | 627895 | 2020-10-13 | Jim Wells | Texas | 48249 | 1559 | 40 |
624653 | 624653 | 2020-10-12 | Jim Wells | Texas | 48249 | 1559 | 40 |
621410 | 621410 | 2020-10-11 | Jim Wells | Texas | 48249 | 1559 | 40 |
618167 | 618167 | 2020-10-10 | Jim Wells | Texas | 48249 | 1554 | 40 |
614925 | 614925 | 2020-10-09 | Jim Wells | Texas | 48249 | 1548 | 40 |
611684 | 611684 | 2020-10-08 | Jim Wells | Texas | 48249 | 1541 | 40 |
608442 | 608442 | 2020-10-07 | Jim Wells | Texas | 48249 | 1541 | 40 |
605199 | 605199 | 2020-10-06 | Jim Wells | Texas | 48249 | 1539 | 39 |
601957 | 601957 | 2020-10-05 | Jim Wells | Texas | 48249 | 1535 | 39 |
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);