ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,711 rows where deaths = 18 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Donley 116
- Martin 108
- Aransas 94
- Coke 90
- Swisher 85
- Upton 71
- Hudspeth 54
- Jack 42
- Cochran 41
- Karnes 37
- Red River 35
- Garza 29
- Real 29
- Childress 28
- Knox 24
- Van Zandt 24
- Anderson 21
- Brewster 21
- Fayette 21
- Blanco 20
- Gonzales 20
- Hansford 19
- Shelby 19
- Bailey 18
- Lynn 17
- Crane 16
- Brazos 15
- Clay 15
- Erath 15
- Panola 15
- …
state 1
- Texas · 1,711 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502321 | 2502321 | 2022-05-13 | Hudspeth | Texas | 48229 | 989 | 18 |
2502438 | 2502438 | 2022-05-13 | Upton | Texas | 48461 | 833 | 18 |
2499063 | 2499063 | 2022-05-12 | Hudspeth | Texas | 48229 | 989 | 18 |
2499180 | 2499180 | 2022-05-12 | Upton | Texas | 48461 | 833 | 18 |
2495805 | 2495805 | 2022-05-11 | Hudspeth | Texas | 48229 | 989 | 18 |
2495922 | 2495922 | 2022-05-11 | Upton | Texas | 48461 | 833 | 18 |
2492547 | 2492547 | 2022-05-10 | Hudspeth | Texas | 48229 | 989 | 18 |
2492664 | 2492664 | 2022-05-10 | Upton | Texas | 48461 | 833 | 18 |
2489289 | 2489289 | 2022-05-09 | Hudspeth | Texas | 48229 | 989 | 18 |
2489406 | 2489406 | 2022-05-09 | Upton | Texas | 48461 | 833 | 18 |
2486032 | 2486032 | 2022-05-08 | Hudspeth | Texas | 48229 | 989 | 18 |
2486148 | 2486148 | 2022-05-08 | Upton | Texas | 48461 | 833 | 18 |
2482774 | 2482774 | 2022-05-07 | Hudspeth | Texas | 48229 | 989 | 18 |
2482890 | 2482890 | 2022-05-07 | Upton | Texas | 48461 | 833 | 18 |
2479516 | 2479516 | 2022-05-06 | Hudspeth | Texas | 48229 | 989 | 18 |
2479632 | 2479632 | 2022-05-06 | Upton | Texas | 48461 | 833 | 18 |
2476258 | 2476258 | 2022-05-05 | Hudspeth | Texas | 48229 | 989 | 18 |
2476374 | 2476374 | 2022-05-05 | Upton | Texas | 48461 | 833 | 18 |
2473001 | 2473001 | 2022-05-04 | Hudspeth | Texas | 48229 | 989 | 18 |
2473117 | 2473117 | 2022-05-04 | Upton | Texas | 48461 | 832 | 18 |
2469745 | 2469745 | 2022-05-03 | Hudspeth | Texas | 48229 | 989 | 18 |
2469861 | 2469861 | 2022-05-03 | Upton | Texas | 48461 | 832 | 18 |
2466489 | 2466489 | 2022-05-02 | Hudspeth | Texas | 48229 | 989 | 18 |
2466605 | 2466605 | 2022-05-02 | Upton | Texas | 48461 | 832 | 18 |
2463234 | 2463234 | 2022-05-01 | Hudspeth | Texas | 48229 | 989 | 18 |
2463350 | 2463350 | 2022-05-01 | Upton | Texas | 48461 | 832 | 18 |
2459978 | 2459978 | 2022-04-30 | Hudspeth | Texas | 48229 | 989 | 18 |
2460094 | 2460094 | 2022-04-30 | Upton | Texas | 48461 | 832 | 18 |
2456722 | 2456722 | 2022-04-29 | Hudspeth | Texas | 48229 | 989 | 18 |
2456838 | 2456838 | 2022-04-29 | Upton | Texas | 48461 | 832 | 18 |
2453466 | 2453466 | 2022-04-28 | Hudspeth | Texas | 48229 | 989 | 18 |
2453582 | 2453582 | 2022-04-28 | Upton | Texas | 48461 | 832 | 18 |
2450210 | 2450210 | 2022-04-27 | Hudspeth | Texas | 48229 | 989 | 18 |
2450326 | 2450326 | 2022-04-27 | Upton | Texas | 48461 | 832 | 18 |
2446953 | 2446953 | 2022-04-26 | Hudspeth | Texas | 48229 | 989 | 18 |
2447069 | 2447069 | 2022-04-26 | Upton | Texas | 48461 | 832 | 18 |
2443698 | 2443698 | 2022-04-25 | Hudspeth | Texas | 48229 | 989 | 18 |
2443814 | 2443814 | 2022-04-25 | Upton | Texas | 48461 | 832 | 18 |
2440442 | 2440442 | 2022-04-24 | Hudspeth | Texas | 48229 | 989 | 18 |
2440558 | 2440558 | 2022-04-24 | Upton | Texas | 48461 | 832 | 18 |
2437186 | 2437186 | 2022-04-23 | Hudspeth | Texas | 48229 | 989 | 18 |
2437302 | 2437302 | 2022-04-23 | Upton | Texas | 48461 | 832 | 18 |
2433930 | 2433930 | 2022-04-22 | Hudspeth | Texas | 48229 | 989 | 18 |
2434046 | 2434046 | 2022-04-22 | Upton | Texas | 48461 | 832 | 18 |
2430674 | 2430674 | 2022-04-21 | Hudspeth | Texas | 48229 | 989 | 18 |
2430790 | 2430790 | 2022-04-21 | Upton | Texas | 48461 | 832 | 18 |
2427418 | 2427418 | 2022-04-20 | Hudspeth | Texas | 48229 | 989 | 18 |
2427534 | 2427534 | 2022-04-20 | Upton | Texas | 48461 | 832 | 18 |
2424162 | 2424162 | 2022-04-19 | Hudspeth | Texas | 48229 | 989 | 18 |
2424278 | 2424278 | 2022-04-19 | Upton | Texas | 48461 | 832 | 18 |
2420906 | 2420906 | 2022-04-18 | Hudspeth | Texas | 48229 | 989 | 18 |
2421022 | 2421022 | 2022-04-18 | Upton | Texas | 48461 | 831 | 18 |
2417650 | 2417650 | 2022-04-17 | Hudspeth | Texas | 48229 | 989 | 18 |
2417766 | 2417766 | 2022-04-17 | Upton | Texas | 48461 | 831 | 18 |
2414394 | 2414394 | 2022-04-16 | Hudspeth | Texas | 48229 | 989 | 18 |
2414510 | 2414510 | 2022-04-16 | Upton | Texas | 48461 | 831 | 18 |
2411138 | 2411138 | 2022-04-15 | Hudspeth | Texas | 48229 | 989 | 18 |
2411254 | 2411254 | 2022-04-15 | Upton | Texas | 48461 | 831 | 18 |
2407882 | 2407882 | 2022-04-14 | Hudspeth | Texas | 48229 | 989 | 18 |
2407998 | 2407998 | 2022-04-14 | Upton | Texas | 48461 | 831 | 18 |
2404626 | 2404626 | 2022-04-13 | Hudspeth | Texas | 48229 | 989 | 18 |
2404742 | 2404742 | 2022-04-13 | Upton | Texas | 48461 | 830 | 18 |
2401371 | 2401371 | 2022-04-12 | Hudspeth | Texas | 48229 | 989 | 18 |
2401487 | 2401487 | 2022-04-12 | Upton | Texas | 48461 | 830 | 18 |
2398116 | 2398116 | 2022-04-11 | Hudspeth | Texas | 48229 | 988 | 18 |
2398232 | 2398232 | 2022-04-11 | Upton | Texas | 48461 | 830 | 18 |
2394861 | 2394861 | 2022-04-10 | Hudspeth | Texas | 48229 | 988 | 18 |
2394977 | 2394977 | 2022-04-10 | Upton | Texas | 48461 | 830 | 18 |
2391605 | 2391605 | 2022-04-09 | Hudspeth | Texas | 48229 | 988 | 18 |
2391721 | 2391721 | 2022-04-09 | Upton | Texas | 48461 | 830 | 18 |
2388349 | 2388349 | 2022-04-08 | Hudspeth | Texas | 48229 | 988 | 18 |
2388465 | 2388465 | 2022-04-08 | Upton | Texas | 48461 | 829 | 18 |
2385094 | 2385094 | 2022-04-07 | Hudspeth | Texas | 48229 | 988 | 18 |
2385210 | 2385210 | 2022-04-07 | Upton | Texas | 48461 | 829 | 18 |
2381839 | 2381839 | 2022-04-06 | Hudspeth | Texas | 48229 | 988 | 18 |
2381955 | 2381955 | 2022-04-06 | Upton | Texas | 48461 | 829 | 18 |
2378584 | 2378584 | 2022-04-05 | Hudspeth | Texas | 48229 | 988 | 18 |
2378700 | 2378700 | 2022-04-05 | Upton | Texas | 48461 | 829 | 18 |
2375330 | 2375330 | 2022-04-04 | Hudspeth | Texas | 48229 | 988 | 18 |
2375446 | 2375446 | 2022-04-04 | Upton | Texas | 48461 | 827 | 18 |
2372078 | 2372078 | 2022-04-03 | Hudspeth | Texas | 48229 | 988 | 18 |
2372194 | 2372194 | 2022-04-03 | Upton | Texas | 48461 | 827 | 18 |
2368825 | 2368825 | 2022-04-02 | Hudspeth | Texas | 48229 | 988 | 18 |
2368941 | 2368941 | 2022-04-02 | Upton | Texas | 48461 | 827 | 18 |
2365572 | 2365572 | 2022-04-01 | Hudspeth | Texas | 48229 | 988 | 18 |
2365688 | 2365688 | 2022-04-01 | Upton | Texas | 48461 | 827 | 18 |
2362319 | 2362319 | 2022-03-31 | Hudspeth | Texas | 48229 | 988 | 18 |
2362435 | 2362435 | 2022-03-31 | Upton | Texas | 48461 | 827 | 18 |
2359065 | 2359065 | 2022-03-30 | Hudspeth | Texas | 48229 | 987 | 18 |
2359181 | 2359181 | 2022-03-30 | Upton | Texas | 48461 | 827 | 18 |
2355811 | 2355811 | 2022-03-29 | Hudspeth | Texas | 48229 | 987 | 18 |
2355927 | 2355927 | 2022-03-29 | Upton | Texas | 48461 | 827 | 18 |
2352558 | 2352558 | 2022-03-28 | Hudspeth | Texas | 48229 | 987 | 18 |
2352674 | 2352674 | 2022-03-28 | Upton | Texas | 48461 | 827 | 18 |
2349306 | 2349306 | 2022-03-27 | Hudspeth | Texas | 48229 | 987 | 18 |
2349422 | 2349422 | 2022-03-27 | Upton | Texas | 48461 | 827 | 18 |
2346053 | 2346053 | 2022-03-26 | Hudspeth | Texas | 48229 | 987 | 18 |
2346169 | 2346169 | 2022-03-26 | Upton | Texas | 48461 | 827 | 18 |
2342800 | 2342800 | 2022-03-25 | Hudspeth | Texas | 48229 | 987 | 18 |
2342916 | 2342916 | 2022-03-25 | Upton | Texas | 48461 | 827 | 18 |
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);