ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 39, fips = 48287 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1517274 | 1517274 | 2021-07-14 | Lee | Texas | 48287 | 2256 | 39 |
1514027 | 1514027 | 2021-07-13 | Lee | Texas | 48287 | 2252 | 39 |
1510781 | 1510781 | 2021-07-12 | Lee | Texas | 48287 | 2252 | 39 |
1507534 | 1507534 | 2021-07-11 | Lee | Texas | 48287 | 2251 | 39 |
1504288 | 1504288 | 2021-07-10 | Lee | Texas | 48287 | 2251 | 39 |
1501042 | 1501042 | 2021-07-09 | Lee | Texas | 48287 | 2250 | 39 |
1497796 | 1497796 | 2021-07-08 | Lee | Texas | 48287 | 2250 | 39 |
1494549 | 1494549 | 2021-07-07 | Lee | Texas | 48287 | 2247 | 39 |
1491302 | 1491302 | 2021-07-06 | Lee | Texas | 48287 | 2246 | 39 |
1488055 | 1488055 | 2021-07-05 | Lee | Texas | 48287 | 2245 | 39 |
1484808 | 1484808 | 2021-07-04 | Lee | Texas | 48287 | 2243 | 39 |
1481562 | 1481562 | 2021-07-03 | Lee | Texas | 48287 | 2243 | 39 |
1478315 | 1478315 | 2021-07-02 | Lee | Texas | 48287 | 2241 | 39 |
1475069 | 1475069 | 2021-07-01 | Lee | Texas | 48287 | 2240 | 39 |
1471823 | 1471823 | 2021-06-30 | Lee | Texas | 48287 | 2237 | 39 |
1468578 | 1468578 | 2021-06-29 | Lee | Texas | 48287 | 2237 | 39 |
1465333 | 1465333 | 2021-06-28 | Lee | Texas | 48287 | 2236 | 39 |
1462088 | 1462088 | 2021-06-27 | Lee | Texas | 48287 | 2235 | 39 |
1458843 | 1458843 | 2021-06-26 | Lee | Texas | 48287 | 2235 | 39 |
1455598 | 1455598 | 2021-06-25 | Lee | Texas | 48287 | 2227 | 39 |
1452353 | 1452353 | 2021-06-24 | Lee | Texas | 48287 | 2227 | 39 |
1449107 | 1449107 | 2021-06-23 | Lee | Texas | 48287 | 2226 | 39 |
1445862 | 1445862 | 2021-06-22 | Lee | Texas | 48287 | 2226 | 39 |
1442617 | 1442617 | 2021-06-21 | Lee | Texas | 48287 | 2225 | 39 |
1439372 | 1439372 | 2021-06-20 | Lee | Texas | 48287 | 2224 | 39 |
1436125 | 1436125 | 2021-06-19 | Lee | Texas | 48287 | 2224 | 39 |
1432878 | 1432878 | 2021-06-18 | Lee | Texas | 48287 | 2220 | 39 |
1429632 | 1429632 | 2021-06-17 | Lee | Texas | 48287 | 2219 | 39 |
1426387 | 1426387 | 2021-06-16 | Lee | Texas | 48287 | 2217 | 39 |
1423140 | 1423140 | 2021-06-15 | Lee | Texas | 48287 | 2217 | 39 |
1419894 | 1419894 | 2021-06-14 | Lee | Texas | 48287 | 2217 | 39 |
1416649 | 1416649 | 2021-06-13 | Lee | Texas | 48287 | 2217 | 39 |
1413403 | 1413403 | 2021-06-12 | Lee | Texas | 48287 | 2217 | 39 |
1410158 | 1410158 | 2021-06-11 | Lee | Texas | 48287 | 2217 | 39 |
1406913 | 1406913 | 2021-06-10 | Lee | Texas | 48287 | 2217 | 39 |
1403667 | 1403667 | 2021-06-09 | Lee | Texas | 48287 | 2217 | 39 |
1400422 | 1400422 | 2021-06-08 | Lee | Texas | 48287 | 2217 | 39 |
1397177 | 1397177 | 2021-06-07 | Lee | Texas | 48287 | 2216 | 39 |
1393930 | 1393930 | 2021-06-06 | Lee | Texas | 48287 | 2213 | 39 |
1390685 | 1390685 | 2021-06-05 | Lee | Texas | 48287 | 2213 | 39 |
1387440 | 1387440 | 2021-06-04 | Lee | Texas | 48287 | 2213 | 39 |
1384195 | 1384195 | 2021-06-03 | Lee | Texas | 48287 | 2218 | 39 |
1380949 | 1380949 | 2021-06-02 | Lee | Texas | 48287 | 2216 | 39 |
1377704 | 1377704 | 2021-06-01 | Lee | Texas | 48287 | 2212 | 39 |
1374458 | 1374458 | 2021-05-31 | Lee | Texas | 48287 | 2212 | 39 |
1371213 | 1371213 | 2021-05-30 | Lee | Texas | 48287 | 2212 | 39 |
1367967 | 1367967 | 2021-05-29 | Lee | Texas | 48287 | 2212 | 39 |
1364721 | 1364721 | 2021-05-28 | Lee | Texas | 48287 | 2212 | 39 |
1361475 | 1361475 | 2021-05-27 | Lee | Texas | 48287 | 2210 | 39 |
1358229 | 1358229 | 2021-05-26 | Lee | Texas | 48287 | 2210 | 39 |
1354983 | 1354983 | 2021-05-25 | Lee | Texas | 48287 | 2210 | 39 |
1351737 | 1351737 | 2021-05-24 | Lee | Texas | 48287 | 2209 | 39 |
1348491 | 1348491 | 2021-05-23 | Lee | Texas | 48287 | 2208 | 39 |
1345243 | 1345243 | 2021-05-22 | Lee | Texas | 48287 | 2208 | 39 |
1341995 | 1341995 | 2021-05-21 | Lee | Texas | 48287 | 2208 | 39 |
1338747 | 1338747 | 2021-05-20 | Lee | Texas | 48287 | 2207 | 39 |
1335500 | 1335500 | 2021-05-19 | Lee | Texas | 48287 | 2202 | 39 |
1332253 | 1332253 | 2021-05-18 | Lee | Texas | 48287 | 2202 | 39 |
1329006 | 1329006 | 2021-05-17 | Lee | Texas | 48287 | 2201 | 39 |
1325760 | 1325760 | 2021-05-16 | Lee | Texas | 48287 | 2200 | 39 |
1322514 | 1322514 | 2021-05-15 | Lee | Texas | 48287 | 2200 | 39 |
1319268 | 1319268 | 2021-05-14 | Lee | Texas | 48287 | 2198 | 39 |
1316020 | 1316020 | 2021-05-13 | Lee | Texas | 48287 | 2198 | 39 |
1312774 | 1312774 | 2021-05-12 | Lee | Texas | 48287 | 2197 | 39 |
1309527 | 1309527 | 2021-05-11 | Lee | Texas | 48287 | 2197 | 39 |
1306281 | 1306281 | 2021-05-10 | Lee | Texas | 48287 | 2194 | 39 |
1303035 | 1303035 | 2021-05-09 | Lee | Texas | 48287 | 2193 | 39 |
1299788 | 1299788 | 2021-05-08 | Lee | Texas | 48287 | 2193 | 39 |
1296541 | 1296541 | 2021-05-07 | Lee | Texas | 48287 | 2191 | 39 |
1293295 | 1293295 | 2021-05-06 | Lee | Texas | 48287 | 2190 | 39 |
1290049 | 1290049 | 2021-05-05 | Lee | Texas | 48287 | 2189 | 39 |
1286803 | 1286803 | 2021-05-04 | Lee | Texas | 48287 | 2186 | 39 |
1283557 | 1283557 | 2021-05-03 | Lee | Texas | 48287 | 2183 | 39 |
1280310 | 1280310 | 2021-05-02 | Lee | Texas | 48287 | 2177 | 39 |
1277063 | 1277063 | 2021-05-01 | Lee | Texas | 48287 | 2177 | 39 |
1273816 | 1273816 | 2021-04-30 | Lee | Texas | 48287 | 2175 | 39 |
1270569 | 1270569 | 2021-04-29 | Lee | Texas | 48287 | 2172 | 39 |
1267322 | 1267322 | 2021-04-28 | Lee | Texas | 48287 | 2170 | 39 |
1264075 | 1264075 | 2021-04-27 | Lee | Texas | 48287 | 2168 | 39 |
1260828 | 1260828 | 2021-04-26 | Lee | Texas | 48287 | 2167 | 39 |
1257581 | 1257581 | 2021-04-25 | Lee | Texas | 48287 | 2165 | 39 |
1254334 | 1254334 | 2021-04-24 | Lee | Texas | 48287 | 2165 | 39 |
1251087 | 1251087 | 2021-04-23 | Lee | Texas | 48287 | 2162 | 39 |
1247840 | 1247840 | 2021-04-22 | Lee | Texas | 48287 | 2157 | 39 |
1244593 | 1244593 | 2021-04-21 | Lee | Texas | 48287 | 2156 | 39 |
1241346 | 1241346 | 2021-04-20 | Lee | Texas | 48287 | 2147 | 39 |
1238099 | 1238099 | 2021-04-19 | Lee | Texas | 48287 | 2143 | 39 |
1234852 | 1234852 | 2021-04-18 | Lee | Texas | 48287 | 2141 | 39 |
1231604 | 1231604 | 2021-04-17 | Lee | Texas | 48287 | 2141 | 39 |
1228356 | 1228356 | 2021-04-16 | Lee | Texas | 48287 | 2138 | 39 |
1225108 | 1225108 | 2021-04-15 | Lee | Texas | 48287 | 2134 | 39 |
1221861 | 1221861 | 2021-04-14 | Lee | Texas | 48287 | 2132 | 39 |
1218613 | 1218613 | 2021-04-13 | Lee | Texas | 48287 | 2129 | 39 |
1215365 | 1215365 | 2021-04-12 | Lee | Texas | 48287 | 2128 | 39 |
1212118 | 1212118 | 2021-04-11 | Lee | Texas | 48287 | 2126 | 39 |
1208869 | 1208869 | 2021-04-10 | Lee | Texas | 48287 | 2126 | 39 |
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);