ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,357 rows where county = "Chester" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 506 ✖
- 0 217
- 51 132
- 76 89
- 48 50
- 1 40
- 96 36
- 75 31
- 81 29
- 2 28
- 19 25
- 21 23
- 151 23
- 45 22
- 97 22
- 14 20
- 69 20
- 123 20
- 88 19
- 78 18
- 83 18
- 13 17
- 6 16
- 77 16
- 80 16
- 18 15
- 824 15
- 44 14
- 54 14
- 57 14
- 71 14
- 28 13
- 30 13
- 72 13
- 826 13
- 827 13
- 4 12
- 124 12
- 825 12
- 22 11
- 145 11
- 153 11
- 8 10
- 25 10
- 46 10
- 65 10
- 128 10
- 349 10
- 374 10
- 821 10
- 17 9
- 39 9
- 58 9
- 10 8
- 27 8
- 32 8
- 38 8
- 84 8
- 92 8
- 94 8
- 111 8
- 135 8
- 15 7
- 31 7
- 33 7
- 36 7
- 37 7
- 41 7
- 66 7
- 68 7
- 73 7
- 74 7
- 86 7
- 90 7
- 118 7
- 119 7
- 148 7
- 150 7
- 350 7
- 362 7
- 381 7
- 383 7
- 746 7
- 754 7
- 843 7
- 1132 7
- 1158 7
- 5 6
- 9 6
- 16 6
- 20 6
- 24 6
- 47 6
- 64 6
- 91 6
- 105 6
- 117 6
- 132 6
- 367 6
- 830 6
- 837 6
- 839 6
- 1140 6
- 11 5
- 26 5
- 34 5
- 55 5
- 70 5
- 79 5
- 99 5
- 106 5
- 115 5
- 121 5
- 136 5
- 139 5
- 152 5
- 335 5
- 343 5
- 369 5
- 378 5
- 398 5
- 814 5
- 822 5
- 903 5
- 1145 5
- 1153 5
- 7 4
- 12 4
- 67 4
- 93 4
- 116 4
- 125 4
- 126 4
- 134 4
- 323 4
- 329 4
- 352 4
- 359 4
- 384 4
- 731 4
- 759 4
- 841 4
- 860 4
- 866 4
- 871 4
- 888 4
- 895 4
- 948 4
- 1020 4
- 1102 4
- 1129 4
- 1135 4
- 1151 4
- 3 3
- 23 3
- 42 3
- 62 3
- 82 3
- 98 3
- 101 3
- 109 3
- 113 3
- 122 3
- 127 3
- 307 3
- 339 3
- 351 3
- 356 3
- 364 3
- 366 3
- 389 3
- 416 3
- 440 3
- 459 3
- 643 3
- 742 3
- 764 3
- 772 3
- 777 3
- 789 3
- 820 3
- 842 3
- 846 3
- 850 3
- 851 3
- 901 3
- 916 3
- 937 3
- 967 3
- 993 3
- 1035 3
- 1083 3
- 1105 3
- 1112 3
- 1139 3
- 1144 3
- 1164 3
- 35 2
- 50 2
- 52 2
- 53 2
- 56 2
- 60 2
- 61 2
- 85 2
- 89 2
- 100 2
- 103 2
- 112 2
- 114 2
- 120 2
- 129 2
- 133 2
- 140 2
- 141 2
- 281 2
- 297 2
- 304 2
- 316 2
- 324 2
- 333 2
- 337 2
- 341 2
- 342 2
- 346 2
- 348 2
- 357 2
- 358 2
- 361 2
- 370 2
- 371 2
- 375 2
- 376 2
- 379 2
- 388 2
- 392 2
- 430 2
- 483 2
- 521 2
- 660 2
- 697 2
- 698 2
- 711 2
- 713 2
- 723 2
- 750 2
- 753 2
- 762 2
- 769 2
- 775 2
- 776 2
- 795 2
- 796 2
- 802 2
- 806 2
- 823 2
- 834 2
- 838 2
- 867 2
- 879 2
- 880 2
- 892 2
- 902 2
- 920 2
- 1058 2
- 1097 2
- 1109 2
- 1120 2
- 1122 2
- 1143 2
- 1148 2
- 1150 2
- 40 1
- 43 1
- 49 1
- 59 1
- 87 1
- 95 1
- 102 1
- 104 1
- 130 1
- 131 1
- 142 1
- 149 1
- 156 1
- 167 1
- 176 1
- 183 1
- 184 1
- 187 1
- 189 1
- 197 1
- 213 1
- 218 1
- 220 1
- 222 1
- 227 1
- 230 1
- 235 1
- 238 1
- 242 1
- 245 1
- 248 1
- 251 1
- 252 1
- 260 1
- 270 1
- 277 1
- 280 1
- 284 1
- 287 1
- 294 1
- 296 1
- 298 1
- 303 1
- 306 1
- 309 1
- 311 1
- 312 1
- 313 1
- 315 1
- 317 1
- 319 1
- 321 1
- 328 1
- 330 1
- 354 1
- 355 1
- 360 1
- 386 1
- 399 1
- 402 1
- 406 1
- 413 1
- 418 1
- 420 1
- 441 1
- 442 1
- 444 1
- 452 1
- 462 1
- 463 1
- 466 1
- 485 1
- 490 1
- 491 1
- 499 1
- 507 1
- 512 1
- 520 1
- 522 1
- 531 1
- 544 1
- 555 1
- 568 1
- 575 1
- 577 1
- 579 1
- 587 1
- 596 1
- 605 1
- 609 1
- 616 1
- 622 1
- 623 1
- 624 1
- 632 1
- 639 1
- 644 1
- 647 1
- 653 1
- 656 1
- 657 1
- 659 1
- 663 1
- 664 1
- 670 1
- 673 1
- 678 1
- 679 1
- 681 1
- 684 1
- 689 1
- 693 1
- 695 1
- 707 1
- 714 1
- 717 1
- 719 1
- 721 1
- 725 1
- 726 1
- 729 1
- 730 1
- 732 1
- 735 1
- 738 1
- 740 1
- 743 1
- 745 1
- 748 1
- 752 1
- 756 1
- 757 1
- 758 1
- 760 1
- 761 1
- 768 1
- 770 1
- 779 1
- 780 1
- 786 1
- 788 1
- 791 1
- 800 1
- 801 1
- 803 1
- 804 1
- 805 1
- 809 1
- 811 1
- 812 1
- 813 1
- 816 1
- 818 1
- 829 1
- 833 1
- 844 1
- 849 1
- 852 1
- 853 1
- 858 1
- 862 1
- 865 1
- 869 1
- 872 1
- 874 1
- 875 1
- 877 1
- 881 1
- 883 1
- 885 1
- 891 1
- 893 1
- 897 1
- 899 1
- 900 1
- 905 1
- 906 1
- 909 1
- 910 1
- 912 1
- 913 1
- 914 1
- 915 1
- 918 1
- 923 1
- 927 1
- 929 1
- 930 1
- 934 1
- 938 1
- 944 1
- 954 1
- 958 1
- 962 1
- 970 1
- 974 1
- 976 1
- 983 1
- 990 1
- 998 1
- 1003 1
- 1007 1
- 1010 1
- 1024 1
- 1028 1
- 1032 1
- 1037 1
- 1038 1
- 1053 1
- 1054 1
- 1057 1
- 1070 1
- 1073 1
- 1076 1
- 1079 1
- 1087 1
- 1090 1
- 1094 1
- 1096 1
- 1098 1
- 1101 1
- 1111 1
- 1113 1
- 1114 1
- 1118 1
- 1124 1
- 1125 1
- 1126 1
- 1130 1
- 1133 1
- 1134 1
- 1141 1
- 1142 1
- 1152 1
- 1154 1
state 3
- Pennsylvania 792
- Tennessee 783
- South Carolina 782
county 1
- Chester · 2,357 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501861 | 2501861 | 2022-05-13 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2502010 | 2502010 | 2022-05-13 | Chester | South Carolina | 45023 | 10134 | 153 |
2502122 | 2502122 | 2022-05-13 | Chester | Tennessee | 47023 | 5870 | 99 |
2498603 | 2498603 | 2022-05-12 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2498752 | 2498752 | 2022-05-12 | Chester | South Carolina | 45023 | 10134 | 153 |
2498864 | 2498864 | 2022-05-12 | Chester | Tennessee | 47023 | 5870 | 99 |
2495345 | 2495345 | 2022-05-11 | Chester | Pennsylvania | 42029 | 94968 | 1164 |
2495494 | 2495494 | 2022-05-11 | Chester | South Carolina | 45023 | 10134 | 153 |
2495606 | 2495606 | 2022-05-11 | Chester | Tennessee | 47023 | 5870 | 99 |
2492087 | 2492087 | 2022-05-10 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2492236 | 2492236 | 2022-05-10 | Chester | South Carolina | 45023 | 10116 | 153 |
2492348 | 2492348 | 2022-05-10 | Chester | Tennessee | 47023 | 5863 | 97 |
2488829 | 2488829 | 2022-05-09 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2488978 | 2488978 | 2022-05-09 | Chester | South Carolina | 45023 | 10116 | 153 |
2489090 | 2489090 | 2022-05-09 | Chester | Tennessee | 47023 | 5863 | 97 |
2485572 | 2485572 | 2022-05-08 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2485721 | 2485721 | 2022-05-08 | Chester | South Carolina | 45023 | 10116 | 153 |
2485833 | 2485833 | 2022-05-08 | Chester | Tennessee | 47023 | 5863 | 97 |
2482314 | 2482314 | 2022-05-07 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2482463 | 2482463 | 2022-05-07 | Chester | South Carolina | 45023 | 10116 | 153 |
2482575 | 2482575 | 2022-05-07 | Chester | Tennessee | 47023 | 5863 | 97 |
2479056 | 2479056 | 2022-05-06 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2479205 | 2479205 | 2022-05-06 | Chester | South Carolina | 45023 | 10116 | 153 |
2479317 | 2479317 | 2022-05-06 | Chester | Tennessee | 47023 | 5863 | 97 |
2475798 | 2475798 | 2022-05-05 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2475947 | 2475947 | 2022-05-05 | Chester | South Carolina | 45023 | 10116 | 153 |
2476059 | 2476059 | 2022-05-05 | Chester | Tennessee | 47023 | 5863 | 97 |
2472541 | 2472541 | 2022-05-04 | Chester | Pennsylvania | 42029 | 93973 | 1158 |
2472690 | 2472690 | 2022-05-04 | Chester | South Carolina | 45023 | 10116 | 153 |
2472802 | 2472802 | 2022-05-04 | Chester | Tennessee | 47023 | 5863 | 97 |
2469285 | 2469285 | 2022-05-03 | Chester | Pennsylvania | 42029 | 93842 | 1154 |
2469434 | 2469434 | 2022-05-03 | Chester | South Carolina | 45023 | 10116 | 153 |
2469546 | 2469546 | 2022-05-03 | Chester | Tennessee | 47023 | 5857 | 97 |
2466029 | 2466029 | 2022-05-02 | Chester | Pennsylvania | 42029 | 93729 | 1153 |
2466178 | 2466178 | 2022-05-02 | Chester | South Carolina | 45023 | 10100 | 152 |
2466290 | 2466290 | 2022-05-02 | Chester | Tennessee | 47023 | 5857 | 97 |
2462774 | 2462774 | 2022-05-01 | Chester | Pennsylvania | 42029 | 93638 | 1153 |
2462923 | 2462923 | 2022-05-01 | Chester | South Carolina | 45023 | 10100 | 152 |
2463035 | 2463035 | 2022-05-01 | Chester | Tennessee | 47023 | 5857 | 97 |
2459518 | 2459518 | 2022-04-30 | Chester | Pennsylvania | 42029 | 93560 | 1153 |
2459667 | 2459667 | 2022-04-30 | Chester | South Carolina | 45023 | 10100 | 152 |
2459779 | 2459779 | 2022-04-30 | Chester | Tennessee | 47023 | 5857 | 97 |
2456262 | 2456262 | 2022-04-29 | Chester | Pennsylvania | 42029 | 93438 | 1153 |
2456411 | 2456411 | 2022-04-29 | Chester | South Carolina | 45023 | 10100 | 152 |
2456523 | 2456523 | 2022-04-29 | Chester | Tennessee | 47023 | 5857 | 97 |
2453006 | 2453006 | 2022-04-28 | Chester | Pennsylvania | 42029 | 93323 | 1153 |
2453155 | 2453155 | 2022-04-28 | Chester | South Carolina | 45023 | 10100 | 152 |
2453267 | 2453267 | 2022-04-28 | Chester | Tennessee | 47023 | 5857 | 97 |
2449750 | 2449750 | 2022-04-27 | Chester | Pennsylvania | 42029 | 93213 | 1152 |
2449899 | 2449899 | 2022-04-27 | Chester | South Carolina | 45023 | 10093 | 151 |
2450011 | 2450011 | 2022-04-27 | Chester | Tennessee | 47023 | 5857 | 97 |
2446493 | 2446493 | 2022-04-26 | Chester | Pennsylvania | 42029 | 93095 | 1151 |
2446642 | 2446642 | 2022-04-26 | Chester | South Carolina | 45023 | 10093 | 151 |
2446754 | 2446754 | 2022-04-26 | Chester | Tennessee | 47023 | 5848 | 97 |
2443238 | 2443238 | 2022-04-25 | Chester | Pennsylvania | 42029 | 93022 | 1151 |
2443387 | 2443387 | 2022-04-25 | Chester | South Carolina | 45023 | 10093 | 151 |
2443499 | 2443499 | 2022-04-25 | Chester | Tennessee | 47023 | 5848 | 97 |
2439982 | 2439982 | 2022-04-24 | Chester | Pennsylvania | 42029 | 92956 | 1151 |
2440131 | 2440131 | 2022-04-24 | Chester | South Carolina | 45023 | 10093 | 151 |
2440243 | 2440243 | 2022-04-24 | Chester | Tennessee | 47023 | 5848 | 97 |
2436726 | 2436726 | 2022-04-23 | Chester | Pennsylvania | 42029 | 92896 | 1151 |
2436875 | 2436875 | 2022-04-23 | Chester | South Carolina | 45023 | 10093 | 151 |
2436987 | 2436987 | 2022-04-23 | Chester | Tennessee | 47023 | 5848 | 97 |
2433470 | 2433470 | 2022-04-22 | Chester | Pennsylvania | 42029 | 92809 | 1150 |
2433619 | 2433619 | 2022-04-22 | Chester | South Carolina | 45023 | 10093 | 151 |
2433731 | 2433731 | 2022-04-22 | Chester | Tennessee | 47023 | 5848 | 97 |
2430214 | 2430214 | 2022-04-21 | Chester | Pennsylvania | 42029 | 92717 | 1150 |
2430363 | 2430363 | 2022-04-21 | Chester | South Carolina | 45023 | 10093 | 151 |
2430475 | 2430475 | 2022-04-21 | Chester | Tennessee | 47023 | 5848 | 97 |
2426958 | 2426958 | 2022-04-20 | Chester | Pennsylvania | 42029 | 92609 | 1148 |
2427107 | 2427107 | 2022-04-20 | Chester | South Carolina | 45023 | 10093 | 151 |
2427219 | 2427219 | 2022-04-20 | Chester | Tennessee | 47023 | 5848 | 97 |
2423702 | 2423702 | 2022-04-19 | Chester | Pennsylvania | 42029 | 92529 | 1148 |
2423851 | 2423851 | 2022-04-19 | Chester | South Carolina | 45023 | 10093 | 151 |
2423963 | 2423963 | 2022-04-19 | Chester | Tennessee | 47023 | 5842 | 96 |
2420446 | 2420446 | 2022-04-18 | Chester | Pennsylvania | 42029 | 92470 | 1145 |
2420595 | 2420595 | 2022-04-18 | Chester | South Carolina | 45023 | 10089 | 151 |
2420707 | 2420707 | 2022-04-18 | Chester | Tennessee | 47023 | 5842 | 96 |
2417190 | 2417190 | 2022-04-17 | Chester | Pennsylvania | 42029 | 92417 | 1145 |
2417339 | 2417339 | 2022-04-17 | Chester | South Carolina | 45023 | 10089 | 151 |
2417451 | 2417451 | 2022-04-17 | Chester | Tennessee | 47023 | 5842 | 96 |
2413934 | 2413934 | 2022-04-16 | Chester | Pennsylvania | 42029 | 92349 | 1145 |
2414083 | 2414083 | 2022-04-16 | Chester | South Carolina | 45023 | 10089 | 151 |
2414195 | 2414195 | 2022-04-16 | Chester | Tennessee | 47023 | 5842 | 96 |
2410678 | 2410678 | 2022-04-15 | Chester | Pennsylvania | 42029 | 92260 | 1145 |
2410827 | 2410827 | 2022-04-15 | Chester | South Carolina | 45023 | 10089 | 151 |
2410939 | 2410939 | 2022-04-15 | Chester | Tennessee | 47023 | 5842 | 96 |
2407422 | 2407422 | 2022-04-14 | Chester | Pennsylvania | 42029 | 92175 | 1145 |
2407571 | 2407571 | 2022-04-14 | Chester | South Carolina | 45023 | 10089 | 151 |
2407683 | 2407683 | 2022-04-14 | Chester | Tennessee | 47023 | 5842 | 96 |
2404166 | 2404166 | 2022-04-13 | Chester | Pennsylvania | 42029 | 92080 | 1144 |
2404315 | 2404315 | 2022-04-13 | Chester | South Carolina | 45023 | 10089 | 151 |
2404427 | 2404427 | 2022-04-13 | Chester | Tennessee | 47023 | 5842 | 96 |
2400911 | 2400911 | 2022-04-12 | Chester | Pennsylvania | 42029 | 92032 | 1144 |
2401060 | 2401060 | 2022-04-12 | Chester | South Carolina | 45023 | 10089 | 151 |
2401172 | 2401172 | 2022-04-12 | Chester | Tennessee | 47023 | 5840 | 96 |
2397656 | 2397656 | 2022-04-11 | Chester | Pennsylvania | 42029 | 91981 | 1144 |
2397805 | 2397805 | 2022-04-11 | Chester | South Carolina | 45023 | 10090 | 151 |
2397917 | 2397917 | 2022-04-11 | Chester | Tennessee | 47023 | 5840 | 96 |
2394401 | 2394401 | 2022-04-10 | Chester | Pennsylvania | 42029 | 91940 | 1143 |
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);