ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 498 ✖
- 4 54
- 20 23
- 25 22
- 13 12
- 1 8
- 17 8
- 2 7
- 3 7
- 19 7
- 24 7
- 3222 7
- 1226 6
- 15 5
- 21 5
- 30 5
- 37 5
- 976 5
- 1218 5
- 1231 5
- 11 4
- 18 4
- 22 4
- 29 4
- 1221 4
- 1223 4
- 3177 4
- 3218 4
- 26 3
- 43 3
- 937 3
- 962 3
- 972 3
- 1015 3
- 1175 3
- 1182 3
- 1203 3
- 1206 3
- 1212 3
- 1232 3
- 1234 3
- 3144 3
- 3169 3
- 3171 3
- 3256 3
- 12 2
- 14 2
- 16 2
- 28 2
- 34 2
- 40 2
- 48 2
- 60 2
- 66 2
- 632 2
- 769 2
- 891 2
- 912 2
- 953 2
- 957 2
- 967 2
- 984 2
- 986 2
- 1009 2
- 1055 2
- 1109 2
- 1140 2
- 1167 2
- 1169 2
- 1181 2
- 1191 2
- 1222 2
- 1235 2
- 1236 2
- 1239 2
- 1257 2
- 1258 2
- 1271 2
- 1280 2
- 1907 2
- 3092 2
- 3131 2
- 3153 2
- 3156 2
- 3187 2
- 3190 2
- 3203 2
- 3204 2
- 3209 2
- 3210 2
- 6 1
- 8 1
- 27 1
- 31 1
- 35 1
- 36 1
- 38 1
- 41 1
- 42 1
- 49 1
- 50 1
- 54 1
- 55 1
- 58 1
- 64 1
- 69 1
- 70 1
- 73 1
- 76 1
- 77 1
- 82 1
- 84 1
- 87 1
- 94 1
- 97 1
- 103 1
- 105 1
- 110 1
- 118 1
- 123 1
- 125 1
- 134 1
- 147 1
- 152 1
- 159 1
- 177 1
- 192 1
- 199 1
- 208 1
- 215 1
- 219 1
- 229 1
- 278 1
- 307 1
- 321 1
- 326 1
- 338 1
- 346 1
- 360 1
- 372 1
- 383 1
- 389 1
- 399 1
- 421 1
- 429 1
- 436 1
- 448 1
- 461 1
- 468 1
- 479 1
- 492 1
- 497 1
- 499 1
- 505 1
- 514 1
- 517 1
- 540 1
- 558 1
- 559 1
- 565 1
- 573 1
- 583 1
- 595 1
- 630 1
- 637 1
- 659 1
- 665 1
- 680 1
- 697 1
- 705 1
- 708 1
- 716 1
- 729 1
- 740 1
- 749 1
- 756 1
- 774 1
- 782 1
- 787 1
- 791 1
- 797 1
- 799 1
- 805 1
- 806 1
- 807 1
- 809 1
- 811 1
- 822 1
- 828 1
- 830 1
- 835 1
- 836 1
- 843 1
- 847 1
- 856 1
- 859 1
- 863 1
- 868 1
- 875 1
- 880 1
- 882 1
- 883 1
- 885 1
- 888 1
- 889 1
- 894 1
- 899 1
- 900 1
- 904 1
- 923 1
- 929 1
- 941 1
- 944 1
- 952 1
- 954 1
- 955 1
- 960 1
- 961 1
- 964 1
- 966 1
- 971 1
- 975 1
- 980 1
- 981 1
- 985 1
- 994 1
- 995 1
- 1003 1
- 1005 1
- 1012 1
- 1016 1
- 1021 1
- 1023 1
- 1024 1
- 1026 1
- 1035 1
- 1042 1
- 1049 1
- 1053 1
- 1059 1
- 1064 1
- 1068 1
- 1075 1
- 1078 1
- 1079 1
- 1080 1
- 1086 1
- 1098 1
- 1099 1
- 1105 1
- 1110 1
- 1117 1
- 1122 1
- 1130 1
- 1134 1
- 1138 1
- 1150 1
- 1157 1
- 1159 1
- 1172 1
- 1185 1
- 1187 1
- 1190 1
- 1194 1
- 1197 1
- 1198 1
- 1201 1
- 1207 1
- 1215 1
- 1219 1
- 1229 1
- 1233 1
- 1240 1
- 1243 1
- 1252 1
- 1253 1
- 1261 1
- 1263 1
- 1264 1
- 1268 1
- 1272 1
- 1274 1
- 1276 1
- 1279 1
- 1281 1
- 1290 1
- 1293 1
- 1296 1
- 1298 1
- 1302 1
- 1307 1
- 1308 1
- 1310 1
- 1314 1
- 1315 1
- 1320 1
- 1326 1
- 1328 1
- 1329 1
- 1331 1
- 1335 1
- 1339 1
- 1342 1
- 1348 1
- 1353 1
- 1356 1
- 1361 1
- 1370 1
- 1390 1
- 1406 1
- 1417 1
- 1437 1
- 1439 1
- 1441 1
- 1449 1
- 1467 1
- 1472 1
- 1479 1
- 1483 1
- 1497 1
- 1526 1
- 1538 1
- 1549 1
- 1557 1
- 1574 1
- 1598 1
- 1603 1
- 1633 1
- 1641 1
- 1653 1
- 1668 1
- 1681 1
- 1711 1
- 1729 1
- 1749 1
- 1756 1
- 1773 1
- 1797 1
- 1808 1
- 1810 1
- 1813 1
- 1815 1
- 1825 1
- 1831 1
- 1840 1
- 1849 1
- 1850 1
- 1851 1
- 1859 1
- 1866 1
- 1877 1
- 1893 1
- 1904 1
- 1925 1
- 1940 1
- 1963 1
- 1981 1
- 1994 1
- 1997 1
- 2001 1
- 2010 1
- 2017 1
- 2035 1
- 2047 1
- 2090 1
- 2096 1
- 2098 1
- 2118 1
- 2135 1
- 2144 1
- 2173 1
- 2177 1
- 2194 1
- 2197 1
- 2204 1
- 2220 1
- 2226 1
- 2245 1
- 2265 1
- 2270 1
- 2277 1
- 2307 1
- 2324 1
- 2340 1
- 2351 1
- 2371 1
- 2383 1
- 2386 1
- 2398 1
- 2414 1
- 2420 1
- 2437 1
- 2470 1
- 2478 1
- 2486 1
- 2491 1
- 2503 1
- 2512 1
- 2515 1
- 2523 1
- 2530 1
- 2532 1
- 2538 1
- 2543 1
- 2544 1
- 2549 1
- 2550 1
- 2555 1
- 2558 1
- 2560 1
- 2566 1
- 2574 1
- 2580 1
- 2581 1
- 2591 1
- 2597 1
- 2607 1
- 2611 1
- 2617 1
- 2629 1
- 2639 1
- 2652 1
- 2653 1
- 2673 1
- 2689 1
- 2702 1
- 2724 1
- 2741 1
- 2760 1
- 2764 1
- 2766 1
- 2775 1
- 2796 1
- 2821 1
- 2840 1
- 2846 1
- 2861 1
- 2868 1
- 2884 1
- 2922 1
- 2933 1
- 2948 1
- 2956 1
- 2967 1
- 2982 1
- 2987 1
- 2995 1
- 3003 1
- 3012 1
- 3016 1
- 3020 1
- 3025 1
- 3033 1
- 3039 1
- 3048 1
- 3066 1
- 3070 1
- 3071 1
- 3077 1
- 3079 1
- 3081 1
- 3085 1
- 3091 1
- 3095 1
- 3097 1
- 3103 1
- 3107 1
- 3110 1
- 3111 1
- 3113 1
- 3119 1
- 3123 1
- 3127 1
- 3129 1
- 3132 1
- 3137 1
- 3140 1
- 3142 1
- 3146 1
- 3150 1
- 3154 1
- 3157 1
- 3158 1
- 3161 1
- 3165 1
- 3167 1
- 3175 1
- 3182 1
- 3189 1
- 3194 1
- 3197 1
- 3199 1
- 3200 1
- 3206 1
- 3211 1
- 3212 1
- 3213 1
- 3217 1
- 3219 1
state 1
- Pennsylvania 785
fips 1
- 42105 · 785 ✖
county 1
- Potter 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501899 | 2501899 | 2022-05-13 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2498641 | 2498641 | 2022-05-12 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2495383 | 2495383 | 2022-05-11 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2492125 | 2492125 | 2022-05-10 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2488867 | 2488867 | 2022-05-09 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2485610 | 2485610 | 2022-05-08 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2482352 | 2482352 | 2022-05-07 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2479094 | 2479094 | 2022-05-06 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2475836 | 2475836 | 2022-05-05 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2472579 | 2472579 | 2022-05-04 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2469323 | 2469323 | 2022-05-03 | Potter | Pennsylvania | 42105 | 3219 | 92 |
2466067 | 2466067 | 2022-05-02 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2462812 | 2462812 | 2022-05-01 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2459556 | 2459556 | 2022-04-30 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2456300 | 2456300 | 2022-04-29 | Potter | Pennsylvania | 42105 | 3218 | 92 |
2453044 | 2453044 | 2022-04-28 | Potter | Pennsylvania | 42105 | 3217 | 92 |
2449788 | 2449788 | 2022-04-27 | Potter | Pennsylvania | 42105 | 3213 | 92 |
2446531 | 2446531 | 2022-04-26 | Potter | Pennsylvania | 42105 | 3212 | 92 |
2443276 | 2443276 | 2022-04-25 | Potter | Pennsylvania | 42105 | 3211 | 92 |
2440020 | 2440020 | 2022-04-24 | Potter | Pennsylvania | 42105 | 3210 | 92 |
2436764 | 2436764 | 2022-04-23 | Potter | Pennsylvania | 42105 | 3210 | 92 |
2433508 | 2433508 | 2022-04-22 | Potter | Pennsylvania | 42105 | 3209 | 92 |
2430252 | 2430252 | 2022-04-21 | Potter | Pennsylvania | 42105 | 3209 | 92 |
2426996 | 2426996 | 2022-04-20 | Potter | Pennsylvania | 42105 | 3206 | 92 |
2423740 | 2423740 | 2022-04-19 | Potter | Pennsylvania | 42105 | 3204 | 92 |
2420484 | 2420484 | 2022-04-18 | Potter | Pennsylvania | 42105 | 3204 | 92 |
2417228 | 2417228 | 2022-04-17 | Potter | Pennsylvania | 42105 | 3203 | 92 |
2413972 | 2413972 | 2022-04-16 | Potter | Pennsylvania | 42105 | 3203 | 92 |
2410716 | 2410716 | 2022-04-15 | Potter | Pennsylvania | 42105 | 3200 | 92 |
2407460 | 2407460 | 2022-04-14 | Potter | Pennsylvania | 42105 | 3199 | 92 |
2404204 | 2404204 | 2022-04-13 | Potter | Pennsylvania | 42105 | 3197 | 92 |
2400949 | 2400949 | 2022-04-12 | Potter | Pennsylvania | 42105 | 3194 | 92 |
2397694 | 2397694 | 2022-04-11 | Potter | Pennsylvania | 42105 | 3190 | 92 |
2394439 | 2394439 | 2022-04-10 | Potter | Pennsylvania | 42105 | 3190 | 92 |
2391183 | 2391183 | 2022-04-09 | Potter | Pennsylvania | 42105 | 3189 | 92 |
2387927 | 2387927 | 2022-04-08 | Potter | Pennsylvania | 42105 | 3187 | 91 |
2384672 | 2384672 | 2022-04-07 | Potter | Pennsylvania | 42105 | 3187 | 91 |
2381417 | 2381417 | 2022-04-06 | Potter | Pennsylvania | 42105 | 3182 | 91 |
2378162 | 2378162 | 2022-04-05 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2374908 | 2374908 | 2022-04-04 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2371656 | 2371656 | 2022-04-03 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2368403 | 2368403 | 2022-04-02 | Potter | Pennsylvania | 42105 | 3177 | 91 |
2365150 | 2365150 | 2022-04-01 | Potter | Pennsylvania | 42105 | 3175 | 91 |
2361897 | 2361897 | 2022-03-31 | Potter | Pennsylvania | 42105 | 3171 | 91 |
2358643 | 2358643 | 2022-03-30 | Potter | Pennsylvania | 42105 | 3171 | 91 |
2355389 | 2355389 | 2022-03-29 | Potter | Pennsylvania | 42105 | 3171 | 91 |
2352136 | 2352136 | 2022-03-28 | Potter | Pennsylvania | 42105 | 3169 | 91 |
2348884 | 2348884 | 2022-03-27 | Potter | Pennsylvania | 42105 | 3169 | 91 |
2345631 | 2345631 | 2022-03-26 | Potter | Pennsylvania | 42105 | 3169 | 91 |
2342378 | 2342378 | 2022-03-25 | Potter | Pennsylvania | 42105 | 3167 | 91 |
2339125 | 2339125 | 2022-03-24 | Potter | Pennsylvania | 42105 | 3165 | 91 |
2335871 | 2335871 | 2022-03-23 | Potter | Pennsylvania | 42105 | 3161 | 91 |
2332617 | 2332617 | 2022-03-22 | Potter | Pennsylvania | 42105 | 3158 | 91 |
2329364 | 2329364 | 2022-03-21 | Potter | Pennsylvania | 42105 | 3157 | 91 |
2326112 | 2326112 | 2022-03-20 | Potter | Pennsylvania | 42105 | 3156 | 91 |
2322859 | 2322859 | 2022-03-19 | Potter | Pennsylvania | 42105 | 3156 | 91 |
2319605 | 2319605 | 2022-03-18 | Potter | Pennsylvania | 42105 | 3154 | 91 |
2316351 | 2316351 | 2022-03-17 | Potter | Pennsylvania | 42105 | 3153 | 91 |
2313098 | 2313098 | 2022-03-16 | Potter | Pennsylvania | 42105 | 3153 | 91 |
2309845 | 2309845 | 2022-03-15 | Potter | Pennsylvania | 42105 | 3150 | 91 |
2306592 | 2306592 | 2022-03-14 | Potter | Pennsylvania | 42105 | 3146 | 91 |
2303341 | 2303341 | 2022-03-13 | Potter | Pennsylvania | 42105 | 3144 | 91 |
2300089 | 2300089 | 2022-03-12 | Potter | Pennsylvania | 42105 | 3144 | 91 |
2296837 | 2296837 | 2022-03-11 | Potter | Pennsylvania | 42105 | 3144 | 91 |
2293585 | 2293585 | 2022-03-10 | Potter | Pennsylvania | 42105 | 3142 | 91 |
2290333 | 2290333 | 2022-03-09 | Potter | Pennsylvania | 42105 | 3140 | 91 |
2287081 | 2287081 | 2022-03-08 | Potter | Pennsylvania | 42105 | 3137 | 91 |
2283829 | 2283829 | 2022-03-07 | Potter | Pennsylvania | 42105 | 3132 | 91 |
2280577 | 2280577 | 2022-03-06 | Potter | Pennsylvania | 42105 | 3131 | 91 |
2277324 | 2277324 | 2022-03-05 | Potter | Pennsylvania | 42105 | 3131 | 91 |
2274071 | 2274071 | 2022-03-04 | Potter | Pennsylvania | 42105 | 3129 | 91 |
2270818 | 2270818 | 2022-03-03 | Potter | Pennsylvania | 42105 | 3127 | 91 |
2267566 | 2267566 | 2022-03-02 | Potter | Pennsylvania | 42105 | 3123 | 91 |
2264313 | 2264313 | 2022-03-01 | Potter | Pennsylvania | 42105 | 3119 | 91 |
2261063 | 2261063 | 2022-02-28 | Potter | Pennsylvania | 42105 | 3113 | 90 |
2257812 | 2257812 | 2022-02-27 | Potter | Pennsylvania | 42105 | 3111 | 90 |
2254561 | 2254561 | 2022-02-26 | Potter | Pennsylvania | 42105 | 3110 | 90 |
2251310 | 2251310 | 2022-02-25 | Potter | Pennsylvania | 42105 | 3107 | 90 |
2248059 | 2248059 | 2022-02-24 | Potter | Pennsylvania | 42105 | 3103 | 90 |
2244808 | 2244808 | 2022-02-23 | Potter | Pennsylvania | 42105 | 3097 | 90 |
2241557 | 2241557 | 2022-02-22 | Potter | Pennsylvania | 42105 | 3095 | 90 |
2238306 | 2238306 | 2022-02-21 | Potter | Pennsylvania | 42105 | 3092 | 90 |
2235055 | 2235055 | 2022-02-20 | Potter | Pennsylvania | 42105 | 3092 | 90 |
2231804 | 2231804 | 2022-02-19 | Potter | Pennsylvania | 42105 | 3091 | 90 |
2228553 | 2228553 | 2022-02-18 | Potter | Pennsylvania | 42105 | 3085 | 90 |
2225302 | 2225302 | 2022-02-17 | Potter | Pennsylvania | 42105 | 3081 | 90 |
2222051 | 2222051 | 2022-02-16 | Potter | Pennsylvania | 42105 | 3079 | 90 |
2218800 | 2218800 | 2022-02-15 | Potter | Pennsylvania | 42105 | 3077 | 89 |
2215549 | 2215549 | 2022-02-14 | Potter | Pennsylvania | 42105 | 3071 | 89 |
2212298 | 2212298 | 2022-02-13 | Potter | Pennsylvania | 42105 | 3070 | 89 |
2209045 | 2209045 | 2022-02-12 | Potter | Pennsylvania | 42105 | 3066 | 89 |
2205792 | 2205792 | 2022-02-11 | Potter | Pennsylvania | 42105 | 3048 | 89 |
2202539 | 2202539 | 2022-02-10 | Potter | Pennsylvania | 42105 | 3039 | 89 |
2199285 | 2199285 | 2022-02-09 | Potter | Pennsylvania | 42105 | 3033 | 88 |
2196031 | 2196031 | 2022-02-08 | Potter | Pennsylvania | 42105 | 3025 | 88 |
2192777 | 2192777 | 2022-02-07 | Potter | Pennsylvania | 42105 | 3020 | 87 |
2189523 | 2189523 | 2022-02-06 | Potter | Pennsylvania | 42105 | 3016 | 87 |
2186270 | 2186270 | 2022-02-05 | Potter | Pennsylvania | 42105 | 3012 | 87 |
2183018 | 2183018 | 2022-02-04 | Potter | Pennsylvania | 42105 | 3003 | 87 |
2179766 | 2179766 | 2022-02-03 | Potter | Pennsylvania | 42105 | 2995 | 86 |
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);