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 rowid
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 |
---|---|---|---|---|---|---|---|
1849 | 1849 | 2020-03-13 | Chester | Pennsylvania | 42029 | 1 | 0 |
2211 | 2211 | 2020-03-14 | Chester | Pennsylvania | 42029 | 2 | 0 |
2631 | 2631 | 2020-03-15 | Chester | Pennsylvania | 42029 | 4 | 0 |
3096 | 3096 | 2020-03-16 | Chester | Pennsylvania | 42029 | 4 | 0 |
3626 | 3626 | 2020-03-17 | Chester | Pennsylvania | 42029 | 4 | 0 |
4243 | 4243 | 2020-03-18 | Chester | Pennsylvania | 42029 | 9 | 0 |
4982 | 4982 | 2020-03-19 | Chester | Pennsylvania | 42029 | 10 | 0 |
5852 | 5852 | 2020-03-20 | Chester | Pennsylvania | 42029 | 17 | 0 |
6855 | 6855 | 2020-03-21 | Chester | Pennsylvania | 42029 | 19 | 0 |
7970 | 7970 | 2020-03-22 | Chester | Pennsylvania | 42029 | 23 | 0 |
8043 | 8043 | 2020-03-22 | Chester | Tennessee | 47023 | 1 | 0 |
9181 | 9181 | 2020-03-23 | Chester | Pennsylvania | 42029 | 40 | 0 |
9216 | 9216 | 2020-03-23 | Chester | South Carolina | 45023 | 1 | 0 |
9261 | 9261 | 2020-03-23 | Chester | Tennessee | 47023 | 1 | 0 |
10503 | 10503 | 2020-03-24 | Chester | Pennsylvania | 42029 | 40 | 0 |
10541 | 10541 | 2020-03-24 | Chester | South Carolina | 45023 | 1 | 0 |
10588 | 10588 | 2020-03-24 | Chester | Tennessee | 47023 | 1 | 0 |
11965 | 11965 | 2020-03-25 | Chester | Pennsylvania | 42029 | 54 | 0 |
12012 | 12012 | 2020-03-25 | Chester | South Carolina | 45023 | 1 | 0 |
12065 | 12065 | 2020-03-25 | Chester | Tennessee | 47023 | 1 | 0 |
13584 | 13584 | 2020-03-26 | Chester | Pennsylvania | 42029 | 84 | 0 |
13634 | 13634 | 2020-03-26 | Chester | South Carolina | 45023 | 1 | 0 |
13689 | 13689 | 2020-03-26 | Chester | Tennessee | 47023 | 2 | 0 |
15330 | 15330 | 2020-03-27 | Chester | Pennsylvania | 42029 | 107 | 0 |
15381 | 15381 | 2020-03-27 | Chester | South Carolina | 45023 | 1 | 0 |
15441 | 15441 | 2020-03-27 | Chester | Tennessee | 47023 | 2 | 0 |
17178 | 17178 | 2020-03-28 | Chester | Pennsylvania | 42029 | 116 | 0 |
17235 | 17235 | 2020-03-28 | Chester | South Carolina | 45023 | 2 | 0 |
17302 | 17302 | 2020-03-28 | Chester | Tennessee | 47023 | 2 | 0 |
19116 | 19116 | 2020-03-29 | Chester | Pennsylvania | 42029 | 137 | 0 |
19175 | 19175 | 2020-03-29 | Chester | South Carolina | 45023 | 2 | 0 |
19247 | 19247 | 2020-03-29 | Chester | Tennessee | 47023 | 2 | 0 |
21166 | 21166 | 2020-03-30 | Chester | Pennsylvania | 42029 | 146 | 0 |
21227 | 21227 | 2020-03-30 | Chester | South Carolina | 45023 | 2 | 0 |
21300 | 21300 | 2020-03-30 | Chester | Tennessee | 47023 | 3 | 0 |
23302 | 23302 | 2020-03-31 | Chester | Pennsylvania | 42029 | 159 | 1 |
23365 | 23365 | 2020-03-31 | Chester | South Carolina | 45023 | 2 | 0 |
23438 | 23438 | 2020-03-31 | Chester | Tennessee | 47023 | 3 | 0 |
25500 | 25500 | 2020-04-01 | Chester | Pennsylvania | 42029 | 183 | 1 |
25563 | 25563 | 2020-04-01 | Chester | South Carolina | 45023 | 3 | 0 |
25636 | 25636 | 2020-04-01 | Chester | Tennessee | 47023 | 3 | 0 |
27772 | 27772 | 2020-04-02 | Chester | Pennsylvania | 42029 | 210 | 2 |
27837 | 27837 | 2020-04-02 | Chester | South Carolina | 45023 | 6 | 0 |
27914 | 27914 | 2020-04-02 | Chester | Tennessee | 47023 | 3 | 0 |
30105 | 30105 | 2020-04-03 | Chester | Pennsylvania | 42029 | 226 | 2 |
30172 | 30172 | 2020-04-03 | Chester | South Carolina | 45023 | 7 | 0 |
30249 | 30249 | 2020-04-03 | Chester | Tennessee | 47023 | 5 | 0 |
32495 | 32495 | 2020-04-04 | Chester | Pennsylvania | 42029 | 250 | 2 |
32563 | 32563 | 2020-04-04 | Chester | South Carolina | 45023 | 12 | 0 |
32640 | 32640 | 2020-04-04 | Chester | Tennessee | 47023 | 6 | 0 |
34930 | 34930 | 2020-04-05 | Chester | Pennsylvania | 42029 | 269 | 2 |
34999 | 34999 | 2020-04-05 | Chester | South Carolina | 45023 | 12 | 0 |
35076 | 35076 | 2020-04-05 | Chester | Tennessee | 47023 | 6 | 0 |
37405 | 37405 | 2020-04-06 | Chester | Pennsylvania | 42029 | 307 | 3 |
37474 | 37474 | 2020-04-06 | Chester | South Carolina | 45023 | 14 | 0 |
37552 | 37552 | 2020-04-06 | Chester | Tennessee | 47023 | 6 | 0 |
39926 | 39926 | 2020-04-07 | Chester | Pennsylvania | 42029 | 335 | 6 |
39997 | 39997 | 2020-04-07 | Chester | South Carolina | 45023 | 15 | 0 |
40075 | 40075 | 2020-04-07 | Chester | Tennessee | 47023 | 7 | 0 |
42486 | 42486 | 2020-04-08 | Chester | Pennsylvania | 42029 | 373 | 6 |
42557 | 42557 | 2020-04-08 | Chester | South Carolina | 45023 | 16 | 0 |
42636 | 42636 | 2020-04-08 | Chester | Tennessee | 47023 | 7 | 0 |
45072 | 45072 | 2020-04-09 | Chester | Pennsylvania | 42029 | 425 | 7 |
45143 | 45143 | 2020-04-09 | Chester | South Carolina | 45023 | 16 | 0 |
45223 | 45223 | 2020-04-09 | Chester | Tennessee | 47023 | 7 | 0 |
47689 | 47689 | 2020-04-10 | Chester | Pennsylvania | 42029 | 485 | 9 |
47760 | 47760 | 2020-04-10 | Chester | South Carolina | 45023 | 17 | 0 |
47841 | 47841 | 2020-04-10 | Chester | Tennessee | 47023 | 7 | 0 |
50346 | 50346 | 2020-04-11 | Chester | Pennsylvania | 42029 | 532 | 15 |
50417 | 50417 | 2020-04-11 | Chester | South Carolina | 45023 | 18 | 0 |
50499 | 50499 | 2020-04-11 | Chester | Tennessee | 47023 | 6 | 0 |
53019 | 53019 | 2020-04-12 | Chester | Pennsylvania | 42029 | 562 | 17 |
53090 | 53090 | 2020-04-12 | Chester | South Carolina | 45023 | 19 | 0 |
53174 | 53174 | 2020-04-12 | Chester | Tennessee | 47023 | 6 | 0 |
55704 | 55704 | 2020-04-13 | Chester | Pennsylvania | 42029 | 593 | 17 |
55775 | 55775 | 2020-04-13 | Chester | South Carolina | 45023 | 20 | 0 |
55860 | 55860 | 2020-04-13 | Chester | Tennessee | 47023 | 6 | 0 |
58407 | 58407 | 2020-04-14 | Chester | Pennsylvania | 42029 | 636 | 20 |
58478 | 58478 | 2020-04-14 | Chester | South Carolina | 45023 | 20 | 0 |
58563 | 58563 | 2020-04-14 | Chester | Tennessee | 47023 | 5 | 0 |
61122 | 61122 | 2020-04-15 | Chester | Pennsylvania | 42029 | 675 | 25 |
61193 | 61193 | 2020-04-15 | Chester | South Carolina | 45023 | 22 | 0 |
61278 | 61278 | 2020-04-15 | Chester | Tennessee | 47023 | 6 | 0 |
63848 | 63848 | 2020-04-16 | Chester | Pennsylvania | 42029 | 722 | 28 |
63919 | 63919 | 2020-04-16 | Chester | South Carolina | 45023 | 22 | 0 |
64005 | 64005 | 2020-04-16 | Chester | Tennessee | 47023 | 6 | 0 |
66594 | 66594 | 2020-04-17 | Chester | Pennsylvania | 42029 | 773 | 30 |
66665 | 66665 | 2020-04-17 | Chester | South Carolina | 45023 | 23 | 0 |
66751 | 66751 | 2020-04-17 | Chester | Tennessee | 47023 | 6 | 0 |
69352 | 69352 | 2020-04-18 | Chester | Pennsylvania | 42029 | 831 | 36 |
69423 | 69423 | 2020-04-18 | Chester | South Carolina | 45023 | 23 | 0 |
69509 | 69509 | 2020-04-18 | Chester | Tennessee | 47023 | 6 | 0 |
72119 | 72119 | 2020-04-19 | Chester | Pennsylvania | 42029 | 877 | 42 |
72190 | 72190 | 2020-04-19 | Chester | South Carolina | 45023 | 24 | 0 |
72276 | 72276 | 2020-04-19 | Chester | Tennessee | 47023 | 8 | 0 |
74894 | 74894 | 2020-04-20 | Chester | Pennsylvania | 42029 | 915 | 44 |
74965 | 74965 | 2020-04-20 | Chester | South Carolina | 45023 | 25 | 0 |
75051 | 75051 | 2020-04-20 | Chester | Tennessee | 47023 | 8 | 0 |
77676 | 77676 | 2020-04-21 | Chester | Pennsylvania | 42029 | 943 | 65 |
77747 | 77747 | 2020-04-21 | Chester | South Carolina | 45023 | 25 | 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);