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: cases, date (date)
deaths 396 ✖
- 1109 22
- 1115 14
- 1111 13
- 0 11
- 2134 11
- 2131 8
- 2213 8
- 1104 7
- 1119 7
- 2128 7
- 2133 7
- 2140 7
- 1128 6
- 2146 6
- 2154 6
- 2157 6
- 2173 6
- 2266 6
- 2325 6
- 2811 6
- 1079 5
- 1110 5
- 2121 5
- 2144 5
- 2167 5
- 2250 5
- 2310 5
- 2342 5
- 2814 5
- 6 4
- 1101 4
- 1486 4
- 1933 4
- 1992 4
- 2119 4
- 2127 4
- 2130 4
- 2183 4
- 2227 4
- 2229 4
- 2241 4
- 2280 4
- 2297 4
- 2403 4
- 2664 4
- 2796 4
- 2808 4
- 2818 4
- 2823 4
- 2830 4
- 1077 3
- 1090 3
- 1092 3
- 1095 3
- 1118 3
- 1123 3
- 1137 3
- 1157 3
- 1190 3
- 1238 3
- 1291 3
- 1360 3
- 1425 3
- 1627 3
- 1694 3
- 1738 3
- 1786 3
- 1820 3
- 1859 3
- 1891 3
- 1919 3
- 1954 3
- 1980 3
- 2002 3
- 2015 3
- 2032 3
- 2052 3
- 2069 3
- 2084 3
- 2096 3
- 2111 3
- 2135 3
- 2145 3
- 2181 3
- 2194 3
- 2209 3
- 2214 3
- 2224 3
- 2231 3
- 2233 3
- 2236 3
- 2262 3
- 2288 3
- 2371 3
- 2470 3
- 2534 3
- 2590 3
- 2640 3
- 2699 3
- 2729 3
- 2748 3
- 2768 3
- 2780 3
- 2812 3
- 2820 3
- 2831 3
- 2 2
- 565 2
- 1052 2
- 1069 2
- 1073 2
- 1075 2
- 1078 2
- 1087 2
- 1088 2
- 1106 2
- 1120 2
- 1126 2
- 1222 2
- 1529 2
- 1559 2
- 2092 2
- 2124 2
- 2129 2
- 2132 2
- 2190 2
- 2222 2
- 2256 2
- 2258 2
- 2264 2
- 2274 2
- 2434 2
- 2639 2
- 2706 2
- 2740 2
- 2773 2
- 2789 2
- 2805 2
- 2817 2
- 2825 2
- 12 1
- 15 1
- 17 1
- 18 1
- 29 1
- 36 1
- 41 1
- 60 1
- 70 1
- 78 1
- 98 1
- 107 1
- 119 1
- 135 1
- 151 1
- 195 1
- 214 1
- 229 1
- 241 1
- 257 1
- 301 1
- 322 1
- 345 1
- 372 1
- 396 1
- 416 1
- 429 1
- 456 1
- 478 1
- 493 1
- 512 1
- 533 1
- 595 1
- 610 1
- 629 1
- 643 1
- 669 1
- 686 1
- 701 1
- 716 1
- 723 1
- 745 1
- 767 1
- 783 1
- 800 1
- 817 1
- 830 1
- 838 1
- 855 1
- 874 1
- 888 1
- 897 1
- 903 1
- 922 1
- 925 1
- 934 1
- 946 1
- 957 1
- 966 1
- 972 1
- 973 1
- 985 1
- 990 1
- 992 1
- 999 1
- 1007 1
- 1010 1
- 1013 1
- 1016 1
- 1024 1
- 1031 1
- 1034 1
- 1041 1
- 1044 1
- 1045 1
- 1046 1
- 1056 1
- 1060 1
- 1061 1
- 1063 1
- 1065 1
- 1066 1
- 1068 1
- 1074 1
- 1093 1
- 1097 1
- 1099 1
- 1100 1
- 1112 1
- 1113 1
- 1114 1
- 1117 1
- 1121 1
- 1122 1
- 1130 1
- 1132 1
- 1135 1
- 1144 1
- 1148 1
- 1151 1
- 1155 1
- 1167 1
- 1168 1
- 1172 1
- 1180 1
- 1202 1
- 1207 1
- 1256 1
- 1259 1
- 1275 1
- 1283 1
- 1313 1
- 1318 1
- 1336 1
- 1351 1
- 1387 1
- 1394 1
- 1409 1
- 1421 1
- 1449 1
- 1455 1
- 1460 1
- 1509 1
- 1517 1
- 1525 1
- 1578 1
- 1584 1
- 1595 1
- 1615 1
- 1648 1
- 1653 1
- 1680 1
- 1685 1
- 1701 1
- 1706 1
- 1713 1
- 1729 1
- 1763 1
- 1766 1
- 1774 1
- 1782 1
- 1803 1
- 1805 1
- 1810 1
- 1815 1
- 1835 1
- 1839 1
- 1848 1
- 1852 1
- 1873 1
- 1874 1
- 1880 1
- 1885 1
- 1905 1
- 1908 1
- 1914 1
- 1917 1
- 1925 1
- 1926 1
- 1930 1
- 1937 1
- 1943 1
- 1946 1
- 1951 1
- 1966 1
- 1969 1
- 1970 1
- 1976 1
- 1983 1
- 1986 1
- 1988 1
- 1996 1
- 1999 1
- 2000 1
- 2001 1
- 2006 1
- 2008 1
- 2011 1
- 2012 1
- 2019 1
- 2024 1
- 2028 1
- 2030 1
- 2039 1
- 2040 1
- 2044 1
- 2049 1
- 2059 1
- 2061 1
- 2065 1
- 2066 1
- 2073 1
- 2077 1
- 2078 1
- 2083 1
- 2093 1
- 2094 1
- 2104 1
- 2106 1
- 2107 1
- 2109 1
- 2112 1
- 2113 1
- 2116 1
- 2117 1
- 2122 1
- 2125 1
- 2126 1
- 2151 1
- 2156 1
- 2168 1
- 2189 1
- 2202 1
- 2212 1
- 2234 1
- 2249 1
- 2272 1
- 2308 1
- 2318 1
- 2327 1
- 2341 1
- 2349 1
- 2429 1
- 2469 1
- 2472 1
- 2506 1
- 2509 1
- 2537 1
- 2538 1
- 2567 1
- 2571 1
- 2595 1
- 2615 1
- 2618 1
- 2619 1
- 2653 1
- 2654 1
- 2682 1
- 2687 1
- 2688 1
- 2724 1
- 2725 1
- 2730 1
- 2731 1
- 2747 1
- 2755 1
- 2761 1
- 2765 1
- 2769 1
- 2772 1
- 2783 1
- 2788 1
- 2806 1
- 2809 1
- 2824 1
- 2839 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);