ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 53031 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 368 ✖
- 28 29
- 71 21
- 30 16
- 31 14
- 50 14
- 338 13
- 70 12
- 1 9
- 54 9
- 29 8
- 41 7
- 337 7
- 412 7
- 414 7
- 38 6
- 69 6
- 1149 6
- 4 5
- 33 5
- 75 5
- 81 5
- 345 5
- 411 5
- 416 5
- 1217 5
- 2788 5
- 2831 5
- 2959 5
- 3124 5
- 32 4
- 51 4
- 325 4
- 329 4
- 333 4
- 385 4
- 450 4
- 470 4
- 733 4
- 1021 4
- 1353 4
- 1447 4
- 1949 4
- 3010 4
- 14 3
- 27 3
- 76 3
- 80 3
- 86 3
- 87 3
- 88 3
- 204 3
- 220 3
- 273 3
- 281 3
- 331 3
- 364 3
- 439 3
- 459 3
- 477 3
- 504 3
- 527 3
- 563 3
- 624 3
- 660 3
- 824 3
- 873 3
- 927 3
- 971 3
- 1003 3
- 1061 3
- 1094 3
- 1133 3
- 1190 3
- 1260 3
- 1294 3
- 1323 3
- 1666 3
- 2191 3
- 2452 3
- 2621 3
- 2745 3
- 2870 3
- 2911 3
- 2921 3
- 2934 3
- 2947 3
- 2992 3
- 3022 3
- 3074 3
- 3 2
- 11 2
- 19 2
- 36 2
- 37 2
- 53 2
- 56 2
- 59 2
- 72 2
- 89 2
- 90 2
- 91 2
- 94 2
- 139 2
- 152 2
- 164 2
- 176 2
- 180 2
- 198 2
- 211 2
- 214 2
- 238 2
- 254 2
- 267 2
- 292 2
- 309 2
- 317 2
- 335 2
- 343 2
- 348 2
- 349 2
- 351 2
- 353 2
- 360 2
- 371 2
- 380 2
- 388 2
- 395 2
- 403 2
- 419 2
- 426 2
- 428 2
- 437 2
- 447 2
- 448 2
- 449 2
- 455 2
- 1012 2
- 1240 2
- 2291 2
- 2385 2
- 2542 2
- 2587 2
- 2662 2
- 2683 2
- 2781 2
- 2793 2
- 2854 2
- 2863 2
- 2877 2
- 2897 2
- 2912 2
- 2914 2
- 2917 2
- 2925 2
- 2939 2
- 2944 2
- 2949 2
- 2953 2
- 2977 2
- 3047 2
- 3060 2
- 3089 2
- 3159 2
- 3180 2
- 6 1
- 7 1
- 8 1
- 10 1
- 13 1
- 17 1
- 20 1
- 22 1
- 35 1
- 39 1
- 43 1
- 44 1
- 57 1
- 61 1
- 62 1
- 63 1
- 65 1
- 66 1
- 67 1
- 74 1
- 79 1
- 82 1
- 84 1
- 92 1
- 93 1
- 103 1
- 106 1
- 112 1
- 114 1
- 115 1
- 122 1
- 123 1
- 128 1
- 134 1
- 146 1
- 149 1
- 159 1
- 161 1
- 167 1
- 169 1
- 170 1
- 171 1
- 186 1
- 188 1
- 191 1
- 193 1
- 195 1
- 196 1
- 201 1
- 205 1
- 207 1
- 209 1
- 216 1
- 218 1
- 219 1
- 229 1
- 233 1
- 246 1
- 252 1
- 256 1
- 258 1
- 259 1
- 261 1
- 276 1
- 277 1
- 279 1
- 284 1
- 286 1
- 290 1
- 291 1
- 308 1
- 312 1
- 316 1
- 328 1
- 339 1
- 342 1
- 344 1
- 346 1
- 347 1
- 356 1
- 357 1
- 359 1
- 362 1
- 363 1
- 373 1
- 378 1
- 381 1
- 390 1
- 396 1
- 397 1
- 398 1
- 400 1
- 402 1
- 405 1
- 406 1
- 407 1
- 415 1
- 420 1
- 432 1
- 436 1
- 438 1
- 441 1
- 443 1
- 444 1
- 445 1
- 454 1
- 462 1
- 465 1
- 468 1
- 469 1
- 473 1
- 474 1
- 478 1
- 490 1
- 495 1
- 496 1
- 501 1
- 510 1
- 518 1
- 521 1
- 524 1
- 540 1
- 541 1
- 549 1
- 553 1
- 579 1
- 602 1
- 609 1
- 617 1
- 637 1
- 640 1
- 645 1
- 651 1
- 686 1
- 697 1
- 708 1
- 723 1
- 787 1
- 799 1
- 811 1
- 844 1
- 852 1
- 861 1
- 867 1
- 889 1
- 903 1
- 915 1
- 925 1
- 945 1
- 956 1
- 958 1
- 968 1
- 986 1
- 989 1
- 992 1
- 997 1
- 1015 1
- 1016 1
- 1037 1
- 1041 1
- 1046 1
- 1080 1
- 1081 1
- 1085 1
- 1091 1
- 1108 1
- 1111 1
- 1117 1
- 1120 1
- 1146 1
- 1160 1
- 1168 1
- 1172 1
- 1185 1
- 1211 1
- 1214 1
- 1236 1
- 1250 1
- 1263 1
- 1276 1
- 1281 1
- 1285 1
- 1304 1
- 1309 1
- 1314 1
- 1318 1
- 1332 1
- 1334 1
- 1344 1
- 1410 1
- 1413 1
- 1431 1
- 1522 1
- 1544 1
- 1567 1
- 1608 1
- 1764 1
- 1793 1
- 1847 1
- 1915 1
- 2046 1
- 2080 1
- 2128 1
- 3198 1
state 1
- Washington 799
fips 1
- 53031 · 799 ✖
county 1
- Jefferson 799
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
649 | 649 | 2020-03-06 | Jefferson | Washington | 53031 | 1 | 0 |
743 | 743 | 2020-03-07 | Jefferson | Washington | 53031 | 1 | 0 |
855 | 855 | 2020-03-08 | Jefferson | Washington | 53031 | 1 | 0 |
986 | 986 | 2020-03-09 | Jefferson | Washington | 53031 | 1 | 0 |
1149 | 1149 | 2020-03-10 | Jefferson | Washington | 53031 | 1 | 0 |
1349 | 1349 | 2020-03-11 | Jefferson | Washington | 53031 | 1 | 0 |
1603 | 1603 | 2020-03-12 | Jefferson | Washington | 53031 | 1 | 0 |
1914 | 1914 | 2020-03-13 | Jefferson | Washington | 53031 | 1 | 0 |
2287 | 2287 | 2020-03-14 | Jefferson | Washington | 53031 | 1 | 0 |
2714 | 2714 | 2020-03-15 | Jefferson | Washington | 53031 | 3 | 0 |
3188 | 3188 | 2020-03-16 | Jefferson | Washington | 53031 | 3 | 0 |
3729 | 3729 | 2020-03-17 | Jefferson | Washington | 53031 | 4 | 0 |
4364 | 4364 | 2020-03-18 | Jefferson | Washington | 53031 | 4 | 0 |
5121 | 5121 | 2020-03-19 | Jefferson | Washington | 53031 | 4 | 0 |
6023 | 6023 | 2020-03-20 | Jefferson | Washington | 53031 | 4 | 0 |
7054 | 7054 | 2020-03-21 | Jefferson | Washington | 53031 | 4 | 0 |
8191 | 8191 | 2020-03-22 | Jefferson | Washington | 53031 | 6 | 0 |
9416 | 9416 | 2020-03-23 | Jefferson | Washington | 53031 | 7 | 0 |
10765 | 10765 | 2020-03-24 | Jefferson | Washington | 53031 | 8 | 0 |
12288 | 12288 | 2020-03-25 | Jefferson | Washington | 53031 | 10 | 0 |
13938 | 13938 | 2020-03-26 | Jefferson | Washington | 53031 | 11 | 0 |
15706 | 15706 | 2020-03-27 | Jefferson | Washington | 53031 | 11 | 0 |
17586 | 17586 | 2020-03-28 | Jefferson | Washington | 53031 | 13 | 0 |
19551 | 19551 | 2020-03-29 | Jefferson | Washington | 53031 | 14 | 0 |
21618 | 21618 | 2020-03-30 | Jefferson | Washington | 53031 | 14 | 0 |
23767 | 23767 | 2020-03-31 | Jefferson | Washington | 53031 | 14 | 0 |
25985 | 25985 | 2020-04-01 | Jefferson | Washington | 53031 | 17 | 0 |
28275 | 28275 | 2020-04-02 | Jefferson | Washington | 53031 | 19 | 0 |
30628 | 30628 | 2020-04-03 | Jefferson | Washington | 53031 | 19 | 0 |
33028 | 33028 | 2020-04-04 | Jefferson | Washington | 53031 | 20 | 0 |
35466 | 35466 | 2020-04-05 | Jefferson | Washington | 53031 | 22 | 0 |
37950 | 37950 | 2020-04-06 | Jefferson | Washington | 53031 | 27 | 0 |
40485 | 40485 | 2020-04-07 | Jefferson | Washington | 53031 | 27 | 0 |
43054 | 43054 | 2020-04-08 | Jefferson | Washington | 53031 | 27 | 0 |
45650 | 45650 | 2020-04-09 | Jefferson | Washington | 53031 | 28 | 0 |
48277 | 48277 | 2020-04-10 | Jefferson | Washington | 53031 | 28 | 0 |
50935 | 50935 | 2020-04-11 | Jefferson | Washington | 53031 | 28 | 0 |
53610 | 53610 | 2020-04-12 | Jefferson | Washington | 53031 | 28 | 0 |
56300 | 56300 | 2020-04-13 | Jefferson | Washington | 53031 | 28 | 0 |
59006 | 59006 | 2020-04-14 | Jefferson | Washington | 53031 | 28 | 0 |
61725 | 61725 | 2020-04-15 | Jefferson | Washington | 53031 | 28 | 0 |
64458 | 64458 | 2020-04-16 | Jefferson | Washington | 53031 | 28 | 0 |
67206 | 67206 | 2020-04-17 | Jefferson | Washington | 53031 | 28 | 0 |
69968 | 69968 | 2020-04-18 | Jefferson | Washington | 53031 | 29 | 0 |
72738 | 72738 | 2020-04-19 | Jefferson | Washington | 53031 | 28 | 0 |
75514 | 75514 | 2020-04-20 | Jefferson | Washington | 53031 | 28 | 0 |
78297 | 78297 | 2020-04-21 | Jefferson | Washington | 53031 | 28 | 0 |
81090 | 81090 | 2020-04-22 | Jefferson | Washington | 53031 | 28 | 0 |
83891 | 83891 | 2020-04-23 | Jefferson | Washington | 53031 | 28 | 0 |
86698 | 86698 | 2020-04-24 | Jefferson | Washington | 53031 | 28 | 0 |
89513 | 89513 | 2020-04-25 | Jefferson | Washington | 53031 | 28 | 0 |
92330 | 92330 | 2020-04-26 | Jefferson | Washington | 53031 | 28 | 0 |
95159 | 95159 | 2020-04-27 | Jefferson | Washington | 53031 | 28 | 0 |
98004 | 98004 | 2020-04-28 | Jefferson | Washington | 53031 | 28 | 0 |
100854 | 100854 | 2020-04-29 | Jefferson | Washington | 53031 | 28 | 0 |
103709 | 103709 | 2020-04-30 | Jefferson | Washington | 53031 | 28 | 0 |
106573 | 106573 | 2020-05-01 | Jefferson | Washington | 53031 | 28 | 0 |
109442 | 109442 | 2020-05-02 | Jefferson | Washington | 53031 | 28 | 0 |
112316 | 112316 | 2020-05-03 | Jefferson | Washington | 53031 | 28 | 0 |
115199 | 115199 | 2020-05-04 | Jefferson | Washington | 53031 | 28 | 0 |
118158 | 118158 | 2020-05-05 | Jefferson | Washington | 53031 | 28 | 0 |
121122 | 121122 | 2020-05-06 | Jefferson | Washington | 53031 | 28 | 0 |
124102 | 124102 | 2020-05-07 | Jefferson | Washington | 53031 | 28 | 0 |
127087 | 127087 | 2020-05-08 | Jefferson | Washington | 53031 | 28 | 0 |
130077 | 130077 | 2020-05-09 | Jefferson | Washington | 53031 | 29 | 0 |
133067 | 133067 | 2020-05-10 | Jefferson | Washington | 53031 | 29 | 0 |
136057 | 136057 | 2020-05-11 | Jefferson | Washington | 53031 | 29 | 0 |
139048 | 139048 | 2020-05-12 | Jefferson | Washington | 53031 | 29 | 0 |
142044 | 142044 | 2020-05-13 | Jefferson | Washington | 53031 | 29 | 0 |
145041 | 145041 | 2020-05-14 | Jefferson | Washington | 53031 | 29 | 0 |
148044 | 148044 | 2020-05-15 | Jefferson | Washington | 53031 | 29 | 0 |
151053 | 151053 | 2020-05-16 | Jefferson | Washington | 53031 | 30 | 0 |
154064 | 154064 | 2020-05-17 | Jefferson | Washington | 53031 | 30 | 0 |
157081 | 157081 | 2020-05-18 | Jefferson | Washington | 53031 | 30 | 0 |
160105 | 160105 | 2020-05-19 | Jefferson | Washington | 53031 | 30 | 0 |
163133 | 163133 | 2020-05-20 | Jefferson | Washington | 53031 | 30 | 0 |
166162 | 166162 | 2020-05-21 | Jefferson | Washington | 53031 | 30 | 0 |
169198 | 169198 | 2020-05-22 | Jefferson | Washington | 53031 | 30 | 0 |
172239 | 172239 | 2020-05-23 | Jefferson | Washington | 53031 | 30 | 0 |
175282 | 175282 | 2020-05-24 | Jefferson | Washington | 53031 | 30 | 0 |
178327 | 178327 | 2020-05-25 | Jefferson | Washington | 53031 | 30 | 0 |
181371 | 181371 | 2020-05-26 | Jefferson | Washington | 53031 | 30 | 0 |
184422 | 184422 | 2020-05-27 | Jefferson | Washington | 53031 | 30 | 0 |
187479 | 187479 | 2020-05-28 | Jefferson | Washington | 53031 | 30 | 0 |
190543 | 190543 | 2020-05-29 | Jefferson | Washington | 53031 | 30 | 0 |
193609 | 193609 | 2020-05-30 | Jefferson | Washington | 53031 | 30 | 0 |
196679 | 196679 | 2020-05-31 | Jefferson | Washington | 53031 | 30 | 0 |
199752 | 199752 | 2020-06-01 | Jefferson | Washington | 53031 | 31 | 0 |
202828 | 202828 | 2020-06-02 | Jefferson | Washington | 53031 | 31 | 0 |
205907 | 205907 | 2020-06-03 | Jefferson | Washington | 53031 | 31 | 0 |
208989 | 208989 | 2020-06-04 | Jefferson | Washington | 53031 | 31 | 0 |
212074 | 212074 | 2020-06-05 | Jefferson | Washington | 53031 | 31 | 0 |
215161 | 215161 | 2020-06-06 | Jefferson | Washington | 53031 | 31 | 0 |
218251 | 218251 | 2020-06-07 | Jefferson | Washington | 53031 | 31 | 0 |
221343 | 221343 | 2020-06-08 | Jefferson | Washington | 53031 | 31 | 0 |
224439 | 224439 | 2020-06-09 | Jefferson | Washington | 53031 | 31 | 0 |
227539 | 227539 | 2020-06-10 | Jefferson | Washington | 53031 | 31 | 0 |
230643 | 230643 | 2020-06-11 | Jefferson | Washington | 53031 | 31 | 0 |
233748 | 233748 | 2020-06-12 | Jefferson | Washington | 53031 | 31 | 0 |
236855 | 236855 | 2020-06-13 | Jefferson | Washington | 53031 | 31 | 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);