ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lee" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1205621 | 1205621 | 2021-04-09 | Lee | Texas | 48287 | 2125 | 38 |
1202373 | 1202373 | 2021-04-08 | Lee | Texas | 48287 | 2123 | 38 |
1199124 | 1199124 | 2021-04-07 | Lee | Texas | 48287 | 2120 | 38 |
1195875 | 1195875 | 2021-04-06 | Lee | Texas | 48287 | 2119 | 38 |
1192627 | 1192627 | 2021-04-05 | Lee | Texas | 48287 | 2119 | 38 |
1189378 | 1189378 | 2021-04-04 | Lee | Texas | 48287 | 2119 | 38 |
1186131 | 1186131 | 2021-04-03 | Lee | Texas | 48287 | 2119 | 38 |
1182884 | 1182884 | 2021-04-02 | Lee | Texas | 48287 | 2121 | 38 |
1179637 | 1179637 | 2021-04-01 | Lee | Texas | 48287 | 2119 | 38 |
1176390 | 1176390 | 2021-03-31 | Lee | Texas | 48287 | 2115 | 38 |
1173143 | 1173143 | 2021-03-30 | Lee | Texas | 48287 | 2113 | 37 |
1169896 | 1169896 | 2021-03-29 | Lee | Texas | 48287 | 2110 | 37 |
1166648 | 1166648 | 2021-03-28 | Lee | Texas | 48287 | 2104 | 37 |
1163400 | 1163400 | 2021-03-27 | Lee | Texas | 48287 | 2104 | 37 |
1160151 | 1160151 | 2021-03-26 | Lee | Texas | 48287 | 2099 | 37 |
1156904 | 1156904 | 2021-03-25 | Lee | Texas | 48287 | 2097 | 37 |
1153657 | 1153657 | 2021-03-24 | Lee | Texas | 48287 | 2095 | 37 |
1150410 | 1150410 | 2021-03-23 | Lee | Texas | 48287 | 2090 | 37 |
1147163 | 1147163 | 2021-03-22 | Lee | Texas | 48287 | 2090 | 37 |
1143916 | 1143916 | 2021-03-21 | Lee | Texas | 48287 | 2090 | 37 |
1140669 | 1140669 | 2021-03-20 | Lee | Texas | 48287 | 2090 | 37 |
1137423 | 1137423 | 2021-03-19 | Lee | Texas | 48287 | 2083 | 37 |
1134177 | 1134177 | 2021-03-18 | Lee | Texas | 48287 | 2086 | 36 |
1130929 | 1130929 | 2021-03-17 | Lee | Texas | 48287 | 2083 | 36 |
1127682 | 1127682 | 2021-03-16 | Lee | Texas | 48287 | 2077 | 36 |
1124436 | 1124436 | 2021-03-15 | Lee | Texas | 48287 | 2077 | 36 |
1121190 | 1121190 | 2021-03-14 | Lee | Texas | 48287 | 2074 | 36 |
1117943 | 1117943 | 2021-03-13 | Lee | Texas | 48287 | 2074 | 36 |
1114696 | 1114696 | 2021-03-12 | Lee | Texas | 48287 | 2071 | 36 |
1111450 | 1111450 | 2021-03-11 | Lee | Texas | 48287 | 2070 | 36 |
1108204 | 1108204 | 2021-03-10 | Lee | Texas | 48287 | 2067 | 36 |
1104958 | 1104958 | 2021-03-09 | Lee | Texas | 48287 | 2059 | 36 |
1101712 | 1101712 | 2021-03-08 | Lee | Texas | 48287 | 2051 | 36 |
1098466 | 1098466 | 2021-03-07 | Lee | Texas | 48287 | 2049 | 36 |
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);