ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
406 rows where deaths = 87 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Wilbarger 43
- Waller 35
- Lamb 24
- Coryell 20
- Llano 14
- Deaf Smith 12
- Jones 12
- Lampasas 11
- Gonzales 10
- Scurry 10
- Willacy 9
- Kerr 8
- Bowie 7
- Cass 7
- Houston 7
- Young 7
- DeWitt 6
- Jasper 6
- Polk 6
- Sabine 6
- San Jacinto 6
- Guadalupe 5
- Kaufman 5
- Medina 5
- Montague 5
- Tyler 5
- Val Verde 5
- Wharton 5
- Caldwell 4
- Eastland 4
- …
state 1
- Texas · 406 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502451 | 2502451 | 2022-05-13 | Wilbarger | Texas | 48487 | 3486 | 87 |
2499193 | 2499193 | 2022-05-12 | Wilbarger | Texas | 48487 | 3486 | 87 |
2495935 | 2495935 | 2022-05-11 | Wilbarger | Texas | 48487 | 3483 | 87 |
2492677 | 2492677 | 2022-05-10 | Wilbarger | Texas | 48487 | 3481 | 87 |
2489419 | 2489419 | 2022-05-09 | Wilbarger | Texas | 48487 | 3481 | 87 |
2486161 | 2486161 | 2022-05-08 | Wilbarger | Texas | 48487 | 3481 | 87 |
2482903 | 2482903 | 2022-05-07 | Wilbarger | Texas | 48487 | 3481 | 87 |
2479645 | 2479645 | 2022-05-06 | Wilbarger | Texas | 48487 | 3479 | 87 |
2476387 | 2476387 | 2022-05-05 | Wilbarger | Texas | 48487 | 3478 | 87 |
2473130 | 2473130 | 2022-05-04 | Wilbarger | Texas | 48487 | 3473 | 87 |
2469874 | 2469874 | 2022-05-03 | Wilbarger | Texas | 48487 | 3471 | 87 |
2466618 | 2466618 | 2022-05-02 | Wilbarger | Texas | 48487 | 3471 | 87 |
2463363 | 2463363 | 2022-05-01 | Wilbarger | Texas | 48487 | 3471 | 87 |
2460107 | 2460107 | 2022-04-30 | Wilbarger | Texas | 48487 | 3471 | 87 |
2456851 | 2456851 | 2022-04-29 | Wilbarger | Texas | 48487 | 3471 | 87 |
2453595 | 2453595 | 2022-04-28 | Wilbarger | Texas | 48487 | 3468 | 87 |
2450339 | 2450339 | 2022-04-27 | Wilbarger | Texas | 48487 | 3465 | 87 |
2447082 | 2447082 | 2022-04-26 | Wilbarger | Texas | 48487 | 3465 | 87 |
2443827 | 2443827 | 2022-04-25 | Wilbarger | Texas | 48487 | 3464 | 87 |
2440571 | 2440571 | 2022-04-24 | Wilbarger | Texas | 48487 | 3464 | 87 |
2437315 | 2437315 | 2022-04-23 | Wilbarger | Texas | 48487 | 3463 | 87 |
2434059 | 2434059 | 2022-04-22 | Wilbarger | Texas | 48487 | 3462 | 87 |
2430803 | 2430803 | 2022-04-21 | Wilbarger | Texas | 48487 | 3461 | 87 |
2427547 | 2427547 | 2022-04-20 | Wilbarger | Texas | 48487 | 3459 | 87 |
2424291 | 2424291 | 2022-04-19 | Wilbarger | Texas | 48487 | 3459 | 87 |
2421020 | 2421020 | 2022-04-18 | Tyler | Texas | 48457 | 3387 | 87 |
2421035 | 2421035 | 2022-04-18 | Wilbarger | Texas | 48487 | 3458 | 87 |
2417764 | 2417764 | 2022-04-17 | Tyler | Texas | 48457 | 3387 | 87 |
2417779 | 2417779 | 2022-04-17 | Wilbarger | Texas | 48487 | 3456 | 87 |
2414508 | 2414508 | 2022-04-16 | Tyler | Texas | 48457 | 3387 | 87 |
2414523 | 2414523 | 2022-04-16 | Wilbarger | Texas | 48487 | 3456 | 87 |
2411252 | 2411252 | 2022-04-15 | Tyler | Texas | 48457 | 3387 | 87 |
2411267 | 2411267 | 2022-04-15 | Wilbarger | Texas | 48487 | 3456 | 87 |
2407996 | 2407996 | 2022-04-14 | Tyler | Texas | 48457 | 3387 | 87 |
2408011 | 2408011 | 2022-04-14 | Wilbarger | Texas | 48487 | 3456 | 87 |
2404755 | 2404755 | 2022-04-13 | Wilbarger | Texas | 48487 | 3456 | 87 |
2401500 | 2401500 | 2022-04-12 | Wilbarger | Texas | 48487 | 3455 | 87 |
2398245 | 2398245 | 2022-04-11 | Wilbarger | Texas | 48487 | 3455 | 87 |
2394990 | 2394990 | 2022-04-10 | Wilbarger | Texas | 48487 | 3455 | 87 |
2391734 | 2391734 | 2022-04-09 | Wilbarger | Texas | 48487 | 3455 | 87 |
2388478 | 2388478 | 2022-04-08 | Wilbarger | Texas | 48487 | 3455 | 87 |
2385223 | 2385223 | 2022-04-07 | Wilbarger | Texas | 48487 | 3455 | 87 |
2381968 | 2381968 | 2022-04-06 | Wilbarger | Texas | 48487 | 3455 | 87 |
2378713 | 2378713 | 2022-04-05 | Wilbarger | Texas | 48487 | 3454 | 87 |
2375459 | 2375459 | 2022-04-04 | Wilbarger | Texas | 48487 | 3453 | 87 |
2372207 | 2372207 | 2022-04-03 | Wilbarger | Texas | 48487 | 3453 | 87 |
2368954 | 2368954 | 2022-04-02 | Wilbarger | Texas | 48487 | 3453 | 87 |
2365701 | 2365701 | 2022-04-01 | Wilbarger | Texas | 48487 | 3451 | 87 |
2290842 | 2290842 | 2022-03-09 | Sabine | Texas | 48403 | 1231 | 87 |
2287530 | 2287530 | 2022-03-08 | Lampasas | Texas | 48281 | 5504 | 87 |
2287590 | 2287590 | 2022-03-08 | Sabine | Texas | 48403 | 1231 | 87 |
2284278 | 2284278 | 2022-03-07 | Lampasas | Texas | 48281 | 5502 | 87 |
2284338 | 2284338 | 2022-03-07 | Sabine | Texas | 48403 | 1230 | 87 |
2281026 | 2281026 | 2022-03-06 | Lampasas | Texas | 48281 | 5496 | 87 |
2281086 | 2281086 | 2022-03-06 | Sabine | Texas | 48403 | 1229 | 87 |
2277773 | 2277773 | 2022-03-05 | Lampasas | Texas | 48281 | 5496 | 87 |
2277833 | 2277833 | 2022-03-05 | Sabine | Texas | 48403 | 1229 | 87 |
2274520 | 2274520 | 2022-03-04 | Lampasas | Texas | 48281 | 5494 | 87 |
2274580 | 2274580 | 2022-03-04 | Sabine | Texas | 48403 | 1229 | 87 |
2271267 | 2271267 | 2022-03-03 | Lampasas | Texas | 48281 | 5483 | 87 |
2268015 | 2268015 | 2022-03-02 | Lampasas | Texas | 48281 | 5482 | 87 |
2268125 | 2268125 | 2022-03-02 | Young | Texas | 48503 | 3870 | 87 |
2264762 | 2264762 | 2022-03-01 | Lampasas | Texas | 48281 | 5482 | 87 |
2264872 | 2264872 | 2022-03-01 | Young | Texas | 48503 | 3866 | 87 |
2261512 | 2261512 | 2022-02-28 | Lampasas | Texas | 48281 | 5481 | 87 |
2261622 | 2261622 | 2022-02-28 | Young | Texas | 48503 | 3859 | 87 |
2258261 | 2258261 | 2022-02-27 | Lampasas | Texas | 48281 | 5480 | 87 |
2258371 | 2258371 | 2022-02-27 | Young | Texas | 48503 | 3859 | 87 |
2255010 | 2255010 | 2022-02-26 | Lampasas | Texas | 48281 | 5479 | 87 |
2255120 | 2255120 | 2022-02-26 | Young | Texas | 48503 | 3859 | 87 |
2251869 | 2251869 | 2022-02-25 | Young | Texas | 48503 | 3857 | 87 |
2248618 | 2248618 | 2022-02-24 | Young | Texas | 48503 | 3852 | 87 |
2242009 | 2242009 | 2022-02-22 | Leon | Texas | 48289 | 3656 | 87 |
2238695 | 2238695 | 2022-02-21 | Frio | Texas | 48163 | 5497 | 87 |
2238740 | 2238740 | 2022-02-21 | Jones | Texas | 48253 | 4444 | 87 |
2238758 | 2238758 | 2022-02-21 | Leon | Texas | 48289 | 3656 | 87 |
2235444 | 2235444 | 2022-02-20 | Frio | Texas | 48163 | 5484 | 87 |
2235489 | 2235489 | 2022-02-20 | Jones | Texas | 48253 | 4444 | 87 |
2235507 | 2235507 | 2022-02-20 | Leon | Texas | 48289 | 3655 | 87 |
2232238 | 2232238 | 2022-02-19 | Jones | Texas | 48253 | 4444 | 87 |
2228987 | 2228987 | 2022-02-18 | Jones | Texas | 48253 | 4444 | 87 |
2225736 | 2225736 | 2022-02-17 | Jones | Texas | 48253 | 4439 | 87 |
2222485 | 2222485 | 2022-02-16 | Jones | Texas | 48253 | 4437 | 87 |
2219234 | 2219234 | 2022-02-15 | Jones | Texas | 48253 | 4433 | 87 |
2215983 | 2215983 | 2022-02-14 | Jones | Texas | 48253 | 4424 | 87 |
2212732 | 2212732 | 2022-02-13 | Jones | Texas | 48253 | 4420 | 87 |
2209479 | 2209479 | 2022-02-12 | Jones | Texas | 48253 | 4415 | 87 |
2206226 | 2206226 | 2022-02-11 | Jones | Texas | 48253 | 4413 | 87 |
2202973 | 2202973 | 2022-02-10 | Jones | Texas | 48253 | 4392 | 87 |
2193143 | 2193143 | 2022-02-07 | DeWitt | Texas | 48123 | 6321 | 87 |
2189889 | 2189889 | 2022-02-06 | DeWitt | Texas | 48123 | 6311 | 87 |
2186636 | 2186636 | 2022-02-05 | DeWitt | Texas | 48123 | 6302 | 87 |
2183384 | 2183384 | 2022-02-04 | DeWitt | Texas | 48123 | 6293 | 87 |
2180132 | 2180132 | 2022-02-03 | DeWitt | Texas | 48123 | 6285 | 87 |
2176881 | 2176881 | 2022-02-02 | DeWitt | Texas | 48123 | 6272 | 87 |
2160610 | 2160610 | 2022-01-28 | Dawson | Texas | 48115 | 2401 | 87 |
2157446 | 2157446 | 2022-01-27 | Llano | Texas | 48299 | 3543 | 87 |
2154193 | 2154193 | 2022-01-26 | Llano | Texas | 48299 | 3525 | 87 |
2150941 | 2150941 | 2022-01-25 | Llano | Texas | 48299 | 3503 | 87 |
2150995 | 2150995 | 2022-01-25 | San Jacinto | Texas | 48407 | 4768 | 87 |
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);