ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Cameron" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419781 | 1419781 | 2021-06-14 | Cameron | Texas | 48061 | 41702 | 1676 |
1416536 | 1416536 | 2021-06-13 | Cameron | Texas | 48061 | 41590 | 1676 |
1413290 | 1413290 | 2021-06-12 | Cameron | Texas | 48061 | 41590 | 1676 |
1410045 | 1410045 | 2021-06-11 | Cameron | Texas | 48061 | 41542 | 1674 |
1406800 | 1406800 | 2021-06-10 | Cameron | Texas | 48061 | 41496 | 1671 |
1403554 | 1403554 | 2021-06-09 | Cameron | Texas | 48061 | 41496 | 1671 |
1400309 | 1400309 | 2021-06-08 | Cameron | Texas | 48061 | 41422 | 1671 |
1397064 | 1397064 | 2021-06-07 | Cameron | Texas | 48061 | 41355 | 1671 |
1393817 | 1393817 | 2021-06-06 | Cameron | Texas | 48061 | 41355 | 1671 |
1390572 | 1390572 | 2021-06-05 | Cameron | Texas | 48061 | 41355 | 1671 |
1387327 | 1387327 | 2021-06-04 | Cameron | Texas | 48061 | 41316 | 1668 |
1384082 | 1384082 | 2021-06-03 | Cameron | Texas | 48061 | 41309 | 1664 |
1380836 | 1380836 | 2021-06-02 | Cameron | Texas | 48061 | 41288 | 1661 |
1377591 | 1377591 | 2021-06-01 | Cameron | Texas | 48061 | 41221 | 1658 |
1374345 | 1374345 | 2021-05-31 | Cameron | Texas | 48061 | 41221 | 1658 |
1371100 | 1371100 | 2021-05-30 | Cameron | Texas | 48061 | 41221 | 1658 |
1367854 | 1367854 | 2021-05-29 | Cameron | Texas | 48061 | 41221 | 1658 |
1364608 | 1364608 | 2021-05-28 | Cameron | Texas | 48061 | 41201 | 1658 |
1361362 | 1361362 | 2021-05-27 | Cameron | Texas | 48061 | 41201 | 1658 |
1358116 | 1358116 | 2021-05-26 | Cameron | Texas | 48061 | 41166 | 1656 |
1354870 | 1354870 | 2021-05-25 | Cameron | Texas | 48061 | 41139 | 1653 |
1351624 | 1351624 | 2021-05-24 | Cameron | Texas | 48061 | 41124 | 1652 |
1348378 | 1348378 | 2021-05-23 | Cameron | Texas | 48061 | 41013 | 1649 |
1345130 | 1345130 | 2021-05-22 | Cameron | Texas | 48061 | 41013 | 1649 |
1341882 | 1341882 | 2021-05-21 | Cameron | Texas | 48061 | 41004 | 1647 |
1338634 | 1338634 | 2021-05-20 | Cameron | Texas | 48061 | 40966 | 1647 |
1335387 | 1335387 | 2021-05-19 | Cameron | Texas | 48061 | 40955 | 1647 |
1332140 | 1332140 | 2021-05-18 | Cameron | Texas | 48061 | 40926 | 1645 |
1328893 | 1328893 | 2021-05-17 | Cameron | Texas | 48061 | 40926 | 1645 |
1325647 | 1325647 | 2021-05-16 | Cameron | Texas | 48061 | 40826 | 1644 |
1322401 | 1322401 | 2021-05-15 | Cameron | Texas | 48061 | 40826 | 1644 |
1319155 | 1319155 | 2021-05-14 | Cameron | Texas | 48061 | 40789 | 1641 |
1315907 | 1315907 | 2021-05-13 | Cameron | Texas | 48061 | 40774 | 1640 |
1312661 | 1312661 | 2021-05-12 | Cameron | Texas | 48061 | 40774 | 1646 |
1309414 | 1309414 | 2021-05-11 | Cameron | Texas | 48061 | 40708 | 1643 |
1306168 | 1306168 | 2021-05-10 | Cameron | Texas | 48061 | 40630 | 1643 |
1302922 | 1302922 | 2021-05-09 | Cameron | Texas | 48061 | 40630 | 1643 |
1299675 | 1299675 | 2021-05-08 | Cameron | Texas | 48061 | 40630 | 1643 |
1296428 | 1296428 | 2021-05-07 | Cameron | Texas | 48061 | 40630 | 1643 |
1293182 | 1293182 | 2021-05-06 | Cameron | Texas | 48061 | 40581 | 1642 |
1289936 | 1289936 | 2021-05-05 | Cameron | Texas | 48061 | 40507 | 1634 |
1286690 | 1286690 | 2021-05-04 | Cameron | Texas | 48061 | 40489 | 1632 |
1283444 | 1283444 | 2021-05-03 | Cameron | Texas | 48061 | 40361 | 1629 |
1280197 | 1280197 | 2021-05-02 | Cameron | Texas | 48061 | 40361 | 1629 |
1276950 | 1276950 | 2021-05-01 | Cameron | Texas | 48061 | 40361 | 1629 |
1273703 | 1273703 | 2021-04-30 | Cameron | Texas | 48061 | 40296 | 1627 |
1270456 | 1270456 | 2021-04-29 | Cameron | Texas | 48061 | 40259 | 1613 |
1267209 | 1267209 | 2021-04-28 | Cameron | Texas | 48061 | 40259 | 1613 |
1263962 | 1263962 | 2021-04-27 | Cameron | Texas | 48061 | 40089 | 1606 |
1260715 | 1260715 | 2021-04-26 | Cameron | Texas | 48061 | 39974 | 1605 |
1257468 | 1257468 | 2021-04-25 | Cameron | Texas | 48061 | 39974 | 1605 |
1254221 | 1254221 | 2021-04-24 | Cameron | Texas | 48061 | 39974 | 1605 |
1250974 | 1250974 | 2021-04-23 | Cameron | Texas | 48061 | 39912 | 1604 |
1247727 | 1247727 | 2021-04-22 | Cameron | Texas | 48061 | 39886 | 1602 |
1244480 | 1244480 | 2021-04-21 | Cameron | Texas | 48061 | 39790 | 1602 |
1241233 | 1241233 | 2021-04-20 | Cameron | Texas | 48061 | 39698 | 1602 |
1237986 | 1237986 | 2021-04-19 | Cameron | Texas | 48061 | 39497 | 1599 |
1234739 | 1234739 | 2021-04-18 | Cameron | Texas | 48061 | 39497 | 1599 |
1231491 | 1231491 | 2021-04-17 | Cameron | Texas | 48061 | 39497 | 1599 |
1228243 | 1228243 | 2021-04-16 | Cameron | Texas | 48061 | 39441 | 1598 |
1224995 | 1224995 | 2021-04-15 | Cameron | Texas | 48061 | 39441 | 1598 |
1221748 | 1221748 | 2021-04-14 | Cameron | Texas | 48061 | 39410 | 1595 |
1218500 | 1218500 | 2021-04-13 | Cameron | Texas | 48061 | 39351 | 1594 |
1215252 | 1215252 | 2021-04-12 | Cameron | Texas | 48061 | 39268 | 1594 |
1212005 | 1212005 | 2021-04-11 | Cameron | Texas | 48061 | 39095 | 1593 |
1208756 | 1208756 | 2021-04-10 | Cameron | Texas | 48061 | 39043 | 1592 |
1205508 | 1205508 | 2021-04-09 | Cameron | Texas | 48061 | 39043 | 1592 |
1202260 | 1202260 | 2021-04-08 | Cameron | Texas | 48061 | 38980 | 1588 |
1199011 | 1199011 | 2021-04-07 | Cameron | Texas | 48061 | 38980 | 1588 |
1195762 | 1195762 | 2021-04-06 | Cameron | Texas | 48061 | 38937 | 1588 |
1192514 | 1192514 | 2021-04-05 | Cameron | Texas | 48061 | 38864 | 1588 |
1189265 | 1189265 | 2021-04-04 | Cameron | Texas | 48061 | 38680 | 1581 |
1186018 | 1186018 | 2021-04-03 | Cameron | Texas | 48061 | 38680 | 1581 |
1182771 | 1182771 | 2021-04-02 | Cameron | Texas | 48061 | 38680 | 1581 |
1179524 | 1179524 | 2021-04-01 | Cameron | Texas | 48061 | 38680 | 1581 |
1176277 | 1176277 | 2021-03-31 | Cameron | Texas | 48061 | 38584 | 1577 |
1173030 | 1173030 | 2021-03-30 | Cameron | Texas | 48061 | 38584 | 1577 |
1169783 | 1169783 | 2021-03-29 | Cameron | Texas | 48061 | 38543 | 1575 |
1166535 | 1166535 | 2021-03-28 | Cameron | Texas | 48061 | 38357 | 1572 |
1163287 | 1163287 | 2021-03-27 | Cameron | Texas | 48061 | 38357 | 1572 |
1160038 | 1160038 | 2021-03-26 | Cameron | Texas | 48061 | 38357 | 1572 |
1156791 | 1156791 | 2021-03-25 | Cameron | Texas | 48061 | 38312 | 1569 |
1153544 | 1153544 | 2021-03-24 | Cameron | Texas | 48061 | 38282 | 1568 |
1150297 | 1150297 | 2021-03-23 | Cameron | Texas | 48061 | 38255 | 1565 |
1147050 | 1147050 | 2021-03-22 | Cameron | Texas | 48061 | 38225 | 1560 |
1143803 | 1143803 | 2021-03-21 | Cameron | Texas | 48061 | 38122 | 1555 |
1140556 | 1140556 | 2021-03-20 | Cameron | Texas | 48061 | 38122 | 1555 |
1137310 | 1137310 | 2021-03-19 | Cameron | Texas | 48061 | 38122 | 1555 |
1134064 | 1134064 | 2021-03-18 | Cameron | Texas | 48061 | 38080 | 1554 |
1130816 | 1130816 | 2021-03-17 | Cameron | Texas | 48061 | 38056 | 1552 |
1127569 | 1127569 | 2021-03-16 | Cameron | Texas | 48061 | 38031 | 1547 |
1124323 | 1124323 | 2021-03-15 | Cameron | Texas | 48061 | 38001 | 1539 |
1121077 | 1121077 | 2021-03-14 | Cameron | Texas | 48061 | 37917 | 1534 |
1117830 | 1117830 | 2021-03-13 | Cameron | Texas | 48061 | 37917 | 1534 |
1114583 | 1114583 | 2021-03-12 | Cameron | Texas | 48061 | 37879 | 1532 |
1111337 | 1111337 | 2021-03-11 | Cameron | Texas | 48061 | 37879 | 1532 |
1108091 | 1108091 | 2021-03-10 | Cameron | Texas | 48061 | 37780 | 1527 |
1104845 | 1104845 | 2021-03-09 | Cameron | Texas | 48061 | 37780 | 1527 |
1101599 | 1101599 | 2021-03-08 | Cameron | Texas | 48061 | 37741 | 1503 |
1098353 | 1098353 | 2021-03-07 | Cameron | Texas | 48061 | 37566 | 1491 |
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);