ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 42029 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 754 ✖
- 93973 7
- 4 3
- 5102 3
- 5439 3
- 6187 3
- 94968 3
- 40 2
- 2163 2
- 2242 2
- 2428 2
- 3287 2
- 3649 2
- 3796 2
- 3998 2
- 4885 2
- 5293 2
- 5604 2
- 5748 2
- 6777 2
- 7040 2
- 7833 2
- 40410 2
- 40827 2
- 41252 2
- 41686 2
- 51038 2
- 90156 2
- 91562 2
- 1 1
- 2 1
- 9 1
- 10 1
- 17 1
- 19 1
- 23 1
- 54 1
- 84 1
- 107 1
- 116 1
- 137 1
- 146 1
- 159 1
- 183 1
- 210 1
- 226 1
- 250 1
- 269 1
- 307 1
- 335 1
- 373 1
- 425 1
- 485 1
- 532 1
- 562 1
- 593 1
- 636 1
- 675 1
- 722 1
- 773 1
- 831 1
- 877 1
- 915 1
- 943 1
- 977 1
- 1017 1
- 1102 1
- 1174 1
- 1217 1
- 1251 1
- 1289 1
- 1339 1
- 1412 1
- 1470 1
- 1514 1
- 1546 1
- 1605 1
- 1647 1
- 1677 1
- 1716 1
- 1770 1
- 1816 1
- 1906 1
- 1926 1
- 1973 1
- 1996 1
- 2008 1
- 2102 1
- 2143 1
- 2267 1
- 2363 1
- 2403 1
- 2497 1
- 2545 1
- 2595 1
- 2647 1
- 2708 1
- 2769 1
- 2824 1
- 2864 1
- 2902 1
- 2943 1
- 2999 1
- 3014 1
- 3091 1
- 3139 1
- 3172 1
- 3198 1
- 3227 1
- 3337 1
- 3356 1
- 3387 1
- 3411 1
- 3438 1
- 3479 1
- 3499 1
- 3529 1
- 3557 1
- 3580 1
- 3601 1
- 3620 1
- 3658 1
- 3718 1
- 3751 1
- 3775 1
- 3800 1
- 3831 1
- 3882 1
- 3906 1
- 3936 1
- 3961 1
- 4012 1
- 4064 1
- 4103 1
- 4153 1
- 4175 1
- 4243 1
- 4245 1
- 4295 1
- 4372 1
- 4422 1
- 4459 1
- 4517 1
- 4580 1
- 4586 1
- 4608 1
- 4709 1
- 4780 1
- 4796 1
- 4836 1
- 4890 1
- 4965 1
- 5014 1
- 5040 1
- 5075 1
- 5157 1
- 5194 1
- 5235 1
- 5264 1
- 5298 1
- 5347 1
- 5362 1
- 5417 1
- 5427 1
- 5505 1
- 5527 1
- 5542 1
- 5561 1
- 5607 1
- 5678 1
- 5719 1
- 5821 1
- 5835 1
- 5899 1
- 5939 1
- 6030 1
- 6089 1
- 6149 1
- 6294 1
- 6357 1
- 6401 1
- 6462 1
- 6510 1
- 6526 1
- 6567 1
- 6633 1
- 6660 1
- 6701 1
- 6741 1
- 6803 1
- 6825 1
- 6920 1
- 6958 1
- 7002 1
- 7075 1
- 7135 1
- 7155 1
- 7202 1
- 7243 1
- 7285 1
- 7292 1
- 7324 1
- 7401 1
- 7455 1
- 7491 1
- 7534 1
- 7575 1
- 7577 1
- 7593 1
- 7656 1
- 7701 1
- 7730 1
- 7775 1
- 7876 1
- 7986 1
- 8039 1
- 8093 1
- 8163 1
- 8198 1
- 8223 1
- 8282 1
- 8361 1
- 8398 1
- 8506 1
- 8581 1
- 8669 1
- 8758 1
- 8817 1
- 8928 1
- 9040 1
- 9169 1
- 9291 1
- 9440 1
- 9601 1
- 9774 1
- 9895 1
- 10020 1
- 10180 1
- 10402 1
- 10574 1
- 10764 1
- 10935 1
- 11080 1
- 11222 1
- 11369 1
- 11619 1
- 11833 1
- 12009 1
- 12154 1
- 12246 1
- 12421 1
- 12654 1
- 13017 1
- 13426 1
- 13686 1
- 13976 1
- 14178 1
- 14470 1
- 14691 1
- 15015 1
- 15264 1
- 15614 1
- 15850 1
- 16105 1
- 16414 1
- 16696 1
- 16929 1
- 17353 1
- 17581 1
- 17798 1
- 17999 1
- 18281 1
- 18562 1
- 18838 1
- 19059 1
- 19309 1
- 19425 1
- 19627 1
- 19845 1
- 20185 1
- 20457 1
- 20648 1
- 20938 1
- 21081 1
- 21137 1
- 21529 1
- 21796 1
- 22280 1
- 22570 1
- 22921 1
- 23197 1
- 23366 1
- 23631 1
- 23914 1
- 24140 1
- 24369 1
- 24645 1
- 24822 1
- 24984 1
- 25167 1
- 25381 1
- 25579 1
- 25771 1
- 25948 1
- 26110 1
- 26249 1
- 26380 1
- 26580 1
- 26744 1
- 27079 1
- 27251 1
- 27405 1
- 27519 1
- 27695 1
- 27775 1
- 27915 1
- 28042 1
- 28201 1
- 28399 1
- 28502 1
- 28624 1
- 28723 1
- 28871 1
- 28958 1
- 29112 1
- 29212 1
- 29325 1
- 29416 1
- 29560 1
- 29693 1
- 29781 1
- 29843 1
- 29912 1
- 30004 1
- 30099 1
- 30220 1
- 30317 1
- 30445 1
- 30561 1
- 30629 1
- 30687 1
- 30776 1
- 30878 1
- 30969 1
- 31065 1
- 31152 1
- 31224 1
- 31291 1
- 31372 1
- 31460 1
- 31528 1
- 31637 1
- 31721 1
- 31819 1
- 31878 1
- 31973 1
- 32094 1
- 32224 1
- 32349 1
- 32487 1
- 32610 1
- 32682 1
- 32810 1
- 32986 1
- 33091 1
- 33278 1
- 33485 1
- 33631 1
- 33748 1
- 34011 1
- 34185 1
- 34327 1
- 34549 1
- 34760 1
- 34949 1
- 35102 1
- 35229 1
- 35377 1
- 35563 1
- 35732 1
- 35905 1
- 36073 1
- 36197 1
- 36459 1
- 36706 1
- 36892 1
- 37067 1
- 37235 1
- 37466 1
- 37555 1
- 37749 1
- 37909 1
- 38031 1
- 38192 1
- 38323 1
- 38455 1
- 38551 1
- 38700 1
- 38824 1
- 38945 1
- 39112 1
- 39226 1
- 39301 1
- 39343 1
- 39476 1
- 39578 1
- 39645 1
- 39752 1
- 39817 1
- 39871 1
- 39910 1
- 39960 1
- 40009 1
- 40076 1
- 40134 1
- 40178 1
- 40219 1
- 40241 1
- 40292 1
- 40318 1
- 40348 1
- 40471 1
- 40484 1
- 40516 1
- 40550 1
- 40575 1
- 40594 1
- 40623 1
- 40647 1
- 40655 1
- 40666 1
- 40680 1
- 40682 1
- 40684 1
- 40689 1
- 40691 1
- 40697 1
- 40698 1
- 40700 1
- 40704 1
- 40705 1
- 40718 1
- 40723 1
- 40725 1
- 40736 1
- 40746 1
- 40758 1
- 40759 1
- 40761 1
- 40765 1
- 40774 1
- 40787 1
- 40793 1
- 40795 1
- 40805 1
- 40813 1
- 40820 1
- 40822 1
- 40830 1
- 40835 1
- 40838 1
- 40842 1
- 40846 1
- 40851 1
- 40861 1
- 40872 1
- 40876 1
- 40886 1
- 40894 1
- 40897 1
- 40910 1
- 40922 1
- 40936 1
- 40942 1
- 40947 1
- 40963 1
- 40971 1
- 40982 1
- 41005 1
- 41025 1
- 41054 1
- 41087 1
- 41106 1
- 41123 1
- 41161 1
- 41184 1
- 41210 1
- 41336 1
- 41380 1
- 41423 1
- 41470 1
- 41541 1
- 41610 1
- 41791 1
- 41871 1
- 41937 1
- 42026 1
- 42128 1
- 42213 1
- 42309 1
- 42388 1
- 42476 1
- 42565 1
- 42652 1
- 42721 1
- 42803 1
- 42868 1
- 42941 1
- 43010 1
- 43111 1
- 43250 1
- 43389 1
- 43498 1
- 43608 1
- 43708 1
- 43860 1
- 43986 1
- 44100 1
- 44205 1
- 44327 1
- 44398 1
- 44495 1
- 44583 1
- 44720 1
- 44842 1
- 44998 1
- 45136 1
- 45286 1
- 45384 1
- 45499 1
- 45659 1
- 45804 1
- 45996 1
- 46103 1
- 46229 1
- 46308 1
- 46439 1
- 46545 1
- 46667 1
- 46804 1
- 46946 1
- 47053 1
- 47148 1
- 47264 1
- 47387 1
- 47513 1
- 47641 1
- 47789 1
- 47935 1
- 48073 1
- 48201 1
- 48321 1
- 48461 1
- 48574 1
- 48725 1
- 48817 1
- 48897 1
- 49010 1
- 49165 1
- 49250 1
- 49427 1
- 49531 1
- 49643 1
- 49705 1
- 49843 1
- 49939 1
- 50095 1
- 50251 1
- 50330 1
- 50406 1
- 50463 1
- 50555 1
- 50649 1
- 50754 1
- 50851 1
- 50979 1
- 51199 1
- 51260 1
- 51421 1
- 51542 1
- 51647 1
- 51755 1
- 51826 1
- 51957 1
- 52084 1
- 52226 1
- 52331 1
- 52886 1
- 53031 1
- 53141 1
- 53278 1
- 53475 1
- 53655 1
- 53807 1
- 53944 1
- 54083 1
- 54218 1
- 54377 1
- 54518 1
- 54713 1
- 54840 1
- 54981 1
- 55089 1
- 55228 1
- 55423 1
- 55670 1
- 55993 1
- 56266 1
- 56515 1
- 56677 1
- 56761 1
- 56993 1
- 57225 1
- 57459 1
- 57893 1
- 58320 1
- 58556 1
- 58779 1
- 59056 1
- 59384 1
- 59688 1
- 60010 1
- 60414 1
- 60720 1
- 60935 1
- 61255 1
- 61651 1
- 62064 1
- 62638 1
- 63050 1
- 63518 1
- 63789 1
- 64499 1
- 65162 1
- 65963 1
- 66965 1
- 67755 1
- 68556 1
- 69335 1
- 70090 1
- 71223 1
- 72122 1
- 73168 1
- 74137 1
- 75216 1
- 76043 1
- 76863 1
- 77666 1
- 78535 1
- 79292 1
- 80208 1
- 81471 1
- 82080 1
- 82556 1
- 83005 1
- 83698 1
- 84183 1
- 84628 1
- 85030 1
- 85307 1
- 85615 1
- 85999 1
- 86490 1
- 86923 1
- 87147 1
- 87343 1
- 87448 1
- 87658 1
- 87863 1
- 88057 1
- 88232 1
- 88534 1
- 88623 1
- 88661 1
- 88764 1
- 88909 1
- 89022 1
- 89034 1
- 89152 1
- 89213 1
- 89276 1
- 89366 1
- 89517 1
- 89819 1
- 89907 1
- 90104 1
- 90237 1
- 90261 1
- 90329 1
- 90389 1
- 90517 1
- 90547 1
- 90567 1
- 90583 1
- 90606 1
- 90651 1
- 90674 1
- 90715 1
- 90741 1
- 90773 1
- 90850 1
- 90881 1
- 90913 1
- 90946 1
- 90979 1
- 90992 1
- 91002 1
- 91034 1
- 91061 1
- 91078 1
- 91100 1
- 91136 1
- 91149 1
- 91172 1
- 91193 1
- 91216 1
- 91263 1
- 91305 1
- 91338 1
- 91357 1
- 91382 1
- 91414 1
- 91460 1
- 91485 1
- 91520 1
- 91619 1
- 91659 1
- 91701 1
- 91756 1
- 91820 1
- 91895 1
- 91940 1
- 91981 1
- 92032 1
- 92080 1
- 92175 1
- 92260 1
- 92349 1
- 92417 1
- 92470 1
- 92529 1
- 92609 1
- 92717 1
- 92809 1
- 92896 1
- 92956 1
- 93022 1
- 93095 1
- 93213 1
- 93323 1
- 93438 1
- 93560 1
- 93638 1
- 93729 1
- 93842 1
state 1
- Pennsylvania · 792 ✖
fips 1
- 42029 · 792 ✖
county 1
- Chester 792
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501861 | 2501861 | 2022-05-13 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2498603 | 2498603 | 2022-05-12 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2495345 | 2495345 | 2022-05-11 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2492087 | 2492087 | 2022-05-10 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2488829 | 2488829 | 2022-05-09 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2485572 | 2485572 | 2022-05-08 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2482314 | 2482314 | 2022-05-07 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2479056 | 2479056 | 2022-05-06 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2475798 | 2475798 | 2022-05-05 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2472541 | 2472541 | 2022-05-04 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2469285 | 2469285 | 2022-05-03 | Chester | Pennsylvania | 42029 | 93842 | 1154 |
2466029 | 2466029 | 2022-05-02 | Chester | Pennsylvania | 42029 | 93729 | 1153 |
2462774 | 2462774 | 2022-05-01 | Chester | Pennsylvania | 42029 | 93638 | 1153 |
2459518 | 2459518 | 2022-04-30 | Chester | Pennsylvania | 42029 | 93560 | 1153 |
2456262 | 2456262 | 2022-04-29 | Chester | Pennsylvania | 42029 | 93438 | 1153 |
2453006 | 2453006 | 2022-04-28 | Chester | Pennsylvania | 42029 | 93323 | 1153 |
2449750 | 2449750 | 2022-04-27 | Chester | Pennsylvania | 42029 | 93213 | 1152 |
2446493 | 2446493 | 2022-04-26 | Chester | Pennsylvania | 42029 | 93095 | 1151 |
2443238 | 2443238 | 2022-04-25 | Chester | Pennsylvania | 42029 | 93022 | 1151 |
2439982 | 2439982 | 2022-04-24 | Chester | Pennsylvania | 42029 | 92956 | 1151 |
2436726 | 2436726 | 2022-04-23 | Chester | Pennsylvania | 42029 | 92896 | 1151 |
2433470 | 2433470 | 2022-04-22 | Chester | Pennsylvania | 42029 | 92809 | 1150 |
2430214 | 2430214 | 2022-04-21 | Chester | Pennsylvania | 42029 | 92717 | 1150 |
2426958 | 2426958 | 2022-04-20 | Chester | Pennsylvania | 42029 | 92609 | 1148 |
2423702 | 2423702 | 2022-04-19 | Chester | Pennsylvania | 42029 | 92529 | 1148 |
2420446 | 2420446 | 2022-04-18 | Chester | Pennsylvania | 42029 | 92470 | 1145 |
2417190 | 2417190 | 2022-04-17 | Chester | Pennsylvania | 42029 | 92417 | 1145 |
2413934 | 2413934 | 2022-04-16 | Chester | Pennsylvania | 42029 | 92349 | 1145 |
2410678 | 2410678 | 2022-04-15 | Chester | Pennsylvania | 42029 | 92260 | 1145 |
2407422 | 2407422 | 2022-04-14 | Chester | Pennsylvania | 42029 | 92175 | 1145 |
2404166 | 2404166 | 2022-04-13 | Chester | Pennsylvania | 42029 | 92080 | 1144 |
2400911 | 2400911 | 2022-04-12 | Chester | Pennsylvania | 42029 | 92032 | 1144 |
2397656 | 2397656 | 2022-04-11 | Chester | Pennsylvania | 42029 | 91981 | 1144 |
2394401 | 2394401 | 2022-04-10 | Chester | Pennsylvania | 42029 | 91940 | 1143 |
2391145 | 2391145 | 2022-04-09 | Chester | Pennsylvania | 42029 | 91895 | 1143 |
2387889 | 2387889 | 2022-04-08 | Chester | Pennsylvania | 42029 | 91820 | 1142 |
2384634 | 2384634 | 2022-04-07 | Chester | Pennsylvania | 42029 | 91756 | 1141 |
2381379 | 2381379 | 2022-04-06 | Chester | Pennsylvania | 42029 | 91701 | 1140 |
2378124 | 2378124 | 2022-04-05 | Chester | Pennsylvania | 42029 | 91659 | 1140 |
2374870 | 2374870 | 2022-04-04 | Chester | Pennsylvania | 42029 | 91619 | 1140 |
2371618 | 2371618 | 2022-04-03 | Chester | Pennsylvania | 42029 | 91562 | 1140 |
2368365 | 2368365 | 2022-04-02 | Chester | Pennsylvania | 42029 | 91562 | 1140 |
2365112 | 2365112 | 2022-04-01 | Chester | Pennsylvania | 42029 | 91520 | 1140 |
2361859 | 2361859 | 2022-03-31 | Chester | Pennsylvania | 42029 | 91485 | 1139 |
2358605 | 2358605 | 2022-03-30 | Chester | Pennsylvania | 42029 | 91460 | 1139 |
2355351 | 2355351 | 2022-03-29 | Chester | Pennsylvania | 42029 | 91414 | 1139 |
2352098 | 2352098 | 2022-03-28 | Chester | Pennsylvania | 42029 | 91382 | 1135 |
2348846 | 2348846 | 2022-03-27 | Chester | Pennsylvania | 42029 | 91357 | 1135 |
2345593 | 2345593 | 2022-03-26 | Chester | Pennsylvania | 42029 | 91338 | 1135 |
2342340 | 2342340 | 2022-03-25 | Chester | Pennsylvania | 42029 | 91305 | 1135 |
2339087 | 2339087 | 2022-03-24 | Chester | Pennsylvania | 42029 | 91263 | 1134 |
2335833 | 2335833 | 2022-03-23 | Chester | Pennsylvania | 42029 | 91216 | 1133 |
2332579 | 2332579 | 2022-03-22 | Chester | Pennsylvania | 42029 | 91193 | 1132 |
2329326 | 2329326 | 2022-03-21 | Chester | Pennsylvania | 42029 | 91172 | 1132 |
2326074 | 2326074 | 2022-03-20 | Chester | Pennsylvania | 42029 | 91149 | 1132 |
2322821 | 2322821 | 2022-03-19 | Chester | Pennsylvania | 42029 | 91136 | 1132 |
2319567 | 2319567 | 2022-03-18 | Chester | Pennsylvania | 42029 | 91100 | 1132 |
2316313 | 2316313 | 2022-03-17 | Chester | Pennsylvania | 42029 | 91078 | 1132 |
2313060 | 2313060 | 2022-03-16 | Chester | Pennsylvania | 42029 | 91061 | 1132 |
2309807 | 2309807 | 2022-03-15 | Chester | Pennsylvania | 42029 | 91034 | 1130 |
2306554 | 2306554 | 2022-03-14 | Chester | Pennsylvania | 42029 | 91002 | 1129 |
2303303 | 2303303 | 2022-03-13 | Chester | Pennsylvania | 42029 | 90992 | 1129 |
2300051 | 2300051 | 2022-03-12 | Chester | Pennsylvania | 42029 | 90979 | 1129 |
2296799 | 2296799 | 2022-03-11 | Chester | Pennsylvania | 42029 | 90946 | 1129 |
2293547 | 2293547 | 2022-03-10 | Chester | Pennsylvania | 42029 | 90913 | 1126 |
2290295 | 2290295 | 2022-03-09 | Chester | Pennsylvania | 42029 | 90881 | 1125 |
2287043 | 2287043 | 2022-03-08 | Chester | Pennsylvania | 42029 | 90850 | 1124 |
2283791 | 2283791 | 2022-03-07 | Chester | Pennsylvania | 42029 | 90773 | 1122 |
2280539 | 2280539 | 2022-03-06 | Chester | Pennsylvania | 42029 | 90741 | 1122 |
2277286 | 2277286 | 2022-03-05 | Chester | Pennsylvania | 42029 | 90715 | 1120 |
2274033 | 2274033 | 2022-03-04 | Chester | Pennsylvania | 42029 | 90674 | 1120 |
2270780 | 2270780 | 2022-03-03 | Chester | Pennsylvania | 42029 | 90651 | 1118 |
2267528 | 2267528 | 2022-03-02 | Chester | Pennsylvania | 42029 | 90606 | 1114 |
2264275 | 2264275 | 2022-03-01 | Chester | Pennsylvania | 42029 | 90583 | 1113 |
2261025 | 2261025 | 2022-02-28 | Chester | Pennsylvania | 42029 | 90567 | 1112 |
2257774 | 2257774 | 2022-02-27 | Chester | Pennsylvania | 42029 | 90547 | 1112 |
2254523 | 2254523 | 2022-02-26 | Chester | Pennsylvania | 42029 | 90517 | 1112 |
2251272 | 2251272 | 2022-02-25 | Chester | Pennsylvania | 42029 | 90389 | 1111 |
2248021 | 2248021 | 2022-02-24 | Chester | Pennsylvania | 42029 | 90329 | 1109 |
2244770 | 2244770 | 2022-02-23 | Chester | Pennsylvania | 42029 | 90261 | 1109 |
2241519 | 2241519 | 2022-02-22 | Chester | Pennsylvania | 42029 | 90237 | 1105 |
2238268 | 2238268 | 2022-02-21 | Chester | Pennsylvania | 42029 | 90156 | 1105 |
2235017 | 2235017 | 2022-02-20 | Chester | Pennsylvania | 42029 | 90156 | 1105 |
2231766 | 2231766 | 2022-02-19 | Chester | Pennsylvania | 42029 | 90104 | 1102 |
2228515 | 2228515 | 2022-02-18 | Chester | Pennsylvania | 42029 | 89907 | 1102 |
2225264 | 2225264 | 2022-02-17 | Chester | Pennsylvania | 42029 | 89819 | 1102 |
2222013 | 2222013 | 2022-02-16 | Chester | Pennsylvania | 42029 | 89517 | 1102 |
2218762 | 2218762 | 2022-02-15 | Chester | Pennsylvania | 42029 | 89366 | 1101 |
2215511 | 2215511 | 2022-02-14 | Chester | Pennsylvania | 42029 | 89276 | 1098 |
2212260 | 2212260 | 2022-02-13 | Chester | Pennsylvania | 42029 | 89213 | 1097 |
2209007 | 2209007 | 2022-02-12 | Chester | Pennsylvania | 42029 | 89152 | 1097 |
2205754 | 2205754 | 2022-02-11 | Chester | Pennsylvania | 42029 | 89022 | 1096 |
2202501 | 2202501 | 2022-02-10 | Chester | Pennsylvania | 42029 | 88909 | 1094 |
2199247 | 2199247 | 2022-02-09 | Chester | Pennsylvania | 42029 | 88764 | 1090 |
2195993 | 2195993 | 2022-02-08 | Chester | Pennsylvania | 42029 | 88661 | 1087 |
2192739 | 2192739 | 2022-02-07 | Chester | Pennsylvania | 42029 | 89034 | 1083 |
2189485 | 2189485 | 2022-02-06 | Chester | Pennsylvania | 42029 | 88623 | 1083 |
2186232 | 2186232 | 2022-02-05 | Chester | Pennsylvania | 42029 | 88534 | 1083 |
2182980 | 2182980 | 2022-02-04 | Chester | Pennsylvania | 42029 | 88232 | 1079 |
2179728 | 2179728 | 2022-02-03 | Chester | Pennsylvania | 42029 | 88057 | 1076 |
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);