ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48141 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502276 | 2502276 | 2022-05-13 | El Paso | Texas | 48141 | 208635 | 3734 |
2499018 | 2499018 | 2022-05-12 | El Paso | Texas | 48141 | 208559 | 3735 |
2495760 | 2495760 | 2022-05-11 | El Paso | Texas | 48141 | 208420 | 3735 |
2492502 | 2492502 | 2022-05-10 | El Paso | Texas | 48141 | 208400 | 3735 |
2489244 | 2489244 | 2022-05-09 | El Paso | Texas | 48141 | 208370 | 3734 |
2485987 | 2485987 | 2022-05-08 | El Paso | Texas | 48141 | 208323 | 3734 |
2482729 | 2482729 | 2022-05-07 | El Paso | Texas | 48141 | 208270 | 3733 |
2479471 | 2479471 | 2022-05-06 | El Paso | Texas | 48141 | 208190 | 3733 |
2476213 | 2476213 | 2022-05-05 | El Paso | Texas | 48141 | 208151 | 3732 |
2472956 | 2472956 | 2022-05-04 | El Paso | Texas | 48141 | 208117 | 3730 |
2469700 | 2469700 | 2022-05-03 | El Paso | Texas | 48141 | 208095 | 3729 |
2466444 | 2466444 | 2022-05-02 | El Paso | Texas | 48141 | 208067 | 3729 |
2463189 | 2463189 | 2022-05-01 | El Paso | Texas | 48141 | 208037 | 3728 |
2459933 | 2459933 | 2022-04-30 | El Paso | Texas | 48141 | 208001 | 3728 |
2456677 | 2456677 | 2022-04-29 | El Paso | Texas | 48141 | 207954 | 3728 |
2453421 | 2453421 | 2022-04-28 | El Paso | Texas | 48141 | 207925 | 3726 |
2450165 | 2450165 | 2022-04-27 | El Paso | Texas | 48141 | 207883 | 3725 |
2446908 | 2446908 | 2022-04-26 | El Paso | Texas | 48141 | 207859 | 3724 |
2443653 | 2443653 | 2022-04-25 | El Paso | Texas | 48141 | 207844 | 3724 |
2440397 | 2440397 | 2022-04-24 | El Paso | Texas | 48141 | 207831 | 3724 |
2437141 | 2437141 | 2022-04-23 | El Paso | Texas | 48141 | 207799 | 3724 |
2433885 | 2433885 | 2022-04-22 | El Paso | Texas | 48141 | 207756 | 3724 |
2430629 | 2430629 | 2022-04-21 | El Paso | Texas | 48141 | 207721 | 3722 |
2427373 | 2427373 | 2022-04-20 | El Paso | Texas | 48141 | 207694 | 3722 |
2424117 | 2424117 | 2022-04-19 | El Paso | Texas | 48141 | 207675 | 3721 |
2420861 | 2420861 | 2022-04-18 | El Paso | Texas | 48141 | 207657 | 3720 |
2417605 | 2417605 | 2022-04-17 | El Paso | Texas | 48141 | 207545 | 3719 |
2414349 | 2414349 | 2022-04-16 | El Paso | Texas | 48141 | 207545 | 3719 |
2411093 | 2411093 | 2022-04-15 | El Paso | Texas | 48141 | 207545 | 3719 |
2407837 | 2407837 | 2022-04-14 | El Paso | Texas | 48141 | 207545 | 3719 |
2404581 | 2404581 | 2022-04-13 | El Paso | Texas | 48141 | 207520 | 3719 |
2401326 | 2401326 | 2022-04-12 | El Paso | Texas | 48141 | 207499 | 3719 |
2398071 | 2398071 | 2022-04-11 | El Paso | Texas | 48141 | 207478 | 3717 |
2394816 | 2394816 | 2022-04-10 | El Paso | Texas | 48141 | 207456 | 3717 |
2391560 | 2391560 | 2022-04-09 | El Paso | Texas | 48141 | 207437 | 3716 |
2388304 | 2388304 | 2022-04-08 | El Paso | Texas | 48141 | 207388 | 3715 |
2385049 | 2385049 | 2022-04-07 | El Paso | Texas | 48141 | 207377 | 3715 |
2381794 | 2381794 | 2022-04-06 | El Paso | Texas | 48141 | 207351 | 3712 |
2378539 | 2378539 | 2022-04-05 | El Paso | Texas | 48141 | 207335 | 3712 |
2375285 | 2375285 | 2022-04-04 | El Paso | Texas | 48141 | 207320 | 3712 |
2372033 | 2372033 | 2022-04-03 | El Paso | Texas | 48141 | 207294 | 3712 |
2368780 | 2368780 | 2022-04-02 | El Paso | Texas | 48141 | 207260 | 3712 |
2365527 | 2365527 | 2022-04-01 | El Paso | Texas | 48141 | 207226 | 3711 |
2362274 | 2362274 | 2022-03-31 | El Paso | Texas | 48141 | 207189 | 3710 |
2359020 | 2359020 | 2022-03-30 | El Paso | Texas | 48141 | 207145 | 3708 |
2355766 | 2355766 | 2022-03-29 | El Paso | Texas | 48141 | 207136 | 3708 |
2352513 | 2352513 | 2022-03-28 | El Paso | Texas | 48141 | 207096 | 3707 |
2349261 | 2349261 | 2022-03-27 | El Paso | Texas | 48141 | 207094 | 3706 |
2346008 | 2346008 | 2022-03-26 | El Paso | Texas | 48141 | 207083 | 3704 |
2342755 | 2342755 | 2022-03-25 | El Paso | Texas | 48141 | 207045 | 3703 |
2339502 | 2339502 | 2022-03-24 | El Paso | Texas | 48141 | 206983 | 3701 |
2336248 | 2336248 | 2022-03-23 | El Paso | Texas | 48141 | 206955 | 3698 |
2332994 | 2332994 | 2022-03-22 | El Paso | Texas | 48141 | 206923 | 3698 |
2329741 | 2329741 | 2022-03-21 | El Paso | Texas | 48141 | 206912 | 3697 |
2326489 | 2326489 | 2022-03-20 | El Paso | Texas | 48141 | 206894 | 3697 |
2323236 | 2323236 | 2022-03-19 | El Paso | Texas | 48141 | 206835 | 3697 |
2319982 | 2319982 | 2022-03-18 | El Paso | Texas | 48141 | 206835 | 3696 |
2316728 | 2316728 | 2022-03-17 | El Paso | Texas | 48141 | 206743 | 3693 |
2313475 | 2313475 | 2022-03-16 | El Paso | Texas | 48141 | 206705 | 3689 |
2310222 | 2310222 | 2022-03-15 | El Paso | Texas | 48141 | 206688 | 3686 |
2306969 | 2306969 | 2022-03-14 | El Paso | Texas | 48141 | 206667 | 3684 |
2303718 | 2303718 | 2022-03-13 | El Paso | Texas | 48141 | 206633 | 3684 |
2300466 | 2300466 | 2022-03-12 | El Paso | Texas | 48141 | 206601 | 3685 |
2297214 | 2297214 | 2022-03-11 | El Paso | Texas | 48141 | 206554 | 3680 |
2293962 | 2293962 | 2022-03-10 | El Paso | Texas | 48141 | 205021 | 3675 |
2290710 | 2290710 | 2022-03-09 | El Paso | Texas | 48141 | 204932 | 3674 |
2287458 | 2287458 | 2022-03-08 | El Paso | Texas | 48141 | 204457 | 3667 |
2284206 | 2284206 | 2022-03-07 | El Paso | Texas | 48141 | 203703 | 3665 |
2280954 | 2280954 | 2022-03-06 | El Paso | Texas | 48141 | 203590 | 3664 |
2277701 | 2277701 | 2022-03-05 | El Paso | Texas | 48141 | 203570 | 3659 |
2274448 | 2274448 | 2022-03-04 | El Paso | Texas | 48141 | 203510 | 3653 |
2271195 | 2271195 | 2022-03-03 | El Paso | Texas | 48141 | 203428 | 3638 |
2267943 | 2267943 | 2022-03-02 | El Paso | Texas | 48141 | 203350 | 3634 |
2264690 | 2264690 | 2022-03-01 | El Paso | Texas | 48141 | 203328 | 3625 |
2261440 | 2261440 | 2022-02-28 | El Paso | Texas | 48141 | 203237 | 3620 |
2258189 | 2258189 | 2022-02-27 | El Paso | Texas | 48141 | 203189 | 3617 |
2254938 | 2254938 | 2022-02-26 | El Paso | Texas | 48141 | 203131 | 3611 |
2251687 | 2251687 | 2022-02-25 | El Paso | Texas | 48141 | 203006 | 3607 |
2248436 | 2248436 | 2022-02-24 | El Paso | Texas | 48141 | 202873 | 3602 |
2245185 | 2245185 | 2022-02-23 | El Paso | Texas | 48141 | 202813 | 3596 |
2241934 | 2241934 | 2022-02-22 | El Paso | Texas | 48141 | 202762 | 3580 |
2238683 | 2238683 | 2022-02-21 | El Paso | Texas | 48141 | 202617 | 3576 |
2235432 | 2235432 | 2022-02-20 | El Paso | Texas | 48141 | 202478 | 3576 |
2232181 | 2232181 | 2022-02-19 | El Paso | Texas | 48141 | 202438 | 3570 |
2228930 | 2228930 | 2022-02-18 | El Paso | Texas | 48141 | 202087 | 3561 |
2225679 | 2225679 | 2022-02-17 | El Paso | Texas | 48141 | 202024 | 3554 |
2222428 | 2222428 | 2022-02-16 | El Paso | Texas | 48141 | 201830 | 3551 |
2219177 | 2219177 | 2022-02-15 | El Paso | Texas | 48141 | 201668 | 3539 |
2215926 | 2215926 | 2022-02-14 | El Paso | Texas | 48141 | 201409 | 3528 |
2212675 | 2212675 | 2022-02-13 | El Paso | Texas | 48141 | 201229 | 3528 |
2209422 | 2209422 | 2022-02-12 | El Paso | Texas | 48141 | 201027 | 3515 |
2206169 | 2206169 | 2022-02-11 | El Paso | Texas | 48141 | 200626 | 3504 |
2202916 | 2202916 | 2022-02-10 | El Paso | Texas | 48141 | 200199 | 3495 |
2199662 | 2199662 | 2022-02-09 | El Paso | Texas | 48141 | 199864 | 3480 |
2196408 | 2196408 | 2022-02-08 | El Paso | Texas | 48141 | 199622 | 3464 |
2193154 | 2193154 | 2022-02-07 | El Paso | Texas | 48141 | 199319 | 3448 |
2189900 | 2189900 | 2022-02-06 | El Paso | Texas | 48141 | 198865 | 3446 |
2186647 | 2186647 | 2022-02-05 | El Paso | Texas | 48141 | 198213 | 3441 |
2183395 | 2183395 | 2022-02-04 | El Paso | Texas | 48141 | 197173 | 3424 |
2180143 | 2180143 | 2022-02-03 | El Paso | Texas | 48141 | 196459 | 3420 |
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);