ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where deaths = 247 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502394 | 2502394 | 2022-05-13 | Polk | Texas | 48373 | 7896 | 247 |
2499136 | 2499136 | 2022-05-12 | Polk | Texas | 48373 | 7895 | 247 |
2495878 | 2495878 | 2022-05-11 | Polk | Texas | 48373 | 7893 | 247 |
2492620 | 2492620 | 2022-05-10 | Polk | Texas | 48373 | 7893 | 247 |
2489362 | 2489362 | 2022-05-09 | Polk | Texas | 48373 | 7892 | 247 |
2486104 | 2486104 | 2022-05-08 | Polk | Texas | 48373 | 7889 | 247 |
2482846 | 2482846 | 2022-05-07 | Polk | Texas | 48373 | 7888 | 247 |
2479588 | 2479588 | 2022-05-06 | Polk | Texas | 48373 | 7888 | 247 |
2476330 | 2476330 | 2022-05-05 | Polk | Texas | 48373 | 7887 | 247 |
2473073 | 2473073 | 2022-05-04 | Polk | Texas | 48373 | 7885 | 247 |
2469817 | 2469817 | 2022-05-03 | Polk | Texas | 48373 | 7884 | 247 |
2466561 | 2466561 | 2022-05-02 | Polk | Texas | 48373 | 7884 | 247 |
2463306 | 2463306 | 2022-05-01 | Polk | Texas | 48373 | 7884 | 247 |
2460050 | 2460050 | 2022-04-30 | Polk | Texas | 48373 | 7880 | 247 |
2456794 | 2456794 | 2022-04-29 | Polk | Texas | 48373 | 7876 | 247 |
2453538 | 2453538 | 2022-04-28 | Polk | Texas | 48373 | 7873 | 247 |
2450282 | 2450282 | 2022-04-27 | Polk | Texas | 48373 | 7844 | 247 |
2447025 | 2447025 | 2022-04-26 | Polk | Texas | 48373 | 7839 | 247 |
2443770 | 2443770 | 2022-04-25 | Polk | Texas | 48373 | 7838 | 247 |
2440514 | 2440514 | 2022-04-24 | Polk | Texas | 48373 | 7835 | 247 |
2437258 | 2437258 | 2022-04-23 | Polk | Texas | 48373 | 7834 | 247 |
2434002 | 2434002 | 2022-04-22 | Polk | Texas | 48373 | 7834 | 247 |
2430746 | 2430746 | 2022-04-21 | Polk | Texas | 48373 | 7832 | 247 |
2427490 | 2427490 | 2022-04-20 | Polk | Texas | 48373 | 7832 | 247 |
2424234 | 2424234 | 2022-04-19 | Polk | Texas | 48373 | 7832 | 247 |
2420978 | 2420978 | 2022-04-18 | Polk | Texas | 48373 | 7831 | 247 |
2417722 | 2417722 | 2022-04-17 | Polk | Texas | 48373 | 7827 | 247 |
2414466 | 2414466 | 2022-04-16 | Polk | Texas | 48373 | 7827 | 247 |
2411210 | 2411210 | 2022-04-15 | Polk | Texas | 48373 | 7827 | 247 |
2407954 | 2407954 | 2022-04-14 | Polk | Texas | 48373 | 7827 | 247 |
2404698 | 2404698 | 2022-04-13 | Polk | Texas | 48373 | 7827 | 247 |
2401443 | 2401443 | 2022-04-12 | Polk | Texas | 48373 | 7826 | 247 |
2398188 | 2398188 | 2022-04-11 | Polk | Texas | 48373 | 7825 | 247 |
2394933 | 2394933 | 2022-04-10 | Polk | Texas | 48373 | 7823 | 247 |
2391677 | 2391677 | 2022-04-09 | Polk | Texas | 48373 | 7821 | 247 |
2388421 | 2388421 | 2022-04-08 | Polk | Texas | 48373 | 7820 | 247 |
2385166 | 2385166 | 2022-04-07 | Polk | Texas | 48373 | 7819 | 247 |
2381911 | 2381911 | 2022-04-06 | Polk | Texas | 48373 | 7819 | 247 |
2378656 | 2378656 | 2022-04-05 | Polk | Texas | 48373 | 7818 | 247 |
2375402 | 2375402 | 2022-04-04 | Polk | Texas | 48373 | 7818 | 247 |
2372150 | 2372150 | 2022-04-03 | Polk | Texas | 48373 | 7817 | 247 |
2368897 | 2368897 | 2022-04-02 | Polk | Texas | 48373 | 7816 | 247 |
2365644 | 2365644 | 2022-04-01 | Polk | Texas | 48373 | 7815 | 247 |
2362391 | 2362391 | 2022-03-31 | Polk | Texas | 48373 | 7815 | 247 |
2359137 | 2359137 | 2022-03-30 | Polk | Texas | 48373 | 7812 | 247 |
2355883 | 2355883 | 2022-03-29 | Polk | Texas | 48373 | 7811 | 247 |
2352630 | 2352630 | 2022-03-28 | Polk | Texas | 48373 | 7809 | 247 |
2349378 | 2349378 | 2022-03-27 | Polk | Texas | 48373 | 7809 | 247 |
2346125 | 2346125 | 2022-03-26 | Polk | Texas | 48373 | 7808 | 247 |
2342872 | 2342872 | 2022-03-25 | Polk | Texas | 48373 | 7807 | 247 |
2339619 | 2339619 | 2022-03-24 | Polk | Texas | 48373 | 7807 | 247 |
2336365 | 2336365 | 2022-03-23 | Polk | Texas | 48373 | 7807 | 247 |
2333111 | 2333111 | 2022-03-22 | Polk | Texas | 48373 | 7801 | 247 |
2329858 | 2329858 | 2022-03-21 | Polk | Texas | 48373 | 7800 | 247 |
2326606 | 2326606 | 2022-03-20 | Polk | Texas | 48373 | 7799 | 247 |
2323353 | 2323353 | 2022-03-19 | Polk | Texas | 48373 | 7797 | 247 |
2313592 | 2313592 | 2022-03-16 | Polk | Texas | 48373 | 7792 | 247 |
2310339 | 2310339 | 2022-03-15 | Polk | Texas | 48373 | 7792 | 247 |
2307086 | 2307086 | 2022-03-14 | Polk | Texas | 48373 | 7792 | 247 |
2303835 | 2303835 | 2022-03-13 | Polk | Texas | 48373 | 7792 | 247 |
2300583 | 2300583 | 2022-03-12 | Polk | Texas | 48373 | 7791 | 247 |
2293992 | 2293992 | 2022-03-10 | Hardin | Texas | 48199 | 12002 | 247 |
2290740 | 2290740 | 2022-03-09 | Hardin | Texas | 48199 | 12001 | 247 |
2274415 | 2274415 | 2022-03-04 | Cherokee | Texas | 48073 | 7920 | 247 |
2242004 | 2242004 | 2022-02-22 | Lamar | Texas | 48277 | 12313 | 247 |
2225858 | 2225858 | 2022-02-17 | Wise | Texas | 48497 | 16670 | 247 |
2222557 | 2222557 | 2022-02-16 | Rockwall | Texas | 48397 | 25827 | 247 |
2222607 | 2222607 | 2022-02-16 | Wise | Texas | 48497 | 16655 | 247 |
2219306 | 2219306 | 2022-02-15 | Rockwall | Texas | 48397 | 25814 | 247 |
2209463 | 2209463 | 2022-02-12 | Hood | Texas | 48221 | 13087 | 247 |
2199766 | 2199766 | 2022-02-09 | Nacogdoches | Texas | 48347 | 11562 | 247 |
2196512 | 2196512 | 2022-02-08 | Nacogdoches | Texas | 48347 | 11534 | 247 |
2193258 | 2193258 | 2022-02-07 | Nacogdoches | Texas | 48347 | 11519 | 247 |
2190004 | 2190004 | 2022-02-06 | Nacogdoches | Texas | 48347 | 11504 | 247 |
2186751 | 2186751 | 2022-02-05 | Nacogdoches | Texas | 48347 | 11477 | 247 |
2183499 | 2183499 | 2022-02-04 | Nacogdoches | Texas | 48347 | 11427 | 247 |
2180247 | 2180247 | 2022-02-03 | Nacogdoches | Texas | 48347 | 11399 | 247 |
2170551 | 2170551 | 2022-01-31 | Van Zandt | Texas | 48467 | 9810 | 247 |
2167297 | 2167297 | 2022-01-30 | Van Zandt | Texas | 48467 | 9759 | 247 |
2128265 | 2128265 | 2022-01-18 | Wood | Texas | 48499 | 6917 | 247 |
2125013 | 2125013 | 2022-01-17 | Wood | Texas | 48499 | 6870 | 247 |
2121761 | 2121761 | 2022-01-16 | Wood | Texas | 48499 | 6804 | 247 |
2118509 | 2118509 | 2022-01-15 | Wood | Texas | 48499 | 6787 | 247 |
2115257 | 2115257 | 2022-01-14 | Wood | Texas | 48499 | 6721 | 247 |
1835716 | 1835716 | 2021-10-20 | Val Verde | Texas | 48465 | 10558 | 247 |
1773931 | 1773931 | 2021-10-01 | Orange | Texas | 48361 | 13443 | 247 |
1738196 | 1738196 | 2021-09-20 | Parker | Texas | 48367 | 21702 | 247 |
1692552 | 1692552 | 2021-09-06 | Bowie | Texas | 48037 | 10658 | 247 |
1689303 | 1689303 | 2021-09-05 | Bowie | Texas | 48037 | 10588 | 247 |
1686053 | 1686053 | 2021-09-04 | Bowie | Texas | 48037 | 10501 | 247 |
1669884 | 1669884 | 2021-08-30 | Guadalupe | Texas | 48187 | 19561 | 247 |
1666637 | 1666637 | 2021-08-29 | Guadalupe | Texas | 48187 | 19555 | 247 |
1663389 | 1663389 | 2021-08-28 | Guadalupe | Texas | 48187 | 19555 | 247 |
1660141 | 1660141 | 2021-08-27 | Guadalupe | Texas | 48187 | 19547 | 247 |
1377665 | 1377665 | 2021-06-01 | Hays | Texas | 48209 | 20931 | 247 |
1374419 | 1374419 | 2021-05-31 | Hays | Texas | 48209 | 20914 | 247 |
1371174 | 1371174 | 2021-05-30 | Hays | Texas | 48209 | 20914 | 247 |
1367928 | 1367928 | 2021-05-29 | Hays | Texas | 48209 | 20914 | 247 |
1364682 | 1364682 | 2021-05-28 | Hays | Texas | 48209 | 20921 | 247 |
1361436 | 1361436 | 2021-05-27 | Hays | Texas | 48209 | 20921 | 247 |
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);