ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Travis" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280393 | 1280393 | 2021-05-02 | Travis | Texas | 48453 | 82402 | 997 |
1277146 | 1277146 | 2021-05-01 | Travis | Texas | 48453 | 82339 | 997 |
1273899 | 1273899 | 2021-04-30 | Travis | Texas | 48453 | 82257 | 996 |
1270652 | 1270652 | 2021-04-29 | Travis | Texas | 48453 | 82152 | 991 |
1267405 | 1267405 | 2021-04-28 | Travis | Texas | 48453 | 82057 | 989 |
1264158 | 1264158 | 2021-04-27 | Travis | Texas | 48453 | 81906 | 986 |
1260911 | 1260911 | 2021-04-26 | Travis | Texas | 48453 | 81811 | 986 |
1257664 | 1257664 | 2021-04-25 | Travis | Texas | 48453 | 81739 | 986 |
1254417 | 1254417 | 2021-04-24 | Travis | Texas | 48453 | 81686 | 986 |
1251170 | 1251170 | 2021-04-23 | Travis | Texas | 48453 | 81686 | 983 |
1247923 | 1247923 | 2021-04-22 | Travis | Texas | 48453 | 81600 | 980 |
1244676 | 1244676 | 2021-04-21 | Travis | Texas | 48453 | 81551 | 980 |
1241429 | 1241429 | 2021-04-20 | Travis | Texas | 48453 | 81470 | 979 |
1238182 | 1238182 | 2021-04-19 | Travis | Texas | 48453 | 81342 | 976 |
1234935 | 1234935 | 2021-04-18 | Travis | Texas | 48453 | 81199 | 976 |
1231687 | 1231687 | 2021-04-17 | Travis | Texas | 48453 | 81138 | 975 |
1228439 | 1228439 | 2021-04-16 | Travis | Texas | 48453 | 81002 | 975 |
1225191 | 1225191 | 2021-04-15 | Travis | Texas | 48453 | 80909 | 973 |
1221944 | 1221944 | 2021-04-14 | Travis | Texas | 48453 | 80799 | 970 |
1218696 | 1218696 | 2021-04-13 | Travis | Texas | 48453 | 80642 | 968 |
1215448 | 1215448 | 2021-04-12 | Travis | Texas | 48453 | 80533 | 967 |
1212201 | 1212201 | 2021-04-11 | Travis | Texas | 48453 | 80446 | 967 |
1208952 | 1208952 | 2021-04-10 | Travis | Texas | 48453 | 80272 | 964 |
1205704 | 1205704 | 2021-04-09 | Travis | Texas | 48453 | 80132 | 961 |
1202456 | 1202456 | 2021-04-08 | Travis | Texas | 48453 | 80031 | 960 |
1199207 | 1199207 | 2021-04-07 | Travis | Texas | 48453 | 79922 | 959 |
1195958 | 1195958 | 2021-04-06 | Travis | Texas | 48453 | 79787 | 957 |
1192710 | 1192710 | 2021-04-05 | Travis | Texas | 48453 | 79645 | 957 |
1189461 | 1189461 | 2021-04-04 | Travis | Texas | 48453 | 79493 | 957 |
1186214 | 1186214 | 2021-04-03 | Travis | Texas | 48453 | 79493 | 957 |
1182967 | 1182967 | 2021-04-02 | Travis | Texas | 48453 | 79422 | 956 |
1179720 | 1179720 | 2021-04-01 | Travis | Texas | 48453 | 79324 | 955 |
1176473 | 1176473 | 2021-03-31 | Travis | Texas | 48453 | 79217 | 954 |
1173226 | 1173226 | 2021-03-30 | Travis | Texas | 48453 | 79085 | 952 |
1169979 | 1169979 | 2021-03-29 | Travis | Texas | 48453 | 78994 | 948 |
1166731 | 1166731 | 2021-03-28 | Travis | Texas | 48453 | 78907 | 945 |
1163483 | 1163483 | 2021-03-27 | Travis | Texas | 48453 | 78828 | 945 |
1160234 | 1160234 | 2021-03-26 | Travis | Texas | 48453 | 78661 | 943 |
1156987 | 1156987 | 2021-03-25 | Travis | Texas | 48453 | 78602 | 939 |
1153740 | 1153740 | 2021-03-24 | Travis | Texas | 48453 | 78496 | 934 |
1150493 | 1150493 | 2021-03-23 | Travis | Texas | 48453 | 78372 | 933 |
1147246 | 1147246 | 2021-03-22 | Travis | Texas | 48453 | 78308 | 933 |
1143999 | 1143999 | 2021-03-21 | Travis | Texas | 48453 | 78193 | 933 |
1140752 | 1140752 | 2021-03-20 | Travis | Texas | 48453 | 78108 | 931 |
1137506 | 1137506 | 2021-03-19 | Travis | Texas | 48453 | 78011 | 929 |
1134260 | 1134260 | 2021-03-18 | Travis | Texas | 48453 | 77916 | 926 |
1131012 | 1131012 | 2021-03-17 | Travis | Texas | 48453 | 77831 | 920 |
1127765 | 1127765 | 2021-03-16 | Travis | Texas | 48453 | 77775 | 914 |
1124519 | 1124519 | 2021-03-15 | Travis | Texas | 48453 | 77669 | 909 |
1121273 | 1121273 | 2021-03-14 | Travis | Texas | 48453 | 77485 | 909 |
1118026 | 1118026 | 2021-03-13 | Travis | Texas | 48453 | 77408 | 908 |
1114779 | 1114779 | 2021-03-12 | Travis | Texas | 48453 | 77329 | 904 |
1111533 | 1111533 | 2021-03-11 | Travis | Texas | 48453 | 77231 | 902 |
1108287 | 1108287 | 2021-03-10 | Travis | Texas | 48453 | 77082 | 892 |
1105041 | 1105041 | 2021-03-09 | Travis | Texas | 48453 | 76855 | 888 |
1101795 | 1101795 | 2021-03-08 | Travis | Texas | 48453 | 76742 | 883 |
1098549 | 1098549 | 2021-03-07 | Travis | Texas | 48453 | 76638 | 882 |
1095301 | 1095301 | 2021-03-06 | Travis | Texas | 48453 | 76507 | 881 |
1092055 | 1092055 | 2021-03-05 | Travis | Texas | 48453 | 76447 | 876 |
1088809 | 1088809 | 2021-03-04 | Travis | Texas | 48453 | 76365 | 868 |
1085564 | 1085564 | 2021-03-03 | Travis | Texas | 48453 | 76274 | 863 |
1082318 | 1082318 | 2021-03-02 | Travis | Texas | 48453 | 76088 | 855 |
1079072 | 1079072 | 2021-03-01 | Travis | Texas | 48453 | 75901 | 852 |
1075827 | 1075827 | 2021-02-28 | Travis | Texas | 48453 | 75636 | 852 |
1072581 | 1072581 | 2021-02-27 | Travis | Texas | 48453 | 75617 | 851 |
1069335 | 1069335 | 2021-02-26 | Travis | Texas | 48453 | 75362 | 846 |
1066090 | 1066090 | 2021-02-25 | Travis | Texas | 48453 | 75047 | 842 |
1062845 | 1062845 | 2021-02-24 | Travis | Texas | 48453 | 74835 | 828 |
1059600 | 1059600 | 2021-02-23 | Travis | Texas | 48453 | 74598 | 825 |
1056354 | 1056354 | 2021-02-22 | Travis | Texas | 48453 | 74206 | 822 |
1053108 | 1053108 | 2021-02-21 | Travis | Texas | 48453 | 73809 | 819 |
1049861 | 1049861 | 2021-02-20 | Travis | Texas | 48453 | 73538 | 813 |
1046614 | 1046614 | 2021-02-19 | Travis | Texas | 48453 | 73538 | 809 |
1043369 | 1043369 | 2021-02-18 | Travis | Texas | 48453 | 73538 | 807 |
1040124 | 1040124 | 2021-02-17 | Travis | Texas | 48453 | 73538 | 805 |
1036879 | 1036879 | 2021-02-16 | Travis | Texas | 48453 | 73538 | 805 |
1033634 | 1033634 | 2021-02-15 | Travis | Texas | 48453 | 73538 | 805 |
1030388 | 1030388 | 2021-02-14 | Travis | Texas | 48453 | 73538 | 804 |
1027141 | 1027141 | 2021-02-13 | Travis | Texas | 48453 | 73538 | 799 |
1023896 | 1023896 | 2021-02-12 | Travis | Texas | 48453 | 73538 | 796 |
1020651 | 1020651 | 2021-02-11 | Travis | Texas | 48453 | 73259 | 786 |
1017406 | 1017406 | 2021-02-10 | Travis | Texas | 48453 | 72972 | 777 |
1014161 | 1014161 | 2021-02-09 | Travis | Texas | 48453 | 72625 | 774 |
1010916 | 1010916 | 2021-02-08 | Travis | Texas | 48453 | 72279 | 772 |
1007670 | 1007670 | 2021-02-07 | Travis | Texas | 48453 | 71831 | 771 |
1004424 | 1004424 | 2021-02-06 | Travis | Texas | 48453 | 71623 | 766 |
1001178 | 1001178 | 2021-02-05 | Travis | Texas | 48453 | 71426 | 763 |
997932 | 997932 | 2021-02-04 | Travis | Texas | 48453 | 71164 | 757 |
994686 | 994686 | 2021-02-03 | Travis | Texas | 48453 | 70631 | 748 |
991440 | 991440 | 2021-02-02 | Travis | Texas | 48453 | 70089 | 737 |
988194 | 988194 | 2021-02-01 | Travis | Texas | 48453 | 69408 | 730 |
984947 | 984947 | 2021-01-31 | Travis | Texas | 48453 | 68731 | 727 |
981700 | 981700 | 2021-01-30 | Travis | Texas | 48453 | 68290 | 722 |
978454 | 978454 | 2021-01-29 | Travis | Texas | 48453 | 68020 | 716 |
975209 | 975209 | 2021-01-28 | Travis | Texas | 48453 | 67566 | 704 |
971964 | 971964 | 2021-01-27 | Travis | Texas | 48453 | 66859 | 696 |
968719 | 968719 | 2021-01-26 | Travis | Texas | 48453 | 66209 | 685 |
965475 | 965475 | 2021-01-25 | Travis | Texas | 48453 | 65507 | 682 |
962230 | 962230 | 2021-01-24 | Travis | Texas | 48453 | 64963 | 681 |
958985 | 958985 | 2021-01-23 | Travis | Texas | 48453 | 64658 | 676 |
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);