ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

772 rows where fips = 48175 and state = "Texas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Texas · 772 ✖

fips 1

  • 48175 · 772 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502294 2502294 2022-05-13 Goliad Texas 48175 1216 32
2499036 2499036 2022-05-12 Goliad Texas 48175 1215 32
2495778 2495778 2022-05-11 Goliad Texas 48175 1215 32
2492520 2492520 2022-05-10 Goliad Texas 48175 1213 32
2489262 2489262 2022-05-09 Goliad Texas 48175 1211 32
2486005 2486005 2022-05-08 Goliad Texas 48175 1210 32
2482747 2482747 2022-05-07 Goliad Texas 48175 1210 32
2479489 2479489 2022-05-06 Goliad Texas 48175 1208 32
2476231 2476231 2022-05-05 Goliad Texas 48175 1207 32
2472974 2472974 2022-05-04 Goliad Texas 48175 1207 32
2469718 2469718 2022-05-03 Goliad Texas 48175 1207 32
2466462 2466462 2022-05-02 Goliad Texas 48175 1206 32
2463207 2463207 2022-05-01 Goliad Texas 48175 1204 32
2459951 2459951 2022-04-30 Goliad Texas 48175 1204 32
2456695 2456695 2022-04-29 Goliad Texas 48175 1204 32
2453439 2453439 2022-04-28 Goliad Texas 48175 1203 32
2450183 2450183 2022-04-27 Goliad Texas 48175 1203 32
2446926 2446926 2022-04-26 Goliad Texas 48175 1203 32
2443671 2443671 2022-04-25 Goliad Texas 48175 1203 32
2440415 2440415 2022-04-24 Goliad Texas 48175 1203 32
2437159 2437159 2022-04-23 Goliad Texas 48175 1203 32
2433903 2433903 2022-04-22 Goliad Texas 48175 1203 32
2430647 2430647 2022-04-21 Goliad Texas 48175 1202 32
2427391 2427391 2022-04-20 Goliad Texas 48175 1202 32
2424135 2424135 2022-04-19 Goliad Texas 48175 1201 32
2420879 2420879 2022-04-18 Goliad Texas 48175 1201 32
2417623 2417623 2022-04-17 Goliad Texas 48175 1200 32
2414367 2414367 2022-04-16 Goliad Texas 48175 1200 32
2411111 2411111 2022-04-15 Goliad Texas 48175 1200 32
2407855 2407855 2022-04-14 Goliad Texas 48175 1200 32
2404599 2404599 2022-04-13 Goliad Texas 48175 1200 32
2401344 2401344 2022-04-12 Goliad Texas 48175 1200 32
2398089 2398089 2022-04-11 Goliad Texas 48175 1200 32
2394834 2394834 2022-04-10 Goliad Texas 48175 1200 32
2391578 2391578 2022-04-09 Goliad Texas 48175 1200 32
2388322 2388322 2022-04-08 Goliad Texas 48175 1200 32
2385067 2385067 2022-04-07 Goliad Texas 48175 1199 32
2381812 2381812 2022-04-06 Goliad Texas 48175 1199 32
2378557 2378557 2022-04-05 Goliad Texas 48175 1198 32
2375303 2375303 2022-04-04 Goliad Texas 48175 1197 32
2372051 2372051 2022-04-03 Goliad Texas 48175 1197 32
2368798 2368798 2022-04-02 Goliad Texas 48175 1197 32
2365545 2365545 2022-04-01 Goliad Texas 48175 1197 32
2362292 2362292 2022-03-31 Goliad Texas 48175 1197 32
2359038 2359038 2022-03-30 Goliad Texas 48175 1197 32
2355784 2355784 2022-03-29 Goliad Texas 48175 1197 32
2352531 2352531 2022-03-28 Goliad Texas 48175 1197 32
2349279 2349279 2022-03-27 Goliad Texas 48175 1197 32
2346026 2346026 2022-03-26 Goliad Texas 48175 1197 32
2342773 2342773 2022-03-25 Goliad Texas 48175 1197 32
2339520 2339520 2022-03-24 Goliad Texas 48175 1197 32
2336266 2336266 2022-03-23 Goliad Texas 48175 1197 32
2333012 2333012 2022-03-22 Goliad Texas 48175 1197 32
2329759 2329759 2022-03-21 Goliad Texas 48175 1191 32
2326507 2326507 2022-03-20 Goliad Texas 48175 1191 32
2323254 2323254 2022-03-19 Goliad Texas 48175 1191 32
2320000 2320000 2022-03-18 Goliad Texas 48175 1189 32
2316746 2316746 2022-03-17 Goliad Texas 48175 1188 32
2313493 2313493 2022-03-16 Goliad Texas 48175 1188 32
2310240 2310240 2022-03-15 Goliad Texas 48175 1188 32
2306987 2306987 2022-03-14 Goliad Texas 48175 1188 32
2303736 2303736 2022-03-13 Goliad Texas 48175 1188 32
2300484 2300484 2022-03-12 Goliad Texas 48175 1188 32
2297232 2297232 2022-03-11 Goliad Texas 48175 1188 32
2293980 2293980 2022-03-10 Goliad Texas 48175 1187 32
2290728 2290728 2022-03-09 Goliad Texas 48175 1187 32
2287476 2287476 2022-03-08 Goliad Texas 48175 1186 32
2284224 2284224 2022-03-07 Goliad Texas 48175 1186 32
2280972 2280972 2022-03-06 Goliad Texas 48175 1185 32
2277719 2277719 2022-03-05 Goliad Texas 48175 1185 32
2274466 2274466 2022-03-04 Goliad Texas 48175 1183 32
2271213 2271213 2022-03-03 Goliad Texas 48175 1181 32
2267961 2267961 2022-03-02 Goliad Texas 48175 1179 32
2264708 2264708 2022-03-01 Goliad Texas 48175 1172 32
2261458 2261458 2022-02-28 Goliad Texas 48175 1170 32
2258207 2258207 2022-02-27 Goliad Texas 48175 1170 32
2254956 2254956 2022-02-26 Goliad Texas 48175 1170 32
2251705 2251705 2022-02-25 Goliad Texas 48175 1167 32
2248454 2248454 2022-02-24 Goliad Texas 48175 1166 31
2245203 2245203 2022-02-23 Goliad Texas 48175 1163 31
2241952 2241952 2022-02-22 Goliad Texas 48175 1161 31
2238701 2238701 2022-02-21 Goliad Texas 48175 1160 31
2235450 2235450 2022-02-20 Goliad Texas 48175 1158 31
2232199 2232199 2022-02-19 Goliad Texas 48175 1156 31
2228948 2228948 2022-02-18 Goliad Texas 48175 1155 31
2225697 2225697 2022-02-17 Goliad Texas 48175 1154 31
2222446 2222446 2022-02-16 Goliad Texas 48175 1152 30
2219195 2219195 2022-02-15 Goliad Texas 48175 1152 30
2215944 2215944 2022-02-14 Goliad Texas 48175 1151 30
2212693 2212693 2022-02-13 Goliad Texas 48175 1148 30
2209440 2209440 2022-02-12 Goliad Texas 48175 1147 30
2206187 2206187 2022-02-11 Goliad Texas 48175 1144 30
2202934 2202934 2022-02-10 Goliad Texas 48175 1141 30
2199680 2199680 2022-02-09 Goliad Texas 48175 1135 29
2196426 2196426 2022-02-08 Goliad Texas 48175 1131 29
2193172 2193172 2022-02-07 Goliad Texas 48175 1127 29
2189918 2189918 2022-02-06 Goliad Texas 48175 1120 29
2186665 2186665 2022-02-05 Goliad Texas 48175 1116 29
2183413 2183413 2022-02-04 Goliad Texas 48175 1113 29
2180161 2180161 2022-02-03 Goliad Texas 48175 1100 29

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);