ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
209 rows where deaths = 118 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482789 | 2482789 | 2022-05-07 | Kendall | Texas | 48259 | 8240 | 118 |
2479531 | 2479531 | 2022-05-06 | Kendall | Texas | 48259 | 8237 | 118 |
2476273 | 2476273 | 2022-05-05 | Kendall | Texas | 48259 | 8236 | 118 |
2473016 | 2473016 | 2022-05-04 | Kendall | Texas | 48259 | 8234 | 118 |
2469760 | 2469760 | 2022-05-03 | Kendall | Texas | 48259 | 8232 | 118 |
2466504 | 2466504 | 2022-05-02 | Kendall | Texas | 48259 | 8232 | 118 |
2463249 | 2463249 | 2022-05-01 | Kendall | Texas | 48259 | 8230 | 118 |
2459993 | 2459993 | 2022-04-30 | Kendall | Texas | 48259 | 8228 | 118 |
2456737 | 2456737 | 2022-04-29 | Kendall | Texas | 48259 | 8223 | 118 |
2453481 | 2453481 | 2022-04-28 | Kendall | Texas | 48259 | 8221 | 118 |
2450225 | 2450225 | 2022-04-27 | Kendall | Texas | 48259 | 8215 | 118 |
2446968 | 2446968 | 2022-04-26 | Kendall | Texas | 48259 | 8213 | 118 |
2443713 | 2443713 | 2022-04-25 | Kendall | Texas | 48259 | 8202 | 118 |
2440457 | 2440457 | 2022-04-24 | Kendall | Texas | 48259 | 8201 | 118 |
2437201 | 2437201 | 2022-04-23 | Kendall | Texas | 48259 | 8199 | 118 |
2433945 | 2433945 | 2022-04-22 | Kendall | Texas | 48259 | 8199 | 118 |
2430689 | 2430689 | 2022-04-21 | Kendall | Texas | 48259 | 8198 | 118 |
2404641 | 2404641 | 2022-04-13 | Kendall | Texas | 48259 | 8179 | 118 |
2401386 | 2401386 | 2022-04-12 | Kendall | Texas | 48259 | 8177 | 118 |
2398131 | 2398131 | 2022-04-11 | Kendall | Texas | 48259 | 8175 | 118 |
2394876 | 2394876 | 2022-04-10 | Kendall | Texas | 48259 | 8172 | 118 |
2381854 | 2381854 | 2022-04-06 | Kendall | Texas | 48259 | 8166 | 118 |
2378599 | 2378599 | 2022-04-05 | Kendall | Texas | 48259 | 8165 | 118 |
2375345 | 2375345 | 2022-04-04 | Kendall | Texas | 48259 | 8165 | 118 |
2372093 | 2372093 | 2022-04-03 | Kendall | Texas | 48259 | 8164 | 118 |
2368840 | 2368840 | 2022-04-02 | Kendall | Texas | 48259 | 8164 | 118 |
2365587 | 2365587 | 2022-04-01 | Kendall | Texas | 48259 | 8161 | 118 |
2365600 | 2365600 | 2022-04-01 | Lavaca | Texas | 48285 | 4235 | 118 |
2362334 | 2362334 | 2022-03-31 | Kendall | Texas | 48259 | 8161 | 118 |
2362347 | 2362347 | 2022-03-31 | Lavaca | Texas | 48285 | 4232 | 118 |
2359080 | 2359080 | 2022-03-30 | Kendall | Texas | 48259 | 8161 | 118 |
2359093 | 2359093 | 2022-03-30 | Lavaca | Texas | 48285 | 4207 | 118 |
2355826 | 2355826 | 2022-03-29 | Kendall | Texas | 48259 | 8158 | 118 |
2355839 | 2355839 | 2022-03-29 | Lavaca | Texas | 48285 | 4205 | 118 |
2352573 | 2352573 | 2022-03-28 | Kendall | Texas | 48259 | 8151 | 118 |
2352586 | 2352586 | 2022-03-28 | Lavaca | Texas | 48285 | 4198 | 118 |
2349321 | 2349321 | 2022-03-27 | Kendall | Texas | 48259 | 8151 | 118 |
2349334 | 2349334 | 2022-03-27 | Lavaca | Texas | 48285 | 4197 | 118 |
2346068 | 2346068 | 2022-03-26 | Kendall | Texas | 48259 | 8151 | 118 |
2346081 | 2346081 | 2022-03-26 | Lavaca | Texas | 48285 | 4197 | 118 |
2342815 | 2342815 | 2022-03-25 | Kendall | Texas | 48259 | 8139 | 118 |
2342828 | 2342828 | 2022-03-25 | Lavaca | Texas | 48285 | 4186 | 118 |
2339562 | 2339562 | 2022-03-24 | Kendall | Texas | 48259 | 8135 | 118 |
2339575 | 2339575 | 2022-03-24 | Lavaca | Texas | 48285 | 4186 | 118 |
2336308 | 2336308 | 2022-03-23 | Kendall | Texas | 48259 | 8134 | 118 |
2336321 | 2336321 | 2022-03-23 | Lavaca | Texas | 48285 | 4185 | 118 |
2333054 | 2333054 | 2022-03-22 | Kendall | Texas | 48259 | 8132 | 118 |
2329801 | 2329801 | 2022-03-21 | Kendall | Texas | 48259 | 8130 | 118 |
2326549 | 2326549 | 2022-03-20 | Kendall | Texas | 48259 | 8130 | 118 |
2323296 | 2323296 | 2022-03-19 | Kendall | Texas | 48259 | 8127 | 118 |
2274471 | 2274471 | 2022-03-04 | Grimes | Texas | 48185 | 8418 | 118 |
2261511 | 2261511 | 2022-02-28 | Lamb | Texas | 48279 | 4266 | 118 |
2258260 | 2258260 | 2022-02-27 | Lamb | Texas | 48279 | 4266 | 118 |
2255009 | 2255009 | 2022-02-26 | Lamb | Texas | 48279 | 4266 | 118 |
2248438 | 2248438 | 2022-02-24 | Erath | Texas | 48143 | 8474 | 118 |
2245187 | 2245187 | 2022-02-23 | Erath | Texas | 48143 | 8454 | 118 |
2241936 | 2241936 | 2022-02-22 | Erath | Texas | 48143 | 8439 | 118 |
2232258 | 2232258 | 2022-02-19 | Limestone | Texas | 48293 | 5043 | 118 |
2229007 | 2229007 | 2022-02-18 | Limestone | Texas | 48293 | 5040 | 118 |
2225756 | 2225756 | 2022-02-17 | Limestone | Texas | 48293 | 5039 | 118 |
2222505 | 2222505 | 2022-02-16 | Limestone | Texas | 48293 | 5030 | 118 |
2219254 | 2219254 | 2022-02-15 | Limestone | Texas | 48293 | 5024 | 118 |
2212788 | 2212788 | 2022-02-13 | Panola | Texas | 48365 | 4337 | 118 |
2209535 | 2209535 | 2022-02-12 | Panola | Texas | 48365 | 4335 | 118 |
2193309 | 2193309 | 2022-02-07 | Titus | Texas | 48449 | 8042 | 118 |
2190055 | 2190055 | 2022-02-06 | Titus | Texas | 48449 | 8038 | 118 |
2186802 | 2186802 | 2022-02-05 | Titus | Texas | 48449 | 8032 | 118 |
2177032 | 2177032 | 2022-02-02 | Shelby | Texas | 48419 | 4154 | 118 |
2173617 | 2173617 | 2022-02-01 | Cooke | Texas | 48097 | 6920 | 118 |
2173778 | 2173778 | 2022-02-01 | Shelby | Texas | 48419 | 4147 | 118 |
2173814 | 2173814 | 2022-02-01 | Willacy | Texas | 48489 | 6368 | 118 |
2170365 | 2170365 | 2022-01-31 | Cooke | Texas | 48097 | 6883 | 118 |
2170562 | 2170562 | 2022-01-31 | Willacy | Texas | 48489 | 6340 | 118 |
2167111 | 2167111 | 2022-01-30 | Cooke | Texas | 48097 | 6862 | 118 |
2167308 | 2167308 | 2022-01-30 | Willacy | Texas | 48489 | 6303 | 118 |
2163856 | 2163856 | 2022-01-29 | Cooke | Texas | 48097 | 6841 | 118 |
2164053 | 2164053 | 2022-01-29 | Willacy | Texas | 48489 | 6263 | 118 |
2160601 | 2160601 | 2022-01-28 | Cooke | Texas | 48097 | 6797 | 118 |
2160798 | 2160798 | 2022-01-28 | Willacy | Texas | 48489 | 6215 | 118 |
2157345 | 2157345 | 2022-01-27 | Cooke | Texas | 48097 | 6757 | 118 |
2157542 | 2157542 | 2022-01-27 | Willacy | Texas | 48489 | 6174 | 118 |
2154289 | 2154289 | 2022-01-26 | Willacy | Texas | 48489 | 6122 | 118 |
2131385 | 2131385 | 2022-01-19 | Hutchinson | Texas | 48233 | 5901 | 118 |
2128131 | 2128131 | 2022-01-18 | Hutchinson | Texas | 48233 | 5892 | 118 |
2124879 | 2124879 | 2022-01-17 | Hutchinson | Texas | 48233 | 5876 | 118 |
2121627 | 2121627 | 2022-01-16 | Hutchinson | Texas | 48233 | 5792 | 118 |
2118375 | 2118375 | 2022-01-15 | Hutchinson | Texas | 48233 | 5746 | 118 |
2053469 | 2053469 | 2021-12-26 | Uvalde | Texas | 48463 | 6494 | 118 |
2050219 | 2050219 | 2021-12-25 | Uvalde | Texas | 48463 | 6494 | 118 |
2046969 | 2046969 | 2021-12-24 | Uvalde | Texas | 48463 | 6494 | 118 |
2043719 | 2043719 | 2021-12-23 | Uvalde | Texas | 48463 | 6494 | 118 |
2040470 | 2040470 | 2021-12-22 | Uvalde | Texas | 48463 | 6494 | 118 |
2037220 | 2037220 | 2021-12-21 | Uvalde | Texas | 48463 | 6489 | 118 |
2033970 | 2033970 | 2021-12-20 | Uvalde | Texas | 48463 | 6485 | 118 |
2030720 | 2030720 | 2021-12-19 | Uvalde | Texas | 48463 | 6479 | 118 |
2027469 | 2027469 | 2021-12-18 | Uvalde | Texas | 48463 | 6477 | 118 |
2024218 | 2024218 | 2021-12-17 | Uvalde | Texas | 48463 | 6477 | 118 |
2020967 | 2020967 | 2021-12-16 | Uvalde | Texas | 48463 | 6474 | 118 |
2017716 | 2017716 | 2021-12-15 | Uvalde | Texas | 48463 | 6469 | 118 |
2014466 | 2014466 | 2021-12-14 | Uvalde | Texas | 48463 | 6457 | 118 |
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);