ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
726 rows where county = "Hidalgo" 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 |
---|---|---|---|---|---|---|---|
1418953 | 1418953 | 2021-06-14 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1415708 | 1415708 | 2021-06-13 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1412462 | 1412462 | 2021-06-12 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1409217 | 1409217 | 2021-06-11 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1405972 | 1405972 | 2021-06-10 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1402726 | 1402726 | 2021-06-09 | Hidalgo | New Mexico | 35023 | 364 | 9 |
1399481 | 1399481 | 2021-06-08 | Hidalgo | New Mexico | 35023 | 364 | 9 |
1396235 | 1396235 | 2021-06-07 | Hidalgo | New Mexico | 35023 | 364 | 9 |
1392989 | 1392989 | 2021-06-06 | Hidalgo | New Mexico | 35023 | 364 | 9 |
1389744 | 1389744 | 2021-06-05 | Hidalgo | New Mexico | 35023 | 364 | 9 |
1386499 | 1386499 | 2021-06-04 | Hidalgo | New Mexico | 35023 | 364 | 9 |
1383254 | 1383254 | 2021-06-03 | Hidalgo | New Mexico | 35023 | 364 | 9 |
1380008 | 1380008 | 2021-06-02 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1376763 | 1376763 | 2021-06-01 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1373517 | 1373517 | 2021-05-31 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1370272 | 1370272 | 2021-05-30 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1367026 | 1367026 | 2021-05-29 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1363780 | 1363780 | 2021-05-28 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1360534 | 1360534 | 2021-05-27 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1357288 | 1357288 | 2021-05-26 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1354042 | 1354042 | 2021-05-25 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1350796 | 1350796 | 2021-05-24 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1347550 | 1347550 | 2021-05-23 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1344302 | 1344302 | 2021-05-22 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1341054 | 1341054 | 2021-05-21 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1337806 | 1337806 | 2021-05-20 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1334559 | 1334559 | 2021-05-19 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1331312 | 1331312 | 2021-05-18 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1328065 | 1328065 | 2021-05-17 | Hidalgo | New Mexico | 35023 | 363 | 9 |
1324819 | 1324819 | 2021-05-16 | Hidalgo | New Mexico | 35023 | 362 | 9 |
1321573 | 1321573 | 2021-05-15 | Hidalgo | New Mexico | 35023 | 362 | 9 |
1318327 | 1318327 | 2021-05-14 | Hidalgo | New Mexico | 35023 | 362 | 9 |
1315079 | 1315079 | 2021-05-13 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1311833 | 1311833 | 2021-05-12 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1308586 | 1308586 | 2021-05-11 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1305340 | 1305340 | 2021-05-10 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1302094 | 1302094 | 2021-05-09 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1298846 | 1298846 | 2021-05-08 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1295600 | 1295600 | 2021-05-07 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1292354 | 1292354 | 2021-05-06 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1289108 | 1289108 | 2021-05-05 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1285862 | 1285862 | 2021-05-04 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1282616 | 1282616 | 2021-05-03 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1279369 | 1279369 | 2021-05-02 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1276122 | 1276122 | 2021-05-01 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1272875 | 1272875 | 2021-04-30 | Hidalgo | New Mexico | 35023 | 361 | 9 |
1269628 | 1269628 | 2021-04-29 | Hidalgo | New Mexico | 35023 | 360 | 9 |
1266381 | 1266381 | 2021-04-28 | Hidalgo | New Mexico | 35023 | 360 | 9 |
1263134 | 1263134 | 2021-04-27 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1259887 | 1259887 | 2021-04-26 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1256640 | 1256640 | 2021-04-25 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1253393 | 1253393 | 2021-04-24 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1250146 | 1250146 | 2021-04-23 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1246899 | 1246899 | 2021-04-22 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1243652 | 1243652 | 2021-04-21 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1240405 | 1240405 | 2021-04-20 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1237158 | 1237158 | 2021-04-19 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1233911 | 1233911 | 2021-04-18 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1230663 | 1230663 | 2021-04-17 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1227415 | 1227415 | 2021-04-16 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1224167 | 1224167 | 2021-04-15 | Hidalgo | New Mexico | 35023 | 359 | 9 |
1220920 | 1220920 | 2021-04-14 | Hidalgo | New Mexico | 35023 | 357 | 9 |
1217672 | 1217672 | 2021-04-13 | Hidalgo | New Mexico | 35023 | 357 | 9 |
1214424 | 1214424 | 2021-04-12 | Hidalgo | New Mexico | 35023 | 357 | 9 |
1211177 | 1211177 | 2021-04-11 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1207928 | 1207928 | 2021-04-10 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1204680 | 1204680 | 2021-04-09 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1201432 | 1201432 | 2021-04-08 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1198183 | 1198183 | 2021-04-07 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1194934 | 1194934 | 2021-04-06 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1191685 | 1191685 | 2021-04-05 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1188437 | 1188437 | 2021-04-04 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1185190 | 1185190 | 2021-04-03 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1181943 | 1181943 | 2021-04-02 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1178696 | 1178696 | 2021-04-01 | Hidalgo | New Mexico | 35023 | 355 | 9 |
1175449 | 1175449 | 2021-03-31 | Hidalgo | New Mexico | 35023 | 353 | 9 |
1172202 | 1172202 | 2021-03-30 | Hidalgo | New Mexico | 35023 | 353 | 9 |
1168954 | 1168954 | 2021-03-29 | Hidalgo | New Mexico | 35023 | 353 | 9 |
1165706 | 1165706 | 2021-03-28 | Hidalgo | New Mexico | 35023 | 352 | 9 |
1162458 | 1162458 | 2021-03-27 | Hidalgo | New Mexico | 35023 | 352 | 9 |
1159210 | 1159210 | 2021-03-26 | Hidalgo | New Mexico | 35023 | 352 | 9 |
1155963 | 1155963 | 2021-03-25 | Hidalgo | New Mexico | 35023 | 352 | 9 |
1152716 | 1152716 | 2021-03-24 | Hidalgo | New Mexico | 35023 | 352 | 9 |
1149469 | 1149469 | 2021-03-23 | Hidalgo | New Mexico | 35023 | 351 | 9 |
1146222 | 1146222 | 2021-03-22 | Hidalgo | New Mexico | 35023 | 351 | 9 |
1142975 | 1142975 | 2021-03-21 | Hidalgo | New Mexico | 35023 | 351 | 9 |
1139728 | 1139728 | 2021-03-20 | Hidalgo | New Mexico | 35023 | 351 | 9 |
1136482 | 1136482 | 2021-03-19 | Hidalgo | New Mexico | 35023 | 351 | 9 |
1133236 | 1133236 | 2021-03-18 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1129988 | 1129988 | 2021-03-17 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1126741 | 1126741 | 2021-03-16 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1123495 | 1123495 | 2021-03-15 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1120248 | 1120248 | 2021-03-14 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1117001 | 1117001 | 2021-03-13 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1113755 | 1113755 | 2021-03-12 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1110509 | 1110509 | 2021-03-11 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1107263 | 1107263 | 2021-03-10 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1104017 | 1104017 | 2021-03-09 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1100771 | 1100771 | 2021-03-08 | Hidalgo | New Mexico | 35023 | 350 | 9 |
1097524 | 1097524 | 2021-03-07 | Hidalgo | New Mexico | 35023 | 350 | 9 |
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);