ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,626 rows where deaths = 28 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Goliad 111
- Blanco 108
- Archer 80
- Mills 73
- Presidio 71
- Jack 70
- Yoakum 68
- La Salle 62
- Wilson 52
- Haskell 47
- Walker 38
- Crosby 37
- Bailey 36
- Bandera 35
- Garza 32
- Madison 29
- Titus 21
- Dallam 19
- Hansford 18
- San Augustine 18
- San Saba 18
- Childress 17
- Jackson 15
- Leon 15
- Van Zandt 15
- Zavala 15
- Duval 14
- Stephens 14
- Baylor 13
- Bosque 13
- …
state 1
- Texas · 1,626 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502211 | 2502211 | 2022-05-13 | Archer | Texas | 48009 | 2213 | 28 |
2502291 | 2502291 | 2022-05-13 | Garza | Texas | 48169 | 1279 | 28 |
2502325 | 2502325 | 2022-05-13 | Jack | Texas | 48237 | 1523 | 28 |
2498953 | 2498953 | 2022-05-12 | Archer | Texas | 48009 | 2212 | 28 |
2499033 | 2499033 | 2022-05-12 | Garza | Texas | 48169 | 1279 | 28 |
2499067 | 2499067 | 2022-05-12 | Jack | Texas | 48237 | 1522 | 28 |
2495695 | 2495695 | 2022-05-11 | Archer | Texas | 48009 | 2206 | 28 |
2495775 | 2495775 | 2022-05-11 | Garza | Texas | 48169 | 1277 | 28 |
2495809 | 2495809 | 2022-05-11 | Jack | Texas | 48237 | 1519 | 28 |
2492437 | 2492437 | 2022-05-10 | Archer | Texas | 48009 | 2206 | 28 |
2492517 | 2492517 | 2022-05-10 | Garza | Texas | 48169 | 1277 | 28 |
2492551 | 2492551 | 2022-05-10 | Jack | Texas | 48237 | 1518 | 28 |
2489179 | 2489179 | 2022-05-09 | Archer | Texas | 48009 | 2204 | 28 |
2489259 | 2489259 | 2022-05-09 | Garza | Texas | 48169 | 1276 | 28 |
2489293 | 2489293 | 2022-05-09 | Jack | Texas | 48237 | 1517 | 28 |
2485922 | 2485922 | 2022-05-08 | Archer | Texas | 48009 | 2203 | 28 |
2486002 | 2486002 | 2022-05-08 | Garza | Texas | 48169 | 1276 | 28 |
2486036 | 2486036 | 2022-05-08 | Jack | Texas | 48237 | 1517 | 28 |
2482664 | 2482664 | 2022-05-07 | Archer | Texas | 48009 | 2202 | 28 |
2482744 | 2482744 | 2022-05-07 | Garza | Texas | 48169 | 1276 | 28 |
2482778 | 2482778 | 2022-05-07 | Jack | Texas | 48237 | 1516 | 28 |
2479406 | 2479406 | 2022-05-06 | Archer | Texas | 48009 | 2202 | 28 |
2479486 | 2479486 | 2022-05-06 | Garza | Texas | 48169 | 1276 | 28 |
2479520 | 2479520 | 2022-05-06 | Jack | Texas | 48237 | 1515 | 28 |
2476148 | 2476148 | 2022-05-05 | Archer | Texas | 48009 | 2201 | 28 |
2476228 | 2476228 | 2022-05-05 | Garza | Texas | 48169 | 1276 | 28 |
2476262 | 2476262 | 2022-05-05 | Jack | Texas | 48237 | 1515 | 28 |
2472891 | 2472891 | 2022-05-04 | Archer | Texas | 48009 | 2190 | 28 |
2472971 | 2472971 | 2022-05-04 | Garza | Texas | 48169 | 1276 | 28 |
2473005 | 2473005 | 2022-05-04 | Jack | Texas | 48237 | 1515 | 28 |
2469635 | 2469635 | 2022-05-03 | Archer | Texas | 48009 | 2182 | 28 |
2469715 | 2469715 | 2022-05-03 | Garza | Texas | 48169 | 1276 | 28 |
2469749 | 2469749 | 2022-05-03 | Jack | Texas | 48237 | 1514 | 28 |
2466379 | 2466379 | 2022-05-02 | Archer | Texas | 48009 | 2180 | 28 |
2466459 | 2466459 | 2022-05-02 | Garza | Texas | 48169 | 1274 | 28 |
2466493 | 2466493 | 2022-05-02 | Jack | Texas | 48237 | 1514 | 28 |
2463124 | 2463124 | 2022-05-01 | Archer | Texas | 48009 | 2180 | 28 |
2463204 | 2463204 | 2022-05-01 | Garza | Texas | 48169 | 1274 | 28 |
2463238 | 2463238 | 2022-05-01 | Jack | Texas | 48237 | 1514 | 28 |
2459868 | 2459868 | 2022-04-30 | Archer | Texas | 48009 | 2180 | 28 |
2459948 | 2459948 | 2022-04-30 | Garza | Texas | 48169 | 1274 | 28 |
2459982 | 2459982 | 2022-04-30 | Jack | Texas | 48237 | 1514 | 28 |
2456612 | 2456612 | 2022-04-29 | Archer | Texas | 48009 | 2179 | 28 |
2456692 | 2456692 | 2022-04-29 | Garza | Texas | 48169 | 1274 | 28 |
2456726 | 2456726 | 2022-04-29 | Jack | Texas | 48237 | 1513 | 28 |
2453356 | 2453356 | 2022-04-28 | Archer | Texas | 48009 | 2179 | 28 |
2453436 | 2453436 | 2022-04-28 | Garza | Texas | 48169 | 1274 | 28 |
2453470 | 2453470 | 2022-04-28 | Jack | Texas | 48237 | 1512 | 28 |
2450100 | 2450100 | 2022-04-27 | Archer | Texas | 48009 | 2176 | 28 |
2450180 | 2450180 | 2022-04-27 | Garza | Texas | 48169 | 1274 | 28 |
2450214 | 2450214 | 2022-04-27 | Jack | Texas | 48237 | 1512 | 28 |
2446843 | 2446843 | 2022-04-26 | Archer | Texas | 48009 | 2175 | 28 |
2446923 | 2446923 | 2022-04-26 | Garza | Texas | 48169 | 1274 | 28 |
2446957 | 2446957 | 2022-04-26 | Jack | Texas | 48237 | 1512 | 28 |
2443588 | 2443588 | 2022-04-25 | Archer | Texas | 48009 | 2172 | 28 |
2443668 | 2443668 | 2022-04-25 | Garza | Texas | 48169 | 1274 | 28 |
2443702 | 2443702 | 2022-04-25 | Jack | Texas | 48237 | 1511 | 28 |
2440332 | 2440332 | 2022-04-24 | Archer | Texas | 48009 | 2172 | 28 |
2440412 | 2440412 | 2022-04-24 | Garza | Texas | 48169 | 1274 | 28 |
2440446 | 2440446 | 2022-04-24 | Jack | Texas | 48237 | 1510 | 28 |
2437076 | 2437076 | 2022-04-23 | Archer | Texas | 48009 | 2172 | 28 |
2437156 | 2437156 | 2022-04-23 | Garza | Texas | 48169 | 1274 | 28 |
2437190 | 2437190 | 2022-04-23 | Jack | Texas | 48237 | 1510 | 28 |
2433820 | 2433820 | 2022-04-22 | Archer | Texas | 48009 | 2168 | 28 |
2433900 | 2433900 | 2022-04-22 | Garza | Texas | 48169 | 1273 | 28 |
2433934 | 2433934 | 2022-04-22 | Jack | Texas | 48237 | 1508 | 28 |
2430564 | 2430564 | 2022-04-21 | Archer | Texas | 48009 | 2165 | 28 |
2430644 | 2430644 | 2022-04-21 | Garza | Texas | 48169 | 1272 | 28 |
2430678 | 2430678 | 2022-04-21 | Jack | Texas | 48237 | 1508 | 28 |
2427308 | 2427308 | 2022-04-20 | Archer | Texas | 48009 | 2162 | 28 |
2427388 | 2427388 | 2022-04-20 | Garza | Texas | 48169 | 1271 | 28 |
2427422 | 2427422 | 2022-04-20 | Jack | Texas | 48237 | 1508 | 28 |
2424052 | 2424052 | 2022-04-19 | Archer | Texas | 48009 | 2161 | 28 |
2424132 | 2424132 | 2022-04-19 | Garza | Texas | 48169 | 1271 | 28 |
2424166 | 2424166 | 2022-04-19 | Jack | Texas | 48237 | 1508 | 28 |
2420796 | 2420796 | 2022-04-18 | Archer | Texas | 48009 | 2160 | 28 |
2420876 | 2420876 | 2022-04-18 | Garza | Texas | 48169 | 1270 | 28 |
2420910 | 2420910 | 2022-04-18 | Jack | Texas | 48237 | 1508 | 28 |
2417540 | 2417540 | 2022-04-17 | Archer | Texas | 48009 | 2156 | 28 |
2417620 | 2417620 | 2022-04-17 | Garza | Texas | 48169 | 1270 | 28 |
2417654 | 2417654 | 2022-04-17 | Jack | Texas | 48237 | 1508 | 28 |
2414284 | 2414284 | 2022-04-16 | Archer | Texas | 48009 | 2156 | 28 |
2414364 | 2414364 | 2022-04-16 | Garza | Texas | 48169 | 1270 | 28 |
2414398 | 2414398 | 2022-04-16 | Jack | Texas | 48237 | 1508 | 28 |
2411028 | 2411028 | 2022-04-15 | Archer | Texas | 48009 | 2156 | 28 |
2411108 | 2411108 | 2022-04-15 | Garza | Texas | 48169 | 1270 | 28 |
2411142 | 2411142 | 2022-04-15 | Jack | Texas | 48237 | 1508 | 28 |
2407772 | 2407772 | 2022-04-14 | Archer | Texas | 48009 | 2156 | 28 |
2407852 | 2407852 | 2022-04-14 | Garza | Texas | 48169 | 1270 | 28 |
2407886 | 2407886 | 2022-04-14 | Jack | Texas | 48237 | 1508 | 28 |
2404516 | 2404516 | 2022-04-13 | Archer | Texas | 48009 | 2154 | 28 |
2404596 | 2404596 | 2022-04-13 | Garza | Texas | 48169 | 1270 | 28 |
2404630 | 2404630 | 2022-04-13 | Jack | Texas | 48237 | 1508 | 28 |
2401261 | 2401261 | 2022-04-12 | Archer | Texas | 48009 | 2154 | 28 |
2401341 | 2401341 | 2022-04-12 | Garza | Texas | 48169 | 1270 | 28 |
2401375 | 2401375 | 2022-04-12 | Jack | Texas | 48237 | 1508 | 28 |
2398006 | 2398006 | 2022-04-11 | Archer | Texas | 48009 | 2150 | 28 |
2398120 | 2398120 | 2022-04-11 | Jack | Texas | 48237 | 1507 | 28 |
2394751 | 2394751 | 2022-04-10 | Archer | Texas | 48009 | 2150 | 28 |
2394865 | 2394865 | 2022-04-10 | Jack | Texas | 48237 | 1507 | 28 |
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);