ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 48077 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280205 | 1280205 | 2021-05-02 | Clay | Texas | 48077 | 1029 | 16 |
1276958 | 1276958 | 2021-05-01 | Clay | Texas | 48077 | 1029 | 16 |
1273711 | 1273711 | 2021-04-30 | Clay | Texas | 48077 | 1029 | 16 |
1270464 | 1270464 | 2021-04-29 | Clay | Texas | 48077 | 1029 | 16 |
1267217 | 1267217 | 2021-04-28 | Clay | Texas | 48077 | 1029 | 16 |
1263970 | 1263970 | 2021-04-27 | Clay | Texas | 48077 | 1026 | 16 |
1260723 | 1260723 | 2021-04-26 | Clay | Texas | 48077 | 1026 | 16 |
1257476 | 1257476 | 2021-04-25 | Clay | Texas | 48077 | 1026 | 16 |
1254229 | 1254229 | 2021-04-24 | Clay | Texas | 48077 | 1026 | 16 |
1250982 | 1250982 | 2021-04-23 | Clay | Texas | 48077 | 1026 | 16 |
1247735 | 1247735 | 2021-04-22 | Clay | Texas | 48077 | 1026 | 16 |
1244488 | 1244488 | 2021-04-21 | Clay | Texas | 48077 | 1026 | 16 |
1241241 | 1241241 | 2021-04-20 | Clay | Texas | 48077 | 1026 | 16 |
1237994 | 1237994 | 2021-04-19 | Clay | Texas | 48077 | 1026 | 16 |
1234747 | 1234747 | 2021-04-18 | Clay | Texas | 48077 | 1026 | 16 |
1231499 | 1231499 | 2021-04-17 | Clay | Texas | 48077 | 1026 | 16 |
1228251 | 1228251 | 2021-04-16 | Clay | Texas | 48077 | 1026 | 16 |
1225003 | 1225003 | 2021-04-15 | Clay | Texas | 48077 | 1024 | 16 |
1221756 | 1221756 | 2021-04-14 | Clay | Texas | 48077 | 1024 | 16 |
1218508 | 1218508 | 2021-04-13 | Clay | Texas | 48077 | 1024 | 16 |
1215260 | 1215260 | 2021-04-12 | Clay | Texas | 48077 | 1023 | 16 |
1212013 | 1212013 | 2021-04-11 | Clay | Texas | 48077 | 1023 | 16 |
1208764 | 1208764 | 2021-04-10 | Clay | Texas | 48077 | 1023 | 16 |
1205516 | 1205516 | 2021-04-09 | Clay | Texas | 48077 | 1023 | 16 |
1202268 | 1202268 | 2021-04-08 | Clay | Texas | 48077 | 1023 | 16 |
1199019 | 1199019 | 2021-04-07 | Clay | Texas | 48077 | 1023 | 16 |
1195770 | 1195770 | 2021-04-06 | Clay | Texas | 48077 | 1023 | 16 |
1192522 | 1192522 | 2021-04-05 | Clay | Texas | 48077 | 1023 | 16 |
1189273 | 1189273 | 2021-04-04 | Clay | Texas | 48077 | 1023 | 16 |
1186026 | 1186026 | 2021-04-03 | Clay | Texas | 48077 | 1023 | 16 |
1182779 | 1182779 | 2021-04-02 | Clay | Texas | 48077 | 1023 | 16 |
1179532 | 1179532 | 2021-04-01 | Clay | Texas | 48077 | 1023 | 16 |
1176285 | 1176285 | 2021-03-31 | Clay | Texas | 48077 | 1021 | 16 |
1173038 | 1173038 | 2021-03-30 | Clay | Texas | 48077 | 1019 | 16 |
1169791 | 1169791 | 2021-03-29 | Clay | Texas | 48077 | 1017 | 16 |
1166543 | 1166543 | 2021-03-28 | Clay | Texas | 48077 | 1017 | 16 |
1163295 | 1163295 | 2021-03-27 | Clay | Texas | 48077 | 1017 | 16 |
1160046 | 1160046 | 2021-03-26 | Clay | Texas | 48077 | 1018 | 16 |
1156799 | 1156799 | 2021-03-25 | Clay | Texas | 48077 | 1018 | 16 |
1153552 | 1153552 | 2021-03-24 | Clay | Texas | 48077 | 1018 | 16 |
1150305 | 1150305 | 2021-03-23 | Clay | Texas | 48077 | 1017 | 16 |
1147058 | 1147058 | 2021-03-22 | Clay | Texas | 48077 | 1014 | 16 |
1143811 | 1143811 | 2021-03-21 | Clay | Texas | 48077 | 1014 | 16 |
1140564 | 1140564 | 2021-03-20 | Clay | Texas | 48077 | 1014 | 16 |
1137318 | 1137318 | 2021-03-19 | Clay | Texas | 48077 | 1014 | 16 |
1134072 | 1134072 | 2021-03-18 | Clay | Texas | 48077 | 1014 | 16 |
1130824 | 1130824 | 2021-03-17 | Clay | Texas | 48077 | 1012 | 16 |
1127577 | 1127577 | 2021-03-16 | Clay | Texas | 48077 | 1011 | 16 |
1124331 | 1124331 | 2021-03-15 | Clay | Texas | 48077 | 1012 | 16 |
1121085 | 1121085 | 2021-03-14 | Clay | Texas | 48077 | 1012 | 16 |
1117838 | 1117838 | 2021-03-13 | Clay | Texas | 48077 | 1012 | 16 |
1114591 | 1114591 | 2021-03-12 | Clay | Texas | 48077 | 1010 | 16 |
1111345 | 1111345 | 2021-03-11 | Clay | Texas | 48077 | 1009 | 16 |
1108099 | 1108099 | 2021-03-10 | Clay | Texas | 48077 | 1006 | 16 |
1104853 | 1104853 | 2021-03-09 | Clay | Texas | 48077 | 1005 | 16 |
1101607 | 1101607 | 2021-03-08 | Clay | Texas | 48077 | 1004 | 16 |
1098361 | 1098361 | 2021-03-07 | Clay | Texas | 48077 | 1004 | 16 |
1095113 | 1095113 | 2021-03-06 | Clay | Texas | 48077 | 1004 | 16 |
1091867 | 1091867 | 2021-03-05 | Clay | Texas | 48077 | 1003 | 16 |
1088621 | 1088621 | 2021-03-04 | Clay | Texas | 48077 | 1003 | 16 |
1085376 | 1085376 | 2021-03-03 | Clay | Texas | 48077 | 1001 | 16 |
1082130 | 1082130 | 2021-03-02 | Clay | Texas | 48077 | 1000 | 16 |
1078884 | 1078884 | 2021-03-01 | Clay | Texas | 48077 | 997 | 16 |
1075639 | 1075639 | 2021-02-28 | Clay | Texas | 48077 | 997 | 16 |
1072393 | 1072393 | 2021-02-27 | Clay | Texas | 48077 | 997 | 16 |
1069147 | 1069147 | 2021-02-26 | Clay | Texas | 48077 | 991 | 16 |
1065902 | 1065902 | 2021-02-25 | Clay | Texas | 48077 | 990 | 16 |
1062657 | 1062657 | 2021-02-24 | Clay | Texas | 48077 | 990 | 16 |
1059412 | 1059412 | 2021-02-23 | Clay | Texas | 48077 | 989 | 16 |
1056166 | 1056166 | 2021-02-22 | Clay | Texas | 48077 | 988 | 16 |
1052920 | 1052920 | 2021-02-21 | Clay | Texas | 48077 | 988 | 16 |
1049673 | 1049673 | 2021-02-20 | Clay | Texas | 48077 | 988 | 16 |
1046426 | 1046426 | 2021-02-19 | Clay | Texas | 48077 | 988 | 16 |
1043181 | 1043181 | 2021-02-18 | Clay | Texas | 48077 | 988 | 16 |
1039936 | 1039936 | 2021-02-17 | Clay | Texas | 48077 | 988 | 16 |
1036691 | 1036691 | 2021-02-16 | Clay | Texas | 48077 | 983 | 16 |
1033446 | 1033446 | 2021-02-15 | Clay | Texas | 48077 | 983 | 16 |
1030200 | 1030200 | 2021-02-14 | Clay | Texas | 48077 | 983 | 16 |
1026953 | 1026953 | 2021-02-13 | Clay | Texas | 48077 | 983 | 16 |
1023708 | 1023708 | 2021-02-12 | Clay | Texas | 48077 | 983 | 16 |
1020463 | 1020463 | 2021-02-11 | Clay | Texas | 48077 | 981 | 16 |
1017218 | 1017218 | 2021-02-10 | Clay | Texas | 48077 | 978 | 16 |
1013973 | 1013973 | 2021-02-09 | Clay | Texas | 48077 | 975 | 16 |
1010728 | 1010728 | 2021-02-08 | Clay | Texas | 48077 | 969 | 16 |
1007482 | 1007482 | 2021-02-07 | Clay | Texas | 48077 | 969 | 16 |
1004236 | 1004236 | 2021-02-06 | Clay | Texas | 48077 | 969 | 16 |
1000990 | 1000990 | 2021-02-05 | Clay | Texas | 48077 | 963 | 16 |
997744 | 997744 | 2021-02-04 | Clay | Texas | 48077 | 962 | 15 |
994498 | 994498 | 2021-02-03 | Clay | Texas | 48077 | 961 | 15 |
991252 | 991252 | 2021-02-02 | Clay | Texas | 48077 | 955 | 15 |
988006 | 988006 | 2021-02-01 | Clay | Texas | 48077 | 944 | 15 |
984759 | 984759 | 2021-01-31 | Clay | Texas | 48077 | 944 | 15 |
981512 | 981512 | 2021-01-30 | Clay | Texas | 48077 | 944 | 15 |
978266 | 978266 | 2021-01-29 | Clay | Texas | 48077 | 939 | 15 |
975021 | 975021 | 2021-01-28 | Clay | Texas | 48077 | 939 | 13 |
971776 | 971776 | 2021-01-27 | Clay | Texas | 48077 | 938 | 13 |
968531 | 968531 | 2021-01-26 | Clay | Texas | 48077 | 938 | 13 |
965287 | 965287 | 2021-01-25 | Clay | Texas | 48077 | 930 | 13 |
962042 | 962042 | 2021-01-24 | Clay | Texas | 48077 | 930 | 13 |
958797 | 958797 | 2021-01-23 | Clay | Texas | 48077 | 930 | 13 |
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);