ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
421 rows where deaths = 78 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502253 | 2502253 | 2022-05-13 | Comanche | Texas | 48093 | 3698 | 78 |
2498995 | 2498995 | 2022-05-12 | Comanche | Texas | 48093 | 3698 | 78 |
2495737 | 2495737 | 2022-05-11 | Comanche | Texas | 48093 | 3698 | 78 |
2492479 | 2492479 | 2022-05-10 | Comanche | Texas | 48093 | 3697 | 78 |
2489221 | 2489221 | 2022-05-09 | Comanche | Texas | 48093 | 3697 | 78 |
2485964 | 2485964 | 2022-05-08 | Comanche | Texas | 48093 | 3697 | 78 |
2482706 | 2482706 | 2022-05-07 | Comanche | Texas | 48093 | 3697 | 78 |
2479448 | 2479448 | 2022-05-06 | Comanche | Texas | 48093 | 3697 | 78 |
2476190 | 2476190 | 2022-05-05 | Comanche | Texas | 48093 | 3697 | 78 |
2472933 | 2472933 | 2022-05-04 | Comanche | Texas | 48093 | 3695 | 78 |
2469677 | 2469677 | 2022-05-03 | Comanche | Texas | 48093 | 3688 | 78 |
2466421 | 2466421 | 2022-05-02 | Comanche | Texas | 48093 | 3688 | 78 |
2463166 | 2463166 | 2022-05-01 | Comanche | Texas | 48093 | 3688 | 78 |
2459910 | 2459910 | 2022-04-30 | Comanche | Texas | 48093 | 3688 | 78 |
2456654 | 2456654 | 2022-04-29 | Comanche | Texas | 48093 | 3684 | 78 |
2453398 | 2453398 | 2022-04-28 | Comanche | Texas | 48093 | 3676 | 78 |
2450142 | 2450142 | 2022-04-27 | Comanche | Texas | 48093 | 3654 | 78 |
2446885 | 2446885 | 2022-04-26 | Comanche | Texas | 48093 | 3640 | 78 |
2443630 | 2443630 | 2022-04-25 | Comanche | Texas | 48093 | 3632 | 78 |
2440374 | 2440374 | 2022-04-24 | Comanche | Texas | 48093 | 3632 | 78 |
2437118 | 2437118 | 2022-04-23 | Comanche | Texas | 48093 | 3632 | 78 |
2433862 | 2433862 | 2022-04-22 | Comanche | Texas | 48093 | 3631 | 78 |
2430606 | 2430606 | 2022-04-21 | Comanche | Texas | 48093 | 3631 | 78 |
2427350 | 2427350 | 2022-04-20 | Comanche | Texas | 48093 | 3629 | 78 |
2424094 | 2424094 | 2022-04-19 | Comanche | Texas | 48093 | 3627 | 78 |
2420838 | 2420838 | 2022-04-18 | Comanche | Texas | 48093 | 3615 | 78 |
2417582 | 2417582 | 2022-04-17 | Comanche | Texas | 48093 | 3599 | 78 |
2414326 | 2414326 | 2022-04-16 | Comanche | Texas | 48093 | 3599 | 78 |
2411070 | 2411070 | 2022-04-15 | Comanche | Texas | 48093 | 3599 | 78 |
2407814 | 2407814 | 2022-04-14 | Comanche | Texas | 48093 | 3599 | 78 |
2404558 | 2404558 | 2022-04-13 | Comanche | Texas | 48093 | 3590 | 78 |
2401303 | 2401303 | 2022-04-12 | Comanche | Texas | 48093 | 3579 | 78 |
2398048 | 2398048 | 2022-04-11 | Comanche | Texas | 48093 | 3570 | 78 |
2394793 | 2394793 | 2022-04-10 | Comanche | Texas | 48093 | 3570 | 78 |
2391537 | 2391537 | 2022-04-09 | Comanche | Texas | 48093 | 3570 | 78 |
2388281 | 2388281 | 2022-04-08 | Comanche | Texas | 48093 | 3553 | 78 |
2385026 | 2385026 | 2022-04-07 | Comanche | Texas | 48093 | 3542 | 78 |
2381771 | 2381771 | 2022-04-06 | Comanche | Texas | 48093 | 3540 | 78 |
2378516 | 2378516 | 2022-04-05 | Comanche | Texas | 48093 | 3540 | 78 |
2375262 | 2375262 | 2022-04-04 | Comanche | Texas | 48093 | 3514 | 78 |
2372010 | 2372010 | 2022-04-03 | Comanche | Texas | 48093 | 3514 | 78 |
2368757 | 2368757 | 2022-04-02 | Comanche | Texas | 48093 | 3514 | 78 |
2365504 | 2365504 | 2022-04-01 | Comanche | Texas | 48093 | 3496 | 78 |
2362251 | 2362251 | 2022-03-31 | Comanche | Texas | 48093 | 3475 | 78 |
2358997 | 2358997 | 2022-03-30 | Comanche | Texas | 48093 | 3456 | 78 |
2355743 | 2355743 | 2022-03-29 | Comanche | Texas | 48093 | 3440 | 78 |
2352490 | 2352490 | 2022-03-28 | Comanche | Texas | 48093 | 3412 | 78 |
2349238 | 2349238 | 2022-03-27 | Comanche | Texas | 48093 | 3412 | 78 |
2345985 | 2345985 | 2022-03-26 | Comanche | Texas | 48093 | 3412 | 78 |
2342732 | 2342732 | 2022-03-25 | Comanche | Texas | 48093 | 3393 | 78 |
2339479 | 2339479 | 2022-03-24 | Comanche | Texas | 48093 | 3338 | 78 |
2336225 | 2336225 | 2022-03-23 | Comanche | Texas | 48093 | 3293 | 78 |
2332971 | 2332971 | 2022-03-22 | Comanche | Texas | 48093 | 3253 | 78 |
2329718 | 2329718 | 2022-03-21 | Comanche | Texas | 48093 | 3213 | 78 |
2326466 | 2326466 | 2022-03-20 | Comanche | Texas | 48093 | 3213 | 78 |
2323213 | 2323213 | 2022-03-19 | Comanche | Texas | 48093 | 3213 | 78 |
2319959 | 2319959 | 2022-03-18 | Comanche | Texas | 48093 | 3196 | 78 |
2316705 | 2316705 | 2022-03-17 | Comanche | Texas | 48093 | 3172 | 78 |
2313452 | 2313452 | 2022-03-16 | Comanche | Texas | 48093 | 3160 | 78 |
2310199 | 2310199 | 2022-03-15 | Comanche | Texas | 48093 | 3160 | 78 |
2306946 | 2306946 | 2022-03-14 | Comanche | Texas | 48093 | 3153 | 78 |
2303695 | 2303695 | 2022-03-13 | Comanche | Texas | 48093 | 3153 | 78 |
2300443 | 2300443 | 2022-03-12 | Comanche | Texas | 48093 | 3153 | 78 |
2297191 | 2297191 | 2022-03-11 | Comanche | Texas | 48093 | 3137 | 78 |
2293939 | 2293939 | 2022-03-10 | Comanche | Texas | 48093 | 3137 | 78 |
2290687 | 2290687 | 2022-03-09 | Comanche | Texas | 48093 | 3135 | 78 |
2274382 | 2274382 | 2022-03-04 | Aransas | Texas | 48007 | 4052 | 78 |
2271129 | 2271129 | 2022-03-03 | Aransas | Texas | 48007 | 4050 | 78 |
2219190 | 2219190 | 2022-02-15 | Gaines | Texas | 48165 | 1801 | 78 |
2215939 | 2215939 | 2022-02-14 | Gaines | Texas | 48165 | 1800 | 78 |
2216085 | 2216085 | 2022-02-14 | Tyler | Texas | 48457 | 3333 | 78 |
2212688 | 2212688 | 2022-02-13 | Gaines | Texas | 48165 | 1799 | 78 |
2209435 | 2209435 | 2022-02-12 | Gaines | Texas | 48165 | 1799 | 78 |
2206182 | 2206182 | 2022-02-11 | Gaines | Texas | 48165 | 1796 | 78 |
2202929 | 2202929 | 2022-02-10 | Gaines | Texas | 48165 | 1776 | 78 |
2199675 | 2199675 | 2022-02-09 | Gaines | Texas | 48165 | 1742 | 78 |
2196421 | 2196421 | 2022-02-08 | Gaines | Texas | 48165 | 1740 | 78 |
2196480 | 2196480 | 2022-02-08 | Lampasas | Texas | 48281 | 5392 | 78 |
2196540 | 2196540 | 2022-02-08 | Sabine | Texas | 48403 | 1213 | 78 |
2193167 | 2193167 | 2022-02-07 | Gaines | Texas | 48165 | 1738 | 78 |
2193226 | 2193226 | 2022-02-07 | Lampasas | Texas | 48281 | 5371 | 78 |
2193286 | 2193286 | 2022-02-07 | Sabine | Texas | 48403 | 1211 | 78 |
2189913 | 2189913 | 2022-02-06 | Gaines | Texas | 48165 | 1736 | 78 |
2189972 | 2189972 | 2022-02-06 | Lampasas | Texas | 48281 | 5364 | 78 |
2190032 | 2190032 | 2022-02-06 | Sabine | Texas | 48403 | 1211 | 78 |
2186660 | 2186660 | 2022-02-05 | Gaines | Texas | 48165 | 1734 | 78 |
2186779 | 2186779 | 2022-02-05 | Sabine | Texas | 48403 | 1204 | 78 |
2183527 | 2183527 | 2022-02-04 | Sabine | Texas | 48403 | 1200 | 78 |
2180275 | 2180275 | 2022-02-03 | Sabine | Texas | 48403 | 1193 | 78 |
2177024 | 2177024 | 2022-02-02 | Sabine | Texas | 48403 | 1189 | 78 |
2173770 | 2173770 | 2022-02-01 | Sabine | Texas | 48403 | 1187 | 78 |
2170518 | 2170518 | 2022-01-31 | Sabine | Texas | 48403 | 1184 | 78 |
2170569 | 2170569 | 2022-01-31 | Young | Texas | 48503 | 3657 | 78 |
2167264 | 2167264 | 2022-01-30 | Sabine | Texas | 48403 | 1181 | 78 |
2167315 | 2167315 | 2022-01-30 | Young | Texas | 48503 | 3649 | 78 |
2163952 | 2163952 | 2022-01-29 | Leon | Texas | 48289 | 3500 | 78 |
2164009 | 2164009 | 2022-01-29 | Sabine | Texas | 48403 | 1174 | 78 |
2164060 | 2164060 | 2022-01-29 | Young | Texas | 48503 | 3630 | 78 |
2160697 | 2160697 | 2022-01-28 | Leon | Texas | 48289 | 3472 | 78 |
2160754 | 2160754 | 2022-01-28 | Sabine | Texas | 48403 | 1170 | 78 |
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);