ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
197 rows where deaths = 175 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502364 | 2502364 | 2022-05-13 | Matagorda | Texas | 48321 | 8374 | 175 |
2499106 | 2499106 | 2022-05-12 | Matagorda | Texas | 48321 | 8368 | 175 |
2495848 | 2495848 | 2022-05-11 | Matagorda | Texas | 48321 | 8367 | 175 |
2492590 | 2492590 | 2022-05-10 | Matagorda | Texas | 48321 | 8366 | 175 |
2489332 | 2489332 | 2022-05-09 | Matagorda | Texas | 48321 | 8366 | 175 |
2486075 | 2486075 | 2022-05-08 | Matagorda | Texas | 48321 | 8364 | 175 |
2482817 | 2482817 | 2022-05-07 | Matagorda | Texas | 48321 | 8364 | 175 |
2479559 | 2479559 | 2022-05-06 | Matagorda | Texas | 48321 | 8361 | 175 |
2476301 | 2476301 | 2022-05-05 | Matagorda | Texas | 48321 | 8360 | 175 |
2473044 | 2473044 | 2022-05-04 | Matagorda | Texas | 48321 | 8360 | 175 |
2469788 | 2469788 | 2022-05-03 | Matagorda | Texas | 48321 | 8359 | 175 |
2466402 | 2466402 | 2022-05-02 | Caldwell | Texas | 48055 | 14272 | 175 |
2466532 | 2466532 | 2022-05-02 | Matagorda | Texas | 48321 | 8359 | 175 |
2463147 | 2463147 | 2022-05-01 | Caldwell | Texas | 48055 | 14268 | 175 |
2463277 | 2463277 | 2022-05-01 | Matagorda | Texas | 48321 | 8358 | 175 |
2459891 | 2459891 | 2022-04-30 | Caldwell | Texas | 48055 | 14259 | 175 |
2460021 | 2460021 | 2022-04-30 | Matagorda | Texas | 48321 | 8357 | 175 |
2456635 | 2456635 | 2022-04-29 | Caldwell | Texas | 48055 | 14259 | 175 |
2456765 | 2456765 | 2022-04-29 | Matagorda | Texas | 48321 | 8357 | 175 |
2453379 | 2453379 | 2022-04-28 | Caldwell | Texas | 48055 | 14255 | 175 |
2453509 | 2453509 | 2022-04-28 | Matagorda | Texas | 48321 | 8354 | 175 |
2450123 | 2450123 | 2022-04-27 | Caldwell | Texas | 48055 | 14251 | 175 |
2450253 | 2450253 | 2022-04-27 | Matagorda | Texas | 48321 | 8352 | 175 |
2446866 | 2446866 | 2022-04-26 | Caldwell | Texas | 48055 | 14246 | 175 |
2446996 | 2446996 | 2022-04-26 | Matagorda | Texas | 48321 | 8351 | 175 |
2443611 | 2443611 | 2022-04-25 | Caldwell | Texas | 48055 | 14242 | 175 |
2443741 | 2443741 | 2022-04-25 | Matagorda | Texas | 48321 | 8348 | 175 |
2440355 | 2440355 | 2022-04-24 | Caldwell | Texas | 48055 | 14236 | 175 |
2440485 | 2440485 | 2022-04-24 | Matagorda | Texas | 48321 | 8348 | 175 |
2437099 | 2437099 | 2022-04-23 | Caldwell | Texas | 48055 | 14232 | 175 |
2437229 | 2437229 | 2022-04-23 | Matagorda | Texas | 48321 | 8348 | 175 |
2433843 | 2433843 | 2022-04-22 | Caldwell | Texas | 48055 | 14230 | 175 |
2433973 | 2433973 | 2022-04-22 | Matagorda | Texas | 48321 | 8348 | 175 |
2430587 | 2430587 | 2022-04-21 | Caldwell | Texas | 48055 | 14222 | 175 |
2430717 | 2430717 | 2022-04-21 | Matagorda | Texas | 48321 | 8346 | 175 |
2427331 | 2427331 | 2022-04-20 | Caldwell | Texas | 48055 | 14221 | 175 |
2427461 | 2427461 | 2022-04-20 | Matagorda | Texas | 48321 | 8343 | 175 |
2424075 | 2424075 | 2022-04-19 | Caldwell | Texas | 48055 | 14219 | 175 |
2424205 | 2424205 | 2022-04-19 | Matagorda | Texas | 48321 | 8343 | 175 |
2420819 | 2420819 | 2022-04-18 | Caldwell | Texas | 48055 | 14216 | 175 |
2420949 | 2420949 | 2022-04-18 | Matagorda | Texas | 48321 | 8341 | 175 |
2417563 | 2417563 | 2022-04-17 | Caldwell | Texas | 48055 | 14205 | 175 |
2417693 | 2417693 | 2022-04-17 | Matagorda | Texas | 48321 | 8340 | 175 |
2414307 | 2414307 | 2022-04-16 | Caldwell | Texas | 48055 | 14205 | 175 |
2414437 | 2414437 | 2022-04-16 | Matagorda | Texas | 48321 | 8340 | 175 |
2411051 | 2411051 | 2022-04-15 | Caldwell | Texas | 48055 | 14205 | 175 |
2411181 | 2411181 | 2022-04-15 | Matagorda | Texas | 48321 | 8340 | 175 |
2407795 | 2407795 | 2022-04-14 | Caldwell | Texas | 48055 | 14205 | 175 |
2407925 | 2407925 | 2022-04-14 | Matagorda | Texas | 48321 | 8340 | 175 |
2404539 | 2404539 | 2022-04-13 | Caldwell | Texas | 48055 | 14200 | 175 |
2404669 | 2404669 | 2022-04-13 | Matagorda | Texas | 48321 | 8337 | 175 |
2401284 | 2401284 | 2022-04-12 | Caldwell | Texas | 48055 | 14199 | 175 |
2401414 | 2401414 | 2022-04-12 | Matagorda | Texas | 48321 | 8333 | 175 |
2398029 | 2398029 | 2022-04-11 | Caldwell | Texas | 48055 | 14195 | 175 |
2398159 | 2398159 | 2022-04-11 | Matagorda | Texas | 48321 | 8329 | 175 |
2394774 | 2394774 | 2022-04-10 | Caldwell | Texas | 48055 | 14194 | 175 |
2394904 | 2394904 | 2022-04-10 | Matagorda | Texas | 48321 | 8329 | 175 |
2391518 | 2391518 | 2022-04-09 | Caldwell | Texas | 48055 | 14192 | 175 |
2391648 | 2391648 | 2022-04-09 | Matagorda | Texas | 48321 | 8328 | 175 |
2388262 | 2388262 | 2022-04-08 | Caldwell | Texas | 48055 | 14192 | 175 |
2388392 | 2388392 | 2022-04-08 | Matagorda | Texas | 48321 | 8324 | 175 |
2385007 | 2385007 | 2022-04-07 | Caldwell | Texas | 48055 | 14188 | 175 |
2385137 | 2385137 | 2022-04-07 | Matagorda | Texas | 48321 | 8322 | 175 |
2381752 | 2381752 | 2022-04-06 | Caldwell | Texas | 48055 | 14187 | 175 |
2381882 | 2381882 | 2022-04-06 | Matagorda | Texas | 48321 | 8317 | 175 |
2378497 | 2378497 | 2022-04-05 | Caldwell | Texas | 48055 | 14182 | 175 |
2378627 | 2378627 | 2022-04-05 | Matagorda | Texas | 48321 | 8316 | 175 |
2375243 | 2375243 | 2022-04-04 | Caldwell | Texas | 48055 | 14182 | 175 |
2375373 | 2375373 | 2022-04-04 | Matagorda | Texas | 48321 | 8313 | 175 |
2371991 | 2371991 | 2022-04-03 | Caldwell | Texas | 48055 | 14179 | 175 |
2372121 | 2372121 | 2022-04-03 | Matagorda | Texas | 48321 | 8313 | 175 |
2368738 | 2368738 | 2022-04-02 | Caldwell | Texas | 48055 | 14174 | 175 |
2368868 | 2368868 | 2022-04-02 | Matagorda | Texas | 48321 | 8312 | 175 |
2365485 | 2365485 | 2022-04-01 | Caldwell | Texas | 48055 | 14169 | 175 |
2365615 | 2365615 | 2022-04-01 | Matagorda | Texas | 48321 | 8306 | 175 |
2362232 | 2362232 | 2022-03-31 | Caldwell | Texas | 48055 | 14161 | 175 |
2362362 | 2362362 | 2022-03-31 | Matagorda | Texas | 48321 | 8304 | 175 |
2358978 | 2358978 | 2022-03-30 | Caldwell | Texas | 48055 | 14160 | 175 |
2359108 | 2359108 | 2022-03-30 | Matagorda | Texas | 48321 | 8302 | 175 |
2355724 | 2355724 | 2022-03-29 | Caldwell | Texas | 48055 | 14158 | 175 |
2355854 | 2355854 | 2022-03-29 | Matagorda | Texas | 48321 | 8298 | 175 |
2352471 | 2352471 | 2022-03-28 | Caldwell | Texas | 48055 | 14144 | 175 |
2352601 | 2352601 | 2022-03-28 | Matagorda | Texas | 48321 | 8291 | 175 |
2349219 | 2349219 | 2022-03-27 | Caldwell | Texas | 48055 | 14142 | 175 |
2349349 | 2349349 | 2022-03-27 | Matagorda | Texas | 48321 | 8291 | 175 |
2345966 | 2345966 | 2022-03-26 | Caldwell | Texas | 48055 | 14142 | 175 |
2346096 | 2346096 | 2022-03-26 | Matagorda | Texas | 48321 | 8291 | 175 |
2342713 | 2342713 | 2022-03-25 | Caldwell | Texas | 48055 | 14138 | 175 |
2342843 | 2342843 | 2022-03-25 | Matagorda | Texas | 48321 | 8280 | 175 |
2339460 | 2339460 | 2022-03-24 | Caldwell | Texas | 48055 | 14138 | 175 |
2339590 | 2339590 | 2022-03-24 | Matagorda | Texas | 48321 | 8276 | 175 |
2336206 | 2336206 | 2022-03-23 | Caldwell | Texas | 48055 | 14137 | 175 |
2336336 | 2336336 | 2022-03-23 | Matagorda | Texas | 48321 | 8272 | 175 |
2332952 | 2332952 | 2022-03-22 | Caldwell | Texas | 48055 | 14132 | 175 |
2329699 | 2329699 | 2022-03-21 | Caldwell | Texas | 48055 | 14130 | 175 |
2326447 | 2326447 | 2022-03-20 | Caldwell | Texas | 48055 | 14130 | 175 |
2323194 | 2323194 | 2022-03-19 | Caldwell | Texas | 48055 | 14129 | 175 |
2319940 | 2319940 | 2022-03-18 | Caldwell | Texas | 48055 | 14128 | 175 |
2316686 | 2316686 | 2022-03-17 | Caldwell | Texas | 48055 | 14128 | 175 |
2313433 | 2313433 | 2022-03-16 | Caldwell | Texas | 48055 | 14125 | 175 |
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);