ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
807 rows where deaths = 68 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Deaf Smith 96
- Dawson 84
- Zavala 62
- Robertson 42
- Wilson 40
- Erath 28
- Duval 27
- Karnes 27
- Lampasas 18
- Moore 17
- Camp 13
- Ellis 13
- Palo Pinto 13
- Montague 12
- Morris 12
- Bee 10
- Hutchinson 9
- Lamb 9
- Scurry 9
- Terry 9
- Llano 8
- Shelby 8
- Wilbarger 8
- Andrews 7
- Burnet 7
- Caldwell 7
- Gaines 7
- Lavaca 7
- Limestone 7
- Nacogdoches 7
- …
state 1
- Texas · 807 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502461 | 2502461 | 2022-05-13 | Zavala | Texas | 48507 | 4059 | 68 |
2499203 | 2499203 | 2022-05-12 | Zavala | Texas | 48507 | 4059 | 68 |
2495945 | 2495945 | 2022-05-11 | Zavala | Texas | 48507 | 4058 | 68 |
2492687 | 2492687 | 2022-05-10 | Zavala | Texas | 48507 | 4058 | 68 |
2489429 | 2489429 | 2022-05-09 | Zavala | Texas | 48507 | 4056 | 68 |
2486171 | 2486171 | 2022-05-08 | Zavala | Texas | 48507 | 4055 | 68 |
2482913 | 2482913 | 2022-05-07 | Zavala | Texas | 48507 | 4055 | 68 |
2479655 | 2479655 | 2022-05-06 | Zavala | Texas | 48507 | 4054 | 68 |
2476397 | 2476397 | 2022-05-05 | Zavala | Texas | 48507 | 4053 | 68 |
2473140 | 2473140 | 2022-05-04 | Zavala | Texas | 48507 | 4053 | 68 |
2469884 | 2469884 | 2022-05-03 | Zavala | Texas | 48507 | 4053 | 68 |
2466628 | 2466628 | 2022-05-02 | Zavala | Texas | 48507 | 4052 | 68 |
2463373 | 2463373 | 2022-05-01 | Zavala | Texas | 48507 | 4052 | 68 |
2460117 | 2460117 | 2022-04-30 | Zavala | Texas | 48507 | 4052 | 68 |
2456861 | 2456861 | 2022-04-29 | Zavala | Texas | 48507 | 4052 | 68 |
2453605 | 2453605 | 2022-04-28 | Zavala | Texas | 48507 | 4052 | 68 |
2450349 | 2450349 | 2022-04-27 | Zavala | Texas | 48507 | 4051 | 68 |
2447092 | 2447092 | 2022-04-26 | Zavala | Texas | 48507 | 4051 | 68 |
2443837 | 2443837 | 2022-04-25 | Zavala | Texas | 48507 | 4051 | 68 |
2440581 | 2440581 | 2022-04-24 | Zavala | Texas | 48507 | 4051 | 68 |
2437325 | 2437325 | 2022-04-23 | Zavala | Texas | 48507 | 4051 | 68 |
2434069 | 2434069 | 2022-04-22 | Zavala | Texas | 48507 | 4051 | 68 |
2430813 | 2430813 | 2022-04-21 | Zavala | Texas | 48507 | 4051 | 68 |
2427557 | 2427557 | 2022-04-20 | Zavala | Texas | 48507 | 4049 | 68 |
2424301 | 2424301 | 2022-04-19 | Zavala | Texas | 48507 | 4048 | 68 |
2421045 | 2421045 | 2022-04-18 | Zavala | Texas | 48507 | 4047 | 68 |
2417789 | 2417789 | 2022-04-17 | Zavala | Texas | 48507 | 4046 | 68 |
2414533 | 2414533 | 2022-04-16 | Zavala | Texas | 48507 | 4046 | 68 |
2411277 | 2411277 | 2022-04-15 | Zavala | Texas | 48507 | 4046 | 68 |
2408021 | 2408021 | 2022-04-14 | Zavala | Texas | 48507 | 4046 | 68 |
2404765 | 2404765 | 2022-04-13 | Zavala | Texas | 48507 | 4044 | 68 |
2401510 | 2401510 | 2022-04-12 | Zavala | Texas | 48507 | 4044 | 68 |
2398255 | 2398255 | 2022-04-11 | Zavala | Texas | 48507 | 4043 | 68 |
2395000 | 2395000 | 2022-04-10 | Zavala | Texas | 48507 | 4043 | 68 |
2391744 | 2391744 | 2022-04-09 | Zavala | Texas | 48507 | 4043 | 68 |
2388488 | 2388488 | 2022-04-08 | Zavala | Texas | 48507 | 4043 | 68 |
2385107 | 2385107 | 2022-04-07 | Karnes | Texas | 48255 | 5706 | 68 |
2385233 | 2385233 | 2022-04-07 | Zavala | Texas | 48507 | 4042 | 68 |
2381852 | 2381852 | 2022-04-06 | Karnes | Texas | 48255 | 5705 | 68 |
2381978 | 2381978 | 2022-04-06 | Zavala | Texas | 48507 | 4041 | 68 |
2378597 | 2378597 | 2022-04-05 | Karnes | Texas | 48255 | 5694 | 68 |
2378723 | 2378723 | 2022-04-05 | Zavala | Texas | 48507 | 4041 | 68 |
2375343 | 2375343 | 2022-04-04 | Karnes | Texas | 48255 | 5674 | 68 |
2375469 | 2375469 | 2022-04-04 | Zavala | Texas | 48507 | 4041 | 68 |
2372091 | 2372091 | 2022-04-03 | Karnes | Texas | 48255 | 5674 | 68 |
2372217 | 2372217 | 2022-04-03 | Zavala | Texas | 48507 | 4041 | 68 |
2368838 | 2368838 | 2022-04-02 | Karnes | Texas | 48255 | 5674 | 68 |
2368964 | 2368964 | 2022-04-02 | Zavala | Texas | 48507 | 4041 | 68 |
2365585 | 2365585 | 2022-04-01 | Karnes | Texas | 48255 | 5674 | 68 |
2365711 | 2365711 | 2022-04-01 | Zavala | Texas | 48507 | 4041 | 68 |
2362332 | 2362332 | 2022-03-31 | Karnes | Texas | 48255 | 5674 | 68 |
2362458 | 2362458 | 2022-03-31 | Zavala | Texas | 48507 | 4039 | 68 |
2359078 | 2359078 | 2022-03-30 | Karnes | Texas | 48255 | 5674 | 68 |
2359204 | 2359204 | 2022-03-30 | Zavala | Texas | 48507 | 4039 | 68 |
2355824 | 2355824 | 2022-03-29 | Karnes | Texas | 48255 | 5669 | 68 |
2355950 | 2355950 | 2022-03-29 | Zavala | Texas | 48507 | 4039 | 68 |
2352571 | 2352571 | 2022-03-28 | Karnes | Texas | 48255 | 5655 | 68 |
2352697 | 2352697 | 2022-03-28 | Zavala | Texas | 48507 | 4039 | 68 |
2349319 | 2349319 | 2022-03-27 | Karnes | Texas | 48255 | 5655 | 68 |
2349445 | 2349445 | 2022-03-27 | Zavala | Texas | 48507 | 4039 | 68 |
2346066 | 2346066 | 2022-03-26 | Karnes | Texas | 48255 | 5655 | 68 |
2346192 | 2346192 | 2022-03-26 | Zavala | Texas | 48507 | 4039 | 68 |
2342813 | 2342813 | 2022-03-25 | Karnes | Texas | 48255 | 5645 | 68 |
2342939 | 2342939 | 2022-03-25 | Zavala | Texas | 48507 | 4039 | 68 |
2339560 | 2339560 | 2022-03-24 | Karnes | Texas | 48255 | 5628 | 68 |
2339686 | 2339686 | 2022-03-24 | Zavala | Texas | 48507 | 4038 | 68 |
2336306 | 2336306 | 2022-03-23 | Karnes | Texas | 48255 | 5616 | 68 |
2336432 | 2336432 | 2022-03-23 | Zavala | Texas | 48507 | 4038 | 68 |
2332990 | 2332990 | 2022-03-22 | Duval | Texas | 48131 | 3327 | 68 |
2333052 | 2333052 | 2022-03-22 | Karnes | Texas | 48255 | 5606 | 68 |
2333178 | 2333178 | 2022-03-22 | Zavala | Texas | 48507 | 4035 | 68 |
2329737 | 2329737 | 2022-03-21 | Duval | Texas | 48131 | 3327 | 68 |
2329799 | 2329799 | 2022-03-21 | Karnes | Texas | 48255 | 5574 | 68 |
2329925 | 2329925 | 2022-03-21 | Zavala | Texas | 48507 | 4035 | 68 |
2326485 | 2326485 | 2022-03-20 | Duval | Texas | 48131 | 3327 | 68 |
2326547 | 2326547 | 2022-03-20 | Karnes | Texas | 48255 | 5574 | 68 |
2326673 | 2326673 | 2022-03-20 | Zavala | Texas | 48507 | 4033 | 68 |
2323232 | 2323232 | 2022-03-19 | Duval | Texas | 48131 | 3326 | 68 |
2323294 | 2323294 | 2022-03-19 | Karnes | Texas | 48255 | 5574 | 68 |
2323420 | 2323420 | 2022-03-19 | Zavala | Texas | 48507 | 4029 | 68 |
2319978 | 2319978 | 2022-03-18 | Duval | Texas | 48131 | 3325 | 68 |
2320040 | 2320040 | 2022-03-18 | Karnes | Texas | 48255 | 5568 | 68 |
2320166 | 2320166 | 2022-03-18 | Zavala | Texas | 48507 | 4029 | 68 |
2316724 | 2316724 | 2022-03-17 | Duval | Texas | 48131 | 3324 | 68 |
2316786 | 2316786 | 2022-03-17 | Karnes | Texas | 48255 | 5568 | 68 |
2316912 | 2316912 | 2022-03-17 | Zavala | Texas | 48507 | 4028 | 68 |
2313471 | 2313471 | 2022-03-16 | Duval | Texas | 48131 | 3324 | 68 |
2313533 | 2313533 | 2022-03-16 | Karnes | Texas | 48255 | 5545 | 68 |
2313659 | 2313659 | 2022-03-16 | Zavala | Texas | 48507 | 4028 | 68 |
2310218 | 2310218 | 2022-03-15 | Duval | Texas | 48131 | 3322 | 68 |
2310280 | 2310280 | 2022-03-15 | Karnes | Texas | 48255 | 5542 | 68 |
2310406 | 2310406 | 2022-03-15 | Zavala | Texas | 48507 | 4028 | 68 |
2306965 | 2306965 | 2022-03-14 | Duval | Texas | 48131 | 3319 | 68 |
2307027 | 2307027 | 2022-03-14 | Karnes | Texas | 48255 | 5541 | 68 |
2307153 | 2307153 | 2022-03-14 | Zavala | Texas | 48507 | 4028 | 68 |
2303714 | 2303714 | 2022-03-13 | Duval | Texas | 48131 | 3318 | 68 |
2303776 | 2303776 | 2022-03-13 | Karnes | Texas | 48255 | 5541 | 68 |
2303902 | 2303902 | 2022-03-13 | Zavala | Texas | 48507 | 4028 | 68 |
2300462 | 2300462 | 2022-03-12 | Duval | Texas | 48131 | 3318 | 68 |
2300524 | 2300524 | 2022-03-12 | Karnes | Texas | 48255 | 5541 | 68 |
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);