ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Bowie" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280185 | 1280185 | 2021-05-02 | Bowie | Texas | 48037 | 6938 | 212 |
1276938 | 1276938 | 2021-05-01 | Bowie | Texas | 48037 | 6936 | 212 |
1273691 | 1273691 | 2021-04-30 | Bowie | Texas | 48037 | 6930 | 212 |
1270444 | 1270444 | 2021-04-29 | Bowie | Texas | 48037 | 6928 | 211 |
1267197 | 1267197 | 2021-04-28 | Bowie | Texas | 48037 | 6923 | 211 |
1263950 | 1263950 | 2021-04-27 | Bowie | Texas | 48037 | 6920 | 210 |
1260703 | 1260703 | 2021-04-26 | Bowie | Texas | 48037 | 6922 | 210 |
1257456 | 1257456 | 2021-04-25 | Bowie | Texas | 48037 | 6920 | 210 |
1254209 | 1254209 | 2021-04-24 | Bowie | Texas | 48037 | 6918 | 210 |
1250962 | 1250962 | 2021-04-23 | Bowie | Texas | 48037 | 6904 | 210 |
1247715 | 1247715 | 2021-04-22 | Bowie | Texas | 48037 | 6901 | 210 |
1244468 | 1244468 | 2021-04-21 | Bowie | Texas | 48037 | 6897 | 210 |
1241221 | 1241221 | 2021-04-20 | Bowie | Texas | 48037 | 6888 | 210 |
1237974 | 1237974 | 2021-04-19 | Bowie | Texas | 48037 | 6883 | 210 |
1234727 | 1234727 | 2021-04-18 | Bowie | Texas | 48037 | 6882 | 210 |
1231479 | 1231479 | 2021-04-17 | Bowie | Texas | 48037 | 6872 | 210 |
1228231 | 1228231 | 2021-04-16 | Bowie | Texas | 48037 | 6870 | 209 |
1224983 | 1224983 | 2021-04-15 | Bowie | Texas | 48037 | 6873 | 209 |
1221736 | 1221736 | 2021-04-14 | Bowie | Texas | 48037 | 6874 | 209 |
1218488 | 1218488 | 2021-04-13 | Bowie | Texas | 48037 | 6877 | 208 |
1215240 | 1215240 | 2021-04-12 | Bowie | Texas | 48037 | 6875 | 208 |
1211993 | 1211993 | 2021-04-11 | Bowie | Texas | 48037 | 6877 | 208 |
1208744 | 1208744 | 2021-04-10 | Bowie | Texas | 48037 | 6871 | 208 |
1205496 | 1205496 | 2021-04-09 | Bowie | Texas | 48037 | 6864 | 208 |
1202248 | 1202248 | 2021-04-08 | Bowie | Texas | 48037 | 6858 | 207 |
1198999 | 1198999 | 2021-04-07 | Bowie | Texas | 48037 | 6856 | 207 |
1195750 | 1195750 | 2021-04-06 | Bowie | Texas | 48037 | 6852 | 207 |
1192502 | 1192502 | 2021-04-05 | Bowie | Texas | 48037 | 6855 | 207 |
1189253 | 1189253 | 2021-04-04 | Bowie | Texas | 48037 | 6848 | 207 |
1186006 | 1186006 | 2021-04-03 | Bowie | Texas | 48037 | 6848 | 207 |
1182759 | 1182759 | 2021-04-02 | Bowie | Texas | 48037 | 6840 | 206 |
1179512 | 1179512 | 2021-04-01 | Bowie | Texas | 48037 | 6827 | 204 |
1176265 | 1176265 | 2021-03-31 | Bowie | Texas | 48037 | 6825 | 203 |
1173018 | 1173018 | 2021-03-30 | Bowie | Texas | 48037 | 6812 | 202 |
1169771 | 1169771 | 2021-03-29 | Bowie | Texas | 48037 | 6811 | 202 |
1166523 | 1166523 | 2021-03-28 | Bowie | Texas | 48037 | 6800 | 202 |
1163275 | 1163275 | 2021-03-27 | Bowie | Texas | 48037 | 6799 | 201 |
1160026 | 1160026 | 2021-03-26 | Bowie | Texas | 48037 | 6790 | 201 |
1156779 | 1156779 | 2021-03-25 | Bowie | Texas | 48037 | 6784 | 201 |
1153532 | 1153532 | 2021-03-24 | Bowie | Texas | 48037 | 6770 | 200 |
1150285 | 1150285 | 2021-03-23 | Bowie | Texas | 48037 | 6767 | 199 |
1147038 | 1147038 | 2021-03-22 | Bowie | Texas | 48037 | 6761 | 198 |
1143791 | 1143791 | 2021-03-21 | Bowie | Texas | 48037 | 6760 | 198 |
1140544 | 1140544 | 2021-03-20 | Bowie | Texas | 48037 | 6754 | 198 |
1137298 | 1137298 | 2021-03-19 | Bowie | Texas | 48037 | 6742 | 197 |
1134052 | 1134052 | 2021-03-18 | Bowie | Texas | 48037 | 6740 | 195 |
1130804 | 1130804 | 2021-03-17 | Bowie | Texas | 48037 | 6735 | 195 |
1127557 | 1127557 | 2021-03-16 | Bowie | Texas | 48037 | 6732 | 195 |
1124311 | 1124311 | 2021-03-15 | Bowie | Texas | 48037 | 6715 | 195 |
1121065 | 1121065 | 2021-03-14 | Bowie | Texas | 48037 | 6711 | 195 |
1117818 | 1117818 | 2021-03-13 | Bowie | Texas | 48037 | 6703 | 195 |
1114571 | 1114571 | 2021-03-12 | Bowie | Texas | 48037 | 6700 | 192 |
1111325 | 1111325 | 2021-03-11 | Bowie | Texas | 48037 | 6697 | 191 |
1108079 | 1108079 | 2021-03-10 | Bowie | Texas | 48037 | 6688 | 191 |
1104833 | 1104833 | 2021-03-09 | Bowie | Texas | 48037 | 6677 | 187 |
1101587 | 1101587 | 2021-03-08 | Bowie | Texas | 48037 | 6675 | 187 |
1098341 | 1098341 | 2021-03-07 | Bowie | Texas | 48037 | 6674 | 187 |
1095093 | 1095093 | 2021-03-06 | Bowie | Texas | 48037 | 6660 | 187 |
1091847 | 1091847 | 2021-03-05 | Bowie | Texas | 48037 | 6634 | 186 |
1088601 | 1088601 | 2021-03-04 | Bowie | Texas | 48037 | 6599 | 185 |
1085356 | 1085356 | 2021-03-03 | Bowie | Texas | 48037 | 6582 | 183 |
1082110 | 1082110 | 2021-03-02 | Bowie | Texas | 48037 | 6574 | 182 |
1078864 | 1078864 | 2021-03-01 | Bowie | Texas | 48037 | 6545 | 181 |
1075619 | 1075619 | 2021-02-28 | Bowie | Texas | 48037 | 6543 | 181 |
1072373 | 1072373 | 2021-02-27 | Bowie | Texas | 48037 | 6532 | 181 |
1069127 | 1069127 | 2021-02-26 | Bowie | Texas | 48037 | 6501 | 179 |
1065882 | 1065882 | 2021-02-25 | Bowie | Texas | 48037 | 6484 | 179 |
1062637 | 1062637 | 2021-02-24 | Bowie | Texas | 48037 | 6478 | 177 |
1059392 | 1059392 | 2021-02-23 | Bowie | Texas | 48037 | 6468 | 175 |
1056146 | 1056146 | 2021-02-22 | Bowie | Texas | 48037 | 6448 | 172 |
1052900 | 1052900 | 2021-02-21 | Bowie | Texas | 48037 | 6440 | 171 |
1049653 | 1049653 | 2021-02-20 | Bowie | Texas | 48037 | 6426 | 171 |
1046406 | 1046406 | 2021-02-19 | Bowie | Texas | 48037 | 6417 | 171 |
1043161 | 1043161 | 2021-02-18 | Bowie | Texas | 48037 | 6393 | 171 |
1039916 | 1039916 | 2021-02-17 | Bowie | Texas | 48037 | 6385 | 171 |
1036671 | 1036671 | 2021-02-16 | Bowie | Texas | 48037 | 6370 | 171 |
1033426 | 1033426 | 2021-02-15 | Bowie | Texas | 48037 | 6351 | 171 |
1030180 | 1030180 | 2021-02-14 | Bowie | Texas | 48037 | 6322 | 171 |
1026933 | 1026933 | 2021-02-13 | Bowie | Texas | 48037 | 6312 | 170 |
1023688 | 1023688 | 2021-02-12 | Bowie | Texas | 48037 | 6282 | 169 |
1020443 | 1020443 | 2021-02-11 | Bowie | Texas | 48037 | 6235 | 167 |
1017198 | 1017198 | 2021-02-10 | Bowie | Texas | 48037 | 6206 | 164 |
1013953 | 1013953 | 2021-02-09 | Bowie | Texas | 48037 | 6183 | 163 |
1010708 | 1010708 | 2021-02-08 | Bowie | Texas | 48037 | 6156 | 162 |
1007462 | 1007462 | 2021-02-07 | Bowie | Texas | 48037 | 6114 | 162 |
1004216 | 1004216 | 2021-02-06 | Bowie | Texas | 48037 | 6114 | 162 |
1000970 | 1000970 | 2021-02-05 | Bowie | Texas | 48037 | 6074 | 162 |
997724 | 997724 | 2021-02-04 | Bowie | Texas | 48037 | 6023 | 159 |
994478 | 994478 | 2021-02-03 | Bowie | Texas | 48037 | 6006 | 158 |
991232 | 991232 | 2021-02-02 | Bowie | Texas | 48037 | 5956 | 157 |
987986 | 987986 | 2021-02-01 | Bowie | Texas | 48037 | 5915 | 156 |
984739 | 984739 | 2021-01-31 | Bowie | Texas | 48037 | 5872 | 156 |
981492 | 981492 | 2021-01-30 | Bowie | Texas | 48037 | 5866 | 156 |
978246 | 978246 | 2021-01-29 | Bowie | Texas | 48037 | 5754 | 155 |
975001 | 975001 | 2021-01-28 | Bowie | Texas | 48037 | 5723 | 154 |
971756 | 971756 | 2021-01-27 | Bowie | Texas | 48037 | 5677 | 154 |
968511 | 968511 | 2021-01-26 | Bowie | Texas | 48037 | 5131 | 150 |
965267 | 965267 | 2021-01-25 | Bowie | Texas | 48037 | 5069 | 150 |
962022 | 962022 | 2021-01-24 | Bowie | Texas | 48037 | 5069 | 150 |
958777 | 958777 | 2021-01-23 | Bowie | Texas | 48037 | 5067 | 150 |
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);