ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Kern" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 646 ✖
- 162767 7
- 111111 5
- 156517 5
- 161987 5
- 126859 4
- 231871 4
- 242458 4
- 242682 4
- 242888 4
- 243186 4
- 243475 4
- 243954 4
- 553 3
- 110948 3
- 111341 3
- 111687 3
- 112318 3
- 113216 3
- 115007 3
- 117101 3
- 119708 3
- 122950 3
- 130375 3
- 134397 3
- 136932 3
- 139554 3
- 141890 3
- 144146 3
- 146348 3
- 148990 3
- 151432 3
- 153681 3
- 155451 3
- 158270 3
- 159721 3
- 161083 3
- 169213 3
- 181112 3
- 196125 3
- 210736 3
- 220089 3
- 226717 3
- 235765 3
- 239635 3
- 240904 3
- 241875 3
- 242196 3
- 242598 3
- 242803 3
- 243003 3
- 243325 3
- 243687 3
- 244205 3
- 1 2
- 2 2
- 5 2
- 671 2
- 110799 2
- 110847 2
- 111049 2
- 111060 2
- 111273 2
- 111437 2
- 111571 2
- 111894 2
- 112063 2
- 153048 2
- 242015 2
- 242104 2
- 242261 2
- 242345 2
- 4 1
- 14 1
- 24 1
- 33 1
- 41 1
- 47 1
- 51 1
- 76 1
- 101 1
- 110 1
- 155 1
- 199 1
- 205 1
- 225 1
- 246 1
- 267 1
- 309 1
- 330 1
- 363 1
- 369 1
- 396 1
- 454 1
- 524 1
- 619 1
- 623 1
- 643 1
- 713 1
- 744 1
- 764 1
- 809 1
- 837 1
- 865 1
- 882 1
- 910 1
- 941 1
- 972 1
- 1007 1
- 1025 1
- 1047 1
- 1084 1
- 1133 1
- 1176 1
- 1238 1
- 1264 1
- 1300 1
- 1331 1
- 1363 1
- 1403 1
- 1438 1
- 1483 1
- 1525 1
- 1562 1
- 1596 1
- 1615 1
- 1654 1
- 1705 1
- 1767 1
- 1834 1
- 1881 1
- 1890 1
- 1951 1
- 2017 1
- 2086 1
- 2155 1
- 2260 1
- 2332 1
- 2386 1
- 2428 1
- 2472 1
- 2544 1
- 2660 1
- 2730 1
- 2804 1
- 2880 1
- 2952 1
- 3026 1
- 3140 1
- 3205 1
- 3291 1
- 3377 1
- 3462 1
- 3522 1
- 3600 1
- 3716 1
- 3803 1
- 3900 1
- 3975 1
- 4059 1
- 4118 1
- 4192 1
- 4310 1
- 4366 1
- 4488 1
- 4558 1
- 4665 1
- 4778 1
- 4949 1
- 5110 1
- 5213 1
- 5255 1
- 5379 1
- 5553 1
- 5769 1
- 5989 1
- 6205 1
- 6349 1
- 6512 1
- 6662 1
- 6808 1
- 6979 1
- 7155 1
- 7435 1
- 8291 1
- 9250 1
- 10094 1
- 10908 1
- 11998 1
- 13513 1
- 14491 1
- 16124 1
- 16910 1
- 17394 1
- 17994 1
- 18834 1
- 19073 1
- 19552 1
- 20061 1
- 20796 1
- 21162 1
- 21285 1
- 21433 1
- 21724 1
- 22009 1
- 22626 1
- 23583 1
- 24440 1
- 24995 1
- 25179 1
- 25499 1
- 25888 1
- 26266 1
- 26570 1
- 26788 1
- 26968 1
- 27184 1
- 27378 1
- 27658 1
- 27915 1
- 28140 1
- 28234 1
- 28520 1
- 28631 1
- 28854 1
- 28961 1
- 29105 1
- 29230 1
- 29324 1
- 29459 1
- 29602 1
- 29763 1
- 29858 1
- 30040 1
- 30080 1
- 30179 1
- 30202 1
- 30371 1
- 30440 1
- 30563 1
- 30622 1
- 30735 1
- 30850 1
- 30916 1
- 31076 1
- 31148 1
- 31261 1
- 31379 1
- 31509 1
- 31572 1
- 31647 1
- 31712 1
- 31785 1
- 31865 1
- 31947 1
- 31994 1
- 32019 1
- 32073 1
- 32128 1
- 32184 1
- 32343 1
- 32443 1
- 32491 1
- 32522 1
- 32609 1
- 32674 1
- 32741 1
- 32831 1
- 32878 1
- 32966 1
- 33020 1
- 33089 1
- 33145 1
- 33225 1
- 33286 1
- 33373 1
- 33448 1
- 33497 1
- 33551 1
- 33630 1
- 33669 1
- 33775 1
- 33813 1
- 33881 1
- 33928 1
- 34027 1
- 34114 1
- 34154 1
- 34308 1
- 34378 1
- 34457 1
- 34563 1
- 34676 1
- 34779 1
- 34973 1
- 35063 1
- 35205 1
- 35394 1
- 35467 1
- 35610 1
- 35818 1
- 36069 1
- 36227 1
- 36470 1
- 36618 1
- 36919 1
- 37141 1
- 37323 1
- 37632 1
- 37982 1
- 38316 1
- 38519 1
- 39437 1
- 39721 1
- 39990 1
- 40337 1
- 40632 1
- 41328 1
- 41827 1
- 41957 1
- 42614 1
- 42937 1
- 43355 1
- 43860 1
- 44327 1
- 45078 1
- 45342 1
- 46397 1
- 47411 1
- 48401 1
- 49232 1
- 49939 1
- 50624 1
- 51612 1
- 53694 1
- 54681 1
- 55801 1
- 56687 1
- 57205 1
- 58200 1
- 59148 1
- 60260 1
- 61324 1
- 62439 1
- 63044 1
- 63557 1
- 64810 1
- 66526 1
- 67292 1
- 68316 1
- 68969 1
- 69484 1
- 70358 1
- 71033 1
- 72270 1
- 72878 1
- 73892 1
- 74732 1
- 76673 1
- 77875 1
- 78832 1
- 79728 1
- 80674 1
- 81490 1
- 82398 1
- 83547 1
- 84644 1
- 85362 1
- 86188 1
- 86718 1
- 87240 1
- 87714 1
- 88399 1
- 89095 1
- 90213 1
- 90564 1
- 91119 1
- 91762 1
- 92327 1
- 92992 1
- 93628 1
- 94113 1
- 94467 1
- 94994 1
- 95554 1
- 95993 1
- 96514 1
- 96862 1
- 97249 1
- 97522 1
- 98187 1
- 98636 1
- 99087 1
- 99570 1
- 100025 1
- 100290 1
- 100434 1
- 100586 1
- 100849 1
- 101157 1
- 101370 1
- 101613 1
- 101738 1
- 101849 1
- 102137 1
- 102332 1
- 102627 1
- 102998 1
- 103143 1
- 103295 1
- 103422 1
- 103622 1
- 103756 1
- 103894 1
- 104057 1
- 104181 1
- 104242 1
- 104307 1
- 104443 1
- 104509 1
- 104564 1
- 104763 1
- 104814 1
- 104878 1
- 104943 1
- 105020 1
- 105144 1
- 105222 1
- 105368 1
- 105441 1
- 105499 1
- 105542 1
- 105625 1
- 105810 1
- 105868 1
- 105912 1
- 105994 1
- 106074 1
- 106127 1
- 106155 1
- 106239 1
- 106288 1
- 106329 1
- 106420 1
- 106460 1
- 106480 1
- 106543 1
- 106628 1
- 106724 1
- 106984 1
- 107172 1
- 107341 1
- 107374 1
- 107434 1
- 107591 1
- 107648 1
- 107764 1
- 107825 1
- 107859 1
- 107879 1
- 108013 1
- 108061 1
- 108131 1
- 108195 1
- 108256 1
- 108280 1
- 108313 1
- 108418 1
- 108456 1
- 108479 1
- 108545 1
- 108598 1
- 108628 1
- 108652 1
- 108719 1
- 108822 1
- 108887 1
- 108968 1
- 108993 1
- 109031 1
- 109052 1
- 109101 1
- 109139 1
- 109177 1
- 109186 1
- 109272 1
- 109298 1
- 109320 1
- 109351 1
- 109424 1
- 109506 1
- 109566 1
- 109630 1
- 109654 1
- 109676 1
- 109738 1
- 109830 1
- 109904 1
- 109999 1
- 110089 1
- 110111 1
- 110131 1
- 110147 1
- 110188 1
- 110252 1
- 110302 1
- 110350 1
- 110372 1
- 110395 1
- 110458 1
- 110522 1
- 110546 1
- 110559 1
- 110593 1
- 110604 1
- 110617 1
- 110673 1
- 110687 1
- 110710 1
- 110734 1
- 110762 1
- 110782 1
- 112623 1
- 112798 1
- 112933 1
- 113071 1
- 113810 1
- 114079 1
- 114342 1
- 114699 1
- 115910 1
- 116120 1
- 116475 1
- 116731 1
- 118025 1
- 118360 1
- 118794 1
- 119277 1
- 120857 1
- 121299 1
- 121898 1
- 122386 1
- 124432 1
- 124943 1
- 125636 1
- 126250 1
- 128770 1
- 129325 1
- 129808 1
- 132125 1
- 132607 1
- 133282 1
- 133792 1
- 135842 1
- 136288 1
- 136494 1
- 136679 1
- 137884 1
- 138233 1
- 138615 1
- 139021 1
- 140373 1
- 140649 1
- 141102 1
- 141463 1
- 142637 1
- 142932 1
- 143272 1
- 143716 1
- 144914 1
- 145227 1
- 145589 1
- 145962 1
- 147294 1
- 147784 1
- 148261 1
- 148507 1
- 149959 1
- 150230 1
- 150632 1
- 150971 1
- 152418 1
- 152732 1
- 154185 1
- 154583 1
- 154896 1
- 155118 1
- 155990 1
- 156264 1
- 157525 1
- 157662 1
- 157875 1
- 158009 1
- 158834 1
- 159023 1
- 159336 1
- 159493 1
- 160199 1
- 160477 1
- 160699 1
- 160825 1
- 161540 1
- 161760 1
- 165859 1
- 166183 1
- 166790 1
- 167686 1
- 174442 1
- 175585 1
- 177220 1
- 179110 1
- 184362 1
- 189849 1
- 191741 1
- 193774 1
- 203066 1
- 204686 1
- 207114 1
- 208859 1
- 214959 1
- 215929 1
- 217169 1
- 218219 1
- 221944 1
- 222651 1
- 224771 1
- 225509 1
- 228153 1
- 229034 1
- 229772 1
- 230630 1
- 233501 1
- 234269 1
- 235122 1
- 236843 1
- 237530 1
- 238120 1
- 238866 1
- 240299 1
- 240461 1
- 240530 1
- 240705 1
- 241233 1
- 241421 1
- 241657 1
- 241765 1
- 244681 1
state 1
- California 788
fips 1
- 6029 788
county 1
- Kern · 788 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499776 | 2499776 | 2022-05-13 | Kern | California | 6029 | 244681 | 2427 |
2496518 | 2496518 | 2022-05-12 | Kern | California | 6029 | 244205 | 2396 |
2493260 | 2493260 | 2022-05-11 | Kern | California | 6029 | 244205 | 2396 |
2490002 | 2490002 | 2022-05-10 | Kern | California | 6029 | 244205 | 2396 |
2486745 | 2486745 | 2022-05-09 | Kern | California | 6029 | 243954 | 2395 |
2483487 | 2483487 | 2022-05-08 | Kern | California | 6029 | 243954 | 2395 |
2480229 | 2480229 | 2022-05-07 | Kern | California | 6029 | 243954 | 2395 |
2476971 | 2476971 | 2022-05-06 | Kern | California | 6029 | 243954 | 2395 |
2473713 | 2473713 | 2022-05-05 | Kern | California | 6029 | 243687 | 2386 |
2470456 | 2470456 | 2022-05-04 | Kern | California | 6029 | 243687 | 2386 |
2467200 | 2467200 | 2022-05-03 | Kern | California | 6029 | 243687 | 2386 |
2463945 | 2463945 | 2022-05-02 | Kern | California | 6029 | 243475 | 2363 |
2460689 | 2460689 | 2022-05-01 | Kern | California | 6029 | 243475 | 2363 |
2457433 | 2457433 | 2022-04-30 | Kern | California | 6029 | 243475 | 2363 |
2454177 | 2454177 | 2022-04-29 | Kern | California | 6029 | 243475 | 2363 |
2450921 | 2450921 | 2022-04-28 | Kern | California | 6029 | 243325 | 2360 |
2447665 | 2447665 | 2022-04-27 | Kern | California | 6029 | 243325 | 2360 |
2444409 | 2444409 | 2022-04-26 | Kern | California | 6029 | 243325 | 2360 |
2441153 | 2441153 | 2022-04-25 | Kern | California | 6029 | 243186 | 2356 |
2437897 | 2437897 | 2022-04-24 | Kern | California | 6029 | 243186 | 2356 |
2434641 | 2434641 | 2022-04-23 | Kern | California | 6029 | 243186 | 2356 |
2431385 | 2431385 | 2022-04-22 | Kern | California | 6029 | 243186 | 2356 |
2428129 | 2428129 | 2022-04-21 | Kern | California | 6029 | 243003 | 2344 |
2424873 | 2424873 | 2022-04-20 | Kern | California | 6029 | 243003 | 2344 |
2421617 | 2421617 | 2022-04-19 | Kern | California | 6029 | 243003 | 2344 |
2418361 | 2418361 | 2022-04-18 | Kern | California | 6029 | 242888 | 2334 |
2415105 | 2415105 | 2022-04-17 | Kern | California | 6029 | 242888 | 2334 |
2411849 | 2411849 | 2022-04-16 | Kern | California | 6029 | 242888 | 2334 |
2408593 | 2408593 | 2022-04-15 | Kern | California | 6029 | 242888 | 2334 |
2405337 | 2405337 | 2022-04-14 | Kern | California | 6029 | 242803 | 2323 |
2402082 | 2402082 | 2022-04-13 | Kern | California | 6029 | 242803 | 2323 |
2398827 | 2398827 | 2022-04-12 | Kern | California | 6029 | 242803 | 2323 |
2395572 | 2395572 | 2022-04-11 | Kern | California | 6029 | 242682 | 2320 |
2392316 | 2392316 | 2022-04-10 | Kern | California | 6029 | 242682 | 2320 |
2389060 | 2389060 | 2022-04-09 | Kern | California | 6029 | 242682 | 2320 |
2385805 | 2385805 | 2022-04-08 | Kern | California | 6029 | 242682 | 2320 |
2382550 | 2382550 | 2022-04-07 | Kern | California | 6029 | 242598 | 2304 |
2379295 | 2379295 | 2022-04-06 | Kern | California | 6029 | 242598 | 2304 |
2376041 | 2376041 | 2022-04-05 | Kern | California | 6029 | 242598 | 2304 |
2372789 | 2372789 | 2022-04-04 | Kern | California | 6029 | 242458 | 2294 |
2369536 | 2369536 | 2022-04-03 | Kern | California | 6029 | 242458 | 2294 |
2366283 | 2366283 | 2022-04-02 | Kern | California | 6029 | 242458 | 2294 |
2363030 | 2363030 | 2022-04-01 | Kern | California | 6029 | 242458 | 2294 |
2359776 | 2359776 | 2022-03-31 | Kern | California | 6029 | 242345 | 2281 |
2356522 | 2356522 | 2022-03-30 | Kern | California | 6029 | 242345 | 2281 |
2353269 | 2353269 | 2022-03-29 | Kern | California | 6029 | 242261 | 2273 |
2350017 | 2350017 | 2022-03-28 | Kern | California | 6029 | 242261 | 2273 |
2346764 | 2346764 | 2022-03-27 | Kern | California | 6029 | 242196 | 2265 |
2343511 | 2343511 | 2022-03-26 | Kern | California | 6029 | 242196 | 2265 |
2340258 | 2340258 | 2022-03-25 | Kern | California | 6029 | 242196 | 2265 |
2337005 | 2337005 | 2022-03-24 | Kern | California | 6029 | 242104 | 2244 |
2333751 | 2333751 | 2022-03-23 | Kern | California | 6029 | 242104 | 2244 |
2330497 | 2330497 | 2022-03-22 | Kern | California | 6029 | 242015 | 2230 |
2327245 | 2327245 | 2022-03-21 | Kern | California | 6029 | 242015 | 2230 |
2323992 | 2323992 | 2022-03-20 | Kern | California | 6029 | 241875 | 2225 |
2320738 | 2320738 | 2022-03-19 | Kern | California | 6029 | 241875 | 2225 |
2317484 | 2317484 | 2022-03-18 | Kern | California | 6029 | 241875 | 2225 |
2314231 | 2314231 | 2022-03-17 | Kern | California | 6029 | 241765 | 2222 |
2310978 | 2310978 | 2022-03-16 | Kern | California | 6029 | 241657 | 2204 |
2307725 | 2307725 | 2022-03-15 | Kern | California | 6029 | 241421 | 2196 |
2304474 | 2304474 | 2022-03-14 | Kern | California | 6029 | 241233 | 2188 |
2301222 | 2301222 | 2022-03-13 | Kern | California | 6029 | 240904 | 2182 |
2297970 | 2297970 | 2022-03-12 | Kern | California | 6029 | 240904 | 2182 |
2294718 | 2294718 | 2022-03-11 | Kern | California | 6029 | 240904 | 2182 |
2291466 | 2291466 | 2022-03-10 | Kern | California | 6029 | 240705 | 2182 |
2288214 | 2288214 | 2022-03-09 | Kern | California | 6029 | 240530 | 2173 |
2284963 | 2284963 | 2022-03-08 | Kern | California | 6029 | 240461 | 2167 |
2281711 | 2281711 | 2022-03-07 | Kern | California | 6029 | 240299 | 2158 |
2278458 | 2278458 | 2022-03-06 | Kern | California | 6029 | 239635 | 2147 |
2275205 | 2275205 | 2022-03-05 | Kern | California | 6029 | 239635 | 2147 |
2271952 | 2271952 | 2022-03-04 | Kern | California | 6029 | 239635 | 2147 |
2268700 | 2268700 | 2022-03-03 | Kern | California | 6029 | 238866 | 2136 |
2265447 | 2265447 | 2022-03-02 | Kern | California | 6029 | 238120 | 2130 |
2262196 | 2262196 | 2022-03-01 | Kern | California | 6029 | 237530 | 2122 |
2258945 | 2258945 | 2022-02-28 | Kern | California | 6029 | 236843 | 2117 |
2255694 | 2255694 | 2022-02-27 | Kern | California | 6029 | 235765 | 2107 |
2252443 | 2252443 | 2022-02-26 | Kern | California | 6029 | 235765 | 2107 |
2249192 | 2249192 | 2022-02-25 | Kern | California | 6029 | 235765 | 2107 |
2245941 | 2245941 | 2022-02-24 | Kern | California | 6029 | 235122 | 2107 |
2242690 | 2242690 | 2022-02-23 | Kern | California | 6029 | 234269 | 2107 |
2239439 | 2239439 | 2022-02-22 | Kern | California | 6029 | 233501 | 2107 |
2236188 | 2236188 | 2022-02-21 | Kern | California | 6029 | 231871 | 2101 |
2232937 | 2232937 | 2022-02-20 | Kern | California | 6029 | 231871 | 2101 |
2229686 | 2229686 | 2022-02-19 | Kern | California | 6029 | 231871 | 2101 |
2226435 | 2226435 | 2022-02-18 | Kern | California | 6029 | 231871 | 2101 |
2223184 | 2223184 | 2022-02-17 | Kern | California | 6029 | 230630 | 2095 |
2219933 | 2219933 | 2022-02-16 | Kern | California | 6029 | 229772 | 2087 |
2216682 | 2216682 | 2022-02-15 | Kern | California | 6029 | 229034 | 2077 |
2213431 | 2213431 | 2022-02-14 | Kern | California | 6029 | 228153 | 2074 |
2210179 | 2210179 | 2022-02-13 | Kern | California | 6029 | 226717 | 2058 |
2206926 | 2206926 | 2022-02-12 | Kern | California | 6029 | 226717 | 2058 |
2203673 | 2203673 | 2022-02-11 | Kern | California | 6029 | 226717 | 2058 |
2200420 | 2200420 | 2022-02-10 | Kern | California | 6029 | 225509 | 2051 |
2197166 | 2197166 | 2022-02-09 | Kern | California | 6029 | 224771 | 2043 |
2193911 | 2193911 | 2022-02-08 | Kern | California | 6029 | 222651 | 2040 |
2190658 | 2190658 | 2022-02-07 | Kern | California | 6029 | 221944 | 2032 |
2187405 | 2187405 | 2022-02-06 | Kern | California | 6029 | 220089 | 2031 |
2184152 | 2184152 | 2022-02-05 | Kern | California | 6029 | 220089 | 2031 |
2180900 | 2180900 | 2022-02-04 | Kern | California | 6029 | 220089 | 2031 |
2177649 | 2177649 | 2022-02-03 | Kern | California | 6029 | 218219 | 2019 |
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);