ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 48003 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280168 | 1280168 | 2021-05-02 | Andrews | Texas | 48003 | 1816 | 47 |
1276921 | 1276921 | 2021-05-01 | Andrews | Texas | 48003 | 1816 | 47 |
1273674 | 1273674 | 2021-04-30 | Andrews | Texas | 48003 | 1816 | 47 |
1270427 | 1270427 | 2021-04-29 | Andrews | Texas | 48003 | 1812 | 47 |
1267180 | 1267180 | 2021-04-28 | Andrews | Texas | 48003 | 1812 | 47 |
1263933 | 1263933 | 2021-04-27 | Andrews | Texas | 48003 | 1812 | 47 |
1260686 | 1260686 | 2021-04-26 | Andrews | Texas | 48003 | 1812 | 47 |
1257439 | 1257439 | 2021-04-25 | Andrews | Texas | 48003 | 1812 | 47 |
1254192 | 1254192 | 2021-04-24 | Andrews | Texas | 48003 | 1812 | 47 |
1250945 | 1250945 | 2021-04-23 | Andrews | Texas | 48003 | 1812 | 47 |
1247698 | 1247698 | 2021-04-22 | Andrews | Texas | 48003 | 1812 | 47 |
1244451 | 1244451 | 2021-04-21 | Andrews | Texas | 48003 | 1812 | 47 |
1241204 | 1241204 | 2021-04-20 | Andrews | Texas | 48003 | 1812 | 47 |
1237957 | 1237957 | 2021-04-19 | Andrews | Texas | 48003 | 1812 | 47 |
1234710 | 1234710 | 2021-04-18 | Andrews | Texas | 48003 | 1812 | 47 |
1231462 | 1231462 | 2021-04-17 | Andrews | Texas | 48003 | 1812 | 47 |
1228214 | 1228214 | 2021-04-16 | Andrews | Texas | 48003 | 1811 | 47 |
1224966 | 1224966 | 2021-04-15 | Andrews | Texas | 48003 | 1811 | 47 |
1221719 | 1221719 | 2021-04-14 | Andrews | Texas | 48003 | 1811 | 47 |
1218471 | 1218471 | 2021-04-13 | Andrews | Texas | 48003 | 1811 | 47 |
1215223 | 1215223 | 2021-04-12 | Andrews | Texas | 48003 | 1811 | 47 |
1211976 | 1211976 | 2021-04-11 | Andrews | Texas | 48003 | 1811 | 47 |
1208727 | 1208727 | 2021-04-10 | Andrews | Texas | 48003 | 1811 | 47 |
1205479 | 1205479 | 2021-04-09 | Andrews | Texas | 48003 | 1811 | 47 |
1202231 | 1202231 | 2021-04-08 | Andrews | Texas | 48003 | 1811 | 47 |
1198982 | 1198982 | 2021-04-07 | Andrews | Texas | 48003 | 1810 | 47 |
1195733 | 1195733 | 2021-04-06 | Andrews | Texas | 48003 | 1809 | 47 |
1192485 | 1192485 | 2021-04-05 | Andrews | Texas | 48003 | 1739 | 47 |
1189236 | 1189236 | 2021-04-04 | Andrews | Texas | 48003 | 1739 | 47 |
1185989 | 1185989 | 2021-04-03 | Andrews | Texas | 48003 | 1739 | 47 |
1182742 | 1182742 | 2021-04-02 | Andrews | Texas | 48003 | 1739 | 47 |
1179495 | 1179495 | 2021-04-01 | Andrews | Texas | 48003 | 1739 | 47 |
1176248 | 1176248 | 2021-03-31 | Andrews | Texas | 48003 | 1739 | 47 |
1173001 | 1173001 | 2021-03-30 | Andrews | Texas | 48003 | 1739 | 47 |
1169754 | 1169754 | 2021-03-29 | Andrews | Texas | 48003 | 1739 | 47 |
1166506 | 1166506 | 2021-03-28 | Andrews | Texas | 48003 | 1739 | 47 |
1163258 | 1163258 | 2021-03-27 | Andrews | Texas | 48003 | 1739 | 47 |
1160009 | 1160009 | 2021-03-26 | Andrews | Texas | 48003 | 1739 | 47 |
1156762 | 1156762 | 2021-03-25 | Andrews | Texas | 48003 | 1739 | 47 |
1153515 | 1153515 | 2021-03-24 | Andrews | Texas | 48003 | 1739 | 47 |
1150268 | 1150268 | 2021-03-23 | Andrews | Texas | 48003 | 1733 | 47 |
1147021 | 1147021 | 2021-03-22 | Andrews | Texas | 48003 | 1710 | 47 |
1143774 | 1143774 | 2021-03-21 | Andrews | Texas | 48003 | 1710 | 47 |
1140527 | 1140527 | 2021-03-20 | Andrews | Texas | 48003 | 1710 | 47 |
1137281 | 1137281 | 2021-03-19 | Andrews | Texas | 48003 | 1710 | 47 |
1134035 | 1134035 | 2021-03-18 | Andrews | Texas | 48003 | 1710 | 47 |
1130787 | 1130787 | 2021-03-17 | Andrews | Texas | 48003 | 1710 | 47 |
1127540 | 1127540 | 2021-03-16 | Andrews | Texas | 48003 | 1710 | 46 |
1124294 | 1124294 | 2021-03-15 | Andrews | Texas | 48003 | 1710 | 46 |
1121048 | 1121048 | 2021-03-14 | Andrews | Texas | 48003 | 1710 | 46 |
1117801 | 1117801 | 2021-03-13 | Andrews | Texas | 48003 | 1710 | 46 |
1114554 | 1114554 | 2021-03-12 | Andrews | Texas | 48003 | 1701 | 46 |
1111308 | 1111308 | 2021-03-11 | Andrews | Texas | 48003 | 1701 | 46 |
1108062 | 1108062 | 2021-03-10 | Andrews | Texas | 48003 | 1701 | 46 |
1104816 | 1104816 | 2021-03-09 | Andrews | Texas | 48003 | 1695 | 46 |
1101570 | 1101570 | 2021-03-08 | Andrews | Texas | 48003 | 1695 | 46 |
1098324 | 1098324 | 2021-03-07 | Andrews | Texas | 48003 | 1695 | 46 |
1095076 | 1095076 | 2021-03-06 | Andrews | Texas | 48003 | 1695 | 46 |
1091830 | 1091830 | 2021-03-05 | Andrews | Texas | 48003 | 1695 | 46 |
1088584 | 1088584 | 2021-03-04 | Andrews | Texas | 48003 | 1694 | 46 |
1085339 | 1085339 | 2021-03-03 | Andrews | Texas | 48003 | 1694 | 46 |
1082093 | 1082093 | 2021-03-02 | Andrews | Texas | 48003 | 1694 | 46 |
1078847 | 1078847 | 2021-03-01 | Andrews | Texas | 48003 | 1694 | 46 |
1075602 | 1075602 | 2021-02-28 | Andrews | Texas | 48003 | 1694 | 46 |
1072356 | 1072356 | 2021-02-27 | Andrews | Texas | 48003 | 1694 | 46 |
1069110 | 1069110 | 2021-02-26 | Andrews | Texas | 48003 | 1679 | 46 |
1065865 | 1065865 | 2021-02-25 | Andrews | Texas | 48003 | 1679 | 46 |
1062620 | 1062620 | 2021-02-24 | Andrews | Texas | 48003 | 1679 | 46 |
1059375 | 1059375 | 2021-02-23 | Andrews | Texas | 48003 | 1679 | 46 |
1056129 | 1056129 | 2021-02-22 | Andrews | Texas | 48003 | 1679 | 46 |
1052883 | 1052883 | 2021-02-21 | Andrews | Texas | 48003 | 1679 | 45 |
1049636 | 1049636 | 2021-02-20 | Andrews | Texas | 48003 | 1679 | 45 |
1046389 | 1046389 | 2021-02-19 | Andrews | Texas | 48003 | 1679 | 45 |
1043144 | 1043144 | 2021-02-18 | Andrews | Texas | 48003 | 1679 | 45 |
1039899 | 1039899 | 2021-02-17 | Andrews | Texas | 48003 | 1679 | 45 |
1036654 | 1036654 | 2021-02-16 | Andrews | Texas | 48003 | 1679 | 45 |
1033409 | 1033409 | 2021-02-15 | Andrews | Texas | 48003 | 1679 | 45 |
1030163 | 1030163 | 2021-02-14 | Andrews | Texas | 48003 | 1679 | 45 |
1026916 | 1026916 | 2021-02-13 | Andrews | Texas | 48003 | 1679 | 45 |
1023671 | 1023671 | 2021-02-12 | Andrews | Texas | 48003 | 1679 | 45 |
1020426 | 1020426 | 2021-02-11 | Andrews | Texas | 48003 | 1678 | 45 |
1017181 | 1017181 | 2021-02-10 | Andrews | Texas | 48003 | 1678 | 45 |
1013936 | 1013936 | 2021-02-09 | Andrews | Texas | 48003 | 1672 | 44 |
1010691 | 1010691 | 2021-02-08 | Andrews | Texas | 48003 | 1672 | 44 |
1007445 | 1007445 | 2021-02-07 | Andrews | Texas | 48003 | 1672 | 44 |
1004199 | 1004199 | 2021-02-06 | Andrews | Texas | 48003 | 1672 | 44 |
1000953 | 1000953 | 2021-02-05 | Andrews | Texas | 48003 | 1672 | 44 |
997707 | 997707 | 2021-02-04 | Andrews | Texas | 48003 | 1672 | 44 |
994461 | 994461 | 2021-02-03 | Andrews | Texas | 48003 | 1655 | 44 |
991215 | 991215 | 2021-02-02 | Andrews | Texas | 48003 | 1655 | 40 |
987969 | 987969 | 2021-02-01 | Andrews | Texas | 48003 | 1649 | 40 |
984722 | 984722 | 2021-01-31 | Andrews | Texas | 48003 | 1649 | 40 |
981475 | 981475 | 2021-01-30 | Andrews | Texas | 48003 | 1649 | 40 |
978229 | 978229 | 2021-01-29 | Andrews | Texas | 48003 | 1649 | 40 |
974984 | 974984 | 2021-01-28 | Andrews | Texas | 48003 | 1630 | 40 |
971739 | 971739 | 2021-01-27 | Andrews | Texas | 48003 | 1630 | 40 |
968494 | 968494 | 2021-01-26 | Andrews | Texas | 48003 | 1630 | 37 |
965250 | 965250 | 2021-01-25 | Andrews | Texas | 48003 | 1630 | 37 |
962005 | 962005 | 2021-01-24 | Andrews | Texas | 48003 | 1630 | 37 |
958760 | 958760 | 2021-01-23 | Andrews | Texas | 48003 | 1630 | 37 |
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);