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: deaths, date (date)
cases 655 ✖
- 1 7
- 253824 6
- 155899 5
- 2 4
- 102512 4
- 146318 4
- 161033 4
- 163067 4
- 244801 4
- 253293 4
- 254590 4
- 255391 4
- 255954 4
- 256677 4
- 10 3
- 31251 3
- 31594 3
- 32022 3
- 111942 3
- 112322 3
- 113113 3
- 114229 3
- 137387 3
- 139735 3
- 142025 3
- 144123 3
- 148938 3
- 151513 3
- 155092 3
- 157469 3
- 158802 3
- 159925 3
- 168865 3
- 181673 3
- 201080 3
- 220181 3
- 233258 3
- 240509 3
- 247269 3
- 249081 3
- 250035 3
- 250990 3
- 252053 3
- 253676 3
- 254703 3
- 255591 3
- 256219 3
- 257043 3
- 4 2
- 43 2
- 201 2
- 222 2
- 315 2
- 458 2
- 633 2
- 885 2
- 1192 2
- 1482 2
- 2122 2
- 2547 2
- 3245 2
- 4474 2
- 6110 2
- 8282 2
- 21316 2
- 30731 2
- 32430 2
- 33162 2
- 33809 2
- 34858 2
- 35711 2
- 37063 2
- 115897 2
- 153221 2
- 153840 2
- 13 1
- 18 1
- 19 1
- 27 1
- 31 1
- 53 1
- 68 1
- 82 1
- 94 1
- 100 1
- 103 1
- 108 1
- 124 1
- 146 1
- 156 1
- 173 1
- 191 1
- 265 1
- 295 1
- 311 1
- 351 1
- 371 1
- 384 1
- 419 1
- 443 1
- 498 1
- 521 1
- 538 1
- 564 1
- 615 1
- 672 1
- 724 1
- 777 1
- 813 1
- 841 1
- 945 1
- 984 1
- 1014 1
- 1074 1
- 1156 1
- 1263 1
- 1287 1
- 1338 1
- 1372 1
- 1417 1
- 1448 1
- 1535 1
- 1631 1
- 1658 1
- 1714 1
- 1743 1
- 1744 1
- 1882 1
- 1914 1
- 1944 1
- 2014 1
- 2080 1
- 2216 1
- 2286 1
- 2318 1
- 2395 1
- 2478 1
- 2706 1
- 2788 1
- 2900 1
- 3058 1
- 3187 1
- 3485 1
- 3672 1
- 3892 1
- 4053 1
- 4374 1
- 4811 1
- 5008 1
- 5289 1
- 5626 1
- 5851 1
- 6599 1
- 6924 1
- 7281 1
- 7627 1
- 7906 1
- 8407 1
- 8756 1
- 8941 1
- 9124 1
- 9565 1
- 9954 1
- 10381 1
- 10639 1
- 10970 1
- 11412 1
- 11756 1
- 12164 1
- 12564 1
- 12866 1
- 13209 1
- 13485 1
- 13933 1
- 14312 1
- 14793 1
- 15083 1
- 15448 1
- 15759 1
- 15945 1
- 16272 1
- 16625 1
- 16641 1
- 17290 1
- 17538 1
- 17846 1
- 17978 1
- 18344 1
- 18690 1
- 19157 1
- 19900 1
- 20603 1
- 21010 1
- 22167 1
- 22535 1
- 22840 1
- 23197 1
- 23414 1
- 23618 1
- 23932 1
- 24071 1
- 24367 1
- 24612 1
- 24821 1
- 24963 1
- 25185 1
- 25542 1
- 25785 1
- 25978 1
- 26147 1
- 26325 1
- 26471 1
- 26565 1
- 26640 1
- 26724 1
- 26783 1
- 26917 1
- 27076 1
- 27196 1
- 27232 1
- 27312 1
- 27381 1
- 27487 1
- 27560 1
- 27668 1
- 27769 1
- 27843 1
- 27944 1
- 28019 1
- 28106 1
- 28199 1
- 28336 1
- 28441 1
- 28517 1
- 28621 1
- 28706 1
- 28796 1
- 28855 1
- 28975 1
- 29022 1
- 29065 1
- 29069 1
- 29111 1
- 29136 1
- 29208 1
- 29286 1
- 29419 1
- 29523 1
- 29579 1
- 29650 1
- 29727 1
- 29796 1
- 29911 1
- 30051 1
- 30194 1
- 30220 1
- 30328 1
- 30752 1
- 30858 1
- 31613 1
- 32497 1
- 32619 1
- 33287 1
- 33969 1
- 34297 1
- 34997 1
- 35973 1
- 36315 1
- 37349 1
- 37947 1
- 37994 1
- 38288 1
- 38568 1
- 38956 1
- 39004 1
- 39324 1
- 40033 1
- 40108 1
- 40568 1
- 40869 1
- 41460 1
- 41574 1
- 41954 1
- 42788 1
- 43071 1
- 43756 1
- 44114 1
- 44726 1
- 47316 1
- 49173 1
- 49918 1
- 52643 1
- 55428 1
- 57616 1
- 58568 1
- 59640 1
- 60488 1
- 61435 1
- 62251 1
- 63080 1
- 63811 1
- 64274 1
- 65149 1
- 65400 1
- 66442 1
- 67484 1
- 68740 1
- 69318 1
- 69871 1
- 70971 1
- 71404 1
- 72557 1
- 73689 1
- 74816 1
- 75621 1
- 76581 1
- 77651 1
- 78278 1
- 79033 1
- 79950 1
- 81294 1
- 82039 1
- 82485 1
- 83200 1
- 83591 1
- 84137 1
- 84744 1
- 85274 1
- 85808 1
- 86336 1
- 86673 1
- 86886 1
- 87401 1
- 87936 1
- 88476 1
- 88852 1
- 89272 1
- 89542 1
- 89748 1
- 90126 1
- 90513 1
- 90944 1
- 91184 1
- 91430 1
- 91730 1
- 91876 1
- 92168 1
- 92520 1
- 92807 1
- 93065 1
- 93231 1
- 93363 1
- 93555 1
- 93734 1
- 93973 1
- 94234 1
- 94374 1
- 94584 1
- 94741 1
- 94794 1
- 95015 1
- 95202 1
- 95393 1
- 95548 1
- 95677 1
- 95785 1
- 95893 1
- 96023 1
- 96184 1
- 96366 1
- 96549 1
- 96665 1
- 96744 1
- 96866 1
- 97026 1
- 97185 1
- 97324 1
- 97461 1
- 97520 1
- 97638 1
- 97727 1
- 97856 1
- 97969 1
- 98112 1
- 98211 1
- 98276 1
- 98362 1
- 98437 1
- 98602 1
- 98731 1
- 98901 1
- 99004 1
- 99085 1
- 99156 1
- 99240 1
- 99317 1
- 99551 1
- 99602 1
- 99702 1
- 99755 1
- 99814 1
- 99865 1
- 99935 1
- 100027 1
- 100135 1
- 100230 1
- 100277 1
- 100357 1
- 100376 1
- 100431 1
- 100500 1
- 100562 1
- 100621 1
- 100702 1
- 100768 1
- 100838 1
- 100864 1
- 100928 1
- 100991 1
- 101061 1
- 101099 1
- 101138 1
- 101161 1
- 101189 1
- 101263 1
- 101326 1
- 101372 1
- 101405 1
- 101451 1
- 101491 1
- 101536 1
- 101625 1
- 101676 1
- 101729 1
- 101755 1
- 101792 1
- 101838 1
- 101862 1
- 101917 1
- 101957 1
- 101987 1
- 102013 1
- 102056 1
- 102085 1
- 102135 1
- 102189 1
- 102238 1
- 102270 1
- 102289 1
- 102329 1
- 102374 1
- 102413 1
- 102437 1
- 102464 1
- 102470 1
- 102490 1
- 102499 1
- 102507 1
- 102534 1
- 102547 1
- 102566 1
- 102592 1
- 102601 1
- 102616 1
- 102626 1
- 102642 1
- 102659 1
- 102680 1
- 102690 1
- 102724 1
- 102770 1
- 102783 1
- 102795 1
- 102812 1
- 102828 1
- 102842 1
- 102867 1
- 102894 1
- 102922 1
- 102947 1
- 102971 1
- 102996 1
- 103020 1
- 103061 1
- 103073 1
- 103091 1
- 103110 1
- 103121 1
- 111906 1
- 112080 1
- 112120 1
- 112176 1
- 112233 1
- 112565 1
- 112617 1
- 112705 1
- 112980 1
- 113495 1
- 113619 1
- 113764 1
- 114048 1
- 114929 1
- 115061 1
- 115322 1
- 115577 1
- 116539 1
- 116756 1
- 116988 1
- 117294 1
- 117451 1
- 117871 1
- 118316 1
- 118734 1
- 119060 1
- 119301 1
- 119941 1
- 120525 1
- 120949 1
- 121317 1
- 121767 1
- 122059 1
- 122447 1
- 123026 1
- 123625 1
- 124095 1
- 124722 1
- 125320 1
- 125743 1
- 126108 1
- 127396 1
- 127981 1
- 128463 1
- 128997 1
- 129522 1
- 129873 1
- 130227 1
- 130757 1
- 131266 1
- 131662 1
- 132281 1
- 132846 1
- 133029 1
- 133272 1
- 133773 1
- 134246 1
- 134729 1
- 135172 1
- 135647 1
- 135861 1
- 136163 1
- 136665 1
- 137094 1
- 138323 1
- 138563 1
- 138965 1
- 139353 1
- 140650 1
- 140950 1
- 141242 1
- 141591 1
- 142951 1
- 143220 1
- 143365 1
- 143745 1
- 145119 1
- 145378 1
- 145503 1
- 145877 1
- 147826 1
- 148063 1
- 148484 1
- 150202 1
- 150458 1
- 150681 1
- 151137 1
- 152527 1
- 152730 1
- 152930 1
- 154257 1
- 154403 1
- 154588 1
- 154879 1
- 155716 1
- 155803 1
- 156677 1
- 156795 1
- 156897 1
- 157242 1
- 158187 1
- 158274 1
- 158450 1
- 158644 1
- 159332 1
- 159455 1
- 159570 1
- 159746 1
- 160392 1
- 160492 1
- 160594 1
- 160844 1
- 161832 1
- 161993 1
- 162458 1
- 165814 1
- 166384 1
- 166504 1
- 173460 1
- 175064 1
- 176980 1
- 179628 1
- 189130 1
- 191271 1
- 193234 1
- 197314 1
- 209430 1
- 211880 1
- 214050 1
- 217179 1
- 227135 1
- 228079 1
- 228842 1
- 231695 1
- 234445 1
- 236214 1
- 238135 1
- 239589 1
- 242286 1
- 242960 1
- 243273 1
- 244263 1
- 246130 1
- 246311 1
- 246898 1
- 247987 1
- 248109 1
- 248184 1
- 248859 1
- 249441 1
- 249597 1
- 249735 1
- 249879 1
- 250415 1
- 250464 1
- 250625 1
- 250811 1
- 251322 1
- 251399 1
- 251576 1
- 251910 1
- 252303 1
- 252398 1
- 252510 1
- 253182 1
- 254460 1
- 257611 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);