ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42055 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 754 ✖
- 40558 7
- 1 4
- 5 3
- 15480 3
- 40694 3
- 843 2
- 1572 2
- 1642 2
- 1807 2
- 1835 2
- 15180 2
- 15372 2
- 15447 2
- 15514 2
- 15584 2
- 15731 2
- 21904 2
- 39827 2
- 40118 2
- 40214 2
- 40270 2
- 3 1
- 7 1
- 11 1
- 12 1
- 19 1
- 21 1
- 23 1
- 26 1
- 27 1
- 30 1
- 32 1
- 39 1
- 43 1
- 52 1
- 57 1
- 59 1
- 64 1
- 66 1
- 69 1
- 78 1
- 80 1
- 89 1
- 106 1
- 111 1
- 115 1
- 143 1
- 151 1
- 152 1
- 164 1
- 181 1
- 205 1
- 227 1
- 237 1
- 264 1
- 284 1
- 313 1
- 325 1
- 351 1
- 377 1
- 396 1
- 406 1
- 425 1
- 452 1
- 478 1
- 493 1
- 513 1
- 522 1
- 545 1
- 563 1
- 580 1
- 601 1
- 621 1
- 631 1
- 644 1
- 662 1
- 677 1
- 697 1
- 711 1
- 734 1
- 740 1
- 746 1
- 756 1
- 759 1
- 762 1
- 767 1
- 774 1
- 777 1
- 781 1
- 782 1
- 785 1
- 788 1
- 792 1
- 795 1
- 798 1
- 800 1
- 807 1
- 827 1
- 837 1
- 842 1
- 849 1
- 852 1
- 855 1
- 872 1
- 876 1
- 879 1
- 882 1
- 891 1
- 896 1
- 900 1
- 902 1
- 912 1
- 913 1
- 915 1
- 925 1
- 940 1
- 950 1
- 954 1
- 955 1
- 956 1
- 958 1
- 970 1
- 984 1
- 989 1
- 993 1
- 997 1
- 1003 1
- 1006 1
- 1016 1
- 1019 1
- 1033 1
- 1043 1
- 1052 1
- 1061 1
- 1074 1
- 1096 1
- 1109 1
- 1146 1
- 1176 1
- 1186 1
- 1191 1
- 1201 1
- 1223 1
- 1231 1
- 1259 1
- 1268 1
- 1276 1
- 1281 1
- 1284 1
- 1294 1
- 1305 1
- 1323 1
- 1328 1
- 1343 1
- 1350 1
- 1368 1
- 1375 1
- 1385 1
- 1393 1
- 1407 1
- 1415 1
- 1416 1
- 1417 1
- 1427 1
- 1432 1
- 1439 1
- 1448 1
- 1457 1
- 1469 1
- 1472 1
- 1483 1
- 1488 1
- 1493 1
- 1499 1
- 1504 1
- 1508 1
- 1514 1
- 1525 1
- 1540 1
- 1550 1
- 1559 1
- 1576 1
- 1583 1
- 1616 1
- 1620 1
- 1633 1
- 1658 1
- 1677 1
- 1679 1
- 1691 1
- 1701 1
- 1710 1
- 1714 1
- 1719 1
- 1738 1
- 1747 1
- 1749 1
- 1757 1
- 1763 1
- 1774 1
- 1777 1
- 1790 1
- 1795 1
- 1798 1
- 1847 1
- 1855 1
- 1869 1
- 1875 1
- 1889 1
- 1892 1
- 1900 1
- 1931 1
- 1936 1
- 1957 1
- 1975 1
- 1982 1
- 1986 1
- 2003 1
- 2020 1
- 2031 1
- 2047 1
- 2081 1
- 2099 1
- 2112 1
- 2115 1
- 2168 1
- 2190 1
- 2219 1
- 2269 1
- 2306 1
- 2329 1
- 2346 1
- 2419 1
- 2467 1
- 2500 1
- 2546 1
- 2599 1
- 2640 1
- 2681 1
- 2758 1
- 2792 1
- 2892 1
- 2996 1
- 3060 1
- 3086 1
- 3156 1
- 3258 1
- 3425 1
- 3508 1
- 3582 1
- 3667 1
- 3829 1
- 3855 1
- 3937 1
- 4097 1
- 4210 1
- 4262 1
- 4320 1
- 4408 1
- 4476 1
- 4662 1
- 4801 1
- 5043 1
- 5232 1
- 5423 1
- 5496 1
- 5568 1
- 5753 1
- 5899 1
- 6042 1
- 6229 1
- 6419 1
- 6682 1
- 6767 1
- 6961 1
- 7063 1
- 7152 1
- 7293 1
- 7471 1
- 7547 1
- 7649 1
- 7776 1
- 7893 1
- 8001 1
- 8074 1
- 8201 1
- 8256 1
- 8294 1
- 8391 1
- 8570 1
- 8699 1
- 8766 1
- 8854 1
- 8924 1
- 8963 1
- 9189 1
- 9404 1
- 9515 1
- 9723 1
- 9855 1
- 9952 1
- 10035 1
- 10180 1
- 10263 1
- 10367 1
- 10442 1
- 10535 1
- 10607 1
- 10652 1
- 10801 1
- 10878 1
- 10933 1
- 10987 1
- 11057 1
- 11091 1
- 11120 1
- 11245 1
- 11302 1
- 11345 1
- 11405 1
- 11437 1
- 11476 1
- 11502 1
- 11583 1
- 11609 1
- 11638 1
- 11683 1
- 11749 1
- 11795 1
- 11813 1
- 11917 1
- 11949 1
- 11990 1
- 12043 1
- 12067 1
- 12101 1
- 12121 1
- 12182 1
- 12224 1
- 12252 1
- 12275 1
- 12292 1
- 12308 1
- 12309 1
- 12370 1
- 12406 1
- 12425 1
- 12464 1
- 12494 1
- 12503 1
- 12520 1
- 12556 1
- 12586 1
- 12620 1
- 12645 1
- 12662 1
- 12679 1
- 12688 1
- 12725 1
- 12767 1
- 12795 1
- 12837 1
- 12872 1
- 12891 1
- 12903 1
- 12976 1
- 13007 1
- 13029 1
- 13067 1
- 13101 1
- 13119 1
- 13123 1
- 13182 1
- 13226 1
- 13251 1
- 13292 1
- 13327 1
- 13348 1
- 13371 1
- 13448 1
- 13496 1
- 13532 1
- 13582 1
- 13624 1
- 13648 1
- 13669 1
- 13744 1
- 13799 1
- 13841 1
- 13877 1
- 13925 1
- 13961 1
- 13978 1
- 14044 1
- 14080 1
- 14169 1
- 14216 1
- 14248 1
- 14266 1
- 14288 1
- 14358 1
- 14398 1
- 14424 1
- 14459 1
- 14479 1
- 14498 1
- 14509 1
- 14571 1
- 14609 1
- 14626 1
- 14663 1
- 14692 1
- 14714 1
- 14725 1
- 14790 1
- 14822 1
- 14841 1
- 14860 1
- 14877 1
- 14888 1
- 14895 1
- 14971 1
- 14996 1
- 15012 1
- 15031 1
- 15046 1
- 15066 1
- 15080 1
- 15091 1
- 15109 1
- 15128 1
- 15222 1
- 15227 1
- 15249 1
- 15259 1
- 15277 1
- 15294 1
- 15297 1
- 15303 1
- 15306 1
- 15312 1
- 15325 1
- 15336 1
- 15357 1
- 15362 1
- 15379 1
- 15386 1
- 15391 1
- 15396 1
- 15406 1
- 15414 1
- 15415 1
- 15419 1
- 15424 1
- 15429 1
- 15438 1
- 15445 1
- 15449 1
- 15452 1
- 15453 1
- 15456 1
- 15462 1
- 15464 1
- 15466 1
- 15467 1
- 15469 1
- 15471 1
- 15477 1
- 15481 1
- 15486 1
- 15489 1
- 15491 1
- 15496 1
- 15497 1
- 15500 1
- 15507 1
- 15512 1
- 15519 1
- 15520 1
- 15521 1
- 15528 1
- 15531 1
- 15533 1
- 15534 1
- 15537 1
- 15540 1
- 15542 1
- 15559 1
- 15566 1
- 15574 1
- 15607 1
- 15614 1
- 15643 1
- 15664 1
- 15688 1
- 15705 1
- 15757 1
- 15804 1
- 15827 1
- 15864 1
- 15878 1
- 15902 1
- 15922 1
- 15947 1
- 16001 1
- 16029 1
- 16095 1
- 16127 1
- 16177 1
- 16214 1
- 16247 1
- 16333 1
- 16369 1
- 16422 1
- 16485 1
- 16552 1
- 16584 1
- 16641 1
- 16733 1
- 16823 1
- 16925 1
- 17007 1
- 17096 1
- 17166 1
- 17195 1
- 17272 1
- 17481 1
- 17621 1
- 17731 1
- 17858 1
- 17929 1
- 17954 1
- 18137 1
- 18200 1
- 18337 1
- 18479 1
- 18621 1
- 18707 1
- 18747 1
- 18891 1
- 18951 1
- 19092 1
- 19192 1
- 19272 1
- 19341 1
- 19403 1
- 19612 1
- 19707 1
- 19782 1
- 19922 1
- 19966 1
- 20041 1
- 20104 1
- 20214 1
- 20341 1
- 20448 1
- 20540 1
- 20611 1
- 20660 1
- 20690 1
- 20785 1
- 20843 1
- 20902 1
- 21028 1
- 21081 1
- 21138 1
- 21165 1
- 21284 1
- 21328 1
- 21375 1
- 21442 1
- 21477 1
- 21516 1
- 21539 1
- 21623 1
- 21689 1
- 21755 1
- 21816 1
- 21873 1
- 21998 1
- 22054 1
- 22117 1
- 22170 1
- 22207 1
- 22236 1
- 22263 1
- 22367 1
- 22412 1
- 22463 1
- 22532 1
- 22831 1
- 22884 1
- 22916 1
- 23049 1
- 23110 1
- 23168 1
- 23244 1
- 23327 1
- 23362 1
- 23411 1
- 23537 1
- 23626 1
- 23702 1
- 23757 1
- 23806 1
- 23844 1
- 23901 1
- 24077 1
- 24197 1
- 24318 1
- 24425 1
- 24536 1
- 24609 1
- 24666 1
- 24908 1
- 25035 1
- 25139 1
- 25226 1
- 25342 1
- 25441 1
- 25486 1
- 25691 1
- 25769 1
- 25897 1
- 26087 1
- 26239 1
- 26349 1
- 26441 1
- 26854 1
- 27620 1
- 28053 1
- 28513 1
- 28674 1
- 28762 1
- 28865 1
- 29085 1
- 29246 1
- 29444 1
- 29682 1
- 29845 1
- 30133 1
- 30240 1
- 30667 1
- 31041 1
- 31259 1
- 31535 1
- 31987 1
- 32207 1
- 32689 1
- 33151 1
- 33432 1
- 33806 1
- 34095 1
- 34399 1
- 34980 1
- 35232 1
- 35535 1
- 35907 1
- 36137 1
- 36493 1
- 36692 1
- 36871 1
- 37020 1
- 37407 1
- 37572 1
- 37826 1
- 38051 1
- 38227 1
- 38400 1
- 38474 1
- 38730 1
- 38837 1
- 38928 1
- 39020 1
- 39130 1
- 39167 1
- 39230 1
- 39340 1
- 39393 1
- 39471 1
- 39519 1
- 39563 1
- 39599 1
- 39620 1
- 39655 1
- 39680 1
- 39747 1
- 39769 1
- 39813 1
- 39876 1
- 39933 1
- 39959 1
- 39979 1
- 40048 1
- 40058 1
- 40067 1
- 40083 1
- 40091 1
- 40104 1
- 40113 1
- 40123 1
- 40139 1
- 40145 1
- 40157 1
- 40163 1
- 40170 1
- 40173 1
- 40175 1
- 40191 1
- 40198 1
- 40202 1
- 40204 1
- 40212 1
- 40227 1
- 40231 1
- 40242 1
- 40244 1
- 40249 1
- 40250 1
- 40252 1
- 40257 1
- 40265 1
- 40267 1
- 40272 1
- 40276 1
- 40290 1
- 40299 1
- 40304 1
- 40310 1
- 40315 1
- 40318 1
- 40319 1
- 40325 1
- 40328 1
- 40335 1
- 40344 1
- 40346 1
- 40350 1
- 40354 1
- 40362 1
- 40367 1
- 40381 1
- 40396 1
- 40406 1
- 40414 1
- 40419 1
- 40443 1
- 40469 1
- 40488 1
- 40500 1
- 40513 1
- 40518 1
- 40519 1
- 40538 1
state 1
- Pennsylvania 785
fips 1
- 42055 · 785 ✖
county 1
- Franklin 785
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5856 | 5856 | 2020-03-20 | Franklin | Pennsylvania | 42055 | 1 | 0 |
6859 | 6859 | 2020-03-21 | Franklin | Pennsylvania | 42055 | 1 | 0 |
7977 | 7977 | 2020-03-22 | Franklin | Pennsylvania | 42055 | 1 | 0 |
9188 | 9188 | 2020-03-23 | Franklin | Pennsylvania | 42055 | 1 | 0 |
10511 | 10511 | 2020-03-24 | Franklin | Pennsylvania | 42055 | 3 | 0 |
11973 | 11973 | 2020-03-25 | Franklin | Pennsylvania | 42055 | 5 | 0 |
13593 | 13593 | 2020-03-26 | Franklin | Pennsylvania | 42055 | 5 | 0 |
15339 | 15339 | 2020-03-27 | Franklin | Pennsylvania | 42055 | 5 | 0 |
17188 | 17188 | 2020-03-28 | Franklin | Pennsylvania | 42055 | 7 | 0 |
19126 | 19126 | 2020-03-29 | Franklin | Pennsylvania | 42055 | 11 | 0 |
21176 | 21176 | 2020-03-30 | Franklin | Pennsylvania | 42055 | 12 | 0 |
23312 | 23312 | 2020-03-31 | Franklin | Pennsylvania | 42055 | 19 | 0 |
25510 | 25510 | 2020-04-01 | Franklin | Pennsylvania | 42055 | 21 | 0 |
27783 | 27783 | 2020-04-02 | Franklin | Pennsylvania | 42055 | 23 | 0 |
30117 | 30117 | 2020-04-03 | Franklin | Pennsylvania | 42055 | 26 | 0 |
32507 | 32507 | 2020-04-04 | Franklin | Pennsylvania | 42055 | 27 | 0 |
34942 | 34942 | 2020-04-05 | Franklin | Pennsylvania | 42055 | 30 | 0 |
37417 | 37417 | 2020-04-06 | Franklin | Pennsylvania | 42055 | 32 | 0 |
39939 | 39939 | 2020-04-07 | Franklin | Pennsylvania | 42055 | 39 | 0 |
42499 | 42499 | 2020-04-08 | Franklin | Pennsylvania | 42055 | 43 | 0 |
45085 | 45085 | 2020-04-09 | Franklin | Pennsylvania | 42055 | 52 | 0 |
47702 | 47702 | 2020-04-10 | Franklin | Pennsylvania | 42055 | 57 | 0 |
50359 | 50359 | 2020-04-11 | Franklin | Pennsylvania | 42055 | 59 | 0 |
53032 | 53032 | 2020-04-12 | Franklin | Pennsylvania | 42055 | 64 | 0 |
55717 | 55717 | 2020-04-13 | Franklin | Pennsylvania | 42055 | 66 | 0 |
58420 | 58420 | 2020-04-14 | Franklin | Pennsylvania | 42055 | 69 | 0 |
61135 | 61135 | 2020-04-15 | Franklin | Pennsylvania | 42055 | 78 | 0 |
63861 | 63861 | 2020-04-16 | Franklin | Pennsylvania | 42055 | 80 | 0 |
66607 | 66607 | 2020-04-17 | Franklin | Pennsylvania | 42055 | 89 | 0 |
69365 | 69365 | 2020-04-18 | Franklin | Pennsylvania | 42055 | 106 | 0 |
72132 | 72132 | 2020-04-19 | Franklin | Pennsylvania | 42055 | 111 | 0 |
74907 | 74907 | 2020-04-20 | Franklin | Pennsylvania | 42055 | 115 | 0 |
77689 | 77689 | 2020-04-21 | Franklin | Pennsylvania | 42055 | 143 | 10 |
80479 | 80479 | 2020-04-22 | Franklin | Pennsylvania | 42055 | 152 | 10 |
83278 | 83278 | 2020-04-23 | Franklin | Pennsylvania | 42055 | 151 | 10 |
86082 | 86082 | 2020-04-24 | Franklin | Pennsylvania | 42055 | 164 | 10 |
88896 | 88896 | 2020-04-25 | Franklin | Pennsylvania | 42055 | 181 | 10 |
91712 | 91712 | 2020-04-26 | Franklin | Pennsylvania | 42055 | 205 | 10 |
94539 | 94539 | 2020-04-27 | Franklin | Pennsylvania | 42055 | 227 | 10 |
97378 | 97378 | 2020-04-28 | Franklin | Pennsylvania | 42055 | 237 | 10 |
100227 | 100227 | 2020-04-29 | Franklin | Pennsylvania | 42055 | 264 | 10 |
103080 | 103080 | 2020-04-30 | Franklin | Pennsylvania | 42055 | 284 | 10 |
105943 | 105943 | 2020-05-01 | Franklin | Pennsylvania | 42055 | 313 | 10 |
108810 | 108810 | 2020-05-02 | Franklin | Pennsylvania | 42055 | 325 | 10 |
111684 | 111684 | 2020-05-03 | Franklin | Pennsylvania | 42055 | 351 | 10 |
114566 | 114566 | 2020-05-04 | Franklin | Pennsylvania | 42055 | 377 | 10 |
117447 | 117447 | 2020-05-05 | Franklin | Pennsylvania | 42055 | 396 | 10 |
120409 | 120409 | 2020-05-06 | Franklin | Pennsylvania | 42055 | 406 | 10 |
123386 | 123386 | 2020-05-07 | Franklin | Pennsylvania | 42055 | 425 | 11 |
126369 | 126369 | 2020-05-08 | Franklin | Pennsylvania | 42055 | 452 | 11 |
129358 | 129358 | 2020-05-09 | Franklin | Pennsylvania | 42055 | 478 | 12 |
132347 | 132347 | 2020-05-10 | Franklin | Pennsylvania | 42055 | 493 | 12 |
135338 | 135338 | 2020-05-11 | Franklin | Pennsylvania | 42055 | 513 | 12 |
138328 | 138328 | 2020-05-12 | Franklin | Pennsylvania | 42055 | 522 | 12 |
141324 | 141324 | 2020-05-13 | Franklin | Pennsylvania | 42055 | 545 | 13 |
144320 | 144320 | 2020-05-14 | Franklin | Pennsylvania | 42055 | 563 | 15 |
147321 | 147321 | 2020-05-15 | Franklin | Pennsylvania | 42055 | 580 | 17 |
150328 | 150328 | 2020-05-16 | Franklin | Pennsylvania | 42055 | 601 | 13 |
153339 | 153339 | 2020-05-17 | Franklin | Pennsylvania | 42055 | 621 | 13 |
156356 | 156356 | 2020-05-18 | Franklin | Pennsylvania | 42055 | 631 | 25 |
159377 | 159377 | 2020-05-19 | Franklin | Pennsylvania | 42055 | 644 | 27 |
162404 | 162404 | 2020-05-20 | Franklin | Pennsylvania | 42055 | 662 | 27 |
165433 | 165433 | 2020-05-21 | Franklin | Pennsylvania | 42055 | 677 | 28 |
168469 | 168469 | 2020-05-22 | Franklin | Pennsylvania | 42055 | 697 | 28 |
171508 | 171508 | 2020-05-23 | Franklin | Pennsylvania | 42055 | 711 | 29 |
174550 | 174550 | 2020-05-24 | Franklin | Pennsylvania | 42055 | 734 | 29 |
177594 | 177594 | 2020-05-25 | Franklin | Pennsylvania | 42055 | 740 | 29 |
180637 | 180637 | 2020-05-26 | Franklin | Pennsylvania | 42055 | 746 | 29 |
183687 | 183687 | 2020-05-27 | Franklin | Pennsylvania | 42055 | 756 | 30 |
186744 | 186744 | 2020-05-28 | Franklin | Pennsylvania | 42055 | 759 | 31 |
189805 | 189805 | 2020-05-29 | Franklin | Pennsylvania | 42055 | 762 | 34 |
192870 | 192870 | 2020-05-30 | Franklin | Pennsylvania | 42055 | 767 | 35 |
195939 | 195939 | 2020-05-31 | Franklin | Pennsylvania | 42055 | 774 | 35 |
199012 | 199012 | 2020-06-01 | Franklin | Pennsylvania | 42055 | 777 | 35 |
202087 | 202087 | 2020-06-02 | Franklin | Pennsylvania | 42055 | 781 | 36 |
205164 | 205164 | 2020-06-03 | Franklin | Pennsylvania | 42055 | 782 | 37 |
208245 | 208245 | 2020-06-04 | Franklin | Pennsylvania | 42055 | 785 | 38 |
211327 | 211327 | 2020-06-05 | Franklin | Pennsylvania | 42055 | 788 | 39 |
214413 | 214413 | 2020-06-06 | Franklin | Pennsylvania | 42055 | 792 | 39 |
217503 | 217503 | 2020-06-07 | Franklin | Pennsylvania | 42055 | 795 | 39 |
220595 | 220595 | 2020-06-08 | Franklin | Pennsylvania | 42055 | 798 | 39 |
223690 | 223690 | 2020-06-09 | Franklin | Pennsylvania | 42055 | 800 | 39 |
226790 | 226790 | 2020-06-10 | Franklin | Pennsylvania | 42055 | 807 | 39 |
229894 | 229894 | 2020-06-11 | Franklin | Pennsylvania | 42055 | 827 | 40 |
232999 | 232999 | 2020-06-12 | Franklin | Pennsylvania | 42055 | 837 | 42 |
236104 | 236104 | 2020-06-13 | Franklin | Pennsylvania | 42055 | 843 | 42 |
239212 | 239212 | 2020-06-14 | Franklin | Pennsylvania | 42055 | 842 | 42 |
242321 | 242321 | 2020-06-15 | Franklin | Pennsylvania | 42055 | 843 | 42 |
245433 | 245433 | 2020-06-16 | Franklin | Pennsylvania | 42055 | 849 | 42 |
248546 | 248546 | 2020-06-17 | Franklin | Pennsylvania | 42055 | 852 | 42 |
251661 | 251661 | 2020-06-18 | Franklin | Pennsylvania | 42055 | 855 | 42 |
254776 | 254776 | 2020-06-19 | Franklin | Pennsylvania | 42055 | 872 | 42 |
257902 | 257902 | 2020-06-20 | Franklin | Pennsylvania | 42055 | 876 | 42 |
261029 | 261029 | 2020-06-21 | Franklin | Pennsylvania | 42055 | 879 | 42 |
264157 | 264157 | 2020-06-22 | Franklin | Pennsylvania | 42055 | 882 | 42 |
267285 | 267285 | 2020-06-23 | Franklin | Pennsylvania | 42055 | 891 | 42 |
270419 | 270419 | 2020-06-24 | Franklin | Pennsylvania | 42055 | 896 | 42 |
273558 | 273558 | 2020-06-25 | Franklin | Pennsylvania | 42055 | 900 | 42 |
276705 | 276705 | 2020-06-26 | Franklin | Pennsylvania | 42055 | 902 | 42 |
279853 | 279853 | 2020-06-27 | Franklin | Pennsylvania | 42055 | 912 | 42 |
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);