ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
321 rows where deaths = 122 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502347 | 2502347 | 2022-05-13 | Lamb | Texas | 48279 | 4356 | 122 |
2499089 | 2499089 | 2022-05-12 | Lamb | Texas | 48279 | 4356 | 122 |
2495831 | 2495831 | 2022-05-11 | Lamb | Texas | 48279 | 4355 | 122 |
2492573 | 2492573 | 2022-05-10 | Lamb | Texas | 48279 | 4355 | 122 |
2489315 | 2489315 | 2022-05-09 | Lamb | Texas | 48279 | 4355 | 122 |
2486058 | 2486058 | 2022-05-08 | Lamb | Texas | 48279 | 4355 | 122 |
2482800 | 2482800 | 2022-05-07 | Lamb | Texas | 48279 | 4355 | 122 |
2479542 | 2479542 | 2022-05-06 | Lamb | Texas | 48279 | 4355 | 122 |
2476284 | 2476284 | 2022-05-05 | Lamb | Texas | 48279 | 4354 | 122 |
2473027 | 2473027 | 2022-05-04 | Lamb | Texas | 48279 | 4354 | 122 |
2469771 | 2469771 | 2022-05-03 | Lamb | Texas | 48279 | 4354 | 122 |
2466515 | 2466515 | 2022-05-02 | Lamb | Texas | 48279 | 4354 | 122 |
2463260 | 2463260 | 2022-05-01 | Lamb | Texas | 48279 | 4354 | 122 |
2460004 | 2460004 | 2022-04-30 | Lamb | Texas | 48279 | 4354 | 122 |
2456748 | 2456748 | 2022-04-29 | Lamb | Texas | 48279 | 4352 | 122 |
2453492 | 2453492 | 2022-04-28 | Lamb | Texas | 48279 | 4352 | 122 |
2450236 | 2450236 | 2022-04-27 | Lamb | Texas | 48279 | 4351 | 122 |
2446979 | 2446979 | 2022-04-26 | Lamb | Texas | 48279 | 4351 | 122 |
2443724 | 2443724 | 2022-04-25 | Lamb | Texas | 48279 | 4351 | 122 |
2440468 | 2440468 | 2022-04-24 | Lamb | Texas | 48279 | 4351 | 122 |
2437212 | 2437212 | 2022-04-23 | Lamb | Texas | 48279 | 4351 | 122 |
2433956 | 2433956 | 2022-04-22 | Lamb | Texas | 48279 | 4351 | 122 |
2430700 | 2430700 | 2022-04-21 | Lamb | Texas | 48279 | 4347 | 122 |
2427444 | 2427444 | 2022-04-20 | Lamb | Texas | 48279 | 4345 | 122 |
2424188 | 2424188 | 2022-04-19 | Lamb | Texas | 48279 | 4342 | 122 |
2420932 | 2420932 | 2022-04-18 | Lamb | Texas | 48279 | 4341 | 122 |
2417676 | 2417676 | 2022-04-17 | Lamb | Texas | 48279 | 4341 | 122 |
2414420 | 2414420 | 2022-04-16 | Lamb | Texas | 48279 | 4341 | 122 |
2411164 | 2411164 | 2022-04-15 | Lamb | Texas | 48279 | 4341 | 122 |
2407908 | 2407908 | 2022-04-14 | Lamb | Texas | 48279 | 4341 | 122 |
2404652 | 2404652 | 2022-04-13 | Lamb | Texas | 48279 | 4340 | 122 |
2401397 | 2401397 | 2022-04-12 | Lamb | Texas | 48279 | 4338 | 122 |
2398142 | 2398142 | 2022-04-11 | Lamb | Texas | 48279 | 4337 | 122 |
2394887 | 2394887 | 2022-04-10 | Lamb | Texas | 48279 | 4337 | 122 |
2391631 | 2391631 | 2022-04-09 | Lamb | Texas | 48279 | 4336 | 122 |
2388375 | 2388375 | 2022-04-08 | Lamb | Texas | 48279 | 4327 | 122 |
2385120 | 2385120 | 2022-04-07 | Lamb | Texas | 48279 | 4326 | 122 |
2381865 | 2381865 | 2022-04-06 | Lamb | Texas | 48279 | 4325 | 122 |
2378610 | 2378610 | 2022-04-05 | Lamb | Texas | 48279 | 4325 | 122 |
2375356 | 2375356 | 2022-04-04 | Lamb | Texas | 48279 | 4325 | 122 |
2372104 | 2372104 | 2022-04-03 | Lamb | Texas | 48279 | 4325 | 122 |
2368851 | 2368851 | 2022-04-02 | Lamb | Texas | 48279 | 4325 | 122 |
2365598 | 2365598 | 2022-04-01 | Lamb | Texas | 48279 | 4322 | 122 |
2362345 | 2362345 | 2022-03-31 | Lamb | Texas | 48279 | 4320 | 122 |
2359091 | 2359091 | 2022-03-30 | Lamb | Texas | 48279 | 4320 | 122 |
2355837 | 2355837 | 2022-03-29 | Lamb | Texas | 48279 | 4320 | 122 |
2352584 | 2352584 | 2022-03-28 | Lamb | Texas | 48279 | 4318 | 122 |
2349332 | 2349332 | 2022-03-27 | Lamb | Texas | 48279 | 4318 | 122 |
2346079 | 2346079 | 2022-03-26 | Lamb | Texas | 48279 | 4318 | 122 |
2342826 | 2342826 | 2022-03-25 | Lamb | Texas | 48279 | 4317 | 122 |
2339573 | 2339573 | 2022-03-24 | Lamb | Texas | 48279 | 4315 | 122 |
2336319 | 2336319 | 2022-03-23 | Lamb | Texas | 48279 | 4312 | 122 |
2333065 | 2333065 | 2022-03-22 | Lamb | Texas | 48279 | 4312 | 122 |
2329812 | 2329812 | 2022-03-21 | Lamb | Texas | 48279 | 4312 | 122 |
2326560 | 2326560 | 2022-03-20 | Lamb | Texas | 48279 | 4311 | 122 |
2323307 | 2323307 | 2022-03-19 | Lamb | Texas | 48279 | 4311 | 122 |
2320053 | 2320053 | 2022-03-18 | Lamb | Texas | 48279 | 4308 | 122 |
2316799 | 2316799 | 2022-03-17 | Lamb | Texas | 48279 | 4302 | 122 |
2316827 | 2316827 | 2022-03-17 | Montague | Texas | 48337 | 4638 | 122 |
2313546 | 2313546 | 2022-03-16 | Lamb | Texas | 48279 | 4302 | 122 |
2313574 | 2313574 | 2022-03-16 | Montague | Texas | 48337 | 4633 | 122 |
2310293 | 2310293 | 2022-03-15 | Lamb | Texas | 48279 | 4302 | 122 |
2310321 | 2310321 | 2022-03-15 | Montague | Texas | 48337 | 4633 | 122 |
2307040 | 2307040 | 2022-03-14 | Lamb | Texas | 48279 | 4298 | 122 |
2307068 | 2307068 | 2022-03-14 | Montague | Texas | 48337 | 4630 | 122 |
2303789 | 2303789 | 2022-03-13 | Lamb | Texas | 48279 | 4298 | 122 |
2303817 | 2303817 | 2022-03-13 | Montague | Texas | 48337 | 4630 | 122 |
2300486 | 2300486 | 2022-03-12 | Gray | Texas | 48179 | 6113 | 122 |
2300537 | 2300537 | 2022-03-12 | Lamb | Texas | 48279 | 4298 | 122 |
2300543 | 2300543 | 2022-03-12 | Limestone | Texas | 48293 | 5068 | 122 |
2300565 | 2300565 | 2022-03-12 | Montague | Texas | 48337 | 4630 | 122 |
2297234 | 2297234 | 2022-03-11 | Gray | Texas | 48179 | 6110 | 122 |
2297285 | 2297285 | 2022-03-11 | Lamb | Texas | 48279 | 4297 | 122 |
2297291 | 2297291 | 2022-03-11 | Limestone | Texas | 48293 | 5068 | 122 |
2297313 | 2297313 | 2022-03-11 | Montague | Texas | 48337 | 4628 | 122 |
2293982 | 2293982 | 2022-03-10 | Gray | Texas | 48179 | 6099 | 122 |
2294033 | 2294033 | 2022-03-10 | Lamb | Texas | 48279 | 4293 | 122 |
2294039 | 2294039 | 2022-03-10 | Limestone | Texas | 48293 | 5068 | 122 |
2294061 | 2294061 | 2022-03-10 | Montague | Texas | 48337 | 4628 | 122 |
2290730 | 2290730 | 2022-03-09 | Gray | Texas | 48179 | 6096 | 122 |
2290781 | 2290781 | 2022-03-09 | Lamb | Texas | 48279 | 4290 | 122 |
2290787 | 2290787 | 2022-03-09 | Limestone | Texas | 48293 | 5067 | 122 |
2290809 | 2290809 | 2022-03-09 | Montague | Texas | 48337 | 4628 | 122 |
2287460 | 2287460 | 2022-03-08 | Erath | Texas | 48143 | 8627 | 122 |
2287478 | 2287478 | 2022-03-08 | Gray | Texas | 48179 | 6091 | 122 |
2287529 | 2287529 | 2022-03-08 | Lamb | Texas | 48279 | 4287 | 122 |
2287535 | 2287535 | 2022-03-08 | Limestone | Texas | 48293 | 5066 | 122 |
2287557 | 2287557 | 2022-03-08 | Montague | Texas | 48337 | 4626 | 122 |
2284208 | 2284208 | 2022-03-07 | Erath | Texas | 48143 | 8620 | 122 |
2284226 | 2284226 | 2022-03-07 | Gray | Texas | 48179 | 6087 | 122 |
2284277 | 2284277 | 2022-03-07 | Lamb | Texas | 48279 | 4280 | 122 |
2284283 | 2284283 | 2022-03-07 | Limestone | Texas | 48293 | 5064 | 122 |
2284305 | 2284305 | 2022-03-07 | Montague | Texas | 48337 | 4626 | 122 |
2280956 | 2280956 | 2022-03-06 | Erath | Texas | 48143 | 8620 | 122 |
2280974 | 2280974 | 2022-03-06 | Gray | Texas | 48179 | 6087 | 122 |
2281025 | 2281025 | 2022-03-06 | Lamb | Texas | 48279 | 4279 | 122 |
2281031 | 2281031 | 2022-03-06 | Limestone | Texas | 48293 | 5062 | 122 |
2281053 | 2281053 | 2022-03-06 | Montague | Texas | 48337 | 4625 | 122 |
2277703 | 2277703 | 2022-03-05 | Erath | Texas | 48143 | 8620 | 122 |
2277721 | 2277721 | 2022-03-05 | Gray | Texas | 48179 | 6087 | 122 |
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);