ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Polk" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1043329 | 1043329 | 2021-02-18 | Polk | Texas | 48373 | 2857 | 87 |
1040084 | 1040084 | 2021-02-17 | Polk | Texas | 48373 | 2857 | 86 |
1036839 | 1036839 | 2021-02-16 | Polk | Texas | 48373 | 2857 | 86 |
1033594 | 1033594 | 2021-02-15 | Polk | Texas | 48373 | 2857 | 86 |
1030348 | 1030348 | 2021-02-14 | Polk | Texas | 48373 | 2857 | 86 |
1027101 | 1027101 | 2021-02-13 | Polk | Texas | 48373 | 2857 | 85 |
1023856 | 1023856 | 2021-02-12 | Polk | Texas | 48373 | 2857 | 84 |
1020611 | 1020611 | 2021-02-11 | Polk | Texas | 48373 | 2857 | 84 |
1017366 | 1017366 | 2021-02-10 | Polk | Texas | 48373 | 2857 | 84 |
1014121 | 1014121 | 2021-02-09 | Polk | Texas | 48373 | 2813 | 84 |
1010876 | 1010876 | 2021-02-08 | Polk | Texas | 48373 | 2813 | 84 |
1007630 | 1007630 | 2021-02-07 | Polk | Texas | 48373 | 2813 | 84 |
1004384 | 1004384 | 2021-02-06 | Polk | Texas | 48373 | 2813 | 83 |
1001138 | 1001138 | 2021-02-05 | Polk | Texas | 48373 | 2813 | 82 |
997892 | 997892 | 2021-02-04 | Polk | Texas | 48373 | 2813 | 82 |
994646 | 994646 | 2021-02-03 | Polk | Texas | 48373 | 2741 | 82 |
991400 | 991400 | 2021-02-02 | Polk | Texas | 48373 | 2741 | 79 |
988154 | 988154 | 2021-02-01 | Polk | Texas | 48373 | 2741 | 78 |
984907 | 984907 | 2021-01-31 | Polk | Texas | 48373 | 2686 | 78 |
981660 | 981660 | 2021-01-30 | Polk | Texas | 48373 | 2686 | 78 |
978414 | 978414 | 2021-01-29 | Polk | Texas | 48373 | 2686 | 76 |
975169 | 975169 | 2021-01-28 | Polk | Texas | 48373 | 2686 | 76 |
971924 | 971924 | 2021-01-27 | Polk | Texas | 48373 | 2686 | 76 |
968679 | 968679 | 2021-01-26 | Polk | Texas | 48373 | 2548 | 76 |
965435 | 965435 | 2021-01-25 | Polk | Texas | 48373 | 2548 | 75 |
962190 | 962190 | 2021-01-24 | Polk | Texas | 48373 | 2548 | 75 |
958945 | 958945 | 2021-01-23 | Polk | Texas | 48373 | 2548 | 74 |
955699 | 955699 | 2021-01-22 | Polk | Texas | 48373 | 2548 | 73 |
952454 | 952454 | 2021-01-21 | Polk | Texas | 48373 | 2548 | 71 |
949209 | 949209 | 2021-01-20 | Polk | Texas | 48373 | 2492 | 71 |
945963 | 945963 | 2021-01-19 | Polk | Texas | 48373 | 2492 | 70 |
942716 | 942716 | 2021-01-18 | Polk | Texas | 48373 | 2492 | 69 |
939471 | 939471 | 2021-01-17 | Polk | Texas | 48373 | 2450 | 69 |
936226 | 936226 | 2021-01-16 | Polk | Texas | 48373 | 2450 | 67 |
932981 | 932981 | 2021-01-15 | Polk | Texas | 48373 | 2450 | 65 |
929736 | 929736 | 2021-01-14 | Polk | Texas | 48373 | 2450 | 64 |
926491 | 926491 | 2021-01-13 | Polk | Texas | 48373 | 2450 | 63 |
923245 | 923245 | 2021-01-12 | Polk | Texas | 48373 | 2352 | 63 |
920000 | 920000 | 2021-01-11 | Polk | Texas | 48373 | 2352 | 61 |
916755 | 916755 | 2021-01-10 | Polk | Texas | 48373 | 2352 | 61 |
913510 | 913510 | 2021-01-09 | Polk | Texas | 48373 | 2352 | 61 |
910265 | 910265 | 2021-01-08 | Polk | Texas | 48373 | 2352 | 61 |
907020 | 907020 | 2021-01-07 | Polk | Texas | 48373 | 2206 | 61 |
903774 | 903774 | 2021-01-06 | Polk | Texas | 48373 | 2206 | 61 |
900529 | 900529 | 2021-01-05 | Polk | Texas | 48373 | 2206 | 59 |
897284 | 897284 | 2021-01-04 | Polk | Texas | 48373 | 2206 | 59 |
894038 | 894038 | 2021-01-03 | Polk | Texas | 48373 | 2180 | 59 |
890792 | 890792 | 2021-01-02 | Polk | Texas | 48373 | 2180 | 59 |
887545 | 887545 | 2021-01-01 | Polk | Texas | 48373 | 2180 | 59 |
884300 | 884300 | 2020-12-31 | Polk | Texas | 48373 | 2180 | 58 |
881055 | 881055 | 2020-12-30 | Polk | Texas | 48373 | 2052 | 58 |
877810 | 877810 | 2020-12-29 | Polk | Texas | 48373 | 2052 | 56 |
874565 | 874565 | 2020-12-28 | Polk | Texas | 48373 | 2049 | 56 |
871320 | 871320 | 2020-12-27 | Polk | Texas | 48373 | 2049 | 55 |
868075 | 868075 | 2020-12-26 | Polk | Texas | 48373 | 2049 | 55 |
864830 | 864830 | 2020-12-25 | Polk | Texas | 48373 | 2049 | 55 |
861585 | 861585 | 2020-12-24 | Polk | Texas | 48373 | 2049 | 55 |
858340 | 858340 | 2020-12-23 | Polk | Texas | 48373 | 2028 | 52 |
855095 | 855095 | 2020-12-22 | Polk | Texas | 48373 | 2007 | 48 |
851850 | 851850 | 2020-12-21 | Polk | Texas | 48373 | 2007 | 48 |
848605 | 848605 | 2020-12-20 | Polk | Texas | 48373 | 1960 | 48 |
845360 | 845360 | 2020-12-19 | Polk | Texas | 48373 | 1960 | 48 |
842114 | 842114 | 2020-12-18 | Polk | Texas | 48373 | 1960 | 48 |
838869 | 838869 | 2020-12-17 | Polk | Texas | 48373 | 1948 | 48 |
835623 | 835623 | 2020-12-16 | Polk | Texas | 48373 | 1948 | 48 |
832377 | 832377 | 2020-12-15 | Polk | Texas | 48373 | 1935 | 46 |
829130 | 829130 | 2020-12-14 | Polk | Texas | 48373 | 1893 | 46 |
825884 | 825884 | 2020-12-13 | Polk | Texas | 48373 | 1875 | 46 |
822637 | 822637 | 2020-12-12 | Polk | Texas | 48373 | 1809 | 45 |
819391 | 819391 | 2020-12-11 | Polk | Texas | 48373 | 1809 | 45 |
816145 | 816145 | 2020-12-10 | Polk | Texas | 48373 | 1809 | 43 |
812899 | 812899 | 2020-12-09 | Polk | Texas | 48373 | 1809 | 43 |
809655 | 809655 | 2020-12-08 | Polk | Texas | 48373 | 1763 | 43 |
806410 | 806410 | 2020-12-07 | Polk | Texas | 48373 | 1763 | 43 |
803165 | 803165 | 2020-12-06 | Polk | Texas | 48373 | 1700 | 43 |
799920 | 799920 | 2020-12-05 | Polk | Texas | 48373 | 1700 | 42 |
796675 | 796675 | 2020-12-04 | Polk | Texas | 48373 | 1700 | 42 |
793430 | 793430 | 2020-12-03 | Polk | Texas | 48373 | 1700 | 42 |
790185 | 790185 | 2020-12-02 | Polk | Texas | 48373 | 1618 | 42 |
786940 | 786940 | 2020-12-01 | Polk | Texas | 48373 | 1592 | 42 |
783696 | 783696 | 2020-11-30 | Polk | Texas | 48373 | 1592 | 42 |
780451 | 780451 | 2020-11-29 | Polk | Texas | 48373 | 1539 | 42 |
777205 | 777205 | 2020-11-28 | Polk | Texas | 48373 | 1539 | 42 |
773960 | 773960 | 2020-11-27 | Polk | Texas | 48373 | 1539 | 42 |
770715 | 770715 | 2020-11-26 | Polk | Texas | 48373 | 1539 | 42 |
767469 | 767469 | 2020-11-25 | Polk | Texas | 48373 | 1539 | 42 |
764224 | 764224 | 2020-11-24 | Polk | Texas | 48373 | 1539 | 42 |
760979 | 760979 | 2020-11-23 | Polk | Texas | 48373 | 1537 | 42 |
757734 | 757734 | 2020-11-22 | Polk | Texas | 48373 | 1487 | 42 |
754487 | 754487 | 2020-11-21 | Polk | Texas | 48373 | 1487 | 42 |
751241 | 751241 | 2020-11-20 | Polk | Texas | 48373 | 1487 | 42 |
747995 | 747995 | 2020-11-19 | Polk | Texas | 48373 | 1487 | 42 |
744749 | 744749 | 2020-11-18 | Polk | Texas | 48373 | 1479 | 42 |
741502 | 741502 | 2020-11-17 | Polk | Texas | 48373 | 1447 | 42 |
738255 | 738255 | 2020-11-16 | Polk | Texas | 48373 | 1447 | 42 |
735011 | 735011 | 2020-11-15 | Polk | Texas | 48373 | 1416 | 42 |
731765 | 731765 | 2020-11-14 | Polk | Texas | 48373 | 1416 | 42 |
728520 | 728520 | 2020-11-13 | Polk | Texas | 48373 | 1416 | 41 |
725277 | 725277 | 2020-11-12 | Polk | Texas | 48373 | 1416 | 41 |
722034 | 722034 | 2020-11-11 | Polk | Texas | 48373 | 1416 | 40 |
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);