ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Caldwell" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280194 | 1280194 | 2021-05-02 | Caldwell | Texas | 48055 | 5573 | 96 |
1276947 | 1276947 | 2021-05-01 | Caldwell | Texas | 48055 | 5573 | 96 |
1273700 | 1273700 | 2021-04-30 | Caldwell | Texas | 48055 | 5570 | 96 |
1270453 | 1270453 | 2021-04-29 | Caldwell | Texas | 48055 | 5554 | 96 |
1267206 | 1267206 | 2021-04-28 | Caldwell | Texas | 48055 | 5542 | 96 |
1263959 | 1263959 | 2021-04-27 | Caldwell | Texas | 48055 | 5538 | 96 |
1260712 | 1260712 | 2021-04-26 | Caldwell | Texas | 48055 | 5530 | 96 |
1257465 | 1257465 | 2021-04-25 | Caldwell | Texas | 48055 | 5519 | 96 |
1254218 | 1254218 | 2021-04-24 | Caldwell | Texas | 48055 | 5519 | 96 |
1250971 | 1250971 | 2021-04-23 | Caldwell | Texas | 48055 | 5516 | 96 |
1247724 | 1247724 | 2021-04-22 | Caldwell | Texas | 48055 | 5503 | 96 |
1244477 | 1244477 | 2021-04-21 | Caldwell | Texas | 48055 | 5493 | 96 |
1241230 | 1241230 | 2021-04-20 | Caldwell | Texas | 48055 | 5485 | 96 |
1237983 | 1237983 | 2021-04-19 | Caldwell | Texas | 48055 | 5465 | 95 |
1234736 | 1234736 | 2021-04-18 | Caldwell | Texas | 48055 | 5458 | 95 |
1231488 | 1231488 | 2021-04-17 | Caldwell | Texas | 48055 | 5458 | 95 |
1228240 | 1228240 | 2021-04-16 | Caldwell | Texas | 48055 | 5458 | 95 |
1224992 | 1224992 | 2021-04-15 | Caldwell | Texas | 48055 | 5461 | 95 |
1221745 | 1221745 | 2021-04-14 | Caldwell | Texas | 48055 | 5457 | 95 |
1218497 | 1218497 | 2021-04-13 | Caldwell | Texas | 48055 | 5447 | 95 |
1215249 | 1215249 | 2021-04-12 | Caldwell | Texas | 48055 | 5440 | 95 |
1212002 | 1212002 | 2021-04-11 | Caldwell | Texas | 48055 | 5425 | 95 |
1208753 | 1208753 | 2021-04-10 | Caldwell | Texas | 48055 | 5425 | 95 |
1205505 | 1205505 | 2021-04-09 | Caldwell | Texas | 48055 | 5421 | 95 |
1202257 | 1202257 | 2021-04-08 | Caldwell | Texas | 48055 | 5419 | 94 |
1199008 | 1199008 | 2021-04-07 | Caldwell | Texas | 48055 | 5414 | 94 |
1195759 | 1195759 | 2021-04-06 | Caldwell | Texas | 48055 | 5410 | 94 |
1192511 | 1192511 | 2021-04-05 | Caldwell | Texas | 48055 | 5405 | 93 |
1189262 | 1189262 | 2021-04-04 | Caldwell | Texas | 48055 | 5397 | 93 |
1186015 | 1186015 | 2021-04-03 | Caldwell | Texas | 48055 | 5397 | 93 |
1182768 | 1182768 | 2021-04-02 | Caldwell | Texas | 48055 | 5396 | 93 |
1179521 | 1179521 | 2021-04-01 | Caldwell | Texas | 48055 | 5389 | 92 |
1176274 | 1176274 | 2021-03-31 | Caldwell | Texas | 48055 | 5382 | 92 |
1173027 | 1173027 | 2021-03-30 | Caldwell | Texas | 48055 | 5372 | 92 |
1169780 | 1169780 | 2021-03-29 | Caldwell | Texas | 48055 | 5366 | 92 |
1166532 | 1166532 | 2021-03-28 | Caldwell | Texas | 48055 | 5351 | 92 |
1163284 | 1163284 | 2021-03-27 | Caldwell | Texas | 48055 | 5351 | 92 |
1160035 | 1160035 | 2021-03-26 | Caldwell | Texas | 48055 | 5345 | 92 |
1156788 | 1156788 | 2021-03-25 | Caldwell | Texas | 48055 | 5342 | 92 |
1153541 | 1153541 | 2021-03-24 | Caldwell | Texas | 48055 | 5334 | 92 |
1150294 | 1150294 | 2021-03-23 | Caldwell | Texas | 48055 | 5319 | 92 |
1147047 | 1147047 | 2021-03-22 | Caldwell | Texas | 48055 | 5318 | 92 |
1143800 | 1143800 | 2021-03-21 | Caldwell | Texas | 48055 | 5308 | 92 |
1140553 | 1140553 | 2021-03-20 | Caldwell | Texas | 48055 | 5308 | 92 |
1137307 | 1137307 | 2021-03-19 | Caldwell | Texas | 48055 | 5298 | 92 |
1134061 | 1134061 | 2021-03-18 | Caldwell | Texas | 48055 | 5291 | 92 |
1130813 | 1130813 | 2021-03-17 | Caldwell | Texas | 48055 | 5288 | 91 |
1127566 | 1127566 | 2021-03-16 | Caldwell | Texas | 48055 | 5268 | 91 |
1124320 | 1124320 | 2021-03-15 | Caldwell | Texas | 48055 | 5268 | 90 |
1121074 | 1121074 | 2021-03-14 | Caldwell | Texas | 48055 | 5258 | 90 |
1117827 | 1117827 | 2021-03-13 | Caldwell | Texas | 48055 | 5258 | 90 |
1114580 | 1114580 | 2021-03-12 | Caldwell | Texas | 48055 | 5252 | 90 |
1111334 | 1111334 | 2021-03-11 | Caldwell | Texas | 48055 | 5247 | 89 |
1108088 | 1108088 | 2021-03-10 | Caldwell | Texas | 48055 | 5239 | 89 |
1104842 | 1104842 | 2021-03-09 | Caldwell | Texas | 48055 | 5238 | 89 |
1101596 | 1101596 | 2021-03-08 | Caldwell | Texas | 48055 | 5233 | 89 |
1098350 | 1098350 | 2021-03-07 | Caldwell | Texas | 48055 | 5229 | 89 |
1095102 | 1095102 | 2021-03-06 | Caldwell | Texas | 48055 | 5229 | 88 |
1091856 | 1091856 | 2021-03-05 | Caldwell | Texas | 48055 | 5225 | 87 |
1088610 | 1088610 | 2021-03-04 | Caldwell | Texas | 48055 | 5215 | 87 |
1085365 | 1085365 | 2021-03-03 | Caldwell | Texas | 48055 | 5212 | 87 |
1082119 | 1082119 | 2021-03-02 | Caldwell | Texas | 48055 | 5207 | 87 |
1078873 | 1078873 | 2021-03-01 | Caldwell | Texas | 48055 | 5194 | 85 |
1075628 | 1075628 | 2021-02-28 | Caldwell | Texas | 48055 | 5164 | 85 |
1072382 | 1072382 | 2021-02-27 | Caldwell | Texas | 48055 | 5164 | 85 |
1069136 | 1069136 | 2021-02-26 | Caldwell | Texas | 48055 | 5162 | 84 |
1065891 | 1065891 | 2021-02-25 | Caldwell | Texas | 48055 | 5146 | 82 |
1062646 | 1062646 | 2021-02-24 | Caldwell | Texas | 48055 | 5137 | 82 |
1059401 | 1059401 | 2021-02-23 | Caldwell | Texas | 48055 | 5121 | 80 |
1056155 | 1056155 | 2021-02-22 | Caldwell | Texas | 48055 | 5116 | 80 |
1052909 | 1052909 | 2021-02-21 | Caldwell | Texas | 48055 | 5112 | 80 |
1049662 | 1049662 | 2021-02-20 | Caldwell | Texas | 48055 | 5112 | 79 |
1046415 | 1046415 | 2021-02-19 | Caldwell | Texas | 48055 | 5107 | 74 |
1043170 | 1043170 | 2021-02-18 | Caldwell | Texas | 48055 | 5103 | 73 |
1039925 | 1039925 | 2021-02-17 | Caldwell | Texas | 48055 | 5095 | 73 |
1036680 | 1036680 | 2021-02-16 | Caldwell | Texas | 48055 | 5089 | 73 |
1033435 | 1033435 | 2021-02-15 | Caldwell | Texas | 48055 | 5060 | 73 |
1030189 | 1030189 | 2021-02-14 | Caldwell | Texas | 48055 | 5060 | 73 |
1026942 | 1026942 | 2021-02-13 | Caldwell | Texas | 48055 | 5061 | 73 |
1023697 | 1023697 | 2021-02-12 | Caldwell | Texas | 48055 | 5050 | 71 |
1020452 | 1020452 | 2021-02-11 | Caldwell | Texas | 48055 | 5077 | 70 |
1017207 | 1017207 | 2021-02-10 | Caldwell | Texas | 48055 | 5060 | 69 |
1013962 | 1013962 | 2021-02-09 | Caldwell | Texas | 48055 | 5054 | 68 |
1010717 | 1010717 | 2021-02-08 | Caldwell | Texas | 48055 | 4964 | 68 |
1007471 | 1007471 | 2021-02-07 | Caldwell | Texas | 48055 | 4937 | 68 |
1004225 | 1004225 | 2021-02-06 | Caldwell | Texas | 48055 | 4937 | 68 |
1000979 | 1000979 | 2021-02-05 | Caldwell | Texas | 48055 | 4925 | 68 |
997733 | 997733 | 2021-02-04 | Caldwell | Texas | 48055 | 4910 | 68 |
994487 | 994487 | 2021-02-03 | Caldwell | Texas | 48055 | 4894 | 68 |
991241 | 991241 | 2021-02-02 | Caldwell | Texas | 48055 | 4862 | 67 |
987995 | 987995 | 2021-02-01 | Caldwell | Texas | 48055 | 4740 | 67 |
984748 | 984748 | 2021-01-31 | Caldwell | Texas | 48055 | 2904 | 67 |
981501 | 981501 | 2021-01-30 | Caldwell | Texas | 48055 | 2903 | 67 |
978255 | 978255 | 2021-01-29 | Caldwell | Texas | 48055 | 2891 | 66 |
975010 | 975010 | 2021-01-28 | Caldwell | Texas | 48055 | 2860 | 64 |
971765 | 971765 | 2021-01-27 | Caldwell | Texas | 48055 | 2847 | 61 |
968520 | 968520 | 2021-01-26 | Caldwell | Texas | 48055 | 2829 | 61 |
965276 | 965276 | 2021-01-25 | Caldwell | Texas | 48055 | 2812 | 61 |
962031 | 962031 | 2021-01-24 | Caldwell | Texas | 48055 | 2809 | 61 |
958786 | 958786 | 2021-01-23 | Caldwell | Texas | 48055 | 2809 | 60 |
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);