ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 9009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 584 ✖
- 13793 4
- 44134 4
- 91876 4
- 92430 4
- 99203 4
- 103448 4
- 124326 4
- 133669 4
- 24 3
- 12409 3
- 12532 3
- 12733 3
- 12884 3
- 13041 3
- 13145 3
- 13316 3
- 13442 3
- 13622 3
- 13961 3
- 14164 3
- 14340 3
- 14583 3
- 14877 3
- 15455 3
- 16073 3
- 17352 3
- 19154 3
- 22015 3
- 25248 3
- 27925 3
- 32843 3
- 37836 3
- 41723 3
- 52278 3
- 56512 3
- 60085 3
- 63085 3
- 65488 3
- 67586 3
- 69233 3
- 71194 3
- 72947 3
- 74678 3
- 76466 3
- 79060 3
- 81793 3
- 84116 3
- 86260 3
- 88101 3
- 89526 3
- 90562 3
- 91189 3
- 91552 3
- 92013 3
- 92136 3
- 92224 3
- 92342 3
- 92573 3
- 92751 3
- 93068 3
- 93680 3
- 94736 3
- 95700 3
- 96757 3
- 98090 3
- 100143 3
- 101274 3
- 101994 3
- 102740 3
- 104308 3
- 104990 3
- 105535 3
- 106133 3
- 106748 3
- 107964 3
- 109448 3
- 110848 3
- 114705 3
- 118666 3
- 149587 3
- 167580 3
- 176971 3
- 182543 3
- 185076 3
- 186894 3
- 189204 3
- 189814 3
- 190557 3
- 193017 3
- 193688 3
- 194335 3
- 195022 3
- 195898 3
- 197193 3
- 198601 3
- 200168 3
- 202240 3
- 8024 2
- 27092 2
- 47375 2
- 48507 2
- 108996 2
- 1 1
- 3 1
- 4 1
- 8 1
- 10 1
- 29 1
- 41 1
- 89 1
- 127 1
- 156 1
- 222 1
- 236 1
- 280 1
- 373 1
- 517 1
- 611 1
- 647 1
- 891 1
- 1024 1
- 1162 1
- 1468 1
- 1664 1
- 1945 1
- 2183 1
- 2383 1
- 2715 1
- 2946 1
- 3358 1
- 3543 1
- 3758 1
- 4163 1
- 4520 1
- 4743 1
- 4871 1
- 5272 1
- 5493 1
- 5811 1
- 6064 1
- 6286 1
- 6509 1
- 6715 1
- 6993 1
- 7089 1
- 7205 1
- 7536 1
- 7900 1
- 8110 1
- 8337 1
- 8419 1
- 8678 1
- 8887 1
- 9091 1
- 9209 1
- 9260 1
- 9430 1
- 9570 1
- 9712 1
- 9881 1
- 10075 1
- 10159 1
- 10338 1
- 10427 1
- 10587 1
- 10663 1
- 10756 1
- 10847 1
- 10905 1
- 11017 1
- 11121 1
- 11124 1
- 11198 1
- 11241 1
- 11309 1
- 11323 1
- 11479 1
- 11525 1
- 11548 1
- 11582 1
- 11673 1
- 11817 1
- 11828 1
- 11860 1
- 11875 1
- 11911 1
- 11930 1
- 11979 1
- 12021 1
- 12034 1
- 12055 1
- 12078 1
- 12089 1
- 12105 1
- 12136 1
- 12174 1
- 12185 1
- 12196 1
- 12225 1
- 12227 1
- 12245 1
- 12254 1
- 12275 1
- 12299 1
- 12318 1
- 12359 1
- 12368 1
- 12383 1
- 12462 1
- 12473 1
- 12486 1
- 12509 1
- 12612 1
- 12617 1
- 12643 1
- 12686 1
- 12788 1
- 12794 1
- 12825 1
- 12835 1
- 12941 1
- 12965 1
- 12983 1
- 13013 1
- 13086 1
- 13100 1
- 13118 1
- 13128 1
- 13224 1
- 13240 1
- 13254 1
- 13272 1
- 13376 1
- 13378 1
- 13388 1
- 13422 1
- 13518 1
- 13524 1
- 13556 1
- 13584 1
- 13675 1
- 13711 1
- 13736 1
- 13763 1
- 13858 1
- 13877 1
- 13917 1
- 14059 1
- 14082 1
- 14102 1
- 14145 1
- 14261 1
- 14278 1
- 14294 1
- 14319 1
- 14434 1
- 14451 1
- 14477 1
- 14520 1
- 14715 1
- 14722 1
- 14749 1
- 14830 1
- 15164 1
- 15223 1
- 15263 1
- 15310 1
- 15680 1
- 15792 1
- 15876 1
- 15952 1
- 16594 1
- 16715 1
- 16837 1
- 17156 1
- 18048 1
- 18244 1
- 18374 1
- 18862 1
- 20053 1
- 20434 1
- 20892 1
- 21237 1
- 23113 1
- 23593 1
- 24115 1
- 24733 1
- 26531 1
- 26643 1
- 29455 1
- 30143 1
- 30819 1
- 32377 1
- 34777 1
- 35321 1
- 35720 1
- 36354 1
- 39576 1
- 40011 1
- 40539 1
- 41146 1
- 42747 1
- 43180 1
- 43568 1
- 46237 1
- 46466 1
- 46892 1
- 49678 1
- 50290 1
- 50791 1
- 51566 1
- 53924 1
- 54757 1
- 55665 1
- 55943 1
- 58165 1
- 58627 1
- 59168 1
- 59585 1
- 61489 1
- 61803 1
- 62396 1
- 62757 1
- 63937 1
- 64733 1
- 64889 1
- 65075 1
- 66619 1
- 66828 1
- 67075 1
- 67380 1
- 68437 1
- 68593 1
- 68795 1
- 68953 1
- 69832 1
- 70150 1
- 70592 1
- 70893 1
- 71998 1
- 72163 1
- 72368 1
- 72658 1
- 73618 1
- 73834 1
- 74020 1
- 74277 1
- 75354 1
- 75647 1
- 75759 1
- 76092 1
- 77335 1
- 77638 1
- 78094 1
- 78536 1
- 80047 1
- 80542 1
- 80806 1
- 81318 1
- 82651 1
- 82967 1
- 83315 1
- 83646 1
- 84979 1
- 85325 1
- 85768 1
- 85999 1
- 86954 1
- 87196 1
- 87454 1
- 87713 1
- 88766 1
- 88949 1
- 89138 1
- 89291 1
- 89913 1
- 90041 1
- 90248 1
- 90432 1
- 90788 1
- 90949 1
- 91001 1
- 91085 1
- 91372 1
- 91382 1
- 91474 1
- 91512 1
- 91680 1
- 91728 1
- 91762 1
- 91795 1
- 91939 1
- 91959 1
- 91980 1
- 92079 1
- 92094 1
- 92115 1
- 92127 1
- 92170 1
- 92183 1
- 92186 1
- 92199 1
- 92264 1
- 92270 1
- 92280 1
- 92314 1
- 92372 1
- 92385 1
- 92394 1
- 92403 1
- 92500 1
- 92519 1
- 92534 1
- 92587 1
- 92628 1
- 92661 1
- 92715 1
- 92825 1
- 92906 1
- 92963 1
- 93029 1
- 93208 1
- 93352 1
- 93463 1
- 93553 1
- 93986 1
- 94202 1
- 94378 1
- 94526 1
- 95045 1
- 95130 1
- 95376 1
- 95552 1
- 96149 1
- 96340 1
- 96504 1
- 96671 1
- 97062 1
- 97459 1
- 97670 1
- 97874 1
- 98478 1
- 98738 1
- 98889 1
- 99059 1
- 99629 1
- 99852 1
- 100014 1
- 100501 1
- 100676 1
- 100839 1
- 101035 1
- 101564 1
- 101655 1
- 101772 1
- 101903 1
- 102307 1
- 102458 1
- 102556 1
- 102606 1
- 103016 1
- 103110 1
- 103215 1
- 103314 1
- 103904 1
- 104002 1
- 104187 1
- 104575 1
- 104705 1
- 104773 1
- 104865 1
- 105228 1
- 105271 1
- 105357 1
- 105441 1
- 105766 1
- 105840 1
- 105929 1
- 106056 1
- 106330 1
- 106385 1
- 106526 1
- 106641 1
- 107237 1
- 107382 1
- 107605 1
- 107768 1
- 108507 1
- 108762 1
- 109979 1
- 110214 1
- 110417 1
- 110703 1
- 112425 1
- 112969 1
- 113208 1
- 113940 1
- 116779 1
- 117516 1
- 117870 1
- 118367 1
- 120403 1
- 122290 1
- 123300 1
- 127993 1
- 129536 1
- 131526 1
- 140745 1
- 143548 1
- 145539 1
- 147192 1
- 159375 1
- 161272 1
- 163214 1
- 165359 1
- 171881 1
- 173127 1
- 174385 1
- 175756 1
- 179656 1
- 180457 1
- 181108 1
- 181836 1
- 183151 1
- 183400 1
- 183922 1
- 184698 1
- 185705 1
- 186006 1
- 186255 1
- 186504 1
- 187271 1
- 187827 1
- 188832 1
- 188938 1
- 189500 1
- 189592 1
- 189689 1
- 189743 1
- 190110 1
- 190141 1
- 190172 1
- 190408 1
- 192053 1
- 192702 1
- 192804 1
- 192884 1
- 193275 1
- 193351 1
- 193445 1
- 193580 1
- 193901 1
- 194017 1
- 194103 1
- 194231 1
- 194567 1
- 194680 1
- 194786 1
- 194892 1
- 195319 1
- 195425 1
- 195533 1
- 195744 1
- 196334 1
- 196585 1
- 196791 1
- 196954 1
- 197674 1
- 197871 1
- 198147 1
- 198377 1
- 199084 1
- 199354 1
- 199602 1
- 199932 1
- 200763 1
- 201134 1
- 201354 1
- 201806 1
- 203366 1
- 203793 1
- 204406 1
- 204937 1
- 205522 1
state 1
- Connecticut 791
fips 1
- 9009 · 791 ✖
county 1
- New Haven 791
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499888 | 2499888 | 2022-05-13 | New Haven | Connecticut | 9009 | 205522 | 2839 |
2496630 | 2496630 | 2022-05-12 | New Haven | Connecticut | 9009 | 204937 | 2831 |
2493372 | 2493372 | 2022-05-11 | New Haven | Connecticut | 9009 | 204406 | 2831 |
2490114 | 2490114 | 2022-05-10 | New Haven | Connecticut | 9009 | 203793 | 2831 |
2486857 | 2486857 | 2022-05-09 | New Haven | Connecticut | 9009 | 203366 | 2830 |
2483599 | 2483599 | 2022-05-08 | New Haven | Connecticut | 9009 | 202240 | 2830 |
2480341 | 2480341 | 2022-05-07 | New Haven | Connecticut | 9009 | 202240 | 2830 |
2477083 | 2477083 | 2022-05-06 | New Haven | Connecticut | 9009 | 202240 | 2830 |
2473825 | 2473825 | 2022-05-05 | New Haven | Connecticut | 9009 | 201806 | 2825 |
2470568 | 2470568 | 2022-05-04 | New Haven | Connecticut | 9009 | 201354 | 2825 |
2467312 | 2467312 | 2022-05-03 | New Haven | Connecticut | 9009 | 201134 | 2824 |
2464057 | 2464057 | 2022-05-02 | New Haven | Connecticut | 9009 | 200763 | 2823 |
2460801 | 2460801 | 2022-05-01 | New Haven | Connecticut | 9009 | 200168 | 2823 |
2457545 | 2457545 | 2022-04-30 | New Haven | Connecticut | 9009 | 200168 | 2823 |
2454289 | 2454289 | 2022-04-29 | New Haven | Connecticut | 9009 | 200168 | 2823 |
2451033 | 2451033 | 2022-04-28 | New Haven | Connecticut | 9009 | 199932 | 2820 |
2447777 | 2447777 | 2022-04-27 | New Haven | Connecticut | 9009 | 199602 | 2820 |
2444521 | 2444521 | 2022-04-26 | New Haven | Connecticut | 9009 | 199354 | 2820 |
2441265 | 2441265 | 2022-04-25 | New Haven | Connecticut | 9009 | 199084 | 2818 |
2438009 | 2438009 | 2022-04-24 | New Haven | Connecticut | 9009 | 198601 | 2818 |
2434753 | 2434753 | 2022-04-23 | New Haven | Connecticut | 9009 | 198601 | 2818 |
2431497 | 2431497 | 2022-04-22 | New Haven | Connecticut | 9009 | 198601 | 2818 |
2428241 | 2428241 | 2022-04-21 | New Haven | Connecticut | 9009 | 198377 | 2817 |
2424985 | 2424985 | 2022-04-20 | New Haven | Connecticut | 9009 | 198147 | 2817 |
2421729 | 2421729 | 2022-04-19 | New Haven | Connecticut | 9009 | 197871 | 2814 |
2418473 | 2418473 | 2022-04-18 | New Haven | Connecticut | 9009 | 197674 | 2814 |
2415217 | 2415217 | 2022-04-17 | New Haven | Connecticut | 9009 | 197193 | 2814 |
2411961 | 2411961 | 2022-04-16 | New Haven | Connecticut | 9009 | 197193 | 2814 |
2408705 | 2408705 | 2022-04-15 | New Haven | Connecticut | 9009 | 197193 | 2814 |
2405449 | 2405449 | 2022-04-14 | New Haven | Connecticut | 9009 | 196954 | 2812 |
2402194 | 2402194 | 2022-04-13 | New Haven | Connecticut | 9009 | 196791 | 2812 |
2398939 | 2398939 | 2022-04-12 | New Haven | Connecticut | 9009 | 196585 | 2812 |
2395684 | 2395684 | 2022-04-11 | New Haven | Connecticut | 9009 | 196334 | 2811 |
2392428 | 2392428 | 2022-04-10 | New Haven | Connecticut | 9009 | 195898 | 2811 |
2389172 | 2389172 | 2022-04-09 | New Haven | Connecticut | 9009 | 195898 | 2811 |
2385917 | 2385917 | 2022-04-08 | New Haven | Connecticut | 9009 | 195898 | 2811 |
2382662 | 2382662 | 2022-04-07 | New Haven | Connecticut | 9009 | 195744 | 2811 |
2379407 | 2379407 | 2022-04-06 | New Haven | Connecticut | 9009 | 195533 | 2811 |
2376153 | 2376153 | 2022-04-05 | New Haven | Connecticut | 9009 | 195425 | 2809 |
2372901 | 2372901 | 2022-04-04 | New Haven | Connecticut | 9009 | 195319 | 2808 |
2369648 | 2369648 | 2022-04-03 | New Haven | Connecticut | 9009 | 195022 | 2808 |
2366395 | 2366395 | 2022-04-02 | New Haven | Connecticut | 9009 | 195022 | 2808 |
2363142 | 2363142 | 2022-04-01 | New Haven | Connecticut | 9009 | 195022 | 2808 |
2359888 | 2359888 | 2022-03-31 | New Haven | Connecticut | 9009 | 194892 | 2806 |
2356634 | 2356634 | 2022-03-30 | New Haven | Connecticut | 9009 | 194786 | 2805 |
2353381 | 2353381 | 2022-03-29 | New Haven | Connecticut | 9009 | 194680 | 2805 |
2350129 | 2350129 | 2022-03-28 | New Haven | Connecticut | 9009 | 194567 | 2796 |
2346876 | 2346876 | 2022-03-27 | New Haven | Connecticut | 9009 | 194335 | 2796 |
2343623 | 2343623 | 2022-03-26 | New Haven | Connecticut | 9009 | 194335 | 2796 |
2340370 | 2340370 | 2022-03-25 | New Haven | Connecticut | 9009 | 194335 | 2796 |
2337117 | 2337117 | 2022-03-24 | New Haven | Connecticut | 9009 | 194231 | 2789 |
2333863 | 2333863 | 2022-03-23 | New Haven | Connecticut | 9009 | 194103 | 2788 |
2330609 | 2330609 | 2022-03-22 | New Haven | Connecticut | 9009 | 194017 | 2789 |
2327357 | 2327357 | 2022-03-21 | New Haven | Connecticut | 9009 | 193901 | 2783 |
2324104 | 2324104 | 2022-03-20 | New Haven | Connecticut | 9009 | 193688 | 2780 |
2320850 | 2320850 | 2022-03-19 | New Haven | Connecticut | 9009 | 193688 | 2780 |
2317596 | 2317596 | 2022-03-18 | New Haven | Connecticut | 9009 | 193688 | 2780 |
2314343 | 2314343 | 2022-03-17 | New Haven | Connecticut | 9009 | 193580 | 2773 |
2311090 | 2311090 | 2022-03-16 | New Haven | Connecticut | 9009 | 193445 | 2773 |
2307837 | 2307837 | 2022-03-15 | New Haven | Connecticut | 9009 | 193351 | 2772 |
2304586 | 2304586 | 2022-03-14 | New Haven | Connecticut | 9009 | 193275 | 2769 |
2301334 | 2301334 | 2022-03-13 | New Haven | Connecticut | 9009 | 193017 | 2768 |
2298082 | 2298082 | 2022-03-12 | New Haven | Connecticut | 9009 | 193017 | 2768 |
2294830 | 2294830 | 2022-03-11 | New Haven | Connecticut | 9009 | 193017 | 2768 |
2291578 | 2291578 | 2022-03-10 | New Haven | Connecticut | 9009 | 192884 | 2765 |
2288326 | 2288326 | 2022-03-09 | New Haven | Connecticut | 9009 | 192804 | 2761 |
2285075 | 2285075 | 2022-03-08 | New Haven | Connecticut | 9009 | 192702 | 2755 |
2281823 | 2281823 | 2022-03-07 | New Haven | Connecticut | 9009 | 192053 | 2747 |
2278570 | 2278570 | 2022-03-06 | New Haven | Connecticut | 9009 | 190557 | 2748 |
2275317 | 2275317 | 2022-03-05 | New Haven | Connecticut | 9009 | 190557 | 2748 |
2272064 | 2272064 | 2022-03-04 | New Haven | Connecticut | 9009 | 190557 | 2748 |
2268812 | 2268812 | 2022-03-03 | New Haven | Connecticut | 9009 | 190408 | 2740 |
2265559 | 2265559 | 2022-03-02 | New Haven | Connecticut | 9009 | 190172 | 2740 |
2262308 | 2262308 | 2022-03-01 | New Haven | Connecticut | 9009 | 190141 | 2730 |
2259057 | 2259057 | 2022-02-28 | New Haven | Connecticut | 9009 | 190110 | 2731 |
2255806 | 2255806 | 2022-02-27 | New Haven | Connecticut | 9009 | 189814 | 2729 |
2252555 | 2252555 | 2022-02-26 | New Haven | Connecticut | 9009 | 189814 | 2729 |
2249304 | 2249304 | 2022-02-25 | New Haven | Connecticut | 9009 | 189814 | 2729 |
2246053 | 2246053 | 2022-02-24 | New Haven | Connecticut | 9009 | 189743 | 2725 |
2242802 | 2242802 | 2022-02-23 | New Haven | Connecticut | 9009 | 189689 | 2724 |
2239551 | 2239551 | 2022-02-22 | New Haven | Connecticut | 9009 | 189592 | 2706 |
2236300 | 2236300 | 2022-02-21 | New Haven | Connecticut | 9009 | 189500 | 2706 |
2233049 | 2233049 | 2022-02-20 | New Haven | Connecticut | 9009 | 189204 | 2699 |
2229798 | 2229798 | 2022-02-19 | New Haven | Connecticut | 9009 | 189204 | 2699 |
2226547 | 2226547 | 2022-02-18 | New Haven | Connecticut | 9009 | 189204 | 2699 |
2223296 | 2223296 | 2022-02-17 | New Haven | Connecticut | 9009 | 188938 | 2687 |
2220045 | 2220045 | 2022-02-16 | New Haven | Connecticut | 9009 | 188832 | 2682 |
2216794 | 2216794 | 2022-02-15 | New Haven | Connecticut | 9009 | 187827 | 2688 |
2213543 | 2213543 | 2022-02-14 | New Haven | Connecticut | 9009 | 187271 | 2664 |
2210291 | 2210291 | 2022-02-13 | New Haven | Connecticut | 9009 | 186894 | 2664 |
2207038 | 2207038 | 2022-02-12 | New Haven | Connecticut | 9009 | 186894 | 2664 |
2203785 | 2203785 | 2022-02-11 | New Haven | Connecticut | 9009 | 186894 | 2664 |
2200532 | 2200532 | 2022-02-10 | New Haven | Connecticut | 9009 | 186504 | 2654 |
2197278 | 2197278 | 2022-02-09 | New Haven | Connecticut | 9009 | 186255 | 2653 |
2194024 | 2194024 | 2022-02-08 | New Haven | Connecticut | 9009 | 186006 | 2639 |
2190770 | 2190770 | 2022-02-07 | New Haven | Connecticut | 9009 | 185705 | 2639 |
2187517 | 2187517 | 2022-02-06 | New Haven | Connecticut | 9009 | 185076 | 2640 |
2184264 | 2184264 | 2022-02-05 | New Haven | Connecticut | 9009 | 185076 | 2640 |
2181012 | 2181012 | 2022-02-04 | New Haven | Connecticut | 9009 | 185076 | 2640 |
2177761 | 2177761 | 2022-02-03 | New Haven | Connecticut | 9009 | 184698 | 2619 |
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);