ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 48469 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280401 | 1280401 | 2021-05-02 | Victoria | Texas | 48469 | 8613 | 206 |
1277154 | 1277154 | 2021-05-01 | Victoria | Texas | 48469 | 8613 | 206 |
1273907 | 1273907 | 2021-04-30 | Victoria | Texas | 48469 | 8600 | 206 |
1270660 | 1270660 | 2021-04-29 | Victoria | Texas | 48469 | 8557 | 206 |
1267413 | 1267413 | 2021-04-28 | Victoria | Texas | 48469 | 8535 | 205 |
1264166 | 1264166 | 2021-04-27 | Victoria | Texas | 48469 | 8499 | 204 |
1260919 | 1260919 | 2021-04-26 | Victoria | Texas | 48469 | 8485 | 204 |
1257672 | 1257672 | 2021-04-25 | Victoria | Texas | 48469 | 8485 | 204 |
1254425 | 1254425 | 2021-04-24 | Victoria | Texas | 48469 | 8485 | 204 |
1251178 | 1251178 | 2021-04-23 | Victoria | Texas | 48469 | 8471 | 204 |
1247931 | 1247931 | 2021-04-22 | Victoria | Texas | 48469 | 8461 | 201 |
1244684 | 1244684 | 2021-04-21 | Victoria | Texas | 48469 | 8447 | 200 |
1241437 | 1241437 | 2021-04-20 | Victoria | Texas | 48469 | 8392 | 199 |
1238190 | 1238190 | 2021-04-19 | Victoria | Texas | 48469 | 8379 | 199 |
1234943 | 1234943 | 2021-04-18 | Victoria | Texas | 48469 | 8379 | 199 |
1231695 | 1231695 | 2021-04-17 | Victoria | Texas | 48469 | 8379 | 199 |
1228447 | 1228447 | 2021-04-16 | Victoria | Texas | 48469 | 8355 | 198 |
1225199 | 1225199 | 2021-04-15 | Victoria | Texas | 48469 | 8336 | 198 |
1221952 | 1221952 | 2021-04-14 | Victoria | Texas | 48469 | 8319 | 198 |
1218704 | 1218704 | 2021-04-13 | Victoria | Texas | 48469 | 8295 | 198 |
1215456 | 1215456 | 2021-04-12 | Victoria | Texas | 48469 | 8272 | 198 |
1212209 | 1212209 | 2021-04-11 | Victoria | Texas | 48469 | 8272 | 198 |
1208960 | 1208960 | 2021-04-10 | Victoria | Texas | 48469 | 8272 | 198 |
1205712 | 1205712 | 2021-04-09 | Victoria | Texas | 48469 | 8259 | 198 |
1202464 | 1202464 | 2021-04-08 | Victoria | Texas | 48469 | 8238 | 198 |
1199215 | 1199215 | 2021-04-07 | Victoria | Texas | 48469 | 8187 | 198 |
1195966 | 1195966 | 2021-04-06 | Victoria | Texas | 48469 | 8187 | 198 |
1192718 | 1192718 | 2021-04-05 | Victoria | Texas | 48469 | 8170 | 197 |
1189469 | 1189469 | 2021-04-04 | Victoria | Texas | 48469 | 8170 | 197 |
1186222 | 1186222 | 2021-04-03 | Victoria | Texas | 48469 | 8170 | 197 |
1182975 | 1182975 | 2021-04-02 | Victoria | Texas | 48469 | 8170 | 197 |
1179728 | 1179728 | 2021-04-01 | Victoria | Texas | 48469 | 8127 | 194 |
1176481 | 1176481 | 2021-03-31 | Victoria | Texas | 48469 | 8127 | 194 |
1173234 | 1173234 | 2021-03-30 | Victoria | Texas | 48469 | 8086 | 194 |
1169987 | 1169987 | 2021-03-29 | Victoria | Texas | 48469 | 8085 | 194 |
1166739 | 1166739 | 2021-03-28 | Victoria | Texas | 48469 | 8085 | 194 |
1163491 | 1163491 | 2021-03-27 | Victoria | Texas | 48469 | 8085 | 194 |
1160242 | 1160242 | 2021-03-26 | Victoria | Texas | 48469 | 8085 | 194 |
1156995 | 1156995 | 2021-03-25 | Victoria | Texas | 48469 | 8069 | 192 |
1153748 | 1153748 | 2021-03-24 | Victoria | Texas | 48469 | 8067 | 192 |
1150501 | 1150501 | 2021-03-23 | Victoria | Texas | 48469 | 8061 | 192 |
1147254 | 1147254 | 2021-03-22 | Victoria | Texas | 48469 | 8059 | 192 |
1144007 | 1144007 | 2021-03-21 | Victoria | Texas | 48469 | 8059 | 192 |
1140760 | 1140760 | 2021-03-20 | Victoria | Texas | 48469 | 8059 | 192 |
1137514 | 1137514 | 2021-03-19 | Victoria | Texas | 48469 | 8059 | 190 |
1134268 | 1134268 | 2021-03-18 | Victoria | Texas | 48469 | 8044 | 190 |
1131020 | 1131020 | 2021-03-17 | Victoria | Texas | 48469 | 8028 | 190 |
1127773 | 1127773 | 2021-03-16 | Victoria | Texas | 48469 | 8013 | 189 |
1124527 | 1124527 | 2021-03-15 | Victoria | Texas | 48469 | 8011 | 189 |
1121281 | 1121281 | 2021-03-14 | Victoria | Texas | 48469 | 8011 | 188 |
1118034 | 1118034 | 2021-03-13 | Victoria | Texas | 48469 | 8011 | 188 |
1114787 | 1114787 | 2021-03-12 | Victoria | Texas | 48469 | 8003 | 188 |
1111541 | 1111541 | 2021-03-11 | Victoria | Texas | 48469 | 7996 | 186 |
1108295 | 1108295 | 2021-03-10 | Victoria | Texas | 48469 | 7981 | 184 |
1105049 | 1105049 | 2021-03-09 | Victoria | Texas | 48469 | 7977 | 183 |
1101803 | 1101803 | 2021-03-08 | Victoria | Texas | 48469 | 7958 | 180 |
1098557 | 1098557 | 2021-03-07 | Victoria | Texas | 48469 | 7958 | 180 |
1095309 | 1095309 | 2021-03-06 | Victoria | Texas | 48469 | 7958 | 180 |
1092063 | 1092063 | 2021-03-05 | Victoria | Texas | 48469 | 7952 | 177 |
1088817 | 1088817 | 2021-03-04 | Victoria | Texas | 48469 | 7947 | 177 |
1085572 | 1085572 | 2021-03-03 | Victoria | Texas | 48469 | 7922 | 177 |
1082326 | 1082326 | 2021-03-02 | Victoria | Texas | 48469 | 7878 | 177 |
1079080 | 1079080 | 2021-03-01 | Victoria | Texas | 48469 | 7878 | 176 |
1075835 | 1075835 | 2021-02-28 | Victoria | Texas | 48469 | 7878 | 176 |
1072589 | 1072589 | 2021-02-27 | Victoria | Texas | 48469 | 7867 | 174 |
1069343 | 1069343 | 2021-02-26 | Victoria | Texas | 48469 | 7867 | 174 |
1066098 | 1066098 | 2021-02-25 | Victoria | Texas | 48469 | 7849 | 174 |
1062853 | 1062853 | 2021-02-24 | Victoria | Texas | 48469 | 7829 | 173 |
1059608 | 1059608 | 2021-02-23 | Victoria | Texas | 48469 | 7795 | 173 |
1056362 | 1056362 | 2021-02-22 | Victoria | Texas | 48469 | 7789 | 172 |
1053116 | 1053116 | 2021-02-21 | Victoria | Texas | 48469 | 7789 | 170 |
1049869 | 1049869 | 2021-02-20 | Victoria | Texas | 48469 | 7789 | 169 |
1046622 | 1046622 | 2021-02-19 | Victoria | Texas | 48469 | 7765 | 167 |
1043377 | 1043377 | 2021-02-18 | Victoria | Texas | 48469 | 7765 | 167 |
1040132 | 1040132 | 2021-02-17 | Victoria | Texas | 48469 | 7739 | 167 |
1036887 | 1036887 | 2021-02-16 | Victoria | Texas | 48469 | 7739 | 167 |
1033642 | 1033642 | 2021-02-15 | Victoria | Texas | 48469 | 7739 | 167 |
1030396 | 1030396 | 2021-02-14 | Victoria | Texas | 48469 | 7739 | 167 |
1027149 | 1027149 | 2021-02-13 | Victoria | Texas | 48469 | 7739 | 167 |
1023904 | 1023904 | 2021-02-12 | Victoria | Texas | 48469 | 7677 | 167 |
1020659 | 1020659 | 2021-02-11 | Victoria | Texas | 48469 | 7677 | 167 |
1017414 | 1017414 | 2021-02-10 | Victoria | Texas | 48469 | 7648 | 165 |
1014169 | 1014169 | 2021-02-09 | Victoria | Texas | 48469 | 7623 | 165 |
1010924 | 1010924 | 2021-02-08 | Victoria | Texas | 48469 | 7581 | 164 |
1007678 | 1007678 | 2021-02-07 | Victoria | Texas | 48469 | 7581 | 163 |
1004432 | 1004432 | 2021-02-06 | Victoria | Texas | 48469 | 7581 | 163 |
1001186 | 1001186 | 2021-02-05 | Victoria | Texas | 48469 | 7534 | 161 |
997940 | 997940 | 2021-02-04 | Victoria | Texas | 48469 | 7509 | 160 |
994694 | 994694 | 2021-02-03 | Victoria | Texas | 48469 | 7460 | 158 |
991448 | 991448 | 2021-02-02 | Victoria | Texas | 48469 | 7369 | 153 |
988202 | 988202 | 2021-02-01 | Victoria | Texas | 48469 | 7317 | 149 |
984955 | 984955 | 2021-01-31 | Victoria | Texas | 48469 | 7317 | 149 |
981708 | 981708 | 2021-01-30 | Victoria | Texas | 48469 | 7317 | 149 |
978462 | 978462 | 2021-01-29 | Victoria | Texas | 48469 | 7317 | 148 |
975217 | 975217 | 2021-01-28 | Victoria | Texas | 48469 | 7204 | 147 |
971972 | 971972 | 2021-01-27 | Victoria | Texas | 48469 | 7131 | 141 |
968727 | 968727 | 2021-01-26 | Victoria | Texas | 48469 | 7066 | 140 |
965483 | 965483 | 2021-01-25 | Victoria | Texas | 48469 | 6984 | 139 |
962238 | 962238 | 2021-01-24 | Victoria | Texas | 48469 | 6984 | 139 |
958993 | 958993 | 2021-01-23 | Victoria | Texas | 48469 | 6984 | 139 |
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);