ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 48059 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502236 | 2502236 | 2022-05-13 | Callahan | Texas | 48059 | 2920 | 72 |
2498978 | 2498978 | 2022-05-12 | Callahan | Texas | 48059 | 2920 | 72 |
2495720 | 2495720 | 2022-05-11 | Callahan | Texas | 48059 | 2918 | 72 |
2492462 | 2492462 | 2022-05-10 | Callahan | Texas | 48059 | 2913 | 72 |
2489204 | 2489204 | 2022-05-09 | Callahan | Texas | 48059 | 2910 | 72 |
2485947 | 2485947 | 2022-05-08 | Callahan | Texas | 48059 | 2908 | 72 |
2482689 | 2482689 | 2022-05-07 | Callahan | Texas | 48059 | 2907 | 72 |
2479431 | 2479431 | 2022-05-06 | Callahan | Texas | 48059 | 2906 | 72 |
2476173 | 2476173 | 2022-05-05 | Callahan | Texas | 48059 | 2904 | 72 |
2472916 | 2472916 | 2022-05-04 | Callahan | Texas | 48059 | 2902 | 72 |
2469660 | 2469660 | 2022-05-03 | Callahan | Texas | 48059 | 2894 | 72 |
2466404 | 2466404 | 2022-05-02 | Callahan | Texas | 48059 | 2890 | 72 |
2463149 | 2463149 | 2022-05-01 | Callahan | Texas | 48059 | 2889 | 72 |
2459893 | 2459893 | 2022-04-30 | Callahan | Texas | 48059 | 2889 | 72 |
2456637 | 2456637 | 2022-04-29 | Callahan | Texas | 48059 | 2888 | 72 |
2453381 | 2453381 | 2022-04-28 | Callahan | Texas | 48059 | 2885 | 72 |
2450125 | 2450125 | 2022-04-27 | Callahan | Texas | 48059 | 2882 | 72 |
2446868 | 2446868 | 2022-04-26 | Callahan | Texas | 48059 | 2878 | 72 |
2443613 | 2443613 | 2022-04-25 | Callahan | Texas | 48059 | 2876 | 72 |
2440357 | 2440357 | 2022-04-24 | Callahan | Texas | 48059 | 2876 | 72 |
2437101 | 2437101 | 2022-04-23 | Callahan | Texas | 48059 | 2876 | 72 |
2433845 | 2433845 | 2022-04-22 | Callahan | Texas | 48059 | 2875 | 72 |
2430589 | 2430589 | 2022-04-21 | Callahan | Texas | 48059 | 2875 | 72 |
2427333 | 2427333 | 2022-04-20 | Callahan | Texas | 48059 | 2866 | 72 |
2424077 | 2424077 | 2022-04-19 | Callahan | Texas | 48059 | 2865 | 72 |
2420821 | 2420821 | 2022-04-18 | Callahan | Texas | 48059 | 2865 | 72 |
2417565 | 2417565 | 2022-04-17 | Callahan | Texas | 48059 | 2857 | 72 |
2414309 | 2414309 | 2022-04-16 | Callahan | Texas | 48059 | 2857 | 72 |
2411053 | 2411053 | 2022-04-15 | Callahan | Texas | 48059 | 2857 | 72 |
2407797 | 2407797 | 2022-04-14 | Callahan | Texas | 48059 | 2857 | 72 |
2404541 | 2404541 | 2022-04-13 | Callahan | Texas | 48059 | 2856 | 72 |
2401286 | 2401286 | 2022-04-12 | Callahan | Texas | 48059 | 2855 | 72 |
2398031 | 2398031 | 2022-04-11 | Callahan | Texas | 48059 | 2854 | 72 |
2394776 | 2394776 | 2022-04-10 | Callahan | Texas | 48059 | 2854 | 72 |
2391520 | 2391520 | 2022-04-09 | Callahan | Texas | 48059 | 2854 | 72 |
2388264 | 2388264 | 2022-04-08 | Callahan | Texas | 48059 | 2846 | 72 |
2385009 | 2385009 | 2022-04-07 | Callahan | Texas | 48059 | 2844 | 72 |
2381754 | 2381754 | 2022-04-06 | Callahan | Texas | 48059 | 2844 | 72 |
2378499 | 2378499 | 2022-04-05 | Callahan | Texas | 48059 | 2842 | 72 |
2375245 | 2375245 | 2022-04-04 | Callahan | Texas | 48059 | 2842 | 72 |
2371993 | 2371993 | 2022-04-03 | Callahan | Texas | 48059 | 2842 | 72 |
2368740 | 2368740 | 2022-04-02 | Callahan | Texas | 48059 | 2842 | 72 |
2365487 | 2365487 | 2022-04-01 | Callahan | Texas | 48059 | 2841 | 72 |
2362234 | 2362234 | 2022-03-31 | Callahan | Texas | 48059 | 2838 | 72 |
2358980 | 2358980 | 2022-03-30 | Callahan | Texas | 48059 | 2832 | 72 |
2355726 | 2355726 | 2022-03-29 | Callahan | Texas | 48059 | 2830 | 72 |
2352473 | 2352473 | 2022-03-28 | Callahan | Texas | 48059 | 2822 | 72 |
2349221 | 2349221 | 2022-03-27 | Callahan | Texas | 48059 | 2822 | 72 |
2345968 | 2345968 | 2022-03-26 | Callahan | Texas | 48059 | 2822 | 72 |
2342715 | 2342715 | 2022-03-25 | Callahan | Texas | 48059 | 2816 | 72 |
2339462 | 2339462 | 2022-03-24 | Callahan | Texas | 48059 | 2805 | 72 |
2336208 | 2336208 | 2022-03-23 | Callahan | Texas | 48059 | 2793 | 72 |
2332954 | 2332954 | 2022-03-22 | Callahan | Texas | 48059 | 2793 | 72 |
2329701 | 2329701 | 2022-03-21 | Callahan | Texas | 48059 | 2793 | 72 |
2326449 | 2326449 | 2022-03-20 | Callahan | Texas | 48059 | 2793 | 72 |
2323196 | 2323196 | 2022-03-19 | Callahan | Texas | 48059 | 2792 | 72 |
2319942 | 2319942 | 2022-03-18 | Callahan | Texas | 48059 | 2791 | 72 |
2316688 | 2316688 | 2022-03-17 | Callahan | Texas | 48059 | 2791 | 72 |
2313435 | 2313435 | 2022-03-16 | Callahan | Texas | 48059 | 2790 | 72 |
2310182 | 2310182 | 2022-03-15 | Callahan | Texas | 48059 | 2790 | 72 |
2306929 | 2306929 | 2022-03-14 | Callahan | Texas | 48059 | 2789 | 72 |
2303678 | 2303678 | 2022-03-13 | Callahan | Texas | 48059 | 2788 | 72 |
2300426 | 2300426 | 2022-03-12 | Callahan | Texas | 48059 | 2788 | 72 |
2297174 | 2297174 | 2022-03-11 | Callahan | Texas | 48059 | 2787 | 72 |
2293922 | 2293922 | 2022-03-10 | Callahan | Texas | 48059 | 2786 | 72 |
2290670 | 2290670 | 2022-03-09 | Callahan | Texas | 48059 | 2784 | 72 |
2287418 | 2287418 | 2022-03-08 | Callahan | Texas | 48059 | 2782 | 72 |
2284166 | 2284166 | 2022-03-07 | Callahan | Texas | 48059 | 2782 | 72 |
2280914 | 2280914 | 2022-03-06 | Callahan | Texas | 48059 | 2769 | 72 |
2277661 | 2277661 | 2022-03-05 | Callahan | Texas | 48059 | 2769 | 72 |
2274408 | 2274408 | 2022-03-04 | Callahan | Texas | 48059 | 2766 | 72 |
2271155 | 2271155 | 2022-03-03 | Callahan | Texas | 48059 | 2766 | 72 |
2267903 | 2267903 | 2022-03-02 | Callahan | Texas | 48059 | 2765 | 72 |
2264650 | 2264650 | 2022-03-01 | Callahan | Texas | 48059 | 2763 | 72 |
2261400 | 2261400 | 2022-02-28 | Callahan | Texas | 48059 | 2762 | 72 |
2258149 | 2258149 | 2022-02-27 | Callahan | Texas | 48059 | 2761 | 72 |
2254898 | 2254898 | 2022-02-26 | Callahan | Texas | 48059 | 2761 | 72 |
2251647 | 2251647 | 2022-02-25 | Callahan | Texas | 48059 | 2759 | 72 |
2248396 | 2248396 | 2022-02-24 | Callahan | Texas | 48059 | 2759 | 72 |
2245145 | 2245145 | 2022-02-23 | Callahan | Texas | 48059 | 2758 | 72 |
2241894 | 2241894 | 2022-02-22 | Callahan | Texas | 48059 | 2755 | 71 |
2238643 | 2238643 | 2022-02-21 | Callahan | Texas | 48059 | 2755 | 71 |
2235392 | 2235392 | 2022-02-20 | Callahan | Texas | 48059 | 2754 | 71 |
2232141 | 2232141 | 2022-02-19 | Callahan | Texas | 48059 | 2754 | 71 |
2228890 | 2228890 | 2022-02-18 | Callahan | Texas | 48059 | 2751 | 70 |
2225639 | 2225639 | 2022-02-17 | Callahan | Texas | 48059 | 2750 | 70 |
2222388 | 2222388 | 2022-02-16 | Callahan | Texas | 48059 | 2746 | 70 |
2219137 | 2219137 | 2022-02-15 | Callahan | Texas | 48059 | 2744 | 70 |
2215886 | 2215886 | 2022-02-14 | Callahan | Texas | 48059 | 2740 | 69 |
2212635 | 2212635 | 2022-02-13 | Callahan | Texas | 48059 | 2740 | 69 |
2209382 | 2209382 | 2022-02-12 | Callahan | Texas | 48059 | 2739 | 68 |
2206129 | 2206129 | 2022-02-11 | Callahan | Texas | 48059 | 2735 | 67 |
2202876 | 2202876 | 2022-02-10 | Callahan | Texas | 48059 | 2730 | 67 |
2199622 | 2199622 | 2022-02-09 | Callahan | Texas | 48059 | 2726 | 67 |
2196368 | 2196368 | 2022-02-08 | Callahan | Texas | 48059 | 2722 | 67 |
2193114 | 2193114 | 2022-02-07 | Callahan | Texas | 48059 | 2717 | 66 |
2189860 | 2189860 | 2022-02-06 | Callahan | Texas | 48059 | 2716 | 66 |
2186607 | 2186607 | 2022-02-05 | Callahan | Texas | 48059 | 2703 | 66 |
2183355 | 2183355 | 2022-02-04 | Callahan | Texas | 48059 | 2698 | 65 |
2180103 | 2180103 | 2022-02-03 | Callahan | Texas | 48059 | 2689 | 65 |
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);