ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
237 rows where deaths = 134 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502255 | 2502255 | 2022-05-13 | Cooke | Texas | 48097 | 7409 | 134 |
2502417 | 2502417 | 2022-05-13 | Shelby | Texas | 48419 | 4491 | 134 |
2498997 | 2498997 | 2022-05-12 | Cooke | Texas | 48097 | 7404 | 134 |
2499159 | 2499159 | 2022-05-12 | Shelby | Texas | 48419 | 4488 | 134 |
2495739 | 2495739 | 2022-05-11 | Cooke | Texas | 48097 | 7401 | 134 |
2495901 | 2495901 | 2022-05-11 | Shelby | Texas | 48419 | 4486 | 134 |
2492481 | 2492481 | 2022-05-10 | Cooke | Texas | 48097 | 7400 | 134 |
2492643 | 2492643 | 2022-05-10 | Shelby | Texas | 48419 | 4485 | 134 |
2489223 | 2489223 | 2022-05-09 | Cooke | Texas | 48097 | 7396 | 134 |
2489385 | 2489385 | 2022-05-09 | Shelby | Texas | 48419 | 4485 | 134 |
2485966 | 2485966 | 2022-05-08 | Cooke | Texas | 48097 | 7395 | 134 |
2486127 | 2486127 | 2022-05-08 | Shelby | Texas | 48419 | 4485 | 134 |
2482708 | 2482708 | 2022-05-07 | Cooke | Texas | 48097 | 7395 | 134 |
2482869 | 2482869 | 2022-05-07 | Shelby | Texas | 48419 | 4485 | 134 |
2479450 | 2479450 | 2022-05-06 | Cooke | Texas | 48097 | 7393 | 134 |
2479611 | 2479611 | 2022-05-06 | Shelby | Texas | 48419 | 4485 | 134 |
2476192 | 2476192 | 2022-05-05 | Cooke | Texas | 48097 | 7393 | 134 |
2476353 | 2476353 | 2022-05-05 | Shelby | Texas | 48419 | 4483 | 134 |
2472935 | 2472935 | 2022-05-04 | Cooke | Texas | 48097 | 7390 | 134 |
2473003 | 2473003 | 2022-05-04 | Hutchinson | Texas | 48233 | 6753 | 134 |
2473096 | 2473096 | 2022-05-04 | Shelby | Texas | 48419 | 4481 | 134 |
2469679 | 2469679 | 2022-05-03 | Cooke | Texas | 48097 | 7389 | 134 |
2469747 | 2469747 | 2022-05-03 | Hutchinson | Texas | 48233 | 6753 | 134 |
2469840 | 2469840 | 2022-05-03 | Shelby | Texas | 48419 | 4480 | 134 |
2466423 | 2466423 | 2022-05-02 | Cooke | Texas | 48097 | 7388 | 134 |
2466491 | 2466491 | 2022-05-02 | Hutchinson | Texas | 48233 | 6752 | 134 |
2466584 | 2466584 | 2022-05-02 | Shelby | Texas | 48419 | 4479 | 134 |
2463168 | 2463168 | 2022-05-01 | Cooke | Texas | 48097 | 7388 | 134 |
2463236 | 2463236 | 2022-05-01 | Hutchinson | Texas | 48233 | 6752 | 134 |
2463329 | 2463329 | 2022-05-01 | Shelby | Texas | 48419 | 4479 | 134 |
2459912 | 2459912 | 2022-04-30 | Cooke | Texas | 48097 | 7386 | 134 |
2459980 | 2459980 | 2022-04-30 | Hutchinson | Texas | 48233 | 6752 | 134 |
2460073 | 2460073 | 2022-04-30 | Shelby | Texas | 48419 | 4479 | 134 |
2456656 | 2456656 | 2022-04-29 | Cooke | Texas | 48097 | 7357 | 134 |
2456724 | 2456724 | 2022-04-29 | Hutchinson | Texas | 48233 | 6752 | 134 |
2456817 | 2456817 | 2022-04-29 | Shelby | Texas | 48419 | 4478 | 134 |
2453400 | 2453400 | 2022-04-28 | Cooke | Texas | 48097 | 7352 | 134 |
2453468 | 2453468 | 2022-04-28 | Hutchinson | Texas | 48233 | 6751 | 134 |
2453561 | 2453561 | 2022-04-28 | Shelby | Texas | 48419 | 4478 | 134 |
2450144 | 2450144 | 2022-04-27 | Cooke | Texas | 48097 | 7348 | 134 |
2450212 | 2450212 | 2022-04-27 | Hutchinson | Texas | 48233 | 6749 | 134 |
2450305 | 2450305 | 2022-04-27 | Shelby | Texas | 48419 | 4475 | 134 |
2446955 | 2446955 | 2022-04-26 | Hutchinson | Texas | 48233 | 6747 | 134 |
2447048 | 2447048 | 2022-04-26 | Shelby | Texas | 48419 | 4474 | 134 |
2443700 | 2443700 | 2022-04-25 | Hutchinson | Texas | 48233 | 6747 | 134 |
2443793 | 2443793 | 2022-04-25 | Shelby | Texas | 48419 | 4474 | 134 |
2440444 | 2440444 | 2022-04-24 | Hutchinson | Texas | 48233 | 6747 | 134 |
2440537 | 2440537 | 2022-04-24 | Shelby | Texas | 48419 | 4474 | 134 |
2437188 | 2437188 | 2022-04-23 | Hutchinson | Texas | 48233 | 6747 | 134 |
2437281 | 2437281 | 2022-04-23 | Shelby | Texas | 48419 | 4474 | 134 |
2433932 | 2433932 | 2022-04-22 | Hutchinson | Texas | 48233 | 6747 | 134 |
2434025 | 2434025 | 2022-04-22 | Shelby | Texas | 48419 | 4474 | 134 |
2430676 | 2430676 | 2022-04-21 | Hutchinson | Texas | 48233 | 6745 | 134 |
2430769 | 2430769 | 2022-04-21 | Shelby | Texas | 48419 | 4472 | 134 |
2427513 | 2427513 | 2022-04-20 | Shelby | Texas | 48419 | 4471 | 134 |
2424257 | 2424257 | 2022-04-19 | Shelby | Texas | 48419 | 4466 | 134 |
2421001 | 2421001 | 2022-04-18 | Shelby | Texas | 48419 | 4465 | 134 |
2417745 | 2417745 | 2022-04-17 | Shelby | Texas | 48419 | 4462 | 134 |
2414489 | 2414489 | 2022-04-16 | Shelby | Texas | 48419 | 4462 | 134 |
2411233 | 2411233 | 2022-04-15 | Shelby | Texas | 48419 | 4462 | 134 |
2407977 | 2407977 | 2022-04-14 | Shelby | Texas | 48419 | 4462 | 134 |
2404628 | 2404628 | 2022-04-13 | Hutchinson | Texas | 48233 | 6730 | 134 |
2404721 | 2404721 | 2022-04-13 | Shelby | Texas | 48419 | 4462 | 134 |
2401373 | 2401373 | 2022-04-12 | Hutchinson | Texas | 48233 | 6730 | 134 |
2401466 | 2401466 | 2022-04-12 | Shelby | Texas | 48419 | 4461 | 134 |
2398118 | 2398118 | 2022-04-11 | Hutchinson | Texas | 48233 | 6730 | 134 |
2398211 | 2398211 | 2022-04-11 | Shelby | Texas | 48419 | 4460 | 134 |
2394863 | 2394863 | 2022-04-10 | Hutchinson | Texas | 48233 | 6730 | 134 |
2394956 | 2394956 | 2022-04-10 | Shelby | Texas | 48419 | 4460 | 134 |
2391607 | 2391607 | 2022-04-09 | Hutchinson | Texas | 48233 | 6728 | 134 |
2391700 | 2391700 | 2022-04-09 | Shelby | Texas | 48419 | 4460 | 134 |
2388351 | 2388351 | 2022-04-08 | Hutchinson | Texas | 48233 | 6723 | 134 |
2388444 | 2388444 | 2022-04-08 | Shelby | Texas | 48419 | 4459 | 134 |
2385096 | 2385096 | 2022-04-07 | Hutchinson | Texas | 48233 | 6715 | 134 |
2385189 | 2385189 | 2022-04-07 | Shelby | Texas | 48419 | 4457 | 134 |
2381934 | 2381934 | 2022-04-06 | Shelby | Texas | 48419 | 4457 | 134 |
2378679 | 2378679 | 2022-04-05 | Shelby | Texas | 48419 | 4453 | 134 |
2307016 | 2307016 | 2022-03-14 | Hutchinson | Texas | 48233 | 6632 | 134 |
2303765 | 2303765 | 2022-03-13 | Hutchinson | Texas | 48233 | 6632 | 134 |
2300513 | 2300513 | 2022-03-12 | Hutchinson | Texas | 48233 | 6632 | 134 |
2264852 | 2264852 | 2022-03-01 | Uvalde | Texas | 48463 | 10515 | 134 |
2261602 | 2261602 | 2022-02-28 | Uvalde | Texas | 48463 | 10510 | 134 |
2258351 | 2258351 | 2022-02-27 | Uvalde | Texas | 48463 | 10510 | 134 |
2255100 | 2255100 | 2022-02-26 | Uvalde | Texas | 48463 | 10507 | 134 |
2251849 | 2251849 | 2022-02-25 | Uvalde | Texas | 48463 | 10504 | 134 |
2248598 | 2248598 | 2022-02-24 | Uvalde | Texas | 48463 | 10501 | 134 |
2173705 | 2173705 | 2022-02-01 | Kleberg | Texas | 48273 | 6335 | 134 |
2170453 | 2170453 | 2022-01-31 | Kleberg | Texas | 48273 | 6299 | 134 |
2167199 | 2167199 | 2022-01-30 | Kleberg | Texas | 48273 | 6263 | 134 |
2163944 | 2163944 | 2022-01-29 | Kleberg | Texas | 48273 | 6210 | 134 |
2160689 | 2160689 | 2022-01-28 | Kleberg | Texas | 48273 | 6153 | 134 |
2157433 | 2157433 | 2022-01-27 | Kleberg | Texas | 48273 | 6091 | 134 |
2154180 | 2154180 | 2022-01-26 | Kleberg | Texas | 48273 | 6030 | 134 |
2150928 | 2150928 | 2022-01-25 | Kleberg | Texas | 48273 | 5986 | 134 |
2150973 | 2150973 | 2022-01-25 | Palo Pinto | Texas | 48363 | 6423 | 134 |
2076015 | 2076015 | 2022-01-02 | Burnet | Texas | 48053 | 7846 | 134 |
2072764 | 2072764 | 2022-01-01 | Burnet | Texas | 48053 | 7846 | 134 |
2069513 | 2069513 | 2021-12-31 | Burnet | Texas | 48053 | 7846 | 134 |
2066262 | 2066262 | 2021-12-30 | Burnet | Texas | 48053 | 7846 | 134 |
2020974 | 2020974 | 2021-12-16 | Washington | Texas | 48477 | 5910 | 134 |
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);