ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Lincoln" 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 |
---|---|---|---|---|---|---|---|
1194936 | 1194936 | 2021-04-06 | Lincoln | New Mexico | 35027 | 1596 | 18 |
1191687 | 1191687 | 2021-04-05 | Lincoln | New Mexico | 35027 | 1595 | 18 |
1188439 | 1188439 | 2021-04-04 | Lincoln | New Mexico | 35027 | 1592 | 18 |
1185192 | 1185192 | 2021-04-03 | Lincoln | New Mexico | 35027 | 1592 | 18 |
1181945 | 1181945 | 2021-04-02 | Lincoln | New Mexico | 35027 | 1592 | 18 |
1178698 | 1178698 | 2021-04-01 | Lincoln | New Mexico | 35027 | 1591 | 18 |
1175451 | 1175451 | 2021-03-31 | Lincoln | New Mexico | 35027 | 1590 | 18 |
1172204 | 1172204 | 2021-03-30 | Lincoln | New Mexico | 35027 | 1586 | 18 |
1168956 | 1168956 | 2021-03-29 | Lincoln | New Mexico | 35027 | 1586 | 17 |
1165708 | 1165708 | 2021-03-28 | Lincoln | New Mexico | 35027 | 1586 | 17 |
1162460 | 1162460 | 2021-03-27 | Lincoln | New Mexico | 35027 | 1586 | 17 |
1159212 | 1159212 | 2021-03-26 | Lincoln | New Mexico | 35027 | 1585 | 17 |
1155965 | 1155965 | 2021-03-25 | Lincoln | New Mexico | 35027 | 1581 | 17 |
1152718 | 1152718 | 2021-03-24 | Lincoln | New Mexico | 35027 | 1578 | 17 |
1149471 | 1149471 | 2021-03-23 | Lincoln | New Mexico | 35027 | 1577 | 17 |
1146224 | 1146224 | 2021-03-22 | Lincoln | New Mexico | 35027 | 1577 | 17 |
1142977 | 1142977 | 2021-03-21 | Lincoln | New Mexico | 35027 | 1576 | 17 |
1139730 | 1139730 | 2021-03-20 | Lincoln | New Mexico | 35027 | 1576 | 17 |
1136484 | 1136484 | 2021-03-19 | Lincoln | New Mexico | 35027 | 1575 | 17 |
1133238 | 1133238 | 2021-03-18 | Lincoln | New Mexico | 35027 | 1576 | 17 |
1129990 | 1129990 | 2021-03-17 | Lincoln | New Mexico | 35027 | 1576 | 17 |
1126743 | 1126743 | 2021-03-16 | Lincoln | New Mexico | 35027 | 1574 | 16 |
1123497 | 1123497 | 2021-03-15 | Lincoln | New Mexico | 35027 | 1574 | 16 |
1120250 | 1120250 | 2021-03-14 | Lincoln | New Mexico | 35027 | 1571 | 16 |
1117003 | 1117003 | 2021-03-13 | Lincoln | New Mexico | 35027 | 1571 | 16 |
1113757 | 1113757 | 2021-03-12 | Lincoln | New Mexico | 35027 | 1571 | 16 |
1110511 | 1110511 | 2021-03-11 | Lincoln | New Mexico | 35027 | 1564 | 16 |
1107265 | 1107265 | 2021-03-10 | Lincoln | New Mexico | 35027 | 1561 | 16 |
1104019 | 1104019 | 2021-03-09 | Lincoln | New Mexico | 35027 | 1559 | 16 |
1100773 | 1100773 | 2021-03-08 | Lincoln | New Mexico | 35027 | 1557 | 16 |
1097526 | 1097526 | 2021-03-07 | Lincoln | New Mexico | 35027 | 1554 | 16 |
1094279 | 1094279 | 2021-03-06 | Lincoln | New Mexico | 35027 | 1554 | 16 |
1091033 | 1091033 | 2021-03-05 | Lincoln | New Mexico | 35027 | 1554 | 16 |
1087788 | 1087788 | 2021-03-04 | Lincoln | New Mexico | 35027 | 1552 | 16 |
1084543 | 1084543 | 2021-03-03 | Lincoln | New Mexico | 35027 | 1550 | 16 |
1081297 | 1081297 | 2021-03-02 | Lincoln | New Mexico | 35027 | 1544 | 16 |
1078051 | 1078051 | 2021-03-01 | Lincoln | New Mexico | 35027 | 1543 | 16 |
1074805 | 1074805 | 2021-02-28 | Lincoln | New Mexico | 35027 | 1543 | 16 |
1071559 | 1071559 | 2021-02-27 | Lincoln | New Mexico | 35027 | 1538 | 16 |
1068314 | 1068314 | 2021-02-26 | Lincoln | New Mexico | 35027 | 1536 | 16 |
1065069 | 1065069 | 2021-02-25 | Lincoln | New Mexico | 35027 | 1532 | 16 |
1061825 | 1061825 | 2021-02-24 | Lincoln | New Mexico | 35027 | 1527 | 16 |
1058579 | 1058579 | 2021-02-23 | Lincoln | New Mexico | 35027 | 1520 | 15 |
1055333 | 1055333 | 2021-02-22 | Lincoln | New Mexico | 35027 | 1516 | 15 |
1052086 | 1052086 | 2021-02-21 | Lincoln | New Mexico | 35027 | 1515 | 15 |
1048839 | 1048839 | 2021-02-20 | Lincoln | New Mexico | 35027 | 1511 | 15 |
1045593 | 1045593 | 2021-02-19 | Lincoln | New Mexico | 35027 | 1510 | 15 |
1042348 | 1042348 | 2021-02-18 | Lincoln | New Mexico | 35027 | 1500 | 15 |
1039103 | 1039103 | 2021-02-17 | Lincoln | New Mexico | 35027 | 1497 | 15 |
1035858 | 1035858 | 2021-02-16 | Lincoln | New Mexico | 35027 | 1496 | 15 |
1032613 | 1032613 | 2021-02-15 | Lincoln | New Mexico | 35027 | 1495 | 15 |
1029366 | 1029366 | 2021-02-14 | Lincoln | New Mexico | 35027 | 1495 | 15 |
1026120 | 1026120 | 2021-02-13 | Lincoln | New Mexico | 35027 | 1486 | 15 |
1022875 | 1022875 | 2021-02-12 | Lincoln | New Mexico | 35027 | 1483 | 15 |
1019630 | 1019630 | 2021-02-11 | Lincoln | New Mexico | 35027 | 1476 | 15 |
1016385 | 1016385 | 2021-02-10 | Lincoln | New Mexico | 35027 | 1475 | 15 |
1013140 | 1013140 | 2021-02-09 | Lincoln | New Mexico | 35027 | 1472 | 15 |
1009895 | 1009895 | 2021-02-08 | Lincoln | New Mexico | 35027 | 1470 | 15 |
1006648 | 1006648 | 2021-02-07 | Lincoln | New Mexico | 35027 | 1466 | 15 |
1003402 | 1003402 | 2021-02-06 | Lincoln | New Mexico | 35027 | 1459 | 15 |
1000157 | 1000157 | 2021-02-05 | Lincoln | New Mexico | 35027 | 1458 | 15 |
996911 | 996911 | 2021-02-04 | Lincoln | New Mexico | 35027 | 1456 | 15 |
993665 | 993665 | 2021-02-03 | Lincoln | New Mexico | 35027 | 1454 | 15 |
990419 | 990419 | 2021-02-02 | Lincoln | New Mexico | 35027 | 1447 | 14 |
987172 | 987172 | 2021-02-01 | Lincoln | New Mexico | 35027 | 1446 | 14 |
983925 | 983925 | 2021-01-31 | Lincoln | New Mexico | 35027 | 1443 | 14 |
980679 | 980679 | 2021-01-30 | Lincoln | New Mexico | 35027 | 1434 | 14 |
977433 | 977433 | 2021-01-29 | Lincoln | New Mexico | 35027 | 1424 | 14 |
974188 | 974188 | 2021-01-28 | Lincoln | New Mexico | 35027 | 1417 | 14 |
970943 | 970943 | 2021-01-27 | Lincoln | New Mexico | 35027 | 1406 | 14 |
967698 | 967698 | 2021-01-26 | Lincoln | New Mexico | 35027 | 1388 | 14 |
964454 | 964454 | 2021-01-25 | Lincoln | New Mexico | 35027 | 1378 | 14 |
961209 | 961209 | 2021-01-24 | Lincoln | New Mexico | 35027 | 1377 | 14 |
957963 | 957963 | 2021-01-23 | Lincoln | New Mexico | 35027 | 1355 | 14 |
954718 | 954718 | 2021-01-22 | Lincoln | New Mexico | 35027 | 1341 | 14 |
951473 | 951473 | 2021-01-21 | Lincoln | New Mexico | 35027 | 1327 | 13 |
948227 | 948227 | 2021-01-20 | Lincoln | New Mexico | 35027 | 1308 | 13 |
944980 | 944980 | 2021-01-19 | Lincoln | New Mexico | 35027 | 1286 | 13 |
941735 | 941735 | 2021-01-18 | Lincoln | New Mexico | 35027 | 1281 | 13 |
938490 | 938490 | 2021-01-17 | Lincoln | New Mexico | 35027 | 1253 | 13 |
935245 | 935245 | 2021-01-16 | Lincoln | New Mexico | 35027 | 1249 | 13 |
932000 | 932000 | 2021-01-15 | Lincoln | New Mexico | 35027 | 1234 | 13 |
928755 | 928755 | 2021-01-14 | Lincoln | New Mexico | 35027 | 1190 | 13 |
925509 | 925509 | 2021-01-13 | Lincoln | New Mexico | 35027 | 1182 | 13 |
922264 | 922264 | 2021-01-12 | Lincoln | New Mexico | 35027 | 1178 | 13 |
919019 | 919019 | 2021-01-11 | Lincoln | New Mexico | 35027 | 1173 | 13 |
915774 | 915774 | 2021-01-10 | Lincoln | New Mexico | 35027 | 1153 | 13 |
912529 | 912529 | 2021-01-09 | Lincoln | New Mexico | 35027 | 1143 | 13 |
909284 | 909284 | 2021-01-08 | Lincoln | New Mexico | 35027 | 1128 | 13 |
906038 | 906038 | 2021-01-07 | Lincoln | New Mexico | 35027 | 1109 | 12 |
902793 | 902793 | 2021-01-06 | Lincoln | New Mexico | 35027 | 1090 | 12 |
899548 | 899548 | 2021-01-05 | Lincoln | New Mexico | 35027 | 1088 | 11 |
896303 | 896303 | 2021-01-04 | Lincoln | New Mexico | 35027 | 1081 | 11 |
893056 | 893056 | 2021-01-03 | Lincoln | New Mexico | 35027 | 1078 | 11 |
889810 | 889810 | 2021-01-02 | Lincoln | New Mexico | 35027 | 1061 | 10 |
886564 | 886564 | 2021-01-01 | Lincoln | New Mexico | 35027 | 1043 | 10 |
883319 | 883319 | 2020-12-31 | Lincoln | New Mexico | 35027 | 1040 | 10 |
880074 | 880074 | 2020-12-30 | Lincoln | New Mexico | 35027 | 1020 | 10 |
876829 | 876829 | 2020-12-29 | Lincoln | New Mexico | 35027 | 1016 | 10 |
873584 | 873584 | 2020-12-28 | Lincoln | New Mexico | 35027 | 1012 | 10 |
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);