ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 35025 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418954 | 1418954 | 2021-06-14 | Lea | New Mexico | 35025 | 9147 | 196 |
1415709 | 1415709 | 2021-06-13 | Lea | New Mexico | 35025 | 9136 | 196 |
1412463 | 1412463 | 2021-06-12 | Lea | New Mexico | 35025 | 9136 | 196 |
1409218 | 1409218 | 2021-06-11 | Lea | New Mexico | 35025 | 9136 | 196 |
1405973 | 1405973 | 2021-06-10 | Lea | New Mexico | 35025 | 9135 | 196 |
1402727 | 1402727 | 2021-06-09 | Lea | New Mexico | 35025 | 9133 | 196 |
1399482 | 1399482 | 2021-06-08 | Lea | New Mexico | 35025 | 9132 | 196 |
1396236 | 1396236 | 2021-06-07 | Lea | New Mexico | 35025 | 9132 | 196 |
1392990 | 1392990 | 2021-06-06 | Lea | New Mexico | 35025 | 9130 | 196 |
1389745 | 1389745 | 2021-06-05 | Lea | New Mexico | 35025 | 9130 | 196 |
1386500 | 1386500 | 2021-06-04 | Lea | New Mexico | 35025 | 9130 | 196 |
1383255 | 1383255 | 2021-06-03 | Lea | New Mexico | 35025 | 9130 | 196 |
1380009 | 1380009 | 2021-06-02 | Lea | New Mexico | 35025 | 9130 | 196 |
1376764 | 1376764 | 2021-06-01 | Lea | New Mexico | 35025 | 9123 | 196 |
1373518 | 1373518 | 2021-05-31 | Lea | New Mexico | 35025 | 9076 | 195 |
1370273 | 1370273 | 2021-05-30 | Lea | New Mexico | 35025 | 9076 | 195 |
1367027 | 1367027 | 2021-05-29 | Lea | New Mexico | 35025 | 9076 | 195 |
1363781 | 1363781 | 2021-05-28 | Lea | New Mexico | 35025 | 9076 | 195 |
1360535 | 1360535 | 2021-05-27 | Lea | New Mexico | 35025 | 9076 | 195 |
1357289 | 1357289 | 2021-05-26 | Lea | New Mexico | 35025 | 9074 | 195 |
1354043 | 1354043 | 2021-05-25 | Lea | New Mexico | 35025 | 9074 | 195 |
1350797 | 1350797 | 2021-05-24 | Lea | New Mexico | 35025 | 9071 | 195 |
1347551 | 1347551 | 2021-05-23 | Lea | New Mexico | 35025 | 9070 | 169 |
1344303 | 1344303 | 2021-05-22 | Lea | New Mexico | 35025 | 9070 | 169 |
1341055 | 1341055 | 2021-05-21 | Lea | New Mexico | 35025 | 9070 | 169 |
1337807 | 1337807 | 2021-05-20 | Lea | New Mexico | 35025 | 9070 | 169 |
1334560 | 1334560 | 2021-05-19 | Lea | New Mexico | 35025 | 9060 | 169 |
1331313 | 1331313 | 2021-05-18 | Lea | New Mexico | 35025 | 9059 | 169 |
1328066 | 1328066 | 2021-05-17 | Lea | New Mexico | 35025 | 9055 | 169 |
1324820 | 1324820 | 2021-05-16 | Lea | New Mexico | 35025 | 9049 | 169 |
1321574 | 1321574 | 2021-05-15 | Lea | New Mexico | 35025 | 9049 | 169 |
1318328 | 1318328 | 2021-05-14 | Lea | New Mexico | 35025 | 9049 | 169 |
1315080 | 1315080 | 2021-05-13 | Lea | New Mexico | 35025 | 9048 | 169 |
1311834 | 1311834 | 2021-05-12 | Lea | New Mexico | 35025 | 9048 | 169 |
1308587 | 1308587 | 2021-05-11 | Lea | New Mexico | 35025 | 9047 | 169 |
1305341 | 1305341 | 2021-05-10 | Lea | New Mexico | 35025 | 9045 | 169 |
1302095 | 1302095 | 2021-05-09 | Lea | New Mexico | 35025 | 9038 | 169 |
1298847 | 1298847 | 2021-05-08 | Lea | New Mexico | 35025 | 9038 | 169 |
1295601 | 1295601 | 2021-05-07 | Lea | New Mexico | 35025 | 9038 | 169 |
1292355 | 1292355 | 2021-05-06 | Lea | New Mexico | 35025 | 9034 | 168 |
1289109 | 1289109 | 2021-05-05 | Lea | New Mexico | 35025 | 9034 | 168 |
1285863 | 1285863 | 2021-05-04 | Lea | New Mexico | 35025 | 9033 | 168 |
1282617 | 1282617 | 2021-05-03 | Lea | New Mexico | 35025 | 9031 | 165 |
1279370 | 1279370 | 2021-05-02 | Lea | New Mexico | 35025 | 9034 | 164 |
1276123 | 1276123 | 2021-05-01 | Lea | New Mexico | 35025 | 9034 | 164 |
1272876 | 1272876 | 2021-04-30 | Lea | New Mexico | 35025 | 9034 | 164 |
1269629 | 1269629 | 2021-04-29 | Lea | New Mexico | 35025 | 9033 | 164 |
1266382 | 1266382 | 2021-04-28 | Lea | New Mexico | 35025 | 9030 | 164 |
1263135 | 1263135 | 2021-04-27 | Lea | New Mexico | 35025 | 9029 | 164 |
1259888 | 1259888 | 2021-04-26 | Lea | New Mexico | 35025 | 9026 | 161 |
1256641 | 1256641 | 2021-04-25 | Lea | New Mexico | 35025 | 9028 | 161 |
1253394 | 1253394 | 2021-04-24 | Lea | New Mexico | 35025 | 9028 | 161 |
1250147 | 1250147 | 2021-04-23 | Lea | New Mexico | 35025 | 9028 | 161 |
1246900 | 1246900 | 2021-04-22 | Lea | New Mexico | 35025 | 9027 | 161 |
1243653 | 1243653 | 2021-04-21 | Lea | New Mexico | 35025 | 9028 | 161 |
1240406 | 1240406 | 2021-04-20 | Lea | New Mexico | 35025 | 9028 | 161 |
1237159 | 1237159 | 2021-04-19 | Lea | New Mexico | 35025 | 9028 | 161 |
1233912 | 1233912 | 2021-04-18 | Lea | New Mexico | 35025 | 9025 | 161 |
1230664 | 1230664 | 2021-04-17 | Lea | New Mexico | 35025 | 9025 | 161 |
1227416 | 1227416 | 2021-04-16 | Lea | New Mexico | 35025 | 9025 | 161 |
1224168 | 1224168 | 2021-04-15 | Lea | New Mexico | 35025 | 9021 | 161 |
1220921 | 1220921 | 2021-04-14 | Lea | New Mexico | 35025 | 9019 | 161 |
1217673 | 1217673 | 2021-04-13 | Lea | New Mexico | 35025 | 9018 | 161 |
1214425 | 1214425 | 2021-04-12 | Lea | New Mexico | 35025 | 9015 | 161 |
1211178 | 1211178 | 2021-04-11 | Lea | New Mexico | 35025 | 9003 | 160 |
1207929 | 1207929 | 2021-04-10 | Lea | New Mexico | 35025 | 9003 | 160 |
1204681 | 1204681 | 2021-04-09 | Lea | New Mexico | 35025 | 9003 | 160 |
1201433 | 1201433 | 2021-04-08 | Lea | New Mexico | 35025 | 9000 | 160 |
1198184 | 1198184 | 2021-04-07 | Lea | New Mexico | 35025 | 9000 | 159 |
1194935 | 1194935 | 2021-04-06 | Lea | New Mexico | 35025 | 8996 | 159 |
1191686 | 1191686 | 2021-04-05 | Lea | New Mexico | 35025 | 8993 | 159 |
1188438 | 1188438 | 2021-04-04 | Lea | New Mexico | 35025 | 8972 | 159 |
1185191 | 1185191 | 2021-04-03 | Lea | New Mexico | 35025 | 8972 | 159 |
1181944 | 1181944 | 2021-04-02 | Lea | New Mexico | 35025 | 8972 | 159 |
1178697 | 1178697 | 2021-04-01 | Lea | New Mexico | 35025 | 8962 | 159 |
1175450 | 1175450 | 2021-03-31 | Lea | New Mexico | 35025 | 8958 | 159 |
1172203 | 1172203 | 2021-03-30 | Lea | New Mexico | 35025 | 8949 | 159 |
1168955 | 1168955 | 2021-03-29 | Lea | New Mexico | 35025 | 8949 | 159 |
1165707 | 1165707 | 2021-03-28 | Lea | New Mexico | 35025 | 8946 | 159 |
1162459 | 1162459 | 2021-03-27 | Lea | New Mexico | 35025 | 8941 | 159 |
1159211 | 1159211 | 2021-03-26 | Lea | New Mexico | 35025 | 8934 | 159 |
1155964 | 1155964 | 2021-03-25 | Lea | New Mexico | 35025 | 8935 | 159 |
1152717 | 1152717 | 2021-03-24 | Lea | New Mexico | 35025 | 8934 | 159 |
1149470 | 1149470 | 2021-03-23 | Lea | New Mexico | 35025 | 8931 | 159 |
1146223 | 1146223 | 2021-03-22 | Lea | New Mexico | 35025 | 8930 | 158 |
1142976 | 1142976 | 2021-03-21 | Lea | New Mexico | 35025 | 8908 | 157 |
1139729 | 1139729 | 2021-03-20 | Lea | New Mexico | 35025 | 8894 | 157 |
1136483 | 1136483 | 2021-03-19 | Lea | New Mexico | 35025 | 8893 | 157 |
1133237 | 1133237 | 2021-03-18 | Lea | New Mexico | 35025 | 8888 | 157 |
1129989 | 1129989 | 2021-03-17 | Lea | New Mexico | 35025 | 8881 | 157 |
1126742 | 1126742 | 2021-03-16 | Lea | New Mexico | 35025 | 8878 | 157 |
1123496 | 1123496 | 2021-03-15 | Lea | New Mexico | 35025 | 8877 | 155 |
1120249 | 1120249 | 2021-03-14 | Lea | New Mexico | 35025 | 8868 | 155 |
1117002 | 1117002 | 2021-03-13 | Lea | New Mexico | 35025 | 8862 | 155 |
1113756 | 1113756 | 2021-03-12 | Lea | New Mexico | 35025 | 8860 | 155 |
1110510 | 1110510 | 2021-03-11 | Lea | New Mexico | 35025 | 8858 | 155 |
1107264 | 1107264 | 2021-03-10 | Lea | New Mexico | 35025 | 8842 | 155 |
1104018 | 1104018 | 2021-03-09 | Lea | New Mexico | 35025 | 8841 | 155 |
1100772 | 1100772 | 2021-03-08 | Lea | New Mexico | 35025 | 8843 | 150 |
1097525 | 1097525 | 2021-03-07 | Lea | New Mexico | 35025 | 8837 | 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);