ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
754 rows where county = "Hartley" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502309 | 2502309 | 2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 |
2499051 | 2499051 | 2022-05-12 | Hartley | Texas | 48205 | 1364 | 3 |
2495793 | 2495793 | 2022-05-11 | Hartley | Texas | 48205 | 1364 | 3 |
2492535 | 2492535 | 2022-05-10 | Hartley | Texas | 48205 | 1364 | 3 |
2489277 | 2489277 | 2022-05-09 | Hartley | Texas | 48205 | 1364 | 3 |
2486020 | 2486020 | 2022-05-08 | Hartley | Texas | 48205 | 1364 | 3 |
2482762 | 2482762 | 2022-05-07 | Hartley | Texas | 48205 | 1364 | 3 |
2479504 | 2479504 | 2022-05-06 | Hartley | Texas | 48205 | 1364 | 3 |
2476246 | 2476246 | 2022-05-05 | Hartley | Texas | 48205 | 1364 | 3 |
2472989 | 2472989 | 2022-05-04 | Hartley | Texas | 48205 | 1364 | 3 |
2469733 | 2469733 | 2022-05-03 | Hartley | Texas | 48205 | 1364 | 3 |
2466477 | 2466477 | 2022-05-02 | Hartley | Texas | 48205 | 1364 | 3 |
2463222 | 2463222 | 2022-05-01 | Hartley | Texas | 48205 | 1364 | 3 |
2459966 | 2459966 | 2022-04-30 | Hartley | Texas | 48205 | 1364 | 3 |
2456710 | 2456710 | 2022-04-29 | Hartley | Texas | 48205 | 1364 | 3 |
2453454 | 2453454 | 2022-04-28 | Hartley | Texas | 48205 | 1364 | 3 |
2450198 | 2450198 | 2022-04-27 | Hartley | Texas | 48205 | 1364 | 3 |
2446941 | 2446941 | 2022-04-26 | Hartley | Texas | 48205 | 1364 | 3 |
2443686 | 2443686 | 2022-04-25 | Hartley | Texas | 48205 | 1364 | 3 |
2440430 | 2440430 | 2022-04-24 | Hartley | Texas | 48205 | 1364 | 3 |
2437174 | 2437174 | 2022-04-23 | Hartley | Texas | 48205 | 1364 | 3 |
2433918 | 2433918 | 2022-04-22 | Hartley | Texas | 48205 | 1363 | 3 |
2430662 | 2430662 | 2022-04-21 | Hartley | Texas | 48205 | 1360 | 3 |
2427406 | 2427406 | 2022-04-20 | Hartley | Texas | 48205 | 1359 | 3 |
2424150 | 2424150 | 2022-04-19 | Hartley | Texas | 48205 | 1356 | 3 |
2420894 | 2420894 | 2022-04-18 | Hartley | Texas | 48205 | 1356 | 3 |
2417638 | 2417638 | 2022-04-17 | Hartley | Texas | 48205 | 1356 | 3 |
2414382 | 2414382 | 2022-04-16 | Hartley | Texas | 48205 | 1356 | 3 |
2411126 | 2411126 | 2022-04-15 | Hartley | Texas | 48205 | 1356 | 3 |
2407870 | 2407870 | 2022-04-14 | Hartley | Texas | 48205 | 1356 | 3 |
2404614 | 2404614 | 2022-04-13 | Hartley | Texas | 48205 | 1355 | 3 |
2401359 | 2401359 | 2022-04-12 | Hartley | Texas | 48205 | 1355 | 3 |
2398104 | 2398104 | 2022-04-11 | Hartley | Texas | 48205 | 1355 | 3 |
2394849 | 2394849 | 2022-04-10 | Hartley | Texas | 48205 | 1355 | 3 |
2391593 | 2391593 | 2022-04-09 | Hartley | Texas | 48205 | 1355 | 3 |
2388337 | 2388337 | 2022-04-08 | Hartley | Texas | 48205 | 1355 | 3 |
2385082 | 2385082 | 2022-04-07 | Hartley | Texas | 48205 | 1355 | 3 |
2381827 | 2381827 | 2022-04-06 | Hartley | Texas | 48205 | 1355 | 3 |
2378572 | 2378572 | 2022-04-05 | Hartley | Texas | 48205 | 1355 | 3 |
2375318 | 2375318 | 2022-04-04 | Hartley | Texas | 48205 | 1355 | 3 |
2372066 | 2372066 | 2022-04-03 | Hartley | Texas | 48205 | 1355 | 3 |
2368813 | 2368813 | 2022-04-02 | Hartley | Texas | 48205 | 1355 | 3 |
2365560 | 2365560 | 2022-04-01 | Hartley | Texas | 48205 | 1355 | 3 |
2362307 | 2362307 | 2022-03-31 | Hartley | Texas | 48205 | 1355 | 3 |
2359053 | 2359053 | 2022-03-30 | Hartley | Texas | 48205 | 1354 | 3 |
2355799 | 2355799 | 2022-03-29 | Hartley | Texas | 48205 | 1354 | 3 |
2352546 | 2352546 | 2022-03-28 | Hartley | Texas | 48205 | 1354 | 3 |
2349294 | 2349294 | 2022-03-27 | Hartley | Texas | 48205 | 1354 | 3 |
2346041 | 2346041 | 2022-03-26 | Hartley | Texas | 48205 | 1354 | 3 |
2342788 | 2342788 | 2022-03-25 | Hartley | Texas | 48205 | 1354 | 3 |
2339535 | 2339535 | 2022-03-24 | Hartley | Texas | 48205 | 1354 | 3 |
2336281 | 2336281 | 2022-03-23 | Hartley | Texas | 48205 | 1354 | 3 |
2333027 | 2333027 | 2022-03-22 | Hartley | Texas | 48205 | 1354 | 3 |
2329774 | 2329774 | 2022-03-21 | Hartley | Texas | 48205 | 1354 | 3 |
2326522 | 2326522 | 2022-03-20 | Hartley | Texas | 48205 | 1354 | 3 |
2323269 | 2323269 | 2022-03-19 | Hartley | Texas | 48205 | 1354 | 3 |
2320015 | 2320015 | 2022-03-18 | Hartley | Texas | 48205 | 1354 | 3 |
2316761 | 2316761 | 2022-03-17 | Hartley | Texas | 48205 | 1353 | 3 |
2313508 | 2313508 | 2022-03-16 | Hartley | Texas | 48205 | 1348 | 3 |
2310255 | 2310255 | 2022-03-15 | Hartley | Texas | 48205 | 1348 | 3 |
2307002 | 2307002 | 2022-03-14 | Hartley | Texas | 48205 | 1346 | 3 |
2303751 | 2303751 | 2022-03-13 | Hartley | Texas | 48205 | 1346 | 3 |
2300499 | 2300499 | 2022-03-12 | Hartley | Texas | 48205 | 1346 | 3 |
2297247 | 2297247 | 2022-03-11 | Hartley | Texas | 48205 | 1343 | 3 |
2293995 | 2293995 | 2022-03-10 | Hartley | Texas | 48205 | 1341 | 3 |
2290743 | 2290743 | 2022-03-09 | Hartley | Texas | 48205 | 1339 | 3 |
2287491 | 2287491 | 2022-03-08 | Hartley | Texas | 48205 | 1336 | 3 |
2284239 | 2284239 | 2022-03-07 | Hartley | Texas | 48205 | 1335 | 3 |
2280987 | 2280987 | 2022-03-06 | Hartley | Texas | 48205 | 1335 | 3 |
2277734 | 2277734 | 2022-03-05 | Hartley | Texas | 48205 | 1335 | 3 |
2274481 | 2274481 | 2022-03-04 | Hartley | Texas | 48205 | 1332 | 3 |
2271228 | 2271228 | 2022-03-03 | Hartley | Texas | 48205 | 1332 | 3 |
2267976 | 2267976 | 2022-03-02 | Hartley | Texas | 48205 | 1332 | 3 |
2264723 | 2264723 | 2022-03-01 | Hartley | Texas | 48205 | 1332 | 3 |
2261473 | 2261473 | 2022-02-28 | Hartley | Texas | 48205 | 1329 | 3 |
2258222 | 2258222 | 2022-02-27 | Hartley | Texas | 48205 | 1329 | 3 |
2254971 | 2254971 | 2022-02-26 | Hartley | Texas | 48205 | 1329 | 3 |
2251720 | 2251720 | 2022-02-25 | Hartley | Texas | 48205 | 1326 | 3 |
2248469 | 2248469 | 2022-02-24 | Hartley | Texas | 48205 | 1326 | 3 |
2245218 | 2245218 | 2022-02-23 | Hartley | Texas | 48205 | 1323 | 3 |
2241967 | 2241967 | 2022-02-22 | Hartley | Texas | 48205 | 1317 | 3 |
2238716 | 2238716 | 2022-02-21 | Hartley | Texas | 48205 | 1317 | 3 |
2235465 | 2235465 | 2022-02-20 | Hartley | Texas | 48205 | 1317 | 3 |
2232214 | 2232214 | 2022-02-19 | Hartley | Texas | 48205 | 1317 | 3 |
2228963 | 2228963 | 2022-02-18 | Hartley | Texas | 48205 | 1316 | 3 |
2225712 | 2225712 | 2022-02-17 | Hartley | Texas | 48205 | 1315 | 3 |
2222461 | 2222461 | 2022-02-16 | Hartley | Texas | 48205 | 1309 | 3 |
2219210 | 2219210 | 2022-02-15 | Hartley | Texas | 48205 | 1295 | 3 |
2215959 | 2215959 | 2022-02-14 | Hartley | Texas | 48205 | 1284 | 3 |
2212708 | 2212708 | 2022-02-13 | Hartley | Texas | 48205 | 1284 | 3 |
2209455 | 2209455 | 2022-02-12 | Hartley | Texas | 48205 | 1284 | 3 |
2206202 | 2206202 | 2022-02-11 | Hartley | Texas | 48205 | 1280 | 3 |
2202949 | 2202949 | 2022-02-10 | Hartley | Texas | 48205 | 1277 | 3 |
2199695 | 2199695 | 2022-02-09 | Hartley | Texas | 48205 | 1273 | 3 |
2196441 | 2196441 | 2022-02-08 | Hartley | Texas | 48205 | 1267 | 3 |
2193187 | 2193187 | 2022-02-07 | Hartley | Texas | 48205 | 1256 | 3 |
2189933 | 2189933 | 2022-02-06 | Hartley | Texas | 48205 | 1255 | 3 |
2186680 | 2186680 | 2022-02-05 | Hartley | Texas | 48205 | 1254 | 3 |
2183428 | 2183428 | 2022-02-04 | Hartley | Texas | 48205 | 1251 | 3 |
2180176 | 2180176 | 2022-02-03 | Hartley | Texas | 48205 | 1240 | 3 |
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);