ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 48147 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502280 | 2502280 | 2022-05-13 | Fannin | Texas | 48147 | 6897 | 183 |
2499022 | 2499022 | 2022-05-12 | Fannin | Texas | 48147 | 6897 | 183 |
2495764 | 2495764 | 2022-05-11 | Fannin | Texas | 48147 | 6895 | 183 |
2492506 | 2492506 | 2022-05-10 | Fannin | Texas | 48147 | 6895 | 183 |
2489248 | 2489248 | 2022-05-09 | Fannin | Texas | 48147 | 6890 | 183 |
2485991 | 2485991 | 2022-05-08 | Fannin | Texas | 48147 | 6890 | 183 |
2482733 | 2482733 | 2022-05-07 | Fannin | Texas | 48147 | 6890 | 183 |
2479475 | 2479475 | 2022-05-06 | Fannin | Texas | 48147 | 6889 | 183 |
2476217 | 2476217 | 2022-05-05 | Fannin | Texas | 48147 | 6888 | 183 |
2472960 | 2472960 | 2022-05-04 | Fannin | Texas | 48147 | 6883 | 183 |
2469704 | 2469704 | 2022-05-03 | Fannin | Texas | 48147 | 6882 | 183 |
2466448 | 2466448 | 2022-05-02 | Fannin | Texas | 48147 | 6881 | 183 |
2463193 | 2463193 | 2022-05-01 | Fannin | Texas | 48147 | 6881 | 183 |
2459937 | 2459937 | 2022-04-30 | Fannin | Texas | 48147 | 6881 | 183 |
2456681 | 2456681 | 2022-04-29 | Fannin | Texas | 48147 | 6879 | 183 |
2453425 | 2453425 | 2022-04-28 | Fannin | Texas | 48147 | 6878 | 183 |
2450169 | 2450169 | 2022-04-27 | Fannin | Texas | 48147 | 6877 | 183 |
2446912 | 2446912 | 2022-04-26 | Fannin | Texas | 48147 | 6876 | 183 |
2443657 | 2443657 | 2022-04-25 | Fannin | Texas | 48147 | 6875 | 183 |
2440401 | 2440401 | 2022-04-24 | Fannin | Texas | 48147 | 6875 | 183 |
2437145 | 2437145 | 2022-04-23 | Fannin | Texas | 48147 | 6875 | 183 |
2433889 | 2433889 | 2022-04-22 | Fannin | Texas | 48147 | 6871 | 183 |
2430633 | 2430633 | 2022-04-21 | Fannin | Texas | 48147 | 6867 | 183 |
2427377 | 2427377 | 2022-04-20 | Fannin | Texas | 48147 | 6865 | 184 |
2424121 | 2424121 | 2022-04-19 | Fannin | Texas | 48147 | 6862 | 184 |
2420865 | 2420865 | 2022-04-18 | Fannin | Texas | 48147 | 6861 | 184 |
2417609 | 2417609 | 2022-04-17 | Fannin | Texas | 48147 | 6859 | 184 |
2414353 | 2414353 | 2022-04-16 | Fannin | Texas | 48147 | 6859 | 184 |
2411097 | 2411097 | 2022-04-15 | Fannin | Texas | 48147 | 6859 | 184 |
2407841 | 2407841 | 2022-04-14 | Fannin | Texas | 48147 | 6859 | 184 |
2404585 | 2404585 | 2022-04-13 | Fannin | Texas | 48147 | 6857 | 183 |
2401330 | 2401330 | 2022-04-12 | Fannin | Texas | 48147 | 6855 | 183 |
2398075 | 2398075 | 2022-04-11 | Fannin | Texas | 48147 | 6853 | 183 |
2394820 | 2394820 | 2022-04-10 | Fannin | Texas | 48147 | 6852 | 183 |
2391564 | 2391564 | 2022-04-09 | Fannin | Texas | 48147 | 6851 | 183 |
2388308 | 2388308 | 2022-04-08 | Fannin | Texas | 48147 | 6851 | 183 |
2385053 | 2385053 | 2022-04-07 | Fannin | Texas | 48147 | 6849 | 183 |
2381798 | 2381798 | 2022-04-06 | Fannin | Texas | 48147 | 6847 | 183 |
2378543 | 2378543 | 2022-04-05 | Fannin | Texas | 48147 | 6846 | 183 |
2375289 | 2375289 | 2022-04-04 | Fannin | Texas | 48147 | 6843 | 183 |
2372037 | 2372037 | 2022-04-03 | Fannin | Texas | 48147 | 6843 | 183 |
2368784 | 2368784 | 2022-04-02 | Fannin | Texas | 48147 | 6843 | 183 |
2365531 | 2365531 | 2022-04-01 | Fannin | Texas | 48147 | 6840 | 183 |
2362278 | 2362278 | 2022-03-31 | Fannin | Texas | 48147 | 6834 | 183 |
2359024 | 2359024 | 2022-03-30 | Fannin | Texas | 48147 | 6829 | 183 |
2355770 | 2355770 | 2022-03-29 | Fannin | Texas | 48147 | 6829 | 183 |
2352517 | 2352517 | 2022-03-28 | Fannin | Texas | 48147 | 6825 | 183 |
2349265 | 2349265 | 2022-03-27 | Fannin | Texas | 48147 | 6825 | 183 |
2346012 | 2346012 | 2022-03-26 | Fannin | Texas | 48147 | 6825 | 183 |
2342759 | 2342759 | 2022-03-25 | Fannin | Texas | 48147 | 6823 | 183 |
2339506 | 2339506 | 2022-03-24 | Fannin | Texas | 48147 | 6820 | 183 |
2336252 | 2336252 | 2022-03-23 | Fannin | Texas | 48147 | 6820 | 183 |
2332998 | 2332998 | 2022-03-22 | Fannin | Texas | 48147 | 6818 | 183 |
2329745 | 2329745 | 2022-03-21 | Fannin | Texas | 48147 | 6816 | 183 |
2326493 | 2326493 | 2022-03-20 | Fannin | Texas | 48147 | 6814 | 183 |
2323240 | 2323240 | 2022-03-19 | Fannin | Texas | 48147 | 6808 | 183 |
2319986 | 2319986 | 2022-03-18 | Fannin | Texas | 48147 | 6804 | 183 |
2316732 | 2316732 | 2022-03-17 | Fannin | Texas | 48147 | 6799 | 183 |
2313479 | 2313479 | 2022-03-16 | Fannin | Texas | 48147 | 6796 | 182 |
2310226 | 2310226 | 2022-03-15 | Fannin | Texas | 48147 | 6796 | 182 |
2306973 | 2306973 | 2022-03-14 | Fannin | Texas | 48147 | 6795 | 182 |
2303722 | 2303722 | 2022-03-13 | Fannin | Texas | 48147 | 6795 | 182 |
2300470 | 2300470 | 2022-03-12 | Fannin | Texas | 48147 | 6795 | 182 |
2297218 | 2297218 | 2022-03-11 | Fannin | Texas | 48147 | 6792 | 182 |
2293966 | 2293966 | 2022-03-10 | Fannin | Texas | 48147 | 6788 | 181 |
2290714 | 2290714 | 2022-03-09 | Fannin | Texas | 48147 | 6785 | 179 |
2287462 | 2287462 | 2022-03-08 | Fannin | Texas | 48147 | 6782 | 179 |
2284210 | 2284210 | 2022-03-07 | Fannin | Texas | 48147 | 6774 | 179 |
2280958 | 2280958 | 2022-03-06 | Fannin | Texas | 48147 | 6772 | 179 |
2277705 | 2277705 | 2022-03-05 | Fannin | Texas | 48147 | 6772 | 178 |
2274452 | 2274452 | 2022-03-04 | Fannin | Texas | 48147 | 6759 | 178 |
2271199 | 2271199 | 2022-03-03 | Fannin | Texas | 48147 | 6757 | 178 |
2267947 | 2267947 | 2022-03-02 | Fannin | Texas | 48147 | 6752 | 178 |
2264694 | 2264694 | 2022-03-01 | Fannin | Texas | 48147 | 6741 | 177 |
2261444 | 2261444 | 2022-02-28 | Fannin | Texas | 48147 | 6735 | 177 |
2258193 | 2258193 | 2022-02-27 | Fannin | Texas | 48147 | 6735 | 177 |
2254942 | 2254942 | 2022-02-26 | Fannin | Texas | 48147 | 6735 | 176 |
2251691 | 2251691 | 2022-02-25 | Fannin | Texas | 48147 | 6733 | 175 |
2248440 | 2248440 | 2022-02-24 | Fannin | Texas | 48147 | 6723 | 173 |
2245189 | 2245189 | 2022-02-23 | Fannin | Texas | 48147 | 6715 | 173 |
2241938 | 2241938 | 2022-02-22 | Fannin | Texas | 48147 | 6712 | 171 |
2238687 | 2238687 | 2022-02-21 | Fannin | Texas | 48147 | 6710 | 171 |
2235436 | 2235436 | 2022-02-20 | Fannin | Texas | 48147 | 6628 | 171 |
2232185 | 2232185 | 2022-02-19 | Fannin | Texas | 48147 | 6628 | 171 |
2228934 | 2228934 | 2022-02-18 | Fannin | Texas | 48147 | 6622 | 170 |
2225683 | 2225683 | 2022-02-17 | Fannin | Texas | 48147 | 6618 | 170 |
2222432 | 2222432 | 2022-02-16 | Fannin | Texas | 48147 | 6612 | 170 |
2219181 | 2219181 | 2022-02-15 | Fannin | Texas | 48147 | 6604 | 169 |
2215930 | 2215930 | 2022-02-14 | Fannin | Texas | 48147 | 6592 | 168 |
2212679 | 2212679 | 2022-02-13 | Fannin | Texas | 48147 | 6585 | 168 |
2209426 | 2209426 | 2022-02-12 | Fannin | Texas | 48147 | 6581 | 168 |
2206173 | 2206173 | 2022-02-11 | Fannin | Texas | 48147 | 6570 | 167 |
2202920 | 2202920 | 2022-02-10 | Fannin | Texas | 48147 | 6554 | 167 |
2199666 | 2199666 | 2022-02-09 | Fannin | Texas | 48147 | 6537 | 167 |
2196412 | 2196412 | 2022-02-08 | Fannin | Texas | 48147 | 6524 | 166 |
2193158 | 2193158 | 2022-02-07 | Fannin | Texas | 48147 | 6513 | 166 |
2189904 | 2189904 | 2022-02-06 | Fannin | Texas | 48147 | 6506 | 166 |
2186651 | 2186651 | 2022-02-05 | Fannin | Texas | 48147 | 6483 | 166 |
2183399 | 2183399 | 2022-02-04 | Fannin | Texas | 48147 | 6468 | 165 |
2180147 | 2180147 | 2022-02-03 | Fannin | Texas | 48147 | 6448 | 165 |
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);