ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Fresno" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 334 ✖
- 0 27
- 7 16
- 1727 13
- 646 10
- 711 10
- 1527 9
- 9 8
- 406 7
- 1747 7
- 2653 7
- 2744 7
- 2754 7
- 1717 6
- 1730 6
- 1744 6
- 1759 6
- 2731 6
- 5 5
- 22 5
- 617 5
- 1291 5
- 1724 5
- 1736 5
- 1753 5
- 2246 5
- 2379 5
- 72 4
- 77 4
- 88 4
- 100 4
- 112 4
- 138 4
- 171 4
- 203 4
- 226 4
- 263 4
- 312 4
- 337 4
- 355 4
- 382 4
- 399 4
- 429 4
- 436 4
- 443 4
- 454 4
- 460 4
- 471 4
- 481 4
- 506 4
- 542 4
- 932 4
- 1137 4
- 1224 4
- 1662 4
- 1690 4
- 1698 4
- 1706 4
- 1722 4
- 1828 4
- 2094 4
- 2358 4
- 2544 4
- 2710 4
- 2722 4
- 2739 4
- 2748 4
- 1 3
- 3 3
- 8 3
- 16 3
- 35 3
- 43 3
- 52 3
- 66 3
- 91 3
- 104 3
- 120 3
- 157 3
- 191 3
- 205 3
- 239 3
- 290 3
- 326 3
- 348 3
- 362 3
- 390 3
- 424 3
- 430 3
- 439 3
- 447 3
- 456 3
- 463 3
- 477 3
- 488 3
- 514 3
- 557 3
- 1043 3
- 1367 3
- 1443 3
- 1488 3
- 1606 3
- 1622 3
- 1633 3
- 1646 3
- 1678 3
- 1682 3
- 1728 3
- 1853 3
- 1927 3
- 1964 3
- 2018 3
- 2051 3
- 2131 3
- 2170 3
- 2233 3
- 2270 3
- 2294 3
- 2335 3
- 2341 3
- 2393 3
- 2415 3
- 2429 3
- 2430 3
- 2457 3
- 2477 3
- 2509 3
- 2597 3
- 2640 3
- 2694 3
- 2725 3
- 2740 3
- 2751 3
- 13 2
- 17 2
- 37 2
- 71 2
- 846 2
- 968 2
- 1451 2
- 1556 2
- 1616 2
- 1627 2
- 1680 2
- 1688 2
- 1719 2
- 1720 2
- 1731 2
- 1742 2
- 1746 2
- 1761 2
- 1790 2
- 1889 2
- 1978 2
- 2063 2
- 2179 2
- 2202 2
- 2205 2
- 2364 2
- 2404 2
- 2425 2
- 2463 2
- 2464 2
- 2502 2
- 2592 2
- 2689 2
- 2707 2
- 2717 2
- 2 1
- 10 1
- 20 1
- 26 1
- 30 1
- 32 1
- 36 1
- 40 1
- 46 1
- 48 1
- 49 1
- 51 1
- 55 1
- 57 1
- 61 1
- 62 1
- 67 1
- 70 1
- 73 1
- 75 1
- 78 1
- 81 1
- 84 1
- 87 1
- 838 1
- 904 1
- 1020 1
- 1067 1
- 1084 1
- 1122 1
- 1173 1
- 1185 1
- 1198 1
- 1254 1
- 1258 1
- 1283 1
- 1341 1
- 1349 1
- 1356 1
- 1397 1
- 1401 1
- 1412 1
- 1422 1
- 1458 1
- 1466 1
- 1505 1
- 1509 1
- 1519 1
- 1532 1
- 1575 1
- 1585 1
- 1593 1
- 1601 1
- 1609 1
- 1620 1
- 1626 1
- 1630 1
- 1636 1
- 1640 1
- 1642 1
- 1643 1
- 1650 1
- 1654 1
- 1657 1
- 1663 1
- 1666 1
- 1667 1
- 1670 1
- 1677 1
- 1684 1
- 1686 1
- 1687 1
- 1693 1
- 1696 1
- 1701 1
- 1702 1
- 1704 1
- 1705 1
- 1707 1
- 1709 1
- 1712 1
- 1725 1
- 1729 1
- 1751 1
- 1755 1
- 1770 1
- 1774 1
- 1792 1
- 1800 1
- 1801 1
- 1804 1
- 1822 1
- 1831 1
- 1838 1
- 1846 1
- 1856 1
- 1867 1
- 1868 1
- 1882 1
- 1888 1
- 1892 1
- 1908 1
- 1939 1
- 1942 1
- 1948 1
- 1957 1
- 1987 1
- 2008 1
- 2035 1
- 2036 1
- 2042 1
- 2048 1
- 2073 1
- 2084 1
- 2112 1
- 2122 1
- 2128 1
- 2147 1
- 2149 1
- 2158 1
- 2166 1
- 2188 1
- 2209 1
- 2210 1
- 2218 1
- 2230 1
- 2242 1
- 2243 1
- 2252 1
- 2254 1
- 2259 1
- 2264 1
- 2284 1
- 2285 1
- 2289 1
- 2293 1
- 2310 1
- 2312 1
- 2316 1
- 2319 1
- 2349 1
- 2365 1
- 2377 1
- 2380 1
- 2405 1
- 2413 1
- 2426 1
- 2434 1
- 2452 1
- 2489 1
- 2493 1
- 2537 1
- 2538 1
- 2542 1
- 2543 1
- 2596 1
- 2621 1
- 2622 1
- 2628 1
- 2629 1
- 2682 1
- 2683 1
- 2708 1
- 2718 1
- 2720 1
- 2738 1
- 2757 1
state 1
- California 798
fips 1
- 6019 798
county 1
- Fresno · 798 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499771 | 2499771 | 2022-05-13 | Fresno | California | 6019 | 257611 | 2757 |
2496513 | 2496513 | 2022-05-12 | Fresno | California | 6019 | 257043 | 2754 |
2493255 | 2493255 | 2022-05-11 | Fresno | California | 6019 | 257043 | 2754 |
2489997 | 2489997 | 2022-05-10 | Fresno | California | 6019 | 257043 | 2754 |
2486740 | 2486740 | 2022-05-09 | Fresno | California | 6019 | 256677 | 2754 |
2483482 | 2483482 | 2022-05-08 | Fresno | California | 6019 | 256677 | 2754 |
2480224 | 2480224 | 2022-05-07 | Fresno | California | 6019 | 256677 | 2754 |
2476966 | 2476966 | 2022-05-06 | Fresno | California | 6019 | 256677 | 2754 |
2473708 | 2473708 | 2022-05-05 | Fresno | California | 6019 | 256219 | 2751 |
2470451 | 2470451 | 2022-05-04 | Fresno | California | 6019 | 256219 | 2751 |
2467195 | 2467195 | 2022-05-03 | Fresno | California | 6019 | 256219 | 2751 |
2463940 | 2463940 | 2022-05-02 | Fresno | California | 6019 | 255954 | 2748 |
2460684 | 2460684 | 2022-05-01 | Fresno | California | 6019 | 255954 | 2748 |
2457428 | 2457428 | 2022-04-30 | Fresno | California | 6019 | 255954 | 2748 |
2454172 | 2454172 | 2022-04-29 | Fresno | California | 6019 | 255954 | 2748 |
2450916 | 2450916 | 2022-04-28 | Fresno | California | 6019 | 255591 | 2744 |
2447660 | 2447660 | 2022-04-27 | Fresno | California | 6019 | 255591 | 2744 |
2444404 | 2444404 | 2022-04-26 | Fresno | California | 6019 | 255591 | 2744 |
2441148 | 2441148 | 2022-04-25 | Fresno | California | 6019 | 255391 | 2744 |
2437892 | 2437892 | 2022-04-24 | Fresno | California | 6019 | 255391 | 2744 |
2434636 | 2434636 | 2022-04-23 | Fresno | California | 6019 | 255391 | 2744 |
2431380 | 2431380 | 2022-04-22 | Fresno | California | 6019 | 255391 | 2744 |
2428124 | 2428124 | 2022-04-21 | Fresno | California | 6019 | 254703 | 2740 |
2424868 | 2424868 | 2022-04-20 | Fresno | California | 6019 | 254703 | 2740 |
2421612 | 2421612 | 2022-04-19 | Fresno | California | 6019 | 254703 | 2740 |
2418356 | 2418356 | 2022-04-18 | Fresno | California | 6019 | 254590 | 2739 |
2415100 | 2415100 | 2022-04-17 | Fresno | California | 6019 | 254590 | 2739 |
2411844 | 2411844 | 2022-04-16 | Fresno | California | 6019 | 254590 | 2739 |
2408588 | 2408588 | 2022-04-15 | Fresno | California | 6019 | 254590 | 2739 |
2405332 | 2405332 | 2022-04-14 | Fresno | California | 6019 | 254460 | 2738 |
2402077 | 2402077 | 2022-04-13 | Fresno | California | 6019 | 253824 | 2731 |
2398822 | 2398822 | 2022-04-12 | Fresno | California | 6019 | 253824 | 2731 |
2395567 | 2395567 | 2022-04-11 | Fresno | California | 6019 | 253824 | 2731 |
2392311 | 2392311 | 2022-04-10 | Fresno | California | 6019 | 253824 | 2731 |
2389055 | 2389055 | 2022-04-09 | Fresno | California | 6019 | 253824 | 2731 |
2385800 | 2385800 | 2022-04-08 | Fresno | California | 6019 | 253824 | 2731 |
2382545 | 2382545 | 2022-04-07 | Fresno | California | 6019 | 253676 | 2725 |
2379290 | 2379290 | 2022-04-06 | Fresno | California | 6019 | 253676 | 2725 |
2376036 | 2376036 | 2022-04-05 | Fresno | California | 6019 | 253676 | 2725 |
2372784 | 2372784 | 2022-04-04 | Fresno | California | 6019 | 253293 | 2722 |
2369531 | 2369531 | 2022-04-03 | Fresno | California | 6019 | 253293 | 2722 |
2366278 | 2366278 | 2022-04-02 | Fresno | California | 6019 | 253293 | 2722 |
2363025 | 2363025 | 2022-04-01 | Fresno | California | 6019 | 253293 | 2722 |
2359771 | 2359771 | 2022-03-31 | Fresno | California | 6019 | 253182 | 2720 |
2356517 | 2356517 | 2022-03-30 | Fresno | California | 6019 | 252510 | 2718 |
2353264 | 2353264 | 2022-03-29 | Fresno | California | 6019 | 252398 | 2717 |
2350012 | 2350012 | 2022-03-28 | Fresno | California | 6019 | 252303 | 2717 |
2346759 | 2346759 | 2022-03-27 | Fresno | California | 6019 | 252053 | 2710 |
2343506 | 2343506 | 2022-03-26 | Fresno | California | 6019 | 252053 | 2710 |
2340253 | 2340253 | 2022-03-25 | Fresno | California | 6019 | 252053 | 2710 |
2337000 | 2337000 | 2022-03-24 | Fresno | California | 6019 | 251910 | 2710 |
2333746 | 2333746 | 2022-03-23 | Fresno | California | 6019 | 251576 | 2708 |
2330492 | 2330492 | 2022-03-22 | Fresno | California | 6019 | 251399 | 2707 |
2327240 | 2327240 | 2022-03-21 | Fresno | California | 6019 | 251322 | 2707 |
2323987 | 2323987 | 2022-03-20 | Fresno | California | 6019 | 250990 | 2694 |
2320733 | 2320733 | 2022-03-19 | Fresno | California | 6019 | 250990 | 2694 |
2317479 | 2317479 | 2022-03-18 | Fresno | California | 6019 | 250990 | 2694 |
2314226 | 2314226 | 2022-03-17 | Fresno | California | 6019 | 250811 | 2689 |
2310973 | 2310973 | 2022-03-16 | Fresno | California | 6019 | 250625 | 2689 |
2307720 | 2307720 | 2022-03-15 | Fresno | California | 6019 | 250464 | 2682 |
2304469 | 2304469 | 2022-03-14 | Fresno | California | 6019 | 250415 | 2683 |
2301217 | 2301217 | 2022-03-13 | Fresno | California | 6019 | 250035 | 2653 |
2297965 | 2297965 | 2022-03-12 | Fresno | California | 6019 | 250035 | 2653 |
2294713 | 2294713 | 2022-03-11 | Fresno | California | 6019 | 250035 | 2653 |
2291461 | 2291461 | 2022-03-10 | Fresno | California | 6019 | 249879 | 2653 |
2288209 | 2288209 | 2022-03-09 | Fresno | California | 6019 | 249735 | 2653 |
2284958 | 2284958 | 2022-03-08 | Fresno | California | 6019 | 249597 | 2653 |
2281706 | 2281706 | 2022-03-07 | Fresno | California | 6019 | 249441 | 2653 |
2278453 | 2278453 | 2022-03-06 | Fresno | California | 6019 | 249081 | 2640 |
2275200 | 2275200 | 2022-03-05 | Fresno | California | 6019 | 249081 | 2640 |
2271947 | 2271947 | 2022-03-04 | Fresno | California | 6019 | 249081 | 2640 |
2268695 | 2268695 | 2022-03-03 | Fresno | California | 6019 | 248859 | 2629 |
2265442 | 2265442 | 2022-03-02 | Fresno | California | 6019 | 248184 | 2628 |
2262191 | 2262191 | 2022-03-01 | Fresno | California | 6019 | 248109 | 2622 |
2258940 | 2258940 | 2022-02-28 | Fresno | California | 6019 | 247987 | 2621 |
2255689 | 2255689 | 2022-02-27 | Fresno | California | 6019 | 247269 | 2597 |
2252438 | 2252438 | 2022-02-26 | Fresno | California | 6019 | 247269 | 2597 |
2249187 | 2249187 | 2022-02-25 | Fresno | California | 6019 | 247269 | 2597 |
2245936 | 2245936 | 2022-02-24 | Fresno | California | 6019 | 246898 | 2596 |
2242685 | 2242685 | 2022-02-23 | Fresno | California | 6019 | 246311 | 2592 |
2239434 | 2239434 | 2022-02-22 | Fresno | California | 6019 | 246130 | 2592 |
2236183 | 2236183 | 2022-02-21 | Fresno | California | 6019 | 244801 | 2544 |
2232932 | 2232932 | 2022-02-20 | Fresno | California | 6019 | 244801 | 2544 |
2229681 | 2229681 | 2022-02-19 | Fresno | California | 6019 | 244801 | 2544 |
2226430 | 2226430 | 2022-02-18 | Fresno | California | 6019 | 244801 | 2544 |
2223179 | 2223179 | 2022-02-17 | Fresno | California | 6019 | 244263 | 2542 |
2219928 | 2219928 | 2022-02-16 | Fresno | California | 6019 | 243273 | 2543 |
2216677 | 2216677 | 2022-02-15 | Fresno | California | 6019 | 242960 | 2538 |
2213426 | 2213426 | 2022-02-14 | Fresno | California | 6019 | 242286 | 2537 |
2210174 | 2210174 | 2022-02-13 | Fresno | California | 6019 | 240509 | 2509 |
2206921 | 2206921 | 2022-02-12 | Fresno | California | 6019 | 240509 | 2509 |
2203668 | 2203668 | 2022-02-11 | Fresno | California | 6019 | 240509 | 2509 |
2200415 | 2200415 | 2022-02-10 | Fresno | California | 6019 | 239589 | 2502 |
2197161 | 2197161 | 2022-02-09 | Fresno | California | 6019 | 238135 | 2502 |
2193906 | 2193906 | 2022-02-08 | Fresno | California | 6019 | 236214 | 2493 |
2190653 | 2190653 | 2022-02-07 | Fresno | California | 6019 | 234445 | 2489 |
2187400 | 2187400 | 2022-02-06 | Fresno | California | 6019 | 233258 | 2477 |
2184147 | 2184147 | 2022-02-05 | Fresno | California | 6019 | 233258 | 2477 |
2180895 | 2180895 | 2022-02-04 | Fresno | California | 6019 | 233258 | 2477 |
2177644 | 2177644 | 2022-02-03 | Fresno | California | 6019 | 231695 | 2463 |
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);