ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,428 rows where county = "Powell" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
cases 674 ✖
- 1 69
- 10 33
- 2 27
- 1865 20
- 1871 14
- 929 13
- 5 11
- 1864 11
- 12 10
- 941 10
- 935 9
- 889 8
- 909 8
- 915 8
- 944 8
- 948 8
- 1868 8
- 8 7
- 70 7
- 920 7
- 1346 7
- 1362 7
- 4699 7
- 4718 7
- 4743 7
- 4749 7
- 4752 7
- 4757 7
- 4764 7
- 4767 7
- 4775 7
- 15 6
- 85 6
- 892 6
- 924 6
- 936 6
- 1361 6
- 1438 6
- 1460 6
- 6 5
- 788 5
- 888 5
- 890 5
- 893 5
- 928 5
- 931 5
- 1021 5
- 1227 5
- 1347 5
- 1354 5
- 1364 5
- 1409 5
- 1854 5
- 1863 5
- 1867 5
- 2765 5
- 3061 5
- 3131 5
- 4782 5
- 76 4
- 89 4
- 133 4
- 318 4
- 774 4
- 885 4
- 902 4
- 922 4
- 943 4
- 946 4
- 980 4
- 1074 4
- 1186 4
- 1329 4
- 1457 4
- 1458 4
- 1464 4
- 1473 4
- 1493 4
- 1534 4
- 1807 4
- 1844 4
- 3457 4
- 3 3
- 4 3
- 53 3
- 68 3
- 80 3
- 90 3
- 91 3
- 220 3
- 587 3
- 661 3
- 686 3
- 724 3
- 748 3
- 764 3
- 781 3
- 786 3
- 794 3
- 846 3
- 879 3
- 894 3
- 911 3
- 912 3
- 916 3
- 918 3
- 930 3
- 940 3
- 942 3
- 959 3
- 987 3
- 1042 3
- 1101 3
- 1140 3
- 1166 3
- 1249 3
- 1310 3
- 1321 3
- 1330 3
- 1333 3
- 1344 3
- 1365 3
- 1375 3
- 1392 3
- 1416 3
- 1429 3
- 1448 3
- 1532 3
- 1625 3
- 1653 3
- 1720 3
- 1771 3
- 1834 3
- 1860 3
- 1949 3
- 2137 3
- 2241 3
- 2318 3
- 2372 3
- 2442 3
- 2499 3
- 2547 3
- 2594 3
- 2668 3
- 2717 3
- 2888 3
- 2967 3
- 3017 3
- 3268 3
- 3748 3
- 4045 3
- 4293 3
- 4441 3
- 4592 3
- 4665 3
- 4693 3
- 7 2
- 9 2
- 17 2
- 21 2
- 27 2
- 30 2
- 33 2
- 37 2
- 38 2
- 50 2
- 72 2
- 75 2
- 84 2
- 93 2
- 96 2
- 100 2
- 102 2
- 110 2
- 112 2
- 123 2
- 143 2
- 183 2
- 316 2
- 390 2
- 393 2
- 465 2
- 725 2
- 771 2
- 782 2
- 797 2
- 818 2
- 834 2
- 836 2
- 851 2
- 859 2
- 862 2
- 867 2
- 870 2
- 874 2
- 876 2
- 883 2
- 884 2
- 895 2
- 910 2
- 913 2
- 921 2
- 923 2
- 925 2
- 961 2
- 974 2
- 992 2
- 1010 2
- 1033 2
- 1035 2
- 1104 2
- 1148 2
- 1189 2
- 1243 2
- 1303 2
- 1304 2
- 1306 2
- 1340 2
- 1342 2
- 1360 2
- 1390 2
- 1420 2
- 1426 2
- 1456 2
- 1459 2
- 1492 2
- 1746 2
- 1838 2
- 2521 2
- 2641 2
- 4650 2
- 13 1
- 19 1
- 20 1
- 23 1
- 28 1
- 29 1
- 31 1
- 32 1
- 34 1
- 36 1
- 40 1
- 41 1
- 42 1
- 43 1
- 44 1
- 48 1
- 49 1
- 51 1
- 59 1
- 60 1
- 62 1
- 67 1
- 69 1
- 71 1
- 81 1
- 86 1
- 87 1
- 88 1
- 92 1
- 94 1
- 97 1
- 98 1
- 109 1
- 115 1
- 117 1
- 119 1
- 120 1
- 121 1
- 127 1
- 128 1
- 129 1
- 131 1
- 132 1
- 136 1
- 137 1
- 138 1
- 139 1
- 142 1
- 146 1
- 147 1
- 149 1
- 159 1
- 163 1
- 164 1
- 165 1
- 168 1
- 169 1
- 182 1
- 193 1
- 197 1
- 198 1
- 208 1
- 210 1
- 214 1
- 229 1
- 230 1
- 241 1
- 255 1
- 268 1
- 291 1
- 307 1
- 313 1
- 324 1
- 335 1
- 346 1
- 373 1
- 391 1
- 392 1
- 394 1
- 415 1
- 425 1
- 430 1
- 436 1
- 445 1
- 452 1
- 462 1
- 479 1
- 486 1
- 493 1
- 499 1
- 503 1
- 507 1
- 520 1
- 528 1
- 531 1
- 534 1
- 553 1
- 556 1
- 565 1
- 576 1
- 592 1
- 596 1
- 603 1
- 609 1
- 613 1
- 620 1
- 625 1
- 637 1
- 640 1
- 650 1
- 652 1
- 654 1
- 672 1
- 673 1
- 674 1
- 681 1
- 688 1
- 689 1
- 705 1
- 706 1
- 709 1
- 711 1
- 715 1
- 719 1
- 720 1
- 721 1
- 722 1
- 727 1
- 731 1
- 732 1
- 756 1
- 761 1
- 762 1
- 769 1
- 785 1
- 792 1
- 795 1
- 801 1
- 809 1
- 811 1
- 814 1
- 821 1
- 825 1
- 826 1
- 829 1
- 832 1
- 833 1
- 835 1
- 838 1
- 849 1
- 850 1
- 852 1
- 858 1
- 860 1
- 861 1
- 869 1
- 872 1
- 873 1
- 880 1
- 881 1
- 891 1
- 896 1
- 898 1
- 900 1
- 901 1
- 903 1
- 919 1
- 927 1
- 934 1
- 937 1
- 947 1
- 950 1
- 952 1
- 957 1
- 960 1
- 963 1
- 964 1
- 966 1
- 967 1
- 968 1
- 969 1
- 971 1
- 975 1
- 978 1
- 979 1
- 981 1
- 984 1
- 997 1
- 998 1
- 1000 1
- 1009 1
- 1013 1
- 1015 1
- 1017 1
- 1019 1
- 1030 1
- 1036 1
- 1037 1
- 1038 1
- 1043 1
- 1048 1
- 1050 1
- 1054 1
- 1056 1
- 1057 1
- 1061 1
- 1063 1
- 1065 1
- 1066 1
- 1070 1
- 1072 1
- 1079 1
- 1081 1
- 1086 1
- 1093 1
- 1097 1
- 1102 1
- 1103 1
- 1105 1
- 1106 1
- 1111 1
- 1112 1
- 1121 1
- 1122 1
- 1124 1
- 1125 1
- 1129 1
- 1132 1
- 1135 1
- 1137 1
- 1141 1
- 1143 1
- 1144 1
- 1150 1
- 1155 1
- 1157 1
- 1158 1
- 1160 1
- 1167 1
- 1170 1
- 1171 1
- 1175 1
- 1177 1
- 1178 1
- 1181 1
- 1187 1
- 1197 1
- 1202 1
- 1204 1
- 1210 1
- 1213 1
- 1219 1
- 1220 1
- 1233 1
- 1236 1
- 1239 1
- 1242 1
- 1255 1
- 1265 1
- 1271 1
- 1272 1
- 1281 1
- 1283 1
- 1288 1
- 1290 1
- 1293 1
- 1296 1
- 1299 1
- 1301 1
- 1311 1
- 1313 1
- 1316 1
- 1319 1
- 1320 1
- 1324 1
- 1325 1
- 1327 1
- 1334 1
- 1335 1
- 1341 1
- 1343 1
- 1348 1
- 1349 1
- 1357 1
- 1358 1
- 1367 1
- 1372 1
- 1373 1
- 1374 1
- 1377 1
- 1380 1
- 1383 1
- 1386 1
- 1395 1
- 1399 1
- 1401 1
- 1404 1
- 1417 1
- 1425 1
- 1431 1
- 1434 1
- 1435 1
- 1439 1
- 1441 1
- 1444 1
- 1446 1
- 1451 1
- 1462 1
- 1465 1
- 1467 1
- 1469 1
- 1476 1
- 1477 1
- 1478 1
- 1482 1
- 1485 1
- 1501 1
- 1511 1
- 1515 1
- 1521 1
- 1551 1
- 1554 1
- 1574 1
- 1579 1
- 1598 1
- 1603 1
- 1624 1
- 1643 1
- 1669 1
- 1676 1
- 1692 1
- 1716 1
- 1737 1
- 1741 1
- 1756 1
- 1764 1
- 1787 1
- 1788 1
- 1792 1
- 1814 1
- 1830 1
- 1837 1
- 1846 1
- 1849 1
- 1853 1
- 1855 1
- 1857 1
- 1858 1
- 1861 1
- 1866 1
- 1869 1
- 1870 1
- 1872 1
- 1877 1
- 1893 1
- 1928 1
- 2021 1
- 2038 1
- 2070 1
- 2107 1
- 2175 1
- 2200 1
- 2211 1
- 2220 1
- 2266 1
- 2278 1
- 2292 1
- 2307 1
- 2327 1
- 2341 1
- 2345 1
- 2368 1
- 2385 1
- 2399 1
- 2416 1
- 2434 1
- 2463 1
- 2469 1
- 2483 1
- 2490 1
- 2513 1
- 2536 1
- 2557 1
- 2567 1
- 2571 1
- 2580 1
- 2601 1
- 2632 1
- 2675 1
- 2684 1
- 2692 1
- 2705 1
- 2733 1
- 2751 1
- 2798 1
- 2815 1
- 2848 1
- 2866 1
- 2908 1
- 2932 1
- 2938 1
- 2958 1
- 2977 1
- 2994 1
- 3000 1
- 3007 1
- 3031 1
- 3046 1
- 3093 1
- 3103 1
- 3170 1
- 3204 1
- 3221 1
- 3257 1
- 3295 1
- 3344 1
- 3369 1
- 3403 1
- 3553 1
- 3596 1
- 3686 1
- 3822 1
- 3876 1
- 3930 1
- 3978 1
- 4133 1
- 4164 1
- 4199 1
- 4255 1
- 4325 1
- 4382 1
- 4402 1
- 4429 1
- 4511 1
- 4531 1
- 4549 1
- 4559 1
- 4625 1
- 4638 1
- 4670 1
- 4678 1
- 4682 1
- 4687 1
county 1
- Powell · 1,428 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22494 | 22494 | 2020-03-31 | Powell | Kentucky | 21197 | 1 | 0 |
24670 | 24670 | 2020-04-01 | Powell | Kentucky | 21197 | 1 | 0 |
26920 | 26920 | 2020-04-02 | Powell | Kentucky | 21197 | 1 | 0 |
29236 | 29236 | 2020-04-03 | Powell | Kentucky | 21197 | 1 | 0 |
31614 | 31614 | 2020-04-04 | Powell | Kentucky | 21197 | 1 | 0 |
34039 | 34039 | 2020-04-05 | Powell | Kentucky | 21197 | 1 | 0 |
36497 | 36497 | 2020-04-06 | Powell | Kentucky | 21197 | 1 | 0 |
39004 | 39004 | 2020-04-07 | Powell | Kentucky | 21197 | 1 | 0 |
41554 | 41554 | 2020-04-08 | Powell | Kentucky | 21197 | 1 | 0 |
44130 | 44130 | 2020-04-09 | Powell | Kentucky | 21197 | 1 | 0 |
46738 | 46738 | 2020-04-10 | Powell | Kentucky | 21197 | 2 | 0 |
49378 | 49378 | 2020-04-11 | Powell | Kentucky | 21197 | 2 | 0 |
52046 | 52046 | 2020-04-12 | Powell | Kentucky | 21197 | 1 | 0 |
54727 | 54727 | 2020-04-13 | Powell | Kentucky | 21197 | 1 | 0 |
57425 | 57425 | 2020-04-14 | Powell | Kentucky | 21197 | 1 | 0 |
60134 | 60134 | 2020-04-15 | Powell | Kentucky | 21197 | 1 | 0 |
62854 | 62854 | 2020-04-16 | Powell | Kentucky | 21197 | 1 | 0 |
65593 | 65593 | 2020-04-17 | Powell | Kentucky | 21197 | 1 | 0 |
68342 | 68342 | 2020-04-18 | Powell | Kentucky | 21197 | 1 | 0 |
71105 | 71105 | 2020-04-19 | Powell | Kentucky | 21197 | 1 | 0 |
73877 | 73877 | 2020-04-20 | Powell | Kentucky | 21197 | 1 | 0 |
76658 | 76658 | 2020-04-21 | Powell | Kentucky | 21197 | 1 | 0 |
79443 | 79443 | 2020-04-22 | Powell | Kentucky | 21197 | 1 | 0 |
82240 | 82240 | 2020-04-23 | Powell | Kentucky | 21197 | 1 | 0 |
85043 | 85043 | 2020-04-24 | Powell | Kentucky | 21197 | 1 | 0 |
87852 | 87852 | 2020-04-25 | Powell | Kentucky | 21197 | 1 | 0 |
90668 | 90668 | 2020-04-26 | Powell | Kentucky | 21197 | 1 | 0 |
93489 | 93489 | 2020-04-27 | Powell | Kentucky | 21197 | 1 | 0 |
96324 | 96324 | 2020-04-28 | Powell | Kentucky | 21197 | 1 | 0 |
99170 | 99170 | 2020-04-29 | Powell | Kentucky | 21197 | 1 | 0 |
102022 | 102022 | 2020-04-30 | Powell | Kentucky | 21197 | 1 | 0 |
104883 | 104883 | 2020-05-01 | Powell | Kentucky | 21197 | 1 | 0 |
107748 | 107748 | 2020-05-02 | Powell | Kentucky | 21197 | 1 | 0 |
110619 | 110619 | 2020-05-03 | Powell | Kentucky | 21197 | 1 | 0 |
113496 | 113496 | 2020-05-04 | Powell | Kentucky | 21197 | 1 | 0 |
116378 | 116378 | 2020-05-05 | Powell | Kentucky | 21197 | 1 | 0 |
119339 | 119339 | 2020-05-06 | Powell | Kentucky | 21197 | 1 | 0 |
122310 | 122310 | 2020-05-07 | Powell | Kentucky | 21197 | 1 | 0 |
125292 | 125292 | 2020-05-08 | Powell | Kentucky | 21197 | 1 | 0 |
128280 | 128280 | 2020-05-09 | Powell | Kentucky | 21197 | 1 | 0 |
131270 | 131270 | 2020-05-10 | Powell | Kentucky | 21197 | 1 | 0 |
134261 | 134261 | 2020-05-11 | Powell | Kentucky | 21197 | 1 | 0 |
137251 | 137251 | 2020-05-12 | Powell | Kentucky | 21197 | 1 | 0 |
140244 | 140244 | 2020-05-13 | Powell | Kentucky | 21197 | 1 | 0 |
143240 | 143240 | 2020-05-14 | Powell | Kentucky | 21197 | 1 | 0 |
146240 | 146240 | 2020-05-15 | Powell | Kentucky | 21197 | 1 | 0 |
149245 | 149245 | 2020-05-16 | Powell | Kentucky | 21197 | 1 | 0 |
152256 | 152256 | 2020-05-17 | Powell | Kentucky | 21197 | 1 | 0 |
155270 | 155270 | 2020-05-18 | Powell | Kentucky | 21197 | 1 | 0 |
158287 | 158287 | 2020-05-19 | Powell | Kentucky | 21197 | 1 | 0 |
161313 | 161313 | 2020-05-20 | Powell | Kentucky | 21197 | 1 | 0 |
164342 | 164342 | 2020-05-21 | Powell | Kentucky | 21197 | 1 | 0 |
167378 | 167378 | 2020-05-22 | Powell | Kentucky | 21197 | 1 | 0 |
170416 | 170416 | 2020-05-23 | Powell | Kentucky | 21197 | 1 | 0 |
173457 | 173457 | 2020-05-24 | Powell | Kentucky | 21197 | 1 | 0 |
176501 | 176501 | 2020-05-25 | Powell | Kentucky | 21197 | 1 | 0 |
179545 | 179545 | 2020-05-26 | Powell | Kentucky | 21197 | 1 | 0 |
182590 | 182590 | 2020-05-27 | Powell | Kentucky | 21197 | 1 | 0 |
185645 | 185645 | 2020-05-28 | Powell | Kentucky | 21197 | 1 | 0 |
188703 | 188703 | 2020-05-29 | Powell | Kentucky | 21197 | 1 | 0 |
191767 | 191767 | 2020-05-30 | Powell | Kentucky | 21197 | 1 | 0 |
194835 | 194835 | 2020-05-31 | Powell | Kentucky | 21197 | 1 | 0 |
197906 | 197906 | 2020-06-01 | Powell | Kentucky | 21197 | 1 | 0 |
200978 | 200978 | 2020-06-02 | Powell | Kentucky | 21197 | 1 | 0 |
204055 | 204055 | 2020-06-03 | Powell | Kentucky | 21197 | 1 | 0 |
207136 | 207136 | 2020-06-04 | Powell | Kentucky | 21197 | 1 | 0 |
210217 | 210217 | 2020-06-05 | Powell | Kentucky | 21197 | 1 | 0 |
213302 | 213302 | 2020-06-06 | Powell | Kentucky | 21197 | 1 | 0 |
216389 | 216389 | 2020-06-07 | Powell | Kentucky | 21197 | 1 | 0 |
219481 | 219481 | 2020-06-08 | Powell | Kentucky | 21197 | 1 | 0 |
222576 | 222576 | 2020-06-09 | Powell | Kentucky | 21197 | 2 | 0 |
225672 | 225672 | 2020-06-10 | Powell | Kentucky | 21197 | 3 | 0 |
228774 | 228774 | 2020-06-11 | Powell | Kentucky | 21197 | 3 | 0 |
231878 | 231878 | 2020-06-12 | Powell | Kentucky | 21197 | 4 | 0 |
234983 | 234983 | 2020-06-13 | Powell | Kentucky | 21197 | 4 | 0 |
238090 | 238090 | 2020-06-14 | Powell | Kentucky | 21197 | 4 | 0 |
241199 | 241199 | 2020-06-15 | Powell | Kentucky | 21197 | 5 | 0 |
244310 | 244310 | 2020-06-16 | Powell | Kentucky | 21197 | 5 | 0 |
247423 | 247423 | 2020-06-17 | Powell | Kentucky | 21197 | 5 | 0 |
250535 | 250535 | 2020-06-18 | Powell | Kentucky | 21197 | 5 | 0 |
253650 | 253650 | 2020-06-19 | Powell | Kentucky | 21197 | 5 | 0 |
256770 | 256770 | 2020-06-20 | Powell | Kentucky | 21197 | 5 | 0 |
259896 | 259896 | 2020-06-21 | Powell | Kentucky | 21197 | 5 | 0 |
263025 | 263025 | 2020-06-22 | Powell | Kentucky | 21197 | 5 | 0 |
266152 | 266152 | 2020-06-23 | Powell | Kentucky | 21197 | 5 | 0 |
269285 | 269285 | 2020-06-24 | Powell | Kentucky | 21197 | 5 | 0 |
272421 | 272421 | 2020-06-25 | Powell | Kentucky | 21197 | 5 | 0 |
275564 | 275564 | 2020-06-26 | Powell | Kentucky | 21197 | 6 | 0 |
278712 | 278712 | 2020-06-27 | Powell | Kentucky | 21197 | 6 | 0 |
281860 | 281860 | 2020-06-28 | Powell | Kentucky | 21197 | 6 | 0 |
285006 | 285006 | 2020-06-29 | Powell | Kentucky | 21197 | 6 | 0 |
288155 | 288155 | 2020-06-30 | Powell | Kentucky | 21197 | 6 | 0 |
291305 | 291305 | 2020-07-01 | Powell | Kentucky | 21197 | 7 | 0 |
294459 | 294459 | 2020-07-02 | Powell | Kentucky | 21197 | 7 | 0 |
297617 | 297617 | 2020-07-03 | Powell | Kentucky | 21197 | 8 | 0 |
300779 | 300779 | 2020-07-04 | Powell | Kentucky | 21197 | 8 | 0 |
303943 | 303943 | 2020-07-05 | Powell | Kentucky | 21197 | 8 | 0 |
307110 | 307110 | 2020-07-06 | Powell | Kentucky | 21197 | 8 | 0 |
310278 | 310278 | 2020-07-07 | Powell | Kentucky | 21197 | 8 | 0 |
313448 | 313448 | 2020-07-08 | Powell | Kentucky | 21197 | 8 | 0 |
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);