ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,217 rows where deaths = 34 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Pecos 122
- Winkler 94
- Blanco 66
- Swisher 57
- Carson 53
- Austin 50
- Morris 42
- Parmer 40
- Jasper 37
- Coleman 35
- Red River 23
- Yoakum 22
- Newton 21
- Castro 19
- Marion 19
- Ward 19
- Colorado 17
- Falls 14
- Bosque 13
- Caldwell 13
- Tyler 12
- Lynn 11
- San Jacinto 11
- Chambers 10
- Howard 10
- Uvalde 10
- Atascosa 9
- Mitchell 9
- Somervell 9
- Clay 8
- …
state 1
- Texas · 1,217 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502222 | 2502222 | 2022-05-13 | Blanco | Texas | 48031 | 2568 | 34 |
2502426 | 2502426 | 2022-05-13 | Swisher | Texas | 48437 | 2288 | 34 |
2502455 | 2502455 | 2022-05-13 | Winkler | Texas | 48495 | 1846 | 34 |
2498964 | 2498964 | 2022-05-12 | Blanco | Texas | 48031 | 2566 | 34 |
2499168 | 2499168 | 2022-05-12 | Swisher | Texas | 48437 | 2288 | 34 |
2499197 | 2499197 | 2022-05-12 | Winkler | Texas | 48495 | 1846 | 34 |
2495706 | 2495706 | 2022-05-11 | Blanco | Texas | 48031 | 2563 | 34 |
2495910 | 2495910 | 2022-05-11 | Swisher | Texas | 48437 | 2286 | 34 |
2495939 | 2495939 | 2022-05-11 | Winkler | Texas | 48495 | 1846 | 34 |
2492448 | 2492448 | 2022-05-10 | Blanco | Texas | 48031 | 2562 | 34 |
2492652 | 2492652 | 2022-05-10 | Swisher | Texas | 48437 | 2286 | 34 |
2492681 | 2492681 | 2022-05-10 | Winkler | Texas | 48495 | 1846 | 34 |
2489190 | 2489190 | 2022-05-09 | Blanco | Texas | 48031 | 2561 | 34 |
2489394 | 2489394 | 2022-05-09 | Swisher | Texas | 48437 | 2285 | 34 |
2489423 | 2489423 | 2022-05-09 | Winkler | Texas | 48495 | 1846 | 34 |
2485933 | 2485933 | 2022-05-08 | Blanco | Texas | 48031 | 2560 | 34 |
2486136 | 2486136 | 2022-05-08 | Swisher | Texas | 48437 | 2285 | 34 |
2486165 | 2486165 | 2022-05-08 | Winkler | Texas | 48495 | 1846 | 34 |
2482675 | 2482675 | 2022-05-07 | Blanco | Texas | 48031 | 2557 | 34 |
2482878 | 2482878 | 2022-05-07 | Swisher | Texas | 48437 | 2285 | 34 |
2482907 | 2482907 | 2022-05-07 | Winkler | Texas | 48495 | 1846 | 34 |
2479417 | 2479417 | 2022-05-06 | Blanco | Texas | 48031 | 2557 | 34 |
2479620 | 2479620 | 2022-05-06 | Swisher | Texas | 48437 | 2285 | 34 |
2479649 | 2479649 | 2022-05-06 | Winkler | Texas | 48495 | 1846 | 34 |
2476159 | 2476159 | 2022-05-05 | Blanco | Texas | 48031 | 2554 | 34 |
2476362 | 2476362 | 2022-05-05 | Swisher | Texas | 48437 | 2285 | 34 |
2476391 | 2476391 | 2022-05-05 | Winkler | Texas | 48495 | 1846 | 34 |
2472902 | 2472902 | 2022-05-04 | Blanco | Texas | 48031 | 2552 | 34 |
2473105 | 2473105 | 2022-05-04 | Swisher | Texas | 48437 | 2285 | 34 |
2473134 | 2473134 | 2022-05-04 | Winkler | Texas | 48495 | 1845 | 34 |
2469646 | 2469646 | 2022-05-03 | Blanco | Texas | 48031 | 2551 | 34 |
2469849 | 2469849 | 2022-05-03 | Swisher | Texas | 48437 | 2285 | 34 |
2469878 | 2469878 | 2022-05-03 | Winkler | Texas | 48495 | 1845 | 34 |
2466390 | 2466390 | 2022-05-02 | Blanco | Texas | 48031 | 2551 | 34 |
2466593 | 2466593 | 2022-05-02 | Swisher | Texas | 48437 | 2284 | 34 |
2466622 | 2466622 | 2022-05-02 | Winkler | Texas | 48495 | 1845 | 34 |
2463135 | 2463135 | 2022-05-01 | Blanco | Texas | 48031 | 2548 | 34 |
2463338 | 2463338 | 2022-05-01 | Swisher | Texas | 48437 | 2284 | 34 |
2463367 | 2463367 | 2022-05-01 | Winkler | Texas | 48495 | 1845 | 34 |
2459879 | 2459879 | 2022-04-30 | Blanco | Texas | 48031 | 2547 | 34 |
2460082 | 2460082 | 2022-04-30 | Swisher | Texas | 48437 | 2284 | 34 |
2460111 | 2460111 | 2022-04-30 | Winkler | Texas | 48495 | 1845 | 34 |
2456623 | 2456623 | 2022-04-29 | Blanco | Texas | 48031 | 2547 | 34 |
2456826 | 2456826 | 2022-04-29 | Swisher | Texas | 48437 | 2284 | 34 |
2456855 | 2456855 | 2022-04-29 | Winkler | Texas | 48495 | 1845 | 34 |
2453367 | 2453367 | 2022-04-28 | Blanco | Texas | 48031 | 2545 | 34 |
2453570 | 2453570 | 2022-04-28 | Swisher | Texas | 48437 | 2284 | 34 |
2453599 | 2453599 | 2022-04-28 | Winkler | Texas | 48495 | 1845 | 34 |
2450111 | 2450111 | 2022-04-27 | Blanco | Texas | 48031 | 2545 | 34 |
2450314 | 2450314 | 2022-04-27 | Swisher | Texas | 48437 | 2284 | 34 |
2450343 | 2450343 | 2022-04-27 | Winkler | Texas | 48495 | 1845 | 34 |
2446854 | 2446854 | 2022-04-26 | Blanco | Texas | 48031 | 2545 | 34 |
2447057 | 2447057 | 2022-04-26 | Swisher | Texas | 48437 | 2284 | 34 |
2447086 | 2447086 | 2022-04-26 | Winkler | Texas | 48495 | 1845 | 34 |
2443599 | 2443599 | 2022-04-25 | Blanco | Texas | 48031 | 2544 | 34 |
2443802 | 2443802 | 2022-04-25 | Swisher | Texas | 48437 | 2284 | 34 |
2443831 | 2443831 | 2022-04-25 | Winkler | Texas | 48495 | 1845 | 34 |
2440343 | 2440343 | 2022-04-24 | Blanco | Texas | 48031 | 2542 | 34 |
2440546 | 2440546 | 2022-04-24 | Swisher | Texas | 48437 | 2284 | 34 |
2440575 | 2440575 | 2022-04-24 | Winkler | Texas | 48495 | 1845 | 34 |
2437087 | 2437087 | 2022-04-23 | Blanco | Texas | 48031 | 2542 | 34 |
2437290 | 2437290 | 2022-04-23 | Swisher | Texas | 48437 | 2284 | 34 |
2437319 | 2437319 | 2022-04-23 | Winkler | Texas | 48495 | 1845 | 34 |
2433831 | 2433831 | 2022-04-22 | Blanco | Texas | 48031 | 2539 | 34 |
2434034 | 2434034 | 2022-04-22 | Swisher | Texas | 48437 | 2284 | 34 |
2434063 | 2434063 | 2022-04-22 | Winkler | Texas | 48495 | 1845 | 34 |
2430575 | 2430575 | 2022-04-21 | Blanco | Texas | 48031 | 2539 | 34 |
2430778 | 2430778 | 2022-04-21 | Swisher | Texas | 48437 | 2284 | 34 |
2430807 | 2430807 | 2022-04-21 | Winkler | Texas | 48495 | 1845 | 34 |
2427319 | 2427319 | 2022-04-20 | Blanco | Texas | 48031 | 2538 | 34 |
2427522 | 2427522 | 2022-04-20 | Swisher | Texas | 48437 | 2284 | 34 |
2427551 | 2427551 | 2022-04-20 | Winkler | Texas | 48495 | 1845 | 34 |
2424063 | 2424063 | 2022-04-19 | Blanco | Texas | 48031 | 2538 | 34 |
2424266 | 2424266 | 2022-04-19 | Swisher | Texas | 48437 | 2284 | 34 |
2424295 | 2424295 | 2022-04-19 | Winkler | Texas | 48495 | 1844 | 34 |
2420807 | 2420807 | 2022-04-18 | Blanco | Texas | 48031 | 2538 | 34 |
2421010 | 2421010 | 2022-04-18 | Swisher | Texas | 48437 | 2284 | 34 |
2421039 | 2421039 | 2022-04-18 | Winkler | Texas | 48495 | 1844 | 34 |
2417551 | 2417551 | 2022-04-17 | Blanco | Texas | 48031 | 2536 | 34 |
2417754 | 2417754 | 2022-04-17 | Swisher | Texas | 48437 | 2281 | 34 |
2417783 | 2417783 | 2022-04-17 | Winkler | Texas | 48495 | 1844 | 34 |
2414295 | 2414295 | 2022-04-16 | Blanco | Texas | 48031 | 2536 | 34 |
2414498 | 2414498 | 2022-04-16 | Swisher | Texas | 48437 | 2281 | 34 |
2414527 | 2414527 | 2022-04-16 | Winkler | Texas | 48495 | 1844 | 34 |
2411039 | 2411039 | 2022-04-15 | Blanco | Texas | 48031 | 2536 | 34 |
2411242 | 2411242 | 2022-04-15 | Swisher | Texas | 48437 | 2281 | 34 |
2411271 | 2411271 | 2022-04-15 | Winkler | Texas | 48495 | 1844 | 34 |
2407783 | 2407783 | 2022-04-14 | Blanco | Texas | 48031 | 2536 | 34 |
2407986 | 2407986 | 2022-04-14 | Swisher | Texas | 48437 | 2281 | 34 |
2408015 | 2408015 | 2022-04-14 | Winkler | Texas | 48495 | 1844 | 34 |
2404527 | 2404527 | 2022-04-13 | Blanco | Texas | 48031 | 2535 | 34 |
2404730 | 2404730 | 2022-04-13 | Swisher | Texas | 48437 | 2280 | 34 |
2404759 | 2404759 | 2022-04-13 | Winkler | Texas | 48495 | 1842 | 34 |
2401272 | 2401272 | 2022-04-12 | Blanco | Texas | 48031 | 2535 | 34 |
2401289 | 2401289 | 2022-04-12 | Carson | Texas | 48065 | 1527 | 34 |
2401475 | 2401475 | 2022-04-12 | Swisher | Texas | 48437 | 2275 | 34 |
2401504 | 2401504 | 2022-04-12 | Winkler | Texas | 48495 | 1842 | 34 |
2398017 | 2398017 | 2022-04-11 | Blanco | Texas | 48031 | 2535 | 34 |
2398034 | 2398034 | 2022-04-11 | Carson | Texas | 48065 | 1527 | 34 |
2398220 | 2398220 | 2022-04-11 | Swisher | Texas | 48437 | 2275 | 34 |
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);