ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,350 rows where county = "Pickens" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 332 ✖
- 62 90
- 0 74
- 5 68
- 18 61
- 79 61
- 6 60
- 4 56
- 2 51
- 10 51
- 3 46
- 74 42
- 57 36
- 1 35
- 63 33
- 59 32
- 102 31
- 15 29
- 91 29
- 31 28
- 80 27
- 101 26
- 305 26
- 14 24
- 92 24
- 11 23
- 78 22
- 26 21
- 304 21
- 81 19
- 9 18
- 84 17
- 95 17
- 162 17
- 8 16
- 82 16
- 88 16
- 119 16
- 164 15
- 72 14
- 7 13
- 20 13
- 77 13
- 96 13
- 123 13
- 24 12
- 93 12
- 120 12
- 606 12
- 12 11
- 45 11
- 53 11
- 68 11
- 85 11
- 126 11
- 167 11
- 17 10
- 27 10
- 90 10
- 299 10
- 16 9
- 19 9
- 99 9
- 625 9
- 54 8
- 61 8
- 97 8
- 133 8
- 140 8
- 166 8
- 306 8
- 631 8
- 76 7
- 110 7
- 124 7
- 148 7
- 155 7
- 160 7
- 300 7
- 477 7
- 612 7
- 616 7
- 621 7
- 624 7
- 23 6
- 30 6
- 35 6
- 36 6
- 50 6
- 55 6
- 69 6
- 70 6
- 73 6
- 98 6
- 103 6
- 158 6
- 163 6
- 273 6
- 278 6
- 297 6
- 303 6
- 325 6
- 505 6
- 13 5
- 22 5
- 38 5
- 47 5
- 58 5
- 60 5
- 64 5
- 65 5
- 89 5
- 108 5
- 121 5
- 143 5
- 483 5
- 484 5
- 491 5
- 512 5
- 529 5
- 628 5
- 21 4
- 40 4
- 41 4
- 44 4
- 48 4
- 51 4
- 52 4
- 83 4
- 115 4
- 122 4
- 156 4
- 159 4
- 254 4
- 279 4
- 295 4
- 314 4
- 327 4
- 440 4
- 494 4
- 499 4
- 503 4
- 515 4
- 523 4
- 560 4
- 579 4
- 594 4
- 29 3
- 33 3
- 43 3
- 104 3
- 111 3
- 113 3
- 114 3
- 116 3
- 134 3
- 135 3
- 154 3
- 161 3
- 175 3
- 186 3
- 197 3
- 266 3
- 269 3
- 271 3
- 281 3
- 282 3
- 283 3
- 286 3
- 288 3
- 290 3
- 291 3
- 309 3
- 334 3
- 343 3
- 365 3
- 393 3
- 420 3
- 437 3
- 443 3
- 454 3
- 468 3
- 526 3
- 535 3
- 550 3
- 589 3
- 632 3
- 25 2
- 34 2
- 39 2
- 42 2
- 56 2
- 66 2
- 67 2
- 87 2
- 100 2
- 105 2
- 109 2
- 125 2
- 129 2
- 130 2
- 139 2
- 142 2
- 146 2
- 153 2
- 178 2
- 182 2
- 215 2
- 224 2
- 238 2
- 241 2
- 255 2
- 260 2
- 275 2
- 276 2
- 284 2
- 293 2
- 294 2
- 296 2
- 298 2
- 302 2
- 311 2
- 317 2
- 332 2
- 337 2
- 447 2
- 460 2
- 487 2
- 488 2
- 496 2
- 500 2
- 504 2
- 510 2
- 518 2
- 530 2
- 542 2
- 559 2
- 563 2
- 580 2
- 593 2
- 603 2
- 28 1
- 32 1
- 37 1
- 46 1
- 49 1
- 71 1
- 75 1
- 112 1
- 117 1
- 131 1
- 132 1
- 137 1
- 138 1
- 147 1
- 151 1
- 157 1
- 173 1
- 189 1
- 190 1
- 192 1
- 195 1
- 200 1
- 213 1
- 214 1
- 227 1
- 233 1
- 235 1
- 245 1
- 246 1
- 247 1
- 248 1
- 253 1
- 261 1
- 262 1
- 263 1
- 264 1
- 265 1
- 267 1
- 272 1
- 277 1
- 280 1
- 285 1
- 287 1
- 289 1
- 301 1
- 308 1
- 313 1
- 318 1
- 321 1
- 329 1
- 330 1
- 338 1
- 340 1
- 351 1
- 353 1
- 359 1
- 361 1
- 372 1
- 378 1
- 379 1
- 382 1
- 401 1
- 403 1
- 408 1
- 413 1
- 422 1
- 426 1
- 428 1
- 430 1
- 448 1
- 449 1
- 464 1
- 465 1
- 472 1
- 474 1
- 475 1
- 476 1
- 492 1
- 493 1
- 495 1
- 501 1
- 513 1
- 520 1
- 522 1
- 540 1
- 549 1
- 553 1
- 570 1
- 578 1
- 582 1
- 591 1
- 602 1
state 3
- Georgia 785
- South Carolina 785
- Alabama 780
county 1
- Pickens · 2,350 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5375 | 5375 | 2020-03-20 | Pickens | Georgia | 13227 | 2 | 0 |
5893 | 5893 | 2020-03-20 | Pickens | South Carolina | 45077 | 1 | 0 |
6309 | 6309 | 2020-03-21 | Pickens | Georgia | 13227 | 2 | 0 |
6903 | 6903 | 2020-03-21 | Pickens | South Carolina | 45077 | 1 | 0 |
7355 | 7355 | 2020-03-22 | Pickens | Georgia | 13227 | 2 | 0 |
8024 | 8024 | 2020-03-22 | Pickens | South Carolina | 45077 | 1 | 0 |
8507 | 8507 | 2020-03-23 | Pickens | Georgia | 13227 | 3 | 0 |
9238 | 9238 | 2020-03-23 | Pickens | South Carolina | 45077 | 1 | 0 |
9765 | 9765 | 2020-03-24 | Pickens | Georgia | 13227 | 4 | 0 |
10564 | 10564 | 2020-03-24 | Pickens | South Carolina | 45077 | 1 | 0 |
10866 | 10866 | 2020-03-25 | Pickens | Alabama | 1107 | 1 | 0 |
11145 | 11145 | 2020-03-25 | Pickens | Georgia | 13227 | 4 | 0 |
12036 | 12036 | 2020-03-25 | Pickens | South Carolina | 45077 | 6 | 0 |
12405 | 12405 | 2020-03-26 | Pickens | Alabama | 1107 | 1 | 0 |
12697 | 12697 | 2020-03-26 | Pickens | Georgia | 13227 | 4 | 0 |
13658 | 13658 | 2020-03-26 | Pickens | South Carolina | 45077 | 6 | 0 |
14066 | 14066 | 2020-03-27 | Pickens | Alabama | 1107 | 1 | 0 |
14371 | 14371 | 2020-03-27 | Pickens | Georgia | 13227 | 4 | 1 |
15405 | 15405 | 2020-03-27 | Pickens | South Carolina | 45077 | 7 | 0 |
15845 | 15845 | 2020-03-28 | Pickens | Alabama | 1107 | 1 | 0 |
16159 | 16159 | 2020-03-28 | Pickens | Georgia | 13227 | 5 | 1 |
17260 | 17260 | 2020-03-28 | Pickens | South Carolina | 45077 | 10 | 0 |
17729 | 17729 | 2020-03-29 | Pickens | Alabama | 1107 | 2 | 0 |
18056 | 18056 | 2020-03-29 | Pickens | Georgia | 13227 | 5 | 1 |
19200 | 19200 | 2020-03-29 | Pickens | South Carolina | 45077 | 11 | 0 |
19701 | 19701 | 2020-03-30 | Pickens | Alabama | 1107 | 3 | 0 |
20049 | 20049 | 2020-03-30 | Pickens | Georgia | 13227 | 6 | 1 |
21252 | 21252 | 2020-03-30 | Pickens | South Carolina | 45077 | 13 | 0 |
21773 | 21773 | 2020-03-31 | Pickens | Alabama | 1107 | 4 | 0 |
22131 | 22131 | 2020-03-31 | Pickens | Georgia | 13227 | 7 | 1 |
23390 | 23390 | 2020-03-31 | Pickens | South Carolina | 45077 | 14 | 0 |
23929 | 23929 | 2020-04-01 | Pickens | Alabama | 1107 | 4 | 0 |
24295 | 24295 | 2020-04-01 | Pickens | Georgia | 13227 | 7 | 1 |
25588 | 25588 | 2020-04-01 | Pickens | South Carolina | 45077 | 14 | 0 |
26151 | 26151 | 2020-04-02 | Pickens | Alabama | 1107 | 9 | 0 |
26526 | 26526 | 2020-04-02 | Pickens | Georgia | 13227 | 9 | 1 |
27864 | 27864 | 2020-04-02 | Pickens | South Carolina | 45077 | 15 | 0 |
28448 | 28448 | 2020-04-03 | Pickens | Alabama | 1107 | 11 | 0 |
28831 | 28831 | 2020-04-03 | Pickens | Georgia | 13227 | 9 | 1 |
30199 | 30199 | 2020-04-03 | Pickens | South Carolina | 45077 | 17 | 0 |
30805 | 30805 | 2020-04-04 | Pickens | Alabama | 1107 | 12 | 0 |
31191 | 31191 | 2020-04-04 | Pickens | Georgia | 13227 | 9 | 1 |
32590 | 32590 | 2020-04-04 | Pickens | South Carolina | 45077 | 17 | 0 |
33209 | 33209 | 2020-04-05 | Pickens | Alabama | 1107 | 12 | 0 |
33598 | 33598 | 2020-04-05 | Pickens | Georgia | 13227 | 9 | 1 |
35026 | 35026 | 2020-04-05 | Pickens | South Carolina | 45077 | 18 | 0 |
35648 | 35648 | 2020-04-06 | Pickens | Alabama | 1107 | 13 | 0 |
36048 | 36048 | 2020-04-06 | Pickens | Georgia | 13227 | 9 | 2 |
37501 | 37501 | 2020-04-06 | Pickens | South Carolina | 45077 | 20 | 0 |
38136 | 38136 | 2020-04-07 | Pickens | Alabama | 1107 | 14 | 0 |
38541 | 38541 | 2020-04-07 | Pickens | Georgia | 13227 | 10 | 2 |
40024 | 40024 | 2020-04-07 | Pickens | South Carolina | 45077 | 21 | 0 |
40678 | 40678 | 2020-04-08 | Pickens | Alabama | 1107 | 15 | 0 |
41085 | 41085 | 2020-04-08 | Pickens | Georgia | 13227 | 10 | 2 |
42584 | 42584 | 2020-04-08 | Pickens | South Carolina | 45077 | 21 | 0 |
43252 | 43252 | 2020-04-09 | Pickens | Alabama | 1107 | 19 | 0 |
43659 | 43659 | 2020-04-09 | Pickens | Georgia | 13227 | 10 | 2 |
45170 | 45170 | 2020-04-09 | Pickens | South Carolina | 45077 | 22 | 0 |
45850 | 45850 | 2020-04-10 | Pickens | Alabama | 1107 | 19 | 0 |
46261 | 46261 | 2020-04-10 | Pickens | Georgia | 13227 | 10 | 2 |
47787 | 47787 | 2020-04-10 | Pickens | South Carolina | 45077 | 27 | 0 |
48479 | 48479 | 2020-04-11 | Pickens | Alabama | 1107 | 21 | 0 |
48892 | 48892 | 2020-04-11 | Pickens | Georgia | 13227 | 11 | 2 |
50444 | 50444 | 2020-04-11 | Pickens | South Carolina | 45077 | 28 | 0 |
51141 | 51141 | 2020-04-12 | Pickens | Alabama | 1107 | 22 | 0 |
51554 | 51554 | 2020-04-12 | Pickens | Georgia | 13227 | 11 | 2 |
53117 | 53117 | 2020-04-12 | Pickens | South Carolina | 45077 | 28 | 0 |
53819 | 53819 | 2020-04-13 | Pickens | Alabama | 1107 | 23 | 0 |
54234 | 54234 | 2020-04-13 | Pickens | Georgia | 13227 | 11 | 2 |
55802 | 55802 | 2020-04-13 | Pickens | South Carolina | 45077 | 31 | 0 |
56511 | 56511 | 2020-04-14 | Pickens | Alabama | 1107 | 24 | 0 |
56926 | 56926 | 2020-04-14 | Pickens | Georgia | 13227 | 13 | 2 |
58505 | 58505 | 2020-04-14 | Pickens | South Carolina | 45077 | 34 | 0 |
59219 | 59219 | 2020-04-15 | Pickens | Alabama | 1107 | 30 | 0 |
59633 | 59633 | 2020-04-15 | Pickens | Georgia | 13227 | 14 | 2 |
61220 | 61220 | 2020-04-15 | Pickens | South Carolina | 45077 | 34 | 0 |
61937 | 61937 | 2020-04-16 | Pickens | Alabama | 1107 | 30 | 0 |
62353 | 62353 | 2020-04-16 | Pickens | Georgia | 13227 | 15 | 2 |
63946 | 63946 | 2020-04-16 | Pickens | South Carolina | 45077 | 37 | 0 |
64670 | 64670 | 2020-04-17 | Pickens | Alabama | 1107 | 32 | 0 |
65086 | 65086 | 2020-04-17 | Pickens | Georgia | 13227 | 16 | 2 |
66692 | 66692 | 2020-04-17 | Pickens | South Carolina | 45077 | 36 | 0 |
67418 | 67418 | 2020-04-18 | Pickens | Alabama | 1107 | 33 | 0 |
67834 | 67834 | 2020-04-18 | Pickens | Georgia | 13227 | 18 | 2 |
69450 | 69450 | 2020-04-18 | Pickens | South Carolina | 45077 | 38 | 0 |
70180 | 70180 | 2020-04-19 | Pickens | Alabama | 1107 | 38 | 0 |
70596 | 70596 | 2020-04-19 | Pickens | Georgia | 13227 | 18 | 2 |
72217 | 72217 | 2020-04-19 | Pickens | South Carolina | 45077 | 39 | 0 |
72949 | 72949 | 2020-04-20 | Pickens | Alabama | 1107 | 40 | 0 |
73365 | 73365 | 2020-04-20 | Pickens | Georgia | 13227 | 18 | 2 |
74992 | 74992 | 2020-04-20 | Pickens | South Carolina | 45077 | 38 | 0 |
75725 | 75725 | 2020-04-21 | Pickens | Alabama | 1107 | 42 | 1 |
76141 | 76141 | 2020-04-21 | Pickens | Georgia | 13227 | 18 | 2 |
77774 | 77774 | 2020-04-21 | Pickens | South Carolina | 45077 | 41 | 0 |
78508 | 78508 | 2020-04-22 | Pickens | Alabama | 1107 | 44 | 1 |
78925 | 78925 | 2020-04-22 | Pickens | Georgia | 13227 | 18 | 2 |
80564 | 80564 | 2020-04-22 | Pickens | South Carolina | 45077 | 41 | 0 |
81301 | 81301 | 2020-04-23 | Pickens | Alabama | 1107 | 44 | 1 |
81718 | 81718 | 2020-04-23 | Pickens | Georgia | 13227 | 19 | 2 |
83363 | 83363 | 2020-04-23 | Pickens | South Carolina | 45077 | 44 | 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);