ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 48427 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 |
---|---|---|---|---|---|---|---|
2502421 | 2502421 | 2022-05-13 | Starr | Texas | 48427 | 20091 | 366 |
2499163 | 2499163 | 2022-05-12 | Starr | Texas | 48427 | 20080 | 366 |
2495905 | 2495905 | 2022-05-11 | Starr | Texas | 48427 | 20072 | 366 |
2492647 | 2492647 | 2022-05-10 | Starr | Texas | 48427 | 20059 | 366 |
2489389 | 2489389 | 2022-05-09 | Starr | Texas | 48427 | 20052 | 366 |
2486131 | 2486131 | 2022-05-08 | Starr | Texas | 48427 | 20051 | 366 |
2482873 | 2482873 | 2022-05-07 | Starr | Texas | 48427 | 20051 | 366 |
2479615 | 2479615 | 2022-05-06 | Starr | Texas | 48427 | 20046 | 366 |
2476357 | 2476357 | 2022-05-05 | Starr | Texas | 48427 | 20037 | 365 |
2473100 | 2473100 | 2022-05-04 | Starr | Texas | 48427 | 20031 | 365 |
2469844 | 2469844 | 2022-05-03 | Starr | Texas | 48427 | 20020 | 365 |
2466588 | 2466588 | 2022-05-02 | Starr | Texas | 48427 | 20014 | 365 |
2463333 | 2463333 | 2022-05-01 | Starr | Texas | 48427 | 20011 | 365 |
2460077 | 2460077 | 2022-04-30 | Starr | Texas | 48427 | 20009 | 365 |
2456821 | 2456821 | 2022-04-29 | Starr | Texas | 48427 | 19993 | 365 |
2453565 | 2453565 | 2022-04-28 | Starr | Texas | 48427 | 19969 | 365 |
2450309 | 2450309 | 2022-04-27 | Starr | Texas | 48427 | 19955 | 365 |
2447052 | 2447052 | 2022-04-26 | Starr | Texas | 48427 | 19952 | 365 |
2443797 | 2443797 | 2022-04-25 | Starr | Texas | 48427 | 19941 | 365 |
2440541 | 2440541 | 2022-04-24 | Starr | Texas | 48427 | 19938 | 365 |
2437285 | 2437285 | 2022-04-23 | Starr | Texas | 48427 | 19938 | 365 |
2434029 | 2434029 | 2022-04-22 | Starr | Texas | 48427 | 19928 | 365 |
2430773 | 2430773 | 2022-04-21 | Starr | Texas | 48427 | 19905 | 365 |
2427517 | 2427517 | 2022-04-20 | Starr | Texas | 48427 | 19898 | 365 |
2424261 | 2424261 | 2022-04-19 | Starr | Texas | 48427 | 19889 | 364 |
2421005 | 2421005 | 2022-04-18 | Starr | Texas | 48427 | 19879 | 364 |
2417749 | 2417749 | 2022-04-17 | Starr | Texas | 48427 | 19861 | 364 |
2414493 | 2414493 | 2022-04-16 | Starr | Texas | 48427 | 19861 | 364 |
2411237 | 2411237 | 2022-04-15 | Starr | Texas | 48427 | 19861 | 364 |
2407981 | 2407981 | 2022-04-14 | Starr | Texas | 48427 | 19861 | 364 |
2404725 | 2404725 | 2022-04-13 | Starr | Texas | 48427 | 19859 | 364 |
2401470 | 2401470 | 2022-04-12 | Starr | Texas | 48427 | 19856 | 364 |
2398215 | 2398215 | 2022-04-11 | Starr | Texas | 48427 | 19854 | 364 |
2394960 | 2394960 | 2022-04-10 | Starr | Texas | 48427 | 19854 | 364 |
2391704 | 2391704 | 2022-04-09 | Starr | Texas | 48427 | 19854 | 364 |
2388448 | 2388448 | 2022-04-08 | Starr | Texas | 48427 | 19853 | 364 |
2385193 | 2385193 | 2022-04-07 | Starr | Texas | 48427 | 19850 | 364 |
2381938 | 2381938 | 2022-04-06 | Starr | Texas | 48427 | 19849 | 364 |
2378683 | 2378683 | 2022-04-05 | Starr | Texas | 48427 | 19846 | 364 |
2375429 | 2375429 | 2022-04-04 | Starr | Texas | 48427 | 19842 | 364 |
2372177 | 2372177 | 2022-04-03 | Starr | Texas | 48427 | 19842 | 364 |
2368924 | 2368924 | 2022-04-02 | Starr | Texas | 48427 | 19842 | 364 |
2365671 | 2365671 | 2022-04-01 | Starr | Texas | 48427 | 19833 | 363 |
2362418 | 2362418 | 2022-03-31 | Starr | Texas | 48427 | 19831 | 363 |
2359164 | 2359164 | 2022-03-30 | Starr | Texas | 48427 | 19829 | 363 |
2355910 | 2355910 | 2022-03-29 | Starr | Texas | 48427 | 19815 | 363 |
2352657 | 2352657 | 2022-03-28 | Starr | Texas | 48427 | 19799 | 363 |
2349405 | 2349405 | 2022-03-27 | Starr | Texas | 48427 | 19798 | 363 |
2346152 | 2346152 | 2022-03-26 | Starr | Texas | 48427 | 19798 | 363 |
2342899 | 2342899 | 2022-03-25 | Starr | Texas | 48427 | 19795 | 363 |
2339646 | 2339646 | 2022-03-24 | Starr | Texas | 48427 | 19780 | 363 |
2336392 | 2336392 | 2022-03-23 | Starr | Texas | 48427 | 19770 | 363 |
2333138 | 2333138 | 2022-03-22 | Starr | Texas | 48427 | 19764 | 363 |
2329885 | 2329885 | 2022-03-21 | Starr | Texas | 48427 | 19752 | 363 |
2326633 | 2326633 | 2022-03-20 | Starr | Texas | 48427 | 19751 | 363 |
2323380 | 2323380 | 2022-03-19 | Starr | Texas | 48427 | 19749 | 363 |
2320126 | 2320126 | 2022-03-18 | Starr | Texas | 48427 | 19733 | 363 |
2316872 | 2316872 | 2022-03-17 | Starr | Texas | 48427 | 19722 | 363 |
2313619 | 2313619 | 2022-03-16 | Starr | Texas | 48427 | 19711 | 362 |
2310366 | 2310366 | 2022-03-15 | Starr | Texas | 48427 | 19707 | 360 |
2307113 | 2307113 | 2022-03-14 | Starr | Texas | 48427 | 19702 | 360 |
2303862 | 2303862 | 2022-03-13 | Starr | Texas | 48427 | 19700 | 360 |
2300610 | 2300610 | 2022-03-12 | Starr | Texas | 48427 | 19696 | 360 |
2297358 | 2297358 | 2022-03-11 | Starr | Texas | 48427 | 19688 | 360 |
2294106 | 2294106 | 2022-03-10 | Starr | Texas | 48427 | 19681 | 360 |
2290854 | 2290854 | 2022-03-09 | Starr | Texas | 48427 | 19646 | 360 |
2287602 | 2287602 | 2022-03-08 | Starr | Texas | 48427 | 19632 | 360 |
2284350 | 2284350 | 2022-03-07 | Starr | Texas | 48427 | 19621 | 360 |
2281098 | 2281098 | 2022-03-06 | Starr | Texas | 48427 | 19619 | 360 |
2277845 | 2277845 | 2022-03-05 | Starr | Texas | 48427 | 19618 | 360 |
2274592 | 2274592 | 2022-03-04 | Starr | Texas | 48427 | 19585 | 360 |
2271339 | 2271339 | 2022-03-03 | Starr | Texas | 48427 | 19568 | 360 |
2268087 | 2268087 | 2022-03-02 | Starr | Texas | 48427 | 19538 | 360 |
2264834 | 2264834 | 2022-03-01 | Starr | Texas | 48427 | 19498 | 357 |
2261584 | 2261584 | 2022-02-28 | Starr | Texas | 48427 | 19425 | 356 |
2258333 | 2258333 | 2022-02-27 | Starr | Texas | 48427 | 19424 | 356 |
2255082 | 2255082 | 2022-02-26 | Starr | Texas | 48427 | 19420 | 356 |
2251831 | 2251831 | 2022-02-25 | Starr | Texas | 48427 | 19293 | 355 |
2248580 | 2248580 | 2022-02-24 | Starr | Texas | 48427 | 19201 | 355 |
2245329 | 2245329 | 2022-02-23 | Starr | Texas | 48427 | 19070 | 355 |
2242078 | 2242078 | 2022-02-22 | Starr | Texas | 48427 | 18996 | 354 |
2238827 | 2238827 | 2022-02-21 | Starr | Texas | 48427 | 18903 | 353 |
2235576 | 2235576 | 2022-02-20 | Starr | Texas | 48427 | 18849 | 353 |
2232325 | 2232325 | 2022-02-19 | Starr | Texas | 48427 | 18834 | 353 |
2229074 | 2229074 | 2022-02-18 | Starr | Texas | 48427 | 18720 | 350 |
2225823 | 2225823 | 2022-02-17 | Starr | Texas | 48427 | 18644 | 349 |
2222572 | 2222572 | 2022-02-16 | Starr | Texas | 48427 | 18503 | 348 |
2219321 | 2219321 | 2022-02-15 | Starr | Texas | 48427 | 18453 | 347 |
2216070 | 2216070 | 2022-02-14 | Starr | Texas | 48427 | 18384 | 347 |
2212819 | 2212819 | 2022-02-13 | Starr | Texas | 48427 | 18280 | 347 |
2209566 | 2209566 | 2022-02-12 | Starr | Texas | 48427 | 18090 | 347 |
2206313 | 2206313 | 2022-02-11 | Starr | Texas | 48427 | 18014 | 345 |
2203060 | 2203060 | 2022-02-10 | Starr | Texas | 48427 | 17853 | 345 |
2199806 | 2199806 | 2022-02-09 | Starr | Texas | 48427 | 17637 | 345 |
2196552 | 2196552 | 2022-02-08 | Starr | Texas | 48427 | 17524 | 345 |
2193298 | 2193298 | 2022-02-07 | Starr | Texas | 48427 | 17401 | 342 |
2190044 | 2190044 | 2022-02-06 | Starr | Texas | 48427 | 17278 | 342 |
2186791 | 2186791 | 2022-02-05 | Starr | Texas | 48427 | 17259 | 342 |
2183539 | 2183539 | 2022-02-04 | Starr | Texas | 48427 | 17166 | 341 |
2180287 | 2180287 | 2022-02-03 | Starr | Texas | 48427 | 17076 | 340 |
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);