ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48061 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1095105 | 1095105 | 2021-03-06 | Cameron | Texas | 48061 | 37566 | 1491 |
1091859 | 1091859 | 2021-03-05 | Cameron | Texas | 48061 | 37566 | 1491 |
1088613 | 1088613 | 2021-03-04 | Cameron | Texas | 48061 | 37566 | 1491 |
1085368 | 1085368 | 2021-03-03 | Cameron | Texas | 48061 | 37518 | 1484 |
1082122 | 1082122 | 2021-03-02 | Cameron | Texas | 48061 | 37411 | 1480 |
1078876 | 1078876 | 2021-03-01 | Cameron | Texas | 48061 | 37239 | 1471 |
1075631 | 1075631 | 2021-02-28 | Cameron | Texas | 48061 | 37239 | 1471 |
1072385 | 1072385 | 2021-02-27 | Cameron | Texas | 48061 | 37239 | 1471 |
1069139 | 1069139 | 2021-02-26 | Cameron | Texas | 48061 | 37166 | 1466 |
1065894 | 1065894 | 2021-02-25 | Cameron | Texas | 48061 | 37166 | 1466 |
1062649 | 1062649 | 2021-02-24 | Cameron | Texas | 48061 | 37137 | 1457 |
1059404 | 1059404 | 2021-02-23 | Cameron | Texas | 48061 | 37106 | 1445 |
1056158 | 1056158 | 2021-02-22 | Cameron | Texas | 48061 | 37041 | 1432 |
1052912 | 1052912 | 2021-02-21 | Cameron | Texas | 48061 | 36902 | 1415 |
1049665 | 1049665 | 2021-02-20 | Cameron | Texas | 48061 | 36902 | 1415 |
1046418 | 1046418 | 2021-02-19 | Cameron | Texas | 48061 | 36902 | 1415 |
1043173 | 1043173 | 2021-02-18 | Cameron | Texas | 48061 | 36514 | 1396 |
1039928 | 1039928 | 2021-02-17 | Cameron | Texas | 48061 | 36514 | 1396 |
1036683 | 1036683 | 2021-02-16 | Cameron | Texas | 48061 | 36514 | 1396 |
1033438 | 1033438 | 2021-02-15 | Cameron | Texas | 48061 | 36514 | 1396 |
1030192 | 1030192 | 2021-02-14 | Cameron | Texas | 48061 | 36514 | 1396 |
1026945 | 1026945 | 2021-02-13 | Cameron | Texas | 48061 | 36514 | 1396 |
1023700 | 1023700 | 2021-02-12 | Cameron | Texas | 48061 | 36514 | 1396 |
1020455 | 1020455 | 2021-02-11 | Cameron | Texas | 48061 | 36323 | 1392 |
1017210 | 1017210 | 2021-02-10 | Cameron | Texas | 48061 | 36258 | 1386 |
1013965 | 1013965 | 2021-02-09 | Cameron | Texas | 48061 | 36148 | 1386 |
1010720 | 1010720 | 2021-02-08 | Cameron | Texas | 48061 | 36076 | 1379 |
1007474 | 1007474 | 2021-02-07 | Cameron | Texas | 48061 | 35736 | 1366 |
1004228 | 1004228 | 2021-02-06 | Cameron | Texas | 48061 | 35736 | 1366 |
1000982 | 1000982 | 2021-02-05 | Cameron | Texas | 48061 | 35736 | 1366 |
997736 | 997736 | 2021-02-04 | Cameron | Texas | 48061 | 35625 | 1357 |
994490 | 994490 | 2021-02-03 | Cameron | Texas | 48061 | 35536 | 1351 |
991244 | 991244 | 2021-02-02 | Cameron | Texas | 48061 | 35300 | 1332 |
987998 | 987998 | 2021-02-01 | Cameron | Texas | 48061 | 35300 | 1332 |
984751 | 984751 | 2021-01-31 | Cameron | Texas | 48061 | 34841 | 1317 |
981504 | 981504 | 2021-01-30 | Cameron | Texas | 48061 | 34961 | 1317 |
978258 | 978258 | 2021-01-29 | Cameron | Texas | 48061 | 34691 | 1305 |
975013 | 975013 | 2021-01-28 | Cameron | Texas | 48061 | 34691 | 1305 |
971768 | 971768 | 2021-01-27 | Cameron | Texas | 48061 | 34482 | 1282 |
968523 | 968523 | 2021-01-26 | Cameron | Texas | 48061 | 34259 | 1272 |
965279 | 965279 | 2021-01-25 | Cameron | Texas | 48061 | 34259 | 1272 |
962034 | 962034 | 2021-01-24 | Cameron | Texas | 48061 | 33748 | 1260 |
958789 | 958789 | 2021-01-23 | Cameron | Texas | 48061 | 33748 | 1260 |
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);