ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where fips = 48345 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280339 | 1280339 | 2021-05-02 | Motley | Texas | 48345 | 115 | 8 |
1277092 | 1277092 | 2021-05-01 | Motley | Texas | 48345 | 115 | 8 |
1273845 | 1273845 | 2021-04-30 | Motley | Texas | 48345 | 115 | 8 |
1270598 | 1270598 | 2021-04-29 | Motley | Texas | 48345 | 115 | 8 |
1267351 | 1267351 | 2021-04-28 | Motley | Texas | 48345 | 115 | 8 |
1264104 | 1264104 | 2021-04-27 | Motley | Texas | 48345 | 115 | 8 |
1260857 | 1260857 | 2021-04-26 | Motley | Texas | 48345 | 108 | 8 |
1257610 | 1257610 | 2021-04-25 | Motley | Texas | 48345 | 108 | 8 |
1254363 | 1254363 | 2021-04-24 | Motley | Texas | 48345 | 108 | 8 |
1251116 | 1251116 | 2021-04-23 | Motley | Texas | 48345 | 108 | 8 |
1247869 | 1247869 | 2021-04-22 | Motley | Texas | 48345 | 108 | 8 |
1244622 | 1244622 | 2021-04-21 | Motley | Texas | 48345 | 106 | 8 |
1241375 | 1241375 | 2021-04-20 | Motley | Texas | 48345 | 106 | 8 |
1238128 | 1238128 | 2021-04-19 | Motley | Texas | 48345 | 106 | 8 |
1234881 | 1234881 | 2021-04-18 | Motley | Texas | 48345 | 106 | 8 |
1231633 | 1231633 | 2021-04-17 | Motley | Texas | 48345 | 106 | 8 |
1228385 | 1228385 | 2021-04-16 | Motley | Texas | 48345 | 104 | 8 |
1225137 | 1225137 | 2021-04-15 | Motley | Texas | 48345 | 103 | 8 |
1221890 | 1221890 | 2021-04-14 | Motley | Texas | 48345 | 103 | 8 |
1218642 | 1218642 | 2021-04-13 | Motley | Texas | 48345 | 102 | 8 |
1215394 | 1215394 | 2021-04-12 | Motley | Texas | 48345 | 98 | 8 |
1212147 | 1212147 | 2021-04-11 | Motley | Texas | 48345 | 98 | 8 |
1208898 | 1208898 | 2021-04-10 | Motley | Texas | 48345 | 98 | 8 |
1205650 | 1205650 | 2021-04-09 | Motley | Texas | 48345 | 94 | 8 |
1202402 | 1202402 | 2021-04-08 | Motley | Texas | 48345 | 93 | 8 |
1199153 | 1199153 | 2021-04-07 | Motley | Texas | 48345 | 90 | 8 |
1195904 | 1195904 | 2021-04-06 | Motley | Texas | 48345 | 90 | 8 |
1192656 | 1192656 | 2021-04-05 | Motley | Texas | 48345 | 90 | 8 |
1189407 | 1189407 | 2021-04-04 | Motley | Texas | 48345 | 90 | 8 |
1186160 | 1186160 | 2021-04-03 | Motley | Texas | 48345 | 90 | 8 |
1182913 | 1182913 | 2021-04-02 | Motley | Texas | 48345 | 90 | 8 |
1179666 | 1179666 | 2021-04-01 | Motley | Texas | 48345 | 90 | 8 |
1176419 | 1176419 | 2021-03-31 | Motley | Texas | 48345 | 90 | 8 |
1173172 | 1173172 | 2021-03-30 | Motley | Texas | 48345 | 90 | 8 |
1169925 | 1169925 | 2021-03-29 | Motley | Texas | 48345 | 90 | 8 |
1166677 | 1166677 | 2021-03-28 | Motley | Texas | 48345 | 90 | 8 |
1163429 | 1163429 | 2021-03-27 | Motley | Texas | 48345 | 90 | 8 |
1160180 | 1160180 | 2021-03-26 | Motley | Texas | 48345 | 89 | 8 |
1156933 | 1156933 | 2021-03-25 | Motley | Texas | 48345 | 88 | 8 |
1153686 | 1153686 | 2021-03-24 | Motley | Texas | 48345 | 88 | 8 |
1150439 | 1150439 | 2021-03-23 | Motley | Texas | 48345 | 87 | 8 |
1147192 | 1147192 | 2021-03-22 | Motley | Texas | 48345 | 86 | 8 |
1143945 | 1143945 | 2021-03-21 | Motley | Texas | 48345 | 86 | 8 |
1140698 | 1140698 | 2021-03-20 | Motley | Texas | 48345 | 86 | 8 |
1137452 | 1137452 | 2021-03-19 | Motley | Texas | 48345 | 86 | 8 |
1134206 | 1134206 | 2021-03-18 | Motley | Texas | 48345 | 85 | 8 |
1130958 | 1130958 | 2021-03-17 | Motley | Texas | 48345 | 85 | 8 |
1127711 | 1127711 | 2021-03-16 | Motley | Texas | 48345 | 85 | 8 |
1124465 | 1124465 | 2021-03-15 | Motley | Texas | 48345 | 85 | 8 |
1121219 | 1121219 | 2021-03-14 | Motley | Texas | 48345 | 85 | 8 |
1117972 | 1117972 | 2021-03-13 | Motley | Texas | 48345 | 85 | 8 |
1114725 | 1114725 | 2021-03-12 | Motley | Texas | 48345 | 85 | 8 |
1111479 | 1111479 | 2021-03-11 | Motley | Texas | 48345 | 85 | 8 |
1108233 | 1108233 | 2021-03-10 | Motley | Texas | 48345 | 85 | 8 |
1104987 | 1104987 | 2021-03-09 | Motley | Texas | 48345 | 85 | 8 |
1101741 | 1101741 | 2021-03-08 | Motley | Texas | 48345 | 85 | 8 |
1098495 | 1098495 | 2021-03-07 | Motley | Texas | 48345 | 85 | 8 |
1095247 | 1095247 | 2021-03-06 | Motley | Texas | 48345 | 85 | 8 |
1092001 | 1092001 | 2021-03-05 | Motley | Texas | 48345 | 85 | 8 |
1088755 | 1088755 | 2021-03-04 | Motley | Texas | 48345 | 85 | 8 |
1085510 | 1085510 | 2021-03-03 | Motley | Texas | 48345 | 85 | 8 |
1082264 | 1082264 | 2021-03-02 | Motley | Texas | 48345 | 85 | 8 |
1079018 | 1079018 | 2021-03-01 | Motley | Texas | 48345 | 85 | 8 |
1075773 | 1075773 | 2021-02-28 | Motley | Texas | 48345 | 85 | 8 |
1072527 | 1072527 | 2021-02-27 | Motley | Texas | 48345 | 85 | 8 |
1069281 | 1069281 | 2021-02-26 | Motley | Texas | 48345 | 85 | 8 |
1066036 | 1066036 | 2021-02-25 | Motley | Texas | 48345 | 85 | 8 |
1062791 | 1062791 | 2021-02-24 | Motley | Texas | 48345 | 85 | 7 |
1059546 | 1059546 | 2021-02-23 | Motley | Texas | 48345 | 85 | 7 |
1056300 | 1056300 | 2021-02-22 | Motley | Texas | 48345 | 85 | 7 |
1053054 | 1053054 | 2021-02-21 | Motley | Texas | 48345 | 85 | 7 |
1049807 | 1049807 | 2021-02-20 | Motley | Texas | 48345 | 85 | 7 |
1046560 | 1046560 | 2021-02-19 | Motley | Texas | 48345 | 83 | 7 |
1043315 | 1043315 | 2021-02-18 | Motley | Texas | 48345 | 83 | 7 |
1040070 | 1040070 | 2021-02-17 | Motley | Texas | 48345 | 83 | 7 |
1036825 | 1036825 | 2021-02-16 | Motley | Texas | 48345 | 83 | 7 |
1033580 | 1033580 | 2021-02-15 | Motley | Texas | 48345 | 83 | 7 |
1030334 | 1030334 | 2021-02-14 | Motley | Texas | 48345 | 83 | 7 |
1027087 | 1027087 | 2021-02-13 | Motley | Texas | 48345 | 83 | 7 |
1023842 | 1023842 | 2021-02-12 | Motley | Texas | 48345 | 83 | 7 |
1020597 | 1020597 | 2021-02-11 | Motley | Texas | 48345 | 83 | 7 |
1017352 | 1017352 | 2021-02-10 | Motley | Texas | 48345 | 83 | 7 |
1014107 | 1014107 | 2021-02-09 | Motley | Texas | 48345 | 80 | 7 |
1010862 | 1010862 | 2021-02-08 | Motley | Texas | 48345 | 80 | 7 |
1007616 | 1007616 | 2021-02-07 | Motley | Texas | 48345 | 80 | 7 |
1004370 | 1004370 | 2021-02-06 | Motley | Texas | 48345 | 80 | 7 |
1001124 | 1001124 | 2021-02-05 | Motley | Texas | 48345 | 80 | 7 |
997878 | 997878 | 2021-02-04 | Motley | Texas | 48345 | 80 | 7 |
994632 | 994632 | 2021-02-03 | Motley | Texas | 48345 | 80 | 7 |
991386 | 991386 | 2021-02-02 | Motley | Texas | 48345 | 80 | 7 |
988140 | 988140 | 2021-02-01 | Motley | Texas | 48345 | 80 | 7 |
984893 | 984893 | 2021-01-31 | Motley | Texas | 48345 | 80 | 7 |
981646 | 981646 | 2021-01-30 | Motley | Texas | 48345 | 80 | 7 |
978400 | 978400 | 2021-01-29 | Motley | Texas | 48345 | 80 | 7 |
975155 | 975155 | 2021-01-28 | Motley | Texas | 48345 | 80 | 7 |
971910 | 971910 | 2021-01-27 | Motley | Texas | 48345 | 80 | 7 |
968665 | 968665 | 2021-01-26 | Motley | Texas | 48345 | 80 | 7 |
965421 | 965421 | 2021-01-25 | Motley | Texas | 48345 | 80 | 7 |
962176 | 962176 | 2021-01-24 | Motley | Texas | 48345 | 80 | 7 |
958931 | 958931 | 2021-01-23 | Motley | Texas | 48345 | 80 | 7 |
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);